WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
COREDB87227165COREDB1117-5月 -13 05:0511.2.0.2.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
CORE-DB1AIX-Based Systems (64-bit) 24 12  48.25

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2547607-8月 -13 22:00:05559 6.6
End Snap:2547707-8月 -13 23:00:14818 6.4
Elapsed:  60.15 (mins)  
DB Time:  4,776.06 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 15,616M 15,552MStd Block Size: 8K
Shared Pool Size: 8,576M 8,640MLog Buffer: 16,536K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 79.4 1.5 0.15 0.05
DB CPU(s): 2.6 0.1 0.00 0.00
Redo size: 91,898.6 1,767.4  
Logical reads: 162,169.0 3,118.9  
Block changes: 534.3 10.3  
Physical reads: 5,231.3 100.6  
Physical writes: 36.2 0.7  
User calls: 1,536.0 29.5  
Parses: 407.7 7.8  
Hard parses: 50.3 1.0  
W/A MB processed: 14.0 0.3  
Logons: 0.7 0.0  
Executes: 519.0 10.0  
Rollbacks: 35.8 0.7  
Transactions: 52.0   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 98.01In-memory Sort %: 100.00
Library Hit %: 83.71Soft Parse %: 87.67
Execute to Parse %: 21.45Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 0.29% Non-Parse CPU: 92.91

Shared Pool Statistics

BeginEnd
Memory Usage %: 62.18 64.21
% SQL with executions>1: 79.34 64.61
% Memory for SQL w/exec>1: 77.89 59.05

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
library cache lock8,244181,7042204163.41Concurrency
cursor: pin S wait on X38061,00816054821.29Concurrency
DB CPU 9,196 3.21 
resmgr:cpu quantum64,3364,831751.69Scheduler
db file sequential read744,2814,11361.44User I/O

