WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
coredb87227165coredb2217-5月 -13 04:0511.2.0.2.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
core-db2AIX-Based Systems (64-bit) 24 12  45.25

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2547607-8月 -13 22:00:05501 7.3
End Snap:2547707-8月 -13 23:00:14838 7.8
Elapsed:  60.15 (mins)  
DB Time:  4,155.71 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 14,784M 14,784MStd Block Size: 8K
Shared Pool Size: 9,472M 9,472MLog Buffer: 16,536K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 69.1 1.5 0.14 0.04
DB CPU(s): 1.7 0.0 0.00 0.00
Redo size: 63,544.3 1,376.9  
Logical reads: 103,991.1 2,253.3  
Block changes: 359.4 7.8  
Physical reads: 8,967.0 194.3  
Physical writes: 18.9 0.4  
User calls: 1,580.4 34.3  
Parses: 401.5 8.7  
Hard parses: 51.0 1.1  
W/A MB processed: 11.1 0.2  
Logons: 0.7 0.0  
Executes: 481.7 10.4  
Rollbacks: 31.3 0.7  
Transactions: 46.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 99.92In-memory Sort %: 100.00
Library Hit %: 83.20Soft Parse %: 87.31
Execute to Parse %: 16.65Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 0.23% Non-Parse CPU: 92.76

Shared Pool Statistics

BeginEnd
Memory Usage %: 55.50 55.56
% SQL with executions>1: 79.15 78.39
% Memory for SQL w/exec>1: 74.28 75.64

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
library cache lock7,515185,6412470374.45Concurrency
cursor: pin S wait on X21830,13413822912.09Concurrency
DB CPU 6,146 2.47 
library cache load lock2,2043,27314851.31Concurrency
library cache pin9,2882,7712981.11Concurrency

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

Load Average BeginLoad Average End%User%System%WIO%Idle
4.71 5.09 9.6 4.1 3.6 86.3
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
20.9 152.3 1.1
Memory Statistics

BeginEnd
Host Mem (MB): 46,335.9 46,335.9
SGA use (MB): 24,576.0 24,576.0
PGA use (MB): 2,756.7 4,113.9
% Host Mem used for SGA+PGA: 58.99 61.92

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 103.82 2.25
Global Cache blocks served: 176.52 3.82
GCS/GES messages received: 769.63 16.68
GCS/GES messages sent: 461.25 9.99
DBWR Fusion writes: 5.01 0.11
Estd Interconnect traffic (KB) 2,483.14 

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

