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:8122-Aug-12 13:07:1924 1.4
End Snap:8222-Aug-12 13:19:0025 1.3
Elapsed:  11.67 (mins)  
DB Time:  240.86 (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): 20.6 0.1 0.04 0.01
DB CPU(s): 0.2 0.0 0.00 0.00
Redo size: 220,214.8 481.8  
Logical reads: 3,477.5 7.6  
Block changes: 1,839.0 4.0  
Physical reads: 0.2 0.0  
Physical writes: 8.9 0.0  
User calls: 1,829.5 4.0  
Parses: 2.0 0.0  
Hard parses: 0.0 0.0  
W/A MB processed: 0.1 0.0  
Logons: 0.1 0.0  
Executes: 461.5 1.0  
Rollbacks: 0.0 0.0  
Transactions: 457.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 99.98
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 100.15Soft Parse %: 99.21
Execute to Parse %: 99.57Latch Hit %: 99.88
Parse CPU to Parse Elapsd %: 57.58% Non-Parse CPU: 95.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 52.58 52.69
% SQL with executions>1: 83.24 77.99
% Memory for SQL w/exec>1: 70.91 64.16

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
log file sync320,09413,5354293.66Commit
DB CPU 123 0.85 
Disk file operations I/O13410750.07User I/O
enq: TX - contention25210380.07Other
enq: FB - contention1135420.03Other

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

