<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.17 -->
<!-- Module:S110PERF Version:1.39 Report:awr_report OS:linux -->
<verbatim>

WORKLOAD REPOSITORY report for

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
PCARD         1840828064 pcard               1 10.2.0.4.0  NO  rac01.nucleu

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      2831 21-Jun-11 14:00:03       171       5.4
  End Snap:      2832 21-Jun-11 15:00:07       176       5.3
   Elapsed:               60.06 (mins)
   DB Time:                0.60 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:     7,424M     7,424M  Std Block Size:         8K
           Shared Pool Size:     1,504M     1,504M      Log Buffer:    14,332K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:                575.73              3,595.43
              Logical reads:                 96.75                604.19
              Block changes:                  2.48                 15.46
             Physical reads:                  0.02                  0.14
            Physical writes:                  0.32                  2.02
                 User calls:                  7.22                 45.12
                     Parses:                  3.74                 23.34
                Hard parses:                  0.01                  0.06
                      Sorts:                  3.20                 19.98
                     Logons:                  0.08                  0.50
                   Executes:                 10.97                 68.48
               Transactions:                  0.16

  % Blocks changed per Read:    2.56    Recursive Call %:    80.25
 Rollback per transaction %:    5.20       Rows per Sort:    20.86

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:  100.00    In-memory Sort %:  100.00
            Library Hit   %:  100.97        Soft Parse %:   99.75
         Execute to Parse %:   65.91         Latch Hit %:   99.66
Parse CPU to Parse Elapsd %:   89.19     % Non-Parse CPU:   95.99

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   82.66   82.82
    % SQL with executions>1:   99.35   99.24
  % Memory for SQL w/exec>1:   96.76   96.27

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
control file sequential read         16,772          43      3  121.6 System I/O
CPU time                                             16          46.1
control file parallel write           1,347           9      6   24.2 System I/O
SQL*Net break/reset to client            67           4     59   11.0 Applicatio
log file parallel write                 607           2      4    6.9 System I/O
          -------------------------------------------------------------
Time Model Statistics                  DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Total time in database user-calls (DB Time): 35.7s
-> Statistics including the word "background" measure background process
   time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name

Statistic Name                                       Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time                                 27.2         76.2
DB CPU                                                   16.5         46.1
PL/SQL execution elapsed time                             6.2         17.5
inbound PL/SQL rpc elapsed time                           5.7         16.0
parse time elapsed                                        0.7          2.0
connection management call elapsed time                   0.7          2.0
RMAN cpu time (backup/restore)                            0.5          1.3
hard parse elapsed time                                   0.3           .7
hard parse (sharing criteria) elapsed time                0.0           .1
failed parse elapsed time                                 0.0           .1
repeated bind elapsed time                                0.0           .0
DB time                                                  35.7          N/A
background elapsed time                                  63.4          N/A
background cpu time                                      10.3          N/A
          -------------------------------------------------------------

Wait Class                              DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc

                                                                  Avg
                                       %Time       Total Wait    wait     Waits
Wait Class                      Waits  -outs         Time (s)    (ms)      /txn
-------------------- ---------------- ------ ---------------- ------- ---------
System I/O                     18,840     .0               55       3      32.7
Application                        67     .0                4      59       0.1
Network                        26,051     .0                3       0      45.1
User I/O                          374     .0                2       6       0.6
Administrative                      3     .0                2     663       0.0
Commit                            176     .6                1       6       0.3
Other                          35,824   99.9                1       0      62.1
Concurrency                        18     .0                0       2       0.0
          -------------------------------------------------------------

Wait Events                            DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
control file sequential read         16,772     .0          43       3      29.1
control file parallel write           1,347     .0           9       6       2.3
SQL*Net break/reset to clien             67     .0           4      59       0.1
log file parallel write                 607     .0           2       4       1.1
db file sequential read                 236     .0           2      10       0.4
switch logfile command                    3     .0           2     663       0.0
ARCH wait on SENDREQ                      5     .0           2     388       0.0
log file sync                           176     .6           1       6       0.3
SQL*Net more data to client             135     .0           1       7       0.2
RMAN backup & recovery I/O               38     .0           0      12       0.1
Log archive I/O                           7     .0           0      50       0.0
recovery area: computing obs              2     .0           0     151       0.0
CGS wait for IPC msg                 35,801  100.0           0       0      62.0
log file sequential read                 17     .0           0       7       0.0
os thread startup                         2     .0           0      20       0.0
latch free                                3     .0           0      11       0.0
enq: CF - contention                      2     .0           0      15       0.0
control file single write                48     .0           0       1       0.1
SQL*Net message to client            25,858     .0           0       0      44.8
recovery area: computing app              3     .0           0       7       0.0
SQL*Net more data from clien             53     .0           0       0       0.1
log file single write                     4     .0           0       1       0.0
recovery area: computing dro              2     .0           0       1       0.0
recovery area: computing bac              2     .0           0       1       0.0
latch: cache buffers chains              14     .0           0       0       0.0
latch: shared pool                        1     .0           0       0       0.0
LGWR wait for redo copy                   9     .0           0       0       0.0
direct path read                         79     .0           0       0       0.1
latch: library cache                      1     .0           0       0       0.0
direct path write                        59     .0           0       0       0.1
SQL*Net message from client          25,856     .0     108,287    4188      44.8
Streams AQ: qmn slave idle w            385     .0       6,998   18177       0.7
DIAG idle wait                       18,009     .0       3,518     195      31.2
ges remote message                    3,602  100.0       3,517     977       6.2
jobq slave wait                       1,201   95.0       3,516    2928       2.1
virtual circuit status                  144   75.0       3,502   24317       0.2
Streams AQ: qmn coordinator             359   36.2       3,499    9746       0.6
Streams AQ: waiting for time              1  100.0       1,957 #######       0.0
class slave wait                          3     .0           0       0       0.0
          -------------------------------------------------------------

Background Wait Events                 DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
control file sequential read          9,927     .0          27       3      17.2
control file parallel write           1,228     .0           8       6       2.1
log file parallel write                 607     .0           2       4       1.1
ARCH wait on SENDREQ                      5     .0           2     388       0.0
events in waitclass Other            35,812  100.0           0       0      62.1
Log archive I/O                           3     .0           0      67       0.0
os thread startup                         2     .0           0      20       0.0
log file sequential read                 10     .0           0       4       0.0
log file single write                     4     .0           0       1       0.0
direct path read                         79     .0           0       0       0.1
direct path write                        59     .0           0       0       0.1
rdbms ipc message                    49,019   99.1      45,398     926      85.0
Streams AQ: qmn slave idle w            385     .0       6,998   18177       0.7
DIAG idle wait                       18,009     .0       3,518     195      31.2
ges remote message                    3,602  100.0       3,517     977       6.2
pmon timer                            1,230  100.0       3,516    2859       2.1
smon timer                               12  100.0       3,516  293014       0.0
Streams AQ: qmn coordinator             359   36.2       3,499    9746       0.6
Streams AQ: waiting for time              1  100.0       1,957 #######       0.0
          -------------------------------------------------------------

Operating System Statistics             DB/Inst: PCARD/pcard  Snaps: 2831-2832

Statistic                                       Total
-------------------------------- --------------------
BUSY_TIME                                      19,535
IDLE_TIME                                   5,744,508
IOWAIT_TIME                                    10,310
NICE_TIME                                           0
SYS_TIME                                        9,259
USER_TIME                                       9,320
LOAD                                                0
RSRC_MGR_CPU_WAIT_TIME                              0
PHYSICAL_MEMORY_BYTES                  33,746,493,440
NUM_CPUS                                           16
NUM_CPU_SOCKETS                                     2
          -------------------------------------------------------------

Service Statistics                     DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by DB Time

                                                             Physical    Logical
Service Name                      DB Time (s)   DB CPU (s)      Reads      Reads
-------------------------------- ------------ ------------ ---------- ----------
pcard                                    22.8         13.2          0    318,487
SYS$USERS                                12.2          3.2          0     13,629
SYS$BACKGROUND                            0.0          0.0         79     16,242
          -------------------------------------------------------------

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

Service Name
----------------------------------------------------------------
 User I/O  User I/O  Concurcy  Concurcy     Admin     Admin   Network   Network
Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
pcard
        0         0        16         0         0         0     24827        94
SYS$USERS
      177        32         0         0         3       199       572         0
SYS$BACKGROUND
      197       208         2         4         0         0         5       193
          -------------------------------------------------------------

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

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------
         8          1           88        0.1    23.3 98zhjwrkbqwwm
Module: easyagent@rac01.nucleussoftware.com (TNS V1-V3)
 begin dp_monitor.query_
row_count ( rc_query => :rc_query,
 rc_count => :rc_count
 ); end;

         8          0           30        0.3    23.0 24vb3s3db0p28
Module: easyagent@rac01.nucleussoftware.com (TNS V1-V3)
select count(*) from sys.v_$archived_log where standby_dest = :t and applied = :
s

         4          4           26        0.2    11.8 2g6a6h64apf4q
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_P7_ROUTING . LOAD_ISSUER_DATA_ELEMENTS ( :T_tlv_aut
h , :T_international_check , :T_primary_resource , :T_secondary_resource ) ; END
 ;

         3          0            1        2.8     7.7 350myuyx0t1d6
insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname
, contents, status, segment_space_management, extent_management, is_back
up) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname,
 decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', '

         2          1            2        1.1     5.9 7rscr98xqwbrf
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
declare ret boolean ; firstcall boolean ; lbRec dbms_rcvman . lbRec_t := NULL ;
lbCursor dbms_rcvman . lbCursor_t ; begin IF ( :firstcall > 0 ) THEN dbms_rcvman
 . setAllIncarnations ( TRUE ) ; firstcall := TRUE ; ELSE firstcall := FALSE ; E
