WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORCL1306904245orcl122-Aug-12 12:0811.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
1AXDXPL14WV0L1Microsoft Windows IA (32-bit) 2 2 1 3.45

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:8022-Aug-12 13:04:3622 1.7
End Snap:8122-Aug-12 13:07:1924 1.4
Elapsed:  2.72 (mins)  
DB Time:  6.58 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 424M 424MStd Block Size: 8K
Shared Pool Size: 264M 264MLog Buffer: 5,124K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 2.4 0.0 0.00 0.00
DB CPU(s): 0.7 0.0 0.00 0.00
Redo size: 980,863.8 500.8  
Logical reads: 14,047.0 7.2  
Block changes: 7,883.5 4.0  
Physical reads: 0.6 0.0  
Physical writes: 29.6 0.0  
User calls: 7,834.7 4.0  
Parses: 4.7 0.0  
Hard parses: 0.4 0.0  
W/A MB processed: 0.2 0.0  
Logons: 0.1 0.0  
Executes: 1,972.9 1.0  
Rollbacks: 0.0 0.0  
Transactions: 1,958.6   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 99.99
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 100.15Soft Parse %: 92.50
Execute to Parse %: 99.76Latch Hit %: 99.61
Parse CPU to Parse Elapsd %: 78.07% Non-Parse CPU: 95.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 51.73 52.58
% SQL with executions>1: 76.24 83.24
% Memory for SQL w/exec>1: 60.84 70.91

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
log file sync320,008289173.13Commit
DB CPU 109 27.56 
SQL*Net message to client640,097200.43Network
log file switch completion121700.21Configuration
Disk file operations I/O250170.11User I/O

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

