<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

    最新隨筆

    搜索

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 久久久久国产免费| 亚洲乱码无码永久不卡在线| 亚洲a一级免费视频| 羞羞视频免费网站在线看| 亚洲第一香蕉视频| 亚洲精华国产精华精华液网站| 亚洲色欲色欲www在线播放| 免费h片在线观看网址最新| 噜噜噜亚洲色成人网站∨| 最好看的中文字幕2019免费| 韩国日本好看电影免费看| 亚洲综合精品香蕉久久网| www在线观看播放免费视频日本| 免费国产综合视频在线看| 国产成人人综合亚洲欧美丁香花 | 16女性下面无遮挡免费| 无码人妻久久一区二区三区免费 | 啦啦啦中文在线观看电视剧免费版 | 亚洲精品国产suv一区88 | 国产免费小视频在线观看| 爱情岛论坛亚洲品质自拍视频网站| 国产在线不卡免费播放| 七次郎成人免费线路视频| 男女作爱在线播放免费网站| 亚洲精品国产成人专区| 精品女同一区二区三区免费播放 | 国产免费啪嗒啪嗒视频看看 | 国产午夜亚洲精品不卡电影| 亚洲美女高清一区二区三区 | 久久久久久精品免费看SSS| 亚洲成人激情小说| 亚洲国产精品一区二区第四页| 国产男女爽爽爽免费视频| 中文字幕亚洲综合久久2| 国产成人精品高清免费| a毛片在线看片免费| 宅男666在线永久免费观看| 国产人成网在线播放VA免费| 久久久无码精品亚洲日韩按摩 | 亚洲免费精彩视频在线观看| 亚洲性无码AV中文字幕|