STATSPACK report for

Database    DB Id    Instance     Inst Num Startup Time    Release     RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
          1792937263 ariepdb1            1 24-Sep-08 14:42 10.2.0.3.0  YES

Host  Name:   ariepdb1         Num CPUs:    4        Phys Memory (MB):    7,936
~~~~

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:          1 06-Oct-08 15:31:57       25       6.8
  End Snap:          3 06-Oct-08 16:20:40       27       8.5
   Elapsed:               48.72 (mins)

Cache Sizes                       Begin        End
~~~~~~~~~~~                  ---------- ----------
               Buffer Cache:     1,024M             Std Block Size:         8K
           Shared Pool Size:     1,024M                 Log Buffer:    13,920K

Load Profile                            Per Second       Per Transaction
~~~~~~~~~~~~                       ---------------       ---------------
                  Redo size:              4,694.68            211,116.12
              Logical reads:              5,248.27            236,010.63
              Block changes:                 14.97                673.35
             Physical reads:              2,532.15            113,868.97
            Physical writes:                  1.67                 75.05
                 User calls:                  2.43                109.43
                     Parses:                  0.80                 36.12
                Hard parses:                  0.03                  1.32
                      Sorts:                  0.17                  7.71
                     Logons:                  0.02                  0.75
                   Executes:                  1.72                 77.37
               Transactions:                  0.02

  % Blocks changed per Read:    0.29    Recursive Call %:    72.53
 Rollback per transaction %:   29.23       Rows per Sort:   233.98

Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.52       Redo NoWait %:  100.00
            Buffer  Hit   %:   51.75    In-memory Sort %:  100.00
            Library Hit   %:   96.00        Soft Parse %:   96.34
         Execute to Parse %:   53.31         Latch Hit %:   99.80
Parse CPU to Parse Elapsd %:   37.84     % Non-Parse CPU:   99.97

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   65.11   65.58
    % SQL with executions>1:   57.92   58.84
  % Memory for SQL w/exec>1:   71.97   72.66

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
CPU time                                                       524          40.1
gc cr multi block request                    2,112,318         372      0   28.5
db file scattered read                         228,258         210      1   16.1
gc buffer busy                                  72,282         171      2   13.1
db file parallel read                           68,786          21      0    1.6
          -------------------------------------------------------------
Host CPU  (CPUs: 4)
~~~~~~~~              Load Average
                      Begin     End      User  System    Idle     WIO     WCPU
                    ------- -------   ------- ------- ------- ------- --------
                       0.00    0.00      5.01    3.61   91.37    1.69    9.57

Instance CPU
~~~~~~~~~~~~
              % of total CPU for Instance:    4.99
              % of busy  CPU for Instance:   57.88
  %DB time waiting for CPU - Resource Mgr:

Memory Statistics                       Begin          End
~~~~~~~~~~~~~~~~~                ------------ ------------
                  Host Mem (MB):      7,936.0      7,936.0
                   SGA use (MB):      2,192.0      2,192.0
                   PGA use (MB):        193.6        198.6
    % Host Mem used for SGA+PGA:         30.1         30.1
          -------------------------------------------------------------

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

Statistic                                       Time (s) % of DB time
----------------------------------- -------------------- ------------
sql execute elapsed time                         1,179.0         99.8
DB CPU                                             524.5         44.4
parse time elapsed                                   1.0           .1
hard parse elapsed time                              0.9           .1
PL/SQL execution elapsed time                        0.6           .1
hard parse (sharing criteria) elaps                  0.1           .0
hard parse (bind mismatch) elapsed                   0.0           .0
connection management call elapsed                   0.0           .0
sequence load elapsed time                           0.0           .0
repeated bind elapsed time                           0.0           .0
PL/SQL compilation elapsed time                      0.0           .0
DB time                                          1,181.1
background elapsed time                             62.0
background cpu time                                 59.1
          -------------------------------------------------------------
RAC Statistics  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

                                Begin   End
                                ----- -----
           Number of Instances:     2     2


Global Cache Load Profile
~~~~~~~~~~~~~~~~~~~~~~~~~                  Per Second       Per Transaction
                                      ---------------       ---------------
  Global Cache blocks received:                823.64             37,038.31
    Global Cache blocks served:                  1.03                 46.11
     GCS/GES messages received:              1,242.68             55,882.37
         GCS/GES messages sent:              3,708.60            166,773.00
            DBWR Fusion writes:                  0.02                  0.98
Estd Interconnect traffic (KB):              7,564.34


