WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
DBM112032532911053DBM11203123-Apr-14 16:0411.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
heliconLinux x86 64-bit 8 8 2 7.79

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:182623-Apr-14 19:30:1059 1.7
End Snap:182723-Apr-14 19:45:1374 1.8
Elapsed:  15.05 (mins)  
DB Time:  210.21 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 728M 728MStd Block Size: 8K
Shared Pool Size: 260M 260MLog Buffer: 9,508K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 14.0 0.1 0.01 0.00
DB CPU(s): 3.2 0.0 0.00 0.00
Redo size: 552,173.5 1,933.1  
Logical reads: 649,091.1 2,272.4  
Block changes: 3,948.6 13.8  
Physical reads: 857.4 3.0  
Physical writes: 578.1 2.0  
User calls: 4,051.3 14.2  
Parses: 1.6 0.0  
Hard parses: 0.4 0.0  
W/A MB processed: 0.1 0.0  
Logons: 0.0 0.0  
Executes: 1,914.2 6.7  
Rollbacks: 0.0 0.0  
Transactions: 285.6   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.96
Buffer Hit %: 99.87In-memory Sort %: 100.00
Library Hit %: 99.92Soft Parse %: 76.90
Execute to Parse %: 99.92Latch Hit %: 99.83
Parse CPU to Parse Elapsd %: 71.98% Non-Parse CPU: 98.91

Shared Pool Statistics

