Enter value for report_name: Using the report name awrrpt_1_1049_1050.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 1049-1050

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
XJDSS2903669701xjdss104-Dec-13 12:1211.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
xjdssaAIX-Based Systems (64-bit) 32 32  80.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:104904-Dec-13 17:00:2335 .7
End Snap:105004-Dec-13 17:30:2435 .7
Elapsed:  30.02 (mins)  
DB Time:  6,657,454,706.53 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 36,864M 36,864MStd Block Size: 8K
Shared Pool Size: 10,240M 10,240MLog Buffer: 36,424K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 221,738,751.4 2,017,410,517.1 7.1E+07 1.0E+09
DB CPU(s): 221,738,751.4 2,017,410,517.1 7.1E+07 1.0E+09
Redo size: 1,023.7 9,313.8  
Logical reads: 24.1 219.3  
Block changes: 4.3 39.3  
Physical reads: 0.0 0.4  
Physical writes: 0.4 3.9  
User calls: 0.2 2.0  
Parses: 0.8 7.3  
Hard parses: 0.0 0.2  
W/A MB processed: 0.0 0.2  
Logons: 0.1 0.6  
Executes: 3.1 28.6  
Rollbacks: 0.0 0.0  
Transactions: 0.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.83In-memory Sort %: 100.00
Library Hit %: 98.58Soft Parse %: 97.70
Execute to Parse %: 74.62Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 5.22220799E+12% Non-Parse CPU: 96.73

Shared Pool Statistics

BeginEnd
Memory Usage %: 16.10 16.11
% SQL with executions>1: 85.09 83.96
% Memory for SQL w/exec>1: 81.69 79.23

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 399,447,282,391 100.00 
control file sequential read36020.00System I/O
db file sequential read10060.00User I/O
Disk file operations I/O53010.00User I/O
log file sync34000.00Commit

Host CPU (CPUs: 32 Cores: 32 Sockets: )

