Statspack Analyzer – Intelligent analysis of Oracle Statspack and AWR reports

After spending a couple days picking through Oracle statspack reports for clues on what could be causing some database latency I finally got the chance to try out the new, free Statspack Analyzer from Texas Memory Systems, Inc. and Burleson Consulting.

StatspackAnalyzer.com is a FREE SITE provided to the Oracle community by sponsor companies including Texas Memory Systems, Inc. and Burleson Consulting.

Our shared goal is that the advice provided by this website evolves as community feedback indicates that the heuristics should be updated. If you like what you see, please let us know. If you don’t like what you see, please tell us what you would do to improve the site and which if any decision rules should be updated.

Just paste your whole statspack or AWR report into the analyzer and it will do the heavy lifting and give you custom recommendations on what areas you can possibly tune to increase performance. I had the chance to run several reports through the analyzer this week and it came up with many of the same conclusions I did in a fraction of the time.

Tools like this aren’t about to replace the DBA but rather help take the edge off intensive tasks like tuning. Check out the sample report to get a better idea of what the analyzer output looks like, or better yet try it out! After all, it’s free!

oracle, database, dba, database administrator, database tuning, sql

5 thoughts on “Statspack Analyzer – Intelligent analysis of Oracle Statspack and AWR reports”

  1. STATSPACK report for

    Database DB Id Instance Inst Num Startup Time Release RAC
    ~~~~~~~~ ———– ———— ——– ————— ———– —
    2947270502 PERFDB 1 27-Dec-06 08:14 10.2.0.2.0 NO

    Host Name: ridley Num CPUs: 16 Phys Memory (MB): 65,335
    ~~~~

    Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
    ~~~~~~~~ ———- —————— ——– ——— ——————-
    Begin Snap: 1 27-Dec-06 08:22:18 22 3.2
    End Snap: 2 27-Dec-06 09:00:03 24 3.0
    Elapsed: 37.75 (mins)

    Cache Sizes Begin End
    ~~~~~~~~~~~ ———- ———-
    Buffer Cache: 1,248M Std Block Size: 8K
    Shared Pool Size: 320M Log Buffer: 4,096K

    Load Profile Per Second Per Transaction
    ~~~~~~~~~~~~ ————— —————
    Redo size: 483,188.79 7,761,862.47
    Logical reads: 5,734.80 92,122.85
    Block changes: 3,207.06 51,517.61
    Physical reads: 48.22 774.57
    Physical writes: 50.56 812.16
    User calls: 2,097.90 33,700.34
    Parses: 563.09 9,045.32
    Hard parses: 0.31 4.93
    Sorts: 9.70 155.89
    Logons: 0.00 0.06
    Executes: 1,317.88 21,170.17
    Transactions: 0.06

    % Blocks changed per Read: 55.92 Recursive Call %: 28.68
    Rollback per transaction %: 0.00 Rows per Sort: 4.52

    Instance Efficiency Percentages
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 100.00
    Buffer Hit %: 99.16 In-memory Sort %: 100.00
    Library Hit %: 99.94 Soft Parse %: 99.95
    Execute to Parse %: 57.27 Latch Hit %: 100.00
    Parse CPU to Parse Elapsd %: 89.11 % Non-Parse CPU: 96.26

    Shared Pool Statistics Begin End
    —— ——
    Memory Usage %: 59.74 65.99
    % SQL with executions>1: 69.75 65.16
    % Memory for SQL w/exec>1: 67.16 63.68

    Top 5 Timed Events Avg %Total
    ~~~~~~~~~~~~~~~~~~ wait Call
    Event Waits Time (s) (ms) Time
    —————————————– ———— ———– —— ——
    CPU time 660 63.9
    log file parallel write 2,145 186 87 18.0
    db file parallel write 20,118 134 7 13.0
    db file sequential read 56,877 19 0 1.9
    log file sync 254 18 72 1.8
    ————————————————————-

    Host CPU (CPUs: 16)
    ~~~~~~~~ Load Average
    Begin End User System Idle WIO WCPU
    ——- ——- ——- ——- ——- ——- ——–
    0.24 1.20 3.54 1.61 94.85 0.00 0.04

    Instance CPU
    ~~~~~~~~~~~~
    % of total CPU for Instance: 1.79
    % of busy CPU for Instance: 34.74
    %DB time waiting for CPU – Resource Mgr:

    Memory Statistics Begin End
    ~~~~~~~~~~~~~~~~~ ———— ————
    Host Mem (MB): 65,334.7 65,334.7
    SGA use (MB): 1,760.0 1,760.0
    PGA use (MB): 44.5 53.4
    % Host Mem used for SGA+PGA: 2.8 2.8
    ————————————————————-

    Time Model System Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Ordered by % of DB time desc, Statistic name

    Statistic Time (s) % of DB time
    ———————————– ——————– ————
    DB CPU 596.2 93.6
    sql execute elapsed time 500.0 78.5
    parse time elapsed 33.4 5.2
    PL/SQL execution elapsed time 15.4 2.4
    hard parse elapsed time 1.2 .2
    PL/SQL compilation elapsed time 0.1 .0
    connection management call elapsed 0.0 .0
    repeated bind elapsed time 0.0 .0
    DB time 637.3
    background elapsed time 351.9
    background cpu time 51.9
    ————————————————————-

    Wait Events DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> s – second, cs – centisecond, ms – millisecond, us – microsecond
    -> %Timeouts: value of 0 indicates value was Only events with Total Wait Time (s) >= .001 are shown
    -> ordered by Total Wait Time desc, Waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    ——————————— ———— —— ———- —— ——–
    log file parallel write 2,145 0 186 87 15.2
    db file parallel write 20,118 0 134 7 142.7
    db file sequential read 56,877 0 19 0 403.4
    log file sync 254 2 18 72 1.8
    log buffer space 63 0 7 116 0.4
    control file parallel write 1,080 0 4 3 7.7
    db file scattered read 5,469 0 2 0 38.8
    free buffer waits 48 94 1 17 0.3
    log file switch completion 14 0 1 55 0.1
    os thread startup 4 0 0 69 0.0
    direct path write 53 0 0 3 0.4
    latch free 1 0 0 42 0.0
    control file sequential read 1,475 0 0 0 10.5
    direct path read 42 0 0 0 0.3
    log file single write 14 0 0 1 0.1
    db file parallel read 2 0 0 9 0.0
    LGWR wait for redo copy 268 0 0 0 1.9
    rdbms ipc reply 65 0 0 0 0.5
    virtual circuit status 75 100 2,184 29123 0.5
    Streams AQ: qmn slave idle wait 80 0 2,178 27226 0.6
    Streams AQ: qmn coordinator idle 160 50 2,178 13613 1.1
    SQL*Net message from client 3,561,810 0 1,486 0 ########
    jobq slave wait 2 50 5 2447 0.0
    SQL*Net message to client 3,561,811 0 2 0 ########
    SQL*Net more data from client 58,230 0 1 0 413.0
    ————————————————————-

    Background Wait Events DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> %Timeouts: value of 0 indicates value was Only events with Total Wait Time (s) >= .001 are shown
    -> ordered by Total Wait Time desc, Waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    ——————————— ———— —— ———- —— ——–
    log file parallel write 2,145 0 186 87 15.2
    db file parallel write 20,118 0 134 7 142.7
    control file parallel write 1,080 0 4 3 7.7
    os thread startup 4 0 0 69 0.0
    direct path write 42 0 0 4 0.3
    direct path read 42 0 0 0 0.3
    log file single write 14 0 0 1 0.1
    control file sequential read 598 0 0 0 4.2
    events in waitclass Other 268 0 0 0 1.9
    db file sequential read 58 0 0 0 0.4
    rdbms ipc message 14,556 85 34,545 2373 103.2
    pmon timer 755 100 2,207 2923 5.4
    Streams AQ: qmn slave idle wait 80 0 2,178 27226 0.6
    Streams AQ: qmn coordinator idle 160 50 2,178 13613 1.1
    smon timer 9 78 2,026 ###### 0.1
    ————————————————————-

    Wait Event Histogram DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Total Waits – units: K is 1000, M is 1000000, G is 1000000000
    -> % of Waits – column heading: 1s is truly >=1024ms
    -> % of Waits – value: .0 indicates value was Ordered by Event (idle events last)

    Total —————– % of Waits ——————
    Event Waits 1s
    ————————– —– —– —– —– —– —– —– —– —–
    LGWR wait for redo copy 268 100.0
    SQL*Net break/reset to cli 2 100.0
    SQL*Net more data to clien 31 100.0
    control file parallel writ 1080 97.6 2.1 .2 .1
    control file sequential re 1475 100.0
    db file parallel read 2 50.0 50.0
    db file parallel write 20K 4.7 40.2 23.9 12.8 6.8 9.4 2.1 .0
    db file scattered read 5469 98.4 .6 .4 .4 .1 .1 .0
    db file sequential read 56K 97.8 .5 .3 .7 .2 .2 .3
    direct path read 42 95.2 2.4 2.4
    direct path write 53 81.1 1.9 9.4 3.8 3.8
    free buffer waits 48 2.1 2.1 16.7 79.2
    latch free 1 100.0
    latch: library cache 2 100.0
    latch: shared pool 1 100.0
    log buffer space 63 1.6 12.7 85.7
    log file parallel write 2145 8.9 8.6 2.7 2.1 2.0 75.7
    log file sequential read 14 100.0
    log file single write 14 100.0
    log file switch completion 14 42.9 57.1
    log file sync 254 2.0 10.6 18.5 8.7 9.1 51.2
    os thread startup 4 100.0
    rdbms ipc reply 65 100.0
    SQL*Net message from clien 3561K 100.0 .0 .0 .0 .0 .0 .0
    SQL*Net message to client 3561K 100.0
    SQL*Net more data from cli 58K 100.0
    Streams AQ: qmn coordinato 160 50.0 50.0
    Streams AQ: qmn slave idle 80 100.0
    class slave wait 3 100.0
    dispatcher timer 37 100.0
    jobq slave wait 2 100.0
    pmon timer 756 .4 99.6
    rdbms ipc message 14K 1.8 .1 .1 .5 .4 .4 29.2 67.6
    smon timer 9 11.1 88.9
    virtual circuit status 75 100.0
    ————————————————————-

    SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB CPU (s): 596
    -> Captured SQL accounts for 84.5% of Total DB CPU
    -> SQL reported below exceeded 1.0% of Total DB CPU

    CPU CPU per Elapsd Old
    Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
    ———- ———— ———- —— ———- ————— ———-
    213.12 555,234 0.00 35.7 215.11 4,668,256 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    40.23 26,056 0.00 6.7 40.23 2,136,731 2853949187
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
    DEL_STS_IND from TGEN568

    25.39 851,187 0.00 4.3 25.39 0 1876777081
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TRUNC(SYSDATE) FROM SYS.DUAL

    25.05 20,209 0.00 4.2 28.35 1,308,535 3364479374
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
    _CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
    _NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
    _AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
    f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS

    23.77 113,549 0.00 4.0 23.88 1,184,877 304009201
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
    AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
    TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
    CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
    SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6

    19.62 851,183 0.00 3.3 19.62 0 543962341
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL

    18.41 32,252 0.00 3.1 19.54 595,263 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    11.64 32,252 0.00 2.0 11.64 162,581 2481065608
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    11.60 26,055 0.00 1.9 11.67 220,202 2260637923

    SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB CPU (s): 596
    -> Captured SQL accounts for 84.5% of Total DB CPU
    -> SQL reported below exceeded 1.0% of Total DB CPU

    CPU CPU per Elapsd Old
    Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
    ———- ———— ———- —— ———- ————— ———-
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
    INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
    S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
    3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
    SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_

    11.38 26,055 0.00 1.9 11.50 218,533 3132248938
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
    CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
    E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
    AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
    L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM

    9.86 26,054 0.00 1.7 9.86 157,633 1477189672
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
    GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
    :b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
    =:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
    AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA

    9.74 26,054 0.00 1.6 9.74 53,546 2408642227
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
    E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
    _SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT
    =:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
    E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT

    9.70 26,054 0.00 1.6 9.70 105,952 2895558748
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI
    L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
    TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
    AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
    AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT

    9.54 26,055 0.00 1.6 9.54 131,083 3748955465
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    8.66 14,594 0.00 1.5 11.75 178,661 3625372575
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
    UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
    D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB

    SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB CPU (s): 596
    -> Captured SQL accounts for 84.5% of Total DB CPU
    -> SQL reported below exceeded 1.0% of Total DB CPU

    CPU CPU per Elapsd Old
    Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
    ———- ———— ———- —— ———- ————— ———-
    R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
    d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)

    6.42 19,325 0.00 1.1 11.16 107,299 1737386892
    Module: unikixvsam@ridley (TNS V1-V3)
    select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
    LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
    RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
    ((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
    and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )

    ————————————————————-

    SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB Time (s): 637
    -> Captured SQL accounts for 81.7% of Total DB Time
    -> SQL reported below exceeded 1.0% of Total DB Time

    Elapsed Elap per CPU Old
    Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
    ———- ———— ———- —— ———- ————— ———-
    215.11 555,234 0.00 33.8 213.12 3,099 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    40.23 26,056 0.00 6.3 40.23 16 2853949187
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
    DEL_STS_IND from TGEN568

    28.35 20,209 0.00 4.4 25.05 18,177 3364479374
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
    _CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
    _NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
    _AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
    f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS

    25.39 851,187 0.00 4.0 25.39 0 1876777081
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TRUNC(SYSDATE) FROM SYS.DUAL

    23.88 113,549 0.00 3.7 23.77 969 304009201
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
    AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
    TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
    CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
    SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6

    19.62 851,183 0.00 3.1 19.62 0 543962341
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL

    19.54 32,252 0.00 3.1 18.41 8,867 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    11.75 14,594 0.00 1.8 8.66 9,771 3625372575
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
    UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
    D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
    R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
    d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)

    SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB Time (s): 637
    -> Captured SQL accounts for 81.7% of Total DB Time
    -> SQL reported below exceeded 1.0% of Total DB Time

    Elapsed Elap per CPU Old
    Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
    ———- ———— ———- —— ———- ————— ———-

    11.67 26,055 0.00 1.8 11.60 558 2260637923
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
    INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
    S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
    3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
    SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_

    11.64 32,252 0.00 1.8 11.64 0 2481065608
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    11.50 26,055 0.00 1.8 11.38 489 3132248938
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
    CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
    E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
    AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
    L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM

    11.16 19,325 0.00 1.8 6.42 23,913 1737386892
    Module: unikixvsam@ridley (TNS V1-V3)
    select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
    LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
    RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
    ((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
    and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )

    9.86 26,054 0.00 1.5 9.86 1 1477189672
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
    GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
    :b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
    =:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
    AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA

    9.74 26,054 0.00 1.5 9.74 0 2408642227
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
    E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
    _SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT
    =:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
    E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT

    9.70 26,054 0.00 1.5 9.70 0 2895558748
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI

    SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> Total DB Time (s): 637
    -> Captured SQL accounts for 81.7% of Total DB Time
    -> SQL reported below exceeded 1.0% of Total DB Time

    Elapsed Elap per CPU Old
    Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
    ———- ———— ———- —— ———- ————— ———-
    L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
    TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
    AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
    AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT

    9.54 26,055 0.00 1.5 9.54 0 3748955465
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    ————————————————————-

    SQL ordered by Gets DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> End Buffer Gets Threshold: 10000 Total Buffer Gets: 12,989,322
    -> Captured SQL accounts for 95.0% of Total Buffer Gets
    -> SQL reported below exceeded 1.0% of Total Buffer Gets

    CPU Elapsd Old
    Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
    4,668,256 555,234 8.4 35.9 213.12 215.11 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    2,136,731 26,056 82.0 16.4 40.23 40.23 2853949187
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
    DEL_STS_IND from TGEN568

    1,308,535 20,209 64.8 10.1 25.05 28.35 3364479374
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
    _CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
    _NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
    _AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
    f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS

    1,184,877 113,549 10.4 9.1 23.77 23.88 304009201
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
    AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
    TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
    CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
    SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6

    595,263 32,252 18.5 4.6 18.41 19.54 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    220,202 26,055 8.5 1.7 11.60 11.67 2260637923
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
    INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
    S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
    3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
    SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_

    218,533 26,055 8.4 1.7 11.38 11.50 3132248938
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
    CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
    E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
    AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
    L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM

    SQL ordered by Gets DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Resources reported for PL/SQL code includes the resources used by all SQL
    statements called by the code.
    -> End Buffer Gets Threshold: 10000 Total Buffer Gets: 12,989,322
    -> Captured SQL accounts for 95.0% of Total Buffer Gets
    -> SQL reported below exceeded 1.0% of Total Buffer Gets

    CPU Elapsd Old
    Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-

    209,309 26,054 8.0 1.6 4.60 4.60 1280268270
    Module: unikixvsam@ridley (TNS V1-V3)
    select TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TAX_SVE_CSS_1_PCT ,B
    IL_SVE_CSS_AMT ,TAX_SVE_CSS_1_AMT ,CRY_CDE ,TAX_SVE_CSS_2_PCT
    ,TAX_SVE_CSS_2_AMT ,TAX_SVE_CSS_3_PCT ,TAX_SVE_CSS_3_AMT ,T
    AX_SVE_CSS_4_PCT ,TAX_SVE_CSS_4_AMT ,TAX_SVE_CSS_5_PCT ,TAX_S
    VE_CSS_5_AMT ,TAX_SVE_CSS_6_PCT ,TAX_SVE_CSS_6_AMT ,TAX_SVE_C

    178,661 14,594 12.2 1.4 8.66 11.75 3625372575
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
    UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
    D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
    R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
    d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)

    162,581 32,252 5.0 1.3 11.64 11.64 2481065608
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    157,633 26,054 6.1 1.2 9.86 9.86 1477189672
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
    GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
    :b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
    =:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
    AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA

    131,083 26,055 5.0 1.0 9.54 9.54 3748955465
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    ————————————————————-

    SQL ordered by Reads DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Disk Reads Threshold: 1000 Total Disk Reads: 109,214
    -> Captured SQL accounts for 93.1% of Total Disk Reads
    -> SQL reported below exceeded 1.0% of Total Disk Reads

    CPU Elapsd Old
    Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
    27,328 2 13,664.0 25.0 3.03 4.16 963101824
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,MHT_ITL_NBR ,CRY_CDE ,SLT_GRP_CDE ,SLT_N
    BR ,CRD_SCM_IDN_CDE ,SLT_BFD_AMT ,SLT_BFD_TXN_NBR ,PNG_SLT_A
    MT ,PNG_SLT_TXN_NBR ,SLT_AMT ,SLT_TXN_NBR ,SLT_UTL_DTE ,SLT
    _DTE ,FCE_SLT_IND ,PMT_NOF_IND ,AVC_GRP_STS_CDE ,IDV_PMT_IND
    ,FLX_PMT_IND ,SLT_DEY_NBR ,ITN_SLT_AMT ,ITN_SLT_BFD_AMT ,L

    23,913 19,325 1.2 21.9 6.42 11.16 1737386892
    Module: unikixvsam@ridley (TNS V1-V3)
    select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
    LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
    RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
    ((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
    and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )

    18,177 20,209 0.9 16.6 25.05 28.35 3364479374
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
    _CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
    _NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
    _AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
    f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS

    9,771 14,594 0.7 8.9 8.66 11.75 3625372575
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
    UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
    D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
    R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
    d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)

    8,867 32,252 0.3 8.1 18.41 19.54 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    3,892 1 3,892.0 3.6 0.23 0.24 2792573995
    Module: SQL*Plus
    select count(*) from tgen593_bkp

    3,099 555,234 0.0 2.8 213.12 215.11 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    1,753 2,950 0.6 1.6 0.76 0.83 224108471
    Module: unikixvsam@ridley (TNS V1-V3)

    SQL ordered by Reads DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Disk Reads Threshold: 1000 Total Disk Reads: 109,214
    -> Captured SQL accounts for 93.1% of Total Disk Reads
    -> SQL reported below exceeded 1.0% of Total Disk Reads

    CPU Elapsd Old
    Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
    ————— ———— ————– —— ——– ——— ———-
    select PNG_SLT_TXN_NBR ,SLT_TXN_NBR ,SLT_RST_IDN_CDE ,IDV_PMT
    _IND ,LST_UPD_NBR into :b1,:b2,:b3,:b4,:b5 from TGEN590 wher
    e (((((ITN_IDN_CDE=:b6 and MHT_ITL_NBR=:b7) and CRY_CDE=:b8) and
    SLT_GRP_CDE=:b9) and SLT_NBR=:b10) and CRD_SCM_IDN_CDE=:b11)

    ————————————————————-

    SQL ordered by Executions DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Executions Threshold: 100 Total Executions: 2,984,994
    -> Captured SQL accounts for 100.1% of Total Executions
    -> SQL reported below exceeded 1.0% of Total Executions

    CPU per Elap per Old
    Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
    ———— ————— —————- ———– ———- ———-
    851,187 851,187 1.0 0.00 0.00 1876777081
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TRUNC(SYSDATE) FROM SYS.DUAL

    851,183 851,183 1.0 0.00 0.00 543962341
    Module: unikixvsam@ridley (TNS V1-V3)
    SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL

    555,234 555,234 1.0 0.00 0.00 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    113,549 113,549 1.0 0.00 0.00 304009201
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
    AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
    TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
    CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
    SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6

    32,252 32,252 1.0 0.00 0.00 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    32,252 32,252 1.0 0.00 0.00 2481065608
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    32,252 32,252 1.0 0.00 0.00 3279785947
    Module: unikixvsam@ridley (TNS V1-V3)
    select LST_PMT_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
    ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)

    ————————————————————-

    SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
    -> Captured SQL accounts for 100.0% of Total Parse Calls
    -> SQL reported below exceeded 1.0% of Total Parse Calls

    % Total Old
    Parse Calls Executions Parses Hash Value
    ———— ———— ——– ———-
    555,234 555,234 43.53 908225952
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
    D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
    :b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid = 😡

    113,549 113,549 8.90 304009201
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
    AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
    TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
    CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
    SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6

    32,252 32,252 2.53 2084546057
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
    OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
    DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
    CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
    ,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A

    32,252 32,252 2.53 2481065608
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    32,252 32,252 2.53 3279785947
    Module: unikixvsam@ridley (TNS V1-V3)
    select LST_PMT_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
    ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)

    26,056 26,056 2.04 2853949187
    Module: unikixvsam@ridley (TNS V1-V3)
    select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
    DEL_STS_IND from TGEN568

    26,055 26,055 2.04 2260637923
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
    INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
    S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
    3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
    SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_

    26,055 26,055 2.04 2560418031
    Module: unikixvsam@ridley (TNS V1-V3)
    select LST_BIL_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
    ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)

    26,055 26,055 2.04 3064314749

    SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
    -> Captured SQL accounts for 100.0% of Total Parse Calls
    -> SQL reported below exceeded 1.0% of Total Parse Calls

    % Total Old
    Parse Calls Executions Parses Hash Value
    ———— ———— ——– ———-
    Module: unikixvsam@ridley (TNS V1-V3)
    select BIL_NBR into :b1 from TGEN620 where ((ITN_IDN_CDE=:b2
    and BIL_NBR=:b1) and MHT_ITL_NBR=:b3)

    26,055 26,055 2.04 3132248938
    Module: unikixvsam@ridley (TNS V1-V3)
    insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
    CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
    E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
    AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
    L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM

    26,055 26,055 2.04 3748955465
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
    ,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
    ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)

    26,054 26,054 2.04 183421324
    Module: unikixvsam@ridley (TNS V1-V3)
    select DFT_TAX_SCM_IND into :b1 from TGEN522 where ITN_IDN_CD
    E=:b2

    26,054 26,054 2.04 1280268270
    Module: unikixvsam@ridley (TNS V1-V3)
    select TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TAX_SVE_CSS_1_PCT ,B
    IL_SVE_CSS_AMT ,TAX_SVE_CSS_1_AMT ,CRY_CDE ,TAX_SVE_CSS_2_PCT
    ,TAX_SVE_CSS_2_AMT ,TAX_SVE_CSS_3_PCT ,TAX_SVE_CSS_3_AMT ,T
    AX_SVE_CSS_4_PCT ,TAX_SVE_CSS_4_AMT ,TAX_SVE_CSS_5_PCT ,TAX_S
    VE_CSS_5_AMT ,TAX_SVE_CSS_6_PCT ,TAX_SVE_CSS_6_AMT ,TAX_SVE_C

    26,054 26,054 2.04 1477189672
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
    GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
    :b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
    =:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
    AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA

    26,054 26,054 2.04 2020074211
    Module: unikixvsam@ridley (TNS V1-V3)
    select MHT_EXT_TXT ,MHT_NME_TXT ,LCN_CTT_TYP_CDE ,LCN_CTT_IDN
    _NBR ,BIL_CTT_TYP_CDE ,BIL_CTT_IDN_NBR ,AVC_CTT_IDN_NBR ,TAX
    _SCM_CDE ,MHT_STO_IDN_TXT into :b1,:b2,:b3,:b4,:b5:i5,:b6:i6,
    :b7:i7,:b8:i8,:b9:i9 from TGEN534 where (ITN_IDN_CDE=:b10 and M
    HT_ITL_NBR=:b11)

    26,054 26,054 2.04 2408642227
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
    E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
    _SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT

    SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
    -> Captured SQL accounts for 100.0% of Total Parse Calls
    -> SQL reported below exceeded 1.0% of Total Parse Calls

    % Total Old
    Parse Calls Executions Parses Hash Value
    ———— ———— ——– ———-
    =:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
    E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT

    26,054 26,054 2.04 2895558748
    Module: unikixvsam@ridley (TNS V1-V3)
    update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI
    L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
    TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
    AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
    AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT

    ————————————————————-

    Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2

    Statistic Total per Second per Trans
    ——————————— —————— ————– ————
    CPU used by this session 65,983 29.1 468.0
    CPU used when call started 65,624 29.0 465.4
    CR blocks created 392 0.2 2.8
    DB time 69,204 30.6 490.8
    DBWR checkpoint buffers written 22,328 9.9 158.4
    DBWR checkpoints 7 0.0 0.1
    DBWR object drop buffers written 0 0.0 0.0
    DBWR thread checkpoint buffers wr 2,262 1.0 16.0
    DBWR transaction table writes 64 0.0 0.5
    DBWR undo block writes 56,743 25.1 402.4
    IMU Flushes 133 0.1 0.9
    IMU Redo allocation size 6,289,300 2,776.7 44,605.0
    IMU commits 2 0.0 0.0
    IMU pool not allocated 4 0.0 0.0
    IMU recursive-transaction flush 3 0.0 0.0
    IMU undo allocation size 5,521,040 2,437.6 39,156.3
    IMU- failed to get a private stra 4 0.0 0.0
    SQL*Net roundtrips to/from client 3,561,967 1,572.6 25,262.2
    active txn count during cleanout 31,629 14.0 224.3
    application wait time 0 0.0 0.0
    background checkpoints completed 6 0.0 0.0
    background checkpoints started 7 0.0 0.1
    background timeouts 12,464 5.5 88.4
    branch node splits 40 0.0 0.3
    buffer is not pinned count 1,672,854 738.6 11,864.2
    buffer is pinned count 1,844,723 814.5 13,083.1
    bytes received via SQL*Net from c 945,431,351 417,409.0 6,705,186.9
    bytes sent via SQL*Net to client 613,577,860 270,895.3 4,351,616.0
    calls to get snapshot scn: kcmgss 3,109,876 1,373.0 22,055.9
    calls to kcmgas 145,153 64.1 1,029.5
    calls to kcmgcs 29,302 12.9 207.8
    change write time 4,534 2.0 32.2
    cleanout – number of ktugct calls 38,952 17.2 276.3
    cleanouts only – consistent read 2,535 1.1 18.0
    cluster key scan block gets 7,816 3.5 55.4
    cluster key scans 3,238 1.4 23.0
    commit batch/immediate performed 7 0.0 0.1
    commit batch/immediate requested 7 0.0 0.1
    commit cleanout failures: block l 1 0.0 0.0
    commit cleanout failures: buffer 107 0.1 0.8
    commit cleanout failures: callbac 809 0.4 5.7
    commit cleanouts 96,358 42.5 683.4
    commit cleanouts successfully com 95,441 42.1 676.9
    commit immediate performed 7 0.0 0.1
    commit immediate requested 7 0.0 0.1
    commit txn count during cleanout 13,625 6.0 96.6
    concurrency wait time 27 0.0 0.2
    consistent changes 259 0.1 1.8
    consistent gets 4,568,022 2,016.8 32,397.3
    consistent gets – examination 1,013,924 447.7 7,191.0
    consistent gets from cache 4,568,022 2,016.8 32,397.3
    cursor authentications 260 0.1 1.8
    data blocks consistent reads – un 259 0.1 1.8
    db block changes 7,263,983 3,207.1 51,517.6
    db block gets 8,421,302 3,718.0 59,725.6
    db block gets direct 4,638 2.1 32.9

    Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2

    Statistic Total per Second per Trans
    ——————————— —————— ————– ————
    db block gets from cache 8,416,664 3,716.0 59,692.7
    deferred (CURRENT) block cleanout 84,027 37.1 595.9
    dirty buffers inspected 54,301 24.0 385.1
    enqueue conversions 528 0.2 3.7
    enqueue releases 36,257 16.0 257.1
    enqueue requests 36,271 16.0 257.2
    enqueue waits 0 0.0 0.0
    execute count 2,984,994 1,317.9 21,170.2
    failed probes on index block recl 53 0.0 0.4
    free buffer inspected 189,325 83.6 1,342.7
    free buffer requested 254,763 112.5 1,806.8
    global undo segment hints helped 1 0.0 0.0
    heap block compress 128,057 56.5 908.2
    hot buffers moved to head of LRU 19,217 8.5 136.3
    immediate (CR) block cleanout app 2,535 1.1 18.0
    immediate (CURRENT) block cleanou 42,070 18.6 298.4
    index fast full scans (full) 4 0.0 0.0
    index fetch by key 397,619 175.6 2,820.0
    index scans kdiixs1 133,595 59.0 947.5
    leaf node 90-10 splits 44 0.0 0.3
    leaf node splits 7,574 3.3 53.7
    lob reads 438 0.2 3.1
    lob writes 56 0.0 0.4
    lob writes unaligned 56 0.0 0.4
    logons cumulative 9 0.0 0.1
    messages received 22,453 9.9 159.2
    messages sent 22,453 9.9 159.2
    no buffer to keep pinned count 0 0.0 0.0
    no work – consistent read gets 3,210,075 1,417.3 22,766.5
    opened cursors cumulative 1,282,513 566.2 9,095.8
    parse count (failures) 0 0.0 0.0
    parse count (hard) 695 0.3 4.9
    parse count (total) 1,275,390 563.1 9,045.3
    parse time cpu 2,471 1.1 17.5
    parse time elapsed 2,773 1.2 19.7
    physical read IO requests 62,540 27.6 443.6
    physical read bytes 894,681,088 395,002.7 6,345,255.9
    physical read total IO requests 64,038 28.3 454.2
    physical read total bytes 918,913,024 405,701.1 6,517,113.7
    physical read total multi block r 5,469 2.4 38.8
    physical reads 109,214 48.2 774.6
    physical reads cache 109,172 48.2 774.3
    physical reads cache prefetch 46,826 20.7 332.1
    physical reads direct 42 0.0 0.3
    physical reads prefetch warmup 12,265 5.4 87.0
    physical write IO requests 36,912 16.3 261.8
    physical write bytes 938,098,688 414,171.6 6,653,182.2
    physical write total IO requests 43,210 19.1 306.5
    physical write total bytes 2,123,482,112 937,519.7 ############
    physical write total multi block 14,767 6.5 104.7
    physical writes 114,514 50.6 812.2
    physical writes direct 4,680 2.1 33.2
    physical writes from cache 109,834 48.5 779.0
    physical writes non checkpoint 109,805 48.5 778.8
    pinned buffers inspected 22 0.0 0.2
    prefetch warmup blocks aged out b 5,355 2.4 38.0

    Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2

    Statistic Total per Second per Trans
    ——————————— —————— ————– ————
    prefetch warmup blocks flushed ou 0 0.0 0.0
    prefetched blocks aged out before 1 0.0 0.0
    process last non-idle time 2,282 1.0 16.2
    recursive calls 1,910,717 843.6 13,551.2
    recursive cpu usage 10,596 4.7 75.2
    redo blocks written 2,211,508 976.4 15,684.5
    redo buffer allocation retries 87 0.0 0.6
    redo entries 3,646,960 1,610.1 25,865.0
    redo log space requests 25 0.0 0.2
    redo log space wait time 78 0.0 0.6
    redo ordering marks 60,610 26.8 429.9
    redo size 1,094,422,608 483,188.8 7,761,862.5
    redo synch time 1,862 0.8 13.2
    redo synch writes 764 0.3 5.4
    redo wastage 629,104 277.8 4,461.7
    redo write time 19,010 8.4 134.8
    redo writer latching time 1 0.0 0.0
    redo writes 2,145 1.0 15.2
    rollback changes – undo records a 14 0.0 0.1
    rollbacks only – consistent read 258 0.1 1.8
    rows fetched via callback 250,822 110.7 1,778.9
    session connect time 834 0.4 5.9
    session cursor cache hits 1,109,035 489.6 7,865.5
    session logical reads 12,989,322 5,734.8 92,122.9
    session pga memory 4,852,112 2,142.2 34,412.1
    session pga memory max 8,194,448 3,617.9 58,116.7
    session uga memory 2,947,600 1,301.4 20,905.0
    session uga memory max 15,180,496 6,702.2 107,663.1
    shared hash latch upgrades – no w 403,158 178.0 2,859.3
    sorts (memory) 21,980 9.7 155.9
    sorts (rows) 99,305 43.8 704.3
    sql area evicted 88 0.0 0.6
    sql area purged 4 0.0 0.0
    summed dirty queue length 548,246 242.1 3,888.3
    switch current to new buffer 72,792 32.1 516.3
    table fetch by rowid 1,589,583 701.8 11,273.6
    table fetch continued row 190 0.1 1.4
    table scan blocks gotten 2,125,962 938.6 15,077.7
    table scan rows gotten 237,067,264 104,665.5 1,681,328.1
    table scans (long tables) 6 0.0 0.0
    table scans (rowid ranges) 3 0.0 0.0
    table scans (short tables) 26,576 11.7 188.5
    total number of times SMON posted 2 0.0 0.0
    transaction rollbacks 7 0.0 0.1
    undo change vector size 420,479,700 185,642.3 2,982,125.5
    user I/O wait time 2,089 0.9 14.8
    user calls 4,751,748 2,097.9 33,700.3
    user commits 141 0.1 1.0
    workarea executions – optimal 8,445 3.7 59.9
    write clones created in foregroun 92 0.0 0.7
    ————————————————————-

    Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Statistics with absolute values (should not be diffed)

    Statistic Begin Value End Value
    ——————————— ————— —————
    logons current 22 24
    opened cursors current 70 72
    session cursor cache count 291 420
    workarea memory allocated 0 2,188
    ————————————————————-

    Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> Statistics identified by ‘(derived)’ come from sources other than SYSSTAT

    Statistic Total per Hour
    ——————————— —————— ———
    log switches (derived) 7 11.13
    ————————————————————-

    OS Statistics DB/Inst: PERFDB/PERFDB Snaps: 1-2
    -> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name

    Statistic Total
    ————————- ———————-
    BUSY_TIME 186,569
    IDLE_TIME 3,436,330
    SYS_TIME 58,213
    USER_TIME 128,356
    LOAD 1
    OS_CPU_WAIT_TIME 1,500
    VM_IN_BYTES 40,960
    PHYSICAL_MEMORY_BYTES 68,508,418,048
    NUM_CPUS 16
    ————————————————————-

    Tablespace IO Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
    ->ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    CGEN_IDX
    33,656 15 0.4 1.3 10,315 5 0 0.0
    CGEN
    27,645 12 0.3 2.3 8,253 4 0 0.0
    UNDOTBS1
    43 0 1.2 1.0 16,782 7 0 0.0
    SYSTEM
    3,994 2 0.0 1.2 339 0 0 0.0
    PERFSTAT
    604 0 0.0 1.7 1,329 1 0 0.0
    SYSAUX
    759 0 0.0 2.3 241 0 0 0.0
    CGEN_CLOB
    12 0 2.5 1.0 8 0 0 0.0
    TMPSPACE
    1 0 0.0 1.0 0 0 0 0.0
    ————————————————————-

    File IO Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
    ->Mx Rd Bkt: Max bucket time for single block read
    ->ordered by Tablespace, File

    Tablespace Filename
    ———————— —————————————————-
    Av Mx

  2. It is quite a useful report but notice how often it mentions solid state disks – and the main sponsor is Texas Memory Systems – who sell SSD.

    I find it useful for conforming my own analysis. I do wish there was a good reference to reading an AWR report though

    John

  3. WORKLOAD REPOSITORY report for

    DB Name DB Id Instance Inst Num Release RAC Host
    ———— ———– ———— ——– ———– — ————
    PAST01 340786915 past01 1 10.2.0.2.0 NO vsl001a012

    Snap Id Snap Time Sessions Curs/Sess
    ——— ——————- ——– ———
    Begin Snap: 8218 24-Jan-10 19:00:50 28 1.9
    End Snap: 8219 24-Jan-10 20:02:14 28 2.0
    Elapsed: 61.40 (mins)
    DB Time: 11.49 (mins)

    Cache Sizes
    ~~~~~~~~~~~ Begin End
    ———- ———-
    Buffer Cache: 144M 144M Std Block Size: 8K
    Shared Pool Size: 592M 592M Log Buffer: 30,744K

    Load Profile
    ~~~~~~~~~~~~ Per Second Per Transaction
    ————— —————
    Redo size: 17,892.92 9,398.58
    Logical reads: 111.15 58.38
    Block changes: 61.25 32.17
    Physical reads: 0.61 0.32
    Physical writes: 3.02 1.59
    User calls: 33.27 17.47
    Parses: 11.67 6.13
    Hard parses: 0.00 0.00
    Sorts: 0.46 0.24
    Logons: 0.00 0.00
    Executes: 12.35 6.49
    Transactions: 1.90

    % Blocks changed per Read: 55.10 Recursive Call %: 20.48
    Rollback per transaction %: 0.01 Rows per Sort: 7.56

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 99.97
    Buffer Hit %: 99.78 In-memory Sort %: 100.00
    Library Hit %: 99.96 Soft Parse %: 99.96
    Execute to Parse %: 5.47 Latch Hit %: 99.98
    Parse CPU to Parse Elapsd %: 89.59 % Non-Parse CPU: 94.67

    Shared Pool Statistics Begin End
    —— ——
    Memory Usage %: 90.97 91.05
    % SQL with executions>1: 99.16 99.12
    % Memory for SQL w/exec>1: 90.60 90.75

    Top 5 Timed Events Avg %Total
    ~~~~~~~~~~~~~~~~~~ wait Call
    Event Waits Time (s) (ms) Time Wait Class
    —————————— ———— ———– —— —— ———-
    enq: TX – row lock contention 249 589 2367 85.5 Applicatio
    latch: shared pool 970 535 551 77.6 Concurrenc
    enq: PR – contention 29 81 2783 11.7 Other
    CPU time 61 8.9
    log file parallel write 7,758 47 6 6.8 System I/O
    ————————————————————-
    ^LTime Model Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Total time in database user-calls (DB Time): 689.1s
    -> Statistics including the word “background” measure background process
    time, and so do not contribute to the DB time statistic
    -> Ordered by % or DB time desc, Statistic name

    Statistic Name Time (s) % of DB Time
    —————————————— —————— ————
    sql execute elapsed time 628.7 91.2
    DB CPU 61.4 8.9
    parse time elapsed 6.0 .9
    hard parse elapsed time 2.4 .4
    failed parse (out of shared memory) elapse 2.2 .3
    failed parse elapsed time 2.2 .3
    hard parse (sharing criteria) elapsed time 0.2 .0
    sequence load elapsed time 0.1 .0
    hard parse (bind mismatch) elapsed time 0.0 .0
    repeated bind elapsed time 0.0 .0
    DB time 689.1 N/A
    background elapsed time 765.8 N/A
    background cpu time 58.4 N/A
    ————————————————————-

    Wait Class DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc

    Avg
    %Time Total Wait wait Waits
    Wait Class Waits -outs Time (s) (ms) /txn
    ——————– —————- —— —————- ——- ———
    Application 251 76.9 589 2348 0.0
    Concurrency 1,031 94.5 552 535 0.1
    Other 4,227 98.8 97 23 0.6
    System I/O 10,656 .0 68 6 1.5
    Commit 7,579 .0 43 6 1.1
    User I/O 3,753 .0 13 4 0.5
    Network 89,262 .0 2 0 12.7
    Configuration 5 .0 1 116 0.0
    ————————————————————-

    ^LWait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    enq: TX – row lock contentio 249 77.5 589 2367 0.0
    latch: shared pool 970 99.5 535 551 0.1
    enq: PR – contention 29 93.1 81 2783 0.0
    log file parallel write 7,758 .0 47 6 1.1
    log file sync 7,579 .0 43 6 1.1
    os thread startup 48 18.8 17 344 0.0
    latch: session allocation 5 .0 15 3077 0.0
    db file sequential read 1,944 .0 13 7 0.3
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    SQL*Net message to client 84,675 .0 2 0 12.1
    log file switch completion 2 .0 1 290 0.0
    ksdxexeotherwait 4,148 100.0 0 0 0.6
    SQL*Net more data from clien 4,587 .0 0 0 0.7
    latch: library cache 6 .0 0 24 0.0
    latch free 10 .0 0 14 0.0
    control file sequential read 1,461 .0 0 0 0.2
    direct path write 1,494 .0 0 0 0.2
    log file single write 4 .0 0 5 0.0
    SQL*Net break/reset to clien 2 .0 0 6 0.0
    SGA: allocation forcing comp 11 .0 0 1 0.0
    latch: cache buffers lru cha 3 .0 0 4 0.0
    direct path read 315 .0 0 0 0.0
    latch: checkpoint queue latc 2 .0 0 2 0.0
    latch: redo allocation 2 .0 0 1 0.0
    latch: cache buffers chains 7 .0 0 0 0.0
    latch: messages 1 .0 0 2 0.0
    LGWR wait for redo copy 11 .0 0 0 0.0
    rdbms ipc reply 1 .0 0 1 0.0
    latch: enqueue hash chains 1 100.0 0 1 0.0
    latch: redo writing 3 .0 0 0 0.0
    latch: virtual circuit queue 3 .0 0 0 0.0
    virtual circuit status 56,849 .1 3,940 69 8.1
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    SQL*Net message from client 84,649 .0 3,458 41 12.1
    ————————————————————-

    ^LBackground Wait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    latch: shared pool 970 99.5 535 551 0.1
    events in waitclass Other 4,204 99.3 90 21 0.6
    log file parallel write 7,758 .0 47 6 1.1
    os thread startup 49 20.4 18 357 0.0
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    db file sequential read 27 .0 2 62 0.0
    control file sequential read 803 .0 0 0 0.1
    log file single write 4 .0 0 5 0.0
    direct path write 8 .0 0 0 0.0
    latch: redo writing 3 .0 0 0 0.0
    direct path read 8 .0 0 0 0.0
    latch: cache buffers chains 1 .0 0 0 0.0
    rdbms ipc message 19,484 60.5 39,136 2009 2.8
    smon timer 15 86.7 3,823 254854 0.0
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    pmon timer 1,140 99.9 3,316 2909 0.2
    ————————————————————-

    Operating System Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total
    ——————————– ——————–
    BUSY_TIME 31,813
    IDLE_TIME 708,131
    IOWAIT_TIME 28,758
    NICE_TIME 0
    SYS_TIME 19,554
    USER_TIME 7,318
    LOAD 1
    RSRC_MGR_CPU_WAIT_TIME 0
    PHYSICAL_MEMORY_BYTES 2,048,012
    NUM_CPUS 2
    ————————————————————-

    ^LService Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by DB Time

    Physical Logical
    Service Name DB Time (s) DB CPU (s) Reads Reads
    ——————————– ———— ———— ———- ———-
    past01 683.2 61.4 2,173 395,473
    SYS$BACKGROUND 0.0 0.0 77 14,132
    SYS$USERS 0.0 0.0 0 0
    ————————————————————-

    Service Wait Class Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Wait Class info for services in the Service Statistics section.
    -> Total Waits and Time Waited displayed for the following wait
    classes: User I/O, Concurrency, Administrative, Network
    -> Time Waited (Wt Time) in centisecond (100th of a second)

    Service Name
    —————————————————————-
    User I/O User I/O Concurcy Concurcy Admin Admin Network Network
    Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
    ——— ——— ——— ——— ——— ——— ——— ———
    past01
    3659 1140 12 15 0 0 89262 211
    SYS$BACKGROUND
    93 198 1019 55148 0 0 0 0
    SYS$USERS
    0 0 0 0 0 0 0 0
    ————————————————————-

    ^LSQL ordered by Elapsed Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by CPU Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Gets DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Executions DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Parse Calls DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Sharable Memory DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Version Count DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    CPU used by this session 5,714 1.6 0.8
    CPU used when call started 4,106 1.1 0.6
    CR blocks created 154 0.0 0.0
    Cached Commit SCN referenced 0 0.0 0.0
    Commit SCN cached 0 0.0 0.0
    DB time 21,649 5.9 3.1
    DBWR checkpoint buffers written 10,388 2.8 1.5
    DBWR checkpoints 1 0.0 0.0
    DBWR revisited being-written buf 0 0.0 0.0
    DBWR tablespace checkpoint buffe 0 0.0 0.0
    DBWR thread checkpoint buffers w 0 0.0 0.0
    DBWR transaction table writes 116 0.0 0.0
    DBWR undo block writes 3,307 0.9 0.5
    IMU CR rollbacks 62 0.0 0.0
    IMU Flushes 3,123 0.9 0.5
    IMU Redo allocation size 15,614,600 4,238.2 2,226.2
    IMU commits 2,388 0.7 0.3
    IMU contention 590 0.2 0.1
    IMU ktichg flush 0 0.0 0.0
    IMU pool not allocated 1,656 0.5 0.2
    IMU recursive-transaction flush 29 0.0 0.0
    IMU undo allocation size 36,313,872 9,856.6 5,177.3
    IMU- failed to get a private str 1,656 0.5 0.2
    Misses for writing mapping 0 0.0 0.0
    SMON posted for undo segment shr 2 0.0 0.0
    SQL*Net roundtrips to/from clien 162,371 44.1 23.2
    active txn count during cleanout 1,570 0.4 0.2
    application wait time 58,932 16.0 8.4
    background checkpoints completed 1 0.0 0.0
    background checkpoints started 1 0.0 0.0
    background timeouts 11,825 3.2 1.7
    branch node splits 3 0.0 0.0
    buffer is not pinned count 12,866 3.5 1.8
    buffer is pinned count 653 0.2 0.1
    bytes received via SQL*Net from 33,602,391 9,120.6 4,790.8
    bytes sent via SQL*Net to client 351,226,114,381 95,332,272.7 50,075,009.2
    calls to get snapshot scn: kcmgs 80,395 21.8 11.5
    calls to kcmgas 9,763 2.7 1.4
    calls to kcmgcs 1,042 0.3 0.2
    change write time 702 0.2 0.1
    cleanout – number of ktugct call 3,160 0.9 0.5
    cleanouts and rollbacks – consis 122 0.0 0.0
    cleanouts only – consistent read 101 0.0 0.0
    cluster key scan block gets 6,186 1.7 0.9
    cluster key scans 88 0.0 0.0
    commit batch/immediate performed 1 0.0 0.0
    commit batch/immediate requested 1 0.0 0.0
    commit cleanout failures: block 0 0.0 0.0
    commit cleanout failures: buffer 7 0.0 0.0
    commit cleanout failures: callba 47 0.0 0.0
    commit cleanout failures: cannot 970 0.3 0.1
    commit cleanouts 85,915 23.3 12.3
    commit cleanouts successfully co 84,891 23.0 12.1
    commit immediate performed 1 0.0 0.0
    commit immediate requested 1 0.0 0.0
    commit txn count during cleanout 7,397 2.0 1.1
    concurrency wait time 55,261 15.0 7.9
    consistent changes 188 0.1 0.0
    consistent gets 56,293 15.3 8.0
    consistent gets – examination 29,215 7.9 4.2
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    consistent gets direct 1,228 0.3 0.2
    consistent gets from cache 55,065 15.0 7.9
    current blocks converted for CR 0 0.0 0.0
    cursor authentications 16 0.0 0.0
    data blocks consistent reads – u 154 0.0 0.0
    db block changes 225,649 61.3 32.2
    db block gets 353,197 95.9 50.4
    db block gets direct 744 0.2 0.1
    db block gets from cache 352,453 95.7 50.3
    deferred (CURRENT) block cleanou 33,116 9.0 4.7
    dirty buffers inspected 0 0.0 0.0
    enqueue conversions 9,494 2.6 1.4
    enqueue releases 53,907 14.6 7.7
    enqueue requests 53,911 14.6 7.7
    enqueue timeouts 0 0.0 0.0
    enqueue waits 58 0.0 0.0
    exchange deadlocks 0 0.0 0.0
    execute count 45,487 12.4 6.5
    failed probes on index block rec 8 0.0 0.0
    free buffer inspected 3,137 0.9 0.5
    free buffer requested 2,835 0.8 0.4
    heap block compress 1,450 0.4 0.2
    hot buffers moved to head of LRU 2,713 0.7 0.4
    immediate (CR) block cleanout ap 223 0.1 0.0
    immediate (CURRENT) block cleano 9,099 2.5 1.3
    index fast full scans (full) 0 0.0 0.0
    index fetch by key 11,957 3.3 1.7
    index scans kdiixs1 4,509 1.2 0.6
    leaf node 90-10 splits 100 0.0 0.0
    leaf node splits 253 0.1 0.0
    lob reads 0 0.0 0.0
    lob writes 8,641 2.4 1.2
    lob writes unaligned 8,099 2.2 1.2
    logons cumulative 2 0.0 0.0
    messages received 12,234 3.3 1.7
    messages sent 12,226 3.3 1.7
    no buffer to keep pinned count 0 0.0 0.0
    no work – consistent read gets 10,282 2.8 1.5
    opened cursors cumulative 43,105 11.7 6.2
    parse count (failures) 2 0.0 0.0
    parse count (hard) 17 0.0 0.0
    parse count (total) 43,001 11.7 6.1
    parse time cpu 327 0.1 0.1
    parse time elapsed 365 0.1 0.1
    physical read IO requests 2,257 0.6 0.3
    physical read bytes 18,489,344 5,018.5 2,636.1
    physical read total IO requests 3,817 1.0 0.5
    physical read total bytes 128,934,400 34,996.3 18,382.4
    physical read total multi block 83 0.0 0.0
    physical reads 2,257 0.6 0.3
    physical reads cache 1,198 0.3 0.2
    physical reads cache prefetch 0 0.0 0.0
    physical reads direct 1,059 0.3 0.2
    physical reads direct (lob) 307 0.1 0.0
    physical reads direct temporary 0 0.0 0.0
    physical reads prefetch warmup 0 0.0 0.0
    physical write IO requests 5,271 1.4 0.8
    physical write bytes 91,258,880 24,770.1 13,011.0
    physical write total IO requests 23,440 6.4 3.3
    physical write total bytes 359,137,792 97,479.7 51,203.0
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    physical write total multi block 15,662 4.3 2.2
    physical writes 11,140 3.0 1.6
    physical writes direct 752 0.2 0.1
    physical writes direct (lob) 744 0.2 0.1
    physical writes direct temporary 0 0.0 0.0
    physical writes from cache 10,388 2.8 1.5
    physical writes non checkpoint 3,018 0.8 0.4
    pinned buffers inspected 0 0.0 0.0
    prefetch warmup blocks aged out 0 0.0 0.0
    prefetched blocks aged out befor 0 0.0 0.0
    process last non-idle time 0 0.0 0.0
    recursive aborts on index block 0 0.0 0.0
    recursive calls 31,558 8.6 4.5
    recursive cpu usage 549 0.2 0.1
    redo blocks written 137,218 37.2 19.6
    redo buffer allocation retries 30 0.0 0.0
    redo entries 88,315 24.0 12.6
    redo log space requests 30 0.0 0.0
    redo log space wait time 60 0.0 0.0
    redo ordering marks 718 0.2 0.1
    redo size 65,921,652 17,892.9 9,398.6
    redo synch time 4,467 1.2 0.6
    redo synch writes 13,185 3.6 1.9
    redo wastage 2,077,560 563.9 296.2
    redo write time 4,842 1.3 0.7
    redo writer latching time 1 0.0 0.0
    redo writes 7,758 2.1 1.1
    rollback changes – undo records 3 0.0 0.0
    rollbacks only – consistent read 32 0.0 0.0
    rows fetched via callback 2,789 0.8 0.4
    session connect time 0 0.0 0.0
    session cursor cache hits 1,383 0.4 0.2
    session logical reads 409,490 111.2 58.4
    session pga memory 148,128 40.2 21.1
    session pga memory max 82,592 22.4 11.8
    session uga memory 120,688 32.8 17.2
    session uga memory max 4,495,016 1,220.1 640.9
    shared hash latch upgrades – no 5,066 1.4 0.7
    shared hash latch upgrades – wai 0 0.0 0.0
    sorts (disk) 0 0.0 0.0
    sorts (memory) 1,678 0.5 0.2
    sorts (rows) 12,693 3.5 1.8
    sql area evicted 1 0.0 0.0
    sql area purged 2 0.0 0.0
    summed dirty queue length 0 0.0 0.0
    switch current to new buffer 437 0.1 0.1
    table fetch by rowid 3,325 0.9 0.5
    table fetch continued row 8 0.0 0.0
    table scan blocks gotten 2,129 0.6 0.3
    table scan rows gotten 46,470 12.6 6.6
    table scans (cache partitions) 0 0.0 0.0
    table scans (long tables) 0 0.0 0.0
    table scans (short tables) 253 0.1 0.0
    total number of times SMON poste 2 0.0 0.0
    transaction rollbacks 1 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    undo change vector size 22,732,468 6,170.2 3,241.0
    user I/O wait time 1,365 0.4 0.2
    user calls 122,556 33.3 17.5
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    user commits 7,013 1.9 1.0
    user rollbacks 1 0.0 0.0
    workarea executions – onepass 0 0.0 0.0
    workarea executions – optimal 437 0.1 0.1
    write clones created in backgrou 0 0.0 0.0
    write clones created in foregrou 6 0.0 0.0
    ————————————————————-

    ^LInstance Activity Stats – Absolute ValuesDB/Inst: PAST01/past01 Snaps: 8218-
    -> Statistics with absolute values (should not be diffed)

    Statistic Begin Value End Value
    ——————————– ————— —————
    session cursor cache count 87,642 87,682
    opened cursors current 53 56
    workarea memory allocated 116 116
    logons current 28 28
    ————————————————————-

    Instance Activity Stats – Thread ActivityDB/Inst: PAST01/past01 Snaps: 8218-8
    -> Statistics identified by ‘(derived)’ come from sources other than SYSSTAT

    Statistic Total per Hour
    ——————————– —————— ———
    log switches (derived) 1 .98
    ————————————————————-

    ^LTablespace IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    PAS_DATA
    2,175 1 5.3 1.0 4,707 1 0 0.0
    UNDOTBS
    2 0 0.0 1.0 339 0 0 0.0
    SYSAUX
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM
    21 0 23.3 1.0 75 0 0 0.0
    INDX
    1 0 0.0 1.0 1 0 0 0.0
    USERS
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LFile IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by Tablespace, File

    Tablespace Filename
    ———————— —————————————————-
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    INDX /dborafiles/vdc/pas/past01/oradata01/indx01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata01/pasdata01.dbf
    1,488 0 6.4 1.0 2,277 1 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata02/pasdata02.dbf
    687 0 2.8 1.0 2,430 1 0 0.0
    SYSAUX /dborafiles/vdc/pas/past01/oradata01/sysaux01.dbf
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM /dborafiles/vdc/pas/past01/oradata01/system01.dbf
    21 0 23.3 1.0 75 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata01/undotbs01.dbf
    1 0 0.0 1.0 236 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata02/undotbs02.dbf
    1 0 0.0 1.0 103 0 0 0.0
    USERS /dborafiles/vdc/pas/past01/oradata01/users01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LBuffer Pool Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Standard block size Pools D: default, K: keep, R: recycle
    -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

    Free Writ Buffer
    Number of Pool Buffer Physical Physical Buff Comp Busy
    P Buffers Hit% Gets Reads Writes Wait Wait Waits
    — ———- —- ————– ———— ———– —- —- ———-
    D 17,847 100 407,487 1,182 10,388 0 0 0
    ————————————————————-

    Instance Recovery Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snapshot, E: End snapshot

    Targt Estd Log File Log Ckpt Log Ckpt
    MTTR MTTR Recovery Actual Target Size Timeout Interval
    (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
    – —– —– ———- ——— ——— ———- ——— ————
    B 0 19 771 11520 68786 552960 68786 N/A
    E 0 19 153 356 57847 552960 57847 N/A
    ————————————————————-

    Buffer Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> Only rows with estimated physical reads >0 are displayed
    -> ordered by Block Size, Buffers For Estimate

    Est
    Phys
    Size for Size Buffers for Read Estimated
    P Est (M) Factor Estimate Factor Physical Reads
    — ——– —— —————- —— ——————
    D 16 .1 1,983 1.2 51,598,018
    D 32 .2 3,966 1.1 46,297,341
    D 48 .3 5,949 1.1 45,547,576
    D 64 .4 7,932 1.0 44,976,656
    D 80 .6 9,915 1.0 43,778,798
    D 96 .7 11,898 1.0 43,438,238
    D 112 .8 13,881 1.0 43,245,302
    D 128 .9 15,864 1.0 43,070,456
    D 144 1.0 17,847 1.0 42,890,301
    D 160 1.1 19,830 1.0 42,771,297
    D 176 1.2 21,813 1.0 42,667,937
    D 192 1.3 23,796 1.0 42,602,022
    D 208 1.4 25,779 1.0 42,552,691
    D 224 1.6 27,762 1.0 42,509,345
    D 240 1.7 29,745 1.0 42,433,796
    D 256 1.8 31,728 1.0 42,319,599
    D 272 1.9 33,711 1.0 42,273,588
    D 288 2.0 35,694 1.0 42,036,564
    ————————————————————-

    ^LPGA Aggr Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> PGA cache hit % – percentage of W/A (WorkArea) data processed only in-memory

    PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
    ————— —————— ————————–
    100.0 8 0
    ————————————————————-

    PGA Aggr Target Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snap E: End snap (rows dentified with B or E contain data
    which is absolute i.e. not diffed over the interval)
    -> Auto PGA Target – actual workarea memory target
    -> W/A PGA Used – amount of memory used for all Workareas (manual + auto)
    -> %PGA W/A Mem – percentage of PGA memory allocated to workareas
    -> %Auto W/A Mem – percentage of workarea memory controlled by Auto Mem Mgmt
    -> %Man W/A Mem – percentage of workarea memory under manual control

    %PGA %Auto %Man
    PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
    Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
    – ———- ———- ———- ———- —— —— —— ———-
    B 191 112 143.5 0.1 .1 100.0 .0 39,062
    E 191 112 143.2 0.1 .1 100.0 .0 39,062
    ————————————————————-

    PGA Aggr Target Histogram DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Optimal Executions are purely in-memory operations

    Low High
    Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
    ——- ——- ————– ————– ———— ————
    2K 4K 426 426 0 0
    64K 128K 3 3 0 0
    512K 1024K 8 8 0 0
    ————————————————————-

    PGA Memory Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
    where Estd PGA Overalloc Count is 0

    Estd Extra Estd PGA Estd PGA
    PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
    Est (MB) Factr Processed Written to Disk Hit % Count
    ———- ——- —————- —————- ——– ———-
    24 0.1 34,432.9 12,717.5 73.0 1,149
    48 0.3 34,432.9 12,596.6 73.0 1,119
    95 0.5 34,432.9 2,571.6 93.0 77
    143 0.8 34,432.9 1,736.6 95.0 15
    191 1.0 34,432.9 1,701.5 95.0 0
    229 1.2 34,432.9 1,369.8 96.0 0
    267 1.4 34,432.9 1,117.5 97.0 0
    305 1.6 34,432.9 1,062.1 97.0 0
    343 1.8 34,432.9 935.6 97.0 0
    381 2.0 34,432.9 935.6 97.0 0
    572 3.0 34,432.9 935.6 97.0 0
    763 4.0 34,432.9 935.6 97.0 0
    1,144 6.0 34,432.9 935.6 97.0 0
    1,526 8.0 34,432.9 935.6 97.0 0
    ————————————————————-

    ^LShared Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
    -> Note there is often a 1:Many correlation between a single logical object
    in the Library Cache, and the physical number of memory objects associated
    with it. Therefore comparing the number of Lib Cache objects (e.g. in
    v$librarycache), with the number of Lib Cache Memory Objects is invalid.

    Est LC Est LC Est LC Est LC
    Shared SP Est LC Time Time Load Load Est LC
    Pool Size Size Est LC Saved Saved Time Time Mem
    Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
    ———- —– ——– ———— ——- —— ——- —— ———–
    272 .5 73 11,202 ####### 1.0 76,690 11.1 ###########
    336 .6 131 13,875 ####### 1.0 16,668 2.4 ###########
    400 .7 194 19,044 ####### 1.0 7,876 1.1 ###########
    464 .8 255 24,348 ####### 1.0 6,931 1.0 ###########
    528 .9 318 30,057 ####### 1.0 6,915 1.0 ###########
    592 1.0 381 36,589 ####### 1.0 6,913 1.0 ###########
    656 1.1 444 42,390 ####### 1.0 6,908 1.0 ###########
    720 1.2 507 48,666 ####### 1.0 6,903 1.0 ###########
    784 1.3 570 54,758 ####### 1.0 6,903 1.0 ###########
    848 1.4 633 60,324 ####### 1.0 6,902 1.0 ###########
    912 1.5 663 64,007 ####### 1.0 6,902 1.0 ###########
    976 1.6 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,040 1.8 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,104 1.9 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,168 2.0 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,232 2.1 663 64,007 ####### 1.0 6,902 1.0 ###########
    ————————————————————-

    SGA Target Advisory DB/Inst: PAST01/past01 Snap: 8219

    SGA Target SGA Size Est DB Est Physical
    Size (M) Factor Time (s) Reads
    ———- ———- ———— —————-
    612 0.8 354,230 43,760,951
    816 1.0 347,421 42,890,278
    1,020 1.3 347,386 42,890,278
    1,224 1.5 347,386 42,890,278
    1,428 1.8 347,386 42,890,278
    1,632 2.0 347,386 42,890,278
    ————————————————————-

    Streams Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Java Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Buffer Wait Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LEnqueue Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only enqueues with waits are shown
    -> Enqueue stats gathered prior to 10g should not be compared with 10g data
    -> ordered by Wait Time desc, Waits desc

    Enqueue Type (Request Reason)
    ——————————————————————————
    Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
    ———— ———— ———– ———– ———— ————–
    TX-Transaction (row lock contention)
    58 56 0 56 114 2,044.46
    PR-Process Startup
    38 38 0 2 83 41,350.00
    ————————————————————-

    ^LUndo Segment Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Min/Max TR (mins) – Min and Max Tuned Retention (minutes)
    -> STO – Snapshot Too Old count, OOS – Out of Space count
    -> Undo segment block stats:
    -> uS – unexpired Stolen, uR – unexpired Released, uU – unexpired reUsed
    -> eS – expired Stolen, eR – expired Released, eU – expired reUsed

    Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
    TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU
    —- ———- ————— ——– ——– ——— —– ————–
    1 3.2 8,231 0 4 120/120 0/0 0/0/0/0/0/0
    ————————————————————-

    Undo Segment Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Most recent 35 Undostat rows, ordered by Time desc

    Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
    End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
    ———— ———– ———— ——- ——- ——- —– ————
    24-Jan 19:56 529 1,371 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:46 525 1,339 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:36 520 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:26 513 1,342 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:16 521 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:06 549 1,449 0 4 120 0/0 0/0/0/0/0/0
    ————————————————————-

    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    AWR Alerted Metric Eleme 13,594 0.0 N/A 0 0 N/A
    Consistent RBA 7,759 0.0 N/A 0 0 N/A
    FAL request queue 76 0.0 N/A 0 0 N/A
    FAL subheap alocation 76 0.0 N/A 0 0 N/A
    FIB s.o chain latch 10 0.0 N/A 0 0 N/A
    FOB s.o list latch 39 0.0 N/A 0 0 N/A
    In memory undo latch 57,797 0.0 N/A 0 7,751 0.0
    JS mem alloc latch 8 0.0 N/A 0 0 N/A
    JS queue access latch 8 0.0 N/A 0 0 N/A
    JS queue state obj latch 20,610 0.0 N/A 0 0 N/A
    KMG MMAN ready and start 1,255 0.0 N/A 0 0 N/A
    KMG resize request state 22 0.0 N/A 0 0 N/A
    KTF sga latch 9 0.0 N/A 0 1,000 0.0
    MQL Tracking Latch 0 N/A N/A 0 73 0.0
    Memory Management Latch 44 0.0 N/A 0 1,244 0.0
    OS process 325 0.0 N/A 0 0 N/A
    OS process allocation 1,456 0.0 N/A 0 0 N/A
    OS process: request allo 71 0.0 N/A 0 0 N/A
    PL/SQL warning settings 3 0.0 N/A 0 0 N/A
    SQL memory manager latch 1 0.0 N/A 0 1,230 0.0
    SQL memory manager worka 82,537 0.0 N/A 0 0 N/A
    Shared B-Tree 132 0.0 N/A 0 0 N/A
    active checkpoint queue 5,758 0.0 N/A 0 0 N/A
    active service list 6,300 0.0 N/A 0 1,140 0.0
    archive control 65 0.0 N/A 0 0 N/A
    archive process latch 1,306 0.0 N/A 0 0 N/A
    begin backup scn array 743 0.0 N/A 0 0 N/A
    cache buffer handles 12 0.0 N/A 0 0 N/A
    cache buffers chains 1,531,075 0.0 0.7 0 2,596 0.0
    cache buffers lru chain 34,429 0.0 1.0 0 422 0.0
    channel handle pool latc 69 0.0 N/A 0 0 N/A
    channel operations paren 17,236 0.0 N/A 0 0 N/A
    checkpoint queue latch 49,900 0.0 0.7 0 8,766 0.0
    client/application info 2 0.0 N/A 0 0 N/A
    compile environment latc 12,491 0.0 N/A 0 0 N/A
    dml lock allocation 42,716 0.0 0.0 0 0 N/A
    dummy allocation 4 0.0 N/A 0 0 N/A
    enqueue hash chains 117,642 0.0 0.3 0 1,404 0.1
    enqueues 61,315 0.0 N/A 0 0 N/A
    event group latch 38 0.0 N/A 0 0 N/A
    file cache latch 90 0.0 N/A 0 0 N/A
    hash table column usage 33 0.0 N/A 0 171 0.0
    hash table modification 54 0.0 N/A 0 0 N/A
    job_queue_processes para 57 0.0 N/A 0 0 N/A
    kks stats 15 0.0 N/A 0 0 N/A
    kmcptab latch 110 0.0 N/A 0 0 N/A
    kmcpvec latch 0 N/A N/A 0 110 0.0
    ksuosstats global area 249 0.0 N/A 0 0 N/A
    ktm global data 19 0.0 N/A 0 0 N/A
    kwqbsn:qsga 132 0.0 N/A 0 0 N/A
    lgwr LWN SCN 8,445 0.1 0.0 0 0 N/A
    library cache 261,487 0.0 2.0 0 0 N/A
    library cache load lock 28 0.0 N/A 0 0 N/A
    library cache lock 209,307 0.0 N/A 0 0 N/A
    library cache lock alloc 40 0.0 N/A 0 0 N/A
    library cache pin 88,014 0.0 N/A 0 0 N/A
    library cache pin alloca 2 0.0 N/A 0 0 N/A
    list of block allocation 573 0.0 N/A 0 0 N/A
    loader state object free 3,342 0.0 N/A 0 0 N/A
    messages 55,816 0.0 0.3 0 0 N/A
    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    mostly latch-free SCN 8,440 0.0 N/A 0 0 N/A
    ncodef allocation latch 55 0.0 N/A 0 0 N/A
    object queue header heap 12 0.0 N/A 0 0 N/A
    object queue header oper 36,326 0.0 N/A 0 0 N/A
    object stats modificatio 1 0.0 N/A 0 0 N/A
    parallel query alloc buf 492 0.0 N/A 0 0 N/A
    parameter table allocati 2 0.0 N/A 0 0 N/A
    post/wait queue 11,510 0.0 N/A 0 7,581 0.0
    process allocation 71 0.0 N/A 0 38 0.0
    process group creation 69 0.0 N/A 0 0 N/A
    qmn task queue latch 528 0.0 N/A 0 0 N/A
    redo allocation 38,681 0.0 0.5 0 88,349 0.0
    redo copy 0 N/A N/A 0 88,362 0.0
    redo writing 31,697 0.0 0.8 0 0 N/A
    resmgr:actses active lis 1 0.0 N/A 0 0 N/A
    resmgr:schema config 1 0.0 N/A 0 0 N/A
    row cache objects 12,389 0.0 N/A 0 0 N/A
    sequence cache 63,574 0.0 N/A 0 0 N/A
    session allocation 30,669 0.0 1.0 15 0 N/A
    session idle bit 257,599 0.0 N/A 0 0 N/A
    session state list latch 8 0.0 N/A 0 0 N/A
    session switching 55 0.0 N/A 0 0 N/A
    session timer 1,140 0.0 N/A 0 0 N/A
    shared pool 8,477 0.2 57.1 535 0 N/A
    shared pool sim alloc 2 0.0 N/A 0 0 N/A
    shared pool simulator 6,517 0.0 N/A 0 0 N/A
    simulator hash latch 30,800 0.0 N/A 0 0 N/A
    simulator lru latch 29,707 0.0 N/A 0 897 0.0
    slave class 2 0.0 N/A 0 0 N/A
    slave class create 8 12.5 1.0 0 0 N/A
    sort extent pool 88 0.0 N/A 0 0 N/A
    state object free list 2 0.0 N/A 0 0 N/A
    statistics aggregation 112 0.0 N/A 0 0 N/A
    threshold alerts latch 168 0.0 N/A 0 0 N/A
    transaction allocation 415 0.0 N/A 0 0 N/A
    transaction branch alloc 55 0.0 N/A 0 0 N/A
    undo global data 41,288 0.0 N/A 0 0 N/A
    virtual circuit buffers 738,709 0.1 0.0 0 0 N/A
    virtual circuit queues 312,136 0.0 0.0 0 0 N/A
    virtual circuits 155,447 0.0 N/A 0 0 N/A
    ————————————————————-

    ^LLatch Sleep Breakdown DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by misses desc

    Latch Name
    —————————————-
    Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
    ————– ———– ———– ———- ——– ——– ——–
    virtual circuit buffers
    738,709 619 9 610 0 0 0
    virtual circuit queues
    312,136 100 3 97 0 0 0
    shared pool
    8,477 17 970 1 0 0 0
    cache buffers chains
    1,531,075 10 7 3 0 0 0
    session allocation
    30,669 5 5 0 0 0 0
    redo allocation
    38,681 4 2 2 0 0 0
    redo writing
    31,697 4 3 1 0 0 0
    cache buffers lru chain
    34,429 3 3 0 0 0 0
    checkpoint queue latch
    49,900 3 2 1 0 0 0
    enqueue hash chains
    117,642 3 1 2 0 0 0
    library cache
    261,487 3 6 0 0 0 0
    messages
    55,816 3 1 2 0 0 0
    slave class create
    8 1 1 0 0 0 0
    ————————————————————-

    ^LLatch Miss Sources DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

    NoWait Waiter
    Latch Name Where Misses Sleeps Sleeps
    ———————— ————————– ——- ———- ——–
    cache buffers chains kcbnlc 0 8 0
    cache buffers chains kcbget: pin buffer 0 1 0
    cache buffers lru chain kcbzgws_1 0 3 0
    checkpoint queue latch kcbklbc: Link buffer into 0 1 0
    checkpoint queue latch kcbkllrba: compute lowest 0 1 0
    enqueue hash chains ksqrcl 0 1 1
    library cache kglScanDependency 0 6 0
    messages ksarcv 0 1 1
    redo allocation kcrfw_redo_gen: redo alloc 0 2 0
    redo writing kcrfsr: rba scn pair 0 2 0
    redo writing kcrfwcr 0 1 0
    session allocation ksucrp 0 2 1
    session allocation ksucri 0 1 1
    session allocation ksuprc 0 1 1
    session allocation ksuxds: not user session 0 1 1
    shared pool kghdmp 0 947 0
    shared pool kghalo 0 22 944
    shared pool kghupr1 0 1 4
    slave class create ksvcreate 0 1 0
    virtual circuit queues kmcfsq 0 3 0
    virtual circuits kmcgms: if called with non 0 4 0
    virtual circuits kmcgms: if shared server 0 4 2
    virtual circuits kmcmbf 0 1 2
    ————————————————————-

    ^LParent Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Child Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Logical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Physical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Row Lock Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by ITL Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Buffer Busy Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LDictionary Cache Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Pct Misses” should be very low ( “Final Usage” is the number of cache entries being used

    Get Pct Scan Pct Mod Final
    Cache Requests Miss Reqs Miss Reqs Usage
    ————————- ———— —— ——- —– ——– ———-
    dc_awr_control 66 0.0 0 N/A 2 1
    dc_global_oids 8 0.0 0 N/A 0 33
    dc_histogram_data 73 47.9 0 N/A 0 62,380
    dc_histogram_defs 156 40.4 0 N/A 0 4,356
    dc_object_ids

  4. WORKLOAD REPOSITORY report for

    DB Name DB Id Instance Inst Num Release RAC Host
    ———— ———– ———— ——– ———– — ————
    PAST01 340786915 past01 1 10.2.0.2.0 NO vsl001a012

    Snap Id Snap Time Sessions Curs/Sess
    ——— ——————- ——– ———
    Begin Snap: 8218 24-Jan-10 19:00:50 28 1.9
    End Snap: 8219 24-Jan-10 20:02:14 28 2.0
    Elapsed: 61.40 (mins)
    DB Time: 11.49 (mins)

    Cache Sizes
    ~~~~~~~~~~~ Begin End
    ———- ———-
    Buffer Cache: 144M 144M Std Block Size: 8K
    Shared Pool Size: 592M 592M Log Buffer: 30,744K

    Load Profile
    ~~~~~~~~~~~~ Per Second Per Transaction
    ————— —————
    Redo size: 17,892.92 9,398.58
    Logical reads: 111.15 58.38
    Block changes: 61.25 32.17
    Physical reads: 0.61 0.32
    Physical writes: 3.02 1.59
    User calls: 33.27 17.47
    Parses: 11.67 6.13
    Hard parses: 0.00 0.00
    Sorts: 0.46 0.24
    Logons: 0.00 0.00
    Executes: 12.35 6.49
    Transactions: 1.90

    % Blocks changed per Read: 55.10 Recursive Call %: 20.48
    Rollback per transaction %: 0.01 Rows per Sort: 7.56

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 99.97
    Buffer Hit %: 99.78 In-memory Sort %: 100.00
    Library Hit %: 99.96 Soft Parse %: 99.96
    Execute to Parse %: 5.47 Latch Hit %: 99.98
    Parse CPU to Parse Elapsd %: 89.59 % Non-Parse CPU: 94.67

    Shared Pool Statistics Begin End
    —— ——
    Memory Usage %: 90.97 91.05
    % SQL with executions>1: 99.16 99.12
    % Memory for SQL w/exec>1: 90.60 90.75

    Top 5 Timed Events Avg %Total
    ~~~~~~~~~~~~~~~~~~ wait Call
    Event Waits Time (s) (ms) Time Wait Class
    —————————— ———— ———– —— —— ———-
    enq: TX – row lock contention 249 589 2367 85.5 Applicatio
    latch: shared pool 970 535 551 77.6 Concurrenc
    enq: PR – contention 29 81 2783 11.7 Other
    CPU time 61 8.9
    log file parallel write 7,758 47 6 6.8 System I/O
    ————————————————————-
    ^LTime Model Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Total time in database user-calls (DB Time): 689.1s
    -> Statistics including the word “background” measure background process
    time, and so do not contribute to the DB time statistic
    -> Ordered by % or DB time desc, Statistic name

    Statistic Name Time (s) % of DB Time
    —————————————— —————— ————
    sql execute elapsed time 628.7 91.2
    DB CPU 61.4 8.9
    parse time elapsed 6.0 .9
    hard parse elapsed time 2.4 .4
    failed parse (out of shared memory) elapse 2.2 .3
    failed parse elapsed time 2.2 .3
    hard parse (sharing criteria) elapsed time 0.2 .0
    sequence load elapsed time 0.1 .0
    hard parse (bind mismatch) elapsed time 0.0 .0
    repeated bind elapsed time 0.0 .0
    DB time 689.1 N/A
    background elapsed time 765.8 N/A
    background cpu time 58.4 N/A
    ————————————————————-

    Wait Class DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc

    Avg
    %Time Total Wait wait Waits
    Wait Class Waits -outs Time (s) (ms) /txn
    ——————– —————- —— —————- ——- ———
    Application 251 76.9 589 2348 0.0
    Concurrency 1,031 94.5 552 535 0.1
    Other 4,227 98.8 97 23 0.6
    System I/O 10,656 .0 68 6 1.5
    Commit 7,579 .0 43 6 1.1
    User I/O 3,753 .0 13 4 0.5
    Network 89,262 .0 2 0 12.7
    Configuration 5 .0 1 116 0.0
    ————————————————————-

    ^LWait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    enq: TX – row lock contentio 249 77.5 589 2367 0.0
    latch: shared pool 970 99.5 535 551 0.1
    enq: PR – contention 29 93.1 81 2783 0.0
    log file parallel write 7,758 .0 47 6 1.1
    log file sync 7,579 .0 43 6 1.1
    os thread startup 48 18.8 17 344 0.0
    latch: session allocation 5 .0 15 3077 0.0
    db file sequential read 1,944 .0 13 7 0.3
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    SQL*Net message to client 84,675 .0 2 0 12.1
    log file switch completion 2 .0 1 290 0.0
    ksdxexeotherwait 4,148 100.0 0 0 0.6
    SQL*Net more data from clien 4,587 .0 0 0 0.7
    latch: library cache 6 .0 0 24 0.0
    latch free 10 .0 0 14 0.0
    control file sequential read 1,461 .0 0 0 0.2
    direct path write 1,494 .0 0 0 0.2
    log file single write 4 .0 0 5 0.0
    SQL*Net break/reset to clien 2 .0 0 6 0.0
    SGA: allocation forcing comp 11 .0 0 1 0.0
    latch: cache buffers lru cha 3 .0 0 4 0.0
    direct path read 315 .0 0 0 0.0
    latch: checkpoint queue latc 2 .0 0 2 0.0
    latch: redo allocation 2 .0 0 1 0.0
    latch: cache buffers chains 7 .0 0 0 0.0
    latch: messages 1 .0 0 2 0.0
    LGWR wait for redo copy 11 .0 0 0 0.0
    rdbms ipc reply 1 .0 0 1 0.0
    latch: enqueue hash chains 1 100.0 0 1 0.0
    latch: redo writing 3 .0 0 0 0.0
    latch: virtual circuit queue 3 .0 0 0 0.0
    virtual circuit status 56,849 .1 3,940 69 8.1
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    SQL*Net message from client 84,649 .0 3,458 41 12.1
    ————————————————————-

    ^LBackground Wait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    latch: shared pool 970 99.5 535 551 0.1
    events in waitclass Other 4,204 99.3 90 21 0.6
    log file parallel write 7,758 .0 47 6 1.1
    os thread startup 49 20.4 18 357 0.0
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    db file sequential read 27 .0 2 62 0.0
    control file sequential read 803 .0 0 0 0.1
    log file single write 4 .0 0 5 0.0
    direct path write 8 .0 0 0 0.0
    latch: redo writing 3 .0 0 0 0.0
    direct path read 8 .0 0 0 0.0
    latch: cache buffers chains 1 .0 0 0 0.0
    rdbms ipc message 19,484 60.5 39,136 2009 2.8
    smon timer 15 86.7 3,823 254854 0.0
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    pmon timer 1,140 99.9 3,316 2909 0.2
    ————————————————————-

    Operating System Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total
    ——————————– ——————–
    BUSY_TIME 31,813
    IDLE_TIME 708,131
    IOWAIT_TIME 28,758
    NICE_TIME 0
    SYS_TIME 19,554
    USER_TIME 7,318
    LOAD 1
    RSRC_MGR_CPU_WAIT_TIME 0
    PHYSICAL_MEMORY_BYTES 2,048,012
    NUM_CPUS 2
    ————————————————————-

    ^LService Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by DB Time

    Physical Logical
    Service Name DB Time (s) DB CPU (s) Reads Reads
    ——————————– ———— ———— ———- ———-
    past01 683.2 61.4 2,173 395,473
    SYS$BACKGROUND 0.0 0.0 77 14,132
    SYS$USERS 0.0 0.0 0 0
    ————————————————————-

    Service Wait Class Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Wait Class info for services in the Service Statistics section.
    -> Total Waits and Time Waited displayed for the following wait
    classes: User I/O, Concurrency, Administrative, Network
    -> Time Waited (Wt Time) in centisecond (100th of a second)

    Service Name
    —————————————————————-
    User I/O User I/O Concurcy Concurcy Admin Admin Network Network
    Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
    ——— ——— ——— ——— ——— ——— ——— ———
    past01
    3659 1140 12 15 0 0 89262 211
    SYS$BACKGROUND
    93 198 1019 55148 0 0 0 0
    SYS$USERS
    0 0 0 0 0 0 0 0
    ————————————————————-

    ^LSQL ordered by Elapsed Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by CPU Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Gets DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Executions DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Parse Calls DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Sharable Memory DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Version Count DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    CPU used by this session 5,714 1.6 0.8
    CPU used when call started 4,106 1.1 0.6
    CR blocks created 154 0.0 0.0
    Cached Commit SCN referenced 0 0.0 0.0
    Commit SCN cached 0 0.0 0.0
    DB time 21,649 5.9 3.1
    DBWR checkpoint buffers written 10,388 2.8 1.5
    DBWR checkpoints 1 0.0 0.0
    DBWR revisited being-written buf 0 0.0 0.0
    DBWR tablespace checkpoint buffe 0 0.0 0.0
    DBWR thread checkpoint buffers w 0 0.0 0.0
    DBWR transaction table writes 116 0.0 0.0
    DBWR undo block writes 3,307 0.9 0.5
    IMU CR rollbacks 62 0.0 0.0
    IMU Flushes 3,123 0.9 0.5
    IMU Redo allocation size 15,614,600 4,238.2 2,226.2
    IMU commits 2,388 0.7 0.3
    IMU contention 590 0.2 0.1
    IMU ktichg flush 0 0.0 0.0
    IMU pool not allocated 1,656 0.5 0.2
    IMU recursive-transaction flush 29 0.0 0.0
    IMU undo allocation size 36,313,872 9,856.6 5,177.3
    IMU- failed to get a private str 1,656 0.5 0.2
    Misses for writing mapping 0 0.0 0.0
    SMON posted for undo segment shr 2 0.0 0.0
    SQL*Net roundtrips to/from clien 162,371 44.1 23.2
    active txn count during cleanout 1,570 0.4 0.2
    application wait time 58,932 16.0 8.4
    background checkpoints completed 1 0.0 0.0
    background checkpoints started 1 0.0 0.0
    background timeouts 11,825 3.2 1.7
    branch node splits 3 0.0 0.0
    buffer is not pinned count 12,866 3.5 1.8
    buffer is pinned count 653 0.2 0.1
    bytes received via SQL*Net from 33,602,391 9,120.6 4,790.8
    bytes sent via SQL*Net to client 351,226,114,381 95,332,272.7 50,075,009.2
    calls to get snapshot scn: kcmgs 80,395 21.8 11.5
    calls to kcmgas 9,763 2.7 1.4
    calls to kcmgcs 1,042 0.3 0.2
    change write time 702 0.2 0.1
    cleanout – number of ktugct call 3,160 0.9 0.5
    cleanouts and rollbacks – consis 122 0.0 0.0
    cleanouts only – consistent read 101 0.0 0.0
    cluster key scan block gets 6,186 1.7 0.9
    cluster key scans 88 0.0 0.0
    commit batch/immediate performed 1 0.0 0.0
    commit batch/immediate requested 1 0.0 0.0
    commit cleanout failures: block 0 0.0 0.0
    commit cleanout failures: buffer 7 0.0 0.0
    commit cleanout failures: callba 47 0.0 0.0
    commit cleanout failures: cannot 970 0.3 0.1
    commit cleanouts 85,915 23.3 12.3
    commit cleanouts successfully co 84,891 23.0 12.1
    commit immediate performed 1 0.0 0.0
    commit immediate requested 1 0.0 0.0
    commit txn count during cleanout 7,397 2.0 1.1
    concurrency wait time 55,261 15.0 7.9
    consistent changes 188 0.1 0.0
    consistent gets 56,293 15.3 8.0
    consistent gets – examination 29,215 7.9 4.2
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    consistent gets direct 1,228 0.3 0.2
    consistent gets from cache 55,065 15.0 7.9
    current blocks converted for CR 0 0.0 0.0
    cursor authentications 16 0.0 0.0
    data blocks consistent reads – u 154 0.0 0.0
    db block changes 225,649 61.3 32.2
    db block gets 353,197 95.9 50.4
    db block gets direct 744 0.2 0.1
    db block gets from cache 352,453 95.7 50.3
    deferred (CURRENT) block cleanou 33,116 9.0 4.7
    dirty buffers inspected 0 0.0 0.0
    enqueue conversions 9,494 2.6 1.4
    enqueue releases 53,907 14.6 7.7
    enqueue requests 53,911 14.6 7.7
    enqueue timeouts 0 0.0 0.0
    enqueue waits 58 0.0 0.0
    exchange deadlocks 0 0.0 0.0
    execute count 45,487 12.4 6.5
    failed probes on index block rec 8 0.0 0.0
    free buffer inspected 3,137 0.9 0.5
    free buffer requested 2,835 0.8 0.4
    heap block compress 1,450 0.4 0.2
    hot buffers moved to head of LRU 2,713 0.7 0.4
    immediate (CR) block cleanout ap 223 0.1 0.0
    immediate (CURRENT) block cleano 9,099 2.5 1.3
    index fast full scans (full) 0 0.0 0.0
    index fetch by key 11,957 3.3 1.7
    index scans kdiixs1 4,509 1.2 0.6
    leaf node 90-10 splits 100 0.0 0.0
    leaf node splits 253 0.1 0.0
    lob reads 0 0.0 0.0
    lob writes 8,641 2.4 1.2
    lob writes unaligned 8,099 2.2 1.2
    logons cumulative 2 0.0 0.0
    messages received 12,234 3.3 1.7
    messages sent 12,226 3.3 1.7
    no buffer to keep pinned count 0 0.0 0.0
    no work – consistent read gets 10,282 2.8 1.5
    opened cursors cumulative 43,105 11.7 6.2
    parse count (failures) 2 0.0 0.0
    parse count (hard) 17 0.0 0.0
    parse count (total) 43,001 11.7 6.1
    parse time cpu 327 0.1 0.1
    parse time elapsed 365 0.1 0.1
    physical read IO requests 2,257 0.6 0.3
    physical read bytes 18,489,344 5,018.5 2,636.1
    physical read total IO requests 3,817 1.0 0.5
    physical read total bytes 128,934,400 34,996.3 18,382.4
    physical read total multi block 83 0.0 0.0
    physical reads 2,257 0.6 0.3
    physical reads cache 1,198 0.3 0.2
    physical reads cache prefetch 0 0.0 0.0
    physical reads direct 1,059 0.3 0.2
    physical reads direct (lob) 307 0.1 0.0
    physical reads direct temporary 0 0.0 0.0
    physical reads prefetch warmup 0 0.0 0.0
    physical write IO requests 5,271 1.4 0.8
    physical write bytes 91,258,880 24,770.1 13,011.0
    physical write total IO requests 23,440 6.4 3.3
    physical write total bytes 359,137,792 97,479.7 51,203.0
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    physical write total multi block 15,662 4.3 2.2
    physical writes 11,140 3.0 1.6
    physical writes direct 752 0.2 0.1
    physical writes direct (lob) 744 0.2 0.1
    physical writes direct temporary 0 0.0 0.0
    physical writes from cache 10,388 2.8 1.5
    physical writes non checkpoint 3,018 0.8 0.4
    pinned buffers inspected 0 0.0 0.0
    prefetch warmup blocks aged out 0 0.0 0.0
    prefetched blocks aged out befor 0 0.0 0.0
    process last non-idle time 0 0.0 0.0
    recursive aborts on index block 0 0.0 0.0
    recursive calls 31,558 8.6 4.5
    recursive cpu usage 549 0.2 0.1
    redo blocks written 137,218 37.2 19.6
    redo buffer allocation retries 30 0.0 0.0
    redo entries 88,315 24.0 12.6
    redo log space requests 30 0.0 0.0
    redo log space wait time 60 0.0 0.0
    redo ordering marks 718 0.2 0.1
    redo size 65,921,652 17,892.9 9,398.6
    redo synch time 4,467 1.2 0.6
    redo synch writes 13,185 3.6 1.9
    redo wastage 2,077,560 563.9 296.2
    redo write time 4,842 1.3 0.7
    redo writer latching time 1 0.0 0.0
    redo writes 7,758 2.1 1.1
    rollback changes – undo records 3 0.0 0.0
    rollbacks only – consistent read 32 0.0 0.0
    rows fetched via callback 2,789 0.8 0.4
    session connect time 0 0.0 0.0
    session cursor cache hits 1,383 0.4 0.2
    session logical reads 409,490 111.2 58.4
    session pga memory 148,128 40.2 21.1
    session pga memory max 82,592 22.4 11.8
    session uga memory 120,688 32.8 17.2
    session uga memory max 4,495,016 1,220.1 640.9
    shared hash latch upgrades – no 5,066 1.4 0.7
    shared hash latch upgrades – wai 0 0.0 0.0
    sorts (disk) 0 0.0 0.0
    sorts (memory) 1,678 0.5 0.2
    sorts (rows) 12,693 3.5 1.8
    sql area evicted 1 0.0 0.0
    sql area purged 2 0.0 0.0
    summed dirty queue length 0 0.0 0.0
    switch current to new buffer 437 0.1 0.1
    table fetch by rowid 3,325 0.9 0.5
    table fetch continued row 8 0.0 0.0
    table scan blocks gotten 2,129 0.6 0.3
    table scan rows gotten 46,470 12.6 6.6
    table scans (cache partitions) 0 0.0 0.0
    table scans (long tables) 0 0.0 0.0
    table scans (short tables) 253 0.1 0.0
    total number of times SMON poste 2 0.0 0.0
    transaction rollbacks 1 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    undo change vector size 22,732,468 6,170.2 3,241.0
    user I/O wait time 1,365 0.4 0.2
    user calls 122,556 33.3 17.5
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    user commits 7,013 1.9 1.0
    user rollbacks 1 0.0 0.0
    workarea executions – onepass 0 0.0 0.0
    workarea executions – optimal 437 0.1 0.1
    write clones created in backgrou 0 0.0 0.0
    write clones created in foregrou 6 0.0 0.0
    ————————————————————-

    ^LInstance Activity Stats – Absolute ValuesDB/Inst: PAST01/past01 Snaps: 8218-
    -> Statistics with absolute values (should not be diffed)

    Statistic Begin Value End Value
    ——————————– ————— —————
    session cursor cache count 87,642 87,682
    opened cursors current 53 56
    workarea memory allocated 116 116
    logons current 28 28
    ————————————————————-

    Instance Activity Stats – Thread ActivityDB/Inst: PAST01/past01 Snaps: 8218-8
    -> Statistics identified by ‘(derived)’ come from sources other than SYSSTAT

    Statistic Total per Hour
    ——————————– —————— ———
    log switches (derived) 1 .98
    ————————————————————-

    ^LTablespace IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    PAS_DATA
    2,175 1 5.3 1.0 4,707 1 0 0.0
    UNDOTBS
    2 0 0.0 1.0 339 0 0 0.0
    SYSAUX
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM
    21 0 23.3 1.0 75 0 0 0.0
    INDX
    1 0 0.0 1.0 1 0 0 0.0
    USERS
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LFile IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by Tablespace, File

    Tablespace Filename
    ———————— —————————————————-
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    INDX /dborafiles/vdc/pas/past01/oradata01/indx01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata01/pasdata01.dbf
    1,488 0 6.4 1.0 2,277 1 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata02/pasdata02.dbf
    687 0 2.8 1.0 2,430 1 0 0.0
    SYSAUX /dborafiles/vdc/pas/past01/oradata01/sysaux01.dbf
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM /dborafiles/vdc/pas/past01/oradata01/system01.dbf
    21 0 23.3 1.0 75 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata01/undotbs01.dbf
    1 0 0.0 1.0 236 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata02/undotbs02.dbf
    1 0 0.0 1.0 103 0 0 0.0
    USERS /dborafiles/vdc/pas/past01/oradata01/users01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LBuffer Pool Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Standard block size Pools D: default, K: keep, R: recycle
    -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

    Free Writ Buffer
    Number of Pool Buffer Physical Physical Buff Comp Busy
    P Buffers Hit% Gets Reads Writes Wait Wait Waits
    — ———- —- ————– ———— ———– —- —- ———-
    D 17,847 100 407,487 1,182 10,388 0 0 0
    ————————————————————-

    Instance Recovery Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snapshot, E: End snapshot

    Targt Estd Log File Log Ckpt Log Ckpt
    MTTR MTTR Recovery Actual Target Size Timeout Interval
    (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
    – —– —– ———- ——— ——— ———- ——— ————
    B 0 19 771 11520 68786 552960 68786 N/A
    E 0 19 153 356 57847 552960 57847 N/A
    ————————————————————-

    Buffer Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> Only rows with estimated physical reads >0 are displayed
    -> ordered by Block Size, Buffers For Estimate

    Est
    Phys
    Size for Size Buffers for Read Estimated
    P Est (M) Factor Estimate Factor Physical Reads
    — ——– —— —————- —— ——————
    D 16 .1 1,983 1.2 51,598,018
    D 32 .2 3,966 1.1 46,297,341
    D 48 .3 5,949 1.1 45,547,576
    D 64 .4 7,932 1.0 44,976,656
    D 80 .6 9,915 1.0 43,778,798
    D 96 .7 11,898 1.0 43,438,238
    D 112 .8 13,881 1.0 43,245,302
    D 128 .9 15,864 1.0 43,070,456
    D 144 1.0 17,847 1.0 42,890,301
    D 160 1.1 19,830 1.0 42,771,297
    D 176 1.2 21,813 1.0 42,667,937
    D 192 1.3 23,796 1.0 42,602,022
    D 208 1.4 25,779 1.0 42,552,691
    D 224 1.6 27,762 1.0 42,509,345
    D 240 1.7 29,745 1.0 42,433,796
    D 256 1.8 31,728 1.0 42,319,599
    D 272 1.9 33,711 1.0 42,273,588
    D 288 2.0 35,694 1.0 42,036,564
    ————————————————————-

    ^LPGA Aggr Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> PGA cache hit % – percentage of W/A (WorkArea) data processed only in-memory

    PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
    ————— —————— ————————–
    100.0 8 0
    ————————————————————-

    PGA Aggr Target Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snap E: End snap (rows dentified with B or E contain data
    which is absolute i.e. not diffed over the interval)
    -> Auto PGA Target – actual workarea memory target
    -> W/A PGA Used – amount of memory used for all Workareas (manual + auto)
    -> %PGA W/A Mem – percentage of PGA memory allocated to workareas
    -> %Auto W/A Mem – percentage of workarea memory controlled by Auto Mem Mgmt
    -> %Man W/A Mem – percentage of workarea memory under manual control

    %PGA %Auto %Man
    PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
    Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
    – ———- ———- ———- ———- —— —— —— ———-
    B 191 112 143.5 0.1 .1 100.0 .0 39,062
    E 191 112 143.2 0.1 .1 100.0 .0 39,062
    ————————————————————-

    PGA Aggr Target Histogram DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Optimal Executions are purely in-memory operations

    Low High
    Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
    ——- ——- ————– ————– ———— ————
    2K 4K 426 426 0 0
    64K 128K 3 3 0 0
    512K 1024K 8 8 0 0
    ————————————————————-

    PGA Memory Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
    where Estd PGA Overalloc Count is 0

    Estd Extra Estd PGA Estd PGA
    PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
    Est (MB) Factr Processed Written to Disk Hit % Count
    ———- ——- —————- —————- ——– ———-
    24 0.1 34,432.9 12,717.5 73.0 1,149
    48 0.3 34,432.9 12,596.6 73.0 1,119
    95 0.5 34,432.9 2,571.6 93.0 77
    143 0.8 34,432.9 1,736.6 95.0 15
    191 1.0 34,432.9 1,701.5 95.0 0
    229 1.2 34,432.9 1,369.8 96.0 0
    267 1.4 34,432.9 1,117.5 97.0 0
    305 1.6 34,432.9 1,062.1 97.0 0
    343 1.8 34,432.9 935.6 97.0 0
    381 2.0 34,432.9 935.6 97.0 0
    572 3.0 34,432.9 935.6 97.0 0
    763 4.0 34,432.9 935.6 97.0 0
    1,144 6.0 34,432.9 935.6 97.0 0
    1,526 8.0 34,432.9 935.6 97.0 0
    ————————————————————-

    ^LShared Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
    -> Note there is often a 1:Many correlation between a single logical object
    in the Library Cache, and the physical number of memory objects associated
    with it. Therefore comparing the number of Lib Cache objects (e.g. in
    v$librarycache), with the number of Lib Cache Memory Objects is invalid.

    Est LC Est LC Est LC Est LC
    Shared SP Est LC Time Time Load Load Est LC
    Pool Size Size Est LC Saved Saved Time Time Mem
    Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
    ———- —– ——– ———— ——- —— ——- —— ———–
    272 .5 73 11,202 ####### 1.0 76,690 11.1 ###########
    336 .6 131 13,875 ####### 1.0 16,668 2.4 ###########
    400 .7 194 19,044 ####### 1.0 7,876 1.1 ###########
    464 .8 255 24,348 ####### 1.0 6,931 1.0 ###########
    528 .9 318 30,057 ####### 1.0 6,915 1.0 ###########
    592 1.0 381 36,589 ####### 1.0 6,913 1.0 ###########
    656 1.1 444 42,390 ####### 1.0 6,908 1.0 ###########
    720 1.2 507 48,666 ####### 1.0 6,903 1.0 ###########
    784 1.3 570 54,758 ####### 1.0 6,903 1.0 ###########
    848 1.4 633 60,324 ####### 1.0 6,902 1.0 ###########
    912 1.5 663 64,007 ####### 1.0 6,902 1.0 ###########
    976 1.6 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,040 1.8 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,104 1.9 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,168 2.0 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,232 2.1 663 64,007 ####### 1.0 6,902 1.0 ###########
    ————————————————————-

    SGA Target Advisory DB/Inst: PAST01/past01 Snap: 8219

    SGA Target SGA Size Est DB Est Physical
    Size (M) Factor Time (s) Reads
    ———- ———- ———— —————-
    612 0.8 354,230 43,760,951
    816 1.0 347,421 42,890,278
    1,020 1.3 347,386 42,890,278
    1,224 1.5 347,386 42,890,278
    1,428 1.8 347,386 42,890,278
    1,632 2.0 347,386 42,890,278
    ————————————————————-

    Streams Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Java Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Buffer Wait Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LEnqueue Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only enqueues with waits are shown
    -> Enqueue stats gathered prior to 10g should not be compared with 10g data
    -> ordered by Wait Time desc, Waits desc

    Enqueue Type (Request Reason)
    ——————————————————————————
    Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
    ———— ———— ———– ———– ———— ————–
    TX-Transaction (row lock contention)
    58 56 0 56 114 2,044.46
    PR-Process Startup
    38 38 0 2 83 41,350.00
    ————————————————————-

    ^LUndo Segment Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Min/Max TR (mins) – Min and Max Tuned Retention (minutes)
    -> STO – Snapshot Too Old count, OOS – Out of Space count
    -> Undo segment block stats:
    -> uS – unexpired Stolen, uR – unexpired Released, uU – unexpired reUsed
    -> eS – expired Stolen, eR – expired Released, eU – expired reUsed

    Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
    TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU
    —- ———- ————— ——– ——– ——— —– ————–
    1 3.2 8,231 0 4 120/120 0/0 0/0/0/0/0/0
    ————————————————————-

    Undo Segment Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Most recent 35 Undostat rows, ordered by Time desc

    Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
    End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
    ———— ———– ———— ——- ——- ——- —– ————
    24-Jan 19:56 529 1,371 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:46 525 1,339 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:36 520 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:26 513 1,342 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:16 521 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:06 549 1,449 0 4 120 0/0 0/0/0/0/0/0
    ————————————————————-

    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    AWR Alerted Metric Eleme 13,594 0.0 N/A 0 0 N/A
    Consistent RBA 7,759 0.0 N/A 0 0 N/A
    FAL request queue 76 0.0 N/A 0 0 N/A
    FAL subheap alocation 76 0.0 N/A 0 0 N/A
    FIB s.o chain latch 10 0.0 N/A 0 0 N/A
    FOB s.o list latch 39 0.0 N/A 0 0 N/A
    In memory undo latch 57,797 0.0 N/A 0 7,751 0.0
    JS mem alloc latch 8 0.0 N/A 0 0 N/A
    JS queue access latch 8 0.0 N/A 0 0 N/A
    JS queue state obj latch 20,610 0.0 N/A 0 0 N/A
    KMG MMAN ready and start 1,255 0.0 N/A 0 0 N/A
    KMG resize request state 22 0.0 N/A 0 0 N/A
    KTF sga latch 9 0.0 N/A 0 1,000 0.0
    MQL Tracking Latch 0 N/A N/A 0 73 0.0
    Memory Management Latch 44 0.0 N/A 0 1,244 0.0
    OS process 325 0.0 N/A 0 0 N/A
    OS process allocation 1,456 0.0 N/A 0 0 N/A
    OS process: request allo 71 0.0 N/A 0 0 N/A
    PL/SQL warning settings 3 0.0 N/A 0 0 N/A
    SQL memory manager latch 1 0.0 N/A 0 1,230 0.0
    SQL memory manager worka 82,537 0.0 N/A 0 0 N/A
    Shared B-Tree 132 0.0 N/A 0 0 N/A
    active checkpoint queue 5,758 0.0 N/A 0 0 N/A
    active service list 6,300 0.0 N/A 0 1,140 0.0
    archive control 65 0.0 N/A 0 0 N/A
    archive process latch 1,306 0.0 N/A 0 0 N/A
    begin backup scn array 743 0.0 N/A 0 0 N/A
    cache buffer handles 12 0.0 N/A 0 0 N/A
    cache buffers chains 1,531,075 0.0 0.7 0 2,596 0.0
    cache buffers lru chain 34,429 0.0 1.0 0 422 0.0
    channel handle pool latc 69 0.0 N/A 0 0 N/A
    channel operations paren 17,236 0.0 N/A 0 0 N/A
    checkpoint queue latch 49,900 0.0 0.7 0 8,766 0.0
    client/application info 2 0.0 N/A 0 0 N/A
    compile environment latc 12,491 0.0 N/A 0 0 N/A
    dml lock allocation 42,716 0.0 0.0 0 0 N/A
    dummy allocation 4 0.0 N/A 0 0 N/A
    enqueue hash chains 117,642 0.0 0.3 0 1,404 0.1
    enqueues 61,315 0.0 N/A 0 0 N/A
    event group latch 38 0.0 N/A 0 0 N/A
    file cache latch 90 0.0 N/A 0 0 N/A
    hash table column usage 33 0.0 N/A 0 171 0.0
    hash table modification 54 0.0 N/A 0 0 N/A
    job_queue_processes para 57 0.0 N/A 0 0 N/A
    kks stats 15 0.0 N/A 0 0 N/A
    kmcptab latch 110 0.0 N/A 0 0 N/A
    kmcpvec latch 0 N/A N/A 0 110 0.0
    ksuosstats global area 249 0.0 N/A 0 0 N/A
    ktm global data 19 0.0 N/A 0 0 N/A
    kwqbsn:qsga 132 0.0 N/A 0 0 N/A
    lgwr LWN SCN 8,445 0.1 0.0 0 0 N/A
    library cache 261,487 0.0 2.0 0 0 N/A
    library cache load lock 28 0.0 N/A 0 0 N/A
    library cache lock 209,307 0.0 N/A 0 0 N/A
    library cache lock alloc 40 0.0 N/A 0 0 N/A
    library cache pin 88,014 0.0 N/A 0 0 N/A
    library cache pin alloca 2 0.0 N/A 0 0 N/A
    list of block allocation 573 0.0 N/A 0 0 N/A
    loader state object free 3,342 0.0 N/A 0 0 N/A
    messages 55,816 0.0 0.3 0 0 N/A
    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    mostly latch-free SCN 8,440 0.0 N/A 0 0 N/A
    ncodef allocation latch 55 0.0 N/A 0 0 N/A
    object queue header heap 12 0.0 N/A 0 0 N/A
    object queue header oper 36,326 0.0 N/A 0 0 N/A
    object stats modificatio 1 0.0 N/A 0 0 N/A
    parallel query alloc buf 492 0.0 N/A 0 0 N/A
    parameter table allocati 2 0.0 N/A 0 0 N/A
    post/wait queue 11,510 0.0 N/A 0 7,581 0.0
    process allocation 71 0.0 N/A 0 38 0.0
    process group creation 69 0.0 N/A 0 0 N/A
    qmn task queue latch 528 0.0 N/A 0 0 N/A
    redo allocation 38,681 0.0 0.5 0 88,349 0.0
    redo copy 0 N/A N/A 0 88,362 0.0
    redo writing 31,697 0.0 0.8 0 0 N/A
    resmgr:actses active lis 1 0.0 N/A 0 0 N/A
    resmgr:schema config 1 0.0 N/A 0 0 N/A
    row cache objects 12,389 0.0 N/A 0 0 N/A
    sequence cache 63,574 0.0 N/A 0 0 N/A
    session allocation 30,669 0.0 1.0 15 0 N/A
    session idle bit 257,599 0.0 N/A 0 0 N/A
    session state list latch 8 0.0 N/A 0 0 N/A
    session switching 55 0.0 N/A 0 0 N/A
    session timer 1,140 0.0 N/A 0 0 N/A
    shared pool 8,477 0.2 57.1 535 0 N/A
    shared pool sim alloc 2 0.0 N/A 0 0 N/A
    shared pool simulator 6,517 0.0 N/A 0 0 N/A
    simulator hash latch 30,800 0.0 N/A 0 0 N/A
    simulator lru latch 29,707 0.0 N/A 0 897 0.0
    slave class 2 0.0 N/A 0 0 N/A
    slave class create 8 12.5 1.0 0 0 N/A
    sort extent pool 88 0.0 N/A 0 0 N/A
    state object free list 2 0.0 N/A 0 0 N/A
    statistics aggregation 112 0.0 N/A 0 0 N/A
    threshold alerts latch 168 0.0 N/A 0 0 N/A
    transaction allocation 415 0.0 N/A 0 0 N/A
    transaction branch alloc 55 0.0 N/A 0 0 N/A
    undo global data 41,288 0.0 N/A 0 0 N/A
    virtual circuit buffers 738,709 0.1 0.0 0 0 N/A
    virtual circuit queues 312,136 0.0 0.0 0 0 N/A
    virtual circuits 155,447 0.0 N/A 0 0 N/A
    ————————————————————-

    ^LLatch Sleep Breakdown DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by misses desc

    Latch Name
    —————————————-
    Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
    ————– ———– ———– ———- ——– ——– ——–
    virtual circuit buffers
    738,709 619 9 610 0 0 0
    virtual circuit queues
    312,136 100 3 97 0 0 0
    shared pool
    8,477 17 970 1 0 0 0
    cache buffers chains
    1,531,075 10 7 3 0 0 0
    session allocation
    30,669 5 5 0 0 0 0
    redo allocation
    38,681 4 2 2 0 0 0
    redo writing
    31,697 4 3 1 0 0 0
    cache buffers lru chain
    34,429 3 3 0 0 0 0
    checkpoint queue latch
    49,900 3 2 1 0 0 0
    enqueue hash chains
    117,642 3 1 2 0 0 0
    library cache
    261,487 3 6 0 0 0 0
    messages
    55,816 3 1 2 0 0 0
    slave class create
    8 1 1 0 0 0 0
    ————————————————————-

    ^LLatch Miss Sources DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

    NoWait Waiter
    Latch Name Where Misses Sleeps Sleeps
    ———————— ————————– ——- ———- ——–
    cache buffers chains kcbnlc 0 8 0
    cache buffers chains kcbget: pin buffer 0 1 0
    cache buffers lru chain kcbzgws_1 0 3 0
    checkpoint queue latch kcbklbc: Link buffer into 0 1 0
    checkpoint queue latch kcbkllrba: compute lowest 0 1 0
    enqueue hash chains ksqrcl 0 1 1
    library cache kglScanDependency 0 6 0
    messages ksarcv 0 1 1
    redo allocation kcrfw_redo_gen: redo alloc 0 2 0
    redo writing kcrfsr: rba scn pair 0 2 0
    redo writing kcrfwcr 0 1 0
    session allocation ksucrp 0 2 1
    session allocation ksucri 0 1 1
    session allocation ksuprc 0 1 1
    session allocation ksuxds: not user session 0 1 1
    shared pool kghdmp 0 947 0
    shared pool kghalo 0 22 944
    shared pool kghupr1 0 1 4
    slave class create ksvcreate 0 1 0
    virtual circuit queues kmcfsq 0 3 0
    virtual circuits kmcgms: if called with non 0 4 0
    virtual circuits kmcgms: if shared server 0 4 2
    virtual circuits kmcmbf 0 1 2
    ————————————————————-

    ^LParent Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Child Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Logical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Physical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Row Lock Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by ITL Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Buffer Busy Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LDictionary Cache Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Pct Misses” should be very low ( “Final Usage” is the number of cache entries being used

    Get Pct Scan Pct Mod Final
    Cache Requests Miss Reqs Miss Reqs Usage
    ————————- ———— —— ——- —– ——– ———-
    dc_awr_control 66 0.0 0 N/A 2 1
    dc_global_oids 8 0.0 0 N/A 0 33
    dc_histogram_data 73 47.9 0 N/A 0 62,380
    dc_histogram_defs 156 40.4 0 N/A 0 4,356
    dc_object_ids

  5. WORKLOAD REPOSITORY report for

    DB Name DB Id Instance Inst Num Release RAC Host
    ———— ———– ———— ——– ———– — ————
    PAST01 340786915 past01 1 10.2.0.2.0 NO vsl001a012

    Snap Id Snap Time Sessions Curs/Sess
    ——— ——————- ——– ———
    Begin Snap: 8218 24-Jan-10 19:00:50 28 1.9
    End Snap: 8219 24-Jan-10 20:02:14 28 2.0
    Elapsed: 61.40 (mins)
    DB Time: 11.49 (mins)

    Cache Sizes
    ~~~~~~~~~~~ Begin End
    ———- ———-
    Buffer Cache: 144M 144M Std Block Size: 8K
    Shared Pool Size: 592M 592M Log Buffer: 30,744K

    Load Profile
    ~~~~~~~~~~~~ Per Second Per Transaction
    ————— —————
    Redo size: 17,892.92 9,398.58
    Logical reads: 111.15 58.38
    Block changes: 61.25 32.17
    Physical reads: 0.61 0.32
    Physical writes: 3.02 1.59
    User calls: 33.27 17.47
    Parses: 11.67 6.13
    Hard parses: 0.00 0.00
    Sorts: 0.46 0.24
    Logons: 0.00 0.00
    Executes: 12.35 6.49
    Transactions: 1.90

    % Blocks changed per Read: 55.10 Recursive Call %: 20.48
    Rollback per transaction %: 0.01 Rows per Sort: 7.56

    Instance Efficiency Percentages (Target 100%)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Buffer Nowait %: 100.00 Redo NoWait %: 99.97
    Buffer Hit %: 99.78 In-memory Sort %: 100.00
    Library Hit %: 99.96 Soft Parse %: 99.96
    Execute to Parse %: 5.47 Latch Hit %: 99.98
    Parse CPU to Parse Elapsd %: 89.59 % Non-Parse CPU: 94.67

    Shared Pool Statistics Begin End
    —— ——
    Memory Usage %: 90.97 91.05
    % SQL with executions>1: 99.16 99.12
    % Memory for SQL w/exec>1: 90.60 90.75

    Top 5 Timed Events Avg %Total
    ~~~~~~~~~~~~~~~~~~ wait Call
    Event Waits Time (s) (ms) Time Wait Class
    —————————— ———— ———– —— —— ———-
    enq: TX – row lock contention 249 589 2367 85.5 Applicatio
    latch: shared pool 970 535 551 77.6 Concurrenc
    enq: PR – contention 29 81 2783 11.7 Other
    CPU time 61 8.9
    log file parallel write 7,758 47 6 6.8 System I/O
    ————————————————————-
    ^LTime Model Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Total time in database user-calls (DB Time): 689.1s
    -> Statistics including the word “background” measure background process
    time, and so do not contribute to the DB time statistic
    -> Ordered by % or DB time desc, Statistic name

    Statistic Name Time (s) % of DB Time
    —————————————— —————— ————
    sql execute elapsed time 628.7 91.2
    DB CPU 61.4 8.9
    parse time elapsed 6.0 .9
    hard parse elapsed time 2.4 .4
    failed parse (out of shared memory) elapse 2.2 .3
    failed parse elapsed time 2.2 .3
    hard parse (sharing criteria) elapsed time 0.2 .0
    sequence load elapsed time 0.1 .0
    hard parse (bind mismatch) elapsed time 0.0 .0
    repeated bind elapsed time 0.0 .0
    DB time 689.1 N/A
    background elapsed time 765.8 N/A
    background cpu time 58.4 N/A
    ————————————————————-

    Wait Class DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc

    Avg
    %Time Total Wait wait Waits
    Wait Class Waits -outs Time (s) (ms) /txn
    ——————– —————- —— —————- ——- ———
    Application 251 76.9 589 2348 0.0
    Concurrency 1,031 94.5 552 535 0.1
    Other 4,227 98.8 97 23 0.6
    System I/O 10,656 .0 68 6 1.5
    Commit 7,579 .0 43 6 1.1
    User I/O 3,753 .0 13 4 0.5
    Network 89,262 .0 2 0 12.7
    Configuration 5 .0 1 116 0.0
    ————————————————————-

    ^LWait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> s – second
    -> cs – centisecond – 100th of a second
    -> ms – millisecond – 1000th of a second
    -> us – microsecond – 1000000th of a second
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    enq: TX – row lock contentio 249 77.5 589 2367 0.0
    latch: shared pool 970 99.5 535 551 0.1
    enq: PR – contention 29 93.1 81 2783 0.0
    log file parallel write 7,758 .0 47 6 1.1
    log file sync 7,579 .0 43 6 1.1
    os thread startup 48 18.8 17 344 0.0
    latch: session allocation 5 .0 15 3077 0.0
    db file sequential read 1,944 .0 13 7 0.3
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    SQL*Net message to client 84,675 .0 2 0 12.1
    log file switch completion 2 .0 1 290 0.0
    ksdxexeotherwait 4,148 100.0 0 0 0.6
    SQL*Net more data from clien 4,587 .0 0 0 0.7
    latch: library cache 6 .0 0 24 0.0
    latch free 10 .0 0 14 0.0
    control file sequential read 1,461 .0 0 0 0.2
    direct path write 1,494 .0 0 0 0.2
    log file single write 4 .0 0 5 0.0
    SQL*Net break/reset to clien 2 .0 0 6 0.0
    SGA: allocation forcing comp 11 .0 0 1 0.0
    latch: cache buffers lru cha 3 .0 0 4 0.0
    direct path read 315 .0 0 0 0.0
    latch: checkpoint queue latc 2 .0 0 2 0.0
    latch: redo allocation 2 .0 0 1 0.0
    latch: cache buffers chains 7 .0 0 0 0.0
    latch: messages 1 .0 0 2 0.0
    LGWR wait for redo copy 11 .0 0 0 0.0
    rdbms ipc reply 1 .0 0 1 0.0
    latch: enqueue hash chains 1 100.0 0 1 0.0
    latch: redo writing 3 .0 0 0 0.0
    latch: virtual circuit queue 3 .0 0 0 0.0
    virtual circuit status 56,849 .1 3,940 69 8.1
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    SQL*Net message from client 84,649 .0 3,458 41 12.1
    ————————————————————-

    ^LBackground Wait Events DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by wait time desc, waits desc (idle events last)

    Avg
    %Time Total Wait wait Waits
    Event Waits -outs Time (s) (ms) /txn
    —————————- ————– —— ———– ——- ———
    latch: shared pool 970 99.5 535 551 0.1
    events in waitclass Other 4,204 99.3 90 21 0.6
    log file parallel write 7,758 .0 47 6 1.1
    os thread startup 49 20.4 18 357 0.0
    control file parallel write 1,250 .0 11 9 0.2
    Log archive I/O 92 .0 6 66 0.0
    log file sequential read 91 .0 4 48 0.0
    db file sequential read 27 .0 2 62 0.0
    control file sequential read 803 .0 0 0 0.1
    log file single write 4 .0 0 5 0.0
    direct path write 8 .0 0 0 0.0
    latch: redo writing 3 .0 0 0 0.0
    direct path read 8 .0 0 0 0.0
    latch: cache buffers chains 1 .0 0 0 0.0
    rdbms ipc message 19,484 60.5 39,136 2009 2.8
    smon timer 15 86.7 3,823 254854 0.0
    Streams AQ: qmn slave idle w 132 .0 3,626 27473 0.0
    Streams AQ: qmn coordinator 273 51.6 3,626 13283 0.0
    pmon timer 1,140 99.9 3,316 2909 0.2
    ————————————————————-

    Operating System Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total
    ——————————– ——————–
    BUSY_TIME 31,813
    IDLE_TIME 708,131
    IOWAIT_TIME 28,758
    NICE_TIME 0
    SYS_TIME 19,554
    USER_TIME 7,318
    LOAD 1
    RSRC_MGR_CPU_WAIT_TIME 0
    PHYSICAL_MEMORY_BYTES 2,048,012
    NUM_CPUS 2
    ————————————————————-

    ^LService Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by DB Time

    Physical Logical
    Service Name DB Time (s) DB CPU (s) Reads Reads
    ——————————– ———— ———— ———- ———-
    past01 683.2 61.4 2,173 395,473
    SYS$BACKGROUND 0.0 0.0 77 14,132
    SYS$USERS 0.0 0.0 0 0
    ————————————————————-

    Service Wait Class Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Wait Class info for services in the Service Statistics section.
    -> Total Waits and Time Waited displayed for the following wait
    classes: User I/O, Concurrency, Administrative, Network
    -> Time Waited (Wt Time) in centisecond (100th of a second)

    Service Name
    —————————————————————-
    User I/O User I/O Concurcy Concurcy Admin Admin Network Network
    Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
    ——— ——— ——— ——— ——— ——— ——— ———
    past01
    3659 1140 12 15 0 0 89262 211
    SYS$BACKGROUND
    93 198 1019 55148 0 0 0 0
    SYS$USERS
    0 0 0 0 0 0 0 0
    ————————————————————-

    ^LSQL ordered by Elapsed Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by CPU Time DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Gets DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Executions DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Parse Calls DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Sharable Memory DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSQL ordered by Version Count DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    CPU used by this session 5,714 1.6 0.8
    CPU used when call started 4,106 1.1 0.6
    CR blocks created 154 0.0 0.0
    Cached Commit SCN referenced 0 0.0 0.0
    Commit SCN cached 0 0.0 0.0
    DB time 21,649 5.9 3.1
    DBWR checkpoint buffers written 10,388 2.8 1.5
    DBWR checkpoints 1 0.0 0.0
    DBWR revisited being-written buf 0 0.0 0.0
    DBWR tablespace checkpoint buffe 0 0.0 0.0
    DBWR thread checkpoint buffers w 0 0.0 0.0
    DBWR transaction table writes 116 0.0 0.0
    DBWR undo block writes 3,307 0.9 0.5
    IMU CR rollbacks 62 0.0 0.0
    IMU Flushes 3,123 0.9 0.5
    IMU Redo allocation size 15,614,600 4,238.2 2,226.2
    IMU commits 2,388 0.7 0.3
    IMU contention 590 0.2 0.1
    IMU ktichg flush 0 0.0 0.0
    IMU pool not allocated 1,656 0.5 0.2
    IMU recursive-transaction flush 29 0.0 0.0
    IMU undo allocation size 36,313,872 9,856.6 5,177.3
    IMU- failed to get a private str 1,656 0.5 0.2
    Misses for writing mapping 0 0.0 0.0
    SMON posted for undo segment shr 2 0.0 0.0
    SQL*Net roundtrips to/from clien 162,371 44.1 23.2
    active txn count during cleanout 1,570 0.4 0.2
    application wait time 58,932 16.0 8.4
    background checkpoints completed 1 0.0 0.0
    background checkpoints started 1 0.0 0.0
    background timeouts 11,825 3.2 1.7
    branch node splits 3 0.0 0.0
    buffer is not pinned count 12,866 3.5 1.8
    buffer is pinned count 653 0.2 0.1
    bytes received via SQL*Net from 33,602,391 9,120.6 4,790.8
    bytes sent via SQL*Net to client 351,226,114,381 95,332,272.7 50,075,009.2
    calls to get snapshot scn: kcmgs 80,395 21.8 11.5
    calls to kcmgas 9,763 2.7 1.4
    calls to kcmgcs 1,042 0.3 0.2
    change write time 702 0.2 0.1
    cleanout – number of ktugct call 3,160 0.9 0.5
    cleanouts and rollbacks – consis 122 0.0 0.0
    cleanouts only – consistent read 101 0.0 0.0
    cluster key scan block gets 6,186 1.7 0.9
    cluster key scans 88 0.0 0.0
    commit batch/immediate performed 1 0.0 0.0
    commit batch/immediate requested 1 0.0 0.0
    commit cleanout failures: block 0 0.0 0.0
    commit cleanout failures: buffer 7 0.0 0.0
    commit cleanout failures: callba 47 0.0 0.0
    commit cleanout failures: cannot 970 0.3 0.1
    commit cleanouts 85,915 23.3 12.3
    commit cleanouts successfully co 84,891 23.0 12.1
    commit immediate performed 1 0.0 0.0
    commit immediate requested 1 0.0 0.0
    commit txn count during cleanout 7,397 2.0 1.1
    concurrency wait time 55,261 15.0 7.9
    consistent changes 188 0.1 0.0
    consistent gets 56,293 15.3 8.0
    consistent gets – examination 29,215 7.9 4.2
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    consistent gets direct 1,228 0.3 0.2
    consistent gets from cache 55,065 15.0 7.9
    current blocks converted for CR 0 0.0 0.0
    cursor authentications 16 0.0 0.0
    data blocks consistent reads – u 154 0.0 0.0
    db block changes 225,649 61.3 32.2
    db block gets 353,197 95.9 50.4
    db block gets direct 744 0.2 0.1
    db block gets from cache 352,453 95.7 50.3
    deferred (CURRENT) block cleanou 33,116 9.0 4.7
    dirty buffers inspected 0 0.0 0.0
    enqueue conversions 9,494 2.6 1.4
    enqueue releases 53,907 14.6 7.7
    enqueue requests 53,911 14.6 7.7
    enqueue timeouts 0 0.0 0.0
    enqueue waits 58 0.0 0.0
    exchange deadlocks 0 0.0 0.0
    execute count 45,487 12.4 6.5
    failed probes on index block rec 8 0.0 0.0
    free buffer inspected 3,137 0.9 0.5
    free buffer requested 2,835 0.8 0.4
    heap block compress 1,450 0.4 0.2
    hot buffers moved to head of LRU 2,713 0.7 0.4
    immediate (CR) block cleanout ap 223 0.1 0.0
    immediate (CURRENT) block cleano 9,099 2.5 1.3
    index fast full scans (full) 0 0.0 0.0
    index fetch by key 11,957 3.3 1.7
    index scans kdiixs1 4,509 1.2 0.6
    leaf node 90-10 splits 100 0.0 0.0
    leaf node splits 253 0.1 0.0
    lob reads 0 0.0 0.0
    lob writes 8,641 2.4 1.2
    lob writes unaligned 8,099 2.2 1.2
    logons cumulative 2 0.0 0.0
    messages received 12,234 3.3 1.7
    messages sent 12,226 3.3 1.7
    no buffer to keep pinned count 0 0.0 0.0
    no work – consistent read gets 10,282 2.8 1.5
    opened cursors cumulative 43,105 11.7 6.2
    parse count (failures) 2 0.0 0.0
    parse count (hard) 17 0.0 0.0
    parse count (total) 43,001 11.7 6.1
    parse time cpu 327 0.1 0.1
    parse time elapsed 365 0.1 0.1
    physical read IO requests 2,257 0.6 0.3
    physical read bytes 18,489,344 5,018.5 2,636.1
    physical read total IO requests 3,817 1.0 0.5
    physical read total bytes 128,934,400 34,996.3 18,382.4
    physical read total multi block 83 0.0 0.0
    physical reads 2,257 0.6 0.3
    physical reads cache 1,198 0.3 0.2
    physical reads cache prefetch 0 0.0 0.0
    physical reads direct 1,059 0.3 0.2
    physical reads direct (lob) 307 0.1 0.0
    physical reads direct temporary 0 0.0 0.0
    physical reads prefetch warmup 0 0.0 0.0
    physical write IO requests 5,271 1.4 0.8
    physical write bytes 91,258,880 24,770.1 13,011.0
    physical write total IO requests 23,440 6.4 3.3
    physical write total bytes 359,137,792 97,479.7 51,203.0
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    physical write total multi block 15,662 4.3 2.2
    physical writes 11,140 3.0 1.6
    physical writes direct 752 0.2 0.1
    physical writes direct (lob) 744 0.2 0.1
    physical writes direct temporary 0 0.0 0.0
    physical writes from cache 10,388 2.8 1.5
    physical writes non checkpoint 3,018 0.8 0.4
    pinned buffers inspected 0 0.0 0.0
    prefetch warmup blocks aged out 0 0.0 0.0
    prefetched blocks aged out befor 0 0.0 0.0
    process last non-idle time 0 0.0 0.0
    recursive aborts on index block 0 0.0 0.0
    recursive calls 31,558 8.6 4.5
    recursive cpu usage 549 0.2 0.1
    redo blocks written 137,218 37.2 19.6
    redo buffer allocation retries 30 0.0 0.0
    redo entries 88,315 24.0 12.6
    redo log space requests 30 0.0 0.0
    redo log space wait time 60 0.0 0.0
    redo ordering marks 718 0.2 0.1
    redo size 65,921,652 17,892.9 9,398.6
    redo synch time 4,467 1.2 0.6
    redo synch writes 13,185 3.6 1.9
    redo wastage 2,077,560 563.9 296.2
    redo write time 4,842 1.3 0.7
    redo writer latching time 1 0.0 0.0
    redo writes 7,758 2.1 1.1
    rollback changes – undo records 3 0.0 0.0
    rollbacks only – consistent read 32 0.0 0.0
    rows fetched via callback 2,789 0.8 0.4
    session connect time 0 0.0 0.0
    session cursor cache hits 1,383 0.4 0.2
    session logical reads 409,490 111.2 58.4
    session pga memory 148,128 40.2 21.1
    session pga memory max 82,592 22.4 11.8
    session uga memory 120,688 32.8 17.2
    session uga memory max 4,495,016 1,220.1 640.9
    shared hash latch upgrades – no 5,066 1.4 0.7
    shared hash latch upgrades – wai 0 0.0 0.0
    sorts (disk) 0 0.0 0.0
    sorts (memory) 1,678 0.5 0.2
    sorts (rows) 12,693 3.5 1.8
    sql area evicted 1 0.0 0.0
    sql area purged 2 0.0 0.0
    summed dirty queue length 0 0.0 0.0
    switch current to new buffer 437 0.1 0.1
    table fetch by rowid 3,325 0.9 0.5
    table fetch continued row 8 0.0 0.0
    table scan blocks gotten 2,129 0.6 0.3
    table scan rows gotten 46,470 12.6 6.6
    table scans (cache partitions) 0 0.0 0.0
    table scans (long tables) 0 0.0 0.0
    table scans (short tables) 253 0.1 0.0
    total number of times SMON poste 2 0.0 0.0
    transaction rollbacks 1 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    transaction tables consistent re 0 0.0 0.0
    undo change vector size 22,732,468 6,170.2 3,241.0
    user I/O wait time 1,365 0.4 0.2
    user calls 122,556 33.3 17.5
    ^LInstance Activity Stats DB/Inst: PAST01/past01 Snaps: 8218-8219

    Statistic Total per Second per Trans
    ——————————– —————— ————– ————-
    user commits 7,013 1.9 1.0
    user rollbacks 1 0.0 0.0
    workarea executions – onepass 0 0.0 0.0
    workarea executions – optimal 437 0.1 0.1
    write clones created in backgrou 0 0.0 0.0
    write clones created in foregrou 6 0.0 0.0
    ————————————————————-

    ^LInstance Activity Stats – Absolute ValuesDB/Inst: PAST01/past01 Snaps: 8218-
    -> Statistics with absolute values (should not be diffed)

    Statistic Begin Value End Value
    ——————————– ————— —————
    session cursor cache count 87,642 87,682
    opened cursors current 53 56
    workarea memory allocated 116 116
    logons current 28 28
    ————————————————————-

    Instance Activity Stats – Thread ActivityDB/Inst: PAST01/past01 Snaps: 8218-8
    -> Statistics identified by ‘(derived)’ come from sources other than SYSSTAT

    Statistic Total per Hour
    ——————————– —————— ———
    log switches (derived) 1 .98
    ————————————————————-

    ^LTablespace IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by IOs (Reads + Writes) desc

    Tablespace
    ——————————
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    PAS_DATA
    2,175 1 5.3 1.0 4,707 1 0 0.0
    UNDOTBS
    2 0 0.0 1.0 339 0 0 0.0
    SYSAUX
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM
    21 0 23.3 1.0 75 0 0 0.0
    INDX
    1 0 0.0 1.0 1 0 0 0.0
    USERS
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LFile IO Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by Tablespace, File

    Tablespace Filename
    ———————— —————————————————-
    Av Av Av Av Buffer Av Buf
    Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
    ————– ——- —— ——- ———— ——– ———- ——
    INDX /dborafiles/vdc/pas/past01/oradata01/indx01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata01/pasdata01.dbf
    1,488 0 6.4 1.0 2,277 1 0 0.0
    PAS_DATA /dborafiles/vdc/pas/past01/oradata02/pasdata02.dbf
    687 0 2.8 1.0 2,430 1 0 0.0
    SYSAUX /dborafiles/vdc/pas/past01/oradata01/sysaux01.dbf
    48 0 29.6 1.0 148 0 0 0.0
    SYSTEM /dborafiles/vdc/pas/past01/oradata01/system01.dbf
    21 0 23.3 1.0 75 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata01/undotbs01.dbf
    1 0 0.0 1.0 236 0 0 0.0
    UNDOTBS /dborafiles/vdc/pas/past01/oradata02/undotbs02.dbf
    1 0 0.0 1.0 103 0 0 0.0
    USERS /dborafiles/vdc/pas/past01/oradata01/users01.dbf
    1 0 0.0 1.0 1 0 0 0.0
    ————————————————————-

    ^LBuffer Pool Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Standard block size Pools D: default, K: keep, R: recycle
    -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

    Free Writ Buffer
    Number of Pool Buffer Physical Physical Buff Comp Busy
    P Buffers Hit% Gets Reads Writes Wait Wait Waits
    — ———- —- ————– ———— ———– —- —- ———-
    D 17,847 100 407,487 1,182 10,388 0 0 0
    ————————————————————-

    Instance Recovery Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snapshot, E: End snapshot

    Targt Estd Log File Log Ckpt Log Ckpt
    MTTR MTTR Recovery Actual Target Size Timeout Interval
    (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
    – —– —– ———- ——— ——— ———- ——— ————
    B 0 19 771 11520 68786 552960 68786 N/A
    E 0 19 153 356 57847 552960 57847 N/A
    ————————————————————-

    Buffer Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> Only rows with estimated physical reads >0 are displayed
    -> ordered by Block Size, Buffers For Estimate

    Est
    Phys
    Size for Size Buffers for Read Estimated
    P Est (M) Factor Estimate Factor Physical Reads
    — ——– —— —————- —— ——————
    D 16 .1 1,983 1.2 51,598,018
    D 32 .2 3,966 1.1 46,297,341
    D 48 .3 5,949 1.1 45,547,576
    D 64 .4 7,932 1.0 44,976,656
    D 80 .6 9,915 1.0 43,778,798
    D 96 .7 11,898 1.0 43,438,238
    D 112 .8 13,881 1.0 43,245,302
    D 128 .9 15,864 1.0 43,070,456
    D 144 1.0 17,847 1.0 42,890,301
    D 160 1.1 19,830 1.0 42,771,297
    D 176 1.2 21,813 1.0 42,667,937
    D 192 1.3 23,796 1.0 42,602,022
    D 208 1.4 25,779 1.0 42,552,691
    D 224 1.6 27,762 1.0 42,509,345
    D 240 1.7 29,745 1.0 42,433,796
    D 256 1.8 31,728 1.0 42,319,599
    D 272 1.9 33,711 1.0 42,273,588
    D 288 2.0 35,694 1.0 42,036,564
    ————————————————————-

    ^LPGA Aggr Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> PGA cache hit % – percentage of W/A (WorkArea) data processed only in-memory

    PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
    ————— —————— ————————–
    100.0 8 0
    ————————————————————-

    PGA Aggr Target Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> B: Begin snap E: End snap (rows dentified with B or E contain data
    which is absolute i.e. not diffed over the interval)
    -> Auto PGA Target – actual workarea memory target
    -> W/A PGA Used – amount of memory used for all Workareas (manual + auto)
    -> %PGA W/A Mem – percentage of PGA memory allocated to workareas
    -> %Auto W/A Mem – percentage of workarea memory controlled by Auto Mem Mgmt
    -> %Man W/A Mem – percentage of workarea memory under manual control

    %PGA %Auto %Man
    PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
    Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
    – ———- ———- ———- ———- —— —— —— ———-
    B 191 112 143.5 0.1 .1 100.0 .0 39,062
    E 191 112 143.2 0.1 .1 100.0 .0 39,062
    ————————————————————-

    PGA Aggr Target Histogram DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Optimal Executions are purely in-memory operations

    Low High
    Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
    ——- ——- ————– ————– ———— ————
    2K 4K 426 426 0 0
    64K 128K 3 3 0 0
    512K 1024K 8 8 0 0
    ————————————————————-

    PGA Memory Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
    where Estd PGA Overalloc Count is 0

    Estd Extra Estd PGA Estd PGA
    PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
    Est (MB) Factr Processed Written to Disk Hit % Count
    ———- ——- —————- —————- ——– ———-
    24 0.1 34,432.9 12,717.5 73.0 1,149
    48 0.3 34,432.9 12,596.6 73.0 1,119
    95 0.5 34,432.9 2,571.6 93.0 77
    143 0.8 34,432.9 1,736.6 95.0 15
    191 1.0 34,432.9 1,701.5 95.0 0
    229 1.2 34,432.9 1,369.8 96.0 0
    267 1.4 34,432.9 1,117.5 97.0 0
    305 1.6 34,432.9 1,062.1 97.0 0
    343 1.8 34,432.9 935.6 97.0 0
    381 2.0 34,432.9 935.6 97.0 0
    572 3.0 34,432.9 935.6 97.0 0
    763 4.0 34,432.9 935.6 97.0 0
    1,144 6.0 34,432.9 935.6 97.0 0
    1,526 8.0 34,432.9 935.6 97.0 0
    ————————————————————-

    ^LShared Pool Advisory DB/Inst: PAST01/past01 Snap: 8219
    -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
    -> Note there is often a 1:Many correlation between a single logical object
    in the Library Cache, and the physical number of memory objects associated
    with it. Therefore comparing the number of Lib Cache objects (e.g. in
    v$librarycache), with the number of Lib Cache Memory Objects is invalid.

    Est LC Est LC Est LC Est LC
    Shared SP Est LC Time Time Load Load Est LC
    Pool Size Size Est LC Saved Saved Time Time Mem
    Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
    ———- —– ——– ———— ——- —— ——- —— ———–
    272 .5 73 11,202 ####### 1.0 76,690 11.1 ###########
    336 .6 131 13,875 ####### 1.0 16,668 2.4 ###########
    400 .7 194 19,044 ####### 1.0 7,876 1.1 ###########
    464 .8 255 24,348 ####### 1.0 6,931 1.0 ###########
    528 .9 318 30,057 ####### 1.0 6,915 1.0 ###########
    592 1.0 381 36,589 ####### 1.0 6,913 1.0 ###########
    656 1.1 444 42,390 ####### 1.0 6,908 1.0 ###########
    720 1.2 507 48,666 ####### 1.0 6,903 1.0 ###########
    784 1.3 570 54,758 ####### 1.0 6,903 1.0 ###########
    848 1.4 633 60,324 ####### 1.0 6,902 1.0 ###########
    912 1.5 663 64,007 ####### 1.0 6,902 1.0 ###########
    976 1.6 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,040 1.8 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,104 1.9 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,168 2.0 663 64,007 ####### 1.0 6,902 1.0 ###########
    1,232 2.1 663 64,007 ####### 1.0 6,902 1.0 ###########
    ————————————————————-

    SGA Target Advisory DB/Inst: PAST01/past01 Snap: 8219

    SGA Target SGA Size Est DB Est Physical
    Size (M) Factor Time (s) Reads
    ———- ———- ———— —————-
    612 0.8 354,230 43,760,951
    816 1.0 347,421 42,890,278
    1,020 1.3 347,386 42,890,278
    1,224 1.5 347,386 42,890,278
    1,428 1.8 347,386 42,890,278
    1,632 2.0 347,386 42,890,278
    ————————————————————-

    Streams Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Java Pool Advisory DB/Inst: PAST01/past01 Snap: 8219

    No data exists for this section of the report.
    ————————————————————-

    Buffer Wait Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LEnqueue Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only enqueues with waits are shown
    -> Enqueue stats gathered prior to 10g should not be compared with 10g data
    -> ordered by Wait Time desc, Waits desc

    Enqueue Type (Request Reason)
    ——————————————————————————
    Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
    ———— ———— ———– ———– ———— ————–
    TX-Transaction (row lock contention)
    58 56 0 56 114 2,044.46
    PR-Process Startup
    38 38 0 2 83 41,350.00
    ————————————————————-

    ^LUndo Segment Summary DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Min/Max TR (mins) – Min and Max Tuned Retention (minutes)
    -> STO – Snapshot Too Old count, OOS – Out of Space count
    -> Undo segment block stats:
    -> uS – unexpired Stolen, uR – unexpired Released, uU – unexpired reUsed
    -> eS – expired Stolen, eR – expired Released, eU – expired reUsed

    Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
    TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU
    —- ———- ————— ——– ——– ——— —– ————–
    1 3.2 8,231 0 4 120/120 0/0 0/0/0/0/0/0
    ————————————————————-

    Undo Segment Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> Most recent 35 Undostat rows, ordered by Time desc

    Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
    End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
    ———— ———– ———— ——- ——- ——- —– ————
    24-Jan 19:56 529 1,371 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:46 525 1,339 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:36 520 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:26 513 1,342 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:16 521 1,365 0 4 120 0/0 0/0/0/0/0/0
    24-Jan 19:06 549 1,449 0 4 120 0/0 0/0/0/0/0/0
    ————————————————————-

    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    AWR Alerted Metric Eleme 13,594 0.0 N/A 0 0 N/A
    Consistent RBA 7,759 0.0 N/A 0 0 N/A
    FAL request queue 76 0.0 N/A 0 0 N/A
    FAL subheap alocation 76 0.0 N/A 0 0 N/A
    FIB s.o chain latch 10 0.0 N/A 0 0 N/A
    FOB s.o list latch 39 0.0 N/A 0 0 N/A
    In memory undo latch 57,797 0.0 N/A 0 7,751 0.0
    JS mem alloc latch 8 0.0 N/A 0 0 N/A
    JS queue access latch 8 0.0 N/A 0 0 N/A
    JS queue state obj latch 20,610 0.0 N/A 0 0 N/A
    KMG MMAN ready and start 1,255 0.0 N/A 0 0 N/A
    KMG resize request state 22 0.0 N/A 0 0 N/A
    KTF sga latch 9 0.0 N/A 0 1,000 0.0
    MQL Tracking Latch 0 N/A N/A 0 73 0.0
    Memory Management Latch 44 0.0 N/A 0 1,244 0.0
    OS process 325 0.0 N/A 0 0 N/A
    OS process allocation 1,456 0.0 N/A 0 0 N/A
    OS process: request allo 71 0.0 N/A 0 0 N/A
    PL/SQL warning settings 3 0.0 N/A 0 0 N/A
    SQL memory manager latch 1 0.0 N/A 0 1,230 0.0
    SQL memory manager worka 82,537 0.0 N/A 0 0 N/A
    Shared B-Tree 132 0.0 N/A 0 0 N/A
    active checkpoint queue 5,758 0.0 N/A 0 0 N/A
    active service list 6,300 0.0 N/A 0 1,140 0.0
    archive control 65 0.0 N/A 0 0 N/A
    archive process latch 1,306 0.0 N/A 0 0 N/A
    begin backup scn array 743 0.0 N/A 0 0 N/A
    cache buffer handles 12 0.0 N/A 0 0 N/A
    cache buffers chains 1,531,075 0.0 0.7 0 2,596 0.0
    cache buffers lru chain 34,429 0.0 1.0 0 422 0.0
    channel handle pool latc 69 0.0 N/A 0 0 N/A
    channel operations paren 17,236 0.0 N/A 0 0 N/A
    checkpoint queue latch 49,900 0.0 0.7 0 8,766 0.0
    client/application info 2 0.0 N/A 0 0 N/A
    compile environment latc 12,491 0.0 N/A 0 0 N/A
    dml lock allocation 42,716 0.0 0.0 0 0 N/A
    dummy allocation 4 0.0 N/A 0 0 N/A
    enqueue hash chains 117,642 0.0 0.3 0 1,404 0.1
    enqueues 61,315 0.0 N/A 0 0 N/A
    event group latch 38 0.0 N/A 0 0 N/A
    file cache latch 90 0.0 N/A 0 0 N/A
    hash table column usage 33 0.0 N/A 0 171 0.0
    hash table modification 54 0.0 N/A 0 0 N/A
    job_queue_processes para 57 0.0 N/A 0 0 N/A
    kks stats 15 0.0 N/A 0 0 N/A
    kmcptab latch 110 0.0 N/A 0 0 N/A
    kmcpvec latch 0 N/A N/A 0 110 0.0
    ksuosstats global area 249 0.0 N/A 0 0 N/A
    ktm global data 19 0.0 N/A 0 0 N/A
    kwqbsn:qsga 132 0.0 N/A 0 0 N/A
    lgwr LWN SCN 8,445 0.1 0.0 0 0 N/A
    library cache 261,487 0.0 2.0 0 0 N/A
    library cache load lock 28 0.0 N/A 0 0 N/A
    library cache lock 209,307 0.0 N/A 0 0 N/A
    library cache lock alloc 40 0.0 N/A 0 0 N/A
    library cache pin 88,014 0.0 N/A 0 0 N/A
    library cache pin alloca 2 0.0 N/A 0 0 N/A
    list of block allocation 573 0.0 N/A 0 0 N/A
    loader state object free 3,342 0.0 N/A 0 0 N/A
    messages 55,816 0.0 0.3 0 0 N/A
    ^LLatch Activity DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Get Requests”, “Pct Get Miss” and “Avg Slps/Miss” are statistics for
    willing-to-wait latch get requests
    -> “NoWait Requests”, “Pct NoWait Miss” are for no-wait latch get requests
    -> “Pct Misses” for both should be very close to 0.0

    Pct Avg Wait Pct
    Get Get Slps Time NoWait NoWait
    Latch Name Requests Miss /Miss (s) Requests Miss
    ———————— ————– —— —— —— ———— ——
    mostly latch-free SCN 8,440 0.0 N/A 0 0 N/A
    ncodef allocation latch 55 0.0 N/A 0 0 N/A
    object queue header heap 12 0.0 N/A 0 0 N/A
    object queue header oper 36,326 0.0 N/A 0 0 N/A
    object stats modificatio 1 0.0 N/A 0 0 N/A
    parallel query alloc buf 492 0.0 N/A 0 0 N/A
    parameter table allocati 2 0.0 N/A 0 0 N/A
    post/wait queue 11,510 0.0 N/A 0 7,581 0.0
    process allocation 71 0.0 N/A 0 38 0.0
    process group creation 69 0.0 N/A 0 0 N/A
    qmn task queue latch 528 0.0 N/A 0 0 N/A
    redo allocation 38,681 0.0 0.5 0 88,349 0.0
    redo copy 0 N/A N/A 0 88,362 0.0
    redo writing 31,697 0.0 0.8 0 0 N/A
    resmgr:actses active lis 1 0.0 N/A 0 0 N/A
    resmgr:schema config 1 0.0 N/A 0 0 N/A
    row cache objects 12,389 0.0 N/A 0 0 N/A
    sequence cache 63,574 0.0 N/A 0 0 N/A
    session allocation 30,669 0.0 1.0 15 0 N/A
    session idle bit 257,599 0.0 N/A 0 0 N/A
    session state list latch 8 0.0 N/A 0 0 N/A
    session switching 55 0.0 N/A 0 0 N/A
    session timer 1,140 0.0 N/A 0 0 N/A
    shared pool 8,477 0.2 57.1 535 0 N/A
    shared pool sim alloc 2 0.0 N/A 0 0 N/A
    shared pool simulator 6,517 0.0 N/A 0 0 N/A
    simulator hash latch 30,800 0.0 N/A 0 0 N/A
    simulator lru latch 29,707 0.0 N/A 0 897 0.0
    slave class 2 0.0 N/A 0 0 N/A
    slave class create 8 12.5 1.0 0 0 N/A
    sort extent pool 88 0.0 N/A 0 0 N/A
    state object free list 2 0.0 N/A 0 0 N/A
    statistics aggregation 112 0.0 N/A 0 0 N/A
    threshold alerts latch 168 0.0 N/A 0 0 N/A
    transaction allocation 415 0.0 N/A 0 0 N/A
    transaction branch alloc 55 0.0 N/A 0 0 N/A
    undo global data 41,288 0.0 N/A 0 0 N/A
    virtual circuit buffers 738,709 0.1 0.0 0 0 N/A
    virtual circuit queues 312,136 0.0 0.0 0 0 N/A
    virtual circuits 155,447 0.0 N/A 0 0 N/A
    ————————————————————-

    ^LLatch Sleep Breakdown DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> ordered by misses desc

    Latch Name
    —————————————-
    Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
    ————– ———– ———– ———- ——– ——– ——–
    virtual circuit buffers
    738,709 619 9 610 0 0 0
    virtual circuit queues
    312,136 100 3 97 0 0 0
    shared pool
    8,477 17 970 1 0 0 0
    cache buffers chains
    1,531,075 10 7 3 0 0 0
    session allocation
    30,669 5 5 0 0 0 0
    redo allocation
    38,681 4 2 2 0 0 0
    redo writing
    31,697 4 3 1 0 0 0
    cache buffers lru chain
    34,429 3 3 0 0 0 0
    checkpoint queue latch
    49,900 3 2 1 0 0 0
    enqueue hash chains
    117,642 3 1 2 0 0 0
    library cache
    261,487 3 6 0 0 0 0
    messages
    55,816 3 1 2 0 0 0
    slave class create
    8 1 1 0 0 0 0
    ————————————————————-

    ^LLatch Miss Sources DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> only latches with sleeps are shown
    -> ordered by name, sleeps desc

    NoWait Waiter
    Latch Name Where Misses Sleeps Sleeps
    ———————— ————————– ——- ———- ——–
    cache buffers chains kcbnlc 0 8 0
    cache buffers chains kcbget: pin buffer 0 1 0
    cache buffers lru chain kcbzgws_1 0 3 0
    checkpoint queue latch kcbklbc: Link buffer into 0 1 0
    checkpoint queue latch kcbkllrba: compute lowest 0 1 0
    enqueue hash chains ksqrcl 0 1 1
    library cache kglScanDependency 0 6 0
    messages ksarcv 0 1 1
    redo allocation kcrfw_redo_gen: redo alloc 0 2 0
    redo writing kcrfsr: rba scn pair 0 2 0
    redo writing kcrfwcr 0 1 0
    session allocation ksucrp 0 2 1
    session allocation ksucri 0 1 1
    session allocation ksuprc 0 1 1
    session allocation ksuxds: not user session 0 1 1
    shared pool kghdmp 0 947 0
    shared pool kghalo 0 22 944
    shared pool kghupr1 0 1 4
    slave class create ksvcreate 0 1 0
    virtual circuit queues kmcfsq 0 3 0
    virtual circuits kmcgms: if called with non 0 4 0
    virtual circuits kmcgms: if shared server 0 4 2
    virtual circuits kmcmbf 0 1 2
    ————————————————————-

    ^LParent Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Child Latch Statistics DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Logical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Physical Reads DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LSegments by Row Lock Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by ITL Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    Segments by Buffer Busy Waits DB/Inst: PAST01/past01 Snaps: 8218-8219

    No data exists for this section of the report.
    ————————————————————-

    ^LDictionary Cache Stats DB/Inst: PAST01/past01 Snaps: 8218-8219
    -> “Pct Misses” should be very low ( “Final Usage” is the number of cache entries being used

    Get Pct Scan Pct Mod Final
    Cache Requests Miss Reqs Miss Reqs Usage
    ————————- ———— —— ——- —– ——– ———-
    dc_awr_control 66 0.0 0 N/A 2 1
    dc_global_oids 8 0.0 0 N/A 0 33
    dc_histogram_data 73 47.9 0 N/A 0 62,380
    dc_histogram_defs 156 40.4 0 N/A 0 4,356
    dc_object_ids

Leave a Reply

Your email address will not be published. Required fields are marked *