WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
IMSCMDB1971518695imscmdb1110.2.0.4.0YESimsdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:310024-Mar-14 23:07:32330 3.8
End Snap:310124-Mar-14 23:59:48325 3.9
Elapsed:  52.27 (mins)  
DB Time:  229.20 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 4,368M 4,368MStd Block Size: 8K
Shared Pool Size: 5,824M 5,824MLog Buffer: 14,328K

Load Profile

Per SecondPer Transaction
Redo size: 599,019.56 929.37
Logical reads: 31,554.99 48.96
Block changes: 4,306.21 6.68
Physical reads: 12.57 0.02
Physical writes: 81.38 0.13
User calls: 3,042.59 4.72
Parses: 1,398.16 2.17
Hard parses: 0.70 0.00
Sorts: 5.65 0.01
Logons: 0.10 0.00
Executes: 1,401.83 2.17
Transactions: 644.54 

% Blocks changed per Read: 13.65Recursive Call %: 19.83
Rollback per transaction %: 5.05Rows per Sort: 57.47

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 99.99
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.82Soft Parse %: 99.95
Execute to Parse %: 0.26Latch Hit %: 99.24
Parse CPU to Parse Elapsd %: 0.80% Non-Parse CPU: 99.36

Shared Pool Statistics

BeginEnd
Memory Usage %: 76.42 77.64
% SQL with executions>1: 97.29 95.55
% Memory for SQL w/exec>1: 96.87 91.36

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
latch: library cache 124,490 31,081 250 226.0Concurrency
cursor: pin S wait on X 1,334,178 13,678 10 99.5Concurrency
CPU time  3,508  25.5 
latch: shared pool 9,581 2,386 249 17.4Concurrency
log file sync 1,934,123 2,206 1 16.0Commit

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 295.00 0.46
Global Cache blocks served: 440.61 0.68
GCS/GES messages received: 1,092.87 1.70
GCS/GES messages sent: 956.32 1.48
DBWR Fusion writes: 41.48 0.06
Estd Interconnect traffic (KB) 6,285.09 

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

