<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人网址| 亚洲精品无码mv在线观看网站| 亚洲va国产va天堂va久久| 亚洲第一永久在线观看| 青娱乐在线视频免费观看| 国产美女精品视频免费观看| 亚洲色偷偷色噜噜狠狠99| 久久久久国色AV免费看图片| 77777午夜亚洲| 成人无遮挡裸免费视频在线观看| 亚洲成人激情小说| 日本一道一区二区免费看| 亚洲av综合av一区| 无码中文字幕av免费放dvd| 337p日本欧洲亚洲大胆色噜噜| 在线观看www日本免费网站| 亚洲色图综合在线| 亚洲中文字幕无码久久| 国产男女性潮高清免费网站| 老外毛片免费视频播放| 伊人久久大香线蕉亚洲五月天| 亚洲日韩一区精品射精| 免费在线观看h片| 自拍偷区亚洲国内自拍| 日本中文一区二区三区亚洲| 在线观看亚洲AV日韩A∨| 免费国内精品久久久久影院| 亚洲视频在线免费| 免费人妻av无码专区| 在线观看免费视频一区| 亚洲第一香蕉视频| 国产色婷婷精品免费视频| 中文字幕在线观看免费| 1区1区3区4区产品亚洲| 四虎免费影院4hu永久免费| 美女被cao网站免费看在线看| 亚洲fuli在线观看| 国产精品亚洲精品日韩已方| h视频在线免费看|