WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
DB11G196335337DB11G105-Oct-10 12:1011.2.0.2.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
oel5-11gR2-demo.localdomainLinux x86 64-bit 1   1.96

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:7005-Oct-10 16:00:3941 4.8
End Snap:7105-Oct-10 17:00:0540 5.1
Elapsed:  59.42 (mins)  
DB Time:  25.37 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 188M 188MStd Block Size: 8K
Shared Pool Size: 288M 288MLog Buffer: 2,328K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.4 0.0 0.01 0.06
DB CPU(s): 0.2 0.0 0.00 0.03
Redo size: 20,366.3 2,072.8  
Logical reads: 543.2 55.3  
Block changes: 136.8 13.9  
Physical reads: 22.5 2.3  
Physical writes: 16.3 1.7  
User calls: 7.0 0.7  
Parses: 9.1 0.9  
Hard parses: 0.0 0.0  
W/A MB processed: 1.8 0.2  
Logons: 0.1 0.0  
Executes: 62.0 6.3  
Rollbacks: 0.0 0.0  
Transactions: 9.8   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 95.85In-memory Sort %: 100.00
Library Hit %: 99.99Soft Parse %: 99.94
Execute to Parse %: 85.34Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 48.26% Non-Parse CPU: 99.68

Shared Pool Statistics

BeginEnd
Memory Usage %: 80.23 80.55
% SQL with executions>1: 88.95 88.76
% Memory for SQL w/exec>1: 79.35 79.70

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 819 53.81 
log file sync11,585139129.15Commit
db file sequential read75,1115913.85User I/O
latch free67010150.64Other
latch: cache buffers lru chain4217170.46Other