Load Average BeginLoad Average End%User%System%WIO%Idle
0.24 0.13 0.3 0.1 0.0 99.6
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
6.9E+08 1.8E+11 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 81,920.0 81,920.0
SGA use (MB): 48,933.7 48,933.7
PGA use (MB): 255.9 255.9
% Host Mem used for SGA+PGA: 60.05 60.05

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU399,447,282,390.92100.00
sql execute elapsed time2.270.00
PL/SQL execution elapsed time0.590.00
parse time elapsed0.230.00
hard parse elapsed time0.130.00
PL/SQL compilation elapsed time0.050.00
connection management call elapsed time0.020.00
hard parse (sharing criteria) elapsed time0.010.00
failed parse elapsed time0.000.00
repeated bind elapsed time0.000.00
DB time399,447,282,391.69 
background elapsed time50.59 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME615 
AVG_IDLE_TIME179,304 
AVG_IOWAIT_TIME13 
AVG_SYS_TIME135 
AVG_USER_TIME412 
BUSY_TIME22,330 
IDLE_TIME5,740,590 
IOWAIT_TIME745 
SYS_TIME6,437 
USER_TIME15,893 
LOAD00
OS_CPU_WAIT_TIME23,900 
VM_IN_BYTES12,288 
VM_OUT_BYTES1,744,896 
PHYSICAL_MEMORY_BYTES85,899,345,920 
NUM_CPUS32 
NUM_CPU_CORES32 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
04-Dec 17:00:230.24     
04-Dec 17:30:240.130.390.280.1199.610.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  399,447,282,391 100.00
User I/O650010.00
System I/O360020.00
Commit340000.00
Application90000.00
Network470000.00
Concurrency0 0 0.00
Other0 0 0.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
control file sequential read360020.180.00
db file sequential read100060.050.00
Disk file operations I/O530010.270.00
log file sync340000.170.00
db file scattered read20010.010.00
jobq slave wait3,7801001,89050019.09 
SQL*Net message from client470965205280.24 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
os thread startup75091190.3817.61
db file sequential read3990492.027.12
control file sequential read3,17802116.054.06
control file parallel write6390113.231.30
db file parallel write5700112.881.00
log file parallel write3800011.920.59
ADR block file read160040.080.11
ASM file metadata operation5400002.730.10
Disk file operations I/O1,4430007.290.05
log file sync30020.020.01
ADR block file write50000.030.00
LGWR wait for redo copy160000.080.00
rdbms ipc message12,7559739,584310364.42 
DIAG idle wait3,5441003,544100017.90 
Space Manager: slave idle wait484992,40649712.44 
Streams AQ: qmn coordinator idle wait130501,820140000.66 
Streams AQ: qmn slave idle wait6501,820280000.33 
wait for unread message on broadcast channel1,8021001,80210009.10 
class slave wait4201,801428880.21 
ASM background timer36001,80150031.82 
pmon timer6001001,80030003.03 
shared server idle wait601001,800300000.30 
dispatcher timer301001,800600010.15 
smon timer6831,7972995190.03 
SQL*Net message from client100010.05 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read1650.012.5 18.818.8   
ADR block file write5100.0       
ADR file lock6100.0       
ASM file metadata operation540100.0       
Disk file operations I/O149398.8.21.0     
LGWR wait for redo copy17100.0       
SQL*Net break/reset to client9100.0       
SQL*Net message to client55100.0       
asynch descriptor resize77100.0       
control file parallel write63992.82.71.41.7.8.6  
control file sequential read321496.5.9.7.9.9.1  
db file async I/O submit581100.0       
db file parallel write58191.93.42.9.7.9 .2 
db file scattered read3100.0       
db file sequential read4013.2.52.548.642.62.5  
log file parallel write38192.73.9.81.31.0.3  
log file sync3794.62.7 2.7    
os thread startup75      100.0 
ASM background timer360       100.0
DIAG idle wait3544      100.0 
KSV master wait10100.0       
SQL*Net message from client5757.912.35.3   1.822.8
Space Manager: slave idle wait484      .499.6
Streams AQ: qmn coordinator idle wait13050.0      50.0
Streams AQ: qmn slave idle wait65       100.0
class slave wait4252.4   11.99.52.423.8
dispatcher timer30       100.0
jobq slave wait3780      100.0 
pmon timer600       100.0
rdbms ipc message12.8K.2.4.2.3.3.329.069.2
shared server idle wait60       100.0
smon timer7       100.0
wait for unread message on broadcast channel1801      100.0 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
db file parallel write199.8.2      
os thread startup75  100.0     

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$USERS399,447,282,392399,447,282,391033
SYS$BACKGROUND00010
xjdss0000
xjdssXDB0000

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 6500000470
SYS$BACKGROUND 184147590000

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
2.9112.910.00633345608883.2197.78350myuyx0t1d6   insert into wrh$_tablespace_st...
1.5711.570.00780976233951.692.101cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
1.2411.240.00992459966923.600.0066gs90fyynks7   insert into wrh$_instance_reco...
1.2211.220.001004588135903.260.004dy1xm4nxc0gf   insert into wrh$_system_event ...
1.1911.190.00516211402977.602.4784k66tf2s7y1c   insert into wrh$_bg_event_summ...
0.6310.630.00973152599730.900.00586b2udq6dbng   insert into wrh$_sysstat (snap...
0.4810.480.001291309495496.162.397g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
0.29280.010.0025356170621151.730.253am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
0.2250.040.008434956328841.960.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
0.2110.210.002941721124272.7323.606ajkhukk78nsr   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
116,761,517,608.811,68369,377,015.8129.230.1387046465634995.840.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
73,744,111,702.61282,633,718,275.0918.460.2925356170621151.730.253am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
49,162,743,428.40358137,326,098.9612.310.0860389071893380.380.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
49,162,741,376.11125393,301,931.0112.310.03191205434723529.260.658vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
30,726,714,768.7456,145,342,953.757.690.01209409900966006.710.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
24,581,373,550.79101243,379,936.156.150.02106270258747088.450.00g00cj285jmgsw   update sys.mon_mods$ set inser...
24,581,372,074.3433744,890,062.866.150.0382244954745523.4110.6047a50dvdgnxc2   update sys.job$ set failures=0...
24,581,371,351.1633744,890,040.946.150.0298660932575407.420.00cumjq42201t37   select u1.user#, u2.user#, u3....
18,436,030,999.2653,687,206,199.854.620.1313984276437990.420.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
18,436,030,999.2653,687,206,199.854.620.228434956328841.960.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
18,436,030,623.92118,436,030,623.924.620.0292014526971056.2766.371s694jdz9ujwd sqlplus@xjdssa (TNS V1-V3) select SNAP_INTERVAL, RETENTI...
18,436,029,299.5336,145,343,099.844.620.02109588238123608.1694.54cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
18,436,028,739.0036,145,342,913.004.620.01145005731783846.040.00a1xgxtssv5rrp MMON_SLAVE select sum(used_blocks), ts.ts...
18,436,028,648.9330614,534,288.304.620.0364190065279509.960.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
18,436,028,347.5231594,710,591.864.620.01202238134571316.470.109ds1amk0gttnh   insert into "SYSMAN"."MGMT_TAS...
18,436,028,106.5130614,534,270.224.620.01332360340842075.320.00fzwnuj0amdfvr EM_PING DELETE FROM MGMT_JOB_HISTORY H...
18,436,027,744.8836,145,342,581.634.620.0449536576685056.100.00dqbhc9r7gz0a5   SELECT DECODE(COUNT(CLIENT_INF...
18,436,027,744.8836,145,342,581.634.620.0444365365767961.520.006mvfay19q3v4n   SELECT COUNT(CLIENT_INFO) FROM...
18,436,027,142.23110167,600,246.754.620.01125381033339444.141.165j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
18,436,025,661.70118,436,025,661.704.622.91633345608883.2197.78350myuyx0t1d6   insert into wrh$_tablespace_st...
12,290,687,360.5466186,222,535.773.080.0268793727530196.9372.905h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
12,290,687,360.54112,290,687,360.543.080.01165153014788294.300.005n5bn74468dh1   SELECT count(*) FROM sys.wri$_...
12,290,687,360.5291,365,631,928.953.080.01161422213823435.9576.983m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
12,290,686,609.52112,290,686,609.523.080.1111312078682678.540.68gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
12,290,686,203.6726,145,343,101.843.080.00261392730830963.380.009ctd6nt7ftzmr sqlplus@xjdssa (TNS V1-V3) select * from dba_hist_wr_cont...
12,290,686,199.67112,290,686,199.673.080.0619193400898982.2824.847xv27767hatvx sqlplus@xjdssa (TNS V1-V3) begin dbms_workload_repository...
12,290,686,067.7662198,236,872.063.080.0338442030738644.260.00fsbqktj5vw6n9   select next_run_date, obj#, ru...
12,290,685,765.8934,096,895,255.303.080.0192051271464141.520.009wrbfqp5r8ab2   CALL mgmt_admin_data.eval_repo...
12,290,685,698.51112,290,685,698.513.080.01108584554276126.800.00bdkc4bwtu64bm sqlplus@xjdssa (TNS V1-V3) begin dbms_workload_repository...
12,290,685,646.14112,290,685,646.143.080.0259421222423786.3913.632asgk01xtb6p0 sqlplus@xjdssa (TNS V1-V3) select d.dbid dbid , d.name db...
12,290,685,283.7530409,689,509.463.080.01116742831342580.180.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
12,290,684,560.6131396,473,695.503.080.01133160179421541.400.0007c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
12,290,683,778.12112,290,683,778.123.081.221004588135903.260.004dy1xm4nxc0gf   insert into wrh$_system_event ...
12,290,683,777.98112,290,683,777.983.081.24992459966923.600.0066gs90fyynks7   insert into wrh$_instance_reco...
12,290,683,769.68112,290,683,769.683.081.57780976233951.692.101cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
6,145,343,680.2616,145,343,680.261.540.0229977286245189.820.006wm3n4d7bnddg   SELECT source, (case when tim...
6,145,343,680.2616,145,343,680.261.540.0184414061542086.550.0047mm81hm9sggy   SELECT sum(case when a.sessio...
6,145,343,680.2616,145,343,680.261.540.0162243934774271.970.006cp74g22fzahf   WITH ash as (SELECT ash.event...
6,145,343,680.2616,145,343,680.261.540.0415180809960880.000.005h91zx386wbht   WITH awr_params as ( SELECT /*...
6,145,343,680.2616,145,343,680.261.540.0199455311219676.340.005dyhfnkzta2zm   WITH awr_evts as (SELECT e.eve...
6,145,343,680.2416,145,343,680.241.540.212941721124272.7323.606ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
6,145,343,666.4251,229,068,733.281.540.0512493583122752.960.008ca8v2jk772ps Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1DAY WHERE...
6,145,343,666.4216,145,343,666.421.540.0141717084151922.370.0039ax31acw29z6 Oracle Enterprise Manager.current metric purge WITH MET AS (SELECT DISTINCT M...
6,145,343,387.7010160,844,984.041.540.01120828615566205.800.00350f5yrnnmshs   lock table sys.mon_mods$ in ex...
6,145,343,244.5430204,844,774.821.540.0187329021522494.360.006x3gu99adnjc7 EM_PING UPDATE MGMT_JOB_EXECUTION SET ...
6,145,343,003.5230204,844,766.781.540.00212568073452920.790.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
6,145,342,953.7516,145,342,953.751.540.01116609923221096.170.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
6,145,342,820.4432,048,447,606.811.540.0162168364394984.3094.0239m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
6,145,342,581.6241,536,335,645.411.540.0232186364540008.120.00d8mayxqw0wnpv   SELECT OWNER FROM DBA_PROCEDUR...
6,145,342,581.6231198,236,857.471.540.0318574968509320.870.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
6,145,341,978.9833186,222,484.211.540.0322662322450803.9515.04aq8yqxyyb40nn   update sys.job$ set this_date=...
6,145,341,978.9812549,162,735.831.540.0413735063204559.790.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
6,145,341,918.7330204,844,730.621.540.0190239969438009.590.002jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
6,145,341,889.2216,145,341,889.221.540.0610633919171516.3870.33fnk7155mk2jq6   insert into wrh$_sysmetric_his...
6,145,341,889.1716,145,341,889.171.540.0511288698866914.4890.750z1031991bd7w   insert into wrh$_sysmetric_sum...
6,145,341,889.1416,145,341,889.141.540.0414781339480793.411.0432mk33ry1g665   INSERT INTO wrh$_datafile (sna...
6,145,341,889.1016,145,341,889.101.540.0416525066927781.550.003jyk0fjp6yjyf   INSERT INTO wrh$_tempfile (sna...
6,145,341,889.0816,145,341,889.081.540.0413764288505561.460.240bdpb49gvdzgg   insert into wrh$_tempstatxs (s...
6,145,341,889.0716,145,341,889.071.540.481291309495496.162.397g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
6,145,341,889.0316,145,341,889.031.541.19516211402977.602.4784k66tf2s7y1c   insert into wrh$_bg_event_summ...
6,145,341,889.0116,145,341,889.011.540.125299901587730.630.0084qubbrsr0kfn   insert into wrh$_latch (snap_i...
6,145,341,889.0016,145,341,889.001.540.069968921873626.430.001xpfbutrrzkph   insert into wrh$_db_cache_advi...
6,145,341,888.9916,145,341,888.991.540.63973152599730.900.00586b2udq6dbng   insert into wrh$_sysstat (snap...
6,145,341,888.9916,145,341,888.991.540.0413771382863456.050.00dnwpm0gdccrph   insert into wrh$_process_memor...

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
2.8512.8576.522.91633345608883.2197.78350myuyx0t1d6   insert into wrh$_tablespace_st...
0.0510.051.330.0511288698866914.4890.750z1031991bd7w   insert into wrh$_sysmetric_sum...
0.0510.051.330.212941721124272.7323.606ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.0410.041.090.0610633919171516.3870.33fnk7155mk2jq6   insert into wrh$_sysmetric_his...
0.0310.030.891.57780976233951.692.101cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
0.0310.030.791.19516211402977.602.4784k66tf2s7y1c   insert into wrh$_bg_event_summ...
0.0210.020.430.0619193400898982.2824.847xv27767hatvx sqlplus@xjdssa (TNS V1-V3) begin dbms_workload_repository...
0.0230.010.430.02109588238123608.1694.54cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.0110.010.360.0292014526971056.2766.371s694jdz9ujwd sqlplus@xjdssa (TNS V1-V3) select SNAP_INTERVAL, RETENTI...
0.01660.000.350.0268793727530196.9372.905h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...

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
7,15828255.6416.490.2925356.33am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
5,6431,6833.3513.000.13870460cm5vu20fhtnq1   select /*+ connect_by_filterin...
5,54415,544.0012.770.1111312.7gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
3,9015780.208.980.228434905uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
1,8483356.004.260.02000k8522rmdzg4k   select privilege# from sysauth...
1,74511,745.004.020.212941723.66ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
1,5215304.203.500.131398400njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
1,1891259.512.740.0319120.78vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1,1465229.202.640.051249308ca8v2jk772ps Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1DAY WHERE...
1,04811,048.002.410.0414781132mk33ry1g665   INSERT INTO wrh$_datafile (sna...
7661766.001.760.022997706wm3n4d7bnddg   SELECT source, (case when tim...
7163582.001.650.086038905ms6rbzdnq16t   select job, nvl2(last_date, 1,...
6353120.481.460.031857404jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
6324158.001.460.02321860d8mayxqw0wnpv   SELECT OWNER FROM DBA_PROCEDUR...
558629.001.290.03384420fsbqktj5vw6n9   select next_run_date, obj#, ru...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
919.0012.330.0610633919171516.3870.33fnk7155mk2jq6   insert into wrh$_sysmetric_his...
717.009.590.0511288698866914.4890.750z1031991bd7w   insert into wrh$_sysmetric_sum...
717.009.591.57780976233951.692.101cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
616.008.220.212941721124272.7323.606ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
515.006.850.0292014526971056.2766.371s694jdz9ujwd sqlplus@xjdssa (TNS V1-V3) select SNAP_INTERVAL, RETENTI...
515.006.850.0619193400898982.2824.847xv27767hatvx sqlplus@xjdssa (TNS V1-V3) begin dbms_workload_repository...
531.676.850.02109588238123608.1694.54cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
313.004.111.19516211402977.602.4784k66tf2s7y1c   insert into wrh$_bg_event_summ...
2660.032.740.0268793727530196.9372.905h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
130.331.370.0162168364394984.3094.0239m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
190.111.370.01161422213823435.9576.983m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
111.001.370.481291309495496.162.397g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
111.001.370.069880288572108.4212.59f318xdxdn0pdc   insert into wrh$_log (snap_id,...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
1,4251,42511,425.000.002192.311cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
3573571357.000.00549.23350myuyx0t1d6   insert into wrh$_tablespace_st...
6969169.000.00106.15f318xdxdn0pdc   insert into wrh$_log (snap_id,...
6565165.000.00100.003jyk0fjp6yjyf   INSERT INTO wrh$_tempfile (sna...
3636136.000.0055.380bdpb49gvdzgg   insert into wrh$_tempstatxs (s...
2222280.790.0033.853am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
2222122.000.0033.85gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
9919.000.0013.8532mk33ry1g665   INSERT INTO wrh$_datafile (sna...
7717.000.0010.770z1031991bd7w   insert into wrh$_sysmetric_sum...
7717.000.0010.772asgk01xtb6p0 sqlplus@xjdssa (TNS V1-V3) select d.dbid dbid , d.name db...
6616.000.009.236ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
5515.000.007.697xv27767hatvx sqlplus@xjdssa (TNS V1-V3) begin dbms_workload_repository...
3313.000.004.6284k66tf2s7y1c   insert into wrh$_bg_event_summ...
2212.000.003.081s694jdz9ujwd sqlplus@xjdssa (TNS V1-V3) select SNAP_INTERVAL, RETENTI...
22660.030.003.085h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
1190.110.001.543m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
1111.000.001.547g732rx16j8jc   insert into WRH$_SERVICE_STAT ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
1,6832,3761.410.13870460cm5vu20fhtnq1   select /*+ connect_by_filterin...
358330.090.086038905ms6rbzdnq16t   select job, nvl2(last_date, 1,...
1841841.000.0100089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1251251.000.041373505kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
1251251.000.0319120.78vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1101101.000.01125381.25j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
10100.000.01120820350f5yrnnmshs   lock table sys.mon_mods$ in ex...
101990.980.02106270g00cj285jmgsw   update sys.mon_mods$ set inser...
91630.690.010008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
66661.000.026879372.95h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
62621.000.03384420fsbqktj5vw6n9   select next_run_date, obj#, ru...
61611.000.0100bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1011017.03350f5yrnnmshs   lock table sys.mon_mods$ in ex...
33332.300k8522rmdzg4k   select privilege# from sysauth...
33332.3047a50dvdgnxc2   update sys.job$ set failures=0...
33332.30aq8yqxyyb40nn   update sys.job$ set this_date=...
331,6832.30cm5vu20fhtnq1   select /*+ connect_by_filterin...
33332.30cumjq42201t37   select u1.user#, u2.user#, u3....
301842.09089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
30912.0908bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
30302.0908vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
30302.0924dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
30302.092jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
30302.0934rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
30302.096x3gu99adnjc7 EM_PING UPDATE MGMT_JOB_EXECUTION SET ...
30302.098t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
30612.09bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
30302.09btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
30302.09c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
30302.09dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
30302.09fzwnuj0amdfvr EM_PING DELETE FROM MGMT_JOB_HISTORY H...
18181.25cb21bacyh3c7d   select metadata from kopm$ whe...
15311.0407c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
15301.040xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
15151.0454kq2fvcfm0d8   SELECT NVL(ABS(PARAMETER_VALUE...

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
07c4n5uh9nk0rselect tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYSMAN"."MGMT_TASK_QTABLE" tab where tab.msgid = :1 and tab.state != 2 for update skip locked
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
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
0njp59jttu2z9DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1
0xqn4sx1ytghrselect /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1))
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
1cq3qr774cu45 insert 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)
1s694jdz9ujwd select SNAP_INTERVAL, RETENTION from DBA_HIST_WR_CONTROL
1xpfbutrrzkphinsert into wrh$_db_cache_advice (snap_id, dbid, instance_number, bpid, buffers_for_estimate, name, block_size, advice_status, size_for_estimate, size_factor, physical_reads, base_physical_reads, actual_physical_reads, estd_physical_read_time) select :snap_id, :dbid, :instance_number, a.bpid, a.nbufs, b.bp_name, a.blksz, decode(a.status, 2, 'ON', 'OFF'), a.poolsz, round((a.poolsz / a.actual_poolsz), 4), a.preads, a.base_preads, a.actual_preads, a.estd_time_for_disk_reads from x$kcbsc a, x$kcbwbpd b where a.bpid = b.bp_id
24dkx03u3rj6kSELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
2asgk01xtb6p0select d.dbid dbid , d.name db_name , i.instance_number inst_num , i.instance_name inst_name from v$database d, v$instance i
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
32mk33ry1g665INSERT INTO wrh$_datafile (snap_id, dbid, file#, creation_change#, filename, ts#, tsname, block_size) SELECT /*+ ordered index(f) index(ts) */ :lah_snap_id lah, :dbid dbid, f.file# file#, f.crscnbas + (f.crscnwrp * power(2, 32)) creation_change#, v.name filename, ts.ts# ts#, ts.name tsname, ts.blocksize block_size FROM v$dbfile v, file$ f, ts$ ts WHERE f.file# = v.file# and f.status$ = 2 and f.ts# = ts.ts# and not exists (SELECT 1 from wrh$_datafile dfh WHERE dfh.file# = f.file# AND dfh.creation_change# = (f.crscnbas + (f.crscnwrp * power(2, 32))) AND dfh.dbid = :dbid2)
34rks4d5suuxzSELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6 insert 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#
39ax31acw29z6WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
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)
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
4dy1xm4nxc0gfinsert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4jrfrtx4u6zcx SELECT 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), M GMT_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, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
54kq2fvcfm0d8SELECT NVL(ABS(PARAMETER_VALUE), 60) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
586b2udq6dbnginsert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5dyhfnkzta2zm WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_in stance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
5h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5h91zx386wbht WITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_valu e end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
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
5n5bn74468dh1SELECT count(*) FROM sys.wri$_adv_executions e WHERE e.name = :exec_name and e.task_id = 821
5uy533jsc8hyhDELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
66gs90fyynks7 insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6cp74g22fzahf WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, r ound(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
6mvfay19q3v4nSELECT COUNT(CLIENT_INFO) FROM GV$SESSION WHERE USERNAME=:B2 AND CLIENT_INFO = :B1 GROUP BY CLIENT_INFO
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6x3gu99adnjc7UPDATE MGMT_JOB_EXECUTION SET STEP_STATUS = :B3 WHERE STEP_STATUS = :B2 AND STEP_ID = :B1 AND START_TIME < (MGMT_JOB_ENGINE.SYSDATE_UTC() - (30/60/24))
7g732rx16j8jcinsert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7xv27767hatvxbegin dbms_workload_repository.modify_snapshot_settings(interval=>30, retention =>7 * 24 * 60); end;
84k66tf2s7y1cinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8ca8v2jk772psDELETE MGMT_METRICS_1DAY WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
8t43xdhf4d9x2SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 )
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
9ctd6nt7ftzmrselect * from dba_hist_wr_control
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.nex t_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.cla ss_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
9ds1amk0gttnhinsert into "SYSMAN"."MGMT_TASK_QTABLE" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
9wrbfqp5r8ab2CALL mgmt_admin_data.eval_repo_performance(:target_guid, :metric_guid, :coll_name, :metric_values)
a1xgxtssv5rrpselect sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
bdkc4bwtu64bmbegin dbms_workload_repository.modify_snapshot_settings(interval => 30 , retention => 8 * 24 * 60); end;
bfujkg8dw1aaxSELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
bn4b3vjw2mj3u SELECT 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
btwkwwx56w4z6SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cb21bacyh3c7dselect metadata from kopm$ where name='DB_FDO'
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d8mayxqw0wnpvSELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
dnwpm0gdccrphinsert into wrh$_process_memory_summary (snap_id, dbid, instance_number, category, num_processes, non_zero_allocs, used_total, allocated_total, allocated_stddev, allocated_max, max_allocated_max) select :snap_id, :dbid, :instance_number, category, COUNT(*) num_processes, SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs, SUM(used) used_total, SUM(allocated) allocated_total, STDDEV(allocated) allocated_stddev, MAX(allocated) allocated_max, MAX(max_allocated) max_allocated_max from v$process_memory group by category
dqbhc9r7gz0a5SELECT DECODE(COUNT(CLIENT_INFO), 0, 'down', 'up') FROM GV$SESSION WHERE CLIENT_INFO = :B1
dwssdqx28tzf5select sysdate + 1 / (24 * 60) from dual
f318xdxdn0pdcinsert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
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
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ( (bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
fzwnuj0amdfvrDELETE FROM MGMT_JOB_HISTORY H WHERE STEP_ID = :B1 AND NOT EXISTS (SELECT 1 FROM MGMT_JOB_EXECUTION E WHERE E.STEP_ID = H.STEP_ID AND E.STEP_STATUS = H.STEP_STATUS)
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
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss 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 vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced30.000.02
CCursor + sql area evicted00.000.00
CPU used by this session1,553,859,990,861862,569,328.667,847,777,731.62
CPU used when call started523,792,652,161290,764,598.482,645,417,435.16
CR blocks created380.020.19
Commit SCN cached10.000.01
DB time189,279105.07955.95
DBWR checkpoint buffers written7750.433.91
DBWR transaction table writes310.020.16
DBWR undo block writes1640.090.83
HSC Heap Segment Block Changes1,0750.605.43
Heap Segment Array Inserts860.050.43
Heap Segment Array Updates440.020.22
IMU CR rollbacks600.030.30
IMU Flushes720.040.36
IMU Redo allocation size233,324129.521,178.40
IMU commits1850.100.93
IMU ktichg flush00.000.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size1,172,304650.765,920.73
Requests to/from client470.030.24
RowCR attempts310.020.16
RowCR hits310.020.16
SQL*Net roundtrips to/from client470.030.24
active txn count during cleanout430.020.22
background timeouts12,3936.8862.59
branch node splits10.000.01
buffer is not pinned count19,19010.6596.92
buffer is pinned count16,5879.2183.77
bytes received via SQL*Net from client12,8067.1164.68
bytes sent via SQL*Net to client16,5339.1883.50
calls to get snapshot scn: kcmgss6,3503.5232.07
calls to kcmgas5060.282.56
calls to kcmgcs1,4340.807.24
cell physical IO interconnect bytes85,569,53647,500.84432,169.37
change write time100.010.05
cleanout - number of ktugct calls450.020.23
cleanouts only - consistent read gets20.000.01
cluster key scan block gets2,5811.4313.04
cluster key scans2,3401.3011.82
commit batch/immediate performed300.020.15
commit batch/immediate requested300.020.15
commit cleanout failures: block lost00.000.00
commit cleanout failures: callback failure30.000.02
commit cleanout failures: cannot pin00.000.00
commit cleanouts1,3560.756.85
commit cleanouts successfully completed1,3530.756.83
commit immediate performed300.020.15
commit immediate requested300.020.15
commit txn count during cleanout230.010.12
concurrency wait time8910.494.50
consistent changes870.050.44
consistent gets35,91419.94181.38
consistent gets - examination12,4096.8962.67
consistent gets direct00.000.00
consistent gets from cache35,91419.94181.38
consistent gets from cache (fastpath)22,27012.36112.47
cursor authentications70.000.04
data blocks consistent reads - undo records applied760.040.38
db block changes7,7774.3239.28
db block gets7,5074.1737.91
db block gets direct00.000.00
db block gets from cache7,5074.1737.91
db block gets from cache (fastpath)2,2001.2211.11
deferred (CURRENT) block cleanout applications6370.353.22
enqueue conversions3620.201.83
enqueue releases18,30210.1692.43
enqueue requests18,30210.1692.43
enqueue timeouts00.000.00
enqueue waits00.000.00
execute count5,6613.1428.59
file io service time00.000.00
file io wait time993,961551.765,020.01
free buffer inspected00.000.00
free buffer requested4130.232.09
heap block compress120.010.06
immediate (CR) block cleanout applications20.000.01
immediate (CURRENT) block cleanout applications3930.221.98
in call idle wait time6,035,5063,350.3930,482.35
index crx upgrade (positioned)00.000.00
index crx upgrade (prefetch)20.000.01
index fast full scans (full)10.000.01
index fetch by key9,8985.4949.99
index scans kdiixs17,2514.0336.62
leaf node 90-10 splits190.010.10
leaf node splits200.010.10
lob reads00.000.00
lob writes30.000.02
lob writes unaligned30.000.02
logical read bytes from cache355,704,832197,456.711,796,489.05
logons cumulative1100.060.56
max cf enq hold time110.010.06
messages received9980.555.04
messages sent9980.555.04
min active SCN optimization applied on CR160.010.08
no work - consistent read gets21,12811.73106.71
non-idle wait count8,1694.5341.26
non-idle wait time1,6350.918.26
opened cursors cumulative5,3902.9927.22
parse count (describe)00.000.00
parse count (failures)10.000.01
parse count (hard)330.020.17
parse count (total)1,4370.807.26
parse time cpu1,305,551,997,007724,730,101.956,593,696,954.58
parse time elapsed250.010.13
physical read IO requests650.040.33
physical read bytes598,016331.973,020.28
physical read total IO requests3,6182.0118.27
physical read total bytes56,000,51231,086.66282,830.87
physical read total multi block requests00.000.00
physical reads730.040.37
physical reads cache730.040.37
physical reads cache prefetch80.000.04
physical reads direct00.000.00
physical reads direct temporary tablespace00.000.00
physical write IO requests5700.322.88
physical write bytes6,348,8003,524.3132,064.65
physical write total IO requests2,2291.2411.26
physical write total bytes29,569,02416,414.18149,338.51
physical write total multi block requests100.010.05
physical writes7750.433.91
physical writes direct00.000.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache7750.433.91
physical writes non checkpoint2500.141.26
pinned buffers inspected00.000.00
pinned cursors current00.000.00
recursive calls32,71918.16165.25
recursive cpu usage7,193,244,221,9563,993,070,080.8936,329,516,272.51
redo blocks checksummed by FG (exclusive)2,6861.4913.57
redo blocks written4,4562.4722.51
redo entries3,0341.6815.32
redo ordering marks50.000.03
redo size1,844,1401,023.719,313.84
redo size for direct writes00.000.00
redo subscn max counts2060.111.04
redo synch long waits00.000.00
redo synch time00.000.00
redo synch time (usec)21,44611.90108.31
redo synch writes380.020.19
redo wastage122,44467.97618.40
redo write time340.020.17
redo writes3810.211.92
rollback changes - undo records applied300.020.15
rollbacks only - consistent read gets380.020.19
rows fetched via callback2,9681.6514.99
session cursor cache hits3,9342.1819.87
session logical reads43,42124.10219.30
shared hash latch upgrades - no wait1,0420.585.26
sorts (memory)4,7652.6524.07
sorts (rows)14,1447.8571.43
sql area evicted00.000.00
sql area purged10.000.01
switch current to new buffer1360.080.69
table fetch by rowid10,6675.9253.87
table fetch continued row20.000.01
table scan blocks gotten2,2461.2511.34
table scan rows gotten148,67382.53750.87
table scans (short tables)7140.403.61
total cf enq hold time1570.090.79
total number of cf enq holders100.010.05
total number of times SMON posted20.000.01
transaction rollbacks300.020.15
undo change vector size658,344365.463,324.97
user I/O wait time3730.211.88
user calls3920.221.98
user commits1980.111.00
workarea executions - optimal1,5220.847.69

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current3535
session uga memory max814,144,896901,322,312
session pga memory1,241,046,1681,339,683,888
session pga memory max1,296,047,9281,397,634,768
session cursor cache count18,75620,753
session uga memory1,408,809,680,4241,550,548,949,000
opened cursors current2323

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others53M1.97.02942120M0.71.01110241960.88
DBWR0M0.000M7M0.32.0038850 
LGWR0M0.000M2M0.21.0011103810.33
Buffer Cache Reads1M0.03.0005550M0.000M616.87
TOTAL:54M2.01.02997629M1.24.01609846380.91

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
Control File50M1.78.02775520M0.71.0111020.40 
Data File0M0.220M6M0.32.0033307.71 
Log File0M0.000M2M0.21.001110  
TOTAL:50M2.01.02775528M1.24.0155431.22 

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)
Others 53M1.97.02942120M0.71.01110235571.12
Others (Control File) 50M1.78.02775520M0.71.01110232140.40
Others (Data File) 3M0.19.0016650M0.000M3437.85
DBWR 0M0.000M7M0.32.0038850 
DBWR (Data File) 0M0.000M7M0.32.0038850 
LGWR 0M0.000M2M0.21.0011100 
LGWR (Log File) 0M0.000M2M0.21.0011100 
Buffer Cache Reads 1M0.04.0005550M0.000M686.51
Buffer Cache Reads (Data File) 1M0.04.0005550M0.000M686.51
TOTAL: 54M2.01.02997629M1.24.01609836251.22

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 5906.101.14477000.00
UNDOTBS1 000.000.0068000.00
SYSTEM 805.001.0025000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX+DATA/xjdss/sysaux01.dbf 5906.101.14477000.00
SYSTEM+DATA/xjdss/system01.dbf 805.001.0025000.00
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  36000.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  16000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  7000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  5000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  4000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D4,545,21610043,46978775000

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00007750

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
B02525512262062254803322062   
E0252629674867254803324867   

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
D3,5840.104421.0027149.00
D7,1680.198841.0027149.00
D10,7520.291,3261.0027149.00
D14,3360.391,7681.0027149.00
D17,9200.492,2091.0027149.00
D21,5040.582,6511.0027149.00
D25,0880.683,0931.0027149.00
D28,6720.783,5351.0027149.00
D32,2560.883,9771.0027149.00
D35,8400.974,4191.0027149.00
D36,8641.004,5451.0027149.00
D39,4241.074,8611.0027149.00
D43,0081.175,3031.0027149.00
D46,5921.265,7451.0027149.00
D50,1761.366,1871.0027149.00
D53,7601.466,6281.0027149.00
D57,3441.567,0701.0027149.00
D60,9281.657,5121.0027149.00
D64,5121.757,9541.0027149.00
D68,0961.858,3961.0027149.00
D71,6801.948,8381.0027149.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B12,28810,879255.920.000.000.000.001,048,576
E12,28810,879255.860.000.000.000.001,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K1,4791,47900
64K128K4400
512K1024K333300
1M2M4400
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
1,5360.13395.133.9899.001123,590
3,0720.25395.133.9899.001123,590
6,1440.50395.130.00100.000122,359
9,2160.75395.130.00100.000122,359
12,2881.00395.130.00100.000122,359
14,7461.20395.130.00100.000122,359
17,2031.40395.130.00100.000122,359
19,6611.60395.130.00100.000122,359
22,1181.80395.130.00100.000122,359
24,5762.00395.130.00100.000122,359
36,8643.00395.130.00100.000122,359
49,1524.00395.130.00100.000122,359
73,7286.00395.130.00100.000122,359
98,3048.00395.130.00100.000122,359

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)
2,0480.20724,2911,5811.0091.00117
3,0720.30724,2911,5811.0091.00117
4,0960.40724,2911,5811.0091.00117
5,1200.50724,2911,5811.0091.00117
6,1440.60724,2911,5811.0091.00117
7,1680.70724,2911,5811.0091.00117
8,1920.80724,2911,5811.0091.00117
8,9600.88724,2911,5811.0091.00117
9,0880.89724,2911,5811.0091.00117
9,2160.90724,2911,5811.0091.00117
9,3440.91724,2911,5811.0091.00117
9,4720.93724,2911,5811.0091.00117
9,6000.94724,2911,5811.0091.00117
9,7280.95724,2911,5811.0091.00117
9,8560.96724,2911,5811.0091.00117
9,9840.98724,2911,5811.0091.00117
10,1120.99724,2911,5811.0091.00117
10,2401.00724,2911,5811.0091.00117
10,3681.01724,2911,5811.0091.00117
10,4961.03724,2911,5811.0091.00117
10,6241.04724,2911,5811.0091.00117
10,7521.05724,2911,5811.0091.00117
10,8801.06724,2911,5811.0091.00117
11,0081.08724,2911,5811.0091.00117
11,1361.09724,2911,5811.0091.00117
11,2641.10724,2911,5811.0091.00117
11,3921.11724,2911,5811.0091.00117
12,2881.20724,2911,5811.0091.00117
13,3121.30724,2911,5811.0091.00117
14,3361.40724,2911,5811.0091.00117
15,3601.50724,2911,5811.0091.00117
16,3841.60724,2911,5811.0091.00117
17,4081.70724,2911,5811.0091.00117
18,4321.80724,2911,5811.0091.00117
19,4561.90724,2911,5811.0091.00117
20,4802.00724,2911,5811.0091.00117

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
20.143681,01633996876.8/4141659.30/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
04-Dec 17:22156541714,141,6590/00/0/0/0/0/0
04-Dec 17:12171601,01624,066,2930/00/0/0/0/0/0
04-Dec 17:0210314341133,996,8770/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM Keyed state latch1540.00 00 
ASM allocation200.00 00 
ASM db client latch1,1960.00 00 
ASM map operation freelist290.00 00 
ASM map operation hash table11,7130.00 00 
ASM network background latch7300.00 00 
ASM network state latch480.00 00 
AWR Alerted Metric Element list18,9900.00 00 
Change Notification Hash table latch6000.00 00 
Consistent RBA3800.00 00 
DML lock allocation1,7500.00 00 
Event Group Locks1880.00 00 
FAL Queue480.00 00 
FOB s.o list latch2,9860.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 latch3,5060.00 06760.00
JS Sh mem access50.00 00 
JS queue access latch10.00 00 
JS queue state obj latch12,9960.00 00 
JS slv state obj latch1270.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch3,4800.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 latch6000.00 00 
KTF sga latch90.00 05630.00
KWQS pqueue ctx latch310.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch1,0930.00 00 
MQL Tracking Latch0  0350.00
Memory Management Latch10.00 06000.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 Latch200.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process6840.00 00 
OS process allocation4,0420.00 00 
OS process: request allocation1540.00 00 
PL/SQL warning settings1580.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch3000.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 05980.00
SQL memory manager workarea list latch40,6160.00 00 
Shared B-Tree1590.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 latch4,1760.00 00 
active service list4,0930.00 01,1510.00
archive control300.00 00 
archive process latch1440.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles980.00 00 
cache buffers chains95,9930.00 04940.00
cache buffers lru chain1,1090.00 01,2640.00
cache table scan latch30.00 030.00
call allocation5690.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch1630.00 00 
channel operations parent latch12,4110.00 00 
checkpoint queue latch392,6650.00 07770.00
client/application info3230.00 00 
compile environment latch1100.00 00 
corrupted undo seg latch1200.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch280.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch280.00 00 
dml lock allocation280.00 00 
done queue latch10.00 00 
dummy allocation2210.00 00 
enqueue freelist latch10.00 033,9380.00
enqueue hash chains37,0280.00 00 
enqueues1380.00 00 
fifth spare latch10.00 00 
file cache latch5060.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 tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch210.00 01050.00
hash table modification latch710.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch10.00 00 
interrupt manipulation10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch340.00 0330.00
job_queue_processes free list latch660.00 00 
job_queue_processes parameter latch4240.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch1880.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock250.00 00 
ksuosstats global area1830.00 00 
ksv allocation latch760.00 00 
ksv class latch1390.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1540.00 00 
ktm global data220.00 00 
kwqbsn:qsga650.00 00 
lgwr LWN SCN9020.00 00 
list of block allocation1050.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch70.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
managed standby latch480.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch10.00 00 
messages27,2600.00 00 
mostly latch-free SCN9160.550.0000 
msg queue latch10.00 00 
multiblock read objects80.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch280.00 00 
object queue header heap22,3810.00 040.00
object queue header operation25,3480.00 00 
object stats modification310.00 00 
parallel query alloc buffer4810.00 00 
parallel query stats10.00 00 
parameter list1000.00 00 
parameter table management5140.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue8110.00 07170.00
process allocation2290.00 0770.00
process group creation1540.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch2630.00 00 
query server freelists10.00 00 
queued dump request60.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation3,5130.00 03,0390.00
redo copy10.00 03,0391.02
redo writing6,5730.00 00 
resmgr group change latch700.00 00 
resmgr:active threads2210.00 00 
resmgr:actses change group480.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list2200.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 objects25,6330.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache1110.00 00 
session allocation3860.00 01890.00
session idle bit8640.00 00 
session queue latch10.00 00 
session state list latch2440.00 00 
session switching1060.00 00 
session timer6000.00 00 
shared pool11,8880.010.0000 
shared pool sim alloc30.00 00 
shared pool simulator620.00 00 
sim partition latch10.00 00 
simulator hash latch2,6680.00 00 
simulator lru latch3060.00 02,3340.00
sort extent pool490.00 00 
space background state object latch60.00 00 
space background task latch2,1800.280.0001,2030.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 latch1320.00 00 
transaction allocation4320.00 00 
undo global data2,3610.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Latch Miss Sources

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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
SYSSYSTEMI_SYSAUTH1 INDEX7,39217.02
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX4,0969.43
SYSSYSTEMI_OBJ# INDEX2,6246.04
SYSSYSTEMICOL$ TABLE2,1765.01
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX1,7924.13

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX56.85
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY_INDEX INDEX56.85
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE45.48
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY TABLE22.74
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE22.74

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX57.69
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY_INDEX INDEX57.69
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE46.15
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY TABLE23.08
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE23.08

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX57.69
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY_INDEX INDEX57.69
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE46.15
SYSSYSAUXWRH$_SYSMETRIC_SUMMARY TABLE23.08
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE23.08

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
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX739.42
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX435.55
SYSSYSAUXSMON_SCN_TIME TABLE263.35
SYSMANSYSAUXMGMT_METRICS_1DAY_PK INDEX212.71
SYSMANSYSAUXMGMT_SYSTEM_PERFORMANCE_LOG TABLE131.68

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX7312.81
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX427.37
SYSMANSYSAUXMGMT_METRICS_1DAY_PK INDEX183.16
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE132.28
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX111.93

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

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1100.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX20813.13
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_02 INDEX17611.11
SYSMANSYSAUXMGMT_SYSTEM_PERFORMANCE_LOG TABLE1449.09
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX1449.09
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE1449.09

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control427.140 31
dc_files3430.000 0343
dc_global_oids2290.440 051
dc_histogram_data720.000 01,532
dc_histogram_defs1348.210 03,953
dc_objects4541.540 02,014
dc_profiles330.000 01
dc_rollback_segments1,5640.000 067
dc_segments1091.830 3940
dc_tablespaces5690.000 018
dc_users3,9420.000 075
global database name1,2460.000 01
outstanding_alerts450.000 016


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY5450.187360.1400
DBLINK30.000 00
EDITION440.00770.0000
QUEUE300.001070.0000
SCHEMA510.000 00
SQL AREA7884.448,0151.1701
SQL AREA BUILD3384.850 00
SQL AREA STATS33100.0033100.0000
SUBSCRIPTION40.0040.0000
TABLE/PROCEDURE3133.511,2711.4900
TRIGGER940.001210.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 cache36,864.0036,864.0036,864.0036,864.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target12,288.0012,288.0012,288.0012,288.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target0.000.000.000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool896.00896.00896.00896.000STA/
large pool896.00896.00896.00896.000STA/
shared pool10,240.0010,240.0010,240.0010,240.000STA/
streams pool0.000.000.000.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
BOther226.88 6.136.4219193737
Freeable28.500.002.593.119 1111
PL/SQL0.490.400.010.04003535
SQL0.070.020.010.0105117
EOther226.65 6.136.4219193737
Freeable28.750.002.613.119 1111
PL/SQL0.410.340.010.04003535
SQL0.060.020.010.0105117

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers38,654,705,664 
Fixed Size2,233,392 
Redo Buffers37,298,176 
Variable Size12,616,469,456 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory896.00896.000.00
largefree memory895.63895.630.00
sharedCheckpoint queue128.02128.020.00
sharedFileOpenBlock120.32120.320.00
shareddb_block_hash_buckets356.00356.000.00
sharedfree memory8,591.788,590.58-0.01
sharedprivate strands107.80107.800.00
 buffer_cache36,864.0036,864.000.00
 fixed_sga2.132.130.00
 log_buffer35.5735.570.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
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 %
1,8020.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.001,8020.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/xjdss/adump  
audit_trailNONE  
compatible11.2.0.0.0  
control_files+DATA/xjdss/control01.ctl, +DATA/xjdss/control02.ctl  
db_block_size8192  
db_cache_size38654705664  
db_domain    
db_files4096  
db_namexjdss  
db_writer_processes6  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=xjdssXDB)  
java_pool_size939524096  
large_pool_size939524096  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=130.89.2.83)(PORT=1521))))  
log_archive_dest_1location=/arch1  
memory_target0  
nls_languageSIMPLIFIED CHINESE  
nls_territoryCHINA  
open_cursors300  
pga_aggregate_target12884901888  
processes5000  
remote_login_passwordfileEXCLUSIVE  
session_cached_cursors200  
sessions7552  
shared_pool_reserved_size629145600  
shared_pool_size10737418240  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA/xjdss/control01.ctl  
+DATA/xjdss/control02.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 Report written to awrrpt_1_1049_1050.html