WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORCL1200893776orcl123-Nov-10 18:1111.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
11gR2BaseLinux x86 64-bit 2   1.96

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:220724-Nov-10 21:18:3333 1.0
End Snap:220824-Nov-10 21:56:4433 1.0
Elapsed:  38.19 (mins)  
DB Time:  537.81 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 396M 396MStd Block Size: 8K
Shared Pool Size: 328M 328MLog Buffer: 6,564K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 14.1 145.4 4.10 0.09
DB CPU(s): 0.6 6.2 0.17 0.00
Redo size: 1,642.8 16,954.0  
Logical reads: 7,758.1 80,067.0  
Block changes: 3.2 32.7  
Physical reads: 12,137.9 125,268.4  
Physical writes: 263.9 2,723.1  
User calls: 160.0 1,651.1  
Parses: 2.3 23.7  
Hard parses: 0.0 0.1  
W/A MB processed: 1.2 12.3  
Logons: 0.1 0.7  
Executes: 3.4 35.4  
Rollbacks: 0.0 0.0  
Transactions: 0.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 99.93In-memory Sort %: 99.70
Library Hit %: 99.46Soft Parse %: 99.41
Execute to Parse %: 33.15Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 9.37% Non-Parse CPU: 99.93

Shared Pool Statistics

BeginEnd
Memory Usage %: 86.68 86.77
% SQL with executions>1: 92.12 91.48
% Memory for SQL w/exec>1: 90.46 90.68

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
direct path write temp86,26717,79020655.13User I/O
direct path read139,7116,8754921.30User I/O
direct path read temp1,530,2666,208419.24User I/O
DB CPU 1,367 4.24 
log file sync604720.01Commit

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
0.11 3.55 12.0 19.3 59.5 67.5
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
30.2 93.0 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 2,011.4 2,011.4
SGA use (MB): 752.0 752.0
PGA use (MB): 186.6 188.7
% Host Mem used for SGA+PGA: 46.66 46.77

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time32,214.5099.83
DB CPU1,366.874.24
PL/SQL execution elapsed time21.080.07
parse time elapsed11.370.04
hard parse elapsed time2.750.01
connection management call elapsed time1.940.01
repeated bind elapsed time0.000.00
DB time32,268.75 
background elapsed time77.36 
background cpu time6.80 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME147,738 
IDLE_TIME306,590 
IOWAIT_TIME270,520 
NICE_TIME69 
SYS_TIME87,501 
USER_TIME54,621 
LOAD04
PHYSICAL_MEMORY_BYTES2,109,128,704 
NUM_CPUS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,576 
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
24-Nov 21:18:330.11     
24-Nov 21:56:443.5532.5212.0219.2667.4859.54

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/O1,756,800030,8821895.70
DB CPU  1,367 4.24
Commit6004720.01
Concurrency7202300.01
Network365,9420200.01
System I/O5060010.00
Other76697000.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
direct path write temp86,267017,790206388.5955.13
direct path read139,71106,87549629.3321.30
direct path read temp1,530,26606,20846,893.0919.24
log file sync6004720.270.01
db file sequential read28204151.270.01
read by other session4502520.200.01
db file parallel read2202970.100.01
SQL*Net message to client365,9420201,648.390.01
latch: shared pool2601330.120.00
latch: cache buffers chains2501280.110.00
library cache: mutex X2001290.090.00
control file sequential read4980012.240.00
Disk file operations I/O2040010.920.00
latch free160020.070.00
asynch descriptor resize741100003.340.00
direct path write20070.010.00
flashback log file sync100120.000.00
latch: object queue header operation10080.000.00
CSS initialization10080.000.00
CSS operation: action10020.000.00
jobq slave wait4,8181002,41250121.70 
SQL*Net message from client365,94201,90951,648.39 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file parallel write750017233.3822.47
os thread startup890131460.4016.82
log file parallel write44609202.0111.73
ASM file metadata operation63807112.878.77
flashback log file sync124264890.057.59
control file parallel write8400563.786.32
control file sequential read3,46104115.594.78
flashback log file write6402240.291.97
CSS initialization3001300.010.50
db file sequential read640060.290.47
Disk file operations I/O2980011.340.31
flashback log file read200080.090.20
log file sync300480.010.19
direct path read300350.010.14
direct path write400240.020.12
latch free50090.020.06
CSS operation: action30050.010.02
SQL*Net more data from client160010.070.01
asynch descriptor resize107100000.480.01
kfk: async disk IO6890003.100.01
CSS operation: query180000.080.01
SQL*Net more data to client160000.070.00
rdbms ipc message11,7149640,117342552.77 
DIAG idle wait4,5781004,582100120.62 
smon timer81002,4003000060.04 
dispatcher timer391002,340600040.18 
Streams AQ: qmn coordinator idle wait164502,296140020.74 
Streams AQ: qmn slave idle wait8402,296273380.38 
Space Manager: slave idle wait459992,29249952.07 
ASM background timer50902,29245032.29 
wait for unread message on broadcast channel2,2901002,292100110.32 
pmon timer860892,29126643.87 
shared server idle wait761002,280300040.34 
class slave wait2601,196459950.12 
KSV master wait20063150.09 
SQL*Net message from client6401130.29 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ASM file metadata operation63995.11.3.9.8.5.21.1.2
CSS initialization4   25.0  75.0 
CSS operation: action4 25.025.050.0    
CSS operation: query2491.78.3      
Disk file operations I/O50282.912.52.4.2.61.4  
LGWR wait for redo copy2100.0       
SQL*Net message to client366K100.0.0.0     
SQL*Net more data from client1693.8 6.3     
SQL*Net more data to client16100.0       
asynch descriptor resize84899.5.1.4     
control file parallel write84176.29.34.81.23.32.62.6 
control file sequential read396088.75.82.6.9.8.7.4 
cursor: pin S1100.0       
db file parallel read22    13.613.672.7 
db file parallel write7503.3.72.87.128.842.814.4.1
db file sequential read34837.11.71.78.621.316.113.5 
direct path read139.7K4.735.65.81.02.16.843.8.2
direct path read temp1530.3K96.1.6.4.7.9.3.9.1
direct path write633.3   50.0 16.7 
direct path write temp86.3K.4.81.31.42.54.486.82.6
flashback log file read2050.05.0 5.015.020.05.0 
flashback log file sync1323.1  7.77.77.753.8 
flashback log file write6418.8  3.117.232.828.1 
kfk: async disk IO697100.0       
latch free2176.24.8  14.34.8  
latch: cache buffers chains2544.0  4.0 8.044.0 
latch: object queue header operation250.0   50.0   
latch: shared pool267.73.87.77.719.215.438.5 
library cache: mutex X2020.0 15.010.045.0 10.0 
log file parallel write44734.97.87.45.617.414.112.5.2
log file sync633.21.66.33.233.341.37.93.2
os thread startup89      98.91.1
read by other session454.44.42.22.213.322.251.1 
ASM background timer5105.5.6.8.6.4.81.490.0
DIAG idle wait4585      100.0 
KSV master wait2010.020.020.015.0 5.020.010.0
SQL*Net message from client366K5.132.427.035.3.1.0.0.0
Space Manager: slave idle wait459.2      99.8
Streams AQ: qmn coordinator idle wait16447.02.4 .6   50.0
Streams AQ: qmn slave idle wait842.4      97.6
class slave wait2634.63.815.43.87.715.43.815.4
dispatcher timer39       100.0
jobq slave wait4830      100.0 
pmon timer8629.51.6.1    88.7
rdbms ipc message11.7K.8.1.1.1.2.221.976.5
shared server idle wait76       100.0
smon timer8       100.0
wait for unread message on broadcast channel2292      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
ASM file metadata operation798.7.2.2.3.3.2 .2
CSS initialization325.0 50.025.0    
control file parallel write2297.41.8.2 .2.4  
control file sequential read1799.6.3.1.0    
db file parallel read1627.34.540.927.3    
db file parallel write10985.512.41.3.5.1 .1 
db file sequential read4786.58.03.71.7    
direct path read61.5K56.020.216.35.21.6.6.2.0
direct path read temp15.3K99.0.1.2.2.2.2.1.0
direct path write183.3 16.7     
direct path write temp77K10.77.622.043.210.03.92.5.1
flashback log file read195.05.0      
flashback log file sync746.2 7.7  46.2  
flashback log file write1871.920.36.31.6    
latch: cache buffers chains1156.040.04.0     
latch: shared pool1061.523.111.53.8    
library cache: mutex X290.0 5.0 5.0   
log file parallel write5787.27.24.7.4 .2.2 
log file sync788.94.83.2   3.2 
os thread startup89 60.718.06.76.76.71.1 
read by other session2348.924.415.611.1    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
ASM file metadata operation199.8 .2     
direct path read19100.0.0      
direct path read temp6100.0.0      
direct path write temp5999.9.1      

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)
orcl32,2221,35327,80917,729
SYS$USERS4413032
ADHOC0000
BATCH_LOW0000
BATCH_STD0000
DSS0000
OLTP0000
SYS$BACKGROUND00014
orclXDB0000

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
orcl 175672030882722003659422
SYS$USERS 790000000
SYS$BACKGROUND 381789130000

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
6,998.7615466.5821.695.5394.9795rzx549dbvs5 Agent.exe SELECT NATION, O_YEAR, SUM(AMO...
4,029.2715268.6212.493.5397.701x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
1,639.524409.885.082.4198.53bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
1,621.014405.255.022.4698.521gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
1,431.701595.454.444.9297.58fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
1,250.613416.873.882.4198.562uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
849.302424.652.632.2598.60c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
831.532415.762.582.3898.5639pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
780.952390.482.422.1398.86agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
739.842369.922.292.6197.68afy3mzh484trw Agent.exe SELECT l_orderkey, SUM(l_exten...
591.442295.721.832.4398.594d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
579.612289.801.802.4398.57c71khx643vgxb Agent.exe SELECT c_custkey, c_name, SUM(...
573.082286.541.782.4498.5512qmb2vstfhgy Agent.exe SELECT c_custkey, c_name, SUM(...
542.592271.291.682.6098.399mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...
395.751395.751.232.5397.291qnaw3d512k2n Agent.exe SELECT l_orderkey, SUM(l_exten...
384.291384.291.192.5697.5559ahdunmw6xbz Agent.exe SELECT l_orderkey, SUM(l_exten...
377.971377.971.172.6197.814ttpsft97zujk Agent.exe SELECT l_orderkey, SUM(l_exten...
374.831374.831.162.5998.272jpbyjb76zda2 Agent.exe SELECT l_orderkey, SUM(l_exten...
365.151365.151.132.7997.933nk66p120bzrd Agent.exe SELECT l_orderkey, SUM(l_exten...
364.961364.961.132.6098.151fwcc9b0mbzum Agent.exe SELECT l_orderkey, SUM(l_exten...
361.291361.291.122.6798.10ct388w8nrts6k Agent.exe SELECT l_orderkey, SUM(l_exten...
361.161361.161.122.5898.198pqynfptn4ff6 Agent.exe SELECT l_orderkey, SUM(l_exten...
356.271356.271.102.5798.316uusdb8z8usyu Agent.exe SELECT l_orderkey, SUM(l_exten...
355.711355.711.102.7598.1280pntantvvbqy Agent.exe SELECT l_orderkey, SUM(l_exten...
355.161355.161.102.6898.197r9673qwmbsyu Agent.exe SELECT l_orderkey, SUM(l_exten...
346.051346.051.072.5398.311ba09vhjx4rxj Agent.exe SELECT l_orderkey, SUM(l_exten...
344.361344.361.072.2798.718q89qv4cxbg9v Agent.exe SELECT c_custkey, c_name, SUM(...
340.801340.801.062.6598.32c6p5t6yk7gvvb Agent.exe SELECT l_orderkey, SUM(l_exten...
337.291337.291.052.2598.65bpqbakh1vjzad Agent.exe SELECT c_custkey, c_name, SUM(...
330.871330.871.032.3298.651809cng2r987s Agent.exe SELECT c_custkey, c_name, SUM(...

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
386.821525.7928.306,998.765.5394.9795rzx549dbvs5 Agent.exe SELECT NATION, O_YEAR, SUM(AMO...
142.24159.4810.414,029.273.5397.701x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
70.39154.695.151,431.704.9297.58fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
39.8349.962.911,621.012.4698.521gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
39.5449.892.891,639.522.4198.53bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
30.09310.032.201,250.612.4198.562uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
19.9529.981.46154.2812.9366.779xcdxpqrhsvmx Agent.exe SELECT l_returnflag, l_linesta...
19.7829.891.45831.532.3898.5639pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
19.3129.651.41739.842.6197.68afy3mzh484trw Agent.exe SELECT l_orderkey, SUM(l_exten...
19.0829.541.40849.302.2598.60c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
16.6728.331.22780.952.1398.86agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
14.3627.181.05591.442.4398.594d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
14.1127.061.03542.592.6098.399mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...
14.0627.031.03579.612.4398.57c71khx643vgxb Agent.exe SELECT c_custkey, c_name, SUM(...
14.0027.001.02573.082.4498.5512qmb2vstfhgy Agent.exe SELECT c_custkey, c_name, SUM(...

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
6,646.8115443.1221.526,998.765.5394.9795rzx549dbvs5 Agent.exe SELECT NATION, O_YEAR, SUM(AMO...
3,936.6815262.4512.744,029.273.5397.701x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
1,615.374403.845.231,639.522.4198.53bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
1,597.024399.265.171,621.012.4698.521gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
1,396.991593.134.521,431.704.9297.58fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
1,232.643410.883.991,250.612.4198.562uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
837.452418.722.71849.302.2598.60c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
819.522409.762.65831.532.3898.5639pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
772.032386.022.50780.952.1398.86agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
722.702361.352.34739.842.6197.68afy3mzh484trw Agent.exe SELECT l_orderkey, SUM(l_exten...
583.082291.541.89591.442.4398.594d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
571.342285.671.85579.612.4398.57c71khx643vgxb Agent.exe SELECT c_custkey, c_name, SUM(...
564.792282.391.83573.082.4498.5512qmb2vstfhgy Agent.exe SELECT c_custkey, c_name, SUM(...
533.832266.911.73542.592.6098.399mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...
385.021385.021.25395.752.5397.291qnaw3d512k2n Agent.exe SELECT l_orderkey, SUM(l_exten...
374.861374.861.21384.292.5697.5559ahdunmw6xbz Agent.exe SELECT l_orderkey, SUM(l_exten...
369.691369.691.20377.972.6197.814ttpsft97zujk Agent.exe SELECT l_orderkey, SUM(l_exten...
368.341368.341.19374.832.5998.272jpbyjb76zda2 Agent.exe SELECT l_orderkey, SUM(l_exten...
358.191358.191.16364.962.6098.151fwcc9b0mbzum Agent.exe SELECT l_orderkey, SUM(l_exten...
357.591357.591.16365.152.7997.933nk66p120bzrd Agent.exe SELECT l_orderkey, SUM(l_exten...
354.621354.621.15361.162.5898.198pqynfptn4ff6 Agent.exe SELECT l_orderkey, SUM(l_exten...
354.421354.421.15361.292.6798.10ct388w8nrts6k Agent.exe SELECT l_orderkey, SUM(l_exten...
350.231350.231.13356.272.5798.316uusdb8z8usyu Agent.exe SELECT l_orderkey, SUM(l_exten...
349.031349.031.13355.712.7598.1280pntantvvbqy Agent.exe SELECT l_orderkey, SUM(l_exten...
348.731348.731.13355.162.6898.197r9673qwmbsyu Agent.exe SELECT l_orderkey, SUM(l_exten...
340.211340.211.10346.052.5398.311ba09vhjx4rxj Agent.exe SELECT l_orderkey, SUM(l_exten...
339.921339.921.10344.362.2798.718q89qv4cxbg9v Agent.exe SELECT c_custkey, c_name, SUM(...
335.081335.081.08340.802.6598.32c6p5t6yk7gvvb Agent.exe SELECT l_orderkey, SUM(l_exten...
332.751332.751.08337.292.2598.65bpqbakh1vjzad Agent.exe SELECT c_custkey, c_name, SUM(...
326.411326.411.06330.872.3298.651809cng2r987s Agent.exe SELECT c_custkey, c_name, SUM(...

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
2,168,62515144,575.0012.206,998.765.5394.9795rzx549dbvs5 Agent.exe SELECT NATION, O_YEAR, SUM(AMO...
2,088,88515139,259.0011.751,431.704.9297.58fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
2,032,20015135,480.0011.434,029.273.5397.701x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
541,8924135,473.003.051,621.012.4698.521gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
541,8924135,473.003.051,639.522.4198.53bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
406,4193135,473.002.291,250.612.4198.562uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
271,1462135,573.001.53780.952.1398.86agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
270,9462135,473.001.52831.532.3898.5639pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
270,9462135,473.001.52849.302.2598.60c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
270,6262135,313.001.52579.612.4398.57c71khx643vgxb Agent.exe SELECT c_custkey, c_name, SUM(...
270,6232135,311.501.52573.082.4498.5512qmb2vstfhgy Agent.exe SELECT c_custkey, c_name, SUM(...
270,6082135,304.001.52591.442.4398.594d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
270,5982135,299.001.52542.592.6098.399mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...
270,4422135,221.001.52739.842.6197.68afy3mzh484trw Agent.exe SELECT l_orderkey, SUM(l_exten...
217,7022108,851.001.22154.2812.9366.779xcdxpqrhsvmx Agent.exe SELECT l_returnflag, l_linesta...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
6,921,58515461,439.0024.896,998.765.5394.9795rzx549dbvs5 Agent.exe SELECT NATION, O_YEAR, SUM(AMO...
3,567,81215237,854.1312.834,029.273.5397.701x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
2,018,94015134,596.007.261,431.704.9297.58fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
1,081,9134270,478.253.891,621.012.4698.521gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
1,080,8004270,200.003.891,639.522.4198.53bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
807,3453269,115.002.901,250.612.4198.562uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
539,3572269,678.501.94831.532.3898.5639pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
531,9232265,961.501.91849.302.2598.60c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
470,0222235,011.001.69739.842.6197.68afy3mzh484trw Agent.exe SELECT l_orderkey, SUM(l_exten...
323,0162161,508.001.16780.952.1398.86agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
319,2692159,634.501.15542.592.6098.399mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...
319,0772159,538.501.15591.442.4398.594d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
317,7772158,888.501.14573.082.4498.5512qmb2vstfhgy Agent.exe SELECT c_custkey, c_name, SUM(...
317,7002158,850.001.14579.612.4398.57c71khx643vgxb Agent.exe SELECT c_custkey, c_name, SUM(...

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
242,356242,3561516,157.070.0014.511x255a7m968k7 Agent.exe SELECT supp_nation, cust_natio...
83,29583,295420,823.750.004.991gkn6r4rbdkmy Agent.exe SELECT n_name, SUM(l_extendedp...
83,13683,136420,784.000.004.98bfk319z4wc782 Agent.exe SELECT n_name, SUM(l_extendedp...
61,88761,887320,629.000.003.712uzp6kw11g1su Agent.exe SELECT n_name, SUM(l_extendedp...
41,41941,419220,709.500.002.4839pvzrsczv31x Agent.exe SELECT n_name, SUM(l_extendedp...
40,35740,357220,178.500.002.42c0chxpnujy8td Agent.exe SELECT n_name, SUM(l_extendedp...
21,18021,180151,412.000.001.27fps40s3v7nd3r Agent.exe SELECT O_YEAR, SUM(DECODE(NATI...
15,66215,66227,831.000.000.94agz7fu32m6qn4 Agent.exe SELECT c_custkey, c_name, SUM(...
12,40112,40126,200.500.000.744d0thwk8bh4zt Agent.exe SELECT c_custkey, c_name, SUM(...
12,40112,40126,200.500.000.749mhss2f5z0qc8 Agent.exe SELECT c_custkey, c_name, SUM(...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,1576,2582.900.4075.190.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
2492491.000.1330.240.006xvp6nxs4a9n4   select nvl(sum(space), 0) from...
24900.000.0293.890.00csnp95dz2r8ss   select file#, block# from recy...
2322321.000.0492.910.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1621621.000.5414.0610.208vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1241241.000.08103.802.32fsbqktj5vw6n9   select next_run_date, obj#, ru...
115760.660.0837.820.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
10800.000.0278.850.00350f5yrnnmshs   lock table sys.mon_mods$ in ex...
1081081.000.0697.820.00g00cj285jmgsw   update sys.mon_mods$ set inser...
81811.000.9120.236.6318naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,1572,15741.03cm5vu20fhtnq1   select /*+ connect_by_filterin...
2492494.746xvp6nxs4a9n4   select nvl(sum(space), 0) from...
2492494.74csnp95dz2r8ss   select file#, block# from recy...
1241242.36fsbqktj5vw6n9   select next_run_date, obj#, ru...
1151152.1908bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1081082.05350f5yrnnmshs   lock table sys.mon_mods$ in ex...
1081082.05g00cj285jmgsw   update sys.mon_mods$ set inser...
762321.45089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
76761.45c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
57571.080k8522rmdzg4k   select privilege# from sysauth...

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
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
12qmb2vstfhgySELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-07-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-07-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
1809cng2r987sSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1995-01-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1ba09vhjx4rxjSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-10', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-10', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
1fwcc9b0mbzumSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-20', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-20', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
1gkn6r4rbdkmySELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1997-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1997-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
1qnaw3d512k2nSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-05', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-05', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
1x255a7m968k7SELECT supp_nation, cust_nation, L_YEAR, SUM(VOLUME) AS REVENUE FROM (SELECT N1.n_name supp_nation, N2.n_name cust_nation, to_number(to_char(l_shipdate, 'YYYY')) AS L_YEAR, l_extendedprice * (1 - l_discount) VOLUME FROM H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2 WHERE s_suppkey = l_suppkey AND o_orderkey = l_orderkey AND c_custkey = o_custkey AND s_nationkey = N1.n_nationkey AND c_nationkey = N2.n_nationkey AND ((N1.n_name = 'ALGERIA' AND N2.n_name = 'CANADA') OR (N1.n_name = 'CANADA' AND N2.n_name = 'ALGERIA')) AND l_shipdate BETWEEN to_date( '1995-01-01', 'YYYY-MM-DD') AND to_date( '1996-12-31', 'YYYY-MM-DD') ) SHIPPING GROUP BY supp_nation, cust_nation, L_YEAR ORDER BY supp_nation, cust_nation, L_YEAR
2jpbyjb76zda2SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-14', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-14', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
2uzp6kw11g1suSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1996-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1996-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
39pvzrsczv31xSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1993-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1993-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
3nk66p120bzrdSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-30', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-30', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
4d0thwk8bh4ztSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-03-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-03-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
4ttpsft97zujkSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-24', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-24', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
59ahdunmw6xbzSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-22', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-22', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
6uusdb8z8usyuSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-15', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-15', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7r9673qwmbsyuSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-26', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-26', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
80pntantvvbqySELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-28', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-28', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
8pqynfptn4ff6SELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-18', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-18', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
8q89qv4cxbg9vSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-05-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-05-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
95rzx549dbvs5SELECT NATION, O_YEAR, SUM(AMOUNT) SUM_PROFIT FROM (SELECT n_name NATION, to_number(TO_CHAR (o_orderdate, 'YYYY')) AS O_YEAR , l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity AS AMOUNT FROM H_Part, H_Supplier, H_Lineitem, H_Partsupp, H_Order, H_Nation WHERE s_suppkey = l_suppkey AND ps_suppkey = l_suppkey AND ps_partkey = l_partkey AND p_partkey = l_partkey AND o_orderkey = l_orderkey AND s_nationkey = n_nationkey AND p_name LIKE '%almond%' ) PROFIT GROUP BY NATION, O_YEAR ORDER BY NATION, O_YEAR DESC
9mhss2f5z0qc8SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-10-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
9xcdxpqrhsvmxSELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 119 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus
afy3mzh484trwSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-06', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-06', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
agz7fu32m6qn4SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1994-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-10-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
bfk319z4wc782SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1995-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
bpqbakh1vjzadSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1994-11-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-11-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
c0chxpnujy8tdSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1994-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1994-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
c6p5t6yk7gvvbSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-03', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-03', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
c71khx643vgxbSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-09-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-09-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
ct388w8nrts6kSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-07', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-07', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
fps40s3v7nd3rSELECT O_YEAR, SUM(DECODE(NATION, 'ALGERIA', VOLUME, 0)) / SUM(VOLUME) AS MKT_SHARE FROM (SELECT to_number(TO_CHAR(o_orderdate, 'YYYY')) AS O_YEAR, l_extendedprice * (1 - l_discount) VOLUME, N2.n_name NATION FROM H_Part, H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2, H_Region WHERE p_partkey = l_partkey AND s_suppkey = l_suppkey AND l_orderkey = o_orderkey AND o_custkey = c_custkey AND c_nationkey = N1.n_nationkey AND N1.n_regionkey = r_regionkey AND r_name = 'AFRICA' AND s_nationkey = N2.n_nationkey AND o_orderdate BETWEEN to_date ('1995-01-01', 'YYYY-MM-DD') AND to_date ('1996-12-31', 'YYYY-MM-DD') AND p_type = 'STANDARD ANODIZED TIN') ALL_NATIONS GROUP BY O_YEAR ORDER BY O_YEAR
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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count1300.060.59
Batched IO (full) vector count00.000.00
Batched IO block miss count5330.232.40
Batched IO buffer defrag count30.000.01
Batched IO double miss count140.010.06
Batched IO same unit count3270.141.47
Batched IO single block count960.040.43
Batched IO slow jump count10.000.00
Batched IO vector block count980.040.44
Batched IO vector read count350.020.16
Block Cleanout Optim referenced20.000.01
CCursor + sql area evicted00.000.00
CPU used by this session132,18057.69595.41
CPU used when call started131,36857.34591.75
CR blocks created150.010.07
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time3,462,4171,511.2315,596.47
DBWR checkpoint buffers written1,2100.535.45
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR parallel query checkpoint buffers written00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes1800.080.81
DBWR undo block writes3400.151.53
DFO trees parallelized00.000.00
HSC Heap Segment Block Changes1,0010.444.51
Heap Segment Array Inserts1070.050.48
LOB table id lookup cache misses00.000.00
Number of read IOs issued139,71060.98629.32
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 1 to 25 pct00.000.00
Parallel operations downgraded 25 to 50 pct00.000.00
Parallel operations downgraded to serial00.000.00
RowCR - row contention00.000.00
RowCR attempts1570.070.71
RowCR hits1570.070.71
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client365,942159.721,648.39
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout700.030.32
application wait time00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts11,2124.8950.50
buffer is not pinned count32,24414.07145.24
buffer is pinned count104,86145.77472.35
bytes received via SQL*Net from client4,144,4391,808.9118,668.64
bytes sent via SQL*Net to client124,252,06254,231.81559,693.97
calls to get snapshot scn: kcmgss8,8063.8439.67
calls to kcmgas8710.383.92
calls to kcmgcs7,6663.3534.53
cell physical IO interconnect bytes232,923,072,000101,663,010.681,049,203,027.03
change write time890.040.40
cleanout - number of ktugct calls720.030.32
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets00.000.00
cluster key scan block gets2,2790.9910.27
cluster key scans2,0230.889.11
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed00.000.00
commit batch/immediate requested00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure40.000.02
commit cleanout failures: cannot pin10.000.00
commit cleanouts1,5130.666.82
commit cleanouts successfully completed1,5080.666.79
commit immediate performed00.000.00
commit immediate requested00.000.00
commit txn count during cleanout410.020.18
concurrency wait time1,5150.666.82
consistent changes450.020.20
consistent gets17,764,9537,753.8080,022.31
consistent gets - examination26,33811.50118.64
consistent gets direct17,271,4957,538.4277,799.53
consistent gets from cache493,458215.382,222.78
consistent gets from cache (fastpath)465,890203.352,098.60
cursor authentications160.010.07
data blocks consistent reads - undo records applied340.010.15
db block changes7,2683.1732.74
db block gets9,9094.3244.64
db block gets direct1300.060.59
db block gets from cache9,7794.2744.05
db block gets from cache (fastpath)1,9580.858.82
deferred (CURRENT) block cleanout applications8650.383.90
dirty buffers inspected00.000.00
enqueue conversions4700.212.12
enqueue releases35,58715.53160.30
enqueue requests35,58715.53160.30
enqueue timeouts00.000.00
enqueue waits00.000.00
exchange deadlocks00.000.00
execute count7,8643.4335.42
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time76,820,67333,529.61346,039.07
flashback log write bytes7,168,0003,128.5932,288.29
flashback log writes570.020.26
free buffer inspected3650.161.64
free buffer requested3930.171.77
heap block compress230.010.10
hot buffers moved to head of LRU7010.313.16
immediate (CR) block cleanout applications00.000.00
immediate (CURRENT) block cleanout applications3110.141.40
index crx upgrade (positioned)00.000.00
index fast full scans (full)70.000.03
index fetch by key8,1333.5536.64
index scans kdiixs119,9138.6989.70
leaf node 90-10 splits320.010.14
leaf node splits400.020.18
lob reads00.000.00
lob writes50.000.02
lob writes unaligned50.000.02
logons cumulative1480.060.67
max cf enq hold time700.030.32
messages received1,2470.545.62
messages sent1,2470.545.62
min active SCN optimization applied on CR00.000.00
no buffer to keep pinned count00.000.00
no work - consistent read gets17,730,0307,738.5679,865.00
non-idle wait count2,131,884930.499,603.08
non-idle wait time3,095,4511,351.0613,943.47
opened cursors cumulative7,2363.1632.59
parse count (describe)00.000.00
parse count (failures)00.000.00
parse count (hard)310.010.14
parse count (total)5,2572.2923.68
parse time cpu970.040.44
parse time elapsed1,0350.454.66
physical read IO requests1,670,321729.047,523.97
physical read bytes227,816,144,89699,434,010.441,026,198,850.88
physical read total IO requests1,674,382730.817,542.26
physical read total bytes227,882,796,03299,463,101.391,026,499,081.23
physical read total multi block requests135,63659.20610.97
physical reads27,809,58812,137.94125,268.41
physical reads cache3360.151.51
physical reads cache prefetch340.010.15
physical reads direct27,809,25212,137.79125,266.90
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace10,537,6274,599.3247,466.79
physical reads for flashback new1710.070.77
physical reads prefetch warmup00.000.00
physical write IO requests87,16038.04392.61
physical write bytes4,952,227,8402,161,479.2722,307,332.61
physical write total IO requests89,81339.20404.56
physical write total bytes4,997,762,0482,181,353.4122,512,441.66
physical write total multi block requests480.020.22
physical writes604,520263.852,723.06
physical writes direct603,310263.322,717.61
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace603,180263.272,717.03
physical writes from cache1,2100.535.45
physical writes non checkpoint603,524263.422,718.58
pinned buffers inspected00.000.00
pinned cursors current00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
queries parallelized00.000.00
recursive calls53,14223.19239.38
recursive cpu usage8170.363.68
redo blocks checksummed by FG (exclusive)4,9172.1522.15
redo blocks written7,8353.4235.29
redo buffer allocation retries00.000.00
redo entries4,9042.1422.09
redo k-bytes read total00.000.00
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks1800.080.81
redo size3,763,7761,642.7616,953.95
redo size for direct writes1,075,360469.364,843.96
redo subscn max counts4570.202.06
redo synch time4510.202.03
redo synch writes780.030.35
redo wastage110,30048.14496.85
redo write time9310.414.19
redo writes4460.192.01
rollback changes - undo records applied00.000.00
rollbacks only - consistent read gets150.010.07
rows fetched via callback3,0361.3313.68
session cursor cache hits5,0062.1822.55
session logical reads17,774,8627,758.1280,066.95
shared hash latch upgrades - no wait1,0160.444.58
shared hash latch upgrades - wait00.000.00
sorts (disk)210.010.09
sorts (memory)6,9083.0231.12
sorts (rows)94,764,37441,361.43426,866.55
sql area evicted40.000.02
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer170.010.08
table fetch by rowid53,59523.39241.42
table fetch continued row00.000.00
table scan blocks gotten17,688,5557,720.4579,678.18
table scan rows gotten1,000,452,129436,663.384,506,541.12
table scans (direct read)2550.111.15
table scans (long tables)2550.111.15
table scans (rowid ranges)00.000.00
table scans (short tables)2,0190.889.09
total cf enq hold time3,2501.4214.64
total number of cf enq holders1360.060.61
total number of times SMON posted00.000.00
transaction rollbacks00.000.00
undo change vector size962,204419.974,334.25
user I/O wait time3,088,8721,348.1913,913.84
user calls366,551159.991,651.13
user commits2220.101.00
user rollbacks00.000.00
workarea executions - multipass2050.090.92
workarea executions - onepass1000.040.45
workarea executions - optimal3,0701.3413.83
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory7,705,499,211,3047,890,190,287,096
opened cursors current3232
logons current3333
session uga memory max5,880,982,7126,047,162,608
session pga memory5,384,823,8325,505,056,224
session pga memory max5,671,412,7605,793,414,624
session cursor cache count117,273119,766

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads203.7G724.8391.02673G24.201.324231670K7.71
Direct Writes8.5G4.063.799871.6G13.45.73239086.3K205.70
Others64M1.77.02793338M0.77.01658549562.23
DBWR0M0.000M10M0.39.0043640 
LGWR0M0.000M9M0.39.0039280 
Buffer Cache Reads3M0.14.0013090M0.000M30128.97
TOTAL:212.2G730.8094.85584.7G39.202.081501761.5K17.39

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 File131.8G61.1558.896711M0.39.00480110.3449.83
Temp File80.4G667.9135.93204.6G37.652.056623.95 
Control File61M1.72.02662427M0.73.0117840.75 
Flashback Log1M0.01.0004368M0.03.0034917.767.50
Log File0M0.000M9M0.39.003928  
Other0M0.000M3M0.01.001309  
TOTAL:212.2G730.7994.85584.7G39.202.081943.9649.83

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Direct Reads 203.7G724.8391.02673G24.201.324230 
Direct Reads (Data File) 203.7G724.8391.02673G24.201.324230 
Direct Writes 8.5G4.063.799871.6G13.45.7323900 
Direct Writes (Data File) 8.5G4.063.799871.6G13.45.7323900 
Others 64M1.76.02793335M0.76.01527641021.40
Others (Control File) 62M1.72.02706026M0.73.01134839450.75
Others (Flashback Log) 1M0.01.0004368M0.03.0034917723.48
Others (Data File) 1M0.03.0004361M0.00.0004368011.85
DBWR 0M0.000M10M0.39.0043640 
DBWR (Data File) 0M0.000M10M0.39.0043640 
LGWR 0M0.000M9M0.39.0039280 
LGWR (Log File) 0M0.000M9M0.39.0039280 
Buffer Cache Reads 3M0.14.0013090M0.000M25717.45
Buffer Cache Reads (Data File) 3M0.14.0013090M0.000M25717.45
TOTAL: 212.2G730.7994.85584.7G39.192.0801943592.34

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TPCH_BIGTEMP 1,530,2576680.006.8986,2423800.00
TPCH_REF_DATA 139,842610.03123.51004750.43
SYSAUX 14000.001.86492000.00
UNDOTBS1 7100.001.00364000.00
SYSTEM 000.000.0037000.00
TPCE_BIGTEMP 900.0015.0025000.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)
SYSAUX+DATA/orcl/datafile/sysaux.258.716405081 14000.001.86492000.00
SYSTEM+DATA/orcl/datafile/system.259.716405187 00  37000.00
TPCE_BIGTEMP/u01/app/oradata/TPCE/tpce_bigtemp.tmp 900.0015.002500 
TPCH_BIGTEMP/u01/app/oradata/TPCH/tpch_bigtemp.tmp 1,530,2576680.006.8986,242380 
TPCH_REF_DATA/u01/app/oradata/TPCH/tpch_ref_data01.dbf 139,842610.03123.51004750.43
UNDOTBS1+DATA/orcl/datafile/undotbs1.260.716405283 7100.001.00364000.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
D48,609100503,2503391,2100047

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,2100

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
B021336113318434246021843   
E021336229055164246025516   

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
D360.0945.14545138300.00
D720.1892.43258116553.00
D1080.27131.4915819043.00
D1440.36181.2513217084.00
D1800.45221.1211916052.00
D2160.55271.0811415718.00
D2520.64311.0511215507.00
D2880.73351.0411115435.00
D3240.82401.0310915337.00
D3600.91441.0010615099.00
D3961.00491.0010615090.00
D4321.09531.0010615062.00
D4681.18570.9910515039.00
D5041.27620.9910515028.00
D5401.36660.9910515024.00
D5761.45710.9810414894.00
D6121.55750.9810314892.00
D6481.64800.9810314891.00
D6841.73840.9710314872.00
D7201.82880.9510114697.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
26.032,7397,783

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)
B1509186.590.000.000.000.0030,720
E1509188.720.000.000.000.0030,720

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K2,8692,86900
64K128K121200
256K512K2412120
512K1024K11111100
1M2M132663531
2M4M450936
4M8M9201379
8M16M300129
16M32M4503015
32M64M150015

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
190.139,186.2921,334.7630.0048745,781
380.259,186.2921,334.7630.0048745,781
750.509,186.2921,334.7630.0048745,781
1130.759,186.2921,330.5030.0048645,774
1501.009,186.2912,654.3742.0048532,760
1801.209,186.2912,548.4442.0040432,601
2101.409,186.2912,286.7343.0036932,209
2401.609,186.2911,356.7845.0031130,814
2701.809,186.2911,204.3145.0030230,585
3002.009,186.299,733.1749.0030228,378
4503.009,186.296,948.0657.00024,201
6004.009,186.294,182.0069.00020,052
9006.009,186.291,299.9388.00015,729
1,2008.009,186.29484.1995.00014,505

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)
2200.67201,56952,3790.991,7921.32356
2560.78563,89552,5260.991,6451.21648
2920.89925,67452,7201.001,4511.07652
3281.001287,29352,8151.001,3561.00654
3641.111649,56952,8601.001,3110.97655
4001.2220012,02652,8821.001,2890.95656
4361.3323614,26652,9041.001,2670.93656
4721.4427216,13152,9301.001,2410.92657
5081.5530817,73752,9441.001,2270.90658
5441.6634219,30752,9461.001,2250.90658
5801.7735619,96352,9471.001,2240.90658
6161.8835619,96352,9471.001,2240.90658
6521.9935619,96352,9471.001,2240.90658
6882.1035619,96352,9471.001,2240.90658

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3760.50324,776157,972
5640.75320,900111,412
7521.00320,355106,036
9401.25320,195103,311
1,1281.50319,939100,734
1,3161.75319,874100,734
1,5042.00319,874100,734

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)
41.000000
82.000000
123.000000
164.000000
205.000000
246.000000
287.000000
328.000000
369.000000
4010.000000
4411.000000
4812.000000
5213.000000
5614.000000
6015.000000
6416.000000
6817.000000
7218.000000
7619.000000
8020.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 block47250

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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
20.174481,274323.1/33.30/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
24-Nov 21:5622786672230/00/0/0/0/0/0
24-Nov 21:4622661,2702330/00/0/0/0/0/0
24-Nov 21:36231656703230/00/0/0/0/0/0
24-Nov 21:261051391,2743330/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM Keyed state latch850.00 00 
ASM allocation650.00 00 
ASM db client latch1,5240.00 00 
ASM map headers540.00 00 
ASM map load waiting list90.00 00 
ASM map operation freelist730.00 00 
ASM map operation hash table40,0070.000.0000 
ASM network background latch1,0400.00 00 
ASM network state latch590.00 00 
AWR Alerted Metric Element list18,5490.00 00 
Change Notification Hash table latch7670.00 00 
Consistent RBA4460.00 00 
DML lock allocation1,7520.00 00 
Event Group Locks1060.00 00 
FAL Queue590.00 00 
FIB s.o chain latch220.00 00 
FOB s.o list latch9780.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch10.00 00 
JS Sh mem access520.001.0000 
JS broadcast autostart latch420.00 00 
JS mem alloc latch60.00 00 
JS queue access latch70.00 00 
JS queue state obj latch30,3220.00 00 
JS slv state obj latch4590.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch6080.00 00 
KFMD SGA760.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch7640.00 00 
KTF sga latch120.00 06970.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch100.00 00 
KWQS pqueue ctx latch550.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch2060.00 00 
MQL Tracking Latch0  0460.00
Memory Management Latch10.00 07640.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch130.00 00 
Minimum flashback SCN latch10.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process8500.00 00 
OS process allocation1,3300.00 00 
OS process: request allocation2100.00 00 
PL/SQL warning settings2470.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch1,4390.070.0000 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1750.00 07620.00
SQL memory manager workarea list latch64,4920.00 00 
Shared B-Tree2260.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP3670.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch1,5120.00 00 
active service list7,6230.041.0003,3040.00
archive control380.00 00 
archive process latch1770.00 00 
begin backup scn array90.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles2260.00 00 
cache buffers chains999,9040.010.2314790.00
cache buffers lru chain1,2900.00 01,6160.00
call allocation6810.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch2280.00 00 
channel operations parent latch14,4760.00 00 
checkpoint queue latch36,6400.00 01,0620.00
client/application info1,1020.00 00 
compile environment latch1480.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch410.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch410.00 00 
dml lock allocation410.00 00 
done queue latch10.00 00 
dummy allocation2970.00 00 
enqueue hash chains71,6290.000.0000 
enqueues68,2420.010.0000 
fifth spare latch10.00 00 
file cache latch8620.00 00 
flashback FBA barrier10.00 00 
flashback SCN barrier20.00 00 
flashback allocation1,7180.00 00 
flashback copy10.00 08690.00
flashback hint SCN barrier10.00 00 
flashback mapping560.00 00 
flashback marker cache20.00 00 
flashback sync request510.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA150.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch130.00 01,3310.00
hash table modification latch740.00 00 
heartbeat check10.00 00 
hint flashback FBA barrier10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch440.00 0434.65
job_queue_processes free list latch880.00 00 
job_queue_processes parameter latch5390.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats550.00 00 
kokc descriptor allocation latch3220.00 00 
ksfv messages10.00 00 
kss move lock270.00 00 
ksuosstats global area1560.00 00 
ksv allocation latch930.00 00 
ksv class latch1781.120.5000 
ksv msg queue latch190.00 0180.00
ksz_so allocation latch2100.00 00 
ktm global data130.00 00 
kwqbsn:qsga840.00 00 
lgwr LWN SCN1,0550.00 00 
list of block allocation1640.00 00 
loader state object freelist2,0340.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch90.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent6500.00 04020.00
managed standby latch590.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch850.00 00 
messages25,6090.010.0000 
mostly latch-free SCN1,0560.00 00 
msg queue latch10.00 00 
multiblock read objects700.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch410.00 00 
object queue header heap3,0540.00 0230.00
object queue header operation12,4970.021.0000 
object stats modification10.00 00 
parallel query alloc buffer3050.00 00 
parallel query stats10.00 00 
parameter list8320.00 00 
parameter table management2970.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue1880.00 0990.00
process allocation2990.00 01050.00
process group creation2100.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch3360.00 00 
query server freelists10.00 00 
queued dump request70.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation2,5610.00 04,8790.06
redo copy50.00 04,8800.20
redo writing4,4580.00 00 
resmgr group change latch2550.00 00 
resmgr:active threads2970.00 00 
resmgr:actses change group730.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list2960.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config110.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects43,1420.00 090.00
rules engine aggregate statistics10.00 00 
rules engine rule set statistics1020.00 00 
second spare latch10.00 00 
segmented array pool180.00 00 
sequence cache1890.00 00 
session allocation1,0990.00 03660.00
session idle bit733,3210.010.0600 
session queue latch10.00 00 
session state list latch2980.00 00 
session switching5670.00 00 
session timer8620.00 00 
shared pool11,6710.460.5710 
shared pool sim alloc30.00 00 
shared pool simulator2060.00 00 
sim partition latch10.00 00 
simulator hash latch636,9390.000.1100 
simulator lru latch7280.00 0636,1990.03
sort extent pool329,8080.030.1100 
space background state object latch20.00 00 
space background task latch1,6980.00 01,5280.00
state object free list20.00 00 
statistics aggregation2,5200.00 00 
tablespace key chain850.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch5320.00 00 
transaction allocation5250.00 00 
undo global data2,1420.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains999,9041082583
sort extent pool329,8081021191
shared pool11,671543128
session idle bit733,32148345
simulator hash latch636,93918216
active service list7,623330
ksv class latch178211
object queue header operation12,497220
JS Sh mem access5110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
JS Sh mem accessjsksGetShMemLatch011
active service listkswslogon: session logout033
cache buffers chainskcbgtcr: fast path (cr pin)0309
cache buffers chainskcbgcur_2010
ksv class latchksvclsl: cldel011
object queue header operationkcbo_switch_cq021
session idle bitksupuc: set busy062
session idle bitksupuc: clear busy015
shared poolkghupr10147
shared poolkghalo01110
shared poolkghalp0513
shared poolkghfre011
simulator hash latchkcbs_lookup_setid: lookup dba011
simulator hash latchkcbsacc: lookup dba011
sort extent poolktatobjstats01111

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn2 1061612
Library Cachekgllkdl1 852-84
Library Cachekglget2 21-1,373
Library Cachekglhdgn1 621-7,197
Cursor Pinkkslce [KKSCHLPIN2]1-811

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
TPCHTPCH_REF_DATAH_LINEITEM TABLE14,693,85682.67
TPCHTPCH_REF_DATAH_ORDER TABLE2,452,76813.80
TPCHTPCH_REF_DATAH_CUSTOMER TABLE225,6641.27
TPCHTPCH_REF_DATAH_PART TABLE170,0640.96
TPCHTPCH_REF_DATAH_PARTSUPP TABLE136,4480.77

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
TPCHTPCH_REF_DATAH_LINEITEM TABLE14,694,07552.84
TPCHTPCH_REF_DATAH_ORDER TABLE2,452,4858.82
TPCHTPCH_REF_DATAH_PARTSUPP TABLE125,0490.45
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION1320.00
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION480.00

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
TPCHTPCH_REF_DATAH_LINEITEM TABLE117,5847.04
TPCHTPCH_REF_DATAH_ORDER TABLE20,8941.25
TPCHTPCH_REF_DATAH_PARTSUPP TABLE1,3440.08
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION480.00
TPCHTPCH_REF_DATAH_PARTSUPP_IDX1 INDEX180.00

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
TPCHTPCH_REF_DATAH_LINEITEM TABLE117,5847.04
TPCHTPCH_REF_DATAH_ORDER TABLE20,8941.25
TPCHTPCH_REF_DATAH_PARTSUPP TABLE1,3440.08
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION480.00
TPCHTPCH_REF_DATAH_PARTSUPP_IDX1 INDEX180.00

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
TPCHTPCH_REF_DATAH_LINEITEM TABLE14,694,07552.84
TPCHTPCH_REF_DATAH_ORDER TABLE2,452,4858.82
TPCHTPCH_REF_DATAH_PARTSUPP TABLE124,9350.45
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION1300.00

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION1410.02
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION590.01
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX220.00
SYSSYSAUXSMON_SCN_TIME TABLE180.00
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1200893776_2190TABLE PARTITION160.00

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSSYSAUXSMON_SCN_TIME TABLE180.02
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION170.02
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX160.02
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION140.02
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE100.01

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION1300.02

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
TPCHTPCH_REF_DATAH_LINEITEM TABLE13551.53
TPCHTPCH_REF_DATAH_ORDER TABLE10540.08
TPCHTPCH_REF_DATAH_PARTSUPP TABLE155.73
SYSSYSTEMI_OBJ2 INDEX62.29

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX43226.73
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX24014.85
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION22413.86
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1200893776_2190INDEX PARTITION804.95
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE804.95

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control490.000 21
dc_files800.000 080
dc_global_oids3060.000 0111
dc_histogram_data70.000 01,857
dc_histogram_defs2900.000 04,762
dc_objects7010.000 43,153
dc_profiles590.000 02
dc_rollback_segments9660.000 039
dc_segments3320.000 71,178
dc_tablespaces2,8940.000 084
dc_users6,9480.000 0118
global database name1,6380.000 01
outstanding_alerts2380.000 179
sch_lj_oids30.000 06


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY7440.001,4130.0000
DBLINK330.000 00
EDITION670.001250.0000
QUEUE420.001400.0000
RULESET10.0010.0000
SCHEMA730.000 00
SQL AREA1,1684.3710,7860.7300
SUBSCRIPTION80.0080.0000
TABLE/PROCEDURE9000.002,1880.0000
TRIGGER80.00390.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 cache396.00396.00396.00432.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target152.00152.00152.00152.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target752.00752.00752.00752.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool4.004.004.004.000STA/
large pool8.008.008.008.000STA/
shared pool328.00328.00292.00328.000GRO/IMM
streams pool4.004.004.004.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
BOther177.18 5.068.2730313535
 Freeable8.190.000.911.134 99
 SQL0.740.660.060.1712137
 PL/SQL0.490.410.010.04023333
EOther179.07 5.128.2530313535
 Freeable8.440.000.941.134 99
 SQL0.730.640.060.1612137
 PL/SQL0.490.410.010.04013333

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers415,236,096 
Fixed Size2,217,712 
Redo Buffers6,721,536 
Variable Size385,878,288 

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 pool6.566.560.00
largefree memory1.061.060.00
sharedASH buffers4.004.000.00
sharedCCUR22.7822.960.78
sharedFileOpenBlock3.793.790.00
sharedKCB Table Scan Buffer3.803.800.00
sharedKGLH08.648.61-0.36
sharedKGLHD11.3111.340.24
sharedKGLS11.9011.67-1.86
sharedKGLSG5.025.020.00
sharedKSFD SGA I/O b3.793.790.00
sharedPCUR20.6020.680.39
sharedPLDIA3.893.82-1.70
sharedPLMCD12.3312.33-0.03
sharedSQLA83.7884.120.41
shareddbwriter coalesce buffer3.793.790.00
sharedflashback generation buff3.803.800.00
sharedfree memory43.6943.39-0.68
sharedkglsim hash table bkts4.004.000.00
sharedprivate strands3.513.510.00
sharedrow cache7.237.230.00
streamsKTG hash buckets1.261.260.00
streamsfree memory2.732.730.00
 buffer_cache396.00396.000.00
 fixed_sga2.112.110.00
 log_buffer6.416.410.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves1123 18:57:480.030.000.00
QMON Coordinator1123 18:57:380.010.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(11324) 10100.000.000.000.000.0022.08
SYS.AQ$_ALERT_QT_E(11323) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(82486) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(82156) 39390.000.000.081.090.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(11324) 0.000.000.00 
SYS.AQ$_ALERT_QT_E(11323) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(82486) 0.000.00  
SYSMAN.MGMT_TASK_Q(82156) 0.020.020.000.03

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
B1GR2BASE_3938_ORCL(62)/SYS.ALERT_QUE 1000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   
TRAINING_1830_ORCL(41)/SYS.ALERT_QUE 1000.000.000.00
TRAINING_3872_ORCL(61)/SYS.ALERT_QUE 1000.000.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
processes36129150150


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
2,2950.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.002,2950.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_enable_automatic_maintenance0  
audit_file_dest/u01/app/oracle/admin/orcl/adump  
audit_trailDB  
compatible11.2.0.0.0  
control_files+DATA/orcl/controlfile/current.257.716404861, +FRA/orcl/controlfile/current.256.716404861  
db_block_size8192  
db_cache_size394264576  
db_create_file_dest+DATA  
db_create_online_log_dest_1+DATA  
db_domain    
db_nameorcl  
db_recovery_file_dest+FRA  
db_recovery_file_dest_size17179869184  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=orclXDB)  
java_pool_size4194304  
job_queue_processes1000  
large_pool_size4194304  
open_cursors300  
pga_aggregate_target157286400  
processes150  
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan    
service_namesorcl, OLTP, DSS, ADHOC, BATCH_STD, BATCH_LOW  
sga_max_size813694976  
sga_target788529152  
shared_pool_size134217728  
streams_pool_size4194304  
timed_statisticsTRUE  
undo_tablespaceUNDOTBS1  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report