ND IF ; << loop_1 >> LOOP ret := dbms_rcvman . listBackup ( lbRecOut => lbRec ,

         2          2        5,385        0.0     5.2 8w5st001wrj4q
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;

         2          2           26        0.1     4.7 639dzmsj6hgw8
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND PRODUCT_IDENTIFIER <> 'CIR' AND ROWNUM = 1

         2          2           19        0.1     4.5 ajxn285tk7a6x
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND ROWNUM = 1

         1          1            2        0.6     3.1 0az7czjdw8z7j
 declare lbRec dbms_rcvman.lbRec_t; lbCursor
 dbms_rcvman.lbCursor_t; first boolean := FALSE; re
t boolean; begin if (:first > 0) then fi
rst := TRUE; end if; <<next_row>> ret := dbms_rcvm

         1          0            4        0.3     2.8 a20djcagc6vp4
 declare policy varchar2(512); alldest numbe
r := dbms_rcvman.FALSE#; begin if (:alldest > 0) then
 alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLog
DeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy

         1          0            1        0.9     2.6 d1zgfup6jvgzt
SQL ordered by Elapsed Time            DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------
Module: sqlnavigator.exe
 SELECT transaction_hist.*,ROWID FROM transaction_hist

         1          0            8        0.1     2.5 fa6ra2q90bnvn
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select db.version_time ,db.controlfile_change# ,db.controlfile_sequence# ,dbinc.
resetlogs_time ,df.last_recid ,tf.last_recid ,ts.last_recid ,rl.last_recid ,rm.l
ast_recid ,dc.last_recid ,al.last_recid ,bp.last_recid ,do.last_recid ,offr.last
_recid ,pc.last_recid ,bs.last_recid ,ldbinc.resetlogs_change# ,ldbinc.resetlogs

         1          0            8        0.1     2.4 33y4yxzq1ms0d
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select nvl(max(al.recid),0) into :b1 from v$archived_log al where ((al.status i
n ('X','A') and al.is_recovery_dest_file='YES') and al.creator='RMAN')

         1          0            7        0.1     2.4 gvsj01d3bp10m
SELECT NVL(MAX(AL.FIRST_CHANGE#), 0) FROM V$ARCHIVED_LOG AL, V$DATABASE_INCARNAT
ION DBINC WHERE AL.DEST_ID = :B1 AND AL.STANDBY_DEST = 'YES' AND AL.APPLIED = 'Y
ES' AND AL.RESETLOGS_CHANGE# = DBINC.RESETLOGS_CHANGE# AND AL.RESETLOGS_TIME = D
BINC.RESETLOGS_TIME AND DBINC.STATUS != 'ORPHAN'

         1          0            3        0.3     2.3 c8gw6zzr9n9qn
SELECT /*+ordered*/ FE.FENUM DFNUMBER, FE.FECRC_SCN DFCREATIONSCN, TO_DATE(FE.FE
CRC_TIM,'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNA
M FILENAME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, FE.FESTA STATUS, FH.FHFSZ BLOCKS
, FE.FEBSZ BLOCKSIZE, FH.FHFSZ*FE.FEBSZ/1024 KBYTES, FE.FEURS UNRECOVSCN, DECODE

         1          0            3        0.3     2.3 8cj5tsda0dbz3
SELECT BS.SET_STAMP LIST_ORDER1, 0 LIST_ORDER2, BS.RECID PKEY, :B9 BACKUP_TYPE,
:B9 FILE_TYPE, BS.KEEP KEEP, BS.KEEP_UNTIL KEEP_UNTIL, BS.KEEP_OPTIONS KEEP_OPTI
ONS, NULL STATUS, NULL FNAME, NULL TAG, NULL MEDIA, BS.RECID RECID, BS.STAMP STA
MP, NULL DEVICE_TYPE, BLOCK_SIZE BLOCK_SIZE, BS.COMPLETION_TIME COMPLETION_TIME,

         1          1           19        0.0     2.2 gnxfa97kjgqmd
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM VISA_ARDEF WHERE SUBSTR(:B1 , 1, 9) BETWEEN LOW_KEY_FOR_RANGE AND
HIGH_KEY_FOR_RANGE AND CARD_TYPE != 'A'

         1          0            1        0.7     2.1 7vgmvmy8vvb9s
insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_c
hange#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phy
blkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_num
ber, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.

         1          0            4        0.2     1.9 3dcdrhnkran7p
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select /*+ rule +*/ round(sum(MBYTES_PROCESSED)) ,round(sum(INPUT_BYTES)) ,ro
und(sum(OUTPUT_BYTES)) from V$RMAN_STATUS start with (RECID=:b1 and STAMP=:b2)
 connect by prior RECID=parent_recid

         1          1            1        0.7     1.9 bunssq950snhf
insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi
d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS from v$sga_target_advice

         1          0            3        0.2     1.6 6b5n438mwq1ng
SELECT /*+ordered*/ FENUM DFNUMBER, FECRC_SCN DFCREATIONSCN, TO_DATE(FECRC_TIM,
'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNAM FILENA
ME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, NULL STATUS, FECSZ BLOCKS, FEBSZ BLOCKSI
SQL ordered by Elapsed Time            DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------
ZE, FECSZ * FEBSZ / 1024 KBYTES, NULL UNRECOVSCN, TO_NUMBER(FE.FESTS) STOPSCN, :

         0          0           60        0.0     1.0 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         0          0            3        0.1     1.0 48dhj675nths8
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
declare first boolean := FALSE ; bhistoryRec dbms_rcvman . bhistoryRec_t ; begin
 if ( :first > 0 ) THEN first := TRUE ; end if ; dbms_rcvman . getAlBackupHistor
y ( backedUpDev => :devtype:devtype_i , first => first , bhistoryRec => bhistory
Rec ) ; :thread := bhistoryRec . logThread ; :sequence := bhistoryRec . logSeque

         0          0            1        0.4     1.0 8nsqjgbjc919b
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
SELECT TO_NUMBER(NULL) DFNUMBER, TO_NUMBER(NULL) CREATE_SCN, BRL.RESETLOGS_CHANG
E# RESET_SCN, BRL.RESETLOGS_TIME RESET_TIME, TO_NUMBER(NULL) CKP_SCN, TO_DATE(NU
LL) CKP_TIME, TO_NUMBER(NULL) STOP_SCN, BRL.THREAD# LOGTHREAD, BRL.SEQUENCE# LOG
SEQUENCE, TO_NUMBER(NULL) SETSTAMP, TO_NUMBER(NULL) SETCOUNT, BS.COMPLETION_TIME

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

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

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------
         4          4           26        0.16    11.8 2g6a6h64apf4q
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_P7_ROUTING . LOAD_ISSUER_DATA_ELEMENTS ( :T_tlv_aut
h , :T_international_check , :T_primary_resource , :T_secondary_resource ) ; END
 ;

         2          2           26        0.06     4.7 639dzmsj6hgw8
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND PRODUCT_IDENTIFIER <> 'CIR' AND ROWNUM = 1

         2          2           19        0.08     4.5 ajxn285tk7a6x
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND ROWNUM = 1

         2          2        5,385        0.00     5.2 8w5st001wrj4q
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;

         1          1            2        0.45     3.1 0az7czjdw8z7j
 declare lbRec dbms_rcvman.lbRec_t; lbCursor
 dbms_rcvman.lbCursor_t; first boolean := FALSE; re
t boolean; begin if (:first > 0) then fi
rst := TRUE; end if; <<next_row>> ret := dbms_rcvm

         1          1           19        0.04     2.2 gnxfa97kjgqmd
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM VISA_ARDEF WHERE SUBSTR(:B1 , 1, 9) BETWEEN LOW_KEY_FOR_RANGE AND
HIGH_KEY_FOR_RANGE AND CARD_TYPE != 'A'

         1          1            1        0.67     1.9 bunssq950snhf
insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi
d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS from v$sga_target_advice

         1          2            2        0.30     5.9 7rscr98xqwbrf
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
declare ret boolean ; firstcall boolean ; lbRec dbms_rcvman . lbRec_t := NULL ;
lbCursor dbms_rcvman . lbCursor_t ; begin IF ( :firstcall > 0 ) THEN dbms_rcvman
 . setAllIncarnations ( TRUE ) ; firstcall := TRUE ; ELSE firstcall := FALSE ; E
ND IF ; << loop_1 >> LOOP ret := dbms_rcvman . listBackup ( lbRecOut => lbRec ,

         1          8           88        0.01    23.3 98zhjwrkbqwwm
Module: easyagent@rac01.nucleussoftware.com (TNS V1-V3)
 begin dp_monitor.query_
row_count ( rc_query => :rc_query,
 rc_count => :rc_count
 ); end;

         0          1            3        0.15     2.3 8cj5tsda0dbz3
SELECT BS.SET_STAMP LIST_ORDER1, 0 LIST_ORDER2, BS.RECID PKEY, :B9 BACKUP_TYPE,
:B9 FILE_TYPE, BS.KEEP KEEP, BS.KEEP_UNTIL KEEP_UNTIL, BS.KEEP_OPTIONS KEEP_OPTI
ONS, NULL STATUS, NULL FNAME, NULL TAG, NULL MEDIA, BS.RECID RECID, BS.STAMP STA
MP, NULL DEVICE_TYPE, BLOCK_SIZE BLOCK_SIZE, BS.COMPLETION_TIME COMPLETION_TIME,

         0          8           30        0.01    23.0 24vb3s3db0p28
SQL ordered by CPU Time                DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------
Module: easyagent@rac01.nucleussoftware.com (TNS V1-V3)
select count(*) from sys.v_$archived_log where standby_dest = :t and applied = :
s

         0          0           60        0.01     1.0 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         0          1            4        0.07     1.9 3dcdrhnkran7p
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select /*+ rule +*/ round(sum(MBYTES_PROCESSED)) ,round(sum(INPUT_BYTES)) ,ro
und(sum(OUTPUT_BYTES)) from V$RMAN_STATUS start with (RECID=:b1 and STAMP=:b2)
 connect by prior RECID=parent_recid

         0          1            7        0.02     2.4 gvsj01d3bp10m
SELECT NVL(MAX(AL.FIRST_CHANGE#), 0) FROM V$ARCHIVED_LOG AL, V$DATABASE_INCARNAT
ION DBINC WHERE AL.DEST_ID = :B1 AND AL.STANDBY_DEST = 'YES' AND AL.APPLIED = 'Y
ES' AND AL.RESETLOGS_CHANGE# = DBINC.RESETLOGS_CHANGE# AND AL.RESETLOGS_TIME = D
BINC.RESETLOGS_TIME AND DBINC.STATUS != 'ORPHAN'

         0          1            8        0.01     2.4 33y4yxzq1ms0d
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select nvl(max(al.recid),0) into :b1 from v$archived_log al where ((al.status i
n ('X','A') and al.is_recovery_dest_file='YES') and al.creator='RMAN')

         0          1            3        0.03     2.3 c8gw6zzr9n9qn
SELECT /*+ordered*/ FE.FENUM DFNUMBER, FE.FECRC_SCN DFCREATIONSCN, TO_DATE(FE.FE
CRC_TIM,'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNA
M FILENAME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, FE.FESTA STATUS, FH.FHFSZ BLOCKS
, FE.FEBSZ BLOCKSIZE, FH.FHFSZ*FE.FEBSZ/1024 KBYTES, FE.FEURS UNRECOVSCN, DECODE

         0          1            4        0.02     2.8 a20djcagc6vp4
 declare policy varchar2(512); alldest numbe
r := dbms_rcvman.FALSE#; begin if (:alldest > 0) then
 alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLog
DeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy

         0          1            3        0.02     1.6 6b5n438mwq1ng
SELECT /*+ordered*/ FENUM DFNUMBER, FECRC_SCN DFCREATIONSCN, TO_DATE(FECRC_TIM,
'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNAM FILENA
ME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, NULL STATUS, FECSZ BLOCKS, FEBSZ BLOCKSI
ZE, FECSZ * FEBSZ / 1024 KBYTES, NULL UNRECOVSCN, TO_NUMBER(FE.FESTS) STOPSCN, :

         0          0            3        0.02     1.0 48dhj675nths8
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
declare first boolean := FALSE ; bhistoryRec dbms_rcvman . bhistoryRec_t ; begin
 if ( :first > 0 ) THEN first := TRUE ; end if ; dbms_rcvman . getAlBackupHistor
y ( backedUpDev => :devtype:devtype_i , first => first , bhistoryRec => bhistory
Rec ) ; :thread := bhistoryRec . logThread ; :sequence := bhistoryRec . logSeque

         0          0            1        0.06     1.0 8nsqjgbjc919b
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
SELECT TO_NUMBER(NULL) DFNUMBER, TO_NUMBER(NULL) CREATE_SCN, BRL.RESETLOGS_CHANG
E# RESET_SCN, BRL.RESETLOGS_TIME RESET_TIME, TO_NUMBER(NULL) CKP_SCN, TO_DATE(NU
LL) CKP_TIME, TO_NUMBER(NULL) STOP_SCN, BRL.THREAD# LOGTHREAD, BRL.SEQUENCE# LOG
SEQUENCE, TO_NUMBER(NULL) SETSTAMP, TO_NUMBER(NULL) SETCOUNT, BS.COMPLETION_TIME

         0          1            1        0.03     2.1 7vgmvmy8vvb9s
insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_c
SQL ordered by CPU Time                DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------
hange#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phy
blkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_num
ber, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.

         0          1            8        0.00     2.5 fa6ra2q90bnvn
Module: rman@rac01.nucleussoftware.com (TNS V1-V3)
select db.version_time ,db.controlfile_change# ,db.controlfile_sequence# ,dbinc.
resetlogs_time ,df.last_recid ,tf.last_recid ,ts.last_recid ,rl.last_recid ,rm.l
ast_recid ,dc.last_recid ,al.last_recid ,bp.last_recid ,do.last_recid ,offr.last
_recid ,pc.last_recid ,bs.last_recid ,ldbinc.resetlogs_change# ,ldbinc.resetlogs

         0          1            1        0.01     2.6 d1zgfup6jvgzt
Module: sqlnavigator.exe
 SELECT transaction_hist.*,ROWID FROM transaction_hist

         0          3            1        0.01     7.7 350myuyx0t1d6
insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname
, contents, status, segment_space_management, extent_management, is_back
up) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname,
 decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', '

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

SQL ordered by Gets                    DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:         348,615
-> Captured SQL account for      84.1% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
       227,237           26      8,739.9   65.2     4.20      4.20 2g6a6h64apf4q
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_P7_ROUTING . LOAD_ISSUER_DATA_ELEMENTS ( :T_tlv_aut
h , :T_international_check , :T_primary_resource , :T_secondary_resource ) ; END
 ;

       101,555           26      3,906.0   29.1     1.67      1.67 639dzmsj6hgw8
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND PRODUCT_IDENTIFIER <> 'CIR' AND ROWNUM = 1

        96,254           19      5,066.0   27.6     1.61      1.61 ajxn285tk7a6x
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT PRODUCT_IDENTIFIER FROM MCI_MPE_ICA_BIN WHERE RPAD(SUBSTR(:B1 ,1,19),19,'
0') BETWEEN BIN_LOW AND BIN_HIGH AND ROWNUM = 1

        28,291           19      1,489.0    8.1     0.79      0.79 gnxfa97kjgqmd
Module: POSH_SRV@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM VISA_ARDEF WHERE SUBSTR(:B1 , 1, 9) BETWEEN LOW_KEY_FOR_RANGE AND
HIGH_KEY_FOR_RANGE AND CARD_TYPE != 'A'

        21,456        5,385          4.0    6.2     1.58      1.87 8w5st001wrj4q
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;

        14,288        3,580          4.0    4.1     0.32      0.32 80ub3uuhsm7pm
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
 ASC) WHERE ROWNUM = 1

        13,344        6,672          2.0    3.8     0.29      0.29 5tcg41hvbdk35
Module: BASE1@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM RESOURCES WHERE RESOURCE_ID = :B1

        10,235           60        170.6    2.9     0.37      0.37 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         7,200        1,800          4.0    2.1     0.16      0.16 34mxy47dkbv1b
Module: DCISC_INT@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC) WHERE ROWNUM
 = 1

         6,702        3,360          2.0    1.9     0.10      0.10 7qzbx5v5hg568
Module: java@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM CURRENCY_TABLE WHERE CURRENCY_CODE = :B1

         5,919        1,227          4.8    1.7     0.09      0.09 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

         5,168          152         34.0    1.5     0.31      0.31 b9yn7yyr5pmxz
Module: frmweb@app02.nucleussoftware.com (TNS V1-V3)
SELECT PROCESSING_CODE,REFERENCE_NUMBER,EXTERNAL_STAN,MESSAGE_TYPE,CARD_NUMBER,C
ARD_ACCEPTOR_ID,INTERNAL_TRANSMISSION_TIME,TRANSACTION_AMOUNT,action_code,AUTHOR
SQL ordered by Gets                    DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:         348,615
-> Captured SQL account for      84.1% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
IZATION_CODE,CAPTURE_CODE,ROUTING_CODE,CURRENT_TABLE_INDICATOR,TRANSACTION_CURRE
NCY,SERVICES_SETUP_CODE,FUNCTION_CODE,SOURCE_ACCOUNT_CODE,DESTINATION_ACCOUNT_CO

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

SQL ordered by Reads                   DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Total Disk Reads:              79
-> Captured SQL account for      0.0% of Total

                               Reads              CPU     Elapsed
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
             0           3           0.0    0.0     0.00      0.00 04xtrk7uyhknh
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f
rom obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null an
d linkname is null and subname is null

             0          60           0.0    0.0     0.00      0.00 089dbukv1aanh
Module: SQL*Plus
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

             0          60           0.0    0.0     0.00      0.00 08vznc16ycuag
Module: ude@rac01.nucleussoftware.com (TNS V1-V3)
SELECT SYS_GUID() FROM SYS.DUAL

             0           2           0.0    0.0     0.91      1.12 0az7czjdw8z7j
 declare lbRec dbms_rcvman.lbRec_t; lbCursor
 dbms_rcvman.lbCursor_t; first boolean := FALSE; re
t boolean; begin if (:first > 0) then fi
rst := TRUE; end if; <<next_row>> ret := dbms_rcvm

             0           1           0.0    0.0     0.00      0.00 0cn2wm9d7zq8d
SELECT decode(value,'FATAL',1,'ERROR',2,'WARNING',3,'INFORMATION',4,'INFORMATION
2',5,'INFORMATION3',6,'INFORMATION4',7,'INFORMATION5',8,'INFORMATION6',9,0) FROM
 sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

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

             0         277           0.0    0.0     0.11      0.11 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0

             0          29           0.0    0.0     0.01      0.01 0v3dvmc22qnam
insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, noneq
uijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn,
:coln, decode(bitand(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decod
e(bitand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode(bitand(:flag

             0         218           0.0    0.0     0.06      0.06 0ws7ahf1d78qa
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_
NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE
_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from
 v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

             0           2           0.0    0.0     0.00      0.00 10xj8nynmpqtq
SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.start
up_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s
1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS
DATE) as end_time, ROUND((cast( (case when s2.end_interval

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

SQL ordered by Executions              DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Total Executions:          39,515
-> Captured SQL account for     64.9% of Total

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
       6,672           6,672            1.0       0.00        0.00 5tcg41hvbdk35
Module: BASE1@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM RESOURCES WHERE RESOURCE_ID = :B1

       5,385               0            0.0       0.00        0.00 8w5st001wrj4q
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;

       3,580               0            0.0       0.00        0.00 80ub3uuhsm7pm
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
 ASC) WHERE ROWNUM = 1

       3,360           3,351            1.0       0.00        0.00 7qzbx5v5hg568
Module: java@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM CURRENCY_TABLE WHERE CURRENCY_CODE = :B1

       1,800               0            0.0       0.00        0.00 34mxy47dkbv1b
Module: DCISC_INT@app02.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC) WHERE ROWNUM
 = 1

       1,227           1,866            1.5       0.00        0.00 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

         468             468            1.0       0.00        0.00 c9z3x25xyjw2g
Module: frmweb@app02.nucleussoftware.com (TNS V1-V3)
SELECT DECODE('''' || :1 || '''' , '''''' , NULL , '''' || :1 || ''''
) FROM DUAL

         277           1,227            4.4       0.00        0.00 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0

         218             218            1.0       0.00        0.00 0ws7ahf1d78qa
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_
NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE
_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from
 v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

         218             218            1.0       0.00        0.00 459f3z9u4fb3u
select value$ from props$ where name = 'GLOBAL_DB_NAME'

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

SQL ordered by Parse Calls             DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Total Parse Calls:          13,469
-> Captured SQL account for      72.7% of Total

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
       5,156        5,385     38.28 8w5st001wrj4q
Module: CIS@app02.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;

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

         468          468      3.47 c9z3x25xyjw2g
Module: frmweb@app02.nucleussoftware.com (TNS V1-V3)
SELECT DECODE('''' || :1 || '''' , '''''' , NULL , '''' || :1 || ''''
) FROM DUAL

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

         218          218      1.62 0ws7ahf1d78qa
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_
NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE
_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from
 v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

         218          218      1.62 459f3z9u4fb3u
select value$ from props$ where name = 'GLOBAL_DB_NAME'

         211          211      1.57 5ur69atw3vfhj
select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE
', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT',
4, 1), failover_retries, failover_delay, flags from service$ where name = :1

         116          116      0.86 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

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

         105          105      0.78 49s332uhbnsma
 declare vsn varchar2(20); begin vsn :=
 dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn;
 if vsn is not null then :pkg_vsnub4 :=
 to_number(substr(vsn,1,2) || substr(vsn,4,2) || s

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

SQL ordered by Sharable Memory         DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)  Executions   % Total    SQL Id
---------------- ------------ -------- -------------
       1,418,993            1     0.09 31a13pnjps7j3
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as tim
e_secs, operation FROM ( SELECT 1 as source, trunc((s
ysdate - cast(ll.log_date as date)) * 86400) as time_secs,
 decode(ll.operation, 'OPEN', 0

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

SQL ordered by Version Count           DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Instance Activity Stats                DB/Inst: PCARD/pcard  Snaps: 2831-2832

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session                      1,835            0.5           3.2
CPU used when call started                    1,700            0.5           3.0
CR blocks created                                55            0.0           0.1
Cached Commit SCN referenced                      0            0.0           0.0
Commit SCN cached                                 0            0.0           0.0
DB time                                     363,462          100.9         629.9
DBWR checkpoint buffers written               1,106            0.3           1.9
DBWR checkpoints                                  1            0.0           0.0
DBWR object drop buffers written                  0            0.0           0.0
DBWR tablespace checkpoint buffe                  0            0.0           0.0
DBWR transaction table writes                    79            0.0           0.1
DBWR undo block writes                          173            0.1           0.3
IMU CR rollbacks                                 43            0.0           0.1
IMU Flushes                                      87            0.0           0.2
IMU Redo allocation size                    491,568          136.4         851.9
IMU commits                                     461            0.1           0.8
IMU contention                                    1            0.0           0.0
IMU ktichg flush                                  0            0.0           0.0
IMU pool not allocated                            0            0.0           0.0
IMU recursive-transaction flush                   1            0.0           0.0
IMU undo allocation size                  2,207,200          612.5       3,825.3
IMU- failed to get a private str                  0            0.0           0.0
SMON posted for undo segment shr                  0            0.0           0.0
SQL*Net roundtrips to/from clien             25,230            7.0          43.7
active txn count during cleanout                 29            0.0           0.1
application wait time                           392            0.1           0.7
background checkpoints completed                  1            0.0           0.0
background checkpoints started                    1            0.0           0.0
background timeouts                          12,788            3.6          22.2
branch node splits                                0            0.0           0.0
buffer is not pinned count                  234,425           65.1         406.3
buffer is pinned count                    5,554,763        1,541.6       9,627.0
bytes received via SQL*Net from          15,851,421        4,399.1      27,472.1
bytes sent via SQL*Net to client          7,922,266        2,198.6      13,730.1
calls to get snapshot scn: kcmgs             49,770           13.8          86.3
calls to kcmgas                                 968            0.3           1.7
calls to kcmgcs                                 156            0.0           0.3
change write time                                 9            0.0           0.0
cleanout - number of ktugct call                 34            0.0           0.1
cleanouts and rollbacks - consis                  0            0.0           0.0
cleanouts only - consistent read                  1            0.0           0.0
cluster key scan block gets                  14,520            4.0          25.2
cluster key scans                             2,212            0.6           3.8
commit batch performed                            0            0.0           0.0
commit batch requested                            0            0.0           0.0
commit batch/immediate performed                  0            0.0           0.0
commit batch/immediate requested                  0            0.0           0.0
commit cleanout failures: block                   0            0.0           0.0
commit cleanout failures: callba                  5            0.0           0.0
commit cleanout failures: cannot                  0            0.0           0.0
commit cleanouts                              2,101            0.6           3.6
commit cleanouts successfully co              2,096            0.6           3.6
commit immediate performed                        0            0.0           0.0
commit immediate requested                        0            0.0           0.0
commit txn count during cleanout                 18            0.0           0.0
concurrency wait time                             4            0.0           0.0
consistent changes                               55            0.0           0.1
consistent gets                             340,136           94.4         589.5
consistent gets - examination                41,593           11.5          72.1
consistent gets direct                            0            0.0           0.0
Instance Activity Stats                DB/Inst: PCARD/pcard  Snaps: 2831-2832

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
consistent gets from cache                  340,136           94.4         589.5
cursor authentications                           10            0.0           0.0
data blocks consistent reads - u                 55            0.0           0.1
db block changes                              8,920            2.5          15.5
db block gets                                 8,479            2.4          14.7
db block gets direct                              0            0.0           0.0
db block gets from cache                      8,479            2.4          14.7
deferred (CURRENT) block cleanou              1,402            0.4           2.4
enqueue conversions                             728            0.2           1.3
enqueue releases                             34,402            9.6          59.6
enqueue requests                             34,404            9.6          59.6
enqueue timeouts                                  2            0.0           0.0
enqueue waits                                     2            0.0           0.0
exchange deadlocks                                0            0.0           0.0
execute count                                39,515           11.0          68.5
failed probes on index block rec                  0            0.0           0.0
free buffer inspected                             0            0.0           0.0
free buffer requested                           203            0.1           0.4
global enqueue gets sync                          0            0.0           0.0
heap block compress                              31            0.0           0.1
immediate (CR) block cleanout ap                  1            0.0           0.0
immediate (CURRENT) block cleano                244            0.1           0.4
index crx upgrade (found)                         0            0.0           0.0
index crx upgrade (positioned)                3,039            0.8           5.3
index fast full scans (full)                      3            0.0           0.0
index fetch by key                           24,960            6.9          43.3
index scans kdiixs1                          11,292            3.1          19.6
leaf node 90-10 splits                            8            0.0           0.0
leaf node splits                                 15            0.0           0.0
lob reads                                         0            0.0           0.0
lob writes                                        0            0.0           0.0
lob writes unaligned                              0            0.0           0.0
logons cumulative                               286            0.1           0.5
messages received                             1,284            0.4           2.2
messages sent                                 1,284            0.4           2.2
no buffer to keep pinned count                    0            0.0           0.0
no work - consistent read gets              277,570           77.0         481.1
opened cursors cumulative                     7,591            2.1          13.2
parse count (failures)                           13            0.0           0.0
parse count (hard)                               34            0.0           0.1
parse count (total)                          13,469            3.7          23.3
parse time cpu                                   66            0.0           0.1
parse time elapsed                               74            0.0           0.1
physical read IO requests                        79            0.0           0.1
physical read bytes                         647,168          179.6       1,121.6
physical read total IO requests              17,196            4.8          29.8
physical read total bytes               534,092,800      148,220.5     925,637.4
physical read total multi block                 371            0.1           0.6
physical reads                                   79            0.0           0.1
physical reads cache                              0            0.0           0.0
physical reads cache prefetch                     0            0.0           0.0
physical reads direct                            79            0.0           0.1
physical reads direct (lob)                       0            0.0           0.0
physical reads direct temporary                   0            0.0           0.0
physical reads prefetch warmup                    0            0.0           0.0
physical write IO requests                      840            0.2           1.5
physical write bytes                      9,543,680        2,648.6      16,540.2
physical write total IO requests              6,189            1.7          10.7
physical write total bytes              142,001,664       39,408.1     246,103.4
physical write total multi block              1,228            0.3           2.1
Instance Activity Stats                DB/Inst: PCARD/pcard  Snaps: 2831-2832

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
physical writes                               1,165            0.3           2.0
physical writes direct                           59            0.0           0.1
physical writes direct (lob)                      0            0.0           0.0
physical writes direct temporary                  0            0.0           0.0
physical writes from cache                    1,106            0.3           1.9
physical writes non checkpoint                  156            0.0           0.3
prefetch warmup blocks flushed o                  0            0.0           0.0
process last non-idle time                    5,587            1.6           9.7
recursive calls                             105,764           29.4         183.3
recursive cpu usage                           1,120            0.3           1.9
redo blocks written                           4,397            1.2           7.6
redo buffer allocation retries                    0            0.0           0.0
redo entries                                  3,682            1.0           6.4
redo log space requests                           0            0.0           0.0
redo log space wait time                          0            0.0           0.0
redo ordering marks                              76            0.0           0.1
redo size                                 2,074,564          575.7       3,595.4
redo subscn max counts                          289            0.1           0.5
redo synch time                                 112            0.0           0.2
redo synch writes                               176            0.1           0.3
redo wastage                                165,108           45.8         286.2
redo write time                                 242            0.1           0.4
redo writer latching time                         0            0.0           0.0
redo writes                                     607            0.2           1.1
rollback changes - undo records                   1            0.0           0.0
rollbacks only - consistent read                 55            0.0           0.1
rows fetched via callback                    16,921            4.7          29.3
session connect time                              0            0.0           0.0
session cursor cache hits                     8,243            2.3          14.3
session logical reads                       348,615           96.8         604.2
session pga memory                       99,497,608       27,612.4     172,439.5
session pga memory max                  220,591,080       61,218.1     382,306.9
session uga memory                  257,709,767,032   71,519,176.0 #############
session uga memory max                  220,403,416       61,166.0     381,981.7
shared hash latch upgrades - no               4,192            1.2           7.3
shared hash latch upgrades - wai                  0            0.0           0.0
sorts (memory)                               11,527            3.2          20.0
sorts (rows)                                240,488           66.7         416.8
sql area evicted                                 41            0.0           0.1
sql area purged                                  14            0.0           0.0
switch current to new buffer                     26            0.0           0.1
table fetch by rowid                      2,872,241          797.1       4,977.9
table fetch continued row                        57            0.0           0.1
table scan blocks gotten                     52,182           14.5          90.4
table scan rows gotten                    3,519,748          976.8       6,100.1
table scans (direct read)                         0            0.0           0.0
table scans (long tables)                         0            0.0           0.0
table scans (rowid ranges)                        0            0.0           0.0
table scans (short tables)                    7,705            2.1          13.4
total number of times SMON poste                  0            0.0           0.0
transaction rollbacks                             0            0.0           0.0
undo change vector size                     684,540          190.0       1,186.4
user I/O wait time                              240            0.1           0.4
user calls                                   26,032            7.2          45.1
user commits                                    547            0.2           1.0
user rollbacks                                   30            0.0           0.1
workarea executions - onepass                     0            0.0           0.0
workarea executions - optimal                 3,583            1.0           6.2
write clones created in backgrou                  0            0.0           0.0
write clones created in foregrou                  0            0.0           0.0
          -------------------------------------------------------------

Instance Activity Stats - Absolute ValuesDB/Inst: PCARD/pcard  Snaps: 2831-28
-> Statistics with absolute values (should not be diffed)

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
session cursor cache count               332,855         335,299
opened cursors current                       917             940
workarea memory allocated                      0              78
logons current                               171             176
          -------------------------------------------------------------

Instance Activity Stats - Thread ActivityDB/Inst: PCARD/pcard  Snaps: 2831-283
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                            1      1.00
          -------------------------------------------------------------

Tablespace IO Stats                    DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                       Av     Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX
             1       0   20.0     1.0          354        0          0    0.0
UNDOTBS1
             1       0   60.0     1.0          167        0          0    0.0
SYSTEM
             1       0   20.0     1.0           82        0          0    0.0
POWERCARD_INDEX_FE_PART01
             2       0   25.0     1.0           71        0          0    0.0
POWERCARD_DATA_BATCH
             4       0   15.0     1.0           58        0          0    0.0
POWERCARD_DATA_FE_PART01
             2       0   45.0     1.0           21        0          0    0.0
POWERCARD_INDEX_FE_PART02
             2       0   10.0     1.0           19        0          0    0.0
POWERCARD_USERS
             1       0   20.0     1.0           17        0          0    0.0
POWERCARD_DATA_FE_PART02
             4       0   30.0     1.0            2        0          0    0.0
POWERCARD_INDEX_BATCH
             2       0   20.0     1.0            3        0          0    0.0
POWERCARD_DATA_BO_PART01
             2       0   30.0     1.0            2        0          0    0.0
POWERCARD_DATA_BO_PART02
             2       0   10.0     1.0            2        0          0    0.0
POWERCARD_DATA_PAR
             1       0   30.0     1.0            3        0          0    0.0
POWERCARD_DATA_FE_PART03
             2       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART04
             2       0    5.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART01
             2       0   15.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART02
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART03
             2       0   30.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART04
             2       0   55.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART05
             2       0    5.0     1.0            1        0          0    0.0
POWERCARD_INDEX_FE_PART03
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_FE_PART04
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART01
             2       0   25.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART02
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART03
             2       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART04
             2       0   10.0     1.0            1        0          0    0.0
OEM_REPOSITORY
             1       0   50.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART03
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART04
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART06
             1       0   20.0     1.0            1        0          0    0.0
Tablespace IO Stats                    DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
POWERCARD_DATA_HIST_PART07
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART08
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART09
             1       0   30.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART10
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART11
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART12
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART13
             1       0  100.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART14
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART01
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART02
             1       0  200.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART03
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART04
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART05
             1       0    0.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART06
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART07
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART08
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART09
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART10
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART11
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART12
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART13
             1       0  160.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PART14
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_PAR
             1       0   20.0     1.0            1        0          0    0.0
TOOLS
             1       0   90.0     1.0            1        0          0    0.0
          -------------------------------------------------------------

File IO Stats                          DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                       Av     Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
OEM_REPOSITORY           /pcard08/oradata/pcard/oemrep01.dbf
             1       0   50.0     1.0            1        0          0    0.0
POWERCARD_DATA_BATCH     /pcard07/oradata/pcard/pwrcrd_data_batch01.dbf
             2       0   15.0     1.0           53        0          0    0.0
POWERCARD_DATA_BATCH     /pcard07/oradata/pcard/pwrcrd_data_batch02.dbf
             2       0   15.0     1.0            5        0          0    0.0
POWERCARD_DATA_BO_PART01 /pcard05/oradata/pcard/pwrcrd_data_bo_part01_01.dbf
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART01 /pcard05/oradata/pcard/pwrcrd_data_bo_part01_02.dbf
             1       0   50.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART02 /pcard06/oradata/pcard/pwrcrd_data_bo_part02_01.dbf
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART02 /pcard06/oradata/pcard/pwrcrd_data_bo_part02_02.dbf
             1       0    0.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART03 /pcard07/oradata/pcard/pwrcrd_data_bo_part03_01.dbf
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_BO_PART04 /pcard08/oradata/pcard/pwrcrd_data_bo_part04_01.dbf
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART01 /pcard05/oradata/pcard/pwrcrd_data_fe_part01_01.dbf
             1       0   20.0     1.0           20        0          0    0.0
POWERCARD_DATA_FE_PART01 /pcard05/oradata/pcard/pwrcrd_data_fe_part01_02.dbf
             1       0   70.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART02 /pcard06/oradata/pcard/pwrcrd_data_fe_part02_01.dbf
             2       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART02 /pcard06/oradata/pcard/pwrcrd_data_fe_part02_02.dbf
             2       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART03 /pcard07/oradata/pcard/pwrcrd_data_fe_part03_01.dbf
             2       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_FE_PART04 /pcard08/oradata/pcard/pwrcrd_data_fe_part04_01.dbf
             2       0    5.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard05/oradata/pcard/pwrcrd_data_hist_part01_01.db
             2       0   15.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard06/oradata/pcard/pwrcrd_data_hist_part02_01.db
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard07/oradata/pcard/pwrcrd_data_hist_part03_01.db
             2       0   30.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard08/oradata/pcard/pwrcrd_data_hist_part04_01.db
             2       0   55.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard05/oradata/pcard/pwrcrd_data_hist_part05_01.db
             2       0    5.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard06/oradata/pcard/pwrcrd_data_hist_part06_01.db
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard07/oradata/pcard/pwrcrd_data_hist_part07_01.db
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard08/oradata/pcard/pwrcrd_data_hist_part08_01.db
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard05/oradata/pcard/pwrcrd_data_hist_part09_01.db
             1       0   30.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard06/oradata/pcard/pwrcrd_data_hist_part10_01.db
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard07/oradata/pcard/pwrcrd_data_hist_part11_01.db
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard08/oradata/pcard/pwrcrd_data_hist_part12_01.db
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard05/oradata/pcard/pwrcrd_data_hist_part13_01.db
             1       0  100.0     1.0            1        0          0    0.0
POWERCARD_DATA_HIST_PART /pcard06/oradata/pcard/pwrcrd_data_hist_part14_01.db
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_DATA_PAR       /pcard08/oradata/pcard/pwrcrd_data_par01.dbf
             1       0   30.0     1.0            3        0          0    0.0
File IO Stats                          DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                       Av     Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
POWERCARD_INDEX_BATCH    /pcard11/oradata/pcard/pwrcrd_ndx_batch01.dbf
             2       0   20.0     1.0            3        0          0    0.0
POWERCARD_INDEX_BO_PART0 /pcard09/oradata/pcard/pwrcrd_ndx_bo_part01_01.dbf
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART0 /pcard10/oradata/pcard/pwrcrd_ndx_bo_part02_01.dbf
             1       0  200.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART0 /pcard11/oradata/pcard/pwrcrd_ndx_bo_part03_01.dbf
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_BO_PART0 /pcard12/oradata/pcard/pwrcrd_ndx_bo_part04_01.dbf
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_FE_PART0 /pcard09/oradata/pcard/pwrcrd_ndx_fe_part01_01.dbf
             2       0   25.0     1.0           71        0          0    0.0
POWERCARD_INDEX_FE_PART0 /pcard10/oradata/pcard/pwrcrd_ndx_fe_part02_01.dbf
             2       0   10.0     1.0           19        0          0    0.0
POWERCARD_INDEX_FE_PART0 /pcard11/oradata/pcard/pwrcrd_ndx_fe_part03_01.dbf
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_FE_PART0 /pcard12/oradata/pcard/pwrcrd_ndx_fe_part04_01.dbf
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_index_hist_part01_01.d
             2       0   25.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard10/oradata/pcard/pwrcrd_index_hist_part02_01.d
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_data_index_part03_01.d
             2       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard12/oradata/pcard/pwrcrd_index_hist_part04_01.d
             2       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_index_hist_part05_01.d
             1       0    0.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard10/oradata/pcard/pwrcrd_index_hist_part06_01.d
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_index_hist_part07_01.d
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard12/oradata/pcard/pwrcrd_index_hist_part08_01.d
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard09/oradata/pcard/pwrcrd_index_hist_part09_01.d
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard10/oradata/pcard/pwrcrd_index_hist_part10_01.d
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_index_hist_part11_01.d
             1       0   10.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard12/oradata/pcard/pwrcrd_index_hist_part12_01.d
             1       0   40.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard11/oradata/pcard/pwrcrd_index_hist_part13_01.d
             1       0  160.0     1.0            1        0          0    0.0
POWERCARD_INDEX_HIST_PAR /pcard10/oradata/pcard/pwrcrd_index_hist_part14_01.d
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_INDEX_PAR      /pcard12/oradata/pcard/pwrcrd_ndx_par01.dbf
             1       0   20.0     1.0            1        0          0    0.0
POWERCARD_USERS          /pcard08/oradata/pcard/pwrcrd_usr01.dbf
             1       0   20.0     1.0           17        0          0    0.0
SYSAUX                   /pcard03/oradata/pcard/pwrcrd_sysaux.dbf
             1       0   20.0     1.0          354        0          0    0.0
SYSTEM                   /pcard01/oradata/pcard/system01.dbf
             1       0   20.0     1.0           82        0          0    0.0
TOOLS                    /pcard08/oradata/pcard/tools01.dbf
             1       0   90.0     1.0            1        0          0    0.0
UNDOTBS1                 /pcard03/oradata/pcard/undotbs01.dbf
             1       0   60.0     1.0          167        0          0    0.0
          -------------------------------------------------------------

Buffer Pool Statistics                 DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                            Free Writ     Buffer
     Number of Pool         Buffer     Physical    Physical Buff Comp       Busy
P      Buffers Hit%           Gets        Reads      Writes Wait Wait      Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D      918,256  100        348,619            0       1,106    0    0          0
          -------------------------------------------------------------

Instance Recovery Stats                 DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> B: Begin snapshot,  E: End snapshot

  Targt  Estd                                  Log File Log Ckpt     Log Ckpt
  MTTR   MTTR   Recovery  Actual    Target       Size    Timeout     Interval
   (s)    (s)   Estd IOs Redo Blks Redo Blks  Redo Blks Redo Blks   Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B     0    20        224       632      1602     829440      1602          N/A
E     0    20        226       414      1336     829440      1336          N/A
          -------------------------------------------------------------

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

                                        Est
                                       Phys
    Size for   Size      Buffers for   Read          Estimated
P    Est (M) Factor         Estimate Factor     Physical Reads
--- -------- ------ ---------------- ------ ------------------
D        736     .1           91,034    1.6            307,213
D      1,472     .2          182,068    1.0            200,274
D      2,208     .3          273,102    1.0            195,049
D      2,944     .4          364,136    1.0            194,692
D      3,680     .5          455,170    1.0            194,692
D      4,416     .6          546,204    1.0            194,692
D      5,152     .7          637,238    1.0            194,692
D      5,888     .8          728,272    1.0            194,692
D      6,624     .9          819,306    1.0            194,692
D      7,360    1.0          910,340    1.0            194,692
D      7,424    1.0          918,256    1.0            194,692
D      8,096    1.1        1,001,374    1.0            194,692
D      8,832    1.2        1,092,408    1.0            194,692
D      9,568    1.3        1,183,442    1.0            194,692
D     10,304    1.4        1,274,476    1.0            194,692
D     11,040    1.5        1,365,510    1.0            194,692
D     11,776    1.6        1,456,544    1.0            194,692
D     12,512    1.7        1,547,578    1.0            194,692
D     13,248    1.8        1,638,612    1.0            194,692
D     13,984    1.9        1,729,646    1.0            194,692
D     14,720    2.0        1,820,680    1.0            194,692
          -------------------------------------------------------------

PGA Aggr Summary                       DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %   W/A MB Processed  Extra W/A MB Read/Written
--------------- ------------------ --------------------------
          100.0                269                          0
          -------------------------------------------------------------

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

                                                %PGA  %Auto   %Man
    PGA Aggr   Auto PGA   PGA Mem    W/A PGA     W/A    W/A    W/A Global Mem
   Target(M)  Target(M)  Alloc(M)    Used(M)     Mem    Mem    Mem   Bound(K)
- ---------- ---------- ---------- ---------- ------ ------ ------ ----------
B      1,800      1,483      293.8        0.0     .0     .0     .0    184,320
E      1,800      1,480      300.6        0.1     .0  100.0     .0    184,320
          -------------------------------------------------------------

PGA Aggr Target Histogram               DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Optimal Executions are purely in-memory operations

  Low     High
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K          3,231          3,231            0            0
    64K    128K             62             62            0            0
   128K    256K             30             30            0            0
   256K    512K              8              8            0            0
   512K   1024K            132            132            0            0
     1M      2M            120            120            0            0
          -------------------------------------------------------------

PGA Memory Advisory                           DB/Inst: PCARD/pcard  Snap: 2832
-> 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
---------- ------- ---------------- ---------------- -------- ----------
       225     0.1         36,113.7            667.3     98.0          1
       450     0.3         36,113.7            637.6     98.0          0
       900     0.5         36,113.7             18.6    100.0          0
     1,350     0.8         36,113.7             18.6    100.0          0
     1,800     1.0         36,113.7             18.6    100.0          0
     2,160     1.2         36,113.7              0.0    100.0          0
     2,520     1.4         36,113.7              0.0    100.0          0
     2,880     1.6         36,113.7              0.0    100.0          0
     3,240     1.8         36,113.7              0.0    100.0          0
     3,600     2.0         36,113.7              0.0    100.0          0
     5,400     3.0         36,113.7              0.0    100.0          0
     7,200     4.0         36,113.7              0.0    100.0          0
    10,800     6.0         36,113.7              0.0    100.0          0
    14,400     8.0         36,113.7              0.0    100.0          0
          -------------------------------------------------------------

Shared Pool Advisory                         DB/Inst: PCARD/pcard  Snap: 2832
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       544    .4      179       17,158 #######    1.0  63,558  210.5  19,639,806
       704    .5      331       22,437 #######    1.0  34,742  115.0  19,681,801
       864    .6      480       31,440 #######    1.0  13,730   45.5  19,708,990
     1,024    .7      631       44,031 #######    1.0   2,524    8.4  19,723,349
     1,184    .8      790       54,610 #######    1.0     313    1.0  19,728,314
     1,344    .9      949       65,237 #######    1.0     305    1.0  19,728,975
     1,504   1.0    1,109       75,467 #######    1.0     302    1.0  19,729,179
     1,664   1.1    1,208       83,320 #######    1.0     302    1.0  19,729,236
     1,824   1.2    1,247       85,381 #######    1.0     302    1.0  19,729,265
     1,984   1.3    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,144   1.4    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,304   1.5    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,464   1.6    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,624   1.7    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,784   1.9    1,268       87,598 #######    1.0     302    1.0  19,729,271
     2,944   2.0    1,268       87,598 #######    1.0     302    1.0  19,729,271
     3,104   2.1    1,268       87,598 #######    1.0     302    1.0  19,729,271
          -------------------------------------------------------------

SGA Target Advisory                           DB/Inst: PCARD/pcard  Snap: 2832

SGA Target   SGA Size       Est DB     Est Physical
  Size (M)     Factor     Time (s)            Reads
---------- ---------- ------------ ----------------
     2,252        0.3       16,042          307,224
     4,504        0.5       13,851          194,692
     6,756        0.8       13,851          194,692
     9,008        1.0       13,851          194,692
    11,260        1.3       13,851          194,692
    13,512        1.5       13,851          194,692
    15,764        1.8       13,851          194,692
    18,016        2.0       13,851          194,692
          -------------------------------------------------------------

Streams Pool Advisory                         DB/Inst: PCARD/pcard  Snap: 2832

  Size for      Size   Est Spill   Est Spill Est Unspill Est Unspill
  Est (MB)    Factor       Count    Time (s)       Count    Time (s)
---------- --------- ----------- ----------- ----------- -----------
        16       0.5         246           2           0           0
        32       1.0           0           0           0           0
        48       1.5           0           0           0           0
        64       2.0           0           0           0           0
        80       2.5           0           0           0           0
        96       3.0           0           0           0           0
       112       3.5           0           0           0           0
       128       4.0           0           0           0           0
       144       4.5           0           0           0           0
       160       5.0           0           0           0           0
       176       5.5           0           0           0           0
       192       6.0           0           0           0           0
       208       6.5           0           0           0           0
       224       7.0           0           0           0           0
       240       7.5           0           0           0           0
       256       8.0           0           0           0           0
       272       8.5           0           0           0           0
       288       9.0           0           0           0           0
       304       9.5           0           0           0           0
       320      10.0           0           0           0           0
          -------------------------------------------------------------

Java Pool Advisory                            DB/Inst: PCARD/pcard  Snap: 2832

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

Buffer Wait Statistics                  DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Enqueue Activity                       DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)
------------------------------------------------------------------------------
    Requests    Succ Gets Failed Gets       Waits  Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
CF-Controlfile Transaction
       8,003        8,003           0           2            0          15.00
          -------------------------------------------------------------

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

Undo   Num Undo       Number of  Max Qry   Max Tx Min/Max   STO/     uS/uR/uU/
 TS# Blocks (K)    Transactions  Len (s) Concurcy TR (mins) OOS      eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
   1         .1             785      241        3 5760/5760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Undo Segment Stats                      DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Most recent 35 Undostat rows, ordered by Time desc

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/    uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS     eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
21-Jun 14:55           8          144     126       2   5,760 0/0   0/0/0/0/0/0
21-Jun 14:45           8          126     241       2   5,760 0/0   0/0/0/0/0/0
21-Jun 14:35           8           90     102       2   5,760 0/0   0/0/0/0/0/0
21-Jun 14:25          10           94       0       2   5,760 0/0   0/0/0/0/0/0
21-Jun 14:15           6           89       0       1   5,760 0/0   0/0/0/0/0/0
21-Jun 14:05          63          242       0       3   5,760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Latch Activity                         DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch               2,393    0.0    N/A      0            0    N/A
AWR Alerted Metric Eleme         23,849    0.0    N/A      0            0    N/A
Consistent RBA                      608    0.0    N/A      0            0    N/A
FAL request queue                    80    0.0    N/A      0            0    N/A
FAL subheap alocation                78    0.0    N/A      0            0    N/A
FIB s.o chain latch                  76    0.0    N/A      0            0    N/A
FOB s.o list latch                  519    0.0    N/A      0            0    N/A
In memory undo latch              6,488    0.0    N/A      0        2,002    0.0
JS queue state obj latch         21,600    0.0    N/A      0            0    N/A
KMG MMAN ready and start          1,200    0.0    N/A      0            0    N/A
KTF sga latch                         7    0.0    N/A      0        1,106    0.0
KWQMN job cache list lat             30    0.0    N/A      0            0    N/A
KWQP Prop Status                      2    0.0    N/A      0            0    N/A
MQL Tracking Latch                    0    N/A    N/A      0           72    0.0
Memory Management Latch               0    N/A    N/A      0        1,200    0.0
OS process                          672    0.0    N/A      0            0    N/A
OS process allocation             1,651    0.0    N/A      0            0    N/A
OS process: request allo            443    0.0    N/A      0            0    N/A
PL/SQL warning settings           6,572    0.0    N/A      0            0    N/A
SQL memory manager latch              1    0.0    N/A      0        1,196    0.0
SQL memory manager worka         81,478    0.0    N/A      0            0    N/A
Shared B-Tree                       131    0.0    N/A      0            0    N/A
X$KSFQP                              21    0.0    N/A      0            0    N/A
active checkpoint queue           3,186    0.0    N/A      0            0    N/A
active service list               7,846    0.0    N/A      0        1,797    0.0
alert log latch                       1    0.0    N/A      0            0    N/A
archive control                     517    0.0    N/A      0            0    N/A
archive process latch             1,350    0.0    N/A      0            0    N/A
cache buffer handles                 33    0.0    N/A      0            0    N/A
cache buffers chains            683,376    0.7    0.0      0          147    0.0
cache buffers lru chain           2,271    0.0    N/A      0          248    0.0
channel handle pool latc            443    0.0    N/A      0            0    N/A
channel operations paren         17,493    0.0    N/A      0            0    N/A
checkpoint queue latch          202,565    0.0    N/A      0        1,027    0.0
client/application info           3,396    0.0    N/A      0            0    N/A
commit callback allocati             58    0.0    N/A      0            0    N/A
compile environment latc            286    0.0    N/A      0            0    N/A
dml lock allocation               2,752    0.0    N/A      0            0    N/A
dummy allocation                    567    0.0    N/A      0            0    N/A
enqueue hash chains              69,536    0.0    N/A      0           62    0.0
enqueues                         65,367    0.0    0.0      0            0    N/A
event group latch                   223    0.0    N/A      0            0    N/A
file cache latch                    425    0.0    N/A      0            0    N/A
ges caches resource list              0    N/A    N/A      0       35,800    0.0
ges process hash list             2,070    0.0    N/A      0            0    N/A
ges process parent latch            220    0.0    N/A      0            0    N/A
ges process table freeli            443    0.0    N/A      0            0    N/A
global KZLD latch for me            217    0.0    N/A      0            0    N/A
hash table column usage              84    0.0    N/A      0          639    0.0
hash table modification              65    0.0    N/A      0            0    N/A
job workq parent latch                0    N/A    N/A      0          120    0.0
job_queue_processes para            120    0.0    N/A      0            0    N/A
kks stats                            98    0.0    N/A      0            0    N/A
kokc descriptor allocati             22    0.0    N/A      0            0    N/A
krbmrosl                             60    0.0    N/A      0            0    N/A
ksuosstats global area              242    0.0    N/A      0            0    N/A
ktm global data                      12    0.0    N/A      0            0    N/A
kwqbsn:qsga                         130    0.0    N/A      0            0    N/A
lgwr LWN SCN                      1,563    0.0    N/A      0            0    N/A
library cache                   231,114    1.1    0.0      0          193    0.0
Latch Activity                         DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
library cache load lock              24    0.0    N/A      0            0    N/A
library cache lock               49,579    0.0    0.0      0            0    N/A
library cache lock alloc          2,054    0.0    N/A      0            0    N/A
library cache pin               137,532    0.9    0.0      0            0    N/A
library cache pin alloca            358    0.0    N/A      0            0    N/A
list of block allocation            151    0.0    N/A      0            0    N/A
loader state object free             36    0.0    N/A      0            0    N/A
logminer context allocat              1    0.0    N/A      0            0    N/A
longop free list parent               1    0.0    N/A      0            1    0.0
messages                        100,512    0.0    0.0      0            0    N/A
mostly latch-free SCN             1,564    0.0    N/A      0            0    N/A
name-service memory obje            498    0.0    N/A      0            0    N/A
name-service namespace b         35,569    0.0    N/A      0            0    N/A
name-service pending que            498    0.0    N/A      0            0    N/A
name-service request que         36,049    0.0    N/A      0            0    N/A
ncodef allocation latch              58    0.0    N/A      0            0    N/A
object queue header heap         12,743    0.0    N/A      0            0    N/A
object queue header oper         16,232    0.0    N/A      0            0    N/A
object stats modificatio              1    0.0    N/A      0            0    N/A
parallel query alloc buf            480    0.0    N/A      0            0    N/A
parameter list                    2,144    0.0    N/A      0            0    N/A
parameter table allocati            577    0.0    N/A      0            0    N/A
post/wait queue                     434    0.0    N/A      0          179    0.0
process allocation               35,763    0.0    1.0      0          223    0.0
process group creation              443    0.0    N/A      0            0    N/A
qmn task queue latch              1,025   18.1    0.0      0            0    N/A
queued dump request              18,009    0.0    N/A      0            0    N/A
redo allocation                   7,912    0.0    N/A      0        3,635    0.0
redo copy                             0    N/A    N/A      0        3,635    0.2
redo writing                      7,585    0.0    N/A      0            0    N/A
resmgr group change latc            700    0.0    N/A      0            0    N/A
resmgr:active threads               564    0.0    N/A      0            0    N/A
resmgr:actses change gro            284    0.0    N/A      0            0    N/A
resmgr:free threads list            563    0.0    N/A      0            0    N/A
resmgr:schema config                  1    0.0    N/A      0            0    N/A
row cache objects                71,049    0.0    N/A      0            1    0.0
rules engine aggregate s             29    0.0    N/A      0            0    N/A
rules engine rule set st            158    0.0    N/A      0            0    N/A
sequence cache                      884    0.0    N/A      0            0    N/A
session allocation                3,675    0.0    0.0      0            0    N/A
session idle bit                 55,824    0.0    N/A      0            0    N/A
session state list latch          1,019    0.1    0.0      0            0    N/A
session switching                   214    0.0    N/A      0            0    N/A
session timer                     1,230    0.0    N/A      0            0    N/A
shared pool                      14,151    0.0    1.0      0            0    N/A
shared pool sim alloc                 1    0.0    N/A      0            0    N/A
shared pool simulator           104,965    0.0    N/A      0            0    N/A
simulator hash latch             20,829    0.0    N/A      0            0    N/A
simulator lru latch               1,106    0.0    N/A      0       19,705    0.0
slave class                           2    0.0    N/A      0            0    N/A
slave class create                    8   12.5    1.0      0            0    N/A
sort extent pool                     88    0.0    N/A      0            0    N/A
state object free list                2    0.0    N/A      0            0    N/A
statistics aggregation              336    0.0    N/A      0            0    N/A
threshold alerts latch            1,444    0.0    N/A      0            0    N/A
transaction allocation          287,670    0.0    N/A      0            0    N/A
transaction branch alloc          1,230    0.0    N/A      0            0    N/A
undo global data                  6,804    0.0    N/A      0            0    N/A
user lock                           978    0.0    N/A      0            0    N/A
virtual circuit buffers             264    0.0    N/A      0            0    N/A
Latch Activity                         DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
virtual circuit queues              120    0.0    N/A      0            0    N/A
virtual circuits                     48    0.0    N/A      0            0    N/A
          -------------------------------------------------------------

Latch Sleep Breakdown                  DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by misses desc

Latch Name
----------------------------------------
  Get Requests      Misses      Sleeps  Spin Gets   Sleep1   Sleep2   Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
       683,376       4,540          14      4,528        0        0        0
library cache
       231,114       2,603           1      2,602        0        0        0
process allocation
        35,763           2           2          0        0        0        0
shared pool
        14,151           1           1          0        0        0        0
slave class create
             8           1           1          0        0        0        0
          -------------------------------------------------------------

Latch Miss Sources                     DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains     kcbgtcr: kslbegin excl           0        249      247
cache buffers chains     kcbrls: kslbegin                 0          8       10
library cache            kglpndl: child: after proc       0          1        0
process allocation       ksucrp                           0          2        0
shared pool              kghalo                           0          1        1
slave class create       ksvcreate                        0          1        0
          -------------------------------------------------------------

Parent Latch Statistics                DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Child Latch Statistics                  DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Segments by Logical Reads              DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Total Logical Reads:         348,615
-> Captured Segments account for   93.5% of Total

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
POWERCARD  POWERCARD_ MCI_MPE_ICA_BIN                 TABLE      178,560   51.22
POWERCARD  POWERCARD_ VISA_ARDEF                      TABLE       28,256    8.11
POWERCARD  POWERCARD_ P7_STORE_AND_FORWARD            TABLE       21,296    6.11
POWERCARD  POWERCARD_ ID_MCI_MPE_ICA_BIN_B            INDEX       19,232    5.52
SYS        SYSTEM     COLTYPE$                        TABLE       10,256    2.94
          -------------------------------------------------------------

Segments by Physical Reads              DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Segments by Row Lock Waits             DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Segments by ITL Waits                   DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Segments by Buffer Busy Waits           DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Dictionary Cache Stats                 DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> "Pct Misses"  should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control                      66    0.0       0   N/A        2          1
dc_database_links                  443    0.0       0   N/A        0          1
dc_global_oids                     148    0.0       0   N/A        0        497
dc_histogram_data                  423    3.8       0   N/A        0     11,632
dc_histogram_defs                5,764    0.4       0   N/A        0     32,094
dc_object_ids                    2,294    0.0       0   N/A        0     10,459
dc_objects                         500    0.6       0   N/A        1     12,091
dc_profiles                        277    0.0       0   N/A        0          1
dc_rollback_segments               815    0.0       0   N/A        0         36
dc_segments                        517    0.0       0   N/A        4      4,991
dc_sequences                         1    0.0       0   N/A        1         36
dc_tablespaces                   1,077    0.0       0   N/A        0         56
dc_usernames                     1,694    0.0       0   N/A        0        341
dc_users                        12,150    0.0       0   N/A        0        568
outstanding_alerts                 702    2.0       0   N/A       29        110
          -------------------------------------------------------------

Library Cache Activity                  DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> "Pct Misses"  should be very low

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   1,047    0.0         24,941    0.0          0        0
CLUSTER                    2    0.0              2    0.0          0        0
INDEX                     40    0.0             40    0.0          0        0
SQL AREA               2,485    0.5         47,825   -2.4         14        0
TABLE/PROCEDURE          314    0.0         41,966    0.0          2        0
TRIGGER                   22    0.0            518    0.0          0        0
          -------------------------------------------------------------

Process Memory Summary                 DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> 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
-> ordered by Begin/End snapshot, Alloc (MB) desc

                                                            Hist
                                    Avg  Std Dev     Max     Max
               Alloc      Used    Alloc    Alloc   Alloc   Alloc    Num    Num
  Category      (MB)      (MB)     (MB)     (MB)    (MB)    (MB)   Proc  Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other        257.1       N/A      1.5      4.4      44      46    170    170
  Freeable      29.4        .0      1.8      1.3       5     N/A     16     16
  PL/SQL         3.9       2.3       .0       .0       0       1    169    169
  SQL            3.5       2.2       .0       .1       0       4    158     82
E Other        261.3       N/A      1.5      4.3      44      55    173    173
  Freeable      31.1        .0      1.7      1.3       5     N/A     18     18
  PL/SQL         4.6       2.4       .0       .1       1       1    172    172
  SQL            3.7       2.3       .0       .1       0       4    161     86
          -------------------------------------------------------------

SGA Memory Summary                      DB/Inst: PCARD/pcard  Snaps: 2831-2832

                                                      End Size (Bytes)
SGA regions                     Begin Size (Bytes)      (if different)
------------------------------ ------------------- -------------------
Database Buffers                     7,784,628,224
Fixed Size                               2,099,328
Redo Buffers                            14,675,968
Variable Size                        1,644,169,088
                               -------------------
sum                                  9,445,572,608
          -------------------------------------------------------------

SGA breakdown difference                DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> ordered by Pool, Name
-> N/A 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   free memory                              16.0           16.0    0.00
large  PX msg pool                               1.0            1.0    0.00
large  free memory                              14.5           14.5    0.00
large  session heap                               .4             .4    0.00
shared ASH buffers                              29.0           29.0    0.00
shared CCursor                                 134.3          134.1   -0.13
shared Heap0: KGL                               27.5           27.5   -0.01
shared KGLS heap                                32.9           33.0    0.07
shared KQR M PO                                 24.6           24.6    0.05
shared PCursor                                  83.8           83.8   -0.05
shared PL/SQL DIANA                             25.1           25.0   -0.22
shared PL/SQL MPCODE                            33.1           33.1   -0.02
shared db_block_hash_buckets                    45.0           45.0    0.00
shared free memory                             260.7          258.4   -0.89
shared library cache                            77.2           77.2   -0.00
shared sql area                                567.3          569.8    0.44
shared sql area:PLSQL                           16.8           16.8    0.00
stream free memory                              31.9           31.9    0.00
       buffer_cache                          7,424.0        7,424.0    0.00
       fixed_sga                                 2.0            2.0    0.00
       log_buffer                               14.0           14.0    0.00
          -------------------------------------------------------------

Streams CPU/IO Usage                   DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Streams processes ordered by CPU usage
-> CPU and I/O Time in micro seconds

Session Type                    CPU Time  User I/O Time   Sys I/O Time
------------------------- -------------- -------------- --------------
QMON Coordinator                  24,264              0              0
QMON Slaves                       18,079              0              0
          -------------------------------------------------------------

Streams Capture                         DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Streams Apply                           DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Buffered Queues                         DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Buffered Subscribers                    DB/Inst: PCARD/pcard  Snaps: 2831-2832

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

Rule Set                                DB/Inst: PCARD/pcard  Snaps: 2831-2832
-> Rule Sets ordered by Evaluations

                                       Fast      SQL      CPU  Elapsed
Ruleset Name                 Evals    Evals    Execs     Time     Time
------------------------- -------- -------- -------- -------- --------
SYS.ALERT_QUE_R                 29        0        0        0        0
          -------------------------------------------------------------

Resource Limit Stats                         DB/Inst: PCARD/pcard  Snap: 2832

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

init.ora Parameters                    DB/Inst: PCARD/pcard  Snaps: 2831-2832

                                                                End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
_log_deletion_policy          ALL
audit_file_dest               /pcard18/admin/pcard/adump
background_dump_dest          /pcard18/admin/pcard/bdump
compatible                    10.2.0.1.0
control_file_record_keep_time 15
control_files                 /pcard02/oradata/pcard/control01.
core_dump_dest                /pcard18/admin/pcard/cdump
db_block_size                 8192
db_domain
db_file_multiblock_read_count 16
db_name                       pcard
db_recovery_file_dest         /dbpcardarch/pcard1
db_recovery_file_dest_size    128849018880
dispatchers                   (PROTOCOL=TCP) (SERVICE=pcard)
fal_client                    PCARDDR
fal_server                    PCARD
job_queue_processes           10
local_listener                PCARD_LSNR
log_archive_config            DG_CONFIG=(pcard,pcarddr)
log_archive_dest_1            LOCATION=/dbpcardarch/pcard1/PCAR
log_archive_dest_2            service=pcarddr async db_unique_n
log_archive_dest_state_2      ENABLE
open_cursors                  2000
pga_aggregate_target          1887436800
processes                     500
remote_listener               PCARD_LSNR
remote_login_passwordfile     EXCLUSIVE
sga_max_size                  9445572608
sga_target                    9445572608
spfile                        /dbpcard01/pcard01/oradata/pcard/
standby_file_management       AUTO
undo_management               AUTO
undo_tablespace               UNDOTBS1
user_dump_dest                /pcard18/admin/pcard/udump
          -------------------------------------------------------------

End of Report
</verbatim>
