WORKLOAD REPOSITORY report for

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

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:110115-Jul-13 21:00:39325 1.9
End Snap:110416-Jul-13 00:00:08337 12.3
Elapsed:  179.49 (mins)  
DB Time:  224.52 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 1.3 0.1 0.00 0.00
DB CPU(s): 0.3 0.0 0.00 0.00
Redo size: 1,305,191.1 88,349.2  
Logical reads: 77,630.0 5,254.8  
Block changes: 1,258.7 85.2  
Physical reads: 330.2 22.4  
Physical writes: 190.5 12.9  
User calls: 559.3 37.9  
Parses: 7.3 0.5  
Hard parses: 0.0 0.0  
W/A MB processed: 0.0 0.0  
Logons: 0.0 0.0  
Executes: 359.0 24.3  
Rollbacks: 0.0 0.0  
Transactions: 14.8   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.58In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.57
Execute to Parse %: 97.96Latch Hit %: 92.90
Parse CPU to Parse Elapsd %: 18.61% Non-Parse CPU: 99.20

Shared Pool Statistics

BeginEnd
Memory Usage %: 65.19 72.51
% SQL with executions>1: 80.55 80.89
% Memory for SQL w/exec>1: 76.52 74.88

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read1,663,9507,051452.34User I/O
DB CPU 3,271 24.28 
reliable message461,9851,16538.65Other
enq: CR - block range reuse ckpt585,15956314.18Other
log file sync159,06438722.87Commit

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

Load Average BeginLoad Average End%User%System%WIO%Idle
1.48 1.56 3.8 0.8 1.0 95.3
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
3.8 82.3 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 129,050.1 129,050.1
SGA use (MB): 12,233.1 12,233.1
PGA use (MB): 838.7 2,095.2
% Host Mem used for SGA+PGA: 10.13 11.10

RAC Statistics

BeginEnd
Number of Instances: 4 4

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 299.67 20.29
Global Cache blocks served: 309.32 20.94
GCS/GES messages received: 1,560.89 105.66
GCS/GES messages sent: 1,596.51 108.07
DBWR Fusion writes: 25.92 1.75
Estd Interconnect traffic (KB) 5,488.64 

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

Buffer access - local cache %: 99.19
Buffer access - remote cache %: 0.39
Buffer access - disk %: 0.42

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.6
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 3.2
Avg global cache current block flush time (ms): 2.9

