WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1198388159orcl2210.2.0.3.0YESnode2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:479604-Jun-09 16:00:1543 2.9
End Snap:479804-Jun-09 18:00:5597 14.6
Elapsed:  120.66 (mins)  
DB Time:  159.43 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,520M 5,520MStd Block Size: 8K
Shared Pool Size: 624M 624MLog Buffer: 4,224K

Load Profile

Per SecondPer Transaction
Redo size: 272,105.21 6,817.41
Logical reads: 33,734.08 845.18
Block changes: 1,353.80 33.92
Physical reads: 125.43 3.14
Physical writes: 32.99 0.83
User calls: 773.61 19.38
Parses: 399.25 10.00
Hard parses: 0.38 0.01
Sorts: 81.06 2.03
Logons: 0.59 0.01
Executes: 798.76 20.01
Transactions: 39.91 

% Blocks changed per Read: 4.01Recursive Call %: 65.43
Rollback per transaction %: 2.57Rows per Sort: 51.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 99.79In-memory Sort %: 100.00
Library Hit %: 99.92Soft Parse %: 99.90
Execute to Parse %: 50.02Latch Hit %: 99.92
Parse CPU to Parse Elapsd %: 97.41% Non-Parse CPU: 97.46

Shared Pool Statistics

BeginEnd
Memory Usage %: 76.65 84.63
% SQL with executions>1: 59.39 85.17
% Memory for SQL w/exec>1: 61.30 85.67

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  3,195  33.4 
gc buffer busy 50,650 1,366 27 14.3Cluster
enq: TX - row lock contention 46,751 1,292 28 13.5Application
flashback buf free by RVWR 24,961 947 38 9.9Other
log file sync 330,497 579 2 6.1Commit

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 108.30 2.71
Global Cache blocks served: 112.55 2.82
GCS/GES messages received: 369.38 9.25
GCS/GES messages sent: 388.89 9.74
DBWR Fusion writes: 5.27 0.13
Estd Interconnect traffic (KB) 1,914.91 

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

