WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
GDDSDB2531107962gddsdb1110.2.0.3.0YESgdds1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3607225-May-12 09:00:5341 4.7
End Snap:3609926-May-12 12:00:1675 8.8
Elapsed:  1,619.39 (mins)  
DB Time:  34.08 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,920M 1,920MStd Block Size: 8K
Shared Pool Size: 2,432M 2,432MLog Buffer: 14,376K

Load Profile

Per SecondPer Transaction
Redo size: 1,897.74 1,536.97
Logical reads: 479.18 388.08
Block changes: 10.18 8.25
Physical reads: 3.89 3.15
Physical writes: 0.65 0.53
User calls: 36.44 29.51
Parses: 5.22 4.23
Hard parses: 0.30 0.24
Sorts: 1.99 1.61
Logons: 0.05 0.04
Executes: 8.23 6.67
Transactions: 1.23 

% Blocks changed per Read: 2.13Recursive Call %: 48.62
Rollback per transaction %: 81.26Rows per Sort: 195.78

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.20In-memory Sort %: 100.00
Library Hit %: 94.07Soft Parse %: 94.22
Execute to Parse %: 36.58Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 80.14% Non-Parse CPU: 90.48

Shared Pool Statistics

BeginEnd
Memory Usage %: 14.89 58.80
% SQL with executions>1: 49.34 94.50
% Memory for SQL w/exec>1: 45.57 94.16

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  990  48.4 
control file parallel write 32,207 734 23 35.9System I/O
reliable message 9,163 395 43 19.3Other
control file sequential read 242,622 226 1 11.0System I/O
log file parallel write 22,038 197 9 9.6System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 2.33 1.89
Global Cache blocks served: 0.60 0.49
GCS/GES messages received: 6.43 5.21
GCS/GES messages sent: 9.72 7.87
DBWR Fusion writes: 0.06 0.05
Estd Interconnect traffic (KB) 26.61 

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

