Enter value for report_name: awrrpt_1_1100_1600.html Using the report name awrr t_1_1100_1600.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 822-827

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:82222-Nov-13 11:00:0344 3.5
End Snap:82722-Nov-13 16:00:3046 3.4
Elapsed:  300.45 (mins)  
DB Time:  88,098,302,428.13 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 293,220,786.0 1,147,113,312.9 2.8E+07 1.1E+08
DB CPU(s): 293,220,786.0 1,147,113,312.8 2.8E+07 1.1E+08
Redo size: 5,563.3 21,764.2  
Logical reads: 72.0 281.5  
Block changes: 37.4 146.3  
Physical reads: 0.0 0.0  
Physical writes: 3.0 11.6  
User calls: 2.7 10.6  
Parses: 1.0 3.9  
Hard parses: 0.0 0.1  
W/A MB processed: 0.0 0.1  
Logons: 0.1 0.3  
Executes: 10.6 41.5  
Rollbacks: 0.0 0.0  
Transactions: 0.3   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 99.80Soft Parse %: 98.48
Execute to Parse %: 90.73Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 6.44716276E+12% Non-Parse CPU: 92.33

Shared Pool Statistics

BeginEnd
Memory Usage %: 73.66 72.12
% SQL with executions>1: 98.62 99.43
% Memory for SQL w/exec>1: 88.51 97.24

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 5,285,898,145,588 100.00 
control file sequential read9,245510.00System I/O
log file sync2,110310.00Commit
ADR block file read180160.00Other
SQL*Net break/reset to client6,596100.00Application

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

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

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
9.2E+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.2 385.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 CPU5,285,898,145,588.46100.00
sql execute elapsed time99.620.00
PL/SQL execution elapsed time17.300.00
parse time elapsed12.590.00
hard parse elapsed time10.260.00
hard parse (sharing criteria) elapsed time10.190.00
connection management call elapsed time2.030.00
PL/SQL compilation elapsed time1.300.00
repeated bind elapsed time0.090.00
failed parse elapsed time0.020.00
sequence load elapsed time0.000.00
DB time5,285,898,145,687.82 
background elapsed time535.27 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME9,830 
AVG_IDLE_TIME1,791,122 
AVG_IOWAIT_TIME99 
AVG_SYS_TIME3,245 
AVG_USER_TIME5,887 
BUSY_TIME341,678 
IDLE_TIME57,343,939 
IOWAIT_TIME6,618 
SYS_TIME125,585 
USER_TIME216,093 
LOAD00
OS_CPU_WAIT_TIME332,400 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES4,698,112 
VM_OUT_BYTES67,555,328 
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
22-Nov 11:00:030.22     
22-Nov 12:00:180.330.690.430.2699.310.02
22-Nov 13:00:360.340.580.370.2199.420.01
22-Nov 16:00:300.220.560.360.2199.440.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  5,285,898,145,588 100.00
System I/O9,2450510.00
Commit2,1100310.00
Other2350140.00
Application6,5960100.00
User I/O4010000.00
Network43,7090000.00
Concurrency190000.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 read9,2450512.010.00
log file sync2,1100310.460.00
ADR block file read1800160.040.00
SQL*Net break/reset to client6,5960101.430.00
Disk file operations I/O3910000.080.00
SQL*Net message to client40,9560008.890.00
SQL*Net more data from client2,7530000.600.00
ADR block file write250010.010.00
direct path write temp50010.000.00
db file sequential read50000.000.00
SQL*Net message from client40,956090,12822018.89 
jobq slave wait38,94510019,4404998.45 
wait for unread message on broadcast channel18,3139818,0219843.97 
Streams AQ: waiting for messages in the queue3,76710018,01847830.82 
KSV master wait200000.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 startup6740801190.1514.92
control file sequential read22,48001614.883.03
db file sequential read1,71601590.372.85
db file parallel write9,31701212.022.20
control file parallel write7,1850811.561.52
log file parallel write6,1010711.321.23
ASM file metadata operation5,4250101.180.10
ADR block file read800030.020.05
Disk file operations I/O12,2280002.650.03
log file sync80040.000.01
Parameter File I/O160010.000.00
CSS initialization100150.000.00
ADR block file write250010.010.00
LGWR wait for redo copy1480000.030.00
db file async I/O submit9,3170002.020.00
CSS operation: action10030.000.00
asynch descriptor resize940100000.200.00
buffer busy waits40010.000.00
CSS operation: query60000.000.00
SQL*Net message to client7980000.170.00
rdbms ipc message121,24495360,062297026.31 
Streams AQ: waiting for time management or cleanup tasks25056,289281445980.00 
DIAG idle wait35,46110035,46210007.70 
Space Manager: slave idle wait5,1369825,43549521.11 
shared server idle wait60110018,030300000.13 
wait for unread message on broadcast channel18,02710018,02710003.91 
class slave wait1,049018,027171840.23 
ASM background timer3,611018,02649920.78 
smon timer787618,0212310360.02 
pmon timer6,00610018,01830001.30 
Streams AQ: qmn coordinator idle wait1,2875018,006139910.28 
Streams AQ: qmn slave idle wait643018,006280030.14 
dispatcher timer30010018,000600010.07 
SQL*Net message from client1,0640110.23 
KSV master wait3130000.07 

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 read26034.25.44.632.321.51.9  
ADR block file write50100.0       
ADR file lock60100.0       
ASM file metadata operation5426100.0 .0     
CSS initialization1    100.0   
CSS operation: action1  100.0     
CSS operation: query683.316.7      
Disk file operations I/O12.6K99.0.7.3.0    
LGWR wait for redo copy148100.0       
Parameter File I/O1693.8   6.3   
SQL*Net break/reset to client6596100.0       
SQL*Net message to client41.8K100.0       
SQL*Net more data from client2753100.0       
asynch descriptor resize940100.0       
buffer busy waits475.025.0      
control file parallel write718493.22.51.21.21.2.4.3 
control file sequential read31.7K97.2.6.4.8.7.1.1 
db file async I/O submit9317100.0       
db file parallel write931764.214.619.9.5.7.2.0 
db file sequential read1721.3 .750.045.63.0.5 
direct path write1100.0       
direct path write temp5100.0       
latch free2100.0       
latch: cache buffers chains4100.0       
latch: call allocation1100.0       
library cache: mutex X18100.0       
log file parallel write610289.52.23.42.61.8.3.2 
log file sync211885.54.05.31.92.3.6.5 
os thread startup674      100.0 
ASM background timer3612.1 .0 .0.0 99.8
DIAG idle wait35.5K      100.0 
KSV master wait33399.7 .3     
SQL*Net message from client42K78.513.81.0.1.1.0.36.2
Space Manager: slave idle wait5119.0 .0.0.0 .499.5
Streams AQ: qmn coordinator idle wait128950.0      50.0
Streams AQ: qmn slave idle wait644       100.0
Streams AQ: waiting for messages in the queue3768    1.2.52.895.5
Streams AQ: waiting for time management or cleanup tasks2      50.050.0
class slave wait104938.4.11.814.39.64.3.830.7
dispatcher timer300       100.0
jobq slave wait39K   .1 .099.9 
pmon timer6006       100.0
rdbms ipc message121.2K.5.3.2.51.21.133.263.0
shared server idle wait601       100.0
smon timer77  1.3 1.3 2.694.8
wait for unread message on broadcast channel36.3K  .0 .4.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
control file parallel write2299.7.2.1     
control file sequential read2599.9.1.0     
db file parallel write1100.0.0      
db file sequential read999.5.3.2     
log file parallel write1299.8.1.1     
log file sync1099.5.3.1     
os thread startup674  98.21.8    

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$USERS5,285,898,145,6505,285,898,145,5880614
xjdss3700608
SYS$BACKGROUND00076
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 40100000119290
xjdss 0019000317810
SYS$BACKGROUND 1396115681800000

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
39.155980.070.003846333648228.010.00aykvshm7zsabd   select size_for_estimate, size...
15.7253.140.00469272871609.1797.49350myuyx0t1d6   insert into wrh$_tablespace_st...
15.2853.060.00522979616774.740.00bunssq950snhf   insert into wrh$_sga_target_ad...
15.091,2110.010.0049734433257313.460.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
8.64300.290.001493233846325.930.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
7.457,0880.000.0069630114934817.790.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
6.4351.290.00668754396816.780.0066gs90fyynks7   insert into wrh$_instance_reco...
6.1451.230.001001419802867.590.004dy1xm4nxc0gf   insert into wrh$_system_event ...
5.8451.170.00631270861582.950.0084k66tf2s7y1c   insert into wrh$_bg_event_summ...
5.3054,3860.000.0079966069687407.240.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...

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
11,161,865,084,907.5260118,572,154,883.37211.165.14217089838487788.540.002b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
7,504,751,908,012.201,2116,197,152,690.35141.9815.0949734433257313.460.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
5,187,558,452,333.577,088731,879,014.1698.147.4569630114934817.790.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
4,241,014,899,764.1954,38677,979,901.0780.235.3079966069687407.240.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
3,337,497,110,018.055985,581,098,846.1863.145.2963107861308523.450.00772s25v1y0x8k   select shared_pool_size_for_es...
3,214,566,829,238.036,821471,275,007.9560.814.4971527470344097.440.006amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,505,870,163,170.435982,518,177,530.3928.4939.153846333648228.010.00aykvshm7zsabd   select size_for_estimate, size...
1,112,497,363,741.622993,720,726,969.0421.051.01109760830705639.540.0024g90qj2b7ywk OEM.CacheModeWaitPool BEGIN EMDW_LOG.set_context(MGM...
934,251,689,467.6117,09654,647,384.7417.671.5161863147738769.880.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
792,884,738,316.732772,862,399,777.3215.002.3034490434726030.080.143am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
682,249,976,010.5715,67443,527,496.2412.910.9076005870584537.760.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
626,932,051,868.761,678373,618,624.4711.860.9466569974204659.014.5418naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
528,590,645,805.61598883,930,845.8310.001.0351410621724106.010.008p447s6p0rv6b   select java_pool_size_for_esti...
430,247,587,936.803,585120,013,274.188.140.8153426729276993.670.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
417,954,773,495.192991,397,842,051.827.910.6069391969832012.185.227vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
411,808,439,263.70656,335,514,450.217.790.4983433136187662.300.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
381,076,674,298.54606,351,277,904.987.210.4291289188192415.880.009juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
381,076,665,017.13606,351,277,750.297.210.37103818630473800.940.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
368,783,866,148.87606,146,397,769.156.981.1332760083729204.780.00gwj1f651t001a emagent_SQL_oracle_database /* OracleOEM */ SELECT SEVERIT...
362,637,244,072.851,483244,529,497.016.860.5368087848726225.420.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
356,490,823,880.681202,970,756,865.676.740.6157979280433510.840.005fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
338,051,807,081.359,69234,879,468.336.400.4280028741322201.260.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
313,466,049,682.93605,224,434,161.385.934.237411913397791.130.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
313,466,037,426.561781,761,045,154.085.930.6349939784961089.420.00cydnuss99swtd OEM.SystemPool BEGIN EM_PING.RECORD_BATCH_HEA...
276,588,160,058.772,497110,768,185.855.230.5947048244385568.040.00fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
276,587,649,809.74596464,073,237.945.230.3480578598175608.500.000k8522rmdzg4k   select privilege# from sysauth...
264,295,089,996.92426,292,740,238.025.000.23113035018838204.010.29934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
252,002,167,527.08299842,816,613.804.770.24103146416522555.510.009q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
252,002,153,337.15524480,920,139.964.770.2793721513119840.200.00fsbqktj5vw6n9   select next_run_date, obj#, ru...
227,416,715,783.20376,146,397,723.874.300.11202912948163035.190.007d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
227,416,715,783.20376,146,397,723.874.300.15149454024107517.050.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
227,416,602,555.204,24253,610,703.104.300.22104192885966689.600.007qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
227,416,568,297.11308738,365,481.484.300.3761647881326203.580.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
215,123,865,297.975,31640,467,243.284.070.2779636277425553.700.005hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
178,245,422,580.98330540,137,644.183.370.2570052357899507.960.00cumjq42201t37   select u1.user#, u2.user#, u3....
172,099,299,591.552,68064,216,156.563.260.3253263377670621.510.002jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
172,098,994,334.58330521,512,104.043.260.2569838001807674.858.26aq8yqxyyb40nn   update sys.job$ set this_date=...
147,513,455,852.61304,917,115,195.092.791.718638996436525.640.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
147,513,430,691.73364,097,595,296.992.793.164662471899445.530.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
147,513,416,051.44330447,010,351.672.790.1977820083695901.844.5347a50dvdgnxc2   update sys.job$ set failures=0...
135,220,670,834.28363,756,129,745.402.560.13102449991919112.390.008u5gujrwh4wf4 emagent_SQL_oracle_database /* OracleOEM */ declare TYPE d...
135,220,658,967.10302447,750,526.382.560.2848211133561197.700.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
129,074,387,059.49304,302,479,568.652.448.641493233846325.930.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
110,635,076,641.83296373,767,150.822.090.1478016964114990.854.2539c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
98,342,307,269.25299328,904,037.691.860.08127559903066665.290.007mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
92,195,877,527.35315292,685,325.481.740.1095631932875574.050.6407c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
86,049,533,299.48300286,831,777.661.630.1178833869247275.080.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
79,903,131,079.60136,146,394,698.431.510.1459064999319636.030.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
79,903,090,352.58515,980,618,070.521.5115.28522979616774.740.00bunssq950snhf   insert into wrh$_sga_target_ad...
73,756,731,108.97126,146,394,259.081.400.3620677408904061.600.001qhza1uh1xcf9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE l_log_...
73,756,728,031.9989382,594,320.301.400.0894764014842207.150.0024dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
73,756,696,232.37266277,280,812.901.400.1454330740107082.650.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
73,756,691,865.69514,751,338,373.141.4015.72469272871609.1797.49350myuyx0t1d6   insert into wrh$_tablespace_st...
67,610,400,107.30601,126,840,001.791.280.05149610320876491.100.007wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
67,610,390,016.55130520,079,923.201.280.0976184154797450.710.009scf6jaun2d06 perl@xjdssa (TNS V1-V3) select username from dba_users...
67,610,389,173.90147459,934,620.231.280.1447509566628885.870.00grb1cf30q5r7m   SELECT /*+ ORDERED USE_NL(asso...
67,610,338,512.481,20556,108,164.741.280.1257390764990601.080.00bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
67,610,301,417.4987976,917,293.991.280.0972985698081168.830.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
61,463,950,920.49299205,565,053.251.160.03184073405769485.290.00btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
61,463,931,896.42266231,067,413.141.160.0970138684380617.300.00459f3z9u4fb3u   select value$ from props$ wher...
61,463,912,914.05512,292,782,582.811.166.141001419802867.590.004dy1xm4nxc0gf   insert into wrh$_system_event ...
55,317,590,649.2773757,775,214.371.050.0870389360524855.090.003t5szdknrrtyp   SELECT /* OPT_DYN_SAMP */ /*+ ...

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
15.3253.0698.1315.72469272871609.1797.49350myuyx0t1d6   insert into wrh$_tablespace_st...
0.041,6780.000.270.9466569974204659.014.5418naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
0.032990.000.200.6069391969832012.185.227vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
0.023300.000.130.2569838001807674.858.26aq8yqxyyb40nn   update sys.job$ set this_date=...
0.013300.000.060.1977820083695901.844.5347a50dvdgnxc2   update sys.job$ set failures=0...
0.012960.000.040.1478016964114990.854.2539c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
0.002770.000.022.3034490434726030.080.143am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
0.0050.000.020.496314121577135.510.60gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
0.0030.000.020.444234313056890.120.627ydcybv1szhrj   INSERT /*+ LEADING(@"SEL$F5BB7...
0.0010.000.010.793128973499536.330.25b2njyb8mzsskb perl@xjdssa (TNS V1-V3) SELECT file_name FROM dba_data...

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
280,82754,3865.1621.655.307996608vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
269,069308,968.9720.748.641493205k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
201,9366,82129.6115.574.497152706amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
98,329601,638.827.584.237411900njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
58,02617,0963.394.471.51618630cm5vu20fhtnq1   select /*+ connect_by_filterin...
56,381361,566.144.353.164662405uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
43,116277155.653.322.3034490.13am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
38,46460164.002.975.142170802b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
36,3357,0885.132.807.456963006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
27,72055,544.002.140.4963141.6gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
21,4402,6808.001.650.325326302jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
19,81059633.241.530.348057800k8522rmdzg4k   select privilege# from sysauth...
17,6102,4977.051.360.59470480fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
15,7601,6789.391.210.94665694.518naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
15,67215,6741.001.210.907600508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0300.000.001.718638996436525.640.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
040.000.000.000.000.0003f9zd7nkcz2z   select 1 from dual where upper...
0600.000.000.0414042799412173.960.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
03150.000.000.1095631932875574.050.6407c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
09,6920.000.000.4280028741322201.260.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
08790.000.000.0972985698081168.830.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
03020.000.000.2848211133561197.700.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
05960.000.000.3480578598175608.500.000k8522rmdzg4k   select privilege# from sysauth...
0600.000.004.237411913397791.130.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
02660.000.000.1454330740107082.650.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
1,4371,43711,437.000.0023950.00cn58bhkggqvj4 emagent_SQL_oracle_database /* OracleOEM */ SELECT dtp.tab...
1,4371,43711,437.000.0023950.00fwyn24jw5wjm4 emagent_SQL_oracle_database /* OracleOEM */ SELECT /*+firs...
1,4001,40011,400.000.0023333.33b2njyb8mzsskb perl@xjdssa (TNS V1-V3) SELECT file_name FROM dba_data...
1,4001,40011,400.000.0023333.33bryu1pu7rnk2s perl@xjdssa (TNS V1-V3) SELECT REPLACE(REPLACE(ddf.fi...
280280426.670.004666.67934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
240240604.000.004000.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
1321321211.000.002200.001qhza1uh1xcf9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE l_log_...
111111373.000.001850.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
1101102770.400.001833.333am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
00300.00 0.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
54,38654,3861.005.307996608vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
17,09624,2921.421.51618630cm5vu20fhtnq1   select /*+ connect_by_filterin...
15,67415,6741.000.907600508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
9,6929,6891.000.42800280089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
7,0887,0881.007.456963006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
6,82155,8048.184.497152706amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
5,31600.000.277963605hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
4,2424,2421.000.221041907qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
3,5853300.090.815342605ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,6802,6801.000.325326302jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
2,4972,4971.000.59470480fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
6001,6783.3818naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
5965963.360k8522rmdzg4k   select privilege# from sysauth...
59617,0963.36cm5vu20fhtnq1   select /*+ connect_by_filterin...
3308791.8608bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
3303301.8647a50dvdgnxc2   update sys.job$ set failures=0...
3303301.86aq8yqxyyb40nn   update sys.job$ set this_date=...
3303301.86cumjq42201t37   select u1.user#, u2.user#, u3....
3019,6921.70089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
3003021.6908vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
2998931.6924dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
2992991.6934rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
2992991.697vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
29915,6741.698t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
2991,2051.69bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
2992991.69btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
2995981.69c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
2992991.69dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
2962961.672mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
2962961.6739c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2662661.500ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
2662661.50459f3z9u4fb3u   select value$ from props$ wher...
2662661.505ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
29,760,321600.44a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
27,148,434370.407d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
27,027,7351200.405fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
25,420,073600.389juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
23,049,910600.347wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
21,405,634130.329dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
17,616,405600.266k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
16,174,217600.24b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
15,638,057600.23cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
13,741,202600.2005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
13,251,480650.20bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
11,890,6803080.184jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
7,993,29950.12gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
5,413,27740.081cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
4,939,6625240.07fsbqktj5vw6n9   select next_run_date, obj#, ru...
4,384,3171,6780.0718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
4,042,0602960.062mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
3,674,99430.058p9z2ztb272bm   SELECT sx.instance_number, sx...
3,605,7753300.05cumjq42201t37   select u1.user#, u2.user#, u3....
3,364,385600.059juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
3,327,2262990.057vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
3,179,96250.0566gs90fyynks7   insert into wrh$_instance_reco...
3,000,101200.0474fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
2,801,0972960.0439c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2,637,274130.049dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2,610,013300.04f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
2,579,8462930.04dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
2,459,9023,5850.045ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,455,03550.04gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2,315,539300.0300prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
2,283,6943300.0347a50dvdgnxc2   update sys.job$ set failures=0...
2,278,5933080.035r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
2,261,70930.0386521pa77y28j   SELECT (case when snap_id = :b...
2,250,7796010.03d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
2,229,808300.03fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
2,222,7582930.036r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
2,200,9142990.039q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
2,043,810600.030njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
1,915,6946,8210.036amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,895,924300.0385snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
1,895,264790.037av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
1,882,60530.034g46czps3t55u   SELECT sum(case when snap_id ...
1,874,474300.037hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
1,873,8392410.033tuvgpf2dxsf8 OEM.BoundedPool SELECT LAST_HEARTBEAT_TS FROM ...
1,873,7592410.039ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
1,853,47750.0384k66tf2s7y1c   insert into wrh$_bg_event_summ...
1,829,9285,3160.035hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
1,809,1464,2420.037qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,536,8622990.027mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
1,519,68250.02bunssq950snhf   insert into wrh$_sga_target_ad...
1,509,0623300.02aq8yqxyyb40nn   update sys.job$ set this_date=...
1,462,736360.025uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
1,317,19550.02gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
1,171,6512990.0234rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1,171,153300.02auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
991,67818naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
965gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
965gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
9238p9z2ztb272bm   SELECT sx.instance_number, sx...
9033047a50dvdgnxc2   update sys.job$ set failures=0...
893085r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
896,8216amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
892074fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
882962mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
8834g46czps3t55u   SELECT sum(case when snap_id ...
8834g46czps3t55u   SELECT sum(case when snap_id ...
883084jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
88797av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
882997mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
882997vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
883085snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
88386521pa77y28j   SELECT (case when snap_id = :b...
88609juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
88609juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
8860b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
88601d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
8830f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
8729934rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
872413tuvgpf2dxsf8 OEM.BoundedPool SELECT LAST_HEARTBEAT_TS FROM ...
875,3165hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
875,3165hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
872936r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
87307hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
87607wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
872419ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
87330aq8yqxyyb40nn   update sys.job$ set this_date=...
8730auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
87330cumjq42201t37   select u1.user#, u2.user#, u3....
8760cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
87293dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
8730fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
86377d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
862999q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
8660a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
86524fsbqktj5vw6n9   select next_run_date, obj#, ru...
841205fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
844,2427qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
84139dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
84139dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
8329639c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
833,5855ms6rbzdnq16t   select job, nvl2(last_date, 1,...
83606k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
826005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
8165bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
80600njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
783000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
665gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
665gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
665gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
665gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
5854,3868vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
5854,3868vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
57365uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
49566gs90fyynks7   insert into wrh$_instance_reco...
49584k66tf2s7y1c   insert into wrh$_bg_event_summ...
455bunssq950snhf   insert into wrh$_sga_target_ad...
4441cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00prz3j9n4gyjSELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')
03f9zd7nkcz2zselect 1 from dual where upper(:value) <> 'FALSE'
05xcf43d9psvmSELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
07c4n5uh9nk0rselect tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYSMAN"."MGMT_TASK_QTABLE" tab where tab.msgid = :1 and tab.state != 2 for update skip locked
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
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')
0xqn4sx1ytghrselect /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1))
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1qhza1uh1xcf9 /* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_flash_recovery_size NUMBER; l_usable_area NUMBER; l_space_used NUMBER; l_reclaimable_area NUMBER; l_nonreclaimable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area/Size SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; SELECT value INTO l_flash_recovery_size FROM v$parameter WHERE name='db_recovery_file_dest_size'; -- Usable Flash Recovery Area (10gR2) -- Reclaimable Flash Recovery Area (10gR2) -- Nonreclaimable Flash Recovery Area l_usable_area := NULL; l_recl aimable_area := NULL; l_nonreclaimable_area := NULL; l_space_used := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (CASE WHEN PERCENT_USED> 100 THEN 0 ELSE (100-PERCENT_USED) END) PERCENT_FREE FROM (SELECT (SUM(PERCENT_SPACE_USED)-SUM(PERCENT_SPACE_RECLAIMABLE)) PERCENT_USED FROM V$FLASH_RECOVERY_AREA_USAGE)' INTO l_usable_area; EXECUTE IMMEDIATE 'SELECT SUM(PERCENT_SPACE_USED), SUM(PERCENT_SPACE_RECLAIMABLE) from v$flash_recovery_area_usage' INTO l_space_used, l_reclaimable_area; l_nonreclaimable_area := l_space_used - l_reclaimable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_reclaimable_area, l_nonreclaimable_area, l_flashback_o n, l_oldest_flashback_time, l_flash_recovery_size from dual; :1 := data_cursor; END;
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;
2b064ybzkwf1yBEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
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
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)
3t5szdknrrtypSELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_0"), NVL(SUM(C2), :"SYS_B_1"), COUNT(DISTINCT C3), NVL(SUM(CASE WHEN C3 IS NULL THEN :"SYS_B_2" ELSE :"SYS_B_3" END), :"SYS_B_4") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("UIT") FULL("UIT") NO_PARALLEL_INDEX("UIT") */ :"SYS_B_5" AS C1, CASE WHEN "UIT"."ECM_SNAPSHOT_ID" IS NOT NULL THEN :"SYS_B_6" ELSE :"SYS_B_7" END AS C2, "UIT"."TARGET_NAME" AS C3 FROM "SYSMAN"."MGMT_STORAGE_REPORT_UI_TARGETS" "UIT") SAMPLESUB
3tuvgpf2dxsf8SELECT LAST_HEARTBEAT_TS FROM MGMT_EMD_PING P, MGMT_TARGETS T WHERE T.TARGET_GUID=P.TARGET_GUID AND T.TARGET_GUID=:B1
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
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
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5uy533jsc8hyhDELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
66gs90fyynks7 insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
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
6r95ktyt1vgmgSELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE
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;
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
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
7ydcybv1szhrj INSERT /*+ LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_ serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_wr ite_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
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
8b5vzx9k2t7s9 /* OracleOEM */ DECLARE TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; x clob := null; pos1 INTEGER := 1; pos2 INTEGER := 4000; statData clob := null; sizeData clob := null; objectsData clob := null; tmp VARCHAR2(4000); partitionName VARCHAR2(4000); jobName VARCHAR2(500); idx_name VARCHAR2(4000); part_name VARCHAR2(4000); tmp_str VARCHAR2(4000); guid RAW(16); idx_guid RAW(16); cursor idx_cur IS select owner, job_name, comments from dba_scheduler_jobs where job_name like 'EM_IDX_STAT_JOB%' and upper(owner) = 'DBSNMP'; idx_rec idx_cur%ROWTYPE; BEGIN OPEN idx_cur; FETCH idx_cur into idx_rec; guid := :1; IF idx_cur%FOUND THEN dbms_lob.createtemporary(statData, false); dbms_lob.createtemporary(sizeData, false); dbms_lob.createtemporary(objectsData, false); idx_name := substr(idx_rec.comments, 1, instr(idx_rec.comments, '|')-1); tmp_str := substr(idx_rec.comments, instr(idx_rec.comments, '|')+1); part_name := substr(tmp_str, 1, instr(tmp_str, '|')-1); idx_guid := substr(t mp_str, instr(tmp_str, '|')+1); if guid = idx_guid THEN if part_name != 'null' then partitionName := part_name; end if; ctx_report.index_stats(idx_name, x, partitionName, true, 5); pos1 := dbms_lob.instr(x, 'indexed documents:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'allocated docids:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, '$I rows:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, p os2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average $I rows per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average size per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency per token:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'token type:'); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend (statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'unique tokens:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average rows:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'averag e size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'average frequency:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'total size of $I data:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated row fragmentation:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'garbage docids:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(statData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'estimated garbage size:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); dbms_lob.writeappend(statData, pos2-pos1, tmp); END IF; /*dbms_lob.freetemporary(x); */ /* Gather Index Objects Data */ ctx_report.describe_index(idx_name, x); pos1 := 1; pos1 := dbms_lob.instr(x, 'datastore:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'filter:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'section gr oup:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'lexer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'wordlist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stemmer:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'fuzzy_match:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1 ); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'stoplist:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; pos1 := dbms_lob.instr(x, 'storage:', pos1); IF pos1 > 0 THEN pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(objectsData, pos2-pos1+1, tmp); END IF; /* Gather Size Data */ ctx_report.index_size(idx_name, x, partitionName); pos1 := 1; LOOP pos1 := dbms_lob.instr(x, 'INDEX (', pos1); EXIT WHEN pos1 < 1; pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := d bms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'TABLESPACE NAME:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BLOCKS USED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES ALLOCATED:', pos1); pos2 := dbms_lob.instr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); pos1 := dbms_lob.instr(x, 'BYTES USED:', pos1); pos2 := dbms_lob.i nstr(x, chr(10), pos1); tmp := dbms_lob.substr(x, pos2-pos1, pos1); tmp := tmp || '|'; dbms_lob.writeappend(sizeData, pos2-pos1+1, tmp); END LOOP; OPEN data_cursor FOR SELECT idx_name, partitionName, dbms_lob.substr(statData), dbms_lob.substr(sizeData), dbms_lob.substr(objectsData) FROM DUAL; :2 := data_cursor; jobName := idx_rec.owner || '.' || idx_rec.job_name; dbms_scheduler.drop_job(job_name => jobName, force => true); dbms_lob.freetemporary(sizeData); dbms_lob.freetemporary(statData); dbms_lob.freetemporary(objectsData); dbms_lob.freetemporary(x); end if; ELSE OPEN data_cursor FOR select 'dummy', 'dummy', 'dummy', 'dummy', 'dummy' from dual; :2 := data_cursor; END IF; END;
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 )
8u5gujrwh4wf4 /* OracleOEM */ declare TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; cap_count number; apply_count number; propagation_count number; cap_error_count number; apply_error_count number; prop_error_count number; total_prop_errors number; sqlstmt varchar2(32767); begin SELECT COUNT(*) into cap_count FROM SYS.DBA_CAPTURE; SELECT COUNT(*) into apply_count FROM SYS.DBA_APPLY; SELECT COUNT(*) into propagation_count FROM SYS.DBA_PROPAGATION; SELECT COUNT(*) into cap_error_count FROM SYS.DBA_CAPTURE WHERE ERROR_NUMBER IS NOT NULL; SELECT COUNT(*) into apply_error_count FROM SYS.DBA_APPLY WHERE ERROR_NUMBER IS NOT NULL; SELECT COUNT(*) into prop_error_count FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL; SELECT NVL(SUM(FAILURES), 0) into total_prop_errors FROM SYS.DBA_QUEUE_SCHEDULES; sqlstmt := 'select '||cap_count||' CAPTURE_COUNT, '||apply_count||' APPLY_COUNT, '||propagation_count||' PROP_COUNT, '||cap_error_count||' CAPTURE_ERROR_COUNT, '||apply_error_coun t||' APPLY_ERROR_COUNT, '||prop_error_count||' PROP_ERROR_COUNT, '||total_prop_errors||' TOTAL_PROP_ERRORS from dual'; OPEN data_cursor FOR sqlstmt; :1 := data_cursor; end;
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
934ur8r7tqbjxSELECT DBID FROM V$DATABASE
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
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 )
9q910gyqj6w95DELETE FROM MGMT_JOB_HISTORY WHERE STEP_ID = :B1
9scf6jaun2d06select username from dba_users where username = :p1
9ugwm6xmvw06uSELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1
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'
b2njyb8mzsskbSELECT file_name FROM dba_data_files
b2u9kspucpqwySELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
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
bryu1pu7rnk2s SELECT REPLACE(REPLACE(ddf.file_name, chr(10), ''), chr(13), '') "file_name", ddf.online_status "status", ddf.tablespace_name "tablespace_name", NVL(ddf.bytes, 0) "bytes", ddf.autoextensible "autoextensible", ddf.increment_by "increment_by", ddf.maxbytes "max_bytes" FROM sys.dba_data_files ddf
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
cn58bhkggqvj4 /* OracleOEM */ SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(ts.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(ts.bytes - NVL(f.bytes, 0), 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) ts, (SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f WHERE dtp.tablespace_name = ts.tablespace_name (+) AND dtp.tablespace_name = f.tablespace_ name (+) AND NOT (dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY') UNION ALL SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(a.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(t.bytes, 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.ta blespace_name = ts.name group by ss.tablespace_name) t WHERE dtp.tablespace_name = a.tablespace_name (+) AND dtp.tablespace_name = t.tablespace_name (+) AND dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY'
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
cxjqbfn0d3yqqSELECT COUNT(*) FROM SYS.DBA_PROPAGATION
cydnuss99swtdBEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
d27r7zhtnfgp4SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();'
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
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
fcg2mzztpyraqUPDATE MGMT_METRICS_RAW SET VALUE= :1 WHERE METRIC_GUID= HEXTORAW(:2) AND COLLECTION_TIMESTAMP= :3 AND KEY_VALUE= NVL(:4, ' ') AND TARGET_GUID= HEXTORAW(:5)
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
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ( (bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
fsn35zyxmf1uySELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%'
fwyn24jw5wjm4 /* OracleOEM */ SELECT /*+first_rows */ d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0) allocated_space, DECODE(d.contents, 'UNDO', NVL(u.bytes, 0)/1024/1024, NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024) used_space FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes, COUNT(file_id) count from dba_data_files GROUP BY tablespace_name) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name) f, (SELECT tablespace_name, SUM(bytes) bytes FROM (SELECT tablespace_name, sum (bytes) bytes, status from dba_undo_extents WHERE status ='ACTIVE' group by tablespace_name, status UNION ALL SELECT tablespace_name, sum(bytes) bytes, status from dba_undo_extents WHERE status ='UNEXPIRED' group by tablespace_name, status ) group by tablespace_name ) u WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND d.tablespace_name = u.tablespace_name(+) AND NOT (d.extent_management = 'LOCAL' AND d.contents = 'TEMPORARY') UNION ALL SELECT d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0) allocated_space, NVL(t.bytes, 0)/1024/1024 used_space FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes, count(file_id) count from dba_temp_files group by tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.tablespace_name = ts.name group by ss.tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY' ORDER BY 1
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)
grb1cf30q5r7m SELECT /*+ ORDERED USE_NL(assoc) USE_NL(cfg) NO_INDEX_FFS(assoc MGMT_POLICY_ASSOC_PK) INDEX_ASC(assoc MGMT_POLICY_ASSOC_PK) NO_INDEX_FFS(cfg MGMT_POLICY_ASSOC_CFG_PK_IDX) INDEX_ASC(cfg MGMT_POLICY_ASSOC_CFG_PK_IDX) CARDINALITY(targets 50)*/ ASSOC.OBJECT_GUID TARGET_GUID, LEAD(ASSOC.OBJECT_GUID, 1) OVER (ORDER BY ASSOC.OBJECT_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY ASSOC.OBJECT_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B5 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B10 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B5 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B10 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B5 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B10 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B5 , NVL(C FG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B10 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, :B4 , POLICY.VIOLATION_LEVEL , DECODE(POLICY.POLICY_TYPE, :B5 , :B11 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B5 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B10 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL(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, :B9 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW( BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B8 , 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 TABLE(CAST(:B1 AS MGMT_TARGET_GUID_ARRAY) ) TARGETS, MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG WHERE POLICY.METRIC_GUID = :B7 AND ASSOC.OBJECT_GUID = TARGETS.COLUMN_VALUE AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND POLICY.POLICY_TYPE != :B6 AND ( POLICY.POLICY_TYPE = :B5 OR ASSOC.COLL_NAME = :B4 ) AND ASSOC.OBJECT_TYPE = :B3 AND ASSOC.IS_ENABLED = :B2 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GU ID AND CFG.POLICY_GUID = ASSOC.POLICY_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME ORDER BY ASSOC.OBJECT_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
gwj1f651t001a/* OracleOEM */ SELECT SEVERITY_INDEX, CRITICAL_INICDENTS, WARNING_INCIDENTS from v$incmeter_summary
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 referenced120.000.00
CCursor + sql area evicted10.000.00
CPU used by this session122,889,227,972,0066,816,944,825.2826,668,669,264.76
CPU used when call started111,628,679,846,5156,192,296,623.4824,224,973,925.02
CR blocks created9660.050.21
Cached Commit SCN referenced00.000.00
Commit SCN cached70.000.00
DB time5,555,351308.171,205.59
DBWR checkpoint buffers written53,6362.9811.64
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes4070.020.09
DBWR undo block writes5,5900.311.21
Effective IO time00.000.00
HSC Heap Segment Block Changes14,0830.783.06
Heap Segment Array Inserts7860.040.17
Heap Segment Array Updates9460.050.21
IMU CR rollbacks1,1460.060.25
IMU Flushes5,8380.321.27
IMU Redo allocation size18,326,0681,016.593,977.01
IMU commits3,2450.180.70
IMU contention50.000.00
IMU ktichg flush10.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush20.000.00
IMU undo allocation size32,082,3361,779.686,962.31
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
Requests to/from client40,9492.278.89
RowCR - row contention00.000.00
RowCR attempts26,7531.485.81
RowCR hits26,7531.485.81
SMON posted for dropping temp segment00.000.00
SQL*Net roundtrips to/from client40,9492.278.89
active txn count during cleanout3660.020.08
application wait time530.000.01
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts111,8376.2024.27
branch node splits00.000.00
buffer is not pinned count480,46626.65104.27
buffer is pinned count282,41815.6761.29
bytes received via SQL*Net from client19,977,5761,108.204,335.41
bytes sent via SQL*Net to client5,999,969332.831,302.08
calls to get snapshot scn: kcmgss223,20812.3848.44
calls to kcmgas8,9250.501.94
calls to kcmgcs22,7811.264.94
cell physical IO interconnect bytes1,314,325,50472,908.62285,226.89
change write time3290.020.07
cleanout - number of ktugct calls4300.020.09
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets470.000.01
cluster key scan block gets25,1011.395.45
cluster key scans23,3061.295.06
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed430.000.01
commit batch/immediate requested430.000.01
commit cleanout failures: block lost20.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure230.000.00
commit cleanout failures: cannot pin20.000.00
commit cleanouts93,2575.1720.24
commit cleanouts successfully completed93,2305.1720.23
commit immediate performed430.000.01
commit immediate requested430.000.01
commit txn count during cleanout2200.010.05
concurrency wait time7,9880.441.73
consistent changes1,4180.080.31
consistent gets707,20339.23153.47
consistent gets - examination267,58314.8458.07
consistent gets direct10.000.00
consistent gets from cache707,20239.23153.47
consistent gets from cache (fastpath)292,15316.2163.40
cursor authentications1000.010.02
data blocks consistent reads - undo records applied1,3530.080.29
db block changes674,35637.41146.34
db block gets590,04932.73128.05
db block gets direct80.000.00
db block gets from cache590,04132.73128.05
db block gets from cache (fastpath)167,0159.2636.24
deferred (CURRENT) block cleanout applications35,9732.007.81
enqueue conversions3,6290.200.79
enqueue releases218,16912.1047.35
enqueue requests218,16912.1047.35
enqueue timeouts00.000.00
enqueue waits00.000.00
execute count191,37210.6241.53
failed probes on index block reclamation90.000.00
file io service time00.000.00
file io wait time28,565,697,6301,584,604.186,199,153.13
free buffer inspected00.000.00
free buffer requested31,3651.746.81
heap block compress2150.010.05
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications470.000.01
immediate (CURRENT) block cleanout applications49,9272.7710.83
in call idle wait time65,892,7353,655.2214,299.64
index crx upgrade (positioned)27,6321.536.00
index crx upgrade (prefetch)290.000.01
index fast full scans (full)870.000.02
index fetch by key176,3169.7838.26
index scans kdiixs1140,0427.7730.39
leaf node 90-10 splits1010.010.02
leaf node splits1960.010.04
lob reads00.000.00
lob writes80.000.00
lob writes unaligned80.000.00
logical read bytes from cache10,627,014,656589,504.662,306,209.78
logons cumulative1,2820.070.28
max cf enq hold time00.000.00
messages received15,4340.863.35
messages sent15,4340.863.35
min active SCN optimization applied on CR00.000.00
no work - consistent read gets320,18817.7669.49
non-idle wait count140,1887.7830.42
non-idle wait time14,9130.833.24
opened cursors cumulative169,3009.3936.74
parse count (describe)00.000.00
parse count (failures)400.000.01
parse count (hard)2700.010.06
parse count (total)17,7340.983.85
parse time cpu40,552,653,739,7872,249,547,886.548,800,489,092.84
parse time elapsed6290.030.14
physical read IO requests60.000.00
physical read bytes49,1522.7310.67
physical read total IO requests33,4521.867.26
physical read total bytes533,888,00029,615.98115,861.11
physical read total multi block requests00.000.00
physical reads60.000.00
physical reads cache50.000.00
physical reads cache prefetch00.000.00
physical reads direct10.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical write IO requests9,3250.522.02
physical write bytes439,451,64824,377.3895,367.11
physical write total IO requests29,8261.656.47
physical write total bytes780,437,50443,292.64169,365.78
physical write total multi block requests2,1740.120.47
physical writes53,6442.9811.64
physical writes direct80.000.00
physical writes direct (lob)30.000.00
physical writes direct temporary tablespace50.000.00
physical writes from cache53,6362.9811.64
physical writes non checkpoint5,3980.301.17
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 calls574,84131.89124.75
recursive cpu usage174,294,915,304,7559,668,535,156.1537,824,417,383.84
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)39,4772.198.57
redo blocks written206,52011.4644.82
redo buffer allocation retries00.000.00
redo entries318,67017.6869.16
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks3440.020.07
redo size100,289,6285,563.2921,764.24
redo size for direct writes24,6841.375.36
redo subscn max counts25,7791.435.59
redo synch long waits60.000.00
redo synch time2780.020.06
redo synch time (usec)3,051,398169.27662.20
redo synch writes2,4300.130.53
redo wastage1,741,76496.62377.99
redo write time7380.040.16
redo writes6,1020.341.32
rollback changes - undo records applied9620.050.21
rollbacks only - consistent read gets9660.050.21
root node splits00.000.00
rows fetched via callback47,4982.6310.31
session connect time00.000.00
session cursor cache hits89,2684.9519.37
session logical reads1,297,25271.96281.52
shared hash latch upgrades - no wait97,1815.3921.09
shared hash latch upgrades - wait100.000.00
sorts (memory)55,7543.0912.10
sorts (rows)197,71010.9742.91
sql area evicted2180.010.05
sql area purged400.000.01
switch current to new buffer24,6771.375.36
table fetch by rowid179,2029.9438.89
table fetch continued row320.000.01
table scan blocks gotten86,7954.8118.84
table scan rows gotten4,308,969239.03935.11
table scans (long tables)00.000.00
table scans (short tables)13,4460.752.92
temp space allocated (bytes)00.000.00
total cf enq hold time2,6930.150.58
total number of cf enq holders3210.020.07
total number of times SMON posted190.000.00
transaction rollbacks430.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size42,279,6842,345.359,175.28
user I/O wait time1,5620.090.34
user calls48,9062.7110.61
user commits4,5640.250.99
user rollbacks440.000.01
workarea executions - onepass00.000.00
workarea executions - optimal21,5691.204.68
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 current4446
session uga memory max199,287,473,584200,277,922,616
session pga memory181,828,728,736182,735,880,032
session pga memory max196,760,271,424197,693,571,584
session cursor cache count3,640,0053,658,130
session uga memory295,893,518,774,584297,362,463,809,296
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)
Others509M1.86.028235224M0.80.01242540.6K317042.58
DBWR0M0.000M418M0.52.0231870 
LGWR0M0.000M101M0.34.0056026102703862.88
Buffer Cache Reads0M0.000M0M0.000M50.00
Direct Writes0M0.000M0M0.000M0 
TOTAL:509M1.86.028235743M1.65.04121546.7K367500.19

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Control File496M1.76.027514224M0.80.0124252572242.25 
Data File4M0.10.000221419M0.52.0232428.46 
Log File0M0.000M101M0.34.005602  
Other0M0.000M0M0.000M1.67 
Temp File0M0.000M0M0.000M0.00 
TOTAL:500M1.86.027736744M1.65.0412712439447.57 

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 509M1.86.028235224M0.80.01242533.4K256868.99
Others (Control File) 496M1.76.027514224M0.80.01242531.7K270762.53
Others (Data File) 13M0.10.0007210M0.000M17168.46
DBWR 0M0.000M418M0.52.0231870 
DBWR (Data File) 0M0.000M418M0.52.0231870 
LGWR 0M0.000M101M0.34.0056020 
LGWR (Log File) 0M0.000M101M0.34.0056020 
Buffer Cache Reads 0M0.000M0M0.000M50.00
Buffer Cache Reads (Data File) 0M0.000M0M0.000M50.00
Direct Writes 0M0.000M0M0.000M0 
Direct Writes (Data File) 0M0.000M0M0.000M0 
TOTAL: 509M1.86.028235743M1.65.04121533.4K256830.59

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 100.001.007,904000.00
UNDOTBS1 000.000.001,120020.00
SYSTEM 000.000.00295025.00
TEMP 500.001.005000.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 100.001.007,904000.00
SYSTEM+DATA/xjdss/system01.dbf 00  295025.00
TEMP+DATA/xjdss/temp01.dbf 500.001.00500 
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  453020.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  385000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  140000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  98000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  44000.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,5341001,297,247553,636004

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000053,6360

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
B0232581346129932548033212993   
E026527812137236472548033223647   

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.002911196.00
D8,4480.201,0421.002901195.00
D12,6720.291,5621.002901195.00
D16,8960.392,0831.002901195.00
D21,1200.492,6041.002901195.00
D25,3440.593,1251.002901195.00
D29,5680.693,6461.002901195.00
D33,7920.784,1661.002901195.00
D38,0160.884,6871.002901195.00
D42,2400.985,2081.002901195.00
D43,1361.005,3191.002901195.00
D46,4641.085,7291.002901195.00
D50,6881.186,2501.002901195.00
D54,9121.276,7701.002901195.00
D59,1361.377,2911.002901195.00
D63,3601.477,8121.002901195.00
D67,5841.578,3331.002901195.00
D71,8081.668,8541.002901195.00
D76,0321.769,3751.002901195.00
D80,2561.869,8951.002901195.00
D84,4801.9610,4161.002901195.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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.190.000.000.000.001,048,576
E14,33612,624385.100.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
2K4K20,93820,93800
64K128K828200
256K512K101000
512K1024K38338300
1M2M14114100
4M8M101000
8M16M5500

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.13110,891.355.89100.00130,126,466
3,5840.25110,891.355.89100.00130,126,466
7,1680.50110,891.355.89100.00030,126,466
10,7520.75110,891.355.89100.00030,126,466
14,3361.00110,891.355.89100.00030,126,466
17,2031.20110,891.350.00100.00030,124,865
20,0701.40110,891.350.00100.00030,124,865
22,9381.60110,891.350.00100.00030,124,865
25,8051.80110,891.350.00100.00030,124,865
28,6722.00110,891.350.00100.00030,124,865
43,0083.00110,891.350.00100.00030,124,865
57,3444.00110,891.350.00100.00030,124,865
86,0166.00110,891.350.00100.00030,124,865
114,6888.00110,891.350.00100.00030,124,865

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.60556,5351,055,7610.91105,93731.6852,362
4,4800.7069520,9811,130,4000.9831,2989.3656,147
5,1200.801,33538,0991,143,1120.9918,5865.5656,837
5,2480.821,46341,7001,145,2720.9916,4264.9156,959
5,3760.841,59144,9961,147,4800.9914,2184.2557,076
5,5040.861,71948,2381,149,8610.9911,8373.5457,224
5,6320.881,84752,0331,151,8920.999,8062.9357,357
5,7600.901,97555,8281,153,5551.008,1432.4457,454
5,8880.922,10359,6231,155,1521.006,5461.9657,552
6,0160.942,23163,3771,156,5811.005,1171.5357,629
6,1440.962,35968,0691,157,9591.003,7391.1257,704
6,2720.982,48673,8381,158,3141.003,3841.0157,747
6,4001.002,61478,3141,158,3541.003,3441.0057,752
6,5281.022,74282,7901,158,3581.003,3401.0057,752
6,6561.042,87087,2661,158,3601.003,3381.0057,752
6,7841.062,99891,7421,158,3671.003,3311.0057,752
6,9121.083,12696,2181,158,3671.003,3311.0057,752
7,0401.103,250100,5831,158,3671.003,3311.0057,752
7,1681.123,250100,5831,158,3671.003,3311.0057,752
7,2961.143,250100,5831,158,3671.003,3311.0057,752
7,4241.163,250100,5831,158,3671.003,3311.0057,752
7,5521.183,250100,5831,158,3671.003,3311.0057,752
7,6801.203,250100,5831,158,3671.003,3311.0057,752
8,3201.303,250100,5831,158,3671.003,3311.0057,752
8,9601.403,250100,5831,158,3671.003,3311.0057,752
9,6001.503,250100,5831,158,3671.003,3311.0057,752
10,2401.603,250100,5831,158,3671.003,3311.0057,752
10,8801.703,250100,5831,158,3671.003,3311.0057,752
11,5201.803,250100,5831,158,3671.003,3311.0057,752
12,1601.903,250100,5831,158,3671.003,3311.0057,752
12,8002.003,250100,5831,158,3671.003,3311.0057,752

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.2514,443,889,027,527290,935
19,2000.3814,443,889,027,527290,354
25,6000.5014,443,889,027,527290,325
32,0000.6314,443,889,027,527290,325
38,4000.7514,443,889,027,527290,325
44,8000.8814,443,889,027,527290,325
51,2001.0014,443,889,027,527290,325
57,6001.1314,443,889,027,527290,325
64,0001.2514,443,889,027,527290,325
70,4001.3814,443,889,027,527290,325
76,8001.5014,443,889,027,527290,325
83,2001.6314,443,889,027,527290,325
89,6001.7514,443,889,027,527290,325
96,0001.8814,443,889,027,527290,325
102,4002.0014,443,889,027,527290,325

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 block205
undo header200

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
22-Nov 15:58151583483676,7120/00/0/0/0/0/0
22-Nov 15:481431449471675,9470/00/0/0/0/0/0
22-Nov 15:381481743423675,9150/00/0/0/0/0/0
22-Nov 15:28101289421676,7400/00/0/0/0/0/0
22-Nov 15:181462253381675,9140/00/0/0/0/0/0
22-Nov 15:085222799363673,7600/00/0/0/0/0/0
22-Nov 12:58101483001676,6950/00/0/0/0/0/0
22-Nov 12:481421438991676,0310/00/0/0/0/0/0
22-Nov 12:381482152953675,9660/00/0/0/0/0/0
22-Nov 12:28121238941676,7550/00/0/0/0/0/0
22-Nov 12:182743042893675,2390/00/0/0/0/0/0
22-Nov 12:085584138873673,6720/00/0/0/0/0/0
22-Nov 11:581162832823676,2600/00/0/0/0/0/0
22-Nov 11:481441698822676,0910/00/0/0/0/0/0
22-Nov 11:381441722771676,0970/00/0/0/0/0/0
22-Nov 11:28111308741676,8420/00/0/0/0/0/0
22-Nov 11:181492662702676,0310/00/0/0/0/0/0
22-Nov 11:085422698693673,7640/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 latch50.00 00 
AQ dequeue txn counter latch15,5940.00 00 
ASM Keyed state latch1,8780.00 00 
ASM allocation6080.00 00 
ASM db client latch12,1840.00 00 
ASM map headers120.00 00 
ASM map load waiting list20.00 00 
ASM map operation freelist2120.00 00 
ASM map operation hash table130,9590.000.0000 
ASM network background latch7,5450.00 00 
ASM network state latch9320.00 00 
AWR Alerted Metric Element list193,0760.00 00 
Change Notification Hash table latch5,9850.00 00 
Consistent RBA6,1010.00 00 
DML lock allocation84,8740.00 00 
Event Group Locks2,2270.00 00 
FAL Queue4800.210.0000 
FIB s.o chain latch40.00 00 
FOB s.o list latch25,2330.00 00 
File State Object Pool Parent Latch50.00 00 
I/O Staticstics latch50.00 00 
IPC stats buffer allocation latch50.00 00 
In memory undo latch99,0610.00 013,4470.00
JS Sh mem access370.00 00 
JS mem alloc latch340.00 00 
JS queue access latch390.00 00 
JS queue state obj latch130,2680.00 00 
JS slv state obj latch1,2030.00 00 
KFC FX Hash Latch50.00 00 
KFC Hash Latch50.00 00 
KFCL LE Freelist50.00 00 
KFK SGA Libload latch34,8580.00 00 
KFMD SGA10.00 00 
KGNFS-NFS:SHM structure50.00 00 
KGNFS-NFS:SVR LIST50.00 00 
KJC message pool free list50.00 00 
KJCT flow control latch50.00 00 
KMG MMAN ready and startup request latch5,9990.00 00 
KMG resize request state object freelist20.00 00 
KTF sga latch970.00 05,0300.00
KWQMN job cache list latch110.00 00 
KWQP Prop Status100.00 00 
KWQS pqsubs latch200.00 00 
KWQS pqueue ctx latch5310.00 00 
Locator state objects pool parent latch50.00 00 
Lsod array latch12,6690.030.0000 
MQL Tracking Latch0  03570.00
Memory Management Latch280.00 05,9990.00
Memory Queue50.00 00 
Memory Queue Message Subscriber #150.00 00 
Memory Queue Message Subscriber #250.00 00 
Memory Queue Message Subscriber #350.00 00 
Memory Queue Message Subscriber #450.00 00 
Memory Queue Subscriber50.00 00 
MinActiveScn Latch2000.00 00 
Mutex50.00 00 
Mutex Stats50.00 00 
OS process7,1290.00 00 
OS process allocation40,4240.000.0000 
OS process: request allocation1,8780.00 00 
PL/SQL warning settings4,2490.00 00 
PX hash array latch50.00 00 
QMT50.00 00 
Real-time plan statistics latch165,9070.00 00 
SGA blob parent50.00 00 
SGA bucket locks50.00 00 
SGA heap locks50.00 00 
SGA pool locks50.00 00 
SQL memory manager latch50.00 05,9810.00
SQL memory manager workarea list latch416,3930.00 00 
Shared B-Tree2,1350.00 00 
Streams Generic50.00 00 
Testing50.00 00 
Token Manager50.00 00 
WCR: sync50.00 00 
Write State Object Pool Parent Latch50.00 00 
X$KSFQP50.00 00 
XDB NFS Security Latch50.00 00 
XDB unused session pool50.00 00 
XDB used session pool50.00 00 
active checkpoint queue latch33,3130.030.0000 
active service list41,6670.00 022,6420.00
archive control9200.00 00 
archive process latch1,4400.420.3300 
begin backup scn array30.00 00 
buffer pool70.00 00 
business card50.00 00 
cache buffer handles1,2340.00 00 
cache buffers chains3,790,6400.000.08042,8230.00
cache buffers lru chain118,8800.000.00086,4050.00
call allocation6,5490.050.3300 
cas latch50.00 00 
change notification client cache latch50.00 00 
channel handle pool latch1,9570.00 00 
channel operations parent latch137,0100.00 00 
checkpoint queue latch4,111,9370.000.00058,5160.00
client/application info8,6830.00 00 
compile environment latch1,2820.00 00 
corrupted undo seg latch2,9290.00 00 
cp cmon/server latch50.00 00 
cp pool latch50.00 00 
cp server hash latch50.00 00 
cp sga latch2860.00 00 
cvmap freelist lock50.00 00 
deferred cleanup latch2860.00 00 
dml lock allocation2860.00 00 
done queue latch50.00 00 
dummy allocation2,5670.00 00 
enqueue freelist latch50.00 0337,5160.00
enqueue hash chains439,9560.00 00 
enqueues70.00 00 
fifth spare latch50.00 00 
file cache latch3,3420.00 00 
flashback copy50.00 00 
fourth Audit Vault latch50.00 00 
gc element50.00 00 
gcs commit scn state50.00 00 
gcs partitioned table hash50.00 00 
gcs pcm hashed value bucket hash50.00 00 
gcs resource freelist50.00 00 
gcs resource hash50.00 00 
gcs resource scan list50.00 00 
gcs shadows freelist50.00 00 
ges domain table50.00 00 
ges enqueue table freelist50.00 00 
ges group table50.00 00 
ges process hash list50.00 00 
ges process parent latch50.00 00 
ges resource hash list50.00 00 
ges resource scan list50.00 00 
ges resource table freelist50.00 00 
ges value block free list50.00 00 
global KZLD latch for mem in SGA2660.00 00 
global ctx hash table latch60.00 00 
global tx hash mapping50.00 00 
granule operation50.00 00 
hash table column usage latch2670.00 0243,4670.00
hash table modification latch4260.00 00 
heartbeat check50.00 00 
intra txn parallel recovery50.00 00 
io pool granule metadata list50.00 00 
job workq parent latch3470.00 03423.51
job_queue_processes free list latch7080.00 00 
job_queue_processes parameter latch4,2410.00 00 
k2q lock allocation50.00 00 
kdlx hb parent latch50.00 00 
kgb parent50.00 00 
kgnfs mount latch50.00 00 
kokc descriptor allocation latch4,5320.00 00 
krbmrosl50.00 00 
ksfv messages50.00 00 
ksim group membership cache50.00 00 
kss move lock1650.00 00 
ksuosstats global area1,8170.00 00 
ksv allocation latch6060.00 00 
ksv class latch3,2570.030.0000 
ksv msg queue latch110.00 060.00
ksz_so allocation latch1,8780.050.0000 
ktm global data2830.00 00 
kwqbsn:qsga9540.00 00 
lgwr LWN SCN9,9510.020.0000 
list of block allocation8,0620.00 00 
loader state object freelist180.00 00 
lob segment dispenser latch50.00 00 
lob segment hash table latch650.00 00 
lob segment query latch50.00 00 
lock DBA buffer during media recovery50.00 00 
logical standby cache50.00 00 
logminer context allocation100.00 00 
logminer work area50.00 00 
longop free list parent50.00 00 
managed standby latch4800.420.0000 
mapped buffers lru chain50.00 00 
message pool operations parent latch6350.00 00 
messages269,0250.010.0000 
mostly latch-free SCN10,3732.960.0000 
msg queue latch50.00 00 
multiblock read objects1320.00 00 
name-service namespace bucket50.00 00 
ncodef allocation latch2860.00 00 
object queue header heap266,5570.00 0260.00
object queue header operation465,4890.010.0000 
object stats modification70.00 00 
parallel query alloc buffer4,7890.00 00 
parallel query stats50.00 00 
parameter list3220.00 00 
parameter table management9,7070.010.0000 
peshm50.00 00 
pesom_free_list50.00 00 
pesom_hash_node50.00 00 
post/wait queue15,2080.260.00012,9740.13
process allocation2,5520.040.0009400.00
process group creation1,8780.00 00 
process queue50.00 00 
process queue reference50.00 00 
qmn task queue latch2,6210.00 00 
query server freelists50.00 00 
queued dump request600.00 00 
queuing load statistics50.00 00 
recovery domain hash list50.00 00 
redo allocation52,4670.030.000318,6950.01
redo copy50.00 0318,7020.09
redo writing64,2530.010.0000 
resmgr group change latch9400.00 00 
resmgr:active threads2,5670.00 00 
resmgr:actses change group6930.00 00 
resmgr:actses change state50.00 00 
resmgr:free threads list2,5620.00 00 
resmgr:plan CPU method50.00 00 
resmgr:resource group CPU method50.00 00 
resmgr:schema config2450.00 00 
resmgr:session queuing50.00 00 
rm cas latch50.00 00 
row cache objects801,3510.000.0002280.00
rules engine rule set statistics5000.00 00 
second Audit Vault latch50.00 00 
second spare latch50.00 00 
segmented array pool40.00 00 
sequence cache1,9240.00 00 
session allocation19,3270.00 016,8560.00
session idle bit113,3870.00 00 
session queue latch50.00 00 
session state list latch2,2320.00 00 
session switching1,2290.00 00 
session timer6,0050.00 00 
shared pool204,7930.000.000750.00
shared pool sim alloc120.00 00 
shared pool simulator1,4140.00 00 
sim partition latch50.00 00 
simulator hash latch70,7780.00 00 
simulator lru latch7,6180.010.00061,0140.00
sort extent pool5200.00 00 
space background state object latch520.00 00 
space background task latch22,4230.740.00012,0150.00
state object free list100.00 00 
statistics aggregation2,8000.00 00 
tablespace key chain50.00 00 
temp lob duration state obj allocation60.00 00 
temporary table state object allocation20.00 00 
test excl. parent l050.00 00 
test excl. parent2 l050.00 00 
third spare latch50.00 00 
threshold alerts latch1,3190.00 00 
transaction allocation24,2480.00 00 
undo global data37,3790.00 00 
virtual circuit buffers50.00 00 
virtual circuit holder50.00 00 
virtual circuit queues50.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains3,790,64052448
archive process latch1,440624
call allocation6,549312

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
archive process latchkcrrgpll022
cache buffers chainskcbgtcr: fast path060
cache buffers chainskcbgcur_2022
cache buffers chainskcbgtcr: fast path (cr pin)021
call allocationksuxds011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 4120
Library Cachekglpnal1 9050
Library Cachekglpndl1 9510

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_METRICS_RAW_PK INDEX214,83216.56
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX164,88012.71
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX87,1366.72
SYSSYSTEMI_SYSAUTH1 INDEX47,2483.64
SYSSYSTEMAUD$ TABLE19,5041.50

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSMANTEMPMGMT_STORAGE_UI_TARGET_IDX1 INDEX116.67

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
SYSMANTEMPMGMT_STORAGE_UI_TARGET_IDX1 INDEX116.67

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
SYSMANTEMPMGMT_STORAGE_UI_TARGET_IDX1 INDEX116.67

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 INDEX15,40428.72
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX10,30819.22
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX5571.04
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX1120.21
SYSSYSAUXSMON_SCN_TIME TABLE730.14

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX1,64317.62
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX1,23813.28
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1161.24
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX910.98
SYSSYSAUXSMON_SCN_TIME TABLE600.64

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB337.50
SYSMANTEMPMGMT_STORAGE_UI_TARGET_IDX1 INDEX112.50

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_SYSAUTH1 INDEX3135.63
SYSSYSTEMI_OBJ2 INDEX78.05
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX55.75
SYSMANSYSAUXMGMT_TARGETS_IDX_01 INDEX44.60

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 INDEX95,31245.51
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX58,76828.06
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX47,61622.74
SYSSYSTEMAUD$ TABLE2,6881.28
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX8960.43

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_control3220.000 81
dc_files3,4300.000 0343
dc_global_oids20,8750.000 091
dc_histogram_data11,4470.000 015,719
dc_histogram_defs33,1430.000 08,833
dc_object_grants7320.000 0105
dc_objects41,6570.000 276,917
dc_profiles8860.000 02
dc_rollback_segments14,7170.000 067
dc_segments2,8920.350 38933
dc_sequences50.000 511
dc_tablespaces31,0040.000 019
dc_users106,3320.000 0214
global database name12,8500.000 01
outstanding_alerts4500.000 015
sch_lj_oids290.000 0235


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS5320.000 00
APP CONTEXT30.002,2050.0000
BODY5,4100.0037,6520.0000
CLUSTER200.00200.0000
DBLINK5420.000 00
EDITION6620.001,2680.0000
QUEUE3140.0051,3670.0000
SCHEMA7480.000 00
SQL AREA10,5380.09227,6580.244840
SQL AREA BUILD27015.930 00
SQL AREA STATS27080.0027080.0000
SUBSCRIPTION370.00370.0000
TABLE/PROCEDURE13,2470.0071,1950.02130
TRIGGER3350.001,4070.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,264.0043,136.0043,136.0043,392.001SHR/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,272.006,400.006,144.006,400.001GRO/DEF
streams pool128.00128.00128.00128.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache43,136.0043,136.0043,136.00101
shared pool6,400.006,400.006,400.00110

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
11/22 11:52:280bufcacheSHR/DEF43,264-128 43,136COM
11/22 11:52:280sharedGRO/DEF6,272128 6,400COM

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
BOther320.72 6.9710.6844444646
Freeable37.690.001.572.129 2424
PL/SQL21.743.380.491.8412124444
SQL1.070.130.050.050202217
EOther323.60 6.7410.5144444848
Freeable38.560.001.542.089 2525
PL/SQL21.893.470.481.8012124646
SQL1.090.130.050.050202417

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers45,365,592,06445,231,374,336
Fixed Size2,234,120 
Redo Buffers26,513,408 
Variable Size8,053,065,9768,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
sharedKGLH0754.49750.98-0.46
sharedKGLHD82.5682.11-0.55
sharedSQLA2,202.012,205.340.15
shareddb_block_hash_buckets356.00356.000.00
shareddbktb: trace buffer78.1378.130.00
sharedevent statistics per sess94.2694.260.00
sharedfree memory1,651.921,784.238.01
sharedksunfy : SSO free list87.8787.870.00
sharedprivate strands107.80107.800.00
streamsfree memory126.74126.740.00
 buffer_cache43,264.0043,136.00-0.30
 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) 3153150.000.000.140.560.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 %
18,0270.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.0018,0270.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  
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 awrr t_1_1100_1600.html