Buffer access - local cache %: 99.05
Buffer access - remote cache %: 0.93
Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 1.6
Avg global cache current block receive time (ms): 2.0
Avg global cache cr block build time (ms): 0.1
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 1.4
Avg global cache cr block flush time (ms): 16.5
Avg global cache current block pin time (ms): 0.2
Avg global cache current block send time (ms): 1.5
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 1.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 7.5
Avg message sent queue time on ksxp (ms): 0.5
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.5
Avg GES message process time (ms): 0.4
% of direct sent messages: 35.55
% of indirect sent messages: 14.31
% of flow controlled messages: 50.13

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 8,264.78 60.10
DB CPU 3,508.21 25.51
parse time elapsed 2,561.26 18.62
hard parse elapsed time 166.99 1.21
RMAN cpu time (backup/restore) 25.57 0.19
connection management call elapsed time 2.62 0.02
hard parse (sharing criteria) elapsed time 2.17 0.02
PL/SQL execution elapsed time 1.02 0.01
inbound PL/SQL rpc elapsed time 0.47 0.00
sequence load elapsed time 0.07 0.00
repeated bind elapsed time 0.00 0.00
DB time 13,752.03  
background elapsed time 4,878.70  
background cpu time 394.25  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 1,883,771 70.83 47,319 25 0.93
Other 2,162,414 1.64 2,503 1 1.07
Commit 1,934,123 0.00 2,206 1 0.96
Cluster 979,609 0.05 2,000 2 0.48
Administrative 127,076 0.00 1,391 11 0.06
System I/O 1,502,834 0.00 424 0 0.74
User I/O 34,963 0.00 178 5 0.02
Application 6,068 0.00 28 5 0.00
Configuration 19,233 98.60 11 1 0.01
Network 7,206,688 0.00 8 0 3.57

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch: library cache 124,490 0.00 31,081 250 0.06
cursor: pin S wait on X 1,334,178 100.00 13,678 10 0.66
latch: shared pool 9,581 0.00 2,386 249 0.00
log file sync 1,934,123 0.00 2,206 1 0.96
latch free 6,420 0.00 1,401 218 0.00
Backup: sbtwrite2 127,058 0.00 1,217 10 0.06
gc cr block 2-way 471,469 0.00 712 2 0.23
gc current block 2-way 454,947 0.00 627 1 0.23
log file parallel write 1,361,401 0.00 325 0 0.67
rdbms ipc reply 469 33.69 311 663 0.00
gc buffer busy 10,354 3.06 211 20 0.01
gc cr grant 2-way 8,839 1.66 189 21 0.00
wait for scn ack 1,057,222 0.00 187 0 0.52
db file sequential read 24,541 0.00 165 7 0.01
gc current block busy 4,581 0.00 129 28 0.00
latch: gcs resource hash 846 0.00 126 149 0.00
cr request retry 121 100.00 98 811 0.00
enq: WF - contention 211 90.52 93 442 0.00
Backup: sbtbackup 3 0.00 89 29817 0.00
latch: cache buffers chains 6,860 0.00 83 12 0.00
Backup: sbtclose2 5 0.00 81 16150 0.00
latch: checkpoint queue latch 298 0.00 80 269 0.00
db file parallel write 125,187 0.00 61 0 0.06
row cache lock 5,045 0.16 54 11 0.00
gc current grant busy 9,894 0.17 52 5 0.00
gc cr multi block request 2,914 0.03 37 13 0.00
kksfbc child completion 697 99.57 34 49 0.00
latch: cache buffers lru chain 165 0.00 31 189 0.00
DFS lock handle 2,811 1.74 30 11 0.00
log file sequential read 2,041 0.00 29 14 0.00
gc cr block busy 2,828 0.25 25 9 0.00
latch: KCL gc element parent latch 872 0.00 24 28 0.00
enq: CF - contention 121 27.27 17 142 0.00
SQL*Net break/reset to client 639 0.00 17 27 0.00
latch: redo allocation 351 0.00 12 34 0.00
gcs log flush sync 17,245 18.83 11 1 0.01
latch: row cache objects 294 0.00 11 38 0.00
reliable message 240 3.75 11 45 0.00
cursor: pin S 994,396 0.00 10 0 0.49
gc current grant 2-way 13,286 0.02 9 1 0.01
buffer busy waits 2,718 0.00 9 3 0.00
latch: ges resource hash list 404 0.00 9 22 0.00
LGWR wait for redo copy 40,583 1.18 8 0 0.02
SQL*Net message to client 7,152,554 0.00 7 0 3.54
enq: TX - allocate ITL entry 18 66.67 7 388 0.00
db file scattered read 426 0.00 6 15 0.00
latch: enqueue hash chains 66 0.00 6 94 0.00
enq: TX - row lock contention 102 0.00 6 58 0.00
enq: TM - contention 5,127 0.00 5 1 0.00
gc current retry 29 0.00 5 174 0.00
cursor: mutex X 339,060 0.00 5 0 0.17
enq: TX - index contention 88 4.55 5 53 0.00
control file sequential read 10,362 0.00 4 0 0.01
RMAN backup & recovery I/O 136 0.00 4 27 0.00
db file parallel read 194 0.00 3 17 0.00
library cache pin 637 0.00 3 5 0.00
Backup: sbtinfo2 5 0.00 3 606 0.00
log file switch completion 103 0.00 2 23 0.00
read by other session 118 0.00 2 18 0.00
latch: library cache lock 80 0.00 2 25 0.00
direct path read 9,527 0.00 2 0 0.00
library cache lock 996 0.00 1 1 0.00
gc cr disk read 24 0.00 1 55 0.00
Log archive I/O 2,029 0.00 1 1 0.00
control file parallel write 1,654 0.00 1 1 0.00
enq: TX - contention 8 0.00 1 98 0.00
enq: HW - contention 48 0.00 1 14 0.00
SQL*Net more data to client 52,864 0.00 1 0 0.03
latch: redo writing 51 0.00 1 13 0.00
latch: object queue header operation 51 0.00 1 11 0.00
os thread startup 5 0.00 0 86 0.00
gc current block congested 56 0.00 0 6 0.00
gc cr block 3-way 1 0.00 0 352 0.00
cursor: mutex S 59,739 0.00 0 0 0.03
global enqueue expand wait 31 100.00 0 10 0.00
name-service call wait 5 0.00 0 52 0.00
gc cr block congested 46 0.00 0 5 0.00
gc current multi block request 209 0.00 0 1 0.00
enq: TA - contention 9 0.00 0 24 0.00
CGS wait for IPC msg 22,082 100.00 0 0 0.01
enq: RO - fast object reuse 199 0.00 0 1 0.00
enq: FB - contention 73 0.00 0 2 0.00
log buffer space 60 0.00 0 3 0.00
undo segment extension 18,953 99.99 0 0 0.01
latch: session allocation 79 0.00 0 2 0.00
enq: TS - contention 110 0.00 0 1 0.00
ksxr poll remote instances 13,848 44.13 0 0 0.01
IPC send completion sync 121 99.17 0 1 0.00
gc cr failure 120 0.00 0 1 0.00
gc current split 9 0.00 0 9 0.00
latch: messages 116 0.00 0 1 0.00
KJC: Wait for msg sends to complete 33 0.00 0 2 0.00
enq: PS - contention 72 0.00 0 1 0.00
enq: RS - prevent file delete 64 0.00 0 1 0.00
enq: AF - task serialization 24 0.00 0 2 0.00
gc current grant congested 3 0.00 0 12 0.00
SQL*Net more data from client 1,270 0.00 0 0 0.00
PX Deq: reap credit 1,987 97.79 0 0 0.00
control file single write 16 0.00 0 1 0.00
enq: DR - contention 1 0.00 0 14 0.00
enq: TT - contention 32 0.00 0 0 0.00
PX Deq Credit: send blkd 26 19.23 0 0 0.00
direct path write 157 0.00 0 0 0.00
enq: JS - job run lock - synchronize 1 0.00 0 6 0.00
buffer deadlock 42 95.24 0 0 0.00
lock escalate retry 26 96.15 0 0 0.00
PX Deq: Signal ACK 22 36.36 0 0 0.00
enq: US - contention 3 0.00 0 1 0.00
log file single write 8 0.00 0 0 0.00
enq: WL - contention 2 0.00 0 0 0.00
Backup: sbtinit 1 0.00 0 1 0.00
ges inquiry response 2 0.00 0 0 0.00
enq: PW - flush prewarm buffers 1 0.00 0 0 0.00
lock deadlock retry 5 100.00 0 0 0.00
Backup: sbtend 3 0.00 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
Backup: sbtinit2 1 0.00 0 0 0.00
SQL*Net message from client 7,152,536 0.00 357,341 50 3.54
gcs remote message 4,227,483 66.70 14,873 4 2.09
PX Idle Wait 1,162 94.49 2,746 2363 0.00
Streams AQ: qmn coordinator idle wait 170 50.59 2,339 13758 0.00
DIAG idle wait 11,945 0.00 2,337 196 0.01
Streams AQ: qmn slave idle wait 84 0.00 2,336 27804 0.00
virtual circuit status 78 100.00 2,304 29535 0.00
ges remote message 56,026 88.91 2,238 40 0.03
Streams AQ: waiting for messages in the queue 209 100.00 1,973 9442 0.00
jobq slave wait 32 100.00 94 2930 0.00
PX Deq: Execution Msg 269 28.62 24 88 0.00
PX Deq: Join ACK 33 39.39 0 9 0.00
PX Deq: Parse Reply 31 41.94 0 8 0.00
PX Deq: Execute Reply 30 30.00 0 5 0.00
class slave wait 3 0.00 0 13 0.00
PX Deq: Msg Fragment 82 26.83 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 170 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch: library cache 3,304 0.00 907 274 0.00
events in waitclass Other 1,155,734 2.80 825 1 0.57
log file parallel write 1,359,001 0.00 324 0 0.67
db file parallel write 124,711 0.00 60 0 0.06
log file sequential read 2,041 0.00 29 14 0.00
latch: cache buffers chains 238 0.00 7 27 0.00
enq: TM - contention 5,069 0.00 5 1 0.00
control file sequential read 6,514 0.00 3 0 0.00
gc cr multi block request 174 0.00 2 10 0.00
Log archive I/O 2,029 0.00 1 1 0.00
control file parallel write 1,181 0.00 1 1 0.00
gc current block busy 2 0.00 1 352 0.00
latch: redo writing 51 0.00 1 13 0.00
os thread startup 4 0.00 0 99 0.00
buffer busy waits 55 0.00 0 3 0.00
log buffer space 60 0.00 0 3 0.00
db file parallel read 14 0.00 0 10 0.00
enq: RO - fast object reuse 60 0.00 0 2 0.00
direct path write 134 0.00 0 0 0.00
log file single write 8 0.00 0 0 0.00
gc current multi block request 3 0.00 0 0 0.00
direct path read 254 0.00 0 0 0.00
gc current grant 2-way 14 0.00 -0 -1 0.00
enq: HW - contention 4 0.00 -0 -49 0.00
library cache pin 5 0.00 -0 -65 0.00
db file sequential read 17 0.00 -1 -72 0.00
gc cr block 2-way 50 0.00 -3 -58 0.00
latch: row cache objects 16 0.00 -3 -211 0.00
gc current block 2-way 96 -2.08 -6 -68 0.00
rdbms ipc message 993,929 4.47 33,577 34 0.49
gcs remote message 4,216,677 66.70 14,805 4 2.09
Streams AQ: qmn coordinator idle wait 170 50.59 2,339 13758 0.00
Streams AQ: qmn slave idle wait 84 0.00 2,336 27804 0.00
DIAG idle wait 11,877 0.00 2,324 196 0.01
pmon timer 925 99.68 2,321 2509 0.00
ges remote message 55,786 88.86 2,225 40 0.03
smon timer 66 10.61 1,669 25290 0.00
PX Deq: Join ACK 18 44.44 0 11 0.00
PX Deq: Parse Reply 18 44.44 0 0 0.00
PX Deq: Execute Reply 17 35.29 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 170 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 14,627
AVG_IDLE_TIME 182,277
AVG_IOWAIT_TIME 3,503
AVG_SYS_TIME 7,947
AVG_USER_TIME 6,622
BUSY_TIME 469,931
IDLE_TIME 5,834,810
IOWAIT_TIME 114,122
SYS_TIME 256,179
USER_TIME 213,752
LOAD 0
OS_CPU_WAIT_TIME 764,300
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 34,359,738,368
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
imscmdb 59,762.50 3,649.20 22,317 97,757,963
SYS$USERS 924.10 1.70 1 1,182
SYS$BACKGROUND 0.00 0.00 19,764 2,923,602
imscmdbXDB 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
imscmdb 20051 7096 1865083 4337213 0 0 7240646 791
SYS$USERS 1 0 5815 177113 129496 142287 3993 0
SYS$BACKGROUND 15546 10887 9811 101384 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
49 1 466 0.11 0.36 d8mg0p59qk74n TransDataDB INSERT INTO PERFORMANCEDBA.COM...
19 18 233,545 0.00 0.14 a7wnwmnur2vh1 TransDataDB SELECT CLASSNAME, CLASSPROPERT...
17 6 23,862 0.00 0.13 6d4n3qaqs75fg TransDataDB SELECT V2345, H, L, A, to_char...
15 6 23,862 0.00 0.11 9p1a94m9kpmf0 TransDataDB SELECT V2345, H, L, A, to_char...
15 6 26,067 0.00 0.11 8m3c3g0tt3a4n TransDataDB SELECT V2315, H, L, A, to_char...
14 3 1 14.44 0.11 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
13 6 23,862 0.00 0.10 538y6wktxwcu6 TransDataDB SELECT V2345, H, L, A, to_char...
12 6 26,086 0.00 0.09 dd8ydjphwabw3 TransDataDB SELECT V2330, H, L, A, to_char...
12 8 26,087 0.00 0.09 31pagbfwwqpzc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
12 7 25,391 0.00 0.09 f2v9yzad75zd8 TransDataDB SELECT V2345, H, L, A, to_char...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
18 19 233,545 0.00 0.14 a7wnwmnur2vh1 TransDataDB SELECT CLASSNAME, CLASSPROPERT...
8 11 23,862 0.00 0.08 6pnkdcs4kxtb9 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
8 11 24,325 0.00 0.08 5543z7x7dh4tj TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
8 10 23,862 0.00 0.08 6vmb5t7nfq4jj TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
8 9 23,861 0.00 0.07 brvuq71mwm3fm TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
8 10 23,862 0.00 0.08 4ts402dbsay3j TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
8 11 26,068 0.00 0.08 9kkdhcx73ppsp TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
8 10 24,325 0.00 0.07 3jtc1qgt0fkkg TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
8 10 23,861 0.00 0.07 acbxyk6wtc4dv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
8 10 23,862 0.00 0.07 719827rx4hd7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...

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
933,892 233,545 4.00 0.94 18.44 18.62 a7wnwmnur2vh1 TransDataDB SELECT CLASSNAME, CLASSPROPERT...
158,497 26,086 6.08 0.16 8.05 10.76 7dk96cv1rzs2t TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
158,405 26,068 6.08 0.16 8.09 10.63 9kkdhcx73ppsp TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,824 26,087 6.05 0.16 7.79 10.17 1jsh36rukbmbv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,496 26,087 6.04 0.16 7.80 10.06 9q7bnzjdawzds TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,486 26,086 6.04 0.16 7.76 9.00 915tr4thj1rjc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,454 26,087 6.04 0.16 7.75 9.28 0acmmmrhf0q8h TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,435 26,087 6.03 0.16 7.69 8.51 1s582dq54bf7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,435 26,087 6.03 0.16 7.76 11.74 31pagbfwwqpzc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
157,435 26,087 6.03 0.16 7.66 9.95 79h85v2x9357n TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...

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
140 466 0.30 0.36 0.66 48.97 d8mg0p59qk74n TransDataDB INSERT INTO PERFORMANCEDBA.COM...
139 1 139.00 0.35 2.99 14.44 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
115 1,067 0.11 0.29 0.46 0.68 db78fxqxwxt7r   select /*+ rule */ bucket, en...
24 23,862 0.00 0.06 5.88 13.30 538y6wktxwcu6 TransDataDB SELECT V2345, H, L, A, to_char...
18 23,862 0.00 0.05 6.08 14.80 9p1a94m9kpmf0 TransDataDB SELECT V2345, H, L, A, to_char...
16 25,391 0.00 0.04 6.54 11.73 f2v9yzad75zd8 TransDataDB SELECT V2345, H, L, A, to_char...
13 189 0.07 0.03 0.08 0.21 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
12 1 12.00 0.03 0.01 0.01 7qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAO...
10 23,862 0.00 0.03 6.00 17.24 6d4n3qaqs75fg TransDataDB SELECT V2345, H, L, A, to_char...
10 23,862 0.00 0.03 5.90 11.64 6dkkmgcdyy8xt TransDataDB SELECT V2345, H, L, A, to_char...

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
233,545 0 0.00 0.00 0.00 a7wnwmnur2vh1 TransDataDB SELECT CLASSNAME, CLASSPROPERT...
26,631 26,629 1.00 0.00 0.00 1z2dmx1dnphxx TransDataDB SELECT V2330, H, L, A, to_char...
26,631 26,631 1.00 0.00 0.00 43ynd5w17xcfx TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,085 1.00 0.00 0.00 0416t7jjtxut9 TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,086 1.00 0.00 0.00 0acmmmrhf0q8h TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,085 1.00 0.00 0.00 0x0zs5h78x0h5 TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,084 1.00 0.00 0.00 1auvdrtuh3b5c TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,086 1.00 0.00 0.00 1jsh36rukbmbv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,086 1.00 0.00 0.00 1s582dq54bf7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,087 1.00 0.00 0.00 31pagbfwwqpzc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
233,535 233,545 5.33 a7wnwmnur2vh1 TransDataDB SELECT CLASSNAME, CLASSPROPERT...
26,630 26,631 0.61 1z2dmx1dnphxx TransDataDB SELECT V2330, H, L, A, to_char...
26,630 26,631 0.61 43ynd5w17xcfx TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,087 0.59 0x0zs5h78x0h5 TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,087 0.59 1s582dq54bf7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,087 0.59 31pagbfwwqpzc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,087 0.59 63agkjg4j94xc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,087 0.59 706gqbwd2ard4 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
26,087 26,087 0.59 790486wy37gb5 TransDataDB SELECT V2330, H, L, A, to_char...
26,087 26,086 0.59 915tr4thj1rjc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
57 34 53txd0pcdmkhx JDBC Thin Client INSERT INTO QRTZ_FIRED_TRIGGER...
26 18 9qpgbymrs68cu JDBC Thin Client DELETE FROM QRTZ_TRIGGER_LISTE...
21 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...

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
38.82 79.29 48.97 0.66 466 d8mg0p59qk74n TransDataDB INSERT INTO PERFORMANCEDBA.COM...
11.25 65.25 17.24 6.00 23,862 6d4n3qaqs75fg TransDataDB SELECT V2345, H, L, A, to_char...
7.73 52.23 14.80 6.08 23,862 9p1a94m9kpmf0 TransDataDB SELECT V2345, H, L, A, to_char...
7.41 63.19 11.73 6.54 25,391 f2v9yzad75zd8 TransDataDB SELECT V2345, H, L, A, to_char...
5.79 49.77 11.64 5.90 23,862 6dkkmgcdyy8xt TransDataDB SELECT V2345, H, L, A, to_char...
5.46 51.73 10.55 5.97 23,862 gzs0h55cx8g49 TransDataDB SELECT V2345, H, L, A, to_char...
5.28 39.70 13.30 5.88 23,862 538y6wktxwcu6 TransDataDB SELECT V2345, H, L, A, to_char...
5.20 50.23 10.36 8.12 23,862 4ts402dbsay3j TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
5.07 43.83 11.57 8.06 23,862 ajn07xrwz56fc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
5.05 44.79 11.28 8.19 24,325 5543z7x7dh4tj TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
4.96 47.42 10.46 8.13 23,862 6vmb5t7nfq4jj TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.95 46.47 10.65 8.31 23,862 6pnkdcs4kxtb9 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.91 48.40 10.15 8.09 23,861 acbxyk6wtc4dv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.73 43.93 10.76 8.05 26,086 7dk96cv1rzs2t TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.72 43.49 10.86 7.75 26,067 8w4yhb6mknb89 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.69 43.78 10.71 7.83 26,068 dyz6wrww93c4v TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.61 45.62 10.11 8.08 23,862 719827rx4hd7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.58 45.77 10.01 8.09 24,325 3jtc1qgt0fkkg TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
4.55 38.76 11.74 7.76 26,087 31pagbfwwqpzc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.53 45.57 9.95 7.66 26,087 79h85v2x9357n TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.50 42.34 10.63 8.09 26,068 9kkdhcx73ppsp TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.44 43.62 10.19 8.06 23,862 0p99anf6c2x8d TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.44 46.38 9.58 8.07 23,862 8fpt5ucnft3t9 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.43 42.18 10.50 7.77 26,068 0n1bkdapwt4k6 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.34 42.63 10.19 7.85 26,087 63agkjg4j94xc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.28 40.70 10.52 7.76 26,068 4fk1jrk880p2g TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.24 43.51 9.74 8.04 23,862 1hd9g891vyc1f TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.19 42.25 9.91 7.86 26,068 g8xhxjhrd0bqf TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.18 41.12 10.16 7.80 26,067 ffkk1urf69j0g TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.17 41.46 10.06 7.80 26,087 9q7bnzjdawzds TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.15 42.85 9.69 7.78 26,086 2wa154k7xv997 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.14 44.06 9.41 8.13 23,861 brvuq71mwm3fm TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
4.13 43.15 9.58 8.05 23,862 asabyqw676kgn TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.09 45.25 9.04 7.95 23,862 a4frycu24a6vx TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.08 44.44 9.18 7.97 23,859 5udc1bks1585s TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
4.01 39.40 10.17 7.79 26,087 1jsh36rukbmbv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.89 41.90 9.28 7.75 26,087 0acmmmrhf0q8h TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.87 40.77 9.50 7.83 26,087 b53dw7hwt3bbc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.82 39.96 9.56 7.80 26,068 17n0s74rd39j9 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.82 41.03 9.30 7.86 26,087 706gqbwd2ard4 TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.82 41.41 9.21 7.90 23,861 0bfcsd1hvv2fn TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.78 38.99 9.70 7.83 26,068 d1kmhwmxxbku1 TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
3.70 41.10 9.00 7.76 26,086 915tr4thj1rjc TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.54 39.52 8.96 7.75 26,087 g32sjb5vqa3r0 TransDataDB UPDATE PERFORMANCEDBA.IPINTERF...
3.52 40.40 8.71 7.98 23,861 3tpucfvygvvdv TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.45 39.49 8.74 7.72 26,087 gjfphpzxv4ffy TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.31 27.92 11.84 5.64 26,086 dd8ydjphwabw3 TransDataDB SELECT V2330, H, L, A, to_char...
3.21 37.72 8.51 7.69 26,087 1s582dq54bf7r TransDataDB UPDATE PERFORMANCEDBA.INTERFAC...
3.18 47.21 6.73 5.56 26,631 1z2dmx1dnphxx TransDataDB SELECT V2330, H, L, A, to_char...
3.08 28.80 10.68 5.69 26,068 axsw40ptbjx7f TransDataDB SELECT V2315, H, L, A, to_char...
3.06 48.76 6.28 5.52 26,087 3yx618uc5furc TransDataDB SELECT V2330, H, L, A, to_char...
3.04 29.77 10.21 5.54 26,087 790486wy37gb5 TransDataDB SELECT V2330, H, L, A, to_char...
3.02 29.47 10.25 5.53 26,068 gvuy15dts87gj TransDataDB SELECT V2315, H, L, A, to_char...
3.01 20.60 14.61 5.60 26,067 8m3c3g0tt3a4n TransDataDB SELECT V2315, H, L, A, to_char...
2.97 29.13 10.19 5.60 26,068 a0d8mz8nkkarn TransDataDB SELECT V2315, H, L, A, to_char...
2.96 42.09 7.03 5.43 26,087 9ckkp7h8g10dy TransDataDB SELECT V2330, H, L, A, to_char...
2.91 39.51 7.35 5.56 26,068 g2rs33pxfqand TransDataDB SELECT V2315, H, L, A, to_char...
2.84 48.72 5.82 5.51 26,087 1auvdrtuh3b5c TransDataDB SELECT V2330, H, L, A, to_char...
2.79 27.04 10.33 5.57 26,068 4awxdk59mdq9g TransDataDB SELECT V2315, H, L, A, to_char...
2.78 41.61 6.68 5.52 26,087 ar1p2vfu1mhx1 TransDataDB SELECT V2330, H, L, A, to_char...
2.78 35.93 7.73 5.49 26,087 0416t7jjtxut9 TransDataDB SELECT V2330, H, L, A, to_char...
2.76 40.54 6.80 5.50 26,087 6kuknfaxkgug5 TransDataDB SELECT V2330, H, L, A, to_char...
2.75 39.52 6.96 5.63 26,086 9jbrfmgbv0172 TransDataDB SELECT V2330, H, L, A, to_char...
2.75 39.02 7.04 5.47 26,087 54j9jrkkytmny TransDataDB SELECT V2330, H, L, A, to_char...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0416t7jjtxut9SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
0acmmmrhf0q8hUPDATE PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
0bfcsd1hvv2fnUPDATE PERFORMANCEDBA.INTERFACEOUTFLOW5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
0n1bkdapwt4k6UPDATE PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
0p99anf6c2x8dUPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETRATE5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
0x0zs5h78x0h5SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
17n0s74rd39j9UPDATE PERFORMANCEDBA.INTERFACEINBROADCASTFLOW5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
1auvdrtuh3b5cSELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
1hd9g891vyc1fUPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETNUM5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
1jsh36rukbmbvUPDATE PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
1s582dq54bf7rUPDATE PERFORMANCEDBA.INTERFACEOUTFLOW5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
1z2dmx1dnphxxSELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.IPINTERFACEOUTTOTOLPR5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2wa154k7xv997UPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETRATE5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
31pagbfwwqpzcUPDATE PERFORMANCEDBA.INTERFACEINERRORPACKETNUM5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
3jtc1qgt0fkkgUPDATE PERFORMANCEDBA.IPINTERFACEOUTTOTOLPR5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
3tpucfvygvvdvUPDATE PERFORMANCEDBA.INTERFACEINFLOW5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
3yx618uc5furcSELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTERRORPACKETNUM5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
43ynd5w17xcfxSELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.IPINTERFACEINTOTOLPR5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
4awxdk59mdq9gSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.IPINTERFACESTATUS5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
4fk1jrk880p2gUPDATE PERFORMANCEDBA.INTERFACEOUTERRORPACKETNUM5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
4ts402dbsay3jUPDATE PERFORMANCEDBA.INTERFACEOUTBWUSEDRATE5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
538y6wktxwcu6SELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
53txd0pcdmkhxINSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
54j9jrkkytmnySELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTDROPPACKETNUM5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
5543z7x7dh4tjUPDATE PERFORMANCEDBA.IPINTERFACEINTOTOLPR5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
5udc1bks1585sUPDATE PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
63agkjg4j94xcUPDATE PERFORMANCEDBA.INTERFACEOUTDROPPACKETRATE5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
6d4n3qaqs75fgSELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
6dkkmgcdyy8xtSELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINERRORPACKETNUM5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
6kuknfaxkgug5SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINDROPPACKETNUM5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
6pnkdcs4kxtb9UPDATE PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
6vmb5t7nfq4jjUPDATE PERFORMANCEDBA.INTERFACEINERRORPACKETNUM5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
706gqbwd2ard4UPDATE PERFORMANCEDBA.INTERFACEINFLOW5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
719827rx4hd7rUPDATE PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
790486wy37gb5SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINERRORPACKETNUM5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
79h85v2x9357nUPDATE PERFORMANCEDBA.INTERFACEOUTBWUSEDRATE5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
7dk96cv1rzs2tUPDATE PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
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#
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
8fpt5ucnft3t9UPDATE PERFORMANCEDBA.INTERFACEOUTDROPPACKETNUM5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
8m3c3g0tt3a4nSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
8w4yhb6mknb89UPDATE PERFORMANCEDBA.INTERFACEINERRORPACKETNUM5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
915tr4thj1rjcUPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETNUM5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
9ckkp7h8g10dySELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.IPINTERFACESTATUS5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
9jbrfmgbv0172SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
9kkdhcx73ppspUPDATE PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
9p1a94m9kpmf0SELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
9q7bnzjdawzdsUPDATE PERFORMANCEDBA.INTERFACEOUTERRORPACKETNUM5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
9qpgbymrs68cuDELETE FROM QRTZ_TRIGGER_LISTENERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
a0d8mz8nkkarnSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
a4frycu24a6vxUPDATE PERFORMANCEDBA.INTERFACEINBROADCASTFLOW5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
a7wnwmnur2vh1SELECT CLASSNAME, CLASSPROPERTY FROM performancedba.MESSAGEKEYWORD WHERE SCENE='SGEPRI' AND ORIGINALCLASS='Firewall' AND KEYWORD='OriginalKey'
acbxyk6wtc4dvUPDATE PERFORMANCEDBA.INTERFACEOUTDROPPACKETRATE5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
ajn07xrwz56fcUPDATE PERFORMANCEDBA.INTERFACEOUTERRORPACKETNUM5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
ar1p2vfu1mhx1SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
asabyqw676kgnUPDATE PERFORMANCEDBA.INTERFACEOUTBROADCASTFLOW5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
axsw40ptbjx7fSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEUNICASTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
b53dw7hwt3bbcUPDATE PERFORMANCEDBA.INTERFACEINBROADCASTFLOW5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
brvuq71mwm3fmUPDATE PERFORMANCEDBA.IPINTERFACESTATUS5MIN SET V2345 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
d1kmhwmxxbku1UPDATE PERFORMANCEDBA.IPINTERFACESTATUS5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
d8mg0p59qk74nINSERT INTO PERFORMANCEDBA.COMPUTERSYSTEMRUNNINGTIME5MIN (RESOURCEID, TIME, V0000, H, L, A, HTIME, LTIME) Values (:1, to_date(:2, 'yyyy-mm-dd'), :3, :4, :5, :6, to_date(:7, 'yyyy-mm-dd hh24:mi:ss'), to_date(:8, 'yyyy-mm-dd hh24:mi:ss'))
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dd8ydjphwabw3SELECT V2330, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEOUTDROPPACKETRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
dyz6wrww93c4vUPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETRATE5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
f2v9yzad75zd8SELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.IPINTERFACEOUTTOTOLPR5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
ffkk1urf69j0gUPDATE PERFORMANCEDBA.INTERFACEINDROPPACKETNUM5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
g2rs33pxfqandSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINBROADCASTFLOW5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
g32sjb5vqa3r0UPDATE PERFORMANCEDBA.IPINTERFACESTATUS5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
g8xhxjhrd0bqfUPDATE PERFORMANCEDBA.INTERFACEBWUSEDRATE5MIN SET V2315 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
gjfphpzxv4ffyUPDATE PERFORMANCEDBA.INTERFACEOUTDROPPACKETNUM5MIN SET V2330 = :1, H=:2, L=:3, A=:4, HTIME=to_date(:5, 'yyyy-mm-dd hh24:mi:ss'), LTIME=to_date(:6, 'yyyy-mm-dd hh24:mi:ss') WHERE RESOURCEID = :7 AND TIME = to_date(:8, 'yyyy-mm-dd')
gvuy15dts87gjSELECT V2315, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')
gzs0h55cx8g49SELECT V2345, H, L, A, to_char(HTIME, 'yyyy-mm-dd hh24:mi:ss'), to_char(LTIME, 'yyyy-mm-dd hh24:mi:ss') FROM PERFORMANCEDBA.INTERFACEINBWUSEDRATE5MIN WHERE RESOURCEID = :1 AND TIME = to_date(:2, 'yyyy-mm-dd')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 73,269 23.36 0.04
CPU used when call started 72,996 23.28 0.04
CR blocks created 12,534 4.00 0.01
Cached Commit SCN referenced 7,087 2.26 0.00
Commit SCN cached 3 0.00 0.00
DB time 1,699,058 541.75 0.84
DBWR checkpoint buffers written 121,292 38.67 0.06
DBWR checkpoints 57 0.02 0.00
DBWR fusion writes 130,101 41.48 0.06
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 291 0.09 0.00
DBWR undo block writes 77,570 24.73 0.04
DFO trees parallelized 11 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 45 0.01 0.00
PX local messages sent 45 0.01 0.00
PX remote messages recv'd 171 0.05 0.00
PX remote messages sent 117 0.04 0.00
Parallel operations downgraded to serial 144 0.05 0.00
Parallel operations not downgraded 11 0.00 0.00
RowCR - row contention 120 0.04 0.00
RowCR attempts 11,183 3.57 0.01
RowCR hits 442 0.14 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 5 0.00 0.00
SQL*Net roundtrips to/from client 7,072,505 2,255.11 3.50
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 2,918 0.93 0.00
application wait time 772 0.25 0.00
background checkpoints completed 4 0.00 0.00
background checkpoints started 4 0.00 0.00
background timeouts 8,873 2.83 0.00
branch node splits 1 0.00 0.00
buffer is not pinned count 11,168,362 3,561.09 5.52
buffer is pinned count 8,225,919 2,622.88 4.07
bytes received via SQL*Net from client 1,728,803,515 551,238.49 855.24
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 1,214,695,802 387,312.42 600.91
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 7,329,855 2,337.16 3.63
calls to kcmgas 3,057,575 974.92 1.51
calls to kcmgcs 2,584 0.82 0.00
change write time 8,206 2.62 0.00
cleanout - number of ktugct calls 6,690 2.13 0.00
cleanouts and rollbacks - consistent read gets 1,349 0.43 0.00
cleanouts only - consistent read gets 2,400 0.77 0.00
cluster key scan block gets 11,925 3.80 0.01
cluster key scans 5,031 1.60 0.00
cluster wait time 172,458 54.99 0.09
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 69 0.02 0.00
commit batch/immediate requested 69 0.02 0.00
commit cleanout failures: block lost 32 0.01 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 777 0.25 0.00
commit cleanout failures: cannot pin 2,133 0.68 0.00
commit cleanouts 1,975,716 629.97 0.98
commit cleanouts successfully completed 1,972,774 629.03 0.98
commit immediate performed 69 0.02 0.00
commit immediate requested 69 0.02 0.00
commit txn count during cleanout 6,637 2.12 0.00
concurrency wait time 193,185 61.60 0.10
consistent changes 26,402 8.42 0.01
consistent gets 88,776,408 28,306.84 43.92
consistent gets - examination 12,307,441 3,924.30 6.09
consistent gets direct 10,839 3.46 0.01
consistent gets from cache 88,765,568 28,303.39 43.91
current blocks converted for CR 1 0.00 0.00
cursor authentications 1,173 0.37 0.00
data blocks consistent reads - undo records applied 25,219 8.04 0.01
db block changes 13,505,199 4,306.21 6.68
db block gets 10,186,863 3,248.14 5.04
db block gets direct 174 0.06 0.00
db block gets from cache 10,186,689 3,248.08 5.04
deferred (CURRENT) block cleanout applications 704,282 224.56 0.35
dirty buffers inspected 285 0.09 0.00
enqueue conversions 735 0.23 0.00
enqueue deadlocks 0 0.00 0.00
enqueue releases 3,870,804 1,234.23 1.91
enqueue requests 3,870,766 1,234.21 1.91
enqueue timeouts 5 0.00 0.00
enqueue waits 1,095 0.35 0.00
exchange deadlocks 105 0.03 0.00
execute count 4,396,440 1,401.83 2.17
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 984,886 314.04 0.49
free buffer requested 1,055,519 336.56 0.52
gc CPU used by this session 30,343 9.68 0.02
gc blocks lost 0 0.00 0.00
gc cr block build time 6,289 2.01 0.00
gc cr block flush time 10,984 3.50 0.01
gc cr block receive time 74,251 23.68 0.04
gc cr block send time 6,415 2.05 0.00
gc cr blocks received 467,340 149.01 0.23
gc cr blocks served 463,233 147.70 0.23
gc current block flush time 174 0.06 0.00
gc current block pin time 17,520 5.59 0.01
gc current block receive time 91,688 29.24 0.05
gc current block send time 140,298 44.73 0.07
gc current blocks received 457,840 145.98 0.23
gc current blocks served 918,610 292.90 0.45
gc local grants 94,417 30.11 0.05
gc remote grants 29,604 9.44 0.01
gcs messages sent 2,985,410 951.91 1.48
ges messages sent 13,827 4.41 0.01
global enqueue get time 16,020 5.11 0.01
global enqueue gets async 8,086 2.58 0.00
global enqueue gets sync 1,945,199 620.24 0.96
global enqueue releases 1,943,962 619.84 0.96
global undo segment hints helped 0 0.00 0.00
heap block compress 189,949 60.57 0.09
hot buffers moved to head of LRU 334,161 106.55 0.17
immediate (CR) block cleanout applications 3,749 1.20 0.00
immediate (CURRENT) block cleanout applications 7,285 2.32 0.00
index crx upgrade (found) 3 0.00 0.00
index crx upgrade (positioned) 3,858 1.23 0.00
index fast full scans (full) 31 0.01 0.00
index fetch by key 4,092,389 1,304.88 2.02
index scans kdiixs1 332,031 105.87 0.16
leaf node 90-10 splits 62 0.02 0.00
leaf node splits 231 0.07 0.00
lob reads 4,668 1.49 0.00
lob writes 213 0.07 0.00
lob writes unaligned 213 0.07 0.00
logons cumulative 319 0.10 0.00
messages received 2,191,718 698.84 1.08
messages sent 2,191,718 698.84 1.08
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 73,589,675 23,464.47 36.40
opened cursors cumulative 4,389,810 1,399.72 2.17
parse count (failures) 3 0.00 0.00
parse count (hard) 2,198 0.70 0.00
parse count (total) 4,384,932 1,398.16 2.17
parse time cpu 2,262 0.72 0.00
parse time elapsed 283,932 90.53 0.14
physical read IO requests 34,075 10.87 0.02
physical read bytes 322,895,872 102,957.12 159.74
physical read total IO requests 83,457 26.61 0.04
physical read total bytes 22,792,390,144 7,267,478.67 11,275.37
physical read total multi block requests 42,021 13.40 0.02
physical reads 39,416 12.57 0.02
physical reads cache 28,323 9.03 0.01
physical reads cache prefetch 4,481 1.43 0.00
physical reads direct 11,093 3.54 0.01
physical reads direct (lob) 10,835 3.45 0.01
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 161,534 51.51 0.08
physical write bytes 2,090,835,968 666,674.52 1,034.33
physical write total IO requests 1,540,078 491.06 0.76
physical write total bytes 6,493,104,128 2,070,361.88 3,212.13
physical write total multi block requests 1,316,098 419.65 0.65
physical writes 255,229 81.38 0.13
physical writes direct 308 0.10 0.00
physical writes direct (lob) 27 0.01 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 254,921 81.28 0.13
physical writes non checkpoint 233,344 74.40 0.12
pinned buffers inspected 185 0.06 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 94 0.03 0.00
process last non-idle time 1,903 0.61 0.00
queries parallelized 9 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive calls 2,359,948 752.48 1.17
recursive cpu usage 3,500 1.12 0.00
redo blocks written 4,342,867 1,384.75 2.15
redo buffer allocation retries 305 0.10 0.00
redo entries 6,968,846 2,222.05 3.45
redo log space requests 355 0.11 0.00
redo log space wait time 242 0.08 0.00
redo ordering marks 62,942 20.07 0.03
redo size 1,878,655,328 599,019.56 929.37
redo subscn max counts 1,166 0.37 0.00
redo synch time 214,061 68.25 0.11
redo synch writes 1,919,470 612.03 0.95
redo wastage 273,520,300 87,213.45 135.31
redo write time 45,543 14.52 0.02
redo writer latching time 348 0.11 0.00
redo writes 1,348,588 430.00 0.67
rollback changes - undo records applied 113 0.04 0.00
rollbacks only - consistent read gets 10,251 3.27 0.01
rows fetched via callback 254,412 81.12 0.13
session connect time 0 0.00 0.00
session cursor cache hits 1,233,454 393.29 0.61
session logical reads 98,963,281 31,554.99 48.96
session uga memory 8,084,680 2,577.84 4.00
session uga memory max 122,739,984 39,136.32 60.72
shared hash latch upgrades - no wait 1,858,668 592.65 0.92
shared hash latch upgrades - wait 375 0.12 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 17,711 5.65 0.01
sorts (rows) 1,017,885 324.56 0.50
sql area evicted 112 0.04 0.00
sql area purged 50 0.02 0.00
summed dirty queue length 2,917 0.93 0.00
switch current to new buffer 4,933 1.57 0.00
table fetch by rowid 8,425,339 2,686.47 4.17
table fetch continued row 14,815 4.72 0.01
table scan blocks gotten 65,468,143 20,874.88 32.39
table scan rows gotten 5,525,300,396 1,761,772.35 2,733.36
table scans (long tables) 26 0.01 0.00
table scans (short tables) 397,703 126.81 0.20
total number of times SMON posted 59 0.02 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 69 0.02 0.00
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 647,718,112 206,528.47 320.43
user I/O wait time 16,937 5.40 0.01
user calls 9,542,222 3,042.59 4.72
user commits 1,919,339 611.99 0.95
user rollbacks 102,092 32.55 0.05
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 13,653 4.35 0.01
write clones created in background 0 0.00 0.00
write clones created in foreground 9 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 113,605,501 113,607,685
opened cursors current 1,247 1,271
logons current 330 325

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 4 4.59

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)
PERFORMANCE 17,749 6 3.69 1.12 158,279 50 10,725 16.93
SYSAUX 14,618 5 7.86 1.20 6,129 2 0 0.00
STATDATA 2,424 1 6.14 1.07 3,345 1 2,010 7.14
UNDOTBS1 2 0 175.00 1.00 5,671 2 287 0.77
SYSTEM 1,763 1 11.59 1.19 471 0 19 29.47
MWS_SYS 58 0 13.10 1.00 28 0 7 1.43
SYSTEMDATA 40 0 96.75 1.00 20 0 0 0.00
MWS_RTM 11 0 7.27 1.00 39 0 0 0.00
RESOURCEDATA 21 0 153.33 1.00 20 0 0 0.00
USERS 4 0 170.00 1.00 4 0 0 0.00
MWS_APP 2 0 0.00 1.00 2 0 0 0.00
MWS_FILE 2 0 0.00 1.00 2 0 0 0.00
RECALCULATEDATA 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 2 0 170.00 1.00 2 0 94 3.30

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
MWS_APP /dev/rlv_MWS_APP_3g 2 0 0.00 1.00 2 0 0 0.00
MWS_FILE /dev/rlv_MWS_FILE_5g 2 0 0.00 1.00 2 0 0 0.00
MWS_RTM /dev/rlv_MWS_SYS_3g 5 0 2.00 1.00 23 0 0 0.00
MWS_RTM /dev/rsm_d10g_10 4 0 17.50 1.00 14 0 0 0.00
MWS_RTM /dev/rsm_d10g_2 2 0 0.00 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d1g_11 8 0 10.00 1.00 2 0 2 0.00
MWS_SYS /dev/rims_d1g_12 17 0 21.18 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d1g_13 7 0 10.00 1.00 14 0 1 10.00
MWS_SYS /dev/rims_d1g_14 6 0 6.67 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d1g_15 6 0 3.33 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d5g_3 2 0 5.00 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d5g_4 6 0 16.67 1.00 2 0 0 0.00
MWS_SYS /dev/rims_d5g_5 6 0 13.33 1.00 2 0 4 0.00
PERFORMANCE /dev/rims_d10g_4 1,524 0 5.64 1.10 21,770 7 1,059 14.25
PERFORMANCE /dev/rims_d10g_5 1,391 0 5.26 1.14 20,441 7 946 15.07
PERFORMANCE /dev/rims_d20g_10 1,590 1 3.08 1.22 14,412 5 488 18.38
PERFORMANCE /dev/rims_d20g_11 1,835 1 2.08 1.11 7,809 2 603 13.75
PERFORMANCE /dev/rims_d20g_12 1,462 0 2.36 1.19 1,765 1 244 19.18
PERFORMANCE /dev/rims_d20g_13 1,172 0 3.22 1.17 9,304 3 681 12.60
PERFORMANCE /dev/rims_d20g_14 2,545 1 3.76 1.03 21,815 7 1,894 27.76
PERFORMANCE /dev/rims_d20g_15 1,676 1 4.68 1.10 23,940 8 2,277 12.58
PERFORMANCE /dev/rims_d20g_7 1,014 0 4.19 1.15 11,620 4 550 14.40
PERFORMANCE /dev/rims_d20g_8 1,561 0 2.43 1.07 7,025 2 347 13.23
PERFORMANCE /dev/rims_d20g_9 1,979 1 4.11 1.11 18,378 6 1,636 17.10
RECALCULATEDATA /dev/rsm_d20g_1 2 0 0.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d10g_1 3 0 103.33 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d10g_2 2 0 155.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d10g_3 2 0 155.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_1 2 0 170.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_16 2 0 150.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_2 2 0 170.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_3 2 0 170.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_4 2 0 165.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_5 2 0 160.00 1.00 2 0 0 0.00
RESOURCEDATA /dev/rims_d20g_6 2 0 160.00 1.00 2 0 0 0.00
STATDATA /dev/rims_d10g_10 326 0 5.92 1.01 421 0 687 7.35
STATDATA /dev/rims_d1g_10 6 0 48.33 1.00 2 0 0 0.00
STATDATA /dev/rims_d1g_6 4 0 77.50 1.00 2 0 0 0.00
STATDATA /dev/rims_d1g_7 6 0 53.33 1.00 2 0 0 0.00
STATDATA /dev/rims_d1g_8 6 0 51.67 1.00 2 0 0 0.00
STATDATA /dev/rims_d1g_9 6 0 48.33 1.00 2 0 0 0.00
STATDATA /dev/rims_d5g_2 56 0 17.14 1.00 254 0 63 9.05
STATDATA /dev/rims_idx 176 0 6.42 1.10 431 0 242 6.86
STATDATA /dev/rimsda_d20g_1 177 0 6.55 1.08 289 0 87 9.31
STATDATA /dev/rimsda_d20g_2 315 0 3.75 1.01 214 0 85 5.76
STATDATA /dev/rimsda_d20g_3 199 0 5.83 1.02 214 0 208 3.27
STATDATA /dev/rimsda_d20g_4 390 0 3.05 1.03 240 0 111 3.87
STATDATA /dev/rsm_d10g_3 190 0 6.63 1.24 415 0 144 6.67
STATDATA /dev/rsm_d10g_8 212 0 8.44 1.23 291 0 159 11.95
STATDATA /dev/rsm_d10g_9 269 0 3.12 1.10 266 0 77 3.77
STATDATA /dev/rsm_d20g_2 86 0 8.95 1.00 300 0 147 10.27
SYSAUX /dev/rimsh_sysaux01 14,618 5 7.86 1.20 6,129 2 0 0.00
SYSTEM /dev/rimsh_system 1,763 1 11.59 1.19 471 0 19 29.47
SYSTEMDATA /dev/rims_d10g_6 4 0 105.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d10g_7 4 0 100.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d10g_8 4 0 100.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d10g_9 4 0 100.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d1g_1 4 0 97.50 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d1g_2 4 0 95.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d1g_3 4 0 92.50 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d1g_4 4 0 92.50 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d1g_5 4 0 85.00 1.00 2 0 0 0.00
SYSTEMDATA /dev/rims_d5g_1 4 0 100.00 1.00 2 0 0 0.00
UNDOTBS1 /dev/rimsh_undo01 2 0 175.00 1.00 5,671 2 287 0.77
UNDOTBS2 /dev/rimsh_undo02 2 0 170.00 1.00 2 0 94 3.30
USERS /dev/rims_users02 2 0 170.00 1.00 2 0 0 0.00
USERS /dev/rimsh_users 2 0 170.00 1.00 2 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 523,862 100 99,364,204 28,721 254,925 0 0 12,126


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 3 5799 26175 698043 1887390 698043  
E 0 36 45840 331930 1887390 1887390 4252197  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 432 0.10 51,813 3.18 1,525,339,585
D 864 0.20 103,626 2.92 1,400,827,256
D 1,296 0.30 155,439 2.66 1,273,858,376
D 1,728 0.40 207,252 2.39 1,145,522,892
D 2,160 0.49 259,065 2.13 1,019,895,538
D 2,592 0.59 310,878 1.88 898,871,404
D 3,024 0.69 362,691 1.63 783,186,207
D 3,456 0.79 414,504 1.41 673,953,495
D 3,888 0.89 466,317 1.20 574,126,912
D 4,320 0.99 518,130 1.02 487,558,698
D 4,368 1.00 523,887 1.00 479,151,783
D 4,752 1.09 569,943 0.87 415,936,202
D 5,184 1.19 621,756 0.75 358,395,279
D 5,616 1.29 673,569 0.65 313,315,814
D 6,048 1.38 725,382 0.58 278,902,894
D 6,480 1.48 777,195 0.53 253,410,480
D 6,912 1.58 829,008 0.49 234,531,900
D 7,344 1.68 880,821 0.46 219,992,513
D 7,776 1.78 932,634 0.43 208,022,255
D 8,208 1.88 984,447 0.41 197,210,739
D 8,640 1.98 1,036,260 0.39 186,761,950

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 1,035 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 4,086 3,287 937.33 1.34 0.14 100.00 0.00 418,400
E 4,086 3,323 855.21 0.00 0.00 0.00 0.00 418,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 12,586 12,586 0 0
64K 128K 30 30 0 0
128K 256K 22 22 0 0
256K 512K 2 2 0 0
512K 1024K 806 806 0 0
1M 2M 238 238 0 0
2M 4M 8 8 0 0
8M 16M 2 2 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
511 0.13 4,022,471.46 24,604.96 99.00 45
1,022 0.25 4,022,471.46 17,718.22 100.00 1
2,043 0.50 4,022,471.46 17,718.22 100.00 0
3,065 0.75 4,022,471.46 17,718.22 100.00 0
4,086 1.00 4,022,471.46 14,609.35 100.00 0
4,903 1.20 4,022,471.46 670.94 100.00 0
5,720 1.40 4,022,471.46 670.94 100.00 0
6,538 1.60 4,022,471.46 670.94 100.00 0
7,355 1.80 4,022,471.46 670.94 100.00 0
8,172 2.00 4,022,471.46 670.94 100.00 0
12,258 3.00 4,022,471.46 670.94 100.00 0
16,344 4.00 4,022,471.46 670.94 100.00 0
24,516 6.00 4,022,471.46 670.94 100.00 0
32,688 8.00 4,022,471.46 670.94 100.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
2,288 0.39 659 46,604 130,510,917 0.97 5,818,585 4.63 3,162,653,310
2,880 0.49 1,200 68,736 131,782,662 0.98 4,546,840 3.62 3,176,407,926
3,472 0.59 1,790 91,886 132,879,590 0.98 3,449,912 2.74 3,188,673,478
4,064 0.70 2,381 116,598 133,705,652 0.99 2,623,850 2.09 3,198,009,736
4,656 0.80 2,973 145,078 134,312,906 0.99 2,016,596 1.60 3,204,785,951
5,248 0.90 3,564 176,296 134,754,152 1.00 1,575,350 1.25 3,209,605,490
5,840 1.00 4,153 208,005 135,072,373 1.00 1,257,129 1.00 3,212,987,575
6,432 1.10 4,745 241,234 135,300,490 1.00 1,029,012 0.82 3,215,347,538
7,024 1.20 5,336 282,026 135,464,594 1.00 864,908 0.69 3,216,999,928
7,616 1.30 5,927 315,369 135,583,447 1.00 746,055 0.59 3,218,171,896
8,208 1.41 6,518 350,598 135,670,686 1.00 658,816 0.52 3,219,021,845
8,800 1.51 7,109 380,492 135,736,175 1.00 593,327 0.47 3,219,658,230
9,392 1.61 7,700 408,110 135,786,784 1.01 542,718 0.43 3,220,153,470
9,984 1.71 8,290 435,446 135,827,190 1.01 502,312 0.40 3,220,555,866
10,576 1.81 8,881 464,621 135,860,507 1.01 468,995 0.37 3,220,897,098
11,168 1.91 9,472 491,276 135,888,858 1.01 440,644 0.35 3,221,198,259
11,760 2.01 10,063 520,280 135,913,828 1.01 415,674 0.33 3,221,473,533

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.50 12,073,341 813,072,002
7,680 0.75 10,897,467 813,072,002
10,240 1.00 10,314,687 479,151,395
12,800 1.25 9,869,093 221,703,350
15,360 1.50 9,676,208 221,703,350
17,920 1.75 9,594,722 148,680,678
20,480 2.00 9,593,691 99,567,660

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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 11,839 188 16
1st level bmb 87 0 5
undo header 181 0 2
2nd level bmb 54 0 2
segment header 29 0 3
undo block 190 0 0

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 48 48 0 16 96 5,969.75
TX-Transaction (allocate ITL entry) 6 6 0 6 7 1,193.50
TM-DML 1,939,363 1,935,181 3,947 4,556 6 1.31
TX-Transaction (row lock contention) 104 103 0 88 6 65.94
TX-Transaction (index contention) 83 83 0 78 5 61.29
TX-Transaction 1,932,288 1,931,864 0 8 1 100.88
HW-Segment High Water Mark 418 418 0 43 1 15.91
TS-Temporary Segment 94 94 0 94 0 3.10
TA-Instance Undo 8 8 0 8 0 27.75
FB-Format Block 112 112 0 70 0 3.07
RO-Multiple Object Reuse (fast object reuse) 477 477 0 156 0 1.35
CF-Controlfile Transaction 5,252 5,252 0 70 0 1.21
WL-Being Written Redo Log 4 4 0 2 0 41.50
PS-PX Process Reservation 120 116 4 66 0 1.03
AF-Advisor Framework (task serialization) 56 56 0 24 0 2.17
DR-Distributed Recovery 2 2 0 1 0 50.00
RS-Reclaimable Space (prevent file delete) 74 74 0 37 0 1.00
TT-Tablespace 443 443 0 29 0 0.28
JS-Job Scheduler (job run lock - synchronize) 1 1 0 1 0 6.00
US-Undo Segment 26 26 0 3 0 0.67
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 0 1 1 0 1.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
1 87.53 2,051,048 366 32 2458.55/2489.23333333333333333333333333333333333 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
25-Mar 00:01 11,572 304,530 57 27 2,460 0/0 0/0/0/0/0/0
24-Mar 23:51 28,342 811,054 66 5 2,459 0/0 0/0/0/0/0/0
24-Mar 23:41 39,297 744,247 264 13 2,470 0/0 0/0/0/0/0/0
24-Mar 23:31 4,857 97,132 285 9 2,489 0/0 0/0/0/0/0/0
24-Mar 23:21 2,443 66,216 366 31 2,484 0/0 0/0/0/0/0/0
24-Mar 23:11 1,015 27,869 141 32 2,477 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 db client latch 2,346 0.00   0 0  
AWR Alerted Metric Element list 20,891 0.00   0 0  
Consistent RBA 1,355,745 0.01 0.09 0 0  
FAL request queue 47 0.00   0 0  
FAL subheap alocation 47 0.00   0 0  
FIB s.o chain latch 274 0.00   0 0  
FOB s.o list latch 1,139 0.00   0 0  
JS broadcast add buf latch 453 0.00   0 0  
JS broadcast drop buf latch 453 0.00   0 0  
JS broadcast load blnc latch 394 0.00   0 0  
JS mem alloc latch 10 0.00   0 0  
JS queue access latch 10 0.00   0 0  
JS queue state obj latch 14,272 0.00   0 0  
JS slv state obj latch 4 0.00   0 0  
KCL gc element parent latch 6,084,413 0.03 0.40 4 37,958 0.06
KJC message pool free list 1,556,228 0.06 0.02 0 60,736 0.11
KJCT flow control latch 5,224,154 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 665 0.00   0 0  
KSXR large replies 134 0.00   0 0  
KTF sga latch 8 0.00   0 643 0.00
KWQMN job cache list latch 141 0.00   0 0  
MQL Tracking Latch 0     0 40 0.00
Memory Management Latch 0     0 665 0.00
OS process 876 0.00   0 0  
OS process allocation 1,255 0.00   0 0  
OS process: request allocation 564 0.00   0 0  
PL/SQL warning settings 479 0.00   0 0  
SGA IO buffer pool latch 1,192 0.08 1.00 0 1,192 0.25
SQL memory manager latch 1 0.00   0 661 0.00
SQL memory manager workarea list latch 63,414 0.00 0.00 0 0  
Shared B-Tree 70 0.00   0 0  
X$KSFQP 17 0.00   0 0  
active checkpoint queue latch 188,672 0.23 0.00 0 0  
active service list 5,789 0.05 0.00 0 783 0.00
archive control 66 0.00   0 0  
archive process latch 764 0.00   0 0  
begin backup scn array 34 0.00   0 0  
business card 26 0.00   0 0  
cache buffer handles 2,482 0.08 0.00 0 0  
cache buffers chains 217,761,728 1.26 0.00 75 1,601,592 0.02
cache buffers lru chain 1,544,832 0.07 0.04 0 1,435,711 0.06
cache table scan latch 0     0 387 0.00
channel handle pool latch 622 0.00   0 0  
channel operations parent latch 391,577 0.00   0 0  
checkpoint queue latch 3,165,801 0.01 0.02 0 686,909 0.00
client/application info 2,481 0.00   0 0  
commit callback allocation 92 0.00   0 0  
compile environment latch 332 0.00   0 0  
dictionary lookup 98 0.00   0 0  
dml lock allocation 3,869,505 0.50 0.00 0 0  
dummy allocation 662 0.00   0 0  
enqueue hash chains 11,671,278 0.05 0.00 0 5,692 0.04
enqueues 2,187,780 0.23 0.00 0 0  
error message lists 55 0.00   0 0  
event group latch 283 0.00   0 0  
file cache latch 1,229 0.00   0 0  
gcs opaque info freelist 1,163,563 0.08 0.00 0 0  
gcs partitioned table hash 8,105,569 0.00   0 0  
gcs remaster request queue 159 0.00   0 0  
gcs remastering latch 1,242,380 0.00   0 0  
gcs resource freelist 95,004 0.00   0 38,402 0.00
gcs resource hash 5,376,387 0.02 0.16 5 829 0.00
gcs resource scan list 1,658 0.00   0 0  
gcs shadows freelist 313,139 0.00 0.83 0 412,269 0.00
ges caches resource lists 279,347 0.18 0.63 8 37,869 0.12
ges deadlock list 2,156 0.00   0 4 0.00
ges domain table 3,905,431 0.00 0.02 0 0  
ges enqueue table freelist 3,918,023 0.01 0.00 0 0  
ges group table 5,845,553 0.01 0.00 0 0  
ges process hash list 4,682 0.00   0 0  
ges process parent latch 7,853,252 0.00 0.18 0 0  
ges process table freelist 564 0.00   0 0  
ges resource hash list 3,981,619 0.16 0.05 4 15,037 0.03
ges resource scan list 1,214 0.00   0 0  
ges resource table freelist 15,433 0.06 0.89 0 0  
ges timeout list 5,872 0.00   0 7,446 0.00
global KZLD latch for mem in SGA 277 0.00   0 0  
hash table column usage latch 541 0.00   0 181,830 0.00
hash table modification latch 137 0.00   0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes parameter latch 34 0.00   0 0  
kks stats 5,164 0.14 1.00 0 0  
kokc descriptor allocation latch 274 0.00   0 0  
krbmrosl 121 0.00   0 0  
ksuosstats global area 136 0.00   0 0  
ktm global data 75 0.00   0 0  
kwqbsn:qsga 70 0.00   0 0  
lgwr LWN SCN 1,361,854 0.13 0.00 0 0  
library cache 8,841,783 0.42 0.65 1502 286 16.08
library cache load lock 2,038 0.00   0 0  
library cache lock 12,755,094 0.05 0.01 2 0  
library cache lock allocation 1,849 0.05 0.00 0 0  
library cache pin 53,006 0.02 0.00 0 8 0.00
library cache pin allocation 612 0.00   0 0  
list of block allocation 1,330 0.00   0 0  
loader state object freelist 5,700 0.00   0 0  
longop free list parent 648 0.00   0 8 0.00
message pool operations parent latch 893 0.00   0 0  
messages 5,554,384 0.16 0.01 0 0  
mostly latch-free SCN 1,389,868 1.79 0.04 1 0  
multiblock read objects 2,949 0.00   0 0  
name-service memory objects 24,689 0.00   0 0  
name-service namespace bucket 26,557 0.00   0 0  
name-service pending queue 12,416 0.00   0 0  
name-service request 10 0.00   0 0  
name-service request queue 37,139 0.00   0 0  
ncodef allocation latch 36 0.00   0 0  
object queue header heap 4,888 0.00   0 4,616 0.00
object queue header operation 3,504,746 0.02 0.06 0 0  
object stats modification 103 0.00   0 0  
parallel query alloc buffer 769 0.00   0 0  
parallel query stats 85 0.00   0 0  
parallel txn reco latch 714 0.00   0 0  
parameter list 2,758 0.00   0 0  
parameter table allocation management 338 1.18 0.75 0 0  
post/wait queue 3,807,613 0.19 0.00 0 1,948,575 0.13
process allocation 14,658 0.01 0.00 0 283 0.00
process group creation 567 0.00   0 0  
process queue 231 0.00   0 0  
process queue reference 4,198 0.00   0 410 0.24
qmn task queue latch 280 0.36 0.00 0 0  
query server freelists 182 0.00   0 0  
query server process 1 0.00   0 2 0.00
queued dump request 10,006 0.00   0 0  
redo allocation 4,117,000 0.20 0.03 8 6,978,758 0.67
redo copy 0     0 6,995,062 0.58
redo writing 4,282,474 0.02 0.07 0 0  
resmgr group change latch 617 0.00   0 0  
resmgr:active threads 657 0.00   0 0  
resmgr:actses change group 325 0.00   0 0  
resmgr:free threads list 656 0.15 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 775,083 0.27 0.12 8 67 8.96
sequence cache 8,934 0.04 0.00 0 0  
session allocation 4,620,142 0.31 0.01 0 0  
session idle bit 21,387,459 0.01 0.02 0 0  
session state list latch 675 0.30 0.00 0 0  
session switching 37 0.00   0 0  
session timer 776 0.00   0 0  
shared pool 218,146 0.67 1.16 112 0  
shared pool simulator 1,930,089 0.02 1.22 79 0  
simulator hash latch 6,071,085 0.00 0.02 0 0  
simulator lru latch 0     0 6,056,989 3.04
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 123 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 159 0.00   0 0  
transaction allocation 184 0.00   0 0  
transaction branch allocation 778 0.00   0 0  
undo global data 5,839,326 0.01 0.00 0 0  
user lock 1,112 0.45 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 217,761,728 2,749,361 6,631 2,743,023 0 0 0
library cache 8,841,783 37,392 24,481 15,102 0 0 0
mostly latch-free SCN 1,389,868 24,851 975 23,887 0 0 0
dml lock allocation 3,869,505 19,173 54 19,119 0 0 0
session allocation 4,620,142 14,270 79 14,191 0 0 0
messages 5,554,384 9,089 116 8,973 0 0 0
redo allocation 4,117,000 8,065 255 7,823 0 0 0
post/wait queue 3,807,613 7,223 6 7,217 0 0 0
library cache lock 12,755,094 6,841 55 6,786 0 0 0
ges resource hash list 3,981,619 6,424 295 6,131 0 0 0
enqueue hash chains 11,671,278 5,734 22 5,712 0 0 0
enqueues 2,187,780 5,008 4 5,004 0 0 0
session idle bit 21,387,459 2,313 36 2,277 0 0 0
row cache objects 775,083 2,080 246 1,870 0 0 0
lgwr LWN SCN 1,361,854 1,838 3 1,835 0 0 0
KCL gc element parent latch 6,084,413 1,628 651 987 0 0 0
shared pool 218,146 1,453 1,689 171 0 0 0
gcs resource hash 5,376,387 1,272 198 1,074 0 0 0
cache buffers lru chain 1,544,832 1,111 39 1,073 0 0 0
gcs opaque info freelist 1,163,563 913 3 910 0 0 0
KJC message pool free list 1,556,228 909 15 894 0 0 0
object queue header operation 3,504,746 727 40 687 0 0 0
redo writing 4,282,474 658 45 613 0 0 0
ges group table 5,845,553 633 3 630 0 0 0
KJCT flow control latch 5,224,154 552 1 551 0 0 0
ges caches resource lists 279,347 499 315 201 0 0 0
active checkpoint queue latch 188,672 442 2 440 0 0 0
shared pool simulator 1,930,089 383 469 146 0 0 0
checkpoint queue latch 3,165,801 307 7 300 0 0 0
simulator hash latch 6,071,085 292 5 287 0 0 0
Consistent RBA 1,355,745 143 13 130 0 0 0
ges domain table 3,905,431 54 1 53 0 0 0
ges process parent latch 7,853,252 11 2 9 0 0 0
ges resource table freelist 15,433 9 8 1 0 0 0
kks stats 5,164 7 7 0 0 0 0
gcs shadows freelist 313,139 6 5 1 0 0 0
parameter table allocation management 338 4 3 1 0 0 0
SGA IO buffer pool latch 1,192 1 1 0 0 0 0
slave class create 12 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclrwrite 0 476 111
KCL gc element parent latch kclnfndnewm 0 102 78
KCL gc element parent latch kclbla 0 86 14
KCL gc element parent latch kclchkping 0 34 0
KCL gc element parent latch kclfwrite1 0 20 94
KCL gc element parent latch kclnfnd 0 11 29
KCL gc element parent latch kclulb 0 3 28
KCL gc element parent latch kclwrt 0 3 183
KCL gc element parent latch KCLUNLNK 0 2 37
KCL gc element parent latch kcllwr 0 2 12
KCL gc element parent latch kclebs 0 1 4
KCL gc element parent latch kclplz 0 1 63
KCL gc element parent latch kclrwrite_1 0 1 1
KJC message pool free list kjcsmpav: allocate a msg buffer 0 15 15
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 1 0
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 2 2
cache buffers chains kcbgtcr: kslbegin excl 0 5,825 5,817
cache buffers chains kcbgtcr: fast path 0 1,374 158
cache buffers chains kcbrls: kslbegin 0 892 2,181
cache buffers chains kcbzwb 0 468 70
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 352 304
cache buffers chains kcbgcur: kslbegin 0 221 155
cache buffers chains kcbbic1 0 37 0
cache buffers chains kcbbxsv 0 31 81
cache buffers chains kclbla 0 26 6
cache buffers chains kcbgtcr: kslbegin shared 0 20 16
cache buffers chains kclebs_1 0 20 1
cache buffers chains kcbzgb: scan from tail. nowait 0 18 0
cache buffers chains kclwrt 0 18 8
cache buffers chains kclcls_3 0 15 0
cache buffers chains kcbget: pin buffer 0 10 10
cache buffers chains kcbchg: kslbegin: call CR func 0 8 224
cache buffers chains kcbnlc 0 7 166
cache buffers chains kclexpand 0 4 19
cache buffers chains kcbnew: new latch again 0 3 1
cache buffers chains kcbzib: finish free bufs 0 3 11
cache buffers chains kcbgcur: buf pinned 0 2 2
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcllwr 0 1 0
cache buffers chains kclpto 0 1 0
cache buffers chains kclwcrs 0 1 2
cache buffers lru chain kcbbxsv: move to being written 0 9 4
cache buffers lru chain kcbzgb: posted for free bufs 0 8 8
cache buffers lru chain kcbzgws 0 8 0
cache buffers lru chain kclmvreqbg 0 5 18
cache buffers lru chain kcbbic2 0 3 6
cache buffers lru chain kclwcrs 0 2 0
cache buffers lru chain H_MK_PI_CR_BG 0 1 0
cache buffers lru chain kcbo_link_q 0 1 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 3 0
checkpoint queue latch kcbkubc 0 3 5
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 2
dml lock allocation ktaiam 0 27 35
dml lock allocation ktaidm 0 27 19
enqueue hash chains ksqcmi: if lk mode requested 0 10 0
enqueue hash chains ksqcmi: if lk mode not requested 0 8 0
enqueue hash chains ksqgtl3 0 1 16
enqueue hash chains ksqrcl 0 1 4
enqueues ksqies 0 4 4
gcs opaque info freelist kjbrcvt save opaque info 0 2 2
gcs opaque info freelist kjbrgrant free opaque info 0 1 1
gcs resource hash kjbcropen 0 53 40
gcs resource hash kjbmpclose 0 33 11
gcs resource hash kclgrantlk_1 0 27 3
gcs resource hash kjblocalfile_nolock 0 19 29
gcs resource hash kclrwrite 0 15 7
gcs resource hash kjbmpopen 0 9 11
gcs resource hash kclpdc 0 7 1
gcs resource hash kjbopen 0 7 3
gcs resource hash kclfwrite1 0 6 1
gcs resource hash kclzcl 0 5 8
gcs resource hash kjbconvert 0 4 8
gcs resource hash kjbassume 0 2 6
gcs resource hash kjbcrcomplete 0 2 7
gcs resource hash kjbrwrdone reget 0 2 1
gcs resource hash kjbcrconvert 0 1 17
gcs resource hash kjbcropen:affinity 0 1 14
gcs resource hash kjblpbast 0 1 12
gcs shadows freelist kjblalc add lock 0 4 0
gcs shadows freelist kjblfr free lock 0 1 5
ges domain table kjdmlad: add a lock to an xid-hashed lock list 0 1 1
ges group table kjgdgll: move a lock from group lock list to process lock list 0 2 1
ges group table kjgagll: move a lock from process lock list to group lock list 0 1 2
ges process parent latch kjlini_client: attach client lock to process 0 1 0
ges process parent latch kjlrem: detach lock from group 0 1 0
ges resource hash list kjucvl: lock convert request 0 126 29
ges resource hash list kjrref: find matched resource 0 73 195
ges resource hash list kjrmas1: lookup master node 0 28 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 7 2
ges resource hash list kjakcai: search for resp by resname 0 3 1
ges resource hash list kjlrlr: remove lock from resource queue 0 3 14
ges resource hash list kjcvscn: remove from scan queue 0 1 0
ges resource table freelist kjrm2c: move resource to cache 0 123 303
ges resource table freelist kjrchc: cached obj cleanup 0 108 0
ges resource table freelist kjruch: cached obj cleanup 0 71 0
ges resource table freelist kjralc: resource allocation 0 8 0
ges resource table freelist kjchc: clean resource cache 0 1 0
kks stats kks stats alloc/free 0 7 7
lgwr LWN SCN kcs023 0 56 0
library cache kglLockCursor 0 10,191 410
library cache kgldte: child 0 0 4,998 6,376
library cache kglhdgn: child: 0 2,752 15,132
library cache kqlmbinv: parent 0 864 311
library cache kglpndl: child: before processing 0 716 68
library cache kglobpn: child: 0 677 187
library cache kglpndl: child: after processing 0 456 1
library cache kgldti: 2child 0 383 36
library cache kqlmbpil: parent 0 327 30
library cache kglpin 0 142 45
library cache kglic 0 101 2
library cache kglhdgc: child: 0 86 2
library cache kgldtld: 2child 0 62 5
library cache kglati 0 50 2
library cache kglrtl 0 41 2
library cache kglukp: child 0 36 35
library cache kglobld 0 26 26
library cache kglini: child 0 14 0
library cache kglget: unpin heap 0 0 4 3
library cache kglivl: child 0 4 1
library cache kglhdiv: child 0 3 0
library cache kglivr: child 0 2 2
library cache kglpin: child: KGLMX 0 2 0
library cache kglScanDependency 0 1 0
library cache kglhdbrnl: child 0 1 0
library cache kglpnp: child 0 1 1
library cache kqlmbfre: child: in loop 0 1 0
library cache lock kgllkdl: child: no lock handle 0 2,180 1,444
library cache lock kgllkal: child: multiinstance 0 34 27
library cache lock kgllkdl: child: cleanup 0 21 28
messages ksaamb: after wakeup 0 70 107
messages ksarcv 0 34 7
messages ksarcv: after wait 0 12 2
mostly latch-free SCN kcslcu3 0 913 972
mostly latch-free SCN kcs01 0 11 13
mostly latch-free SCN kcs024 0 3 0
mostly latch-free SCN kcsnew_scn_rba 0 2 0
object queue header operation kcbo_switch_cq 0 12 15
object queue header operation kcbo_switch_mq_bg 0 11 16
object queue header operation kcbw_unlink_q 0 8 3
object queue header operation kcbo_switch_q_bg 0 6 5
object queue header operation kcbw_link_q 0 2 0
object queue header operation kcbw_unlink_q_bg 0 1 1
parameter table allocation management ksp_param_table_free 0 3 3
post/wait queue ksliwat:add:nowait 0 1 0
post/wait queue ksliwat:remove 0 1 3
post/wait queue kslpstevent:get 0 1 1
post/wait queue kslpstevent:reget 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 219 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 15 15
redo allocation kcrfw_redo_gen: redo allocation 2 0 5 0
redo allocation kcrfw_redo_write: before write 0 3 147
redo allocation kcrfw_redo_write: more space 0 2 82
redo writing kcrfwcr 0 19 41
redo writing kcrfw_post: rba scn pair 0 11 0
redo writing kcrfw_post: after write 0 8 0
redo writing kcrfw_cal_target_rba 0 7 0
row cache objects kqreqd: reget 0 81 0
row cache objects kqrigt 0 45 18
row cache objects kqrpre: find obj 0 37 145
row cache objects kqrso 0 30 7
row cache objects kqrbgl 0 24 20
row cache objects kqreqd 0 10 8
row cache objects kqrbtm: pop parent 0 9 10
row cache objects kqrbpr: KQRRSNRL 0 1 2
row cache objects kqrsrd 0 1 10
session allocation ksuxds: not user session 0 41 29
session allocation ksucri 0 32 48
session allocation ksuprc 0 3 0
session allocation ksudlc 0 1 0
session idle bit ksupuc: set busy 0 22 13
session idle bit ksuxds 0 13 6
session idle bit ksupuc: clear busy 0 10 26
shared pool kghalo 0 859 325
shared pool kghupr1 0 525 1,163
shared pool kghalp 0 169 114
shared pool kghfre 0 67 55
shared pool kghasp 0 33 6
shared pool kghfrh 0 18 2
shared pool kghfree_extents: scan 0 1 6
shared pool simulator kglsim_unpin_simhp 0 269 102
shared pool simulator kglsim_upd_newhp 0 118 1
shared pool simulator kglsim_unpin_simhp: fast path 0 80 365
shared pool simulator kglsim_chg_simhp_inval 0 1 0
simulator hash latch kcbsacc: lookup dba 0 5 5
slave class create ksvcreate 0 1 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
RESOURCEDBA RESOURCEDATA OBJECT   TABLE 62,142,448 62.79
RESOURCEDBA RESOURCEDATA COMPUTERSYSTEM   TABLE 4,821,136 4.87
PERFORMANCEDBA PERFORMANCE MESSAGEKEYWORD   TABLE 1,280,464 1.29
STATDBA STATDATA T_ONLINECOUNTREAL   TABLE 788,320 0.80
PERFORMANCEDBA PERFORMANCE PK_IPINTERFACEINTPR5MIN   INDEX 658,608 0.67

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYS SYSAUX WRH$_SQL_PLAN   TABLE 2,463 6.25
SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST   INDEX 1,922 4.88
SYS SYSAUX I_WRI$_OPTSTAT_H_ST   INDEX 1,815 4.60
SYS SYSAUX WRH$_SQLTEXT   TABLE 882 2.24
SYS SYSAUX WRI$_OPTSTAT_HISTHEAD_HISTORY   TABLE 501 1.27

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
PERFORMANCEDBA PERFORMANCE JBOSTATUS5MIN   TABLE 114 62.30
STATDBA STATDATA PK_TPROTALHOMESTATUS   INDEX 18 9.84
STATDBA STATDATA PK_TPROTALHOMERESTIME   INDEX 15 8.20
PERFORMANCEDBA PERFORMANCE CPULOAD5MIN   TABLE 6 3.28
PERFORMANCEDBA PERFORMANCE L2LINKINFLOW5MIN   TABLE 6 3.28

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
PERFORMANCEDBA PERFORMANCE INTERFACEOUTDROPPACKETRATE5MIN   TABLE 237 10.02
PERFORMANCEDBA PERFORMANCE INTERFACEOUTBWUSEDRATE5MIN   TABLE 188 7.95
PERFORMANCEDBA PERFORMANCE INTERFACEOUTERRORPACKETNUM5MIN   TABLE 182 7.70
PERFORMANCEDBA PERFORMANCE INTERFACEUNICASTFLOW5MIN   TABLE 146 6.17
PERFORMANCEDBA PERFORMANCE INTERFACEINERRORPACKETNUM5MIN   TABLE 136 5.75

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
PERFORMANCEDBA PERFORMANCE INTERFACEOUTDROPPACKETRATE5MIN   TABLE 853 10.24
PERFORMANCEDBA PERFORMANCE INTERFACEOUTBWUSEDRATE5MIN   TABLE 644 7.73
PERFORMANCEDBA PERFORMANCE INTERFACEOUTERRORPACKETNUM5MIN   TABLE 633 7.60
PERFORMANCEDBA PERFORMANCE INTERFACEUNICASTFLOW5MIN   TABLE 465 5.58
PERFORMANCEDBA PERFORMANCE INTERFACEINERRORPACKETNUM5MIN   TABLE 453 5.44

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
PERFORMANCEDBA PERFORMANCE IPINTERFACEINTOTOLPR5MIN   TABLE 24,975 5.34
PERFORMANCEDBA PERFORMANCE IPINTERFACEOUTTOTOLPR5MIN   TABLE 24,834 5.31
PERFORMANCEDBA PERFORMANCE IPINTERFACESTATUS5MIN   TABLE 24,313 5.20
PERFORMANCEDBA PERFORMANCE INTERFACEBWUSEDRATE5MIN   TABLE 24,296 5.20
PERFORMANCEDBA PERFORMANCE INTERFACEINFLOW5MIN   TABLE 24,282 5.20

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
PERFORMANCEDBA PERFORMANCE IPINTERFACEINTOTOLPR5MIN   TABLE 24,661 5.39
PERFORMANCEDBA PERFORMANCE IPINTERFACEOUTTOTOLPR5MIN   TABLE 24,561 5.36
PERFORMANCEDBA PERFORMANCE INTERFACEBWUSEDRATE5MIN   TABLE 24,444 5.34
PERFORMANCEDBA PERFORMANCE IPINTERFACESTATUS5MIN   TABLE 24,440 5.34
PERFORMANCEDBA PERFORMANCE INTERFACEINFLOW5MIN   TABLE 24,405 5.33

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 86 2.33 0   2 1
dc_database_links 555 0.00 0   0 1
dc_global_oids 197 1.52 0   0 28
dc_histogram_data 158,693 1.17 0   316 19,227
dc_histogram_defs 36,878 6.96 0   306 10,537
dc_object_ids 27,172 1.77 0   62 3,437
dc_objects 8,223 4.97 0   258 1,725
dc_profiles 277 0.00 0   0 1
dc_rollback_segments 3,013 0.00 0   0 104
dc_segments 14,444 2.17 0   269 3,818
dc_sequences 147 2.72 0   147 8
dc_tablespace_quotas 6 16.67 0   0 3
dc_tablespaces 29,303 0.00 0   0 15
dc_usernames 1,510 0.13 0   0 21
dc_users 78,928 0.00 0   0 62
outstanding_alerts 60 86.67 0   0 14

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 6 2 0
dc_global_oids 3 0 0
dc_histogram_defs 3,160 0 0
dc_object_ids 594 0 0
dc_objects 1,131 9 0
dc_segments 757 2 0
dc_sequences 294 4 0
dc_tablespace_quotas 12 1 0
dc_usernames 2 0 0
outstanding_alerts 120 39 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 18 11.11 719 0.83 4 0
CLUSTER 19 5.26 53 1.89 0 0
INDEX 88 14.77 337 10.98 24 0
SQL AREA 3,169,362 0.07 4,435,592 0.16 1,106 274
TABLE/PROCEDURE 3,375 3.64 26,539 3.36 354 0
TRIGGER 164 2.44 268 1.49 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY 2 1 0 1 0
CLUSTER 53 2 0 1 0
INDEX 337 173 36 119 0
TABLE/PROCEDURE 9,041 524 11 383 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 736.03   2.20 8.35 124 172 334 334
  Freeable 196.44 0.00 1.00 1.06 9   196 196
  SQL 2.97 1.34 0.01 0.02 0 409 309 255
  PL/SQL 1.42 0.74 0.00 0.01 0 0 332 330
