WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
BXGRID1854997517bxgrid2210.2.0.5.0YESdqpicc06

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1592917-Aug-12 07:59:2049 10.1
End Snap:1593217-Aug-12 10:59:5847 7.1
Elapsed:  180.63 (mins)  
DB Time:  3.38 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 3,760M 3,760MStd Block Size: 8K
Shared Pool Size: 1,008M 1,008MLog Buffer: 14,356K

Load Profile

Per SecondPer Transaction
Redo size: 3,247.28 17,918.79
Logical reads: 394.13 2,174.85
Block changes: 16.59 91.53
Physical reads: 0.97 5.34
Physical writes: 0.68 3.73
User calls: 5.08 28.01
Parses: 3.43 18.95
Hard parses: 0.23 1.25
Sorts: 1.59 8.75
Logons: 0.14 0.78
Executes: 8.10 44.71
Transactions: 0.18 

% Blocks changed per Read: 4.21Recursive Call %: 82.54
Rollback per transaction %: 34.47Rows per Sort: 40.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.76In-memory Sort %: 100.00
Library Hit %: 95.79Soft Parse %: 93.42
Execute to Parse %: 57.62Latch Hit %: 99.91
Parse CPU to Parse Elapsd %: 92.00% Non-Parse CPU: 92.35

Shared Pool Statistics

BeginEnd
Memory Usage %: 77.95 72.63
% SQL with executions>1: 95.83 90.36
% Memory for SQL w/exec>1: 94.34 87.76

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  128  63.0 
name-service call wait 371 24 64 11.6Other
DFS lock handle 1,998 21 10 10.3Other
control file parallel write 3,616 20 5 9.6System I/O
SQL*Net break/reset to client 38 16 411 7.7Application

RAC Statistics