BeginEnd
Memory Usage %: 74.66 65.25
% SQL with executions>1: 79.00 70.05
% Memory for SQL w/exec>1: 68.33 61.00

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read770,8989,3361274.02User I/O
DB CPU 2,877 22.81 
log file sync256,68326712.12Commit
read by other session4,21951120.41User I/O
log file switch (private strand flush incomplete)26612450.10Configuration

Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
8.37 14.07 39.6 1.4 30.5 58.1
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
41.4 98.9 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 7,974.6 7,974.6
SGA use (MB): 1,024.0 1,024.0
PGA use (MB): 184.9 217.0
% Host Mem used for SGA+PGA: 15.16 15.56

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time12,024.6495.34
DB CPU2,876.5122.81
parse time elapsed57.060.45
connection management call elapsed time7.390.06
hard parse elapsed time3.630.03
hard parse (sharing criteria) elapsed time0.470.00
hard parse (bind mismatch) elapsed time0.460.00
PL/SQL compilation elapsed time0.260.00
PL/SQL execution elapsed time0.010.00
repeated bind elapsed time0.000.00
sequence load elapsed time0.000.00
DB time12,612.51 
background elapsed time221.86 
background cpu time62.12 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME297,133 
IDLE_TIME412,759 
IOWAIT_TIME216,362 
NICE_TIME99 
SYS_TIME10,170 
USER_TIME281,270 
LOAD814
PHYSICAL_MEMORY_BYTES8,361,992,192 
NUM_CPUS8 
NUM_CPU_CORES8 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX174,760 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX131,072 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
23-Apr 19:30:108.37     
23-Apr 19:45:1314.0741.8639.621.4358.1430.48

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/O775,29209,3881274.44
DB CPU  2,877 22.81
Commit256,683026712.12
Configuration418019460.15
Concurrency2,70601140.09
Network1,986,3100400.03
Application1,2300220.02
Other2913120.00
System I/O3640000.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 read770,89809,336122.9974.02
log file sync256,683026711.002.12
read by other session4,219051120.020.41
log file switch (private strand flush incomplete)266012450.000.10
cursor: pin S wait on X74081040.000.06
log file switch (checkpoint incomplete)14807470.000.06
SQL*Net message to client1,986,3100407.700.03
enq: TX - row lock contention1,2300220.000.02
library cache lock5001210.000.01
library cache load lock2701190.000.00
enq: TX - index contention3201160.000.00
library cache: mutex X2170020.000.00
latch: cache buffers chains1,3250000.010.00
kksfbc child completion61000510.000.00
db file parallel read2800110.000.00
cursor: pin S640040.000.00
buffer busy waits6350000.000.00
control file sequential read3640000.000.00
latch free1930010.000.00
enq: HW - contention400280.000.00
enq: TX - contention100690.000.00
latch: In memory undo latch2540000.000.00
row cache lock110030.000.00
latch: shared pool90020.000.00
latch: object queue header operation460000.000.00
db file scattered read20070.000.00
Disk file operations I/O1450000.000.00
latch: enqueue hash chains280000.000.00
enq: CU - contention10040.000.00
latch: row cache objects80000.000.00
latch: redo allocation50000.000.00
latch: undo global data60000.000.00
SQL*Net message from client1,986,307022,827117.70 
jobq slave wait120100605010.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 write242,545010500.9447.32
db file parallel write39,26602310.1510.33
control file sequential read2,47101460.016.41
db file sequential read1,65801490.016.40
db file scattered read8601110.000.43
log file sequential read5601100.000.26
direct path read3200150.000.21
os thread startup1100380.000.19
control file parallel write6630010.000.16
ASM file metadata operation5420010.000.14
LGWR wait for redo copy2,6340000.010.10
ADR block file read160070.000.05
latch: cache buffers chains180010.000.01
latch: redo allocation390000.000.00
reliable message580000.000.00
latch free110010.000.00
db file async I/O submit2,5640000.010.00
CSS initialization10070.000.00
direct path write270000.000.00
log file single write560000.000.00
latch: cache buffers lru chain220000.000.00
Disk file operations I/O510000.000.00
ADR block file write50000.000.00
CSS operation: action10020.000.00
latch: object queue header operation70000.000.00
rdbms ipc message246,243212,462510.95 
class slave wait26703,621135610.00 
Space Manager: slave idle wait454912,15847540.00 
DIAG idle wait1,8071001,81010010.01 
smon timer410906220920.00 
ASM background timer181090650030.00 
wait for unread message on broadcast channel90410090510020.00 
pmon timer3636990424900.00 
Streams AQ: qmn coordinator idle wait2904490231110.00 
Streams AQ: qmn slave idle wait129090269930.00 
SQL*Net message from client450050.00 
KSV master wait860000.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read1675.0  12.5  12.5 
ADR block file write5100.0       
ADR file lock6100.0       
ASM file metadata operation54591.74.03.3.4.2.2.2 
CSS initialization1   100.0    
CSS operation: action1 100.0      
CSS operation: query6100.0       
Disk file operations I/O196100.0       
LGWR wait for redo copy263899.6.2.2 .1   
SQL*Net message to client1991.1K100.0.0.0.0    
asynch descriptor resize61100.0       
buffer busy waits63998.0.6.8.2.2 .3 
control file parallel write66391.33.92.71.2.6.2.2 
control file sequential read283572.2.62.89.57.83.93.2 
cursor: pin S6456.36.34.7 31.31.6  
cursor: pin S wait on X742.71.4 1.417.613.563.5 
db file async I/O submit2565100.0       
db file parallel read28  7.135.746.47.13.6 
db file parallel write39.3K95.0.4.3.53.8.0.0 
db file scattered read8813.611.49.123.925.011.45.7 
db file sequential read774.4K2.12.014.139.425.710.16.7 
direct path read326.36.321.915.618.825.06.3 
direct path write2796.3 3.7     
enq: CU - contention1  100.0     
enq: HW - contention425.0    50.025.0 
enq: TX - contention1      100.0 
enq: TX - index contention3225.03.19.415.618.812.515.6 
enq: TX - row lock contention123684.74.13.13.71.71.9.8 
kksfbc child completion6      100.0 
latch free20493.62.9 .52.01.0  
latch: In memory undo latch25397.21.61.2     
latch: cache buffers chains134994.52.92.1.2.2 .1 
latch: cache buffers lru chain22100.0       
latch: checkpoint queue latch1100.0       
latch: enqueue hash chains2896.43.6      
latch: messages3100.0       
latch: object queue header operation5496.31.91.9     
latch: redo allocation4597.8 2.2     
latch: redo writing2100.0       
latch: row cache objects8100.0       
latch: session allocation2100.0       
latch: shared pool944.411.122.222.2    
latch: undo global data6100.0       
library cache load lock2711.1 3.7 22.255.67.4 
library cache lock5058.02.02.0 16.02.020.0 
library cache: mutex X21782.92.3.5 11.51.8.9 
log file parallel write243.1K92.73.22.21.0.6.2.0 
log file sequential read5626.87.114.316.123.25.47.1 
log file single write56100.0       
log file switch (checkpoint incomplete)148  2.02.711.516.267.6 
log file switch (private strand flush incomplete)2651.51.11.94.27.221.562.6 
log file sync257.3K85.45.73.92.22.1.7.1 
os thread startup11      100.0 
read by other session42273.95.215.533.722.011.87.7 
reliable message58100.0       
row cache lock119.1 90.9     
ASM background timer181       100.0
DIAG idle wait1811      99.9.1
KSV master wait8698.8 1.2     
SQL*Net message from client1991.1K26.6.2.2.146.226.1.7 
Space Manager: slave idle wait457      3.196.9
Streams AQ: qmn coordinator idle wait29255.1 .3    44.5
Streams AQ: qmn slave idle wait130       100.0
class slave wait26735.6 .4.73.45.622.132.2
jobq slave wait120      100.0 
pmon timer364.3  .51.1 11.087.1
rdbms ipc message246.8K31.417.521.818.47.6.71.5.9
smon timer4214.3     7.178.6
wait for unread message on broadcast channel905      100.0 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ADR block file read287.512.5      
ASM file metadata operation199.8 .2     
buffer busy waits299.7.3      
control file parallel write199.8.2      
control file sequential read9296.81.81.0.5    
cursor: pin S wait on X4736.528.4 28.46.8   
db file parallel read196.43.6      
db file parallel write7100.0.0.0.0    
db file scattered read594.34.51.1     
db file sequential read51.5K93.34.42.1.2.0   
direct path read293.83.13.1     
enq: HW - contention175.025.0      
enq: TX - contention1  100.0     
enq: TX - index contention584.49.46.3     
enq: TX - row lock contention1099.2.6.2     
kksfbc child completion6 100.0      
latch: cache buffers chains199.9.1      
library cache load lock292.67.4      
library cache lock1080.016.0  4.0   
library cache: mutex X299.1.9      
log file parallel write18100.0.0.0     
log file sequential read492.93.63.6     
log file switch (checkpoint incomplete)10032.444.623.0     
log file switch (private strand flush incomplete)16637.442.320.4     
log file sync23699.9.1.0.0    
os thread startup11 100.0      
read by other session32792.35.71.9.1    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

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)
DBM11203.antognini.ch12,5792,870770585,661
SYS$USERS101116
SYS$BACKGROUND00231

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
DBM11203.antognini.ch 77423093802706110019857354
SYS$USERS 8246000000
SYS$BACKGROUND 1837153300000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
3,625.67176,1820.0228.751.4498.7782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
2,314.6510,4420.2218.3592.645.10g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
1,327.33147,0580.0110.523.9095.728vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
1,290.2551,9480.0210.232.6797.159zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
1,038.3051,8870.028.232.0498.11d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
1,010.98147,0540.018.022.6297.285g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
323.4151,9450.012.565.9693.622yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
84.9151,9470.000.6714.2585.02gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
84.57311,1300.000.6787.050.00gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
42.65176,1860.000.3465.9415.17gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,144.3710,4420.2174.552,314.6592.645.10g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
73.62311,1300.002.5684.5787.050.00gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
52.16176,1820.001.813,625.671.4498.7782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
51.74147,0580.001.801,327.333.9095.728vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
34.4851,9480.001.201,290.252.6797.159zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
28.12176,1860.000.9842.6565.9415.17gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
26.44147,0540.000.921,010.982.6297.285g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
21.2051,8870.000.741,038.302.0498.11d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
19.2751,9450.000.67323.415.9693.622yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
18.68155,2520.000.6520.6890.340.007v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...

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
3,580.90176,1820.0238.083,625.671.4498.7782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
1,270.53147,0580.0113.511,327.333.9095.728vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
1,253.4551,9480.0213.331,290.252.6797.159zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
1,018.7051,8870.0210.831,038.302.0498.11d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
983.44147,0540.0110.461,010.982.6297.285g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
302.7751,9450.013.22323.415.9693.622yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
118.0610,4420.011.262,314.6592.645.10g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
72.1951,9470.000.7784.9114.2585.02gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
31.8110,4420.000.3438.6010.1282.416k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...
6.47176,1860.000.0742.6565.9415.17gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...

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
9,341,219311,13030.021.5984.57870gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
1,952,469147,05813.280.331,327.333.995.78vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
1,095,476155,2527.060.1920.6890.307v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
1,038,463147,0597.060.1818.3991.91dt8dtzvsq5kj5 Swingbench User Thread select p.product_id, product_n...
1,021,987176,1865.800.1742.6565.915.2gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
975,04951,94818.770.171,290.252.797.19zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
705,177176,1824.000.123,625.671.498.882ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
649,92751,94712.510.1184.9114.385gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
577,327147,0543.930.101,010.982.697.35g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
534,76151,94510.290.09323.41693.62yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
271,995176,1821.5435.143,625.671.4498.7782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
112,200147,0580.7614.491,327.333.9095.728vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
100,19151,9481.9312.941,290.252.6797.159zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
94,16251,8871.8112.161,038.302.0498.11d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
82,827147,0540.5610.701,010.982.6297.285g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
25,83151,9450.503.34323.415.9693.622yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
6,60251,9470.130.8584.9114.2585.02gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
6,53710,4420.630.842,314.6592.645.10g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
2,13010,4420.200.2838.6010.1282.416k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...
7931793.000.106.4719.7676.489zus1m3s2675b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...

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
271,994271,994176,1821.540.0035.1782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
112,210112,210147,0580.760.0014.518vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
100,193100,19351,9481.930.0012.959zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
94,16694,16651,8871.810.0012.18d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
82,83182,831147,0540.560.0010.715g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
25,83225,83251,9450.500.003.342yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
6,6026,60251,9470.130.000.85gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
6,5466,54610,4420.630.000.85g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
2,1302,13010,4420.200.000.286k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...
1,1261,12611,126.000.000.159zus1m3s2675b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
311,1301,565,8115.0384.57870gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
176,186176,1801.0042.6565.915.2gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
176,182176,1671.003,625.671.498.882ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
155,2521,552,49010.0020.6890.307v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
147,0591,470,49010.0018.3991.91dt8dtzvsq5kj5 Swingbench User Thread select p.product_id, product_n...
147,058147,0551.001,327.333.995.78vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
147,057147,0591.0012.1592.20982zxphp8ht6c Swingbench User Thread select product_id, product_nam...
147,054132,5840.901,010.982.697.35g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
51,94851,9471.001,290.252.797.19zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
51,94751,9471.005.4089.308uk8bquk453q8 Swingbench User Thread select orders_seq.nextval from...
51,947147,0382.8384.9114.385gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
51,94551,9451.00323.41693.62yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
51,88749,8960.961,038.30298.1d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
20,50220,5021.002.1090.505d8b4p888x97a Swingbench User Thread select customer_seq.nextval fr...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
15115110.51b2gnxm5z6r51n   lock table sys.col_usage$ in e...
1371379.53350f5yrnnmshs   lock table sys.mon_mods$ in ex...
23961.609tgj4g8y4rwy8   select type#, blocks, extents,...
191111.32bsa0wjtftg3uw   select file# from file$ where ...
17301.18cm5vu20fhtnq1   select /*+ connect_by_filterin...
15151.040k8522rmdzg4k   select privilege# from sysauth...
15151.040ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
1551,9451.042yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
15151.04459f3z9u4fb3u   select value$ from props$ wher...
1520,5021.045d8b4p888x97a Swingbench User Thread select customer_seq.nextval fr...
15147,0541.045g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
15151.045ur69atw3vfhj   select decode(failover_method,...
1510,4421.046k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...
15155,2521.047v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
15176,1821.0482ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
1551,9471.048uk8bquk453q8 Swingbench User Thread select orders_seq.nextval from...
15147,0581.048vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
15147,0571.04982zxphp8ht6c Swingbench User Thread select product_id, product_nam...
1551,9481.049zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
1551,8871.04d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
15147,0591.04dt8dtzvsq5kj5 Swingbench User Thread select p.product_id, product_n...
15151.04g4rkmp4240p84 Swingbench User Thread BEGIN dbms_application_info.se...
1510,4421.04g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
1551,9471.04gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
15176,1861.04gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
15311,1301.04gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...

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

Complete List of SQL Text

SQL IdSQL Text
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
2yp5w5a36s5xvupdate orders set order_mode = :1 , order_status = :2 , order_total = :3 where order_id = :4
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
5d8b4p888x97aselect customer_seq.nextval from dual
5g00dq4fxwnswupdate inventories set quantity_on_hand = quantity_on_hand - :1 where product_id = :2 and warehouse_id = :3
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6k3uuf3g8pwh6update /*+ index(orders, order_pk) */ orders set order_status = :1 where order_id = :2
7v0pya6f6qc6sselect p.product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url, quantity_on_hand, warehouse_id from product_information p, inventories i where category_id = :1 and i.product_id = p.product_id
82ud5h0qcg0bfselect customer_id, cust_first_name , cust_last_name , nls_language , nls_territory , credit_limit , cust_email , account_mgr_id from customers where customer_id = :1
8uk8bquk453q8select orders_seq.nextval from dual
8vvvyuun2urt6insert into order_items(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) values (:1 , :2 , :3 , :4 , :5 )
982zxphp8ht6cselect product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url from product_information where product_id = :1
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9zd49du11u7cfinsert into orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) values (:1 , :2 , :3 , :4 )
9zus1m3s2675bDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN perfstat.statspack.snap(i_snap_level => 7); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bsa0wjtftg3uwselect file# from file$ where ts#=:1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d5j6fbqmu3gjpSELECT /*+ use_nl */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and c.customer_id = :1
dt8dtzvsq5kj5select p.product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url, quantity_on_hand, warehouse_id from product_information p, inventories i where i.product_id = :1 and i.product_id = p.product_id
g4rkmp4240p84BEGIN dbms_application_info.set_client_info('Swingbench Load Generator'); END;
g8rhybcumtwd6SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email, order_date FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and o.order_status <= 4
gfqas5ahy1x56SELECT o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and o.order_id = :1
gshgncvvtv0c6insert into logon values(:1 , :2 )
gyk686gnaygs2select product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status list_price, min_price, catalog_url from product_information where category_id = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count4330.480.00
Batched IO (full) vector count00.000.00
Batched IO block miss count7680.850.00
Batched IO buffer defrag count30.000.00
Batched IO double miss count1230.140.00
Batched IO same unit count2630.290.00
Batched IO single block count4940.550.00
Batched IO vector block count1260.140.00
Batched IO vector read count620.070.00
Block Cleanout Optim referenced6,6757.390.03
CCursor + sql area evicted170.020.00
CPU used by this session274,380303.901.06
CPU used when call started274,171303.671.06
CR blocks created76,36884.590.30
Cached Commit SCN referenced41,73146.220.16
Commit SCN cached8,6099.540.03
DB time1,258,0621,393.434.88
DBWR checkpoint buffers written31,90035.330.12
DBWR checkpoints140.020.00
DBWR thread checkpoint buffers written31,90035.330.12
DBWR transaction table writes2850.320.00
DBWR undo block writes24,06826.660.09
HSC Heap Segment Block Changes589,972653.452.29
Heap Segment Array Inserts1730.190.00
Heap Segment Array Updates210.020.00
IMU CR rollbacks18,37320.350.07
IMU Flushes29,87133.090.12
IMU Redo allocation size143,624,724159,078.92556.93
IMU commits168,153186.250.65
IMU contention26,33629.170.10
IMU ktichg flush00.000.00
IMU pool not allocated59,91266.360.23
IMU recursive-transaction flush00.000.00
IMU undo allocation size376,000,264416,458.361,458.00
IMU- failed to get a private strand59,91266.360.23
LOB table id lookup cache misses00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client1,988,0932,202.017.71
RowCR - row contention2760.310.00
RowCR attempts159,698176.880.62
RowCR hits156,900173.780.61
SMON posted for undo segment shrink260.030.00
SQL*Net roundtrips to/from client1,988,1122,202.047.71
active txn count during cleanout60,69067.220.24
application wait time2200.240.00
background checkpoints completed140.020.00
background checkpoints started140.020.00
background timeouts4,6995.200.02
branch node splits40.000.00
buffer is not pinned count285,236,508315,928.311,106.05
buffer is pinned count287,542,236318,482.141,114.99
bytes received via SQL*Net from client485,538,094537,782.601,882.75
bytes sent via SQL*Net to client1,076,635,5261,192,482.854,174.82
calls to get snapshot scn: kcmgss1,594,6521,766.246.18
calls to kcmgas349,201386.781.35
calls to kcmgcs1,018,8661,128.503.95
cell physical IO interconnect bytes11,859,735,55213,135,857.8745,987.93
change write time2,2002.440.01
cleanout - number of ktugct calls46,80051.840.18
cleanouts and rollbacks - consistent read gets33,59637.210.13
cleanouts only - consistent read gets9871.090.00
cluster key scan block gets3,8674.280.01
cluster key scans3,1643.500.01
commit batch/immediate performed330.040.00
commit batch/immediate requested330.040.00
commit cleanout failures: block lost100.010.00
commit cleanout failures: buffer being written390.040.00
commit cleanout failures: callback failure2270.250.00
commit cleanout failures: cannot pin7,5388.350.03
commit cleanouts1,058,9021,172.844.11
commit cleanouts successfully completed1,051,0881,164.194.08
commit immediate performed330.040.00
commit immediate requested330.040.00
commit txn count during cleanout72,20679.980.28
concurrency wait time1,1541.280.00
consistent changes173,518192.190.67
consistent gets581,211,846643,750.962,253.74
consistent gets - examination379,363,286420,183.251,471.04
consistent gets direct120.010.00
consistent gets from cache581,211,847643,750.972,253.74
consistent gets from cache (fastpath)201,512,179223,195.14781.39
cursor authentications470.050.00
data blocks consistent reads - undo records applied160,463177.730.62
db block changes3,564,9633,948.5613.82
db block gets4,822,1325,341.0018.70
db block gets direct600.070.00
db block gets from cache4,822,0725,340.9318.70
db block gets from cache (fastpath)1,653,6271,831.566.41
deferred (CURRENT) block cleanout applications371,815411.821.44
dirty buffers inspected363,770402.911.41
enqueue conversions5630.620.00
enqueue releases619,926686.632.40
enqueue requests619,934686.642.40
enqueue timeouts00.000.00
enqueue waits1,2661.400.00
execute count1,728,2681,914.236.70
file io service time00.000.00
file io wait time15,397,986,73217,054,829.2959,708.04
free buffer inspected865,517958.653.36
free buffer requested878,713973.263.41
heap block compress8650.960.00
hot buffers moved to head of LRU478,074529.521.85
immediate (CR) block cleanout applications34,58338.300.13
immediate (CURRENT) block cleanout applications40,59744.970.16
in call idle wait time2,555,4282,830.409.91
index crx upgrade (positioned)240.030.00
index fast full scans (full)20.000.00
index fetch by key94,692,078104,881.06367.18
index scans kdiixs194,436,438104,597.92366.19
leaf node 90-10 splits180.020.00
leaf node splits1,9582.170.01
lob reads00.000.00
lob writes1100.120.00
lob writes unaligned1100.120.00
logical read bytes from cache4,800,790,085,6325,317,361,079.8118,615,794.79
logons cumulative270.030.00
max cf enq hold time300.030.00
messages received288,184319.191.12
messages sent288,184319.191.12
min active SCN optimization applied on CR225,820250.120.88
no buffer to keep pinned count30.000.00
no work - consistent read gets200,598,432222,183.07777.85
non-idle wait count3,587,0743,973.0513.91
non-idle wait time986,1241,092.233.82
opened cursors cumulative1,727,5061,913.396.70
parse count (describe)70.010.00
parse count (failures)00.000.00
parse count (hard)3320.370.00
parse count (total)1,4371.590.01
parse time cpu3,1393.480.01
parse time elapsed4,3614.830.02
physical read IO requests773,429856.653.00
physical read bytes6,341,222,4007,023,545.8324,589.06
physical read total IO requests776,320859.853.01
physical read total bytes6,387,666,9447,074,987.8724,769.15
physical read total multi block requests20.000.00
physical reads774,075857.373.00
physical reads cache773,993857.283.00
physical reads cache prefetch6760.750.00
physical reads direct820.090.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests383,680424.961.49
physical write bytes4,275,765,2484,735,842.9216,579.93
physical write total IO requests876,098970.373.40
physical write total bytes5,472,060,4166,060,860.9321,218.75
physical write total multi block requests3620.400.00
physical writes521,944578.112.02
physical writes direct1300.140.00
physical writes direct (lob)130.010.00
physical writes direct temporary tablespace00.000.00
physical writes from cache521,814577.962.02
physical writes non checkpoint426,917472.851.66
pinned buffers inspected950.110.00
pinned cursors current50.010.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use20.000.00
process last non-idle time5200.580.00
recovery blocks read00.000.00
recursive calls289,598320.761.12
recursive cpu usage2,3602.610.01
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)296,116327.981.15
redo blocks read for recovery00.000.00
redo blocks written1,147,0451,270.474.45
redo buffer allocation retries4430.490.00
redo entries1,192,5361,320.854.62
redo k-bytes read for recovery00.000.00
redo log space requests4710.520.00
redo log space wait time1,8692.070.01
redo ordering marks11,15912.360.04
redo size498,530,952552,173.501,933.13
redo size for direct writes7800.860.00
redo subscn max counts28,53731.610.11
redo synch long waits8470.940.00
redo synch time26,96229.860.10
redo synch time (usec)269,626,508298,638.661,045.52
redo synch writes257,926285.681.00
redo wastage70,121,08477,666.20271.91
redo write time12,62113.980.05
redo writes242,728268.850.94
rollback changes - undo records applied1250.140.00
rollbacks only - consistent read gets41,58446.060.16
rows fetched via callback94,478,496104,644.50366.35
session connect time00.000.00
session cursor cache hits90,01599.700.35
session logical reads586,033,175649,091.072,272.43
shared hash latch upgrades - no wait428,124474.191.66
shared hash latch upgrades - wait540.060.00
sorts (memory)2,1062.330.01
sorts (rows)27,41730.370.11
sql area evicted3100.340.00
sql area purged00.000.00
summed dirty queue length3,184,8483,527.5412.35
switch current to new buffer7120.790.00
table fetch by rowid191,823,399212,463.84743.82
table fetch continued row1650.180.00
table scan blocks gotten8,684,6499,619.1333.68
table scan rows gotten310,139,845343,511.281,202.61
table scans (long tables)00.000.00
table scans (short tables)309,789343.121.20
temp space allocated (bytes)00.000.00
total cf enq hold time4,9305.460.02
total number of cf enq holders900.100.00
total number of times SMON posted410.050.00
transaction rollbacks320.040.00
undo change vector size164,305,732181,985.23637.12
user I/O wait time941,2891,042.573.65
user calls3,657,7164,051.2914.18
user commits257,888285.641.00
workarea executions - optimal1,0321.140.00
write clones created in foreground6700.740.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current5974
session uga memory max389,241,744438,292,728
session pga memory189,926,704226,155,536
session pga memory max346,674,448406,137,136
session cursor cache count3,4454,082
session uga memory47,278,308,06451,580,682,632
opened cursors current101132

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)1455.82

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 Reads5.9G858.176.709840M0.000M774.8K11.67
DBWR0M0.000M4G425.924.525650 
LGWR6M0.46.0066451.1G545.401.24715243.9K0.27
Others38M2.76.04208816M1.14.01772130044.22
Direct Writes0M0.000M1M0.05.0011070 
Streams AQ1M0.01.0011070M0.000M817.13
Direct Reads0M0.080M0M0.030M0 
TOTAL:6G861.486.759695.1G972.545.791641021.6K8.93

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 File5.9G858.276.709844G425.764.5234411.6710.50
Log File0M0.060M1.1G545.061.242729.79 
Control File44M3.14.04873421M1.47.0232594.86 
Temp File0M0.000M0M0.000M12.00 
TOTAL:6G861.476.758585.1G972.305.7894311.6410.50

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 5.9G858.706.714270M0.000M775.2K11.67
Buffer Cache Reads (Data File) 5.9G858.706.714270M0.000M775.2K11.67
DBWR 0M0.000M4G426.164.528980 
DBWR (Data File) 0M0.000M4G426.164.528980 
LGWR 6M0.46.0066451.1G545.691.247154694.24
LGWR (Log File) 0M0.060M1.1G545.351.242721124.89
LGWR (Control File) 6M0.40.0066454M0.34.0044303574.04
Others 39M2.76.04319616M1.14.01772124954.98
Others (Control File) 39M2.74.04319616M1.13.01772124784.98
Others (Data File) 0M0.020M0M0.010M176.06
Direct Writes 0M0.000M1M0.05.0011070 
Direct Writes (Data File) 0M0.000M1M0.05.0011070 
Streams AQ 1M0.01.0011070M0.000M817.13
Streams AQ (Data File) 1M0.01.0011070M0.000M817.13
Direct Reads 0M0.080M0M0.030M0 
Direct Reads (Data File) 0M0.080M0M0.030M0 
TOTAL: 6G862.016.765225.1G973.075.79496778.2K11.64

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SOE 769,58085212.111.00379,9764215,01210.30
UNDOTBS1 89010.671.002,81731130.27
SYSAUX 1,33316.881.24609100.00
SYSTEM 1,21419.321.27320632.38
USERS 1400.001.0014000.00
TEMP 2015.001.004000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SOE+DATA/dbm11203/datafile/soe.486.836957131 769,58085212.111.00379,9764215,01210.30
SYSAUX+DATA/dbm11203/datafile/sysaux.460.772715927 1,33316.881.24609100.00
SYSTEM+DATA/dbm11203/datafile/system.459.772715923 1,21419.321.27320632.38
TEMP+DATA/dbm11203/tempfile/temp.462.772715931 2015.001.00400 
UNDOTBS1+DATA/dbm11203/datafile/undotbs1.461.772715929 89010.671.002,81731130.27
USERS+DATA/dbm11203/datafile/users.463.772715939 1400.001.0014000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D89,362100582,128,444773,555521,818005,181

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
028,5440003,356

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
B01816165167866165888165888417367   
E01816018169373165888165888413717   

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
D720.109364.242,505,397123766393.00
D1440.2018276.051,898,816118012189.00
D2160.3027152.991,052,31919982087.00
D2880.40359.9468,3681648053.00
D3600.49441.429,753192020.00
D4320.59531.268,678181821.00
D5040.69621.168,011175497.00
D5760.79711.107,550171123.00
D6480.89801.047,186167671.00
D7200.99881.006,906165006.00
D7281.00891.006,878164749.00
D7921.09970.976,672162794.00
D8641.191060.946,474160909.00
D9361.291150.926,297159230.00
D1,0081.381240.896,133157681.00
D1,0801.481330.875,980156222.00
D1,1521.581410.855,848154977.00
D1,2241.681500.835,729153845.00
D1,2961.781590.815,559152232.00
D1,3681.881680.714,879145778.00
D1,4401.981770.624,241139734.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B1288184.920.000.000.000.0026,214
E1288217.020.000.000.000.0026,214

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K94794700
64K128K9900
128K256K3300
512K1024K555500
1M2M6600
4M8M4400

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
160.131,680.0631.6998.00112,814,750
320.251,680.0631.6998.00112,814,750
640.501,680.0631.6998.00112,814,750
960.751,680.0631.6998.00112,814,750
1281.001,680.060.00100.00112,762,644
1541.201,680.060.00100.0012,762,644
1791.401,680.060.00100.0002,762,644
2051.601,680.060.00100.0002,762,644
2301.801,680.060.00100.0002,762,644
2562.001,680.060.00100.0002,762,644
3843.001,680.060.00100.0002,762,644
5124.001,680.060.00100.0002,762,644
7686.001,680.060.00100.0002,762,644
1,0248.001,680.060.00100.0002,762,644

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)
2320.89221,53515,5160.978452.135,793
2360.91251,69015,5880.987731.955,795
2400.92281,86415,6930.986681.685,797
2440.94311,99715,7330.996281.585,797
2480.95352,15615,7830.995781.465,798
2520.97392,27015,8330.995281.335,799
2560.98422,30115,8971.004641.175,800
2601.00452,50115,9641.003971.005,804
2641.02492,66015,9671.003940.995,804
2681.03532,85115,9671.003940.995,804
2721.05562,95915,9691.003920.995,804
2761.06603,18815,9691.003920.995,804
2801.08643,39415,9701.003910.985,804
2841.09683,60015,9701.003910.985,804
2881.11723,80615,9701.003910.985,804
2921.12764,01215,9701.003910.985,804
2961.14804,27115,9701.003910.985,804
3161.22995,44515,9701.003910.985,804
3441.321266,32015,9711.003900.985,805
3721.431266,32915,9711.003900.985,805
4001.541266,32915,9711.003900.985,805
4281.651266,32915,9711.003900.985,805
4561.751266,32915,9711.003900.985,805
4841.861266,32915,9711.003900.985,805
5121.971266,32915,9711.003900.985,805
5402.081266,32915,9711.003900.985,805

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5120.5010,148,3651,079,936,247
7680.75101,2518,232,006
1,0241.0088,5906,856,577
1,2801.2583,1706,303,251
1,5361.5077,6345,712,900
1,7921.7564,9314,358,040
2,0482.0064,9314,358,040

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
40.500000
81.000000
121.500000
162.000000
202.500000
243.000000
283.500000
324.000000
364.500000
405.000000
445.500000
486.000000
526.500000
567.000000
607.500000
648.000000
688.500000
729.000000
769.500000
8010.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block5,0285210
segment header2204
3rd level bmb1104
2nd level bmb903
undo header4400
undo block6900
1st level bmb200

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 1,2361,23601,23021.80
TX-Transaction (index contention) 415415032015.00
HW-Segment High Water Mark 34634604027.50
TX-Transaction 260,161260,16201070.00
CU-Cursor 34934901010.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
226.58313,6109383119.6/29.60/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
23-Apr 19:4314,853175,77233631200/00/0/0/0/0/0
23-Apr 19:3311,722137,83893827300/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 latch20.00 00 
ASM Keyed state latch370.00 00 
ASM allocation1720.00 00 
ASM db client latch6980.00 00 
ASM map operation freelist701.430.0000 
ASM map operation hash table3,306,0490.000.0700 
ASM network background latch4530.00 00 
ASM network state latch2930.00 00 
AWR Alerted Metric Element list6,9890.00 00 
Change Notification Hash table latch3020.00 00 
Consistent RBA242,5810.000.6700 
DML lock allocation698,7260.010.0800 
Event Group Locks550.00 00 
FOB s.o list latch2700.00 00 
File State Object Pool Parent Latch20.00 00 
I/O Staticstics latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch1,391,6810.030.650257,9540.00
JS Sh mem access40.00 00 
JS mem alloc latch20.00 00 
JS queue access latch40.00 00 
JS queue state obj latch5,5020.00 00 
JS slv state obj latch60.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KFK SGA Libload latch2170.00 00 
KFMD SGA10.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch3020.00 00 
KTF sga latch50.00 03030.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status1170.00 00 
KWQS pqueue ctx latch20.00 00 
Locator state objects pool parent latch20.00 00 
Lsod array latch2660.00 00 
MQL Tracking Latch0  0180.00
Memory Management Latch20.00 03020.00
Memory Queue1200.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch100.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process1160.00 00 
OS process allocation1,8810.00 00 
OS process: request allocation370.00 00 
PL/SQL warning settings810.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch4960.00 00 
SGA IO buffer pool latch130.00 0130.00
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 02980.00
SQL memory manager workarea list latch20,3580.00 00 
Shared B-Tree7220.00 00 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch44,1200.00 00 
active service list1,8370.050.0002,2310.00
begin backup scn array150.00 00 
bq:time manger info latch320.00 00 
buffer pool20.00 00 
bufq statistics1180.00 00 
business card20.00 00 
cache buffer handles19,0070.110.0000 
cache buffers chains804,374,7240.190.000879,9730.02
cache buffers lru chain703,3900.060.0501,452,9090.11
cache table scan latch880.00 0880.00
call allocation1,0190.00 00 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch390.00 00 
channel operations parent latch6,9810.00 00 
checkpoint queue latch2,062,7800.010.010515,0510.01
client/application info1520.00 00 
compile environment latch270.00 00 
corrupted undo seg latch4070.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch1130.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch1130.00 00 
dml lock allocation1130.00 00 
done queue latch20.00 00 
dummy allocation410.00 00 
enqueue freelist latch20.00 019,9010.00
enqueue hash chains1,240,9570.040.06020.00
enqueues410.00 00 
fifth spare latch20.00 00 
file cache latch2350.00 00 
flashback copy20.00 00 
fourth Audit Vault latch20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA150.00 00 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch2920.00 012,2910.00
hash table modification latch20.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch30.00 010.00
job_queue_processes free list latch40.00 00 
job_queue_processes parameter latch1980.00 00 
k2q lock allocation20.00 00 
kcbtsemkid latch140.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kokc descriptor allocation latch80.00 00 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock200.00 00 
ksuosstats global area970.00 00 
ksv allocation latch1490.00 00 
ksv class latch8160.370.0000 
ksv instance latch40.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch370.00 00 
ktm global data1570.00 00 
kwqbsn:qsga5610.00 00 
lgwr LWN SCN244,2610.000.0000 
list of block allocation990.00 00 
loader state object freelist2380.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch40.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation30.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch2450.00 00 
messages852,9940.030.0100 
mostly latch-free SCN247,7880.390.0300 
msg queue latch20.00 00 
multiblock read objects3060.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch1130.00 00 
object queue header heap353,9810.00 01,8470.00
object queue header operation3,523,0230.030.0500 
object stats modification3370.00 00 
parallel query alloc buffer1220.00 00 
parallel query stats20.00 00 
parameter list1402.140.0000 
parameter table management860.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue373,2400.010.020258,7580.08
process allocation480.00 0260.00
process group creation370.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch8450.00 00 
query server freelists20.00 00 
queued dump request30.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation1,141,7120.090.0401,190,5150.39
redo copy20.00 01,192,2980.31
redo writing775,9920.010.0400 
resmgr group change latch175.880.0000 
resmgr:active threads410.00 00 
resmgr:actses change group270.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list390.00 00 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:schema config20.00 00 
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects55,2380.110.1306880.00
rules engine rule set statistics2000.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
sequence cache216,6250.040.0200 
session allocation257,9000.020.040257,8920.00
session idle bit7,568,1210.020.0400 
session queue latch20.00 00 
session state list latch660.00 00 
session switching1260.00 00 
session timer3630.00 00 
shared pool32,0270.170.2500 
shared pool sim alloc150.00 00 
shared pool simulator2,2480.00 00 
sim partition latch20.00 00 
simulator hash latch34,366,8490.010.0200 
simulator lru latch32,4551.270.02034,281,5001.38
sort extent pool1690.00 00 
space background state object latch40.00 00 
space background task latch1,5310.460.0006110.00
state object free list20.00 00 
statistics aggregation3360.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch380.00 00 
trace latch110.00 00 
transaction allocation1080.00 00 
undo global data1,411,9780.020.0200 
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains804,374,7241,488,1161,3551,486,761
simulator hash latch34,366,8494,3161004,217
session idle bit7,568,1211,281541,227
object queue header operation3,523,0231,146541,093
redo allocation1,141,7121,02244978
mostly latch-free SCN247,78895829929
enqueue hash chains1,240,95745928431
cache buffers lru chain703,39043223410
simulator lru latch32,4554139404
In memory undo latch1,391,681395257140
undo global data1,411,9782666260
messages852,9942533250
checkpoint queue latch2,062,7801241123
sequence cache216,62595293
DML lock allocation698,72684777
row cache objects55,23860852
session allocation257,90057255
shared pool32,027561450
post/wait queue373,24049148
redo writing775,99249247
ASM map operation hash table3,306,04914113
Consistent RBA242,581321

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation hash tablekffmDoDone_1010
DML lock allocationktaiam076
In memory undo latchktiFlush: child018577
In memory undo latchkticmt: child08235
In memory undo latchktichg: child011134
cache buffers chainskcbchg1: mod cr pin0334146
cache buffers chainskcbgtcr: fast path (cr pin)0287443
cache buffers chainskcbget: fast exchange026716
cache buffers chainskcbgtcr: kslbegin shared024265
cache buffers chainskcbgtcr: fast path0178556
cache buffers chainskcbgtcr_2016389
cache buffers chainskcbgtcr_10650
cache buffers chainskcbgcur_40594
cache buffers chainskcbgcur_204513
cache buffers chainskcbzgb: scan from tail. nowait0300
cache buffers chainskcbgtcr: kslbegin excl02835
cache buffers chainskcbrls: fast release025255
cache buffers chainskcbzwb02521
cache buffers chainskcbnew: new latch again0192
cache buffers chainskcbget: fast path091
cache buffers chainskcbnlc088
cache buffers chainskcbchg1: aux pin076
cache buffers chainskcbzib: finish processing buffer074
cache buffers chainskcbbic2061
cache buffers chainskcb_pre_apply: kcbhq61059
cache buffers chainskcb_post_apply: kcbhq62041
cache buffers chainskcbchg1: clear MS bit0313
cache buffers chainskcbzib: exchange rls038
cache buffers chainskcbzpbuf039
cache buffers chainskcbbic1024
cache buffers chainskcbget: release shr026
cache buffers chainskcbnew_1020
cache buffers chainskcbzibmlt: multi-block read: nowait020
cache buffers chainskcbget: pin buffer010
cache buffers chainskcbrls_20128
cache buffers lru chainkcbzgws0220
cache buffers lru chainkcbzgb010
checkpoint queue latchkcbklbc_cql010
enqueue hash chainsksqgtl301912
enqueue hash chainsksqrcl0815
enqueue hash chainsksqcmi: get hash chain latch after wait011
lgwr LWN SCNkcs0230150
messagesksaamb: after wakeup031
mostly latch-free SCNkcslcu301429
mostly latch-free SCNkcsnew_scn_rba020
object queue header operationkcbo_switch_cq01430
object queue header operationkcbo_switch_mq_bg0132
object queue header operationkcbo_unlink_q01317
object queue header operationkcbo_link_q0112
object queue header operationkcbo_check_flist033
object queue header operationkcbo_switch_q_bg022
post/wait queueksliwat:add:nowait010
redo allocationkcrfw_redo_gen: redo allocation 10390
redo allocationkcrf_pvt_strand_bind034
redo allocationkcrf_pvt_strand_unbind010
redo allocationkcrfw_redo_gen: redo allocation 2010
redo writingkcrfw_cal_target_rba010
redo writingkcrfwcr011
row cache objectskqreqd031
row cache objectskqreqd: reget030
row cache objectskqrpre: find obj012
row cache objectskqrso010
sequence cachekdnssd020
session allocationksucri_int : SSO010
session allocationksuxds012
session idle bitksupuc: set busy03522
session idle bitksupuc: clear busy01630
session idle bitksuxds032
shared poolkghalo0126
shared poolkghupr10213
simulator hash latchkcbsacc: lookup dba0100100
simulator lru latchkcbs_simulate: simulate set090
undo global dataktubnd_4020
undo global dataktudba: KSLBEGIN021
undo global dataktudnx:child022

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkkslce [KKSCHLPIN2]5,9010
Cursor Pinkksfbc [KKSCHLPIN1]820
Library Cachekglpin1 4760
Library Cachekglpndl1 95650
Library Cachekglhdgn2 106510
Library Cachekgllkc1 57330
Library Cachekglllal3 111320
Library Cachekglpnal1 90310
Cursor PinkksLockDelete [KKSCHLPIN6]200
Library Cachekgllkdl1 8580
Library Cachekglhdgn1 6270
Library Cachekgllkal3 8270
Library Cachekglget2 260
Library CachekglUpgradeLock 11940
Library Cachekglini1 3230
Library Cachekgllldl2 11230
Library Cachekglobld1 7510

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
SOESOEITEM_ORDER_IX INDEX188,119,18432.10
SOESOECUSTOMERS_PK INDEX187,892,78432.06
SOESOECUSTOMERS TABLE94,131,21616.06
SOESOEORDERS TABLE93,754,88016.00
SOESOEPRODUCT_INFORMATION TABLE9,718,8161.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SOESOECUSTOMERS TABLE148,56619.19
SOESOECUSTOMERS_PK INDEX140,24818.12
SOESOEORD_CUSTOMER_IX INDEX92,87412.00
SOESOEINVENTORIES TABLE81,65510.55
SOESOEITEM_ORDER_IX INDEX64,6848.36

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SOESOECUSTOMERS TABLE148,56319.21
SOESOECUSTOMERS_PK INDEX140,24918.13
SOESOEORD_CUSTOMER_IX INDEX92,87412.01
SOESOEINVENTORIES TABLE81,65510.56
SOESOEITEM_ORDER_IX INDEX64,6828.36

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SOESOECUSTOMERS TABLE148,56319.21
SOESOECUSTOMERS_PK INDEX140,24918.13
SOESOEORD_CUSTOMER_IX INDEX92,87412.01
SOESOEINVENTORIES TABLE81,65510.56
SOESOEITEM_ORDER_IX INDEX64,6828.36

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
SOESOEINVENTORIES TABLE104,69320.06
SOESOEITEM_PRODUCT_IX INDEX63,06412.08
SOESOEORDER_PK INDEX51,5879.88
SOESOEORD_CUSTOMER_IX INDEX50,0879.60
SOESOEORD_WAREHOUSE_IX INDEX46,4838.91

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SOESOEINVENTORIES TABLE68,21517.78
SOESOEORDER_PK INDEX50,13613.07
SOESOEORD_CUSTOMER_IX INDEX47,34812.34
SOESOEORDER_ITEMS_PK INDEX44,18411.52
SOESOEITEM_ORDER_IX INDEX42,96411.20

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_2532911053_1819TABLE PARTITION4736.15
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB129.23

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
SOESOEORDERS TABLE158,80015.44
SOESOEORD_WAREHOUSE_IX INDEX158,33615.39
SOESOEITEM_ORDER_IX INDEX129,29612.57
SOESOEORDER_ITEMS TABLE128,96012.54
SOESOEINVENTORIES TABLE106,59210.36

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SOESOEORDERS TABLE1,22774.68
SOESOEORD_ORDER_DATE_IX INDEX1448.76
SOESOEORD_WAREHOUSE_IX INDEX1046.33
SOESOEITEM_PRODUCT_IX INDEX794.81
SOESOECUST_ACCOUNT_MANAGER_IX INDEX221.34

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SOESOEORDERS TABLE52292.72
SOESOEORD_ORDER_DATE_IX INDEX132.31
SYSSYSTEMAUD$ TABLE61.07
SOESOEORDER_ITEMS TABLE50.89
SOESOEORDER_PK INDEX50.89

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control190.000 21
dc_global_oids535.660 024
dc_histogram_data2,76915.310 02,149
dc_histogram_defs5,38729.030 02,942
dc_object_grants250.000 010
dc_objects2,7597.290 11,264
dc_profiles170.000 01
dc_rollback_segments1,0680.000 078
dc_segments1,2538.700 15463
dc_sequences1442.860 147
dc_tablespaces2,7690.000 07
dc_users2,9600.710 022
global database name6290.000 01
outstanding_alerts80.000 04
sch_lj_oids20.000 01


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS303.330 00
BODY306.67595.0810
CLUSTER362.78362.7800
DBLINK313.230 00
EDITION230.00387.8900
INDEX156.67156.6700
QUEUE2660.002660.0000
SCHEMA1600.000 00
SQL AREA1,4708.911,728,7550.022110
SQL AREA BUILD35083.710 00
SQL AREA STATS30054.0030054.0000
TABLE/PROCEDURE1,4058.83147,4550.674680


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 cache728.00728.00728.00740.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target128.00128.00128.00128.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target1,024.001,024.001,024.001,024.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool4.004.004.004.000STA/
large pool8.008.000.008.000GRO/IMM
shared pool260.00260.00260.00260.000STA/
streams pool8.008.000.008.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther154.45 2.622.4114255959
Freeable25.380.000.790.421 3232
PL/SQL4.072.410.070.37345959
SQL1.050.130.030.03054137
EOther184.86 2.502.1714257474
Freeable26.190.000.790.431 3333
PL/SQL4.432.680.060.33347474
SQL1.570.110.030.03055551

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers763,363,328 
Fixed Size2,235,208 
Redo Buffers9,736,192 
Variable Size293,602,488 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory4.004.000.00
largeASM map operations hashta0.380.380.00
largePX msg pool3.713.710.00
largefree memory3.913.910.00
sharedASH buffers16.0016.000.00
sharedKCB Table Scan Buffer3.803.800.00
sharedKGLH018.4116.66-9.53
sharedKGLHD3.853.21-16.71
sharedKGLS4.884.890.37
sharedKGLSG5.025.020.00
sharedKKSSP2.783.5728.19
sharedKSFD SGA I/O b3.793.790.00
sharedPLMCD4.06 -100.00
sharedSQLA43.7021.74-50.25
shareddb_block_hash_buckets5.575.570.00
shareddbwriter coalesce buffer3.793.790.00
shareddirty object counts array4.004.000.00
sharedevent statistics per sess3.103.100.00
sharedfree memory65.8890.3537.13
sharedkglsim hash table bkts4.004.000.00
sharedksunfy : SSO free list2.892.890.00
sharedprivate strands3.513.510.00
sharedrow cache7.247.240.00
sharedwrite state object3.683.680.00
streamsfree memory7.997.990.00
 buffer_cache728.00728.000.00
 fixed_sga2.132.130.00
 log_buffer9.299.290.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0423 16:34:100.020.140.00