Buffer access - local cache %: 99.81
Buffer access - remote cache %: 0.11
Buffer access - disk %: 0.08

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 92.5
Avg global cache cr block receive time (ms): 3.9
Avg global cache current block receive time (ms): 2.9
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 %: 12.2
Avg global cache cr block flush time (ms): 27.4
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.3
Avg global cache current block flush time (ms): 159.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 6.4
Avg message sent queue time on ksxp (ms): 19.1
Avg message received queue time (ms): 0.4
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.1
% of direct sent messages: 65.42
% of indirect sent messages: 34.22
% of flow controlled messages: 0.36


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
en9169.254.224.51N    

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 elapsed223,529.3889.65
hard parse elapsed time169,891.7768.14
sql execute elapsed time54,294.8021.78
PL/SQL compilation elapsed time33,016.3813.24
DB CPU6,146.412.47
failed parse elapsed time3,119.541.25
hard parse (sharing criteria) elapsed time1,638.850.66
hard parse (bind mismatch) elapsed time728.700.29
connection management call elapsed time76.950.03
PL/SQL execution elapsed time59.100.02
sequence load elapsed time21.450.01
repeated bind elapsed time0.120.00
DB time249,342.34 
background elapsed time14,892.75 
background cpu time12,295.86 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
NUM_LCPUS0 
NUM_VCPUS0 
AVG_BUSY_TIME50,318 
AVG_IDLE_TIME317,930 
AVG_IOWAIT_TIME13,231 
AVG_SYS_TIME14,886 
AVG_USER_TIME35,318 
BUSY_TIME1,210,533 
IDLE_TIME7,633,105 
IOWAIT_TIME320,353 
SYS_TIME360,066 
USER_TIME850,467 
LOAD55
OS_CPU_WAIT_TIME2,114,800 
RSRC_MGR_CPU_WAIT_TIME266,817 
VM_IN_BYTES1,049,960,448 
VM_OUT_BYTES3,864,756,216 
PHYSICAL_MEMORY_BYTES48,586,686,464 
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.71     
07-8月 23:00:145.0913.699.624.0786.313.62

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency52,1210222,624427189.28
DB CPU  6,146 2.47
User I/O257,79603,460131.39
Other50,128733,427681.37
Scheduler64,32402,735431.10
Cluster468,75802,45150.98
Application40,71401,277310.51
Commit68,29301,214180.49
Network5,204,849043800.18
System I/O9,00701820.01
Configuration178813710.01

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 lock7,5150185,641247030.0574.45
cursor: pin S wait on X218030,1341382290.0012.09
library cache load lock2,20403,27314850.011.31
library cache pin9,28802,7712980.061.11
resmgr:cpu quantum64,32402,735430.391.10
KJC: Wait for msg sends to complete3,88102,4756380.020.99
direct path read79,73102,004250.480.80
db file sequential read143,25001,34790.860.54
enq: TX - row lock contention38701,25632450.000.50
log file sync68,29301,214180.410.49
latch: ges resource hash list94306036400.010.24
gc current block 2-way206,581052031.240.21
gc buffer busy acquire19,9650414210.120.17
gc cr block 2-way121,108038830.730.16
buffer busy waits1,36103482560.010.14
gc buffer busy release1,15203192770.010.13
SQL*Net more data from client6,5480299460.040.12
library cache: mutex X13,6300277200.080.11
gc current grant busy42,801019550.260.08
gc cr grant congested55015227690.000.06
gc cr grant 2-way36,930014540.220.06
SQL*Net message to client5,194,0090139031.180.06
name-service call wait251921234920.000.05
gc current block busy2,1760122560.010.05
gc cr block busy19,29109950.120.04
DFS lock handle23523974130.000.04
enq: US - contention4109021880.000.04
enq: TX - index contention4640671450.000.03
db file scattered read18,97805630.110.02
latch: row cache objects712054760.000.02
row cache lock11,05104840.070.02
gc current grant congested2403213520.000.01
gc current grant 2-way9,33803130.060.01
db file parallel read1,288029220.010.01
gc current retry1201915900.000.01
control file sequential read9,00701820.050.01
SQL*Net break/reset to client39,85601800.240.01
read by other session1,134013110.010.01
enq: SQ - contention140012860.000.00
latch free2,1180940.010.00
gc cr multi block request8,7450910.050.00
external table open13086210.000.00
enq: PS - contention8782890.010.00
latch: shared pool1,7960740.010.00
gc cr block congested15705300.000.00
enq: KO - fast object checkpoint4670480.000.00
reliable message29103110.000.00
enq: TX - contention931003350.000.00
buffer exterminate318993100.000.00
latch: cache buffers chains3,8630310.020.00
Disk file operations I/O11,3940300.070.00
latch: gc element8503330.000.00
IPC send completion sync3,4590210.020.00
latch: object queue header operation2601510.000.00
gc current block congested2250160.000.00
latch: gcs resource hash6012080.000.00
enq: JQ - contention251001340.000.00
PX Deq: reap credit20,892100100.130.00
external table read2090140.000.00
gc current multi block request2701240.000.00
asynch descriptor resize14,218100100.090.00
rdbms ipc reply4460110.000.00
enq: FB - contention1401370.000.00
log file switch completion600680.000.00
ASM file metadata operation2001040.000.00
PX Deq: Slave Session Stats8890000.010.00
undo segment extension151000110.000.00
cr request retry141000100.000.00
gc current split350030.000.00
SQL*Net more data to client4,2920000.030.00
resmgr:internal state change110001000.000.00
gc cr disk read1220010.000.00
buffer deadlock788100000.000.00
CSS initialization200200.000.00
latch: enqueue hash chains620010.000.00
external table seek130020.000.00
enq: TX - allocate ITL entry170010.000.00
utl_file I/O1,7850000.010.00
PX Deq: Signal ACK RSG390000.000.00
CSS operation: action20040.000.00
enq: TT - contention110010.000.00
gc cr failure140010.000.00
latch: session allocation70010.000.00
PX Deq: Signal ACK EXT390000.000.00
enq: AE - lock70010.000.00
global enqueue expand wait60010.000.00
CSS operation: query60000.000.00
cursor: pin S170000.000.00
enq: TM - contention4100010.000.00
enq: TO - contention40000.000.00
direct path write temp10020.000.00
latch: cache buffers lru chain50000.000.00
enq: MD - contention40000.000.00
SQL*Net message from client5,193,671010,123,748194931.18 
jobq slave wait4,0251002,0115000.02 
PX Deq: Execution Msg3,40005881730.02 
PX Deq: Msg Fragment7750460.00 
PX Deq: Parse Reply3903790.00 
PX Deq Credit: send blkd5,2510100.03 
PX Deq: Join ACK3901190.00 
PX Deq: Execute Reply4001140.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
latch free53601,02819180.006.90
log file parallel write121,883032430.732.17
os thread startup105127125800.001.82
enq: PR - contention50241482070.001.62
gcs log flush sync42,7251212830.260.86
enq: PV - syncstart40108268820.000.72
db file parallel write13,99509370.080.62
gc cr block 2-way2,448092370.010.61
control file sequential read15,08407650.090.51
process diagnostic dump2,428042170.010.28
ges inquiry response2,415026110.010.17
enq: CF - contention3529522630.000.15
enq: WF - contention180179640.000.12
Streams AQ: qmn coordinator waiting for slave to start31001756440.000.11
control file parallel write5,00701530.030.10
gc buffer busy acquire1013128060.000.09
db file sequential read967011110.010.07
log file sequential read19108400.000.05
latch: gc element8508890.000.05
ges lms sync during dynamic remastering and reconfig72887990.000.05
row cache lock4,6960610.030.04
latch: ges resource hash list28505180.000.03
row cache cleanup72,8980500.440.03
ASM file metadata operation1,1170440.010.03
gc cr grant 2-way24304150.000.02
LGWR wait for redo copy1,5350420.010.02
DFS lock handle5,55331310.030.02
PX Deq: reap credit6,710100200.040.01
row cache process37,4130200.220.01
latch: gcs resource hash2902560.000.01
latch: object queue header operation1850290.000.01
gc current block 2-way2,1910210.010.01
ksdxexeotherwait3014350.000.01
reliable message5220120.000.01
gc current grant busy11701100.000.01
library cache: mutex X4012160.000.01
libcache interrupt action by LCK54,3010100.330.00
CGS wait for IPC msg29,274100100.180.00
latch: row cache objects4101140.000.00
ksxr poll remote instances49,835100100.300.00
library cache lock4440010.000.00
enq: US - contention9810000.010.00
kjbdrmcvtq lmon drm quiesce: ping completion2200180.000.00
enq: TM - contention10800390.000.00
ADR block file write1900190.000.00
db file parallel read1300280.000.00
Parameter File I/O800040.000.00
CSS initialization500670.000.00
library cache pin4890010.000.00
gc current grant 2-way3020010.000.00
name-service call wait800340.000.00
gc current block busy350070.000.00
latch: messages400650.000.00
ADR block file read470050.000.00
ADR file lock22180100.000.00
gc cr multi block request2140010.000.00
Disk file operations I/O3720000.000.00
enq: KO - fast object checkpoint2120010.000.00
ges generic event15870100.000.00
enq: CR - block range reuse ckpt2900000.000.00
Log archive I/O400320.000.00
gc current grant congested400300.000.00
CSS operation: action1200100.000.00
gc cr grant congested500220.000.00
gc cr block busy110060.000.00
ges LMON to get to FTDONE4500160.000.00
latch: shared pool370010.000.00
db file scattered read200240.000.00
buffer busy waits590010.000.00
enq: PS - contention2450020.000.00
ARCH wait for archivelog lock100400.000.00
gc buffer busy release50050.000.00
enq: TQ - TM contention160020.000.00
log file sync30070.000.00
direct path write50040.000.00
enq: RO - fast object reuse260010.000.00
CSS operation: query140010.000.00
enq: TT - contention2767000.000.00
enq: WL - contention11000100.000.00
enq: TA - contention130010.000.00
ges2 LMON to wake up LMD - mrcvr40020.000.00
rdbms ipc reply440000.000.00
kfk: async disk IO30020.000.00
CSS operation: data query20030.000.00
gc current multi block request80010.000.00
enq: FB - contention90010.000.00
CSS group registration10050.000.00
IPC send completion sync120000.000.00
gc current block congested60010.000.00
PX Deq: Signal ACK RSG180000.000.00
asynch descriptor resize1,841100000.010.00
SQL*Net message to client3,6790000.020.00
enq: HW - contention40010.000.00
PX Deq: Slave Session Stats180000.000.00
latch: cache buffers lru chain60000.000.00
latch: redo allocation100000.000.00
latch: checkpoint queue latch10020.000.00
log file single write20010.000.00
KJC: Wait for msg sends to complete1730000.000.00
enq: PW - flush prewarm buffers2100010.000.00
PX Deq: Signal ACK EXT180000.000.00
gc object scan12100000.000.00
latch: cache buffers chains500000.000.00
rdbms ipc message307,2332487,9212861.84 
PX Idle Wait858012,841149660.01 
class slave wait107011,9451116320.00 
Streams AQ: waiting for time management or cleanup tasks122817,880645890.00 
wait for unread message on broadcast channel7,2201007,21810000.04 
DIAG idle wait238,066956,996291.43 
gcs remote message1,382,015266,70058.30 
Space Manager: slave idle wait1,036985,12749490.01 
Streams AQ: qmn slave idle wait19824,905247720.00 
ASM background timer73703,61148990.00 
pmon timer1,312893,60227460.01 
PING1,410203,60225550.01 
shared server idle wait1201003,600300020.00 
dispatcher timer601003,600600030.00 
smon timer8163,578441750.00 
ges remote message1,357,068933,57738.15 
Streams AQ: qmn coordinator idle wait288433,528122490.00 
GCR sleep6801003,40050000.00 
VKRM Idle102,40624062500.00 
SGA: MMAN sleep for component shrink26,830100275100.16 
SQL*Net message from client5,0440810.03 
KSV master wait2,20598310.01 
PX Deq: Join ACK1800120.00 
heartbeat monitor sleep100770.00 
PX Deq: Parse Reply180040.00 
PX Deq: Execute Reply180000.00 
Streams AQ: RAC qmn coordinator idle wait292100000.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 read4748.9 6.423.412.88.5  
ADR block file write19  5.35.336.842.110.5 
ADR file lock2286.4   4.54.54.5 
ARCH wait for archivelog lock1      100.0 
ASM file metadata operation111796.31.01.0.4.1.11.0.1
CGS wait for IPC msg29.3K99.9.0.0.0.0.0.0 
CSS group registration1   100.0    
CSS initialization742.9     57.1 
CSS operation: action1421.47.114.335.77.1 14.3 
CSS operation: data query2  100.0     
CSS operation: query2085.0 10.0 5.0   
DFS lock handle578592.65.4.9.3.2.2.3.2
Disk file operations I/O11.8K93.84.71.1.2.1.0.1 
IPC send completion sync345892.35.31.2.8.2.1.1 
KJC: Wait for msg sends to complete404692.8.1.1.1.0.0.16.6
LGWR wait for redo copy153492.01.02.22.11.0.8.9 
Log archive I/O425.0  25.0  50.0 
PX Deq: Signal ACK EXT57100.0       
PX Deq: Signal ACK RSG5787.712.3      
PX Deq: Slave Session Stats90497.21.2.8.4.2 .1 
PX Deq: reap credit27.6K99.9.0.0.0.0.0.0.0
PX qref latch8100.0       
Parameter File I/O8036.31.326.328.81.36.3  
SQL*Net break/reset to client39.8K97.02.1.5.1.1.1.1.0
SQL*Net message to client5201.5K100.0.0.0.0.0.0.0.0
SQL*Net more data from client657267.4.1.2.3.81.429.9 
SQL*Net more data to client4302100.0 .0     
Streams AQ: qmn coordinator waiting for slave to start3       100.0
asynch descriptor resize16.1K99.7.1.0.0.1.0.0 
buffer busy waits142034.42.53.55.66.08.737.32.2
buffer deadlock78699.2.1 .5.1   
buffer exterminate318   .999.1   
control file parallel write5008.372.614.37.93.4.9.5 
control file sequential read24.1K50.532.55.04.53.41.92.3 
cr request retry14    100.0   
cursor: mutex S1100.0       
cursor: pin S1794.15.9      
cursor: pin S wait on X218    43.11.811.943.1
db file parallel read13013.45.36.96.825.733.818.1 
db file parallel write14K3.552.015.812.39.93.33.3 
db file scattered read19K21.257.210.73.54.42.3.7 
db file sequential read143.9K27.316.43.97.528.013.53.4.0
direct path read79.6K.0.2.82.446.532.317.8 
direct path write5 20.040.040.0    
direct path write temp1 100.0      
enq: AE - lock7100.0       
enq: CF - contention35283.09.13.12.0.6.6.61.1
enq: CR - block range reuse ckpt29095.23.41.4     
enq: FB - contention2373.913.0 4.3 4.34.3 
enq: HW - contention475.0 25.0     
enq: JQ - contention2528.036.012.012.04.0 8.0 
enq: JS - job run lock - synchronize1100.0       
enq: KO - fast object checkpoint67975.05.33.82.76.63.53.1 
enq: MD - contention4100.0       
enq: PR - contention5      20.080.0
enq: PS - contention89985.89.02.7.9.7.4.3.2
enq: PV - syncstart4       100.0
enq: PW - flush prewarm buffers2100.0       
enq: RO - fast object reuse2692.33.8 3.8    
enq: SQ - contention1405.05.712.18.62.93.662.1 
enq: TA - contention1392.3 7.7     
enq: TD - KTF dump entries1100.0       
enq: TM - contention1492.9     7.1 
enq: TO - contention4100.0       
enq: TQ - TM contention1675.012.5 12.5    
enq: TT - contention3889.57.92.6     
enq: TX - allocate ITL entry1770.611.85.911.8    
enq: TX - contention9374.29.76.53.21.1 4.31.1
enq: TX - index contention46626.46.44.32.65.45.848.5.6
enq: TX - row lock contention38734.616.812.99.310.17.25.93.1
enq: US - contention102294.71.7.8.3.1.41.2.9
enq: WF - contention1877.8  5.6 5.65.65.6
enq: WL - contention1    100.0   
external table open1392.3      7.7
external table read20994.7   .52.42.4 
external table seek1392.3    7.7  
gc buffer busy acquire20K81.37.42.72.01.81.53.1.2
gc buffer busy release11577.56.73.64.23.810.163.8.3
gc cr block 2-way123.6K93.84.01.1.4.3.2.2.0
gc cr block busy19.3K.648.831.89.35.91.91.7.0
gc cr block congested15979.27.51.91.9.6.67.5.6
gc cr disk read12391.95.7 .8.8.8  
gc cr failure1492.97.1      
gc cr grant 2-way37.2K94.93.01.0.4.3.2.2.0
gc cr grant congested6168.93.3 3.31.63.313.16.6
gc cr multi block request892688.67.61.81.1.6.2.1 
gc current block 2-way208.7K94.73.6.9.4.2.1.1.0
gc current block busy220914.227.721.112.413.94.85.4.5
gc current block congested23085.27.0.42.6.91.32.6 
gc current grant 2-way972794.32.81.0.6.5.3.5.1
gc current grant busy42.9K92.74.61.4.5.3.1.3.0
gc current grant congested2842.9  7.110.73.617.917.9
gc current multi block request3551.411.42.98.68.65.711.4 
gc current retry1266.78.3 8.3  8.38.3
gc current split3683.32.82.85.6 2.82.8 
gc object scan12100.0       
gcs log flush sync42.6K39.932.58.66.710.61.5.2.0
ges LMON to get to FTDONE4    50.050.0  
ges generic event1513.3   73.313.3  
ges inquiry response241386.29.02.51.2.5.1.2.2
ges lms sync during dynamic remastering and reconfig72  2.89.71.420.863.91.4
ges2 LMON to wake up LMD - mrcvr475.0  25.0    
global enqueue expand wait6100.0       
kfk: async disk IO333.333.3 33.3    
kjbdrmcvtq lmon drm quiesce: ping completion2227.34.513.64.513.622.713.6 
ksdxexeotherwait3    33.3 33.333.3
ksxr poll remote instances49.6K100.0.0.0     
latch free265284.34.72.1.91.3.52.63.6
latch: cache buffers chains391498.0.6.4.4.2.2.2.0
latch: cache buffers lru chain1090.010.0      
latch: call allocation4100.0       
latch: checkpoint queue latch1  100.0     
latch: enqueue hash chains6492.24.71.6 1.6   
latch: gc element17055.311.27.65.93.52.912.9.6
latch: gcs resource hash3517.1 11.420.014.32.934.3 
latch: ges resource hash list123236.01.31.84.71.4.339.814.8
latch: messages425.0    25.050.0 
latch: object queue header operation21169.712.39.01.92.8.93.3 
latch: redo allocation10100.0       
latch: row cache objects75455.43.74.94.13.14.024.8 
latch: session allocation757.142.9      
latch: shared pool183783.66.63.9.5.31.53.4 
latch: undo global data1100.0       
libcache interrupt action by LCK54.1K100.0.0.0.0.0.0  
library cache load lock22042.63.46.9.61.12.547.235.8
library cache lock799278.35.62.51.0.8.61.49.8
library cache pin982384.53.82.11.63.3.2.54.0
library cache: mutex X13.7K62.74.44.25.07.15.011.5.1
lock deadlock retry2100.0       
lock escalate retry9100.0       
log file parallel write122K44.436.85.87.23.91.2.7 
log file sequential read1914.2  .523.052.419.9 
log file single write2100.0       
log file switch completion6    16.716.766.7 
log file sync68.5K15.550.514.19.36.12.32.1.0
name-service call wait259.4 .4 .83.195.4 
os thread startup105      88.611.4
process diagnostic dump242822.5 64.511.9.6.2.2.2
rdbms ipc reply48179.011.43.74.01.0.2.6 
read by other session113412.010.37.515.032.718.73.8 
reliable message81362.110.319.94.91.4.5.9 
resmgr:cpu quantum64.3K14.06.18.813.417.217.123.3.0
resmgr:internal state change1      100.0 
row cache cleanup72.6K100.0.0.0.0.0.0.0.0
row cache lock15.7K87.88.61.81.0.2.2.4.1
row cache process37.2K100.0.0.0.0.0.0.0 
undo segment extension1533.3   33.326.76.7 
utl_file I/O178599.9   .1   
ASM background timer737.8.3.1.1.1 .398.2
DIAG idle wait238.5K3.5.5.515.255.19.615.7.0
GCR sleep680       100.0
KSV master wait220599.5.0.1.1  .1.0
PING141077.8.61.0.1.2 .120.1
PX Deq Credit: send blkd525199.6.1.0.1.0.0.1 
PX Deq: Execute Reply5872.46.910.3 5.21.73.4 
PX Deq: Execution Msg338876.17.52.92.33.12.34.01.9
PX Deq: Join ACK5724.63.540.419.33.51.87.0 
PX Deq: Msg Fragment77595.72.6.9.3.1.1.1.1
PX Deq: Parse Reply5719.312.38.817.510.55.324.61.8
PX Idle Wait8473.934.916.95.91.91.46.328.8
SGA: MMAN sleep for component shrink26.8K.1.0.0.099.2.5.1 
SQL*Net message from client5202.5K81.37.51.9.8.6.85.41.6
Space Manager: slave idle wait1036   .1.1 .399.5
Streams AQ: RAC qmn coordinator idle wait292100.0       
Streams AQ: qmn coordinator idle wait28850.72.11.41.01.0.3 43.4
Streams AQ: qmn slave idle wait19811.1      88.9
Streams AQ: waiting for time management or cleanup tasks12217.2     27.055.7
class slave wait10644.32.8 .911.37.59.423.6
dispatcher timer60       100.0
gcs remote message1381K29.813.813.513.227.32.4.0.0
ges remote message1356.9K95.5.6.4.3.3.32.5.0
heartbeat monitor sleep1      100.0 
jobq slave wait3995      100.0 
pmon timer13134.3   .1.13.791.9
rdbms ipc message307.3K35.24.45.56.47.35.030.85.5
shared server idle wait120       100.0
smon timer8137.0   1.2 3.758.0
wait for unread message on broadcast channel7220   .0.0 99.9.1

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 write289.510.5      
ADR file lock195.5  4.5    
ARCH wait for archivelog lock1 100.0      
ASM file metadata operation1298.9.2.4.2 .2.1 
CGS wait for IPC msg2100.0.0.0     
CSS initialization442.928.6 28.6    
CSS operation: action285.714.3      
DFS lock handle1799.6.1.1.0.0.1 .2
Disk file operations I/O699.9.0.0.0    
IPC send completion sync399.9.1      
KJC: Wait for msg sends to complete593.3.0.1    6.6
LGWR wait for redo copy1499.1.5.1.1 .1  
Log archive I/O250.050.0      
PX Deq: Slave Session Stats199.9.1      
PX Deq: reap credit4100.0.0.0   .0 
SQL*Net break/reset to client3099.9.0.0.0.0 .0 
SQL*Net message to client29100.0.0.0.0.0.0.0.0
SQL*Net more data from client196370.13.05.621.3    
asynch descriptor resize2100.0.0 .0    
buffer busy waits54260.610.38.85.79.33.2.91.3
control file parallel write2699.5.2.2.1    
control file sequential read55897.71.2.9.2.0.0  
cursor: pin S wait on X3545.0 .93.23.24.64.139.0
db file parallel read23581.913.93.2.9.1   
db file parallel write46596.72.0.8.5.0   
db file scattered read12899.3.5.1.0.0   
db file sequential read485096.62.6.6.2.0.0.0 
direct path read14.1K82.212.04.01.6.2.0  
enq: CF - contention298.3    .6 1.1
enq: FB - contention195.7   4.3   
enq: JQ - contention292.04.0   4.0  
enq: KO - fast object checkpoint2196.91.5.7.7.1   
enq: PR - contention2     20.020.060.0
enq: PS - contention399.4.2   .1 .2
enq: SQ - contention8737.97.137.98.67.11.4  
enq: TM - contention192.9   7.1   
enq: TX - contention594.61.1 1.11.11.11.1 
enq: TX - index contention22650.913.312.73.417.21.9 .6
enq: TX - row lock contention2891.01.81.61.6.3.81.31.8
enq: US - contention1297.9.1.5.3.2.1 .9
enq: WF - contention188.9   5.6  5.6
external table read597.6.51.01.0    
gc buffer busy acquire63796.71.2.5.7.5.2.1.1
gc buffer busy release74036.010.412.88.712.619.3.2.1
gc cr block 2-way31299.7.1.1.0.0.0.0.0
gc cr block busy32398.3.8.5.4.1.0.0 
gc cr block congested1391.81.31.31.32.51.3.6 
gc cr grant 2-way8399.8.1.1.0.0.0.0.0
gc cr grant congested880.33.34.9 3.31.6 6.6
gc cr multi block request1399.9.1.0 .0   
gc current block 2-way29099.9.1.0.0.0.0.0.0
gc current block busy12494.12.71.7.9.2 .2.3
gc current block congested697.4.4.9.4.9   
gc current grant 2-way5299.4.1.2.1.0.1.0.0
gc current grant busy12199.7.1.1.0.0.0.0.0
gc current grant congested664.33.63.6  10.73.614.3
gc current multi block request488.6 5.75.7    
gc current retry183.3    8.3 8.3
gc current split197.2 2.8     
gcs log flush sync7999.8.1.1.0.0.0.0.0
ges inquiry response699.6  .0.1.0.1.1
ges lms sync during dynamic remastering and reconfig4634.731.923.65.62.8  1.4
kjbdrmcvtq lmon drm quiesce: ping completion386.49.1 4.5    
ksdxexeotherwait233.333.3    33.3 
latch free7093.8.5.81.3 .1 3.6
latch: cache buffers chains999.8 .1.1  .0 
latch: gc element2286.52.92.92.91.82.4 .6
latch: gcs resource hash1265.711.45.75.78.62.9  
latch: ges resource hash list62145.52.611.96.84.813.610.64.1
latch: messages250.025.0 25.0    
latch: object queue header operation796.7.9 .5.9.9  
latch: row cache objects18775.22.03.14.015.5.3  
latch: shared pool6396.62.0.7.7    
library cache load lock139417.16.820.57.11.611.316.119.7
library cache lock13388.8.5.4.1.2.2.39.5
library cache pin5895.5.1.1.1.1.1.13.9
library cache: mutex X158188.43.13.14.7.5.2.1.0
log file parallel write85699.3.5.1.1.0.0  
log file sequential read3880.17.95.85.2.5.5  
log file switch completion433.316.733.316.7    
log file sync146397.81.2.6.2.1.0.0.0
name-service call wait2474.61.23.9.483.86.2  
os thread startup96  82.93.81.01.02.98.6
process diagnostic dump699.7.0.1   .1.1
rdbms ipc reply399.4.4.2     
read by other session4396.23.4.4.1    
reliable message799.1.2 .1.1.4  
resmgr:cpu quantum15K76.78.77.53.22.9.9.0.0
resmgr:internal state change1  100.0     
row cache cleanup7100.0 .0.0 .0 .0
row cache lock6299.6.1.0.1.0.1.0.0
row cache process3100.0 .0  .0  
undo segment extension193.36.7      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
DFS lock handle999.8.0.0.1    
KJC: Wait for msg sends to complete26893.4  6.6    
SQL*Net message to client6100.0.0   .0  
Streams AQ: qmn coordinator waiting for slave to start3  100.0     
buffer busy waits1898.7.1.11.1    
cursor: pin S wait on X1961.0.92.8.9.51.42.330.3
enq: CF - contention498.9.6.3.3    
enq: PR - contention240.020.0 20.0   20.0
enq: PS - contention299.8.2      
enq: PV - syncstart4  50.0  50.0  
enq: TX - index contention399.4.2.4     
enq: TX - row lock contention398.2.3 .5   1.0
enq: US - contention999.1 .5.4    
enq: WF - contention194.4   5.6   
external table open192.3 7.7     
gc buffer busy acquire2099.9.1.0.0 .0.0 
gc buffer busy release199.9    .1  
gc cr block 2-way12100.0.0 .0 .0.0 
gc cr grant 2-way7100.0.0  .0 .0 
gc cr grant congested493.41.6  3.3 1.6 
gc current block 2-way15100.0.0.0  .0.0 
gc current block busy699.7.2.0   .0 
gc current grant 2-way4100.0.0      
gc current grant busy7100.0.0.0   .0 
gc current grant congested485.77.13.63.6    
gc current retry191.7   8.3   
gcs log flush sync1100.0.0      
ges inquiry response399.9.0.0.0    
ges lms sync during dynamic remastering and reconfig198.61.4      
latch free9596.4 1.22.3.1.0  
latch: gc element199.4 .6     
latch: ges resource hash list5195.91.82.4     
library cache load lock43480.313.4 6.3    
library cache lock37490.5.31.32.8.1.1.14.8
library cache pin38696.1.23.7.0    
library cache: mutex X3100.0.0      
log file sync22100.0.0.0.0.0.0.0 
os thread startup891.42.92.91.01.0  1.0
process diagnostic dump299.9.0  .0   
resmgr:cpu quantum18100.0.0.0     
row cache cleanup1100.0.0      
row cache lock6100.0.0      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

  % of Total Waits
