STATSPACK report for

Database    DB Id    Instance     Inst Num Startup Time    Release     RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
          4259010470 vcentre             1 06-Aug-08 10:58 10.2.0.4.0  NO

Host  Name:   P-VERICENTRE     Num CPUs:    2        Phys Memory (MB):    2,047
~~~~

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:      53858 01-Sep-08 23:09:00       66       6.7
  End Snap:      53995 02-Sep-08 06:00:00       68      14.6
   Elapsed:              411.00 (mins)

Cache Sizes                       Begin        End
~~~~~~~~~~~                  ---------- ----------
               Buffer Cache:       704M             Std Block Size:         8K
           Shared Pool Size:       296M                 Log Buffer:     6,817K

Load Profile                            Per Second       Per Transaction
~~~~~~~~~~~~                       ---------------       ---------------
                  Redo size:             10,453.73             21,088.76
              Logical reads:                241.77                487.74
              Block changes:                 38.05                 76.76
             Physical reads:                 18.95                 38.22
            Physical writes:                  2.96                  5.98
                 User calls:                 61.85                124.78
                     Parses:                  4.09                  8.26
                Hard parses:                  0.28                  0.56
                      Sorts:                  2.50                  5.04
                     Logons:                  0.05                  0.09
                   Executes:                  9.63                 19.43
               Transactions:                  0.50

  % Blocks changed per Read:   15.74    Recursive Call %:    45.35
 Rollback per transaction %:    0.00       Rows per Sort:   270.53

Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:   99.99
            Buffer  Hit   %:   92.17    In-memory Sort %:  100.00
            Library Hit   %:   95.68        Soft Parse %:   93.22
         Execute to Parse %:   57.50         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   94.90     % Non-Parse CPU:   93.96

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   92.02   93.51
    % SQL with executions>1:   44.34   65.04
  % Memory for SQL w/exec>1:   45.59   67.97

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
CPU time                                                       888          42.4
db file sequential read                        109,828         465      4   22.2
RMAN backup & recovery I/O                      12,167         266     22   12.7
db file scattered read                          15,667         243     16   11.6
control file sequential read                    84,972         110      1    5.3
          -------------------------------------------------------------
Host CPU  (CPUs: 2)
~~~~~~~~              Load Average
                      Begin     End      User  System    Idle     WIO     WCPU
                    ------- -------   ------- ------- ------- ------- --------
                                         8.19    2.03   89.79

Instance CPU
~~~~~~~~~~~~
              % of total CPU for Instance:    6.93
              % of busy  CPU for Instance:   67.83
  %DB time waiting for CPU - Resource Mgr:

Memory Statistics                       Begin          End
~~~~~~~~~~~~~~~~~                ------------ ------------
                  Host Mem (MB):      2,047.5      2,047.5
                   SGA use (MB):      1,032.0      1,032.0
                   PGA use (MB):        161.1        165.4
    % Host Mem used for SGA+PGA:         58.3         58.5
          -------------------------------------------------------------

Time Model System Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Ordered by % of DB time desc, Statistic name

Statistic                                       Time (s) % of DB time
----------------------------------- -------------------- ------------
RMAN cpu time (backup/restore)                   2,331.1        115.4
sql execute elapsed time                         2,180.8        108.0
DB CPU                                             982.8         48.7
PL/SQL execution elapsed time                      519.1         25.7
parse time elapsed                                 100.2          5.0
hard parse elapsed time                             86.4          4.3
PL/SQL compilation elapsed time                      4.1           .2
sequence load elapsed time                           2.5           .1
hard parse (sharing criteria) elaps                  2.4           .1
repeated bind elapsed time                           1.7           .1
inbound PL/SQL rpc elapsed time                      1.6           .1
failed parse elapsed time                            0.5           .0
connection management call elapsed                   0.4           .0
hard parse (bind mismatch) elapsed                   0.1           .0
DB time                                          2,019.3
background elapsed time                          2,854.3
background cpu time                              2,433.9
          -------------------------------------------------------------
Wait Events  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> s - second, cs - centisecond,  ms - millisecond, us - microsecond
-> %Timeouts:  value of 0 indicates value was < .5%.  Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

                                                                    Avg
                                                %Time Total Wait   wait    Waits
Event                                    Waits  -outs   Time (s)   (ms)     /txn
--------------------------------- ------------ ------ ---------- ------ --------
db file sequential read                109,828      0        465      4      9.0
RMAN backup & recovery I/O              12,167      0        266     22      1.0
db file scattered read                  15,667      0        243     16      1.3
control file sequential read            84,972      0        110      1      7.0
control file parallel write              8,843      0         27      3      0.7
log file parallel write                 19,181      0         22      1      1.6
SQL*Net more data to client            365,163      0         21      0     29.9
db file parallel write                  11,725      0         18      2      1.0
log file sync                           12,267      0         15      1      1.0
log file sequential read                   326      0          7     21      0.0
Log archive I/O                            302      0          6     20      0.0
os thread startup                          272      0          4     15      0.0
PL/SQL lock timer                            1    100          1   1000      0.0
control file single write                   20      0          0     17      0.0
log file switch completion                   6      0          0     49      0.0
enq: CF - contention                        14      0          0     19      0.0
switch logfile command                       6      0          0     36      0.0
enq: TC - contention                         5      0          0     32      0.0
recovery area: computing obsolete            1      0          0    144      0.0
LGWR wait for redo copy                     54     19          0      2      0.0
direct path read                            25      0          0      4      0.0
log file single write                       12      0          0      7      0.0
latch: shared pool                          42      0          0      2      0.0
latch free                                   7      0          0      9      0.0
direct path write temp                      33      0          0      2      0.0
kksfbc child completion                      1    100          0     50      0.0
buffer busy waits                           90      0          0      0      0.0
rdbms ipc reply                             43      0          0      1      0.0
library cache load lock                      1      0          0     28      0.0
enq: JS - queue lock                         4      0          0      7      0.0
direct path read temp                        6      0          0      4      0.0
latch: cache buffers chains                 12      0          0      2      0.0
direct path write                           31      0          0      1      0.0
read by other session                        2      0          0     10      0.0
recovery area: computing applied             1      0          0     14      0.0
recovery area: computing backed u            1      0          0     13      0.0
db file parallel read                        5      0          0      3      0.0
latch: In memory undo latch                 95      0          0      0      0.0
recovery area: computing dropped             1      0          0     13      0.0
cursor: pin S wait on X                      1    100          0     10      0.0
SQL*Net break/reset to client               56      0          0      0      0.0
db file single write                         5      0          0      1      0.0
latch: library cache                         9      0          0      0      0.0
SQL*Net message from client          1,528,685      0    267,430    175    125.1
jobq slave wait                         13,871     94     40,766   2939      1.1
Streams AQ: qmn slave idle wait            879      0     24,577  27960      0.1
Streams AQ: qmn coordinator idle         1,788     51     24,577  13745      0.1
Streams AQ: waiting for time mana            5    100      8,216 ######      0.0
SQL*Net message to client            1,528,686      0          5      0    125.1
class slave wait                            12      0          0      0      0.0
Wait Events  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> s - second, cs - centisecond,  ms - millisecond, us - microsecond
-> %Timeouts:  value of 0 indicates value was < .5%.  Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

                                                                    Avg
                                                %Time Total Wait   wait    Waits
Event                                    Waits  -outs   Time (s)   (ms)     /txn
--------------------------------- ------------ ------ ---------- ------ --------
          -------------------------------------------------------------
Background Wait Events  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> %Timeouts:  value of 0 indicates value was < .5%.  Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

                                                                    Avg
                                                %Time Total Wait   wait    Waits
Event                                    Waits  -outs   Time (s)   (ms)     /txn
--------------------------------- ------------ ------ ---------- ------ --------
control file sequential read            25,889      0         55      2      2.1
control file parallel write              8,328      0         26      3      0.7
log file parallel write                 19,181      0         22      1      1.6
db file parallel write                  11,725      0         18      2      1.0
log file sequential read                   255      0          5     20      0.0
Log archive I/O                            234      0          5     20      0.0
os thread startup                          273      0          4     15      0.0
db file sequential read                     94      0          1      7      0.0
events in waitclass Other                   94     11          0      4      0.0
direct path read                            25      0          0      4      0.0
log file single write                       12      0          0      7      0.0
latch: cache buffers chains                  3      0          0      8      0.0
direct path write                           25      0          0      1      0.0
rdbms ipc message                      102,476     79    454,059   4431      8.4
pmon timer                               8,294    100     24,651   2972      0.7
Streams AQ: qmn slave idle wait            879      0     24,577  27960      0.1
Streams AQ: qmn coordinator idle         1,788     51     24,577  13745      0.1
smon timer                                 108     71     23,749 ######      0.0
Streams AQ: waiting for time mana            5    100      8,216 ######      0.0
          -------------------------------------------------------------
Wait Event Histogram  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

                           Total ----------------- % of Waits ------------------
Event                      Waits  <1ms  <2ms  <4ms  <8ms <16ms <32ms  <=1s   >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
LGWR wait for redo copy      54   79.6         1.9        18.5
Log archive I/O             302    2.3    .3          .7    .3  95.7    .7
PL/SQL lock timer             1                                      100.0
RMAN backup & recovery I/O   12K   1.4    .7   1.1   2.0  20.3  69.8   4.7
SQL*Net break/reset to cli   56  100.0
SQL*Net more data to clien  365K 100.0    .0    .0
buffer busy waits            90   95.6   1.1         2.2   1.1
control file parallel writ 8843         94.9   3.0    .8    .4    .3    .6
control file sequential re   84K  90.9   5.9   1.0   1.2    .7    .2    .2    .0
control file single write    20   25.0         5.0              70.0
cursor: mutex S               3  100.0
cursor: pin S wait on X       1                          100.0
db file parallel read         5   20.0  60.0              20.0
db file parallel write       11K  56.2  21.9  14.0   5.8   1.6    .3    .2
db file scattered read       15K    .6   9.7  11.9  43.3  19.1   6.8   8.7    .0
db file sequential read     109K  56.9   6.4   5.7  15.2  13.4   1.8    .6    .0
db file single write          5   80.0  20.0
direct path read             25   72.0               4.0  16.0   4.0   4.0
direct path read temp         6               50.0  50.0
direct path write            31   87.1   9.7               3.2
direct path write temp       33   54.5  12.1  18.2  15.2
enq: CF - contention         14   14.3   7.1  21.4         7.1  21.4  28.6
enq: JS - queue lock          4               25.0  50.0  25.0
enq: TC - contention          5         20.0        20.0  20.0        40.0
kksfbc child completion       1                                      100.0
latch free                    7   28.6                    71.4
latch: In memory undo latc   95   98.9         1.1
latch: cache buffers chain   12   91.7                           8.3
latch: cache buffers lru c    1  100.0
latch: enqueue hash chains    1  100.0
latch: library cache          7  100.0
latch: object queue header    2  100.0
latch: redo allocation        5  100.0
latch: session allocation     3  100.0
latch: shared pool           37   73.0  13.5   2.7   5.4   2.7         2.7
library cache load lock       1                                100.0
log file parallel write      19K  93.7   2.0   1.2   1.1    .5   1.1    .4
log file sequential read    326    7.1    .3    .6   1.2  27.9  47.9  15.0
log file single write        12   91.7                                 8.3
log file switch completion    6                                 33.3  66.7
log file sync                12K  94.2   2.5    .9    .8    .6    .5    .5
os thread startup           272     .4                    84.2  14.3   1.1
rdbms ipc reply              43   93.0   2.3   2.3         2.3
read by other session         2                          100.0
recovery area: computing a    1                          100.0
recovery area: computing b    1                          100.0
recovery area: computing d    1                          100.0
recovery area: computing o    1                                      100.0
switch logfile command        6                           16.7  33.3  50.0
undo segment extension        1  100.0
SQL*Net message from clien 1528K  93.9   3.9    .3    .3    .3    .1    .1   1.1
Wait Event Histogram  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

                           Total ----------------- % of Waits ------------------
