WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
QUERYDB1813880573querydb1108-Feb-14 14:0211.2.0.3.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
expquery01HP-UX IA (64-bit) 16 16 4 127.83

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:480327-Feb-14 08:00:1852 1.1
End Snap:480427-Feb-14 09:00:3353 1.1
Elapsed:  60.24 (mins)  
DB Time:  2.36 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 40,960M 40,960MStd Block Size: 8K
Shared Pool Size: 4,096M 4,096MLog Buffer: 44,656K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.0 10.9 0.05 0.02
DB CPU(s): 0.0 11.6 0.05 0.02
Redo size: 612.3 170,261.5  
Logical reads: 13.6 3,772.3  
Block changes: 1.0 279.3  
Physical reads: 0.0 7.0  
Physical writes: 0.2 49.7  
User calls: 2.1 582.4  
Parses: 0.1 30.9  
Hard parses: 0.0 0.1  
W/A MB processed: 0.0 2.7  
Logons: 0.7 191.9  
Executes: 0.8 213.5  
Rollbacks: 0.0 0.0  
Transactions: 0.0   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.81In-memory Sort %: 100.00
Library Hit %: 99.93Soft Parse %: 99.75
Execute to Parse %: 85.55Latch Hit %: 99.90
Parse CPU to Parse Elapsd %: 100.00% Non-Parse CPU: 99.97

Shared Pool Statistics

BeginEnd
Memory Usage %: 93.82 93.83
% SQL with executions>1: 98.86 98.87
% Memory for SQL w/exec>1: 90.23 90.23

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 151 106.64 
IPC send completion sync144000.02Other
PX Deq: Slave Session Stats42000.01Other
DFS lock handle18010.01Other
enq: PS - contention36000.01Other

Host CPU (CPUs: 16 Cores: 16 Sockets: 4)

Load Average BeginLoad Average End%User%System%WIO%Idle
0.01 0.02 0.9 0.6 0.9 98.5
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.7 45.4 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 130,900.6 130,900.6
SGA use (MB): 47,149.7 47,149.7
PGA use (MB): 349.3 350.4
% Host Mem used for SGA+PGA: 36.29 36.29

RAC Statistics

BeginEnd
Number of Instances: 3 3

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 0.17 46.92
Global Cache blocks served: 1.98 549.77
GCS/GES messages received: 732.47 203,664.62
GCS/GES messages sent: 564.10 156,849.08
DBWR Fusion writes: 0.03 8.08
Estd Interconnect traffic (KB) 270.40 

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

