

WORKLOAD REPOSITORY report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
O10G          4231508839 o10g                1 10.1.0.3.0  NO      bhora

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      2152 29-Mar-05 21:00:59        24      13.8
  End Snap:      2161 30-Mar-05 06:00:34        29      13.6
   Elapsed:              539.58 (mins)
   DB Time:                8.55 (mins)

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
               Buffer Cache:       404M      Std Block Size:         8K
           Shared Pool Size:       148M          Log Buffer:       256K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:              3,209.86             16,118.78
              Logical reads:                 82.03                411.95
              Block changes:                 21.71                109.04
             Physical reads:                  0.41                  2.06
            Physical writes:                  1.01                  5.05
                 User calls:                  2.96                 14.89
                     Parses:                  1.74                  8.75
                Hard parses:                  0.06                  0.31
                      Sorts:                  0.94                  4.72
                     Logons:                  0.02                  0.11
                   Executes:                  8.65                 43.45
               Transactions:                  0.20

  % Blocks changed per Read:   26.47    Recursive Call %:    91.72
 Rollback per transaction %:    8.10       Rows per Sort:   155.63

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:   99.99
            Buffer  Hit   %:   99.50    In-memory Sort %:  100.00
            Library Hit   %:   98.97        Soft Parse %:   96.46
         Execute to Parse %:   79.86         Latch Hit %:  100.00
Parse CPU to Parse Elapsd %:   59.44     % Non-Parse CPU:   95.46

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   46.90   68.12
    % SQL with executions>1:   64.60   94.25
  % Memory for SQL w/exec>1:   59.73   90.21

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                        % Total
Event                                 Waits    Time (s)   DB Time     Wait Class
------------------------------ ------------ ----------- --------- --------------
CPU time                                            335     65.30
log file parallel write               6,967         196     38.12     System I/O
control file parallel write          10,849          96     18.62     System I/O
log file sync                         3,092          80     15.62         Commit
db file sequential read               2,860          28      5.38       User I/O
          -------------------------------------------------------------
Wait Events  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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
                                                    Total Wait    wait     Waits
Event                              Waits   Timeouts   Time (s)    (ms)      /txn
--------------------------- ------------ ---------- ---------- ------- ---------
log file parallel write            6,967          0        196      28       1.1
control file parallel write       10,849          0         96       9       1.7
log file sync                      3,092          0         80      26       0.5
db file sequential read            2,860          0         28      10       0.4
db file scattered read             1,825          0         21      12       0.3
class slave wait                       2          2         10    5002       0.0
SQL*Net break/reset to clie       22,482          0          9       0       3.5
latch: library cache                 170          0          4      25       0.0
log buffer space                     125          0          4      32       0.0
log file switch completion            30          0          2      58       0.0
process startup                       23          0          2      72       0.0
latch free                             9          0          1      66       0.0
log file single write                 44          0          0      11       0.0
control file sequential rea        3,470          0          0       0       0.5
SQL*Net message to client         92,322          0          0       0      14.3
LGWR wait for redo copy              135          5          0       3       0.0
latch: cache buffers chains           14         14          0      18       0.0
rdbms ipc reply                       15          0          0      16       0.0
control file single write            115          0          0       2       0.0
SQL*Net more data from clie          828          0          0       0       0.1
latch: shared pool                    10          0          0      13       0.0
log file sequential read              44          0          0       2       0.0
latch: cache buffers lru ch            6          0          0      15       0.0
db file parallel write            13,132          0          0       0       2.0
latch: checkpoint queue lat            1          0          0      66       0.0
enq: CF - contention                   1          0          0      64       0.0
latch: row cache objects               2          0          0       6       0.0
SQL*Net more data to client          216          0          0       0       0.0
latch: redo allocation                 5          0          0       1       0.0
undo segment extension             6,712      6,712          0       0       1.0
buffer busy waits                      6          0          0       0       0.0
direct path read                      88          0          0       0       0.0
direct path write                    108          0          0       0       0.0
direct path write temp                64          0          0       0       0.0
Queue Monitor Task Wait                4          0          0       0       0.0
SQL*Net message from client       92,320          0    205,303    2224      14.3
jobq slave wait                   22,209     21,673     66,659    3001       3.4
queue messages                     6,328      6,304     31,555    4987       1.0
virtual circuit status             1,078      1,078     31,498   29219       0.2
Queue Monitor Wait                 1,054      1,054     31,479   29867       0.2
wait for unread message on        31,236     31,210     31,466    1007       4.8
wakeup time manager                  207         55     30,464  147169       0.0
Queue Monitor Slave Wait               1          1         60   60000       0.0
          -------------------------------------------------------------

Background Wait Events  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                    Total Wait    wait     Waits
Event                              Waits   Timeouts   Time (s)    (ms)      /txn
--------------------------- ------------ ---------- ---------- ------- ---------
log file parallel write            6,968          0        196      28       1.1
control file parallel write       10,849          0         96       9       1.7
process startup                       23          0          2      72       0.0
log file single write                 44          0          0      11       0.0
LGWR wait for redo copy              135          5          0       3       0.0
rdbms ipc reply                       15          0          0      16       0.0
control file sequential rea        1,710          0          0       0       0.3
control file single write            115          0          0       2       0.0
latch: library cache                  10          0          0      18       0.0
latch: cache buffers chains            2          2          0      59       0.0
log file sequential read              44          0          0       2       0.0
log buffer space                       2          0          0      47       0.0
db file parallel write            13,132          0          0       0       2.0
latch: checkpoint queue lat            1          0          0      66       0.0
latch: shared pool                     2          0          0       6       0.0
latch: redo allocation                 5          0          0       1       0.0
buffer busy waits                      6          0          0       0       0.0
direct path read                      88          0          0       0       0.0
direct path write                     88          0          0       0       0.0
Queue Monitor Task Wait                4          0          0       0       0.0
rdbms ipc message                 95,617     90,016    246,032    2573      14.8
Queue Monitor Wait                 1,054      1,054     31,479   29867       0.2
smon timer                           211          0     30,666  145336       0.0
wakeup time manager                  205         55     29,924  145970       0.0
          -------------------------------------------------------------

Time Model Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by Time (seconds) desc

                                                       Time      % Total
Statistic Name                                     (seconds)     DB Time
--------------------------------------------- -------------- -----------
DB time                                               513.09      100.00
background elapsed time                               450.82       87.86
sql execute elapsed time                              409.40       79.79
DB CPU                                                335.04       65.30
PL/SQL execution elapsed time                         163.63       31.89
background cpu time                                    68.92       13.43
parse time elapsed                                     25.45        4.96
hard parse elapsed time                                18.13        3.53
connection management call elapsed time                  .90         .18
PL/SQL compilation elapsed time                          .67         .13
Java execution elapsed time                              .37         .07
hard parse (sharing criteria) elapsed time               .13         .03
hard parse (bind mismatch) elapsed time                  .08         .01
sequence load elapsed time                               .06         .01
inbound PL/SQL rpc elapsed time                          .00         .00
failed parse elapsed time                                .00         .00
failed parse (out of shared memory) elapsed t            .00         .00
          -------------------------------------------------------------

Operating System Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161