QMON Coordinator0423 16:34:000.000.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
SYS.SCHEDULER$_EVENT_QUEUE(12613) 00.0000.0000.00 

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
000000

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

No data exists for this section of the report.

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

No data exists for this section of the report.

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/u00/app/oracle/admin/DBM11203/adump  
audit_trailDB  
control_files+DATA/dbm11203/controlfile/current.455.772715921, +FRA/dbm11203/controlfile/current.332.772715921  
core_dump_dest/u00/app/oracle/diag/rdbms/dbm11203/DBM11203/cdump  
cursor_sharingEXACT  
db_block_size8192  
db_create_file_dest+DATA  
db_domainantognini.ch  
db_nameDBM11203  
db_recovery_file_dest+FRA  
db_recovery_file_dest_size2147483648  
diagnostic_dest/u00/app/oracle  
local_listener(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.101)(PORT=1521)))  
log_buffer8183808  
open_cursors30  
optimizer_dynamic_sampling2  
optimizer_modeALL_ROWS  
pga_aggregate_target134217728  
plsql_warningsDISABLE:ALL  
processes150  
query_rewrite_enabledTRUE  
remote_login_passwordfileEXCLUSIVE  
result_cache_max_size2031616  
sga_target1073741824  
skip_unusable_indexesTRUE  
undo_tablespaceUNDOTBS1  
user_dump_dest/u00/app/oracle/diag/rdbms/dbm11203/DBM11203/trace  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA/dbm11203/controlfile/current.455.772715921  
+FRA/dbm11203/controlfile/current.332.772715921  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report