Host CPU (CPUs: 24 Cores: 12 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
4.47 5.38 14.7 3.9 5.3 81.4
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
10.9 58.9 1.6
Memory Statistics

BeginEnd
Host Mem (MB): 49,408.0 49,408.0
SGA use (MB): 24,576.0 24,576.0
PGA use (MB): 3,003.4 3,885.0
% Host Mem used for SGA+PGA: 55.82 57.60

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 176.53 3.40
Global Cache blocks served: 103.85 2.00
GCS/GES messages received: 461.48 8.88
GCS/GES messages sent: 770.38 14.82
DBWR Fusion writes: 5.49 0.11
Estd Interconnect traffic (KB) 2,483.62 

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

Buffer access - local cache %: 97.90
Buffer access - remote cache %: 0.11
Buffer access - disk %: 1.99

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 87.1
Avg global cache cr block receive time (ms): 7.0
Avg global cache current block receive time (ms): 3.0
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 %: 13.0
Avg global cache cr block flush time (ms): 4.0
Avg global cache current block pin time (ms): 0.1
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.7
Avg global cache current block flush time (ms): 9.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3
Avg message sent queue time on ksxp (ms): 7.1
Avg message received queue time (ms): 0.2
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 40.80
% of indirect sent messages: 58.86
% of flow controlled messages: 0.34


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
en9169.254.131.102N    

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed242,484.6384.62
hard parse elapsed time168,858.9958.93
sql execute elapsed time49,755.4717.36
PL/SQL compilation elapsed time12,318.864.30
DB CPU9,195.803.21
failed parse elapsed time3,802.181.33
hard parse (sharing criteria) elapsed time3,372.001.18
hard parse (bind mismatch) elapsed time3,335.371.16
sequence load elapsed time1,296.520.45
PL/SQL execution elapsed time1,048.140.37
connection management call elapsed time18.820.01
repeated bind elapsed time0.240.00
DB time286,563.44 
background elapsed time2,339.74 
background cpu time429.05 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME68,006 
AVG_IDLE_TIME298,157 
AVG_IOWAIT_TIME19,460 
AVG_SYS_TIME14,283 
AVG_USER_TIME53,609 
BUSY_TIME1,634,985 
IDLE_TIME7,158,549 
IOWAIT_TIME469,872 
SYS_TIME345,557 
USER_TIME1,289,428 
LOAD45
OS_CPU_WAIT_TIME2,180,600 
RSRC_MGR_CPU_WAIT_TIME471,533 
VM_IN_BYTES1,009,983,504 
VM_OUT_BYTES4,372,574,208 
PHYSICAL_MEMORY_BYTES51,808,043,008 
NUM_CPUS24 
NUM_CPU_CORES12 
GLOBAL_RECEIVE_SIZE_MAX1,310,720 
GLOBAL_SEND_SIZE_MAX1,310,720 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
07-8月 22:00:054.47     
07-8月 23:00:145.3818.5914.663.9381.415.34

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency65,5930244,552372885.34
DB CPU  9,196 3.21
User I/O1,148,04607,20262.51
Scheduler64,33604,831751.69
Cluster699,08204,22261.47
Application68,22901,639240.57
Configuration38711,24632200.43
Commit83,65601,223150.43
Other90,169701,055120.37
Network5,048,896034700.12
System I/O21,47704520.02

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
library cache lock8,2441181,704220410.0463.41
cursor: pin S wait on X380061,0081605480.0021.29
resmgr:cpu quantum64,33604,831750.341.69
db file sequential read744,28104,11363.971.44
db file scattered read354,65502,34971.890.82
enq: TX - row lock contention38101,61942490.000.56
buffer busy waits1,79801,4127850.010.49
enq: SQ - contention29001,24642960.000.43
log file sync83,65601,223150.450.43
gc buffer busy acquire50,8871941180.270.33
DFS lock handle6,5246627960.030.22
gc current grant busy47,1790609130.250.21
gc cr block busy19,9460537270.110.19
direct path read13,3050457340.070.16
gc current block congested40803658950.000.13
enq: US - contention110032729770.000.11
gc cr block congested35902988300.000.10
gc current block 2-way242,098026411.290.09
gc current block busy2,19502311050.010.08
SQL*Net more data from client6,9220210300.040.07
gc cr block 2-way138,312020510.740.07
gc cr multi block request35,731020060.190.07
gc current grant congested75016221610.000.06
row cache lock16,890015490.090.05
SQL*Net message to client5,033,3190137026.820.05
gc cr grant congested12801259780.000.04
read by other session17,662012070.090.04
library cache pin8,7061110130.050.04
gc cr grant 2-way107,868010910.570.04
gc buffer busy release57701061840.000.04
db file parallel read5,4100101190.030.04
library cache: mutex X15,81609660.080.03
Disk file operations I/O10,46205960.060.02
name-service call wait10882494510.000.02
control file sequential read21,44704520.110.02
gc current grant 2-way12,38404440.070.02
library cache load lock1270262080.000.01
enq: TX - index contention362024670.000.01
gc cr disk read40,75502410.220.01
SQL*Net break/reset to client67,65601900.360.01
ASM file metadata operation1510171130.000.01
latch: shared pool1,84001370.010.00
buffer exterminate652997100.000.00
reliable message4,5570710.020.00
enq: PS - contention96310440.010.00
PX Deq: Signal ACK RSG1,6250320.010.00
latch: ges resource hash list12903230.000.00
PX Deq: Slave Session Stats2,4750210.010.00
os thread startup12021630.000.00
latch: row cache objects4960240.000.00
direct path write temp8602190.000.00
enq: TX - contention230100270.000.00
rdbms ipc reply1,0200110.010.00
latch: cache buffers chains10,8950100.060.00
PX Deq: reap credit44,820100100.240.00
asynch descriptor resize15,566100100.080.00
gc current split2801320.000.00
direct path write1460160.000.00
latch free2,8820100.020.00
direct path read temp2401300.000.00
IPC send completion sync9840000.010.00
enq: KO - fast object checkpoint1350030.000.00
cr request retry451000100.000.00
buffer deadlock638100010.000.00
external table read2120020.000.00
enq: TM - contention24290180.000.00
enq: WF - contention700590.000.00
gc cr block lost1004090.000.00
latch: object queue header operation1230030.000.00
PX Deq: Signal ACK EXT1,6250000.010.00
latch: gcs resource hash1400230.000.00
resmgr:internal state change310001000.000.00
SQL*Net more data to client8,6550000.050.00
CSS initialization800210.000.00
enq: RO - fast object reuse330050.000.00
enq: FB - contention830020.000.00
gc current multi block request1020020.000.00
KJC: Wait for msg sends to complete3,6090000.020.00
log file switch completion200720.000.00
enq: HW - contention640010.000.00
enq: TT - contention790010.000.00
latch: enqueue hash chains1430000.000.00
enq: JQ - contention11000520.000.00
CSS operation: action90050.000.00
control file parallel write300020.000.00
undo segment extension5100080.000.00
enq: TO - contention5562010.000.00
latch: cache buffers lru chain600010.000.00
gc cr failure470010.000.00
enq: TX - allocate ITL entry260010.000.00
enq: CR - block range reuse ckpt70030.000.00
enq: OD - Serializing DDLs16100010.000.00
latch: gc element1850000.000.00
utl_file I/O1,7750000.010.00
enq: MD - contention230010.000.00
CSS operation: query240000.000.00
enq: SK - contention19100010.000.00
ges inquiry response120010.000.00
enq: PI - contention8100010.000.00
wait list latch free10060.000.00
latch: call allocation50010.000.00
latch: undo global data40010.000.00
cursor: pin S220000.000.00
global enqueue expand wait70010.000.00
PX qref latch537100000.000.00
enq: AF - task serialization20010.000.00
enq: CF - contention40010.000.00
enq: TS - contention40000.000.00
lock deadlock retry13100000.000.00
latch: session allocation10010.000.00
gc current retry20010.000.00
SQL*Net message from client5,033,058011,035,739219326.82 
jobq slave wait3,332991,6604980.02 
PX Deq: Execution Msg3,40006431890.02 
PX Deq: Parse Reply1,62502881770.01 
PX Deq: Execute Reply10,3600189180.06 
auto-sqltune: wait graph update13926448940.00 
PX Deq: Join ACK1,625019110.01 
PL/SQL lock timer4100410000.00 
PX Deq Credit: send blkd7850110.00 
KSV master wait1500300.00 
PX Deq Credit: need buffer500410.00 
PX Deq: Msg Fragment7750000.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
log file parallel write137,330035930.7315.33
os thread startup86122726340.009.68
db file parallel write14,17009770.084.16
gcs log flush sync35,34978020.193.40
gc current grant congested3071235900.003.02
control file sequential read14,73306850.082.93
gc current block busy2803713320.001.59
enq: PV - syncstart2029145610.001.24
reliable message745326350.001.13
row cache lock4,15401950.020.82
enq: CO - master slave det1,13210019170.010.81
process diagnostic dump2,44401980.010.80
Streams AQ: qmn coordinator waiting for slave to start4751742620.000.73
enq: TH - metric threshold evaluation1015152650.000.65
db file sequential read1,405015110.010.63
control file parallel write4,99601430.030.59
gc cr grant congested130129210.000.51
enq: PR - contention201154710.000.47
enq: CF - contention3481009250.000.37
gc current block congested26072550.000.28
log file sequential read19306300.000.25
library cache lock56022360.000.15
gc current block 2-way1,0010330.010.14
buffer busy waits6303400.000.11
latch free3340270.000.11
enq: TD - KTF dump entries11022110.000.10
gc cr grant 2-way3540260.000.09
ges lms sync during dynamic remastering and reconfig72782300.000.09
row cache process51,7200200.280.08
ASM file metadata operation9490220.010.07
row cache cleanup89,4590200.480.07
DFS lock handle2,29670110.010.06
wait for scn ack6012010.000.05
ADR block file write2401400.000.04
LGWR wait for redo copy1,6960110.010.04
gc current grant busy1050160.000.03
ksxr poll remote instances61,535100100.330.03
kjbdrmcvtq lmon drm quiesce: ping completion36711960.000.03
CSS initialization4011390.000.02
gc cr multi block request4301120.000.02
CGS wait for IPC msg30,365100000.160.02
latch: shared pool570080.000.02
gc current grant 2-way3550010.000.02
gc cr block 2-way2590020.000.02
name-service call wait800470.000.02
ADR block file read690050.000.01
library cache pin6550010.000.01
Parameter File I/O960030.000.01
latch: cache buffers chains730040.000.01
libcache interrupt action by LCK64,7970000.350.01
Log archive I/O600480.000.01
gc cr block busy1000270.000.01
direct path write900260.000.01
resmgr:internal state change210001040.000.01
enq: KO - fast object checkpoint3670010.000.01
ges inquiry response2160010.000.01
latch: ges resource hash list5470000.000.01
latch: row cache objects280060.000.01
SQL*Net break/reset to client3700000.000.01
ges LMON to get to FTDONE61000210.000.01
latch: gc element1410010.000.01
ADR file lock2814040.000.00
gc cr block congested200570.000.00
enq: DR - contention200510.000.00
PX Deq: reap credit6,696100000.040.00
Disk file operations I/O3680000.000.00
latch: object queue header operation4660000.000.00
SGA: allocation forcing component growth100590.000.00
log file sync300160.000.00
IPC send completion sync150030.000.00
CSS operation: action160030.000.00
CSS operation: data query200200.000.00
enq: TT - contention6258010.000.00
ksdxexeotherwait100380.000.00
latch: messages300120.000.00
ges generic event21000140.000.00
latch: gcs resource hash210010.000.00
enq: TX - index contention100260.000.00
latch: cache buffers lru chain440010.000.00
enq: PS - contention2143010.000.00
rdbms ipc reply770000.000.00
gc buffer busy release50030.000.00
buffer deadlock11000160.000.00
db file scattered read100160.000.00
enq: TM - contention1173010.000.00
enq: PE - contention6100010.000.00
enq: WF - contention150010.000.00
gc current multi block request110010.000.00
enq: PG - contention6100010.000.00
enq: CR - block range reuse ckpt140010.000.00
kfk: async disk IO30020.000.00
db file parallel read10070.000.00
enq: US - contention70010.000.00
SQL*Net message to client4,5560000.020.00
latch: enqueue hash chains20020.000.00
asynch descriptor resize2,113100000.010.00
enq: TK - Auto Task Serialization6100010.000.00
PX Deq: Signal ACK RSG180000.000.00
enq: RO - fast object reuse100000.000.00
CSS operation: query120000.000.00
enq: TA - contention50010.000.00
gc current split20020.000.00
SQL*Net more data from client220000.000.00
PX Deq: Slave Session Stats180000.000.00
library cache: mutex X50010.000.00
log file single write20010.000.00
gc current retry10020.000.00
enq: FB - contention50000.000.00
enq: HW - contention40010.000.00
latch: redo allocation100000.000.00
enq: AF - task serialization20010.000.00
enq: MW - contention20010.000.00
rdbms ipc message337,8422388,2522611.80 
PX Idle Wait858012,999151500.00 
class slave wait9209,6381047590.00 
wait for unread message on broadcast channel7,2191007,21610000.04 
DIAG idle wait207,426926,931331.11 
gcs remote message1,210,653346,85166.45 
Space Manager: slave idle wait1,142965,55348620.01 
Streams AQ: qmn slave idle wait20524,968242350.00 
ASM background timer77803,60946390.00 
shared server idle wait1201003,600300010.00 
dispatcher timer601003,600600020.00 
pmon timer1,466753,59424510.01 
ges remote message396,109733,59392.11 
PING1,367213,58526230.01 
GCR sleep7101003,55150010.00 
Streams AQ: qmn coordinator idle wait291423,539121610.00 
smon timer75203,52046810.00 
SGA: MMAN sleep for component shrink30,968100315100.17 
SQL*Net message from client6,1880910.03 
KSV master wait2,13499100.01 
PX Deq: Parse Reply180060.00 
PX Deq: Join ACK180030.00 
PX Deq: Execute Reply180010.00 
Streams AQ: RAC qmn coordinator idle wait300100000.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 read6940.61.414.521.718.82.9  
ADR block file write24  12.58.329.220.829.2 
ADR file lock2889.3    3.67.1 
ARCH wait for archivelog lock1100.0       
ASM file metadata operation109984.8.4.4.2  14.3 
CGS wait for IPC msg30.4K99.9.0.0.0.0.0  
CSS initialization1250.0     50.0 
CSS operation: action2524.020.0 52.04.0   
CSS operation: data query2     100.0  
CSS operation: query3683.32.813.9     
DFS lock handle889171.022.03.5.9.5.5.8.9
Disk file operations I/O10.8K93.14.61.3.1.0.0.8.1
IPC send completion sync99696.22.5.3.5.2.1.2 
KJC: Wait for msg sends to complete374799.8.1 .0.0.1.0 
LGWR wait for redo copy169894.51.21.51.3.8.5.2 
Log archive I/O633.3   16.7 50.0 
PX Deq: Signal ACK EXT163896.51.21.6.3.2.1  
PX Deq: Signal ACK RSG163890.42.31.5.9.54.0.3 
PX Deq: Slave Session Stats248691.45.31.7.8.4.1.2 
PX Deq: reap credit51.4K100.0.0.0.0  .0 
PX qref latch537100.0       
Parameter File I/O9636.5 43.811.57.31.0  
SGA: allocation forcing component growth1      100.0 
SQL*Net break/reset to client68K98.51.1.2.1.0.0.0 
SQL*Net message to client5038.1K100.0.0.0.0.0.0.0.0
SQL*Net more data from client696878.1.2.2.3.41.019.8 
SQL*Net more data to client7243100.0       
Streams AQ: qmn coordinator waiting for slave to start425.0      75.0
asynch descriptor resize17.7K99.9.0.0.0.0.0.0 
buffer busy waits186045.84.37.22.82.64.119.313.9
buffer deadlock63993.72.22.01.3.3.2.3 
buffer exterminate652  .3.398.9.5  
control file parallel write5026.375.913.06.53.0.6.7 
control file sequential read36.2K53.531.14.74.53.51.41.4 
cr request retry45    100.0   
cursor: mutex S2100.0       
cursor: pin S2290.99.1      
cursor: pin S wait on X380    29.2.59.560.8
db file parallel read54095.517.67.68.019.625.216.5 
db file parallel write14.2K3.648.018.012.111.33.73.3 
db file scattered read354.4K15.249.48.53.911.87.14.0 
db file sequential read746.1K43.023.54.25.914.96.81.8.0
direct path read13.3K.1.2.3.423.045.031.0 
direct path read temp24  8.38.320.820.841.7 
direct path write1554.525.815.545.22.62.63.9 
direct path write temp863.512.810.524.415.116.317.4 
enq: AF - task serialization475.025.0      
enq: CF - contention35285.88.52.61.1 .31.1.6
enq: CO - master slave det113285.69.33.11.0.4 .4.3
enq: CR - block range reuse ckpt2268.24.522.74.5    
enq: DR - contention250.0     50.0 
enq: FB - contention8878.411.42.34.52.3 1.1 
enq: HW - contention6877.910.32.94.44.4   
enq: JQ - contention1      100.0 
enq: KO - fast object checkpoint50291.84.01.4.4.81.0.6 
enq: MD - contention2391.34.34.3     
enq: MW - contention2100.0       
enq: OD - Serializing DDLs1675.012.56.3 6.3   
enq: PE - contention666.716.7 16.7    
enq: PG - contention683.3  16.7    
enq: PI - contention862.525.012.5     
enq: PR - contention2       100.0
enq: PS - contention98069.424.53.51.6.4.3.2.1
enq: PV - syncstart2       100.0
enq: RO - fast object reuse4360.54.74.720.97.0 2.3 
enq: SK - contention1994.75.3      
enq: SQ - contention2906.24.14.53.42.46.920.352.1
enq: TA - contention580.020.0      
enq: TD - KTF dump entries1181.8 9.1    9.1
enq: TH - metric threshold evaluation1       100.0
enq: TK - Auto Task Serialization683.316.7      
enq: TM - contention3494.1  2.92.9   
enq: TO - contention5592.73.61.81.8    
enq: TS - contention4100.0       
enq: TT - contention14187.98.51.4.71.4   
enq: TX - allocate ITL entry2684.611.5 3.8    
enq: TX - contention23081.77.83.91.73.5 1.3 
enq: TX - index contention36436.33.62.75.86.39.635.7 
enq: TX - row lock contention38144.114.48.18.77.34.78.73.9
enq: US - contention11824.63.41.7 2.53.431.433.1
enq: WF - contention2290.94.5    4.5 
external table open14100.0       
external table read21291.57.5    .9 
external table seek14100.0       
gc buffer busy acquire50.9K35.238.210.73.75.42.74.0.1
gc buffer busy release58315.416.58.78.411.76.031.71.5
gc cr block 2-way138.6K94.83.2.8.4.3.2.2.0
gc cr block busy19.9K.749.331.19.15.62.12.1.1
gc cr block congested36135.72.53.35.35.05.033.89.4
gc cr block lost1      100.0 
gc cr disk read40.8K96.32.5.6.3.1.1.1.0
gc cr failure4791.52.14.32.1    
gc cr grant 2-way107.7K96.22.6.7.3.1.1.1.0
gc cr grant congested14165.25.02.13.55.72.112.14.3
gc cr multi block request35.5K55.432.64.66.21.0.2.1.0
gc current block 2-way243.2K95.53.0.8.3.2.1.2.0
gc current block busy222517.024.919.512.712.56.46.3.6
gc current block congested43546.7.92.83.23.41.829.411.7
gc current grant 2-way12.8K95.72.3.7.3.2.2.4.1
gc current grant busy47.3K92.64.71.0.4.4.2.6.1
gc current grant congested7812.82.61.32.62.62.652.623.1
gc current multi block request11281.312.5 2.71.81.8  
gc current retry366.7 33.3     
gc current split3073.310.03.36.7  6.7 
gc object scan3100.0       
gcs log flush sync35.3K37.738.58.77.27.5.4.0 
ges LMON to get to FTDONE6     100.0  
ges generic event2    50.050.0  
ges inquiry response22880.315.43.11.3    
ges lms sync during dynamic remastering and reconfig72  1.418.15.625.050.0 
global enqueue expand wait7100.0       
kfk: async disk IO333.333.3 33.3    
kjbdrmcvtq lmon drm quiesce: ping completion3      100.0 
ksdxexeotherwait1      100.0 
ksxr poll remote instances60.3K100.0.0      
latch free321391.14.91.41.2.8.2.4 
latch: cache buffers chains11K99.1.3.3.1.1.0.0 
latch: cache buffers lru chain10490.43.81.92.91.0   
latch: call allocation1392.3  7.7    
latch: checkpoint queue latch1100.0       
latch: enqueue hash chains14592.43.41.42.8    
latch: gc element32397.2.9.3.9 .3.3 
latch: gcs resource hash3582.9  8.65.7 2.9 
latch: ges resource hash list68889.81.91.52.62.2.91.2 
latch: messages366.7     33.3 
latch: object queue header operation58998.5.2.3.8  .2 
latch: redo allocation1090.010.0      
latch: row cache objects52271.55.23.44.65.97.91.5 
latch: session allocation1 100.0      
latch: shared pool185878.37.25.92.91.81.32.6 
latch: undo global data450.025.025.0     
libcache interrupt action by LCK63.6K100.0 .0.0    
library cache load lock1273.95.51.61.613.41.672.4 
library cache lock876781.95.72.01.1.6.31.56.8
library cache pin931892.64.11.1.8.4.2.8.1
library cache: mutex X15.8K62.83.13.76.89.410.04.2 
lock deadlock retry14100.0       
lock escalate retry2100.0       
log file parallel write137.3K45.036.65.57.04.11.3.6 
log file sequential read1933.1.5 .516.163.216.6 
log file single write250.050.0      
log file switch completion2    50.0 50.0 
log file sync83.7K22.745.112.38.96.12.52.4.0
name-service call wait116  .9 .9.997.4 
os thread startup98      91.88.2
process diagnostic dump244410.9.171.916.3.5.1.2.0
rdbms ipc reply108960.627.59.4.9.9.2.5 
read by other session17.7K22.840.012.15.812.05.31.8.0
reliable message531192.23.92.0.6.2.2.9 
resmgr:cpu quantum64.3K8.86.68.38.97.410.349.6.1
resmgr:internal state change5      100.0 
row cache cleanup87.6K100.0.0.0.0.0.0.0 
row cache lock20.3K88.67.41.71.0.5.2.4.2
row cache process50.5K100.0.0.0.0.0.0.0 
undo segment extension1127.3   27.318.227.3 
utl_file I/O38199.5.3 .3    
wait for scn ack6   16.7  83.3 
wait list latch free1   100.0    
ASM background timer7781.3.1    4.694.0
DIAG idle wait207.5K5.0.4.513.047.914.219.0.0
GCR sleep710       100.0
KSV master wait214999.5.1.1.0  .2 
PING136777.7.9.4.1.1 .120.6
PL/SQL lock timer4      100.0 
PX Deq Credit: need buffer560.020.0    20.0 
PX Deq Credit: send blkd78592.64.61.3.3.6 .6 
PX Deq: Execute Reply10.4K15.45.28.116.338.710.65.8.0
PX Deq: Execution Msg339242.527.311.25.13.83.34.62.2
PX Deq: Join ACK163825.347.417.05.62.31.11.0.2
PX Deq: Msg Fragment77599.5.4  .1   
PX Deq: Parse Reply163831.138.314.73.12.32.37.01.2
PX Idle Wait84815.926.314.24.61.81.17.029.2
SGA: MMAN sleep for component shrink31K.0.0.0.099.5.3.1 
SQL*Net message from client5039.5K83.06.71.5.7.7.85.21.4
Space Manager: slave idle wait1145.2 .1   1.598.3
Streams AQ: RAC qmn coordinator idle wait300100.0       
Streams AQ: qmn coordinator idle wait29155.31.71.0   .341.6
Streams AQ: qmn slave idle wait20514.1      85.9
auto-sqltune: wait graph update13       100.0
class slave wait9254.36.52.26.56.51.17.615.2
dispatcher timer60       100.0
gcs remote message1210.5K26.011.112.513.033.83.6.0.0
ges remote message396.1K84.72.21.51.21.01.08.4.0
jobq slave wait3343      100.0 
pmon timer14676.5  .1.2.38.984.0
rdbms ipc message336.8K37.05.05.48.86.64.427.84.9
shared server idle wait120       100.0
smon timer7542.3.1    2.994.7
wait for unread message on broadcast channel7219    .0 99.9.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ADR block file write770.812.512.5 4.2   
ADR file lock292.97.1      
ASM file metadata operation15785.7 12.21.7.2.2  
CSS initialization650.041.7  8.3   
DFS lock handle7198.4.1.1.0 .6.0.8
Disk file operations I/O9799.1.0.1.1.2.4.1 
IPC send completion sync299.8.2      
KJC: Wait for msg sends to complete1100.0.0      
LGWR wait for redo copy399.8.1.1     
Log archive I/O350.016.716.716.7    
PX Deq: Signal ACK RSG599.7.1.1 .1.1  
PX Deq: Slave Session Stats699.8.0.2 .0   
PX Deq: reap credit2100.0.0  .0   
SGA: allocation forcing component growth1 100.0      
SQL*Net break/reset to client14100.0.0.0.0    
SQL*Net message to client19100.0.0.0.0 .0 .0
SQL*Net more data from client138380.21.93.914.1    
asynch descriptor resize1100.0    .0  
buffer busy waits45266.84.43.4.91.29.55.08.9
buffer deadlock299.7 .2.2    
control file parallel write3599.3.5.1.1    
control file sequential read51998.6.7.6.1.0.0  
cursor: pin S wait on X4529.71.1.31.31.35.52.458.4
db file parallel read89283.513.52.2.6.1.0  
db file parallel write47196.71.9.8.5.0.0  
db file scattered read14.3K96.03.2.6.2.0.0  
db file sequential read13.3K98.21.4.3.1.0.0.0 
direct path read412969.022.65.22.9.4.0  
direct path read temp1058.329.212.5     
direct path write696.12.6.6.6    
direct path write temp1582.611.64.71.2    
enq: CF - contention498.3   .9.3 .6
enq: CO - master slave det499.4.1 .1.2  .3
enq: DR - contention150.0 50.0     
enq: FB - contention198.91.1      
enq: JQ - contention1 100.0      
enq: KO - fast object checkpoint399.4.2.4     
enq: PS - contention299.7 .1.1   .1
enq: RO - fast object reuse197.72.3      
enq: SQ - contention6727.66.64.13.84.11.72.849.3
enq: TX - contention398.7   1.3   
enq: TX - index contention13064.37.79.96.911.0.3  
enq: TX - row lock contention3487.42.13.41.61.3.3.33.7
enq: US - contention3935.62.5.8.8 27.11.731.4
enq: WF - contention195.5   4.5   
external table read299.1  .9    
gc buffer busy acquire205495.9.91.8.3.3.7.0.0
gc buffer busy release19366.76.93.83.45.012.71.4.2
gc cr block 2-way35399.7.1.1.0.0.0.0.0
gc cr block busy42197.81.0.6.3.1.1.0.1
gc cr block congested13656.83.08.07.28.37.23.95.5
gc cr block lost1    100.0   
gc cr disk read2499.9.0.0.0.0  .0
gc cr grant 2-way15699.8.0.0.0.0.0.0.0
gc cr grant congested1883.72.83.52.82.8 .73.5
gc cr multi block request3399.9.1.0.0.0  .0
gc current block 2-way42999.8.1.0.0.0.0.0.0
gc current block busy14893.03.41.3.9.5.3.3.3
gc current block congested15458.92.55.17.66.97.46.05.7
gc current grant 2-way6399.5.1.1.1.1.1.0.0
gc current grant busy32899.3.2.1.1.2.1.1.1
gc current grant congested5124.410.37.710.312.811.512.810.3
gc current split293.33.3   3.3  
gcs log flush sync11100.0.0.0.0 .0  
ges lms sync during dynamic remastering and reconfig3650.048.61.4     
kjbdrmcvtq lmon drm quiesce: ping completion3   100.0    
ksdxexeotherwait1 100.0      
latch free1299.6.2.1.0 .1  
latch: cache buffers chains5100.0.0.0 .0   
latch: gc element199.7 .3     
latch: gcs resource hash197.1   2.9   
latch: ges resource hash list898.8.3.1 .4.3  
latch: messages166.733.3      
latch: object queue header operation199.8   .2   
latch: row cache objects898.51.5      
latch: shared pool4997.4.9.5.5.4.4  
library cache load lock9227.66.311.010.244.9   
library cache lock15791.6.3.2.1.7.2.36.6
library cache pin7699.1.4.0.0.0.3 .1
library cache: mutex X65795.83.7.4.0.0.0  
log file parallel write82399.4.4.1.1.0.0  
log file sequential read3283.46.28.32.1    
log file switch completion150.0 50.0     
log file sync197297.61.1.7.4.1.1.0.0
name-service call wait1132.67.89.52.673.34.3  
os thread startup91  75.511.24.11.01.07.1
process diagnostic dump499.8  .0.0.1 .0
rdbms ipc reply599.5.5      
read by other session33398.11.2.3.2.1.1.0 
reliable message5099.1.2.1.1.1.5  
resmgr:cpu quantum32K50.317.316.48.95.61.3.1.0
resmgr:internal state change5  100.0     
row cache cleanup5100.0.0 .0 .0  
row cache lock9499.3.1.1.0.1.1.0.2
row cache process3100.0 .0 .0   
undo segment extension372.79.19.19.1    
wait for scn ack516.733.3 16.733.3   

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
DFS lock handle7499.2.1.4.2.0   
SQL*Net message to client6100.0.0   .0  
Streams AQ: qmn coordinator waiting for slave to start325.0 75.0     
buffer busy waits16591.1.97.3.7    
cursor: pin S wait on X4741.62.93.93.4.5.31.346.1
enq: CF - contention299.4.6      
enq: CO - master slave det399.7.2 .1    
enq: PR - contention2 50.050.0     
enq: PS - contention199.9.1      
enq: PV - syncstart2 50.0  50.0   
enq: SQ - contention14350.74.822.122.4    
enq: TD - KTF dump entries190.99.1      
enq: TH - metric threshold evaluation1   100.0    
enq: TX - row lock contention1096.3.8.31.3.3  1.0
enq: US - contention3768.65.112.713.6    
gc buffer busy acquire24100.0.0.0.0.0.0  
gc buffer busy release199.8.2      
gc cr block 2-way12100.0.0.0     
gc cr block busy1399.9.0.0.0 .0.0 
gc cr block congested2094.51.11.71.41.4   
gc cr disk read1100.0.0      
gc cr grant 2-way8100.0.0      
gc cr grant congested596.5.7 1.4.7 .7 
gc cr multi block request3100.0.0   .0.0 
gc current block 2-way7100.0.0      
gc current block busy799.7 .0.0.0.2  
gc current block congested2594.31.62.31.1.5 .2 
gc current grant 2-way6100.0.0.0     
gc current grant busy2499.9.0.0.0 .0.0 
gc current grant congested889.7 6.4 1.3 2.6 
library cache lock18893.4.3.8.9.0 .14.4
library cache pin699.9 .0.1    
log file sync12100.0.0 .0.0.0.0 
os thread startup792.91.02.02.0 1.01.0 
process diagnostic dump1100.0  .0    
resmgr:cpu quantum31100.0.0.0     
row cache lock3999.8.2      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

  % of Total Waits
EventWaits 4m to 1h <2m <4m <8m<1/4h<1/2h< 1h>=1h
cursor: pin S wait on X17553.923.918.23.9   
enq: TX - row lock contention499.0.3.8    
library cache lock38895.6.81.91.7   

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
COREDB.271,2535,7787,902345,198
SYS$USERS15,3253,42610,982239,735
SYS$BACKGROUND001330
COREDBXDB0000

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
COREDB. 376275325544056243337004994151347
SYS$USERS 771731394721722121500549020
SYS$BACKGROUND 187415710352530000

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
4,914.2521023.401.710.150.0095v76f5muyjjg JDBC Thin Client select originalorderno from or...
3,763.541,2033.131.310.050.067ncnu7ud2ykhu JDBC Thin Client insert into ORDERS (domesticin...
3,333.346,8680.491.160.140.009upvznnp7xgsj JDBC Thin Client SELECT BG.BANKGATEWAYNAME AS b...
3,194.6813,194.681.1167.2315.336mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
3,158.5014225.611.100.010.00fp1vatugjfuym JDBC Thin Client SELECT O.STATUS, P.TICKETNO FR...
2,649.895529.980.920.160.009awmqbn8w5tkq JDBC Thin Client SELECT O.STATUS, P.TICKETNO FR...
2,573.073287.840.9080.203.429q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
1,998.326333.050.700.150.00g3yjdvgd23b85 JDBC Thin Client select p.orderno, o.bookUser f...
1,800.001,5571.160.630.150.006wytwy7ry0jsb JDBC Thin Client UPDATE ORDERS SET TICKETOUTAGE...
1,742.442,1000.830.610.050.007jk3kcjxvz83k JDBC Thin Client UPDATE PAYBILL SET PAYSTATUS =...

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
2,147.8612,147.8623.363,194.6867.2315.336mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
2,063.523286.2922.442,573.0780.203.429q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
490.551,4950.335.33643.8776.190.580a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
489.052921.675.32621.3778.702.75bs6q10hmtbh49 JDBC Thin Client select bs.billno, bs.bankflowi...
223.551,1760.192.43310.6371.970.00gyudauqxd8gqc JDBC Thin Client select ag.ORGAREA ORGAREA from...
195.791161.692.13281.7369.500.00dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
130.241740.751.42171.0476.140.0058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
104.261850.561.13162.4864.170.012ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
80.092160.370.87106.6175.120.0025svbmrbjp20g JDBC Thin Client select g.airport from agentsal...
76.42561.360.83216.9535.2333.223af2rnt9q4u9b JDBC Thin Client select cd.CCRDNO , cd.item, cd...

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
489.711489.716.793,194.6867.2315.336mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
87.953280.271.222,573.0780.203.429q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
85.71561.531.19254.2729.9633.71btrs48n39rhcd JDBC Thin Client select cd.CCRDNO, cd.item, cd....
72.07561.291.00216.9535.2333.223af2rnt9q4u9b JDBC Thin Client select cd.CCRDNO , cd.item, cd...
54.00510.800.75108.9735.7249.56c6ksc6kfhjjc6 DBMS_SCHEDULER with ash_samples as ( SELECT /...
34.38221.560.48118.3455.6429.0573fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
21.1610,4540.000.2932.114.8965.911ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
17.102920.060.24621.3778.702.75bs6q10hmtbh49 JDBC Thin Client select bs.billno, bs.bankflowi...
13.0862.180.1863.1959.8520.693bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
8.7510,3980.000.1227.296.2732.069nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...

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
192,797,7031192,797,703.0032.943,194.6867.215.36mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
189,334,952328577,240.7132.352,573.0780.23.49q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
44,649,5691,49529,865.937.63643.8776.2.60a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
25,694,766174147,671.074.39171.0476.1058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
16,350,77318588,382.562.79162.4864.202ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
13,076,5531,17611,119.522.23310.63720gyudauqxd8gqc JDBC Thin Client select ag.ORGAREA ORGAREA from...
9,973,94318454,206.211.70209.1822.9.17qkh5ucsbcqk6 JDBC Thin Client select sum(o.seatnum) from ord...
8,587,36856153,345.861.47254.273033.7btrs48n39rhcd JDBC Thin Client select cd.CCRDNO, cd.item, cd....
8,583,69356153,280.231.47216.9535.233.23af2rnt9q4u9b JDBC Thin Client select cd.CCRDNO , cd.item, cd...
8,452,70811672,868.171.44281.7369.50dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
6,990,39818437,991.291.1960.206309b2r0p9d97p92 JDBC Thin Client select sum(t.seatnum) from ord...
6,494,28917437,323.501.1140.9176.8.4c5jycdptb6cj3 JDBC Thin Client select sum(o.seatnum) from ord...
6,124,94029220,975.821.05621.3778.72.8bs6q10hmtbh49 JDBC Thin Client select bs.billno, bs.bankflowi...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
159,277531,855.400.84108.9735.7249.56c6ksc6kfhjjc6 DBMS_SCHEDULER with ash_samples as ( SELECT /...
81,811181,811.000.433,194.6867.2315.336mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
19,62732859.840.102,573.0780.203.429q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
12,72022578.180.07118.3455.6429.0573fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
8,18756146.200.04254.2729.9633.71btrs48n39rhcd JDBC Thin Client select cd.CCRDNO, cd.item, cd....
6,53256116.640.03216.9535.2333.223af2rnt9q4u9b JDBC Thin Client select cd.CCRDNO , cd.item, cd...
1,9602926.710.01621.3778.702.75bs6q10hmtbh49 JDBC Thin Client select bs.billno, bs.bankflowi...
1,52610,4540.150.0132.114.8965.911ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
68610,3980.070.0027.296.2732.069nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
54312,0570.050.0040.766.4520.36f4uf0u8q871js JDBC Thin Client select min(pt.ticketno) as min...

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
68,96368,963168,963.000.004.906mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
19,62719,62732859.840.001.399q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
12,52712,52722569.410.000.8973fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
8,0818,08156144.300.000.57btrs48n39rhcd JDBC Thin Client select cd.CCRDNO, cd.item, cd....
1,9601,9602926.710.000.14bs6q10hmtbh49 JDBC Thin Client select bs.billno, bs.bankflowi...
1,9211,9215384.200.000.14c6ksc6kfhjjc6 DBMS_SCHEDULER with ash_samples as ( SELECT /...
1,8431,8436307.170.000.138kvgs3007httw Foglight for Oracle <5.6.4.311> select /*+ rule */ decode(INST...
68668610,3980.070.000.059nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
54354312,0570.050.000.04f4uf0u8q871js JDBC Thin Client select min(pt.ticketno) as min...
53853810,4830.050.000.0481h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
153,57300.0019.942.804yq6qwgw992zk JDBC Thin Client select CABINS from GENERALIZEL...
105,919105,9121.0037.78.70520mkxqpf15q8 JDBC Thin Client select 1 from dual
105,68300.0094.0110d4ggk0agny9tf JDBC Thin Client SET TRANSACTION READ WRITE
99,34899,3471.0018.7823.10ftj9uawt4wwzb   select condition from cdef$ wh...
25,88225,8821.002.363.40bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
24,00824,0081.0036.352.815.909uaa1krtq5by JDBC Thin Client select f.agentfeereturntype fr...
16,25200.001.931.604xcfs63ggs8m0 JDBC Thin Client select CABINS from GENERALIZEL...
15,14915,1491.001.6725.83.22jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
14,75914,7591.002.182.3087tu7wk540dwq JDBC Thin Client select MAX_THREAD_COUNT from p...
12,99012,9891.004.055.402dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
153,445153,57310.434yq6qwgw992zk JDBC Thin Client select CABINS from GENERALIZEL...
105,907105,9197.20520mkxqpf15q8 JDBC Thin Client select 1 from dual
105,680105,6837.18d4ggk0agny9tf JDBC Thin Client SET TRANSACTION READ WRITE
99,34699,3486.75ftj9uawt4wwzb   select condition from cdef$ wh...
25,87925,8821.76bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
16,24016,2521.104xcfs63ggs8m0 JDBC Thin Client select CABINS from GENERALIZEL...
15,14915,1491.032jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
14,75914,7591.0087tu7wk540dwq JDBC Thin Client select MAX_THREAD_COUNT from p...
12,95912,9900.882dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...
12,05812,0580.825f0955qkz78g4 JDBC Thin Client select DOMESTICINDICATE from o...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
16,063,462550.18b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...
8,896,671550.1089nf3yvxk8yq7 Foglight for Oracle <5.6.4.311> select /*+ rule */ rownum, sid...
2,912,279110.0321dnq66bcztyr Foglight for Oracle <5.5.8.127> select (jj.act_jobs_jobs + js....
1,632,2091,1220.028swypbbr0m372   select order#, columns, types ...
1,561,37290.02am19a1bvysghh Foglight for Oracle <5.6.4.311> select (jj.act_jobs_jobs + js....
1,075,065320.019nz14w8x5fsfd JDBC Thin Client BEGIN PROCESSORDER.CallBackByB...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
10955b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...
456bt51szvfrcdpn JDBC Thin Client SELECT obj_type, plan_id, comp...
361,6837ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
361,6837ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
342,7903nkd3g3ju5ph1   select obj#, type#, ctime, mti...
3015356h11bx91nk74   select limit# from profile$ wh...
285589nf3yvxk8yq7 Foglight for Oracle <5.6.4.311> select /*+ rule */ rownum, sid...
281,1228swypbbr0m372   select order#, columns, types ...
24329nz14w8x5fsfd JDBC Thin Client BEGIN PROCESSORDER.CallBackByB...
232,4875n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
23469subccxd9b03 JDBC Thin Client SELECT signature, inuse_featur...
232,36983taa7kaw59c1   select name, intcol#, segcol#,...
217681gu8t96d0bdmu   select t.ts#, t.file#, t.block...
217681gu8t96d0bdmu   select t.ts#, t.file#, t.block...

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
191.094504.391,429.4813.370.020.005ansr7r9htpq3   update undo$ set name=:2, file...
146.591843.36209.1870.0822.920.097qkh5ucsbcqk6 JDBC Thin Client select sum(o.seatnum) from ord...
115.6812.663,194.683.6267.2315.336mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
38.0210,4830.8752.1772.891.6514.6581h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...
33.8712,0580.7846.8972.221.986.26bhwz3x2mjy7s3 JDBC Thin Client SELECT PL.PNRNO FROM PNRLIST P...
31.701850.73162.4819.5164.170.012ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
30.09560.69254.2711.8329.9633.71btrs48n39rhcd JDBC Thin Client select cd.CCRDNO, cd.item, cd....
25.38560.58216.9511.7035.2333.223af2rnt9q4u9b JDBC Thin Client select cd.CCRDNO , cd.item, cd...
24.051160.55281.738.5469.500.00dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
20.8612,0570.4840.7651.166.4520.36f4uf0u8q871js JDBC Thin Client select min(pt.ticketno) as min...
14.313280.332,573.070.5680.203.429q7k9nbpvk8pv DBMS_SCHEDULER SELECT NVL(SUM(TIME_WAITED/100...
13.2724,0080.3036.3536.522.8115.9309uaa1krtq5by JDBC Thin Client select f.agentfeereturntype fr...
12.7110,4370.2939.3932.272.9518.686u1fc9nj87uhd JDBC Thin Client SELECT S.SEGORDER, (S.CARRIER ...
8.641840.2060.2014.3663.040.009b2r0p9d97p92 JDBC Thin Client select sum(t.seatnum) from ord...
8.3612,0580.1911.9969.706.349.725f0955qkz78g4 JDBC Thin Client select DOMESTICINDICATE from o...
7.9010,3980.1827.2928.966.2732.069nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
7.602,1000.171,742.440.440.050.007jk3kcjxvz83k JDBC Thin Client UPDATE PAYBILL SET PAYSTATUS =...
7.341,4950.17643.871.1476.190.580a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
6.931,2030.163,763.540.180.050.067ncnu7ud2ykhu JDBC Thin Client insert into ORDERS (domesticin...
5.0910,4540.1232.1115.844.8965.911ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
4.881740.1156.078.7170.140.0152ngpnc7n319u JDBC Thin Client select count(*) from orders o ...
4.7450.11108.974.3535.7249.56c6ksc6kfhjjc6 DBMS_SCHEDULER with ash_samples as ( SELECT /...
4.4740.101,181.690.380.100.09ckh0xnga85szg JDBC Thin Client select * from ( select /*+USE_...
3.5312,0580.0816.9020.853.250.06a7pqvnr44uy38 JDBC Thin Client SELECT HO.PAYMONEY, HO.HOTELOR...
3.4730.081,636.550.210.130.105q9n2yy5aj6hv JDBC Thin Client select count(*) as orderstatus...
3.0560.0763.194.8359.8520.693bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
2.99220.07118.342.5355.6429.0573fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
2.971840.0758.205.1171.510.0067jr1q3uanf6w JDBC Thin Client select count(*) from orders o ...
2.8912,0950.075.7450.3012.190.00bhvwd3sbwdyga JDBC Thin Client select f.isautoconfirm from fl...
2.6210,4830.066.5040.337.540.005s3uwrd1gxt7q JDBC Thin Client SELECT NVL(AG.AGENTTYPE, OU1.F...
2.609,2010.063.8467.689.100.0095bdypfq2ky5g JDBC Thin Client select o.domesticindicate from...
2.601740.06171.041.5276.140.0058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
2.5510,4830.064.0662.8612.060.009tzrcb1d5f06z JDBC Thin Client SELECT O.ORDERNO, O.GROUPFLAG,...
2.2312,9900.054.0555.025.430.002dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...
2.2210,4830.0512.3717.945.0914.0590yfsh8rb8gma JDBC Thin Client select p.TYPE from paxinsuranc...
2.2110,4830.057.5729.122.900.0078txh8n821266 JDBC Thin Client select 1 from dual where exist...
1.9830.051,291.690.150.120.007qwgyfxhnaxna JDBC Thin Client select originalorderno from or...
1.977680.053.1562.502.5421.571gu8t96d0bdmu   select t.ts#, t.file#, t.block...
1.7440.041,271.260.140.010.0083bank242m66q JDBC Thin Client select o.campaignscriptid from...
1.5580.042.4363.8811.0913.76fmbv2fxj0mwuy   DECLARE job BINARY_INTEGER := ...
1.4610,4390.032.6056.0612.290.008whvjha2fnk63 JDBC Thin Client SELECT F.TOTALPRICE, F.AGENTFE...
1.441740.0340.913.5176.760.43c5jycdptb6cj3 JDBC Thin Client select sum(o.seatnum) from ord...
1.4012,0570.032.6053.685.760.00ckg1n91hh2qkk JDBC Thin Client select o.pricefileno from flig...
1.1810,4830.032.4348.645.770.00g128myz1mz13n JDBC Thin Client select 1 from dual where exist...
1.051,7190.023.2032.6320.600.83fr6m3gyy3gwk7 JDBC Thin Client UPDATE PNRLIST SET TICKETFLAG ...
1.021,5320.021,666.520.060.130.00ab5gtgnqyskp7 JDBC Thin Client select o.campaignscriptid from...
0.651,5570.011,800.000.040.150.006wytwy7ry0jsb JDBC Thin Client UPDATE ORDERS SET TICKETOUTAGE...
0.61140.010.7185.6511.210.01buzp8cfu6upry JDBC Thin Client SELECT C.CHANGENO, C.ORDERNO, ...
0.5630.011,114.040.050.100.0004havy07x2m26 JDBC Thin Client select count(*) as changestatu...
0.4880.010.7366.2020.680.0074mb2gqrm9xb6 JDBC Thin Client select c.refaction, c.basiccon...
0.471,1720.010.6375.110.0011.2887gaftwrm2h68   select o.owner#, o.name, o.nam...
0.42150.010.7953.3018.940.0114abfzpgc5vkt JDBC Thin Client select c.refaction, c.basiccon...
0.42220.0181.710.5281.260.00d6fwfwn6jjbsb JDBC Thin Client select distinct pi.orderno, o....
0.35320.010.9237.9641.211.049nz14w8x5fsfd JDBC Thin Client BEGIN PROCESSORDER.CallBackByB...
0.331,6830.0132.971.011.762.007ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.28480.010.8432.7411.860.218zr60wpvdvbtu JDBC Thin Client select /*+index(orders IDX_CR...
0.252,4870.010.5445.5916.660.015n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
0.231830.013.406.8245.030.00az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
0.201,1220.001.1417.739.6157.358swypbbr0m372   select order#, columns, types ...
0.142,3690.001.987.0330.3137.1883taa7kaw59c1   select name, intcol#, segcol#,...
0.09550.00119.470.0760.250.01b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...
0.07110.0033.810.2122.600.0121dnq66bcztyr Foglight for Oracle <5.5.8.127> select (jj.act_jobs_jobs + js....
0.0340.00332.710.010.050.005wsn90a3fjnmj JDBC Thin Client UPDATE batchpay b SET b.pnrval...
0.031,1760.00310.630.0171.970.00gyudauqxd8gqc JDBC Thin Client select ag.ORGAREA ORGAREA from...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04havy07x2m26select count(*) as changestatustotal from change c, orders o where o.orderno = c.orderno AND C.STATUS ='H' and (c.submituserid = '113907597020'or c.submituserid = '113907597020') and ROWNUM <= 100 AND to_char(c.createtime, 'yyyy-MM-dd')>=to_char(to_date('2013-05-09', 'yyyy-MM-dd'), 'yyyy-MM-dd') AND c.changetype ='F' order by c.createtime desc
09uaa1krtq5byselect f.agentfeereturntype from flightpricedomestic f where f.orderno = :1
0a1z1knkykfwzselect p.psgname, p.pnrno, (select sum(s.mileage) from segmentprice s where s.orderno=:1 )as mileage , e.exchangeid, e.exchangedate from passenger p, exchange e where p.orderno=e.ecsno(+) and p.pnrno=e.pnr(+) and p.orderno=:2 and p.type!=2
14abfzpgc5vktselect c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'urcguowp' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='urcguowp') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1ugz7d875p582select o.paymode, pb.paystatus, bgw.bankgatewayname, pb.paydate, pb.billno, pb.batchid, pb.uppbillno, pb.batchflag, pb.paymoney, pb.currency, pb.bankcode from payment pm, paybill pb, orders o, bankgateway bgw where pm.orderno = :1 and pm.billno = pb.billno and pm.paystatus != 'D' and pm.orderno = o.orderno and pb.bankgatewaycode = bgw.BANKGATEWAYCODE
21dnq66bcztyrselect (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /*+RULE*/ count(*) tot_jobs_jobs from SYS.dba_jobs) tj, (select /*+RULE*/ count(*) tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /*+RULE*/ count(*) act_jobs_jobs from SYS.dba_jobs_running) jj, (select /*+RULE*/ count(*) act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /*+RULE*/ count(*) due_jobs FROM SYS.dba_jobs WHERE next_date < sysdate) wj, (select /*+RULE*/ count(*) due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date < sysdate) ws
25svbmrbjp20gselect g.airport from agentsaleairport g where g.agent in ( select c.city from cityintegration c, (select t.area from cityintegration t where t.city = (select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea))aaa where aaa.area = c.area union select o.code from agentarea a, ORGAREATOCODE o where a.orgunitguid = '4629' and a.ORGAREA = o.orgarea)
2dqj3rc7b0x8qselect o.Isautocreate from orders o where o.orderno = :1
2ggs3r1ncmwwrselect count(*) as recordscount from orders t where t.bookuser='080009577652' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
3af2rnt9q4u9bselect cd.CCRDNO , cd.item, cd.orderno, r.domesticindicate from callcenterdatarecord cd, refundorder r where cd.status='T' and cd.flag='W' and (r.status='R' or r.status='P') and cd.item=r.refundno and cd.orderno=r.orderno
3bf7cptakrtgaselect p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag ='B' group by p.orderno union select p.orderno from passengerinfo p , orders o where p.orderno = o.orderno and o.orderflag ='B' and o.status = 'E' and o.createdate>sysdate-2 and p.sendflag is null group by p.orderno
3nkd3g3ju5ph1select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
4xcfs63ggs8m0select CABINS from GENERALIZELINK where MERCHANTID = 'TAOBAO'
4yq6qwgw992zkselect CABINS from GENERALIZELINK where MERCHANTID = 'CZBTOC'
520mkxqpf15q8select 1 from dual
52ngpnc7n319uselect count(*) from orders o where o.bookuser='580008619967' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'
56h11bx91nk74select limit# from profile$ where profile#=:1 and resource#=:2 and type#=:3
58z173u8h1kxcselect count(*) as recordscount from orders t where t.bookuser='580008619967' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')
5ansr7r9htpq3update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
5f0955qkz78g4select DOMESTICINDICATE from orders where orderno = :1
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5q9n2yy5aj6hvselect count(*) as orderstatustotail from (select od.orderno, od.domesticindicate, od.status, od.campaignscriptid, fp.totalpaymoney, to_char(od.createdate, 'yyyy-MM-dd') as createdate from orders od, flightpricedomestic fp, segment sm where (od.bookuser in ('13875098898' , '13875098898' , '' )) and od.orderno = fp.orderno and sm.orderno = od.orderno and od.enterpricetype IS NULL and od.createdate >= to_date('2013-05-09', 'yyyy-MM-dd') AND (((1 = 1 and (od.status in ('C', 'P', 'L', 'M'))) or (1=2 and (od.status in ('B', 'T'))) or (1=3 and od.status in ('O', 'R', 'E')) or (1=4 and od.status='D'))) AND od.groupflag='0' group by od.orderno, od.status, fp.totalpaymoney, od.createdate, od.domesticindicate, od.campaignscriptid order by od.createdate desc ) od where rownum < 101
5s3uwrd1gxt7qSELECT NVL(AG.AGENTTYPE, OU1.FLAG) ouType, OU1.NAME AGENTNAME, (SELECT CL.ALIASNAME FROM CITYLIST CL WHERE CL.LOCALE = 'zh' AND CL.CODE = OU1.CITY) AS CITY, (SELECT OU2.NAME FROM ORGANIZATIONUNITPROFILE OU2 WHERE OU2.ORGUNITGUID = OU1.PARENTGUID) AS PARENTNAME, AG.PURCHASAGENT AS AGENT FROM ORGANIZATIONUNITPROFILE OU1, ORDERS O, AGENTPROFILE AG WHERE O.BOOKAGENT = OU1.ORGUNITGUID AND AG.ORGUNITGUID(+) = OU1.ORGUNITGUID AND O.ORDERNO = :1
5wsn90a3fjnmjUPDATE batchpay b SET b.pnrvalid = 'N' WHERE b.orderno IN (SELECT bp.orderno FROM batchpay bp, orders o WHERE bp.orderno = o.orderno AND o.createdate < SYSDATE - 24/24 AND (bp.pnrvalid = 'Y' OR bp.pnrvalid IS NULL)GROUP BY bp.orderno)
67jr1q3uanf6wselect count(*) from orders o where o.bookuser='080009577652' and o.orderflag='C' and o.status='E' and o.createdate>= date'2013-08-06'
69subccxd9b03SELECT signature, inuse_features, flags FROM sql$ WHERE signature = :1
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6u1fc9nj87uhdSELECT S.SEGORDER, (S.CARRIER || S.FLIGHTNO) FLIGHTNO, S.PLANETYPE, S.CABIN, S.DEPTIME FLIGHTDATE, (select a.name from airportslist a where a.code = s.depairport and a.locale = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = s.arrairport and a.locale = 'zh') ARRAIRPORT, to_char(s.deptime, 'HH24MI') DEPTIME, to_char(s.arrtime, 'HH24MI') ARRTIME, s.depairport DEPAIRPORTCODE, s.arrairport ARRAIRPORTCODE, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = S.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG FROM SEGMENT S WHERE S.ORDERNO = :1 ORDER BY S.SEGORDER ASC
6wytwy7ry0jsbUPDATE ORDERS SET TICKETOUTAGENT = BOOKAGENT WHERE ORDERNO = :B1
73fhvwt6xvk2xselect distinct pi.orderno from passengerinfo pi, orders o where pi.sendflag is null and pi.orderno=o.orderno and o.status='D' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')
74mb2gqrm9xb6select c.refaction, c.basiccontext from controlledaction c, (select ca.refaction, min(ca.priority) priority from (select roleid from userrolesmapping where userguid = 'shewangh' union select orgrole.roleid from userprofile users, organizationunitprofile orgrole where users.orgunitguid = orgrole.orgunitguid and (users.userguid ='shewangh') and orgrole.roleid is not null) ur join permissionset ps on ur.roleid = ps.roleid join controlledaction ca on ps.actionid = ca.actionid group by ca.refaction) x where c.refaction = x.refaction and c.priority = x.priority
78txh8n821266select 1 from dual where exists (select 1 from paxinsurance p where p.orderno = :1 )
7jk3kcjxvz83kUPDATE PAYBILL SET PAYSTATUS = PAYSTATUS WHERE BILLNO = :B1 RETURNING PAYSTATUS INTO :O0
7ncnu7ud2ykhuinsert into ORDERS (domesticindicate, orderflag, adultnum, groupname, payreceived, paymoney, childnum, enterpricetype, campaignscriptid, transactor, bookusername, memberno, contact, originalorderno, remarkno, bookagent, seatnum, emailflag, submitpricetime, infantnum, bookagentname, paymode, createdate, deliverstatus, tickettimelimit, shipagent, refbyorder, transactorname, reforder, ticketoutagent, campaigntype, noteflag, attribute5, attribute4, refticket, attribute3, groupflag, attribute2, isautocreate, attribute1, transactorcardno, status, gxhtype, parentorderno, bookuser, orderno) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 )
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7qkh5ucsbcqk6select sum(o.seatnum) from orders o, segment s where o.bookuser='080009577652' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'
7qwgyfxhnaxnaselect originalorderno from orders p where p.orderno='C1307090026705'
81h1tf5rjb8jrselect pt.segorder, p.type, count(*) as refundnum from psgticket pt, passenger p where pt.orderno = p.orderno and pt.psgname = p.psgname and pt.orderno = p.orderno and pt.refundno is not null and pt.orderno = :1 group by pt.segorder, p.type order by pt.segorder, p.type asc
83bank242m66qselect o.campaignscriptid from orders o where o.groupflag = '0' and o.domesticindicate = 1 and o.orderno = 'B1308070079473'
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
87gaftwrm2h68select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
87tu7wk540dwqselect MAX_THREAD_COUNT from partener_interface p where p.partnerid='QQ' and p.interfaceid='AVPRICE_JAXB'
89nf3yvxk8yq7select /*+ rule */ rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name || '.' || o1.name, decode(u.name || '.' || o.name, '.', null, u.name || '.' || o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /*+ ordered */ l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /*+ ordered */ distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null
8kvgs3007httw select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16) <> 16 and nvl(b.bytes, 0) > 0 union select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$tempstat a, sys.v_$tempfile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT) , 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d where a.file#=b.file# and b.ts#=d.ts# and nvl(b.bytes, 0) > 0 union select /*+ rule */ decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, INSTR(b.NAME, '/', -1, 1)+1), substr(b.name, INSTR(b.NAME, '\', -1, 1)+1)) file_file_name, decode(INSTR(b.NAME, '\', -1, 1), 0, substr(b.name, 1, INSTR(b.NAME, '/', -1, 1)-1), substr(b.name, 1, INSTR(b.NAME, '\', -1, 1)-1)) file_file_path, b.NAME file_file_full_name, b.file# file_file_id, d.name file_tablespace, DECODE(d.contents$, 0, (DECODE (BITAND (d.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') file_tbs_contents, a.PHYRDS file_read_requests, a.PHYWRTS file_write_requests, a.PHYBLKRD file_physical_reads, a.PHYBLKWRT file_physical_writes, a.SINGLEBLKRDS file_single_block_reads, a.READTIM/100 file_read_time, a.WRITETIM/100 file_write_time, decode(nvl(a.PHYBLKRD, 0), 0, 0, 10*a.READTIM/a.PHYBLKRD) file_avg_read_time, decode(nvl(a.PHYBLKWRT, 0), 0, 0, 10*a.WRITETIM/a.PHYBLKWRT) file_avg_write_time, decode(nvl(a.PHYBLKRD+a.PHYBLKWRT, 0), 0, 0, 10*(a.READTIM+a.WRITETIM)/(a.PHYBLKRD+a.PHYBLKWRT)) file_avg_io_time, a.SINGLEBLKRDTIM/100 file_single_block_read_time, a.LSTIOTIM/100 file_last_io_time, a.MINIOTIM/100 file_min_single_io_time, a.MAXIORTM/100 file_max_single_read_time, a.MAXIOWTM/100 file_max_single_write_time, decode((c.total_data_io+e.total_temp_io), 0, 0, 100*nvl((a.PHYWRTS+a.PHYRDS), 0)/(c.total_data_io+e.total_temp_io)) file_physical_io_pct, decode((c.total_data_reads+e.total_temp_reads), 0, 0, 100*nvl(a.PHYBLKRD, 0)/(c.total_data_reads+e.total_temp_reads)) file_physical_reads_pct, decode((c.total_data_writes+e.total_temp_writes), 0, 0, 100*nvl(a.PHYBLKWRT, 0)/(c.total_data_writes+e.total_temp_writes)) file_physical_writes_pct from sys.v_$filestat a, sys.v_$datafile b, (select nvl(sum(PHYBLKRD), 0) total_data_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_data_io, nvl(sum(PHYBLKWRT), 0) total_data_writes from sys.V_$FILESTAT) c, (select nvl(sum(PHYBLKRD), 0) total_temp_reads, nvl(sum(PHYBLKRD+PHYBLKWRT), 0) total_temp_io, nvl(sum(PHYBLKWRT), 0) total_temp_writes from sys.V_$TEMPSTAT) e, sys.ts$ d, sys.v_$parameter p where a.file#=b.file# and b.ts#=d.ts# and BITAND (d.flags, 16)=16 and nvl(b.bytes, 0) > 0 and p.name = 'undo_tablespace' and upper(p.value) = upper(d.name)
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8whvjha2fnk63SELECT F.TOTALPRICE, F.AGENTFEE, F.AIRPORTTAX, F.PHASEAGENTFEE, F.PHASEAGENTFEESTART, F.PHASEAGENTFEEEND, F.ENDORSEMENT, F.CHENDORSEMENT, F.INENDORSEMENT, F.FUELTAX, F.FILENO, F.CHFILENO, F.INFILENO, F.ADUSECONDITION, F.CHUSECONDITION, F.INUSECONDITION, F.BIZFEE, F.BIZFEEREMARK, F.TOTALCOST, F.TOTALPAYMONEY, F.BOOKINFO, F.OTHERFEE, F.OTHERFEEREMARK, F.CONFIRMMESSAGE, F.BASISREMARK, F.TOURCODE, F.TOTALMILEAGE, (case when F.TOTALLUGGAGECHARGE is null then 0 else F.TOTALLUGGAGECHARGE end ) as TOTALLUGGAGECHARGE FROM FLIGHTPRICEDOMESTIC F WHERE F.ORDERNO = :1
8zr60wpvdvbtu select /*+index(orders IDX_CREATEDATE_STATUS)*/pnrlist.orderno, pnrlist.pnrno, orders.campaignscriptid , orders.orderflag from orders, pnrlist where orders.orderno = pnrlist.orderno and orders.orderno like '%8' and orders.status in('B', 'T') and orders.createdate>sysdate-30 and ( pnrlist.ticketflag is null or ( Ticketflag = 'P' and (TicketTime is null or (sysdate - tickettime) > 1/48)) or ( Ticketflag = 'T' and (TicketTime is null or (sysdate - tickettime) > 1/288))) and rownum <= 100
90yfsh8rb8gmaselect p.TYPE from paxinsurance p where p.orderno = :1
95bdypfq2ky5gselect o.domesticindicate from orders o where o.orderno = :1
95v76f5muyjjgselect originalorderno from orders p where p.orderno=''
9awmqbn8w5tkqSELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070027006' AND P.ORDERNO='C1308070027006'
9b2r0p9d97p92select sum(t.seatnum) from orders t, segment s where t.bookuser='080009577652' and t.orderno=s.orderno and t.orderflag='C' and t.status in ('D', 'N','S', 'C', 'P') and t.createdate >= date'2013-08-07'
9nz14w8x5fsfdBEGIN PROCESSORDER.CallBackByBank(:1); COMMIT; END;
9nztpwka2vvp4SELECT SP.ORDERNO, SP.SEGORDER, SP.TRANSFERINDICATE, SP.ADULTPRICE, SP.CHILDPRICE, SP.INFANTPRICE, SP.ADULTCOST, SP.CHILDCOST, SP.INFANTCOST, SP.BASICFEERATE, SP.CHBASICFEERATE, SP.INBASICFEERATE, SP.XFEERATE, SP.APPENDFEERATE, SP.PHASEFEERATE, SP.AIRPORTTAX, nvl(SP.ORIGINADULTFUELTAX, 0) ORIGINADULTFUELTAX, nvl(SP.ADULTFUELTAX, 0) ADULTFUELTAX, nvl(SP.CHILDFUELTAX, 0) CHILDFUELTAX, nvl(SP.INFANTFUELTAX, 0) INFANTFUELTAX, SP.ADULTDISPLAYPRICE, SP.CHILDDISPLAYPRICE, SP.INFANTDISPLAYPRICE, SP.ADULTFAREBASIS, SP.CHILDFAREBASIS, SP.INFANTFAREBASIS, sp.adultbaggageallow, sp.childbaggageallow, sp.infantbaggageallow, (SP.CARRIER || SP.FLIGHTNO) FLIGHTNO, (SELECT AP.OPENETICKET FROM AIRPORTSLIST AP WHERE AP.CODE = SP.DEPAIRPORT AND AP.LOCALE = 'zh') AS EFLAG, (select a.name from airportslist a where a.code = SP.DEPAIRPORT AND a.LOCALE = 'zh') DEPAIRPORT, (select a.name from airportslist a where a.code = SP.ARRAIRPORT AND a.LOCALE = 'zh') ARRAIRPORT, to_char(SP.FLIGHTDATE, 'HH24:MI') DEPTIME, to_char(SP.ARRTIME, 'HH24:MI') ARRTIME, SP.DEPAIRPORT DEPAIRPORTCODE, SP.ARRAIRPORT ARRAIRPORTCODE, SP.CABIN, SP.FLIGHTDATE FROM SEGMENTPRICE SP WHERE SP.ORDERNO = :1 ORDER BY SP.SEGORDER ASC
9q7k9nbpvk8pvSELECT NVL(SUM(TIME_WAITED/1000), 0) FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY S, SYS.WRH$_SEG_STAT_OBJ SO, SYS.WRM$_SNAPSHOT SN , SYS.OBJ$ OBJ WHERE SN.SNAP_ID = S.SNAP_ID AND SN.DBID = S.DBID AND SN.BEGIN_INTERVAL_TIME >= (CURRENT_TIMESTAMP - NUMTODSINTERVAL(30, 'day')) AND S.CURRENT_OBJ# = SO.OBJ# AND S.WAIT_CLASS = 'User I/O' AND S.WAIT_TIME = 0 AND SO.DATAOBJ# = :B1 AND OBJ.OBJ# = SO.OBJ# AND OBJ.DATAOBJ# = SO.DATAOBJ#
9tzrcb1d5f06zSELECT O.ORDERNO, O.GROUPFLAG, O.GROUPNAME, o.CAMPAIGNSCRIPTID, O.TRANSACTOR, O.CONTACT, O.BOOKAGENT, O.BOOKAGENTNAME, O.STATUS, O.CREATEDATE, O.REFORDER, O.REFBYORDER, O.REFTICKET, O.ADULTNUM, O.CHILDNUM, O.INFANTNUM, nvl(O.Isautocreate, '0') Isautocreate , O.ORIGINALORDERNO, O.ORDERFLAG, O.CAMPAIGNSCRIPTID, O.ATTRIBUTE2, O.ATTRIBUTE1 FROM ORDERS O WHERE O.ORDERNO = :1
9upvznnp7xgsjSELECT BG.BANKGATEWAYNAME AS bank, PS.LARGECLIENTID AS bigClientCode, PB.BILLNO AS billNo, OD.ORDERNO AS bookTktNum, PB.CURRENCY AS currency, case when od.groupflag='1' then 'Y' else 'N' end as GroupFlag FROM ORDERS OD , ( SELECT PT.PSGNAME AS PSGNAME, PT.ORDERNO AS ORDERNO FROM PSGTICKET PT WHERE PT.TICKETNO = :1 AND ROWNUM = 1) TICKET , PASSENGER PS , PAYMENT PY , PAYBILL PB , BANKGATEWAY BG WHERE OD.ORDERNO = TICKET.ORDERNO AND OD.ORDERNO = PS.ORDERNO AND PS.ORDERNO = TICKET.ORDERNO AND PS.PSGNAME = TICKET.PSGNAME AND OD.ORDERNO = PY.ORDERNO AND PY.BILLNO = PB.BILLNO AND PB.PAYSTATUS='P' AND BG.BANKGATEWAYCODE = PB.BANKGATEWAYCODE
a7pqvnr44uy38SELECT HO.PAYMONEY, HO.HOTELORDERNO, HO.PAYTYPE , CASE HO.PAYTYPE WHEN 'C' THEN '前台现付' ELSE '网上支付' END AS PAYTYPEINFO , CASE WHEN HO.PAYTYPE = 'C' THEN F.TOTALPAYMONEY WHEN HO.PAYTYPE = 'E' AND O.PAYMONEY IS NULL THEN F.TOTALPAYMONEY + HO.PAYMONEY ELSE O.PAYMONEY END AS ORDERPAYMONEY FROM HOTELORDERS HO , FLIGHTPRICEDOMESTIC F , ORDERS O WHERE HO.ORDERNO = F.ORDERNO AND O.ORDERNO = HO.ORDERNO AND HO.ORDERNO = :1
ab5gtgnqyskp7select o.campaignscriptid from orders o where o.orderno = :1
am19a1bvysghhselect (jj.act_jobs_jobs + js.act_jobs_sched) + 0 active_job_proc, greatest (wj.due_jobs + ws.due_sched - jj.act_jobs_jobs - js.act_jobs_sched, 0) + 0 jobs_waiting, greatest (tj.tot_jobs_jobs + ts.tot_jobs_sched - jj.act_jobs_jobs - js.act_jobs_sched - wj.due_jobs - ws.due_sched, 0) + 0 idle_job_procs, (tj.tot_jobs_jobs + ts.tot_jobs_sched) + 0 total_job_procs from (select /*+RULE*/ count(*) tot_jobs_jobs from SYS.dba_jobs) tj, (select /*+RULE*/ count(*) tot_jobs_sched from SYS.dba_scheduler_jobs) ts, (select /*+RULE*/ count(*) act_jobs_jobs from SYS.dba_jobs_running) jj, (select /*+RULE*/ count(*) act_jobs_sched from SYS.dba_scheduler_running_jobs) js, (select /*+RULE*/ count(*) due_jobs FROM SYS.dba_jobs WHERE next_date > sysdate-365 and next_date < sysdate) wj, (select /*+RULE*/ count(*) due_sched FROM SYS.dba_scheduler_jobs WHERE next_run_date > sysdate-365 and next_run_date < sysdate) ws
az33m61ym46y4SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
b0d1f3vqvdca7select /*+ rule */ rownum, sid, serial, locking_sid, locking_serial, lock_type, lock_mode, lock_request_mode, object_wanted, instance, host, pid, db_user, os_user, client_machine, program, blocked_sql_hash, blocked_sql, lock_event, seconds_in_wait from (select l.sid sid, s.serial# serial, l.locking_sid locking_sid, s1.serial# locking_serial, l.lock_type lock_type, DECODE (l.lock_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_mode, DECODE (l.lock_request_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_request_mode, decode(s.p2text, 'object #', u1.name || '.' || o1.name, decode(u.name || '.' || o.name, '.', null, u.name || '.' || o.name)) object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, s.sql_hash_value blocked_sql_hash, substr(ses.sql_text, 1, 100) blocked_sql, s.event lock_event, s.seconds_in_wait seconds_in_wait from (select /*+ ordered */ l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l1.inst_id inst_id, l2.inst_id locking_inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l, sys.gv_$session s, sys.gv_$session s1, sys.gv_$instance i, SYS.obj$ o, sys.obj$ o1, SYS.user$ u, SYS.user$ u1, sys.gv_$sql ses where l.sid = s.sid and l.locking_sid = s1.sid and u.user#(+) = o.owner# and u1.user#(+) = o1.owner# and o.obj#(+) = s.row_wait_obj# and o1.obj#(+) = s.p2 and s.sql_hash_value = ses.hash_value(+) and s.inst_id = l.inst_id and i.inst_id = l.inst_id and s1.inst_id = l.locking_inst_id union select lc.locking_sid sid, s.serial# serial, null locking_sid, null locking_serial, null lock_type, null lock_mode, null lock_request_mode, null object_wanted, i.instance_name instance, i.host_name host, s.process pid, s.username db_user, s.osuser os_user, RTRIM(s.machine, chr(0)) client_machine, s.program program, null blocked_sql_hash, null blocked_sql, null lock_event, null seconds_in_wait from (select /*+ ordered */ distinct locking_sid, null, null, null, null, inst_id from ( select l1.sid sid, l2.sid locking_sid, l1.type lock_type, l2.lmode lock_mode, l1.request lock_request_mode, l2.inst_id inst_id from sys.gv_$lock l1, sys.gv_$lock l2 where l2.block > 0 and l2.lmode > 0 and l1.request > 0 and l1.type = l2.type and l1.id1 = l2.id1 and l1.id2 = l2.id2 and l1.type in ('TX', 'TM')) l where not exists (select 1 from sys.gv_$lock where sid=l.locking_sid and inst_id=l.inst_id and request > 0 and type in ('TX', 'TM'))) lc, sys.gv_$session s, sys.gv_$instance i where lc.locking_sid = s.sid and s.inst_id = lc.inst_id and i.inst_id = lc.inst_id) where seconds_in_wait > :1 or locking_sid is null
bhvwd3sbwdygaselect f.isautoconfirm from flightpricedomestic f where f.orderno = :1
bhwz3x2mjy7s3SELECT PL.PNRNO FROM PNRLIST PL WHERE PL.ORDERNO = :1
bs6q10hmtbh49select bs.billno, bs.bankflowid, bs.paymoney, bs.bankgatewaycode, bs.bankcode, bs.orderstatus status from banksettleorder bs where bs.orderstatus in ('A', 'B', 'C') and bs.settlestatus is null and bs.bankgatewaycode ='CMB' and bs.errcount < 5 order by bs.errcount, bs.billno asc
bt51szvfrcdpnSELECT obj_type, plan_id, comp_data FROM sqlobj$data WHERE signature = :1 AND category = :2
btrs48n39rhcdselect cd.CCRDNO, cd.item, cd.orderno, c.changetype from callcenterdatarecord cd, change c where cd.status='S' and cd.flag='W' and c.status='E' and cd.item=c.changeno and cd.orderno=c.orderno
bunvx480ynf57SELECT 1 FROM DUAL
buzp8cfu6uprySELECT C.CHANGENO, C.ORDERNO, C.CHANGETYPE, C.STATUS, C.CREATETIME, C.DEALTIME, C.SUBMITUSERNAME, C.BOOKAGENTNAME FROM CHANGE C WHERE C.DOMESTICINDICATE='0' AND ROWNUM <= 500 AND ROWNUM <= 301 AND C.CREATETIME >= to_date('2013-08-06', 'yyyy-MM-dd') AND C.CREATETIME <= to_date('2013-08-07', 'yyyy-MM-dd') + 1 AND C.STATUS = ( CASE 'S' WHEN 'A' THEN 'F' ELSE 'S' END ) AND 1=1 ORDER BY C.CREATETIME DESC
c5jycdptb6cj3select sum(o.seatnum) from orders o, segment s where o.bookuser='580008619967' and o.orderno=s.orderno and o.status='D' and s.cabin in ('R', 'O', 'X', 'N') and o.createdate>= date'2013-08-06'
c6ksc6kfhjjc6with ash_samples as ( SELECT /*+ full(@SEL$2383FF78, ASH@SEL$2) */ sample_id, ash.instance_number instance_id, sql_id, sql_exec_id, sample_time FROM DBA_HIST_ACTIVE_SESS_HISTORY ash, V$DATABASE db, DBA_HIST_SNAPSHOT s WHERE ash.dbid = (select dbid from V$DATABASE) AND mod(ash.sample_id, :1) = 0 AND ash.snap_id = s.snap_id AND ash.dbid = s.dbid AND ash.instance_number = s.instance_number AND s.end_interval_time > (TO_TIMESTAMP(:2, 'YYYY-MM-DD HH24:MI:SS:FF6') at TIME ZONE dbtimezone) - 7 ) SELECT total_exec_count, activity_rate, activity_rate_over FROM (SELECT sum(exec_cnt)+1 total_exec_count FROM ( SELECT (case when next_exec_id>sql_exec_id then (next_exec_id - sql_exec_id) else 0 end) exec_cnt FROM ( SELECT sql_exec_id, lead(sql_exec_id, 1, 0) over (partition by instance_id order by sample_time NULLS last) next_exec_id FROM ash_samples WHERE sql_id = :3 ) ) ) sql_count_query, (SELECT sql_count/sample_total activity_rate FROM ( SELECT count(*) sample_total, sum(case when sql_id=:4 then 1 else 0 end) sql_count FROM ash_samples ) ) sql_activity_query, (SELECT over_count/ash_sample_count activity_rate_over FROM ( SELECT count(*) ash_sample_count, sum(case when total >= s.value*2 then 1 else 0 end) over_count FROM ( SELECT instance_id, count(*) total, sum(case when sql_id=:5 then 1 else 0 end) sql_count FROM ash_samples a GROUP BY a.sample_id, a.instance_id ) t, gv$osstat s where t.instance_id = s.inst_id and s.stat_name = 'NUM_CPUS' and t.sql_count > 0 ) ) sql_activity_over_2cpu_query
ckg1n91hh2qkkselect o.pricefileno from flightpricedomestic o where o.orderno = :1
ckh0xnga85szgselect * from ( select /*+USE_NL(orders, f)*/ orders.orderno, orders.status, orders.groupflag, f.totalcost, f.fileno, orders.contact, orders.adultnum as adultnum, orders.childnum, orders.infantnum, orders.bookagentname from orders, flightpricedomestic f where orders.orderno = f.orderno and orders.domesticindicate = '1' and orders.createdate >= to_date( '2013-08-07', 'yyyy-MM-dd') AND orders.createdate <= to_date( '2013-8-7', 'yyyy-MM-dd') + 1 and 1=1 and 1=1 and orders.bookagent in (select orgunitguid from organizationunitprofile start with orgunitguid = '7939' connect by parentguid = prior orgunitguid) order by orders.orderno desc) tem where rownum <= :1
d4ggk0agny9tfSET TRANSACTION READ WRITE
d6fwfwn6jjbsbselect distinct pi.orderno, o.contact, o.campaignscriptid, o.domesticindicate, ho.paytype from passengerinfo pi, orders o, hotelorders ho where pi.sendflag is null and pi.orderno=o.orderno and o.orderno=ho.orderno(+) and o.status='E' and o.createdate>to_date('2013-08-06', 'yyyy-mm-dd') and o.createdate<to_date('2013-08-08', 'yyyy-mm-dd')
dugh7uyrn80b4select * from( select /*+ index(c IX_CHANGE_STATUS_CHANGETYPE) */ c.changeno , c.orderno from change c where c.changetype = 'F' and ( ( substr(c.orderno, 1, 1) = 'C' and c.status = 'H' and c.changestyle = '自愿' ) or ( substr(c.orderno, 1, 1) = 'B' and ( ( c.status = 'V' and c.needpayment = 0 ) or ( c.status = 'H' and c.needpayment = 1 ) ) and c.autoPass is not null ) ) and c.createtime > sysdate - 7 order by c.createtime ) ch where rownum <= 5
f4uf0u8q871jsselect min(pt.ticketno) as minTicketno, max(pt.ticketno)as maxTicketno, pl.tickettime from psgticket pt, pnrlist pl where pt.orderno = :1 and pt.orderno = pl.orderno and pl.ticketflag = 'S' group by pt.carrier, pl.tickettime
fmbv2fxj0mwuyDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN session_mon; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fp1vatugjfuymSELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070028285' AND P.ORDERNO='C1308070028285'
fr6m3gyy3gwk7UPDATE PNRLIST SET TICKETFLAG = TICKETFLAG WHERE ORDERNO = :B2 AND PNRNO = :B1 RETURNING TICKETFLAG INTO :O0
ftj9uawt4wwzbselect condition from cdef$ where rowid=:1
g128myz1mz13nselect 1 from dual where exists (select 1 from orders o where o.orderno = :1 and o.orderflag='C' )
g3yjdvgd23b85select p.orderno, o.bookUser from payment p, orders o where o.orderno=p.orderno and p.billno = 'CCB020130807794444' and o.bookagent='HR'
gyudauqxd8gqcselect ag.ORGAREA ORGAREA from agentarea ag where ag.orgunitguid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count8,3982.330.04
Batched IO (full) vector count8,7132.410.05
Batched IO (space) vector count00.000.00
Batched IO block miss count206,36257.181.10
Batched IO buffer defrag count6770.190.00
Batched IO double miss count23,5646.530.13
Batched IO same unit count49,57213.740.26
Batched IO single block count15,0004.160.08
Batched IO slow jump count4,4991.250.02
Batched IO vector block count149,65641.470.80
Batched IO vector read count4,2071.170.02
Block Cleanout Optim referenced3,1610.880.02
CCursor + sql area evicted3,2330.900.02
CPU used by this session860,457238.424.59
CPU used when call started540,454149.752.88
CR blocks created31,3168.680.17
Cached Commit SCN referenced581,589161.153.10
Clusterwide global transactions160.000.00
Clusterwide global transactions spanning RAC nodes00.000.00
Commit SCN cached10,2602.840.05
DB time27,813,4177,706.64148.22
DBWR checkpoint buffers written61,14316.940.33
DBWR checkpoints1420.040.00
DBWR fusion writes19,8305.490.11
DBWR object drop buffers written2070.060.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written1,7370.480.01
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes1,0620.290.01
DBWR undo block writes42,12111.670.22
DFO trees parallelized7980.220.00
DX/BB enqueue lock background get time140.000.00
DX/BB enqueue lock background gets320.010.00
DX/BB enqueue lock foreground requests2930.080.00
DX/BB enqueue lock foreground wait time140.000.00
Effective IO time456,636,087126,526.272,433.38
GTX processes spawned by autotune00.000.00
GTX processes stopped by autotune00.000.00
HSC Heap Segment Block Changes350,28397.061.87
HSC IDL Compressed Blocks10,2802.850.05
Heap Segment Array Inserts5,5401.540.03
LOB table id lookup cache misses30.000.00
Misses for writing mapping00.000.00
Number of read IOs issued58,50416.210.31
PX local messages recv'd7,5032.080.04
PX local messages sent7,5032.080.04
PX remote messages recv'd6,9931.940.04
PX remote messages sent2,5180.700.01
Parallel operations not downgraded8320.230.00
RowCR - row contention8710.240.00
RowCR attempts119,40233.080.64
RowCR hits175,40048.600.93
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink170.000.00
SQL*Net roundtrips to/from client5,032,2191,394.3426.82
SQL*Net roundtrips to/from dblink00.000.00
active txn count during cleanout88,67924.570.47
application wait time163,87245.410.87
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts45,31412.560.24
branch node splits100.000.00
buffer is not pinned count395,940,462109,708.522,109.94
buffer is pinned count2,626,739,530727,825.8613,997.71
bytes received via SQL*Net from client399,822,877110,784.272,130.63
bytes received via SQL*Net from dblink00.000.00
bytes sent via SQL*Net to client575,775,729159,537.883,068.27
bytes sent via SQL*Net to dblink00.000.00
calls to get snapshot scn: kcmgss1,965,949544.7310.48
calls to kcmgas627,556173.893.34
calls to kcmgcs304,01584.241.62
cell physical IO interconnect bytes157,821,641,21643,729,753.16841,020.18
change write time2,6080.720.01
cleanout - number of ktugct calls50,26813.930.27
cleanouts and rollbacks - consistent read gets27,7027.680.15
cleanouts only - consistent read gets10,3352.860.06
cluster key scan block gets189,38652.481.01
cluster key scans127,26335.260.68
cluster wait time435,640120.712.32
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed30,3048.400.16
commit batch/immediate requested30,3048.400.16
commit cleanout failures: block lost2,4270.670.01
commit cleanout failures: buffer being written70.000.00
commit cleanout failures: callback failure2,1080.580.01
commit cleanout failures: cannot pin4050.110.00
commit cleanouts316,32187.651.69
commit cleanouts successfully completed311,37486.281.66
commit immediate performed30,3048.400.16
commit immediate requested30,3048.400.16
commit txn count during cleanout74,87420.750.40
concurrency wait time24,480,5116,783.14130.45
consistent changes189,63552.541.01
consistent gets582,807,476161,486.263,105.74
consistent gets - examination23,295,1006,454.68124.14
consistent gets direct7,394,7562,048.9639.41
consistent gets from cache575,412,712159,437.303,066.33
consistent gets from cache (fastpath)546,227,385151,350.532,910.81
cursor authentications29,2168.100.16
data blocks consistent reads - undo records applied86,58623.990.46
db block changes1,928,183534.2710.28
db block gets2,463,964682.7213.13
db block gets direct24,1486.690.13
db block gets from cache2,439,816676.0313.00
db block gets from cache (fastpath)579,645160.613.09
deferred (CURRENT) block cleanout applications96,89226.850.52
dirty buffers inspected11,4173.160.06
enqueue conversions21,6716.000.12
enqueue deadlocks00.000.00
enqueue releases1,232,526341.516.57
enqueue requests1,234,446342.046.58
enqueue timeouts1,6750.460.01
enqueue waits4,9691.380.03
exchange deadlocks7910.220.00
execute count1,873,145519.029.98
failed probes on index block reclamation30.000.00
file io service time00.000.00
file io wait time7,120,899,1291,973,082.7737,946.76
frame signature mismatch00.000.00
free buffer inspected12,050,0423,338.8764.21
free buffer requested12,252,9493,395.0965.30
gc blocks compressed176,83149.000.94
gc blocks lost10.000.00
gc cr block flush time7,7002.130.04
gc cr block receive time116,33332.230.62
gc cr blocks received165,68245.910.88
gc cr blocks served149,31241.370.80
gc current block flush time1,4740.410.01
gc current block pin time1,5890.440.01
gc current block receive time142,99139.620.76
gc current blocks received471,421130.622.51
gc current blocks served225,47362.471.20
gc kbytes saved526,155145.792.80
gc kbytes sent2,472,116684.9813.17
gc local grants10,677,4522,958.5456.90
gc remote grants900,438249.504.80
gcs messages sent2,640,237731.5714.07
ges messages sent140,07738.810.75
global enqueue get time18,255,8715,058.4097.28
global enqueue gets async26,7337.410.14
global enqueue gets sync2,069,190573.3411.03
global enqueue releases2,065,191572.2311.01
heap block compress4,9371.370.03
hot buffers moved to head of LRU3,321,922920.4517.70
immediate (CR) block cleanout applications38,03910.540.20
immediate (CURRENT) block cleanout applications26,7387.410.14
index crx upgrade (positioned)1770.050.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)5,2611.460.03
index fetch by key13,922,4713,857.6974.19
index scans kdiixs1113,335,04231,403.26603.95
leaf node 90-10 splits3940.110.00
leaf node splits1,7720.490.01
lob reads22,1896.150.12
lob writes21,1425.860.11
lob writes unaligned21,1425.860.11
logons cumulative2,6090.720.01
max cf enq hold time150.000.00
messages received230,69463.921.23
messages sent230,69263.921.23
min active SCN optimization applied on CR12,9643.590.07
no buffer to keep pinned count1,2920.360.01
no work - consistent read gets557,765,121154,547.442,972.29
non-idle wait count16,809,7454,657.7089.58
non-idle wait time26,755,1237,413.40142.58
opened cursors cumulative1,856,187514.329.89
parse count (describe)800.020.00
parse count (failures)2,7130.750.01
parse count (hard)181,42250.270.97
parse count (total)1,471,425407.717.84
parse time cpu65,23818.080.35
parse time elapsed22,706,0436,291.47121.00
physical read IO requests1,407,675390.047.50
physical read bytes154,664,296,44842,854,905.41824,194.91
physical read total IO requests1,448,535401.367.72
physical read total bytes155,749,903,36043,155,709.04829,980.03
physical read total multi block requests145,45340.300.78
physical reads18,879,9195,231.31100.61
physical reads cache11,484,8033,182.2561.20
physical reads cache prefetch10,382,9602,876.9555.33
physical reads direct7,395,1162,049.0639.41
physical reads direct (lob)570.020.00
physical reads direct temporary tablespace3600.100.00
physical reads prefetch warmup00.000.00
physical write IO requests56,99215.790.30
physical write bytes1,068,777,472296,140.475,695.44
physical write total IO requests206,01057.081.10
physical write total bytes2,071,737,856574,044.1211,040.14
physical write total multi block requests3,5550.990.02
physical writes130,46636.150.70
physical writes direct24,5086.790.13
physical writes direct (lob)630.020.00
physical writes direct temporary tablespace14,0773.900.08
physical writes from cache105,95829.360.56
physical writes non checkpoint108,65630.110.58
pinned buffers inspected5380.150.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use1,385,663383.947.38
process last non-idle time3,6011.000.02
queries parallelized6790.190.00
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls3,251,237900.8617.33
recursive cpu usage366,098101.441.95
redo KB read446,714123.782.38
redo blocks checksummed by FG (exclusive)101,01127.990.54
redo blocks written743,743206.083.96
redo buffer allocation retries40.000.00
redo entries1,040,517288.315.54
redo log space requests50.000.00
redo log space wait time140.000.00
redo ordering marks41,50211.500.22
redo size331,664,03691,898.591,767.41
redo size for direct writes9,002,3282,494.4047.97
redo subscn max counts8,1422.260.04
redo synch long waits25,0556.940.13
redo synch time123,38134.190.66
redo synch time (usec)1,233,929,845341,901.456,575.52
redo synch writes85,82123.780.46
redo wastage36,854,35610,211.73196.39
redo write broadcast ack count67,80918.790.36
redo write broadcast ack time166,052,60346,010.42884.88
redo write broadcast lgwr post count60.000.00
redo write time37,55610.410.20
redo writes137,32638.050.73
remote Oradebug requests20.000.00
rollback changes - undo records applied57,34115.890.31
rollbacks only - consistent read gets5,0541.400.03
root node splits00.000.00
rows fetched via callback2,327,270644.8512.40
scheduler wait time483,092133.862.57
session connect time00.000.00
session cursor cache hits574,724159.253.06
session logical reads585,271,612162,169.033,118.87
shared hash latch upgrades - no wait1,384,504383.627.38
shared hash latch upgrades - wait1,3430.370.01
sorts (disk)00.000.00
sorts (memory)2,121,094587.7211.30
sorts (rows)247,241,83168,506.601,317.53
sql area evicted155,26243.020.83
sql area purged2,3130.640.01
summed dirty queue length13,8343.830.07
switch current to new buffer16,1284.470.09
table fetch by rowid1,446,745,530400,869.147,709.60
table fetch continued row1,123,295311.255.99
table scan blocks gotten151,893,78542,087.24809.43
table scan rows gotten12,220,678,9073,386,146.9765,123.12
table scans (cache partitions)00.000.00
table scans (direct read)610.020.00
table scans (long tables)4100.110.00
table scans (rowid ranges)00.000.00
table scans (short tables)128,22235.530.68
temp space allocated (bytes)5,242,8801,452.7127.94
total cf enq hold time7,5352.090.04
total number of cf enq holders3750.100.00
total number of slots00.000.00
total number of times SMON posted7550.210.00
transaction lock background gets4500.120.00
transaction lock foreground requests4500.120.00
transaction lock foreground wait time660.020.00
transaction rollbacks30,1358.350.16
transaction tables consistent read rollbacks120.000.00
transaction tables consistent reads - undo records applied2980.080.00
undo change vector size114,458,67231,714.60609.94
user I/O wait time721,578199.943.85
user calls5,543,5341,536.0229.54
user commits58,56716.230.31
user rollbacks129,08835.770.69
workarea executions - onepass40.000.00
workarea executions - optimal1,513,090419.258.06
write clones created in background10.000.00
write clones created in foreground220.010.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max378,553,070,208379,508,273,712
session cursor cache count31,506,37131,535,369
session uga memory279,034,938,040,344279,206,950,168,384
opened cursors current3,6735,221
workarea memory allocated3,9292,428
logons current559818
session uga memory max3,512,199,929,5523,519,418,778,536
session pga memory281,321,954,688282,266,448,016

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)11.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Buffer Cache Reads87.5G373.7124.82720M0.000M1101.4K5.69
Direct Reads56.4G16.2116.00041M0.00.0002770 
Others1G11.33.287058630M2.98.17456245.5K2.69
DBWR0M0.000M830M15.54.2299790 
LGWR0M0.000M363M38.37.100581137.3K2.26
Direct Writes0M0.000M155M0.20.0429470 
TOTAL:144.9G401.2541.11471.9G57.09.5483481284.3K5.22

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 File143.7G391.0040.7772914M15.66.2532543.6236.76
Log File437M0.12.121085362M38.36.10030420.0042.15
Control File566M10.02.156829157M2.78.0435022.74176.00
Archive Log0M0.000M436M0.12.120808  
Temp File190M0.09.052645110M0.14.03047910.4115.43
Other0M0.010M0M0.020M0.08 
TOTAL:144.9G401.2441.10781.9G57.09.5483483.5936.75

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)
Buffer Cache Reads 87.5G373.6724.81610M0.000M1095.9K5.62
Buffer Cache Reads (Data File) 87.5G373.6724.81610M0.000M1095.9K5.62
Direct Reads 56.3G16.1715.96331M0.00.0002770 
Direct Reads (Data File) 56.3G16.1715.96331M0.00.0002770 
Others 1G11.32.287058630M2.97.17456240.4K2.69
Others (Control File) 566M10.02.156829157M2.78.04350236.2K2.75
Others (Archive Log) 0M0.000M436M0.12.1208080 
Others (Log File) 436M0.12.1208080M0.000M429.75
Others (Data File) 34M1.18.00942037M0.07.01025242692.14
DBWR 0M0.000M830M15.54.2299790 
DBWR (Data File) 0M0.000M830M15.54.2299790 
LGWR 0M0.000M363M38.37.100581191.58
LGWR (Log File) 0M0.000M362M38.36.10030440.75
LGWR (Control File) 0M0.000M1M0.01.000277151.80
Direct Writes 0M0.000M155M0.20.0429470 
Direct Writes (Data File) 0M0.000M155M0.20.0429470 
TOTAL: 144.7G401.1741.06651.9G57.07.5483481136.3K5.51

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
COREDATA 937,3152604.0918.7919,728575,2514.19
CORE_INDEX 164,226466.921.3716,13443,503164.10
USERS 160,301445.943.948,64121,131182.51
SYSAUX 107,678303.993.264,822100.00
SYSTEM 27,17682.901.091,24601,939688.61
QUEST 5,05612.951.301,412000.00
UNDOTBS1 365012.791.004,52211061.51
AMSDATA 2,62512.031.000000.00
ETS_TMP 2,29213.241.000000.00
TEMP 271013.4789.23516000.00
UNDOTBS2 10104.651.00003,35012.05
AMSINDEX 3402.941.000000.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)
AMSDATA+DATADG/COREDB/datafile/amsdata.297.786494983 2,62512.031.000000.00
AMSINDEX+DATADG/COREDB/datafile/amsindex.298.786495075 3402.941.000000.00
COREDATA+DATADG/COREDB/datafile/COREDATA.270.730202259 115,108323.8120.722,01512,2042.98
COREDATA+DATADG/COREDB/datafile/COREDATA.271.730202435 110,347314.0821.532,43413,4733.27
COREDATA+DATADG/COREDB/datafile/COREDATA.272.730202619 119,504333.8320.722,66913,6404.03
COREDATA+DATADG/COREDB/datafile/COREDATA.273.730202791 108,910303.8220.943,01812,7513.50
COREDATA+DATADG/COREDB/datafile/COREDATA.274.730202937 117,246323.8219.102,57113,2203.62
COREDATA+DATADG/COREDB/datafile/COREDATA.283.745515419 112,568313.8920.571,96912,9643.06
COREDATA+DATADG/COREDB/datafile/COREDATA.295.783256433 85,011244.6615.90599015,0613.20
COREDATA+DATADG/COREDB/datafile/COREDATA.296.783257507 82,222234.7116.261,130013,9583.39
COREDATA+DATADG/COREDB/datafile/COREDATA.305.796495117 51,967144.5712.261,795015,3374.52
COREDATA+DATADG/COREDB/datafile/COREDATA.307.803139899 34,432104.716.301,528012,6436.92
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.276.730204269 14,63546.581.321,0680314454.43
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.277.730204109 17,02756.061.281,315017542.11
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.280.730204413 14,80945.961.281,8201438248.90
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.281.730204551 13,05446.101.321,2730119153.36
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.282.730204685 16,11645.401.289890143642.17
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.286.745515665 14,81745.601.31860016233.13
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.291.771353279 14,10146.511.401,92515952.71
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.292.771353509 8,91427.231.645650215425.12
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.293.783255523 12,96747.951.381,30502415.83
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.294.783255951 11,87238.121.381,423091419.65
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.302.796411061 9,19639.011.49832023764.68
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.303.796493979 8,99029.481.531,780029345.22
CORE_INDEX+DATADG/COREDB/datafile/CORE_index.306.803129617 7,72829.661.509790556108.83
ETS_TMP+DATADG/COREDB/datafile/ets_tmp.275.730287209 2,29213.241.000000.00
QUEST+DATADG/COREDB/datafile/quest.289.748266187 5,05612.951.301,412000.00
SYSAUX+DATADG/COREDB/datafile/sysaux.260.729362609 91,935253.702.864,425100.00
SYSAUX+DATADG/COREDB/datafile/sysaux.301.787835057 15,74345.685.59397000.00
SYSTEM+DATADG/COREDB/datafile/system.259.729362599 27,17682.901.091,24601,939688.61
TEMP+DATADG/COREDB/tempfile/temp.262.729362685 271013.4789.2351600 
UNDOTBS1+DATADG/COREDB/datafile/undotbs1.261.744737439 365012.791.004,52211061.51
UNDOTBS2+DATADG/COREDB/datafile/undotbs2.263.744738251 10104.651.00003,35012.05
USERS+DATADG/COREDB/datafile/users.264.730203979 21,80767.034.161,242023085.61
USERS+DATADG/COREDB/datafile/users.278.730203631 23,92675.683.761,743098404.49
USERS+DATADG/COREDB/datafile/users.279.730203813 24,12575.913.751,48006867.21
USERS+DATADG/COREDB/datafile/users.287.733311617 24,57576.733.821,0290471117.26
USERS+DATADG/COREDB/datafile/users.288.733311861 21,74766.854.599410218390.55
USERS+DATADG/COREDB/datafile/users.290.745515943 20,48366.934.4494202829.64
USERS+DATADG/COREDB/datafile/users.300.787832331 8,09122.964.3261401320.00
USERS+DATADG/COREDB/datafile/users.304.796494633 7,57222.993.298406143.33
USERS+DATADG/COREDB/datafile/users.308.803140519 7,97522.322.0956601112.73

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
D1,833,22098577,545,03011,486,185105,9580085,302

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000059,4060

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
B038124623803557322488320355732  2
E028147648682849712488320284971  2

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
D1,5360.1018152.4496,362,7131644172644.00
D3,0720.2036329.5354,270,8231360324790.00
D4,6080.3054416.7230,721,0601201516255.00
D6,1440.407269.3417,167,9901110120743.00
D7,6800.499075.159,457,025158121632.00
D9,2160.591,0892.995,491,581131380549.00
D10,7520.691,2701.953,589,452118553488.00
D12,2880.791,4521.442,646,158112192362.00
D13,8240.891,6331.172,151,21318854681.00
D15,3600.991,8141.011,861,44516900622.00
D15,5521.001,8371.001,837,68616740409.00
D16,8961.091,9960.911,671,37815618903.00
D18,4321.192,1770.831,533,53414689348.00
D19,9681.282,3590.781,427,79213976271.00
D21,5041.382,5400.731,344,36913413707.00
D23,0401.482,7220.691,275,18012947131.00
D24,5761.582,9030.661,217,46312557914.00
D26,1121.683,0840.631,165,25412205842.00
D27,6481.783,2660.611,119,15211894953.00
D29,1841.883,4470.591,078,68711622072.00
D30,7201.983,6290.561,025,24911261713.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.9650,53419

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)
B6,1443,5483,003.421.740.06100.000.00629,140
E6,1442,9893,885.052.660.07100.000.00629,140

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K1,461,9261,461,92600
64K128K8,8488,84800
128K256K1,2121,21200
256K512K60860800
512K1024K18,36118,36100
1M2M22,03322,03300
2M4M404000
4M8M363240
8M16M313100
16M32M232300
32M64M4400

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
7680.13117,155,307.5244,019,529.2573.002,439,463158,484,161,249
1,5360.25117,155,307.5241,058,806.3274.002,267,102155,572,865,047
3,0720.50117,155,307.52364,238.11100.001,706115,557,657,714
4,6080.75117,155,307.52343,080.02100.000115,536,852,845
6,1441.00117,155,307.52250,273.50100.000115,445,595,652
7,3731.20117,155,307.52245,883.02100.000115,441,278,467
8,6021.40117,155,307.52245,883.02100.000115,441,278,467
9,8301.60117,155,307.52245,883.02100.000115,441,278,467
11,0591.80117,155,307.52245,883.02100.000115,441,278,467
12,2882.00117,155,307.52245,883.02100.000115,441,278,467
18,4323.00117,155,307.52245,883.02100.000115,441,278,467
24,5764.00117,155,307.52245,883.02100.000115,441,278,467
36,8646.00117,155,307.52245,883.02100.000115,441,278,467
49,1528.00117,155,307.52245,883.02100.000115,441,278,467

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)
8,6401.0045931,20563,226,5661.002,555,9501.001,940,877
9,6001.111,36086,65663,302,7471.002,479,7690.973,847,851
10,4961.212,255135,73163,426,1751.002,356,3410.923,868,144
11,3921.323,150185,24063,501,1201.002,281,3960.893,881,581
12,2881.424,046234,47263,543,6041.012,238,9120.883,890,159
13,1841.534,941283,08963,569,5791.012,212,9370.873,896,087
14,0801.635,837332,12763,586,8161.012,195,7000.863,900,494
14,9761.736,733381,38063,599,2921.012,183,2240.853,903,955
15,8721.847,628430,38963,609,0261.012,173,4900.853,906,795
16,7041.938,524478,92263,617,1791.012,165,3370.853,909,228
17,6642.049,420527,76563,624,3501.012,158,1660.843,911,382

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
12,2880.50386,558,49754,270,884,678
15,3600.63136,353,08117,168,021,984
18,4320.7557,613,6535,491,554,462
21,5040.8838,423,3912,646,082,813
24,5761.0032,972,9601,837,685,126
27,6481.1330,846,2051,533,548,238
30,7201.2529,570,1511,344,450,438
33,7921.3828,712,8541,217,466,396
36,8641.5027,855,5571,078,721,169
39,9361.6327,417,0171,025,244,532
43,0081.7527,149,9391,025,244,532
46,0801.8827,110,3711,025,244,532
49,1522.0027,097,1831,025,244,532

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
640.500000
1281.000000
1921.500000
2562.000000
3202.500000
3843.000000
4483.500000
5124.000000
5764.500000
6405.000000
7045.500000
7686.000000
8326.500000
8967.000000
9607.500000
1,0248.000000
1,0888.500000
1,1529.000000
1,2169.500000
1,28010.000000

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)
data block81,2572,36429
system undo header47768143
undo header3,3124012
undo block13915
1st level bmb10001
2nd level bmb2030

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 40940903811,6194,250.21
SQ-Sequence Cache 1,9521,95202901,2464,296.52
US-Undo Segment 25525501173292,811.24
PV-KSV slave startup (syncstart) 2929022914,561.00
TX-Transaction (index contention) 53753703632467.29
CO-KTUCLO Master Slave enq (master slave det) 1,13201,1321,1321916.72
TH-Threshold Chain (metric threshold evaluation) 141141011515,265.00
PR-Process Startup 989802115,471.50
CF-Controlfile Transaction 10,25510,2505352924.89
PS-PX Process Reservation 6,2535,78846598443.89
TD-KTF map table enqueue (KTF dump entries) 11110112211.45
TX-Transaction 97,46897,469123027.84
KO-Multiple Object Checkpoint (fast object checkpoint) 1,4131,413050211.35
TT-Tablespace 15,46415,464014103.31
WF-AWR Flush 4464242222019.50
FB-Format Block 18218208802.26
RO-Multiple Object Reuse (fast object reuse) 14414404304.05
DR-Distributed Recovery 2202080.50
HW-Segment High Water Mark 3,6393,63906801.54
JQ-Job Queue 403641053.00
TO-Temp Object 30930905500.67
CR-Reuse Block Range (block range reuse ckpt) 1,0691,06902101.52
TM-DML 280,486280,441463400.88
TX-Transaction (allocate ITL entry) 292902600.92
OD-Online DDLs (Serializing DDLs) 313101601.44
MD-Materialized View Log DDL 464602300.70
SK-Shrink Segment 323201900.74
PI-Remote PX Process Spawn Status 16160801.25
PE-Parameter 24240601.50
PG-Global Parameter 12120601.00
TK-Auto Task Serialization (Auto Task Serialization) 660601.00
TA-Instance Undo 23230501.00
AF-Advisor Framework (task serialization) 4124120401.00
MW-MWIN Schedule 220201.00
TS-Temporary Segment 18180400.25

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
240.9497,2752,73989180/1800/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
07-8月 22:598,08817,4251,55671800/00/0/0/0/0/0
07-8月 22:497,47918,8932,739891800/00/0/0/0/0/0
07-8月 22:392,4346,5902,092861800/00/0/0/0/0/0
07-8月 22:296,46816,4851,47191800/00/0/0/0/0/0
07-8月 22:196,26618,08386991800/00/0/0/0/0/0
07-8月 22:0910,20019,7991,02691800/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch50.00 00 
ASM Keyed state latch3,8000.340.0000 
ASM allocation8330.00 00 
ASM db client latch10,6020.00 00 
ASM map headers210.00 00 
ASM map load waiting list60.00 00 
ASM map operation freelist10,2720.00 00 
ASM map operation hash table3,461,0700.000.0600 
ASM network background latch2,0920.00 00 
ASM network state latch4370.00 00 
AWR Alerted Metric Element list68,0280.00 00 
Change Notification Hash table latch1,1990.00 00 
Consistent RBA137,3350.000.0000 
DML lock allocation171,563,0180.350.0000 
Event Group Locks2,0340.00 00 
FAL Queue980.00 00 
FIB s.o chain latch300.00 00 
FOB s.o list latch19,1080.260.0000 
File State Object Pool Parent Latch50.00 00 
I/O Staticstics latch50.00 00 
IPC other latch300.00 00 
IPC stats buffer allocation latch6,6020.00 07,5400.08
In memory undo latch50.00 00 
JS Sh mem access130.00 00 
JS broadcast add buf latch16,8910.00 00 
JS broadcast drop buf latch16,8910.00 00 
JS broadcast load blnc latch16,7870.00 00 
JS mem alloc latch120.00 00 
JS queue access latch170.00 00 
JS queue state obj latch604,3320.00 00 
JS slv state obj latch1850.00 00 
KFC FX Hash Latch50.00 00 
KFC Hash Latch50.00 00 
KFCL LE Freelist50.00 00 
KFK SGA Libload latch1,3920.00 00 
KFMD SGA70.00 00 
KGNFS-NFS:SHM structure50.00 00 
KGNFS-NFS:SVR LIST50.00 00 
KJC message pool free list131,5760.120.02029,6620.01
KJCT flow control latch2,454,4670.020.0100 
KMG MMAN ready and startup request latch32,0420.00 00 
KMG resize request state object freelist160.00 00 
KSXR large replies2320.00 00 
KTF sga latch340.00 01,1810.00
KWQMN job cache list latch3620.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch290.00 00 
KWQS pqueue ctx latch590.00 00 
Locator state objects pool parent latch50.00 00 
Lsod array latch24,4860.240.0000 
MQL Tracking Latch0  0710.00
Memory Management Latch31,1210.00 032,0410.00
Memory Queue50.00 00 
Memory Queue Message Subscriber #150.00 00 
Memory Queue Message Subscriber #250.00 00 
Memory Queue Message Subscriber #350.00 00 
Memory Queue Message Subscriber #450.00 00 
Memory Queue Subscriber50.00 00 
MinActiveScn Latch1,2090.00 00 
Mutex50.00 00 
Mutex Stats50.00 00 
OS process5,9060.00 00 
OS process allocation11,3400.080.0000 
OS process: request allocation3,8000.110.0000 
PL/SQL warning settings53,3830.000.0000 
PX hash array latch50.00 00 
QMT50.00 00 
Real-time plan statistics latch22,4750.010.00010.00
Reserved Space Latch40.00 00 
Result Cache: RC Latch110.00 00 
SGA IO buffer pool latch1120.00 01160.00
SGA blob parent50.00 00 
SGA bucket locks50.00 00 
SGA heap locks50.00 00 
SGA pool locks50.00 00 
SQL memory manager latch50.00 03,5490.00
SQL memory manager workarea list latch458,3020.00 00 
Shared B-Tree2860.00 00 
Streams Generic50.00 00 
Testing50.00 00 
Token Manager50.00 00 
WCR: sync50.00 00 
Write State Object Pool Parent Latch50.00 00 
X$KSFQP50.00 00 
XDB NFS Security Latch50.00 00 
XDB unused session pool50.00 00 
XDB used session pool50.00 00 
active checkpoint queue latch40,6940.840.0000 
active service list6,315,2910.020.0501,040,7170.01
alert log latch20.00 00 
archive control3520.00 00 
archive process latch2950.00 00 
begin backup scn array4590.00 00 
buffer pool140.00 00 
business card1,6690.00 00 
cache buffer handles107,8150.010.0000 
cache buffers chains1,179,213,1900.180.01192,405,8220.00
cache buffers lru chain1,855,7550.080.08091,026,8580.06
cache table scan latch354,5970.010.030354,5950.01
call allocation31,0680.110.3700 
cas latch50.00 00 
change notification client cache latch50.00 00 
channel handle pool latch3,8780.340.0000 
channel operations parent latch3,658,4440.000.0600 
checkpoint queue latch3,029,6970.000.020314,7700.00
client/application info20,6720.00 00 
compile environment latch2,6180.00 00 
corrupted undo seg latch202,2720.020.0300 
cp cmon/server latch50.00 00 
cp pool latch50.00 00 
cp server hash latch50.00 00 
cp sga latch3950.00 00 
cvmap freelist lock50.00 00 
deferred cleanup latch3950.00 00 
dml lock allocation4070.00 00 
done queue latch50.00 00 
dummy allocation4,9820.00 00 
enqueue hash chains3,115,9580.020.2003,7080.00
enqueues1,703,6170.040.0100 
error message lists3,9750.030.0000 
fifth spare latch50.00 00 
file cache latch1,2680.00 00 
flashback copy50.00 00 
fourth Audit Vault latch50.00 00 
gc element9,787,5500.070.0503,385,0940.04
gcs commit scn state50.00 00 
gcs opaque info freelist666,2160.030.0000 
gcs partitioned table hash29,313,9810.110.00010,621,5210.00
gcs pcm hashed value bucket hash50.00 00 
gcs remaster request queue830.00 00 
gcs remastering latch4,114,2360.990.0002,7233.38
gcs resource freelist542,8060.020.00081,3040.00
gcs resource hash25,896,4800.010.0104230.00
gcs resource scan list1,0580.00 00 
gcs shadows freelist189,1770.000.000122,2150.00
ges caches resource lists934,1640.030.040458,9280.02
ges deadlock list37,1300.00 053,2920.00
ges domain table4,287,7210.000.0000 
ges enqueue table freelist4,224,7940.010.0200 
ges group table4,151,9840.000.0100 
ges process hash list162,9330.000.4300 
ges process parent latch8,591,1340.000.00010.00
ges process table freelist3,8000.030.0000 
ges resource hash list6,738,7350.030.31387,9330.01
ges resource scan list7,0570.010.0000 
ges resource table freelist115,3850.00 00 
ges timeout list23,2360.160.0804,1410.00
ges value block free list3,4410.00 00 
global KZLD latch for mem in SGA1,6260.00 00 
global tx hash mapping2550.00 00 
granule operation50.00 00 
hash table column usage latch2,0750.100.0005,813,6400.02
hash table modification latch3000.00 00 
heartbeat check50.00 02,5870.12
heartbeat structure management0  07090.00
internal temp table object number allocation latch770.00 00 
interrupt manipulation7,6370.00 00 
intra txn parallel recovery50.00 00 
io pool granule metadata list50.00 00 
job workq parent latch410.00 0360.00
job_queue_processes free list latch770.00 00 
job_queue_processes parameter latch16,8780.00 00 
k2q global data latch2,4750.00 00 
k2q lock allocation3780.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch50.00 00 
kgb parent50.00 00 
kgnfs mount latch50.00 00 
kokc descriptor allocation latch79,3010.00 00 
krbmrosl20.00 00 
ksfv messages50.00 00 
ksim group membership cache2,9250.00 00 
ksim membership request latch3680.00 03,1390.00
kss move lock630.00 00 
ksuosstats global area2580.00 00 
ksv allocation latch5080.00 00 
ksv class latch6,6900.00 00 
ksv instance latch40.00 00 
ksv msg queue latch110.00 060.00
ksxp shared latch3,8000.130.0000 
ksxp so latch3,8000.180.0000 
ksz_so allocation latch3,8000.970.0000 
ktm global data1,5930.00 00 
kwqbsn:qsga1240.00 00 
lgwr LWN SCN154,7890.020.0000 
list of block allocation2,6060.00 00 
loader state object freelist6660.00 00 
lob segment dispenser latch50.00 00 
lob segment hash table latch170.00 00 
lob segment query latch50.00 00 
lock DBA buffer during media recovery50.00 00 
logical standby cache50.00 00 
logminer context allocation60.00 00 
logminer work area50.00 00 
longop free list parent2,1300.00 03100.00
managed standby latch970.00 00 
mapped buffers lru chain50.00 00 
message pool operations parent latch12,3140.00 00 
messages998,4500.090.0000 
mostly latch-free SCN156,2940.820.0000 
msg queue latch50.00 00 
multiblock read objects1,290,3220.020.0300 
name-service memory objects26,1070.00 00 
name-service namespace bucket109,4640.00 00 
name-service pending queue16,0220.00 00 
name-service request520.00 00 
name-service request queue50,1380.00 00 
ncodef allocation latch3950.00 00 
object queue header heap125,5550.00 0124,9090.00
object queue header operation26,655,7650.010.250112,8030.02
object stats modification83,5210.010.22010.00
parallel query alloc buffer17,1520.00 00 
parallel query stats3,1730.00 00 
parallel txn reco latch46,0330.00 00 
parameter list8,8480.030.0000 
parameter table management11,6400.051.0000 
peshm50.00 00 
pesom_free_list50.00 00 
pesom_hash_node50.00 00 
post/wait queue260,1390.020.060128,0010.02
process allocation3,8991.902.2022,0001.45
process group creation3,8000.00 00 
process queue9,1650.00 00 
process queue reference274,4020.010.00024,4742.19
qmn state object latch60.00 00 
qmn task queue latch8371.910.6300 
query server freelists7,5040.00 00 
query server process80.00 090.00
queued dump request120.00 00 
queuing load statistics50.00 00 
recovery domain hash list50.00 00 
redo allocation448,5250.060.0401,039,8700.16
redo copy50.00 01,040,5160.23
redo writing457,0660.040.0000 
reservation so alloc latch20.00 00 
resmgr group change latch3,6280.00 00 
resmgr:active threads37,1290.090.9701,7650.00
resmgr:actses change group2,5870.00 00 
resmgr:actses change state3080.00 00 
resmgr:free threads list5,0030.040.0000 
resmgr:plan CPU method50.00 00 
resmgr:resource group CPU method60.00 00 
resmgr:schema config185,2130.130.9801152.61
resmgr:session queuing50.00 00 
rm cas latch50.00 00 
row cache objects46,324,8280.650.0024,9710.68
rules engine aggregate statistics130.00 00 
rules engine rule set statistics1260.00 00 
second Audit Vault latch50.00 00 
second spare latch50.00 00 
segmented array pool60.00 00 
sequence cache119,7470.020.0000 
session allocation781,6670.010.020776,6950.02
session idle bit11,862,9570.010.0100 
session queue latch50.00 00 
session state list latch5,1870.150.0000 
session switching9,2550.00 00 
session timer1,4670.00 00 
shared pool10,891,8110.100.19140 
shared pool sim alloc50.00 00 
shared pool simulator1,876,5830.010.2100 
sim partition latch50.00 00 
simulator hash latch39,345,4290.000.0200 
simulator lru latch1,9370.210.75038,109,3040.43
sort extent pool1,8110.00 00 
space background state object latch110.00 00 
space background task latch3,5290.200.0002,3940.00
state object free list20.00 00 
statistics aggregation1,5680.00 00 
tablespace key chain5,0900.00 00 
temp lob duration state obj allocation80.00 00 
temporary table state object allocation260.00 00 
test excl. parent l050.00 00 
test excl. parent2 l050.00 00 
third spare latch50.00 00 
threshold alerts latch2200.00 00 
trace latch1280.780.0000 
transaction allocation43,961,8610.130.0100 
transaction branch allocation1,6690.00 00 
undo global data629,2460.040.020160.00
virtual circuit buffers50.00 00 
virtual circuit holder50.00 00 
virtual circuit queues50.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains1,179,213,1902,165,62811,4282,154,705
DML lock allocation171,563,018604,5242,066602,516
row cache objects46,324,828299,994530299,470
transaction allocation43,961,86155,76241255,372
gcs remastering latch4,114,23640,731340,728
shared pool10,891,81110,4762,0018,598
gc element9,787,5506,8993456,573
gcs resource hash25,896,4802,973392,938
object queue header operation26,655,7652,4016071,814
ges resource hash list6,738,7352,2386861,563
cache buffers lru chain1,855,7551,4061061,302
active service list6,315,2911,341611,278
mostly latch-free SCN156,2941,28341,279
messages998,4508693866
simulator hash latch39,345,42983416819
session idle bit11,862,9577975792
enqueue hash chains3,115,958739146594
enqueues1,703,6176415636
KJCT flow control latch2,454,4674765471
ges caches resource lists934,16429711286
redo allocation448,52528310273
ges enqueue table freelist4,224,7942756269
multiblock read objects1,290,3222608252
resmgr:schema config185,2132442404
undo global data629,2462374233
ges group table4,151,9841642162
KJC message pool free list131,5761573154
shared pool simulator1,876,5831172592
process allocation3,8997416329
checkpoint queue latch3,029,69762161
post/wait queue260,13954351
session allocation781,66751150
cache table scan latch354,59740139
ges timeout list23,23637334
call allocation31,068351322
channel operations parent latch3,658,44435233
resmgr:active threads37,12934331
corrupted undo seg latch202,27233132
ASM map operation hash table3,461,07017116
qmn task queue latch83716106
object stats modification83,521927
ges process hash list162,933734
parameter table management11,640660
simulator lru latch1,937431

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation hash tablekffmTranslate011
DML lock allocationktadmc02,0642,027
DML lock allocationktaiam0127
DML lock allocationktaidm0112
KJC message pool free listkjcsmpav: allocate a msg buffer033
KJCT flow control latchkjctcsnd: send normal message033
KJCT flow control latchkjcts_sedeqv2: dequeue a vector of msgs020
active service listkswslogon: session logout0371
active service listkswsite: service iterator0221
active service listkswslogon: session login0151
active service listkswsgetso: get service object0775
active service listkswssetsvc: PX session switch service010
cache buffers chainskcbgtcr: fast path (cr pin)07,4993,332
cache buffers chainskcbgtcr_206,0865,934
cache buffers chainskcbgtcr: kslbegin excl07491,527
cache buffers chainskcbrls_107084,475
cache buffers chainskcbgtcr: fast path0616304
cache buffers chainskcbchg1: kslbegin: bufs not pinned0198165
cache buffers chainskcbzwb0181128
cache buffers chainskcbgcur_209355
cache buffers chainskcbzibmlt: multi-block read: nowait0520
cache buffers chainskcbrls_2039147
cache buffers chainskcbget: pin buffer03332
cache buffers chainskclwrt0260
cache buffers chainskcbchg1: kslbegin: call CR func02577
cache buffers chainskclbla0161
cache buffers chainskclcls_301465
cache buffers chainskcllkopesc092
cache buffers chainskcbgtcr: kslbegin shared074
cache buffers chainskcbbxsv0515
cache buffers chainskcl_fairness051
cache buffers chainskcbgkcbcr045
cache buffers chainskcbzgb: scan from tail. nowait030
cache buffers chainskclcqchk030
cache buffers chainskcbbic2020
cache buffers chainskcbesc: escalate021
cache buffers chainskcbgtcr_1022
cache buffers chainskcbzibmlt: finish free bufs023
cache buffers chainskcbbic1010
cache buffers chainskcbgcur: fast path (shr)010
cache buffers chainskcbnlc017
cache buffers chainskcbxbh010
cache buffers chainskcbzib: finish processing buffer019
cache buffers chainskclevict010
cache buffers chainskcllwr_1010
cache buffers chainskclrlstp011
cache buffers lru chainkcbzgws0790
cache buffers lru chainkcbzgb_20188
cache buffers lru chainkcbw_activate_granule030
cache buffers lru chainkcbzgm030
cache buffers lru chainkcbzgb0247
cache buffers lru chainkcbbic20121
cache table scan latchkcbz_free_table_scan_read_buffer011
call allocationksuxds0123
call allocationksuprc011
channel operations parent latchksrpubwait():1010
channel operations parent latchksrwait()011
checkpoint queue latchkcbkubc_4010
corrupted undo seg latchktudiscorrupted011
enqueue hash chainsksqexpandres01150
enqueue hash chainsksqgtl301239
enqueue hash chainsksqrcl09100
enqueue hash chainsksqcmi: if lk mode not requested061
enqueue hash chainsksqcmi: if lk mode requested024
enqueue hash chainsksqexpandwait021
enqueuesksqdel033
enqueuesksqgel: create enqueue022
gc elementkclbla01862
gc elementkclnfndnewm09063
gc elementkcl_fairness0415
gc elementkclevict0360
gc elementkclchkping0290
gc elementkclulb02884
gc elementkclplz02363
gc elementkclfwrite10176
gc elementkclnfndx01597
gc elementKCLUNLNK0689
gc elementkclwrt062
gc elementkclcqchk0428
gc elementkcl_get_le_latch020
gc elementkclpto_3020
gc elementkclrwrite028
gc elementkclebs012
gc elementkclhngcbk1010
gc elementkclhngcbk1_1010
gc elementkclnfndnew011
gc elementkclpdc_14010
gc elementkclpdcl0123
gc elementkclplz_10111
gcs remastering latchkjfcdrmrfg beginning030
gcs resource hashkjblocalobj_nolock0138
gcs resource hashkjbconvert081
gcs resource hashkjbcropen:affinity041
gcs resource hashkjbassume032
gcs resource hashkjbcrcomplete031
gcs resource hashkjbopen020
gcs resource hashkclfwrite1010
gcs resource hashkclpdc012
gcs resource hashkclrwrite012
gcs resource hashkjbcropen013
gcs resource hashkjblpast011
gcs resource hashkjbmpcreatepi011
ges enqueue table freelistkjlalc: lock allocation034
ges enqueue table freelistkjlfr: remove lock from parent object032
ges group tablekjgagll: move a lock from process lock list to group lock list022
ges process hash listkjakiqa: set inquiry response030
ges resource hash listkjrmas1: lookup master node04972
ges resource hash listkjakcai: search for resp by resname0817
ges resource hash listkjlrlr: remove lock from resource queue059183
ges resource hash listkjucvl: lock convert request028467
ges resource hash listkjlmfnd: search for lockp by rename and inst id0211
ges resource hash listkjrref: find matched resource0636
ges resource hash listkjcvscn: remove from scan queue040
ges resource hash listkjuinq: inquire resource held mode010
ges resource table freelistkjruch: cached obj cleanup040
ges resource table freelistkjrm2c: move resource to cache0311
ges resource table freelistkjchc: clean resource cache020
ges resource table freelistkjrchc2: cached obj cleanup010
ges resource table freelistkjrchc: cached obj cleanup010
ges timeout listkjtscn: try to lock timer queue030
lgwr LWN SCNkcs023020
messagesksaamb: after wakeup021
messagesksarcv: after wait012
mostly latch-free SCNkcslcu3024
multiblock read objectskcbzibmlt042
multiblock read objectskcbzibmlt: normal mbr free046
object queue header operationkclobj_50539429
object queue header operationkclobj_102827
object queue header operationkcbo_unlink_q022124
object queue header operationkcbo_link_q:reget0100
object queue header operationkcbo_link_q0811
object queue header operationkcbo_write_q044
object queue header operationkcbo_switch_mq_bg035
object queue header operationkcbo_unlink_q_bg036
object queue header operationkcbo_switch_q_bg025
object queue header operationkcldbufs028
object queue header operationkcbo_sw_buf010
object queue header operationkcbo_switch_cq014
object queue header operationkclbufs011
object stats modificationksolsgetchk020
parameter table managementkspcpy050
parameter table managementksp_param_table_free010
post/wait queuekslpstevent:get022
post/wait queueksliwat:remove011
process allocationksuapc0119162
process allocationksucrp:10400
process allocationksudlp030
qmn task queue latchkwqmnmvtsks: delay to ready list050
qmn task queue latchkwqmnaddtsk: add task020
qmn task queue latchkwqmngettsk: get task0210
qmn task queue latchkwqmndntsk: task done but retry010
redo allocationkcrfw_redo_gen: redo allocation 1090
redo allocationkcrfw_redo_gen: redo allocation 3010
resmgr:active threadskgsksimsetup10320
resmgr:active threadskskdynthreshact010
resmgr:resource group CPU methodkgkprrpicknext0290299
resmgr:resource group CPU methodkgkprraddtorl02314
resmgr:schema configkgskgmaxdop101506
resmgr:schema configkgskgasi1089234
resmgr:schema configkgskmetricupd010
row cache objectskqreqd: reget028711
row cache objectskqrpre: find obj0106429
row cache objectskqrso05733
row cache objectskqrbgl0292
row cache objectskqreqd02224
row cache objectskqrbtm: pop parent092
row cache objectskqrbip042
row cache objectskqrigt0421
row cache objectskqrigt2030
row cache objectsksucallcbksafely: kqrhngc030
row cache objectskqrpre: init complete021
row cache objectskqrcmt: while loop011
row cache objectskqrigt3010
session allocationkspallmod010
session idle bitksupuc: clear busy032
session idle bitksupuc: set busy024
session idle bitksuxds021
shared poolkghalo01,459774
shared poolkghupr10261680
shared poolkghalp0158456
shared poolkgh_heap_sizes05445
shared poolkgh_next_free0472
shared poolkghfrunp: alloc: wait0110
shared poolkghfre0437
shared poolkghasp022
shared poolkghfrh011
shared poolkghfrunp: clatch: nowait010
shared poolkghfrunp: clatch: wait010
shared pool simulatorkglsim_unpin_simhp0226
shared pool simulatorkglsim_scan_lru: scan026
shared pool simulatorkglsim_upd_newhp018
simulator hash latchkcbsacc: lookup dba01114
simulator hash latchkcbsacc: insert dba020
simulator hash latchkcbsacc: remove dba021
simulator hash latchkcbs_lookup_setid: lookup dba011
simulator lru latchkcbs_shrink_pool030
transaction allocationktcxbr0412412
undo global dataktudba: KSLBEGIN022
undo global dataktucof: at start010
undo global datakturdc: KSLBEGIN010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]6,024,659821,028
Library Cachekgllkal1 80233,6127,013
Library Cachekglget1 1114,6602,908
Library Cachekglhdgn1 6268,2841,299
Library Cachekglget2 259,9811,233
Library Cachekglpndl1 9559,4851,743
Library Cachekglobpn1 7153,9541,156
Library Cachekglpin1 447,6031,015
Library Cachekgldtin1 4240,898683
Library Cachekglhdgn2 10629,3481,141
Library Cachekglpnal2 9129,346877
Library Cachekglpnal1 9027,586904
Library Cachekgllkdl1 8523,790692
Library Cachekglobld1 751,51922
Library Cachekglhdgh1 641,20597
Cursor Pinkksfbc [KKSCHLFSP2]4924,933
Library Cachekglrfcl1 793375
Cursor Pinkksfbc [KKSCHLPIN1]2082
Library CachekglReleaseHandleReference 1252003
Library Cachekgllkc1 57951
Library Cachekglllal3 1113682
hash tablekkshGetNextChild [KKSHBKLOC1]310
Cursor PinkksLockDelete [KKSCHLPIN6]190
Library Cachekgllldl2 112110
Library Cachekglnti1 4650
Library Cachekglati1 4545
Library Cachekglini1 3228
Library CachekglUpgradeLock 11910
Library Cachekglhbh1 6310
Library Cachekglic1 4910
Library Cachekgllkal3 8210
Library Cachekglllal1 10912
Library Cachekglrdtin1 4410

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
ECSCOREDATAEXCHANGE TABLE67,520,48011.54
ECSUSERSORGANIZATIONUNITPROFILE TABLE57,782,2409.87
ECSCORE_INDEXIDX_OUNESTLOOP INDEX34,678,7685.93
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_87227165_25241TABLE PARTITION24,907,7924.26
ECSCOREDATAREPAYBILL TABLE22,569,4883.86

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ECSCOREDATAREFUNDORDER TABLE4,968,76626.32
ECSCOREDATAPSGTICKET TABLE4,351,60823.05
SYSUSERSAUD$ TABLE420,3292.23
ECSCOREDATAORDERSSYS_P2389TABLE PARTITION155,8360.83
ECSCOREDATAORDERSSYS_P2409TABLE PARTITION149,8610.79

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
ECSCOREDATAPSGTICKET TABLE133,7059.50
ECSCOREDATAREPAYBILL TABLE113,1038.03
ECSUSERSFLIGHTPRICEDOMESTIC TABLE69,0254.90
ECSCOREDATAREFUNDORDER TABLE52,1703.71
ECSUSERSTRACEOFPROCESSSYS_P2528TABLE PARTITION50,3013.57

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
ECSCOREDATAPSGTICKET TABLE133,7059.50
ECSCOREDATAREPAYBILL TABLE113,1038.03
ECSUSERSFLIGHTPRICEDOMESTIC TABLE69,0254.90
ECSCOREDATAREFUNDORDER TABLE52,1703.71
ECSUSERSTRACEOFPROCESSSYS_P2528TABLE PARTITION50,3013.57

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
ECSCOREDATAREFUNDORDER TABLE4,954,68867.00
ECSCOREDATAORDERSSYS_P2489TABLE PARTITION85,7051.16
ECSCOREDATAORDERSSYS_P2409TABLE PARTITION74,1141.00
ECSCOREDATAORDERSSYS_P2448TABLE PARTITION69,0120.93
ECSCOREDATAORDERSSYS_P2389TABLE PARTITION66,7110.90

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
PAOTEMPQUEST_ADV_SEGSTAT_WIDE_PK INDEX4,7963.68
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_87227165_25433TABLE PARTITION4,0733.12
ECSCOREDATAPAYBILL TABLE3,4302.63
SYSUSERSAUD$ TABLE2,6352.02
** MISSING **USERS** MISSING: 300054/300054** MISSING **UNDEFINED2,4341.87

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
ECSCOREDATAPAYBILL TABLE3,1645.55
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION1,8493.24
ECSCORE_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION1,8473.24
ECSCOREDATAPASSENGERINFO TABLE1,7073.00
ECSCORE_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION1,5262.68

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
PAOTEMPQUEST_ADV_SEGSTAT_WIDE_PK INDEX4,79619.57
** MISSING **USERS** MISSING: 300054/300054** MISSING **UNDEFINED2,4479.98
** MISSING **COREDATA** MISSING: 300056/300056** MISSING **UNDEFINED2,0658.43
** MISSING **USERS** MISSING: 300055/300055** MISSING **UNDEFINED1,7347.08
** MISSING **COREDATA** MISSING: 300057/300057** MISSING **UNDEFINED1,4746.01

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
ECSCORE_INDEXPK_ORGANIZATIONUNITPROFILE INDEX3,16555.81
ECSCOREDATAREFUNDORDER TABLE190.34
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION160.28
ECSCOREDATAORDERSSYS_P2389TABLE PARTITION150.26
ECSCOREDATAORDERSSYS_P2409TABLE PARTITION150.26

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION151,76023.46
SYSUSERSAUD$ TABLE49,6647.68
ECSCORE_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION42,4006.55
ECSCORE_INDEXIDX_CREATEDATE_STATUSSYS_P2548INDEX PARTITION38,1285.89
ECSCORE_INDEXPK_PNRLIST INDEX27,7604.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION32939.45
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION14817.75
ECSCORE_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION9211.03
ECSCORE_INDEXCATALOGSYS_P2528INDEX PARTITION202.40
ECSUSERSUSERPROFILE TABLE192.28

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION2388.46
ECSCORE_INDEXSYS_C0049434 INDEX311.54

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMUNDO$ TABLE1,34753.09
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION48419.08
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION2389.38
ECSCORE_INDEXPK_PNRLIST INDEX1224.81
ECSCORE_INDEXSYS_C0048724 INDEX602.36

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
ECSCOREDATAORDERSSYS_P2409TABLE PARTITION18,90231.83
ECSCOREDATAORDERSSYS_P2389TABLE PARTITION15,71526.46
ECSCOREDATACHANGE TABLE9,19415.48
ECSCOREDATACALLCENTERDATARECORD TABLE9,17515.45
ECSCORE_INDEXPK_ORDERS INDEX1,1361.91

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
ECSCOREDATAORDERSSYS_P2548TABLE PARTITION25,97515.68
ECSCORE_INDEXPK_ORDERS INDEX10,2866.21
ECSUSERSPNRLIST TABLE8,5925.19
ECSCORE_INDEXPK_FLIGHTPRICEDOMESTIC INDEX5,8463.53
ECSCORE_INDEXPK_PNRLIST INDEX5,6523.41

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
ECSCOREDATACNPPHONEPAYINFO TABLE84,40917.91
ECSCOREDATAORDERSSYS_P2048TABLE PARTITION63,27013.42
ECSCOREDATAORDERSSYS_P2448TABLE PARTITION56,07211.89
ECSCOREDATAORDERSSYS_P2489TABLE PARTITION19,3584.11
ECSCORE_INDEXORDERSEGMENT_FK INDEX18,8844.01

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_control4090.000 21
dc_constraints50735.110 5071
dc_files8820.000 042
dc_global_oids29,3650.380 051
dc_histogram_data8,194,3840.070 2,8087,270
dc_histogram_defs3,137,4380.340 2,0394,704
dc_object_grants54,8680.150 082
dc_objects4,944,6860.070 2611,745
dc_profiles3,2740.370 04
dc_rollback_segments151,2770.060 4501,920
dc_segments1,405,6660.170 461,163
dc_sequences1,67369.640 1,6735
dc_table_scns46100.000 00
dc_tablespaces897,5580.000 014
dc_users2,007,0240.000 072
global database name4,5040.000 01
outstanding_alerts7190.140 1311
qmtmrctn_cache_entries4100.000 00
qmtmrctq_cache_entries123100.000 00
sch_lj_objs650.000 03

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control400
dc_constraints84508
dc_global_oids1130145
dc_histogram_defs13,43706,770
dc_objects3,43822,951
dc_profiles12013
dc_rollback_segments552860
dc_segments2,74922,569
dc_sequences3,3431,11851
dc_table_scns4600
dc_tablespaces19019
dc_users68076
outstanding_alerts1321838
qmtmrctn_cache_entries404
qmtmrctq_cache_entries1230123
sch_lj_objs305

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS3,0671.010 00
BODY11,2301.8198,2480.24120
CLUSTER1,0241.371,0371.4510
DBLINK3,2570.000 00
DIRECTORY506.007012.8640
EDITION1,4930.002,9690.0000
HINTSET OBJECT3119.353138.7100
INDEX135,6350.19135,5720.3800
OBJECT ID49100.000 00
QUEUE277.411793.3530
RULESET0 137.6910
SCHEMA3,9790.000 00
SQL AREA571,09827.152,640,29221.4021,2562,609
SQL AREA BUILD177,41094.950 00
SQL AREA STATS171,35995.25171,36295.2510
SUBSCRIPTION966.67966.6700
TABLE/PROCEDURE408,2580.261,431,1910.807,0120
TEMPORARY INDEX121100.00121100.0000
TEMPORARY TABLE31631.01316100.002180
TRIGGER8994.5666,4620.11190
XML SCHEMA520.00666.6710

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS3,0670000
BODY096,44896,44800
CLUSTER1,0371,0371,03700
DBLINK3,2570000
DIRECTORY29575700
EDITION1,4931,4931,49300
HINTSET OBJECT31313100
INDEX135,550135,551135,55100
QUEUE317917900
RULESET0131300
SCHEMA1,7100000
SUBSCRIPTION09900
TABLE/PROCEDURE516,655716,402716,40200
TEMPORARY INDEX12112112100
TEMPORARY TABLE31631631600
TRIGGER066,46266,46200
XML SCHEMA33300

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache15,616.0015,552.0015,552.0018,304.008SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target6,144.006,144.006,144.006,144.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target24,576.0024,576.0024,576.0024,576.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool64.0064.0064.0064.000STA/
large pool64.0064.0064.0064.000STA/
shared pool8,576.008,640.005,952.008,640.008GRO/DEF
streams pool128.00128.0064.00128.000SHR/DEF

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache15,552.0015,616.0015,584.00606
shared pool8,576.008,640.008,608.00660

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
08/07 22:57:4460bufcacheSHR/DEF15,5520-12815,552CAN
08/07 22:57:4460sharedGRO/DEF8,64001288,640CAN
08/07 22:44:1460bufcacheSHR/DEF15,5520-12815,552CAN
08/07 22:44:1460sharedGRO/DEF8,64001288,640CAN
08/07 22:30:541bufcacheSHR/IMM15,616-64 15,552COM
08/07 22:30:541sharedGRO/IMM8,57664 8,640COM
08/07 22:24:4360bufcacheSHR/DEF15,6160-12815,616CAN
08/07 22:24:4360sharedGRO/DEF8,57601288,576CAN
08/07 22:15:1160bufcacheSHR/DEF15,6160-12815,616CAN
08/07 22:15:1160sharedGRO/DEF8,57601288,576CAN
08/07 22:06:0960bufcacheSHR/DEF15,6160-12815,616CAN
08/07 22:06:0960sharedGRO/DEF8,57601288,576CAN

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
BOther2,473.50 4.394.044444564564
Freeable402.560.000.870.6711 464464
PL/SQL99.8963.230.180.1511562560
SQL40.5517.480.080.5212275529430
EOther3,225.48 3.923.584444822822
Freeable512.940.000.840.559 608608
PL/SQL113.2779.440.140.1412820819
SQL32.776.660.040.061275786684

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers16,374,562,81616,307,453,952
Fixed Size2,231,608 
Redo Buffers16,932,864 
Variable Size9,261,023,9449,328,132,808

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory64.0064.000.00
largePX msg pool7.817.810.00
largefree memory55.8155.810.00
sharedKGH: NO ACCESS801.82801.820.00
sharedKGLH0582.60627.287.67
sharedKGLHD2,762.982,773.190.37
sharedSQLA362.65488.8134.79
sharedfree memory3,243.663,091.88-4.68
sharedgcs resources336.81336.810.00
sharedgcs shadows248.18248.180.00
sharedkglsim object batch125.21125.210.00
streamsKGH: NO ACCESS63.9963.990.00
streamsfree memory127.95127.950.00
 buffer_cache15,616.0015,552.00-0.41
 fixed_sga2.132.130.00
 log_buffer16.1516.150.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0517 05:09:440.220.000.00
QMON Slaves0517 05:09:440.220.000.00

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

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 130.0000.102.040.000.000.160.011

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 130100.000.0042.600.000.004.93
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(49631) 34340.000.000.180.430.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.003.28 
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_TASK_Q(49631) 0.010.010.010.01

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
CORE_DB1_3938_COREDB1(22)/SYS.ALERT_QUE 13000.000.000.00
CORE_DB2_3938_COREDB2(42)/SYS.ALERT_QUE 13000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/app/oracle/admin/COREDB/adump  
cluster_databaseTRUE  
compatible11.2.0.0.0  
control_files+DATADG/COREDB/controlfile/current.256.729362595, +FLASHDG/COREDB/controlfile/current.256.729362595  
db_block_size8192  
db_create_file_dest+DATADG  
db_domain  
db_nameCOREDB  
db_recovery_file_dest+FLASHDG  
db_recovery_file_dest_size1887436800000  
diagnostic_dest/oracle/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=COREDBXDB)  
instance_number1  
job_queue_processes1000  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.10.31)(PORT=1521))))  
log_archive_format%t_%s_%r.dbf  
max_dump_file_size20480  
memory_max_target34359738368  
memory_target0  
open_cursors3000  
pga_aggregate_target6442450944  
processes2000  
remote_listenerCORE-DB-cluster-scan:1521  
remote_login_passwordfileEXCLUSIVE  
resource_limitTRUE  
sec_case_sensitive_logonFALSE  
service_namesCOREDB.  
sessions3024  
sga_max_size25769803776  
sga_target25769803776  
thread1  
undo_retention10800  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATADG/COREDB/controlfile/current.256.729362595  
+FLASHDG/COREDB/controlfile/current.256.729362595  

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)50,77214.070.27
acks for commit broadcast(logical)58,63316.250.31
broadcast msgs on commit(actual)68,85019.080.37
broadcast msgs on commit(logical)120,46933.380.64
broadcast msgs on commit(wasted)16,0314.440.09
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received30.000.00
flow control messages sent00.000.00
gcs apply delta00.000.00
gcs assume cvt00.000.00
gcs assume no cvt119,32433.060.64
gcs ast xid300.010.00
gcs blocked converts154,13642.710.82
gcs blocked cr converts179,54749.750.96
gcs compatible basts8240.230.00
gcs compatible cr basts (global)43,08211.940.23
gcs compatible cr basts (local)163,27845.240.87
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs15,2104.210.08
gcs dbwr write request msgs11,5693.210.06
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 only1370.040.00
gcs force cr grant7940.220.00
gcs force cr no current00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts12,5713.480.07
gcs immediate (null) converts20,8965.790.11
gcs immediate cr (compatible) converts1,2490.350.01
gcs immediate cr (null) converts257,32771.301.37
gcs indirect ast71,95119.940.38
gcs indirect bidless ast330.010.00
gcs indirect fg ast71,77419.890.38
gcs lms flush pi msgs00.000.00
gcs lms write request msgs6,8831.910.04
gcs msgs process time(ms)45,72412.670.24
gcs msgs received1,525,497422.698.13
gcs new served by master1,2710.350.01
gcs out-of-order msgs110.000.00
gcs pings refused2920.080.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts980.030.00
gcs reader bypass N->Xw ping local00.000.00
gcs reader bypass N->Xw ping remote00.000.00
gcs reader bypass grant X on assume00.000.00
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast00.000.00
gcs reader bypass grant immediate00.000.00
gcs recovery claim msgs00.000.00
gcs refuse xid350.010.00
gcs regular cr00.000.00
gcs retry convert request30.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual22,3796.200.12
gcs side channel msgs logical815,484225.964.35
gcs stale cr39,29210.890.21
gcs undo cr8,1712.260.04
gcs write notification msgs1,7240.480.01
gcs writes refused560.020.00
ges msgs process time(ms)3,2990.910.02
ges msgs received139,98538.790.75
global posts dropped00.000.00
global posts queue time760.020.00
global posts queued460.010.00
global posts requested470.010.00
global posts sent460.010.00
implicit batch messages received34,9409.680.19
implicit batch messages sent96,71026.800.52
lmd msg send time(ms)100.000.00
lms(s) msg send time(ms)00.000.00
messages flow controlled5,8561.620.03
messages queue sent actual315,60587.451.68
messages queue sent logical848,077234.994.52
messages received actual887,977246.044.73
messages received logical1,665,577461.508.88
messages sent directly703,044194.803.75
messages sent indirectly1,014,276281.045.41
messages sent not implicit batched3230.090.00
messages sent pbatched1,136,685314.966.06
msgs causing lmd to send msgs56,36515.620.30
msgs causing lms(s) to send msgs55,56515.400.30
msgs received queue time (ms)310,82986.131.66
msgs received queued1,665,581461.508.88
msgs sent queue time (ms)267,20174.041.42
msgs sent queue time on ksxp (ms)8,113,7812,248.1943.24
msgs sent queued1,065,778295.315.68
msgs sent queued on ksxp1,150,472318.786.13
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received229,77463.671.22
process batch messages sent258,58071.651.38
 00.000.00


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests133,779
CURRENT Block Requests15,657
Data Block Requests133,780
Undo Block Requests3,048
TX Block Requests11,444
Current Results130,170
Private results3,253
Zero Results15,879
Disk Read Results123
Fail Results0
Fairness Down Converts47,773
Fairness Clears8,701
Free GC Elements0
Flushes19,440
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works2,479
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins40526.1738.2733.091.231.23
Flushes1,63415.7367.6914.751.840.00
Writes19,8090.0162.5632.073.711.65


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
2data block138,24385.2914.480.23469,86197.470.472.06
2undo header24,76299.150.360.4831095.813.550.65
2Others82998.790.121.091,23099.590.080.33
2undo block1,80096.783.060.172487.500.0012.50

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
2data block7.151.2130.18758.372.851.64119.6733.03
2undo header6.982.77543.98464.6816.781.37337.22542.48
2others1.220.9975.5313.411.811.790.816.57
2undo block1.410.916.76193.613662.912.91 29282.91

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
2data block0117,913100.000.00457,952100.000.00
2undo header024,552100.000.00297100.000.00
2others0819100.000.001,225100.000.00
2undo block01,742100.000.0021100.000.00

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
2data block 1.211.21 1.641.64 
2undo header 2.772.77 1.371.37 
2others 0.990.99 1.791.79 
2undo block 0.910.91 2.912.91 

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
12820.535.552820.515.55
22821.7015.072821.9615.07

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.671.20
Parallel Query0.010.03
DB Locks0.210.10
DB Streams0.000.00
Other0.000.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
en9169.254.131.102NO  1.050000 1.540000
en9169.254.131.102NO  1.050161,364,64800 1.54001,398,030,6674
en9169.254.131.102NO  1.050-161,364,64800 1.5400-1,398,030,667-4
en9169.254.131.102NO  1.050000 1.540000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

NameTotalper Remaster OpBegin SnapEnd Snap
remaster ops31.00  
remastered objects31.00  
replayed locks received3,0721,024.00  
replayed locks sent93.00  
resources cleaned00.00  
remaster time (s)58.819.59  
quiesce time (s)2.30.77  
freeze time (s)0.60.19  
cleanup time (s)0.90.30  
replay time (s)0.30.09  
fixwrite time (s)1.30.45  
sync time (s)52.217.39  
affinity objects  186187


Back to Top

End of Report