WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
XJHBDB4063371540xjhbdb2210.2.0.5.0YEShp580hbdb2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:57219-Feb-14 10:00:1240 5.3
End Snap:57319-Feb-14 11:52:2135 1.9
Elapsed:  112.16 (mins)  
DB Time:  1,538.34 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 9,056M 9,056MStd Block Size: 8K
Shared Pool Size: 1,136M 1,136MLog Buffer: 14,316K

Load Profile

Per SecondPer Transaction
Redo size: 426.80 18,896.50
Logical reads: 16.23 718.53
Block changes: 1.95 86.50
Physical reads: 0.59 26.18
Physical writes: 0.08 3.68
User calls: 0.20 8.77
Parses: 0.56 24.86
Hard parses: 0.02 1.03
Sorts: 0.54 23.98
Logons: 0.04 1.57
Executes: 1.19 52.70
Transactions: 0.02 

% Blocks changed per Read: 12.04Recursive Call %: 97.75
Rollback per transaction %: 85.53Rows per Sort: 57.11

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 66.26Redo NoWait %: 100.00
Buffer Hit %: 96.36In-memory Sort %: 100.00
Library Hit %: 96.58Soft Parse %: 95.84
Execute to Parse %: 52.84Latch Hit %: 99.67
Parse CPU to Parse Elapsd %: 12.24% Non-Parse CPU: 98.65

Shared Pool Statistics

BeginEnd
Memory Usage %: 75.79 76.27
% SQL with executions>1: 96.54 95.36
% Memory for SQL w/exec>1: 92.36 92.46

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
gc buffer busy 37,413 32,663 873 35.4Cluster
gc cr block lost 16,902 15,323 907 16.6Cluster
gc cr multi block request 13,591 5,619 413 6.1Cluster
enq: WF - contention 299 133 444 .1Other
CPU time  65  .1 

RAC Statistics

BeginEnd
Number of Instances: 2 1

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1.37 60.64
Global Cache blocks served: 0.97 42.93
GCS/GES messages received: 5.89 260.85
GCS/GES messages sent: 9.54 422.55
DBWR Fusion writes: 0.01 0.32
Estd Interconnect traffic (KB) 21.73 

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

