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