Load Average BeginLoad Average End%User%System%WIO%Idle
   38.6 34.0  27.4
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
42.8 59.0 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 3,535.8 3,535.8
SGA use (MB): 736.0 736.0
PGA use (MB): 32.6 32.3
% Host Mem used for SGA+PGA: 21.74 21.73

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU108.8827.56
sql execute elapsed time32.768.29
parse time elapsed11.272.85
hard parse elapsed time0.130.03
hard parse (sharing criteria) elapsed time0.130.03
PL/SQL execution elapsed time0.120.03
connection management call elapsed time0.020.00
PL/SQL compilation elapsed time0.000.00
repeated bind elapsed time0.000.00
DB time395.09 
background elapsed time144.77 
background cpu time30.92 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME11,843 
AVG_IDLE_TIME4,467 
AVG_SYS_TIME5,545 
AVG_USER_TIME6,295 
BUSY_TIME23,699 
IDLE_TIME8,945 
SYS_TIME11,101 
USER_TIME12,598 
PHYSICAL_MEMORY_BYTES3,707,600,896 
NUM_CPUS2 
NUM_CPU_CORES2 
NUM_CPU_SOCKETS1 
TCP_RECEIVE_SIZE_MAX64,512 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
22-Aug 13:04:360.00     
22-Aug 13:07:190.0072.6038.5934.0127.400.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Commit320,0080289173.13
DB CPU  109 27.56
Network640,0970200.43
Configuration1801680.31
User I/O6901100.18
Concurrency2,4210000.10
System I/O1340020.06
Other2040000.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sync320,008028911.0073.13
SQL*Net message to client640,0970202.000.43
log file switch completion1201700.000.21
Disk file operations I/O2500170.000.11
log file switch (checkpoint incomplete)600640.000.10
control file sequential read1340020.000.06
library cache lock300740.000.06
db file sequential read290060.000.04
db file scattered read150080.000.03
latch: In memory undo latch1,4330000.000.01
buffer busy waits8210000.000.01
cursor: pin S wait on X200140.000.01
cursor: pin S340010.000.00
library cache: mutex X30050.000.00
enq: TX - contention170010.000.00
latch: enqueue hash chains470000.000.00
latch free1030000.000.00
latch: cache buffers chains1250000.000.00
latch: undo global data140000.000.00
jobq slave wait3601001805000.00 
SQL*Net message from client640,097015402.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 write189,075010410.5972.18
db file parallel write5590350.002.02
control file sequential read2170170.000.98
control file parallel write1390150.000.52
db file async I/O submit3100120.000.35
os thread startup800320.000.17
direct path read1100150.000.11
log file sequential read1000110.000.07
LGWR wait for redo copy2,6890000.010.04
direct path write50060.000.02
db file sequential read20090.000.01
log file single write100010.000.01
reliable message500000.000.00
latch: redo allocation250000.000.00
rdbms ipc message73,75211,651220.23 
Space Manager: slave idle wait718732846210.00 
DIAG idle wait32710032710000.00 
smon timer100323323340.00 
shared server idle wait6100180300100.00 
dispatcher timer3100180600100.00 
pmon timer569516429270.00 
Streams AQ: qmn slave idle wait50140280090.00 
Streams AQ: qmn coordinator idle wait956140155610.00 
SQL*Net message from client200010.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
Disk file operations I/O2619.215.419.2 15.411.519.2 
LGWR wait for redo copy2689100.0.0      
SQL*Net message to client640.1K100.0       
asynch descriptor resize13100.0       
buffer busy waits822100.0       
control file parallel write139 33.839.612.95.07.21.4 
control file sequential read35142.224.212.06.311.43.4.6 
cursor: pin S3494.1 2.92.9    
cursor: pin S wait on X2    100.0   
db file async I/O submit31084.85.8.31.06.51.3.3 
db file parallel write55927.219.022.020.25.73.62.3 
db file scattered read128.38.316.716.741.78.3  
db file sequential read2821.414.37.117.928.610.7  
direct path read119.1  27.318.245.5  
direct path write5 20.020.040.020.0   
enq: FB - contention5100.0       
enq: TX - contention1782.417.6      
latch free108100.0       
latch: In memory undo latch1433100.0       
latch: cache buffers chains125100.0       
latch: enqueue hash chains47100.0       
latch: messages19100.0       
latch: redo allocation25100.0       
latch: session allocation1100.0       
latch: undo global data14100.0       
library cache lock3      100.0 
library cache: mutex X366.7   33.3   
log file parallel write189.1K97.31.6.6.3.1.1.1 
log file sequential read1010.010.020.020.020.020.0  
log file single write1070.020.010.0     
log file switch (checkpoint incomplete)6     33.366.7 
log file switch completion12      100.0 
log file sync320K92.15.51.1.6.4.2.1 
os thread startup8     62.537.5 
reliable message5098.02.0      
DIAG idle wait326      100.0 
SQL*Net message from client640.1K99.6.3.1.0.0.0  
Space Manager: slave idle wait721.4   1.4 2.894.4
Streams AQ: qmn coordinator idle wait944.4      55.6
Streams AQ: qmn slave idle wait5       100.0
class slave wait2100.0       
dispatcher timer3       100.0
jobq slave wait359      100.0 
pmon timer56       100.0
rdbms ipc message73.8K98.7.2.0.0.0.0.5.6
shared server idle wait6       100.0
smon timer10      60.040.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
Disk file operations I/O580.815.43.8     
control file parallel write298.6.7.7     
control file sequential read299.4.3  .3   
db file async I/O submit199.7 .3     
db file parallel write1397.71.6.5.2    
library cache lock3 33.366.7     
log file parallel write10699.9.0.0.0.0   
log file switch (checkpoint incomplete)433.3 66.7     
log file switch completion12 66.733.3     
log file sync48099.9.1.0.0.0.0  
os thread startup362.537.5      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS39510902,292
SYS$BACKGROUND0003
orcl.usf.ad.usfood.local0000
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
SYS$USERS 69124210006400972
SYS$BACKGROUND 180900000

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
0.3910.390.1051.6745.931uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
0.3410.340.0995.520.00dayq182sk41ks   insert into wrh$_memory_target...
0.3410.340.0995.660.00bm2pwrpcr8ru6   select sga_size s, sga_size_fa...
0.3410.340.09101.950.00bunssq950snhf   insert into wrh$_sga_target_ad...
0.2730.090.0746.6536.356gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.2550.050.066.2847.672ts960gft6nsd SQL*Plus select name n from v$database
0.1310.130.0311.8795.08350myuyx0t1d6   insert into wrh$_tablespace_st...
0.10130.010.020.0097.7818naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
0.085480.000.0257.1821.553c1kubcdjnppq   update sys.col_usage$ set equa...
0.0710.070.0266.8245.586ajkhukk78nsr   begin prvt_hdm.auto_execute( :...

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
0.3410.340.320.34101.950.00bunssq950snhf   insert into wrh$_sga_target_ad...
0.3310.330.300.3495.660.00bm2pwrpcr8ru6   select sga_size s, sga_size_fa...
0.3310.330.300.3495.520.00dayq182sk41ks   insert into wrh$_memory_target...
0.2010.200.190.3951.6745.931uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
0.1330.040.110.2746.6536.356gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.055480.000.040.0857.1821.553c1kubcdjnppq   update sys.col_usage$ set equa...
0.0510.050.040.03142.300.005dfmd823r8dsp   insert into wrh$_memory_resize...
0.0510.050.040.0766.8245.586ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.02120.000.010.001098.800.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
0.0210.020.010.01120.980.000bdpb49gvdzgg   insert into wrh$_tempstatxs (s...

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
0.1810.1819.370.3951.6745.931uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
0.1310.1313.430.1311.8795.08350myuyx0t1d6   insert into wrh$_tablespace_st...
0.1250.0212.730.256.2847.672ts960gft6nsd SQL*Plus select name n from v$database
0.1030.0310.450.2746.6536.356gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.09130.0110.070.100.0097.7818naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
0.0610.066.380.060.0097.630z1031991bd7w   insert into wrh$_sysmetric_sum...
0.0310.033.430.0766.8245.586ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.0310.033.210.030.0096.414rcrxkvaqt37f   insert into wrh$_shared_pool_a...
0.03660.003.210.030.0090.395h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
0.0310.032.920.030.0096.31d87cd6s72f197   insert into wrh$_seg_stat (sna...
0.025480.001.900.0857.1821.553c1kubcdjnppq   update sys.col_usage$ set equa...

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
3,17931,059.670.140.2746.636.36gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
2,23512,235.000.100.3951.745.91uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
1,8545483.380.080.0857.221.53c1kubcdjnppq   update sys.col_usage$ set equa...
8571857.000.040.0766.845.66ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
6421584.060.030.0100cm5vu20fhtnq1   select /*+ connect_by_filterin...
514957.110.020.0284.303am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
378399.690.020.01034.98vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
3311122.960.010.01104.30g00cj285jmgsw   update sys.mon_mods$ set inser...
240663.640.010.03090.45h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
2011020.100.010.01004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
58158.0063.040.3951.6745.931uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
616.006.520.030.0096.31d87cd6s72f197   insert into wrh$_seg_stat (sna...
515.005.430.060.0097.630z1031991bd7w   insert into wrh$_sysmetric_sum...
313.003.260.030.0096.414rcrxkvaqt37f   insert into wrh$_shared_pool_a...
3660.053.260.030.0090.395h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
313.003.260.0766.8245.586ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
25480.002.170.0857.1821.553c1kubcdjnppq   update sys.col_usage$ set equa...
0460.000.000.000.000.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
0120.000.000.001098.800.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
010.000.000.01120.980.000bdpb49gvdzgg   insert into wrh$_tempstatxs (s...

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
6060160.000.00113.211uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
353557.000.0066.042ts960gft6nsd SQL*Plus select name n from v$database
3232132.000.0060.381cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
1212112.000.0022.643jyk0fjp6yjyf   INSERT INTO wrh$_tempfile (sna...
7717.000.0013.2135y2u24f4rxqm   insert into wrh$_seg_stat_obj ...
7717.000.0013.21934ur8r7tqbjx   SELECT DBID FROM V$DATABASE
4414.000.007.551tn90bbpyjshq   UPDATE wrh$_tempfile tfh SET (...
33660.050.005.665h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
225480.000.003.773c1kubcdjnppq   update sys.col_usage$ set equa...
00460.00 0.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
5485481.000.0857.221.53c1kubcdjnppq   update sys.col_usage$ set equa...
20400.000.0100b2gnxm5z6r51n   lock table sys.col_usage$ in e...
1584212.660.0100cm5vu20fhtnq1   select /*+ connect_by_filterin...
11200.000.0000350f5yrnnmshs   lock table sys.mon_mods$ in ex...
1121080.960.01104.30g00cj285jmgsw   update sys.mon_mods$ set inser...
66661.000.03090.45h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
54541.000.0000bsa0wjtftg3uw   select file# from file$ where ...
46461.000.0000089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
39391.000.01005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
39391.000.01034.98vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
20420426.84b2gnxm5z6r51n   lock table sys.col_usage$ in e...
11211214.74350f5yrnnmshs   lock table sys.mon_mods$ in ex...
881.050k8522rmdzg4k   select privilege# from sysauth...
81581.05cm5vu20fhtnq1   select /*+ connect_by_filterin...
6540.79bsa0wjtftg3uw   select file# from file$ where ...
550.660ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
550.662ts960gft6nsd SQL*Plus select name n from v$database
550.66459f3z9u4fb3u   select value$ from props$ wher...
550.664vs91dcv7u1p6 sqlplus.exe insert into sys.aud$( sessioni...
550.665qgz1p0cut7mx sqlplus.exe BEGIN DBMS_OUTPUT.DISABLE; END...

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
0bdpb49gvdzgginsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select /*+ leading (tf ts ftio fn fw) */ :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and ftio.kcftiofno = tf.tfnum and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0z1031991bd7winsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
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))
1cq3qr774cu45insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1tn90bbpyjshqUPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id
1uk5m5qbzj1vtBEGIN dbms_workload_repository.create_snapshot; END;
2ts960gft6nsdselect name n from v$database
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
35y2u24f4rxqminsert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3jyk0fjp6yjyfINSERT INTO wrh$_tempfile (snap_id, dbid, file#, creation_change#, filename, ts#, tsname, block_size) SELECT :lah_snap_id lah, :dbid dbid, tf.file# file#, tf.creation_change# cr_chg#, tf.name name, ts.ts# ts#, ts.name tsname, tf.block_size block_size FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND not exists (SELECT 1 FROM wrh$_tempfile tfh WHERE tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change# AND tfh.dbid = :dbid2)
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4jrfrtx4u6zcxSELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4rcrxkvaqt37finsert into wrh$_shared_pool_advice (snap_id, dbid, instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits) select :snap_id, :dbid, :instance_number, shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects, estd_lc_time_saved, estd_lc_time_saved_factor, estd_lc_load_time, estd_lc_load_time_factor, estd_lc_memory_object_hits from v$shared_pool_advice
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5dfmd823r8dspinsert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5qgz1p0cut7mxBEGIN DBMS_OUTPUT.DISABLE; END;
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
934ur8r7tqbjxSELECT DBID FROM V$DATABASE
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bm2pwrpcr8ru6select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d87cd6s72f197insert into wrh$_seg_stat (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delta, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta) select :snap_id, :dbid, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts_drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, chn_exc_kewrseg, chn_exc_dl_kewrseg, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg
dayq182sk41ksinsert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
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 (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced10.010.00
CCursor + sql area evicted00.000.00
CPU used by this session8,61152.700.03
CPU used when call started8,59952.630.03
CR blocks created210.130.00
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time55,918342.220.17
DBWR checkpoint buffers written4,81929.490.02
DBWR checkpoints50.030.00
DBWR object drop buffers written00.000.00
DBWR thread checkpoint buffers written4,30826.360.01
DBWR transaction table writes640.390.00
DBWR undo block writes3,64122.280.01
HSC Heap Segment Block Changes321,1121,965.191.00
Heap Segment Array Inserts880.540.00
Heap Segment Array Updates200.120.00
IMU CR rollbacks200.120.00
IMU Flushes18,357112.340.06
IMU Redo allocation size7,081,47643,338.2922.13
IMU commits298,6131,827.500.93
IMU contention16,920103.550.05
IMU ktichg flush00.000.00
IMU pool not allocated3,08318.870.01
IMU recursive-transaction flush10.010.00
IMU undo allocation size125,513,152768,134.35392.18
IMU- failed to get a private strand3,08318.870.01
Requests to/from client640,0973,917.362.00
RowCR attempts60.040.00
RowCR hits60.040.00
SMON posted for undo segment shrink70.040.00
SQL*Net roundtrips to/from client640,0973,917.362.00
active txn count during cleanout11,50770.420.04
application wait time00.000.00
background checkpoints completed30.020.00
background checkpoints started50.030.00
background timeouts7854.800.00
buffer is not pinned count4,62628.310.01
buffer is pinned count1,6189.900.01
bytes received via SQL*Net from client129,305,538791,343.56404.03
bytes sent via SQL*Net to client88,990,060544,614.81278.06
calls to get snapshot scn: kcmgss322,5721,974.121.01
calls to kcmgas320,7231,962.811.00
calls to kcmgcs321,0701,964.931.00
cell physical IO interconnect bytes255,357,4401,562,775.03797.89
change write time5483.350.00
cleanout - number of ktugct calls26,455161.900.08
cleanouts only - consistent read gets10.010.00
cluster key scan block gets210.130.00
cluster key scans200.120.00
commit batch/immediate performed30.020.00
commit batch/immediate requested30.020.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: callback failure60.040.00
commit cleanout failures: cannot pin14,31887.630.04
commit cleanouts320,8771,963.751.00
commit cleanouts successfully completed306,5531,876.090.96
commit immediate performed30.020.00
commit immediate requested30.020.00
commit txn count during cleanout28,239172.820.09
concurrency wait time650.400.00
consistent changes420.260.00
consistent gets367,0822,246.521.15
consistent gets - examination43,603266.850.14
consistent gets direct00.000.00
consistent gets from cache367,0822,246.521.15
consistent gets from cache (fastpath)323,1521,977.671.01
cursor authentications1070.650.00
data blocks consistent reads - undo records applied240.150.00
db block changes1,288,1667,883.514.03
db block gets1,928,19611,800.476.02
db block gets direct00.000.00
db block gets from cache1,928,19611,800.476.02
db block gets from cache (fastpath)519,4633,179.091.62
deferred (CURRENT) block cleanout applications308,9931,891.020.97
enqueue conversions2511.540.00
enqueue releases642,8643,934.302.01
enqueue requests642,8643,934.302.01
enqueue timeouts00.000.00
enqueue waits220.130.00
execute count322,3791,972.941.01
file io service time00.000.00
file io wait time49,747,815304,454.19155.44
free buffer requested5,31332.520.02
heap block compress50.030.00
immediate (CR) block cleanout applications10.010.00
immediate (CURRENT) block cleanout applications1150.700.00
in call idle wait time325,8321,994.081.02
index crx upgrade (positioned)00.000.00
index fast full scans (full)00.000.00
index fetch by key1,77110.840.01
index scans kdiixs11,0316.310.00
leaf node 90-10 splits110.070.00
leaf node splits160.100.00
lob writes180.110.00
lob writes unaligned180.110.00
logical read bytes from cache18,802,917,376115,072,933.7658,751.77
logons cumulative160.100.00
max cf enq hold time00.000.00
messages received189,7541,161.290.59
messages sent189,7541,161.290.59
min active SCN optimization applied on CR760.470.00
no work - consistent read gets2,29614.050.01
non-idle wait count1,481,2439,065.134.63
non-idle wait time40,393247.200.13
opened cursors cumulative642,1943,930.202.01
parse count (describe)00.000.00
parse count (hard)570.350.00
parse count (total)7604.650.00
parse time cpu4382.680.00
parse time elapsed5613.430.00
physical read IO requests530.320.00
physical read bytes753,6644,612.392.35
physical read total IO requests4192.560.00
physical read total bytes6,550,52840,088.9120.47
physical read total multi block requests00.000.00
physical reads920.560.00
physical reads cache770.470.00
physical reads cache prefetch390.240.00
physical reads direct150.090.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup390.240.00
physical write IO requests7594.650.00
physical write bytes39,600,128242,350.84123.73
physical write total IO requests194,1751,188.340.61
physical write total bytes248,806,9121,522,686.12777.42
physical write total multi block requests2321.420.00
physical writes4,83429.580.02
physical writes direct150.090.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache4,81929.490.02
physical writes non checkpoint3,75622.990.01
process last non-idle time1641.000.00
recursive calls328,7562,011.971.03
recursive cpu usage1,3168.050.00
redo blocks checksummed by FG (exclusive)1,4458.840.00
redo blocks written399,7012,446.151.25
redo buffer allocation retries180.110.00
redo entries347,1462,124.521.08
redo log space requests230.140.00
redo log space wait time1220.750.00
redo ordering marks2061.260.00
redo size160,273,152980,863.84500.79
redo size for direct writes00.000.00
redo subscn max counts3602.200.00
redo synch long waits1180.720.00
redo synch poll writes00.000.00
redo synch polls00.000.00
redo synch time29,252179.020.09
redo synch time (usec)292,535,1381,790,300.72914.06
redo synch writes320,0341,958.591.00
redo wastage37,522,776229,637.55117.24
redo write time10,72165.610.03
redo writes189,0751,157.130.59
rollback changes - undo records applied30.020.00
rollbacks only - consistent read gets120.070.00
rows fetched via callback8185.010.00
session connect time1641.000.00
session cursor cache hits117,148716.940.37
session logical reads2,295,27814,046.997.17
shared hash latch upgrades - no wait6163.770.00
shared hash latch upgrades - wait00.000.00
sorts (memory)6133.750.00
sorts (rows)6,32438.700.02
sql area evicted00.000.00
sql area purged00.000.00
switch current to new buffer280.170.00
table fetch by rowid1,76210.780.01
table fetch continued row00.000.00
table scan blocks gotten4282.620.00
table scan rows gotten44,463272.110.14
table scans (long tables)00.000.00
table scans (short tables)1100.670.00
total cf enq hold time1,0786.600.00
total number of cf enq holders150.090.00
total number of times SMON posted100.060.00
transaction rollbacks30.020.00
undo change vector size42,644,828260,984.26133.25
user I/O wait time930.570.00
user calls1,280,1827,834.654.00
user commits320,0401,958.631.00
workarea executions - optimal3602.200.00
write clones created in background00.000.00
write clones created in foreground170.100.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current3733
logons current2224
session uga memory max198,178,696211,750,356
session pga memory159,907,896164,993,332
session pga memory max183,648,956188,734,392
session cursor cache count6,1976,509
session uga memory339,323,629,008352,209,440,712

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)5110.16

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)
LGWR1M0.54.006119196M1182.611.19951189.2K0.56
DBWR0M0.000M38M4.55.2325580 
Others4M1.70.0244793M1.08.0183593655.32
Buffer Cache Reads0M0.210M0M0.000M357.49
Direct Reads0M0.090M0M0.000M0 
Direct Writes0M0.000M0M0.090M0 
TOTAL:5M2.55.030599237M1188.331.45042189.6K0.57

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
Log File0M0.060M194M1182.001.1872710.50 
Data File1M0.34.00611939M4.65.23867815.53 
Control File6M2.15.0367195M1.69.0305994.67 
TOTAL:7M2.55.042839238M1188.331.456546.25 

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)
LGWR 1M0.54.006119196M1182.611.19951994.41
LGWR (Log File) 0M0.060M194M1182.001.18727205.85
LGWR (Control File) 1M0.48.0061192M0.61.012239794.05
DBWR 0M0.000M38M4.55.2325580 
DBWR (Data File) 0M0.000M38M4.55.2325580 
Others 4M1.70.0244793M1.08.0183592774.87
Others (Control File) 4M1.66.0244793M1.08.0183592724.85
Others (Data File) 0M0.030M0M0.000M56.00
Buffer Cache Reads 0M0.210M0M0.000M357.49
Buffer Cache Reads (Data File) 0M0.210M0M0.000M357.49
Direct Reads 0M0.090M0M0.000M0 
Direct Reads (Data File) 0M0.090M0M0.000M0 
Direct Writes 0M0.000M0M0.090M0 
Direct Writes (Data File) 0M0.000M0M0.090M0 
TOTAL: 5M2.55.030599237M1188.331.450424114.98

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX 4206.672.07345200.00
UNDOTBS1 300.001.0032523220.03
SYSTEM 504.001.0043000.00
USERS 300.001.004305240.06
EXAMPLE 300.001.003000.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)
EXAMPLEC:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF 300.001.003000.00
SYSAUXC:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF 4206.672.07345200.00
SYSTEMC:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 504.001.0043000.00
UNDOTBS1C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF 300.001.0032523220.03
USERSC:\ORACLE\ORADATA\ORCL\USERS01.DBF 300.001.004305240.06

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
D52,7351002,288,740744,81900846

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
04,10100511207

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
B0455733616165888165888465625   
E0852227165739165888165888459700   

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
D400.0951.1415184.00
D800.19101.0514175.00
D1200.28151.0414174.00
D1600.38201.0314173.00
D2000.47251.0214172.00
D2400.57301.0113170.00
D2800.66351.0013170.00
D3200.75401.0013170.00
D3600.85451.0013170.00
D4000.94501.0013170.00
D4241.00531.0013170.00
D4401.04551.0013170.00
D4801.13601.0013170.00
D5201.23651.0013170.00
D5601.32701.0013170.00
D6001.42751.0013170.00
D6401.51801.0013170.00
D6801.60851.0013170.00
D7201.70901.0013170.00
D7601.79951.0013170.00
D8001.891001.0013170.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K33233200
64K128K2200
512K1024K242400
4M8M2200

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
620.13124.860.00100.00056,373
1240.25124.860.00100.00056,373
2480.50124.860.00100.00056,373
3720.75124.860.00100.00056,373
4961.00124.860.00100.00056,373
5951.20124.860.00100.00056,373
6941.40124.860.00100.00056,373
7941.60124.860.00100.00056,373
8931.80124.860.00100.00056,373
9922.00124.860.00100.00056,373
1,4883.00124.860.00100.00056,373
1,9844.00124.860.00100.00056,373
2,9766.00124.860.00100.00056,373
3,9688.00124.860.00100.00056,373

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)
1040.39161,53318,6310.976808.40471
1360.52463,34818,6950.976167.60473
1680.64493,60718,6950.976167.60473
1840.70493,60718,6950.976167.60473
1920.73493,60718,6950.976167.60473
2000.76493,60718,6950.976167.60473
2080.79493,60718,6950.976167.60473
2160.82493,60718,6950.976167.60473
2240.85493,60718,6950.976167.60473
2320.88493,60718,7780.985336.58473
2400.91493,60718,8610.984505.56473
2480.94493,60718,9440.993674.53473
2560.97493,60719,0870.992242.77474
2641.00493,60719,2301.00811.00474
2721.03493,60719,2301.00811.00474
2801.06493,60719,2301.00811.00474
2881.09493,60719,2301.00811.00474
2961.12493,60719,2301.00811.00474
3041.15493,60719,2301.00811.00474
3121.18493,60719,2301.00811.00474
3201.21493,60719,2301.00811.00474
3281.24493,60719,2301.00811.00474
3361.27493,60719,2301.00811.00474
3601.36493,60719,2301.00811.00474
3921.48493,60719,2301.00811.00474
4241.61493,60719,2301.00811.00474
4561.73493,60719,2301.00811.00474
4881.85493,60719,2301.00811.00474
5201.97493,60719,2301.00811.00474
5522.09493,60719,2301.00811.00474

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1840.2519,33315,030
3680.5018,73415,030
5520.7518,72113,371
7361.0018,72113,270
9201.2518,72113,270
1,1041.5018,72113,270
1,2881.7518,72113,270
1,4722.0018,72113,270

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)
81.000000
162.000000
243.000000
324.000000
405.000000
486.000000
567.000000
648.000000
729.000000
8010.000000
8811.000000
9612.000000
10413.000000
11214.000000
12015.000000
12816.000000
13617.000000
14418.000000
15219.000000
16020.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 block48700
undo header32200
segment header1900
1st level bmb1400
2nd level bmb400

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction 318,384319,79701700.00
FB-Format Block 48480500.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch1820.00 00 
ASM map operation hash table10.00 00 
ASM network state latch40.00 00 
AWR Alerted Metric Element list8340.00 00 
Change Notification Hash table latch540.00 00 
Consistent RBA189,0890.00 00 
DML lock allocation641,2140.150.0000 
Event Group Locks300.00 00 
FOB s.o list latch510.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch1,287,7920.230.490320,0890.00
JS Sh mem access10.00 00 
JS broadcast autostart latch30.00 00 
JS queue access latch10.00 00 
JS queue state obj latch1,1520.00 00 
JS slv state obj latch130.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch550.00 00 
KTF sga latch20.00 0530.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch20.00 00 
KWQS pqueue ctx latch220.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  030.00
Memory Management Latch10.00 0550.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 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process870.00 00 
OS process allocation3620.280.0000 
OS process: request allocation240.00 00 
PL/SQL warning settings370.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch20.00 00 
SGA IO buffer pool latch180.00 0180.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch60.00 0540.00
SQL memory manager workarea list latch3,8820.00 00 
Shared B-Tree530.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch6350.00 00 
active service list4710.00 06620.00
buffer pool10.00 00 
business card10.00 00 
cache buffer handles3940.00 00 
cache buffers chains9,024,2070.520.0005,3580.00
cache buffers lru chain4,9970.00 010,5840.03
call allocation2390.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch280.00 00 
channel operations parent latch1,5170.00 00 
checkpoint queue latch12,2360.00 06,3970.03
client/application info700.00 00 
compile environment latch160.00 00 
corrupted undo seg latch120.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch40.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch40.00 00 
dml lock allocation60.00 00 
done queue latch10.00 00 
dummy allocation310.00 00 
enqueue freelist latch10.00 03,5760.00
enqueue hash chains1,286,0171.050.0000 
enqueues40.00 00 
fifth spare latch10.00 00 
file cache latch1110.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.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 SGA50.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch2230.00 02,0670.00
hash table modification latch10.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch40.00 030.00
job_queue_processes free list latch60.00 00 
job_queue_processes parameter latch370.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch50.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch520.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock50.00 00 
ksuosstats global area190.00 00 
ksv allocation latch100.00 00 
ksv class latch50.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch244.170.0000 
ktm global data410.00 00 
kwqbsn:qsga70.00 00 
lgwr LWN SCN189,1790.00 00 
list of block allocation370.00 00 
loader state object freelist360.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch30.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 parent10.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch1570.00 00 
messages493,1811.090.0000 
mostly latch-free SCN189,7600.210.0300 
msg queue latch10.00 00 
multiblock read objects280.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch40.00 00 
object queue header heap1,2500.00 020.00
object queue header operation23,0900.020.0000 
object stats modification1570.00 00 
parallel query alloc buffer250.00 00 
parallel query stats10.00 00 
parameter list240.00 00 
parameter table management1290.780.0000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue348,5760.030.000319,8290.43
process allocation320.00 0130.00
process group creation244.170.0000 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch2015.000.6700 
query server freelists10.00 00 
queued dump request10.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,210,5760.010.380345,8211.25
redo copy10.00 0347,1340.90
redo writing572,0340.000.0000 
resmgr group change latch110.00 00 
resmgr:active threads310.00 00 
resmgr:actses change group110.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list303.330.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config10.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects17,5320.00 00 
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache360.00 00 
session allocation320,1240.090.000320,0990.05
session idle bit2,880,4440.010.2500 
session queue latch10.00 00 
session state list latch260.00 00 
session switching160.00 00 
session timer560.00 00 
shared pool7,0080.360.0000 
shared pool sim alloc30.00 00 
shared pool simulator920.00 00 
sim partition latch10.00 00 
simulator hash latch86,9980.00 00 
simulator lru latch4,3610.00 082,0030.08
sort extent pool200.00 00 
space background state object latch20.00 00 
space background task latch2681.121.0001110.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.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 latch30.00 00 
transaction allocation1950.00 00 
undo global data1,640,0160.600.0000 
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 chains9,024,20746,82512646,700
enqueue hash chains1,286,01713,4844713,437
undo global data1,640,0169,787149,773
messages493,1815,358195,339
In memory undo latch1,287,7922,9411,4341,508
DML lock allocation641,2149794975
mostly latch-free SCN189,76039312381
session idle bit2,880,44434487257
session allocation320,1242731272
redo allocation1,210,576662541
qmn task queue latch20321
space background task latch268330

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam021
DML lock allocationktaidm023
In memory undo latchkticmt: child0879307
In memory undo latchktiFlush: child06581,241
In memory undo latchktichg: child0100
In memory undo latchkticflush_2010
PC and Classifier lists for WLMNo latch020
cache buffers chainskcbgcur: fast path (shr)01,4741,475
cache buffers chainskcbgcur_2079
cache buffers chainskcbnlc060
cache buffers chainskcbrls_2042
cache buffers chainskcbchg1: mod cr pin021
cache buffers chainskcbgcur_4023
cache buffers chainskcbgtcr: fast path024
cache buffers chainskcbchg1: mod cur pin010
cache buffers chainskcbrls: fast release014
cache buffers chainskcbzpbuf010
enqueue hash chainsksqrcl02827
enqueue hash chainsksqgtl301920
messagesksaamb: after wakeup01617
messagesksarcv022
messagesksarcv: after wait010
mostly latch-free SCNkcs050100
mostly latch-free SCNkcs040212
qmn task queue latchkwqmnmvtsks: delay to ready list020
redo allocationkcrfw_redo_gen: redo allocation 10250
session allocationksucri_int : SSO010
session idle bitksupuc: set busy06317
session idle bitksupuc: clear busy02242
session idle bitksuxds0329
space background task latchktsj_grab_task013
undo global dataktudnx:child084
undo global dataktubnd_4030
undo global dataktudba: KSLBEGIN020
undo global dataktufrbs_20110

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkksfbc [KKSCHLPIN1]400
Cursor Pinkkslce [KKSCHLPIN2]60
Library Cachekglati1 4550
Cursor PinkksLockDelete [KKSCHLPIN6]40
Library Cachekglget2 210

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
TESTUSERUSERSTESTTABLE TABLE1,286,68856.06
SYSSYSTEMI_COL_USAGE$ INDEX1,0560.05
SYSSYSTEMI_SYSAUTH1 INDEX8320.04
SYSSYSTEMCOL_USAGE$ TABLE5440.02
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE3520.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE3133.70
SYSSYSAUXWRH$_SQLTEXT TABLE1213.04
SYSSYSAUXWRH$_MVPARAMETER_PKWRH$_MVPARA_1306904245_58INDEX PARTITION55.43
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY TABLE55.43
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX55.43

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE1630.19
SYSSYSAUXWRH$_MVPARAMETER_PKWRH$_MVPARA_1306904245_58INDEX PARTITION47.55
SYSSYSAUXWRH$_OSSTAT_PKWRH$_OSSTAT_1306904245_58INDEX PARTITION35.66
SYSSYSAUXWRI$_ADV_PARAMETERS_PK INDEX35.66
SYSSYSTEMCOL_USAGE$ TABLE23.77

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE1630.19
SYSSYSAUXWRH$_MVPARAMETER_PKWRH$_MVPARA_1306904245_58INDEX PARTITION47.55
SYSSYSAUXWRH$_OSSTAT_PKWRH$_OSSTAT_1306904245_58INDEX PARTITION35.66
SYSSYSAUXWRI$_ADV_PARAMETERS_PK INDEX35.66
SYSSYSTEMCOL_USAGE$ TABLE23.77

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
TESTUSERUSERSTESTTABLE TABLE51510.65
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_1306904245_58INDEX PARTITION240.50
SYSSYSTEMCOL_USAGE$ TABLE190.39
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1306904245_58TABLE PARTITION150.31
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1306904245_58TABLE PARTITION150.31

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
TESTUSERUSERSTESTTABLE TABLE364.74
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX101.32
SYSSYSAUXWRH$_SQL_PLAN TABLE81.05
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX60.79
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1306904245_58TABLE PARTITION60.79

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

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
TESTUSERUSERSTESTTABLE TABLE6,19279.96
SYSSYSTEMCOL_USAGE$ TABLE5286.82
SYSSYSTEMMON_MODS$ TABLE1281.65
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_1306904245_58INDEX PARTITION1281.65
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE961.24

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

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
TESTUSERUSERSTESTTABLE TABLE524100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control60.000 21
dc_global_oids430.000 052
dc_histogram_data3140.000 01,359
dc_histogram_defs2,0190.050 04,066
dc_object_grants190.000 069
dc_objects6560.910 01,804
dc_profiles80.000 01
dc_rollback_segments730.000 034
dc_segments3850.260 8677
dc_tablespaces8910.000 07
dc_users1,3550.070 0103
global database name1190.000 01


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS100.000 00
BODY910.001340.0000
CLUSTER10.0010.0000
DBLINK100.000 00
EDITION80.00160.0000
INDEX120.00120.0000
QUEUE70.00290.0000
SCHEMA120.000 00
SQL AREA6160.32322,701-0.1711
SQL AREA BUILD653.080 00
SQL AREA STATS6598.466598.4600
SUBSCRIPTION10.0010.0000
TABLE/PROCEDURE3431.171,1660.6000
TRIGGER100.00190.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 cache424.00424.00424.00424.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target496.00496.00496.00496.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target736.00736.00736.00736.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool24.0024.0024.0024.000STA/
large pool8.008.008.008.000STA/
shared pool264.00264.00264.00264.000STA/
streams pool8.008.008.008.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther32.04 1.331.24552424
SQL0.510.420.050.1404117
PL/SQL0.340.280.020.03002222
EOther31.74 1.221.14552626
SQL0.450.380.040.1104128
PL/SQL0.340.280.010.03002424

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers444,596,224 
Fixed Size1,384,856 
Redo Buffers5,246,976 
Variable Size327,159,400 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory24.0024.000.00
largePX msg pool0.470.470.00
largefree memory7.537.530.00
sharedASH buffers4.004.000.00
sharedKCB Table Scan Buffer4.004.000.00
sharedKGLH020.3521.013.23
sharedKGLHD3.974.000.79
sharedKGLS10.4610.470.11
sharedKGLSG3.523.520.00
sharedKQR M PO2.872.880.12
sharedKSFD SGA I/O b4.004.000.00
sharedPLDIA2.712.710.00
sharedPLMCD5.445.440.00
sharedSQLA17.6419.088.16
shareddbwriter coalesce buffer4.004.000.00
sharedevent statistics per sess3.103.100.00
sharedfree memory127.42125.18-1.76
sharedksunfy : SSO free list2.692.690.00
sharedrow cache3.623.620.00
streamsfree memory8.008.000.00
 buffer_cache424.00424.000.00
 fixed_sga1.321.320.00
 log_buffer5.005.000.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 Coordinator0822 12:01:200.000.000.00
QMON Slaves0822 12:01:300.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12733) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(12732) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 10100.000.000.000.010.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(12733) 0.000.00  
SYS.AQ$_ALERT_QT_E(12732) 0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 0.060.060.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE 000   
LOCALHOST_3938_ORCL(41)/SYS.ALERT_QUE 0000.000.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
1630.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.001630.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_destC:\ORACLE\ADMIN\ORCL\ADUMP  
audit_trailDB  
compatible11.2.0.0.0  
control_filesC:\ORACLE\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL  
db_block_size8192  
db_domainusf.ad.usfood.local  
db_nameorcl  
db_recovery_file_destC:\oracle\fast_recovery_area  
db_recovery_file_dest_size4353687552  
diagnostic_destC:\ORACLE  
dispatchers(PROTOCOL=TCP) (SERVICE=orclXDB)  
event10503 trace name context forever, level 4000  
local_listenerLISTENER_ORCL  
memory_target1291845632  
open_cursors300  
processes150  
remote_login_passwordfileEXCLUSIVE  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_filesC:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL  
C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report