Event                      Waits  <1ms  <2ms  <4ms  <8ms <16ms <32ms  <=1s   >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
SQL*Net message to client  1528K 100.0
SQL*Net more data from cli   24  100.0
Streams AQ: qmn coordinato 1788   49.2                                  .1  50.8
Streams AQ: qmn slave idle  879                                         .1  99.9
Streams AQ: waiting for ti    5               20.0                          80.0
class slave wait             12  100.0
jobq slave wait              13K    .0                .0    .1    .0   1.3  98.6
pmon timer                 8294     .8    .0          .0    .0          .0  99.1
rdbms ipc message           102K   2.7   2.7   1.7    .6   2.6   2.9  31.7  55.1
smon timer                  108    1.9                                  .9  97.2
          -------------------------------------------------------------

SQL ordered by CPU  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB CPU (s):             983
-> Captured SQL accounts for  102.3% of Total DB CPU
-> SQL reported below exceeded  1.0% of Total DB CPU

    CPU                  CPU per             Elapsd                     Old
  Time (s)   Executions  Exec (s)  %Total   Time (s)    Buffer Gets  Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
    131.65          137       0.96   13.4     229.78         521,114  333476733
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

    121.30            1     121.30   12.3     225.40       1,112,744 3490285666
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETERINFO".
* FROM "VCESERVICE"."PARAMETERINFO"

    103.44            1     103.44   10.5     151.52         821,856  125601442
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc (  )

     93.42            1      93.42    9.5     160.89         434,618  559837124
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETER".* FR
OM "VCESERVICE"."PARAMETER"

     46.09        2,437       0.02    4.7      51.38         926,044 1246544843
Module: ORACLE.EXE
SELECT "MODELNAME","TERMID" FROM "TERMIDTOUTID" "TERMIDTOUTID" W
HERE "TERMID"=:1

     33.51          137       0.24    3.4      34.54           3,455  486588686
