WORKLOAD REPOSITORY report for

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

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:110115-Jul-13 21:00:39330 2.7
End Snap:110416-Jul-13 00:00:08340 12.0
Elapsed:  179.49 (mins)  
DB Time:  187.53 (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,103,365.2 88,265.6  
Logical reads: 80,526.3 6,441.8  
Block changes: 1,067.7 85.4  
Physical reads: 292.7 23.4  
Physical writes: 161.9 13.0  
User calls: 469.6 37.6  
Parses: 8.4 0.7  
Hard parses: 0.0 0.0  
W/A MB processed: 0.0 0.0  
Logons: 0.0 0.0  
Executes: 299.5 24.0  
Rollbacks: 0.0 0.0  
Transactions: 12.5   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.64In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.82
Execute to Parse %: 97.19Latch Hit %: 94.14
Parse CPU to Parse Elapsd %: 18.98% Non-Parse CPU: 99.16

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.80 72.02
% SQL with executions>1: 83.02 81.33
% Memory for SQL w/exec>1: 80.06 76.23

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read1,410,9535,843451.93User I/O
DB CPU 2,901 25.78 
reliable message381,72898438.75Other
enq: CR - block range reuse ckpt474,67145714.06Other
log file sync134,59731522.80Commit

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

Load Average BeginLoad Average End%User%System%WIO%Idle
1.42 1.79 3.1 0.9 0.8 96.0
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
3.0 73.9 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): 1,027.0 2,123.6
% Host Mem used for SGA+PGA: 10.28 11.12

RAC Statistics

BeginEnd
Number of Instances: 4 4

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 279.34 22.35
Global Cache blocks served: 276.19 22.09
GCS/GES messages received: 1,562.73 125.01
GCS/GES messages sent: 1,579.02 126.32
DBWR Fusion writes: 22.78 1.82
Estd Interconnect traffic (KB) 5,057.83 

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