Buffer access - local cache %: 98.57
Buffer access - remote cache %: 1.24
Buffer access - disk %: 0.19

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

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


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
lan901:801169.254.254.172N    

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU151.21106.64
connection management call elapsed time2.721.92
sql execute elapsed time0.080.05
parse time elapsed0.010.01
repeated bind elapsed time0.000.00
DB time141.80 
background elapsed time341.82 
background cpu time254.51 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME5,414 
AVG_IDLE_TIME355,531 
AVG_IOWAIT_TIME3,248 
AVG_SYS_TIME2,157 
AVG_USER_TIME3,094 
BUSY_TIME89,339 
IDLE_TIME5,691,194 
IOWAIT_TIME54,446 
SYS_TIME37,222 
USER_TIME52,117 
LOAD00
OS_CPU_WAIT_TIME58,728,615,700 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES4,788,224 
PHYSICAL_MEMORY_BYTES137,259,204,608 
NUM_CPUS16 
NUM_CPU_CORES16 
NUM_CPU_SOCKETS4 
TCP_RECEIVE_SIZE_DEFAULT32,768 
TCP_RECEIVE_SIZE_MAX1,073,725,440 
TCP_RECEIVE_SIZE_MIN24,576 
TCP_SEND_SIZE_DEFAULT32,768 
TCP_SEND_SIZE_MAX2,147,483,647 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
27-Feb 08:00:180.01     
27-Feb 09:00:330.021.550.900.6498.450.94

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  151 106.64
Other63957000.05
Concurrency4212000.01
Network2,4360000.00
Cluster70000.00
User I/O30010.00
Commit10000.00
Application0 0 0.00
System I/O0 0 0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
IPC send completion sync14400011.080.02
PX Deq: Slave Session Stats420003.230.01
DFS lock handle1811011.380.01
enq: PS - contention360002.770.01
library cache pin240001.850.00
library cache lock1631001.230.00
SQL*Net message to client2,436000187.380.00
PX Deq: reap credit3601000027.690.00
Disk file operations I/O30010.230.00
row cache lock20010.150.00
gc current block 2-way30000.230.00
gc cr block 2-way40000.310.00
jobq slave wait24010012251018.46 
SQL*Net message from client2,4350114187.31 
PX Deq: Execution Msg168032012.92 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
ges lms sync during dynamic remastering and reconfig7278223065.546.45
reliable message5741152744.154.50
control file sequential read10,628020817.540.52
os thread startup1801821.380.43
enq: CO - master slave det1,2001001192.310.20
db file sequential read33100125.460.13
CSS operation: data query28500221.920.13
ASM file metadata operation87200067.080.11
enq: WF - contention1800131.380.07
row cache process12,571000967.000.07
CGS wait for IPC msg29,372100002,259.380.05
row cache lock38800029.850.05
DFS lock handle357910027.460.03
gc current block 2-way28800022.150.02
ksxr poll remote instances7,15710000550.540.02
ADR block file read160031.230.01
CSS group membership query570014.380.01
db file single write23900018.380.01
gc current block 3-way1090008.380.01
gc cr block 3-way1020007.850.01
row cache cleanup11,014000847.230.01
enq: TT - contention237950018.230.01
log file sequential read140021.080.01
control file parallel write1,27900098.380.01
ADR block file write50060.380.01
gc cr block 2-way880006.770.01
gc current block busy180011.380.01
latch: ges resource hash list1,591000122.380.01
gc current grant busy580004.460.01
library cache pin640004.920.01
enq: PS - contention3633002.770.01
PX Deq: reap credit1,77810000136.770.01
gcs log flush sync400003.080.00
ges2 LMON to wake up LMD - mrcvr100010.770.00
gc current grant 2-way880006.770.00
gc cr block busy70010.540.00
Disk file operations I/O1,462000112.460.00
libcache interrupt action by LCK10,341000795.460.00
asynch descriptor resize2,45110000188.540.00
enq: TA - contention120010.920.00
log file parallel write19500015.000.00
enq: CF - contention875010.620.00
SQL*Net message to client4,869000374.540.00
library cache lock1656001.230.00
PX Deq: Slave Session Stats300002.310.00
IPC send completion sync250001.920.00
enq: TD - KTF dump entries90000.690.00
enq: TM - contention683000.460.00
latch free920007.080.00
rdbms ipc message101,3645786,4618537,797.23 
wait for unread message on broadcast channel7,1861007,2291006552.77 
DIAG idle wait113,426347,153638,725.08 
gcs remote message2,538,46897,1153195,266.77 
dispatcher timer611003,661600204.69 
shared server idle wait1211003,632300209.31 
Streams AQ: qmn slave idle wait12703,628285709.77 
Streams AQ: qmn coordinator idle wait168753,6282159812.92 
PING1,096263,624330684.31 
ASM background timer70403,615513554.15 
Space Manager: slave idle wait726983,613497755.85 
smon timer17653,6132125221.31 
PX Idle Wait4203,613860213.23 
pmon timer1,2011003,612300892.38 
GCR sleep7211003,612500955.46 
ges remote message66,208443,611555,092.92 
class slave wait8101,506185906.23 
SQL*Net message from client7,3020122561.69 
KSV master wait2,2089800169.85 
PX Deq: Join ACK300012.31 
PX Deq: Parse Reply300002.31 
PX Deq: Execute Reply300002.31 
Streams AQ: RAC qmn coordinator idle wait2551000019.62 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read1631.36.331.331.3    
ADR block file write5   100.0    
ADR file lock6100.0       
ARCH wait for archivelog lock1100.0       
ASM file metadata operation87298.3.8.2.2 .1.3 
CGS wait for IPC msg29.4K100.0 .0     
CSS group membership query5778.921.1      
CSS operation: data query285 99.6.4     
CSS operation: query57100.0       
DFS lock handle37599.5.3.3     
Disk file operations I/O146599.9.1      
IPC send completion sync16999.4.6      
KJC: Wait for msg sends to complete3100.0       
LGWR wait for redo copy11100.0       
Log archive I/O1100.0       
PX Deq: Signal ACK EXT30100.0       
PX Deq: Signal ACK RSG30100.0       
PX Deq: Slave Session Stats7297.22.8      
PX Deq: reap credit2137100.0       
SQL*Net message to client7304100.0       
asynch descriptor resize2451100.0       
control file parallel write1279100.0       
control file sequential read10.6K99.8.1.0.1    
db file async I/O submit421100.0       
db file sequential read32976.02.110.011.2.6   
db file single write239100.0       
enq: AE - lock2100.0       
enq: CF - contention887.5 12.5     
enq: CO - master slave det120197.11.21.2.2.1 .2 
enq: DR - contention2100.0       
enq: FB - contention1100.0       
enq: JS - job run lock - synchronize2100.0       
enq: MW - contention2100.0       
enq: PS - contention7295.84.2      
enq: TA - contention1291.7 8.3     
enq: TD - KTF dump entries9100.0       
enq: TM - contention6100.0       
enq: TT - contention237100.0       
enq: WF - contention1877.811.1   5.65.6 
enq: WL - contention1100.0       
gc buffer busy release1100.0       
gc cr block 2-way96100.0       
gc cr block 3-way9999.0  1.0    
gc cr block busy862.525.012.5     
gc cr grant 2-way4100.0       
gc current block 2-way29099.3.7      
gc current block 3-way10099.0 1.0     
gc current block busy955.633.311.1     
gc current grant 2-way8598.8   1.2   
gc current grant busy51100.0       
gc current multi block request1100.0       
gc object scan8100.0       
gcs log flush sync3290.69.4      
ges lms sync during dynamic remastering and reconfig72   20.81.411.166.7 
ges2 LMON to wake up LMD - mrcvr1060.020.010.010.0    
kfk: async disk IO3100.0       
ksxr poll remote instances7161100.0       
latch free92100.0       
latch: cache buffers chains1100.0       
latch: ges resource hash list1626100.0       
latch: object queue header operation1100.0       
libcache interrupt action by LCK10.3K100.0       
library cache lock3293.83.13.1     
library cache pin8898.9 1.1     
log file parallel write18699.5 .5     
log file sequential read1478.6  7.114.3   
log file single write4100.0       
log file sync2100.0       
os thread startup18      100.0 
reliable message57487.56.8.9.2  4.7 
row cache cleanup11K100.0       
row cache lock39097.41.31.0.3    
row cache process12.6K99.8.2.0     
ASM background timer7042.8.4.3.7.1 .994.7
DIAG idle wait113.6K65.0.1.1.1.33.431.0 
GCR sleep721       100.0
KSV master wait220899.5.2.1.0 .0.1 
PING109373.6.2.3.2   25.8
PX Deq: Execute Reply30100.0       
PX Deq: Execution Msg16880.410.71.85.4  1.2.6
PX Deq: Join ACK3063.313.320.03.3    
PX Deq: Parse Reply3096.73.3      
PX Idle Wait42      26.273.8
SQL*Net message from client973636.124.929.26.32.8.8  
Space Manager: slave idle wait726       100.0
Streams AQ: RAC qmn coordinator idle wait255100.0       
Streams AQ: qmn coordinator idle wait16825.0      75.0
Streams AQ: qmn slave idle wait127.8      99.2
class slave wait8151.93.73.72.513.62.53.718.5
dispatcher timer61       100.0
gcs remote message2538.9K49.218.815.26.86.23.8.0 
ges remote message66.2K37.42.92.41.71.52.351.7 
jobq slave wait240      100.0 
pmon timer1200       100.0
rdbms ipc message101.4K28.42.53.23.8.3.442.518.9
shared server idle wait121       100.0
smon timer17       100.0
wait for unread message on broadcast channel7186      100.0 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ASM file metadata operation399.7 .3     
enq: CO - master slave det299.8.1.1     
enq: WF - contention194.4  5.6    
ges lms sync during dynamic remastering and reconfig4833.3   33.333.3  
os thread startup18  100.0     
reliable message2795.3.9.3.3.52.6  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
querydb14115100
SYS$USERS0000
SYS$BACKGROUND00049
querydbXDB0000

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
querydb 00800024320
SYS$USERS 303400040
SYS$BACKGROUND 203211082820000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
3.8660.642.720.260.00axfcq597829h6 MMON_SLAVE select tablespace_id, rfno, al...
0.3010.300.2190.494.7384qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.217210.000.1551.420.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
0.1810.180.13101.280.007qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
0.1710.170.1224.130.001cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
0.1310.130.0985.718.9084k66tf2s7y1c   insert into wrh$_bg_event_summ...
0.1210.120.0989.334.604dy1xm4nxc0gf   insert into wrh$_system_event ...
0.1210.120.0867.482.986ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.1110.110.0817.7874.26fnk7155mk2jq6   insert into wrh$_sysmetric_his...
0.0910.090.0721.5069.855ax5xu96u2ztd   insert into WRH$_EVENT_HISTOGR...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0.2710.270.180.3090.494.7384qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.1810.180.120.18101.280.007qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
0.1110.110.070.1289.334.604dy1xm4nxc0gf   insert into wrh$_system_event ...
0.117210.000.070.2151.420.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
0.1110.110.070.1385.718.9084k66tf2s7y1c   insert into wrh$_bg_event_summ...
0.08100.010.050.07108.480.004tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
0.0810.080.050.1267.482.986ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.0710.070.050.07101.960.0066gs90fyynks7   insert into wrh$_instance_reco...
0.0610.060.040.06105.470.005dfmd823r8dsp   insert into wrh$_memory_resize...
0.063960.000.040.05119.360.00csnp95dz2r8ss   select file#, block# from recy...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0.0810.0816.050.1117.7874.26fnk7155mk2jq6   insert into wrh$_sysmetric_his...
0.0610.0612.480.0921.5069.855ax5xu96u2ztd   insert into WRH$_EVENT_HISTOGR...
0.0310.035.290.0853.2836.64586b2udq6dbng   insert into wrh$_sysstat (snap...
0.0320.015.090.0333.8789.75c0agatqzq2jzr   insert into "SYS"."ALERT_QT" (...
0.0110.012.710.3090.494.7384qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.0110.012.410.0474.2431.057g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
0.0110.012.190.1385.718.9084k66tf2s7y1c   insert into wrh$_bg_event_summ...
0.0110.012.100.0360.2232.91f0s0bk5k713yb   insert into wrh$_parameter (sn...
0.0110.012.000.0241.4343.03cp3gpd7z878w8   insert into wrh$_sgastat (snap...
0.0110.011.090.1289.334.604dy1xm4nxc0gf   insert into wrh$_system_event ...
0.0110.011.020.0682.908.827ydcybv1szhrj   INSERT /*+ LEADING(@"SEL$F5BB7...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
16,733116,733.0034.120.18101.307qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
6,73239617.0013.730.0647.406xvp6nxs4a9n4   select nvl(sum(space), 0) from...
6,73239617.0013.730.05119.40csnp95dz2r8ss   select file#, block# from recy...
3,53010353.007.200.07108.504tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
2,23812,238.004.560.1267.536ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
1,4427212.002.940.2151.405ms6rbzdnq16t   select job, nvl2(last_date, 1,...
1,29111,291.002.630.0293.506wm3n4d7bnddg   SELECT source, (case when tim...
561787.191.140.0242.48.43s58mgk0uy2ws   insert into wrm$_snapshot_deta...
4591459.000.940.1117.874.3fnk7155mk2jq6   insert into wrh$_sysmetric_his...
420670.000.860.0543.30a1xgxtssv5rrp MMON_SLAVE select sum(used_blocks), ts.ts...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
20120.0021.980.1117.7874.26fnk7155mk2jq6   insert into wrh$_sysmetric_his...
17117.0018.680.0921.5069.855ax5xu96u2ztd   insert into WRH$_EVENT_HISTOGR...
818.008.790.0853.2836.64586b2udq6dbng   insert into wrh$_sysstat (snap...
623.006.590.0333.8789.75c0agatqzq2jzr   insert into "SYS"."ALERT_QT" (...
515.005.490.3090.494.7384qubbrsr0kfn   insert into wrh$_latch (snap_i...
313.003.300.1385.718.9084k66tf2s7y1c   insert into wrh$_bg_event_summ...
313.003.300.0360.2232.91f0s0bk5k713yb   insert into wrh$_parameter (sn...
212.002.200.1289.334.604dy1xm4nxc0gf   insert into wrh$_system_event ...
212.002.200.0474.2431.057g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
212.002.200.0241.4343.03cp3gpd7z878w8   insert into wrh$_sgastat (snap...
1780.011.100.0242.448.423s58mgk0uy2ws   insert into wrm$_snapshot_deta...
111.001.100.1267.482.986ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
111.001.100.0182.9922.507tdugauk22j8t   insert into WRH$_IOSTAT_DETAIL...
111.001.100.0682.908.827ydcybv1szhrj   INSERT /*+ LEADING(@"SEL$F5BB7...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
2020210.000.0021.989dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2020120.000.0021.98fnk7155mk2jq6   insert into wrh$_sysmetric_his...
1717117.000.0018.685ax5xu96u2ztd   insert into WRH$_EVENT_HISTOGR...
8818.000.008.79586b2udq6dbng   insert into wrh$_sysstat (snap...
6623.000.006.59c0agatqzq2jzr   insert into "SYS"."ALERT_QT" (...
3313.000.003.3084k66tf2s7y1c   insert into wrh$_bg_event_summ...
3313.000.003.30f0s0bk5k713yb   insert into wrh$_parameter (sn...
2212.000.002.204dy1xm4nxc0gf   insert into wrh$_system_event ...
2212.000.002.207g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
11780.010.001.103s58mgk0uy2ws   insert into wrm$_snapshot_deta...
1111.000.001.106ajkhukk78nsr   begin prvt_hdm.auto_execute( :...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
72100.000.2151.405ms6rbzdnq16t   select job, nvl2(last_date, 1,...
3963961.000.0647.406xvp6nxs4a9n4   select nvl(sum(space), 0) from...
39600.000.05119.40csnp95dz2r8ss   select file#, block# from recy...
38500.000.02109.80c4nhd1ntptxq7   select message_level, sequence...
8500.000.01302.60350f5yrnnmshs   lock table sys.mon_mods$ in ex...
85851.000.0240.30g00cj285jmgsw   update sys.mon_mods$ set inser...
78781.000.0242.48.43s58mgk0uy2ws   insert into wrm$_snapshot_deta...
60601.000.01141.403rrrnq9axk0dz   select count(*) from SYS.AQ$_S...
36361.000.0178.70crwtm662ycm4w   select count(*) from sys.job$ ...
20201.000.0000bsa0wjtftg3uw   select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
858521.20350f5yrnnmshs   lock table sys.mon_mods$ in ex...
2465.99a1xgxtssv5rrp MMON_SLAVE select sum(used_blocks), ts.ts...
1864.49axfcq597829h6 MMON_SLAVE select tablespace_id, rfno, al...
7201.75bsa0wjtftg3uw   select file# from file$ where ...
73851.75c4nhd1ntptxq7   select message_level, sequence...
601.506mvfay19q3v4n   SELECT COUNT(CLIENT_INFO) FROM...
63961.506xvp6nxs4a9n4   select nvl(sum(space), 0) from...
63961.50csnp95dz2r8ss   select file#, block# from recy...
601.50dqbhc9r7gz0a5   SELECT DECODE(COUNT(CLIENT_INF...
4851.00g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
6,855,21820.169dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
3,609,088100.08bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
3,084,33010.076wm3n4d7bnddg   SELECT source, (case when tim...
2,889,64010.07317v5hnvvd49h   UPDATE wrh$_seg_stat_obj ob S...
2,757,19920.0669k5bhm12sz98   SELECT dbin.instance_number, d...
1,928,82240.04fsbqktj5vw6n9   select next_run_date, obj#, ru...
1,798,24510.043qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
1,726,42510.042a99kfa1dykuy   update wrh$_seg_stat_obj sso s...
1,480,38110.031cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
1,361,94110.039n8xc314xdm0t   insert into wrh$_shared_server...
1,353,20510.032zd224kurqsr9   SELECT XMLTYPE(I.DATA) AS DATA...
1,244,35620.0389sdz401dc5uf   select program_oid, schedule_e...
1,155,46820.033c1kubcdjnppq   update sys.col_usage$ set equa...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
55269k5bhm12sz98   SELECT dbin.instance_number, d...
491c8gnrhxma4tas   SELECT owner#, property FROM s...
451gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
401b2gnxm5z6r51n   lock table sys.col_usage$ in e...
3913qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
3785350f5yrnnmshs   lock table sys.mon_mods$ in ex...
3785g00cj285jmgsw   update sys.mon_mods$ set inser...
367215ms6rbzdnq16t   select job, nvl2(last_date, 1,...
3615s34t44u10q4g   SELECT a.name task_name, nvl(e...
3423c1kubcdjnppq   update sys.col_usage$ set equa...
3236crwtm662ycm4w   select count(*) from sys.job$ ...
3120shksdzxpp4bh   select snap_interval, retentio...
3157gzxf61vj6wq4   SELECT ID FROM SYS.WRI$_ADV_TA...
314fsbqktj5vw6n9   select next_run_date, obj#, ru...
3020cjngzmtm4yv1   select reason_id, object_id, s...
29289sdz401dc5uf   select program_oid, schedule_e...
2812a99kfa1dykuy   update wrh$_seg_stat_obj sso s...
2810bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
27119rkm1wsf9axx   insert into WRI$_ALERT_HISTORY...
27142cfrr6x5t75c   SELECT MAX(DB_NAME), MAX(VERSI...
2747uhu8c5c39y9w   SELECT NVL(E.STATUS, A.STATUS)...
271aktbxfjwnzgmu   update WRM$_DATABASE_INSTANCE ...
2616wm3n4d7bnddg   SELECT source, (case when tim...
2629dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2629dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2512zd224kurqsr9   SELECT XMLTYPE(I.DATA) AS DATA...
246g4vrdfn14tp29   SELECT PROPERTY FROM SYS.WRI$_...
221317v5hnvvd49h   UPDATE wrh$_seg_stat_obj ob S...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO SQL IdSQL ModuleSQL Text
0.0472117.590.2120.2151.420.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
0.02109.750.0732.51108.480.004tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
0.02107.670.0362.1932.980.00dma0vxbwh325p   update smon_scn_time set time_...
0.0217.640.1215.8467.482.986ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.0216.850.305.6490.494.7384qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.01783.080.0232.1742.448.423s58mgk0uy2ws   insert into wrm$_snapshot_deta...
0.0112.990.097.9021.5069.855ax5xu96u2ztd   insert into WRH$_EVENT_HISTOGR...
0.01852.570.0225.5040.300.00g00cj285jmgsw   update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0cjngzmtm4yv1select reason_id, object_id, subobject_id, internal_instance_number, time_suggested, context, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, sequence_id, metric_value, instance_name from wri$_alert_outstanding where internal_instance_number > -2
0shksdzxpp4bhselect snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid
19rkm1wsf9axxinsert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
2a99kfa1dykuyupdate wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (ts#, obj#, dataobj#) in (select tsn_kewrseg, objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
2zd224kurqsr9SELECT XMLTYPE(I.DATA) AS DATA, D.DIRECTIVE_NAME FROM DBA_ADVISOR_DIR_TASK_INST I, DBA_ADVISOR_DIR_DEFINITIONS D WHERE I.TASK_ID = :B1 AND I.DIRECTIVE_ID = D.ID AND D.ADVISOR_NAME = 'ADDM'
317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
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
3qsmy8ybvwt3ninsert into WRI$_ALERT_OUTSTANDING (reason_id, object_id, subobject_id, internal_instance_number, owner, object_name, subobject_name, sequence_id, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, context, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32)
3rrrnq9axk0dzselect count(*) from SYS.AQ$_SYS$SERVICE_METRICS_TAB_S where name = :1
3s58mgk0uy2wsinsert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
42cfrr6x5t75cSELECT MAX(DB_NAME), MAX(VERSION) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME = (SELECT MAX(STARTUP_TIME) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME <= :B2 )
4dy1xm4nxc0gfinsert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4tg8mr2bvy6grselect smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
586b2udq6dbnginsert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5ax5xu96u2ztdinsert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5dfmd823r8dspinsert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5ms6rbzdnq16tselect 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
5s34t44u10q4gSELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
66gs90fyynks7 insert 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
69k5bhm12sz98 SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_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 = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6mvfay19q3v4nSELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7g732rx16j8jcinsert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7gzxf61vj6wq4SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
7tdugauk22j8t insert into WRH$_IOSTAT_DETAIL (snap_id, dbid, instance_number, function_id, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, large_read_reqs, large_write_reqs, number_of_waits, wait_time) (select :snap_id, :dbid, :instance_number, function_id, filetype_id, nvl(sum(small_read_megabytes), 0) small_read_megabytes, nvl(sum(small_write_megabytes), 0) small_write_megabytes, nvl(sum(large_read_megabytes), 0) large_read_megabytes, nvl(sum(large_write_megabytes), 0) large_write_megabytes, nvl(sum(small_read_reqs), 0) small_read_reqs, nvl(sum(small_write_reqs), 0) small_write_reqs, nvl(sum(large_read_reqs), 0) large_read_reqs, nvl(sum(large_write_reqs), 0) large_write_reqs, nvl(sum(number_of_waits), 0) number_of_waits, nvl(sum(wait_time), 0) wait_time from v$iostat_function_detail group by function_id, filetype_id having sum(small_read_megabytes + small_write_megabytes + large_read_megabytes + large_write_megabytes + small_read_reqs + small_write_reqs + large_read_reqs + large_write_reqs) > 0 )
7uhu8c5c39y9wSELECT NVL(E.STATUS, A.STATUS) STATUS#, A.PROPERTY FROM WRI$_ADV_TASKS A, WRI$_ADV_EXECUTIONS E WHERE A.ID = E.TASK_ID(+) AND A.ADVISOR_ID = E.ADVISOR_ID(+) AND A.LAST_EXEC_NAME = E.NAME(+) AND A.ID = :B1
7ydcybv1szhrj 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#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_ serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_wr ite_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) 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 (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
84k66tf2s7y1cinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
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
89sdz401dc5ufselect program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1
9dhn1b8d88dpf 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, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), 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, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.nex t_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null 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))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) 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 <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, 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 <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), 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.owner# = 0 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, 4, 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 j.owner# = 0 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 and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9n8xc314xdm0t insert into wrh$_shared_server_summary (snap_id, dbid, instance_number, num_samples, sample_time, sampled_total_conn, sampled_active_conn, sampled_total_srv, sampled_active_srv, sampled_total_disp, sampled_active_disp, srv_busy, srv_idle, srv_in_net, srv_out_net, srv_messages, srv_bytes, cq_wait, cq_totalq, dq_totalq) select :snap_id, :dbid, :instance_number, a.kmmsasnum, a.kmmsastime, a.kmmsastvc, a.kmmsasavc, a.kmmsastsrv, a.kmmsasasrv, a.kmmsastdisp, a.kmmsasadisp, s.busy, s.idle, s.in_net, s.out_net, s.messages, s.bytes, cq.wait, cq.totalq, dq.totalq from x$kmmsas a, (select sum(wait) as wait, sum(totalq) as totalq from v$queue where type = 'COMMON') cq, (select sum(busy) as busy, sum(idle) as idle, sum(in_net) as in_net, sum(out_net) as out_net, sum(messages) as messages, sum(bytes) as bytes from (select sum(busy) as busy, sum(idle) as idle, sum(in_net) as in_net, sum(out_net) as out_net, sum(messages) as messages, sum(bytes) as b ytes from v$shared_server union select kmmhstsbsy, kmmhstsidl, kmmhstsneti, kmmhstsneto, kmmhstsnmg, kmmhstsnmb from x$kmmhst)) s, (select sum(totalq) as totalq from (select sum(totalq) as totalq from v$queue where type = 'DISPATCHER' union select kmmhstdqtnc from x$kmmhst)) dq
a1xgxtssv5rrpselect sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
aktbxfjwnzgmuupdate WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
axfcq597829h6select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b))
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), 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, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a .flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c0agatqzq2jzrinsert into "SYS"."ALERT_QT" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
c8gnrhxma4tasSELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
cp3gpd7z878w8insert into wrh$_sgastat (snap_id, dbid, instance_number, pool, name, bytes) select :snap_id, :dbid, :instance_number, pool, name, bytes from (select pool, name, bytes, 100*(bytes) / (sum(bytes) over (partition by pool)) part_pct from v$sgastat) where part_pct >= 1 or pool is null or name = 'free memory' order by name, pool
crwtm662ycm4wselect count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
dma0vxbwh325pupdate smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn = (select min(scn) from smon_scn_time)
dqbhc9r7gz0a5SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1
f0s0bk5k713ybinsert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash
fnk7155mk2jq6insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ( (bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
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
g4vrdfn14tp29SELECT PROPERTY FROM SYS.WRI$_ADV_TASKS WHERE ID = :B1
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced240.011.85
CCursor + sql area evicted00.000.00
CPU used by this session23,4106.481,800.77
CPU used when call started1,8250.50140.38
CR blocks created10.000.08
Cached Commit SCN referenced00.000.00
Commit SCN cached60.000.46
DB time12,5223.46963.23
DBWR checkpoint buffers written5520.1542.46
DBWR checkpoints10.000.08
DBWR fusion writes1050.038.08
DBWR object drop buffers written00.000.00
DBWR transaction table writes300.012.31
DBWR undo block writes1990.0615.31
DFO trees parallelized120.000.92
HSC Heap Segment Block Changes4290.1233.00
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts1340.0410.31
Heap Segment Array Updates00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd240.011.85
PX local messages sent240.011.85
PX remote messages recv'd1200.039.23
PX remote messages sent1200.039.23
Parallel operations not downgraded120.000.92
Requests to/from client30.000.23
RowCR attempts00.000.00
RowCR hits00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client2,4350.67187.31
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created60.000.46
TBS Extension: tasks executed60.000.46
active txn count during cleanout2170.0616.69
application wait time00.000.00
background checkpoints completed10.000.08
background checkpoints started10.000.08
background timeouts25,7427.121,980.15
branch node splits00.000.00
buffer is not pinned count3,6501.01280.77
buffer is pinned count7,2802.01560.00
bytes received via SQL*Net from client1,1330.3187.15
bytes sent via SQL*Net to client624,890172.8748,068.46
calls to get snapshot scn: kcmgss2,8060.78215.85
calls to kcmgas2,0630.57158.69
calls to kcmgcs3,0840.85237.23
cell physical IO interconnect bytes237,086,72065,589.7118,237,440.00
change write time50.000.38
cleanout - number of ktugct calls1780.0513.69
cleanouts and rollbacks - consistent read gets10.000.08
cleanouts only - consistent read gets40.000.31
cluster key scan block gets2410.0718.54
cluster key scans2410.0718.54
cluster wait time250.011.92
commit batch/immediate performed00.000.00
commit batch/immediate requested00.000.00
commit cleanout failures: block lost130.001.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure100.000.77
commit cleanout failures: cannot pin00.000.00
commit cleanouts6560.1850.46
commit cleanouts successfully completed6330.1848.69
commit immediate performed00.000.00
commit immediate requested00.000.00
commit txn count during cleanout790.026.08
concurrency wait time1710.0513.15
consistent changes160.001.23
consistent gets43,83412.133,371.85
consistent gets - examination2,4970.69192.08
consistent gets direct00.000.00
consistent gets from cache43,83412.133,371.85
cursor authentications30.000.23
data blocks consistent reads - undo records applied20.000.15
db block changes3,6311.00279.31
db block gets5,2061.44400.46
db block gets direct00.000.00
db block gets from cache5,2061.44400.46
deferred (CURRENT) block cleanout applications2670.0720.54
dirty buffers inspected00.000.00
enqueue conversions7960.2261.23
enqueue releases40,90811.323,146.77
enqueue requests42,11011.653,239.23
enqueue timeouts1,2010.3392.38
enqueue waits1,5730.44121.00
exchange deadlocks00.000.00
execute count2,7760.77213.54
failed probes on index block reclamation00.000.00
file io service time12,8593.56989.15
file io wait time493,715136.5937,978.08
free buffer inspected5330.1541.00
free buffer requested7840.2260.31
gc blocks compressed2,9190.81224.54
gc blocks lost00.000.00
gc cr block flush time00.000.00
gc cr block receive time70.000.54
gc cr blocks received2010.0615.46
gc cr blocks served4110.1131.62
gc current block flush time10.000.08
gc current block pin time00.000.00
gc current block receive time110.000.85
gc current blocks received4090.1131.46
gc current blocks served6,7361.86518.15
gc kbytes saved9,5982.66738.31
gc kbytes sent47,57913.163,659.92
gc local grants840.026.46
gc read wait time00.000.00
gc read wait timeouts00.000.00
gc read waits00.000.00
gc reader bypass grants250.011.92
gc remote grants1580.0412.15
gcs messages sent1,995,961552.18153,535.46
ges messages sent43,07711.923,313.62
global enqueue get time1570.0412.08
global enqueue gets async4270.1232.85
global enqueue gets sync15,9264.411,225.08
global enqueue releases14,2633.951,097.15
heap block compress140.001.08
hot buffers moved to head of LRU20.000.15
immediate (CR) block cleanout applications50.000.38
immediate (CURRENT) block cleanout applications2110.0616.23
in call idle wait time14,214,7473,932.491,093,442.08
index crx upgrade (positioned)600.024.62
index crx upgrade (prefetch)00.000.00
index fast full scans (full)30.000.23
index fetch by key3,4960.97268.92
index scans kdiixs12,3890.66183.77
leaf node 90-10 splits10.000.08
leaf node splits580.024.46
lob reads00.000.00
lob writes10.000.08
lob writes unaligned10.000.08
logical read bytes from cache401,735,680111,139.6130,902,744.62
logons cumulative2,4950.69191.92
max cf enq hold time00.000.00
messages received1,9520.54150.15
messages sent1,9520.54150.15
min active SCN optimization applied on CR00.000.00
no work - consistent read gets37,96610.502,920.46
non-idle wait count144,63540.0111,125.77
non-idle wait time4,4411.23341.62
opened cursors cumulative4,3801.21336.92
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)10.000.08
parse count (total)4010.1130.85
parse time cpu50.000.38
parse time elapsed50.000.38
physical read IO requests910.037.00
physical read bytes745,472206.2357,344.00
physical read total IO requests10,9723.04844.00
physical read total bytes180,846,59250,030.9513,911,276.31
physical read total multi block requests50.000.38
physical reads910.037.00
physical reads cache910.037.00
physical reads cache prefetch00.000.00
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests4590.1335.31
physical write bytes5,292,0321,464.03407,079.38
physical write total IO requests3,6411.01280.08
physical write total bytes56,240,12815,558.754,326,163.69
physical write total multi block requests210.011.62
physical writes6460.1849.69
physical writes direct00.000.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache6460.1849.69
physical writes non checkpoint2640.0720.31
pinned buffers inspected00.000.00
pinned cursors current00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use7260.2055.85
process last non-idle time80,26122.206,173.92
queries parallelized120.000.92
recursive calls19,1255.291,471.15
recursive cpu usage2110.0616.23
redo KB read2,3020.64177.08
redo blocks checksummed by FG (exclusive)1,3980.39107.54
redo blocks written2,3040.64177.23
redo buffer allocation retries00.000.00
redo entries2,5850.72198.85
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks420.013.23
redo size2,213,400612.33170,261.54
redo size for direct writes00.000.00
redo subscn max counts1080.038.31
redo synch long waits00.000.00
redo synch time00.000.00
redo synch time (usec)5830.1644.85
redo synch writes50.000.38
redo wastage108,54430.038,349.54
redo write broadcast ack count30.000.23
redo write broadcast ack time2,7660.77212.77
redo write broadcast lgwr post count00.000.00
redo write time100.000.77
redo writes1890.0514.54
rollback changes - undo records applied00.000.00
rollbacks only - consistent read gets10.000.08
root node splits00.000.00
rows fetched via callback7250.2055.77
session connect time00.000.00
session cursor cache hits1,5660.43120.46
session logical reads49,04013.573,772.31
shared hash latch upgrades - no wait1930.0514.85
sorts (memory)9230.2671.00
sorts (rows)10,3482.86796.00
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer100.000.77
table fetch by rowid4,7081.30362.15
table fetch continued row00.000.00
table scan blocks gotten19,3215.351,486.23
table scan rows gotten952,496263.5173,268.92
table scans (long tables)00.000.00
table scans (short tables)1,7420.48134.00
temp space allocated (bytes)00.000.00
total cf enq hold time2580.0719.85
total number of cf enq holders170.001.31
total number of times SMON posted60.000.46
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks00.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size806,456223.1062,035.08
user I/O wait time500.013.85
user calls7,5712.09582.38
user commits130.001.00
user rollbacks00.000.00
workarea executions - onepass00.000.00
workarea executions - optimal2320.0617.85
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory6,298,299,365,9046,298,427,306,264
opened cursors current5859
logons current5253
session uga memory max390,837,656,872391,314,243,096
session pga memory5,840,181,6565,841,076,192
session pga memory max10,348,420,15210,349,249,152
session cursor cache count1,109,9431,110,213

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)11.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others171M3.00.04730644M0.77.01217213.6K0.01
DBWR0M0.000M6M0.13.0016594260.00
LGWR0M0.000M5M0.11.0013834150.05
Buffer Cache Reads1M0.03.0002760M0.000M913.53
TOTAL:172M3.04.04758355M1.01.01521514.6K0.03

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Control File168M2.94.04647640M0.71.0110650.012.50
Data File1M0.09.0002768M0.19.0022130.97 
Log File2M0.00.0005534M0.10.0011060.458.00
Archive Log0M0.000M2M0.00.000553  
TOTAL:171M3.04.04730654M1.01.0149390.045.80

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others 170M3.00.04703044M0.77.01217211.1K0.01
Others (Control File) 167M2.94.04620040M0.70.01106510.6K0.01
Others (Data File) 1M0.07.0002762M0.07.0005534780.00
Others (Archive Log) 0M0.000M2M0.00.0005530 
Others (Log File) 2M0.00.0005530M0.000M102.90
DBWR 0M0.000M6M0.13.00165950.00
DBWR (Data File) 0M0.000M6M0.13.0016590 
DBWR (Control File) 0M0.000M0M0.000M50.00
LGWR 0M0.000M4M0.11.001106210.00
LGWR (Log File) 0M0.000M4M0.10.00110680.00
LGWR (Control File) 0M0.000M0M0.010M130.00
Buffer Cache Reads 1M0.03.0002760M0.000M913.52
Buffer Cache Reads (Data File) 1M0.03.0002760M0.000M913.52
TOTAL: 171M3.04.04730654M1.01.01493911.2K0.04

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX 8704.601.00366000.00
UNDOTBS1 000.000.0077000.00
SYSTEM 000.000.0016000.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+DATA_DG/querydb/datafile/sysaux.261.822838405 8704.601.00366000.00
SYSTEM+DATA_DG/querydb/datafile/system.260.822838401 00  16000.00
UNDOTBS1+DATA_DG/querydb/datafile/undotbs1.262.822838407 00  77000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D4,839,04010049,05691646000

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00005520

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0036812465814246668581  0
E0033211658844246668884  0

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D4,0960.104841.14376,552145783.00
D8,1920.209681.08354,983142520.00
D12,2880.301,4521.07351,404141978.00
D16,3840.401,9361.06348,971141610.00
D20,4800.502,4201.05344,718140966.00
D24,5760.602,9031.03340,824140377.00
D28,6720.703,3871.03337,844139926.00
D32,7680.803,8711.02336,285139690.00
D36,8640.904,3551.01334,340139396.00
D40,9601.004,8391.00329,448138656.00
D45,0561.105,3230.99325,785138101.00
D49,1521.205,8070.98321,645137475.00
D53,2481.306,2910.97320,244137263.00
D57,3441.406,7750.97317,922136912.00
D61,4401.507,2590.96316,660136721.00
D65,5361.607,7420.96315,721136579.00
D69,6321.708,2260.95314,192136347.00
D73,7281.808,7100.95312,409136077.00
D77,8241.909,1940.95311,551135948.00
D81,9202.009,6780.94309,598135652.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00350

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)
B10,2408,952349.340.000.000.000.001,048,570
E10,2408,950350.370.000.000.000.001,048,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K19519500
64K128K101000
512K1024K161600
1M2M9900
4M8M2200

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 CountEstd Time
1,2800.13633,802.584.61100.0000
2,5600.25633,802.584.61100.0000
5,1200.50633,802.584.61100.0000
7,6800.75633,802.584.61100.0000
10,2401.00633,802.584.61100.0000
12,2881.20633,802.580.00100.0000
14,3361.40633,802.580.00100.0000
16,3841.60633,802.580.00100.0000
18,4321.80633,802.580.00100.0000
20,4802.00633,802.580.00100.0000
30,7203.00633,802.580.00100.0000
40,9604.00633,802.580.00100.0000
61,4406.00633,802.580.00100.0000
81,9208.00633,802.580.00100.0000

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)
4,0961.0048321,468135,3611.006,6901.0016,549
4,2241.0361126,908135,4981.006,5530.9816,562
4,3521.0673931,879135,5731.006,4780.9716,568
4,4801.0986736,828135,6341.006,4170.9616,575
4,6081.1399541,925135,6921.006,3590.9516,579
4,7361.161,12347,151135,7281.006,3230.9516,582
4,8641.191,25152,377135,7591.006,2920.9416,585
4,9921.221,37957,603135,7811.006,2700.9416,588
5,1201.251,50762,829135,8051.006,2460.9316,591
5,2481.281,63568,055135,8231.006,2280.9316,593
5,6321.382,01983,245135,8521.006,1990.9316,597
6,1441.502,531102,876135,8771.006,1740.9216,601
6,6561.633,043122,507135,8941.006,1570.9216,604
7,1681.753,555142,138135,9041.006,1470.9216,605
7,6801.884,067161,769135,9131.006,1380.9216,606
8,1922.004,579181,400135,9151.006,1360.9216,606

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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)
CO-KTUCLO Master Slave enq (master slave det) 1,20001,2001,20010.56
WF-AWR Flush 2121018012.83
TT-Tablespace 434434023700.23
PS-PX Process Reservation 13213207200.53
TA-Instance Undo 121201200.92
CF-Controlfile Transaction 7,3777,3770800.75
TD-KTF map table enqueue (KTF dump entries) 10100900.56
TM-DML 4944940600.67
DR-Distributed Recovery 220201.00
AE-Edition Lock (lock) 15150200.50
JS-Job Scheduler (job run lock - synchronize) 220200.50
MW-MWIN Schedule 220200.00
WL-Being Written Redo Log 110100.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
20.171971,099318.3/29.30/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
27-Feb 08:54071940180/00/0/0/0/0/0
27-Feb 08:44017990280/00/0/0/0/0/0
27-Feb 08:34074950190/00/0/0/0/0/0
27-Feb 08:247121,0993290/00/0/0/0/0/0
27-Feb 08:14024930190/00/0/0/0/0/0
27-Feb 08:041611681,0973290/00/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
AQ deq hash table latch10.00 00 
ASM Keyed state latch4,9010.00 00 
ASM allocation510.00 00 
ASM db client latch2,7510.00 00 
ASM map headers430.00 00 
ASM map load waiting list100.00 00 
ASM map operation freelist120.00 00 
ASM map operation hash table51,8780.00 00 
ASM network background latch1,4280.00 00 
ASM network state latch1010.00 00 
AWR Alerted Metric Element list36,2460.00 00 
Change Notification Hash table latch1,2000.00 00 
Consistent RBA1930.00 00 
DML lock allocation1,0120.00 00 
Event Group Locks4,9470.00 00 
FAL Queue980.00 00 
FIB s.o chain latch100.00 00 
FOB s.o list latch2,9180.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC other latch300.00 00 
IPC stats buffer allocation latch5,0530.00 05,0560.00
In memory undo latch10.00 00 
JS Sh mem access90.00 00 
JS broadcast add buf latch8340.00 00 
JS broadcast drop buf latch8340.00 00 
JS broadcast load blnc latch7240.00 00 
JS mem alloc latch40.00 00 
JS queue access latch50.00 00 
JS queue state obj latch26,3480.00 00 
JS slv state obj latch90.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch6660.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list6380.00 0480.00
KJCT flow control latch2,324,5540.00 00 
KMG MMAN ready and startup request latch1,2010.00 00 
KSXR large replies3630.00 00 
KTF sga latch320.00 09530.00
KWQMN job cache list latch2600.00 00 
KWQS pqsubs latch60.00 00 
KWQS pqueue ctx latch20.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch31,8610.00 00 
MQL Tracking Latch0  0710.00
Memory Management Latch10.00 01,2010.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch1,2800.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process9,8920.00 00 
OS process allocation11,8570.00 00 
OS process: request allocation4,9010.00 00 
PL/SQL warning settings2,4970.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch16,6200.00 00 
Reserved Space Latch40.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 01,2010.00
SQL memory manager workarea list latch80,6830.00 00 
Shared B-Tree1350.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP50.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch2,9260.00 00 
active service list18,1250.00 02,7070.00
alert log latch20.00 00 
archive control630.00 00 
archive process latch2950.00 00 
buffer pool10.00 00 
business card250.00 00 
cache buffer handles240.00 00 
cache buffers chains207,9040.001.000261,4800.00
cache buffers lru chain1,1280.00 014,1870.00
call allocation9,9070.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch4,9140.00 00 
channel operations parent latch653,0180.000.0000 
checkpoint queue latch549,9040.00 08270.00
client/application info2,7270.00 00 
compile environment latch2,4950.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch570.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch570.00 00 
dml lock allocation570.00 00 
done queue latch10.00 00 
dummy allocation4,9900.00 00 
enqueue freelist latch10.00 082,7110.00
enqueue hash chains89,7560.00 00 
enqueues10.00 00 
error message lists720.00 00 
fifth spare latch10.00 00 
file cache latch4,1980.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element27,8230.00 01980.00
gc persistent rm80.00 00 
gcs commit scn state10.00 00 
gcs opaque info freelist86,9940.000.0000 
gcs partitioned table hash41,075,0770.000.000440.00
gcs pcm hashed value bucket hash10.00 00 
gcs remaster request queue6610.00 00 
gcs remastering latch16,243,4830.480.0000 
gcs resource freelist280,1840.00 0260,9930.00
gcs resource hash19,675,0930.000.0000 
gcs resource scan list10.00 00 
gcs shadows freelist301,7290.00 0290,8340.00
ges caches resource lists25,1950.000.00081,5140.00
ges deadlock list2140.00 00 
ges domain table30,2290.00 00 
ges enqueue table freelist97,1890.00 00 
ges group table29,0680.00 00 
ges process hash list54,9430.00 00 
ges process parent latch137,4600.00 00 
ges process table freelist4,9010.00 00 
ges resource hash list298,8140.550.99015,5110.02
ges resource scan list210.00 00 
ges resource table freelist27,4170.00 00 
ges timeout list8780.00 02780.00
ges value block free list90.00 00 
global KZLD latch for mem in SGA20.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch100.00 050.00
hash table modification latch790.00 00 
heartbeat check10.00 01,0200.00
heartbeat structure management0  07210.00
interrupt manipulation3480.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch30.00 020.00
job_queue_processes free list latch40.00 00 
job_queue_processes parameter latch7910.00 00 
k2q global data latch2,4020.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch40.00 00 
ksfv messages10.00 00 
ksim group membership cache1970.00 00 
ksim membership request latch0  02,3100.00
kss move lock290.00 00 
ksuosstats global area3640.00 00 
ksv allocation latch1130.00 00 
ksv class latch6,8100.00 00 
ksv msg queue latch90.00 080.00
ksxp shared latch4,9010.00 00 
ksxp so latch4,9010.00 00 
ksz_so allocation latch4,9010.00 00 
ktm global data630.00 00 
kwqbsn:qsga1260.00 00 
lgwr LWN SCN1,3130.00 00 
list of block allocation310.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
managed standby latch970.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch8,6500.00 00 
messages208,1540.000.0000 
mostly latch-free SCN1,3160.080.0000 
msg queue latch10.00 00 
multiblock read objects920.00 00 
name-service memory objects40,9440.00 00 
name-service namespace bucket38,5020.00 00 
name-service pending queue2100.00 00 
name-service request queue66,5750.00 00 
ncodef allocation latch570.00 00 
object queue header heap23,6060.00 02670.00
object queue header operation99,5440.000.5000 
object stats modification70.00 00 
parallel query alloc buffer9970.00 00 
parallel query stats790.00 00 
parallel txn reco latch4,7520.00 00 
parameter list8,4490.00 00 
parameter table management5,0890.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue67,5420.00 067,4340.00
process allocation21,0790.000.0002,4510.00
process group creation4,9010.00 00 
process queue2410.00 00 
process queue reference4,3760.00 03900.00
qmn task queue latch51716.631.0000 
query server freelists1810.00 00 
query server process60.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation2,8280.00 02,6030.00
redo copy10.00 02,6030.85
redo writing6,0260.00 00 
reservation so alloc latch20.00 00 
resmgr group change latch560.00 00 
resmgr:active threads4,9900.00 00 
resmgr:actses change group590.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list4,9890.020.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects85,3330.000.0000 
rules engine aggregate statistics20.00 00 
rules engine rule set statistics40.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
segmented array pool100.00 00 
sequence cache7,3110.00 00 
session allocation7,5010.00 02,5400.00
session idle bit15,1880.00 00 
session queue latch10.00 00 
session state list latch1400.00 00 
session switching2,5080.00 00 
session timer1,2010.00 00 
shared pool147,5170.000.0000 
shared pool sim alloc10.00 00 
shared pool simulator80.00 00 
sim partition latch10.00 00 
simulator hash latch3,0920.00 00 
simulator lru latch10.00 03,0810.00
sort extent pool1340.00 00 
space background task latch3,8960.151.0002,4020.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch8540.00 00 
transaction allocation540.00 00 
undo global data2,9790.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
ges resource hash list298,8141,6371,62611
qmn task queue latch51786860
space background task latch3,896660
object queue header operation99,544211
cache buffers chains207,904110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
PC and Classifier lists for WLMNo latch060
cache buffers chainskclwrt010
ges resource hash listkjakcai: search for resp by resname01,5321
ges resource hash listkjlmfnd: search for lockp by rename and inst id0930
ges resource hash listkjrmas1: lookup master node010
object queue header operationkcbo_switch_mq_bg011
qmn task queue latchkwqmnmvtsks: delay to ready list0840
qmn task queue latchkwqmnaddtsk: add task020

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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
SYSSYSAUXWRH$_SEG_STAT_OBJ_PK INDEX16,52833.70
SYSSYSTEMRECYCLEBIN$ TABLE13,44027.41
SYSSYSAUXSMON_SCN_TIME TABLE3,5367.21
SYSSYSTEMTS$ TABLE1,9363.95
SYSSYSTEMJOB$ TABLE1,5043.07

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX1213.19
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1813880573_2878INDEX PARTITION1112.09
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE88.79
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1813880573_2878TABLE PARTITION55.49
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1813880573_4750TABLE PARTITION44.40

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX1213.19
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1813880573_2878INDEX PARTITION1112.09
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE88.79
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1813880573_2878TABLE PARTITION55.49
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1813880573_4750TABLE PARTITION44.40

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX1213.19
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1813880573_2878INDEX PARTITION1112.09
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE88.79
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1813880573_2878TABLE PARTITION55.49
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1813880573_4750TABLE PARTITION44.40

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_1813880573_4750INDEX PARTITION213.25
SYSSYSAUXWRH$_BG_EVENT_SUMMARY_PK INDEX172.63
SYSSYSAUXSMON_SCN_TIME TABLE152.32
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX152.32
SYSSYSTEMMON_MODS$ TABLE142.17

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSSYSAUXSMON_SCN_TIME TABLE153.27
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX153.27
SYSSYSTEMMON_MODS$ TABLE143.05
SYSSYSAUXSMON_SCN_TIME_SCN_IDX INDEX132.83
SYSSYSAUXSMON_SCN_TIME_TIM_IDX INDEX122.61

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX3100.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1813880573_2878INDEX PARTITION1609.71
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE1448.74
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX1287.77
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_1813880573_4750INDEX PARTITION965.83
SYSSYSTEMMON_MODS$ TABLE804.85

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
SYSSYSTEMJOB$ TABLE6733.33
SYSSYSAUXSMON_SCN_TIME TABLE3617.91
SYSSYSAUXSMON_SCN_TIME_SCN_IDX INDEX188.96
SYSSYSTEMI_MON_MODS$_OBJ INDEX21.00
SYSSYSTEMOBJ$ TABLE21.00

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SYSSYSTEMJOB$ TABLE6114.91
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_1813880573_4750INDEX PARTITION389.29
SYSSYSAUXSMON_SCN_TIME TABLE276.60
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX256.11
SYSSYSAUXSMON_SCN_TIME_SCN_IDX INDEX184.40

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_control643.130 01
dc_global_oids70.000 066
dc_histogram_data130.000 033,605
dc_histogram_defs20.000 053,964
dc_objects2,7140.520 08,113
dc_profiles20.000 01
dc_rollback_segments8,8320.000 0398
dc_segments100.000 022,605
dc_tablespaces1,7850.000 069
dc_users12,3650.000 0233
global database name3,1500.000 01
outstanding_alerts39098.720 266
sch_lj_oids40.000 030

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control220
dc_objects220
outstanding_alerts7713840

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS40.000 00
BODY160.00190.0000
DBLINK2,4370.000 00
EDITION130.00150.0000
QUEUE0 620.0000
RULESET0 20.0000
SCHEMA2,4330.000 00
SQL AREA3500.292,9730.1000
SQL AREA BUILD1100.000 00
SQL AREA STATS1100.001100.0000
TABLE/PROCEDURE2,4540.004,9290.0420

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS40000
BODY0171700
DBLINK2,4370000
EDITION13131300
QUEUE0626200
RULESET02200
SCHEMA2,4330000
TABLE/PROCEDURE314,9264,92600

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache40,960.0040,960.0040,960.0040,960.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target10,240.0010,240.0010,240.0010,240.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target0.000.000.000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool1,024.001,024.001,024.001,024.000STA/
large pool1,024.001,024.001,024.001,024.000STA/
shared pool4,096.004,096.004,096.004,096.000STA/
streams pool0.000.000.000.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to 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
BOther322.72 5.878.6341415555
Freeable25.630.001.281.969 2020
SQL0.760.300.030.04052318
PL/SQL0.280.180.010.01005352
EOther323.80 5.788.5841415656
Freeable25.560.001.352.009 1919
SQL0.780.310.030.04052419
PL/SQL0.280.180.010.01005453

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers42,949,672,960 
Fixed Size2,193,928 
Redo Buffers45,727,744 
Variable Size6,442,452,472 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory1,024.001,024.000.00
largefree memory1,023.631,023.630.00
sharedFileOpenBlock112.00112.000.00
sharedKGLH0210.65210.670.01
sharedKQR L PO75.7075.700.00
sharedSQLA407.53407.540.00
shareddb_block_hash_buckets356.00356.000.00
sharedfree memory253.02252.93-0.04
sharedgc name table96.0096.000.00
sharedgcs resources1,072.131,072.130.00
sharedgcs shadows625.41625.410.00
sharedges enqueues89.0389.030.00
sharedges resource92.1792.170.00
sharedobject queue41.4441.440.00
 buffer_cache40,960.0040,960.000.00
 fixed_sga2.092.090.00
 log_buffer43.6143.610.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

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

Streams Apply Rate

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 Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,6140.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00 0.000.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/querydb/adump  
audit_trailDB  
cluster_databaseTRUE  
compatible11.2.0.0.0  
control_files+DATA_DG/querydb/control01.ctl, +DATA_DG/querydb/control02.ctl  
db_block_size8192  
db_cache_size42949672960  
db_domain    
db_files1000  
db_namequerydb  
db_recovery_file_dest+DATA_DG  
db_recovery_file_dest_size1099511627776  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=querydbXDB)  
instance_number1  
java_pool_size1073741824  
large_pool_size1073741824  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.194.204)(PORT=1521))))  
open_cursors300  
pga_aggregate_target10737418240  
processes2000  
remote_listenerquerydb-scan:1521  
remote_login_passwordfileEXCLUSIVE  
session_cached_cursors128  
sessions3024  
shared_pool_size4294967296  
spfile+DATA_DG/querydb/spfilequerydb.ora  
thread1  
timed_statisticsTRUE  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA_DG/querydb/control01.ctl  
+DATA_DG/querydb/control02.ctl  

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)1,788,717494.85137,593.62
acks for commit broadcast(logical)1,803,436498.92138,725.85
broadcast msgs on commit(actual)2540.0719.54
broadcast msgs on commit(logical)3040.0823.38
broadcast msgs on commit(wasted)90.000.69
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received40.000.31
flow control messages sent00.000.00
gcs apply delta00.000.00
gcs assume cvt200.011.54
gcs assume no cvt34,1519.452,627.00
gcs ast xid00.000.00
gcs blocked converts17,2264.771,325.08
gcs blocked cr converts56,19015.544,322.31
gcs compatible basts1960.0515.08
gcs compatible cr basts (global)3,8311.06294.69
gcs compatible cr basts (local)22,2686.161,712.92
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs1000.037.69
gcs dbwr write request msgs700.025.38
gcs delta msgs sent00.000.00
gcs delta push aborted by cancel00.000.00
gcs delta push aborted by remastering00.000.00
gcs delta push cancelled00.000.00
gcs delta push cancelled at master00.000.00
gcs delta push cancelled by close00.000.00
gcs delta push cancelled by consign00.000.00
gcs delta push cancelled by cvt ping00.000.00
gcs delta push cancelled by dwncvt00.000.00
gcs delta push create pi00.000.00
gcs delta update master msgs sent00.000.00
gcs delta wait aborted by remastering00.000.00
gcs delta wait cancelled00.000.00
gcs error msgs00.000.00
gcs force cr block only20.000.15
gcs force cr grant80.000.62
gcs force cr no current00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts19,5345.401,502.62
gcs immediate (null) converts69,94119.355,380.08
gcs immediate cr (compatible) converts00.000.00
gcs immediate cr (null) converts187,89651.9814,453.54
gcs indirect ast228,41163.1917,570.08
gcs indirect bidless ast3180.0924.46
gcs indirect fg ast228,41163.1917,570.08
gcs lms flush pi msgs2,3690.66182.23
gcs lms write request msgs12,1543.36934.92
gcs msgs process time(ms)13,1273.631,009.77
gcs msgs received2,574,194712.15198,014.92
gcs new served by master57,24115.844,403.15
gcs out-of-order msgs00.000.00
gcs pings refused20.000.15
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts210.011.62
gcs reader bypass N->Xw ping local20.000.15
gcs reader bypass N->Xw ping remote00.000.00
gcs reader bypass grant X on assume20.000.15
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast160.001.23
gcs reader bypass grant immediate3280.0925.23
gcs recovery claim msgs00.000.00
gcs refuse xid00.000.00
gcs regular cr79,41721.976,109.00
gcs retry convert request00.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual2100.0616.15
gcs side channel msgs logical7410.2057.00
gcs stale cr00.000.00
gcs undo cr00.000.00
gcs write notification msgs00.000.00
gcs writes refused30.000.23
ges msgs process time(ms)1,2240.3494.15
ges msgs received73,44620.325,649.69
global posts dropped00.000.00
global posts queue time1530.0411.77
global posts queued40.000.31
global posts requested40.000.31
global posts sent40.000.31
implicit batch messages received52,54714.544,042.08
implicit batch messages sent10,0742.79774.92
lmd msg send time(ms)10.000.08
lms(s) msg send time(ms)00.000.00
messages flow controlled2280.0617.54
messages queue sent actual97,06126.857,466.23
messages queue sent logical20,6415.711,587.77
messages received actual2,481,279686.44190,867.62
messages received logical2,647,635732.46203,664.23
messages sent directly17,2664.781,328.15
messages sent indirectly57,66115.954,435.46
messages sent not implicit batched00.000.00
messages sent pbatched1,984,403548.98152,646.38
msgs causing lmd to send msgs34,2289.472,632.92
msgs causing lms(s) to send msgs117,29532.459,022.69
msgs received queue time (ms)592,875164.0245,605.77
msgs received queued2,647,646732.47203,665.08
msgs sent queue time (ms)1,8540.51142.62
msgs sent queue time on ksxp (ms)256,78171.0419,752.38
msgs sent queued107,19529.668,245.77
msgs sent queued on ksxp1,967,230544.23151,325.38
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received43,05511.913,311.92
process batch messages sent1,922,690531.91147,899.23


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests151
CURRENT Block Requests257
Data Block Requests151
Undo Block Requests0
TX Block Requests221
Current Results408
Private results0
Zero Results0
Disk Read Results0
Fail Results0
Fairness Down Converts103
Fairness Clears10
Free GC Elements0
Flushes2
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works12
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins00.000.000.000.000.00
Flushes1471.4328.570.000.000.00
Writes10598.101.900.000.000.00


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
3data block4197.562.440.0023296.983.020.00
2data block10099.001.000.0012598.401.600.00
3Others19100.000.000.0022100.000.000.00
3undo header3080.0020.000.001100.000.000.00
2Others11100.000.000.0017100.000.000.00
2undo header1100.000.000.003100.000.000.00
2undo block1100.000.000.000   

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

  CR Avg Time (ms) Current Avg Time (ms)
Inst NoBlock Class AllImmedBusyCongstAllImmedBusyCongst
3data block0.330.311.11 0.310.290.99 
2data block0.420.393.41 0.340.321.40 
3others0.190.19  0.230.23  
3undo header0.340.200.89 0.260.26  
2others0.380.38  0.240.24  
2undo header0.260.26  0.580.58  
2undo block0.270.27      
3undo block        

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

   CR Current
Src Inst#Block Class Blocks LostImmed Blks Received% 2hop% 3hopImmed Blks Received% 2hop% 3hop
3data block04050.0050.0022578.6721.33
2data block09928.2871.7212363.4136.59
3others019100.000.0022100.000.00
2others01127.2772.731758.8241.18
3undo header024100.000.001100.000.00
2undo header01100.000.003100.000.00
2undo block01100.000.000  
3undo block00  0  

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

   CR Avg Time (ms) Current Avg Time (ms)
Src Inst#Block Class Lost TimeImmed2hop3hopImmed2hop3hop
3data block 0.310.280.340.290.270.38
2data block 0.390.270.430.320.270.41
3others 0.190.19 0.230.23 
2others 0.380.140.470.240.180.33
3undo header 0.200.20 0.260.26 
2undo header 0.260.26 0.580.58 
2undo block 0.270.27    
3undo block       

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
12820.310.062820.310.06
22820.410.462820.500.45
32820.380.312820.420.31

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.010.00
Parallel Query0.000.00
DB Locks0.090.12
DB Streams0.000.00
Other0.010.04

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Device NameIP AddressPublicSourceSend Mbytes/secSend ErrorsSend DroppedSend Buffer OverrunSend Carrier LostReceive Mbytes/secReceive ErrorsReceive DroppedReceive Buffer OverrunReceive Frame Errors
lan901:801169.254.254.172NO  0.000000 0.000000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

NameTotalper Remaster OpBegin SnapEnd Snap
remaster ops31.00  
remastered objects51.67  
replayed locks received3010.00  
replayed locks sent4,8221,607.33  
resources cleaned00.00  
remaster time (s)36.812.26  
quiesce time (s)14.24.73  
freeze time (s)0.10.02  
cleanup time (s)8.12.69  
replay time (s)0.30.10  
fixwrite time (s)13.64.55  
sync time (s)0.40.14  
affinity objects  6,6206,615


Back to Top

End of Report