Global Cache Efficiency Percentages (Target local+remote 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer access -  local cache %:   36.06
Buffer access - remote cache %:   15.69
Buffer access -         disk %:   48.25


Global Cache and Enqueue Services - Workload Characteristics
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                     Avg global enqueue get time (ms):     0.1

          Avg global cache cr block receive time (ms):     0.9
     Avg global cache current block receive time (ms):     1.0

            Avg global cache cr block build time (ms):     0.0
             Avg global cache cr block send time (ms):     0.1
            Avg global cache cr block flush time (ms):
      Global cache log flushes for cr blocks served %:     0.0

         Avg global cache current block pin time (ms):     0.0
        Avg global cache current block send time (ms):     0.0
       Avg global cache current block flush time (ms):
 Global cache log flushes for current blocks served %:     0.0


Global Cache and Enqueue Services - Messaging Statistics
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                     Avg message sent queue time (ms):     0.1
             Avg message sent queue time on ksxp (ms):     0.3
                 Avg message received queue time (ms):     0.0
                    Avg GCS message process time (ms):     0.0
                    Avg GES message process time (ms):     0.0

                            % of direct sent messages:    0.06
                          % of indirect sent messages:   99.92
                        % of flow controlled messages:    0.02
          -------------------------------------------------------------
Wait Events  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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
--------------------------------- ------------ ------ ---------- ------ --------
gc cr multi block request            2,112,318      0        372      0 ########
db file scattered read                 228,258      0        210      1  3,511.7
gc buffer busy                          72,282      0        171      2  1,112.0
db file parallel read                   68,786      0         21      0  1,058.2
db file parallel write                   1,750      0          2      1     26.9
control file sequential read             7,145      0          1      0    109.9
read by other session                      770      0          1      1     11.8
log file parallel write                    449      0          1      2      6.9
db file sequential read                  4,275      0          1      0     65.8
control file parallel write              1,014      0          1      1     15.6
gc current block 2-way                   1,029      0          0      0     15.8
CGS wait for IPC msg                    29,108    100          0      0    447.8
library cache lock                         474      0          0      0      7.3
log file sync                               51      0          0      2      0.8
name-service call wait                       3      0          0     42      0.0
gc cr block 2-way                          291      0          0      0      4.5
row cache lock                             522      0          0      0      8.0
gc cr grant 2-way                          370      0          0      0      5.7
enq: TM - contention                       208      0          0      0      3.2
IPC send completion sync                   131     99          0      0      2.0
enq: US - contention                       219      0          0      0      3.4
wait for scn ack                           354      0          0      0      5.4
PX Deq: Msg Fragment                       195     47          0      0      3.0
os thread startup                            2      0          0     19      0.0
gc current multi block request             612      0          0      0      9.4
gc cr block busy                             5      0          0      7      0.1
DFS lock handle                            114      0          0      0      1.8
enq: HW - contention                        72      0          0      0      1.1
ksxr poll remote instances               2,692     78          0      0     41.4
PX Deq: reap credit                      3,081    100          0      0     47.4
enq: PS - contention                        46      0          0      0      0.7
gc current grant busy                       33      0          0      0      0.5
latch: cache buffers chains                348      0          0      0      5.4
enq: CF - contention                        14      0          0      1      0.2
enq: TA - contention                        10      0          0      0      0.2
enq: FB - contention                         6      0          0      0      0.1
SQL*Net more data to client                102      0          0      0      1.6
rdbms ipc reply                              3      0          0      0      0.0
SQL*Net message from client              5,749      0     15,919   2769     88.4
PX Idle Wait                             2,370     98      5,707   2408     36.5
gcs remote message                     580,565    100      5,655     10  8,931.8
EMON idle wait                             585    100      2,854   4879      9.0
ges remote message                      39,068     98      2,854     73    601.0
DIAG idle wait                          14,613      0      2,854    195    224.8
Streams AQ: waiting for messages           596     99      2,847   4777      9.2
virtual circuit status                      97    100      2,813  29002      1.5
PX Deq: Execution Msg                      260     33          0      1      4.0
SQL*Net more data from client               40      0          0      0      0.6
SQL*Net message to client                5,752      0          0      0     88.5
Wait Events  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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: ARIEPDB/ariepdb1  Snaps: 1-3
-> %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 parallel write                   1,750      0          2      1     26.9
control file sequential read             6,526      0          1      0    100.4
log file parallel write                    449      0          1      2      6.9
control file parallel write              1,014      0          1      1     15.6
events in waitclass Other               32,520     96          0      0    500.3
enq: TM - contention                       170      0          0      0      2.6
os thread startup                            2      0          0     19      0.0
gc cr block 2-way                           61      0          0      0      0.9
gc current block 2-way                      46      0          0      0      0.7
gc current grant busy                        7      0          0      0      0.1
rdbms ipc message                       37,401     96     28,162    753    575.4
gcs remote message                     580,555    100      5,655     10  8,931.6
EMON idle wait                             585    100      2,854   4879      9.0
ges remote message                      39,042     98      2,854     73    600.6
DIAG idle wait                          14,613      0      2,854    195    224.8
pmon timer                                 979    100      2,851   2912     15.1
smon timer                                  10    100      2,638 ######      0.2
          -------------------------------------------------------------
Wait Event Histogram  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
CGS wait for IPC msg         29K 100.0
DFS lock handle             114  100.0
IPC send completion sync    131   99.2    .8
LGWR wait for redo copy      11  100.0
PX Deq: Msg Fragment        195   99.5                      .5
PX Deq: reap credit        3081  100.0
SQL*Net more data to clien  102  100.0
control file parallel writ 1014   95.6   4.0    .2    .1    .1
control file sequential re 7145   99.9    .0    .1
db file parallel read        68K  99.6    .3    .0    .1    .0    .0    .0
db file parallel write     1750   79.2   6.2   6.1   6.8   1.5    .1
db file scattered read      228K  97.9   1.5    .3    .3    .0    .0    .0
db file sequential read    4275   99.7    .1    .0    .2
enq: CF - contention         14   85.7  14.3
enq: FB - contention          6  100.0
enq: HW - contention         67  100.0
enq: PI - contention          1  100.0
enq: PS - contention         46  100.0
enq: TA - contention         10  100.0
enq: TM - contention        208   99.5    .5
enq: TT - contention          2  100.0
enq: US - contention        219  100.0
gc buffer busy               71K  18.0  15.4  65.2   1.3    .0    .0    .0
gc cr block 2-way           264   94.3   5.3    .4
gc cr block busy              5   60.0  20.0                    20.0
gc cr grant 2-way           366   99.5    .3    .3
gc cr multi block request  2112K  99.9    .1    .0    .0    .0    .0    .0    .0
gc current block 2-way     1013   99.3    .6    .1
gc current grant 2-way        4  100.0
gc current grant busy        32  100.0
gc current multi block req  590   99.7    .3
ksxr poll remote instances 2687  100.0
latch free                    2  100.0
latch: KCL gc element pare    4  100.0
latch: cache buffers chain  334   99.7    .3
latch: cache buffers lru c    8  100.0
latch: gcs resource hash      3  100.0
library cache lock          471   99.4    .6
log file parallel write     449   92.2    .9    .2   1.6   2.2    .7   2.2
log file sync                51   80.4   5.9         2.0   7.8   3.9
name-service call wait        3                           33.3  33.3  33.3
os thread startup             2   50.0                                50.0
rdbms ipc reply               3  100.0
read by other session       766   32.5  51.4  15.1    .8    .1
row cache lock              518   99.8    .2
wait for scn ack            354   99.4    .6
DIAG idle wait               14K                            .0    .0  99.9
EMON idle wait              585                                            100.0
PX Deq: Execution Msg       260   88.8         6.9         3.5    .4    .4
PX Idle Wait               2370           .0    .5    .1    .0    .0   1.0  98.3
SQL*Net message from clien 5749   33.3   5.6   5.4   8.5  14.4  13.4  10.2   9.2
Wait Event Histogram  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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  5723  100.0
SQL*Net more data from cli   40   97.5               2.5
Streams AQ: waiting for me  596                                         .5  99.5
dispatcher timer             48                                        2.1  97.9
gcs remote message          580K  20.4   2.9  36.7   8.2   5.6  26.2    .1
ges remote message           39K   5.3    .7    .3    .2    .2    .4  92.9
pmon timer                  979    1.4    .1                            .1  98.4
rdbms ipc message            37K   5.3    .2    .1    .1    .1    .0  78.4  15.7
smon timer                   10                                            100.0
virtual circuit status       97                                        1.0  99.0
          -------------------------------------------------------------

SQL ordered by CPU  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB CPU (s):             525
-> Captured SQL accounts for   95.1% 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
---------- ------------ ---------- ------ ---------- --------------- ----------
    474.08          395       1.20   90.4    1065.40      12,782,694 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

      9.42            2       4.71    1.8      10.50         150,195  371706031
Module: SQL*Plus
BEGIN statspack.snap(i_snap_level => 7); END;

      6.75            2       3.37    1.3       7.21          99,718 2783330933
Module: SQL*Plus
INSERT INTO STATS$SQL_PLAN ( PLAN_HASH_VALUE , ID , OPERATION ,
OPTIONS , OBJECT_NODE , OBJECT# , OBJECT_OWNER , OBJECT_NAME , O
BJECT_ALIAS , OBJECT_TYPE , OPTIMIZER , PARENT_ID , DEPTH , POSI
TION , SEARCH_COLUMNS , COST , CARDINALITY , BYTES , OTHER_TAG ,
 PARTITION_START , PARTITION_STOP , PARTITION_ID , OTHER , DISTR

          -------------------------------------------------------------
SQL ordered by Elapsed  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total DB Time (s):           1,181
-> Captured SQL accounts for   93.3% 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
---------- ------------ ---------- ------ ---------- --------------- ----------
   1065.40          395       2.70   90.2     474.08       6,971,894 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

          -------------------------------------------------------------
SQL ordered by Gets  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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:      15,340,691
-> Captured SQL accounts for   85.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
--------------- ------------ -------------- ------ -------- --------- ----------
     12,782,694          395       32,361.3   83.3   474.08   1065.40 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

          -------------------------------------------------------------
SQL ordered by Reads  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Disk Reads Threshold:      1000  Total Disk Reads:       7,401,483
-> Captured SQL accounts for   95.7% 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
--------------- ------------ -------------- ------ -------- --------- ----------
      6,971,894          395       17,650.4   94.2   474.08   1065.40 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

         98,365            4       24,591.3    1.3     3.29     11.43  252123343
select beneficiar0_.EH_CODE as EH1_28_, beneficiar0_.BENE_CODE a
s BENE2_28_, beneficiar0_.IC_NO as IC3_28_, beneficiar0_.BENE_NA
ME as BENE4_28_, beneficiar0_.ALTERNATE_BENE_NAME as ALTERNATE5_
28_, beneficiar0_.ALTERNATE_BENE_ADD1 as ALTERNATE6_28_, benefic
iar0_.ALTERNATE_BENE_ADD2 as ALTERNATE7_28_, beneficiar0_.ALTERN

          -------------------------------------------------------------
SQL ordered by Executions  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Executions Threshold:       100  Total Executions:           5,029
-> Captured SQL accounts for   84.0% 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
------------ --------------- ---------------- ----------- ---------- ----------
         585               0              0.0       0.00        0.00 1920230216
select  /*+ FIRST_ROWS(1) */   tab.rowid, tab.msgid, tab.corrid,
 tab.priority, tab.delay,   tab.expiration, tab.retry_count, tab
.exception_qschema,   tab.exception_queue, tab.chain_no, tab.loc
al_order_no, tab.enq_time,   tab.time_manager_info, tab.state, t
ab.enq_tid, tab.step_no, tab.user_data  from "SYS"."AQ_EVENT_TAB

         476             318              0.7       0.00        0.00 3665763022
update sys.col_usage$ set   equality_preds    = equality_preds
  + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoi
n_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_pre
ds       = range_preds       + decode(bitand(:flag,8),0,0,1),

         395             395              1.0       0.00        0.00 1924946697
select count(taskvo0_.TASK_ID) as col_0_0_ from TASK taskvo0_ wh
ere taskvo0_.EH_CODE=:1 and taskvo0_.DELETE_FLAG=:2 and taskvo0_
.DESTINATION_USER_CODE=:3 and taskvo0_.TASK_STATUS=:4

         395             347              0.9       1.20        2.70 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

         184             125              0.7       0.00        0.00    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

         184               0              0.0       0.00        0.00 2396279102
lock table sys.mon_mods$ in exclusive mode nowait

         164               0              0.0       0.00        0.00 2554034351
lock table sys.col_usage$ in exclusive mode nowait

         158             158              1.0       0.00        0.00  260339297
insert into sys.col_usage$ values (   :objn, :coln,   decode(bit
and(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(b
itand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode
(bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :t
ime)

         128             128              1.0       0.00        0.00 3400197331
Module: java@ariepmis (TNS V1-V3)
select rtrim(sys_context('userenv','current_schema')) from dual

         102             102              1.0       0.00        0.00 2743654637
INSERT INTO BANK_ACCOUNT_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,EH_C
ODE,BK_AC_CODE,BK_AC_NAME,BK_CODE,CURRENCY_CODE,ARRANGEMENT_TYPE
,INWARD_TT_ARRANGEMENT_TYPE,BK_AC_NO,MICR_REQUIRED,MICR_CODE,DD_
REMARKS_1,DD_REMARKS_2,DD_REMARKS_3,GENERAL_NOTES,DD_VALIDITY_MO
SQL ordered by Executions  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Executions Threshold:       100  Total Executions:           5,029
-> Captured SQL accounts for   84.0% 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
------------ --------------- ---------------- ----------- ---------- ----------
NTHS,SCOPE_OF_AC,CORRES_BK_LIMIT_FC,IM_ALIAS_NAME,AC_NO_FORMAT_1

         102             102              1.0       0.00        0.00 3899147569
INSERT INTO BANK_ACCOUNT_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,EH_C
ODE,BK_AC_CODE,BK_AC_NAME,BK_CODE,CURRENCY_CODE,ARRANGEMENT_TYPE
,INWARD_TT_ARRANGEMENT_TYPE,BK_AC_NO,MICR_REQUIRED,MICR_CODE,DD_
REMARKS_1,DD_REMARKS_2,DD_REMARKS_3,GENERAL_NOTES,DD_VALIDITY_MO
NTHS,SCOPE_OF_AC,CORRES_BK_LIMIT_FC,IM_ALIAS_NAME,AC_NO_FORMAT_1

          73               0              0.0       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

          59              59              1.0       0.00        0.00 1048608874
insert into sys.mon_mods$ values (:1, :2, :3, :4, :5, :6, :7)

          58              58              1.0       0.00        0.00  114366654
Module: java@ariepmis (TNS V1-V3)
SELECT CURRENCY_NAME FROM CURRENCY   WHERE CURRENCY_CODE =  :1


          58              56              1.0       0.00        0.00 1584316829
Module: java@ariepmis (TNS V1-V3)
SELECT BK_AC_NAME FROM BANK_ACCOUNT   WHERE BK_AC_CODE =  :1

          57              57              1.0       0.00        0.00 1722640360
Module: java@ariepmis (TNS V1-V3)
SELECT TRIM(TO_CHAR (TRUNC(:1 , CY.DECIMAL_DIGITS )  , '999,999,
999,999,999,999,990.' ||  RTRIM(LPAD('a' , CY.DECIMAL_DIGITS +
1  , '9' )  , 'a' )   )  )  FROM CURRENCY CY   WHERE CY.CURRENCY
_CODE =  NVL(:1 , 1 )

          56              56              1.0       0.00        0.00 1198191172
Module: java@ariepmis (TNS V1-V3)
SELECT NVL(REASON_NAME , '-' )  FROM REASON   WHERE REASON_CODE
=  NVL(:1 , 13 )

          -------------------------------------------------------------
SQL ordered by Parse Calls  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Parse Calls Threshold:      1000 Total Parse Calls:           2,348
-> Captured SQL accounts for   86.3% of Total Parse Calls
-> SQL reported below exceeded  1.0% of Total Parse Calls

                           % Total    Old
 Parse Calls  Executions   Parses  Hash Value
------------ ------------ -------- ----------
         184          184     7.84    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

         184          184     7.84 2396279102
lock table sys.mon_mods$ in exclusive mode nowait

         164          158     6.98  260339297
insert into sys.col_usage$ values (   :objn, :coln,   decode(bit
and(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(b
itand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode
(bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :t
ime)

         164          164     6.98 2554034351
lock table sys.col_usage$ in exclusive mode nowait

         164          476     6.98 3665763022
update sys.col_usage$ set   equality_preds    = equality_preds
  + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoi
n_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_pre
ds       = range_preds       + decode(bitand(:flag,8),0,0,1),

         128          128     5.45 3400197331
Module: java@ariepmis (TNS V1-V3)
select rtrim(sys_context('userenv','current_schema')) from dual

          90          102     3.83 2743654637
INSERT INTO BANK_ACCOUNT_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,EH_C
ODE,BK_AC_CODE,BK_AC_NAME,BK_CODE,CURRENCY_CODE,ARRANGEMENT_TYPE
,INWARD_TT_ARRANGEMENT_TYPE,BK_AC_NO,MICR_REQUIRED,MICR_CODE,DD_
REMARKS_1,DD_REMARKS_2,DD_REMARKS_3,GENERAL_NOTES,DD_VALIDITY_MO
NTHS,SCOPE_OF_AC,CORRES_BK_LIMIT_FC,IM_ALIAS_NAME,AC_NO_FORMAT_1

          90          102     3.83 3899147569
INSERT INTO BANK_ACCOUNT_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,EH_C
ODE,BK_AC_CODE,BK_AC_NAME,BK_CODE,CURRENCY_CODE,ARRANGEMENT_TYPE
,INWARD_TT_ARRANGEMENT_TYPE,BK_AC_NO,MICR_REQUIRED,MICR_CODE,DD_
REMARKS_1,DD_REMARKS_2,DD_REMARKS_3,GENERAL_NOTES,DD_VALIDITY_MO
NTHS,SCOPE_OF_AC,CORRES_BK_LIMIT_FC,IM_ALIAS_NAME,AC_NO_FORMAT_1

          59           59     2.51 1048608874
insert into sys.mon_mods$ values (:1, :2, :3, :4, :5, :6, :7)

          31          395     1.32 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

SQL ordered by Parse Calls  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Parse Calls Threshold:      1000 Total Parse Calls:           2,348
-> Captured SQL accounts for   86.3% of Total Parse Calls
-> SQL reported below exceeded  1.0% of Total Parse Calls

                           % Total    Old
 Parse Calls  Executions   Parses  Hash Value
------------ ------------ -------- ----------
          27          395     1.15 1924946697
select count(taskvo0_.TASK_ID) as col_0_0_ from TASK taskvo0_ wh
ere taskvo0_.EH_CODE=:1 and taskvo0_.DELETE_FLAG=:2 and taskvo0_
.DESTINATION_USER_CODE=:3 and taskvo0_.TASK_STATUS=:4

          -------------------------------------------------------------
SQL ordered by Sharable Memory  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Sharable Memory Threshold:   1048576

Sharable Mem (b)  Executions  % Total Old Hash Value
---------------- ------------ ------- --------------
       6,262,416            3     0.6   1503900916
insert into TEMP_DOC (DOC_ID, TXN_NO, EH_BR_CODE, DOC_NO, PRODUC
T_DEFINITION_CODE, PRODUCT_CODE, TT_SUBPRODUCT_CODE, CC_BR_CODE,
 CC_NO, FC_CODE, FC_AMOUNT, LC_AMOUNT, EXCH_RATE, BOARD_RATE, AC
TUAL_VALUATION_RATE, DEAL_RATE, MISC_PRODUCT_CODE, TXN_VALUATION
_RATE, MISC_SUBPRODUCT_CODE, UNIT_PRICE, SOURCE_OF_FUND_CODE, BA

       4,057,184            2     0.4   3545646772
update BANK_ACCOUNT set BK_AC_NAME=:1, BK_CODE=to_number(:2), AR
RANGEMENT_TYPE=:3, CURRENCY_CODE=to_number(:4), INWARD_TT_ARRANG
EMENT_TYPE=:5, BK_AC_NO=:6, DELETE_FLAG=:7, MICR_REQUIRED=to_num
ber(:8), MICR_CODE=:9, DD_REMARKS_1=:10, DD_REMARKS_2=:11, DD_RE
MARKS_3=:12, GENERAL_NOTES=:13, DD_VALIDITY_MONTHS=to_number(:14

       1,432,250            2     0.1   1493505662
update NODAL_POINT set BK_CODE=to_number(:1), NODAL_POINT_NAME=:
2, NODAL_POINT_ADD1=:3, NODAL_POINT_ADD2=:4, NODAL_POINT_ADD3=:5
, COUNTRY_CODE=to_number(:6), REGION=:7, STATE=:8, CITY=:9, AREA
=:10, PIN_CODE=:11, TELEPHONE=:12, FAX=:13, CONTACT_PERSON=:14,
NODAL_POINT_INTIMATION_MODE_1=to_number(:15), NODAL_POINT_INTIMA

       1,077,771            1     0.1   2139425675
Module: TOAD 8.5.3.2
select o.*, NVL(d.debuginfo, 'F') DEBUGINFO, nvl(p.AUTHID, 'CURR
ENT_USER') authid from ( Select object_name, object_type, decode
(status, 'VALID', 'V', 'I') status, last_ddl_time, object_id, cr
eated from sys.user_objects where 1=1 and object_type in ('FUNCT
ION', 'PROCEDURE', 'PACKAGE', 'PACKAGE BODY') ) o, sys.all_probe

          -------------------------------------------------------------
SQL ordered by Version Count  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Version Count Threshold:        20

 Version
   Count  Executions   Old Hash Value
-------- ------------ ---------------
      32            2   3545646772
update BANK_ACCOUNT set BK_AC_NAME=:1, BK_CODE=to_number(:2), AR
RANGEMENT_TYPE=:3, CURRENCY_CODE=to_number(:4), INWARD_TT_ARRANG
EMENT_TYPE=:5, BK_AC_NO=:6, DELETE_FLAG=:7, MICR_REQUIRED=to_num
ber(:8), MICR_CODE=:9, DD_REMARKS_1=:10, DD_REMARKS_2=:11, DD_RE
MARKS_3=:12, GENERAL_NOTES=:13, DD_VALIDITY_MONTHS=to_number(:14

      25            3   1503900916
insert into TEMP_DOC (DOC_ID, TXN_NO, EH_BR_CODE, DOC_NO, PRODUC
T_DEFINITION_CODE, PRODUCT_CODE, TT_SUBPRODUCT_CODE, CC_BR_CODE,
 CC_NO, FC_CODE, FC_AMOUNT, LC_AMOUNT, EXCH_RATE, BOARD_RATE, AC
TUAL_VALUATION_RATE, DEAL_RATE, MISC_PRODUCT_CODE, TXN_VALUATION
_RATE, MISC_SUBPRODUCT_CODE, UNIT_PRICE, SOURCE_OF_FUND_CODE, BA

          -------------------------------------------------------------
SQL ordered by Cluster Wait Time  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

  Cluster      CWT % of     Elapsd        CPU                      Old
Wait Time (s) Elapsd Time   Time (s)    Time (s)    Executions   Hash Value
------------- ----------- ----------- ----------- -------------- ----------
       486.11        45.6    1,065.40      474.08            395 3494640853
select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0
_ where alertvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and al
ertvo0_.ALERT_TO_USER=:3 and alertvo0_.STATUS=:4

         2.12        18.5       11.43        3.29              4  252123343
select beneficiar0_.EH_CODE as EH1_28_, beneficiar0_.BENE_CODE a
s BENE2_28_, beneficiar0_.IC_NO as IC3_28_, beneficiar0_.BENE_NA
ME as BENE4_28_, beneficiar0_.ALTERNATE_BENE_NAME as ALTERNATE5_
28_, beneficiar0_.ALTERNATE_BENE_ADD1 as ALTERNATE6_28_, benefic
iar0_.ALTERNATE_BENE_ADD2 as ALTERNATE7_28_, beneficiar0_.ALTERN

         1.17        47.2        2.48        1.18              1 2102381498
select alertvo0_.ALERT_ID as col_0_0_, alerttypev1_.ALERT_TYPE_N
AME as col_1_0_, secureduse2_.USER_NAME as col_2_0_, alertvo0_.C
REATED_DATE as col_3_0_, exchangeho3_.EH_BR_NAME as col_4_0_, al
ertvo0_.ALERT_MESSAGE as col_5_0_, alertvo0_.ROW_VERSION_NUMBER
as col_6_0_, alertvo0_.STATUS as col_7_0_ from ALERT alertvo0_,

          .05         0.4       10.50        9.42              2  371706031
Module: SQL*Plus
BEGIN statspack.snap(i_snap_level => 7); END;

          .02        43.8        0.04        0.04              5  466491438
select smontabv.cnt, smontab.time_mp,    smontab.scn, smontab.nu
m_mappings, smontab.tim_scn_map, smontab.orig_thread    from smo
n_scn_time smontab,         (select max(scn) scnmax,
     count(*)+sum(NVL2(TIM_SCN_MAP,NUM_MAPPINGS,0)) cnt
        from smon_scn_time where thread=0) smontabv   where smon

          .01        57.7        0.03        0.03              7  356910524
update SEQ_NUMBER set PREVIOUS_SEQ_NO=PREVIOUS_SEQ_NO+INCREMENT_
BY, PREVIOUS_SEQ_USED_DATE=to_date(:1, 'DD-MM-YYYY'), ROW_VERSIO
N_NUMBER=ROW_VERSION_NUMBER+1 where SEQ_CODE=:2 and EH_CODE=:3 a
nd ROW_VERSION_NUMBER=:4 and DELETE_FLAG=:5 and PREVIOUS_SEQ_NO+
INCREMENT_BY<=END_SEQ_NO

          .01        63.8        0.02        0.02             11 1567718282
INSERT INTO SEQ_NUMBER_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,USER_C
ODE,EH_CODE,SEQ_CODE,EH_BR_CODE,BK_AC_CODE,START_SEQ_NO,END_SEQ_
NO,INCREMENT_BY,PREVIOUS_SEQ_NO,PREVIOUS_SEQ_USED_DATE,RESET_FRE
QUENCY,STARTED_DATE,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED
_DATE,DELETE_FLAG,ROW_VERSION_NUMBER) VALUES (SEQ_NUMBER_SEQ.NEX

          .01        33.5        0.04        0.02              4 4270608805
Module: OEM.CacheModeWaitnPool
BEGIN EMD_NOTIFICATION.DEQUEUE(:1, :2, :3, :4); END;

          .01         8.1        0.12        0.06            102 3899147569
INSERT INTO BANK_ACCOUNT_AT(AUDIT_ID, AUDIT_FLAG,AUDIT_DATE,EH_C
ODE,BK_AC_CODE,BK_AC_NAME,BK_CODE,CURRENCY_CODE,ARRANGEMENT_TYPE
,INWARD_TT_ARRANGEMENT_TYPE,BK_AC_NO,MICR_REQUIRED,MICR_CODE,DD_
REMARKS_1,DD_REMARKS_2,DD_REMARKS_3,GENERAL_NOTES,DD_VALIDITY_MO
NTHS,SCOPE_OF_AC,CORRES_BK_LIMIT_FC,IM_ALIAS_NAME,AC_NO_FORMAT_1

SQL ordered by Cluster Wait Time  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

  Cluster      CWT % of     Elapsd        CPU                      Old
Wait Time (s) Elapsd Time   Time (s)    Time (s)    Executions   Hash Value
------------- ----------- ----------- ----------- -------------- ----------
          .01        14.4        0.07        0.07            476 3665763022
update sys.col_usage$ set   equality_preds    = equality_preds
  + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoi
n_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_pre
ds       = range_preds       + decode(bitand(:flag,8),0,0,1),

          .01        61.4        0.02        0.02              4 3712212843
Module: OEM.CacheModeWaitnPool
BEGIN EMD_NOTIFICATION.GET_SEVERITY_DETAILS(:1, :2, :3); END;

          .01        56.4        0.01        0.01              4 3600464091
Module: OEM.CacheModeWaitnPool
BEGIN EMD_NOTIFICATION.SETUP_FOR_RETRY(:1, :2); END;

          .01         0.1        7.21        6.75              2 2783330933
Module: SQL*Plus
INSERT INTO STATS$SQL_PLAN ( PLAN_HASH_VALUE , ID , OPERATION ,
OPTIONS , OBJECT_NODE , OBJECT# , OBJECT_OWNER , OBJECT_NAME , O
BJECT_ALIAS , OBJECT_TYPE , OPTIMIZER , PARENT_ID , DEPTH , POSI
TION , SEARCH_COLUMNS , COST , CARDINALITY , BYTES , OTHER_TAG ,
 PARTITION_START , PARTITION_STOP , PARTITION_ID , OTHER , DISTR

          .01         5.8        0.10        0.08              1 1685633182
Module: TOAD 8.5.3.2
select  tabs.table_name, 'IFACTS_U2', tabs.cluster_name        ,
 partitioned, iot_type         , TEMPORARY, table_type, table_ty
pe_owner         ,tablespace_name        , NESTED         , last
_analyzed        , Dropped           , DECODE(TO_CHAR(pct_free)
|| TO_CHAR(pct_used) || cluster_name || iot_type, '00', 'YES', '

          .00        51.1        0.01        0.01              8 2043957858
insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wr
p, scn_bas,  num_mappings, tim_scn_map) values (0, :1, :2, :3, :
4, :5, :6, :7)

          .00        61.7        0.01        0.01              4 2314035986
Module: OEM.CacheModeWaitnPool
UPDATE MGMT_NOTIFY_REQUEUE SET LAST_TIMESTAMP = SYSDATE, NUM_REQ
UEUES = NUM_REQUEUES + 1 WHERE DEVICE_NAME = :B5 AND DEVICE_OWNE
R = :B4 AND SOURCE_GUID = :B3 AND RULE_NAME = :B2 AND RULE_OWNER
 = :B1

          .00         8.6        0.04        0.04            158  260339297
insert into sys.col_usage$ values (   :objn, :coln,   decode(bit
and(:flag,1),0,0,1),   decode(bitand(:flag,2),0,0,1),   decode(b
itand(:flag,4),0,0,1),   decode(bitand(:flag,8),0,0,1),   decode
(bitand(:flag,16),0,0,1),   decode(bitand(:flag,32),0,0,1),   :t
ime)

          -------------------------------------------------------------
Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session                      52,356           17.9        805.5
CPU used when call started                    52,461           18.0        807.1
CR blocks created                                  0            0.0          0.0
Cached Commit SCN referenced                       0            0.0          0.0
Commit SCN cached                                  0            0.0          0.0
DB time                                      412,958          141.3      6,353.2
DBWR checkpoint buffers written                4,818            1.7         74.1
DBWR checkpoints                                   0            0.0          0.0
DBWR fusion writes                                64            0.0          1.0
DBWR object drop buffers written                   0            0.0          0.0
DBWR tablespace checkpoint buffer                  0            0.0          0.0
DBWR thread checkpoint buffers wr                  0            0.0          0.0
DBWR transaction table writes                     42            0.0          0.7
DBWR undo block writes                         1,012            0.4         15.6
DDL statements parallelized                        0            0.0          0.0
DFO trees parallelized                             0            0.0          0.0
PX local messages recv'd                           0            0.0          0.0
PX local messages sent                             0            0.0          0.0
PX remote messages recv'd                        202            0.1          3.1
PX remote messages sent                           90            0.0          1.4
Parallel operations downgraded to                  0            0.0          0.0
Parallel operations not downgrade                  0            0.0          0.0
RowCR - row contention                             0            0.0          0.0
RowCR attempts                                    14            0.0          0.2
RowCR hits                                        14            0.0          0.2
SMON posted for instance recovery                  0            0.0          0.0
SMON posted for undo segment reco                  0            0.0          0.0
SMON posted for undo segment shri                  0            0.0          0.0
SQL*Net roundtrips to/from client              5,739            2.0         88.3
SQL*Net roundtrips to/from dblink                  0            0.0          0.0
active txn count during cleanout                 695            0.2         10.7
application wait time                              6            0.0          0.1
background checkpoints completed                   0            0.0          0.0
background checkpoints started                     0            0.0          0.0
background timeouts                            5,816            2.0         89.5
branch node splits                                 0            0.0          0.0
buffer is not pinned count                    66,112           22.6      1,017.1
buffer is pinned count                        53,589           18.3        824.5
bytes received via SQL*Net from c            851,449          291.3     13,099.2
bytes received via SQL*Net from d                  0            0.0          0.0
bytes sent via SQL*Net to client           1,374,926          470.4     21,152.7
bytes sent via SQL*Net to dblink                   0            0.0          0.0
calls to get snapshot scn: kcmgss             20,574            7.0        316.5
calls to kcmgas                                1,976            0.7         30.4
calls to kcmgcs                                  486            0.2          7.5
change write time                                 21            0.0          0.3
cleanout - number of ktugct calls                712            0.2         11.0
cleanouts and rollbacks - consist                  0            0.0          0.0
cleanouts only - consistent read                   3            0.0          0.1
cluster key scan block gets                   20,285            6.9        312.1
cluster key scans                              9,640            3.3        148.3
cluster wait time                             54,376           18.6        836.6
commit batch performed                             0            0.0          0.0
commit batch requested                             0            0.0          0.0
commit batch/immediate performed                   1            0.0          0.0
commit batch/immediate requested                   1            0.0          0.0
Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
commit cleanout failures: block l                  0            0.0          0.0
commit cleanout failures: buffer                   0            0.0          0.0
commit cleanout failures: callbac                 19            0.0          0.3
commit cleanout failures: cannot                   0            0.0          0.0
commit cleanouts                               1,824            0.6         28.1
commit cleanouts successfully com              1,805            0.6         27.8
commit immediate performed                         1            0.0          0.0
commit immediate requested                         1            0.0          0.0
commit txn count during cleanout                 187            0.1          2.9
concurrency wait time                             29            0.0          0.5
consistent changes                                 0            0.0          0.0
consistent gets                           15,301,875        5,235.0    235,413.5
consistent gets - examination                 34,290           11.7        527.5
consistent gets direct                             0            0.0          0.0
consistent gets from cache                15,301,887        5,235.0    235,413.7
current blocks converted for CR                    0            0.0          0.0
cursor authentications                            97            0.0          1.5
data blocks consistent reads - un                  0            0.0          0.0
db block changes                              43,768           15.0        673.4
db block gets                                 38,816           13.3        597.2
db block gets direct                               0            0.0          0.0
db block gets from cache                      38,825           13.3        597.3
deferred (CURRENT) block cleanout                554            0.2          8.5
dirty buffers inspected                            0            0.0          0.0
enqueue conversions                              165            0.1          2.5
enqueue deadlocks                                  0            0.0          0.0
enqueue releases                              13,979            4.8        215.1
enqueue requests                              13,979            4.8        215.1
enqueue timeouts                                   0            0.0          0.0
enqueue waits                                    559            0.2          8.6
exchange deadlocks                                 0            0.0          0.0
execute count                                  5,029            1.7         77.4
failed probes on index block recl                  0            0.0          0.0
free buffer inspected                      9,797,106        3,351.7    150,724.7
free buffer requested                      9,810,844        3,356.4    150,936.1
gc CPU used by this session                   37,394           12.8        575.3
gc cr block build time                             1            0.0          0.0
gc cr block flush time                             0            0.0          0.0
gc cr block receive time                          58            0.0          0.9
gc cr block send time                              2            0.0          0.0
gc cr blocks received                            678            0.2         10.4
gc cr blocks served                              365            0.1          5.6
gc current block flush time                        0            0.0          0.0
gc current block pin time                          0            0.0          0.0
gc current block receive time                235,590           80.6      3,624.5
gc current block send time                         6            0.0          0.1
gc current blocks received                 2,406,812          823.4     37,027.9
gc current blocks served                       2,632            0.9         40.5
gc local grants                            3,777,327        1,292.3     58,112.7
gc remote grants                           3,603,090        1,232.7     55,432.2
gcs messages sent                         10,837,490        3,707.7    166,730.6
ges messages sent                              2,755            0.9         42.4
global enqueue get time                           52            0.0          0.8
global enqueue gets async                        517            0.2          8.0
global enqueue gets sync                       8,528            2.9        131.2
global enqueue releases                        8,252            2.8        127.0
Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
heap block compress                               10            0.0          0.2
hot buffers moved to head of LRU                  18            0.0          0.3
immediate (CR) block cleanout app                  3            0.0          0.1
immediate (CURRENT) block cleanou                457            0.2          7.0
index crx upgrade (found)                          0            0.0          0.0
index crx upgrade (positioned)                   824            0.3         12.7
index fast full scans (full)                      31            0.0          0.5
index fetch by key                            32,356           11.1        497.8
index scans kdiixs1                            4,646            1.6         71.5
leaf node 90-10 splits                            66            0.0          1.0
leaf node splits                                 170            0.1          2.6
lob reads                                          0            0.0          0.0
lob writes                                         0            0.0          0.0
lob writes unaligned                               0            0.0          0.0
logons cumulative                                 49            0.0          0.8
messages received                              2,689            0.9         41.4
messages sent                                  2,689            0.9         41.4
no buffer to keep pinned count                     0            0.0          0.0
no work - consistent read gets            15,253,756        5,218.5    234,673.2
opened cursors cumulative                      2,878            1.0         44.3
parse count (failures)                             0            0.0          0.0
parse count (hard)                                86            0.0          1.3
parse count (total)                            2,348            0.8         36.1
parse time cpu                                    14            0.0          0.2
parse time elapsed                                37            0.0          0.6
physical read IO requests                    638,387          218.4      9,821.3
physical read bytes                   60,632,948,736   20,743,396.8 ############
physical read total IO requests              645,533          220.9      9,931.3
physical read total bytes             60,750,028,800   20,783,451.5 ############
physical read total multi block r            228,258           78.1      3,511.7
physical reads                             7,401,483        2,532.2    113,869.0
physical reads cache                       7,401,483        2,532.2    113,869.0
physical reads cache prefetch              7,100,164        2,429.1    109,233.3
physical reads direct                              0            0.0          0.0
physical reads direct (lob)                        0            0.0          0.0
physical reads direct temporary t                  0            0.0          0.0
physical reads prefetch warmup                     0            0.0          0.0
physical write IO requests                     1,767            0.6         27.2
physical write bytes                      39,960,576       13,671.1    614,778.1
physical write total IO requests               5,723            2.0         88.1
physical write total bytes               118,331,392       40,482.9  1,820,483.0
physical write total multi block               1,483            0.5         22.8
physical writes                                4,878            1.7         75.1
physical writes direct                             0            0.0          0.0
physical writes direct (lob)                       0            0.0          0.0
physical writes direct temporary                   0            0.0          0.0
physical writes from cache                     4,878            1.7         75.1
physical writes non checkpoint                 4,333            1.5         66.7
pinned buffers inspected                       8,603            2.9        132.4
prefetch warmup blocks aged out b                  0            0.0          0.0
prefetch warmup blocks flushed ou                  0            0.0          0.0
prefetched blocks aged out before                  1            0.0          0.0
process last non-idle time                     1,465            0.5         22.5
queries parallelized                               0            0.0          0.0
recovery blocks read                               0            0.0          0.0
recursive calls                               18,777            6.4        288.9
Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
recursive cpu usage                            1,080            0.4         16.6
redo blocks read for recovery                      0            0.0          0.0
redo blocks written                           27,862            9.5        428.7
redo buffer allocation retries                     0            0.0          0.0
redo entries                                  25,062            8.6        385.6
redo log space requests                            0            0.0          0.0
redo log space wait time                           0            0.0          0.0
redo ordering marks                              710            0.2         10.9
redo size                                 13,722,548        4,694.7    211,116.1
redo subscn max counts                           171            0.1          2.6
redo synch time                                   13            0.0          0.2
redo synch writes                                630            0.2          9.7
redo wastage                                 118,984           40.7      1,830.5
redo write time                                   83            0.0          1.3
redo writer latching time                          0            0.0          0.0
redo writes                                      449            0.2          6.9
rollback changes - undo records a                  2            0.0          0.0
rollbacks only - consistent read                   0            0.0          0.0
rows fetched via callback                     10,966            3.8        168.7
session connect time                               0            0.0          0.0
session cursor cache hits                      1,629            0.6         25.1
session logical reads                     15,340,691        5,248.3    236,010.6
session pga memory                        27,207,768        9,308.2    418,581.1
session pga memory max                   138,946,648       47,535.6  2,137,640.7
session uga memory                         4,526,976        1,548.7     69,645.8
session uga memory max                    33,196,248       11,356.9    510,711.5
shared hash latch upgrades - no w              1,096            0.4         16.9
shared hash latch upgrades - wait                  0            0.0          0.0
sorts (disk)                                       0            0.0          0.0
sorts (memory)                                   501            0.2          7.7
sorts (rows)                                 117,224           40.1      1,803.5
sql area evicted                                   0            0.0          0.0
sql area purged                                    0            0.0          0.0
summed dirty queue length                          0            0.0          0.0
switch current to new buffer                      33            0.0          0.5
table fetch by rowid                          22,921            7.8        352.6
table fetch continued row                        198            0.1          3.1
table scan blocks gotten                  14,712,107        5,033.2    226,340.1
table scan rows gotten                 1,108,416,603      379,205.1 ############
table scans (long tables)                        400            0.1          6.2
table scans (rowid ranges)                         0            0.0          0.0
table scans (short tables)                     2,214            0.8         34.1
total number of times SMON posted                  0            0.0          0.0
transaction lock background gets                   0            0.0          0.0
transaction lock foreground reque                  0            0.0          0.0
transaction rollbacks                              1            0.0          0.0
transaction tables consistent rea                  0            0.0          0.0
transaction tables consistent rea                  0            0.0          0.0
undo change vector size                    3,770,328        1,289.9     58,005.1
user I/O wait time                            23,319            8.0        358.8
user calls                                     7,113            2.4        109.4
user commits                                      46            0.0          0.7
user rollbacks                                    19            0.0          0.3
workarea executions - onepass                      0            0.0          0.0
workarea executions - optimal                    540            0.2          8.3
write clones created in backgroun                  0            0.0          0.0
Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
write clones created in foregroun                  0            0.0          0.0
          -------------------------------------------------------------

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

Statistic                             Begin Value       End Value
--------------------------------- --------------- ---------------
logons current                                 25              27
opened cursors current                        169             229
session cursor cache count                 36,764          36,877
          -------------------------------------------------------------

Instance Activity Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                      Total  per Hour
--------------------------------- ------------------ ---------
log switches (derived)                             0       .00
          -------------------------------------------------------------

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

Statistic                                  Total
------------------------- ----------------------
NUM_LCPUS                                      0
NUM_VCPUS                                      0
BUSY_TIME                                100,821
IDLE_TIME                              1,068,114
IOWAIT_TIME                               19,796
SYS_TIME                                  42,227
USER_TIME                                 58,594
OS_CPU_WAIT_TIME                         111,900
PHYSICAL_MEMORY_BYTES              8,321,499,136
NUM_CPUS                                       4
NUM_CPU_CORES                                  2
          -------------------------------------------------------------
Tablespace IO Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->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
     7,902,452   2,704    0.8    10.9        8,372        3    512,054    2.4
SYSAUX
        46,579      16    7.1     1.3      139,290       48         65    2.5
IFACTSTEST
        94,153      32  168.2    14.2        9,253        3          0    0.0
UNDOTBS1
           149       0 ######     1.0       51,856       18         75    0.0
SYSTEM
         8,725       3   27.4     1.1       17,111        6        117    0.8
STATSPACK
             0       0    0.0                1,204        0          0    0.0
UNDOTBS2
           163       0 ######     1.0          150        0          0    0.0
          -------------------------------------------------------------
File IO Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->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)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
IFACTSTEST               /u03/ariepdb/ifactstest01.dbf
        15,422       5 #####        15.7          268        0          0
                         /u03/ariepdb/ifactstest02.dbf
        17,025       6 #####        14.0        2,022        1          0
                         /u03/ariepdb/ifactstest03.dbf
        15,408       5 #####        15.7          247        0          0
                         /u03/ariepdb/ifactstest04.dbf
        17,348       6 #####        13.9        1,269        0          0
                         /u03/ariepdb/ifactstest05.dbf
        15,487       5 #####        15.6        1,196        0          0
                         /u03/ariepdb/ifactstest06.dbf
         6,812       2 #####         9.7        2,740        1          0
                         /u03/ariepdb/ifactstest07.dbf
         6,651       2 #####         9.8        1,511        1          0

STATSPACK                /u03/ariepdb/statspack.dbf
             0       0                          1,204        0          0

SYSAUX                   /u02/ariepdb/sysaux01.dbf
        46,579      16   7.1         1.3      139,290       48         65    2.5

SYSTEM                   /u01/ariepdb/system01.dbf
         8,725       3  27.4   8     1.1       17,111        6        117    0.8

UNDOTBS1                 /u03/ariepdb/undotbs01.dbf
           149       0 #####         1.0       51,856       18         75    0.0

UNDOTBS2                 /u04/ariepdb/undotbs02.dbf
           163       0 #####         1.0          150        0          0

USERS                    /u04/ariepdb/users01.dbf
     7,902,452   2,704   0.8   8    10.9        8,372        3    512,054    2.4

          -------------------------------------------------------------
File Read Histogram Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->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
------------ ------------ ------------ ------------ ------------ ------------
SYSTEM                   /u01/ariepdb/system01.dbf
           0            0            1            0            0            0

USERS                    /u04/ariepdb/users01.dbf
       4,264            2            8            0            0            0

          -------------------------------------------------------------
Buffer Pool Statistics  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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      122K   52     15,330,333    7,401,567       4,878       0    0     73,052
          -------------------------------------------------------------

Instance Recovery Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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    14       2894     17142     17428      92160     17428
E     0    11        323       170      5864      92160      5864
          -------------------------------------------------------------

Buffer Pool Advisory  DB/Inst: ARIEPDB/ariepdb1  End Snap: 3
-> 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         96    .1           12    1.0         88,229        3,173      3.4
D        192    .2           23    1.0         87,716        3,140      3.3
D        288    .3           35    1.0         87,667        3,136      3.3
D        384    .4           46    1.0         87,656        3,136      3.3
D        480    .5           58    1.0         87,652        3,135      3.3
D        576    .6           69    1.0         87,648        3,135      3.3
D        672    .7           81    1.0         87,645        3,135      3.3
D        768    .8           92    1.0         87,645        3,135      3.3
D        864    .8          104    1.0         87,645        3,135      3.3
D        960    .9          115    1.0         87,645        3,135      3.3
D      1,024   1.0          123    1.0         87,643        3,135      3.3
D      1,056   1.0          127    1.0         87,642        3,135      3.3
D      1,152   1.1          138    1.0         87,640        3,135      3.3
D      1,248   1.2          150    1.0         87,640        3,135      3.3
D      1,344   1.3          161    1.0         87,640        3,135      3.3
D      1,440   1.4          173    1.0         87,638        3,134      3.3
D      1,536   1.5          184    1.0         87,637        3,134      3.3
D      1,632   1.6          196    1.0         87,637        3,134      3.3
D      1,728   1.7          207    1.0         87,637        3,134      3.3
D      1,824   1.8          219    1.0         87,305        3,113      3.3
D      1,920   1.9          230    1.0         83,690        2,880      3.0
          -------------------------------------------------------------

Buffer wait Statistics  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> ordered by wait time desc, waits desc

Class                        Waits Total Wait Time (s) Avg Time (ms)
---------------------- ----------- ------------------- -------------
data block                  72,940                 177             2
          -------------------------------------------------------------
PGA Aggr Target Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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
--------------- ---------------- -------------------------
          100.0              105                         0

                                             %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     1,024       842      193.6        0.0     .0     .0     .0    104,850
E     1,024       836      198.6        0.0     .0     .0     .0    104,850
          -------------------------------------------------------------

PGA Aggr Target Histogram  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Optimal Executions are purely in-memory operations

    Low    High
Optimal Optimal    Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
     2K      4K            407           407            0            0
    64K    128K             12            12            0            0
   128K    256K              2             2            0            0
   512K   1024K            107           107            0            0
     1M      2M              8             8            0            0
     2M      4M              2             2            0            0
          -------------------------------------------------------------

PGA Memory Advisory  DB/Inst: ARIEPDB/ariepdb1  End Snap: 3
-> 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
---------- ------- ---------------- ---------------- -------- ----------
       128     0.1         16,126.3          1,855.1     90.0         56
       256     0.3         16,126.3          1,432.8     92.0          0
       512     0.5         16,126.3          1,432.8     92.0          0
       768     0.8         16,126.3          1,432.8     92.0          0
     1,024     1.0         16,126.3          1,432.8     92.0          0
     1,229     1.2         16,126.3          1,432.8     92.0          0
     1,434     1.4         16,126.3          1,432.8     92.0          0
     1,638     1.6         16,126.3          1,432.8     92.0          0
     1,843     1.8         16,126.3          1,432.8     92.0          0
     2,048     2.0         16,126.3          1,432.8     92.0          0
     3,072     3.0         16,126.3          1,432.8     92.0          0
     4,096     4.0         16,126.3          1,432.8     92.0          0
     6,144     6.0         16,126.3          1,432.8     92.0          0
     8,192     8.0         16,126.3          1,432.8     92.0          0
          -------------------------------------------------------------
Process Memory Summary Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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 --------     193.6      91.5     18.4      6.7     8.2      22     22     29
  Other        173.9                         6.0     8.5      22     22     29
  Freeable      18.4        .0               1.2     1.4       6            15
  SQL             .8        .5                .1      .0       0     18     12
  PL/SQL          .5        .2                .0      .0       0      0     25
E --------     198.6      94.8     20.6      6.4     8.0      22     22     31
  Other        176.5                         5.7     8.3      22     22     31
  Freeable      20.6        .0               1.2     1.3       6            17
  SQL             .9        .5                .1      .0       0     18     14
  PL/SQL          .6        .3                .0      .0       0      0     27
          -------------------------------------------------------------

Top Process Memory (by component)  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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 LMS0 --------    22.2    10.5       .0       22.2       22.2
         Other            22.2                        22.2       22.2
         PL/SQL             .0      .0                  .0         .0
       8 LMS1 --------    22.2    10.5       .0       22.2       22.2
         Other            22.2                        22.2       22.2
         PL/SQL             .0      .0                  .0         .0
      11 LGWR --------    22.0    10.4       .0       22.0       22.0
         Other            22.0                        22.0       22.0
         PL/SQL             .0      .0                  .0         .0
      22 ARC0 --------    21.9    10.4       .0       21.9       21.9
         Other            21.9                        21.9       21.9
         PL/SQL             .0      .0                  .0         .0
      23 ARC1 --------    21.9    10.4       .0       21.9       21.9
         Other            21.9                        21.9       21.9
         PL/SQL             .0      .0                  .0         .0
       6 LMD0 --------    21.6    10.2       .0       21.6       21.6
         Other            21.6                        21.6       21.6
         PL/SQL             .0      .0                  .0         .0
      20 LCK0 --------     8.2     4.1       .0        8.2        8.2
         Other             8.2                         8.2        8.2
         PL/SQL             .0      .0                  .0         .0
      13 SMON --------     7.0      .6      6.2        7.0       13.0
         Freeable          6.2      .0                 6.2
         Other              .8                          .8        5.5
         SQL                .0      .0                  .0        1.3
         PL/SQL             .0      .0                  .0         .0
       5 LMON --------     5.6     2.7       .1        5.6        5.6
         Other             5.5                         5.5        5.5
         Freeable           .1      .0                  .1
         PL/SQL             .0      .0                  .0         .0
      21 TNS V1-V3 ---     5.6     3.4       .6        5.6        5.6
         Other             4.8                         4.8        4.8
         Freeable           .6      .0                  .6
         SQL                .1      .1                  .1        1.4
         PL/SQL             .0      .0                  .0         .0
      17  ------------     4.6     3.4      1.0        4.6        6.7
         Other             3.4                         3.4        3.4
         Freeable          1.0      .0                 1.0
         SQL                .1      .1                  .1        3.3
         PL/SQL             .1      .0                  .1         .1
      16  ------------     4.1     2.8      1.0        4.1       20.4
         Other             2.9                         2.9        2.9
         Freeable          1.0      .0                 1.0
         SQL                .1      .1                  .1       18.1
         PL/SQL             .1      .0                  .1         .1
      26  ------------     4.1     3.1       .9        4.1        6.6
         Other             3.0                         3.0        3.0
         Freeable           .9      .0                  .9
         SQL                .1      .1                  .1        4.2
         PL/SQL             .1      .0                  .1         .1
      38  ------------     2.6     1.5       .8        2.6        7.4
         Other             1.8                         1.8        1.8
         Freeable           .8      .0                  .8

Top Process Memory (by component)  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B     38 SQL                .1      .0                  .1        5.7
         PL/SQL             .0      .0                  .0         .0
      12 CKPT --------     2.4      .4      1.5        2.4        3.8
         Freeable          1.5      .0                 1.5
         Other              .8                          .8        2.2
         SQL                .0      .0                  .0         .1
         PL/SQL             .0      .0                  .0         .0
      10 DBW0 --------     2.3      .4      1.5        2.3        3.8
         Freeable          1.5      .0                 1.5
         Other              .8                          .8        2.3
         PL/SQL             .0      .0                  .0         .0
      27  ------------     2.3     1.6       .8        2.3        3.6
         Other             1.4                         1.4        1.4
         Freeable           .8      .0                  .8
         PL/SQL             .1      .0                  .1         .1
         SQL                .0      .0                  .0        2.4
      15  ------------     1.9      .6      1.0        1.9        2.5
         Freeable          1.0      .0                 1.0
         Other              .8                          .8         .8
         SQL                .1      .0                  .1        1.6
         PL/SQL             .0      .0                  .0         .0
      24  ------------     1.7      .4      1.1        1.7        1.7
         Freeable          1.1      .0                 1.1
         Other              .6                          .6         .6
         SQL                .0      .0                  .0         .7
         PL/SQL             .0      .0                  .0         .0
      29 PZ98 --------     1.4      .0       .8        1.4        1.4
         Freeable           .8      .0                  .8
         Other              .6                          .6         .6
         SQL                .0      .0                  .0         .9
         PL/SQL             .0      .0                  .0         .0
E      7 LMS0 --------    22.2    10.5       .0       22.2       22.2
         Other            22.2                        22.2       22.2
         PL/SQL             .0      .0                  .0         .0
       8 LMS1 --------    22.2    10.5       .0       22.2       22.2
         Other            22.2                        22.2       22.2
         PL/SQL             .0      .0                  .0         .0
      11 LGWR --------    22.0    10.4       .0       22.0       22.0
         Other            22.0                        22.0       22.0
         PL/SQL             .0      .0                  .0         .0
      22 ARC0 --------    21.9    10.4       .0       21.9       21.9
         Other            21.9                        21.9       21.9
         PL/SQL             .0      .0                  .0         .0
      23 ARC1 --------    21.9    10.4       .0       21.9       21.9
         Other            21.9                        21.9       21.9
         PL/SQL             .0      .0                  .0         .0
       6 LMD0 --------    21.6    10.2       .0       21.6       21.6
         Other            21.6                        21.6       21.6
         PL/SQL             .0      .0                  .0         .0
      20 LCK0 --------     8.2     4.2       .0        8.2        8.2
         Other             8.2                         8.2        8.2
         PL/SQL             .0      .0                  .0         .0
      13 SMON --------     7.0      .6      6.1        7.0       13.0

Top Process Memory (by component)  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E     13 Freeable          6.1      .0                 6.1
         Other              .9                          .9        5.6
         SQL                .0      .0                  .0        1.3
         PL/SQL             .0      .0                  .0         .0
      21 TNS V1-V3 ---     5.8     3.9      1.0        5.8       10.3
         Other             4.6                         4.6        6.6
         Freeable          1.0      .0                 1.0
         SQL                .1      .1                  .1        2.7
         PL/SQL             .0      .0                  .0         .0
       5 LMON --------     5.6     2.7       .1        5.6        5.6
         Other             5.5                         5.5        5.5
         Freeable           .1      .0                  .1
         PL/SQL             .0      .0                  .0         .0
      17  ------------     4.6     3.4      1.1        4.6        6.7
         Other             3.3                         3.3        3.3
         Freeable          1.1      .0                 1.1
         SQL                .1      .1                  .1        3.3
         PL/SQL             .1      .0                  .1         .1
      16  ------------     4.2     2.8      1.1        4.2       20.4
         Other             2.9                         2.9        2.9
         Freeable          1.1      .0                 1.1
         SQL                .1      .1                  .1       18.1
         PL/SQL             .1      .0                  .1         .1
      26  ------------     4.1     3.2      1.0        4.1        6.6
         Other             2.9                         2.9        2.9
         Freeable          1.0      .0                 1.0
         SQL                .1      .1                  .1        4.2
         PL/SQL             .1      .0                  .1         .1
      24  ------------     3.3     1.4      1.0        3.3        3.3
         Other             2.2                         2.2        2.2
         Freeable          1.0      .0                 1.0
         SQL                .1      .0                  .1        1.6
         PL/SQL             .0      .0                  .0         .0
      38  ------------     2.6     1.5       .8        2.6        7.4
         Other             1.8                         1.8        1.8
         Freeable           .8      .0                  .8
         SQL                .1      .0                  .1        5.7
         PL/SQL             .0      .0                  .0         .0
      10 DBW0 --------     2.3      .4      1.5        2.3        3.8
         Freeable          1.5      .0                 1.5
         Other              .8                          .8        2.3
         PL/SQL             .0      .0                  .0         .0
      27  ------------     2.3     1.6       .8        2.3        3.6
         Other             1.4                         1.4        1.4
         Freeable           .8      .0                  .8
         PL/SQL             .1      .0                  .1         .1
         SQL                .0      .0                  .0        2.4
      12 CKPT --------     2.2      .4      1.6        2.2        3.8
         Freeable          1.6      .0                 1.6
         Other              .6                          .6        2.1
         SQL                .0      .0                  .0         .1
         PL/SQL             .0      .0                  .0         .0
      25  ------------     1.9      .7      1.0        1.9        3.2

Top Process Memory (by component)  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E     25 Freeable          1.0      .0                 1.0
         Other              .9                          .9         .9
         PL/SQL             .0      .0                  .0         .3
         SQL                .0      .0                  .0        2.5
      15  ------------     1.9      .6      1.0        1.9        2.5
         Freeable          1.0      .0                 1.0
         Other              .8                          .8         .8
         SQL                .1      .0                  .1        1.6
         PL/SQL             .0      .0                  .0         .0
          -------------------------------------------------------------
Enqueue activity  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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)
------------ ------------ ----------- ----------- ------------ --------------
TM-DML
       6,132        6,132           0         204            0            .42
US-Undo Segment
         230          230           0         219            0            .27
PS-PX Process Reservation
          46           46           0          46            0            .41
HW-Segment High Water Mark
          58           58           0          53            0            .26
CF-Controlfile Transaction
       6,792        6,792           0          14            0            .50
TA-Instance Undo
          10           10           0          10            0            .20
FB-Format Block
          75           75           0           6            0            .33
PI-Remote PX Process Spawn Status
           1            1           0           1            0           1.00
TT-Tablespace
           5            5           0           2            0            .00
          -------------------------------------------------------------

Latch Activity  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->"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               1,962    0.0             0            0
Consistent RBA                      449    0.0             0            0
FAL request queue                    59    0.0             0            0
FAL subheap alocation                59    0.0             0            0
FOB s.o list latch                   14    0.0             0            0
KCL gc element parent la     41,471,352    0.0    0.0      0           14    0.0
KJC message pool free li      1,067,924    0.0    0.0      0      207,946    0.0
KJCT flow control latch       6,008,739    0.0    0.0      0            0
KMG MMAN ready and start            975    0.0             0            0
KPON ksr channel latch              585    0.0             0            0
KTF sga latch                        10    0.0             0          947    0.0
KWQMN job cache list lat              8    0.0             0            0
KWQP Prop Status                      2    0.0             0            0
MQL Tracking Latch                    0                    0           10   20.0
Memory Management Latch               0                    0          975    0.0
OS process                           15    0.0             0            0
OS process allocation               986    0.0             0            0
OS process: request allo              8    0.0             0            0
PL/SQL warning settings              87    0.0             0            0
SGA IO buffer pool latch        220,241    0.0    0.0      0      220,241    0.0
SQL memory manager latch              2    0.0             0          974    0.0
SQL memory manager worka         65,976    0.0             0            0
Shared B-Tree                         6    0.0             0            0
active checkpoint queue           2,772    0.0             0            0
active service list                 384    0.0             0          979    0.0
archive control                      49    0.0             0            0
archive process latch             1,033    0.0             0            0
cache buffer handles              1,556    0.0             0            0
cache buffers chains         43,039,066    0.8    0.0      0   19,535,005    0.0
cache buffers lru chain       9,866,360    0.2    0.0      0   14,429,738    2.8
cache table scan latch                0                    0      228,243    0.0
channel anchor                    1,170    0.0             0            0
channel handle pool latc              8    0.0             0            0
channel operations paren         78,846    0.0             0            0
checkpoint queue latch           29,834    0.0             0        2,334    0.0
client/application info             268    0.0             0            0
commit callback allocati             16    0.0             0            0
compile environment latc            766    0.0             0            0
dml lock allocation              11,981    0.0             0            0
dummy allocation                     98    0.0             0            0
enqueue hash chains              41,426    0.0             0            0
enqueues                         15,514    0.0             0            0
event group latch                     5    0.0             0            0
file cache latch                    124    0.0             0            0
gcs opaque info freelist      2,390,258    0.0    0.0      0            0
gcs partitioned table ha     53,664,372    0.0    0.0      0            0
gcs remaster request que             16    0.0             0            0
gcs remastering latch                50    0.0             0            0
gcs resource freelist         7,552,386    0.0    0.0      0          304    0.0
gcs resource hash            26,833,024    0.0    0.0      0            0
Latch Activity  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
gcs shadows freelist              1,704    0.0             0        1,753    0.0
ges caches resource list          5,530    0.1    0.0      0       31,291    0.0
ges deadlock list                   888    0.0             0            2    0.0
ges domain table                 19,218    0.0             0            0
ges enqueue table freeli         20,129    0.0             0            0
ges group table                  24,642    0.0             0            0
ges process hash list             1,309    0.0             0            0
ges process parent latch         39,258    0.0             0            0
ges process table freeli              8    0.0             0            0
ges resource hash list           26,878    0.0    0.0      0        2,018    0.0
ges resource scan list               58    0.0             0            0
ges resource table freel          3,019    0.0             0            0
ges timeout list                    962    0.0             0          728    0.0
global KZLD latch for me              4    0.0             0            0
hash table column usage             323    0.0             0       12,276    0.0
hash table modification              74    0.0             0            0
kks stats                           140    0.0             0            0
ksuosstats global area                4    0.0             0            0
ktm global data                      10    0.0             0            0
kwqbsn:qsga                           6    0.0             0            0
lgwr LWN SCN                      1,290    0.0             0            0
library cache                    35,548    0.0    0.0      0            0
library cache load lock             148    0.0             0            0
library cache lock               13,324    0.0             0            0
library cache lock alloc            249    0.0             0            0
library cache pin                11,132    0.0             0            0
library cache pin alloca            141    0.0             0            0
list of block allocation             78    0.0             0            0
message pool operations             440    0.0             0            0
messages                         79,210    0.0    0.0      0            0
mostly latch-free SCN             1,292    0.1    0.0      0            0
multiblock read objects         640,868    0.0    0.0      0            0
name-service memory obje          1,836    0.0             0            0
name-service namespace b         29,157    0.0             0            0
name-service pending que          1,474    0.0             0            0
name-service request                  6    0.0             0            0
name-service request que         30,760    0.0             0            0
ncodef allocation latch              47    0.0             0            0
object queue header heap          2,781    0.0             0            6    0.0
object queue header oper     19,636,653    0.0    0.0      0            0
object stats modificatio          1,340    0.0             0            0
parallel query alloc buf            708    0.0             0            0
parallel query stats                 45    0.0             0            0
parallel txn reco latch             230    0.0             0            0
parameter list                       36    0.0             0            0
parameter table allocati             49    0.0             0            0
post/wait queue                     118    0.0             0           51    0.0
process allocation               28,248    0.0             0            5    0.0
process group creation                8    0.0             0            0
process queue                       137    0.0             0            0
Latch Activity  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
process queue reference           3,260    0.0             0          287    0.0
query server freelists               92    0.0             0            0
query server process                  1    0.0             0            1    0.0
queued dump request              14,613    0.0             0            0
redo allocation                   3,030    0.0             0       25,030    0.0
redo copy                             0                    0       25,031    0.0
redo writing                      6,166    0.0             0            0
resmgr group change latc             52    0.0             0            0
resmgr:actses active lis            100    0.0             0            0
resmgr:actses change gro             49    0.0             0            0
resmgr:free threads list             98    0.0             0            0
resmgr:schema config                  2    0.0             0            0
row cache objects                42,964    0.0             0            0
rules engine rule set st            200    0.0             0            0
sequence cache                      234    0.0             0            0
session allocation               25,660    0.0             0            0
session idle bit                 14,944    0.1    0.0      0            0
session state list latch            115    0.0             0            0
session switching                    47    0.0             0            0
session timer                       979    0.0             0            0
shared pool                     451,687    0.0    0.0      0            0
shared pool sim alloc                 2    0.0             0            0
shared pool simulator             1,440    0.0             0            0
simulator hash latch          4,093,314    0.0    0.0      0            0
simulator lru latch           1,876,932    2.4    0.0      0      613,604    0.0
sort extent pool                     74    0.0             0            0
transaction allocation           65,455    0.0             0            0
transaction branch alloc             47    0.0             0            0
undo global data                  2,837    0.0             0            0
user lock                            14    0.0             0            0
          -------------------------------------------------------------
Latch Sleep breakdown  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> ordered by misses desc

                                       Get                                 Spin
Latch Name                        Requests       Misses      Sleeps        Gets
-------------------------- --------------- ------------ ----------- -----------
cache buffers chains            43,039,066      361,779         348     361,433
simulator lru latch              1,876,932       45,704           1      45,703
cache buffers lru chain          9,866,360       18,017           9      18,009
gcs resource hash               26,833,024        1,550           3       1,547
KCL gc element parent latc      41,471,352        1,371           4       1,367
gcs resource freelist            7,552,386          124           1         123
          -------------------------------------------------------------
Latch Miss Sources  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
KCL gc element parent la kclnfndnewm                      0          3        0
KCL gc element parent la kclplz                           0          1        4
KCL gc element parent la kclulb                           0          1        1
cache buffers chains     kcbgtcr: kslbegin excl           0     11,971   11,952
cache buffers chains     kcbrls: kslbegin                 0        213      289
cache buffers chains     kcbzwb                           0         39        3
cache buffers chains     kcbzib: finish free bufs         0         17        0
cache buffers chains     kcbzgb: scan from tail. no       0          2        0
cache buffers chains     kcbzib: multi-block read:        0          2        0
cache buffers lru chain  kcbzgws_1                        0          9        6
gcs resource freelist    kjbralc add resource             0          1        0
gcs resource hash        kjbassume                        0          2        0
gcs resource hash        kjbcropen:affinity               0          1        0
simulator lru latch      kcbs_simulate: simulate se       0          1        1
          -------------------------------------------------------------
Segments by Logical Reads  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Segment Logical Reads Threshold:     10000
-> Pct Total shows % of logical reads for each top segment compared with total
   logical reads for all segments captured by the Snapshot

                                           Subobject    Obj.       Logical   Pct
Owner      Tablespace Object Name          Name         Type         Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
IFACTS_U2  USERS      ALERT                             TABLE   14,466,992  94.3
SYS        SYSAUX     SYS_IOT_TOP_8833                  INDEX      496,384   3.2
PERFSTAT   STATSPACK  STATS$SQL_PLAN                    TABLE      159,376   1.0
IFACTS_U2  USERS      BENEFICIARY                       TABLE       99,216    .6
IFACTS_U2  USERS      TASK                              TABLE       24,144    .2
          -------------------------------------------------------------


Segments by Physical Reads  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Segment Physical Reads Threshold:      1000

                                           Subobject    Obj.      Physical   Pct
Owner      Tablespace Object Name          Name         Type         Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
IFACTS_U2  USERS      ALERT                             TABLE    7,275,837  98.7
IFACTS_U2  USERS      BENEFICIARY                       TABLE       98,365   1.3
SYS        SYSTEM     HIST_HEAD$                        TABLE            1    .0
          -------------------------------------------------------------
Segments by Global Cache Buffer Busy Waits  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-
-> There is no specific Threshold for Segment GC Buffer Busy Waits

                                                                 GC Buffer
                                           Subobject    Obj.          Busy   Pct
Owner      Tablespace Object Name          Name         Type         Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
IFACTS_U2  USERS      ALERT                             TABLE       72,282 100.0
          -------------------------------------------------------------


Segments by CR Blocks Received  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Global Cache CR Blocks Received Threshold:      1000

                                                                        CR
                                           Subobject    Obj.        Blocks   Pct
Owner      Tablespace Object Name          Name         Type        Recevd Total
---------- ---------- -------------------- ------------ ----- ------------ -----
IFACTS_U2  USERS      ALERT                             TABLE          485  73.7
SYS        SYSTEM     SMON_SCN_TIME                     TABLE           31   4.7
SYS        SYSAUX     SYS_IOT_TOP_8833                  INDEX           24   3.6
SYS        SYSTEM     SEG$                              TABLE           23   3.5
SYS        SYSTEM     USER$                             TABLE           14   2.1
          -------------------------------------------------------------


Segments By Current Blocks Received  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> End Global Cache CU Blocks Received Threshold:      1000

                                                                        CU
                                           Subobject    Obj.        Blocks   Pct
Owner      Tablespace Object Name          Name         Type        Recevd Total
---------- ---------- -------------------- ------------ ----- ------------ -----
IFACTS_U2  USERS      ALERT                             TABLE    2,397,426 100.0
SYS        SYSTEM     COL_USAGE$                        TABLE           19    .0
IFACTS_U2  IFACTSTEST SEQ_NUMBER_AT                     TABLE           13    .0
SYS        SYSAUX     SYS_IOT_TOP_8833                  INDEX            8    .0
SYS        SYSTEM     SMON_SCN_TIME                     TABLE            8    .0
          -------------------------------------------------------------
Dictionary Cache Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->"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_global_oids                      44    0.0       0              0        199
dc_histogram_data                1,073    0.0       0              0     11,144
dc_histogram_defs                2,578   20.6       0              0     21,573
dc_object_ids                    1,599    0.0       0              0      3,793
dc_objects                         911    0.0       0              0      3,994
dc_profiles                          4    0.0       0              0          2
dc_rollback_segments               494    0.0       0              0         25
dc_segments                        745    0.0       0              0      3,167
dc_sequences                         4   25.0       0              4         96
dc_tablespaces                   2,555    0.0       0              0          8
dc_usernames                       597    0.0       0              0         44
dc_users                         3,832    0.0       0              0         59
          -------------------------------------------------------------


                                   GES          GES          GES
Cache                         Requests    Conflicts     Releases
------------------------- ------------ ------------ ------------
dc_histogram_defs                  531            0            0
dc_sequences                         8            1            0
          -------------------------------------------------------------


Library Cache Activity  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
->"Pct Misses"  should be very low

                         Get  Pct        Pin        Pct               Invali-
Namespace           Requests  Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
SQL AREA                  22  100.0          6,292    4.3          5        0
TABLE/PROCEDURE          756    0.0          2,849    3.5         52        0
BODY                      25    0.0             53    0.0          0        0
TRIGGER                   16    0.0             37    0.0          0        0
CLUSTER                    5    0.0              5    0.0          0        0
          -------------------------------------------------------------


                    GES Lock      GES Pin      GES Pin   GES Inval GES Invali-
Namespace           Requests     Requests     Releases    Requests     dations
--------------- ------------ ------------ ------------ ----------- -----------
SQL AREA                   0            0            0           0           0
TABLE/PROCEDURE        1,710            0            0           0           0
BODY                       0            0            0           0           0
TRIGGER                    0            0            0           0           0
CLUSTER                    5            0            0           0           0
          -------------------------------------------------------------
Global Enqueue Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
acks for commit broadcast(actual)            9,430          3.2        145.1
acks for commit broadcast(logical           10,099          3.5        155.4
broadcast msgs on commit(actual)               449          0.2          6.9
broadcast msgs on commit(logical)              449          0.2          6.9
broadcast msgs on commit(wasted)                50          0.0          0.8
dynamically allocated gcs resourc                0          0.0          0.0
dynamically allocated gcs shadows                0          0.0          0.0
false posts waiting for scn acks                 0          0.0          0.0
flow control messages received                   0          0.0          0.0
flow control messages sent                       0          0.0          0.0
gcs assume cvt                                   0          0.0          0.0
gcs assume no cvt                            1,468          0.5         22.6
gcs ast xid                                      0          0.0          0.0
gcs blocked converts                           139          0.0          2.1
gcs blocked cr converts                        533          0.2          8.2
gcs compatible basts                             0          0.0          0.0
gcs compatible cr basts (global)               983          0.3         15.1
gcs compatible cr basts (local)          1,194,022        408.5     18,369.6
gcs cr basts to PIs                              0          0.0          0.0
gcs cr serve without current lock                0          0.0          0.0
gcs dbwr flush pi msgs                          50          0.0          0.8
gcs dbwr write request msgs                     30          0.0          0.5
gcs error msgs                                   0          0.0          0.0
gcs forward cr to pinged instance                0          0.0          0.0
gcs immediate (compatible) conver                6          0.0          0.1
gcs immediate (null) converts                  628          0.2          9.7
gcs immediate cr (compatible) con                0          0.0          0.0
gcs immediate cr (null) converts         3,776,321      1,291.9     58,097.2
gcs indirect ast                               704          0.2         10.8
gcs lms flush pi msgs                            0          0.0          0.0
gcs lms write request msgs                      49          0.0          0.8
gcs msgs process time(ms)                   15,900          5.4        244.6
gcs msgs received                        3,630,261      1,242.0     55,850.2
gcs out-of-order msgs                            0          0.0          0.0
gcs pings refused                                0          0.0          0.0
gcs pkey conflicts retry                         0          0.0          0.0
gcs queued converts                              0          0.0          0.0
gcs recovery claim msgs                          0          0.0          0.0
gcs refuse xid                                   0          0.0          0.0
gcs regular cr                                   0          0.0          0.0
gcs retry convert request                        0          0.0          0.0
gcs side channel msgs actual                12,277          4.2        188.9
gcs side channel msgs logical            2,411,249        824.9     37,096.1
gcs stale cr                                     0          0.0          0.0
gcs undo cr                                      0          0.0          0.0
gcs write notification msgs                      0          0.0          0.0
gcs writes refused                               0          0.0          0.0
ges msgs process time(ms)                       21          0.0          0.3
ges msgs received                            2,093          0.7         32.2
global posts dropped                             0          0.0          0.0
global posts queue time                          0          0.0          0.0
global posts queued                              0          0.0          0.0
global posts requested                           0          0.0          0.0
global posts sent                                0          0.0          0.0
implicit batch messages received             4,403          1.5         67.7
implicit batch messages sent               215,429         73.7      3,314.3
Global Enqueue Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
lmd msg send time(ms)                            0          0.0          0.0
lms(s) msg send time(ms)                         0          0.0          0.0
messages flow controlled                       896          0.3         13.8
messages queue sent actual                 242,135         82.8      3,725.2
messages queue sent logical              4,818,859      1,648.6     74,136.3
messages received actual                   448,170        153.3      6,894.9
messages received logical                3,632,351      1,242.7     55,882.3
messages sent directly                       2,895          1.0         44.5
messages sent indirectly                 4,816,853      1,647.9     74,105.4
messages sent not implicit batche           26,707          9.1        410.9
messages sent pbatched                   6,019,068      2,059.2     92,601.0
msgs causing lmd to send msgs                  655          0.2         10.1
msgs causing lms(s) to send msgs             9,618          3.3        148.0
msgs received queue time (ms)                1,882          0.6         29.0
msgs received queued                     3,632,353      1,242.7     55,882.4
msgs sent queue time (ms)                  383,349        131.1      5,897.7
msgs sent queue time on ksxp (ms)          243,000         83.1      3,738.5
msgs sent queued                         4,818,806      1,648.6     74,135.5
msgs sent queued on ksxp                   859,217        294.0     13,218.7
process batch messages received            425,055        145.4      6,539.3
process batch messages sent                615,720        210.6      9,472.6
          -------------------------------------------------------------
Global CR Served Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

Statistic                                   Total
------------------------------ ------------------
CR Block Requests                             351
CURRENT Block Requests                         14
Data Block Requests                           351
Undo Block Requests                             0
TX Block Requests                               2
Current Results                               365
Private results                                 0
Zero Results                                    0
Disk Read Results                               0
Fail Results                                    0
Fairness Down Converts                         61
Fairness Clears                                 0
Free GC Elements                                0
Flushes                                         0
Flushes Queued                                  0
Flush Queue Full                                0
Flush Max Time (us)                             0
Light Works                                     0
Errors                                          0
          -------------------------------------------------------------


Global CURRENT Served Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Pins    = CURRENT Block Pin Operations
-> Flushes = Redo Flush before CURRENT Block Served Operations
-> Writes  = CURRENT Block Fusion Write Operations

Statistic         Total   % <1ms  % <10ms % <100ms    % <1s   % <10s
----------- ----------- -------- -------- -------- -------- --------
Pins              2,632   100.00                     0.00
    0.00                     0.00                     0.00
Flushes               0     0.00                     0.00
    0.00                     0.00                     0.00
Writes               64    56.25                    34.38
    9.38                     0.00                     0.00
          -------------------------------------------------------------


Global Cache Transfer Stats  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> Immediate  (Immed) - Block Transfer NOT impacted by Remote Processing Delays
   Busy        (Busy) - Block Transfer impacted by Remote Contention
   Congested (Congst) - Block Transfer impacted by Remote System Load
-> ordered by CR + Current Blocks Received desc

              -------------- CR -------------  ----------- Current -----------
Inst Block         Blocks      %      %      %      Blocks      %      %      %
  No Class       Received  Immed   Busy Congst    Received  Immed   Busy Congst
---- -------- ----------- ------ ------ ------ ----------- ------ ------ ------
   2 data blo         658   97.3    2.7     .0   2,406,801  100.0     .0     .0
   2 others            20  100.0     .0     .0          11  100.0     .0     .0
          -------------------------------------------------------------
Rule Sets  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> * 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: ARIEPDB/ariepdb1  End Snap: 3
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       352    .3      133        9,249 #######    1.0   4,819   17.8   6,075,420
       464    .5      241       12,650 #######    1.0     275    1.0   6,081,957
       576    .6      352       16,481 #######    1.0     270    1.0   6,082,779
       688    .7      466       22,659 #######    1.0     270    1.0   6,082,996
       800    .8      466       22,659 #######    1.0     270    1.0   6,082,996
       912    .9      466       22,659 #######    1.0     270    1.0   6,082,996
     1,024   1.0      466       22,659 #######    1.0     270    1.0   6,082,996
     1,136   1.1      466       22,659 #######    1.0     270    1.0   6,082,996
     1,248   1.2      466       22,659 #######    1.0     270    1.0   6,082,996
     1,360   1.3      466       22,659 #######    1.0     270    1.0   6,082,996
     1,472   1.4      466       22,659 #######    1.0     270    1.0   6,082,996
     1,584   1.5      466       22,659 #######    1.0     270    1.0   6,082,996
     1,696   1.7      466       22,659 #######    1.0     270    1.0   6,082,996
     1,808   1.8      466       22,659 #######    1.0     270    1.0   6,082,996
     1,920   1.9      466       22,659 #######    1.0     270    1.0   6,082,996
     2,032   2.0      466       22,659 #######    1.0     270    1.0   6,082,996
     2,144   2.1      466       22,659 #######    1.0     270    1.0   6,082,996
          -------------------------------------------------------------
SGA Memory Summary  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

                                                        End Size (Bytes)
SGA regions                      Begin Size (Bytes)       (if different)
------------------------------ -------------------- --------------------
Database Buffers                      1,073,741,824
Fixed Size                                2,074,512
Redo Buffers                             14,700,544
Variable Size                         1,207,961,712
                               -------------------- --------------------
sum                                   2,298,478,592
          -------------------------------------------------------------


SGA breakdown difference  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3
-> 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                              64.0           64.0     0.00
large  free memory                              64.0           64.0     0.00
shared CCursor                                  44.2           44.6     0.90
shared KGLS heap                                26.9           27.0     0.28
shared KQR L PO                                 31.4           31.9     1.63
shared PCursor                                  24.3           24.6     1.13
shared PL/SQL DIANA                             11.4           11.4     0.00
shared free memory                             357.3          352.4    -1.36
shared gcs resources                            20.4           20.4     0.00
shared gcs shadows                              12.9           12.9     0.00
shared ges big msg buffers                      13.8           13.8     0.00
shared ges enqueues                             11.3           11.3     0.00
shared ges resource                             14.0           14.1     0.94
shared library cache                            26.6           26.7     0.28
shared sql area                                300.1          303.3     1.08
       buffer_cache                          1,024.0        1,024.0     0.00
       fixed_sga                                 2.0            2.0     0.00
       log_buffer                               14.0           14.0     0.00
          -------------------------------------------------------------
SQL Memory Statistics  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

                                   Begin            End         % Diff
                          -------------- -------------- --------------
   Avg Cursor Size (KB):           36.38          36.47            .23
 Cursor to Parent ratio:            1.40           1.40           -.01
          Total Cursors:           9,453          9,498            .47
          Total Parents:           6,751          6,784            .49
          -------------------------------------------------------------
init.ora Parameters  DB/Inst: ARIEPDB/ariepdb1  Snaps: 1-3

                                                                  End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
audit_file_dest               /opt/oracle/app/oracle/admin/arie
background_dump_dest          /opt/oracle/app/oracle/admin/arie
cluster_database              TRUE
cluster_database_instances    2
compatible                    10.2.0.3.0
control_files                 /u03/ariepdb/control01.ctl, /u04/
core_dump_dest                /opt/oracle/app/oracle/admin/arie
cpu_count                     2
db_block_size                 8192
db_cache_size                 1073741824
db_create_online_log_dest_1   /u03/ariepdb
db_create_online_log_dest_2   /u04/ariepdb
db_create_online_log_dest_3   /u05/ariepdb
db_create_online_log_dest_4   /u06/ariepdb
db_domain                     arg.internal
db_file_multiblock_read_count 32
db_name                       ariepdb
db_recovery_file_dest         /u09/ariepdb
db_recovery_file_dest_size    2147483648
dispatchers                   (PROTOCOL=TCP) (SERVICE=ariepdbXD
instance_number               1
java_pool_size                67108864
job_queue_processes           10
large_pool_size               67108864
log_archive_dest_1            LOCATION=/u08/ariepdb
log_archive_dest_2            LOCATION=/u09/ariepdb
log_archive_format            redo_%t_%s_%r.arc
nls_language                  AMERICAN
nls_territory                 AMERICA
open_cursors                  300
pga_aggregate_target          1073741824
processes                     500
remote_listener               LISTENERS_ARIEPDB
remote_login_passwordfile     EXCLUSIVE
service_names                 ariepdb.arg.internal
sessions                      555
shared_pool_size              1073741824
sort_area_size                801677937
spfile                        /u01/ariepdb/spfileariepdb.ora
thread                        1
undo_management               AUTO
undo_tablespace               UNDOTBS1
user_dump_dest                /opt/oracle/app/oracle/admin/arie
          -------------------------------------------------------------

End of Report ( ariepdb.txt )

