WORKLOAD REPOSITORY report for

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

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:110115-Jul-13 21:00:39328 2.6
End Snap:110416-Jul-13 00:00:08334 12.0
Elapsed:  179.49 (mins)  
DB Time:  179.52 (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,064,434.4 88,269.5  
Logical reads: 65,246.2 5,410.6  
Block changes: 1,025.2 85.0  
Physical reads: 258.3 21.4  
Physical writes: 817.7 67.8  
User calls: 464.7 38.5  
Parses: 8.2 0.7  
Hard parses: 0.0 0.0  
W/A MB processed: 0.0 0.0  
Logons: 0.0 0.0  
Executes: 294.4 24.4  
Rollbacks: 0.0 0.0  
Transactions: 12.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.94
Buffer Hit %: 99.60In-memory Sort %: 100.00
Library Hit %: 99.98Soft Parse %: 99.62
Execute to Parse %: 97.21Latch Hit %: 93.63
Parse CPU to Parse Elapsd %: 19.19% Non-Parse CPU: 99.15

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.42 71.94
% SQL with executions>1: 82.84 78.75
% Memory for SQL w/exec>1: 74.83 68.06

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read1,360,7775,632452.29User I/O
DB CPU 2,663 24.73 
reliable message369,89894438.77Other
enq: CR - block range reuse ckpt477,52145714.24Other
log file sync129,84630922.87Commit

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

Load Average BeginLoad Average End%User%System%WIO%Idle
1.22 1.67 3.2 0.8 0.9 96.0
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
3.1 78.3 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): 941.5 2,046.9
% Host Mem used for SGA+PGA: 10.21 11.07

RAC Statistics

BeginEnd
Number of Instances: 4 4

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 268.28 22.25
Global Cache blocks served: 268.88 22.30
GCS/GES messages received: 1,530.85 126.95
GCS/GES messages sent: 1,485.54 123.19
DBWR Fusion writes: 19.15 1.59
Estd Interconnect traffic (KB) 4,886.40 

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

Buffer access - local cache %: 99.19
Buffer access - remote cache %: 0.41
Buffer access - disk %: 0.40

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 0.3
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.6
Avg global cache cr block flush time (ms): 2.6
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 %: 3.5
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.19
% of indirect sent messages: 39.73
% of flow controlled messages: 1.09


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
bond1:1169.254.76.169N    

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,128.0784.75
DB CPU2,663.1824.73
parse time elapsed117.791.09
sequence load elapsed time0.490.00
repeated bind elapsed time0.170.00
connection management call elapsed time0.150.00
hard parse elapsed time0.100.00
PL/SQL execution elapsed time0.020.00
RMAN cpu time (backup/restore)0.000.00
DB time10,771.09 
background elapsed time23,595.07 
background cpu time19,112.65 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME2,779,832 
IDLE_TIME66,353,993 
IOWAIT_TIME608,860 
NICE_TIME478 
SYS_TIME532,648 
USER_TIME2,212,448 
LOAD12
RSRC_MGR_CPU_WAIT_TIME4 
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.22     
15-Jul 22:00:051.471.280.800.4798.720.19
15-Jul 23:00:021.647.476.440.9592.531.32
16-Jul 00:00:081.673.282.340.8996.721.12

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,405,86805,682452.75
DB CPU  2,663 24.73
Other873,73701,462213.57
Cluster2,750,573092108.55
Commit129,846030922.87
Network5,389,762021802.02
System I/O25,68001710.16
Concurrency8,1500300.03
Configuration49779130.01
Administrative810011510.01
Application2751010.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,360,77705,632410.4852.29
reliable message369,898094432.858.77
enq: CR - block range reuse ckpt477,521045713.684.24
log file sync129,846030921.002.87
gc current grant 2-way969,656022807.472.12
SQL*Net more data from client973,092018607.491.73
gc current grant busy338,092015402.601.43
gc current block 3-way347,077014902.671.38
gc current block 2-way417,822010703.220.99
gc cr block 3-way244,517010601.880.98
gc cr block 2-way253,42906501.950.60
latch free22,03905630.170.52
db file scattered read17,77704830.140.44
gc cr multi block request88,91703900.680.37
gc current block busy35,60702710.270.25
control file sequential read25,68001710.200.16
SQL*Net more data to client425,15701603.270.15
SQL*Net message to client3,986,382015030.700.14
gc buffer busy release5,82301530.040.14
gc cr block busy4,85701430.040.13
gc current block congested15,9410700.120.06
gc cr block congested10,6140500.080.04
gc current grant congested13,5080400.100.04
name-service call wait3803820.000.03
JS kgl get object wait810011510.000.01
db file parallel read8801130.000.01
gc current multi block request2,0440110.020.01
latch: row cache objects6,9060100.050.01
undo segment extension10479190.000.01
direct path read5130110.000.01
gc cr grant 2-way2,4010100.020.01
SQL*Net vector data to client5,1310100.040.01
enq: TX - index contention3050120.000.01
buffer busy waits4350010.000.00
enq: FB - contention1,5690000.010.00
log file switch completion700500.000.00
Disk file operations I/O26,6840000.210.00
resmgr:internal state change310001010.000.00
enq: TX - contention970030.000.00
row cache lock2860010.000.00
enq: TX - row lock contention2001240.000.00
gc buffer busy acquire1410020.000.00
enq: HW - contention37782000.000.00
PX Deq: Slave Session Stats1460010.000.00
enq: TM - contention2700000.000.00
local write wait280030.000.00
enq: PS - contention14612010.000.00
os thread startup200300.000.00
DFS lock handle6913010.000.00
SecureFile mutex460010.000.00
library cache: mutex X650010.000.00
IPC send completion sync4920000.000.00
latch: ges resource hash list4750000.000.00
gc cr disk read580010.000.00
cursor: pin S80030.000.00
gc current split240010.000.00
PX Deq: reap credit1,004100000.010.00
gc current retry50020.000.00
enq: SQ - contention50020.000.00
library cache lock2195000.000.00
gc cr grant congested360000.000.00
library cache pin190000.000.00
enq: CF - contention90010.000.00
enq: JQ - contention11100000.000.00
enq: JS - job run lock - synchronize9100010.000.00
latch: shared pool320000.000.00
latch: object queue header operation340000.000.00
latch: enqueue hash chains320000.000.00
enq: UL - contention3100010.000.00
wait list latch free20010.000.00
latch: gc element190000.000.00
gc cr failure40000.000.00
latch: cache buffers chains220000.000.00
ASM file metadata operation470000.000.00
enq: TX - allocate ITL entry40000.000.00
SQL*Net message from client3,986,38602,815,01570630.70 
jobq slave wait2,1971001,1015010.02 
KSV master wait12401100.00 
PX Deq: Execution Msg5640120.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,339,41801,116110.314.73
latch: row cache objects10,975,8140891084.523.78
log file parallel write547,091086424.213.66
db file parallel write755,133059715.812.53
direct path write temp424,961054013.272.29
enq: FU - contention304501501170.001.91
gc current block busy60,826024340.471.03
gc current block 2-way888,884020606.840.87
gcs log flush sync150,126118711.160.79
gc cr disk read921,117017807.090.75
flashback log file write49,701012930.380.55
enq: CR - block range reuse ckpt173,72707101.340.30
log file sequential read5,785070120.040.30
gc current grant busy139,15705801.070.25
gc cr block 3-way141,78605001.090.21
gc current block 3-way129,34704901.000.21
gc buffer busy release15,24404730.120.20
ges inquiry response101,30704200.780.18
DFS lock handle49,661973310.380.14
control file sequential read58,76803010.450.13
gc cr block 2-way139,62002801.080.12
ASM file metadata operation10,47402620.080.11
gc buffer busy acquire4,13102660.030.11
ksxr poll remote instances1,522,22210023011.720.10
buffer busy waits4,49902150.030.09
control file parallel write6,38601630.050.07
CSS operation: data query3,58001130.030.05
row cache cleanup3,530,22309027.180.04
enq: DW - contention14,147100600.110.02
latch free14,6300500.110.02
PX Nsq: PQ load info query2410052010.000.02
gc current block congested16,1590500.120.02
os thread startup10705430.000.02
wait list latch free4,2320510.030.02
reliable message3,0320210.020.01
gc cr block congested6,0420200.050.01
enq: WF - contention5502380.000.01
gc current grant 2-way8,7380200.070.01
local write wait1,6880210.010.01
ges lms sync during dynamic remastering and reconfig96512170.000.01
SQL*Net break/reset to client6802230.000.01
libcache interrupt action by LCK3,528,33701027.170.01
name-service call wait1801830.000.01
row cache process3,534,26501027.210.01
enq: CO - master slave det3,588100100.030.01
LGWR wait for redo copy18,1480100.140.01
row cache lock1,0910110.010.01
undo segment extension14577190.000.01
CGS wait for IPC msg100,603100100.770.00
latch: messages4,9400100.040.00
gc cr block busy2760130.000.00
Log archive I/O4470120.000.00
db file async I/O submit703,5960105.420.00
direct path read1510140.000.00
enq: JS - wdw op1004230.000.00
enq: CF - contention73841010.010.00
kfk: async disk IO4340010.000.00
latch: redo writing1,9940000.020.00
db file scattered read690040.000.00
Disk file operations I/O5,7950000.040.00
db file single write4220010.000.00
read by other session670040.000.00
CSS group membership query1790010.000.00
enq: HW - contention4630000.000.00
enq: TX - contention200090.000.00
log file switch completion200680.000.00
CSS operation: action430030.000.00
enq: TM - contention2572050.000.00
gc cr grant 2-way4040000.000.00
resmgr:internal state change110001000.000.00
CSS initialization180050.000.00
rdbms ipc reply100860.000.00
gc current multi block request500020.000.00
enq: PS - contention18843000.000.00
direct path write1140010.000.00
flashback log file read80080.000.00
latch: object queue header operation4840000.000.00
latch: cache buffers chains1,2750000.010.00
PX Deq: reap credit3,640100000.030.00
latch: gc element7120000.010.00
enq: RO - fast object reuse470010.000.00
db file parallel read300100.000.00
log file single write120020.000.00
gc current grant congested1260000.000.00
gc cr multi block request560000.000.00
enq: TX - index contention200120.000.00
library cache lock686000.000.00
gc object scan2,678100000.020.00
library cache pin680000.000.00
latch: ges resource hash list2180000.000.00
enq: TA - contention640000.000.00
ges generic event21000100.000.00
CSS operation: query2330000.000.00
latch: enqueue hash chains1800000.000.00
latch: undo global data3320000.000.00
log file sync90020.000.00
ges DFS hang analysis phase 2 acks100150.000.00
library cache: mutex X180010.000.00
enq: TD - KTF dump entries330000.000.00
flashback log file sync40020.000.00
latch: gcs resource hash960000.000.00
enq: PI - contention22100000.000.00
PX Deq: Slave Session Stats1260000.000.00
enq: FB - contention250000.000.00
ADR block file read450000.000.00
enq: MW - contention60010.000.00
kjbdrmcvtq lmon drm quiesce: ping completion20020.000.00
enq: PR - contention10050.000.00
latch: checkpoint queue latch400000.000.00
latch: redo allocation400000.000.00
enq: TK - Auto Task Serialization12100000.000.00
gc current split30010.000.00
PX Deq: Signal ACK EXT1260000.000.00
PX Deq: Signal ACK RSG1260000.000.00
enq: DR - contention60000.000.00
asynch descriptor resize351100000.000.00
ADR block file write150000.000.00
gc cr grant congested70000.000.00
enq: AF - task serialization40000.000.00
latch: cache buffers lru chain120000.000.00
rdbms ipc message14,425,7761330,32423111.08 
gcs remote message19,311,7372684,9664148.71 
Space Manager: slave idle wait687,340071,3191045.29 
wait for unread message on broadcast channel21,6908921,5399930.17 
DIAG idle wait325,5787921,230652.51 
class slave wait3,122012,60340370.02 
PING3,8542210,77727960.03 
shared server idle wait35910010,773300090.00 
GCR sleep2,15410010,77150010.02 
ASM background timer6,710010,77016050.05 
Streams AQ: qmn slave idle wait375010,767287120.00 
Streams AQ: qmn coordinator idle wait7505010,767143560.01 
pmon timer3,58510010,76230020.03 
dispatcher timer17910010,742600100.00 
smon timer131,350010,726821.01 
ges remote message2,291,668210,625517.65 
PX Idle Wait16305,803356030.00 
SQL*Net message from client213016750.00 
KSV master wait7,908821520.06 
PX Deq: Join ACK1260010.00 
PX Deq: Parse Reply1260000.00 
PX Deq: Execute Reply1260000.00 
Streams AQ: RAC qmn coordinator idle wait759100000.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 read45100.0       
ADR block file write15100.0       
ADR file lock18100.0       
ARCH wait for archivelog lock6100.0       
ASM file metadata operation10.6K85.23.26.3.44.1.5.3.0
asynch descriptor resize384100.0       
buffer busy waits493654.25.79.015.69.54.41.7 
CGS wait for IPC msg100.6K100.0       
control file parallel write6395 72.522.73.4.6.4.5 
control file sequential read84.5K95.32.4.9.7.4.2.1 
CSS group membership query17911.287.21.1.6    
CSS initialization1850.0  5.644.4   
CSS operation: action4318.620.923.337.2    
CSS operation: data query3580.07.489.82.8    
CSS operation: query23396.61.71.7     
cursor: pin S875.0   25.0   
db file async I/O submit700.1K100.0       
db file parallel read91   24.258.215.42.2 
db file parallel write753.5K87.37.83.01.4.4.1.0 
db file scattered read17.8K71.12.34.910.19.81.6.2 
db file sequential read2701K70.32.94.913.26.71.6.3.0
db file single write42292.25.52.4     
DFS lock handle49.7K98.7.4.0.0.1.0.7 
direct path read66474.55.45.67.75.31.4.2 
direct path write11490.45.34.4     
direct path write temp425K42.050.45.51.8.3.1.0 
Disk file operations I/O32.1K100.0.0      
enq: AF - task serialization4100.0       
enq: CF - contention74898.71.2 .1    
enq: CO - master slave det358799.9.1      
enq: CR - block range reuse ckpt651.4K87.56.33.62.0.5.2.1 
enq: DR - contention6100.0       
enq: DW - contention14.1K99.6.4.0.0    
enq: FB - contention159699.9.1      
enq: FL - Flashback database log2100.0       
enq: FU - contention366.7      33.3
enq: HW - contention84199.3.7      
enq: JQ - contention11100.0       
enq: JS - job run lock - synchronize9100.0       
enq: JS - wdw op1      100.0 
enq: KD - determine DBRM master2100.0       
enq: KT - contention1100.0       
enq: MW - contention666.733.3      
enq: PI - contention22100.0       
enq: PR - contention1   100.0    
enq: PS - contention33496.73.3      
enq: PW - flush prewarm buffers1100.0       
enq: RO - fast object reuse4795.74.3      
enq: RS - prevent aging list update1100.0       
enq: SQ - contention520.040.020.020.0    
enq: TA - contention6498.41.6      
enq: TD - KTF dump entries33100.0       
enq: TK - Auto Task Serialization12100.0       
enq: TM - contention29599.3.3    .3 
enq: TT - contention1100.0       
enq: TX - allocate ITL entry5100.0       
enq: TX - contention11747.020.510.34.312.05.1.9 
enq: TX - index contention30689.21.31.31.32.62.91.3 
enq: TX - row lock contention2     50.050.0 
enq: UL - contention3100.0       
enq: WF - contention5590.9    1.87.3 
enq: WL - contention3100.0       
flashback log file read850.0   37.512.5  
flashback log file sync425.025.050.0     
flashback log file write49.7K38.019.715.823.32.8.3.0 
gc buffer busy acquire427237.916.614.911.88.66.83.5 
gc buffer busy release21.1K27.441.317.97.23.32.0.9 
gc cr block busy51331.650.736.07.92.41.0.3 
gc cr block congested16.7K99.4.2.1.1.1.0.1 
gc cr block 2-way393.1K99.8.1.0.0.0.0.0 
gc cr block 3-way386.4K99.5.2.1.1.1.0.0 
gc cr disk read921.2K99.8.0.0.0.0.0.0 
gc cr failure6100.0       
gc cr grant congested43100.0       
gc cr grant 2-way281099.8.1.1.0.0   
gc cr multi block request89K99.1.6.1.1.1.0.0 
gc current block busy96.4K40.727.718.37.23.71.7.7 
gc current block congested32.1K99.6.1.1.1.1.0.0 
gc current block 2-way1306.8K99.8.0.0.0.0.0.0 
gc current block 3-way476.5K99.6.2.1.1.1.0.0 
gc current grant busy477.3K99.0.5.2.2.1.0.0 
gc current grant congested13.6K99.6.1.0.1.1.0.1 
gc current grant 2-way979.5K99.8.0.0.0.0.0.0 
gc current multi block request208899.0.6.1.1.0 .0 
gc current retry785.7   14.3   
gc current split2692.37.7      
gc object scan2677100.0       
gc quiesce1100.0       
gcs log flush sync150.2K55.529.310.43.61.2.0  
ges DFS hang analysis phase 2 acks1    100.0   
ges generic event2    100.0   
ges inquiry response101.3K99.6.4.0     
ges lms sync during dynamic remastering and reconfig96  31.32.125.017.724.0 
IPC send completion sync600100.0       
JS kgl get object wait8      100.0 
kfk: async disk IO43483.911.53.5.7.2.2  
kjbdrmcvtq lmon drm quiesce: ping completion250.0 50.0     
KJC: Wait for msg sends to complete35100.0       
ksxr poll remote instances1522.5K100.0.0      
latch: cache buffers chains1299100.0       
latch: cache buffers lru chain14100.0       
latch: call allocation2100.0       
latch: checkpoint queue latch40100.0       
latch: enqueue hash chains21299.5.5      
latch free36.7K49.012.728.59.8.0   
latch: gc element731100.0       
latch: gcs resource hash100100.0       
latch: ges resource hash list693100.0       
latch: messages495199.7.3      
latch: object queue header operation51899.4.2 .4    
latch: redo allocation40100.0       
latch: redo writing199699.7.3      
latch: row cache objects11M99.9.1.0.0.0   
latch: shared pool32100.0       
latch: undo global data335100.0       
LGWR wait for redo copy18.2K100.0  .0.0   
libcache interrupt action by LCK3529K100.0       
library cache lock89100.0       
library cache: mutex X8394.0   6.0   
library cache pin87100.0       
local write wait171676.615.95.61.7.2   
lock deadlock retry1100.0       
lock escalate retry19100.0       
Log archive I/O44743.826.222.86.3.9   
log file parallel write547.2K44.640.011.03.2.8.3.1 
log file sequential read57953.73.25.730.136.116.34.9 
log file single write1656.312.5 25.06.3   
log file switch completion14     35.764.3 
log file sync129.9K8.858.823.66.31.7.6.2 
name-service call wait56    1.810.787.5 
os thread startup109    .982.616.5 
PX Deq: reap credit4643100.0       
PX Deq: Signal ACK EXT126100.0       
PX Deq: Signal ACK RSG126100.0       
PX Deq: Slave Session Stats27296.71.11.1.4.7   
PX Nsq: PQ load info query24      100.0 
rdbms ipc reply1      100.0 
read by other session6854.47.45.914.711.85.9  
reliable message373K62.819.513.61.1.8.61.5 
resmgr:internal state change4      100.0 
row cache cleanup3530.8K100.0       
row cache lock137792.16.7.1.1.1.2.6 
row cache process3534.9K100.0       
SecureFile mutex4689.1   10.9   
SQL*Net break/reset to client6850.0     50.0 
SQL*Net message to client3984.6K100.0       
SQL*Net more data from client973.8K93.95.5.4.1.0.0.0 
SQL*Net more data to client425.2K99.7.1.1.1.0.0  
SQL*Net vector data to client513199.9.0.0     
undo segment extension24658.1   14.223.24.5 
wait list latch free4232.0100.0      
ASM background timer672826.86.16.52.78.87.79.232.2
class slave wait314143.6.312.13.19.41.816.013.6
DIAG idle wait325.5K14.91.41.3.512.934.434.6 
dispatcher timer179       100.0
GCR sleep2153       100.0
gcs remote message19.3M34.910.912.213.128.9.0.0 
ges remote message2291.4K72.111.53.52.83.22.94.0 
jobq slave wait2206      100.0 
KSV master wait804793.43.42.0.2.2.5.2.1
PING385477.8.0     22.2
pmon timer3584       100.0
PX Deq: Execute Reply12698.41.6      
PX Deq: Execution Msg56471.812.111.53.0.2.21.2 
PX Deq: Join ACK12669.025.44.8.8    
PX Deq: Parse Reply12696.8 1.61.6    
PX Idle Wait146    6.84.865.123.3
rdbms ipc message14.1M67.88.96.34.33.83.15.4.4
shared server idle wait359       100.0
smon timer131.4K46.98.92.03.26.08.423.71.0
Space Manager: slave idle wait668.8K40.013.31.92.95.88.126.21.9
SQL*Net message from client3985K.456.122.26.65.03.65.01.1
Streams AQ: qmn coordinator idle wait75050.0      50.0
Streams AQ: qmn slave idle wait375       100.0
Streams AQ: RAC qmn coordinator idle wait759100.0       
wait for unread message on broadcast channel21.7K   .0.7 99.2 

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 operation2899.7.2.0.0  .0.0
buffer busy waits8398.31.4.2 .0.0  
control file parallel write3299.5.3.2.0    
control file sequential read4599.9.0.0     
db file parallel read297.82.2      
db file parallel write198100.0.0.0.0    
db file scattered read4099.8.2.0     
db file sequential read862999.7.3.0.0.0.0.0 
DFS lock handle34899.3.7.0.0    
direct path read199.8.2      
direct path write temp13100.0.0.0.0    
enq: CR - block range reuse ckpt40299.9.0.0.0.0.0  
enq: JS - wdw op1    100.0   
enq: TM - contention199.7 .3     
enq: TX - contention199.1.9      
enq: TX - index contention498.71.3      
enq: TX - row lock contention150.0  50.0    
enq: WF - contention492.7  1.81.83.6  
flashback log file write24100.0.0.0     
gc buffer busy acquire14896.52.8.6.0.1   
gc buffer busy release19599.1.8.1.0    
gc cr block busy1799.7.3.0     
gc cr block congested1399.9.1.0     
gc cr block 2-way20100.0.0.0     
gc cr block 3-way49100.0.0.0     
gc cr disk read33100.0.0.0     
gc cr multi block request13100.0.0.0     
gc current block busy68999.3.6.1.0.0.0  
gc current block congested16100.0.0.0     
gc current block 2-way97100.0.0.0.0    
gc current block 3-way52100.0.0.0     
gc current grant busy112100.0.0.0.0    
gc current grant congested999.9.0.0.0    
gc current grant 2-way30100.0.0.0.0    
gc current multi block request1100.0.0      
ges lms sync during dynamic remastering and reconfig2376.024.0      
JS kgl get object wait8  62.525.012.5   
log file parallel write30799.9.1.0.0    
log file sequential read28295.14.6.3.0    
log file switch completion935.750.014.3     
log file sync32299.8.2.0.0    
name-service call wait4912.517.962.57.1    
os thread startup1883.5 14.71.8    
PX Nsq: PQ load info query24   100.0    
rdbms ipc reply1  100.0     
reliable message568098.5.6.8.1.0   
resmgr:internal state change4  100.0     
row cache lock899.4.2.3.1    
SQL*Net break/reset to client3450.050.0      
SQL*Net more data from client163100.0.0.0.0    
undo segment extension1195.53.31.2     

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 operation4100.0.0      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

  % of Total Waits
