Enter value for report_name: awrrpt_1_1200_1500.html Using the report name awrrpt_1_1200_1500.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 919-922

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:91926-Nov-13 12:00:3046 3.4
End Snap:92226-Nov-13 15:00:0544 3.5
Elapsed:  179.59 (mins)  
DB Time:  52,856,008,731.37 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 294,312,637.1 1,178,068,545.3 2.7E+07 1.0E+08
DB CPU(s): 294,312,637.1 1,178,068,545.3 2.7E+07 1.0E+08
Redo size: 4,752.8 19,024.3  
Logical reads: 64.8 259.3  
Block changes: 32.0 127.9  
Physical reads: 0.0 0.0  
Physical writes: 3.3 13.3  
User calls: 2.9 11.7  
Parses: 1.0 3.8  
Hard parses: 0.0 0.0  
W/A MB processed: 0.0 0.1  
Logons: 0.1 0.3  
Executes: 10.8 43.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.90Soft Parse %: 99.22
Execute to Parse %: 91.10Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 1.46074215E+13% Non-Parse CPU: 94.15

Shared Pool Statistics

BeginEnd
Memory Usage %: 70.86 70.88
% SQL with executions>1: 95.58 98.61
% Memory for SQL w/exec>1: 76.90 95.90

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 3,171,360,523,833 100.00 
control file sequential read5,621310.00System I/O
log file sync1,268210.00Commit
ADR block file read108160.00Other
SQL*Net break/reset to client6,080000.00Application

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

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

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
9.2E+08 1.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): 385.2 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 CPU3,171,360,523,833.12100.00
sql execute elapsed time53.430.00
PL/SQL execution elapsed time10.310.00
parse time elapsed1.730.00
connection management call elapsed time1.220.00
hard parse elapsed time0.400.00
hard parse (sharing criteria) elapsed time0.340.00
PL/SQL compilation elapsed time0.050.00
repeated bind elapsed time0.050.00
failed parse elapsed time0.010.00
DB time3,171,360,523,882.02 
background elapsed time313.43 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME5,679 
AVG_IDLE_TIME1,070,782 
AVG_IOWAIT_TIME49 
AVG_SYS_TIME1,878 
AVG_USER_TIME3,394 
BUSY_TIME198,674 
IDLE_TIME34,281,768 
IOWAIT_TIME3,920 
SYS_TIME73,821 
USER_TIME124,853 
LOAD00
OS_CPU_WAIT_TIME188,200 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES4,702,208 
VM_OUT_BYTES39,071,744 
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
26-Nov 12:00:300.28     
26-Nov 15:00:050.340.580.360.2199.420.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  3,171,360,523,833 100.00
System I/O5,6210310.00
Commit1,2680210.00
Other1420150.00
Application6,0800000.00
User I/O2470010.00
Network28,2870000.00
Concurrency210000.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 read5,6210312.090.00
log file sync1,2680210.470.00
ADR block file read1080160.040.00
SQL*Net break/reset to client6,0800002.260.00
Disk file operations I/O2400010.090.00
SQL*Net message to client26,6420009.900.00
SQL*Net more data from client1,6450000.610.00
ADR block file write150010.010.00
db file sequential read40030.000.00
direct path write temp30010.000.00
SQL*Net message from client26,642055,90320989.90 
jobq slave wait22,98910011,4744998.54 
wait for unread message on broadcast channel10,9429810,7719844.06 
Streams AQ: waiting for messages in the queue2,16110010,77049840.80 

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 startup4020481190.1515.21
control file sequential read12,4510914.633.02
db file parallel write5,7890812.152.43
db file sequential read6870690.261.98
control file parallel write4,4240511.641.73
log file parallel write3,6310411.351.14
ASM file metadata operation3,2320001.200.10
ADR block file read480040.020.06
Disk file operations I/O6,9460002.580.03
enq: PR - contention100580.000.02
CSS initialization100160.000.01
log file sync40030.000.00
ADR block file write150010.010.00
direct path write10070.000.00
db file async I/O submit5,7890002.150.00
LGWR wait for redo copy890000.030.00
CSS operation: action10030.000.00
asynch descriptor resize560100000.210.00
CSS operation: query60000.000.00
buffer busy waits10020.000.00
rdbms ipc message70,27795215,364306526.11 
DIAG idle wait21,19810021,19810007.87 
Space Manager: slave idle wait3,2699816,20149561.21 
dispatcher timer18010010,800600010.07 
smon timer467410,7832344170.02 
Streams AQ: qmn coordinator idle wait7705010,780140000.29 
Streams AQ: qmn slave idle wait385010,780280000.14 
class slave wait715010,775150700.27 
wait for unread message on broadcast channel10,77510010,77510004.00 
ASM background timer2,154010,77250010.80 
pmon timer3,59010010,77030001.33 
shared server idle wait35910010,770300000.13 
SQL*Net message from client6360110.24 
KSV master wait2110000.08 

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 read15632.16.42.634.023.11.9  
ADR block file write3096.7   3.3   
ADR file lock36100.0       
ASM file metadata operation3233100.0       
CSS initialization1    100.0   
CSS operation: action1  100.0     
CSS operation: query683.316.7      
Disk file operations I/O719098.8.8.4.0    
LGWR wait for redo copy90100.0       
SQL*Net break/reset to client6080100.0       
SQL*Net message to client27.1K100.0       
SQL*Net more data from client1647100.0       
SQL*Net more data to client2100.0       
asynch descriptor resize562100.0       
buffer busy waits250.050.0      
control file parallel write442092.33.01.21.31.4.4.4 
control file sequential read18.1K97.2.6.4.7.8.1.1 
db file async I/O submit5789100.0       
db file parallel write578961.315.721.4.9.7.1  
db file sequential read691.3.11.451.445.01.7  
direct path write1   100.0    
direct path write temp366.7 33.3     
enq: PR - contention1      100.0 
latch: In memory undo latch1100.0       
latch: active service list1100.0       
latch: cache buffers chains3100.0       
latch: call allocation1100.0       
latch: undo global data1100.0       
library cache: mutex X19100.0       
log file parallel write367690.11.83.62.51.6.2.1 
log file sync127584.94.16.02.32.0.4.4 
os thread startup404      100.0 
ASM background timer2155       100.0
DIAG idle wait21.2K      100.0 
KSV master wait222100.0       
SQL*Net message from client27.3K80.412.5.9.1.1.0.25.9
Space Manager: slave idle wait3238      .299.8
Streams AQ: qmn coordinator idle wait77050.0      50.0
Streams AQ: qmn slave idle wait385       100.0
Streams AQ: waiting for messages in the queue2161    .3  99.7
class slave wait71237.6 1.517.47.44.4.431.2
dispatcher timer180       100.0
jobq slave wait23K  .0.1.0 99.9 
pmon timer3590       100.0
rdbms ipc message70.3K.6.4.2.5.6.332.465.0
shared server idle wait360       100.0
smon timer43      2.397.7
wait for unread message on broadcast channel21.7K    .4.499.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 write1699.6.2.1     
control file sequential read1899.9.1.0     
enq: PR - contention1 100.0      
log file parallel write599.9.1.1     
log file sync599.6.2.2     
os thread startup404  99.3.7    

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)
xjdss12,292,098,82912,292,098,8050387
SYS$BACKGROUND00044
xjdssXDB0000
SYS$USERS-15,299,967,732,874-15,299,967,732,8970265

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
xjdss 1021000213880
SYS$BACKGROUND 76346406480000
SYS$USERS 2460000069000

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
23.433580.070.009523512834201.510.00aykvshm7zsabd   select size_for_estimate, size...
8.847090.010.0049499954143312.970.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
6.0623.030.00405482128552.700.00bunssq950snhf   insert into wrh$_sga_target_ad...
5.9622.980.00618911055593.3197.44350myuyx0t1d6   insert into wrh$_tablespace_st...
5.15150.340.001433363630727.540.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
4.554,3040.000.0038094061346523.270.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
3.8731.290.00794016791912.800.0066gs90fyynks7   insert into wrh$_instance_reco...
3.7131.240.00993451772299.620.004dy1xm4nxc0gf   insert into wrh$_system_event ...
3.5131.170.00701012409049.810.0084k66tf2s7y1c   insert into wrh$_bg_event_summ...
3.333580.010.0061636510723454.570.00772s25v1y0x8k   select shared_pool_size_for_es...

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
4,375,989,491,089.577096,172,058,520.58137.988.8449499954143312.970.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
2,231,019,353,350.623586,231,897,635.0670.3523.439523512834201.510.00aykvshm7zsabd   select size_for_estimate, size...
2,052,783,649,596.123585,734,032,540.7764.733.3361636510723454.570.00772s25v1y0x8k   select shared_pool_size_for_es...
2,003,613,614,468.3432,62161,420,974.6663.183.1463839786499115.730.028vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1,733,186,079,875.904,304402,691,933.0654.654.5538094061346523.270.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
854,300,586,385.381794,772,628,974.2226.940.60142716436081753.790.0024g90qj2b7ywk OEM.CacheModeWaitPool BEGIN EMDW_LOG.set_context(MGM...
596,166,596,759.1110,25858,117,235.0118.800.9165746103124063.920.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
528,560,331,795.291782,969,440,066.2716.670.6285417403735844.000.00cydnuss99swtd OEM.SystemPool BEGIN EM_PING.RECORD_BATCH_HEA...
454,807,522,838.731672,723,398,340.3514.341.3533755231331486.150.173am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
399,493,803,780.443581,115,904,479.8312.600.6264290763515823.710.008p447s6p0rv6b   select java_pool_size_for_esti...
387,201,670,097.792,499154,942,645.1012.210.5866775948017388.530.00fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
276,572,089,245.021791,545,095,470.648.720.14197842603577418.750.009q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
264,280,108,392.722,146123,150,097.118.330.4855460211363319.400.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
251,988,003,438.28406,299,700,085.967.950.3083649136061888.710.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
233,549,876,469.069,50524,571,265.287.360.5542435529298620.310.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
233,549,800,797.22723,243,747,233.297.360.3763382463707971.340.005fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
227,403,946,909.25366,316,776,303.037.170.6933056791120647.280.00gwj1f651t001a emagent_SQL_oracle_database /* OracleOEM */ SELECT SEVERIT...
227,403,944,528.78366,316,776,236.917.170.2979642750158925.020.009juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
221,257,889,697.21366,146,052,491.596.980.16140412553670399.890.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
221,257,699,280.181791,236,076,532.296.980.3760255528822294.885.407vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
208,965,670,801.88874239,091,156.526.590.3264335928991600.060.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
196,673,503,592.02354555,574,868.906.200.2096378343848997.830.000k8522rmdzg4k   select privilege# from sysauth...
190,527,801,804.902,72070,046,985.966.010.3553851685496904.370.002jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
159,797,240,666.02185863,768,868.465.040.2079110677980324.610.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
153,651,310,612.81256,146,052,424.514.840.11134625968714132.450.27934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
147,505,273,645.05364,097,368,712.364.650.13111678735346039.640.008u5gujrwh4wf4 emagent_SQL_oracle_database /* OracleOEM */ declare TYPE d...
147,505,089,211.32304,916,836,307.044.652.116975696999954.180.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
141,359,208,916.23236,146,052,561.584.460.07195034712007930.440.007d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
141,359,208,916.23236,146,052,561.584.460.10144410604999875.260.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
135,213,052,439.47387349,387,732.404.260.2067597400570659.970.00fsbqktj5vw6n9   select next_run_date, obj#, ru...
122,920,954,521.59198620,812,901.623.880.1580258136762664.600.00cumjq42201t37   select u1.user#, u2.user#, u3....
116,774,933,898.805,76920,241,798.213.680.2545935320317680.740.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
86,044,685,907.08183470,189,540.482.710.1751021492556558.360.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
86,044,673,175.83156551,568,417.792.710.1460517701504297.976.764vs91dcv7u1p6 emagent@xjdssa (TNS V1-V3) insert into sys.aud$( sessioni...
86,044,635,960.76184,780,257,553.382.711.605368187402331.810.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
73,752,650,596.36154,916,843,373.092.335.151433363630727.540.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
73,752,572,213.58158466,788,431.732.330.0890722150456457.170.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
67,606,519,450.71176384,127,951.422.130.0888175132642137.550.006r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
67,606,509,698.34154,507,100,646.562.130.897560000010996.170.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
61,460,470,782.81198310,406,418.091.940.1443168021620935.535.03aq8yqxyyb40nn   update sys.job$ set this_date=...
55,314,440,318.0786,914,305,039.761.740.0773758487769779.550.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
55,314,416,806.32179309,019,088.301.740.0865545397976464.863.4939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
55,314,412,362.67198279,365,719.001.740.1246001806628747.989.5447a50dvdgnxc2   update sys.job$ set failures=0...
49,168,423,522.31242,048,684,313.431.550.05106558934424833.040.004nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
49,168,404,109.86176279,365,932.441.550.04135052061718515.960.00dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
49,168,392,803.49358137,341,879.341.550.03153201198988891.620.00c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
49,168,391,147.70178276,226,916.561.550.0676593437311438.160.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
49,168,375,180.94179274,683,660.231.550.04114347717809569.300.002mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
49,168,370,807.8272068,289,403.901.550.0768886419535726.410.00bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
49,168,368,581.30179274,683,623.361.550.01427290941003705.120.00ab5btgh76akb6 OEM.CacheModeWaitPool delete from "SYSMAN"."MGMT_JO...
36,876,308,357.36361,024,341,898.821.160.03136467723918889.800.007wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
36,876,299,502.4153668,799,066.241.160.0578242132571792.730.0024dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
36,876,299,495.79179206,012,846.351.160.03132291657383987.330.00415urv6x9mf8w OEM.CacheModeWaitPool SELECT /*+ RULE */ STEP_ID FRO...
36,876,299,015.29179206,012,843.661.160.0581852745749992.020.007mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
36,876,274,159.00218,438,137,079.501.165.96618911055593.3197.44350myuyx0t1d6   insert into wrh$_tablespace_st...
36,876,274,109.59312,292,091,369.861.163.71993451772299.620.004dy1xm4nxc0gf   insert into wrh$_system_event ...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
5.8122.9090.205.96618911055593.3197.44350myuyx0t1d6   insert into wrh$_tablespace_st...
0.021790.000.310.3760255528822294.885.407vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
0.011980.000.180.1246001806628747.989.5447a50dvdgnxc2   update sys.job$ set failures=0...
0.011560.000.150.1460517701504297.976.764vs91dcv7u1p6 emagent@xjdssa (TNS V1-V3) insert into sys.aud$( sessioni...
0.011980.000.110.1443168021620935.535.03aq8yqxyyb40nn   update sys.job$ set this_date=...
0.001790.000.050.0865545397976464.863.4939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
0.001670.000.041.3533755231331486.150.173am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
0.0030.000.030.288635696992145.080.73gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
0.0010.000.030.774006396052120.940.24bryu1pu7rnk2s perl@xjdssa (TNS V1-V3) SELECT REPLACE(REPLACE(ddf.fi...
0.0032,6210.000.013.1463839786499115.730.028vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...

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
168,39732,6215.1624.133.146383908vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
161,4681510,764.5323.135.151433305k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
49,344301,644.807.072.116975600njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
34,79810,2583.394.990.91657460cm5vu20fhtnq1   select /*+ connect_by_filterin...
28,176181,565.334.041.605368105uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
25,709167153.953.681.3533755.23am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
22,97635964.003.293.09002b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
22,0314,3045.123.164.553809406v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
21,7602,7208.003.120.355385102jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
17,6312,4997.062.530.58667750fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
16,62635,542.002.380.2886356.7gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
11,87235433.541.700.209637800k8522rmdzg4k   select privilege# from sysauth...
9,5069,5051.001.360.554243508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
8,01818,018.001.151.53402480cn58bhkggqvj4 emagent_SQL_oracle_database /* OracleOEM */ SELECT dtp.tab...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0150.000.000.897560000010996.170.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
0360.000.000.030.000.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
01860.000.000.0642656449023689.901.0707c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
05,7690.000.000.2545935320317680.740.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
05410.000.000.0642928306225009.050.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
01830.000.000.1751021492556558.360.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
03540.000.000.2096378343848997.830.000k8522rmdzg4k   select privilege# from sysauth...
0300.000.002.116975696999954.180.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
01580.000.000.0890722150456457.170.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
01780.000.000.0676593437311438.160.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
1,4371,43711,437.000.0028740.00cn58bhkggqvj4 emagent_SQL_oracle_database /* OracleOEM */ SELECT dtp.tab...
1,4001,40011,400.000.0028000.00bryu1pu7rnk2s perl@xjdssa (TNS V1-V3) SELECT REPLACE(REPLACE(ddf.fi...
168168256.720.003360.00934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
144144364.000.002880.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
6969233.000.001380.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
66661670.400.001320.003am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
00150.00 0.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
00360.00 0.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
001860.00 0.0007c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
005,7690.00 0.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
32,62132,6181.003.146383908vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
10,25814,5661.420.91657460cm5vu20fhtnq1   select /*+ connect_by_filterin...
9,5059,5061.000.554243508t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
5,7695,7691.000.25459350089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
4,3044,3041.004.553809406v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
2,7202,7201.000.355385102jfqzrxhrm93b   select /*+ rule */ c.name, u.n...
2,4992,4991.000.58667750fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
2,1461980.090.485546005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
1,0761790.170.163903003mzmha5pxaf9j OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
8748741.000.326433505kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3543543.430k8522rmdzg4k   select privilege# from sysauth...
35410,2583.43cm5vu20fhtnq1   select /*+ connect_by_filterin...
2065412.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1981981.9247a50dvdgnxc2   update sys.job$ set failures=0...
1981981.92aq8yqxyyb40nn   update sys.job$ set this_date=...
1981981.92cumjq42201t37   select u1.user#, u2.user#, u3....
1821831.7608vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
1819,5051.758t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
1805,7691.74089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1795361.7324dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
1791791.732mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
1791791.7334rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1791791.7339c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
1791791.737vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
1797201.73bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
1791791.73btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
1793581.73c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
1791791.73dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
1581581.530ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
1581581.53459f3z9u4fb3u   select value$ from props$ wher...
1561561.514vs91dcv7u1p6 emagent@xjdssa (TNS V1-V3) insert into sys.aud$( sessioni...
1561561.515ur69atw3vfhj   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
33,566,681360.49a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
30,931,618230.457d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
30,566,719720.455fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
29,329,089360.439juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
25,433,998360.377wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
24,542,74680.369dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
19,950,693360.296k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
17,828,081360.26b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
17,614,985360.26cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
15,584,346360.2305xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
15,213,624400.22bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
13,377,4001850.204jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
9,018,00330.13gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
6,028,08510.091cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
5,639,9183870.08fsbqktj5vw6n9   select next_run_date, obj#, ru...
4,901,64010.074cwh3y70p6fdb Oracle Enterprise Manager.Metric Engine select a.tablespace_name, a.me...
4,547,0761790.072mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
4,066,0311980.06cumjq42201t37   select u1.user#, u2.user#, u3....
3,704,9861790.057vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
3,510,08230.0566gs90fyynks7   insert into wrh$_instance_reco...
3,374,009360.059juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
3,303,309120.0574fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
3,196,2231,0760.053mzmha5pxaf9j OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
3,138,2171790.0539c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2,966,245180.04f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
2,905,7261760.04dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
2,904,1221790.04415urv6x9mf8w OEM.CacheModeWaitPool SELECT /*+ RULE */ STEP_ID FRO...
2,785,5502,1460.045ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,646,33880.049dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2,642,051150.0400prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
2,531,8513590.04d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
2,529,5821760.046r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
2,513,9901980.0447a50dvdgnxc2   update sys.job$ set failures=0...
2,511,480180.04fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
2,493,0311940.043x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
2,482,1621790.049q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
2,270,354300.030njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
2,154,740180.0385snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
2,153,416430.037av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
2,111,770180.037hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
2,111,593180.03frky6qxh68bk7   SELECT NVL(TO_NUMBER(VALUE), 0...
2,110,391730.039ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
2,110,2931790.03b0d86bn8ncths OEM.SystemPool SELECT STEP_ID FROM MGMT_JOB_E...
2,108,830240.034nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
2,108,6031790.03ab5btgh76akb6 OEM.CacheModeWaitPool delete from "SYSMAN"."MGMT_JO...
2,042,39730.0384k66tf2s7y1c   insert into wrh$_bg_event_summ...
1,728,6621790.037mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
1,718,6381980.03aq8yqxyyb40nn   update sys.job$ set this_date=...
1,688,37820.02bunssq950snhf   insert into wrh$_sga_target_ad...
1,616,384180.025uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
1,332,8991790.0234rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1,318,977180.02auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
1,317,93130.02gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
1,257,01130.02gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
100437av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
1001885snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
100369juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
100369juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
10018f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
991792mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
9917934rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
9919847a50dvdgnxc2   update sys.job$ set failures=0...
991854jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
991766r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
991797mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
99198aq8yqxyyb40nn   update sys.job$ set this_date=...
99359d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
981,0763mzmha5pxaf9j OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
981,0763mzmha5pxaf9j OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
981943x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
98179415urv6x9mf8w OEM.CacheModeWaitPool SELECT /*+ RULE */ STEP_ID FRO...
98244nw0ag3rg25h1 OEM.SystemPool INSERT INTO mgmt_db_hdm_metric...
981274fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
98237d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
98187hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
981797vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
98739ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
98179ab5btgh76akb6 OEM.CacheModeWaitPool delete from "SYSMAN"."MGMT_JO...
9818auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
98179b0d86bn8ncths OEM.SystemPool SELECT STEP_ID FROM MGMT_JOB_E...
98198cumjq42201t37   select u1.user#, u2.user#, u3....
9836cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
98176dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
9818frky6qxh68bk7   SELECT NVL(TO_NUMBER(VALUE), 0...
98387fsbqktj5vw6n9   select next_run_date, obj#, ru...
9818fsn35zyxmf1uy   SELECT WHAT, NEXT_DATE NEXT_TI...
971799q910gyqj6w95 OEM.CacheModeWaitPool DELETE FROM MGMT_JOB_HISTORY W...
9736a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
9736b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
96367wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
95725fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
9589dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
9589dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
942,1465ms6rbzdnq16t   select job, nvl2(last_date, 1,...
94366k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
933605xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
9317939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
9340bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
891500prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
89300njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
7532,6218vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
7532,6218vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
663gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
63185uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
54384k66tf2s7y1c   insert into wrh$_bg_event_summ...
53366gs90fyynks7   insert into wrh$_instance_reco...
502bunssq950snhf   insert into wrh$_sga_target_ad...
4911cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
302,499fcg2mzztpyraq OEM.SystemPool UPDATE MGMT_METRICS_RAW SET VA...
271564vs91dcv7u1p6 emagent@xjdssa (TNS V1-V3) insert into sys.aud$( sessioni...
2414cwh3y70p6fdb Oracle Enterprise Manager.Metric Engine select a.tablespace_name, a.me...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00prz3j9n4gyjSELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')
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))
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)
24dkx03u3rj6kSELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
24g90qj2b7ywkBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END;
2b064ybzkwf1yBEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2mysbczfp729xSELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL
34rks4d5suuxzSELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60)
350myuyx0t1d6 insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
39c8q6w3s3r8yUPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2)
3am9cfkvx7gq1CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3mzmha5pxaf9jSELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM ( SELECT :B3 JOB_ID, :B3 EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE = :B2 AND STEP_STATUS != :B1 UNION SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, STEP_STATUS, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 ) AND COMMAND_TYPE = :B5 AND START_TIME <= :B4 ) WHERE ROWNUM <= :B8
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
415urv6x9mf8wSELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 ) AND STEP_TYPE=:B2 AND J.EXECUTION_TIMEOUT > 0 AND (:B1 -E.START_TIME) > (J.EXECUTION_TIMEOUT/24)
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
4cwh3y70p6fdb select a.tablespace_name, a.meg, a.maxmeg, a.file_name, a.file_id, a.ts#, a.blocksize, a.flag, b.freebytes, b.maxfreebytes, nvl(c.ts#, -99) from (select f.tablespace_name, (f.bytes)/1048576 meg, (f.maxbytes)/1048576 maxmeg, f.file_name, f.file_id, ts.ts#, ts.blocksize, DECODE(BITAND(ts.flags, 3), 1, ts.dflminlen, 0) flag from sys.ts$ ts, sys.dba_data_files f where ts.contents$ = 0 and ts.online$ = 1 AND ( ts.bitmapped = 0 OR (ts.bitmapped != 0 AND bitand(ts.flags, 3) = 0)) AND bitand(flags, 2048) != 2048 and f.tablespace_name = ts.name) a, (SELECT ts.name tablespace_name, SUM(e.length * ts.blocksize/1048576) freebytes, MAX(e.length * ts.blocksize/1024) maxfreebytes FROM sys.fet$ e, sys.ts$ ts WHERE ts.ts# = e.ts# GROUP BY ts.name UNION ALL SELECT ts.name tablespace_name, SUM(e.blocks * ts.blocksize/1048576) freebytes, MAX(e.blocks * ts.blocksize/1024) maxfreebytes FROM sys.dba_lmt_free_space e, sys.ts$ ts WHERE ts.ts# = e.tablespace_id GROUP BY ts.name) b, (select d istinct s.ts# from sys.seg$ s where s.maxexts < 2100000000 and s.maxexts - extents < 2 and exists (select 1 from sys.sys_objects so where so.header_block = s.block# and s.file# = so.header_file and s.ts# = so.ts_number)) c where a.tablespace_name = b.tablespace_name and a.ts# = c.ts#(+) order by a.tablespace_name, a.file_name
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
4nw0ag3rg25h1INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE, TASK_COUNT) VALUES ( :1, :2, :3, :4)
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
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
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
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
6k5agh28pr3wpselect propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6r95ktyt1vgmgSELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE
6v7n0y2bq89n8BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;
74fnxs1kfd150DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 )
772s25v1y0x8kselect shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7av8js40455qbSELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B2 AND TARGET_TYPE = :B1
7d92gmwphtza8SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP'
7hskd14849h8kSELECT GREATEST(0, NVL(TRUNC(TO_NUMBER(VALUE)/60, 2), 0)) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderOldestFile' AND HOST_URL = :B1
7mdacxfm37utkSELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND')
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
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
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||'%'
ab5btgh76akb6 delete from "SYSMAN"."MGMT_JOB_STEP_TARGETS" where "STEP_ID" = :1
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
bryu1pu7rnk2s SELECT REPLACE(REPLACE(ddf.file_name, chr(10), ''), chr(13), '') "file_name", ddf.online_status "status", ddf.tablespace_name "tablespace_name", NVL(ddf.bytes, 0) "bytes", ddf.autoextensible "autoextensible", ddf.increment_by "increment_by", ddf.maxbytes "max_bytes" FROM sys.dba_data_files ddf
btwkwwx56w4z6SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cn58bhkggqvj4 /* OracleOEM */ SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(ts.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(ts.bytes - NVL(f.bytes, 0), 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) ts, (SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f WHERE dtp.tablespace_name = ts.tablespace_name (+) AND dtp.tablespace_name = f.tablespace_ name (+) AND NOT (dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY') UNION ALL SELECT dtp.tablespace_name "TABLESPACE_NAME", dtp.status "STATUS", dtp.contents "CONTENTS", dtp.extent_management "EXTENT MANAGEMENT", dtp.allocation_type "ALLOCATION TYPE", dtp.logging "LOGGING", NVL(a.bytes, 0) "SIZE (M)", dtp.initial_extent "INITIAL EXT SIZE (K)", dtp.next_extent "Next Extent", dtp.pct_increase "INCREMENT PCT", dtp.max_extents "MAX EXTENTS", NVL(t.bytes, 0) "USED BYTES", dtp.min_extents, dtp.min_extlen, dtp.segment_space_management "SEGMENT SPACE MANAGEMENT", dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.ta blespace_name = ts.name group by ss.tablespace_name) t WHERE dtp.tablespace_name = a.tablespace_name (+) AND dtp.tablespace_name = t.tablespace_name (+) AND dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY'
cumjq42201t37select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cxjqbfn0d3yqqSELECT COUNT(*) FROM SYS.DBA_PROPAGATION
cydnuss99swtdBEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
d27r7zhtnfgp4SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();'
dkk8923ygggj7UPDATE MGMT_EMD_PING SET LAST_HEARTBEAT_TS = :B6 , LAST_HEARTBEAT_UTC = CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE), CLEAN_HEARTBEAT_UTC = :B5 , STATUS_SYNC_UTC = :B4 , EMD_UPTIME_UTC = :B3 , HEARTBEAT_RECORDER_URL = SUBSTR(:B1 , 0, 256), UNRCH_START_TS = NULL WHERE TARGET_GUID = :B2
dwssdqx28tzf5select sysdate + 1 / (24 * 60) from dual
f4fcb8ngpf080SELECT HOST_URL, MODULE, NVL(SUM(VALUE), 0) HR_THROUGHPUT, NVL(SUM(DURATION/1000.0), 0) RUNTIME, NVL((SUM(VALUE)*1000.0), 0)/ DECODE(NVL(SUM(DURATION), 0), 0, 1, SUM(DURATION)) SEC_THROUGHPUT FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = :B3 AND MODULE LIKE :B2 ||'%' AND NAME = :B1 AND IS_TOTAL = 'Y' AND DURATION > 0 AND TIME > (SYSDATE - (1/24)) GROUP BY HOST_URL, MODULE
fcg2mzztpyraqUPDATE MGMT_METRICS_RAW SET VALUE= :1 WHERE METRIC_GUID= HEXTORAW(:2) AND COLLECTION_TIMESTAMP= :3 AND KEY_VALUE= NVL(:4, ' ') AND TARGET_GUID= HEXTORAW(:5)
fjvwzpxbpch0h /* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
frky6qxh68bk7SELECT NVL(TO_NUMBER(VALUE), 0) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderFileCount' AND HOST_URL = :B1
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ( (bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
fsn35zyxmf1uySELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%'
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

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 referenced50.000.00
CCursor + sql area evicted00.000.00
CPU used by this session79,712,535,715,5857,397,584,230.1629,610,897,368.35
CPU used when call started73,978,739,375,9956,865,469,161.9427,480,958,163.45
CR blocks created5860.050.22
Cached Commit SCN referenced00.000.00
Commit SCN cached10.000.00
DB time3,308,907307.081,229.16
DBWR checkpoint buffers written35,8103.3213.30
DBWR checkpoints00.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes2520.020.09
DBWR undo block writes3,3230.311.23
Effective IO time00.000.00
HSC Heap Segment Block Changes8,6590.803.22
Heap Segment Array Inserts3430.030.13
Heap Segment Array Updates4940.050.18
IMU CR rollbacks6960.060.26
IMU Flushes3,3100.311.23
IMU Redo allocation size9,930,328921.573,688.83
IMU commits2,0610.190.77
IMU contention20.000.00
IMU ktichg flush00.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size18,422,2321,709.646,843.33
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping10.000.00
Number of read IOs issued00.000.00
Requests to/from client26,6432.479.90
RowCR - row contention00.000.00
RowCR attempts16,5361.536.14
RowCR hits16,5401.536.14
SMON posted for dropping temp segment00.000.00
SQL*Net roundtrips to/from client26,6432.479.90
active txn count during cleanout1440.010.05
application wait time460.000.02
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts66,9536.2124.87
branch node splits00.000.00
buffer is not pinned count256,00023.7695.10
buffer is pinned count101,1759.3937.58
bytes received via SQL*Net from client12,413,6691,152.034,611.32
bytes sent via SQL*Net to client3,770,760349.941,400.73
calls to get snapshot scn: kcmgss128,59311.9347.77
calls to kcmgas5,0880.471.89
calls to kcmgcs12,5321.164.66
cell physical IO interconnect bytes793,727,48873,660.51294,846.76
change write time1910.020.07
cleanout - number of ktugct calls1620.020.06
cleanouts and rollbacks - consistent read gets30.000.00
cleanouts only - consistent read gets110.000.00
cluster key scan block gets11,4471.064.25
cluster key scans10,7110.993.98
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed270.000.01
commit batch/immediate requested270.000.01
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure90.000.00
commit cleanout failures: cannot pin20.000.00
commit cleanouts45,2934.2016.83
commit cleanouts successfully completed45,2824.2016.82
commit immediate performed270.000.01
commit immediate requested270.000.01
commit txn count during cleanout810.010.03
concurrency wait time4,7680.441.77
consistent changes8460.080.31
consistent gets372,14634.54138.24
consistent gets - examination145,78413.5354.15
consistent gets direct10.000.00
consistent gets from cache372,14534.54138.24
consistent gets from cache (fastpath)150,88914.0056.05
cursor authentications460.000.02
data blocks consistent reads - undo records applied8210.080.30
db block changes344,24031.95127.88
db block gets325,83730.24121.04
db block gets direct100.000.00
db block gets from cache325,82730.24121.04
db block gets from cache (fastpath)98,1999.1136.48
deferred (CURRENT) block cleanout applications20,1861.877.50
enqueue conversions2,1740.200.81
enqueue releases129,67912.0348.17
enqueue requests129,67912.0348.17
enqueue timeouts00.000.00
enqueue waits10.000.00
execute count115,94710.7643.07
failed probes on index block reclamation30.000.00
file io service time00.000.00
file io wait time8,117,390753.323,015.38
free buffer inspected00.000.00
free buffer requested11,9611.114.44
heap block compress1140.010.04
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications140.000.01
immediate (CURRENT) block cleanout applications20,9601.957.79
in call idle wait time36,120,0693,352.0613,417.56
index crx upgrade (positioned)16,5251.536.14
index crx upgrade (prefetch)100.000.00
index fast full scans (full)280.000.01
index fetch by key94,8818.8135.25
index scans kdiixs174,7016.9327.75
leaf node 90-10 splits500.000.02
leaf node splits730.010.03
lob reads00.000.00
lob writes20.000.00
lob writes unaligned20.000.00
logical read bytes from cache5,717,786,624530,629.312,123,992.06
logons cumulative7630.070.28
max cf enq hold time00.000.00
messages received9,4060.873.49
messages sent9,4060.873.49
min active SCN optimization applied on CR00.000.00
no work - consistent read gets156,41714.5258.10
non-idle wait count87,0428.0832.33
non-idle wait time8,6790.813.22
opened cursors cumulative100,2989.3137.26
parse count (describe)00.000.00
parse count (failures)240.000.01
parse count (hard)810.010.03
parse count (total)10,3220.963.83
parse time cpu18,551,425,258,2611,721,632,986.656,891,316,960.72
parse time elapsed1270.010.05
physical read IO requests50.000.00
physical read bytes40,9603.8015.22
physical read total IO requests18,7541.746.97
physical read total bytes301,604,86427,989.92112,037.47
physical read total multi block requests00.000.00
physical reads50.000.00
physical reads cache40.000.00
physical reads cache prefetch00.000.00
physical reads direct10.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical write IO requests5,7980.542.15
physical write bytes293,437,44027,231.95109,003.51
physical write total IO requests18,2951.706.80
physical write total bytes492,122,62445,670.59182,809.30
physical write total multi block requests1,4340.130.53
physical writes35,8203.3213.31
physical writes direct100.000.00
physical writes direct (lob)70.000.00
physical writes direct temporary tablespace30.000.00
physical writes from cache35,8103.3213.30
physical writes non checkpoint3,2050.301.19
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 calls347,88532.28129.23
recursive cpu usage100,228,620,952,3849,301,544,093.5637,232,028,585.58
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)20,2331.887.52
redo blocks written105,1779.7639.07
redo buffer allocation retries00.000.00
redo entries158,63014.7258.93
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks1770.020.07
redo size51,213,4404,752.7719,024.31
redo size for direct writes57,5965.3521.40
redo subscn max counts12,7601.184.74
redo synch long waits30.000.00
redo synch time1530.010.06
redo synch time (usec)1,709,883158.68635.17
redo synch writes1,4510.130.54
redo wastage1,063,83698.73395.18
redo write time4020.040.15
redo writes3,6300.341.35
rollback changes - undo records applied8150.080.30
rollbacks only - consistent read gets5820.050.22
root node splits00.000.00
rows fetched via callback22,9512.138.53
session connect time00.000.00
session cursor cache hits27,4422.5510.19
session logical reads697,98364.78259.28
shared hash latch upgrades - no wait57,7335.3621.45
shared hash latch upgrades - wait80.000.00
sorts (memory)32,6753.0312.14
sorts (rows)85,8147.9631.88
sql area evicted140.000.01
sql area purged240.000.01
switch current to new buffer8,4810.793.15
table fetch by rowid72,6126.7426.97
table fetch continued row1830.020.07
table scan blocks gotten48,4304.4917.99
table scan rows gotten2,546,814236.35946.07
table scans (long tables)00.000.00
table scans (short tables)7,4460.692.77
temp space allocated (bytes)00.000.00
total cf enq hold time1,6430.150.61
total number of cf enq holders2220.020.08
total number of times SMON posted100.000.00
transaction rollbacks270.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size21,315,5401,978.157,918.11
user I/O wait time6430.060.24
user calls31,3822.9111.66
user commits2,6650.250.99
user rollbacks270.000.01
workarea executions - onepass00.000.00
workarea executions - optimal12,0201.124.47
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 current4644
session uga memory max218,858,848,104219,436,357,680
session pga memory199,566,522,096200,094,640,920
session pga memory max216,483,150,224217,023,131,064
session cursor cache count3,994,9214,005,783
session uga memory324,413,372,803,144325,285,289,961,984
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)
Others288M1.74.026727139M0.82.01289923.2K0.54
DBWR0M0.000M278M0.54.0257990 
LGWR0M0.000M57M0.34.00528936760.56
Buffer Cache Reads0M0.000M0M0.000M42.50
Direct Writes0M0.000M0M0.000M0 
TOTAL:288M1.74.026727474M1.70.04398826.9K0.55

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 File283M1.68.026263138M0.82.0128060.22 
Data File14M0.06.001299280M0.54.0259847.99 
Log File0M0.000M57M0.34.005289  
Temp File0M0.000M0M0.000M0.33 
TOTAL:297M1.74.027562475M1.70.0440810.50 

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 287M1.74.026634139M0.82.01289918.8K0.50
Others (Control File) 282M1.68.026170139M0.82.01289918.1K0.22
Others (Data File) 5M0.06.0004640M0.000M6877.99
DBWR 0M0.000M278M0.54.0257990 
DBWR (Data File) 0M0.000M278M0.54.0257990 
LGWR 0M0.000M57M0.34.0052890 
LGWR (Log File) 0M0.000M57M0.34.0052890 
Buffer Cache Reads 0M0.000M0M0.000M42.50
Buffer Cache Reads (Data File) 0M0.000M0M0.000M42.50
Direct Writes 0M0.000M0M0.000M0 
Direct Writes (Data File) 0M0.000M0M0.000M0 
TOTAL: 287M1.74.026634474M1.70.04398818.8K0.50

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 2010.001.004,925010.00
UNDOTBS1 000.000.00686000.00
SYSTEM 000.000.00183010.00
TEMP 303.331.003000.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 2010.001.004,925010.00
SYSTEM+DATA/xjdss/system01.dbf 00  183010.00
TEMP+DATA/xjdss/temp01.dbf 303.331.00300 
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  275000.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  44000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  253000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  57000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  57000.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,302,752100698,032435,810002

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000035,8100

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
B023535612465268102548033226810   
E0232651515126372548033212637   

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.002981198.00
D8,4480.201,0421.002971197.00
D12,6720.291,5621.002971197.00
D16,8960.392,0831.002971197.00
D21,1200.492,6041.002971197.00
D25,3440.593,1251.002971197.00
D29,5680.693,6461.002971197.00
D33,7920.794,1661.002971197.00
D38,0160.884,6871.002971197.00
D42,2400.985,2081.002971197.00
D43,0081.005,3031.002971197.00
D46,4641.085,7291.002971197.00
D50,6881.186,2501.002971197.00
D54,9121.286,7701.002971197.00
D59,1361.387,2911.002971197.00
D63,3601.477,8121.002971197.00
D67,5841.578,3331.002971197.00
D71,8081.678,8541.002971197.00
D76,0321.779,3751.002971197.00
D80,2561.879,8951.002971197.00
D84,4801.9610,4161.002971197.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,623385.170.000.000.000.001,048,576
E14,33612,625381.760.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
2K4K11,83211,83200
64K128K181800
256K512K6600
512K1024K12912900
1M2M303000
4M8M2200
8M16M3300

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1,7920.13123,690.485.89100.00133,329,256
3,5840.25123,690.485.89100.00133,329,256
7,1680.50123,690.485.89100.00033,329,256
10,7520.75123,690.485.89100.00033,329,256
14,3361.00123,690.485.89100.00033,329,256
17,2031.20123,690.480.00100.00033,327,668
20,0701.40123,690.480.00100.00033,327,668
22,9381.60123,690.480.00100.00033,327,668
25,8051.80123,690.480.00100.00033,327,668
28,6722.00123,690.480.00100.00033,327,668
43,0083.00123,690.480.00100.00033,327,668
57,3444.00123,690.480.00100.00033,327,668
86,0166.00123,690.480.00100.00033,327,668
114,6888.00123,690.480.00100.00033,327,668

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)
4,2240.653369,9811,234,0740.9747,44913.3261,700
4,9920.761,10429,0861,252,7880.9828,7358.0662,787
5,2480.801,36034,9691,258,9820.9922,5416.3363,162
5,3760.821,48838,3431,261,9910.9919,5325.4863,343
5,5040.841,61641,7171,265,0850.9916,4384.6163,547
5,6320.861,74445,0911,267,9050.9913,6183.8263,734
5,7600.881,87248,0581,270,2860.9911,2373.1563,884
5,8880.902,00052,0301,272,4981.009,0252.5364,035
6,0160.922,12856,0021,274,5421.006,9811.9664,168
6,1440.942,25659,9471,276,5181.005,0051.4064,291
6,2720.962,38465,2481,277,4641.004,0591.1464,380
6,4000.982,51269,4031,277,9401.003,5831.0164,423
6,5281.002,64074,9031,277,9601.003,5631.0064,424
6,6561.022,76879,7101,277,9621.003,5611.0064,424
6,7841.042,89684,5271,277,9691.003,5541.0064,424
6,9121.063,02489,3441,277,9701.003,5531.0064,425
7,0401.083,15294,1611,277,9761.003,5471.0064,425
7,1681.103,28098,9781,277,9801.003,5430.9964,425
7,2961.123,408103,7951,277,9801.003,5430.9964,425
7,4241.143,536108,6121,277,9801.003,5430.9964,425
7,5521.163,562109,5921,277,9801.003,5430.9964,425
7,6801.183,562109,5921,277,9801.003,5430.9964,425
8,0641.243,562109,5921,277,9801.003,5430.9964,425
8,8321.353,562109,5921,277,9801.003,5430.9964,425
9,6001.473,562109,5921,277,9801.003,5430.9964,425
10,3681.593,562109,5921,277,9801.003,5430.9964,425
11,1361.713,562109,5921,277,9801.003,5430.9964,425
11,9041.823,562109,5921,277,9801.003,5430.9964,425
12,6721.943,562109,5921,277,9801.003,5430.9964,425
13,4402.063,562109,5921,277,9801.003,5430.9964,425

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.253,571,781,105,926297,837
19,2000.383,571,781,105,926297,095
25,6000.503,571,781,105,926296,976
32,0000.633,571,781,105,926296,976
38,4000.753,571,781,105,926296,976
44,8000.883,571,781,105,926296,976
51,2001.003,571,781,105,926296,976
57,6001.133,571,781,105,926296,976
64,0001.253,571,781,105,926296,976
70,4001.383,571,781,105,926296,976
76,8001.503,571,781,105,926296,976
83,2001.633,571,781,105,926296,976
89,6001.753,571,781,105,926296,976
96,0001.883,571,781,105,926296,976
102,4002.003,571,781,105,926296,976

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

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

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PR-Process Startup 40240201059.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
20.961,0521,0484657828.5/661200.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
26-Nov 14:581431634482659,6870/00/0/0/0/0/0
26-Nov 14:48111371,0481661,1290/00/0/0/0/0/0
26-Nov 14:381411454431659,7900/00/0/0/0/0/0
26-Nov 14:281481751,0423659,7250/00/0/0/0/0/0
26-Nov 14:18152044381661,2010/00/0/0/0/0/0
26-Nov 14:084992281,0374657,8290/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch30.00 00 
AQ dequeue txn counter latch9,3340.00 00 
ASM Keyed state latch1,1220.00 00 
ASM allocation4220.00 00 
ASM db client latch7,1700.00 00 
ASM map operation freelist1360.00 00 
ASM map operation hash table74,2870.000.0000 
ASM network background latch4,5310.00 00 
ASM network state latch6170.00 00 
AWR Alerted Metric Element list115,9070.00 00 
Change Notification Hash table latch3,5830.00 00 
Consistent RBA3,6310.00 00 
DML lock allocation50,1700.00 00 
Event Group Locks1,3260.00 00 
FAL Queue2880.00 00 
FOB s.o list latch14,3750.00 00 
File State Object Pool Parent Latch30.00 00 
I/O Staticstics latch30.00 00 
IPC stats buffer allocation latch30.00 00 
In memory undo latch59,2540.001.0007,9560.00
JS Sh mem access230.00 00 
JS mem alloc latch170.00 00 
JS queue access latch200.00 00 
JS queue state obj latch77,9340.00 00 
JS slv state obj latch7170.00 00 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KFK SGA Libload latch20,8220.00 00 
KFMD SGA10.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list30.00 00 
KJCT flow control latch30.00 00 
KMG MMAN ready and startup request latch3,5910.00 00 
KTF sga latch570.00 03,0460.03
KWQMN job cache list latch10.00 00 
KWQP Prop Status40.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch2950.00 00 
Locator state objects pool parent latch30.00 00 
Lsod array latch7,5470.130.0000 
MQL Tracking Latch0  02140.00
Memory Management Latch30.00 03,5910.00
Memory Queue30.00 00 
Memory Queue Message Subscriber #130.00 00 
Memory Queue Message Subscriber #230.00 00 
Memory Queue Message Subscriber #330.00 00 
Memory Queue Message Subscriber #430.00 00 
Memory Queue Subscriber30.00 00 
MinActiveScn Latch1180.00 00 
Mutex30.00 00 
Mutex Stats30.00 00 
OS process4,2590.00 00 
OS process allocation24,1940.000.0000 
OS process: request allocation1,1220.090.0000 
PL/SQL warning settings2,5460.00 00 
PX hash array latch30.00 00 
QMT30.00 00 
Real-time plan statistics latch100,2340.00 00 
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA pool locks30.00 00 
SQL memory manager latch30.00 03,5800.00
SQL memory manager workarea list latch247,5560.00 00 
Shared B-Tree1,2430.00 00 
Streams Generic30.00 00 
Testing30.00 00 
Token Manager30.00 00 
WCR: sync30.00 00 
Write State Object Pool Parent Latch30.00 00 
X$KSFQP20.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
active checkpoint queue latch20,1530.050.0000 
active service list24,9090.001.00010,2440.00
archive control5520.00 00 
archive process latch8640.00 00 
begin backup scn array70.00 00 
buffer pool30.00 00 
business card30.00 00 
cache buffer handles7020.00 00 
cache buffers chains2,025,9760.000.06010,3400.00
cache buffers lru chain52,8190.000.00048,4290.01
call allocation3,7400.080.3300 
cas latch30.00 00 
change notification client cache latch30.00 00 
channel handle pool latch1,1710.090.0000 
channel operations parent latch81,0730.000.0000 
checkpoint queue latch2,462,7270.000.00030,6970.00
client/application info5,1230.00 00 
compile environment latch7630.00 00 
corrupted undo seg latch2,4720.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1710.00 00 
cvmap freelist lock30.00 00 
deferred cleanup latch1710.00 00 
dml lock allocation1710.00 00 
done queue latch30.00 00 
dummy allocation1,5310.00 00 
enqueue freelist latch30.00 0201,1420.00
enqueue hash chains261,5700.000.0000 
enqueues20.00 00 
fifth spare latch30.00 00 
file cache latch1,6590.00 00 
flashback copy30.00 00 
fourth Audit Vault latch30.00 00 
gc element30.00 00 
gcs commit scn state30.00 00 
gcs partitioned table hash30.00 00 
gcs pcm hashed value bucket hash30.00 00 
gcs resource freelist30.00 00 
gcs resource hash30.00 00 
gcs resource scan list30.00 00 
gcs shadows freelist30.00 00 
ges domain table30.00 00 
ges enqueue table freelist30.00 00 
ges group table30.00 00 
ges process hash list30.00 00 
ges process parent latch30.00 00 
ges resource hash list30.00 00 
ges resource scan list30.00 00 
ges resource table freelist30.00 00 
ges value block free list30.00 00 
global KZLD latch for mem in SGA1560.00 00 
global ctx hash table latch40.00 00 
global tx hash mapping30.00 00 
granule operation30.00 00 
hash table column usage latch2380.00 06,5210.00
hash table modification latch2070.00 00 
heartbeat check30.00 00 
intra txn parallel recovery30.00 00 
io pool granule metadata list30.00 00 
job workq parent latch2060.00 02034.43
job_queue_processes free list latch4180.00 00 
job_queue_processes parameter latch2,5380.00 00 
k2q lock allocation30.00 00 
kdlx hb parent latch30.00 00 
kgb parent30.00 00 
kgnfs mount latch30.00 00 
kokc descriptor allocation latch2,5540.00 00 
krbmrosl30.00 00 
ksfv messages30.00 00 
ksim group membership cache30.00 00 
kss move lock950.00 00 
ksuosstats global area1,0840.00 00 
ksv allocation latch3550.00 00 
ksv class latch2,1940.00 00 
ksv msg queue latch30.00 00 
ksz_so allocation latch1,1220.090.0000 
ktm global data1700.00 00 
kwqbsn:qsga5690.00 00 
lgwr LWN SCN5,9250.00 00 
list of block allocation3,8670.00 00 
loader state object freelist120.00 00 
lob segment dispenser latch30.00 00 
lob segment hash table latch390.00 00 
lob segment query latch30.00 00 
lock DBA buffer during media recovery30.00 00 
logical standby cache30.00 00 
logminer context allocation50.00 00 
logminer work area30.00 00 
longop free list parent30.00 00 
managed standby latch2880.00 00 
mapped buffers lru chain30.00 00 
message pool operations parent latch3750.00 00 
messages156,8110.010.0000 
mostly latch-free SCN6,1362.280.0000 
msg queue latch30.00 00 
multiblock read objects440.00 00 
name-service namespace bucket30.00 00 
ncodef allocation latch1710.00 00 
object queue header heap161,2580.00 0100.00
object queue header operation276,0770.010.0000 
object stats modification30.00 00 
parallel query alloc buffer2,8670.00 00 
parallel query stats30.00 00 
parameter list2220.00 00 
parameter table management5,7380.00 00 
peshm30.00 00 
pesom_free_list30.00 00 
pesom_hash_node30.00 00 
post/wait queue9,2510.220.0007,8690.09
process allocation1,5240.070.0005600.00
process group creation1,1220.00 00 
process queue30.00 00 
process queue reference30.00 00 
qmn task queue latch1,5670.00 00 
query server freelists30.00 00 
queued dump request360.00 00 
queuing load statistics30.00 00 
recovery domain hash list30.00 00 
redo allocation31,2090.020.000158,7440.01
redo copy30.00 0158,7530.11
redo writing38,6270.020.0000 
resmgr group change latch5600.00 00 
resmgr:active threads1,5300.00 00 
resmgr:actses change group4100.00 00 
resmgr:actses change state30.00 00 
resmgr:free threads list1,5280.070.0000 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method30.00 00 
resmgr:schema config820.00 00 
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects298,0740.000.0000 
rules engine rule set statistics2000.00 00 
second Audit Vault latch30.00 00 
second spare latch30.00 00 
sequence cache1,1140.00 00 
session allocation12,6450.00 011,2040.00
session idle bit73,2080.00 00 
session queue latch30.00 00 
session state list latch1,3420.00 00 
session switching7360.00 00 
session timer3,5900.00 00 
shared pool113,0130.010.00080.00
shared pool sim alloc70.00 00 
shared pool simulator1070.00 00 
sim partition latch30.00 00 
simulator hash latch35,0810.00 00 
simulator lru latch4,1950.00 030,5200.00
sort extent pool2980.00 00 
space background state object latch280.00 00 
space background task latch13,8150.780.0007,1940.00
state object free list40.00 00 
statistics aggregation1,6800.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
third spare latch30.00 00 
threshold alerts latch7910.00 00 
transaction allocation14,4520.00 00 
undo global data21,2150.001.0000 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains2,025,97648345
call allocation3,740312
In memory undo latch59,254110
active service list24,909110
undo global data21,215110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchkticmt: child010
active service listkswslogon: session logout011
cache buffers chainskcbgtcr: fast path030
cache buffers chainskcbgtcr: fast path (cr pin)020
cache buffers chainskcbgcur_2011
call allocationksuxds011
undo global datakturax010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 4130
Library Cachekglpndl1 9530
Library Cachekglpnal1 9020
Library Cachekglget2 210

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,8487.86
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX51,5047.38
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX17,3922.49
SYSSYSTEMI_SYSAUTH1 INDEX15,4242.21
SYSSYSTEMAUD$ TABLE6,0480.87

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 INDEX6,37517.80
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX3,4319.58
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1870.52
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX420.12
SYSSYSTEMAUD$ TABLE170.05

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX66611.49
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX3946.80
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX390.67
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX230.40
SYSSYSAUXSMON_SCN_TIME TABLE130.22

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 INDEX13.57
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX13.57

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX21,24840.92
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX19,48837.53
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX9,52018.34
SYSSYSTEMAUD$ TABLE8161.57
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX2240.43

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSMANSYSAUXMGMT_JOB_EXEC_IDX04 INDEX1100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1920.000 41
dc_files2,0580.000 0343
dc_global_oids12,1340.000 080
dc_histogram_data9510.000 011,299
dc_histogram_defs1,8720.110 05,811
dc_object_grants4370.000 070
dc_objects14,4300.010 154,277
dc_profiles5190.000 02
dc_rollback_segments8,7900.000 067
dc_segments4760.000 21971
dc_sequences20.000 211
dc_tablespaces6,8390.000 019
dc_users46,8340.000 0169
global database name7,5600.000 01
outstanding_alerts2700.000 015
sch_lj_oids150.000 097


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS3120.000 00
APP CONTEXT30.001470.0000
BODY3,2690.0022,7960.0000
CLUSTER30.0030.0000
DBLINK3200.000 00
EDITION3930.007520.0000
QUEUE1790.0030,6180.0000
SCHEMA3700.000 00
SQL AREA6,0800.12137,1650.133024
SQL AREA BUILD8117.280 00
SQL AREA STATS8162.968162.9600
SUBSCRIPTION230.00230.0000
TABLE/PROCEDURE7,4190.0140,5260.0120
TRIGGER2040.008620.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,008.0043,008.0043,008.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,528.006,528.006,144.006,528.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
BOther323.09 6.7310.5144444848
Freeable38.500.001.482.069 2626
PL/SQL22.483.440.491.8913134646
SQL1.130.130.050.060202317
EOther320.44 6.9710.6844444646
Freeable37.810.001.512.109 2525
PL/SQL22.463.430.511.9313134444
SQL1.070.130.050.050202217

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers45,097,156,608 
Fixed Size2,234,120 
Redo Buffers26,513,408 
Variable Size8,321,501,432 

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
sharedASM extent pointer array85.3785.370.00
sharedFileOpenBlock121.60121.600.00
sharedKGLH0732.28732.650.05
sharedKGLHD75.0375.070.06
sharedSQLA2,245.552,246.440.04
shareddb_block_hash_buckets356.00356.000.00
shareddbktb: trace buffer78.1378.130.00
sharedevent statistics per sess94.2694.260.00
sharedfree memory1,902.301,901.08-0.06
sharedksunfy : SSO free list87.8787.870.00
sharedprivate strands107.80107.800.00
streamsfree memory126.74126.740.00
 buffer_cache43,008.0043,008.000.00
 fixed_sga2.132.130.00
 log_buffer25.2925.290.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

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

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
10,7750.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.0010,7750.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_1_1200_1500.html