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:182223-Apr-14 18:30:0558 1.5
End Snap:182323-Apr-14 18:45:0659 1.5
Elapsed:  15.03 (mins)  
DB Time:  106.74 (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): 7.1 0.0 0.01 0.00
DB CPU(s): 1.9 0.0 0.00 0.00
Redo size: 393,267.0 1,931.8  
Logical reads: 406,407.8 1,996.3  
Block changes: 2,827.7 13.9  
Physical reads: 580.0 2.9  
Physical writes: 377.6 1.9  
User calls: 2,896.4 14.2  
Parses: 0.6 0.0  
Hard parses: 0.0 0.0  
W/A MB processed: 0.1 0.0  
Logons: 0.0 0.0  
Executes: 1,364.7 6.7  
Rollbacks: 0.0 0.0  
Transactions: 203.6   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.97
Buffer Hit %: 99.86In-memory Sort %: 100.00
Library Hit %: 100.02Soft Parse %: 98.98
Execute to Parse %: 99.96Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 104.26% Non-Parse CPU: 98.89

Shared Pool Statistics

BeginEnd
Memory Usage %: 66.48 66.54
% SQL with executions>1: 76.23 75.09
% Memory for SQL w/exec>1: 60.16 60.10

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
db file sequential read520,2074,568971.32User I/O
DB CPU 1,701 26.57 
log file sync182,7389411.47Commit
read by other session2,75327100.42User I/O
SQL*Net message to client1,418,459200.04Network

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