Buffer access - local cache %: 99.29
Buffer access - remote cache %: 0.35
Buffer access - disk %: 0.36

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.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: 61.00
% of indirect sent messages: 38.01
% of flow controlled messages: 0.99


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
bond1:1169.254.71.72N    

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,556.0184.93
DB CPU2,901.1125.78
parse time elapsed130.061.16
hard parse elapsed time0.920.01
PL/SQL execution elapsed time0.600.01
sequence load elapsed time0.530.00
PL/SQL compilation elapsed time0.420.00
repeated bind elapsed time0.190.00
connection management call elapsed time0.080.00
RMAN cpu time (backup/restore)0.030.00
DB time11,251.94 
background elapsed time22,484.41 
background cpu time17,525.92 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME2,765,424 
IDLE_TIME66,412,448 
IOWAIT_TIME586,576 
NICE_TIME451 
SYS_TIME601,639 
USER_TIME2,123,347 
LOAD12
VM_IN_BYTES2,048 
VM_OUT_BYTES0 
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.42     
15-Jul 22:00:051.801.340.810.5298.660.16
15-Jul 23:00:022.006.935.771.0793.071.21
16-Jul 00:00:081.793.702.611.0196.301.16

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,451,55305,886452.31
DB CPU  2,901 25.78
Other885,61101,510213.42
Cluster2,785,081094908.43
Commit134,597031522.80
Network5,460,943023302.07
Concurrency7,3940510.04
System I/O5,4120310.03
Administrative410012500.01
Configuration43778120.01
Application3061120.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,410,95305,843410.4851.93
reliable message381,728098432.848.75
enq: CR - block range reuse ckpt474,671045713.534.06
log file sync134,597031521.002.80
gc current grant 2-way1,005,995024207.472.15
SQL*Net more data from client1,006,244019907.471.77
gc current grant busy342,440016002.541.43
gc current block 3-way322,052014202.391.27
gc current block 2-way438,332011503.261.02
gc cr block 3-way250,617011101.860.99
gc cr block 2-way247,79506601.840.59
latch free23,75906430.180.57
db file scattered read14,03504230.100.37
gc cr multi block request87,57204000.650.35
gc current block busy34,82502610.260.23
SQL*Net more data to client446,16001703.310.15
SQL*Net message to client4,001,787016029.730.14
gc cr block busy5,23501630.040.14
gc buffer busy release5,35101320.040.11
gc current block congested15,7190700.120.06
gc cr block congested10,9730500.080.05
gc current grant congested13,9350400.100.04
name-service call wait4504820.000.03
control file sequential read5,4010310.040.03
latch: row cache objects5,9980200.040.02
JS kgl get object wait410012500.000.01
SQL*Net vector data to client6,7520100.050.01
gc current multi block request1,4350110.010.01
resmgr:internal state change810011000.000.01
buffer busy waits4930110.000.01
gc cr grant 2-way2,4770100.020.01
direct path read5770110.000.01
enq: FB - contention1,7560100.010.00
enq: TX - index contention2180120.000.00
row cache lock3910010.000.00
undo segment extension4892090.000.00
enq: TX - row lock contention2002070.000.00
Disk file operations I/O25,9540000.190.00
library cache load lock400740.000.00
db file parallel read1300180.000.00
enq: HW - contention38178000.000.00
local write wait200070.000.00
DFS lock handle1259010.000.00
log file switch completion300420.000.00
enq: TX - contention960010.000.00
enq: TM - contention2970000.000.00
enq: PS - contention18114010.000.00
gc buffer busy acquire1510010.000.00
PX Deq: Slave Session Stats1740010.000.00
latch: ges resource hash list8960000.010.00
SecureFile mutex730010.000.00
cursor: pin S110050.000.00
library cache: mutex X580010.000.00
IPC send completion sync4800000.000.00
CSS operation: action50060.000.00
os thread startup100300.000.00
gc cr disk read1220000.000.00
control file parallel write110020.000.00
PX Deq: reap credit1,386100000.010.00
library cache pin410000.000.00
library cache lock3468000.000.00
read by other session100110.000.00
CSS initialization20060.000.00
gc cr grant congested380000.000.00
enq: SQ - contention40020.000.00
gc current split110010.000.00
gc current retry40010.000.00
latch: enqueue hash chains600000.000.00
enq: JS - job run lock - synchronize8100010.000.00
latch: shared pool320000.000.00
latch: object queue header operation520000.000.00
CSS operation: query60010.000.00
PX Deq: Signal ACK EXT480000.000.00
enq: JQ - contention3100010.000.00
ges inquiry response100000.000.00
latch: gc element260000.000.00
latch: cache buffers chains310000.000.00
enq: CF - contention30010.000.00
enq: UL - contention3100010.000.00
wait list latch free10010.000.00
SQL*Net message from client4,001,79002,831,28070829.73 
jobq slave wait1,3841006935010.01 
PX Deq: Execution Msg5040120.00 
KSV master wait5501140.00 
PX Deq: Join ACK480020.00 
PX Deq: Parse Reply480010.00 
PX Deq: Execute Reply480000.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
latch: row cache objects10,290,48901,998076.448.88
db file sequential read1,680,92001,344112.495.98
log file parallel write576,876089324.293.97
db file parallel write812,135062116.032.76
gc current block busy75,396029140.561.29
gc cr disk read1,244,450025209.241.12
gc current block 2-way918,720022306.820.99
gcs log flush sync145,237117911.080.79
flashback log file write49,315012730.370.56
gc current grant busy165,74306901.230.31
log file sequential read5,788065110.040.29
enq: CR - block range reuse ckpt164,48906401.220.28
gc cr block 3-way167,77306301.250.28
gc current block 3-way146,38005701.090.25
gc buffer busy release16,71205330.120.23
ges inquiry response100,53903900.750.17
gc cr block 2-way172,80303701.280.17
gc buffer busy acquire4,78903270.040.14
ASM file metadata operation5,77003050.040.14
buffer busy waits5,82302650.040.12
ksxr poll remote instances1,519,62510025011.290.11
control file sequential read42,16002210.310.10
DFS lock handle48,355991700.360.08
CSS operation: data query3,58001440.030.06
control file parallel write4,97801430.040.06
row cache cleanup3,524,125010026.180.04
latch free24,3350900.180.04
enq: DW - contention15,410100600.110.03
gc current block congested17,0220500.130.02
PX Nsq: PQ load info query2410052010.000.02
os thread startup9204450.000.02
enq: WF - contention6303500.000.01
wait list latch free2,6730310.020.01
gc cr block congested7,1290200.050.01
gc current grant 2-way9,5100200.070.01
reliable message1,5420210.010.01
ges lms sync during dynamic remastering and reconfig96592210.000.01
libcache interrupt action by LCK3,522,13102026.160.01
LGWR wait for redo copy21,0100200.160.01
row cache lock1,0710210.010.01
name-service call wait2101660.000.01
row cache process3,528,38701026.210.01
latch: messages6,4030100.050.01
enq: CO - master slave det3,587100100.030.01
enq: XR - database force logging3,5790100.030.01
CGS wait for IPC msg99,441100100.740.01
gc cr block busy3540130.000.00
db file async I/O submit735,3580105.460.00
latch: redo writing2,1830000.020.00
enq: JS - wdw op1004390.000.00
undo segment extension6073070.000.00
enq: CF - contention73241000.010.00
read by other session1000030.000.00
enq: TM - contention23740130.000.00
direct path read550050.000.00
CSS group membership query1790010.000.00
enq: HW - contention4940000.000.00
Log archive I/O1380020.000.00
enq: TX - contention1100130.000.00
log file switch completion200680.000.00
CSS operation: action300040.000.00
RMAN backup & recovery I/O130090.000.00
gc cr grant 2-way4130000.000.00
db file scattered read170060.000.00
CSS initialization140070.000.00
enq: PS - contention18040010.000.00
resmgr:internal state change2500500.000.00
latch: cache buffers chains2,1230000.020.00
rdbms ipc reply100940.000.00
enq: TX - index contention500190.000.00
latch: object queue header operation9050000.010.00
enq: US - contention1520000.000.00
enq: XL - fault extent map200290.000.00
Disk file operations I/O3,5270000.030.00
gc object scan5,824100000.040.00
latch: gc element1,2310000.010.00
enq: RO - fast object reuse940010.000.00
PX Deq: reap credit3,990100000.030.00
latch: ges resource hash list4370000.000.00
latch: undo global data6270000.000.00
enq: TA - contention640010.000.00
flashback log file read80040.000.00
gc current grant congested1280000.000.00
CSS operation: query2210000.000.00
direct path write410010.000.00
enq: TD - KTF dump entries320010.000.00
log file single write120010.000.00
latch: enqueue hash chains1730000.000.00
gc cr multi block request280010.000.00
flashback log file sync50030.000.00
log file sync80020.000.00
gc current multi block request260010.000.00
library cache pin480000.000.00
latch: gcs resource hash1380000.000.00
library cache lock467000.000.00
latch: checkpoint queue latch580000.000.00
enq: PI - contention21100000.000.00
enq: FB - contention270000.000.00
kfk: async disk IO110010.000.00
ADR block file read660000.000.00
PX Deq: Slave Session Stats1260000.000.00
latch: redo allocation470000.000.00
gc current split50010.000.00
gc cr grant congested120000.000.00
PX Deq: Signal ACK RSG1260000.000.00
enq: TK - Auto Task Serialization12100000.000.00
PX Deq: Signal ACK EXT1260000.000.00
enq: RS - prevent file delete12100000.000.00
latch: cache buffers lru chain260000.000.00
enq: MW - contention60000.000.00
enq: DR - contention60000.000.00
enq: WL - contention3100010.000.00
ADR block file write150000.000.00
asynch descriptor resize133100000.000.00
rdbms ipc message14,832,8891330,06922110.18 
gcs remote message19,310,2342684,9384143.44 
Space Manager: slave idle wait989,569080,318817.35 
wait for unread message on broadcast channel21,6888921,5399930.16 
DIAG idle wait460,4045421,049463.42 
class slave wait2,993014,15347290.02 
PING3,6552310,77729490.03 
shared server idle wait35910010,773300090.00 
ASM background timer3,643010,77229570.03 
GCR sleep2,15410010,77150010.02 
Streams AQ: qmn coordinator idle wait7505010,767143570.01 
Streams AQ: qmn slave idle wait375010,767287130.00 
pmon timer3,58510010,76130020.03 
dispatcher timer17910010,742600100.00 
smon timer156,080010,727691.16 
ges remote message2,550,940110,587418.95 
PX Idle Wait14706,970474150.00 
KSV master wait7,976822940.06 
SQL*Net message from client122010840.00 
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 read66100.0       
ADR block file write15100.0       
ADR file lock18100.0       
ARCH wait for archivelog lock7100.0       
ASM file metadata operation584890.8.1.51.2.2.96.2.1
asynch descriptor resize149100.0       
buffer busy waits631752.96.610.215.49.34.41.2 
buffer deadlock2100.0       
CGS wait for IPC msg99.4K100.0       
control file parallel write5000 74.920.13.1.9.3.7 
control file sequential read47.6K95.62.41.1.6.3.1.0 
CSS group membership query1791.196.12.2.6    
CSS initialization1650.0   43.86.3  
CSS operation: action3514.314.32.968.6    
CSS operation: data query3580 1.374.823.9.0   
CSS operation: query22796.5 2.6.9    
cursor: mutex S1100.0       
cursor: pin S1154.5   45.5   
db file async I/O submit732.3K100.0       
db file parallel read13   30.838.515.415.4 
db file parallel write810.8K87.87.52.91.3.4.1.0 
db file scattered read14K67.62.05.412.410.61.8.3 
db file sequential read3092.3K72.42.94.612.26.21.5.3.0
DFS lock handle48.5K99.7.3      
direct path read63286.12.13.64.02.71.3.3 
direct path write4190.24.92.42.4    
Disk file operations I/O29.5K100.0.0      
enq: AF - task serialization1100.0       
enq: CF - contention73599.6.3    .1 
enq: CO - master slave det358899.8.2      
enq: CR - block range reuse ckpt639.3K87.16.63.72.0.5.1.1 
enq: DR - contention6100.0       
enq: DW - contention15.4K99.6.4      
enq: FB - contention1780100.0       
enq: FL - Flashback database log2100.0       
enq: HW - contention87199.5.5      
enq: JQ - contention3100.0       
enq: JS - job run lock - synchronize887.512.5      
enq: JS - wdw op1      100.0 
enq: KD - determine DBRM master2100.0       
enq: KT - contention1100.0       
enq: MW - contention6100.0       
enq: PI - contention21100.0       
enq: PS - contention36198.11.9      
enq: PW - flush prewarm buffers1100.0       
enq: RO - fast object reuse9497.92.1      
enq: RS - prevent file delete12100.0       
enq: SQ - contention425.025.050.0     
enq: TA - contention6498.41.6      
enq: TD - KTF dump entries32100.0       
enq: TK - Auto Task Serialization12100.0       
enq: TM - contention32099.1  .3  .6 
enq: TT - contention1100.0       
enq: TX - allocate ITL entry1100.0       
enq: TX - contention10766.422.41.92.81.93.7.9 
enq: TX - index contention22387.91.3 4.01.82.22.7 
enq: TX - row lock contention2      100.0 
enq: UL - contention3100.0       
enq: US - contention152100.0       
enq: WF - contention6387.31.6    11.1 
enq: WL - contention4100.0       
enq: XL - fault extent map2     50.050.0 
enq: XR - database force logging358099.9.1      
flashback log file read850.0  37.512.5   
flashback log file sync5 20.060.020.0    
flashback log file write49.3K37.819.416.024.22.3.3.0 
gc buffer busy acquire494041.317.513.810.58.05.73.2 
gc buffer busy release22.1K27.341.218.46.93.41.9.8 
gc cr block busy55871.650.036.68.12.31.0.4 
gc cr block congested18.1K99.4.3.1.1.0.0.1 
gc cr block 2-way420.7K99.8.1.0.0.0.0.0 
gc cr block 3-way418.4K99.5.2.1.1.1.0.0 
gc cr disk read1244.6K99.8.0.0.0.0.0.0 
gc cr failure3100.0       
gc cr grant congested50100.0       
gc cr grant 2-way289199.7.1.0.1.0   
gc cr multi block request87.7K99.1.7.1.1.1.0.0 
gc current block busy110.3K35.830.120.37.73.71.6.7 
gc current block congested32.8K99.4.2.1.1.0.0.0 
gc current block 2-way1357.4K99.8.1.0.0.0.0.0 
gc current block 3-way468.6K99.5.2.1.1.1.0.0 
gc current grant busy508.3K99.0.5.2.2.1.0.0 
gc current grant congested14.1K99.6.1.1.1.1.0.0 
gc current grant 2-way1015.7K99.8.1.0.0.0.0.0 
gc current multi block request144699.0.3.1.1.3 .1 
gc current retry475.0  25.0    
gc current split1693.86.3      
gc object scan5823100.0       
gc quiesce2100.0       
gcs log flush sync145.3K55.329.810.33.41.2 .0 
ges inquiry response100.6K99.7.3.0.0    
ges lms sync during dynamic remastering and reconfig96  18.814.616.721.928.1 
global enqueue expand wait2100.0       
IPC send completion sync588100.0       
JS kgl get object wait4      100.0 
kfk: async disk IO1181.89.19.1     
kjbdrmcvtq lmon drm quiesce: ping completion2100.0       
KJC: Wait for msg sends to complete46100.0       
ksxr poll remote instances1519.8K100.0.0.0.0    
latch: cache buffers chains2154100.0       
latch: cache buffers lru chain26100.0       
latch: call allocation3100.0       
latch: checkpoint queue latch58100.0       
latch: enqueue hash chains233100.0       
latch free48.1K57.69.522.410.4.0   
latch: gc element1257100.0       
latch: gcs resource hash141100.0       
latch: ges resource hash list133399.9.1      
latch: lob segment hash table latch1100.0       
latch: messages6408100.0       
latch: object queue header operation957100.0       
latch: redo allocation47100.0       
latch: redo writing218399.7.3      
latch: row cache objects10.3M96.93.0.1.0.0.0  
latch: shared pool32100.0       
latch: undo global data630100.0       
LGWR wait for redo copy21K100.0.0      
libcache interrupt action by LCK3522.5K100.0       
library cache load lock425.025.0    50.0 
library cache lock8098.81.3      
library cache: mutex X9795.9   4.1   
library cache pin8998.91.1      
local write wait20  70.020.0 5.05.0 
lock escalate retry13100.0       
Log archive I/O13844.226.123.25.8.7   
log file parallel write577K46.538.510.83.1.8.2.0 
log file sequential read58004.53.35.238.231.613.04.3 
log file single write1675.0  18.86.3   
log file switch completion11    9.1 90.9 
log file sync134.6K9.857.723.76.31.7.6.2 
name-service call wait661.51.5 3.03.06.184.8 
os thread startup93     73.126.9 
PX Deq: reap credit5374100.0       
PX Deq: Signal ACK EXT174100.0       
PX Deq: Signal ACK RSG126100.0       
PX Deq: Slave Session Stats30098.01.0.3 .7   
PX Nsq: PQ load info query24      100.0 
rdbms ipc reply1      100.0 
read by other session10155.45.910.914.910.92.0  
reliable message383.4K63.418.813.61.2.8.61.5 
resmgr:internal state change1010.0     90.0 
RMAN backup & recovery I/O13   46.253.8   
row cache cleanup3524.5K100.0.0    .0 
row cache lock146186.711.6.2.1.1.3.9 
row cache process3528.8K100.0.0      
SecureFile mutex7393.2   6.8   
SQL*Net break/reset to client4100.0       
SQL*Net message to client4002.5K100.0.0      
SQL*Net more data from client1006.3K93.95.5.4.1.0.0.0 
SQL*Net more data to client446.6K99.8.1.1.1.0.0.0 
SQL*Net vector data to client675299.7  .2.1   
undo segment extension10856.5   20.418.54.6 
wait list latch free2676.199.7.1.1    
ASM background timer367113.11.6.8.7.92.321.858.9
class slave wait301743.9.311.34.19.91.816.112.5
DIAG idle wait460.4K34.71.71.51.812.124.623.5 
dispatcher timer179       100.0
GCR sleep2154       100.0
gcs remote message19.3M35.210.712.013.129.0.0.0 
ges remote message2551.1K76.49.02.92.63.02.73.6 
jobq slave wait1395      100.0 
KSV master wait805893.4.1.3.9.2.74.3.1
PING365576.6      23.4
pmon timer3584       100.0
PX Deq: Execute Reply17499.4.6      
PX Deq: Execution Msg50476.010.19.72.6.4 1.2 
PX Deq: Join ACK17453.432.214.4     
PX Deq: Parse Reply17497.11.7.6.6    
PX Idle Wait126  2.4 6.35.657.128.6
rdbms ipc message14.6M68.38.76.24.23.83.25.3.3
shared server idle wait359       100.0
smon timer156.1K43.711.22.23.46.58.723.7.6
Space Manager: slave idle wait964.3K42.913.91.82.85.57.624.21.2
SQL*Net message from client4002.8K.852.525.16.75.03.65.11.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.3 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ASM file metadata operation36093.86.1.0    .1
buffer busy waits7398.81.0.1  .0  
control file parallel write3799.3.2.4.1    
control file sequential read17100.0.0.0.0    
db file parallel read284.615.4      
db file parallel write228100.0.0.0.0 .0  
db file scattered read3699.7.2.0     
db file sequential read878799.7.3.0.0.0.0.0 
direct path read299.7.2.2     
enq: CF - contention199.9 .1     
enq: CR - block range reuse ckpt42499.9.0.0.0.0.0  
enq: JS - wdw op1    100.0   
enq: TM - contention299.4  .6    
enq: TX - contention199.1.9      
enq: TX - index contention697.32.2.4     
enq: TX - row lock contention2   100.0    
enq: WF - contention788.9 1.63.21.64.8  
enq: XL - fault extent map150.050.0      
flashback log file write21100.0.0.0     
gc buffer busy acquire15796.82.1.9 .0.1  
gc buffer busy release18799.2.6.2.0.0.0  
gc cr block busy2299.6.3.0.0    
gc cr block congested1299.9.0.0.0    
gc cr block 2-way17100.0.0.0.0    
gc cr block 3-way64100.0.0.0.0    
gc cr disk read53100.0.0.0.0    
gc cr multi block request12100.0.0.0.0    
gc current block busy78299.3.6.1.0.0.0  
gc current block congested16100.0.0.0     
gc current block 2-way85100.0.0.0.0    
gc current block 3-way69100.0.0.0.0    
gc current grant busy135100.0.0.0.0    
gc current grant congested6100.0.0.0.0    
gc current grant 2-way64100.0.0.0.0    
gc current multi block request199.9.1      
gcs log flush sync1100.0 .0     
ges lms sync during dynamic remastering and reconfig2771.928.1      
JS kgl get object wait4  25.025.050.0   
library cache load lock250.0 25.025.0    
local write wait195.05.0      
log file parallel write268100.0.0.0.0    
log file sequential read24995.73.9.4.0.0   
log file switch completion109.181.89.1     
log file sync27499.8.2.0     
name-service call wait5615.221.259.14.5    
os thread startup2573.19.715.12.2    
PX Nsq: PQ load info query24   100.0    
rdbms ipc reply1  100.0     
reliable message593598.5.6.8.1.0   
resmgr:internal state change910.0 90.0     
row cache cleanup1100.0.0      
row cache lock1399.1.4.5     
SQL*Net more data from client187100.0.0.0.0    
SQL*Net more data to client2100.0.0      
undo segment extension595.44.6      

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 operation599.9.1.0     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
eztopqa_va11,2392,8961,46838,422
SYS$USERS7304
SYS$BACKGROUND211,683828,596
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 1451311588572064005458758233
SYS$USERS 268118804121290
SYS$BACKGROUND 168454213441382158920320000

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,310.96157,4210.0229.4314.6269.890wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
2,523.08207,5100.0122.4213.2661.236fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,335.7395,8860.0111.8713.2878.629j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
703.6219,2250.046.2524.1053.34d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
458.3519,2220.024.0712.2978.166mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
221.9819,0380.011.9715.8174.88gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
181.61128,6200.001.6157.910.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
151.0374,9280.001.3459.230.07aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
149.0419,0200.011.3279.320.09b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
142.15115,1220.001.2641.360.113jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
129.40941.381.1527.5660.45aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
484.01157,4210.0016.683,310.9614.6269.890wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
334.61207,5100.0011.532,523.0813.2661.236fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
177.3495,8860.006.111,335.7313.2878.629j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
169.6019,2250.015.85703.6224.1053.34d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
118.2219,0200.014.08149.0479.320.09b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
105.17128,6200.003.63181.6157.910.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
89.4574,9280.003.08151.0359.230.07aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
58.79115,1220.002.03142.1541.360.113jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
56.3519,2220.001.94458.3512.2978.166mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
35.66940.381.23129.4027.5660.45aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
35.0919,0380.001.21221.9815.8174.88gs68f01qx915k 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,313.92157,4210.0132.003,310.9614.6269.890wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
1,544.99207,5100.0121.372,523.0813.2661.236fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,050.1895,8860.0114.521,335.7313.2878.629j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
375.3319,2250.025.19703.6224.1053.34d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
358.2219,2220.024.95458.3512.2978.166mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
166.2219,0380.012.30221.9815.8174.88gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
78.23940.831.08129.4027.5660.45aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
40.01410.980.5551.8715.1277.130m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
1.916490.000.038.2965.1523.089tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
0.7550.150.016.8426.9410.997f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...

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,667,508128,62044.060.65181.6157.908w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
4,763,697157,42130.260.553,310.9614.669.90wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
3,622,12719,225188.410.42703.6224.153.3d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
3,114,99919,020163.770.36149.0479.3.1b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
2,880,451207,51013.880.332,523.0813.361.26fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
2,446,93774,92832.660.28151.0359.2.1aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
1,670,747128,52013.000.1920.8131.905dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
1,434,59995,88614.960.171,335.7313.378.69j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
1,269,720317,3564.000.1522.8929.40d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
1,138,230115,1229.890.13142.1541.4.13jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
539,167157,4213.4317.113,310.9614.6269.890wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
418,431207,5102.0213.282,523.0813.2661.236fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
196,18695,8862.056.221,335.7313.2878.629j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
98,226941,044.963.12129.4027.5660.45aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
61,01519,2253.171.94703.6224.1053.34d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
58,36519,2223.041.85458.3512.2978.166mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
54,597411,331.631.7351.8715.1277.130m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
39,50419,0382.081.25221.9815.8174.88gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
8546491.320.038.2965.1523.089tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
18374,9280.000.01151.0359.230.07aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...

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
521,875521,875157,4213.320.0016.790wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
408,336408,336207,5101.970.0013.136fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
196,186196,18695,8862.050.006.319j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
98,22698,226941,044.960.003.16aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
39,50439,50419,0382.080.001.27gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
13,95613,95641340.390.000.450m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
4,8894,88931,629.670.000.161cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
3,1783,17821,589.000.000.10f3999s9g0mmgm perl@lair (TNS V1-V3) SELECT tablespace_name , SUM( ...
1,1881,1881866.000.000.04gf87bnxzf9raf rman@mhva011.ezto.mhecloud.mcgraw-hill.com (TNS select db.version_time, db.con...
340340408.500.000.01bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
404,904404,9021.0042.1831.30dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
317,356317,3531.0022.8929.40d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
262,532262,4621.0017.2129.30d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
207,510207,5101.002,523.0813.361.26fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
167,82274,6340.4412.5726.207jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
157,421363,5902.313,310.9614.669.90wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
128,6201,674,77313.02181.6157.908w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
128,5221,285,21010.0018.2228.40d024vwxkhahjc JDBC Thin Client SELECT title, managers, partic...
128,5201,285,18010.0020.8131.905dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
119,754119,7541.0016.5527.309z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
115,295115,2951.0030.4632.42.256z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
115,12295,8320.83142.1541.4.13jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
109,92400.0013.0524.8076nzpvfmj776g JDBC Thin Client SELECT questionID, data FROM f...
95,88695,8851.001,335.7313.378.69j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
95,11195,1081.0013.3125.706y55dxn24t86q   select obj#, intcol#, ts#, fil...
84,37400.005.8025.9073r2ts8p97um2 JDBC Thin Client SELECT flags FROM users WHERE ...
79,85779,8561.009.6826.60054rpfwwu14za JDBC Thin Client SELECT url FROM tests WHERE te...
75,825298,3633.9310.8726.50ckr1vbptqjnd1 JDBC Thin Client SELECT mediaID FROM mediaconsu...
74,928149,8562.00151.0359.2.1aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
53,65342,1870.7912.903400qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
42,19557,9221.3737.8147.50ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
42,19442,1921.006.4230.60dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
42,194103,6602.4611.6239.607cbf1umqgg15a 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
49,598157,42154.700wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
22,964207,51025.326fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
9,2799,27910.23350f5yrnnmshs   lock table sys.mon_mods$ in ex...
203167,8220.227jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
20119,0200.22b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
19919,2780.228fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
19842,1940.22dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
19742,1950.22ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
19619,0380.22gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
19519,2250.22d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...

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
233.66157,42111.473,310.967.0614.6269.890wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
187.1919,2259.19703.6226.6024.1053.34d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
128.3095,8866.301,335.739.6113.2878.629j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
118.39207,5105.812,523.084.6913.2661.236fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
68.18115,1223.35142.1547.9741.360.113jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
53.8119,2222.64458.3511.7412.2978.166mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
39.4274,9281.94151.0326.1059.230.07aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
24.1619,0381.19221.9810.8815.8174.88gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
22.9719,0201.13149.0415.4179.320.09b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
15.10940.74129.4011.6727.5660.45aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
11.5042,1950.5637.8130.4247.540.01ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
5.47410.2751.8710.5515.1277.130m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
2.9919,2780.157.1441.9230.530.028fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
2.399,2790.125.9340.3772.066.45g00cj285jmgsw   update sys.mon_mods$ set inser...
1.701,6410.086.3826.6869.870.019dd5xusnyg10n JDBC Thin Client SELECT * FROM attemptdata WHER...
0.726490.048.298.6465.1523.089tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
0.2450.016.843.5126.9410.997f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...
0.166490.010.9217.8928.4638.46bjrsu1sf38nx2 JDBC Thin Client SELECT g.groupID, gm.name, g.e...
0.11262,5320.0117.210.6729.340.02d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
0.10115,2950.0130.460.3432.432.2156z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
0.104,4460.010.7314.1826.3619.116b9n2bk019yv6 JDBC Thin Client SELECT questionID from groupme...
0.0890.003.792.0796.910.2553qg5xxgv1jxm JDBC Thin Client SELECT medialookaside.* FROM m...
0.0610.000.4614.0740.9341.096ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.0520.001.433.6623.750.09f3999s9g0mmgm perl@lair (TNS V1-V3) SELECT tablespace_name , SUM( ...
0.0330.000.1418.1342.3145.5447mm81hm9sggy   SELECT sum(case when a.sessio...
0.02130.000.0360.8245.720.009wncfacx0nj9h   insert into smon_scn_time (thr...
0.01420.000.0531.1557.090.040kkhhb2w93cx0   update seg$ set type#=:4, bloc...
0.01119,7540.0016.550.0827.330.009z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
0.0110.000.234.9981.6110.657qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
0.0130.000.0714.4161.7426.495h91zx386wbht   WITH awr_params as ( SELECT /*...
0.0130.000.0325.4287.010.00317v5hnvvd49h   UPDATE wrh$_seg_stat_obj ob S...
0.0130.0014.010.053.790.551cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
0.01404,9040.0042.180.0231.280.00dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
0.0130.000.096.0588.504.446cp74g22fzahf   WITH ash as (SELECT ash.event...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
054rpfwwu14zaSELECT url FROM tests WHERE testID= :1
0kkhhb2w93cx0update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
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)
317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
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
53qg5xxgv1jxmSELECT medialookaside.* FROM medialookaside LEFT JOIN media ON medialookaside.mediaID = media.mediaID WHERE media.mediaID IS NULL AND ROWNUM <= 10
56z638s8sdpv0SELECT * FROM tests WHERE testID=:1
5dqygfkgt8hwdSELECT catalogID FROM library WHERE entryID=:1
5h91zx386wbhtWITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6b9n2bk019yv6SELECT questionID from groupmembers WHERE groupID = :1 and testid = :2 ORDER BY orderID
6cp74g22fzahf WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
6fp93dkgc917vUPDATE attemptdata set ITEMSCORE = :1 , MAXPOINTS = :2 , FORMULAANSWER = :3 , RECORDEDVALUE = :4 , FOLLOWUP = :5 , FEEDBACK = :6 , HTML = :7 , INSTRUCTORCOMMENT = :8 , PARAMS = :9 , UPDATEDTIME = :10 , USERRESPONSE = :11 , elapsed = :12 WHERE ATTEMPTDATA_PK = :13
6mj44b33a0xwsINSERT INTO attempt (attempt_pk, testid, activityid, attemptno, userid, sectionid, totalscore, params, maxscore, totalcorrect, pctscore, elapsedtime, groupscores, datasize, createdtime) VALUES( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 )
6y55dxn24t86qselect obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1
73r2ts8p97um2SELECT flags FROM users WHERE listID=:1 AND userID=:2
76nzpvfmj776gSELECT questionID, data FROM fullcredit WHERE testID=:1
7cbf1umqgg15aSELECT mediaID, overrideHeight, overrideWidth FROM mediaconsumers WHERE testID=:1 AND lower(name)=:2
7f70vfs8vfj68SELECT mediaID, mediatype, datasize FROM media WHERE datasize > :1 AND block=0
7jkvzr8ar6j6gSELECT name FROM mediaconsumers WHERE testID=:1 AND consumerID=:2
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
8fttd5fgbsx2ySELECT * FROM attempt WHERE testid=:1 AND sectionid=:2 AND activityid=:3 AND userid=:4 AND attemptno=:5 AND submissionid IS NOT NULL
8w92u8fd9rccdSELECT * FROM library WHERE parentID =:1
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
bn4b3vjw2mj3uSELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
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
gf87bnxzf9rafselect db.version_time, db.controlfile_change#, db.controlfile_sequence#, dbinc.resetlogs_time, df.last_recid, tf.last_recid, ts.last_recid, rl.last_recid, rm.last_recid, dc.last_recid, al.last_recid, bp.last_recid, do.last_recid, offr.last_recid, pc.last_recid, bs.last_recid, ldbinc.resetlogs_change#, ldbinc.resetlogs_time, ic.last_recid, rt.last_recid, grsp.last_recid, nrsp.last_recid, bcr.last_recid, decode(dc.records_used, 0, 0, dc.last_recid - dc.records_used + 1), decode(al.records_used, 0, 0, al.last_recid - al.records_used + 1), decode(bp.records_used, 0, 0, bp.last_recid - bp.records_used + 1), decode(bs.records_used, 0, 0, bs.last_recid - bs.records_used + 1), decode(do.records_used, 0, 0, do.last_recid - do.records_used + 1), decode(offr.records_used, 0, 0, offr.last_recid - offr.records_used + 1), decode(pc.records_used, 0, 0, pc.last_recid - pc.records_used + 1)into :vertime, :cfscn, :cfseq, :rltime, :dfhwm, :tfhwm, :tshwm, :rlhwm, :rmhwm, :dchwm, :alhwm, :bphwm, :dohwm, :offrhwm, :pchwm, :bshwm, :lrstscn, :lrsttime, :ichwm, :rthwm, :grsphwm, :nrsphwm, :bcrhwm, :dclwm, :allwm, :bplwm, :bslwm, :dolwm, :offrlwm, :pclwm from v$database db, v$controlfile_record_section df, v$controlfile_record_section tf, v$controlfile_record_section ts, v$controlfile_record_section rt, v$controlfile_record_section rl, v$controlfile_record_section rm, v$controlfile_record_section dc, v$controlfile_record_section al, v$controlfile_record_section bp, v$controlfile_record_section do, v$controlfile_record_section offr, v$controlfile_record_section pc, v$controlfile_record_section bs, v$controlfile_record_section ic, v$controlfile_record_section grsp, v$controlfile_record_section nrsp, v$controlfile_record_section bcr, v$database_incarnation dbinc, v$database_incarnation ldbinc where df.type = 'DATAFILE' and tf.type = 'TEMPORARY FILENAME' and ts.type = 'TABLESPACE' and rt.type = 'REDO THREAD' and rl.type = 'REDO LOG' and rm.type = 'RMAN CONFIGURATION' and dc.type = 'DATAFILE COPY' and al.type = 'ARCHIVED LOG' and bp.type = 'BACKUP PIECE' and do.type = 'DELETED OBJECT' and offr.type = 'OFFLINE RANGE' and pc.type = 'PROXY COPY' and bs.type = 'BACKUP SET' and ic.type = 'DATABASE INCARNATION' and grsp.type = 'GUARANTEED RESTORE POINT' and nrsp.type = 'RESTORE POINT' and bcr.type = 'DATABASE BLOCK CORRUPTION' and dbinc.incarnation#=db.recovery_target_incarnation# and ldbinc.incarnation#=db.last_open_incarnation#
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 cleanout50,2474.670.37
application wait time870.010.00
background checkpoints completed30.000.00
background checkpoints started40.000.00
background timeouts108,16110.040.80
Batched IO block miss count840.010.00
Batched IO (bound) vector count80.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count50.000.00
Batched IO (full) vector count00.000.00
Batched IO same unit count360.000.00
Batched IO single block count40.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count420.000.00
Batched IO vector read count90.000.00
Block Cleanout Optim referenced5,4320.500.04
branch node splits650.010.00
buffer is not pinned count30,828,6872,862.66229.00
buffer is pinned count9,412,148873.9869.92
bytes received via SQL*Net from client9,778,203,212907,974.9072,635.05
bytes sent via SQL*Net to client6,287,952,539583,880.5946,708.56
bytes via SQL*Net vector to client494,828,28145,948.283,675.71
Cached Commit SCN referenced431,13740.033.20
calls to get snapshot scn: kcmgss50,729,3174,710.57376.83
calls to kcmgas8,121,794754.1760.33
calls to kcmgcs10,414,622967.0777.36
CCursor + sql area evicted00.000.00
cell physical IO interconnect bytes106,730,317,3129,910,660.15792,820.71
change write time19,7391.830.15
cleanout - number of ktugct calls68,4786.360.51
cleanouts and rollbacks - consistent read gets2,6210.240.02
cleanouts only - consistent read gets204,91919.031.52
cluster key scan block gets2,5760.240.02
cluster key scans1,7230.160.01
cluster wait time203,73918.921.51
commit batch/immediate performed2,3130.210.02
commit batch/immediate requested2,3130.210.02
commit cleanout failures: block lost1,1540.110.01
commit cleanout failures: buffer being written90.000.00
commit cleanout failures: callback failure4,6620.430.03
commit cleanout failures: cannot pin310.000.00
commit cleanouts864,36780.266.42
commit cleanouts successfully completed858,51179.726.38
commit immediate performed2,3130.210.02
commit immediate requested2,3130.210.02
Commit SCN cached46,4684.310.35
commit txn count during cleanout159,91014.851.19
concurrency wait time203,64318.911.51
consistent changes457,87142.523.40
consistent gets38,689,7383,592.61287.40
consistent gets - examination16,380,9181,521.08121.68
consistent gets direct6510.060.00
consistent gets from cache38,689,0873,592.55287.39
consistent gets from cache (fastpath)18,690,0951,735.51138.83
CPU used by this session1,721,998159.9012.79
CPU used when call started214,68019.931.59
CR blocks created492,02645.693.65
cursor authentications1280.010.00
data blocks consistent reads - undo records applied3,2800.300.02
db block changes11,498,3601,067.7085.41
db block gets828,518,76076,933.796,154.45
db block gets direct1370.010.00
db block gets from cache828,518,63476,933.786,154.45
db block gets from cache (fastpath)1,110,627103.138.25
DB time1,168,882108.548.68
DBWR checkpoint buffers written723,70167.205.38
DBWR checkpoints510.000.00
DBWR fusion writes245,30022.781.82
DBWR transaction table writes69,0396.410.51
DBWR undo block writes147,50113.701.10
deferred (CURRENT) block cleanout applications394,77436.662.93
DFO trees parallelized840.010.00
dirty buffers inspected81,9737.610.61
Effective IO time596,52955.394.43
enqueue conversions6,415,389595.7147.66
enqueue releases16,103,3201,495.31119.62
enqueue requests16,239,0041,507.91120.63
enqueue timeouts135,66212.601.01
enqueue waits666,74161.914.95
exchange deadlocks270.000.00
execute count3,224,927299.4623.96
file io wait time9,252,728,848859,180.9168,731.69
flashback cache read optimizations for block new28,9722.690.22
flashback direct read optimizations for block new10.000.00
flashback log write bytes8,922,439,680828,511.2466,278.22
flashback log writes41,1163.820.31
free buffer inspected4,207,695390.7131.26
free buffer requested7,002,085650.1952.01
gc blocks compressed2,240,284208.0316.64
gc cr block flush time1,2760.120.01
gc cr block receive time37,3673.470.28
gc cr blocks received1,039,21696.507.72
gc cr blocks served1,015,69394.317.54
gc current block flush time17,9221.660.13
gc current block pin time4,5220.420.03
gc current block receive time86,6828.050.64
gc current blocks received1,969,043182.8414.63
gc current blocks served1,958,636181.8714.55
gc kbytes saved9,290,986862.7369.02
gc kbytes sent14,503,6481,346.77107.74
gc local grants881,19581.836.55
gc read wait time120.000.00
gc read waits120.000.00
gc reader bypass grants6,8080.630.05
gc remote grants2,848,047264.4621.16
gcs messages sent14,587,8131,354.58108.36
ges messages sent2,417,028224.4417.95
global enqueue get time65,8086.110.49
global enqueue gets async3,9500.370.03
global enqueue gets sync5,153,808478.5738.28
global enqueue releases2,856,023265.2021.22
heap block compress127,52311.840.95
Heap Segment Array Inserts3450.030.00
Heap Segment Array Updates2880.030.00
hot buffers moved to head of LRU451,72341.953.36
HSC Heap Segment Block Changes1,615,940150.0512.00
immediate (CR) block cleanout applications207,54419.271.54
immediate (CURRENT) block cleanout applications20,4671.900.15
in call idle wait time63,881,3975,931.84474.53
index crx upgrade (positioned)1780.020.00
index crx upgrade (prefetch)140.000.00
index fast full scans (full)90.000.00
index fetch by key810,94275.306.02
index scans kdiixs12,465,363228.9318.31
leaf node splits7,6830.710.06
leaf node 90-10 splits3650.030.00
lob reads7,6190.710.06
lob writes1110.010.00
lob writes unaligned1110.010.00
logical read bytes from cache7,104,166,248,448659,671,769.7652,771,605.09
logons cumulative2220.020.00
max cf enq hold time7400.070.01
messages received18,277,8921,697.23135.77
messages sent18,277,8921,697.23135.77
min active SCN optimization applied on CR1,6380.150.01
no buffer to keep pinned count2,9580.270.02
no work - consistent read gets10,822,0681,004.9180.39
non-idle wait count50,616,7814,700.12375.99
non-idle wait time1,553,368144.2411.54
Number of read IOs issued6510.060.00
opened cursors cumulative1,309,432121.599.73
Parallel operations not downgraded840.010.00
parse count (describe)330.000.00
parse count (hard)1630.020.00
parse count (total)90,6818.420.67
parse time cpu2,4500.230.02
parse time elapsed12,9061.200.10
physical read bytes25,818,963,9682,397,472.28191,790.02
physical read IO requests3,109,059288.7023.09
physical read total bytes38,215,319,5523,548,561.03283,873.39
physical read total IO requests3,167,723294.1523.53
physical read total multi block requests11,1691.040.08
physical reads3,151,729292.6623.41
physical reads cache3,149,153292.4223.39
physical reads cache prefetch42,8703.980.32
physical reads direct2,5760.240.02
physical reads direct (lob)6510.060.00
physical reads direct temporary tablespace00.000.00
physical reads for flashback new1,394,748129.5110.36
physical reads prefetch warmup1,5840.150.01
physical write bytes14,283,988,9921,326,368.78106,105.21
physical write IO requests823,08176.436.11
physical write total bytes68,514,997,7606,362,099.12508,947.32
physical write total IO requests2,168,829201.3916.11
physical write total multi block requests82,0847.620.61
physical writes1,743,651161.9112.95
physical writes direct4950.050.00
physical writes direct temporary tablespace00.000.00
physical writes from cache1,743,156161.8612.95
physical writes non checkpoint1,586,943147.3611.79
pinned buffers inspected6850.060.01
pinned cursors current2,0420.190.02
prefetch warmup blocks aged out before use139,15012.921.03
prefetched blocks aged out before use220.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'd5280.050.00
PX remote messages sent5280.050.00
queries parallelized840.010.00
recursive calls2,022,233187.7815.02
recursive cpu usage25,2692.350.19
redo blocks checksummed by FG (exclusive)19,265,9881,788.98143.11
redo blocks written24,310,2522,257.38180.58
redo buffer allocation retries7350.070.01
redo entries9,035,793839.0467.12
redo KB read11,227,7541,042.5883.40
redo log space requests7380.070.01
redo log space wait time490.000.00
redo ordering marks1,210,126112.378.99
redo size11,882,409,1161,103,365.2188,265.64
redo size for direct writes1,127,324104.688.37
redo subscn max counts278,61425.872.07
redo synch long waits12,4181.150.09
redo synch time31,7122.940.24
redo synch time (usec)317,158,21829,450.372,355.93
redo synch writes134,67612.511.00
redo wastage169,968,98015,782.811,262.57
redo write broadcast ack count4,1130.380.03
redo write broadcast ack time3,189,367296.1623.69
redo write time93,9308.720.70
redo writes576,98953.584.29
Requests to/from client3,995,992371.0629.68
rollback changes - undo records applied2320.020.00
rollbacks only - consistent read gets740.010.00
RowCR - row contention2900.030.00
RowCR attempts19,9291.850.15
RowCR hits19,6361.820.15
rows fetched via callback9,365,276869.6369.57
securefile allocation bytes10,309,844,992957,341.5776,584.23
securefile allocation chunks616,18657.224.58
securefile bytes non-transformed8,904,413,095826,837.3466,144.31
securefile number of non-transformed flushes274,63625.502.04
segment cfs allocations11,6771.080.09
segment chunks allocation from disepnser584,70454.294.34
segment dispenser allocations262,04024.331.95
segment dispenser load empty1340.010.00
segment dispenser load tasks5,9360.550.04
segment prealloc bytes3,024,093,184280,808.3122,463.76
segment prealloc ops99,2149.210.74
segment prealloc tasks92,0788.550.68
segment prealloc time (ms)16,770,9431,557.30124.58
segment prealloc ufs2cfs bytes2,894,094,336268,737.0021,498.09
segment total chunk allocation10,8591.010.08
session connect time00.000.00
session cursor cache hits1,323,054122.859.83
session logical reads867,207,13380,526.286,441.84
shared hash latch upgrades - no wait205,53019.081.53
SMON posted for undo segment shrink2700.030.00
sorts (memory)100,4049.320.75
sorts (rows)230,11021.371.71
sql area evicted00.000.00
sql area purged00.000.00
SQL*Net roundtrips to/from client3,996,033371.0629.68
summed dirty queue length1,217,643113.079.04
switch current to new buffer6,9280.640.05
table fetch by rowid18,027,9061,674.02133.92
table fetch continued row46,3384.300.34
table scan blocks gotten30,0042.790.22
table scan rows gotten727,82967.585.41
table scans (short tables)3,4490.320.03
total cf enq hold time19,0801.770.14
total number of cf enq holders7890.070.01
total number of times SMON posted157,85614.661.17
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks2,3120.210.02
undo change vector size954,237,52088,607.667,088.33
user calls5,056,935469.5737.56
user commits134,61912.501.00
user I/O wait time723,23167.165.37
user rollbacks20.000.00
workarea executions - optimal98,1969.120.73
write clones created in background230.000.00
write clones created in foreground240.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory13,038,052,91251,819,661,672
opened cursors current8994,068
logons current330340
session uga memory max2,646,803,8402,862,552,656
session pga memory949,383,5522,063,847,952
session pga memory max1,000,242,1762,276,497,904
session cursor cache count10,31913,347

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)41.34

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others11.5G5.151.0932027.3G7.442.5979598.8K1.24
Buffer Cache Reads24G288.452.284370M0.000M3106.3K1.97
LGWR1M0.01.00009223.2G117.532.20489577.2K1.09
DBWR46M0.27.00427113.3G76.301.2638729540.06
Direct Reads20M0.23.0018572M0.02.0001850 
RMAN2M0.01.0001850M0.000M1310.97
Direct Writes0M0.000M1M0.01.0000920 
TOTAL:35.6G294.133.3839863.8G201.316.066993785.4K1.81

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Data File24.1G288.742.2869713.3G76.401.266291.9713.95
Log File11.2G1.071.0635823.2G117.562.206378.210.00
Flashback Log0M0.000M16.3G4.591.551363.50 
Archive Log0M0.000M11.2G1.061.063399.08 
Control File858M4.43.079671313M1.86.0290640.427.07
TOTAL:36.1G294.233.4302364.3G201.476.116491.950.15

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others 12G5.201.1401927.8G7.502.6449394K1.37
Others (Flashback Log) 0M0.000M16.3G4.591.5513649.4K2.18
Others (Log File) 11.2G1.071.065070M0.000M419.90
Others (Archive Log) 0M0.000M11.2G1.061.064690 
Others (Control File) 809M4.13.075121310M1.84.02878544.5K0.46
Others (Data File) 0M0.000M1M0.00.0000920 
Buffer Cache Reads 24G288.692.286230M0.000M3108.9K1.99
Buffer Cache Reads (Data File) 24G288.692.286230M0.000M3108.9K1.99
LGWR 1M0.01.00009223.2G117.582.206651001.66
LGWR (Log File) 0M0.000M23.2G117.562.20646322.63
LGWR (Control File) 1M0.01.0000922M0.01.000185681.21
DBWR 0M0.000M13.3G76.411.265450 
DBWR (Data File) 0M0.000M13.3G76.411.265450 
Direct Reads 20M0.23.0018572M0.02.0001850 
Direct Reads (Data File) 20M0.23.0018572M0.02.0001850 
RMAN 2M0.01.0001850M0.000M1310.97
RMAN (Control File) 2M0.01.0001850M0.000M1180.08
RMAN (Archive Log) 0M0.000M0M0.000M139.08
Direct Writes 0M0.000M1M0.01.0000920 
Direct Writes (Data File) 0M0.000M1M0.01.0000920 
TOTAL: 36.1G294.153.4285664.3G201.526.117323203.1K1.97

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,924,3852722.191.01601,197568171.31
UNDOTBS1 129,604122.991.0083,69088,0653.29
EZTO_DATA 38,72448.501.0269,730620.00
EZTO_INDEX 14,39117.731.0265,2556961.88
SYSAUX 89904.851.201,188000.00
SYSTEM 26405.761.021780220.00
EZTO_LOB_MANUAL 900.001.009000.00
UNDOTBS2 1600.001.00102,1996.87
UNDOTBS3 100.001.00101,2045.18
UNDOTBS4 100.001.00102,4854.88
USERS 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.304.813959451 3807.631.3412000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.316.813959497 9106.591.1251000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.321.813959571 3307.581.008000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.325.813959657 1905.791.006000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.328.813959053 3508.571.0077000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.329.813959089 6806.321.017000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.333.813958673 41307.921.00636000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.334.813958733 55307.901.031,025000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.335.813958789 1,05408.251.011,461000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.336.813958889 98607.711.011,598000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.337.813958923 66808.101.00978000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.338.813958979 9007.561.00287000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.339.813958337 40708.161.03638000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.340.813958291 46608.001.06763000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.341.813958195 51408.851.10906000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.342.813958141 32107.231.02676000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.343.813958113 71807.991.001,489000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.344.813958015 2,64808.181.024,680000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.345.813957977 6,38818.791.0210,017110.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.346.813957901 6,07918.151.029,457100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.347.813957523 2,75008.381.074,350000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.348.813957523 91109.141.051,570000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.349.813957399 26008.081.00446000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.350.813957319 8907.871.00176000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.351.813957275 3007.001.0031000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.352.813957085 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.353.813957085 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.358.813956627 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.359.813956627 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.360.813956509 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.361.813956439 500.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.428.813950183 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.429.813950069 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.430.813950033 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.431.813949977 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.432.813949915 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.433.813949901 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.434.813949567 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.435.813949541 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.436.813949465 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.437.813949341 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.438.813949153 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.439.813949117 13304.961.001,881000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.440.813949055 400.001.0035000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.441.813948941 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.442.813948925 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.443.813948855 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.444.813948839 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.445.813948805 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.446.813948513 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.447.813948511 300.001.000000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.581.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.582.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.584.813930683 100.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.611.813964757 4706.381.0073000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.612.813964829 79809.251.001,582000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.617.813965575 8,67219.021.0118,688210.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.619.813965599 2,92208.771.035,566100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.620.813965653 28809.651.00433000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.621.813965689 1507.331.0749000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.622.813965729 902.221.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.623.813965743 1609.381.006000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.624.813965799 1704.121.945000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.634.813966737 1804.441.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.636.813966819 1806.671.008000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.637.813967121 1906.321.0010000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.638.813967189 800.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.639.813967493 700.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.640.813967621 700.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.680.813970465 700.001.001000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.683.813970633 2107.141.0021000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.298.813959857 12408.551.15297000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.299.813960597 60706.711.003,946060.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.302.813959711 3907.441.0068000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.303.813959883 5106.861.0289000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.305.813959771 4708.511.0086000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.306.813960601 38707.291.113,643074.29
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.315.813960647 43107.701.004,569080.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.317.813960159 5407.781.0091000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.318.813960243 8607.671.00138000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.319.813960269 1206.671.0014000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.320.813960377 2,30806.101.036,806130.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.322.813960701 86507.351.005,548140.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.323.813960703 30308.581.003,095025.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.326.813960441 45508.241.002,343000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.331.813960573 79206.461.005,833110.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.427.813950305 3008.331.3355000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.583.813930683 1108.181.0039000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.585.813930683 2009.501.0040000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.586.813930683 2,62408.871.039,2651235.65
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.587.813930683 1,38108.751.036,0621240.42
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.588.813930683 67509.101.043,777030.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.649.813967997 3,08907.721.029,4511150.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.277.813963385 63906.591.007220140.71
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.278.813963293 8,82811.301.251,196052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.279.813963217 26,15020.901.02815091.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.280.813963173 62,92660.771.00824052.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.281.813963093 47,00440.771.005530110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.282.813962941 22,29420.921.00670081.25
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.283.813962937 19,82720.931.01584020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.284.813962933 55901.611.13184000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.285.813962919 3,40601.361.01333020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.286.813962777 4,43001.471.11557030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.287.813961529 10,06611.171.017130131.54
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.307.813961503 89501.341.29170010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.308.813961481 2,45001.061.08126010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.309.813961455 75701.651.3995000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.310.813961447 97401.171.2853000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.311.813961441 1,25801.613.64558000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.312.813961361 14401.743.7969000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.313.813961275 2702.223.116000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.314.813961143 38501.663.88187000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.327.813961001 3204.382.9412000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.330.813961111 2302.173.2210000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.332.813960835 600.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.354.813957039 28302.723.921000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.355.813956965 24402.663.915000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.356.813956921 74302.713.943000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.357.813956683 14903.493.861000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.362.813956257 4407.271.00141000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.363.813956255 5208.081.0075000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.364.813956085 3606.941.0080010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.365.813956051 35010.001.0051000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.366.813956021 4307.671.0058000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.367.813955945 51018.041.0060000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.368.813955909 4009.001.0036000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.372.813963441 1,19104.121.007720192.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.374.813955661 32901.881.0033000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.375.813955617 3208.131.0028000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.376.813955601 3207.811.0026000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.377.813955491 3107.741.0027000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.378.813955445 33010.001.0025000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.379.813955209 4108.781.0060000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.380.813955209 3308.481.0026000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.381.813955073 4208.101.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.382.813955049 30010.331.0023000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.383.813955033 6,06810.791.0037000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.384.813955005 7,02310.781.00163000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.385.813954953 6,53010.781.00111010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.386.813954697 5,21600.841.00107000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.387.813954641 11,78710.701.0044000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.388.813954551 10,21410.771.0074000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.389.813954459 7,67910.731.00490110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.390.813954401 7,76310.791.0060010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.391.813954053 6,98210.721.0048000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.392.813953999 13,03010.711.0038000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.393.813953881 6,02910.771.0052000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.394.813953847 1607.501.0020000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.395.813953839 300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.396.813953803 51401.871.0071000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.397.813953755 805.001.0015000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.398.813953409 48501.321.0064000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.399.813953343 40901.541.0073000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.400.813953257 53901.601.00106000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.401.813953157 39900.601.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.402.813953077 31101.901.0070010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.403.813952647 4908.781.0051000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.404.813952647 4307.671.0086000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.405.813952521 40801.911.0064010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.406.813952521 25502.161.00131000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.407.813952487 61901.101.0062000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.408.813952435 8109.751.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.409.813952381 72901.371.0061000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.410.813952043 54901.421.0047000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.411.813952007 1,50201.011.0048000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.412.813951931 2,00100.801.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.413.813951819 2,43800.801.0042000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.414.813951723 1,21301.041.0076000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.415.813951297 2,00801.061.0037000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.416.813951283 1,03000.951.00111000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.417.813951223 2,20900.871.0091010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.418.813951177 2,87400.811.0073000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.419.813951135 72901.081.0089000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.420.813951051 41501.661.0066000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.421.813951025 1,50000.931.00121000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.422.813950699 7905.061.00111010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.423.813950673 1,80100.921.00110000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.424.813950607 31101.931.0057000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.425.813950455 97701.071.0069000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.426.813950379 26201.531.0051040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.448.813948277 98501.011.0050010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.449.813948187 22601.681.0047000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.450.813947987 1,49400.761.0034000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.451.813947979 4007.001.0079010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.452.813947939 72600.961.0079000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.453.813947873 4906.531.00106020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.454.813947825 65801.311.0098054.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.455.813947707 40401.561.0065000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.456.813947691 49502.381.00123000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.457.813947691 40302.701.0088000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.458.813947407 11903.951.00118000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.459.813947383 64101.951.00127000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.460.813947197 9507.371.00122000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.461.813947061 9407.451.00133000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.462.813946815 35302.521.0074000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.463.813946815 5708.951.0074000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.464.813946763 54402.261.0070000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.465.813946683 35002.711.00102010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.466.813946639 8708.511.00119010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.467.813946501 70501.861.00104000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.468.813946487 29803.461.00104000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.469.813946471 7208.331.00103020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.470.813946199 95501.281.0071010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.471.813946119 88101.261.00600210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.472.813945975 30802.241.0089000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.473.813945845 16104.351.0088000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.474.813945809 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.475.813945777 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.476.813945753 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.477.813945677 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.478.813945635 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.479.813945499 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.480.813945463 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.481.813945463 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.482.813945201 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.483.813945089 500.001.000000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.484.813944999 6,00613.871.002,341000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.485.813944841 1,48704.581.00565000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.486.813944825 11,96814.351.004,677000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.487.813944759 26,10924.021.0010,128100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.488.813944759 25,40824.221.009,791100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.489.813944681 20,56224.311.008,408110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.490.813944637 26,82324.191.0010,427100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.491.813944501 18,81824.701.008,158100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.492.813944451 15,89414.691.007,129100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.493.813944435 11,90415.381.005,537100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.494.813944189 11,93015.021.005,243000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.495.813944045 12,35914.791.005,028010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.496.813943995 39,30741.931.005,154010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.497.813943829 51,70551.631.006,143110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.498.813943801 60,60161.651.006,897133.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.499.813943745 82,61981.481.008,016110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.500.813943711 75,97971.841.009,7301110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.501.813943681 83,28981.881.0011,294110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.502.813943651 108,909101.831.0013,979110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.503.813943507 68,77062.111.0010,702120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.504.813943451 93,21492.941.0026,424210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.505.813943405 68,27864.901.0038,467410.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.506.813943213 46,44645.811.0031,455310.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.507.813943029 39,77646.231.0028,373310.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.508.813943027 29,60736.631.0022,699210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.509.813942881 24,34526.731.0018,777210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.510.813942815 19,43327.031.0015,538110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.511.813942745 21,99626.821.0017,179210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.512.813942737 16,32527.061.0013,319110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.513.813942723 13,42016.961.0011,035110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.514.813942707 9,07616.981.007,317110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.515.813942561 10,98516.851.008,896110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.516.813942347 8,39216.701.006,388110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.517.813942313 7,59016.921.006,032110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.518.813942081 17,45723.121.005,410190.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.519.813941969 4,60906.991.003,778010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.520.813941903 16,35423.251.005,276072.86
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.521.813941733 12,53513.681.004,6960130.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.522.813941663 13,94913.241.004,9850200.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.523.813941609 14,19413.091.004,3920130.77
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.524.813941583 26,97631.911.004,0010111.82
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.525.813941581 21,96122.121.004,0080120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.526.813941565 20,49622.161.003,726090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.527.813941431 30,86831.531.003,297080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.528.813941165 38,48141.411.002,976010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.529.813940979 23,80221.701.003,050090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.530.813940819 20,86121.771.002,8030182.22
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.531.813940811 44,56741.251.002,8080140.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.532.813940607 76,81671.041.002,6350174.12
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.533.813940523 51,55751.091.002,126061.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.534.813940481 19,29221.661.002,2360131.54
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.535.813940463 10,96812.051.002,002081.25
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.536.813940437 12,31711.741.002,0550141.43
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.537.813940423 22,01121.361.001,8610142.14
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.538.813940279 12,77811.771.001,9150192.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.539.813940047 4,71703.281.001,5260150.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.540.813939721 5,03802.621.001,429070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.541.813939403 28,94431.111.006,4231150.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.542.813939387 22702.253.85107000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.543.813939261 91,95590.851.0011,9671341.47
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.544.813939237 82,31280.861.008,7551481.46
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.545.813938401 2,38105.261.001,350000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.546.813938341 109,988100.831.0013,7701491.43
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.547.813938325 20802.453.7595000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.548.813938319 54,08050.891.0015,3511501.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.549.813938303 2,75705.751.001,655020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.550.813938207 141,002130.661.008,3051140.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.551.813938191 806.252.501000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.552.813938079 5303.213.623000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.553.813937743 17001.593.8883000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.554.813937633 37103.693.919000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.555.813937633 96803.083.944000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.556.813937587 61303.303.951000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.557.813935445 76803.113.923000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.558.813935373 28204.543.951000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.559.813935373 28803.583.921000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.560.813935373 45704.573.912000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.561.813935197 34003.973.933000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.562.813935181 4007.003.752000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.563.813935181 16010.633.255000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.564.813935135 1108.183.093000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.565.813934533 1608.133.382000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.566.813934531 15203.683.913000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.567.813934505 2207.733.183000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.568.813934439 43303.163.942000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.569.813932221 32802.353.942000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.570.813932219 27002.703.901000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.571.813932195 60303.103.943000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.572.813932077 37002.653.922000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.573.813932061 19403.253.934000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.574.813932053 12703.943.943000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.575.813932007 31602.973.9410000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.576.813931931 38703.133.904000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.577.813931235 19703.453.756000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.578.813931235 18903.703.827000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.579.813931233 22903.283.8710000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.580.813931231 60103.243.8592000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.602.813963443 1,87802.911.02825081.25
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.603.813964375 2,15302.691.026760130.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.604.813964415 1,73203.171.001,113080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.605.813964431 2,42002.511.009870101.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.606.813964501 9,56311.151.00695058.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.607.813964515 14,33211.001.008570211.43
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.608.813964517 2,07802.221.00467050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.609.813964531 13,11711.041.008290140.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.610.813964633 11,94011.061.00757082.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.613.813964829 7,56111.421.00856060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.614.813964989 8,34711.241.008490151.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.615.813965537 14,41811.041.00813020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.616.813965541 15,33811.041.00862060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.618.813965583 2,14002.201.00562000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.625.813965939 41506.241.00361040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.626.813966075 94103.721.00614030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.627.813966441 3,38701.671.00694091.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.628.813966465 63104.071.00426000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.629.813966547 2,90601.881.00485000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.630.813966601 1,12202.771.00409000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.631.813966673 3,28001.591.00460020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.632.813966679 5,61211.081.00487020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.633.813966697 15,94610.971.02550030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.635.813966761 26,97330.881.00437000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.641.813967621 3,89901.291.00422068.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.642.813967681 9,98910.951.00445000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.643.813967757 9,64010.911.00539020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.644.813967757 11,94210.921.00379000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.645.813967767 12,01110.911.003270110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.646.813967769 15,56510.881.002380110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.647.813967891 6,79610.891.00457060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.648.813967981 4,98901.091.00398040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.650.813968021 8,24510.981.00345010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.651.813968357 5,01301.221.00288020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.652.813968501 4,88201.251.005330618.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.653.813968795 8,02211.051.00320000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.654.813968829 4,23201.201.00282020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.655.813968865 4,15001.371.00408000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.656.813968891 7,47311.171.00496010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.657.813968899 5,31801.261.00351000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.658.813968943 3,42701.011.00147000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.659.813968967 3,25301.321.00486060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.660.813969061 2,70303.031.00947010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.661.813969097 9,06511.801.001,516050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.662.813969097 10,64811.931.001,578010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.663.813969469 17,23621.631.001,9410110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.664.813969661 7,93213.001.002,439020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.665.813969945 5,98513.441.002,179033.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.666.813970041 2700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.667.813970041 800.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.668.813970107 800.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.669.813970169 4000.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.670.813970171 29500.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.671.813970175 21500.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.672.813970209 5500.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.673.813970237 2300.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.674.813970385 700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.675.813970409 4700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.676.813970427 700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.677.813970429 700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.678.813970435 700.001.001000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.679.813970463 5,22404.681.002,376000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.681.813970561 4,84506.951.003,610000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.682.813970589 8708.051.0082030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.684.813970649 5,29306.571.003,939010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.713.816189311 700.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.685.813970653 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.686.813970653 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.687.813970889 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.688.813971075 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.689.813971145 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.693.813971299 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.696.813971335 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.698.813971447 100.001.001000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.699.813971519 100.001.001000.00
SYSAUX+EZTOPQA_DF/eztopqa_va/datafile/sysaux.697.813971341 89904.851.201,188000.00
SYSTEM+EZTOPQA_DF/eztopqa_va/datafile/system.694.813971299 26405.761.021780220.00
UNDOTBS1+EZTOPQA_DF/eztopqa_va/datafile/undotbs1.690.813971153 129,604122.991.0083,69088,0653.29
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.589.813930683 500.001.000000.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.590.813930683 500.001.000000.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.591.813930683 100.001.00102,1996.87
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.592.813930683 500.001.000000.00
UNDOTBS3+EZTOPQA_DF/eztopqa_va/datafile/undotbs3.691.813971193 100.001.00101,2045.18
UNDOTBS4+EZTOPQA_DF/eztopqa_va/datafile/undotbs4.692.813971243 100.001.00102,4854.88
USERS+EZTOPQA_DF/eztopqa_va/datafile/users.695.813971333 100.001.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D483,712100866,247,6812,993,2541,644,5440014,888
R483,71283896,875155,82998,569005

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000723,3750

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
B00907343123572533973830235725  0
E0185002812050506663644339738306663644  6

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.09453.5111,729127289.00
D7680.19912.699,003120904.00
D1,1520.281361.806,026113929.00
D1,5360.381811.515,054111653.00
D1,9200.472271.364,545110460.00
D2,3040.562721.254,17019582.00
D2,6880.663171.183,93819038.00
D3,0720.753631.113,70518492.00
D3,4560.844081.073,59118226.00
D3,8400.944531.023,41817820.00
D4,0961.004841.003,34217643.00
D4,2241.034990.993,31817586.00
D4,6081.135440.983,26117451.00
D4,9921.225900.963,19317292.00
D5,3761.316350.943,14017169.00
D5,7601.416800.933,10317083.00
D6,1441.507260.923,07317013.00
D6,5281.597710.913,05016957.00
D6,9121.698160.913,03116913.00
D7,2961.788620.903,01616877.00
D7,6801.889070.903,00216846.00
R3840.09451.023511254.00
R7680.19911.003441248.00
R1,1520.281361.003431247.00
R1,5360.381811.003431247.00
R1,9200.472271.003431247.00
R2,3040.562721.003431247.00
R2,6880.663171.003431247.00
R3,0720.753631.003431247.00
R3,4560.844081.003431247.00
R3,8400.944531.003431247.00
R4,0961.004841.003431247.00
R4,2241.034991.003431247.00
R4,6081.135441.003431247.00
R4,9921.225901.003431247.00
R5,3761.316351.003431247.00
R5,7601.416801.003431247.00
R6,1441.507261.003431247.00
R6,5281.597711.003431247.00
R6,9121.698161.003431247.00
R7,2961.788621.003431247.00
R7,6801.889071.003431247.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,5681,026.990.000.000.000.00838,860
E8,1925,6832,123.580.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
2K4K97,93897,93800
64K128K767600
256K512K2200
512K1024K14214200
1M2M292900

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.13561.070.00100.0048106,749
2,0480.25561.070.00100.000106,749
4,0960.50561.070.00100.000106,749
6,1440.75561.070.00100.000106,749
8,1921.00561.070.00100.000106,749
9,8301.20561.070.00100.000106,749
11,4691.40561.070.00100.000106,749
13,1071.60561.070.00100.000106,749
14,7461.80561.070.00100.000106,749
16,3842.00561.070.00100.000106,749
24,5763.00561.070.00100.000106,749
32,7684.00561.070.00100.000106,749
49,1526.00561.070.00100.000106,749
65,5368.00561.070.00100.000106,749

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.79573,405181,0421.001551.003,385
2,7520.90573,405181,0421.001551.003,385
2,7840.91573,405181,0421.001551.003,385
2,8160.92573,405181,0421.001551.003,385
2,8480.93573,405181,0421.001551.003,385
2,8800.94573,405181,0421.001551.003,385
2,9120.95573,405181,0421.001551.003,385
2,9440.96573,405181,0421.001551.003,385
2,9760.97573,405181,0421.001551.003,385
3,0080.98573,405181,0421.001551.003,385
3,0400.99573,405181,0421.001551.003,385
3,0721.00573,405181,0421.001551.003,386
3,1041.01573,405181,0431.001540.993,386
3,1361.02573,405181,0431.001540.993,386
3,1681.03573,405181,0431.001540.993,386
3,2001.04573,405181,0431.001540.993,386
3,2321.05573,405181,0431.001540.993,386
3,2641.06573,405181,0431.001540.993,386
3,2961.07573,405181,0431.001540.993,386
3,3281.08573,405181,0431.001540.993,386
3,3601.09573,405181,0431.001540.993,386
3,3921.10573,405181,0431.001540.993,386
3,7121.21573,405181,0431.001540.993,386
4,0321.31573,405181,0431.001540.993,386
4,3521.42573,405181,0431.001540.993,386
4,6721.52573,405181,0431.001540.993,386
4,9921.63573,405181,0431.001540.993,386
5,3121.73573,405181,0431.001540.993,386
5,6321.83573,405181,0431.001540.993,386
5,9521.94573,405181,0431.001540.993,386
6,2722.04573,405181,0431.001540.993,386

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 header13,925604
2nd level bmb52211
free list10602
data block12201
3rd level bmb12301
1st level bmb2301
file header block3701
undo block3000
segment header400

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,600,5773,600,4230639,1775510.86
DW-In memory Dispenser 495,754363,690132,06415,41070.48
WF-AWR Flush 6363063350.48
XR-Quiesce / Force Logging (database force logging) 3,5803,58003,57910.35
FB-Format Block 1,8471,84701,78310.44
TX-Transaction (index contention) 269269022312.83
HW-Segment High Water Mark 7,3987,398087510.63
CO-KTUCLO Master Slave enq (master slave det) 3,58703,5873,58710.15
TM-DML 547,067547,029032001.50
JS-Job Scheduler (wdw op) 11010440.00
TX-Transaction (row lock contention) 22020205.00
CF-Controlfile Transaction 24,44024,440073500.45
PS-PX Process Reservation 670670036100.69
TX-Transaction 398,528398,528010702.34
US-Undo Segment 277277015200.59
XL-ASM Extent Fault Lock (fault extent map) 414102030.00
RO-Multiple Object Reuse (fast object reuse) 18818809400.53
TA-Instance Undo 646406400.78
TD-KTF map table enqueue (KTF dump entries) 323203200.63
PI-Remote PX Process Spawn Status 212102100.48
JS-Job Scheduler (job run lock - synchronize) 981801.25
SQ-Sequence Cache 1461460402.50
KD-Scheduler Master DBRM (determine DBRM master) 211205.00
RS-Reclaimable Space (prevent file delete) 131301200.00
TK-Auto Task Serialization (Auto Task Serialization) 121201200.00
DR-Distributed Recovery 660600.00
MW-MWIN Schedule 660600.00
JQ-Job Queue 440300.00
UL-User-defined 770300.00
WL-Being Written Redo Log 532300.00
FL-Flashback database log (Flashback database log) 440200.00
AF-Advisor Framework (task serialization) 21210100.00
KT-Scheduler Plan 110100.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 541100.00
TT-Tablespace 40,29440,2940100.00
TX-Transaction (allocate ITL entry) 110100.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
2145.13397,4621,8451439.5/44.70/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
15-Jul 23:5914,56031,7041,82812430/00/0/0/0/0/0
15-Jul 23:4913,56228,4481,63613420/00/0/0/0/0/0
15-Jul 23:398,34620,8481,70310420/00/0/0/0/0/0
15-Jul 23:298,84620,1071,7459410/00/0/0/0/0/0
15-Jul 23:1911,32422,9631,84511430/00/0/0/0/0/0
15-Jul 23:0914,76431,8941,69114420/00/0/0/0/0/0
15-Jul 22:5913,50635,1261,68712420/00/0/0/0/0/0
15-Jul 22:499,21129,3871,80310420/00/0/0/0/0/0
15-Jul 22:399,49935,1271,79913420/00/0/0/0/0/0
15-Jul 22:2911,23342,0931,55413430/00/0/0/0/0/0
15-Jul 22:199,98331,4461,74410430/00/0/0/0/0/0
15-Jul 22:098,62725,1191,5488430/00/0/0/0/0/0
15-Jul 21:595,06318,1361,5909400/00/0/0/0/0/0
15-Jul 21:494,06715,1121,58712390/00/0/0/0/0/0
15-Jul 21:392,3239,26598410450/00/0/0/0/0/0
15-Jul 21:291981,6031450/00/0/0/0/0/0
15-Jul 21:194961,8002450/00/0/0/0/0/0
15-Jul 21:092104931,8024430/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,518,33810.080.0010 
active service list107,3070.000.0005,2240.00
alert log latch60.00 00 
AQ deq hash table latch30.00 00 
AQ dequeue txn counter latch3580.00 00 
archive control1900.00 00 
archive process latch8860.00 00 
ASM allocation1,6540.00 00 
ASM db client latch1,939,6990.00 00 
ASM Keyed state latch1990.00 00 
ASM map headers2,4520.00 00 
ASM map load waiting list5450.00 00 
ASM map operation freelist9110.00 00 
ASM map operation hash table12,781,0110.060.0000 
ASM network background latch8,1200.00 00 
ASM network SGA latch120.00 00 
ASM network state latch1,8290.00 00 
ASM scan context latch160.00 00 
AWR Alerted Metric Element list173,2550.00 00 
begin backup scn array80.00 00 
buffer pool30.00 00 
business card1710.00 00 
cache buffer handles29,7840.00 00 
cache buffers chains1,770,288,1270.010.01011,496,6500.07
cache buffers lru chain26,546,0380.040.00013,800,1480.02
cache table scan latch0  013,9570.00
call allocation1,5000.530.3800 
cas latch30.00 00 
change notification client cache latch30.00 00 
Change Notification Hash table latch3,5920.00 00 
channel handle pool latch3690.00 00 
channel operations parent latch219,782,6230.010.0200 
checkpoint queue latch1,144,279,4250.000.0002,672,1980.01
client/application info7370.00 00 
compile environment latch2440.00 00 
Consistent RBA576,9840.000.1100 
corrupted undo seg latch3,0080.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,094,3560.000.0000 
dml lock allocation1710.00 00 
done queue latch30.00 00 
dummy allocation4810.00 00 
enqueue freelist latch30.00 030,581,5480.00
enqueue hash chains45,131,8350.190.0007700.13
enqueues3,1060.00 00 
error message lists4320.00 00 
Event Group Locks3510.00 00 
FAL Queue2930.00 00 
fast space usage latch641,2500.000.0000 
FIB s.o chain latch900.00 00 
fifth spare latch30.00 00 
file cache latch25,1070.00 00 
File State Object Pool Parent Latch8,440,3950.050.0100 
flashback allocation1,185,9270.000.0300 
flashback copy30.00 01,108,2370.03
flashback mapping41,3520.640.0200 
flashback prepare log info140.00 00 
flashback sync request72,1810.450.0000 
FOB s.o list latch31,0240.790.0100 
fourth Audit Vault latch30.00 00 
gc element32,163,5570.030.130866,2710.02
gc persistent rm160.00 00 
gcs commit scn state30.00 00 
gcs opaque info freelist4,481,0200.060.0000 
gcs partitioned table hash77,464,4860.200.000130,1720.01
gcs pcm hashed value bucket hash30.00 00 
gcs remaster request queue4350.00 00 
gcs remastering latch1,110,73513.460.0000 
gcs resource freelist1,697,7000.000.0001,200,3940.00
gcs resource hash36,619,9230.040.0104070.00
gcs resource scan list1,0840.00 00 
gcs shadows freelist2,532,2390.000.0002,733,6490.00
ges caches resource lists1,732,4860.350.0102,550,4370.02
ges deadlock list1,5560.00 00 
ges DFS wait callback info20.00 00 
ges domain table5,837,5330.000.0000 
ges enqueue table freelist5,939,7090.000.0000 
ges group table10,144,9800.000.0100 
ges process hash list128,958,1300.000.1200 
ges process parent latch15,690,7270.000.0000 
ges process table freelist1990.00 00 
ges resource hash list18,437,2830.060.1208482.71
ges resource scan list4130.00 00 
ges resource table freelist6,0170.00 00 
ges timeout list3,8660.00 06600.00
ges value block free list740.00 00 
global KZLD latch for mem in SGA20.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch2150.00 06,9370.00
hash table modification latch1,3100.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 latch360.00 00 
interrupt manipulation1,1360.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,1490.00 04,6160.00
job workq parent latch160.00 0130.00
job_queue_processes free list latch360.00 00 
job_queue_processes parameter latch8,0730.00 00 
JS broadcast add buf latch8,1980.00 00 
JS broadcast drop buf latch8,2010.00 00 
JS broadcast load blnc latch7,8790.00 00 
JS mem alloc latch560.00 00 
JS queue access latch590.00 00 
JS queue state obj latch284,1560.00 00 
JS Sh mem access210.00 00 
JS slv state obj latch620.00 00 
kcbtsemkid latch40.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,8960.00 00 
KFMD SGA170.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,839,2550.180.020147,1980.04
KJCT flow control latch28,820,9260.010.0100 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
KMG MMAN ready and startup request latch3,5890.00 00 
kokc descriptor allocation latch120.00 00 
krbmrosl1,6710.00 00 
ksfv messages30.00 00 
ksim group membership cache1,410,1600.000.0000 
ksim membership request latch0  010,5140.00
kss move lock950.00 00 
ksuosstats global area1,0860.00 00 
ksv allocation latch3530.00 00 
ksv class latch30,1100.030.0000 
ksv instance latch380.00 00 
ksv msg queue latch1320.00 01290.00
ksxp shared latch1990.00 00 
ksxp so latch1990.00 00 
KSXR large replies1,4360.00 00 
ksz_so allocation latch1990.00 00 
KTF sga latch990.00 03,5900.00
ktm global data624,6500.020.0100 
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 SCN580,2480.030.0000 
list of block allocation7,9600.00 00 
loader state object freelist1,3500.00 00 
lob segment dispenser latch1,243,4220.00 00 
lob segment hash table latch1,285,1510.000.2500 
lob segment query latch5570.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,2120.020.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,8180.020.0300 
messages60,891,1627.590.0010 
MinActiveScn Latch3,8270.00 00 
mostly latch-free SCN597,5851.570.0200 
MQL Tracking Latch0  02140.00
msg queue latch30.00 00 
multiblock read objects202,4420.000.0000 
Mutex30.00 00 
Mutex Stats30.00 00 
name-service memory objects35,7200.00 00 
name-service namespace bucket4,305,4670.000.0000 
name-service namespace objects360.00 00 
name-service pending queue7,1540.00 00 
name-service request1300.00 00 
name-service request queue126,0580.00 00 
ncodef allocation latch1710.00 00 
object queue header heap286,784,4840.000.0003,511,6100.17
object queue header operation402,611,1060.010.0200 
object stats modification58,9010.030.0000 
OS process8570.00 00 
OS process allocation22,0030.00 00 
OS process: request allocation1990.00 00 
parallel query alloc buffer7,8260.00 00 
parallel query stats3810.00 00 
parallel txn reco latch66,4320.00 00 
parameter list1180.00 00 
parameter table management6010.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
PL/SQL warning settings2,0200.00 00 
post/wait queue3,441,7110.190.0003,825,2140.67
process allocation17,4600.00 01040.00
process group creation1990.00 00 
process queue1,0190.00 00 
process queue reference16,1740.00 01,6280.00
PX hash array latch30.00 00 
qmn task queue latch1,5270.00 00 
QMT30.00 00 
query server freelists8980.00 00 
query server process610.00 0220.00
queued dump request360.00 00 
queuing load statistics30.00 00 
Real-time plan statistics latch1,0800.00 00 
recovery domain hash list30.00 00 
redo allocation2,966,2780.140.0109,020,7520.46
redo copy30.00 09,035,6080.33
redo writing19,488,1644.180.0000 
reservation so alloc latch40.00 00 
Reserved Space Latch100.00 00 
resmgr group change latch1,409,6670.000.0000 
resmgr:active threads40,6880.001.0003,5740.00
resmgr:actses change group2650.00 00 
resmgr:actses change state300.00 00 
resmgr:free threads list5240.190.0000 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method44,2890.210.0000 
resmgr:schema config1,789,2141.500.93681172.56
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects1,775,426,53422.940.03199920.00
second Audit Vault latch30.00 00 
second spare latch30.00 00 
segmented array pool820.00 00 
sequence cache1,556,3940.040.0000 
session allocation136,3610.000.000135,9160.00
session idle bit10,253,8190.000.0000 
session queue latch30.00 00 
session state list latch5610.00 00 
session switching2690.370.0000 
session timer3,5840.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA IO buffer pool latch960.00 0960.00
SGA pool locks30.00 00 
Shared B-Tree3780.00 00 
shared pool10,884,1110.040.0100 
shared pool sim alloc80.00 00 
shared pool simulator4530.00 00 
sim partition latch30.00 00 
simulator hash latch58,330,3570.000.0000 
simulator lru latch30.00 058,093,0560.01
sort extent pool158,2470.00 00 
space background state object latch120.00 00 
space background task latch2,560,59912.280.05367,0180.12
SQL memory manager latch30.00 03,5810.00
SQL memory manager workarea list latch241,0790.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 allocation60.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
Testing30.00 00 
third spare latch30.00 00 
threshold alerts latch5510.00 00 
Token Manager30.00 00 
transaction allocation2,389,6570.000.0000 
undo global data817,227,5400.030.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$KSFQP540.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects1,775,426,534407,212,26010,375,065400,963,909
messages60,891,1624,621,5926,4304,615,184
active checkpoint queue latch19,518,3381,966,9985,2221,961,781
redo writing19,488,164815,4702,183813,287
space background task latch2,560,599314,36216,927297,452
undo global data817,227,540246,756642246,129
cache buffers chains1,770,288,127156,0262,185153,873
enqueue hash chains45,131,83585,29323385,060
object queue header operation402,611,10650,19196949,234
resmgr:schema config1,789,21426,80024,9411,876
channel operations parent latch219,782,62326,48649626,000
gcs resource hash36,619,92315,95414515,813
checkpoint queue latch1,144,279,42515,3706015,312
ges resource hash list18,437,28311,4401,33710,107
cache buffers lru chain26,546,03811,2702611,244
gc element32,163,5579,7711,3028,514
mostly latch-free SCN597,5859,3731429,235
ASM map operation hash table12,781,0117,990167,974
post/wait queue3,441,7116,407166,391
ges caches resource lists1,732,4866,080875,993
object queue header heap286,784,4845,765165,749
shared pool10,884,1114,310324,278
redo allocation2,966,2784,106474,059
File State Object Pool Parent Latch8,440,3953,936213,915
KJC message pool free list1,839,2553,377693,308
KJCT flow control latch28,820,9262,619292,591
gcs opaque info freelist4,481,0202,471112,460
ges process hash list128,958,130867107760
message pool operations parent latch4,793,81881824794
sequence cache1,556,3946442642
ges group table10,144,9804183416
session idle bit10,253,8193421341
flashback mapping41,3522666260
FOB s.o list latch31,0242442242
ktm global data624,650100199
flashback allocation1,185,92729128
Consistent RBA576,984918
call allocation1,500835
lob segment hash table latch1,285,151413
resmgr:active threads40,688220

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active checkpoint queue latchkcbbacq: scan active checkpoints04,9485,075
active checkpoint queue latchkcbkcpa: Checkpoint post-processing013892
active checkpoint queue latchkcbkcpa: Checkpoint post-processing 209931
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 10178
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 201011
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 30105
ASM map operation hash tablekffmTranslate0911
ASM map operation hash tablekffmDoDone_1075
cache buffers chainskcbchg1: clear MS bit01,0075
cache buffers chainskcbgcur_40409657
cache buffers chainskcbbxsv0324332
cache buffers chainskcbrls_2025696
cache buffers chainskcbzwb08214
cache buffers chainskclbla05434
cache buffers chainskclwlr03413
cache buffers chainskcllkopesc0282
cache buffers chainskcbgcur_20152
cache buffers chainskclwrt0115
cache buffers chainskcbgtcr: fast path (cr pin)065
cache buffers chainskcbzib: finish processing buffer051
cache buffers chainskcbchg1: mod cur pin034
cache buffers chainskcbgtcr: fast path0310
cache buffers chainskcbzgb: scan from tail. nowait020
cache buffers chainskclwcrs020
cache buffers chainskcbbic2010
cache buffers chainskcbgtcr_2011
cache buffers chainskcbkzs010
cache buffers chainskcbnlc011
cache buffers chainskcbrls: fast release0123
cache buffers chainskclcrs_1010
cache buffers chainskcllkopb_1012
cache buffers chainskclrlstp011
cache buffers lru chainkcbbic2069
cache buffers lru chainkcbbxsv: move to being written050
cache buffers lru chainkcbzgws050
cache buffers lru chainkcbkcxe042
cache buffers lru chainkcbzgb030
cache buffers lru chainkcbo_link_q020
cache buffers lru chainkcbbwlru0113
call allocationksuxds033
channel operations parent latchksrwait()0323335
channel operations parent latchksrapublish()09015
channel operations parent latchksrpubwait():1084128
channel operations parent latchksrsconsume()03469
channel operations parent latchksrmfree()0178
checkpoint queue latchkcbkubc_402325
checkpoint queue latchkcbbwthc: thread checkpoint buffers01625
checkpoint queue latchkcbbwdl: thread checkpoint queue0128
checkpoint queue latchkcbklbc_cql090
enqueue hash chainsksqrcl09521
enqueue hash chainsksqcmi: if lk mode not requested068168
enqueue hash chainsksqcmi: if lk mode requested03312
enqueue hash chainsksqcnl0205
enqueue hash chainsksqgtl301728
File State Object Pool Parent LatchFSO create01212
File State Object Pool Parent LatchFSO delete normal099
flashback allocationkrfgdata2011
flashback mappingkrfget_sfgda1056
flashback mappingkrfw_advance_mapping1010
FOB s.o list latchksfd_fobd022
gc elementkclchkping01,1080
gc elementkclnfndnewm07430
gc elementkclrwrite04849
gc elementkclfwrite102925
gc elementkclulb02521
gc elementkclbla01113
gc elementKCLUNLNK01120
gc elementkclwrt0412
gc elementkclebs022
gc elementkclfwrite2010
gc elementkclhngcbk1010
gc elementkclpdc_21014
gc elementkclplz_1014
gcs opaque info freelistkjbrcvt save opaque info065
gcs opaque info freelistkjbrinfofree free opaque info056
gcs resource hashkjbassume0355
gcs resource hashkclrwrite03125
gcs resource hashkjbcropen0218
gcs resource hashkclfwrite101814
gcs resource hashkjbrwrdone reget0131
gcs resource hashkjbcrcomplete094
gcs resource hashkjbconvert050
gcs resource hashkjbmpcreatepi0320
gcs resource hashkjbopen:affinity030
gcs resource hashkclgrantlk_1020
gcs resource hashkjbopen024
gcs resource hashkjbmdowncvt016
gcs resource hashkjbmpclose0122
gcs resource hashkjbmpconvert013
ges group tablekjgdgll: move a lock from group lock list to process lock list020
ges group tablekjgagll: move a lock from process lock list to group lock list013
ges process hash listkjakiqa: set inquiry response01070
ges resource hash listkjakcai: search for resp by resname084934
ges resource hash listkjlmfnd: search for lockp by rename and inst id026416
ges resource hash listkjlrlr: remove lock from resource queue0156152
ges resource hash listkjrmas1: lookup master node0341
ges resource hash listkjucvl: lock convert request0220
ges resource hash listkjuinq: inquire resource held mode080
ges resource hash listkjakoca: search for resp by resname031,138
ges resource hash listkjrref: find matched resource0125
ges resource table freelistkjchc: clean resource cache0830
ges resource table freelistkjrm2c: move resource to cache0487
KJC message pool free listkjcsmpav: allocate a msg buffer06671
KJC message pool free listkjcspfmbq: free vector of msg buffers030
KJCT flow control latchkjcts_sqenq: queue a message0209
KJCT flow control latchkjctcsnd: send normal message077
KJCT flow control latchkjctr_updatetkt: update ticket info012
KJCT flow control latchkjcts_sedeqv2: dequeue a vector of msgs0111
ktm global dataktmbis010
lgwr LWN SCNkcs0230460
lob segment hash table latchlob_segment_dispenser:20010
message pool operations parent latchksrmalloc()0184
message pool operations parent latchksrmfree()055
message pool operations parent latchksrmdone()0317
messagesksarcv03,8162,551
messagesksarcv: after wait01,4921,945
messagesksaamb: after wakeup01,1221,934
mostly latch-free SCNkcslcu3096142
mostly latch-free SCNkcsnew_scn_rba010
object queue header heapkcbo_link_q:alloc061
object queue header heapkcbo_unlink_q_bg060
object queue header heapkcbo_unlink_q040
object queue header operationkcldbufs0281230
object queue header operationkcbo_link_q018941
object queue header operationkcbo_unlink_q012642
object queue header operationkcbo_switch_mq_bg012056
object queue header operationkcbo_switch_q_bg08554
object queue header operationkcbo_check_flist067553
object queue header operationkcbo_link_q:reget0472
object queue header operationkcbo_unlink_q_bg04327
object queue header operationkcbo_switch_cq04122
object queue header operationkclbufs0298
PC and Classifier lists for WLMNo latch010
post/wait queueksliwat:add:nowait080
post/wait queueksliwat:add:wait037
post/wait queuekslpstevent:reget033
post/wait queuekslpstevent:get023
redo allocationkcrfw_redo_gen: redo allocation 10450
redo allocationkcrfw_redo_gen: redo allocation 2020
redo writingkcrfwcr02,1122,130
redo writingkcrfw_cal_target_rba03832
redo writingkcrfw_post: rba scn pair0320
redo writingkcrfw_post: after write0121
resmgr:active threadskgsksimsetup1020
resmgr:schema configkgskgmaxdop1024,16824,875
resmgr:schema configkgskgasi1070865
resmgr:schema configkgskmetricupd0600
resmgr:schema configkgskgcs1050
row cache objectskqrpre: find obj04,666,1145,709,098
row cache objectskqreqd: reget03,369,5381,789,975
row cache objectskqreqd02,338,8962,875,653
row cache objectskqrigt010
sequence cachekdnnxt: cached seq010
sequence cachekdnssd010
session idle bitksupuc: set busy010
shared poolkghalo01928
shared poolkghfre0134
space background task latchktsj_grab_task016,16216,839
space background task latchktsjCreateTask065010
space background task latchktsj_detach_task011478
undo global dataktudba: KSLBEGIN0637641
undo global dataktudnx:child030
undo global dataktufrbs_2021

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 4250
Library Cachekglpnal2 91250
Library Cachekglpndl1 95160
Library Cachekglpnal1 90120
Library Cachekglhdgn2 106100
Library Cachekgllkdl1 8580
Cursor PinkksLockDelete [KKSCHLPIN6]80
Cursor Pinkksfbc [KKSCHLFSP2]70
Cursor Pinkksfbc [KKSCHLPIN1]60
Library Cachekgllkal1 8050
Library Cachekgllkc1 5740
Library Cachekglobpn1 7130
Library Cachekglhdgn1 6210
Library Cachekglllal1 10910
hash tablekkscsSearchChildList [KKSHBKLOC2]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,282,3840.15
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX1,089,0400.13
EZTOEZTO_DATALIBRARYSYS_P17813TABLE PARTITION767,2320.09
EZTOEZTO_INDEXBYCONSTESTMEDIA INDEX683,4400.08
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX652,9600.08

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB100,4153.19
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION4,5020.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,4960.14
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,4000.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48438LOB PARTITION3,9580.13

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB100,4143.23
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION4,5020.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,4960.14
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,3980.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48438LOB PARTITION3,9580.13

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB100,4143.23
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48444LOB PARTITION4,5020.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48446LOB PARTITION4,4960.14
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION4,3980.14
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48438LOB PARTITION3,9580.13

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1797134646_1094TABLE PARTITION1315.09

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB96,0675.51
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX31,4101.80
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,6000.15
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50675LOB PARTITION1,9650.11
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,7510.10

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX27,8243.38
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,2010.27
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,8470.22
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,2710.15
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50819LOB PARTITION1,0600.13

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 PARTITION13727.68

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 INDEX327,74432.58
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB107,66410.70
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION26,7522.66
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX26,5762.64
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49318INDEX PARTITION9,9040.98

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 INDEX8877.88
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P48945INDEX PARTITION43.54
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION32.65
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX21.77
EZTOEZTO_INDEXATTEMPTDATA_PKSYS_P49547INDEX PARTITION21.77

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SYSSYSAUXWRH$_SEG_STAT_PKWRH$_SEG_ST_1797134646_1094INDEX PARTITION1100.00

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_P50565LOB PARTITION103.24
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX92.91
SYSSYSTEMSEG$ TABLE92.91
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50508LOB PARTITION82.59
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50700LOB PARTITION72.27

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX1020.83
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX816.67
SYSSYSTEMSEG$ TABLE612.50
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41213LOB PARTITION36.25
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48465LOB PARTITION36.25

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 PARTITION43,5434.19
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX35,8573.45
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41296LOB PARTITION5,6980.55
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41234LOB PARTITION3,8940.37
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,1290.11

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX154,3407.84
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX29,2231.48
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION2,6240.13
EZTOEZTO_INDEXATTEMPT_TESTUSERID_IDXSYS_P39068INDEX PARTITION1,9780.10
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,1650.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_control1933.630 01
dc_files7960.000 0398
dc_global_oids290.000 034
dc_histogram_data2140.000 0558
dc_histogram_defs2,4136.590 04,765
dc_objects307,4500.090 146,789
dc_profiles160.000 01
dc_rollback_segments591,113,6940.000 01,040
dc_segments102,0370.410 28616,964
dc_sequences14288.730 1420
dc_tablespaces106,6170.000 012
dc_users208,7910.000 078
global database name9,6320.000 01
outstanding_alerts138100.000 00
sch_lj_oids2015.000 05

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control770
dc_histogram_defs15900
dc_objects295510
dc_segments9924930
dc_sequences2841270
dc_users100
outstanding_alerts2641380
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_STATUS40.000 00
BODY1137.964,2720.2300
CLUSTER20.0020.0000
DBLINK210.000 00
EDITION550.00640.0000
INDEX1390.7213917.99240
QUEUE0 1790.0000
SCHEMA681.470 00
SQL AREA92,4830.333,316,8630.015071
SQL AREA BUILD12138.840 00
SQL AREA STATS12158.6812158.6800
TABLE/PROCEDURE98,1240.15763,2550.02340

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS40000
BODY04,2644,26400
CLUSTER22200
DBLINK210000
EDITION55585800
INDEX13913913900
QUEUE017917900
SCHEMA110000
TABLE/PROCEDURE98,230665,438665,43800

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
BOther985.88 2.958.15134134334334
Freeable38.690.000.941.578 4141
SQL1.690.110.010.0105290278
PL/SQL0.950.360.000.0100332330
EOther2,024.56 5.908.93133133343343
Freeable91.190.000.591.168 155155
SQL6.260.580.020.0205295287
PL/SQL1.810.800.010.0300341340

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.730.11
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,019.79859.68-15.70
sharedgcs resources214.34214.340.00
sharedgcs shadows125.03125.030.00
sharedges enqueues146.50147.850.92
sharedges resource88.4589.020.65
sharedksunfy : SSO free list119.14119.140.00
sharedKTSL subheap49.17162.51230.54
sharedobject queue39.2471.0581.06
 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,7820.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,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.00100.0000 
D0000.0010,7820.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_number1  
large_pool_size268435456  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.169.2.53)(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  
thread1  
undo_tablespaceUNDOTBS1  
_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,255,854116.619.33
acks for commit broadcast(logical)1,509,219140.1411.21
broadcast msgs on commit(actual)1,477,836137.2310.98
broadcast msgs on commit(logical)1,639,281152.2212.18
broadcast msgs on commit(wasted)308,24428.622.29
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received1530.010.00
flow control messages sent780.010.00
gcs apply delta00.000.00
gcs assume cvt5,8060.540.04
gcs assume no cvt1,745,115162.0512.96
gcs ast xid160.000.00
gcs blocked converts1,656,643153.8312.31
gcs blocked cr converts1,048,87297.407.79
gcs compatible basts478,68944.453.56
gcs compatible cr basts (global)261,57024.291.94
gcs compatible cr basts (local)199,42018.521.48
gcs cr basts to PIs70.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs200,23718.591.49
gcs dbwr write request msgs146,00813.561.08
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 only330,50930.692.46
gcs force cr grant278,87025.902.07
gcs force cr no current00.000.00
gcs forward cr to pinged instance130.000.00
gcs immediate (compatible) converts37,8333.510.28
gcs immediate cr (compatible) converts2730.030.00
gcs immediate cr (null) converts122,65611.390.91
gcs immediate (null) converts1,404,487130.4210.43
gcs indirect ast1,213,598112.699.01
gcs indirect bidless ast5,1770.480.04
gcs indirect fg ast1,213,571112.699.01
gcs lms flush pi msgs136,88612.711.02
gcs lms write request msgs123,59311.480.92
gcs msgs process time(ms)377,23935.032.80
gcs msgs received14,460,4891,342.76107.42
gcs new served by master34,8433.240.26
gcs out-of-order msgs4370.040.00
gcs pings refused5790.050.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts7,6320.710.06
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast5,1540.480.04
gcs reader bypass grant immediate6,6310.620.05
gcs reader bypass grant X on assume2360.020.00
gcs reader bypass N->Xw ping local2220.020.00
gcs reader bypass N->Xw ping remote1900.020.00
gcs recovery claim msgs00.000.00
gcs refuse xid370.000.00
gcs regular cr683,02663.425.07
gcs retry convert request1,1760.110.01
gcs share recovery bast00.000.00
gcs side channel msgs actual00.000.00
gcs side channel msgs logical00.000.00
gcs stale cr1,378,358127.9910.24
gcs undo cr520.000.00
gcs write notification msgs10,3600.960.08
gcs writes refused4,6970.440.03
ges msgs process time(ms)54,2245.040.40
ges msgs received2,368,900219.9717.60
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 received342,54031.812.54
implicit batch messages sent325,38430.212.42
lmd msg send time(ms)30.000.00
lms(s) msg send time(ms)170.000.00
messages flow controlled122,86211.410.91
messages queue sent actual6,044,311561.2644.90
messages queue sent logical801,99274.475.96
messages received actual15,984,5401,484.28118.74
messages received logical16,829,9051,562.77125.02
messages sent directly7,556,693701.6956.13
messages sent indirectly4,708,522437.2234.98
messages sent not implicit batched00.000.00
messages sent pbatched5,293,339491.5239.32
msgs causing lmd to send msgs1,624,619150.8612.07
msgs causing lms(s) to send msgs2,772,359257.4320.59
msgs received queue time (ms)450,84141.863.35
msgs received queued16,827,7291,562.57125.00
msgs sent queue time (ms)258,17323.971.92
msgs sent queue time on ksxp (ms)3,498,006324.8125.98
msgs sent queued6,518,803605.3248.42
msgs sent queued on ksxp16,135,6941,498.31119.86
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received4,406,192409.1532.73
process batch messages sent4,905,599455.5236.44


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests685,426
CURRENT Block Requests1,326,299
Data Block Requests685,430
Undo Block Requests52
TX Block Requests1,363
Current Results1,013,309
Private results1,740
Zero Results680
Disk Read Results996,045
Fail Results5
Fairness Down Converts298,646
Fairness Clears28,093
Free GC Elements0
Flushes5,200
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)47,782
Light Works5,216
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins11,80955.4135.119.430.060.00
Flushes65,2229.0887.523.390.010.00
Writes245,26245.8152.651.360.180.00


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
4data block238,71096.110.793.09255,40594.393.681.93
2data block216,29995.740.813.46215,33694.014.051.94
3data block214,78195.910.733.36208,43393.924.161.93
4Others136,76397.910.082.01187,70696.171.841.99
4undo header13597.042.220.74292,21588.929.851.23
3Others115,12197.920.081.99168,39496.101.991.91
2Others117,13697.760.122.12162,87296.291.751.96
2undo header11688.798.622.59242,75388.4010.381.22
3undo header12489.529.680.81236,02990.358.411.25
2undo block3683.3316.670.000   
3undo block1586.6713.330.000   
4undo block1376.9223.080.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.400.382.920.470.370.350.760.47
2data block0.390.363.020.510.350.330.750.39
3data block0.390.372.980.470.360.340.770.45
4others0.310.312.620.340.310.310.700.37
4undo header0.290.261.530.260.630.263.950.30
3others0.290.282.980.320.290.280.700.33
2others0.300.293.070.330.300.290.660.35
2undo header0.330.231.370.260.640.254.010.35
3undo header0.390.241.810.240.550.243.850.28
2undo block5.150.2329.80     
3undo block0.420.271.42     
4undo block0.550.231.61     

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 block0229,42650.0449.96241,07559.7840.22
2data block0207,07852.7447.26202,44758.9141.09
3data block0205,99847.0852.92195,75055.2644.74
4others0133,90050.5749.43180,51759.0640.94
3others0112,72952.4947.51161,83062.2937.71
2others0114,51149.5650.44156,83557.9242.08
4undo header0131100.000.00259,834100.000.00
2undo header0103100.000.00214,591100.000.00
3undo header0111100.000.00213,247100.000.00
2undo block030100.000.000  
3undo block013100.000.000  
4undo block010100.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.380.290.460.350.280.45
2data block 0.360.280.460.330.260.44
3data block 0.370.270.460.340.260.44
4others 0.310.230.380.310.240.41
3others 0.280.210.370.280.220.40
2others 0.290.210.380.290.220.40
4undo header 0.260.26 0.260.26 
2undo header 0.230.23 0.250.25 
3undo header 0.240.24 0.240.24 
2undo block 0.230.23    
3undo block 0.270.27    
4undo block 0.230.23    

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
18560.430.158560.420.15
28560.390.148560.430.15
38560.410.148560.440.15
48560.440.158560.480.15

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache1.321.31
Parallel Query0.000.00
DB Locks0.380.37
DB Streams0.000.00
Other0.030.03

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.71.72NO  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 received1,712428.00  
replayed locks sent9,4582,364.50  
resources cleaned00.00  
remaster time (s)5.21.29  
quiesce time (s)0.70.18  
freeze time (s)0.10.03  
cleanup time (s)0.10.02  
replay time (s)0.80.20  
fixwrite time (s)1.20.29  
sync time (s)2.30.57  
affinity objects  13


Back to Top

End of Report