Database Tuning (MOSC)

MOSC Banner

Batch long run issue.

edited Sep 26, 2013 6:09AM in Database Tuning (MOSC) 1 commentAnswered
Hello Everbody, Good Day/Night.

We have batch job which is taking more time now a days. i have generated the AWR report and i saw there huge wait for db file sequentila read.

Top 5 Timed Foreground Events

    EventWaitsTime(s)Avg wait (ms)% DB timeWait Classdb file sequential read4,474,47212,310325.17User I/ODB CPU 11,961 24.45 direct path read126,7194,423359.04User I/Odb file scattered read302,4083,709127.58User I/Odb file parallel read592,4593,42167.00User I/O

    Buffer Pool Statistics

    • Standard block size Pools default, K: keep, R: recycle
    • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

    PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy WaitsD1,663,19997975,128,36927,372,0214,222,0290042,554

    Howdy, Stranger!

    Log In

    To view full details, sign in to My Oracle Support Community.

    Register

    Don't have a My Oracle Support Community account? Click here to get started.

    Category Leaderboard

    Top contributors this month

    Instructions for posting

    ×

    1. Select a discussion category from the picklist.


    2. Enter a title that clearly identifies the subject of your question.


    3. In the body, insert detailed information, including Oracle product and version.


    Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


    Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


    New to My Oracle Support Community? Visit our Welcome Center

    MOSC Help Center