<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    How to Generating an Oracle Trace File --MRO software..wmc

    Overview : You can generate a log of Oracle statements being executed on the server. This trace file is very useful in diagnosing performance problems. Oracle's utility, tkprof, can be used to sort commands. You can also request the execution plan of the statements.
    Procedure

    1. Enable timed statistics
    Modify the initxxx.ora file for your database instance to include timed_statistics with the following parameter. You must shutdown and restart the database for this parameter to take effect.
    timed_statistics=true
    2. Trace all sessions
    To trace all sessions, set SQL_TRACE in the initxxx.ora file to TRUE. If you are trying to diagnose a specific error then open the .trc file with a text editor and search for err='Oracle error number without the leading zeros'
    3. Trace a specific session
    MAXIMO 4.x

    Start the MAXIMO application you wish to trace.

    Determine the process id of the workstation you want to trace.

    select sid, serial# from v$session where username='maximoschema' and machine='hostname';

    Start the trace:

    exec dbms_system.set_sql_trace_in_session (sid, serial#, TRUE);
    note: the procedure can be run as sys. You may need to grant execute to system on dbms_system.

    Run the MAXIMO process you wish to trace.

    Stop the trace:

    exec dbms_system.set_sql_trace_in_session (sid, serial#, FALSE);


    MAXIMO 5.x

    You cannot trace a specific session in MAXIMO 5.x.



    4. Generate the results using tkprof

    Format the results of the trace file with ORACLE's TKPROF utility. You will want to sort either by total CPU time SORT=(PRSCPU,EXECPU,FCHCPU) or by total elapsed time SORT=(PRSELA,EXEELA,FCHELA)

    By turning on tracing within MAXIMO and running TKPROF, you will be able to see exactly which SQL statements generated by MAXIMO are the long-running statements. You can run the TKPROF utility using the EXPLAIN PLAN option which will show you the path that the optimizer uses for each particular SQL statement. The goal is to discover why particular SQL statements are taking so long to run.


    Example:

    tkprof ora_213999.trc ora_213999.out sys=no sort=execpu explain=maximo/maximo@tns:maxdb

    Performance issues to consider (1) optimization mode (cost vs rule) (2) missing indexes (3) database table and index fragmentation (4) other processes running on the database server (5) server resource limitations reached: memory, file throughput, CPU speed.


    Note: Increasing the size of Oracle trace files

    You may need to increase the size of the trace file.

    To determine the current setting:

    SELECT NAME,VALUE FROM V$PARAMETER WHERE NAME = 'max_dump_file_size';

    To increase it:

    ALTER SYSTEM SET MAX_DUMP_FILE_SIZE = nnM SCOPE = MEMORY;

    where size can be nnK nnM or UNLIMITED

    and SCOPE can be:

    MEMORY - For dynamic parameters. Change is immediate but does not persist across shutdown.
    SPFILE - For static or dynamic parms. Change goes into affect after a shutdown/restart. Static parms can only use this one.
    BOTH - For dynamic parms. Put into affect immediately and make it permanent.

    posted on 2006-02-09 15:51 大樹 閱讀(502) 評論(0)  編輯  收藏


    只有注冊用戶登錄后才能發(fā)表評論。


    網(wǎng)站導(dǎo)航:
     
    <2006年2月>
    2930311234
    567891011
    12131415161718
    19202122232425
    2627281234
    567891011

    導(dǎo)航

    統(tǒng)計

    公告

    本期話題
    能源行業(yè)資產(chǎn)管理咨詢
    資產(chǎn)管理信息化方案提供
    資產(chǎn)管理相關(guān)行業(yè)培訓(xùn)
    大型企業(yè)軟件體系架構(gòu)整合
    資產(chǎn)管理信息系統(tǒng)實施
    信息集成
    信息孤島

    常用鏈接

    留言簿(6)

    隨筆檔案(45)

    文章檔案(7)

    新聞檔案(1)

    相冊

    wallgate management consulting

    最新隨筆

    搜索

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 国产福利电影一区二区三区,亚洲国模精品一区| 久久久久免费精品国产| 亚洲国产精品免费观看| 亚洲成av人片不卡无码| 男人的天堂av亚洲一区2区| 又黄又大的激情视频在线观看免费视频社区在线| 污网站在线观看免费| 99re6在线视频精品免费下载| 午夜神器成在线人成在线人免费| 亚洲成A人片在线观看中文| 亚洲免费在线视频| 亚洲精品又粗又大又爽A片| 永久免费av无码网站yy| 精品国产麻豆免费网站| 亚洲国产精品无码久久久不卡| 亚洲国产日韩在线人成下载| a级毛片免费观看在线| 国产精彩免费视频| ZZIJZZIJ亚洲日本少妇JIZJIZ| 一级**爱片免费视频| 青青草国产免费久久久91| 国产精品久久久久久亚洲小说| 亚洲黄色免费电影| MM131亚洲国产美女久久| a级大片免费观看| 亚洲av片一区二区三区| 亚洲自偷自偷在线成人网站传媒 | 免费a级毛片18以上观看精品| 久久99亚洲网美利坚合众国| 亚洲免费在线观看| 亚洲视频一区二区三区| 韩日电影在线播放免费版| 亚洲美女视频网站| 国产区卡一卡二卡三乱码免费| 亚洲一级特黄特黄的大片| 99久久精品日本一区二区免费 | 国产精品无码一二区免费 | 亚洲精品456播放| 一级白嫩美女毛片免费| 精品无码一区二区三区亚洲桃色| 午夜男人一级毛片免费 |