Enter value for report_name: awrrpt_1_500_0800.html Using the report name awrrpt_1_500_0800.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 840-843

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
XJDSS2903669701xjdss111-Oct-13 11:1011.2.0.3.0NO

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:84023-Nov-13 05:00:1144 3.5
End Snap:84323-Nov-13 08:00:5347 3.3
Elapsed:  180.70 (mins)  
DB Time:  54,599,914,839.65 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 43,136M 43,136MStd Block Size: 8K
Shared Pool Size: 6,400M 6,400MLog Buffer: 25,892K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 302,152,534.9 986,745,448.9 1.8E+07 1.3E+08
DB CPU(s): 302,152,534.9 986,745,448.8 1.8E+07 1.3E+08
Redo size: 8,993.0 29,368.7  
Logical reads: 379.9 1,240.8  
Block changes: 60.2 196.6  
Physical reads: 0.1 0.4  
Physical writes: 3.5 11.4  
User calls: 2.4 7.7  
Parses: 1.6 5.3  
Hard parses: 0.1 0.3  
W/A MB processed: 0.1 0.2  
Logons: 0.1 0.2  
Executes: 17.2 56.3  
Rollbacks: 0.0 0.0  
Transactions: 0.3   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.97In-memory Sort %: 100.00
Library Hit %: 98.69Soft Parse %: 93.55
Execute to Parse %: 90.66Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 5.13197640E+12% Non-Parse CPU: 89.96

Shared Pool Statistics

BeginEnd
Memory Usage %: 72.01 72.04
% SQL with executions>1: 98.42 91.30
% Memory for SQL w/exec>1: 88.78 69.85

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 3,275,994,890,091 100.00 
control file sequential read15,421910.00System I/O
log file sync1,251210.00Commit
ADR block file read128150.00Other
enq: TM - contention102560.00Application

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

Load Average BeginLoad Average End%User%System%WIO%Idle
0.28 0.26 0.4 0.2 0.0 99.4
Instance CPU

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

