Enter value for report_name: awrrpt_1120_2300_0100.html Using the report name awrrpt_1120_2300_0100.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 786-788

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:78620-Nov-13 23:00:5645 3.4
End Snap:78821-Nov-13 01:00:2045 3.4
Elapsed:  119.40 (mins)  
DB Time:  34,727,883,692.88 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 290,854,149.9 1,134,280,360.1 2.8E+07 1.2E+08
DB CPU(s): 290,854,149.8 1,134,280,360.1 2.8E+07 1.2E+08
Redo size: 4,588.7 17,895.1  
Logical reads: 61.4 239.3  
Block changes: 30.7 119.8  
Physical reads: 0.0 0.0  
Physical writes: 3.0 11.7  
User calls: 2.4 9.2  
Parses: 1.1 4.1  
Hard parses: 0.1 0.2  
W/A MB processed: 0.0 0.1  
Logons: 0.1 0.3  
Executes: 10.3 40.1  
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.39Soft Parse %: 95.13
Execute to Parse %: 89.74Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 4.37320120E+12% Non-Parse CPU: 93.37

Shared Pool Statistics

BeginEnd
Memory Usage %: 74.00 73.99
% SQL with executions>1: 97.41 98.72
% Memory for SQL w/exec>1: 85.64 94.98

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 2,083,673,021,540 100.00 
control file sequential read3,539210.00System I/O
log file sync832120.00Commit
ADR block file read72040.00Other
SQL*Net message to client13,854000.00Network

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

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

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
9.1E+08 1.6E+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.7 381.8
% 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 CPU2,083,673,021,540.15100.00
sql execute elapsed time35.210.00
PL/SQL execution elapsed time6.790.00
parse time elapsed3.940.00
hard parse elapsed time2.810.00
hard parse (sharing criteria) elapsed time2.790.00
connection management call elapsed time0.790.00
PL/SQL compilation elapsed time0.050.00
repeated bind elapsed time0.020.00
failed parse elapsed time0.010.00
sequence load elapsed time0.000.00
DB time2,083,673,021,573.00 
background elapsed time212.70 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME3,682 
AVG_IDLE_TIME712,042 
AVG_IOWAIT_TIME29 
AVG_SYS_TIME1,130 
AVG_USER_TIME2,238 
BUSY_TIME129,203 
IDLE_TIME22,796,579 
IOWAIT_TIME2,384 
SYS_TIME46,581 
USER_TIME82,622 
LOAD00
OS_CPU_WAIT_TIME136,000 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES3,780,608 
VM_OUT_BYTES66,510,848 
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
20-Nov 23:00:560.47     
21-Nov 01:00:200.120.560.360.2099.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  2,083,673,021,540 100.00
System I/O3,5390210.00
Commit8320120.00
Other980030.00
Network14,9450000.00
Application5100000.00
User I/O1490000.00
Concurrency40000.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 read3,5390211.930.00
log file sync8320120.450.00
ADR block file read720040.040.00
SQL*Net message to client13,8540007.540.00
SQL*Net break/reset to client5100000.280.00
Disk file operations I/O1450000.080.00
SQL*Net more data from client1,0910000.590.00
latch free40030.000.00
ADR block file write100010.010.00
direct path write temp20010.000.00
SQL*Net message from client13,854035,90925927.54 
jobq slave wait15,0221007,5004998.18 
Streams AQ: waiting for messages in the queue1,4371007,16549860.78 
wait for unread message on broadcast channel7,274987,1619853.96 

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 startup2690321190.1515.00
control file sequential read8,4190614.582.96
control file parallel write2,8510521.552.22
db file parallel write3,7170512.022.15
log file parallel write2,6990311.471.41
db file sequential read3430380.191.32
ASM file metadata operation2,1470001.170.10
resmgr:internal state change110001000.000.05
ADR block file read320020.020.04
Disk file operations I/O4,4990002.450.02
log file sync30020.000.00
ADR block file write100010.010.00
db file async I/O submit3,7170002.020.00
LGWR wait for redo copy510000.030.00
latch free20010.000.00
asynch descriptor resize370100000.200.00
rdbms ipc message47,05795143,214304325.62 
DIAG idle wait14,09110014,09110007.67 
Space Manager: slave idle wait1,936989,58949531.05 
dispatcher timer1201007,200600010.07 
shared server idle wait2391007,170300000.13 
Streams AQ: qmn coordinator idle wait512507,168140000.28 
Streams AQ: qmn slave idle wait25607,168280000.14 
class slave wait40907,164175160.22 
wait for unread message on broadcast channel7,1631007,16310003.90 
ASM background timer1,43207,16250010.78 
pmon timer2,3871007,16130001.30 
smon timer31747,1592309360.02 
SQL*Net message from client4040110.22 
KSV master wait1180000.06 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read10452.93.83.824.015.4   
ADR block file write2095.05.0      
ADR file lock24100.0       
ASM file metadata operation2147100.0       
Disk file operations I/O464499.1.7.2.0    
LGWR wait for redo copy51100.0       
SQL*Net break/reset to client510100.0       
SQL*Net message to client14.2K100.0       
SQL*Net more data from client1091100.0       
asynch descriptor resize368100.0       
control file parallel write285293.02.4.71.01.3.51.1 
control file sequential read12K97.3.5.4.9.7.1.1 
db file async I/O submit3719100.0       
db file parallel write371963.415.719.8.6.5.0.0 
db file sequential read345.6 .947.047.83.8  
direct path write temp2100.0       
latch free650.016.716.7 16.7   
library cache: mutex X4100.0       
log file parallel write269791.22.42.62.0.9.5.4 
log file sync83586.74.35.01.11.11.0.8 
os thread startup267      100.0 
resmgr:internal state change1      100.0 
ASM background timer1432       100.0
DIAG idle wait14.1K      100.0 
KSV master wait126100.0       
SQL*Net message from client14.3K75.415.71.1.1.0.0.37.4
Space Manager: slave idle wait1934 .1.1.2  .299.5
Streams AQ: qmn coordinator idle wait51250.0      50.0
Streams AQ: qmn slave idle wait256       100.0
Streams AQ: waiting for messages in the queue1436    .2  99.8
class slave wait40938.4 2.013.09.84.22.430.3
dispatcher timer119       100.0
jobq slave wait15K   .0.0.099.9 
pmon timer2387       100.0
rdbms ipc message47K1.0.5.2.5.6.332.264.7
shared server idle wait239       100.0
smon timer29  3.4   3.493.1
wait for unread message on broadcast channel14.4K    .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 write3198.9.7.4.0    
control file sequential read1099.9.0.0.0    
db file parallel write1100.0.0      
log file parallel write1099.6.2.1     
log file sync799.2.6.2     
os thread startup267  98.91.1    
resmgr:internal state change1  100.0     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS2,083,673,021,5582,083,673,021,5400179
xjdss1500221
SYS$BACKGROUND00039
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 1490000045320
xjdss 004000104030
SYS$BACKGROUND 48423270320000

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
15.632380.070.009475618411825.650.00aykvshm7zsabd   select size_for_estimate, size...
5.964650.010.0048552854068314.580.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
4.1243,1460.000.0071708189460955.910.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
3.741100.030.008865914458852.300.053am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
3.42130.260.001439186717913.930.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
3.332,8640.000.0085886890823370.410.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
3.2013.200.00384210009772.5097.42350myuyx0t1d6   insert into wrh$_tablespace_st...
3.0613.060.00601815916984.680.00bunssq950snhf   insert into wrh$_sga_target_ad...
2.9521.470.00625972675430.840.05gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2.6121.310.00470351406303.950.0066gs90fyynks7   insert into wrh$_instance_reco...

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
3,680,761,090,981.0623915,400,674,020.84176.652.10175509604111275.700.002b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
2,956,482,758,233.9643,14668,522,754.33141.894.1271708189460955.910.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
2,895,016,846,434.194656,225,842,680.50138.945.9648552854068314.580.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
2,864,283,147,776.182,8641,000,098,864.45137.463.3385886890823370.410.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
1,481,315,656,313.612386,224,015,362.6671.0915.639475618411825.650.00aykvshm7zsabd   select size_for_estimate, size...
1,321,505,669,719.472385,552,544,830.7563.422.0963195254552619.690.00772s25v1y0x8k   select shared_pool_size_for_es...
1,112,522,705,899.701,612690,150,561.9753.391.3880866221716458.760.006amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
417,963,890,388.761193,512,301,599.9120.060.4299176124106331.100.0024g90qj2b7ywk OEM.CacheModeWaitPool BEGIN EMDW_LOG.set_context(MGM...
381,084,744,073.616,73156,616,363.7018.290.6360371486293271.630.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
331,912,530,322.901103,017,386,639.3015.933.748865914458852.300.053am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
313,473,048,262.966,33549,482,722.6915.040.3882935301797473.080.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
307,326,431,210.401,604191,600,019.4614.750.3391800067868976.080.003c1kubcdjnppq   update sys.col_usage$ set equa...
301,180,352,953.612381,265,463,667.8714.450.4172964775714034.960.008p447s6p0rv6b   select java_pool_size_for_esti...
270,447,239,285.00650416,072,675.8212.980.3772125418511713.563.8918naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
264,300,803,022.622,148123,045,066.5812.680.20131566902299611.950.005hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
202,835,481,031.591,427142,141,192.039.730.3460373093142718.760.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
172,102,914,067.35247,170,954,752.818.260.4340191710528215.960.009juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
165,956,271,956.56483,457,422,332.437.960.7223028213102698.760.005fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
153,663,315,611.33246,402,638,150.477.370.11145599988261415.120.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
153,663,249,735.83256,146,529,989.437.370.13114781138924991.760.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
153,663,202,149.301181,302,230,526.697.370.2659531460884354.513.317vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
147,516,782,447.86246,146,532,601.997.080.3245689502350142.630.00gwj1f651t001a emagent_SQL_oracle_database /* OracleOEM */ SELECT SEVERIT...
147,516,695,626.05582253,465,112.767.080.2265889200586928.830.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
141,370,189,049.422,14865,814,799.376.780.12122667131508338.990.007qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
129,077,130,076.713,84833,543,952.726.190.1775550415909199.460.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
116,784,041,634.62231505,558,621.795.600.1580514620526186.880.000k8522rmdzg4k   select privilege# from sysauth...
104,490,979,036.15119878,075,454.095.010.1198969472183057.650.009q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
98,344,525,585.21166,146,532,849.084.720.1662177258095957.670.00934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
98,344,516,591.65156,556,301,106.114.720.04239019362235146.260.007d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
92,197,986,551.52156,146,532,436.774.420.06160344324437430.880.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
86,051,444,238.26243,585,476,843.264.130.2043839604374337.240.008u5gujrwh4wf4 emagent_SQL_oracle_database /* OracleOEM */ declare TYPE d...
79,904,882,743.53250319,619,530.973.830.1360206061485942.650.00fsbqktj5vw6n9   select next_run_date, obj#, ru...
79,904,869,474.86130614,652,842.113.830.0896392869865319.814.5247a50dvdgnxc2   update sys.job$ set failures=0...
79,904,868,158.87130614,652,831.993.830.1266907430675791.740.00cumjq42201t37   select u1.user#, u2.user#, u3....
67,611,855,497.8588,451,481,937.233.240.6410497040151566.810.00a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
67,611,812,299.98132512,210,699.243.240.1159700325203948.450.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
55,318,752,903.77105,531,875,290.382.650.757368239521635.700.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
49,172,275,226.82133,782,482,709.762.363.421439186717913.930.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
49,172,262,792.5386,146,532,849.072.360.637856236496271.540.00fcsu9qb17sk52 emagent_SQL_oracle_database /* OracleOEM */ DECLARE instan...
49,172,233,027.05479102,656,018.852.360.05100384274512179.380.00bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
43,025,692,845.61122352,669,613.492.060.1922901599411093.220.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
43,025,691,840.90119361,560,435.642.060.04118954083054745.100.007mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
36,879,181,317.1257,375,836,263.421.770.596301289899449.660.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
36,879,165,467.82116317,923,840.241.770.0755172816103130.010.8939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
36,879,159,982.55346106,587,167.581.770.0495312226972700.680.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
30,732,660,412.61241,280,527,517.191.470.1225505340812984.870.00cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
30,732,646,530.40122251,906,938.771.470.0482230016937989.940.5807c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
30,732,633,836.49101304,283,503.331.470.0557856198039279.990.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
24,586,119,032.34130189,123,992.561.180.0927185606749747.284.45aq8yqxyyb40nn   update sys.job$ set this_date=...
24,586,116,742.19122,048,843,061.851.180.01235883303676401.880.00f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
24,586,112,401.6764,097,685,400.281.180.554460680729075.260.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
24,586,108,881.84101243,426,820.611.180.0455018481620693.620.00459f3z9u4fb3u   select value$ from props$ wher...
24,586,105,233.03212,293,052,616.511.182.48989660066265.260.004dy1xm4nxc0gf   insert into wrh$_system_event ...
24,586,105,232.93212,293,052,616.471.181.301888043713172.600.00586b2udq6dbng   insert into wrh$_sysstat (snap...

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
3.1213.12106.463.20384210009772.5097.42350myuyx0t1d6   insert into wrh$_tablespace_st...
0.016500.000.500.3772125418511713.563.8918naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
0.011180.000.290.2659531460884354.513.317vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
0.001300.000.140.0927185606749747.284.45aq8yqxyyb40nn   update sys.job$ set this_date=...
0.001300.000.130.0896392869865319.814.5247a50dvdgnxc2   update sys.job$ set failures=0...
0.001100.000.063.748865914458852.300.053am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
0.0020.000.052.95625972675430.840.05gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
0.001160.000.020.0755172816103130.010.8939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
0.0043,1460.000.024.1271708189460955.910.018vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
0.001220.000.010.0482230016937989.940.5807c4n5uh9nk0r   select tab.rowid, tab.msgid, t...

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
221,20143,1465.1350.324.127170808vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
107,637138,279.7724.493.421439105k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
67,4241,61241.8315.341.388086606amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
31,718110288.357.223.7488659.13am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
25,522212,761.005.812.95625970gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
22,8366,7313.395.200.63603710cm5vu20fhtnq1   select /*+ connect_by_filterin...
17,1502,8645.993.903.338588606v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
16,448101,644.803.740.757368200njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
15,29623964.003.482.101755002b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
10,813110,813.002.460.46133250d2zc7068p1xq2   BEGIN ECM_CT.DELETE_SNAPSHOTS(...
9,41761,569.502.140.554460605uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
7,85051,570.001.790.596301209dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
7,78523133.701.770.158051400k8522rmdzg4k   select privilege# from sysauth...
6,3356,3351.001.440.388293508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
6,1386509.441.400.37721253.918naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
5,2941,6043.301.200.339180003c1kubcdjnppq   update sys.col_usage$ set equa...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0240.000.000.020.000.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
01220.000.000.0482230016937989.940.5807c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
03,8480.000.000.1775550415909199.460.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
03460.000.000.0495312226972700.680.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
01320.000.000.1159700325203948.450.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
02310.000.000.1580514620526186.880.000k8522rmdzg4k   select privilege# from sysauth...
0100.000.000.757368239521635.700.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
01010.000.000.0557856198039279.990.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
01180.000.000.0428571216239304.560.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
06500.000.000.3772125418511713.563.8918naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...

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
2,8002,80011025.450.00140000.003am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
3573571357.000.0017850.00350myuyx0t1d6   insert into wrh$_tablespace_st...
180180257.200.009000.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
112112167.000.005600.00934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
9696244.000.004800.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
565687.000.002800.00fcsu9qb17sk52 emagent_SQL_oracle_database /* OracleOEM */ DECLARE instan...
4545153.000.002250.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
333356.600.001650.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
00240.00 0.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
001220.00 0.0007c4n5uh9nk0r   select tab.rowid, tab.msgid, t...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
43,14643,1461.004.127170808vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
6,7319,5621.420.63603710cm5vu20fhtnq1   select /*+ connect_by_filterin...
6,3356,3351.000.388293508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
3,8483,8481.000.17755500089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
2,8642,8641.003.338588606v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
2,14820.000.201315605hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
2,1482,1481.000.121226607qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,61222,20313.771.388086606amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,6041,4580.910.339180003c1kubcdjnppq   update sys.col_usage$ set equa...
1,4271300.090.346037305ms6rbzdnq16t   select job, nvl2(last_date, 1,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2386503.1518naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
2312313.060k8522rmdzg4k   select privilege# from sysauth...
2316,7313.06cm5vu20fhtnq1   select /*+ connect_by_filterin...
1301301.7247a50dvdgnxc2   update sys.job$ set failures=0...
1301301.72aq8yqxyyb40nn   update sys.job$ set this_date=...
1301301.72cumjq42201t37   select u1.user#, u2.user#, u3....
1223461.6108bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1213,8481.60089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1211321.6008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
1203531.5924dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
1206,3351.598t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
1194791.57bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
1192371.57c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
1181181.5634rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1181181.567vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
1181181.56btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
1181181.56dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
1161161.532mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
1161161.5339c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
1011011.340ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
1011011.34459f3z9u4fb3u   select value$ from props$ wher...
1011011.345ur69atw3vfhj   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,414,329240.45a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
26,705,999480.415fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
26,517,170150.407d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
25,094,313240.389juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
22,785,030240.357wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
21,120,44250.329dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
17,404,205240.266k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
15,806,665240.24b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
15,458,329240.24cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
13,573,658240.2105xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
12,924,328250.20bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
11,755,4961220.184jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
8,970,717250.141tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
8,757,21450.13a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
7,737,07520.12gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
5,167,40510.081cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
4,881,6702500.07fsbqktj5vw6n9   select next_run_date, obj#, ru...
4,685,9496500.0718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
4,399,3801,6040.073c1kubcdjnppq   update sys.col_usage$ set equa...
3,996,1721160.062mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
3,563,9191300.05cumjq42201t37   select u1.user#, u2.user#, u3....
3,553,21810.058p9z2ztb272bm   SELECT sx.instance_number, sx...
3,363,569240.059juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
3,289,4661180.057vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
3,245,24220.0566gs90fyynks7   insert into wrh$_instance_reco...
2,934,30720.04gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2,932,74180.0474fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
2,767,3931160.0439c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2,636,45050.049dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2,550,685120.04f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
2,550,2381170.04dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
2,430,3101,4270.045ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,232,5741300.0347a50dvdgnxc2   update sys.job$ set failures=0...
2,227,3771220.035r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
2,225,2432390.03d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
2,185,4151220.033x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
2,175,3301190.039q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
1,992,570100.030njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
1,894,2141,6120.036amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,873,752290.037av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
1,852,890120.037hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
1,852,788120.0385snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
1,830,848480.033tumcjn4g1gsg OEM.SystemPool UPDATE MGMT_OMS_PARAMETERS SET...
1,830,703370.039ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
1,830,6531190.03b0d86bn8ncths OEM.SystemPool SELECT STEP_ID FROM MGMT_JOB_E...
1,815,51720.0384k66tf2s7y1c   insert into wrh$_bg_event_summ...
1,799,5522,1480.035hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
1,787,6422,1480.037qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,519,4061190.027mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
1,474,1341300.02aq8yqxyyb40nn   update sys.job$ set this_date=...
1,452,27410.02bunssq950snhf   insert into wrh$_sga_target_ad...
1,437,12860.025uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
1,316,96320.02gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
1,157,729120.02auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
1,144,8031180.0234rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1,082,57643,1460.028vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1,062,34820.02gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
962gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
962gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
9365018naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
8918p9z2ztb272bm   SELECT sx.instance_number, sx...
8813047a50dvdgnxc2   update sys.job$ set failures=0...
881,6126amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
871162mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
871224jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
871225r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
87874fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
87297av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
871197mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
871187vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
87249juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
87249juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
87239d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
861223x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
86127hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
86247wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
861285snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
8612auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
8624b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
86130cumjq42201t37   select u1.user#, u2.user#, u3....
8624cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
86117dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
8612f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
8511834rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
85483tumcjn4g1gsg OEM.SystemPool UPDATE MGMT_OMS_PARAMETERS SET...
852,1485hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
852,1485hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
851199q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
85379ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
8524a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
85130aq8yqxyyb40nn   update sys.job$ set this_date=...
85119b0d86bn8ncths OEM.SystemPool SELECT STEP_ID FROM MGMT_JOB_E...
85250fsbqktj5vw6n9   select next_run_date, obj#, ru...
84251tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
84157d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
83485fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
832,1487qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
8359dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
8359dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
8211639c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
821,4275ms6rbzdnq16t   select job, nvl2(last_date, 1,...
82246k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
825a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
812405xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
7925bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
78100njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
5665uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
5543,1468vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
5543,1468vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
49266gs90fyynks7   insert into wrh$_instance_reco...
48284k66tf2s7y1c   insert into wrh$_bg_event_summ...
431bunssq950snhf   insert into wrh$_sga_target_ad...
4211cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
368a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
368a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
368a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
368a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
368a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05xcf43d9psvmSELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
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)
1tgukkrqj3zhw SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND ((CLSOID IS NOT NULL AND INST_ID IS NULL AND CLSOID IN (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2, 3, 4 DESC
24dkx03u3rj6kSELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
24g90qj2b7ywkBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END;
2b064ybzkwf1yBEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2mysbczfp729xSELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
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)
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3tumcjn4g1gsgUPDATE MGMT_OMS_PARAMETERS SET VALUE = :B1 WHERE HOST_URL = :B3 AND NAME = :B2
3x0kdm7z3yaswSELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
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
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
586b2udq6dbnginsert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
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
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
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
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
9ugwm6xmvw06uSELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1
a5mmhrrnpwjsc SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
a5pyncg7v0bw3/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_F INDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
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'
b0d86bn8ncthsSELECT STEP_ID FROM MGMT_JOB_EXECUTION WHERE STEP_ID = :B1 FOR UPDATE NOWAIT
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
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
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
d27r7zhtnfgp4SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();'
d2zc7068p1xq2BEGIN ECM_CT.DELETE_SNAPSHOTS(:1); END;
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
fcsu9qb17sk52 /* OracleOEM */ DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SEL ECT parameter_value, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; -- open the cursor to return OPEN data_cursor FOR SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, NULL, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS') start_time, TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM dba_addm_findings f, (SELECT finding_id, count(r.rec_id) recCount, r.type FROM dba_advisor_recommendations r WHERE task_id=latest_task_id GRO UP BY r.finding_id, r.type) recInfo, (select count(f_all.task_id) finding_count, f_curr.finding_name FROM (select finding_name from dba_advisor_findings where task_id=latest_task_id) f_curr, (select t.task_id, i.local_task_id, t.end_time, t.begin_time from dba_addm_tasks t, dba_addm_instances i where t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=sys_context('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ) tasks, dba_advisor_findings f_all WHERE f_all.task_id=tasks.task_id AND f_all.finding_name=f_curr.finding_name AND f_all.type<>'INFORMATION' AND f_all.type<>'WARNING' AND f_all.parent=0 GROUP BY f_curr.finding_name) history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f.parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :2 := data_cursor; END;
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
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)
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 referenced20.000.00
CCursor + sql area evicted90.000.00
CPU used by this session40,297,323,095,5055,624,991,795.1321,936,485,081.93
CPU used when call started36,315,546,173,2175,069,186,575.4019,768,941,847.15
CR blocks created3820.050.21
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time2,184,000304.861,188.89
DBWR checkpoint buffers written21,5643.0111.74
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes1710.020.09
DBWR undo block writes2,2770.321.24
Effective IO time00.000.00
HSC Heap Segment Block Changes8,2261.154.48
Heap Segment Array Inserts1830.030.10
Heap Segment Array Updates3190.040.17
IMU CR rollbacks4140.060.23
IMU Flushes2,2520.311.23
IMU Redo allocation size6,600,824921.393,593.26
IMU commits1,3640.190.74
IMU contention00.000.00
IMU ktichg flush00.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size12,377,2641,727.716,737.76
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 client13,8521.937.54
RowCR - row contention00.000.00
RowCR attempts10,3911.455.66
RowCR hits10,3911.455.66
SMON posted for dropping temp segment00.000.00
SQL*Net roundtrips to/from client13,8521.937.54
active txn count during cleanout940.010.05
application wait time80.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts44,5086.2124.23
branch node splits00.000.00
buffer is not pinned count156,52521.8585.21
buffer is pinned count76,93910.7441.88
bytes received via SQL*Net from client7,180,8841,002.363,909.03
bytes sent via SQL*Net to client2,040,864284.881,110.98
calls to get snapshot scn: kcmgss84,15711.7545.81
calls to kcmgas3,6560.511.99
calls to kcmgcs7,6601.074.17
cell physical IO interconnect bytes503,893,50470,337.10274,302.40
change write time1380.020.08
cleanout - number of ktugct calls1050.010.06
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets90.000.00
cluster key scan block gets6,2600.873.41
cluster key scans5,5890.783.04
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed170.000.01
commit batch/immediate requested170.000.01
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure50.000.00
commit cleanout failures: cannot pin00.000.00
commit cleanouts27,8103.8815.14
commit cleanouts successfully completed27,8053.8815.14
commit immediate performed170.000.01
commit immediate requested170.000.01
commit txn count during cleanout460.010.03
concurrency wait time3,1990.451.74
consistent changes5530.080.30
consistent gets233,14532.54126.92
consistent gets - examination86,30012.0546.98
consistent gets direct00.000.00
consistent gets from cache233,14532.54126.92
consistent gets from cache (fastpath)99,91213.9554.39
cursor authentications2110.030.11
data blocks consistent reads - undo records applied5340.070.29
db block changes220,13430.73119.83
db block gets206,41728.81112.37
db block gets direct20.000.00
db block gets from cache206,41528.81112.37
db block gets from cache (fastpath)67,0169.3536.48
deferred (CURRENT) block cleanout applications13,5161.897.36
enqueue conversions1,4390.200.78
enqueue releases87,21412.1747.48
enqueue requests87,21412.1747.48
enqueue timeouts00.000.00
enqueue waits00.000.00
execute count73,66210.2840.10
failed probes on index block reclamation20.000.00
file io service time00.000.00
file io wait time4,891,545682.802,662.79
free buffer inspected00.000.00
free buffer requested6,6480.933.62
heap block compress680.010.04
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications90.000.00
immediate (CURRENT) block cleanout applications11,3481.586.18
in call idle wait time24,430,5963,410.2013,299.18
index crx upgrade (positioned)10,9601.535.97
index crx upgrade (prefetch)50.000.00
index fast full scans (full)270.000.01
index fetch by key63,3058.8434.46
index scans kdiixs158,2168.1331.69
leaf node 90-10 splits290.000.02
leaf node splits480.010.03
lob reads00.000.00
lob writes80.000.00
lob writes unaligned80.000.00
logical read bytes from cache3,600,875,520502,636.251,960,193.53
logons cumulative5050.070.27
max cf enq hold time00.000.00
messages received6,4440.903.51
messages sent6,4440.903.51
min active SCN optimization applied on CR00.000.00
no work - consistent read gets101,37314.1555.18
non-idle wait count50,0556.9927.25
non-idle wait time5,7540.803.13
opened cursors cumulative67,1479.3736.55
parse count (describe)00.000.00
parse count (failures)160.000.01
parse count (hard)3680.050.20
parse count (total)7,5581.064.11
parse time cpu13,819,315,784,5521,929,000,040.987,522,763,083.59
parse time elapsed3160.040.17
physical read IO requests20.000.00
physical read bytes16,3842.298.92
physical read total IO requests12,3031.726.70
physical read total bytes198,746,11227,742.42108,190.59
physical read total multi block requests00.000.00
physical reads20.000.00
physical reads cache20.000.00
physical reads cache prefetch00.000.00
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical write IO requests3,7190.522.02
physical write bytes176,668,67224,660.6996,172.39
physical write total IO requests12,1271.696.60
physical write total bytes305,147,39242,594.68166,111.81
physical write total multi block requests8500.120.46
physical writes21,5663.0111.74
physical writes direct20.000.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace20.000.00
physical writes from cache21,5643.0111.74
physical writes non checkpoint2,2230.311.21
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 calls223,18631.15121.49
recursive cpu usage67,486,124,599,7489,420,201,343.3836,737,139,139.76
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)13,6641.917.44
redo blocks written68,4079.5537.24
redo buffer allocation retries00.000.00
redo entries99,87913.9454.37
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks1190.020.06
redo size32,873,2244,588.6817,895.06
redo size for direct writes00.000.00
redo subscn max counts4,9230.692.68
redo synch long waits20.000.00
redo synch time1230.020.07
redo synch time (usec)1,333,240186.10725.77
redo synch writes9590.130.52
redo wastage762,056106.37414.84
redo write time3310.050.18
redo writes2,7000.381.47
rollback changes - undo records applied1330.020.07
rollbacks only - consistent read gets3810.050.21
root node splits00.000.00
rows fetched via callback14,3882.017.83
session connect time00.000.00
session logical reads439,56261.36239.28
shared hash latch upgrades - no wait38,0165.3120.69
shared hash latch upgrades - wait60.000.00
sorts (memory)22,0693.0812.01
sorts (rows)64,0788.9434.88
sql area evicted2300.030.13
sql area purged160.000.01
switch current to new buffer4,3840.612.39
table fetch by rowid47,6586.6525.94
table fetch continued row130.000.01
table scan blocks gotten29,4074.1016.01
table scan rows gotten1,522,336212.50828.71
table scans (long tables)00.000.00
table scans (short tables)4,9740.692.71
temp space allocated (bytes)00.000.00
total cf enq hold time1,5100.210.82
total number of cf enq holders1260.020.07
total number of times SMON posted70.000.00
transaction rollbacks170.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size13,869,5841,936.027,550.13
user I/O wait time2930.040.16
user calls16,9802.379.24
user commits1,8210.250.99
user rollbacks160.000.01
workarea executions - onepass00.000.00
workarea executions - optimal8,0921.134.41
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 current4545
session uga memory max192,172,271,488192,552,961,304
session pga memory175,477,453,184175,824,014,808
session pga memory max190,195,479,584190,545,645,688
session cursor cache count3,509,5363,516,603
session uga memory285,357,494,469,184285,937,340,710,272
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)
Others190M1.72.02652189M0.80.01242315.2K0.59
DBWR0M0.000M169M0.52.0235900 
LGWR0M0.000M34M0.38.00474526970.68
Buffer Cache Reads0M0.000M0M0.000M20.00
TOTAL:190M1.72.026521292M1.69.04075917.9K0.60

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 File187M1.67.02610289M0.80.0124230.28 
Data File0M0.050M166M0.52.0231718.62 
Log File0M0.000M34M0.38.004745  
Temp File0M0.000M0M0.000M0.00 
TOTAL:187M1.72.026102289M1.69.0403400.51 

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 190M1.72.02652189M0.80.01242312.3K0.51
Others (Control File) 187M1.67.02610289M0.80.01242312K0.28
Others (Data File) 3M0.05.0004180M0.000M3438.62
DBWR 0M0.000M169M0.52.0235900 
DBWR (Data File) 0M0.000M169M0.52.0235900 
LGWR 0M0.000M34M0.38.0047450 
LGWR (Log File) 0M0.000M34M0.38.0047450 
Buffer Cache Reads 0M0.000M0M0.000M20.00
Buffer Cache Reads (Data File) 0M0.000M0M0.000M20.00
TOTAL: 190M1.72.026521292M1.69.04075912.3K0.51

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 000.000.003,102000.00
UNDOTBS1 000.000.00469000.00
SYSTEM 000.000.00146000.00
TEMP 200.001.002000.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 00  3,102000.00
SYSTEM+DATA/xjdss/system01.dbf 00  146000.00
TEMP+DATA/xjdss/temp01.dbf 200.001.00200 
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  208000.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  36000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  145000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  42000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  38000.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,334,316100439,550221,564000

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000021,5640

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
B026525212183240152548033224015   
E0232391212127252548033212725   

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.002901195.00
D8,4480.201,0421.002891194.00
D12,6720.291,5621.002891194.00
D16,8960.392,0831.002891194.00
D21,1200.492,6041.002891194.00
D25,3440.593,1251.002891194.00
D29,5680.683,6461.002891194.00
D33,7920.784,1661.002891194.00
D38,0160.884,6871.002891194.00
D42,2400.985,2081.002891194.00
D43,2641.005,3341.002891194.00
D46,4641.075,7291.002891194.00
D50,6881.176,2501.002891194.00
D54,9121.276,7701.002891194.00
D59,1361.377,2911.002891194.00
D63,3601.467,8121.002891194.00
D67,5841.568,3331.002891194.00
D71,8081.668,8541.002891194.00
D76,0321.769,3751.002891194.00
D80,2561.869,8951.002891194.00
D84,4801.9510,4161.002891194.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,625381.710.000.000.000.001,048,576
E14,33612,625381.770.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
2K4K7,9647,96400
64K128K161600
256K512K4400
512K1024K878700
1M2M171700
4M8M2200
8M16M2200

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.13106,725.575.89100.00128,978,949
3,5840.25106,725.575.89100.00128,978,949
7,1680.50106,725.575.89100.00028,978,949
10,7520.75106,725.575.89100.00028,978,949
14,3361.00106,725.575.89100.00028,978,949
17,2031.20106,725.570.00100.00028,977,349
20,0701.40106,725.570.00100.00028,977,349
22,9381.60106,725.570.00100.00028,977,349
25,8051.80106,725.570.00100.00028,977,349
28,6722.00106,725.570.00100.00028,977,349
43,0083.00106,725.570.00100.00028,977,349
57,3444.00106,725.570.00100.00028,977,349
86,0166.00106,725.570.00100.00028,977,349
114,6888.00106,725.570.00100.00028,977,349

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,7120.59666,854961,5670.87152,98646.6347,629
4,3520.6970524,7951,084,9000.9829,6539.0453,839
4,9920.801,34539,5901,096,1230.9918,4305.6254,387
5,1200.821,47242,0811,098,2470.9916,3064.9754,497
5,2480.841,60044,6761,100,1630.9914,3904.3954,594
5,3760.861,72848,5031,102,1560.9912,3973.7854,685
5,5040.881,85351,6121,104,1740.9910,3793.1654,802
5,6320.901,98156,0471,105,9891.008,5642.6154,910
5,7600.922,10960,6611,107,4481.007,1052.1754,983
5,8880.942,23764,8681,108,7571.005,7961.7755,050
6,0160.962,36471,5611,109,9301.004,6231.4155,101
6,1440.982,49275,7891,111,1041.003,4491.0555,152
6,2721.002,62080,0171,111,2721.003,2811.0055,171
6,4001.022,74884,2451,111,2751.003,2781.0055,171
6,5281.042,87688,4731,111,2771.003,2761.0055,171
6,6561.063,00492,7011,111,2791.003,2741.0055,171
6,7841.083,13296,9291,111,2791.003,2741.0055,171
6,9121.103,17798,4251,111,2791.003,2741.0055,171
7,0401.123,17798,4251,111,2791.003,2741.0055,171
7,1681.143,17798,4251,111,2791.003,2741.0055,171
7,2961.163,17798,4251,111,2791.003,2741.0055,171
7,4241.183,17798,4251,111,2791.003,2741.0055,171
7,5521.203,17798,4251,111,2791.003,2741.0055,171
8,1921.313,17798,4251,111,2791.003,2741.0055,171
8,8321.413,17798,4251,111,2791.003,2741.0055,171
9,4721.513,17798,4251,111,2791.003,2741.0055,171
10,1121.613,17798,4251,111,2791.003,2741.0055,171
10,7521.713,17798,4251,111,2791.003,2741.0055,171
11,3921.823,17798,4251,111,2791.003,2741.0055,171
12,0321.923,17798,4251,111,2791.003,2741.0055,171
12,6722.023,17798,4251,111,2791.003,2741.0055,171

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.2510,481,895,762,139289,515
19,2000.3810,481,895,762,139288,966
25,6000.5010,481,895,762,139288,937
32,0000.6310,481,895,762,139288,937
38,4000.7510,481,895,762,139288,937
44,8000.8810,481,895,762,139288,937
51,2001.0010,481,895,762,139288,937
57,6001.1310,481,895,762,139288,937
64,0001.2510,481,895,762,139288,937
70,4001.3810,481,895,762,139288,937
76,8001.5010,481,895,762,139288,937
83,2001.6310,481,895,762,139288,937
89,6001.7510,481,895,762,139288,937
96,0001.8810,481,895,762,139288,937
102,4002.0010,481,895,762,139288,937

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
21.111,3479024654663.9/658138.70/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
21-Nov 00:58171929024658,1110/00/0/0/0/0/0
21-Nov 00:481441452982656,7210/00/0/0/0/0/0
21-Nov 00:381461958981657,4160/00/0/0/0/0/0
21-Nov 00:28111222932658,1390/00/0/0/0/0/0
21-Nov 00:181493668921656,6330/00/0/0/0/0/0
21-Nov 00:086453272883654,6640/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 latch20.00 00 
AQ dequeue txn counter latch6,2040.00 00 
ASM Keyed state latch7400.00 00 
ASM allocation2360.00 00 
ASM db client latch4,7640.00 00 
ASM map operation freelist720.00 00 
ASM map operation hash table48,9640.00 00 
ASM network background latch2,9900.00 00 
ASM network state latch3650.00 00 
AWR Alerted Metric Element list76,8940.00 00 
Change Notification Hash table latch2,3820.00 00 
Consistent RBA2,6990.00 00 
DML lock allocation34,6700.00 00 
Event Group Locks8770.00 00 
FAL Queue1910.00 00 
FOB s.o list latch9,2880.00 00 
File State Object Pool Parent Latch20.00 00 
I/O Staticstics latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch35,9430.00 05,3370.00
JS Sh mem access140.00 00 
JS mem alloc latch300.00 00 
JS queue access latch320.00 00 
JS queue state obj latch51,8000.00 00 
JS slv state obj latch4780.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KFK SGA Libload latch13,8040.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch2,3880.00 00 
KTF sga latch380.00 02,0460.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch1980.00 00 
Locator state objects pool parent latch20.00 00 
Lsod array latch4,9400.00 00 
MQL Tracking Latch0  01420.00
Memory Management Latch20.00 02,3880.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch780.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process2,8270.00 00 
OS process allocation16,0860.00 00 
OS process: request allocation7400.00 00 
PL/SQL warning settings1,7400.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch66,6870.00 00 
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 02,3800.00
SQL memory manager workarea list latch164,6300.00 00 
Shared B-Tree8250.00 00 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch13,2690.170.0000 
active service list16,5380.00 08,5300.00
archive control3670.00 00 
archive process latch5730.00 00 
buffer pool20.00 00 
business card20.00 00 
cache buffer handles4360.00 00 
cache buffers chains1,285,6190.000.0005,7960.00
cache buffers lru chain30,3880.000.00028,4900.00
call allocation2,8690.030.0000 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch7700.00 00 
channel operations parent latch53,8840.00 00 
checkpoint queue latch1,630,9950.000.00016,5320.00
client/application info3,5060.00 00 
compile environment latch5050.00 00 
corrupted undo seg latch4160.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch1130.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch1130.00 00 
dml lock allocation1130.00 00 
done queue latch20.00 00 
dummy allocation1,0120.00 00 
enqueue freelist latch20.00 0133,9300.00
enqueue hash chains175,9640.00 00 
enqueues20.00 00 
fifth spare latch20.00 00 
file cache latch9920.00 00 
flashback copy20.00 00 
fourth Audit Vault latch20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA1010.00 00 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch5800.00 070,9410.00
hash table modification latch1480.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch20.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch1370.00 01353.70
job_queue_processes free list latch2780.00 00 
job_queue_processes parameter latch1,6860.00 00 
k2q lock allocation20.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kokc descriptor allocation latch1,7040.00 00 
krbmrosl20.00 00 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock640.00 00 
ksuosstats global area7190.00 00 
ksv allocation latch2370.00 00 
ksv class latch1,2580.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch7400.00 00 
ktm global data1140.00 00 
kwqbsn:qsga3780.00 00 
lgwr LWN SCN4,2820.00 00 
list of block allocation2,2850.00 00 
loader state object freelist40.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch260.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation30.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
managed standby latch1910.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch2460.00 00 
messages105,0270.030.0000 
mostly latch-free SCN4,4542.630.0000 
msg queue latch20.00 00 
multiblock read objects220.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch1130.00 00 
object queue header heap106,1990.00 080.00
object queue header operation172,9590.010.0000 
object stats modification40.00 00 
parallel query alloc buffer1,9060.00 00 
parallel query stats20.00 00 
parameter list1340.00 00 
parameter table management3,7680.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue5,9010.120.0004,9840.08
process allocation1,0090.00 03700.00
process group creation7400.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch1,0420.00 00 
query server freelists20.00 00 
queued dump request240.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation21,8010.040.00099,9400.01
redo copy20.00 099,9420.10
redo writing26,3910.060.0000 
resmgr group change latch29,1790.00 00 
resmgr:active threads2,5340.041.0003,5730.03
resmgr:actses change group3320.00 00 
resmgr:actses change state230.00 00 
resmgr:free threads list1,0520.00 00 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method1,0380.00 00 
resmgr:schema config30,2870.020.7101190.00
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects349,0010.00 01240.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
sequence cache7640.00 00 
session allocation6,6450.00 05,6950.00
session idle bit39,1520.00 00 
session queue latch20.00 00 
session state list latch8890.00 00 
session switching4850.00 00 
session timer2,3860.00 00 
shared pool99,7240.000.000200.00
shared pool sim alloc160.00 00 
shared pool simulator9570.00 00 
sim partition latch20.00 00 
simulator hash latch21,8040.00 00 
simulator lru latch2,9380.140.00018,6260.00
sort extent pool1980.00 00 
space background state object latch200.00 00 
space background task latch8,7160.250.0004,7820.00
state object free list20.00 00 
statistics aggregation1,1200.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch5260.00 00 
transaction allocation9,5760.00 00 
undo global data14,9530.010.0000 
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
resmgr:schema config30,287752
resmgr:active threads2,534110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chainskcbgtcr: fast path030
resmgr:active threadskgskmetricupd010
resmgr:schema configkgskgasi1031
resmgr:schema configkgskmetricupd020

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpndl1 9520
Library Cachekglpin1 410
Library Cachekglpnal1 9010

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX54,68812.44
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX51,56811.73
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX17,5684.00
SYSSYSTEMI_SYSAUTH1 INDEX15,5843.55
SYSSYSTEMAUD$ TABLE5,4241.23

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX5,12523.76
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX3,43715.94
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1850.86
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX400.19
SYSSYSAUXSMON_SCN_TIME TABLE350.16

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX54014.52
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX38710.41
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX370.99
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX340.91
SYSSYSAUXSMON_SCN_TIME TABLE200.54

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX414.81
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX13.70

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 INDEX22,12838.11
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX19,58433.73
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX9,53616.42
SYSMANSYSAUXMGMT_ESA_REPORT_PK INDEX1,3282.29
SYSMANSYSAUXMGMT_ESA_REPORT TABLE1,2482.15

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_control1280.000 31
dc_files6860.000 0343
dc_global_oids8,1350.000 094
dc_histogram_data3,5782.210 032,256
dc_histogram_defs19,6571.280 08,336
dc_object_grants2880.000 0105
dc_objects20,4310.000 107,602
dc_profiles3410.000 02
dc_rollback_segments5,8600.000 067
dc_segments2,9600.000 17857
dc_sequences10.000 111
dc_tablespaces12,3010.000 019
dc_users41,2850.000 0256
global database name5,0250.000 01
outstanding_alerts1800.000 015
sch_lj_oids90.000 0267


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS2020.000 00
BODY2,1250.0015,1580.0000
CLUSTER160.00160.0000
DBLINK2060.000 00
EDITION2570.004930.0000
INDEX90.00988.8970
QUEUE1210.0020,2700.0000
SCHEMA3050.000 00
SQL AREA4,4830.1195,9750.645716
SQL AREA BUILD29112.710 00
SQL AREA STATS28479.2328479.2300
SUBSCRIPTION140.00140.0000
TABLE/PROCEDURE5,8870.0029,8500.49460
TRIGGER1390.006820.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,264.0043,264.0043,392.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target14,336.0014,336.0014,336.0014,336.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target51,200.0051,200.0051,200.0051,200.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool896.00896.00896.00896.000STA/
large pool384.00384.00384.00384.000STA/
shared pool6,272.006,272.006,144.006,272.000GRO/DEF
streams pool128.00128.00128.00128.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther320.95 6.8310.6044444747
Freeable38.130.001.592.119 2424
PL/SQL21.553.440.481.7812124545
SQL1.120.150.050.050202217
EOther319.85 6.8110.6144444747
Freeable39.380.001.582.099 2525
PL/SQL21.483.370.481.7812124545
SQL1.090.140.050.050202217

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers45,365,592,064 
Fixed Size2,234,120 
Redo Buffers26,513,408 
Variable Size8,053,065,976 

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
sharedKGLH0757.30757.05-0.03
sharedKGLHD83.1982.96-0.27
sharedSQLA2,214.442,214.870.02
shareddb_block_hash_buckets356.00356.000.00
shareddbktb: trace buffer78.1378.130.00
sharedevent statistics per sess94.2694.260.00
sharedfree memory1,630.621,631.560.06
sharedksunfy : SSO free list87.8787.870.00
sharedprivate strands107.80107.800.00
streamsfree memory126.74126.740.00
 buffer_cache43,264.0043,264.000.00
 fixed_sga2.132.130.00
 log_buffer25.2925.290.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

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

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12733) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(69041) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(68711) 1221220.000.000.060.210.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 %
7,1650.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.007,1650.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 awrrpt_1120_2300_0100.html