WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ZZDB2480532765zzdb1110.2.0.5.0YESzzdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:212309-Jan-13 09:00:13102 1.0
End Snap:212609-Jan-13 12:00:2387 1.1
Elapsed:  180.18 (mins)  
DB Time:  66.93 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,384M 18,384MStd Block Size: 8K
Shared Pool Size: 2,016M 2,016MLog Buffer: 30,680K

Load Profile

Per SecondPer Transaction
Redo size: 5,094.89 239,471.08
Logical reads: 210.14 9,877.16
Block changes: 32.80 1,541.87
Physical reads: 105.73 4,969.66
Physical writes: 3.83 179.88
User calls: 3.16 148.73
Parses: 1.32 62.26
Hard parses: 0.02 0.92
Sorts: 0.46 21.48
Logons: 0.03 1.40
Executes: 1.94 91.16
Transactions: 0.02 

% Blocks changed per Read: 15.61Recursive Call %: 74.32
Rollback per transaction %: 86.96Rows per Sort: 176.77

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 49.69In-memory Sort %: 100.00
Library Hit %: 98.01Soft Parse %: 98.53
Execute to Parse %: 31.70Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 83.41% Non-Parse CPU: 98.64

Shared Pool Statistics

BeginEnd
Memory Usage %: 78.51 78.67
% SQL with executions>1: 97.11 96.22
% Memory for SQL w/exec>1: 87.77 85.37

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
gc cr multi block request 281,323 3,805 14 94.7Cluster
CPU time  126  3.1 
db file scattered read 63,702 110 2 2.7User I/O
db file parallel read 31,511 81 3 2.0User I/O
SQL*Net more data from dblink 667 76 114 1.9Network

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 36.25 1,703.84
Global Cache blocks served: 0.17 7.77
GCS/GES messages received: 2.98 140.17
GCS/GES messages sent: 40.47 1,901.97
DBWR Fusion writes: 0.02 0.97
Estd Interconnect traffic (KB) 299.81 

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

