Statspack Analyzer - Intelligent analysis of Oracle Statspack and AWR reports
Categories: Database Administration, Information Technology, OracleAfter spending a couple days picking through Oracle statspack reports for clues on what could be causing some database latency I finally got the chance to try out the new, free Statspack Analyzer from Texas Memory Systems, Inc. and Burleson Consulting.
StatspackAnalyzer.com is a FREE SITE provided to the Oracle community by sponsor companies including Texas Memory Systems, Inc. and Burleson Consulting.
…
Our shared goal is that the advice provided by this website evolves as community feedback indicates that the heuristics should be updated. If you like what you see, please let us know. If you don’t like what you see, please tell us what you would do to improve the site and which if any decision rules should be updated.
Just paste your whole statspack or AWR report into the analyzer and it will do the heavy lifting and give you custom recommendations on what areas you can possibly tune to increase performance. I had the chance to run several reports through the analyzer this week and it came up with many of the same conclusions I did in a fraction of the time.
Tools like this aren’t about to replace the DBA but rather help take the edge off intensive tasks like tuning. Check out the sample report to get a better idea of what the analyzer output looks like, or better yet try it out! After all, it’s free!
2 Responses to “Statspack Analyzer - Intelligent analysis of Oracle Statspack and AWR reports”
Leave a Reply
Story Pulse
January 4th, 2007 at 4:10 am
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ———– ———— ——– ————— ———– —
2947270502 PERFDB 1 27-Dec-06 08:14 10.2.0.2.0 NO
Host Name: ridley Num CPUs: 16 Phys Memory (MB): 65,335
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ———- —————— ——– ——— ——————-
Begin Snap: 1 27-Dec-06 08:22:18 22 3.2
End Snap: 2 27-Dec-06 09:00:03 24 3.0
Elapsed: 37.75 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ———- ———-
Buffer Cache: 1,248M Std Block Size: 8K
Shared Pool Size: 320M Log Buffer: 4,096K
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ ————— —————
Redo size: 483,188.79 7,761,862.47
Logical reads: 5,734.80 92,122.85
Block changes: 3,207.06 51,517.61
Physical reads: 48.22 774.57
Physical writes: 50.56 812.16
User calls: 2,097.90 33,700.34
Parses: 563.09 9,045.32
Hard parses: 0.31 4.93
Sorts: 9.70 155.89
Logons: 0.00 0.06
Executes: 1,317.88 21,170.17
Transactions: 0.06
% Blocks changed per Read: 55.92 Recursive Call %: 28.68
Rollback per transaction %: 0.00 Rows per Sort: 4.52
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.16 In-memory Sort %: 100.00
Library Hit %: 99.94 Soft Parse %: 99.95
Execute to Parse %: 57.27 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 89.11 % Non-Parse CPU: 96.26
Shared Pool Statistics Begin End
—— ——
Memory Usage %: 59.74 65.99
% SQL with executions>1: 69.75 65.16
% Memory for SQL w/exec>1: 67.16 63.68
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
—————————————– ———— ———– —— ——
CPU time 660 63.9
log file parallel write 2,145 186 87 18.0
db file parallel write 20,118 134 7 13.0
db file sequential read 56,877 19 0 1.9
log file sync 254 18 72 1.8
————————————————————-
Host CPU (CPUs: 16)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
——- ——- ——- ——- ——- ——- ——–
0.24 1.20 3.54 1.61 94.85 0.00 0.04
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 1.79
% of busy CPU for Instance: 34.74
%DB time waiting for CPU - Resource Mgr:
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ———— ————
Host Mem (MB): 65,334.7 65,334.7
SGA use (MB): 1,760.0 1,760.0
PGA use (MB): 44.5 53.4
% Host Mem used for SGA+PGA: 2.8 2.8
————————————————————-
Time Model System Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % of DB time
———————————– ——————– ————
DB CPU 596.2 93.6
sql execute elapsed time 500.0 78.5
parse time elapsed 33.4 5.2
PL/SQL execution elapsed time 15.4 2.4
hard parse elapsed time 1.2 .2
PL/SQL compilation elapsed time 0.1 .0
connection management call elapsed 0.0 .0
repeated bind elapsed time 0.0 .0
DB time 637.3
background elapsed time 351.9
background cpu time 51.9
————————————————————-
Wait Events DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
——————————— ———— —— ———- —— ——–
log file parallel write 2,145 0 186 87 15.2
db file parallel write 20,118 0 134 7 142.7
db file sequential read 56,877 0 19 0 403.4
log file sync 254 2 18 72 1.8
log buffer space 63 0 7 116 0.4
control file parallel write 1,080 0 4 3 7.7
db file scattered read 5,469 0 2 0 38.8
free buffer waits 48 94 1 17 0.3
log file switch completion 14 0 1 55 0.1
os thread startup 4 0 0 69 0.0
direct path write 53 0 0 3 0.4
latch free 1 0 0 42 0.0
control file sequential read 1,475 0 0 0 10.5
direct path read 42 0 0 0 0.3
log file single write 14 0 0 1 0.1
db file parallel read 2 0 0 9 0.0
LGWR wait for redo copy 268 0 0 0 1.9
rdbms ipc reply 65 0 0 0 0.5
virtual circuit status 75 100 2,184 29123 0.5
Streams AQ: qmn slave idle wait 80 0 2,178 27226 0.6
Streams AQ: qmn coordinator idle 160 50 2,178 13613 1.1
SQL*Net message from client 3,561,810 0 1,486 0 ########
jobq slave wait 2 50 5 2447 0.0
SQL*Net message to client 3,561,811 0 2 0 ########
SQL*Net more data from client 58,230 0 1 0 413.0
————————————————————-
Background Wait Events DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> %Timeouts: value of 0 indicates value was Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
——————————— ———— —— ———- —— ——–
log file parallel write 2,145 0 186 87 15.2
db file parallel write 20,118 0 134 7 142.7
control file parallel write 1,080 0 4 3 7.7
os thread startup 4 0 0 69 0.0
direct path write 42 0 0 4 0.3
direct path read 42 0 0 0 0.3
log file single write 14 0 0 1 0.1
control file sequential read 598 0 0 0 4.2
events in waitclass Other 268 0 0 0 1.9
db file sequential read 58 0 0 0 0.4
rdbms ipc message 14,556 85 34,545 2373 103.2
pmon timer 755 100 2,207 2923 5.4
Streams AQ: qmn slave idle wait 80 0 2,178 27226 0.6
Streams AQ: qmn coordinator idle 160 50 2,178 13613 1.1
smon timer 9 78 2,026 ###### 0.1
————————————————————-
Wait Event Histogram DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: 1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was Ordered by Event (idle events last)
Total —————– % of Waits ——————
Event Waits 1s
————————– —– —– —– —– —– —– —– —– —–
LGWR wait for redo copy 268 100.0
SQL*Net break/reset to cli 2 100.0
SQL*Net more data to clien 31 100.0
control file parallel writ 1080 97.6 2.1 .2 .1
control file sequential re 1475 100.0
db file parallel read 2 50.0 50.0
db file parallel write 20K 4.7 40.2 23.9 12.8 6.8 9.4 2.1 .0
db file scattered read 5469 98.4 .6 .4 .4 .1 .1 .0
db file sequential read 56K 97.8 .5 .3 .7 .2 .2 .3
direct path read 42 95.2 2.4 2.4
direct path write 53 81.1 1.9 9.4 3.8 3.8
free buffer waits 48 2.1 2.1 16.7 79.2
latch free 1 100.0
latch: library cache 2 100.0
latch: shared pool 1 100.0
log buffer space 63 1.6 12.7 85.7
log file parallel write 2145 8.9 8.6 2.7 2.1 2.0 75.7
log file sequential read 14 100.0
log file single write 14 100.0
log file switch completion 14 42.9 57.1
log file sync 254 2.0 10.6 18.5 8.7 9.1 51.2
os thread startup 4 100.0
rdbms ipc reply 65 100.0
SQL*Net message from clien 3561K 100.0 .0 .0 .0 .0 .0 .0
SQL*Net message to client 3561K 100.0
SQL*Net more data from cli 58K 100.0
Streams AQ: qmn coordinato 160 50.0 50.0
Streams AQ: qmn slave idle 80 100.0
class slave wait 3 100.0
dispatcher timer 37 100.0
jobq slave wait 2 100.0
pmon timer 756 .4 99.6
rdbms ipc message 14K 1.8 .1 .1 .5 .4 .4 29.2 67.6
smon timer 9 11.1 88.9
virtual circuit status 75 100.0
————————————————————-
SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 596
-> Captured SQL accounts for 84.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
———- ———— ———- —— ———- ————— ———-
213.12 555,234 0.00 35.7 215.11 4,668,256 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
40.23 26,056 0.00 6.7 40.23 2,136,731 2853949187
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
DEL_STS_IND from TGEN568
25.39 851,187 0.00 4.3 25.39 0 1876777081
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TRUNC(SYSDATE) FROM SYS.DUAL
25.05 20,209 0.00 4.2 28.35 1,308,535 3364479374
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
_CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
_NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
_AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS
23.77 113,549 0.00 4.0 23.88 1,184,877 304009201
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6
19.62 851,183 0.00 3.3 19.62 0 543962341
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL
18.41 32,252 0.00 3.1 19.54 595,263 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
11.64 32,252 0.00 2.0 11.64 162,581 2481065608
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
11.60 26,055 0.00 1.9 11.67 220,202 2260637923
SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 596
-> Captured SQL accounts for 84.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
———- ———— ———- —— ———- ————— ———-
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_
11.38 26,055 0.00 1.9 11.50 218,533 3132248938
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM
9.86 26,054 0.00 1.7 9.86 157,633 1477189672
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
:b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
=:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA
9.74 26,054 0.00 1.6 9.74 53,546 2408642227
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
_SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT
=:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT
9.70 26,054 0.00 1.6 9.70 105,952 2895558748
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI
L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT
9.54 26,055 0.00 1.6 9.54 131,083 3748955465
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
8.66 14,594 0.00 1.5 11.75 178,661 3625372575
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
SQL ordered by CPU DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 596
-> Captured SQL accounts for 84.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
———- ———— ———- —— ———- ————— ———-
R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)
6.42 19,325 0.00 1.1 11.16 107,299 1737386892
Module: unikixvsam@ridley (TNS V1-V3)
select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )
————————————————————-
SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 637
-> Captured SQL accounts for 81.7% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
———- ———— ———- —— ———- ————— ———-
215.11 555,234 0.00 33.8 213.12 3,099 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
40.23 26,056 0.00 6.3 40.23 16 2853949187
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
DEL_STS_IND from TGEN568
28.35 20,209 0.00 4.4 25.05 18,177 3364479374
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
_CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
_NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
_AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS
25.39 851,187 0.00 4.0 25.39 0 1876777081
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TRUNC(SYSDATE) FROM SYS.DUAL
23.88 113,549 0.00 3.7 23.77 969 304009201
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6
19.62 851,183 0.00 3.1 19.62 0 543962341
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL
19.54 32,252 0.00 3.1 18.41 8,867 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
11.75 14,594 0.00 1.8 8.66 9,771 3625372575
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)
SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 637
-> Captured SQL accounts for 81.7% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
———- ———— ———- —— ———- ————— ———-
11.67 26,055 0.00 1.8 11.60 558 2260637923
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_
11.64 32,252 0.00 1.8 11.64 0 2481065608
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
11.50 26,055 0.00 1.8 11.38 489 3132248938
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM
11.16 19,325 0.00 1.8 6.42 23,913 1737386892
Module: unikixvsam@ridley (TNS V1-V3)
select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )
9.86 26,054 0.00 1.5 9.86 1 1477189672
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
:b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
=:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA
9.74 26,054 0.00 1.5 9.74 0 2408642227
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
_SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT
=:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT
9.70 26,054 0.00 1.5 9.70 0 2895558748
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI
SQL ordered by Elapsed DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 637
-> Captured SQL accounts for 81.7% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
———- ———— ———- —— ———- ————— ———-
L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT
9.54 26,055 0.00 1.5 9.54 0 3748955465
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
————————————————————-
SQL ordered by Gets DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 12,989,322
-> Captured SQL accounts for 95.0% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
————— ———— ————– —— ——– ——— ———-
4,668,256 555,234 8.4 35.9 213.12 215.11 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
2,136,731 26,056 82.0 16.4 40.23 40.23 2853949187
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
DEL_STS_IND from TGEN568
1,308,535 20,209 64.8 10.1 25.05 28.35 3364479374
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
_CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
_NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
_AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS
1,184,877 113,549 10.4 9.1 23.77 23.88 304009201
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6
595,263 32,252 18.5 4.6 18.41 19.54 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
220,202 26,055 8.5 1.7 11.60 11.67 2260637923
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_
218,533 26,055 8.4 1.7 11.38 11.50 3132248938
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM
SQL ordered by Gets DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 12,989,322
-> Captured SQL accounts for 95.0% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
————— ———— ————– —— ——– ——— ———-
209,309 26,054 8.0 1.6 4.60 4.60 1280268270
Module: unikixvsam@ridley (TNS V1-V3)
select TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TAX_SVE_CSS_1_PCT ,B
IL_SVE_CSS_AMT ,TAX_SVE_CSS_1_AMT ,CRY_CDE ,TAX_SVE_CSS_2_PCT
,TAX_SVE_CSS_2_AMT ,TAX_SVE_CSS_3_PCT ,TAX_SVE_CSS_3_AMT ,T
AX_SVE_CSS_4_PCT ,TAX_SVE_CSS_4_AMT ,TAX_SVE_CSS_5_PCT ,TAX_S
VE_CSS_5_AMT ,TAX_SVE_CSS_6_PCT ,TAX_SVE_CSS_6_AMT ,TAX_SVE_C
178,661 14,594 12.2 1.4 8.66 11.75 3625372575
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)
162,581 32,252 5.0 1.3 11.64 11.64 2481065608
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
157,633 26,054 6.1 1.2 9.86 9.86 1477189672
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
:b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
=:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA
131,083 26,055 5.0 1.0 9.54 9.54 3748955465
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
————————————————————-
SQL ordered by Reads DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Disk Reads Threshold: 1000 Total Disk Reads: 109,214
-> Captured SQL accounts for 93.1% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
————— ———— ————– —— ——– ——— ———-
27,328 2 13,664.0 25.0 3.03 4.16 963101824
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,MHT_ITL_NBR ,CRY_CDE ,SLT_GRP_CDE ,SLT_N
BR ,CRD_SCM_IDN_CDE ,SLT_BFD_AMT ,SLT_BFD_TXN_NBR ,PNG_SLT_A
MT ,PNG_SLT_TXN_NBR ,SLT_AMT ,SLT_TXN_NBR ,SLT_UTL_DTE ,SLT
_DTE ,FCE_SLT_IND ,PMT_NOF_IND ,AVC_GRP_STS_CDE ,IDV_PMT_IND
,FLX_PMT_IND ,SLT_DEY_NBR ,ITN_SLT_AMT ,ITN_SLT_BFD_AMT ,L
23,913 19,325 1.2 21.9 6.42 11.16 1737386892
Module: unikixvsam@ridley (TNS V1-V3)
select TXN_SKY ,TXN_IDN_CDE ,ITN_TXN_TOT_AMT ,TXN_CSS_CDE ,S
LT_TXN_TOT_AMT ,TXN_POS_IND ,OGL_TXN_TOT_AMT ,OGL_CRY_CDE ,C
RD_SCM_IDN_CDE ,SLT_NBR ,TXN_SRC_CDE from TGEN509 where ((((
((ITN_IDN_CDE=:b1 and SLT_MHT_ITL_NBR=:b2) and SLT_GRP_CDE=:b3)
and SLT_CRY_CDE=:b4) and IDV_PMT_IND=’1′) and SLT_NBR is null )
18,177 20,209 0.9 16.6 25.05 28.35 3364479374
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TXN_TYP
_CDE ,CRD_TYP_CDE ,CPR_MHD_ITL_CDE ,PMT_MDE_CDE ,OGL_TXN_TOT
_NBR ,OGL_CRY_CDE ,OGL_TXN_TOT_AMT ,OGL_MHT_ITL_NBR ,TXN_MNM
_AMT ,TOT_TXF_AMT from TGEN624 where TXN_SKY=:b1 for update o
f BIL_MHT_ITL_NBR,BIL_NBR,LST_UPD_DTE,LST_UPD_TME,LST_UPD_UID,LS
9,771 14,594 0.7 8.9 8.66 11.75 3625372575
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN590 set AVC_GRP_STS_CDE=:b1,SLT_RST_IDN_CDE=:b2,LST_
UPD_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UI
D=:b3,LST_UPD_NBR=:b4 where ((((((ITN_IDN_CDE=:b5 and MHT_ITL_NB
R=:b6) and CRY_CDE=:b7) and SLT_GRP_CDE=:b8) and SLT_NBR=:b9) an
d CRD_SCM_IDN_CDE=:b10) and LST_UPD_NBR=:b11)
8,867 32,252 0.3 8.1 18.41 19.54 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
3,892 1 3,892.0 3.6 0.23 0.24 2792573995
Module: SQL*Plus
select count(*) from tgen593_bkp
3,099 555,234 0.0 2.8 213.12 215.11 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
1,753 2,950 0.6 1.6 0.76 0.83 224108471
Module: unikixvsam@ridley (TNS V1-V3)
SQL ordered by Reads DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Disk Reads Threshold: 1000 Total Disk Reads: 109,214
-> Captured SQL accounts for 93.1% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
————— ———— ————– —— ——– ——— ———-
select PNG_SLT_TXN_NBR ,SLT_TXN_NBR ,SLT_RST_IDN_CDE ,IDV_PMT
_IND ,LST_UPD_NBR into :b1,:b2,:b3,:b4,:b5 from TGEN590 wher
e (((((ITN_IDN_CDE=:b6 and MHT_ITL_NBR=:b7) and CRY_CDE=:b8) and
SLT_GRP_CDE=:b9) and SLT_NBR=:b10) and CRD_SCM_IDN_CDE=:b11)
————————————————————-
SQL ordered by Executions DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Executions Threshold: 100 Total Executions: 2,984,994
-> Captured SQL accounts for 100.1% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
———— ————— —————- ———– ———- ———-
851,187 851,187 1.0 0.00 0.00 1876777081
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TRUNC(SYSDATE) FROM SYS.DUAL
851,183 851,183 1.0 0.00 0.00 543962341
Module: unikixvsam@ridley (TNS V1-V3)
SELECT TO_CHAR(SYSDATE,’HH24.MI.SS’) FROM SYS.DUAL
555,234 555,234 1.0 0.00 0.00 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
113,549 113,549 1.0 0.00 0.00 304009201
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6
32,252 32,252 1.0 0.00 0.00 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
32,252 32,252 1.0 0.00 0.00 2481065608
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
32,252 32,252 1.0 0.00 0.00 3279785947
Module: unikixvsam@ridley (TNS V1-V3)
select LST_PMT_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)
————————————————————-
SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
-> Captured SQL accounts for 100.0% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
———— ———— ——– ———-
555,234 555,234 43.53 908225952
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN624 set BIL_NBR=:b1:i1,BIL_MHT_ITL_NBR=:b2:i2,LST_UP
D_DTE=ESS_CURRENT_DATE,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=
:b3,LST_UPD_NBR=(LST_UPD_NBR+1) where rowid =
113,549 113,549 8.90 304009201
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN632(ITN_IDN_CDE,MHT_ITL_NBR,CRY_CDE,RCN_DTE,SAP_
AVY_CDE,SAP_TOT_AMT,SAP_TXN_NBR,TXN_CSS_CDE,TXN_IDN_CDE,OGL_TXN_
TOT_AMT,OGL_CRY_CDE,ITN_TXN_TOT_AMT,CPR_MHD_ITL_CDE,SLT_GRP_CDE,
CRD_SCM_IDN_CDE,OGL_TXN_BSE_AMT,PMT_ODR_NBR,NON_MKP_SLT_AMT,ORN_
SRC_CDE,P_ITN_ALS_NBR,P_PTT_NBR) values (:b1,:b2,:b3,:b4,:b5,:b6
32,252 32,252 2.53 2084546057
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN521(ITN_IDN_CDE,PMT_ODR_NBR,MHT_ITL_NBR,CRY_CDE,
OGL_PMT_AMT,PNG_PMT_AMT,SPT_PMT_CDE,ACT_SEQ_NBR,ODR_GTD_DTE,ODR_
DUE_DTE,CHG_GRC_DTE,LST_CGE_DTE,ODR_STS_CDE,OVD_MNLPMT_BLK_CDE,F
CE_SLT_IND,TAX_1_AMT,SLT_GRP_CDE,BNK_ACT_NBR_TXT,MGE_IND,ISG_DTE
,ITN_PNG_PMT_AMT,TAX_2_AMT,TAX_3_AMT,TAX_4_AMT,TAX_5_AMT,TAX_6_A
32,252 32,252 2.53 2481065608
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_PMT_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
32,252 32,252 2.53 3279785947
Module: unikixvsam@ridley (TNS V1-V3)
select LST_PMT_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)
26,056 26,056 2.04 2853949187
Module: unikixvsam@ridley (TNS V1-V3)
select ITN_IDN_CDE ,GL_RCD_TYP_CDE ,GL_SRC_CDE ,GL_DST_CDE ,
DEL_STS_IND from TGEN568
26,055 26,055 2.04 2260637923
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN619(ITN_IDN_CDE,BIL_NBR,TAX_SVE_CSS_CDE,TAX_FEE_
INC_IND,MHT_ITL_NBR,TAX_SVE_CSS_1_PCT,BIL_SVE_CSS_AMT,TAX_SVE_CS
S_1_AMT,CRY_CDE,TAX_SVE_CSS_2_PCT,TAX_SVE_CSS_2_AMT,TAX_SVE_CSS_
3_PCT,TAX_SVE_CSS_3_AMT,TAX_SVE_CSS_4_PCT,TAX_SVE_CSS_4_AMT,TAX_
SVE_CSS_5_PCT,TAX_SVE_CSS_5_AMT,TAX_SVE_CSS_6_PCT,TAX_SVE_CSS_6_
26,055 26,055 2.04 2560418031
Module: unikixvsam@ridley (TNS V1-V3)
select LST_BIL_NBR ,LST_UPD_NBR into :b1,:b2 from TGEN534 wh
ere (ITN_IDN_CDE=:b3 and MHT_ITL_NBR=:b4)
26,055 26,055 2.04 3064314749
SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
-> Captured SQL accounts for 100.0% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
———— ———— ——– ———-
Module: unikixvsam@ridley (TNS V1-V3)
select BIL_NBR into :b1 from TGEN620 where ((ITN_IDN_CDE=:b2
and BIL_NBR=:b1) and MHT_ITL_NBR=:b3)
26,055 26,055 2.04 3132248938
Module: unikixvsam@ridley (TNS V1-V3)
insert into TGEN620(ITN_IDN_CDE,BIL_NBR,MHT_ITL_NBR,BIL_DTE,BIL_
CTT_TYP_CDE,CTT_IDN_NBR,BIL_TOT_AMT,TAX_BIL_TOT_1_AMT,BIL_STS_CD
E,BIL_SAE_INL_DTE,CRY_CDE,PMT_ODR_NBR,SLT_AVC_NBR,TAX_BIL_TOT_2_
AMT,TAX_BIL_TOT_3_AMT,TAX_BIL_TOT_4_AMT,TAX_BIL_TOT_5_AMT,TAX_BI
L_TOT_6_AMT,TAX_BIL_TOT_7_AMT,TAX_BIL_TOT_8_AMT,TAX_BIL_TOT_9_AM
26,055 26,055 2.04 3748955465
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN534 set LST_BIL_NBR=:b1,LST_UPD_DTE=ESS_CURRENT_DATE
,LST_UPD_TME=ESS_CURRENT_TIME,LST_UPD_UID=:b2,LST_UPD_NBR=:b3 wh
ere ((ITN_IDN_CDE=:b4 and MHT_ITL_NBR=:b5) and LST_UPD_NBR=:b6)
26,054 26,054 2.04 183421324
Module: unikixvsam@ridley (TNS V1-V3)
select DFT_TAX_SCM_IND into :b1 from TGEN522 where ITN_IDN_CD
E=:b2
26,054 26,054 2.04 1280268270
Module: unikixvsam@ridley (TNS V1-V3)
select TAX_SVE_CSS_CDE ,TAX_FEE_INC_IND ,TAX_SVE_CSS_1_PCT ,B
IL_SVE_CSS_AMT ,TAX_SVE_CSS_1_AMT ,CRY_CDE ,TAX_SVE_CSS_2_PCT
,TAX_SVE_CSS_2_AMT ,TAX_SVE_CSS_3_PCT ,TAX_SVE_CSS_3_AMT ,T
AX_SVE_CSS_4_PCT ,TAX_SVE_CSS_4_AMT ,TAX_SVE_CSS_5_PCT ,TAX_S
VE_CSS_5_AMT ,TAX_SVE_CSS_6_PCT ,TAX_SVE_CSS_6_AMT ,TAX_SVE_C
26,054 26,054 2.04 1477189672
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN521 set PNG_PMT_AMT=(PNG_PMT_AMT+:b1),OGL_PMT_AMT=(O
GL_PMT_AMT+:b2),ITN_PNG_PMT_AMT=(ITN_PNG_PMT_AMT+:b3),TAX_1_AMT=
:b4,TAX_2_AMT=:b5:i5,TAX_3_AMT=:b6:i6,TAX_4_AMT=:b7:i7,TAX_5_AMT
=:b8:i8,TAX_6_AMT=:b9:i9,TAX_7_AMT=:b10:i10,TAX_8_AMT=:b11:i11,T
AX_9_AMT=:b12:i12,TAX_10_AMT=:b13:i13,LST_UPD_DTE=ESS_CURRENT_DA
26,054 26,054 2.04 2020074211
Module: unikixvsam@ridley (TNS V1-V3)
select MHT_EXT_TXT ,MHT_NME_TXT ,LCN_CTT_TYP_CDE ,LCN_CTT_IDN
_NBR ,BIL_CTT_TYP_CDE ,BIL_CTT_IDN_NBR ,AVC_CTT_IDN_NBR ,TAX
_SCM_CDE ,MHT_STO_IDN_TXT into :b1,:b2,:b3,:b4,:b5:i5,:b6:i6,
:b7:i7,:b8:i8,:b9:i9 from TGEN534 where (ITN_IDN_CDE=:b10 and M
HT_ITL_NBR=:b11)
26,054 26,054 2.04 2408642227
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN619 set BIL_SVE_CSS_AMT=(BIL_SVE_CSS_AMT+:b1),TAX_SV
E_CSS_1_AMT=(TAX_SVE_CSS_1_AMT+:b2),TAX_SVE_CSS_2_AMT=:b3:i3,TAX
_SVE_CSS_3_AMT=:b4:i4,TAX_SVE_CSS_4_AMT=:b5:i5,TAX_SVE_CSS_5_AMT
SQL ordered by Parse Calls DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> End Parse Calls Threshold: 1000 Total Parse Calls: 1,275,390
-> Captured SQL accounts for 100.0% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
———— ———— ——– ———-
=:b6:i6,TAX_SVE_CSS_6_AMT=:b7:i7,TAX_SVE_CSS_7_AMT=:b8:i8,TAX_SV
E_CSS_8_AMT=:b9:i9,TAX_SVE_CSS_9_AMT=:b10:i10,TAX_SVE_CSS_10_AMT
26,054 26,054 2.04 2895558748
Module: unikixvsam@ridley (TNS V1-V3)
update TGEN620 set BIL_CTT_TYP_CDE=:b1:i1,CTT_IDN_NBR=:b2:i2,BI
L_TOT_AMT=:b3,TAX_BIL_TOT_1_AMT=:b4:i4,TAX_BIL_TOT_2_AMT=:b5:i5,
TAX_BIL_TOT_3_AMT=:b6:i6,TAX_BIL_TOT_4_AMT=:b7:i7,TAX_BIL_TOT_5_
AMT=:b8:i8,TAX_BIL_TOT_6_AMT=:b9:i9,TAX_BIL_TOT_7_AMT=:b10:i10,T
AX_BIL_TOT_8_AMT=:b11:i11,TAX_BIL_TOT_9_AMT=:b12:i12,TAX_BIL_TOT
————————————————————-
Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
Statistic Total per Second per Trans
——————————— —————— ————– ————
CPU used by this session 65,983 29.1 468.0
CPU used when call started 65,624 29.0 465.4
CR blocks created 392 0.2 2.8
DB time 69,204 30.6 490.8
DBWR checkpoint buffers written 22,328 9.9 158.4
DBWR checkpoints 7 0.0 0.1
DBWR object drop buffers written 0 0.0 0.0
DBWR thread checkpoint buffers wr 2,262 1.0 16.0
DBWR transaction table writes 64 0.0 0.5
DBWR undo block writes 56,743 25.1 402.4
IMU Flushes 133 0.1 0.9
IMU Redo allocation size 6,289,300 2,776.7 44,605.0
IMU commits 2 0.0 0.0
IMU pool not allocated 4 0.0 0.0
IMU recursive-transaction flush 3 0.0 0.0
IMU undo allocation size 5,521,040 2,437.6 39,156.3
IMU- failed to get a private stra 4 0.0 0.0
SQL*Net roundtrips to/from client 3,561,967 1,572.6 25,262.2
active txn count during cleanout 31,629 14.0 224.3
application wait time 0 0.0 0.0
background checkpoints completed 6 0.0 0.0
background checkpoints started 7 0.0 0.1
background timeouts 12,464 5.5 88.4
branch node splits 40 0.0 0.3
buffer is not pinned count 1,672,854 738.6 11,864.2
buffer is pinned count 1,844,723 814.5 13,083.1
bytes received via SQL*Net from c 945,431,351 417,409.0 6,705,186.9
bytes sent via SQL*Net to client 613,577,860 270,895.3 4,351,616.0
calls to get snapshot scn: kcmgss 3,109,876 1,373.0 22,055.9
calls to kcmgas 145,153 64.1 1,029.5
calls to kcmgcs 29,302 12.9 207.8
change write time 4,534 2.0 32.2
cleanout - number of ktugct calls 38,952 17.2 276.3
cleanouts only - consistent read 2,535 1.1 18.0
cluster key scan block gets 7,816 3.5 55.4
cluster key scans 3,238 1.4 23.0
commit batch/immediate performed 7 0.0 0.1
commit batch/immediate requested 7 0.0 0.1
commit cleanout failures: block l 1 0.0 0.0
commit cleanout failures: buffer 107 0.1 0.8
commit cleanout failures: callbac 809 0.4 5.7
commit cleanouts 96,358 42.5 683.4
commit cleanouts successfully com 95,441 42.1 676.9
commit immediate performed 7 0.0 0.1
commit immediate requested 7 0.0 0.1
commit txn count during cleanout 13,625 6.0 96.6
concurrency wait time 27 0.0 0.2
consistent changes 259 0.1 1.8
consistent gets 4,568,022 2,016.8 32,397.3
consistent gets - examination 1,013,924 447.7 7,191.0
consistent gets from cache 4,568,022 2,016.8 32,397.3
cursor authentications 260 0.1 1.8
data blocks consistent reads - un 259 0.1 1.8
db block changes 7,263,983 3,207.1 51,517.6
db block gets 8,421,302 3,718.0 59,725.6
db block gets direct 4,638 2.1 32.9
Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
Statistic Total per Second per Trans
——————————— —————— ————– ————
db block gets from cache 8,416,664 3,716.0 59,692.7
deferred (CURRENT) block cleanout 84,027 37.1 595.9
dirty buffers inspected 54,301 24.0 385.1
enqueue conversions 528 0.2 3.7
enqueue releases 36,257 16.0 257.1
enqueue requests 36,271 16.0 257.2
enqueue waits 0 0.0 0.0
execute count 2,984,994 1,317.9 21,170.2
failed probes on index block recl 53 0.0 0.4
free buffer inspected 189,325 83.6 1,342.7
free buffer requested 254,763 112.5 1,806.8
global undo segment hints helped 1 0.0 0.0
heap block compress 128,057 56.5 908.2
hot buffers moved to head of LRU 19,217 8.5 136.3
immediate (CR) block cleanout app 2,535 1.1 18.0
immediate (CURRENT) block cleanou 42,070 18.6 298.4
index fast full scans (full) 4 0.0 0.0
index fetch by key 397,619 175.6 2,820.0
index scans kdiixs1 133,595 59.0 947.5
leaf node 90-10 splits 44 0.0 0.3
leaf node splits 7,574 3.3 53.7
lob reads 438 0.2 3.1
lob writes 56 0.0 0.4
lob writes unaligned 56 0.0 0.4
logons cumulative 9 0.0 0.1
messages received 22,453 9.9 159.2
messages sent 22,453 9.9 159.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 3,210,075 1,417.3 22,766.5
opened cursors cumulative 1,282,513 566.2 9,095.8
parse count (failures) 0 0.0 0.0
parse count (hard) 695 0.3 4.9
parse count (total) 1,275,390 563.1 9,045.3
parse time cpu 2,471 1.1 17.5
parse time elapsed 2,773 1.2 19.7
physical read IO requests 62,540 27.6 443.6
physical read bytes 894,681,088 395,002.7 6,345,255.9
physical read total IO requests 64,038 28.3 454.2
physical read total bytes 918,913,024 405,701.1 6,517,113.7
physical read total multi block r 5,469 2.4 38.8
physical reads 109,214 48.2 774.6
physical reads cache 109,172 48.2 774.3
physical reads cache prefetch 46,826 20.7 332.1
physical reads direct 42 0.0 0.3
physical reads prefetch warmup 12,265 5.4 87.0
physical write IO requests 36,912 16.3 261.8
physical write bytes 938,098,688 414,171.6 6,653,182.2
physical write total IO requests 43,210 19.1 306.5
physical write total bytes 2,123,482,112 937,519.7 ############
physical write total multi block 14,767 6.5 104.7
physical writes 114,514 50.6 812.2
physical writes direct 4,680 2.1 33.2
physical writes from cache 109,834 48.5 779.0
physical writes non checkpoint 109,805 48.5 778.8
pinned buffers inspected 22 0.0 0.2
prefetch warmup blocks aged out b 5,355 2.4 38.0
Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
Statistic Total per Second per Trans
——————————— —————— ————– ————
prefetch warmup blocks flushed ou 0 0.0 0.0
prefetched blocks aged out before 1 0.0 0.0
process last non-idle time 2,282 1.0 16.2
recursive calls 1,910,717 843.6 13,551.2
recursive cpu usage 10,596 4.7 75.2
redo blocks written 2,211,508 976.4 15,684.5
redo buffer allocation retries 87 0.0 0.6
redo entries 3,646,960 1,610.1 25,865.0
redo log space requests 25 0.0 0.2
redo log space wait time 78 0.0 0.6
redo ordering marks 60,610 26.8 429.9
redo size 1,094,422,608 483,188.8 7,761,862.5
redo synch time 1,862 0.8 13.2
redo synch writes 764 0.3 5.4
redo wastage 629,104 277.8 4,461.7
redo write time 19,010 8.4 134.8
redo writer latching time 1 0.0 0.0
redo writes 2,145 1.0 15.2
rollback changes - undo records a 14 0.0 0.1
rollbacks only - consistent read 258 0.1 1.8
rows fetched via callback 250,822 110.7 1,778.9
session connect time 834 0.4 5.9
session cursor cache hits 1,109,035 489.6 7,865.5
session logical reads 12,989,322 5,734.8 92,122.9
session pga memory 4,852,112 2,142.2 34,412.1
session pga memory max 8,194,448 3,617.9 58,116.7
session uga memory 2,947,600 1,301.4 20,905.0
session uga memory max 15,180,496 6,702.2 107,663.1
shared hash latch upgrades - no w 403,158 178.0 2,859.3
sorts (memory) 21,980 9.7 155.9
sorts (rows) 99,305 43.8 704.3
sql area evicted 88 0.0 0.6
sql area purged 4 0.0 0.0
summed dirty queue length 548,246 242.1 3,888.3
switch current to new buffer 72,792 32.1 516.3
table fetch by rowid 1,589,583 701.8 11,273.6
table fetch continued row 190 0.1 1.4
table scan blocks gotten 2,125,962 938.6 15,077.7
table scan rows gotten 237,067,264 104,665.5 1,681,328.1
table scans (long tables) 6 0.0 0.0
table scans (rowid ranges) 3 0.0 0.0
table scans (short tables) 26,576 11.7 188.5
total number of times SMON posted 2 0.0 0.0
transaction rollbacks 7 0.0 0.1
undo change vector size 420,479,700 185,642.3 2,982,125.5
user I/O wait time 2,089 0.9 14.8
user calls 4,751,748 2,097.9 33,700.3
user commits 141 0.1 1.0
workarea executions - optimal 8,445 3.7 59.9
write clones created in foregroun 92 0.0 0.7
————————————————————-
Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
——————————— ————— —————
logons current 22 24
opened cursors current 70 72
session cursor cache count 291 420
workarea memory allocated 0 2,188
————————————————————-
Instance Activity Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> Statistics identified by ‘(derived)’ come from sources other than SYSSTAT
Statistic Total per Hour
——————————— —————— ———
log switches (derived) 7 11.13
————————————————————-
OS Statistics DB/Inst: PERFDB/PERFDB Snaps: 1-2
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name
Statistic Total
————————- ———————-
BUSY_TIME 186,569
IDLE_TIME 3,436,330
SYS_TIME 58,213
USER_TIME 128,356
LOAD 1
OS_CPU_WAIT_TIME 1,500
VM_IN_BYTES 40,960
PHYSICAL_MEMORY_BYTES 68,508,418,048
NUM_CPUS 16
————————————————————-
Tablespace IO Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
->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)
————– ——- —— ——- ———— ——– ———- ——
CGEN_IDX
33,656 15 0.4 1.3 10,315 5 0 0.0
CGEN
27,645 12 0.3 2.3 8,253 4 0 0.0
UNDOTBS1
43 0 1.2 1.0 16,782 7 0 0.0
SYSTEM
3,994 2 0.0 1.2 339 0 0 0.0
PERFSTAT
604 0 0.0 1.7 1,329 1 0 0.0
SYSAUX
759 0 0.0 2.3 241 0 0 0.0
CGEN_CLOB
12 0 2.5 1.0 8 0 0 0.0
TMPSPACE
1 0 0.0 1.0 0 0 0 0.0
————————————————————-
File IO Stats DB/Inst: PERFDB/PERFDB Snaps: 1-2
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File
Tablespace Filename
———————— —————————————————-
Av Mx
June 27th, 2007 at 10:40 am
It is quite a useful report but notice how often it mentions solid state disks - and the main sponsor is Texas Memory Systems - who sell SSD.
I find it useful for conforming my own analysis. I do wish there was a good reference to reading an AWR report though
John