Host CPU (CPUs: 1 Cores: Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
2.54 0.00 22.1 4.6 0.1 72.2
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
26.9 96.9 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 2,011.3 2,011.3
SGA use (MB): 524.0 524.0
PGA use (MB): 127.7 127.8
% Host Mem used for SGA+PGA: 32.40 32.41

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time1,278.6784.00
DB CPU819.0353.81
PL/SQL execution elapsed time446.7529.35
parse time elapsed5.040.33
repeated bind elapsed time0.030.00
sequence load elapsed time0.010.00
DB time1,522.15 
background elapsed time419.22 
background cpu time126.91 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME97,627 
IDLE_TIME253,770 
IOWAIT_TIME245 
NICE_TIME96 
SYS_TIME16,338 
USER_TIME77,535 
VM_IN_BYTES51,990,528 
VM_OUT_BYTES753,750,016 
PHYSICAL_MEMORY_BYTES2,109,009,920 
NUM_CPUS1 
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
05-Oct 16:00:392.54     
05-Oct 17:00:050.0027.7822.064.6572.220.07

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  819 53.81
Commit11,5850139129.15
User I/O75,83806013.93
Other1,9783519101.26
Concurrency839017201.11
Network24,2520300.20
Configuration700270.01
Application1000170.01
System I/O4590000.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
log file sync11,5850139120.339.15
db file sequential read75,11105912.143.85
latch free670010150.020.64
latch: cache buffers lru chain42107170.010.46
library cache: mutex X15106380.000.38
latch: cache buffers chains32505170.010.35
SQL*Net message to client24,2520300.690.20
latch: row cache objects20003150.010.20
latch: object queue header operation9401120.000.07
latch: In memory undo latch6301160.000.06
buffer busy waits6601140.000.06
latch: redo allocation6201130.000.05
cursor: pin S3101250.000.05
db file parallel read5130010.010.03
read by other session2100200.000.03
latch: enqueue hash chains2400150.000.02
Disk file operations I/O1120020.000.02
latch: redo copy700270.000.01
enq: TX - row lock contention1000170.000.01
db file scattered read810020.000.01
latch: session allocation800160.000.01
latch: messages500110.000.00
latch: shared pool200160.000.00
cursor: mutex S100100.000.00
control file sequential read4590000.010.00
asynch descriptor resize694100000.020.00
PL/SQL lock timer141,63810023,5481664.04 
jobq slave wait7,4941003,8455130.21 
SQL*Net message from client24,23803,8311580.69 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
os thread startup1370523810.0012.44
log file parallel write30,05204410.8610.61
db file async I/O submit16,82703720.488.76
control file parallel write1,5740320.040.64
db file sequential read1,0640220.030.43
LGWR wait for redo copy13302120.000.37
control file sequential read3,0380100.090.14
latch: redo allocation460080.000.09
latch: cache buffers lru chain2600130.000.08
db file scattered read1230010.000.04
latch free1200110.000.03
latch: object queue header operation800100.000.02
Disk file operations I/O700010.000.02
latch: redo writing200420.000.02
latch: cache buffers chains200350.000.02
reliable message500110.000.01
rdbms ipc reply70070.000.01
enq: PR - contention100460.000.01
latch: messages50050.000.01
asynch descriptor resize200100000.010.01
latch: shared pool100230.000.01
direct path sync100220.000.01
latch: checkpoint queue latch100210.000.01
ADR block file read150010.000.00
buffer busy waits40040.000.00
latch: enqueue hash chains10050.000.00
latch: call allocation10050.000.00
latch: In memory undo latch40010.000.00
db file single write120000.000.00
log file single write40000.000.00
ADR block file write50000.000.00
direct path write20010.000.00
rdbms ipc message46,8163642,4129061.34 
Streams AQ: waiting for time management or cleanup tasks5607,54015080090.00 
DIAG idle wait6,9671007,12010220.20 
Space Manager: slave idle wait1,401946,74348130.04 
dispatcher timer601003,601600110.00 
shared server idle wait1191003,572300190.00 
smon timer28213,5631272420.00 
pmon timer1,1841003,55930050.03 
Streams AQ: qmn coordinator idle wait254503,558140100.01 
Streams AQ: qmn slave idle wait13003,558273710.00 
class slave wait190000.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 read1586.76.7  6.7   
ADR block file write5100.0       
ADR file lock6100.0       
Disk file operations I/O18284.612.1.5.5.5.51.1 
LGWR wait for redo copy1318.45.319.115.330.518.33.1 
SQL*Net message to client24.2K99.3.1.1.2.3.0.0 
asynch descriptor resize90199.9.1      
buffer busy waits705.77.111.418.631.415.710.0 
control file parallel write157434.551.311.1.81.7.5.1 
control file sequential read350698.31.5.0.1.1.1  
cursor: mutex S1    100.0   
cursor: pin S3112.93.212.912.925.816.116.1 
db file async I/O submit16.8K90.12.5.61.21.82.11.7 
db file parallel read51393.42.9.21.8.61.2  
db file scattered read20487.77.81.5.5 1.51.0 
db file sequential read76.2K92.24.5.7.61.2.6.2 
db file single write12100.0       
direct path sync1     100.0  
direct path write2100.0       
enq: PR - contention1      100.0 
enq: TX - row lock contention10   30.010.060.0  
latch free6824.11.06.224.531.426.26.6 
latch: In memory undo latch6711.93.010.47.523.937.36.0 
latch: cache buffers chains3262.15.58.316.029.128.210.7 
latch: cache buffers lru chain4443.25.611.515.828.424.511.0 
latch: call allocation1   100.0    
latch: checkpoint queue latch1     100.0  
latch: enqueue hash chains25  8.028.048.08.08.0 
latch: messages10 10.020.030.030.010.0  
latch: object queue header operation1028.83.919.623.517.618.67.8 
latch: redo allocation1084.612.014.815.732.416.73.7 
latch: redo copy7  28.6 14.328.628.6 
latch: redo writing2   50.0  50.0 
latch: row cache objects2001.01.010.526.030.023.08.5 
latch: session allocation714.3  14.314.342.914.3 
latch: shared pool3   33.3 66.7  
library cache: mutex X1496.02.012.812.114.122.130.9 
log file parallel write30K48.037.811.11.01.6.4.0 
log file sequential read4100.0       
log file single write4100.0       
log file sync11.6K12.25.310.214.332.221.14.8 
os thread startup137      98.51.5
rdbms ipc reply742.914.314.3  28.6  
read by other session214.89.54.89.542.99.519.0 
reliable message5 20.020.0 20.040.0  
DIAG idle wait6967      90.79.3
PL/SQL lock timer141.5K      100.0 
SQL*Net message from client24.2K      100.0 
Space Manager: slave idle wait13991.2 .1  .21.397.1
Streams AQ: qmn coordinator idle wait254 14.618.54.32.87.12.850.0
Streams AQ: qmn slave idle wait1302.3      97.7
Streams AQ: waiting for time management or cleanup tasks540.0     20.040.0
class slave wait19100.0       
dispatcher timer60       100.0
jobq slave wait7490      100.0 
pmon timer1185       100.0
rdbms ipc message46.8K1.3.3.73.17.512.953.820.4
shared server idle wait119       100.0
smon timer287.1     17.975.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
Disk file operations I/O298.9.5 .5    
LGWR wait for redo copy496.93.1      
SQL*Net message to client3100.0.0.0     
buffer busy waits790.08.61.4     
control file parallel write299.9.1.1     
cursor: pin S583.912.9  3.2   
db file async I/O submit29198.31.2.5.0.0   
db file scattered read299.0.5.5     
db file sequential read19099.8.2.1.0    
enq: PR - contention1 100.0      
latch free4593.45.7.9     
latch: In memory undo latch494.06.0      
latch: cache buffers chains3589.39.51.2     
latch: cache buffers lru chain4989.09.01.6.5    
latch: enqueue hash chains292.08.0      
latch: object queue header operation892.27.8      
latch: redo allocation496.33.7      
latch: redo copy271.414.314.3     
latch: redo writing150.0 50.0     
latch: row cache objects1791.57.51.0     
latch: session allocation185.714.3      
library cache: mutex X4669.122.16.0.7.71.3  
log file parallel write10100.0.0.0     
log file sync55395.24.6.2.0    
os thread startup137  2.235.043.118.21.5 
read by other session481.09.59.5     

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)
DB11G.WORLD1,451779761,873
SYS$USERS7240247
DB11GXDB0000
SYS$BACKGROUND00317

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
DB11G.WORLD 74618598371700242523
SYS$USERS 11971200000
SYS$BACKGROUND 12682147520000

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
754.757,0940.1149.5856.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
310.428,4940.0420.3952.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
169.2721,3050.0111.1257.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
90.064,2640.025.9257.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
74.4719,1270.004.8952.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
58.8625,3880.003.8744.100.080y1prvxqc2ra9 Browse Products SELECT PRODUCTS.PRODUCT_ID, PR...
49.7719,9250.003.2761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
46.607,0870.013.0646.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
44.201,4380.032.9053.0922.81apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...
43.852,9140.022.8862.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
35.3821,0550.002.3245.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
30.857,0940.002.0344.820.055mddt5kt45rg3 New Order UPDATE ORDERS SET ORDER_MODE =...
26.374,2640.011.7352.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
24.4219,9250.001.6045.080.095raw2bzx227wp New Order INSERT INTO LOGON VALUES (:B2 ...
21.78580.381.4353.993.506gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
21.254,2640.001.4045.400.24f9u2k84v884y7 Process Orders UPDATE /*+ index(orders, order...
17.442,9140.011.1558.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...

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
423.507,0940.0651.71754.7556.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
163.538,4940.0219.97310.4252.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
97.6321,3050.0011.92169.2757.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
51.414,2640.016.2890.0657.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
39.3919,1270.004.8174.4752.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
30.5419,9250.003.7349.7761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
27.282,9140.013.3343.8562.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
25.9625,3880.003.1758.8644.100.080y1prvxqc2ra9 Browse Products SELECT PRODUCTS.PRODUCT_ID, PR...
23.471,4380.022.8744.2053.0922.81apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...
21.627,0870.002.6446.6046.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
16.0821,0550.001.9635.3845.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
13.834,2640.001.6926.3752.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
13.837,0940.001.6930.8544.820.055mddt5kt45rg3 New Order UPDATE ORDERS SET ORDER_MODE =...
11.76580.201.4421.7853.993.506gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
11.0119,9250.001.3424.4245.080.095raw2bzx227wp New Order INSERT INTO LOGON VALUES (:B2 ...
10.272,9140.001.2517.4458.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
9.654,2640.001.1821.2545.400.24f9u2k84v884y7 Process Orders UPDATE /*+ index(orders, order...

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
32.637,0940.0052.71754.7556.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
13.0119,1270.0021.0174.4752.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
12.2219,9250.0019.7449.7761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
10.081,4380.0116.2944.2053.0922.81apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...
7.194,2640.0011.6190.0657.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
7.144,2640.0011.5326.3752.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
6.8121,3050.0011.01169.2757.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
6.547,0870.0010.5746.6046.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
6.178,4940.009.97310.4252.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
4.941,4380.007.989.1939.7353.750ruh367af7gbw Browse and Update Orders SELECT ORDER_ID, ORDER_MODE, C...
2.674270.014.313.2138.9783.124tx09gq85z630 Browse and Update Orders SELECT ORDER_ID, LINE_ITEM_ID,...
2.562,9140.004.1443.8562.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
2.562,9140.004.1417.4458.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
1.1721,0550.001.8835.3845.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
0.794270.001.281.1852.5867.123hatpjzrqvfn7 Browse and Update Orders UPDATE ORDERS SET ORDER_TOTAL ...
0.76580.011.2321.7853.993.506gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

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
1,321,9467,094186.3568.26754.7556.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
599,78521,30528.1530.97169.2757.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
298,9488,49435.2015.44310.4252.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
293,80019,12715.3615.1774.4752.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
230,65125,3889.0911.9158.8644.100.080y1prvxqc2ra9 Browse Products SELECT PRODUCTS.PRODUCT_ID, PR...
143,0334,26433.547.3990.0657.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
120,54621,0555.736.2235.3845.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
108,4787,08715.315.6046.6046.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
81,7744,26419.184.2226.3752.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
81,2692,91427.894.2043.8562.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
79,70019,9254.004.1249.7761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
76,9226,81711.283.979.4753.230.437r7636982atn9 New Order UPDATE INVENTORIES SET QUANTIT...
60,41419,9253.033.1224.4245.080.095raw2bzx227wp New Order INSERT INTO LOGON VALUES (:B2 ...
57,5937,0948.122.9730.8544.820.055mddt5kt45rg3 New Order UPDATE ORDERS SET ORDER_MODE =...
56,9954,26413.372.9421.2545.400.24f9u2k84v884y7 Process Orders UPDATE /*+ index(orders, order...
54,9702,91418.862.8417.4458.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
27,62458476.281.4321.7853.993.506gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
23,9261,43816.641.2444.2053.0922.81apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
48,0977,0946.7859.84754.7556.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
27,66919,9251.3934.4249.7761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
15,08419,1270.7918.7774.4752.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
13,8968,4941.6417.29310.4252.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
11,67521,3050.5514.53169.2757.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
7,7257,0871.099.6146.6046.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
6,9951,4384.868.7044.2053.0922.81apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...
3,8564,2640.904.8090.0657.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
3,8094,2640.894.7426.3752.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
2,9771,4382.073.709.1939.7353.750ruh367af7gbw Browse and Update Orders SELECT ORDER_ID, ORDER_MODE, C...
2,5512,9140.883.1743.8562.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
2,5392,9140.873.1617.4458.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
1,94321,0550.092.4235.3845.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
1,5422771.001.920.8538.9514.39ab3swhv5g138y   select OBJOID, CLSOID, RUNTIME...
1,4965825.791.8621.7853.993.506gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
1,0095717.701.262.2555.2011.253am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
8584272.011.073.2138.9783.124tx09gq85z630 Browse and Update Orders SELECT ORDER_ID, LINE_ITEM_ID,...

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
48,09748,0977,0946.780.0061.770w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
27,66927,66919,9251.390.0035.548dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
15,08415,08419,1270.790.0019.370yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
13,89613,8968,4941.640.0017.85147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
11,67511,67521,3050.550.0014.99c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
7,7257,7257,0871.090.009.92gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
6,9956,9951,4384.860.008.98apgb2g9q2zjh1 JDBC Thin Client BEGIN :1 := orderentry.browsea...
3,8563,8564,2640.900.004.955yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
3,8093,8094,2640.890.004.895cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
2,9772,9771,4382.070.003.820ruh367af7gbw Browse and Update Orders SELECT ORDER_ID, ORDER_MODE, C...
2,5512,5512,9140.880.003.28dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...
2,5392,5392,9140.870.003.260bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
1,9431,94321,0550.090.002.508z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
9089085815.660.001.176gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
8588584272.010.001.104tx09gq85z630 Browse and Update Orders SELECT ORDER_ID, LINE_ITEM_ID,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
25,388355,43214.0058.8644.100.080y1prvxqc2ra9 Browse Products SELECT PRODUCTS.PRODUCT_ID, PR...
21,30596,3824.52169.2757.684.03c13sma6rkr27c New Order SELECT PRODUCTS.PRODUCT_ID, PR...
21,05519,1270.9135.3845.453.308z3542ffmp562 New Order SELECT QUANTITY_ON_HAND FROM P...
19,92519,9251.0024.4245.080.095raw2bzx227wp New Order INSERT INTO LOGON VALUES (:B2 ...
19,92519,9251.0049.7761.3624.558dq0v1mjngj7t Browse and Update Orders SELECT CUSTOMER_ID, CUST_FIRST...
19,92519,9251.0011.9048.380.00c749bc43qqfz3 New Order SELECT SYSDATE FROM DUAL
19,12719,1271.0074.4752.9017.470yas01u2p9ch4 New Order INSERT INTO ORDER_ITEMS(ORDER_...
8,4948,4941.00310.4252.681.99147a57cxq3w5y JDBC Thin Client BEGIN :1 := orderentry.browsep...
7,0947,0941.00754.7556.114.320w2qpuc6u2zsp JDBC Thin Client BEGIN :1 := orderentry.neworde...
7,0947,0941.0030.8544.820.055mddt5kt45rg3 New Order UPDATE ORDERS SET ORDER_MODE =...
7,0877,0871.0046.6046.3914.04gvgdv2v90wfa7 New Order INSERT INTO ORDERS(ORDER_ID, O...
6,81719,1412.819.4753.230.437r7636982atn9 New Order UPDATE INVENTORIES SET QUANTIT...
4,2644,2641.0026.3752.4327.075cnawuttguyja Process Orders WITH NEED_TO_PROCESS AS (SELEC...
4,2644,2641.0090.0657.097.985yq51dtyc6qf2 JDBC Thin Client BEGIN :1 := orderentry.process...
4,2644,2641.0021.2545.400.24f9u2k84v884y7 Process Orders UPDATE /*+ index(orders, order...
3,3294,7371.421.0429.870.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
2,9142,9141.0017.4458.8814.680bzhqhhj9mpaa New Customer INSERT INTO CUSTOMERS(CUSTOMER...
2,9142,9141.001.0767.420.004z3ktqk9zq1j9 New Customer SELECT CUSTOMER_SEQ.NEXTVAL FR...
2,9142,9141.0043.8562.215.85dcq9a12vtcnuw JDBC Thin Client BEGIN :1 := orderentry.newcust...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3,3293,32910.28cm5vu20fhtnq1   select /*+ connect_by_filterin...
2012010.62350f5yrnnmshs   lock table sys.mon_mods$ in ex...
2012010.62g00cj285jmgsw   update sys.mon_mods$ set inser...
1671670.5208bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1261260.39fsbqktj5vw6n9   select next_run_date, obj#, ru...
1243710.38089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
94940.293m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
92920.2849s332uhbnsma   declare vsn varchar2(20); beg...
88880.27f80h0xb1qvbsk   SELECT sys.wri$_adv_seq_msggro...
81810.253s58mgk0uy2ws   insert into wrm$_snapshot_deta...

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
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0bzhqhhj9mpaaINSERT INTO CUSTOMERS(CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
0ruh367af7gbwSELECT ORDER_ID, ORDER_MODE, CUSTOMER_ID, ORDER_STATUS, ORDER_TOTAL, SALES_REP_ID, PROMOTION_ID FROM ORDERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
0w2qpuc6u2zspBEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;
0y1prvxqc2ra9SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B2 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND ROWNUM < :B1
0yas01u2p9ch4INSERT INTO ORDER_ITEMS(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) VALUES (:B4 , :B3 , :B2 , :B1 , 1)
147a57cxq3w5yBEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3hatpjzrqvfn7UPDATE ORDERS SET ORDER_TOTAL = ORDER_TOTAL + :B2 WHERE ORDER_ID = :B1
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3s58mgk0uy2wsinsert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4tx09gq85z630SELECT ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY FROM ORDER_ITEMS WHERE ORDER_ID = :B2 AND ROWNUM < :B1
4z3ktqk9zq1j9SELECT CUSTOMER_SEQ.NEXTVAL FROM DUAL
5cnawuttguyjaWITH NEED_TO_PROCESS AS (SELECT ORDER_ID, CUSTOMER_ID FROM ORDERS WHERE ORDER_STATUS <= 4 AND ROWNUM < 10 ) SELECT O.ORDER_ID, OI.LINE_ITEM_ID, OI.PRODUCT_ID, OI.UNIT_PRICE, OI.QUANTITY, O.ORDER_MODE, O.ORDER_STATUS, O.ORDER_TOTAL, O.SALES_REP_ID, O.PROMOTION_ID, C.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME, C.CREDIT_LIMIT, C.CUST_EMAIL, O.ORDER_DATE FROM ORDERS O, NEED_TO_PROCESS NTP, CUSTOMERS C, ORDER_ITEMS OI WHERE NTP.ORDER_ID = O.ORDER_ID AND C.CUSTOMER_ID = O.CUSTOMER_ID AND OI.ORDER_ID (+) = O.ORDER_ID
5mddt5kt45rg3UPDATE ORDERS SET ORDER_MODE = 'online', ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(0, :B3 )), ORDER_TOTAL = :B2 WHERE ORDER_ID = :B1
5raw2bzx227wpINSERT INTO LOGON VALUES (:B2 , :B1 )
5yq51dtyc6qf2BEGIN :1 := orderentry.processorders(:2 , :3 ); END;
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7r7636982atn9UPDATE INVENTORIES SET QUANTITY_ON_HAND = QUANTITY_ON_HAND - :B1 WHERE PRODUCT_ID = :B3 AND WAREHOUSE_ID = :B2
8dq0v1mjngj7tSELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
8z3542ffmp562SELECT QUANTITY_ON_HAND FROM PRODUCT_INFORMATION P, INVENTORIES I WHERE I.PRODUCT_ID = :B2 AND I.PRODUCT_ID = P.PRODUCT_ID AND I.WAREHOUSE_ID = :B1
ab3swhv5g138y select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
apgb2g9q2zjh1BEGIN :1 := orderentry.browseandupdateorders(:2 , :3 , :4 ); END;
c13sma6rkr27cSELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHOUSE_ID = :B2 AND ROWNUM < :B1
c749bc43qqfz3SELECT SYSDATE FROM DUAL
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
dcq9a12vtcnuwBEGIN :1 := orderentry.newcustomer(:2 , :3 , :4 , :5 , :6 , :7 ); END;
f80h0xb1qvbskSELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
f9u2k84v884y7UPDATE /*+ index(orders, order_pk) */ ORDERS SET ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(:B3 + 1, :B2 )) WHERE ORDER_ID = :B1
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
gvgdv2v90wfa7INSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID) VALUES (ORDERS_SEQ.NEXTVAL , SYSTIMESTAMP , :B1 ) RETURNING ORDER_ID INTO :O0

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count2,0020.560.06
Batched IO buffer defrag count00.000.00
Batched IO double miss count1,0660.300.03
Batched IO same unit count00.000.00
Batched IO single block count5530.160.02
Batched IO vector block count1,4490.410.04
Batched IO vector read count5130.140.01
Block Cleanout Optim referenced830.020.00
CCursor + sql area evicted00.000.00
CPU used by this session75,41021.152.15
CPU used when call started72,61020.372.07
CR blocks created4,7341.330.14
Cached Commit SCN referenced1800.050.01
Commit SCN cached3910.110.01
DB time2,892,552811.3182.57
DBWR checkpoint buffers written23,7986.670.68
DBWR checkpoints20.000.00
DBWR parallel query checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes1460.040.00
DBWR undo block writes3,6521.020.10
DDL statements parallelized00.000.00
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes86,82424.352.48
Heap Segment Array Inserts1750.050.00
Heap Segment Array Updates1100.030.00
IMU CR rollbacks4010.110.01
IMU Flushes8,4982.380.24
IMU Redo allocation size21,159,9245,935.01604.05
IMU commits26,5307.440.76
IMU contention6,8231.910.19
IMU ktichg flush10.000.00
IMU pool not allocated1100.030.00
IMU undo allocation size48,311,69613,550.631,379.15
IMU- failed to get a private strand1100.030.00
Number of read IOs issued00.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations not downgraded00.000.00
RowCR - row contention4370.120.01
RowCR attempts12,0443.380.34
RowCR hits11,5913.250.33
SMON posted for undo segment shrink50.000.00
SQL*Net roundtrips to/from client24,2456.800.69
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created60.000.00
TBS Extension: tasks executed60.000.00
active txn count during cleanout6,3291.780.18
application wait time160.000.00
background checkpoints completed20.000.00
background checkpoints started20.000.00
background timeouts16,9954.770.49
branch node splits20.000.00
buffer is not pinned count857,538240.5324.48
buffer is pinned count840,664235.7924.00
bytes received via SQL*Net from client1,744,339489.2649.80
bytes sent via SQL*Net to client3,424,499960.5297.76
calls to get snapshot scn: kcmgss203,44657.065.81
calls to kcmgas40,79811.441.16
calls to kcmgcs3,6791.030.11
cell physical IO interconnect bytes1,326,731,776372,126.2837,874.16
change write time3,9511.110.11
cleanout - number of ktugct calls3,4200.960.10
cleanouts and rollbacks - consistent read gets2,0240.570.06
cleanouts only - consistent read gets180.010.00
cluster key scan block gets2,3270.650.07
cluster key scans2,0690.580.06
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed580.020.00
commit batch/immediate requested580.020.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written10.000.00
commit cleanout failures: callback failure170.000.00
commit cleanout failures: cannot pin1,4500.410.04
commit cleanouts148,52741.664.24
commit cleanouts successfully completed147,05941.254.20
commit immediate performed580.020.00
commit immediate requested580.020.00
commit nowait performed00.000.00
commit nowait requested00.000.00
commit txn count during cleanout2,8150.790.08
commit wait/nowait performed00.000.00
commit wait/nowait requested00.000.00
concurrency wait time6,9141.940.20
consistent changes5,9801.680.17
consistent gets1,271,075356.5236.29
consistent gets - examination891,272249.9925.44
consistent gets direct10.000.00
consistent gets from cache1,271,074356.5236.29
consistent gets from cache (fastpath)356,18199.9010.17
cursor authentications380.010.00
data blocks consistent reads - undo records applied5,6441.580.16
db block changes487,584136.7613.92
db block gets665,518186.6719.00
db block gets direct60.000.00
db block gets from cache665,512186.6719.00
db block gets from cache (fastpath)158,81244.544.53
deferred (CURRENT) block cleanout applications58,79316.491.68
dirty buffers inspected27,7437.780.79
enqueue conversions7440.210.02
enqueue releases133,03237.313.80
enqueue requests133,07937.333.80
enqueue timeouts10.000.00
enqueue waits110.000.00
execute count220,92261.966.31
failed probes on index block reclamation10.000.00
file io service time3980.110.01
file io wait time96,826,29227,158.172,764.10
free buffer inspected100,68228.242.87
free buffer requested89,65125.152.56
heap block compress1600.040.00
hot buffers moved to head of LRU79,06622.182.26
immediate (CR) block cleanout applications2,0420.570.06
immediate (CURRENT) block cleanout applications6,4961.820.19
index crx upgrade (positioned)80.000.00
index fast full scans (direct read)00.000.00
index fast full scans (full)50.000.00
index fast full scans (rowid ranges)00.000.00
index fetch by key268,00675.177.65
index scans kdiixs167,14518.831.92
leaf node 90-10 splits410.010.00
leaf node splits4440.120.01
lob reads00.000.00
lob writes770.020.00
lob writes unaligned770.020.00
logons cumulative2030.060.01
max cf enq hold time00.000.00
messages received46,92513.161.34
messages sent46,92513.161.34
min active SCN optimization applied on CR130.000.00
no buffer to keep pinned count00.000.00
no work - consistent read gets361,558101.4110.32
non-idle wait count180,44550.615.15
non-idle wait time38,07110.681.09
opened cursors cumulative230,16864.566.57
parse count (describe)60.000.00
parse count (failures)00.000.00
parse count (hard)190.010.00
parse count (total)32,3859.080.92
parse time cpu2640.070.01
parse time elapsed5470.150.02
physical read IO requests77,86121.842.22
physical read bytes658,448,384184,683.8618,796.70
physical read total IO requests81,38922.832.32
physical read total bytes716,040,192200,837.4120,440.77
physical read total multi block requests260.010.00
physical reads80,37722.542.29
physical reads cache80,37622.542.29
physical reads cache prefetch3,4520.970.10
physical reads direct10.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests44,05212.361.26
physical write bytes475,045,888133,242.5013,561.12
physical write total IO requests77,29321.682.21
physical write total bytes610,691,584171,288.8717,433.39
physical write total multi block requests1640.050.00
physical writes57,98916.261.66
physical writes direct60.000.00
physical writes direct (lob)10.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache57,98316.261.66
physical writes non checkpoint40,85911.461.17
pinned buffers inspected00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time8,1322.280.23
queries parallelized00.000.00
recursive calls381,105106.8910.88
recursive cpu usage40,77511.441.16
redo blocks checksummed by FG (exclusive)35,3179.911.01
redo blocks written163,99746.004.68
redo buffer allocation retries00.000.00
redo entries190,02453.305.42
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks00.000.00
redo size72,611,23620,366.252,072.83
redo size for direct writes1480.040.00
redo synch long waits1,7370.490.05
redo synch time14,0203.930.40
redo synch time (usec)140,200,78539,324.004,002.31
redo synch writes24,3156.820.69
redo wastage9,018,8802,529.65257.46
redo write time4,7341.330.14
redo writes30,0478.430.86
rollback changes - undo records applied580.020.00
rollbacks only - consistent read gets1030.030.00
rows fetched via callback173,67848.714.96
session connect time00.000.00
session cursor cache hits227,47963.806.49
session logical reads1,936,593543.1855.28
shared hash latch upgrades - no wait56,81515.941.62
shared hash latch upgrades - wait180.010.00
sorts (disk)00.000.00
sorts (memory)9,9392.790.28
sorts (rows)29,4258.250.84
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length35,72410.021.02
switch current to new buffer1370.040.00
table fetch by rowid680,284190.8119.42
table fetch continued row00.000.00
table scan blocks gotten4,0401.130.12
table scan rows gotten296,24283.098.46
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)1,4730.410.04
total cf enq hold time6700.190.02
total number of cf enq holders1130.030.00
total number of times SMON posted230.010.00
transaction rollbacks580.020.00
undo change vector size23,981,7686,726.49684.61
user I/O wait time6,2471.750.18
user calls24,8416.970.71
user commits35,0309.831.00
workarea executions - onepass00.000.00
workarea executions - optimal12,8323.600.37
write clones created in background00.000.00
write clones created in foreground160.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory max2,469,805,7602,634,948,776
session pga memory583,259,336727,967,648
session pga memory max777,442,504931,325,856
session cursor cache count12,64815,907
session uga memory953,553,982,6081,237,033,246,280
opened cursors current196202
workarea memory allocated01,347
logons current4140

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)22.02

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 Reads626M21.81.1755820M0.000M77.3K0.52
DBWR0M0.000M452M12.30.12677816.8K1.75
Others54M0.98.01514649M0.88.01374366050.58
LGWR0M0.010M80M8.44.02243860.1K0.96
Direct Writes0M0.000M0M0.000M20.00
Streams AQ0M0.000M0M0.000M172.18
TOTAL:680M22.81.190728581M21.61.162960160.9K0.81

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 File627M21.82.175863451M12.30.1264980.512.00
Control File54M0.98.01514649M0.88.0137430.04 
Log File0M0.000M80M8.43.0224380.00 
Temp File0M0.000M0M0.000M0.00 
TOTAL:681M22.81.191009580M21.61.1626800.492.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 626M21.81.1755820M0.000M76.3K0.52
Buffer Cache Reads (Data File) 626M21.81.1755820M0.000M76.3K0.52
DBWR 0M0.000M452M12.30.1267780 
DBWR (Data File) 0M0.000M452M12.30.1267780 
Others 54M0.98.01514649M0.88.01374334970.04
Others (Control File) 54M0.97.01514649M0.87.01374334660.04
Others (Data File) 0M0.010M0M0.000M310.29
LGWR 0M0.010M80M8.44.022438480.00
LGWR (Log File) 0M0.000M80M8.43.02243880.00
LGWR (Control File) 0M0.010M0M0.010M400.00
Streams AQ 0M0.000M0M0.000M172.18
Streams AQ (Data File) 0M0.000M0M0.000M172.18
Direct Writes 0M0.000M0M0.000M0 
Direct Writes (Data File) 0M0.000M0M0.000M0 
TOTAL: 680M22.81.190728581M21.61.16296079.9K0.50

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SWINGBENCH 75,531210.771.0042,745127214.58
SYSAUX 1,51901.281.18736000.00
SYSTEM 69400.974.2457000.00
UNDOTBS1 400.001.0051301918.95
TEMP 400.001.000000.00
EXAMPLE 100.001.000000.00
USERS 100.001.000000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EXAMPLE/u01/app/oracle/oradata/DB11G/example01.dbf 100.001.000000.00
SWINGBENCH/u01/app/oracle/product/11.2.0.2/db_1/dbs/soe.dbf 75,531210.771.0042,745127214.58
SYSAUX/u01/app/oracle/oradata/DB11G/sysaux01.dbf 1,51901.281.18736000.00
SYSTEM/u01/app/oracle/oradata/DB11G/system01.dbf 69400.974.2457000.00
TEMP/u01/app/oracle/oradata/DB11G/temp01.dbf 400.001.00000 
UNDOTBS1/u01/app/oracle/oradata/DB11G/undotbs01.dbf 400.001.0051301918.95
USERS/u01/app/oracle/oradata/DB11G/users01.dbf 100.001.000000.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
D23,077961,936,61280,37657,9830091

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000023,7980

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
B023447029931157722165888157722   
E020110231501810216588818102   

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
D160.0923.1397612306.00
D320.1742.6582611946.00
D480.2662.2169011619.00
D640.3481.9260011402.00
D800.43101.6852511221.00
D960.51121.5046811084.00
D1120.60141.364241981.00
D1280.68161.253901898.00
D1440.77181.163621831.00
D1600.85201.093401778.00
D1760.94221.033231736.00
D1881.00231.003121710.00
D1921.02240.993091702.00
D2081.11260.952971674.00
D2241.19270.922881652.00
D2401.28290.902811636.00
D2561.36310.882741620.00
D2721.45330.862681605.00
D2881.53350.852641596.00
D3041.62370.842611588.00
D3201.70390.832581581.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.006,5050

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
2K4K3,6773,67700
64K128K8800
256K512K2200
512K1024K9,1379,13700
1M2M5500
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
350.1326,784.609,788.7073.00809,324,596
700.2526,784.604,335.6386.00627,934,301
1400.5026,784.602,380.3192.0007,435,779
2100.7526,784.602,380.3192.0007,435,779
2801.0026,784.602,380.3192.0007,435,779
3361.2026,784.601,600.6694.0007,237,004
3921.4026,784.601,297.6295.0007,159,740
4481.6026,784.601,133.9896.0007,118,020
5041.8026,784.601,133.9896.0007,118,020
5602.0026,784.601,133.9896.0007,118,020
8403.0026,784.601,133.9896.0007,118,020
1,1204.0026,784.601,133.9896.0007,118,020
1,6806.0026,784.601,133.9896.0007,118,020
2,2408.0026,784.601,133.9896.0007,118,020

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)
1600.56302,23532,9820.992812.81619
1920.67624,01233,1191.001441.44650
2240.78945,89633,1611.001021.02650
2560.891086,81533,1631.001001.00650
2881.001096,85233,1631.001001.00650
3201.111096,85233,1631.001001.00650
3521.221096,85233,1631.001001.00650
3841.331096,85233,1631.001001.00650
4161.441096,85233,1631.001001.00650
4481.561096,85233,1631.001001.00650
4801.671096,85233,1631.001001.00650
5121.781096,85233,1631.001001.00650
5441.891096,85233,1631.001001.00650
5762.001096,85233,1631.001001.00650

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2620.508,336619,354
3930.757,673367,986
5241.007,517311,562
6551.257,502304,365
7861.507,502304,365
9171.757,502304,365
1,0482.007,502304,365

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 block72115
undo header16017
undo block3030

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) 1010010018.00
PR-Process Startup 13713701040.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
24.0843,6391,1361119.5/310/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
05-Oct 16:5215681,1363310/00/0/0/0/0/0
05-Oct 16:4218905281220/00/0/0/0/0/0
05-Oct 16:328309,85998910300/00/0/0/0/0/0
05-Oct 16:2298911,19838611190/00/0/0/0/0/0
05-Oct 16:121,01311,17799211300/00/0/0/0/0/0
05-Oct 16:021,21611,24739011200/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 latch220.00 00 
AQ dequeue txn counter latch40.00 00 
AQ disk delete txn counter latch40.00 00 
ASM db client latch2,3800.00 00 
ASM map operation hash table20.00 00 
ASM network state latch560.00 00 
AWR Alerted Metric Element list25,7500.00 00 
Change Notification Hash table latch1,1810.00 00 
Consistent RBA30,0530.00 00 
DML lock allocation135,0310.001.0000 
Event Group Locks1390.00 00 
FOB s.o list latch3670.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 latch209,3260.031.00135,9100.00
JS Sh mem access80.00 00 
JS mem alloc latch60.00 00 
JS queue access latch80.00 00 
JS queue state obj latch25,4500.00 00 
JS slv state obj latch2380.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.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 latch1,1820.00 00 
KTF sga latch210.00 01,1470.00
KWQMN job cache list latch110.00 00 
KWQP Prop Status30.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch810.00 00 
Locator state objects pool parent latch20.00 00 
Lsod array latch20.00 00 
MQL Tracking Latch0  0700.00
Memory Management Latch20.00 01,1820.00
Memory Queue20.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 Latch380.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process1,2380.00 00 
OS process allocation7,4950.00 00 
OS process: request allocation2750.00 00 
PL/SQL warning settings3840.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch8260.00 00 
SGA IO buffer pool latch150.00 0150.00
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch1200.00 01,1800.00
SQL memory manager workarea list latch122,9830.00 00 
Shared B-Tree3590.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 latch18,0120.00 00 
active service list7,9220.00 01,7400.00
begin backup scn array20.00 00 
buffer pool20.00 00 
business card20.00 00 
cache buffer handles1,4560.00 00 
cache buffers chains4,862,5660.020.42593,8080.01
cache buffers lru chain149,0420.301.01763,8300.20
cache table scan latch2040.00 02040.00
call allocation1,0820.091.0000 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch2930.00 00 
channel operations parent latch19,7850.00 00 
checkpoint queue latch138,1790.001.00049,7220.02
client/application info902,2940.071.00100 
compile environment latch2030.00 00 
corrupted undo seg latch2320.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch560.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch560.00 00 
dml lock allocation560.00 00 
done queue latch20.00 00 
dummy allocation4090.00 00 
enqueue hash chains266,8720.011.0000 
enqueues59,0350.00 00 
fifth spare latch20.00 00 
file cache latch1750.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 tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch240.00 04,3190.00
hash table modification latch1300.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch80.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch690.00 0672.99
job_queue_processes free list latch1380.00 00 
job_queue_processes parameter latch8280.00 00 
k2q lock allocation20.00 00 
kcbtsemkid latch20.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kokc descriptor allocation latch3760.00 00 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock400.00 00 
ksuosstats global area2440.00 00 
ksv allocation latch1330.00 00 
ksv class latch800.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch2750.00 00 
ktm global data1130.00 00 
kwqbsn:qsga1320.00 00 
lgwr LWN SCN30,4260.00 00 
list of block allocation2010.00 00 
loader state object freelist80.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch140.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 latch290.00 00 
messages157,9850.011.0000 
mostly latch-free SCN30,4260.00 00 
msg queue latch20.00 00 
multiblock read objects1,4440.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch560.00 00 
object queue header heap18,6430.00 05730.00
object queue header operation358,9540.031.0110 
object stats modification550.00 00 
parallel query alloc buffer4740.00 00 
parallel query stats20.00 00 
parameter list1800.00 00 
parameter table management9610.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue17,1370.00 011,5960.00
process allocation4120.00 01370.00
process group creation2750.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch5200.191.0000 
query server freelists20.00 00 
queued dump request120.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation132,4580.081.001189,9690.07
redo copy1504.671.000189,8840.15
redo writing110,6550.001.0000 
resmgr group change latch268,2980.00 00 
resmgr:active threads4090.00 00 
resmgr:actses change group880.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list4070.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 objects613,4530.031.0030 
rules engine aggregate statistics10.00 00 
rules engine rule set statistics2020.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
sequence cache30,5840.011.0000 
session allocation118,9110.011.0000 
session idle bit108,7730.00 00 
session queue latch20.00 00 
session state list latch4650.00 00 
session switching7480.00 00 
session timer1,1840.00 00 
shared pool21,8140.011.0000 
shared pool sim alloc40.00 00 
shared pool simulator700.00 00 
sim partition latch20.00 00 
simulator hash latch115,6440.001.0000 
simulator lru latch5,3470.041.000104,8670.38
sort extent pool1080.00 00 
space background state object latch90.00 00 
space background task latch4,0630.221.1102,3710.00
state object free list20.00 00 
statistics aggregation5600.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 latch1430.00 00 
transaction allocation9100.00 00 
undo global data193,6150.00 00 
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 chains4,862,566779327452
client/application info902,2946656660
cache buffers lru chain149,0424494552
row cache objects613,4532002000
redo allocation132,4581081080
object queue header operation358,9541021030
In memory undo latch209,32667670
enqueue hash chains266,87225250
messages157,98510100
space background task latch4,0639100
redo copy150770
session allocation118,911770
shared pool21,814330
DML lock allocation135,031220
redo writing110,655220
sequence cache30,584220
simulator lru latch5,347220
call allocation1,082110
checkpoint queue latch138,179110
qmn task queue latch520110
simulator hash latch115,644110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam011
DML lock allocationktaidm011
In memory undo latchktiFlush: child03461
In memory undo latchkticmt: child0251
In memory undo latchktichg: child073
In memory undo latchktiFlushMe010
cache buffers chainskcbgtcr: fast path (cr pin)011025
cache buffers chainskcbgtcr: fast path09751
cache buffers chainskcbgcur: fast path (shr)0606
cache buffers chainskcbget: pin buffer02074
cache buffers chainskcbgtcr: kslbegin shared0112
cache buffers chainskcbgcur_201015
cache buffers chainskcbchg1: kslbegin: bufs not pinned071
cache buffers chainskcbnlc063
cache buffers chainskcbget: exchange0151
cache buffers chainskcbnew: new latch again010
cache buffers chainskcbrls_10166
cache buffers chainskcbzgb: scan from tail. nowait010
cache buffers chainskcbzibmlt: multi-block read: nowait010
cache buffers chainskcbzwb010
cache buffers lru chainkcbzgws_10437436
cache buffers lru chainkcbbxsv: move to being written0100
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_2040
cache buffers lru chainkcbzgb021
cache buffers lru chainkcbbic20118
cache buffers lru chainkcbzswcu010
call allocationksudlp: top call010
checkpoint queue latchkcbklbc_cql010
client/application infoksuinfos_modact0416563
client/application infokskirefrattrmap0250103
enqueue hash chainsksqrcl0170
enqueue hash chainsksqgtl30825
messagesksaamb: after wakeup075
messagesksarcv031
object queue header operationkcbo_switch_cq04639
object queue header operationkcbo_unlink_q02150
object queue header operationkcbo_link_q0167
object queue header operationkcbo_switch_q_bg0130
object queue header operationkcbo_switch_mq_bg075
qmn task queue latchkwqmnmvtsks: delay to ready list010
redo allocationkcrfw_redo_gen: redo allocation 10940
redo allocationkcrfw_post: more space0102
redo allocationkcrfw_redo_gen: redo allocation 30263
redo allocationkcrfw_redo_write: before write0243
redo copykcrfw_redo_gen: nowait070
redo writingkcrfw_cal_target_rba011
redo writingkcrfwcr010
row cache objectskqreqd: reget01800
row cache objectskqrpre: find obj017199
row cache objectskqreqd031
sequence cachekdnssd020
session allocationksucri_int : SSO046
session allocationksuxds031
shared poolkghalo021
shared poolkghfre012
simulator hash latchkcbs_lookup_setid: lookup dba010
simulator lru latchkcbs_simulate: simulate set020
space background task latchktsjCreateTask060
space background task latchktsj_grab_task0410

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpndl1 95551,422
Library Cachekglpin1 4533,257
Cursor Pinkksfbc [KKSCHLFSP2]31775
Library Cachekglhdgn2 10625676
Library Cachekglget1 110278
Library Cachekglobpn1 716107
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]110

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
SOESWINGBENCHINVENTORY_PK INDEX377,61619.50
SOESWINGBENCHINVENTORIES TABLE163,2488.43
SOESWINGBENCHPRD_DESC_PK INDEX137,5687.10
SOESWINGBENCHPRODUCT_INFORMATION_PK INDEX127,8726.60
SOESWINGBENCHORDER_PK INDEX126,4966.53

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SOESWINGBENCHCUSTOMERS TABLE17,19621.39
SOESWINGBENCHCUSTOMERS_PK INDEX14,63218.20
SOESWINGBENCHINVENTORIES TABLE13,69017.03
SOESWINGBENCHORDER_ITEMS_PK INDEX8,65810.77
SOESWINGBENCHORD_CUSTOMER_IX INDEX8,14510.13

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SOESWINGBENCHCUSTOMERS TABLE17,19622.09
SOESWINGBENCHCUSTOMERS_PK INDEX14,63218.79
SOESWINGBENCHINVENTORIES TABLE13,69017.58
SOESWINGBENCHORDER_ITEMS_PK INDEX8,65811.12
SOESWINGBENCHORD_CUSTOMER_IX INDEX8,14510.46

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SOESWINGBENCHCUSTOMERS TABLE17,19622.09
SOESWINGBENCHCUSTOMERS_PK INDEX14,63218.79
SOESWINGBENCHINVENTORIES TABLE13,69017.58
SOESWINGBENCHORDER_ITEMS_PK INDEX8,65811.12
SOESWINGBENCHORD_CUSTOMER_IX INDEX8,14510.46

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
SOESWINGBENCHINVENTORIES TABLE16,95429.24
SOESWINGBENCHORD_CUSTOMER_IX INDEX7,17512.37
SOESWINGBENCHORDER_ITEMS_PK INDEX7,06012.17
SOESWINGBENCHITEM_ORDER_IX INDEX7,01712.10
SOESWINGBENCHITEM_PRODUCT_IX INDEX6,21710.72

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SOESWINGBENCHINVENTORIES TABLE12,07927.42
SOESWINGBENCHORDER_ITEMS_PK INDEX7,06016.03
SOESWINGBENCHITEM_ORDER_IX INDEX7,01715.93
SOESWINGBENCHORD_CUSTOMER_IX INDEX6,77015.37
SOESWINGBENCHITEM_PRODUCT_IX INDEX4,68310.63

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_196335337_58TABLE PARTITION583.33

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX480.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SOESWINGBENCHORDER_ITEMS TABLE21,76016.50
SOESWINGBENCHITEM_PRODUCT_IX INDEX21,26416.12
SOESWINGBENCHINVENTORIES TABLE19,55214.82
SOESWINGBENCHORDER_ITEMS_PK INDEX19,20014.56
SOESWINGBENCHITEM_ORDER_IX INDEX18,92814.35

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SOESWINGBENCHCUST_EMAIL_IX INDEX1520.00
SOESWINGBENCHCUST_ACCOUNT_MANAGER_IX INDEX1216.00
SOESWINGBENCHORD_STATUS_IX INDEX1216.00
SOESWINGBENCHORDERS TABLE1013.33
SOESWINGBENCHORDER_PK INDEX912.00

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
SOESWINGBENCHORDER_PK INDEX2243.14
SOESWINGBENCHLOGON TABLE1325.49
SOESWINGBENCHORDERS TABLE815.69
SOESWINGBENCHORDER_ITEMS TABLE611.76
SOESWINGBENCHORD_STATUS_IX INDEX23.92

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_files60.000 06
dc_global_oids48,8510.000 076
dc_histogram_data6220.000 02,138
dc_histogram_defs8380.000 05,633
dc_objects49,8540.000 53,049
dc_profiles690.000 01
dc_rollback_segments8490.000 022
dc_segments820.000 21976
dc_sequences100.000 1017
dc_tablespaces22,6450.000 09
dc_users78,5050.000 0311
global database name2,4440.000 01
outstanding_alerts323.130 17
sch_lj_oids50.000 09


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1,0560.00106,9220.0000
CLUSTER30.0030.0000
DBLINK20.000 00
EDITION820.001490.0000
INDEX180.00180.0000
QUEUE750.002370.0000
RULESET0 10.0000
SCHEMA670.000 00
SQL AREA1,3240.53225,5850.0200
SQL AREA BUILD1353.850 00
SQL AREA STATS13100.0013100.0000
SUBSCRIPTION80.0080.0000
TABLE/PROCEDURE24,6590.00142,2030.0000
TRIGGER1820.002360.0000


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 cache188.00188.00188.00188.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target280.00280.00280.00280.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target524.00524.00524.00524.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool28.0028.0028.0028.000STA/
large pool4.004.004.004.000STA/
shared pool288.00288.00288.00288.000STA/
streams pool8.008.008.008.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther76.05 1.771.8811174343
 Freeable46.880.001.672.4313 2828
 PL/SQL3.250.970.080.100114141
 SQL1.530.200.050.05063024
