WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
EZTOPQA1797134646eztopqa_va3315-Jul-13 17:0711.2.0.3.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
mhva013.ezto.mhecloud.mcgraw-hill.comLinux x86 64-bit 64 32 4 126.03

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:110115-Jul-13 21:00:39331 2.6
End Snap:110416-Jul-13 00:00:08338 11.5
Elapsed:  179.49 (mins)  
DB Time:  184.22 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 4,096M 4,096MStd Block Size: 8K
Shared Pool Size: 3,072M 3,072MLog Buffer: 39,932K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 1.0 0.1 0.00 0.00
DB CPU(s): 0.3 0.0 0.00 0.00
Redo size: 1,061,599.8 89,524.0  
Logical reads: 68,398.9 5,768.0  
Block changes: 1,106.4 93.3  
Physical reads: 259.9 21.9  
Physical writes: 376.3 31.7  
User calls: 452.5 38.2  
Parses: 3.8 0.3  
Hard parses: 0.1 0.0  
W/A MB processed: 0.0 0.0  
Logons: 0.0 0.0  
Executes: 285.4 24.1  
Rollbacks: 0.0 0.0  
Transactions: 11.9   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.96
Buffer Hit %: 99.62In-memory Sort %: 100.00
Library Hit %: 99.96Soft Parse %: 98.68
Execute to Parse %: 98.67Latch Hit %: 92.93
Parse CPU to Parse Elapsd %: 23.20% Non-Parse CPU: 99.01

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.41 71.80
% SQL with executions>1: 81.12 85.28
% Memory for SQL w/exec>1: 76.28 76.97

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read1,338,8925,677451.36User I/O
DB CPU 3,030 27.41 
reliable message370,25394338.53Other
enq: CR - block range reuse ckpt474,85745314.10Other
log file sync127,67730322.74Commit

Host CPU (CPUs: 64 Cores: 32 Sockets: 4)

Load Average BeginLoad Average End%User%System%WIO%Idle
1.28 1.64 3.5 0.8 0.8 95.7
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
3.5 80.6 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 129,050.1 129,050.1
SGA use (MB): 12,233.1 12,233.1
PGA use (MB): 949.7 2,027.9
% Host Mem used for SGA+PGA: 10.22 11.05

RAC Statistics

BeginEnd
Number of Instances: 4 4

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 279.24 23.55
Global Cache blocks served: 272.12 22.95
GCS/GES messages received: 1,494.64 126.04
GCS/GES messages sent: 1,488.33 125.51
DBWR Fusion writes: 21.57 1.82
Estd Interconnect traffic (KB) 4,993.54 

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