Buffer access - local cache %: 32.44
Buffer access - remote cache %: 17.25
Buffer access - disk %: 50.31

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.3
Avg global cache current block receive time (ms): 0.8
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 1.4
Avg global cache cr block flush time (ms): 1.5
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 %: 1.0
Avg global cache current block flush time (ms): 2.2

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 27.10
% of indirect sent messages: 67.30
% of flow controlled messages: 5.60

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 4,009.44 99.85
DB CPU 125.86 3.13
PL/SQL execution elapsed time 5.98 0.15
parse time elapsed 2.56 0.06
hard parse elapsed time 1.78 0.04
hard parse (sharing criteria) elapsed time 0.33 0.01
PL/SQL compilation elapsed time 0.27 0.01
failed parse elapsed time 0.26 0.01
connection management call elapsed time 0.21 0.01
hard parse (bind mismatch) elapsed time 0.07 0.00
repeated bind elapsed time 0.00 0.00
DB time 4,015.56  
background elapsed time 163.00  
background cpu time 26.78  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Cluster 290,383 0 3,808 13 94.82
User I/O 104,252   214 2 5.34
CPU time     126   3.13
Network 27,508   83 3 2.06
System I/O 34,736   22 1 0.56
Other 1,106,918 100 11 0 0.28
Concurrency 1,166   1 1 0.03
Application 2,203   0 0 0.01
Commit 8   0 1 0.00
Configuration 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 cr multi block request 281,323 0 3,805 14 1,223.14
db file scattered read 63,702   110 2 276.97
db file parallel read 31,511   81 3 137.00
SQL*Net more data from dblink 667   76 114 2.90
db file sequential read 9,037   24 3 39.29
control file sequential read 29,434   15 1 127.97
SQL*Net message from dblink 46   6 136 0.20
control file parallel write 3,775   6 2 16.41
CGS wait for IPC msg 1,082,750 100 6 0 4,707.61
reliable message 802 0 5 6 3.49
gc current block 2-way 4,346   2 0 18.90
log file parallel write 1,527   1 1 6.64
os thread startup 32   1 32 0.14
gc current grant busy 1,913   1 0 8.32
gc current grant 2-way 1,427   0 0 6.20
DFS lock handle 1,080   0 0 4.70
SQL*Net break/reset to client 2,178   0 0 9.47
library cache lock 831   0 0 3.61
enq: WF - contention 32   0 6 0.14
gc cr block 2-way 520   0 0 2.26
gc cr disk read 406   0 0 1.77
gc cr grant 2-way 422   0 0 1.83
IPC send completion sync 630 100 0 0 2.74
row cache lock 262   0 0 1.14
latch free 3   0 28 0.01
rdbms ipc reply 384   0 0 1.67
PX Deq: reap credit 8,133 96 0 0 35.36
ksxr poll remote instances 8,937 91 0 0 38.86
enq: PS - contention 288   0 0 1.25
gcs log flush sync 34   0 1 0.15
gc cr block busy 13   0 3 0.06
SQL*Net message to client 23,252   0 0 101.10
cr request retry 3,479 100 0 0 15.13
SQL*Net more data from client 3,272   0 0 14.23
CSS operation: query 6   0 3 0.03
enq: TT - contention 78   0 0 0.34
gc current block busy 8   0 2 0.03
enq: TA - contention 35   0 0 0.15
enq: TD - KTF dump entries 35   0 0 0.15
enq: CF - contention 30   0 0 0.13
log file sync 8   0 1 0.03
library cache pin 41   0 0 0.18
enq: TM - contention 21   0 0 0.09
SQL*Net more data to client 223   0 0 0.97
enq: FB - contention 21   0 0 0.09
PX Deq Credit: send blkd 58 72 0 0 0.25
enq: US - contention 25   0 0 0.11
CSS initialization 2   0 2 0.01
gc buffer busy 2   0 1 0.01
enq: JS - job run lock - synchronize 4   0 1 0.02
enq: HW - contention 10   0 0 0.04
enq: DR - contention 6   0 0 0.03
PX Deq: Signal ACK 33 36 0 0 0.14
gc current multi block request 3   0 0 0.01
enq: UL - contention 3   0 0 0.01
enq: JI - contention 2   0 0 0.01
CSS operation: action 4   0 0 0.02
KJC: Wait for msg sends to complete 12   0 0 0.05
enq: AF - task serialization 1   0 1 0.00
direct path write 2   0 0 0.01
enq: PW - flush prewarm buffers 1   0 0 0.00
LGWR wait for redo copy 10   0 0 0.04
SQL*Net more data to dblink 3   0 0 0.01
SQL*Net message to dblink 45   0 0 0.20
latch: messages 1   0 0 0.00
latch: gcs resource hash 2   0 0 0.01
latch: object queue header operation 1   0 0 0.00
SQL*Net message from client 23,310   535,445 22971 101.35
gcs remote message 4,309,560 99 126,604 29 18,737.22
DIAG idle wait 53,987 0 10,557 196 234.73
ges remote message 140,226 95 10,555 75 609.68
PX Idle Wait 4,453 94 10,554 2370 19.36
ASM background timer 2,161   10,548 4881 9.40
Streams AQ: waiting for messages in the queue 1,152 94 10,547 9155 5.01
virtual circuit status 361 100 10,540 29196 1.57
Streams AQ: qmn slave idle wait 382   10,503 27495 1.66
Streams AQ: qmn coordinator idle wait 795 48 10,503 13211 3.46
class slave wait 116 78 10,414 89776 0.50
Streams AQ: waiting for time management or cleanup tasks 2 100 5,661 2830261 0.01
jobq slave wait 120 100 352 2931 0.52
i/o slave wait 95,212   184 2 413.97
PX Deq: Execution Msg 1,358 32 0 0 5.90
PX Deq: Join ACK 93 40 0 0 0.40
single-task message 1   0 34 0.00
PX Deq: Msg Fragment 423 46 0 0 1.84
PX Deq: Parse Reply 92 40 0 0 0.40
Streams AQ: RAC qmn coordinator idle wait 795 100 0 0 3.46
PX Deq: Execute Reply 46 22 0 0 0.20

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 28,355   15 1 123.28
events in waitclass Other 1,093,979 100 11 0 4,756.43
control file parallel write 3,775   6 2 16.41
log file parallel write 1,525   1 1 6.63
os thread startup 32   1 32 0.14
gc current block 2-way 60   0 0 0.26
gc current grant busy 48   0 0 0.21
gc cr block 2-way 25   0 0 0.11
enq: TM - contention 20   0 0 0.09
library cache lock 11   0 0 0.05
gc cr multi block request 7   0 0 0.03
library cache pin 10   0 0 0.04
gc current grant 2-way 1   0 0 0.00
row cache lock 13   -0 -0 0.06
rdbms ipc message 174,367 96 199,684 1145 758.12
gcs remote message 4,309,549 99 126,604 29 18,737.17
DIAG idle wait 53,978   10,555 196 234.69
ges remote message 140,218 95 10,555 75 609.64
pmon timer 3,641 100 10,548 2897 15.83
ASM background timer 2,161   10,548 4881 9.40
smon timer 2,197   10,545 4800 9.55
Streams AQ: qmn slave idle wait 382   10,503 27495 1.66
Streams AQ: qmn coordinator idle wait 795 48 10,503 13211 3.46
class slave wait 90 100 10,414 115711 0.39
Streams AQ: waiting for time management or cleanup tasks 2 100 5,661 2830261 0.01
Streams AQ: RAC qmn coordinator idle wait 795 100 0 0 3.46

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 39,360
IDLE_TIME 51,842,853
IOWAIT_TIME 23,976
NICE_TIME 347
SYS_TIME 16,708
USER_TIME 19,940
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 9,884,975,104
VM_OUT_BYTES 1,188,159,488
PHYSICAL_MEMORY_BYTES 33,736,966,144
NUM_CPUS 48
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 4,005.80 117.80 1,142,338 2,127,571
zzdb 9.70 7.90 674 30,642
SYS$BACKGROUND 0.10 0.10 9 113,853
zzdbXDB 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 103342 211 713 0 0 0 7065 83
zzdb 674 3 229 0 0 0 20251 0
SYS$BACKGROUND 236 0 224 1 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
4,000 114 2 2000.12 99.62 gw1zq9dnvg29f SQL*Plus BEGIN DBMS_MVIEW.REFRESH('GS_A...
2,535 96 2 1267.71 63.14 ax42nanv2s1kk   /* MV_REFRESH (DEL) */ DELETE ...
1,382 16 1 1382.15 34.42 atq6d70jb8bm0   /* MV_REFRESH (DEL) */ DELETE ...
76 1 1 76.43 1.90 9nm9u80bkwc3d   /* MV_REFRESH (INS) */ INSERT ...
4 0 1 3.59 0.09 cmd2s7ywmjybr   begin sys.dbms_snapshot_utl.se...
3 3 3 1.03 0.08 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
3 1 2 1.51 0.08 dc30qhb774qwn sqlplus@zzdb1 (TNS V1-V3) SELECT D.TABLESPACE_NAME, SPAC...
3 3 3 0.98 0.07 bunssq950snhf   insert into wrh$_sga_target_ad...
1 1 3 0.19 0.01 f65q0ura3jt36   INSERT /*+ LEADING(@"SEL$F5BB7...
0 0 8,772 0.00 0.01 520mkxqpf15q8   select 1 from dual

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
114 4,000 2 57.04 90.64 99.62 gw1zq9dnvg29f SQL*Plus BEGIN DBMS_MVIEW.REFRESH('GS_A...
96 2,535 2 47.88 76.08 63.14 ax42nanv2s1kk   /* MV_REFRESH (DEL) */ DELETE ...
16 1,382 1 15.83 12.58 34.42 atq6d70jb8bm0   /* MV_REFRESH (DEL) */ DELETE ...
3 3 3 1.05 2.51 0.08 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
3 3 3 1.01 2.40 0.07 bunssq950snhf   insert into wrh$_sga_target_ad...
1 76 1 1.36 1.08 1.90 9nm9u80bkwc3d   /* MV_REFRESH (INS) */ INSERT ...
1 3 2 0.49 0.78 0.08 dc30qhb774qwn sqlplus@zzdb1 (TNS V1-V3) SELECT D.TABLESPACE_NAME, SPAC...
1 1 3 0.19 0.45 0.01 f65q0ura3jt36   INSERT /*+ LEADING(@"SEL$F5BB7...
0 0 8,772 0.00 0.39 0.01 520mkxqpf15q8   select 1 from dual
0 0 3 0.09 0.22 0.01 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...

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
2,111,419 2 1,055,709.50 92.94 114.09 4000.23 gw1zq9dnvg29f SQL*Plus BEGIN DBMS_MVIEW.REFRESH('GS_A...
1,590,384 2 795,192.00 70.01 95.75 2535.41 ax42nanv2s1kk   /* MV_REFRESH (DEL) */ DELETE ...
166,077 1 166,077.00 7.31 1.36 76.43 9nm9u80bkwc3d   /* MV_REFRESH (INS) */ INSERT ...
144,543 1 144,543.00 6.36 15.83 1382.15 atq6d70jb8bm0   /* MV_REFRESH (DEL) */ DELETE ...
25,655 35 733.00 1.13 0.18 0.18 c7sn076yz7030   select smontabv.cnt, smontab.t...
16,982 23 738.35 0.75 0.06 0.07 7cq8d0jqxzum1   delete from smon_scn_time wher...
10,368 8 1,296.00 0.46 0.12 0.12 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...
7,294 2 3,647.00 0.32 0.99 3.02 dc30qhb774qwn sqlplus@zzdb1 (TNS V1-V3) SELECT D.TABLESPACE_NAME, SPAC...
7,196 3 2,398.67 0.32 0.28 0.31 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
6,483 2,161 3.00 0.29 0.00 0.22 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...

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,141,467 2 570,733.50 99.86 114.09 4000.23 gw1zq9dnvg29f SQL*Plus BEGIN DBMS_MVIEW.REFRESH('GS_A...
1,079,993 2 539,996.50 94.49 95.75 2535.41 ax42nanv2s1kk   /* MV_REFRESH (DEL) */ DELETE ...
61,470 1 61,470.00 5.38 15.83 1382.15 atq6d70jb8bm0   /* MV_REFRESH (DEL) */ DELETE ...
853 2 426.50 0.07 0.99 3.02 dc30qhb774qwn sqlplus@zzdb1 (TNS V1-V3) SELECT D.TABLESPACE_NAME, SPAC...
68 2 34.00 0.01 0.05 0.35 3xafvt8bycqda   select count(0) from(select t....
64 1 64.00 0.01 0.04 0.30 04fwy5mv2082n   select count(0) from(select t....
57 1 57.00 0.00 0.03 0.28 fqmc3sk1a9knk   select count(0) from(select t....
51 2 25.50 0.00 0.03 0.25 98nybnmdfwc38   select t.BAC014, BAC015, BAEAG...
46 1 46.00 0.00 0.03 0.26 4mnxp0bgzmm9p   select count(0) from(select t....
45 1 45.00 0.00 0.03 0.24 62d53cwcqpzug   select count(0) from(select 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
8,772 8,772 1.00 0.00 0.00 520mkxqpf15q8   select 1 from dual
2,161 0 0.00 0.00 0.00 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
1,440 1,440 1.00 0.00 0.00 8kyvv5knwptbf   select count(*) from sys.job$ ...
753 753 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
360 7,560 21.00 0.00 0.00 aykvshm7zsabd   select size_for_estimate, size...
360 7,200 20.00 0.00 0.00 g6gu1n3x0h1h4   select streams_pool_size_for_e...
310 414 1.34 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
297 275 0.93 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set equa...
262 0 0.00 0.00 0.00 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
262 260 0.99 0.00 0.00 g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
8,772 8,772 61.26 520mkxqpf15q8   select 1 from dual
753 753 5.26 2ym6hhaq30r73   select type#, blocks, extents,...
310 310 2.16 0h6b2sajwb74n   select privilege#, level from ...
262 262 1.83 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
262 262 1.83 g00cj285jmgsw   update sys.mon_mods$ set inser...
186 186 1.30 92bs3gqjsyf78   Select * From YL_AC0A T where ...
181 181 1.26 9nz8k23mumykt sqlplus@zzdb1 (TNS V1-V3) select * From v$session_wait t...
180 0 1.26 7frqszzdu8sgg racgimon@zzdb2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
147 297 1.03 3c1kubcdjnppq   update sys.col_usage$ set equa...
147 147 1.03 b2gnxm5z6r51n   lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,515,552 6 0.12 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
2,072,762 3 0.10 66gs90fyynks7   insert into wrh$_instance_reco...
1,868,316 40 0.09 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...
1,724,996 3 0.08 7h66bd08futqb   insert into wrh$_sess_time_sta...
1,635,077 1 0.08 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sna...
1,617,556 186 0.08 92bs3gqjsyf78   Select * From YL_AC0A T where ...
1,536,218 1 0.07 gvynt9bqh451z   SELECT sum(case when snap_id =...
1,533,712 1 0.07 5an8d9ctcysja   SELECT (case when snap_id = :s...
1,487,788 3 0.07 akh9zqqkx3wj7   select 1, max(id) from sys.wri...
1,264,018 3 0.06 71y370j6428cb   insert into wrh$_thread (snap_...
1,232,047 3 0.06 32whwm2babwpt   insert into wrh$_seg_stat_obj ...
1,228,136 3 0.06 3kjbw2svxydst   insert into wrh$_comp_iostat (...
1,225,927 1 0.06 fqvb8jxywth8n   SELECT startsn.sga_size_factor...
1,189,268 3 0.06 0cfuq7q5cwvpb   select program_oid, schedule_e...
1,158,899 3 0.05 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...
1,106,915 3 0.05 70utgu2587mhs   insert into wrh$_java_pool_adv...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
75 3 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
74 1 gvynt9bqh451z   SELECT sum(case when snap_id =...
73 6 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
70 3 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
70 3 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
69 1 5an8d9ctcysja   SELECT (case when snap_id = :s...
69 1 fqvb8jxywth8n   SELECT startsn.sga_size_factor...
66 1 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sna...
61 3 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...
52 3 akh9zqqkx3wj7   select 1, max(id) from sys.wri...
39 8 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
38 3 0cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
38 3 2xn8yx0uz75fm   SELECT S.SNAP_ID, S.BEGIN_INTE...
38 262 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
38 3 62kabp6pxzmab   UPDATE SYS.WRI$_ADV_TASKS SET ...
38 3 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
38 3 66gs90fyynks7   insert into wrh$_instance_reco...
38 3 70utgu2587mhs   insert into wrh$_java_pool_adv...
38 3 84ygtc6ucuafk DBMS_SCHEDULER update sys.scheduler$_job set ...
38 40 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...
38 40 9pudktzqq9ywb   select a.obj# OBJOID, a.class_...
38 3 bhvyz9bgyrhb2   SELECT name, datatype, value, ...
38 3 bunssq950snhf   insert into wrh$_sga_target_ad...
38 3 dnwpm0gdccrph   insert into wrh$_process_memor...
38 3 dtj94u9jj2qj4   insert into wrh$_tablespace_sp...
38 262 g00cj285jmgsw   update sys.mon_mods$ set inser...
38 3 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
37 3 3kjbw2svxydst   insert into wrh$_comp_iostat (...
36 297 3c1kubcdjnppq   update sys.col_usage$ set equa...
36 18 b6gmjjc1t8vy4   Select Count(0) From Yl_Ic0b T...
35 3 0cfuq7q5cwvpb   select program_oid, schedule_e...
35 3 71y370j6428cb   insert into wrh$_thread (snap_...
35 3 7h66bd08futqb   insert into wrh$_sess_time_sta...
35 2,161 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
35 1,440 8kyvv5knwptbf   select count(*) from sys.job$ ...
35 1,440 8kyvv5knwptbf   select count(*) from sys.job$ ...
35 147 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
29 35 c7sn076yz7030   select smontabv.cnt, smontab.t...
26 186 92bs3gqjsyf78   Select * From YL_AC0A T where ...
24 34 35raw9fndjg6t   Select * From YL_AB0A T where ...
24 34 35raw9fndjg6t   Select * From YL_AB0A T where ...
24 34 35raw9fndjg6t   Select * From YL_AB0A T where ...

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
3,806.73 95.16 4,000.23 114.09 2 gw1zq9dnvg29f SQL*Plus BEGIN DBMS_MVIEW.REFRESH('GS_A...
2,439.09 96.20 2,535.41 95.75 2 ax42nanv2s1kk   /* MV_REFRESH (DEL) */ DELETE ...
1,367.64 98.95 1,382.15 15.83 1 atq6d70jb8bm0   /* MV_REFRESH (DEL) */ DELETE ...
0.17 5.56 3.02 0.99 2 dc30qhb774qwn sqlplus@zzdb1 (TNS V1-V3) SELECT D.TABLESPACE_NAME, SPAC...
0.04 8.74 0.46 0.19 186 92bs3gqjsyf78   Select * From YL_AC0A T where ...
0.03 8.32 0.35 0.05 2 3xafvt8bycqda   select count(0) from(select t....
0.03 48.83 0.05 0.02 5 1mx5f86kun3tc SQL*Plus Select t.Username, t.Tab_Name,...
0.02 7.61 0.31 0.28 3 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.02 38.72 0.05 0.03 2 bnvt1s1yy5w08   select t.BAC014, BAC015, BAEAG...
0.02 41.94 0.04 0.03 1 c4qh7622m9bj1   select count(0) from(select t....
0.02 38.91 0.05 0.03 2 gba5h0hyy7bk8   select t.BAC014, BAC015, BAEAG...
0.02 48.93 0.03 0.02 1 5jb4w96ry3v51   select t.BAC014, BAC015, BAEAG...
0.02 6.43 0.24 0.03 2 gsskh29vtpr90   select t.BAC014, BAC015, BAEAG...
0.01 5.64 0.26 0.03 1 4mnxp0bgzmm9p   select count(0) from(select t....
0.01 7.62 0.18 0.02 1 cb8jjgws559qm   select t.BAC014, BAC015, BAEAG...
0.01 19.41 0.07 0.06 753 2ym6hhaq30r73   select type#, blocks, extents,...
0.01 0.41 3.09 3.16 3 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.01 6.35 0.19 0.02 2 anc8m4m9zdxs0   select t.BAC014, BAC015, BAEAG...
0.01 15.75 0.08 0.03 1 dcwuv4x9fhkgn   select count(0) from(select t....
0.01 3.89 0.30 0.04 1 04fwy5mv2082n   select count(0) from(select t....
0.01 3.99 0.28 0.03 1 fqmc3sk1a9knk   select count(0) from(select t....
0.01 4.35 0.25 0.03 2 98nybnmdfwc38   select t.BAC014, BAC015, BAEAG...
0.01 6.89 0.16 0.01 1 55nvyszunwqr7   select t.BAC014, BAC015, BAEAG...
0.01 24.08 0.04 0.02 8 gbawm8dd01jtn   select count(0) from(select t....
0.01 6.10 0.16 0.03 3 34d5sc1k5q74v   select t.BAC014, BAC015, BAEAG...
0.01 14.77 0.06 0.05 297 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.01 3.31 0.24 0.03 1 62d53cwcqpzug   select count(0) from(select t....
0.01 6.81 0.11 0.02 4 4s7q5hkxjmcvz   select t.BAC014, BAC015, BAEAG...
0.01 22.16 0.03 0.02 4 ffcr8h043kxq1   select count(0) from(select t....
0.01 3.29 0.18 0.18 35 c7sn076yz7030   select smontabv.cnt, smontab.t...
0.01 6.89 0.08 0.05 2 593tj6c6vtap4   select t.aac001 , t.aac002 , t...
0.01 7.85 0.07 0.05 34 35raw9fndjg6t   Select * From YL_AB0A T where ...
0.01 31.07 0.02 0.02 3 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
0.01 7.69 0.07 0.06 23 7cq8d0jqxzum1   delete from smon_scn_time wher...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04fwy5mv2082nselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350127197303151234' )
0cfuq7q5cwvpbselect program_oid, schedule_expr, next_run_date, class_oid, comments, flags, schedule_limit, end_date, run_count, failure_count, last_enabled_time, number_of_args, max_failures, max_runs, job_weight, schedule_id, program_action, start_date, max_run_duration, priority, retry_count, running_instance, running_slave, job_status, last_start_date, last_end_date, user_callback, user_callback_ctx, creator, client_id, guid, nls_env, env, char_env, source, destination, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, owner_udn from sys.scheduler$_job where obj# = :1
0cn2wm9d7zq8dSELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
1mx5f86kun3tcSelect t.Username, t.Tab_Name, t.Errtext, t.dt From t_Mv_Errlog t Where t.Status =0 And t.Dt >= to_date('2013-01-01 20:00:00', 'yyyy.mm.dd hh24:mi:ss') order by t.dt
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2xn8yx0uz75fmSELECT S.SNAP_ID, S.BEGIN_INTERVAL, S.END_INTERVAL FROM (SELECT SS.SNAP_ID, CAST(SS.BEGIN_INTERVAL_TIME AS DATE) AS BEGIN_INTERVAL, CAST(SS.END_INTERVAL_TIME AS DATE) AS END_INTERVAL FROM WRM$_SNAPSHOT SS WHERE SS.DBID = :B3 AND SS.INSTANCE_NUMBER = :B2 AND SS.SNAP_ID <= :B1 ORDER BY SS.DBID, SS.INSTANCE_NUMBER, SS.SNAP_ID DESC) S WHERE ROWNUM <= 2
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
32whwm2babwpt insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
34d5sc1k5q74vselect t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350321197710195712' order by t.BAC014
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
35raw9fndjg6tSelect * From YL_AB0A T where T.AAB001 = :1
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
3kjbw2svxydstinsert into wrh$_comp_iostat (SNAP_ID, DBID, INSTANCE_NUMBER, COMPONENT, FILE_TYPE, IO_TYPE, OPERATION, BYTES, IO_COUNT) select :snap_id, :dbid, :instance_number, 'RMAN', 'DATAFILE', is_sync, type, sum(bytes), sum(io_count) from (select decode(x.type, 1, 'READ', 'WRITE') as type, case when (bitand(x.flags, 2) = 0) then 'SYNC' else 'ASYNC' end as is_sync, x.blocks * x.block_size as bytes, case when (bitand(x.flags, 2) = 0) then (x.sync_count) else (x.async_short_count + x.async_long_count + x.async_ready) end as io_count from x$ksfqp x, v$dbfile df where x.type in (1, 2) and df.name = x.filename) group by is_sync, type
3xafvt8bycqdaselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350428197211290010' )
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4mnxp0bgzmm9pselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350103195801190279' )
4s7q5hkxjmcvzselect t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '510522198601013600' order by t.BAC014
520mkxqpf15q8select 1 from dual
55nvyszunwqr7select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350521197911238038' order by t.BAC014
593tj6c6vtap4select t.aac001 , t.aac002 , t.aab001, t.aac003, getGSCode(t.AAC004, 'AAC004'), t.aac006, getGSCode(t.aac005, 'AAC005'), getGSCode(t.aac011, 'AAC011'), t.aac007, getGSCode(t.aac012, 'AAC012'), getGSCode(t.aac028, 'AAC028'), getGSCode(t.aac013, 'AAC013'), getGSCode(t.aac014, 'AAC014'), getGSCode(t.aac015, 'AAC015'), getGSCode(t.aac020, 'AAC020'), getGSCode(t.aac009, 'AAC009'), t.aae006, t.aae007, t.aae005, getGSCode(t.sac003, 'SAC003'), getGSCode(t.aac019, 'AAC019'), getdwmc(t.aab001), t.aac010 from gs_ac0a t where t.AAC002 = '350428197211290010'
5an8d9ctcysjaSELECT (case when snap_id = :startsn then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :instance_number AND (pga.snap_id = :startsn OR pga.snap_id = :endsn) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
5jb4w96ry3v51select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350625196304212529' order by t.BAC014
62d53cwcqpzugselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350427198012013529' )
62kabp6pxzmabUPDATE SYS.WRI$_ADV_TASKS SET STATUS = :B3 , EXEC_END = SYSDATE, CLEANUP = :B2 , MTIME = SYSDATE WHERE ID = :B1
6403c5znjqh5binsert into WRH$_RULE_SET (snap_id, dbid, instance_number, owner, name, startup_time, cpu_time, elapsed_time, evaluations, sql_free_evaluations, sql_executions, reloads) select * from (select :snap_id, :dbid, :instance_number, rs.owner, rs.name, rs.first_load_time, rs.cpu_time, rs.elapsed_time, rs.evaluations, rs.sql_free_evaluations, rs.sql_executions, rs.reloads from v$rule_set rs order by rs.evaluations desc) where rownum <= 25
66gs90fyynks7insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
70utgu2587mhsinsert into wrh$_java_pool_advice (snap_id, dbid, instance_number, java_pool_size_for_estimate, java_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits) select :snap_id, :dbid, :instance_number, java_pool_size_for_estimate, java_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits from v$java_pool_advice
71y370j6428cbinsert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread#
76natvnhtqqhwINSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
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
7h66bd08futqb insert into wrh$_sess_time_stats (snap_id, dbid, instance_number, session_type, min_logon_time, sum_cpu_time, sum_sys_io_wait, sum_user_io_wait) select :snap_id, :dbid, :instance_number, type, min(logon_time) min_logon_time, sum(cpu_time) cpu_time, sum(sys_io_wait) sys_io_wait, sum(user_io_wait) user_io_wait from (select sid, serial#, max(type) type, max(logon_time) logon_time, max(cpu_time) cpu_time, sum(case when kslcsclsname = 'System I/O' then kslcstim else 0 end) as sys_io_wait, sum(case when kslcsclsname ='User I/O' then kslcstim else 0 end) as user_io_wait from (select /*+ ordered */ allsids.sid sid, allsids.serial# serial#, max(type) type, max(logon_time) logon_time, sum(kewsval) cpu_time from (select type, allsids.sid, sess.ksuseser as serial#, sess.ksuseltm as logon_time from (select /*+ ordered index(p) */ s.indx as sid, decode(l.role, 'reader', 'Logminer Reader', 'preparer', 'Logminer Preparer', 'builder', 'Logminer Builder') as type from x$logmnr_process l, x$ksupr p, x$ksuse s where l.role in ('reader', 'preparer', 'builder') and l.pid = p.indx and bitand(p.ksspaflg, 1)!=0 and p.ksuprpid = s.ksusepid union all select sid _knst as sid, decode(type_knst, 8, 'STREAMS Capture', 7, 'STREAMS Apply Reader', 2, 'STREAMS Apply Server', 1, 'STREAMS Apply Coordinator') as type from x$knstcap where type_knst in (8, 7, 2, 1) union all select indx as sid, (case when ksusepnm like '%(q00%)' then 'QMON Slaves' else 'QMON Coordinator' end) as type from x$ksuse where ksusepnm like '%(q00%)' or ksusepnm like '%(QMNC)' union all select kwqpssid as sid, 'Propagation Sender' as type from x$kwqps union all select kwqpdsid as sid, 'Propagation Receiver' as type from x$kwqpd) allsids, x$ksuse sess where bitand(sess.ksspaflg, 1) != 0 and bitand(sess.ksuseflg, 1) != 0 and allsids.sid = sess.indx) allsids, x$kewssesv sesv, x$kewssmap map where allsids.sid = sesv.ksusenum and sesv.kewsnum = map.soffst and map.aggid = 1 and (map.stype = 2 or map.stype = 3) and map.sname in ('DB CPU', 'background cpu time') group by sid, serial#) allaggr, x$kslcs allio where allaggr.sid = allio.kslcssid(+) and allio.kslcsclsname in ('System I/O', 'User I/O') group by allaggr.sid, allaggr.serial#) group by type
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
84ygtc6ucuafkupdate sys.scheduler$_job set job_status = :1 where obj# = :2
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
8kyvv5knwptbfselect count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
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
92bs3gqjsyf78Select * From YL_AC0A T where T.AAC002 = :1
98nybnmdfwc38select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350425198301250018' order by t.BAC014
9nm9u80bkwc3d /* MV_REFRESH (INS) */ INSERT INTO "FJLSS_QZ"."GS_AC2I" SELECT /*+ NO_MERGE("JV$") */ "MAS$1"."BAEA85", "MAS$1"."AAC001", "MAS$1"."AAE140", "MAS$1"."AAE143", "MAS$1"."AAB001", "JV$"."AAC002", "JV$"."AAC003", "MAS$1"."AAB004", "MAS$1"."AAB080", "MAS$1"."BIEA60", "MAS$1"."AAB033", "MAS$1"."BAC014", "MAS$1"."BAC015", "MAS$1"."AAB122", "MAS$1"."AAB121", "MAS$1"."AAA042", "MAS$1"."AAA041", "MAS$1"."BAEAG1", "MAS$1"."BAEAG3", "MAS$1"."BAEAG9", "MAS$1"."AAE063", "MAS$1"."AAB034", "MAS$1"."BAEA28", "MAS$1"."BAEA27", "MAS$1"."AAE011", "MAS$1"."AAE036", "MAS$1"."BAEA23", "MAS$1"."BAEA24", "MAS$1"."BAEA25", "MAS$1"."BAEA26", "MAS$1"."AAB191", "MAS$1"."AAE002", "MAS$1"."AAE003", "MAS$1"."BAEAH2", "MAS$1"."BAEB01", "MAS$1"."BAEB03", "MAS$1".&q uot;BIEA20", "MAS$1"."AAE064", "MAS$1".ROWID, "JV$"."RID$" FROM ( SELECT "MAS$"."ROWID" "RID$" , "MAS$".* FROM "FZCA"."SYS_ERROR_03"@"DBLINK_QZ_LSS" "MAS$" WHERE ROWID IN (SELECT /*+ HASH_SJ */ CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "FZCA"."MLOG$_SYS_ERROR_03"@"DBLINK_QZ_LSS" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )) "JV$", "FZCA"."SYS_ERROR_09"@DBLINK_QZ_LSS "MAS$1" WHERE "MAS$1"."AAC001"="JV$"."AAC001"
9nz8k23mumyktselect * From v$session_wait t where sid=170
9pudktzqq9ywbselect 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 not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags, :4) <> 0 and lower(b.affinity) = lower(:5)) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
anc8m4m9zdxs0select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350500197512065019' order by t.BAC014
atq6d70jb8bm0/* MV_REFRESH (DEL) */ DELETE FROM "FJLSS_QZ"."GS_AC2I" SNA$ WHERE "AROWID" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "FZCA"."MLOG$_SYS_ERROR_09"@"DBLINK_QZ_LSS" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
ax42nanv2s1kk/* MV_REFRESH (DEL) */ DELETE FROM "FJLSS_QZ"."GS_AC2I" SNA$ WHERE "BROWID" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "FZCA"."MLOG$_SYS_ERROR_03"@"DBLINK_QZ_LSS" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b5yyh2vc9g8tmSELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
b6gmjjc1t8vy4Select Count(0) From Yl_Ic0b T1 Where T1.AAC002 = :1
bhvyz9bgyrhb2SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bnvt1s1yy5w08select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350402196911300023' order by t.BAC014
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
c4qh7622m9bj1select count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350823198212236723' )
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
cb8jjgws559qmselect t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350322198103296838' order by t.BAC014
cmd2s7ywmjybrbegin sys.dbms_snapshot_utl.set_up@"DBLINK_QZ_LSS" (:mown_col, :mas_col, :rollseg_col, :flag_col, :outflag_col, :snaptime_col, :loadertime_col, :num_sid, :snapid_tab, :max_tab_scn_col, :max_dl_scn_col, :max_pmop_scn_col, :trunc_scn_col, :max_ins_tim_col, :max_upd_tim_col, :max_del_tim_col, :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col, :hdl_col, :hdl_indx_col, :rscn); end;
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dc30qhb774qwn SELECT D.TABLESPACE_NAME, SPACE || 'M' "SUM_SPACE(M)", BLOCKS "SUM_BLOCKS", SPACE - NVL (FREE_SPACE, 0) || 'M' "USED_SPACE(M)", ROUND ( (1 - NVL (FREE_SPACE, 0) / SPACE) * 100, 2) || '%' "USED_RATE(%)", FREE_SPACE || 'M' "FREE_SPACE(M)" FROM ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024), 2) SPACE, SUM (BLOCKS) BLOCKS FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) D, ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024), 2) FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+) UNION ALL --???????????????? SELECT D.TABLESPACE_NAME, SPACE || 'M' "SUM_SPACE(M)", BLOCKS SUM_BLOCKS, USED_SPACE || 'M' "USED_SPACE(M)", ROUND (NVL (USED_SPACE, 0) / SPACE * 100, 2) || '%' "USED_RATE(%)", NVL (FREE_SPACE, 0) || 'M' "FREE_SPACE(M)" FROM ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / (1024 * 1024), 2) SPACE, SUM (BLOCKS) BLOCKS FROM DBA_TEMP_FILES GROUP BY TABLESPACE_NAME) D, ( SELECT TABLESPACE_NAME, ROUND (SUM (BYTES_USED) / (1024 * 1024), 2) USED_SPACE, ROUND (SUM (BYTES_FREE) / (1024 * 1024), 2) FREE_SPACE FROM V$TEMP_SPACE_HEADER GROUP BY TABLESPACE_NAME) F WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+) ORDER BY 1
dcwuv4x9fhkgnselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350104198109284914' )
dnwpm0gdccrphinsert into wrh$_process_memory_summary (snap_id, dbid, instance_number, category, num_processes, non_zero_allocs, used_total, allocated_total, allocated_stddev, allocated_max, max_allocated_max) select :snap_id, :dbid, :instance_number, category, COUNT(*) num_processes, SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs, SUM(used) used_total, SUM(allocated) allocated_total, STDDEV(allocated) allocated_stddev, MAX(allocated) allocated_max, MAX(max_allocated) max_allocated_max from v$process_memory group by category
dtj94u9jj2qj4insert into wrh$_tablespace_space_usage (snap_id, dbid, tablespace_id, tablespace_usedsize, tablespace_size, tablespace_maxsize, rtime) select :snap_id, :dbid, KTTEFINFOTSN, sum(KTTEFINFOUSP), sum(KTTEFINFOSIZE), sum(KTTEFINFOMSIZE), to_char(sysdate, 'MM/DD/YYYY HH24:MI:SS') from X$KTTEFINFO group by KTTEFINFOTSN
f65q0ura3jt36 INSERT /*+ LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id, machine, port, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.curr ent_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id, a.machine, a.port, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
ffcr8h043kxq1select count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350402196911300023' )
fqmc3sk1a9knkselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350121198509233725' )
fqvb8jxywth8nSELECT startsn.sga_size_factor * 100 as factor, startsn.sga_size as start_size_mb, endsn.sga_size as end_size_mb, (endsn.estd_db_time - startsn.estd_db_time) * 1000000 as dbtime FROM WRH$_SGA_TARGET_ADVICE startsn , WRH$_SGA_TARGET_ADVICE endsn WHERE startsn.dbid = :db_id AND startsn.snap_id = :start_snap AND startsn.instance_number = :inst_num AND startsn.sga_size_factor >= 1 AND endsn.dbid = startsn.dbid AND endsn.snap_id = :end_snap AND endsn.instance_number = startsn.instance_number AND endsn.sga_size_factor = startsn.sga_size_factor ORDER BY startsn.sga_size_factor ASC
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
g6gu1n3x0h1h4select streams_pool_size_for_estimate s, streams_pool_size_factor * 100 f, estd_spill_time + estd_unspill_time, 0 from v$streams_pool_advice
g6wf9na8zs5hbinsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std FROM x$kewmsmdv WHERE groupid = 2
gba5h0hyy7bk8select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '352627197610021316' order by t.BAC014
gbawm8dd01jtnselect count(0) from(select t.AAC001, d.AAB004, t.AAC002, t.AAC003, t.BIEA60, g.aaa103, t.BAC014, t.BAC015, t.BAEAG8, t.AAB122, t.BAEAH4, t.BAEAH5 from YL_AC2A t left join YL_AB0A d on t.AAB001=d.AAB001 left join YL_AA10 g on t.AAE143 = g.aaa102 and g.aaa100='AAE143' where t.AAC002 = '350122198404256513' )
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gsskh29vtpr90select t.BAC014, BAC015, BAEAG8, a.AAB004 from YL_AC2A t left join YL_AB0A a on t.AAB001=a.AAB001 where t.AAC002 = '350627198104010019' order by t.BAC014
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)
gw1zq9dnvg29fBEGIN DBMS_MVIEW.REFRESH('GS_AC2I', 'F'); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 13,609 1.26 59.17
CPU used when call started 13,003 1.20 56.53
CR blocks created 30 0.00 0.13
Cached Commit SCN referenced 2,963 0.27 12.88
Commit SCN cached 24 0.00 0.10
DB time 1,545,990 143.01 6,721.70
DBWR checkpoint buffers written 41,138 3.81 178.86
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 223 0.02 0.97
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 93 0.01 0.40
DBWR undo block writes 4,036 0.37 17.55
DFO trees parallelized 37 0.00 0.16
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 96 0.01 0.42
PX local messages sent 96 0.01 0.42
PX remote messages recv'd 920 0.09 4.00
PX remote messages sent 562 0.05 2.44
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 37 0.00 0.16
RowCR - row contention 1 0.00 0.00
RowCR attempts 1,091 0.10 4.74
RowCR hits 1,090 0.10 4.74
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 23,058 2.13 100.25
SQL*Net roundtrips to/from dblink 45 0.00 0.20
active txn count during cleanout 1,380 0.13 6.00
application wait time 30 0.00 0.13
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 64,845 6.00 281.93
branch node splits 0 0.00 0.00
buffer is not pinned count 96,531 8.93 419.70
buffer is pinned count 131,743 12.19 572.80
bytes received via SQL*Net from client 7,875,105 728.47 34,239.59
bytes received via SQL*Net from dblink 1,357,672 125.59 5,902.92
bytes sent via SQL*Net to client 3,751,267 347.00 16,309.86
bytes sent via SQL*Net to dblink 16,785 1.55 72.98
calls to get snapshot scn: kcmgss 35,222 3.26 153.14
calls to kcmgas 32,500 3.01 141.30
calls to kcmgcs 1,240 0.11 5.39
change write time 147 0.01 0.64
cleanout - number of ktugct calls 7,394 0.68 32.15
cleanouts and rollbacks - consistent read gets 2 0.00 0.01
cleanouts only - consistent read gets 3,401 0.31 14.79
cluster key scan block gets 59,894 5.54 260.41
cluster key scans 2,069 0.19 9.00
cluster wait time 380,770 35.22 1,655.52
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 6 0.00 0.03
commit batch/immediate requested 6 0.00 0.03
commit cleanout failures: block lost 25 0.00 0.11
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 16 0.00 0.07
commit cleanout failures: cannot pin 1 0.00 0.00
commit cleanouts 2,435 0.23 10.59
commit cleanouts successfully completed 2,393 0.22 10.40
commit immediate performed 6 0.00 0.03
commit immediate requested 6 0.00 0.03
commit txn count during cleanout 6,399 0.59 27.82
concurrency wait time 140 0.01 0.61
consistent changes 57 0.01 0.25
consistent gets 1,693,733 156.67 7,364.06
consistent gets - examination 34,624 3.20 150.54
consistent gets direct 0 0.00 0.00
consistent gets from cache 1,693,733 156.67 7,364.06
cursor authentications 114 0.01 0.50
data blocks consistent reads - undo records applied 12 0.00 0.05
db block changes 354,631 32.80 1,541.87
db block gets 578,014 53.47 2,513.10
db block gets direct 7 0.00 0.03
db block gets from cache 578,007 53.47 2,513.07
deferred (CURRENT) block cleanout applications 1,323 0.12 5.75
dirty buffers inspected 40 0.00 0.17
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 7,448 0.69 32.38
enqueue releases 315,543 29.19 1,371.93
enqueue requests 315,544 29.19 1,371.93
enqueue timeouts 1 0.00 0.00
enqueue waits 566 0.05 2.46
exchange deadlocks 0 0.00 0.00
execute count 20,967 1.94 91.16
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 1,490,814 137.90 6,481.80
free buffer requested 1,558,101 144.13 6,774.35
gc CPU used by this session 5,137 0.48 22.33
gc blocks lost 3,796 0.35 16.50
gc cr block build time 2 0.00 0.01
gc cr block flush time 2 0.00 0.01
gc cr block receive time 14 0.00 0.06
gc cr block send time 6 0.00 0.03
gc cr blocks received 508 0.05 2.21
gc cr blocks served 920 0.09 4.00
gc current block flush time 2 0.00 0.01
gc current block pin time 1 0.00 0.00
gc current block receive time 32,317 2.99 140.51
gc current block send time 6 0.00 0.03
gc current blocks received 391,376 36.20 1,701.63
gc current blocks served 866 0.08 3.77
gc local grants 1,102,961 102.03 4,795.48
gc remote grants 2,478 0.23 10.77
gcs messages sent 431,125 39.88 1,874.46
ges messages sent 6,329 0.59 27.52
global enqueue get time 141 0.01 0.61
global enqueue gets async 743 0.07 3.23
global enqueue gets sync 28,831 2.67 125.35
global enqueue releases 27,973 2.59 121.62
heap block compress 501 0.05 2.18
hot buffers moved to head of LRU 7,293 0.67 31.71
immediate (CR) block cleanout applications 3,403 0.31 14.80
immediate (CURRENT) block cleanout applications 4,918 0.45 21.38
index crx upgrade (positioned) 5,710 0.53 24.83
index fast full scans (full) 32 0.00 0.14
index fetch by key 87,733 8.12 381.45
index scans kdiixs1 11,477 1.06 49.90
leaf node 90-10 splits 19 0.00 0.08
leaf node splits 379 0.04 1.65
lob reads 11 0.00 0.05
lob writes 119 0.01 0.52
lob writes unaligned 119 0.01 0.52
local undo segment hints helped 0 0.00 0.00
logons cumulative 321 0.03 1.40
messages received 20,081 1.86 87.31
messages sent 20,081 1.86 87.31
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,637,767 151.50 7,120.73
opened cursors cumulative 14,047 1.30 61.07
parse count (failures) 10 0.00 0.04
parse count (hard) 211 0.02 0.92
parse count (total) 14,320 1.32 62.26
parse time cpu 171 0.02 0.74
parse time elapsed 205 0.02 0.89
physical read IO requests 268,429 24.83 1,167.08
physical read bytes 9,363,628,032 866,160.41 40,711,426.23
physical read total IO requests 298,088 27.57 1,296.03
physical read total bytes 9,847,717,888 910,940.01 42,816,164.73
physical read total multi block requests 63,702 5.89 276.97
physical reads 1,143,021 105.73 4,969.66
physical reads cache 1,143,021 105.73 4,969.66
physical reads cache prefetch 1,038,996 96.11 4,517.37
physical reads direct 0 0.00 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 33,697 3.12 146.51
physical write bytes 338,919,424 31,350.95 1,473,562.71
physical write total IO requests 46,610 4.31 202.65
physical write total bytes 581,920,256 53,829.17 2,530,088.07
physical write total multi block requests 4,363 0.40 18.97
physical writes 41,372 3.83 179.88
physical writes direct 7 0.00 0.03
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 41,365 3.83 179.85
physical writes non checkpoint 15,415 1.43 67.02
pinned buffers inspected 0 0.00 0.00
pinned cursors current 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 4,770 0.44 20.74
process last non-idle time 14,455 1.34 62.85
queries parallelized 37 0.00 0.16
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 98,986 9.16 430.37
recursive cpu usage 12,474 1.15 54.23
redo blocks read for recovery 0 0.00 0.00
redo blocks written 112,211 10.38 487.87
redo buffer allocation retries 0 0.00 0.00
redo entries 199,433 18.45 867.10
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 2,392 0.22 10.40
redo size 55,078,348 5,094.89 239,471.08
redo subscn max counts 5,876 0.54 25.55
redo synch time 1 0.00 0.00
redo synch writes 16 0.00 0.07
redo wastage 438,484 40.56 1,906.45
redo write broadcast ack time 43 0.00 0.19
redo write time 148 0.01 0.64
redo writer latching time 0 0.00 0.00
redo writes 1,525 0.14 6.63
rollback changes - undo records applied 81,155 7.51 352.85
rollbacks only - consistent read gets 10 0.00 0.04
root node splits 0 0.00 0.00
rows fetched via callback 6,299 0.58 27.39
session connect time 14,477 1.34 62.94
session cursor cache hits 11,895 1.10 51.72
session logical reads 2,271,747 210.14 9,877.16
shared hash latch upgrades - no wait 7,072 0.65 30.75
sorts (disk) 0 0.00 0.00
sorts (memory) 4,940 0.46 21.48
sorts (rows) 873,232 80.78 3,796.66
space was found by tune down 0 0.00 0.00
sql area evicted 86 0.01 0.37
sql area purged 10 0.00 0.04
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 13 0.00 0.06
switch current to new buffer 9,340 0.86 40.61
table fetch by rowid 31,979 2.96 139.04
table fetch continued row 1 0.00 0.00
table scan blocks gotten 1,553,609 143.71 6,754.82
table scan rows gotten 44,939,683 4,157.04 195,389.93
table scans (long tables) 3 0.00 0.01
table scans (short tables) 2,874 0.27 12.50
total number of times SMON posted 2,198 0.20 9.56
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction rollbacks 6 0.00 0.03
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 16,076,928 1,487.16 69,899.69
user I/O wait time 21,433 1.98 93.19
user calls 34,209 3.16 148.73
user commits 30 0.00 0.13
user rollbacks 200 0.02 0.87
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 2,275 0.21 9.89
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 2.4E+11 2.4E+11
session cursor cache count 256,684 257,835
session uga memory 1.2E+13 1.2E+13
opened cursors current 105 100
workarea memory allocated 2,100 2,100
logons current 102 87
session uga memory max 46,187,426,624 46,325,526,504
session pga memory 57,622,620,688 58,085,585,392

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)
TBS_AUTO_LSS 265,228 25 0.48 4.30 21,782 2 0 0.00
TBS_IDX_AUTO_LSS 3,188 0 3.66 1.00 10,197 1 0 0.00
SYSAUX 9 0 4.44 1.00 825 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 647 0 0 0.00
SYSTEM 4 0 5.00 1.00 246 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)
SYSAUX +ZZDB/zzdb/datafile/sysaux.263.796477355 9 0 4.44 1.00 825 0 0 0.00
SYSTEM +ZZDB/zzdb/datafile/system.261.796477349 4 0 5.00 1.00 246 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.272.796760583 5,650 1 0.50 4.14 472 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.273.796760607 5,560 1 0.44 4.18 437 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.274.796760631 5,311 0 0.52 4.39 497 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.275.796760639 5,303 0 0.57 4.45 406 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.276.796760649 5,328 0 0.51 4.38 364 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.277.796760659 5,407 1 0.49 4.30 456 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.278.796760669 5,145 0 0.57 4.54 406 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.279.796760677 5,292 0 0.52 4.41 408 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.280.796760687 5,200 0 0.50 4.51 388 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.281.796760697 5,260 0 0.56 4.46 381 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.282.796760707 5,283 0 0.50 4.39 426 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.283.796760717 5,257 0 0.56 4.45 477 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.284.796760725 5,219 0 0.52 4.52 455 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.285.796760735 5,283 0 0.51 4.47 429 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.286.796760745 5,129 0 0.54 4.60 507 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.287.796760757 5,296 0 0.50 4.42 515 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.288.796760765 5,372 0 0.49 4.34 432 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.289.796760775 5,514 1 0.46 4.23 469 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.290.796760785 5,588 1 0.47 4.23 419 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.291.796760795 5,488 1 0.48 4.24 393 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.292.796760805 5,666 1 0.44 4.12 363 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.293.796760815 5,604 1 0.43 4.16 423 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.294.796760825 5,721 1 0.46 4.07 404 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.295.796760835 5,703 1 0.41 4.09 427 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.296.796760843 5,322 0 0.45 4.33 407 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.297.796760853 5,313 0 0.45 4.32 451 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.298.796760863 5,322 0 0.46 4.32 445 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.299.796760873 5,405 0 0.51 4.22 514 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.300.796760883 5,205 0 0.52 4.41 445 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.301.796760893 5,277 0 0.53 4.40 478 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.302.796760903 5,325 0 0.46 4.30 378 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.303.796760913 5,384 0 0.48 4.29 449 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.304.796760923 5,490 1 0.46 4.20 458 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.305.796760933 5,335 0 0.53 4.34 496 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.306.796760943 5,376 0 0.43 4.33 433 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.307.796760953 5,513 1 0.42 4.22 446 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.308.796760963 5,423 1 0.46 4.26 465 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.309.796760973 5,687 1 0.39 4.07 514 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.310.796760983 5,378 0 0.49 4.27 480 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.311.796760993 5,413 1 0.53 4.29 493 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.312.796761003 5,388 0 0.48 4.30 447 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.331.796834803 5,500 1 0.42 4.21 444 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.332.796834817 5,369 0 0.47 4.32 367 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.333.796834833 5,322 0 0.50 4.33 425 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.334.796834847 5,474 1 0.43 4.24 511 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.335.796834861 5,503 1 0.41 4.23 456 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.336.796834871 5,526 1 0.44 4.22 406 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.337.796834883 5,696 1 0.43 4.10 521 0 0 0.00
TBS_AUTO_LSS +ZZDB/zzdb/datafile/tbs_auto_lss.338.796834893 5,703 1 0.42 4.11 499 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.313.796761091 171 0 3.22 1.00 506 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.314.796761101 118 0 3.31 1.00 427 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.315.796761111 110 0 4.55 1.00 444 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.316.796761121 148 0 3.45 1.00 504 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.317.796761131 136 0 3.24 1.00 538 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.319.796816733 133 0 3.68 1.00 473 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.320.796816745 152 0 3.09 1.00 453 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.321.796816755 130 0 3.38 1.00 362 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.322.796816765 164 0 3.41 1.00 348 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.323.796819403 158 0 3.42 1.00 448 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.324.796819419 200 0 4.35 1.00 569 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.325.796819437 184 0 3.53 1.00 590 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.326.796819451 160 0 3.56 1.00 592 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.327.796819469 144 0 4.79 1.00 441 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.328.796819483 130 0 4.38 1.00 556 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.329.796819499 195 0 3.64 1.00 540 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.330.796819515 100 0 4.20 1.00 396 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.339.796834907 128 0 4.30 1.00 497 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.340.796834919 169 0 2.90 1.00 423 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.341.796834931 186 0 3.44 1.00 620 0 0 0.00
TBS_IDX_AUTO_LSS +ZZDB/zzdb/datafile/tbs_idx_auto_lss.342.796834943 172 0 3.60 1.00 470 0 0 0.00
UNDOTBS1 +ZZDB/zzdb/datafile/undotbs1.262.796902269 0 0     647 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 2,202,633 50 2,271,807 1,143,021 41,365 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 0 220 639 542 3774870 542  
E 0 0 180 414 160 3774870 160  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,824 0.10 218,538 1.07 227,857,928
D 3,648 0.20 437,076 1.06 225,299,282
D 5,472 0.30 655,614 1.05 222,166,125
D 7,296 0.40 874,152 1.03 218,443,406
D 9,120 0.50 1,092,690 1.02 216,375,348
D 10,944 0.60 1,311,228 1.01 215,165,634
D 12,768 0.69 1,529,766 1.01 214,261,232
D 14,592 0.79 1,748,304 1.01 213,428,284
D 16,416 0.89 1,966,842 1.00 212,658,590
D 18,240 0.99 2,185,380 1.00 212,217,497
D 18,384 1.00 2,202,633 1.00 212,195,052
D 20,064 1.09 2,403,918 1.00 211,911,904
D 21,888 1.19 2,622,456 1.00 211,687,498
D 23,712 1.29 2,840,994 1.00 211,450,594
D 25,536 1.39 3,059,532 1.00 211,251,841
D 27,360 1.49 3,278,070 0.99 211,094,206
D 29,184 1.59 3,496,608 0.99 210,955,323
D 31,008 1.69 3,715,146 0.99 210,810,534
D 32,832 1.79 3,933,684 0.99 210,701,344
D 34,656 1.89 4,152,222 0.99 210,442,386
D 36,480 1.98 4,370,760 0.98 207,495,886

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 149 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 4,096 3,462 314.62 0.00 0.00 0.00 0.00 419,430
E 4,096 3,442 346.28 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 2,089 2,089 0 0
64K 128K 17 17 0 0
512K 1024K 136 136 0 0
1M 2M 33 33 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
512 0.13 105,372.41 16,920.29 86.00 0
1,024 0.25 105,372.41 13,883.77 88.00 0
2,048 0.50 105,372.41 10,604.83 91.00 0
3,072 0.75 105,372.41 10,604.83 91.00 0
4,096 1.00 105,372.41 9,307.33 92.00 0
4,915 1.20 105,372.41 7,060.45 94.00 0
5,734 1.40 105,372.41 7,060.45 94.00 0
6,554 1.60 105,372.41 7,060.45 94.00 0
7,373 1.80 105,372.41 7,060.45 94.00 0
8,192 2.00 105,372.41 7,060.45 94.00 0
12,288 3.00 105,372.41 7,060.45 94.00 0
16,384 4.00 105,372.41 7,060.45 94.00 0
24,576 6.00 105,372.41 7,060.45 94.00 0
32,768 8.00 105,372.41 7,060.45 94.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)
1,408 0.69 227 13,734 256,001 0.99 16,841 1.09 16,909
1,616 0.80 425 23,369 256,981 1.00 15,861 1.03 17,032
1,824 0.90 627 34,406 257,396 1.00 15,446 1.00 17,083
2,032 1.00 833 47,950 257,441 1.00 15,401 1.00 17,087
2,240 1.10 1,040 63,058 257,448 1.00 15,394 1.00 17,088
2,448 1.20 1,229 78,141 257,451 1.00 15,391 1.00 17,088
2,656 1.31 1,347 89,275 257,452 1.00 15,390 1.00 17,088
2,864 1.41 1,372 92,005 257,452 1.00 15,390 1.00 17,088
3,072 1.51 1,372 92,005 257,452 1.00 15,390 1.00 17,088
3,280 1.61 1,372 92,005 257,452 1.00 15,390 1.00 17,088
3,488 1.72 1,372 92,005 257,452 1.00 15,390 1.00 17,088
3,696 1.82 1,372 92,005 257,452 1.00 15,390 1.00 17,088
3,904 1.92 1,372 92,005 257,452 1.00 15,390 1.00 17,088
4,112 2.02 1,372 92,005 257,452 1.00 15,390 1.00 17,088

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 1,343,426 225,308,706
10,240 0.50 1,327,732 216,375,295
15,360 0.75 1,322,588 214,253,344
20,480 1.00 1,318,895 212,195,052
25,600 1.25 1,317,576 211,452,369
30,720 1.50 1,316,653 210,964,321
35,840 1.75 1,315,862 210,433,833
40,960 2.00 1,310,586 207,505,541

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

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

No data exists for this section of the report.

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 60 60 0 32 0 6.88
PS-PX Process Reservation 403 403 0 271 0 0.26
TT-Tablespace 1,004 1,004 0 72 0 0.28
CF-Controlfile Transaction 25,039 25,039 0 29 0 0.34
US-Undo Segment 57 57 0 25 0 0.40
TM-DML 9,874 9,874 0 21 0 0.48
UL-User-defined 8 8 0 3 0 3.33
TA-Instance Undo 71 71 0 35 0 0.00
TD-KTF map table enqueue (KTF dump entries) 35 35 0 35 0 0.00
FB-Format Block 48 48 0 20 0 0.00
HW-Segment High Water Mark 376 376 0 10 0 0.00
DR-Distributed Recovery 6 6 0 6 0 0.00
JS-Job Scheduler (job run lock - synchronize) 6 6 0 4 0 0.00
JI-Materialized View 2 2 0 2 0 0.00
AF-Advisor Framework (task serialization) 21 21 0 1 0 0.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 0 1 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
1 2.46 1,033 2,147 4 3219.6/3374.9 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
09-Jan 12:02 52 45 0 3 3,375 0/0 0/0/0/0/0/0
09-Jan 11:52 2 20 0 1 3,367 0/0 0/0/0/0/0/0
09-Jan 11:42 1 19 0 1 3,357 0/0 0/0/0/0/0/0
09-Jan 11:32 0 3 0 0 3,347 0/0 0/0/0/0/0/0
09-Jan 11:22 2 28 0 1 3,337 0/0 0/0/0/0/0/0
09-Jan 11:12 1 87 1,329 2 3,328 0/0 0/0/0/0/0/0
09-Jan 11:02 70 59 729 4 3,318 0/0 0/0/0/0/0/0
09-Jan 10:52 1,857 363 128 3 3,308 0/0 0/0/0/0/0/0
09-Jan 10:42 149 22 2,147 4 3,315 0/0 0/0/0/0/0/0
09-Jan 10:32 98 8 1,547 2 3,307 0/0 0/0/0/0/0/0
09-Jan 10:22 80 22 947 2 3,298 0/0 0/0/0/0/0/0
09-Jan 10:12 34 124 346 2 3,288 0/0 0/0/0/0/0/0
09-Jan 10:02 42 43 0 4 3,279 0/0 0/0/0/0/0/0
09-Jan 09:52 1 16 0 1 3,269 0/0 0/0/0/0/0/0
09-Jan 09:42 1 26 0 1 3,259 0/0 0/0/0/0/0/0
09-Jan 09:32 1 7 0 1 3,249 0/0 0/0/0/0/0/0
09-Jan 09:22 1 17 0 1 3,239 0/0 0/0/0/0/0/0
09-Jan 09:12 0 72 0 0 3,230 0/0 0/0/0/0/0/0
09-Jan 09:02 64 52 0 3 3,220 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,578 0.00   0 0  
ASM map operation freelist 176 0.00   0 0  
ASM map operation hash table 704,042 0.00 0.00 0 0  
ASM network background latch 4,322 0.00   0 0  
AWR Alerted Metric Element list 61,348 0.00   0 0  
Consistent RBA 1,525 0.00   0 0  
FAL request queue 216 0.00   0 0  
FAL subheap alocation 216 0.00   0 0  
FOB s.o list latch 4,715 0.00   0 0  
JS broadcast add buf latch 7,613 0.00   0 0  
JS broadcast drop buf latch 7,616 0.00   0 0  
JS broadcast load blnc latch 7,304 0.00   0 0  
JS mem alloc latch 17 0.00   0 0  
JS queue access latch 17 0.00   0 0  
JS queue state obj latch 263,046 0.00   0 0  
JS slv state obj latch 12 0.00   0 0  
KCL gc element parent latch 2,032,600 0.00 0.00 0 4,110 0.00
KFK SGA context latch 3,684 0.00   0 0  
KFMD SGA 138 0.00   0 0  
KJC message pool free list 24,776 0.00 0.00 0 20,114 0.00
KJCT flow control latch 138,865 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 3,602 0.00   0 0  
KSXR large replies 726 0.00   0 0  
KTF sga latch 69 0.00   0 3,571 0.00
KWQMN job cache list latch 797 0.00   0 0  
KWQP Prop Status 6 0.00   0 0  
MQL Tracking Latch 0     0 216 0.00
Memory Management Latch 0     0 3,602 0.00
OS process 477 0.00   0 0  
OS process allocation 3,906 0.00   0 0  
OS process: request allocation 175 0.00   0 0  
PL/SQL warning settings 341 0.00   0 0  
SGA IO buffer pool latch 40,348 0.00   0 40,348 0.00
SQL memory manager latch 3 0.00   0 3,599 0.00
SQL memory manager workarea list latch 242,162 0.00   0 0  
Shared B-Tree 391 0.00   0 0  
active checkpoint queue latch 38,869 0.16 0.00 0 0  
active service list 64,958 0.00   0 9,964 0.00
archive control 180 0.00   0 0  
archive process latch 4,031 0.00   0 0  
begin backup scn array 2 0.00   0 0  
business card 74 0.00   0 0  
cache buffer handles 930 0.00   0 0  
cache buffers chains 9,092,745 0.00 0.00 0 3,098,602 0.00
cache buffers lru chain 556,138 0.00 0.00 0 3,145,967 0.00
cache table scan latch 0     0 63,702 0.00
channel handle pool latch 219 0.00   0 0  
channel operations parent latch 422,154 0.00 0.00 0 0  
checkpoint queue latch 1,997,366 0.00 0.00 0 41,498 0.00
client/application info 1,333 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 321 0.00   0 0  
constraint object allocation 4 0.00   0 0  
dml lock allocation 19,906 0.00   0 0  
dummy allocation 657 0.00   0 0  
enqueue hash chains 667,192 0.00   0 4,062 0.00
enqueues 611,510 0.00 0.00 0 0  
error message lists 149 0.00   0 0  
event group latch 80 0.00   0 0  
file cache latch 3,536 0.00   0 0  
gcs opaque info freelist 794,862 0.00   0 0  
gcs partitioned table hash 3,227,671 0.00   0 1,100,987 0.00
gcs remastering latch 405,900 0.00   0 0  
gcs resource freelist 19,321 0.00   0 802 0.00
gcs resource hash 3,198,366 0.00 0.02 0 0  
gcs shadows freelist 3,720 0.00   0 1,200 0.00
ges caches resource lists 993,727 0.00 0.00 0 999,601 0.00
ges deadlock list 1,628 0.00   0 0  
ges domain table 54,282 0.00   0 0  
ges enqueue table freelist 58,352 0.00   0 0  
ges group table 80,498 0.00   0 0  
ges process hash list 4,510 0.00   0 0  
ges process parent latch 119,166 0.00   0 0  
ges process table freelist 175 0.00   0 0  
ges resource hash list 85,418 0.02 0.00 0 5,119 0.02
ges resource scan list 50 0.00   0 0  
ges resource table freelist 9,547 0.01 0.00 0 0  
ges timeout list 590 0.00   0 304 0.00
global KZLD latch for mem in SGA 46 0.00   0 0  
global hanganlyze operation 3 0.00   0 0  
global tx hash mapping 12 0.00   0 0  
hash table column usage latch 249 0.00   0 7,615 0.00
hash table modification latch 223 0.00   0 0  
interrupt manipulation 1,630 0.00   0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 186 0.00   0 0  
kks stats 732 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 1,452 0.00   0 0  
ksuosstats global area 727 0.00   0 0  
ktm global data 2,198 0.00   0 0  
kwqbsn:qsga 388 0.00   0 0  
lgwr LWN SCN 4,142 0.00   0 0  
library cache 79,359 0.00   0 384 0.00
library cache load lock 56 0.00   0 0  
library cache lock 113,255 0.00   0 0  
library cache lock allocation 632 0.00   0 0  
library cache pin 36,547 0.00 0.00 0 0  
library cache pin allocation 40 0.00   0 0  
list of block allocation 1,501 0.00   0 0  
loader state object freelist 2 0.00   0 0  
logminer context allocation 3 0.00   0 0  
longop free list parent 1,305 0.00   0 3 0.00
message pool operations parent latch 3,171 0.00   0 0  
messages 387,280 0.04 0.01 0 0  
mostly latch-free SCN 4,143 0.00   0 0  
multiblock read objects 208,746 0.00   0 0  
name-service memory objects 1,540 0.00   0 0  
name-service namespace bucket 109,294 0.00   0 0  
name-service pending queue 792 0.00   0 0  
name-service request queue 108,509 0.00   0 0  
ncodef allocation latch 174 0.00   0 0  
object queue header heap 156,672 0.00   0 468 0.00
object queue header operation 3,397,515 0.00 0.06 0 0  
object stats modification 3 0.00   0 0  
parallel query alloc buffer 3,592 0.00   0 0  
parallel query stats 346 0.00   0 0  
parallel txn reco latch 3,360 0.00   0 0  
parameter list 474 0.00   0 0  
parameter table management 667 0.00   0 0  
post/wait queue 68 0.00   0 43 0.00
process allocation 107,669 0.00   0 80 0.00
process group creation 175 0.00   0 0  
process queue 911 0.00   0 0  
process queue reference 17,462 0.00   0 1,675 0.00
qmn task queue latch 1,528 0.00   0 0  
query server freelists 693 0.00   0 0  
queued dump request 53,970 0.00   0 0  
redo allocation 13,994 0.02 0.00 0 199,537 0.02
redo copy 0     0 199,545 0.01
redo writing 51,044 0.07 0.00 0 0  
resmgr group change latch 486 0.00   0 0  
resmgr:active threads 608 0.00   0 0  
resmgr:actses change group 289 0.00   0 0  
resmgr:free threads list 605 0.00   0 0  
resmgr:resource group CPU method 304 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 321,883 0.00 0.00 0 181 0.00
rules engine rule set statistics 300 0.00   0 0  
sequence cache 430 0.00   0 0  
session allocation 5,823 0.02 0.00 0 0  
session idle bit 70,709 0.00   0 0  
session state list latch 680 0.00   0 0  
session switching 649 0.00   0 0  
session timer 3,640 0.00   0 0  
shared pool 114,977 0.00 0.00 0 0  
shared pool sim alloc 7 0.00   0 0  
shared pool simulator 794 0.00   0 0  
simulator hash latch 505,777 0.00   0 0  
simulator lru latch 0     0 317,169 0.00
slave class 26 0.00   0 0  
slave class create 104 2.88 1.00 0 0  
sort extent pool 2,486 0.00   0 0  
state object free list 6 0.00   0 0  
statistics aggregation 1,680 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 463 0.00   0 0  
transaction allocation 111 0.00   0 0  
transaction branch allocation 3,644 0.00   0 0  
undo global data 121,197 0.00   0 0  
user lock 245 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
messages 387,280 155 1 154 0 0 0
gcs resource hash 3,198,366 125 2 124 0 0 0
object queue header operation 3,397,515 18 1 17 0 0 0
slave class create 104 3 3 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 2 0
gcs resource hash kjblocalfile_nolock 0 2 0
messages ksarcv 0 1 0
object queue header operation kcbo_switch_q_bg 0 1 0
slave class create ksvcreate 0 3 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
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1,553,952 68.40
FJLSS_QZ TBS_IDX_AUTO_LSS IDX_GSAC2I_AAC002   INDEX 96,784 4.26
FJLSS_QZ TBS_IDX_AUTO_LSS IDX_GSAC2I_AAC001   INDEX 85,696 3.77
FJLSS_QZ TBS_IDX_AUTO_LSS PK_GS_AC2I   INDEX 71,216 3.13
SYS SYSTEM SMON_SCN_TIME   TABLE 57,952 2.55

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 1,138,837 99.63
FJLSS_QZ TBS_IDX_AUTO_LSS PK_GS_AC2I   INDEX 2,611 0.23
FJLSS_FZ TBS_AUTO_LSS YL_AC2A   TABLE 187 0.02
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 152 0.01
FJLSS_SM TBS_AUTO_LSS YL_AC2A   TABLE 110 0.01

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
FJLSS_SM TBS_AUTO_LSS YL_AC2A   TABLE 48 9.45
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 44 8.66
FJLSS_FZ TBS_AUTO_LSS YL_AC2A   TABLE 42 8.27
SYS SYSAUX WRH$_SQL_PLAN   TABLE 24 4.72
SYS SYSAUX WRH$_SQLTEXT   TABLE 22 4.33

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 390,083 99.67
FJLSS_FZ TBS_AUTO_LSS YL_AC2A   TABLE 172 0.04
FJLSS_QZ TBS_IDX_AUTO_LSS PK_GS_AC2I   INDEX 140 0.04
FJLSS_ZZ TBS_AUTO_LSS YL_AC2A   TABLE 140 0.04
FJLSS_SM TBS_AUTO_LSS YL_AC2A   TABLE 133 0.03

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 197 0.00 0   6 1
dc_database_links 134 0.00 0   0 10
dc_files 150 0.00 0   0 75
dc_global_oids 921 0.00 0   0 22
dc_histogram_data 180 0.00 0   0 65,362
dc_histogram_defs 2,220 3.02 0   0 11,082
dc_object_ids 6,360 0.02 0   0 1,533
dc_objects 1,526 0.07 0   25 2,672
dc_profiles 58 0.00 0   0 1
dc_rollback_segments 4,823 0.00 0   0 50
dc_segments 1,448 0.21 0   12 1,261
dc_sequences 8 12.50 0   8 4
dc_tablespace_quotas 5 0.00 0   0 16
dc_tablespaces 83,813 0.00 0   0 10
dc_usernames 653 0.00 0   0 50
dc_users 4,178 0.00 0   0 93
global database name 2 0.00 0   0 1
outstanding_alerts 126 85.71 0   0 1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 12 0 0
dc_histogram_defs 67 35 0
dc_object_ids 11 0 0
dc_objects 41 0 0
dc_segments 24 4 0
dc_sequences 16 0 0
dc_tablespace_quotas 10 0 0
outstanding_alerts 252 108 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 64 0.00 83 0.00 0 0
CLUSTER 7 0.00 12 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 2,555 9.86 25,623 2.20 80 93
TABLE/PROCEDURE 382 0.00 4,151 0.75 23 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 12 2 0 0 0
INDEX 11 0 0 0 0
TABLE/PROCEDURE 2,411 76 17 35 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 289.17   2.75 4.05 17 17 105 105
  Freeable 24.50 0.00 1.44 1.49 7   17 17
  SQL 0.57 0.31 0.01 0.02 0 2 71 67
  PL/SQL 0.42 0.21 0.00 0.01 0 0 103 103
E Other 313.67   3.49 4.09 17 17 90 90
  Freeable 31.56 0.00 1.17 1.22 7   27 27
  PL/SQL 0.58 0.39 0.01 0.01 0 0 88 88
  SQL 0.50 0.29 0.01 0.02 0 2 56 51

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 19,277,021,184  
Fixed Size 2,134,632  
Redo Buffers 31,416,320  
Variable Size 2,164,264,344  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared ASH buffers 63.00 63.00 0.00
shared CCursor 81.75 81.84 0.11
shared Heap0: KGL 26.72 26.77 0.19
shared KQR M SO 31.16 31.16 0.00
shared PCursor 33.25 33.38 0.37
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 433.26 430.00 -0.75
shared gcs resources 380.27 380.27 0.00
shared gcs shadows 227.70 227.70 0.00
shared library cache 51.12 51.16 0.08
shared sql area 292.38 295.77 1.16
streams free memory 16.00 16.00 0.00
  buffer_cache 18,384.00 18,384.00 0.00
  fixed_sga 2.04 2.04 0.00
  log_buffer 29.96 29.96 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 0 0 0
QMON Coordinator 0 0 0

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

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,380,211 2,441,625 2460830 2460830


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/oracle/admin/zzdb/adump   
background_dump_dest /u01/oracle/admin/zzdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +ZZDB/zzdb/controlfile/current.256.796477345, +ZZDB/zzdb/controlfile/current.343.796903479, +ZZDB/zzdb/controlfile/current.344.796903563   
core_dump_dest /u01/oracle/admin/zzdb/cdump   
db_block_size 8192   
db_create_file_dest +ZZDB   
db_domain      
db_file_multiblock_read_count 16   
db_name zzdb   
dispatchers (PROTOCOL=TCP) (SERVICE=zzdbXDB)   
instance_number 1   
job_queue_processes 30   
log_archive_dest_1 location=/backup/archivelog   
log_archive_format %t_%s_%r.dbf   
open_cursors 300   
pga_aggregate_target 4294967296   
processes 300   
remote_listener LISTENERS_ZZDB   
remote_login_passwordfile EXCLUSIVE   
sessions 335   
sga_target 21474836480   
spfile +ZZDB/zzdb/spfilezzdb.ora   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /u01/oracle/admin/zzdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 513 0.05 2.23
acks for commit broadcast(logical) 523 0.05 2.27
broadcast msgs on commit(actual) 1,526 0.14 6.63
broadcast msgs on commit(logical) 1,526 0.14 6.63
broadcast msgs on commit(wasted) 53 0.00 0.23
broadcast on commit wait time(ms) 273 0.03 1.19
broadcast on commit waits 1,266 0.12 5.50
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 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 366 0.03 1.59
gcs ast xid 0 0.00 0.00
gcs blocked converts 2,248 0.21 9.77
gcs blocked cr converts 671 0.06 2.92
gcs compatible basts 0 0.00 0.00
gcs compatible cr basts (global) 11 0.00 0.05
gcs compatible cr basts (local) 396,876 36.71 1,725.55
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 194 0.02 0.84
gcs dbwr write request msgs 108 0.01 0.47
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 99 0.01 0.43
gcs immediate (null) converts 1,558 0.14 6.77
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 946 0.09 4.11
gcs indirect ast 591 0.05 2.57
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 41 0.00 0.18
gcs msgs process time(ms) 563 0.05 2.45
gcs msgs received 26,799 2.48 116.52
gcs out-of-order msgs 0 0.00 0.00
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 11 0.00 0.05
gcs side channel msgs actual 17,653 1.63 76.75
gcs side channel msgs logical 400,131 37.01 1,739.70
gcs stale cr 408 0.04 1.77
gcs undo cr 1 0.00 0.00
gcs write notification msgs 0 0.00 0.00
gcs writes refused 3 0.00 0.01
ges msgs process time(ms) 93 0.01 0.40
ges msgs received 5,440 0.50 23.65
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 1,787 0.17 7.77
implicit batch messages sent 5,739 0.53 24.95
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 2,321 0.21 10.09
messages queue sent actual 19,119 1.77 83.13
messages queue sent logical 31,287 2.89 136.03
messages received actual 29,454 2.72 128.06
messages received logical 32,239 2.98 140.17
messages sent directly 11,240 1.04 48.87
messages sent indirectly 27,915 2.58 121.37
messages sent not implicit batched 13,380 1.24 58.17
messages sent pbatched 397,737 36.79 1,729.29
msgs causing lmd to send msgs 1,423 0.13 6.19
msgs causing lms(s) to send msgs 277 0.03 1.20
msgs received queue time (ms) 379 0.04 1.65
msgs received queued 32,237 2.98 140.16
msgs sent queue time (ms) 847 0.08 3.68
msgs sent queue time on ksxp (ms) 24,781 2.29 107.74
msgs sent queued 30,921 2.86 134.44
msgs sent queued on ksxp 87,458 8.09 380.25
number of ges deadlock detected 0 0.00 0.00
process batch messages received 4,666 0.43 20.29
process batch messages sent 59,598 5.51 259.12


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 826
CURRENT Block Requests 110
Data Block Requests 826
Undo Block Requests 1
TX Block Requests 16
Current Results 934
Private results 1
Zero Results 1
Disk Read Results 0
Fail Results 0
Fairness Down Converts 155
Fairness Clears 0
Free GC Elements 0
Flushes 13
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 2
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 885 100.00 0.00 0.00 0.00 0.00
Flushes 9 77.78 11.11 11.11 0.00 0.00
Writes 223 74.44 18.39 4.48 1.79 0.90


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 388 99.74 0.26 0.00 391,252 99.99 0.00 0.01
2 Others 80 98.75 1.25 0.00 87 100.00 0.00 0.00
2 undo header 17 82.35 17.65 0.00 1 100.00 0.00 0.00


Back to Top

End of Report