Global Cache and Enqueue Services - Messaging Statistics

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


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
bond1:1169.254.40.2N    

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 time11,497.5585.35
DB CPU3,271.3924.28
parse time elapsed141.141.05
sequence load elapsed time1.090.01
repeated bind elapsed time0.220.00
hard parse elapsed time0.120.00
PL/SQL execution elapsed time0.040.00
connection management call elapsed time0.010.00
RMAN cpu time (backup/restore)0.000.00
DB time13,471.46 
background elapsed time27,699.24 
background cpu time23,234.30 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME3,218,745 
IDLE_TIME65,955,335 
IOWAIT_TIME686,353 
NICE_TIME559 
SYS_TIME552,433 
USER_TIME2,626,890 
LOAD12
PHYSICAL_MEMORY_BYTES135,318,794,240 
NUM_CPU_CORES32 
NUM_CPUS64 
NUM_CPU_SOCKETS4 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX2,097,152 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
15-Jul 21:00:391.48     
15-Jul 22:00:051.221.160.690.4798.840.20
15-Jul 23:00:022.019.087.991.0090.921.60
16-Jul 00:00:081.563.682.690.9396.321.17

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,768,10007,249453.81
DB CPU  3,271 24.28
Other1,077,89401,800213.36
Cluster3,355,64001,11808.30
Commit159,064038722.87
Network6,727,063028702.13
Concurrency13,6130400.03
Configuration50684130.01
Administrative710011860.01
Application4341010.00
Scheduler30000.00
System I/O0 0 0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
db file sequential read1,663,95007,051410.4652.34
reliable message461,98501,16532.908.65
enq: CR - block range reuse ckpt585,159056313.684.18
log file sync159,064038721.002.87
gc current grant 2-way1,207,435027607.592.05
SQL*Net more data from client1,185,799024407.451.81
db file scattered read75,244019630.471.46
gc current grant busy413,422019202.601.42
gc current block 3-way385,332016702.421.24
gc current block 2-way546,462013903.431.03
gc cr block 3-way268,378011701.690.87
gc cr block 2-way283,63107401.780.55
gc cr multi block request151,34307100.950.53
latch free26,59206830.170.51
gc current block busy35,63202710.220.20
SQL*Net more data to client751,95802404.730.18
gc buffer busy release6,72301830.040.14
SQL*Net message to client4,781,494018030.050.13
gc cr block busy5,71001730.040.13
gc current block congested18,7220800.120.06
gc cr block congested11,8200610.070.04
gc current grant congested16,1430400.100.03
name-service call wait3603780.000.02
latch: row cache objects12,1880200.080.01
JS kgl get object wait710011860.000.01
db file parallel read7601160.000.01
gc current multi block request2,2040110.010.01
SQL*Net vector data to client7,8120100.050.01
gc cr grant 2-way2,3620100.010.01
row cache lock3540120.000.00
undo segment extension7584180.000.00
buffer busy waits5030110.000.00
resmgr:internal state change510011000.000.00
enq: TX - index contention2500020.000.00
log file switch completion1000490.000.00
direct path read6890010.000.00
local write wait760060.000.00
enq: FB - contention1,3740000.010.00
enq: TX - row lock contention2001670.000.00
Disk file operations I/O28,0640000.180.00
gc buffer busy acquire1610020.000.00
enq: TX - contention920030.000.00
enq: SQ - contention1400150.000.00
enq: HW - contention40489000.000.00
DFS lock handle7312020.000.00
enq: TM - contention4270000.000.00
gc cr grant congested310030.000.00
library cache: mutex X1000010.000.00
SecureFile mutex960010.000.00
enq: PS - contention13813000.000.00
latch: ges resource hash list6210000.000.00
PX Deq: Slave Session Stats1380000.000.00
IPC send completion sync4680000.000.00
os thread startup100300.000.00
gc cr disk read940000.000.00
gc current retry60030.000.00
gc current split240010.000.00
library cache lock2990000.000.00
PX Deq: reap credit948100000.010.00
cursor: pin S100010.000.00
wait list latch free100010.000.00
enq: JQ - contention12100010.000.00
library cache pin200000.000.00
latch: shared pool390000.000.00
enq: JS - job run lock - synchronize10100010.000.00
latch: enqueue hash chains480000.000.00
enq: UL - contention5100010.000.00
latch: object queue header operation470000.000.00
ASM file metadata operation750000.000.00
latch: messages20010.000.00
gc cr failure50000.000.00
latch: gc element290000.000.00
SQL*Net message from client4,781,49602,829,17159230.05 
jobq slave wait2,5601001,2825010.02 
KSV master wait15002120.00 
PX Deq: Execution Msg5400120.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file sequential read1,583,16301,32819.954.79
latch: row cache objects14,935,25301,290093.884.66
log file parallel write657,89801,02724.143.71
db file parallel write969,384075316.092.72
gc current block busy68,498025940.430.93
gc cr disk read1,151,363022707.240.82
gc current block 2-way886,796021005.570.76
gcs log flush sync164,541120811.030.75
flashback log file write55,532013930.350.50
enq: CR - block range reuse ckpt216,17209001.360.32
gc current grant busy158,46706801.000.25
log file sequential read5,580060110.040.22
gc cr block 3-way156,84405800.990.21
gc current block 3-way141,07105500.890.20
ges inquiry response118,50505100.740.18
gc buffer busy release13,30504740.080.17
gc cr block 2-way162,34403401.020.12
ASM file metadata operation5,70403050.040.11
control file sequential read55,32402700.350.10
gc buffer busy acquire3,94202560.020.09
ksxr poll remote instances1,523,6711002509.580.09
DFS lock handle48,549992400.310.09
buffer busy waits4,87802250.030.08
control file parallel write5,14601530.030.05
CSS operation: data query3,58001130.020.04
row cache cleanup3,652,97109022.960.03
latch free18,6180600.120.02
enq: DW - contention14,735100600.090.02
gc current block congested15,9610600.100.02
wait list latch free5,0800510.030.02
PX Nsq: PQ load info query2410052010.000.02
os thread startup12004360.000.02
ges lms sync during dynamic remastering and reconfig96593330.000.01
reliable message1,8750310.010.01
enq: WF - contention6203420.000.01
gc current grant 2-way10,0670200.060.01
gc cr block congested6,4570200.040.01
LGWR wait for redo copy24,9620200.160.01
libcache interrupt action by LCK3,650,70902022.950.01
row cache lock1,3010110.010.01
row cache process3,657,65301022.990.01
enq: CO - master slave det3,588100100.020.00
latch: messages5,8680100.040.00
enq: XR - database force logging3,5780100.020.00
CGS wait for IPC msg100,232100100.630.00
name-service call wait1801510.000.00
db file async I/O submit877,3820105.510.00
gc cr block busy2980130.000.00
undo segment extension7279190.000.00
Log archive I/O3340120.000.00
direct path read1260040.000.00
enq: JS - wdw op1004510.000.00
enq: TM - contention34560120.000.00
latch: redo writing2,1140000.010.00
enq: CF - contention75343000.000.00
enq: TX - contention1800150.000.00
gc object scan36,462100000.230.00
read by other session830030.000.00
enq: HW - contention5280000.000.00
CSS group membership query1790010.000.00
db file scattered read220070.000.00
gc cr grant 2-way5200000.000.00
CSS operation: action340030.000.00
CSS initialization160060.000.00
rdbms ipc reply100850.000.00
local write wait160050.000.00
enq: PS - contention17235000.000.00
latch: object queue header operation5970000.000.00
enq: US - contention1260000.000.00
gc current grant congested1420000.000.00
latch: cache buffers chains1,3340000.010.00
Disk file operations I/O4,5380000.030.00
enq: RO - fast object reuse940010.000.00
gc cr multi block request1530000.000.00
direct path write890010.000.00
PX Deq: reap credit3,710100000.020.00
flashback log file read80040.000.00
log file single write120030.000.00
latch: undo global data4110000.000.00
latch: gc element7450000.000.00
enq: XL - fault extent map100270.000.00
enq: PI - contention57100000.000.00
latch: ges resource hash list2190000.000.00
CSS operation: query2270000.000.00
library cache lock744000.000.00
library cache pin710000.000.00
enq: TD - KTF dump entries330010.000.00
log file sync170010.000.00
gc current multi block request340010.000.00
kfk: async disk IO110020.000.00
enq: TA - contention640000.000.00
latch: enqueue hash chains1610000.000.00
library cache: mutex X180010.000.00
ges generic event11000100.000.00
flashback log file sync60020.000.00
PX Deq: Slave Session Stats1260000.000.00
latch: gcs resource hash790000.000.00
enq: TX - index contention20030.000.00
enq: TK - Auto Task Serialization12100010.000.00
enq: FB - contention210000.000.00
PX Deq: Signal ACK RSG1260000.000.00
db file parallel read10060.000.00
latch: checkpoint queue latch430000.000.00
ADR block file read450000.000.00
latch: redo allocation400000.000.00
PX Deq: Signal ACK EXT1260000.000.00
enq: MW - contention60010.000.00
enq: DR - contention60010.000.00
gc cr grant congested90000.000.00
latch: cache buffers lru chain200000.000.00
ARCH wait for archivelog lock40000.000.00
enq: AF - task serialization40000.000.00
asynch descriptor resize150100000.000.00
ADR block file write150000.000.00
rdbms ipc message16,879,8521329,68620106.10 
gcs remote message19,513,0202584,8954122.65 
Space Manager: slave idle wait951,581069,590735.98 
wait for unread message on broadcast channel21,6808921,5399940.14 
DIAG idle wait332,5017921,234642.09 
class slave wait3,078014,41046820.02 
PING3,7912310,77728430.02 
shared server idle wait35910010,773300100.00 
ASM background timer3,606010,77129870.02 
GCR sleep2,15310010,76650010.01 
pmon timer3,58710010,76230000.02 
Streams AQ: qmn coordinator idle wait7505010,760143460.00 
Streams AQ: qmn slave idle wait375010,760286920.00 
dispatcher timer17910010,742600110.00 
smon timer158,720010,724681.00 
ges remote message2,178,566210,635513.69 
PX Idle Wait15505,795373840.00 
KSV master wait7,901822840.05 
SQL*Net message from client6807980.00 
PX Deq: Parse Reply1260020.00 
PX Deq: Join ACK1260010.00 
PX Deq: Execute Reply1260000.00 
Streams AQ: RAC qmn coordinator idle wait759100000.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read45100.0       
ADR block file write15100.0       
ADR file lock18100.0       
ARCH wait for archivelog lock580.020.0      
ASM file metadata operation581290.1.2.61.1.21.56.1.1
asynch descriptor resize152100.0       
buffer busy waits538357.05.410.214.68.83.01.1 
buffer deadlock1100.0       
CGS wait for IPC msg100.2K100.0 .0     
control file parallel write5156 72.422.03.51.0.3.9 
control file sequential read55.4K95.82.31.0.5.3.1.0 
CSS group membership query17915.182.71.7.6    
CSS initialization1650.0   50.0   
CSS operation: action3417.617.611.852.9    
CSS operation: data query3580 4.095.3.7    
CSS operation: query22796.5 3.5     
cursor: mutex S1100.0       
cursor: pin S1090.0   10.0   
db file async I/O submit872.9K100.0       
db file parallel read77   10.470.110.49.1 
db file parallel write967K87.47.73.01.4.4.1.0 
db file scattered read75.3K70.51.95.411.98.91.3.2 
db file sequential read3247.5K69.52.85.013.67.01.7.3.0
DFS lock handle48.6K99.5.4.0.0 .0.1 
direct path read81584.53.93.24.72.71.0  
direct path write8988.87.93.4     
Disk file operations I/O32.6K100.0       
enq: AF - task serialization4100.0       
enq: CF - contention75499.6.4      
enq: CO - master slave det358899.8.2      
enq: CR - block range reuse ckpt801.4K87.36.53.61.9.5.2.1 
enq: DR - contention6100.0       
enq: DW - contention14.7K99.5.5      
enq: FB - contention1396100.0       
enq: FL - Flashback database log2100.0       
enq: HW - contention93299.6.4      
enq: JQ - contention1275.025.0      
enq: JS - job run lock - synchronize10100.0       
enq: JS - wdw op1      100.0 
enq: KD - determine DBRM master2100.0       
enq: KT - contention1100.0       
enq: MW - contention6100.0       
enq: PI - contention5798.21.8      
enq: PS - contention31098.11.9      
enq: PW - flush prewarm buffers2100.0       
enq: RO - fast object reuse9495.74.3      
enq: SQ - contention1421.47.128.614.314.3 14.3 
enq: TA - contention64100.0       
enq: TD - KTF dump entries3397.0 3.0     
enq: TK - Auto Task Serialization12100.0       
enq: TK - Auto Task Slave Lockout1100.0       
enq: TM - contention46199.3.2   .2.2 
enq: TX - allocate ITL entry3100.0       
enq: TX - contention11055.514.56.44.511.83.63.6 
enq: TX - index contention25389.3.81.62.81.22.81.6 
enq: TX - row lock contention2      100.0 
enq: UL - contention5100.0       
enq: US - contention12696.83.2      
enq: WF - contention6291.91.6    6.5 
enq: WL - contention1100.0       
enq: XL - fault extent map1     100.0  
enq: XR - database force logging357899.9.1      
flashback log file read850.0 12.525.0 12.5  
flashback log file sync616.766.716.7     
flashback log file write55.5K38.919.016.922.82.1.3.1 
gc buffer busy acquire410440.817.914.99.18.35.43.6 
gc buffer busy release20K26.439.519.57.43.82.21.2 
gc cr block busy60091.449.737.18.02.21.2.3 
gc cr block congested18.3K99.4.2.1.1.1.0.1 
gc cr block 2-way446.1K99.8.1.0.0.0.0.0 
gc cr block 3-way425.3K99.5.2.1.1.1.0.0 
gc cr disk read1151.6K99.8.0.0.0.0.0.0 
gc cr failure5100.0       
gc cr grant congested4095.0 2.5   2.5 
gc cr grant 2-way289199.8.1.1   .0 
gc cr multi block request151.5K99.2.6.1.1.0.0.0 
gc current block busy104.2K38.030.618.76.93.51.6.7 
gc current block congested34.7K99.5.2.1.1.1.0.1 
gc current block 2-way1433.5K99.8.1.0.0.0.0.0 
gc current block 3-way526.5K99.5.2.1.1.1.0.0 
gc current grant busy572K99.0.5.2.2.1.0.0 
gc current grant congested16.3K99.7.1.1.1.0.0.0 
gc current grant 2-way1217.6K99.8.0.0.0.0.0.0 
gc current multi block request222498.6.9.2.3.0   
gc current retry977.8  11.111.1   
gc current split2487.512.5      
gc object scan36.5K100.0       
gcs log flush sync164.6K55.129.110.83.81.2.0.0 
ges generic event1    100.0   
ges inquiry response118.5K99.6.4.0.0 .0  
ges lms sync during dynamic remastering and reconfig96  19.819.82.112.545.8 
IPC send completion sync576100.0       
JS kgl get object wait7      100.0 
kfk: async disk IO1163.618.2 18.2    
kjbdrmcvtq lmon drm quiesce: ping completion1100.0       
KJC: Wait for msg sends to complete27100.0       
ksxr poll remote instances1523.9K100.0.0.0     
latch: cache buffers chains1351100.0       
latch: cache buffers lru chain22100.0       
latch: call allocation2100.0       
latch: checkpoint queue latch43100.0       
latch: enqueue hash chains20999.5.5      
latch free45.2K50.012.627.410.0.0   
latch: gc element774100.0       
latch: gcs resource hash81100.0       
latch: ges resource hash list84199.5.4   .1  
latch: lob segment hash table latch1100.0       
latch: messages587099.6.2   .2  
latch: object queue header operation64499.5.2 .2.2   
latch: redo allocation40100.0       
latch: redo writing211499.7.3 .0    
latch: row cache objects14.9M99.9.1.0.0.0.0.0 
latch: shared pool4097.52.5      
latch: undo global data413100.0       
LGWR wait for redo copy25K100.0.0      
libcache interrupt action by LCK3651.3K100.0       
library cache lock10399.01.0      
library cache: mutex X11893.2   6.8   
library cache pin91100.0       
local write wait92  76.118.51.11.13.3 
lock escalate retry16100.0       
Log archive I/O33442.526.324.66.3.3   
log file parallel write658K45.239.311.23.2.8.2.0 
log file sequential read55903.63.15.338.134.312.53.1 
log file single write1650.06.36.325.012.5   
log file switch completion15     20.080.0 
log file sync159.1K9.056.924.86.71.8.6.2 
name-service call wait543.71.91.93.75.63.779.6 
os thread startup121     81.818.2 
PX Deq: reap credit4658100.0       
PX Deq: Signal ACK EXT126100.0       
PX Deq: Signal ACK RSG126100.0       
PX Deq: Slave Session Stats26498.9.4.4.4    
PX Nsq: PQ load info query24      100.0 
rdbms ipc reply1      100.0 
read by other session8459.56.010.711.97.14.8  
reliable message463.9K65.017.013.91.2.8.61.5 
resmgr:cpu quantum3100.0       
resmgr:internal state change5      100.0 
row cache cleanup3653.5K100.0.0      
row cache lock165187.910.7.2 .2.2.8 
row cache process3658.2K100.0       
SecureFile mutex9692.7   7.3   
SQL*Net message to client4781.6K100.0       
SQL*Net more data from client1185.8K93.55.9.4.1.0.0.0 
SQL*Net more data to client752.1K99.8.0.1.1.0.0.0 
SQL*Net vector data to client781299.2.1.2.4.1   
undo segment extension14755.1   19.721.83.4 
wait list latch free5088.099.7.3     
ASM background timer362412.81.0.5.4.42.322.859.9
class slave wait309643.6.410.93.010.01.716.314.1
DIAG idle wait332.5K14.71.41.2.514.833.933.5 
dispatcher timer179       100.0
GCR sleep2153       100.0
gcs remote message19.5M35.211.012.313.128.4.0.0 
ges remote message2178.8K71.711.63.42.93.33.04.3 
jobq slave wait2571      100.0 
KSV master wait807093.1.0.3.8.21.14.3.1
PING379177.4      22.6
pmon timer3586      .0100.0
PX Deq: Execute Reply12692.17.9      
PX Deq: Execution Msg54083.05.98.01.3.7.2.9 
PX Deq: Join ACK12666.77.112.713.5    
PX Deq: Parse Reply12661.15.616.716.7    
PX Idle Wait13810.9 1.4.78.78.045.724.6
rdbms ipc message16.5M69.98.16.14.13.73.14.7.3
shared server idle wait359       100.0
smon timer158.7K46.28.92.03.56.78.923.2.6
Space Manager: slave idle wait929.6K47.311.81.62.85.67.622.21.1
SQL*Net message from client4782.3K1.252.325.56.64.83.55.11.0
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    .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 operation35693.86.1.0   .0.1
buffer busy waits5898.9.9.0.0 .1  
control file parallel write4499.1.3.5.1    
control file sequential read18100.0.0.0.0    
db file parallel read790.97.81.3     
db file parallel write271100.0.0.0.0 .0  
db file scattered read12399.8.2.0  .0  
db file sequential read10.9K99.7.3.0.0.0.0.0 
DFS lock handle5699.9.0.1.0    
enq: CR - block range reuse ckpt57199.9.1.0.0.0   
enq: JS - wdw op1    100.0   
enq: SQ - contention285.77.17.1     
enq: TM - contention199.8   .2   
enq: TX - contention496.43.6      
enq: TX - index contention498.41.6      
enq: TX - row lock contention2 50.0  50.0   
enq: WF - contention493.5   3.23.2  
flashback log file write3099.9.1.0     
gc buffer busy acquire14996.42.6.9 .1.0  
gc buffer busy release23598.81.0.2.0 .0  
gc cr block busy1999.7.2.1     
gc cr block congested1699.9.0.0.0    
gc cr block 2-way25100.0.0.0.0    
gc cr block 3-way74100.0.0.0.0    
gc cr disk read62100.0.0.0.0    
gc cr grant congested197.5 2.5     
gc cr grant 2-way1100.0 .0     
gc cr multi block request14100.0.0.0     
gc current block busy67899.3.5.1.0.0.0  
gc current block congested2599.9.0.0.0    
gc current block 2-way95100.0.0.0.0    
gc current block 3-way87100.0.0.0.0    
gc current grant busy167100.0.0.0.0    
gc current grant congested5100.0.0.0     
gc current grant 2-way91100.0.0.0.0    
gcs log flush sync3100.0 .0     
ges lms sync during dynamic remastering and reconfig4454.237.58.3     
JS kgl get object wait7  42.928.628.6   
latch: row cache objects3100.0.0      
local write wait396.72.21.1     
log file parallel write295100.0.0.0.0    
log file sequential read17296.92.8.3.0    
log file switch completion1220.046.726.76.7    
log file sync38399.8.2.0.0    
name-service call wait4320.431.542.65.6    
os thread startup2281.87.49.9.8    
PX Nsq: PQ load info query24   100.0    
rdbms ipc reply1  100.0     
reliable message688398.5.6.7.1.0.0  
resmgr:internal state change5  100.0     
row cache lock1399.2.3.5     
SQL*Net more data from client235100.0.0.0.0    
SQL*Net more data to client3100.0.0 .0    
undo segment extension596.62.7.7     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
eztopqa_va13,4653,2681,96946,434
SYS$USERS2203
SYS$BACKGROUND211,587789,408
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 17680837249135494006726968287
SYS$USERS 3106407100
SYS$BACKGROUND 158794513291859362313200000

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,970.45187,2950.0229.4713.3071.350wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
3,037.77248,2460.0122.5512.4862.386fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,555.97112,9020.0111.5512.5579.149j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
263.8622,5580.011.9614.6975.99gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
256.64982.621.9115.5275.420m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
207.37151,9580.001.5456.240.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
162.6588,5260.001.2156.740.60aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
160.8722,4940.011.1978.190.20b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
150.32135,8910.001.1241.140.293jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
149.021021.461.1125.3461.79aa4maxrz4511z 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
528.14187,2950.0016.143,970.4513.3071.350wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
379.01248,2460.0011.593,037.7712.4862.386fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
195.21112,9020.005.971,555.9712.5579.149j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
125.7922,4940.013.85160.8778.190.20b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
116.63151,9580.003.57207.3756.240.008w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
92.2988,5260.002.82162.6556.740.60aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
61.84135,8910.001.89150.3241.140.293jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
39.82980.411.22256.6415.5275.420m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
38.7622,5580.001.18263.8614.6975.99gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
37.761020.371.15149.0225.3461.79aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,832.74187,2950.0233.023,970.4513.3071.350wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
1,894.88248,2460.0122.093,037.7712.4862.386fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
1,231.41112,9020.0114.351,555.9712.5579.149j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
200.5122,5580.012.34263.8614.6975.99gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
193.57981.982.26256.6415.5275.420m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
92.081020.901.07149.0225.3461.79aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
31.438700.040.3746.7419.8467.236mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
19.458700.020.2334.6119.8956.20d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
3.0413.040.043.142.9996.69350myuyx0t1d6   insert into wrh$_tablespace_st...
2.088030.000.028.9564.1123.279tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
6,697,118151,95844.070.80207.3756.208w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
5,675,427187,29530.300.683,970.4513.371.30wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
3,738,27422,494166.190.45160.8778.2.2b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
3,503,535248,24614.110.423,037.7712.562.46fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
2,892,07688,52632.670.35162.6556.7.6aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
1,974,648151,89813.000.2423.5831.105dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
1,842,437112,90216.320.221,555.9712.579.19j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
1,582,0441698,877.750.195.9098.6.253qg5xxgv1jxm JDBC Thin Client SELECT medialookaside.* FROM m...
1,574,452393,5344.000.1926.9327.20d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
1,343,576135,8919.890.16150.3241.1.33jwu317rq41wn 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
640,778187,2953.4218.023,970.4513.3071.350wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
499,303248,2462.0114.043,037.7712.4862.386fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
297,231983,032.978.36256.6415.5275.420m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
232,276112,9022.066.531,555.9712.5579.149j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
106,6561021,045.653.00149.0225.3461.79aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
46,76122,5582.071.31263.8614.6975.99gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
8,2278709.460.2346.7419.8467.236mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
4,5198705.190.1334.6119.8956.20d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
1,04888,5260.010.03162.6556.740.60aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
1,0158031.260.038.9564.1123.279tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...

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
619,384619,384187,2953.310.0018.610wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
232,102232,102112,9022.060.006.979j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
106,633106,6331021,045.420.003.20aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
75,33675,33698768.730.002.260m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
46,73646,73622,5582.070.001.40gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
11,89611,896248,2460.050.000.366fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
4,8884,88831,629.330.000.151cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
4144141414.000.000.01350myuyx0t1d6   insert into wrh$_tablespace_st...
340340408.500.000.01bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
33333388,5260.000.000.01aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
479,512479,4991.0047.8129.60dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
393,534393,5251.0026.9327.20d1fduptwha0n9 JDBC Thin Client SELECT mediatype FROM media WH...
369,590369,4511.0022.0128.20d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
248,246248,2451.003,037.7712.562.46fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
197,44987,9890.4513.9726.407jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
187,295432,5712.313,970.4513.371.30wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
151,9581,979,13413.02207.3756.208w92u8fd9rccd JDBC Thin Client SELECT * FROM library WHERE pa...
151,8981,518,97010.0023.5831.105dqygfkgt8hwd JDBC Thin Client SELECT catalogID FROM library ...
151,8941,518,92010.0019.97280d024vwxkhahjc JDBC Thin Client SELECT title, managers, partic...
140,235140,2331.0018.6425.509z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
135,896135,8941.0033.8931.31.656z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
135,891113,1080.83150.3241.1.33jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
135,48600.0014.6823.7076nzpvfmj776g JDBC Thin Client SELECT questionID, data FROM f...
112,902112,9021.001,555.9712.579.19j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
100,65400.006.5424.3073r2ts8p97um2 JDBC Thin Client SELECT flags FROM users WHERE ...
95,06395,0631.0010.8326.70054rpfwwu14za JDBC Thin Client SELECT url FROM tests WHERE te...
93,401393,5184.2112.40260ckr1vbptqjnd1 JDBC Thin Client SELECT mediaID FROM mediaconsu...
90,06490,0651.0011.7522.206y55dxn24t86q   select obj#, intcol#, ts#, fil...
88,526177,0502.00162.6556.7.6aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
63,95150,3240.7914.333100qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
50,31950,3191.007.2929.80dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
50,31968,4311.3644.5047.80ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
50,319125,4732.4912.9036.407cbf1umqgg15a 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
59,515187,29575.530wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
9,2549,25411.74350f5yrnnmshs   lock table sys.mon_mods$ in ex...
20950,3190.27dkmdukk4xfrsq JDBC Thin Client SELECT mediatype, datasize FRO...
209197,4490.277jkvzr8ar6j6g JDBC Thin Client SELECT name FROM mediaconsumer...
20763,9510.260qhuda3t93088 JDBC Thin Client SELECT * FROM tests WHERE url ...
20650,3190.26ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
2052,1440.26bsa0wjtftg3uw   select file# from file$ where ...
20593,4010.26ckr1vbptqjnd1 JDBC Thin Client SELECT mediaID FROM mediaconsu...
20450,3190.267cbf1umqgg15a JDBC Thin Client SELECT mediaID, overrideHeight...
20322,7750.268fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO SQL IdSQL ModuleSQL Text
258.29187,29512.233,970.456.5113.3071.350wmqqks6usuu5 JDBC Thin Client UPDATE attemptdata SET itemsco...
149.53112,9027.081,555.979.6112.5579.149j5trt70jc4r8 JDBC Thin Client UPDATE attempt SET params = :1...
133.23248,2466.313,037.774.3912.4862.386fp93dkgc917v JDBC Thin Client UPDATE attemptdata set ITEMSCO...
71.51135,8913.39150.3247.5741.140.293jwu317rq41wn JDBC Thin Client SELECT * FROM attempt WHERE te...
43.5288,5262.06162.6526.7656.740.60aa9yh7rqc9nar JDBC Thin Client SELECT * FROM attemptdata WHER...
30.45981.44256.6411.8715.5275.420m483bapqc9n3 JDBC Thin Client SELECT datasize, data FROM med...
28.5022,5581.35263.8610.8014.6975.99gs68f01qx915k JDBC Thin Client UPDATE attempt set SUBMISSIONI...
25.8122,4941.22160.8716.0578.190.20b2qv4nq67cczh JDBC Thin Client SELECT * FROM attemptdata WHER...
21.2171.0039.1254.2144.592.477f70vfs8vfj68 JDBC Thin Client SELECT mediaID, mediatype, dat...
17.081020.81149.0211.4625.3461.79aa4maxrz4511z JDBC Thin Client INSERT INTO uploads (uploadID,...
14.5550,3190.6944.5032.7147.810.01ff1nrgm5dnjrb JDBC Thin Client SELECT datasize, mediatype, da...
9.478700.4534.6127.3719.8956.20d86bg3hw9p7nq JDBC Thin Client INSERT INTO attemptdata (attem...
7.028700.3346.7415.0219.8467.236mj44b33a0xws JDBC Thin Client INSERT INTO attempt (attempt_p...
2.6622,7750.137.0437.8332.940.008fttd5fgbsx2y JDBC Thin Client SELECT * FROM attempt WHERE te...
2.239,2540.115.6239.7172.927.36g00cj285jmgsw   update sys.mon_mods$ set inser...
1.751,8560.086.3727.3867.540.229dd5xusnyg10n JDBC Thin Client SELECT * FROM attemptdata WHER...
0.878030.048.959.6964.1123.279tdph9wa5jnbh JDBC Thin Client select q.questionID, q.format,...
0.1810.012.158.5875.8613.236ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.168030.010.9017.5628.8434.74bjrsu1sf38nx2 JDBC Thin Client SELECT g.groupID, gm.name, g.e...
0.12369,5900.0122.010.5528.200.01d4tasbthp4r6z JDBC Thin Client SELECT * FROM medialookaside W...
0.11135,8960.0133.890.3331.281.5856z638s8sdpv0 JDBC Thin Client SELECT * FROM tests WHERE test...
0.07230.000.1065.6728.169.809wncfacx0nj9h   insert into smon_scn_time (thr...
0.07160.005.901.1098.600.2053qg5xxgv1jxm JDBC Thin Client SELECT medialookaside.* FROM m...
0.0530.000.3911.6419.4674.3547mm81hm9sggy   SELECT sum(case when a.sessio...
0.0310.000.1818.9876.514.917qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
0.032,5200.000.476.5122.4634.456b9n2bk019yv6 JDBC Thin Client SELECT questionID from groupme...
0.02530.000.0532.2765.100.070kkhhb2w93cx0   update seg$ set type#=:4, bloc...
0.0220.000.0918.6886.170.015h91zx386wbht   WITH awr_params as ( SELECT /*...
0.01140,2350.0018.640.0725.540.009z1yfsqr77brw JDBC Thin Client SELECT indexID FROM tests WHER...
0.01110.000.353.7489.750.003wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
0.0120.000.148.7791.503.446cp74g22fzahf   WITH ash as (SELECT ash.event...
0.0110.000.0522.7480.070.00bsvzkk7xc8dd9   SELECT sum(blk_read) as blk_r...
0.0110.000.0521.0183.060.00cd1dfrzuta22f   WITH awr_params as ( SELECT /*...
0.01479,5120.0047.810.0229.570.01dgtyz938v4s3q JDBC Thin Client SELECT EZTO_SEQUENCE.nextval F...
0.0120.000.0611.8488.000.005dyhfnkzta2zm   WITH awr_evts as (SELECT e.eve...
0.0110.000.0710.5987.400.0074g6ka8ncc1jb   WITH ash as (SELECT ash.event...
0.0110.000.0323.8663.310.00a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
0.0110.000.0227.9280.850.001p36ta7p3d7fu   select file#, block#, ts#, blo...
0.0130.000.0230.7381.570.00317v5hnvvd49h   UPDATE wrh$_seg_stat_obj ob S...
0.0110.000.0318.6688.380.007yjzq240hcd2c   UPDATE /*+ INDEX(wrh$_seg_sta...
0.0110.003.140.162.9996.69350myuyx0t1d6   insert into wrh$_tablespace_st...

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)
1p36ta7p3d7fuselect file#, block#, ts#, blocks from seg$ where type# = 3
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
350myuyx0t1d6insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3jwu317rq41wnSELECT * FROM attempt WHERE testid=:1 AND sectionid=:2 AND activityid=:3 AND userid=:4 AND attemptno=:5 AND submissionid IS NULL
3wrrjm9qtr2mySELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL(JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
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
5dyhfnkzta2zmWITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_instance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
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
74g6ka8ncc1jb WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
76nzpvfmj776gSELECT questionID, data FROM fullcredit WHERE testID=:1
7cbf1umqgg15aSELECT mediaID, overrideHeight, overrideWidth FROM mediaconsumers WHERE testID=:1 AND lower(name)=:2
7f70vfs8vfj68SELECT mediaID, mediatype, datasize FROM media WHERE datasize > :1 AND block=0
7jkvzr8ar6j6gSELECT name FROM mediaconsumers WHERE testID=:1 AND consumerID=:2
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
7yjzq240hcd2c UPDATE /*+ INDEX(wrh$_seg_stat_obj wrh$_seg_stat_obj_index) */ 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 :lah_snap_id, 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, 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 snap_id > :lah_snap_id - 10 AND (object_name LIKE '%UNAVAIL%' OR (object_type LIKE '%UNDEF%' AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%') OR owner LIKE '%UNAVAIL%' OR tablespace_name LIKE '%UNAVAIL%')
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
a5mmhrrnpwjscSELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
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
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bsvzkk7xc8dd9 SELECT sum(blk_read) as blk_read, sum(read_time) as read_time, sum(blk_write) as blk_write, sum(write_time) as write_time, sum(tot_reads) as reads, sum(tot_writes) as writes, sum(sb_reads) as sreads, sum(sb_read_time) as srds_time, count(*) as total_files, block_size FROM ( SELECT df.block_size as block_size, df.filename as file_name, 0 as is_temp, df.ts# as ts#, fs.* FROM ( SELECT endsn.file# as file#, endsn.creation_change# as creation_change#, sum(endsn.phyblkrd - nvl(startsn.phyblkrd, 0)) as blk_read, sum(endsn.phyblkwrt - nvl(startsn.phyblkwrt, 0)) as blk_write, sum(endsn.readtim - nvl(startsn.readtim, 0)) * 10000 as read_time, sum(endsn.writetim - nvl(startsn.writetim, 0)) * 10000 as write_time, sum(endsn.phyrds - nvl(startsn.phyrds, 0)) as tot_reads, sum(endsn.phywrts - nvl(startsn.phywrts, 0)) as tot_writes, sum(endsn.singleblkrds - nvl(startsn.singleblkrds, 0)) as sb_reads, sum(endsn.singleblkrdtim - nvl(startsn.singleblkrdtim, 0)) * 10000 as sb_read_time FROM WRH$_FILESTATXS endsn, WRH$_FILESTATXS startsn WHERE startsn.file#(+) = endsn.file# AND startsn.creation_change#(+) = endsn.creation_change# AND startsn.phyblkrd(+) < endsn.phyblkrd AND endsn.dbid = :dbid AND endsn.snap_id = :eid AND startsn.dbid(+) = :dbid AND startsn.instance_number(+) = endsn.instance_number AND startsn.snap_id(+) = :bid GROUP BY endsn.file#, endsn.creation_change# ) fs, WRH$_DATAFILE df WHERE df.dbid = :dbid AND fs.file# = df.file# AND fs.creation_change# = df.creation_change# ) group by block_size order by block_size
cd1dfrzuta22fWITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
ckr1vbptqjnd1SELECT mediaID FROM mediaconsumers WHERE testID=:1
d024vwxkhahjcSELECT title, managers, participants, computers, oemID, creation, modified, owner FROM indices WHERE indexID=:1
d1fduptwha0n9SELECT mediatype FROM media WHERE mediaID=:1 AND block=0
d4tasbthp4r6zSELECT * FROM medialookaside WHERE mediaID=:1
d86bg3hw9p7nqINSERT INTO attemptdata (attemptdata_pk, attempt_pk, testid, sectionid, activityid, attemptno, userid, questionid, itemscore, params, maxpoints, formulaanswer, recordedvalue, followup, feedback, html, instructorcomment, createdtime, userresponse) VALUES( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 )
dgtyz938v4s3qSELECT EZTO_SEQUENCE.nextval FROM dual
dkmdukk4xfrsqSELECT mediatype, datasize FROM media WHERE mediaID= :1 AND ROWNUM <=1 ORDER BY block
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
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 cleanout58,8325.460.37
application wait time950.010.00
background checkpoints completed30.000.00
background checkpoints started30.000.00
background timeouts102,4479.510.64
Batched IO block miss count1060.010.00
Batched IO (bound) vector count20.000.00
Batched IO buffer defrag count30.000.00
Batched IO double miss count280.000.00
Batched IO (full) vector count00.000.00
Batched IO same unit count200.000.00
Batched IO single block count20.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count820.010.00
Batched IO vector read count100.000.00
Block Cleanout Optim referenced5,4230.500.03
branch node splits540.010.00
buffer is not pinned count36,618,8323,400.32230.17
buffer is pinned count11,143,6601,034.7770.04
bytes received via SQL*Net from client11,541,797,4961,071,737.3272,546.58
bytes sent via SQL*Net to client9,259,310,839859,792.3358,199.89
bytes via SQL*Net vector to client569,726,01452,903.083,581.04
Cached Commit SCN referenced733,69168.134.61
calls to get snapshot scn: kcmgss60,512,1905,618.98380.35
calls to kcmgas8,865,452823.2255.72
calls to kcmgcs10,860,9371,008.5168.27
CCursor + sql area evicted00.000.00
cell physical IO interconnect bytes118,438,320,12810,997,833.56744,450.30
change write time20,6501.920.13
cleanout - number of ktugct calls80,9817.520.51
cleanouts and rollbacks - consistent read gets2,7780.260.02
cleanouts only - consistent read gets246,10822.851.55
cluster key scan block gets2,1360.200.01
cluster key scans1,5280.140.01
cluster wait time211,20319.611.33
commit batch/immediate performed1,8270.170.01
commit batch/immediate requested1,8270.170.01
commit cleanout failures: block lost1,2150.110.01
commit cleanout failures: buffer being written70.000.00
commit cleanout failures: callback failure6,1510.570.04
commit cleanout failures: cannot pin210.000.00
commit cleanouts1,021,40294.846.42
commit cleanouts successfully completed1,014,00894.166.37
commit immediate performed1,8270.170.01
commit immediate requested1,8270.170.01
Commit SCN cached61,2385.690.38
commit txn count during cleanout191,32517.771.20
concurrency wait time132,42912.300.83
consistent changes505,85346.973.18
consistent gets44,021,6814,087.72276.70
consistent gets - examination19,693,3931,828.67123.78
consistent gets direct7820.070.00
consistent gets from cache44,020,8994,087.65276.70
consistent gets from cache (fastpath)20,349,7901,889.62127.91
CPU used by this session2,297,405213.3314.44
CPU used when call started230,71821.421.45
CR blocks created494,21045.893.11
cursor authentications1600.010.00
data blocks consistent reads - undo records applied3,6970.340.02
db block changes13,555,5681,258.7385.20
db block gets791,996,48473,542.464,978.14
db block gets direct1670.020.00
db block gets from cache791,996,34673,542.454,978.13
db block gets from cache (fastpath)1,330,677123.568.36
DB time1,445,575134.239.09
DBWR checkpoint buffers written843,83678.365.30
DBWR checkpoints500.000.00
DBWR fusion writes279,09925.921.75
DBWR transaction table writes77,4797.190.49
DBWR undo block writes174,22416.181.10
deferred (CURRENT) block cleanout applications465,37043.212.93
DFO trees parallelized360.000.00
dirty buffers inspected93,4458.680.59
Effective IO time488,84845.393.07
enqueue conversions7,694,486714.4948.36
enqueue releases18,832,0921,748.69118.37
enqueue requests19,066,4011,770.45119.84
enqueue timeouts234,30521.761.47
enqueue waits828,05676.895.20
exchange deadlocks390.000.00
execute count3,866,410359.0224.30
file io wait time10,103,428,638938,174.6363,505.63
flashback cache read optimizations for block new37,8813.520.24
flashback direct read optimizations for block new30.000.00
flashback log write bytes10,219,233,280948,927.9064,233.53
flashback log writes47,3274.390.30
free buffer inspected4,523,751420.0628.43
free buffer requested7,691,089714.1748.34
gc blocks compressed2,504,869232.5915.74
gc cr block flush time1,5620.150.01
gc cr block receive time40,1273.730.25
gc cr blocks received1,127,018104.657.08
gc cr blocks served1,101,036102.246.92
gc current block flush time20,8431.940.13
gc current block pin time4,2540.400.03
gc current block receive time87,0178.080.55
gc current blocks received2,100,229195.0213.20
gc current blocks served2,230,131207.0814.02
gc kbytes saved10,266,701953.3464.53
gc kbytes sent16,382,6291,521.24102.97
gc local grants1,009,90793.786.35
gc read wait time30.000.00
gc read waits40.000.00
gc reader bypass grants8,3110.770.05
gc remote grants3,210,268298.1020.18
gcs messages sent15,264,4131,417.4195.95
ges messages sent1,928,813179.1012.12
global enqueue get time81,0677.530.51
global enqueue gets async4,1440.380.03
global enqueue gets sync6,111,582567.5038.41
global enqueue releases3,332,126309.4120.94
heap block compress153,15414.220.96
Heap Segment Array Inserts3500.030.00
Heap Segment Array Updates3120.030.00
hot buffers moved to head of LRU500,32746.463.14
HSC Heap Segment Block Changes1,921,689178.4412.08
immediate (CR) block cleanout applications248,89223.111.56
immediate (CURRENT) block cleanout applications23,6552.200.15
in call idle wait time62,863,2285,837.29395.13
index crx upgrade (positioned)1790.020.00
index crx upgrade (prefetch)130.000.00
index fast full scans (full)90.000.00
index fetch by key941,21687.405.92
index scans kdiixs13,175,292294.8519.96
leaf node splits8,8660.820.06
leaf node 90-10 splits4900.050.00
lob reads9,3680.870.06
lob writes1370.010.00
lob writes unaligned1370.010.00
logical read bytes from cache6,848,654,049,280635,945,843.2843,047,575.66
logons cumulative2640.020.00
max cf enq hold time6300.060.00
messages received22,072,6772,049.60138.74
messages sent22,072,6772,049.60138.74
min active SCN optimization applied on CR9450.090.01
no buffer to keep pinned count5,2540.490.03
no work - consistent read gets13,085,1041,215.0482.25
non-idle wait count59,254,0815,502.16372.44
non-idle wait time1,700,712157.9210.69
Number of read IOs issued7820.070.00
opened cursors cumulative1,517,164140.889.54
Parallel operations not downgraded360.000.00
parse count (describe)800.010.00
parse count (hard)3420.030.00
parse count (total)78,7927.320.50
parse time cpu2,6020.240.02
parse time elapsed13,9841.300.09
physical read bytes29,131,071,4882,705,025.50183,104.88
physical read IO requests3,328,290309.0620.92
physical read total bytes41,549,897,7283,858,201.12261,164.07
physical read total IO requests3,395,025315.2521.34
physical read total multi block requests11,1001.030.07
physical reads3,556,038330.2022.35
physical reads cache3,551,375329.7722.32
physical reads cache prefetch229,03621.271.44
physical reads direct4,6640.430.03
physical reads direct (lob)7820.070.00
physical reads direct temporary tablespace00.000.00
physical reads for flashback new1,647,212152.9610.35
physical reads prefetch warmup6,3330.590.04
physical write bytes16,806,346,7521,560,587.86105,637.18
physical write IO requests982,50391.236.18
physical write total bytes76,888,422,4007,139,632.44483,286.23
physical write total IO requests2,533,462235.2515.92
physical write total multi block requests92,8308.620.58
physical writes2,051,556190.5012.90
physical writes direct9630.090.01
physical writes direct temporary tablespace00.000.00
physical writes from cache2,050,593190.4112.89
physical writes non checkpoint1,873,882174.0011.78
pinned buffers inspected7260.070.00
pinned cursors current2,2760.210.01
prefetch clients - default10.000.00
prefetch warmup blocks aged out before use10,3430.960.07
prefetched blocks aged out before use240.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'd4560.040.00
PX remote messages sent4560.040.00
queries parallelized360.000.00
recursive calls2,070,629192.2713.02
recursive cpu usage19,7671.840.12
redo blocks checksummed by FG (exclusive)22,788,1092,116.04143.24
redo blocks written28,746,1582,669.28180.69
redo buffer allocation retries100.000.00
redo entries10,631,607987.2266.83
redo KB read11,229,9831,042.7870.59
redo log space requests120.000.00
redo log space wait time470.000.00
redo ordering marks1,433,769133.149.01
redo size14,055,917,7921,305,191.1388,349.21
redo size for direct writes1,374,164127.608.64
redo subscn max counts316,22229.361.99
redo synch long waits15,7041.460.10
redo synch time38,8503.610.24
redo synch time (usec)388,569,38736,081.412,442.37
redo synch writes159,16214.781.00
redo wastage195,800,94018,181.501,230.72
redo write broadcast ack count4,1900.390.03
redo write broadcast ack time3,142,684291.8219.75
redo write broadcast lgwr post count10.000.00
redo write time107,67110.000.68
redo writes657,96361.104.14
remote Oradebug requests00.000.00
Requests to/from client4,774,379443.3330.01
rollback changes - undo records applied3400.030.00
rollbacks only - consistent read gets820.010.00
RowCR - row contention3360.030.00
RowCR attempts23,9002.220.15
RowCR hits23,5572.190.15
rows fetched via callback11,150,3841,035.3970.09
securefile allocation bytes12,170,240,0001,130,092.6476,496.68
securefile allocation chunks749,57769.604.71
securefile bytes non-transformed10,504,106,214975,380.3666,024.11
securefile number of non-transformed flushes327,19530.382.06
segment cfs allocations14,1281.310.09
segment chunks allocation from disepnser712,29866.144.48
segment dispenser allocations312,45529.011.96
segment dispenser load tasks5,6280.520.04
segment prealloc bytes3,502,243,840325,208.0522,013.54
segment prealloc ops104,2489.680.66
segment prealloc tasks95,8538.900.60
segment prealloc time (ms)21,510,9551,997.44135.21
segment prealloc ufs2cfs bytes3,095,527,424287,441.5619,457.10
segment total chunk allocation13,5501.260.09
session connect time00.000.00
session cursor cache hits1,563,983145.239.83
session logical reads836,015,85477,629.975,254.82
shared hash latch upgrades - no wait226,47221.031.42
shared hash latch upgrades - wait10.000.00
SMON posted for undo segment shrink3110.030.00
sorts (memory)119,47011.090.75
sorts (rows)293,41227.251.84
sql area evicted00.000.00
sql area purged00.000.00
SQL*Net roundtrips to/from client4,774,444443.3430.01
summed dirty queue length1,707,768158.5810.73
switch current to new buffer8,3680.780.05
table fetch by rowid21,213,9411,969.86133.34
table fetch continued row62,0065.760.39
table scan blocks gotten37,6833.500.24
table scan rows gotten997,52992.636.27
table scans (short tables)3,3840.310.02
total cf enq hold time18,9101.760.12
total number of cf enq holders8050.070.01
total number of times SMON posted161,09214.961.01
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks1,8260.170.01
undo change vector size1,145,330,680106,352.037,199.04
user calls6,023,672559.3437.86
user commits159,09514.771.00
user I/O wait time857,95179.675.39
user rollbacks00.000.00
workarea executions - optimal116,43510.810.73
write clones created in background920.010.00
write clones created in foreground140.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory38,773,677,08094,746,184,432
opened cursors current6304,146
logons current325337
session uga memory max2,476,473,5842,718,660,080
session pga memory768,648,8002,046,641,712
session pga memory max807,283,6162,232,404,848
session cursor cache count5,6588,923

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.921.0955228.5G8.082.71384113.4K1.19
LGWR1M0.01.00009227.4G135.952.60705658.1K1.10
Buffer Cache Reads27.1G308.632.576310M0.000M3322.4K2.22
DBWR46M0.27.00427115.6G91.051.4861729540.06
Direct Reads37M0.42.0034354M0.05.0003710 
Direct Writes0M0.000M2M0.03.0001850 
TOTAL:38.7G315.253.6796471.6G235.166.807624096.9K2.01

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 File27.1G309.122.5814215.7G91.171.489892.2212.85
Log File11.3G1.081.0712927.4G135.992.607982.980.00
Flashback Log0M0.000M17.5G5.161.666043.75 
Archive Log0M0.000M11.3G1.071.07064  
Control File876M5.14.081342322M1.92.0298990.279.39
TOTAL:39.3G315.343.7340672.2G235.306.864452.190.14

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others 12.1G5.981.1534729.1G8.142.77076108.4K1.22
Others (Flashback Log) 0M0.000M17.5G5.161.6660455.6K2.07
Others (Log File) 11.3G1.081.076210M0.000M292.21
Others (Archive Log) 0M0.000M11.3G1.081.074910 
Others (Control File) 829M4.86.076978320M1.90.02971452.4K0.28
Others (Data File) 3M0.04.0002781M0.00.0000923987.16
LGWR 1M0.01.00009227.4G136.012.608441002.26
LGWR (Log File) 0M0.000M27.4G135.992.60826323.69
LGWR (Control File) 1M0.01.0000922M0.01.000185681.59
Buffer Cache Reads 27.1G308.772.577430M0.000M3323.9K2.23
Buffer Cache Reads (Data File) 27.1G308.772.577430M0.000M3323.9K2.23
DBWR 0M0.000M15.6G91.131.487570 
DBWR (Data File) 0M0.000M15.6G91.131.487570 
Direct Reads 37M0.42.0034354M0.05.0003710 
Direct Reads (Data File) 37M0.42.0034354M0.05.0003710 
Direct Writes 0M0.000M2M0.03.0001850 
Direct Writes (Data File) 0M0.000M2M0.03.0001850 
TOTAL: 39.3G315.183.7344372.2G235.356.867333432.4K2.20

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 3,110,1952892.471.07730,091686771.26
UNDOTBS4 153,757142.511.0093,51096,7553.34
EZTO_DATA 46,42348.221.0982,885830.00
EZTO_INDEX 16,45827.821.0572,94271101.18
SYSAUX 86904.641.241,083000.00
SYSTEM 2608.081.00194050.00
EZTO_LOB_MANUAL 8200.001.0018000.00
UNDOTBS2 2300.001.00801,7445.07
UNDOTBS1 200.001.00202,1784.40
UNDOTBS3 200.001.00201,0256.56
USERS 200.001.002000.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 8205.241.2721000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.316.813959497 8106.671.4323000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.321.813959571 10605.191.3311000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.325.813959657 7701.951.167000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.328.813959053 4506.671.0072000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.329.813959089 6506.001.129000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.333.813958673 43607.641.00609000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.334.813958733 73907.601.041,076000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.335.813958789 1,10708.011.091,879030.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.336.813958889 1,20607.891.151,881000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.337.813958923 77508.091.091,089000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.338.813958979 11607.841.00267000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.339.813958337 62807.661.07947000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.340.813958291 40407.251.00846000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.341.813958195 50308.071.05957000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.342.813958141 32507.911.08803000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.343.813958113 77507.871.061,640000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.344.813958015 3,28508.461.065,846100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.345.813957977 7,52018.261.1212,342100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.346.813957901 7,88318.091.0811,746100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.347.813957523 3,06408.041.125,007000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.348.813957523 1,24907.871.151,830000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.349.813957399 37407.461.00458000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.350.813957319 6307.781.70103000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.351.813957275 5807.411.0070000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.352.813957085 1200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.353.813957085 1200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.358.813956627 1400.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.359.813956627 1400.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.360.813956509 1400.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.361.813956439 1400.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.428.813950183 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.429.813950069 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.430.813950033 1000.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.431.813949977 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.432.813949915 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.433.813949901 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.434.813949567 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.435.813949541 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.436.813949465 1100.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.437.813949341 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.438.813949153 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.439.813949117 7506.271.002,246000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.440.813949055 900.001.0044000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.441.813948941 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.442.813948925 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.443.813948855 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.444.813948839 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.445.813948805 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.446.813948513 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.447.813948511 900.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.581.813930683 200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.582.813930683 200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.584.813930683 200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.611.813964757 3705.411.4147000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.612.813964829 91807.781.051,911000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.617.813965575 10,18218.901.0721,973200.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.619.813965599 3,38508.861.086,353100.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.620.813965653 22308.481.06458000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.621.813965689 16009.381.14214000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.622.813965729 1602.501.003000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.623.813965743 2203.641.593000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.624.813965799 4400.681.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.634.813966737 1703.531.004000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.636.813966819 1302.311.007000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.637.813967121 2304.781.618000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.638.813967189 904.441.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.639.813967493 1002.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.640.813967621 1304.621.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.680.813970465 1200.001.002000.00
EZTO_DATA+EZTOPQA_DF/eztopqa_va/datafile/ezto_data.683.813970633 2605.001.0011000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.298.813959857 11107.751.08350000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.299.813960597 30507.481.113,796030.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.302.813959711 5806.551.0055000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.303.813959883 3505.431.0092000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.305.813959771 6607.731.2194000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.306.813960601 94507.591.015,460180.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.315.813960647 1,05107.441.084,553080.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.317.813960159 7907.851.0095000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.318.813960243 8508.241.00109000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.319.813960269 2205.911.0022000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.320.813960377 2,36305.271.027,820150.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.322.813960701 88807.981.165,481152.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.323.813960703 11707.861.002,678000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.326.813960441 30207.751.082,200020.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.331.813960573 93806.971.076,461100.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.427.813950305 3308.181.0050000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.583.813930683 1208.331.0037000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.585.813930683 2508.001.0050000.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.586.813930683 3,20809.161.069,8231301.00
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.587.813930683 1,50708.741.048,1901174.12
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.588.813930683 80008.931.033,8780120.83
EZTO_INDEX+EZTOPQA_DF/eztopqa_va/datafile/ezto_index.649.813967997 3,50808.131.0411,6481200.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.277.813963385 78407.591.11880090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.278.813963293 6,36011.561.008640142.14
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.279.813963217 19,77120.911.00798050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.280.813963173 49,08150.811.008970152.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.281.813963093 37,15530.881.00643030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.282.813962941 20,96120.941.00773090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.283.813962937 17,13020.931.00539091.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.284.813962933 1,26301.812.54503020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.285.813962919 4,62501.451.76965000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.286.813962777 4,54402.021.347420102.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.287.813961529 9,32711.121.12921050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.307.813961503 93701.711.18173000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.308.813961481 1,69801.381.50232070.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.309.813961455 1,50401.762.51465020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.310.813961447 86601.401.94173000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.311.813961441 38701.862.3991000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.312.813961361 32202.673.81134000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.313.813961275 28201.913.84136000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.314.813961143 72601.973.94360000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.327.813961001 72401.953.91356000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.330.813961111 20401.423.6994000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.332.813960835 15601.923.6871000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.354.813957039 3,29902.793.933000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.355.813956965 73803.413.903000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.356.813956921 1,45803.163.936000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.357.813956683 2,12003.823.945000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.362.813956257 5906.441.00150010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.363.813956255 5807.071.00100000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.364.813956085 6306.351.00110000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.365.813956051 4106.591.0045000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.366.813956021 4307.911.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.367.813955945 7307.811.0075000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.368.813955909 5008.801.0037000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.372.813963441 1,12404.471.00773042.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.374.813955661 23002.521.0040000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.375.813955617 4408.861.0033000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.376.813955601 5806.551.0045000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.377.813955491 5007.401.0039000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.378.813955445 4306.051.0032000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.379.813955209 6209.031.0073000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.380.813955209 4507.111.0029000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.381.813955073 8107.041.0099000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.382.813955049 5606.791.0039000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.383.813955033 4,79700.921.0060010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.384.813955005 4,88200.911.00172000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.385.813954953 4,33400.771.00112000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.386.813954697 3,58600.931.0091025.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.387.813954641 8,49710.831.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.388.813954551 7,03910.831.0082000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.389.813954459 4,98800.891.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.390.813954401 6,10610.821.0053010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.391.813954053 4,85300.801.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.392.813953999 10,29410.851.0038000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.393.813953881 5,04900.931.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.394.813953847 1601.251.0017000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.395.813953839 1200.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.396.813953803 47701.781.0093000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.397.813953755 1300.771.0014000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.398.813953409 38801.311.0082000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.399.813953343 26801.941.0089000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.400.813953257 66601.311.00109000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.401.813953157 26000.881.004000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.402.813953077 58901.441.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.403.813952647 6407.661.0061000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.404.813952647 4606.741.00100000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.405.813952521 66501.491.0096000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.406.813952521 53201.841.00184020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.407.813952487 70401.461.0089000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.408.813952435 5806.381.0051000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.409.813952381 73801.591.0071000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.410.813952043 67301.561.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.411.813952007 1,19401.211.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.412.813951931 1,13701.381.0087010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.413.813951819 1,72900.951.0067000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.414.813951723 77001.061.0094000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.415.813951297 1,55500.921.0042000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.416.813951283 98000.981.00141000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.417.813951223 1,44100.871.0091010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.418.813951177 1,85801.071.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.419.813951135 61301.891.0099000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.420.813951051 28002.141.0072000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.421.813951025 96301.171.00137000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.422.813950699 7607.761.00153000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.423.813950673 1,12301.341.00139000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.424.813950607 39001.921.0094010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.425.813950455 1,19901.231.0095000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.426.813950379 31901.471.0054000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.448.813948277 65901.461.0070000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.449.813948187 26801.871.0062010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.450.813947987 98400.951.0056000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.451.813947979 5206.731.00100010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.452.813947939 44501.391.0084000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.453.813947873 4108.051.00106000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.454.813947825 43101.321.00112000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.455.813947707 72401.511.0063000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.456.813947691 45302.141.00123000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.457.813947691 35703.141.0081000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.458.813947407 12105.871.00151000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.459.813947383 49101.771.00153000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.460.813947197 8908.201.00115000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.461.813947061 9408.401.00129000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.462.813946815 31302.491.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.463.813946815 6907.831.00100000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.464.813946763 71201.241.0062000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.465.813946683 50202.351.00136000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.466.813946639 9207.171.00103000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.467.813946501 99101.531.00104000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.468.813946487 22703.881.00105000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.469.813946471 6208.871.0087000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.470.813946199 45902.481.0078000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.471.813946119 86301.341.0057000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.472.813945975 25903.441.0096000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.473.813945845 24703.121.0092000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.474.813945809 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.475.813945777 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.476.813945753 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.477.813945677 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.478.813945635 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.479.813945499 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.480.813945463 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.481.813945463 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.482.813945201 700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.483.813945089 3002.331.0011000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.484.813944999 3,00704.271.001,157000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.485.813944841 1,02004.591.00401000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.486.813944825 6,43514.021.002,542000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.487.813944759 12,82714.201.005,009000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.488.813944759 20,43124.381.007,872100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.489.813944681 29,43834.191.0011,948100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.490.813944637 29,64234.191.0011,618100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.491.813944501 27,86234.411.0011,776100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.492.813944451 25,26024.591.0010,746100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.493.813944435 23,66424.651.0010,257100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.494.813944189 16,73824.841.007,331100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.495.813944045 16,71524.511.006,646100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.496.813943995 41,69642.011.005,878100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.497.813943829 58,75951.701.006,838120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.498.813943801 71,01071.651.007,938120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.499.813943745 72,58871.871.009,530150.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.500.813943711 127,558121.731.0013,479120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.501.813943681 98,09492.031.0014,138120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.502.813943651 107,686102.131.0016,397220.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.503.813943507 67,52662.451.0012,105130.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.504.813943451 104,723103.131.0031,989320.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.505.813943405 83,51285.031.0048,087420.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.506.813943213 59,42965.631.0038,229410.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.507.813943029 51,21556.281.0035,6183110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.508.813943027 39,01446.541.0029,012310.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.509.813942881 32,50236.311.0023,154210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.510.813942815 24,09726.961.0019,217210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.511.813942745 27,98936.791.0021,537210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.512.813942737 19,95427.161.0016,420210.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.513.813942723 15,81717.201.0013,188110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.514.813942707 11,35517.021.009,188110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.515.813942561 12,87517.001.0010,746110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.516.813942347 9,69917.101.008,043110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.517.813942313 9,45517.091.007,781110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.518.813942081 19,00323.441.006,7501130.77
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.519.813941969 6,19517.031.005,062010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.520.813941903 18,44823.571.006,753190.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.521.813941733 14,30414.091.006,1261120.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.522.813941663 14,37813.791.005,9711120.83
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.523.813941609 16,63223.131.005,344090.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.524.813941583 27,31132.111.004,640050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.525.813941581 21,19622.511.004,6150120.83
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.526.813941565 18,66422.591.004,612060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.527.813941431 30,94731.821.014,2930102.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.528.813941165 40,93941.481.013,7620142.86
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.529.813940979 24,41721.931.023,704060.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.530.813940819 22,30121.941.023,416030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.531.813940811 43,74441.481.013,8290132.31
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.532.813940607 78,58971.101.003,2350140.71
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.533.813940523 55,59651.191.012,8420113.64
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.534.813940481 18,31721.871.032,748050.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.535.813940463 11,29512.431.072,644081.25
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.536.813940437 14,40711.891.052,643010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.537.813940423 23,39221.561.032,546030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.538.813940279 14,97211.821.032,228091.11
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.539.813940047 5,05003.561.082,029010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.540.813939721 5,03603.381.081,997025.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.541.813939403 32,01131.221.017,6291100.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.542.813939387 1,00003.063.88104000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.543.813939261 98,27990.891.0013,2511540.74
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.544.813939237 80,27070.941.0010,3311712.82
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.545.813938401 2,79105.621.001,810000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.546.813938341 121,016110.881.0014,2161441.14
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.547.813938325 43403.273.9110000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.548.813938319 56,79150.921.0118,4942302.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.549.813938303 2,61107.151.001,956020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.550.813938207 132,082120.691.009,356140.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.551.813938191 1,95203.253.9535000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.552.813938079 1,80003.173.9522000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.553.813937743 1,10202.293.9491000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.554.813937633 1,30702.693.957000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.555.813937633 89903.073.935000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.556.813937587 1,51302.243.94134000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.557.813935445 2,17702.143.95525000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.558.813935373 2,00102.203.95570000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.559.813935373 1,81202.483.942000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.560.813935373 92703.073.923000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.561.813935197 68103.323.932000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.562.813935181 2,54102.713.973000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.563.813935181 1,55403.023.944000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.564.813935135 2,67702.173.933000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.565.813934533 2,29202.593.9670000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.566.813934531 2,68402.843.947000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.567.813934505 3,04202.353.95583000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.568.813934439 1,90102.693.955000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.569.813932221 1,96602.503.962000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.570.813932219 2,77202.413.954000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.571.813932195 1,73202.583.953000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.572.813932077 1,79502.403.942000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.573.813932061 1,29802.843.944000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.574.813932053 3,10402.363.95136000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.575.813932007 3,33602.073.95530000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.576.813931931 1,54502.963.952000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.577.813931235 1,46903.103.9313000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.578.813931235 72702.893.962000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.579.813931233 1,36303.073.954000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.580.813931231 2,93102.463.968000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.602.813963443 1,52303.821.011,0070110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.603.813964375 1,62103.561.01695020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.604.813964415 2,01904.051.001,342080.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.605.813964431 2,39803.041.001,219040.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.606.813964501 7,92211.311.00891030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.607.813964515 10,62611.221.001,0720130.77
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.608.813964517 1,72102.951.006280102.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.609.813964531 9,95911.211.001,0720131.54
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.610.813964633 10,82111.221.00965036.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.613.813964829 7,44111.601.00985033.33
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.614.813964989 7,42211.511.001,0800191.58
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.615.813965537 12,85011.291.001,0140300.67
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.616.813965541 15,87811.121.001,061042.50
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.618.813965583 2,26902.721.02682030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.625.813965939 58806.621.00502010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.626.813966075 85804.361.00733010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.627.813966441 3,05502.001.00820030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.628.813966465 63906.041.005200110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.629.813966547 3,07602.041.005210110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.630.813966601 1,07603.281.00575030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.631.813966673 3,37501.721.00567000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.632.813966679 6,61711.171.00612000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.633.813966697 16,14711.181.00571020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.635.813966761 24,46020.911.00455020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.641.813967621 3,33701.491.00487000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.642.813967681 8,60811.111.00529010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.643.813967757 7,58711.371.00721020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.644.813967757 10,48710.951.00481010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.645.813967767 11,59511.011.00417000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.646.813967769 15,23010.931.00300010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.647.813967891 6,07711.101.00480030.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.648.813967981 3,96101.291.00443000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.650.813968021 6,79911.071.00424010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.651.813968357 4,37501.291.00300000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.652.813968501 4,93601.401.00699000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.653.813968795 7,86211.121.00385000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.654.813968829 4,66101.421.00354000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.655.813968865 4,60301.441.00479000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.656.813968891 6,68011.231.00487000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.657.813968899 4,89101.461.00453000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.658.813968943 3,86001.051.00156000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.659.813968967 3,00802.181.00615020.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.660.813969061 2,60904.321.011,2270110.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.661.813969097 6,60312.531.001,807010.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.662.813969097 8,12912.491.001,767000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.663.813969469 13,76612.211.002,391000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.664.813969661 7,40313.701.002,777000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.665.813969945 6,09114.491.002,918000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.666.813970041 4800.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.667.813970041 1000.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.668.813970107 1000.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.669.813970169 7400.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.670.813970171 42500.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.671.813970175 13700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.672.813970209 7300.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.673.813970237 1700.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.674.813970385 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.675.813970409 7300.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.676.813970427 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.677.813970429 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.678.813970435 900.001.002000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.679.813970463 5,66015.581.003,319000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.681.813970561 5,93516.941.004,743000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.682.813970589 9708.251.0085000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.684.813970649 6,23517.171.004,977000.00
EZTO_LOB+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob.713.816189311 900.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.685.813970653 200.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.686.813970653 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.687.813970889 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.688.813971075 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.689.813971145 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.693.813971299 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.696.813971335 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.698.813971447 1000.001.002000.00
EZTO_LOB_MANUAL+EZTOPQA_DF/eztopqa_va/datafile/ezto_lob_manual.699.813971519 1000.001.002000.00
SYSAUX+EZTOPQA_DF/eztopqa_va/datafile/sysaux.697.813971341 86904.641.241,083000.00
SYSTEM+EZTOPQA_DF/eztopqa_va/datafile/system.694.813971299 2608.081.00194050.00
UNDOTBS1+EZTOPQA_DF/eztopqa_va/datafile/undotbs1.690.813971153 200.001.00202,1784.40
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.589.813930683 700.001.002020.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.590.813930683 700.001.002000.00
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.591.813930683 200.001.00201,7425.08
UNDOTBS2+EZTOPQA_DF/eztopqa_va/datafile/undotbs2.592.813930683 700.001.002000.00
UNDOTBS3+EZTOPQA_DF/eztopqa_va/datafile/undotbs3.691.813971193 200.001.00201,0256.56
UNDOTBS4+EZTOPQA_DF/eztopqa_va/datafile/undotbs4.692.813971243 153,757142.511.0093,51096,7553.34
USERS+EZTOPQA_DF/eztopqa_va/datafile/users.695.813971333 200.001.002000.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,712100834,840,5373,145,1591,944,4540012,494
R483,712641,122,768406,122106,088004

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000843,2670

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
B00315194013904933973830139049  0
E0145767912556356428212339738306428212  5

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D3840.09452.167,037118377.00
D7680.19911.745,654114760.00
D1,1520.281361.545,011113079.00
D1,5360.381811.394,528111817.00
D1,9200.472271.304,241111067.00
D2,3040.562721.233,994110420.00
D2,6880.663171.153,75319790.00
D3,0720.753631.093,55619275.00
D3,4560.844081.043,39818863.00
D3,8400.944531.023,30318615.00
D4,0961.004841.003,25318482.00
D4,2241.034990.993,21618386.00
D4,6081.135440.953,08418040.00
D4,9921.225900.922,98317777.00
D5,3761.316350.882,85317436.00
D5,7601.416800.852,76417204.00
D6,1441.507260.812,65016906.00
D6,5281.597710.802,59416760.00
D6,9121.698160.792,57216702.00
D7,2961.788620.792,55316654.00
D7,6801.889070.782,53816613.00
R3840.09451.024471333.00
R7680.19911.014451331.00
R1,1520.281361.014421329.00
R1,5360.381811.004411327.00
R1,9200.472271.004411327.00
R2,3040.562721.004411327.00
R2,6880.663171.004401327.00
R3,0720.753631.004401327.00
R3,4560.844081.004401327.00
R3,8400.944531.004401327.00
R4,0961.004841.004401327.00
R4,2241.034991.004401327.00
R4,6081.135441.004401327.00
R4,9921.225901.004401327.00
R5,3761.316351.004401327.00
R5,7601.416801.004401327.00
R6,1441.507261.004401327.00
R6,5281.597711.004401327.00
R6,9121.698161.004401327.00
R7,2961.788621.004401327.00
R7,6801.889071.004401327.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,723838.750.000.000.000.00838,860
E8,1925,7122,095.200.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
2K4K116,120116,12000
64K128K11811800
128K256K161600
256K512K141400
512K1024K13513500
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.13513.424.2899.0044101,664
2,0480.25513.420.00100.000100,823
4,0960.50513.420.00100.000100,823
6,1440.75513.420.00100.000100,823
8,1921.00513.420.00100.000100,823
9,8301.20513.420.00100.000100,823
11,4691.40513.420.00100.000100,823
13,1071.60513.420.00100.000100,823
14,7461.80513.420.00100.000100,823
16,3842.00513.420.00100.000100,823
24,5763.00513.420.00100.000100,823
32,7684.00513.420.00100.000100,823
49,1526.00513.420.00100.000100,823
65,5368.00513.420.00100.000100,823

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.79543,312208,0531.001651.003,137
2,7520.90543,312208,0531.001651.003,137
2,7840.91543,312208,0531.001651.003,137
2,8160.92543,312208,0531.001651.003,137
2,8480.93543,312208,0531.001651.003,137
2,8800.94543,312208,0531.001651.003,137
2,9120.95543,312208,0531.001651.003,137
2,9440.96543,312208,0531.001651.003,137
2,9760.97543,312208,0531.001651.003,137
3,0080.98543,312208,0531.001651.003,137
3,0400.99543,312208,0531.001651.003,137
3,0721.00543,312208,0531.001651.003,137
3,1041.01543,312208,0531.001651.003,137
3,1361.02543,312208,0531.001651.003,137
3,1681.03543,312208,0531.001651.003,137
3,2001.04543,312208,0531.001651.003,137
3,2321.05543,312208,0531.001651.003,137
3,2641.06543,312208,0531.001651.003,137
3,2961.07543,312208,0531.001651.003,137
3,3281.08543,312208,0531.001651.003,137
3,3601.09543,312208,0531.001651.003,137
3,3921.10543,312208,0531.001651.003,137
3,7121.21543,312208,0531.001651.003,137
4,0321.31543,312208,0531.001651.003,137
4,3521.42543,312208,0531.001651.003,137
4,6721.52543,312208,0531.001651.003,137
4,9921.63543,312208,0531.001651.003,137
5,3121.73543,312208,0531.001651.003,137
5,6321.83543,312208,0531.001651.003,137
5,9521.94543,312208,0531.001651.003,137
6,2722.04543,312208,0531.001651.003,137

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header11,647484
2nd level bmb38501
3rd level bmb16102
data block11501
free list7802
1st level bmb1303
file header block3900
segment header403
undo block5600

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) 4,385,3224,385,1680801,3506890.86
DW-In memory Dispenser 639,383408,688230,69814,73670.48
WF-AWR Flush 6464062341.94
XR-Quiesce / Force Logging (database force logging) 3,5783,57803,57810.31
CO-KTUCLO Master Slave enq (master slave det) 3,58803,5883,58810.20
FB-Format Block 2,3952,39501,39510.47
TM-DML 644,149644,082046111.37
TX-Transaction (index contention) 318318025212.10
TX-Transaction 444,986444,986011014.73
JS-Job Scheduler (wdw op) 11010450.00
HW-Segment High Water Mark 7,6807,680093200.44
TX-Transaction (row lock contention) 22020165.00
CF-Controlfile Transaction 24,47524,471475300.37
SQ-Sequence Cache 180180014015.00
PS-PX Process Reservation 535534131000.55
US-Undo Segment 373373012600.40
JQ-Job Queue 141131203.33
RO-Multiple Object Reuse (fast object reuse) 18818809400.32
XL-ASM Extent Fault Lock (fault extent map) 878701030.00
PI-Remote PX Process Spawn Status 11211205700.35
TD-KTF map table enqueue (KTF dump entries) 333303300.61
TK-Auto Task Serialization (Auto Task Serialization) 343401201.67
JS-Job Scheduler (job run lock - synchronize) 10641001.00
KD-Scheduler Master DBRM (determine DBRM master) 211205.00
TA-Instance Undo 646406400.00
DR-Distributed Recovery 660600.00
MW-MWIN Schedule 660600.00
UL-User-defined 13130500.00
AF-Advisor Framework (task serialization) 27270400.00
TX-Transaction (allocate ITL entry) 330300.00
FL-Flashback database log (Flashback database log) 440200.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 642200.00
KT-Scheduler Plan 110100.00
TK-Auto Task Serialization (Auto Task Slave Lockout) 11110100.00
WL-Being Written Redo Log 431100.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
7173.28443,0671,8792038.5/46.90/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:5912,43527,4501,75710450/00/0/0/0/0/0
15-Jul 23:4914,29127,1501,87913430/00/0/0/0/0/0
15-Jul 23:397,61917,9261,63411470/00/0/0/0/0/0
15-Jul 23:2910,97024,4661,75810410/00/0/0/0/0/0
15-Jul 23:1913,74531,1421,87313460/00/0/0/0/0/0
15-Jul 23:0915,06032,0871,78512450/00/0/0/0/0/0
15-Jul 22:5916,15730,6211,74217450/00/0/0/0/0/0
15-Jul 22:4916,47632,5971,74120420/00/0/0/0/0/0
15-Jul 22:3914,92740,7991,85216430/00/0/0/0/0/0
15-Jul 22:2914,59554,4961,72812420/00/0/0/0/0/0
15-Jul 22:1913,58949,8391,7209420/00/0/0/0/0/0
15-Jul 22:0911,16433,0121,61711420/00/0/0/0/0/0
15-Jul 21:596,77623,2651,2799390/00/0/0/0/0/0
15-Jul 21:494,24513,9101,5788380/00/0/0/0/0/0
15-Jul 21:391,1163,8511,5836440/00/0/0/0/0/0
15-Jul 21:291629791440/00/0/0/0/0/0
15-Jul 21:1911051,5772440/00/0/0/0/0/0
15-Jul 21:091102891,8492430/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 latch23,662,98210.540.0010 
active service list59,0010.010.0005,2630.00
alert log latch60.00 00 
AQ deq hash table latch30.00 00 
archive control1890.00 00 
archive process latch8850.231.0000 
ASM allocation1,6870.00 00 
ASM db client latch2,006,0670.00 00 
ASM Keyed state latch2340.00 00 
ASM map headers2,3710.00 00 
ASM map load waiting list5540.00 00 
ASM map operation freelist1,1960.00 00 
ASM map operation hash table13,999,7610.070.0000 
ASM network background latch8,0260.00 00 
ASM network SGA latch90.00 00 
ASM network state latch1,8380.00 00 
ASM scan context latch120.00 00 
AWR Alerted Metric Element list175,8250.00 00 
begin backup scn array100.00 00 
buffer pool30.00 00 
business card750.00 00 
cache buffer handles38,7240.00 00 
cache buffers chains1,711,501,5950.010.01018,755,4010.21
cache buffers lru chain31,797,9660.040.00014,872,5370.02
cache table scan latch1,3230.00 074,8630.00
call allocation1,9870.300.3300 
cas latch30.00 00 
change notification client cache latch30.00 00 
Change Notification Hash table latch3,5940.00 00 
channel handle pool latch4640.00 00 
channel operations parent latch229,557,6690.010.0100 
checkpoint queue latch1,376,325,1340.000.0003,105,5520.01
client/application info7530.00 00 
compile environment latch2820.00 00 
Consistent RBA658,0230.000.0000 
corrupted undo seg latch2,8430.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1740.00 00 
cvmap freelist lock30.00 00 
database property service latch880.00 00 
deferred cleanup latch1740.00 00 
DML lock allocation1,288,5100.000.0000 
dml lock allocation1740.00 00 
done queue latch30.00 00 
dummy allocation5550.180.0000 
enqueue freelist latch30.00 035,951,8110.01
enqueue hash chains53,260,5850.180.0009490.11
enqueues3,7620.00 00 
error message lists2880.00 00 
Event Group Locks4080.00 00 
FAL Queue2940.00 00 
fast space usage latch770,3950.000.0000 
FIB s.o chain latch540.00 00 
fifth spare latch30.00 00 
file cache latch26,7870.00 00 
File State Object Pool Parent Latch10,063,2090.050.0000 
flashback allocation1,359,3720.010.0400 
flashback copy30.00 01,272,6470.03
flashback mapping47,5910.650.0000 
flashback prepare log info140.00 00 
flashback sync request82,3530.440.0000 
FOB s.o list latch34,4070.870.0100 
fourth Audit Vault latch30.00 00 
gc element35,524,4230.030.080988,2470.02
gcs commit scn state30.00 00 
gcs opaque info freelist4,636,6920.050.0000 
gcs partitioned table hash80,467,2450.150.000161,7630.01
gcs pcm hashed value bucket hash30.00 00 
gcs remaster request queue30.00 00 
gcs remastering latch1,566,5369.650.0000 
gcs resource freelist1,801,1720.000.0001,208,9010.00
gcs resource hash39,161,0620.040.0007370.00
gcs resource scan list1,9110.00 00 
gcs shadows freelist2,565,5490.000.0002,705,6230.00
ges caches resource lists2,063,7320.360.0102,177,8720.04
ges deadlock list1,9420.00 00 
ges DFS wait callback info20.00 00 
ges domain table6,806,0790.000.0000 
ges enqueue table freelist6,910,5320.000.0000 
ges group table12,053,0840.000.0000 
ges process hash list151,982,2940.000.0900 
ges process parent latch18,245,0850.000.0000 
ges process table freelist2340.00 00 
ges resource hash list20,886,4100.050.0807451.88
ges resource scan list4510.00 00 
ges resource table freelist9,4890.00 00 
ges timeout list4,1200.020.0005110.00
ges value block free list510.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch3660.00 031,1940.00
hash table modification latch1,2910.00 00 
heartbeat check30.00 06,2770.00
heartbeat structure management0  02,1530.00
In memory undo latch30.00 00 
internal temp table object number allocation latch720.00 00 
interrupt manipulation1,1400.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,3600.00 05,1460.00
job workq parent latch270.00 0244.17
job_queue_processes free list latch540.00 00 
job_queue_processes parameter latch2,3730.00 00 
JS broadcast add buf latch2,4930.00 00 
JS broadcast drop buf latch2,4920.00 00 
JS broadcast load blnc latch2,1730.00 00 
JS mem alloc latch530.00 00 
JS queue access latch560.00 00 
JS queue state obj latch78,7460.00 00 
JS Sh mem access230.00 00 
JS slv state obj latch880.00 00 
kcbtsemkid latch30.00 00 
kdlx hb parent latch30.00 00 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KFK SGA Libload latch16,8480.00 00 
KFMD SGA140.00 00 
kgb parent30.00 00 
kgnfs mount latch30.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list1,964,3200.170.010175,0880.03
KJCT flow control latch28,816,2720.010.0000 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
KMG MMAN ready and startup request latch3,5890.00 00 
kokc descriptor allocation latch120.00 00 
ksfv messages30.00 00 
ksim group membership cache1,681,6620.000.0000 
ksim membership request latch0  010,4190.00
kss move lock1210.00 00 
ksuosstats global area1,0860.00 00 
ksv allocation latch4040.00 00 
ksv class latch30,2910.020.6000 
ksv instance latch380.00 00 
ksv msg queue latch1350.00 01320.00
ksxp shared latch2340.00 00 
ksxp so latch2340.00 00 
KSXR large replies40.00 00 
ksz_so allocation latch2340.00 00 
KTF sga latch1020.00 03,5630.00
ktm global data636,6100.020.0000 
kwqbsn:qsga3750.00 00 
KWQMN job cache list latch7590.00 00 
k2q global data latch7,1780.00 00 
k2q lock allocation30.00 00 
lgwr LWN SCN662,1540.040.0000 
list of block allocation9,5390.020.0000 
loader state object freelist1,8400.00 00 
lob segment dispenser latch1,551,7630.000.0000 
lob segment hash table latch1,510,8990.000.5000 
lob segment query latch6890.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,6810.030.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,6070.020.0200 
messages71,528,6368.390.0010 
MinActiveScn Latch3,8280.00 00 
mostly latch-free SCN681,7691.570.0100 
MQL Tracking Latch0  02140.00
msg queue latch30.00 00 
multiblock read objects360,4220.000.0000 
Mutex30.00 00 
Mutex Stats30.00 00 
name-service memory objects35,7000.00 00 
name-service namespace bucket5,119,8930.010.0000 
name-service namespace objects360.00 00 
name-service pending queue7,7300.00 00 
name-service request1080.00 00 
name-service request queue126,7010.00 00 
ncodef allocation latch1740.00 00 
object queue header heap346,883,7130.000.0003,973,2220.19
object queue header operation478,632,3000.010.0100 
object stats modification66,2550.030.0000 
OS process1,0640.00 00 
OS process allocation22,1500.00 00 
OS process: request allocation2340.00 00 
parallel query alloc buffer7,6030.00 00 
parallel query stats2490.00 00 
parallel txn reco latch66,4320.00 00 
parameter list880.00 00 
parameter table management6860.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
PL/SQL warning settings3010.00 00 
post/wait queue3,122,0970.180.0003,460,4100.68
process allocation17,5330.00 01230.00
process group creation2340.00 00 
process queue9040.00 00 
process queue reference15,6510.00 01,4340.00
PX hash array latch30.00 00 
qmn task queue latch1,5270.00 00 
QMT30.00 00 
query server freelists6750.00 00 
query server process380.00 0180.00
queued dump request360.00 00 
queuing load statistics30.00 00 
Real-time plan statistics latch1,1580.00 00 
recovery domain hash list30.00 00 
redo allocation3,395,8190.140.01010,612,2800.51
redo copy30.00 010,631,2630.33
redo writing23,459,7574.600.0000 
reservation so alloc latch40.00 00 
Reserved Space Latch100.00 00 
resmgr group change latch1,681,2870.000.0000 
resmgr:active threads36,1690.001.0003,5870.03
resmgr:actses change group2850.00 00 
resmgr:actses change state400.00 00 
resmgr:free threads list5980.330.0000 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method49,6370.190.0000 
resmgr:schema config2,056,8161.460.92721191.68
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects1,758,421,53429.470.03129230.00
second Audit Vault latch30.00 00 
second spare latch30.00 00 
segmented array pool460.00 00 
sequence cache1,847,4460.040.0100 
session allocation161,2080.000.000160,7170.00
session idle bit12,208,0540.010.0100 
session queue latch30.00 00 
session state list latch6460.00 00 
session switching2880.690.0000 
session timer3,5860.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA IO buffer pool latch760.00 0760.00
SGA pool locks30.00 00 
Shared B-Tree3780.00 00 
shared pool12,925,6000.040.0100 
shared pool sim alloc150.00 00 
shared pool simulator6710.00 00 
sim partition latch30.00 00 
simulator hash latch57,192,9420.000.0000 
simulator lru latch30.00 056,900,7530.01
sort extent pool161,4910.00 00 
space background state object latch160.00 00 
space background task latch2,502,49515.140.03271,1970.07
SQL memory manager latch30.00 03,5780.00
SQL memory manager workarea list latch240,8280.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 
trace latch100.00 00 
transaction allocation2,821,8780.000.0000 
undo global data778,780,0420.020.0000 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 
WCR: sync30.00 00 
Write State Object Pool Parent Latch30.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
X$KSFQP600.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects1,758,421,534518,167,35015,102,336506,663,722
messages71,528,6366,001,4325,8925,995,562
active checkpoint queue latch23,662,9822,494,7404,4522,490,292
redo writing23,459,7571,078,0682,1151,075,955
space background task latch2,502,495378,96612,373366,603
undo global data778,780,042179,479427179,066
cache buffers chains1,711,501,595151,5441,363150,193
enqueue hash chains53,260,58596,36820996,159
object queue header operation478,632,30060,12065159,476
resmgr:schema config2,056,81630,09327,6172,499
channel operations parent latch229,557,66929,44842829,023
checkpoint queue latch1,376,325,13419,9564319,913
gcs resource hash39,161,06217,2778417,196
cache buffers lru chain31,797,96611,7262211,704
mostly latch-free SCN681,76910,68512810,560
ges resource hash list20,886,41010,6438419,803
gc element35,524,42310,1528049,378
ASM map operation hash table13,999,76110,0901510,075
object queue header heap346,883,7137,459187,441
ges caches resource lists2,063,7327,396547,342
post/wait queue3,122,0975,50255,497
shared pool12,925,6005,451405,411
redo allocation3,395,8194,892414,852
File State Object Pool Parent Latch10,063,2094,710174,693
KJC message pool free list1,964,3203,424413,383
KJCT flow control latch28,816,2722,88682,878
gcs opaque info freelist4,636,6922,51922,517
session idle bit12,208,0548518843
sequence cache1,847,4468145809
message pool operations parent latch4,793,60776613754
ges process hash list151,982,29455248504
ges group table12,053,0844532451
flashback mapping47,5913071306
FOB s.o list latch34,4072982296
ges enqueue table freelist6,910,5322801279
lgwr LWN SCN662,1542441243
flashback allocation1,359,37270367
call allocation1,987625
ksv class latch30,291532
archive process latch885220
lob segment hash table latch1,510,899211
resmgr:active threads36,169110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
active checkpoint queue latchkcbbacq: scan active checkpoints04,1984,316
active checkpoint queue latchkcbkcpa: Checkpoint post-processing 2010523
active checkpoint queue latchkcbkcpa: Checkpoint post-processing09883
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 102216
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 20206
active checkpoint queue latchkcbk_add_rbr_ckpt: Add rbr ckpt 3098
archive process latchkcrrgpll022
ASM map operation hash tablekffmTranslate0119
ASM map operation hash tablekffmDoDone_1046
cache buffers chainskcbchg1: clear MS bit06144
cache buffers chainskcbbxsv0264271
cache buffers chainskcbgcur_40231384
cache buffers chainskcbrls_2010865
cache buffers chainskcbzwb0666
cache buffers chainskclbla05222
cache buffers chainskclwlr0279
cache buffers chainskcbgcur_20161
cache buffers chainskcllkopesc0110
cache buffers chainskcbkzs080
cache buffers chainskcbchg1: mod cr pin060
cache buffers chainskcbgtcr: fast path (cr pin)055
cache buffers chainskclwrt055
cache buffers chainskcbzib: finish processing buffer041
cache buffers chainskcbzgb: scan from tail. nowait030
cache buffers chainskclcqchk030
cache buffers chainskcbget: fast exchange020
cache buffers chainskcbbic1010
cache buffers chainskcbchg1: mod cur pin011
cache buffers chainskcbrls: fast release0121
cache buffers chainskclexpandlock0127
cache buffers lru chainkcbbic2049
cache buffers lru chainkcbbxsv: move to being written040
cache buffers lru chainkcbkcxe041
cache buffers lru chainkcbzgws040
cache buffers lru chainkcbzgb032
cache buffers lru chainkcbbwlru017
cache buffers lru chainkcbo_link_q010
cache buffers lru chainkclmvreqbg012
call allocationksuxds022
channel operations parent latchksrwait()0344269
channel operations parent latchksrapublish()05110
channel operations parent latchksrsconsume()03676
channel operations parent latchksrpubwait():1035127
channel operations parent latchksrmfree()0172
checkpoint queue latchkcbkubc_402911
checkpoint queue latchkcbklbc_cql070
checkpoint queue latchkcbbwdl: thread checkpoint queue046
checkpoint queue latchkcbbwthc: thread checkpoint buffers0326
enqueue hash chainsksqrcl09314
enqueue hash chainsksqcmi: if lk mode not requested071156
enqueue hash chainsksqcmi: if lk mode requested01612
enqueue hash chainsksqcnl0153
enqueue hash chainsksqgtl301424
File State Object Pool Parent LatchFSO create0913
File State Object Pool Parent LatchFSO delete normal084
flashback allocationkrfgdata2033
flashback mappingkrfw_advance_mapping1010
FOB s.o list latchksfd_fobd022
gc elementkclchkping06730
gc elementkclnfndnewm03625
gc elementkclrwrite02939
gc elementkclbla0227
gc elementkclfwrite102118
gc elementkclulb01019
gc elementkclwrt095
gc elementKCLUNLNK0728
gc elementkclebs042
gc elementkcl_fairness020
gc elementkcllkopesc020
gc elementkcllwr021
gc elementkclnfnd011
gc elementkclplz0112
gc elementkclrwrite_10010
gcs opaque info freelistkjbrinfofree free opaque info021
gcs resource hashkclrwrite02019
gcs resource hashkclfwrite10149
gcs resource hashkjbassume0131
gcs resource hashkjbcropen0114
gcs resource hashkjbcrcomplete091
gcs resource hashkjbrwrdone reget092
gcs resource hashkjbconvert040
gcs resource hashkjblpwreq018
gcs resource hashkjbmpcreatepi019
gcs resource hashkjbopen010
gcs resource hashkjbopen:affinity010
ges enqueue table freelistkjlfr: remove lock from parent object010
ges group tablekjgagll: move a lock from process lock list to group lock list012
ges group tablekjgdgll: move a lock from group lock list to process lock list010
ges process hash listkjakiqa: set inquiry response0480
ges resource hash listkjakcai: search for resp by resname049734
ges resource hash listkjlrlr: remove lock from resource queue020869
ges resource hash listkjlmfnd: search for lockp by rename and inst id0827
ges resource hash listkjrmas1: lookup master node0270
ges resource hash listkjucvl: lock convert request0202
ges resource hash listkjakoca: search for resp by resname04714
ges resource hash listkjuinq: inquire resource held mode030
ges resource table freelistkjchc: clean resource cache0490
ges resource table freelistkjrm2c: move resource to cache0555
KJC message pool free listkjcsmpav: allocate a msg buffer04041
KJC message pool free listkjcspfmbq: free vector of msg buffers010
KJCT flow control latchkjcts_sqenq: queue a message070
KJCT flow control latchkjctcsnd: send normal message010
ksv class latchksvclsl: rdp - recycle030
lgwr LWN SCNkcs0230400
lob segment hash table latchlob_segment_dispenser:23010
message pool operations parent latchksrmdone()065
message pool operations parent latchksrmalloc()051
message pool operations parent latchksrmfree()038
messagesksarcv03,6032,410
messagesksarcv: after wait01,2741,769
messagesksaamb: after wakeup01,0151,713
mostly latch-free SCNkcslcu3088129
mostly latch-free SCNkcs024010
object queue header heapkcbo_link_q:alloc082
object queue header heapkcbo_unlink_q_bg060
object queue header heapkcbo_check_flist0216
object queue header heapkcbo_unlink_q020
object queue header operationkcldbufs0176119
object queue header operationkcbo_link_q012534
object queue header operationkcbo_switch_mq_bg09737
object queue header operationkcbo_switch_q_bg06534
object queue header operationkcbo_unlink_q06525
object queue header operationkcbo_check_flist049399
object queue header operationkcbo_unlink_q_bg04523
object queue header operationkcbo_link_q:reget0310
object queue header operationkcbo_switch_cq02420
object queue header operationkclbufs0208
object queue header operationkclobj_5010
PC and Classifier lists for WLMNo latch030
post/wait queueksliwat:add:nowait040
post/wait queuekslpstevent:get014
redo allocationkcrfw_redo_gen: redo allocation 10410
redo writingkcrfwcr02,0352,059
redo writingkcrfw_cal_target_rba04431
redo writingkcrfw_post: rba scn pair0350
redo writingkcrfw_post: after write0125
resmgr:active threadskgskmetricupd010
resmgr:schema configkgskgmaxdop1027,13927,578
resmgr:schema configkgskgasi1039535
resmgr:schema configkgskmetricupd0640
resmgr:schema configkgskclassinfo10120
resmgr:schema configkgskscscb041
resmgr:schema configkgskgcs1020
resmgr:schema configkgskgetclassidbyname013
row cache objectskqrpre: find obj06,616,2218,475,494
row cache objectskqreqd: reget04,668,1912,958,649
row cache objectskqreqd03,817,4033,667,730
sequence cachekdnssd050
session idle bitksupuc: clear busy053
session idle bitksupuc: set busy035
session idle bitksuxds011
shared poolkghalo02430
shared poolkghfre01510
shared poolkghfnd: get next extent010
space background task latchktsj_grab_task011,73812,279
space background task latchktsjCreateTask044522
space background task latchktsj_detach_task018774
undo global dataktudba: KSLBEGIN0424426
undo global dataktudnx:child021
undo global dataktusmupst: KSLBEGIN011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal2 91570
Library Cachekglpin1 4340
Library Cachekglpndl1 95170
Library Cachekglpnal1 90120
Library Cachekgllkdl1 8570
Cursor PinkksLockDelete [KKSCHLPIN6]60
Cursor Pinkksfbc [KKSCHLFSP2]50
Library Cachekgllkal1 8040
Library Cachekglobpn1 7130
Library Cachekglhdgn2 10620
Library Cachekgllkc1 5710
hash tablekkscsSearchChildList [KKSHBKLOC2]10
Cursor Pinkksfbc [KKSCHLPIN1]10

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
EZTOEZTO_DATALIBRARYSYS_P17728TABLE PARTITION1,518,8480.18
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX1,285,9840.15
EZTOEZTO_DATALIBRARYSYS_P17813TABLE PARTITION913,6960.11
EZTOEZTO_INDEXBYCONSTESTMEDIA INDEX802,8320.10
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX776,6080.09

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB106,8463.00
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41185LOB PARTITION20,9990.59
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41263LOB PARTITION17,1320.48
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41259LOB PARTITION15,4260.43
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41295LOB PARTITION15,4260.43

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB106,8473.21
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50632LOB PARTITION5,3900.16
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41185LOB PARTITION5,3010.16
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48456LOB PARTITION4,8180.14
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41263LOB PARTITION4,3290.13

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB106,8473.21
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50632LOB PARTITION5,3900.16
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41185LOB PARTITION5,3010.16
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48456LOB PARTITION4,8180.14
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41263LOB PARTITION4,3290.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 PARTITION1202.57

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB98,2104.79
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX34,3391.67
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX3,2480.16
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,8160.09
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50788LOB PARTITION1,7550.09

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX29,6323.02
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX2,7090.28
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,8070.18
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50788LOB PARTITION1,6760.17
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION1,4740.15

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 PARTITION16717.34

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 INDEX388,40033.85
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB109,9209.58
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX32,1602.80
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION29,9842.61
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49413INDEX PARTITION15,2961.33

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 INDEX9574.80
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P48945INDEX PARTITION32.36
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTPK_IDXSYS_P47982INDEX PARTITION21.57
EZTOEZTO_INDEXATTEMPTDATA_PKSYS_P49455INDEX PARTITION21.57
EZTOEZTO_INDEXATTEMPTDATA_PKSYS_P49575INDEX PARTITION21.57

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX93.38
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48596LOB PARTITION83.01
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50429LOB PARTITION83.01
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50686LOB PARTITION83.01
EZTOEZTO_LOBSYS_LOB0000156592C00010$$SYS_LOB_P50500LOB PARTITION72.63

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX1131.43
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48652LOB PARTITION411.43
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX38.57
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48438LOB PARTITION38.57
EZTOEZTO_LOBSYS_LOB0000154027C00008$$SYS_LOB_P48682LOB PARTITION38.57

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 PARTITION63,7645.66
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX40,0593.55
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41296LOB PARTITION7,3760.65
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41234LOB PARTITION5,5980.50
EZTOEZTO_LOBSYS_LOB0000145503C00009$$SYS_LOB_P41294LOB PARTITION3,7960.34

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
EZTOEZTO_INDEXATTEMPTDATA_ATTEMPTID_IDX INDEX170,9458.14
EZTOEZTO_INDEXATTEMPT_ATTEMPTID_IDX INDEX30,5571.45
EZTOEZTO_INDEXATTEMPTDATA_TESTUSERID_IDXSYS_P49308INDEX PARTITION2,8030.13
EZTOEZTO_INDEXATTEMPT_TESTUSERID_IDXSYS_P39068INDEX PARTITION2,2320.11
EZTOEZTO_LOBSYS_LOB0000164360C00007$$ LOB1,1800.06

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1962.550 21
dc_global_oids440.000 032
dc_histogram_data3651.370 0457
dc_histogram_defs18,1161.520 04,508
dc_objects286,9530.100 36,731
dc_profiles160.000 01
dc_rollback_segments585,429,0230.000 01,040
dc_segments99,5950.440 30616,918
dc_sequences16687.950 1660
dc_tablespaces118,1240.000 012
dc_users200,4200.000 077
global database name10,0250.000 01
outstanding_alerts13891.300 00
sch_lj_oids2213.640 05

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control950
dc_histogram_defs27600
dc_objects301540
dc_segments1,0484900
dc_sequences3321460
outstanding_alerts2641260
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
BODY1390.002,4210.0000
CLUSTER40.0040.0000
DBLINK100.000 00
EDITION620.00750.0000
INDEX2470.4024710.12240
QUEUE0 1790.0000
SCHEMA820.000 00
SQL AREA80,4340.143,972,140-0.004898
SQL AREA BUILD25653.130 00
SQL AREA STATS25681.2525681.2500
TABLE/PROCEDURE93,6460.04858,3430.03330

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY02,4152,41500
CLUSTER44400
DBLINK100000
EDITION62656500
INDEX24724724700
QUEUE017917900
SCHEMA130000
TABLE/PROCEDURE93,979764,346764,34600

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
BOther803.85 2.454.515454328328
Freeable32.810.001.371.948 2424
SQL1.390.060.000.0105283276
PL/SQL0.900.320.000.0100326325
EOther2,001.60 5.896.315454340340
Freeable86.380.000.581.068 149149
SQL6.100.550.020.0205291284
PL/SQL1.360.470.000.0200338337

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory192.00192.000.00
largefree memory255.63255.630.00
sharedASH buffers128.00128.000.00
sharedASM extent pointer array70.6570.650.01
sharedCheckpoint queue64.0364.030.00
shareddb_block_hash_buckets44.5044.500.00
shareddbktb: trace buffer80.0080.000.00
shareddbwriter coalesce buffer32.0332.030.00
shareddirty object counts array32.0032.000.00
sharedevent statistics per sess127.81127.810.00
sharedfree memory1,069.21844.49-21.02
sharedgcs resources214.34214.340.00
sharedgcs shadows125.03125.030.00
sharedges enqueues154.50156.711.43
sharedges resource88.5689.931.56
sharedksunfy : SSO free list119.14119.140.00
sharedKTSL subheap34.54162.50370.43
sharedobject queue 86.84 
 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,7780.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,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
D0000.0010,7780.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00   00 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/eztopqa/adump  
audit_trailNONE  
cluster_databaseTRUE  
cluster_database_instances4  
compatible11.2.0.0.0  
control_file_record_keep_time31  
control_files+EZTOPQA_RDOA/eztopqa_va/controlfile/current.257.784840069, +EZTOPQA_RDOB/eztopqa_va/controlfile/current.257.784840069, +EZTOPQA_DF/eztopqa_va/controlfile/current.276.784840069, +EZTOPQA_ARCH/eztopqa_va/controlfile/current.270.784840069  
db_block_size8192  
db_cache_size4294967296  
db_create_file_dest+EZTOPQA_DF  
db_create_online_log_dest_1+EZTOPQA_RDOA  
db_create_online_log_dest_2+EZTOPQA_RDOB  
db_domain    
db_file_multiblock_read_count4  
db_files1024  
db_nameEZTOPQA  
db_recovery_file_dest+EZTOPQA_DF  
db_recovery_file_dest_size697932185600  
db_recycle_cache_size4294967296  
db_unique_nameeztopqa_va  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=DB112032XDB)  
_gc_defer_time3  
gcs_server_processes8  
global_namesTRUE  
instance_number4  
large_pool_size268435456  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.169.2.59)(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  
thread4  
undo_tablespaceUNDOTBS4  
_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,130,867105.017.11
acks for commit broadcast(logical)1,393,639129.418.76
broadcast msgs on commit(actual)1,698,438157.7110.68
broadcast msgs on commit(logical)1,881,201174.6811.82
broadcast msgs on commit(wasted)357,80033.222.25
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received880.010.00
flow control messages sent2750.030.00
gcs apply delta00.000.00
gcs assume cvt6,5880.610.04
gcs assume no cvt1,769,638164.3211.12
gcs ast xid250.000.00
gcs blocked converts1,612,788149.7610.14
gcs blocked cr converts1,044,08596.956.56
gcs compatible basts510,85147.443.21
gcs compatible cr basts (global)297,81427.651.87
gcs compatible cr basts (local)296,09927.491.86
gcs cr basts to PIs40.000.00
gcs cr serve without current lock10.000.00
gcs dbwr flush pi msgs221,17820.541.39
gcs dbwr write request msgs166,43915.461.05
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 only322,64029.962.03
gcs force cr grant281,29126.121.77
gcs force cr no current00.000.00
gcs forward cr to pinged instance160.000.00
gcs immediate (compatible) converts39,0783.630.25
gcs immediate cr (compatible) converts2480.020.00
gcs immediate cr (null) converts112,98810.490.71
gcs immediate (null) converts1,382,518128.388.69
gcs indirect ast1,154,221107.187.25
gcs indirect bidless ast5,0790.470.03
gcs indirect fg ast1,154,203107.187.25
gcs lms flush pi msgs104,7279.720.66
gcs lms write request msgs103,6059.620.65
gcs msgs process time(ms)401,07137.242.52
gcs msgs received14,842,3341,378.2293.29
gcs new served by master29,3582.730.18
gcs out-of-order msgs4400.040.00
gcs pings refused8430.080.01
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts8,4260.780.05
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast6,1790.570.04
gcs reader bypass grant immediate7,0070.650.04
gcs reader bypass grant X on assume2530.020.00
gcs reader bypass N->Xw ping local2360.020.00
gcs reader bypass N->Xw ping remote2050.020.00
gcs recovery claim msgs00.000.00
gcs refuse xid150.000.00
gcs regular cr632,53558.743.98
gcs retry convert request1,1820.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,408,668130.808.85
gcs undo cr490.000.00
gcs write notification msgs10,4550.970.07
gcs writes refused4,1910.390.03
ges msgs process time(ms)47,0534.370.30
ges msgs received1,967,309182.6812.37
global posts dropped00.000.00
global posts queue time00.000.00
global posts queued00.000.00
global posts requested00.000.00
global posts sent00.000.00
implicit batch messages received338,43431.432.13
implicit batch messages sent370,92734.442.33
lmd msg send time(ms)00.000.00
lms(s) msg send time(ms)240.000.00
messages flow controlled133,34012.380.84
messages queue sent actual5,631,323522.9135.40
messages queue sent logical916,33285.095.76
messages received actual15,865,2151,473.2099.72
messages received logical16,810,4091,560.97105.66
messages sent directly8,265,273767.4951.95
messages sent indirectly4,898,960454.9030.79
messages sent not implicit batched00.000.00
messages sent pbatched4,538,389421.4228.53
msgs causing lmd to send msgs1,060,99298.526.67
msgs causing lms(s) to send msgs2,559,331237.6516.09
msgs received queue time (ms)598,93555.623.76
msgs received queued16,808,0851,560.75105.65
msgs sent queue time (ms)278,29725.841.75
msgs sent queue time on ksxp (ms)4,113,286381.9525.85
msgs sent queued6,173,533573.2638.80
msgs sent queued on ksxp16,225,0701,506.61101.98
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received4,730,802439.2929.74
process batch messages sent4,117,352382.3325.88


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests727,974
CURRENT Block Requests1,410,544
Data Block Requests727,982
Undo Block Requests49
TX Block Requests1,399
Current Results1,098,547
Private results1,820
Zero Results718
Disk Read Results1,037,490
Fail Results2
Fairness Down Converts340,711
Fairness Clears36,618
Free GC Elements0
Flushes6,022
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)109,234
Light Works5,960
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins11,57255.3335.449.190.040.00
Flushes71,3949.4586.693.850.010.00
Writes279,02544.8853.651.340.120.00


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
3data block256,74095.820.723.45325,19095.492.651.86
2data block265,34495.970.763.27254,67894.463.551.99
1data block254,58695.980.713.32250,81094.603.541.87
1Others120,28697.940.081.99185,41196.151.991.86
3Others117,31697.990.081.93177,02496.092.051.87
2Others112,38497.860.092.05170,49396.072.021.91
1undo header12692.864.762.38264,74589.419.461.13
2undo header11091.828.180.00239,28488.859.851.30
3undo header13789.789.490.73232,71590.937.841.23
2undo block2365.2234.780.000   
3undo block1855.5638.895.560   
1undo block1485.7114.290.000   

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

  CR Avg Time (ms) Current Avg Time (ms)
Inst NoBlock Class AllImmedBusyCongstAllImmedBusyCongst
3data block0.390.372.940.560.330.320.740.37
2data block0.380.362.950.480.360.340.770.48
1data block0.380.363.030.500.350.330.770.40
1others0.290.292.380.330.300.300.650.39
3others0.290.293.000.350.300.290.670.41
2others0.290.293.350.330.310.300.650.37
1undo header0.370.242.910.250.590.253.830.37
2undo header0.600.234.73 0.610.243.890.33
3undo header0.410.291.570.250.530.243.890.30
2undo block0.730.211.70     
3undo block0.820.291.680.16    
1undo block0.470.251.81     

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

   CR Current
Src Inst#Block Class Blocks LostImmed Blks Received% 2hop% 3hopImmed Blks Received% 2hop% 3hop
3data block0246,01947.1352.87310,52563.2936.71
2data block0254,65053.8046.20240,56153.8746.13
1data block0244,34250.6749.33237,25659.3340.67
1others0117,80751.7048.30178,27859.0440.96
3others0114,95751.1848.82170,09761.9238.08
2others0109,97450.1949.81163,78658.8241.18
1undo header0117100.000.00236,698100.000.00
2undo header0101100.000.00212,593100.000.00
3undo header0123100.000.00211,605100.000.00
2undo block015100.000.000  
1undo block012100.000.000  
3undo 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
3data block 0.370.260.460.320.250.44
2data block 0.360.270.450.340.260.43
1data block 0.360.270.450.330.260.43
1others 0.290.210.360.300.220.40
3others 0.290.210.370.290.220.40
2others 0.290.210.370.300.220.41
1undo header 0.240.24 0.250.25 
2undo header 0.230.23 0.240.24 
3undo header 0.290.29 0.240.24 
2undo block 0.210.21    
1undo block 0.250.25    
3undo block 0.290.29    

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
18550.450.138550.500.16
28550.410.138550.450.14
38550.410.128550.450.13
48550.370.118550.360.11

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

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

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Device NameIP AddressPublicSourceSend Mbytes/secSend ErrorsSend DroppedSend Buffer OverrunSend Carrier LostReceive Mbytes/secReceive ErrorsReceive DroppedReceive Buffer OverrunReceive Frame Errors
bond1:1169.254.40.2NO  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 received35,8148,953.50  
replayed locks sent00.00  
resources cleaned00.00  
remaster time (s)5.21.30  
quiesce time (s)0.70.18  
freeze time (s)0.20.05  
cleanup time (s)0.10.04  
replay time (s)1.80.44  
fixwrite time (s)1.40.34  
sync time (s)1.00.26  
affinity objects  111


Back to Top

End of Report