Buffer access - local cache %: 87.92
Buffer access - remote cache %: 8.44
Buffer access - disk %: 3.64

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 129.0
Avg global cache cr block receive time (ms): 1.2
Avg global cache current block receive time (ms): 1.9
Avg global cache cr block build time (ms): 0.1
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 0.0
Avg global cache cr block flush time (ms): 
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.6
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.1
Avg GES message process time (ms): 0.1
% of direct sent messages: 20.32
% of indirect sent messages: 58.81
% of flow controlled messages: 20.87

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 170,648.04 184.88
DB CPU 65.37 0.07
parse time elapsed 2.84 0.00
hard parse elapsed time 2.67 0.00
PL/SQL compilation elapsed time 2.39 0.00
PL/SQL execution elapsed time 0.38 0.00
hard parse (sharing criteria) elapsed time 0.15 0.00
hard parse (bind mismatch) elapsed time 0.12 0.00
connection management call elapsed time 0.03 0.00
repeated bind elapsed time 0.00 0.00
DB time 92,300.17  
background elapsed time 184,036.56  
background cpu time 256.43  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Cluster 68,211 0 53,634 786 58.11
Other 107,488 95 151 1 0.16
CPU time     65   0.07
Concurrency 37,678 1 26 1 0.03
System I/O 18,488   18 1 0.02
User I/O 3,398   7 2 0.01
Commit 15 20 1 34 0.00
Configuration 65   0 2 0.00
Network 312   0 0 0.00
Application 10   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 37,413 0 32,663 873 246.14
gc cr block lost 16,902 0 15,323 907 111.20
gc cr multi block request 13,591 0 5,619 413 89.41
enq: WF - contention 299 82 133 444 1.97
gc domain validation 21 48 20 956 0.14
latch: cache buffers chains 36,542   17 0 240.41
control file sequential read 15,811   13 1 104.02
gc cr failure 8 75 8 1022 0.05
db file sequential read 3,240   6 2 21.32
os thread startup 93   6 63 0.61
gcs resource directory to be unfrozen 19   5 258 0.13
control file parallel write 2,275   4 2 14.97
CGS wait for IPC msg 66,774 100 3 0 439.30
wait for votes 88 100 3 30 0.58
cursor: pin S wait on X 242 99 3 10 1.59
ges enter server mode 5 20 2 317 0.03
cr request retry 23,251 100 1 0 152.97
DFS lock handle 1,289   1 1 8.48
ges lmd/lmses to freeze in rcfg - mrcvr 110 71 1 8 0.72
gcs enter server mode 2 50 1 430 0.01
name-service call wait 16   1 49 0.11
read by other session 57   1 13 0.38
db file scattered read 95   1 6 0.63
log file sync 15 20 1 34 0.10
log file parallel write 189   0 2 1.24
row cache lock 614   0 1 4.04
reliable message 454   0 1 2.99
enq: PS - contention 338   0 1 2.22
ges2 LMON to wake up lms - mrcvr 2 12 92 0 21 0.08
gc current block 2-way 163   0 1 1.07
PX Deq: reap credit 6,653 96 0 0 43.77
latch free 16   0 9 0.11
ksxr poll remote instances 7,204 76 0 0 47.39
PX Deq Credit: send blkd 303 50 0 0 1.99
checkpoint completed 21   0 5 0.14
gc cr block 2-way 73   0 1 0.48
enq: TX - index contention 8   0 8 0.05
log file sequential read 15   0 4 0.10
library cache load lock 9   0 6 0.06
kksfbc child completion 1 100 0 50 0.01
rdbms ipc reply 274   0 0 1.80
PX Deq: Signal ACK 250 32 0 0 1.64
IPC send completion sync 56 100 0 1 0.37
gc current grant busy 30   0 1 0.20
gc cr block busy 2   0 15 0.01
db file parallel write 143   0 0 0.94
enq: SQ - contention 44   0 1 0.29
buffer busy waits 64   0 0 0.42
library cache pin 82   0 0 0.54
global enqueue expand wait 2 100 0 10 0.01
ges global resource directory to be frozen 1 100 0 20 0.01
CSS initialization 3   0 5 0.02
direct path read 2   0 4 0.01
library cache lock 10   0 1 0.07
Streams AQ: qmn coordinator waiting for slave to start 1   0 8 0.01
gc current grant 2-way 8   0 1 0.05
enq: JS - job run lock - synchronize 3   0 2 0.02
gcs log flush sync 16   0 0 0.11
enq: MW - contention 4   0 1 0.03
CSS operation: action 7   0 0 0.05
enq: DR - contention 4   0 1 0.03
log file single write 8   0 0 0.05
KJC: Wait for msg sends to complete 6   0 0 0.04
recovery read 45   0 0 0.30
enq: AF - task serialization 1   0 1 0.01
latch: shared pool 13   0 0 0.09
PX qref latch 3   0 0 0.02
SQL*Net message to client 307   0 0 2.02
CSS operation: data query 1   0 1 0.01
latch: cache buffers lru chain 2   0 0 0.01
direct path write 4   0 0 0.03
latch: gcs resource hash 8   0 0 0.05
control file single write 1   0 0 0.01
CSS operation: query 1   0 0 0.01
latch: KCL gc element parent latch 2   0 0 0.01
SQL*Net break/reset to client 10   0 0 0.07
ges lmd/lmses to unfreeze in rcfg - mrcvr 1   0 0 0.01
latch: cache buffer handles 2   0 0 0.01
latch: library cache 1   0 0 0.01
cursor: pin S 1   0 0 0.01
SQL*Net more data from client 5   0 0 0.03
LGWR wait for redo copy 2   0 0 0.01
buffer deadlock 1 100 0 0 0.01
latch: session allocation 1   0 0 0.01
Log archive I/O 1   0 0 0.01
latch: object queue header operation 1   0 0 0.01
gcs remote message 1,823,004 98 52,427 29 11,993.45
SQL*Net message from client 305   13,743 45057 2.01
PX Idle Wait 2,994 94 7,089 2368 19.70
virtual circuit status 225 100 6,590 29288 1.48
DIAG idle wait 33,499   6,567 196 220.39
ges remote message 91,008 92 6,566 72 598.74
Streams AQ: qmn slave idle wait 239   6,556 27432 1.57
Streams AQ: qmn coordinator idle wait 475 50 6,547 13784 3.13
Streams AQ: waiting for time management or cleanup tasks 3 67 6,423 2140909 0.02
jobq slave wait 80 100 234 2931 0.53
Streams AQ: waiting for messages in the queue 2   8 3855 0.01
PX Deq: Par Recov Execute 97   7 69 0.64
PX Deq: Execution Msg 597 7 1 2 3.93
PX Deq: Join ACK 397 33 0 1 2.61
PX Deq: Parse Reply 356 33 0 1 2.34
PX Deq: Msg Fragment 271 7 0 1 1.78
PX Deq: Par Recov Reply 67   0 2 0.44
PX Deq: Execute Reply 330 29 0 0 2.17
class slave wait 67   0 1 0.44
Streams AQ: RAC qmn coordinator idle wait 476 100 0 0 3.13

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file sequential read 14,578   13 1 95.91
events in waitclass Other 42,028 92 9 0 276.50
gc domain validation 7 43 6 904 0.05
os thread startup 93   6 63 0.61
gc cr failure 4 75 4 1108 0.03
control file parallel write 2,275   4 2 14.97
db file sequential read 2,203   1 1 14.49
log file parallel write 189   0 2 1.24
db file scattered read 28   0 6 0.18
log file sequential read 15   0 4 0.10
gc cr block busy 1   0 29 0.01
db file parallel write 143   0 0 0.94
row cache lock 123   0 0 0.81
library cache pin 11   0 0 0.07
log file single write 8   0 0 0.05
control file single write 1   0 0 0.01
Log archive I/O 1   0 0 0.01
rdbms ipc message 105,767 92 91,536 865 695.84
gcs remote message 1,822,998 98 52,427 29 11,993.41
pmon timer 2,268 100 6,567 2896 14.92
DIAG idle wait 33,499   6,567 196 220.39
ges remote message 91,004 92 6,566 72 598.71
Streams AQ: qmn slave idle wait 239   6,556 27432 1.57
Streams AQ: qmn coordinator idle wait 475 50 6,547 13784 3.13
Streams AQ: waiting for time management or cleanup tasks 3 67 6,423 2140909 0.02
smon timer 6   26 4401 0.04
PX Deq: Par Recov Reply 67   0 2 0.44
Streams AQ: RAC qmn coordinator idle wait 476 100 0 0 3.13
PX Deq: Join ACK 13   0 1 0.09

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 38,753
IDLE_TIME 21,493,632
IOWAIT_TIME 40,973
NICE_TIME 227
SYS_TIME 19,761
USER_TIME 16,412
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 368,221,184
VM_OUT_BYTES 592,351,232
PHYSICAL_MEMORY_BYTES 33,736,904,704
NUM_CPUS 32
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 92,298.40 63.60 120 4,363
SYS$BACKGROUND 0.10 0.10 3,777 99,514
xjhbdb 0.00 0.00 0 0
xjhbdbXDB 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 105 0 131 0 0 0 312 0
SYS$BACKGROUND 3290 7 37538 26 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
144,399 176 2 72199.44 156.44 b6b0ujx89mmnc   select o.owner#, o.obj#, decod...
43,195 17 1 43194.55 46.80 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
43,195 17 1 43194.55 46.80 crqkznuh5t6fs DBMS_SCHEDULER UPDATE SYS.WRI$_SEGADV_OBJLIST...
39,160 22 7 5594.27 42.43 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
35,156 24 1 35155.99 38.09 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
35,156 24 1 35155.99 38.09 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
5,180 4 2 2589.80 5.61 fsb35xh35m345 sqlplus@hp580hbdb2 (TNS V1-V3) select count(*) from dba_segme...
3 0 1 3.28 0.00 6w3rdsz64hdhk   select min(timeout) from sys.r...
3 0 1 3.20 0.00 79w2cqu2gmjm8   select 1 from aq$_schedules
3 0 6 0.51 0.00 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
176 144,399 2 87.91 268.95 156.44 b6b0ujx89mmnc   select o.owner#, o.obj#, decod...
24 35,156 1 24.11 36.88 38.09 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
24 35,156 1 24.11 36.88 38.09 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
22 39,160 7 3.10 33.21 42.43 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
17 43,195 1 16.64 25.45 46.80 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
17 43,195 1 16.64 25.45 46.80 crqkznuh5t6fs DBMS_SCHEDULER UPDATE SYS.WRI$_SEGADV_OBJLIST...
4 5,180 2 1.86 5.70 5.61 fsb35xh35m345 sqlplus@hp580hbdb2 (TNS V1-V3) select count(*) from dba_segme...
3 3 1 2.71 4.15 0.00 bunssq950snhf   insert into wrh$_sga_target_ad...
2 2 224 0.01 3.42 0.00 aykvshm7zsabd   select size_for_estimate, size...
2 2 1 1.77 2.71 0.00 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
1 1 111 0.01 1.09 0.00 7frqszzdu8sgg racgimon@hp580hbdb2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
1 1 1 0.69 1.05 0.00 b7jn4mf49n569   select o.name, u.name from obj...

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
57,523 7 8,217.57 52.67 21.71 39159.90 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
11,908 59 201.83 10.90 0.58 2.02 bh27jbn2c9bq8   SELECT count(*) as occur_count...
9,465 3 3,155.00 8.67 0.23 0.72 cf621qmts91wf   SELECT /*+ ordered use_nl(stat...
7,776 6 1,296.00 7.12 0.21 3.06 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...
7,480 3 2,493.33 6.85 0.29 1.35 dgyj6z7xacxjm   SELECT /*+ ordered use_nl(stat...
5,351 2 2,675.50 4.90 3.73 5179.60 fsb35xh35m345 sqlplus@hp580hbdb2 (TNS V1-V3) select count(*) from dba_segme...
4,876 1 4,876.00 4.46 0.69 1.33 b7jn4mf49n569   select o.name, u.name from obj...
4,421 512 8.63 4.05 0.17 0.36 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
3,657 2 1,828.50 3.35 175.82 144398.89 b6b0ujx89mmnc   select o.owner#, o.obj#, decod...
3,630 242 15.00 3.32 0.05 0.08 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
3,630 242 15.00 3.32 0.04 0.05 csnp95dz2r8ss   select file#, block# from recy...
2,688 1,344 2.00 2.46 0.14 0.26 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
1,511 6 251.83 1.38 0.11 1.32 gqabj2m771r38   SELECT /*+ ordered use_nl(stat...
1,276 6 212.67 1.17 0.09 0.29 gwbj9cspdpgq8   SELECT ash.sql_id, ash.sql_opc...

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,960 1 1,960.00 49.25 0.69 1.33 b7jn4mf49n569   select o.name, u.name from obj...
898 7 128.29 22.56 21.71 39159.90 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
311 1 311.00 7.81 0.12 0.25 c7sn076yz7030   select smontabv.cnt, smontab.t...
302 59 5.12 7.59 0.58 2.02 bh27jbn2c9bq8   SELECT count(*) as occur_count...
116 6 19.33 2.91 0.11 1.32 gqabj2m771r38   SELECT /*+ ordered use_nl(stat...
62 2 31.00 1.56 175.82 144398.89 b6b0ujx89mmnc   select o.owner#, o.obj#, decod...
48 3 16.00 1.21 0.21 2.57 65vuzhm491wk9 racgimon@hp580hbdb2 (TNS V1-V3) DECLARE reason_id dbms_server...
37 1 37.00 0.93 0.08 0.33 ayyw8ywjuqak1   select t.schema, t.name, t.obj...
34 182 0.19 0.85 0.04 3.06 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
33 6 5.50 0.83 0.08 1.26 51fpg24fxb8k9   SELECT startsn.stat_id, smap.k...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,344 0 0.00 0.00 0.00 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
512 512 1.00 0.00 0.00 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
470 469 1.00 0.00 0.00 f80h0xb1qvbsk   SELECT sys.wri$_adv_seq_msggro...
242 242 1.00 0.00 0.00 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
242 0 0.00 0.00 0.00 csnp95dz2r8ss   select file#, block# from recy...
224 2,688 12.00 0.00 0.00 772s25v1y0x8k   select shared_pool_size_for_es...
224 4,704 21.00 0.01 0.01 aykvshm7zsabd   select size_for_estimate, size...
206 222 1.08 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
190 0 0.00 0.00 0.00 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
182 175 0.96 0.00 0.02 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
114 114 1.00 0.00 0.00 1yyh2fdqqguz8   INSERT INTO sys.wri$_adv_findi...
111 111 1.00 0.01 0.01 7frqszzdu8sgg racgimon@hp580hbdb2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
95 95 1.00 0.00 0.00 0sxrub8cckxb7   INSERT INTO sys.wri$_adv_actio...
95 95 1.00 0.00 0.00 2gxbvynrd71dr   INSERT INTO sys.wri$_adv_rec_a...
95 95 1.00 0.00 0.00 g39ah6rgvvxbv   INSERT INTO sys.wri$_adv_recom...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
512 512 13.55 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
470 470 12.44 f80h0xb1qvbsk   SELECT sys.wri$_adv_seq_msggro...
242 242 6.41 6xvp6nxs4a9n4   select nvl(sum(space), 0) from...
242 242 6.41 csnp95dz2r8ss   select file#, block# from recy...
206 206 5.45 0h6b2sajwb74n   select privilege#, level from ...
190 190 5.03 c4nhd1ntptxq7 MMON_SLAVE select message_level, sequence...
114 114 3.02 1yyh2fdqqguz8   INSERT INTO sys.wri$_adv_findi...
111 111 2.94 7frqszzdu8sgg racgimon@hp580hbdb2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
95 95 2.51 0sxrub8cckxb7   INSERT INTO sys.wri$_adv_actio...
95 95 2.51 2gxbvynrd71dr   INSERT INTO sys.wri$_adv_rec_a...
95 95 2.51 g39ah6rgvvxbv   INSERT INTO sys.wri$_adv_recom...
77 77 2.04 2q817mk1r7sw8   INSERT INTO sys.wri$_adv_ratio...
75 75 1.99 2ym6hhaq30r73   select type#, blocks, extents,...
69 69 1.83 04p9rnacfgfsn   INSERT INTO sys.wri$_adv_objec...
69 69 1.83 7d72r1ca0x4cs   SELECT attr4 FROM WRI$_ADV_OBJ...
59 59 1.56 bh27jbn2c9bq8   SELECT count(*) as occur_count...
47 47 1.24 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

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
144,219.14 99.88 144,398.89 175.82 2 b6b0ujx89mmnc   select o.owner#, o.obj#, decod...
43,177.14 99.96 43,194.55 16.64 1 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
43,177.14 99.96 43,194.55 16.64 1 crqkznuh5t6fs DBMS_SCHEDULER UPDATE SYS.WRI$_SEGADV_OBJLIST...
39,022.27 99.65 39,159.90 21.71 7 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
35,131.69 99.93 35,155.99 24.11 1 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
35,131.69 99.93 35,155.99 24.11 1 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
5,175.08 99.91 5,179.60 3.73 2 fsb35xh35m345 sqlplus@hp580hbdb2 (TNS V1-V3) select count(*) from dba_segme...
2.03 66.16 3.06 0.21 6 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...
1.97 88.80 2.22 0.02 68 04xtrk7uyhknh   select obj#, type#, ctime, mti...
1.97 76.93 2.57 0.21 3 65vuzhm491wk9 racgimon@hp580hbdb2 (TNS V1-V3) DECLARE reason_id dbms_server...
1.97 61.62 3.20 0.01 1 79w2cqu2gmjm8   select 1 from aq$_schedules
1.97 60.07 3.28 0.01 1 6w3rdsz64hdhk   select min(timeout) from sys.r...
1.97 64.50 3.06 0.04 182 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.49 36.74 1.35 0.29 3 dgyj6z7xacxjm   SELECT /*+ ordered use_nl(stat...
0.47 35.62 1.32 0.11 6 gqabj2m771r38   SELECT /*+ ordered use_nl(stat...
0.41 92.55 0.44 0.01 1 27crjkm60uua8   select trace_type, primary_id,...
0.08 6.12 1.26 0.08 6 51fpg24fxb8k9   SELECT startsn.stat_id, smap.k...
0.02 32.06 0.07 0.02 32 451q2032pshqm   select owner#, name, namespace...
0.01 7.14 0.10 0.01 6 gvynt9bqh451z   SELECT sum(case when snap_id =...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04p9rnacfgfsnINSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5)VALUES(:1, :2, :3, :4, :5, :6, ' ', :7) RETURNING rowid into :8
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
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0sxrub8cckxb7INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15) RETURNING rowid INTO :16
1b28hzmjun5t0MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0)
1yyh2fdqqguz8INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
27crjkm60uua8select trace_type, primary_id, qualifier_id1, qualifier_id2, instance_name, flags from wri$_tracing_enabled where instance_name is null or instance_name = :1
2gxbvynrd71drINSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
2q817mk1r7sw8INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ') RETURNING rowid INTO :13
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
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
451q2032pshqmselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
51fpg24fxb8k9 SELECT startsn.stat_id, smap.keh_id, GREATEST( 0, (endsn.value - startsn.value) ) as value_diff FROM (SELECT t1.* FROM WRH$_SYSSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) startsn , (SELECT t1.* FROM WRH$_SYSSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) endsn , X$KEHSYSMAP smap WHERE startsn.snap_id = :begin_snap_id and endsn.snap_id = :end_snap_id and startsn.dbid = :dbid and endsn.dbid = :dbid2 and startsn.instance_number = :instance_number and endsn.instance_number = :instance_number2 and startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash ORDER BY startsn.stat_id ASC
65vuzhm491wk9 DECLARE reason_id dbms_server_alert.REASON_ID_T := NULL; resource_id NUMBER; db_name recent_resource_incarnations$.db_unique_name%TYPE := :db_unique_name; inst_name recent_resource_incarnations$.instance_name%TYPE := :instance_name; event_id NUMBER := :event_id; event_time TIMESTAMP WITH TIME ZONE := TO_TIMESTAMP_TZ(:event_time, 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM', 'NLS_CALENDAR=''Gregorian'''); BEGIN CASE :reason_name WHEN 'DATABASE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_DATABASE_UP; WHEN 'DATABASE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_DATABASE_DOWN; WHEN 'INSTANCE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_INSTANCE_UP; WHEN 'INSTANCE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_INSTANCE_DOWN; WHEN 'SERVICE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_UP; WHEN 'SERVICE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_DOWN; WHEN 'SERVICE_MEMBER_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_MEMBER_UP; WHEN 'SERVICE_MEMBER_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SERVICE_MEMBER_DOWN; WHEN 'SVC_PRECONNECT_UP' THEN reason_id := dbms_server_alert.RSN_FAN_SVC_PRECONNECT_UP; WHEN 'SVC_PRECONNECT_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_SVC_PRECONNECT_DOWN; WHEN 'NODE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_NODE_DOWN; WHEN 'ASM_INSTANCE_UP' THEN reason_id := dbms_server_alert.RSN_FAN_ASM_INSTANCE_UP; WHEN 'ASM_INSTANCE_DOWN' THEN reason_id := dbms_server_alert.RSN_FAN_ASM_INSTANCE_DOWN; END CASE; IF :use_resource_id = 'Y' THEN BEGIN SELECT resource_id INTO resource_id FROM recent_resource_incarnations$ WHERE resource_type = 'INSTANCE' AND db_unique_name = db_name AND db_domain=NVL(SYS_CONTEXT('USERENV', 'DB_DOMAIN'), '==N/A==') AND instance_name = inst_name AND startup_time = (SELECT MAX(startup_time) FROM recent_resource_incarnations$ WHERE resource_type = 'INSTANCE' AND db_unique_name = db_name AND db_domain = NVL(SYS_CONTEXT('USERENV', 'DB_DOMAIN'), '==N/A==') AND instance_name = inst_name AND from_tz(startup_time, '+00:00') < event_time); EXCEPTION WHEN NO_DATA_FOUND T HEN RETURN; WHEN OTHERS THEN RAISE; END; event_id := 2147483648 + BITAND(event_id * 128, 2147483648-1) + resource_id; END IF; dbms_ha_alerts_prvt.post_ha_alert( reason_id => reason_id, same_transaction => FALSE, clear_old_alert => FALSE, database_unique_name => db_name, instance_name => inst_name, service_name => :service_name, host_name => :host_name, incarnation => :incarnation, event_reason => :event_reason, event_time => event_time, cardinality => :cardinality, event_id => event_id, timeout_seconds => :alert_timeout_seconds, immediate_timeout => :immed_timeout = 'Y', duplicates_ok => TRUE); END;
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6w3rdsz64hdhkselect min(timeout) from sys.reg$
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
772s25v1y0x8kselect shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
79w2cqu2gmjm8select 1 from aq$_schedules
7d72r1ca0x4csSELECT attr4 FROM WRI$_ADV_OBJECTS WHERE rowid = :1
7frqszzdu8sggselect DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
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
8cuu0uynbrhbnselect 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) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
8mrg623amm8rx 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, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) 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, v$instance i 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 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i 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 and i.logins = 'ALLOWED' 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, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' 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, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
ayyw8ywjuqak1select t.schema, t.name, t.objno, t.flags, t.timezone from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft where aft.table_objno = t.objno and aft.owner_instance = :1 and bitand(t.flags, 4+16+32+64+128+256) = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM') and exists (select 1 from system.aq$_queues q where q.table_objno = t.objno and q.usage = 0)
b6b0ujx89mmncselect o.owner#, o.obj#, decode(o.linkname, null, decode(u.name, null, 'SYS', u.name), o.remoteowner), o.name, o.linkname, o.namespace, o.subname from user$ u, obj$ o where u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from dependency$ where p_obj# = o.obj#) order by o.obj# for update of o.owner#
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
b7jn4mf49n569select o.name, u.name from obj$ o, type$ t, user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
bh27jbn2c9bq8SELECT count(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and sql_id = :sql
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
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
cf621qmts91wf SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time = 0 and a.session_type = 1 and a.event_id in ( select en.event_id from WRH$_EVENT_NAME en where a.dbid = en.dbid and en.wait_class = 'User I/O') GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.iowait_delta) >= :cutoff ORDER BY sum(s.iowait_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.io_wait DESC
crqkznuh5t6fsUPDATE SYS.WRI$_SEGADV_OBJLIST SET STATUS = 'NEW' WHERE STATUS = 'BEING_PROCESSED'
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dgyj6z7xacxjm SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time <> 0 GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.cpu_time_delta) >= :cutoff ORDER BY sum(s.cpu_time_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.cpu_time DESC
f80h0xb1qvbskSELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fsb35xh35m345select count(*) from dba_segments where tablespace_name='TBST_BDH'
g39ah6rgvvxbvINSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags) VALUES (:1, :2, :3, :4, :5, :6, :7, :8)
gqabj2m771r38 SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id GROUP BY s.sql_id HAVING sum(s.elapsed_time_delta - s.plsexec_time_delta - s.jave xec_time_delta) >= :cutoff ORDER BY sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.sqlx_time DESC
gvynt9bqh451zSELECT sum(case when snap_id = :startsn then value else 0 end) as begin_sga, sum(case when snap_id = :endsn then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :instance_number AND (sga.snap_id = :startsn OR sga.snap_id = :endsn)
gwbj9cspdpgq8SELECT ash.sql_id, ash.sql_opcode, ash.cnt, nvl(st.sql_text, to_clob(' ')) FROM WRH$_SQLTEXT st , (SELECT sql_id, sql_opcode, cnt FROM ( SELECT a.sql_id, max(a.sql_opcode) as sql_opcode, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :start_snap AND a.snap_id <= :end_snap AND a.dbid = :db_id AND a.instance_number = :inst_num AND a.wait_time = 0 AND a.sql_id is NOT NULL AND a.event_id in (:event1, :event2) GROUP BY a.sql_id HAVING count(*) >= :cutoff_count ORDER BY 3 DESC ) WHERE rownum <= :max_rows ) ash WHERE ash.sql_id = st.sql_id(+) AND st.dbid(+) = :db_id ORDER BY ash.cnt DESC

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 35,054 5.21 230.62
CPU used when call started 9,834 1.46 64.70
CR blocks created 76 0.01 0.50
Cached Commit SCN referenced 18,522 2.75 121.86
Commit SCN cached 0 0.00 0.00
DB time 9,475,795 1,408.05 62,340.76
DBWR checkpoint buffers written 348 0.05 2.29
DBWR checkpoints 11 0.00 0.07
DBWR fusion writes 49 0.01 0.32
DBWR object drop buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 15 0.00 0.10
DBWR undo block writes 99 0.01 0.65
DFO trees parallelized 133 0.02 0.88
PX local messages recv'd 914 0.14 6.01
PX local messages sent 903 0.13 5.94
PX remote messages recv'd 332 0.05 2.18
PX remote messages sent 554 0.08 3.64
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 133 0.02 0.88
RowCR attempts 0 0.00 0.00
RowCR hits 0 0.00 0.00
SMON posted for instance recovery 1 0.00 0.01
SMON posted for undo segment shrink 1 0.00 0.01
SQL*Net roundtrips to/from client 310 0.05 2.04
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 150 0.02 0.99
application wait time 0 0.00 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 33,245 4.94 218.72
branch node splits 0 0.00 0.00
buffer is not pinned count 44,947 6.68 295.70
buffer is pinned count 522,065 77.58 3,434.64
bytes received via SQL*Net from client 25,290 3.76 166.38
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 39,031 5.80 256.78
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 12,633 1.88 83.11
calls to kcmgas 1,896 0.28 12.47
calls to kcmgcs 1,111 0.17 7.31
change write time 15 0.00 0.10
cleanout - number of ktugct calls 194 0.03 1.28
cleanouts and rollbacks - consistent read gets 6 0.00 0.04
cleanouts only - consistent read gets 63 0.01 0.41
cluster key scan block gets 809 0.12 5.32
cluster key scans 343 0.05 2.26
cluster wait time 5,361,248 796.65 35,271.37
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 2 0.00 0.01
commit batch/immediate requested 2 0.00 0.01
commit cleanout failures: block lost 17 0.00 0.11
commit cleanout failures: callback failure 5 0.00 0.03
commit cleanouts 529 0.08 3.48
commit cleanouts successfully completed 507 0.08 3.34
commit immediate performed 2 0.00 0.01
commit immediate requested 2 0.00 0.01
commit txn count during cleanout 170 0.03 1.12
concurrency wait time 2,565 0.38 16.88
consistent changes 317 0.05 2.09
consistent gets 92,125 13.69 606.09
consistent gets - examination 21,163 3.14 139.23
consistent gets direct 2 0.00 0.01
consistent gets from cache 92,123 13.69 606.07
cursor authentications 70 0.01 0.46
data blocks consistent reads - undo records applied 164 0.02 1.08
db block changes 13,148 1.95 86.50
db block gets 17,092 2.54 112.45
db block gets direct 147 0.02 0.97
db block gets from cache 16,945 2.52 111.48
deferred (CURRENT) block cleanout applications 277 0.04 1.82
dirty buffers inspected 0 0.00 0.00
enqueue conversions 4,968 0.74 32.68
enqueue releases 179,867 26.73 1,183.34
enqueue requests 179,908 26.73 1,183.61
enqueue timeouts 52 0.01 0.34
enqueue waits 438 0.07 2.88
exchange deadlocks 1 0.00 0.01
execute count 8,011 1.19 52.70
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 8,774 1.30 57.72
free buffer requested 147,354 21.90 969.43
gc CPU used by this session 3,106 0.46 20.43
gc blocks lost 23,242 3.45 152.91
gc cr block build time 4 0.00 0.03
gc cr block flush time 0 0.00 0.00
gc cr block receive time 722 0.11 4.75
gc cr block send time 4 0.00 0.03
gc cr blocks received 6,012 0.89 39.55
gc cr blocks served 546 0.08 3.59
gc current block flush time 0 0.00 0.00
gc current block pin time 11 0.00 0.07
gc current block receive time 598 0.09 3.93
gc current block send time 35 0.01 0.23
gc current blocks received 3,205 0.48 21.09
gc current blocks served 5,980 0.89 39.34
gc local grants 3,883 0.58 25.55
gc remote grants 282 0.04 1.86
gcs messages sent 60,227 8.95 396.23
ges messages sent 4,001 0.59 26.32
global enqueue get time 281,374 41.81 1,851.14
global enqueue gets async 5,566 0.83 36.62
global enqueue gets sync 16,249 2.41 106.90
global enqueue releases 16,223 2.41 106.73
heap block compress 21 0.00 0.14
hot buffers moved to head of LRU 180 0.03 1.18
immediate (CR) block cleanout applications 69 0.01 0.45
immediate (CURRENT) block cleanout applications 125 0.02 0.82
index crx upgrade (found) 1 0.00 0.01
index crx upgrade (positioned) 4,459 0.66 29.34
index fast full scans (full) 0 0.00 0.00
index fetch by key 11,293 1.68 74.30
index scans kdiixs1 6,500 0.97 42.76
leaf node 90-10 splits 35 0.01 0.23
leaf node splits 40 0.01 0.26
lob reads 224 0.03 1.47
lob writes 427 0.06 2.81
lob writes unaligned 427 0.06 2.81
logons cumulative 238 0.04 1.57
messages received 1,794 0.27 11.80
messages sent 1,794 0.27 11.80
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 62,718 9.32 412.62
opened cursors cumulative 4,300 0.64 28.29
parse count (failures) 0 0.00 0.00
parse count (hard) 157 0.02 1.03
parse count (total) 3,778 0.56 24.86
parse time cpu 88 0.01 0.58
parse time elapsed 719 0.11 4.73
physical read IO requests 3,364 0.50 22.13
physical read bytes 32,604,160 4,844.81 214,501.05
physical read total IO requests 19,258 2.86 126.70
physical read total bytes 350,453,760 52,075.57 2,305,616.84
physical read total multi block requests 198 0.03 1.30
physical reads 3,980 0.59 26.18
physical reads cache 3,977 0.59 26.16
physical reads cache prefetch 616 0.09 4.05
physical reads direct 2 0.00 0.01
physical reads direct (lob) 2 0.00 0.01
physical reads direct temporary tablespace 0 0.00 0.00
physical write IO requests 326 0.05 2.14
physical write bytes 4,587,520 681.68 30,181.05
physical write total IO requests 7,547 1.12 49.65
physical write total bytes 121,885,696 18,111.57 801,879.58
physical write total multi block requests 415 0.06 2.73
physical writes 560 0.08 3.68
physical writes direct 147 0.02 0.97
physical writes direct (lob) 2 0.00 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 413 0.06 2.72
physical writes non checkpoint 359 0.05 2.36
pinned buffers inspected 3,443 0.51 22.65
prefetched blocks aged out before use 0 0.00 0.00
queries parallelized 133 0.02 0.88
recovery blocks read 21 0.00 0.14
recursive calls 58,043 8.62 381.86
recursive cpu usage 14,993 2.23 98.64
redo blocks read for recovery 40 0.01 0.26
redo blocks written 5,515 0.82 36.28
redo buffer allocation retries 0 0.00 0.00
redo entries 9,158 1.36 60.25
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 160 0.02 1.05
redo size 2,872,268 426.80 18,896.50
redo subscn max counts 98 0.01 0.64
redo synch time 52 0.01 0.34
redo synch writes 17 0.00 0.11
redo wastage 65,056 9.67 428.00
redo write broadcast ack time 5 0.00 0.03
redo write time 45 0.01 0.30
redo writer latching time 0 0.00 0.00
redo writes 186 0.03 1.22
rollback changes - undo records applied 17 0.00 0.11
rollbacks only - consistent read gets 69 0.01 0.45
root node splits 0 0.00 0.00
rows fetched via callback 8,034 1.19 52.86
session cursor cache hits 4,437 0.66 29.19
session logical reads 109,217 16.23 718.53
shared hash latch upgrades - no wait 4,747 0.71 31.23
shared hash latch upgrades - wait 4 0.00 0.03
sorts (disk) 0 0.00 0.00
sorts (memory) 3,645 0.54 23.98
sorts (rows) 208,158 30.93 1,369.46
sql area evicted 28 0.00 0.18
sql area purged 0 0.00 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 2 0.00 0.01
table fetch by rowid 275,485 40.94 1,812.40
table fetch continued row 19 0.00 0.13
table scan blocks gotten 33,724 5.01 221.87
table scan rows gotten 1,552,401 230.68 10,213.16
table scans (long tables) 0 0.00 0.00
table scans (short tables) 690 0.10 4.54
total number of times SMON posted 8 0.00 0.05
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction rollbacks 2 0.00 0.01
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 868,716 129.09 5,715.24
user I/O wait time 748 0.11 4.92
user calls 1,333 0.20 8.77
user commits 22 0.00 0.14
user rollbacks 130 0.02 0.86
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 1,863 0.28 12.26
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 5,821,085,392 6,100,516,224
session cursor cache count 7,716 3,261
session uga memory 3.9E+11 4.1E+11
opened cursors current 211 65
workarea memory allocated 4,001 1,427
logons current 40 35
session uga memory max 3,132,960,264 7,501,906,184
session pga memory 2,600,842,960 2,713,271,008

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

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)
SYSTEM 2,641 0 1.34 1.10 30 0 3 390.00
SYSAUX 607 0 6.85 1.57 260 0 36,685 901.01
UNDOTBS2 8 0 11.25 1.00 34 0 2 5.00
UNDOTBS1 26 0 11.92 1.00 2 0 4 7.50

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX /dev/raw/raw47 607 0 6.85 1.57 260 0 36,685 901.01
SYSTEM /dev/raw/raw46 2,641 0 1.34 1.10 30 0 3 390.00
UNDOTBS1 /dev/raw/raw35 18 0 15.56 1.00 2 0 1 0.00
UNDOTBS1 /dev/raw/raw36 7 0 4.29 1.00 0 0 3 10.00
UNDOTBS1 /dev/raw/raw37 1 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/raw/raw38 5 0 12.00 1.00 4 0 2 5.00
UNDOTBS2 /dev/raw/raw39 1 0 20.00 1.00 22 0 0 0.00
UNDOTBS2 /dev/raw/raw40 0 0     6 0 0 0.00
UNDOTBS2 /dev/raw/raw41 2 0 5.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 1,084,993 96 108,754 3,930 413 0 0 37,511


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 251 1637 1362 4608000 1362  
E 0 0 515 4815 4815 4608000 4815  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 896 0.10 107,352 1.37 11,813,443
D 1,792 0.20 214,704 1.14 9,804,159
D 2,688 0.30 322,056 1.09 9,393,133
D 3,584 0.40 429,408 1.09 9,373,661
D 4,480 0.49 536,760 1.08 9,289,191
D 5,376 0.59 644,112 1.05 9,059,348
D 6,272 0.69 751,464 1.02 8,785,588
D 7,168 0.79 858,816 1.02 8,784,459
D 8,064 0.89 966,168 1.02 8,756,362
D 8,960 0.99 1,073,520 1.00 8,637,730
D 9,072 1.00 1,086,939 1.00 8,626,884
D 9,856 1.09 1,180,872 0.99 8,547,272
D 10,752 1.19 1,288,224 0.98 8,492,789
D 11,648 1.28 1,395,576 0.98 8,424,682
D 12,544 1.38 1,502,928 0.97 8,390,166
D 13,440 1.48 1,610,280 0.97 8,360,114
D 14,336 1.58 1,717,632 0.95 8,214,793
D 15,232 1.68 1,824,984 0.94 8,094,309
D 16,128 1.78 1,932,336 0.93 8,040,105
D 17,024 1.88 2,039,688 0.92 7,949,406
D 17,920 1.98 2,147,040 0.91 7,816,896

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 40 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 6,144 5,414 194.56 2.51 1.29 100.00 0.00 629,140
E 6,144 5,415 198.06 0.00 0.00 0.00 0.00 629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 1,819 1,819 0 0
64K 128K 5 5 0 0
512K 1024K 25 25 0 0
1M 2M 14 14 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
768 0.13 175,891.55 10,401.99 94.00 0
1,536 0.25 175,891.55 5,554.76 97.00 0
3,072 0.50 175,891.55 1,028.56 99.00 0
4,608 0.75 175,891.55 1,028.56 99.00 0
6,144 1.00 175,891.55 1,028.56 99.00 0
7,373 1.20 175,891.55 0.00 100.00 0
8,602 1.40 175,891.55 0.00 100.00 0
9,830 1.60 175,891.55 0.00 100.00 0
11,059 1.80 175,891.55 0.00 100.00 0
12,288 2.00 175,891.55 0.00 100.00 0
18,432 3.00 175,891.55 0.00 100.00 0
24,576 4.00 175,891.55 0.00 100.00 0
36,864 6.00 175,891.55 0.00 100.00 0
49,152 8.00 175,891.55 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 (K)
896 0.78 120 10,682 5,495 1.00 90 1.00 1,369
1,024 0.89 124 11,064 5,495 1.00 90 1.00 1,369
1,152 1.00 124 11,064 5,495 1.00 90 1.00 1,369
1,280 1.11 124 11,064 5,495 1.00 90 1.00 1,369
1,408 1.22 124 11,064 5,495 1.00 90 1.00 1,369
1,536 1.33 124 11,064 5,495 1.00 90 1.00 1,369
1,664 1.44 124 11,064 5,495 1.00 90 1.00 1,369
1,792 1.56 124 11,064 5,495 1.00 90 1.00 1,369
1,920 1.67 124 11,064 5,495 1.00 90 1.00 1,369
2,048 1.78 124 11,064 5,495 1.00 90 1.00 1,369
2,176 1.89 124 11,064 5,495 1.00 90 1.00 1,369
2,304 2.00 124 11,064 5,495 1.00 90 1.00 1,369

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,560 0.25 248,524 11,813,392
5,120 0.50 239,798 9,373,764
7,680 0.75 237,688 8,785,423
10,240 1.00 237,119 8,626,692
12,800 1.25 236,384 8,424,827
15,360 1.50 235,649 8,214,336
17,920 1.75 234,700 7,949,497
20,480 2.00 234,226 7,816,646

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 36,839 32,960 895
undo block 5 0 8
1st level bmb 3 0 13
undo header 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 72 20 52 55 136 2,476.00
PS-PX Process Reservation 973 973 0 320 0 0.97
TX-Transaction (index contention) 8 8 0 8 0 11.25
SQ-Sequence Cache 90 90 0 43 0 0.23
DR-Distributed Recovery 4 4 0 4 0 2.50
MW-MWIN Schedule 4 4 0 4 0 2.50
JS-Job Scheduler (job run lock - synchronize) 4 4 0 3 0 3.33
AF-Advisor Framework (task serialization) 13 13 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 0.08 62 44,106 2 15/747.1 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
19-Feb 11:46 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 11:36 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 11:26 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 11:16 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 11:06 0 2 0 0 15 0/0 0/0/0/0/0/0
19-Feb 10:56 1 5 0 1 15 0/0 0/0/0/0/0/0
19-Feb 10:46 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 10:36 0 0 0 0 15 0/0 0/0/0/0/0/0
19-Feb 10:26 0 3 0 0 15 0/0 0/0/0/0/0/0
19-Feb 10:16 0 0 44,106 0 747 0/0 0/0/0/0/0/0
19-Feb 10:06 82 52 43,503 2 737 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 7,018 0.00   0 0  
AWR Alerted Metric Element list 17,374 0.00   0 0  
Consistent RBA 189 0.00   0 0  
FOB s.o list latch 1,517 0.26 0.00 0 0  
JS broadcast add buf latch 4,495 0.00   0 0  
JS broadcast drop buf latch 4,497 0.00   0 0  
JS broadcast load blnc latch 4,302 0.00   0 0  
JS mem alloc latch 14 0.00   0 0  
JS queue access latch 14 0.00   0 0  
JS queue state obj latch 154,940 0.00   0 0  
KCL gc element parent latch 1,973,900 0.06 0.00 0 22,007 0.00
KJC destination ctx free list 9 0.00   0 0  
KJC message pool free list 27,574 0.01 0.00 0 1,564 0.00
KJCT flow control latch 93,159 0.09 0.00 0 0  
KMG MMAN ready and startup request latch 2,244 0.00   0 0  
KSXR large replies 4 0.00   0 0  
KTF sga latch 2 0.00   0 2,236 0.00
KWQMN job cache list latch 488 0.00   0 0  
KWQMN to-be-Stopped Buffer list Latch 1 0.00   0 0  
MQL Tracking Latch 0     0 133 0.00
Memory Management Latch 0     0 2,244 0.00
OS process 759 0.00   0 0  
OS process allocation 2,759 0.00   0 0  
OS process: request allocation 169 0.00   0 0  
PL/SQL warning settings 252 0.00   0 0  
SGA IO buffer pool latch 96 1.04 0.00 0 96 0.00
SQL memory manager latch 1 0.00   0 2,240 0.00
SQL memory manager workarea list latch 150,462 0.00   0 0  
Shared B-Tree 237 0.00   0 0  
active checkpoint queue latch 9,200 0.32 0.21 0 0  
active service list 38,330 0.01 0.00 0 2,825 0.00
archive control 111 0.00   0 0  
begin backup scn array 9 0.00   0 0  
business card 274 0.00   0 0  
cache buffer handles 54 24.07 0.15 0 0  
cache buffers chains 1,119,489 3.28 0.99 17 192,100 4.02
cache buffers lru chain 153,685 0.11 0.01 0 220,539 0.28
cache table scan latch 0     0 98 0.00
channel handle pool latch 195 0.00   0 0  
channel operations parent latch 319,679 0.00 0.00 0 0  
checkpoint queue latch 665,348 0.00   0 738 0.00
client/application info 806 0.00   0 0  
commit callback allocation 6 0.00   0 0  
compile environment latch 239 0.00   0 0  
database property service latch 3 0.00   0 0  
dml lock allocation 785 0.00   0 0  
dummy allocation 481 0.62 0.00 0 0  
enqueue hash chains 372,947 0.00 0.00 0 2,982 0.00
enqueues 357,057 0.01 0.00 0 0  
error message lists 676 0.15 0.00 0 0  
event group latch 90 0.00   0 0  
file cache latch 2,358 0.00   0 0  
gcs domain validate latch 1 0.00   0 0  
gcs drop object freelist 1 0.00   0 0  
gcs opaque info freelist 34,972 0.27 0.00 0 0  
gcs partitioned table hash 2,017,019 0.00   0 173 0.00
gcs remastering latch 6 0.00   0 0  
gcs resource freelist 272,697 0.00 0.00 0 531 0.00
gcs resource hash 2,360,709 0.00 0.07 0 0  
gcs resource validate list 15,754 5.41 0.00 0 0  
gcs shadows freelist 15,086 0.00   0 6,419 0.00
generalized trace enabling latch 1 0.00   0 0  
ges caches resource lists 15,988 0.02 0.00 0 71,236 0.00
ges deadlock list 36 0.00   0 0  
ges domain table 17,876 0.00   0 0  
ges enqueue table freelist 39,391 0.00   0 0  
ges group table 27,478 0.01 0.00 0 0  
ges process hash list 7,285 0.00   0 0  
ges process parent latch 72,650 0.00 0.00 0 0  
ges process table freelist 170 0.00   0 0  
ges resource hash list 407,477 0.03 0.00 0 6,700 0.09
ges resource scan list 132 0.00   0 0  
ges resource table freelist 7,465 0.00   0 0  
ges timeout list 862 0.00   0 2,335 0.04
hash table column usage latch 0     0 5,364 0.02
hash table modification latch 5 0.00   0 0  
interrupt manipulation 1,180 0.00   0 0  
job workq parent latch 0     0 8 0.00
job_queue_processes parameter latch 116 0.00   0 0  
kks stats 409 0.00   0 0  
kokc descriptor allocation latch 18 0.00   0 0  
ksuosstats global area 450 0.00   0 0  
ktm global data 14 0.00   0 0  
kwqbsn:qsga 237 0.00   0 0  
lgwr LWN SCN 2,410 0.00   0 0  
library cache 51,209 0.11 0.02 0 121 0.00
library cache load lock 300 0.00   0 0  
library cache lock 45,317 0.03 0.00 0 0  
library cache lock allocation 355 0.00   0 0  
library cache pin 15,691 0.07 0.00 0 1 0.00
library cache pin allocation 59 0.00   0 0  
list of block allocation 52 0.00   0 0  
loader state object freelist 14 0.00   0 0  
message pool operations parent latch 1,950 0.00   0 0  
messages 214,446 0.01 0.00 0 0  
mostly latch-free SCN 2,411 0.04 0.00 0 0  
multiblock read objects 32,775 0.16 0.00 0 0  
name-service memory objects 858 0.00   0 0  
name-service namespace bucket 68,193 0.00   0 0  
name-service namespace objects 3 0.00   0 0  
name-service pending queue 424 0.00   0 0  
name-service request 32 0.00   0 0  
name-service request queue 67,120 0.00   0 0  
ncodef allocation latch 108 0.00   0 0  
object queue header heap 44,989 0.00   0 8,006 0.00
object queue header operation 399,590 0.03 0.01 0 0  
object stats modification 22 4.55 0.00 0 0  
parallel query alloc buffer 3,732 0.08 0.00 0 0  
parallel query stats 561 1.07 0.00 0 0  
parallel txn reco latch 21 0.00   0 0  
parameter list 24 0.00   0 0  
parameter table management 485 0.00   0 0  
post/wait queue 44 0.00   0 31 0.00
process allocation 66,834 0.01 0.90 0 90 0.00
process group creation 169 0.00   0 0  
process queue 1,523 0.00   0 0  
process queue reference 29,283 0.04 0.00 0 2,574 0.12
qmn state object latch 1 0.00   0 0  
qmn task queue latch 957 0.00   0 0  
query server freelists 1,280 0.55 0.00 0 0  
query server process 16 0.00   0 0  
queued dump request 33,499 0.00   0 0  
redo allocation 5,029 0.14 0.00 0 9,170 0.36
redo copy 0     0 9,176 0.09
redo writing 14,435 0.01 0.00 0 0  
reg$ timeout service time 1 0.00   0 0  
resmgr group change latch 289 0.00   0 0  
resmgr:active threads 343 0.00   0 0  
resmgr:actses change group 167 0.00   0 0  
resmgr:free threads list 342 0.88 0.00 0 0  
resmgr:resource group CPU method 167 0.60 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 45,866 0.25 0.00 0 224 0.00
rules engine aggregate statistics 3 0.00   0 0  
rules engine rule set statistics 9 0.00   0 0  
rules engine rule statistics 3 0.00   0 0  
sequence cache 1,622 0.25 0.00 0 0  
session allocation 1,909 1.68 0.03 0 0  
session idle bit 2,916 0.00   0 0  
session state list latch 509 0.79 0.00 0 0  
session switching 503 0.00   0 0  
session timer 2,268 0.00   0 0  
shared pool 32,022 0.29 0.14 0 0  
shared pool sim alloc 8 0.00   0 0  
shared pool simulator 534 0.00   0 0  
simulator hash latch 28,927 0.00   0 0  
simulator lru latch 0     0 28,549 0.08
slave class 72 0.00   0 0  
slave class create 283 0.35 1.00 0 0  
sort extent pool 218 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 563 0.00   0 0  
temp lob duration state obj allocation 12 0.00   0 0  
threshold alerts latch 577 0.00   0 0  
transaction allocation 77 0.00   0 0  
transaction branch allocation 2,268 0.00   0 0  
undo global data 10,004 0.00   0 0  
user lock 15 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 1,119,489 36,760 36,532 2,497 0 0 0
KCL gc element parent latch 1,973,900 1,214 2 1,212 0 0 0
cache buffers lru chain 153,685 166 2 164 0 0 0
gcs resource hash 2,360,709 111 8 103 0 0 0
object queue header operation 399,590 108 1 107 0 0 0
shared pool 32,022 92 13 82 0 0 0
library cache 51,209 58 1 57 0 0 0
session allocation 1,909 32 1 31 0 0 0
active checkpoint queue latch 9,200 29 6 23 0 0 0
cache buffer handles 54 13 2 11 0 0 0
process allocation 66,834 10 9 1 0 0 0
slave class create 283 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 8 5
KCL gc element parent latch kclple_1 0 1 0
active checkpoint queue latch kcbzck1: Check checkpoint complete 0 5 3
active checkpoint queue latch kcbstc1: Start a new checkpoint 0 1 3
cache buffer handles kcbzgs 0 2 2
cache buffers chains kcbzwb 0 30,684 29,973
cache buffers chains kcbgtcr 0 5,254 6,107
cache buffers chains kcbgtcr: kslbegin excl 0 38 40
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 9 4
cache buffers chains kcbzib: multi-block read: nowait 0 5 0
cache buffers chains kcbgtcr: fast path 0 4 1
cache buffers chains kcbrls: kslbegin 0 3 18
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kclebs_1 0 1 1
cache buffers lru chain kcbzfw 0 1 13
cache buffers lru chain kcbzgws 0 1 0
gcs resource hash kjbcropen 0 5 5
gcs resource hash kjblocalfile_nolock 0 1 1
gcs resource hash kjbopen:affinity 0 1 0
gcs resource hash kjbrecoveryopen 0 1 1
library cache kglScanDependency 0 1 0
object queue header operation kcbw_unlink_q 0 3 3
object queue header operation kcbo_switch_mq_bg 0 1 0
process allocation ksucrp 0 9 0
session allocation ksuxds: KSUSFCLC not set 0 1 0
shared pool kghalo 0 13 13
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 371540_536 TABLE PARTITION 18,784 17.20
SYS SYSAUX WRH$_SQLSTAT 371540_536 TABLE PARTITION 12,608 11.54
SYS SYSTEM OBJ$   TABLE 9,536 8.73
SYS SYSTEM RECYCLEBIN$   TABLE 7,216 6.61
SYS SYSAUX WRH$_EVENT_NAME   TABLE 5,712 5.23

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYS SYSTEM TYPE$   TABLE 1,950 48.99
SYS SYSAUX WRH$_SQLSTAT 371540_536 TABLE PARTITION 418 10.50
SYS SYSTEM SMON_SCN_TIME   TABLE 305 7.66
SYS SYSTEM TAB$   TABLE 303 7.61
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 371540_536 TABLE PARTITION 264 6.63

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSAUX WRI$_ADV_MSG_GRPS_IDX_01   INDEX 6 75.00
SYS SYSAUX WRI$_ADV_MESSAGE_GROUPS_PK   INDEX 2 25.00

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
SYS SYSAUX WRI$_ADV_MESSAGE_GROUPS_PK   INDEX 40 62.50
SYS SYSAUX WRI$_ADV_MSG_GRPS_IDX_01   INDEX 14 21.88
SYS SYSAUX WRI$_ADV_FINDINGS_PK   INDEX 3 4.69
SYS SYSAUX WRI$_ADV_RATIONALE_PK   INDEX 3 4.69
SYS SYSAUX WRH$_DB_CACHE_ADVICE 371540_536 TABLE PARTITION 1 1.56

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SYS SYSAUX WRH$_SQLSTAT 371540_536 TABLE PARTITION 37,392 99.97
SYS SYSTEM TAB$   TABLE 3 0.01
SYS SYSAUX WRH$_PGASTAT_PK   INDEX 3 0.01
SYS SYSAUX WRH$_SYSSTAT_PK 371540_536 INDEX PARTITION 3 0.01
SYS SYSAUX WRH$_SYSSTAT 371540_536 TABLE PARTITION 1 0.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SYS SYSAUX WRH$_SQLSTAT 371540_536 TABLE PARTITION 5,934 98.70
SYS SYSTEM OBJ$   TABLE 36 0.60
SYS SYSTEM SEG$   TABLE 7 0.12
SYS SYSAUX WRH$_SQL_PLAN   TABLE 5 0.08
SYS SYSAUX WRH$_FILESTATXS 371540_536 TABLE PARTITION 4 0.07

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SYS SYSTEM TAB$   TABLE 2,877 89.77
SYS SYSAUX WRI$_SEGADV_OBJLIST   TABLE 202 6.30
SYS SYSAUX WRH$_SQLSTAT_INDEX 371540_536 INDEX PARTITION 30 0.94
SYS SYSTEM IDL_UB2$   TABLE 14 0.44
SYS SYSAUX WRH$_SQLSTAT 371540_536 TABLE PARTITION 8 0.25

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 119 0.00 0   2 1
dc_database_links 7 0.00 0   0 11
dc_global_oids 50 10.00 0   0 33
dc_histogram_data 3,474 1.35 0   0 2,024
dc_histogram_defs 3,223 5.65 0   0 3,994
dc_object_ids 2,463 1.58 0   0 1,296
dc_objects 916 8.08 0   12 1,190
dc_profiles 10 0.00 0   0 1
dc_rollback_segments 530 0.00 0   10 22
dc_segments 1,001 6.09 0   2 1,259
dc_sequences 47 2.13 0   47 7
dc_tablespaces 2,198 0.00 0   0 20
dc_usernames 252 0.00 0   0 46
dc_users 1,350 0.00 0   0 72
outstanding_alerts 201 94.53 0   3 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_global_oids 5 0 0
dc_histogram_defs 182 0 0
dc_object_ids 39 37 0
dc_objects 97 75 0
dc_rollback_segments 20 0 0
dc_segments 65 8 0
dc_sequences 94 0 0
outstanding_alerts 402 187 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 26 0.00 33 6.06 2 0
CLUSTER 9 11.11 18 5.56 0 0
INDEX 26 0.00 98 16.33 14 0
SQL AREA 1,057 4.26 9,756 3.23 83 45
TABLE/PROCEDURE 265 4.91 3,077 3.57 42 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 18 1 0 1 0
INDEX 98 14 19 38 0
TABLE/PROCEDURE 1,458 56 21 163 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 139.98   3.26 4.45 11 11 43 43
  Freeable 50.69 0.00 2.82 2.79 7   18 18
  SQL 3.51 2.97 0.17 0.38 1 6 21 19
  PL/SQL 0.40 0.29 0.01 0.01 0 0 41 41
E Other 144.19   2.67 4.14 11 11 54 54
  Freeable 52.94 0.00 1.65 3.46 20   32 32
  SQL 0.76 0.23 0.05 0.04 0 3 16 14
  PL/SQL 0.20 0.10 0.00 0.01 0 0 52 36

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 9,495,904,256  
Fixed Size 2,114,104  
Redo Buffers 14,659,584  
Variable Size 1,224,740,296  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 13.87 14.20 2.38
shared Checkpoint queue 31.26 31.26 0.00
shared FileOpenBlock 15.20 15.20 0.00
shared KCL name table 12.00 12.00 0.00
shared KGH: NO ACCESS 31.75 32.77 3.19
shared db_block_hash_buckets 90.00 90.00 0.00
shared event statistics per sess 29.85 29.85 0.00
shared free memory 274.98 269.60 -1.96
shared gcs resources 189.98 189.98 0.00
shared gcs shadows 113.79 113.79 0.00
shared ges big msg buffers 15.20 15.20 0.00
shared ges enqueues 34.97 35.11 0.39
shared library cache 15.02 15.16 0.95
shared sessions 17.35 17.35 0.00
shared sql area 46.16 48.94 6.04
  buffer_cache 9,056.00 9,056.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/app/oracle/admin/xjhbdb/adump   
background_dump_dest /u01/app/oracle/admin/xjhbdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files /dev/raw/raw7, /dev/raw/raw8, /dev/raw/raw9   
core_dump_dest /u01/app/oracle/admin/xjhbdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_files 2000   
db_name xjhbdb   
dispatchers (PROTOCOL=TCP) (SERVICE=xjhbdbXDB)   
instance_number 2   
job_queue_processes 10   
open_cursors 1024   
pga_aggregate_target 6442450944   
processes 3000   
remote_listener LISTENERS_XJHBDB   
remote_login_passwordfile EXCLUSIVE   
sessions 3305   
sga_target 10737418240   
spfile /dev/raw/raw6   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /u01/app/oracle/admin/xjhbdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 444 0.07 2.92
acks for commit broadcast(logical) 467 0.07 3.07
broadcast msgs on commit(actual) 43 0.01 0.28
broadcast msgs on commit(logical) 43 0.01 0.28
broadcast msgs on commit(wasted) 6 0.00 0.04
broadcast on commit wait time(ms) 207 0.03 1.36
broadcast on commit waits 40 0.01 0.26
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 2 0.00 0.01
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 5,842 0.87 38.43
gcs ast xid 0 0.00 0.00
gcs blocked converts 157 0.02 1.03
gcs blocked cr converts 360 0.05 2.37
gcs compatible basts 3 0.00 0.02
gcs compatible cr basts (global) 1 0.00 0.01
gcs compatible cr basts (local) 29,326 4.36 192.93
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 44 0.01 0.29
gcs dbwr write request msgs 48 0.01 0.32
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 268 0.04 1.76
gcs immediate (null) converts 484 0.07 3.18
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 3,716 0.55 24.45
gcs indirect ast 518 0.08 3.41
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 23 0.00 0.15
gcs msgs process time(ms) 1,973 0.29 12.98
gcs msgs received 35,427 5.26 233.07
gcs out-of-order msgs 8 0.00 0.05
gcs pings refused 0 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 32 0.00 0.21
gcs side channel msgs actual 15,932 2.37 104.82
gcs side channel msgs logical 32,522 4.83 213.96
gcs stale cr 323 0.05 2.13
gcs undo cr 0 0.00 0.00
gcs write notification msgs 0 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 213 0.03 1.40
ges msgs received 4,222 0.63 27.78
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 5,938 0.88 39.07
implicit batch messages sent 9,029 1.34 59.40
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 9,623 1.43 63.31
messages queue sent actual 29,400 4.37 193.42
messages queue sent logical 38,864 5.77 255.68
messages received actual 33,095 4.92 217.73
messages received logical 39,649 5.89 260.85
messages sent directly 9,366 1.39 61.62
messages sent indirectly 27,114 4.03 178.38
messages sent not implicit batched 20,371 3.03 134.02
messages sent pbatched 18,200 2.70 119.74
msgs causing lmd to send msgs 1,807 0.27 11.89
msgs causing lms(s) to send msgs 207 0.03 1.36
msgs received queue time (ms) 1,370 0.20 9.01
msgs received queued 39,649 5.89 260.85
msgs sent queue time (ms) 2,687 0.40 17.68
msgs sent queue time on ksxp (ms) 26,471 3.93 174.15
msgs sent queued 38,852 5.77 255.61
msgs sent queued on ksxp 45,479 6.76 299.20
number of ges deadlock detected 0 0.00 0.00
process batch messages received 1,494 0.22 9.83
process batch messages sent 8,963 1.33 58.97


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 481
CURRENT Block Requests 54
Data Block Requests 481
Undo Block Requests 0
TX Block Requests 1
Current Results 535
Private results 0
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 52
Fairness Clears 0
Free GC Elements 0
Flushes 0
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 5
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 5,965 100.00 0.00 0.00 0.00 0.00
Flushes 1 100.00 0.00 0.00 0.00 0.00
Writes 48 64.58 35.42 0.00 0.00 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 5,995 99.87 0.03 0.10 3,173 92.09 0.00 7.91
1 Others 13 100.00 0.00 0.00 8 100.00 0.00 0.00


Back to Top

End of Report