Buffer access - local cache %: 99.21
Buffer access - remote cache %: 0.41
Buffer access - disk %: 0.38

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.4
Avg global cache current block receive time (ms): 0.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.5
Avg global cache cr block flush time (ms): 2.5
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 %: 2.7
Avg global cache current block flush time (ms): 2.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 59.82
% of indirect sent messages: 39.13
% of flow controlled messages: 1.05


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
bond1:1169.254.88.82N    

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time9,333.6984.45
DB CPU3,030.1027.41
parse time elapsed131.591.19
sequence load elapsed time0.660.01
repeated bind elapsed time0.200.00
hard parse elapsed time0.180.00
connection management call elapsed time0.020.00
RMAN cpu time (backup/restore)0.010.00
PL/SQL execution elapsed time0.010.00
PL/SQL compilation elapsed time0.000.00
DB time11,052.93 
background elapsed time25,023.01 
background cpu time21,111.19 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME2,995,065 
IDLE_TIME66,171,281 
IOWAIT_TIME571,464 
NICE_TIME610 
SYS_TIME543,085 
USER_TIME2,410,476 
LOAD12
PHYSICAL_MEMORY_BYTES135,318,794,240 
NUM_CPU_CORES32 
NUM_CPUS64 
NUM_CPU_SOCKETS4 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX2,097,152 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
15-Jul 21:00:391.28     
15-Jul 22:00:051.391.320.820.4998.680.20
15-Jul 23:00:021.768.387.320.9691.621.24
16-Jul 00:00:081.643.272.290.9196.731.03

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
User I/O1,364,31605,684451.43
DB CPU  3,030 27.41
Other870,56401,457213.18
Cluster2,754,796092208.34
Commit127,677030322.74
Network5,210,981021901.98
Concurrency11,0000300.03
Configuration35672140.01
Application2,4270100.00
Administrative510011000.00
Scheduler20000.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
db file sequential read1,338,89205,677410.4851.36
reliable message370,253094332.908.53
enq: CR - block range reuse ckpt474,857045313.724.10
log file sync127,677030321.002.74
gc current grant 2-way951,443022507.452.04
SQL*Net more data from client953,893018607.471.68
gc current block 3-way352,171015202.761.38
gc current grant busy321,415015102.521.36
gc current block 2-way474,680012103.721.09
gc cr block 3-way243,761010601.910.96
gc cr block 2-way243,93706301.910.57
latch free21,42305730.170.51
gc cr multi block request79,46403600.620.32
gc current block busy33,35602510.260.23
SQL*Net message to client3,870,668018030.310.17
gc cr block busy5,04601530.040.13
SQL*Net more data to client379,30901402.970.13
gc buffer busy release4,46301130.030.10
gc current block congested17,0050700.130.06
db file scattered read1,1350760.010.06
gc cr block congested10,8180500.080.05
gc current grant congested13,3550400.100.03
name-service call wait4003810.000.03
latch: row cache objects9,7530100.080.01
SQL*Net vector data to client7,1110100.060.01
gc current multi block request1,5660110.010.01
undo segment extension71831120.000.01
db file parallel read4201120.000.00
JS kgl get object wait510011000.000.00
gc cr grant 2-way2,0260000.020.00
row cache lock3090010.000.00
enq: FB - contention1,3360000.010.00
enq: TX - index contention2430020.000.00
log file switch completion600610.000.00
Disk file operations I/O23,7060000.190.00
resmgr:internal state change310001010.000.00
buffer busy waits3430010.000.00
enq: TX - row lock contention1002790.000.00
gc buffer busy acquire1220020.000.00
direct path read5170000.000.00
SQL*Net break/reset to client2,1520000.020.00
library cache: mutex X1240010.000.00
enq: TM - contention2740000.000.00
enq: SQ - contention900100.000.00
PX Deq: Slave Session Stats1420010.000.00
enq: TX - contention750010.000.00
enq: HW - contention26874000.000.00
enq: PS - contention1251010.000.00
local write wait200040.000.00
DFS lock handle7414010.000.00
IPC send completion sync4800000.000.00
latch: ges resource hash list5600000.000.00
SecureFile mutex710000.000.00
gc cr disk read1190000.000.00
cursor: pin S270010.000.00
gc current split210010.000.00
PX Deq: reap credit976100000.010.00
cursor: mutex S20050.000.00
library cache lock2692000.000.00
read by other session40020.000.00
library cache pin190000.000.00
enq: JQ - contention10100010.000.00
latch: shared pool580000.000.00
latch: enqueue hash chains560000.000.00
gc cr grant congested230000.000.00
enq: JS - job run lock - synchronize9100000.000.00
wait list latch free30010.000.00
latch: object queue header operation320000.000.00
latch: gc element320000.000.00
latch: messages60000.000.00
latch: cache buffers chains220000.000.00
KJC: Wait for msg sends to complete350000.000.00
SQL*Net message from client3,870,66902,852,51673730.31 
jobq slave wait2,0411001,0225010.02 
PX Deq: Execution Msg5520120.00 
KSV master wait3800120.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file sequential read1,447,69701,204111.344.81
latch: row cache objects13,098,55201,0790102.574.31
log file parallel write544,401084424.263.37
db file parallel write792,736060416.212.41
gc current block busy67,809026240.531.05
gc current block 2-way915,943021207.170.85
gc cr disk read1,038,677020408.130.81
direct path write temp140,317015711.100.63
gcs log flush sync118,977115010.930.60
flashback log file write47,617012730.370.51
enq: CR - block range reuse ckpt181,88307601.420.31
gc current grant busy142,30305901.110.24
log file sequential read5,624058100.040.23
gc cr block 3-way153,52905501.200.22
gc current block 3-way131,01205001.030.20
ges inquiry response111,25804600.870.18
gc buffer busy release10,25303230.080.13
gc cr block 2-way155,26403201.220.13
ASM file metadata operation5,67902850.040.11
gc buffer busy acquire4,28302760.030.11
control file sequential read47,10302510.370.10
ksxr poll remote instances1,523,31010023011.930.09
DFS lock handle48,808981800.380.07
reliable message926017190.010.07
buffer busy waits3,62001640.030.06
control file parallel write5,17101330.040.05
CSS operation: data query3,58001130.030.04
row cache cleanup3,547,56509027.780.03
latch free19,6510700.150.03
wait list latch free6,1960710.050.03
enq: DW - contention14,711100600.120.02
gc current block congested16,9460500.130.02
os thread startup11905430.000.02
PX Nsq: PQ load info query2410052010.000.02
gc cr grant 2-way18,8770400.150.02
gc current grant 2-way12,6290300.100.01
gc cr block congested6,4590200.050.01
row cache lock2,4950210.020.01
enq: WF - contention6902240.000.01
name-service call wait1802920.000.01
libcache interrupt action by LCK3,544,07401027.750.01
row cache process3,555,03101027.840.01
LGWR wait for redo copy18,1520100.140.01
gc cr block busy4210130.000.01
CGS wait for IPC msg100,435100100.790.00
enq: XR - database force logging3,5810100.030.00
latch: messages6,1660100.050.00
ges lms sync during dynamic remastering and reconfig96501120.000.00
db file async I/O submit719,1520105.630.00
db file scattered read2470130.000.00
undo segment extension69811100.000.00
db file parallel read5901110.000.00
latch: redo writing2,5680000.020.00
Log archive I/O2150020.000.00
direct path read630040.000.00
CSS group membership query1790010.000.00
enq: CF - contention78738000.010.00
enq: TX - contention1100170.000.00
gc cr multi block request4160000.000.00
read by other session640020.000.00
log file switch completion200750.000.00
enq: HW - contention4650000.000.00
CSS operation: action360030.000.00
enq: PS - contention18040010.000.00
resmgr:internal state change110001000.000.00
enq: TM - contention9638010.000.00
rdbms ipc reply100920.000.00
latch: cache buffers chains1,4530000.010.00
CSS initialization160060.000.00
enq: RO - fast object reuse1410010.000.00
enq: US - contention1810000.000.00
library cache pin2140000.000.00
library cache lock2062000.000.00
log file single write120050.000.00
gc cr grant congested2780000.000.00
latch: object queue header operation7360000.010.00
Disk file operations I/O4,1560000.030.00
flashback log file read80070.000.00
enq: TX - index contention400150.000.00
gc current grant congested1620000.000.00
PX Deq: reap credit3,775100000.030.00
enq: TA - contention640010.000.00
latch: gc element8120000.010.00
latch: undo global data4720000.000.00
enq: TS - contention7941000.000.00
CSS operation: query2270000.000.00
JS kgl get object wait11000200.000.00
latch: enqueue hash chains1750000.000.00
latch: ges resource hash list1470000.000.00
direct path write180010.000.00
enq: TD - KTF dump entries330000.000.00
log file sync100010.000.00
latch: checkpoint queue latch730000.000.00
gc current multi block request150000.000.00
enq: TK - Auto Task Serialization13100010.000.00
kfk: async disk IO110010.000.00
flashback log file sync50010.000.00
PX Deq: Slave Session Stats1260000.000.00
latch: gcs resource hash790000.000.00
enq: PI - contention18100000.000.00
ADR block file read450000.000.00
enq: AF - task serialization1681000.000.00
latch: redo allocation600000.000.00
PX Deq: Signal ACK RSG1260000.000.00
enq: DR - contention60010.000.00
PX Deq: Signal ACK EXT1260000.000.00
enq: FB - contention100000.000.00
ARCH wait for archivelog lock40010.000.00
enq: MW - contention60000.000.00
latch: cache buffers lru chain220000.000.00
asynch descriptor resize227100000.000.00
gc current split30010.000.00
ADR block file write150000.000.00
enq: WL - contention3100000.000.00
rdbms ipc message14,681,9881330,28722114.97 
gcs remote message19,069,5752685,0124149.33 
Space Manager: slave idle wait779,472074,359956.10 
wait for unread message on broadcast channel21,6868921,5399930.17 
DIAG idle wait333,1507921,231642.61 
class slave wait3,077015,05448930.02 
PING3,6932310,77729180.03 
shared server idle wait35910010,773300100.00 
ASM background timer3,564010,77330230.03 
GCR sleep2,15310010,76650010.02 
pmon timer3,58810010,76029990.03 
Streams AQ: qmn coordinator idle wait7485010,751143730.01 
Streams AQ: qmn slave idle wait374010,751287450.00 
smon timer134,084010,743801.05 
dispatcher timer17910010,742600110.00 
ges remote message2,206,232210,633517.28 
PX Idle Wait15906,039379800.00 
KSV master wait7,921822630.06 
VKRM Idle1018177770.00 
PX Deq: Join ACK1260010.00 
SQL*Net message from client640010.00 
PX Deq: Parse Reply1260000.00 
PX Deq: Execute Reply1260000.00 
Streams AQ: RAC qmn coordinator idle wait757100000.01 

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 read52100.0       
ADR block file write15100.0       
ADR file lock18100.0       
ARCH wait for archivelog lock580.020.0      
ASM file metadata operation573091.0.1.61.0.1.76.3.1
asynch descriptor resize229100.0       
buffer busy waits396355.76.18.915.48.44.31.2 
CGS wait for IPC msg100.5K100.0       
control file parallel write5182 74.520.33.5.9.2.5 
control file sequential read47.2K95.42.41.0.8.3.1.0 
CSS group membership query17917.979.91.11.1    
CSS initialization1650.0  18.825.06.3  
CSS operation: action3622.213.919.444.4    
CSS operation: data query3580 11.588.0.5    
CSS operation: query22796.5.92.6     
cursor: mutex S250.0   50.0   
cursor: pin S2892.9   7.1   
db file async I/O submit715.5K100.0       
db file parallel read10110.92.03.013.952.515.82.0 
db file parallel write790.9K87.77.52.91.4.4.1.0 
db file scattered read138150.33.15.115.220.64.31.3 
db file sequential read2787.5K70.62.84.913.16.61.6.3.0
DFS lock handle48.9K99.2.8.0   .0 
direct path read58088.63.62.93.31.4.2  
direct path write1883.316.7      
direct path write temp140.3K60.535.33.0.9.2.1.0 
Disk file operations I/O28.3K100.0.0      
enq: AF - task serialization16100.0       
enq: CF - contention788100.0       
enq: CR - block range reuse ckpt657K87.46.43.51.9.5.2.1 
enq: DR - contention6100.0       
enq: DW - contention14.7K99.6.4      
enq: FB - contention134899.9.1      
enq: FL - Flashback database log2100.0       
enq: HW - contention73299.9.1      
enq: JQ - contention10100.0       
enq: JS - job run lock - synchronize9100.0       
enq: MW - contention6100.0       
enq: PD - contention2100.0       
enq: PE - contention1100.0       
enq: PI - contention18100.0       
enq: PS - contention30598.02.0      
enq: PW - flush prewarm buffers1100.0       
enq: RO - fast object reuse14193.64.32.1     
enq: RS - prevent aging list update1100.0       
enq: SQ - contention911.133.344.4   11.1 
enq: TA - contention6498.41.6      
enq: TD - KTF dump entries32100.0       
enq: TK - Auto Task Serialization13100.0       
enq: TM - contention37099.5   .3 .3 
enq: TS - contention79100.0       
enq: TT - contention2100.0       
enq: TX - allocate ITL entry3100.0       
enq: TX - contention8666.317.48.1 2.32.33.5 
enq: TX - index contention24790.7.8.41.23.22.41.2 
enq: TX - row lock contention1      100.0 
enq: US - contention181100.0       
enq: WF - contention6991.31.4  1.4 5.8 
enq: WL - contention4100.0       
enq: WP - contention1100.0       
enq: XR - database force logging358299.8.2      
flashback log file read825.012.5  62.5   
flashback log file sync560.0 40.0     
flashback log file write47.6K37.819.115.923.53.1.5.1 
gc buffer busy acquire440639.316.814.610.29.75.93.6 
gc buffer busy release14.7K28.140.718.07.13.21.91.0 
gc cr block busy54641.649.737.67.92.0.9.3 
gc cr block congested17.3K99.4.2.1.1.1.0.1 
gc cr block 2-way399.3K99.8.1.0.0.0.0.0 
gc cr block 3-way397.4K99.6.2.1.1.1.0.0 
gc cr disk read1039K99.8.0.0.0.0.0.0 
gc cr failure2100.0       
gc cr grant congested301100.0       
gc cr grant 2-way20.9K99.9.0.0.0.0   
gc cr multi block request79.9K99.1.7.1.1.1.0.0 
gc current block busy101.2K37.529.519.37.63.81.7.7 
gc current block congested34K99.5.1.1.1.1.0.0 
gc current block 2-way1391.1K99.8.0.0.0.0.0.0 
gc current block 3-way483.3K99.6.2.1.1.1.0.0 
gc current grant busy463.8K99.1.4.2.2.1.0.0 
gc current grant congested13.5K99.6.1.1.1.1.0.0 
gc current grant 2-way964.3K99.8.1.0.0.0.0.0 
gc current multi block request158198.9.6 .3.1 .1 
gc current retry3100.0       
gc current split2495.84.2      
gc object scan28100.0       
gc quiesce1100.0       
gcs log flush sync119K55.229.310.63.71.3.0.0 
ges inquiry response111.3K99.6.4.0     
ges lms sync during dynamic remastering and reconfig96  25.024.016.734.4  
IPC send completion sync588100.0       
JS kgl get object wait6     16.783.3 
kfk: async disk IO1190.9 9.1     
KJC: Wait for msg sends to complete50100.0       
ksxr poll remote instances1523.7K100.0.0.0     
latch: cache buffers chains147599.8.1  .1   
latch: cache buffers lru chain24100.0       
latch: checkpoint queue latch73100.0       
latch: enqueue hash chains231100.0       
latch free41.1K55.211.023.610.2.0   
latch: gc element844100.0       
latch: gcs resource hash82100.0       
latch: ges resource hash list70799.9.1      
latch: messages617299.5.4.1     
latch: object queue header operation76899.9 .1     
latch: redo allocation60100.0       
latch: redo writing256899.4.1.5     
latch: row cache objects13.1M99.9.1.0.0.0.0  
latch: shared pool58100.0       
latch: undo global data474100.0       
LGWR wait for redo copy18.2K100.0.0      
libcache interrupt action by LCK3545.1K100.0       
library cache lock23499.1.9      
library cache: mutex X14693.8   6.2   
library cache pin23598.71.3      
local write wait20  75.020.05.0   
lock escalate retry14100.0       
Log archive I/O21540.930.221.96.5.5   
log file parallel write544.5K47.937.210.73.2.8.2.1 
log file sequential read56343.83.15.541.731.711.42.9 
log file single write1650.0  37.56.36.3  
log file switch completion8    12.512.575.0 
log file sync127.7K10.657.623.06.21.7.7.2 
name-service call wait58  1.73.4 6.987.9 
os thread startup119     81.518.5 
PX Deq: reap credit4751100.0       
PX Deq: Signal ACK EXT126100.0       
PX Deq: Signal ACK RSG126100.0       
PX Deq: Slave Session Stats26898.1.7.4 .7   
PX Nsq: PQ load info query24      100.0 
rdbms ipc reply1      100.0 
read by other session6867.64.47.411.87.41.5  
reliable message371.3K63.019.413.41.1.8.61.5 
resmgr:cpu quantum2100.0       
resmgr:internal state change4      100.0 
row cache cleanup3548.6K100.0.0.0     
row cache lock280491.57.4.1.1.1.2.6 
row cache process3556K100.0       
SecureFile mutex7195.8   4.2   
SQL*Net break/reset to client2152100.0       
SQL*Net message to client3871.1K100.0.0.0     
SQL*Net more data from client954K94.45.1.4.1.0.0.0 
SQL*Net more data to client379.4K99.8.0.1.0.0.0  
SQL*Net vector data to client711199.9.1.0     
undo segment extension14056.4   15.719.38.6 
wait list latch free6193.099.6.3     
ASM background timer358213.1.9.4.4.42.122.160.4
class slave wait309644.6.311.23.210.11.715.513.4
DIAG idle wait333.2K14.71.31.2.615.133.134.0 
dispatcher timer179       100.0
GCR sleep2154       100.0
gcs remote message19M34.410.812.313.329.2.0.0 
ges remote message2206.7K73.410.33.22.73.13.04.3 
jobq slave wait2059.0     100.0 
KSV master wait797893.8.1.4.8.1.54.3.1
PING369376.8      23.2
pmon timer3587      .199.9
PX Deq: Execute Reply12699.2.8      
PX Deq: Execution Msg55271.710.112.73.8.4.21.1 
PX Deq: Join ACK12671.416.711.9     
PX Deq: Parse Reply126100.0       
PX Idle Wait142 5.65.61.47.76.349.323.9
rdbms ipc message14.4M68.18.86.44.23.73.15.4.3
shared server idle wait358       100.0
smon timer134.1K44.99.02.03.46.49.024.3.9
Space Manager: slave idle wait756.3K43.712.21.72.95.68.024.21.7
SQL*Net message from client3871.4K1.254.023.16.75.13.85.01.2
Streams AQ: qmn coordinator idle wait74849.9.1     50.0
Streams AQ: qmn slave idle wait374       100.0
Streams AQ: RAC qmn coordinator idle wait757100.0       
wait for unread message on broadcast channel21.7K   .0.7 99.3 

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 operation36393.66.3    .0.1
buffer busy waits4998.81.1.1  .0  
control file parallel write2699.5.2.2.1    
control file sequential read16100.0.0.0     
db file parallel read298.02.0      
db file parallel write192100.0.0.0.0 .0  
db file scattered read1898.71.2.1     
db file sequential read869399.7.3.0.0.0.0.0 
DFS lock handle2100.0.0.0     
direct path write temp6100.0.0      
enq: CR - block range reuse ckpt44399.9.1.0.0.0.0  
enq: SQ - contention188.9 11.1     
enq: TM - contention199.7.3      
enq: TX - contention396.53.5      
enq: TX - index contention398.81.2      
enq: TX - row lock contention1    100.0   
enq: WF - contention494.2 1.4 2.91.4  
flashback log file write2499.9.0.0     
gc buffer busy acquire15796.43.0.5.1.0.0  
gc buffer busy release14599.0.8.2  .0  
gc cr block busy1799.7.2.1.0    
gc cr block congested2099.9.1.0     
gc cr block 2-way27100.0.0.0.0    
gc cr block 3-way65100.0.0.0.0    
gc cr disk read53100.0.0.0.0    
gc cr multi block request19100.0.0.0.0    
gc current block busy69999.3.6.1.0.0.0  
gc current block congested16100.0.0.0     
gc current block 2-way111100.0.0.0.0    
gc current block 3-way76100.0.0.0.0    
gc current grant busy130100.0.0.0.0    
gc current grant congested5100.0.0.0     
gc current grant 2-way63100.0.0.0.0    
gc current multi block request199.9.1      
gcs log flush sync1100.0.0      
JS kgl get object wait516.7 83.3     
log file parallel write30499.9.0.0.0    
log file sequential read16297.12.6.2.0.0   
log file switch completion625.025.050.0     
log file sync30699.8.2.0.0    
name-service call wait5112.113.862.112.1    
os thread startup2281.53.411.83.4    
PX Nsq: PQ load info query24   100.0    
rdbms ipc reply1  100.0     
reliable message566598.5.6.7.1.0.0  
resmgr:internal state change4  100.0     
row cache lock1699.4.3.3     
SQL*Net more data from client184100.0.0.0.0    
undo segment extension1291.45.02.9.7    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
ASM file metadata operation499.9.1      

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)
eztopqa_va11,0453,0261,34736,381
SYS$USERS2202
SYS$BACKGROUND211,452700,171
DB112032XDB0000

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
eztopqa_va 13642875684109343005208790219
SYS$USERS 3606605121520
SYS$BACKGROUND 159257913621665069011041000

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,241.16150,6810.0229.3214.2570.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
2,485.49197,3710.0122.4913.3861.546fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,258.1791,1240.0111.3813.5578.169j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
643.8218,1060.045.8222.2653.65d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
455.931455.934.1266.3734.3705s9358mm6vrr   begin dbms_feature_usage_inter...
454.141454.144.1166.5434.512d1p0p5k3f8fu   select p, NULL, NULL from (sel...
425.0318,1060.023.8512.3878.016mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
227.51122,4030.002.0665.340.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
206.1318,0240.011.8616.4874.35gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
144.9371,1300.001.3159.930.32aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
141.40109,0950.001.2843.550.223jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
140.2818,0930.011.2779.500.07b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
129.10841.541.1725.2364.03aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...

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
461.83150,6810.0015.243,241.1614.2570.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
332.66197,3710.0010.982,485.4913.3861.546fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
302.591302.599.99455.9366.3734.3705s9358mm6vrr   begin dbms_feature_usage_inter...
302.201302.209.97454.1466.5434.512d1p0p5k3f8fu   select p, NULL, NULL from (sel...
170.5291,1240.005.631,258.1713.5578.169j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
148.65122,4030.004.91227.5165.340.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
143.3218,1060.014.73643.8222.2653.65d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
111.5318,0930.013.68140.2879.500.07b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
86.8571,1300.002.87144.9359.930.32aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
61.59109,0950.002.03141.4043.550.223jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
52.6218,1060.001.74425.0312.3878.016mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
33.9618,0240.001.12206.1316.4874.35gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
32.57840.391.07129.1025.2364.03aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...

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
2,291.37150,6810.0232.523,241.1614.2570.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
1,529.67197,3710.0121.712,485.4913.3861.546fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
983.4491,1240.0113.961,258.1713.5578.169j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
345.4118,1060.024.90643.8222.2653.65d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
331.5918,1060.024.71425.0312.3878.016mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
156.701156.702.22455.9366.3734.3705s9358mm6vrr   begin dbms_feature_usage_inter...
156.701156.702.22454.1466.5434.512d1p0p5k3f8fu   select p, NULL, NULL from (sel...
153.2718,0240.012.18206.1316.4874.35gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
82.67840.981.17129.1025.2364.03aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
16.1535.380.2327.2237.7459.33acc988uzvjmmt   delete from WRH$_SYSMETRIC_HIS...

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
5,392,926122,40344.060.73227.5165.308w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
4,568,174150,68130.320.623,241.1614.270.70wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
3,391,92418,106187.340.46643.8222.353.7d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
3,008,45818,093166.280.41140.2879.5.1b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
2,774,368197,37114.060.382,485.4913.461.56fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
2,323,98571,13032.670.32144.9359.9.3aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
1,589,913122,30413.000.2225.0937.305dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
1,544,74611140,431.450.2147.3144.12.27f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...
1,336,572334,0714.000.1830.2830.80d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
1,333,77491,12414.640.181,258.1713.678.29j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
516,723150,6813.4318.463,241.1614.2570.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
398,934197,3712.0214.252,485.4913.3861.546fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
186,51591,1242.056.661,258.1713.5578.169j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
87,947841,046.993.14129.1025.2364.03aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
58,23018,1063.222.08643.8222.2653.65d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
54,58218,1063.011.95425.0312.3878.016mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
37,43418,0242.081.34206.1316.4874.35gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
14,59834,866.000.5227.2237.7459.33acc988uzvjmmt   delete from WRH$_SYSMETRIC_HIS...
5,51831,839.330.2012.7711.6485.232whm2vvjb98k7   delete from WRH$_SQL_PLAN tab ...
2,7643383.760.103.7612.2082.900m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...

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
499,845499,845150,6813.320.0017.900wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
389,323389,323197,3711.970.0013.946fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
186,344186,34491,1242.040.006.679j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
87,94787,947841,046.990.003.15aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
37,39937,39918,0242.070.001.34gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
14,59814,59834,866.000.000.52acc988uzvjmmt   delete from WRH$_SYSMETRIC_HIS...
5,5185,51831,839.330.000.202whm2vvjb98k7   delete from WRH$_SQL_PLAN tab ...
4,9014,90131,633.670.000.181cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
3,2983,29813,298.000.000.1205s9358mm6vrr   begin dbms_feature_usage_inter...
2,3152,3153771.670.000.0896w2cbx7ntmtv   delete from WRH$_BG_EVENT_SUMM...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
384,964384,9401.0050.2534.20dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
334,071334,0661.0030.2830.80d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
221,977221,9321.0018.5131.40d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
197,371197,3711.002,485.4913.461.56fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
160,13870,0820.4414.3130.107jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
150,681346,9722.303,241.1614.270.70wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
122,4031,593,63513.02227.5165.308w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
122,3141,223,12010.0020.7633.60d024vwxkhahjc JDBC Thin Client SELECT title, managers, partic...
122,3041,222,97010.0025.0937.305dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
113,432113,4311.0018.1430.409z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
109,57300.0015.1426.4076nzpvfmj776g JDBC Thin Client SELECT questionID, data FROM f...
109,325109,3241.0036.1737.41.956z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
109,09590,8020.83141.4043.6.23jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
91,12491,1231.001,258.1713.678.29j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
80,33800.006.8629.2073r2ts8p97um2 JDBC Thin Client SELECT flags FROM users WHERE ...
79,76279,7631.0010.4122.706y55dxn24t86q   select obj#, intcol#, ts#, fil...
76,23876,2381.0011.1431.40054rpfwwu14za JDBC Thin Client SELECT url FROM tests WHERE te...
76,056334,0794.3912.9929.5.1ckr1vbptqjnd1 JDBC Thin Client SELECT mediaID FROM mediaconsu...
71,130142,2582.00144.9359.9.3aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
51,67740,1750.7815.303900qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
40,17240,1721.007.6534.30dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
40,17254,4001.3538.2050.60ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
40,172100,3462.5013.8744.307cbf1umqgg15a JDBC Thin Client SELECT mediaID, overrideHeight...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
21,701197,37152.906fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
9,8019,80123.89350f5yrnnmshs   lock table sys.mon_mods$ in ex...
2932930.71b2gnxm5z6r51n   lock table sys.col_usage$ in e...
18740,1720.46dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
184122,3140.45d024vwxkhahjc JDBC Thin Client SELECT title, managers, partic...
18440,1720.45ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
18318,0930.45b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
18151,6770.440qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
18140,1720.447cbf1umqgg15a JDBC Thin Client SELECT mediaID, overrideHeight...
18118,2950.448fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO SQL IdSQL ModuleSQL Text
220.06150,68111.763,241.166.7914.2570.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
180.6818,1069.65643.8228.0622.2653.65d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
123.7091,1246.611,258.179.8313.5578.169j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
111.44197,3715.952,485.494.4813.3861.546fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
67.61109,0953.61141.4047.8243.550.223jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
50.7618,1062.71425.0311.9412.3878.016mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
38.7371,1302.07144.9326.7259.930.32aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
22.7418,0241.21206.1311.0316.4874.35gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
22.3918,0931.20140.2815.9679.500.07b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
20.22111.0847.3142.7344.072.167f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...
13.21840.71129.1010.2325.2364.03aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
11.2340,1720.6038.2029.3950.570.02ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
2.8718,2950.157.2339.7036.700.018fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
2.399,8010.135.7141.9069.506.77g00cj285jmgsw   update sys.mon_mods$ set inser...
1.9830.1127.227.2837.7459.33acc988uzvjmmt   delete from WRH$_SYSMETRIC_HIS...
1.471,3780.085.1828.3366.840.019dd5xusnyg10n JDBC Thin Client SELECT * FROM attemptdata WHER...
1.0130.0512.777.9011.6485.232whm2vvjb98k7   delete from WRH$_SQL_PLAN tab ...
0.626500.038.097.7267.8721.659tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
0.3610.024.038.9930.1765.369v9n97qj8z1dg   delete /*+ dynamic_sampling(4)...
0.3030.025.545.5039.2859.1596w2cbx7ntmtv   delete from WRH$_BG_EVENT_SUMM...
0.26330.013.767.0312.2082.900m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
0.16221,9770.0118.510.8631.380.03d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
0.10109,3250.0136.170.2737.391.9156z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
0.1010.011.118.8263.7926.256ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.094,5810.001.008.5429.4825.386b9n2bk019yv6 JDBC Thin Client SELECT questionID from groupme...
0.0830.0015.020.523.650.561cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
0.072820.000.6511.1223.8658.73bjrsu1sf38nx2 JDBC Thin Client SELECT g.groupID, gm.name, g.e...
0.0530.000.3215.9420.1767.5047mm81hm9sggy   SELECT sum(case when a.sessio...
0.03360.000.359.2815.9781.19cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.0320.000.773.6499.490.0053qg5xxgv1jxm JDBC Thin Client SELECT medialookaside.* FROM m...
0.0230.000.1116.7675.398.495h91zx386wbht   WITH awr_params as ( SELECT /*...
0.012820.000.0914.9129.5220.31gacbtcuuq5rwv JDBC Thin Client SELECT * FROM questionbanks WH...
0.01113,4320.0018.140.0630.390.009z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
0.0130.000.146.1992.330.196cp74g22fzahf   WITH ash as (SELECT ash.event...
0.0110.000.272.8776.5921.534dy1xm4nxc0gf   insert into wrh$_system_event ...
0.01384,9640.0050.250.0134.200.00dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
0.0110.000.481.2068.5125.063wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
0.0130.000.0510.1377.689.61fkjkrv5ycz96u   SELECT sum(blk_read) as blk_r...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
054rpfwwu14zaSELECT url FROM tests WHERE testID= :1
05s9358mm6vrrbegin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
0m483bapqc9n3SELECT datasize, data FROM media WHERE mediaID=:1 ORDER BY block
0qhuda3t93088SELECT * FROM tests WHERE url = :1
0wmqqks6usuu5UPDATE attemptdata SET itemscore = :1 , maxpoints = :2 , formulaanswer = :3 , recordedvalue = :4 , followup = :5 , feedback = :6 , html = :7 , instructorcomment = :8 , params = :9 , updatedtime = :10 , userresponse = :11 , elapsed = :12 WHERE attemptdata_pk = :13
1cq3qr774cu45insert 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)
2d1p0p5k3f8fuselect p, NULL, NULL from (select count(*) p from v$rman_status where operation = 'BLOCK MEDIA RECOVERY')
2whm2vvjb98k7delete from WRH$_SQL_PLAN tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3jwu317rq41wnSELECT * FROM attempt WHERE testid=:1 AND sectionid=:2 AND activityid=:3 AND userid=:4 AND attemptno=:5 AND submissionid IS NULL
3wrrjm9qtr2mySELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL(JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
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
53qg5xxgv1jxmSELECT medialookaside.* FROM medialookaside LEFT JOIN media ON medialookaside.mediaID = media.mediaID WHERE media.mediaID IS NULL AND ROWNUM <= 10
56z638s8sdpv0SELECT * FROM tests WHERE testID=:1
5dqygfkgt8hwdSELECT catalogID FROM library WHERE entryID=:1
5h91zx386wbhtWITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6b9n2bk019yv6SELECT questionID from groupmembers WHERE groupID = :1 and testid = :2 ORDER BY orderID
6cp74g22fzahf WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
6fp93dkgc917vUPDATE attemptdata set ITEMSCORE = :1 , MAXPOINTS = :2 , FORMULAANSWER = :3 , RECORDEDVALUE = :4 , FOLLOWUP = :5 , FEEDBACK = :6 , HTML = :7 , INSTRUCTORCOMMENT = :8 , PARAMS = :9 , UPDATEDTIME = :10 , USERRESPONSE = :11 , elapsed = :12 WHERE ATTEMPTDATA_PK = :13
6mj44b33a0xwsINSERT INTO attempt (attempt_pk, testid, activityid, attemptno, userid, sectionid, totalscore, params, maxscore, totalcorrect, pctscore, elapsedtime, groupscores, datasize, createdtime) VALUES( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 )
6y55dxn24t86qselect obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1
73r2ts8p97um2SELECT flags FROM users WHERE listID=:1 AND userID=:2
76nzpvfmj776gSELECT questionID, data FROM fullcredit WHERE testID=:1
7cbf1umqgg15aSELECT mediaID, overrideHeight, overrideWidth FROM mediaconsumers WHERE testID=:1 AND lower(name)=:2
7f70vfs8vfj68SELECT mediaID, mediatype, datasize FROM media WHERE datasize > :1 AND block=0
7jkvzr8ar6j6gSELECT name FROM mediaconsumers WHERE testID=:1 AND consumerID=:2
8fttd5fgbsx2ySELECT * FROM attempt WHERE testid=:1 AND sectionid=:2 AND activityid=:3 AND userid=:4 AND attemptno=:5 AND submissionid IS NOT NULL
8w92u8fd9rccdSELECT * FROM library WHERE parentID =:1
96w2cbx7ntmtvdelete from WRH$_BG_EVENT_SUMMARY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
9dd5xusnyg10nSELECT * FROM attemptdata WHERE attempt_pk = :1 AND ( questionid = :2 OR questionid = :3 OR questionid = :4 OR questionid = :5 )
9j5trt70jc4r8UPDATE attempt SET params = :1 , totalscore = :2 , totalcorrect = :3 , pctscore = :4 , groupscores = :5 , datasize = :6 , updatedtime = :7 WHERE attempt_pk = :8
9tdph9wa5jnbhselect q.questionID, q.format, q.data, tqx.points, existsNode(PICKERXML, '//answerProperties[identifier = "common/wimbatool/wimba.html"]') wimbaEnabled, tqx.maxpoints, tqx.reftag from questions q , test_question_xref tqx where tqx.testid = :1 and tqx.questionid = q.questionid
9v9n97qj8z1dgdelete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)
9z1yfsqr77brwSELECT indexID FROM tests WHERE testID=:1
aa4maxrz4511zINSERT INTO uploads (uploadID, creation, state, datasize, filename, testID, data) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
aa9yh7rqc9narSELECT * FROM attemptdata WHERE attempt_pk = :1 AND ( questionid = :2 OR questionid = :3 )
acc988uzvjmmtdelete from WRH$_SYSMETRIC_HISTORY tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b2qv4nq67cczhSELECT * FROM attemptdata WHERE attempt_pk = :1
bjrsu1sf38nx2SELECT g.groupID, gm.name, g.enabled, g.randomize, g.randomCount, g.summarize from groups g, groups_master gm WHERE g.testID = :1 AND g.groupID = gm.groupID ORDER BY orderID
ckr1vbptqjnd1SELECT mediaID FROM mediaconsumers WHERE testID=:1
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d024vwxkhahjcSELECT title, managers, participants, computers, oemID, creation, modified, owner FROM indices WHERE indexID=:1
d1fduptwha0n9SELECT mediatype FROM media WHERE mediaID=:1 AND block=0
d4tasbthp4r6zSELECT * FROM medialookaside WHERE mediaID=:1
d86bg3hw9p7nqINSERT INTO attemptdata (attemptdata_pk, attempt_pk, testid, sectionid, activityid, attemptno, userid, questionid, itemscore, params, maxpoints, formulaanswer, recordedvalue, followup, feedback, html, instructorcomment, createdtime, userresponse) VALUES( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 )
dgtyz938v4s3qSELECT EZTO_SEQUENCE.nextval FROM dual
dkmdukk4xfrsqSELECT mediatype, datasize FROM media WHERE mediaID= :1 AND ROWNUM <=1 ORDER BY block
ff1nrgm5dnjrbSELECT datasize, mediatype, data, height, width FROM media WHERE mediaID=:1 ORDER BY block
fkjkrv5ycz96u SELECT sum(blk_read) as blk_read, sum(read_time) as read_time, sum(blk_write) as blk_write, sum(write_time) as write_time, sum(tot_reads) as reads, sum(tot_writes) as writes, sum(sb_reads) as sreads, sum(sb_read_time) as srds_time, count(*) as total_files, block_size FROM ( SELECT df.block_size as block_size, df.filename as file_name, 0 as is_temp, df.ts# as ts#, fs.* FROM ( SELECT endsn.file# as file#, endsn.creation_change# as creation_change#, (endsn.phyblkrd - nvl(startsn.phyblkrd, 0)) as blk_read, (endsn.phyblkwrt - nvl(startsn.phyblkwrt, 0)) as blk_write, (endsn.readtim - nvl(startsn.readtim, 0)) * 10000 as read_time, (endsn.writetim - nvl(startsn.writetim, 0)) * 10000 as write_time, (endsn.phyrds - nvl(startsn.phyrds, 0)) as tot_reads, (endsn.phywrts - nvl(startsn.phywrts, 0)) as tot_writes, (endsn.singleblkrds - nvl(startsn.singleblkrds, 0)) as sb_reads, (endsn.singleblkrdtim - nvl(startsn.singleblkrdtim, 0)) * 10000 as sb_read_time FROM WRH$_FILESTATXS endsn, WRH$_FILESTATXS startsn WHERE startsn.file#(+) = endsn.file# AND startsn.creation_change#(+) = endsn.creation_change# AND startsn.phyblkrd(+) < endsn.phyblkrd AND endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid(+) = :dbid AND startsn.instance_number(+) = endsn.instance_number AND startsn.snap_id(+) = :bid ) fs, WRH$_DATAFILE df WHERE df.dbid = :dbid AND fs.file# = df.file# AND fs.creation_change# = df.creation_change# ) group by block_size order by block_size
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
gacbtcuuq5rwvSELECT * FROM questionbanks WHERE bankID = :1
gs68f01qx915kUPDATE attempt set SUBMISSIONID = :1 , SUBMISSIONTIME = :2 , MAXSCORE = :3 , TOTALCORRECT = :4 , PCTSCORE = :5 , ELAPSEDTIME = :6 , GROUPSCORES = :7 , UPDATEDTIME = :8 , PARAMS = :9 WHERE ATTEMPT_PK = :10

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
active txn count during cleanout48,3064.490.38
application wait time680.010.00
background checkpoints completed30.000.00
background checkpoints started30.000.00
background timeouts102,4479.510.80
Batched IO block miss count2,4090.220.02
Batched IO (bound) vector count260.000.00
Batched IO buffer defrag count80.000.00
Batched IO double miss count270.000.00
Batched IO (full) vector count80.000.00
Batched IO same unit count9830.090.01
Batched IO single block count20.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count1,4270.130.01
Batched IO vector read count420.000.00
Block Cleanout Optim referenced5,3990.500.04
branch node splits420.000.00
buffer is not pinned count29,820,2622,769.03233.51
buffer is pinned count9,283,556862.0572.70
bytes received via SQL*Net from client9,284,070,235862,095.2672,699.92
bytes sent via SQL*Net to client5,681,487,274527,568.5344,489.50
bytes via SQL*Net vector to client529,472,68849,165.494,146.09
Cached Commit SCN referenced368,29134.202.88
calls to get snapshot scn: kcmgss48,346,5564,489.34378.58
calls to kcmgas7,604,570706.1459.55
calls to kcmgcs9,080,734843.2171.11
CCursor + sql area evicted00.000.00
cell physical IO interconnect bytes121,290,041,34411,262,686.20949,774.80
change write time17,7691.650.14
cleanout - number of ktugct calls66,5336.180.52
cleanouts and rollbacks - consistent read gets2,4790.230.02
cleanouts only - consistent read gets199,07918.491.56
cluster key scan block gets3,5040.330.03
cluster key scans2,4690.230.02
cluster wait time187,21417.381.47
commit batch/immediate performed6080.060.00
commit batch/immediate requested6080.060.00
commit cleanout failures: block lost1,1770.110.01
commit cleanout failures: buffer being written30.000.00
commit cleanout failures: callback failure4,8080.450.04
commit cleanout failures: cannot pin190.000.00
commit cleanouts823,13376.436.45
commit cleanouts successfully completed817,12675.886.40
commit immediate performed6080.060.00
commit immediate requested6080.060.00
Commit SCN cached46,0934.280.36
commit txn count during cleanout153,82514.281.20
concurrency wait time110,70410.280.87
consistent changes416,60638.683.26
consistent gets35,695,6033,314.60279.52
consistent gets - examination15,408,6061,430.80120.66
consistent gets direct5910.050.00
consistent gets from cache35,695,0123,314.55279.51
consistent gets from cache (fastpath)16,939,9371,573.00132.65
CPU used by this session2,065,258191.7716.17
CPU used when call started228,53721.221.79
CR blocks created464,98943.183.64
cursor authentications3000.030.00
data blocks consistent reads - undo records applied3,1600.290.02
db block changes11,915,2541,106.4293.30
db block gets700,905,28465,084.295,488.51
db block gets direct1430.010.00
db block gets from cache700,905,14165,084.285,488.51
db block gets from cache (fastpath)1,333,343123.8110.44
DB time1,175,433109.159.20
DBWR checkpoint buffers written699,19864.935.48
DBWR checkpoints500.000.00
DBWR fusion writes232,34021.571.82
DBWR object drop buffers written30.000.00
DBWR transaction table writes65,5216.080.51
DBWR undo block writes152,53014.161.19
deferred (CURRENT) block cleanout applications375,94334.912.94
DFO trees parallelized360.000.00
dirty buffers inspected78,0957.250.61
Effective IO time223,85620.791.75
enqueue conversions6,154,581571.5048.19
enqueue releases15,144,6951,406.30118.59
enqueue requests15,250,5901,416.13119.42
enqueue timeouts105,8959.830.83
enqueue waits679,75563.125.32
exchange deadlocks270.000.00
execute count3,073,273285.3824.07
file io wait time7,585,057,454704,329.2359,395.61
flashback cache read optimizations for block new29,1672.710.23
flashback direct read optimizations for block new20.000.00
flashback log write bytes8,501,420,032789,420.3466,571.29
flashback log writes39,4183.660.31
free buffer inspected4,155,560385.8732.54
free buffer requested6,591,559612.0851.62
gc blocks compressed2,149,913199.6416.84
gc cr block flush time1,2930.120.01
gc cr block receive time35,2263.270.28
gc cr blocks received996,89792.577.81
gc cr blocks served1,003,02993.147.85
gc current block flush time14,6971.360.12
gc current block pin time3,2840.300.03
gc current block receive time83,4377.750.65
gc current blocks received2,010,336186.6715.74
gc current blocks served1,927,505178.9815.09
gc kbytes saved8,955,724831.6170.13
gc kbytes sent14,488,5471,345.37113.45
gc local grants801,74174.456.28
gc read wait time20.000.00
gc read waits30.000.00
gc reader bypass grants6,8110.630.05
gc remote grants2,529,335234.8719.81
gcs messages sent13,985,4411,298.65109.51
ges messages sent2,042,680189.6816.00
global enqueue get time66,6006.180.52
global enqueue gets async5,2970.490.04
global enqueue gets sync4,963,888460.9338.87
global enqueue releases2,734,214253.8921.41
heap block compress121,95211.320.95
Heap Segment Array Inserts3620.030.00
Heap Segment Array Updates3860.040.00
hot buffers moved to head of LRU454,58142.213.56
HSC Heap Segment Block Changes1,797,476166.9114.08
immediate (CR) block cleanout applications201,56618.721.58
immediate (CURRENT) block cleanout applications20,5971.910.16
in call idle wait time63,446,9645,891.52496.83
index crx upgrade (positioned)1,2550.120.01
index crx upgrade (prefetch)220.000.00
index fast full scans (full)690.010.00
index fetch by key777,66872.216.09
index scans kdiixs12,142,904198.9816.78
leaf node splits7,2890.680.06
leaf node 90-10 splits4330.040.00
lob reads7,5050.700.06
lob writes3030.030.00
lob writes unaligned3030.030.00
logical read bytes from cache6,034,228,240,384560,323,158.8847,251,677.63
logons cumulative2600.020.00
max cf enq hold time2,0000.190.02
messages received18,078,0311,678.68141.56
messages sent18,078,0311,678.68141.56
min active SCN optimization applied on CR9500.090.01
no buffer to keep pinned count6650.060.01
no work - consistent read gets10,492,204974.2882.16
non-idle wait count52,337,1594,859.90409.83
non-idle wait time1,409,660130.9011.04
Number of read IOs issued5910.050.00
opened cursors cumulative1,241,973115.339.73
Parallel operations not downgraded360.000.00
parse count (describe)610.010.00
parse count (failures)30.000.00
parse count (hard)5420.050.00
parse count (total)41,0213.810.32
parse time cpu3,0080.280.02
parse time elapsed12,9671.200.10
physical read bytes22,929,080,3202,129,136.35179,548.65
physical read IO requests2,792,939259.3521.87
physical read total bytes35,215,168,0003,269,991.35275,756.19
physical read total IO requests2,851,059264.7422.33
physical read total multi block requests11,0601.030.09
physical reads2,798,960259.9021.92
physical reads cache2,796,369259.6621.90
physical reads cache prefetch8,0570.750.06
physical reads direct2,5910.240.02
physical reads direct (lob)5910.050.00
physical reads direct temporary tablespace00.000.00
physical reads for flashback new1,334,315123.9010.45
physical reads prefetch warmup3,2040.300.03
physical write bytes33,197,416,4483,082,628.05259,955.96
physical write IO requests960,04189.157.52
physical write total bytes86,074,873,3447,992,694.84674,018.62
physical write total IO requests2,233,072207.3617.49
physical write total multi block requests80,9567.520.63
physical writes4,052,419376.3031.73
physical writes direct2,377,111220.7318.61
physical writes direct temporary tablespace2,376,630220.6918.61
physical writes from cache1,675,308155.5613.12
physical writes non checkpoint3,904,230362.5430.57
pinned buffers inspected5420.050.00
pinned cursors current1,9610.180.02
prefetch clients - default80.000.00
prefetch warmup blocks aged out before use43,5644.050.34
prefetched blocks aged out before use250.000.00
process last non-idle time00.000.00
PX local messages recv'd720.010.00
PX local messages sent720.010.00
PX remote messages recv'd4640.040.00
PX remote messages sent4640.040.00
queries parallelized360.000.00
recursive calls1,834,160170.3214.36
recursive cpu usage66,8316.210.52
redo blocks checksummed by FG (exclusive)18,307,9641,700.03143.36
redo blocks written23,385,5802,171.53183.12
redo buffer allocation retries3,4830.320.03
redo entries9,101,573845.1571.27
redo KB read11,230,7561,042.8687.94
redo log space requests3,4850.320.03
redo log space wait time540.010.00
redo ordering marks1,148,129106.618.99
redo size11,432,573,3881,061,599.8289,524.00
redo size for direct writes1,176,736109.279.21
redo subscn max counts253,14323.511.98
redo synch long waits11,8321.100.09
redo synch time30,4792.830.24
redo synch time (usec)304,746,70928,298.012,386.35
redo synch writes127,73711.861.00
redo wastage161,226,15214,971.051,262.50
redo write broadcast ack count4,0330.370.03
redo write broadcast ack time863,891,76780,218.806,764.80
redo write broadcast lgwr post count30.000.00
redo write time88,5888.230.69
redo writes544,44850.564.26
Requests to/from client3,863,980358.8030.26
rollback changes - undo records applied1930.020.00
rollbacks only - consistent read gets820.010.00
RowCR - row contention2700.030.00
RowCR attempts19,2001.780.15
RowCR hits18,9261.760.15
rows fetched via callback8,921,524828.4369.86
securefile allocation bytes9,786,138,624908,716.0676,631.42
securefile allocation chunks601,87155.894.71
securefile bytes non-transformed8,448,192,229784,477.7466,154.48
securefile number of non-transformed flushes262,37424.362.05
segment cfs allocations9,7460.900.08
segment chunks allocation from disepnser572,85853.194.49
segment dispenser allocations251,13923.321.97
segment dispenser load tasks4,4690.410.03
segment prealloc bytes2,986,344,448277,304.3923,384.89
segment prealloc ops84,9317.890.67
segment prealloc tasks78,6497.300.62
segment prealloc time (ms)19,085,2461,772.21149.45
segment prealloc ufs2cfs bytes2,496,315,392231,801.5319,547.67
segment total chunk allocation9,5610.890.07
session connect time00.000.00
session cursor cache hits1,302,361120.9310.20
session logical reads736,600,87468,398.895,768.03
shared hash latch upgrades - no wait201,04118.671.57
shared hash latch upgrades - wait20.000.00
SMON posted for instance recovery00.000.00
SMON posted for undo segment shrink3140.030.00
sorts (memory)96,3988.950.75
sorts (rows)227,45321.121.78
sql area evicted00.000.00
sql area purged260.000.00
SQL*Net roundtrips to/from client3,864,022358.8030.26
summed dirty queue length1,145,190106.348.97
switch current to new buffer8,3930.780.07
table fetch by rowid17,739,4651,647.24138.91
table fetch continued row45,5314.230.36
table scan blocks gotten25,6932.390.20
table scan rows gotten593,02255.074.64
table scans (long tables)230.000.00
table scans (short tables)3,3580.310.03
total cf enq hold time20,5401.910.16
total number of cf enq holders9120.080.01
total number of times SMON posted135,67612.601.06
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks6060.060.00
undo change vector size990,071,18491,935.507,752.86
user calls4,873,410452.5338.16
user commits127,70411.861.00
user I/O wait time704,76565.445.52
workarea executions - optimal93,6468.700.73
write clones created in background200.000.00
write clones created in foreground90.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory34,500,379,96838,914,701,744
opened cursors current8683,874
logons current331338
session uga memory max1,855,509,0082,779,163,624
session pga memory867,644,3361,949,358,032
session pga memory max930,216,8482,170,838,288
session cursor cache count8,25410,952

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)41.34

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)
Others11.4G5.161.0842026.9G7.352.5618497.4K1.27
LGWR1M0.01.00009222.3G110.882.12105544.7K1.08
Buffer Cache Reads21.3G259.142.028740M0.000M2788.7K2.11
Direct Writes0M0.000M18.1G14.721.724270 
DBWR46M0.27.00427112.8G74.331.2145729540.06
Direct Reads20M0.23.0018572M0.03.0001850 
TOTAL:32.8G264.813.1191780.2G207.317.621923433.6K1.92

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
Data File21.4G259.452.0312512.8G74.401.216712.1112.44
Log File11.4G1.091.0848522.3G110.912.122812.670.00
Temp File0M0.000M18.1G14.711.72417  
Flashback Log0M0.000M15.9G4.431.514046.88 
Archive Log0M0.000M11.4G1.081.08373  
Control File752M4.38.069828324M1.93.0300850.4513.55
TOTAL:33.5G264.923.1859380.9G207.467.691562.080.10

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 12.1G5.231.1526327.7G7.432.6301892.3K1.42
Others (Flashback Log) 0M0.000M15.9G4.431.5141347.7K2.28
Others (Log File) 11.4G1.091.086980M0.000M291.79
Others (Archive Log) 0M0.000M11.4G1.091.086240 
Others (Control File) 704M4.10.065371321M1.91.02980744.2K0.48
Others (Data File) 3M0.04.0002780M0.000M3982.78
LGWR 1M0.01.00009222.3G110.922.123091002.14
LGWR (Log File) 0M0.000M22.3G110.912.12290324.41
LGWR (Control File) 1M0.01.0000922M0.01.000185681.07
Buffer Cache Reads 21.4G259.362.030510M0.000M2791K2.13
Buffer Cache Reads (Data File) 21.4G259.362.030510M0.000M2791K2.13
Direct Writes 0M0.000M18.1G14.721.724270 
Direct Writes (Data File) 0M0.000M18.1G14.721.724270 
DBWR 0M0.000M12.8G74.421.216150 
DBWR (Data File) 0M0.000M12.8G74.421.216150 
Direct Reads 20M0.23.0018572M0.03.0001850 
Direct Reads (Data File) 20M0.23.0018572M0.03.0001850 
TOTAL: 33.5G264.833.1851080.9G207.527.693892883.4K2.11

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EZTO_LOB 2,576,7112392.351.00588,947556260.88
UNDOTBS3 134,268122.651.0081,04785,1293.13
TEMP 000.00 158,4421500.00
EZTO_DATA 36,96938.391.0567,625620.00
EZTO_INDEX 13,87517.651.0357,3425691.74
SYSAUX 29,92531.791.014,931000.00
SYSTEM 71104.121.68304050.00
EZTO_LOB_MANUAL 7300.001.009000.00
UNDOTBS2 2300.001.00701,4636.24
UNDOTBS4 300.001.00102,0005.05
UNDOTBS1 100.001.00101,8114.58
USERS 100.001.001000.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)
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.304.813959451 5807.931.0041000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.316.813959497 5407.781.0027000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.321.813959571 5008.401.0015000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.325.813959657 17010.001.0012000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.328.813959053 2008.001.0047000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.329.813959089 4807.081.0020000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.333.813958673 33908.471.00562000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.334.813958733 61708.301.13950000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.335.813958789 87309.211.051,487000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.336.813958889 1,05308.191.061,536000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.337.813958923 43508.281.06841000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.338.813958979 12008.251.00257000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.339.813958337 43408.641.08776000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.340.813958291 41907.711.00680000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.341.813958195 43607.801.03795000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.342.813958141 36307.161.00625000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.343.813958113 75407.641.061,571000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.344.813958015 2,41908.111.054,521000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.345.813957977 5,99018.211.059,933100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.346.813957901 6,34618.121.069,474110.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.347.813957523 2,50008.111.064,065000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.348.813957523 88308.311.121,370000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.349.813957399 20708.161.14335000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.350.813957319 6707.161.00100000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.351.813957275 1506.671.0022000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.352.813957085 500.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.353.813957085 500.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.358.813956627 700.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.359.813956627 700.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.360.813956509 700.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.361.813956439 700.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.428.813950183 900.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.429.813950069 900.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.430.813950033 900.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.431.813949977 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.432.813949915 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.433.813949901 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.434.813949567 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.435.813949541 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.436.813949465 1000.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.437.813949341 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.438.813949153 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.439.813949117 12805.551.001,831000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.440.813949055 900.001.0030000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.441.813948941 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.442.813948925 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.443.813948855 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.444.813948839 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.445.813948805 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.446.813948513 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.447.813948511 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.581.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.582.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.584.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.611.813964757 2808.931.0034000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.612.813964829 64108.531.001,453000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.617.813965575 8,30719.031.0518,143210.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.619.813965599 2,56809.261.085,308000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.620.813965653 30008.131.05437000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.621.813965689 18109.781.03249000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.622.813965729 205.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.623.813965743 708.571.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.624.813965799 1808.891.787000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.634.813966737 907.781.337000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.636.813966819 1106.361.005000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.637.813967121 11012.731.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.638.813967189 306.671.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.639.813967493 4010.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.640.813967621 300.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.680.813970465 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.683.813970633 802.501.0021000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.298.813959857 9108.791.00239000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.299.813960597 22108.821.072,990061.67
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.302.813959711 4303.261.0051000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.303.813959883 7008.141.00102000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.305.813959771 4308.841.0072000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.306.813960601 33407.901.093,411040.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.315.813960647 47006.701.103,7520120.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.317.813960159 6908.261.00112000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.318.813960243 3106.771.0094000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.319.813960269 15010.002.2011000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.320.813960377 2,41405.581.036,740100.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.322.813960701 69007.651.024,267040.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.323.813960703 24908.071.002,348010.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.326.813960441 23607.841.001,5080110.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.331.813960573 98206.841.045,587130.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.427.813950305 3406.761.0039000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.583.813930683 2108.101.0049000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.585.813930683 4509.111.0047000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.586.813930683 2,86508.591.028,1201146.43
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.587.813930683 1,59008.991.036,0531110.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.588.813930683 75208.401.043,287020.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.649.813967997 2,61007.751.038,4631110.91
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.277.813963385 67205.671.00718080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.278.813963293 5,68211.331.00689070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.279.813963217 17,31320.901.00600060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.280.813963173 42,96340.801.00682074.29
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.281.813963093 32,16830.791.00483040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.282.813962941 16,84621.001.00594070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.283.813962937 16,72320.951.00448010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.284.813962933 65101.631.25154040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.285.813962919 2,18101.371.00294025.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.286.813962777 3,85601.631.01411070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.287.813961529 9,14611.001.00574030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.307.813961503 1,00001.141.08132000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.308.813961481 2,41000.911.0796000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.309.813961455 60401.391.0971025.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.310.813961447 74400.931.0036000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.311.813961441 22800.921.3413000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.312.813961361 200.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.313.813961275 3801.583.8418000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.314.813961143 3802.373.8418000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.327.813961001 2007.503.409000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.330.813961111 1903.163.588000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.332.813960835 200.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.354.813957039 700.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.355.813956965 700.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.356.813956921 2204.092.952000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.357.813956683 1402.862.505000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.362.813956257 8404.641.00103010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.363.813956255 4109.511.0068000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.364.813956085 3407.351.0086000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.365.813956051 3809.741.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.366.813956021 2906.901.0035000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.367.813955945 3207.811.0032000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.368.813955909 3208.751.0023000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.372.813963441 1,27603.131.00610082.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.374.813955661 23002.301.0023000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.375.813955617 39010.261.0028000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.376.813955601 3007.671.0022000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.377.813955491 5306.791.0039000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.378.813955445 2607.311.0018000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.379.813955209 40011.251.0046000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.380.813955209 3006.331.0021000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.381.813955073 3708.111.0057000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.382.813955049 3608.891.0027000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.383.813955033 5,06700.721.0049000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.384.813955005 5,82510.831.00134010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.385.813954953 4,65600.811.0077000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.386.813954697 4,13900.751.0080010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.387.813954641 8,30910.781.0034010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.388.813954551 8,10410.691.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.389.813954459 5,61110.741.0034000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.390.813954401 5,03900.881.0037000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.391.813954053 6,09710.881.0044000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.392.813953999 9,97610.791.0030000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.393.813953881 4,49900.901.0047010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.394.813953847 900.001.0013000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.395.813953839 900.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.396.813953803 38602.051.0052000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.397.813953755 900.001.0011000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.398.813953409 28901.491.0057010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.399.813953343 19702.181.0060020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.400.813953257 66101.231.00108030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.401.813953157 26700.561.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.402.813953077 42501.791.0076000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.403.813952647 2705.931.0030000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.404.813952647 81017.041.0082010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.405.813952521 56901.621.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.406.813952521 23802.981.00138000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.407.813952487 49501.171.0083000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.408.813952435 7106.621.0062000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.409.813952381 49401.361.0047000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.410.813952043 37102.101.0049000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.411.813952007 1,40600.971.0053000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.412.813951931 1,72501.011.0050000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.413.813951819 1,65200.781.0046000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.414.813951723 1,19400.831.0070000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.415.813951297 1,53200.841.0025000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.416.813951283 76601.121.00103000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.417.813951223 1,50400.961.0077000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.418.813951177 2,40400.761.0059000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.419.813951135 56601.331.0071000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.420.813951051 34301.521.0053000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.421.813951025 1,15900.851.0097000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.422.813950699 7205.831.00101000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.423.813950673 1,73500.881.0099000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.424.813950607 26202.371.0076000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.425.813950455 1,13601.021.0066000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.426.813950379 33002.301.0055010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.448.813948277 76401.221.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.449.813948187 30701.731.0079000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.450.813947987 1,13600.811.0039010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.451.813947979 2907.931.0078000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.452.813947939 57801.421.0065000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.453.813947873 4508.001.00103000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.454.813947825 40901.611.00108000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.455.813947707 60501.191.0063000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.456.813947691 35702.241.00109000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.457.813947691 36002.081.0075000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.458.813947407 11307.611.00137000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.459.813947383 65001.541.00129030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.460.813947197 8707.011.00115000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.461.813947061 8005.881.00111000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.462.813946815 23602.461.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.463.813946815 7209.031.0079000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.464.813946763 40601.971.0078000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.465.813946683 23402.991.0097000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.466.813946639 7506.801.00105000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.467.813946501 95101.471.00105000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.468.813946487 44902.691.00107000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.469.813946471 35902.591.00101000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.470.813946199 59201.401.0059000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.471.813946119 67901.301.0060000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.472.813945975 16102.921.0068020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.473.813945845 36001.641.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.474.813945809 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.475.813945777 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.476.813945753 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.477.813945677 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.478.813945635 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.479.813945499 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.480.813945463 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.481.813945463 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.482.813945201 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.483.813945089 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.484.813944999 4,04704.161.001,542000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.485.813944841 92303.411.00348000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.486.813944825 11,79114.181.004,526000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.487.813944759 17,38824.311.006,721100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.488.813944759 24,11624.341.009,303100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.489.813944681 27,72934.291.0011,289100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.490.813944637 26,08024.381.0010,398100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.491.813944501 25,62324.581.0010,808100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.492.813944451 15,73215.011.007,007100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.493.813944435 11,15415.261.005,149000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.494.813944189 11,10915.361.005,064000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.495.813944045 9,66315.121.004,282000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.496.813943995 21,01622.591.004,2350110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.497.813943829 29,76132.041.004,731010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.498.813943801 70,51971.471.006,144110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.499.813943745 72,58771.511.007,384100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.500.813943711 60,58361.991.008,699110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.501.813943681 93,86691.861.0011,206110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.502.813943651 89,14182.031.0013,111110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.503.813943507 59,62262.151.009,541120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.504.813943451 94,61892.941.0027,343310.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.505.813943405 66,93465.081.0038,819410.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.506.813943213 45,41945.851.0031,679310.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.507.813943029 39,81846.331.0028,852300.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.508.813943027 30,53536.571.0023,393200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.509.813942881 24,28326.621.0018,909200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.510.813942815 19,14526.941.0015,472100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.511.813942745 21,74926.831.0017,258200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.512.813942737 15,27517.141.0012,400100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.513.813942723 12,27517.141.0010,263100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.514.813942707 9,14017.041.007,474100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.515.813942561 10,74316.891.008,617100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.516.813942347 7,78716.851.006,283100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.517.813942313 7,51217.041.006,183100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.518.813942081 16,46623.211.005,336030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.519.813941969 4,88507.211.004,145000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.520.813941903 15,47413.321.005,5791102.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.521.813941733 12,07213.701.004,6930210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.522.813941663 12,37113.591.004,871030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.523.813941609 14,02012.951.004,138063.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.524.813941583 25,91821.851.003,879040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.525.813941581 19,98222.221.003,859030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.526.813941565 16,12312.461.003,673072.86
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.527.813941431 28,40831.661.003,3440101.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.528.813941165 35,39731.421.002,936082.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.529.813940979 21,07221.671.002,715061.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.530.813940819 20,97221.631.002,644061.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.531.813940811 43,37141.221.002,7730110.91
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.532.813940607 72,28171.041.002,479052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.533.813940523 50,60851.181.002,439010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.534.813940481 18,48521.511.002,008040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.535.813940463 9,97212.231.001,979092.22
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.536.813940437 11,94511.941.002,083052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.537.813940423 21,57321.411.001,890090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.538.813940279 12,55911.771.001,8080110.91
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.539.813940047 4,32903.321.001,566000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.540.813939721 4,65203.001.001,585060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.541.813939403 27,90331.151.004,1280352.29
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.542.813939387 2004.503.456000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.543.813939261 76,93170.861.0011,5311260.77
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.544.813939237 62,41960.921.008,3681470.64
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.545.813938401 2,24605.041.001,275010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.546.813938341 95,68490.881.0015,3181381.05
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.547.813938325 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.548.813938319 53,17850.901.0018,2682440.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.549.813938303 2,60105.511.001,514000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.550.813938207 106,920100.651.006,5631120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.551.813938191 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.552.813938079 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.553.813937743 4304.193.562000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.554.813937633 2205.453.598000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.555.813937633 1909.473.682000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.556.813937587 5605.543.755000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.557.813935445 2107.623.573000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.558.813935373 1906.323.586000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.559.813935373 200.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.560.813935373 3303.943.524000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.561.813935197 1202.503.331000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.562.813935181 1005.003.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.563.813935181 1406.433.293000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.564.813935135 9704.433.9226000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.565.813934533 1705.293.653000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.566.813934531 402.502.502000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.567.813934505 2203.183.553000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.568.813934439 904.443.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.569.813932221 15010.673.332000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.570.813932219 3307.883.769000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.571.813932195 903.333.335000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.572.813932077 15011.333.531000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.573.813932061 14010.003.574000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.574.813932053 1607.503.692000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.575.813932007 306.672.671000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.576.813931931 902.223.442000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.577.813931235 6703.433.8513000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.578.813931235 1106.363.552000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.579.813931233 100.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.580.813931231 4903.273.8022000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.602.813963443 1,54003.051.007810111.82
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.603.813964375 1,68302.651.00615074.29
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.604.813964415 1,76602.891.00995071.43
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.605.813964431 2,49802.251.008700210.48
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.606.813964501 7,64611.161.00658040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.607.813964515 11,72611.031.008130120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.608.813964517 2,07002.121.03481030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.609.813964531 9,40111.141.007830140.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.610.813964633 9,59811.161.00817080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.613.813964829 7,17711.391.00779040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.614.813964989 6,71211.261.00824070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.615.813965537 12,61811.111.00798060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.616.813965541 15,20410.981.00765010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.618.813965583 1,66602.391.00521052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.625.813965939 64003.381.00343010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.626.813966075 1,05103.291.00588020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.627.813966441 2,79701.441.00680050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.628.813966465 61604.871.00450020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.629.813966547 2,76601.821.00428020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.630.813966601 93803.141.00450000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.631.813966673 3,41801.481.00460060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.632.813966679 5,48411.301.00530000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.633.813966697 14,71810.931.00465010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.635.813966761 23,68220.921.00445045.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.641.813967621 3,70001.391.00433042.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.642.813967681 7,42811.131.00455000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.643.813967757 7,07411.141.00523010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.644.813967757 9,90010.961.00368000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.645.813967767 11,20310.961.00337020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.646.813967769 13,71710.901.00243000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.647.813967891 5,83311.011.00405030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.648.813967981 3,71401.171.00352030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.650.813968021 6,96611.131.00337000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.651.813968357 3,74101.501.00282000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.652.813968501 4,44501.331.00535000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.653.813968795 7,50011.071.00334010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.654.813968829 4,21001.481.00327000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.655.813968865 4,46801.361.00410030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.656.813968891 5,41411.281.00424000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.657.813968899 3,80001.401.00335000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.658.813968943 3,22701.181.00151000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.659.813968967 2,16501.501.00414000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.660.813969061 2,05903.871.00918040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.661.813969097 6,63212.221.001,474033.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.662.813969097 7,84712.311.001,596000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.663.813969469 12,98111.911.001,825000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.664.813969661 6,16313.851.002,391030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.665.813969945 4,59004.121.002,138000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.666.813970041 2200.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.667.813970041 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.668.813970107 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.669.813970169 5100.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.670.813970171 37100.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.671.813970175 6700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.672.813970209 5100.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.673.813970237 700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.674.813970385 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.675.813970409 4300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.676.813970427 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.677.813970429 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.678.813970435 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.679.813970463 5,24505.111.002,632000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.681.813970561 4,66406.591.003,639000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.682.813970589 13007.621.001100160.63
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.684.813970649 5,35706.441.003,939030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.713.816189311 300.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.685.813970653 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.686.813970653 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.687.813970889 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.688.813971075 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.689.813971145 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.693.813971299 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.696.813971335 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.698.813971447 900.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.699.813971519 900.001.001000.00
SYSAUX+EZTOPQA_DF/eztopqa_va/datafile/sysaux.697.813971341 29,92531.791.014,931000.00
SYSTEM+EZTOPQA_DF/eztopqa_va/datafile/system.694.813971299 71104.121.68304050.00
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.292.814111801 00  36800 
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.293.814111793 00  106,016100 
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.294.814111787 00  52,05850 
UNDOTBS1+EZTOPQA_DF/eztopqa_va/datafile/undotbs1.690.813971153 100.001.00101,8114.58
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.589.813930683 700.001.002010.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.590.813930683 700.001.002000.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.591.813930683 200.001.00101,4626.24
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.592.813930683 700.001.002000.00
UNDOTBS3+EZTOPQA_DF/eztopqa_va/datafile/undotbs3.691.813971193 134,268122.651.0081,04785,1293.13
UNDOTBS4+EZTOPQA_DF/eztopqa_va/datafile/undotbs4.692.813971243 300.001.00102,0005.05
USERS+EZTOPQA_DF/eztopqa_va/datafile/users.695.813971333 100.001.001000.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
D483,712100735,828,3612,703,5061,589,0150011,083
R483,71288762,27492,80586,2430022

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000698,7070

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
B00644263522266633973830222666  0
E048338947567824939708339738304939708  20

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
D3840.09452.637,670118939.00
D7680.19912.126,184115263.00
D1,1520.281361.835,324113133.00
D1,5360.381811.634,745111700.00
D1,9200.472271.494,353110730.00
D2,3040.562721.353,94319716.00
D2,6880.663171.253,63618954.00
D3,0720.753631.163,37018298.00
D3,4560.844081.083,14317737.00
D3,8400.944531.032,99217362.00
D4,0961.004841.002,91617173.00
D4,2241.034990.992,89617125.00
D4,6081.135440.972,84116989.00
D4,9921.225900.962,79416872.00
D5,3761.316350.942,73816732.00
D5,7601.416800.912,65716533.00
D6,1441.507260.892,58116345.00
D6,5281.597710.872,54516255.00
D6,9121.698160.872,52516207.00
D7,2961.788620.862,51016168.00
D7,6801.889070.862,49616135.00
R3840.09451.002711212.00
R7680.19911.002701212.00
R1,1520.281361.002701212.00
R1,5360.381811.002701212.00
R1,9200.472271.002701211.00
R2,3040.562721.002701211.00
R2,6880.663171.002701211.00
R3,0720.753631.002701211.00
R3,4560.844081.002701211.00
R3,8400.944531.002701211.00
R4,0961.004841.002701211.00
R4,2241.034991.002701211.00
R4,6081.135441.002701211.00
R4,9921.225901.002701211.00
R5,3761.316351.002701211.00
R5,7601.416801.002701211.00
R6,1441.507261.002701211.00
R6,5281.597711.002701211.00
R6,9121.698161.002701211.00
R7,2961.788621.002701211.00
R7,6801.889071.002701211.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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)
B8,1926,644949.710.000.000.000.00838,860
E8,1925,7832,027.940.000.000.000.00838,860

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K93,43093,43000
64K128K565600
128K256K2200
256K512K2200
512K1024K11811800
1M2M353500

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,0240.13442.160.00100.004484,123
2,0480.25442.160.00100.00084,123
4,0960.50442.160.00100.00084,123
6,1440.75442.160.00100.00084,123
8,1921.00442.160.00100.00084,123
9,8301.20442.160.00100.00084,123
11,4691.40442.160.00100.00084,123
13,1071.60442.160.00100.00084,123
14,7461.80442.160.00100.00084,123
16,3842.00442.160.00100.00084,123
24,5763.00442.160.00100.00084,123
32,7684.00442.160.00100.00084,123
49,1526.00442.160.00100.00084,123
65,5368.00442.160.00100.00084,123

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)
2,4320.79533,47962,3151.001641.002,691
2,7520.90533,47962,3151.001641.002,691
2,7840.91533,47962,3151.001641.002,691
2,8160.92533,47962,3151.001641.002,691
2,8480.93533,47962,3151.001641.002,691
2,8800.94533,47962,3151.001641.002,691
2,9120.95533,47962,3151.001641.002,691
2,9440.96533,47962,3151.001641.002,691
2,9760.97533,47962,3151.001641.002,691
3,0080.98533,47962,3151.001641.002,691
3,0400.99533,47962,3151.001641.002,691
3,0721.00533,47962,3151.001641.002,691
3,1041.01533,47962,3151.001641.002,691
3,1361.02533,47962,3151.001641.002,691
3,1681.03533,47962,3151.001641.002,691
3,2001.04533,47962,3151.001641.002,691
3,2321.05533,47962,3151.001641.002,691
3,2641.06533,47962,3151.001641.002,691
3,2961.07533,47962,3151.001641.002,691
3,3281.08533,47962,3151.001641.002,691
3,3601.09533,47962,3151.001641.002,691
3,3921.10533,47962,3151.001641.002,691
3,7121.21533,47962,3151.001641.002,691
4,0321.31533,47962,3151.001641.002,691
4,3521.42533,47962,3151.001641.002,691
4,6721.52533,47962,3151.001641.002,691
4,9921.63533,47962,3151.001641.002,691
5,3121.73533,47962,3151.001641.002,691
5,6321.83533,47962,3151.001641.002,691
5,9521.94533,47962,3151.001641.002,691
6,2722.04533,47962,3151.001641.002,691

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

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header10,371444
2nd level bmb36401
3rd level bmb12801
data block9201
free list8301
file header block1001
undo block3200
1st level bmb2000
segment header500

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CR-Reuse Block Range (block range reuse ckpt) 3,507,4713,507,3720656,7645550.85
DW-In memory Dispenser 441,155335,271105,88314,71170.47
WF-AWR Flush 104104069224.35
XR-Quiesce / Force Logging (database force logging) 3,5813,58103,58110.41
FB-Format Block 1,8341,83401,34610.49
TX-Transaction (index contention) 321321024701.74
HW-Segment High Water Mark 6,9016,901073300.48
TX-Transaction 361,795361,79408603.37
TX-Transaction (row lock contention) 11010280.00
PS-PX Process Reservation 539539030500.89
TM-DML 526,077526,020037000.57
CF-Controlfile Transaction 24,69324,690378700.23
RO-Multiple Object Reuse (fast object reuse) 470470014100.92
US-Undo Segment 324324018100.61
SQ-Sequence Cache 14714709011.11
TA-Instance Undo 646406401.25
TS-Temporary Segment 949407900.38
PI-Remote PX Process Spawn Status 181801801.11
AF-Advisor Framework (task serialization) 464601601.25
JQ-Job Queue 10641001.00
JS-Job Scheduler (job run lock - synchronize) 972901.11
TX-Transaction (allocate ITL entry) 330303.33
TD-KTF map table enqueue (KTF dump entries) 343403300.00
TK-Auto Task Serialization (Auto Task Serialization) 151501300.00
DR-Distributed Recovery 660600.00
MW-MWIN Schedule 660600.00
WL-Being Written Redo Log 431300.00
FL-Flashback database log (Flashback database log) 440200.00
PD-Property Lock 440200.00
TT-Tablespace 53,20553,2050200.00
PE-Parameter 220100.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 532100.00
RS-Reclaimable Space (prevent aging list update) 110100.00
WP-AWR Purge 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
6147.79361,2561,9001438.5/44.70/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
15-Jul 23:599,77021,0161,88810430/00/0/0/0/0/0
15-Jul 23:4910,32921,7951,70511420/00/0/0/0/0/0
15-Jul 23:396,06713,8091,8209420/00/0/0/0/0/0
15-Jul 23:298,91220,2101,61311400/00/0/0/0/0/0
15-Jul 23:1912,22326,3561,71312420/00/0/0/0/0/0
15-Jul 23:0914,77527,1701,80912420/00/0/0/0/0/0
15-Jul 22:5911,91727,6251,60712420/00/0/0/0/0/0
15-Jul 22:4912,63133,4041,55512410/00/0/0/0/0/0
15-Jul 22:399,65332,2201,79614420/00/0/0/0/0/0
15-Jul 22:2912,10041,7021,59810430/00/0/0/0/0/0
15-Jul 22:1919,73134,6831,78811430/00/0/0/0/0/0
15-Jul 22:097,79919,0081,78614430/00/0/0/0/0/0
15-Jul 21:596,21720,7829868390/00/0/0/0/0/0
15-Jul 21:493,44613,4035797380/00/0/0/0/0/0
15-Jul 21:392,1137,5841,81810450/00/0/0/0/0/0
15-Jul 21:290551,9000450/00/0/0/0/0/0
15-Jul 21:192891,8972450/00/0/0/0/0/0
15-Jul 21:091083451,5615430/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
active checkpoint queue latch19,330,68110.410.0010 
active service list56,3560.00 05,2490.00
alert log latch60.00 00 
AQ deq hash table latch30.00 00 
archive control1890.00 00 
archive process latch8850.00 00 
ASM allocation1,7230.00 00 
ASM db client latch1,929,0420.00 00 
ASM Keyed state latch2360.00 00 
ASM map headers2,3110.00 00 
ASM map load waiting list4940.00 00 
ASM map operation freelist1,3340.00 00 
ASM map operation hash table12,170,2740.070.0000 
ASM network background latch8,0600.00 00 
ASM network SGA latch90.00 00 
ASM network state latch2,0510.00 00 
ASM scan context latch120.00 00 
AWR Alerted Metric Element list175,8320.00 00 
begin backup scn array100.00 00 
buffer pool30.00 00 
business card750.00 00 
cache buffer handles29,7740.00 00 
cache buffers chains1,509,536,4610.010.0109,244,1610.02
cache buffers lru chain26,440,1330.040.00013,115,3420.02
cache table scan latch0  01,2080.00
call allocation2,1290.280.0000 
cas latch30.00 00 
change notification client cache latch30.00 00 
Change Notification Hash table latch3,5850.00 00 
channel handle pool latch4100.00 00 
channel operations parent latch220,502,2420.010.0100 
checkpoint queue latch1,127,281,1920.000.0102,543,4560.01
client/application info7830.00 00 
compile environment latch2790.00 00 
Consistent RBA544,4930.000.1300 
corrupted undo seg latch1,1850.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1750.00 00 
cvmap freelist lock30.00 00 
database property service latch80.00 00 
deferred cleanup latch1750.00 00 
DML lock allocation1,052,3560.000.3300 
dml lock allocation1750.00 00 
done queue latch30.00 00 
dummy allocation5540.00 00 
enqueue freelist latch30.00 028,721,4580.00
enqueue hash chains42,754,5290.170.0007010.14
enqueues2,7820.00 00 
error message lists2880.00 00 
Event Group Locks4030.00 00 
FAL Queue2940.00 00 
fast space usage latch619,5560.000.0000 
FIB s.o chain latch540.00 00 
fifth spare latch30.00 00 
file cache latch25,9060.00 00 
File State Object Pool Parent Latch8,045,4520.040.0100 
flashback allocation1,142,0360.000.0600 
flashback copy30.00 01,066,1600.03
flashback mapping39,6220.740.0100 
flashback prepare log info140.00 00 
flashback sync request69,8120.440.0000 
FOB s.o list latch29,8162.090.0200 
fourth Audit Vault latch30.00 00 
gc element30,522,2990.030.110841,6770.02
gcs commit scn state30.00 00 
gcs opaque info freelist4,069,2160.050.0000 
gcs partitioned table hash75,400,7650.400.000134,8430.01
gcs pcm hashed value bucket hash30.00 00 
gcs remaster request queue530.00 00 
gcs remastering latch949,20126.090.0000 
gcs resource freelist1,677,3590.000.0001,186,1500.00
gcs resource hash35,502,3990.040.0104800.00
gcs resource scan list1,2950.00 00 
gcs shadows freelist2,473,9450.000.0002,645,9560.00
ges caches resource lists1,295,6370.390.0102,205,5270.03
ges deadlock list2,2080.00 00 
ges DFS wait callback info10.00 00 
ges domain table5,570,3110.000.0000 
ges enqueue table freelist5,676,4070.000.0000 
ges group table9,773,5580.000.0000 
ges process hash list142,691,1230.000.0700 
ges process parent latch15,041,2850.000.3300 
ges process table freelist2360.00 00 
ges resource hash list17,484,4270.050.0808362.87
ges resource scan list8330.00 00 
ges resource table freelist8,9490.00 00 
ges timeout list5,9220.00 04810.21
ges value block free list2860.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch6080.00 025,6410.00
hash table modification latch1,3830.00 00 
heartbeat check30.00 06,2760.00
heartbeat structure management0  02,1530.00
In memory undo latch30.00 00 
internal temp table object number allocation latch510.00 00 
interrupt manipulation1,1620.00 00 
intra txn parallel recovery30.00 00 
io pool granule metadata list30.00 00 
I/O Staticstics latch30.00 00 
IPC other latch920.00 00 
IPC stats buffer allocation latch1,2430.00 04,2710.00
job workq parent latch220.00 0190.00
job_queue_processes free list latch410.00 00 
job_queue_processes parameter latch2,3610.00 00 
JS broadcast add buf latch2,4890.00 00 
JS broadcast drop buf latch2,4890.00 00 
JS broadcast kill buf latch10.00 00 
JS broadcast load blnc latch2,1590.00 00 
JS mem alloc latch560.00 00 
JS queue access latch590.00 00 
JS queue state obj latch78,6580.00 00 
JS Sh mem access210.00 00 
JS slv state obj latch760.00 00 
kcbtsemkid latch30.00 00 
kdlx hb parent latch30.00 00 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KFK SGA Libload latch16,9920.00 00 
KFMD SGA140.00 00 
kgb parent30.00 00 
kgnfs mount latch30.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list1,917,9320.160.020141,0130.04
KJCT flow control latch27,188,5980.010.0100 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
KMG MMAN ready and startup request latch3,5880.00 00 
kokc descriptor allocation latch160.00 00 
ksfv messages30.00 00 
ksim group membership cache1,365,4460.000.0000 
ksim membership request latch0  010,5550.00
kss move lock1290.00 00 
ksuosstats global area1,0860.00 00 
ksv allocation latch4260.00 00 
ksv class latch30,1440.030.0000 
ksv instance latch780.00 00 
ksv msg queue latch750.00 0720.00
ksxp shared latch2360.00 00 
ksxp so latch2360.00 00 
KSXR large replies200.00 00 
ksz_so allocation latch2360.420.0000 
KTF sga latch1030.00 03,5810.00
ktm global data535,9390.020.0100 
kwqbsn:qsga3740.00 00 
KWQMN job cache list latch7570.00 00 
k2q global data latch7,1780.00 00 
k2q lock allocation30.00 00 
lgwr LWN SCN548,1300.030.0000 
list of block allocation7,7680.00 00 
loader state object freelist1,2360.00 00 
lob segment dispenser latch1,267,1170.000.0000 
lob segment hash table latch1,226,6490.000.0000 
lob segment query latch5200.00 00 
Locator state objects pool parent latch30.00 00 
lock DBA buffer during media recovery30.00 00 
logical standby cache30.00 00 
logminer context allocation30.00 00 
logminer work area30.00 00 
longop free list parent30.00 00 
Lsod array latch6,2330.050.0000 
managed standby latch2910.00 00 
mapped buffers lru chain30.00 00 
Memory Management Latch30.00 03,5880.00
Memory Queue30.00 00 
Memory Queue Message Subscriber #130.00 00 
Memory Queue Message Subscriber #230.00 00 
Memory Queue Message Subscriber #330.00 00 
Memory Queue Message Subscriber #430.00 00 
Memory Queue Subscriber30.00 00 
message pool operations parent latch4,793,6760.010.0300 
messages60,285,8918.080.0010 
MinActiveScn Latch14,5840.00 00 
mostly latch-free SCN564,0201.580.0100 
MQL Tracking Latch0  02140.00
msg queue latch30.00 00 
multiblock read objects173,5840.000.0000 
Mutex30.00 00 
Mutex Stats30.00 00 
name-service memory objects35,7050.00 00 
name-service namespace bucket4,171,2020.010.0000 
name-service namespace objects360.00 00 
name-service pending queue11,0380.00 00 
name-service request1120.00 00 
name-service request queue130,4940.00 00 
ncodef allocation latch1750.00 00 
object queue header heap283,875,5570.000.0003,350,7300.18
object queue header operation395,370,2860.010.0100 
object stats modification60,5610.030.0500 
OS process1,0640.00 00 
OS process allocation22,1440.000.0000 
OS process: request allocation2360.00 00 
parallel query alloc buffer7,6280.00 00 
parallel query stats2530.00 00 
parallel txn reco latch66,4320.00 00 
parameter list930.00 00 
parameter table management5710.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
PL/SQL warning settings7640.00 00 
post/wait queue2,947,4380.170.0003,235,1820.63
process allocation17,5360.00 01210.00
process group creation2360.00 00 
process queue9200.00 00 
process queue reference15,5700.00 01,4510.00
PX hash array latch30.00 00 
qmn task queue latch1,5230.00 00 
QMT30.00 00 
query server freelists6840.00 00 
query server process550.00 0190.00
queued dump request360.00 00 
queuing load statistics30.00 00 
Real-time plan statistics latch2,0450.00 00 
recovery domain hash list30.00 00 
redo allocation2,804,0140.140.0209,090,7690.43
redo copy30.00 09,104,7010.28
redo writing19,222,0595.250.0000 
reservation so alloc latch40.00 00 
Reserved Space Latch110.00 00 
resmgr group change latch1,365,1080.000.0000 
resmgr:active threads36,1960.011.0003,6040.00
resmgr:actses change group3110.00 00 
resmgr:actses change state450.00 00 
resmgr:free threads list6170.160.0000 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method46,1400.150.0100 
resmgr:schema config1,740,6251.420.90601200.83
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects1,581,536,64028.390.03108020.00
second Audit Vault latch30.00 00 
second spare latch30.00 00 
segmented array pool460.00 00 
sequence cache1,480,1490.050.0100 
session allocation129,4590.000.000128,9740.00
session idle bit9,876,2820.000.0300 
session queue latch30.00 00 
session state list latch6520.00 00 
session switching2930.00 00 
session timer3,5870.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA IO buffer pool latch360.00 0360.00
SGA pool locks30.00 00 
Shared B-Tree3770.00 00 
shared pool10,376,8010.030.0200 
shared pool sim alloc310.00 00 
shared pool simulator1,0570.00 00 
sim partition latch30.00 00 
simulator hash latch50,409,5420.000.0000 
simulator lru latch30.00 050,195,5370.01
sort extent pool156,1450.00 00 
space background state object latch200.00 00 
space background task latch2,061,00411.880.05361,2550.09
SQL memory manager latch30.00 03,5810.00
SQL memory manager workarea list latch241,0350.00 00 
state object free list60.00 00 
statistics aggregation1,6800.00 00 
Streams Generic30.00 00 
tablespace key chain1640.00 00 
temp lob duration state obj allocation100.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
Testing30.00 00 
third spare latch30.00 00 
threshold alerts latch5520.00 00 
Token Manager30.00 00 
transaction allocation2,270,4820.000.0000 
undo global data689,421,6540.020.0000 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 
WCR: sync30.00 00 
Write State Object Pool Parent Latch30.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
X$KSFQP550.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects1,581,536,640449,009,95213,254,394438,784,730
messages60,285,8914,872,7476,1844,866,576
active checkpoint queue latch19,330,6812,012,8704,8542,008,021
redo writing19,222,0591,009,0532,5681,006,485
space background task latch2,061,004244,77013,235231,540
undo global data689,421,654152,744486152,270
cache buffers chains1,509,536,461124,8541,495123,380
enqueue hash chains42,754,52973,61823373,387
object queue header operation395,370,28654,30677253,538
resmgr:schema config1,740,62524,75722,3872,385
channel operations parent latch220,502,24223,50824323,266
gcs resource hash35,502,39914,5338414,451
checkpoint queue latch1,127,281,19214,1287514,055
cache buffers lru chain26,440,1339,463249,439
mostly latch-free SCN564,0208,9151228,797
ges resource hash list17,484,4278,6177087,910
gc element30,522,2998,2828717,438
ASM map operation hash table12,170,2748,013187,995
object queue header heap283,875,5575,519265,493
ges caches resource lists1,295,6375,089375,052
post/wait queue2,947,4384,86984,861
redo allocation2,804,0143,891603,831
shared pool10,376,8013,616583,558
KJC message pool free list1,917,9323,159543,105
File State Object Pool Parent Latch8,045,4523,052273,025
KJCT flow control latch27,188,5982,561152,548
gcs opaque info freelist4,069,2161,98581,977
sequence cache1,480,1497705765
message pool operations parent latch4,793,67663216616
FOB s.o list latch29,81662411616
ges group table9,773,5583851384
session idle bit9,876,28233410324
ges process hash list142,691,12332822306
flashback mapping39,6222934289
ktm global data535,9391181117
resmgr:resource group CPU method46,14071170
flashback allocation1,142,03647344
object stats modification60,56120119
Consistent RBA544,493817
DML lock allocation1,052,356312
ges process parent latch15,041,285312
resmgr:active threads36,196220

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active checkpoint queue latchkcbbacq: scan active checkpoints04,6184,701
active checkpoint queue latchkcbkcpa: Checkpoint post-processing010698
active checkpoint queue latchkcbkcpa: Checkpoint post-processing 209729
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 101413
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 20128
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 3075
ASM map operation hash tablekffmTranslate01412
ASM map operation hash tablekffmDoDone_1046
cache buffers chainskcbchg1: clear MS bit06471
cache buffers chainskcbbxsv0339340
cache buffers chainskcbgcur_40264424
cache buffers chainskcbrls_2014847
cache buffers chainskcbzwb0403
cache buffers chainskclbla03813
cache buffers chainskclwlr0208
cache buffers chainskcllkopesc0133
cache buffers chainskcbgcur_2061
cache buffers chainskclwrt058
cache buffers chainskcbgtcr: fast path046
cache buffers chainskcbgtcr: fast path (cr pin)044
cache buffers chainskcbchg1: mod cr pin031
cache buffers chainskcbbic1021
cache buffers chainskcbbic2021
cache buffers chainskcbrls: fast release027
cache buffers chainskcbzib: finish processing buffer020
cache buffers chainskcbchg1: mod cur pin012
cache buffers chainskcbget: fast exchange010
cache buffers chainskcbgtcr_2010
cache buffers chainskcbkzs010
cache buffers chainskcbnlc010
cache buffers chainskclexpandlock0118
cache buffers chainskclpdcl010
cache buffers chainskclrwrite_1010
cache buffers lru chainkcbzgws080
cache buffers lru chainkcbbxsv: move to being written070
cache buffers lru chainkcbbic2055
cache buffers lru chainkcbkcxe023
cache buffers lru chainkcbbwlru0113
cache buffers lru chainkclwcrs010
channel operations parent latchksrwait()0146160
channel operations parent latchksrapublish()0578
channel operations parent latchksrpubwait():104779
channel operations parent latchksrsconsume()01935
channel operations parent latchksrmfree()0122
checkpoint queue latchkcbkubc_404518
checkpoint queue latchkcbbwthc: thread checkpoint buffers01137
checkpoint queue latchkcbbwdl: thread checkpoint queue0914
checkpoint queue latchkcbklbc_cql090
checkpoint queue latchkcbkllrba: compute lowest lrba010
DML lock allocationktaiam010
enqueue hash chainsksqrcl09916
enqueue hash chainsksqcmi: if lk mode not requested073168
enqueue hash chainsksqcmi: if lk mode requested0257
enqueue hash chainsksqcnl0214
enqueue hash chainsksqgtl301538
File State Object Pool Parent LatchFSO create01815
File State Object Pool Parent LatchFSO delete normal0912
flashback allocationkrfgdata2033
flashback mappingkrfget_sfgda1034
flashback mappingkrfw_advance_mapping1010
FOB s.o list latchksfd_fobd01010
FOB s.o list latchksfd_allfob011
gc elementkclchkping07160
gc elementkclnfndnewm06320
gc elementkclfwrite102824
gc elementkclrwrite02634
gc elementkclbla01612
gc elementkclulb0923
gc elementKCLUNLNK0832
gc elementkclwrt045
gc elementkclebs020
gc elementkcl_fairness020
gc elementkclfwrite2020
gc elementkclhngcbk1020
gc elementkclshrsplit020
gc elementkcllwr013
gc elementkclplz_1011
gc elementkclrwrite_10010
gcs opaque info freelistkjbrcvt save opaque info067
gcs opaque info freelistkjbrinfofree free opaque info021
gcs resource hashkclrwrite01819
gcs resource hashkjbassume0182
gcs resource hashkclfwrite101610
gcs resource hashkjbrwrdone reget0142
gcs resource hashkjbconvert030
gcs resource hashkjbcropen036
gcs resource hashkjbmpcreatepi032
gcs resource hashkjbcrcomplete022
gcs resource hashkjbmpclose027
gcs resource hashkjbopen022
gcs resource hashkclpdc011
gcs resource hashkjbcrconvert010
gcs resource hashkjbmdowncvt011
ges group tablekjgagll: move a lock from process lock list to group lock list011
ges process hash listkjakiqa: set inquiry response0220
ges process parent latchkjata010
ges resource hash listkjakcai: search for resp by resname030440
ges resource hash listkjlrlr: remove lock from resource queue020631
ges resource hash listkjlmfnd: search for lockp by rename and inst id011422
ges resource hash listkjrmas1: lookup master node0391
ges resource hash listkjucvl: lock convert request0321
ges resource hash listkjakoca: search for resp by resname012589
ges resource hash listkjrref: find matched resource0128
ges resource table freelistkjchc: clean resource cache0350
ges resource table freelistkjrm2c: move resource to cache0238
KJC message pool free listkjcsmpav: allocate a msg buffer05357
KJC message pool free listkjcspfmbq: free vector of msg buffers010
KJCT flow control latchkjctcsnd: send normal message083
KJCT flow control latchkjcts_sqenq: queue a message062
KJCT flow control latchkjcts_sedeqv2: dequeue a vector of msgs015
ktm global dataktmbis010
lgwr LWN SCNkcs0230490
message pool operations parent latchksrmalloc()0124
message pool operations parent latchksrmfree()054
messagesksarcv03,7102,434
messagesksarcv: after wait01,3591,827
messagesksaamb: after wakeup01,1151,923
mostly latch-free SCNkcslcu3073123
mostly latch-free SCNkcsnew_scn_rba010
object queue header heapkcbo_link_q:alloc0163
object queue header heapkcbo_unlink_q_bg080
object queue header heapkcbo_check_flist0223
object queue header operationkcbo_link_q019026
object queue header operationkcbo_switch_mq_bg013943
object queue header operationkcbo_unlink_q09919
object queue header operationkcbo_switch_q_bg07930
object queue header operationkcldbufs078199
object queue header operationkcbo_unlink_q_bg06720
object queue header operationkcbo_link_q:reget0611
object queue header operationkcbo_check_flist039436
object queue header operationkcbo_switch_cq03712
object queue header operationkclobj_103638
object queue header operationkclobj_5041
object queue header operationkclbufs027
object stats modificationksols_rank010
post/wait queuekslpstevent:get051
post/wait queueksliwat:add:nowait030
redo allocationkcrfw_redo_gen: redo allocation 10600
redo writingkcrfwcr02,4692,509
redo writingkcrfw_cal_target_rba06246
redo writingkcrfw_post: rba scn pair0351
redo writingkcrfw_post: after write0212
resmgr:active threadskgsksimsetup1020
resmgr:resource group CPU methodkgkprrpicknext011
resmgr:schema configkgskgmaxdop1021,95622,351
resmgr:schema configkgskgasi1035935
resmgr:schema configkgskmetricupd0670
resmgr:schema configkgskgcs1040
resmgr:schema configkgskgetclassidbyname011
row cache objectskqrpre: find obj05,929,2917,528,731
row cache objectskqreqd: reget04,110,0872,554,102
row cache objectskqreqd03,214,5213,171,092
sequence cachekdnssd030
sequence cachekdnnxt: cached seq020
session idle bitksupuc: clear busy067
session idle bitksupuc: set busy064
shared poolkghalo03441
shared poolkghfre02317
shared poolkghalp010
space background task latchktsj_grab_task012,64813,202
space background task latchktsjCreateTask04947
space background task latchktsj_detach_task09326
undo global dataktudba: KSLBEGIN0482480
undo global dataktubnd:child021
undo global dataktufrbs_2011
undo global dataktusmupst: KSLBEGIN011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal2 91620
Library Cachekglpin1 4530
Library Cachekglpndl1 95210
Cursor Pinkksfbc [KKSCHLFSP2]170
Library Cachekglpnal1 90150
Cursor Pinkksfbc [KKSCHLPIN1]90
Cursor PinkksLockDelete [KKSCHLPIN6]80
Library Cachekglobpn1 7160
Library Cachekgllkdl1 8540
Library Cachekglhdgn2 10630
hash tablekkshGetNextChild [KKSHBKLOC1]30
Library Cachekgllkal1 8020
Library Cachekgllkc1 5710
Cursor ParentkkscsPruneChild [KKSPRTLOC35]10

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
EZTOEZTO_DATALIBRARYSYS_P17728TABLE PARTITION1,216,9280.17
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX1,019,0240.14
EZTOEZTO_DATALIBRARYSYS_P17813TABLE PARTITION737,8880.10
EZTOEZTO_INDEXBYCONSTESTMEDIA INDEX652,3840.09
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX626,8000.09

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB87,8613.14
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX8,3160.30
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,9690.18
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,0350.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION3,7690.13

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB87,8623.15
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX8,3160.30
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,9690.18
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,0350.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION3,7690.13

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB87,8623.15
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX8,3160.30
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,9690.18
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,0350.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION3,7690.13

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

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1797134646_1094TABLE PARTITION1224.71

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB84,6892.09
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX25,2000.62
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,1900.05
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION1,6470.04
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50876LOB PARTITION1,3340.03

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX22,1282.30
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX1,9590.20
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,6080.17
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,1480.12
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50784LOB PARTITION1,0880.11

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1797134646_1094TABLE PARTITION1430.01

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX306,91222.97
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE151,76011.36
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX150,48011.26
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB90,3366.76
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX25,7601.93

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX9674.42
EZTOEZTO_INDEXATTEMPTDATA_PKSYS_P49493INDEX PARTITION32.33
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49413INDEX PARTITION32.33
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX21.55
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTPK_IDXSYS_P48238INDEX PARTITION21.55

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50684LOB PARTITION176.34
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50407LOB PARTITION93.36
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50437LOB PARTITION93.36
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50777LOB PARTITION82.99
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50486LOB PARTITION62.24

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX1831.58
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41213LOB PARTITION1628.07
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX58.77
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50482LOB PARTITION35.26
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB35.26

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41213LOB PARTITION38,8673.90
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX35,4863.56
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41234LOB PARTITION3,7150.37
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41296LOB PARTITION3,6200.36
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41294LOB PARTITION2,0820.21

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX147,9707.36
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX28,8671.44
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION2,5560.13
EZTOEZTO_INDEXATTEMPT_TESTUSERID_IDXSYS_P39068INDEX PARTITION1,8700.09
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49318INDEX PARTITION1,3490.07

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_control2143.270 23
dc_global_oids362.780 032
dc_histogram_data2870.000 0382
dc_histogram_defs16,8805.190 04,599
dc_object_grants2119.050 08
dc_objects257,9700.240 717,076
dc_profiles20.000 01
dc_rollback_segments526,516,3550.000 01,040
dc_segments89,2580.600 39417,023
dc_sequences14187.940 1412
dc_tablespaces95,9780.000 012
dc_users176,5600.000 075
global database name20,6460.000 01
outstanding_alerts13892.750 08
sch_lj_oids2015.000 05

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control1150
dc_global_oids100
dc_histogram_defs87600
dc_objects76680
dc_segments1,2764620
dc_sequences2821230
dc_users400
outstanding_alerts2541280
sch_lj_oids300

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY5371.123,2690.2100
CLUSTER137.69137.6900
DBLINK100.000 00
EDITION550.00550.0000
INDEX2420.002420.0000
QUEUE2,1520.002,3310.0000
SCHEMA3601.110 00
SQL AREA42,5701.173,193,5760.0261100
SQL AREA BUILD43174.710 00
SQL AREA STATS43185.8543185.8500
TABLE/PROCEDURE84,3140.34707,2810.06100
TRANSFORMATION1,0760.001,0760.0000
TRIGGER1844.351844.3500

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY23,2613,26100
CLUSTER13131300
DBLINK100000
EDITION55555500
INDEX24224224200
QUEUE1,0762,3312,33100
SCHEMA10000
TABLE/PROCEDURE84,509623,019623,01900
TRANSFORMATION1,0761,0761,07600
TRIGGER018418400

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 buffer cache4,096.004,096.004,096.004,096.000INI/
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/
java pool192.00192.00192.00192.000STA/
KEEP buffer cache0.000.000.000.000STA/
large pool256.00256.00256.00256.000STA/
PGA Target8,192.008,192.008,192.008,192.000STA/
RECYCLE buffer cache4,096.004,096.004,096.004,096.000INI/
SGA Target0.000.000.000.000STA/
Shared IO Pool0.000.000.000.000STA/
shared pool3,072.003,072.003,072.003,072.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
BOther901.05 2.694.725454335335
Freeable46.440.001.261.988 3737
SQL1.490.070.010.0105291278
PL/SQL0.950.370.000.0100333331
EOther1,926.70 5.656.305454341341
Freeable94.380.000.651.257 146146
SQL5.700.480.020.0205294286
PL/SQL1.400.510.000.0200339338

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers8,589,934,592 
Fixed Size2,240,344 
Redo Buffers40,890,368 
Variable Size4,194,304,168 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory192.00192.000.00
largefree memory255.63255.630.00
sharedASH buffers128.00128.000.00
sharedASM extent pointer array70.6570.650.01
sharedCheckpoint queue64.0364.030.00
shareddb_block_hash_buckets44.5044.500.00
shareddbktb: trace buffer80.0080.000.00
shareddbwriter coalesce buffer32.0332.030.00
shareddirty object counts array32.0032.000.00
sharedevent statistics per sess127.81127.810.00
sharedfree memory1,031.73866.32-16.03
sharedgcs resources214.34214.340.00
sharedgcs shadows125.03125.030.00
sharedges enqueues147.11149.671.74
sharedges resource88.4289.931.70
sharedksunfy : SSO free list119.14119.140.00
sharedKTSL subheap52.42162.53210.04
sharedobject queue38.4362.7763.33
 buffer_cache8,192.008,192.000.00
 fixed_sga2.142.140.00
 log_buffer39.0039.000.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 %
10,7840.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.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
D0000.0010,7840.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00 0.00 00 

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/eztopqa/adump  
audit_trailNONE  
cluster_databaseTRUE  
cluster_database_instances4  
compatible11.2.0.0.0  
control_file_record_keep_time31  
control_files+EZTOPQA_RDOA/eztopqa_va/controlfile/current.257.784840069, +EZTOPQA_RDOB/eztopqa_va/controlfile/current.257.784840069, +EZTOPQA_DF/eztopqa_va/controlfile/current.276.784840069, +EZTOPQA_ARCH/eztopqa_va/controlfile/current.270.784840069  
db_block_size8192  
db_cache_size4294967296  
db_create_file_dest+EZTOPQA_DF  
db_create_online_log_dest_1+EZTOPQA_RDOA  
db_create_online_log_dest_2+EZTOPQA_RDOB  
db_domain    
db_file_multiblock_read_count4  
db_files1024  
db_nameEZTOPQA  
db_recovery_file_dest+EZTOPQA_DF  
db_recovery_file_dest_size697932185600  
db_recycle_cache_size4294967296  
db_unique_nameeztopqa_va  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=DB112032XDB)  
_gc_defer_time3  
gcs_server_processes8  
global_namesTRUE  
instance_number3  
large_pool_size268435456  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.169.2.57)(PORT=1521))))  
log_archive_dest_1LOCATION=+EZTOPQA_ARCH  
log_archive_format%t_%s_%r.dbf  
max_dump_file_size104857600  
open_cursors300  
pga_aggregate_target8589934592  
processes5120  
recyclebinOFF  
remote_listenermhva011scan.ezto.mhecloud.mcgraw-hill.com:1521  
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan  SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN
_rollback_segment_count250  
sessions10240  
sga_max_size12884901888  
sga_target0  
shared_pool_size3221225472  
spfile+EZTOPQA_DF/eztopqa_va/spfile.ora  
standby_file_managementAUTO  
thread3  
undo_tablespaceUNDOTBS3  
_use_adaptive_log_file_syncFALSE  
utl_file_dir/u01/app/oracle/admin/eztopqa/util  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+EZTOPQA_ARCH/eztopqa_va/controlfile/current.270.784840069  
+EZTOPQA_DF/eztopqa_va/controlfile/current.276.784840069  
+EZTOPQA_RDOA/eztopqa_va/controlfile/current.257.784840069  
+EZTOPQA_RDOB/eztopqa_va/controlfile/current.257.784840069  

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)1,261,188117.119.88
acks for commit broadcast(logical)1,521,190141.2511.91
broadcast msgs on commit(actual)1,388,659128.9510.87
broadcast msgs on commit(logical)1,538,583142.8712.05
broadcast msgs on commit(wasted)286,63026.622.24
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received1280.010.00
flow control messages sent670.010.00
gcs apply delta00.000.00
gcs assume cvt3,5730.330.03
gcs assume no cvt1,566,052145.4212.26
gcs ast xid240.000.00
gcs blocked converts1,400,013130.0010.96
gcs blocked cr converts963,95089.517.55
gcs compatible basts426,60239.613.34
gcs compatible cr basts (global)259,51424.102.03
gcs compatible cr basts (local)268,35524.922.10
gcs cr basts to PIs50.000.00
gcs cr serve without current lock10.000.00
gcs dbwr flush pi msgs175,52416.301.37
gcs dbwr write request msgs144,20513.391.13
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 only320,10629.722.51
gcs force cr grant274,56425.502.15
gcs force cr no current00.000.00
gcs forward cr to pinged instance150.000.00
gcs immediate (compatible) converts39,6863.690.31
gcs immediate cr (compatible) converts2140.020.00
gcs immediate cr (null) converts110,70210.280.87
gcs immediate (null) converts1,410,512130.9811.05
gcs indirect ast1,227,510113.989.61
gcs indirect bidless ast5,4800.510.04
gcs indirect fg ast1,227,493113.989.61
gcs lms flush pi msgs98,9069.180.77
gcs lms write request msgs103,1619.580.81
gcs msgs process time(ms)366,61234.042.87
gcs msgs received14,055,3061,305.14110.06
gcs new served by master33,7403.130.26
gcs out-of-order msgs3450.030.00
gcs pings refused6960.060.01
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts4,9510.460.04
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast5,1790.480.04
gcs reader bypass grant immediate6,8950.640.05
gcs reader bypass grant X on assume2530.020.00
gcs reader bypass N->Xw ping local2290.020.00
gcs reader bypass N->Xw ping remote2230.020.00
gcs recovery claim msgs00.000.00
gcs refuse xid170.000.00
gcs regular cr660,23561.315.17
gcs retry convert request5430.050.00
gcs share recovery bast00.000.00
gcs side channel msgs actual00.000.00
gcs side channel msgs logical00.000.00
gcs stale cr1,364,936126.7410.69
gcs undo cr490.000.00
gcs write notification msgs6,6870.620.05
gcs writes refused4,0600.380.03
ges msgs process time(ms)45,4214.220.36
ges msgs received2,040,774189.5015.98
global posts dropped00.000.00
global posts queue time00.000.00
global posts queued00.000.00
global posts requested00.000.00
global posts sent00.000.00
implicit batch messages received338,67131.452.65
implicit batch messages sent325,17630.202.55
lmd msg send time(ms)40.000.00
lms(s) msg send time(ms)180.000.00
messages flow controlled125,95711.700.99
messages queue sent actual5,653,730524.9944.27
messages queue sent logical792,48973.596.21
messages received actual15,287,3891,419.55119.71
messages received logical16,096,7241,494.70126.05
messages sent directly7,154,729664.3756.03
messages sent indirectly4,680,084434.5836.65
messages sent not implicit batched00.000.00
messages sent pbatched4,681,568434.7236.66
msgs causing lmd to send msgs1,246,811115.789.76
msgs causing lms(s) to send msgs2,628,495244.0820.58
msgs received queue time (ms)291,15127.042.28
msgs received queued16,094,2731,494.47126.03
msgs sent queue time (ms)258,48524.002.02
msgs sent queue time on ksxp (ms)3,307,157307.0925.90
msgs sent queued6,117,980568.1047.91
msgs sent queued on ksxp15,243,7381,415.49119.37
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received4,266,563396.1833.41
process batch messages sent4,366,454405.4634.19


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests674,217
CURRENT Block Requests1,373,366
Data Block Requests674,225
Undo Block Requests49
TX Block Requests399
Current Results1,000,998
Private results1,597
Zero Results687
Disk Read Results1,044,368
Fail Results4
Fairness Down Converts289,654
Fairness Clears26,493
Free GC Elements0
Flushes5,173
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)56,304
Light Works5,263
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins8,92956.1334.908.930.040.00
Flushes52,2299.5786.843.560.030.00
Writes232,37947.4751.291.070.160.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
4data block240,31096.010.773.22333,18495.372.771.86
1data block215,34195.900.733.37209,83294.053.991.96
2data block205,62695.660.803.55205,86093.744.232.03
4Others123,66497.860.092.05180,19696.231.791.98
4undo header1,13595.682.821.50277,63290.278.451.28
1Others106,62897.890.092.02162,73196.301.791.91
1undo header1,11795.083.311.61256,71090.018.641.35
2Others102,39797.840.102.06152,05796.171.871.97
2undo header83495.203.241.56232,59890.068.711.24
4undo block2676.9223.080.000   
1undo block2277.2722.730.000   
2undo block2090.0010.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
4data block0.390.362.920.480.330.320.760.38
1data block0.390.372.710.480.360.340.780.44
2data block0.390.363.020.450.360.350.720.38
4others0.280.282.930.390.290.280.680.35
4undo header0.380.235.440.210.560.243.960.38
1others0.290.283.270.340.290.280.700.33
1undo header0.310.232.570.290.560.243.900.31
2others0.290.292.500.390.290.280.640.35
2undo header0.350.263.010.220.570.244.040.25
1undo block0.530.251.47     
2undo block0.640.293.77     

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
4data block0230,72849.2550.75317,74363.6136.39
1data block0206,51847.8652.14197,34655.4544.55
2data block0196,69250.4449.56192,96750.3449.66
4others0121,01550.8649.14173,40361.9138.09
1others0104,37851.5148.49156,71861.6538.35
4undo header01,086100.000.00250,622100.000.00
2others0100,18847.8152.19146,22860.4039.60
1undo header01,062100.000.00231,058100.000.00
2undo header0794100.000.00209,467100.000.00
2undo block018100.000.000  
1undo block017100.000.000  

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
4data block 0.360.270.460.320.250.43
1data block 0.370.280.450.340.260.44
2data block 0.360.270.450.350.260.43
4others 0.280.210.350.280.210.40
1others 0.280.210.360.280.220.39
4undo header 0.230.23 0.240.240.28
2others 0.290.200.360.280.210.39
1undo header 0.230.23 0.240.24 
2undo header 0.260.26 0.240.24 
2undo block 0.290.29    
1undo block 0.250.25    

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
18560.430.168560.470.16
28560.380.128560.420.14
38560.370.128560.370.13
48560.420.138560.450.13

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache1.321.34
Parallel Query0.000.00
DB Locks0.360.36
DB Streams0.000.00
Other0.010.01

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
bond1:1169.254.88.82NO  0.000000 0.000000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

NameTotalper Remaster OpBegin SnapEnd Snap
remaster ops41.00  
remastered objects123.00  
replayed locks received00.00  
replayed locks sent10,6732,668.25  
resources cleaned00.00  
remaster time (s)5.21.30  
quiesce time (s)0.70.18  
freeze time (s)0.10.02  
cleanup time (s)0.20.05  
replay time (s)0.30.09  
fixwrite time (s)0.70.17  
sync time (s)3.20.80  
affinity objects  1919


Back to Top

End of Report