Statistic Name                                   Value
----------------------------------- ------------------
AVG_BUSY_TICKS                               1,612,076
AVG_IDLE_TICKS                               1,623,609
AVG_IN_BYTES                             6,576,128,000
AVG_NICE_TICKS                                 101,484
AVG_OUT_BYTES                           21,369,929,728
AVG_SYS_TICKS                                   87,573
AVG_USER_TICKS                               1,423,019
BUSY_TICKS                                   1,612,076
IDLE_TICKS                                   1,623,609
IN_BYTES                                 6,576,128,000
NICE_TICKS                                     101,484
OUT_BYTES                               21,369,929,728
RSRC_MGR_CPU_WAIT_TIME                               0
SYS_TICKS                                       87,573
USER_TICKS                                   1,423,019
          -------------------------------------------------------------

Service Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by DB Time

                                                             Physical    Logical
Service Name                      DB Time (s)   DB CPU (s)      Reads      Reads
-------------------------------- ------------ ------------ ---------- ----------
o10g                                    307.3        238.1        369    765,403
SYS$USERS                               205.8         97.0     11,847  1,647,529
SYS$BACKGROUND                            0.0          0.0      1,336    247,889
o10gXDB                                   0.0          0.0          0          0
          -------------------------------------------------------------

Service Wait Class Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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
--------- --------- --------- --------- --------- --------- --------- ---------
o10g
      145       270        13        75         0         0     80886        30
SYS$USERS
     3797      3741       135       285         0         0     11988        21
SYS$BACKGROUND
   590876       919        41        78         0         0         0         0
          -------------------------------------------------------------

SQL ordered by Elapsed Time  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------
       123        114        1,035        0.1    24.0 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

       107         50            1      107.3    20.9 b6usrg82hwsa3
call dbms_stats.gather_database_stats_job_proc (  )

        70         64       23,035        0.0    13.6 8hk7xvhua40va
Module: OEM.SystemPool
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

        32         31       19,323        0.0     6.2 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

        30         18          526        0.1     5.8 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

        23         20       50,155        0.0     4.5 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3

        14         14       10,206        0.0     2.7 7gtztzv329wg0
select c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and
 cd.enabled = :1 and c.owner# = u.user#

         7          1            8        0.9     1.3 d92h3rjp0y217
begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

         7          6           18        0.4     1.3 6q766vsk5290x
BEGIN dbms_stats_internal.flush_cache_stats; END;

         6          5          108        0.1     1.2 bfzd6w0q8a103
Module: emagent@bhora (TNS V1-V3)
/* OracleOEM */
BEGIN
  IF (:1 = 'READ WRITE') THEN
    ----
    -- For a read-
write database appropriately configured, try to evaluate.
    ----
    dbsnmp.mg
mt_response.get_metric_curs(:2);
  ELSE
    ----
    -- For a read-only database
, do not evaluate, but rather return an empty
    -- cursor.
    ----
    DECLAR

         6          6        9,864        0.0     1.2 bnucpshq8d51j
Module: OEM.SystemPool
UPDATE MGMT_METRICS_RAW SET STRING_VALUE= :1 , VALUE= :2  WHERE TARGET_GUID= HEX
TORAW(:3) AND COLLECTION_TIMESTAMP= :4 AND KEY_VALUE= NVL(:5, ' ') AND METRIC_GU
ID= HEXTORAW(:6)

          -------------------------------------------------------------

SQL ordered by CPU Time  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------
       114        123        1,035        0.11    24.0 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

        64         70       23,035        0.00    13.6 8hk7xvhua40va
Module: OEM.SystemPool
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

        50        107            1       50.16    20.9 b6usrg82hwsa3
call dbms_stats.gather_database_stats_job_proc (  )

        31         32       19,323        0.00     6.2 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

        20         23       50,155        0.00     4.5 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3

        18         30          526        0.03     5.8 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

        14         14       10,206        0.00     2.7 7gtztzv329wg0
select c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and
 cd.enabled = :1 and c.owner# = u.user#

         6          7           18        0.36     1.3 6q766vsk5290x
BEGIN dbms_stats_internal.flush_cache_stats; END;

         6          6        9,864        0.00     1.2 bnucpshq8d51j
Module: OEM.SystemPool
UPDATE MGMT_METRICS_RAW SET STRING_VALUE= :1 , VALUE= :2  WHERE TARGET_GUID= HEX
TORAW(:3) AND COLLECTION_TIMESTAMP= :4 AND KEY_VALUE= NVL(:5, ' ') AND METRIC_GU
ID= HEXTORAW(:6)

         5          6          108        0.04     1.2 bfzd6w0q8a103
Module: emagent@bhora (TNS V1-V3)
/* OracleOEM */
BEGIN
  IF (:1 = 'READ WRITE') THEN
    ----
    -- For a read-
write database appropriately configured, try to evaluate.
    ----
    dbsnmp.mg
mt_response.get_metric_curs(:2);
  ELSE
    ----
    -- For a read-only database
, do not evaluate, but rather return an empty
    -- cursor.
    ----
    DECLAR

         1          7            8        0.15     1.3 d92h3rjp0y217
begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

          -------------------------------------------------------------

SQL ordered by Gets  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:       2,655,828
-> Captured SQL accounts for    106.5% of Total Buffer Gets

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
       924,450            1    924,450.0   34.8    50.16    107.32 b6usrg82hwsa3
call dbms_stats.gather_database_stats_job_proc (  )

       459,395       23,035         19.9   17.3    64.00     69.76 8hk7xvhua40va
Module: OEM.SystemPool
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

       309,881        2,059        150.5   11.7     1.92      2.61 7vaq3b61mm72q
SELECT SU.NAME, SO.NAME, A.STATSTYPE#, A.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, US
ER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AN
D A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# A
ND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2

       308,660          526        586.8   11.6    18.38     29.99 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

       158,329           48      3,298.5    6.0     1.72      4.26 2zwjrv2186835
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1

       153,560       50,155          3.1    5.8    20.17     23.04 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3

       117,515       19,323          6.1    4.4    30.81     31.94 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

       112,266       10,206         11.0    4.2    13.63     13.63 7gtztzv329wg0
select c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and
 cd.enabled = :1 and c.owner# = u.user#

        84,419        2,059         41.0    3.2     0.84      0.85 g1xapjmt4vm5c
SELECT SU.NAME, SO.NAME, A.STATSTYPE#, A.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, US
ER$ U, COL$ C, OBJ$ SO, USER$ SU WHERE O.OWNER#=U.USER# AND A.OBJ#=O.OBJ# AND O.
OBJ#=C.OBJ# AND C.INTCOL#=A.INTCOL# AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.US
ER# AND O.TYPE#=2 AND U.NAME=:B3 AND O.NAME=:B2 AND C.NAME=:B1

        81,544            1     81,544.0    3.1     2.04      3.55 gztxrdrasr2f4