E Other 659.75   2.01 7.91 124 172 328 328
  Freeable 191.25 0.00 1.01 1.11 9   189 189
  SQL 3.07 1.41 0.01 0.02 0 409 303 269
  PL/SQL 1.17 0.55 0.00 0.01 0 0 326 326

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 4,580,179,968  
Fixed Size 2,101,912  
Redo Buffers 14,671,872  
Variable Size 6,140,464,488  

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.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 701.93 708.84 0.99
shared Cursor Stats 66.48 66.48 0.00
shared PCursor 391.54 394.81 0.84
shared free memory 1,373.16 1,302.49 -5.15
shared gcs resources 199.91 199.91 0.00
shared gcs shadows 109.88 109.88 0.00
shared kglsim object batch 86.87 86.87 0.00
shared library cache 355.12 356.75 0.46
shared sql area 2,105.87 2,156.94 2.43
  buffer_cache 4,368.00 4,368.00 0.00
  fixed_sga 2.00 2.00 0.00
  log_buffer 13.99 13.99 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 987,264 1,223,524 1187127 1187127
gcs_shadows 900,441 1,147,971 1187127 1187127


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/imscmdb/adump   
background_dump_dest /oracle/admin/imscmdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files /dev/rimsh_control01, /dev/rimsh_control02   
core_dump_dest /oracle/admin/imscmdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name imscmdb   
dispatchers (PROTOCOL=TCP) (SERVICE=imscmdbXDB)   
instance_number 1   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=10.229.252.52)(PORT=1521))   
log_archive_dest_1 LOCATION=/arch1   
open_cursors 300   
pga_aggregate_target 4284481536   
processes 1500   
remote_listener LISTENERS_IMSCMDB   
remote_login_passwordfile EXCLUSIVE   
sessions 1655   
sga_max_size 10737418240   
sga_target 10737418240   
spfile /dev/rimsh_spfile   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/imscmdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 282,147 89.96 0.14
acks for commit broadcast(logical) 530,093 169.02 0.26
broadcast msgs on commit(actual) 1,338,160 426.68 0.66
broadcast msgs on commit(logical) 1,347,206 429.56 0.67
broadcast msgs on commit(wasted) 89,308 28.48 0.04
broadcast on commit wait time(ms) 176,834 56.38 0.09
broadcast on commit waits 960,474 306.25 0.48
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 4 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 439,136 140.02 0.22
gcs ast xid 8 0.00 0.00
gcs blocked converts 267,035 85.15 0.13
gcs blocked cr converts 272,075 86.75 0.13
gcs compatible basts 86 0.03 0.00
gcs compatible cr basts (global) 1,131 0.36 0.00
gcs compatible cr basts (local) 313,973 100.11 0.16
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 129,924 41.43 0.06
gcs dbwr write request msgs 73,119 23.31 0.04
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 4,365 1.39 0.00
gcs immediate (null) converts 5,934 1.89 0.00
gcs immediate cr (compatible) converts 6 0.00 0.00
gcs immediate cr (null) converts 42,145 13.44 0.02
gcs indirect ast 18,414 5.87 0.01
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 13,613 4.34 0.01
gcs msgs process time(ms) 1,573,396 501.69 0.78
gcs msgs received 3,414,494 1,088.73 1.69
gcs out-of-order msgs 12 0.00 0.00
gcs pings refused 139 0.04 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 38 0.01 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 4 0.00 0.00
gcs regular cr 1 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 39,835 12.70 0.02
gcs side channel msgs logical 949,164 302.65 0.47
gcs stale cr 32 0.01 0.00
gcs undo cr 2,085 0.66 0.00
gcs write notification msgs 8,942 2.85 0.00
gcs writes refused 14 0.00 0.00
ges msgs process time(ms) 4,651 1.48 0.00
ges msgs received 12,968 4.13 0.01
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 99,833 31.83 0.05
implicit batch messages sent 85,166 27.16 0.04
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 1,342,795 428.16 0.66
messages queue sent actual 1,507,501 480.67 0.75
messages queue sent logical 1,737,526 554.02 0.86
messages received actual 2,794,683 891.10 1.38
messages received logical 3,427,534 1,092.89 1.70
messages sent directly 952,181 303.61 0.47
messages sent indirectly 383,394 122.25 0.19
messages sent not implicit batched 1,422,346 453.52 0.70
messages sent pbatched 335,463 106.96 0.17
msgs causing lmd to send msgs 3,563 1.14 0.00
msgs causing lms(s) to send msgs 31,161 9.94 0.02
msgs received queue time (ms) 162,955 51.96 0.08
msgs received queued 3,427,454 1,092.86 1.70
msgs sent queue time (ms) 12,997,950 4,144.47 6.43
msgs sent queue time on ksxp (ms) 1,358,837 433.27 0.67
msgs sent queued 1,736,683 553.75 0.86
msgs sent queued on ksxp 2,744,766 875.18 1.36
process batch messages received 981,943 313.10 0.49
process batch messages sent 315,575 100.62 0.16


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 458,266
CURRENT Block Requests 2,648
Data Block Requests 458,265
Undo Block Requests 2,050
TX Block Requests 462
Current Results 454,481
Private results 2
Zero Results 6,304
Disk Read Results 29
Fail Results 3
Fairness Down Converts 4,299
Fairness Clears 0
Free GC Elements 0
Flushes 6,643
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 253
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 915,089 99.50 0.00 0.49 0.01 0.00
Flushes 1,153 89.59 8.59 1.56 0.26 0.00
Writes 130,092 67.57 28.21 2.49 1.35 0.38


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 463,589 99.40 0.59 0.01 454,933 98.81 0.98 0.21
2 Others 92 98.91 1.09 0.00 497 96.58 0.20 3.22
2 undo header 502 97.01 2.99 0.00 15 100.00 0.00 0.00
2 undo block 115 96.52 3.48 0.00 0      


Back to Top

End of Report