WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
YXDB3349992778yxdb2231-Jan-15 09:0111.2.0.4.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
nari65Linux x86 64-bit 24 12 2 62.89

Snap IdSnap TimeSessionsCursors/SessionInstances
Begin Snap:2431-Jan-15 12:51:46120 3.92
End Snap:2531-Jan-15 13:38:41161 6.02
Elapsed:  46.92 (mins)   
DB Time:  1,350.39 (mins)   

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 28.8 2.1 0.00 0.00
DB CPU(s): 12.5 0.9 0.00 0.00
Redo size (bytes): 191,643.6 13,656.2  
Logical read (blocks): 1,825,703.9 130,096.5  
Block changes: 1,196.5 85.3  
Physical read (blocks): 1,231.1 87.7  
Physical write (blocks): 88.3 6.3  
Read IO requests: 1,230.9 87.7  
Write IO requests: 63.3 4.5  
Read IO (MB): 9.6 0.7  
Write IO (MB): 0.7 0.1  
Global Cache blocks received: 114.3 8.1  
Global Cache blocks served: 122.0 8.7  
User calls: 18,044.5 1,285.8  
Parses (SQL): 1,158.5 82.6  
Hard parses (SQL): 0.1 0.0  
SQL Work Area (MB): -0.1 -0.0  
Logons: 0.2 0.0  
Executes (SQL): 9,268.7 660.5  
Rollbacks: 0.4 0.0  
Transactions: 14.0   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.93In-memory Sort %: 100.00
Library Hit %: 100.02Soft Parse %: 99.99
Execute to Parse %: 87.50Latch Hit %: 99.73
Parse CPU to Parse Elapsd %: 58.24% Non-Parse CPU: 99.85

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
db file sequential read3,464,98138.2K1147.2User I/O
DB CPU 35.2K 43.4 
log file sync38,01546791235.8Commit
gc current block busy6,659882.91331.1Cluster
gc buffer busy acquire10,470655.763.8Cluster
gc buffer busy release3,059655.6214.8Cluster
gc cr block busy3,760365.797.5Cluster
gc current block 2-way249,07068.60.1Cluster
SQL*Net message to client48,724,06244.10.1Network
read by other session2,35326.511.0User I/O

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
User I/O3,469,71938,2361147.213.6
DB CPU 35,151 43.412.5
Commit38,0194,6811235.81.7
Cluster433,6242,69163.31.0
System I/O354,5421,39141.70.5
Other173,55880851.00.3
Concurrency34,710582.10.0
Network48,737,115440.10.0
Application96423.00.0
Configuration21901.00.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
24 12 2 1.45 7.86 49.9 3.0 0.0 46.3

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
52.6 98.0 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 1,325.5 1,233.6 91.9
Database Requests: 1,294.2 1,230.9 63.3
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 27.7 0.0 27.7
Total (MB): 10.8 9.7 1.1
Database (MB): 10.3 9.6 0.7
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 0.4 0.0 0.4
Database (blocks): 1,319.4 1,231.1 88.3
Via Buffer Cache (blocks): 1,319.3 1,231.1 88.2
Direct (blocks): 0.1 0.0 0.1

Memory Statistics

BeginEnd
Host Mem (MB): 64,402.8 64,402.8
SGA use (MB): 31,744.0 31,872.0
PGA use (MB): 470.8 688.3
% Host Mem used for SGA+PGA: 50.02 50.56

Cache Sizes

BeginEnd
Buffer Cache: 25,728M 25,856MStd Block Size: 8K
Shared Pool Size: 4,202M 4,195MLog Buffer: 20,596K

Shared Pool Statistics

BeginEnd
Memory Usage %: 46.22 46.33
% SQL with executions>1: 87.83 92.54
% Memory for SQL w/exec>1: 80.34 81.81

Main Report

RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time74,329.4791.74
DB CPU35,151.1943.38
PL/SQL execution elapsed time492.980.61
parse time elapsed102.110.13
repeated bind elapsed time43.160.05
connection management call elapsed time1.310.00
hard parse elapsed time0.490.00
sequence load elapsed time0.290.00
hard parse (sharing criteria) elapsed time0.140.00
PL/SQL compilation elapsed time0.090.00
failed parse elapsed time0.040.00
DB time81,023.49 
background elapsed time2,361.92 
background cpu time226.00 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME3,610,531 
IDLE_TIME3,111,817 
IOWAIT_TIME724 
NICE_TIME0 
SYS_TIME199,982 
USER_TIME3,353,562 
LOAD18
PHYSICAL_MEMORY_BYTES67,531,182,080 
NUM_CPUS24 
NUM_CPU_CORES12 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,586 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
31-Jan 12:51:461.45     
31-Jan 13:38:417.8653.7149.892.9746.290.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
User I/O3,469,437038,2341147.19
DB CPU  35,151 43.38
Commit38,01504,6791235.77
Cluster433,36002,69163.32
Concurrency25,21405720.07
Network48,736,06104400.05
Other13,73533400.00
Application96417230.00
System I/O3770000.00
Configuration21757010.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
db file sequential read3,464,981038,2071187.7147.16
log file sync38,01504,6791230.965.77
gc current block busy6,65908831330.171.09
gc buffer busy acquire10,4700656630.270.81
gc buffer busy release3,05916562140.080.81
gc cr block busy3,7600366970.100.45
gc current block 2-way249,07006906.300.08
SQL*Net message to client48,724,06204401,233.330.05
read by other session2,353027110.060.03
cursor: pin S3,62602160.090.03
enq: TX - index contention1,180021180.030.03
gc cr block 2-way53,00001501.340.02
gc current grant busy16,15001410.410.02
gc cr multi block request1,39901390.040.02
gc current grant 2-way45,53601001.150.01
buffer busy waits2,1850840.060.01
gc cr grant 2-way36,8640800.930.01
library cache: mutex X7,8780410.200.01
enq: TX - row lock contention211792110.010.00
latch: row cache objects6,2880200.160.00
latch free3,8680200.100.00
gc current block congested4,1220100.100.00
db file scattered read1090180.000.00
enq: SV - contention1,7270100.040.00
gcs enter server mode110015120.000.00
latch: cache buffers chains3,7680000.100.00
gc cr block congested9320000.020.00
IPC send completion sync1,3390000.030.00
gc current grant congested9660000.020.00
gc cr grant congested8500000.020.00
gc current multi block request4730000.010.00
control file sequential read3770000.010.00
SQL*Net more data to client11,9930000.300.00
enq: FB - contention3870000.010.00
row cache lock2670000.010.00
latch: ges resource hash list3350000.010.00
enq: PS - contention3330000.010.00
enq: HW - contention19660000.000.00
buffer deadlock1,112100000.030.00
cursor: pin S wait on X100540.000.00
ADR block file read180020.000.00
SQL*Net break/reset to client7520000.020.00
undo segment extension6100050.000.00
PX Deq: reap credit3,363100000.090.00
gc current split490010.000.00
cursor: mutex X120020.000.00
enq: TX - allocate ITL entry150010.000.00
Disk file operations I/O1,9920000.050.00
PX Deq: Slave Session Stats3370000.010.00
latch: gc element3510000.010.00
latch: enqueue hash chains370000.000.00
latch: cache buffers lru chain960000.000.00
latch: object queue header operation620000.000.00
latch: session allocation510000.000.00
enq: WF - contention180000.000.00
latch: shared pool70000.000.00
KJC: Wait for msg sends to complete2180000.010.00
latch: gcs resource hash140000.000.00
wait list latch free20010.000.00
gc cr failure10010.000.00
global enqueue expand wait360000.000.00
SQL*Net message from client48,724,0250365,83081,233.33 
wait for unread message on broadcast channel2,826992,8159960.07 
Streams AQ: waiting for messages in the queue568982,80749420.01 
PX Deq: Execution Msg1,3480000.03 
PX Deq: Msg Fragment400000.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write31,05401,087350.7946.01
gcs log flush sync100,5311079082.5433.45
db file parallel write172,836028524.3712.07
db file async I/O submit141,75801303.590.54
Streams AQ: qmn coordinator waiting for slave to start21001362830.000.53
control file parallel write1,3080320.030.13
control file sequential read7,2100300.180.11
log file sync4024540.000.08
db file sequential read8602210.000.08
os thread startup2101300.000.03
enq: CO - master slave det937100000.020.02
DFS lock handle1,316100000.030.01
CGS wait for IPC msg24,817100000.630.01
SGA: allocation forcing component growth3670690.000.01
reliable message2960000.010.01
row cache lock1770000.000.00
ksxr poll remote instances7,258100000.180.00
db file scattered read500120.000.00
Parameter File I/O240020.000.00
row cache process11,6800000.300.00
ADR block file read150030.000.00
enq: CF - contention93100000.000.00
row cache cleanup10,0450000.250.00
latch free250010.000.00
gc current block 2-way920000.000.00
PX Deq: reap credit1,890100000.050.00
gc cr block 2-way590000.000.00
ADR block file write50020.000.00
gc current grant busy540000.000.00
LGWR wait for redo copy1880000.000.00
gc cr grant 2-way410000.000.00
latch: cache buffers lru chain840000.000.00
latch: cache buffers chains1170000.000.00
enq: PS - contention1650000.000.00
latch: gc element1070000.000.00
libcache interrupt action by LCK9,1620000.230.00
Disk file operations I/O1670000.000.00
latch: object queue header operation790000.000.00
enq: TA - contention130000.000.00
enq: TD - KTF dump entries70000.000.00
gc cr multi block request80000.000.00
asynch descriptor resize297100000.010.00
enq: TK - Auto Task Serialization4100010.000.00
latch: gcs resource hash280000.000.00
gc current grant 2-way90000.000.00
IPC send completion sync110000.000.00
SQL*Net message to client1,0500000.030.00
buffer busy waits190000.000.00
latch: redo allocation110000.000.00
PX Deq: Slave Session Stats120000.000.00
rdbms ipc message154,0553051,0203313.90 
Space Manager: slave idle wait2,1609210,38348070.05 
DIAG idle wait40,974745,6051371.04 
gcs remote message801,98074,773620.30 
Streams AQ: qmn slave idle wait10422,934282140.00 
dispatcher timer471002,821600110.00 
wait for unread message on broadcast channel2,860792,8159840.07 
GCR sleep5631002,81550010.01 
pmon timer9381002,81430000.02 
ges remote message37,769642,813740.96 
PX Idle Wait33702,81383470.01 
PING980222,80928670.02 
Streams AQ: qmn coordinator idle wait194512,801144380.00 
shared server idle wait931002,791300090.00 
smon timer8902,731306810.00 
class slave wait230600260830.00 
SQL*Net message from client1,3260110.03 
PX Deq: Join ACK120010.00 
KSV master wait1,712100000.04 
PX Deq: Parse Reply120000.00 
Streams AQ: RAC qmn coordinator idle wait199100000.01 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read3357.6 15.221.26.1   
ADR block file write540.020.020.020.0    
ADR file lock6100.0       
CGS wait for IPC msg24.8K100.0       
DFS lock handle131698.81.1.1     
Disk file operations I/O2159100.0 .0     
IPC send completion sync135098.11.8.1     
KJC: Wait for msg sends to complete218100.0       
LGWR wait for redo copy18899.5.5      
PX Deq: Signal ACK EXT12100.0       
PX Deq: Signal ACK RSG12100.0       
PX Deq: Slave Session Stats349100.0       
PX Deq: reap credit5253100.0.0      
Parameter File I/O2462.54.24.220.88.3   
SGA: allocation forcing component growth3  33.3   66.7 
SQL*Net break/reset to client750100.0       
SQL*Net message to client48.7M100.0.0.0.0    
SQL*Net more data from client8100.0       
SQL*Net more data to client12K100.0.0      
Streams AQ: qmn coordinator waiting for slave to start2       100.0
asynch descriptor resize297100.0       
buffer busy waits220493.92.8.7.6.1.31.5 
buffer deadlock111998.41.6      
control file parallel write130850.918.014.410.65.0.8.2 
control file sequential read758698.6.7.3.2.2.1.1 
cursor: mutex X1283.3   16.7   
cursor: pin S362444.31.0.6.254.0   
cursor: pin S wait on X1      100.0 
db file async I/O submit141.7K100.0.0   .0  
db file parallel write172.8K74.112.76.74.81.2.3.2.0
db file scattered read11444.71.83.513.223.77.95.3 
db file sequential read3465K15.62.97.424.430.214.94.5.0
direct path write2100.0       
enq: AF - task serialization1100.0       
enq: CF - contention9398.91.1      
enq: CO - master slave det93799.0.6.3     
enq: DR - contention1100.0       
enq: FB - contention38899.01.0      
enq: HW - contention19799.01.0      
enq: MW - contention1100.0       
enq: PE - contention2100.0       
enq: PG - contention1100.0       
enq: PS - contention34999.7.3      
enq: SV - contention172798.71.2.1     
enq: TA - contention13100.0       
enq: TD - KTF dump entries887.512.5      
enq: TK - Auto Task Serialization4100.0       
enq: TM - contention1100.0       
enq: TX - allocate ITL entry1580.06.76.7 6.7   
enq: TX - index contention118061.43.43.26.910.47.07.5.1
enq: TX - row lock contention21174.94.3 .91.43.814.7 
enq: US - contention2100.0       
enq: WF - contention21100.0       
gc buffer busy acquire10.5K43.84.04.18.010.36.123.6.1
gc buffer busy release30606.41.92.63.44.86.473.8.7
gc cr block 2-way53.1K99.0.9.1.0    
gc cr block busy37604.520.014.912.17.14.935.9.6
gc cr block congested93298.71.2.1     
gc cr failure1 100.0      
gc cr grant 2-way36.9K99.7.3.0.0    
gc cr grant congested85099.3.7      
gc cr multi block request140783.74.73.32.91.1.93.2.1
gc current block 2-way249.1K98.71.2.1.0.0   
gc current block busy66593.610.310.911.09.86.147.5.7
gc current block congested412198.61.1.3     
gc current grant 2-way45.6K99.3.6.1.0    
gc current grant busy16.2K98.7.8.1.0.0.0.2 
gc current grant congested96998.81.0.2     
gc current multi block request47299.2.6.2     
gc current split4987.88.22.02.0    
gcs enter server mode1      100.0 
gcs log flush sync100.5K37.19.310.211.212.819.4.0 
global enqueue expand wait36100.0       
ksxr poll remote instances7261100.0       
latch free389389.66.62.71.1.1   
latch: cache buffers chains388598.41.4.1.1.1   
latch: cache buffers lru chain180100.0       
latch: call allocation8100.0       
latch: checkpoint queue latch5100.0       
latch: enqueue hash chains3797.32.7      
latch: gc element45899.8.2      
latch: gcs resource hash42100.0       
latch: ges resource hash list33695.24.2.3.3    
latch: messages6100.0       
latch: object queue header operation14199.3.7      
latch: redo allocation19100.0       
latch: redo writing2100.0       
latch: row cache objects628894.14.11.4.4.0   
latch: session allocation51100.0       
latch: shared pool771.428.6      
libcache interrupt action by LCK9166100.0       
library cache lock1100.0       
library cache pin1100.0       
library cache: mutex X786395.1.5.1.04.2.1  
lock deadlock retry14100.0       
log file parallel write31.1K21.316.017.816.110.24.214.3.2
log file sync38K12.39.311.110.67.95.442.5.9
os thread startup21     76.223.8 
read by other session235313.94.29.323.527.915.45.7 
reliable message29693.66.1.3     
row cache cleanup10K100.0       
row cache lock44498.01.8.2     
row cache process11.7K100.0       
undo segment extension650.0   50.0   
wait list latch free2 100.0      
DIAG idle wait40.9K20.91.3.8.23.26.966.7 
GCR sleep563       100.0
KSV master wait1714100.0       
PING98077.7      22.3
PX Deq: Execute Reply12100.0       
PX Deq: Execution Msg134896.32.8.6.1.1.1  
PX Deq: Join ACK1233.358.38.3     
PX Deq: Msg Fragment40100.0       
PX Deq: Parse Reply12100.0       
PX Idle Wait33725.222.613.18.91.81.216.311.0
SQL*Net message from client48.7M84.611.11.6.6.7.5.9.0
Space Manager: slave idle wait2161.1  .0 .11.398.4
Streams AQ: RAC qmn coordinator idle wait199100.0       
Streams AQ: qmn coordinator idle wait19449.5      50.5
Streams AQ: qmn slave idle wait104       100.0
Streams AQ: waiting for messages in the queue568    .2.2.798.9
class slave wait2391.3      8.7
dispatcher timer47       100.0
gcs remote message802.1K44.611.210.410.210.113.4.0 
ges remote message37.9K14.81.61.71.51.73.475.3 
pmon timer938      .199.9
rdbms ipc message154.1K39.12.62.73.13.84.235.59.0
shared server idle wait93       100.0
smon timer891.1     3.495.5
wait for unread message on broadcast channel5685.2 .0.0.8 99.0 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
SGA: allocation forcing component growth233.3 66.7     
buffer busy waits3398.5.4.5.3.2.2  
control file parallel write299.8.1.1     
control file sequential read799.9.1.0.0 .0  
cursor: pin S wait on X1 100.0      
db file parallel write42599.8.1.1.0.0.0.0 
db file scattered read694.75.3      
db file sequential read156.5K95.53.8.6.1.0.0.0.0
enq: TX - index contention8992.53.12.2.8.9.5.1 
enq: TX - row lock contention3185.310.03.8.9    
gc buffer busy acquire248976.24.65.25.75.52.7.1 
gc buffer busy release227725.69.715.119.119.710.2.7 
gc cr block busy137363.55.98.69.77.84.0.6 
gc cr multi block request4696.7.8.7.7.7.3.1 
gc current block busy321551.77.111.212.610.86.0.7 
gc current grant busy3899.8.0.0.1.1.0  
gcs enter server mode1    100.0   
gcs log flush sync22100.0.0      
log file parallel write448785.63.23.93.62.31.2.2.0
log file sync16.5K56.66.39.511.510.05.3.8.0
os thread startup576.223.8      
read by other session13494.34.9.8     

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
Streams AQ: qmn coordinator waiting for slave to start2  100.0     
db file sequential read16100.0.0      
log file parallel write2100.0.0      
log file sync8100.0.0      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
yxdb81,01035,1463,4655,139,505
SYS$USERS13505
SYS$BACKGROUND00081
yxdbXDB0000

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
yxdb 3469415382342521157004873449344
SYS$USERS 180300015680
SYS$BACKGROUND 2822950010000

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
35,393.98209,4760.1743.683.7096.809t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
26,557.564,643,0230.0132.7888.320.0083p6uchsnm6n2   SELECT a.sys_user_name, a.org_...
19,213.742,095,0150.0123.712.2098.8786g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
15,507.032,095,0460.0119.142.9998.62c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
3,229.3929,8830.113.999.3833.6407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
3,173.5934,7360.093.9298.130.00ctpdw3pywk3k9   begin pkg_ca_lookup.p_get_owec...
1,494.00129,3620.011.8498.410.003d3k6bzs4nk3f   SELECT RCVBL_YM, ORG_NO, SUM(R...
1,441.39129,3600.011.7898.850.0042pxs62tawj10   SELECT RCVBL_YM, ORG_NO, SUM(R...
1,408.7629,4430.051.742.570.54fb7paxp4m9wcg   INSERT INTO A_PREPAY_FLOW (PRE...
718.0330,0110.020.894.3495.224bf7r12w7dg25   SELECT pkg_sp_seq.f_a_defid se...

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
23,456.554,643,0230.0166.7326,557.5688.320.0083p6uchsnm6n2   SELECT a.sys_user_name, a.org_...
3,114.1134,7360.098.863,173.5998.130.00ctpdw3pywk3k9   begin pkg_ca_lookup.p_get_owec...
1,470.30129,3620.014.181,494.0098.410.003d3k6bzs4nk3f   SELECT RCVBL_YM, ORG_NO, SUM(R...
1,424.74129,3600.014.051,441.3998.850.0042pxs62tawj10   SELECT RCVBL_YM, ORG_NO, SUM(R...
1,309.58209,4760.013.7335,393.983.7096.809t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
463.432,095,0460.001.3215,507.032.9998.62c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
422.572,095,0150.001.2019,213.742.2098.8786g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
303.0229,8830.010.863,229.399.3833.6407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
118.43104,0470.000.34168.4670.300.000zy85nnkqxrx6   select dept_no deptno from v_m...
118.1130,0100.000.34139.9684.392.837xn7z2p30awww   begin pkg_ca_counter.p_ca_coun...

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
34,260.22209,4760.1689.6035,393.983.7096.809t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
18,996.922,095,0150.0149.6819,213.742.2098.8786g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
15,293.182,095,0460.0140.0015,507.032.9998.62c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
1,086.3829,8830.042.843,229.399.3833.6407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
691.1159,9130.011.81699.293.5798.83bxctd2r3kgjyb   SELECT PL_AMT_ID FROM P_E_PL_A...
683.7130,0110.021.79718.034.3495.224bf7r12w7dg25   SELECT pkg_sp_seq.f_a_defid se...
683.6459,9120.011.79691.862.5998.817q8fzfa8p6gk8   SELECT PL_AMT_ID FROM P_E_PL_A...
382.6229,4420.011.00621.235.0261.5933j84p5q021j3   INSERT INTO A_PAY_FLOW (CHARGE...
315.064,1950.080.82325.892.1796.68g4ncbpmxhsh2b   SELECT a.org_no, a.cons_id, a....
301.4312,9030.020.79309.672.0397.34b76zzq2h9gm66   SELECT count(*) record_num FRO...

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
525,546,4774,643,023113.1910.2326,557.5688.3083p6uchsnm6n2   SELECT a.sys_user_name, a.org_...
121,892,71234,7363,509.122.373,173.5998.10ctpdw3pywk3k9   begin pkg_ca_lookup.p_get_owec...
72,201,653129,362558.141.401,494.0098.403d3k6bzs4nk3f   SELECT RCVBL_YM, ORG_NO, SUM(R...
49,028,991129,360379.010.951,441.3998.8042pxs62tawj10   SELECT RCVBL_YM, ORG_NO, SUM(R...
33,490,795523,32464.000.65242.0838.30f3pwz8c7b36m5   select * from indy_user_profil...
30,155,978209,476143.960.5935,393.983.796.89t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
17,307,9664,3943,939.000.3493.6690.904nxjprfhqt4jr   select DISTINCT a.sys_user_nam...
15,032,389119,638125.650.29283.4639.80cr61tqvuq0fzd   select pkg_ca_counter.f_getnew...
14,225,735119,468119.080.28214.8336.70942n22j17wfux   SELECT CUR_NOTE_NO, INV_OPER_I...
13,963,3534,655,2513.000.27220.7814.704fuvxgt352tdg   SELECT role_id FROM p_role WHE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
3,203,550209,47615.2992.4435,393.983.7096.809t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
1,602,1552,095,0150.7646.2319,213.742.2098.8786g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
1,601,4392,095,0460.7646.2115,507.032.9998.62c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
77,74529,8832.602.243,229.399.3833.6407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
52,13759,9130.871.50699.293.5798.83bxctd2r3kgjyb   SELECT PL_AMT_ID FROM P_E_PL_A...
51,95059,9120.871.50691.862.5998.817q8fzfa8p6gk8   SELECT PL_AMT_ID FROM P_E_PL_A...
51,85330,0111.731.50718.034.3495.224bf7r12w7dg25   SELECT pkg_sp_seq.f_a_defid se...
24,66129,4420.840.71621.235.0261.5933j84p5q021j3   INSERT INTO A_PAY_FLOW (CHARGE...
18,3464,1954.370.53325.892.1796.68g4ncbpmxhsh2b   SELECT a.org_no, a.cons_id, a....
16,58312,9031.290.48309.672.0397.34b76zzq2h9gm66   SELECT count(*) record_num FRO...

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
3,203,4843,203,484209,47615.290.0092.459t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
1,602,1291,602,1292,095,0150.760.0046.2386g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
1,601,4131,601,4132,095,0460.760.0046.21c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
77,77577,77529,8832.600.002.2407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
52,13752,13759,9130.870.001.50bxctd2r3kgjyb   SELECT PL_AMT_ID FROM P_E_PL_A...
51,95051,95059,9120.870.001.507q8fzfa8p6gk8   SELECT PL_AMT_ID FROM P_E_PL_A...
51,85351,85330,0111.730.001.504bf7r12w7dg25   SELECT pkg_sp_seq.f_a_defid se...
24,66124,66129,4420.840.000.7133j84p5q021j3   INSERT INTO A_PAY_FLOW (CHARGE...
18,34618,3464,1954.370.000.53g4ncbpmxhsh2b   SELECT a.org_no, a.cons_id, a....
16,58316,58312,9031.290.000.48b76zzq2h9gm66   SELECT count(*) record_num FRO...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
4,655,2514,655,0911.00220.7814.704fuvxgt352tdg   SELECT role_id FROM p_role WHE...
4,643,02368,904,07414.8426,557.5688.3083p6uchsnm6n2   SELECT a.sys_user_name, a.org_...
2,095,0462,095,0311.0015,507.03398.6c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
2,095,0152,095,0031.0019,213.742.298.986g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
523,32436,108,34169.00242.0838.30f3pwz8c7b36m5   select * from indy_user_profil...
269,427269,4221.0049.39530g03fat3zm461h   SELECT CAST(DBMS_RANDOM.VALUE(...
269,415269,4191.007.2765.60g29djn2028jrv   SELECT MOD(:B1 , 12) FROM DUAL
209,497209,5131.0023.7585.307b264xcn53h3m   SELECT :B21 LOCATION, :B20 RCV...
209,493838,0404.0019.0953.6043nabnvjnxcxs   SELECT PARA_NAME NAME, PARA_VA...
209,493628,5393.0020.0748.60f0zvt5m556g1h   SELECT '' NAME, '' VALUE, 0 DI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
209,425209,4936.4243nabnvjnxcxs   SELECT PARA_NAME NAME, PARA_VA...
209,417209,4936.42f0zvt5m556g1h   SELECT '' NAME, '' VALUE, 0 DI...
209,414209,4916.42g2rwb6n6qd4sy   SELECT NAME, VALUE, VALUE || '...
209,411209,4926.42d84sbdxtx6154   SELECT PARA_NAME NAME, PARA_VA...
209,401209,4976.427b264xcn53h3m   SELECT :B21 LOCATION, :B20 RCV...
191,8222,095,0155.8886g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
191,8172,095,0465.88c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
119,055269,4273.65g03fat3zm461h   SELECT CAST(DBMS_RANDOM.VALUE(...
119,050269,4153.65g29djn2028jrv   SELECT MOD(:B1 , 12) FROM DUAL
65,00266,7071.99bunvx480ynf57   SELECT 1 FROM DUAL
60,47760,4791.85ct1sv0zp5u7bz   SELECT * FROM TABLE(:B1 )
54,95959,9121.697q8fzfa8p6gk8   SELECT PL_AMT_ID FROM P_E_PL_A...
54,95159,9131.68bxctd2r3kgjyb   SELECT PL_AMT_ID FROM P_E_PL_A...
42,27060,3691.30bp3yfmnrn6u37   SELECT NVL(PARA_VALUE, '?') FR...
42,00859,9121.2985x2nh0ncy4rn   SELECT PARA_VALUE FROM A_PAY_C...
34,73734,7371.073pfdq4w46wcgt   SELECT * FROM (SELECT T.*, ROW...
34,400104,0911.0524sywb47s816k   SELECT PARA_NAME NAME, PARA_VA...
33,788108,3561.049b5xuf6ffcgq3   SELECT t.org_no org_no, null p...
32,644104,0471.000zy85nnkqxrx6   select dept_no deptno from v_m...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO SQL IdSQL ModuleSQL Text
1,810.7029,88367.283,229.3956.079.3833.6407ttw6rma134k   begin pkg_ca_counter.p_ca_arra...
1,356.1429,44350.391,408.7696.262.570.54fb7paxp4m9wcg   INSERT INTO A_PREPAY_FLOW (PRE...
232.3929,9008.64249.8593.017.132.03g5tva0zp1yz4v   SELECT NVL(PREPAY_BAL, 0) - NV...
222.153,8488.25284.5778.075.7516.1609g7gn0zqnu2s   begin pkg_be_common.p_initapp(...
211.3929,4427.85621.2334.035.0261.5933j84p5q021j3   INSERT INTO A_PAY_FLOW (CHARGE...
209.573,8487.79217.1596.511.582.22512pkdrfucyax   INSERT INTO S_APP_CERT (ACT_ID...
120.11119,6384.46283.4642.3739.830.00cr61tqvuq0fzd   select pkg_ca_counter.f_getnew...
118.53119,4684.40214.8355.1736.710.00942n22j17wfux   SELECT CUR_NOTE_NO, INV_OPER_I...
54.4234,4252.02152.3935.7118.3442.18dfcmxs132fy4g   begin pkg_be_common.p_updatere...
52.243,8241.9495.3554.7933.508.835xwhyp8wvvjwk   BEGIN OWF_MGR.WF_ENGINE.STARTP...
21.4722,0950.80142.9915.017.3077.379j429cnhv8w62   INSERT INTO p_special_maint_lo...
20.864,4190.78190.1910.973.4185.68c49c86qkjp1hf   INSERT INTO C_CONS(CONS_ID, VA...
5.234,1950.19325.891.602.1796.68g4ncbpmxhsh2b   SELECT a.org_no, a.cons_id, a....
3.914,4190.15119.463.276.6790.134jpp33nxykts6   begin pkg_ca_paymode.p_update_...
3.0230,0100.11139.962.1684.392.837xn7z2p30awww   begin pkg_ca_counter.p_ca_coun...
2.82129,3600.101,441.390.2098.850.0042pxs62tawj10   SELECT RCVBL_YM, ORG_NO, SUM(R...
2.8234,7360.103,173.590.0998.130.00ctpdw3pywk3k9   begin pkg_ca_lookup.p_get_owec...
2.7012,9030.10309.670.872.0397.34b76zzq2h9gm66   SELECT count(*) record_num FRO...
2.054,4190.08114.601.796.7490.5441xb9h8r0cfba   INSERT INTO C_CUST(ORG_NO, LEG...
1.704,4190.06141.071.203.0096.34gf7t338wcvvkh   INSERT INTO C_PAYMENT_RELA(PR_...
0.4030,0100.018.844.5637.3613.235ka8uwtu53fcd   SELECT A.TMP_PAY_RELA_NO, A.CO...
0.16209,4760.0135,393.980.003.7096.809t6habqtx6vzg   begin pkg_ca_counter.p_ca_coun...
0.082,095,0150.0019,213.740.002.2098.8786g6708pvuqtu   SELECT PL_AMT_ID FROM P_E_PL_A...
0.082,095,0460.0015,507.030.002.9998.62c98tw7kbymbru   SELECT PL_AMT_ID FROM P_E_PL_A...
0.0610.000.1151.7967.500.00dyj1ssw8jw54f   SELECT sum(case when a.sessio...
0.0210.000.0438.6672.530.006cp74g22fzahf   WITH ash as (SELECT ash.event...
0.0140.000.303.0415.4981.25cw7a1fjgc3p03 OEM.BoundedPool INSERT INTO MGMT_VIOLATIONS(CO...
0.0130.000.133.8987.330.00a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
07ttw6rma134kbegin pkg_ca_counter.p_ca_array_write_off(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18); end;
09g7gn0zqnu2sbegin pkg_be_common.p_initapp(:1, :2, :3, :4, :5, :6, :7, :8, :9); end;
0zy85nnkqxrx6select dept_no deptno from v_mr_dep_no where org_no = :1 order by prio_code
24sywb47s816kSELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '??????????'
33j84p5q021j3 INSERT INTO A_PAY_FLOW (CHARGE_ID, CASHCHK_ID, ACCT_ID, CONS_NO, ORG_NO, CHARGE_YM, CHARGE_DATE, ACCT_YM, TYPE_CODE, RCV_AMT, THIS_CHG, LAST_CHG, CHARGE_EMP_NO, PAY_MODE, SETTLE_MODE, SETTLE_NOTE_NO, SETTLE_BANK_CODE, ACCT_NO, CHARGE_REMARK, RCV_ORG_NO, DEPT_NO, STATUS_CODE, RELATE_ID, RCVED_DATE, BANK_DATE, CONS_BANK_ACCT, BRANCH_ID, PREPAY_CODE) VALUES (:B1 , :B31 , :B2 , :B3 , :B4 , TO_CHAR(:B15 , 'YYYYMM'), :B15 , :B30 , :B29 , :B5 , :B6 , :B7 , :B28 , :B27 , :B26 , :B25 , :B24 , :B8 , 'THIS:' || TO_CHAR(:B23 , :B22 ) || '|LAST:' || TO_CHAR(:B23 - DECODE(:B17 , '????', 0, NVL(:B9 , 0)), :B22 ) || '|' || DECODE(NVL(:B10 , '0'), '0', '', 'TRAN:' || :B10 ) || '|' || DECODE(:B17 , '????', 'XGYS:' || :B11 ) || '|' || DECODE(:B17 , '????', 'XGSJ:' || :B21 ) || '|' || DECODE(:B20 , -999999, '', 0, '', 'YZJE:' || :B20 || '|'), :B19 , :B18 , DECODE(:B17 , '????', '02', '01'), NULL, TO_CHAR(:B15 , 'YYYYMMDD'), NVL(:B1 6 , TO_CHAR(:B15 , 'yyyymmdd')), NVL(:B14 , '0'), :B13 , :B12 )
3d3k6bzs4nk3f SELECT RCVBL_YM, ORG_NO, SUM(RCVBL_AMT) RCVBL_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBL_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.RELEASE_YM < SUBSTR(:B1 , 1, 6) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_NO FROM P_MID_RCVBLSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RELEASE_DATE <> TO_CHAR(SYSDATE, 'yyyymmdd') AND RELEASE_DATE <= :B1 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_YM = SUBSTR(:B1 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVBL_AMT, B.OPERATOR_ NO FROM A_RCVBL_FLOW A, R_OPER_ACTIVITY B WHERE AMT_TYPE NOT IN (SELECT T.PARA_VALUE FROM A_PAY_CFG T WHERE PARA_TYPE = '??????????') AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RELEASE_DATE = TO_CHAR(SYSDATE, 'yyyymmdd') AND :B1 = TO_CHAR(SYSDATE, 'yyyymmdd') AND ORG_NO = :B5 AND (B.OPERATOR_NO = :B2 OR :B2 IS NULL) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO
3pfdq4w46wcgtSELECT * FROM (SELECT T.*, ROWNUM RN FROM (SELECT RCVBL_YM, ORG_NO, MR_SECT_EMPNO, SUM(RCVBL_AMT) RCVBL_AMT, SUM(RCVED_AMT) RCVED_AMT, SUM(RCVBL_AMT) - SUM(RCVED_AMT) OWE_AMT, (CASE SIGN(SUM(RCVBL_AMT)) WHEN 1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) * 100, '9999990.09') || '%' WHEN -1 THEN TO_CHAR(SUM(RCVED_AMT) / SUM(RCVBL_AMT) * 100, '9999990.09') || '%' ELSE '100%' END) RCVED_RAT, '??' DETAIL FROM TABLE(:B1 ) GROUP BY RCVBL_YM, ORG_NO, MR_SECT_EMPNO ORDER BY ORG_NO, RCVBL_YM DESC, MR_SECT_EMPNO) T) WHERE RN BETWEEN :B3 AND :B2
41xb9h8r0cfbaINSERT INTO C_CUST(ORG_NO, LEGAL_PERSON, CUST_ID, CUST_NO, NAME) VALUES(:1, :2, :3, :4, :5)
42pxs62tawj10 SELECT RCVBL_YM, ORG_NO, SUM(RCVED_AMT) RCVED_AMT, OPERATOR_NO FROM (SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVED_YSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM <> TO_CHAR(SYSDATE, 'YYYYMM') AND RCVED_YM < SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, RCVED_AMT, B.OPERATOR_NO FROM P_MID_RCVEDSTAT A, R_OPER_ACTIVITY B WHERE ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_DATE <> TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE <= :B2 AND RCVED_YM = SUBSTR(:B2 , 1, 6) AND A.MR_SECT_NO = B.MR_SECT_NO AND B.ACT_CODE = '03' AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) UNION ALL SELECT RCVBL_YM, ORG_NO, THIS_RCVED_AMT RCVED_AMT, B.OPERATOR_NO FROM A_RCVED_FLOW T, R_OPER_ACTIVITY B WHERE EXISTS (SELECT 1 FROM A_PAY_FLOW WHERE STATUS_CODE = '01' AND CHARGE_YM = T. RCVED_YM AND CHARGE_ID = T.CHARGE_ID) AND ORG_NO = :B5 AND RCVBL_YM >= :B4 AND RCVBL_YM <= :B3 AND RCVED_YM = TO_CHAR(SYSDATE, 'YYYYMM') AND :B2 = TO_CHAR(SYSDATE, 'YYYYMMDD') AND RCVED_DATE = TO_CHAR(SYSDATE, 'YYYYMMDD') AND T.MR_SECT_NO = B.MR_SECT_NO AND (B.OPERATOR_NO = :B1 OR :B1 IS NULL) AND B.ACT_CODE = '03') GROUP BY RCVBL_YM, ORG_NO, OPERATOR_NO
43nabnvjnxcxsSELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC
4bf7r12w7dg25SELECT pkg_sp_seq.f_a_defid seq FROM DUAL
4fuvxgt352tdgSELECT role_id FROM p_role WHERE role_desc = :1 AND role_grant_flag = :2 AND range_code = :3
4jpp33nxykts6begin pkg_ca_paymode.p_update_cons_extend(:1, :2, :3); end;
4nxjprfhqt4jrselect DISTINCT a.sys_user_name, a.org_no, a.dept_no, a.user_name from v_sp_user a where exists (select 1 from p_user_role_rela b where a.sys_user_name = b.sys_user_name and b.role_id = :1) AND a.org_no in (select org_no from o_org start with org_no = :2 connect by PRIOR org_no = p_org_no) AND a.cur_status_code IN ('04', '01') ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
512pkdrfucyaxINSERT INTO S_APP_CERT (ACT_ID, APPN_ID, APP_ID, CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY) SELECT PKG_SP_SEQ.F_C_DEFID, :B3 , :B2 , CERT_EFFECT_DATE, CERT_EXPIRE_DATE, CERT_ID, CERT_NAME, CERT_NO, CERT_TYPE_CODE, DIRECTORY FROM C_CERT WHERE CUST_ID = :B1
5ka8uwtu53fcdSELECT A.TMP_PAY_RELA_NO, A.CONS_NAME, (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.ORG_NO) ORG_NAME, A.ORG_NO, A.ELEC_ADDR, (SELECT NAME FROM P_CODE WHERE VALUE = C.PAY_MODE AND CODE_TYPE = 'payMode') PAYMODE, D.VAT_NO VATNO, A.CUST_ID, STATUS_CODE, VOLT_CODE, A.CONS_NO FROM C_CONS A, C_PAYMENT_RELA B, C_ACCT C, C_VAT D WHERE C.ACCT_ID(+) = B.ACCT_ID AND B.CONS_ID(+) = A.CONS_ID AND D.VAT_ID(+) = A.VAT_ID AND A.CONS_NO = :B1
5xwhyp8wvvjwkBEGIN OWF_MGR.WF_ENGINE.STARTPROCESS(:1, :2);END;
6cp74g22fzahf WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, r ound(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
7b264xcn53h3mSELECT :B21 LOCATION, :B20 RCV_ORG_NO, :B19 ACCT_ORG_NO, TO_CHAR(:B18 ) PAGE_LINE, :B17 SFQX, :B16 TWFS, :B15 CHG, UPPER(:B14 ) POSCS, UPPER(:B13 ) VOICECS, :B12 APP_MODEL, :B11 PRT_VALUE, :B10 PREVIEW_FLAG, :B9 ANALYSIS_FLAG, :B8 MULTI_CONS, :B7 CHG_KZ, :B6 MAXMONEY, :B5 ISPRTTOGETHER, :B4 LIMITMONEY, :B3 PRECHG_KZ, :B2 PRECHK_FLAG, :B1 JM_BFSFZ FROM DUAL
7q8fzfa8p6gk8SELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *400
7xn7z2p30awwwbegin pkg_ca_counter.p_ca_counter_attr_query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); end;
83p6uchsnm6n2SELECT a.sys_user_name, a.org_no, a.dept_no, a.user_name FROM v_sp_user a, p_user_role_rela b WHERE a.sys_user_name = b.sys_user_name AND b.role_id = :1 AND a.dept_no = :2 AND a.cur_status_code IN (:3, :4) ORDER BY nlssort(a.user_name, 'NLS_SORT=SCHINESE_PINYIN_M')
85x2nh0ncy4rnSELECT PARA_VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '???????????'
86g6708pvuqtuSELECT PL_AMT_ID FROM P_E_PL_ATMTM WHERE ID = :B2 + :B1 *200
942n22j17wfuxSELECT CUR_NOTE_NO, INV_OPER_ID, REMAIN_T_NUM FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0 AND BGN_NO = (SELECT MIN(BGN_NO) FROM A_INV_IO WHERE OPER_STATUS = '02' AND NOTE_TYPE_CODE = :B2 AND INITIATOR_NO = :B1 AND VER_ID IS NOT NULL AND REMAIN_T_NUM > 0)
9b5xuf6ffcgq3SELECT t.org_no org_no, null p_org_no, t.sort_no disp_sn, t.org_name name, t.org_type org_type_code, (select count(a.org_no) FROM o_org a WHERE a.p_org_no = t.org_no) subs FROM o_org t WHERE t.org_no = :1 ORDER BY t.sort_no
9j429cnhv8w62INSERT INTO p_special_maint_log (log_id, chg_type_code, table_name, primary_key, log_time, end_time, content, user_name, login_ip, qry_name, qry_value) VALUES (:1, :2, upper(:3), :4, SYSDATE, SYSDATE, :5, :6, :7, :8, :9)
9t6habqtx6vzgbegin pkg_ca_counter.p_ca_counter_para(:1, :2, :3, :4, :5, :6, :7, :8); end;
a8j39qb13tqkr SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_F INDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
b76zzq2h9gm66SELECT count(*) record_num FROM c_cons a WHERE a.org_no = :1 AND a.cons_no = :2 AND nvl(a.status_code, 'x') <> '9'
bp3yfmnrn6u37SELECT NVL(PARA_VALUE, '?') FROM A_PAY_CFG WHERE PARA_TYPE = '????' AND PARA_NAME = '????????'
bunvx480ynf57SELECT 1 FROM DUAL
bxctd2r3kgjybSELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *400
c49c86qkjp1hfINSERT INTO C_CONS(CONS_ID, VAT_ID, CUST_ID, CONS_NO, CONS_NAME, CUST_QUERY_NO, TMP_PAY_RELA_NO, ORGN_CONS_NO, VOLT_CODE, ELEC_ADDR, TRADE_CODE, ELEC_TYPE_CODE, CONTRACT_CAP, RUN_CAP, SHIFT_NO, LODE_ATTR_CODE, HEC_INDUSTRY_CODE, HOLIDAY, BUILD_DATE, PS_DATE, CANCEL_DATE, DUE_DATE, NOTIFY_MODE, SETTLE_MODE, STATUS_CODE, ORG_NO, RRIO_CODE, CHK_CYCLE, LAST_CHK_DATE, CHECKER_NO, POWEROFF_CODE, TRANSFER_CODE, MR_SECT_NO, NOTE_TYPE_CODE, TMP_FLAG, TMP_DATE, CONS_SORT_CODE, RURAL_CONS_CODE) 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)
c98tw7kbymbruSELECT PL_AMT_ID FROM P_E_PL_ATMTE WHERE ID = :B2 + :B1 *200
cr61tqvuq0fzdselect pkg_ca_counter.f_getnewnoteno(:1, :2) inv_no from dual
ct1sv0zp5u7bzSELECT * FROM TABLE(:B1 )
ctpdw3pywk3k9begin pkg_ca_lookup.p_get_owecount_group_empno(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13); end;
cw7a1fjgc3p03INSERT INTO MGMT_VIOLATIONS(COLLECTION_TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, POLICY_GUID, TARGET_GUID, VALUE, VIOLATION_LEVEL) VALUES ( NVL(:1, SYSDATE), NVL(:2, ' '), :3, :4, :5, :6, :7, :8, :9)
d84sbdxtx6154SELECT PARA_NAME NAME, PARA_VALUE VALUE FROM A_PAY_CFG WHERE PARA_TYPE = '????????' ORDER BY FILE_ID ASC
dfcmxs132fy4gbegin pkg_be_common.p_updaterecord(:1, :2, :3, :4, :5); end;
dyj1ssw8jw54f SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.snap_id > :bid AND a.snap_id <= :eid
f0zvt5m556g1hSELECT '' NAME, '' VALUE, 0 DISP_SN FROM DUAL UNION ALL SELECT NAME, VALUE, DISP_SN FROM P_CODE WHERE CODE_TYPE = 'bankCode' AND NVL(CONTENT1, 1) = '1'
f3pwz8c7b36m5select * from indy_user_profile where user_id in ( select user_id from indy_user where user_name=:1 )
fb7paxp4m9wcgINSERT INTO A_PREPAY_FLOW (PREPAY_ID, CHARGE_ID, PREPAY_AMT, CONS_NO, ORG_NO, PREPAY_DATE, PREPAY_YM, ACCT_NO, NOTE_ID, RCVBL_AMT_ID, PREPAY_TYPE, PREPAY_CODE, AMT_TYPE) SELECT PKG_SP_SEQ.F_A_PRE_FLO_PREID, :B7 , :B6 - :B8 , :B5 , :B4 , TO_CHAR(:B9 , 'YYYYMMDD'), TO_CHAR(:B9 , 'YYYYMM'), :B3 , '0', :B2 , '01', :B1 , '01' FROM DUAL WHERE :B6 - :B8 <> 0
g03fat3zm461hSELECT CAST(DBMS_RANDOM.VALUE(1, 257199038) AS NUMBER(9)) FROM DUAL
g29djn2028jrvSELECT MOD(:B1 , 12) FROM DUAL
g2rwb6n6qd4sySELECT NAME, VALUE, VALUE || '|' || DECODE(NVL(CONTENT2, '?'), '?', 'YES', '?', 'NO') ISINV FROM V_SP_CODE WHERE VALUE NOT IN ('06', '09', '04', '07') AND CODE_TYPE = 'settleMode' ORDER BY VALUE ASC
g4ncbpmxhsh2b SELECT a.org_no, a.cons_id, a.cust_id, a.rrio_code, a.run_cap orgn_run_cap, a.run_cap t_run_cap, a.cust_id, a.cons_id, a.cons_no, a.cons_name, a.cust_query_no, a.tmp_pay_rela_no, a.orgn_cons_no, a.cons_sort_code, a.elec_addr, a.trade_code, (SELECT name FROM v_sp_code WHERE code_type = 'tradeCode' AND value = a.trade_code) trade, a.elec_type_code, a.shift_no, (SELECT o.org_name FROM o_org o WHERE o.org_no= a.org_no) org_name, a.lode_attr_code, a.volt_code, a.hec_industry_code, a.holiday, a.notify_mode, a.settle_mode, a.org_no ps_org_no, a.transfer_code, a.mr_sect_no, a.note_type_code, a.tmp_flag, a.tmp_date, a.build_date, a.contract_cap orgn_contract_cap, a.contract_cap t_contract_cap, a.rrio_code prio_code, b.pr_id, b.pay_agreement_no, c.pay_mode, d.vat_id, d.vat_name, d.vat_no, d.vat_acct, d.bank_code vat_bank_code, d.reg_addr, d.tel_no vat_tel_no, d.bgn_date vat_bgn_date, d.end_date vat_end_date, e.csa_id elec_addr_id, e.province_code, e.cit y_code, e.county_code, e.street_code, e.village_code, e.road_code, e.community_code, e.plate_no, f.cust_no, f.name cust_name, f.credit_level_code, f.value_level_code, f.risk_level_code, f.org_no cust_org_no FROM c_cons a, c_payment_rela b, c_acct c, c_vat d, c_elec_addr e, c_cust f WHERE a.cons_id = b.cons_id(+) AND b.acct_id = c.acct_id(+) AND a.vat_id = d.vat_id(+) AND a.cons_id = e.cons_id(+) AND a.cust_id = f.cust_id(+) AND a.cons_no = :1
g5tva0zp1yz4vSELECT NVL(PREPAY_BAL, 0) - NVL(FREEZE_AMT, 0) - NVL(TRANSIT_NOTE_BAL, 0) - NVL(CHECK_AMT, 0), NVL(FREEZE_AMT, 0) FROM A_ACCT_BAL WHERE CONS_NO = :B2 AND PREPAY_CODE = :B1 FOR UPDATE NOWAIT
gf7t338wcvvkhINSERT INTO C_PAYMENT_RELA(PR_ID, ACCT_ID, CONS_ID, PAY_AGREEMENT_NO, ORG_NO) VALUES(:1, :2, :3, :4, :5)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes3,368,2661,196.4985.26
execute count26,092,4619,268.66660.47
gc cr block receive time39,42014.001.00
gc cr blocks received59,80521.241.51
gc current block receive time121,04243.003.06
gc current blocks received261,83393.016.63
logons cumulative6340.230.02
opened cursors cumulative14,466,5995,138.88366.19
parse count (total)3,261,3391,158.5082.55
parse time elapsed8,9573.180.23
physical reads3,465,6441,231.0887.72
physical writes248,61288.316.29
redo size539,501,308191,643.6213,656.19
session cursor cache hits2,782,866988.5470.44
session logical reads5,139,590,1951,825,703.91130,096.45
user calls50,797,61518,044.511,285.82
user commits38,31813.610.97
user rollbacks1,1880.420.03
workarea executions - optimal7,867,0052,794.55199.13

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count20.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count100.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count60.000.00
Batched IO single block count10.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count30.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced17,8436.340.45
CCursor + sql area evicted00.000.00
CPU used by this session2,991,3361,062.5975.72
CPU used when call started2,978,0651,057.8875.38
CR blocks created33,75911.990.85
Cached Commit SCN referenced2,904,9881,031.9273.53
Commit SCN cached8,7333.100.22
DBWR checkpoint buffers written181,78164.574.60
DBWR checkpoints00.000.00
DBWR fusion writes61,52821.861.56
DBWR object drop buffers written00.000.00
DBWR transaction table writes8090.290.02
DBWR undo block writes25,9449.220.66
DFO trees parallelized80.000.00
Effective IO time00.000.00
HSC Heap Segment Block Changes474,429168.5312.01
Heap Segment Array Inserts67,94924.141.72
Heap Segment Array Updates1850.070.00
Number of read IOs issued00.000.00
PX local messages recv'd160.010.00
PX local messages sent160.010.00
PX remote messages recv'd7220.260.02
PX remote messages sent6820.240.02
Parallel operations not downgraded80.000.00
Requests to/from client48,724,02217,307.921,233.33
RowCR - row contention180.010.00
RowCR attempts5,442,2121,933.20137.76
RowCR hits5,459,6881,939.41138.20
SMON posted for undo segment shrink650.020.00
SQL*Net roundtrips to/from client48,724,05917,307.941,233.33
TBS Extension: tasks created40.000.00
TBS Extension: tasks executed40.000.00
active txn count during cleanout84,50630.022.14
background timeouts19,5776.950.50
branch node splits140.000.00
buffer is not pinned count4,862,403,9091,727,240.79123,080.14
buffer is pinned count67,212,739,69723,875,553.691,701,329.92
bytes received via SQL*Net from client1,929,435,923685,381.2448,839.06
bytes sent via SQL*Net to client10,431,497,6023,705,514.49264,048.44
calls to get snapshot scn: kcmgss26,201,3749,307.35663.23
calls to kcmgas207,24473.625.25
calls to kcmgcs1,871,504664.8047.37
cell physical IO interconnect bytes31,731,009,53611,271,604.54803,194.69
change write time1,7290.610.04
cleanout - number of ktugct calls55,90819.861.42
cleanouts and rollbacks - consistent read gets33,25011.810.84
cleanouts only - consistent read gets6,7312.390.17
cluster key scan block gets190,17767.564.81
cluster key scans106,21637.732.69
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed2670.090.01
commit batch/immediate requested2670.090.01
commit cleanout failures: block lost37,29613.250.94
commit cleanout failures: buffer being written790.030.00
commit cleanout failures: callback failure3910.140.01
commit cleanout failures: cannot pin1610.060.00
commit cleanouts1,150,496408.6829.12
commit cleanouts successfully completed1,112,569395.2128.16
commit immediate performed2670.090.01
commit immediate requested2670.090.01
commit txn count during cleanout135,23248.043.42
consistent changes318,082112.998.05
consistent gets5,135,539,8261,824,265.12129,993.92
consistent gets - examination69,081,19924,539.271,748.63
consistent gets direct00.000.00
consistent gets from cache5,135,539,8261,824,265.12129,993.92
consistent gets from cache (fastpath)5,059,388,6211,797,214.41128,066.33
cursor authentications960.030.00
data blocks consistent reads - undo records applied51,98818.471.32
db block gets4,050,3691,438.79102.53
db block gets direct3040.110.01
db block gets from cache4,050,0651,438.68102.52
db block gets from cache (fastpath)1,137,481404.0628.79
deferred (CURRENT) block cleanout applications304,267108.087.70
dirty buffers inspected5,6462.010.14
enqueue conversions30,63110.880.78
enqueue releases668,729237.5516.93
enqueue requests670,160238.0616.96
enqueue timeouts1,3940.500.04
enqueue waits3,4271.220.09
exchange deadlocks1,2080.430.03
free buffer inspected3,884,8141,379.9898.33
free buffer requested3,968,8901,409.84100.46
gc blocks compressed203,05272.135.14
gc cr block flush time35,27312.530.89
gc cr blocks served64,66222.971.64
gc current block flush time94,98833.742.40
gc current block pin time8000.280.02
gc current blocks served278,82499.047.06
gc force cr disk read20.000.00
gc kbytes saved584,286207.5514.79
gc kbytes sent2,163,603768.5654.77
gc local grants3,417,6291,214.0286.51
gc read wait timeouts00.000.00
gc read waits3990.140.01
gc remote grants107,89438.332.73
gcs messages sent748,159265.7618.94
ges messages sent13,0774.650.33
global enqueue get time10,5713.760.27
global enqueue gets async4570.160.01
global enqueue gets sync5,231,0551,858.19132.41
global enqueue releases5,197,5181,846.28131.56
heap block compress1,5140.540.04
hot buffers moved to head of LRU1,608,952571.5440.73
immediate (CR) block cleanout applications39,98114.201.01
immediate (CURRENT) block cleanout applications18,1066.430.46
index crx upgrade (positioned)3,2901.170.08
index fast full scans (full)280.010.00
index fetch by key17,806,1196,325.15450.72
index scans kdiixs134,699,48212,326.08878.33
leaf node 90-10 splits2800.100.01
leaf node splits5,4301.930.14
lob reads00.000.00
lob writes1320.050.00
lob writes unaligned1320.050.00
logical read bytes from cache42,103,511,072,76814,956,162,232.331,065,749,786.68
max cf enq hold time00.000.00
messages received236,03883.855.97
messages sent236,03883.855.97
min active SCN optimization applied on CR3,319,0271,179.0084.01
no buffer to keep pinned count2120.080.01
no work - consistent read gets5,057,804,3971,796,651.66128,026.23
non-idle wait count53,930,95319,157.551,365.13
parse count (describe)00.000.00
parse count (failures)1520.050.00
parse count (hard)1700.060.00
parse time cpu5,2171.850.13
physical read IO requests3,465,1951,230.9287.71
physical read bytes28,390,555,64810,084,996.37718,639.08
physical read total IO requests3,472,8301,233.6387.91
physical read total bytes28,515,199,48810,129,272.80721,794.14
physical read total multi block requests10.000.00
physical reads cache3,465,6441,231.0887.72
physical reads cache prefetch4490.160.01
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests178,20763.304.51
physical write bytes2,036,629,504723,458.9351,552.41
physical write total IO requests258,66891.886.55
physical write total bytes3,215,810,0481,142,331.7381,400.55
physical write total multi block requests2,3930.850.06
physical writes direct3040.110.01
physical writes direct (lob)40.000.00
physical writes from cache248,30888.206.29
physical writes non checkpoint183,39065.144.64
pinned buffers inspected3150.110.01
pinned cursors current580.020.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time2,8881.030.07
queries parallelized80.000.00
recursive calls50,798,33218,044.771,285.84
recursive cpu usage477,124169.4912.08
redo blocks checksummed by FG (exclusive)193,07968.594.89
redo blocks written1,109,677394.1828.09
redo entries1,881,816668.4747.63
redo ordering marks19,6086.970.50
redo size for direct writes7800.280.02
redo subscn max counts7,2482.570.18
redo synch long waits2510.090.01
redo synch time468,139166.2911.85
redo synch time (usec)4,681,442,7481,662,959.11118,499.54
redo synch time overhead (usec)4,276,0781,518.96108.24
redo synch time overhead count (<128 msec)40.000.00
redo synch time overhead count (<2 msec)38,24813.590.97
redo synch time overhead count (<32 msec)40.000.00
redo synch time overhead count (<8 msec)130.000.00
redo synch time overhead count (>=128 msec)30.000.00
redo synch writes38,32613.610.97
redo wastage10,055,1523,571.83254.52
redo write broadcast ack count350.010.00
redo write broadcast ack time3,1441.120.08
redo write info find38,27413.600.97
redo write info find fail20.000.00
redo write time109,40138.862.77
redo writes31,06511.040.79
rollback changes - undo records applied1,4020.500.04
rollbacks only - consistent read gets6710.240.02
root node splits20.000.00
rows fetched via callback12,784,1834,541.24323.60
session connect time00.000.00
shared hash latch upgrades - no wait7,371,9332,618.68186.60
shared hash latch upgrades - wait3,9241.390.10
sorts (memory)6,505,2732,310.83164.67
sorts (rows)130,052,69946,197.793,291.97
sql area evicted1520.050.00
sql area purged1520.050.00
summed dirty queue length181,18964.364.59
switch current to new buffer49,73417.671.26
table fetch by rowid36,017,184,82412,794,155.30911,688.98
table fetch continued row60.000.00
table scan blocks gotten47,334,73816,814.421,198.17
table scan rows gotten3,623,693,6061,287,221.6191,725.15
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)1,085,823385.7127.49
temp space allocated (bytes)00.000.00
total cf enq hold time9400.330.02
total number of cf enq holders930.030.00
total number of times SMON posted900.030.00
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction rollbacks2640.090.01
undo change vector size188,013,66066,786.904,759.12
user logons cumulative2760.100.01
user logouts cumulative2390.080.01
write clones created in background10.000.00
write clones created in foreground680.020.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current120161
opened cursors current463972
session cursor cache count177,824210,819
session pga memory402,100,256587,075,392
session pga memory max734,552,7041,224,193,024
session uga memory743,737,856901,657,808
session uga memory max16,186,532,96018,853,036,360

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Buffer Cache Reads26.4G1230.819.617M0M0.000M3464.5K10.56
DBWR0M0.000M1.9G63.29.689M0 
LGWR0M0.000M1.1G27.65.385M0 
Others120M2.71.043M41M0.94.015M76480.26
Direct Writes0M0.000M2M0.00.001M0 
TOTAL:26.6G1233.529.66M3G91.881.09M3472.2K10.54

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 File26.4G1230.889.618M1.9G63.30.69M10.568.00
Log File0M0.000M1.1G27.65.385M  
Control File119M2.70.042M41M0.93.015M0.23 
Other0M0.000M0M0.010M0.00 
Temp File0M0.000M0M0.000M4.67 
TOTAL:26.6G1233.589.661M3G91.881.09M10.548.00

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Buffer Cache Reads 26.4G1230.819.617M0M0.000M3464.5K10.56
Buffer Cache Reads (Data File) 26.4G1230.819.617M0M0.000M3464.5K10.56
DBWR 0M0.000M1.9G63.29.689M0 
DBWR (Data File) 0M0.000M1.9G63.29.689M0 
LGWR 0M0.000M1.1G27.65.385M0 
LGWR (Log File) 0M0.000M1.1G27.65.385M0 
Others 120M2.71.043M41M0.93.015M76280.25
Others (Control File) 119M2.70.042M41M0.93.015M75900.23
Others (Data File) 1M0.010M0M0.000M385.42
Direct Writes 0M0.000M2M0.00.001M0 
Direct Writes (Data File) 0M0.000M2M0.00.001M0 
TOTAL: 26.6G1233.529.66M3G91.881.089M3472.1K10.54

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
DATA_MAN 3,332,7251,18410.811.0027,3081183.8811102,69714.65
IDX_C 73,9712615.601.0044,01026.2816161955.79
IDX_S 6,530215.301.0040,0682.321514761147.79
IDX_P 7,700315.051.0022,6862.7315881416.82
DATA_C 23,902820.161.006,3448.492021842.78
USERS 4,664216.131.067,9061.631632,35316.62
IDX_A 1,571115.751.007,7440.561633,698132.94
DATA_A 2,827115.721.006,3601.001621,08597.60
IDX_OUT 3,429117.871.003,6051.221815152.00
DATA_D 5,020215.851.005191.7816000.00
DATA_S 639015.981.004,8560.23162242.50
UNDOTBS2 15012.001.002,7410.011211810.11
DATA_P 798013.951.191,6130.271415,7255.54
SYSAUX 57205.471.028460.205000.00
DATA_E 271018.711.008920.1019057874.86
DATA_OUT 10018.001.006460.001802210.00
SYSTEM 112015.271.04530.0415000.00
DATA_G 81019.011.0000.0319000.00
DATA_R 23018.701.0000.0119000.00
IDX_G 6016.671.0000.0017000.00
TEMP 303.331.0020.003000.00
DATA_O 1010.001.0000.00100405.25
IDX_R 1010.001.0000.0010000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
DATA_A/ora/yxdb/DATA_A.DBF 2,827115.721.00115.726,36021,08597.60
DATA_C/ora/yxdb/DATA_C.DBF 23,902820.161.00820.166,34421842.78
DATA_D/ora/yxdb/DATA_D.DBF 5,020215.851.00215.85519000.00
DATA_E/ora/yxdb/DATA_E.DBF 271018.711.00018.67892057874.86
DATA_G/ora/yxdb/DATA_G.DBF 81019.011.00019.010000.00
DATA_MAN/ora/yxdb/DATA_MAN.DBF 3,332,7251,18410.811.001,18410.8127,308102,69714.65
DATA_O/ora/yxdb/DATA_O.DBF 1010.001.00010.0000405.25
DATA_OUT/ora/yxdb/DATA_OUT.DBF 10018.001.00018.0064602210.00
DATA_P/ora/yxdb/DATA_P.DBF 798013.951.19014.171,61315,7255.54
DATA_R/ora/yxdb/DATA_R.DBF 23018.701.00018.700000.00
DATA_S/ora/yxdb/DATA_S.DBF 639015.981.00015.984,8562242.50
IDX_A/ora/yxdb/IDX_A.DBF 1,571115.751.00115.757,74433,698132.94
IDX_C/ora/yxdb/IDX_C.DBF 73,9712615.601.002615.6044,010161955.79
IDX_G/ora/yxdb/IDX_G.DBF 6016.671.00016.670000.00
IDX_OUT/ora/yxdb/IDX_OUT.DBF 3,429117.871.00117.873,60515152.00
IDX_P/ora/yxdb/IDX_P.DBF 7,700315.051.00315.0522,686881416.82
IDX_R/ora/yxdb/IDX_R.DBF 1010.001.00010.000000.00
IDX_S/ora/yxdb/IDX_S.DBF 6,530215.301.00215.3040,06814761147.79
SYSAUX/ora/yxdb/sysaux01.dbf 57205.471.0205.47846000.00
SYSTEM/ora/yxdb/system01.dbf 112015.271.04015.2853000.00
TEMP/ora/yxdb/temp01.dbf 303.331.0003.33200 
UNDOTBS2/ora/yxdb/undotbs02.dbf 15012.001.00012.002,74111810.11
USERS/ora/yxdb/users01.dbf 4,664216.131.06216.277,90632,35316.62

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
D3,029,1921005,104,851,8583,465,625248,3080018,371

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000181,7730

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
B0060950824938679476604938  0
E0302873932370872513067947660725130  12

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
D2,5600.103001.7022,1821315211.00
D5,1200.206001.6120,9201295847.00
D7,6800.309001.5219,7811278372.00
D10,2400.401,2001.4318,6571261137.00
D12,8000.501,5001.3617,6671245941.00
D15,3600.591,8001.2816,6541230402.00
D17,9200.692,0991.2015,6791215450.00
D20,4800.792,3991.1314,7771201603.00
D23,0400.892,6991.0713,9121188335.00
D25,6000.992,9991.0113,0991175858.00
D25,8561.003,0291.0013,0231174690.00
D28,1601.093,2990.9512,3361164154.00
D30,7201.193,5990.8911,6121153050.00
D33,2801.293,8990.8410,9311142601.00
D35,8401.394,1990.7910,2801132612.00
D38,4001.494,4990.749,6761123350.00
D40,9601.584,7990.709,1281114937.00
D43,5201.685,0990.668,6361107393.00
D46,0801.785,3990.638,2071100811.00
D48,6401.885,6980.607,840195186.00
D51,2001.985,9980.587,553190769.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.001,052,6680

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K6,861,5436,861,54300
64K128K10,80610,80600
128K256K71,82871,82800
256K512K47647600
512K1024K341,367341,36700
1M2M563,569563,56900
2M4M1,9691,96900
4M8M5,6465,64600
8M16M3,8053,80500

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
2,5600.1312.890.00100.0000
5,1200.2512.890.00100.0000
10,2400.5012.890.00100.0000
15,3600.7512.890.00100.0000
20,4801.0012.890.00100.0000
24,5761.2012.890.00100.0000
28,6721.4012.890.00100.0000
32,7681.6012.890.00100.0000
36,8641.8012.890.00100.0000
40,9602.0012.890.00100.0000
61,4403.0012.890.00100.0000
81,9204.0012.890.00100.0000
122,8806.0012.890.00100.0000
163,8408.0012.890.00100.0000

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)
4,6081.001779,4752,103,6211.004871.0030,275
4,7361.031779,4752,103,6261.004820.9930,275
4,8641.061779,4752,103,6261.004820.9930,275
4,9921.081779,4752,103,6261.004820.9930,275
5,1201.111779,4752,103,6261.004820.9930,275
5,2481.141779,4752,103,6261.004820.9930,275
5,3761.171779,4752,103,6261.004820.9930,275
5,5041.191779,4752,103,6261.004820.9930,275
5,6321.221779,4752,103,6261.004820.9930,275
5,7601.251779,4752,103,6261.004820.9930,275
6,1441.331779,4752,103,6261.004820.9930,275
6,6561.441779,4752,103,6261.004820.9930,275
7,1681.561779,4752,103,6261.004820.9930,275
7,6801.671779,4752,103,6261.004820.9930,275
8,1921.781779,4752,103,6261.004820.9930,275
8,7041.891779,4752,103,6261.004820.9930,275
9,2162.001779,4752,103,6261.004820.9930,275

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
11,9520.38476,79320,919,296
15,9360.50442,08418,657,293
19,9200.63426,89817,666,283
23,9040.75396,38515,679,054
27,8880.88369,28613,911,905
31,8721.00355,63013,022,470
35,8561.13333,97211,612,136
39,8401.25313,55910,279,938
43,8241.38304,2779,675,695
47,8081.50288,3458,636,502
51,7921.63281,7668,206,761
55,7761.75271,7017,553,033
59,7601.88271,7017,553,033
63,7442.00271,7017,553,033

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block17,60288050
undo header285518
undo block23929
segment header9818
1st level bmb7002
3rd level bmb2603
2nd level bmb2802

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 1,1901,19001,1802118.08
TX-Transaction (row lock contention) 50346457211211.18
CO-KTUCLO Master Slave enq (master slave det) 937093793700.47
FB-Format Block 791791038800.39
PS-PX Process Reservation 373373034900.37
HW-Segment High Water Mark 30,49830,493019700.46
CF-Controlfile Transaction 6,2406,24009300.43
TX-Transaction (allocate ITL entry) 151501501.33
WF-AWR Flush 292902100.48
TA-Instance Undo 141401300.77
TD-KTF map table enqueue (KTF dump entries) 990800.00
TK-Auto Task Serialization (Auto Task Serialization) 12120400.00
US-Undo Segment 78780200.00
PE-Parameter 12120200.00
TM-DML 521,083521,0650100.00
AF-Advisor Framework (task serialization) 13130100.00
PG-Global Parameter 330100.00
DR-Distributed Recovery 110100.00
MW-MWIN Schedule 110100.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
522.1435,9929282315/28.50/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
31-Jan 13:286,23810,01592816280/00/0/0/0/0/0
31-Jan 13:186,28310,11832523180/00/0/0/0/0/0
31-Jan 13:085,7039,5822321150/00/0/0/0/0/0
31-Jan 12:583,9116,27732418180/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 latch10.00 00 
ASM db client latch2,6000.00 00 
ASM map operation hash table10.00 00 
ASM network state latch450.00 00 
AWR Alerted Metric Element list28,7710.00 00 
Change Notification Hash table latch9380.00 00 
Consistent RBA31,0610.00 00 
DML lock allocation6,768,9480.000.0000 
Event Group Locks9320.00 00 
FIB s.o chain latch60.00 00 
FOB s.o list latch3,9660.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC other latch230.00 00 
IPC stats buffer allocation latch1,5690.00 01,7290.00
In memory undo latch10.00 00 
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS slv state obj latch10.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list152,4220.120.0307,3780.20
KJCT flow control latch1,291,7640.040.0000 
KMG MMAN ready and startup request latch9380.00 00 
KMG resize request state object freelist20.00 00 
KSXR large replies20.00 00 
KTF sga latch270.00 09450.00
KWQMN job cache list latch2370.00 00 
KWQS pqsubs latch400.00 00 
KWQS pqueue ctx latch4430.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0550.00
Memory Management Latch310.00 09380.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch9970.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process1,1710.00 00 
OS process allocation6,2390.00 00 
OS process: request allocation5530.00 00 
PL/SQL warning settings340,0900.030.0000 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch10,3880.00 00 
SGA IO buffer pool latch1020.00 01020.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch950.00 09360.00
SQL memory manager workarea list latch11,414,0090.020.0100 
Shared B-Tree8240.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch206,0060.150.0100 
active service list14,1940.00 01,5730.00
begin backup scn array150.00 00 
buffer pool30.00 00 
business card170.00 00 
cache buffer handles117,5640.010.0000 
cache buffers chains10,219,660,1460.280.0005,500,4920.01
cache buffers lru chain1,035,2870.100.1705,585,3540.13
cache table scan latch1140.00 01140.00
call allocation119,4840.800.0100 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5790.00 00 
channel operations parent latch614,4480.000.0000 
checkpoint queue latch5,605,5080.000.020453,0850.01
client/application info4,5100.00 00 
compile environment latch6350.00 00 
corrupted undo seg latch4,4700.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch450.00 00 
cvmap freelist lock10.00 00 
database property service latch320.00 00 
deferred cleanup latch450.00 00 
dml lock allocation450.00 00 
done queue latch10.00 00 
dummy allocation1,2280.080.0000 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 0265,3850.01
enqueue hash chains2,639,5860.180.010400.00
enqueues1860.00 00 
error message lists320.00 00 
fifteenth spare latch - children10.00 00 
file cache latch1,1600.00 00 
first Audit Vault latch2760.00 00 
flashback copy10.00 00 
fourteenth spare latch - children10.00 00 
fourth Audit Vault latch10.00 00 
gc element4,705,5780.080.120106,4540.03
gcs commit scn state10.00 00 
gcs opaque info freelist513,9440.050.0000 
gcs partitioned table hash10,184,4110.000.0003,327,7370.01
gcs pcm hashed value bucket hash10.00 00 
gcs remaster request queue29,4581.360.0000 
gcs resource freelist278,0230.020.0300 
gcs resource hash6,053,3820.020.0302670.00
gcs resource scan list6240.00 00 
gcs resource validate list10.00 00 
gcs shadows freelist156,4980.020.1700 
ges caches resource lists1,574,9570.020.00037,8530.02
ges deadlock list2,4660.00 030.00
ges domain table10,391,2510.000.0000 
ges enqueue table freelist10,403,5560.030.0100 
ges group table10,450,3170.010.0000 
ges process hash list3,3180.00 00 
ges process parent latch20,845,9380.000.8000 
ges process table freelist5530.00 00 
ges resource hash list20,360,1830.120.0102500.40
ges resource scan list1600.00 00 
ges resource table freelist5,3450.00 00 
ges timeout list7040.00 01680.00
ges value block free list10.00 00 
global KZLD latch for mem in SGA2760.00 00 
global ctx hash table latch20.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch640.00 02,7410.00
hash table modification latch1370.00 00 
heartbeat check10.00 07990.00
heartbeat structure management0  05630.00
interrupt manipulation2,7050.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 00 
k2q global data latch1,8760.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch120.00 00 
ksfv messages10.00 00 
ksim group membership cache1630.00 00 
ksim membership request latch0  01,6050.00
kss move lock430.00 00 
ksuosstats global area3930.00 00 
ksv allocation latch1250.00 00 
ksv class latch5,2170.00 00 
ksv msg queue latch10.00 00 
ksxp shared latch5530.00 00 
ksxp so latch5530.00 00 
ksz_so allocation latch5530.00 00 
ktm global data3760.00 00 
kwqbsn:qsga3400.00 00 
lgwr LWN SCN31,1220.020.0000 
list of block allocation40,4340.010.2000 
loader state object freelist60.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch110.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer local10.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch7,9060.00 00 
messages724,6520.180.0000 
mostly latch-free SCN32,2091.800.0100 
msg queue latch10.00 00 
multiblock read objects18,1000.020.2500 
name-service memory objects28,9980.00 00 
name-service namespace bucket28,5150.00 00 
name-service pending queue14,5980.00 00 
name-service request queue48,0110.00 00 
ncodef allocation latch450.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap1,722,4220.000.14071,6130.00
object queue header operation17,653,5280.260.0000 
object stats modification5120.00 00 
parallel query alloc buffer3,3330.00 00 
parallel query stats3620.00 00 
parallel txn reco latch2,4780.00 00 
parameter list2,8090.00 00 
parameter table management2,0140.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue242,9770.070.000219,4580.07
process allocation14,2260.021.0002970.00
process group creation5530.00 00 
process queue1,0640.00 00 
process queue reference20,3720.00 01,7970.00
qmn state object latch40.00 00 
qmn task queue latch4150.00 00 
query server freelists7230.00 00 
query server process40.00 00 
queued dump request100.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation102,6840.830.0201,880,1910.27
redo copy10.00 01,881,7990.02
redo writing309,2840.070.0100 
resmgr group change latch6130.00 00 
resmgr:active threads1,2640.00 00 
resmgr:actses change group6350.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list1,2270.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config370.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects36,800,6261.040.0220 
rules engine aggregate statistics110.00 00 
rules engine rule set statistics220.00 00 
second Audit Vault latch10.00 00 
sequence cache864,5830.060.0000 
session allocation23,412,0440.030.01023,410,7490.03
session idle bit125,004,7580.030.0300 
session queue latch10.00 00 
session state list latch1,6150.00 00 
session switching3020.00 00 
session timer9380.00 00 
seventh spare latch - X parent10.00 00 
shared pool360,8030.120.0200 
shared pool sim alloc30.00 00 
shared pool simulator280.00 00 
sim partition latch10.00 00 
simulator hash latch315,074,9310.040.0210 
simulator lru latch2180.00 0314,953,8203.84
sixth spare latch - X parent10.00 00 
sort extent pool176,8230.630.0000 
space background state object latch120.00 00 
space background task latch6,3112.570.0401,8990.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temporary table state object allocation1720.00 00 
tenth spare latch - X parent10.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
thirteenth spare latch - children10.00 00 
threshold alerts latch3630.00 00 
transaction allocation1,635,9020.000.0000 
twelfth spare latch - children10.00 00 
twenty-fifth spare latch - S par10.00 00 
twenty-first spare latch - S par10.00 00 
twenty-fourth spare latch - S par10.00 00 
twenty-second spare latch - S par10.00 00 
twenty-third spare latch - S par10.00 00 
undo global data422,4120.020.0000 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  031,1570.09

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains10,219,660,14628,287,7374,07828,297,433
row cache objects36,800,626381,2106,377374,924
simulator hash latch315,074,931129,9662,736127,264
object queue header operation17,653,52845,66914245,528
session idle bit125,004,75833,9881,08532,908
ges resource hash list20,360,18324,90434324,568
session allocation23,412,0447,631517,580
enqueue hash chains2,639,5864,646394,609
gc element4,705,5783,7094623,251
ges enqueue table freelist10,403,5562,827262,801
SQL memory manager workarea list latch11,414,0092,490342,456
ges group table10,450,3171,45451,449
gcs resource hash6,053,3821,319441,277
messages724,6521,29761,291
sort extent pool176,8231,10811,107
cache buffers lru chain1,035,2871,060181880
call allocation119,4849518943
redo allocation102,68485420835
mostly latch-free SCN32,2095808572
KJCT flow control latch1,291,7644612459
shared pool360,8034157408
active checkpoint queue latch206,0063003297
checkpoint queue latch5,605,5082285223
redo writing309,2842032201
KJC message pool free list152,4221816175
space background task latch6,3111627156
gcs resource freelist278,02369267
gcs shadows freelist156,49824420
ges process parent latch20,845,9381082
object queue header heap1,722,422716
list of block allocation40,434514
multiblock read objects18,100413
process allocation14,226330

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KJC message pool free listkjcsmpav: allocate a msg buffer036
KJC message pool free listkjcspfmbq: free vector of msg buffers030
KJCT flow control latchkjcts_sqenq: queue a message020
SQL memory manager workarea list latchqesmmIRegisterWorkArea:203013
SQL memory manager workarea list latchqesmmIUnRegisterWorkArea0421
active checkpoint queue latchkcbbacq: scan active checkpoints033
cache buffers chainskcbzwb01,101906
cache buffers chainskcbgtcr: fast path0711523
cache buffers chainskcbgtcr: kslbegin shared0706439
cache buffers chainskcbgtcr_20356313
cache buffers chainskcbchg1: mod cr pin0332141
cache buffers chainskcbgtcr: fast path (cr pin)0284900
cache buffers chainskclcls_302272
cache buffers chainskcbget: fast exchange0216183
cache buffers chainskcbget: pin buffer0114100
cache buffers chainskcbchg1: clear MS bit09773
cache buffers chainskcbzgb: scan from tail. nowait0950
cache buffers chainskcbgcur_205535
cache buffers chainskcbgtcr: kslbegin excl04653
cache buffers chainskcbrls_2040154
cache buffers chainskcbesc: escalate0303
cache buffers chainskclwlr02932
cache buffers chainskcbget: exchange02838
cache buffers chainskcbgcur: fast path (shr)02126
cache buffers chainskcbgtcr_102153
cache buffers chainskcbget: fast path01619
cache buffers chainskclbla0152
cache buffers chainskcbgcur_401116
cache buffers chainskcbchg1: mod cur pin0540
cache buffers chainskcbget: release excl0514
cache buffers chainskcbnlc0511
cache buffers chainskcbrls: fast release05270
cache buffers chainskcbso1: set no access0528
cache buffers chainskcbzibmlt: multi-block read: nowait040
cache buffers chainskclgrantlk040
cache buffers chainskcbbxsv031
cache buffers chainskcbsod10310
cache buffers chainskcbzib: finish processing buffer032
cache buffers chainskcllkopesc030
cache buffers chainskclrqchk0310
cache buffers chainskcbzib: exchange rls025
cache buffers chainskcbzibmlt: finish free bufs029
cache buffers chainskcbcge0163
cache buffers chainskclrlstp0125
cache buffers lru chainkcbzgws01620
cache buffers lru chainkcbzgb_20814
cache buffers lru chainkcbzgb0759
cache buffers lru chainkcbbwlru0213
cache buffers lru chainkcbo_ivd_proc0117
cache buffers lru chainkcbo_link_q013
call allocationksuprc066
call allocationksudlc : rec call011
call allocationksuxds010
checkpoint queue latchkcbkubc_4030
checkpoint queue latchkcbklbc_cql020
enqueue hash chainsksqrcl0146
enqueue hash chainsksqgtl301311
enqueue hash chainsksqcmi: if lk mode not requested087
enqueue hash chainsksqcmi: if lk mode requested0414
gc elementkclnfndnewm043123
gc elementkclchkping0560
gc elementkclbla04612
gc elementkclnfndx01941
gc elementkclfwrite10913
gc elementkclrwrite0512
gc elementKCLUNLNK0426
gc elementkclulb039
gc elementkclebs020
gc elementkclrlstp023
gc elementkclcqchk0151
gc elementkclgcbbrcbk1_1010
gc elementkclhngcbk1010
gc elementkclplz0111
gcs resource freelistkjbralc add resource021
gcs resource hashkjbassume0122
gcs resource hashkjbconvert0105
gcs resource hashkclfwrite1052
gcs resource hashkclrwrite040
gcs resource hashkjblocalobj_nolock047
gcs resource hashkjbopen040
gcs resource hashkjbcropen020
gcs resource hashkjbrwrdone reget022
gcs resource hashkjbcrcomplete010
gcs shadows freelistkjblfr free lock044
ges enqueue table freelistkjlalc: lock allocation01718
ges enqueue table freelistkjlfr: remove lock from parent object098
ges group tablekjgdgll: move a lock from group lock list to process lock list042
ges group tablekjgagll: move a lock from process lock list to group lock list013
ges process parent latchkjata_fg080
ges resource hash listkjlrlr: remove lock from resource queue0191182
ges resource hash listkjrmas1: lookup master node01007
ges resource hash listkjakoca: search for resp by resname04447
ges resource hash listkjrref: find matched resource04105
ges resource hash listkjakcai: search for resp by resname021
ges resource hash listkjcvscn: remove from scan queue020
lgwr LWN SCNkcs023030
list of block allocationktlbbl011
messagesksaamb: after wakeup032
messagesksarcv023
messagesksarcv: after wait011
mostly latch-free SCNkcslcu3058
multiblock read objectskcbzibmlt: normal mbr free010
object queue header heapkcbo_unlink_q010
object queue header operationkcbo_unlink_q010110
object queue header operationkcbo_ivbo04659
object queue header operationkcbo_link_q0310
object queue header operationkcbo_switch_cq064
object queue header operationkcbo_switch_q_bg042
object queue header operationkcbo_switch_mq_bg039
object queue header operationkcldbufs0155
process allocationksucrp:1030
redo allocationkcrfw_redo_gen: redo allocation 10190
redo allocationkcrfw_post: more space012
redo writingkcrfw_post: rba scn pair010
redo writingkcrfwcr012
row cache objectskqreqd: reget04,60831
row cache objectskqreqd01,021336
row cache objectskqrpre: find obj07486,010
session allocationksucri_int : SSO0410
session allocationksuxds01051
session idle bitksupuc: set busy0789344
session idle bitksupuc: clear busy0238504
session idle bitksuxds0129308
shared poolkghalp055
shared poolkghalo010
shared poolkghupr1011
simulator hash latchkcbsacc: lookup dba02,7312,734
simulator hash latchkcbs_lookup_setid: lookup dba042
simulator hash latchkcbsacc: insert dba010
sort extent poolktstcrtobj010
space background task latchktsj_grab_task077

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkksfbc [KKSCHLFSP2]5,3510
Library Cachekglpndl1 953,9750
Library Cachekglpnal2 912,7610
Cursor PinkksLockDelete [KKSCHLPIN6]2,3060
Library Cachekglpin1 41,0690
Library Cachekglpnal1 905590
Library Cachekglget1 11520
Library Cachekgllkal1 80940
Library Cachekgllkdl1 85700
Cursor Pinkksfbc [KKSCHLPIN1]690
Library Cachekglobpn1 71240
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]180
Library Cachekglhdgn2 106150
Cursor Pinkkslce [KKSCHLPIN2]70
Library Cachekgllkc1 5740
Library Cachekglhdgn1 6230
Cursor Pinkksxsccmp [KKSCHLPIN5]30
Library Cachekglget2 210

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
SGPMDATA_PP_USER_ROLE_RELA TABLE4,616,462,33689.82
SGPMIDX_PFK_SP_ROLE_USER_ROLE INDEX154,510,3363.01
SGPMDATA_MANIDX_2013010303 INDEX52,635,3601.02
AMBERDATA_PINDY_USER TABLE47,803,5200.93
SGPM_OUTDATA_OUTP_MID_RCVBL_YSTAT TABLE44,280,4960.86

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SGPMDATA_MANP_E_PL_ATMTM TABLE1,397,96240.34
SGPMDATA_MANP_E_PL_ATMTE TABLE1,397,37940.32
SGPMDATA_MANP_E_PL_ATMTE_IDX INDEX256,2817.39
SGPMDATA_MANP_E_PL_ATMTM_IDX INDEX256,2517.39
SGPMDATA_MANPK_A_PAY_FLOW_R01_RED INDEX16,6470.48

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SGPMDATA_MANP_E_PL_ATMTM TABLE1,397,91940.34
SGPMDATA_MANP_E_PL_ATMTE TABLE1,397,36640.33
SGPMDATA_MANP_E_PL_ATMTE_IDX INDEX256,2837.40
SGPMDATA_MANP_E_PL_ATMTM_IDX INDEX256,2537.40
SGPMDATA_MANPK_A_PAY_FLOW_R01_RED INDEX16,6470.48

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SGPMDATA_MANP_E_PL_ATMTM TABLE1,397,91940.34
SGPMDATA_MANP_E_PL_ATMTE TABLE1,397,36640.33
SGPMDATA_MANP_E_PL_ATMTE_IDX INDEX256,2837.40
SGPMDATA_MANP_E_PL_ATMTM_IDX INDEX256,2537.40
SGPMDATA_MANPK_A_PAY_FLOW_R01_RED INDEX16,6470.48

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SGPMDATA_MANPK_A_PAY_FLOW_R01_RED INDEX22,2338.94
SGPMIDX_PIDX_P_SPECIAL_PRIMARY_KEY INDEX17,4027.00
SGPMIDX_PPK_P_SPECIAL_MAINT_LOG INDEX12,6675.10
SGPMDATA_CC_CONSP1240201TABLE PARTITION4,0821.64
SGPMIDX_CIDX_C_CONS_CONS_NO INDEX3,8601.55

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SGPMDATA_MANPK_A_PAY_FLOW_R01_RED INDEX22,23412.48
SGPMIDX_PIDX_P_SPECIAL_PRIMARY_KEY INDEX13,6307.65
SGPMIDX_PPK_P_SPECIAL_MAINT_LOG INDEX6,0533.40
SGPMIDX_CIDX_C_CONS_CONS_NO INDEX3,8602.17
SGPMDATA_CC_CONSP1240201TABLE PARTITION3,7772.12

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_3349992778_0TABLE PARTITION30098.68

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SGPMDATA_EA_ACCT_BALP1240201TABLE PARTITION67,0406.81
SGPMIDX_SPK_S_APP_APP_NO INDEX46,5924.73
SGPMDATA_AA_PAY_FLOWPMAXTABLE PARTITION40,6724.13
SGPMIDX_ALOC_A_PAY_FLOW_ACNOPMAXINDEX PARTITION35,1363.57
SGPMIDX_AIDX_A_PREPAY_FLOW_R0_CHARGE_I1 INDEX34,0323.45

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SGPMDATA_EA_ACCT_BALP1240201TABLE PARTITION45828.84
SGPMIDX_ALOC_A_PAY_FLOW_ACNOPMAXINDEX PARTITION29618.64
SGPMIDX_AIDX_A_PREPAY_FLOW_CONS_NO1 INDEX19512.28
SGPMIDX_AIDX_A_PREPAY_FLOW_R0_CHARGE_I1 INDEX945.92
SGPMIDX_AIDX_A_PREPAY_FLOW_R01_ACCT_NO1 INDEX865.42

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SGPMIDX_SIDX_S_APP_HANDLE_TIME INDEX426.67
SGPMIDX_AIDX_A_PREPAY_FLOW_R0_CHARGE_I1 INDEX320.00
SGPMIDX_AIDX_A_PREPAY_FLOW_CONS_NO1 INDEX213.33
SGPMIDX_SFK_S_APP_ACCT_S_APP_PAYMENT_RE INDEX16.67
SGPMIDX_SFK_S_APP_NATURAL_INFO_S_APP_AC INDEX16.67

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SGPMIDX_ALOC_A_PAY_FLOW_ACNOPMAXINDEX PARTITION61631.13
SGPMDATA_MANLOC_A_PAY_FLOW_LONG2 INDEX41220.82
SGPMIDX_AIDX_A_PREPAY_FLOW_CONS_NO1 INDEX21410.81
SGPMDATA_EA_ACCT_BALP1240201TABLE PARTITION974.90
SGPMDATA_MANPK_A_PREPAY_FLOW_R01_RED1 INDEX793.99

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
AMBERDATA_PNDX_INDY_USER_PROFILE INDEX2,31021.02
SGPMIDX_AIDX_A_PREPAY_FLOW_CONS_NO1 INDEX1,23111.20
SGPMDATA_AA_INV_IO TABLE1,0239.31
WF_AMBERDATA_PINDYWF_WORKLIST_CUR TABLE8377.62
WF_AMBERDATA_PINDYSP_TASK_USER_CURP1240100TABLE PARTITION7907.19

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SGPMDATA_EA_ACCT_BALP1240201TABLE PARTITION13,59922.74
OWF_MGRUSERSWF_TASK TABLE7,65112.79
SGPMIDX_SPK_S_APP_CONS_NO INDEX3,5815.99
SGPMIDX_SIDX_S_APP_PAYMENT_INS_ID INDEX1,7142.87
SGPMIDX_SIDX_S_APP_NATURAL_INS_ID INDEX1,7082.86

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SGPMIDX_AIDX_A_PREPAY_FLOW_R0_CHARGE_I1 INDEX18,7127.15
SGPMDATA_MANPK_A_PREPAY_FLOW_R01_RED1 INDEX18,3407.00
SGPMIDX_AIDX_A_PREPAY_FLOW_R01_ACCT_NO1 INDEX15,7256.01
SGPMIDX_AIDX_A_PREPAY_FLOW_CONS_NO1 INDEX13,5835.19
SGPMDATA_EA_ACCT_BALP1240201TABLE PARTITION13,3265.09

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_control560.000 21
dc_global_oids258,2300.000 0107
dc_histogram_data2790.000 03,303
dc_histogram_defs8590.000 07,408
dc_objects258,3450.000 04,131
dc_profiles5860.000 02
dc_rollback_segments49,9880.000 0179
dc_segments9662.590 416,798
dc_sequences23043.910 2308
dc_tablespaces5,754,9370.000 040
dc_users5,941,0430.000 092
global database name2,9090.000 01
outstanding_alerts15796.180 112

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control400
dc_objects300
dc_segments107510
dc_sequences4601010
outstanding_alerts3061440

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS8280.000 00
APP CONTEXT20.00140.0000
BODY5,0550.002,039,996-0.0000
CONTEXT POLICY4,4190.004,4190.0000
DBLINK8290.000 00
EDITION2870.005630.0000
INDEX120.00120.0000
QUEUE5640.004,7490.0000
RULESET0 110.0000
SCHEMA2770.000 00
SQL AREA23,0250.0726,418,165-0.02153152
SQL AREA BUILD1708.820 00
SQL AREA STATS17010.0017010.0000
TABLE/PROCEDURE93,1280.002,481,436-0.0000
TRANSFORMATION2820.002820.0000
TRIGGER940.0011,5190.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_STATUS8280000
BODY01,976,6841,976,68400
CONTEXT POLICY4,4194,4194,41900
DBLINK8290000
EDITION28728728700
INDEX12121200
QUEUE3,2224,7494,74900
RULESET0111100
SCHEMA2760000
TABLE/PROCEDURE151,6702,417,6132,417,61300
TRANSFORMATION28228228200
TRIGGER011,51411,51400

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 cache25,728.0025,856.0024,448.0025,856.000GRO/MAN
KEEP buffer cache0.000.000.000.000STA/
PGA Target20,608.0020,480.0020,480.0020,992.001SHR/MAN
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target31,744.0031,872.0031,360.0031,872.001GRO/DEF
Shared IO Pool0.000.000.000.000STA/
java pool128.00128.00128.00768.000SHR/DEF
large pool896.00896.00896.001,280.000SHR/DEF
shared pool4,736.004,736.002,944.004,736.000GRO/IMM
streams pool0.000.000.000.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache25,856.0025,856.0025,856.00110
PGA Target20,480.0020,480.0020,480.00101
SGA Target31,872.0031,872.0031,872.00110

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
01/31 13:37:380pgaSHR/MAN20,608-128 20,480COM
01/31 13:37:371sgaGRO/DEF31,744128 31,872COM
01/31 10:06:5412644bufcacheGRO/MAN25,344512 25,856COM

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
BOther377.85 3.073.912525123123
PL/SQL47.8629.430.401.00313121121
Freeable42.880.001.000.654 4343
SQL2.210.750.020.071209893
EOther504.55 3.083.542525164164
PL/SQL94.9644.230.591.19313162162
Freeable70.310.000.930.704 7676
SQL18.480.900.130.23120139134

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers26,977,763,32827,111,981,056
Fixed Size2,266,224 
Redo Buffers21,090,304 
Variable Size27,648,854,92827,514,637,200

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory128.00128.000.00
largefree memory888.19888.190.00
sharedASH buffers48.0048.000.00
sharedKGLH063.2263.540.50
sharedSQLA85.3386.341.19
shareddb_block_hash_buckets178.00178.000.00
sharedevent statistics per sess56.8956.890.00
sharedfree memory2,259.922,251.84-0.36
sharedgc name table96.0096.000.00
sharedgcs resources734.27734.270.00
sharedgcs shadows508.34508.340.00
sharedges big msg buffers54.1754.170.00
sharedges enqueues63.6263.840.34
sharedksunfy : SSO free list54.1354.130.00
 buffer_cache25,728.0025,856.000.50
 fixed_sga2.162.160.00
 log_buffer20.1120.110.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
2,8150.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.002,8150.00100.0000 
D0000.002,8150.00100.0000 
D0000.002,8150.00100.0000 
D0000.002,8150.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00 0.000.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/yxdb/adump  
audit_trailNONE  
cluster_databaseTRUE  
compatible11.2.0.4.0  
control_files/ora/yxdb/control01.ctl, /ora/fast_recovery_area/yxdb/control02.ctl  
db_block_size8192  
db_domain    
db_nameyxdb  
db_recovery_file_dest/ora/fast_recovery_area  
db_recovery_file_dest_size4621074432  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=yxdbXDB)  
instance_number2  
local_listener(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.55)(PORT=1521))  
memory_target54895050752  
open_cursors3000  
plsql_warningsDISABLE:ALL  
processes3000  
remote_listenernari-cluster-scan:1521  
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan    
session_cached_cursors800  
sessions4536  
spfile/ora/yxdb/spfileyxdb.ora  
thread2  
undo_tablespaceUNDOTBS2  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/ora/fast_recovery_area/yxdb/control02.ctl  
/ora/yxdb/control01.ctl  

Back to init.ora Parameters
Back to Top

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 114.25 8.14
Global Cache blocks served: 122.01 8.69
GCS/GES messages received: 269.03 19.17
GCS/GES messages sent: 270.41 19.27
DBWR Fusion writes: 21.86 1.56
Estd Interconnect traffic (KB) 1,995.50 

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

Buffer access - local cache %: 99.93
Buffer access - remote cache %: 0.01
Buffer access - disk %: 0.07

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 6.6
Avg global cache current block receive time (ms): 4.6
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 %: 6.0
Avg global cache cr block flush time (ms): 90.9
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 %: 2.3
Avg global cache current block flush time (ms): 146.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 1.7
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 55.81
% of indirect sent messages: 43.22
% of flow controlled messages: 0.97

Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourcePubSrc
eth2:1169.254.222.45N   

RAC Statistics


Back to Top


Back to Top

Global Messaging Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)22,8248.110.58
acks for commit broadcast(logical)23,6478.400.60
broadcast msgs on commit(actual)25,3779.010.64
broadcast msgs on commit(logical)31,06511.040.79
broadcast msgs on commit(wasted)1,8340.650.05
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received00.000.00
flow control messages sent00.000.00
gcs apply delta00.000.00
gcs assume cvt00.000.00
gcs assume no cvt129,35545.953.27
gcs ast xid490.020.00
gcs blocked converts234,10683.165.93
gcs blocked cr converts51,40118.261.30
gcs compatible basts1,2760.450.03
gcs compatible cr basts (global)4,0451.440.10
gcs compatible cr basts (local)25,9669.220.66
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs60,04621.331.52
gcs dbwr write request msgs36,32312.900.92
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 only50.000.00
gcs force cr grant00.000.00
gcs force cr no current00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts10,0093.560.25
gcs immediate (null) converts87,96631.252.23
gcs immediate cr (compatible) converts320.010.00
gcs immediate cr (null) converts71,63725.451.81
gcs indirect ast74,76126.561.89
gcs indirect bidless ast00.000.00
gcs indirect fg ast74,76126.561.89
gcs lms flush pi msgs00.000.00
gcs lms write request msgs5,3711.910.14
gcs msgs process time(ms)33,14311.770.84
gcs msgs received744,243264.3718.84
gcs new served by master13,3304.740.34
gcs out-of-order msgs10.000.00
gcs pings refused1780.060.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts1020.040.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 xid630.020.00
gcs regular cr00.000.00
gcs retry convert request00.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual18,6766.630.47
gcs side channel msgs logical410,537145.8310.39
gcs stale cr00.000.00
gcs undo cr1,3410.480.03
gcs write notification msgs2,3770.840.06
gcs writes refused2200.080.01
ges msgs process time(ms)3080.110.01
ges msgs received13,1004.650.33
global posts dropped00.000.00
global posts queue time50.000.00
global posts queued110.000.00
global posts requested110.000.00
global posts sent110.000.00
implicit batch messages received44,90815.951.14
implicit batch messages sent43,32415.391.10
lmd msg send time(ms)00.000.00
lms(s) msg send time(ms)00.000.00
messages flow controlled6,9842.480.18
messages queue sent actual272,69796.876.90
messages queue sent logical97,77134.732.47
messages received actual688,590244.6017.43
messages received logical757,343269.0319.17
messages sent directly400,679142.3310.14
messages sent indirectly310,270110.227.85
messages sent not implicit batched00.000.00
messages sent pbatched67,56824.001.71
msgs causing lmd to send msgs5,8052.060.15
msgs causing lms(s) to send msgs18,3796.530.47
msgs received queue time (ms)8,1652.900.21
msgs received queued757,343269.0319.17
msgs sent queue time (ms)17,0026.040.43
msgs sent queue time on ksxp (ms)1,200,541426.4630.39
msgs sent queued326,503115.988.26
msgs sent queued on ksxp695,970247.2217.62
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received50,11817.801.27
process batch messages sent56,14319.941.42


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests52,790
CURRENT Block Requests11,873
Data Block Requests52,790
Undo Block Requests1,148
TX Block Requests8,463
Current Results62,495
Private results1,614
Zero Results554
Disk Read Results0
Fail Results0
Fairness Down Converts15,195
Fairness Clears1,163
Free GC Elements0
Flushes3,882
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works1,768
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins40981.1711.743.673.420.00
Flushes6,5085.6730.3825.7237.171.06
Writes61,52633.5658.375.351.910.81


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 block49,48891.376.811.81259,09895.542.861.60
1undo header7,48994.634.031.3421193.364.741.90
1Others1,64999.030.060.912,48497.951.130.93
1undo block1,17168.3230.571.110   

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 block6.970.3098.150.344.650.28153.070.31
1undo header4.520.22107.040.2513.640.24282.810.91
1others0.210.207.060.200.280.207.220.22
1undo block13.470.2443.520.21    

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 block045,219100.000.00247,532100.000.00
1undo header07,087100.000.00197100.000.00
1others01,633100.000.002,433100.000.00
1undo block0800100.000.000  

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

   CR Avg Time (ms) Current Avg Time (ms)
Src Inst#Block Class Lost TimeImmed2hop3hopImmed2hop3hop
1data block 0.300.30 0.280.28 
1undo header 0.220.22 0.240.24 
1others 0.200.20 0.200.20 
1undo block 0.240.24    

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
12190.200.072190.250.10
22190.150.052190.140.04

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.750.70
Parallel Query0.000.00
DB Locks0.080.08
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
eth2:1169.254.222.45NO  0.000000 0.000000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report