MERGE INTO STATS_TARGET$ ST USING (SELECT * FROM ( SELECT DECODE(BITAND(T.FLAGS,
16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAG
S, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATE
S), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -10

        58,067       19,323          3.0    2.2     4.43      4.71 6gh8gj9n09vr7
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERA
TE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE ST
EP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND S
TEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=

        39,909        9,864          4.0    1.5     5.82      5.96 bnucpshq8d51j
Module: OEM.SystemPool
UPDATE MGMT_METRICS_RAW SET STRING_VALUE= :1 , VALUE= :2  WHERE TARGET_GUID= HEX
TORAW(:3) AND COLLECTION_TIMESTAMP= :4 AND KEY_VALUE= NVL(:5, ' ') AND METRIC_GU
ID= HEXTORAW(:6)
SQL ordered by Gets  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:       2,655,828
-> Captured SQL accounts for    106.5% of Total Buffer Gets

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------

        35,172          230        152.9    1.3     0.72      4.20 0ybwd63u2any5
insert into sys.wri$_optstat_histgrm_history (obj#,intcol#,savtime,bucket, endpo
int,epvalue) select hg.obj#,hg.intcol#,:3,hg.bucket,hg.endpoint, hg.epvalue from
 sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2

        28,996          382         75.9    1.1     2.94      4.18 abtp0uqvdb1d3
CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

        28,980        1,035         28.0    1.1   114.00    123.26 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

        27,670           18      1,537.2    1.0     6.50      6.67 6q766vsk5290x
BEGIN dbms_stats_internal.flush_cache_stats; END;

          -------------------------------------------------------------

SQL ordered by Reads  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Total Disk Reads:          13,282
-> Captured SQL accounts for    113.6% of Total Disk Reads

                               Reads              CPU     Elapsed
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
        11,324           1      11,324.0   85.3    50.16    107.32 b6usrg82hwsa3
call dbms_stats.gather_database_stats_job_proc (  )

           456       2,046           0.2    3.4     1.30      3.62 cydgw456rs7z0
insert into sys.wri$_optstat_histhead_history(obj#,intcol#,savtime,flags, null_c
nt,minimum,maximum,distcnt,density,lowval,hival,avgcln,sample_distcnt, sample_si
ze,timestamp#) select h.obj#, h.intcol#, :3, bitand(h.spare2,7) + 8 + decode(h.c
ache_cnt,0,0,64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowv

           386         230           1.7    2.9     0.72      4.20 0ybwd63u2any5
insert into sys.wri$_optstat_histgrm_history (obj#,intcol#,savtime,bucket, endpo
int,epvalue) select hg.obj#,hg.intcol#,:3,hg.bucket,hg.endpoint, hg.epvalue from
 sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2

           346           1         346.0    2.6     1.56      2.37 bxtzzf9mcjrnr
select  /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monit
oring */  count(*),sum(vsize("SNAP_ID")),sum(vsize("DBID")),sum(vsize("INSTANCE_
NUMBER")),count(distinct "SQL_ID"),sum(vsize("SQL_ID")),substrb(dump(min("SQL_ID
"),16,0,32),1,120),substrb(dump(max("SQL_ID"),16,0,32),1,120),count(distinct "PL

           309         526           0.6    2.3    18.38     29.99 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

           295          19          15.5    2.2     0.08      1.85 6hfvx4j60unx6
Module: OEM.BoundedPool
SELECT SEVERITY_CODE, COLLECTION_TIMESTAMP, SEVERITY_GUID FROM MGMT_SEVERITY, (S
ELECT MAX(COLLECTION_TIMESTAMP) AS MAX_TIMESTAMP FROM MGMT_SEVERITY WHERE TARGET
_GUID = :B5 AND METRIC_GUID = :B4 AND KEY_VALUE = :B3 AND COLLECTION_TIMESTAMP >
 :B2 AND SEVERITY_CODE != :B1 ) TS WHERE TARGET_GUID = :B5 AND METRIC_GUID = :B4

           295           1         295.0    2.2     0.06      0.42 drrr67vsm6xsw
select  /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monit
oring */  count(*),count("SYS_NC00058$"),count(distinct "SYS_NC00058$"),sum(vsiz
e("SYS_NC00058$")),substrb(dump(min("SYS_NC00058$"),16,0,32),1,120),substrb(dump
(max("SYS_NC00058$"),16,0,32),1,120),count("SYS_NC00059$"),count(distinct "SYS_N

           245          12          20.4    1.8     0.13      1.65 cmjf0y5s3t51t
Module: OEM.BoundedPool
INSERT INTO MGMT_SEVERITY(COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSI
D, MESSAGE_PARAMS, METRIC_GUID, SEVERITY_CODE, TARGET_GUID) VALUES ( :1, NVL(:2,
 ' '), :3, :4, :5, :6, :7, :8)

           233           5          46.6    1.8     0.12      0.63 b2hrmq9xsdw51
BEGIN EMD_LOADER.STRING_HISTORY_PURGE(:1); END;

           230           5          46.0    1.7     0.09      0.57 6g1p4s9ra6ag8
Module: Oracle Enterprise Manager.string history purge
SELECT SMH.ROWID FROM (SELECT TARGET_GUID,METRIC_GUID,KEY_VALUE, LEAST(MAX(COLLE
CTION_TIMESTAMP),:B2 ) MAX_COLL FROM MGMT_STRING_METRIC_HISTORY WHERE TARGET_GUI
D = :B1 GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE) MAX_STR_HIST, MGMT_STRING_
METRIC_HISTORY SMH WHERE SMH.TARGET_GUID = MAX_STR_HIST.TARGET_GUID AND SMH.METR

           213           1         213.0    1.6     0.15      0.70 4jzzvw4mgv4x9
select /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monito
ring no_expand index(t,"WRH$_SYSSTAT_PK") */ count(*) as nrw,count(distinct sys_
op_lbid(8134,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,
15),1) as clf from "SYS"."WRH$_SYSSTAT"  t where "DBID" is not null or "SNAP_ID"

SQL ordered by Reads  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Total Disk Reads:          13,282
-> Captured SQL accounts for    113.6% of Total Disk Reads

                               Reads              CPU     Elapsed
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
           149           1         149.0    1.1     0.31      0.42 0m7ph2r512s7m
select  /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monit
oring */  count(*),sum(vsize("SNAP_ID")),sum(vsize("DBID")),count(distinct "INST
ANCE_NUMBER"),sum(vsize("INSTANCE_NUMBER")),substrb(dump(min("INSTANCE_NUMBER"),
16,0,32),1,120),substrb(dump(max("INSTANCE_NUMBER"),16,0,32),1,120),count(distin

           149           1         149.0    1.1     0.26      0.48 510p6fm16btpp
select  /*+ cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monit
oring */  count(*),count("SNAP_ID"),sum(vsize("SNAP_ID")),sum(vsize("DBID")),sum
(vsize("SQL_ID")),sum(vsize("PLAN_HASH_VALUE")),sum(vsize("ID")),count("OPERATIO
N"),count(distinct "OPERATION"),sum(vsize("OPERATION")),substrb(dump(min("OPERAT

          -------------------------------------------------------------

SQL ordered by Executions  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Total Executions:         280,145
-> Captured SQL accounts for     77.4% of Total Executions

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
      50,155          50,155            1.0       0.00        0.00 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3

      23,035          48,791            2.1       0.00        0.00 8hk7xvhua40va
Module: OEM.SystemPool
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)

      19,323               1            0.0       0.00        0.00 6gh8gj9n09vr7
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERA
TE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE ST
EP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND S
TEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=

      19,323          19,323            1.0       0.00        0.00 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

      17,666          17,666            1.0       0.00        0.00 089dbukv1aanh
Module: EM_PING
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

      10,206          10,206            1.0       0.00        0.00 7gtztzv329wg0
select c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and
 cd.enabled = :1 and c.owner# = u.user#

       9,864           9,864            1.0       0.00        0.00 bnucpshq8d51j
Module: OEM.SystemPool
UPDATE MGMT_METRICS_RAW SET STRING_VALUE= :1 , VALUE= :2  WHERE TARGET_GUID= HEX
TORAW(:3) AND COLLECTION_TIMESTAMP= :4 AND KEY_VALUE= NVL(:5, ' ') AND METRIC_GU
ID= HEXTORAW(:6)

       6,316             535            0.1       0.00        0.00 803b7z0t84sq7
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date < :2))    or  ((last_date is null) and (next_date < :3))) and (field1 =
 :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, jo
b

       4,859               0            0.0       0.00        0.00 8ggw94h7mvxd7
Module: EM_PING
COMMIT

       4,803           4,482            0.9       0.00        0.00 96g93hntrzjtr
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_
size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, a
vgcln from hist_head$ where obj#=:1 and intcol#=:2

       4,507           4,507            1.0       0.00        0.00 g2wr3u7s1gtf3
select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysd
ate+5/86400))

          -------------------------------------------------------------

SQL ordered by Parse Calls  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Total Parse Calls:          56,434
-> Captured SQL accounts for     66.2% of Total Parse Calls

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
      10,206       10,206     18.08 7gtztzv329wg0
select c.name, u.name from con$ c, cdef$ cd, user$ u  where c.con# = cd.con# and
 cd.enabled = :1 and c.owner# = u.user#

       2,298        4,859      4.07 8ggw94h7mvxd7
Module: EM_PING
COMMIT

       1,796        1,796      3.18 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

       1,127        1,127      2.00 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
 + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn

       1,098        1,098      1.95 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

       1,081        1,081      1.92 8hd36umbhpgsz
select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, de
finitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextp
ct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(t
runc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpar

       1,053        1,592      1.87 24dkx03u3rj6k
Module:
SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETE
R_VALUE)='TRUE'

         729          729      1.29 b2gnxm5z6r51n
lock table sys.col_usage$ in exclusive mode nowait

         703          703      1.25 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0

         695          230      1.23 53btfq0dt9bs9
insert into sys.col_usage$ values (   :objn, :coln,   decode(bitand(:flag,1),0,0
,1),   decode(bitand(:flag,2),0,0,1),   decode(bitand(:flag,4),0,0,1),   decode(
bitand(:flag,8),0,0,1),   decode(bitand(:flag,16),0,0,1),   decode(bitand(:flag,
32),0,0,1),   :time)

         689        1,687      1.22 3c1kubcdjnppq
update sys.col_usage$ set   equality_preds    = equality_preds    + decode(bitan
d(:flag,1),0,0,1),   equijoin_preds    = equijoin_preds    + decode(bitand(:flag
,2),0,0,1),   nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0
,1),   range_preds       = range_preds       + decode(bitand(:flag,8),0,0,1),

          -------------------------------------------------------------

SQL ordered by Sharable Memory  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

SQL ordered by Version Count  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

Instance Activity Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session                     30,404            0.9           4.7
CPU used when call started                   30,404            0.9           4.7
CR blocks created                             2,534            0.1           0.4
Cached Commit SCN referenced                  1,468            0.1           0.2
Commit SCN cached                                 9            0.0           0.0
DB time                                  10,444,646          322.6       1,620.1
DBWR checkpoint buffers written              32,093            1.0           5.0
DBWR checkpoints                                 11            0.0           0.0
DBWR thread checkpoint buffers w              3,290            0.1           0.5
DBWR transaction table writes                   357            0.0           0.1
DBWR undo block writes                        5,786            0.2           0.9
IMU CR rollbacks                              1,090            0.0           0.2
IMU Flushes                                   8,258            0.3           1.3
IMU Redo allocation size                 10,565,252          326.3       1,638.8
IMU commits                                   5,229            0.2           0.8
IMU contention                                   26            0.0           0.0
IMU ktichg flush                                125            0.0           0.0
IMU pool not allocated                          185            0.0           0.0
IMU recursive-transaction flush                   5            0.0           0.0
IMU undo allocation size                 25,539,528          788.9       3,961.5
IMU- failed to get a private str                185            0.0           0.0
SQL*Net roundtrips to/from clien             91,824            2.8          14.2
active txn count during cleanout                570            0.0           0.1
application wait time                           901            0.0           0.1
background checkpoints completed                 11            0.0           0.0
background checkpoints started                   11            0.0           0.0
background timeouts                          90,154            2.8          14.0
branch node splits                                1            0.0           0.0
buffer is not pinned count                  928,276           28.7         144.0
buffer is pinned count                      630,902           19.5          97.9
bytes received via SQL*Net from          15,862,496          490.0       2,460.5
bytes sent via SQL*Net to client          8,084,921          249.7       1,254.1
calls to get snapshot scn: kcmgs            428,508           13.2          66.5
calls to kcmgas                              14,189            0.4           2.2
calls to kcmgcs                                 892            0.0           0.1
change write time                             1,613            0.1           0.3
cleanout - number of ktugct call              1,077            0.0           0.2
cleanouts and rollbacks - consis                 54            0.0           0.0
cleanouts only - consistent read                177            0.0           0.0
cluster key scan block gets                 113,177            3.5          17.6
cluster key scans                            36,368            1.1           5.6
commit cleanout failures: block                 180            0.0           0.0
commit cleanout failures: buffer                  0            0.0           0.0
commit cleanout failures: callba                  5            0.0           0.0
commit cleanouts                             50,668            1.6           7.9
commit cleanouts successfully co             50,483            1.6           7.8
commit txn count during cleanout                744            0.0           0.1
concurrency wait time                           443            0.0           0.1
consistent changes                            8,984            0.3           1.4
consistent gets                           1,943,695           60.0         301.5
consistent gets - examination               754,104           23.3         117.0
consistent gets direct                           11            0.0           0.0
consistent gets from cache                1,943,684           60.0         301.5
cursor authentications                          794            0.0           0.1
data blocks consistent reads - u              3,950            0.1           0.6
db block changes                            702,984           21.7         109.0
db block gets                               712,133           22.0         110.5
db block gets direct                            370            0.0           0.1
db block gets from cache                    711,763           22.0         110.4
deferred (CURRENT) block cleanou             32,634            1.0           5.1
Instance Activity Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
enqueue conversions                           6,918            0.2           1.1
enqueue releases                            289,747            9.0          44.9
enqueue requests                            289,747            9.0          44.9
enqueue waits                                     1            0.0           0.0
execute count                               280,145            8.7          43.5
frame signature mismatch                          4            0.0           0.0
free buffer inspected                             5            0.0           0.0
free buffer requested                        21,250            0.7           3.3
heap block compress                             640            0.0           0.1
immediate (CR) block cleanout ap                231            0.0           0.0
immediate (CURRENT) block cleano             14,416            0.5           2.2
index fast full scans (full)                    838            0.0           0.1
index fetch by key                          390,960           12.1          60.6
index scans kdiixs1                         229,725            7.1          35.6
leaf node 90-10 splits                           92            0.0           0.0
leaf node splits                                247            0.0           0.0
logons cumulative                               726            0.0           0.1
messages received                            19,253            0.6           3.0
messages sent                                19,253            0.6           3.0
no buffer to keep pinned count                    0            0.0           0.0
no work - consistent read gets              922,936           28.5         143.2
opened cursors cumulative                    54,601            1.7           8.5
parse count (failures)                           19            0.0           0.0
parse count (hard)                            2,000            0.1           0.3
parse count (total)                          56,434            1.7           8.8
parse time cpu                                1,520            0.1           0.2
parse time elapsed                            2,557            0.1           0.4
physical read IO requests                     4,517            0.1           0.7
physical reads                               13,282            0.4           2.1
physical reads cache                         13,194            0.4           2.1
physical reads cache prefetch                 8,765            0.3           1.4
physical reads direct                            88            0.0           0.0
physical reads direct temporary                   0            0.0           0.0
physical reads prefetch warmup                2,754            0.1           0.4
physical write IO requests                   14,923            0.5           2.3
physical writes                              32,551            1.0           5.1
physical writes direct                          458            0.0           0.1
physical writes direct (lob)                     11            0.0           0.0
physical writes direct temporary                359            0.0           0.1
physical writes from cache                   32,093            1.0           5.0
physical writes non checkpoint                6,414            0.2           1.0
process last non-idle time          779,632,167,582   24,081,626.8 #############
recursive calls                           1,063,245           32.8         164.9
recursive cpu usage                          24,834            0.8           3.9
redo blocks written                         213,638            6.6          33.1
redo buffer allocation retries                  148            0.0           0.0
redo entries                                326,647           10.1          50.7
redo log space requests                          32            0.0           0.0
redo log space wait time                        176            0.0           0.0
redo ordering marks                               2            0.0           0.0
redo size                               103,917,804        3,209.9      16,118.8
redo synch time                               8,509            0.3           1.3
redo synch writes                             2,965            0.1           0.5
redo wastage                              2,018,844           62.4         313.1
redo write time                              19,786            0.6           3.1
redo writer latching time                        34            0.0           0.0
redo writes                                   6,968            0.2           1.1
rollback changes - undo records              19,105            0.6           3.0
rollbacks only - consistent read              2,480            0.1           0.4
rows fetched via callback                   178,757            5.5          27.7
Instance Activity Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
session connect time                779,632,167,582   24,081,626.8 #############
session logical reads                     2,655,828           82.0         412.0
session pga memory                        3,605,372          111.4         559.2
session pga memory max                   15,450,360          477.2       2,396.5
session uga memory                       17,081,964          527.6       2,649.6
session uga memory max                  417,626,868       12,899.9      64,778.5
shared hash latch upgrades - no             248,350            7.7          38.5
sorts (memory)                               30,456            0.9           4.7
sorts (rows)                              4,739,857          146.4         735.2
switch current to new buffer                  1,337            0.0           0.2
table fetch by rowid                        435,678           13.5          67.6
table fetch continued row                     1,957            0.1           0.3
table scan blocks gotten                    137,344            4.2          21.3
table scan rows gotten                    3,732,821          115.3         579.0
table scans (long tables)                         1            0.0           0.0
table scans (short tables)                   32,798            1.0           5.1
transaction rollbacks                           343            0.0           0.1
undo change vector size                  40,224,312        1,242.5       6,239.2
user I/O wait time                            4,808            0.2           0.8
user calls                                   95,988            3.0          14.9
user commits                                  5,925            0.2           0.9
user rollbacks                                  522            0.0           0.1
workarea executions - optimal                19,469            0.6           3.0
write clones created in foregrou                 52            0.0           0.0
          -------------------------------------------------------------

Instance Activity Stats - Absolute Values  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Statistics with absolute values (should not be diffed)
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
logons current                                24              29
open threads (derived)                         1               1
opened cursors current                       331             394
          -------------------------------------------------------------

Instance Activity Stats - Thread Activity  DB/Inst: O10G/o10g  Snaps: 2152-2161

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                           11      1.22
          -------------------------------------------------------------

Tablespace IO Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX
         3,316       0   11.4     3.4       12,447        0          0    0.0
SYSTEM
         1,225       0    8.9     1.6        1,336        0          0    0.0
UNDOTBS1
            12       0    2.5     1.0        1,052        0          6    0.0
STUDENT_DATA
           131       0    2.0     1.0           11        0          0    0.0
TEMP
            44       0    0.2     8.2           33        0          0    0.0
USERS
            31       0    3.5     1.0           11        0          0    0.0
ASSM_DATA
            11       0    0.0     1.0           11        0          0    0.0
EXAMPLE
            11       0    0.0     1.0           11        0          0    0.0
UNDOTBS2
            11       0    0.0     1.0           11        0          0    0.0
          -------------------------------------------------------------

File IO Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ASSM_DATA                /u01/app/oracle/oradata/o10g/addm_data01.dbf
            11       0    0.0     1.0           11        0          0    0.0
EXAMPLE                  /u01/app/oracle/oradata/o10g/example01.dbf
            11       0    0.0     1.0           11        0          0    0.0
STUDENT_DATA             /u01/app/oracle/oradata/o10g/student_data01.dbf
           131       0    2.0     1.0           11        0          0    0.0
SYSAUX                   /u01/app/oracle/oradata/o10g/sysaux01.dbf
         3,316       0   11.4     3.4       12,447        0          0    0.0
SYSTEM                   /u01/app/oracle/oradata/o10g/system01.dbf
         1,225       0    8.9     1.6        1,336        0          0    0.0
TEMP                     /u01/app/oracle/oradata/o10g/temp01.dbf
            44       0    0.2     8.2           33        0          0
UNDOTBS1                 /u01/app/oracle/oradata/o10g/undotbs01.dbf
            12       0    2.5     1.0        1,052        0          6    0.0
UNDOTBS2                 /u01/app/oracle/oradata/o10g/undotbs02.dbf
            11       0    0.0     1.0           11        0          0    0.0
USERS                    /u01/app/oracle/oradata/o10g/users01.dbf
            31       0    3.5     1.0           11        0          0    0.0
          -------------------------------------------------------------

Buffer Pool Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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       50,601   99      2,657,298       13,314      32,093    0    0          6
          -------------------------------------------------------------

Instance Recovery Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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    20        947      5122     10585      18432     10585
E     0    17        404      2100      5976      18432      5976
          -------------------------------------------------------------

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

        Size for  Size      Buffers for  Est Physical          Estimated
P   Estimate (M) Factr         Estimate   Read Factor     Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D             40    .1            5,010          3.04             69,801
D             80    .2           10,020          1.53             35,028
D            120    .3           15,030          1.28             29,361
D            160    .4           20,040          1.14             26,147
D            200    .5           25,050          1.02             23,390
D            240    .6           30,060          1.00             22,958
D            280    .7           35,070          1.00             22,958
D            320    .8           40,080          1.00             22,958
D            360    .9           45,090          1.00             22,958
D            400   1.0           50,100          1.00             22,958
D            404   1.0           50,601          1.00             22,958
D            440   1.1           55,110          1.00             22,958
D            480   1.2           60,120          1.00             22,958
D            520   1.3           65,130          1.00             22,958
D            560   1.4           70,140          1.00             22,958
D            600   1.5           75,150          1.00             22,958
D            640   1.6           80,160          1.00             22,958
D            680   1.7           85,170          1.00             22,958
D            720   1.8           90,180          1.00             22,958
D            760   1.9           95,190          1.00             22,958
D            800   2.0          100,200          1.00             22,958
          -------------------------------------------------------------

PGA Aggr Summary  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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                662                          0
          -------------------------------------------------------------

PGA Aggr Target Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> 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        188        149       57.5        0.0     .0     .0     .0      9,625
E        188        146       62.1        0.0     .0     .0     .0      9,625
          -------------------------------------------------------------

PGA Aggr Target Histogram  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Optimal Executions are purely in-memory operations

  Low     High
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K         18,540         18,540            0            0
    64K    128K             59             59            0            0
   128K    256K             86             86            0            0
   256K    512K             63             63            0            0
   512K   1024K            745            745            0            0
     2M      4M              2              2            0            0
          -------------------------------------------------------------

PGA Memory Advisory  DB/Inst: O10G/o10g  Snap: 2161
-> 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            730.3             23.3     97.0         10
        47     0.3            730.3              2.9    100.0          0
        94     0.5            730.3              0.0    100.0          0
       141     0.8            730.3              0.0    100.0          0
       188     1.0            730.3              0.0    100.0          0
       226     1.2            730.3              0.0    100.0          0
       263     1.4            730.3              0.0    100.0          0
       301     1.6            730.3              0.0    100.0          0
       338     1.8            730.3              0.0    100.0          0
       376     2.0            730.3              0.0    100.0          0
       564     3.0            730.3              0.0    100.0          0
       752     4.0            730.3              0.0    100.0          0
     1,128     6.0            730.3              0.0    100.0          0
     1,504     8.0            730.3              0.0    100.0          0
          -------------------------------------------------------------

Shared Pool Advisory  DB/Inst: O10G/o10g  Snap: 2161
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
        36    .2       17        2,962     118    1.0      57    1.1      45,614
        52    .4       32        5,431     121    1.0      54    1.0      46,014
        68    .5       43        6,723     121    1.0      54    1.0      46,033
        84    .6       43        6,723     121    1.0      54    1.0      46,033
       100    .7       43        6,723     121    1.0      54    1.0      46,033
       116    .8       43        6,723     121    1.0      54    1.0      46,033
       132    .9       43        6,723     121    1.0      54    1.0      46,033
       148   1.0       43        6,723     121    1.0      54    1.0      46,033
       164   1.1       43        6,723     121    1.0      54    1.0      46,033
       180   1.2       43        6,723     121    1.0      54    1.0      46,033
       196   1.3       43        6,723     121    1.0      54    1.0      46,033
       212   1.4       43        6,723     121    1.0      54    1.0      46,033
       228   1.5       43        6,723     121    1.0      54    1.0      46,033
       244   1.6       43        6,723     121    1.0      54    1.0      46,033
       260   1.8       43        6,723     121    1.0      54    1.0      46,033
       276   1.9       43        6,723     121    1.0      54    1.0      46,033
       292   2.0       43        6,723     121    1.0      54    1.0      46,033
       308   2.1       43        6,723     121    1.0      54    1.0      46,033
          -------------------------------------------------------------

Java Pool Advisory  DB/Inst: O10G/o10g  Snap: 2161

                                        Est LC Est LC  Est LC Est LC
      Java    JP   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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
         4    .5        4           44       0     .0      31    1.0           0
         8   1.0        4           44       0     .0      31    1.0           0
        12   1.5        4           44       0     .0      31    1.0           0
        16   2.0        4           44       0     .0      31    1.0           0
          -------------------------------------------------------------

Buffer Wait Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by wait time desc, waits desc

Class                    Waits Total Wait Time (s)  Avg Time (ms)
------------------ ----------- ------------------- --------------
undo header                  6                   0              0
          -------------------------------------------------------------

Enqueue Activity  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Enqueue stats gathered prior to 10i should not be compared with 10i 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)
------------ ------------ ----------- ----------- ------------ --------------
CF-Controlfile Transaction
      10,933       10,933           0           1            0          70.00
          -------------------------------------------------------------

Undo Segment Summary  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> Undo segment block stats:
-> uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
-> eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo         Undo             Num  Max Qry   Max Tx   Snap OutOf    uS/uR/uU/
 TS#       Blocks           Trans  Len (s) Concurcy TooOld Space    eS/eR/eU
---- ------------ --------------- -------- -------- ------ ----- ---------------
   1        5,730          10,047      123        4      0     0 0/0/0/0/0/0
          -------------------------------------------------------------

Undo Segment Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by Time desc

                    Undo          Num Max Qry  Max Tx   Snap OutOf   uS/uR/uU/
End Time          Blocks        Trans Len (s)   Concy TooOld Space   eS/eR/eU
------------ ----------- ------------ ------- ------- ------ ----- -------------
30-Mar 06:04         234          197       0       3      0     0 0/0/0/0/0/0
30-Mar 05:54          52          138       0       2      0     0 0/0/0/0/0/0
30-Mar 05:44          46          106       0       3      0     0 0/0/0/0/0/0
30-Mar 05:34          58          139       0       2      0     0 0/0/0/0/0/0
30-Mar 05:24          49          103       0       1      0     0 0/0/0/0/0/0
30-Mar 05:14          41          176       0       1      0     0 0/0/0/0/0/0
30-Mar 05:04         231          190       0       3      0     0 0/0/0/0/0/0
30-Mar 04:54          51          139       0       2      0     0 0/0/0/0/0/0
30-Mar 04:44          42          102       0       1      0     0 0/0/0/0/0/0
30-Mar 04:34          60          147       0       3      0     0 0/0/0/0/0/0
30-Mar 04:24          51          114       0       2      0     0 0/0/0/0/0/0
30-Mar 04:14          44          215       0       2      0     0 0/0/0/0/0/0
30-Mar 04:04         218          187       0       3      0     0 0/0/0/0/0/0
30-Mar 03:54          50          136       0       2      0     0 0/0/0/0/0/0
30-Mar 03:44          44          102       0       1      0     0 0/0/0/0/0/0
30-Mar 03:34          61          154       0       3      0     0 0/0/0/0/0/0
30-Mar 03:24          48          102       0       1      0     0 0/0/0/0/0/0
30-Mar 03:14          45          235       0       1      0     0 0/0/0/0/0/0
30-Mar 03:04         226          192       0       3      0     0 0/0/0/0/0/0
30-Mar 02:54          50          152       0       1      0     0 0/0/0/0/0/0
30-Mar 02:44          53          108       0       3      0     0 0/0/0/0/0/0
30-Mar 02:34          57          136       0       2      0     0 0/0/0/0/0/0
30-Mar 02:24          52           82       0       3      0     0 0/0/0/0/0/0
30-Mar 02:14          40          220       0       1      0     0 0/0/0/0/0/0
30-Mar 02:04         255          210       0       3      0     0 0/0/0/0/0/0
30-Mar 01:54          50          141       0       1      0     0 0/0/0/0/0/0
30-Mar 01:44          46          130       0       1      0     0 0/0/0/0/0/0
30-Mar 01:34          57          104       0       1      0     0 0/0/0/0/0/0
30-Mar 01:24          50          213       0       1      0     0 0/0/0/0/0/0
30-Mar 01:14          42          104       0       1      0     0 0/0/0/0/0/0
30-Mar 01:04         229          245       0       3      0     0 0/0/0/0/0/0
30-Mar 00:54          63          152       0       3      0     0 0/0/0/0/0/0
30-Mar 00:44          44           95       0       2      0     0 0/0/0/0/0/0
30-Mar 00:34          63          154       0       3      0     0 0/0/0/0/0/0
          -------------------------------------------------------------

Latch Activity  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
Consistent RBA                    6,980    0.0             0            0
FIB s.o chain latch                   4    0.0             0            0
FOB s.o list latch                  681    0.0             0            0
In memory undo latch            105,933    0.0             0       15,838    0.0
JOX SGA heap latch                  198    0.0             0            0
JS mem alloc latch                    8    0.0             0            0
JS queue access latch                 8    0.0             0            0
JS queue state obj latch        227,514    0.0             0            0
JS slv state obj latch               13    0.0             0            0
KMG resize request state              2    0.0             0            0
KTF sga enqueue                      57    0.0             0        9,222    0.0
KWQMN job cache list lat          1,320    0.0             0            0
MQL Tracking Latch                    0                    0          641    0.0
Memory Management Latch         157,430    0.0             0       10,498    0.0
PL/SQL warning settings             745    0.0             0            0
SQL memory manager latch              9    0.0             0       10,471    0.0
SQL memory manager worka        729,476    0.0             0            0
SWRF Alerted Metric Elem        110,246    0.0             0            0
active checkpoint queue          23,686    0.0             0            0
active service list              53,591    0.0             0            0
archive control                     198    0.0             0            0
begin backup scn array               10    0.0             0            0
buffer pool                           1    0.0             0            0
cache buffer handles              5,710    0.0             0            0
cache buffers chains          6,243,756    0.0    2.3      0       30,610    0.0
cache buffers lru chain          97,212    0.0    1.0      0       19,506    0.0
channel handle pool latc            787    0.0             0            0
channel operations paren     88,465,302    0.0             0            0
checkpoint queue latch          292,762    0.0    1.0      0       25,666    0.0
child cursor hash table          18,402    0.0             0            0
client/application info           2,668    0.0             0            0
commit callback allocati            360    0.0             0            0
compile environment latc         38,275    0.0             0            0
cursor bind value captur            980    0.0             0        3,994    0.0
dictionary lookup                    11    0.0             0            0
dml lock allocation              39,473    0.0             0            0
dummy allocation                  1,447    0.0             0            0
enqueue hash chains             586,633    0.0             0            0
enqueues                        559,340    0.0             0            0
event group latch                   189    0.0             0            0
file cache latch                  1,518    0.0             0            0
global KZLD latch for me            164    0.0             0            0
hash table column usage           1,466    0.0             0       85,446    0.0
hash table modification             567    0.0             0            0
internal temp table obje              6    0.0             0            0
job workq parent latch                0                    0        1,074    0.0
job_queue_processes free              2    0.0             0            0
job_queue_processes para          2,129    0.0             0            0
kmcptab latch                         2    0.0             0            0
kmcpvec latch                         0                    0            2    0.0
ksuosstats global area            2,176    0.0             0            0
ktm global data                     233    0.0             0            0
lgwr LWN SCN                     14,511    0.0             0            0
library cache                 1,914,545    0.0    1.2      4            0
library cache load lock           6,462    0.0             0            0
library cache lock              456,810    0.0             0            0
library cache lock alloc         12,122    0.0             0            0
library cache pin             1,262,174    0.0             0            1    0.0
library cache pin alloca         13,806    0.0             0            0
list of block allocation          4,128    0.0             0            0
Latch Activity  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
loader state object free            320    0.0             0            0
longop free list parent             180    0.0             0          187    0.0
message pool operations             466    0.0             0            0
messages                        225,558    0.0             0            0
mostly latch-free SCN            14,511    0.0             0            0
multiblock read objects           3,996    0.0             0            0
ncodef allocation latch             517    0.0             0            0
object queue header heap            855    0.0             0            0
object queue header oper        292,394    0.0             0            0
object stats modificatio          1,631    0.0             0            0
parallel query alloc buf          4,188    0.0             0            0
parameter list                        6    0.0             0            0
parameter table allocati          1,447    0.0             0            0
post/wait queue                   6,733    0.0             0        3,278    0.0
process allocation                  189    0.0             0          189    0.0
process group creation              373    0.0             0            0
qmn state object latch                7    0.0             0            0
qmn task queue latch                 10    0.0             0            0
redo allocation                  53,726    0.0    1.0      0      326,664    0.0
redo copy                             3    0.0             0      326,736    0.0
redo writing                     66,725    0.0             0            0
row cache objects             1,290,156    0.0    2.0      0            0
sequence cache                    1,161    0.0             0            0
session allocation              654,248    0.0             0            0
session idle bit                229,534    0.0             0            0
session switching                   517    0.0             0            0
session timer                    10,857    0.0             0            0
shared pool                   1,034,510    0.0    1.0      0            0
simulator hash latch            404,275    0.0             0            0
simulator lru latch                 327    0.0             0        4,220    0.0
slave class                          21    0.0             0            0
slave class create                   85   10.6    1.0      1            0
sort extent pool                  2,132    0.0             0            0
state object free list               18    0.0             0            0
statistics aggregation            1,260    0.0             0            0
temporary table state ob             38    0.0             0            0
threshold alerts latch            1,523    0.0             0            0
trace latch                           4    0.0             0            0
transaction allocation            1,481    0.0             0            0
transaction branch alloc            517    0.0             0            0
undo global data                 50,988    0.0             0            0
user lock                         1,726    0.0             0            0
          -------------------------------------------------------------

Latch Sleep Breakdown  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> ordered by misses desc

Latch Name
----------------------------------------
  Get Requests      Misses      Sleeps  Spin Gets   Sleep1   Sleep2   Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
library cache
     1,914,545         140         170          0      120       15        5
shared pool
     1,034,510          10          10          0       10        0        0
slave class create
            85           9           9          0        9        0        0
cache buffers lru chain
        97,212           6           6          0        6        0        0
cache buffers chains
     6,243,756           6          14          0        0        4        2
redo allocation
        53,726           5           5          0        5        0        0
row cache objects
     1,290,156           1           2          0        0        1        0
checkpoint queue latch
       292,762           1           1          0        1        0        0
          -------------------------------------------------------------

Latch Miss Sources  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains     kcbnew: new latch again          0          5        0
cache buffers chains     kcbgtcr: fast path               0          5        3
cache buffers chains     kcbgcur: kslbegin                0          2        0
cache buffers chains     kcbzgb: scan from tail. no       0          2        0
cache buffers lru chain  kcbzgws_1                        0          5        4
cache buffers lru chain  kcbzgb: posted for free bu       0          1        1
checkpoint queue latch   kcbklbc: Link buffer into        0          1        0
library cache            kglic                            0         70        5
library cache            kglpnc: child                    0         21       23
library cache            kglpndl: child: after proc       0         19        0
library cache            kglpin: child: heap proces       0         15        0
library cache            kglupc: child                    0         11       98
library cache            kglpndl: child: before pro       0          8        5
library cache            kglobpn: child:                  0          6        4
library cache            kglhdgn: child:                  0          4        8
library cache            kgldte: child 0                  0          4        5
library cache            kglhdgc: child:                  0          4        0
library cache            kglpnp: child                    0          2       16
library cache            kglidp: child                    0          1        0
library cache lock       kgllkdl: child: no lock ha       0          5        5
redo allocation          kcrfw_redo_gen: redo alloc       0          5        0
row cache objects        kqrpre: find obj                 0          1        2
row cache objects        kqreqd                           0          1        0
shared pool              kghupr1                          0          7        3
shared pool              kghalo                           0          3        5
slave class create       ksvcreate                        0          9        0
          -------------------------------------------------------------

Parent Latch Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

Child Latch Statistics  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

Segments by Logical Reads  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> % Total shows % of logical reads for each top segment compared with total
   logical reads for all segments captured by the Snapshot

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN     SYSAUX     MGMT_METRICS_RAW_PK             INDEX      354,864   14.67
SYS        SYSAUX     SYS_IOT_TOP_8555                INDEX      341,488   14.12
SYS        SYSTEM     OBJ$                            TABLE      202,880    8.39
SYSMAN     SYSAUX     MGMT_CURRENT_METRICS            INDEX      157,648    6.52
SYS        SYSTEM     I_OBJ1                          INDEX       91,520    3.78
          -------------------------------------------------------------

Segments by Physical Reads  DB/Inst: O10G/o10g  Snaps: 2152-2161

           Tablespace                      Subobject  Obj.      Physical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS        SYSTEM     HISTGRM$                        TABLE        1,154   21.22
SYS        SYSAUX     I_WRI$_OPTSTAT_H_OBJ            INDEX          630   11.59
SYS        SYSAUX     I_WRI$_OPTSTAT_HH_OB            INDEX          350    6.44
SYS        SYSAUX     WRH$_SQLTEXT                    TABLE          320    5.89
SYS        SYSAUX     WRH$_SQL_PLAN                   TABLE          316    5.81
          -------------------------------------------------------------

Segments by Buffer Busy Waits  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

Segments by Row Lock Waits  DB/Inst: O10G/o10g  Snaps: 2152-2161

                                                                     Row
           Tablespace                      Subobject  Obj.          Lock
Owner         Name    Object Name            Name     Type         Waits  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN     SYSAUX     MGMT_METRICS_1HOUR_P            INDEX            1  100.00
          -------------------------------------------------------------

Segments by ITL Waits  DB/Inst: O10G/o10g  Snaps: 2152-2161

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

Dictionary Cache Stats  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> "Pct Misses"  should be very low (< 2% in most cases)
-> "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                     574    0.0       0             18          1
dc_constraints                     132   34.1       0            132          1
dc_files                           160    0.0       0              0          8
dc_global_oids                  84,028    0.0       0              0         68
dc_histogram_data                8,840   23.1       0          1,526      2,834
dc_histogram_defs               21,369   27.3       0          2,053      3,609
dc_object_ids                  103,869    0.3       0             11      1,113
dc_objects                      14,992    3.9       0             34      2,316
dc_profiles                        865    0.0       0              0          2
dc_rollback_segments            10,523    0.0       0              0         37
dc_segments                      7,055    5.4       0             26      1,190
dc_sequences                        30   20.0       0             30         12
dc_table_scns                        9  100.0       0              0          0
dc_tablespaces                  47,998    0.0       0              0          9
dc_usernames                     2,525    0.1       0              0         18
dc_users                       126,519    0.0       0              0         61
outstanding_alerts                 512    2.5       0             26          9
          -------------------------------------------------------------

Library Cache Activity  DB/Inst: O10G/o10g  Snaps: 2152-2161
-> "Pct Misses"  should be very low

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   6,029    0.2         53,925    0.0          0        0
CLUSTER                  148    0.0            509    0.0          0        0
INDEX                    306   72.9          1,696   23.5          0        0
JAVA DATA                  9    0.0              0                 0        0
SQL AREA              41,977    3.7        374,560    0.9        266      279
TABLE/PROCEDURE        4,172    5.3         97,025    1.8        497        0
TRIGGER                  335    6.3         25,582    0.1          0        0
          -------------------------------------------------------------

SGA Memory Summary  DB/Inst: O10G/o10g  Snap: 2161

SGA regions                       Size in Bytes
------------------------------ ----------------
Database Buffers                    423,624,704
Fixed Size                              780,260
Redo Buffers                            262,144
Variable Size                       170,924,060
SGA breakdown difference  DB/Inst: O10G/o10g  Snaps: 2152-2161

Pool   Name                                Begin value        End value  % Diff
------ ------------------------------ ---------------- ---------------- -------
java   free memory                           2,808,320        2,808,320    0.00
java   joxlod exec hp                        5,346,432        5,346,432    0.00
java   joxs heap                               233,856          233,856    0.00
large  PX msg pool                             206,208          206,208    0.00
large  free memory                           3,988,096        3,988,096    0.00
shared ASH buffers                           2,097,152        2,097,152    0.00
shared KGLS heap                             3,941,704        4,617,664   17.15
shared KQR L SO                                119,808          308,232  157.27
shared KQR M PO                              2,696,792        3,632,296   34.69
shared KQR M SO                                328,704        1,297,112  294.61
shared KQR S PO                                243,524          345,512   41.88
shared KQR S SO                                  4,096            6,912   68.75
shared KSPD key heap                             4,220            4,220    0.00
shared KTI-UNDO                              1,235,304        1,235,304    0.00
shared PL/SQL DIANA                          2,420,836        2,536,712    4.79
shared PL/SQL MPCODE                         3,650,036        4,504,720   23.42
shared PLS non-lib hp                           10,404           10,404    0.00
shared PX subheap                               65,548           65,548    0.00
shared alert threshol                            4,452            4,452    0.00
shared dbwriter coalesce buffer              1,049,088        1,049,088    0.00
shared event statistics per sess             3,860,360        3,860,360    0.00
shared fixed allocation callback                   308              308    0.00
shared free memory                          82,411,664       49,474,400  -39.97
shared joxlod exec hp                          322,364          322,364    0.00
shared joxlod pcod hp                           63,848           63,848    0.00
shared joxs heap                                 4,220            4,220    0.00
shared library cache                        12,354,752       22,108,756   78.95
shared miscellaneous                        18,250,192       19,053,148    4.40
shared parameters                               76,512           96,348   25.93
shared partitioning d                          187,052          323,868   73.14
shared pl/sql source                             1,748           19,736 #######
shared private strands                       1,198,080        1,198,080    0.00
shared repository                              103,280          245,412  137.62
shared row cache                             3,707,272        3,707,272    0.00
shared sql area                             14,441,436       32,447,892  124.69
shared table definiti                           10,956            9,740  -11.10
shared temporary tabl                              748              748    0.00
shared trigger defini                           13,964           25,792   84.70
shared trigger inform                            2,008            2,008    0.00
shared trigger source                            2,340           13,560  479.49
shared type object de                          304,476          496,060   62.92
       buffer_cache                        423,624,704      423,624,704    0.00
       fixed_sga                               780,260          780,260    0.00
       log_buffer                              262,144          262,144    0.00
          -------------------------------------------------------------

Resource Limit Stats  DB/Inst: O10G/o10g  Snap: 2161

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

init.ora Parameters  DB/Inst: O10G/o10g  Snaps: 2152-2161

                                                                End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
__db_cache_size               423624704
__java_pool_size              8388608
__large_pool_size             4194304
__shared_pool_size            155189248
background_dump_dest          /u01/app/oracle/admin/o10g/bdump
compatible                    10.1.0.2.0
control_files                 /u01/app/oracle/oradata/o10g/cont
core_dump_dest                /u01/app/oracle/admin/o10g/cdump
db_block_size                 8192
db_domain
db_file_multiblock_read_count 16
db_name                       o10g
db_recovery_file_dest         /u01/app/oracle/flash_recovery_ar
db_recovery_file_dest_size    2147483648
dispatchers                   (PROTOCOL=TCP) (SERVICE=o10gXDB)
job_queue_processes           10
log_archive_dest_1            LOCATION=/u01/app/oracle/oradata2
log_archive_format            arch_%d_%T_%S_%R.log
open_cursors                  300
pga_aggregate_target          197132288
processes                     150
remote_login_passwordfile     EXCLUSIVE
sga_target                    595591168
undo_management               AUTO
undo_tablespace               UNDOTBS1
user_dump_dest                /u01/app/oracle/admin/o10g/udump
          -------------------------------------------------------------

End of Report