INSERT INTO STATS$BG_EVENT_SUMMARY ( SNAP_ID , DBID , INSTANCE_N
UMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO
 ) SELECT :B3 , :B2 , :B1 , E.EVENT , SUM(E.TOTAL_WAITS) , SUM(E
.TOTAL_TIMEOUTS) , SUM(E.TIME_WAITED_MICRO) FROM V$SESSION_EVENT
 E WHERE E.SID IN (SELECT S.SID FROM V$SESSION S WHERE S.TYPE =

     29.35          137       0.21    3.0      41.24         109,102 3195300417
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
 , TEXT_SUBSET , SQL_ID , SHARABLE_MEM , SORTS , MODULE , LOADED
_VERSIONS , FETCHES , EXECUTIONS , PX_SERVERS_EXECUTIONS , END_O
F_FETCH_COUNT , LOADS , INVALIDATIONS , PARSE_CALLS , DISK_READS
 , DIRECT_WRITES , BUFFER_GETS , APPLICATION_WAIT_TIME , CONCURR

     26.83           14       1.92    2.7      27.31          52,492  821767095
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN keep_advisory_gathering; :mydate
:= next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;


     26.06           14       1.86    2.7      26.19          48,572 2962468285
SELECT O.OWNER OWNER, O.OBJECT_NAME OBJECT_NAME, O.SUBOBJECT_NAM
E SUBOBJECT_NAME, O.OBJECT_TYPE OBJECT_TYPE, COUNT(DISTINCT FILE
# || BLOCK#) NUM_BLOCKS FROM DBA_OBJECTS O, V$BH BH WHERE O.DATA
_OBJECT_ID = BH.OBJD AND O.OWNER NOT IN ('SYS','SYSTEM') AND LOW
ER(BH.STATUS) != 'free' GROUP BY O.OWNER, O.OBJECT_NAME, O.SUBOB
SQL ordered by CPU  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB CPU (s):             983
-> Captured SQL accounts for  102.3% of Total DB CPU
-> SQL reported below exceeded  1.0% of Total DB CPU

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

     20.80        2,437       0.01    2.1      25.87         147,249  417319142
Module: ORACLE.EXE
INSERT  INTO "RELATION" ("FAMNM","APPNM","TERMID","CLUSTERID","A
CCCNT","VIOLATIONCOUNT") SELECT "A2"."MMA_MODEL","A2"."MMA_APLIK
ACJA",:B3,:B2,2,0 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE "A2"."M
MA_MODEL"=:B1 AND  NOT EXISTS (SELECT 1 FROM "RELATION" "A3" WHE
RE "A3"."FAMNM"="A2"."MMA_MODEL" AND "A3"."APPNM"="A2"."MMA_APLI

     19.24        2,437       0.01    2.0      26.70          72,043 2689290720
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = 0 WHERE "A1"."TERMID"=:B1
AND  NOT EXISTS (SELECT 1 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE
 "A1"."FAMNM"="A2"."MMA_MODEL" AND "A1"."APPNM"="A2"."MMA_APLIKA
CJA")

     18.35           27       0.68    1.9      18.57         207,902 1854484190
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TI
ME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2
(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  j
ob_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH T
IME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME

     16.81            1      16.81    1.7     248.11         215,955 4023405807
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc (  )

     15.69          137       0.11    1.6      16.17           1,141  195971808
INSERT INTO STATS$SQL_STATISTICS ( SNAP_ID , DBID , INSTANCE_NUM
BER , TOTAL_SQL , TOTAL_SQL_MEM , SINGLE_USE_SQL , SINGLE_USE_SQ
L_MEM , TOTAL_CURSORS ) SELECT :B3 , :B2 , :B1 , COUNT(1) , SUM(
SHARABLE_MEM) , SUM(DECODE(EXECUTIONS, 1, 1, 0)) , SUM(DECODE(EX
ECUTIONS, 1, SHARABLE_MEM, 0)) , SUM(VERSION_COUNT) FROM STATS$V

     15.16          411       0.04    1.5      17.48          67,092 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;

     14.59       82,402       0.00    1.5      17.71         226,018 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2

     14.55          137       0.11    1.5      20.44          51,631 1969545765
INSERT INTO STATS$LATCH ( SNAP_ID , DBID , INSTANCE_NUMBER , NAM
E , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_GETS ,
SQL ordered by CPU  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB CPU (s):             983
-> Captured SQL accounts for  102.3% of Total DB CPU
-> SQL reported below exceeded  1.0% of Total DB CPU

    CPU                  CPU per             Elapsd                     Old
  Time (s)   Executions  Exec (s)  %Total   Time (s)    Buffer Gets  Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
IMMEDIATE_MISSES , SPIN_GETS , WAIT_TIME ) SELECT :B3 , :B2 , :B
1 , NAME , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_
GETS , IMMEDIATE_MISSES , SPIN_GETS , WAIT_TIME FROM V$LATCH

     12.55        2,437       0.01    1.3      13.80          91,674 1895818703
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = :B2 WHERE "A1"."TERMID"=:B
1

          -------------------------------------------------------------
SQL ordered by Elapsed  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB Time (s):           2,019
-> Captured SQL accounts for  102.9% of Total DB Time
-> SQL reported below exceeded  1.0% of Total DB Time

  Elapsed                Elap per            CPU                        Old
  Time (s)   Executions  Exec (s)  %Total   Time (s)  Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
    248.11            1     248.11   12.3      16.81          84,761 4023405807
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc (  )

    240.14           30       8.00   11.9      10.32          84,472 3778941046
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint,  spac
e_usage, space_alloc, quality from  table(dbms_space.object_grow
th_trend(:1, :2, :3, :4, NULL, NULL,  NULL, 'FALSE', :5, 'FALSE'
))

    229.78          137       1.68   11.4     131.65           6,141  333476733
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

    225.40            1     225.40   11.2     121.30         195,487 3490285666
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETERINFO".
* FROM "VCESERVICE"."PARAMETERINFO"

    160.89            1     160.89    8.0      93.42         111,551  559837124
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETER".* FR
OM "VCESERVICE"."PARAMETER"

    151.52            1     151.52    7.5     103.44          16,649  125601442
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc (  )

    122.82        2,437       0.05    6.1       5.33           9,431  891782014
Module: ORACLE.EXE
UPDATE "PARAMETER" "A1" SET "VALUE" = :B2 WHERE "A1"."PARNAMELOC
"='DLFULL' AND "A1"."PARTID"=:B1

     51.38        2,437       0.02    2.5      46.09               0 1246544843
Module: ORACLE.EXE
SELECT "MODELNAME","TERMID" FROM "TERMIDTOUTID" "TERMIDTOUTID" W
HERE "TERMID"=:1

     41.24          137       0.30    2.0      29.35           1,583 3195300417
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
 , TEXT_SUBSET , SQL_ID , SHARABLE_MEM , SORTS , MODULE , LOADED
_VERSIONS , FETCHES , EXECUTIONS , PX_SERVERS_EXECUTIONS , END_O
F_FETCH_COUNT , LOADS , INVALIDATIONS , PARSE_CALLS , DISK_READS
 , DIRECT_WRITES , BUFFER_GETS , APPLICATION_WAIT_TIME , CONCURR

     34.54          137       0.25    1.7      33.51              63  486588686
INSERT INTO STATS$BG_EVENT_SUMMARY ( SNAP_ID , DBID , INSTANCE_N
UMBER , EVENT , TOTAL_WAITS , TOTAL_TIMEOUTS , TIME_WAITED_MICRO
SQL ordered by Elapsed  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB Time (s):           2,019
-> Captured SQL accounts for  102.9% of Total DB Time
-> SQL reported below exceeded  1.0% of Total DB Time

  Elapsed                Elap per            CPU                        Old
  Time (s)   Executions  Exec (s)  %Total   Time (s)  Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
 ) SELECT :B3 , :B2 , :B1 , E.EVENT , SUM(E.TOTAL_WAITS) , SUM(E
.TOTAL_TIMEOUTS) , SUM(E.TIME_WAITED_MICRO) FROM V$SESSION_EVENT
 E WHERE E.SID IN (SELECT S.SID FROM V$SESSION S WHERE S.TYPE =

     28.83          137       0.21    1.4       3.98              50 3683286753
INSERT INTO STATS$FILE_HISTOGRAM ( SNAP_ID , DBID , INSTANCE_NUM
BER , FILE# , SINGLEBLKRDTIM_MILLI , SINGLEBLKRDS ) SELECT :B3 ,
 :B2 , :B1 , FILE# , SINGLEBLKRDTIM_MILLI , SINGLEBLKRDS FROM V$
FILE_HISTOGRAM WHERE SINGLEBLKRDS > 0

     27.31           14       1.95    1.4      26.83               7  821767095
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN keep_advisory_gathering; :mydate
:= next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;


     26.70        2,437       0.01    1.3      19.24               5 2689290720
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = 0 WHERE "A1"."TERMID"=:B1
AND  NOT EXISTS (SELECT 1 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE
 "A1"."FAMNM"="A2"."MMA_MODEL" AND "A1"."APPNM"="A2"."MMA_APLIKA
CJA")

     26.19           14       1.87    1.3      26.06               2 2962468285
SELECT O.OWNER OWNER, O.OBJECT_NAME OBJECT_NAME, O.SUBOBJECT_NAM
E SUBOBJECT_NAME, O.OBJECT_TYPE OBJECT_TYPE, COUNT(DISTINCT FILE
# || BLOCK#) NUM_BLOCKS FROM DBA_OBJECTS O, V$BH BH WHERE O.DATA
_OBJECT_ID = BH.OBJD AND O.OWNER NOT IN ('SYS','SYSTEM') AND LOW
ER(BH.STATUS) != 'free' GROUP BY O.OWNER, O.OBJECT_NAME, O.SUBOB

     25.87        2,437       0.01    1.3      20.80             234  417319142
Module: ORACLE.EXE
INSERT  INTO "RELATION" ("FAMNM","APPNM","TERMID","CLUSTERID","A
CCCNT","VIOLATIONCOUNT") SELECT "A2"."MMA_MODEL","A2"."MMA_APLIK
ACJA",:B3,:B2,2,0 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE "A2"."M
MA_MODEL"=:B1 AND  NOT EXISTS (SELECT 1 FROM "RELATION" "A3" WHE
RE "A3"."FAMNM"="A2"."MMA_MODEL" AND "A3"."APPNM"="A2"."MMA_APLI

     20.44          137       0.15    1.0      14.55             835 1969545765
INSERT INTO STATS$LATCH ( SNAP_ID , DBID , INSTANCE_NUMBER , NAM
E , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_GETS ,
IMMEDIATE_MISSES , SPIN_GETS , WAIT_TIME ) SELECT :B3 , :B2 , :B
1 , NAME , LATCH# , LEVEL# , GETS , MISSES , SLEEPS , IMMEDIATE_
GETS , IMMEDIATE_MISSES , SPIN_GETS , WAIT_TIME FROM V$LATCH

          -------------------------------------------------------------
SQL ordered by Gets  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> End Buffer Gets Threshold:     10000 Total Buffer Gets:       5,962,159
-> Captured SQL accounts for  118.6% of Total Buffer Gets
-> SQL reported below exceeded  1.0% of Total Buffer Gets

                                                     CPU      Elapsd     Old
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
      1,112,744            1    1,112,744.0   18.7   121.30    225.40 3490285666
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETERINFO".
* FROM "VCESERVICE"."PARAMETERINFO"

        926,044        2,437          380.0   15.5    46.09     51.38 1246544843
Module: ORACLE.EXE
SELECT "MODELNAME","TERMID" FROM "TERMIDTOUTID" "TERMIDTOUTID" W
HERE "TERMID"=:1

        821,856            1      821,856.0   13.8   103.44    151.52  125601442
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc (  )

        521,114          137        3,803.8    8.7   131.65    229.78  333476733
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

        434,618            1      434,618.0    7.3    93.42    160.89  559837124
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETER".* FR
OM "VCESERVICE"."PARAMETER"

        270,501        1,623          166.7    4.5     2.67      3.00 2749947875
Module: DBMS_SCHEDULER
SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATIO
N$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, O
BJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OB
J# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OI
D$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2

        226,018       82,402            2.7    3.8    14.59     17.71 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2

        215,955            1      215,955.0    3.6    16.81    248.11 4023405807
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc (  )

        207,902           27        7,700.1    3.5    18.35     18.57 1854484190
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TI
ME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2
(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  j
ob_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH T
IME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME

SQL ordered by Gets  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> End Buffer Gets Threshold:     10000 Total Buffer Gets:       5,962,159
-> Captured SQL accounts for  118.6% of Total Buffer Gets
-> SQL reported below exceeded  1.0% of Total Buffer Gets

                                                     CPU      Elapsd     Old
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
        158,961            1      158,961.0    2.7     2.58      8.64 2150591530
delete from sys.wri$_optstat_histgrm_history where savtime < :1

        147,249        2,437           60.4    2.5    20.80     25.87  417319142
Module: ORACLE.EXE
INSERT  INTO "RELATION" ("FAMNM","APPNM","TERMID","CLUSTERID","A
CCCNT","VIOLATIONCOUNT") SELECT "A2"."MMA_MODEL","A2"."MMA_APLIK
ACJA",:B3,:B2,2,0 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE "A2"."M
MA_MODEL"=:B1 AND  NOT EXISTS (SELECT 1 FROM "RELATION" "A3" WHE
RE "A3"."FAMNM"="A2"."MMA_MODEL" AND "A3"."APPNM"="A2"."MMA_APLI

        132,240           30        4,408.0    2.2    10.32    240.14 3778941046
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint,  spac
e_usage, space_alloc, quality from  table(dbms_space.object_grow
th_trend(:1, :2, :3, :4, NULL, NULL,  NULL, 'FALSE', :5, 'FALSE'
))

        109,102          137          796.4    1.8    29.35     41.24 3195300417
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
 , TEXT_SUBSET , SQL_ID , SHARABLE_MEM , SORTS , MODULE , LOADED
_VERSIONS , FETCHES , EXECUTIONS , PX_SERVERS_EXECUTIONS , END_O
F_FETCH_COUNT , LOADS , INVALIDATIONS , PARSE_CALLS , DISK_READS
 , DIRECT_WRITES , BUFFER_GETS , APPLICATION_WAIT_TIME , CONCURR

        109,054          119          916.4    1.8     0.76      0.76 2591807184
Module: exp.exe
SELECT SCHEMAOID      FROM   SYS.EXU9XMLST      WHERE  TOBJID =
:1

        106,507        2,536           42.0    1.8     9.07     10.93 3005103076
insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epva
lue) values(:1,:2,:3,:4,:5,:6,:7)

        103,707           27        3,841.0    1.7     9.74      9.87 1311155541
Module: DBMS_SCHEDULER
SELECT SYSDATE, MAX (T.EVDATE) MAX_, TRUNC(((SYSDATE - MAX (T.EV
DATE)) * 24 * 60),2) DIFF_ FROM VCESERVICE.TERMLOG T WHERE LOWER
 (T.PORTNM) LIKE 'com%' AND T.INIT = 'T'

        103,707           27        3,841.0    1.7     8.42      8.60 3956602999
Module: DBMS_SCHEDULER
SELECT SYSDATE, MAX (T.EVDATE) MAX_, TRUNC(((SYSDATE - MAX (T.EV
DATE)) * 24 * 60),2) DIFF_ FROM VCESERVICE.TERMLOG T WHERE LOWER
 (T.PORTNM) LIKE 'tcp%' AND T.INIT = 'T'

         91,674        2,437           37.6    1.5    12.55     13.80 1895818703
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = :B2 WHERE "A1"."TERMID"=:B
1
SQL ordered by Gets  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> End Buffer Gets Threshold:     10000 Total Buffer Gets:       5,962,159
-> Captured SQL accounts for  118.6% of Total Buffer Gets
-> SQL reported below exceeded  1.0% of Total Buffer Gets

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

         91,020          137          664.4    1.5     0.97      0.99 1629027619
INSERT INTO STATS$SQLTEXT ( OLD_HASH_VALUE , TEXT_SUBSET , PIECE
 , SQL_ID , SQL_TEXT , ADDRESS , COMMAND_TYPE , LAST_SNAP_ID ) S
ELECT /*+ ordered use_nl(vst) */ NEW_SQL.OLD_HASH_VALUE , NEW_SQ
L.TEXT_SUBSET , VST.PIECE , VST.SQL_ID , VST.SQL_TEXT , VST.ADDR
ESS , VST.COMMAND_TYPE , NEW_SQL.SNAP_ID FROM (SELECT HASH_VALUE

         80,575        1,182           68.2    1.4     8.15     11.00   25503030
delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3

         72,390          381          190.0    1.2     9.09     10.38 2514399594
Module: vtserver.exe
SELECT COUNT(UTID) FROM TERMINFO

         72,043        2,437           29.6    1.2    19.24     26.70 2689290720
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = 0 WHERE "A1"."TERMID"=:B1
AND  NOT EXISTS (SELECT 1 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE
 "A1"."FAMNM"="A2"."MMA_MODEL" AND "A1"."APPNM"="A2"."MMA_APLIKA
CJA")

         71,785            1       71,785.0    1.2    11.45     19.80 2300816316
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."TERMLOG_BACKUP_

          -------------------------------------------------------------
SQL ordered by Reads  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Disk Reads Threshold:      1000  Total Disk Reads:         467,257
-> Captured SQL accounts for  117.3% of Total Disk Reads
-> SQL reported below exceeded  1.0% of Total Disk Reads

                                                     CPU      Elapsd     Old
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
        195,487            1      195,487.0   41.8   121.30    225.40 3490285666
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETERINFO".
* FROM "VCESERVICE"."PARAMETERINFO"

        111,551            1      111,551.0   23.9    93.42    160.89  559837124
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."PARAMETER".* FR
OM "VCESERVICE"."PARAMETER"

         84,761            1       84,761.0   18.1    16.81    248.11 4023405807
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc (  )

         84,472           30        2,815.7   18.1    10.32    240.14 3778941046
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint,  spac
e_usage, space_alloc, quality from  table(dbms_space.object_grow
th_trend(:1, :2, :3, :4, NULL, NULL,  NULL, 'FALSE', :5, 'FALSE'
))

         22,084            1       22,084.0    4.7    11.45     19.80 2300816316
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."TERMLOG_BACKUP_
20080610".* FROM "VCESERVICE"."TERMLOG_BACKUP_20080610"

         16,649            1       16,649.0    3.6   103.44    151.52  125601442
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc (  )

          9,719            1        9,719.0    2.1     6.98     12.86 3689511813
Module: exp.exe
SELECT /*+NESTED_TABLE_GET_REFS+*/ "VCESERVICE"."DLDTABLE".* FRO
M "VCESERVICE"."DLDTABLE"

          9,431        2,437            3.9    2.0     5.33    122.82  891782014
Module: ORACLE.EXE
UPDATE "PARAMETER" "A1" SET "VALUE" = :B2 WHERE "A1"."PARNAMELOC
"='DLFULL' AND "A1"."PARTID"=:B1

          6,141          137           44.8    1.3   131.65    229.78  333476733
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_d
ate; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

          -------------------------------------------------------------
SQL ordered by Executions  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Executions Threshold:       100  Total Executions:         237,533
-> Captured SQL accounts for  124.7% of Total Executions
-> SQL reported below exceeded  1.0% of Total Executions

                                                CPU per    Elap per     Old
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
      82,402          60,874              0.7       0.00        0.00 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2

      26,825          26,825              1.0       0.00        0.00 3861983998
Module: ORACLE.EXE
SELECT UPDATE_LOG, INSERT_LOG, DELETE_LOG FROM AUDIT_CONTROL WHE
RE PROFILE_NAME = 'Terminal'

      17,137          17,137              1.0       0.00        0.00 2023129176
Module: TERMIN~1.EXE
INSERT INTO MLO_ACCESS_COUNTER_LOG VALUES (:B1 , SYSDATE, :B2 ,
:B3 , :B4 )

       9,864           9,864              1.0       0.00        0.00 1220089776
Module: TOAD 9.5.0.31
begin dbms_output.get_line(line => :line, status => :status); en
d;

       9,413          19,399              2.1       0.00        0.00 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0

       8,528           8,528              1.0       0.00        0.00 1307778841
select condition from cdef$ where rowid=:1

       4,930             699              0.1       0.00        0.00 1038353885
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n
ext_date) and (next_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, job

       4,834           4,828              1.0       0.00        0.00 1564451597
Module: ORACLE.EXE
SELECT "APPNM","TERMID" FROM "RELATION" "RELATION" WHERE ("APPNM
" LIKE 'PL%' OR "APPNM" LIKE 'C%' OR "APPNM" LIKE 'ESER%') AND "
TERMID"=:1

       4,366           4,366              1.0       0.00        0.00 1693927332
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400))

       4,200           4,200              1.0       0.00        0.00 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1

       3,712           3,712              1.0       0.00        0.00 3024244421
INSERT INTO CANDIDATES_FOR_KEEP VALUES (:B1 ,:B2 ,:B3 ,:B4 ,:B5
SQL ordered by Executions  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Executions Threshold:       100  Total Executions:         237,533
-> Captured SQL accounts for  124.7% of Total Executions
-> SQL reported below exceeded  1.0% of Total Executions

                                                CPU per    Elap per     Old
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
)

       3,427          53,028             15.5       0.00        0.00  199663413
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$
 where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

       3,233           3,233              1.0       0.00        0.00 1443852909
Module: DBMS_SCHEDULER
SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_row
s(1) leading(cc) */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SY
S.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON#
= CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND C
D.INTCOLS = 1 AND CD.TYPE# IN (2,3) AND BITAND(CD.DEFER, 2+4) =

       2,536          20,547              8.1       0.00        0.00 3005103076
insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epva
lue) values(:1,:2,:3,:4,:5,:6,:7)

       2,437           2,370              1.0       0.01        0.01  417319142
Module: ORACLE.EXE
INSERT  INTO "RELATION" ("FAMNM","APPNM","TERMID","CLUSTERID","A
CCCNT","VIOLATIONCOUNT") SELECT "A2"."MMA_MODEL","A2"."MMA_APLIK
ACJA",:B3,:B2,2,0 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE "A2"."M
MA_MODEL"=:B1 AND  NOT EXISTS (SELECT 1 FROM "RELATION" "A3" WHE
RE "A3"."FAMNM"="A2"."MMA_MODEL" AND "A3"."APPNM"="A2"."MMA_APLI

       2,437           2,073              0.9       0.00        0.05  891782014
Module: ORACLE.EXE
UPDATE "PARAMETER" "A1" SET "VALUE" = :B2 WHERE "A1"."PARNAMELOC
"='DLFULL' AND "A1"."PARTID"=:B1

       2,437           2,437              1.0       0.00        0.00 1011911089
Module: ORACLE.EXE
SELECT COUNT(*) FROM "RELATION" "A1" WHERE "A1"."TERMID"=:B1 AND
 ROWNUM<2

       2,437           2,437              1.0       0.02        0.02 1246544843
Module: ORACLE.EXE
SELECT "MODELNAME","TERMID" FROM "TERMIDTOUTID" "TERMIDTOUTID" W
HERE "TERMID"=:1

       2,437           9,765              4.0       0.01        0.01 1895818703
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = :B2 WHERE "A1"."TERMID"=:B
1

       2,437           7,328              3.0       0.01        0.01 2689290720
Module: ORACLE.EXE
UPDATE "RELATION" "A1" SET "ACCCNT" = 0 WHERE "A1"."TERMID"=:B1
AND  NOT EXISTS (SELECT 1 FROM "TT_MGR_MODEL_APPNM"@! "A2" WHERE
 "A1"."FAMNM"="A2"."MMA_MODEL" AND "A1"."APPNM"="A2"."MMA_APLIKA
CJA")
SQL ordered by Executions  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Executions Threshold:       100  Total Executions:         237,533
-> Captured SQL accounts for  124.7% of Total Executions
-> SQL reported below exceeded  1.0% of Total Executions

                                                CPU per    Elap per     Old
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------

       2,402               0              0.0       0.00        0.00 3508161114
select cachedblk, cachehit, logicalread from tab_stats$ where ob
j#=:1

          -------------------------------------------------------------
SQL ordered by Parse Calls  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Parse Calls Threshold:      1000 Total Parse Calls:         100,959
-> Captured SQL accounts for   89.0% of Total Parse Calls
-> SQL reported below exceeded  1.0% of Total Parse Calls

                           % Total    Old
 Parse Calls  Executions   Parses  Hash Value
------------ ------------ -------- ----------
       9,864        9,864     9.77 1220089776
Module: TOAD 9.5.0.31
begin dbms_output.get_line(line => :line, status => :status); en
d;

       9,413        9,413     9.32 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0

       8,528        8,528     8.45 1307778841
select condition from cdef$ where rowid=:1

       4,442       82,402     4.40 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2

       4,200        4,200     4.16 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1

       2,437        2,437     2.41 1246544843
Module: ORACLE.EXE
SELECT "MODELNAME","TERMID" FROM "TERMIDTOUTID" "TERMIDTOUTID" W
HERE "TERMID"=:1

       1,805        1,805     1.79    2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn

       1,805        1,805     1.79 2396279102
lock table sys.mon_mods$ in exclusive mode nowait

       1,530        1,530     1.52 1348827743
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
VL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2
 and block#=:3

          -------------------------------------------------------------
SQL ordered by Sharable Memory  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> End Sharable Memory Threshold:   1048576

Sharable Mem (b)  Executions  % Total Old Hash Value
---------------- ------------ ------- --------------
       1,267,726            1     0.4   2458736366
Module: DBMS_SCHEDULER
MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */
 INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYP
E#, CASE WHEN STALENESS > .5 THEN 128 ELSE 0 END + AFLAGS AFLAGS
, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand d
ynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.F

          -------------------------------------------------------------
Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session                      88,838            3.6          7.3
CPU used when call started                    54,039            2.2          4.4
CR blocks created                              1,642            0.1          0.1
Cached Commit SCN referenced                   2,205            0.1          0.2
Commit SCN cached                                 34            0.0          0.0
DB time                                    4,240,895          172.0        346.9
DBWR checkpoint buffers written               71,707            2.9          5.9
DBWR checkpoints                                  11            0.0          0.0
DBWR object drop buffers written                   0            0.0          0.0
DBWR revisited being-written buff                227            0.0          0.0
DBWR tablespace checkpoint buffer                365            0.0          0.0
DBWR thread checkpoint buffers wr             71,342            2.9          5.8
DBWR transaction table writes                  1,742            0.1          0.1
DBWR undo block writes                        20,218            0.8          1.7
IMU CR rollbacks                                   0            0.0          0.0
IMU Flushes                                      422            0.0          0.0
IMU Redo allocation size                   2,350,392           95.3        192.3
IMU commits                                    3,578            0.2          0.3
IMU contention                                   120            0.0          0.0
IMU ktichg flush                                   2            0.0          0.0
IMU pool not allocated                           939            0.0          0.1
IMU recursive-transaction flush                    5            0.0          0.0
IMU undo allocation size                   8,252,916          334.7        675.1
IMU- failed to get a private stra                939            0.0          0.1
Misses for writing mapping                         0            0.0          0.0
SMON posted for undo segment reco                  0            0.0          0.0
SMON posted for undo segment shri                 10            0.0          0.0
SQL*Net roundtrips to/from client          1,528,658           62.0        125.1
active txn count during cleanout              12,332            0.5          1.0
application wait time                              1            0.0          0.0
auto extends on undo tablespace                    0            0.0          0.0
background checkpoints completed                   6            0.0          0.0
background checkpoints started                     6            0.0          0.0
background timeouts                           80,220            3.3          6.6
branch node splits                                22            0.0          0.0
buffer is not pinned count                 1,092,017           44.3         89.3
buffer is pinned count                     2,292,932           93.0        187.6
bytes received via SQL*Net from c         33,887,958        1,374.2      2,772.3
bytes sent via SQL*Net to client       2,144,552,016       86,964.8    175,437.8
calls to get snapshot scn: kcmgss            371,966           15.1         30.4
calls to kcmgas                              121,980            5.0         10.0
calls to kcmgcs                                5,779            0.2          0.5
change write time                              2,779            0.1          0.2
cleanout - number of ktugct calls             23,059            0.9          1.9
cleanouts and rollbacks - consist                 20            0.0          0.0
cleanouts only - consistent read              10,531            0.4          0.9
cluster key scan block gets                  130,604            5.3         10.7
cluster key scans                             39,974            1.6          3.3
commit batch performed                             0            0.0          0.0
commit batch requested                             0            0.0          0.0
commit batch/immediate performed                  22            0.0          0.0
commit batch/immediate requested                  22            0.0          0.0
commit cleanout failures: block l                 89            0.0          0.0
commit cleanout failures: buffer                  47            0.0          0.0
commit cleanout failures: callbac              4,437            0.2          0.4
commit cleanout failures: cannot                  87            0.0          0.0
Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
commit cleanouts                              86,203            3.5          7.1
commit cleanouts successfully com             81,543            3.3          6.7
commit immediate performed                        22            0.0          0.0
commit immediate requested                        22            0.0          0.0
commit txn count during cleanout              22,906            0.9          1.9
concurrency wait time                            421            0.0          0.0
consistent changes                            14,318            0.6          1.2
consistent gets                            4,901,053          198.8        400.9
consistent gets - examination                793,277           32.2         64.9
consistent gets direct                             2            0.0          0.0
consistent gets from cache                 4,901,051          198.7        400.9
current blocks converted for CR                    0            0.0          0.0
cursor authentications                         1,448            0.1          0.1
data blocks consistent reads - un              2,218            0.1          0.2
db block changes                             938,308           38.1         76.8
db block gets                              1,061,111           43.0         86.8
db block gets direct                             503            0.0          0.0
db block gets from cache                   1,060,608           43.0         86.8
deferred (CURRENT) block cleanout             41,309            1.7          3.4
dirty buffers inspected                          644            0.0          0.1
enqueue conversions                           73,175            3.0          6.0
enqueue deadlocks                                  0            0.0          0.0
enqueue releases                             332,870           13.5         27.2
enqueue requests                             332,883           13.5         27.2
enqueue timeouts                                   6            0.0          0.0
enqueue waits                                     23            0.0          0.0
exchange deadlocks                                 0            0.0          0.0
execute count                                237,533            9.6         19.4
failed probes on index block recl                  0            0.0          0.0
free buffer inspected                        466,983           18.9         38.2
free buffer requested                        491,333           19.9         40.2
global undo segment hints helped                   0            0.0          0.0
heap block compress                           18,144            0.7          1.5
hot buffers moved to head of LRU              52,482            2.1          4.3
immediate (CR) block cleanout app             10,551            0.4          0.9
immediate (CURRENT) block cleanou             16,772            0.7          1.4
index crx upgrade (found)                          0            0.0          0.0
index crx upgrade (positioned)                17,282            0.7          1.4
index fast full scans (full)                   1,055            0.0          0.1
index fetch by key                           416,479           16.9         34.1
index scans kdiixs1                          140,431            5.7         11.5
leaf node 90-10 splits                           263            0.0          0.0
leaf node splits                               4,511            0.2          0.4
lob reads                                      4,483            0.2          0.4
lob writes                                       862            0.0          0.1
lob writes unaligned                             862            0.0          0.1
logons cumulative                              1,115            0.1          0.1
messages received                             32,671            1.3          2.7
messages sent                                 32,671            1.3          2.7
no buffer to keep pinned count                     0            0.0          0.0
no work - consistent read gets             3,957,090          160.5        323.7
opened cursors cumulative                    123,054            5.0         10.1
parse count (failures)                            24            0.0          0.0
parse count (hard)                             6,841            0.3          0.6
parse count (total)                          100,959            4.1          8.3
parse time cpu                                 5,363            0.2          0.4
Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
parse time elapsed                             5,651            0.2          0.5
physical read IO requests                    125,474            5.1         10.3
physical read bytes                    3,827,769,344      155,221.8    313,135.6
physical read total IO requests              238,176            9.7         19.5
physical read total bytes             34,140,120,576    1,384,433.1  2,792,876.4
physical read total multi block r             43,268            1.8          3.5
physical reads                               467,257           19.0         38.2
physical reads cache                         467,044           18.9         38.2
physical reads cache prefetch                341,611           13.9         28.0
physical reads direct                            213            0.0          0.0
physical reads direct temporary t                186            0.0          0.0
physical reads prefetch warmup                     0            0.0          0.0
physical write IO requests                    52,377            2.1          4.3
physical write bytes                     598,671,360       24,277.0     48,975.1
physical write total IO requests             101,185            4.1          8.3
physical write total bytes             4,419,725,824      179,226.5    361,561.3
physical write total multi block              22,636            0.9          1.9
physical writes                               73,080            3.0          6.0
physical writes direct                           714            0.0          0.1
physical writes direct (lob)                       5            0.0          0.0
physical writes direct temporary                 677            0.0          0.1
physical writes from cache                    72,366            2.9          5.9
physical writes non checkpoint                23,519            1.0          1.9
pinned buffers inspected                          77            0.0          0.0
prefetch warmup blocks aged out b                  0            0.0          0.0
prefetched blocks aged out before                 30            0.0          0.0
process last non-idle time                    24,660            1.0          2.0
recursive calls                            1,265,849           51.3        103.6
recursive cpu usage                           43,235            1.8          3.5
redo blocks written                          532,532           21.6         43.6
redo buffer allocation retries                    53            0.0          0.0
redo entries                                 481,274           19.5         39.4
redo log space requests                           53            0.0          0.0
redo log space wait time                          29            0.0          0.0
redo ordering marks                                4            0.0          0.0
redo size                                257,788,944       10,453.7     21,088.8
redo synch time                                1,498            0.1          0.1
redo synch writes                             12,313            0.5          1.0
redo wastage                               5,795,928          235.0        474.1
redo write time                                2,499            0.1          0.2
redo writer latching time                         11            0.0          0.0
redo writes                                   19,182            0.8          1.6
rollback changes - undo records a                  9            0.0          0.0
rollbacks only - consistent read               1,610            0.1          0.1
rows fetched via callback                    171,878            7.0         14.1
session connect time                               0            0.0          0.0
session cursor cache hits                     97,660            4.0          8.0
session logical reads                      5,962,159          241.8        487.7
session pga memory                     1,132,311,424       45,916.9     92,630.2
session pga memory max                 8,364,667,776      339,199.8    684,282.4
session uga memory                 3,551,968,555,440  144,037,654.3 ############
session uga memory max                 1,197,120,964       48,545.1     97,932.0
shared hash latch upgrades - no w             19,060            0.8          1.6
shared hash latch upgrades - wait                  0            0.0          0.0
sorts (disk)                                       0            0.0          0.0
sorts (memory)                                61,639            2.5          5.0
Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
sorts (rows)                              16,674,933          676.2      1,364.1
sql area evicted                               7,388            0.3          0.6
sql area purged                                   79            0.0          0.0
summed dirty queue length                      3,818            0.2          0.3
switch current to new buffer                  11,600            0.5          1.0
table fetch by rowid                       1,178,624           47.8         96.4
table fetch continued row                      1,272            0.1          0.1
table scan blocks gotten                   3,134,104          127.1        256.4
table scan rows gotten                   348,384,310       14,127.5     28,500.0
table scans (long tables)                          9            0.0          0.0
table scans (short tables)                    19,436            0.8          1.6
total number of times SMON posted                 31            0.0          0.0
transaction rollbacks                             22            0.0          0.0
transaction tables consistent rea                 10            0.0          0.0
transaction tables consistent rea                 66            0.0          0.0
undo change vector size                   95,574,052        3,875.7      7,818.6
user I/O wait time                            70,844            2.9          5.8
user calls                                 1,525,290           61.9        124.8
user commits                                  12,224            0.5          1.0
user rollbacks                                     0            0.0          0.0
workarea executions - multipass                    0            0.0          0.0
workarea executions - onepass                      2            0.0          0.0
workarea executions - optimal                 32,736            1.3          2.7
write clones created in backgroun                 14            0.0          0.0
write clones created in foregroun                298            0.0          0.0
          -------------------------------------------------------------

Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Statistics with absolute values (should not be diffed)

Statistic                             Begin Value       End Value
--------------------------------- --------------- ---------------
logons current                                 66              68
opened cursors current                        445             992
session cursor cache count              1,522,361       1,535,651
workarea memory allocated                  16,741          16,741
          -------------------------------------------------------------

Instance Activity Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                      Total  per Hour
--------------------------------- ------------------ ---------
log switches (derived)                             6       .88
          -------------------------------------------------------------

OS Statistics  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name

Statistic                                  Total
------------------------- ----------------------
BUSY_TIME                                503,720
IDLE_TIME                              4,428,191
SYS_TIME                                 100,030
USER_TIME                                403,690
VM_IN_BYTES                        5,214,662,656
VM_OUT_BYTES                           4,157,440
PHYSICAL_MEMORY_BYTES              2,146,910,208
NUM_CPUS                                       2
NUM_CPU_CORES                                  2
          -------------------------------------------------------------
Tablespace IO Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
USERS
        65,072       3  141.6     1.0       26,878        1          0    0.0
VCESERVICE
        51,905       2  161.1     7.4        9,616        0          0    0.0
SYSAUX
         5,928       0   50.9     2.2        6,608        0          0    0.0
UNDOTBS1
             5       0 ######     1.0        6,260        0          9    0.0
SYSTEM
         2,535       0  166.7     1.9        2,975        0         83    0.6
TEMPVCESERVICE
            31       0    3.5    21.9           40        0          0    0.0
          -------------------------------------------------------------
File IO Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                        Av   Mx                                             Av
                 Av     Rd   Rd    Av                    Av        Buffer BufWt
         Reads Reads/s (ms)  Bkt Blks/Rd       Writes Writes/s      Waits  (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
SYSAUX                   F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\SYSAUX01.
         5,928       0  50.9 ###     2.2        6,608        0          0

SYSTEM                   F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\SYSTEM01.
         2,535       0 ##### ###     1.9        2,975        0         83    0.6

TEMPVCESERVICE           F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\VCTMP_VCE
            31       0   3.5  16    21.9           40        0          0

UNDOTBS1                 F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\UNDOTBS01
             5       0 #####         1.0        6,260        0          9    0.0

USERS                    F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\USERS01.D
        65,072       3 ##### ###     1.0       26,878        1          0

VCESERVICE               F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\VC_VCESER
        51,905       2 ##### ###     7.4        9,616        0          0

          -------------------------------------------------------------
File Read Histogram Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->Number of single block reads in each time range
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
    0 - 2 ms     2 - 4 ms    4 - 8 ms     8 - 16 ms   16 - 32 ms       32+ ms
------------ ------------ ------------ ------------ ------------ ------------
VCESERVICE               F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\VC_VCESER
      23,599        2,240        5,912        5,072          797          300

USERS                    F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\USERS01.D
      42,825        3,704        9,581        7,970          655          209

SYSTEM                   F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\SYSTEM01.
       1,062          122          413          536           94           31

SYSAUX                   F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\SYSAUX01.
       2,062          141          798        1,110          419          106

TEMPVCESERVICE           F:\ORACLE\PRODUCT\10.2.0.4\ORADATA\VCENTRE\VCTMP_VCE
           4            0            1            1            0            0

          -------------------------------------------------------------
Buffer Pool Statistics  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
-> Buffers: the number of buffers.  Units of K, M, G are divided by 1000

                                                            Free Writ     Buffer
            Pool         Buffer     Physical    Physical  Buffer Comp       Busy
P   Buffers Hit%           Gets        Reads      Writes   Waits Wait      Waits
--- ------- ---- -------------- ------------ ----------- ------- ---- ----------
D       87K   92      5,965,267      467,045      72,366       0    0         92
          -------------------------------------------------------------

Instance Recovery Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> 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     0        313      1678      2000     294840      2790         2000
E     0     0        353      1664      2000     294840      2534         2000
          -------------------------------------------------------------

Buffer Pool Advisory  DB/Inst: VCENTRE/vcentre  End Snap: 53995
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Pool, Block Size, Buffers For Estimate

                                   Est
                                  Phys      Estimated                   Est
    Size for  Size      Buffers   Read     Phys Reads     Est Phys % dbtime
P    Est (M) Factr  (thousands)  Factr    (thousands)    Read Time  for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
D         64    .1            8    3.6         84,381      354,680     99.2
D        128    .2           16    1.4         32,322       75,656     21.2
D        192    .3           24    1.2         27,792       51,376     14.4
D        256    .4           32    1.1         26,394       43,886     12.3
D        320    .5           40    1.1         25,718       40,262     11.3
D        384    .5           48    1.1         25,232       37,655     10.5
D        448    .6           56    1.0         24,599       34,264      9.6
D        512    .7           64    1.0         24,255       32,420      9.1
D        576    .8           72    1.0         24,034       31,236      8.7
D        640    .9           80    1.0         23,819       30,084      8.4
D        704   1.0           88    1.0         23,611       28,969      8.1
D        768   1.1           96    1.0         23,443       28,067      7.8
D        832   1.2          104    1.0         23,207       26,802      7.5
D        896   1.3          112    1.0         23,062       26,027      7.3
D        960   1.4          120    1.0         22,889       25,097      7.0
D      1,024   1.5          128    1.0         22,753       24,371      6.8
D      1,088   1.5          136    1.0         22,631       23,715      6.6
D      1,152   1.6          144    1.0         22,500       23,016      6.4
D      1,216   1.7          152    0.9         22,349       22,207      6.2
D      1,280   1.8          160    0.9         22,059       20,651      5.8
          -------------------------------------------------------------

Buffer wait Statistics  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by wait time desc, waits desc

Class                        Waits Total Wait Time (s) Avg Time (ms)
---------------------- ----------- ------------------- -------------
data block                      83                   0             1
undo header                      9                   0             0
          -------------------------------------------------------------
PGA Aggr Target Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> B: Begin snap   E: End snap (rows identified with B or E contain data
   which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> 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 Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
           99.8            2,923                         6

                                             %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       150        69      161.1       16.3   10.1  100.0     .0     30,720
E       150        68      165.4       16.8   10.1  100.0     .0     30,720
          -------------------------------------------------------------

PGA Aggr Target Histogram  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Optimal Executions are purely in-memory operations

    Low    High
Optimal Optimal    Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
     2K      4K         28,641        28,641            0            0
    64K    128K            465           465            0            0
   128K    256K             77            77            0            0
   256K    512K            301           301            0            0
   512K   1024K          3,142         3,142            0            0
     1M      2M              9             9            0            0
     2M      4M             80            78            2            0
     4M      8M             21            21            0            0
     8M     16M              2             2            0            0
          -------------------------------------------------------------

PGA Memory Advisory  DB/Inst: VCENTRE/vcentre  End Snap: 53995
-> 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
---------- ------- ---------------- ---------------- -------- ----------
        19     0.1        543,825.7         86,022.5     86.0      9,399
        38     0.3        543,825.7         86,014.3     86.0      9,399
        75     0.5        543,825.7         65,976.4     89.0      6,294
       113     0.8        543,825.7          7,141.7     99.0        430
       150     1.0        543,825.7          1,265.3    100.0          7
       180     1.2        543,825.7             37.1    100.0          0
       210     1.4        543,825.7              0.0    100.0          0
       240     1.6        543,825.7              0.0    100.0          0
       270     1.8        543,825.7              0.0    100.0          0
       300     2.0        543,825.7              0.0    100.0          0
       450     3.0        543,825.7              0.0    100.0          0
       600     4.0        543,825.7              0.0    100.0          0
       900     6.0        543,825.7              0.0    100.0          0
     1,200     8.0        543,825.7              0.0    100.0          0
          -------------------------------------------------------------
Process Memory Summary Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> B: Begin snap   E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
   Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> Num Procs or Allocs:  For Begin/End snapshot lines, it is the number of
   processes. For Category lines, it is the number of allocations
-> ordered by Begin/End snapshot, Alloc (MB) desc

                                                                  Hist   Num
                                          Avg    Std Dev   Max    Max   Procs
             Alloc     Used    Freeabl   Alloc    Alloc   Alloc  Alloc    or
  Category   (MB)      (MB)      (MB)     (MB)    (MB)    (MB)    (MB)  Allocs
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B --------     161.5      89.5       .0      2.4     3.6      17     17     66
  Other        142.1                         2.2     3.1       9     10     66
  SQL           18.3      17.0                .4     2.4      16     16     44
  PL/SQL         1.0        .5                .0      .0       0      1     66
E --------     165.8      92.6       .0      2.4     3.6      17     17     68
  Other        144.9                         2.1     3.1       9     10     68
  SQL           19.9      17.9                .4     2.3      16     16     46
  PL/SQL         1.0        .5                .0      .0       0      1     68
          -------------------------------------------------------------

Top Process Memory (by component)  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B    122 SHAD --------    17.1    17.1       .0       17.1       17.1
         SQL              16.4    16.4                16.4       16.4
         Other              .7                          .7         .7
         PL/SQL             .0      .0                  .0         .0
      14 ARC0 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      15 ARC1 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      16 ARC2 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      17 ARC3 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      18 ARC4 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      19 ARC5 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      20 ARC6 --------     9.1     4.3       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      21 ARC7 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      22 ARC8 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      23 ARC9 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
       6 LGWR --------     9.1     4.2       .0        9.1        9.8
         Other             9.1                         9.1        9.8
         PL/SQL             .0      .0                  .0         .0
      25 J001 --------     2.4     1.8       .0        2.4        3.1
         Other             2.3                         2.3        2.3
         SQL                .1      .0                  .1        1.3
         PL/SQL             .0      .0                  .0         .0
      69 SHAD --------     2.1     1.2       .0        2.1        9.5
         Other             1.9                         1.9        1.9
         PL/SQL             .2      .0                  .2         .5
         SQL                .0      .0                  .0        7.7
      31 SHAD --------     1.5      .5       .0        1.5        2.1
         Other             1.5                         1.5        1.5
         PL/SQL             .0      .0                  .0         .7
         SQL                .0      .0                  .0         .5
      11 MMON --------     1.5     1.1       .0        1.5        2.7
         Other             1.4                         1.4        1.7
         SQL                .0      .0                  .0         .9
         PL/SQL             .0      .0                  .0         .0

Top Process Memory (by component)  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B      7 CKPT --------     1.5      .2       .0        1.5        1.5
         Other             1.5                         1.5        1.5
         PL/SQL             .0      .0                  .0         .0
     110 SHAD --------     1.4      .5       .0        1.4        2.3
         Other             1.4                         1.4        1.4
         SQL                .1      .0                  .1        1.3
         PL/SQL             .0      .0                  .0         .0
      37 SHAD --------     1.2      .5       .0        1.2        1.8
         Other             1.1                         1.1        1.1
         SQL                .1      .0                  .1         .6
         PL/SQL             .0      .0                  .0         .0
     141 SHAD --------     1.2     1.0       .0        1.2        2.0
         Other             1.1                         1.1        1.1
         SQL                .0      .0                  .0         .4
         PL/SQL             .0      .0                  .0         .9
E    122 SHAD --------    17.1    17.1       .0       17.1       17.1
         SQL              16.4    16.4                16.4       16.4
         Other              .7                          .7         .7
         PL/SQL             .0      .0                  .0         .0
      14 ARC0 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      15 ARC1 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      16 ARC2 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      17 ARC3 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      18 ARC4 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      19 ARC5 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      20 ARC6 --------     9.1     4.3       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      21 ARC7 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      22 ARC8 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
      23 ARC9 --------     9.1     4.2       .0        9.1        9.1
         Other             9.1                         9.1        9.1
         PL/SQL             .0      .0                  .0         .0
       6 LGWR --------     9.1     4.2       .0        9.1        9.8
         Other             9.1                         9.1        9.8
         PL/SQL             .0      .0                  .0         .0
      32 J001 --------     2.3     1.8       .0        2.3        3.0

Top Process Memory (by component)  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E     32 Other             2.2                         2.2        2.2
         SQL                .1      .0                  .1        1.3
         PL/SQL             .0      .0                  .0         .0
      69 SHAD --------     2.1     1.2       .0        2.1        9.5
         Other             1.9                         1.9        1.9
         PL/SQL             .2      .0                  .2         .5
         SQL                .0      .0                  .0        7.7
      51 SHAD --------     1.8      .9       .0        1.8        2.7
         Other             1.4                         1.4        1.4
         SQL                .4      .1                  .4        1.4
         PL/SQL             .0      .0                  .0         .0
      41 m000 --------     1.6      .9       .0        1.6        2.3
         Other             1.1                         1.1        1.2
         SQL                .5      .5                  .5        1.2
         PL/SQL             .0      .0                  .0         .0
      31 SHAD --------     1.5      .5       .0        1.5        2.1
         Other             1.5                         1.5        1.5
         PL/SQL             .0      .0                  .0         .7
         SQL                .0      .0                  .0         .5
      11 MMON --------     1.5     1.1       .0        1.5        2.7
         Other             1.4                         1.4        1.7
         SQL                .0      .0                  .0         .9
         PL/SQL             .0      .0                  .0         .0
       7 CKPT --------     1.5      .2       .0        1.5        1.5
         Other             1.5                         1.5        1.5
         PL/SQL             .0      .0                  .0         .0
     110 SHAD --------     1.4      .5       .0        1.4        2.3
         Other             1.4                         1.4        1.4
         SQL                .1      .0                  .1        1.3
         PL/SQL             .0      .0                  .0         .0
          -------------------------------------------------------------
Enqueue activity  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)
------------------------------------------------------------------------------
    Requests    Succ Gets Failed Gets       Waits Wt Time (s)  Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
CF-Controlfile Transaction
      14,611       14,611           0          14            0          19.07
TC-Tablespace Checkpoint
          15           15           0           5            0          28.20
JS-Job Scheduler (queue lock)
      77,381       77,381           0           4            0           7.50
          -------------------------------------------------------------

Undo Segment Summary  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count,  OOS - Out Of Space count
-> Undo segment block stats:
   uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
   eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo   Num Undo       Number of  Max Qry     Max Tx Min/Max   STO/  uS/uR/uU/
 TS# Blocks (K)    Transactions  Len (s)      Concy TR (mins) OOS   eS/eR/eU
---- ---------- --------------- -------- ---------- --------- ----- -----------
   1       17.9          23,725      902          6 15/29.1   0/0   0/0/0/0/0/0
          -------------------------------------------------------------


Undo Segment Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Most recent 35 Undostat rows, ordered by End Time desc

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/  uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS   eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- -----------
02-Sep 06:08         296          361       0       3      15 0/0   0/0/0/0/0/0
02-Sep 05:58         245          233       0       3      15 0/0   0/0/0/0/0/0
02-Sep 05:48         374          477       0       3      15 0/0   0/0/0/0/0/0
02-Sep 05:38         306          439       0       2      15 0/0   0/0/0/0/0/0
02-Sep 05:28         307          474       0       2      15 0/0   0/0/0/0/0/0
02-Sep 05:18         308          392       0       2      15 0/0   0/0/0/0/0/0
02-Sep 05:09         422          594       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:58         309          397       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:48         304          436       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:39         380          497       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:28         308          394       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:18         431          710       0       3      15 0/0   0/0/0/0/0/0
02-Sep 04:08         359          455       0       3      15 0/0   0/0/0/0/0/0
02-Sep 03:58         335          499       0       2      15 0/0   0/0/0/0/0/0
02-Sep 03:48         298          365       0       3      15 0/0   0/0/0/0/0/0
02-Sep 03:39         389          472       0       3      15 0/0   0/0/0/0/0/0
02-Sep 03:28         331          393       0       3      15 0/0   0/0/0/0/0/0
02-Sep 03:18         377          763       0       3      15 0/0   0/0/0/0/0/0
02-Sep 03:09       3,677        2,557       0       6      15 0/0   0/0/0/0/0/0
02-Sep 02:58         324          536       0       2      15 0/0   0/0/0/0/0/0
02-Sep 02:48         395          481       0       3      15 0/0   0/0/0/0/0/0
02-Sep 02:38         330          528       0       3      15 0/0   0/0/0/0/0/0
02-Sep 02:28         328          490       0       3      15 0/0   0/0/0/0/0/0
02-Sep 02:18         322          590       0       3      15 0/0   0/0/0/0/0/0
02-Sep 02:09         484          683       0       3      15 0/0   0/0/0/0/0/0
02-Sep 01:58         392          751       0       3      15 0/0   0/0/0/0/0/0
02-Sep 01:48         409          755       0       3      15 0/0   0/0/0/0/0/0
02-Sep 01:39         452          761       0       3      15 0/0   0/0/0/0/0/0
02-Sep 01:28         399          719       0       4      15 0/0   0/0/0/0/0/0
02-Sep 01:18         424          938       0       3      15 0/0   0/0/0/0/0/0
02-Sep 01:09         537          956       0       3      15 0/0   0/0/0/0/0/0
02-Sep 00:58         415          714       0       2      15 0/0   0/0/0/0/0/0
02-Sep 00:48         270          382     902       3      29 0/0   0/0/0/0/0/0
02-Sep 00:39         322          266     300       3      18 0/0   0/0/0/0/0/0
          -------------------------------------------------------------
Latch Activity  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->"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                       Requests      Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch              16,478    0.0             0            0
AWR Alerted Metric Eleme        110,568    0.0             0            0
Consistent RBA                   19,190    0.0             0            0
FAL request queue                 1,161    0.0             0            0
FAL subheap alocation             1,161    0.0             0            0
FIB s.o chain latch                 316    0.0             0            0
FOB s.o list latch                1,218    0.0             0            0
In memory undo latch             37,457    0.3    1.0      0       10,539    0.1
JS Sh mem access                    102    0.0             0            0
JS mem alloc latch                  352    0.0             0            0
JS queue access latch               352    0.0             0            0
JS queue state obj latch        154,762    0.0             0            0
JS slv state obj latch            3,381    0.0             0            0
KMG MMAN ready and start          8,219    0.0             0            0
KTF sga latch                        50    0.0             0        6,291    0.0
KWQMN job cache list lat              5    0.0             0            0
KWQP Prop Status                    137    0.0             0            0
MQL Tracking Latch                    0                    0          490    0.0
Memory Management Latch               0                    0        8,219    0.0
OS process                        2,484    0.0             0            0
OS process allocation             9,877    0.0             0            0
OS process: request allo            574    0.0             0            0
PL/SQL warning settings          13,013    0.0             0            0
Reserved Space Latch                 18    0.0             0            0
SGA IO buffer pool latch         15,667    0.0             0       15,667    0.0
SQL memory manager latch            144    0.0             0        8,207    0.0
SQL memory manager worka        579,472    0.0             0            0
Shared B-Tree                     1,290    0.0             0            0
X$KSFQP                             133    0.0             0            0
active checkpoint queue          21,520    0.0             0            0
active service list              50,018    0.0             0        8,294    0.0
archive control                     754    0.0             0            0
archive process latch            10,544    0.0             0            0
begin backup scn array               11    0.0             0            0
cache buffer handles             12,238    0.0             0            0
cache buffers chains         18,355,349    0.0    0.1      0      961,192    0.0
cache buffers lru chain         649,687    0.0    0.0      0      511,811    0.0
cache table scan latch                0                    0       15,667    0.0
channel handle pool latc            612    0.0             0            0
channel operations paren        117,097    0.0    0.0      0            0
checkpoint queue latch          259,447    0.0    0.0      0       63,467    0.0
client/application info           2,615    0.0             0            0
commit callback allocati             38    0.0             0            0
compile environment latc          1,115    0.0             0            0
device information                   10    0.0             0            0
dictionary lookup                   103    0.0             0            0
dml lock allocation             111,883    0.0             0            0
dummy allocation                  2,228    0.0             0            0
enqueue hash chains             739,084    0.0    0.0      0            7    0.0
enqueues                        528,261    0.0    0.0      0            0
Latch Activity  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->"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                       Requests      Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
event group latch                   288    0.0             0            0
file cache latch                    628    0.0             0            0
global KZLD latch for me              9    0.0             0            0
global tx hash mapping           81,312    0.0             0            0
hash table column usage           1,479    0.0             0      271,963    0.0
hash table modification             464    0.0             0            0
internal temp table obje              3    0.0             0            0
job workq parent latch                0                    0        1,652    0.1
job_queue_processes para          1,096    0.0             0            0
kks stats                        45,348    0.0             0            0
kokc descriptor allocati        158,958    0.0             0            0
krbmrosl                          1,037    0.0             0            0
ksuosstats global area            1,930    0.0             0            0
ktm global data                     128    0.0             0            0
kwqbsn:qsga                       1,290    0.0             0            0
lgwr LWN SCN                     23,374    0.0    0.0      0            0
library cache                 1,158,042    0.0    0.0      0       29,330    0.5
library cache load lock           7,070    0.0             0           48    0.0
library cache lock              432,469    0.0    0.0      0            0
library cache lock alloc         17,630    0.0    0.0      0            0
library cache pin               436,534    0.0    0.0      0            0
library cache pin alloca          3,716    0.0             0            0
list of block allocation          3,671    0.0             0            0
loader state object free            142    0.0             0            0
longop free list parent           1,905    0.0             0          177    0.0
message pool operations              42    0.0             0            0
messages                        250,043    0.0    0.0      0            0
mostly latch-free SCN            23,390    0.0    0.0      0            0
multiblock read objects          33,784    0.0             0            0
ncodef allocation latch             395    0.0             0            0
object queue header heap         22,154    0.0             0          505    0.0
object queue header oper      1,227,227    0.0    0.0      0            0
object stats modificatio             95    0.0             0            0
parallel query alloc buf          3,228    0.0             0            0
parameter list                      117    0.0             0            0
parameter table allocati          1,250    0.0             0            0
post/wait queue                  18,614    0.0             0       12,304    0.0
process allocation                  574    0.0             0          288    0.0
process group creation              574    0.0             0            0
qmn task queue latch              3,516    0.0             0            0
redo allocation                 545,880    0.0    0.1      0            0
redo copy                             0                    0      481,359    0.0
redo writing                     95,744    0.0    0.0      0            0
reservation so alloc lat             12    0.0             0            0
row cache objects             2,215,954    0.0    0.0      0          464    0.2
rules engine rule set st         13,700    0.0             0            0
sequence cache                    8,721    0.0             0            0
session allocation              747,597    0.1    0.0      0            0
session idle bit              3,076,254    0.0    0.1      0            0
session state list latch          2,908    0.0             0            0
Latch Activity  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->"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                       Requests      Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
session switching                   395    0.0             0            0
session timer                     8,294    0.0             0            0
shared pool                     977,762    0.0    0.1      0            0
shared pool simulator           867,461    0.0    0.0      0            0
simulator hash latch            605,955    0.0             0            0
simulator lru latch              72,402    0.0    0.0      0      485,309    0.0
slave class                          13    0.0             0            0
slave class create                   53    9.4    1.0      0            0
sort extent pool                    753    0.0             0            0
state object free list               12    0.0             0            0
statistics aggregation            2,016    0.0             0            0
temp lob duration state               6    0.0             0            0
temporary table state ob              4    0.0             0            0
threshold alerts latch            1,049    0.0             0            0
transaction allocation            2,621    0.0             0            0
transaction branch alloc         73,505    0.0             0            0
undo global data                221,028    0.0    0.0      0            0
user lock                         1,690    0.2    0.0      0            0
          -------------------------------------------------------------
Latch Sleep breakdown  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by misses desc

                                       Get                                 Spin
Latch Name                        Requests       Misses      Sleeps        Gets
-------------------------- --------------- ------------ ----------- -----------
shared pool                        977,762          423          42         386
session allocation                 747,597          378           3         375
cache buffers lru chain            649,687          237           1         236
library cache                    1,158,042          186           9         179
In memory undo latch                37,457           99          95           4
cache buffers chains            18,355,349           98          12          86
object queue header operat       1,227,227           55           2          53
redo allocation                    545,880           42           5          37
enqueue hash chains                739,084           39           1          38
enqueues                           528,261           32           1          31
session idle bit                 3,076,254           14           1          13
slave class create                      53            5           5           0
          -------------------------------------------------------------
Latch Miss Sources  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch     ktiFlush: child                  0         89       10
In memory undo latch     kticmt: child                    0          9       83
In memory undo latch     ktichg: child                    0          1        6
cache buffers chains     kcbgcur: kslbegin                0          7        0
cache buffers chains     kcbbxsv                          0          5        4
cache buffers chains     kcbnlc                           0          2        0
cache buffers lru chain  kcbzgws_1                        0          1        1
enqueue hash chains      ksqrcl                           0          1        0
enqueues                 ksqgel: create enqueue           0          1        0
library cache            kglic                            0          5        0
library cache            kglScanDependency                0          3        0
library cache            kglobpn: child:                  0          1        1
object queue header oper kcbo_switch_mq_bg                0          1        0
object queue header oper kcbo_switch_q_bg                 0          1        0
redo allocation          kcrfw_redo_gen                   0          5        0
session allocation       ksudlc                           0          2        2
session allocation       ksufap: active sessions          0          1        0
session idle bit         ksupuc: set busy                 0          1        0
shared pool              kghalo                           0         36       24
shared pool              kghupr1                          0          3        2
shared pool              kghfrunp: alloc: wait            0          2        0
shared pool              kghalp                           0          1       11
slave class create       ksvcreate                        0          5        0
          -------------------------------------------------------------
Mutex Sleep  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> ordered by Wait Time desc

                                                                         Wait
Mutex Type         Location                                 Sleeps     Time (s)
------------------ -------------------------------- -------------- ------------
Cursor Pin         kkslce [KKSCHLPIN2]                           1          0.0
Cursor Parent      kkspsc0 [KKSPRTLOC26]                         3          0.0
          -------------------------------------------------------------
Dictionary Cache Stats  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->"Pct Misses"  should be very low (< 2% in most cases)
->"Final Usage" is the number of cache entries being used in End Snapshot

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control                     473    0.0       0             14          1
dc_constraints                     156   34.0       0            156          1
dc_database_links                   39    0.0       0              0          1
dc_files                             5  100.0       0              0          5
dc_global_oids                  82,014    0.1       0              0        104
dc_histogram_data              214,034    1.6       0          2,520      4,135
dc_histogram_defs               78,355    9.3       0          1,899      3,818
dc_object_grants                   462   21.2       0              0        218
dc_object_ids                  179,712    0.7       0             70      1,506
dc_objects                      23,296    6.2       0            338      1,364
dc_profiles                        965    0.0       0              0          1
dc_rollback_segments             2,761    0.0       0              0         22
dc_segments                     35,293    4.3       0            120      1,559
dc_sequences                     2,422    0.1       0          2,422          7
dc_table_scns                       12  100.0       0              0          0
dc_tablespace_quotas                41    2.4       0              1          3
dc_tablespaces                  58,608    0.0       0              0          7
dc_usernames                    11,649    0.1       0              0         50
dc_users                       178,803    0.0       0              0         88
global database name                 1  100.0       0              0          1
outstanding_alerts                 287    0.0       0              0          6
          -------------------------------------------------------------


Library Cache Activity  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
->"Pct Misses"  should be very low

                         Get  Pct        Pin        Pct               Invali-
Namespace           Requests  Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   5,562    1.2         21,938    0.3          2        0
CLUSTER                  220    1.4            567    0.7          1        0
INDEX                    258   71.3          1,583   18.4          0        0
SQL AREA              38,734   33.1        324,638    6.1        478      465
TABLE/PROCEDURE       12,142    9.0        164,902    1.9        836        0
TRIGGER                  908    2.0         25,146    0.1          4        0
          -------------------------------------------------------------
Rule Sets  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> * indicates Rule Set activity (re)started between Begin/End snaps
-> Top 25 ordered by Evaluations desc

                                                               No-SQL  SQL
Rule                                *     Eval/sec Reloads/sec Eval % Eval %
----------------------------------- - ------------ ----------- ------ ------
SYS.ALERT_QUE_R                                  0           0      0      0
          -------------------------------------------------------------
Shared Pool Advisory  DB/Inst: VCENTRE/vcentre  End Snap: 53995
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       136    .5       38        5,913 #######     .8 #######   11.5  40,057,668
       168    .6       67        8,450 #######     .9 #######    6.9  40,240,615
       200    .7       98       11,624 #######    1.0  80,010    4.4  40,270,316
       232    .8      129       14,247 #######    1.0  52,807    2.9  40,288,521
       264    .9      160       16,850 #######    1.0  44,776    2.4  40,302,293
       296   1.0      191       19,187 #######    1.0  18,324    1.0  40,315,422
       328   1.1      222       21,858 #######    1.0   7,997     .4  40,328,347
       360   1.2      253       24,523 #######    1.0       1     .0  40,341,422
       392   1.3      284       27,064 #######    1.0       1     .0  40,353,660
       424   1.4      315       29,683 #######    1.1       1     .0  40,364,030
       456   1.5      346       32,654 #######    1.1       1     .0  40,372,098
       488   1.6      377       35,392 #######    1.1       1     .0  40,381,777
       520   1.8      408       38,105 #######    1.1       1     .0  40,392,160
       552   1.9      439       40,931 #######    1.1       1     .0  40,399,839
       584   2.0      470       43,946 #######    1.1       1     .0  40,407,276
       616   2.1      501       46,684 #######    1.1       1     .0  40,413,336
          -------------------------------------------------------------
SGA Memory Summary  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

                                                        End Size (Bytes)
SGA regions                      Begin Size (Bytes)       (if different)
------------------------------ -------------------- --------------------
Database Buffers                        738,197,504
Fixed Size                                1,297,776
Redo Buffers                              7,090,176
Variable Size                           335,544,976
                               -------------------- --------------------
sum                                   1,082,130,432
          -------------------------------------------------------------


SGA breakdown difference  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995
-> Top 35 rows by size, ordered by Pool, Name (note rows with null values for
   Pool column, or Names showing free memory are always shown)
-> Null value for Begin MB or End MB indicates the size of that Pool/Name was
   insignificant, or zero in that snapshot

Pool   Name                                 Begin MB         End MB  % Diff
------ ------------------------------ -------------- -------------- --------
java p free memory                              24.0           24.0     0.00
shared ASH buffers                               4.0            4.0     0.00
shared CCursor                                  31.8           29.8    -6.43
shared Cursor Stats                              3.5            3.5     0.00
shared KCB Table Scan Buffer                     4.0            4.0     0.00
shared KGLS heap                                                7.6 ########
shared KQR M PO                                                 3.3 ########
shared KSFD SGA I/O b                            4.0            4.0     0.00
shared KTI-UNDO                                  4.0            4.0     0.00
shared PCursor                                  21.6           19.9    -7.84
shared PL/SQL MPCODE                                            4.7 ########
shared XDB Schema Cac                            4.5            5.3    17.99
shared db_block_hash_buckets                     3.0            3.0     0.00
shared event statistics per sess                 4.9            4.9     0.00
shared free memory                              23.6           19.2   -18.67
shared kglsim heap                               4.3            4.3     0.00
shared kglsim object batch                       6.9            6.9     0.00
shared library cache                            19.6           19.5    -0.99
shared private strands                           3.9            3.9     0.00
shared row cache                                 3.6            3.6     0.00
shared sql area                                106.2           96.5    -9.15
       buffer_cache                            704.0          704.0     0.00
       fixed_sga                                 1.2            1.2     0.00
       log_buffer                                6.8            6.8     0.00
          -------------------------------------------------------------
SQL Memory Statistics  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

                                   Begin            End         % Diff
                          -------------- -------------- --------------
   Avg Cursor Size (KB):           16.58          17.11           3.13
 Cursor to Parent ratio:            1.04           1.07           2.10
          Total Cursors:           8,126          7,061         -15.08
          Total Parents:           7,788          6,625         -17.55
          -------------------------------------------------------------
init.ora Parameters  DB/Inst: VCENTRE/vcentre  Snaps: 53858-53995

                                                                  End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
audit_file_dest               F:\ORACLE\PRODUCT\10.2.0.4\ADMIN\
background_dump_dest          F:\ORACLE\PRODUCT\10.2.0.4\ADMIN\
compatible                    10.2.0.3.0
control_files                 F:\ORACLE\PRODUCT\10.2.0.4\ORADAT
core_dump_dest                F:\ORACLE\PRODUCT\10.2.0.4\ADMIN\
cursor_sharing                EXACT
db_block_size                 8192
db_cache_size                 738197504
db_domain
db_file_multiblock_read_count 32
db_name                       VCENTRE
db_recovery_file_dest         F:\oracle\product\10.2.0.4\flash_
db_recovery_file_dest_size    64424509440
dispatchers
java_pool_size                25165824
job_queue_processes           10
large_pool_size               0
log_archive_format            ARC%S_%R.%T
log_archive_max_processes     10
log_checkpoint_interval       2000
log_checkpoint_timeout        180
log_checkpoints_to_alert      TRUE
nls_territory                 AMERICA
open_cursors                  1500
pga_aggregate_target          157286400
processes                     500
remote_login_passwordfile     EXCLUSIVE
shared_pool_size              310378496
shared_servers                0
smtp_out_server               p-mail
undo_management               AUTO
undo_tablespace               UNDOTBS1
user_dump_dest                F:\ORACLE\PRODUCT\10.2.0.4\ADMIN\
          -------------------------------------------------------------

End of Report ( sp_53858_53995.lst )