EOther75.23 1.791.8911174242
 Freeable46.630.001.732.5513 2727
 PL/SQL3.200.930.080.090114040
 SQL2.771.430.100.26162924

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers197,132,288 
Fixed Size2,231,128 
Redo Buffers2,383,872 
Variable Size637,535,400 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory28.0028.000.00
largePX msg pool0.470.470.00
largefree memory3.533.530.00
sharedFileOpenBlock3.803.800.00
sharedKCB Table Scan Buffer3.803.800.00
sharedKGLH039.3739.560.47
sharedKGLHD8.778.790.22
sharedKGLS17.3817.380.00
sharedKGLSG5.025.020.00
sharedKQR L PO3.283.280.03
sharedKQR M PO3.553.550.00
sharedKSFD SGA I/O b3.793.790.00
sharedPLDIA8.598.590.00
sharedPLMCD8.598.590.00
sharedSQLA52.9853.711.38
sharedevent statistics per sess3.083.080.00
sharedfree memory56.9456.02-1.62
sharedkglsim hash table bkts4.004.000.00
sharedprivate strands3.513.510.00
sharedrow cache7.247.240.00
streamsfree memory8.008.000.00
 buffer_cache188.00188.000.00
 fixed_sga2.132.130.00
 log_buffer2.272.270.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 Slaves1005 12:53:223.160.040.00