Buffer access - local cache %: 98.71
Buffer access - remote cache %: 0.49
Buffer access - disk %: 0.80

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.0
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.8
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.3
Avg global cache cr block flush time (ms): 13.1
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.3
Avg global cache current block flush time (ms): 11.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.2
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.1
% of direct sent messages: 32.56
% of indirect sent messages: 54.45
% of flow controlled messages: 12.99

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 2,045.71 100.04
DB CPU 990.36 48.43
PL/SQL execution elapsed time 635.44 31.08
parse time elapsed 144.45 7.06
hard parse elapsed time 127.46 6.23
PL/SQL compilation elapsed time 4.75 0.23
hard parse (sharing criteria) elapsed time 1.97 0.10
Java execution elapsed time 1.12 0.05
sequence load elapsed time 0.99 0.05
repeated bind elapsed time 0.72 0.04
connection management call elapsed time 0.23 0.01
hard parse (bind mismatch) elapsed time 0.16 0.01
failed parse elapsed time 0.02 0.00
DB time 2,044.81  
background elapsed time 2,824.88  
background cpu time 629.38  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O 297,125 0.00 1,165 4 2.48
Other 1,688,868 89.97 610 0 14.08
User I/O 60,552 0.00 413 7 0.50
Concurrency 76,652 0.00 133 2 0.64
Cluster 337,936 0.00 83 0 2.82
Commit 8,622 0.02 74 9 0.07
Application 19,970 0.00 4 0 0.17
Network 3,660,405 0.00 3 0 30.51
Configuration 199 89.95 0 2 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 32,207 0.00 734 23 0.27
reliable message 9,163 3.26 395 43 0.08
control file sequential read 242,622 0.00 226 1 2.02
log file parallel write 22,038 0.00 197 9 0.18
db file parallel read 9,770 0.00 172 18 0.08
DFS lock handle 14,834 1.62 148 10 0.12
db file scattered read 18,743 0.00 135 7 0.16
os thread startup 1,842 0.00 111 60 0.02
db file sequential read 29,687 0.00 106 4 0.25
log file sync 8,622 0.02 74 9 0.07
gc cr multi block request 230,550 0.00 41 0 1.92
name-service call wait 429 0.00 22 50 0.00
gc cr block 2-way 43,425 0.00 13 0 0.36
CGS wait for IPC msg 936,709 100.00 12 0 7.81
gc current block 2-way 35,299 0.00 11 0 0.29
row cache lock 32,719 0.00 10 0 0.27
gc current block busy 63 0.00 8 130 0.00
library cache pin 28,427 0.00 7 0 0.24
wait for scn ack 15,854 0.01 6 0 0.13
log file sequential read 124 0.00 5 42 0.00
library cache lock 13,618 0.00 5 0 0.11
enq: US - contention 17,424 0.00 4 0 0.15
PX qref latch 410,689 100.00 4 0 3.42
SQL*Net break/reset to client 19,498 0.00 4 0 0.16
enq: WF - contention 758 0.53 3 4 0.01
Log archive I/O 132 0.00 3 23 0.00
gc current grant busy 9,900 0.00 3 0 0.08
latch free 2,283 0.00 2 1 0.02
ksxr poll remote instances 191,083 56.53 2 0 1.59
gcs log flush sync 302 19.21 2 7 0.00
PX Deq: reap credit 63,688 95.33 2 0 0.53
gc cr disk read 7,007 0.00 2 0 0.06
SQL*Net message to client 3,532,030 0.00 2 0 29.44
gc current multi block request 3,250 0.00 2 0 0.03
rdbms ipc reply 7,044 0.00 1 0 0.06
gc recovery quiesce 2 100.00 1 624 0.00
gc cr grant 2-way 6,112 0.00 1 0 0.05
PX Deq: Signal ACK 1,555 30.29 1 1 0.01
enq: PS - contention 2,167 0.00 1 0 0.02
SQL*Net more data from client 31,074 0.00 1 0 0.26
gc cr block busy 275 0.00 1 3 0.00
SQL*Net more data to client 97,301 0.00 1 0 0.81
gcs drm freeze in enter server mode 8 0.00 1 90 0.00
log file switch completion 2 0.00 0 224 0.00
PX Deq Credit: send blkd 2,432 56.04 0 0 0.02
IPC send completion sync 941 99.36 0 0 0.01
enq: JS - queue lock 102 0.00 0 3 0.00
gc current grant 2-way 2,032 0.00 0 0 0.02
enq: CF - contention 27 0.00 0 10 0.00
latch: ges resource hash list 9,533 0.00 0 0 0.08
gc remaster 7 0.00 0 29 0.00
enq: TM - contention 356 0.00 0 0 0.00
ges global resource directory to be frozen 9 100.00 0 16 0.00
gc buffer busy 8 12.50 0 16 0.00
enq: JS - job run lock - synchronize 135 0.00 0 1 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 9 0.00 0 11 0.00
enq: TA - contention 299 0.00 0 0 0.00
enq: TD - KTF dump entries 206 0.00 0 0 0.00
LGWR wait for redo copy 404 0.00 0 0 0.00
latch: gcs resource hash 147 0.00 0 0 0.00
enq: DR - contention 55 0.00 0 0 0.00
enq: RO - fast object reuse 71 0.00 0 0 0.00
log file single write 2 0.00 0 10 0.00
enq: PI - contention 64 0.00 0 0 0.00
ges inquiry response 43 0.00 0 0 0.00
cursor: pin S wait on X 1 100.00 0 18 0.00
enq: MW - contention 54 0.00 0 0 0.00
enq: TT - contention 56 0.00 0 0 0.00
enq: UL - contention 45 0.00 0 0 0.00
enq: PR - contention 2 0.00 0 7 0.00
latch: cache buffers lru chain 29 0.00 0 0 0.00
enq: FB - contention 29 0.00 0 0 0.00
KJC: Wait for msg sends to complete 172 0.00 0 0 0.00
enq: TO - contention 34 0.00 0 0 0.00
gc cr block congested 3 0.00 0 2 0.00
enq: AF - task serialization 14 0.00 0 0 0.00
gc current block congested 3 0.00 0 2 0.00
enq: HW - contention 18 0.00 0 0 0.00
latch: session allocation 6 0.00 0 1 0.00
enq: MD - contention 15 0.00 0 0 0.00
latch: shared pool 14 0.00 0 0 0.00
latch: messages 29 0.00 0 0 0.00
enq: SK - contention 9 0.00 0 0 0.00
direct path read 1,931 0.00 0 0 0.02
latch: enqueue hash chains 4 0.00 0 0 0.00
enq: TX - index contention 4 0.00 0 0 0.00
latch: library cache 13 0.00 0 0 0.00
enq: JS - wdw op 2 0.00 0 0 0.00
undo segment extension 179 100.00 0 0 0.00
direct path write temp 297 0.00 0 0 0.00
direct path write 124 0.00 0 0 0.00
buffer busy waits 6 0.00 0 0 0.00
latch: library cache lock 3 0.00 0 0 0.00
latch: KCL gc element parent latch 12 0.00 0 0 0.00
latch: object queue header operation 1 0.00 0 0 0.00
latch: row cache objects 4 0.00 0 0 0.00
latch: redo allocation 3 0.00 0 0 0.00
cr request retry 1 100.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
SQL*Net message from client 3,531,995 0.00 1,607,130 455 29.44
gcs remote message 6,379,120 99.55 189,677 30 53.17
jobq slave wait 40,684 94.58 112,754 2771 0.34
DIAG idle wait 479,433 0.00 94,853 198 4.00
ges remote message 1,369,054 96.31 94,805 69 11.41
Streams AQ: waiting for messages in the queue 11,357 100.00 94,732 8341 0.09
virtual circuit status 3,239 100.00 94,629 29216 0.03
Streams AQ: qmn slave idle wait 3,447 0.00 94,532 27424 0.03
Streams AQ: qmn coordinator idle wait 5,213 66.68 94,520 18132 0.04
PX Idle Wait 34,376 96.31 81,852 2381 0.29
Streams AQ: waiting for time management or cleanup tasks 23 100.00 66,005 2869772 0.00
PX Deq: Execution Msg 4,966 12.83 18 4 0.04
PX Deq: Msg Fragment 1,643 12.84 7 4 0.01
PL/SQL lock timer 2 100.00 2 981 0.00
PX Deq: Join ACK 2,280 39.65 1 1 0.02
PX Deq: Execute Reply 3,568 39.01 1 0 0.03
PX Deq: Parse Reply 2,269 38.83 1 0 0.02
Streams AQ: RAC qmn coordinator idle wait 7,246 100.00 0 0 0.06
class slave wait 28 0.00 0 1 0.00
PX Deq Credit: need buffer 9 66.67 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
control file parallel write 32,207 0.00 734 23 0.27
events in waitclass Other 1,198,231 87.96 398 0 9.99
control file sequential read 208,107 0.00 203 1 1.73
log file parallel write 22,038 0.00 197 9 0.18
os thread startup 1,743 0.00 103 59 0.01
log file sequential read 124 0.00 5 42 0.00
Log archive I/O 132 0.00 3 23 0.00
row cache lock 2,343 0.00 1 1 0.02
gc current block 2-way 3,110 0.00 1 0 0.03
gc cr block 2-way 1,426 0.00 0 0 0.01
gc current grant busy 860 0.00 0 0 0.01
db file sequential read 48 0.00 0 7 0.00
gc current block busy 1 0.00 0 189 0.00
enq: TM - contention 157 0.00 0 0 0.00
gc cr block busy 1 0.00 0 35 0.00
enq: RO - fast object reuse 71 0.00 0 0 0.00
log file single write 2 0.00 0 10 0.00
gc cr multi block request 74 0.00 0 0 0.00
library cache lock 36 0.00 0 0 0.00
gc current grant 2-way 40 0.00 0 0 0.00
latch: shared pool 3 0.00 0 1 0.00
buffer busy waits 3 0.00 0 0 0.00
latch: row cache objects 3 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 1,521,445 89.39 1,210,191 795 12.68
gcs remote message 6,379,121 99.55 189,677 30 53.17
DIAG idle wait 479,432 0.00 94,853 198 4.00
pmon timer 32,639 100.00 94,821 2905 0.27
ges remote message 1,369,035 96.31 94,805 69 11.41
Streams AQ: qmn slave idle wait 3,447 0.00 94,532 27424 0.03
Streams AQ: qmn coordinator idle wait 5,213 66.68 94,520 18132 0.04
smon timer 427 74.24 91,792 214971 0.00
Streams AQ: waiting for time management or cleanup tasks 23 100.00 66,005 2869772 0.00
PX Deq: Join ACK 700 45.86 1 1 0.01
PX Deq: Parse Reply 705 45.53 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 7,246 100.00 0 0 0.06
PX Deq: Execute Reply 727 38.51 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 997,740
AVG_IDLE_TIME 8,715,233
AVG_IOWAIT_TIME 105,347
AVG_SYS_TIME 672,540
AVG_USER_TIME 323,537
BUSY_TIME 1,998,693
IDLE_TIME 17,433,671
IOWAIT_TIME 213,911
SYS_TIME 1,348,379
USER_TIME 650,314
LOAD 0
OS_CPU_WAIT_TIME 64,932,327,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 13,713,408
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 17,145,126,912
NUM_CPUS 2
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 1,505.10 524.00 368,006 27,771,631
gddsdb 538.40 465.00 9,284 18,132,417
SYS$BACKGROUND 0.00 0.00 485 727,451
gddsdbXDB 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
SYS$USERS 55158 37616 31387 1676 0 0 2008903 193
gddsdb 4164 3310 36666 1009 0 0 1651334 143
SYS$BACKGROUND 1230 346 8637 10606 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
313 93 2 156.36 15.29 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
177 71 1 176.86 8.65 0taz46tk64xr7 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
140 14 2 69.95 6.84 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
127 8 43 2.95 6.20 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
120 102 622 0.19 5.85 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
94 26 1,615 0.06 4.61 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
58 7 1,165 0.05 2.86 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
53 53 9,545 0.01 2.60 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
39 4 5 7.75 1.90 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
18 17 16 1.11 0.87 akpv4yxpfxcvh JDBC Thin Client select * from dxlogsnote or...

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
102 120 622 0.16 5.85 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
93 313 2 46.63 15.29 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
71 177 1 70.94 8.65 0taz46tk64xr7 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
53 53 9,545 0.01 2.60 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
26 94 1,615 0.02 4.61 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
17 18 16 1.09 0.87 akpv4yxpfxcvh JDBC Thin Client select * from dxlogsnote or...
15 17 622 0.02 0.83 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
14 140 2 6.80 6.84 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
9 13 2,490 0.00 0.65 4y1y43113gv8f   delete from histgrm$ where obj...
8 8 5,670 0.00 0.41 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
8 127 43 0.18 6.20 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
7 58 1,165 0.01 2.86 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
4 39 5 0.85 1.90 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...

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
21,612,998 622 34,747.59 46.42 101.78 119.72 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
19,192,542 9,545 2,010.74 41.22 52.89 53.19 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
1,766,389 622 2,839.85 3.79 15.40 17.07 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
1,453,481 1 1,453,481.00 3.12 70.94 176.86 0taz46tk64xr7 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
1,329,701 2 664,850.50 2.86 93.26 312.72 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
665,784 1,615 412.25 1.43 26.04 94.21 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
459,618 2 229,809.00 0.99 13.60 139.89 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
270,635 2 135,317.50 0.58 1.56 1.60 89804m321gw99 JDBC Thin Client select * from inventory whe...
270,621 2 135,310.50 0.58 2.08 2.10 6rusf5usxz0nn JDBC Thin Client select * from inventory whe...
270,607 2 135,303.50 0.58 1.78 1.79 73p4ab8kujcxz JDBC Thin Client select * from inventory whe...

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
205,021 1 205,021.00 54.27 70.94 176.86 0taz46tk64xr7 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
80,212 2 40,106.00 21.23 13.60 139.89 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
80,083 43 1,862.40 21.20 7.95 126.79 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
26,149 2 13,074.50 6.92 93.26 312.72 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
11,820 1,615 7.32 3.13 26.04 94.21 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
11,745 1,165 10.08 3.11 7.39 58.49 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
11,742 5 2,348.40 3.11 4.23 38.75 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
9,993 1 9,993.00 2.65 2.36 7.79 0day7ru2puqr1 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
4,283 1 4,283.00 1.13 1.77 3.77 gxy45w2c1rcv1 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
3,342 1 3,342.00 0.88 1.14 6.25 626xsbs7qatvd DBMS_SCHEDULER select /*+ no_parallel_index(t...

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
27,284 85,590 3.14 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
21,945 0 0.00 0.00 0.00 2k3bu9k1p7kyz   select /*+ INDEX(ol$ ol$signat...
13,979 13,979 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
10,065 837 0.08 0.00 0.00 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
9,692 9,518 0.98 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set eq...
9,545 7,393 0.77 0.01 0.01 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
9,151 9,151 1.00 0.00 0.00 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...
9,081 66,731 7.35 0.00 0.00 68fbr7gjyvakv exp@gdds1 (TNS V1-V3) SELECT BUCKET, ENDPTHASH, EN...
8,622 8,622 1.00 0.00 0.00 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
8,373 8,373 1.00 0.00 0.00 86vr1d9h5ysf1 JDBC Thin Client select OWNERID, FLOWAPP01 from...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
27,284 27,284 5.38 0h6b2sajwb74n   select privilege#, level from ...
21,945 21,945 4.32 2k3bu9k1p7kyz   select /*+ INDEX(ol$ ol$signat...
13,979 13,979 2.75 2ym6hhaq30r73   select type#, blocks, extents,...
9,110 9,151 1.80 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...
8,373 8,373 1.65 86vr1d9h5ysf1 JDBC Thin Client select OWNERID, FLOWAPP01 from...
6,660 6,660 1.31 7c94butjcxfh9 JDBC Thin Client select OWNERID, FLOWAPP01 from...
4,144 4,144 0.82 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
4,142 4,142 0.82 g00cj285jmgsw   update sys.mon_mods$ set inser...
3,562 3,562 0.70 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
3,516 178 0.69 53btfq0dt9bs9   insert into sys.col_usage$ val...

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
20.58 6.58 312.72 93.26 2 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
11.81 6.68 176.86 70.94 1 0taz46tk64xr7 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
8.88 6.35 139.89 13.60 2 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
8.67 86.76 10.00 1.59 1 bhvf7p165f6c5 JDBC Thin Client select * from wftransaction ...
8.55 6.74 126.79 7.95 43 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
4.56 34.27 13.30 8.61 2,490 4y1y43113gv8f   delete from histgrm$ where obj...
3.44 2.87 119.72 101.78 622 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
1.58 1.68 94.21 26.04 1,615 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1.57 95.10 1.65 0.17 81 6gwzs9q9z2x32 JDBC Thin Client delete from maxsession where m...
1.49 2.56 58.49 7.39 1,165 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
1.49 3.85 38.75 4.23 5 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
1.47 13.65 10.80 5.40 1 87kdu2wk22tp9 DBMS_SCHEDULER select /*+ no_parallel_index(t...
1.38 21.03 6.54 3.56 2,948 5vdxntxszh5p0 JDBC Thin Client update wfassignment set assign...
1.11 30.97 3.57 1.64 2 5ps3p5ma94bkh DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
1.06 94.07 1.12 0.13 2,047 0kn0gdvnmqmuk DBMS_SCHEDULER select 1 from "MAXIMO"."WFASSI...
0.90 87.31 1.03 0.15 85 2nw5tf2kfdfd0 DBMS_SCHEDULER begin ctxsys.drvdml.DeletePend...
0.90 91.21 0.99 0.12 85 9z4qbcwu143pw DBMS_SCHEDULER DELETE /*+INDEX(dr$pending)*/ ...
0.79 14.56 5.45 3.83 2,719 bywqkxw8zag3r JDBC Thin Client insert into wfassignment (owne...
0.63 5.61 11.24 2.34 1 7jhgtr9p96hbr DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.47 38.66 1.21 0.91 2 d364ff1x8aj7t DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.41 34.39 1.18 0.83 2 64rm3fkyzgnyy DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.40 98.51 0.41 0.00 3 77480c76zuny9 JDBC Thin Client update dxrunlogs set zbuser=:1...
0.38 6.09 6.20 1.83 720 0ybwd63u2any5   insert into sys.wri$_optstat_h...
0.27 11.46 2.33 1.96 3,922 db78fxqxwxt7r   select /*+ rule */ bucket, en...
0.26 1.51 17.07 15.40 622 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
0.25 4.05 6.25 1.14 1 626xsbs7qatvd DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.25 9.83 2.57 2.06 8 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.25 34.45 0.73 0.55 24 31a13pnjps7j3   SELECT source, (case w...
0.24 15.50 1.55 1.55 9,692 3c1kubcdjnppq   update sys.col_usage$ set eq...
0.24 57.17 0.42 0.00 1 086m4xkdc2xyy DBMS_SCHEDULER select /*+ no_parallel(t) no_...
0.23 39.41 0.58 0.55 598 aq8yqxyyb40nn   update sys.job$ set this_date=...
0.22 53.77 0.42 0.12 4 gfvjmmmx6vku1 JDBC Thin Client select * from wftransaction ...
0.22 2.86 7.79 2.36 1 0day7ru2puqr1 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
0.21 90.64 0.24 0.02 8 7cq8d0jqxzum1   delete from smon_scn_time wher...
0.20 61.40 0.32 0.18 5 3ab2tvzpwggc1 JDBC Thin Client select * from mrline where ...
0.19 89.26 0.21 0.02 7 g337099aatnuj   update smon_scn_time set orig_...
0.19 96.99 0.20 0.01 4 fr1k4gxy5pt52 JDBC Thin Client update dxlogsnote set descript...
0.18 30.74 0.59 0.45 1 5kvyc4tv51v5r JDBC Thin Client select count(*) from wftransac...
0.18 47.54 0.38 0.34 2,141 c4nhd1ntptxq7   select message_level, sequenc...
0.18 23.92 0.75 0.62 1 cyfauqcw5k0nj DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.17 21.22 0.80 0.69 2 6b53dx5f75byp DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.15 29.86 0.49 0.20 1 10xtqfjuy0x48 JDBC Thin Client select * from doclinks wher...
0.15 14.26 1.02 0.85 2 a62nah9p9g6rc DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.14 5.49 2.64 1.88 1 8w1bht4s3mt33 DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.14 62.10 0.23 0.12 239 47a50dvdgnxc2   update sys.job$ set failures=0...
0.14 10.18 1.39 0.60 67 3038pc1vzu8vu DBMS_SCHEDULER select /*+ ORDERED USE_NL(base...
0.14 47.83 0.30 0.23 1 16nj8n756zw4u JDBC Thin Client select * from matusetrans w...
0.13 11.12 1.18 1.12 2 0075wjazyxcm5 DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.13 22.61 0.58 0.28 3 3hbsnuctrh0cw JDBC Thin Client select * from asset where c...
0.12 2.19 5.68 5.49 22 84qubbrsr0kfn   insert into wrh$_latch (snap...
0.12 18.21 0.68 0.64 1 5gw68c17m76zf   SELECT (SELECT DISPLAYNAME FRO...
0.12 2.71 4.32 4.10 2 cqjwytk1ghamg DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
0.12 0.22 53.19 52.89 9,545 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
0.11 16.06 0.71 0.63 1 5uzqxa82xchzt JDBC Thin Client select * from wftransaction ...
0.10 34.29 0.31 0.27 1 95t0pj1vmrbrb JDBC Thin Client select * from item where cl...
0.10 15.36 0.67 0.43 2 1bqj9rpf98r58 JDBC Thin Client select count(*) from workorder...
0.10 10.27 1.00 0.20 1 f5nm3zn5cr5nr DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.10 2.69 3.77 1.77 1 gxy45w2c1rcv1 exp@gdds1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
0.10 6.51 1.54 1.45 2 6dvbmzm8snzds JDBC Thin Client select * from wftransaction ...
0.09 9.73 0.96 0.89 2 gnvpphhgfm2vq JDBC Thin Client select count(*) from wftransac...
0.09 10.30 0.91 0.42 1 156drv6my0mfu DBMS_SCHEDULER select /*+ no_parallel_index(t...
0.09 10.57 0.88 0.48 2 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
0.09 20.06 0.46 0.39 1 cjtrjwy9nv88u   SELECT A.PONUM, (SELECT DESC...
0.09 7.13 1.26 1.21 9,151 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0075wjazyxcm5select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count(distinct "SAMPLE_ID"), count(distinct "SAMPLE_TIME"), count("SQL_ID"), sum(sys_op_opnsize("SQL_ID")), count("CLIENT_ID"), count(distinct "CLIENT_ID"), sum(sys_op_opnsize("CLIENT_ID")), substrb(dump(min(substrb("CLIENT_ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CLIENT_ID", 1, 32)), 16, 0, 32), 1, 120), count("XID"), count(distinct "XID"), sum(sys_op_opnsize("XID")), substrb(dump(min("XID"), 16, 0, 32), 1, 120), substrb(dump(max("XID"), 16, 0, 32), 1, 120) from "SYS"."WRH$_ACTIVE_SESSION_HISTORY" t
086m4xkdc2xyy select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "SYS"."WRI$_ALERT_HISTORY" t
0day7ru2puqr1SELECT /*+NESTED_TABLE_GET_REFS+*/ "MAXIMO"."DXLOGSETMODE".* FROM "MAXIMO"."DXLOGSETMODE"
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0kn0gdvnmqmukselect 1 from "MAXIMO"."WFASSIGNMENT" where rowid = :RID for update nowait
0taz46tk64xr7SELECT /*+NESTED_TABLE_GET_REFS+*/ "MAXIMO"."WFASSIGNMENT".* FROM "MAXIMO"."WFASSIGNMENT"
0ybwd63u2any5insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
10xtqfjuy0x48select * from doclinks where (ownertable='PO' and ownerid= 5006 ) or (ownertable = 'COMPANIES' and ownerid = (select companiesid from companies where company= 'BTSRXJMYXZRGS' and orgid= 'CGDC' )) or (ownertable = 'CONTRACT' and ownerid = (select contractid from contract where contractnum= '' and revisionnum= -32767 and orgid= 'CGDC' )) or (ownertable = 'MRLINE' and ownerid in (select mrlineid from mrline where mrnum in (select mrnum from poline where ponum= 'PO5154' and siteid= 'LSSITE' ))) or (ownertable = 'PR' and ownerid in (select prid from pr where prnum in (select prnum from prline where ponum= 'PO5154' and siteid= 'LSSITE' ))) or (ownertable = 'RFQ' and ownerid in (select rfqid from rfq where rfqnum in (select rfqnum from rfqline where ponum= 'PO5154' and siteid= 'LSSITE' )))
156drv6my0mfuselect /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_HH_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_HH_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4217, 'L', t.rowid)) as nlb, count(distinct SYS_EXTRACT_UTC("SAVTIME")) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTHEAD_HISTORY" t where SYS_EXTRACT_UTC("SAVTIME") is not null
15an99c0zzka4SELECT PND_INDEX_NAME INAME FROM CTX_USER_PENDING
16nj8n756zw4uselect * from matusetrans where storeloc = 'DRK' and siteid= 'LSSITE' order by actualdate desc
1b28hzmjun5t0MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0)
1bqj9rpf98r58select count(*) from workorder where (((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and istask = 0)) and (exists ((select siteid from siteauth a1, groupuser b1, maxgroup m1, applicationauth t1 where b1.userid = 'CAICZ' and b1.groupname=a1.groupname and b1.groupname=m1.groupname and m1.independent = 1 and a1.groupname = t1.groupname and t1.app = 'WOREQCK' and a1.siteid = workorder.siteid ) union all (select siteid from siteauth a, groupuser b, maxgroup m where b.userid = 'CAICZ' and b.groupname=a.groupname and b.groupname=m.groupname and m.independent = 0 and a.siteid = workorder.siteid and ( exists (select 1 from maxgroup m2, applicationauth c, groupuser d where d.userid = 'CAICZ' and d.groupname = m2.groupname and d.groupname = c.groupname and m2.independent = 0 and c.app = 'WOREQCK' ))) )) and (worktype ='CM')
2k3bu9k1p7kyzselect /*+ INDEX(ol$ ol$signature) */ ol_name, rowid, textlen, version, creator, timestamp, flags, hintcount, hash_value, hash_value2 from outln.ol$ where signature = :1 and category = :2
2nw5tf2kfdfd0begin ctxsys.drvdml.DeletePending(:1, :2, :3); end;
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3038pc1vzu8vuselect /*+ ORDERED USE_NL(base pnd) */ base.rowid, upper(substrb(base."LANGCODE", 1, 30)), NULL, NULL, nvl(pnd_lock_failed, 'N'), base."DESCRIPTION" from ctxsys.drv$pending pnd, "MAXIMO"."WFASSIGNMENT" base where pnd.pnd_cid = :CID and pnd.pnd_pid = :PID and pnd.pnd_timestamp <= to_date(:TSTAMP, 'YYYYMMDDSSSSS') and base.rowid = pnd.pnd_rowid order by pnd.pnd_cid, pnd.pnd_pid, pnd.pnd_rowid
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3ab2tvzpwggc1select * from mrline where mrnum = 'MR5405' and siteid= 'LSSITE'
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3hbsnuctrh0cwselect * from asset where classstructureid in (select classstructureid from classancestor where ancestor= '38030200100000' )
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
53btfq0dt9bs9insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
5gw68c17m76zfSELECT (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=A.ISSUETO) AS DISPLAYNAME, (SELECT DESCRIPTION FROM DEPT WHERE DEPTNUM=SUBSTR(A.IT6, 1, 2)) AS SUBDEPTNAME, (SELECT DESCRIPTION FROM DEPT WHERE DEPTNUM=A.IT6) AS DEPTNAME, (SELECT P_GETGLDESC(A.GLDEBITACCT) FROM DUAL) AS GLDESC, A.ITEMNUM, A.ACTUALDATE, (SELECT DESCRIPTION FROM LOCATIONS WHERE LOCATION=A.STORELOC) AS STORELOC, (SELECT DESCRIPTION FROM ITEM WHERE ITEMNUM=A.ITEMNUM) AS ITEMNAME, C.LOTNUM, A.QUANTITY AS QUANTITY, A.UNITCOST, A.LINECOST AS LINECOST, A.IT10, (SELECT MAX(ISSUEUNIT) FROM INVENTORY WHERE ITEMNUM=A.ITEMNUM) AS ISSUEUNIT, A.MEMO FROM MATUSETRANS A, INVBALANCES C WHERE A.ITEMNUM=C.ITEMNUM AND A.LOTNUM=C.LOTNUM AND (to_char(ACTUALDATE, 'yyyy-mm-dd hh24:mi:ss') BETWEEN to_char(:1, 'yyyy-mm-dd hh24:mi:ss') AND to_char(:2, 'yyyy-mm-dd hh24:mi:ss'))
5kvyc4tv51v5rselect count(*) from wftransaction where ownertable = 'WOTHAZARD' and ownerid = 17527
5ps3p5ma94bkh MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > .5 THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M WHERE :B1 IS NOT NULL AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE # = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B4 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND( OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE :B5 IS NOT NULL UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# A ND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (:B8 IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > .1 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (T.ROWCNT + M.INSERTS - M.DELETES))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI WHERE :B1 IS NOT NULL AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE# (+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), (TP.ROWCNT + M.INSERTS - M.DELETES))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# A ND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE :B5 IS NOT NULL UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (:B8 IS NOT NULL) AND :B1 IS NOT NULL AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.PART# PART#, I.BO# BO# FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PA RT#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND :B5 IS NOT NULL AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.SUBPART# PART#, I.POBJ# BO# FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B3 , :B2 , NEW.PART#, NEW.BO#)
5uzqxa82xchztselect * from wftransaction where ownertable = 'WOTHAZARD' and ownerid = 17527 order by transdate, transid
5vdxntxszh5p0update wfassignment set assignstatus=:1 where wfassignmentid=:2 and rowstamp=:3
626xsbs7qatvdselect /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4219, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("INTCOL#")||sys_op_descend(SYS_EXTRACT_UTC("SAVTIME")))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" sample block ( 19.0190397351, 1) t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null
64rm3fkyzgnyyselect /*+ no_parallel_index(t, "WRH$_WAITCLASSMETRIC_HIST_IND") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "WRH$_WAITCLASSMETRIC_HIST_IND") */ count(*) as nrw, count(distinct sys_op_lbid(9113, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("DBID")||sys_op_descend("SNAP_ID")||sys_op_descend("INSTANCE_NUMBER")||sys_op_descend("GROUP_ID")||sys_op_descend("WAIT_CLASS_ID")||sys_op_descend("BEGIN_TIME"))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" t where "DBID" is not null or "SNAP_ID" is not null or "INSTANCE_NUMBER" is not null or "GROUP_ID" is not null or "WAIT_CLASS_ID" is not null or "BEGIN_TIME" is not null
68fbr7gjyvakvSELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_RAW(ENDPTVAL) ENDPTVAL_RAW FROM SYS.EXU8HST WHERE POBJID = :1 AND INTCOL = :2 ORDER BY BUCKET
6b53dx5f75bypselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count(distinct "BEGIN_TIME"), count(distinct "END_TIME"), count(distinct "AVERAGE_WAITER_COUNT"), count(distinct "DBTIME_IN_WAIT"), count(distinct "TIME_WAITED") from "SYS"."WRH$_WAITCLASSMETRIC_HISTORY" t
6dvbmzm8snzdsselect * from wftransaction where ownertable = 'WORKORDER' and ownerid = 58670 order by transdate, transid
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6gwzs9q9z2x32delete from maxsession where maxsessionuid=:1 and rowstamp=:2
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6rusf5usxz0nnselect * from inventory where ((siteid = 'LSSITE') and (exists (select itemnum from maximo.item where ((upper(description) like '%½Ç¸Ö%')) and (itemnum = inventory.itemnum and itemsetid = inventory.itemsetid)))) and (itemnum in (select itemnum from item where itemtype in (select value from synonymdomain where domainid='ITEMTYPE' and maxvalue = 'ITEM')))
6ssrk2dqj7jbxselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
73p4ab8kujcxzselect * from inventory where ((siteid = 'LSSITE') and (exists (select itemnum from maximo.item where ((upper(description) like '%½ºÈ¦%')) and (itemnum = inventory.itemnum and itemsetid = inventory.itemsetid)))) and (itemnum in (select itemnum from item where itemtype in (select value from synonymdomain where domainid='ITEMTYPE' and maxvalue = 'ITEM')))
77480c76zuny9update dxrunlogs set zbuser=:1, runlog5=:2, zhibie=:3, tq=:4, shiftzz=:5, runlog4=:6, runlog6=:7 where dxrunlogsid=:8 and rowstamp=:9
7c94butjcxfh9select OWNERID, FLOWAPP01 from FLOWAPPCFG where OWNERTABLE=upper('WORKORDER')
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
7jhgtr9p96hbrselect /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_H_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4220, 'L', t.rowid)) as nlb, count(distinct SYS_EXTRACT_UTC("SAVTIME")) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where SYS_EXTRACT_UTC("SAVTIME") is not null
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
86vr1d9h5ysf1select OWNERID, FLOWAPP01 from FLOWAPPCFG where OWNERTABLE=upper('WOTHAZARD')
87kdu2wk22tp9select /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4219, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("INTCOL#")||sys_op_descend(SYS_EXTRACT_UTC("SAVTIME")))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null
89804m321gw99select * from inventory where ((siteid = 'LSSITE') and (exists (select itemnum from maximo.item where ((upper(description) like '%º¸Ìõ%')) and (itemnum = inventory.itemnum and itemsetid = inventory.itemsetid)))) and (itemnum in (select itemnum from item where itemtype in (select value from synonymdomain where domainid='ITEMTYPE' and maxvalue = 'ITEM')))
89qyn4bbt03jqSELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME
8a1pvy4cy8hgvinsert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7)
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8w1bht4s3mt33select /*+ no_parallel_index(t, "I_H_OBJ#_COL#") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_H_OBJ#_COL#") */ count(*) as nrw, count(distinct sys_op_lbid(254, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("COL#"))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."HISTGRM$" t where "OBJ#" is not null or "COL#" is not null
95t0pj1vmrbrbselect * from item where classstructureid in (select classstructureid from classancestor where ancestor= 'K36042800' )
9z4qbcwu143pwDELETE /*+INDEX(dr$pending)*/ FROM DR$PENDING WHERE PND_CID = :B3 AND PND_PID = :B2 AND PND_ROWID = :B1
a62nah9p9g6rcselect /*+ no_parallel_index(t, "WRH$_SYSMETRIC_SUMMARY_INDEX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "WRH$_SYSMETRIC_SUMMARY_INDEX") */ count(*) as nrw, count(distinct sys_op_lbid(9107, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("DBID")||sys_op_descend("SNAP_ID")||sys_op_descend("INSTANCE_NUMBER")||sys_op_descend("GROUP_ID")||sys_op_descend("METRIC_ID"))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRH$_SYSMETRIC_SUMMARY" t where "DBID" is not null or "SNAP_ID" is not null or "INSTANCE_NUMBER" is not null or "GROUP_ID" is not null or "METRIC_ID" is not null
abtp0uqvdb1d3CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
akpv4yxpfxcvhselect * from dxlogsnote order by logdate desc
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
av3jp9pzytg3ucall maximo_ts_job ( )
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bhvf7p165f6c5select * from wftransaction where ownertable = 'WORKORDER' and ownerid = 58115 order by transdate, transid
bvttmwz2rkt85SELECT /*+FIRST_ROWS INDEX(dr$pending)*/ NULL FROM DR$PENDING WHERE PND_CID = :B2 AND PND_PID = :B1 AND PND_TIMESTAMP <= SYSDATE
bywqkxw8zag3rinsert into wfassignment (ownertable, assignstatus, wfassignmentid, assign_03, priority, templateid, processname, assign_05, origperson, nodeid, duedate, wfid, assignid, calendarbased, escrole, recordkey, conditionclass, condition, app, hasld, assign_04, processrev, assign_01, roleid, langcode, ownerid, assigncode, description, assign_02, timelimit, emailnotification, startdate) values (:1, :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, :29, :30, :31, :32)
c3hhngpbpvvmkSELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
cjtrjwy9nv88uSELECT A.PONUM, (SELECT DESCRIPTION FROM PO WHERE PONUM=A.PONUM) AS DESCRIPTION, A.POLINENUM, ----²É¹ºµ¥ÐÐ A.ITEMNUM, A.TOLOT, (SELECT DESCRIPTION FROM ITEM WHERE ITEMNUM=A.ITEMNUM) AS ITEMNAME, A.ACTUALDATE, A.TOSTORELOC, A.UNITCOST, A.QUANTITY, A.LINECOST, B.PO4, A.ROWSTAMP FROM MATRECTRANS A, PO B WHERE A.PONUM=B.PONUM AND (to_char(ACTUALDATE, 'yyyy-mm-dd hh24:mi:ss') BETWEEN to_char(:1, 'yyyy-mm-dd hh24:mi:ss') AND to_char(:2, 'yyyy-mm-dd hh24:mi:ss'))
cqjwytk1ghamg select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("ROWS_PROCESSED_DELTA"), count(distinct "ROWS_PROCESSED_DELTA"), sum(sys_op_opnsize("ROWS_PROCESSED_DELTA")), substrb(dump(min("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), count("CPU_TIME_TOTAL"), count(distinct "CPU_TIME_TOTAL"), sum(sys_op_opnsize("CPU_TIME_TOTAL")), substrb(dump(min("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), count("CPU_TIME_DELTA"), count(distinct "CPU_TIME_DELTA"), sum(sys_op_opnsize("CPU_TIME_DELTA")), substrb(dump(min("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_TOTAL"), count(distinct "ELAPSED_TIME_TOTAL"), sum(sys_op_opnsize("ELAPSED_TIME_TOTAL")), substrb(dump(min("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_DELTA"), count(distinct "ELAPSED_TIME_DELTA"), sum(sys_op_opnsize("ELAPSED_TIME_DELTA")), substrb(dump(min("ELAPSED_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_DELTA"), 16, 0, 32), 1, 120), count("IOWAIT_TOTAL"), count(distinct "IOWAIT_TOTAL"), sum(sys_op_opnsize("IOWAIT_TOTAL")), substrb(dump(min("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), count("IOWAIT_DELTA"), count(distinct "IOWAIT_DELTA"), sum(sys_op_opnsize("IOWAIT_DELTA")), substrb(dump(min("IOWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_DELTA"), 16, 0, 32), 1, 120), count("CLWAIT_TOTAL"), count(distinct "CLWAIT_TOTAL"), sum(sys_op_opnsize("CLWAIT_TOTAL")), substrb(dump(min("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CLWAIT_DELTA"), count(distinct "CLWAIT_DELTA"), sum(sys_op_opnsize("CLWAIT_DELTA")), substrb(dump(min("CLWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_DELTA"), 16, 0, 32), 1, 120), count("APWAIT_TOTAL"), count(distinct "APWAIT_TOTAL"), sum(sys_op_opnsize("APWAIT_TOTAL")), substrb(dump(min("APWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("APWAIT_TOTAL"), 16, 0, 32), 1, 120), count("APWAIT_DELTA"), count(distinct "APWAIT_DELTA"), sum(sys_op_opnsize("APWAIT_DELTA")), substrb(dump(min("APWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("APWAIT_DELTA"), 16, 0, 32), 1, 120), count("CCWAIT_TOTAL"), count(distinct "CCWAIT_TOTAL"), sum(sys_op_opnsize("CCWAIT_TOTAL")), substrb(dump(min("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CCWAIT_DELTA"), count(distinct "CCWAIT_DELTA"), sum(sys_op_opnsize("CCWAIT_DELTA")), substrb(dump(min("CCWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_DELTA"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_TOTAL"), count(distinct "DIRECT_WRITES_TOTAL"), sum(sys_op_opnsize("DIRECT_WRITES_TOTAL" )), substrb(dump(min("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_DELTA"), count(distinct "DIRECT_WRITES_DELTA"), sum(sys_op_opnsize("DIRECT_WRITES_DELTA")), substrb(dump(min("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_TOTAL"), count(distinct "PLSEXEC_TIME_TOTAL"), sum(sys_op_opnsize("PLSEXEC_TIME_TOTAL")), substrb(dump(min("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_DELTA"), count(distinct "PLSEXEC_TIME_DELTA"), sum(sys_op_opnsize("PLSEXEC_TIME_DELTA")), substrb(dump(min("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_TOTAL"), count(distinct "JAVEXEC_TIME_TOTAL"), sum(sys_op_opnsize("JAVEXEC_TIME_TOTAL")), substrb(dump(min("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_DELTA"), count(distinct "JAVEXEC_TIME_DELTA"), sum(sys_op_opnsize("JAVEXEC_TIME_DELTA")), substrb(dump(min("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("BIND_DATA"), count(distinct "BIND_DATA"), sum(sys_op_opnsize("BIND_DATA")), substrb(dump(min(substrb("BIND_DATA", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BIND_DATA", 1, 32)), 16, 0, 32 ), 1, 120), count("FLAG"), count(distinct "FLAG"), sum(sys_op_opnsize("FLAG")), substrb(dump(min("FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("FLAG"), 16, 0, 32), 1, 120), count(distinct "SNAP_ID"), sum(sys_op_opnsize("SNAP_ID")), count(distinct "DBID"), sum(sys_op_opnsize("DBID")), count(distinct "INSTANCE_NUMBER"), sum(sys_op_opnsize("INSTANCE_NUMBER")), count(distinct "SQL_ID"), sum(sys_op_opnsize("SQL_ID")), count(distinct "PLAN_HASH_VALUE"), sum(sys_op_opnsize("PLAN_HASH_VALUE")), substrb(dump(min("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), count("OPTIMIZER_COST"), count(distinct "OPTIMIZER_COST"), sum(sys_op_opnsize("OPTIMIZER_COST")), substrb(dump(min("OPTIMIZER_COST"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_COST"), 16, 0, 32), 1, 120), count("OPTIMIZER_MODE"), count(distinct "OPTIMIZER_MODE"), sum(sys_op_opnsize("OPTIMIZER_MODE")), substrb(dump(min("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), count("OPTIMIZER_ENV_HASH_VALUE"), count(distinct "OPTIMIZER_ENV_HASH_VALUE"), sum(sys_op_opnsize("OPTIMIZER_ENV_HASH_VALUE")), substrb(dump(min("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), count("SHARABLE_MEM"), count(distinct "SHARABLE_MEM"), sum(sys_op_opnsize("SHARABLE_MEM")), substrb(dump(min("SHARABLE_MEM"), 16, 0, 32), 1, 120), substrb(dump(max("SHARABLE_MEM"), 16, 0, 32), 1, 120), cou nt("LOADED_VERSIONS"), count(distinct "LOADED_VERSIONS"), sum(sys_op_opnsize("LOADED_VERSIONS")), substrb(dump(min("LOADED_VERSIONS"), 16, 0, 32), 1, 120), substrb(dump(max("LOADED_VERSIONS"), 16, 0, 32), 1, 120), count("VERSION_COUNT"), count(distinct "VERSION_COUNT"), sum(sys_op_opnsize("VERSION_COUNT")), substrb(dump(min("VERSION_COUNT"), 16, 0, 32), 1, 120), substrb(dump(max("VERSION_COUNT"), 16, 0, 32), 1, 120), count("MODULE"), count(distinct "MODULE"), sum(sys_op_opnsize("MODULE")), substrb(dump(min(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), count("ACTION"), count(distinct "ACTION"), sum(sys_op_opnsize("ACTION")), substrb(dump(min(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), count("SQL_PROFILE"), count(distinct "SQL_PROFILE"), sum(sys_op_opnsize("SQL_PROFILE")), substrb(dump(min(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), count("FORCE_MATCHING_SIGNATURE"), count(distinct "FORCE_MATCHING_SIGNATURE"), sum(sys_op_opnsize("FORCE_MATCHING_SIGNATURE")), substrb(dump(min("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), substrb(dump(max("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), count("PARSING_SCHEMA_ID"), count(distinct "PARSING_SCHEMA_ID"), sum(sys_op_opnsize("PARSING_SCHEMA_ID")), substrb(dump(min("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), substrb(dump( max("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), count("PARSING_SCHEMA_NAME"), count(distinct "PARSING_SCHEMA_NAME"), sum(sys_op_opnsize("PARSING_SCHEMA_NAME")), substrb(dump(min("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), count("FETCHES_TOTAL"), count(distinct "FETCHES_TOTAL"), sum(sys_op_opnsize("FETCHES_TOTAL")), substrb(dump(min("FETCHES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_TOTAL"), 16, 0, 32), 1, 120), count("FETCHES_DELTA"), count(distinct "FETCHES_DELTA"), sum(sys_op_opnsize("FETCHES_DELTA")), substrb(dump(min("FETCHES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_DELTA"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_TOTAL"), count(distinct "END_OF_FETCH_COUNT_TOTAL"), sum(sys_op_opnsize("END_OF_FETCH_COUNT_TOTAL")), substrb(dump(min("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_DELTA"), count(distinct "END_OF_FETCH_COUNT_DELTA"), sum(sys_op_opnsize("END_OF_FETCH_COUNT_DELTA")), substrb(dump(min("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), count("SORTS_TOTAL"), count(distinct "SORTS_TOTAL"), sum(sys_op_opnsize("SORTS_TOTAL")), substrb(dump(min("SORTS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_TOTAL"), 16, 0, 32), 1, 120), count("SORTS_DELTA"), count(distinct "SORTS_DELTA"), sum(sys_op_opnsize("SORTS_DE LTA")), substrb(dump(min("SORTS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_DELTA"), 16, 0, 32), 1, 120), count("EXECUTIONS_TOTAL"), count(distinct "EXECUTIONS_TOTAL"), sum(sys_op_opnsize("EXECUTIONS_TOTAL")), substrb(dump(min("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), count("EXECUTIONS_DELTA"), count(distinct "EXECUTIONS_DELTA"), sum(sys_op_opnsize("EXECUTIONS_DELTA")), substrb(dump(min("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_TOTAL"), count(distinct "PX_SERVERS_EXECS_TOTAL"), sum(sys_op_opnsize("PX_SERVERS_EXECS_TOTAL")), substrb(dump(min("PX_SERVERS_EXECS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_TOTAL"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_DELTA"), count(distinct "PX_SERVERS_EXECS_DELTA"), sum(sys_op_opnsize("PX_SERVERS_EXECS_DELTA")), substrb(dump(min("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), count("LOADS_TOTAL"), count(distinct "LOADS_TOTAL"), sum(sys_op_opnsize("LOADS_TOTAL")), substrb(dump(min("LOADS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_TOTAL"), 16, 0, 32), 1, 120), count("LOADS_DELTA"), count(distinct "LOADS_DELTA"), sum(sys_op_opnsize("LOADS_DELTA")), substrb(dump(min("LOADS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_DELTA"), 16, 0, 32), 1, 120), count("INVALIDATIONS_TOTAL"), count(distin ct "INVALIDATIONS_TOTAL"), sum(sys_op_opnsize("INVALIDATIONS_TOTAL")), substrb(dump(min("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), count("INVALIDATIONS_DELTA"), count(distinct "INVALIDATIONS_DELTA"), sum(sys_op_opnsize("INVALIDATIONS_DELTA")), substrb(dump(min("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), count("PARSE_CALLS_TOTAL"), count(distinct "PARSE_CALLS_TOTAL"), sum(sys_op_opnsize("PARSE_CALLS_TOTAL")), substrb(dump(min("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), count("PARSE_CALLS_DELTA"), count(distinct "PARSE_CALLS_DELTA"), sum(sys_op_opnsize("PARSE_CALLS_DELTA")), substrb(dump(min("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), count("DISK_READS_TOTAL"), count(distinct "DISK_READS_TOTAL"), sum(sys_op_opnsize("DISK_READS_TOTAL")), substrb(dump(min("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), count("DISK_READS_DELTA"), count(distinct "DISK_READS_DELTA"), sum(sys_op_opnsize("DISK_READS_DELTA")), substrb(dump(min("DISK_READS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_DELTA"), 16, 0, 32), 1, 120), count("BUFFER_GETS_TOTAL"), count(distinct "BUFFER_GETS_TOTAL"), sum(sys_op_opnsize("BUFFER_GETS_TOTAL")), substrb(dump(min("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), sub strb(dump(max("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), count("BUFFER_GETS_DELTA"), count(distinct "BUFFER_GETS_DELTA"), sum(sys_op_opnsize("BUFFER_GETS_DELTA")), substrb(dump(min("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120), count("ROWS_PROCESSED_TOTAL"), count(distinct "ROWS_PROCESSED_TOTAL"), sum(sys_op_opnsize("ROWS_PROCESSED_TOTAL")), substrb(dump(min("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120) from "SYS"."WRH$_SQLSTAT" t
cyfauqcw5k0njselect /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count(distinct "ENDPOINT"), count("EPVALUE"), count(distinct "EPVALUE"), count("SPARE1"), count(distinct "SPARE1"), sum(sys_op_opnsize("SPARE1")), substrb(dump(min("SPARE1"), 16, 0, 32), 1, 120), substrb(dump(max("SPARE1"), 16, 0, 32), 1, 120), count("SPARE2"), count(distinct "SPARE2"), sum(sys_op_opnsize("SPARE2")), substrb(dump(min("SPARE2"), 16, 0, 32), 1, 120), substrb(dump(max("SPARE2"), 16, 0, 32), 1, 120) from "SYS"."HISTGRM$" sample ( 25.0000000000) t
d364ff1x8aj7t select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("OBJECT_NODE"), count(distinct "OBJECT_NODE"), sum(sys_op_opnsize("OBJECT_NODE")), substrb(dump(min(substrb("OBJECT_NODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("OBJECT_NODE", 1, 32)), 16, 0, 32), 1, 120), count("OPTIMIZER"), count(distinct "OPTIMIZER"), sum(sys_op_opnsize("OPTIMIZER")), substrb(dump(min("OPTIMIZER"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER"), 16, 0, 32), 1, 120), count("OTHER_TAG"), count(distinct "OTHER_TAG"), sum(sys_op_opnsize("OTHER_TAG")), substrb(dump(min(substrb("OTHER_TAG", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("OTHER_TAG", 1, 32)), 16, 0, 32), 1, 120), count("PARTITION_START"), count(distinct "PARTITION_START"), sum(sys_op_opnsize("PARTITION_START")), substrb(dump(min("PARTITION_START"), 16, 0, 32), 1, 120), substrb(dump(max("PARTITION_START"), 16, 0, 32), 1, 120), count("PARTITION_STOP"), count(distinct "PARTITION_STOP"), sum(sys_op_opnsize("PARTITION_STOP")), substrb(dump(min("PARTITION_STOP"), 16, 0, 32), 1, 120), substrb(dump(max("PARTITION_STOP"), 16, 0, 32), 1, 120), count("PARTITION_ID"), count(distinct "PARTITION_ID"), sum(sys_op_opnsize("PARTITION_ID")), substrb(dump(min("PARTITION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PARTITION_ID"), 16, 0, 32), 1, 120), count("OTHER"), count(distinct "OTHER"), sum(sys_op_opnsize("OTHER")), substrb(dump(min(s ubstrb("OTHER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("OTHER", 1, 32)), 16, 0, 32), 1, 120), count("DISTRIBUTION"), count(distinct "DISTRIBUTION"), sum(sys_op_opnsize("DISTRIBUTION")), substrb(dump(min("DISTRIBUTION"), 16, 0, 32), 1, 120), substrb(dump(max("DISTRIBUTION"), 16, 0, 32), 1, 120), count("TEMP_SPACE"), count(distinct "TEMP_SPACE"), sum(sys_op_opnsize("TEMP_SPACE")), substrb(dump(min("TEMP_SPACE"), 16, 0, 32), 1, 120), substrb(dump(max("TEMP_SPACE"), 16, 0, 32), 1, 120), count("ACCESS_PREDICATES"), count(distinct "ACCESS_PREDICATES"), sum(sys_op_opnsize("ACCESS_PREDICATES")), substrb(dump(min(substrb("ACCESS_PREDICATES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ACCESS_PREDICATES", 1, 32)), 16, 0, 32), 1, 120), count("FILTER_PREDICATES"), count(distinct "FILTER_PREDICATES"), sum(sys_op_opnsize("FILTER_PREDICATES")), substrb(dump(min(substrb("FILTER_PREDICATES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("FILTER_PREDICATES", 1, 32)), 16, 0, 32), 1, 120), count("PROJECTION"), count(distinct "PROJECTION"), sum(sys_op_opnsize("PROJECTION")), substrb(dump(min(substrb("PROJECTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PROJECTION", 1, 32)), 16, 0, 32), 1, 120), count("REMARKS"), count(distinct "REMARKS"), sum(sys_op_opnsize("REMARKS")), substrb(dump(min(substrb("REMARKS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REMARKS", 1, 32)), 16, 0, 32), 1, 120), count(case when "OTHER_XML" is null then null else 1 end), sum(sys_op_opnsize("OTHER_XML")) from "SYS"."WRH$_SQL_PLAN" t
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f5nm3zn5cr5nrselect /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4216, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTHEAD_HISTORY" t where "OBJ#" is not null or "INTCOL#" is not null or SYS_EXTRACT_UTC("SAVTIME") is not null
fr1k4gxy5pt52update dxlogsnote set description=:1 where dxlogsnoteid=:2 and rowstamp=:3
frg5wcfrk4cnrSELECT MAXSEQ.NEXTVAL FROM DUAL
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g337099aatnujupdate smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
gfvjmmmx6vku1select * from wftransaction where wfid = 70997 and memo is not null order by transdate desc
gnvpphhgfm2vqselect count(*) from wftransaction where ownertable = 'WORKORDER' and ownerid = 58670
gxy45w2c1rcv1SELECT /*+NESTED_TABLE_GET_REFS+*/ "MAXIMO"."LOGINTRACKING".* FROM "MAXIMO"."LOGINTRACKING"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 103,683 1.07 0.86
CPU used when call started 60,760 0.63 0.51
CR blocks created 3,017 0.03 0.03
Cached Commit SCN referenced 12,079 0.12 0.10
Commit SCN cached 432 0.00 0.00
DB time 21,419,358 220.45 178.54
DBWR checkpoint buffers written 56,148 0.58 0.47
DBWR checkpoints 42 0.00 0.00
DBWR fusion writes 5,662 0.06 0.05
DBWR transaction table writes 2,784 0.03 0.02
DBWR undo block writes 12,316 0.13 0.10
DFO trees parallelized 917 0.01 0.01
PX local messages recv'd 4,647 0.05 0.04
PX local messages sent 4,647 0.05 0.04
PX remote messages recv'd 3,526 0.04 0.03
PX remote messages sent 4,266 0.04 0.04
Parallel operations not downgraded 917 0.01 0.01
RowCR - row contention 2 0.00 0.00
RowCR attempts 5,582 0.06 0.05
RowCR hits 5,734 0.06 0.05
SMON posted for undo segment shrink 5 0.00 0.00
SQL*Net roundtrips to/from client 3,531,428 36.35 29.44
active txn count during cleanout 2,534 0.03 0.02
application wait time 411 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 375,299 3.86 3.13
branch node splits 3 0.00 0.00
buffer is not pinned count 10,411,772 107.16 86.79
buffer is pinned count 9,708,163 99.92 80.92
bytes received via SQL*Net from client 236,450,367 2,433.53 1,970.90
bytes sent via SQL*Net to client 1,317,023,974 13,554.71 10,977.85
calls to get snapshot scn: kcmgss 1,596,158 16.43 13.30
calls to kcmgas 134,347 1.38 1.12
calls to kcmgcs 3,716 0.04 0.03
change write time 2,015 0.02 0.02
cleanout - number of ktugct calls 4,806 0.05 0.04
cleanouts and rollbacks - consistent read gets 38 0.00 0.00
cleanouts only - consistent read gets 1,707 0.02 0.01
cluster key scan block gets 506,835 5.22 4.22
cluster key scans 165,957 1.71 1.38
cluster wait time 8,286 0.09 0.07
commit batch/immediate performed 18 0.00 0.00
commit batch/immediate requested 18 0.00 0.00
commit cleanout failures: block lost 323 0.00 0.00
commit cleanout failures: callback failure 322 0.00 0.00
commit cleanouts 114,759 1.18 0.96
commit cleanouts successfully completed 114,114 1.17 0.95
commit immediate performed 18 0.00 0.00
commit immediate requested 18 0.00 0.00
commit txn count during cleanout 5,134 0.05 0.04
concurrency wait time 13,266 0.14 0.11
consistent changes 9,726 0.10 0.08
consistent gets 45,602,238 469.33 380.11
consistent gets - examination 5,298,565 54.53 44.17
consistent gets direct 2,178 0.02 0.02
consistent gets from cache 45,599,828 469.31 380.09
cursor authentications 10,744 0.11 0.09
data blocks consistent reads - undo records applied 4,478 0.05 0.04
db block changes 989,528 10.18 8.25
db block gets 955,775 9.84 7.97
db block gets direct 2,165 0.02 0.02
db block gets from cache 953,610 9.81 7.95
deferred (CURRENT) block cleanout applications 64,589 0.66 0.54
dirty buffers inspected 3 0.00 0.00
enqueue conversions 56,333 0.58 0.47
enqueue releases 2,476,820 25.49 20.65
enqueue requests 2,477,685 25.50 20.65
enqueue timeouts 866 0.01 0.01
enqueue waits 21,652 0.22 0.18
execute count 800,092 8.23 6.67
failed probes on index block reclamation 1 0.00 0.00
free buffer inspected 444,239 4.57 3.70
free buffer requested 650,108 6.69 5.42
gc CPU used by this session 22,794 0.23 0.19
gc blocks lost 7 0.00 0.00
gc cr block build time 53 0.00 0.00
gc cr block flush time 127 0.00 0.00
gc cr block receive time 5,552 0.06 0.05
gc cr block send time 122 0.00 0.00
gc cr blocks received 101,203 1.04 0.84
gc cr blocks served 35,426 0.36 0.30
gc current block flush time 75 0.00 0.00
gc current block pin time 26 0.00 0.00
gc current block receive time 9,947 0.10 0.08
gc current block send time 78 0.00 0.00
gc current blocks received 125,010 1.29 1.04
gc current blocks served 23,284 0.24 0.19
gc local grants 124,591 1.28 1.04
gc remote grants 265,347 2.73 2.21
gcs messages sent 762,822 7.85 6.36
ges messages sent 181,212 1.87 1.51
global enqueue get time 65,530 0.67 0.55
global enqueue gets async 67,809 0.70 0.57
global enqueue gets sync 557,367 5.74 4.65
global enqueue releases 544,832 5.61 4.54
heap block compress 2,978 0.03 0.02
hot buffers moved to head of LRU 95,240 0.98 0.79
immediate (CR) block cleanout applications 1,745 0.02 0.01
immediate (CURRENT) block cleanout applications 21,008 0.22 0.18
index crx upgrade (positioned) 123,240 1.27 1.03
index fast full scans (full) 3,150 0.03 0.03
index fetch by key 2,881,511 29.66 24.02
index scans kdiixs1 2,251,366 23.17 18.77
leaf node 90-10 splits 385 0.00 0.00
leaf node splits 1,106 0.01 0.01
lob reads 9,691 0.10 0.08
lob writes 10,716 0.11 0.09
lob writes unaligned 10,716 0.11 0.09
logons cumulative 4,721 0.05 0.04
messages received 166,213 1.71 1.39
messages sent 166,181 1.71 1.39
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 39,653,905 408.11 330.53
opened cursors cumulative 548,233 5.64 4.57
parse count (failures) 49 0.00 0.00
parse count (hard) 29,354 0.30 0.24
parse count (total) 507,446 5.22 4.23
parse time cpu 9,427 0.10 0.08
parse time elapsed 11,763 0.12 0.10
physical read IO requests 160,958 1.66 1.34
physical read bytes 3,094,519,808 31,848.56 25,793.90
physical read total IO requests 404,324 4.16 3.37
physical read total bytes 7,199,583,232 74,097.56 60,011.03
physical read total multi block requests 18,941 0.19 0.16
physical reads 377,749 3.89 3.15
physical reads cache 375,571 3.87 3.13
physical reads cache prefetch 318,138 3.27 2.65
physical reads direct 2,178 0.02 0.02
physical reads direct (lob) 2,053 0.02 0.02
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 5,473 0.06 0.05
physical write IO requests 46,867 0.48 0.39
physical write bytes 517,373,952 5,324.77 4,312.49
physical write total IO requests 165,655 1.70 1.38
physical write total bytes 2,425,015,296 24,958.07 20,213.35
physical write total multi block requests 17,559 0.18 0.15
physical writes 63,156 0.65 0.53
physical writes direct 2,165 0.02 0.02
physical writes direct (lob) 125 0.00 0.00
physical writes direct temporary tablespace 2,040 0.02 0.02
physical writes from cache 60,991 0.63 0.51
physical writes non checkpoint 31,353 0.32 0.26
pinned buffers inspected 610 0.01 0.01
prefetch clients - default 20 0.00 0.00
prefetch warmup blocks aged out before use 6,747 0.07 0.06
prefetched blocks aged out before use 66,346 0.68 0.55
process last non-idle time 91,845 0.95 0.77
queries parallelized 629 0.01 0.01
recursive calls 3,350,104 34.48 27.92
recursive cpu usage 38,424 0.40 0.32
redo blocks written 195,002 2.01 1.63
redo buffer allocation retries 2 0.00 0.00
redo entries 557,150 5.73 4.64
redo log space requests 2 0.00 0.00
redo log space wait time 46 0.00 0.00
redo ordering marks 9,297 0.10 0.08
redo size 184,391,400 1,897.74 1,536.97
redo subscn max counts 11,282 0.12 0.09
redo synch time 7,576 0.08 0.06
redo synch writes 157,093 1.62 1.31
redo wastage 12,291,800 126.51 102.46
redo write time 21,708 0.22 0.18
redo writer latching time 1 0.00 0.00
redo writes 22,029 0.23 0.18
rollback changes - undo records applied 3 0.00 0.00
rollbacks only - consistent read gets 2,960 0.03 0.02
rows fetched via callback 1,904,818 19.60 15.88
session connect time 0 0.00 0.00
session cursor cache hits 297,713 3.06 2.48
session logical reads 46,558,503 479.18 388.08
session pga memory 5,374,450,528 55,313.44 44,797.91
session pga memory max 9,329,388,320 96,017.35 77,763.70
session uga memory ############### 102,641,504.90 83,128,542.98
session uga memory max 5,368,461,840 55,251.80 44,748.00
shared hash latch upgrades - no wait 148,792 1.53 1.24
sorts (memory) 192,977 1.99 1.61
sorts (rows) 37,780,423 388.83 314.91
sql area evicted 444 0.00 0.00
sql area purged 131 0.00 0.00
summed dirty queue length 3 0.00 0.00
switch current to new buffer 1,168 0.01 0.01
table fetch by rowid 5,445,164 56.04 45.39
table fetch continued row 613,585 6.31 5.11
table scan blocks gotten 10,645,798 109.57 88.74
table scan rows gotten 721,242,332 7,422.97 6,011.81
table scans (long tables) 6 0.00 0.00
table scans (short tables) 150,013 1.54 1.25
total number of times SMON posted 110 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 18 0.00 0.00
undo change vector size 63,930,840 657.97 532.89
user I/O wait time 41,259 0.42 0.34
user calls 3,540,310 36.44 29.51
user commits 22,487 0.23 0.19
user rollbacks 97,484 1.00 0.81
workarea executions - optimal 118,685 1.22 0.99
write clones created in foreground 3 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 1,709 50,598
opened cursors current 191 657
logons current 41 75

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 0.04

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)
TS_MAXIMO_DATA 134,065 1 2.46 2.50 15,501 0 2 0.00
SYSAUX 10,231 0 4.53 1.90 19,645 0 2 0.00
SYSTEM 6,068 0 2.89 1.54 5,001 0 0 0.00
UNDOTBS3 0 0 0.00 0.00 6,276 0 6 0.00
THAMS 5,860 0 2.46 1.00 0 0 0 0.00
HUSSAR 3,969 0 3.01 1.02 13 0 0 0.00
TEMP 129 0 3.95 13.54 324 0 0 0.00
TS_MAX60TEST_DATA 342 0 4.88 5.01 107 0 0 0.00
OA 231 0 2.77 1.53 0 0 0 0.00
USERS 80 0 3.50 1.00 0 0 0 0.00
TS_MAX60TEST2_DATA 5 0 2.00 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HUSSAR /dev/vgora/rdatafile4_03 3,969 0 3.01 1.02 13 0 0 0.00
OA /dev/vgora/rdatafile10_01 44 0 5.23 1.89 0 0 0 0.00
OA /dev/vgora/rdatafile10_02 97 0 2.37 1.37 0 0 0 0.00
OA /dev/vgora/rdatafile10_03 90 0 2.00 1.52 0 0 0 0.00
SYSAUX /dev/vgora/rsysaux 10,231 0 4.53 1.90 19,645 0 2 0.00
SYSTEM /dev/vgora/rsystem 6,068 0 2.89 1.54 5,001 0 0 0.00
TEMP /dev/vgora/rtemp 129 0 3.95 13.54 324 0 0  
THAMS /dev/vgora/rdatafile10_20 5,860 0 2.46 1.00 0 0 0 0.00
TS_MAX60TEST2_DATA /dev/vgora/rmaxtest2 5 0 2.00 1.00 0 0 0 0.00
TS_MAX60TEST_DATA /dev/vgora/rmaxtest 342 0 4.88 5.01 107 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata1 18,803 0 2.35 2.59 1,462 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata2 20,910 0 2.52 2.28 2,826 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata3 14,204 0 2.84 2.75 1,162 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata4 16,038 0 2.39 2.37 440 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata5 15,033 0 2.45 2.49 1,032 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata6 15,647 0 2.26 2.30 1,378 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata7 14,873 0 2.31 2.48 3,638 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata8 18,557 0 2.55 2.78 3,563 0 2 0.00
UNDOTBS3 /dev/vgora/rdatafile4_01 0 0     6,276 0 6 0.00
USERS /dev/vgora/rusers 80 0 3.50 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 230,280 99 46,577,107 375,593 60,858 0 0 10
K 3,838 100 35,366 0 133 0 0 0


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 21 701 1661 3687 232200 3687  
E 0 20 323 479 1682 232200 1682  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 192 0.10 23,028 2.40 929,158
D 384 0.20 46,056 1.48 573,415
D 576 0.30 69,084 1.36 527,746
D 768 0.40 92,112 1.26 488,533
D 960 0.50 115,140 1.22 472,660
D 1,152 0.60 138,168 1.18 455,607
D 1,344 0.70 161,196 1.14 442,825
D 1,536 0.80 184,224 1.12 432,098
D 1,728 0.90 207,252 1.05 406,755
D 1,920 1.00 230,280 1.00 387,542
D 2,112 1.10 253,308 1.00 387,542
D 2,304 1.20 276,336 1.00 387,542
D 2,496 1.30 299,364 1.00 387,542
D 2,688 1.40 322,392 1.00 387,542
D 2,880 1.50 345,420 1.00 387,542
D 3,072 1.60 368,448 1.00 387,542
D 3,264 1.70 391,476 1.00 387,542
D 3,456 1.80 414,504 1.00 387,542
D 3,648 1.90 437,532 1.00 387,542
D 3,840 2.00 460,560 0.98 381,072
K 16 0.50 1,919 1.00 0
K 32 1.00 3,838 1.00 0
K 48 1.50 5,757 1.00 0
K 64 2.00 7,676 1.00 0

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 10,713 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,760 278.39 64.65 23.22 100.00 0.00 209,710
E 2,048 1,691 331.73 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 111,228 111,228 0 0
64K 128K 376 376 0 0
128K 256K 120 120 0 0
256K 512K 73 73 0 0
512K 1024K 5,187 5,187 0 0
1M 2M 1,583 1,583 0 0
2M 4M 68 68 0 0
4M 8M 12 12 0 0
8M 16M 2 2 0 0
32M 64M 10 10 0 0
64M 128M 49 49 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 11,002.88 3,682.78 75.00 0
512 0.25 11,002.88 351.86 97.00 0
1,024 0.50 11,002.88 0.00 100.00 0
1,536 0.75 11,002.88 0.00 100.00 0
2,048 1.00 11,002.88 0.00 100.00 0
2,458 1.20 11,002.88 0.00 100.00 0
2,867 1.40 11,002.88 0.00 100.00 0
3,277 1.60 11,002.88 0.00 100.00 0
3,686 1.80 11,002.88 0.00 100.00 0
4,096 2.00 11,002.88 0.00 100.00 0
6,144 3.00 11,002.88 0.00 100.00 0
8,192 4.00 11,002.88 0.00 100.00 0
12,288 6.00 11,002.88 0.00 100.00 0
16,384 8.00 11,002.88 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
640 0.26 288 24,836 191,713 0.94 11,390 70.75 1,113,922
896 0.37 539 36,329 199,893 0.99 3,210 19.94 1,118,408
1,152 0.47 791 45,685 202,942 1.00 161 1.00 1,119,808
1,408 0.58 929 52,687 202,942 1.00 161 1.00 1,119,845
1,664 0.68 929 52,687 202,942 1.00 161 1.00 1,119,845
1,920 0.79 929 52,687 202,942 1.00 161 1.00 1,119,845
2,176 0.89 929 52,687 202,942 1.00 161 1.00 1,119,845
2,432 1.00 929 52,687 202,942 1.00 161 1.00 1,119,845
2,688 1.11 929 52,687 202,942 1.00 161 1.00 1,119,845
2,944 1.21 929 52,687 202,942 1.00 161 1.00 1,119,845
3,200 1.32 929 52,687 202,942 1.00 161 1.00 1,119,845
3,456 1.42 929 52,687 202,942 1.00 161 1.00 1,119,845
3,712 1.53 929 52,687 202,942 1.00 161 1.00 1,119,845
3,968 1.63 929 52,687 202,942 1.00 161 1.00 1,119,845
4,224 1.74 929 52,687 202,942 1.00 161 1.00 1,119,845
4,480 1.84 929 52,687 202,942 1.00 161 1.00 1,119,845
4,736 1.95 929 52,687 202,942 1.00 161 1.00 1,119,845
4,992 2.05 929 52,687 202,942 1.00 161 1.00 1,119,845

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

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 7 88 3 1.00 161 1.00 88
32 1.00 7 88 3 1.00 161 1.00 88
48 1.50 7 88 3 1.00 161 1.00 88
64 2.00 7 88 3 1.00 161 1.00 88

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header 6 0 0
data block 4 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
US-Undo Segment 18,212 18,212 0 17,390 5 0.29
WF-AWR Flush 768 766 2 630 3 5.16
PS-PX Process Reservation 7,106 6,242 864 2,087 1 0.54
JS-Job Scheduler (queue lock) 952,493 952,493 0 102 0 3.12
CF-Controlfile Transaction 218,199 218,199 0 26 0 10.96
JS-Job Scheduler (job run lock - synchronize) 708 708 0 131 0 1.44
TM-DML 150,414 150,414 0 346 0 0.45
TA-Instance Undo 325 325 0 299 0 0.41
TD-KTF map table enqueue (KTF dump entries) 206 206 0 206 0 0.36
DR-Distributed Recovery 54 54 0 54 0 0.54
PI-Remote PX Process Spawn Status 208 208 0 64 0 0.42
TT-Tablespace 15,476 15,476 0 56 0 0.43
RO-Multiple Object Reuse (fast object reuse) 164 164 0 69 0 0.28
MW-MWIN Schedule 54 54 0 54 0 0.31
PR-Process Startup 1,367 1,367 0 1 0 14.00
UL-User-defined 1,282 1,282 0 43 0 0.28
AF-Advisor Framework (task serialization) 239 239 0 14 0 0.79
FB-Format Block 138 138 0 26 0 0.38
TO-Temp Object 65 65 0 29 0 0.17
HW-Segment High Water Mark 5,591 5,591 0 18 0 0.28
MD-Materialized View Log DDL 27 27 0 14 0 0.36
SK-Shrink Segment 17 17 0 8 0 0.63
TX-Transaction (index contention) 5 5 0 4 0 0.25
JS-Job Scheduler (wdw op) 3 3 0 2 0 0.50

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
21 9.17 37,925 3,217 5 5760/5760 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
26-May 11:55 28 229 2,418 3 5,760 0/0 0/0/0/0/0/0
26-May 11:45 11 123 1,811 3 5,760 0/0 0/0/0/0/0/0
26-May 11:35 23 254 1,206 2 5,760 0/0 0/0/0/0/0/0
26-May 11:25 13 154 602 2 5,760 0/0 0/0/0/0/0/0
26-May 11:15 35 370 168 2 5,760 0/0 0/0/0/0/0/0
26-May 11:05 79 196 2,240 3 5,760 0/0 0/0/0/0/0/0
26-May 10:55 46 258 1,636 2 5,760 0/0 0/0/0/0/0/0
26-May 10:45 36 156 1,033 3 5,760 0/0 0/0/0/0/0/0
26-May 10:35 19 257 1,320 3 5,760 0/0 0/0/0/0/0/0
26-May 10:25 10 117 713 2 5,760 0/0 0/0/0/0/0/0
26-May 10:15 20 337 1,254 2 5,760 0/0 0/0/0/0/0/0
26-May 10:05 82 219 69 3 5,760 0/0 0/0/0/0/0/0
26-May 09:55 36 315 2,065 3 5,760 0/0 0/0/0/0/0/0
26-May 09:45 30 365 2,756 2 5,760 0/0 0/0/0/0/0/0
26-May 09:35 13 208 2,151 1 5,760 0/0 0/0/0/0/0/0
26-May 09:25 42 164 2,570 3 5,760 0/0 0/0/0/0/0/0
26-May 09:15 8 319 1,966 1 5,760 0/0 0/0/0/0/0/0
26-May 09:05 101 231 1,362 3 5,760 0/0 0/0/0/0/0/0
26-May 08:55 27 314 757 2 5,760 0/0 0/0/0/0/0/0
26-May 08:45 20 192 153 3 5,760 0/0 0/0/0/0/0/0
26-May 08:35 16 242 0 2 5,760 0/0 0/0/0/0/0/0
26-May 08:25 17 136 0 2 5,760 0/0 0/0/0/0/0/0
26-May 08:15 8 258 0 2 5,760 0/0 0/0/0/0/0/0
26-May 08:05 86 201 0 3 5,760 0/0 0/0/0/0/0/0
26-May 07:55 12 188 0 3 5,760 0/0 0/0/0/0/0/0
26-May 07:45 12 129 0 3 5,760 0/0 0/0/0/0/0/0
26-May 07:35 12 170 2,153 3 5,760 0/0 0/0/0/0/0/0
26-May 07:25 7 122 1,549 1 5,760 0/0 0/0/0/0/0/0
26-May 07:15 6 262 944 1 5,760 0/0 0/0/0/0/0/0
26-May 07:05 91 225 482 3 5,760 0/0 0/0/0/0/0/0
26-May 06:55 17 167 0 3 5,760 0/0 0/0/0/0/0/0
26-May 06:45 8 122 0 2 5,760 0/0 0/0/0/0/0/0
26-May 06:35 8 139 0 1 5,760 0/0 0/0/0/0/0/0
26-May 06:25 9 118 0 3 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 73,918 0.00   0 0  
AWR Alerted Metric Element list 529,767 0.00   0 0  
Consistent RBA 22,041 0.00 0.00 0 0  
FAL request queue 1,943 0.00   0 0  
FAL subheap alocation 1,943 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 5,202 0.00   0 0  
JOX SGA heap latch 1,541 0.00   0 1,147 0.00
JS Sh mem access 800 13.88 1.00 0 0  
JS broadcast add buf latch 55,532 0.00   0 0  
JS broadcast drop buf latch 55,560 0.00   0 0  
JS broadcast kill buf latch 3 0.00   0 0  
JS broadcast load blnc latch 52,728 0.00   0 0  
JS mem alloc latch 1,962 0.00   0 0  
JS queue access latch 1,962 0.00   0 0  
JS queue state obj latch 1,904,986 0.00   0 0  
JS slv state obj latch 10,226 0.00   0 0  
KCL gc element parent latch 2,553,983 0.01 0.08 0 2,184 0.00
KJC message pool free list 102,653 0.01 0.57 0 25,845 0.00
KJCT flow control latch 903,188 0.00 0.21 0 0  
KMG MMAN ready and startup request latch 32,373 0.00   0 0  
KSXR large replies 6,524 0.00   0 0  
KTF sga latch 416 0.00   0 29,734 0.00
KWQMN job cache list latch 8,352 0.00   0 0  
MQL Tracking Latch 0     0 1,929 0.00
Memory Management Latch 0     0 32,373 0.00
NLS data objects 1 0.00   0 0  
OS process 12,486 0.00   0 0  
OS process allocation 40,738 0.00   0 0  
OS process: request allocation 2,891 0.00   0 0  
PL/SQL warning settings 22,307 0.00   0 0  
QMT 1 0.00   0 0  
SGA IO buffer pool latch 18,768 0.00   0 18,768 0.00
SQL memory manager latch 27 0.00   0 32,085 0.00
SQL memory manager workarea list latch 2,222,358 0.00   0 0  
Shared B-Tree 3,447 0.00   0 0  
active checkpoint queue latch 81,028 0.00   0 0  
active service list 495,007 0.00 0.25 0 32,639 0.00
archive control 1,623 0.00   0 0  
archive process latch 34,028 0.00 1.00 0 0  
begin backup scn array 125 0.00   0 0  
business card 1,834 0.00   0 0  
cache buffer handles 10,004 0.00   0 0  
cache buffers chains 91,320,562 0.00 0.04 0 1,516,403 0.00
cache buffers lru chain 903,140 0.05 0.06 0 758,905 0.05
cache table scan latch 0     0 17,699 0.06
channel handle pool latch 3,372 0.00   0 0  
channel operations parent latch 6,303,026 0.01 0.01 0 0  
checkpoint queue latch 1,172,176 0.00   0 65,833 0.00
client/application info 54,603 0.00   0 0  
commit callback allocation 1,666 0.00   0 0  
compile environment latch 280,728 0.00   0 0  
dictionary lookup 41 0.00   0 0  
dml lock allocation 302,380 0.00 0.00 0 0  
dummy allocation 9,697 0.00   0 0  
enqueue hash chains 5,424,371 0.00 0.05 0 273 0.00
enqueues 4,850,130 0.00 0.16 0 0  
error message lists 3,975 0.00   0 0  
event group latch 1,463 0.00   0 0  
file cache latch 13,470 0.00   0 0  
gcs drop object freelist 924 0.00   0 0  
gcs opaque info freelist 130,368 0.00   0 0  
gcs partitioned table hash 4,051,656 0.00 0.00 0 0  
gcs remaster request queue 3 0.00   0 0  
gcs remastering latch 694,686 0.00 0.00 0 0  
gcs resource freelist 213,689 0.23 0.00 0 3,370 0.00
gcs resource hash 1,890,412 0.03 0.25 0 300 0.00
gcs resource scan list 600 0.00   0 0  
gcs shadows freelist 37,194 0.00   0 10,707 0.00
ges caches resource lists 376,094 0.02 0.22 0 1,054,137 0.00
ges deadlock list 27,460 0.00   0 56 0.00
ges domain table 1,022,110 0.00   0 0  
ges enqueue table freelist 1,186,995 0.00 0.04 0 0  
ges group table 1,510,936 0.00   0 0  
ges process hash list 102,707 0.02 1.00 0 0  
ges process parent latch 2,499,593 0.00 0.06 0 0  
ges process table freelist 2,891 0.00   0 0  
ges resource hash list 2,080,758 0.48 0.96 0 162,992 0.02
ges resource scan list 5,559 0.00   0 0  
ges resource table freelist 224,642 0.00 0.50 0 0  
ges synchronous data 32 3.13 0.00 0 12,386 0.00
ges timeout list 74,226 0.00   0 62,107 0.00
global KZLD latch for mem in SGA 96 0.00   0 0  
hash table column usage latch 6,289 0.00   0 943,269 0.00
hash table modification latch 2,068 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 4,646 0.00
job_queue_processes free list latch 1 0.00   0 0  
job_queue_processes parameter latch 3,613 0.00   0 0  
kks stats 57,582 0.00   0 0  
kmcptab latch 6 0.00   0 0  
kmcpvec latch 0     0 6 0.00
ksuosstats global area 6,531 0.00   0 0  
ktm global data 438 0.00   0 0  
kwqbsn:qsga 3,447 0.00   0 0  
lgwr LWN SCN 44,273 0.00   0 0  
library cache 4,192,752 0.00 0.13 0 1,002 0.00
library cache load lock 57,250 0.00   0 0  
library cache lock 2,562,252 0.00 0.23 0 0  
library cache lock allocation 66,023 0.00   0 0  
library cache pin 1,511,647 0.00 0.00 0 48 0.00
library cache pin allocation 16,120 0.00   0 0  
list of block allocation 7,709 0.00   0 0  
loader state object freelist 2,590 0.00   0 0  
longop free list parent 283 0.00   0 298 0.00
message pool operations parent latch 22,732 0.00   0 0  
messages 3,304,001 0.01 0.16 0 0  
mostly latch-free SCN 44,300 0.05 0.00 0 0  
multiblock read objects 145,278 0.00 0.00 0 0  
name-service memory objects 63,124 0.00   0 0  
name-service namespace bucket 973,106 0.00   0 0  
name-service namespace objects 278 0.00   0 0  
name-service pending queue 27,202 0.00   0 0  
name-service request 858 0.00   0 0  
name-service request queue 969,820 0.00   0 0  
ncodef allocation latch 1,554 0.00   0 0  
object queue header heap 168,007 0.00   0 2,853 0.00
object queue header operation 1,490,974 0.00 0.11 0 0  
object stats modification 1,591 0.00   0 0  
parallel query alloc buffer 31,476 0.00   0 0  
parallel query stats 3,543 0.00   0 0  
parallel txn reco latch 18,088 0.00   0 0  
parameter list 462 0.00   0 0  
parameter table allocation management 5,974 0.00   0 0  
post/wait queue 23,870 0.00   0 8,969 0.00
process allocation 932,082 0.00 0.70 0 1,462 0.07
process group creation 2,891 0.00   0 0  
process queue 10,079 0.00   0 0  
process queue reference 177,433 0.01 0.00 0 17,449 2353.65
qm_init_sga 1 0.00   0 0  
qmn task queue latch 13,788 15.03 0.99 0 0  
query server freelists 8,543 0.00   0 0  
query server process 143 0.00   0 143 0.00
queued dump request 479,432 0.00   0 0  
redo allocation 110,611 0.01 0.33 0 557,594 0.00
redo copy 0     0 557,599 0.08
redo writing 214,323 0.00   0 0  
resmgr group change latch 11,614 0.00   0 0  
resmgr:actses active list 9,610 0.00   0 0  
resmgr:actses change group 3,499 0.00   0 0  
resmgr:free threads list 9,583 0.00   0 0  
resmgr:schema config 27 0.00   0 0  
row cache objects 9,332,009 0.04 0.00 0 6,548 0.00
rules engine aggregate statistics 833 0.00   0 0  
rules engine rule set statistics 1,666 0.00   0 0  
sequence cache 72,464 0.00   0 0  
session allocation 1,980,060 0.01 0.03 0 0  
session idle bit 7,356,963 0.00 0.08 0 0  
session state list latch 10,755 0.00   0 0  
session switching 1,554 0.00   0 0  
session timer 32,639 0.00   0 0  
shared pool 3,794,190 0.01 0.04 0 0  
shared pool sim alloc 2,143 0.00   0 0  
shared pool simulator 464,085 0.00   0 0  
simulator hash latch 3,005,382 0.00   0 0  
simulator lru latch 2,913,371 0.00 0.02 0 40,223 0.00
slave class 57 0.00   0 0  
slave class create 228 11.84 1.00 2 0  
sort extent pool 3,244 0.00   0 0  
state object free list 54 0.00   0 0  
statistics aggregation 3,780 0.00   0 0  
temp lob duration state obj allocation 8 0.00   0 0  
temporary table state object allocation 8 0.00   0 0  
threshold alerts latch 8,231 0.00   0 0  
trace latch 36 0.00   0 0  
transaction allocation 7,655 0.00   0 0  
transaction branch allocation 1,554 0.00   0 0  
undo global data 151,681 0.00   0 0  
user lock 6,958 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
ges resource hash list 2,080,758 9,972 9,531 443 0 0 0
row cache objects 9,332,009 3,502 4 3,498 0 0 0
qmn task queue latch 13,788 2,072 2,061 11 0 0 0
gcs resource hash 1,890,412 592 147 445 0 0 0
gcs resource freelist 213,689 500 1 499 0 0 0
cache buffers lru chain 903,140 463 29 434 0 0 0
channel operations parent latch 6,303,026 340 2 338 0 0 0
shared pool 3,794,190 318 14 304 0 0 0
session allocation 1,980,060 203 6 197 0 0 0
messages 3,304,001 184 29 155 0 0 0
KCL gc element parent latch 2,553,983 158 12 146 0 0 0
simulator lru latch 2,913,371 121 3 118 0 0 0
JS Sh mem access 800 111 111 0 0 0 0
enqueues 4,850,130 104 17 87 0 0 0
library cache 4,192,752 103 13 92 0 0 0
enqueue hash chains 5,424,371 75 4 71 0 0 0
ges caches resource lists 376,094 67 15 52 0 0 0
ges enqueue table freelist 1,186,995 48 2 46 0 0 0
ges process parent latch 2,499,593 47 3 44 0 0 0
KJCT flow control latch 903,188 28 6 22 0 0 0
slave class create 228 27 27 0 0 0 0
cache buffers chains 91,320,562 24 1 23 0 0 0
session idle bit 7,356,963 24 2 22 0 0 0
ges process hash list 102,707 19 19 0 0 0 0
library cache lock 2,562,252 13 3 10 0 0 0
process allocation 932,082 10 7 3 0 0 0
object queue header operation 1,490,974 9 1 8 0 0 0
redo allocation 110,611 9 3 6 0 0 0
KJC message pool free list 102,653 7 4 3 0 0 0
active service list 495,007 4 1 3 0 0 0
ges resource table freelist 224,642 2 1 1 0 0 0
archive process latch 34,028 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
JS Sh mem access jsksGetShMemLatch 0 111 111
KCL gc element parent latch kclnfndnewm 0 6 5
KCL gc element parent latch kclplz 0 3 3
KCL gc element parent latch kclzcl 0 2 0
KCL gc element parent latch kclliter 0 1 0
KCL gc element parent latch kclpto 0 1 0
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 4 0
KJCT flow control latch kjctcsnd: send normal message 0 3 3
KJCT flow control latch kjcts_sqenq: queue a message 0 3 3
active service list kswssyis: find service entry 1 0 1 0
archive process latch kcrrgpll 0 1 0
cache buffers chains kcbrls: kslbegin 0 1 0
cache buffers lru chain kcbzgws_1 0 27 28
cache buffers lru chain kcbzfw 0 1 0
cache buffers lru chain kclwcrs 0 1 0
channel operations parent latch ksrmfree() 0 1 0
channel operations parent latch ksrpubwait():1 0 1 1
channel operations parent latch ksrwait() 0 1 2
enqueue hash chains ksqgtl3 0 2 2
enqueue hash chains ksqrcl 0 2 0
enqueues ksqgel: create enqueue 0 14 3
enqueues ksqdel 0 3 8
event range base latch No latch 0 2,061 2,061
gcs resource freelist kjbralc_bg: add resource 0 1 1
gcs resource hash kjbcrcomplete 0 88 1
gcs resource hash kjbassume 0 44 1
gcs resource hash kjbldrmrpst 0 12 0
gcs resource hash kclzcl 0 1 4
gcs resource hash kjblocalfile_nolock 0 1 0
gcs resource hash kjbmdowncvt 0 1 53
ges enqueue table freelist kjlalc: lock allocation 0 1 0
ges enqueue table freelist kjlfr: remove lock from parent object 0 1 2
ges process hash list kjakiqa: set inquiry response 0 19 0
ges process parent latch kjatioc 0 2 0
ges process parent latch kjatb 0 1 2
ges resource hash list kjakcai: search for resp by resname 0 4,482 52
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 3,426 6
ges resource hash list kjrmas1: lookup master node 0 815 0
ges resource hash list kjlrlr: remove lock from resource queue 0 522 4,873
ges resource hash list kjucvl: lock convert request 0 138 4,705
ges resource hash list kjcvscn: remove from scan queue 0 136 0
ges resource hash list kjrref: find matched resource 0 11 67
ges resource table freelist kjruch: cached obj cleanup 0 7 0
ges resource table freelist kjchc: clean resource cache 0 6 0
ges resource table freelist kjrchc: cached obj cleanup 0 2 0
ges resource table freelist kjrchc: move resource from cache to kjrparent 0 1 0
library cache kglScanDependency 0 3 0
library cache kglobpn: child: 0 3 3
library cache kglhdgn: child: 0 2 3
library cache kglpndl: child: before processing 0 2 0
library cache kglati 0 1 0
library cache kgldte: child 0 0 1 3
library cache kglpndl: child: after processing 0 1 0
library cache lock kgllkal: child: multiinstance 0 2 2
library cache lock kgllkdl: child: cleanup 0 1 1
messages ksarcv: after wait 0 19 20
messages ksarcv 0 7 4
messages ksaamb: after wakeup 0 3 5
object queue header operation kcbo_switch_cq 0 1 0
process allocation ksucrp 0 4 0
process allocation ksufap: active procs 0 3 4
redo allocation kcrfw_redo_gen: redo allocation 1 0 3 0
row cache objects kqreqd 0 2 0
row cache objects kqrpre: find obj 0 1 2
row cache objects ksucallcbksafely: kqrhngc 0 1 0
session allocation ksudlc 0 2 1
session allocation ksuxds: KSUSFCLC not set 0 2 0
session allocation ksuxds: KSUSFCLC set 0 2 0
session idle bit ksupuc: clear busy 0 1 0
session idle bit ksuxds 0 1 1
shared pool kghalo 0 9 6
shared pool kghfre 0 4 3
shared pool kghupr1 0 1 5
simulator lru latch kcbs_simulate: simulate set 0 3 3
slave class create ksvcreate 0 27 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
CTXSYS SYSAUX SYS_IOT_TOP_40951   INDEX 21,623,744 46.44
MAXIMO TS_MAXIMO_DATA WORKORDER   TABLE 3,013,840 6.47
MAXIMO TS_MAXIMO_DATA MAXMENU   TABLE 2,145,376 4.61
MAXIMO TS_MAXIMO_DATA DXLOGSNOTE   TABLE 2,000,608 4.30
MAXIMO TS_MAXIMO_DATA ITEM   TABLE 1,639,648 3.52

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 225,144 59.60
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT_ORID   INDEX 16,345 4.33
MAXIMO TS_MAXIMO_DATA DR$WFASSIGNMDES_TIDX$I   TABLE 13,688 3.62
MAXIMO TS_MAXIMO_DATA DXLOGSETMODE   TABLE 10,617 2.81
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX2   INDEX 8,446 2.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
MAXIMO TS_MAX60TEST_DATA WOTHRJPREC   TABLE 2 28.57
SYS SYSAUX WRH$_SQLSTAT_INDEX 7962_36089 INDEX PARTITION 2 28.57
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX1   INDEX 1 14.29
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX2   INDEX 1 14.29
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX3   INDEX 1 14.29

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
MAXIMO TS_MAXIMO_DATA MAXSESSION_NDX   INDEX 2 50.00
CTXSYS SYSAUX SYS_IOT_TOP_40951   INDEX 2 50.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SYS SYSAUX WRH$_SQL_PLAN   TABLE 6,256 6.18
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 5,145 5.08
MAXIMO TS_MAXIMO_DATA WFTRANSACTION_NDX1   INDEX 4,165 4.12
SYS SYSAUX WRH$_WAITCLASSMETRIC_HIST_IND   INDEX 2,925 2.89
SYS SYSTEM HISTGRM$   TABLE 2,792 2.76

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
MAXIMO TS_MAXIMO_DATA WFTRANSACTION   TABLE 22,264 17.81
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 15,699 12.56
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX3   INDEX 15,633 12.51
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX2   INDEX 4,431 3.54
CTXSYS SYSAUX DRC$DEL_KEY   INDEX 2,907 2.33

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 1,801 0.11 0   54 1
dc_constraints 426 33.57 0   426 1
dc_files 115 20.00 0   0 23
dc_global_oids 99,242 0.12 0   0 175
dc_histogram_data 725,865 0.97 0   5,067 9,602
dc_histogram_defs 802,843 2.00 0   3,671 13,906
dc_object_grants 53,504 0.87 0   0 712
dc_object_ids 902,610 0.25 0   35 3,234
dc_objects 103,326 2.47 0   892 3,038
dc_profiles 3,124 0.00 0   0 1
dc_rollback_segments 52,710 0.00 0   0 58
dc_segments 177,427 1.57 0   47 3,685
dc_sequences 976 32.89 0   976 19
dc_table_scns 27 100.00 0   0 0
dc_tablespaces 169,313 0.00 0   0 24
dc_usernames 18,845 0.08 0   0 26
dc_users 427,639 0.01 0   0 78
global database name 1 100.00 0   0 1
outstanding_alerts 3,692 73.10 0   832 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 110 2 0
dc_constraints 710 0 0
dc_files 23 0 0
dc_global_oids 121 0 0
dc_histogram_defs 20,746 0 0
dc_object_ids 2,307 40 0
dc_objects 4,379 83 0
dc_segments 2,873 161 0
dc_sequences 1,952 313 0
dc_table_scns 27 0 0
dc_tablespaces 1 0 0
dc_usernames 16 0 0
dc_users 17 0 0
global database name 1 0 0
outstanding_alerts 6,751 2,296 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 28,840 0.24 72,388 0.10 0 0
CLUSTER 256 0.78 676 0.30 0 0
INDEX 484 59.71 2,795 18.46 10 0
JAVA DATA 3 100.00 512 0.78 0 0
SQL AREA 28,196 99.68 1,041,478 8.17 338 471
TABLE/PROCEDURE 38,902 5.40 413,104 1.46 863 0
TRIGGER 3,152 1.49 15,713 0.30 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 676 7 1 3 0
INDEX 2,795 853 220 589 0
TABLE/PROCEDURE 118,698 6,571 230 4,821 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 193.59   4.40 7.21 22 22 44 44
  SQL 66.16 65.38 2.36 12.02 64 64 28 22
  Freeable 18.13 0.00 0.86 0.57 2   21 21
  PL/SQL 0.53 0.36 0.01 0.02 0 0 42 41
E Other 279.76   3.59 5.66 22 22 78 78
  Freeable 48.88 0.00 0.87 0.29 2   56 56
  PL/SQL 1.77 1.20 0.02 0.02 0 0 76 75
  SQL 1.38 0.62 0.02 0.03 0 75 62 53

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 2,046,820,352  
Fixed Size 2,055,040  
Redo Buffers 14,721,024  
Variable Size 4,378,854,528  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 26.41 -17.46
java joxlod exec hp   5.40  
shared CCursor   108.04  
shared Heap0: KGL   32.13  
shared PCursor   90.73  
shared free memory 2,069.96 1,001.96 -51.60
shared gcs resources 38.97 38.97 0.00
shared gcs shadows 24.55 24.55 0.00
shared library cache   84.42  
shared sql area 59.08 732.87 1140.38
shared sql area:PLSQL   30.96  
  buffer_cache 1,952.00 1,952.00 0.00
  fixed_sga 1.96 1.96 0.00
  log_buffer 14.04 14.04 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

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/oracle/admin/gddsdb/adump   
background_dump_dest /u01/oracle/admin/gddsdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files /dev/vgora/rcontrol01, /dev/vgora/rcontrol02, /dev/vgora/rcontrol03   
core_dump_dest /u01/oracle/admin/gddsdb/cdump   
db_block_size 8192   
db_cache_size 2013265920   
db_domain      
db_file_multiblock_read_count 16   
db_keep_cache_size 33554432   
db_name gddsdb   
dispatchers (PROTOCOL=TCP) (SERVICE=gddsdbXDB)   
instance_number 1   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=vip1)(PORT=1521))   
log_archive_dest_1 location=/arch1   
log_archive_format %t_%s_%r.dbf   
open_cursors 1500   
pga_aggregate_target 2147483648   
processes 1500   
remote_listener LISTENERS_GDDSDB   
remote_login_passwordfile EXCLUSIVE   
sessions 1655   
sga_max_size 6442450944   
sga_target 0   
shared_pool_size 2550136832   
spfile /dev/vgora/rspfile   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS3   
user_dump_dest /u01/oracle/admin/gddsdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 23,282 0.24 0.19
acks for commit broadcast(logical) 23,511 0.24 0.20
broadcast msgs on commit(actual) 19,183 0.20 0.16
broadcast msgs on commit(logical) 22,031 0.23 0.18
broadcast msgs on commit(wasted) 740 0.01 0.01
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 0 0.00 0.00
flow control messages sent 2 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 10,393 0.11 0.09
gcs ast xid 0 0.00 0.00
gcs blocked converts 24,334 0.25 0.20
gcs blocked cr converts 56,367 0.58 0.47
gcs compatible basts 117 0.00 0.00
gcs compatible cr basts (global) 1,420 0.01 0.01
gcs compatible cr basts (local) 43,653 0.45 0.36
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 5,005 0.05 0.04
gcs dbwr write request msgs 3,239 0.03 0.03
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 1,352 0.01 0.01
gcs immediate (null) converts 4,219 0.04 0.04
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 64,357 0.66 0.54
gcs indirect ast 7,855 0.08 0.07
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 2,153 0.02 0.02
gcs msgs process time(ms) 11,435 0.12 0.10
gcs msgs received 414,169 4.26 3.45
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 50 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 8,671 0.09 0.07
gcs side channel msgs logical 241,455 2.49 2.01
gcs stale cr 7,520 0.08 0.06
gcs undo cr 0 0.00 0.00
gcs write notification msgs 257 0.00 0.00
gcs writes refused 53 0.00 0.00
ges msgs process time(ms) 13,338 0.14 0.11
ges msgs received 210,580 2.17 1.76
global posts dropped 0 0.00 0.00
global posts queue time 2,916 0.03 0.02
global posts queued 731 0.01 0.01
global posts requested 833 0.01 0.01
global posts sent 731 0.01 0.01
implicit batch messages received 9,660 0.10 0.08
implicit batch messages sent 23,016 0.24 0.19
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 57,962 0.60 0.48
messages queue sent actual 194,742 2.00 1.62
messages queue sent logical 362,300 3.73 3.02
messages received actual 351,736 3.62 2.93
messages received logical 624,749 6.43 5.21
messages sent directly 145,300 1.50 1.21
messages sent indirectly 242,931 2.50 2.02
messages sent not implicit batched 171,726 1.77 1.43
messages sent pbatched 522,741 5.38 4.36
msgs causing lmd to send msgs 75,292 0.77 0.63
msgs causing lms(s) to send msgs 34,657 0.36 0.29
msgs received queue time (ms) 114,230 1.18 0.95
msgs received queued 624,755 6.43 5.21
msgs sent queue time (ms) 14,902 0.15 0.12
msgs sent queue time on ksxp (ms) 88,714 0.91 0.74
msgs sent queued 362,159 3.73 3.02
msgs sent queued on ksxp 418,757 4.31 3.49
process batch messages received 139,006 1.43 1.16
process batch messages sent 165,034 1.70 1.38


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 34,283
CURRENT Block Requests 1,137
Data Block Requests 34,289
Undo Block Requests 0
TX Block Requests 247
Current Results 35,403
Private results 2
Zero Results 15
Disk Read Results 0
Fail Results 0
Fairness Down Converts 7,407
Fairness Clears 0
Free GC Elements 0
Flushes 97
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 48,276
Light Works 92
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 23,288 99.98 0.01 0.00 0.00 0.00
Flushes 68 0.00 52.94 47.06 0.00 0.00
Writes 5,662 0.00 23.97 75.91 0.12 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 96,101 99.30 0.63 0.07 121,393 99.78 0.04 0.18
2 Others 4,885 99.98 0.00 0.02 3,356 99.67 0.30 0.03
2 undo header 101 97.03 2.97 0.00 182 97.80 2.20 0.00
2 undo block 1 100.00 0.00 0.00 0      


Back to Top

End of Report