Buffer access - local cache %: 99.47
Buffer access - remote cache %: 0.32
Buffer access - disk %: 0.21

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.6
Avg global cache cr block receive time (ms): 0.8
Avg global cache current block receive time (ms): 2.1
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 12.9
Avg global cache cr block flush time (ms): 2.1
Avg global cache current block pin time (ms): 0.6
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 2.2
Avg global cache current block flush time (ms): 24.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.4
Avg message received queue time (ms): 0.1
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 49.06
% of indirect sent messages: 25.59
% of flow controlled messages: 25.35

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,840.19 92.42
DB CPU 3,194.83 33.40
Java execution elapsed time 677.30 7.08
PL/SQL execution elapsed time 146.04 1.53
parse time elapsed 93.25 0.97
sequence load elapsed time 41.37 0.43
hard parse elapsed time 20.91 0.22
PL/SQL compilation elapsed time 1.55 0.02
repeated bind elapsed time 1.48 0.02
connection management call elapsed time 1.23 0.01
failed parse elapsed time 0.16 0.00
hard parse (sharing criteria) elapsed time 0.06 0.00
hard parse (bind mismatch) elapsed time 0.04 0.00
DB time 9,565.54  
background elapsed time 1,337.08  
background cpu time 457.44  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Cluster 1,005,055 0.11 2,516 3 3.48
Other 515,930 54.07 1,315 3 1.79
Application 48,146 2.41 1,292 27 0.17
User I/O 424,622 0.00 1,052 2 1.47
Commit 330,497 0.00 579 2 1.14
Configuration 15,048 46.96 475 32 0.05
System I/O 457,739 0.00 342 1 1.58
Concurrency 94,140 0.03 49 1 0.33
Network 3,797,854 0.00 12 0 13.14

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 50,650 1.69 1,366 27 0.18
enq: TX - row lock contention 46,751 2.48 1,292 28 0.16
flashback buf free by RVWR 24,961 1.44 947 38 0.09
log file sync 330,497 0.00 579 2 1.14
gc current block busy 13,104 1.64 562 43 0.05
db file sequential read 161,061 0.00 496 3 0.56
enq: HW - contention 8,613 8.08 473 55 0.03
db file scattered read 47,483 0.00 262 6 0.16
gcs log flush sync 147,140 41.05 245 2 0.51
log file parallel write 360,070 0.00 218 1 1.25
gc cr block busy 47,829 0.00 150 3 0.17
gc cr block 2-way 336,140 0.00 141 0 1.16
gc current block 2-way 296,976 0.00 138 0 1.03
db file parallel read 3,358 0.00 136 41 0.01
direct path read 160,814 0.00 113 1 0.56
gc current multi block request 69,485 0.02 71 1 0.24
reliable message 192 19.27 56 290 0.00
db file parallel write 65,354 0.00 55 1 0.23
gc cr multi block request 114,874 0.00 46 0 0.40
log file sequential read 2,270 0.00 44 19 0.01
direct path write 51,645 0.00 39 1 0.18
gc current grant busy 49,714 0.00 33 1 0.17
cr request retry 42 100.00 19 444 0.00
buffer busy waits 51,311 0.01 19 0 0.18
row cache lock 24,565 0.00 18 1 0.09
DFS lock handle 33,094 0.00 14 0 0.11
global enqueue expand wait 1,034 82.11 13 12 0.00
Log archive I/O 5,615 0.00 12 2 0.02
enq: TX - index contention 637 0.16 11 17 0.00
control file sequential read 20,577 0.00 10 0 0.07
read by other session 261 0.00 6 22 0.00
wait for scn ack 39,517 0.00 6 0 0.14
SQL*Net more data to client 429,434 0.00 5 0 1.49
IPC send completion sync 11,675 99.97 5 0 0.04
gc current grant 2-way 16,992 0.00 5 0 0.06
SQL*Net message to client 3,118,542 0.00 4 0 10.79
control file parallel write 3,835 0.00 3 1 0.01
gc current retry 184 0.00 3 16 0.00
SQL*Net more data from client 249,878 0.00 2 0 0.86
gc cr grant 2-way 8,997 0.00 2 0 0.03
rdbms ipc reply 934 0.00 2 2 0.00
enq: WF - contention 14 21.43 2 123 0.00
log file switch completion 39 0.00 2 42 0.00
enq: PS - contention 3,989 0.00 1 0 0.01
enq: US - contention 4,297 0.00 1 0 0.01
kjbdrmcvtq lmon drm quiesce: ping completion 37 27.03 1 21 0.00
latch: cache buffers chains 16,091 0.00 1 0 0.06
CGS wait for IPC msg 100,433 99.89 1 0 0.35
ksxr poll remote instances 73,497 54.97 1 0 0.25
SQL*Net break/reset to client 1,350 0.00 1 0 0.00
ges global resource directory to be frozen 37 97.30 1 15 0.00
PX Deq: reap credit 56,741 98.49 0 0 0.20
cursor: pin S wait on X 23 100.00 0 16 0.00
gcs drm freeze in enter server mode 6 0.00 0 60 0.00
gc current split 48 0.00 0 6 0.00
gc remaster 8 0.00 0 30 0.00
library cache lock 662 0.00 0 0 0.00
os thread startup 4 0.00 0 42 0.00
library cache pin 754 0.00 0 0 0.00
LGWR wait for redo copy 5,784 0.00 0 0 0.02
change tracking file synchronous read 137 0.00 0 1 0.00
latch free 222 0.00 0 1 0.00
enq: CF - contention 266 0.00 0 0 0.00
buffer deadlock 9,195 94.37 0 0 0.03
change tracking file synchronous write 120 0.00 0 1 0.00
latch: object queue header operation 149 0.00 0 0 0.00
gc current block unknown 6 0.00 0 7 0.00
KJC: Wait for msg sends to complete 1,204 0.00 0 0 0.00
enq: TM - contention 45 0.00 0 1 0.00
library cache load lock 9 0.00 0 2 0.00
enq: TD - KTF dump entries 20 0.00 0 1 0.00
gc cr failure 45 0.00 0 0 0.00
PX Deq: Signal ACK 120 30.00 0 0 0.00
latch: library cache 42 0.00 0 0 0.00
undo segment extension 6,382 99.81 0 0 0.02
PX Deq Credit: send blkd 92 41.30 0 0 0.00
latch: enqueue hash chains 93 0.00 0 0 0.00
latch: ges resource hash list 125 0.00 0 0 0.00
wait list latch free 1 0.00 0 11 0.00
latch: cache buffers lru chain 17 0.00 0 1 0.00
log file single write 18 0.00 0 0 0.00
enq: TA - contention 22 0.00 0 0 0.00
enq: TT - contention 23 0.00 0 0 0.00
enq: TX - allocate ITL entry 13 0.00 0 0 0.00
latch: KCL gc element parent latch 144 0.00 0 0 0.00
enq: SQ - contention 1 0.00 0 5 0.00
enq: FL - Flashback database log 10 0.00 0 0 0.00
enq: TX - contention 9 0.00 0 0 0.00
lock escalate retry 183 90.71 0 0 0.00
latch: shared pool 21 0.00 0 0 0.00
enq: FB - contention 8 0.00 0 0 0.00
enq: DR - contention 6 0.00 0 0 0.00
latch: library cache pin 10 0.00 0 0 0.00
ges inquiry response 2 0.00 0 1 0.00
gc cr block congested 1 0.00 0 2 0.00
enq: WL - contention 5 0.00 0 0 0.00
enq: CT - global space management 5 0.00 0 0 0.00
enq: JS - job run lock - synchronize 4 0.00 0 0 0.00
latch: gcs resource hash 27 0.00 0 0 0.00
latch: redo allocation 14 0.00 0 0 0.00
latch: undo global data 8 0.00 0 0 0.00
cursor: pin S 246 0.00 0 0 0.00
enq: RS - read alert level 3 0.00 0 0 0.00
enq: CT - state 2 0.00 0 0 0.00
gc current request 2 0.00 0 0 0.00
enq: IR - contention 2 0.00 0 0 0.00
enq: FD - Marker generation 2 0.00 0 0 0.00
enq: RS - prevent aging list update 2 0.00 0 0 0.00
latch: row cache objects 4 0.00 0 0 0.00
lock deadlock retry 15 100.00 0 0 0.00
latch: library cache lock 2 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
cursor: mutex X 1 0.00 0 0 0.00
cursor: mutex S 4 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 1 0.00 0 0 0.00
latch: checkpoint queue latch 1 0.00 0 0 0.00
SQL*Net message from client 3,118,487 0.00 343,732 110 10.79
PX Idle Wait 8,626 53.93 14,064 1630 0.03
gcs remote message 2,146,606 81.59 13,716 6 7.43
virtual circuit status 242 100.00 7,088 29288 0.00
DIAG idle wait 34,336 0.00 7,068 206 0.12
ASM background timer 1,820 0.00 7,068 3883 0.01
wait for unread message on broadcast channel 7,222 98.82 7,066 978 0.02
jobq slave wait 3,033 47.44 7,063 2329 0.01
Streams AQ: qmn slave idle wait 256 0.00 7,057 27566 0.00
Streams AQ: qmn coordinator idle wait 538 47.96 7,057 13117 0.00
ges remote message 253,882 79.69 7,057 28 0.88
class slave wait 291 7.90 6,806 23389 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,961 3960566 0.00
PX Deq: Execution Msg 23,306 32.73 21 1 0.08
PX Deq: Execute Reply 134 35.82 2 13 0.00
PX Deq: Msg Fragment 6,500 37.29 1 0 0.02
KSV master wait 264 0.00 1 3 0.00
PX Deq: Parse Reply 135 36.30 0 1 0.00
PX Deq: Join ACK 135 36.30 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 538 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
events in waitclass Other 375,004 53.79 310 1 1.30
log file parallel write 360,070 0.00 218 1 1.25
db file parallel write 65,354 0.00 55 1 0.23
log file sequential read 2,270 0.00 44 19 0.01
Log archive I/O 5,615 0.00 12 2 0.02
control file sequential read 17,860 0.00 9 1 0.06
control file parallel write 3,835 0.00 3 1 0.01
row cache lock 1,126 0.00 0 0 0.00
os thread startup 4 0.00 0 42 0.00
gc current block 2-way 330 0.00 0 0 0.00
buffer busy waits 395 1.27 0 0 0.00
gc current block busy 9 0.00 0 11 0.00
gc cr block 2-way 187 0.00 0 0 0.00
direct path read 113 0.00 0 1 0.00
gc current multi block request 45 0.00 0 1 0.00
gc current grant busy 70 0.00 0 0 0.00
enq: TM - contention 5 0.00 0 4 0.00
log file single write 18 0.00 0 0 0.00
library cache lock 23 0.00 0 0 0.00
gc cr block busy 6 0.00 0 1 0.00
direct path write 112 0.00 0 0 0.00
gc buffer busy 1 0.00 0 3 0.00
latch: cache buffers chains 100 0.00 0 0 0.00
log file sync 4 0.00 0 1 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 661,900 19.48 133,060 201 2.29
gcs remote message 2,146,581 81.59 13,716 6 7.43
ASM background timer 1,820 0.00 7,068 3883 0.01
DIAG idle wait 34,335 0.00 7,068 206 0.12
pmon timer 2,671 99.96 7,066 2645 0.01
Streams AQ: qmn slave idle wait 256 0.00 7,057 27566 0.00
Streams AQ: qmn coordinator idle wait 538 47.96 7,057 13117 0.00
ges remote message 253,844 79.69 7,057 28 0.88
smon timer 162 0.00 7,048 43504 0.00
class slave wait 287 8.01 6,806 23715 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 3,961 3960566 0.00
KSV master wait 264 0.00 1 3 0.00
PX Deq: Join ACK 60 40.00 0 1 0.00
PX Deq: Parse Reply 60 40.00 0 1 0.00
PX Deq: Execute Reply 59 38.98 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 538 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 59,246
AVG_IDLE_TIME 664,151
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 17,694
AVG_USER_TIME 41,324
BUSY_TIME 475,589
IDLE_TIME 5,314,920
IOWAIT_TIME 0
SYS_TIME 143,333
USER_TIME 332,256
LOAD 0
OS_CPU_WAIT_TIME 8,500
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 4,096
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 16,634,126,336
NUM_CPUS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
orcl_rac 9,515.50 3,148.30 905,716 243,040,851
orcl 45.40 42.80 345 59,049
SYS$USERS 4.90 3.80 383 521,020
SYS$BACKGROUND 0.00 0.00 2,236 611,858
orclXDB 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
orcl_rac 422683 104744 85298 4657 0 0 3774250 1235
orcl 317 65 736 15 0 0 16356 2
SYS$USERS 162 47 1125 19 0 0 7505 1
SYS$BACKGROUND 1470 367 6992 175 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
1,879 68 8,081 0.23 19.65 6y4wha9gqjbkb java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_outbox.createOut...
1,750 48 8,079 0.22 18.29 03hcmjsrzk2uj java@jbosscluster2-s (TNS V1-V3) INSERT INTO MESSAGECONTENTS (I...
1,292 198 62,045 0.02 13.51 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
1,097 94 113,288 0.01 11.46 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
570 341 10,169 0.06 5.96 apgdwp5n2wdug java@jbosscluster2-s (TNS V1-V3) SELECT T1.RN, T1.SUBMESSAGEID...
560 331 10,169 0.06 5.85 6ubadds0qp649 java@jbosscluster2-s (TNS V1-V3) SELECT * FROM ( ...
549 81 113,285 0.00 5.74 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...
329 224 8,468 0.04 3.44 gvt7aq1y5uvp4 java@jbosscluster2-s (TNS V1-V3) SELECT ALL_RESULTS.ID, ALL_RE...
302 105 13,717 0.02 3.15 0bgsvc3fy531p java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
285 78 53,708 0.01 2.98 4vngfzppsahts java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_prepare...
282 49 6,870 0.04 2.95 1dtdmbwrskwxk java@jbosscluster2-s (TNS V1-V3) BEGIN p_outbox.sendOutboxMessa...
252 37 3,548 0.07 2.63 6h0sav4txmn3a java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
242 242 375,621 0.00 2.53 b6qv8f7zwqz0d java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_commit_...
230 230 384,687 0.00 2.40 779s4601t4v6f java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_end_new...
220 129 10,169 0.02 2.30 gmc1a22nkcump java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
207 52 8,078 0.03 2.17 dgc3kfn6agh0z java@jbosscluster2-s (TNS V1-V3) BEGIN p_mailboxitem.manageMail...
184 184 384,689 0.00 1.92 bnk1g42zxuk5u java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_start_n...
144 129 8,079 0.02 1.51 9ztc2usu3fmj5 java@jbosscluster2-s (TNS V1-V3) SELECT P.ID ID, P.SYSTEMID SY...
131 77 10,169 0.01 1.37 4fmn6aaz2ds06 java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
125 43 6,872 0.02 1.30 492ahypg2kn82 java@jbosscluster2-s (TNS V1-V3) BEGIN p_recipient.updateRecipi...
116 20 51,012 0.00 1.21 danx7unqfwhw8 java@jbosscluster2-s (TNS V1-V3) UPDATE JMS_MESSAGES SET TXID=:...
99 16 6,543 0.02 1.03 7kqrapr7256ud java@jbosscluster2-s (TNS V1-V3) INSERT INTO MAILBOXITEM (MAILB...

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
341 570 10,169 0.03 5.96 apgdwp5n2wdug java@jbosscluster2-s (TNS V1-V3) SELECT T1.RN, T1.SUBMESSAGEID...
331 560 10,169 0.03 5.85 6ubadds0qp649 java@jbosscluster2-s (TNS V1-V3) SELECT * FROM ( ...
242 242 375,621 0.00 2.53 b6qv8f7zwqz0d java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_commit_...
230 230 384,687 0.00 2.40 779s4601t4v6f java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_end_new...
224 329 8,468 0.03 3.44 gvt7aq1y5uvp4 java@jbosscluster2-s (TNS V1-V3) SELECT ALL_RESULTS.ID, ALL_RE...
198 1,292 62,045 0.00 13.51 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
184 184 384,689 0.00 1.92 bnk1g42zxuk5u java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_start_n...
129 220 10,169 0.01 2.30 gmc1a22nkcump java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
129 144 8,079 0.02 1.51 9ztc2usu3fmj5 java@jbosscluster2-s (TNS V1-V3) SELECT P.ID ID, P.SYSTEMID SY...
105 302 13,717 0.01 3.15 0bgsvc3fy531p java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
94 1,097 113,288 0.00 11.46 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
81 549 113,285 0.00 5.74 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...
78 285 53,708 0.00 2.98 4vngfzppsahts java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_prepare...
77 131 10,169 0.01 1.37 4fmn6aaz2ds06 java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
68 1,879 8,081 0.01 19.65 6y4wha9gqjbkb java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_outbox.createOut...
52 207 8,078 0.01 2.17 dgc3kfn6agh0z java@jbosscluster2-s (TNS V1-V3) BEGIN p_mailboxitem.manageMail...
49 282 6,870 0.01 2.95 1dtdmbwrskwxk java@jbosscluster2-s (TNS V1-V3) BEGIN p_outbox.sendOutboxMessa...
48 1,750 8,079 0.01 18.29 03hcmjsrzk2uj java@jbosscluster2-s (TNS V1-V3) INSERT INTO MESSAGECONTENTS (I...
43 125 6,872 0.01 1.30 492ahypg2kn82 java@jbosscluster2-s (TNS V1-V3) BEGIN p_recipient.updateRecipi...
37 252 3,548 0.01 2.63 6h0sav4txmn3a java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
20 116 51,012 0.00 1.21 danx7unqfwhw8 java@jbosscluster2-s (TNS V1-V3) UPDATE JMS_MESSAGES SET TXID=:...
16 99 6,543 0.00 1.03 7kqrapr7256ud java@jbosscluster2-s (TNS V1-V3) INSERT INTO MAILBOXITEM (MAILB...

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
94,548,796 10,169 9,297.75 38.71 341.43 570.11 apgdwp5n2wdug java@jbosscluster2-s (TNS V1-V3) SELECT T1.RN, T1.SUBMESSAGEID...
94,539,705 10,169 9,296.85 38.71 330.68 559.61 6ubadds0qp649 java@jbosscluster2-s (TNS V1-V3) SELECT * FROM ( ...
41,324,137 8,468 4,880.04 16.92 224.45 329.24 gvt7aq1y5uvp4 java@jbosscluster2-s (TNS V1-V3) SELECT ALL_RESULTS.ID, ALL_RE...
36,524,859 62,045 588.68 14.96 198.17 1292.14 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
31,433,809 10,169 3,091.14 12.87 128.86 220.11 gmc1a22nkcump java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
21,174,591 13,717 1,543.68 8.67 104.78 301.56 0bgsvc3fy531p java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
15,671,335 10,169 1,541.09 6.42 76.61 131.41 4fmn6aaz2ds06 java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
6,929,673 1,496 4,632.13 2.84 60.97 82.62 1cbrtxcgj2pty java@jbosscluster2-s (TNS V1-V3) BEGIN p_compliance_details.cre...
6,926,807 1,133,920 6.11 2.84 57.76 68.44 fmw713zqmuzzz java@jbosscluster2-s (TNS V1-V3) INSERT INTO COMPLIANCE_DETAILS...
5,785,631 3,548 1,630.67 2.37 37.40 252.01 6h0sav4txmn3a java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
5,779,409 113,288 51.02 2.37 93.88 1096.54 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
4,794,664 1,198,694 4.00 1.96 76.22 76.22 4z6jfdhm5uxr7 java@jbosscluster2-s (TNS V1-V3) select longname from javasnm$ ...
3,116,637 113,285 27.51 1.28 80.58 548.85 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...

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
207,700 1 207,700.00 22.87 11.05 26.41 6j2ad4xn6ga79 java@jbosscluster2-s (TNS V1-V3) INSERT INTO RETENTION_MAILBOXI...
120,380 1 120,380.00 13.26 9.00 19.94 5abbdkwfx9fs6 java@jbosscluster2-s (TNS V1-V3) DELETE SUBMESSAGEHISTORY WHERE...
87,954 62,045 1.42 9.69 198.17 1292.14 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
73,492 8,081 9.09 8.09 68.29 1879.38 6y4wha9gqjbkb java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_outbox.createOut...
71,848 8,079 8.89 7.91 48.06 1749.97 03hcmjsrzk2uj java@jbosscluster2-s (TNS V1-V3) INSERT INTO MESSAGECONTENTS (I...
61,737 3,548 17.40 6.80 37.40 252.01 6h0sav4txmn3a java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
59,148 13,717 4.31 6.51 104.78 301.56 0bgsvc3fy531p java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
47,884 10,169 4.71 5.27 341.43 570.11 apgdwp5n2wdug java@jbosscluster2-s (TNS V1-V3) SELECT T1.RN, T1.SUBMESSAGEID...
47,870 10,169 4.71 5.27 330.68 559.61 6ubadds0qp649 java@jbosscluster2-s (TNS V1-V3) SELECT * FROM ( ...
44,431 1 44,431.00 4.89 7.13 12.02 9bmg1119wuqm7 java@jbosscluster2-s (TNS V1-V3) DELETE MAILBOXITEM WHERE (SUBM...
24,174 1,496 16.16 2.66 60.97 82.62 1cbrtxcgj2pty java@jbosscluster2-s (TNS V1-V3) BEGIN p_compliance_details.cre...
24,167 1,133,920 0.02 2.66 57.76 68.44 fmw713zqmuzzz java@jbosscluster2-s (TNS V1-V3) INSERT INTO COMPLIANCE_DETAILS...
11,425 8,468 1.35 1.26 224.45 329.24 gvt7aq1y5uvp4 java@jbosscluster2-s (TNS V1-V3) SELECT ALL_RESULTS.ID, ALL_RE...

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
1,198,694 1,198,703 1.00 0.00 0.00 4z6jfdhm5uxr7 java@jbosscluster2-s (TNS V1-V3) select longname from javasnm$ ...
1,133,920 1,133,918 1.00 0.00 0.00 fmw713zqmuzzz java@jbosscluster2-s (TNS V1-V3) INSERT INTO COMPLIANCE_DETAILS...
384,689 384,687 1.00 0.00 0.00 bnk1g42zxuk5u java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_start_n...
384,687 384,686 1.00 0.00 0.00 779s4601t4v6f java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_end_new...
384,681 384,678 1.00 0.00 0.00 avc1jqzz04wpr java@jbosscluster2-s (TNS V1-V3) SELECT 'x' FROM DUAL
375,621 375,616 1.00 0.00 0.00 b6qv8f7zwqz0d java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_commit_...
113,288 51,002 0.45 0.00 0.01 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
113,285 113,283 1.00 0.00 0.00 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...
113,062 113,062 1.00 0.00 0.00 21dhsz9pz0d27 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_TRANSACTIONS (...
62,045 62,045 1.00 0.00 0.02 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
384,692 384,689 13.31 bnk1g42zxuk5u java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_start_n...
384,691 384,687 13.31 779s4601t4v6f java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_end_new...
384,691 384,681 13.31 avc1jqzz04wpr java@jbosscluster2-s (TNS V1-V3) SELECT 'x' FROM DUAL
375,621 375,621 13.00 b6qv8f7zwqz0d java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_commit_...
113,289 113,285 3.92 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...
113,289 113,288 3.92 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
113,064 113,062 3.91 21dhsz9pz0d27 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_TRANSACTIONS (...
62,044 62,045 2.15 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
56,982 56,982 1.97 0hsyjkg4q7z0g java@jbosscluster2-s (TNS V1-V3) BEGIN p_session.getActiveSessi...
53,708 53,708 1.86 4vngfzppsahts java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_prepare...
51,012 51,012 1.76 danx7unqfwhw8 java@jbosscluster2-s (TNS V1-V3) UPDATE JMS_MESSAGES SET TXID=:...
31,304 31,304 1.08 d6xwurybd1sc1 java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_audit.addAuditEn...

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

No data exists for this section of the report.

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
497.51 90.65 548.85 80.58 113,285 6yu9g4s41wmpp java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_TRANSACTIONS W...
407.64 21.69 1,879.38 68.29 8,081 6y4wha9gqjbkb java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_outbox.createOut...
310.80 17.76 1,749.97 48.06 8,079 03hcmjsrzk2uj java@jbosscluster2-s (TNS V1-V3) INSERT INTO MESSAGECONTENTS (I...
298.10 23.07 1,292.14 198.17 62,045 cz0d2rv3hsxa2 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_MESSAGES (MESS...
265.72 24.23 1,096.54 93.88 113,288 fqsda57xpqq15 java@jbosscluster2-s (TNS V1-V3) DELETE FROM JMS_MESSAGES WHERE...
223.85 79.25 282.47 48.70 6,870 1dtdmbwrskwxk java@jbosscluster2-s (TNS V1-V3) BEGIN p_outbox.sendOutboxMessa...
154.18 74.39 207.26 51.68 8,078 dgc3kfn6agh0z java@jbosscluster2-s (TNS V1-V3) BEGIN p_mailboxitem.manageMail...
95.51 82.39 115.92 20.20 51,012 danx7unqfwhw8 java@jbosscluster2-s (TNS V1-V3) UPDATE JMS_MESSAGES SET TXID=:...
88.60 89.85 98.61 16.37 6,543 7kqrapr7256ud java@jbosscluster2-s (TNS V1-V3) INSERT INTO MAILBOXITEM (MAILB...
67.22 53.91 124.68 42.57 6,872 492ahypg2kn82 java@jbosscluster2-s (TNS V1-V3) BEGIN p_recipient.updateRecipi...
62.47 81.17 76.96 17.24 16,339 68mpuua893h37 java@jbosscluster1-s (TNS V1-V3) BEGIN :1 := p_rts.markAsRead(:...
58.07 87.23 66.57 8.01 8,754 ch6ygprzxubjr java@jbosscluster1-s (TNS V1-V3) UPDATE MAILBOXITEM SET LASTMOD...
50.85 78.83 64.51 21.71 6,870 253h456mgf3zr java@jbosscluster2-s (TNS V1-V3) UPDATE MAILBOXITEM SET MAILTYP...
48.12 80.69 59.63 18.24 22,866 6cjxa2k19akg5 java@jbosscluster1-s (TNS V1-V3) SELECT SUBMESSAGE.ID, SUBMESS...
43.47 13.20 329.24 224.45 8,468 gvt7aq1y5uvp4 java@jbosscluster2-s (TNS V1-V3) SELECT ALL_RESULTS.ID, ALL_RE...
40.44 48.63 83.15 11.92 13,341 9pwyz2pm98vxx java@jbosscluster2-s (TNS V1-V3) BEGIN p_retention.updateMessag...
39.99 85.60 46.72 10.70 6,543 d0mzzx77304yz java@jbosscluster2-s (TNS V1-V3) INSERT INTO SUBMESSAGE (ID, S...
38.96 51.66 75.42 5.54 6,590 0fvy4tf0x9tm0 java@jbosscluster2-s (TNS V1-V3) UPDATE SUBMESSAGERETENTION SET...
38.15 17.33 220.11 128.86 10,169 gmc1a22nkcump java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
37.67 88.17 42.72 14.12 5,374 gwca9akskcaq9 java@jbosscluster2-s (TNS V1-V3) DELETE FROM DRAFTRECIPIENTS WH...
35.75 86.73 41.23 10.48 18,861 9utsq4swwsmzd java@jbosscluster2-s (TNS V1-V3) SELECT SMRP.SUBMESSAGEID, SMR...
35.08 11.63 301.56 104.78 13,717 0bgsvc3fy531p java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
34.59 77.81 44.45 11.29 5,374 9bab7znufyxyv java@jbosscluster2-s (TNS V1-V3) INSERT INTO MAILBOXITEM ( MAIL...
34.25 13.59 252.01 37.40 3,548 6h0sav4txmn3a java@jbosscluster2-s (TNS V1-V3) SELECT ID, NAME, OWNERID, O...
32.95 72.32 45.57 13.87 5,374 dmvgk7gcc8m1t java@jbosscluster2-s (TNS V1-V3) INSERT INTO RECIPIENT SELECT :...
29.62 5.20 570.11 341.43 10,169 apgdwp5n2wdug java@jbosscluster2-s (TNS V1-V3) SELECT T1.RN, T1.SUBMESSAGEID...
29.62 5.29 559.61 330.68 10,169 6ubadds0qp649 java@jbosscluster2-s (TNS V1-V3) SELECT * FROM ( ...
20.73 15.77 131.41 76.61 10,169 4fmn6aaz2ds06 java@jbosscluster2-s (TNS V1-V3) SELECT COUNT(*) FROM MAILBOXIT...
17.69 31.42 56.28 38.03 113,062 21dhsz9pz0d27 java@jbosscluster2-s (TNS V1-V3) INSERT INTO JMS_TRANSACTIONS (...
15.85 97.36 16.28 1.58 1,496 5ptjshzv4fbht java@jbosscluster2-s (TNS V1-V3) UPDATE SUBMESSAGE SET TYPE='M'...
14.48 75.72 19.12 13.01 22,866 fb9bdkw7ku1ws java@jbosscluster1-s (TNS V1-V3) SELECT SUBMESSAGEHISTORY.SUBME...
14.08 47.79 29.47 17.82 56,982 0hsyjkg4q7z0g java@jbosscluster2-s (TNS V1-V3) BEGIN p_session.getActiveSessi...
13.41 66.96 20.02 16.15 22,866 butrzvwc2ckcc java@jbosscluster1-s (TNS V1-V3) SELECT SUBMESSAGE.CS AS CHECKS...
13.25 16.03 82.62 60.97 1,496 1cbrtxcgj2pty java@jbosscluster2-s (TNS V1-V3) BEGIN p_compliance_details.cre...
13.20 19.28 68.44 57.76 1,133,920 fmw713zqmuzzz java@jbosscluster2-s (TNS V1-V3) INSERT INTO COMPLIANCE_DETAILS...
6.07 17.57 34.54 25.11 11,917 fnpgu5z2728vu java@jbosscluster2-s (TNS V1-V3) SELECT TO_CHAR(SEQ_MAILBOXITEM...
4.73 48.61 9.72 7.52 22,866 1zbussrsbs640 java@jbosscluster1-s (TNS V1-V3) SELECT RECIPIENT.ID, RECIPIEN...
3.92 14.83 26.41 11.05 1 6j2ad4xn6ga79 java@jbosscluster2-s (TNS V1-V3) INSERT INTO RETENTION_MAILBOXI...
3.24 40.88 7.92 5.86 6,543 7m7vsk5b9m836 java@jbosscluster2-s (TNS V1-V3) BEGIN p_validate.validateSecur...
3.13 24.50 12.76 9.84 12,462 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
2.68 13.46 19.94 9.00 1 5abbdkwfx9fs6 java@jbosscluster2-s (TNS V1-V3) DELETE SUBMESSAGEHISTORY WHERE...
1.97 16.36 12.02 7.13 1 9bmg1119wuqm7 java@jbosscluster2-s (TNS V1-V3) DELETE MAILBOXITEM WHERE (SUBM...
1.79 31.25 5.71 4.79 25,170 8k7w26ugdmpzy java@jbosscluster2-s (TNS V1-V3) SELECT T1.ID, T1.SYSTEMID, T...
1.16 0.80 144.39 128.71 8,079 9ztc2usu3fmj5 java@jbosscluster2-s (TNS V1-V3) SELECT P.ID ID, P.SYSTEMID SY...
0.33 0.79 41.24 36.26 31,304 d6xwurybd1sc1 java@jbosscluster2-s (TNS V1-V3) BEGIN :1 := p_audit.addAuditEn...
0.29 0.12 242.38 241.56 375,621 b6qv8f7zwqz0d java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_commit_...
0.13 0.05 284.78 77.51 53,708 4vngfzppsahts java@jbosscluster2-s (TNS V1-V3) begin :1 := JAVA_XA.xa_prepare...
0.04 7.51 0.57 0.54 801 8zkxzv3y7h8jt java@jbosscluster2-s (TNS V1-V3) SELECT POPUL.ID, POPUL.SYSTEM...
0.02 8.34 0.22 0.11 196 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
0.01 9.12 0.15 0.04 398 41gwbcw6w43v8 java@jbosscluster2-s (TNS V1-V3) DELETE FROM SEARCHATTACHEMENT ...
0.01 13.41 0.06 0.06 284 8swypbbr0m372   select order#, columns, types ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
03hcmjsrzk2ujINSERT INTO MESSAGECONTENTS (ID, SYSTEMID, CREATIONTIMESTAMP, BODY, PLAINBODY, FORMATTYPE, TEMPLATEID, CUSTOMDATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
0bgsvc3fy531pSELECT COUNT(*) FROM MAILBOXITEM WHERE OWNERID = :B3 AND OWNERSYSTEMID = :B2 AND MAILBOXID = :B1 AND MAILTYPE='RECVD' AND TRASHEDTIMESTAMP IS NULL AND READDATE IS NULL
0fvy4tf0x9tm0UPDATE SUBMESSAGERETENTION SET LASTACCESSTIMESTAMP = :B5 , REPLYFORWARDTIMESTAMP = :B4 , EXPIRATIONTIMESTAMP = :B3 WHERE SUBMESSAGEID = :B2 AND SUBMESSAGESYSTEMID = :B1
0hsyjkg4q7z0gBEGIN p_session.getActiveSessionId(:1, :2, :3, :4, :5); END;
1cbrtxcgj2ptyBEGIN p_compliance_details.createAddressBook_array(:1, :2, :3, :4); END;
1dtdmbwrskwxkBEGIN p_outbox.sendOutboxMessage(:1, :2, :3, :4, :5, :6, :7); END;
1zbussrsbs640SELECT RECIPIENT.ID, RECIPIENT.SYSTEMID, RECIPIENT.SEQUENCENR, RECIPIENT.TYPE, RECIPIENT.LISTTYPE, POPULATION.DISPLAYNAME1, POPULATION.SMTPADDRESS FROM RECIPIENT , POPULATION WHERE RECIPIENT.SUBMESSAGEID = :B2 AND RECIPIENT.SUBMESSAGESYSTEMID = :B1 AND RECIPIENT.ID = POPULATION.ID AND RECIPIENT.SYSTEMID = POPULATION.SYSTEMID
21dhsz9pz0d27INSERT INTO JMS_TRANSACTIONS (TXID) values(:1)
253h456mgf3zrUPDATE MAILBOXITEM SET MAILTYPE = 'SENT', MAILBOXID = :B5 , LASTMODIFIEDTIMESTAMP = :B4 , READDATE = :B4 , LASTREADDATE = :B4 WHERE MAILBOXID = :B3 AND SUBMESSAGEID=:B2 AND SUBMESSAGESYSTEMID=:B1
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
41gwbcw6w43v8DELETE FROM SEARCHATTACHEMENT WHERE ID = :B2 AND SYSTEMID = :B1
492ahypg2kn82BEGIN p_recipient.updateRecipientsInboxes(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
4fmn6aaz2ds06SELECT COUNT(*) FROM MAILBOXITEM MBI WHERE MBI.OWNERID=:B3 AND MBI.OWNERSYSTEMID=:B2 AND MBI.MAILBOXID=:B1 AND MBI.MAILTYPE IN ('SENT', 'RECVD') AND MBI.TRASHEDTIMESTAMP IS NULL
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4vngfzppsahtsbegin :1 := JAVA_XA.xa_prepare_new (:2, :3, :4); end;
4z6jfdhm5uxr7select longname from javasnm$ where short = :1
5abbdkwfx9fs6DELETE SUBMESSAGEHISTORY WHERE HISTORYID IN (SELECT MAILBOXITEM.HISTORYID FROM SUBMESSAGERETENTION, MAILBOXITEM WHERE SUBMESSAGERETENTION.EXPIRATIONTIMESTAMP < :B1 AND SUBMESSAGERETENTION.HOLD = 0 AND MAILBOXITEM.SUBMESSAGEID = SUBMESSAGERETENTION.SUBMESSAGEID AND MAILBOXITEM.SUBMESSAGESYSTEMID = SUBMESSAGERETENTION.SUBMESSAGESYSTEMID )
5ptjshzv4fbhtUPDATE SUBMESSAGE SET TYPE='M', LASTACCESSTIMESTAMP = :B3 , CREATIONTIMESTAMP = :B3 , STATUS=-1 WHERE ID=:B2 AND SYSTEMID=:B1
68mpuua893h37BEGIN :1 := p_rts.markAsRead(:2, :3, :4, :5, :6); END;
6cjxa2k19akg5SELECT SUBMESSAGE.ID, SUBMESSAGE.SYSTEMID, SUBMESSAGE.TYPE, SUBMESSAGE.CREATIONTIMESTAMP, SUBMESSAGE.CREATIONTYPE, SUBMESSAGE.CS AS CHECKSUM, SUBMESSAGE.CST AS CHECKSUMTYPE, SUBMESSAGE.PV AS PERMISSIONVECTOR, SUBMESSAGE.PRIORITY, SUBMESSAGE.SENSITIVITY, SUBMESSAGE.LASTACCESSTIMESTAMP, SUBMESSAGE.SIGNATUREID, SUBMESSAGE.STATUS, SUBMESSAGE.SENDERID, SUBMESSAGE.SENDERSYSTEMID, POPULATION.DISPLAYNAME1, POPULATION.SMTPADDRESS, POPULATION.TYPE AS SENDERTYPE, SUBMESSAGE.SUBJECT, MESSAGECONTENTS.BODY, MESSAGECONTENTS.PLAINBODY, MESSAGECONTENTS.FORMATTYPE AS FORMATTYPE, MESSAGECONTENTS.TEMPLATEID, MESSAGECONTENTS.CUSTOMDATA FROM SUBMESSAGE , MESSAGECONTENTS, POPULATION, MAILBOXITEM WHERE SUBMESSAGE.ID = :B4 AND SUBMESSAGE.SYSTEMID = :B3 AND SUBMESSAGE.MESSAGEID=MESSAGECONTENTS.ID AND SUBMESSAGE.MESSAGESYSTEMID=MESSAGECONTENTS.SYSTEMID AND POPULATION.ID = SUBMESSAGE.SENDERID AND POPULATION.SYSTEMID = SUBMESSAGE.SENDERSYSTEMID AND SUBMESSAGE.ID = MAILBOXITEM.SUBMESSAGEID AND SUBMESSAGE.SYSTEMID = MAILBOXITEM.SUBMESSAGESYSTEMID AND MAILBOXITEM.OWNERID = :B2 AND MAILBOXITEM.OWNERSYSTEMID = :B1
6h0sav4txmn3aSELECT ID, NAME, OWNERID, OWNERSYSTEMID, MBTYPE, ITEMSTYPE, MBPARENT, -1, P_MAILBOX.GETUNREADITEMSCOUNT(ID, :B2 , :B1 ), DESCRIPTION FROM MAILBOX WHERE MAILBOX.OWNERID = :B2 AND MAILBOX.OWNERSYSTEMID = :B1
6j2ad4xn6ga79INSERT INTO RETENTION_MAILBOXITEM (MAILBOXITEMID, OWNERID, OWNERSYSTEMID, DELETEDTIMESTAMP) SELECT MAILBOXITEM.MAILBOXID, MAILBOXITEM.OWNERID, MAILBOXITEM.OWNERSYSTEMID, :B1 FROM MAILBOXITEM, SUBMESSAGERETENTION WHERE MAILBOXITEM.SUBMESSAGEID = SUBMESSAGERETENTION.SUBMESSAGEID AND MAILBOXITEM.SUBMESSAGESYSTEMID = SUBMESSAGERETENTION.SUBMESSAGESYSTEMID AND SUBMESSAGERETENTION.EXPIRATIONTIMESTAMP < :B1 AND SUBMESSAGERETENTION.HOLD = 0
6ubadds0qp649 SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY mailboxitem.deliverydate DESC, deliverydate DESC, mailboxitem.submessageid DESC) AS rn, mailboxitem.submessageid, mailboxitem.submessagesystemid, submessage.type, mailboxitem.readdate, mailboxitem.forwarddate, mailboxitem.replydate, mailboxitem.flag, submessage.priority, submessage.sensitivity, mailboxitem.containsattachments, population.displayname1, population.smtpaddress, submessage.subject, mailboxitem.deliverydate, submessage.pv, submessage.hasCustomData as hasCustomData FROM mailboxitem , submessage, population WHERE mailboxitem.ownerid = :v_population_id AND mailboxitem.ownersystemid = :v_population_system_id AND mailboxitem.mailboxid = :v_mailbox_id AND mailboxitem.mailtype='RECVD' AND mailboxitem.trashedtimestamp is null AND mailboxitem.deletedtimestamp is null AND submessage.id = mailboxitem.submessageid AND submessage.systemid = mailbox item.submessagesystemid AND submessage.senderid = population.id AND submessage.sendersystemid = population.systemid ) WHERE rn > :v_from AND rn <= :v_to
6y4wha9gqjbkbBEGIN :1 := p_outbox.createOutboxMail(:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28); END;
6yu9g4s41wmppDELETE FROM JMS_TRANSACTIONS WHERE TXID = :1
779s4601t4v6fbegin :1 := JAVA_XA.xa_end_new(:2, :3, :4, :5); end;
7kqrapr7256udINSERT INTO MAILBOXITEM (MAILBOXITEMID, MAILBOXID, SUBMESSAGEID, SUBMESSAGESYSTEMID, OWNERID, OWNERSYSTEMID, MAILTYPE, TRASHEDTIMESTAMP, HISTORYID, LASTMODIFIEDTIMESTAMP) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
7m7vsk5b9m836BEGIN p_validate.validateSecurity(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10); END;
8k7w26ugdmpzySELECT T1.ID, T1.SYSTEMID, T1.ENCRYPTED, T1.FILESIZE, T1.INDEXSTATUS, T1.HASHDEPTH, T1.CS, T1.CST, T1.ORIGINALFILENAME, T1.FILEEXTENSION FROM ATTACHMENT T1, ATTACHMENTCONTAINMENT T2, SUBMESSAGE T3 WHERE T1.ID = T2.CONTAINEE AND T1.SYSTEMID = T2.CONTAINEESYSTEMID AND T2.CONTAINER = T3.MESSAGEID AND T2.CONTAINERSYSTEMID = T3.MESSAGESYSTEMID AND T3.ID = :B2 AND T3.SYSTEMID = :B1
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8zkxzv3y7h8jtSELECT POPUL.ID, POPUL.SYSTEMID, POPUL.TYPE, POPUL.STATUS, POPUL.DISPLAYNAME1, POPUL.DISPLAYNAME2, POPUL.DOMAINID, POPUL.DOMAINSYSTEMID, '0' AS ADMINISTRABLE, POPUL.COMPLIANCESTATUS, POPUL.STARTDATE, POPUL.STARTTIME, POPUL.ENDDATE, POPUL.ENDTIME, PERS.LOGONNAME, PERS.FIRSTNAME, PERS.LASTNAME, PERS.PASSWORD, PERS.ROLEID, PERS.ROLESYSTEMID, PERS.ROLEBITS, ROLE.PERMISSIONBITS, ROLE.PERMISSIONSIZE, 0 AS DUMMYLOGGEDON, PERS.FAILEDLOGONS, PERS.TOKEN, PERS.TOKENEXPIREDATE, PERS.AUTOLOGONALLOWED, POPUL.SMTPADDRESS, PERS.EMAILADDRESS, PERS.SMSADDRESS, PERS.ADMINISTEREDDOMAINID, PERS.ADMINISTEREDDOMAINSYSTEMID, PERS.EUSID, EUS.TYPE, PERS.SYNCHRONIZE, CASE WHEN (PERS.ADMINISTEREDDOMAINID, PERS.ADMINISTEREDDOMAINSYSTEMID)= (SELECT ID, SYSTEMID FROM V_POPULATION R WHERE R.DOMAINID IS NULL AND R.DOMAINSYSTEMID IS NULL) THEN 1 ELSE 0 END AS ISROOTADMINISTERED FROM V_POPULATION POPUL, V_PERSON PERS, ROLE ROLE, EUS EUS WHERE POPUL.ID = :B2 AND POPUL.SYSTEMID = :B1 AND (POPUL.TYPE = 'P' OR POPUL.TYPE = 'A') AND PERS.ID = POPUL.ID AND PERS.SYSTEMID = POPUL.SYSTEMID AND PERS.ROLEID = ROLE.ID(+) AND PERS.ROLESYSTEMID = ROLE.SYSTEMID(+) AND PERS.EUSID = EUS.ID(+)
9bab7znufyxyvINSERT INTO MAILBOXITEM ( MAILBOXITEMID, MAILBOXID, SUBMESSAGEID, SUBMESSAGESYSTEMID, OWNERID, OWNERSYSTEMID, MAILTYPE, LASTMODIFIEDTIMESTAMP, LISTTYPE, DELIVERYDATE, CONTAINSATTACHMENTS) VALUES ( :B10 , :B9 , :B8 , :B7 , :B1 , :B2 , :B6 , :B5 , :B3 , :B5 , :B4 )
9bmg1119wuqm7DELETE MAILBOXITEM WHERE (SUBMESSAGEID, SUBMESSAGESYSTEMID) IN ( SELECT SUBMESSAGEID, SUBMESSAGESYSTEMID FROM SUBMESSAGERETENTION WHERE EXPIRATIONTIMESTAMP < :B1 AND SUBMESSAGERETENTION.HOLD = 0 )
9pwyz2pm98vxxBEGIN p_retention.updateMessageRetention(:1, :2, :3, :4, :5); END;
9utsq4swwsmzdSELECT SMRP.SUBMESSAGEID, SMRP.SUBMESSAGESYSTEMID, SMRP.RETENTIONPOLICYID, SMRP.RETENTIONPOLICYSYSTEMID, RP.CODE, RP.DESCRIPTION, SMRP.POLICYTYPE, SMRP.DAYS, SMRP.MONTHS, SMRP.YEARS, SMRP.SENTTIMESTAMP, SMRP.LASTACCESSTIMESTAMP, SMRP.REPLYFORWARDTIMESTAMP, SMRP.EXPIRATIONTIMESTAMP, SMRP.HOLD RETENTIONHOLD FROM SUBMESSAGERETENTION SMRP, RETENTIONPOLICY RP WHERE SMRP.SUBMESSAGEID = :B2 AND SMRP.SUBMESSAGESYSTEMID = :B1 AND SMRP.RETENTIONPOLICYID = RP.ID AND SMRP.RETENTIONPOLICYSYSTEMID = RP.SYSTEMID
9ztc2usu3fmj5SELECT P.ID ID, P.SYSTEMID SYSTEMID, A.TYPED_NAME TYPEDNAME, P.TYPE POPULATIONTYPE, P.DISPLAYNAME1 DISPLAYNAME, P.SMTPADDRESS SMTPADDRESS FROM POPULATION P, COMPLIANCE_DETAILS C, TABLE(CAST(:B1 AS RECIPIENT_INFO_LIST)) A WHERE C.OWNERID = :B3 AND C.OWNERSYSTEMID = :B2 AND P.STATUS <> 'R' AND C.TARGETID = P.ID AND C.TARGETSYSTEMID = P.SYSTEMID AND UPPER(P.DISPLAYNAME1) LIKE UPPER(NVL(A.DISPLAY_NAME, P.DISPLAYNAME1) || '%') AND UPPER(P.SMTPADDRESS) = NVL(UPPER(A.SMTPADDRESS), UPPER(P.SMTPADDRESS))
apgdwp5n2wdugSELECT T1.RN, T1.SUBMESSAGEID AS SUBMESSAGEID, T1.SUBMESSAGESYSTEMID AS SUBMESSAGESYSTEMID, T1.TYPE, T1.REPLYDATE AS REPLYDATE, T1.FORWARDDATE AS FORWARDDATE, T1.READDATE AS READDATE, NVL(T1.FLAG, 0) AS FLAG, T1.PRIORITY AS PRIORITY, T1.SENSITIVITY AS SENSITIVITY, T1.CONTAINSATTACHMENTS AS CONTAINSATTACHMENTS, T1.DISPLAYNAME1 AS ADDRESSDISPLAYNAME1, T1.SMTPADDRESS AS SMTPADDRESS, T1.SUBJECT AS SUBJECT, T1.DELIVERYDATE AS DELIVERYDATE, T1.PV AS PV, T1.HASCUSTOMDATA AS HASCUSTOMDATA FROM TABLE(P_MAILBOX_CONTENTS.GETRECEIVEDITEMSSET( :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 )) T1 ORDER BY RN
avc1jqzz04wprSELECT 'x' FROM DUAL
b6qv8f7zwqz0dbegin :1 := JAVA_XA.xa_commit_new (:2, :3, :4, :5); end;
bnk1g42zxuk5ubegin :1 := JAVA_XA.xa_start_new(:2, :3, :4, :5, :6); end;
butrzvwc2ckccSELECT SUBMESSAGE.CS AS CHECKSUM, MAILBOXITEM.MAILTYPE, MAILBOXITEM.TRASHEDTIMESTAMP, MAILBOXITEM.DELETEDTIMESTAMP, MAILBOXITEM.FLAG, MAILBOXITEM.CONTAINSATTACHMENTS AS CONTAINSATTACHMENTS, MAILBOXITEM.HISTORYID, MAILBOX.NAME AS MAILBOXNAME FROM MAILBOXITEM, MAILBOX, SUBMESSAGE WHERE MAILBOXITEM.MAILBOXID = :B1 AND MAILBOXITEM.SUBMESSAGEID = :B3 AND MAILBOXITEM.SUBMESSAGESYSTEMID = :B2 AND SUBMESSAGE.ID = MAILBOXITEM.SUBMESSAGEID AND SUBMESSAGE.SYSTEMID = MAILBOXITEM.SUBMESSAGESYSTEMID AND MAILBOX.ID = :B1
ch6ygprzxubjrUPDATE MAILBOXITEM SET LASTMODIFIEDTIMESTAMP = :B5 , READDATE = NVL(READDATE, :B5 ), LASTREADDATE = :B5 WHERE SUBMESSAGEID = :B4 AND SUBMESSAGESYSTEMID = :B3 AND OWNERID = :B2 AND OWNERSYSTEMID = :B1
cz0d2rv3hsxa2INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(:1, :2, :3, :4, :5)
d0mzzx77304yzINSERT INTO SUBMESSAGE (ID, SYSTEMID, CREATIONTIMESTAMP, CREATIONTYPE, SENDERID, SENDERSYSTEMID, CS, CSWWS, CST, MESSAGEID, MESSAGESYSTEMID, PV, PRIORITY, SENSITIVITY, TYPE, STATUS, SUBJECT, SORTSUBJECT, HASCUSTOMDATA, SIGNATUREID, EXTERNALID) VALUES ( :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , P_SUBMESSAGE.GETSUBJECTFORSORT (:B4 ), :B3 , :B2 , :B1 )
d6xwurybd1sc1BEGIN :1 := p_audit.addAuditEntry(:2, :3, :4, :5, :6, :7, :8, :9); END;
danx7unqfwhw8UPDATE JMS_MESSAGES SET TXID=:1, TXOP=:2 WHERE MESSAGEID=:3 AND DESTINATION=:4
dgc3kfn6agh0zBEGIN p_mailboxitem.manageMailboxItem(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14); END;
dmvgk7gcc8m1tINSERT INTO RECIPIENT SELECT :B2 , :B1 , DRAFTRECIPIENTS.SEQUENCENR, POPULATION.TYPE, DRAFTRECIPIENTS.ID, DRAFTRECIPIENTS.SYSTEMID, DRAFTRECIPIENTS.LISTTYPE FROM DRAFTRECIPIENTS , POPULATION WHERE POPULATION.ID=DRAFTRECIPIENTS.ID AND POPULATION.SYSTEMID = DRAFTRECIPIENTS.SYSTEMID AND DRAFTRECIPIENTS.SUBMESSAGEID = :B2 AND DRAFTRECIPIENTS.SUBMESSAGESYSTEMID = :B1
fb9bdkw7ku1wsSELECT SUBMESSAGEHISTORY.SUBMESSAGEID ID, SUBMESSAGEHISTORY.SUBMESSAGESYSTEMID SYSTEMID, SUBMESSAGE.SENDERID, SUBMESSAGE.SENDERSYSTEMID, POPULATION.DISPLAYNAME1, POPULATION.SMTPADDRESS, POPULATION.TYPE AS SENDERTYPE, SUBMESSAGE.CREATIONTIMESTAMP, SUBMESSAGE.SUBJECT, SUBMESSAGEHISTORY.CHECKED, SUBMESSAGE.PV AS PERMISSIONVECTOR FROM MAILBOXITEM, SUBMESSAGEHISTORY, SUBMESSAGE, POPULATION WHERE MAILBOXITEM.MAILBOXID = :B3 AND MAILBOXITEM.SUBMESSAGEID = :B2 AND MAILBOXITEM.SUBMESSAGESYSTEMID = :B1 AND MAILBOXITEM.HISTORYID = SUBMESSAGEHISTORY.HISTORYID AND SUBMESSAGEHISTORY.SUBMESSAGEID = SUBMESSAGE.ID(+) AND SUBMESSAGEHISTORY.SUBMESSAGESYSTEMID = SUBMESSAGE.SYSTEMID(+) AND SUBMESSAGE.SENDERID = POPULATION.ID(+) AND SUBMESSAGE.SENDERSYSTEMID = POPULATION.SYSTEMID(+) ORDER BY SUBMESSAGE.CREATIONTIMESTAMP DESC
fmw713zqmuzzzINSERT INTO COMPLIANCE_DETAILS (OWNERID, OWNERSYSTEMID, TARGETID, TARGETSYSTEMID) VALUES (:B4 , :B3 , :B1 , :B2 )
fnpgu5z2728vuSELECT TO_CHAR(SEQ_MAILBOXITEM.NEXTVAL) FROM DUAL
fqsda57xpqq15DELETE FROM JMS_MESSAGES WHERE TXID=:1 AND TXOP=:2
gmc1a22nkcumpSELECT ID, NAME, OWNERID, OWNERSYSTEMID, MBTYPE, ITEMSTYPE, MBPARENT, P_MAILBOX.GETITEMSCOUNT(ID, :B2 , :B1 ), P_MAILBOX.GETUNREADITEMSCOUNT(ID, :B2 , :B1 ), DESCRIPTION FROM MAILBOX WHERE ID = :B3 AND OWNERID = :B2 AND OWNERSYSTEMID = :B1
gvt7aq1y5uvp4SELECT ALL_RESULTS.ID, ALL_RESULTS.SYSTEMID, ALL_RESULTS.DISPLAYNAME1 DISPLAYNAME, ALL_RESULTS.TYPE, ALL_RESULTS.SMTPADDRESS, ROWNUM RN FROM (SELECT DISTINCT * FROM (SELECT RECIPIENT.ID ID, RECIPIENT.SYSTEMID SYSTEMID , POPULATION.DISPLAYNAME1 DISPLAYNAME1, POPULATION.TYPE TYPE, POPULATION.SMTPADDRESS SMTPADDRESS FROM SUBMESSAGE, RECIPIENT, POPULATION WHERE SUBMESSAGE.SENDERID = :B2 AND SUBMESSAGE.SENDERSYSTEMID = :B1 AND SUBMESSAGE.ID = RECIPIENT.SUBMESSAGEID AND SUBMESSAGE.SYSTEMID = RECIPIENT.SUBMESSAGESYSTEMID AND RECIPIENT.ID = POPULATION.ID AND RECIPIENT.SYSTEMID = POPULATION.SYSTEMID AND POPULATION.STATUS != 'R' ORDER BY SUBMESSAGE.CREATIONTIMESTAMP DESC) ) ALL_RESULTS WHERE ROWNUM <= :B3
gwca9akskcaq9DELETE FROM DRAFTRECIPIENTS WHERE SUBMESSAGEID = :B2 AND SUBMESSAGESYSTEMID = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 284,470 39.29 0.98
CPU used when call started 283,045 39.10 0.98
CR blocks created 216,723 29.94 0.75
Cached Commit SCN referenced 560 0.08 0.00
Commit SCN cached 1 0.00 0.00
DB time 2,432,968 336.06 8.42
DBWR checkpoint buffers written 151,871 20.98 0.53
DBWR checkpoints 9 0.00 0.00
DBWR fusion writes 38,155 5.27 0.13
DBWR thread checkpoint buffers written 7,391 1.02 0.03
DBWR transaction table writes 1,366 0.19 0.00
DBWR undo block writes 93,540 12.92 0.32
DFO trees parallelized 49 0.01 0.00
PX local messages recv'd 197 0.03 0.00
PX local messages sent 197 0.03 0.00
PX remote messages recv'd 12,729 1.76 0.04
PX remote messages sent 7,937 1.10 0.03
Parallel operations not downgraded 49 0.01 0.00
RowCR - row contention 2,764 0.38 0.01
RowCR attempts 173,792 24.01 0.60
RowCR hits 176,570 24.39 0.61
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 67 0.01 0.00
SQL*Net roundtrips to/from client 3,116,796 430.52 10.79
active txn count during cleanout 383,803 53.01 1.33
application wait time 129,238 17.85 0.45
background checkpoints completed 8 0.00 0.00
background checkpoints started 9 0.00 0.00
background timeouts 39,922 5.51 0.14
branch node splits 9 0.00 0.00
buffer is not pinned count 135,053,739 18,654.73 467.38
buffer is pinned count 137,252,356 18,958.42 474.99
bytes received via SQL*Net from client 2,003,492,451 276,738.85 6,933.51
bytes sent via SQL*Net to client 2,019,514,688 278,951.98 6,988.96
calls to get snapshot scn: kcmgss 5,120,132 707.23 17.72
calls to kcmgas 1,598,366 220.78 5.53
calls to kcmgcs 47,160 6.51 0.16
change write time 5,667 0.78 0.02
cleanout - number of ktugct calls 343,368 47.43 1.19
cleanouts and rollbacks - consistent read gets 190,406 26.30 0.66
cleanouts only - consistent read gets 27,653 3.82 0.10
cluster key scan block gets 21,596 2.98 0.07
cluster key scans 6,450 0.89 0.02
cluster wait time 251,581 34.75 0.87
commit batch/immediate performed 155 0.02 0.00
commit batch/immediate requested 155 0.02 0.00
commit cleanout failures: block lost 34,046 4.70 0.12
commit cleanout failures: buffer being written 3 0.00 0.00
commit cleanout failures: callback failure 971 0.13 0.00
commit cleanout failures: cannot pin 4,169 0.58 0.01
commit cleanouts 1,353,860 187.01 4.69
commit cleanouts successfully completed 1,314,671 181.59 4.55
commit immediate performed 155 0.02 0.00
commit immediate requested 155 0.02 0.00
commit txn count during cleanout 159,516 22.03 0.55
concurrency wait time 4,857 0.67 0.02
consistent changes 517,184 71.44 1.79
consistent gets 228,480,184 31,559.56 790.70
consistent gets - examination 101,179,373 13,975.73 350.15
consistent gets direct 183,746 25.38 0.64
consistent gets from cache 228,025,719 31,496.79 789.13
current blocks converted for CR 11 0.00 0.00
cursor authentications 1,248 0.17 0.00
data blocks consistent reads - undo records applied 351,852 48.60 1.22
db block changes 9,801,040 1,353.80 33.92
db block gets 15,742,735 2,174.52 54.48
db block gets direct 52,298 7.22 0.18
db block gets from cache 15,690,437 2,167.29 54.30
deferred (CURRENT) block cleanout applications 351,684 48.58 1.22
dirty buffers inspected 12 0.00 0.00
enqueue conversions 1,572,106 217.15 5.44
enqueue releases 5,683,896 785.11 19.67
enqueue requests 5,685,360 785.31 19.68
enqueue timeouts 1,464 0.20 0.01
enqueue waits 56,679 7.83 0.20
exchange deadlocks 9,405 1.30 0.03
execute count 5,782,730 798.76 20.01
flashback log writes 30,096 4.16 0.10
free buffer inspected 773,432 106.83 2.68
free buffer requested 2,875,404 397.17 9.95
gc CPU used by this session 39,645 5.48 0.14
gc cr block build time 1,081 0.15 0.00
gc cr block flush time 11,261 1.56 0.04
gc cr block receive time 34,178 4.72 0.12
gc cr block send time 2,062 0.28 0.01
gc cr blocks received 412,070 56.92 1.43
gc cr blocks served 416,767 57.57 1.44
gc current block flush time 20,977 2.90 0.07
gc current block pin time 24,066 3.32 0.08
gc current block receive time 79,649 11.00 0.28
gc current block send time 1,848 0.26 0.01
gc current blocks received 371,975 51.38 1.29
gc current blocks served 398,072 54.98 1.38
gc local grants 397,505 54.91 1.38
gc remote grants 329,366 45.49 1.14
gcs messages sent 2,669,600 368.75 9.24
ges messages sent 145,795 20.14 0.50
global enqueue get time 183,018 25.28 0.63
global enqueue gets async 26,324 3.64 0.09
global enqueue gets sync 1,092,065 150.84 3.78
global enqueue releases 1,093,060 150.98 3.78
heap block compress 44,062 6.09 0.15
hot buffers moved to head of LRU 109,116 15.07 0.38
immediate (CR) block cleanout applications 218,067 30.12 0.75
immediate (CURRENT) block cleanout applications 271,981 37.57 0.94
index crx upgrade (found) 1 0.00 0.00
index crx upgrade (positioned) 20,781 2.87 0.07
index fast full scans (full) 786 0.11 0.00
index fetch by key 33,758,009 4,662.93 116.83
index scans kdiixs1 14,194,040 1,960.60 49.12
leaf node 90-10 splits 542 0.07 0.00
leaf node splits 1,843 0.25 0.01
lob reads 48,113 6.65 0.17
lob writes 103,163 14.25 0.36
lob writes unaligned 74,286 10.26 0.26
logons cumulative 4,283 0.59 0.01
messages received 596,512 82.40 2.06
messages sent 596,384 82.38 2.06
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 125,267,418 17,302.97 433.51
opened cursors cumulative 2,905,735 401.36 10.06
parse count (failures) 435 0.06 0.00
parse count (hard) 2,767 0.38 0.01
parse count (total) 2,890,465 399.25 10.00
parse time cpu 8,127 1.12 0.03
parse time elapsed 8,343 1.15 0.03
physical read IO requests 408,866 56.48 1.41
physical read bytes 7,438,778,368 1,027,505.25 25,743.46
physical read total IO requests 431,946 59.66 1.49
physical read total bytes 10,137,357,312 1,400,255.17 35,082.46
physical read total multi block requests 50,893 7.03 0.18
physical reads 908,054 125.43 3.14
physical reads cache 686,354 94.80 2.38
physical reads cache prefetch 526,862 72.77 1.82
physical reads direct 221,700 30.62 0.77
physical reads direct (lob) 169,446 23.41 0.59
physical reads direct temporary tablespace 0 0.00 0.00
physical reads for flashback new 71,560 9.88 0.25
physical reads prefetch warmup 176,284 24.35 0.61
physical write IO requests 131,441 18.16 0.45
physical write bytes 1,956,659,200 270,269.86 6,771.43
physical write total IO requests 551,206 76.14 1.91
physical write total bytes 10,165,300,736 1,404,114.94 35,179.16
physical write total multi block requests 338,189 46.71 1.17
physical writes 238,850 32.99 0.83
physical writes direct 52,408 7.24 0.18
physical writes direct (lob) 52,266 7.22 0.18
physical writes from cache 186,442 25.75 0.65
physical writes non checkpoint 189,504 26.18 0.66
pinned buffers inspected 1,782 0.25 0.01
prefetch warmup blocks aged out before use 11,537 1.59 0.04
prefetched blocks aged out before use 8 0.00 0.00
process last non-idle time 6,987 0.97 0.02
queries parallelized 49 0.01 0.00
recursive calls 10,602,099 1,464.45 36.69
recursive cpu usage 111,265 15.37 0.39
redo blocks written 4,192,761 579.14 14.51
redo buffer allocation retries 42 0.01 0.00
redo entries 5,291,097 730.85 18.31
redo log space requests 46 0.01 0.00
redo log space wait time 172 0.02 0.00
redo ordering marks 77,549 10.71 0.27
redo size 1,969,946,468 272,105.21 6,817.41
redo subscn max counts 30,112 4.16 0.10
redo synch time 59,420 8.21 0.21
redo synch writes 337,280 46.59 1.17
redo wastage 107,308,324 14,822.31 371.36
redo write time 25,309 3.50 0.09
redo writer latching time 12 0.00 0.00
redo writes 360,060 49.73 1.25
rollback changes - undo records applied 644 0.09 0.00
rollbacks only - consistent read gets 19,509 2.69 0.07
rows fetched via callback 33,547,955 4,633.92 116.10
session connect time 0 0.00 0.00
session cursor cache hits 2,320,795 320.57 8.03
session logical reads 244,222,919 33,734.08 845.18
session pga memory 10,175,228,024 1,405,486.18 35,213.52
session pga memory max 19,461,220,472 2,688,143.83 67,349.65
session uga memory ############### 71,810,304.75 1,799,159.30
session uga memory max 1,256,150,168 173,509.79 4,347.17
shared hash latch upgrades - no wait 308,455 42.61 1.07
shared hash latch upgrades - wait 1,236 0.17 0.00
sorts (memory) 586,865 81.06 2.03
sorts (rows) 30,373,922 4,195.50 105.12
sql area evicted 1,027 0.14 0.00
sql area purged 436 0.06 0.00
summed dirty queue length 2 0.00 0.00
switch current to new buffer 144,749 19.99 0.50
table fetch by rowid 101,579,848 14,031.04 351.54
table fetch continued row 14,609 2.02 0.05
table scan blocks gotten 5,708,829 788.55 19.76
table scan rows gotten 123,751,924 17,093.63 428.27
table scans (long tables) 3 0.00 0.00
table scans (short tables) 136,859 18.90 0.47
total number of times SMON posted 162 0.02 0.00
transaction lock background get time 0 0.00 0.00
transaction lock background gets 8 0.00 0.00
transaction lock foreground requests 8 0.00 0.00
transaction rollbacks 155 0.02 0.00
undo change vector size 539,196,612 74,478.27 1,866.00
user I/O wait time 105,171 14.53 0.36
user calls 5,600,678 773.61 19.38
user commits 281,537 38.89 0.97
user rollbacks 7,421 1.03 0.03
workarea executions - optimal 362,057 50.01 1.25
write clones created in foreground 44 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 793 9,964
opened cursors current 126 1,414
logons current 43 97

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 9 4.48

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)
BLUE_M064_CLOB 140,136 19 1.09 1.01 25,611 4 1,029 84.75
BLUE_M004_BLOB 74,885 10 0.70 1.01 30,041 4 1,126 14.46
UNDOTBS2 71,292 10 0.86 1.00 7,755 1 3,055 0.11
BLUE_AUTO_INDX 31,709 4 3.23 3.09 40,114 6 63,964 9.03
BLUE_M001_NTAB 52,831 7 2.70 8.02 7,470 1 115 283.65
BLUE_M008_NTAB 26,831 4 8.58 3.11 14,069 2 2,693 14.53
BLUE_K064_NTAB 8,460 1 0.05 1.01 176 0 12,186 31.97
USERS 683 0 4.76 1.98 3,858 1 424 9.36
SYSAUX 949 0 3.20 2.21 1,009 0 0 0.00
BLUE_M256_NTAB 626 0 10.50 4.07 916 0 11 7.27
SYSTEM 748 0 3.73 1.01 211 0 8 0.00
BLUE_K128_NTAB 24 0 3.75 3.38 178 0 113 4.07
UNDOTBS1 9 0 0.00 1.00 5 0 15,566 3.88
BLUE_K064_BLOB 6 0 0.00 1.00 5 0 0 0.00
BLUE_K512_BLOB 6 0 0.00 1.00 5 0 0 0.00
BLUE_K512_CLOB 6 0 1.67 1.00 5 0 0 0.00
BLUE_M004_CLOB 6 0 1.67 1.00 5 0 0 0.00
BLUE_M064_BLOB 6 0 0.00 1.00 5 0 0 0.00
BLUE_M064_NTAB 6 0 0.00 1.00 5 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
BLUE_AUTO_INDX +DG1/orcl/datafile/blue_auto_indx01.dbf 31,709 4 3.23 3.09 40,114 6 63,964 9.03
BLUE_K064_BLOB +DG1/orcl/datafile/blue_k064_blob01.dbf 6 0 0.00 1.00 5 0 0 0.00
BLUE_K064_NTAB +DG1/orcl/datafile/blue_k064_ntab01.dbf 8,460 1 0.05 1.01 176 0 12,186 31.97
BLUE_K128_NTAB +DG1/orcl/datafile/blue_k128_ntab01.dbf 24 0 3.75 3.38 178 0 113 4.07
BLUE_K512_BLOB +DG1/orcl/datafile/blue_k512_blob01.dbf 6 0 0.00 1.00 5 0 0 0.00
BLUE_K512_CLOB +DG1/orcl/datafile/blue_k512_clob01.dbf 6 0 1.67 1.00 5 0 0 0.00
BLUE_M001_NTAB +DG1/orcl/datafile/blue_m001_ntab01.dbf 52,831 7 2.70 8.02 7,470 1 115 283.65
BLUE_M004_BLOB +DG1/orcl/datafile/blue_m004_blob01.dbf 74,885 10 0.70 1.01 30,041 4 1,126 14.46
BLUE_M004_CLOB +DG1/orcl/datafile/blue_m004_clob01.dbf 6 0 1.67 1.00 5 0 0 0.00
BLUE_M008_NTAB +DG1/orcl/datafile/blue_m008_ntab01.dbf 26,831 4 8.58 3.11 14,069 2 2,693 14.53
BLUE_M064_BLOB +DG1/orcl/datafile/blue_m064_blob01.dbf 6 0 0.00 1.00 5 0 0 0.00
BLUE_M064_CLOB +DG1/orcl/datafile/blue_m064_clob01.dbf 57,076 8 1.08 1.01 10,621 1 598 67.16
BLUE_M064_CLOB +DG1/orcl/datafile/blue_m064_clob02.dbf 65,781 9 1.11 1.00 12,049 2 420 110.19
BLUE_M064_CLOB +DG1/orcl/datafile/blue_m064_clob03.dbf 17,273 2 1.08 1.01 2,936 0 11 70.00
BLUE_M064_CLOB +DG1/orcl/datafile/blue_m064_clob04.dbf 6 0 1.67 1.00 5 0 0 0.00
BLUE_M064_NTAB +DG1/orcl/datafile/blue_m064_ntab01.dbf 6 0 0.00 1.00 5 0 0 0.00
BLUE_M256_NTAB +DG1/orcl/datafile/blue_m256_ntab01.dbf 626 0 10.50 4.07 916 0 11 7.27
SYSAUX +DG1/orcl/datafile/sysaux.257.670607357 949 0 3.20 2.21 1,009 0 0 0.00
SYSTEM +DG1/orcl/datafile/system.256.670607357 748 0 3.73 1.01 211 0 8 0.00
UNDOTBS1 +DG1/orcl/datafile/undotbs1.258.670607357 9 0 0.00 1.00 5 0 15,566 3.88
UNDOTBS2 +DG1/orcl/datafile/undotbs2.264.670607447 71,292 10 0.86 1.00 7,755 1 3,055 0.11
USERS +DG1/orcl/datafile/users.259.670607357 683 0 4.76 1.98 3,858 1 424 9.36

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 662,055 100 243,087,061 686,427 186,445 0 0 100,290


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 19 273 1042 943650 943650    
E 0 33 3765 98012 943650 943650 1475843  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 544 0.10 65,246 19.90 14,187,906
D 1,088 0.20 130,492 7.86 5,604,668
D 1,632 0.30 195,738 2.76 1,970,549
D 2,176 0.39 260,984 1.15 823,042
D 2,720 0.49 326,230 1.02 728,253
D 3,264 0.59 391,476 1.01 716,698
D 3,808 0.69 456,722 1.00 714,883
D 4,352 0.79 521,968 1.00 713,912
D 4,896 0.89 587,214 1.00 713,043
D 5,440 0.99 652,460 1.00 713,017
D 5,520 1.00 662,055 1.00 713,017
D 5,984 1.08 717,706 1.00 712,800
D 6,528 1.18 782,952 1.00 712,557
D 7,072 1.28 848,198 1.00 712,557
D 7,616 1.38 913,444 1.00 712,557
D 8,160 1.48 978,690 1.00 712,557
D 8,704 1.58 1,043,936 1.00 712,557
D 9,248 1.68 1,109,182 1.00 712,557
D 9,792 1.77 1,174,428 1.00 712,557
D 10,336 1.87 1,239,674 1.00 712,557
D 10,880 1.97 1,304,920 1.00 712,557

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 15,508 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 2,048 1,722 307.83 0.00 0.00 0.00 0.00 209,710
E 2,048 1,539 706.90 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 345,375 345,375 0 0
64K 128K 26 26 0 0
256K 512K 4 4 0 0
512K 1024K 16,630 16,630 0 0
1M 2M 11 11 0 0
4M 8M 2 2 0 0
8M 16M 16 16 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
256 0.13 15,519.29 466.68 97.00 123
512 0.25 15,519.29 0.00 100.00 0
1,024 0.50 15,519.29 0.00 100.00 0
1,536 0.75 15,519.29 0.00 100.00 0
2,048 1.00 15,519.29 0.00 100.00 0
2,458 1.20 15,519.29 0.00 100.00 0
2,867 1.40 15,519.29 0.00 100.00 0
3,277 1.60 15,519.29 0.00 100.00 0
3,686 1.80 15,519.29 0.00 100.00 0
4,096 2.00 15,519.29 0.00 100.00 0
6,144 3.00 15,519.29 0.00 100.00 0
8,192 4.00 15,519.29 0.00 100.00 0
12,288 6.00 15,519.29 0.00 100.00 0
16,384 8.00 15,519.29 0.00 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
496 0.79 70 1,982 55,459 0.96 2,362 24.60 7,643,850
560 0.90 131 3,355 55,466 0.96 2,355 24.53 7,645,138
624 1.00 172 5,123 57,725 1.00 96 1.00 7,645,376
688 1.10 175 5,476 57,725 1.00 96 1.00 7,645,381
752 1.21 175 5,476 57,725 1.00 96 1.00 7,645,381
816 1.31 175 5,476 57,725 1.00 96 1.00 7,645,381
880 1.41 175 5,476 57,725 1.00 96 1.00 7,645,381
944 1.51 175 5,476 57,725 1.00 96 1.00 7,645,381
1,008 1.62 175 5,476 57,725 1.00 96 1.00 7,645,381
1,072 1.72 175 5,476 57,725 1.00 96 1.00 7,645,381
1,136 1.82 175 5,476 57,725 1.00 96 1.00 7,645,381
1,200 1.92 175 5,476 57,725 1.00 96 1.00 7,645,381
1,264 2.03 175 5,476 57,725 1.00 96 1.00 7,645,381

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,552 0.25 49,106 14,186,406
3,104 0.50 9,917 822,443
4,656 0.75 9,601 714,727
6,208 1.00 9,596 712,874
7,760 1.25 9,594 712,446
9,312 1.50 9,594 712,446
10,864 1.75 9,594 712,446
12,416 2.00 9,594 712,446

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

Java Pool Size(M)JP 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
16 0.50 6 100 2 1.00 96 1.00 100
32 1.00 6 100 2 1.00 96 1.00 100
48 1.50 6 100 2 1.00 96 1.00 100
64 2.00 6 100 2 1.00 96 1.00 100

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 79,744 1,026 13
1st level bmb 1,295 93 72
undo header 11,863 57 5
2nd level bmb 628 28 45
undo block 6,756 4 1
segment header 2 0 15

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 41,549 40,827 0 39,969 1,325 33.15
HW-Segment High Water Mark 34,764 33,302 1,462 7,761 485 62.52
TX-Transaction (index contention) 719 716 0 626 11 17.99
WF-AWR Flush 43 43 0 11 2 161.00
PS-PX Process Reservation 4,187 4,185 2 3,989 2 0.40
US-Undo Segment 4,815 4,815 0 3,895 1 0.31
CF-Controlfile Transaction 16,711 16,711 0 257 0 0.18
TM-DML 663,743 663,740 0 43 0 0.84
TD-KTF map table enqueue (KTF dump entries) 16 16 0 16 0 1.50
TT-Tablespace 1,301 1,301 0 23 0 0.39
TA-Instance Undo 28 28 0 22 0 0.41
TX-Transaction (allocate ITL entry) 13 13 0 13 0 0.54
TX-Transaction 339,267 339,267 0 9 0 0.67
FL-Flashback database log (Flashback database log) 38 38 0 9 0 0.56
FB-Format Block 22 22 0 8 0 0.63
SQ-Sequence Cache 682 682 0 1 0 5.00
CT-Block Change Tracking (global space management) 5 5 0 5 0 0.60
JS-Job Scheduler (job run lock - synchronize) 4 4 0 4 0 0.50
WL-Being Written Redo Log 9 9 0 5 0 0.20
FD-Flashback Database (Marker generation) 8 8 0 2 0 0.50
IR-Instance Recovery 344 344 0 2 0 0.50
RS-Reclaimable Space (prevent aging list update) 8 8 0 2 0 0.50
DR-Distributed Recovery 7 7 0 6 0 0.00
RS-Reclaimable Space (read alert level) 40 40 0 3 0 0.00
CT-Block Change Tracking (state) 5 5 0 2 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 95.03 342,693 1,138 39 15/33 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
04-Jun 18:06 1,093 4,834 377 12 19 0/0 0/0/0/0/0/0
04-Jun 17:56 20,560 109,328 74 34 15 0/0 0/0/0/0/0/0
04-Jun 17:46 10,560 57,348 131 18 32 0/0 0/0/0/0/0/0
04-Jun 17:36 371 1,093 1,015 2 30 0/0 0/0/0/0/0/0
04-Jun 17:26 3,018 13,213 414 13 20 0/0 0/0/0/0/0/0
04-Jun 17:16 6,589 27,529 631 39 25 0/0 0/0/0/0/0/0
04-Jun 17:06 7,158 30,781 1,138 38 33 0/0 0/0/0/0/0/0
04-Jun 16:56 9,735 40,378 627 18 24 0/0 0/0/0/0/0/0
04-Jun 16:46 7,298 34,660 456 15 33 0/0 0/0/0/0/0/0
04-Jun 16:36 8,292 20,723 771 17 27 0/0 0/0/0/0/0/0
04-Jun 16:26 20,281 2,156 502 14 22 0/0 0/0/0/0/0/0
04-Jun 16:16 17 152 0 3 15 0/0 0/0/0/0/0/0
04-Jun 16:06 59 498 0 3 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 1,476 0.00   0 0  
ASM db client latch 6,698 0.00   0 0  
ASM map headers 541 0.00   0 0  
ASM map load waiting list 155 0.00   0 0  
ASM map operation freelist 2,966 0.10 0.00 0 0  
ASM map operation hash table 2,294,348 0.00 0.00 0 0  
ASM network background latch 3,749 0.00   0 0  
AWR Alerted Metric Element list 49,350 0.00   0 0  
Consistent RBA 360,152 0.00 0.00 0 0  
FAL request queue 163 0.00   0 0  
FAL subheap alocation 163 0.00   0 0  
FIB s.o chain latch 216 0.00   0 0  
FOB s.o list latch 2,707 0.00   0 0  
JOX SGA heap latch 1,308 0.00   0 0  
JS broadcast add buf latch 1,655 0.00   0 0  
JS broadcast drop buf latch 1,655 0.00   0 0  
JS broadcast load blnc latch 1,440 0.00   0 0  
JS mem alloc latch 12 0.00   0 2 0.00
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 60,922 0.00   0 0  
JS slv state obj latch 4 0.00   0 0  
KCL gc element parent latch 11,314,432 0.04 0.03 0 16,223 0.16
KFK SGA context latch 5,064 0.00   0 0  
KFMD SGA 673 0.00   0 0  
KJC destination ctx free list 0     0 2 0.00
KJC message pool free list 602,135 0.03 0.00 0 138,262 0.04
KJC receiver ctx free list 0     0 2 0.00
KJCT flow control latch 3,084,233 0.01 0.01 0 0  
KMG MMAN ready and startup request latch 2,405 0.00   0 0  
KSXR large replies 20 0.00   0 0  
KTF sga latch 31 0.00   0 2,322 0.00
KWQMN job cache list latch 599 0.00   0 0  
MQL Tracking Latch 0     0 144 0.00
Memory Management Latch 0     0 2,405 0.00
Mutex Stats 2 0.00   0 0  
OS process 558 0.00   0 0  
OS process allocation 2,831 0.00   0 0  
OS process: request allocation 410 0.00   0 0  
PL/SQL warning settings 1,636,800 0.00   0 0  
Reserved Space Latch 103 0.00   0 0  
SGA IO buffer pool latch 367 0.00   0 367 0.00
SQL memory manager latch 2 0.00   0 2,405 0.00
SQL memory manager workarea list latch 244,367 0.00 0.00 0 0  
Shared B-Tree 256 0.00   0 0  
active checkpoint queue latch 87,249 0.34 0.00 0 2 0.00
active service list 49,450 0.00 0.00 0 2,671 0.00
alert log latch 0     0 2 0.00
archive control 187 0.00   0 0  
archive process latch 2,568 0.00   0 0  
begin backup scn array 52,116 0.00 0.00 0 0  
business card 98 0.00   0 0  
cache buffer handles 3,451 0.00   0 0  
cache buffers chains 414,537,765 0.07 0.06 1 8,116,918 0.05
cache buffers lru chain 3,873,093 0.17 0.00 0 6,129,002 0.23
cache table scan latch 0     0 23,456 0.00
channel handle pool latch 511 0.00   0 0  
channel operations parent latch 2,113,965 0.00 0.00 0 0  
checkpoint queue latch 1,109,836 0.01 0.01 0 433,432 0.01
client/application info 22,761 0.00   0 0  
commit callback allocation 82 0.00   0 0  
compile environment latch 468,346 0.00   0 0  
dml lock allocation 1,327,614 0.09 0.00 0 0  
dummy allocation 8,514 0.00   0 0  
enqueue hash chains 14,485,176 0.29 0.00 0 3,945 0.13
enqueues 9,826,389 0.54 0.00 0 0  
error message lists 221 0.00   0 0  
event group latch 232 0.00   0 0  
event range base latch 39 0.00   0 0  
file cache latch 1,943 0.00   0 0  
flashback FBA barrier 4 0.00   0 0  
flashback SCN barrier 8 0.00   0 0  
flashback allocation 256,585 0.02 0.00 0 0  
flashback copy 0     0 186,792 0.13
flashback hint SCN barrier 4 0.00   0 0  
flashback mapping 30,021 0.00   0 0  
flashback sync request 130,989 0.02 0.00 0 0  
gcs drop object freelist 2,016 0.10 0.00 0 0  
gcs opaque info freelist 812,782 0.03 0.00 0 0  
gcs partitioned table hash 14,891,524 0.00   0 0  
gcs remaster request queue 16 0.00   0 0  
gcs remastering latch 1,731,846 0.00 2.40 0 0  
gcs resource freelist 936,101 0.10 0.00 0 104,002 0.01
gcs resource hash 6,912,467 0.07 0.01 0 2,279 0.04
gcs resource scan list 4,559 0.00   0 0  
gcs shadows freelist 459,793 0.00   0 533,420 0.00
ges caches resource lists 514,559 0.02 0.00 0 126,443 0.05
ges deadlock list 1,376 0.00   0 0  
ges domain table 2,044,550 0.00 0.00 0 0  
ges enqueue table freelist 2,189,978 0.03 0.00 0 0  
ges group table 2,978,149 0.02 0.01 0 0  
ges process hash list 21,429 0.00   0 0  
ges process parent latch 4,504,674 0.00   0 0  
ges process table freelist 410 0.00   0 0  
ges resource hash list 2,805,380 0.40 0.01 0 127,340 0.09
ges resource scan list 46,668 0.00 0.00 0 0  
ges resource table freelist 69,860 0.00 0.00 0 20 0.00
ges synchronous data 128 4.69 0.00 0 41,685 0.02
ges timeout list 112,544 0.01 0.00 0 67,742 0.01
global KZLD latch for mem in SGA 216 0.00   0 0  
global tx hash mapping 5,550,814 0.00 0.00 0 4 0.00
hash table column usage latch 1,200 0.00   0 235,454 0.00
hash table modification latch 175 0.00   0 2 0.00
hint flashback FBA barrier 4 0.00   0 0  
job workq parent latch 0     0 250 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 245 0.00   0 0  
kks stats 11,276 0.00   0 0  
ksuosstats global area 487 0.00   0 0  
ksv instance 2 0.00   0 0  
ktm global data 296 0.00   0 0  
kwqbsn:qsga 256 0.00   0 0  
lgwr LWN SCN 376,876 0.00 0.00 0 0  
library cache 16,028,924 0.24 0.00 0 13,619 0.16
library cache load lock 5,311 0.02 0.00 0 0  
library cache lock 4,442,234 0.02 0.00 0 0  
library cache lock allocation 20,881 0.00   0 0  
library cache pin 7,514,374 0.05 0.00 0 0  
library cache pin allocation 3,493 0.00   0 0  
list of block allocation 4,829 0.00   0 0  
loader state object freelist 324,926 0.01 0.00 0 0  
longop free list parent 3 0.00   0 3 0.00
message pool operations parent latch 25,131 0.00   0 0  
messages 2,078,853 0.09 0.00 0 0  
mostly latch-free SCN 382,201 0.13 0.00 0 0  
msg queue 264 0.00   0 264 0.00
multiblock read objects 925,024 0.04 0.00 0 2 0.00
name-service memory objects 61,598 0.00   0 4 0.00
name-service namespace bucket 85,301 0.00   0 0  
name-service namespace objects 0     0 2 0.00
name-service pending queue 31,698 0.00   0 0  
name-service request queue 105,990 0.00   0 0  
ncodef allocation latch 128 0.00   0 0  
object queue header heap 88,513 0.00   0 791 0.00
object queue header operation 6,114,763 0.02 0.10 0 0  
object stats modification 273 0.00   0 4 0.00
parallel query alloc buffer 32,868 0.00   0 0  
parallel query stats 4,074 0.00   0 0  
parallel txn reco latch 4,732 0.00   0 0  
parameter list 2,874 0.00   0 0  
parameter table allocation management 7,604 0.00   0 0  
post/wait queue 1,009,406 0.07 0.00 0 481,457 0.03
process allocation 53,890 0.00 0.00 0 232 0.00
process group creation 410 0.00   0 0  
process queue 12,113 0.00   0 0  
process queue reference 237,152 0.00   0 21,078 0.00
qmn task queue latch 1,024 0.00   0 0  
query server freelists 8,173 0.00   0 0  
queued dump request 34,335 0.00   0 0  
redo allocation 1,140,889 0.30 0.00 0 5,284,028 0.41
redo copy 64 0.00   0 5,291,284 0.14
redo writing 1,193,014 0.03 0.00 0 0  
reservation so alloc latch 56 0.00   0 0  
resmgr group change latch 8,659 0.00   0 0  
resmgr:actses active list 8,997 0.00   0 0  
resmgr:actses change group 5,254 0.00   0 0  
resmgr:free threads list 8,506 0.00   0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 8,136,228 0.10 0.00 0 6,788 0.09
rules engine aggregate statistics 41 0.00   0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 82 0.00   0 0  
segmented array pool 140 0.00   0 0  
sequence cache 281,251 0.05 0.00 0 0  
session allocation 1,575,739 0.06 0.00 0 0  
session idle bit 11,666,324 0.02 0.01 0 0  
session state list latch 8,432 0.00   0 0  
session switching 128 0.00   0 0  
session timer 2,671 0.00   0 0  
shared pool 3,073,939 0.12 0.01 0 0  
shared pool sim alloc 123 0.00   0 0  
shared pool simulator 1,266,225 0.00 0.00 0 0  
simulator hash latch 15,864,055 0.00 0.00 0 0  
simulator lru latch 15,607,140 0.26 0.00 0 148,515 0.02
slave class 796 0.00   0 2 0.00
slave class create 562 0.36 1.00 0 0  
sort extent pool 916 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 336 0.00   0 0  
temp lob duration state obj allocation 100 0.00   0 0  
threshold alerts latch 1,139 0.00   0 0  
trace latch 64 0.00   0 0  
transaction allocation 1,473 0.00   0 0  
transaction branch allocation 5,210,905 0.23 0.00 0 0  
undo global data 6,665,033 0.04 0.00 0 2 0.00
user lock 1,000 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 414,537,765 279,656 16,091 264,193 0 0 0
enqueues 9,826,389 53,017 110 52,908 0 0 0
enqueue hash chains 14,485,176 41,671 93 41,578 0 0 0
simulator lru latch 15,607,140 40,274 52 40,222 0 0 0
library cache 16,028,924 38,494 42 38,452 0 0 0
transaction branch allocation 5,210,905 12,197 21 12,176 0 0 0
ges resource hash list 2,805,380 11,296 125 11,171 0 0 0
row cache objects 8,136,228 8,543 4 8,539 0 0 0
cache buffers lru chain 3,873,093 6,468 17 6,452 0 0 0
gcs resource hash 6,912,467 4,993 27 4,966 0 0 0
KCL gc element parent latch 11,314,432 4,317 144 4,177 0 0 0
library cache pin 7,514,374 3,698 10 3,688 0 0 0
shared pool 3,073,939 3,570 21 3,549 0 0 0
redo allocation 1,140,889 3,411 14 3,397 0 0 0
session idle bit 11,666,324 2,586 14 2,573 0 0 0
undo global data 6,665,033 2,445 8 2,437 0 0 0
messages 2,078,853 1,825 1 1,824 0 0 0
object queue header operation 6,114,763 1,433 149 1,296 0 0 0
dml lock allocation 1,327,614 1,236 2 1,234 0 0 0
library cache lock 4,442,234 867 2 865 0 0 0
ges enqueue table freelist 2,189,978 707 1 706 0 0 0
ges group table 2,978,149 565 4 561 0 0 0
KJCT flow control latch 3,084,233 384 4 382 0 0 0
checkpoint queue latch 1,109,836 123 1 122 0 0 0
gcs remastering latch 1,731,846 5 12 3 0 0 0
slave class create 562 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclbla 0 334 1
KCL gc element parent latch kclnfndnewm 0 34 162
KCL gc element parent latch kclpto_3 0 18 7
KCL gc element parent latch kclgcr 0 17 1
KCL gc element parent latch kclpto 0 17 6
KCL gc element parent latch kclliter 0 16 1
KCL gc element parent latch kclchkping 0 14 1
KCL gc element parent latch kcldrop 0 8 0
KCL gc element parent latch kclpdc_3 0 6 2
KCL gc element parent latch kclplz 0 6 2
KCL gc element parent latch KCLUNLNK 0 5 161
KCL gc element parent latch kclfwrite1 0 4 3
KCL gc element parent latch kclnfnd 0 3 3
KCL gc element parent latch kclulb 0 3 108
KCL gc element parent latch kclexpand 0 2 0
KCL gc element parent latch kclgrantlk 0 2 1
KCL gc element parent latch kclrwrite 0 2 4
KJCT flow control latch kjctcsnd: send normal message 0 2 0
KJCT flow control latch kjcts_sqenq: queue a message 0 2 2
cache buffers chains kcbgtcr: kslbegin excl 0 12,299 3,116
cache buffers chains kcbzwb 0 10,487 5,484
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 7,673 8,879
cache buffers chains kcbget: pin buffer 0 4,221 3,413
cache buffers chains kcbgcur: kslbegin 0 2,127 1,465
cache buffers chains kcbgtcr: fast path 0 1,405 1,182
cache buffers chains kcbrls: kslbegin 0 442 9,980
cache buffers chains kcbgtcr: kslbegin shared 0 174 146
cache buffers chains kcbchg: kslbegin: call CR func 0 163 4,474
cache buffers chains kclbla 0 110 29
cache buffers chains kcbget: exchange rls 0 55 37
cache buffers chains kcbget: exchange 0 45 52
cache buffers chains kclwcrs 0 43 10
cache buffers chains kcbsod1 0 42 240
cache buffers chains kclpto 0 25 0
cache buffers chains kcbso1: set no access 0 21 11
cache buffers chains kcbgcur: buf pinned 0 18 14
cache buffers chains kcbzgb: scan from tail. nowait 0 18 0
cache buffers chains kcbcge 0 16 452
cache buffers chains kcbnlc 0 14 140
cache buffers chains kcbgtcr 0 13 8
cache buffers chains kcbzib: multi-block read: nowait 0 11 0
cache buffers chains kclfpdb 0 11 0
cache buffers chains kclebs_1 0 9 2
cache buffers chains kcbesc: escalate 0 8 5
cache buffers chains kclwrt 0 8 1
cache buffers chains kcbzib: finish free bufs 0 6 58
cache buffers chains kclpto_1 0 5 41
cache buffers chains kclwlr 0 4 8
cache buffers chains kcbgkcbcr 0 3 54
cache buffers chains kclpred 0 3 0
cache buffers chains kcbzib: exchange rls 0 2 1
cache buffers chains kclcsr 0 2 47
cache buffers chains kclcsr_1 0 2 0
cache buffers chains kclfpdb_2 0 2 4
cache buffers chains kcbbic1 0 1 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kclfbst_1 0 1 3
cache buffers chains kcllwr 0 1 0
cache buffers chains kclpdc_4 0 1 10
cache buffers lru chain kcbzgws 0 5 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 3 0
cache buffers lru chain kcbzib 0 3 0
cache buffers lru chain kcbrenounce 0 1 0
cache buffers lru chain kcbz_decr_wspwbcnt 0 1 2
cache buffers lru chain kcbzfw 0 1 1
cache buffers lru chain kcbzgb: posted for free bufs 0 1 9
cache buffers lru chain kcbzgm 0 1 0
cache buffers lru chain kclmergepi 0 1 0
checkpoint queue latch kcbswcu: Switch buffers 0 1 0
dml lock allocation ktaiam 0 2 2
enqueue hash chains ksqrcl 0 36 21
enqueue hash chains ksqcmi: if lk mode not requested 0 30 28
enqueue hash chains ksqcmi: if lk mode requested 0 11 26
enqueue hash chains ksqgtl3 0 11 16
enqueue hash chains ksqexpandres 0 3 0
enqueue hash chains ksqcnl 0 2 2
enqueues ksqgel: create enqueue 0 58 49
enqueues ksqdel 0 48 50
enqueues ksqies 0 4 11
gcs remastering latch 59 0 10 0
gcs remastering latch 43 0 1 0
gcs remastering latch 69 0 1 0
gcs resource hash kjbcrcomplete 0 19 0
gcs resource hash kjbassume 0 7 4
gcs resource hash kjbconvert 0 1 2
ges enqueue table freelist kjlfr: remove lock from parent object 0 1 0
ges group table kjgagll: move a lock from process lock list to group lock list 0 2 2
ges group table kjgdgll: move a lock from group lock list to process lock list 0 2 2
ges resource hash list kjlrlr: remove lock from resource queue 0 94 94
ges resource hash list kjrmas1: lookup master node 0 16 2
ges resource hash list kjrref: find matched resource 0 7 22
ges resource hash list kjucvl: lock convert request 0 6 6
ges resource hash list kjakcai: search for resp by resname 0 1 1
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
library cache kglpndl: child: after processing 0 18 1
library cache kglobpn: child: 0 12 5
library cache kglpnp: child 0 6 15
library cache kglpndl: child: before processing 0 3 13
library cache kgldte: child 0 0 2 4
library cache lock kgllkal: child: multiinstance 0 2 1
library cache lock kgllkdl: child: no lock handle 0 1 0
library cache pin kglpndl 0 7 6
library cache pin kglpnp: child 0 3 4
messages ksarcv: after wait 0 1 0
object queue header operation kclobj_1 0 166 54
object queue header operation kclobj_3 0 44 0
object queue header operation kcbw_unlink_q 0 8 58
object queue header operation kcbw_link_q 0 5 75
object queue header operation kcbo_switch_cq 0 3 29
object queue header operation kcbo_switch_mq_bg 0 3 2
object queue header operation kcbw_unlink_q_bg 0 1 8
redo allocation kcrfw_redo_gen: redo allocation 1 0 13 0
redo allocation kcrfw_redo_gen: redo allocation 2 0 1 0
row cache objects kqreqd: reget 0 2 1
row cache objects kqrpre: find obj 0 2 1
session idle bit ksupuc: set busy 0 10 7
session idle bit ksupuc: clear busy 0 7 10
shared pool kghalo 0 15 2
shared pool kghfre 0 4 8
shared pool kghupr1 0 2 11
simulator lru latch kcbs_simulate: simulate set 0 52 52
slave class create ksvcreate 0 2 0
transaction branch allocation ksupuc 0 10 9
transaction branch allocation ktcsbr 0 5 5
transaction branch allocation ktcbba 0 2 1
transaction branch allocation ktcbod 0 2 2
transaction branch allocation ktcdbr 0 2 4
undo global data ktudba: KSLBEGIN 0 5 7
undo global data kturimugur: child 0 2 0
undo global data ktufrbs: child 0 1 1

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
HEAD BLUE_M001_NTAB MAILBOXITEM   TABLE 52,704,592 21.58
HEAD BLUE_AUTO_INDX JMS_MESSAGES_DESTINATION_IB   INDEX 39,254,240 16.07
HEAD BLUE_AUTO_INDX SUBMESSAGE_ID_SYSID_PK   INDEX 32,104,496 13.15
HEAD BLUE_M008_NTAB SUBMESSAGE   TABLE 28,975,248 11.86
HEAD BLUE_AUTO_INDX RECIPIENT_PK   INDEX 26,912,272 11.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HEAD BLUE_M001_NTAB MAILBOXITEM   TABLE 387,986 42.73
HEAD BLUE_M064_CLOB MESSAGECONTENTS_PLAINBODY   LOB 59,884 6.59
HEAD BLUE_M064_CLOB MESSAGECONTENTS_BODY   LOB 58,252 6.42
HEAD BLUE_M008_NTAB SUBMESSAGE   TABLE 50,482 5.56
HEAD BLUE_M004_BLOB JMS_MESSAGES_MESSAGEBLOB   LOB 46,162 5.08

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HEAD BLUE_AUTO_INDX JMS_MESSAGES_DESTINATION_IB   INDEX 40,547 96.02
HEAD BLUE_M001_NTAB SUBMESSAGERETENTION   TABLE 258 0.61
HEAD BLUE_AUTO_INDX JMS_MESSAGES_TXID_TXOP_I   INDEX 120 0.28
HEAD BLUE_AUTO_INDX MAILBOXITEM_SUBMESSAGE   INDEX 110 0.26
HEAD BLUE_M001_NTAB MAILBOXITEM   TABLE 70 0.17

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HEAD BLUE_AUTO_INDX SUBMESSAGE_MESSAGEID_SYSID_I   INDEX 4 30.77
HEAD BLUE_AUTO_INDX ATTACHMENTTIMESTAMPS_DELDATE_I   INDEX 2 15.38
HEAD BLUE_AUTO_INDX MESSAGECONTENTS_PK   INDEX 2 15.38
HEAD BLUE_AUTO_INDX SUBMESSAGERETENTION_SUBMSID_PK   INDEX 2 15.38
HEAD BLUE_AUTO_INDX RECIPIENT_PK   INDEX 1 7.69

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HEAD BLUE_AUTO_INDX JMS_MESSAGES_DESTINATION_IB   INDEX 41,185 85.35
HEAD BLUE_AUTO_INDX JMS_MESSAGES_TXID_TXOP_I   INDEX 3,541 7.34
HEAD BLUE_K064_NTAB JMS_TRANSACTIONS   TABLE 1,047 2.17
HEAD BLUE_M008_NTAB COMPLIANCE_DETAILS   TABLE 643 1.33
HEAD BLUE_AUTO_INDX JMS_MESSAGES_PK   INDEX 379 0.79

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
HEAD BLUE_K064_NTAB JMS_TRANSACTIONS   TABLE 10,907 32.91
HEAD BLUE_AUTO_INDX JMS_MESSAGES_DESTINATION_IB   INDEX 7,447 22.47
HEAD BLUE_AUTO_INDX JMS_MESSAGES_TXID_TXOP_I   INDEX 5,255 15.86
HEAD BLUE_M008_NTAB ATTACHMTCONTAINMENT_CNT_CNE_PK   INDEX 1,247 3.76
HEAD BLUE_AUTO_INDX SUBMESSAGE_ID_SYSID_PK   INDEX 958 2.89

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
HEAD BLUE_M001_NTAB MAILBOXITEM   TABLE 77,885 18.90
HEAD BLUE_AUTO_INDX MAILBOXITEM_MBID_OWN_DATES   INDEX 28,806 6.99
HEAD BLUE_K064_NTAB JMS_TRANSACTIONS   TABLE 25,065 6.08
HEAD BLUE_AUTO_INDX MAILBOXITEM_MAILBOX_SUBMSG_PK   INDEX 24,492 5.94
HEAD BLUE_M008_NTAB SUBMESSAGE   TABLE 22,917 5.56

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
HEAD BLUE_M001_NTAB MAILBOXITEM   TABLE 54,338 14.61
HEAD BLUE_M008_NTAB SUBMESSAGE   TABLE 45,209 12.15
HEAD BLUE_AUTO_INDX MAILBOXITEM_MBID_OWN_DATES   INDEX 19,323 5.19
HEAD BLUE_AUTO_INDX MAILBOXITEM_MAILBOX_SUBMSG_PK   INDEX 17,126 4.60
HEAD BLUE_AUTO_INDX MAILBOXITEM_MBID_OWNER   INDEX 12,337 3.32

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 136 0.74 0   3 1
dc_files 22 100.00 0   0 0
dc_global_oids 482,175 0.01 0   0 42
dc_histogram_data 71,172 3.63 0   0 1,013
dc_histogram_defs 98,306 4.84 0   0 1,380
dc_object_grants 217 21.66 0   0 2
dc_object_ids 1,015,877 0.09 0   0 453
dc_objects 21,087 4.64 0   1 303
dc_profiles 337 0.00 0   0 1
dc_rollback_segments 232,783 0.00 0   8 171
dc_segments 109,772 1.14 0   9 299
dc_sequences 15,760 50.79 0   15,760 3
dc_tablespaces 63,075 0.01 0   0 20
dc_usernames 2,833 0.14 0   0 7
dc_users 566,413 0.01 0   0 52
outstanding_alerts 532 86.28 0   41 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 7 1 0
dc_files 22 0 22
dc_global_oids 47 0 32
dc_histogram_defs 4,761 0 5,251
dc_object_ids 902 0 945
dc_objects 981 0 1,754
dc_rollback_segments 12 0 0
dc_segments 1,276 7 1,393
dc_sequences 29,860 7,994 9
dc_tablespaces 4 0 5
dc_usernames 4 0 7
dc_users 34 0 37
outstanding_alerts 1,027 433 8

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 2,890 1.35 2,906,415 0.00 16 0
CLUSTER 130 0.00 204 2.94 6 0
INDEX 104 40.38 220 20.00 2 0
JAVA DATA 52 0.00 0   0 0
SQL AREA 2,255 85.19 6,571,507 0.12 1,116 59
TABLE/PROCEDURE 35,023 1.89 3,252,532 0.08 550 0
TRIGGER 102 3.92 399 1.50 2 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 1 41 13 37 0
CLUSTER 204 0 0 0 0
INDEX 220 42 73 42 0
TABLE/PROCEDURE 223,340 612 505 337 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 290.38   6.18 7.32 28 28 47 47
  Freeable 14.31 0.00 0.60 0.55 2   24 24
  JAVA 1.89 1.88 1.89 0.00 2 4 1 1
  SQL 0.93 0.46 0.04 0.04 0 1 23 19
  PL/SQL 0.46 0.24 0.01 0.02 0 0 45 43
E Other 608.32   6.02 5.72 28 28 101 101
  JAVA 50.91 50.82 1.34 0.27 2 2 38 38
  Freeable 40.25 0.00 0.67 0.39 2   60 60
  PL/SQL 3.87 2.29 0.04 0.05 0 0 99 97
  SQL 3.61 1.55 0.05 0.05 0 8 77 58

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 5,788,139,520  
Fixed Size 2,279,080  
Redo Buffers 4,325,376  
Variable Size 714,815,832  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 26.56 26.56 0.00
java joxlod exec hp 5.37 5.37 0.00
large ASM map operations hashta 0.38 0.38 0.00
large CTWR dba buffer 0.51 0.51 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 12.10 12.10 0.00
large krcc extent chunk 1.99 1.99 0.00
shared ASH buffers 15.50 15.50 0.00
shared KCL name table 6.00 6.00 0.00
shared event statistics per sess 9.71 9.71 0.00
shared flashback generation buff 15.04 15.04 0.00
shared free memory 145.73 95.93 -34.17
shared gcs resources 110.18 110.18 0.00
shared gcs shadows 69.40 69.40 0.00
shared ges big msg buffers 15.03 15.03 0.00
shared ges reserved msg buffers 7.86 7.86 0.00
shared library cache 7.95 11.84 49.03
shared row cache 7.16 7.16 0.00
shared sql area 10.31 52.78 411.77
  buffer_cache 5,520.00 5,520.00 0.00
  fixed_sga 2.17 2.17 0.00
  log_buffer 4.13 4.13 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 520,178 734,020 750107 750107
gcs_shadows 606,872 743,578 750107 750107


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/oracle/admin/orcl/adump   
background_dump_dest /u01/oracle/admin/orcl/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +DG1/orcl/controlfile/current.260.670607423   
core_dump_dest /u01/oracle/admin/orcl/cdump   
db_block_size 8192   
db_create_file_dest +DG1   
db_domain      
db_file_multiblock_read_count 16   
db_flashback_retention_target 2880   
db_name orcl   
db_recovery_file_dest +DGFRA   
db_recovery_file_dest_size 322122547200   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
instance_number 2   
job_queue_processes 10   
log_archive_dest_1      
log_archive_dest_10 location=use_db_recovery_file_dest   
open_cursors 300   
pga_aggregate_target 2147483648   
processes 1000   
remote_listener LISTENERS_ORCL   
remote_login_passwordfile EXCLUSIVE   
service_names orcl, orcl_rac   
sessions 1105   
sga_target 6509559808   
spfile +DG1/orcl/spfileorcl.ora   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /u01/oracle/admin/orcl/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 174,812 24.15 0.60
acks for commit broadcast(logical) 215,028 29.70 0.74
broadcast msgs on commit(actual) 358,550 49.53 1.24
broadcast msgs on commit(logical) 360,060 49.73 1.25
broadcast msgs on commit(wasted) 19,179 2.65 0.07
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 17 0.00 0.00
flow control messages sent 10 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 200,847 27.74 0.70
gcs ast xid 54 0.01 0.00
gcs blocked converts 274,304 37.89 0.95
gcs blocked cr converts 381,826 52.74 1.32
gcs compatible basts 346 0.05 0.00
gcs compatible cr basts (global) 26,779 3.70 0.09
gcs compatible cr basts (local) 122,130 16.87 0.42
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 35,219 4.86 0.12
gcs dbwr write request msgs 28,525 3.94 0.10
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 8,876 1.23 0.03
gcs immediate (null) converts 104,182 14.39 0.36
gcs immediate cr (compatible) converts 195 0.03 0.00
gcs immediate cr (null) converts 324,163 44.78 1.12
gcs indirect ast 38,356 5.30 0.13
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 9,273 1.28 0.03
gcs msgs process time(ms) 87,668 12.11 0.30
gcs msgs received 2,523,246 348.53 8.73
gcs out-of-order msgs 15 0.00 0.00
gcs pings refused 465 0.06 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 50 0.01 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 82 0.01 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 337,638 46.64 1.17
gcs side channel msgs actual 6,408 0.89 0.02
gcs side channel msgs logical 842,116 116.32 2.91
gcs stale cr 7 0.00 0.00
gcs undo cr 12,954 1.79 0.04
gcs write notification msgs 3,749 0.52 0.01
gcs writes refused 315 0.04 0.00
ges msgs process time(ms) 2,982 0.41 0.01
ges msgs received 150,961 20.85 0.52
global posts dropped 0 0.00 0.00
global posts queue time 125 0.02 0.00
global posts queued 41 0.01 0.00
global posts requested 41 0.01 0.00
global posts sent 41 0.01 0.00
implicit batch messages received 21,193 2.93 0.07
implicit batch messages sent 36,749 5.08 0.13
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 382,731 52.87 1.32
messages queue sent actual 629,695 86.98 2.18
messages queue sent logical 850,154 117.43 2.94
messages received actual 1,785,893 246.68 6.18
messages received logical 2,674,195 369.38 9.25
messages sent directly 740,784 102.32 2.56
messages sent indirectly 386,365 53.37 1.34
messages sent not implicit batched 592,946 81.90 2.05
messages sent pbatched 1,453,734 200.80 5.03
msgs causing lmd to send msgs 60,769 8.39 0.21
msgs causing lms(s) to send msgs 369,501 51.04 1.28
msgs received queue time (ms) 251,376 34.72 0.87
msgs received queued 2,674,233 369.39 9.25
msgs sent queue time (ms) 45,907 6.34 0.16
msgs sent queue time on ksxp (ms) 651,523 89.99 2.25
msgs sent queued 838,951 115.88 2.90
msgs sent queued on ksxp 1,843,207 254.60 6.38
process batch messages received 743,134 102.65 2.57
process batch messages sent 690,977 95.44 2.39


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 333,043
CURRENT Block Requests 83,767
Data Block Requests 333,043
Undo Block Requests 12,966
TX Block Requests 62,529
Current Results 384,321
Private results 15,969
Zero Results 16,483
Disk Read Results 0
Fail Results 13
Fairness Down Converts 46,152
Fairness Clears 0
Free GC Elements 0
Flushes 53,707
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 165,488
Light Works 24,301
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 398,025 98.33 0.01 1.65 0.00 0.00
Flushes 8,621 60.72 31.48 6.57 1.06 0.17
Writes 38,155 30.60 66.62 0.83 1.22 0.73


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 332,572 85.86 14.14 0.00 337,349 96.40 3.60 0.01
1 undo header 59,366 94.47 5.53 0.00 2,058 92.66 7.34 0.00
1 Others 6,881 97.22 2.78 0.00 32,546 95.27 4.73 0.00
1 undo block 13,262 84.37 15.63 0.00 1 100.00 0.00 0.00


Back to Top

End of Report