QMON Coordinator1005 12:53:110.340.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 10100.000.000.000.000.009.51
SYS.AQ$_ALERT_QT_E(12342) 200.000.000.000.000.000.00
SYSMAN.MGMT_TASK_Q(66573) 64640.000.000.121.100.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12343) 0.000.000.00 
SYS.AQ$_ALERT_QT_E(12342) 0.000.000.00 
SYSMAN.MGMT_TASK_Q(66573) 0.020.020.000.02

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE 000   
OEL5_11GR2_DE_3938_DB11G(22)/SYS.ALERT_QUE 1020.000.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,5630.00100.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/DB11G/adump  
audit_trailDB  
compatible11.2.0.0.0  
control_files/u01/app/oracle/oradata/DB11G/control01.ctl, /u01/app/oracle/flash_recovery_area/DB11G/control02.ctl  
db_block_size8192  
db_create_file_dest/u01/app/oracle/oradata/DB11G/  
db_domainWORLD  
db_nameDB11G  
db_recovery_file_dest/u01/app/oracle/flash_recovery_area  
db_recovery_file_dest_size4070572032  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=DB11GXDB)  
event    
memory_target843055104  
open_cursors300  
processes150  
remote_login_passwordfileEXCLUSIVE  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/u01/app/oracle/flash_recovery_area/DB11G/control02.ctl  
 /u01/app/oracle/oradata/DB11G/control01.ctl  

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