WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
GDDSDB2531107962gddsdb2210.2.0.3.0YESgdds2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3594320-May-12 00:00:35567 13.4
End Snap:3612827-May-12 16:55:4687 9.2
Elapsed:  11,095.17 (mins)  
DB Time:  253.34 (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: 2,145.81 1,624.05
Logical reads: 888.87 672.73
Block changes: 11.85 8.97
Physical reads: 4.04 3.06
Physical writes: 0.81 0.62
User calls: 66.71 50.49
Parses: 13.05 9.88
Hard parses: 0.54 0.41
Sorts: 2.13 1.62
Logons: 0.03 0.02
Executes: 15.08 11.41
Transactions: 1.32 

% Blocks changed per Read: 1.33Recursive Call %: 30.85
Rollback per transaction %: 76.61Rows per Sort: 225.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.57In-memory Sort %: 100.00
Library Hit %: 93.58Soft Parse %: 95.88
Execute to Parse %: 13.44Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 78.06% Non-Parse CPU: 89.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 92.17 91.91
% SQL with executions>1: 97.84 90.34
% Memory for SQL w/exec>1: 97.92 91.38

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  9,167  60.3 
control file parallel write 219,926 8,114 37 53.4System I/O
log file parallel write 202,094 2,266 11 14.9System I/O
log file sync 147,437 1,550 11 10.2Commit
DFS lock handle 29,741 888 30 5.8Other

RAC Statistics

BeginEnd
Number of Instances: 1 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 0.09 0.07
Global Cache blocks served: 0.42 0.32
GCS/GES messages received: 1.56 1.18
GCS/GES messages sent: 1.25 0.94
DBWR Fusion writes: 0.01 0.01
Estd Interconnect traffic (KB) 4.63 

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

Buffer access - local cache %: 99.56
Buffer access - remote cache %: 0.01
Buffer access - disk %: 0.43

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.4
Avg global cache cr block receive time (ms): 0.7
Avg global cache current block receive time (ms): 0.5
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.5
Avg global cache cr block flush time (ms): 2.0
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.0
Avg global cache current block flush time (ms): 13.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3
Avg message sent queue time on ksxp (ms): 2.3
Avg message received queue time (ms): 3.5
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.3
% of direct sent messages: 27.42
% of indirect sent messages: 59.51
% of flow controlled messages: 13.07

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 13,042.83 85.81
DB CPU 9,167.26 60.31
PL/SQL execution elapsed time 1,996.14 13.13
parse time elapsed 1,241.12 8.17
hard parse elapsed time 998.41 6.57
hard parse (sharing criteria) elapsed time 30.11 0.20
sequence load elapsed time 12.66 0.08
PL/SQL compilation elapsed time 7.82 0.05
failed parse elapsed time 7.27 0.05
connection management call elapsed time 3.53 0.02
repeated bind elapsed time 1.32 0.01
hard parse (bind mismatch) elapsed time 0.31 0.00
DB time 15,200.40  
background elapsed time 21,761.32  
background cpu time 4,281.74  

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 2,014,461 0.00 11,180 6 2.29
Other 8,948,600 93.40 1,803 0 10.17
User I/O 490,079 0.00 1,584 3 0.56
Commit 147,437 0.04 1,550 11 0.17
Concurrency 336,147 0.06 388 1 0.38
Cluster 74,216 0.09 129 2 0.08
Application 326,382 0.00 58 0 0.37
Network 45,005,707 0.00 27 0 51.17
Configuration 1,097 3.65 11 10 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 219,926 0.00 8,114 37 0.25
log file parallel write 202,094 0.00 2,266 11 0.23
log file sync 147,437 0.04 1,550 11 0.17
DFS lock handle 29,741 5.17 888 30 0.03
db file scattered read 215,871 0.00 874 4 0.25
control file sequential read 1,586,875 0.00 726 0 1.80
db file sequential read 210,970 0.00 709 3 0.24
reliable message 5,993 5.01 420 70 0.01
os thread startup 5,025 0.36 205 41 0.01
cursor: pin S 97 0.00 126 1297 0.00
latch: session allocation 717 0.00 114 158 0.00
gc cr failure 65 98.46 87 1332 0.00
latch free 23,768 0.00 66 3 0.03
CGS wait for IPC msg 6,640,816 100.00 65 0 7.55
library cache lock 24,105 0.37 59 2 0.03
SQL*Net break/reset to client 325,782 0.00 58 0 0.37
row cache lock 63,201 0.02 41 1 0.07
Log archive I/O 1,838 0.00 38 21 0.00
latch: library cache lock 1,441 0.00 36 25 0.00
log file sequential read 1,744 0.00 36 21 0.00
library cache pin 237,646 0.00 32 0 0.27
gc cr block 2-way 36,583 0.00 24 1 0.04
SQL*Net message to client 44,472,678 0.00 19 0 50.56
name-service call wait 460 0.00 19 41 0.00
enq: WF - contention 179 6.15 17 96 0.00
wait for scn ack 23,955 0.03 16 1 0.03
ksxr poll remote instances 986,989 57.85 12 0 1.12
rdbms ipc reply 17,441 0.00 12 1 0.02
latch: library cache 2,700 0.00 10 4 0.00
gc current block 2-way 23,807 0.00 10 0 0.03
PX qref latch 1,084,718 100.00 9 0 1.23
SQL*Net more data to client 340,698 0.00 5 0 0.39
enq: US - contention 20,126 0.00 5 0 0.02
Streams AQ: qmn coordinator waiting for slave to start 2 50.00 5 2539 0.00
log file switch completion 33 0.00 5 151 0.00
gcs resource directory to be unfrozen 20 0.00 5 225 0.00
log buffer space 294 0.34 4 12 0.00
enq: CF - contention 48 0.00 3 54 0.00
SQL*Net more data from client 192,331 0.00 3 0 0.22
gcs enter server mode 5 100.00 3 500 0.00
checkpoint completed 2 0.00 2 1234 0.00
gc domain validation 4 0.00 2 616 0.00
wait for votes 75 100.00 2 32 0.00
buffer busy waits 79 2.53 2 30 0.00
LGWR wait for redo copy 2,075 8.96 2 1 0.00
gc current block busy 75 0.00 2 26 0.00
PX Deq: Signal ACK 526 20.91 2 4 0.00
gc current grant busy 7,530 0.00 2 0 0.01
gcs log flush sync 172 34.30 1 9 0.00
gc cr block busy 98 0.00 1 14 0.00
enq: JS - queue lock 541 0.00 1 2 0.00
ges lmd/lmses to freeze in rcfg - mrcvr 75 74.67 1 16 0.00
ges LMON to get to FTDONE 73 65.75 1 17 0.00
PX Deq: reap credit 57,936 97.18 1 0 0.07
latch: ges resource hash list 44,965 0.00 1 0 0.05
ges enter server mode 3 33.33 1 312 0.00
ges2 LMON to wake up lms - mrcvr 2 41 92.68 1 21 0.00
latch: shared pool 911 0.00 1 1 0.00
IPC send completion sync 2,692 99.59 1 0 0.00
cursor: pin S wait on X 97 98.97 1 8 0.00
enq: PS - contention 1,590 0.00 1 0 0.00
latch: cache buffers lru chain 49 0.00 0 8 0.00
log file single write 35 0.00 0 11 0.00
ges global resource directory to be frozen 15 100.00 0 23 0.00
enq: HW - contention 729 0.00 0 0 0.00
gc current grant 2-way 1,724 0.00 0 0 0.00
gc cr multi block request 1,901 0.00 0 0 0.00
latch: cache buffers chains 789 0.00 0 0 0.00
gc cr grant 2-way 1,298 0.00 0 0 0.00
PX Deq: Test for msg 6 0.00 0 36 0.00
PX Deq Credit: send blkd 536 65.67 0 0 0.00
enq: JS - job run lock - synchronize 184 0.00 0 1 0.00
gc buffer busy 44 0.00 0 4 0.00
gc cr disk read 413 0.00 0 0 0.00
enq: TT - contention 424 0.00 0 0 0.00
enq: TM - contention 386 0.00 0 0 0.00
enq: RO - fast object reuse 199 0.00 0 1 0.00
direct path read 61,637 0.00 0 0 0.07
enq: TA - contention 379 0.00 0 0 0.00
ges LMD to inherit communication channels 1 100.00 0 103 0.00
latch: messages 144 0.00 0 1 0.00
enq: DR - contention 52 0.00 0 2 0.00
db file parallel read 4 0.00 0 18 0.00
latch: KCL gc element parent latch 44 0.00 0 2 0.00
enq: FB - contention 236 0.00 0 0 0.00
latch: row cache objects 92 0.00 0 1 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 12 0.00 0 6 0.00
kksfbc child completion 1 100.00 0 54 0.00
read by other session 12 0.00 0 4 0.00
ges reconfiguration to start 2 0.00 0 24 0.00
gc current multi block request 652 0.00 0 0 0.00
latch: redo allocation 14 0.00 0 3 0.00
enq: TX - index contention 10 0.00 0 3 0.00
enq: TS - contention 89 0.00 0 0 0.00
KJC: Wait for msg sends to complete 330 0.00 0 0 0.00
gc cr block congested 13 0.00 0 2 0.00
enq: PI - contention 78 0.00 0 0 0.00
wait list latch free 1 0.00 0 20 0.00
gc current block congested 7 0.00 0 2 0.00
latch: gcs resource hash 40 0.00 0 0 0.00
enq: IR - contention 25 0.00 0 0 0.00
enq: AF - task serialization 22 0.00 0 0 0.00
kjctssqmg: quick message send wait 43 100.00 0 0 0.00
gc current grant congested 2 0.00 0 2 0.00
cursor: mutex S 6 0.00 0 1 0.00
control file single write 1 0.00 0 4 0.00
enq: TX - row lock contention 15 0.00 0 0 0.00
latch: enqueue hash chains 27 0.00 0 0 0.00
direct path write 1,079 0.00 0 0 0.00
kst: async disk IO 1,938 0.00 0 0 0.00
latch: library cache pin 44 0.00 0 0 0.00
direct path write temp 506 0.00 0 0 0.00
buffer deadlock 1 100.00 0 1 0.00
undo segment extension 39 100.00 0 0 0.00
latch: object queue header operation 4 0.00 0 0 0.00
library cache load lock 1 0.00 0 0 0.00
cr request retry 1 100.00 0 0 0.00
recovery read 8 0.00 0 0 0.00
latch: undo global data 1 0.00 0 0 0.00
ksfd: async disk IO 2 0.00 0 0 0.00
SQL*Net message from client 44,473,157 0.00 32,380,631 728 50.56
gcs remote message 43,456,591 99.90 1,299,806 30 49.41
jobq slave wait 239,054 93.05 673,639 2818 0.27
ges remote message 8,381,389 98.99 649,756 78 9.53
Streams AQ: qmn slave idle wait 23,695 0.01 648,111 27352 0.03
Streams AQ: qmn coordinator idle wait 28,458 85.24 647,983 22770 0.03
virtual circuit status 22,190 100.00 647,862 29196 0.03
DIAG idle wait 3,297,537 0.00 647,112 196 3.75
Streams AQ: waiting for time management or cleanup tasks 10,789 62.52 605,587 56130 0.01
Streams AQ: waiting for messages in the queue 59,460 100.00 549,017 9233 0.07
PX Idle Wait 36,649 96.46 87,466 2387 0.04
PX Deq: Execution Msg 6,175 30.54 17 3 0.01
PL/SQL lock timer 8 75.00 4 490 0.00
PX Deq: Msg Fragment 2,897 46.29 3 1 0.00
PX Deq: Par Recov Execute 42 0.00 2 51 0.00
PX Deq: Par Recov Reply 12 0.00 1 108 0.00
PX Deq: Join ACK 789 43.09 1 1 0.00
PX Deq: Parse Reply 836 40.19 1 1 0.00
Streams AQ: RAC qmn coordinator idle wait 47,948 100.00 0 0 0.05
class slave wait 306 0.00 0 1 0.00
PX Deq: Execute Reply 671 29.96 0 0 0.00
PX Deq: Par Recov Change Vector 74 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 219,926 0.00 8,114 37 0.25
log file parallel write 202,094 0.00 2,266 11 0.23
events in waitclass Other 7,896,840 93.65 636 0 8.98
control file sequential read 1,349,573 0.00 564 0 1.53
os thread startup 5,025 0.36 205 41 0.01
Log archive I/O 1,838 0.00 38 21 0.00
log file sequential read 1,744 0.00 36 21 0.00
row cache lock 6,570 0.20 33 5 0.01
gc cr block 2-way 17,608 0.00 17 1 0.02
db file sequential read 1,383 0.00 6 5 0.00
gc current block 2-way 7,104 0.00 5 1 0.01
log buffer space 287 0.00 2 7 0.00
buffer busy waits 31 3.23 1 42 0.00
gc domain validation 1 0.00 1 533 0.00
log file single write 35 0.00 0 11 0.00
library cache lock 482 0.00 0 1 0.00
gc current grant busy 711 0.00 0 0 0.00
gc cr block busy 9 0.00 0 13 0.00
log file sync 12 0.00 0 9 0.00
latch: library cache 104 0.00 0 1 0.00
enq: TM - contention 199 0.00 0 0 0.00
latch: shared pool 42 0.00 0 1 0.00
gc current grant 2-way 176 0.00 0 0 0.00
enq: RO - fast object reuse 45 0.00 0 1 0.00
gc cr multi block request 148 0.00 0 0 0.00
enq: HW - contention 63 0.00 0 0 0.00
gc cr grant 2-way 47 0.00 0 0 0.00
library cache pin 32 0.00 0 0 0.00
gc cr block congested 5 0.00 0 2 0.00
db file scattered read 1 0.00 0 8 0.00
control file single write 1 0.00 0 4 0.00
kst: async disk IO 1,420 0.00 0 0 0.00
latch: row cache objects 17 0.00 0 0 0.00
direct path read 299 0.00 0 0 0.00
direct path write 299 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 0 0.00
latch: cache buffers chains 5 0.00 0 0 0.00
rdbms ipc message 9,914,113 92.22 8,271,529 834 11.27
gcs remote message 43,456,597 99.90 1,299,806 30 49.41
ges remote message 8,381,408 98.99 649,756 78 9.53
pmon timer 231,603 100.00 649,559 2805 0.26
Streams AQ: qmn coordinator idle wait 28,458 85.24 647,983 22770 0.03
smon timer 4,028 87.36 635,611 157798 0.00
Streams AQ: waiting for time management or cleanup tasks 10,789 62.52 605,587 56130 0.01
PX Deq: Par Recov Reply 12 0.00 1 108 0.00
PX Deq: Join ACK 789 43.09 1 1 0.00
PX Deq: Parse Reply 836 40.19 1 1 0.00
Streams AQ: RAC qmn coordinator idle wait 47,948 100.00 0 0 0.05
PX Deq: Execute Reply 671 29.96 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 55,667,814
AVG_IDLE_TIME 10,892,717
AVG_IOWAIT_TIME 152,983
AVG_SYS_TIME 35,516,295
AVG_USER_TIME 20,137,315
BUSY_TIME 111,351,843
IDLE_TIME 21,790,133
IOWAIT_TIME 309,805
SYS_TIME 71,054,896
USER_TIME 40,296,947
LOAD 5
OS_CPU_WAIT_TIME ###############
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 92,790,784
VM_OUT_BYTES 90,112
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 8,623.30 4,243.80 929,609 306,030,270
gddsdb 6,563.70 4,914.50 1,751,054 275,215,283
SYS$BACKGROUND 0.00 0.00 10,785 10,465,662
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 251929 82211 38574 705 0 0 11630158 980
gddsdb 222663 71395 253996 13609 0 0 33371691 1741
SYS$BACKGROUND 15943 4737 43139 24434 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
1,153 169 4 288.16 7.58 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
634 79 2 316.75 4.17 fhkxwq12zxh1v   select HDDEPT, HDONGROUP, WO1...
500 369 3,750 0.13 3.29 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
431 112 9,326 0.05 2.84 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
302 21 4 75.38 1.98 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
288 11 81 3.55 1.89 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
210 21 2,453 0.09 1.38 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
205 16 26 7.90 1.35 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
181 6 140 1.29 1.19 70vs1d7ywk5m0 MMON_SLAVE begin dbms_stats.copy_table_st...
177 165 36,129 0.00 1.16 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...

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
369 500 3,750 0.10 3.29 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
169 1,153 4 42.28 7.58 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
165 177 36,129 0.00 1.16 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
112 431 9,326 0.01 2.84 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
84 103 3,376 0.02 0.68 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
79 634 2 39.49 4.17 fhkxwq12zxh1v   select HDDEPT, HDONGROUP, WO1...
75 79 135 0.55 0.52 akpv4yxpfxcvh JDBC Thin Client select * from dxlogsnote or...
53 58 21,060 0.00 0.38 5vw9ycttbmgbw JDBC Thin Client select * from report
50 53 72 0.70 0.35 cxqm2jxfx5jy1 JDBC Thin Client select * from dxlogsnote wh...
41 45 1,017 0.04 0.30 fgj28pb6u79uy JDBC Thin Client select count(id) as cu from IN...
21 302 4 5.37 1.98 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
21 210 2,453 0.01 1.38 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
16 205 26 0.62 1.35 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
11 288 81 0.14 1.89 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
6 181 140 0.04 1.19 70vs1d7ywk5m0 MMON_SLAVE begin dbms_stats.copy_table_st...

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
88,955,120 3,750 23,721.37 15.03 368.87 499.51 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
70,191,910 36,129 1,942.81 11.86 164.94 176.83 bvttmwz2rkt85 DBMS_SCHEDULER SELECT /*+FIRST_ROWS INDEX(dr$...
12,629,365 3,376 3,740.93 2.13 83.64 103.15 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
3,787,077 9,326 406.08 0.64 112.03 430.95 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
3,416,519 4 854,129.75 0.58 169.14 1152.62 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
2,181,982 2 1,090,991.00 0.37 78.98 633.50 fhkxwq12zxh1v   select HDDEPT, HDONGROUP, WO1...
1,921,723 31 61,991.06 0.32 40.48 43.64 534v52cvnm5g4 JDBC Thin Client select * from workorder whe...
1,890,660 2 945,330.00 0.32 8.23 18.14 0du76dgjg98xc JDBC Thin Client select distinct ma.domainid, ...
1,730,914 28 61,818.36 0.29 36.44 37.03 3pmupdjmhccus JDBC Thin Client select * from workorder whe...
1,717,656 245,374 7.00 0.29 22.57 24.13 2f20v850910tu JDBC Thin Client select tabMaxId, InfoMaxId, er...

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
1,710,187 2 855,093.50 63.54 78.98 633.50 fhkxwq12zxh1v   select HDDEPT, HDONGROUP, WO1...
484,656 4 121,164.00 18.01 169.14 1152.62 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
312,275 4 78,068.75 11.60 21.49 301.53 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
311,969 81 3,851.47 11.59 11.39 287.77 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
144,021 1 144,021.00 5.35 9.75 79.72 658fb6mmfuxdq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
61,848 9,326 6.63 2.30 112.03 430.95 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
61,076 2,453 24.90 2.27 20.98 210.44 abtp0uqvdb1d3   CALL MGMT_ADMIN_DATA.EVALUATE_...
61,068 26 2,348.77 2.27 16.12 205.37 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
43,829 89,327 0.49 1.63 28.91 42.49 6azxd8702a2cm JDBC Thin Client begin dbms_lob.read(:1, :2, ...
12,178 1 12,178.00 0.45 1.41 8.62 grnr386b8t7wv 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
245,374 245,374 1.00 0.00 0.00 2f20v850910tu JDBC Thin Client select tabMaxId, InfoMaxId, er...
236,488 0 0.00 0.00 0.00 2k3bu9k1p7kyz   select /*+ INDEX(ol$ ol$signat...
207,732 207,732 1.00 0.00 0.00 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...
161,531 161,531 1.00 0.00 0.00 02unwp247d7fd JDBC Thin Client select vartype from maxvartype...
161,531 161,532 1.00 0.00 0.00 8z03vw0qubxgw JDBC Thin Client select varvalue from maxvars w...
160,065 517,635 3.23 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
135,566 135,566 1.00 0.00 0.00 4xjbyrsjf3sj7 JDBC Thin Client select vartype from maxvartype...
135,566 135,566 1.00 0.00 0.00 aw5n3a6aq4kqu JDBC Thin Client select varvalue from maxvars w...
95,470 95,470 1.00 0.00 0.00 3z22gw9rndwxx JDBC Thin Client select varvalue from maxvars w...
95,469 95,469 1.00 0.00 0.00 157a8j9tspby9 JDBC Thin Client select varvalue from maxvars w...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
245,374 245,374 2.82 2f20v850910tu JDBC Thin Client select tabMaxId, InfoMaxId, er...
236,488 236,488 2.72 2k3bu9k1p7kyz   select /*+ INDEX(ol$ ol$signat...
163,696 207,732 1.88 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...
161,531 161,531 1.86 02unwp247d7fd JDBC Thin Client select vartype from maxvartype...
161,531 161,531 1.86 8z03vw0qubxgw JDBC Thin Client select varvalue from maxvars w...
160,065 160,065 1.84 0h6b2sajwb74n   select privilege#, level from ...
135,566 135,566 1.56 4xjbyrsjf3sj7 JDBC Thin Client select vartype from maxvartype...
135,566 135,566 1.56 aw5n3a6aq4kqu JDBC Thin Client select varvalue from maxvars w...
95,470 95,470 1.10 3z22gw9rndwxx JDBC Thin Client select varvalue from maxvars w...
95,469 95,469 1.10 157a8j9tspby9 JDBC Thin Client select varvalue from maxvars w...
95,205 95,205 1.10 ad5f0qu2rtdj9 JDBC Thin Client select vartype from maxvartype...
94,137 94,137 1.08 7ytt4wav7qnmy JDBC Thin Client select vartype from maxvartype...

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
87.29 98.16 88.93 0.28 464 98fsfpyx1h47z JDBC Thin Client select reloadcache from maxses...
13.20 70.04 18.84 7.61 32,332 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
1.45 6.01 24.18 17.75 37,091 5vdxntxszh5p0 JDBC Thin Client update wfassignment set assign...
1.16 38.15 3.03 2.99 17,081 g2wr3u7s1gtf3   select count(*) from sys.job$ ...
0.78 1.50 51.68 35.26 34,336 bywqkxw8zag3r JDBC Thin Client insert into wfassignment (owne...
0.67 37.66 1.79 0.09 1,258 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.67 27.88 2.42 0.01 1 6w3rdsz64hdhk   select min(timeout) from sys.r...
0.67 28.94 2.33 0.01 1 79w2cqu2gmjm8   select 1 from aq$_schedules
0.67 42.06 1.60 0.01 38 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.63 91.72 0.68 0.06 18 c7sn076yz7030   select smontabv.cnt, smontab....
0.55 28.39 1.92 0.22 1,346 c4nhd1ntptxq7   select message_level, sequenc...
0.43 2.66 15.97 5.78 6 24b3xmp4wd3tu   delete from sys.wri$_optstat_h...
0.28 2.49 11.05 10.32 72 84qubbrsr0kfn   insert into wrh$_latch (snap...
0.19 3.89 4.86 4.62 52,774 3c1kubcdjnppq   update sys.col_usage$ set eq...
0.17 14.01 1.24 0.78 2 7j7p2skat1xbz JDBC Thin Client select * from wftransaction ...
0.17 14.85 1.14 0.94 40,648 3k63u29aj4jfd JDBC Thin Client SELECT IDX_ID FROM DR$INDEX WH...
0.13 4.29 3.12 1.58 306 8v71021dgbnk5 JDBC Thin Client insert into workorder (woeq1, ...
0.12 4.07 2.95 2.90 37,961 0t3fycvxv9xwb   INSERT INTO CTXSYS.DRV$PENDING...
0.11 0.57 18.97 15.31 207,732 frg5wcfrk4cnr JDBC Thin Client SELECT MAXSEQ.NEXTVAL FROM DUA...
0.09 0.09 103.15 83.64 3,376 15an99c0zzka4 DBMS_SCHEDULER SELECT PND_INDEX_NAME INAME FR...
0.09 0.02 499.51 368.87 3,750 av3jp9pzytg3u DBMS_SCHEDULER call maximo_ts_job ( )
0.08 4.37 1.92 0.98 3,018 db78fxqxwxt7r   select /*+ rule */ bucket, en...
0.08 3.47 2.37 1.60 147 31a13pnjps7j3   SELECT source, (case w...
0.06 6.01 1.01 0.12 1 b7k3svyn44ymt JDBC Thin Client select * from asset where (...
0.05 14.84 0.35 0.34 889 19rkm1wsf9axx   insert into WRI$_ALERT_HISTORY...
0.05 1.99 2.34 2.34 22,222 g00cj285jmgsw   update sys.mon_mods$ set inser...
0.05 0.65 7.09 5.47 201 63fyqfhnd7u5k   select OBJOID, CLSOID, RUNT...
0.04 14.38 0.30 0.30 647 3qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
0.04 0.02 180.56 6.27 140 70vs1d7ywk5m0 MMON_SLAVE begin dbms_stats.copy_table_st...
0.04 65.20 0.06 0.02 437 dr7knmnxzuk5c JDBC Thin Client SELECT IDX_DOCID_COUNT FROM DR...
0.03 0.73 4.71 4.38 39 2ybrhdgyk5hdy JDBC Thin Client select sortnum, id, title, s...
0.03 1.84 1.38 0.64 288 d89c1mh5pvbkz MMON_SLAVE SELECT /*+ rule */ U.NAME, OT...
0.02 0.58 3.70 0.32 2 9mp7ud243ngqn JDBC Thin Client select count(*) from workorder...
0.02 11.07 0.19 0.19 345 f9wmnkt6d42g8 JDBC Thin Client update maxsession set servert...
0.02 0.05 43.64 40.48 31 534v52cvnm5g4 JDBC Thin Client select * from workorder whe...
0.02 1.17 1.68 1.41 2,385 1c42ud43swukm JDBC Thin Client update ManagerOfDept set devo...
0.01 0.40 2.78 2.56 34,339 4thqz1dr1yswx JDBC Thin Client select WFASSIGNMENTSEQ.NEXTVAL...
0.01 0.46 2.15 1.80 63,873 2ym6hhaq30r73   select type#, blocks, extents,...
0.01 0.23 4.31 2.39 1,630 00qfx9ukmq9s1 JDBC Thin Client select id, title, publishdate,...
0.01 0.07 13.66 7.76 2,869 2ks4ybnv62100 JDBC Thin Client select count(id) as cu from In...
0.01 0.03 26.50 14.42 20,295 8a1pvy4cy8hgv   insert into histgrm$(obj#, int...
0.01 0.29 2.75 2.40 322 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
0.01 0.34 2.38 1.46 140 2mp99nzd9u1qp   delete from histgrm$ where obj...
0.01 1.25 0.58 0.58 1 c2dtrqhzpzxgg JDBC Thin Client select * from workorder whe...
0.01 0.03 25.61 24.34 33 cgt4uypt4a0ja JDBC Thin Client select * from dxlogsnote wh...
0.01 0.05 14.91 0.69 69 7vgmvmy8vvb9s   insert into wrh$_tempstatxs ...
0.01 0.37 1.89 1.20 1,154 7fz05n5q6h8ca JDBC Thin Client update taskscheduler set serv...
0.01 3.38 0.15 0.09 1,935 89v8ckgw5y2tc JDBC Thin Client SELECT 0 FROM DR$INDEX WHERE I...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00qfx9ukmq9s1select id, title, publishdate, countnum, by1, '0' from InfoList where ( (infoscope like '%, 120%, ') ) and (publishdate>' ' and publishdate is not null) and (by3 is null or by3='' or by3>'2012-05-25') order by by7 desc, publishdate Desc
02unwp247d7fdselect vartype from maxvartype where varname = 'LIC_7'
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0du76dgjg98xcselect distinct ma.domainid, dom.objectname, dom.validtnwhereclause, dom.listwhereclause, dom.errorresourcbundle, dom.erroraccesskey, dom.siteid, dom.orgid from maxattribute ma, maxobject mo, maxdomain md, maxtabledomain dom where ma.objectname = mo.objectname and ma.domainid=md.domainid and md.domaintype in (select value from synonymdomain where domainid='DOMTYPE' and maxvalue='MAXTABLE') and ma.domainid = dom.domainid order by ma.domainid
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0t3fycvxv9xwbINSERT INTO CTXSYS.DRV$PENDING (PND_CID, PND_PID, PND_ROWID, PND_TIMESTAMP, PND_LOCK_FAILED) VALUES(:1, :2, :3, SYSDATE, 'N')
157a8j9tspby9select varvalue from maxvars where varname = 'BASELANGUAGE'
15an99c0zzka4SELECT PND_INDEX_NAME INAME FROM CTX_USER_PENDING
19rkm1wsf9axxinsert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) 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)
1c42ud43swukmupdate ManagerOfDept set devolve_id='' where endtime<1337875200000 and dept_id<10000
24b3xmp4wd3tudelete from sys.wri$_optstat_histgrm_history where savtime < :1
2f20v850910tuselect tabMaxId, InfoMaxId, erasePeriod, ListMaxNum, LastModifyTime, delNopassTime, everyMaxNum from InfoConfig
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
2ks4ybnv62100select count(id) as cu from InfoList_1 where ( (infoscope like '%, 120%, ') ) and (publishdate>' ' and publishdate is not null) and (by3 is null or by3='' or by3>'2012-05-25')
2mp99nzd9u1qpdelete from histgrm$ where obj# = :1
2ybrhdgyk5hdyselect sortnum, id, title, step, actorid, currenttaskid, workflowid, year, 'GWLIST' from GWLIST where 2>1 and sortnum=0 and ( (instr(handler, ', 10394, ')<>0 ) or (instr(handler, ', 10394, ')<>0 ) or (instr(handler, ', 27, ')<>0 ) ) and workflowid=3 order by starttime desc
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
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
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
3k63u29aj4jfdSELECT IDX_ID FROM DR$INDEX WHERE IDX_OWNER# = :B2 AND IDX_NAME = :B1
3pmupdjmhccusselect * from workorder where ((siteid = 'LSSITE')) and (exists ((select siteid from siteauth a1, groupuser b1, maxgroup m1, applicationauth t1 where b1.userid = 'LANJS' and b1.groupname=a1.groupname and b1.groupname=m1.groupname and m1.independent = 1 and a1.groupname = t1.groupname and t1.app = 'CREATEWR' and a1.siteid = workorder.siteid ) union all (select siteid from siteauth a, groupuser b, maxgroup m where b.userid = 'LANJS' 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 = 'LANJS' and d.groupname = m2.groupname and d.groupname = c.groupname and m2.independent = 0 and c.app = 'CREATEWR' ))) )) order by wonum
3qsmy8ybvwt3ninsert into WRI$_ALERT_OUTSTANDING (reason_id, object_id, subobject_id, internal_instance_number, owner, object_name, subobject_name, sequence_id, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, context, metric_value) 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)
3y9bat7nwcjy5SELECT ELAPSED_TIME FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'AUTO_SPACE_ADVISOR_JOB'
3z22gw9rndwxxselect varvalue from maxvars where varname = 'MLSUPPORTED'
4thqz1dr1yswxselect WFASSIGNMENTSEQ.NEXTVAL from DUMMY_TABLE
4xjbyrsjf3sj7select vartype from maxvartype where varname = 'LIC_10'
534v52cvnm5g4select * from workorder where ((siteid = 'LSSITE')) and (exists ((select siteid from siteauth a1, groupuser b1, maxgroup m1, applicationauth t1 where b1.userid = 'ZHANGJL' and b1.groupname=a1.groupname and b1.groupname=m1.groupname and m1.independent = 1 and a1.groupname = t1.groupname and t1.app = 'CREATEWR' and a1.siteid = workorder.siteid ) union all (select siteid from siteauth a, groupuser b, maxgroup m where b.userid = 'ZHANGJL' 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 = 'ZHANGJL' and d.groupname = m2.groupname and d.groupname = c.groupname and m2.independent = 0 and c.app = 'CREATEWR' ))) )) order by wonum
5vdxntxszh5p0update wfassignment set assignstatus=:1 where wfassignmentid=:2 and rowstamp=:3
5vw9ycttbmgbwselect * from report
63fyqfhnd7u5k select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a where bitand(a.job_status, 515) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 fr om sys.scheduler$_window d where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
658fb6mmfuxdq select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count(distinct "ASSIGNID"), count("PRIORITY"), count(distinct "PRIORITY"), sum(sys_op_opnsize("PRIORITY")), substrb(dump(min("PRIORITY"), 16, 0, 32), 1, 120), substrb(dump(max("PRIORITY"), 16, 0, 32), 1, 120), count("STARTDATE"), count(distinct "STARTDATE"), count("DUEDATE"), count(distinct "DUEDATE"), count("ASSIGN_01"), count(distinct "ASSIGN_01"), sum(sys_op_opnsize("ASSIGN_01")), substrb(dump(min("ASSIGN_01"), 16, 0, 32), 1, 120), substrb(dump(max("ASSIGN_01"), 16, 0, 32), 1, 120), count("ASSIGN_02"), count(distinct "ASSIGN_02"), sum(sys_op_opnsize("ASSIGN_02")), substrb(dump(min("ASSIGN_02"), 16, 0, 32), 1, 120), substrb(dump(max("ASSIGN_02"), 16, 0, 32), 1, 120), count("ASSIGN_03"), count(distinct "ASSIGN_03"), sum(sys_op_opnsize("ASSIGN_03")), substrb(dump(min("ASSIGN_03"), 16, 0, 32), 1, 120), substrb(dump(max("ASSIGN_03"), 16, 0, 32), 1, 120), count("ASSIGN_04"), count(distinct "ASSIGN_04"), sum(sys_op_opnsize("ASSIGN_04")), substrb(dump(min("ASSIGN_04"), 16, 0, 32), 1, 120), substrb(dump(max("ASSIGN_04"), 16, 0, 32), 1, 120), count("ASSIGN_05"), count(distinct "ASSIGN_05"), sum(sys_op_opnsize("ASSIGN_05")), substrb(dump(min("ASSIGN_05"), 16, 0, 32), 1, 120), substrb(dump(max("ASSIGN_05"), 16, 0, 32), 1, 120), count("CONDITIONCLASS"), count(distinct "CONDITIONCLASS"), sum(sys_op_opnsize("CONDITIONCLASS")), substrb(dump(min(s ubstrb("CONDITIONCLASS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CONDITIONCLASS", 1, 32)), 16, 0, 32), 1, 120), count("ESCROLE"), count(distinct "ESCROLE"), sum(sys_op_opnsize("ESCROLE")), substrb(dump(min("ESCROLE"), 16, 0, 32), 1, 120), substrb(dump(max("ESCROLE"), 16, 0, 32), 1, 120), count(distinct "ROWSTAMP") from "MAXIMO"."WFASSIGNMENT" sample ( 8.6293712287) t
6azxd8702a2cmbegin dbms_lob.read(:1, :2, :3, :4); end;
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;
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
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
6w3rdsz64hdhkselect min(timeout) from sys.reg$
70vs1d7ywk5m0begin dbms_stats.copy_table_stats('SYS', :bind1, :bind2, :bind3, flags=>1, force=>TRUE); end;
79w2cqu2gmjm8select 1 from aq$_schedules
7fz05n5q6h8caupdate taskscheduler set servertimestamp = :1 where servername = :2 and taskname in ( :3 , :4 , :5 , :6 , :7)
7j7p2skat1xbzselect * from wftransaction where ownertable = 'HOTWORKPERMIT' and ownerid = 841 order by transdate, transid
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7vgmvmy8vvb9sinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
7ytt4wav7qnmyselect vartype from maxvartype where varname = 'MLSUPPORTED'
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
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
89v8ckgw5y2tcSELECT 0 FROM DR$INDEX WHERE IDX_ID = :B2 AND IDX_OWNER# = :B1
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'))
8v71021dgbnk5 insert into workorder (woeq1, wopm2, siteid, outlabcost, workorderid, hdifout, glaccount, performmoveto, status, woeq3, hdisorder, estatapprmatcost, hddept, hasfollowupwork, estservcost, woeq4, woacceptscharges, origrecordid, wolo6, movetoparent, wojo1, haschildren, outtoolcost, estlabhrs, acttoolcost, hasld, ownergroup, woeq2, downtime, actlabhrs, woclass, wo9, wopriority, description, wolo7, wonum, wogroup, outmatcost, wo17, wolo2, worktype, location, wolo10, interruptible, wolo3, wo16, estatapprservcost, jpnum, chargestore, fincntrlid, estmatcost, estlabcost, pmnum, statusdate, parent, estatapprtoolcost, actmatcost, istask, hdbalance, woeq12, changedate, reportedby, wolo9, estatapprlabcost, wo18, esttoolcost, assetsys5, wolo8, woeq10, estdur, woeq7, movetoloc, assetnum, hdworkpart, actlabcost, langcode, hdongroup, woeq8, wttype, changeby, phone, woeq13, wolo1, woeq9, historyflag, owner, reportdate, hdtrasend, hdonplan, woflowcfg, parentchgsstatus, movetobinnum, orgid, woeq6, wolo5, disabled, woeq14, wolo4, actstart, onbehalfof, woeq5, estatapprlabhrs, woeq11, actservcost) 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, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104)
8z03vw0qubxgwselect varvalue from maxvars where varname = 'LIC_7'
98fsfpyx1h47zselect reloadcache from maxsession where issystem = 1 and servername = :1 and serverhost = :2
9mp7ud243ngqnselect count(*) from workorder where (((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 1 and siteid = 'LSSITE' and istask = 0)) and (worktype ='CM')
abtp0uqvdb1d3CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
ad5f0qu2rtdj9select vartype from maxvartype where varname = 'BASELANGUAGE'
akpv4yxpfxcvhselect * from dxlogsnote order by logdate desc
av3jp9pzytg3ucall maximo_ts_job ( )
aw5n3a6aq4kquselect varvalue from maxvars where varname = 'LIC_10'
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
b7k3svyn44ymtselect * from asset where (assetnum like '%GGH%' and siteid like '%LSSITE%')
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)
c2dtrqhzpzxggselect * from workorder where (((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and hdendtime >= TO_TIMESTAMP ('2012-04-25 00:00:38' , 'YYYY-MM-DD HH24:MI:SS.FF') and siteid = 'LSSITE' and istask = 0) and (exists (select siteid from maximo.dept where ((upper(description) like '%??%')) and (trim(deptnum)=trim(workorder.wopm2))))) and (worktype ='CM') order by workorderid desc
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
c7sn076yz7030select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
cgt4uypt4a0jaselect * from dxlogsnote where exists ( select siteid from siteauth a, groupuser b where a.groupname=b.groupname and b.userid = 'CHENXF' and a.siteid = dxlogsnote.siteid) order by logdate desc
cxqm2jxfx5jy1select * from dxlogsnote where exists ( select siteid from siteauth a, groupuser b where a.groupname=b.groupname and b.userid = 'HANHT' and a.siteid = dxlogsnote.siteid) order by logdate desc
d89c1mh5pvbkz SELECT /*+ rule */ U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE :B4 IS NULL AND U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OT.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OT.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.TABPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TP.BO# = OT.OBJ# AND TP.OBJ# = OP.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME , NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, OS.SUBNAME, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR (OP.SUBNAME = :B4 AND (:B5 IS NOT NULL OR OS.SUBNAME IS NULL)) OR OS.SUBNAME = :B4 ) AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# ORDER BY 1, 2, 3, 4, 5, 22
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dr7knmnxzuk5cSELECT IDX_DOCID_COUNT FROM DR$INDEX WHERE IDX_ID = :B1
f9wmnkt6d42g8update maxsession set servertimestamp = :1 where serverhost = :2 and servername = :3 and issystem = :4
fgj28pb6u79uyselect count(id) as cu from INFOLIST_1 where 2>1 and(id not in (select distinct infoid from INFOLOG9 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG8 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG7 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG6 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG5 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG4 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG3 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG2 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG12 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG11 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG10 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG1 where userid='10276') ) and(id not in (select distinct infoid from INFOLOG0 where userid='10276') ) and publishdate is not null
fhkxwq12zxh1v select HDDEPT, HDONGROUP, WO18, WONUM, DESCRIPTION, WO9, WO17, HDCMUPCAUS, HDPCOMPHR, WOPM2, WOJO1, REPORTDATE, decode(VALIDATETIME, null, '?', to_char(VALIDATETIME, 'yyyy-mm-dd HH24:MI:SS')) AS VALIDATETIME, decode(JXSQITIME, null, '?', to_char(JXSQITIME, 'yyyy-mm-dd HH24:MI:SS')) AS JXSQITIME, decode(YQTIME, null, '?', to_char(YQTIME, 'yyyy-mm-dd HH24:MI:SS')) AS YQTIME, decode(DJCXPZTIME, null, '?', to_char(DJCXPZTIME, 'yyyy-mm-dd HH24:MI:SS')) AS DJCXPZTIME, WANGONGTIME, HDCOMPTIME, HDPCOMPTIME, case when djtime >4 then -30 else 0 end djkhje, --?????? --???????? case when WOTIME <4 or WOTIME =4 and WO9 ='????' then 35 when WOTIME >4 AND WOTIME <12 and WO9 ='????' then 30 when WOTIME >12 and WO9 ='????' then (12-WOTIME)*10 --?????? when WOTIME <4 or WOTIME =4 and WO9 ='??' then 55 when WOTIME >4 AND WOTIME <12 and WO9 ='??' then 50 when WOTIME >12 and WO9 ='??' then (12-WOTIME)*10 --?????? when WOTIME <4 and WO9 ='??' then (4-WOTIME)*100 when ((WOTIME <24 or WOTIME =24) and WOTIME > 4) and WO9 ='??' then 200 when WOTIME >24 and WO9 ='??' then (24-WOTIME)*100 --?????? end jxkhje1, --?????? case when ACCEPTTIME >2 then -30 else 0 end yxkhje, --?????? case when WO9 ='????' then -30 when WO9 ='??' then -50 when WO9 ='??' then -200 when WO9='??' then -500 end fskh , --???? case when wldjtime>30 then -50 end wldjkh , --?????? case when fsdjtime>90 then -100 end fsdjkh, --?????? AFFIRMTIME, WOTIME, SPTIME, YANQIHUAQUTIME, PAUSETIME, ACCEPTTIME, HDCOMPGP, HDCHEGROUP, HDCOMPHR, HDCOMPADV, HDUNIT, HDCANCELREASON from qxkh where (to_char(HDCOMPTIME, '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'))
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
g2wr3u7s1gtf3select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
grnr386b8t7wvselect /*+ no_parallel_index(t, "WFASSIGN_NDX3") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t, "WFASSIGN_NDX3") */ count(*) as nrw, count(distinct sys_op_lbid(65612, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("WFID")||sys_op_descend("PROCESSNAME")||sys_op_descend("PROCESSREV")||sys_op_descend("NODEID"))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "MAXIMO"."WFASSIGNMENT" sample block ( 2.7513652041, 1) t where "WFID" is not null or "PROCESSNAME" is not null or "PROCESSREV" is not null or "NODEID" is not null

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,056,942 1.59 1.20
CPU used when call started 830,160 1.25 0.94
CR blocks created 15,510 0.02 0.02
Cached Commit SCN referenced 34,973 0.05 0.04
Commit SCN cached 1,251 0.00 0.00
DB time 126,696,834 190.32 144.04
DBWR checkpoint buffers written 519,776 0.78 0.59
DBWR checkpoints 302 0.00 0.00
DBWR fusion writes 6,639 0.01 0.01
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 19,723 0.03 0.02
DBWR undo block writes 96,738 0.15 0.11
DFO trees parallelized 340 0.00 0.00
Misses for writing mapping 5 0.00 0.00
PX local messages recv'd 997 0.00 0.00
PX local messages sent 990 0.00 0.00
PX remote messages recv'd 4,402 0.01 0.01
PX remote messages sent 3,642 0.01 0.00
Parallel operations downgraded to serial 3,745 0.01 0.00
Parallel operations not downgraded 340 0.00 0.00
RowCR - row contention 25 0.00 0.00
RowCR attempts 65,635 0.10 0.07
RowCR hits 69,411 0.10 0.08
SMON posted for instance recovery 1 0.00 0.00
SMON posted for undo segment shrink 40 0.00 0.00
SQL*Net roundtrips to/from client 44,468,877 66.80 50.56
active txn count during cleanout 19,041 0.03 0.02
application wait time 5,805 0.01 0.01
background checkpoints completed 13 0.00 0.00
background checkpoints started 13 0.00 0.00
background timeouts 3,087,648 4.64 3.51
branch node splits 11 0.00 0.00
buffer is not pinned count 151,339,708 227.34 172.06
buffer is pinned count 141,147,989 212.03 160.47
bytes received via SQL*Net from client 3,283,356,425 4,932.11 3,732.84
bytes sent via SQL*Net to client 5,927,209,930 8,903.59 6,738.64
calls to get snapshot scn: kcmgss 36,868,030 55.38 41.92
calls to kcmgas 739,924 1.11 0.84
calls to kcmgcs 20,955 0.03 0.02
change write time 9,652 0.01 0.01
cleanout - number of ktugct calls 25,903 0.04 0.03
cleanouts and rollbacks - consistent read gets 4,142 0.01 0.00
cleanouts only - consistent read gets 3,708 0.01 0.00
cluster key scan block gets 2,299,233 3.45 2.61
cluster key scans 555,476 0.83 0.63
cluster wait time 12,871 0.02 0.01
commit batch/immediate performed 64 0.00 0.00
commit batch/immediate requested 64 0.00 0.00
commit cleanout failures: block lost 257 0.00 0.00
commit cleanout failures: buffer being written 2 0.00 0.00
commit cleanout failures: callback failure 1,849 0.00 0.00
commit cleanout failures: cannot pin 4 0.00 0.00
commit cleanouts 975,879 1.47 1.11
commit cleanouts successfully completed 973,767 1.46 1.11
commit immediate performed 64 0.00 0.00
commit immediate requested 64 0.00 0.00
commit txn count during cleanout 31,144 0.05 0.04
concurrency wait time 38,749 0.06 0.04
consistent changes 44,775 0.07 0.05
consistent gets 583,856,407 877.04 663.79
consistent gets - examination 71,560,403 107.49 81.36
consistent gets direct 63,832 0.10 0.07
consistent gets from cache 583,793,000 876.95 663.71
current blocks converted for CR 0 0.00 0.00
cursor authentications 89,142 0.13 0.10
data blocks consistent reads - undo records applied 29,482 0.04 0.03
db block changes 7,886,816 11.85 8.97
db block gets 7,870,461 11.82 8.95
db block gets direct 7,444 0.01 0.01
db block gets from cache 7,863,017 11.81 8.94
deferred (CURRENT) block cleanout applications 548,229 0.82 0.62
dirty buffers inspected 6,236 0.01 0.01
enqueue conversions 876,816 1.32 1.00
enqueue releases 36,090,926 54.21 41.03
enqueue requests 36,091,090 54.21 41.03
enqueue timeouts 164 0.00 0.00
enqueue waits 25,166 0.04 0.03
exchange deadlocks 1 0.00 0.00
execute count 10,037,020 15.08 11.41
failed probes on index block reclamation 22 0.00 0.00
free buffer inspected 2,791,235 4.19 3.17
free buffer requested 2,874,814 4.32 3.27
gc CPU used by this session 108,516 0.16 0.12
gc cr block build time 81 0.00 0.00
gc cr block flush time 122 0.00 0.00
gc cr block receive time 2,614 0.00 0.00
gc cr block send time 301 0.00 0.00
gc cr blocks received 37,062 0.06 0.04
gc cr blocks served 117,111 0.18 0.13
gc current block flush time 29 0.00 0.00
gc current block pin time 83 0.00 0.00
gc current block receive time 1,240 0.00 0.00
gc current block send time 471 0.00 0.00
gc current blocks received 24,116 0.04 0.03
gc current blocks served 161,645 0.24 0.18
gc local grants 2,698,292 4.05 3.07
gc remote grants 8,614 0.01 0.01
gcs messages sent 590,687 0.89 0.67
ges messages sent 238,635 0.36 0.27
global enqueue get time 201,822 0.30 0.23
global enqueue gets async 387,282 0.58 0.44
global enqueue gets sync 4,879,813 7.33 5.55
global enqueue releases 5,073,080 7.62 5.77
heap block compress 23,670 0.04 0.03
hot buffers moved to head of LRU 516,764 0.78 0.59
immediate (CR) block cleanout applications 7,850 0.01 0.01
immediate (CURRENT) block cleanout applications 153,294 0.23 0.17
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 1,418,259 2.13 1.61
index fast full scans (full) 12,494 0.02 0.01
index fetch by key 32,182,210 48.34 36.59
index scans kdiixs1 21,056,925 31.63 23.94
leaf node 90-10 splits 2,983 0.00 0.00
leaf node splits 6,944 0.01 0.01
lob reads 8,260,487 12.41 9.39
lob writes 38,089 0.06 0.04
lob writes unaligned 38,039 0.06 0.04
logons cumulative 20,347 0.03 0.02
messages received 1,083,903 1.63 1.23
messages sent 1,083,729 1.63 1.23
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 500,646,734 752.05 569.18
opened cursors cumulative 8,743,641 13.13 9.94
parse count (failures) 48,505 0.07 0.06
parse count (hard) 358,213 0.54 0.41
parse count (total) 8,688,130 13.05 9.88
parse time cpu 91,834 0.14 0.10
parse time elapsed 117,646 0.18 0.13
physical read IO requests 484,387 0.73 0.55
physical read bytes 22,048,456,704 33,120.20 25,066.86
physical read total IO requests 2,077,269 3.12 2.36
physical read total bytes 49,880,496,128 74,928.23 56,709.06
physical read total multi block requests 219,385 0.33 0.25
physical reads 2,691,448 4.04 3.06
physical reads cache 2,627,329 3.95 2.99
physical reads cache prefetch 2,205,116 3.31 2.51
physical reads direct 64,131 0.10 0.07
physical reads direct (lob) 63,315 0.10 0.07
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 413,351 0.62 0.47
physical write bytes 4,440,416,256 6,670.19 5,048.30
physical write total IO requests 1,450,426 2.18 1.65
physical write total bytes 18,900,006,912 28,390.74 21,487.39
physical write total multi block requests 164,101 0.25 0.19
physical writes 542,043 0.81 0.62
physical writes direct 7,743 0.01 0.01
physical writes direct (lob) 597 0.00 0.00
physical writes direct temporary tablespace 5,097 0.01 0.01
physical writes from cache 534,300 0.80 0.61
physical writes non checkpoint 125,283 0.19 0.14
pinned buffers inspected 494 0.00 0.00
prefetch clients - default 594 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 381,494 0.57 0.43
process last non-idle time 667,383 1.00 0.76
queries parallelized 340 0.00 0.00
recovery blocks read 143 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 19,809,098 29.76 22.52
recursive cpu usage 185,727 0.28 0.21
redo blocks read for recovery 512 0.00 0.00
redo blocks written 1,524,836 2.29 1.73
redo buffer allocation retries 55 0.00 0.00
redo entries 4,465,120 6.71 5.08
redo log space requests 60 0.00 0.00
redo log space wait time 510 0.00 0.00
redo ordering marks 77,027 0.12 0.09
redo size 1,428,490,008 2,145.81 1,624.05
redo subscn max counts 113,185 0.17 0.13
redo synch time 159,840 0.24 0.18
redo synch writes 4,092,934 6.15 4.65
redo wastage 107,824,240 161.97 122.59
redo write time 232,037 0.35 0.26
redo writer latching time 220 0.00 0.00
redo writes 202,094 0.30 0.23
rollback changes - undo records applied 78 0.00 0.00
rollbacks only - consistent read gets 10,755 0.02 0.01
rows fetched via callback 36,028,168 54.12 40.96
session connect time 0 0.00 0.00
session cursor cache hits 3,844,508 5.78 4.37
session logical reads 591,726,867 888.87 672.73
session pga memory 35,172,723,136 52,834.88 39,987.82
session pga memory max 41,300,429,888 62,039.64 46,954.40
session uga memory ############### 86,769,385.60 65,670,982.54
session uga memory max 45,534,101,552 68,399.27 51,767.65
shared hash latch upgrades - no wait 1,611,551 2.42 1.83
shared hash latch upgrades - wait 0 0.00 0.00
sorts (memory) 1,421,159 2.13 1.62
sorts (rows) 320,306,333 481.15 364.16
sql area evicted 91,754 0.14 0.10
sql area purged 48,981 0.07 0.06
summed dirty queue length 7,370 0.01 0.01
switch current to new buffer 86,980 0.13 0.10
table fetch by rowid 90,080,273 135.31 102.41
table fetch continued row 5,789,660 8.70 6.58
table scan blocks gotten 324,751,798 487.83 369.21
table scan rows gotten 17,109,130,253 25,700.56 19,451.34
table scans (long tables) 159 0.00 0.00
table scans (short tables) 3,073,677 4.62 3.49
total number of times SMON posted 509 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 64 0.00 0.00
undo change vector size 521,744,992 783.74 593.17
user I/O wait time 158,385 0.24 0.18
user calls 44,407,692 66.71 50.49
user commits 205,761 0.31 0.23
user rollbacks 673,825 1.01 0.77
workarea executions - optimal 1,159,435 1.74 1.32
write clones created in foreground 43 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,549,687 1,851,785
opened cursors current 7,605 797
workarea memory allocated 2,343 176,243
logons current 567 87

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 13 0.07

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 335,707 1 3.77 7.43 176,597 0 21 6.19
SYSAUX 22,813 0 5.02 2.11 138,432 0 32 43.44
OA 62,680 0 0.82 1.05 13,425 0 12 3.33
UNDOTBS4 38 0 6.58 1.00 46,911 0 52 0.19
SYSTEM 10,439 0 3.74 2.19 35,034 0 10 111.00
THAMS 30,485 0 2.71 1.00 13 0 0 0.00
HUSSAR 20,643 0 3.21 1.00 653 0 0 0.00
TS_MAX60TEST_DATA 656 0 5.18 3.72 1,373 0 2 0.00
TEMP 343 0 4.84 13.53 815 0 0 0.00
USERS 429 0 3.87 1.00 13 0 0 0.00
UNDOTBS3 76 0 5.39 1.00 33 0 0 0.00
TS_MAX60TEST2_DATA 39 0 3.85 1.00 13 0 0 0.00
TS_MAX60TEST2_INDEX 13 0 5.38 1.00 13 0 0 0.00
TS_MAX60TEST_INDEX 13 0 6.15 1.00 13 0 0 0.00
TS_MAXIMO_INDEX 13 0 4.62 1.00 13 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 20,643 0 3.21 1.00 653 0 0 0.00
OA /dev/vgora/rdatafile10_01 20,046 0 0.84 1.10 5,985 0 12 3.33
OA /dev/vgora/rdatafile10_02 11,003 0 0.90 1.05 3,862 0 0 0.00
OA /dev/vgora/rdatafile10_03 31,631 0 0.77 1.01 3,578 0 0 0.00
SYSAUX /dev/vgora/rsysaux 22,813 0 5.02 2.11 138,432 0 32 43.44
SYSTEM /dev/vgora/rsystem 10,439 0 3.74 2.19 35,034 0 10 111.00
TEMP /dev/vgora/rtemp 343 0 4.84 13.53 815 0 0  
THAMS /dev/vgora/rdatafile10_20 30,485 0 2.71 1.00 13 0 0 0.00
TS_MAX60TEST2_DATA /dev/vgora/rmaxtest2 39 0 3.85 1.00 13 0 0 0.00
TS_MAX60TEST2_INDEX /dev/vgora/rmaxt2indx 13 0 5.38 1.00 13 0 0 0.00
TS_MAX60TEST_DATA /dev/vgora/rmaxtest 656 0 5.18 3.72 1,373 0 2 0.00
TS_MAX60TEST_INDEX /dev/vgora/rmaxtindx 13 0 6.15 1.00 13 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata1 53,885 0 3.65 6.78 18,662 0 1 10.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata2 54,568 0 3.57 6.42 40,915 0 3 6.67
TS_MAXIMO_DATA /dev/vgora/rmaxdata3 35,087 0 3.88 8.13 17,366 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata4 36,130 0 4.02 7.89 6,657 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata5 35,953 0 3.86 7.84 11,492 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata6 35,987 0 3.78 7.78 16,259 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata7 37,567 0 3.81 7.48 18,697 0 0 0.00
TS_MAXIMO_DATA /dev/vgora/rmaxdata8 46,530 0 3.77 7.89 46,549 0 17 5.88
TS_MAXIMO_INDEX /dev/vgora/rmaxdindx 13 0 4.62 1.00 13 0 0 0.00
UNDOTBS3 /dev/vgora/rdatafile4_01 76 0 5.39 1.00 33 0 0 0.00
UNDOTBS4 /dev/vgora/rdatafile4_02 38 0 6.58 1.00 46,911 0 52 0.19
USERS /dev/vgora/rusers 429 0 3.87 1.00 13 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 100 591,486,922 2,627,189 533,887 0 0 129
K 3,838 100 127,074 1 413 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 22 428 1085 2066 232200 2066  
E 0 23 349 591 1805 232200 1805  

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 4.75 77,972,322
D 384 0.20 46,056 2.24 36,663,283
D 576 0.30 69,084 1.65 27,125,297
D 768 0.40 92,112 1.34 21,989,785
D 960 0.50 115,140 1.23 20,177,101
D 1,152 0.60 138,168 1.18 19,313,435
D 1,344 0.70 161,196 1.11 18,184,633
D 1,536 0.80 184,224 1.06 17,301,100
D 1,728 0.90 207,252 1.02 16,683,714
D 1,920 1.00 230,280 1.00 16,399,004
D 2,112 1.10 253,308 0.98 16,151,111
D 2,304 1.20 276,336 0.98 16,043,283
D 2,496 1.30 299,364 0.97 15,921,602
D 2,688 1.40 322,392 0.97 15,830,789
D 2,880 1.50 345,420 0.96 15,734,077
D 3,072 1.60 368,448 0.96 15,685,525
D 3,264 1.70 391,476 0.96 15,672,437
D 3,456 1.80 414,504 0.95 15,649,767
D 3,648 1.90 437,532 0.94 15,446,351
D 3,840 2.00 460,560 0.83 13,680,165
K 16 0.50 1,919 1.00 39
K 32 1.00 3,838 1.00 39
K 48 1.50 5,757 1.00 39
K 64 2.00 7,676 1.00 39

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 450,014 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 746 2,013.87 2.29 0.11 100.00 0.00 209,710
E 2,048 1,640 640.08 172.05 26.88 100.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 867,173 867,173 0 0
64K 128K 13,624 13,624 0 0
128K 256K 2,226 2,226 0 0
256K 512K 1,019 1,019 0 0
512K 1024K 28,405 28,405 0 0
1M 2M 244,196 244,196 0 0
2M 4M 1,735 1,735 0 0
4M 8M 108 108 0 0
8M 16M 18 18 0 0
16M 32M 2 2 0 0
32M 64M 227 227 0 0
64M 128M 709 709 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 2,475,328.38 1,435,625.72 63.00 37,075
512 0.25 2,475,328.38 983,162.21 72.00 23,569
1,024 0.50 2,475,328.38 359,145.00 87.00 7,383
1,536 0.75 2,475,328.38 25,343.68 99.00 0
2,048 1.00 2,475,328.38 0.00 100.00 0
2,458 1.20 2,475,328.38 0.00 100.00 0
2,867 1.40 2,475,328.38 0.00 100.00 0
3,277 1.60 2,475,328.38 0.00 100.00 0
3,686 1.80 2,475,328.38 0.00 100.00 0
4,096 2.00 2,475,328.38 0.00 100.00 0
6,144 3.00 2,475,328.38 0.00 100.00 0
8,192 4.00 2,475,328.38 0.00 100.00 0
12,288 6.00 2,475,328.38 0.00 100.00 0
16,384 8.00 2,475,328.38 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
896 0.37 314 34,004 5,392,477 0.79 1,438,260 182.98 66,256,333
1,152 0.47 554 42,860 6,193,424 0.91 637,313 81.08 66,889,241
1,408 0.58 808 53,937 6,411,266 0.94 419,471 53.37 67,042,084
1,664 0.68 1,063 65,820 6,521,020 0.96 309,717 39.40 67,135,137
1,920 0.79 1,318 77,687 6,619,979 0.97 210,758 26.81 67,200,374
2,176 0.89 1,573 89,425 6,733,029 0.99 97,708 12.43 67,261,631
2,432 1.00 1,828 102,839 6,822,877 1.00 7,860 1.00 67,308,847
2,688 1.11 2,083 115,306 6,869,199 1.01 1 0.00 67,353,915
2,944 1.21 2,338 127,941 6,895,999 1.01 1 0.00 67,383,044
3,200 1.32 2,593 142,239 6,912,841 1.01 1 0.00 67,404,915
3,456 1.42 2,848 155,068 6,931,200 1.02 1 0.00 67,426,189
3,712 1.53 3,103 166,426 6,950,949 1.02 1 0.00 67,446,710
3,968 1.63 3,358 179,648 6,964,673 1.02 1 0.00 67,465,647
4,224 1.74 3,613 192,983 6,984,025 1.02 1 0.00 67,485,571
4,480 1.84 3,868 207,611 6,999,564 1.03 1 0.00 67,503,749
4,736 1.95 4,123 220,367 7,014,038 1.03 1 0.00 67,520,786
4,992 2.05 4,378 231,929 7,020,075 1.03 1 0.00 67,536,404

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 5 102 3 1.00 7,860 1.00 102
32 1.00 5 102 3 1.00 7,860 1.00 102
48 1.50 5 102 3 1.00 7,860 1.00 102
64 2.00 5 102 3 1.00 7,860 1.00 102

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 76 3 35
undo header 51 0 0
segment header 1 0 0
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 4,502 4,500 2 168 18 105.14
US-Undo Segment 199,095 199,095 0 20,051 6 0.29
CF-Controlfile Transaction 1,408,495 1,408,494 1 46 3 57.33
JS-Job Scheduler (queue lock) 15,743,092 15,743,092 0 532 1 2.51
PS-PX Process Reservation 2,812 2,812 0 1,586 1 0.57
HW-Segment High Water Mark 34,902 34,902 0 710 0 0.53
JS-Job Scheduler (job run lock - synchronize) 4,272 4,272 0 184 0 1.59
TM-DML 1,046,187 1,046,187 0 375 0 0.54
TT-Tablespace 88,745 88,745 0 423 0 0.39
TA-Instance Undo 3,552 3,552 0 379 0 0.35
RO-Multiple Object Reuse (fast object reuse) 2,583 2,583 0 194 0 0.62
DR-Distributed Recovery 370 370 0 51 0 1.67
FB-Format Block 1,411 1,411 0 237 0 0.31
TS-Temporary Segment 574 574 0 82 0 0.49
TX-Transaction (index contention) 10 10 0 8 0 4.38
PI-Remote PX Process Spawn Status 230 230 0 78 0 0.35
AF-Advisor Framework (task serialization) 1,645 1,645 0 22 0 0.55
IR-Instance Recovery 962 962 0 25 0 0.32
TX-Transaction (row lock contention) 15 15 0 15 0 0.33

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
22 72.17 333,599 3,521 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
27-May 16:48 18 100 2,163 2 5,760 0/0 0/0/0/0/0/0
27-May 16:38 11 208 1,561 2 5,760 0/0 0/0/0/0/0/0
27-May 16:28 23 172 961 2 5,760 0/0 0/0/0/0/0/0
27-May 16:18 16 353 1,224 3 5,760 0/0 0/0/0/0/0/0
27-May 16:08 114 441 1,147 3 5,760 0/0 0/0/0/0/0/0
27-May 15:58 31 358 547 3 5,760 0/0 0/0/0/0/0/0
27-May 15:48 38 378 0 3 5,760 0/0 0/0/0/0/0/0
27-May 15:38 26 283 2,800 2 5,760 0/0 0/0/0/0/0/0
27-May 15:28 31 281 2,199 3 5,760 0/0 0/0/0/0/0/0
27-May 15:18 16 366 1,766 2 5,760 0/0 0/0/0/0/0/0
27-May 15:08 94 246 1,166 3 5,760 0/0 0/0/0/0/0/0
27-May 14:58 14 269 2,199 2 5,760 0/0 0/0/0/0/0/0
27-May 14:48 21 198 1,598 3 5,760 0/0 0/0/0/0/0/0
27-May 14:38 12 175 1,559 2 5,760 0/0 0/0/0/0/0/0
27-May 14:28 13 244 2,159 2 5,760 0/0 0/0/0/0/0/0
27-May 14:18 11 196 1,558 2 5,760 0/0 0/0/0/0/0/0
27-May 14:08 89 381 2,330 3 5,760 0/0 0/0/0/0/0/0
27-May 13:58 25 254 1,729 3 5,760 0/0 0/0/0/0/0/0
27-May 13:48 38 214 1,129 2 5,760 0/0 0/0/0/0/0/0
27-May 13:38 10 195 1,511 3 5,760 0/0 0/0/0/0/0/0
27-May 13:28 20 234 910 3 5,760 0/0 0/0/0/0/0/0
27-May 13:18 17 237 310 3 5,760 0/0 0/0/0/0/0/0
27-May 13:08 98 371 717 3 5,760 0/0 0/0/0/0/0/0
27-May 12:58 16 202 2,558 3 5,760 0/0 0/0/0/0/0/0
27-May 12:48 9 151 1,958 2 5,760 0/0 0/0/0/0/0/0
27-May 12:38 10 181 2,302 2 5,760 0/0 0/0/0/0/0/0
27-May 12:28 14 236 2,490 3 5,760 0/0 0/0/0/0/0/0
27-May 12:18 21 177 1,747 3 5,760 0/0 0/0/0/0/0/0
27-May 12:08 111 454 1,147 3 5,760 0/0 0/0/0/0/0/0
27-May 11:58 47 212 546 3 5,760 0/0 0/0/0/0/0/0
27-May 11:48 63 335 168 3 5,760 0/0 0/0/0/0/0/0
27-May 11:38 17 244 2,793 2 5,760 0/0 0/0/0/0/0/0
27-May 11:28 9 161 2,192 2 5,760 0/0 0/0/0/0/0/0
27-May 11:18 21 274 1,649 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 454,464 0.00   0 0  
AWR Alerted Metric Element list 8,355,685 0.00 0.00 0 0  
Consistent RBA 202,108 0.00   0 0  
FAL request queue 13,347 0.00   0 0  
FAL subheap alocation 13,347 0.00   0 0  
FIB s.o chain latch 122 0.00   0 0  
FOB s.o list latch 28,618 1.30 0.82 18 0  
JS Sh mem access 4,951 14.58 1.00 0 0  
JS broadcast add buf latch 892,603 0.00   0 0  
JS broadcast drop buf latch 892,766 0.00   0 0  
JS broadcast kill buf latch 9 0.00   0 0  
JS broadcast load blnc latch 873,240 0.00   0 0  
JS mem alloc latch 11,575 0.00   0 0  
JS queue access latch 11,575 0.00   0 0  
JS queue state obj latch 31,486,184 0.00   0 0  
JS slv state obj latch 43,365 0.00   0 0  
KCL gc element parent latch 7,447,232 0.00 0.31 0 3,849 0.00
KJC destination ctx free list 15 0.00   0 0  
KJC message pool free list 91,599 0.01 0.60 0 4,535 0.00
KJCT flow control latch 730,958 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 221,884 0.00   0 0  
KSXR large replies 18,916 0.00   0 0  
KTF sga latch 3,379 0.09 0.00 0 187,260 0.00
KWQMN job cache list latch 75,255 0.14 0.99 0 0  
KWQMN to-be-Stopped Buffer list Latch 1 0.00   0 0  
MQL Tracking Latch 0     0 13,305 0.00
Memory Management Latch 0     0 221,884 0.00
OS process 44,105 0.00   0 0  
OS process allocation 250,753 0.00 1.00 0 0  
OS process: request allocation 11,961 0.13 1.00 0 0  
PL/SQL warning settings 261,639 0.00   0 0  
SGA IO buffer pool latch 216,153 0.00   0 216,153 0.00
SQL memory manager latch 185 0.00   0 218,913 0.00
SQL memory manager workarea list latch 15,786,675 0.00 0.50 0 0  
Shared B-Tree 23,556 0.00   0 0  
active checkpoint queue latch 634,641 0.00   0 0  
active service list 7,406,339 0.00 0.97 2 231,602 0.00
archive control 11,193 0.00   0 0  
archive process latch 232,261 0.00   0 0  
begin backup scn array 918 0.00   0 0  
business card 688 0.00   0 0  
cache buffer handles 33,164 0.00   0 0  
cache buffers chains 1,135,977,710 0.00 0.17 0 7,017,323 0.00
cache buffers lru chain 4,084,661 0.01 0.16 0 3,903,275 0.01
cache table scan latch 0     0 215,852 0.01
channel handle pool latch 12,804 0.00   0 0  
channel operations parent latch 40,201,359 0.00 0.01 0 0  
checkpoint queue latch 8,639,500 0.00   0 512,616 0.00
client/application info 298,099 0.00   0 0  
commit callback allocation 16,688 0.00   0 0  
compile environment latch 4,304,982 0.00   0 0  
database property service latch 3 0.00   0 0  
dictionary lookup 774 0.00   0 0  
dml lock allocation 2,103,979 0.00 0.25 0 0  
dummy allocation 41,480 0.06 0.96 0 0  
enqueue hash chains 75,965,108 0.00 0.15 0 14,978 0.00
enqueues 73,650,764 0.00 0.46 0 0  
error message lists 1,365 0.00   0 0  
event group latch 5,741 0.00   0 0  
file cache latch 67,013 0.00   0 0  
gcs domain validate latch 1 0.00   0 0  
gcs drop object freelist 3,523 0.00   0 0  
gcs opaque info freelist 232,809 0.01 0.36 0 0  
gcs partitioned table hash 9,919,132 0.00 0.00 0 0  
gcs remaster request queue 711 0.84 0.83 0 0  
gcs remastering latch 679,609 0.00 0.33 0 0  
gcs resource freelist 1,362,170 0.00 0.18 0 250,875 0.00
gcs resource hash 7,142,560 0.00 0.38 0 36 0.00
gcs resource scan list 72 0.00   0 0  
gcs resource validate list 72,628 0.00   0 0  
gcs shadows freelist 346,491 0.00   0 354,883 0.00
generalized trace enabling latch 1 0.00   0 0  
ges caches resource lists 5,248,695 0.01 0.12 0 7,895,892 0.00
ges deadlock list 48,510 0.00   0 94 0.00
ges domain table 8,776,934 0.00   0 0  
ges enqueue table freelist 9,664,754 0.00 0.28 0 0  
ges group table 13,114,658 0.00 0.40 0 0  
ges process hash list 319,841 0.00   0 375 0.00
ges process parent latch 20,088,652 0.00 0.17 0 2 0.00
ges process table freelist 11,964 0.00   0 0  
ges resource hash list 17,037,563 0.27 1.00 1 1,392,831 0.18
ges resource scan list 21,408 0.00 0.00 0 0  
ges resource table freelist 2,633,414 0.00 0.38 0 0  
ges synchronous data 178 1.12 1.00 0 97,857 0.00
ges timeout list 56,800 0.00   0 63,566 0.00
global KZLD latch for mem in SGA 1,505 0.00   0 0  
global hanganlyze operation 2 0.00   0 0  
hash table column usage latch 53,313 0.00 1.00 0 9,636,528 0.00
hash table modification latch 16,443 0.00   0 0  
internal temp table object number allocation latc 9 0.00   0 0  
job workq parent latch 0     0 27,282 0.01
job_queue_processes free list latch 1 0.00   0 0  
job_queue_processes parameter latch 22,765 0.00   0 0  
kks stats 1,935,392 0.00 0.43 0 0  
kmcptab latch 44 0.00   0 0  
kmcpvec latch 0     0 44 0.00
ksuosstats global area 44,751 0.00   0 0  
ktm global data 4,113 0.00   0 0  
kwqbsn:qsga 23,556 0.00   0 0  
lgwr LWN SCN 328,593 0.01 0.00 0 0  
library cache 45,325,056 0.01 0.59 10 1,519,530 0.01
library cache load lock 510,236 0.00 1.00 0 0  
library cache lock 32,032,269 0.01 0.60 36 0  
library cache lock allocation 430,108 0.06 0.90 5 0  
library cache pin 12,654,386 0.00 0.36 0 148 0.00
library cache pin allocation 95,610 0.07 0.94 14 0  
list of block allocation 55,836 0.01 1.00 0 0  
loader state object freelist 90,324 0.00   0 0  
longop free list parent 684 0.00   0 699 0.00
message pool operations parent latch 82,372 0.04 0.00 0 0  
messages 21,508,931 0.00 0.33 0 0  
mostly latch-free SCN 328,690 0.04 0.06 0 0  
multiblock read objects 514,452 0.00 0.00 0 0  
name-service memory objects 286,557 0.00   0 0  
name-service namespace bucket 6,545,697 0.00   0 0  
name-service namespace objects 304 0.00   0 0  
name-service pending queue 258,314 0.00   0 0  
name-service request 920 0.00   0 0  
name-service request queue 6,705,810 0.00   0 0  
ncodef allocation latch 11,033 0.00   0 0  
object queue header heap 1,276,038 0.00   0 11,069 0.00
object queue header operation 8,690,600 0.00 0.11 0 0  
object stats modification 1,139 0.00   0 2 0.00
parallel query alloc buffer 99,575 0.00 0.00 0 0  
parallel query stats 2,145 0.00   0 0  
parallel txn reco latch 198,128 0.00   0 0  
parameter list 6,050 0.00   0 0  
parameter table allocation management 25,499 0.65 0.90 1 0  
post/wait queue 355,538 0.00 0.00 0 147,965 0.00
process allocation 6,368,469 0.00 0.78 1 5,739 0.03
process group creation 11,961 0.00   0 0  
process queue 5,550 0.00   0 0  
process queue reference 103,319 0.00 0.00 0 9,921 10933.56
qmn state object latch 4 0.00   0 0  
qmn task queue latch 94,767 20.73 1.00 1 0  
query server freelists 4,600 0.00   0 0  
query server process 154 0.00   0 153 0.00
queued dump request 3,297,515 0.00   0 0  
redo allocation 859,303 0.01 0.30 0 4,465,141 0.00
redo copy 0     0 4,465,152 0.05
redo writing 1,698,911 0.00   0 0  
reg$ timeout service time 1 0.00   0 0  
resmgr group change latch 61,082 0.00   0 0  
resmgr:actses active list 40,881 0.00   0 0  
resmgr:actses change group 16,080 0.00   0 0  
resmgr:actses change state 5 0.00   0 0  
resmgr:free threads list 40,686 0.06 0.91 0 0  
resmgr:resource group CPU method 5 0.00   0 0  
resmgr:schema config 185 0.00   0 0  
row cache objects 91,148,508 0.01 0.01 0 78,940 0.02
rules engine aggregate statistics 3,945 0.00   0 0  
rules engine rule set statistics 7,890 0.00   0 0  
sequence cache 1,327,805 0.00 0.00 0 0  
session allocation 16,295,904 0.01 0.37 114 0  
session idle bit 93,100,050 0.00 0.44 17 0  
session state list latch 48,759 0.00   0 0  
session switching 11,033 0.00   0 0  
session timer 231,603 0.00   0 0  
shared pool 36,479,208 0.01 0.18 1 0  
shared pool sim alloc 165 0.00   0 0  
shared pool simulator 20,288,912 0.00 1.00 0 0  
simulator hash latch 35,233,882 0.00 0.25 0 0  
simulator lru latch 34,807,104 0.01 0.09 0 172,662 0.00
slave class 395 0.00   0 0  
slave class create 1,580 9.30 1.00 6 0  
sort extent pool 22,236 0.00   0 0  
state object free list 372 0.00   0 0  
statistics aggregation 25,903 0.00   0 0  
temp lob duration state obj allocation 42 0.00   0 0  
temporary table state object allocation 16 0.00   0 0  
threshold alerts latch 54,325 0.00   0 0  
trace latch 61 0.00   0 0  
transaction allocation 48,011 0.00 1.00 0 0  
transaction branch allocation 11,033 0.00   0 0  
undo global data 1,266,309 0.00 1.00 0 0  
user lock 45,458 0.37 0.91 1 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
ges resource hash list 17,037,563 45,160 44,965 199 0 0 0
qmn task queue latch 94,767 19,644 19,640 4 0 0 0
row cache objects 91,148,508 8,849 92 8,760 0 0 0
shared pool 36,479,208 5,141 911 4,245 0 0 0
cache buffers chains 1,135,977,710 4,780 789 3,992 0 0 0
library cache 45,325,056 4,614 2,700 2,563 0 0 0
simulator lru latch 34,807,104 4,212 384 3,828 0 0 0
session idle bit 93,100,050 2,637 1,159 1,478 0 0 0
library cache lock 32,032,269 2,385 1,441 962 0 0 0
session allocation 16,295,904 1,951 717 1,235 0 0 0
channel operations parent latch 40,201,359 1,109 14 1,095 0 0 0
JS Sh mem access 4,951 722 722 0 0 0 0
messages 21,508,931 438 144 294 0 0 0
FOB s.o list latch 28,618 371 303 76 0 0 0
enqueues 73,650,764 371 172 199 0 0 0
cache buffers lru chain 4,084,661 310 49 261 0 0 0
ges enqueue table freelist 9,664,754 290 82 208 0 0 0
ges caches resource lists 5,248,695 273 33 241 0 0 0
active service list 7,406,339 263 256 7 0 0 0
library cache lock allocation 430,108 237 214 24 0 0 0
enqueue hash chains 75,965,108 178 27 151 0 0 0
user lock 45,458 169 154 22 0 0 0
parameter table allocation management 25,499 165 149 16 0 0 0
slave class create 1,580 147 147 0 0 0 0
KCL gc element parent latch 7,447,232 140 44 96 0 0 0
mostly latch-free SCN 328,690 139 8 131 0 0 0
library cache pin 12,654,386 121 44 77 0 0 0
KWQMN job cache list latch 75,255 108 107 1 0 0 0
gcs resource hash 7,142,560 106 40 66 0 0 0
ges process parent latch 20,088,652 95 16 79 0 0 0
library cache pin allocation 95,610 64 60 4 0 0 0
redo allocation 859,303 46 14 32 0 0 0
process allocation 6,368,469 41 32 10 0 0 0
object queue header operation 8,690,600 35 4 31 0 0 0
ges resource table freelist 2,633,414 32 12 20 0 0 0
gcs opaque info freelist 232,809 25 9 16 0 0 0
dummy allocation 41,480 23 22 1 0 0 0
resmgr:free threads list 40,686 23 21 2 0 0 0
gcs resource freelist 1,362,170 22 4 18 0 0 0
OS process: request allocation 11,961 15 15 0 0 0 0
list of block allocation 55,836 8 8 0 0 0 0
kks stats 1,935,392 7 3 4 0 0 0
gcs remaster request queue 711 6 5 1 0 0 0
KJC message pool free list 91,599 5 3 2 0 0 0
ges group table 13,114,658 5 2 3 0 0 0
dml lock allocation 2,103,979 4 1 3 0 0 0
simulator hash latch 35,233,882 4 1 3 0 0 0
gcs remastering latch 679,609 3 1 2 0 0 0
SQL memory manager workarea list latch 15,786,675 2 1 1 0 0 0
ges synchronous data 178 2 2 0 0 0 0
transaction allocation 48,011 2 2 0 0 0 0
OS process allocation 250,753 1 1 0 0 0 0
hash table column usage latch 53,313 1 1 0 0 0 0
library cache load lock 510,236 1 1 0 0 0 0
shared pool simulator 20,288,912 1 1 0 0 0 0
undo global data 1,266,309 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_fobd 0 303 303
JS Sh mem access jsksGetShMemLatch 0 722 722
KCL gc element parent latch kclnfndnewm 0 11 2
KCL gc element parent latch kclzcl 0 10 0
KCL gc element parent latch kclliter 0 7 1
KCL gc element parent latch kclplz 0 5 15
KCL gc element parent latch kclulb 0 5 18
KCL gc element parent latch KCLUNLNK 0 3 1
KCL gc element parent latch kclchkping 0 3 0
KCL gc element parent latch kcldrop 0 1 0
KCL gc element parent latch kclebs 0 1 2
KCL gc element parent latch kclnfnd 0 1 7
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 3 0
KWQMN job cache list latch kwqmnprsc: loop 0 106 0
KWQMN job cache list latch kwqmnijt: populate job item 0 1 0
OS process allocation kso_delete_process:1 0 1 1
OS process: request allocation ksoreqholder_delete 0 15 15
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 1
active service list ksws_event: ksws event 0 254 254
active service list kswssyis: find service entry 1 0 2 1
active service list kswsasidlist: return list of service name 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 575 777
cache buffers chains kcbrls: kslbegin 0 193 8
cache buffers chains kcbgtcr: fast path 0 21 4
cache buffers chains kcbgcur: kslbegin 0 6 2
cache buffers chains kcbnlc 0 2 0
cache buffers chains kcbbic1 0 1 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 3
cache buffers chains kcbget: exchange rls 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers chains kclcls_3 0 1 0
cache buffers lru chain kcbzgws_1 0 43 37
cache buffers lru chain kcbzgm 0 3 0
cache buffers lru chain H_MK_PI_CR_BG 0 1 0
cache buffers lru chain kcbbic2 0 1 41
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
channel operations parent latch ksrwait() 0 11 14
channel operations parent latch ksrmfree() 0 2 0
channel operations parent latch ksrpubwait():1 0 1 0
channel operations parent latch ksrsconsume() 0 1 1
cost function kzulrl 0 154 154
dml lock allocation ktaiam 0 1 1
dummy allocation ktcdod 0 22 22
enqueue hash chains ksqgtl3 0 18 19
enqueue hash chains ksqrcl 0 7 8
enqueue hash chains ksqcmi: if lk mode requested 0 2 0
enqueues ksqgel: create enqueue 0 102 18
enqueues ksqdel 0 55 44
enqueues ksqies 0 15 110
event range base latch No latch 0 19,640 19,640
gcs opaque info freelist kjbrgrant free opaque info 0 5 0
gcs opaque info freelist kjbrcvt save opaque info 0 4 9
gcs remaster request queue kjbdomchkreq 0 3 0
gcs remaster request queue kjdrscn 0 2 0
gcs remastering latch 43 0 1 0
gcs resource freelist kjbralc add resource 0 3 3
gcs resource freelist kjbrfr free resource 0 1 1
gcs resource hash kjbcrcomplete 0 28 1
gcs resource hash kclzcl 0 3 3
gcs resource hash kjblocalfile_nolock 0 2 1
gcs resource hash kjbrrcres_99 0 2 0
gcs resource hash kclfwrite1 0 1 0
gcs resource hash kjbassume 0 1 0
gcs resource hash kjbmdowncvt 0 1 11
gcs resource hash kjbrdrmcvtq_98 0 1 0
gcs resource hash kjbrrcfwst 0 1 0
ges enqueue table freelist kjlalc: lock allocation 0 72 61
ges enqueue table freelist kjlfr: remove lock from parent object 0 10 21
ges group table kjgagll: move a lock from process lock list to group lock list 0 1 1
ges group table kjgdgll: move a lock from group lock list to process lock list 0 1 1
ges process parent latch kjata 0 14 0
ges process parent latch kjatb 0 1 1
ges process parent latch kjlrem: detach lock from group 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 18,963 64
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 15,064 3
ges resource hash list kjrmas1: lookup master node 0 8,328 0
ges resource hash list kjlrlr: remove lock from resource queue 0 1,222 15,675
ges resource hash list kjucvl: lock convert request 0 813 28,902
ges resource hash list kjcvscn: remove from scan queue 0 539 0
ges resource hash list kjrref: find matched resource 0 32 320
ges resource hash list kjtscn: try lock res with nowait 0 3 0
ges resource hash list kjfcrmd: mark valueblock dubious 0 1 0
ges resource table freelist kjruch: cached obj cleanup 0 20 0
ges resource table freelist kjchc: clean resource cache 0 10 0
ges resource table freelist kjralc: resource allocation 0 8 5
ges resource table freelist kjrfr: remove from resource table 0 4 7
ges resource table freelist kjrm2c: move resource to cache 0 2 33
ges resource table freelist kjrchc: cached obj cleanup 0 1 0
ges synchronous data kjfscpl: get sync data latch in nowait 0 2 0
hash table column usage latch KSXMMON_GETCELEM 0 1 0
kks stats kks stats alloc/free 0 3 3
lgwr LWN SCN kcs023 0 7 0
library cache kglScanDependency 0 757 0
library cache kglhdgn: child: 0 294 586
library cache kglobpn: child: 0 213 291
library cache kgldti: 2child 0 122 4
library cache kglLockCursor 0 73 164
library cache kglpndl: child: before processing 0 58 68
library cache kglpndl: child: after processing 0 44 32
library cache kgldte: child 0 0 40 377
library cache kglhdgc: child: 0 31 0
library cache kglpnp: child 0 15 71
library cache kglati 0 10 0
library cache kglic 0 8 0
library cache kqlmbfre: child: in loop 0 5 7
library cache kglukp: child 0 4 4
library cache kglpin 0 2 38
library cache kqlmbfre: child: no obj to free 0 2 0
library cache kglivl: child 0 1 0
library cache kglobld 0 1 0
library cache kglpin: child: KGLMX 0 1 0
library cache load lock kglllal: llatch 0 1 1
library cache lock kgllkdl: child: cleanup 0 1,358 1,374
library cache lock kgllkdl: child: no lock handle 0 805 975
library cache lock kgllkal: child: multiinstance 0 83 67
library cache lock ksucallcbksafely: kqllhng 0 1 0
library cache lock allocation kgllkrel 0 213 214
library cache lock allocation kgllkget 0 1 0
library cache pin kglpnal: child: alloc space 0 16 38
library cache pin kqlmbpil: child 0 9 0
library cache pin kglpndl 0 8 2
library cache pin kqlmbp: child 0 8 1
library cache pin kglpnp: child 0 3 3
library cache pin allocation kglpnrel 0 60 60
list of block allocation ktcdod 0 8 8
messages ksarcv: after wait 0 95 108
messages ksarcv 0 34 15
messages ksaamb: after wakeup 0 15 21
mostly latch-free SCN kcslcu3 0 1 8
object queue header operation kcbw_link_q 0 3 0
object queue header operation kcbo_switch_cq 0 1 0
parameter table allocation management ksp_param_table_free 0 149 149
process allocation ksufap: active procs 0 24 7
process allocation ksucrp 0 7 0
process allocation ksudlp 0 1 9
redo allocation kcrfw_redo_gen: redo allocation 1 0 14 0
resmgr:free threads list kgskthrsod 0 21 21
row cache objects kqrpre: find obj 0 48 65
row cache objects kqreqd: reget 0 19 0
row cache objects kqreqd 0 12 1
row cache objects kqrso 0 8 0
row cache objects kqrbip 0 2 0
row cache objects kqrigt 0 2 9
row cache objects kqrbgl 0 1 14
session allocation ksuxds: KSUSFCLC not set 0 584 572
session allocation ksucri 0 72 122
session allocation ksuxds: not user session 0 25 6
session allocation ksuprc 0 23 8
session allocation ksudlc 0 10 0
session allocation ksucrp 0 1 4
session allocation ksudlp 0 1 1
session allocation kxfpqidqr 0 1 5
session idle bit ksupuc: set busy 0 789 770
session idle bit ksupuc: clear busy 0 323 319
session idle bit ksuxds 0 50 73
shared pool kghalo 0 672 224
shared pool kghfrunp: clatch: nowait 0 210 0
shared pool kghfre 0 110 89
shared pool kghupr1 0 56 538
shared pool kghalp 0 48 54
shared pool kghfrunp: alloc: wait 0 18 0
shared pool kghasp 0 7 6
shared pool kghfrunp: clatch: wait 0 3 83
shared pool simulator kglsim_upd_newhp 0 1 0
simulator hash latch kcbs_lookup_setid: lookup dba 0 1 0
simulator lru latch kcbs_simulate: simulate set 0 383 384
simulator lru latch kcbssck 0 1 0
slave class create ksvcreate 0 147 0
transaction allocation ktcdod 0 1 1
transaction allocation ktcxbr 0 1 1
undo global data kturimugur: child 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
CTXSYS SYSAUX SYS_IOT_TOP_40951   INDEX 87,943,888 14.86
DAGLADMIN OA GWLIST   TABLE 76,329,120 12.90
DAGLADMIN OA INFOLIST_1   TABLE 51,854,656 8.76
MAXIMO TS_MAXIMO_DATA WORKORDER   TABLE 39,107,088 6.61
MAXIMO TS_MAXIMO_DATA MAXMENU   TABLE 37,704,528 6.37

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 2,058,857 76.50
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX3   INDEX 57,773 2.15
MAXIMO TS_MAXIMO_DATA DR$WFASSIGNMDES_TIDX$I   TABLE 36,040 1.34
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX2   INDEX 18,641 0.69
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT_ORID   INDEX 17,364 0.65

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
DAGLADMIN OA MANAGEROFDEPT   TABLE 24 58.54
MAXIMO TS_MAXIMO_DATA WFASSIGNMENTU_NDX   INDEX 4 9.76
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX3   INDEX 4 9.76
MAXIMO TS_MAX60TEST_DATA WOTHRJPREC   TABLE 4 9.76
MAXIMO TS_MAX60TEST_DATA WOTHELECPREC   TABLE 2 4.88

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
DAGLADMIN OA MANAGEROFDEPT   TABLE 12 57.14
SYS SYSTEM SCHEDULER$_JOB   TABLE 4 19.05
MAXIMO TS_MAXIMO_DATA WFASSIGNMENTU_NDX   INDEX 2 9.52
MAXIMO TS_MAXIMO_DATA MAXSESSION   TABLE 1 4.76
MAXIMO TS_MAX60TEST_DATA WOTHELECPREC   TABLE 1 4.76

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
CTXSYS SYSAUX SYS_IOT_TOP_40951   INDEX 28 73.68
MAXIMO TS_MAXIMO_DATA MAXSESSION   TABLE 6 15.79
MAXIMO TS_MAXIMO_DATA MAXMODULES   TABLE 3 7.89
MAXIMO TS_MAXIMO_DATA L_MAXMODULES_NDX1   INDEX 1 2.63

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SYS SYSTEM JOB$   TABLE 6,832 18.43
SYS SYSTEM I_JOB_NEXT   INDEX 6,816 18.39
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 2,849 7.69
MAXIMO TS_MAXIMO_DATA MAXSESSION   TABLE 2,036 5.49
MAXIMO TS_MAXIMO_DATA WFTRANSACTION_NDX1   INDEX 1,488 4.01

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
MAXIMO TS_MAXIMO_DATA WFASSIGN_NDX2   INDEX 3,747 15.54
SYS SYSTEM I_JOB_NEXT   INDEX 1,702 7.06
SYS SYSTEM JOB$   TABLE 1,702 7.06
MAXIMO TS_MAXIMO_DATA WFASSIGNMENT   TABLE 1,666 6.91
SYS SYSTEM COL_USAGE$   TABLE 998 4.14

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 12,269 0.46 0   327 1
dc_constraints 990 33.54 0   990 0
dc_files 644 0.00 0   0 23
dc_global_oids 81,782 0.12 0   0 43
dc_histogram_data 8,399,941 0.23 0   12,723 5,734
dc_histogram_defs 9,033,492 0.47 0   10,629 6,459
dc_object_grants 76,631 0.13 0   0 239
dc_object_ids 8,668,969 0.07 0   507 1,981
dc_objects 1,049,666 0.61 0   6,578 1,171
dc_profiles 19,041 0.00 0   0 1
dc_rollback_segments 495,342 0.00 0   10 58
dc_segments 1,970,639 0.25 0   2,406 1,911
dc_sequences 16,704 2.97 0   16,704 29
dc_table_scns 62 100.00 0   0 0
dc_tablespace_quotas 18 27.78 0   7 1
dc_tablespaces 2,274,559 0.00 0   0 18
dc_usernames 127,519 0.02 0   0 13
dc_users 3,430,661 0.00 0   0 54
outstanding_alerts 23,269 18.98 0   3,945 15

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 711 57 0
dc_constraints 1,650 1 1
dc_global_oids 102 0 104
dc_histogram_defs 57,926 1,913 18,822
dc_object_ids 6,845 0 5,039
dc_objects 20,849 271 3,909
dc_rollback_segments 40 20 0
dc_segments 9,202 49 4,511
dc_sequences 33,408 344 157
dc_table_scns 62 0 0
dc_tablespace_quotas 36 0 4
dc_tablespaces 6 0 7
dc_usernames 24 0 24
dc_users 30 0 30
outstanding_alerts 43,638 2,443 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 162,017 0.01 597,855 0.02 75 0
CLUSTER 691 0.87 1,396 1.15 10 0
INDEX 1,686 48.04 10,006 14.48 170 0
SQL AREA 277,246 99.49 12,404,501 8.22 78,596 2,359
TABLE/PROCEDURE 223,233 0.66 2,950,610 0.55 8,070 0
TRIGGER 24,555 0.49 204,241 0.18 240 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY 14 24 27 23 0
CLUSTER 1,396 21 6 11 0
INDEX 10,006 3,054 954 2,011 0
TABLE/PROCEDURE 736,317 25,681 1,738 18,593 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 1,694.41   2.98 3.25 40 46 569 569
  Freeable 287.13 0.00 0.72 0.34 1   398 398
  PL/SQL 19.93 13.55 0.04 0.01 0 0 567 567
  SQL 12.83 6.40 0.02 0.07 1 77 554 486
E Other 411.01   4.57 10.23 73 73 90 90
  SQL 174.87 173.30 2.33 11.38 64 64 75 45
  Freeable 52.19 0.00 0.80 0.70 6   65 65
  PL/SQL 2.07 1.56 0.02 0.02 0 0 88 87

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 26.41 26.41 0.00
java joxlod exec hp 5.40 5.40 0.00
shared CCursor 187.58 185.53 -1.10
shared Heap0: KGL 105.80 97.75 -7.61
shared PCursor 139.61 139.25 -0.26
shared free memory 190.49 196.65 3.24
shared gcs resources 38.97 38.97 0.00
shared gcs shadows 24.55 24.55 0.00
shared ges enqueues 25.48 25.48 0.00
shared ges resource 36.23 36.23 0.00
shared kglsim object batch 42.73 43.01 0.66
shared library cache 200.66 194.91 -2.87
shared sql area 1,176.65 1,189.77 1.12
  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

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 179,043 225,369 265255 265255
gcs_shadows 256,803 265,214 265255 265255


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 2   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=vip2)(PORT=1521))   
log_archive_dest_1 location=/arch2   
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   
shadow_core_dump partial PARTIAL
shared_pool_size 2550136832   
spfile /dev/vgora/rspfile   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS4   
user_dump_dest /u01/oracle/admin/gddsdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 19,950 0.03 0.02
acks for commit broadcast(logical) 20,356 0.03 0.02
broadcast msgs on commit(actual) 24,941 0.04 0.03
broadcast msgs on commit(logical) 25,975 0.04 0.03
broadcast msgs on commit(wasted) 928 0.00 0.00
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 1 0.00 0.00
flow control messages received 6 0.00 0.00
flow control messages sent 3 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 96,799 0.15 0.11
gcs ast xid 0 0.00 0.00
gcs blocked converts 25,504 0.04 0.03
gcs blocked cr converts 87,586 0.13 0.10
gcs compatible basts 125 0.00 0.00
gcs compatible cr basts (global) 4,141 0.01 0.00
gcs compatible cr basts (local) 91,496 0.14 0.10
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,893 0.01 0.01
gcs dbwr write request msgs 4,860 0.01 0.01
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 12,750 0.02 0.01
gcs immediate (null) converts 49,042 0.07 0.06
gcs immediate cr (compatible) converts 19 0.00 0.00
gcs immediate cr (null) converts 624,944 0.94 0.71
gcs indirect ast 29,242 0.04 0.03
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,625 0.00 0.00
gcs msgs process time(ms) 18,586 0.03 0.02
gcs msgs received 834,761 1.25 0.95
gcs out-of-order msgs 2 0.00 0.00
gcs pings refused 8 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 9,571 0.01 0.01
gcs side channel msgs actual 14,495 0.02 0.02
gcs side channel msgs logical 68,030 0.10 0.08
gcs stale cr 73,591 0.11 0.08
gcs undo cr 1 0.00 0.00
gcs write notification msgs 400 0.00 0.00
gcs writes refused 41 0.00 0.00
ges msgs process time(ms) 54,226 0.08 0.06
ges msgs received 204,540 0.31 0.23
global posts dropped 0 0.00 0.00
global posts queue time 11,098 0.02 0.01
global posts queued 1,233 0.00 0.00
global posts requested 1,501 0.00 0.00
global posts sent 1,233 0.00 0.00
implicit batch messages received 23,266 0.03 0.03
implicit batch messages sent 11,010 0.02 0.01
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 61,538 0.09 0.07
messages queue sent actual 209,958 0.32 0.24
messages queue sent logical 234,219 0.35 0.27
messages received actual 483,661 0.73 0.55
messages received logical 1,039,301 1.56 1.18
messages sent directly 129,123 0.19 0.15
messages sent indirectly 280,166 0.42 0.32
messages sent not implicit batched 198,948 0.30 0.23
messages sent pbatched 591,224 0.89 0.67
msgs causing lmd to send msgs 86,262 0.13 0.10
msgs causing lms(s) to send msgs 74,451 0.11 0.08
msgs received queue time (ms) 3,651,993 5.49 4.15
msgs received queued 1,039,274 1.56 1.18
msgs sent queue time (ms) 61,693 0.09 0.07
msgs sent queue time on ksxp (ms) 900,954 1.35 1.02
msgs sent queued 230,843 0.35 0.26
msgs sent queued on ksxp 389,437 0.58 0.44
process batch messages received 182,134 0.27 0.21
process batch messages sent 172,225 0.26 0.20


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 111,791
CURRENT Block Requests 5,337
Data Block Requests 111,818
Undo Block Requests 1
TX Block Requests 115
Current Results 117,116
Private results 0
Zero Results 12
Disk Read Results 0
Fail Results 0
Fairness Down Converts 23,031
Fairness Clears 0
Free GC Elements 0
Flushes 613
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 627
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 161,647 99.99 0.01 0.00 0.00 0.00
Flushes 21 0.00 47.62 52.38 0.00 0.00
Writes 6,638 0.00 26.20 73.56 0.15 0.09


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 35,899 99.82 0.14 0.03 23,358 99.70 0.27 0.03
1 Others 912 98.90 1.10 0.00 730 98.49 1.51 0.00
1 undo header 251 85.66 14.34 0.00 28 100.00 0.00 0.00


Back to Top

End of Report