EventWaits 4m to 1h <2m <4m <8m<1/4h<1/2h< 1h>=1h
enq: FU - contention166.7 33.3    

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
eztopqa_va10,7632,6601,43738,034
SYS$BACKGROUND211,343664,502
SYS$USERS2101
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 1405716568280943005389822218
SYS$BACKGROUND 17725531660145111619200000
SYS$USERS 1405608100

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,152.92152,1260.0229.2713.5270.730wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
2,404.83197,3560.0122.3312.5662.396fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,457.183485.7313.5361.3637.2805s9358mm6vrr   begin dbms_feature_usage_inter...
1,450.783483.5913.4761.5537.442d1p0p5k3f8fu   select p, NULL, NULL from (sel...
1,246.8692,3370.0111.5812.9378.559j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
330.529,1710.043.0721.4955.32d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
198.1318,1100.011.8415.9574.08gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
173.68124,8800.001.6157.400.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
140.78971.451.3124.5163.22aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
138.9172,6560.001.2956.670.58aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
132.2718,1310.011.2377.200.11b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
130.71111,1950.001.2141.400.283jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...

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
894.173298.0633.581,457.1861.3637.2805s9358mm6vrr   begin dbms_feature_usage_inter...
892.913297.6433.531,450.7861.5537.442d1p0p5k3f8fu   select p, NULL, NULL from (sel...
426.27152,1260.0016.013,152.9213.5270.730wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
301.97197,3560.0011.342,404.8312.5662.396fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
161.1892,3370.006.051,246.8612.9378.559j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
102.1118,1310.013.83132.2777.200.11b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
99.70124,8800.003.74173.6857.400.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
78.7372,6560.002.96138.9156.670.58aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
71.029,1710.012.67330.5221.4955.32d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
54.11111,1950.002.03130.7141.400.283jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
34.50970.361.30140.7824.5163.22aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
31.6118,1100.001.19198.1315.9574.08gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...

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,230.14152,1260.0130.373,152.9213.5270.730wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
1,500.44197,3560.0120.442,404.8312.5662.396fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
979.3692,3370.0113.341,246.8612.9378.559j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
543.243181.087.401,457.1861.3637.2805s9358mm6vrr   begin dbms_feature_usage_inter...
543.233181.087.401,450.7861.5537.442d1p0p5k3f8fu   select p, NULL, NULL from (sel...
182.859,1710.022.49330.5221.4955.32d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
146.7818,1100.012.00198.1315.9574.08gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
89.01970.921.21140.7824.5163.22aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
43.64570.770.5958.4415.9874.680m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
2.056200.000.037.7061.0326.699tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...

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,504,487124,88044.080.78173.6857.408w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
4,684,654152,12630.790.673,152.9213.570.70wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
2,983,86618,131164.570.42132.2777.2.1b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
2,768,530197,35614.030.392,404.8312.662.46fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
2,373,81972,65632.670.34138.9156.7.6aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
1,751,5179,171190.980.25330.5221.555.3d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
1,621,984124,76713.000.2319.5331.705dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
1,486,59592,33716.100.211,246.8612.978.59j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
1,276,034318,9364.000.1822.5528.70d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
1,259,2289139,914.220.1811.2225.813.17f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
518,057152,1263.4118.633,152.9213.5270.730wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
403,053197,3562.0414.492,404.8312.5662.396fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
189,65192,3372.056.821,246.8612.9378.559j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
101,372971,045.073.64140.7824.5163.22aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
68,679571,204.892.4758.4415.9874.680m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
37,60118,1102.081.35198.1315.9574.08gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
31,5469,1713.441.13330.5221.4955.32d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
1,20372,6560.020.04138.9156.670.58aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
7796201.260.037.7061.0326.699tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
456111,1950.000.02130.7141.400.283jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...

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,834499,834152,1263.290.0018.340wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
393,378393,378197,3561.990.0014.446fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
189,422189,42292,3372.050.006.959j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
101,372101,372971,045.070.003.72aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
37,60137,60118,1102.080.001.38gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
24,93224,932161,558.250.000.92f3999s9g0mmgm perl@lair (TNS V1-V3) SELECT tablespace_name , SUM( ...
17,49517,49557306.930.000.640m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
17,49517,49535,831.670.000.6405s9358mm6vrr   begin dbms_feature_usage_inter...
7,6997,69932,566.330.000.282d1p0p5k3f8fu   select p, NULL, NULL from (sel...
4,8894,88931,629.670.000.181cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
395,613395,6061.0039.8130.30dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
318,936318,9341.0022.5528.70d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
301,472301,3661.0018.6728.90d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
197,356197,3551.002,404.8312.662.46fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
162,16571,8480.4411.3926.807jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
152,126349,1692.303,152.9213.570.70wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
124,8801,626,69413.03173.6857.408w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
124,7671,247,67010.0019.5331.705dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
124,7611,247,60010.0016.9227.80d024vwxkhahjc JDBC Thin Client SELECT title, managers, partic...
114,988114,9881.0015.4927.309z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
111,525111,5241.0028.5232.61.856z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
111,19592,4990.83130.7141.4.33jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
106,89100.0012.3523.8076nzpvfmj776g JDBC Thin Client SELECT questionID, data FROM f...
92,33792,3371.001,246.8612.978.59j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
81,52600.005.3825073r2ts8p97um2 JDBC Thin Client SELECT flags FROM users WHERE ...
75,12875,1281.009.8923.706y55dxn24t86q   select obj#, intcol#, ts#, fil...
74,66574,6651.008.9126.70054rpfwwu14za JDBC Thin Client SELECT url FROM tests WHERE te...
74,267307,2984.1410.3226.3.4ckr1vbptqjnd1 JDBC Thin Client SELECT mediaID FROM mediaconsu...
72,656145,3102.00138.9156.7.6aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
52,04140,7600.7811.8932.500qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
40,76340,7631.005.9631.60dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
40,76355,2651.3633.4345.30ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
40,763101,2402.4810.7436.507cbf1umqgg15a 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
48,129152,12654.370wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
21,854197,35624.696fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
9,2279,22710.42350f5yrnnmshs   lock table sys.mon_mods$ in ex...
19918,7160.228fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
19618,1310.22b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
196318,9360.22d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
196162,1650.227jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
19440,7630.22dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
19218,1100.22gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
19140,7630.22ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...

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.47152,12612.143,152.926.9913.5270.730wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
124.1692,3376.841,246.869.9612.9378.559j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
111.29197,3566.132,404.834.6312.5662.396fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
88.959,1714.90330.5226.9121.4955.32d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
64.12111,1953.53130.7149.0641.400.283jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
39.2072,6562.16138.9128.2256.670.58aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
23.4118,1101.29198.1311.8115.9574.08gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
22.8418,1311.26132.2717.2777.200.11b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
16.01970.88140.7811.3724.5163.22aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
9.3140,7630.5133.4327.8745.340.02ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
7.10570.3958.4412.1515.9874.680m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
2.4818,7160.146.2339.7833.050.008fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
2.359,2270.135.6941.2973.494.14g00cj285jmgsw   update sys.mon_mods$ set inser...
1.621,5120.095.4929.5865.880.459dd5xusnyg10n JDBC Thin Client SELECT * FROM attemptdata WHER...
0.686200.047.708.8161.0326.699tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
0.4920.034.6510.4766.4523.626ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.3390.0211.222.9425.8113.077f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...
0.24160.0113.451.7620.790.16f3999s9g0mmgm perl@lair (TNS V1-V3) SELECT tablespace_name , SUM( ...
0.16301,4720.0118.670.8628.940.01d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
0.10111,5250.0128.520.3532.571.8056z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
0.0930.001,457.180.0161.3637.2805s9358mm6vrr   begin dbms_feature_usage_inter...
0.094,0430.000.8410.5420.5337.606b9n2bk019yv6 JDBC Thin Client SELECT questionID from groupme...
0.0730.001,450.780.0061.5537.442d1p0p5k3f8fu   select p, NULL, NULL from (sel...
0.072390.000.5013.5321.4158.57bjrsu1sf38nx2 JDBC Thin Client SELECT g.groupID, gm.name, g.e...
0.04230.000.1037.3631.4537.909wncfacx0nj9h   insert into smon_scn_time (thr...
0.036200.000.1422.0327.449.41gacbtcuuq5rwv JDBC Thin Client SELECT * FROM questionbanks WH...
0.0320.000.0832.7972.330.00cd1dfrzuta22f   WITH awr_params as ( SELECT /*...
0.0330.000.1024.6548.0636.3847mm81hm9sggy   SELECT sum(case when a.sessio...
0.0220.000.0926.5877.940.00bsvzkk7xc8dd9   SELECT sum(blk_read) as blk_r...
0.0220.000.1119.5280.420.0074g6ka8ncc1jb   WITH ash as (SELECT ash.event...
0.0260.002.240.8493.905.1553qg5xxgv1jxm JDBC Thin Client SELECT medialookaside.* FROM m...
0.0230.000.1018.5383.600.415h91zx386wbht   WITH awr_params as ( SELECT /*...
0.0130.003.060.4816.851.221cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
0.01114,9880.0015.490.0827.330.009z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
0.0110.000.234.2989.556.194dy1xm4nxc0gf   insert into wrh$_system_event ...
0.01395,6130.0039.810.0230.340.00dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
0.0130.000.135.5791.440.866cp74g22fzahf   WITH ash as (SELECT ash.event...
0.0120.000.0612.1787.220.008h01dqpvft7r3   WITH awr_evts as (SELECT e.eve...
0.0120.000.0159.9643.510.0092yv7gw4g8b94   SELECT decode(es.name, 'cache'...
0.0130.000.0138.1564.610.006wm3n4d7bnddg   SELECT source, (case when tim...

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')
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
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
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6y55dxn24t86qselect obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1
73r2ts8p97um2SELECT flags FROM users WHERE listID=:1 AND userID=:2
74g6ka8ncc1jb 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.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.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
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
8h01dqpvft7r3WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_instance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
8w92u8fd9rccdSELECT * FROM library WHERE parentID =:1
92yv7gw4g8b94SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name
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
9wncfacx0nj9hinsert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
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 )
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
bsvzkk7xc8dd9 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#, sum(endsn.phyblkrd - nvl(startsn.phyblkrd, 0)) as blk_read, sum(endsn.phyblkwrt - nvl(startsn.phyblkwrt, 0)) as blk_write, sum(endsn.readtim - nvl(startsn.readtim, 0)) * 10000 as read_time, sum(endsn.writetim - nvl(startsn.writetim, 0)) * 10000 as write_time, sum(endsn.phyrds - nvl(startsn.phyrds, 0)) as tot_reads, sum(endsn.phywrts - nvl(startsn.phywrts, 0)) as tot_writes, sum(endsn.singleblkrds - nvl(startsn.singleblkrds, 0)) as sb_reads, sum(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.snap_id = :eid AND startsn.dbid(+) = :dbid AND startsn.instance_number(+) = endsn.instance_number AND startsn.snap_id(+) = :bid GROUP BY endsn.file#, endsn.creation_change# ) 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
cd1dfrzuta22fWITH 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.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)
ckr1vbptqjnd1SELECT mediaID FROM mediaconsumers WHERE testID=:1
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
f3999s9g0mmgmSELECT tablespace_name , SUM( bytes ) total_bytes FROM dba_data_files WHERE tablespace_name NOT IN ( 'SYSTEM', 'XDB', 'CWMLITE' ) AND tablespace_name NOT LIKE 'UNDO%' AND tablespace_name NOT LIKE 'ROLLB%' AND tablespace_name NOT LIKE 'PARTDATA%' AND tablespace_name NOT LIKE 'PARTINDX%' AND tablespace_name NOT LIKE 'SYSAUX%' GROUP BY tablespace_name
ff1nrgm5dnjrbSELECT datasize, mediatype, data, height, width FROM media WHERE mediaID=:1 ORDER BY block
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,7334.530.38
application wait time490.000.00
background checkpoints completed30.000.00
background checkpoints started40.000.00
background timeouts102,4589.510.79
Batched IO block miss count200.000.00
Batched IO (bound) vector count20.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count20.000.00
Batched IO (full) vector count00.000.00
Batched IO same unit count90.000.00
Batched IO single block count10.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count80.000.00
Batched IO vector read count30.000.00
Block Cleanout Optim referenced5,1780.480.04
branch node splits490.000.00
buffer is not pinned count30,665,2812,847.47236.13
buffer is pinned count10,243,864951.2178.88
bytes received via SQL*Net from client9,462,017,879878,610.9572,859.85
bytes sent via SQL*Net to client5,936,785,813551,269.8345,714.70
bytes via SQL*Net vector to client358,911,50733,327.312,763.71
Cached Commit SCN referenced455,94642.343.51
calls to get snapshot scn: kcmgss48,939,8204,544.39376.85
calls to kcmgas7,695,991714.6259.26
calls to kcmgcs9,079,665843.1169.92
CCursor + sql area evicted00.000.00
cell physical IO interconnect bytes161,390,161,40814,986,144.071,242,743.76
change write time16,4761.530.13
cleanout - number of ktugct calls67,8556.300.52
cleanouts and rollbacks - consistent read gets2,3430.220.02
cleanouts only - consistent read gets202,30518.791.56
cluster key scan block gets2,2840.210.02
cluster key scans1,5460.140.01
cluster wait time181,62516.871.40
commit batch/immediate performed5320.050.00
commit batch/immediate requested5320.050.00
commit cleanout failures: block lost1,0680.100.01
commit cleanout failures: buffer being written50.000.00
commit cleanout failures: callback failure5,7740.540.04
commit cleanout failures: cannot pin170.000.00
commit cleanouts836,87477.716.44
commit cleanouts successfully completed830,01077.076.39
commit immediate performed5320.050.00
commit immediate requested5320.050.00
Commit SCN cached45,6254.240.35
commit txn count during cleanout157,58414.631.21
concurrency wait time92,3198.570.71
consistent changes436,34940.523.36
consistent gets36,661,2373,404.24282.30
consistent gets - examination15,896,7731,476.12122.41
consistent gets direct5800.050.00
consistent gets from cache36,660,6573,404.18282.30
consistent gets from cache (fastpath)17,597,1951,634.02135.50
CPU used by this session1,785,818165.8313.75
CPU used when call started200,60618.631.54
CR blocks created482,12144.773.71
cursor authentications1720.020.00
data blocks consistent reads - undo records applied2,9790.280.02
db block changes11,040,4101,025.1885.01
db block gets665,994,41661,841.995,128.32
db block gets direct1360.010.00
db block gets from cache665,994,28161,841.975,128.32
db block gets from cache (fastpath)1,111,939103.258.56
DB time1,161,676107.878.95
DBWR checkpoint buffers written696,11964.645.36
DBWR checkpoints510.000.00
DBWR fusion writes206,27319.151.59
DBWR transaction table writes36,2653.370.28
DBWR undo block writes141,01113.091.09
deferred (CURRENT) block cleanout applications380,52135.332.93
DFO trees parallelized360.000.00
dirty buffers inspected40,7083.780.31
Effective IO time582,28354.074.48
enqueue conversions6,167,106572.6647.49
enqueue releases15,257,3351,416.74117.49
enqueue requests15,325,9591,423.12118.01
enqueue timeouts68,6136.370.53
enqueue waits673,57062.555.19
exchange deadlocks300.000.00
execute count3,170,909294.4424.42
file io wait time7,434,542,503690,346.4557,247.80
flashback cache read optimizations for block new34,5373.210.27
flashback direct read optimizations for block new10.000.00
flashback log write bytes8,762,212,352813,629.3867,471.18
flashback log writes41,5333.860.32
free buffer inspected3,856,047358.0629.69
free buffer requested6,525,137605.9050.25
gc blocks compressed2,164,160200.9616.66
gc cr block flush time1,5220.140.01
gc cr block receive time34,0413.160.26
gc cr blocks received976,89790.717.52
gc cr blocks served1,020,12294.737.86
gc current block flush time18,5071.720.14
gc current block pin time4,6570.430.04
gc current block receive time79,0557.340.61
gc current blocks received1,912,250177.5714.72
gc current blocks served1,875,543174.1614.44
gc kbytes saved8,961,969832.1869.01
gc kbytes sent14,203,3531,318.88109.37
gc local grants851,38479.066.56
gc read wait time10.000.00
gc read waits10.000.00
gc reader bypass grants6,9470.650.05
gc remote grants2,477,558230.0619.08
gcs messages sent13,847,1261,285.80106.63
ges messages sent2,151,070199.7416.56
global enqueue get time113,40710.530.87
global enqueue gets async3,8790.360.03
global enqueue gets sync4,987,669463.1438.41
global enqueue releases2,759,808256.2721.25
heap block compress122,82411.410.95
Heap Segment Array Inserts3780.040.00
Heap Segment Array Updates2400.020.00
hot buffers moved to head of LRU339,49931.522.61
HSC Heap Segment Block Changes1,552,752144.1811.96
immediate (CR) block cleanout applications204,65119.001.58
immediate (CURRENT) block cleanout applications20,5101.900.16
in call idle wait time62,933,6135,843.80484.60
index crx upgrade (positioned)1790.020.00
index crx upgrade (prefetch)220.000.00
index fast full scans (full)90.000.00
index fetch by key809,42675.166.23
index scans kdiixs12,462,127228.6218.96
leaf node splits7,6470.710.06
leaf node 90-10 splits4170.040.00
lob reads7,3580.680.06
lob writes3500.030.00
lob writes unaligned3500.030.00
logical read bytes from cache5,756,149,030,912534,496,513.8844,323,757.03
logons cumulative3030.030.00
max cf enq hold time4,4300.410.03
messages received17,941,0561,665.95138.15
messages sent17,941,0561,665.95138.15
min active SCN optimization applied on CR5350.050.00
no buffer to keep pinned count2,9570.270.02
no work - consistent read gets11,254,9531,045.1086.67
non-idle wait count50,184,0204,659.92386.43
non-idle wait time1,469,055136.4111.31
Number of read IOs issued5800.050.00
opened cursors cumulative1,249,613116.039.62
Parallel operations not downgraded360.000.00
parse count (describe)840.010.00
parse count (hard)3390.030.00
parse count (total)88,5188.220.68
parse time cpu2,2540.210.02
parse time elapsed11,7481.090.09
physical read bytes22,784,827,3922,115,721.94175,448.75
physical read IO requests2,724,656253.0020.98
physical read total bytes35,970,530,3043,340,101.68276,981.89
physical read total IO requests2,821,804262.0221.73
physical read total multi block requests11,4291.060.09
physical reads2,781,351258.2721.42
physical reads cache2,775,845257.7621.37
physical reads cache prefetch58,3215.420.45
physical reads direct5,5060.510.04
physical reads direct (lob)5800.050.00
physical reads direct temporary tablespace00.000.00
physical reads for flashback new1,346,271125.0110.37
physical reads prefetch warmup6,4640.600.05
physical write bytes72,138,645,5046,698,550.43555,485.23
physical write IO requests1,237,824114.949.53
physical write total bytes125,419,622,91211,646,041.63965,761.81
physical write total IO requests2,519,255233.9319.40
physical write total multi block requests80,4167.470.62
physical writes8,805,987817.6967.81
physical writes direct7,154,560664.3555.09
physical writes direct temporary tablespace7,153,410664.2455.08
physical writes from cache1,651,427153.3512.72
physical writes non checkpoint8,686,972806.6466.89
pinned buffers inspected6850.060.01
pinned cursors current2,0700.190.02
prefetch warmup blocks aged out before use76,3877.090.59
prefetched blocks aged out before use260.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'd4720.040.00
PX remote messages sent4720.040.00
queries parallelized360.000.00
recursive calls1,816,935168.7113.99
recursive cpu usage119,60111.110.92
redo blocks checksummed by FG (exclusive)18,598,4941,726.99143.21
redo blocks written23,446,5272,177.17180.54
redo buffer allocation retries5,2180.480.04
redo entries8,628,282801.1966.44
redo KB read11,227,4111,042.5486.45
redo log space requests5,2220.480.04
redo log space wait time680.010.00
redo ordering marks1,172,885108.919.03
redo size11,463,204,8161,064,434.4088,269.48
redo size for direct writes1,119,140103.928.62
redo subscn max counts251,10723.321.93
redo synch long waits12,0041.110.09
redo synch time31,0932.890.24
redo synch time (usec)310,969,84428,875.612,394.54
redo synch writes129,92612.061.00
redo wastage161,613,50015,006.881,244.46
redo write broadcast ack count3,3730.310.03
redo write broadcast ack time2,777,327257.8921.39
redo write time90,4148.400.70
redo writes547,13150.804.21
Requests to/from client3,981,282369.6930.66
rollback changes - undo records applied2860.030.00
rollbacks only - consistent read gets850.010.00
RowCR - row contention2600.020.00
RowCR attempts19,0321.770.15
RowCR hits18,7681.740.14
rows fetched via callback9,035,173838.9869.57
securefile allocation bytes9,970,049,024925,785.0076,771.82
securefile allocation chunks593,30155.094.57
securefile bytes non-transformed8,614,329,455799,897.4766,332.45
securefile number of non-transformed flushes265,01924.612.04
segment cfs allocations11,6351.080.09
segment chunks allocation from disepnser563,04952.284.34
segment dispenser allocations252,72223.471.95
segment dispenser load tasks4,3250.400.03
segment prealloc bytes2,986,344,448277,301.8422,995.58
segment prealloc ops86,9738.080.67
segment prealloc tasks80,4907.470.62
segment prealloc time (ms)16,243,7911,508.34125.08
segment prealloc ufs2cfs bytes2,259,230,720209,784.5217,396.63
segment total chunk allocation11,4961.070.09
session connect time00.000.00
session cursor cache hits1,261,504117.149.71
session logical reads702,655,62565,246.225,410.62
shared hash latch upgrades - no wait292,79127.192.25
SMON posted for undo segment shrink4330.040.00
sorts (memory)96,9979.010.75
sorts (rows)244,01722.661.88
sql area evicted00.000.00
sql area purged00.000.00
SQL*Net roundtrips to/from client3,981,304369.6930.66
summed dirty queue length530,18749.234.08
switch current to new buffer6,3430.590.05
table fetch by rowid18,349,4671,703.87141.30
table fetch continued row47,0114.370.36
table scan blocks gotten31,2962.910.24
table scan rows gotten816,62975.836.29
table scans (short tables)3,4290.320.03
total cf enq hold time18,7801.740.14
total number of cf enq holders1,6900.160.01
total number of times SMON posted133,44412.391.03
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks5320.050.00
undo change vector size916,760,66085,127.297,059.28
user calls5,004,283464.6838.53
user commits129,85112.061.00
user I/O wait time734,36868.195.65
user rollbacks150.000.00
workarea executions - optimal94,6638.790.73
write clones created in background1,7160.160.01
write clones created in foreground160.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory25,898,585,85643,206,217,600
opened cursors current8604,006
logons current328334
session uga memory max414,827,7442,794,814,592
session pga memory858,470,8481,990,664,256
session pga memory max911,230,0162,189,223,968
session cursor cache count5,9068,910

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)
Direct Writes0M0.000M54.6G44.325.189660 
Others12.3G8.711.1709227.3G8.042.59831139.3K0.99
LGWR1M0.01.00009222.4G110.972.12669547.3K1.12
Buffer Cache Reads21.2G252.512.013780M0.000M2717.7K2.13
DBWR46M0.27.00427112.6G70.491.1971029540.06
Direct Reads44M0.50.0040855M0.06.0004640 
TOTAL:33.6G262.003.19315116.9G233.8711.11223407.3K1.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
Temp File10M0.12.00092854.6G44.485.190960.13 
Data File21.2G253.032.0195312.6G70.441.199702.1311.21
Log File11G1.051.0489022.4G110.972.126882.810.00
Flashback Log0M0.000M16.2G4.621.536777.50 
Archive Log0M0.000M11G1.051.04760  
Control File1.6G7.94.149777400M2.38.0371420.1616.49
TOTAL:33.9G262.143.21915117.1G233.9311.13902.070.60

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)
Direct Writes 0M0.000M54.6G44.325.189660 
Direct Writes (Data File) 0M0.000M54.6G44.325.189660 
Others 12.6G8.841.1977527.6G8.072.62440134.1K0.95
Others (Flashback Log) 0M0.000M16.2G4.621.5369649.8K2.12
Others (Log File) 11.1G1.051.051220M0.000M311.87
Others (Archive Log) 0M0.000M11G1.051.050200 
Others (Control File) 1.5G7.67.145599397M2.36.03686482.6K0.23
Others (Data File) 10M0.12.0009284M0.04.00037116651.81
LGWR 1M0.01.00009222.4G110.992.127061001.21
LGWR (Log File) 0M0.000M22.4G110.972.12688323.28
LGWR (Control File) 1M0.01.0000922M0.01.000185680.24
Buffer Cache Reads 21.2G252.552.014150M0.000M2718.1K2.13
Buffer Cache Reads (Data File) 21.2G252.552.014150M0.000M2718.1K2.13
DBWR 0M0.000M12.6G70.511.197380 
DBWR (Data File) 0M0.000M12.6G70.511.197380 
Direct Reads 45M0.51.0041785M0.06.0004640 
Direct Reads (Data File) 45M0.51.0041785M0.06.0004640 
TOTAL: 33.8G261.913.21618117.1G233.9511.13892852.2K2.08

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,546,5972362.351.02575,953536280.96
TEMP 41700.531.00478,5824400.00
UNDOTBS2 122,763113.091.0051,38156,4573.38
EZTO_DATA 39,22248.091.0967,956600.00
EZTO_INDEX 13,19717.481.0760,9836902.22
SYSAUX 94605.171.341,297000.00
SYSTEM 4005.751.00137040.00
EZTO_LOB_MANUAL 8300.001.0019000.00
UNDOTBS1 300.001.00302,0884.58
UNDOTBS3 300.001.00309915.81
UNDOTBS4 300.001.00301,9045.84
USERS 300.001.003000.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 5605.711.0515000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.316.813959497 9006.671.1434000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.321.813959571 5708.601.0411000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.325.813959657 3607.781.8112000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.328.813959053 3605.001.0056000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.329.813959089 6508.151.0623000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.333.813958673 29208.151.00503000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.334.813958733 64507.741.24951000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.335.813958789 95007.491.121,559000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.336.813958889 96807.911.061,500000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.337.813958923 55308.261.03878000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.338.813958979 11506.781.00332000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.339.813958337 46107.721.03752000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.340.813958291 53609.531.05893000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.341.813958195 36407.171.15672000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.342.813958141 32607.521.12676000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.343.813958113 71507.681.051,357000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.344.813958015 2,59707.591.084,580000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.345.813957977 6,41817.851.099,696100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.346.813957901 6,28917.791.129,616100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.347.813957523 2,79608.031.114,078000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.348.813957523 1,13707.531.131,627000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.349.813957399 26807.841.05344000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.350.813957319 8707.701.0093000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.351.813957275 3805.261.0024000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.352.813957085 1400.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.353.813957085 1400.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.358.813956627 1600.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.359.813956627 1600.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.360.813956509 1600.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.361.813956439 1600.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.428.813950183 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.429.813950069 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.430.813950033 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.431.813949977 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.432.813949915 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.433.813949901 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.434.813949567 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.435.813949541 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.436.813949465 1100.001.002000.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 13706.201.001,964000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.440.813949055 900.001.0034000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.441.813948941 1001.001.003000.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 1001.001.003000.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 300.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.582.813930683 300.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.584.813930683 300.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.611.813964757 7507.471.2069000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.612.813964829 88207.851.071,716000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.617.813965575 8,52819.121.0917,712200.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.619.813965599 2,76308.991.055,389100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.620.813965653 26508.601.09459000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.621.813965689 14508.281.00189000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.622.813965729 2200.911.415000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.623.813965743 2700.371.005000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.624.813965799 3404.411.155000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.634.813966737 2102.861.195000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.636.813966819 2604.231.0012000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.637.813967121 2604.231.8810000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.638.813967189 1503.331.004000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.639.813967493 1300.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.640.813967621 1300.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.680.813970465 1500.001.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.683.813970633 3104.521.0022000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.298.813959857 11607.411.00276000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.299.813960597 22607.211.163,456058.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.302.813959711 4005.001.0046000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.303.813959883 10706.731.00125000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.305.813959771 3804.741.0073000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.306.813960601 34507.191.043,657052.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.315.813960647 43706.821.183,913075.71
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.317.813960159 4906.121.0082025.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.318.813960243 6905.941.00109000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.319.813960269 3304.241.0023000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.320.813960377 2,40405.961.066,561130.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.322.813960701 63607.201.034,554070.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.323.813960703 10007.801.082,641010.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.326.813960441 19507.541.181,712020.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.331.813960573 86306.431.075,308020.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.427.813950305 5207.501.0058000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.583.813930683 1608.751.2543000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.585.813930683 705.711.0034000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.586.813930683 2,49908.531.088,6951220.91
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.587.813930683 1,41409.091.056,4341121.67
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.588.813930683 51809.131.103,4410102.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.649.813967997 3,03307.441.089,7421123.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.277.813963385 62805.331.00681030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.278.813963293 5,59411.411.00636091.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.279.813963217 19,19920.931.005920110.91
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.280.813963173 42,96240.831.00652040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.281.813963093 31,98630.841.005340170.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.282.813962941 16,57720.921.00543070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.283.813962937 14,31010.911.01437042.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.284.813962933 55001.731.07200030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.285.813962919 2,68001.151.02308010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.286.813962777 3,99201.371.01397033.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.287.813961529 8,28311.131.01617090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.307.813961503 66901.431.01119010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.308.813961481 1,50601.091.0299061.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.309.813961455 56101.731.52134020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.310.813961447 66400.721.0021000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.311.813961441 19101.151.075000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.312.813961361 3004.001.708000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.313.813961275 3603.332.1711000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.314.813961143 3902.052.7714000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.327.813961001 29401.363.77139000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.330.813961111 1800.561.223000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.332.813960835 1,03901.753.90507000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.354.813957039 26502.793.756000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.355.813956965 3,97301.993.945000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.356.813956921 51502.893.879000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.357.813956683 15502.773.634000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.362.813956257 7703.641.00144000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.363.813956255 4207.621.0079010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.364.813956085 5808.281.0098000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.365.813956051 4308.371.0051000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.366.813956021 5307.921.0078000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.367.813955945 5106.081.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.368.813955909 4407.951.0032000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.372.813963441 81804.911.006350100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.374.813955661 24302.021.0030000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.375.813955617 3707.571.0024000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.376.813955601 3407.651.0024000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.377.813955491 3807.631.0026000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.378.813955445 3506.001.0025000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.379.813955209 3306.671.0039000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.380.813955209 5207.501.0036000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.381.813955073 5606.791.0064000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.382.813955049 4006.501.0028000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.383.813955033 6,85510.931.0059000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.384.813955005 5,34900.811.00107000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.385.813954953 5,45310.771.0073000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.386.813954697 4,29800.841.0065000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.387.813954641 8,71110.761.0034000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.388.813954551 7,99510.831.0069000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.389.813954459 5,76810.731.0030000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.390.813954401 5,58210.831.0041000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.391.813954053 5,15800.771.0040000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.392.813953999 9,86110.781.0033000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.393.813953881 4,64300.781.0049000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.394.813953847 3605.831.0034000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.395.813953839 1200.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.396.813953803 51901.681.0076000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.397.813953755 1200.001.006000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.398.813953409 22601.681.0063000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.399.813953343 42101.571.0076010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.400.813953257 58201.581.00118000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.401.813953157 29000.661.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.402.813953077 65001.091.0068010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.403.813952647 2605.771.0025000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.404.813952647 4606.091.0087000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.405.813952521 46701.861.0070000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.406.813952521 27601.961.00109000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.407.813952487 65201.561.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.408.813952435 5507.091.0050000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.409.813952381 48302.111.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.410.813952043 50701.581.0055000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.411.813952007 1,53500.991.0053000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.412.813951931 1,38400.891.0044000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.413.813951819 1,84600.881.00410210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.414.813951723 93701.071.0048000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.415.813951297 1,64500.961.0033000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.416.813951283 89300.951.0071000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.417.813951223 1,63100.781.0091020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.418.813951177 2,18400.931.0051000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.419.813951135 63200.981.0074000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.420.813951051 26902.231.0045000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.421.813951025 1,44501.041.00108000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.422.813950699 7006.431.0097000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.423.813950673 1,30801.001.00107000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.424.813950607 20902.111.0045000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.425.813950455 1,16301.071.0075000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.426.813950379 17102.631.0040010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.448.813948277 50801.101.0043000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.449.813948187 31101.801.0050000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.450.813947987 1,23300.941.0063010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.451.813947979 4807.711.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.452.813947939 47501.201.0078000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.453.813947873 5506.731.00117000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.454.813947825 68501.401.00107030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.455.813947707 33602.141.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.456.813947691 32402.281.0096050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.457.813947691 26402.771.0058000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.458.813947407 8805.231.00138020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.459.813947383 59801.511.00100000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.460.813947197 8207.201.00123000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.461.813947061 8508.241.00130000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.462.813946815 35202.671.0086000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.463.813946815 6107.381.0073000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.464.813946763 42801.941.0061000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.465.813946683 31701.641.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.466.813946639 6108.691.0069000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.467.813946501 77401.681.0086000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.468.813946487 28301.701.0077010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.469.813946471 7207.081.0093000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.470.813946199 64701.421.0058000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.471.813946119 95301.161.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.472.813945975 21302.771.0051020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.473.813945845 43401.411.0057000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.474.813945809 1100.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.475.813945777 1100.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.476.813945753 1100.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.477.813945677 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.478.813945635 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.479.813945499 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.480.813945463 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.481.813945463 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.482.813945201 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.483.813945089 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.484.813944999 42603.501.00135000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.485.813944841 10103.561.0037000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.486.813944825 1,56603.911.00585000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.487.813944759 2,62604.101.00878000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.488.813944759 5,70814.271.002,197000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.489.813944681 13,33514.301.005,634100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.490.813944637 7,64814.591.002,978000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.491.813944501 20,90424.631.008,922100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.492.813944451 20,90224.781.008,869100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.493.813944435 27,42134.611.0011,424100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.494.813944189 26,45424.811.0010,673100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.495.813944045 33,16434.231.0012,236100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.496.813943995 46,65143.141.0012,583100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.497.813943829 72,65871.871.009,603100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.498.813943801 53,05151.771.006,949100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.499.813943745 72,88371.561.007,765110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.500.813943711 65,64061.891.008,725110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.501.813943681 104,983101.711.0011,661110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.502.813943651 96,43791.921.0012,644110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.503.813943507 56,97752.191.009,009110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.504.813943451 85,98783.031.0025,109200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.505.813943405 65,30965.011.0037,462300.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.506.813943213 44,98845.901.0030,669300.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.507.813943029 36,67336.301.0026,666200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.508.813943027 28,98036.491.0022,175200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.509.813942881 23,20526.581.0017,762200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.510.813942815 18,66326.981.0014,993100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.511.813942745 21,11426.841.0016,581200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.512.813942737 17,25826.251.0012,585100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.513.813942723 13,18716.921.0010,362100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.514.813942707 9,08017.011.007,193100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.515.813942561 11,44716.411.008,491100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.516.813942347 8,01716.441.005,879100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.517.813942313 7,38416.621.005,684100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.518.813942081 16,12013.071.005,015070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.519.813941969 4,89106.531.003,679000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.520.813941903 15,29113.291.005,046070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.521.813941733 11,97813.941.004,738040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.522.813941663 12,71513.471.004,9180190.53
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.523.813941609 13,42813.051.004,165040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.524.813941583 24,16021.891.003,691050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.525.813941581 19,44922.241.003,611080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.526.813941565 16,02912.451.003,600080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.527.813941431 28,18731.591.003,2910161.88
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.528.813941165 32,95131.471.002,841010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.529.813940979 21,33921.731.002,698070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.530.813940819 17,52121.901.002,776040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.531.813940811 37,91541.281.002,670061.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.532.813940607 68,13761.061.002,612080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.533.813940523 46,03341.191.002,220052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.534.813940481 16,67021.701.002,136033.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.535.813940463 9,35212.351.001,850092.22
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.536.813940437 11,40411.851.002,019000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.537.813940423 18,18721.461.001,771060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.538.813940279 12,55311.721.001,7740111.82
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.539.813940047 3,89403.351.001,384000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.540.813939721 3,83203.241.001,286030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.541.813939403 20,02521.321.006,7261200.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.542.813939387 1807.222.335000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.543.813939261 60,35860.941.0017,7202620.48
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.544.813939237 56,60950.951.007,6981183.89
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.545.813938401 2,45704.901.001,286010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.546.813938341 86,74380.901.0013,2551631.75
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.547.813938325 1604.382.253000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.548.813938319 48,75650.871.0013,2171540.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.549.813938303 2,35906.051.001,606030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.550.813938207 116,657110.631.004,7070613.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.551.813938191 1606.882.383000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.552.813938079 2605.382.924000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.553.813937743 36102.833.903000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.554.813937633 1,04901.573.924000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.555.813937633 1708.242.597000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.556.813937587 3604.443.504000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.557.813935445 4102.683.464000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.558.813935373 1203.332.504000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.559.813935373 6205.163.564000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.560.813935373 5105.693.535000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.561.813935197 25203.533.893000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.562.813935181 1,05003.173.955000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.563.813935181 1,07303.013.934000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.564.813935135 1,93403.143.953000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.565.813934533 62003.633.894000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.566.813934531 9004.113.4111000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.567.813934505 38004.083.7523000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.568.813934439 4103.663.398000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.569.813932221 2405.002.798000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.570.813932219 1806.112.674000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.571.813932195 1703.532.944000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.572.813932077 1403.572.715000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.573.813932061 903.331.893000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.574.813932053 44801.723.975000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.575.813932007 89302.333.918000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.576.813931931 52101.983.933000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.577.813931235 85102.133.9635000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.578.813931235 1305.383.154000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.579.813931233 5207.503.635000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.580.813931231 8504.123.808000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.602.813963443 1,41203.771.14801082.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.603.813964375 1,32802.761.00530070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.604.813964415 1,91503.241.001,079082.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.605.813964431 2,21802.941.001,0410111.82
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.606.813964501 5,66711.341.006610102.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.607.813964515 10,37511.191.009030150.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.608.813964517 1,82802.371.01475000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.609.813964531 9,60711.141.00824050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.610.813964633 8,50611.231.00768080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.613.813964829 6,43511.581.008590100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.614.813964989 7,01011.371.00863040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.615.813965537 11,65711.081.007380120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.616.813965541 14,36610.991.00727020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.618.813965583 2,17901.781.03445010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.625.813965939 54405.721.00394010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.626.813966075 83902.961.00569010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.627.813966441 3,64801.411.00691010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.628.813966465 38706.301.00410020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.629.813966547 2,56901.751.00422010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.630.813966601 95202.721.00360010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.631.813966673 2,96801.431.00445000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.632.813966679 4,54001.151.00409000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.633.813966697 13,68710.991.00407025.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.635.813966761 23,89820.881.004160210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.641.813967621 3,60501.461.00440020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.642.813967681 8,22911.061.00366040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.643.813967757 6,76811.041.00559060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.644.813967757 9,17911.021.00377010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.645.813967767 11,04710.971.00303000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.646.813967769 12,61810.871.00216020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.647.813967891 5,51711.031.00372020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.648.813967981 3,60601.011.00330030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.650.813968021 6,04511.101.00330000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.651.813968357 3,00701.591.00264000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.652.813968501 4,68501.381.66991010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.653.813968795 7,04910.991.00262000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.654.813968829 3,51501.501.00254000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.655.813968865 3,90901.521.00410030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.656.813968891 6,98111.141.00479020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.657.813968899 3,97801.281.00281010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.658.813968943 3,28501.111.01132000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.659.813968967 2,31601.491.01426010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.660.813969061 2,25903.231.00798000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.661.813969097 6,92911.911.001,428010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.662.813969097 8,17512.051.001,375000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.663.813969469 12,22911.841.001,627020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.664.813969661 5,97113.581.002,208000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.665.813969945 4,59904.561.002,179000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.666.813970041 1700.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.667.813970041 1700.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.668.813970107 1700.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.669.813970169 11300.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.670.813970171 27100.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.671.813970175 9500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.672.813970209 9500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.673.813970237 2700.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.674.813970385 1500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.675.813970409 7100.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.676.813970427 1500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.677.813970429 1500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.678.813970435 1500.001.003000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.679.813970463 4,62505.611.002,603000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.681.813970561 4,61606.311.003,428000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.682.813970589 11006.361.1185000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.684.813970649 4,98706.931.003,953000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.713.816189311 1500.001.003000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.685.813970653 300.001.003000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.686.813970653 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.687.813970889 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.688.813971075 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.689.813971145 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.693.813971299 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.696.813971335 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.698.813971447 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.699.813971519 1000.001.002000.00
SYSAUX+EZTOPQA_DF/eztopqa_va/datafile/sysaux.697.813971341 94605.171.341,297000.00
SYSTEM+EZTOPQA_DF/eztopqa_va/datafile/system.694.813971299 4005.751.00137040.00
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.292.814111801 39000.411.0039,00840 
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.293.814111793 903.331.00127,686120 
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.294.814111787 902.221.00150,176140 
TEMP+EZTOPQA_DF/eztopqa_va/tempfile/temp.295.814111777 901.111.00161,712150 
UNDOTBS1+EZTOPQA_DF/eztopqa_va/datafile/undotbs1.690.813971153 300.001.00302,0884.58
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.589.813930683 49,75253.001.005,758190.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.590.813930683 34,13933.051.003,9400100.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.591.813930683 19,38823.291.0038,96646,4363.39
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.592.813930683 19,48423.191.002,717020.00
UNDOTBS3+EZTOPQA_DF/eztopqa_va/datafile/undotbs3.691.813971193 300.001.00309915.81
UNDOTBS4+EZTOPQA_DF/eztopqa_va/datafile/undotbs4.692.813971243 300.001.00301,9045.84
USERS+EZTOPQA_DF/eztopqa_va/datafile/users.695.813971333 300.001.003000.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,712100701,800,1162,603,0271,554,1140012,159
R483,71279818,272172,28196,912004

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000695,7140

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
B00651253727016833973830270168  0
E0144909511267196085149339738306085149  4

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.737,880119579.00
D7680.19912.206,349115740.00
D1,1520.281361.664,795111843.00
D1,5360.381811.464,203110360.00
D1,9200.472271.273,67419032.00
D2,3040.562721.143,28418054.00
D2,6880.663171.093,15117720.00
D3,0720.753631.063,06417502.00
D3,4560.844081.032,98617306.00
D3,8400.944531.012,92317150.00
D4,0961.004841.002,88617056.00
D4,2241.034990.992,86517004.00
D4,6081.135440.962,77116767.00
D4,9921.225900.932,68416549.00
D5,3761.316350.922,64216445.00
D5,7601.416800.912,61316372.00
D6,1441.507260.902,59116315.00
D6,5281.597710.892,57016263.00
D6,9121.698160.882,55316220.00
D7,2961.788620.872,52516151.00
D7,6801.889070.872,50916110.00
R3840.09451.022571211.00
R7680.19911.002521206.00
R1,1520.281361.002521206.00
R1,5360.381811.002521206.00
R1,9200.472271.002521206.00
R2,3040.562721.002521206.00
R2,6880.663171.002521206.00
R3,0720.753631.002521206.00
R3,4560.844081.002521206.00
R3,8400.944531.002521206.00
R4,0961.004841.002521206.00
R4,2241.034991.002521206.00
R4,6081.135441.002521206.00
R4,9921.225901.002521206.00
R5,3761.316351.002521206.00
R5,7601.416801.002521206.00
R6,1441.507261.002521206.00
R6,5281.597711.002521206.00
R6,9121.698161.002521206.00
R7,2961.788621.002521206.00
R7,6801.889071.002521206.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,650941.530.000.000.000.00838,860
E8,1925,7562,046.890.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
2K4K94,30894,30800
64K128K787800
256K512K4400
512K1024K19919900
1M2M707000

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.13603.9118.0497.0047140,963
2,0480.25603.910.00100.000136,874
4,0960.50603.910.00100.000136,874
6,1440.75603.910.00100.000136,874
8,1921.00603.910.00100.000136,874
9,8301.20603.910.00100.000136,874
11,4691.40603.910.00100.000136,874
13,1071.60603.910.00100.000136,874
14,7461.80603.910.00100.000136,874
16,3842.00603.910.00100.000136,874
24,5763.00603.910.00100.000136,874
32,7684.00603.910.00100.000136,874
49,1526.00603.910.00100.000136,874
65,5368.00603.910.00100.000136,874

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.79503,298206,6421.001471.002,915
2,7520.90503,298206,6421.001471.002,915
2,7840.91503,298206,6421.001471.002,915
2,8160.92503,298206,6421.001471.002,915
2,8480.93503,298206,6421.001471.002,915
2,8800.94503,298206,6421.001471.002,915
2,9120.95503,298206,6421.001471.002,915
2,9440.96503,298206,6421.001471.002,915
2,9760.97503,298206,6421.001471.002,915
3,0080.98503,298206,6421.001471.002,915
3,0400.99503,298206,6421.001471.002,915
3,0721.00503,298206,6421.001471.002,915
3,1041.01503,298206,6421.001471.002,915
3,1361.02503,298206,6421.001471.002,915
3,1681.03503,298206,6421.001471.002,915
3,2001.04503,298206,6421.001471.002,915
3,2321.05503,298206,6421.001471.002,915
3,2641.06503,298206,6421.001471.002,915
3,2961.07503,298206,6421.001471.002,915
3,3281.08503,298206,6421.001471.002,915
3,3601.09503,298206,6421.001471.002,915
3,3921.10503,298206,6421.001471.002,915
3,7121.21503,298206,6421.001471.002,915
4,0321.31503,298206,6421.001471.002,915
4,3521.42503,298206,6421.001471.002,915
4,6721.52503,298206,6421.001471.002,915
4,9921.63503,298206,6421.001471.002,915
5,3121.73503,298206,6421.001471.002,915
5,6321.83503,298206,6421.001471.002,915
5,9521.94503,298206,6421.001471.002,915
6,2722.04503,298206,6421.001471.002,915

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 header11,418484
2nd level bmb35701
3rd level bmb15201
data block9402
free list8801
undo block2400
1st level bmb1600
segment header1000
file header block500

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,487,2583,487,1930651,2605590.86
FU-DBFUS 3303450150,093.33
DW-In memory Dispenser 396,289331,27965,00714,14770.47
WF-AWR Flush 6666055237.27
CO-KTUCLO Master Slave enq (master slave det) 3,58803,5883,58810.26
TX-Transaction (index contention) 401401030711.89
FB-Format Block 2,1782,17801,59410.36
TX-Transaction 384,623384,624011714.53
HW-Segment High Water Mark 8,0008,000084010.61
CF-Controlfile Transaction 26,24726,244274700.63
JS-Job Scheduler (wdw op) 11010430.00
TM-DML 527,629527,588029500.88
TX-Transaction (row lock contention) 22020125.00
PS-PX Process Reservation 544542233400.69
RO-Multiple Object Reuse (fast object reuse) 18818804700.85
PI-Remote PX Process Spawn Status 262602200.91
TD-KTF map table enqueue (KTF dump entries) 333303300.30
TK-Auto Task Serialization (Auto Task Serialization) 121201200.83
JS-Job Scheduler (job run lock - synchronize) 963901.11
MW-MWIN Schedule 660601.67
WL-Being Written Redo Log 532205.00
KT-Scheduler Plan 1101010.00
TA-Instance Undo 646406400.00
JQ-Job Queue 11651100.00
DR-Distributed Recovery 660600.00
SQ-Sequence Cache 1581580500.00
TX-Transaction (allocate ITL entry) 550500.00
AF-Advisor Framework (task serialization) 33330400.00
UL-User-defined 440300.00
FL-Flashback database log (Flashback database log) 440200.00
KD-Scheduler Master DBRM (determine DBRM master) 211200.00
PR-Process Startup 1091090100.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 431100.00
RS-Reclaimable Space (prevent aging list update) 110100.00
TT-Tablespace 92,56792,5680100.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
4138.21383,3701,9611738.5/46.20/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:5911,27024,3681,93810450/00/0/0/0/0/0
15-Jul 23:4911,84423,8041,87712420/00/0/0/0/0/0
15-Jul 23:398,65920,3011,63811410/00/0/0/0/0/0
15-Jul 23:298,94319,1691,75411410/00/0/0/0/0/0
15-Jul 23:1913,27426,6741,78412460/00/0/0/0/0/0
15-Jul 23:099,23819,1401,78810440/00/0/0/0/0/0
15-Jul 22:5912,21129,8161,83614420/00/0/0/0/0/0
15-Jul 22:499,22328,1891,60912430/00/0/0/0/0/0
15-Jul 22:3913,95752,1481,61317430/00/0/0/0/0/0
15-Jul 22:2911,85751,5101,84614430/00/0/0/0/0/0
15-Jul 22:1910,88035,9281,5979420/00/0/0/0/0/0
15-Jul 22:097,02820,9811,6019420/00/0/0/0/0/0
15-Jul 21:594,89415,8671,2818390/00/0/0/0/0/0
15-Jul 21:493,0539,5776788380/00/0/0/0/0/0
15-Jul 21:391,7305,4591,9617450/00/0/0/0/0/0
15-Jul 21:29011,5930440/00/0/0/0/0/0
15-Jul 21:1961711,5794440/00/0/0/0/0/0
15-Jul 21:091422671,8033430/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,150,79110.520.0010 
active service list49,5840.010.0005,2650.00
alert log latch60.00 00 
AQ deq hash table latch30.00 00 
archive control1890.00 00 
archive process latch8850.00 00 
ASM allocation5,8870.00 00 
ASM db client latch1,924,7610.00 00 
ASM Keyed state latch2800.00 00 
ASM map headers7,1710.00 00 
ASM map load waiting list1,5390.00 00 
ASM map operation freelist1,3590.070.0000 
ASM map operation hash table15,745,2380.050.0000 
ASM network background latch15,1230.00 00 
ASM network SGA latch90.00 00 
ASM network state latch4,4510.00 00 
ASM scan context latch120.00 00 
AWR Alerted Metric Element list175,1990.00 00 
begin backup scn array90.00 00 
buffer pool30.00 00 
business card750.00 00 
cache buffer handles35,1430.00 00 
cache buffers chains1,438,980,6870.010.01010,158,0160.05
cache buffers lru chain26,900,0970.030.00012,636,1940.02
cache table scan latch0  017,4700.00
call allocation2,3000.480.1800 
cas latch30.00 00 
change notification client cache latch30.00 00 
Change Notification Hash table latch3,5920.00 00 
channel handle pool latch4510.00 00 
channel operations parent latch222,106,0330.010.0200 
checkpoint queue latch1,121,185,5040.000.0002,584,4320.01
client/application info9050.00 00 
compile environment latch3210.00 00 
Consistent RBA547,1870.000.0000 
corrupted undo seg latch1,3900.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1710.00 00 
cvmap freelist lock30.00 00 
deferred cleanup latch1710.00 00 
DML lock allocation1,055,4650.000.0000 
dml lock allocation1710.00 00 
done queue latch30.00 00 
dummy allocation6390.00 00 
enqueue freelist latch30.00 028,825,7530.01
enqueue hash chains43,018,5640.170.0001,5110.13
enqueues2,8970.00 00 
error message lists2880.00 00 
Event Group Locks4670.00 00 
FAL Queue2940.00 00 
fast space usage latch621,2340.000.0000 
FIB s.o chain latch9380.00 00 
fifth spare latch30.00 00 
file cache latch28,4170.00 00 
File State Object Pool Parent Latch8,088,9610.040.0000 
flashback allocation1,178,0240.000.0000 
flashback copy30.00 01,098,8640.03
flashback mapping41,7180.510.0000 
flashback prepare log info140.00 00 
flashback sync request71,7820.440.0000 
FOB s.o list latch35,4731.690.0200 
fourth Audit Vault latch30.00 00 
gc element29,902,2620.030.090826,3250.02
gcs commit scn state30.00 00 
gcs opaque info freelist4,025,1480.050.0000 
gcs partitioned table hash75,811,3610.190.000123,3180.01
gcs pcm hashed value bucket hash30.00 00 
gcs remaster request queue90.00 00 
gcs remastering latch1,042,88415.750.0000 
gcs resource freelist1,686,1340.000.0001,163,7490.00
gcs resource hash35,326,2930.040.0106010.00
gcs resource scan list1,5810.00 00 
gcs shadows freelist2,427,2560.000.0002,586,8490.00
ges caches resource lists1,552,8650.300.0102,291,0880.02
ges deadlock list1,7100.00 00 
ges DFS wait callback info120.00 010.00
ges domain table5,634,3420.000.0000 
ges enqueue table freelist5,741,0610.000.0200 
ges group table9,813,4050.000.0000 
ges process hash list129,936,4150.000.1300 
ges process parent latch15,170,6640.000.0000 
ges process table freelist2800.00 00 
ges resource hash list17,663,5880.050.08021,8810.09
ges resource scan list1,1450.00 00 
ges resource table freelist7,6880.00 00 
ges timeout list3,3100.00 021,2940.00
ges value block free list490.00 00 
global KZLD latch for mem in SGA660.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch3210.00 020,2600.00
hash table modification latch1,2850.00 00 
heartbeat check30.00 06,2770.00
heartbeat structure management0  02,1540.00
In memory undo latch30.00 00 
internal temp table object number allocation latch900.00 00 
interrupt manipulation1,1800.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,4090.00 04,7630.00
job workq parent latch230.00 0200.00
job_queue_processes free list latch400.00 00 
job_queue_processes parameter latch2,3640.00 00 
JS broadcast add buf latch2,4890.00 00 
JS broadcast drop buf latch2,4890.00 00 
JS broadcast load blnc latch2,1590.00 00 
JS mem alloc latch570.00 00 
JS queue access latch600.00 00 
JS queue state obj latch78,6220.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,8000.00 00 
KFMD SGA180.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,961,5990.170.010145,5680.05
KJCT flow control latch27,220,2050.010.0000 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
KMG MMAN ready and startup request latch3,5890.00 00 
kokc descriptor allocation latch120.00 00 
ksfv messages30.00 00 
ksim group membership cache1,363,0840.000.0000 
ksim membership request latch0  010,4330.00
kss move lock1090.00 00 
ksuosstats global area1,0860.00 00 
ksv allocation latch3810.00 00 
ksv class latch30,4180.050.1900 
ksv instance latch1040.00 00 
ksv msg queue latch1120.00 01090.00
ksxp shared latch2800.00 00 
ksxp so latch2800.00 00 
KSXR large replies80.00 00 
ksz_so allocation latch2800.00 00 
KTF sga latch990.00 03,5770.00
ktm global data524,7110.030.0000 
kwqbsn:qsga3750.00 00 
KWQMN job cache list latch7590.00 00 
k2q global data latch7,1780.00 00 
k2q lock allocation30.00 00 
lgwr LWN SCN550,8000.030.0000 
list of block allocation7,7940.00 00 
loader state object freelist1,6180.00 00 
lob segment dispenser latch1,230,3470.00 00 
lob segment hash table latch1,229,5290.000.0000 
lob segment query latch5300.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,9620.140.0000 
managed standby latch2910.00 00 
mapped buffers lru chain30.00 00 
Memory Management Latch30.00 03,5890.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,2290.010.0100 
messages59,676,2068.050.0010 
MinActiveScn Latch3,8290.030.0000 
mostly latch-free SCN565,7731.430.0100 
MQL Tracking Latch0  02140.00
msg queue latch30.00 00 
multiblock read objects211,9400.000.0000 
Mutex30.00 00 
Mutex Stats30.00 00 
name-service memory objects35,7000.00 00 
name-service namespace bucket4,164,0730.000.0000 
name-service namespace objects360.00 00 
name-service pending queue9,9940.00 00 
name-service request1080.00 00 
name-service request queue129,8690.00 00 
ncodef allocation latch1710.00 00 
object queue header heap281,695,6020.000.0003,290,2510.19
object queue header operation393,936,1320.010.0100 
object stats modification58,1140.030.0000 
OS process1,1020.00 00 
OS process allocation22,1480.00 00 
OS process: request allocation2800.00 00 
parallel query alloc buffer7,6510.00 00 
parallel query stats2570.00 00 
parallel txn reco latch66,4320.00 00 
parameter list4590.00 00 
parameter table management6710.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
PL/SQL warning settings3580.00 00 
post/wait queue3,077,6150.100.0003,278,2990.41
process allocation17,5600.00 01430.00
process group creation2800.00 00 
process queue9270.00 00 
process queue reference15,2250.020.0001,4660.00
PX hash array latch30.00 00 
qmn task queue latch1,5270.00 00 
QMT30.00 00 
query server freelists6910.00 00 
query server process540.00 0180.00
queued dump request360.00 00 
queuing load statistics30.00 00 
Real-time plan statistics latch6480.00 00 
recovery domain hash list30.00 00 
redo allocation2,816,4870.130.0108,619,0260.44
redo copy30.00 08,632,5460.30
redo writing19,090,9575.210.0000 
reservation so alloc latch40.00 00 
Reserved Space Latch110.00 00 
resmgr group change latch1,362,6800.000.0000 
resmgr:active threads36,2590.001.0003,5970.00
resmgr:actses change group2990.00 00 
resmgr:actses change state330.00 00 
resmgr:free threads list6860.00 00 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method52,6700.130.0000 
resmgr:schema config1,738,2191.420.93591191.68
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects1,441,298,31226.850.0389240.00
second Audit Vault latch30.00 00 
second spare latch30.00 00 
segmented array pool8960.00 00 
sequence cache1,518,4010.040.0100 
session allocation132,1530.000.000131,5650.00
session idle bit10,141,0180.000.0100 
session queue latch30.00 00 
session state list latch6030.00 00 
session switching3111.290.2500 
session timer3,5840.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA IO buffer pool latch450.00 0450.00
SGA pool locks30.00 00 
Shared B-Tree3780.00 00 
shared pool10,443,4610.030.0100 
shared pool sim alloc160.00 00 
shared pool simulator6190.00 00 
sim partition latch30.00 00 
simulator hash latch46,952,8670.000.0000 
simulator lru latch30.00 046,719,3840.01
sort extent pool195,9220.000.0000 
space background state object latch190.00 00 
space background task latch1,873,1948.970.05256,8660.08
SQL memory manager latch30.00 03,5810.00
SQL memory manager workarea list latch241,5950.00 00 
state object free list60.00 00 
statistics aggregation1,6800.00 00 
Streams Generic30.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation120.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
Testing30.00 00 
third spare latch30.00 00 
threshold alerts latch5500.00 00 
Token Manager30.00 00 
trace latch50.00 00 
transaction allocation2,296,2410.000.0000 
undo global data655,192,6710.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$KSFQP1710.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects1,441,298,312386,931,62711,099,473378,476,391
messages59,676,2064,804,7154,9634,799,772
active checkpoint queue latch19,150,7912,015,6014,1052,011,499
redo writing19,090,957994,5311,994992,537
space background task latch1,873,194167,9568,906159,053
undo global data655,192,671143,349345143,014
cache buffers chains1,438,980,687125,1981,309123,901
enqueue hash chains43,018,56471,44221471,230
object queue header operation393,936,13248,11652047,598
channel operations parent latch222,106,03325,36140024,966
resmgr:schema config1,738,21924,68722,9741,729
checkpoint queue latch1,121,185,50414,5364014,496
gcs resource hash35,326,29314,26610314,166
cache buffers lru chain26,900,0979,142149,128
ges resource hash list17,663,5888,5116947,818
gc element29,902,2628,2417587,510
ASM map operation hash table15,745,2388,204108,194
mostly latch-free SCN565,7738,0751027,974
object queue header heap281,695,6025,230145,216
ges caches resource lists1,552,8654,607324,575
redo allocation2,816,4873,635403,595
KJC message pool free list1,961,5993,358383,321
shared pool10,443,4613,317323,285
post/wait queue3,077,6153,07933,076
File State Object Pool Parent Latch8,088,9612,885112,874
KJCT flow control latch27,220,2052,67782,670
gcs opaque info freelist4,025,1481,85251,847
message pool operations parent latch4,793,2296558647
FOB s.o list latch35,47360014589
sequence cache1,518,4015743571
session idle bit10,141,0184855480
ges process hash list129,936,41539351342
ges group table9,813,4053201319
flashback mapping41,7182141213
ges enqueue table freelist5,741,0611052103
ksv class latch30,41816313
call allocation2,30011210
session switching311413
resmgr:active threads36,259110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active checkpoint queue latchkcbbacq: scan active checkpoints03,8863,984
active checkpoint queue latchkcbkcpa: Checkpoint post-processing09887
active checkpoint queue latchkcbkcpa: Checkpoint post-processing 208515
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 101912
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 20105
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 3072
ASM map operation hash tablekffmDoDone_1056
ASM map operation hash tablekffmTranslate054
cache buffers chainskcbchg1: clear MS bit05721
cache buffers chainskcbbxsv0282290
cache buffers chainskcbgcur_40171350
cache buffers chainskcbrls_2010650
cache buffers chainskcbzwb0814
cache buffers chainskclbla06222
cache buffers chainskclwlr03111
cache buffers chainskcllkopesc0144
cache buffers chainskcbgcur_2090
cache buffers chainskcbzib: finish processing buffer081
cache buffers chainskclcqchk080
cache buffers chainskcbkzs060
cache buffers chainskclwrt065
cache buffers chainskcbchg1: mod cr pin030
cache buffers chainskcbchg1: mod cur pin033
cache buffers chainskclexpandlock0334
cache buffers chainskcbzgb: scan from tail. nowait020
cache buffers chainskcbbic1010
cache buffers chainskcbgtcr: fast path016
cache buffers chainskcllkopb_1010
cache buffers lru chainkcbkcxe050
cache buffers lru chainkcbbic2037
cache buffers lru chainkcbzgws030
cache buffers lru chainkcbbxsv: move to being written020
cache buffers lru chainkcbbwlru014
call allocationksuxds022
channel operations parent latchksrwait()0304273
channel operations parent latchksrapublish()0458
channel operations parent latchksrpubwait():1044104
channel operations parent latchksrsconsume()03048
channel operations parent latchksrmfree()0137
checkpoint queue latchkcbkubc_402111
checkpoint queue latchkcbklbc_cql090
checkpoint queue latchkcbbwdl: thread checkpoint queue046
checkpoint queue latchkcbbwthc: thread checkpoint buffers0422
checkpoint queue latchkcbkllscn020
enqueue hash chainsksqrcl01139
enqueue hash chainsksqcmi: if lk mode not requested064183
enqueue hash chainsksqcmi: if lk mode requested0194
enqueue hash chainsksqcnl0112
enqueue hash chainsksqgtl30718
File State Object Pool Parent LatchFSO create068
File State Object Pool Parent LatchFSO delete normal053
flashback mappingkrfw_advance_mapping1010
FOB s.o list latchksfd_fobd01414
gc elementkclchkping06380
gc elementkclnfndnewm03624
gc elementkclrwrite03134
gc elementkclfwrite102018
gc elementkclbla0188
gc elementkclulb0915
gc elementkclwrt078
gc elementkcl_fairness030
gc elementkclcqchk02619
gc elementkclhngcbk1020
gc elementKCLUNLNK0224
gc elementkclebs011
gc elementkcllwr010
gc elementkclrlstp011
gc elementkclrwrite_10010
gc elementkclshrsplit012
gcs opaque info freelistkjbrcvt save opaque info043
gcs opaque info freelistkjbrinfofree free opaque info012
gcs resource hashkclrwrite02019
gcs resource hashkjbassume0199
gcs resource hashkjbrwrdone reget0141
gcs resource hashkclfwrite10129
gcs resource hashkjbcrcomplete0121
gcs resource hashkjbcropen096
gcs resource hashkjbopen071
gcs resource hashkjbconvert051
gcs resource hashkclpdc011
gcs resource hashkjbcrconvert010
gcs resource hashkjbmdowncvt017
gcs resource hashkjbmpopen017
gcs resource hashkjbopen:affinity011
ges enqueue table freelistkjlalc: lock allocation011
ges enqueue table freelistkjlfr: remove lock from parent object011
ges group tablekjgagll: move a lock from process lock list to group lock list011
ges process hash listkjakiqa: set inquiry response0510
ges resource hash listkjakcai: search for resp by resname039521
ges resource hash listkjlrlr: remove lock from resource queue013550
ges resource hash listkjlmfnd: search for lockp by rename and inst id012310
ges resource hash listkjucvl: lock convert request0160
ges resource hash listkjrmas1: lookup master node0150
ges resource hash listkjakoca: search for resp by resname07602
ges resource hash listkjcvscn: remove from scan queue020
ges resource hash listkjuinq: inquire resource held mode010
ges resource table freelistkjchc: clean resource cache0300
ges resource table freelistkjrm2c: move resource to cache0233
KJC message pool free listkjcsmpav: allocate a msg buffer03539
KJC message pool free listkjcspfmbq: free vector of msg buffers030
KJCT flow control latchkjcts_sqenq: queue a message042
KJCT flow control latchkjctcsnd: send normal message033
KJCT flow control latchkjcts_sedeqv2: dequeue a vector of msgs012
ksv class latchksvclsl: rdp - recycle030
lgwr LWN SCNkcs0230270
lob segment hash table latchlob_segment_dispenser:30010
message pool operations parent latchksrmalloc()053
message pool operations parent latchksrmdone()023
message pool operations parent latchksrmfree()023
messagesksarcv02,9191,910
messagesksarcv: after wait01,1141,492
messagesksaamb: after wakeup09301,561
mostly latch-free SCNkcslcu3075102
object queue header heapkcbo_link_q:alloc0111
object queue header heapkcbo_check_flist0113
object queue header heapkcbo_unlink_q010
object queue header heapkcbo_unlink_q_bg010
object queue header operationkcldbufs018288
object queue header operationkcbo_switch_mq_bg07033
object queue header operationkcbo_link_q06934
object queue header operationkcbo_switch_q_bg06422
object queue header operationkcbo_unlink_q04218
object queue header operationkcbo_unlink_q_bg03722
object queue header operationkcbo_check_flist029327
object queue header operationkcbo_link_q:reget0221
object queue header operationkcbo_switch_cq0227
object queue header operationkclbufs0153
PC and Classifier lists for WLMNo latch010
post/wait queueksliwat:add:nowait030
redo allocationkcrfw_redo_gen: redo allocation 10400
redo writingkcrfwcr01,9221,949
redo writingkcrfw_cal_target_rba04123
redo writingkcrfw_post: rba scn pair0310
resmgr:active threadskgsksimsetup1010
resmgr:schema configkgskgmaxdop1022,59822,939
resmgr:schema configkgskgasi1031533
resmgr:schema configkgskmetricupd0570
resmgr:schema configkgskgcs1030
resmgr:schema configkgskscscb010
row cache objectskqrpre: find obj04,999,1946,351,766
row cache objectskqreqd: reget03,388,5882,126,157
row cache objectskqreqd02,711,2662,621,117
sequence cachekdnnxt: cached seq020
sequence cachekdnss013
session idle bitksupuc: set busy034
session idle bitksupuc: clear busy010
session idle bitksuxds011
session switchingkskexeall011
shared poolkghalo02024
shared poolkghfre0128
space background task latchktsj_grab_task08,5488,863
space background task latchktsjCreateTask02839
space background task latchktsj_detach_task07535
undo global dataktudba: KSLBEGIN0343342
undo global dataktubnd:child010
undo global dataktucof: at start010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal2 91380
Library Cachekglpin1 4260
Library Cachekglpndl1 95100
Cursor Pinkksfbc [KKSCHLFSP2]90
Library Cachekglpnal1 9070
Library Cachekglobpn1 7150
Library Cachekglhdgn2 10640
Library Cachekgllkdl1 8530
Cursor PinkksLockDelete [KKSCHLPIN6]20
Library Cachekgllkal1 8010
Cursor Pinkksfbc [KKSCHLPIN1]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,249,7440.18
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX1,056,4160.15
EZTOEZTO_DATALIBRARYSYS_P17813TABLE PARTITION754,6720.11
EZTOEZTO_INDEXBYCONSTESTMEDIA INDEX658,7200.09
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX634,3680.09

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB102,3973.68
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41283LOB PARTITION14,1120.51
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41246LOB PARTITION10,2840.37
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50532LOB PARTITION5,4790.20
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50595LOB PARTITION4,4760.16

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB102,3983.76
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50532LOB PARTITION5,4790.20
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50595LOB PARTITION4,4760.16
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48781LOB PARTITION4,1350.15
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48447LOB PARTITION3,9110.14

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB102,3983.76
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50532LOB PARTITION5,4790.20
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50595LOB PARTITION4,4760.16
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48781LOB PARTITION4,1350.15
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48447LOB PARTITION3,9110.14

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 PARTITION1262.29

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB95,1191.08
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX29,0200.33
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,5830.03
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50532LOB PARTITION1,8040.02
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50419LOB PARTITION1,7390.02

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX24,5531.98
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,1710.18
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,8140.15
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50765LOB PARTITION1,2510.10
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,2370.10

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 PARTITION1360.00

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 INDEX321,61633.16
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB104,51210.78
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX24,9442.57
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION23,9042.46
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49041INDEX PARTITION16,7361.73

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 INDEX9459.87
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION53.18
EZTOEZTO_INDEXATTEMPTDATA_PKSYS_P49698INDEX PARTITION42.55
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49413INDEX PARTITION42.55
EZTOEZTO_INDEXATTEMPT_TESTUSERID_IDXSYS_P39068INDEX PARTITION42.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_P50834LOB PARTITION114.55
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50501LOB PARTITION72.89
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50743LOB PARTITION72.89
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50748LOB PARTITION72.89
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50808LOB PARTITION72.89

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 INDEX1127.50
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50400LOB PARTITION717.50
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX512.50
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48751LOB PARTITION37.50
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB37.50

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 PARTITION44,3124.54
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX35,9193.68
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41296LOB PARTITION2,9440.30
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41294LOB PARTITION2,2500.23
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,2050.12

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX150,2537.86
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX29,3011.53
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION2,5860.14
EZTOEZTO_INDEXATTEMPT_TESTUSERID_IDXSYS_P39068INDEX PARTITION2,0370.11
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,2000.06

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_control1962.040 31
dc_files5,9700.000 0398
dc_global_oids250.000 031
dc_histogram_data3904.100 0457
dc_histogram_defs5,3853.270 04,441
dc_objects239,5270.110 06,710
dc_profiles190.000 01
dc_rollback_segments479,833,4300.000 01,040
dc_segments83,9340.470 22416,898
dc_sequences15379.740 1538
dc_tablespaces100,3300.000 012
dc_users167,3790.000 075
global database name10,0150.000 01
outstanding_alerts13892.750 00
sch_lj_oids2114.290 05

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control1040
dc_histogram_defs17600
dc_objects264570
dc_segments8465010
dc_sequences3061210
outstanding_alerts2641280
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
ACCOUNT_STATUS300.000 00
BODY1042.882,3920.1300
CLUSTER10.0010.0000
DBLINK740.000 00
EDITION600.00790.0000
INDEX2820.002828.51240
QUEUE0 1790.0000
SCHEMA600.000 00
SQL AREA89,9320.123,241,3810.0176109
SQL AREA BUILD25043.200 00
SQL AREA STATS25169.7225169.7200
TABLE/PROCEDURE78,2360.03708,6520.02330

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS300000
BODY02,3862,38600
CLUSTER11100
DBLINK740000
EDITION60606000
INDEX28228228200
QUEUE017917900
SCHEMA190000
TABLE/PROCEDURE78,531629,867629,86700

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
BOther895.98 2.714.665454331331
Freeable43.250.001.081.828 4040
SQL1.580.100.010.0105285276
PL/SQL0.930.350.000.0100329328
EOther1,966.56 5.846.285454337337
Freeable74.190.000.480.838 153153
SQL6.100.600.020.0205288281
PL/SQL1.340.460.000.0200335334

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.48862.10-16.42
sharedgcs resources214.34214.340.00
sharedgcs shadows125.03125.030.00
sharedges enqueues161.35163.261.18
sharedges resource88.4789.461.12
sharedksunfy : SSO free list119.14119.140.00
sharedKTSL subheap51.40162.51216.14
sharedobject queue 61.96 
 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,7680.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,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
D0000.0010,7680.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00 0.000.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/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_number2  
large_pool_size268435456  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.169.2.55)(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  
thread2  
undo_tablespaceUNDOTBS2  
_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,275,766118.469.82
acks for commit broadcast(logical)1,533,164142.3611.81
broadcast msgs on commit(actual)1,392,641129.3210.72
broadcast msgs on commit(logical)1,546,848143.6411.91
broadcast msgs on commit(wasted)285,15126.482.20
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received1530.010.00
flow control messages sent1020.010.00
gcs apply delta00.000.00
gcs assume cvt5,8050.540.04
gcs assume no cvt1,567,371145.5412.07
gcs ast xid260.000.00
gcs blocked converts1,460,047135.5811.24
gcs blocked cr converts1,082,806100.558.34
gcs compatible basts435,70840.463.36
gcs compatible cr basts (global)277,97225.812.14
gcs compatible cr basts (local)169,93415.781.31
gcs cr basts to PIs50.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs184,28517.111.42
gcs dbwr write request msgs143,93213.371.11
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 only304,59328.282.35
gcs force cr grant242,76322.541.87
gcs force cr no current00.000.00
gcs forward cr to pinged instance60.000.00
gcs immediate (compatible) converts39,7203.690.31
gcs immediate cr (compatible) converts2610.020.00
gcs immediate cr (null) converts118,72711.020.91
gcs immediate (null) converts1,394,376129.4810.74
gcs indirect ast1,220,957113.379.40
gcs indirect bidless ast5,4980.510.04
gcs indirect fg ast1,220,942113.379.40
gcs lms flush pi msgs106,2499.870.82
gcs lms write request msgs102,1499.490.79
gcs msgs process time(ms)377,81135.082.91
gcs msgs received14,359,4001,333.37110.57
gcs new served by master32,5793.030.25
gcs out-of-order msgs4870.050.00
gcs pings refused5150.050.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts7,5040.700.06
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast5,2020.480.04
gcs reader bypass grant immediate7,0340.650.05
gcs reader bypass grant X on assume2440.020.00
gcs reader bypass N->Xw ping local2500.020.00
gcs reader bypass N->Xw ping remote1880.020.00
gcs recovery claim msgs00.000.00
gcs refuse xid210.000.00
gcs regular cr723,86667.225.57
gcs retry convert request7780.070.01
gcs share recovery bast00.000.00
gcs side channel msgs actual00.000.00
gcs side channel msgs logical00.000.00
gcs stale cr1,645,970152.8412.67
gcs undo cr790.010.00
gcs write notification msgs7,1710.670.06
gcs writes refused4,2940.400.03
ges msgs process time(ms)46,3174.300.36
ges msgs received2,126,812197.4916.38
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 received320,39429.752.47
implicit batch messages sent318,55929.582.45
lmd msg send time(ms)60.000.00
lms(s) msg send time(ms)170.000.00
messages flow controlled126,74211.770.98
messages queue sent actual5,710,634530.2743.97
messages queue sent logical783,89172.796.04
messages received actual15,629,6271,451.31120.35
messages received logical16,486,8751,530.92126.95
messages sent directly6,910,041641.6453.21
messages sent indirectly4,637,930430.6635.71
messages sent not implicit batched00.000.00
messages sent pbatched4,956,057460.2038.16
msgs causing lmd to send msgs1,351,861125.5310.41
msgs causing lms(s) to send msgs2,656,378246.6620.45
msgs received queue time (ms)357,66133.212.75
msgs received queued16,485,7051,530.81126.94
msgs sent queue time (ms)269,62025.042.08
msgs sent queue time on ksxp (ms)3,380,738313.9226.03
msgs sent queued6,172,739573.1847.53
msgs sent queued on ksxp15,158,1351,407.53116.72
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received4,309,231400.1433.18
process batch messages sent4,581,718425.4435.28


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests687,106
CURRENT Block Requests1,611,431
Data Block Requests687,106
Undo Block Requests66
TX Block Requests1,049
Current Results1,017,895
Private results1,600
Zero Results620
Disk Read Results1,278,456
Fail Results5
Fairness Down Converts297,114
Fairness Clears27,299
Free GC Elements0
Flushes5,797
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)155,693
Light Works5,178
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins11,38652.4536.8010.710.040.00
Flushes65,8739.1787.333.480.020.00
Writes206,24951.7047.001.140.150.01


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 block248,97596.180.763.06259,09494.363.691.95
1data block215,51696.120.713.17214,59694.083.981.94
3data block202,73195.930.703.37201,72093.674.331.99
4Others111,21797.730.102.17172,84495.842.181.98
4undo header13191.606.871.53271,97790.318.421.27
1Others101,93897.880.072.05162,91896.012.031.96
3Others96,13397.840.092.07157,00496.251.931.82
1undo header12196.693.310.00250,89590.348.361.30
3undo header13394.744.510.75221,26091.727.051.22
3undo block1662.5037.500.000   
1undo block1681.2518.750.000   
4undo block1070.0030.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.380.353.110.470.350.330.740.43
1data block0.380.352.910.450.350.330.740.43
3data block0.380.362.820.470.360.340.730.41
4others0.290.283.230.350.290.280.650.35
4undo header0.370.251.980.340.570.244.190.27
1others0.290.282.300.340.300.290.650.33
3others0.290.292.880.340.290.280.660.35
1undo header0.360.263.39 0.560.244.020.29
3undo header0.320.242.050.160.510.244.010.25
1undo block0.480.231.56     
3undo block0.690.211.48     
4undo block0.730.261.81     

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 block0239,45552.2647.74244,47054.5045.50
1data block0207,16153.8546.15201,88258.7341.27
3data block0194,47350.7649.24188,96049.9650.04
4others0108,68948.9451.06165,66259.4840.52
1others099,78049.5250.48156,41959.6040.40
4undo header0120100.000.00245,627100.000.00
3others094,05548.5651.44151,11362.1437.86
1undo header0117100.000.00226,657100.000.00
3undo header0126100.000.00202,944100.000.00
1undo block013100.000.000  
3undo block010100.000.000  
4undo block07100.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.350.270.450.330.260.43
1data block 0.350.270.450.330.260.43
3data block 0.360.270.450.340.260.43
4others 0.280.200.350.280.210.39
1others 0.280.210.360.290.220.39
4undo header 0.250.25 0.240.24 
3others 0.290.200.360.280.210.40
1undo header 0.260.26 0.240.24 
3undo header 0.240.24 0.240.24 
1undo block 0.230.23    
3undo block 0.210.21    
4undo block 0.260.26    

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
18550.400.178550.480.17
28550.380.138550.370.13
38550.370.128550.440.14
48550.380.138550.460.15

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache1.291.28
Parallel Query0.000.00
DB Locks0.350.37
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.76.169NO  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 sent17,3954,348.75  
resources cleaned00.00  
remaster time (s)5.21.31  
quiesce time (s)0.80.20  
freeze time (s)0.10.03  
cleanup time (s)0.10.03  
replay time (s)0.50.13  
fixwrite time (s)1.20.29  
sync time (s)2.50.63  
affinity objects  33


Back to Top

End of Report