EventWaits 4m to 1h <2m <4m <8m<1/4h<1/2h< 1h>=1h
cursor: pin S wait on X6669.76.911.511.9   
enq: PR - contention180.020.0     
enq: TX - row lock contention499.0.8.3    
library cache lock38695.2.72.41.7   
os thread startup199.01.0     

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
coredb.248,2635,74432,377374,186
SYS$USERS1,0864047905
SYS$BACKGROUND003353
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. 249835342739157222608005149352392
SYS$USERS 7970341291317005485046
SYS$BACKGROUND 143111601842800000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
3,991.801,1123.591.600.040.057ncnu7ud2ykhu JDBC Thin Client insert into ORDERS (domesticin...
2,710.225542.041.090.120.00gt918y7x55jkh JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
2,596.585519.321.040.120.00azv5apyucyna9 JDBC Thin Client select * from ( select /*+USE_...
1,781.893593.960.710.120.00g2zczp1a02hk1 JDBC Thin Client select orderno, bookAgent from...
1,777.033592.340.710.120.0035q7sbkf9dqxu JDBC Thin Client select p.orderno, o.bookUser f...
1,733.574433.390.700.120.03d5zsfzmzs2r1w JDBC Thin Client select count(*) as returnstatu...
1,727.943575.980.690.120.02885s9c2hvbwqy JDBC Thin Client select count(*) as returnstatu...
1,687.164421.790.680.010.009awmqbn8w5tkq JDBC Thin Client SELECT O.STATUS, P.TICKETNO FR...
1,434.306239.050.580.090.00dchg4jkvzb5aw JDBC Thin Client SELECT 1 FROM ORDERS WHERE ORD...
1,342.723447.570.540.100.009w5zg0b4d0392 JDBC Thin Client SELECT 1 FROM ORDERS WHERE ORD...

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
545.151,6630.338.87729.1774.760.200a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
368.222281.625.99550.8766.840.10dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
259.07534.894.21402.4164.386.428663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
205.111,0840.193.34272.8475.170.00gyudauqxd8gqc JDBC Thin Client select ag.ORGAREA ORGAREA from...
158.872340.682.58351.7245.170.012ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
149.17236.492.43734.9620.3071.033bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
141.30562.522.30177.6879.530.00f71kx19hsq60a JDBC Thin Client select * from exchange t where...
87.921510.581.43113.9477.160.0058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
69.582340.301.1391.3276.190.547qkh5ucsbcqk6 JDBC Thin Client select sum(o.seatnum) from ord...
64.130 1.0489.5571.610.01b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...

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
522.052322.7015.04734.9620.3071.033bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
316.48935.169.12382.6011.5082.727zpq6vurnvy2v JDBC Thin Client select tt.changeno from segcha...
203.322010.175.86286.3020.2471.0273fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
107.281010.733.09151.7820.1070.68d6fwfwn6jjbsb JDBC Thin Client select distinct pi.orderno, o....
25.84530.490.74402.4164.386.428663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
16.8510,6020.000.4932.594.5751.711ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
9.1961.530.2636.5960.9225.11d38ugrdrr80np JDBC Thin Client select o.orderno, p.psgname, p...
9.1510,5190.000.2618.929.9948.379nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
9.00130.690.2643.3163.5020.7735s6v3maugv34 JDBC Thin Client select pi.orderno, o.createdat...
8.2810,6150.000.2415.616.0953.0881h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...

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
49,669,9011,66329,867.6513.23729.1774.8.20a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
28,623,613234122,323.137.63351.7245.202ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
26,691,67553503,616.517.11402.4164.46.48663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
16,197,51022871,041.714.32550.8766.8.1dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
14,599,68223462,391.803.8991.3276.2.57qkh5ucsbcqk6 JDBC Thin Client select sum(o.seatnum) from ord...
14,426,79015195,541.663.84113.9477.2058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
11,798,7711,08410,884.483.14272.8475.20gyudauqxd8gqc JDBC Thin Client select ag.ORGAREA ORGAREA from...
10,624,13223445,402.272.8376.8772.609b2r0p9d97p92 JDBC Thin Client select sum(t.seatnum) from ord...
9,179,84423399,123.652.45734.9620.3713bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
4,939,44123421,108.721.3274.2273.6067jr1q3uanf6w JDBC Thin Client select count(*) from orders o ...
4,891,9819543,553.441.30382.6011.582.77zpq6vurnvy2v JDBC Thin Client select tt.changeno from segcha...
4,866,06515132,225.601.3033.1074.5.7c5jycdptb6cj3 JDBC Thin Client select sum(o.seatnum) from ord...
4,254,4795873,353.091.1399.6158.701ubkxxgj9aynq JDBC Thin Client select * from (select c.chang...
3,989,05220199,452.601.06286.3020.27173fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
8,206,21623356,792.0025.36734.9620.3071.033bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
4,879,9249542,213.7815.08382.6011.5082.727zpq6vurnvy2v JDBC Thin Client select tt.changeno from segcha...
3,567,92020178,396.0011.02286.3020.2471.0273fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
1,783,96010178,396.005.51151.7820.1070.68d6fwfwn6jjbsb JDBC Thin Client select distinct pi.orderno, o....
2,6145349.320.01402.4164.386.428663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
1,29510,6020.120.0032.594.5751.711ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
7756129.170.0036.5960.9225.11d38ugrdrr80np JDBC Thin Client select o.orderno, p.psgname, p...
7491357.620.0043.3163.5020.7735s6v3maugv34 JDBC Thin Client select pi.orderno, o.createdat...
73910,5190.070.0018.929.9948.379nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
60210,6150.060.0015.616.0953.0881h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...

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
66,10266,102232,874.000.0014.403bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
28,74028,740201,437.000.006.2673fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
3,3773,37711307.000.000.748kvgs3007httw Foglight for Oracle <5.6.4.311> select /*+ rule */ decode(INST...
3,0703,07010307.000.000.67cdth6mx505rb3 Foglight for Oracle <5.5.8.127> select /*+ rule */ * from ( se...
2,6142,6145349.320.000.578663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
1,4371,43710143.700.000.31d6fwfwn6jjbsb JDBC Thin Client select distinct pi.orderno, o....
1,2951,29510,6020.120.000.281ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
73973910,5190.070.000.169nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
60260210,6150.060.000.1381h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...
40740712,3440.030.000.09f4uf0u8q871js JDBC Thin Client select min(pt.ticketno) as min...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
164,17000.0022.403.304yq6qwgw992zk JDBC Thin Client select CABINS from GENERALIZEL...
105,251105,2521.0033.1516.90ftj9uawt4wwzb   select condition from cdef$ wh...
92,02692,0241.0042.10.50520mkxqpf15q8 JDBC Thin Client select 1 from dual
91,60400.00135.451.80d4ggk0agny9tf JDBC Thin Client SET TRANSACTION READ WRITE
24,59724,5901.0020.834.518.609uaa1krtq5by JDBC Thin Client select f.agentfeereturntype fr...
20,71220,7111.002.7370bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
13,83513,8351.002.45.4087tu7wk540dwq JDBC Thin Client select MAX_THREAD_COUNT from p...
13,70913,7021.003.608.902dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...
12,37412,3671.004.7312.9.2bhvwd3sbwdyga JDBC Thin Client select f.isautoconfirm from fl...
12,34412,3371.002.675.60ckg1n91hh2qkk JDBC Thin Client select o.pricefileno from flig...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
164,033164,17011.324yq6qwgw992zk JDBC Thin Client select CABINS from GENERALIZEL...
105,252105,2517.26ftj9uawt4wwzb   select condition from cdef$ wh...
92,02392,0266.35520mkxqpf15q8 JDBC Thin Client select 1 from dual
91,59991,6046.32d4ggk0agny9tf JDBC Thin Client SET TRANSACTION READ WRITE
20,71020,7121.43bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
13,83513,8350.9587tu7wk540dwq JDBC Thin Client select MAX_THREAD_COUNT from p...
13,67113,7090.942dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...
12,34312,3430.85bhwz3x2mjy7s3 JDBC Thin Client SELECT PL.PNRNO FROM PNRLIST P...
12,34212,3430.855f0955qkz78g4 JDBC Thin Client select DOMESTICINDICATE from o...
12,34112,3430.85a7pqvnr44uy38 JDBC Thin Client SELECT HO.PAYMONEY, HO.HOTELOR...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
8,273,79000.08b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...
4,816,7284860.05c6awqs517jpj0   select /*+ index(idl_char$ i_i...
4,776,0934860.0539m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
4,597,2374860.05cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
4,032,19100.0489nf3yvxk8yq7 Foglight for Oracle <5.6.4.311> select /*+ rule */ rownum, sid...
2,341,5974920.02ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
1,834,83610.02dg13jqzazvhwg JDBC Thin Client select count(*) as count from ...
1,694,27600.02am19a1bvysghh Foglight for Oracle <5.6.4.311> select (jj.act_jobs_jobs + js....
1,691,8531,8760.0283taa7kaw59c1   select name, intcol#, segcol#,...
1,632,3561,6030.023w4qs0tbpmxr6   select con#, obj#, rcon#, enab...
1,060,7825440.011gu8t96d0bdmu   select t.ts#, t.file#, t.block...
1,056,2945440.011gu8t96d0bdmu   select t.ts#, t.file#, t.block...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
1270b0d1f3vqvdca7 Foglight for Oracle <5.5.8.127> select /*+ rule */ rownum, sid...
5148639m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
51486c6awqs517jpj0   select /*+ index(idl_char$ i_i...
51486cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
40492ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
390d0av6s1umpzgf Foglight for Oracle <5.5.8.127> select decode(dp.dest_param, '...
31069subccxd9b03 JDBC Thin Client SELECT signature, inuse_featur...
301,6033w4qs0tbpmxr6   select con#, obj#, rcon#, enab...
307bt51szvfrcdpn JDBC Thin Client SELECT obj_type, plan_id, comp...
291,87683taa7kaw59c1   select name, intcol#, segcol#,...
245441gu8t96d0bdmu   select t.ts#, t.file#, t.block...
245441gu8t96d0bdmu   select t.ts#, t.file#, t.block...
236,43753saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
236,43753saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
2215158z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
2128buzp8cfu6upry JDBC Thin Client SELECT C.CHANGENO, C.ORDERNO, ...
2128buzp8cfu6upry JDBC Thin Client SELECT C.CHANGENO, C.ORDERNO, ...

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
94.772343.70351.7226.9445.170.012ggs3r1ncmwwr JDBC Thin Client select count(*) as recordscoun...
53.07532.07402.4113.1964.386.428663vhj8vkpp0 JDBC Thin Client select/*+index(ORDERPNRLIST_F...
19.862280.77550.873.6066.840.10dugh7uyrn80b4 JDBC Thin Client select * from( select /*+ inde...
9.8512,3430.3817.4856.374.1823.96bhwz3x2mjy7s3 JDBC Thin Client SELECT PL.PNRNO FROM PNRLIST P...
9.361,6630.37729.171.2874.760.200a1z1knkykfwz JDBC Thin Client select p.psgname, p.pnrno, (se...
8.7810,6020.3432.5926.944.5751.711ugz7d875p582 JDBC Thin Client select o.paymode, pb.paystatus...
8.061,3600.3114.6055.208.4221.034vs91dcv7u1p6 JDBC Thin Client insert into sys.aud$( sessioni...
7.5124,5970.2920.8336.074.5118.5709uaa1krtq5by JDBC Thin Client select f.agentfeereturntype fr...
6.5312,3440.2520.7831.438.6628.12f4uf0u8q871js JDBC Thin Client select min(pt.ticketno) as min...
5.8420.23984.250.590.080.0099g18d3aqu23g JDBC Thin Client SELECT P.TYPE, P.PNRNO, RI.ORD...
5.5912,3430.229.6457.958.1914.135f0955qkz78g4 JDBC Thin Client select DOMESTICINDICATE from o...
5.4710,5620.2116.7832.598.4039.776u1fc9nj87uhd JDBC Thin Client SELECT S.SEGORDER, (S.CARRIER ...
4.7710,5190.1918.9225.239.9948.379nztpwka2vvp4 JDBC Thin Client SELECT SP.ORDERNO, SP.SEGORDER...
4.002,0770.161,294.460.310.090.017jk3kcjxvz83k JDBC Thin Client UPDATE PAYBILL SET PAYSTATUS =...
3.9730.151,093.890.360.070.00dx3zc47x1cw9p JDBC Thin Client select p.orderno from paybill ...
3.8412,3430.156.3160.809.660.02a7pqvnr44uy38 JDBC Thin Client SELECT HO.PAYMONEY, HO.HOTELOR...
3.765440.1516.2423.180.862.671gu8t96d0bdmu   select t.ts#, t.file#, t.block...
3.5510,6150.145.0969.7710.810.029tzrcb1d5f06z JDBC Thin Client SELECT O.ORDERNO, O.GROUPFLAG,...
3.382340.1376.874.4072.620.009b2r0p9d97p92 JDBC Thin Client select sum(t.seatnum) from ord...
2.899,9430.114.0272.0111.200.0095bdypfq2ky5g JDBC Thin Client select o.domesticindicate from...
2.76580.1199.612.7758.680.001ubkxxgj9aynq JDBC Thin Client select * from (select c.chang...
2.6312,3740.104.7355.5612.880.18bhvwd3sbwdyga JDBC Thin Client select f.isautoconfirm from fl...
2.622340.1074.223.5373.640.0567jr1q3uanf6w JDBC Thin Client select count(*) from orders o ...
2.3910,6150.0915.6115.296.0953.0881h1tf5rjb8jr JDBC Thin Client select pt.segorder, p.type, co...
2.321,1120.093,991.800.060.040.057ncnu7ud2ykhu JDBC Thin Client insert into ORDERS (domesticin...
2.0813,7090.083.6057.668.890.002dqj3rc7b0x8q JDBC Thin Client select o.Isautocreate from ord...
2.0710,6150.085.1140.537.630.005s3uwrd1gxt7q JDBC Thin Client SELECT NVL(AG.AGENTTYPE, OU1.F...
1.9560.081,434.300.140.090.00dchg4jkvzb5aw JDBC Thin Client SELECT 1 FROM ORDERS WHERE ORD...
1.891510.0729.316.4470.210.00g2yqaqwzb765r JDBC Thin Client select sum(t.seatnum) from ord...
1.5610,6150.062.9053.815.520.00g128myz1mz13n JDBC Thin Client select 1 from dual where exist...
1.541510.0645.603.3874.630.0852ngpnc7n319u JDBC Thin Client select count(*) from orders o ...
1.412340.0691.321.5576.190.547qkh5ucsbcqk6 JDBC Thin Client select sum(o.seatnum) from ord...
1.3710,5710.052.5653.608.580.008whvjha2fnk63 JDBC Thin Client SELECT F.TOTALPRICE, F.AGENTFE...
1.2912,3440.052.6748.425.620.00ckg1n91hh2qkk JDBC Thin Client select o.pricefileno from flig...
1.131510.04113.940.9977.160.0058z173u8h1kxc JDBC Thin Client select count(*) as recordscoun...
0.991510.0433.103.0074.500.72c5jycdptb6cj3 JDBC Thin Client select sum(o.seatnum) from ord...
0.97230.04734.960.1320.3071.033bf7cptakrtga JDBC Thin Client select p.orderno from passenge...
0.9030.031,781.890.050.120.00g2zczp1a02hk1 JDBC Thin Client select orderno, bookAgent from...
0.6330.021,133.480.060.010.0057g40763jz1hx JDBC Thin Client SELECT O.STATUS, P.TICKETNO FR...
0.5610,6150.026.638.475.8923.4090yfsh8rb8gma JDBC Thin Client select p.TYPE from paxinsuranc...
0.4450.02770.850.060.010.00fyn11ybbbgd4t JDBC Thin Client SELECT 1 FROM ORDERS WHERE ORD...
0.3790.01382.600.1011.5082.727zpq6vurnvy2v JDBC Thin Client select tt.changeno from segcha...
0.341090.012.3014.5947.470.00az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
0.30200.01286.300.1020.2471.0273fhvwt6xvk2x JDBC Thin Client select distinct pi.orderno fro...
0.2430.01782.410.030.010.00a1d4259qsz5s3 JDBC Thin Client SELECT 1 FROM ORDERS WHERE ORD...
0.2240.011,171.940.020.090.002duyv3zxb3gzb JDBC Thin Client select count(*) as orderstatus...
0.22130.0143.310.5163.5020.7735s6v3maugv34 JDBC Thin Client select pi.orderno, o.createdat...
0.2130.011,214.750.020.110.000sdd673b06r28 JDBC Thin Client select od.orderno, od.domestic...
0.2160.0136.590.5760.9225.11d38ugrdrr80np JDBC Thin Client select o.orderno, p.psgname, p...
0.1830.011,175.590.020.090.056t7d38cwb4t1a JDBC Thin Client select count(*) as returnstatu...
0.1630.011,777.030.010.120.0035q7sbkf9dqxu JDBC Thin Client select p.orderno, o.bookUser f...
0.1410,6150.012.585.598.920.0078txh8n821266 JDBC Thin Client select 1 from dual where exist...
0.14100.01151.780.0920.1070.68d6fwfwn6jjbsb JDBC Thin Client select distinct pi.orderno, o....
0.1330.011,727.940.010.120.02885s9c2hvbwqy JDBC Thin Client select count(*) as returnstatu...
0.124860.001.0211.6920.5770.55cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.082990.000.1941.9210.6226.497sn14ggsm4682 JDBC Thin Client insert into INTELTAXTOORDERS (...
0.0620.001,128.100.010.080.00bnkw4gr0bwb52 JDBC Thin Client select * from ( select /*+USE_...
0.05100.002.362.1621.1662.220nvtgf57cgppu JDBC Thin Client select count(*) as recordscoun...
0.0550.002,596.580.000.120.00azv5apyucyna9 JDBC Thin Client select * from ( select /*+USE_...
0.049710.000.3611.4719.6412.803nkd3g3ju5ph1   select obj#, type#, ctime, mti...
0.04710.000.854.1254.040.001qzsjc90kxcma JDBC Thin Client select count(*) as count from ...
0.031,8760.001.182.6121.1510.3883taa7kaw59c1   select name, intcol#, segcol#,...
0.034920.000.397.0731.0157.87ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
0.024860.000.404.3827.3867.8539m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
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
0nvtgf57cgppuselect count(*) as recordscount from orders t where t.bookuser='130002318390' and t.orderflag='C' and t.status in ('C', 'P') and t.createdate>=to_date('2013-02-07', 'yyyy-MM-dd')
0sdd673b06r28select od.orderno, od.domesticindicate, od.status, od.totalpaymoney, od.createdate, od.campaignscriptid, '' as SEGINFO, '' as PSGNUMINFO 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('080009930240', '080009930240')) and od.orderno = fp.orderno and sm.orderno = od.orderno and 1=1 group by od.orderno, od.status, fp.totalpaymoney, od.createdate, od.domesticindicate, od.campaignscriptid order by od.createdate desc ) od where rownum < 30
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# (+)
1qzsjc90kxcma select count(*) as count from adjustorder ao, orderadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and ao.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '122' connect by parentguid = prior orgunitguid) union select count(*) as count from adjustorder ao, refundadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and ao.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '122' connect by parentguid = prior orgunitguid) union select count(*) as count from adjustorder ao, changeadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and a o.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '122' connect by parentguid = prior orgunitguid)
1ubkxxgj9aynq select * from (select c.changeno from change c where c.changetype = 'P' and c.status = 'V' order by c.dealtime asc)x where rownum < 2
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
2dqj3rc7b0x8qselect o.Isautocreate from orders o where o.orderno = :1
2duyv3zxb3gzbselect 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 ('113907597020' , '113907597020' , '320106196602131223' )) 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
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')
35q7sbkf9dqxuselect p.orderno, o.bookUser from payment p, orders o where o.orderno=p.orderno and p.billno = 'CMB020130807794320' and o.bookagent='HR'
35s6v3maugv34select pi.orderno, o.createdate, pi.psgname, p.idcard, pi.segorder, pi.insuranceno , sg.carrier, sg.flightno, pi.officecode, pi.orgname, pi.orgarea, sg.depairport, sg.arrairport, sg.deptime, pt.ticketno, pi.amount from paxinsurance pi join orders o on o.orderno=pi.orderno join psgticket pt on pt.orderno=pi.orderno and pt.psgname=pi.psgname and pt.segorder=pi.segorder join segment sg on sg.orderno=pi.orderno and sg.segorder=pi.segorder join passenger p on p.orderno=pi.orderno and p.psgname=pi.psgname where pi.status='2' and pi.type='0' and pi.insuranceno is not null and o.orderno in (select orderno from (select o1.orderno from orders o1, paxinsurance pi1 where o1.orderno = pi1.orderno and o1.ticketoutagent not in('6187', '9549', '6110', '9597', '9484', '9483', '9485', '6564', '9232', '9587', '9602') and pi1.status ='2' and pi1.type = '0' and o1.status = 'E' and o1.createdate > sysdate -30 and o1.createdate <sysdate ) where rownum <'30') order by pi.psgname, pi.segorder
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
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
3w4qs0tbpmxr6select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :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)
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'
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
57g40763jz1hxSELECT O.STATUS, P.TICKETNO FROM ORDERS O, PSGTICKET P WHERE O.ORDERNO='C1308070028571' AND P.ORDERNO='C1308070028571'
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')
5f0955qkz78g4select DOMESTICINDICATE from orders where orderno = :1
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
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
6t7d38cwb4t1aselect count(*) as returnstatustotal from refundorder ref, orders o where o.orderno = ref.orderno AND (REF.STATUS ='U' OR REF.STATUS = 'N' OR REF.STATUS = 'Y') and (o.bookuser = '113907597020' or o.bookuser = '113907597020' ) and rownum <= 100 and ref.createtime>=to_date('2013-05-09', 'yyyy-MM-dd') order by ref.createtime desc
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
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')
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 )
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'
7sn14ggsm4682insert into INTELTAXTOORDERS (taxtype, taxcurrency, taxindex, taxcategory, taxamount, orderno, psgtype) values (:1, :2, :3, :4, :5, :6, :7)
7zpq6vurnvy2vselect tt.changeno from segchange tt , change c, orders oi where tt.orderno=:1 and tt.changeno = c.changeno and c.status= 'E' and oi.campaignscriptid='15'
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
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#
8663vhj8vkpp0 select/*+index(ORDERPNRLIST_FK) */ o.orderno , p.pnrno from orders o , pnrlist p where o.orderno = p.orderno and o.status = 'E' and o.groupflag = '1' and o.groupname is not null and o.createdate > sysdate - 7 and ( p.sendtomask is null or ( p.sendtomask = '1' and (sysdate - p.sendtomasktime) > 1 / 48 ) ) and rownum <= 100
87tu7wk540dwqselect MAX_THREAD_COUNT from partener_interface p where p.partnerid='QQ' and p.interfaceid='AVPRICE_JAXB'
885s9c2hvbwqyselect count(*) as returnstatustotal from refundorder ref, orders o where o.orderno = ref.orderno AND (REF.STATUS ='U' OR REF.STATUS = 'N' OR REF.STATUS = 'Y') and (o.bookuser = '13875098898' or o.bookuser = '13875098898' ) and rownum <= 100 and ref.createtime>=to_date('2013-05-09', 'yyyy-MM-dd') order by ref.createtime desc
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)
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
90yfsh8rb8gmaselect p.TYPE from paxinsurance p where p.orderno = :1
95bdypfq2ky5gselect o.domesticindicate from orders o where o.orderno = :1
99g18d3aqu23gSELECT P.TYPE, P.PNRNO, RI.ORDERNO, RI.PSGNAME, RI.REFUNDNO, RI.REFUNDSEGMENT, nvl(RI.COST, 0) COST, nvl(ri.basicfee, 0) basicfee, RI.USEDCOST, RI.TAX1, RI.TAX2, RI.TAX3, RI.REFUNDAGETNFEE, RI.REFUNDCOST, RI.REFUNDTAX, nvl(RI.COSTSPEND, 0) COSTSPEND, RI.REFUNDFEE, nvl(RI.REFUNDMONEY, 0) REFUNDMONEY, nvl(RI.REFUNDMONEYLOCAL, 0) REFUNDMONEYLOCAL, nvl(RI.REPAYMONEY, 0) REPAYMONEY, nvl(RI.REPAYMONEYLOCAL, 0) REPAYMONEYLOCAL, RI.PRINTREFUNDNO FROM REFUNDINTERNATIONAL RI, PASSENGER P WHERE RI.ORDERNO = P.ORDERNO AND RI.PSGNAME = P.PSGNAME AND RI.REFUNDNO = 'T13080708450'
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'
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
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
9w5zg0b4d0392SELECT 1 FROM ORDERS WHERE ORDERNO='C1308070027893'
a1d4259qsz5s3SELECT 1 FROM ORDERS WHERE ORDERNO='B1308070079448' AND (BOOKAGENT IN ('2243') OR TICKETOUTAGENT IN ('2243') OR SHIPAGENT IN ('2243')) AND DOMESTICINDICATE <> '0'
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
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
azv5apyucyna9select * 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 orders.orderno in (select p.orderno from pnrlist p where p.pnrno ='NX8T60') and 1=1 and orders.bookagent in (select orgunitguid from organizationunitprofile start with orgunitguid = '3913' connect by parentguid = prior orgunitguid) order by orders.orderno desc) tem where rownum <= :1
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
bnkw4gr0bwb52select * 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-8-7', 'yyyy-MM-dd') + 1 and orders.orderno in (select p.orderno from pnrlist p where p.pnrno ='NT154C') and 1=1 and orders.bookagent in (select orgunitguid from organizationunitprofile start with orgunitguid = '3712' connect by parentguid = prior orgunitguid) order by orders.orderno desc) tem where rownum <= :1
bt51szvfrcdpnSELECT obj_type, plan_id, comp_data FROM sqlobj$data WHERE signature = :1 AND category = :2
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'
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cdth6mx505rb3 select /*+ rule */ * from ( 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) ) where 1=1
ckg1n91hh2qkkselect o.pricefileno from flightpricedomestic o where o.orderno = :1
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d0av6s1umpzgfselect decode(dp.dest_param, 'no', dir.dr, a.destination) "dest_directory", nvl(r.arch_sum, 0) "arch_sum", nvl(r.arch_sum, 0) "arch_rate", a.avg_arch_size "avg_arch_size", a.binding "binding", 0 "dest_total", 0 "dest_free_space" from (select destination, (sum (blocks * block_size)/1024/1024) arch_sum from sys.gv_$archived_log l, sys.gv_$archive_dest ad where l.completion_time > sysdate - :1/1000/60/60/24 AND l.standby_dest = 'NO' AND ad.dest_id = l.dest_id group by destination) r, (select d.destination destination, avg((l.blocks * l.block_size)/1024/1024) avg_arch_size, d.binding binding from sys.gv_$archived_log l, sys.gv_$archive_dest d where d.destination is not null and d.dest_id=l.dest_id and upper(d.target)!='STANDBY' group by d.destination, d.binding) a, (select decode(value, NULL, 'no', 'yes') dest_param from sys.v_$parameter where name like 'log_archive_dest_1') dp, (select destination, decode(substr(max(name), 1, instr(max(name), '/', -1, 1)), null, substr(max(name), 1, instr(max(name), '\', -1, 1)), substr(max(name), 1, instr(max(name), '/', -1, 1))) dr from sys.gv_$archived_log l, sys.gv_$archive_dest ad where l.dest_id = ad.dest_id group by destination) dir where a.destination=r.destination(+) and a.destination = dir.destination
d38ugrdrr80npselect o.orderno, p.psgname, p.idcard, pt.ticketno, pt.segorder, s.carrier, s.flightno, s.depairport, s.arrairport, s.deptime, s.arrtime, o.createdate, sysdate, pi.officecode, pi.orgname, pi.orgarea from orders o join segment s on o.orderno = s.orderno join passenger p on p.orderno = o.orderno join psgticket pt on pt.orderno = o.orderno and pt.psgname = p.psgname and pt.segorder=s.segorder join paxinsurance pi on pi.orderno = pt.orderno and pi.psgname = pt.psgname and pi.segorder = pt.segorder and pi.status = '0' and pi.type='0' where o.orderno in (select orderno from (select /*+ index(o1 IDX_CREATEDATE_STATUS) */ o1.orderno from orders o1, paxinsurance pi1 where o1.orderno = pi1.orderno and (o1.bookagent in (select orgunitguid from ecs.organizationunitprofile start with orgunitguid = 'B2COU' connect by parentguid = prior orgunitguid) or o1.ticketoutagent in('122', '2736', '9558', '8333', '9601', '9598')) and pi1.status ='0' and pi1.type = '0' and o1.status = 'E' and o1.createdate > sysdate -3 and o1.createdate <sysdate) where rownum <'30') order by pt.ticketno, pi.segorder
d4ggk0agny9tfSET TRANSACTION READ WRITE
d5zsfzmzs2r1wselect count(*) as returnstatustotal from refundorder ref, orders o where o.orderno = ref.orderno AND (REF.STATUS ='U' OR REF.STATUS = 'N' OR REF.STATUS = 'Y') and (o.bookuser = '680013519428' or o.bookuser = '680013519428' ) and rownum <= 100 and ref.createtime>=to_date('2013-05-09', 'yyyy-MM-dd') order by ref.createtime desc
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')
dchg4jkvzb5awSELECT 1 FROM ORDERS WHERE ORDERNO='B1308070079477' AND (BOOKAGENT IN ('3230') OR TICKETOUTAGENT IN ('3230') OR SHIPAGENT IN ('3230')) AND DOMESTICINDICATE <> '0'
dg13jqzazvhwg select count(*) as count from adjustorder ao, orderadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and ao.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '2166' connect by parentguid = prior orgunitguid) union select count(*) as count from adjustorder ao, refundadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and ao.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '2166' connect by parentguid = prior orgunitguid) union select count(*) as count from adjustorder ao, changeadjust j where ao.adjustno = j.adjustno and ( ('123456' = '123456' and ao.TYPE <> '7' ) or ('123456' = '12' and ao.TYPE in ('1', '2')) or ('123456' = '3' and ao.TYPE='3') or ('123456' = '45' and ao.TYPE in ('4', '5')) or ('123456' = '6' and ao.TYPE = '6') or ('123456' = '9' and ao.TYPE = '9') or ('123456' = '8' and ao.TYPE = '8') or ('123456' = 'IJ' and ao.TYPE in ('I', 'J')) or ('123456' = 'K' and ao.TYPE = 'K') or ('123456' = 'LM' and ao.TYPE in ('L', 'M')) or ('123456' = 'N' and ao.TYPE = 'N') or ('123456' = 'OQ' and ao.TYPE in ('O', 'Q')) or ('123456' = 'P' and ao.TYPE = 'P')) AND ( ('S' = 'S' and ao.STATUS = 'S' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ( 'S' = 'P' and ao.STATUS='P' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'B' and ao.STATUS='B' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) or ('S' = 'SYN' and ao.STATUS in('S', 'Y', 'N') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ('S'='RTF' and ao.STATUS in('R', 'T', 'F') and ao.TYPE in('3', '6', '8', 'K', 'N', 'P') ) or ( 'S' = 'X' and ao.STATUS='X' and ao.TYPE in('1', '2', '4', '5', '9', 'I', 'J', 'L', 'M', 'O', 'Q') ) ) and ao.saleouid in (select orgunitguid from organizationunitprofile start with orgunitguid = '2166' connect by parentguid = prior orgunitguid)
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
dx3zc47x1cw9pselect p.orderno from paybill b, payment p where b.billno=p.billno and b.billno='TEN020130807794516'
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
f71kx19hsq60aselect * from exchange t where t.ecsno like '%B%' and t.exchangedate >= (sysdate-10/24/60)
ftj9uawt4wwzbselect condition from cdef$ where rowid=:1
fyn11ybbbgd4tSELECT 1 FROM ORDERS WHERE ORDERNO='B1308070079466' AND (BOOKAGENT IN ('7695') OR TICKETOUTAGENT IN ('7695') OR SHIPAGENT IN ('7695')) AND DOMESTICINDICATE <> '0'
g128myz1mz13nselect 1 from dual where exists (select 1 from orders o where o.orderno = :1 and o.orderflag='C' )
g2yqaqwzb765rselect sum(t.seatnum) from orders t, segment s where t.bookuser='580008619967' 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'
g2zczp1a02hk1select orderno, bookAgent from orders where orderno = (select orderno from payment where billno = 'CRED020130807794376')
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gt918y7x55jkhSELECT 1 FROM DUAL WHERE EXISTS (select 1 from orders o where o.orderno = 'B1308050016446' and o.domesticindicate = '1')
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 count1,8180.500.01
Batched IO (full) vector count150.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count36,75010.180.22
Batched IO buffer defrag count2860.080.00
Batched IO double miss count2,0300.560.01
Batched IO same unit count12,1853.380.07
Batched IO single block count1,0910.300.01
Batched IO slow jump count110.000.00
Batched IO vector block count23,7976.590.14
Batched IO vector read count2,4100.670.01
Block Cleanout Optim referenced2,4580.680.01
CCursor + sql area evicted3,6771.020.02
CPU used by this session555,126153.813.33
CPU used when call started530,712147.053.19
CR blocks created30,4578.440.18
Cached Commit SCN referenced1,8360.510.01
Clusterwide global transactions160.000.00
Clusterwide global transactions spanning RAC nodes00.000.00
Commit SCN cached3,6921.020.02
DB time24,754,8616,858.92148.62
DBWR checkpoint buffers written47,31713.110.28
DBWR checkpoints1500.040.00
DBWR fusion writes18,0685.010.11
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written1,6900.470.01
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes7970.220.00
DBWR undo block writes22,5766.260.14
DFO trees parallelized390.010.00
DX/BB enqueue lock background get time150.000.00
DX/BB enqueue lock background gets320.010.00
DX/BB enqueue lock foreground requests2660.070.00
DX/BB enqueue lock foreground wait time200.010.00
Effective IO time2,002,720,183554,901.4012,023.94
HSC Heap Segment Block Changes218,01160.411.31
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts4,5791.270.03
LOB table id lookup cache misses00.000.00
Number of read IOs issued256,02670.941.54
PX local messages recv'd720.020.00
PX local messages sent720.020.00
PX remote messages recv'd2,5180.700.02
PX remote messages sent6,9931.940.04
Parallel operations downgraded to serial00.000.00
Parallel operations not downgraded390.010.00
RowCR - row contention8610.240.01
RowCR attempts78,21021.670.47
RowCR hits78,25621.680.47
SMON posted for instance recovery00.000.00
SMON posted for undo segment shrink440.010.00
SQL*Net roundtrips to/from client5,194,2761,439.2031.19
SQL*Net roundtrips to/from dblink00.000.00
active txn count during cleanout108,49730.060.65
application wait time127,77435.400.77
background checkpoints completed10.000.00
background checkpoints started10.000.00
background timeouts45,00712.470.27
branch node splits40.000.00
buffer is not pinned count169,335,76446,918.511,016.66
buffer is pinned count563,469,892156,122.783,382.96
bytes received via SQL*Net from client408,556,120113,200.222,452.89
bytes received via SQL*Net from dblink00.000.00
bytes sent via SQL*Net to client557,501,412154,469.073,347.13
bytes sent via SQL*Net to dblink00.000.00
calls to get snapshot scn: kcmgss1,657,069459.139.95
calls to kcmgas457,520126.772.75
calls to kcmgcs195,63954.211.17
cell physical IO interconnect bytes267,461,221,37674,106,512.001,605,785.40
change write time1,8380.510.01
cleanout - number of ktugct calls40,17311.130.24
cleanouts and rollbacks - consistent read gets26,9067.450.16
cleanouts only - consistent read gets2,4700.680.01
cluster key scan block gets36,51510.120.22
cluster key scans24,8266.880.15
cluster wait time256,27171.011.54
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed15,6004.320.09
commit batch/immediate requested15,6004.320.09
commit cleanout failures: block lost2,1900.610.01
commit cleanout failures: buffer being written40.000.00
commit cleanout failures: callback failure1,0310.290.01
commit cleanout failures: cannot pin1510.040.00
commit cleanouts283,87578.651.70
commit cleanouts successfully completed280,49977.721.68
commit immediate performed15,6004.320.09
commit immediate requested15,6004.320.09
commit txn count during cleanout55,00615.240.33
concurrency wait time22,290,4036,176.09133.83
consistent changes107,43629.770.65
consistent gets373,718,913103,547.742,243.74
consistent gets - examination22,299,8876,178.72133.88
consistent gets direct32,074,6278,887.04192.57
consistent gets from cache341,644,27394,660.702,051.17
consistent gets from cache (fastpath)314,977,11587,271.921,891.06
cursor authentications30,4528.440.18
data blocks consistent reads - undo records applied102,68728.450.62
db block changes1,297,179359.417.79
db block gets1,600,430443.449.61
db block gets direct9380.260.01
db block gets from cache1,599,492443.189.60
db block gets from cache (fastpath)421,119116.682.53
deferred (CURRENT) block cleanout applications87,64724.280.53
dirty buffers inspected2,6690.740.02
enqueue conversions18,9415.250.11
enqueue deadlocks00.000.00
enqueue releases1,179,807326.897.08
enqueue requests1,180,106326.987.09
enqueue timeouts150.000.00
enqueue waits4,5521.260.03
exchange deadlocks1,2020.330.01
execute count1,738,534481.7010.44
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time1,782,770,607493,959.1310,703.41
frame signature mismatch00.000.00
free buffer inspected538,302149.153.23
free buffer requested743,299205.954.46
gc blocks compressed218,70860.601.31
gc blocks lost00.000.00
gc cr block flush time55,32415.330.33
gc cr block receive time58,79516.290.35
gc cr blocks received149,30041.370.90
gc cr blocks served165,65945.900.99
gc current block flush time23,9006.620.14
gc current block pin time1,8990.530.01
gc current block receive time66,12218.320.40
gc current blocks received225,40562.451.35
gc current blocks served471,429130.622.83
gc kbytes saved671,330186.014.03
gc kbytes sent4,425,3741,226.1626.57
gc local grants258,00071.491.55
gc remote grants103,82628.770.62
gcs messages sent1,521,837421.669.14
ges messages sent142,88639.590.86
global enqueue get time19,009,3715,267.00114.13
global enqueue gets async21,9196.070.13
global enqueue gets sync2,033,416563.4112.21
global enqueue releases2,040,099565.2612.25
heap block compress2,9840.830.02
hot buffers moved to head of LRU580,767160.923.49
immediate (CR) block cleanout applications29,3818.140.18
immediate (CURRENT) block cleanout applications19,1425.300.11
index crx upgrade (positioned)4620.130.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)5,7131.580.03
index fetch by key4,638,7351,285.2727.85
index scans kdiixs192,431,86525,610.45554.94
leaf node 90-10 splits3900.110.00
leaf node splits1,3670.380.01
lob reads1,0140.280.01
lob writes2130.060.00
lob writes unaligned2130.060.00
logons cumulative2,3460.650.01
max cf enq hold time130.000.00
messages received191,33953.021.15
messages sent191,33953.021.15
min active SCN optimization applied on CR12,0153.330.07
no buffer to keep pinned count470.010.00
no work - consistent read gets350,212,63097,034.762,102.61
non-idle wait count12,746,3673,531.6976.53
non-idle wait time23,924,0796,628.74143.64
opened cursors cumulative1,724,022477.6810.35
parse count (describe)410.010.00
parse count (failures)2,3140.640.01
parse count (hard)183,92450.961.10
parse count (total)1,449,123401.518.70
parse time cpu44,50212.330.27
parse time elapsed19,054,7185,279.56114.40
physical read IO requests459,021127.182.76
physical read bytes265,120,169,98473,457,867.871,591,730.18
physical read total IO requests487,466135.062.93
physical read total bytes266,008,152,57673,703,904.631,597,061.45
physical read total multi block requests255,96270.921.54
physical reads32,363,3028,967.02194.30
physical reads cache289,01780.081.74
physical reads cache prefetch128,42835.580.77
physical reads direct32,074,2858,886.95192.57
physical reads direct (lob)170.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests42,44411.760.25
physical write bytes557,547,520154,481.843,347.41
physical write total IO requests175,44548.611.05
physical write total bytes1,453,069,312402,607.528,723.95
physical write total multi block requests1,7200.480.01
physical writes68,06018.860.41
physical writes direct9800.270.01
physical writes direct (lob)30.000.00
physical writes direct temporary tablespace20.000.00
physical writes from cache67,08018.590.40
physical writes non checkpoint46,38412.850.28
pinned buffers inspected910.030.00
pinned cursors current290.010.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use140.000.00
process last non-idle time3,5961.000.02
queries parallelized350.010.00
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls2,768,690767.1316.62
recursive cpu usage69,55419.270.42
redo KB read446,526123.722.68
redo blocks checksummed by FG (exclusive)70,23519.460.42
redo blocks written535,420148.353.21
redo buffer allocation retries110.000.00
redo entries750,516207.954.51
redo log space requests70.000.00
redo log space wait time400.010.00
redo ordering marks21,7956.040.13
redo size229,340,66463,544.301,376.92
redo size for direct writes7,742,8562,145.3446.49
redo subscn max counts9,1182.530.05
redo synch long waits21,8636.060.13
redo synch time122,85134.040.74
redo synch time (usec)1,229,473,503340,654.967,381.52
redo synch writes71,15319.710.43
redo wastage35,970,6369,966.52215.96
redo write broadcast ack count57,72015.990.35
redo write broadcast ack time88,710,56724,579.38532.60
redo write broadcast lgwr post count60.000.00
redo write time33,7659.360.20
redo writes121,95833.790.73
remote Oradebug requests30.000.00
rollback changes - undo records applied43,09611.940.26
rollbacks only - consistent read gets6,3051.750.04
root node splits00.000.00
rows fetched via callback2,617,416725.2215.71
scheduler wait time273,46675.771.64
session connect time00.000.00
session cursor cache hits536,102148.543.22
session logical reads375,319,203103,991.142,253.34
shared hash latch upgrades - no wait1,004,818278.416.03
shared hash latch upgrades - wait4660.130.00
sorts (disk)00.000.00
sorts (memory)2,008,079556.3912.06
sorts (rows)192,601,87753,364.941,156.34
sql area evicted177,55549.201.07
sql area purged6070.170.00
summed dirty queue length7,6932.130.05
switch current to new buffer7,1531.980.04
table fetch by rowid315,426,75287,396.511,893.76
table fetch continued row231,45464.131.39
table scan blocks gotten154,970,04142,938.15930.41
table scan rows gotten12,358,543,4133,424,229.2874,198.30
table scans (cache partitions)00.000.00
table scans (direct read)2160.060.00
table scans (long tables)2160.060.00
table scans (rowid ranges)00.000.00
table scans (short tables)58,87916.310.35
temp space allocated (bytes)00.000.00
total cf enq hold time10,2602.840.06
total number of cf enq holders3950.110.00
total number of times SMON posted760.020.00
transaction lock background gets1720.050.00
transaction lock foreground requests1720.050.00
transaction lock foreground wait time480.010.00
transaction rollbacks15,5924.320.09
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size70,904,03219,645.65425.69
user I/O wait time346,83396.102.08
user calls5,703,9971,580.4334.25
user commits53,47014.820.32
user rollbacks113,09131.330.68
workarea executions - onepass00.000.00
workarea executions - optimal1,423,616394.458.55
write clones created in background00.000.00
write clones created in foreground210.010.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max437,601,873,808439,090,903,504
session cursor cache count34,246,44134,276,512
session uga memory338,911,012,231,392339,057,358,403,592
opened cursors current3,6696,576
workarea memory allocated18,83913,991
logons current501838
session uga memory max3,613,682,057,4083,616,545,214,272
session pga memory321,797,052,400323,144,804,464

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)
Direct Reads244.3G70.8269.30140M0.000M0 
Buffer Cache Reads2.2G56.12.6250780M0.000M160.2K9.06
Others844M7.87.233850592M2.90.16402733K3.24
DBWR0M0.000M524M11.74.1451860 
LGWR0M0.000M262M33.96.072593122K2.30
Direct Writes0M0.000M7M0.02.0019390 
Streams AQ0M0.000M0M0.000M1318.62
TOTAL:247.3G134.8270.16031.4G48.63.383747315.3K5.84

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 File246.5G128.0069.9303526M11.76.1457407.0040.11
Log File436M0.12.120804262M33.96.0725934.0070.25
Control File377M6.68.104456157M2.77.0435003.6079.00
Archive Log0M0.000M436M0.12.120804  
Other0M0.010M0M0.010M0.20 
Temp File0M0.010M0M0.000M1.92 
TOTAL:247.3G134.8270.15561.3G48.63.3826386.6440.16

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads 244.1G70.7869.25650M0.000M0 
Direct Reads (Data File) 244.1G70.7869.25650M0.000M0 
Buffer Cache Reads 2.2G56.13.6253550M0.000M158.9K8.93
Buffer Cache Reads (Data File) 2.2G56.13.6253550M0.000M158.9K8.93
Others 844M7.87.233850592M2.89.16402728K3.33
Others (Control File) 377M6.67.104456156M2.77.04322324.1K3.60
Others (Archive Log) 0M0.000M436M0.12.1208040 
Others (Log File) 436M0.12.1208040M0.000M43.25
Others (Data File) 31M1.07.0085890M0.000M38771.66
DBWR 0M0.000M524M11.74.1451860 
DBWR (Data File) 0M0.000M524M11.74.1451860 
LGWR 0M0.000M262M33.97.072593192.68
LGWR (Log File) 0M0.000M262M33.96.07259341.25
LGWR (Control File) 0M0.000M0M0.010M153.07
Direct Writes 0M0.000M7M0.02.0019390 
Direct Writes (Data File) 0M0.000M7M0.02.0019390 
Streams AQ 0M0.000M0M0.000M1318.62
Streams AQ (Data File) 0M0.000M0M0.000M1318.62
TOTAL: 247.1G134.7870.11571.4G48.61.383747186.9K8.10

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 391,2341081.6482.6016,896520,0972.84
core_INDEX 39,6051112.131.0013,73642,75848.79
USERS 23,439610.801.007,05522,112179.16
SYSTEM 3,29614.081.011220433589.28
UNDOTBS2 129017.211.002,47611012.57
SYSAUX 1,000012.075.871,116000.00
QUEST 47107.561.17985000.00
ETS_TMP 8802.731.001000.00
TEMP 6010.001.002000.00
AMSDATA 200.001.004000.00
UNDOTBS1 200.001.0010361245.54
AMSINDEX 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
AMSDATA+DATADG/coredb/datafile/amsdata.297.786494983 100.001.003000.00
AMSDATA+DATADG/coredb/datafile/amsdata.309.817664033 100.001.001000.00
AMSINDEX+DATADG/coredb/datafile/amsindex.298.786495075 100.001.001000.00
coredata+DATADG/coredb/datafile/coredata.270.730202259 36,050101.41104.071,44802,3851.59
coredata+DATADG/coredb/datafile/coredata.271.730202435 36,828101.38104.501,81012,4551.03
coredata+DATADG/coredb/datafile/coredata.272.730202619 37,032101.37102.042,79912,2040.90
coredata+DATADG/coredb/datafile/coredata.273.730202791 35,847101.44101.572,46112,1150.73
coredata+DATADG/coredb/datafile/coredata.274.730202937 37,151101.56100.512,76612,1120.82
coredata+DATADG/coredb/datafile/coredata.283.745515419 36,147101.39103.881,79102,2822.84
coredata+DATADG/coredb/datafile/coredata.295.783256433 62,928171.6756.8726801,6511.05
coredata+DATADG/coredb/datafile/coredata.296.783257507 64,127181.7556.0567101,6181.34
coredata+DATADG/coredb/datafile/coredata.305.796495117 25,64672.4766.142,03112,22813.64
coredata+DATADG/coredb/datafile/coredata.307.803139899 19,47852.4248.1885101,0474.47
core_INDEX+DATADG/coredb/datafile/core_index.276.730204269 4,073111.261.009140190152.58
core_INDEX+DATADG/coredb/datafile/core_index.277.730204109 4,044111.641.001,218011032.55
core_INDEX+DATADG/coredb/datafile/core_index.280.730204413 4,099110.481.001,833132320.80
core_INDEX+DATADG/coredb/datafile/core_index.281.730204551 2,718112.301.001,07408013.63
core_INDEX+DATADG/coredb/datafile/core_index.282.730204685 3,293111.231.0091802924.83
core_INDEX+DATADG/coredb/datafile/core_index.286.745515665 2,705112.181.0069301253.33
core_INDEX+DATADG/coredb/datafile/core_index.291.771353279 3,008112.091.001,39902018.00
core_INDEX+DATADG/coredb/datafile/core_index.292.771353509 1,789014.181.0048302988.28
core_INDEX+DATADG/coredb/datafile/core_index.293.783255523 2,570113.751.001,05503638.89
core_INDEX+DATADG/coredb/datafile/core_index.294.783255951 2,759113.071.001,220096644.01
core_INDEX+DATADG/coredb/datafile/core_index.302.796411061 2,341114.121.00777019921.76
core_INDEX+DATADG/coredb/datafile/core_index.303.796493979 2,933112.081.001,2490217136.22
core_INDEX+DATADG/coredb/datafile/core_index.306.803129617 3,273112.101.00903054722.10
ETS_TMP+DATADG/coredb/datafile/ets_tmp.275.730287209 8802.731.001000.00
QUEST+DATADG/coredb/datafile/quest.289.748266187 47107.561.17985000.00
SYSAUX+DATADG/coredb/datafile/sysaux.260.729362609 927012.296.251,017000.00
SYSAUX+DATADG/coredb/datafile/sysaux.301.787835057 7309.321.0399000.00
SYSTEM+DATADG/coredb/datafile/system.259.729362599 3,29614.081.011220433589.28
TEMP+DATADG/coredb/tempfile/temp.262.729362685 6010.001.00200 
UNDOTBS1+DATADG/coredb/datafile/undotbs1.261.744737439 200.001.0010361245.54
UNDOTBS2+DATADG/coredb/datafile/undotbs2.263.744738251 129017.211.002,47611012.57
USERS+DATADG/coredb/datafile/users.264.730203979 3,200110.521.009450377419.10
USERS+DATADG/coredb/datafile/users.278.730203631 3,591111.141.001,661065428.46
USERS+DATADG/coredb/datafile/users.279.730203813 3,422110.581.00710045623.78
USERS+DATADG/coredb/datafile/users.287.733311617 4,867110.291.0085001,154114.96
USERS+DATADG/coredb/datafile/users.288.733311861 3,457110.771.001,498042472.76
USERS+DATADG/coredb/datafile/users.290.745515943 3,254110.871.0066704321.40
USERS+DATADG/coredb/datafile/users.300.787832331 745012.321.002280210.00
USERS+DATADG/coredb/datafile/users.304.796494633 464013.811.00493000.00
USERS+DATADG/coredb/datafile/users.308.803140519 439011.391.003025.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D1,746,218100343,084,719288,98366,9650025,995

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000045,6250

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
B095673466302896542488320289654  4
E0106958649262893312488320289331  5

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D1,4720.1017444.23103,769,1081682308187.00
D2,9440.2034821.8451,242,1671332652794.00
D4,4160.3052211.4326,812,2741170030634.00
D5,8880.406966.1414,394,071187366533.00
D7,3600.508693.417,998,493144793169.00
D8,8320.601,0432.135,001,171124840936.00
D10,3040.701,2171.553,638,780115771927.00
D11,7760.801,3911.272,970,816111325496.00
D13,2480.901,5651.112,597,44118840052.00
D14,7201.001,7391.002,353,77917218075.00
D14,7841.001,7461.002,346,16817167410.00
D16,1921.101,9130.932,178,67616052470.00
D17,6641.192,0870.872,045,03115162833.00
D19,1361.292,2600.831,944,18014491503.00
D20,6081.392,4340.791,864,06413958194.00
D22,0801.492,6080.771,797,37613514272.00
D23,5521.592,7820.741,741,31713141109.00
D25,0241.692,9560.721,691,90112812162.00
D26,4961.793,1300.701,646,12512507444.00
D27,9681.893,3040.681,595,56012170844.00
D29,4401.993,4780.651,534,04811761384.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0044,2640

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,7022,756.7411.590.42100.000.00629,140
E6,1442,7994,113.900.190.00100.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,379,4971,379,49700
64K128K6,8036,80300
128K256K98098000
256K512K38238200
512K1024K16,09216,09200
1M2M19,76019,76000
4M8M505000
8M16M454500
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.13116,501,759.4837,594,431.2276.002,042,059151,236,799,984
1,5360.25116,501,759.4836,078,048.5476.001,945,618149,748,555,130
3,0720.50116,501,759.48284,001.90100.001,744114,618,698,585
4,6080.75116,501,759.48243,228.32100.000114,578,681,602
6,1441.00116,501,759.4831,805.25100.000114,371,181,665
7,3731.20116,501,759.4830,851.84100.000114,370,245,956
8,6021.40116,501,759.4830,851.84100.000114,370,245,956
9,8301.60116,501,759.4830,851.84100.000114,370,245,956
11,0591.80116,501,759.4830,851.84100.000114,370,245,956
12,2882.00116,501,759.4830,851.84100.000114,370,245,956
18,4323.00116,501,759.4830,851.84100.000114,370,245,956
24,5764.00116,501,759.4830,851.84100.000114,370,245,956
36,8646.00116,501,759.4830,851.84100.000114,370,245,956
49,1528.00116,501,759.4830,851.84100.000114,370,245,956

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)
9,4721.0046134,04066,428,3701.004,039,0691.001,680,417
10,4321.101,42796,39566,498,1771.003,969,2620.983,548,017
11,3921.202,386148,21666,610,9861.003,856,4530.953,566,465
12,3521.303,345199,44666,670,9491.003,796,4900.943,577,788
13,3121.414,305250,47266,706,9851.003,760,4540.933,585,069
14,2721.515,264301,70966,730,8571.003,736,5820.933,590,241
15,2321.616,224353,04466,747,3621.003,720,0770.923,594,138
16,1921.717,184404,35766,759,3291.013,708,1100.923,597,211
17,1521.818,144455,66966,768,7681.013,698,6710.923,599,749
18,1121.919,103506,79466,776,7061.013,690,7330.913,601,929
19,0722.0110,063558,04966,783,4711.013,683,9680.913,603,843

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.50713,680,731103,768,883,741
15,3600.63201,404,06626,812,238,555
18,4320.7556,282,5585,001,090,969
21,5040.8842,768,8752,970,717,482
24,5761.0038,610,5212,346,167,653
27,6481.1336,537,1372,044,919,726
30,7201.2535,332,4891,864,030,200
33,7921.3834,255,2551,691,821,495
36,8641.5033,614,3201,595,628,621
39,9361.6333,023,5801,534,159,028
43,0081.7532,903,8881,534,159,028
46,0801.8832,865,2781,534,159,028
49,1522.0032,849,8341,534,159,028

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)
641.000000
1282.000000
1923.000000
2564.000000
3205.000000
3846.000000
4487.000000
5128.000000
5769.000000
64010.000000
70411.000000
76812.000000
83213.000000
89614.000000
96015.000000
1,02416.000000
1,08817.000000
1,15218.000000
1,21619.000000
1,28020.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 block25,45381232
undo header36288244
system undo header6513206
undo block10015
2nd level bmb2080
1st level bmb800

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) 40240203871,2583,249.86
PR-Process Startup 1051050524148,207.00
PV-KSV slave startup (syncstart) 27270410826,881.50
US-Undo Segment 2,0562,05601,0229088.25
TX-Transaction (index contention) 582582046569147.67
CF-Controlfile Transaction 10,16810,16173522263.44
WF-AWR Flush 272701817963.89
SQ-Sequence Cache 1,7061,70601401286.54
PS-PX Process Reservation 1,0371,0307902910.27
TX-Transaction 76,81976,816093447.24
KO-Multiple Object Checkpoint (fast object checkpoint) 2,1882,188067945.84
FB-Format Block 4747023152.04
JQ-Job Queue 3534125135.20
TM-DML 262,079262,080014028.43
CR-Reuse Block Range (block range reuse ckpt) 1,4501,450029000.49
WL-Being Written Redo Log 1101051.00
TX-Transaction (allocate ITL entry) 262601701.59
TQ-Queue table enqueue (TM contention) 606001601.63
TT-Tablespace 4,4684,46803800.61
RO-Multiple Object Reuse (fast object reuse) 646402600.77
TA-Instance Undo 141401300.69
AE-Edition Lock (lock) 1,4301,4300701.00
TO-Temp Object 14140401.00
HW-Segment High Water Mark 2,9862,9860400.75
MD-Materialized View Log DDL 660400.50
PW-Buffer Cache PreWarm (flush prewarm buffers) 220201.00
JS-Job Scheduler (job run lock - synchronize) 110101.00
TD-KTF map table enqueue (KTF dump entries) 10100101.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
421.0171,7021,065117180/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:515,62919,5326961800/00/0/0/0/0/0
07-8月 22:418034,5297571171800/00/0/0/0/0/0
07-8月 22:313,66211,83635381800/00/0/0/0/0/0
07-8月 22:213,46811,62675961800/00/0/0/0/0/0
07-8月 22:113,36111,36372951800/00/0/0/0/0/0
07-8月 22:014,08412,8161,06561800/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 
AQ dequeue txn counter latch8300.00 00 
ASM Keyed state latch3,3140.240.0000 
ASM allocation7890.00 00 
ASM db client latch10,2980.00 00 
ASM map headers210.00 00 
ASM map load waiting list60.00 00 
ASM map operation freelist8,3150.00 00 
ASM map operation hash table1,335,4760.000.0000 
ASM network background latch1,8820.00 00 
ASM network state latch2790.00 00 
AWR Alerted Metric Element list65,4670.00 00 
Change Notification Hash table latch1,1310.00 00 
Consistent RBA121,8880.000.0000 
DML lock allocation162,097,4660.370.0010 
Event Group Locks1,8310.00 00 
FAL Queue980.00 00 
FIB s.o chain latch260.00 00 
FOB s.o list latch17,9350.070.0000 
File State Object Pool Parent Latch50.00 00 
I/O Staticstics latch50.00 00 
IPC other latch310.00 00 
IPC stats buffer allocation latch5,7910.00 07,2320.11
In memory undo latch50.00 00 
JS Sh mem access130.00 00 
JS broadcast add buf latch16,7320.00 00 
JS broadcast drop buf latch16,7320.00 00 
JS broadcast load blnc latch16,6300.00 00 
JS mem alloc latch140.00 00 
JS queue access latch190.00 00 
JS queue state obj latch598,6940.00 00 
JS slv state obj latch1570.00 00 
KFC FX Hash Latch50.00 00 
KFC Hash Latch50.00 00 
KFCL LE Freelist50.00 00 
KFK SGA Libload latch9600.00 00 
KFMD SGA30.00 00 
KGNFS-NFS:SHM structure50.00 00 
KGNFS-NFS:SVR LIST50.00 00 
KJC message pool free list68,2040.100.00012,1260.00
KJCT flow control latch1,433,4450.020.0000 
KMG MMAN ready and startup request latch27,9160.00 00 
KMG resize request state object freelist120.00 00 
KTF sga latch320.00 01,1840.00
KWQMN job cache list latch5740.171.0000 
KWQP Prop Status20.00 00 
KWQS pqsubs latch310.00 00 
KWQS pqueue ctx latch640.00 00 
Locator state objects pool parent latch50.00 00 
Lsod array latch20,8590.140.0000 
MQL Tracking Latch0  0720.00
Memory Management Latch26,9530.00 027,9160.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 Latch2,3400.00 00 
Mutex50.00 00 
Mutex Stats50.00 00 
OS process5,1020.00 00 
OS process allocation10,7110.9434.1710250 
OS process: request allocation3,3160.060.0000 
PL/SQL warning settings48,2070.00 00 
PX hash array latch50.00 00 
QMT50.00 00 
Real-time plan statistics latch22,7910.00 00 
Reserved Space Latch40.00 00 
Result Cache: RC Latch100.00 00 
SGA IO buffer pool latch350.00 0350.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,4980.00
SQL memory manager workarea list latch433,3450.000.0000 
Shared B-Tree4580.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$KSFQP13,8100.00 00 
XDB NFS Security Latch50.00 00 
XDB unused session pool50.00 00 
XDB used session pool50.00 00 
active checkpoint queue latch27,3940.310.0000 
active service list5,814,4990.010.0401,404,6580.01
alert log latch20.00 00 
archive control3520.00 00 
archive process latch2950.00 00 
begin backup scn array340.00 00 
buffer pool110.00 00 
business card830.00 00 
cache buffer handles86,5200.010.0000 
cache buffers chains688,324,4860.150.00316,728,1390.00
cache buffers lru chain525,2480.020.12015,598,4420.04
cache table scan latch18,9800.020.00018,9800.00
call allocation24,0190.070.2400 
cas latch50.00 00 
change notification client cache latch50.00 00 
channel handle pool latch3,3830.380.0000 
channel operations parent latch3,300,4360.000.0000 
checkpoint queue latch2,538,1750.000.030256,4240.00
client/application info18,2590.010.0000 
compile environment latch2,3550.00 00 
corrupted undo seg latch145,0220.020.0000 
cp cmon/server latch50.00 00 
cp pool latch50.00 00 
cp server hash latch50.00 00 
cp sga latch1870.00 00 
cvmap freelist lock50.00 00 
deferred cleanup latch1870.00 00 
dml lock allocation1870.00 00 
done queue latch50.00 00 
dummy allocation4,3780.020.0000 
enqueue hash chains2,938,6810.020.1302,3620.00
enqueues1,673,2520.030.0100 
error message lists1490.00 00 
fifth spare latch50.00 00 
file cache latch9030.00 00 
flashback copy50.00 00 
fourth Audit Vault latch50.00 00 
gc element3,259,2890.050.12102,670,7560.05
gcr global ctx10.00 00 
gcs commit scn state50.00 00 
gcs opaque info freelist818,2200.180.0100 
gcs partitioned table hash19,798,4010.260.000342,1100.00
gcs pcm hashed value bucket hash50.00 00 
gcs remaster request queue130.00 00 
gcs remastering latch3,868,9181.740.0015941.85
gcs resource freelist691,9940.000.000948,7860.00
gcs resource hash9,529,7970.010.043690.00
gcs resource scan list1610.00 00 
gcs shadows freelist875,8050.000.0001,064,3480.00
ges caches resource lists1,031,7900.020.0701,434,4320.01
ges deadlock list37,1840.020.00036,6710.00
ges domain table4,043,7560.000.0000 
ges enqueue table freelist4,109,7000.010.0200 
ges group table4,043,4050.000.1300 
ges process hash list1,262,1430.010.7400 
ges process parent latch8,347,5100.000.00010.00
ges process table freelist3,3140.030.0000 
ges resource hash list6,225,3370.041.3160678,7660.00
ges resource scan list1,4040.00 00 
ges resource table freelist109,7580.000.0000 
ges timeout list18,1260.010.0001,6770.00
ges value block free list4830.00 00 
global KZLD latch for mem in SGA1,3640.00 00 
global ctx hash table latch10.00 00 
global tx hash mapping2370.00 00 
granule operation50.00 00 
hash table column usage latch1,7790.00 05,859,2720.01
hash table modification latch1190.00 00 
heartbeat check50.00 02,6230.00
heartbeat structure management20.00 06800.00
internal temp table object number allocation latch330.00 00 
interrupt manipulation6,9370.00 00 
intra txn parallel recovery50.00 00 
io pool granule metadata list50.00 00 
job workq parent latch400.00 0350.00
job_queue_processes free list latch720.00 00 
job_queue_processes parameter latch16,7190.00 00 
k2q global data latch2,4780.00 00 
k2q lock allocation3410.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch50.00 00 
kgb parent50.00 00 
kgnfs mount latch50.00 00 
kokc descriptor allocation latch3,7360.00 00 
krbmrosl20.00 00 
ksfv messages50.00 00 
ksim group membership cache1,9290.00 00 
ksim membership request latch3140.00 03,1810.00
kss move lock590.00 00 
ksuosstats global area2590.00 00 
ksv allocation latch2950.00 00 
ksv class latch6,8930.00 00 
ksv instance latch160.00 00 
ksv msg queue latch120.00 070.00
ksxp shared latch3,3140.210.0000 
ksxp so latch3,3140.210.0000 
ksz_so allocation latch3,3140.630.0000 
ktm global data2760.00 00 
kwqbsn:qsga1260.00 00 
lgwr LWN SCN141,2160.030.0600 
list of block allocation3,6580.080.0000 
loader state object freelist5070.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 parent1580.00 01530.00
managed standby latch970.00 00 
mapped buffers lru chain50.00 00 
message pool operations parent latch12,4010.00 00 
messages873,6420.030.0100 
mostly latch-free SCN142,2730.620.0000 
msg queue latch50.00 00 
multiblock read objects231,9160.040.0400 
name-service memory objects26,1010.00 00 
name-service namespace bucket35,0730.00 00 
name-service pending queue10,1100.00 00 
name-service request520.00 00 
name-service request queue46,4380.00 00 
ncodef allocation latch1870.00 00 
object queue header heap16,1750.00 015,4180.00
object queue header operation3,131,4670.010.57390,1520.00
object stats modification3,4190.00 010.00
parallel query alloc buffer7,6360.00 00 
parallel query stats9670.00 00 
parallel txn reco latch24,9340.00 00 
parameter list7,5970.00 00 
parameter table management10,8240.011.0000 
peshm50.00 00 
pesom_free_list50.00 00 
pesom_hash_node50.00 00 
post/wait queue231,9580.020.020120,5670.02
process allocation3,4211.720.8121,8150.61
process group creation3,3140.00 00 
process queue2,8210.00 00 
process queue reference96,5350.00 010,6190.08
qmn state object latch50.00 00 
qmn task context latch30.00 00 
qmn task queue latch8392.620.8200 
query server freelists1,9530.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 allocation405,0800.050.050749,9560.13
redo copy50.00 0750,3320.32
redo writing396,7930.010.0000 
reservation so alloc latch20.00 00 
resmgr group change latch3,1710.00 00 
resmgr:active threads36,3510.071.0401,8020.00
resmgr:actses change group2,3290.00 00 
resmgr:actses change state1610.00 00 
resmgr:free threads list4,4050.020.0000 
resmgr:plan CPU method50.00 00 
resmgr:resource group CPU method60.00 00 
resmgr:schema config184,7560.120.9701170.85
resmgr:session queuing50.00 00 
rm cas latch50.00 00 
row cache objects47,126,1420.470.00555,1460.45
rules engine aggregate statistics120.00 00 
rules engine rule set statistics1240.00 00 
second Audit Vault latch50.00 00 
second spare latch50.00 00 
segmented array pool60.00 00 
sequence cache111,3870.020.0000 
session allocation807,8060.000.270803,5570.02
session idle bit12,207,3910.010.0100 
session queue latch50.00 00 
session state list latch4,6770.090.0000 
session switching7,6420.00 00 
session timer1,3130.00 00 
shared pool11,120,5180.080.2170 
shared pool sim alloc50.00 00 
shared pool simulator1,980,4680.010.3100 
sim partition latch50.00 00 
simulator hash latch21,855,0940.000.0300 
simulator lru latch1,3080.150.50021,847,1300.29
sort extent pool4060.00 00 
space background state object latch100.00 00 
space background task latch3,2150.00 02,2230.00
state object free list20.00 00 
statistics aggregation7840.00 00 
tablespace key chain2,9080.00 00 
temp lob duration state obj allocation20.00 00 
temporary table state object allocation200.00 00 
test excl. parent l050.00 00 
test excl. parent2 l050.00 00 
third spare latch50.00 00 
threshold alerts latch2210.00 00 
trace latch850.00 00 
transaction allocation41,522,2760.170.0000 
transaction branch allocation1,4970.00 00 
undo global data519,2300.020.0107250.41
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 chains688,324,4861,030,6344,0181,026,775
DML lock allocation162,097,466607,0241,624605,455
row cache objects47,126,142220,845835220,092
transaction allocation41,522,27670,86332070,556
gcs remastering latch3,868,91867,409467,409
shared pool11,120,5188,8141,8616,979
ges resource hash list6,225,3372,4033,1441,177
gc element3,259,2891,5451881,375
gcs opaque info freelist818,2201,485161,470
gcs resource hash9,529,7971,077401,042
mostly latch-free SCN142,2738763873
active service list5,814,49977831747
session idle bit12,207,3916968688
enqueue hash chains2,938,68150065436
enqueues1,673,2524875482
object queue header operation3,131,467400228191
simulator hash latch21,855,0942787271
messages873,6422764272
ges enqueue table freelist4,109,7002485243
KJCT flow control latch1,433,4452291228
resmgr:schema config184,7562152096
ges caches resource lists1,031,79021015196
ges process hash list1,262,14318914049
redo allocation405,08018710177
ges group table4,043,40518123158
OS process allocation10,7111013,4516
shared pool simulator1,980,4681003169
undo global data519,23093192
multiblock read objects231,91683380
cache buffers lru chain525,248811071
process allocation3,421594812
post/wait queue231,95848147
lgwr LWN SCN141,21636234
checkpoint queue latch2,538,17535134
resmgr:active threads36,35127280
session allocation807,80626719
qmn task queue latch83922185
call allocation24,01917413
simulator lru latch1,308211
KWQMN job cache list latch574110
parameter table management10,824110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktadmc01,6231,550
DML lock allocationktaiam0149
KJCT flow control latchkjctcsnd: send normal message011
KWQMN job cache list latchkwqmnprsc: loop010
OS process allocationkso_new_process:103,3570
OS process allocationkso_new_process:20893,295
OS process allocationksosp_forknew020
OS process allocationkso_delete_process:10189
OS process allocationksoreq_cancel:10167
OS process allocationksoreq_submit010
active service listkswslogon: session logout0183
active service listkswsite: service iterator0160
active service listkswslogon: session login061
cache buffers chainskcbgtcr: fast path (cr pin)03,4861,572
cache buffers chainskcbgtcr_20691692
cache buffers chainskcbgtcr: kslbegin excl04171,048
cache buffers chainskcbrls_103431,627
cache buffers chainskcbzwb0177110
cache buffers chainskcbchg1: kslbegin: bufs not pinned0113107
cache buffers chainskcbgtcr: fast path010034
cache buffers chainskcbgcur_206527
cache buffers chainskcbget: pin buffer01734
cache buffers chainskcbrls_2017107
cache buffers chainskcbchg1: kslbegin: call CR func01536
cache buffers chainskclcls_301118
cache buffers chainskclbla080
cache buffers chainskcllkopesc080
cache buffers chainskcbgcur: fast path (shr)050
cache buffers chainskclpdcl030
cache buffers chainskcbso1: set no access021
cache buffers chainskcbsod1027
cache buffers chainskcbzgb: scan from tail. nowait020
cache buffers chainskcl_fairness020
cache buffers chainskcbbxsv011
cache buffers chainskcbgcur_1011
cache buffers chainskcbget: exchange rls010
cache buffers chainskcbgtcr: kslbegin shared010
cache buffers chainskcbzibmlt: multi-block read: nowait010
cache buffers chainskclwcrs014
cache buffers chainskclwlr011
cache buffers lru chainkcbzgws080
cache buffers lru chainkcbo_link_q011
cache buffers lru chainkcbw_activate_granule010
call allocationksuxds044
checkpoint queue latchkcbkubc_4010
enqueue hash chainsksqexpandres0600
enqueue hash chainsksqgtl30213
enqueue hash chainsksqcmi: if lk mode not requested011
enqueue hash chainsksqcmi: if lk mode requested010
enqueue hash chainsksqrcl0148
enqueuesksqgel: create enqueue033
enqueuesksqdel022
gc elementkclnfndnewm04553
gc elementkclchkping0350
gc elementkclbla0273
gc elementkclollnumiter0270
gc elementkclevict0260
gc elementkclfwrite10147
gc elementkclnfndnew0111
gc elementkclnfndx086
gc elementkcl_fairness063
gc elementkclnfnds062
gc elementkcl_get_le_latch040
gc elementkclrwrite0416
gc elementkclwrt032
gc elementkclpdcl0215
gc elementkclulb0221
gc elementkclclose_1010
gc elementkclcqchk_1010
gc elementkclhngcbk1_1010
gc elementkclnfnd017
gc elementkclpdc_21012
gcs opaque info freelistkjbrinfofree free opaque info0120
gcs opaque info freelistkjbrcvt save opaque info0416
gcs remastering latchkjfcdrmrfg beginning040
gcs resource hashkclrwrite066
gcs resource hashkjbmpwrite061
gcs resource hashkjbcropen050
gcs resource hashkjbopen:affinity040
gcs resource hashkjbcropen:affinity030
gcs resource hashkjblocalobj_nolock031
gcs resource hashkjbrdrmcvtq_980315
gcs resource hashkclgrantlk_1020
gcs resource hashkjbmpopen020
gcs resource hashkjbassume010
gcs resource hashkjbconvert013
gcs resource hashkjbcrcomplete011
gcs resource hashkjbmdowncvt010
gcs resource hashkjbmpcreatepi011
gcs resource hashkjbrwrdone reget010
ges enqueue table freelistkjlfr: remove lock from parent object031
ges enqueue table freelistkjlalc: lock allocation024
ges group tablekjgagll: move a lock from process lock list to group lock list02123
ges group tablekjgdgll: move a lock from group lock list to process lock list020
ges process hash listkjakiqa: set inquiry response09644
ges process hash list320440
ges resource hash listkjrmas1: lookup master node02,7507
ges resource hash listkjakcai: search for resp by resname018932
ges resource hash listkjlmfnd: search for lockp by rename and inst id01106
ges resource hash listkjlrlr: remove lock from resource queue076370
ges resource hash listkjrref: find matched resource0102,696
ges resource hash listkjucvl: lock convert request0430
ges resource hash listkjcvscn: remove from scan queue030
ges resource table freelistkjruch: cached obj cleanup070
ges resource table freelistkjrm2c: move resource to cache0415
ges resource table freelistkjchc: clean resource cache030
ges resource table freelistkjrchc: cached obj cleanup010
lgwr LWN SCNkcs023030
messagesksarcv020
messagesksarcv: after wait022
mostly latch-free SCNkcs024020
multiblock read objectskcbzibmlt031
object queue header operationkclobj_50127100
object queue header operationkclobj_105354
object queue header operationkclobj_204237
object queue header operationkcbo_link_q:reget050
object queue header operationkcbo_link_q0213
object queue header operationkcbo_switch_mq_bg012
object queue header operationkcbo_unlink_q0116
object queue header operationkcbo_write_q010
object queue header operationkcldbufs011
parameter table managementkspcpy010
post/wait queuekslpstevent:get011
process allocationksucrp:10450
process allocationksuapc0348
qmn task queue latchkwqmnmvtsks: delay to ready list0120
qmn task queue latchkwqmngettsk: get task0418
qmn task queue latchkwqmndntsk: task done but retry020
redo allocationkcrfw_redo_gen: redo allocation 10100
resmgr:active threadskgsksimsetup10280
resmgr:resource group CPU methodkgkprraddtorl07249
resmgr:resource group CPU methodkgkprrpicknext01235
resmgr:schema configkgskgmaxdop1013210
resmgr:schema configkgskgasi1076198
resmgr:schema configkgskmetricupd010
row cache objectskqreqd: reget05265
row cache objectskqrpre: find obj0183730
row cache objectskqrso06938
row cache objectskqreqd02726
row cache objectskqrbgl0141
row cache objectskqrbtm: pop parent0104
row cache objectskqrigt0223
row cache objectskqrigt2011
row cache objectskqrpre: init complete011
row cache objectsksucallcbksafely: kqrhngc010
session allocationkspallmod070
session idle bitksupuc: clear busy044
session idle bitksupuc: set busy045
session idle bitksuxds010
shared poolkghalo01,332709
shared poolkghupr10262605
shared poolkghalp0171496
shared poolkgh_heap_sizes09234
shared poolkghasp017
shared poolkghfre019
shared poolkghfrunp: alloc: wait010
shared poolkghfrunp: clatch: nowait010
shared pool simulatorkglsim_unpin_simhp0283
shared pool simulatorkglsim_scan_lru: scan0214
shared pool simulatorkglsim_upd_newhp0110
simulator hash latchkcbsacc: lookup dba077
simulator lru latchkcbs_shrink_pool010
transaction allocationktcxbr0320320
undo global dataktudba: KSLBEGIN011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]2,931,07764,182
Library Cachekglhdgn1 62505,56913,941
Library Cachekglhdgh1 64318,88219,709
Library Cachekgllkal1 80140,55720,907
Library Cachekglllal3 111117,632109,025
Library Cachekgllkdl1 8589,7173,008
Library Cachekglpnal2 9181,61034,540
Library Cachekgldtin1 4234,9398,006
Library Cachekglpin1 432,3934,945
Library Cachekglget1 131,3331,627
Library Cachekglobpn1 7121,4097,966
Library Cachekglpnal1 9018,3902,173
Library Cachekgllldl2 11210,8555,173
Library Cachekglllal1 1099,7651,353
Library Cachekglpndl1 955,8682,789
Library Cachekglhdgn2 1065,4042,128
Library Cachekglrfcl1 791,83770
Library Cachekglget2 250132
Library CachekglReleaseHandleReference 1251652
Cursor Pinkksfbc [KKSCHLFSP2]1022
Library Cachekgllkc1 578683
Cursor Pinkksfbc [KKSCHLPIN1]340
Library Cachekglnti1 4690
Library Cachekglini1 3230
Library Cachekglobld1 7531
Library CachekglUpgradeLock 11910
Library Cachekglati1 4510
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]10
Cursor PinkksLockDelete [KKSCHLPIN6]10

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
ECScoredataEXCHANGE TABLE65,064,81617.34
ECSUSERSORGANIZATIONUNITPROFILE TABLE46,663,68012.43
ECScore_INDEXIDX_OUNESTLOOP INDEX26,136,6726.96
ECScoredataCHANGE TABLE21,737,8405.79
ECScoredataORDERSSYS_P2548TABLE PARTITION20,966,5285.59

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ECScoredataPASSENGERINFO TABLE16,389,20850.64
ECScoredataREFUNDORDER TABLE10,844,95633.51
ECScoredataORDERSSYS_P2048TABLE PARTITION187,4270.58
ECScoredataORDERSSYS_P2489TABLE PARTITION171,5630.53
ECScoredataORDERSSYS_P2448TABLE PARTITION138,4390.43

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
ECScoredataPASSENGERINFO TABLE132,01928.76
ECScoredataREFUNDORDER TABLE92,46620.14
ECScoredataORDERSSYS_P2048TABLE PARTITION33,2337.24
ECSUSERSFLIGHTPRICEDOMESTIC TABLE11,0052.40
ECScoredataPSGTICKET TABLE4,6541.01

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
ECScoredataPASSENGERINFO TABLE132,01928.76
ECScoredataREFUNDORDER TABLE92,46620.14
ECScoredataORDERSSYS_P2048TABLE PARTITION33,2337.24
ECSUSERSFLIGHTPRICEDOMESTIC TABLE11,0052.40
ECScoredataPSGTICKET TABLE4,6541.01

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
ECScoredataPASSENGERINFO TABLE16,389,20351.10
ECScoredataREFUNDORDER TABLE10,838,38033.79
ECScoredataORDERSSYS_P2489TABLE PARTITION171,4100.53
ECScoredataORDERSSYS_P2448TABLE PARTITION138,0240.43
ECScoredataORDERSSYS_P2048TABLE PARTITION126,0460.39

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
ECScoredataPAYBILL TABLE1,9792.91
ECScoredataPASSENGERINFO TABLE1,8792.76
ECScore_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION1,8352.70
ECScore_INDEXIDX_BOOKUSERSYS_P2548INDEX PARTITION1,2721.87
ECScore_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION1,0351.52

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
ECScore_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION1,7744.18
ECScoredataPASSENGERINFO TABLE1,7354.09
ECScoredataPAYBILL TABLE1,7254.06
ECScore_INDEXIDX_BOOKUSERSYS_P2548INDEX PARTITION1,1982.82
ECScore_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION1,0092.38

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_87227165_25433TABLE PARTITION93395.20

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
ECScore_INDEXPK_ORGANIZATIONUNITPROFILE INDEX4,45175.07
ECScoredataPASSENGERINFO TABLE911.53
ECScoredataREFUNDORDER TABLE350.59
PAOTEMPQUEST_ADV_SEGSTAT_WIDE_PK INDEX40.07
ECScoredataORDERSSYS_P2048TABLE PARTITION20.03

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
ECScoredataORDERSSYS_P2548TABLE PARTITION167,45629.12
ECScore_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION42,0967.32
ECScore_INDEXIDX_CREATEDATE_STATUSSYS_P2548INDEX PARTITION36,0326.26
ECScore_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION24,2084.21
ECSUSERSTRACEOFPROCESSSYS_P2528TABLE PARTITION23,8724.15

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ECScoredataORDERSSYS_P2548TABLE PARTITION33837.06
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION25928.40
ECScore_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION808.77
ECSUSERSTICKETNOSECTION TABLE303.29
ECScore_INDEXIDX_CREATEDATE_STATUSSYS_P2548INDEX PARTITION272.96

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION2083.33
ECScore_INDEXSYS_C0049434 INDEX28.33
ECScore_INDEXIDX_SEARCHBILL INDEX14.17
ECScore_INDEXWEBTERMCOMMANDHISTORY_PK INDEX14.17

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION66143.43
ECScoredataORDERSSYS_P2548TABLE PARTITION30319.91
SYSSYSTEMUNDO$ TABLE27518.07
ECScore_INDEXIDX_CREATEDATE_STATUSSYS_P2548INDEX PARTITION805.26
ECScore_INDEXIX_ITEMNOSYS_P2528INDEX PARTITION573.75

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
ECScoredataCHANGE TABLE15,92070.76
ECScoredataEXCHANGE TABLE1,8358.16
ECSUSERSIDX_TRACEIDSYS_P2528INDEX PARTITION1,1835.26
ECScore_INDEXPK_ORDERS INDEX1,1535.12
ECScoredataORDERSSYS_P2548TABLE PARTITION6592.93

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
ECScoredataORDERSSYS_P2548TABLE PARTITION29,84919.99
ECScore_INDEXPK_ORDERS INDEX10,6307.12
ECSUSERSPNRLIST TABLE9,0186.04
ECScore_INDEXIDX_CREATEDATE_STATUSSYS_P2548INDEX PARTITION6,7524.52
ECScore_INDEXPK_FLIGHTPRICEDOMESTIC INDEX5,6833.81

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
ECScoredataORDERSSYS_P2548TABLE PARTITION19,1768.51
ECScoredataORDERSSYS_P2489TABLE PARTITION15,2526.77
ECScoredataCHANGE TABLE13,3155.91
ECScoredataORDERSSYS_P2448TABLE PARTITION12,1725.40
ECScore_INDEXIDX_SHOWLISTSYS_P2548INDEX PARTITION11,3625.04

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_control672.990 01
dc_files67237.500 00
dc_global_oids6,2940.810 028
dc_histogram_data8,388,4850.100 04,962
dc_histogram_defs3,423,6440.330 133,005
dc_object_grants40,7080.010 029
dc_objects5,044,7820.020 261,804
dc_profiles2,7530.360 03
dc_rollback_segments126,5240.180 1721,920
dc_segments1,397,5730.130 5928
dc_sequences1,56874.740 1,5687
dc_table_scns6100.000 00
dc_tablespaces846,5850.000 013
dc_users2,008,9190.000 045
global database name5,6570.000 01
outstanding_alerts7690.790 120
qmtmrctn_cache_entries1100.000 00
qmtmrctq_cache_entries1100.000 00
sch_lj_oids250.000 04

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control220
dc_files2520294
dc_global_oids51063
dc_histogram_defs11,43059811,037
dc_objects1,1628946
dc_profiles10012
dc_rollback_segments4112250
dc_segments1,92051,655
dc_sequences3,1331,12248
dc_table_scns600
dc_tablespaces606
dc_users27047
outstanding_alerts134567
qmtmrctn_cache_entries101
qmtmrctq_cache_entries101
sch_lj_oids100

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS2,7280.950 00
APP CONTEXT1100.00250.0000
BODY10,8261.2598,4330.16130
CLUSTER5931.525961.5100
DBLINK2,7310.000 00
DIRECTORY466.526612.1220
EDITION1,4160.002,8140.0000
HINTSET OBJECT3917.953935.9000
INDEX140,7470.02140,7470.5560
OBJECT ID8100.000 00
QUEUE9561.461,1152.6940
RULESET0 128.3310
SCHEMA2,9450.000 00
SQL AREA564,32828.142,435,76322.7022,834618
SQL AREA BUILD183,00594.750 00
SQL AREA STATS175,37995.20175,37995.2000
SUBSCRIPTION1392.311392.3100
TABLE/PROCEDURE396,4010.181,430,1710.705,6630
TRANSFORMATION3590.003590.0000
TRIGGER6552.4466,3130.0320
XML SCHEMA50.0090.0000

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS2,7280000
BODY096,90496,90400
CLUSTER59659659600
DBLINK2,7310000
DIRECTORY26525200
EDITION1,4161,4171,41700
HINTSET OBJECT39393900
INDEX140,747140,747140,74700
QUEUE4631,1151,11500
RULESET0121200
SCHEMA1,4060000
SUBSCRIPTION0131300
TABLE/PROCEDURE525,359687,431687,43100
TRANSFORMATION35935935900
TRIGGER066,31366,31300
XML SCHEMA55500

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 cache14,784.0014,784.0012,928.0016,576.006SHR/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 pool9,472.009,472.007,680.0011,328.006GRO/DEF
streams pool64.0064.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 cache14,784.0014,784.0014,784.00505
shared pool9,472.009,472.009,472.00550

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
08/07 22:54:0760bufcacheSHR/DEF14,7840-12814,784CAN
08/07 22:54:0760sharedGRO/DEF9,47201289,472CAN
08/07 22:43:3460bufcacheSHR/DEF14,7840-12814,784CAN
08/07 22:43:3460sharedGRO/DEF9,47201289,472CAN
08/07 22:23:1760bufcacheSHR/DEF14,7840-12814,784CAN
08/07 22:23:1760sharedGRO/DEF9,47201289,472CAN
08/07 22:14:1560bufcacheSHR/DEF14,7840-12814,784CAN
08/07 22:14:1560sharedGRO/DEF9,47201289,472CAN
08/07 22:05:1360bufcacheSHR/DEF14,7840-12814,784CAN
08/07 22:05:1360sharedGRO/DEF9,47201289,472CAN

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,265.73 4.494.374451505505
Freeable356.130.000.840.505 422422
PL/SQL90.8356.770.180.1823504502
SQL43.8020.670.090.6815204471461
EOther3,410.78 4.063.684451841841
Freeable528.500.000.790.475 666666
PL/SQL131.8495.870.160.1623840839
SQL52.3616.760.060.288204808800

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers15,502,147,584 
Fixed Size2,231,608 
Redo Buffers16,932,864 
Variable Size10,133,439,176 

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.2855.280.00
sharedKGH: NO ACCESS126.88126.880.00
sharedKGLH0788.54762.74-3.27
sharedKGLHD2,311.092,313.070.09
sharedSQLA578.15590.382.11
sharedfree memory4,215.124,209.53-0.13
sharedgcs resources270.51270.510.00
sharedgcs shadows199.32199.320.00
sharedkglsim object batch150.59150.590.00
streamsKGH: NO ACCESS63.9963.990.00
streamsfree memory64.0164.010.00
 buffer_cache14,784.0014,784.000.00
 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 Slaves0517 04:51:590.280.150.00