Load Average BeginLoad Average End%User%System%WIO%Idle
   75.3 7.5  17.2
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
9.9 11.9 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.3 34.5
% Host Mem used for SGA+PGA: 21.73 21.79

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU123.030.85
sql execute elapsed time87.730.61
parse time elapsed14.560.10
connection management call elapsed time0.800.01
PL/SQL execution elapsed time0.260.00
hard parse elapsed time0.020.00
hard parse (sharing criteria) elapsed time0.000.00
sequence load elapsed time0.000.00
repeated bind elapsed time0.000.00
DB time14,451.67 
background elapsed time653.59 
background cpu time15.03 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME57,990 
AVG_IDLE_TIME12,023 
AVG_SYS_TIME5,229 
AVG_USER_TIME52,748 
BUSY_TIME116,020 
IDLE_TIME24,077 
SYS_TIME10,489 
USER_TIME105,531 
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:07:190.00     
22-Aug 13:19:000.0082.8175.337.4917.190.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,094013,5354293.66
DB CPU  123 0.85
Other682019270.13
Concurrency1,085010100.07
User I/O172010600.07
Configuration32207210.05
System I/O3370380.02
Network640,6690200.01
Application200120.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sync320,094013,535421.0093.66
Disk file operations I/O134010750.000.07
enq: TX - contention252010380.000.07
enq: FB - contention11305420.000.03
buffer busy waits22405210.000.03
log file switch completion6503520.000.02
latch free17803170.000.02
latch: In memory undo latch5380350.000.02
control file sequential read3370380.000.02
latch: cache buffers chains2620280.000.01
SQL*Net message to client640,6690202.000.01
log file switch (private strand flush incomplete)2302730.000.01
enq: HW - contention2340270.000.01
cursor: pin S5101130.000.00
latch: enqueue hash chains870160.000.00
latch: session allocation2400170.000.00
db file sequential read240060.000.00
latch: undo global data230050.000.00
db file scattered read110080.000.00
enq: RO - fast object reuse200120.000.00
local write wait30020.000.00
SQL*Net message from client640,66905,61092.00 
jobq slave wait1,4031007075040.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 write48,4620541110.1582.81
control file sequential read73909130.001.43
db file parallel write68707110.001.11
os thread startup27051840.000.76
control file parallel write39805120.000.72
Disk file operations I/O10021900.000.29
db file async I/O submit6290120.000.18
reliable message1100020.000.04
LGWR wait for redo copy1280020.000.04
direct path read1000230.000.04
log file sequential read800110.000.01
log file single write800100.000.01
latch free200030.000.01
buffer busy waits50060.000.00
direct path write50050.000.00
db file sequential read40070.000.00
latch: In memory undo latch40070.000.00
log file sync100180.000.00
latch: redo allocation40050.000.00
rdbms ipc message17,676217,0603990.06 
Space Manager: slave idle wait403941,96248680.00 
DIAG idle wait1,3981001,40110020.00 
smon timer250791316200.00 
Streams AQ: qmn coordinator idle wait4556700155660.00 
Streams AQ: qmn slave idle wait250700280170.00 
pmon timer2339869429770.00 
shared server idle wait23100690300100.00 
dispatcher timer11100660600200.00 
SQL*Net message from client1360150.00 
class slave wait30020.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/O1442.11.41.44.95.620.863.9 
LGWR wait for redo copy12889.8.81.6.81.63.12.3 
SQL*Net message to client640.8K100.0.0.0.0.0.0.0 
asynch descriptor resize61100.0       
buffer busy waits22943.72.64.43.914.47.423.6 
control file parallel write398 20.622.118.318.89.810.3 
control file sequential read107618.810.813.214.418.817.56.6 
cursor: pin S519.85.911.813.729.423.55.9 
db file async I/O submit62946.635.18.15.62.91.4.3 
db file parallel write68711.46.020.824.320.711.25.7 
db file scattered read11 27.39.19.145.59.1  
db file sequential read2828.610.717.917.925.0   
direct path read10 10.0 30.020.0 40.0 
direct path write560.0  20.0 20.0  
enq: FB - contention1132.71.86.210.635.49.733.6 
enq: HW - contention2346.035.020.57.316.714.1.4 
enq: RO - fast object reuse250.0    50.0  
enq: TX - contention2521.63.26.07.521.020.240.5 
latch free19826.35.69.67.114.119.218.2 
latch: In memory undo latch54267.22.44.64.27.49.84.4 
latch: cache buffers chains26251.52.78.012.25.013.07.6 
latch: enqueue hash chains8756.3 10.39.29.28.06.9 
latch: messages2100.0       
latch: redo allocation475.0    25.0  
latch: redo writing1100.0       
latch: row cache objects6100.0       
latch: session allocation2441.7   37.54.216.7 
latch: shared pool4100.0       
latch: undo global data2360.9 8.78.74.317.4  
local write wait3 66.733.3     
log file parallel write48.5K15.85.211.624.323.811.87.6 
log file sequential read812.512.5 25.012.537.5  
log file single write837.525.0 12.5 12.512.5 
log file switch (private strand flush incomplete)23      100.0 
log file switch completion65     9.290.8 
log file sync320.1K.1.2.63.211.628.655.7 
os thread startup27    22.2 77.8 
reliable message11377.91.84.45.35.35.3  
DIAG idle wait1398      100.0 
SQL*Net message from client640.8K15.213.613.515.127.512.13.0 
Space Manager: slave idle wait403      1.298.8
Streams AQ: qmn coordinator idle wait4533.3 4.4 4.42.2 55.6
Streams AQ: qmn slave idle wait25       100.0
class slave wait333.333.3 33.3    
dispatcher timer11       100.0
jobq slave wait1405    .1 99.9 
pmon timer234      .999.1
rdbms ipc message17.7K44.44.65.65.411.87.310.810.1
shared server idle wait23       100.0
smon timer26      30.869.2

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/O9236.136.19.011.17.6   
LGWR wait for redo copy397.72.3      
SQL*Net message to client1100.0.0      
buffer busy waits5476.415.76.11.7    
control file parallel write4189.78.51.8     
control file sequential read7193.45.7.8.1    
cursor: pin S394.15.9      
db file async I/O submit299.7.3      
db file parallel write3994.34.11.5.1    
direct path read460.040.0      
enq: FB - contention3866.415.04.414.2    
enq: HW - contention199.6 .4     
enq: TX - contention10259.511.529.0     
latch free3681.817.7.5     
latch: In memory undo latch2495.64.4      
latch: cache buffers chains2092.47.6      
latch: enqueue hash chains693.16.9      
latch: session allocation483.38.38.3     
log file parallel write367792.47.1.4.0.0   
log file single write187.512.5      
log file switch (private strand flush incomplete)23 30.469.6     
log file switch completion599.266.224.6     
log file sync178.3K44.338.416.9.3.0.0  
os thread startup2122.23.711.148.13.711.1  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS14,45212302,433
SYS$BACKGROUND0002
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 17210108510006406692
SYS$BACKGROUND 2923650000

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
77.96320,0000.000.5441.195.61crjmvnqggmm7x SQL*Plus insert into testtable values (...
7.43340.220.051.0564.902ts960gft6nsd SQL*Plus select name n from v$database
1.4111.410.0170.9223.751uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
1.0150.200.017.760.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
0.7610.760.010.0077.877mgr3uwydqq8j   select decode(open_mode, 'MOU...
0.74120.060.018.4954.776gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.6210.620.000.0080.64b4qw7n9wg64mh   INSERT /*+ APPEND LEADING(@"SE...
0.4210.420.003.760.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
0.41340.010.000.0098.775j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
0.3310.330.0099.640.00dayq182sk41ks   insert into wrh$_memory_target...

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
32.11320,0000.0026.1077.9641.195.61crjmvnqggmm7x SQL*Plus insert into testtable values (...
1.0011.000.811.4170.9223.751uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
0.3310.330.270.3399.800.00bm2pwrpcr8ru6   select sga_size s, sga_size_fa...
0.3310.330.270.33100.530.00bunssq950snhf   insert into wrh$_sga_target_ad...
0.3310.330.270.3399.640.00dayq182sk41ks   insert into wrh$_memory_target...
0.16320.000.130.12130.630.00b4g1xkhnxf0j8 SQL*Plus SELECT SID, substr(USERNAME, 1...
0.0910.090.080.09105.611.086ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.08340.000.067.431.0564.902ts960gft6nsd SQL*Plus select name n from v$database
0.0850.020.061.017.760.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
0.06120.010.050.748.4954.776gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...

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
4.82340.1438.797.431.0564.902ts960gft6nsd SQL*Plus select name n from v$database
4.37320,0000.0035.1977.9641.195.61crjmvnqggmm7x SQL*Plus insert into testtable values (...
0.5910.594.730.760.0077.877mgr3uwydqq8j   select decode(open_mode, 'MOU...
0.5010.504.000.620.0080.64b4qw7n9wg64mh   INSERT /*+ APPEND LEADING(@"SE...
0.40340.013.250.410.0098.775j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
0.40120.033.250.748.4954.776gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.3310.332.701.4170.9223.751uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
0.13340.001.020.1411.5693.86f711myt0q6cma SQL*Plus insert into sys.aud$( sessioni...
0.1210.120.960.1212.7797.01350myuyx0t1d6   insert into wrh$_tablespace_st...
0.0810.080.680.090.0093.467ydcybv1szhrj   INSERT /*+ LEADING(@"SEL$F5BB7...

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,098,428320,0006.5686.1777.9641.25.6crjmvnqggmm7x SQL*Plus insert into testtable values (...
4,13614,136.000.171.4170.923.81uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
3,77512314.580.160.748.554.86gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
3,2547494.340.130.0837.20cm5vu20fhtnq1   select /*+ connect_by_filterin...
1,37111,371.000.060.09105.61.16ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
9254918.880.040.01000k8522rmdzg4k   select privilege# from sysauth...
2781392.000.010.04005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2621262.000.010.62080.6b4qw7n9wg64mh   INSERT /*+ APPEND LEADING(@"SE...
2541254.000.010.09093.57ydcybv1szhrj   INSERT /*+ LEADING(@"SEL$F5BB7...
1581158.000.010.0000d8mayxqw0wnpv   SELECT OWNER FROM DBA_PROCEDUR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
53153.0051.961.4170.9223.751uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
17117.0016.670.0441.5092.40fnk7155mk2jq6   insert into wrh$_sysmetric_his...
12112.0011.760.0360.0893.180z1031991bd7w   insert into wrh$_sysmetric_sum...
422.003.920.030.0093.960gkq5s6hqx8hy   insert into wrh$_sessmetric_hi...
2320,0000.001.9677.9641.195.61crjmvnqggmm7x SQL*Plus insert into testtable values (...
0640.000.000.000.000.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
0330.000.000.000.000.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
0490.000.000.010.000.000k8522rmdzg4k   select privilege# from sysauth...
010.000.000.00684.410.000pt4jfmq9f1q0   SELECT x.statistic# as stat_id...
0340.000.000.010.000.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...

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
238238347.000.00440.742ts960gft6nsd SQL*Plus select name n from v$database
1191191119.000.00220.371uk5m5qbzj1vt SQL*Plus BEGIN dbms_workload_repository...
5050510.000.0092.59bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
3232132.000.0059.261cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
1010110.000.0018.529dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
7717.000.0012.962cpffmjm98pcm   select name, resetlogs_time, ...
7717.000.0012.9635y2u24f4rxqm   insert into wrh$_seg_stat_obj ...
77240.290.0012.9649s332uhbnsma   declare vsn varchar2(20); beg...
7717.000.0012.967mgr3uwydqq8j   select decode(open_mode, 'MOU...
7717.000.0012.96a2g6ywq35wnsk   SELECT CONTROLFILE_TYPE FROM V...
4422.000.007.410gkq5s6hqx8hy   insert into wrh$_sessmetric_hi...
3313.000.005.569jwc1x1zfz670   SELECT RM.CONF#, RM.NAME, RM.V...
3313.000.005.56aukf94xzh2p3g   declare policy varchar2(512);...
22320,0000.000.003.70crjmvnqggmm7x SQL*Plus insert into testtable values (...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
320,000319,9991.0077.9641.25.6crjmvnqggmm7x SQL*Plus insert into testtable values (...
7492,4023.210.0837.20cm5vu20fhtnq1   select /*+ connect_by_filterin...
139130.090.04005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
64641.000.0000089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
50501.000.0300bsa0wjtftg3uw   select file# from file$ where ...
4976315.570.01000k8522rmdzg4k   select privilege# from sysauth...
39391.000.02200.505kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
34341.000.01000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
34341.007.431.164.92ts960gft6nsd SQL*Plus select name n from v$database
34341.000.0000459f3z9u4fb3u   select value$ from props$ wher...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
49493.530k8522rmdzg4k   select privilege# from sysauth...
497493.53cm5vu20fhtnq1   select /*+ connect_by_filterin...
34342.450ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
34342.452ts960gft6nsd SQL*Plus select name n from v$database
34342.45459f3z9u4fb3u   select value$ from props$ wher...
34342.454vs91dcv7u1p6 sqlplus.exe insert into sys.aud$( sessioni...
34342.455qgz1p0cut7mx sqlplus.exe BEGIN DBMS_OUTPUT.DISABLE; END...
34342.455ur69atw3vfhj   select decode(failover_method,...
34342.457hys3h7ysgf9m sqlplus.exe SELECT ATTRIBUTE, SCOPE, NUMER...
34342.45cw6vxf0kbz3v1 sqlplus.exe SELECT CHAR_VALUE FROM SYSTEM....
34342.45d6vwqbw6r2ffk sqlplus.exe SELECT USER FROM DUAL
34342.45dyk4dprp70d74 SQL*Plus SELECT DECODE('A', 'A', '1', '...
34342.45f711myt0q6cma SQL*Plus insert into sys.aud$( sessioni...
34342.45g4y6nw3tts7cc sqlplus.exe BEGIN DBMS_APPLICATION_INFO.SE...
34342.45g9460ysz75yzc SQL*Plus select user u from dual
33320,0002.38crjmvnqggmm7x SQL*Plus insert into testtable values (...
32322.3157gyskzb9xr9j SQL*Plus begin SELECT sid into :monitor...
32322.31b4g1xkhnxf0j8 SQL*Plus SELECT SID, substr(USERNAME, 1...
32322.31bgxuazsj8dg97 SQL*Plus SELECT SID FROM V$SESSION WHER...
25501.80bsa0wjtftg3uw   select file# from file$ where ...

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
0gkq5s6hqx8hyinsert into wrh$_sessmetric_history (snap_id, dbid, instance_number, begin_time, end_time, sessid, serial#, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, eid, eidsq, intsize_csec, groupid, metricid, value from x$kewmdrmv where groupid = 4
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0pt4jfmq9f1q0SELECT x.statistic# as stat_id, x.keh_id as keh_id, nvl(awr_time.value_diff, 0) as value_diff FROM X$KEHTIMMAP x , (SELECT startsn.stat_id as stat_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid AND startsn.stat_id = endsn.stat_id GROUP BY startsn.stat_id ) awr_time WHERE x.statistic# <> 0 AND x.statistic# = awr_time.stat_id(+) ORDER BY x.keh_id ASC
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
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)
1uk5m5qbzj1vtBEGIN dbms_workload_repository.create_snapshot; END;
2cpffmjm98pcm select name, resetlogs_time, resetlogs_change#, dbid into :dbname:dbname_i, :rlgtime, :rlgscn, :fhdbi:fhdbi_i from v$database
2ts960gft6nsdselect name n from v$database
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_'
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
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)
57gyskzb9xr9jbegin SELECT sid into :monitored_sid from v$session where audsid=USERENV('SESSIONID'); end;
5j0q2df7hm1k2INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5ms6rbzdnq16tselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5qgz1p0cut7mxBEGIN DBMS_OUTPUT.DISABLE; END;
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
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;
7hys3h7ysgf9mSELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
7mgr3uwydqq8j select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 'READ ONLY WITH APPLY', 1, 2) dbstate into :dbstate from v$database
7ydcybv1szhrj INSERT /*+ LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
9dhn1b8d88dpf select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9jwc1x1zfz670SELECT RM.CONF#, RM.NAME, RM.VALUE FROM V$RMAN_CONFIGURATION RM WHERE ((:B2 IS NULL OR UPPER(:B2 ) = UPPER(RM.NAME)) AND (:B1 IS NULL OR UPPER(:B1 ) = UPPER(RM.VALUE)))
a2g6ywq35wnskSELECT CONTROLFILE_TYPE FROM V$DATABASE
aukf94xzh2p3g declare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; rlgscn number; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy(policy => policy, alldest => alldest); if ((policy like '%APPLIED%' OR policy like '%SHIPPED%') AND policy not like '%BACKED UP%') then dbms_rcvman.getSCNForAppliedPolicy( minscn => :applied_scn , rlgscn => rlgscn); else :applied_scn := 0; end if; end;
b4g1xkhnxf0j8SELECT SID, substr(USERNAME, 1, 12) Username, substr(TIMESOURCE, 1, 30), SECONDS, ROUND(SECONDS/(SELECT ROUND((SYSDATE-LOGON_TIME)*24*60*60, 0) FROM V$SESSION WHERE SID= :monitored_sid), 2)*100 AS PERCENTAGE FROM (SELECT logon_time, SID, username, 'TOTAL_TIME' TIMESOURCE, ROUND((SYSDATE-LOGON_TIME)*24*60*60, 0) SECONDS FROM V$SESSION WHERE SID= :monitored_sid UNION ALL SELECT a.logon_time, a.SID, a.USERNAME, 'CPU' TIMESOURCE, ROUND((VALUE/100), 0) SECONDS FROM V$SESSION a, V$SESSTAT b where a.SID = b.SID and a.SID = :monitored_sid and b.STATISTIC# = (SELECT STATISTIC# FROM V$STATNAME WHERE NAME='CPU used by this session') UNION ALL SELECT b.logon_time, a.SID, b.USERNAME, a.EVENT TIMESOURCE, ROUND((TIME_WAITED/100), 0) SECONDS FROM V$SESSION_EVENT a, V$SESSION b WHERE a.SID = b.SID AND a.SID= :monitored_sid UNION ALL select b.logon_time, a.sid, b.username, 'UNACCOUNTED_TIME' TIMESOURCE, ROUND(MAX(SYSDATE-LOGON_TIME)*24*60*60, 0)-(ROUND(SUM((TIME_WAITED/100)), 0)+ROUND(MAX(VALUE/100), 0)) as UNACCOUNTED_FOR_TIME FROM V$SESSION_EVENT a, V$SESSION b, V$SESSTAT c WHERE a.SID = b.SID AND b.sid = c.sid and c.STATISTIC# = (SELECT STATISTIC# FROM V$STATNAME WHERE NAME='CPU used by this session') AND a.SID= :monitored_sid group by b.logon_time, a.sid, b.username) order by SECONDS desc
b4qw7n9wg64mh INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
bgxuazsj8dg97SELECT SID FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID')
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
bn4b3vjw2mj3uSELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
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
crjmvnqggmm7xinsert into testtable values (1)
cw6vxf0kbz3v1SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES')
d6vwqbw6r2ffkSELECT USER FROM DUAL
d8mayxqw0wnpvSELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
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
dyk4dprp70d74SELECT DECODE('A', 'A', '1', '2') FROM DUAL
f711myt0q6cmainsert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fnk7155mk2jq6insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g4y6nw3tts7ccBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END;
g9460ysz75yzcselect user u from dual

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 referenced30.000.00
CCursor + sql area evicted00.000.00
CPU used by this session9,74213.910.03
CPU used when call started9,68013.820.03
CR blocks created200.030.00
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time1,506,9842,151.924.71
DBWR checkpoint buffers written6,1288.750.02
DBWR checkpoints60.010.00
DBWR object drop buffers written440.060.00
DBWR thread checkpoint buffers written1,7772.540.01
DBWR transaction table writes640.090.00
DBWR undo block writes5,3377.620.02
HSC Heap Segment Block Changes320,628457.851.00
Heap Segment Array Inserts1020.150.00
Heap Segment Array Updates370.050.00
IMU CR rollbacks200.030.00
IMU Flushes74,324106.130.23
IMU Redo allocation size29,039,82841,467.8790.73
IMU commits243,891348.270.76
IMU contention72,882104.070.23
IMU ktichg flush00.000.00
IMU pool not allocated1,8822.690.01
IMU recursive-transaction flush00.000.00
IMU undo allocation size126,079,508180,037.20393.91
IMU- failed to get a private strand1,8382.620.01
Requests to/from client640,669914.852.00
RowCR attempts60.010.00
RowCR hits60.010.00
SMON posted for undo segment shrink220.030.00
SQL*Net roundtrips to/from client640,669914.852.00
active txn count during cleanout72,918104.120.23
application wait time30.000.00
background checkpoints completed40.010.00
background checkpoints started40.010.00
background timeouts3,3384.770.01
buffer is not pinned count6,2838.970.02
buffer is pinned count6,6399.480.02
bytes received via SQL*Net from client129,462,131184,867.46404.48
bytes sent via SQL*Net to client89,169,611127,331.13278.59
calls to get snapshot scn: kcmgss323,260461.601.01
calls to kcmgas320,920458.261.00
calls to kcmgcs324,560463.461.01
cell physical IO interconnect bytes253,149,184361,488.32790.91
change write time5510.790.00
cleanout - number of ktugct calls73,721105.270.23
cleanouts only - consistent read gets30.000.00
cluster key scan block gets500.070.00
cluster key scans490.070.00
commit batch/immediate performed160.020.00
commit batch/immediate requested160.020.00
commit cleanout failures: block lost00.000.00
commit cleanout failures: callback failure100.010.00
commit cleanout failures: cannot pin49,39570.530.15
commit cleanouts320,694457.941.00
commit cleanouts successfully completed271,289387.390.85
commit immediate performed160.020.00
commit immediate requested160.020.00
commit txn count during cleanout98,533140.700.31
concurrency wait time1,5352.190.00
consistent changes360.050.00
consistent gets505,901722.411.58
consistent gets - examination174,845249.670.55
consistent gets direct00.000.00
consistent gets from cache505,901722.411.58
consistent gets from cache (fastpath)330,544472.011.03
cursor authentications640.090.00
data blocks consistent reads - undo records applied250.040.00
db block changes1,287,8761,839.044.02
db block gets1,929,3452,755.046.03
db block gets direct460.070.00
db block gets from cache1,929,2992,754.976.03
db block gets from cache (fastpath)335,344478.861.05
deferred (CURRENT) block cleanout applications236,325337.460.74
enqueue conversions6430.920.00
enqueue releases647,960925.262.02
enqueue requests647,961925.272.02
enqueue timeouts10.000.00
enqueue waits6010.860.00
execute count323,164461.471.01
file io service time00.000.00
file io wait time10,451,61414,924.5432.65
free buffer requested5,0197.170.02
heap block compress160.020.00
immediate (CR) block cleanout applications30.000.00
immediate (CURRENT) block cleanout applications1390.200.00
in call idle wait time1,400,6062,000.024.38
index crx upgrade (positioned)00.000.00
index fast full scans (full)00.000.00
index fetch by key1,2801.830.00
index scans kdiixs13,0214.310.01
leaf node 90-10 splits180.030.00
leaf node splits230.030.00
lob writes190.030.00
lob writes unaligned190.030.00
logical read bytes from cache19,949,158,40028,486,711.2162,326.71
logons cumulative750.110.00
max cf enq hold time2340.330.00
messages received49,20770.270.15
messages sent49,20770.270.15
min active SCN optimization applied on CR20.000.00
no work - consistent read gets5,9868.550.02
non-idle wait count1,139,5061,627.183.56
non-idle wait time1,415,7412,021.634.42
opened cursors cumulative642,972918.142.01
parse count (describe)10.000.00
parse count (hard)110.020.00
parse count (total)1,3871.980.00
parse time cpu4940.710.00
parse time elapsed8581.230.00
physical read IO requests540.080.00
physical read bytes835,5841,193.192.61
physical read total IO requests1,1431.630.00
physical read total bytes18,509,82426,431.3957.83
physical read total multi block requests00.000.00
physical reads1020.150.00
physical reads cache820.120.00
physical reads cache prefetch480.070.00
physical reads direct200.030.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup480.070.00
physical write IO requests7641.090.00
physical write bytes51,126,27273,006.56159.73
physical write total IO requests50,89572.680.16
physical write total bytes234,639,360335,056.93733.08
physical write total multi block requests3440.490.00
physical writes6,2418.910.02
physical writes direct660.090.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache6,1758.820.02
physical writes non checkpoint4,9667.090.02
pinned cursors current00.000.00
process last non-idle time7001.000.00
recursive calls342,575489.191.07
recursive cpu usage1,4812.110.00
redo blocks checksummed by FG (exclusive)2,4733.530.01
redo blocks written332,944475.431.04
redo buffer allocation retries880.130.00
redo entries401,686573.591.25
redo log space requests1000.140.00
redo log space wait time5150.740.00
redo ordering marks4820.690.00
redo size154,215,736220,214.76481.81
redo size for direct writes1560.220.00
redo subscn max counts1,3421.920.00
redo synch long waits11,91217.010.04
redo synch poll writes197,594282.160.62
redo synch polls308,176440.060.96
redo synch time1,421,8922,030.414.44
redo synch time (usec)14,218,936,46620,304,151.6244,423.90
redo synch writes320,104457.101.00
redo wastage10,679,45615,249.9033.37
redo write time54,34877.610.17
redo writes48,46269.200.15
rollback changes - undo records applied120.020.00
rollbacks only - consistent read gets120.020.00
rows fetched via callback9171.310.00
session connect time7001.000.00
session cursor cache hits641,581916.162.00
session logical reads2,435,2463,477.457.61
shared hash latch upgrades - no wait5010.720.00
shared hash latch upgrades - wait00.000.00
sorts (memory)2,6983.850.01
sorts (rows)14,16320.220.04
sql area evicted00.000.00
sql area purged10.000.00
switch current to new buffer440.060.00
table fetch by rowid4,1285.890.01
table fetch continued row00.000.00
table scan blocks gotten1,4472.070.00
table scan rows gotten418,649597.821.31
table scans (long tables)00.000.00
table scans (short tables)4850.690.00
total cf enq hold time3,4224.890.01
total number of cf enq holders400.060.00
total number of times SMON posted260.040.00
transaction rollbacks130.020.00
undo change vector size42,677,86060,942.51133.34
user I/O wait time1,2401.770.00
user calls1,281,1641,829.464.00
user commits320,074457.051.00
workarea executions - optimal1,6472.350.01
write clones created in background30.000.00
write clones created in foreground260.040.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current3333
logons current2425
session uga memory max211,750,356256,651,216
session pga memory164,993,332187,703,716
session pga memory max188,734,392211,444,776
session cursor cache count6,5097,855
session uga memory352,209,440,712412,342,661,608

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)420.56

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.10.001427164M70.56.23418648.6K11.18
DBWR0M0.000M49M1.06.0699700 
Others16M1.46.02284711M1.02.015707138011.55
Buffer Cache Reads1M0.05.0014270M0.000M345.74
Direct Reads0M0.030M0M0.000M0 
Direct Writes0M0.000M0M0.030M0 
TOTAL:18M1.63.025703224M72.68.31986450K11.19

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.010M163M70.45.23275811.25 
Data File1M0.08.00142750M1.09.07139819.83 
Control File17M1.54.02427512M1.14.01713511.13 
TOTAL:18M1.63.025703225M72.68.32129211.58 

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.10.001427164M70.56.2341867510.45
LGWR (Log File) 0M0.010M163M70.45.2327581610.44
LGWR (Control File) 1M0.08.0014271M0.11.0014275910.46
DBWR 0M0.000M49M1.06.0699700 
DBWR (Data File) 0M0.000M49M1.06.0699700 
Others 16M1.46.02284711M1.02.015707102211.14
Others (Control File) 16M1.45.02284711M1.02.015707101711.17
Others (Data File) 0M0.010M0M0.000M54.60
Buffer Cache Reads 1M0.05.0014270M0.000M345.74
Buffer Cache Reads (Data File) 1M0.05.0014270M0.000M345.74
Direct Reads 0M0.030M0M0.000M0 
Direct Reads (Data File) 0M0.030M0M0.000M0 
Direct Writes 0M0.000M0M0.030M0 
Direct Writes (Data File) 0M0.000M0M0.030M0 
TOTAL: 18M1.63.025703224M72.68.319864113110.93

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
UNDOTBS1 400.001.004171671.64
SYSAUX 3106.772.55257000.00
USERS 1100.911.0066017026.35
SYSTEM 400.001.0020000.00
EXAMPLE 400.001.004000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EXAMPLEC:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF 400.001.004000.00
SYSAUXC:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF 3106.772.55257000.00
SYSTEMC:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 400.001.0020000.00
UNDOTBS1C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF 400.001.004171671.64
USERSC:\ORACLE\ORADATA\ORCL\USERS01.DBF 1100.911.0066017026.35

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,432,331826,17500237

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
01,777004,3510

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
B0852227165739165888165888459700   
E0882700151390165888165888424184   

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.1615187.00
D800.19101.0514176.00
D1200.28151.0414174.00
D1600.38201.0314173.00
D2000.47251.0214172.00
D2400.57301.0113171.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.00400

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
2K4K1,6031,60300
64K128K4400
512K1024K383800
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.13164.880.00100.00074,445
1240.25164.880.00100.00074,445
2480.50164.880.00100.00074,445
3720.75164.880.00100.00074,445
4961.00164.880.00100.00074,445
5951.20164.880.00100.00074,445
6941.40164.880.00100.00074,445
7941.60164.880.00100.00074,445
8931.80164.880.00100.00074,445
9922.00164.880.00100.00074,445
1,4883.00164.880.00100.00074,445
1,9844.00164.880.00100.00074,445
2,9766.00164.880.00100.00074,445
3,9688.00164.880.00100.00074,445

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.39151,34518,9750.968188.52476
1360.52463,33719,0580.977357.66478
1680.64493,61719,0580.977357.66478
1840.70493,61719,0580.977357.66478
1920.73493,61719,0580.977357.66478
2000.76493,61719,0580.977357.66478
2080.79493,61719,0580.977357.66478
2160.82493,61719,0580.977357.66478
2240.85493,61719,0750.977187.48478
2320.88493,61719,1750.976186.44478
2400.91493,61719,2760.985175.39478
2480.94493,61719,3760.984174.34478
2560.97493,61719,5360.992572.68479
2641.00493,61719,6971.00961.00479
2721.03493,61719,6971.00961.00479
2801.06493,61719,6971.00961.00479
2881.09493,61719,6971.00961.00479
2961.12493,61719,6971.00961.00479
3041.15493,61719,6971.00961.00479
3121.18493,61719,6971.00961.00479
3201.21493,61719,6971.00961.00479
3281.24493,61719,6971.00961.00479
3361.27493,61719,6971.00961.00479
3601.36493,61719,6971.00961.00479
3921.48493,61719,6971.00961.00479
4241.61493,61719,6971.00961.00479
4561.73493,61719,6971.00961.00479
4881.85493,61719,6971.00961.00479
5201.97493,61719,6971.00961.00479
5522.09493,61719,6971.00961.00479

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1840.2533,90815,395
3680.5033,18915,395
5520.7533,17213,431
7361.0033,17213,334
9201.2533,17213,334
1,1041.5033,17213,334
1,2881.7533,17213,334
1,4722.0033,17213,334

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 block161428
undo header6702
1st level bmb602
segment header300

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction 320,110320,39602521040.80
FB-Format Block 1581580113540.73
HW-Segment High Water Mark 397397023414.92
RO-Multiple Object Reuse (fast object reuse) 20200207.50

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
27.08404,6393601919/190/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
22-Aug 13:107,077404,63936019190/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 db client latch6630.00 00 
ASM map operation hash table10.00 00 
ASM network state latch130.00 00 
AWR Alerted Metric Element list5,4460.00 00 
Change Notification Hash table latch2330.00 00 
Consistent RBA48,4670.001.0000 
DML lock allocation640,9600.040.0700 
Event Group Locks1370.00 00 
FOB s.o list latch2880.350.0000 
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,347,9700.060.723320,2030.00
JS Sh mem access30.00 00 
JS broadcast autostart latch130.00 00 
JS mem alloc latch20.00 00 
JS queue access latch30.00 00 
JS queue state obj latch5,0920.00 00 
JS slv state obj latch470.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 latch2320.00 00 
KTF sga latch40.00 02290.00
KWQMN job cache list latch30.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch40.00 00 
KWQS pqueue ctx latch240.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0150.00
Memory Management Latch10.00 02320.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 Latch80.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process3770.00 00 
OS process allocation1,5350.00 00 
OS process: request allocation1210.00 00 
PL/SQL warning settings2240.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch120.00 00 
SGA IO buffer pool latch120.00 0120.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch240.00 02300.00
SQL memory manager workarea list latch15,8200.00 00 
Shared B-Tree770.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 latch9630.00 00 
active service list1,8700.00 08040.00
begin backup scn array30.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles4200.00 00 
cache buffers chains9,129,1030.160.0225,0370.00
cache buffers lru chain6,3970.00 017,4200.01
call allocation3870.260.0000 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch1280.00 00 
channel operations parent latch5,6310.00 00 
checkpoint queue latch21,8380.00 06,6000.00
client/application info3960.00 00 
compile environment latch750.00 00 
corrupted undo seg latch490.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch130.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch130.00 00 
dml lock allocation130.00 00 
done queue latch10.00 00 
dummy allocation1500.00 00 
enqueue freelist latch20.00 014,2650.04
enqueue hash chains1,297,1750.240.0310 
enqueues80.00 00 
fifth spare latch10.00 00 
file cache latch2050.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 SGA340.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch0  02190.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 latch150.00 0140.00
job_queue_processes free list latch320.00 00 
job_queue_processes parameter latch1660.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch40.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch680.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock70.00 00 
ksuosstats global area720.00 00 
ksv allocation latch260.00 00 
ksv class latch150.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1210.00 00 
ktm global data1050.00 00 
kwqbsn:qsga270.00 00 
lgwr LWN SCN48,4760.00 00 
list of block allocation1190.00 00 
loader state object freelist500.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 latch3750.00 00 
messages126,0890.230.0100 
mostly latch-free SCN48,5410.110.7410 
msg queue latch10.00 00 
multiblock read objects240.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch130.00 00 
object queue header heap1,8990.00 070.00
object queue header operation32,2840.010.0000 
object stats modification590.00 00 
parallel query alloc buffer930.00 00 
parallel query stats10.00 00 
parameter list880.00 00 
parameter table management7800.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue25,8170.020.000124,0970.09
process allocation1480.00 0610.00
process group creation1210.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch1006.000.8300 
query server freelists10.00 00 
queued dump request20.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation785,8530.000.160401,3460.25
redo copy10.00 0401,7370.24
redo writing147,8190.000.3300 
resmgr group change latch610.00 00 
resmgr:active threads1500.00 00 
resmgr:actses change group520.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list1490.00 00 
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 objects15,8560.080.4600 
rules engine aggregate statistics20.00 00 
rules engine rule set statistics1040.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache2290.00 00 
session allocation320,4670.120.060320,3240.04
session idle bit2,882,5780.020.2520 
session queue latch10.00 00 
session state list latch980.00 00 
session switching740.00 00 
session timer2330.00 00 
shared pool6,5860.120.5000 
shared pool sim alloc30.00 00 
shared pool simulator240.00 00 
sim partition latch10.00 00 
simulator hash latch97,0920.00 00 
simulator lru latch5,7680.030.00090,8840.03
sort extent pool470.00 00 
space background state object latch10.00 00 
space background task latch1,2861.240.9404690.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 latch260.00 00 
trace latch10.00 00 
transaction allocation7200.141.0000 
undo global data1,773,9660.110.0100 
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,129,10314,81928214,557
enqueue hash chains1,297,1753,151993,064
undo global data1,773,9661,910251,887
In memory undo latch1,347,970791571249
session idle bit2,882,578520128400
session allocation320,46739124367
messages126,0892912289
DML lock allocation640,96022917212
mostly latch-free SCN48,541533914
redo allocation785,85325421
space background task latch1,28616151
row cache objects15,8561367
shared pool6,586844
qmn task queue latch100651
redo writing147,819312
Consistent RBA48,467110
transaction allocation720110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam01110
DML lock allocationktaidm067
In memory undo latchktiFlush: child0334516
In memory undo latchkticmt: child024483
In memory undo latchktichg: child0230
PC and Classifier lists for WLMNo latch060
cache buffers chainskcbgcur: fast path (shr)0900917
cache buffers chainskcbrls_20331
cache buffers chainskcbgcur_201310
cache buffers chainskcbnlc0710
cache buffers chainskcbgtcr: fast path043
cache buffers chainskcbgtcr: fast path (cr pin)030
cache buffers chainskcb_pre_apply: kcbhq61020
cache buffers chainskcbgcur_40219
cache buffers chainskcb_post_apply: kcbhq62010
enqueue hash chainsksqgtl305964
enqueue hash chainsksqrcl04034
messagesksaamb: after wakeup012
messagesksarcv010
mostly latch-free SCNkcs0403139
mostly latch-free SCNkcs05080
mostly latch-free SCNkcsnew_scn_rba010
qmn task queue latchkwqmnmvtsks: delay to ready list050
redo allocationkcrfw_redo_gen: redo allocation 1040
redo writingkcrfwcr010
row cache objectskqreqd: reget050
row cache objectskqreqd010
session allocationksuxds01524
session allocationksucri_int : SSO090
session idle bitksupuc: set busy06645
session idle bitksupuc: clear busy04039
session idle bitksuxds02244
shared poolkghalo044
space background task latchktsj_grab_task0915
transaction allocationktcccadd011
undo global dataktudnx:child01110
undo global dataktubnd_4050
undo global dataktudba: KSLBEGIN053
undo global dataktufrbs_20312
undo global dataktubnd_3010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Cursor Pinkksfbc [KKSCHLPIN1]530
Cursor PinkksLockDelete [KKSCHLPIN6]20

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,288,19252.90
SYSSYSTEMI_SYSAUTH1 INDEX4,2240.17
SYSSYSTEMAUD$ TABLE6240.03
TESTUSERUSERSTESTTABLE TABLE6240.03
SYSSYSTEMJOB$ TABLE5600.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE3635.29
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX98.82
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE87.84
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY TABLE87.84
SYSSYSAUXWRH$_SEG_STAT_PKWRH$_SEG_ST_1306904245_58INDEX PARTITION65.88

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE916.67
TESTUSERUSERSTESTTABLE TABLE47.41
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX47.41
TESTUSERUSERSTESTTABLE TABLE35.56
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE35.56

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSSYSAUXWRH$_SQL_PLAN TABLE916.67
TESTUSERUSERSTESTTABLE TABLE47.41
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX47.41
TESTUSERUSERSTESTTABLE TABLE35.56
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE35.56

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 TABLE3966.35
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1306904245_58TABLE PARTITION500.80
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_1306904245_58INDEX PARTITION150.24
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1306904245_58TABLE PARTITION140.22
SYSSYSAUXWRH$_SQLSTATWRH$_SQLSTA_1306904245_58TABLE PARTITION130.21

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
TESTUSERUSERSTESTTABLE TABLE314.06
TESTUSERUSERSTESTTABLE TABLE293.80
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1306904245_58TABLE PARTITION50.65
SYSSYSAUXWRH$_LATCHWRH$_LATCH_1306904245_58TABLE PARTITION40.52
SYSSYSAUXWRH$_SEG_STAT_PKWRH$_SEG_ST_1306904245_58INDEX PARTITION40.52

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1306904245_58TABLE PARTITION4669.70

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 TABLE4,57673.52
SYSSYSTEMAUD$ TABLE5609.00
SYSMANSYSAUXMGMT_JOB_EXECUTION TABLE1762.83
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE1442.31
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX1282.06

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 TABLE170100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control200.000 21
dc_global_oids710.000 052
dc_histogram_data160.000 01,359
dc_histogram_defs293.450 04,067
dc_objects2980.670 21,805
dc_profiles490.000 01
dc_rollback_segments3260.000 034
dc_segments1700.590 27678
dc_sequences20.000 29
dc_tablespaces5030.000 07
dc_users3,8530.000 0103
global database name5650.000 01
outstanding_alerts633.330 27
sch_lj_oids20.000 06


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS680.000 00
BODY3340.004290.0000
DBLINK680.000 00
EDITION510.00990.0000
QUEUE150.00430.0000
RULESET0 20.0000
SCHEMA480.000 00
SQL AREA1,0830.46323,915-0.1545
SQL AREA BUILD944.440 00
SQL AREA STATS1060.001060.0000
SUBSCRIPTION10.0010.0000
TABLE/PROCEDURE1360.009110.0000
TRIGGER430.00520.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
BOther31.74 1.221.14552626
SQL0.450.380.040.1104128
PL/SQL0.340.280.010.03002424
EOther33.76 1.251.12552727
SQL0.500.430.040.1204138
PL/SQL0.380.290.020.03012525

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
sharedKGLH021.0121.140.61
sharedKGLHD4.004.010.18
sharedKGLS10.4710.470.00
sharedKGLSG3.523.520.00
sharedKQR M PO2.882.880.03
sharedKSFD SGA I/O b4.004.000.00
sharedPLDIA2.712.710.00
sharedPLMCD5.445.440.00
sharedSQLA19.0819.180.51
shareddbwriter coalesce buffer4.004.000.00
sharedevent statistics per sess3.103.100.00
sharedfree memory125.18124.89-0.23
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 Slaves0822 12:01:300.020.000.00
QMON Coordinator0822 12:01:200.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

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 20.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(12733) 20100.000.000.000.000.0021.59
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.000.00 
SYS.AQ$_ALERT_QT_E(12732) 0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 0.010.010.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 2000.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 %
7000.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.007000.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