BeginEnd
Number of Instances: 4 4

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 2.38 13.11
Global Cache blocks served: 7.71 42.56
GCS/GES messages received: 42.84 236.41
GCS/GES messages sent: 25.18 138.92
DBWR Fusion writes: 0.07 0.37
Estd Interconnect traffic (KB) 94.00 

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.16
Buffer access - remote cache %: 0.60
Buffer access - disk %: 0.24

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.5
Avg global cache cr block receive time (ms): 0.3
Avg global cache current block receive time (ms): 0.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.8
Avg global cache cr block flush time (ms): 4.2
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 4.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 32.08
% of indirect sent messages: 51.82
% of flow controlled messages: 16.09

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 138.66 68.36
DB CPU 127.73 62.97
parse time elapsed 12.95 6.38
hard parse elapsed time 11.13 5.49
PL/SQL execution elapsed time 1.67 0.82
PL/SQL compilation elapsed time 1.17 0.58
hard parse (sharing criteria) elapsed time 1.13 0.56
connection management call elapsed time 1.05 0.52
hard parse (bind mismatch) elapsed time 0.07 0.04
sequence load elapsed time 0.05 0.02
repeated bind elapsed time 0.01 0.01
failed parse elapsed time 0.00 0.00
DB time 202.83  
background elapsed time 126.84  
background cpu time 80.25  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     128   62.97
Other 1,424,331 97 64 0 31.71
System I/O 40,878   47 1 23.37
User I/O 5,604   16 3 8.01
Application 940   16 17 7.77
Concurrency 8,506 0 15 2 7.54
Cluster 31,798   10 0 4.97
Commit 1,315 1 7 5 3.52
Network 54,279   0 0 0.22
Configuration 57   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
name-service call wait 371   24 64 0.19
DFS lock handle 1,998 0 21 10 1.02
control file parallel write 3,616   20 5 1.84
SQL*Net break/reset to client 38   16 411 0.02
os thread startup 201 1 14 67 0.10
log file parallel write 3,386   13 4 1.72
db file sequential read 3,867   12 3 1.97
CGS wait for IPC msg 1,325,055 99 9 0 674.67
log file sync 1,315 1 7 5 0.67
control file sequential read 28,989   7 0 14.76
db file parallel write 4,773   6 1 2.43
Streams AQ: qmn coordinator waiting for slave to start 1 100 5 4889 0.00
gc cr multi block request 8,561   4 0 4.36
db file scattered read 938   3 3 0.48
enq: WF - contention 54 2 2 34 0.03
Log archive I/O 68   1 21 0.03
gc current block 3-way 4,406   1 0 2.24
gc cr block 3-way 4,356   1 0 2.22
db file parallel read 653   1 2 0.33
gc cr block 2-way 5,192   1 0 2.64
gc current block 2-way 4,957   1 0 2.52
library cache lock 5,980   1 0 3.04
log file sequential read 42   1 23 0.02
PX Deq: reap credit 63,293 90 1 0 32.23
IPC send completion sync 2,047 100 1 0 1.04
enq: PS - contention 3,369   1 0 1.72
row cache lock 1,947   1 0 0.99
gcs log flush sync 496 1 1 1 0.25
gc cr block busy 50   0 8 0.03
gc current grant busy 1,094   0 0 0.56
SQL*Net more data from client 379   0 1 0.19
gc current block busy 80   0 4 0.04
reliable message 1,215   0 0 0.62
gc cr grant 2-way 2,183   0 0 1.11
PX Deq Credit: send blkd 3,916 79 0 0 1.99
enq: TM - contention 902   0 0 0.46
latch free 239   0 1 0.12
SQL*Net more data to client 6,318   0 0 3.22
ksxr poll remote instances 14,632 68 0 0 7.45
gc current grant 2-way 801   0 0 0.41
gc buffer busy 4   0 17 0.00
enq: TT - contention 460   0 0 0.23
latch: ges resource hash list 6,146   0 0 3.13
CSS operation: query 24   0 2 0.01
enq: PI - contention 248   0 0 0.13
SQL*Net message to client 47,582   0 0 24.23
latch: session allocation 77   0 0 0.04
enq: CF - contention 102   0 0 0.05
library cache pin 60   0 0 0.03
latch: shared pool 89   0 0 0.05
enq: TX - index contention 9   0 2 0.00
CSS initialization 8   0 1 0.00
rdbms ipc reply 85   0 0 0.04
enq: HW - contention 56   0 0 0.03
latch: library cache 32   0 0 0.02
gc current block congested 1   0 5 0.00
gc current multi block request 111   0 0 0.06
cursor: pin S 32   0 0 0.02
CSS operation: action 16   0 0 0.01
KJC: Wait for msg sends to complete 188   0 0 0.10
PX Deq: Signal ACK 80 34 0 0 0.04
enq: FB - contention 20   0 0 0.01
log file single write 4   0 1 0.00
gc current split 2   0 1 0.00
latch: enqueue hash chains 6   0 0 0.00
latch: cache buffers chains 179   0 0 0.09
enq: JS - job run lock - synchronize 4   0 0 0.00
latch: library cache lock 9   0 0 0.00
LGWR wait for redo copy 53   0 0 0.03
latch: cache buffers lru chain 2   0 0 0.00
PX qref latch 57 46 0 0 0.03
enq: AF - task serialization 2   0 0 0.00
latch: KCL gc element parent latch 12   0 0 0.01
enq: TA - contention 2   0 0 0.00
latch: gcs resource hash 11   0 0 0.01
direct path read 119   0 0 0.06
enq: WL - contention 1   0 0 0.00
enq: IR - contention 1   0 0 0.00
enq: TX - allocate ITL entry 1   0 0 0.00
direct path write 27   0 0 0.01
enq: TQ - TM contention 1   0 0 0.00
latch: redo allocation 3   0 0 0.00
latch: object queue header operation 2   0 0 0.00
latch: messages 2   0 0 0.00
SQL*Net message from client 47,962   131,959 2751 24.42
PX Idle Wait 23,307 95 55,695 2390 11.87
gcs remote message 857,693 74 21,152 25 436.71
Streams AQ: qmn slave idle wait 387 0 10,626 27457 0.20
DIAG idle wait 53,595   10,582 197 27.29
ASM background timer 2,170   10,582 4876 1.10
ges remote message 208,140 48 10,570 51 105.98
Streams AQ: qmn coordinator idle wait 637 62 10,561 16579 0.32
class slave wait 219 86 10,537 48115 0.11
virtual circuit status 361 100 10,530 29168 0.18
Streams AQ: waiting for time management or cleanup tasks 98 99 8,352 85221 0.05
jobq slave wait 121 99 353 2915 0.06
PX Deq: Execution Msg 6,644 21 118 18 3.38
PX Deq: Msg Fragment 4,416 35 2 0 2.25
PX Deq: Join ACK 1,455 32 0 0 0.74
PX Deq: Parse Reply 990 20 0 0 0.50
KSV master wait 8   0 17 0.00
PX Deq: Execute Reply 1,251 40 0 0 0.64
PX Deq Credit: need buffer 195 93 0 0 0.10
Streams AQ: RAC qmn coordinator idle wait 782 100 0 0 0.40

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 3,616   20 5 1.84
events in waitclass Other 1,343,953 98 15 0 684.29
log file parallel write 3,388   13 4 1.73
os thread startup 127   6 49 0.06
control file sequential read 27,321   6 0 13.91
db file parallel write 4,773   6 1 2.43
Log archive I/O 68   1 21 0.03
log file sequential read 42   1 23 0.02
enq: TM - contention 902   0 0 0.46
db file sequential read 36   0 3 0.02
gc cr block 3-way 388   0 0 0.20
gc current block 2-way 292   0 0 0.15
gc current block 3-way 198   0 0 0.10
gc cr block 2-way 140   0 0 0.07
library cache lock 74   0 0 0.04
row cache lock 41   0 0 0.02
gc current grant busy 40   0 0 0.02
log file single write 4   0 1 0.00
gc current grant 2-way 28   0 0 0.01
latch: cache buffers chains 167   0 0 0.09
gc cr multi block request 2   0 0 0.00
gc buffer busy 1   0 0 0.00
gc cr grant 2-way 1   0 0 0.00
rdbms ipc message 172,586 82 146,668 850 87.87
gcs remote message 857,620 74 21,153 25 436.67
DIAG idle wait 53,595   10,582 197 27.29
ASM background timer 2,170   10,582 4876 1.10
pmon timer 4,900 100 10,578 2159 2.49
ges remote message 208,140 48 10,570 51 105.98
Streams AQ: qmn coordinator idle wait 637 62 10,561 16579 0.32
class slave wait 196 96 10,537 53761 0.10
smon timer 37 97 10,401 281116 0.02
Streams AQ: waiting for time management or cleanup tasks 98 99 8,352 85221 0.05
KSV master wait 8   0 17 0.00
Streams AQ: RAC qmn coordinator idle wait 782 100 0 0 0.40

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 6,914
AVG_IDLE_TIME 1,076,219
AVG_IOWAIT_TIME 1,645
AVG_SYS_TIME 3,443
AVG_USER_TIME 3,160
BUSY_TIME 57,897
IDLE_TIME 8,612,335
IOWAIT_TIME 15,786
SYS_TIME 30,095
USER_TIME 27,802
LOAD 0
OS_CPU_WAIT_TIME 3.0E+11
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 18,059,264
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 17,109,544,960
NUM_CPUS 8
NUM_CPU_SOCKETS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
bxgrid 180.00 120.70 12,759 3,630,291
SYS$USERS 22.70 6.80 0 96
SYS$BACKGROUND 0.20 0.30 64 82,507
bxgridXDB 0.00 0.00 0 0
srv_bxgrid 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
bxgrid 5432 16 5805 8 0 0 52425 0
SYS$USERS 0 0 1264 0 0 0 360 0
SYS$BACKGROUND 171 0 1422 7 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
20 0 3 6.75 9.98 8w2ww0j6wabqf JDBC Thin Client BEGIN :1 := f_grgzze1(:2, :3, ...
20 0 3 6.74 9.97 5nr9kftsfkk3v JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...
12 5 2 5.84 5.76 94dqvpj2mmh35 JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
11 4 8 1.39 5.48 fhau8wkzn8aa0 JDBC Thin Client SELECT SUM(NVL(BCZHYE, 0)) FRO...
10 0 2 4.96 4.89 1sfzvy51jcmpq JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...
7 0 1 6.93 3.42 2yk0dvqt65fgt JDBC Thin Client BEGIN Payoff_Cal.getMdryBjInfo...
7 6 37 0.18 3.21 b1ankxa565snk ZZ_ZYDJ_E.EXE begin zzy_getInfo2(:V00001, :V...
6 5 1 5.55 2.74 dtwmp9qwucfk4 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
5 5 1 5.34 2.63 8pgmvx7ttn4s2 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
5 5 262 0.02 2.51 4g4ghu7sfq927 JDBC Thin Client SELECT SUM(NVL(BYJFFSE, 0)), S...
5 5 8 0.58 2.30 5nvjpt2fyzhaz JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
4 4 3 1.19 1.76 bunssq950snhf   insert into wrh$_sga_target_ad...
4 4 172 0.02 1.74 ap2t8wcyasd78 JDBC Thin Client SELECT SUM(NVL(BYDFFSE, 0)), S...
3 3 0   1.56 1gc7umngbqyc1   SELECT /*+ ORDERED */ A.READY ...
3 3 2 1.58 1.56 dv3cdn7rj1c0b JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
3 3 2 1.34 1.32 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
3 2 30 0.09 1.31 2dwbs9gvgt5b5 ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
3 2 30 0.08 1.25 27nvjbb9gcyht ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
2 1 9 0.27 1.20 9b6tjndvcaug9 JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...
2 2 2 1.16 1.15 gnwx8y9wp7yu8 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
2 1 115 0.02 1.07 abdawddgymyhp JDBC Thin Client DELETE FROM TABLE_GMXZYB WHERE...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
6 7 37 0.17 4.90 3.21 b1ankxa565snk ZZ_ZYDJ_E.EXE begin zzy_getInfo2(:V00001, :V...
5 5 262 0.02 4.08 2.51 4g4ghu7sfq927 JDBC Thin Client SELECT SUM(NVL(BYJFFSE, 0)), S...
5 6 1 5.19 4.06 2.74 dtwmp9qwucfk4 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
5 5 1 4.88 3.82 2.63 8pgmvx7ttn4s2 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
5 5 8 0.59 3.72 2.30 5nvjpt2fyzhaz JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
5 12 2 2.32 3.62 5.76 94dqvpj2mmh35 JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
4 11 8 0.51 3.19 5.48 fhau8wkzn8aa0 JDBC Thin Client SELECT SUM(NVL(BCZHYE, 0)) FRO...
4 4 172 0.02 2.83 1.74 ap2t8wcyasd78 JDBC Thin Client SELECT SUM(NVL(BYDFFSE, 0)), S...
4 4 3 1.21 2.83 1.76 bunssq950snhf   insert into wrh$_sga_target_ad...
3 3 0   2.41 1.56 1gc7umngbqyc1   SELECT /*+ ORDERED */ A.READY ...
3 3 2 1.45 2.26 1.56 dv3cdn7rj1c0b JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
3 3 2 1.36 2.13 1.32 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
2 3 30 0.08 1.94 1.25 27nvjbb9gcyht ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
2 3 30 0.08 1.92 1.31 2dwbs9gvgt5b5 ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
2 2 2 0.89 1.39 1.15 gnwx8y9wp7yu8 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
2 2 539 0.00 1.37 1.00 5yjvt9zd534jx ZZ_ZYDJ_E.EXE begin zzy_putData(:V00001, :V0...
1 2 115 0.01 1.14 1.07 abdawddgymyhp JDBC Thin Client DELETE FROM TABLE_GMXZYB WHERE...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
608,731 8 76,091.38 14.25 4.75 4.66 5nvjpt2fyzhaz JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
578,082 0   13.53 3.08 3.16 1gc7umngbqyc1   SELECT /*+ ORDERED */ A.READY ...
532,723 37 14,397.92 12.47 6.26 6.52 b1ankxa565snk ZZ_ZYDJ_E.EXE begin zzy_getInfo2(:V00001, :V...
275,691 2 137,845.50 6.45 4.63 11.69 94dqvpj2mmh35 JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
252,332 24 10,513.83 5.91 1.09 1.12 fca1gqzj52va2   select sum(SYSDATE - cast(NVL(...
225,857 8 28,232.13 5.29 4.07 11.11 fhau8wkzn8aa0 JDBC Thin Client SELECT SUM(NVL(BCZHYE, 0)) FRO...
215,653 30 7,188.43 5.05 2.45 2.65 2dwbs9gvgt5b5 ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
215,527 30 7,184.23 5.05 2.48 2.54 27nvjbb9gcyht ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
195,879 2 97,939.50 4.59 2.89 3.16 dv3cdn7rj1c0b JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
187,008 2 93,504.00 4.38 2.72 2.69 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
164,638 2 82,319.00 3.85 1.21 1.19 b8apt5xhr92ur JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
123,568 24 5,148.67 2.89 0.71 0.71 0078dhy7zav20   select sum(SYSDATE - cast(qt.e...
94,481 539 175.29 2.21 1.75 2.02 5yjvt9zd534jx ZZ_ZYDJ_E.EXE begin zzy_putData(:V00001, :V0...
93,262 1 93,262.00 2.18 0.66 0.64 1vbm5z6ybuyvq JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
92,666 4 23,166.50 2.17 0.35 0.36 dbqymq7gyf1q7 JDBC Thin Client SELECT COUNT(DISTINCT(ZGBH)), ...
84,913 6 14,152.17 1.99 0.75 0.81 09mcsvm1a6cya JDBC Thin Client BEGIN YY_Report.buildBxhzb_zg(...
60,489 48 1,260.19 1.42 0.41 0.41 4rk56hkxjn5j0 JDBC Thin Client INSERT INTO J_BXHZB (LB, WDBM,...
51,383 29 1,771.83 1.20 0.77 0.98 1khx9jbhaq6p1 ZZ_ZYDJ_E.EXE begin zzy_computeData(:V00001,...
51,048 4 12,762.00 1.20 1.25 1.52 4rpt6t29kp5bg JDBC Thin Client SELECT COUNT(ZGBH) , NVL(SUM(N...
47,934 434 110.45 1.12 0.41 0.64 42st29yftqnbg JDBC Thin Client DELETE FROM TABLE_GG2 WHERE A1...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
6,432 2 3,216.00 61.34 4.63 11.69 94dqvpj2mmh35 JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
6,427 8 803.38 61.30 4.07 11.11 fhau8wkzn8aa0 JDBC Thin Client SELECT SUM(NVL(BCZHYE, 0)) FRO...
3,247 1 3,247.00 30.97 0.22 6.93 2yk0dvqt65fgt JDBC Thin Client BEGIN Payoff_Cal.getMdryBjInfo...
878 2 439.00 8.37 0.48 9.92 1sfzvy51jcmpq JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...
360 3 120.00 3.43 0.07 0.86 guc8p1rmmktz5 JDBC Thin Client DELETE FROM TABLE_GMXZB_DETAIL...
278 387 0.72 2.65 0.53 1.12 armt8pbbsfysu JDBC Thin Client SELECT COUNT(*) FROM TABLE_GMX...
247 1 247.00 2.36 0.15 1.00 5gh88q3c12v7h JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
247 2 123.50 2.36 0.02 0.88 gayhqaqbbgcwm JDBC Thin Client SELECT SUM(NVL(GZ, 0)), COUNT(...
231 1 231.00 2.20 4.88 5.34 8pgmvx7ttn4s2 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
220 115 1.91 2.10 1.45 2.18 abdawddgymyhp JDBC Thin Client DELETE FROM TABLE_GMXZYB WHERE...
208 1 208.00 1.98 5.19 5.55 dtwmp9qwucfk4 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
155 3 51.67 1.48 0.06 0.50 56b5svgh0ahyb JDBC Thin Client DELETE FROM TABLE_GBB WHERE DW...
138 1 138.00 1.32 1.09 1.58 7q9w1gy1nmrkw JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
137 4 34.25 1.31 1.07 1.39 6yxr2j98nx7cx JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
125 2 62.50 1.19 1.78 2.32 gnwx8y9wp7yu8 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
2,500 2,500 1.00 0.00 0.00 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,971 1,971 1.00 0.00 0.00 abhv38bx4tpmw ZZ_ZYDJ_E.EXE SELECT DUMP(TRIM(:B1 )) FROM D...
1,867 1,867 1.00 0.00 0.00 9wg9fr2p0mrut ZZ_ZYDJ_E.EXE INSERT INTO J_ZYJS_TRANSDATA (...
1,857 11,130 5.99 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
1,300 1,298 1.00 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set equa...
1,123 1,123 1.00 0.00 0.00 a8mg8km170nn7 jyb_zdcs.exe begin zzy_getRate(:V00001, :V0...
978 94 0.10 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
761 23 0.03 0.00 0.00 1x4cuspg6bv5u ZZ_ZYDJ_E.EXE SELECT DDYY, ZGLB2 FROM J_TSRQ...
612 612 1.00 0.00 0.00 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
612 0 0.00 0.00 0.00 csnp95dz2r8ss   select file#, block# from recy...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,500 2,500 6.72 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
2,248 1,123 6.04 a8mg8km170nn7 jyb_zdcs.exe begin zzy_getRate(:V00001, :V0...
1,857 1,857 4.99 0h6b2sajwb74n   select privilege#, level from ...
1,080 539 2.90 5yjvt9zd534jx ZZ_ZYDJ_E.EXE begin zzy_putData(:V00001, :V0...
978 978 2.63 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
612 612 1.64 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
612 612 1.64 csnp95dz2r8ss   select file#, block# from recy...
540 180 1.45 7frqszzdu8sgg racgimon@dqpicc08 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
456 456 1.23 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
456 456 1.23 g00cj285jmgsw   update sys.mon_mods$ set inser...
445 2 1.20 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
445 1,300 1.20 3c1kubcdjnppq   update sys.col_usage$ set equa...
445 445 1.20 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
383 383 1.03 4yffxmsh6n03q ic_mzjs.exe BEGIN SYS.DBMS_DESCRIBE.DESCRI...
375 434 1.01 42st29yftqnbg JDBC Thin Client DELETE FROM TABLE_GG2 WHERE A1...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,343,649 2 0.13 f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
1,068,497 3 0.10 31a13pnjps7j3   SELECT source, (case when time...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
94 31 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
21 341 gw4jskyt0gvvn obilling.exe SELECT * FROM J_GRZHB WHERE ZG...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
4.96 42.40 11.69 4.63 2 94dqvpj2mmh35 JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
4.95 44.55 11.11 4.07 8 fhau8wkzn8aa0 JDBC Thin Client SELECT SUM(NVL(BCZHYE, 0)) FRO...
0.59 5.99 9.92 0.48 2 1sfzvy51jcmpq JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...
0.38 12.16 3.16 2.89 2 dv3cdn7rj1c0b JDBC Thin Client BEGIN YY_Report.buildBxhzb_bc_...
0.35 23.08 1.52 1.25 4 4rpt6t29kp5bg JDBC Thin Client SELECT COUNT(ZGBH) , NVL(SUM(N...
0.27 69.57 0.39 0.16 84 6s8yw2cz896tc ic_mzjs.exe select fybz , kbxbz , fylb , k...
0.23 11.39 2.02 1.75 539 5yjvt9zd534jx ZZ_ZYDJ_E.EXE begin zzy_putData(:V00001, :V0...
0.18 85.45 0.21 0.06 97 60c4qc8p4a1b4 ic_mzjs.exe SELECT "IC_JSDB"."CZYDM" , "I...
0.15 18.97 0.77 0.35 71 cr7mcb26fgppz JDBC Thin Client BEGIN :1 := yy_mzjs.SaveMzjs(:...
0.14 21.40 0.64 0.41 434 42st29yftqnbg JDBC Thin Client DELETE FROM TABLE_GG2 WHERE A1...
0.10 48.03 0.22 0.15 251 g3bk4qjqvwgz7 obilling.exe SELECT MAX(FYBZ) FROM LS_FYDB ...
0.10 3.29 3.16 3.08 0 1gc7umngbqyc1   SELECT /*+ ORDERED */ A.READY ...
0.10 1.53 6.52 6.26 37 b1ankxa565snk ZZ_ZYDJ_E.EXE begin zzy_getInfo2(:V00001, :V...
0.10 46.71 0.21 0.11 358 bbrucrf7d6qdd JDBC Thin Client DELETE FROM TABLE_GG1 WHERE A1...
0.09 9.08 0.98 0.77 29 1khx9jbhaq6p1 ZZ_ZYDJ_E.EXE begin zzy_computeData(:V00001,...
0.05 2.03 2.65 2.45 30 2dwbs9gvgt5b5 ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
0.04 16.41 0.24 0.07 1,300 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.03 3.14 1.12 1.09 24 fca1gqzj52va2   select sum(SYSDATE - cast(NVL(...
0.02 1.75 1.39 1.07 4 6yxr2j98nx7cx JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
0.02 0.94 2.54 2.48 30 27nvjbb9gcyht ZZ_ZYDJ_E.EXE SELECT COUNT(*) FROM J_ZYJS_ZY...
0.02 2.03 1.12 0.53 387 armt8pbbsfysu JDBC Thin Client SELECT COUNT(*) FROM TABLE_GMX...
0.02 3.59 0.59 0.55 1 1rz4sy1qu2xfa ZZ_ZYDJ_B.EXE begin zzy_cancelData(:V00001, ...
0.02 3.54 0.54 0.52 1 89ggz9ya4u74d ZZ_ZYDJ_E.EXE UPDATE J_ZYJS_ZYDJB SET ZFSJ=S...
0.02 2.14 0.86 0.07 3 guc8p1rmmktz5 JDBC Thin Client DELETE FROM TABLE_GMXZB_DETAIL...
0.02 13.94 0.13 0.01 80 a60u590hz8n8a ic_mzjs.exe SELECT * FROM IC_JSDB WHERE ZG...
0.02 1.74 1.00 0.15 1 5gh88q3c12v7h JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
0.02 1.97 0.88 0.02 2 gayhqaqbbgcwm JDBC Thin Client SELECT SUM(NVL(GZ, 0)), COUNT(...
0.02 3.20 0.51 0.50 1 5kmwj7q7h2dva ZZ_ZYDJ_B.EXE UPDATE J_ZYJS_YZDJB SET ZFSJ =...
0.02 0.23 6.93 0.22 1 2yk0dvqt65fgt JDBC Thin Client BEGIN Payoff_Cal.getMdryBjInfo...
0.02 0.29 5.34 4.88 1 8pgmvx7ttn4s2 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
0.02 0.69 2.18 1.45 115 abdawddgymyhp JDBC Thin Client DELETE FROM TABLE_GMXZYB WHERE...
0.01 59.91 0.02 0.01 59 21f5qsh6ztdsx ZZ_ZYDJ_T.EXE SELECT JSDH FROM J_CZYXXB WHER...
0.01 0.60 2.32 1.78 2 gnwx8y9wp7yu8 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
0.01 1.85 0.71 0.71 24 0078dhy7zav20   select sum(SYSDATE - cast(qt.e...
0.01 13.42 0.09 0.06 456 g00cj285jmgsw   update sys.mon_mods$ set inser...
0.01 0.18 5.55 5.19 1 dtwmp9qwucfk4 JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
0.01 1.43 0.50 0.06 3 56b5svgh0ahyb JDBC Thin Client DELETE FROM TABLE_GBB WHERE DW...
0.01 14.94 0.04 0.03 978 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
0.01 0.81 0.78 0.79 2 4zf2cnzzn01ap JDBC Thin Client SELECT Y.* FROM V_SSYZKB Y WHE...
0.01 0.40 1.58 1.09 1 7q9w1gy1nmrkw JDBC Thin Client INSERT INTO TABLE_GG1 (A1, A2,...
0.01 0.13 4.66 4.75 8 5nvjpt2fyzhaz JDBC Thin Client BEGIN PayOff_Report.buildJfHz_...
0.01 0.23 2.43 0.77 9 9b6tjndvcaug9 JDBC Thin Client SELECT COUNT(*) FROM FGRHDGZ_B...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0078dhy7zav20select sum(SYSDATE - cast(qt.enq_time as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where iot.subscriber# != 0 and (iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 8) = 8))) and qt.msgid = iot.msgid
09mcsvm1a6cyaBEGIN YY_Report.buildBxhzb_zg(:1, :2, :3, :4, :5); END;
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_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), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1gc7umngbqyc1SELECT /*+ ORDERED */ A.READY FROM USER_QUEUES B, GV$AQ A WHERE B.NAME = 'MGMT_NOTIFY_Q' AND A.QID = B.QID
1khx9jbhaq6p1begin zzy_computeData(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008); end;
1rz4sy1qu2xfabegin zzy_cancelData(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008); end;
1sfzvy51jcmpqSELECT COUNT(*) FROM FGRHDGZ_BAK WHERE NF = :B2 AND ZGBH = :B1
1vbm5z6ybuyvqBEGIN PayOff_Report.buildJfHz_YlBj(:1, :2, :3, :4, :5); END;
1x4cuspg6bv5uSELECT DDYY, ZGLB2 FROM J_TSRQDA WHERE ZGBH = :B1 AND ZTBZ = 'A'
21f5qsh6ztdsxSELECT JSDH FROM J_CZYXXB WHERE WDBM = :B1 AND ROWNUM = 1
27nvjbb9gcyhtSELECT COUNT(*) FROM J_ZYJS_ZYDJB WHERE ZGBH=:B1 AND (ZFSJ IS NULL) AND (CYSJ1 IS NULL) AND SUBSTRB(SFWS, 1, 1) IN ('E', 'Z')
2dwbs9gvgt5b5SELECT COUNT(*) FROM J_ZYJS_ZYDJB WHERE ZGBH=:B1 AND (ZFSJ IS NULL) AND (BXSJ1 IS NULL) AND SUBSTRB(SFWS, 1, 1) IN ('E', 'Z')
2yk0dvqt65fgtBEGIN Payoff_Cal.getMdryBjInfo(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14); END;
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
42st29yftqnbgDELETE FROM TABLE_GG2 WHERE A1=:B1
4g4ghu7sfq927SELECT SUM(NVL(BYJFFSE, 0)), SUM(NVL(BNJFFSE, 0)) FROM TABLE_GMXZB_DETAIL WHERE DWDM=:B4 AND ZBLB=:B3 AND SUBSTRB(RQ, 1, 10)=SUBSTRB(:B2 , 1, 10) AND TRIM(KMDM) LIKE :B1
4rk56hkxjn5j0INSERT INTO J_BXHZB (LB, WDBM, YGXS, JZLB, SJJE, DJZS, SYZH, SYBCZH, QFBZ, TSZF, QTZF, ABLZF, SYJJ, BCBX, JZRC) SELECT :B9 , :B8 , :B4 , :B7 , SUM(SJJE), SUM(DJZS), SUM(SYZH), SUM(NVL(BCPTZYJJ, 0)) + SUM(NVL(BCTSZYJJ, 0)) + SUM(NVL(BCTFCZYJJ, 0)) + SUM(NVL(BCCEZYJJ, 0)) + SUM(NVL(BCPTMZJJ, 0)) + SUM(NVL(BCZWMZJJ, 0)) + SUM(NVL(MXBBX, 0)) , SUM(QFBZ), SUM(TSZF), SUM(QTZF), SUM(ABLZF), SUM(SYJJ) + SUM(MZTBBX), SUM(BCBX), COUNT(*) FROM J_ZGBXJLB WHERE WDBM LIKE :B6 AND JZLB = :B5 AND YGXS = :B4 AND ((CZBZ='A' AND BXRQ >= :B2 AND BXRQ < :B3 ) OR (CZBZ='B' AND ZFRQ > :B2 AND ZFRQ < :B3 AND BXRQ < :B2 ) ) AND (ZGLB1 <> 'D' AND ZGLB1 <> 'J') AND LB = 'A' AND DWSX LIKE :B1 || '%'
4rpt6t29kp5bgSELECT COUNT(ZGBH) , NVL(SUM(NVL(BCZHYE, 0)), 0) FROM J_GRZHB WHERE WDBM LIKE :B2 AND ZGLB = :B1
4yffxmsh6n03qBEGIN SYS.DBMS_DESCRIBE.DESCRIBE_PROCEDURE(:object_name, :res1, :res2, :overload, :position, :level, :argument, :datatype, :default, :in_out, :length, :precision, :scale, :radix, :spare); END;
4zf2cnzzn01apSELECT Y.* FROM V_SSYZKB Y WHERE Y.ZGBH = '40951736' ORDER BY Y.ZGBH, Y.SYRQ DESC
56b5svgh0ahybDELETE FROM TABLE_GBB WHERE DWDM=:B3 AND ZBLB=:B2 AND SUBSTRB(RQ, 1, 10)=:B1
5gh88q3c12v7hBEGIN PayOff_Report.buildJfHz_YyBj(:1, :2, :3, :4, :5, :6, :7); END;
5kmwj7q7h2dvaUPDATE J_ZYJS_YZDJB SET ZFSJ = SYSDATE WHERE YYDM = :B2 AND ZYH = :B1
5nr9kftsfkk3vSELECT COUNT(*) FROM FGRHDGZ_BAK WHERE ZGBH = :B2 AND NF=:B1
5nvjpt2fyzhazBEGIN PayOff_Report.buildJfHz_Sy(:1, :2, :3, :4, :5); END;
5yjvt9zd534jxbegin zzy_putData(:V00001, :V00002, :V00003, :V00004, :V00005, :V00006, :V00007, :V00008); end;
60c4qc8p4a1b4 SELECT "IC_JSDB"."CZYDM" , "IC_JSDB"."YYDM" , "IC_JSDB"."PDBM" , "IC_JSDB"."ZGBH" , "IC_JSDB"."SHBXH" , "IC_JSDB"."XM" , "IC_JSDB"."YGXS" , "IC_JSDB"."ZGLB1" , "IC_JSDB"."JZLB" , "IC_JSDB"."KB" , "IC_JSDB"."JZSJ" , "IC_JSDB"."XYAOF" , "IC_JSDB"."ZCHENGYF" , "IC_JSDB"."ZCAOYF" , "IC_JSDB"."JCHAF" , "IC_JSDB"."HYANF" , "IC_JSDB"."ZLIAOF" , "IC_JSDB"."FSHEF" , "IC_JSDB"."HCIF" , "IC_JSDB"."CTF" , "IC_JSDB"."SSHUF" , "IC_JSDB"."BCHAOF" , "IC_JSDB"."CZHIF" , "IC_JSDB"."LGUANF" , "IC_JSDB"."QJINGF" , "IC_JSDB"."CLIAOF" , "IC_JSDB"."XDIANF" , "IC_JSDB"."QTAF" , "IC_JSDB"."CFMC1" , "IC_JSDB&quo t;."CFXJ1" , "IC_JSDB"."CFMC2" , "IC_JSDB"."CFXJ2" , "IC_JSDB"."CFMC3" , "IC_JSDB"."CFXJ3" , "IC_JSDB"."CFMC4" , "IC_JSDB"."CFXJ4" , "IC_JSDB"."CFMC5" , "IC_JSDB"."CFXJ5" , "IC_JSDB"."HEJI" , "IC_JSDB"."ZHZF" , "IC_JSDB"."GRZF" , "IC_JSDB"."YLYF" , "IC_JSDB"."TSFY" , "IC_JSDB"."ZFYF" , "IC_JSDB"."ZFBZ" , "IC_JSDB"."CFBZ" , "IC_JSDB"."CLBZ" , "IC_JSDB"."JBZHYE" , "IC_JSDB"."BCZF" , "IC_JSDB"."TJTZZF" , "IC_JSDB"."MXBZF" , "IC_JSDB"."MZTBZF" FROM "IC_JSDB" WHERE ( "IC_JSDB"."YYDM" = :czm ) and ( "IC_JSDB"."PDBM" = :pdn )
6s8yw2cz896tcselect fybz , kbxbz , fylb , kbxbl , grzf , zhzf + bczf + tjtzzf + mxbzf + mztbzf from ls_fydb where zgbh =:1 and jzsj =:2 and sfxmxh =:3
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
6yxr2j98nx7cxINSERT INTO TABLE_GG1 (A1, A2, A3, B1, B2, B3, C1, C2, C3, C4, C5, C6, C7, C8, C9, E1, E2, E3, E4, E5, F1, F2, F3, F4, F5, F6, F7, F8, F9, G1, G2, G3, G4, G5, G6, G7, G8, G9, H1, H2, H3, I1, I2, I3, I4, I5, I6, I7, I8, I9) VALUES ('xrzx20', 'xrzx', 'J', 'feb21', null, 'ok', 'confirmTicketAll', null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, null, null, null, null, null, null, null, null, null)
7frqszzdu8sggselect DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7q9w1gy1nmrkwINSERT INTO TABLE_GG1 (A1, A2, A3, B1, B2, B3, C1, C2, C3, C4, C5, C6, C7, C8, C9, E1, E2, E3, E4, E5, F1, F2, F3, F4, F5, F6, F7, F8, F9, G1, G2, G3, G4, G5, G6, G7, G8, G9, H1, H2, H3, I1, I2, I3, I4, I5, I6, I7, I8, I9) VALUES ('xryj08', 'xryj', 'M', 'feb21', null, 'ok', 'generatePreview', null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, null, null, null, null, null, null, null, null, null)
89ggz9ya4u74dUPDATE J_ZYJS_ZYDJB SET ZFSJ=SYSDATE, ZTBZ='Z' WHERE YYDM=:B3 AND ZYH=:B2 AND ZGBH=:B1
8pgmvx7ttn4s2INSERT INTO TABLE_GG1 (A1, A2, A3, B1, B2, B3, C1, C2, C3, C4, C5, C6, C7, C8, C9, E1, E2, E3, E4, E5, F1, F2, F3, F4, F5, F6, F7, F8, F9, G1, G2, G3, G4, G5, G6, G7, G8, G9, H1, H2, H3, I1, I2, I3, I4, I5, I6, I7, I8, I9) VALUES ('xryj08', 'xryj', 'J', 'feb21', null, 'ok', 'generatePreview', null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, null, null, null, null, null, null, null, null, null)
8w2ww0j6wabqfBEGIN :1 := f_grgzze1(:2, :3, :4) ; END;
94dqvpj2mmh35BEGIN YY_Report.buildBxhzb_bc_1(:1, :2, :3); END;
9b6tjndvcaug9SELECT COUNT(*) FROM FGRHDGZ_BAK WHERE ZGBH = :B2 AND NF = :B1
9wg9fr2p0mrutINSERT INTO J_ZYJS_TRANSDATA (COM, COMTYPE, YYDM, ZYH, ZGBH, PUTDATA, PUTADATALENGTH, GETDATA, GETADATALENGTH, TRANSTIME) VALUES (:B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)
a60u590hz8n8aSELECT * FROM IC_JSDB WHERE ZGBH = :B2 AND JZLB IN('F', 'T') AND ZFBZ IS NULL AND JZSJ = :B1 AND ROWNUM = 1
a8mg8km170nn7begin zzy_getRate(:V00001, :V00002, :V00003, :V00004); end;
abdawddgymyhpDELETE FROM TABLE_GMXZYB WHERE DWDM=:B4 AND ZBLB=:B3 AND SUBSTRB(RQ, 1, 10)=SUBSTRB(:B2 , 1, 10) AND PZH=:B1
abhv38bx4tpmwSELECT DUMP(TRIM(:B1 )) FROM DUAL
ap2t8wcyasd78SELECT SUM(NVL(BYDFFSE, 0)), SUM(NVL(BNDFFSE, 0)) FROM TABLE_GMXZB_DETAIL WHERE DWDM=:B4 AND ZBLB=:B3 AND SUBSTRB(RQ, 1, 10)=SUBSTRB(:B2 , 1, 10) AND TRIM(KMDM) LIKE :B1
armt8pbbsfysuSELECT COUNT(*) FROM TABLE_GMXZYB WHERE DWDM=:B4 AND ZBLB=:B3 AND KMDM=:B2 AND SUBSTRB(RQ, 1, 6)=SUBSTRB(:B1 , 1, 6)
b1ankxa565snkbegin zzy_getInfo2(:V00001, :V00002, :V00003, :V00004); end;
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b8apt5xhr92urBEGIN PayOff_Report.buildJfHz_Yl(:1, :2, :3, :4, :5); END;
bbrucrf7d6qddDELETE FROM TABLE_GG1 WHERE A1=:B1
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
cr7mcb26fgppzBEGIN :1 := yy_mzjs.SaveMzjs(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24); END;
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
dbqymq7gyf1q7SELECT COUNT(DISTINCT(ZGBH)), SUM(NVL(SYSJJE, 0)), SUM(GZ) FROM AJBYLGRJF WHERE WDBM LIKE :B4 AND NF = :B3 AND YF = :B2 AND YF1 = :B1 AND SYYJJE > 0 AND SYYJJE = SYSJJE AND ZGBH IN (SELECT ZGBH FROM FGRZRXX WHERE LRRQ >= :B6 AND LRRQ < :B5 )
dtwmp9qwucfk4INSERT INTO TABLE_GG1 (A1, A2, A3, B1, B2, B3, C1, C2, C3, C4, C5, C6, C7, C8, C9, E1, E2, E3, E4, E5, F1, F2, F3, F4, F5, F6, F7, F8, F9, G1, G2, G3, G4, G5, G6, G7, G8, G9, H1, H2, H3, I1, I2, I3, I4, I5, I6, I7, I8, I9) VALUES ('xryj08', 'xryj', 'R', 'feb21', null, 'ok', 'generatePreview', null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, null, null, null, null, null, null, null, null, null)
dv3cdn7rj1c0bBEGIN YY_Report.buildBxhzb_bc_2(:1, :2, :3, :4); END;
f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fca1gqzj52va2select sum(SYSDATE - cast(NVL(qt.delay, qt.enq_time) as date)) from "SYS"."ALERT_QT" qt, "SYS"."AQ$_ALERT_QT_I" iot where ((iot.subscriber# != 0 and iot.subscriber# in (select subscriber_id from "SYS"."AQ$_ALERT_QT_S" where queue_name = :1 and (bitand(subscriber_type, 1) = 1))) or (iot.subscriber# = 0 and iot.queue# = :2)) and qt.msgid = iot.msgid
fhau8wkzn8aa0SELECT SUM(NVL(BCZHYE, 0)) FROM J_GRZHB ZH , (SELECT ZGBH FROM FGRZRXX WHERE GZ LIKE :B1 || '%') XX WHERE ZH.WDBM LIKE :B2 AND ZH.ZGBH = XX.ZGBH
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g3bk4qjqvwgz7SELECT MAX(FYBZ) FROM LS_FYDB WHERE YYDM = :B4 AND CZYDM = :B3 AND PDBM = :B2 AND CFH = :B1
gayhqaqbbgcwmSELECT SUM(NVL(GZ, 0)), COUNT(DISTINCT(ZGBH)), SUM(NVL(BQYJJE, 0)) FROM AJBYYGRJF WHERE WDBM LIKE :B4 AND NF = :B3 AND BQYJJE > 0 AND (JFRQ IS NULL OR (JFRQ >= :B2 AND JFRQ <= :B1 ))
gnwx8y9wp7yu8INSERT INTO TABLE_GG1 (A1, A2, A3, B1, B2, B3, C1, C2, C3, C4, C5, C6, C7, C8, C9, E1, E2, E3, E4, E5, F1, F2, F3, F4, F5, F6, F7, F8, F9, G1, G2, G3, G4, G5, G6, G7, G8, G9, H1, H2, H3, I1, I2, I3, I4, I5, I6, I7, I8, I9) VALUES ('xrzx20', 'xrzx', 'J', 'unConfirmTicketAll', null, 'ok', null, null, null, null, null, null, null, null, null, 1001, 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, null, null, null, null, null, null, null, null, null)
guc8p1rmmktz5DELETE FROM TABLE_GMXZB_DETAIL WHERE DWDM=:B3 AND ZBLB=:B2 AND SUBSTRB(RQ, 1, 10)=:B1
gw4jskyt0gvvnSELECT * FROM J_GRZHB WHERE ZGBH = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 11,277 1.04 5.74
CPU used when call started 11,009 1.02 5.61
CR blocks created 684 0.06 0.35
Cached Commit SCN referenced 43 0.00 0.02
Commit SCN cached 15 0.00 0.01
DB time 110,575 10.20 56.30
DBWR checkpoint buffers written 6,604 0.61 3.36
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 734 0.07 0.37
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 233 0.02 0.12
DBWR undo block writes 2,149 0.20 1.09
DFO trees parallelized 230 0.02 0.12
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 4,282 0.40 2.18
PX local messages sent 4,282 0.40 2.18
PX remote messages recv'd 7,222 0.67 3.68
PX remote messages sent 9,902 0.91 5.04
Parallel operations downgraded 1 to 25 pct 0 0.00 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 230 0.02 0.12
RowCR - row contention 11 0.00 0.01
RowCR attempts 591 0.05 0.30
RowCR hits 576 0.05 0.29
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 46,480 4.29 23.67
active txn count during cleanout 3,699 0.34 1.88
application wait time 1,576 0.15 0.80
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 41,691 3.85 21.23
branch node splits 0 0.00 0.00
buffer is not pinned count 1,948,738 179.81 992.23
buffer is pinned count 4,154,549 383.35 2,115.35
bytes received via SQL*Net from client 3,983,280 367.54 2,028.15
bytes sent via SQL*Net to client 27,038,141 2,494.86 13,766.87
calls to get snapshot scn: kcmgss 128,228 11.83 65.29
calls to kcmgas 31,121 2.87 15.85
calls to kcmgcs 1,957 0.18 1.00
change write time 81 0.01 0.04
cleanout - number of ktugct calls 2,726 0.25 1.39
cleanouts and rollbacks - consistent read gets 723 0.07 0.37
cleanouts only - consistent read gets 125 0.01 0.06
cluster key scan block gets 19,528 1.80 9.94
cluster key scans 2,169 0.20 1.10
cluster wait time 984 0.09 0.50
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 57 0.01 0.03
commit batch/immediate requested 57 0.01 0.03
commit cleanout failures: block lost 141 0.01 0.07
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 16 0.00 0.01
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 13,948 1.29 7.10
commit cleanouts successfully completed 13,791 1.27 7.02
commit immediate performed 57 0.01 0.03
commit immediate requested 57 0.01 0.03
commit txn count during cleanout 757 0.07 0.39
concurrency wait time 1,528 0.14 0.78
consistent changes 3,406 0.31 1.73
consistent gets 4,115,554 379.75 2,095.50
consistent gets - examination 909,596 83.93 463.13
consistent gets direct 120 0.01 0.06
consistent gets from cache 4,115,434 379.74 2,095.43
current blocks converted for CR 0 0.00 0.00
cursor authentications 820 0.08 0.42
data blocks consistent reads - undo records applied 3,072 0.28 1.56
db block changes 179,768 16.59 91.53
db block gets 155,852 14.38 79.35
db block gets direct 45 0.00 0.02
db block gets from cache 155,807 14.38 79.33
deferred (CURRENT) block cleanout applications 5,922 0.55 3.02
dirty buffers inspected 4 0.00 0.00
enqueue conversions 5,867 0.54 2.99
enqueue releases 140,598 12.97 71.59
enqueue requests 140,626 12.98 71.60
enqueue timeouts 24 0.00 0.01
enqueue waits 5,091 0.47 2.59
exchange deadlocks 1 0.00 0.00
execute count 87,803 8.10 44.71
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 33,128 3.06 16.87
free buffer requested 40,853 3.77 20.80
gc CPU used by this session 3,033 0.28 1.54
gc blocks lost 0 0.00 0.00
gc cr block build time 9 0.00 0.00
gc cr block flush time 25 0.00 0.01
gc cr block receive time 403 0.04 0.21
gc cr block send time 20 0.00 0.01
gc cr blocks received 13,392 1.24 6.82
gc cr blocks served 7,105 0.66 3.62
gc current block flush time 33 0.00 0.02
gc current block pin time 42 0.00 0.02
gc current block receive time 517 0.05 0.26
gc current block send time 219 0.02 0.11
gc current blocks received 12,362 1.14 6.29
gc current blocks served 76,483 7.06 38.94
gc local grants 3,932 0.36 2.00
gc remote grants 9,013 0.83 4.59
gcs messages sent 186,198 17.18 94.81
ges messages sent 86,647 8.00 44.12
global enqueue get time 5,689 0.52 2.90
global enqueue gets async 3,625 0.33 1.85
global enqueue gets sync 33,195 3.06 16.90
global enqueue releases 29,668 2.74 15.11
heap block compress 7,253 0.67 3.69
hot buffers moved to head of LRU 1,568 0.14 0.80
immediate (CR) block cleanout applications 848 0.08 0.43
immediate (CURRENT) block cleanout applications 2,811 0.26 1.43
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 2,337 0.22 1.19
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 21 0.00 0.01
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 582,455 53.74 296.57
index scans kdiixs1 118,080 10.90 60.12
leaf node 90-10 splits 23 0.00 0.01
leaf node splits 127 0.01 0.06
lob reads 82 0.01 0.04
lob writes 83 0.01 0.04
lob writes unaligned 74 0.01 0.04
logons cumulative 1,523 0.14 0.78
messages received 14,013 1.29 7.13
messages sent 14,013 1.29 7.13
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 3,169,569 292.46 1,613.83
opened cursors cumulative 35,121 3.24 17.88
parse count (failures) 2 0.00 0.00
parse count (hard) 2,448 0.23 1.25
parse count (total) 37,214 3.43 18.95
parse time cpu 977 0.09 0.50
parse time elapsed 1,062 0.10 0.54
physical read IO requests 8,214 0.76 4.18
physical read bytes 85,893,120 7,925.52 43,733.77
physical read total IO requests 37,350 3.45 19.02
physical read total bytes 596,543,488 55,044.16 303,739.05
physical read total multi block requests 973 0.09 0.50
physical reads 10,485 0.97 5.34
physical reads cache 10,365 0.96 5.28
physical reads cache prefetch 4,986 0.46 2.54
physical reads direct 120 0.01 0.06
physical reads direct (lob) 120 0.01 0.06
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 5,028 0.46 2.56
physical write bytes 60,088,320 5,544.46 30,594.87
physical write total IO requests 19,069 1.76 9.71
physical write total bytes 322,768,896 29,782.48 164,342.62
physical write total multi block requests 3,921 0.36 2.00
physical writes 7,335 0.68 3.73
physical writes direct 45 0.00 0.02
physical writes direct (lob) 45 0.00 0.02
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 7,290 0.67 3.71
physical writes non checkpoint 3,716 0.34 1.89
pinned buffers inspected 9 0.00 0.00
pinned cursors current 7 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 9 0.00 0.00
process last non-idle time 10,942 1.01 5.57
queries parallelized 230 0.02 0.12
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 259,970 23.99 132.37
recursive cpu usage 6,817 0.63 3.47
redo blocks written 36,394 3.36 18.53
redo buffer allocation retries 0 0.00 0.00
redo entries 99,453 9.18 50.64
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,872 0.17 0.95
redo size 35,192,512 3,247.28 17,918.79
redo subscn max counts 1,873 0.17 0.95
redo synch time 752 0.07 0.38
redo synch writes 1,309 0.12 0.67
redo wastage 1,770,728 163.39 901.59
redo write broadcast ack time 58 0.01 0.03
redo write time 1,269 0.12 0.65
redo writer latching time 0 0.00 0.00
redo writes 3,368 0.31 1.71
rollback changes - undo records applied 447 0.04 0.23
rollbacks only - consistent read gets 37 0.00 0.02
root node splits 0 0.00 0.00
rows fetched via callback 287,189 26.50 146.23
session connect time 0 0.00 0.00
session cursor cache hits 20,107 1.86 10.24
session logical reads 4,271,406 394.13 2,174.85
shared hash latch upgrades - no wait 4,315 0.40 2.20
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 17,183 1.59 8.75
sorts (rows) 689,642 63.63 351.14
sql area evicted 3,064 0.28 1.56
sql area purged 3 0.00 0.00
summed dirty queue length 8 0.00 0.00
switch current to new buffer 2,609 0.24 1.33
table fetch by rowid 2,578,368 237.91 1,312.81
table fetch continued row 58,937 5.44 30.01
table scan blocks gotten 1,830,681 168.92 932.12
table scan rows gotten 75,268,873 6,945.20 38,324.27
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 556 0.05 0.28
table scans (rowid ranges) 556 0.05 0.28
table scans (short tables) 8,636 0.80 4.40
total number of times SMON posted 1 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 57 0.01 0.03
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 13,926,720 1,285.04 7,091.00
user I/O wait time 1,633 0.15 0.83
user calls 55,009 5.08 28.01
user commits 1,287 0.12 0.66
user rollbacks 677 0.06 0.34
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 11,159 1.03 5.68
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 4.1E+12 4.1E+12
session cursor cache count 6,858,522 6,863,886
session uga memory 3.1E+11 3.1E+11
opened cursors current 497 332
workarea memory allocated 0 320
logons current 49 47
session uga memory max 4.8E+11 4.8E+11
session pga memory 2.0E+12 2.0E+12

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 0.33

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
BUSINESS01 4,995 0 0.51 1.33 612 0 0 0.00
INDEX02 1,568 0 2.69 1.00 474 0 0 0.00
INDEX03 318 0 3.84 1.00 750 0 1 70.00
FINANCE01 169 0 5.09 1.00 685 0 0 0.00
SYSAUX 41 0 4.63 1.00 659 0 0 0.00
UNDOTBS2 0 0 0.00 0.00 604 0 0 0.00
INDEX01 300 0 3.93 1.00 299 0 0 0.00
INDEX04 121 0 5.70 1.00 267 0 0 0.00
DATA04 275 0 8.36 3.34 63 0 0 0.00
SYSTEM 177 0 6.10 1.00 127 0 0 0.00
BUSINESS04 25 0 5.60 1.00 252 0 0 0.00
BUSINESS02 127 0 0.47 1.01 76 0 0 0.00
DATA05 5 0 4.00 1.00 87 0 0 0.00
INDEX05 21 0 5.71 1.00 44 0 0 0.00
DATA02 34 0 3.82 1.00 18 0 0 0.00
DATA03 1 0 10.00 1.00 6 0 0 0.00
DATA01 0 0 0.00 0.00 4 0 0 0.00
HISDATA02 3 0 6.67 1.00 0 0 0 0.00
HISDATA03 2 0 5.00 1.00 1 0 0 0.00
HISDATA05 3 0 6.67 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
BUSINESS01 +DG1/bxgrid/datafile/business01.259.738519491 4,517 0 0.49 1.32 478 0 0 0.00
BUSINESS01 +DG2/bxgrid/datafile/business01.287.751277513 478 0 0.71 1.37 134 0 0 0.00
BUSINESS02 +DG4/bxgrid/datafile/business02.274.738520195 127 0 0.47 1.01 76 0 0 0.00
BUSINESS04 +DG4/bxgrid/datafile/busniess04.296.760537645 25 0 5.60 1.00 252 0 0 0.00
DATA01 +DG3/bxgrid/datafile/data01.257.738520455 0 0     4 0 0 0.00
DATA02 +DG3/bxgrid/datafile/data02.258.738520529 34 0 3.82 1.00 18 0 0 0.00
DATA03 +DG1/bxgrid/datafile/data03.260.738520611 1 0 10.00 1.00 6 0 0 0.00
DATA04 +DG1/bxgrid/datafile/data04.261.738521001 274 0 8.39 3.35 5 0 0 0.00
DATA04 +DG2/bxgrid/datafile/data04.289.791290669 1 0 0.00 1.00 58 0 0 0.00
DATA05 +DG2/bxgrid/datafile/data05.284.738521017 5 0 4.00 1.00 21 0 0 0.00
DATA05 +DG2/bxgrid/datafile/data05.288.791290369 0 0     66 0 0 0.00
FINANCE01 +DG2/bxgrid/datafile/finace01.285.738521019 169 0 5.09 1.00 685 0 0 0.00
HISDATA02 +DG1/bxgrid/datafile/data02.257.732908275 3 0 6.67 1.00 0 0 0 0.00
HISDATA03 +DG2/bxgrid/datafile/hisdata03.282.732964397 2 0 5.00 1.00 1 0 0 0.00
HISDATA05 +DG3/bxgrid/datafile/hisdata05.263.778501541 3 0 6.67 1.00 0 0 0 0.00
INDEX01 +DG3/bxgrid/datafile/index01.259.738521041 300 0 3.93 1.00 299 0 0 0.00
INDEX02 +DG3/bxgrid/datafile/index02.260.738522191 1,568 0 2.69 1.00 474 0 0 0.00
INDEX03 +DG1/bxgrid/datafile/index03.262.738522203 318 0 3.84 1.00 750 0 1 70.00
INDEX04 +DG1/bxgrid/datafile/index04.263.738522201 121 0 5.70 1.00 267 0 0 0.00
INDEX05 +DG2/bxgrid/datafile/index05.286.738522221 21 0 5.71 1.00 44 0 0 0.00
SYSAUX +DG2/bxgrid/datafile/sysaux.257.732825407 41 0 4.63 1.00 659 0 0 0.00
SYSTEM +DG2/bxgrid/datafile/system.256.732825407 177 0 6.10 1.00 127 0 0 0.00
UNDOTBS2 +DG2/bxgrid/datafile/undotbs2.264.732825517 0 0     604 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 449,481 100 4,271,143 10,356 7,290 0 0 1


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 476 952 1381 138240 1381  
E 0 0 239 281 2683 138240 2683  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 368 0.10 44,091 2.56 72,824,033
D 736 0.20 88,182 2.01 57,194,355
D 1,104 0.29 132,273 1.69 47,881,515
D 1,472 0.39 176,364 1.46 41,605,189
D 1,840 0.49 220,455 1.32 37,435,384
D 2,208 0.59 264,546 1.22 34,656,623
D 2,576 0.69 308,637 1.15 32,667,640
D 2,944 0.78 352,728 1.10 31,114,346
D 3,312 0.88 396,819 1.05 29,727,560
D 3,680 0.98 440,910 1.01 28,613,190
D 3,760 1.00 450,495 1.00 28,406,953
D 4,048 1.08 485,001 0.97 27,679,449
D 4,416 1.17 529,092 0.95 26,852,123
D 4,784 1.27 573,183 0.92 26,095,952
D 5,152 1.37 617,274 0.90 25,426,177
D 5,520 1.47 661,365 0.87 24,851,118
D 5,888 1.57 705,456 0.86 24,321,919
D 6,256 1.66 749,547 0.84 23,764,676
D 6,624 1.76 793,638 0.81 23,101,684
D 6,992 1.86 837,729 0.78 22,240,774
D 7,360 1.96 881,820 0.74 21,128,790

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 172 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 1,621 1,320 268.26 0.00 0.00 0.00 0.00 165,990
E 1,621 1,329 253.96 0.31 0.12 100.00 0.00 165,990

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 10,786 10,786 0 0
64K 128K 153 153 0 0
128K 256K 76 76 0 0
256K 512K 26 26 0 0
512K 1024K 92 92 0 0
1M 2M 20 20 0 0
2M 4M 6 6 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
203 0.13 197,428.53 134,185.35 60.00 380
405 0.25 197,428.53 63,977.84 76.00 38
811 0.50 197,428.53 32,562.61 86.00 1
1,216 0.75 197,428.53 32,557.97 86.00 0
1,621 1.00 197,428.53 32,557.97 86.00 0
1,945 1.20 197,428.53 32,557.97 86.00 0
2,269 1.40 197,428.53 32,557.97 86.00 0
2,594 1.60 197,428.53 32,557.97 86.00 0
2,918 1.80 197,428.53 32,557.97 86.00 0
3,242 2.00 197,428.53 32,557.97 86.00 0
4,863 3.00 197,428.53 32,557.97 86.00 0
6,484 4.00 197,428.53 32,557.97 86.00 0
9,726 6.00 197,428.53 32,557.97 86.00 0
12,968 8.00 197,428.53 32,557.97 86.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
448 0.44 128 8,261 2,756,114 1.00 13,314 1.69 243,995
560 0.56 236 14,160 2,758,225 1.00 11,203 1.42 244,191
672 0.67 347 19,990 2,759,497 1.00 9,931 1.26 244,327
784 0.78 458 25,587 2,760,419 1.00 9,009 1.14 244,430
896 0.89 569 31,378 2,761,091 1.00 8,337 1.06 244,507
1,008 1.00 680 36,895 2,761,553 1.00 7,875 1.00 244,562
1,120 1.11 791 42,157 2,761,808 1.00 7,620 0.97 244,593
1,232 1.22 902 47,704 2,761,983 1.00 7,445 0.95 244,616
1,344 1.33 1,013 53,507 2,762,103 1.00 7,325 0.93 244,632
1,456 1.44 1,124 59,497 2,762,186 1.00 7,242 0.92 244,645
1,568 1.56 1,235 65,082 2,762,247 1.00 7,181 0.91 244,654
1,680 1.67 1,346 70,839 2,762,295 1.00 7,133 0.91 244,662
1,792 1.78 1,457 77,126 2,762,337 1.00 7,091 0.90 244,669
1,904 1.89 1,568 82,689 2,762,376 1.00 7,052 0.90 244,676
2,016 2.00 1,679 88,934 2,762,418 1.00 7,010 0.89 244,682

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,216 0.25 997,100 77,039,581
2,432 0.50 827,462 39,602,094
3,648 0.75 795,708 32,915,104
4,864 1.00 776,376 28,406,925
6,080 1.25 765,429 26,290,609
7,296 1.50 756,035 24,438,478
8,512 1.75 744,855 22,353,409
9,728 2.00 744,545 22,353,409

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1 0 70

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 59 59 0 53 2 35.51
PS-PX Process Reservation 6,481 6,457 24 3,261 1 0.28
TM-DML 5,046 5,046 0 901 0 0.18
TT-Tablespace 632 632 0 455 0 0.16
PI-Remote PX Process Spawn Status 448 448 0 248 0 0.21
TX-Transaction (index contention) 11 11 0 9 0 1.78
HW-Segment High Water Mark 994 994 0 52 0 0.19
CF-Controlfile Transaction 24,618 24,618 0 102 0 0.04
FB-Format Block 23 23 0 18 0 0.22
JS-Job Scheduler (job run lock - synchronize) 6 6 0 4 0 1.00
AF-Advisor Framework (task serialization) 21 21 0 2 0 0.50
TX-Transaction (allocate ITL entry) 1 1 0 1 0 1.00
WL-Being Written Redo Log 1 1 0 1 0 1.00
TA-Instance Undo 36 36 0 2 0 0.00
IR-Instance Recovery 13 13 0 1 0 0.00
TQ-Queue table enqueue (TM contention) 25 25 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 1.92 2,564 1,967 11 15/44.8 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
17-Aug 10:55 5 97 0 5 15 0/0 0/0/0/0/0/0
17-Aug 10:45 85 113 1,967 8 45 0/0 0/0/0/0/0/0
17-Aug 10:35 71 132 1,361 7 35 0/0 0/0/0/0/0/0
17-Aug 10:25 10 22 753 7 25 0/0 0/0/0/0/0/0
17-Aug 10:15 19 185 0 5 15 0/0 0/0/0/0/0/0
17-Aug 10:05 66 56 0 7 15 0/0 0/0/0/0/0/0
17-Aug 09:55 15 130 0 7 15 0/0 0/0/0/0/0/0
17-Aug 09:45 16 30 0 8 15 0/0 0/0/0/0/0/0
17-Aug 09:35 260 147 0 7 15 0/0 0/0/0/0/0/0
17-Aug 09:25 192 69 32 6 17 0/0 0/0/0/0/0/0
17-Aug 09:15 92 176 0 5 15 0/0 0/0/0/0/0/0
17-Aug 09:05 282 248 0 7 39 0/0 0/0/0/0/0/0
17-Aug 08:55 205 331 0 8 29 0/0 0/0/0/0/0/0
17-Aug 08:45 223 200 0 7 20 0/0 0/0/0/0/0/0
17-Aug 08:35 176 149 0 7 15 0/0 0/0/0/0/0/0
17-Aug 08:25 44 68 0 10 18 0/0 0/0/0/0/0/0
17-Aug 08:15 40 227 0 11 15 0/0 0/0/0/0/0/0
17-Aug 08:05 116 184 0 11 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 40 0.00   0 0  
ASM db client latch 8,708 0.00   0 0  
ASM map headers 28 0.00   0 0  
ASM map load waiting list 4 0.00   0 0  
ASM map operation freelist 417 0.00   0 0  
ASM map operation hash table 122,768 0.00 0.00 0 0  
ASM network background latch 4,341 0.00   0 0  
AWR Alerted Metric Element list 47,219 0.00   0 0  
Consistent RBA 3,385 0.00   0 0  
FAL request queue 219 0.00   0 0  
FAL subheap alocation 219 0.00   0 0  
FIB s.o chain latch 12 0.00   0 0  
FOB s.o list latch 3,804 0.08 0.00 0 0  
JS broadcast add buf latch 2,477 0.00   0 0  
JS broadcast drop buf latch 2,477 0.00   0 0  
JS broadcast load blnc latch 2,154 0.00   0 0  
JS mem alloc latch 14 0.00   0 0  
JS queue access latch 14 0.00   0 0  
JS queue state obj latch 91,164 0.00   0 0  
JS slv state obj latch 12 0.00   0 0  
KCL gc element parent latch 321,524 0.03 0.12 0 217 0.00
KFK SGA context latch 14,576 0.00   0 0  
KFMD SGA 264 0.00   0 0  
KJC message pool free list 35,366 0.03 0.11 0 3,683 0.03
KJCT flow control latch 416,011 0.01 0.07 0 0  
KMG MMAN ready and startup request latch 3,601 0.00   0 0  
KTF sga latch 10,048 0.00   0 3,119 0.00
KWQMN job cache list latch 936 0.00   0 0  
KWQP Prop Status 6 0.00   0 0  
MQL Tracking Latch 0     0 215 0.00
Memory Management Latch 0     0 3,601 0.00
OS process 2,511 0.00   0 0  
OS process allocation 5,273 0.04 0.00 0 0  
OS process: request allocation 1,068 0.00   0 0  
PL/SQL warning settings 7,352 0.00   0 0  
SGA IO buffer pool latch 841 0.00   0 841 0.00
SQL memory manager latch 3 0.00   0 3,596 0.00
SQL memory manager workarea list latch 244,436 0.00   0 0  
Shared B-Tree 392 0.00   0 0  
active checkpoint queue latch 9,454 0.00   0 0  
active service list 32,470 0.55 0.20 0 9,070 0.00
alert log latch 2 0.00   0 0  
archive control 363 0.00   0 0  
archive process latch 4,034 0.00   0 0  
begin backup scn array 45 0.00   0 0  
business card 460 0.00   0 0  
cache buffer handles 1,250 0.00   0 0  
cache buffers chains 8,190,884 0.01 0.44 0 307,465 0.01
cache buffers lru chain 44,361 0.04 0.11 0 266,874 0.05
cache table scan latch 0     0 921 1.85
channel handle pool latch 1,110 0.00   0 0  
channel operations parent latch 550,911 0.00 0.00 0 0  
checkpoint queue latch 371,479 0.01 0.00 0 10,029 0.00
client/application info 7,286 0.00   0 0  
commit callback allocation 18 0.00   0 0  
compile environment latch 1,643 0.00   0 0  
dml lock allocation 10,336 0.00   0 0  
dummy allocation 3,288 1.61 0.06 0 0  
enqueue hash chains 312,730 0.01 0.38 0 229 0.00
enqueues 269,717 0.02 0.18 0 0  
error message lists 3,714 0.13 0.00 0 0  
event group latch 533 0.00   0 0  
file cache latch 5,594 0.00   0 0  
gcs opaque info freelist 185,124 0.08 0.01 0 0  
gcs partitioned table hash 938,221 0.00   0 1,155 0.00
gcs remastering latch 9,489 0.00   0 0  
gcs resource freelist 29,719 0.01 0.00 0 9,943 0.01
gcs resource hash 441,651 0.06 0.04 0 2 0.00
gcs resource scan list 4 0.00   0 0  
gcs shadows freelist 83,287 0.00   0 96,042 0.00
ges caches resource lists 1,258,391 0.00 0.27 0 1,250,631 0.00
ges deadlock list 12,198 0.00   0 3 0.00
ges domain table 53,792 0.00   0 0  
ges enqueue table freelist 149,836 0.00 0.00 0 0  
ges group table 81,332 0.00   0 0  
ges process hash list 50,589 0.00   0 0  
ges process parent latch 239,246 0.00   0 0  
ges process table freelist 1,068 0.09 0.00 0 0  
ges resource hash list 439,085 1.55 0.90 0 28,277 0.01
ges resource scan list 420 0.00   0 0  
ges resource table freelist 46,149 0.00   0 0  
ges timeout list 6,056 0.00   0 4,284 0.00
global KZLD latch for mem in SGA 372 0.00   0 0  
hash table column usage latch 686 0.00   0 117,696 0.00
hash table modification latch 276 0.00   0 0  
interrupt manipulation 8,248 2.51 0.02 0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 186 0.00   0 0  
kks stats 16,838 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 10,020 0.00   0 0  
ksuosstats global area 729 0.00   0 0  
ktm global data 39 0.00   0 0  
kwqbsn:qsga 389 0.00   0 0  
lgwr LWN SCN 5,074 0.02 0.00 0 0  
library cache 293,893 0.39 0.03 0 19,582 0.00
library cache load lock 534 0.00   0 0  
library cache lock 407,238 0.86 0.00 0 0  
library cache lock allocation 5,085 0.00   0 0  
library cache pin 93,990 0.03 0.00 0 0  
library cache pin allocation 842 0.00   0 0  
list of block allocation 701 0.00   0 0  
loader state object freelist 168 0.00   0 0  
logminer context allocation 3 0.00   0 0  
message pool operations parent latch 6,154 0.02 0.00 0 0  
messages 367,894 0.00 0.11 0 0  
mostly latch-free SCN 5,086 0.20 0.00 0 0  
msg queue 8 0.00   0 8 0.00
multiblock read objects 26,648 0.00   0 0  
name-service memory objects 31,870 0.01 0.00 0 0  
name-service namespace bucket 131,019 0.00   0 0  
name-service pending queue 3,970 0.00   0 0  
name-service request 720 0.83 0.33 0 0  
name-service request queue 113,531 0.01 0.50 0 0  
ncodef allocation latch 246 0.00   0 0  
object queue header heap 401 0.00   0 212 0.00
object queue header operation 103,044 0.01 0.29 0 0  
object stats modification 3 0.00   0 0  
parallel query alloc buffer 21,016 0.05 0.00 0 0  
parallel query stats 1,801 3.61 0.11 0 0  
parallel txn reco latch 5,760 0.00   0 0  
parameter list 4,236 0.00   0 0  
parameter table management 3,306 0.00   0 0  
post/wait queue 3,623 0.00   0 1,821 0.00
process allocation 110,011 0.00 0.00 0 532 0.19
process group creation 1,068 0.00   0 0  
process queue 9,259 0.06 0.00 0 0  
process queue reference 868,163 0.01 0.00 0 23,883 0.24
qmn state object latch 2 0.00   0 0  
qmn task queue latch 1,540 9.42 1.00 0 0  
query server freelists 6,636 0.51 0.38 0 0  
query server process 120 0.00   0 120 0.00
queued dump request 53,594 0.00   0 0  
redo allocation 13,542 0.02 1.00 0 99,582 0.00
redo copy 0     0 99,582 0.05
redo writing 27,169 0.00 0.00 0 0  
resmgr group change latch 2,047 0.00   0 0  
resmgr:active threads 3,241 0.00   0 0  
resmgr:actses change group 1,483 0.00   0 0  
resmgr:free threads list 3,238 1.51 0.00 0 0  
resmgr:resource group CPU method 1,485 0.74 0.00 0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 899,990 0.02 0.00 0 573 0.00
rules engine aggregate statistics 3 0.00   0 0  
rules engine rule set statistics 306 0.00   0 0  
segmented array pool 8 0.00   0 0  
sequence cache 3,347 0.00   0 0  
session allocation 17,371 3.37 0.13 0 0  
session idle bit 115,097 0.01 0.00 0 0  
session state list latch 3,291 1.12 0.00 0 0  
session switching 2,921 0.00   0 0  
session timer 4,900 0.00   0 0  
shared pool 216,902 1.25 0.03 0 0  
shared pool simulator 24,551 0.00   0 0  
simulator hash latch 306,615 0.00 0.00 0 0  
simulator lru latch 0     0 305,921 0.00
slave class 49 0.00   0 0  
slave class create 317 0.95 1.00 0 0  
sort extent pool 499 0.00   0 0  
state object free list 6 0.00   0 0  
statistics aggregation 2,940 0.00   0 0  
threshold alerts latch 2,288 0.00   0 0  
transaction allocation 617 0.00   0 0  
transaction branch allocation 4,900 0.00   0 0  
undo global data 22,929 0.00   0 4 0.00
user lock 1,499 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
ges resource hash list 439,085 6,809 6,145 665 0 0 0
library cache lock 407,238 3,484 9 3,475 0 0 0
shared pool 216,902 2,711 89 2,624 0 0 0
library cache 293,893 1,160 32 1,130 0 0 0
session allocation 17,371 586 77 517 0 0 0
cache buffers chains 8,190,884 410 179 232 0 0 0
gcs resource hash 441,651 259 11 248 0 0 0
interrupt manipulation 8,248 207 4 204 0 0 0
active service list 32,470 178 35 144 0 0 0
qmn task queue latch 1,540 145 145 0 0 0 0
gcs opaque info freelist 185,124 144 1 143 0 0 0
KCL gc element parent latch 321,524 103 12 91 0 0 0
parallel query stats 1,801 65 7 58 0 0 0
dummy allocation 3,288 53 3 50 0 0 0
enqueues 269,717 50 9 41 0 0 0
ges caches resource lists 1,258,391 37 10 27 0 0 0
query server freelists 6,636 34 13 21 0 0 0
KJCT flow control latch 416,011 27 2 26 0 0 0
cache buffers lru chain 44,361 18 2 16 0 0 0
messages 367,894 18 2 16 0 0 0
enqueue hash chains 312,730 16 6 10 0 0 0
KJC message pool free list 35,366 9 1 8 0 0 0
name-service request queue 113,531 8 4 4 0 0 0
object queue header operation 103,044 7 2 5 0 0 0
name-service request 720 6 2 4 0 0 0
redo allocation 13,542 3 3 0 0 0 0
slave class create 317 3 3 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclwrt 0 5 0
KCL gc element parent latch kclnfndnewm 0 4 3
KCL gc element parent latch kclnfnd 0 2 2
KCL gc element parent latch KCLUNLNK 0 1 4
KCL gc element parent latch kclbla 0 1 0
KCL gc element parent latch kclgrantlk 0 1 0
KCL gc element parent latch kclplz 0 1 0
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 1 0
KJCT flow control latch kjcts_sqenq: queue a message 0 2 0
active service list kswslogon: session logout 0 43 43
active service list kswssetsvc: PX session switch service 0 40 5
cache buffers chains kclwrt 0 167 0
cache buffers chains kcbgtcr: kslbegin excl 0 24 22
cache buffers chains kcbrls: kslbegin 0 12 14
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 0
cache buffers chains kclbla 0 1 1
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 1 1
cache buffers lru chain kcbzgws 0 1 1
channel operations parent latch ksrmfree() 0 2 0
dummy allocation ktcdod 0 3 3
enqueue hash chains ksqrcl 0 4 1
enqueue hash chains ksqcmi: if lk mode requested 0 1 1
enqueue hash chains ksqgtl3 0 1 4
enqueues ksqies 0 7 8
enqueues ksqdel 0 1 0
enqueues ksqgel: create enqueue 0 1 1
event range base latch No latch 0 151 150
gcs opaque info freelist kjbrgrant free opaque info 0 1 0
gcs resource hash kclwrt 0 10 0
gcs resource hash kjbassume 0 1 1
ges resource hash list kjakcai: search for resp by resname 0 5,351 2
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 738 7
ges resource hash list kjrmas1: lookup master node 0 29 0
ges resource hash list kjlrlr: remove lock from resource queue 0 11 3,491
ges resource hash list kjucvl: lock convert request 0 6 2,617
ges resource hash list kjrref: find matched resource 0 3 23
ges resource hash list kjcvscn: remove from scan queue 0 2 0
ges resource table freelist kjrm2c: move resource to cache 0 5 10
ges resource table freelist kjruch: cached obj cleanup 0 3 0
ges resource table freelist kjrchc2: cached obj cleanup 0 2 0
interrupt manipulation ksursi0 0 4 4
library cache kglobpn: child: 0 9 10
library cache kglpndl: child: after processing 0 8 2
library cache kglLockCursor 0 4 1
library cache kglhdgn: child: 0 4 6
library cache kglpin 0 3 8
library cache lock kgllkdl: child: no lock handle 0 4 3
library cache lock kgllkdl: child: cleanup 0 3 4
messages ksaamb: after wakeup 0 2 0
name-service request kjxgndel: create a request so 0 1 1
name-service request kjxgndel: request done - delete request so 0 1 1
name-service request queue kjxgndel: queue a delete request 0 3 4
name-service request queue kjxgnapq: process a request 0 1 0
object queue header operation kcbw_unlink_q 0 2 2
object queue header operation kcbo_switch_mq_bg 0 1 1
parallel query stats kxfprst: KSLBEGIN:1 0 7 7
query server freelists kxfpobadf 0 9 9
query server freelists kxfpobrmf 0 4 4
redo allocation kcrfw_redo_gen: redo allocation 1 0 3 0
session allocation kxfprdp 0 41 46
session allocation ksuxds: KSUSFCLC not set 0 33 31
session allocation kxfpqidqr 0 3 0
shared pool kghalo 0 73 60
shared pool kghfre 0 16 29
slave class create ksvcreate 0 3 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
BUSINESS BUSINESS04 AJBYLGRJF   TABLE 763,360 17.87
BUSINESS BUSINESS01 J_ZYJS_ZYDJB   TABLE 653,504 15.30
BUSINESS BUSINESS01 FGRZRXX   TABLE 367,408 8.60
BUSINESS INDEX03 PK_FGRZRXX   INDEX 263,664 6.17
BUSINESS BUSINESS01 J_ZGBXJLB   TABLE 232,240 5.44

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
BUSINESS BUSINESS01 J_GRZHB   TABLE 6,454 61.55
BUSINESS DATA04 FGRHDGZ_BAK P2001 TABLE PARTITION 878 8.37
FINANCE INDEX02 INDEX_GMXZYB   INDEX 626 5.97
FINANCE INDEX02 IDX_GMXZB_DETAIL   INDEX 352 3.36
FINANCE INDEX03 UK_TABLE_GBB   INDEX 143 1.36

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
BUSINESS INDEX04 IDX_IC_FYDB_PART P2012_8 INDEX PARTITION 3 27.27
BUSINESS INDEX03 IDX_FYDB_YYDM_PDBM   INDEX 2 18.18
SYS SYSAUX WRH$_SERVICE_WAIT_CLASS_PK 7517_15922 INDEX PARTITION 2 18.18
BUSINESS DATA05 IDX_IC_JSDB_PART P2012_08 INDEX PARTITION 1 9.09
BUSINESS INDEX04 IDX_J_ZYJS_FYJLB_YYDM_ZYH_ZGBH   INDEX 1 9.09

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
BUSINESS INDEX01 PK_J_ZYJS_ZYDJB1   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
BUSINESS INDEX03 IDX_JSDB_YYDM_PDBM   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
BUSINESS BUSINESS01 J_GRZHB   TABLE 8,180 61.08
BUSINESS BUSINESS01 LS_FYDB   TABLE 685 5.11
BUSINESS INDEX01 PK_LS_FYDB   INDEX 404 3.02
SYS SYSTEM JOB$   TABLE 327 2.44
SYS SYSAUX SYS_IOT_TOP_8802   INDEX 288 2.15

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
BUSINESS BUSINESS01 J_GRZHB   TABLE 5,771 46.68
FINANCE INDEX03 TABLE_GG22   INDEX 814 6.58
BUSINESS DATA04 FGRHDGZ_BAK P2001 TABLE PARTITION 642 5.19
BUSINESS INDEX04 IDX_IC_FYDB_PART P2012_8 INDEX PARTITION 271 2.19
BUSINESS BUSINESS01 LS_FYDB   TABLE 266 2.15

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 191 3.14 0   0 1
dc_database_links 753 0.00 0   0 1
dc_global_oids 5,093 0.00 0   0 82
dc_histogram_data 207,321 0.53 0   0 11,338
dc_histogram_defs 58,797 1.19 0   0 5,449
dc_object_grants 80 0.00 0   0 125
dc_object_ids 64,144 0.05 0   0 1,638
dc_objects 7,318 0.79 0   1 779
dc_profiles 372 0.00 0   0 1
dc_rollback_segments 12,575 0.00 0   0 162
dc_segments 17,376 0.81 0   13 1,400
dc_sequences 38 52.63 0   38 2
dc_tablespace_quotas 1 100.00 0   1 1
dc_tablespaces 16,790 0.00 0   0 29
dc_usernames 2,830 0.00 0   0 16
dc_users 41,052 0.00 0   0 53
outstanding_alerts 1,010 96.83 0   3 1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 6 6 0
dc_histogram_defs 698 0 424
dc_object_ids 29 0 45
dc_objects 60 6 197
dc_segments 158 16 254
dc_sequences 76 19 1
dc_tablespace_quotas 2 0 0
outstanding_alerts 1,983 976 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 154 0.65 7,244 0.10 4 0
CLUSTER 60 0.00 99 1.01 1 0
INDEX 26 11.54 102 5.88 3 0
JAVA DATA 2 100.00 2 100.00 0 0
JAVA RESOURCE 2 100.00 2 100.00 0 0
JAVA SOURCE 2 100.00 2 100.00 0 0
SQL AREA 12,155 29.74 121,934 5.66 209 85
TABLE/PROCEDURE 1,198 1.42 39,466 0.62 132 0
TRIGGER 218 1.38 1,433 0.42 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 99 1 1 0 0
INDEX 102 4 1 1 0
JAVA DATA 2 2 0 0 0
JAVA RESOURCE 2 2 0 0 0
JAVA SOURCE 2 2 0 0 0
TABLE/PROCEDURE 11,455 52 26 32 0
TRIGGER 2 3 1 1 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 188.50   3.63 3.95 15 15 52 52
  Freeable 76.38 0.00 4.02 10.98 47   19 19
  SQL 1.97 1.28 0.06 0.07 0 3 33 31
  PL/SQL 1.44 0.60 0.03 0.05 0 0 50 50
E Other 173.67   3.47 4.12 15 15 50 50
  Freeable 77.19 0.00 4.29 11.23 47   18 18
  SQL 1.95 1.53 0.06 0.09 0 3 31 26
  PL/SQL 1.18 0.53 0.02 0.04 0 0 48 48

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 3,942,645,760  
Fixed Size 2,074,976  
Redo Buffers 14,700,544  
Variable Size 1,140,852,384  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.54 1.54 0.00
large free memory 46.09 46.09 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor 111.91 81.22 -27.42
shared KGH: NO ACCESS 71.88 71.88 0.00
shared PCursor 70.80 50.87 -28.15
shared db_block_hash_buckets 22.50 22.50 0.00
shared free memory 222.22 275.94 24.17
shared gcs resources 76.52 76.52 0.00
shared gcs shadows 45.82 45.82 0.00
shared kglsim heap 12.31 12.31 0.00
shared kglsim object batch 22.33 22.33 0.00
shared library cache 31.80 28.95 -8.98
shared sql area 181.21 202.63 11.82
shared sql area:PLSQL 53.25 33.09 -37.85
streams free memory 16.00 16.00 0.00
  buffer_cache 3,760.00 3,760.00 0.00
  fixed_sga 1.98 1.98 0.00
  log_buffer 14.02 14.02 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 150,000 0 0
QMON Slaves 50,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 3 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 131,583 400,656 495206 495206
gcs_shadows 229,992 427,473 495206 495206
processes 51 211 230 230


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/oracle/admin/bxgrid/adump   
background_dump_dest /u01/oracle/admin/bxgrid/bdump   
cluster_database TRUE   
cluster_database_instances 4   
compatible 10.2.0.1.0   
control_files +DG2/bxgrid/controlfile/current.260.732825485, +DG4/bxgrid/controlfile/current.256.732825485   
core_dump_dest /u01/oracle/admin/bxgrid/cdump   
db_block_size 8192   
db_create_file_dest +DG2   
db_domain      
db_file_multiblock_read_count 16   
db_name bxgrid   
db_recovery_file_dest +DG4   
db_recovery_file_dest_size 8589934592   
disk_asynch_io FALSE   
dispatchers (PROTOCOL=TCP) (SERVICE=bxgridXDB)   
filesystemio_options NONE   
instance_number 2   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=10.65.99.11)(PORT=1521))   
log_archive_dest_1 location=/arc_des   
log_archive_dest_2 location=/backup/arc_des   
log_archive_dest_3 location=/bxdbbak   
log_archive_dest_state_1 ENABLE   
log_archive_dest_state_2 ENABLE   
log_archive_dest_state_3 DEFER   
open_cursors 300   
pga_aggregate_target 1699741696   
processes 230   
remote_listener LISTENERS_BXGRID   
remote_login_passwordfile EXCLUSIVE   
service_names srv_bxgrid, bxgrid   
sessions 258   
sga_target 5100273664   
spfile +DG1/bxgrid/spfilebxgrid.ora   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /u01/oracle/admin/bxgrid/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 45,789 4.23 23.31
acks for commit broadcast(logical) 45,964 4.24 23.40
broadcast msgs on commit(actual) 8,643 0.80 4.40
broadcast msgs on commit(logical) 10,092 0.93 5.14
broadcast msgs on commit(wasted) 387 0.04 0.20
broadcast on commit wait time(ms) 472 0.04 0.24
broadcast on commit waits 2,698 0.25 1.37
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 56 0.01 0.03
flow control messages sent 177 0.02 0.09
gcs assume cvt 6 0.00 0.00
gcs assume no cvt 87,866 8.11 44.74
gcs ast xid 1 0.00 0.00
gcs blocked converts 6,444 0.59 3.28
gcs blocked cr converts 10,448 0.96 5.32
gcs compatible basts 245 0.02 0.12
gcs compatible cr basts (global) 464 0.04 0.24
gcs compatible cr basts (local) 85,514 7.89 43.54
gcs cr basts to PIs 4 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 723 0.07 0.37
gcs dbwr write request msgs 849 0.08 0.43
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 590 0.05 0.30
gcs immediate (null) converts 2,737 0.25 1.39
gcs immediate cr (compatible) converts 1 0.00 0.00
gcs immediate cr (null) converts 9,879 0.91 5.03
gcs indirect ast 11,326 1.05 5.77
gcs lms flush pi msgs 635 0.06 0.32
gcs lms write request msgs 823 0.08 0.42
gcs msgs process time(ms) 5,588 0.52 2.85
gcs msgs received 345,029 31.84 175.68
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 1,582 0.15 0.81
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 7 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 44,382 4.10 22.60
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 4,368 0.40 2.22
gcs side channel msgs logical 29,617 2.73 15.08
gcs stale cr 4 0.00 0.00
gcs undo cr 88 0.01 0.04
gcs write notification msgs 29 0.00 0.01
gcs writes refused 9 0.00 0.00
ges msgs process time(ms) 5,687 0.52 2.90
ges msgs received 119,274 11.01 60.73
global posts dropped 0 0.00 0.00
global posts queue time 16 0.00 0.01
global posts queued 27 0.00 0.01
global posts requested 27 0.00 0.01
global posts sent 27 0.00 0.01
implicit batch messages received 17,995 1.66 9.16
implicit batch messages sent 8,621 0.80 4.39
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 17,150 1.58 8.73
messages queue sent actual 112,441 10.38 57.25
messages queue sent logical 127,283 11.74 64.81
messages received actual 312,357 28.82 159.04
messages received logical 464,303 42.84 236.41
messages sent directly 34,185 3.15 17.41
messages sent indirectly 55,220 5.10 28.12
messages sent not implicit batched 103,820 9.58 52.86
messages sent pbatched 180,520 16.66 91.91
msgs causing lmd to send msgs 52,970 4.89 26.97
msgs causing lms(s) to send msgs 37,143 3.43 18.91
msgs received queue time (ms) 1,482 0.14 0.75
msgs received queued 464,297 42.84 236.40
msgs sent queue time (ms) 2,601 0.24 1.32
msgs sent queue time on ksxp (ms) 20,936 1.93 10.66
msgs sent queued 126,321 11.66 64.32
msgs sent queued on ksxp 223,084 20.58 113.59
number of ges deadlock detected 0 0.00 0.00
process batch messages received 96,519 8.91 49.14
process batch messages sent 144,513 13.33 73.58


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 5,706
CURRENT Block Requests 1,428
Data Block Requests 5,707
Undo Block Requests 88
TX Block Requests 970
Current Results 6,996
Private results 81
Zero Results 57
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,477
Fairness Clears 0
Free GC Elements 0
Flushes 60
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 220
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 76,513 100.00 0.00 0.00 0.00 0.00
Flushes 74 47.30 43.24 9.46 0.00 0.00
Writes 734 67.85 30.93 1.23 0.00 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
4 data block 6,239 99.81 0.19 0.00 5,837 99.33 0.43 0.24
3 data block 3,584 99.69 0.31 0.00 3,893 98.87 0.72 0.41
1 data block 2,163 99.82 0.18 0.00 2,318 98.75 0.60 0.65
4 undo header 450 99.56 0.44 0.00 7 100.00 0.00 0.00
3 undo header 413 99.27 0.73 0.00 9 100.00 0.00 0.00
1 undo header 188 100.00 0.00 0.00 6 100.00 0.00 0.00
1 Others 83 100.00 0.00 0.00 104 96.15 3.85 0.00
4 Others 89 95.51 4.49 0.00 86 100.00 0.00 0.00
3 Others 72 100.00 0.00 0.00 91 100.00 0.00 0.00
3 undo block 41 100.00 0.00 0.00 0      
1 undo block 31 100.00 0.00 0.00 0      
4 undo block 23 95.65 4.35 0.00 0      


Back to Top

End of Report