QMON Coordinator0517 04:51:590.210.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 120.0000.102.120.000.000.180.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) 120100.000.003.780.000.0057.09
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(49961) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(49631) 37370.000.000.240.680.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.000.32 
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(49961) 0.000.00  
SYSMAN.MGMT_TASK_Q(49631) 0.010.010.010.02

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 12000.000.000.00
core_DB2_3938_coredb2(42)/SYS.ALERT_QUE 12000.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.0599.9500 
D0000.003,6080.0599.9500 
D0000.003,6080.0599.9500 
D0000.003,6080.0599.9500 
Sum0.00   00 
Avg0.00 0.0599.9500 
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  
audit_trailDB  
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_number2  
job_queue_processes1000  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.10.32)(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  
thread2  
undo_retention10800  
undo_tablespaceUNDOTBS2  

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)59,04316.360.35
acks for commit broadcast(logical)68,85319.080.41
broadcast msgs on commit(actual)58,63716.250.35
broadcast msgs on commit(logical)102,99728.540.62
broadcast msgs on commit(wasted)13,9143.860.08
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received00.000.00
flow control messages sent30.000.00
gcs apply delta00.000.00
gcs assume cvt00.000.00
gcs assume no cvt284,32778.781.71
gcs ast xid350.010.00
gcs blocked converts81,80822.670.49
gcs blocked cr converts114,78831.800.69
gcs compatible basts8920.250.01
gcs compatible cr basts (global)25,5567.080.15
gcs compatible cr basts (local)317,95588.101.91
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs14,9054.130.09
gcs dbwr write request msgs11,7553.260.07
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 only1170.030.00
gcs force cr grant1380.040.00
gcs force cr no current00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts11,1203.080.07
gcs immediate (null) converts73,43620.350.44
gcs immediate cr (compatible) converts1,1480.320.01
gcs immediate cr (null) converts810,816224.664.87
gcs indirect ast137,88138.200.83
gcs indirect bidless ast1170.030.00
gcs indirect fg ast137,58938.120.83
gcs lms flush pi msgs00.000.00
gcs lms write request msgs5,5441.540.03
gcs msgs process time(ms)99,02327.440.59
gcs msgs received2,637,830730.8715.84
gcs new served by master1,2100.340.01
gcs out-of-order msgs50.000.00
gcs pings refused1060.030.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts380.010.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 xid300.010.00
gcs regular cr00.000.00
gcs retry convert request20.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual20,9975.820.13
gcs side channel msgs logical446,656123.762.68
gcs stale cr40,76811.300.24
gcs undo cr12,4383.450.07
gcs write notification msgs7890.220.00
gcs writes refused160.000.00
ges msgs process time(ms)8,8912.460.05
ges msgs received139,88938.760.84
global posts dropped00.000.00
global posts queue time1330.040.00
global posts queued490.010.00
global posts requested490.010.00
global posts sent490.010.00
implicit batch messages received96,70226.790.58
implicit batch messages sent34,9409.680.21
lmd msg send time(ms)00.000.00
lms(s) msg send time(ms)00.000.00
messages flow controlled2,9190.810.02
messages queue sent actual241,95767.041.45
messages queue sent logical119,59633.140.72
messages received actual1,150,101318.666.90
messages received logical2,777,728769.6416.68
messages sent directly530,556147.003.19
messages sent indirectly277,58076.911.67
messages sent not implicit batched1560.040.00
messages sent pbatched953,433264.175.72
msgs causing lmd to send msgs41,13711.400.25
msgs causing lms(s) to send msgs126,52535.060.76
msgs received queue time (ms)980,888271.785.89
msgs received queued2,777,652769.6116.68
msgs sent queue time (ms)2,061,181571.1012.37
msgs sent queue time on ksxp (ms)16,961,8344,699.68101.84
msgs sent queued320,69288.861.93
msgs sent queued on ksxp887,713245.965.33
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received236,41465.501.42
process batch messages sent255,85970.891.54
 00.000.00


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests146,375
CURRENT Block Requests60,092
Data Block Requests146,375
Undo Block Requests1,806
TX Block Requests24,853
Current Results145,607
Private results3,117
Zero Results16,919
Disk Read Results40,784
Fail Results2
Fairness Down Converts49,325
Fairness Clears9,961
Free GC Elements0
Flushes20,163
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)32,556,874
Light Works2,769
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins43616.2850.9228.213.441.15
Flushes1,49516.1267.5614.921.400.00
Writes18,0170.0268.9227.093.190.78


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
1data block133,74585.4214.420.16224,02498.820.980.20
1undo header11,44599.100.760.1420694.174.850.97
1undo block3,04898.131.710.1627100.000.000.00
1Others1,04299.520.190.291,08199.440.460.09

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
1data block3.523.245.0914.702.932.4252.816.35
1undo header10.049.9010.74110.0531.760.63641.930.89
1undo block0.860.776.191.6529.1529.15  
1others1.301.302.960.480.740.732.920.49

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
1data block0114,247100.000.00221,372100.000.00
1undo header011,342100.000.00194100.000.00
1undo block02,991100.000.0027100.000.00
1others01,037100.000.001,075100.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
1data block 3.243.24 2.422.42 
1undo header 9.909.90 0.630.63 
1undo block 0.770.77 29.1529.15 
1others 1.301.30 0.730.73 

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
128414.19224.5128428.13316.91
22840.190.052840.170.05

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache1.200.67
Parallel Query0.030.01
DB Locks0.100.21
DB Streams0.000.00
Other0.010.00

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.224.51NO  1.600000 1.050000
en9169.254.224.51NO  1.600161,364,64800 1.05001,398,030,6674
en9169.254.224.51NO  1.600-161,364,64800 1.0500-1,398,030,667-4
en9169.254.224.51NO  1.600000 1.050000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

NameTotalper Remaster OpBegin SnapEnd Snap
remaster ops31.00  
remastered objects31.00  
replayed locks received93.00  
replayed locks sent3,0721,024.00  
resources cleaned00.00  
remaster time (s)27.39.11  
quiesce time (s)15.45.13  
freeze time (s)0.80.26  
cleanup time (s)4.21.39  
replay time (s)1.60.52  
fixwrite time (s)1.50.49  
sync time (s)1.50.51  
affinity objects  118117


Back to Top

End of Report