Load Average BeginLoad Average End%User%System%WIO%Idle
6.93 7.23 23.8 0.9 21.8 74.8
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
24.8 98.4 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): 178.2 181.2
% Host Mem used for SGA+PGA: 15.08 15.11

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time6,114.4295.47
DB CPU1,701.4426.57
parse time elapsed26.870.42
sequence load elapsed time0.090.00
PL/SQL execution elapsed time0.000.00
repeated bind elapsed time0.000.00
DB time6,404.55 
background elapsed time107.51 
background cpu time38.73 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME176,851 
IDLE_TIME524,631 
IOWAIT_TIME152,976 
NICE_TIME35 
SYS_TIME6,268 
USER_TIME166,878 
LOAD77
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 18:30:056.93     
23-Apr 18:45:067.2325.2123.790.8974.7921.81

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/O523,01504,595971.75
DB CPU  1,701 26.57
Commit182,73809411.47
Configuration17305280.08
Network1,418,4590200.04
Application6840110.01
Concurrency1,0380000.01
System I/O3560000.00
Other1023000.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 read520,20704,56892.8371.32
log file sync182,73809411.001.47
read by other session2,753027100.010.42
SQL*Net message to client1,418,4590207.730.04
log file switch (checkpoint incomplete)7302340.000.04
log file switch (private strand flush incomplete)10002240.000.04
enq: TX - row lock contention6840110.000.01
db file parallel read4100100.000.01
buffer busy waits3690010.000.00
enq: TX - index contention700160.000.00
control file sequential read3560000.000.00
latch: cache buffers chains4480000.000.00
cursor: pin S270020.000.00
latch free710000.000.00
latch: In memory undo latch1550000.000.00
db file scattered read20070.000.00
library cache: mutex X320000.000.00
latch: enqueue hash chains140000.000.00
latch: object queue header operation100000.000.00
SQL*Net message from client1,418,463016,141117.73 
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 write178,85903900.9736.11
db file parallel write25,15201410.1413.37
db file sequential read1,1590760.016.85
control file sequential read2,3240520.014.81
db file scattered read11901120.001.38
os thread startup1200350.000.39
direct path read1800190.000.32
log file sequential read440050.000.22
ASM file metadata operation5410000.000.20
control file parallel write6160000.000.10
ADR block file read160050.000.08
LGWR wait for redo copy8260000.000.05
enq: JS - queue lock100510.000.05
reliable message870000.000.01
Disk file operations I/O660000.000.00
CSS initialization10050.000.00
db file async I/O submit1,5550000.010.00
latch free30010.000.00
log file single write440000.000.00
ADR block file write50010.000.00
read by other session10030.000.00
latch: redo allocation120000.000.00
direct path write120000.000.00
CSS operation: action10010.000.00
rdbms ipc message184,586212,525681.01 
class slave wait23503,606153440.00 
Space Manager: slave idle wait607942,93548360.00 
DIAG idle wait1,8001001,80210010.01 
Streams AQ: qmn coordinator idle wait3014390330010.00 
Streams AQ: qmn slave idle wait129090370010.00 
wait for unread message on broadcast channel90010090110010.00 
ASM background timer180090050000.00 
pmon timer3149190028650.00 
smon timer303899299830.00 
KSV master wait750000.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.56.3 6.3 
ADR block file write580.020.0      
ADR file lock6100.0       
ASM file metadata operation54596.12.4.7.4.2 .2 
CSS initialization1   100.0    
CSS operation: action1100.0       
CSS operation: query6100.0       
Disk file operations I/O78100.0       
LGWR wait for redo copy82499.8.1.1     
SQL*Net message to client1419K100.0 .0     
asynch descriptor resize25100.0       
buffer busy waits37397.9.8.3  .5.5 
control file parallel write61699.5 .5     
control file sequential read268091.2.11.23.62.6.4.9 
cursor: pin S2680.8 3.8 15.4   
db file async I/O submit1557100.0       
db file parallel read41  7.348.836.64.92.4 
db file parallel write25.2K95.4.4.3.43.4.0.0 
db file scattered read12115.74.19.137.219.06.68.3 
db file sequential read521.6K2.12.919.849.118.34.43.4 
direct path read1811.1  5.650.027.85.6 
direct path write12100.0       
enq: JS - queue lock1      100.0 
enq: TX - index contention7 14.3 42.914.314.314.3 
enq: TX - row lock contention67994.01.81.21.0.9.4.7 
latch free7493.25.41.4     
latch: In memory undo latch15797.51.9.6     
latch: cache buffers chains44896.72.01.3     
latch: cache buffers lru chain9100.0       
latch: checkpoint queue latch1100.0       
latch: enqueue hash chains14100.0       
latch: messages2100.0       
latch: object queue header operation1492.97.1      
latch: redo allocation11100.0       
latch: undo global data3100.0       
library cache: mutex X3296.9   3.1   
log file parallel write178.9K98.7.3.3.2.3.2.0 
log file sequential read4436.49.14.525.020.54.5  
log file single write44100.0       
log file switch (checkpoint incomplete)731.4 1.42.711.021.961.6 
log file switch (private strand flush incomplete)100 1.02.08.014.048.027.0 
log file sync182.8K96.31.2.8.4.8.3.0 
os thread startup12      100.0 
read by other session27444.96.119.739.916.57.55.2 
reliable message87100.0       
ASM background timer181       100.0
DIAG idle wait1802      100.0 
KSV master wait75100.0       
SQL*Net message from client1419K26.8.1.1.047.125.2.6 
Space Manager: slave idle wait608.2   .2.5.798.5
Streams AQ: qmn coordinator idle wait30157.1      42.9
Streams AQ: qmn slave idle wait129       100.0
class slave wait23536.2 .44.74.711.111.131.9
jobq slave wait120      100.0 
pmon timer315.3     3.296.5
rdbms ipc message184.7K21.614.420.922.814.72.61.81.3
smon timer30      13.386.7
wait for unread message on broadcast channel901      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 read193.86.3      
ASM file metadata operation199.8 .2     
buffer busy waits299.5.5      
control file sequential read2499.1.2.3.3.0   
db file parallel read197.62.4      
db file parallel write5100.0.0.0     
db file scattered read1091.75.02.5.8    
db file sequential read17.6K96.62.11.1.2.0   
direct path read194.4 5.6     
enq: JS - queue lock1 100.0      
enq: TX - index contention185.714.3      
enq: TX - row lock contention599.3.4.1.1    
log file parallel write13100.0.0.0.0    
log file switch (checkpoint incomplete)4538.461.6      
log file switch (private strand flush incomplete)2773.027.0      
log file sync70100.0.0.0.0    
os thread startup12 100.0      
read by other session14394.83.51.6.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.ch6,3971,702520366,686
SYS$USERS6114
SYS$BACKGROUND00212

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 5225094592103800014184532
SYS$USERS 4913000000
SYS$BACKGROUND 137092200000

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
1,863.02124,8820.0129.091.7298.5782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
1,350.707,0860.1921.0991.786.66g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
651.8236,8520.0210.183.1796.949zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
587.08105,2520.019.175.1794.638vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
527.8936,7520.018.242.4297.82d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
433.79105,2540.006.773.4696.725g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
399.5214,6710.036.242.6497.539bz9sa0abpc48 Swingbench User Thread insert into customers (custome...
104.4036,8530.001.6310.3789.352yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
52.38220,4410.000.8289.310.00gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
44.4336,8540.000.6918.1381.06gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...

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
1,239.617,0860.1772.861,350.7091.786.66g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
46.78220,4410.002.7552.3889.310.00gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
32.12124,8820.001.891,863.021.7298.5782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
30.35105,2520.001.78587.085.1794.638vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
20.6336,8520.001.21651.823.1796.949zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
17.01124,8830.001.0023.2973.0412.30gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
15.00105,2540.000.88433.793.4696.725g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
12.7536,7520.000.75527.892.4297.82d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
11.95109,8620.000.7012.9092.660.007v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
10.83105,2520.000.6411.7592.121.10dt8dtzvsq5kj5 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
1,836.46124,8820.0139.891,863.021.7298.5782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
631.8836,8520.0213.72651.823.1796.949zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
555.57105,2520.0112.07587.085.1794.638vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
516.3636,7520.0111.21527.892.4297.82d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
419.55105,2540.009.11433.793.4696.725g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
389.6514,6710.038.46399.522.6497.539bz9sa0abpc48 Swingbench User Thread insert into customers (custome...
93.2936,8530.002.03104.4010.3789.352yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
89.977,0860.011.951,350.7091.786.66g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
36.0236,8540.000.7844.4318.1381.06gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
20.407,0820.000.4424.0210.1084.896k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...

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
351,654,8567,08649,626.7195.981,350.7091.86.7g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
6,619,177220,44130.031.8152.3889.30gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
1,398,081105,25213.280.38587.085.294.68vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
775,085109,8627.060.2112.9092.707v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
747,326124,8835.980.2023.297312.3gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
743,176105,2527.060.2011.7592.11.1dt8dtzvsq5kj5 Swingbench User Thread select p.product_id, product_n...
699,93036,85218.990.19651.823.296.99zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
500,271124,8824.010.141,863.021.798.682ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
487,65236,85413.230.1344.4318.181.1gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
412,977105,2543.920.11433.793.596.75g00dq4fxwnsw Swingbench User Thread update inventories set quantit...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
194,859124,8821.5637.271,863.021.7298.5782ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
70,67136,8521.9213.52651.823.1796.949zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
68,008105,2520.6513.01587.085.1794.638vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
65,59936,7521.7812.55527.892.4297.82d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
48,065105,2540.469.19433.793.4696.725g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
47,09614,6713.219.01399.522.6497.539bz9sa0abpc48 Swingbench User Thread insert into customers (custome...
11,19736,8530.302.14104.4010.3789.352yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
7,7737,0861.101.491,350.7091.786.66g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
4,35436,8540.120.8344.4318.1381.06gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
1,9427,0820.270.3724.0210.1084.896k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...

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
194,866194,866124,8821.560.0037.3582ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
70,67370,67336,8521.920.0013.559zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
68,01068,010105,2520.650.0013.038vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
65,59865,59836,7521.780.0012.57d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
48,06648,066105,2540.460.009.215g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
11,19711,19736,8530.300.002.152yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
7,7777,7777,0861.100.001.49g8rhybcumtwd6 Swingbench User Thread SELECT /*+ first_rows index(cu...
5,6805,68014,6710.390.001.099bz9sa0abpc48 Swingbench User Thread insert into customers (custome...
4,3544,35436,8540.120.000.83gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
1,9421,9427,0820.270.000.376k3uuf3g8pwh6 Swingbench User Thread update /*+ index(orders, order...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
220,4411,109,6225.0352.3889.30gyk686gnaygs2 Swingbench User Thread select product_id, product_nam...
124,883124,8811.0023.297312.3gshgncvvtv0c6 Swingbench User Thread insert into logon values(:1 , ...
124,882124,8771.001,863.021.798.682ud5h0qcg0bf Swingbench User Thread select customer_id, cust_first...
109,8621,098,61010.0012.9092.707v0pya6f6qc6s Swingbench User Thread select p.product_id, product_n...
105,25494,7020.90433.793.596.75g00dq4fxwnsw Swingbench User Thread update inventories set quantit...
105,252105,2521.00587.085.294.68vvvyuun2urt6 Swingbench User Thread insert into order_items(ORDER_...
105,2521,052,50010.0011.7592.11.1dt8dtzvsq5kj5 Swingbench User Thread select p.product_id, product_n...
105,251105,2501.007.7193.20982zxphp8ht6c Swingbench User Thread select product_id, product_nam...
36,854105,2352.8644.4318.181.1gfqas5ahy1x56 Swingbench User Thread SELECT o.order_id, line_item_i...
36,85336,8531.00104.4010.489.42yp5w5a36s5xv Swingbench User Thread update orders set order_mode =...
36,85236,8521.00651.823.296.99zd49du11u7cf Swingbench User Thread insert into orders(ORDER_ID, O...
36,84836,8481.003.3788.32.88uk8bquk453q8 Swingbench User Thread select orders_seq.nextval from...
36,75234,0580.93527.892.497.8d5j6fbqmu3gjp Swingbench User Thread SELECT /*+ use_nl */ o.order_i...
14,67114,6711.001.3389.805d8b4p888x97a Swingbench User Thread select customer_seq.nextval fr...
14,67114,6711.00399.522.697.59bz9sa0abpc48 Swingbench User Thread insert into customers (custome...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
13413427.24350f5yrnnmshs   lock table sys.mon_mods$ in ex...
7881.42bsa0wjtftg3uw   select file# from file$ where ...
5101.020kkhhb2w93cx0   update seg$ set type#=:4, bloc...
440.81b2gnxm5z6r51n   lock table sys.col_usage$ in e...
220.411gfaj4z5hn1kf   delete from dependency$ where ...
220.4120vv6ttajyjzq   delete from access$ where d_ob...
220.412pff93c8c626v   select name, address, protocol...
2100.414m7m0t6fjcs5x   update seq$ set increment$=:2,...
220.416abthk1u14yb7   SELECT VERSION FROM V$INSTANCE
2120.416xvp6nxs4a9n4   select nvl(sum(space), 0) from...

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
0kkhhb2w93cx0update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
1gfaj4z5hn1kfdelete from dependency$ where d_obj#=:1
20vv6ttajyjzqdelete from access$ where d_obj#=:1
2pff93c8c626vselect name, address, protocol, subscriber_type, subscriber_id from "SYS"."AQ$_SCHEDULER$_EVENT_QTAB_S" where queue_name = :1 and (bitand(subscriber_type, 4096) = 4096)
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
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
5d8b4p888x97aselect customer_seq.nextval from dual
5g00dq4fxwnswupdate inventories set quantity_on_hand = quantity_on_hand - :1 where product_id = :2 and warehouse_id = :3
6abthk1u14yb7SELECT VERSION FROM V$INSTANCE
6k3uuf3g8pwh6update /*+ index(orders, order_pk) */ orders set order_status = :1 where order_id = :2
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
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
9bz9sa0abpc48insert into customers (customer_id , cust_first_name , cust_last_name , nls_language , nls_territory , credit_limit , cust_email , account_mgr_id ) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 )
9zd49du11u7cfinsert into orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) values (:1 , :2 , :3 , :4 )
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bsa0wjtftg3uwselect file# from file$ where ts#=:1
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
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 count4510.500.00
Batched IO (full) vector count00.000.00
Batched IO block miss count6430.710.00
Batched IO buffer defrag count70.010.00
Batched IO double miss count900.100.00
Batched IO same unit count2230.250.00
Batched IO single block count4810.530.00
Batched IO vector block count1230.140.00
Batched IO vector read count600.070.00
Block Cleanout Optim referenced3,5583.950.02
CCursor + sql area evicted00.000.00
CPU used by this session162,156179.860.88
CPU used when call started162,045179.740.88
CR blocks created43,72748.500.24
Cached Commit SCN referenced34,73038.520.19
Commit SCN cached6,5047.210.04
DB time641,440711.493.49
DBWR checkpoint buffers written49,33754.720.27
DBWR checkpoints110.010.00
DBWR thread checkpoint buffers written49,33754.720.27
DBWR transaction table writes2180.240.00
DBWR undo block writes16,33618.120.09
HSC Heap Segment Block Changes421,099467.082.29
Heap Segment Array Inserts1690.190.00
Heap Segment Array Updates150.020.00
IMU CR rollbacks13,39614.860.07
IMU Flushes23,25925.800.13
IMU Redo allocation size116,746,320129,495.11636.09
IMU commits154,026170.850.84
IMU contention19,87222.040.11
IMU pool not allocated6,2586.940.03
IMU recursive-transaction flush00.000.00
IMU undo allocation size373,604,528414,402.452,035.59
IMU- failed to get a private strand6,2586.940.03
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,418,8641,573.817.73
RowCR - row contention2310.260.00
RowCR attempts112,607124.900.61
RowCR hits111,471123.640.61
SMON posted for undo segment shrink240.030.00
SQL*Net roundtrips to/from client1,418,8721,573.817.73
active txn count during cleanout55,65561.730.30
application wait time800.090.00
background checkpoints completed110.010.00
background checkpoints started110.010.00
background timeouts4,6825.190.03
branch node splits30.000.00
buffer is not pinned count177,662,097197,062.94968.00
buffer is pinned count179,300,974198,880.79976.93
bytes received via SQL*Net from client346,648,249384,502.521,888.72
bytes sent via SQL*Net to client767,717,895851,553.324,182.93
calls to get snapshot scn: kcmgss1,133,7821,257.596.18
calls to kcmgas235,694261.431.28
calls to kcmgcs726,676806.033.96
cell physical IO interconnect bytes7,982,754,8168,854,478.1943,494.22
change write time1,3001.440.01
cleanout - number of ktugct calls32,87436.460.18
cleanouts and rollbacks - consistent read gets23,36325.910.13
cleanouts only - consistent read gets1,7311.920.01
cluster key scan block gets600.070.00
cluster key scans600.070.00
commit batch/immediate performed180.020.00
commit batch/immediate requested180.020.00
commit cleanout failures: buffer being written90.010.00
commit cleanout failures: callback failure940.100.00
commit cleanout failures: cannot pin4,9275.470.03
commit cleanouts757,256839.954.13
commit cleanouts successfully completed752,226834.374.10
commit immediate performed180.020.00
commit immediate requested180.020.00
commit txn count during cleanout47,75352.970.26
concurrency wait time860.100.00
consistent changes100,357111.320.55
consistent gets362,913,878402,544.371,977.34
consistent gets - examination236,188,959261,980.991,286.88
consistent gets direct00.000.00
consistent gets from cache362,913,875402,544.371,977.34
consistent gets from cache (fastpath)126,504,818140,319.25689.26
cursor authentications50.010.00
data blocks consistent reads - undo records applied90,673100.570.49
db block changes2,549,3132,827.7013.89
db block gets3,483,0033,863.3518.98
db block gets direct270.030.00
db block gets from cache3,482,9763,863.3218.98
db block gets from cache (fastpath)1,190,1041,320.066.48
deferred (CURRENT) block cleanout applications265,326294.301.45
dirty buffers inspected209,279232.131.14
enqueue conversions5790.640.00
enqueue releases443,391491.812.42
enqueue requests443,403491.822.42
enqueue timeouts00.000.00
enqueue waits6910.770.00
execute count1,230,3801,364.746.70
file io service time00.000.00
file io wait time8,599,511,4519,538,585.1646,854.63
free buffer inspected568,832630.953.10
free buffer requested584,574648.413.19
heap block compress5760.640.00
hot buffers moved to head of LRU267,499296.711.46
immediate (CR) block cleanout applications25,09427.830.14
immediate (CURRENT) block cleanout applications29,43532.650.16
in call idle wait time2,633,4902,921.0714.35
index crx upgrade (positioned)00.000.00
index fast full scans (full)20.000.00
index fetch by key58,944,68065,381.49321.16
index scans kdiixs158,760,49665,177.19320.16
leaf node 90-10 splits200.020.00
leaf node splits1,6111.790.01
lob reads00.000.00
lob writes800.090.00
lob writes unaligned800.090.00
logical read bytes from cache3,001,522,946,0483,329,291,715.4316,353,864.89
logons cumulative130.010.00
max cf enq hold time100.010.00
messages received207,981230.691.13
messages sent207,981230.691.13
min active SCN optimization applied on CR159,883177.340.87
no buffer to keep pinned count00.000.00
no work - consistent read gets125,842,864139,585.01685.66
non-idle wait count2,527,0152,802.9713.77
non-idle wait time476,964529.052.60
opened cursors cumulative1,230,0721,364.406.70
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)50.010.00
parse count (total)4920.550.00
parse time cpu1,8832.090.01
parse time elapsed1,8062.000.01
physical read IO requests521,753578.732.84
physical read bytes4,283,432,9604,751,187.3623,338.38
physical read total IO requests524,482581.762.86
physical read total bytes4,327,405,5684,799,961.8123,577.97
physical read total multi block requests50.010.00
physical reads522,880579.982.85
physical reads cache522,825579.922.85
physical reads cache prefetch1,1701.300.01
physical reads direct550.060.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests236,463262.281.29
physical write bytes2,788,556,8003,093,069.4915,193.51
physical write total IO requests597,121662.333.25
physical write total bytes3,655,349,2484,054,516.3919,916.25
physical write total multi block requests1,0991.220.01
physical writes340,400377.571.85
physical writes direct820.090.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache340,318377.481.85
physical writes non checkpoint268,955298.331.47
pinned buffers inspected390.040.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use10.000.00
process last non-idle time00.000.00
recovery blocks read00.000.00
recursive calls193,830215.001.06
recursive cpu usage1,5361.700.01
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)292,518324.461.59
redo blocks read for recovery00.000.00
redo blocks written826,743917.024.50
redo buffer allocation retries1740.190.00
redo entries649,827720.793.54
redo k-bytes read for recovery00.000.00
redo log space requests1760.200.00
redo log space wait time4970.550.00
redo ordering marks6,1156.780.03
redo size354,549,884393,267.021,931.77
redo size for direct writes2080.230.00
redo subscn max counts16,12517.890.09
redo synch long waits1870.210.00
redo synch time9,60110.650.05
redo synch time (usec)96,015,263106,500.21523.14
redo synch writes183,545203.591.00
redo wastage55,374,42461,421.36301.71
redo write time5,2605.830.03
redo writes178,894198.430.97
rollback changes - undo records applied480.050.00
rollbacks only - consistent read gets19,77021.930.11
rows fetched via callback58,794,76465,215.20320.34
session connect time00.000.00
session logical reads366,396,963406,407.811,996.32
shared hash latch upgrades - no wait309,676343.491.69
shared hash latch upgrades - wait300.030.00
sorts (memory)4450.490.00
sorts (rows)16,32218.100.09
sql area evicted00.000.00
sql area purged00.000.00
summed dirty queue length1,935,7982,147.1910.55
switch current to new buffer3420.380.00
table fetch by rowid119,629,777132,693.45651.81
table fetch continued row00.000.00
table scan blocks gotten6,180,6296,855.5633.68
table scan rows gotten220,747,132244,852.901,202.75
table scans (long tables)00.000.00
table scans (short tables)220,455244.531.20
temp space allocated (bytes)00.000.00
total cf enq hold time3,2503.600.02
total number of cf enq holders790.090.00
total number of times SMON posted280.030.00
transaction rollbacks150.020.00
undo change vector size119,248,856132,270.93649.73
user I/O wait time460,683510.992.51
user calls2,611,2142,896.3614.23
user commits183,536203.581.00
workarea executions - optimal2740.300.00
write clones created in foreground1230.140.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current5859
session uga memory max276,205,016302,141,872
session pga memory173,079,824178,701,104
session pga memory max315,033,488327,256,848
session cursor cache count2,4452,661
session uga memory30,094,017,22434,389,911,968
opened cursors current8990

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)1143.92

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 Reads4G578.794.531080M0.000M521.8K8.33
DBWR0M0.000M2.6G262.242.949360 
LGWR5M0.36.005546811M399.03.899561179.4K0.10
Others38M2.67.04214916M1.10.01774729001.50
Direct Reads1M0.06.0011090M0.020M0 
Streams AQ1M0.01.0011090M0.000M85.75
Direct Writes0M0.000M0M0.040M0 
TOTAL:4G581.894.580993.4G662.443.86667704.1K6.20

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 File4G578.864.532192.6G262.302.950478.3320.20
Log File0M0.050M808M398.78.8962344.93 
Control File42M2.97.04658619M1.37.0210741.82 
Temp File0M0.000M0M0.000M11.00 
TOTAL:4G581.884.578783.4G662.453.867788.2920.20

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 4G578.734.529970M0.000M521.7K8.33
Buffer Cache Reads (Data File) 4G578.734.529970M0.000M521.7K8.33
DBWR 0M0.000M2.6G262.242.949360 
DBWR (Data File) 0M0.000M2.6G262.242.949360 
LGWR 5M0.36.005546811M399.01.8995613682.08
LGWR (Log File) 0M0.050M808M398.74.896234882.47
LGWR (Control File) 5M0.31.0055463M0.27.0033272801.96
Others 37M2.67.04104016M1.10.01774724051.81
Others (Control File) 37M2.66.04104016M1.10.01774724001.80
Others (Data File) 0M0.010M0M0.000M54.40
Direct Reads 1M0.06.0011090M0.020M0 
Direct Reads (Data File) 1M0.06.0011090M0.020M0 
Streams AQ 1M0.01.0011090M0.000M85.75
Streams AQ (Data File) 1M0.01.0011090M0.000M85.75
Direct Writes 0M0.000M0M0.040M0 
Direct Writes (Data File) 0M0.000M0M0.040M0 
TOTAL: 4G581.824.578783.4G662.413.86667524.4K8.29

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 519,8315778.781.00234,5762603,2708.39
SYSAUX 1,47526.391.40502100.00
UNDOTBS1 8306.021.001,3632520.19
SYSTEM 230010.483.3526010.00
USERS 1100.001.0011000.00
TEMP 2010.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)
SOE+DATA/dbm11203/datafile/soe.486.836957131 519,8315778.781.00234,5762603,2708.39
SYSAUX+DATA/dbm11203/datafile/sysaux.460.772715927 1,47526.391.40502100.00
SYSTEM+DATA/dbm11203/datafile/system.459.772715923 230010.483.3526010.00
TEMP+DATA/dbm11203/tempfile/temp.462.772715931 2010.001.00000 
UNDOTBS1+DATA/dbm11203/datafile/undotbs1.461.772715929 8306.021.001,3632520.19
USERS+DATA/dbm11203/datafile/users.463.772715939 1100.001.0011000.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,362100365,315,273522,788340,346003,322

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
040,9100008,366

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
B01920987167937165888165888445422   
E01921454167685165888165888384637   

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.109347.391,573,046114509263.00
D1440.2018261.431,183,804110918910.00
D2160.3027121.53550,32715075738.00
D2880.40351.707,684170425.00
D3600.49441.396,293157590.00
D4320.59531.255,643151592.00
D5040.69621.165,231147798.00
D5760.79711.094,945145155.00
D6480.89801.044,716143048.00
D7200.99881.004,545141465.00
D7281.00891.004,528141313.00
D7921.09970.974,400140130.00
D8641.191060.944,276138988.00
D9361.291150.924,167137977.00
D1,0081.381240.904,064137032.00
D1,0801.481330.883,968136146.00
D1,1521.581410.863,886135385.00
D1,2241.681500.843,810134684.00
D1,2961.781590.813,682133512.00
D1,3681.881680.693,110128235.00
D1,4401.981770.632,840125740.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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)
B1288178.240.000.000.000.0026,214
E1288181.230.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
2K4K19919900
64K128K9900
128K256K1100
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.13692.4213.5798.0061,160,917
320.25692.4213.5798.0061,160,917
640.50692.4213.5798.0061,160,917
960.75692.4213.5798.0061,160,917
1281.00692.420.00100.0061,138,602
1541.20692.420.00100.0001,138,602
1791.40692.420.00100.0001,138,602
2051.60692.420.00100.0001,138,602
2301.80692.420.00100.0001,138,602
2562.00692.420.00100.0001,138,602
3843.00692.420.00100.0001,138,602
5124.00692.420.00100.0001,138,602
7686.00692.420.00100.0001,138,602
1,0248.00692.420.00100.0001,138,602

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.891278310,0500.984331.753,925
2360.911589810,0810.984021.633,927
2400.921799710,1290.993541.433,928
2440.94211,24910,1420.993411.383,928
2480.95251,46510,1600.993231.313,929
2520.97291,68110,1780.993051.233,929
2560.98331,89710,2091.002741.113,930
2601.00372,11310,2361.002471.003,932
2641.02402,40710,2391.002440.993,932
2681.03442,62110,2391.002440.993,932
2721.05482,83110,2391.002440.993,932
2761.06523,05710,2391.002440.993,932
2801.08563,31910,2401.002430.983,933
2841.09593,64510,2401.002430.983,933
2881.11633,94110,2401.002430.983,933
2921.12674,17610,2401.002430.983,933
2961.14714,33510,2401.002430.983,933
3161.22914,82010,2401.002430.983,933
3441.32955,04410,2401.002430.983,933
3721.43955,04410,2401.002430.983,933
4001.54955,04410,2401.002430.983,933
4281.65955,04410,2401.002430.983,933
4561.75955,04410,2401.002430.983,933
4841.86955,04410,2401.002430.983,933
5121.97955,04410,2401.002430.983,933
5402.08955,04410,2401.002430.983,933

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5120.505,164,978563,502,939
7680.7563,9535,367,615
1,0241.0056,2574,514,774
1,2801.2553,0124,169,845
1,5361.5049,4283,778,414
1,7921.7541,5302,913,835
2,0482.0041,5302,913,835

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 block3,275278
undo block2400
undo header2800

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) 686686068411.17
TX-Transaction (index contention) 52052007014.29
JS-Job Scheduler (queue lock) 2,7522,75201050.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
221.26247,0759392019.6/29.70/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 18:4310,617123,63833820200/00/0/0/0/0/0
23-Apr 18:3310,647123,43793920300/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 latch230.00 00 
ASM allocation1500.00 00 
ASM db client latch6930.00 00 
ASM map operation freelist360.00 00 
ASM map operation hash table2,245,3330.000.0000 
ASM network background latch4400.00 00 
ASM network state latch1920.00 00 
AWR Alerted Metric Element list6,8050.00 00 
Change Notification Hash table latch3010.00 00 
Consistent RBA178,9070.00 00 
DML lock allocation498,2230.010.0900 
Event Group Locks270.00 00 
FOB s.o list latch1480.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,305,4400.020.570183,7740.00
JS Sh mem access60.00 00 
JS broadcast autostart latch10.00 00 
JS mem alloc latch20.00 00 
JS queue access latch40.00 00 
JS queue state obj latch5,5040.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 latch2100.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 latch3010.00 00 
KTF sga latch50.00 03020.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 latch1870.00 00 
MQL Tracking Latch0  0180.00
Memory Management Latch20.00 03010.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 process1070.00 00 
OS process allocation1,8650.00 00 
OS process: request allocation230.00 00 
PL/SQL warning settings440.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch4360.00 00 
SGA IO buffer pool latch110.00 0110.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 03000.00
SQL memory manager workarea list latch20,4660.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 latch28,4280.00 00 
active service list1,7600.00 02,1330.00
begin backup scn array40.00 00 
bq:time manger info latch320.00 00 
buffer pool20.00 00 
bufq statistics1180.00 00 
business card20.00 00 
cache buffer handles10,2260.100.0000 
cache buffers chains505,924,4000.050.000586,3230.01
cache buffers lru chain451,9160.040.060954,9730.06
cache table scan latch1210.00 01210.00
call allocation1140.00 00 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch270.00 00 
channel operations parent latch6,9620.00 00 
checkpoint queue latch1,348,9250.000.020333,5520.00
client/application info180.00 00 
compile environment latch130.00 00 
corrupted undo seg latch1590.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch340.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch340.00 00 
dml lock allocation340.00 00 
done queue latch20.00 00 
dummy allocation270.00 00 
enqueue freelist latch20.00 017,6220.01
enqueue hash chains888,0710.030.0600 
enqueues210.00 00 
fifth spare latch20.00 00 
file cache latch2200.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 latch80.00 0350.00
hash table modification latch20.00 00 
heartbeat check20.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 latch110.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kokc descriptor allocation latch40.00 00 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock220.00 00 
ksuosstats global area960.00 00 
ksv allocation latch730.00 00 
ksv class latch7190.140.0000 
ksv instance latch40.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch230.00 00 
ktm global data1230.00 00 
kwqbsn:qsga5610.00 00 
lgwr LWN SCN179,8700.000.0000 
list of block allocation540.00 00 
loader state object freelist1340.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 latch2650.00 00 
messages616,5400.020.0200 
mostly latch-free SCN182,0810.350.0200 
msg queue latch20.00 00 
multiblock read objects3660.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch340.00 00 
object queue header heap228,3550.00 01,3250.00
object queue header operation2,330,8540.020.0300 
object stats modification1950.00 00 
parallel query alloc buffer1220.00 00 
parallel query stats20.00 00 
parameter list20.00 00 
parameter table management420.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue271,5900.010.000184,4500.04
process allocation350.00 0120.00
process group creation230.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 allocation900,5470.040.030649,3970.19
redo copy20.00 0649,8850.16
redo writing566,7750.000.0000 
resmgr group change latch20.00 00 
resmgr:active threads270.00 00 
resmgr:actses change group130.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list250.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 objects8,3500.020.000390.00
rules engine rule set statistics2000.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
sequence cache154,9070.010.0000 
session allocation183,6440.010.000183,6370.00
session idle bit5,405,4870.010.0700 
session queue latch20.00 00 
session state list latch380.00 00 
session switching470.00 00 
session timer3140.00 00 
shared pool2,3500.130.0000 
shared pool sim alloc20.00 00 
shared pool simulator380.00 00 
sim partition latch20.00 00 
simulator hash latch21,646,9300.010.0100 
simulator lru latch20,8430.710.02021,589,4670.70
sort extent pool760.00 00 
space background state object latch50.00 00 
space background task latch1,8430.220.0006070.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 
transaction allocation450.00 00 
undo global data1,065,4910.010.0400 
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 chains505,924,400239,995450239,545
simulator hash latch21,646,9301,507221,485
mostly latch-free SCN182,08163513622
object queue header operation2,330,85445014436
session idle bit5,405,48743832406
redo allocation900,54731611305
In memory undo latch1,305,440277158120
enqueue hash chains888,07122714213
cache buffers lru chain451,91618110171
simulator lru latch20,8431483145
messages616,5401152113
undo global data1,065,49173370
DML lock allocation498,22343439
checkpoint queue latch1,348,92541140

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam031
DML lock allocationktaidm013
In memory undo latchktiFlush: child012350
In memory undo latchkticmt: child0388
In memory undo latchktichg: child011104
In memory undo latchkticflush_2010
cache buffers chainskcbgtcr: fast path (cr pin)0128194
cache buffers chainskcbgtcr: kslbegin shared011939
cache buffers chainskcbget: fast exchange0872
cache buffers chainskcbgtcr: fast path068195
cache buffers chainskcbchg1: mod cr pin06522
cache buffers chainskcbgtcr_206236
cache buffers chainskcbgcur_20225
cache buffers chainskcbgcur_40173
cache buffers chainskcbgtcr_10150
cache buffers chainskcbnew: new latch again0100
cache buffers chainskcbzgb: scan from tail. nowait060
cache buffers chainskcbzwb055
cache buffers chainskcbget: fast path041
cache buffers chainskcbgtcr: kslbegin excl048
cache buffers chainskcbnlc044
cache buffers chainskcbrls: fast release0474
cache buffers chainskcbgcur: fast path (shr)033
cache buffers chainskcbbic2020
cache buffers chainskcbbxsv020
cache buffers chainskcb_pre_apply: kcbhq61015
cache buffers chainskcbchg1: clear MS bit013
cache buffers chainskcbget: pin buffer010
cache buffers chainskcbrls_2019
cache buffers chainskcbzib: exchange rls013
cache buffers lru chainkcbzgws090
cache buffers lru chainkcbo_link_q010
checkpoint queue latchkcbklbc_cql010
enqueue hash chainsksqgtl30114
enqueue hash chainsksqrcl0210
enqueue hash chainsksqcmi: get hash chain latch after wait010
lgwr LWN SCNkcs023080
messagesksaamb: after wakeup011
messagesksarcv011
mostly latch-free SCNkcslcu30513
object queue header operationkcbo_switch_cq046
object queue header operationkcbo_link_q030
object queue header operationkcbo_unlink_q034
object queue header operationkcbo_check_flist013
object queue header operationkcbo_link_q:reget010
object queue header operationkcbo_switch_mq_bg011
object queue header operationkcbo_switch_q_bg010
redo allocationkcrfw_redo_gen: redo allocation 10110
session idle bitksupuc: set busy02016
session idle bitksupuc: clear busy01114
session idle bitksuxds034
simulator hash latchkcbsacc: lookup dba02221
simulator lru latchkcbs_simulate: simulate set030
undo global dataktubnd_4020
undo global dataktudnx:child011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkksfbc [KKSCHLPIN1]240
Library Cachekglpin1 4150
Library Cachekglpndl1 95110
Cursor PinkksLockDelete [KKSCHLPIN6]100
Library Cachekglpnal1 9080

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 INDEX117,716,44832.13
SOESOECUSTOMERS_PK INDEX117,354,96032.03
SOESOEORDERS TABLE58,667,76016.01
SOESOECUSTOMERS TABLE58,425,95215.95
SOESOEPRODUCT_INFORMATION TABLE6,935,3121.89

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SOESOECUSTOMERS TABLE107,28520.52
SOESOECUSTOMERS_PK INDEX103,49019.79
SOESOEORD_CUSTOMER_IX INDEX65,81612.59
SOESOEINVENTORIES TABLE47,6679.12
SOESOEITEM_ORDER_IX INDEX46,2858.85

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SOESOECUSTOMERS TABLE107,28320.56
SOESOECUSTOMERS_PK INDEX103,49019.84
SOESOEORD_CUSTOMER_IX INDEX65,81612.61
SOESOEINVENTORIES TABLE47,6679.14
SOESOEITEM_ORDER_IX INDEX46,2858.87

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SOESOECUSTOMERS TABLE107,28320.56
SOESOECUSTOMERS_PK INDEX103,49019.84
SOESOEORD_CUSTOMER_IX INDEX65,81612.61
SOESOEINVENTORIES TABLE47,6679.14
SOESOEITEM_ORDER_IX INDEX46,2858.87

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 TABLE68,34220.08
SOESOEORDER_PK INDEX36,81010.81
SOESOEORD_CUSTOMER_IX INDEX35,32110.38
SOESOEITEM_ORDER_IX INDEX32,6229.58
SOESOEORDER_ITEMS_PK INDEX32,5369.56

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SOESOEINVENTORIES TABLE36,88915.60
SOESOEORDER_PK INDEX34,55514.61
SOESOEORD_CUSTOMER_IX INDEX32,42413.71
SOESOEORDER_ITEMS_PK INDEX30,01912.70
SOESOEITEM_ORDER_IX INDEX29,47712.47

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 PARTITION2732.93

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
SOESOEORDER_ITEMS TABLE91,21617.68
SOESOEORD_WAREHOUSE_IX INDEX79,82415.47
SOESOEORDERS TABLE70,52813.67
SOESOEINVENTORIES TABLE64,81612.56
SOESOEITEM_ORDER_IX INDEX63,18412.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SOESOEORDERS TABLE68556.94
SOESOEORD_ORDER_DATE_IX INDEX29224.27
SOESOEITEM_PRODUCT_IX INDEX967.98
SOESOEORD_WAREHOUSE_IX INDEX352.91
SOESOECUST_LNAME_IX INDEX242.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
SOESOEORDERS TABLE33496.53
SOESOECUSTOMERS_PK INDEX41.16
SOESOEORD_ORDER_DATE_IX INDEX30.87
SOESOEITEM_ORDER_IX INDEX20.58
SOESOEORDER_PK INDEX20.58

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control190.000 21
dc_global_oids70.000 024
dc_histogram_data7844.870 02,000
dc_histogram_defs4112.200 02,024
dc_objects2290.440 11,501
dc_profiles20.000 01
dc_rollback_segments9630.000 078
dc_segments1210.000 10614
dc_sequences100.000 105
dc_tablespaces5060.000 07
dc_users2340.000 046
global database name6120.000 01
outstanding_alerts80.000 04
sch_lj_oids20.000 01


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY150.00440.0000
CLUSTER20.0020.0000
DBLINK10.000 00
EDITION80.0080.0000
QUEUE2620.002620.0000
SCHEMA10.000 00
SQL AREA3721.081,230,463-0.0210
SQL AREA BUILD5100.000 00
SQL AREA STATS580.00580.0000
TABLE/PROCEDURE270.00103,3510.0010


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
BOther151.47 2.612.4214255858
Freeable23.560.000.810.462 2929
PL/SQL2.412.090.040.18125858
SQL0.820.090.020.03094036
EOther153.90 2.612.4014255959
Freeable24.130.000.780.421 3131
PL/SQL2.412.090.040.18125959
SQL0.810.090.020.03094136

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.4418.43-0.04
sharedKGLHD3.813.820.20
sharedKGLS4.364.370.09
sharedKGLSG5.025.020.00
sharedKKSSP2.722.761.41
sharedKSFD SGA I/O b3.793.790.00
sharedPLMCD3.203.200.00
sharedSQLA22.2622.320.30
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 memory87.1486.99-0.17
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.050.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