BeginEnd
Host Mem (MB): 81,920.0 81,920.0
SGA use (MB): 51,200.0 51,200.0
PGA use (MB): 381.1 386.1
% Host Mem used for SGA+PGA: 62.97 62.97

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU3,275,994,890,090.72100.00
sql execute elapsed time194.630.00
PL/SQL execution elapsed time21.820.00
parse time elapsed9.310.00
hard parse elapsed time6.610.00
hard parse (sharing criteria) elapsed time3.890.00
connection management call elapsed time1.200.00
failed parse elapsed time0.510.00
repeated bind elapsed time0.110.00
PL/SQL compilation elapsed time0.080.00
sequence load elapsed time0.010.00
DB time3,275,994,890,379.24 
background elapsed time328.60 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME6,172 
AVG_IDLE_TIME1,077,006 
AVG_IOWAIT_TIME62 
AVG_SYS_TIME1,850 
AVG_USER_TIME3,866 
BUSY_TIME213,766 
IDLE_TIME34,480,956 
IOWAIT_TIME4,213 
SYS_TIME73,023 
USER_TIME140,743 
LOAD00
OS_CPU_WAIT_TIME209,000 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES0 
VM_OUT_BYTES38,596,608 
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
23-Nov 05:00:110.28     
23-Nov 08:00:530.260.620.410.2199.380.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  3,275,994,890,091 100.00
System I/O15,4210910.00
Commit1,2510210.00
Other2000140.00
User I/O2,1050000.00
Application7710000.00
Concurrency239090.00
Network22,3770000.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 read15,4210914.640.00
log file sync1,2510210.380.00
ADR block file read1280150.040.00
enq: TM - contention1002560.000.00
resmgr:internal state change210001000.000.00
ASM file metadata operation1001300.000.00
SQL*Net break/reset to client7700000.230.00
Disk file operations I/O2690000.080.00
SQL*Net message to client20,7370006.250.00
db file scattered read190050.010.00
direct path write temp400020.010.00
direct path read180040.010.00
CSS initialization300160.000.00
SQL*Net more data from client1,6400000.490.00
utl_file I/O1,7390000.520.00
db file sequential read200010.010.00
ADR block file write200010.010.00
CSS operation: action30030.000.00
CSS operation: query180000.010.00
latch free30010.000.00
SQL*Net message from client20,737054,12526106.25 
jobq slave wait24,30310012,1415007.32 
Streams AQ: waiting for messages in the queue2,21110010,84149030.67 
wait for unread message on broadcast channel11,0099810,8389853.32 
PL/SQL lock timer1100110000.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
os thread startup4280511190.1315.48
db file parallel write6,81701122.053.27
control file sequential read12,21701013.682.90
log file parallel write5,7280611.731.93
db file sequential read6910690.211.89
control file parallel write4,3370511.311.63
ASM file metadata operation3,2510000.980.10
resmgr:internal state change210001000.000.06
rdbms ipc reply1001270.000.04
ADR block file read480020.010.03
Disk file operations I/O6,9510002.090.02
CSS initialization100150.000.00
latch free180010.010.00
db file async I/O submit6,8170002.050.00
LGWR wait for redo copy1170000.040.00
ADR block file write150010.000.00
log file sync40020.000.00
CSS operation: action10030.000.00
asynch descriptor resize580100000.170.00
CSS operation: query60000.000.00
rdbms ipc message73,69393217,342294922.20 
DIAG idle wait21,32810021,32810006.42 
Space Manager: slave idle wait2,8139913,96549640.85 
wait for unread message on broadcast channel10,84210010,84210003.27 
class slave wait634010,842171010.19 
ASM background timer2,167010,83850010.65 
smon timer428610,8382580370.01 
pmon timer3,61210010,83630001.09 
Streams AQ: qmn coordinator idle wait7745010,836140000.23 
Streams AQ: qmn slave idle wait387010,836280000.12 
shared server idle wait36110010,830300000.11 
dispatcher timer18010010,800600010.05 
VKRM Idle107,25172510030.00 
SQL*Net message from client6080110.18 
KSV master wait1840000.06 

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 read17648.94.51.121.022.22.3  
ADR block file write35100.0       
ADR file lock42100.0       
ASM file metadata operation3253100.0     .0 
CSS initialization4    75.025.0  
CSS operation: action4  100.0     
CSS operation: query2483.316.7      
Disk file operations I/O722199.0.7.3.0    
LGWR wait for redo copy117100.0       
SQL*Net break/reset to client770100.0       
SQL*Net message to client21.2K100.0       
SQL*Net more data from client1640100.0       
asynch descriptor resize580100.0       
buffer busy waits1100.0       
control file parallel write434185.04.24.54.12.0.2  
control file sequential read27.6K94.42.11.9.9.7.0  
db file async I/O submit6814100.0       
db file parallel write681557.815.321.63.91.3.2  
db file scattered read1910.515.826.336.85.35.3  
db file sequential read7112.5.11.545.347.52.8.1 
direct path read1866.7  11.122.2   
direct path write temp4151.212.226.87.3 2.4  
enq: TM - contention1      100.0 
latch free2181.09.59.5     
latch: cache buffers chains4100.0       
latch: shared pool1100.0       
library cache: mutex X19100.0       
log file parallel write572785.83.54.73.81.8.4.0 
log file sync125681.34.78.13.31.9.6  
os thread startup428      100.0 
rdbms ipc reply1      100.0 
reliable message4100.0       
resmgr:internal state change4      100.0 
utl_file I/O173999.8 .1.1.1   
ASM background timer2168       100.0
DIAG idle wait21.3K      100.0 
KSV master wait197100.0       
PL/SQL lock timer1      100.0 
SQL*Net message from client21.3K75.315.81.1.1.1.0.37.3
Space Manager: slave idle wait2792   .0.1.1.299.5
Streams AQ: qmn coordinator idle wait77450.0      50.0
Streams AQ: qmn slave idle wait387       100.0
Streams AQ: waiting for messages in the queue2211    .6.21.298.0
class slave wait63738.1 1.914.38.34.91.730.8
dispatcher timer181       100.0
jobq slave wait24.3K  .0.0.0 100.0 
pmon timer3612       100.0
rdbms ipc message73.7K1.7.4.3.81.01.032.462.4
shared server idle wait361       100.0
smon timer41       100.0
wait for unread message on broadcast channel21.9K  .0 .3.399.3 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ASM file metadata operation1100.0 .0     
db file sequential read199.9.1      
enq: TM - contention1   100.0    
log file parallel write1100.0.0      
os thread startup428  99.1.9    
rdbms ipc reply1  100.0     
resmgr:internal state change4  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$USERS3,269,848,563,8503,269,848,563,62511,462
xjdss63002,607
SYS$BACKGROUND00049
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 21050500068010
xjdss 0018000155810
SYS$BACKGROUND 76436434510000

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
76.79176.790.00312167423497.650.14b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
48.31182.680.00458047524521.500.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
45.6532,5960.000.00215440656752.070.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
23.643600.070.009488423991231.950.00aykvshm7zsabd   select size_for_estimate, size...
19.88119.880.00340105123032.570.805zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
19.641610.120.008073465568751.090.00dbvkky621gqtr MMON_SLAVE SELECT /*+ parallel */ EXTRACT...
14.838920.020.0038300427955112.110.00424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, for...
8.866970.010.000.000.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
6.2732.090.00685877778593.4297.47350myuyx0t1d6   insert into wrh$_tablespace_st...
6.1123.060.00502945001672.840.00bunssq950snhf   insert into wrh$_sga_target_ad...

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
5,679,212,352,462.198926,366,829,991.55173.3614.8338300427955112.110.00424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, for...
4,775,701,676,768.654,3041,109,596,114.49145.784.61103611545181309.900.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
3,177,654,532,419.561,5032,114,207,939.0797.005.4957896245361366.370.004y1y43113gv8f   delete from histgrm$ where obj...
2,243,414,977,636.113606,231,708,271.2168.4823.649488423991231.950.00aykvshm7zsabd   select size_for_estimate, size...
2,157,363,134,818.5612,157,363,134,818.5665.850.99218165366674409.250.047qx7y9h2rkt9g DBMS_SCHEDULER SELECT ddf.file_name file_name...
2,022,146,620,043.973605,617,073,944.5761.733.2462396968999840.720.00772s25v1y0x8k   select shared_pool_size_for_es...
1,585,754,099,357.651619,849,404,343.8448.4119.648073465568751.090.00dbvkky621gqtr MMON_SLAVE SELECT /*+ parallel */ EXTRACT...
1,376,779,774,183.482,415570,095,144.5942.032.0367705563719723.970.006amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
885,072,055,456.262,261391,451,594.6327.021.1775627081643790.590.00cvhk2j2gymzhd MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...
712,974,453,330.901803,960,969,185.1721.760.60119149787065334.420.0024g90qj2b7ywk OEM.CacheModeWaitPool BEGIN EMDW_LOG.set_context(MGM...
620,779,705,578.2116,07538,617,711.0818.950.7583087690035603.520.007sx5p1ug5ag12 MMON_SLAVE SELECT SPARE4 FROM SYS.OPTSTAT...
590,047,872,156.6310,30157,280,639.9518.010.9562085729454092.670.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
583,901,731,887.319,50961,405,166.8817.820.55105886144513089.020.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
491,706,544,802.271672,944,350,567.6815.011.5132640733978722.570.183am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
411,804,310,479.222,157190,915,303.8812.570.4984193071722672.500.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
393,365,906,212.353601,092,683,072.8112.010.6362740485828312.510.008p447s6p0rv6b   select java_pool_size_for_esti...
381,072,690,541.82524727,237,959.0511.630.6162239422629893.060.0063kf3an2j0pkc   insert into sys.wri$_optstat_h...
344,194,688,232.774,51476,250,484.7710.510.5167375936560087.280.006qg99cfg26kwb MMON_SLAVE SELECT COUNT(UNQ) UNQ, COUNT(P...
288,877,698,524.513,22889,491,232.508.820.17174575884141624.040.005hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
276,585,055,370.303,22885,683,102.658.440.17158595985785397.540.007qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
251,999,682,456.122,261111,454,967.927.690.4063303778752040.110.00g1xapjmt4vm5c MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...
245,853,352,601.005,76742,631,065.137.500.2696199177750257.620.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
245,853,348,736.962,253109,122,658.127.500.3962502122459518.360.01d0xmnp08rhfbg   insert into sys.wri$_optstat_h...
245,853,329,894.20406,146,333,247.357.500.2789905005830562.300.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
239,707,129,173.16366,658,531,365.927.320.5841269401667111.050.009juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
239,707,015,018.451239,707,015,018.457.3276.79312167423497.650.14b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
239,707,002,735.42874274,264,305.197.320.3568323932839683.510.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
239,706,951,304.15723,329,263,212.567.320.3665754204170663.030.005fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
233,560,783,480.16366,487,799,541.127.130.23101902610593437.210.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
233,560,681,307.6414,06716,603,446.467.130.3370071848128394.410.00cn39cg7kr98v6 DBMS_SCHEDULER SELECT P.VALCHAR FROM SYS.OPTS...
233,560,681,301.232,253103,666,525.217.130.4255157395381969.250.00330q95smuwnv9   update hist_head$ set bucket_c...
221,268,184,024.101812,292,676,890.236.7548.31458047524521.500.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
196,682,620,221.94404,917,065,505.556.002.866866604344669.840.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
190,536,280,727.141801,058,534,892.935.820.3751831233927118.751.577vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
153,658,304,991.66186826,119,919.314.690.2756893836615085.710.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
147,511,928,149.46351420,261,903.564.500.2268538472830507.910.000k8522rmdzg4k   select privilege# from sysauth...
141,365,675,524.50322439,023,837.034.320.2168432768339256.320.0015aftu6tf4xd0 MMON_SLAVE SELECT /*+ ordered use_nl(o c ...
135,219,405,108.46226,146,336,595.844.130.07195760206602282.380.007d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
122,926,645,826.06199617,721,838.323.750.1868846026572533.500.00cumjq42201t37   select u1.user#, u2.user#, u3....
110,633,977,433.38244,609,749,059.723.382.185072226190020.010.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
98,341,330,516.1832,5963,016,975.413.0045.65215440656752.070.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
92,195,005,776.79437210,972,553.262.810.1186902635287765.840.00dy0yxpyu2wcbv MMON_SLAVE SELECT /*+ all_rows */ C.NAME ...
92,194,984,601.77180512,194,358.902.810.1754950580291676.170.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
86,048,655,005.49152566,109,572.402.630.08108665128121393.100.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
79,902,319,961.07199401,519,195.782.440.1267429825194790.479.5447a50dvdgnxc2   update sys.job$ set failures=0...
73,755,976,560.03199370,633,048.042.250.1548144216347491.303.54aq8yqxyyb40nn   update sys.job$ set this_date=...
67,609,670,861.26167,609,670,861.262.0619.88340105123032.570.805zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
61,463,386,247.61242,560,974,426.981.880.05131579436221124.000.004nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
61,463,323,227.45180341,462,906.821.880.06101607384945613.110.0034rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
55,316,988,476.30531104,175,119.541.690.0692642754105349.320.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
49,170,676,650.4272567,821,622.971.500.0767519878955314.810.00bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
49,170,669,747.76124396,537,659.261.500.1532210112768423.100.00d89c1mh5pvbkz MMON_SLAVE SELECT /*+ rule */ U.NAME, OT....
49,170,669,734.99224,585,334,867.501.502.951664647350937.573.12g5m0bnvyy37b1 DBMS_SCHEDULER select sql_id, plan_hash_value...
49,170,665,978.9486,146,333,247.371.500.3215609091046700.650.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
49,170,661,187.64361,365,851,699.661.500.1729052089328002.380.006k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
49,170,660,716.58180273,170,337.311.500.05108391369183890.620.007mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
43,024,336,029.15161267,231,900.801.310.0854575863243211.530.007tt3tfgb57599   delete /*+ index(mm) */ from s...
43,024,315,183.84175245,853,229.621.310.0946566135445856.1111.8839c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
43,024,310,574.16314,341,436,858.051.316.27685877778593.4297.47350myuyx0t1d6   insert into wrh$_tablespace_st...
36,878,005,986.87301,229,266,866.231.130.0658602561596197.090.001tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
36,878,002,310.94208177,298,088.031.130.0568118516219558.960.003d40u5r2jfcsd   update ind$ set ts#=:2, file#=...
36,877,994,471.20152242,618,384.681.130.0570651559421420.270.00459f3z9u4fb3u   select value$ from props$ wher...
36,877,980,499.26312,292,660,166.421.133.69998959554259.360.004dy1xm4nxc0gf   insert into wrh$_system_event ...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
6.1132.0491.316.27685877778593.4297.47350myuyx0t1d6   insert into wrh$_tablespace_st...
0.1610.162.3719.88340105123032.570.805zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
0.1110.111.5876.79312167423497.650.14b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
0.0920.051.382.951664647350937.573.12g5m0bnvyy37b1 DBMS_SCHEDULER select sql_id, plan_hash_value...
0.0310.030.492.64465371685979.131.2573629tmfbjzrh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
0.011990.000.170.1267429825194790.479.5447a50dvdgnxc2   update sys.job$ set failures=0...
0.011750.000.160.0946566135445856.1111.8839c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
0.0132,5960.000.0945.65215440656752.070.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
0.011800.000.090.3751831233927118.751.577vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
0.011990.000.080.1548144216347491.303.54aq8yqxyyb40nn   update sys.job$ set this_date=...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
2,450,61032,59675.1859.4945.652154408vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
2,443,66718135,759.2859.3248.314580405k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
844,6731844,673.0020.5176.7931216.1b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
249,6851249,685.006.0619.8834010.85zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
225,037892252.285.4614.83383000424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, for...
159,3872,26170.493.871.17756270cvhk2j2gymzhd MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...
101,0922,41541.862.452.036770506amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
95,1761,50363.322.315.495789604y1y43113gv8f   delete from histgrm$ where obj...
65,483401,637.081.592.866866600njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
59,766159,766.001.452.9641523063n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
57,1424,51412.661.390.516737506qg99cfg26kwb MMON_SLAVE SELECT COUNT(UNQ) UNQ, COUNT(P...
56,5252,26125.001.370.40633030g1xapjmt4vm5c MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
7741774.0063.7019.88340105123032.570.805zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
7482374.0061.562.951664647350937.573.12g5m0bnvyy37b1 DBMS_SCHEDULER select sql_id, plan_hash_value...
4371437.0035.9776.79312167423497.650.14b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
0360.000.000.134715473087430.140.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
05,7670.000.000.2696199177750257.620.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
05310.000.000.0692642754105349.320.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
01800.000.000.1754950580291676.170.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
010.000.000.541134660980340.660.140j6d9y40st3k1 DBMS_SCHEDULER select client_name, status fr...
03510.000.000.2268538472830507.910.000k8522rmdzg4k   select privilege# from sysauth...
0400.000.002.866866604344669.840.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...

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
12,55312,553112,553.000.0020246.775zruc4v6y32f9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
12,48812,48889214.000.0020141.94424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, for...
1,7221,72211,722.000.002777.4273629tmfbjzrh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
1,5441,54411,544.000.002490.327qx7y9h2rkt9g DBMS_SCHEDULER SELECT ddf.file_name file_name...
7227223240.670.001164.52350myuyx0t1d6   insert into wrh$_tablespace_st...
144144364.000.00232.26fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
66661670.400.00106.453am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
3636218.000.0058.06g5m0bnvyy37b1 DBMS_SCHEDULER select sql_id, plan_hash_value...
2828128.000.0045.16b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
00360.00 0.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
32,59632,5961.0045.652154408vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
16,07516,0751.000.758308707sx5p1ug5ag12 MMON_SLAVE SELECT SPARE4 FROM SYS.OPTSTAT...
14,06700.000.33700710cn39cg7kr98v6 DBMS_SCHEDULER SELECT P.VALCHAR FROM SYS.OPTS...
10,30114,6321.420.95620850cm5vu20fhtnq1   select /*+ connect_by_filterin...
9,5099,5091.000.551058808t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
5,7675,7671.000.26961990089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
4,5144,5141.000.516737506qg99cfg26kwb MMON_SLAVE SELECT COUNT(UNQ) UNQ, COUNT(P...
4,3044,3041.004.611036106v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
3,22800.000.171745705hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
3,2283,2281.000.171585907qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
2,41533,28913.782.036770506amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
2,26100.001.17756270cvhk2j2gymzhd MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...
2,26100.000.40633030g1xapjmt4vm5c MMON_SLAVE SELECT SU.NAME, SO.NAME, A.STA...
2,2532,2531.000.42551570330q95smuwnv9   update hist_head$ set bucket_c...
2,2532,2531.000.39625020d0xmnp08rhfbg   insert into sys.wri$_optstat_h...
2,1571990.090.498419305ms6rbzdnq16t   select job, nvl2(last_date, 1,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3513512.010k8522rmdzg4k   select privilege# from sysauth...
35110,3012.01cm5vu20fhtnq1   select /*+ connect_by_filterin...
1991991.1447a50dvdgnxc2   update sys.job$ set failures=0...
1991991.14aq8yqxyyb40nn   update sys.job$ set this_date=...
1991991.14cumjq42201t37   select u1.user#, u2.user#, u3....
1985311.1308bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1805,7671.03089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1801801.0308vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
1805341.0324dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
1801801.0334rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1801801.037vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
1809,5091.038t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
1807251.03bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
1801801.03btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
1803601.03c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
1801801.03dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
1751751.002mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
1751751.0039c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
39,158,91610.5863n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
35,995,81510.543wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
34,558,34010.5163n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
30,452,393360.45a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
27,461,962220.417d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
27,349,447720.415fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
26,071,553360.399juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
23,314,830360.357wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
21,690,82680.329dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
18,957,9921240.28d89c1mh5pvbkz MMON_SLAVE SELECT /*+ rule */ U.NAME, OT....
18,040,805360.276k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
16,541,721360.25b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
15,817,745360.24cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
14,076,290360.2105xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
13,414,992400.20bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
12,299,56910.181cdcp34r6c7px DBMS_SCHEDULER /* SQL Analyze(1) */ select /*...
12,160,9681860.184jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
10,517,58110.16b5y9gf2h9c6x0 DBMS_SCHEDULER /* SQL Analyze(1) */ select /*...
9,846,02210.150j6d9y40st3k1 DBMS_SCHEDULER select client_name, status fr...
9,290,901300.141tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
9,290,4783220.1415aftu6tf4xd0 MMON_SLAVE SELECT /*+ ordered use_nl(o c ...
9,159,3162170.148vj58v5cxstjj MMON_SLAVE SELECT /*+ ordered use_nl(u io...
9,077,46260.14a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
8,078,451200.129dy457uf4uxzd DBMS_SCHEDULER SELECT /*+ all_rows */ '"'||UI...
7,993,29930.12gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
6,943,54810.1063n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
4,655,53210.0763n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
4,647,42010.0763n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
4,133,8921750.062mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
3,754,71410.068p9z2ztb272bm   SELECT sx.instance_number, sx...
3,689,4231990.05cumjq42201t37   select u1.user#, u2.user#, u3....
3,402,7461800.057vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
3,365,977360.059juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
3,322,19910.053wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
3,311,58630.0566gs90fyynks7   insert into wrh$_instance_reco...
3,067,493120.0574fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
2,834,8011750.0439c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2,669,373180.04f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
2,639,0621770.04dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
2,638,09880.049dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2,489,5022,1570.045ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,460,7585240.0463kf3an2j0pkc   insert into sys.wri$_optstat_h...
2,355,28410.0463n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
2,355,28410.0463n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
2,355,28410.0463n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
2,351,22810.0463n9pwutt8yzw DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
2,313,02110.0386521pa77y28j   SELECT (case when snap_id = :b...
2,309,2701990.0347a50dvdgnxc2   update sys.job$ set failures=0...
2,304,2011850.035r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
2,276,3153610.03d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
2,255,400180.03fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
2,236,6631860.033x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
2,215,28330.03gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2,069,546400.030njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
1,958,6542,4150.036amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,925,70910.034g46czps3t55u   SELECT sum(case when snap_id ...
1,917,578180.037hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
1,917,476180.0385snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
1,916,760420.037av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
1,916,751520.039ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
1,893,870240.034nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
1,891,25330.0384k66tf2s7y1c   insert into wrh$_bg_event_summ...
1,859,5363,2280.035hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
1,852,2023,2280.037qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,799,5272,2530.03d0xmnp08rhfbg   insert into sys.wri$_optstat_h...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
963gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
963gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
9418p9z2ztb272bm   SELECT sx.instance_number, sx...
9119947a50dvdgnxc2   update sys.job$ set failures=0...
912,4156amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
911274fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
901752mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
9014g46czps3t55u   SELECT sum(case when snap_id ...
9014g46czps3t55u   SELECT sum(case when snap_id ...
901864jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
901855r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
901807vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
90186521pa77y28j   SELECT (case when snap_id = :b...
90369juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
90369juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
9036b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
9018f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
89427av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
89187hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
891807mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
891885snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
89188kzksw8m2rk68   SELECT NVL(VALUE, 'None') FROM...
89529ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
89199aq8yqxyyb40nn   update sys.job$ set this_date=...
8918auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
89199cumjq42201t37   select u1.user#, u2.user#, u3....
89361d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
89177dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
8818034rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
881863x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
88244nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
883,2285hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
883,2285hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
88367wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
8836a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
8836cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
8818fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
8732215aftu6tf4xd0 MMON_SLAVE SELECT /*+ ordered use_nl(o c ...
87301tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
87227d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
863,2287qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
85725fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
85366k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
8589dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
8589dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
856a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
843605xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
8417539c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
842,1575ms6rbzdnq16t   select job, nvl2(last_date, 1,...
8240bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
81400njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
772178vj58v5cxstjj MMON_SLAVE SELECT /*+ ordered use_nl(u io...
75124d89c1mh5pvbkz MMON_SLAVE SELECT /*+ rule */ U.NAME, OT....
731,5034y1y43113gv8f   delete from histgrm$ where obj...
7352463kf3an2j0pkc   insert into sys.wri$_optstat_h...
731617tt3tfgb57599   delete /*+ index(mm) */ from s...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
6332,5968vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
6332,5968vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
6113wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
6113wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
6113wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05xcf43d9psvmSELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
0j6d9y40st3k1 select client_name, status from DBA_AUTOTASK_CLIENT where lower(client_name) = 'sql tuning advisor'
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
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
15aftu6tf4xd0 SELECT /*+ ordered use_nl(o c cu h) index(u i_user1) index(o i_obj2) index(ci_obj#) index(cu i_col_usage$) index(h i_hh_obj#_intcol#) */ C.NAME COL_NAME, C.TYPE# COL_TYPE, C.CHARSETFORM COL_CSF, C.DEFAULT$ COL_DEF, C.NULL$ COL_NULL, C.PROPERTY COL_PROP, C.COL# COL_UNUM, C.INTCOL# COL_INUM, C.OBJ# COL_OBJ, C.SCALE COL_SCALE, H.BUCKET_CNT H_BCNT, (T.ROWCNT-H.NULL_CNT)/GREATEST(H.DISTCNT, 1) H_PFREQ, C.LENGTH COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP, CU.EQUIJOIN_PREDS CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP, CU.NONEQUIJOIN_PREDS CU_NEJP, CU.NULL_PREDS NP FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.COL$ C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE :B3 = '0' AND U.NAME = :B2 AND O.OWNER# = U.USER# AND O.TYPE# = 2 AND O.NAME = :B1 AND O.OBJ# = T.OBJ# AND O.OBJ# = C.OBJ# AND C.OBJ# = CU.OBJ#(+) AND C.INTCOL# = CU.INTCOL#(+) AND C.OBJ# = H.OBJ#(+) AND C.INTCOL# = H.INTCOL#(+) UNION ALL SELECT /*+ ordered use_nl(c) */ C.KQFCONAM COL_NAME, C.KQF CODTY COL_TYPE, DECODE(C.KQFCODTY, 1, 1, 0) COL_CSF, NULL COL_DEF, 0 COL_NULL, 0 COL_PROP, C.KQFCOCNO COL_UNUM, C.KQFCOCNO COL_INUM, O.KQFTAOBJ COL_OBJ, DECODE(C.KQFCODTY, 2, -127, 0) COL_SCALE, H.BUCKET_CNT H_BCNT, (ST.ROWCNT-NULL_CNT)/GREATEST(H.DISTCNT, 1) H_PFREQ, DECODE(C.KQFCODTY, 2, 22, C.KQFCOSIZ) COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP, CU.EQUIJOIN_PREDS CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP, CU.NONEQUIJOIN_PREDS CU_NEJP, CU.NULL_PREDS NP FROM SYS.X$KQFTA O, SYS.TAB_STATS$ ST, SYS.X$KQFCO C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE :B3 != '0' AND :B2 = 'SYS' AND O.KQFTANAM = :B1 AND O.KQFTAOBJ = ST.OBJ#(+) AND O.KQFTAOBJ = C.KQFCOTOB AND C.KQFCOTOB = CU.OBJ#(+) AND C.KQFCOCNO = CU.INTCOL#(+) AND C.KQFCOTOB = H.OBJ#(+) AND C.KQFCOCNO = H.INTCOL#(+)
1cdcp34r6c7px /* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("RETRY_COUNT")), to_char(substrb(dump(min("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(count("GOOD_COUNT")), to_char(substrb(dump(min("GOOD_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("GOOD_COUNT"), 16, 0, 32), 1, 120)), to_char(count("LG_JOB_LOG_ID")), to_char(substrb(dump(min("LG_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("LG_DATE")), to_char(substrb(dump(min("LG_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DATE"), 16, 0, 32), 1, 120)), to_char(count("LG_PRIORITY")), to_char(substrb(dump(min("LG_PRIORITY "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("LG_DURATION")), to_char(substrb(dump(min("LG_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DURATION"), 16, 0, 32), 1, 120)), to_char(count("LG_CPU_TIME")), to_char(substrb(dump(min("LG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("LG_TEMP")), to_char(substrb(dump(min("LG_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_TEMP"), 16, 0, 32), 1, 120)), to_char(count("LG_DOP")), to_char(substrb(dump(min("LG_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DOP"), 16, 0, 32), 1, 120)), to_char(count("LG_IO_RATE")), to_char(substrb(dump(min("LG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_IO_RATE"), 16, 0, 32), 1 , 120)), to_char(count("LG_UNDO_RATE")), to_char(substrb(dump(min("LG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LG_CPU_WAIT")), to_char(substrb(dump(min("LG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_IO_WAIT")), to_char(substrb(dump(min("LG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_UNDO_WAIT")), to_char(substrb(dump(min("LG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_TEMP_WAIT")), to_char(substrb(dump(min("LG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_CONCURRENCY")), to_cha r(substrb(dump(min("LG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("LG_CONTENTION")), to_char(substrb(dump(min("LG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("LT_JOB_LOG_ID")), to_char(substrb(dump(min("LT_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("LT_DATE")), to_char(substrb(dump(min("LT_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DATE"), 16, 0, 32), 1, 120)), to_char(count("LT_PRIORITY")), to_char(substrb(dump(min("LT_PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("LT_TERM_CODE")), to_char(substrb(dump(min("LT_TERM_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_TERM_CODE"), 16, 0, 32), 1, 120)), to_char(count("LT_ERROR")), to_char(substrb(dump(min("LT_ERROR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_ERROR"), 16, 0, 32), 1, 120)), to_char(count("LT_DURATION")), to_char(substrb(dump(min("LT_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DURATION"), 16, 0, 32), 1, 120)), to_char(count("LT_CPU_TIME")), to_char(substrb(dump(min("LT_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("LT_TEMP")), to_char(substrb(dump(min("LT_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_TEMP"), 16, 0, 32), 1, 120)), to_char(count("LT_DOP")), to_char(substrb(dump(min("LT_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DOP"), 16, 0, 32), 1, 120)), to_char(count( "LT_IO_RATE")), to_char(substrb(dump(min("LT_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LT_UNDO_RATE")), to_char(substrb(dump(min("LT_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LT_CPU_WAIT")), to_char(substrb(dump(min("LT_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_IO_WAIT")), to_char(substrb(dump(min("LT_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_UNDO_WAIT")), to_char(substrb(dump(min("LT_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_TEMP_WAIT")), to_char(substrb(dump(min("LT_TEM P_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_CONCURRENCY")), to_char(substrb(dump(min("LT_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("LT_CONTENTION")), to_char(substrb(dump(min("LT_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("MG_DURATION")), to_char(substrb(dump(min("MG_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_DURATION"), 16, 0, 32), 1, 120)), to_char(count("MG_CPU_TIME")), to_char(substrb(dump(min("MG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("MG_TEMP")), to_char(substrb(dump(min("MG_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump (max("MG_TEMP"), 16, 0, 32), 1, 120)), to_char(count("MG_DOP")), to_char(substrb(dump(min("MG_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_DOP"), 16, 0, 32), 1, 120)), to_char(count("MG_IO_RATE")), to_char(substrb(dump(min("MG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("MG_UNDO_RATE")), to_char(substrb(dump(min("MG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("MG_CPU_WAIT")), to_char(substrb(dump(min("MG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_IO_WAIT")), to_char(substrb(dump(min("MG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_UNDO_WAIT ")), to_char(substrb(dump(min("MG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_TEMP_WAIT")), to_char(substrb(dump(min("MG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_CONCURRENCY")), to_char(substrb(dump(min("MG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("MG_CONTENTION")), to_char(substrb(dump(min("MG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("INFO_FIELD_1")), to_char(substrb(dump(min("INFO_FIELD_1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_1"), 16, 0, 32), 1, 120)), to_char(count(case when "INFO_FIELD_2" is null then null else 1 end)), to_char(sum(sys_op_opnsize("INFO_FIELD_2"))), to_char(count("INFO_FIELD_3")), to_char(substrb(dump(min("INFO_FIELD_3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_3"), 16, 0, 32), 1, 120)), to_char(count("INFO_FIELD_4")), to_char(substrb(dump(min("INFO_FIELD_4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_4"), 16, 0, 32), 1, 120)), to_char(count("CLIENT_ID")), to_char(substrb(dump(min("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(count("OPERATION_ID")), to_char(substrb(dump(min("OPERATION_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERATION_ID"), 16, 0, 32), 1, 120)), to_char(count("TARGET_TYPE")), to_char(substrb(dump(min("TARGET_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TARGET_TYPE"), 16, 0, 32), 1, 120)) , to_char(count("TARGET_NAME")), to_char(substrb(dump(min("TARGET_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TARGET_NAME"), 16, 0, 32), 1, 120)), to_char(count("ATTRIBUTES")), to_char(substrb(dump(min("ATTRIBUTES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ATTRIBUTES"), 16, 0, 32), 1, 120)), to_char(count("ATTRIBUTES_OVERRIDE")), to_char(substrb(dump(min("ATTRIBUTES_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ATTRIBUTES_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(count("TASK_PRIORITY")), to_char(substrb(dump(min("TASK_PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TASK_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("PRIORITY_OVERRIDE")), to_char(substrb(dump(min("PRIORITY_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRIORITY_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(count( "STATUS")), to_char(substrb(dump(min("STATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("STATUS"), 16, 0, 32), 1, 120)), to_char(count("ARG_4")), to_char(substrb(dump(min("ARG_4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_4"), 16, 0, 32), 1, 120)), to_char(count("ARG_5")), to_char(substrb(dump(min("ARG_5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_5"), 16, 0, 32), 1, 120)), to_char(count("ARG_6")), to_char(substrb(dump(min("ARG_6"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_6"), 16, 0, 32), 1, 120)), to_char(count("WINDOW_NAME")), to_char(substrb(dump(min("WINDOW_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("WINDOW_NAME"), 16, 0, 32), 1, 120)), to_char(count("CURR_JOB_NAME")), to_char(substrb(dump(min("CURR_JOB_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "CURR_JOB_NAME"), 16, 0, 32), 1, 120)), to_char(count("CURR_WIN_START")), to_char(substrb(dump(min("CURR_WIN_START"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURR_WIN_START"), 16, 0, 32), 1, 120)), to_char(count("EST_TYPE")), to_char(substrb(dump(min("EST_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_TYPE"), 16, 0, 32), 1, 120)), to_char(count("EST_WEIGHT")), to_char(substrb(dump(min("EST_WEIGHT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_WEIGHT"), 16, 0, 32), 1, 120)), to_char(count("EST_DURATION")), to_char(substrb(dump(min("EST_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_DURATION"), 16, 0, 32), 1, 120)), to_char(count("EST_CPU_TIME")), to_char(substrb(dump(min("EST_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(coun t("EST_TEMP")), to_char(substrb(dump(min("EST_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_TEMP"), 16, 0, 32), 1, 120)), to_char(count("EST_DOP")), to_char(substrb(dump(min("EST_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_DOP"), 16, 0, 32), 1, 120)), to_char(count("EST_IO_RATE")), to_char(substrb(dump(min("EST_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("EST_UNDO_RATE")), to_char(substrb(dump(min("EST_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_UNDO_RATE"), 16, 0, 32), 1, 120)) from "SYS"."KET$_CLIENT_TASKS" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
1tgukkrqj3zhw SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 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, :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2, 3, 4 DESC
24dkx03u3rj6kSELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
24g90qj2b7ywkBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END;
2mysbczfp729xSELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
330q95smuwnv9update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5, null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10, distcnt=:11, lowval=:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2
34rks4d5suuxzSELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)
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#
39c8q6w3s3r8yUPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2)
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3d40u5r2jfcsdupdate ind$ set ts#=:2, file#=:3, block#=:4, intcols=:5, type#=:6, flags=:7, property=:8, pctfree$=:9, initrans=:10, maxtrans=:11, blevel=:12, leafcnt=:13, distkey=:14, lblkkey=:15, dblkkey=:16, clufac=:17, cols=:18, analyzetime=:19, samplesize=:20, dataobj#=:21, degree=decode(:22, 1, null, :22), instances=decode(:23, 1, null, :23), rowcnt=:24, pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27, spare4=:29, spare2=:30, spare6=:32where obj#=:1
3wrrjm9qtr2my SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL (JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
3x0kdm7z3yaswSELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
424h0nf7bhqzd SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NUL L as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED, sfetches as fetches, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, command_type, optimizer_env, bind_data, parsing_schema_name, parsing_user_id, plan_hash_value, optimizer_cost FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_ delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0)) T1, (SELECT sql_id, plan_hash_value, sum(CPU_TIME) AS scpu, sum(BUFFER_GETS) AS sbgets, sum(DISK_READS) AS sdreads, sum(DIRECT_WRITES) AS swrites, sum(ROWS_PROCESSED) AS srow, sum(FETCHES) AS sfetches, sum(EXECUTIONS) AS sexec, sum(END_OF_FETCH_COUNT) AS seofc, sum(ELAPSED_TIME) AS sela p, MAX(SNAP_ID) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS snap_id, MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS instance_number FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only captur e sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S )
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
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
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
4g46czps3t55u SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_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
4nw0ag3rg25h1INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE, TASK_COUNT) VALUES ( :1, :2, :3, :4)
4y1y43113gv8fdelete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3
5fk0v8km2f811select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5hfunyv38vwfpSELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1
5k5v1ah25fb2cBEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END;
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
5r8jah3jm5au2SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1
5uy533jsc8hyhDELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
5zruc4v6y32f9DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
63kf3an2j0pkcinsert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
63n9pwutt8yzw MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 ELSE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND BITAND(T.PROPERTY, 4294967296) != 4294967296 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.I NSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND B ITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL, 'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR ( BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL (S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0 ) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# T YPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 EL SE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(TP.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INS ERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT)) OR BITAND(TP.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND T.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITA ND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE ( DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
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
6amygb1ygg2y7INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5)
6k5agh28pr3wpselect propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6qg99cfg26kwbSELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1) leading(cc) */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2, 3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+ first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY, 1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS, 1025) = 0 AND ROWNUM < 2 )
6v7n0y2bq89n8BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;
73629tmfbjzrhDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
74fnxs1kfd150DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 )
772s25v1y0x8kselect shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7av8js40455qbSELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B2 AND TARGET_TYPE = :B1
7d92gmwphtza8SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP'
7hskd14849h8kSELECT GREATEST(0, NVL(TRUNC(TO_NUMBER(VALUE)/60, 2), 0)) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderOldestFile' AND HOST_URL = :B1
7mdacxfm37utkSELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND')
7qqnad1j615m7SELECT HOST_URL FROM MGMT_FAILOVER_TABLE WHERE FAILOVER_ID = :B1
7qx7y9h2rkt9gSELECT ddf.file_name file_name, vdf.status status, ddf.tablespace_name tablespace_name, '', ddf.autoextensible autoextensible, ddf.increment_by increment_by, ddf.maxbytes max_file_size, vdf.create_bytes, 'NA' os_storage FROM sys.dba_data_files ddf, v$datafile vdf /*+ all_rows use_concat */ WHERE (ddf.file_name = vdf.name) UNION ALL SELECT dtf.file_name file_name, vtf.status status, dtf.tablespace_name tablespace_name, '', dtf.autoextensible autoextensible, dtf.increment_by increment_by, dtf.maxbytes max_file_size, vtf.create_bytes, 'NA' os_storage FROM sys.dba_temp_files dtf, v$tempfile vtf WHERE (dtf.file_id = vtf.file#)
7sx5p1ug5ag12SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
7tt3tfgb57599delete /*+ index(mm) */ from sys.mon_mods_all$ mm where obj# = :1
7vcwzqf7mgk3bINSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC')
7wt7phk4xns75select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
81ky0n97v4zsg/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1)
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
85snhhhd1qmt7SELECT NVL(TO_NUMBER(SUM(VALUE)), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = 'EMD_NOTIFICATION.NotificationDelivery Subsystem' AND TIME > (SYSDATE-(1/(24*6))) AND HOST_URL = :B1
86521pa77y28jSELECT (case when snap_id = :begin_snap_id then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :inst_num AND (pga.snap_id = :begin_snap_id OR pga.snap_id = :end_snap_id ) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
8kzksw8m2rk68SELECT NVL(VALUE, 'None') FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderDirectory' AND HOST_URL = :B1
8p447s6p0rv6bselect java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice
8p9z2ztb272bm SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
8t43xdhf4d9x2SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 )
8vj58v5cxstjj SELECT /*+ ordered use_nl(u io i ito t itu po) */ IO.OBJ# IOBJN, I.TYPE# ITYPE, I.FLAGS IFLAGS, I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE, 1), I.ANALYZETIME, ITU.NAME TOWN, ITO.NAME TAB, I.BO# TOBJN, T.FLAGS TFLAGS, T.PROPERTY TPROP, ITO.TYPE# TTYPE, CASE WHEN BITAND(T.FLAGS, 16) = 0 THEN NULL ELSE T.ROWCNT END NROWS, PO.PARTTYPE PTYPE, PO.PARTCNT PCNT, PO.PARTKEYCOLS PTKCOLS, PO.FLAGS PFLAGS, MOD(PO.SPARE2, 256) SPTYPE FROM SYS.USER$ U, SYS.OBJ$ IO, SYS.IND$ I, SYS.OBJ$ ITO, SYS.USER$ ITU, SYS.TAB$ T, PARTOBJ$ PO WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND IO.TYPE#=1 AND IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER# AND ITO.OBJ#=T.OBJ# AND IO.OBJ#=PO.OBJ#(+) UNION ALL SELECT /*+ ordered use_nl(u io i ito t itu) */ IO.OBJ# IOBJN, I.TYPE# ITYPE, I.FLAGS IFLAGS, I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE, 1), I.ANALYZETIME, ITU.NAME TOWN, ITO.NAME TAB, I.BO# TOBJN, 0 TFLAGS, 0 TPROP, ITO.TYPE# TTYPE, NULL NROWS, NULL PTYPE, N ULL PCNT, NULL PTKCOLS, NULL PFLAGS, NULL SPTYPE FROM SYS.USER$ U, SYS.OBJ$ IO, SYS.IND$ I, SYS.OBJ$ ITO, SYS.USER$ ITU, SYS.CLU$ T WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND IO.TYPE#=1 AND IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER# AND ITO.OBJ#=T.OBJ#
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
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
9dy457uf4uxzd SELECT /*+ all_rows */ '"'||UI.NAME||'"' IND_OWNER, '"'||OIP.NAME||'"' IND_NAME, '"'||OIP.SUBNAME||'"' PART_NAME, OIP.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTP, SYS.TABPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDPART$ IP, SYS.OBJ$ OIP, SYS.USER$ UI WHERE UT.NAME = :B3 AND UT.USER# = OTP.OWNER# AND OTP.NAME = :B2 AND OTP.SUBNAME = :B1 AND OTP.NAMESPACE = 1 AND OTP.REMOTEOWNER IS NULL AND OTP.LINKNAME IS NULL AND OTP.TYPE# = 19 AND OTP.OBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = OIP.OBJ# AND OIP.OWNER# = UI.USER# UNION ALL SELECT '"'||UI.NAME||'"' IND_OWNER, '"'||OIP.NAME||'"' IND_NAME, '"'||OIP.SUBNAME||'"' PART_NAME, OIP.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTP, SYS.TABCOMPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDCOMPART$ IP, SYS.OBJ$ OIP, SYS.USER$ UI WHERE UT .NAME = :B3 AND UT.USER# = OTP.OWNER# AND OTP.NAME = :B2 AND OTP.SUBNAME = :B1 AND OTP.NAMESPACE = 1 AND OTP.REMOTEOWNER IS NULL AND OTP.LINKNAME IS NULL AND OTP.TYPE# = 19 AND OTP.OBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = OIP.OBJ# AND OIP.OWNER# = UI.USER# UNION ALL SELECT '"'||UI.NAME||'"' IND_OWNER, '"'||OIS.NAME||'"' IND_NAME, '"'||OIS.SUBNAME||'"' PART_NAME, OIS.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTS, SYS.TABSUBPART$ TSP, SYS.TABCOMPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDCOMPART$ IP, SYS.INDSUBPART$ ISP, SYS.OBJ$ OIS, SYS.USER$ UI WHERE UT.NAME = :B3 AND UT.USER# = OTS.OWNER# AND OTS.NAME = :B2 AND OTS.SUBNAME = :B1 AND OTS.NAMESPACE = 1 AND OTS.REMOTEOWNER IS NULL AND OTS.LINKNAME IS NULL AND OTS.TYPE# = 34 AND OTS.OBJ# = TSP.OBJ# AND TSP.POBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FL AGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = ISP.POBJ# AND ISP.SUBPART# = TSP.SUBPART# AND ISP.OBJ# = OIS.OBJ# AND OIS.OWNER# = UI.USER#
9juw6s4yy5pzp/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9ugwm6xmvw06uSELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1
a5mmhrrnpwjsc SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
a5pyncg7v0bw3/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
auqc5yhb7ady2SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS WHERE NAME='TIMESTAMP'
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b2u9kspucpqwySELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
b5y9gf2h9c6x0 /* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("OBJ#")), to_char(substrb(dump(min("OBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OBJ#"), 16, 0, 32), 1, 120)), to_char(count("PROGRAM_OID")), to_char(substrb(dump(min("PROGRAM_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROGRAM_OID"), 16, 0, 32), 1, 120)), to_char(count("PROGRAM_ACTION")), to_char(substrb(dump(min("PROGRAM_ACTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROGRAM_ACTION"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_EXPR")), to_char(substrb(dump(min("SCHEDULE_EXPR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SCHEDULE_EXPR"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_OWNER")), to_char(substrb(dump(min("QUEUE_OW NER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_OWNER"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_NAME")), to_char(substrb(dump(min("QUEUE_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_NAME"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_AGENT")), to_char(substrb(dump(min("QUEUE_AGENT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_AGENT"), 16, 0, 32), 1, 120)), to_char(count("EVENT_RULE")), to_char(substrb(dump(min("EVENT_RULE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EVENT_RULE"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_LIMIT")), to_char(substrb(dump(min("SCHEDULE_LIMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SCHEDULE_LIMIT"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_ID")), to_char(substrb(dump(min("SCHEDULE_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "SCHEDULE_ID"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_ENABLED_TIME")), to_char(substrb(dump(min("LAST_ENABLED_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_ENABLED_TIME"), 16, 0, 32), 1, 120)), to_char(count("CLASS_OID")), to_char(substrb(dump(min("CLASS_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLASS_OID"), 16, 0, 32), 1, 120)), to_char(count("PRIORITY")), to_char(substrb(dump(min("PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("JOB_WE IGHT")), to_char(substrb(dump(min("JOB_WEIGHT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_WEIGHT"), 16, 0, 32), 1, 120)), to_char(count("NUMBER_OF_ARGS")), to_char(substrb(dump(min("NUMBER_OF_ARGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NUMBER_OF_ARGS"), 16, 0, 32), 1, 120)), to_char(count("MAX_RUNS")), to_char(substrb(dump(min("MAX_RUNS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_RUNS"), 16, 0, 32), 1, 120)), to_char(count("MAX_FAILURES")), to_char(substrb(dump(min("MAX_FAILURES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_FAILURES"), 16, 0, 32), 1, 120)), to_char(count("MAX_RUN_DURATION")), to_char(substrb(dump(min("MAX_RUN_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_RUN_DURATION"), 16, 0, 32), 1, 120)), to_char(count("MXDUR_MSGID")), to_char(substrb(dump(min("MXDU R_MSGID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MXDUR_MSGID"), 16, 0, 32), 1, 120)), to_char(count("FLAGS")), to_char(substrb(dump(min("FLAGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FLAGS"), 16, 0, 32), 1, 120)), to_char(count("COMMENTS")), to_char(substrb(dump(min("COMMENTS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COMMENTS"), 16, 0, 32), 1, 120)), to_char(count("USER_CALLBACK")), to_char(substrb(dump(min("USER_CALLBACK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USER_CALLBACK"), 16, 0, 32), 1, 120)), to_char(count("USER_CALLBACK_CTX")), to_char(substrb(dump(min("USER_CALLBACK_CTX"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USER_CALLBACK_CTX"), 16, 0, 32), 1, 120)), to_char(count("CREATOR")), to_char(substrb(dump(min("CREATOR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREATOR "), 16, 0, 32), 1, 120)), to_char(count("CLIENT_ID")), to_char(substrb(dump(min("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(count("GUID")), to_char(substrb(dump(min("GUID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("GUID"), 16, 0, 32), 1, 120)), to_char(count("NLS_ENV")), to_char(substrb(dump(min("NLS_ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NLS_ENV"), 16, 0, 32), 1, 120)), to_char(count("ENV")), to_char(substrb(dump(min("ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ENV"), 16, 0, 32), 1, 120)), to_char(count("CHAR_ENV")), to_char(substrb(dump(min("CHAR_ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHAR_ENV"), 16, 0, 32), 1, 120)), to_char(count("SOURCE")), to_char(substrb(dump(min("SOURCE"), 16, 0, 32), 1, 120)), to _char(substrb(dump(max("SOURCE"), 16, 0, 32), 1, 120)), to_char(count("DEST_OID")), to_char(substrb(dump(min("DEST_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DEST_OID"), 16, 0, 32), 1, 120)), to_char(count("DESTINATION")), to_char(substrb(dump(min("DESTINATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DESTINATION"), 16, 0, 32), 1, 120)), to_char(count("DATABASE_ROLE")), to_char(substrb(dump(min("DATABASE_ROLE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATABASE_ROLE"), 16, 0, 32), 1, 120)), to_char(count("INSTANCE_ID")), to_char(substrb(dump(min("INSTANCE_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INSTANCE_ID"), 16, 0, 32), 1, 120)), to_char(count("CREDENTIAL_NAME")), to_char(substrb(dump(min("CREDENTIAL_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_NAME"), 16, 0, 32), 1, 120)), to_char(count("CREDENTIAL_OWNER")), to_char(substrb(dump(min("CREDENTIAL_OWNER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_OWNER"), 16, 0, 32), 1, 120)), to_char(count("CREDENTIAL_OID")), to_char(substrb(dump(min("CREDENTIAL_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_OID"), 16, 0, 32), 1, 120)), to_char(count("OWNER_UDN")), to_char(substrb(dump(min("OWNER_UDN"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OWNER_UDN"), 16, 0, 32), 1, 120)), to_char(count("FW_NAME")), to_char(substrb(dump(min("FW_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FW_NAME"), 16, 0, 32), 1, 120)), to_char(count("FW_OID")), to_char(substrb(dump(min("FW_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FW_OID"), 16, 0, 32), 1, 120)), to_char(count("JOB_STATUS")), to_char(substrb(dump(min ("JOB_STATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_STATUS"), 16, 0, 32), 1, 120)), to_char(count("NEXT_RUN_DATE")), to_char(substrb(dump(min("NEXT_RUN_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NEXT_RUN_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_START_DATE")), to_char(substrb(dump(min("LAST_START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_START_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_END_DATE")), to_char(substrb(dump(min("LAST_END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RETRY_COUNT")), to_char(substrb(dump(min("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(count("RUN_COUNT")), to_char(substrb(dump(min("RUN_COUNT"), 16, 0, 32), 1, 120)) , to_char(substrb(dump(max("RUN_COUNT"), 16, 0, 32), 1, 120)), to_char(count("FAILURE_COUNT")), to_char(substrb(dump(min("FAILURE_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FAILURE_COUNT"), 16, 0, 32), 1, 120)), to_char(count("RUNNING_INSTANCE")), to_char(substrb(dump(min("RUNNING_INSTANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUNNING_INSTANCE"), 16, 0, 32), 1, 120)), to_char(count("RUNNING_SLAVE")), to_char(substrb(dump(min("RUNNING_SLAVE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUNNING_SLAVE"), 16, 0, 32), 1, 120)), to_char(count("DIST_FLAGS")), to_char(substrb(dump(min("DIST_FLAGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DIST_FLAGS"), 16, 0, 32), 1, 120)), to_char(count("JOB_DEST_ID")), to_char(substrb(dump(min("JOB_DEST_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_DEST_I D"), 16, 0, 32), 1, 120)), to_char(count("RUN_INVOKER")), to_char(substrb(dump(min("RUN_INVOKER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUN_INVOKER"), 16, 0, 32), 1, 120)), to_char(count("SYS_NC00055$")), to_char(substrb(dump(min("SYS_NC00055$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SYS_NC00055$"), 16, 0, 32), 1, 120)), to_char(count("SYS_NC00056$")), to_char(substrb(dump(min("SYS_NC00056$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SYS_NC00056$"), 16, 0, 32), 1, 120)) from "SYS"."SCHEDULER$_JOB" t /* ACL, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
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
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cn39cg7kr98v6SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1
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
cvhk2j2gymzhdSELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1
cxjqbfn0d3yqqSELECT COUNT(*) FROM SYS.DBA_PROPAGATION
d0xmnp08rhfbginsert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2
d27r7zhtnfgp4SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();'
d89c1mh5pvbkz SELECT /*+ rule */ U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE :B4 IS NULL AND U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OT.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OT.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.TABPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TP.BO# = OT.OBJ# AND TP.OBJ# = OP.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, OS.SUBNAME, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR (OP.SUBNAME = :B4 AND (:B5 IS NOT NULL OR OS.SUBNAME IS NULL)) OR OS.SUBNAME = :B4 ) AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# ORDER BY 1, 2, 3, 4, 5, 22
dbvkky621gqtrSELECT /*+ parallel */ EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
dkk8923ygggj7UPDATE MGMT_EMD_PING SET LAST_HEARTBEAT_TS = :B6 , LAST_HEARTBEAT_UTC = CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE), CLEAN_HEARTBEAT_UTC = :B5 , STATUS_SYNC_UTC = :B4 , EMD_UPTIME_UTC = :B3 , HEARTBEAT_RECORDER_URL = SUBSTR(:B1 , 0, 256), UNRCH_START_TS = NULL WHERE TARGET_GUID = :B2
dwssdqx28tzf5select sysdate + 1 / (24 * 60) from dual
dy0yxpyu2wcbvSELECT /*+ all_rows */ C.NAME ICNAME, IC.POS# ICPOS, IC.SPARE1 ICFLAGS, C.PROPERTY ICPROP, C.DEFAULT$ ICEXPR, C.DEFLENGTH ICELEN FROM ICOL$ IC, COL$ C WHERE (:B2 IS NULL) AND IC.OBJ#=:B1 AND IC.BO#=C.OBJ# AND IC.INTCOL# = C.INTCOL# UNION ALL SELECT '"'||BO.NAME||'"."'||C.NAME||'"' ICNAME, IC.POS# ICPOS, IC.SPARE1 ICFLAGS, C.PROPERTY ICPROP, C.DEFAULT$ ICEXPR, C.DEFLENGTH ICELEN FROM ICOL$ IC, COL$ C, OBJ$ BO WHERE (:B2 IS NOT NULL) AND IC.OBJ#=:B1 AND IC.BO#=C.OBJ# AND IC.BO#=BO.OBJ# AND IC.SPARE2 = C.INTCOL# ORDER BY ICPOS
f4fcb8ngpf080SELECT HOST_URL, MODULE, NVL(SUM(VALUE), 0) HR_THROUGHPUT, NVL(SUM(DURATION/1000.0), 0) RUNTIME, NVL((SUM(VALUE)*1000.0), 0)/ DECODE(NVL(SUM(DURATION), 0), 0, 1, SUM(DURATION)) SEC_THROUGHPUT FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = :B3 AND MODULE LIKE :B2 ||'%' AND NAME = :B1 AND IS_TOTAL = 'Y' AND DURATION > 0 AND TIME > (SYSDATE - (1/24)) GROUP BY HOST_URL, MODULE
fjvwzpxbpch0h /* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
fsn35zyxmf1uySELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%'
g1xapjmt4vm5cSELECT SU.NAME, SO.NAME, A.STATSTYPE#, A.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU WHERE O.OWNER#=U.USER# AND A.OBJ#=O.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=A.INTCOL# AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND U.NAME=:B3 AND O.NAME=:B2 AND C.NAME=:B1
g5m0bnvyy37b1 select sql_id, plan_hash_value, bucket_id, begin_snap, end_snap from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io, row_number() over (partition by bucket_id order by cpu_plus_io desc) as within_bucket_rnk from (select dbid, sql_id, bucket_id, max(plan_hash_value) keep (dense_rank last order by cpu_plus_io) plan_hash_value, max(begin_snap) keep (dense_rank last order by cpu_plus_io) begin_snap, max(end_snap) keep (dense_rank last order by cpu_plus_io) end_snap, max(cpu_plus_io) cpu_plus_io from (select dbid, sql_id, plan_hash_value, begin_snap, end_snap, bucket_id, cpu_time + buffer_gets * 10000 as cpu_plus_io from (select dbid, begin_snap, end_snap, sql_id, plan_hash_value, case when bucket_id = 0 then cpu_time / executions else cpu_time end as cpu_time, case when bucket_id = 0 then buffer_gets / executions else buffer_gets e nd as buffer_gets, bucket_id from (select dbid, min(snap_id) begin_snap, max(snap_id) end_snap, sql_id, plan_hash_value, sum(cpu_time) cpu_time, sum(buffer_gets) buffer_gets, decode(sum(executions), 0, 1, sum(executions)) executions, decode(grouping_id(snap_id, hour_id, day_id), 3, 0, 5, 1, 6, 2, 3) bucket_id from (select f.dbid, f.snap_id, sql_id, plan_hash_value, to_number(to_char(begin_interval_time + 0, 'DDD')) day_id, (to_number(to_char(begin_interval_time + 0, 'DDD')) - 1)*24 + to_number(to_char(begin_interval_time + 0, 'HH24')) hour_id, cpu_time, buffer_gets, executions from (select v1.* from ( select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions from (select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions, row_number() over(partition by dbid, snap_id order by(cpu_time + buffer_gets * 10000) desc) as within_snap_rnk from (select /*+ cardinality(d 1) * / sq.dbid, sq.snap_id, min(sq.instance_number) min_inst_num, sq.sql_id, plan_hash_value, sum(cpu_time_delta) cpu_time, sum(buffer_gets_delta) buffer_gets, sum(executions_delta) executions from dba_hist_sqlstat sq, v$database d, dba_hist_sqltext st where sq.dbid = d.dbid and st.dbid = sq.dbid and st.sql_id = sq.sql_id and sq.snap_id between :bid and :eid and st.command_type in (2, 3, 6, 7, 189) and bitand(nvl(sq.flag, 0), 1) = 0 group by sq.dbid, sq.snap_id, sq.sql_id, plan_hash_value)) where within_snap_rnk <= 150 ) v1, (select sq.sql_id from dba_hist_sqlstat sq, v$database d where sq.dbid = d.dbid and sq.snap_id between :bid and :eid group by sq.dbid, sq.sql_id having sum(nvl(executions_delta, 0)) >= 2) v2 where v1.sql_id = v2.sql_id) f, dba_hist_snapshot s where f.snap_id = s.snap_id and f.dbid = s.dbid and s.instance_number = f.min_inst_num) group by grouping sets ((dbid, sql_id, plan_hash_value, snap_id), (dbid, sql_id, plan_hash_value, day_id), (db id, sql_id, plan_hash_value, hour_id), (dbid, sql_id, plan_hash_value))))) group by dbid, sql_id, bucket_id) where cpu_plus_io >= decode(bucket_id, 0, (10 * 1000000), 1, (60 * 1000000), 2, (240 * 1000000), (480 * 1000000)))where within_bucket_rnk <= 150) order by bucket_id asc, cpu_plus_io desc
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)
gz4vfuvmxa42jSELECT COUNT(*) FROM SYS.DBA_ADVISOR_TASKS WHERE OWNER = :B1 AND ROWNUM = 1

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 slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced850.010.03
CCursor + sql area evicted460.000.01
CPU used by this session79,336,057,679,1467,317,346,864.1023,896,402,915.41
CPU used when call started54,095,861,888,9284,989,385,620.2816,293,934,303.89
CR blocks created3,9010.361.18
Cached Commit SCN referenced1,7280.160.52
Commit SCN cached670.010.02
DB time3,398,100313.411,023.52
DBWR checkpoint buffers written36,6603.3811.04
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes2440.020.07
DBWR undo block writes5,2200.481.57
Effective IO time65,6956.0619.79
HSC Heap Segment Block Changes61,7465.6918.60
Heap Segment Array Inserts9500.090.29
Heap Segment Array Updates5670.050.17
IMU CR rollbacks1,6140.150.49
IMU Flushes3,5020.321.05
IMU Redo allocation size11,142,8001,027.733,356.27
IMU commits2,4880.230.75
IMU contention20.000.00
IMU ktichg flush10.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size21,387,9921,972.666,442.17
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping10.000.00
Number of read IOs issued220.000.01
Requests to/from client20,7461.916.25
RowCR - row contention00.000.00
RowCR attempts1370.010.04
RowCR hits1370.010.04
SMON posted for dropping temp segment00.000.00
SQL*Net roundtrips to/from client20,7461.916.25
active txn count during cleanout6010.060.18
application wait time380.000.01
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts67,3326.2120.28
branch node splits10.000.00
buffer is not pinned count1,637,796151.06493.31
buffer is pinned count506,37846.70152.52
bytes received via SQL*Net from client10,757,293992.173,240.15
bytes sent via SQL*Net to client3,058,223282.07921.15
calls to get snapshot scn: kcmgss239,75022.1172.21
calls to kcmgas42,0443.8812.66
calls to kcmgcs43,2283.9913.02
cell physical IO interconnect bytes1,023,399,42494,390.48308,252.84
change write time1,2180.110.37
cleanout - number of ktugct calls8470.080.26
cleanouts and rollbacks - consistent read gets380.000.01
cleanouts only - consistent read gets1970.020.06
cluster key scan block gets59,9715.5318.06
cluster key scans45,7454.2213.78
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed260.000.01
commit batch/immediate requested260.000.01
commit cleanout failures: block lost220.000.01
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure1190.010.04
commit cleanout failures: cannot pin10.000.00
commit cleanouts67,9246.2620.46
commit cleanouts successfully completed67,7826.2520.42
commit immediate performed260.000.01
commit immediate requested260.000.01
commit txn count during cleanout5830.050.18
concurrency wait time5,1260.471.54
consistent changes13,6241.264.10
consistent gets3,531,176325.691,063.61
consistent gets - examination1,991,598183.69599.88
consistent gets direct260.000.01
consistent gets from cache3,531,150325.691,063.60
consistent gets from cache (fastpath)957,17388.28288.31
cursor authentications5260.050.16
data blocks consistent reads - undo records applied7,3990.682.23
db block changes652,82460.21196.63
db block gets588,10354.24177.14
db block gets direct1,1910.110.36
db block gets from cache586,91254.13176.78
db block gets from cache (fastpath)145,39313.4143.79
deferred (CURRENT) block cleanout applications27,6402.558.33
enqueue conversions2,1830.200.66
enqueue releases140,20112.9342.23
enqueue requests140,20112.9342.23
enqueue timeouts00.000.00
enqueue waits10.000.00
execute count186,78617.2356.26
failed probes on index block reclamation50.000.00
file io service time00.000.00
file io wait time2,333,261,999215,202.11702,789.76
free buffer inspected00.000.00
free buffer requested57,2575.2817.25
heap block compress5240.050.16
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications2350.020.07
immediate (CURRENT) block cleanout applications35,3763.2610.66
in call idle wait time36,962,6063,409.1511,133.32
index crx upgrade (positioned)16,6081.535.00
index crx upgrade (prefetch)190.000.01
index fast full scans (full)8300.080.25
index fetch by key11,249,5391,037.573,388.42
index scans kdiixs1216,28519.9565.15
leaf node 90-10 splits1250.010.04
leaf node splits3410.030.10
lob reads2,6100.240.79
lob writes2,0490.190.62
lob writes unaligned2,0490.190.62
logical read bytes from cache33,735,163,9043,111,471.6710,161,193.95
logons cumulative7910.070.24
max cf enq hold time00.000.00
messages received12,6051.163.80
messages sent12,6051.163.80
min active SCN optimization applied on CR00.000.00
no work - consistent read gets1,440,239132.84433.81
non-idle wait count91,5198.4427.57
non-idle wait time10,2730.953.09
opened cursors cumulative172,19615.8851.87
parse count (describe)10.000.00
parse count (failures)1750.020.05
parse count (hard)1,1260.100.34
parse count (total)17,4511.615.26
parse time cpu32,895,968,731,1623,034,070,770.329,908,424,316.62
parse time elapsed6410.060.19
physical read IO requests620.010.02
physical read bytes9,953,280918.012,997.98
physical read total IO requests28,3902.628.55
physical read total bytes468,426,75243,204.08141,092.40
physical read total multi block requests170.000.01
physical reads1,2150.110.37
physical reads cache1,1890.110.36
physical reads cache prefetch1,1490.110.35
physical reads direct260.000.01
physical reads direct (lob)260.000.01
physical reads direct temporary tablespace00.000.00
physical write IO requests6,8870.642.07
physical write bytes310,075,39228,598.9793,396.20
physical write total IO requests21,3301.976.42
physical write total bytes554,972,67251,186.40167,160.44
physical write total multi block requests1,4880.140.45
physical writes37,8513.4911.40
physical writes direct1,1910.110.36
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace1,1910.110.36
physical writes from cache36,6603.3811.04
physical writes non checkpoint6,2520.581.88
pinned buffers inspected00.000.00
pinned cursors current00.000.00
process last non-idle time00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls528,81048.77159.28
recursive cpu usage97,595,914,394,7129,001,495,398.6429,396,359,757.44
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)38,0183.5111.45
redo blocks written200,81118.5260.49
redo buffer allocation retries00.000.00
redo entries311,57828.7493.85
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks1320.010.04
redo size97,504,0248,993.0229,368.68
redo size for direct writes00.000.00
redo subscn max counts18,4851.705.57
redo synch long waits00.000.00
redo synch time1410.010.04
redo synch time (usec)1,593,619146.98480.01
redo synch writes1,4320.130.43
redo wastage1,639,564151.22493.84
redo write time6970.060.21
redo writes5,7280.531.73
rollback changes - undo records applied3830.040.12
rollbacks only - consistent read gets3,8610.361.16
root node splits00.000.00
rows fetched via callback117,51410.8435.40
session connect time00.000.00
session cursor cache hits92,4048.5227.83
session logical reads4,119,279379.931,240.75
shared hash latch upgrades - no wait509,66147.01153.51
shared hash latch upgrades - wait10.000.00
sorts (memory)42,8773.9512.91
sorts (rows)4,765,135439.501,435.28
sql area evicted3580.030.11
sql area purged2110.020.06
switch current to new buffer45,4244.1913.68
table fetch by rowid329,26330.3799.18
table fetch continued row5950.050.18
table scan blocks gotten165,68315.2849.90
table scan rows gotten7,447,108686.862,243.10
table scans (long tables)00.000.00
table scans (short tables)29,5822.738.91
temp space allocated (bytes)3,145,728290.14947.51
total cf enq hold time1,7420.160.52
total number of cf enq holders1960.020.06
total number of times SMON posted50.000.00
transaction rollbacks260.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size39,629,5523,655.1211,936.61
user I/O wait time6700.060.20
user calls25,5012.357.68
user commits3,2960.300.99
user rollbacks240.000.01
workarea executions - onepass00.000.00
workarea executions - optimal19,8711.835.99
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current4447
session uga memory max202,903,756,728203,523,783,904
session pga memory185,069,151,544185,655,761,704
session pga memory max200,290,559,960200,960,990,664
session cursor cache count3,705,5573,716,825
session uga memory301,180,859,360,688302,087,138,438,496
opened cursors current155155

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)
Others437M2.61.040305138M0.80.01272832.7K131449.53
DBWR0M0.000M286M0.63.0263780 
LGWR0M0.000M98M0.53.00903857271499901.94
Buffer Cache Reads10M0.00.0009220M0.000M402.33
Direct Writes0M0.000M6M0.00.0005530 
Direct Reads0M0.000M0M0.000M0 
TOTAL:447M2.62.041227528M1.97.04869838.4K335186.92

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 File432M2.55.039844135M0.80.012451776919.87 
Data File0M0.070M286M0.63.0263788.22 
Log File0M0.000M98M0.53.009038  
Temp File10M0.00.0009229M0.01.0008300.265.12
TOTAL:442M2.62.040766528M1.97.048698756796.165.12

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 437M2.61.040305138M0.80.01272828.3K151589.26
Others (Control File) 432M2.55.039844135M0.80.01245127.6K155372.89
Others (Data File) 5M0.06.0004613M0.00.0002766908.37
DBWR 0M0.000M286M0.63.0263780 
DBWR (Data File) 0M0.000M286M0.63.0263780 
LGWR 0M0.000M98M0.53.0090380 
LGWR (Log File) 0M0.000M98M0.53.0090380 
Buffer Cache Reads 10M0.00.0009220M0.000M402.33
Buffer Cache Reads (Data File) 10M0.00.0009220M0.000M402.33
Direct Writes 0M0.000M6M0.00.0005530 
Direct Writes (Data File) 0M0.000M6M0.00.0005530 
Direct Reads 0M0.000M0M0.000M0 
Direct Reads (Data File) 0M0.000M0M0.000M0 
TOTAL: 447M2.62.041227528M1.97.04869828.4K151375.56

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 2200.001.185,384010.00
UNDOTBS1 000.000.00836000.00
SYSTEM 000.000.00597000.00
TEMP 4002.7529.7370000.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 2200.001.185,384010.00
SYSTEM+DATA/xjdss/system01.dbf 00  597000.00
TEMP+DATA/xjdss/temp01.dbf 4002.7529.737000 
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  300000.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  27000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  76000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  289000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  144000.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
D5,318,5341004,117,9121,18936,660001

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000036,6600

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
B0232861379128802548033212880   
E023529512547238812548033223881   

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
D4,2240.105211.002931196.00
D8,4480.201,0421.002931195.00
D12,6720.291,5621.002931195.00
D16,8960.392,0831.002931195.00
D21,1200.492,6041.002931195.00
D25,3440.593,1251.002931195.00
D29,5680.693,6461.002931195.00
D33,7920.784,1661.002931195.00
D38,0160.884,6871.002931195.00
D42,2400.985,2081.002931195.00
D43,1361.005,3191.002931195.00
D46,4641.085,7291.002931195.00
D50,6881.186,2501.002931195.00
D54,9121.276,7701.002931195.00
D59,1361.377,2911.002931195.00
D63,3601.477,8121.002931195.00
D67,5841.578,3331.002931195.00
D71,8081.668,8541.002931195.00
D76,0321.769,3751.002931195.00
D80,2561.869,8951.002931195.00
D84,4801.9610,4161.002931195.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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)
B14,33612,626381.130.000.000.000.001,048,576
E14,33612,623386.060.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
2K4K19,26019,26000
64K128K464600
128K256K484800
256K512K848400
512K1024K33733700
1M2M727200
2M4M141400
4M8M2200
8M16M3300

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,7920.13112,883.585.89100.00130,475,294
3,5840.25112,883.585.89100.00130,475,294
7,1680.50112,883.585.89100.00030,475,294
10,7520.75112,883.585.89100.00030,475,294
14,3361.00112,883.585.89100.00030,475,294
17,2031.20112,883.580.00100.00030,473,703
20,0701.40112,883.580.00100.00030,473,703
22,9381.60112,883.580.00100.00030,473,703
25,8051.80112,883.580.00100.00030,473,703
28,6722.00112,883.580.00100.00030,473,703
43,0083.00112,883.580.00100.00030,473,703
57,3444.00112,883.580.00100.00030,473,703
86,0166.00112,883.580.00100.00030,473,703
114,6888.00112,883.580.00100.00030,473,703

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)
3,8400.60596,3771,073,7040.91108,60332.1553,285
4,4800.7069824,3451,148,9950.9733,3129.8657,142
5,1200.801,33542,1041,162,2460.9920,0615.9457,899
5,2480.821,46345,5291,164,5040.9917,8035.2758,035
5,3760.841,59148,9541,166,8320.9915,4754.5858,167
5,5040.861,71952,3791,169,3500.9912,9573.8458,329
5,6320.881,84755,7991,171,6270.9910,6803.1658,480
5,7600.901,97557,9901,173,4731.008,8342.6258,595
5,8880.922,10360,1151,175,2411.007,0662.0958,711
6,0160.942,23163,6151,176,8521.005,4551.6158,814
6,1440.962,35967,4811,178,3501.003,9571.1758,907
6,2720.982,48673,6781,178,7931.003,5141.0458,962
6,4001.002,61478,1821,178,9291.003,3781.0058,979
6,5281.022,74282,6861,178,9341.003,3731.0058,980
6,6561.042,87087,1901,178,9361.003,3711.0058,980
6,7841.062,99891,6941,178,9431.003,3641.0058,980
6,9121.083,12696,1981,178,9431.003,3641.0058,980
7,0401.103,254100,7021,178,9431.003,3641.0058,980
7,1681.123,305102,5221,178,9431.003,3641.0058,980
7,2961.143,305102,5221,178,9431.003,3641.0058,980
7,4241.163,305102,5221,178,9431.003,3641.0058,980
7,5521.183,305102,5221,178,9431.003,3641.0058,980
7,6801.203,305102,5221,178,9431.003,3641.0058,980
8,3201.303,305102,5221,178,9431.003,3641.0058,980
8,9601.403,305102,5221,178,9431.003,3641.0058,980
9,6001.503,305102,5221,178,9431.003,3641.0058,980
10,2401.603,305102,5221,178,9431.003,3641.0058,980
10,8801.703,305102,5221,178,9431.003,3641.0058,980
11,5201.803,305102,5221,178,9431.003,3641.0058,980
12,1601.903,305102,5221,178,9431.003,3641.0058,980
12,8002.003,305102,5221,178,9431.003,3641.0058,980

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
12,8000.2512,844,304,280,488293,384
19,2000.3812,844,304,280,488292,769
25,6000.5012,844,304,280,488292,740
32,0000.6312,844,304,280,488292,740
38,4000.7512,844,304,280,488292,740
44,8000.8812,844,304,280,488292,740
51,2001.0012,844,304,280,488292,740
57,6001.1312,844,304,280,488292,740
64,0001.2512,844,304,280,488292,740
70,4001.3812,844,304,280,488292,740
76,8001.5012,844,304,280,488292,740
83,2001.6312,844,304,280,488292,740
89,6001.7512,844,304,280,488292,740
96,0001.8812,844,304,280,488292,740
102,4002.0012,844,304,280,488292,740

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
1281.000000
2562.000000
3843.000000
5124.000000
6405.000000
7686.000000
8967.000000
1,0248.000000
1,1529.000000
1,28010.000000
1,40811.000000
1,53612.000000
1,66413.000000
1,79214.000000
1,92015.000000
2,04816.000000
2,17617.000000
2,30418.000000
2,43219.000000
2,56020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TM-DML 30,54030,540010256.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
23-Nov 07:58111391,2181652,1260/00/0/0/0/0/0
23-Nov 07:481451906141651,3860/00/0/0/0/0/0
23-Nov 07:381441471,2131651,5060/00/0/0/0/0/0
23-Nov 07:28141716082652,1830/00/0/0/0/0/0
23-Nov 07:181431561,2071651,4970/00/0/0/0/0/0
23-Nov 07:085123476023649,5290/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 latch30.00 00 
AQ dequeue txn counter latch9,3860.00 00 
ASM Keyed state latch1,1570.00 00 
ASM allocation3680.00 00 
ASM db client latch7,2570.00 00 
ASM map operation freelist1280.00 00 
ASM map operation hash table99,7290.020.0000 
ASM network background latch4,5310.00 00 
ASM network state latch5640.00 00 
AWR Alerted Metric Element list115,9230.00 00 
Change Notification Hash table latch3,6410.00 00 
Consistent RBA5,7300.00 00 
DML lock allocation61,1900.00 00 
Event Group Locks1,3740.00 00 
FAL Queue2920.680.0000 
FOB s.o list latch14,4380.00 00 
File State Object Pool Parent Latch30.00 00 
I/O Staticstics latch30.00 00 
IPC stats buffer allocation latch30.00 00 
In memory undo latch65,5620.00 011,3870.00
JS Sh mem access230.00 00 
JS broadcast autostart latch40.00 00 
JS mem alloc latch580.00 00 
JS queue access latch610.00 00 
JS queue state obj latch78,4200.00 00 
JS slv state obj latch7630.00 00 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KFK SGA Libload latch20,9380.00 00 
KFMD SGA40.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list30.00 00 
KJCT flow control latch30.00 00 
KMG MMAN ready and startup request latch3,6120.00 00 
KTF sga latch580.00 03,1100.03
KWQMN job cache list latch10.00 00 
KWQP Prop Status40.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch2940.00 00 
Locator state objects pool parent latch30.00 00 
Lsod array latch7,7460.00 00 
MQL Tracking Latch0  02160.00
Memory Management Latch30.00 03,6120.00
Memory Queue30.00 00 
Memory Queue Message Subscriber #130.00 00 
Memory Queue Message Subscriber #230.00 00 
Memory Queue Message Subscriber #330.00 00 
Memory Queue Message Subscriber #430.00 00 
Memory Queue Subscriber30.00 00 
MinActiveScn Latch1200.00 00 
Mutex30.00 00 
Mutex Stats30.00 00 
OS process4,4540.00 00 
OS process allocation24,4530.00 00 
OS process: request allocation1,1570.00 00 
PL/SQL warning settings2,7540.00 00 
PX hash array latch30.00 00 
QMT30.00 00 
Real-time plan statistics latch99,9440.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA pool locks30.00 00 
SQL memory manager latch30.00 03,6000.03
SQL memory manager workarea list latch252,9060.00 00 
Shared B-Tree1,2440.00 00 
Streams Generic30.00 00 
Testing30.00 00 
Token Manager30.00 00 
WCR: sync30.00 00 
Write State Object Pool Parent Latch30.00 00 
X$KSFQP20.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
active checkpoint queue latch21,2610.110.0000 
active service list25,1380.00 09,6620.00
archive control5530.00 00 
archive process latch8762.050.8900 
buffer pool30.00 00 
business card30.00 00 
cache buffer handles7,9240.010.0000 
cache buffers chains7,557,2590.000.15029,1370.00
cache buffers lru chain130,5220.010.00099,9100.01
cache table scan latch190.00 0190.00
call allocation4,8280.00 00 
cas latch30.00 00 
change notification client cache latch30.00 00 
channel handle pool latch1,2160.00 00 
channel operations parent latch82,0300.00 00 
checkpoint queue latch2,536,3080.000.00041,6110.00
client/application info5,2690.00 00 
compile environment latch7910.00 00 
corrupted undo seg latch1,1750.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1720.00 00 
cvmap freelist lock30.00 00 
database property service latch80.00 00 
deferred cleanup latch1720.00 00 
dml lock allocation1720.00 00 
done queue latch30.00 00 
dummy allocation1,5820.00 00 
enqueue freelist latch30.00 0205,4760.00
enqueue hash chains282,6290.000.0000 
enqueues220.00 00 
fifth spare latch30.00 00 
file cache latch1,6550.00 00 
flashback copy30.00 00 
fourth Audit Vault latch30.00 00 
gc element30.00 00 
gcs commit scn state30.00 00 
gcs partitioned table hash30.00 00 
gcs pcm hashed value bucket hash30.00 00 
gcs resource freelist30.00 00 
gcs resource hash30.00 00 
gcs resource scan list30.00 00 
gcs shadows freelist30.00 00 
ges domain table30.00 00 
ges enqueue table freelist30.00 00 
ges group table30.00 00 
ges process hash list30.00 00 
ges process parent latch30.00 00 
ges resource hash list30.00 00 
ges resource scan list30.00 00 
ges resource table freelist30.00 00 
ges value block free list30.00 00 
global KZLD latch for mem in SGA1520.00 00 
global ctx hash table latch10.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch4630.00 084,4610.03
hash table modification latch2570.00 00 
heartbeat check30.00 00 
internal temp table object number allocation latch30.00 00 
intra txn parallel recovery30.00 00 
io pool granule metadata list30.00 00 
job workq parent latch2140.00 02110.47
job_queue_processes free list latch4460.00 00 
job_queue_processes parameter latch2,5530.00 00 
k2q lock allocation30.00 00 
kcfis latch430.00 00 
kdlx hb parent latch30.00 00 
kgb parent30.00 00 
kgnfs mount latch30.00 00 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
kokc descriptor allocation latch2,5860.00 00 
krbmrosl30.00 00 
ksfv messages30.00 00 
ksim group membership cache30.00 00 
kss move lock950.00 00 
ksuosstats global area1,0910.00 00 
ksv allocation latch3560.00 00 
ksv class latch1,9510.00 00 
ksv msg queue latch30.00 00 
ksz_so allocation latch1,1570.00 00 
ktm global data1510.00 00 
kwqbsn:qsga5710.00 00 
lgwr LWN SCN8,0990.020.0000 
list of block allocation5,1740.00 00 
loader state object freelist1180.00 00 
lob segment dispenser latch30.00 00 
lob segment hash table latch390.00 00 
lob segment query latch30.00 00 
lock DBA buffer during media recovery30.00 00 
logical standby cache30.00 00 
logminer context allocation50.00 00 
logminer work area30.00 00 
longop free list parent1830.00 01820.00
managed standby latch2920.680.0000 
mapped buffers lru chain30.00 00 
message pool operations parent latch3960.00 00 
messages168,1530.020.0000 
mostly latch-free SCN8,5393.780.0000 
msg queue latch30.00 00 
multiblock read objects1260.00 00 
name-service namespace bucket30.00 00 
ncodef allocation latch1720.00 00 
object queue header heap171,8590.00 01,7280.00
object queue header operation353,3090.020.0000 
object stats modification390.00 00 
parallel query alloc buffer2,8830.00 00 
parallel query stats30.00 00 
parameter list2140.00 00 
parameter table management5,7920.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
post/wait queue8,8100.320.0007,4530.13
process allocation1,5850.00 05800.00
process group creation1,1570.00 00 
process queue30.00 00 
process queue reference30.00 00 
qmn task queue latch1,5750.00 00 
query server freelists30.00 00 
queued dump request360.00 00 
queuing load statistics30.00 00 
recovery domain hash list30.00 00 
redo allocation38,9580.040.000311,5980.01
redo copy30.00 0311,6140.06
redo writing46,0810.050.0000 
resmgr group change latch47,3720.00 00 
resmgr:active threads3,1100.061.0003,6320.00
resmgr:actses change group4820.00 00 
resmgr:actses change state280.00 00 
resmgr:free threads list1,6210.00 00 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method3,0800.00 00 
resmgr:schema config48,2720.020.3801210.00
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects571,1770.040.0002090.00
rules engine rule set statistics2000.00 00 
second Audit Vault latch30.00 00 
second spare latch30.00 00 
sequence cache2,1610.00 00 
session allocation10,0840.00 08,5650.00
session idle bit58,7780.00 00 
session queue latch30.00 00 
session state list latch1,4220.00 00 
session switching7520.00 00 
session timer3,6120.00 00 
shared pool204,0750.010.070750.00
shared pool sim alloc250.00 00 
shared pool simulator3,9960.00 00 
sim partition latch30.00 00 
simulator hash latch177,7600.00 00 
simulator lru latch6,9730.00 0170,1070.00
sort extent pool5180.00 00 
space background state object latch280.00 00 
space background task latch12,9270.970.0007,2280.00
state object free list40.00 00 
statistics aggregation1,6800.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation60.00 00 
temporary table state object allocation80.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
third spare latch30.00 00 
threshold alerts latch7920.00 00 
transaction allocation14,8020.00 00 
undo global data37,8380.00 00 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains7,557,25927423
archive process latch87618162
shared pool204,07514113
resmgr:schema config48,272835
resmgr:active threads3,110220

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
archive process latchkcrrgpll01614
cache buffers chainskcbgtcr: fast path030
cache buffers chainskcbgtcr: fast path (cr pin)020
cache buffers chainskcbgcur_2010
resmgr:active threadskgsksysstop010
resmgr:active threadskskdynthreshact010
resmgr:schema configkgskgasi1021
resmgr:schema configkgskmetricupd010
shared poolkghalo011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 490
Library Cachekglpnal1 9030
Library Cachekglpndl1 9530
Library Cachekglget2 210
Library Cachekglhdgn2 10610
Library Cachekgllkc1 5710
Library Cachekgllkdl1 8510

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
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX760,67218.47
SYSMANSYSAUXMGMT_CURRENT_METRICS_IDX_01 INDEX53,2961.29
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX51,4241.25
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX17,5040.42
SYSSYSTEMI_SYSAUTH1 INDEX15,6160.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

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 INDEX5,11413.51
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX3,3708.90
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1850.49
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX330.09
SYSSYSAUXSMON_SCN_TIME TABLE200.05

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX5507.99
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX4306.24
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX370.54
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX280.41
SYSSYSAUXSMON_SCN_TIME TABLE200.29

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
SYSSYSTEMI_OBJ2 INDEX60.72
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX10.12

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 INDEX21,92040.01
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX21,71239.63
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX9,63217.58
SYSSYSTEMAUD$ TABLE8161.49
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX1920.35

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_control6390.000 41
dc_constraints12033.330 1201
dc_files1,3720.000 0343
dc_global_oids12,2150.000 091
dc_histogram_data10,76923.610 3,0128,360
dc_histogram_defs25,10112.920 2,2538,009
dc_object_grants4530.000 0105
dc_objects30,2640.520 1206,074
dc_profiles5270.000 02
dc_rollback_segments8,7900.000 067
dc_segments5,8890.050 12942
dc_sequences140.000 1411
dc_table_scns11100.000 00
dc_tablespaces20,1500.000 019
dc_users70,2880.020 0163
global database name7,6650.000 01
outstanding_alerts2700.000 015
qmtmrciq_cache_entries10.000 02
qmtmrctn_cache_entries10.000 05
qmtmrctq_cache_entries10.000 015
sch_lj_objs1816.670 0182
sch_lj_oids2615.380 0207


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS3040.000 00
APP CONTEXT10.0020.0000
BODY4,1980.0025,4600.0000
CLUSTER820.00820.0000
DBLINK3100.000 00
DIRECTORY10.0020.0000
EDITION3950.007540.0000
INDEX1,9760.251,76911.481090
OBJECT ID17100.000 00
QUEUE1850.0030,7640.0000
SCHEMA4450.000 00
SECURITY CLASS40.0040.0000
SQL AREA11,0201.31225,4411.12504290
SQL AREA BUILD1,02529.660 00
SQL AREA STATS1,04656.601,04656.6000
SUBSCRIPTION240.00240.0000
TABLE/PROCEDURE11,4550.3352,5631.222940
TEMPORARY INDEX1333.76133100.001280
TEMPORARY TABLE3630.55363100.003610
TRIGGER6140.001,2330.0000
XDB ACL10.0010.0000
XDB CONFIG10.0010.0000
XML SCHEMA50.0090.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 cache43,136.0043,136.0043,136.0043,392.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target14,336.0014,336.0014,336.0014,336.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target51,200.0051,200.0051,200.0051,200.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool896.00896.00896.00896.000STA/
large pool384.00384.00384.00384.000STA/
shared pool6,400.006,400.006,144.006,400.000GRO/DEF
streams pool128.00128.00128.00128.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
BOther319.25 6.9410.6944444646
Freeable38.940.001.562.079 2525
PL/SQL21.913.430.501.8512124444
SQL1.070.130.050.050202217
EOther323.14 6.5910.4444444949
Freeable39.880.001.532.039 2626
PL/SQL21.963.460.471.8012124747
SQL1.110.140.050.050202317

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers45,231,374,336 
Fixed Size2,234,120 
Redo Buffers26,513,408 
Variable Size8,187,283,704 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory896.00896.000.00
largePX msg pool7.817.810.00
largefree memory375.81375.810.00
sharedASH buffers64.0064.000.00
sharedASM extent pointer array85.3785.370.00
sharedFileOpenBlock121.60121.600.00
sharedKGLH0744.05743.44-0.08
sharedKGLHD80.2579.98-0.33
sharedSQLA2,212.552,217.600.23
shareddb_block_hash_buckets356.00356.000.00
shareddbktb: trace buffer78.1378.130.00
sharedevent statistics per sess94.2694.260.00
sharedfree memory1,791.641,789.47-0.12
sharedksunfy : SSO free list87.8787.870.00
sharedprivate strands107.80107.800.00
streamsfree memory126.74126.740.00
 buffer_cache43,136.0043,136.000.00
 fixed_sga2.132.130.00
 log_buffer25.2925.290.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator1011 11:48:530.000.000.00
QMON Slaves1011 11:49:030.000.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12733) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(69041) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 1861860.000.000.090.340.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(12733) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(69041) 0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 0.020.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
10,8420.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.0010,8420.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_trailDB  
compatible11.2.0.0.0  
control_files+DATA/xjdss/control01.ctl, +DATA/xjdss/control02.ctl  
db_block_size8192  
db_cache_size32212254720  
db_domain    
db_files2000  
db_namexjdss  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=xjdssXDB)  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=130.89.2.83)(PORT=1521))))  
log_archive_dest_1location=/arch1  
nls_languageSIMPLIFIED CHINESE  
nls_territoryCHINA  
open_cursors600  
pga_aggregate_target15032385536  
processes5000  
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan  SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN
sessions7552  
sga_max_size53687091200  
sga_target53687091200  
shared_pool_reserved_size322122547  
shared_pool_size6442450944  
spfile+DATA/xjdss/spfilexjdss.ora  
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_500_0800.html