Enter value for report_name: awrrpt_0000_0100.html Using the report name awrrpt_0000_0100.html AWR Report for DB: XJDSS, Inst: xjdss, Snaps: 811-813

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:81122-Nov-13 00:00:5247 3.4
End Snap:81322-Nov-13 02:00:1646 3.4
Elapsed:  119.39 (mins)  
DB Time:  34,522,493,800.13 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 289,146,554.1 1,151,389,454.2 2.9E+07 1.2E+08
DB CPU(s): 289,146,554.1 1,151,389,454.1 2.9E+07 1.2E+08
Redo size: 5,268.5 20,979.2  
Logical reads: 63.9 254.2  
Block changes: 35.8 142.7  
Physical reads: 0.0 0.0  
Physical writes: 3.0 11.9  
User calls: 2.4 9.4  
Parses: 1.0 3.8  
Hard parses: 0.0 0.1  
W/A MB processed: 0.0 0.1  
Logons: 0.1 0.3  
Executes: 10.0 39.7  
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.68Soft Parse %: 97.83
Execute to Parse %: 90.40Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 7.43018787E+12% Non-Parse CPU: 94.19

Shared Pool Statistics

BeginEnd
Memory Usage %: 73.85 73.82
% SQL with executions>1: 98.24 99.31
% Memory for SQL w/exec>1: 91.16 96.03

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 2,071,349,627,978 100.00 
control file sequential read783110.00System I/O
log file sync823110.00Commit
ADR block file read72060.00Other
SQL*Net message to client13,773000.00Network

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

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

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
9.0E+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): 386.4 384.9
% Host Mem used for SGA+PGA: 62.97 62.97

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU2,071,349,627,978.40100.00
sql execute elapsed time33.750.00
PL/SQL execution elapsed time6.740.00
parse time elapsed1.860.00
hard parse elapsed time0.860.00
hard parse (sharing criteria) elapsed time0.840.00
connection management call elapsed time0.780.00
repeated bind elapsed time0.030.00
PL/SQL compilation elapsed time0.010.00
failed parse elapsed time0.010.00
DB time2,071,349,628,007.60 
background elapsed time216.08 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME3,849 
AVG_IDLE_TIME711,897 
AVG_IOWAIT_TIME25 
AVG_SYS_TIME1,289 
AVG_USER_TIME2,295 
BUSY_TIME131,994 
IDLE_TIME22,791,604 
IOWAIT_TIME2,200 
SYS_TIME49,230 
USER_TIME82,764 
LOAD00
OS_CPU_WAIT_TIME128,400 
RSRC_MGR_CPU_WAIT_TIME2 
VM_IN_BYTES8,192 
VM_OUT_BYTES927,526,912 
PHYSICAL_MEMORY_BYTES85,899,345,920 
NUM_CPUS32 
NUM_CPU_CORES32 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_DEFAULT16,384 
TCP_RECEIVE_SIZE_MAX9,223,372,036,854,775,807 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX9,223,372,036,854,775,807 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
22-Nov 00:00:520.31     
22-Nov 02:00:160.310.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  2,071,349,627,978 100.00
System I/O7830110.00
Commit8230110.00
Other970040.00
Network14,8650000.00
Application5100000.00
User I/O1470000.00
Concurrency50000.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 read7830110.440.00
log file sync8230110.460.00
ADR block file read720060.040.00
SQL*Net message to client13,7730007.660.00
SQL*Net break/reset to client5100000.280.00
Disk file operations I/O1430000.080.00
SQL*Net more data from client1,0920000.610.00
latch free30040.000.00
ADR block file write100000.010.00
direct path write temp20010.000.00
SQL*Net message from client13,773035,87826057.66 
jobq slave wait15,2651007,6204998.49 
wait for unread message on broadcast channel7,274987,1619844.04 
Streams AQ: waiting for messages in the queue1,4341007,16049930.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 startup2720321180.1514.89
control file sequential read8,5690614.762.81
db file parallel write3,6340512.022.14
log file sequential read37905120.212.13
control file parallel write2,8800411.601.69
db file sequential read3430390.191.41
log file parallel write2,4990211.391.05
ASM file metadata operation2,1650001.200.10
ADR block file read320050.020.07
resmgr:internal state change110001000.000.05
Disk file operations I/O4,5110002.510.03
log file sync40020.000.00
latch free40010.000.00
ADR block file write100000.010.00
rdbms ipc reply10050.000.00
db file async I/O submit3,6340002.020.00
LGWR wait for redo copy490000.030.00
asynch descriptor resize372100000.210.00
log file single write20010.000.00
rdbms ipc message46,88295143,294305626.06 
VKRM Idle1014,400143996520.00 
DIAG idle wait14,09210014,09210007.83 
Space Manager: slave idle wait2,0939910,35949491.16 
dispatcher timer1201007,200600010.07 
smon timer31747,1712313360.02 
shared server idle wait2391007,170300000.13 
Streams AQ: qmn coordinator idle wait512507,168140000.28 
Streams AQ: qmn slave idle wait25607,168280000.14 
ASM background timer1,44207,16649690.80 
wait for unread message on broadcast channel7,1641007,16410003.98 
class slave wait43907,164163180.24 
pmon timer2,3871007,16130001.33 
SQL*Net message from client4000110.22 
KSV master wait1320000.07 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read10432.74.81.037.522.11.9  
ADR block file write20100.0       
ADR file lock24100.0       
ARCH wait for archivelog lock1100.0       
ASM file metadata operation216599.9.0.0.0    
Disk file operations I/O465299.0.7.3.0    
LGWR wait for redo copy49100.0       
Log archive I/O1100.0       
SQL*Net break/reset to client510100.0       
SQL*Net message to client14.1K100.0       
SQL*Net more data from client1092100.0       
asynch descriptor resize371100.0       
buffer busy waits1100.0       
control file parallel write287592.92.41.0.91.6.7.4 
control file sequential read933397.1.7.4.8.8.1.2 
db file async I/O submit3632100.0       
db file parallel write363263.915.219.9.3.4.1.1 
db file sequential read345.6 1.449.945.82.3  
direct path write temp2100.0       
latch free728.642.914.3 14.3   
latch: call allocation1100.0       
latch: session allocation1100.0       
library cache: mutex X6100.0       
log file parallel write249891.02.32.92.21.2.2.2 
log file sequential read3791.8  4.784.26.32.9 
log file single write2100.0       
log file sync82588.03.45.51.71.1.2.1 
os thread startup272      100.0 
rdbms ipc reply1   100.0    
reliable message4100.0       
resmgr:internal state change1      100.0 
ASM background timer1442.4 .1 .1  99.4
DIAG idle wait14.1K      100.0 
KSV master wait13997.8.7.7.7    
SQL*Net message from client14.2K75.415.81.0.1.1.0.37.4
Space Manager: slave idle wait2094  .0.0.0 .499.5
Streams AQ: qmn coordinator idle wait51050.0      50.0
Streams AQ: qmn slave idle wait255       100.0
Streams AQ: waiting for messages in the queue1434    .1  99.9
VKRM Idle1       100.0
class slave wait43638.8.51.814.29.24.11.629.8
dispatcher timer119       100.0
jobq slave wait15.3K    .1 99.9 
pmon timer2387       100.0
rdbms ipc message46.9K.7.4.2.5.5.332.464.9
shared server idle wait239       100.0
smon timer32  3.1   3.193.8
wait for unread message on broadcast channel14.4K    .3.399.3 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
control file parallel write1299.6.3.1     
control file sequential read1699.8.1.1     
db file parallel write499.9.1.0     
log file parallel write599.8.2      
log file sequential read1197.1.82.1     
log file sync199.9.1      
os thread startup272  99.3.7    
resmgr:internal state change1  100.0     

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS2,077,496,069,6602,077,496,069,6440202
xjdss1400217
SYS$BACKGROUND00039
xjdssXDB0000

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 1470000045200
xjdss 005000103370
SYS$BACKGROUND 48543275320000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
15.632380.070.009514785887251.490.00aykvshm7zsabd   select size_for_estimate, size...
5.984650.010.0048118639929919.020.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
3.48100.350.001414222939239.520.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
3.102,8640.000.0078678195027850.060.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
3.0713.070.00600878916609.280.00bunssq950snhf   insert into wrh$_sga_target_ad...
3.0413.040.00404704971969.8997.60350myuyx0t1d6   insert into wrh$_tablespace_st...
2.6121.300.00707749694697.680.0066gs90fyynks7   insert into wrh$_instance_reco...
2.4821.240.00989682624652.160.004dy1xm4nxc0gf   insert into wrh$_system_event ...
2.3421.170.00788223009631.250.0084k66tf2s7y1c   insert into wrh$_bg_event_summ...
2.1421,7410.000.0059476933972913.210.038vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
3,674,290,757,374.2223915,373,601,495.29177.392.10175096798725822.410.002b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
2,876,535,182,128.964656,186,097,165.87138.875.9848118639929919.020.0081ky0n97v4zsg emagent_SQL_oracle_database /* OracleOEM */ select s.sid, ...
2,440,136,555,541.052,864852,002,987.27117.803.1078678195027850.060.006v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
1,487,440,483,438.922386,249,749,930.4271.8115.639514785887251.490.00aykvshm7zsabd   select size_for_estimate, size...
1,339,925,725,376.082385,629,940,022.5964.692.1362858558778641.070.00772s25v1y0x8k   select shared_pool_size_for_es...
1,272,313,918,007.0521,74158,521,407.3961.422.1459476933972913.210.038vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
1,014,163,288,610.611,611629,524,077.3548.961.3774061602073581.320.006amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
479,422,186,097.076,78170,700,809.0423.150.6475274326597122.290.00cm5vu20fhtnq1   select /*+ connect_by_filterin...
331,907,666,390.941103,017,342,421.7416.021.1329463958873110.500.133am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
307,322,416,899.342381,291,270,659.2414.840.4174473156457182.730.008p447s6p0rv6b   select java_pool_size_for_esti...
307,321,914,828.15642478,694,571.3814.840.3978665347947923.543.2718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
258,150,557,548.391192,169,332,416.3712.460.4458551216621657.670.00cydnuss99swtd OEM.SystemPool BEGIN EM_PING.RECORD_BATCH_HEA...
239,711,171,395.396,32437,904,992.3111.570.3764721207261663.610.008t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
239,711,115,454.621192,014,379,121.4711.570.4751402980131240.360.0024g90qj2b7ywk OEM.CacheModeWaitPool BEGIN EMDW_LOG.set_context(MGM...
190,539,620,256.551,426133,618,247.029.200.3456441299999865.720.005ms6rbzdnq16t   select job, nvl2(last_date, 1,...
184,393,187,186.61306,146,439,572.898.900.18101163748237037.820.00bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
178,246,696,989.78483,713,472,853.958.610.2572319541442918.640.005fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
159,807,516,221.56246,658,646,509.237.720.1793638679640439.410.009juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
153,661,068,362.83246,402,544,515.127.420.14106964601800713.790.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
153,661,002,112.302,14871,536,779.387.420.11137865725896353.040.005hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
147,514,625,091.89246,146,442,712.167.120.4433294352729841.970.00gwj1f651t001a emagent_SQL_oracle_database /* OracleOEM */ SELECT SEVERIT...
129,075,288,169.401191,084,666,287.146.230.05269637117546276.490.002dzhaf5as370g OEM.SystemPool SELECT PING.TARGET_GUID, TGT.T...
122,928,765,331.41582211,217,809.855.930.2158494332912094.990.005kyb5bvnu3s04   SELECT DISTINCT METRIC_GUID FR...
122,928,764,219.241191,033,014,825.375.930.2452073896376113.181.487vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
116,782,414,872.66167,298,900,929.545.640.08147441374230060.320.00934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
116,782,355,870.872,14854,367,949.665.640.11103962713650613.890.007qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
116,782,342,789.893,82830,507,404.075.640.1768911147113256.770.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
104,489,452,055.52231452,335,290.285.040.1571801225935928.360.000k8522rmdzg4k   select privilege# from sysauth...
104,489,439,935.46122856,470,819.145.040.1475070724441373.750.004jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
92,196,641,796.31156,146,442,786.424.450.05204078716595410.160.007d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
92,196,641,796.31156,146,442,786.424.450.06148388337404732.560.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
92,196,574,159.55119774,761,127.394.450.1181713543645299.030.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
86,050,128,181.57238361,555,160.434.150.0994066473011620.280.0043c5ykm1mcp2a OMS begin dbms_application_info.se...
86,050,108,119.52204,302,505,405.984.151.406134111112423.280.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
73,757,255,436.60131563,032,484.253.560.1070433498635971.660.00cumjq42201t37   select u1.user#, u2.user#, u3....
67,610,815,902.37118572,973,016.123.260.04156040563831083.800.000xqn4sx1ytghr   select /*+ first_rows(1) no_ex...
49,171,555,783.53104,917,155,578.352.373.481414222939239.520.005k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
49,171,543,672.1386,146,442,959.022.370.3613591071046740.110.00fcsu9qb17sk52 emagent_SQL_oracle_database /* OracleOEM */ DECLARE instan...
49,171,542,370.9186,146,442,796.362.370.3812901108345684.860.001qhza1uh1xcf9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE l_log_...
49,171,525,474.00357137,735,365.472.370.03151092445532191.120.0024dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
49,171,490,354.01104,917,149,035.402.370.578617279663873.830.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
49,171,490,354.00124,097,624,196.172.371.024841305148937.110.005uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
43,025,077,700.4067,170,846,283.402.080.3313183964681564.350.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
43,025,065,542.16131328,435,614.832.080.0852912898973296.5011.3247a50dvdgnxc2   update sys.job$ set failures=0...
36,878,636,451.05346106,585,654.481.780.0493560231501768.340.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
36,878,629,370.8348076,830,477.861.780.0575387128458940.690.00bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
36,878,621,321.48119309,904,380.851.780.0662925284217719.405.0739c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
30,732,195,123.61119258,253,740.531.480.0653926538671682.730.0034rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
30,732,186,610.6799310,426,127.381.480.0558251235093579.670.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
24,585,765,652.80241,024,406,902.201.190.1220313945957411.790.00cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
24,585,748,326.09131187,677,468.141.190.1023882179323224.432.63aq8yqxyyb40nn   update sys.job$ set this_date=...
24,585,745,245.74212,292,872,622.871.192.48989682624652.160.004dy1xm4nxc0gf   insert into wrh$_system_event ...
24,585,738,064.86102,458,573,806.491.190.723391248546828.910.00ayhsygk061114 Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(ROLL...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2.9612.9693.333.04404704971969.8997.60350myuyx0t1d6   insert into wrh$_tablespace_st...
0.016420.000.400.3978665347947923.543.2718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
0.011310.000.290.0852912898973296.5011.3247a50dvdgnxc2   update sys.job$ set failures=0...
0.0120.000.160.0358905867057980.9616.563wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
0.001190.000.110.2452073896376113.181.487vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
0.001190.000.090.0662925284217719.405.0739c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
0.001310.000.090.1023882179323224.432.63aq8yqxyyb40nn   update sys.job$ set this_date=...
0.001100.000.051.1329463958873110.500.133am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
0.0020.000.050.325806854430761.240.46gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
0.0021,7410.000.022.1459476933972913.210.038vwv6hx92ymmm   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
112,23121,7415.1624.542.145947608vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
107,6191010,761.9023.533.481414205k5v1ah25fb2c OEM.SystemPool BEGIN EMD_LOADER.UPDATE_CURREN...
67,4231,61141.8514.741.377406106amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
32,843201,642.157.181.406134100njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
22,9976,7813.395.030.64752740cm5vu20fhtnq1   select /*+ connect_by_filterin...
18,750121,562.504.101.024841305uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
17,216110156.513.761.1329463.13am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
15,30023964.023.352.101750902b064ybzkwf1y OEM.SystemPool BEGIN EMD_NOTIFICATION.QUEUE_R...
14,9612,8645.223.273.107867806v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
11,09225,546.002.430.3258068.5gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
9,30861,551.332.040.331318309dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
7,83623133.921.710.157180100k8522rmdzg4k   select privilege# from sysauth...
6,3246,3241.001.380.376472108t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
6,1006429.501.330.39786653.318naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
0100.000.000.578617279663873.830.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
0240.000.000.0234571366281025.870.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
01220.000.000.0432942641936970.100.6607c4n5uh9nk0r   select tab.rowid, tab.msgid, t...
03,8280.000.000.1768911147113256.770.00089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
03460.000.000.0493560231501768.340.0008bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
01190.000.000.1181713543645299.030.0008vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
02310.000.000.1571801225935928.360.000k8522rmdzg4k   select privilege# from sysauth...
0200.000.001.406134111112423.280.000njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
0990.000.000.0558251235093579.670.000ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
01180.000.000.04156040563831083.800.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
3573571357.000.0017850.00350myuyx0t1d6   insert into wrh$_tablespace_st...
112112167.000.005600.00934ur8r7tqbjx emagent_SQL_oracle_database SELECT DBID FROM V$DATABASE
9696244.000.004800.00fjvwzpxbpch0h emagent_SQL_oracle_database /* OracleOEM */ select capture...
8888811.000.004400.001qhza1uh1xcf9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE l_log_...
565687.000.002800.00fcsu9qb17sk52 emagent_SQL_oracle_database /* OracleOEM */ DECLARE instan...
464667.670.002300.009dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
4545153.000.002250.008b5vzx9k2t7s9 emagent_SQL_oracle_database /* OracleOEM */ DECLARE TYPE d...
44441100.400.002200.003am9cfkvx7gq1   CALL MGMT_ADMIN_DATA.EVALUATE_...
00100.00 0.0000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
00240.00 0.0005xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
21,74121,7411.002.145947608vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
6,7819,6301.420.64752740cm5vu20fhtnq1   select /*+ connect_by_filterin...
6,3246,3241.000.376472108t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
3,8283,8281.000.17689110089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
2,8642,8641.003.107867806v7n0y2bq89n8 OEM.SystemPool BEGIN EMDW_LOG.set_context(MGM...
2,14800.000.111378605hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
2,1482,1481.000.111039607qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,61122,20313.781.377406106amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,4261310.090.345644105ms6rbzdnq16t   select job, nvl2(last_date, 1,...
6426421.000.39786653.318naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2386423.4718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
2312313.370k8522rmdzg4k   select privilege# from sysauth...
2316,7813.37cm5vu20fhtnq1   select /*+ connect_by_filterin...
1313461.9108bqjmf8490s2 SEVERITY EVALUATION SELECT PARAMETER_VALUE FROM MG...
1311311.9147a50dvdgnxc2   update sys.job$ set failures=0...
1311311.91aq8yqxyyb40nn   update sys.job$ set this_date=...
1311311.91cumjq42201t37   select u1.user#, u2.user#, u3....
1202381.75c8h3jdwaa532q EM_PING SELECT TO_NUMBER(PARAMETER_VAL...
1193,8281.73089dbukv1aanh EM_PING SELECT SYS_EXTRACT_UTC(SYSTIME...
1191191.7308vznc16ycuag EM_PING SELECT SYS_GUID() FROM SYS.DUA...
1193571.7324dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARA...
1191191.732mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
1191191.7334rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1191191.7339c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
1191191.737vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
1196,3241.738t43xdhf4d9x2   SELECT CONTEXT_TYPE_ID, CONTEX...
1194801.73bfujkg8dw1aax   SELECT UPPER(PARAMETER_VALUE) ...
1191191.73btwkwwx56w4z6 SEVERITY EVALUATION SELECT target_guid FROM mgmt_m...
1191191.73dwssdqx28tzf5   select sysdate + 1 / (24 * 60)...
99991.440ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
99991.44459f3z9u4fb3u   select value$ from props$ wher...
99991.445ur69atw3vfhj   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
35,341,49520.543wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
29,760,321240.45a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
27,148,434150.417d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
27,027,735480.415fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
25,420,073240.399juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
23,049,910240.357wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
21,120,44260.329dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
17,616,405240.276k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
16,174,217240.25b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
15,638,057240.24cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
13,741,202240.2105xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
13,251,480300.20bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
11,890,6801220.184jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
9,077,445300.141tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
8,970,67060.14a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
7,993,29920.12gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
5,413,23710.081cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
4,609,4376420.0718naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
4,042,0601190.062mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
3,605,7751310.05cumjq42201t37   select u1.user#, u2.user#, u3....
3,595,22610.058p9z2ztb272bm   SELECT sx.instance_number, sx...
3,364,385240.059juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
3,327,2261190.057vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
3,321,37520.053wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
3,179,96220.0566gs90fyynks7   insert into wrh$_instance_reco...
3,000,10180.0574fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
2,801,0971190.0439c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
2,636,45060.049dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
2,610,013120.04f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
2,579,8461180.04dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
2,520,4231190.042dzhaf5as370g OEM.SystemPool SELECT PING.TARGET_GUID, TGT.T...
2,459,9021,4260.045ms6rbzdnq16t   select job, nvl2(last_date, 1,...
2,455,03520.04gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2,315,539100.0400prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
2,283,6941310.0347a50dvdgnxc2   update sys.job$ set failures=0...
2,278,5931220.035r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
2,250,7792390.03d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
2,222,7581180.036r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
2,211,0231220.033x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
2,043,810200.030njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
1,915,6941,6110.036amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
1,895,924120.0385snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
1,895,371100.03ayhsygk061114 Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(ROLL...
1,895,264260.037av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
1,874,474120.037hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
1,873,839330.033tuvgpf2dxsf8 OEM.BoundedPool SELECT LAST_HEARTBEAT_TS FROM ...
1,873,759330.039ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
1,853,47720.0384k66tf2s7y1c   insert into wrh$_bg_event_summ...
1,829,9282,1480.035hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
1,787,6422,1480.037qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
1,536,8621190.027mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
1,519,68210.02bunssq950snhf   insert into wrh$_sga_target_ad...
1,517,427120.028kzksw8m2rk68   SELECT NVL(VALUE, 'None') FROM...
1,509,0621310.02aq8yqxyyb40nn   update sys.job$ set this_date=...
1,462,736120.025uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
1,317,19520.02gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
1,171,6511190.0234rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
1,171,153120.02auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
9964218naypzfmabd6 EM_PING INSERT INTO MGMT_SYSTEM_PERFOR...
962gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
962gz4vfuvmxa42j emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_A...
9013147a50dvdgnxc2   update sys.job$ set failures=0...
9018p9z2ztb272bm   SELECT sx.instance_number, sx...
891225r8jah3jm5au2   SELECT TARGETS.TARGET_NAME, TA...
891,6116amygb1ygg2y7 OEM.SystemPool INSERT INTO MGMT_METRICS_RAW(C...
89874fnxs1kfd150 OEM.SystemPool DELETE FROM MGMT_BLACKOUT_WIND...
881192mysbczfp729x EM_PING SELECT /*+ INDEX(ping mgmt_emd...
881224jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
88267av8js40455qb OEM.BoundedPool SELECT TARGET_GUID FROM MGMT_T...
881197mdacxfm37utk OEM.CacheModeWaitPool SELECT COUNT(*) FROM MGMT_FAIL...
881197vcwzqf7mgk3b EM_PING INSERT INTO MGMT_JOB_EXECUTION...
881285snhhhd1qmt7   SELECT NVL(TO_NUMBER(SUM(VALUE...
88249juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
88249juw6s4yy5pzp emagent_SQL_oracle_database /* OracleOEM */ SELECT SUM(bro...
8824b2u9kspucpqwy emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
88239d27r7zhtnfgp4 OEM.SystemPool SELECT LAST_DATE, THIS_DATE FR...
8812f4fcb8ngpf080   SELECT HOST_URL, MODULE, NVL(S...
8711934rks4d5suuxz EM_PING SELECT COUNT(FAILOVER_ID) FROM...
87333tuvgpf2dxsf8 OEM.BoundedPool SELECT LAST_HEARTBEAT_TS FROM ...
871223x0kdm7z3yasw   SELECT TARGET_TYPE, TYPE_META_...
872,1485hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
872,1485hfunyv38vwfp OEM.SystemPool SELECT JOB_ID, EXECUTION_ID, S...
871186r95ktyt1vgmg OEM.BoundedPool SELECT CURRENT_STATUS FROM MGM...
87127hskd14849h8k   SELECT GREATEST(0, NVL(TRUNC(T...
87247wt7phk4xns75 emagent_SQL_oracle_database select a.capture_name streams_...
87128kzksw8m2rk68   SELECT NVL(VALUE, 'None') FROM...
87339ugwm6xmvw06u OEM.BoundedPool SELECT LAST_LOAD_TIME FROM MGM...
87131aq8yqxyyb40nn   update sys.job$ set this_date=...
8712auqc5yhb7ady2   SELECT DISTINCT HOST_URL FROM ...
87131cumjq42201t37   select u1.user#, u2.user#, u3....
8724cxjqbfn0d3yqq emagent_SQL_oracle_database SELECT COUNT(*) FROM SYS.DBA_P...
87118dkk8923ygggj7 OEM.SystemPool UPDATE MGMT_EMD_PING SET LAST_...
86157d92gmwphtza8 emagent_SQL_oracle_database SELECT OWNER, JOB_NAME, COMMEN...
8624a5pyncg7v0bw3 emagent_SQL_oracle_database /* OracleOEM */ SELECT PROPAGA...
85301tgukkrqj3zhw   SELECT OBJOID, CLSOID, (2*PRI ...
851192dzhaf5as370g OEM.SystemPool SELECT PING.TARGET_GUID, TGT.T...
84485fk0v8km2f811 perl@xjdssa (TNS V1-V3) select propagation_name, 'BUFF...
846a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
8311939c8q6w3s3r8y EM_PING UPDATE MGMT_EMD_PING_CHECK SET...
831,4265ms6rbzdnq16t   select job, nvl2(last_date, 1,...
83246k5agh28pr3wp perl@xjdssa (TNS V1-V3) select propagation_name stream...
832,1487qqnad1j615m7 OEM.SystemPool SELECT HOST_URL FROM MGMT_FAIL...
8369dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
8369dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
822405xcf43d9psvm emagent_SQL_oracle_database SELECT NVL(SUM(FAILURES), 0) F...
8130bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DECODE(...
80200njp59jttu2z9 Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_RAW WHERE ...
781000prz3j9n4gyj Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(COLL...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
662gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
6410ayhsygk061114 Oracle Enterprise Manager.rollup SELECT METRIC_GUID, TRUNC(ROLL...
6023wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
6023wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
6023wrrjm9qtr2my MMON_SLAVE SELECT T.CLIENT_ID, T.OPERATIO...
5821,7418vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
5821,7418vwv6hx92ymmm   UPDATE MGMT_CURRENT_METRICS SE...
57125uy533jsc8hyh Oracle Enterprise Manager.rollup DELETE MGMT_METRICS_1HOUR WHER...
49266gs90fyynks7   insert into wrh$_instance_reco...
49284k66tf2s7y1c   insert into wrh$_bg_event_summ...
451bunssq950snhf   insert into wrh$_sga_target_ad...
4411cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00prz3j9n4gyjSELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(COLLECTION_TIMESTAMP, 'HH24')
05xcf43d9psvmSELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
07c4n5uh9nk0rselect tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration , tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgid, tab.user_prop, tab.user_data from "SYSMAN"."MGMT_TASK_QTABLE" tab where tab.msgid = :1 and tab.state != 2 for update skip locked
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0njp59jttu2z9DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0xqn4sx1ytghrselect /*+ first_rows(1) no_expand */ tab.msgid from "SYSMAN"."AQ$_MGMT_TASK_QTABLE_F" tab where q_name = :1 and (state = :2 ) and queue_id = :3 and ( tab.user_data.scheduled_time <= CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) AND (tab.user_data.message_code = 0 OR tab.user_data.message_code = 1))
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1qhza1uh1xcf9 /* OracleOEM */ DECLARE l_log_mode VARCHAR2(32); l_flashback_on VARCHAR2(32); l_flash_recovery_area VARCHAR2(512); l_flash_recovery_size NUMBER; l_usable_area NUMBER; l_space_used NUMBER; l_reclaimable_area NUMBER; l_nonreclaimable_area NUMBER; l_oldest_flashback_time VARCHAR2(512); TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_102 CONSTANT VARCHAR2(10) := '10.2.0.0.0'; BEGIN -- Database version SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; -- Log Mode, Flashback On SELECT log_mode, flashback_on INTO l_log_mode, l_flashback_on FROM v$database; -- Flash Recovery Area/Size SELECT value INTO l_flash_recovery_area FROM v$parameter WHERE name='db_recovery_file_dest'; SELECT value INTO l_flash_recovery_size FROM v$parameter WHERE name='db_recovery_file_dest_size'; -- Usable Flash Recovery Area (10gR2) -- Reclaimable Flash Recovery Area (10gR2) -- Nonreclaimable Flash Recovery Area l_usable_area := NULL; l_recl aimable_area := NULL; l_nonreclaimable_area := NULL; l_space_used := NULL; IF (v_db_version >= db_version_102) THEN IF (length(l_flash_recovery_area) > 0) THEN EXECUTE IMMEDIATE 'SELECT (CASE WHEN PERCENT_USED> 100 THEN 0 ELSE (100-PERCENT_USED) END) PERCENT_FREE FROM (SELECT (SUM(PERCENT_SPACE_USED)-SUM(PERCENT_SPACE_RECLAIMABLE)) PERCENT_USED FROM V$FLASH_RECOVERY_AREA_USAGE)' INTO l_usable_area; EXECUTE IMMEDIATE 'SELECT SUM(PERCENT_SPACE_USED), SUM(PERCENT_SPACE_RECLAIMABLE) from v$flash_recovery_area_usage' INTO l_space_used, l_reclaimable_area; l_nonreclaimable_area := l_space_used - l_reclaimable_area; END IF; END IF; -- Oldest Flashback Time BEGIN SELECT to_char(oldest_flashback_time, 'YYYY-MM-DD HH24:MI:SS') INTO l_oldest_flashback_time FROM v$flashback_database_log; EXCEPTION WHEN OTHERS THEN l_oldest_flashback_time := ''; END; OPEN data_cursor FOR SELECT l_log_mode, l_flash_recovery_area, l_usable_area, l_reclaimable_area, l_nonreclaimable_area, l_flashback_o n, l_oldest_flashback_time, l_flash_recovery_size from dual; :1 := data_cursor; END;
1tgukkrqj3zhw SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND ((CLSOID IS NOT NULL AND INST_ID IS NULL AND CLSOID IN (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2, 3, 4 DESC
24dkx03u3rj6kSELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
24g90qj2b7ywkBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END;
2b064ybzkwf1yBEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2dzhaf5as370gSELECT PING.TARGET_GUID, TGT.TIMEZONE_REGION, PING.STATUS, PING.DOWN_REASON_MSG, PING.UNRCH_START_TS, PING.LAST_HEARTBEAT_TS FROM MGMT_TARGETS TGT, MGMT_EMD_PING PING WHERE TGT.TARGET_GUID = PING.TARGET_GUID AND TGT.TARGET_TYPE = :B2 AND TGT.EMD_URL = :B1 FOR UPDATE OF PING.TARGET_GUID
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)
3tuvgpf2dxsf8SELECT LAST_HEARTBEAT_TS FROM MGMT_EMD_PING P, MGMT_TARGETS T WHERE T.TARGET_GUID=P.TARGET_GUID AND T.TARGET_GUID=:B1
3wrrjm9qtr2my SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL (JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
3x0kdm7z3yaswSELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
43c5ykm1mcp2abegin dbms_application_info.set_module(:1, :2); dbms_application_info.set_client_info(:3); dbms_session.set_identifier(:4); end;
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4dy1xm4nxc0gfinsert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id
4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), M GMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
5fk0v8km2f811select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5hfunyv38vwfpSELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1
5k5v1ah25fb2cBEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END;
5kyb5bvnu3s04SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5ms6rbzdnq16tselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5r8jah3jm5au2SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5uy533jsc8hyhDELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1
66gs90fyynks7 insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery
6amygb1ygg2y7INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5)
6k5agh28pr3wpselect propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6r95ktyt1vgmgSELECT CURRENT_STATUS FROM MGMT_CURRENT_AVAILABILITY WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B1 ) ORDER BY TARGET_GUID FOR UPDATE
6v7n0y2bq89n8BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END;
74fnxs1kfd150DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 )
772s25v1y0x8kselect shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7av8js40455qbSELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B2 AND TARGET_TYPE = :B1
7d92gmwphtza8SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP'
7hskd14849h8kSELECT GREATEST(0, NVL(TRUNC(TO_NUMBER(VALUE)/60, 2), 0)) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderOldestFile' AND HOST_URL = :B1
7mdacxfm37utkSELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND')
7qqnad1j615m7SELECT HOST_URL FROM MGMT_FAILOVER_TABLE WHERE FAILOVER_ID = :B1
7vcwzqf7mgk3bINSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC')
7wt7phk4xns75select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
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;
8kzksw8m2rk68SELECT NVL(VALUE, 'None') FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderDirectory' AND HOST_URL = :B1
8p447s6p0rv6bselect java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice
8p9z2ztb272bm SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
8t43xdhf4d9x2SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 )
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 )
9ugwm6xmvw06uSELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1
a5mmhrrnpwjsc SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
a5pyncg7v0bw3/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
auqc5yhb7ady2SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS WHERE NAME='TIMESTAMP'
ayhsygk061114SELECT METRIC_GUID, TRUNC(ROLLUP_TIMESTAMP, 'DD'), KEY_VALUE, SUM(SAMPLE_COUNT), MIN(VALUE_MINIMUM), MAX(VALUE_MAXIMUM), SUM(SAMPLE_COUNT * VALUE_AVERAGE), SUM((POWER(VALUE_SDEV, 2) * (SAMPLE_COUNT-1)) + (SAMPLE_COUNT * POWER(VALUE_AVERAGE, 2))) FROM MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP >= (:B2 +1) AND ROLLUP_TIMESTAMP < (:B1 +1) GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(ROLLUP_TIMESTAMP, 'DD')
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b2u9kspucpqwySELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
bfujkg8dw1aaxSELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a .flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
btwkwwx56w4z6SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cxjqbfn0d3yqqSELECT COUNT(*) FROM SYS.DBA_PROPAGATION
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
fcsu9qb17sk52 /* OracleOEM */ DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SEL ECT parameter_value, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; -- open the cursor to return OPEN data_cursor FOR SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, NULL, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS') start_time, TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM dba_addm_findings f, (SELECT finding_id, count(r.rec_id) recCount, r.type FROM dba_advisor_recommendations r WHERE task_id=latest_task_id GRO UP BY r.finding_id, r.type) recInfo, (select count(f_all.task_id) finding_count, f_curr.finding_name FROM (select finding_name from dba_advisor_findings where task_id=latest_task_id) f_curr, (select t.task_id, i.local_task_id, t.end_time, t.begin_time from dba_addm_tasks t, dba_addm_instances i where t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=sys_context('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ) tasks, dba_advisor_findings f_all WHERE f_all.task_id=tasks.task_id AND f_all.finding_name=f_curr.finding_name AND f_all.type<>'INFORMATION' AND f_all.type<>'WARNING' AND f_all.parent=0 GROUP BY f_curr.finding_name) history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f.parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :2 := data_cursor; END;
fjvwzpxbpch0h /* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gwj1f651t001a/* OracleOEM */ SELECT SEVERITY_INDEX, CRITICAL_INICDENTS, WARNING_INCIDENTS from v$incmeter_summary
gz4vfuvmxa42jSELECT COUNT(*) FROM SYS.DBA_ADVISOR_TASKS WHERE OWNER = :B1 AND ROWNUM = 1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced30.000.00
CCursor + sql area evicted20.000.00
CPU used by this session39,694,162,903,1165,541,039,652.3322,064,570,818.85
CPU used when call started35,897,566,324,3005,011,060,162.9419,954,178,056.86
CR blocks created3830.050.21
Cached Commit SCN referenced00.000.00
Commit SCN cached10.000.00
DB time2,201,279307.281,223.61
DBWR checkpoint buffers written21,4392.9911.92
DBWR checkpoints10.000.00
DBWR object drop buffers written00.000.00
DBWR transaction table writes1630.020.09
DBWR undo block writes2,2500.311.25
Effective IO time00.000.00
HSC Heap Segment Block Changes4,8760.682.71
Heap Segment Array Inserts1790.020.10
Heap Segment Array Updates3170.040.18
IMU CR rollbacks4740.070.26
IMU Flushes2,3110.321.28
IMU Redo allocation size7,151,508998.303,975.27
IMU commits1,2310.170.68
IMU contention10.000.00
IMU ktichg flush00.000.00
IMU pool not allocated340.000.02
IMU recursive-transaction flush00.000.00
IMU undo allocation size12,289,9921,715.606,831.57
IMU- failed to get a private strand340.000.02
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
Requests to/from client13,7711.927.65
RowCR - row contention00.000.00
RowCR attempts10,2561.435.70
RowCR hits10,2561.435.70
SMON posted for dropping temp segment00.000.00
SQL*Net roundtrips to/from client13,7701.927.65
active txn count during cleanout810.010.05
application wait time80.000.00
background checkpoints completed00.000.00
background checkpoints started10.000.00
background timeouts44,5136.2124.74
branch node splits00.000.00
buffer is not pinned count155,06721.6586.20
buffer is pinned count77,13410.7742.88
bytes received via SQL*Net from client7,162,345999.823,981.29
bytes sent via SQL*Net to client2,027,589283.041,127.06
calls to get snapshot scn: kcmgss81,93811.4445.55
calls to kcmgas3,4330.481.91
calls to kcmgcs7,6411.074.25
cell physical IO interconnect bytes2,270,016,512316,879.121,261,821.30
change write time1420.020.08
cleanout - number of ktugct calls940.010.05
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets90.000.01
cluster key scan block gets5,4180.763.01
cluster key scans4,7940.672.66
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed170.000.01
commit batch/immediate requested170.000.01
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure50.000.00
commit cleanout failures: cannot pin00.000.00
commit cleanouts36,1635.0520.10
commit cleanouts successfully completed36,1585.0520.10
commit immediate performed170.000.01
commit immediate requested170.000.01
commit txn count during cleanout450.010.03
concurrency wait time3,2280.451.79
consistent changes5560.080.31
consistent gets243,27333.96135.23
consistent gets - examination81,49111.3845.30
consistent gets direct00.000.00
consistent gets from cache243,27333.96135.23
consistent gets from cache (fastpath)105,62214.7458.71
cursor authentications950.010.05
data blocks consistent reads - undo records applied5370.070.30
db block changes256,66235.83142.67
db block gets214,10129.89119.01
db block gets direct20.000.00
db block gets from cache214,09929.89119.01
db block gets from cache (fastpath)57,4348.0231.93
deferred (CURRENT) block cleanout applications14,3552.007.98
enqueue conversions1,4440.200.80
enqueue releases86,26912.0447.95
enqueue requests86,26912.0447.95
enqueue timeouts00.000.00
enqueue waits00.000.00
execute count71,4649.9839.72
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time4,938,414689.372,745.09
free buffer inspected00.000.00
free buffer requested11,7811.646.55
heap block compress580.010.03
hot buffers moved to head of LRU00.000.00
immediate (CR) block cleanout applications90.000.01
immediate (CURRENT) block cleanout applications18,9432.6410.53
in call idle wait time25,419,3313,548.3714,129.70
index crx upgrade (positioned)10,9881.536.11
index crx upgrade (prefetch)140.000.01
index fast full scans (full)300.000.02
index fetch by key53,6127.4829.80
index scans kdiixs149,3536.8927.43
leaf node 90-10 splits300.000.02
leaf node splits430.010.02
lob reads00.000.00
lob writes10.000.00
lob writes unaligned10.000.00
logical read bytes from cache3,746,791,424523,027.022,082,707.85
logons cumulative5070.070.28
max cf enq hold time00.000.00
messages received6,1470.863.42
messages sent6,1470.863.42
min active SCN optimization applied on CR00.000.00
no work - consistent read gets116,69516.2964.87
non-idle wait count47,4156.6226.36
non-idle wait time5,9340.833.30
opened cursors cumulative65,0679.0836.17
parse count (describe)00.000.00
parse count (failures)160.000.01
parse count (hard)1490.020.08
parse count (total)6,8590.963.81
parse time cpu12,036,904,357,1251,680,271,341.086,690,886,246.32
parse time elapsed1620.020.09
physical read IO requests20.000.00
physical read bytes16,3842.299.11
physical read total IO requests10,5451.475.86
physical read total bytes1,058,578,944147,770.54588,426.32
physical read total multi block requests8610.120.48
physical reads20.000.00
physical reads cache20.000.00
physical reads cache prefetch00.000.00
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical write IO requests3,6360.512.02
physical write bytes175,644,67224,518.8297,634.61
physical write total IO requests12,7571.787.09
physical write total bytes1,211,437,568169,108.58673,394.98
physical write total multi block requests1,7200.240.96
physical writes21,4412.9911.92
physical writes direct20.000.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace20.000.00
physical writes from cache21,4392.9911.92
physical writes non checkpoint2,1710.301.21
pinned buffers inspected00.000.00
process last non-idle time00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls216,89630.28120.56
recursive cpu usage65,657,256,224,9449,165,313,829.4936,496,529,307.92
redo KB read880,665122.93489.53
redo blocks checksummed by FG (exclusive)13,5811.907.55
redo blocks written77,69910.8543.19
redo buffer allocation retries00.000.00
redo entries121,17816.9267.36
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks1300.020.07
redo size37,741,6125,268.4820,979.22
redo size for direct writes00.000.00
redo subscn max counts9,6701.355.38
redo synch long waits00.000.00
redo synch time710.010.04
redo synch time (usec)820,733114.57456.22
redo synch writes9400.130.52
redo wastage710,75299.22395.08
redo write time2580.040.14
redo writes2,4970.351.39
rollback changes - undo records applied1320.020.07
rollbacks only - consistent read gets3820.050.21
root node splits00.000.00
rows fetched via callback11,6421.636.47
session connect time00.000.00
session logical reads457,37463.85254.24
shared hash latch upgrades - no wait37,5875.2520.89
shared hash latch upgrades - wait20.000.00
sorts (memory)21,8123.0412.12
sorts (rows)56,7927.9331.57
sql area evicted1360.020.08
sql area purged160.000.01
switch current to new buffer9,2541.295.14
table fetch by rowid42,8215.9823.80
table fetch continued row60.000.00
table scan blocks gotten29,7674.1616.55
table scan rows gotten1,562,000218.04868.26
table scans (long tables)00.000.00
table scans (short tables)4,9960.702.78
temp space allocated (bytes)00.000.00
total cf enq hold time1,2830.180.71
total number of cf enq holders1320.020.07
total number of times SMON posted80.000.00
transaction rollbacks170.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size15,898,8082,219.378,837.58
user I/O wait time3180.040.18
user calls16,8752.369.38
user commits1,7830.250.99
user rollbacks160.000.01
workarea executions - onepass00.000.00
workarea executions - optimal7,9891.124.44
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 current4746
session uga memory max197,137,409,712197,522,932,392
session pga memory179,909,735,496180,263,833,760
session pga memory max194,790,749,928195,153,433,408
session cursor cache count3,600,4823,607,594
session uga memory292,689,330,362,008293,273,471,636,704
opened cursors current158155

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)10.50

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)
Others1008M1.47.140710950M0.92.13261312.5K0.59
DBWR0M0.000M167M0.51.0233120 
LGWR0M0.000M38M0.35.00530425320.48
Buffer Cache Reads0M0.000M0M0.000M20.00
TOTAL:1008M1.47.1407101.1G1.78.16123015.1K0.57

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
Log File860M0.12.12005038M0.35.0053043.4321.81
Archive Log0M0.000M860M0.12.120050  
Control File147M1.30.02052090M0.80.0125630.2714.00
Data File14M0.05.001954167M0.51.0233128.17 
Temp File0M0.000M0M0.000M0.00 
TOTAL:1021M1.47.1425241.1G1.78.1612300.5521.80

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 1009M1.47.140849950M0.92.13261396600.55
Others (Archive Log) 0M0.000M860M0.12.1200500 
Others (Log File) 860M0.12.1200500M0.000M42.50
Others (Control File) 147M1.30.02052090M0.80.01256393130.27
Others (Data File) 2M0.05.0002790M0.000M3438.17
DBWR 0M0.000M167M0.51.0233120 
DBWR (Data File) 0M0.000M167M0.51.0233120 
LGWR 0M0.000M38M0.35.005304241.04
LGWR (Log File) 0M0.000M38M0.35.00530442.00
LGWR (Control File) 0M0.000M0M0.000M200.85
Buffer Cache Reads 0M0.000M0M0.000M20.00
Buffer Cache Reads (Data File) 0M0.000M0M0.000M20.00
TOTAL: 1009M1.47.1408491.1G1.78.16123096860.55

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX 000.000.003,044000.00
UNDOTBS1 000.000.00452010.00
SYSTEM 000.000.00138000.00
TEMP 200.001.002000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX+DATA/xjdss/sysaux01.dbf 00  3,044000.00
SYSTEM+DATA/xjdss/system01.dbf 00  138000.00
TEMP+DATA/xjdss/temp01.dbf 200.001.00200 
UNDOTBS1+DATA/xjdss/undotbs01.dbf 00  309010.00
UNDOTBS1+DATA/xjdss/undotbs02.dbf 00  58000.00
UNDOTBS1+DATA/xjdss/undotbs03.dbf 00  18000.00
UNDOTBS1+DATA/xjdss/undotbs04.dbf 00  32000.00
UNDOTBS1+DATA/xjdss/undotbs05.dbf 00  35000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D5,334,316100457,427221,439001

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

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

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
B027559916583281112548033228111   
E027644716146273772548033227377   

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.002911195.00
D8,4480.201,0421.002901195.00
D12,6720.291,5621.002901195.00
D16,8960.392,0831.002901195.00
D21,1200.492,6041.002901195.00
D25,3440.593,1251.002901195.00
D29,5680.683,6461.002901195.00
D33,7920.784,1661.002901195.00
D38,0160.884,6871.002901195.00
D42,2400.985,2081.002901195.00
D43,2641.005,3341.002901195.00
D46,4641.075,7291.002901195.00
D50,6881.176,2501.002901195.00
D54,9121.276,7701.002901195.00
D59,1361.377,2911.002901195.00
D63,3601.467,8121.002901195.00
D67,5841.568,3331.002901195.00
D71,8081.668,8541.002901195.00
D76,0321.769,3751.002901195.00
D80,2561.869,8951.002901195.00
D84,4801.9510,4161.002901195.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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,623386.430.000.000.000.001,048,576
E14,33612,624384.850.000.000.000.001,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K7,8357,83500
64K128K121200
256K512K4400
512K1024K10010000
1M2M222200
4M8M2200
8M16M2200

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
1,7920.13109,499.325.89100.00129,702,859
3,5840.25109,499.325.89100.00129,702,859
7,1680.50109,499.325.89100.00029,702,859
10,7520.75109,499.325.89100.00029,702,859
14,3361.00109,499.325.89100.00029,702,859
17,2031.20109,499.320.00100.00029,701,261
20,0701.40109,499.320.00100.00029,701,261
22,9381.60109,499.320.00100.00029,701,261
25,8051.80109,499.320.00100.00029,701,261
28,6722.00109,499.320.00100.00029,701,261
43,0083.00109,499.320.00100.00029,701,261
57,3444.00109,499.320.00100.00029,701,261
86,0166.00109,499.320.00100.00029,701,261
114,6888.00109,499.320.00100.00029,701,261

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
3,7120.59606,941988,5590.87155,40846.7348,894
4,3520.6969923,2091,112,4170.9831,5509.4955,141
4,9920.801,33939,4521,124,2060.9919,7615.9455,729
5,1200.821,46543,6161,126,4510.9917,5165.2755,849
5,2480.841,59147,2931,128,4930.9915,4744.6555,953
5,3760.861,71950,8451,130,6000.9913,3674.0256,054
5,5040.881,84754,3971,132,8870.9911,0803.3356,184
5,6320.901,97557,9491,134,8270.999,1402.7556,301
5,7600.922,10360,8481,136,3911.007,5762.2856,381
5,8880.942,23163,6811,137,8681.006,0991.8356,461
6,0160.962,35969,1141,139,1291.004,8381.4556,521
6,1440.982,48774,6681,140,3851.003,5821.0856,578
6,2721.002,61579,0471,140,6411.003,3261.0056,604
6,4001.022,74383,4261,140,6471.003,3201.0056,604
6,5281.042,87187,8051,140,6491.003,3181.0056,604
6,6561.062,99992,1841,140,6511.003,3161.0056,604
6,7841.083,12796,5631,140,6581.003,3090.9956,605
6,9121.103,229100,0611,140,6581.003,3090.9956,605
7,0401.123,229100,0611,140,6581.003,3090.9956,605
7,1681.143,229100,0611,140,6581.003,3090.9956,605
7,2961.163,229100,0611,140,6581.003,3090.9956,605
7,4241.183,229100,0611,140,6581.003,3090.9956,605
7,5521.203,229100,0611,140,6581.003,3090.9956,605
8,1921.313,229100,0611,140,6581.003,3090.9956,605
8,8321.413,229100,0611,140,6581.003,3090.9956,605
9,4721.513,229100,0611,140,6581.003,3090.9956,605
10,1121.613,229100,0611,140,6581.003,3090.9956,605
10,7521.713,229100,0611,140,6581.003,3090.9956,605
11,3921.823,229100,0611,140,6581.003,3090.9956,605
12,0321.923,229100,0611,140,6581.003,3090.9956,605
12,6722.023,229100,0611,140,6581.003,3090.9956,605

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.2518,219,154,203,347290,867
19,2000.3818,219,154,203,347290,286
25,6000.5018,219,154,203,347290,257
32,0000.6318,219,154,203,347290,257
38,4000.7518,219,154,203,347290,257
44,8000.8818,219,154,203,347290,257
51,2001.0018,219,154,203,347290,257
57,6001.1318,219,154,203,347290,257
64,0001.2518,219,154,203,347290,257
70,4001.3818,219,154,203,347290,257
76,8001.5018,219,154,203,347290,257
83,2001.6318,219,154,203,347290,257
89,6001.7518,219,154,203,347290,257
96,0001.8818,219,154,203,347290,257
102,4002.0018,219,154,203,347290,257

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)
undo header100

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
22-Nov 01:58131814172661,1440/00/0/0/0/0/0
22-Nov 01:481451461,0172660,3990/00/0/0/0/0/0
22-Nov 01:381441774111660,4100/00/0/0/0/0/0
22-Nov 01:28111281,0101661,1440/00/0/0/0/0/0
22-Nov 01:181512514052660,3600/00/0/0/0/0/0
22-Nov 01:084962391,0053658,4780/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch20.00 00 
AQ dequeue txn counter latch6,2060.00 00 
ASM Keyed state latch7430.00 00 
ASM allocation2580.00 00 
ASM db client latch4,7630.00 00 
ASM map headers140.00 00 
ASM map load waiting list40.00 00 
ASM map operation freelist760.00 00 
ASM map operation hash table51,1820.00 00 
ASM network background latch3,0140.00 00 
ASM network state latch3820.00 00 
AWR Alerted Metric Element list77,3540.00 00 
Change Notification Hash table latch2,3820.00 00 
Consistent RBA2,5000.00 00 
DML lock allocation33,3620.00 00 
Event Group Locks8800.00 00 
FAL Queue1940.00 00 
FIB s.o chain latch60.00 00 
FOB s.o list latch9,2950.00 00 
File State Object Pool Parent Latch20.00 00 
I/O Staticstics latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch36,3730.00 05,2970.00
JS Sh mem access140.00 00 
JS mem alloc latch390.00 00 
JS queue access latch410.00 00 
JS queue state obj latch51,8340.00 00 
JS slv state obj latch1,5020.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KFK SGA Libload latch13,8620.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch2,3880.00 00 
KTF sga latch380.00 02,0250.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch1980.00 00 
Locator state objects pool parent latch20.00 00 
Lsod array latch4,9660.160.0000 
MQL Tracking Latch0  01410.00
Memory Management Latch20.00 02,3880.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch800.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process2,8530.00 00 
OS process allocation16,1010.010.0000 
OS process: request allocation7450.00 00 
PL/SQL warning settings1,6680.00 00 
PX hash array latch20.00 00 
QMT20.00 00 
Real-time plan statistics latch67,7160.00 00 
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 02,3800.00
SQL memory manager workarea list latch164,6180.00 00 
Shared B-Tree8250.00 00 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch13,1910.020.0000 
active service list16,5620.010.0007,8800.00
alert log latch20.00 00 
archive control3710.00 00 
archive process latch5830.00 00 
buffer pool20.00 00 
business card20.00 00 
cache buffer handles4140.00 00 
cache buffers chains1,396,1890.000.00012,4010.00
cache buffers lru chain40,0070.00 034,9450.00
call allocation2,6420.110.3300 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch7790.130.0000 
channel operations parent latch53,9360.00 00 
checkpoint queue latch1,635,8140.000.00022,2660.00
client/application info3,4980.00 00 
compile environment latch5070.00 00 
corrupted undo seg latch4130.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch1140.00 00 
cvmap freelist lock20.00 00 
database property service latch60.00 00 
deferred cleanup latch1140.00 00 
dml lock allocation1140.00 00 
done queue latch20.00 00 
dummy allocation1,0170.00 00 
enqueue freelist latch20.00 0133,6220.00
enqueue hash chains173,9070.00 00 
enqueues20.00 00 
fifth spare latch20.00 00 
file cache latch9900.00 00 
flashback copy20.00 00 
fourth Audit Vault latch20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA990.00 00 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch3200.00 013,5250.00
hash table modification latch1320.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch20.00 00 
interrupt manipulation10.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch1380.00 01362.94
job_queue_processes free list latch2830.00 00 
job_queue_processes parameter latch1,6880.00 00 
k2q lock allocation20.00 00 
kcbtsemkid latch10.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kgnfs mount latch20.00 00 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
kokc descriptor allocation latch1,6900.00 00 
krbmrosl20.00 00 
ksfv messages20.00 00 
ksim group membership cache20.00 00 
kss move lock700.00 00 
ksuosstats global area7190.00 00 
ksv allocation latch2500.00 00 
ksv class latch1,3580.070.0000 
ksv msg queue latch30.00 010.00
ksz_so allocation latch7450.270.0000 
ktm global data1150.00 00 
kwqbsn:qsga3780.00 00 
lgwr LWN SCN4,0510.00 00 
list of block allocation3,1150.00 00 
loader state object freelist40.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch260.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation30.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
managed standby latch1930.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch2590.00 00 
messages104,2390.010.0000 
mostly latch-free SCN4,2262.840.0000 
msg queue latch20.00 00 
multiblock read objects1220.00 00 
name-service namespace bucket20.00 00 
ncodef allocation latch1140.00 00 
object queue header heap105,5650.00 080.00
object queue header operation182,9350.000.0000 
object stats modification20.00 00 
parallel query alloc buffer1,9060.00 00 
parallel query stats20.00 00 
parameter list1480.00 00 
parameter table management3,7750.051.0000 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue6,0140.00 05,1340.02
process allocation1,0170.200.0003720.00
process group creation7450.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch1,0420.00 00 
query server freelists20.00 00 
queued dump request240.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation23,8840.020.000121,2400.01
redo copy20.00 0121,2440.08
redo writing25,7150.000.0000 
resmgr group change latch23,8640.00 00 
resmgr:active threads2,5370.00 03,5730.00
resmgr:actses change group3310.00 00 
resmgr:actses change state220.00 00 
resmgr:free threads list1,0570.00 00 
resmgr:method mem alloc latch40.00 00 
resmgr:plan CPU method20.00 00 
resmgr:schema config24,9630.021.0001190.00
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects231,1800.000.000870.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch20.00 00 
second spare latch20.00 00 
segmented array pool40.00 00 
sequence cache7370.00 00 
session allocation6,6530.021.0005,6360.00
session idle bit38,8910.00 00 
session queue latch20.00 00 
session state list latch8960.00 00 
session switching4890.00 00 
session timer2,3870.00 00 
shared pool85,3180.040.000220.00
shared pool sim alloc80.00 00 
shared pool simulator5720.00 00 
sim partition latch20.00 00 
simulator hash latch20,9490.00 00 
simulator lru latch2,8320.00 017,8570.00
sort extent pool1990.00 00 
space background state object latch240.00 00 
space background task latch9,0230.280.0004,7840.00
state object free list20.00 00 
statistics aggregation1,1200.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch5270.00 00 
transaction allocation9,5920.00 00 
undo global data14,3580.00 00 
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
resmgr:schema config24,963550
call allocation2,642312
parameter table management3,775220
session allocation6,653110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chainskcbgtcr: fast path020
cache buffers chainskcbgtcr: fast path (cr pin)010
call allocationksuxds011
parameter table managementksp_param_table_free011
parameter table managementkspallmod011
resmgr:schema configkgskgasi1040
resmgr:schema configkgskmetricupd010
session allocationkspallmod010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 420
Library Cachekglpnal1 9020
Library Cachekglpndl1 9520

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX68,52814.98
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX54,65611.95
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX38,5928.44
SYSSYSTEMI_SYSAUTH1 INDEX15,6003.41
SYSMANSYSAUXMGMT_METRICS_1DAY_PK INDEX10,8482.37

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX5,09823.78
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX3,42415.97
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX1840.86
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX460.21
SYSSYSAUXSMON_SCN_TIME TABLE250.12

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
SYSMANSYSAUXMGMT_METRICS_RAW_PK INDEX51314.11
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX41511.41
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX371.02
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX360.99
SYSSYSAUXSMON_SCN_TIME TABLE250.69

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 INDEX620.00
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX26.67

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 INDEX33,68041.45
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX19,50424.01
SYSMANSYSAUXMGMT_METRICS_1HOUR_PK INDEX19,08823.49
SYSMANSYSAUXMGMT_METRICS_1DAY_PK INDEX6,6568.19
SYSSYSTEMAUD$ TABLE8000.98

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1280.000 31
dc_files6860.000 0343
dc_global_oids8,0080.000 093
dc_histogram_data1,4122.270 027,213
dc_histogram_defs3,1775.540 08,670
dc_object_grants2970.000 0105
dc_objects14,0790.030 147,052
dc_profiles3390.000 02
dc_rollback_segments5,8600.000 067
dc_segments1,0190.000 15943
dc_sequences10.000 111
dc_tablespaces5,8830.000 019
dc_users34,1190.000 0245
global database name5,0260.000 01
outstanding_alerts1800.000 015
sch_lj_oids110.000 0259


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS1980.000 00
BODY2,1140.0014,9770.0000
CLUSTER200.00200.0000
DBLINK2020.000 00
EDITION2570.004920.0000
INDEX80.00887.5070
QUEUE1210.0020,3270.0000
SCHEMA2690.000 00
SQL AREA4,1470.1089,2890.333916
SQL AREA BUILD14210.560 00
SQL AREA STATS13969.7813969.7800
SUBSCRIPTION140.00140.0000
TABLE/PROCEDURE5,2180.0027,7860.35280
TRIGGER1330.005440.1810


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache43,264.0043,264.0043,264.0043,392.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target14,336.0014,336.0014,336.0014,336.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target51,200.0051,200.0051,200.0051,200.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool896.00896.00896.00896.000STA/
large pool384.00384.00384.00384.000STA/
shared pool6,272.006,272.006,144.006,272.000GRO/DEF
streams pool128.00128.00128.00128.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther324.16 6.6210.4444444949
Freeable39.380.001.512.049 2626
PL/SQL21.713.400.461.7712124747
SQL1.220.160.050.050202317
EOther324.01 6.7510.6045454848
Freeable38.000.001.582.129 2424
PL/SQL21.703.390.471.7912124646
SQL1.180.160.050.050202317

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory896.00896.000.00
largePX msg pool7.817.810.00
largefree memory375.81375.810.00
sharedASH buffers64.0064.000.00
sharedASM extent pointer array85.3785.370.00
sharedFileOpenBlock121.60121.600.00
sharedKGLH0759.01758.48-0.07
sharedKGLHD83.2083.06-0.16
sharedSQLA2,206.432,205.72-0.03
shareddb_block_hash_buckets356.00356.000.00
shareddbktb: trace buffer78.1378.130.00
sharedevent statistics per sess94.2694.260.00
sharedfree memory1,640.371,642.010.10
sharedksunfy : SSO free list87.8787.870.00
sharedprivate strands107.80107.800.00
streamsfree memory126.74126.740.00
 buffer_cache43,264.0043,264.000.00
 fixed_sga2.132.130.00
 log_buffer25.2925.290.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

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

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
7,1640.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.007,1640.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/xjdss/adump  
audit_trailDB  
compatible11.2.0.0.0  
control_files+DATA/xjdss/control01.ctl, +DATA/xjdss/control02.ctl  
db_block_size8192  
db_cache_size32212254720  
db_domain    
db_files2000  
db_namexjdss  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=xjdssXDB)  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=130.89.2.83)(PORT=1521))))  
log_archive_dest_1location=/arch1  
nls_languageSIMPLIFIED CHINESE  
nls_territoryCHINA  
open_cursors600  
pga_aggregate_target15032385536  
processes5000  
remote_login_passwordfileEXCLUSIVE  
resource_manager_planSCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN  
sessions7552  
sga_max_size53687091200  
sga_target53687091200  
shared_pool_reserved_size322122547  
shared_pool_size6442450944  
spfile+DATA/xjdss/spfilexjdss.ora  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA/xjdss/control01.ctl  
+DATA/xjdss/control02.ctl  

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report Report written to awrrpt_0000_0100.html SQL> SQL> SQL> SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options [oracle@xjdssa:/home/oracle]$ [oracle@xjdssa:/home/oracle]$ [oracle@xjdssa:/home/oracle]$ [oracle@xjdssa:/home/oracle]$ lslog Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Oct 14 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Oct 14 22:00:00 2013 Starting background process VKRM Mon Oct 14 22:00:00 2013 VKRM started with pid=44, OS id=4916218 Mon Oct 14 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Oct 14 22:00:45 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 15 01:00:42 2013 Thread 1 cannot allocate new log, sequence 9 Private strand flush not complete Current log# 6 seq# 8 mem# 0: +DATA/xjdss/redo06.log Thread 1 advanced to log sequence 9 (LGWR switch) Current log# 7 seq# 9 mem# 0: +DATA/xjdss/redo07.log Tue Oct 15 01:00:51 2013 Archived Log entry 8 added for thread 1 sequence 8 ID 0xffffffffad131ec2 dest 1: Tue Oct 15 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Oct 15 17:00:57 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Tue Oct 15 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Oct 15 22:00:00 2013 Starting background process VKRM Tue Oct 15 22:00:00 2013 VKRM started with pid=27, OS id=4915974 Tue Oct 15 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 15 22:00:53 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 16 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Oct 16 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Oct 16 22:00:00 2013 Starting background process VKRM Wed Oct 16 22:00:00 2013 VKRM started with pid=24, OS id=5112384 Wed Oct 16 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 16 22:00:20 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 16 23:00:26 2013 Thread 1 cannot allocate new log, sequence 10 Private strand flush not complete Current log# 7 seq# 9 mem# 0: +DATA/xjdss/redo07.log Thread 1 advanced to log sequence 10 (LGWR switch) Current log# 8 seq# 10 mem# 0: +DATA/xjdss/redo08.log Wed Oct 16 23:00:36 2013 Archived Log entry 9 added for thread 1 sequence 9 ID 0xffffffffad131ec2 dest 1: Thu Oct 17 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Oct 17 04:00:34 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Thu Oct 17 05:10:01 2013 Time drift detected. Please check VKTM trace file for more details. Thu Oct 17 11:21:51 2013 minact-scn: useg scan erroring out with error e:12751 Thu Oct 17 16:54:47 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Thu Oct 17 21:05:41 2013 minact-scn: useg scan erroring out with error e:12751 Thu Oct 17 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Oct 17 22:00:00 2013 Starting background process VKRM Thu Oct 17 22:00:00 2013 VKRM started with pid=27, OS id=4391222 Thu Oct 17 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Oct 17 22:00:18 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Oct 18 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Oct 18 21:00:28 2013 Thread 1 cannot allocate new log, sequence 11 Private strand flush not complete Current log# 8 seq# 10 mem# 0: +DATA/xjdss/redo08.log Thread 1 advanced to log sequence 11 (LGWR switch) Current log# 9 seq# 11 mem# 0: +DATA/xjdss/redo09.log Fri Oct 18 21:00:37 2013 Archived Log entry 10 added for thread 1 sequence 10 ID 0xffffffffad131ec2 dest 1: Fri Oct 18 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Oct 18 22:00:00 2013 Starting background process VKRM Fri Oct 18 22:00:00 2013 VKRM started with pid=24, OS id=4719220 Fri Oct 18 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Oct 18 22:01:02 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 19 01:56:10 2013 minact-scn: useg scan erroring out with error e:12751 Sat Oct 19 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Oct 19 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Oct 19 06:00:00 2013 Starting background process VKRM Sat Oct 19 06:00:00 2013 VKRM started with pid=44, OS id=4195186 Sat Oct 19 06:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 19 06:00:14 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 19 20:47:47 2013 minact-scn: useg scan erroring out with error e:12751 Sun Oct 20 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sun Oct 20 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sun Oct 20 06:00:00 2013 Starting background process VKRM Sun Oct 20 06:00:00 2013 VKRM started with pid=44, OS id=6226094 Sun Oct 20 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Oct 20 06:00:30 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Oct 20 10:09:45 2013 Thread 1 cannot allocate new log, sequence 12 Private strand flush not complete Current log# 9 seq# 11 mem# 0: +DATA/xjdss/redo09.log Thread 1 advanced to log sequence 12 (LGWR switch) Current log# 10 seq# 12 mem# 0: +DATA/xjdss/redo10.log Sun Oct 20 10:09:55 2013 Archived Log entry 11 added for thread 1 sequence 11 ID 0xffffffffad131ec2 dest 1: Sun Oct 20 10:53:30 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 21 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Oct 21 02:35:32 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 21 04:53:58 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 21 13:07:33 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 21 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Oct 21 22:00:00 2013 Starting background process VKRM Mon Oct 21 22:00:00 2013 VKRM started with pid=37, OS id=5308914 Mon Oct 21 22:06:14 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Oct 21 22:06:30 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 22 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Oct 22 03:01:13 2013 Thread 1 cannot allocate new log, sequence 13 Private strand flush not complete Current log# 10 seq# 12 mem# 0: +DATA/xjdss/redo10.log Thread 1 advanced to log sequence 13 (LGWR switch) Current log# 11 seq# 13 mem# 0: +DATA/xjdss/redo11.log Tue Oct 22 03:01:23 2013 Archived Log entry 12 added for thread 1 sequence 12 ID 0xffffffffad131ec2 dest 1: Tue Oct 22 09:05:24 2013 minact-scn: useg scan erroring out with error e:12751 Tue Oct 22 13:12:12 2013 minact-scn: useg scan erroring out with error e:12751 Tue Oct 22 17:58:06 2013 minact-scn: useg scan erroring out with error e:12751 Tue Oct 22 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Oct 22 22:00:00 2013 Starting background process VKRM Tue Oct 22 22:00:00 2013 VKRM started with pid=27, OS id=4195236 Tue Oct 22 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 22 22:00:31 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 23 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Oct 23 21:00:17 2013 Thread 1 cannot allocate new log, sequence 14 Private strand flush not complete Current log# 11 seq# 13 mem# 0: +DATA/xjdss/redo11.log Thread 1 advanced to log sequence 14 (LGWR switch) Current log# 12 seq# 14 mem# 0: +DATA/xjdss/redo12.log Wed Oct 23 21:00:27 2013 Archived Log entry 13 added for thread 1 sequence 13 ID 0xffffffffad131ec2 dest 1: Wed Oct 23 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Oct 23 22:00:00 2013 Starting background process VKRM Wed Oct 23 22:00:00 2013 VKRM started with pid=27, OS id=4653400 Wed Oct 23 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 23 22:00:18 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Oct 24 00:34:00 2013 minact-scn: useg scan erroring out with error e:12751 Thu Oct 24 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Oct 24 11:01:25 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Thu Oct 24 15:03:49 2013 minact-scn: useg scan erroring out with error e:12751 Thu Oct 24 17:36:01 2013 OS Pid: 4456796 executed alter system set events '28401 trace name context forever,level 1' Thu Oct 24 17:41:57 2013 Thread 1 cannot allocate new log, sequence 15 Private strand flush not complete Current log# 12 seq# 14 mem# 0: +DATA/xjdss/redo12.log Thread 1 advanced to log sequence 15 (LGWR switch) Current log# 13 seq# 15 mem# 0: +DATA/xjdss/redo13.log Thu Oct 24 17:42:01 2013 Archived Log entry 14 added for thread 1 sequence 14 ID 0xffffffffad131ec2 dest 1: Thu Oct 24 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Oct 24 22:00:00 2013 Starting background process VKRM Thu Oct 24 22:00:00 2013 VKRM started with pid=51, OS id=4719514 Thu Oct 24 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Oct 24 22:04:03 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Oct 25 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Oct 25 03:39:15 2013 minact-scn: useg scan erroring out with error e:12751 Fri Oct 25 11:16:44 2013 minact-scn: useg scan erroring out with error e:12751 Fri Oct 25 13:16:33 2013 Thread 1 cannot allocate new log, sequence 16 Private strand flush not complete Current log# 13 seq# 15 mem# 0: +DATA/xjdss/redo13.log Thread 1 advanced to log sequence 16 (LGWR switch) Current log# 14 seq# 16 mem# 0: +DATA/xjdss/redo14.log Fri Oct 25 13:16:36 2013 Archived Log entry 15 added for thread 1 sequence 15 ID 0xffffffffad131ec2 dest 1: Fri Oct 25 13:17:51 2013 Thread 1 cannot allocate new log, sequence 17 Private strand flush not complete Current log# 14 seq# 16 mem# 0: +DATA/xjdss/redo14.log Thread 1 advanced to log sequence 17 (LGWR switch) Current log# 15 seq# 17 mem# 0: +DATA/xjdss/redo15.log Fri Oct 25 13:17:52 2013 Archived Log entry 16 added for thread 1 sequence 16 ID 0xffffffffad131ec2 dest 1: Thread 1 advanced to log sequence 18 (LGWR switch) Current log# 16 seq# 18 mem# 0: +DATA/xjdss/redo16.log Fri Oct 25 13:17:52 2013 Archived Log entry 17 added for thread 1 sequence 17 ID 0xffffffffad131ec2 dest 1: Thread 1 advanced to log sequence 19 (LGWR switch) Current log# 3 seq# 19 mem# 0: +DATA/xjdss/redo03.log Fri Oct 25 13:17:54 2013 Archived Log entry 18 added for thread 1 sequence 18 ID 0xffffffffad131ec2 dest 1: Fri Oct 25 16:02:41 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Fri Oct 25 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Oct 25 22:00:00 2013 Starting background process VKRM Fri Oct 25 22:00:00 2013 VKRM started with pid=37, OS id=6094862 Fri Oct 25 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Oct 25 22:00:22 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 26 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Oct 26 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Oct 26 06:00:00 2013 Starting background process VKRM Sat Oct 26 06:00:00 2013 VKRM started with pid=37, OS id=4456912 Sat Oct 26 06:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 26 06:00:23 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Oct 26 17:01:31 2013 minact-scn: useg scan erroring out with error e:12751 Sat Oct 26 21:03:51 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Sun Oct 27 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sun Oct 27 04:00:58 2013 Thread 1 cannot allocate new log, sequence 20 Private strand flush not complete Current log# 3 seq# 19 mem# 0: +DATA/xjdss/redo03.log Thread 1 advanced to log sequence 20 (LGWR switch) Current log# 1 seq# 20 mem# 0: +DATA/xjdss/redo01.log Sun Oct 27 04:01:07 2013 Archived Log entry 19 added for thread 1 sequence 19 ID 0xffffffffad131ec2 dest 1: Sun Oct 27 04:48:49 2013 minact-scn: useg scan erroring out with error e:12751 Sun Oct 27 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sun Oct 27 06:00:00 2013 Starting background process VKRM Sun Oct 27 06:00:00 2013 VKRM started with pid=27, OS id=3343048 Sun Oct 27 06:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Oct 27 06:00:32 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Oct 27 14:26:41 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 28 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Oct 28 02:05:27 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Mon Oct 28 03:32:38 2013 Time drift detected. Please check VKTM trace file for more details. Mon Oct 28 18:47:24 2013 Thread 1 cannot allocate new log, sequence 21 Private strand flush not complete Current log# 1 seq# 20 mem# 0: +DATA/xjdss/redo01.log Thread 1 advanced to log sequence 21 (LGWR switch) Current log# 2 seq# 21 mem# 0: +DATA/xjdss/redo02.log Mon Oct 28 18:47:34 2013 Archived Log entry 20 added for thread 1 sequence 20 ID 0xffffffffad131ec2 dest 1: Mon Oct 28 19:05:16 2013 minact-scn: useg scan erroring out with error e:12751 Mon Oct 28 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Oct 28 22:00:00 2013 Starting background process VKRM Mon Oct 28 22:00:00 2013 VKRM started with pid=27, OS id=5308830 Mon Oct 28 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Oct 28 22:00:39 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 29 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Oct 29 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Oct 29 22:00:00 2013 Starting background process VKRM Tue Oct 29 22:00:00 2013 VKRM started with pid=24, OS id=4456996 Tue Oct 29 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Oct 29 22:00:23 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 30 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Oct 30 09:00:13 2013 Thread 1 cannot allocate new log, sequence 22 Private strand flush not complete Current log# 2 seq# 21 mem# 0: +DATA/xjdss/redo02.log Thread 1 advanced to log sequence 22 (LGWR switch) Current log# 4 seq# 22 mem# 0: +DATA/xjdss/redo04.log Wed Oct 30 09:00:22 2013 Archived Log entry 21 added for thread 1 sequence 21 ID 0xffffffffad131ec2 dest 1: Wed Oct 30 19:56:48 2013 minact-scn: useg scan erroring out with error e:12751 Wed Oct 30 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Oct 30 22:00:00 2013 Starting background process VKRM Wed Oct 30 22:00:00 2013 VKRM started with pid=24, OS id=3342918 Wed Oct 30 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Oct 30 22:00:23 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Oct 31 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Oct 31 09:30:14 2013 Time drift detected. Please check VKTM trace file for more details. Thu Oct 31 11:08:42 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Thu Oct 31 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Oct 31 22:00:00 2013 Starting background process VKRM Thu Oct 31 22:00:00 2013 VKRM started with pid=37, OS id=4653568 Thu Oct 31 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Oct 31 22:00:29 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 01 00:57:26 2013 Thread 1 cannot allocate new log, sequence 23 Private strand flush not complete Current log# 4 seq# 22 mem# 0: +DATA/xjdss/redo04.log Thread 1 advanced to log sequence 23 (LGWR switch) Current log# 5 seq# 23 mem# 0: +DATA/xjdss/redo05.log Fri Nov 01 00:57:36 2013 Archived Log entry 22 added for thread 1 sequence 22 ID 0xffffffffad131ec2 dest 1: Fri Nov 01 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Nov 01 09:12:58 2013 minact-scn: useg scan erroring out with error e:12751 Fri Nov 01 13:27:53 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 01 21:00:25 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Fri Nov 01 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Nov 01 22:00:00 2013 Starting background process VKRM Fri Nov 01 22:00:00 2013 VKRM started with pid=24, OS id=2359502 Fri Nov 01 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 01 22:00:22 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 01 22:10:08 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Fri Nov 01 22:18:29 2013 minact-scn: useg scan erroring out with error e:12751 Sat Nov 02 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Nov 02 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Nov 02 06:00:00 2013 Starting background process VKRM Sat Nov 02 06:00:00 2013 VKRM started with pid=44, OS id=6094986 Sat Nov 02 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 02 06:00:24 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 02 15:18:50 2013 Time drift detected. Please check VKTM trace file for more details. Sat Nov 02 17:00:36 2013 Thread 1 cannot allocate new log, sequence 24 Private strand flush not complete Current log# 5 seq# 23 mem# 0: +DATA/xjdss/redo05.log Thread 1 advanced to log sequence 24 (LGWR switch) Current log# 6 seq# 24 mem# 0: +DATA/xjdss/redo06.log Sat Nov 02 17:00:45 2013 Archived Log entry 23 added for thread 1 sequence 23 ID 0xffffffffad131ec2 dest 1: Sun Nov 03 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sun Nov 03 03:11:28 2013 Errors in file /u01/app/oracle/diag/rdbms/xjdss/xjdss/trace/xjdss_m001_6095004.trc: ORA-00604: 递归 SQL 级别 3 出现错误 ORA-12751: 违反了 CPU 时间或运行时间策略 Suspending MMON slave action kewfmadsa_ for 82800 seconds Sun Nov 03 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sun Nov 03 06:00:00 2013 Starting background process VKRM Sun Nov 03 06:00:00 2013 VKRM started with pid=30, OS id=4391346 Sun Nov 03 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Nov 03 06:00:17 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Nov 04 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Nov 04 08:06:37 2013 Thread 1 cannot allocate new log, sequence 25 Private strand flush not complete Current log# 6 seq# 24 mem# 0: +DATA/xjdss/redo06.log Thread 1 advanced to log sequence 25 (LGWR switch) Current log# 7 seq# 25 mem# 0: +DATA/xjdss/redo07.log Mon Nov 04 08:06:46 2013 Archived Log entry 24 added for thread 1 sequence 24 ID 0xffffffffad131ec2 dest 1: Mon Nov 04 08:12:44 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Mon Nov 04 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Nov 04 22:00:00 2013 Starting background process VKRM Mon Nov 04 22:00:00 2013 VKRM started with pid=44, OS id=5308978 Mon Nov 04 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Nov 04 22:00:18 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 05 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Nov 05 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Nov 05 22:00:00 2013 Starting background process VKRM Tue Nov 05 22:00:00 2013 VKRM started with pid=44, OS id=4719480 Tue Nov 05 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 05 22:00:15 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 05 22:36:48 2013 Thread 1 cannot allocate new log, sequence 26 Private strand flush not complete Current log# 7 seq# 25 mem# 0: +DATA/xjdss/redo07.log Thread 1 advanced to log sequence 26 (LGWR switch) Current log# 8 seq# 26 mem# 0: +DATA/xjdss/redo08.log Tue Nov 05 22:36:57 2013 Archived Log entry 25 added for thread 1 sequence 25 ID 0xffffffffad131ec2 dest 1: Wed Nov 06 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Nov 06 03:04:55 2013 minact-scn: useg scan erroring out with error e:12751 Wed Nov 06 17:12:15 2013 Time drift detected. Please check VKTM trace file for more details. Wed Nov 06 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Nov 06 22:00:00 2013 Starting background process VKRM Wed Nov 06 22:00:00 2013 VKRM started with pid=30, OS id=6684782 Wed Nov 06 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 06 22:00:34 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Nov 07 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Nov 07 04:00:56 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Thu Nov 07 13:16:05 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Thu Nov 07 13:38:37 2013 minact-scn: useg scan erroring out with error e:12751 Thu Nov 07 15:45:42 2013 Thread 1 cannot allocate new log, sequence 27 Private strand flush not complete Current log# 8 seq# 26 mem# 0: +DATA/xjdss/redo08.log Thread 1 advanced to log sequence 27 (LGWR switch) Current log# 9 seq# 27 mem# 0: +DATA/xjdss/redo09.log Thu Nov 07 15:45:51 2013 Archived Log entry 26 added for thread 1 sequence 26 ID 0xffffffffad131ec2 dest 1: Thu Nov 07 17:08:47 2013 Time drift detected. Please check VKTM trace file for more details. Thu Nov 07 21:44:43 2013 Time drift detected. Please check VKTM trace file for more details. Thu Nov 07 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Nov 07 22:00:00 2013 Starting background process VKRM Thu Nov 07 22:00:00 2013 VKRM started with pid=27, OS id=4195154 Thu Nov 07 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Nov 07 22:00:17 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 08 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Nov 08 03:20:14 2013 minact-scn: useg scan erroring out with error e:12751 Fri Nov 08 18:17:09 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Fri Nov 08 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Nov 08 22:00:00 2013 Starting background process VKRM Fri Nov 08 22:00:00 2013 VKRM started with pid=37, OS id=5374794 Fri Nov 08 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 08 22:00:18 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 09 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Nov 09 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Nov 09 06:00:00 2013 Starting background process VKRM Sat Nov 09 06:00:00 2013 VKRM started with pid=37, OS id=4916216 Sat Nov 09 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 09 06:00:15 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 09 08:33:07 2013 Thread 1 cannot allocate new log, sequence 28 Private strand flush not complete Current log# 9 seq# 27 mem# 0: +DATA/xjdss/redo09.log Thread 1 advanced to log sequence 28 (LGWR switch) Current log# 10 seq# 28 mem# 0: +DATA/xjdss/redo10.log Sat Nov 09 08:33:16 2013 Archived Log entry 27 added for thread 1 sequence 27 ID 0xffffffffad131ec2 dest 1: Sat Nov 09 23:18:38 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Sun Nov 10 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sun Nov 10 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sun Nov 10 06:00:00 2013 Starting background process VKRM Sun Nov 10 06:00:00 2013 VKRM started with pid=24, OS id=4194632 Sun Nov 10 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Nov 10 06:02:38 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Nov 10 10:18:16 2013 Suspending MMON slave action kewrmapsa_ for 82800 seconds Sun Nov 10 14:13:42 2013 minact-scn: useg scan erroring out with error e:12751 Sun Nov 10 20:10:25 2013 Thread 1 cannot allocate new log, sequence 29 Private strand flush not complete Current log# 10 seq# 28 mem# 0: +DATA/xjdss/redo10.log Thread 1 advanced to log sequence 29 (LGWR switch) Current log# 11 seq# 29 mem# 0: +DATA/xjdss/redo11.log Sun Nov 10 20:10:34 2013 Archived Log entry 28 added for thread 1 sequence 28 ID 0xffffffffad131ec2 dest 1: Mon Nov 11 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Nov 11 09:02:23 2013 minact-scn: useg scan erroring out with error e:12751 Mon Nov 11 18:19:11 2013 minact-scn: useg scan erroring out with error e:12751 Mon Nov 11 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Nov 11 22:00:00 2013 Starting background process VKRM Mon Nov 11 22:00:00 2013 VKRM started with pid=37, OS id=2359472 Mon Nov 11 22:03:53 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Nov 11 22:29:14 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 12 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Nov 12 10:21:34 2013 Thread 1 cannot allocate new log, sequence 30 Private strand flush not complete Current log# 11 seq# 29 mem# 0: +DATA/xjdss/redo11.log Thread 1 advanced to log sequence 30 (LGWR switch) Current log# 12 seq# 30 mem# 0: +DATA/xjdss/redo12.log Tue Nov 12 10:21:43 2013 Archived Log entry 29 added for thread 1 sequence 29 ID 0xffffffffad131ec2 dest 1: Tue Nov 12 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Nov 12 22:00:00 2013 Starting background process VKRM Tue Nov 12 22:00:00 2013 VKRM started with pid=37, OS id=5112646 Tue Nov 12 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 12 22:00:19 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 13 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Nov 13 11:00:21 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Wed Nov 13 15:01:32 2013 Time drift detected. Please check VKTM trace file for more details. Wed Nov 13 20:32:08 2013 minact-scn: useg scan erroring out with error e:12751 Wed Nov 13 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Nov 13 22:00:00 2013 Starting background process VKRM Wed Nov 13 22:00:00 2013 VKRM started with pid=27, OS id=3473610 Wed Nov 13 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 13 22:00:44 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Nov 14 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Nov 14 03:21:34 2013 Thread 1 cannot allocate new log, sequence 31 Private strand flush not complete Current log# 12 seq# 30 mem# 0: +DATA/xjdss/redo12.log Thread 1 advanced to log sequence 31 (LGWR switch) Current log# 13 seq# 31 mem# 0: +DATA/xjdss/redo13.log Thu Nov 14 03:21:43 2013 Archived Log entry 30 added for thread 1 sequence 30 ID 0xffffffffad131ec2 dest 1: Thu Nov 14 12:17:14 2013 minact-scn: useg scan erroring out with error e:12751 Thu Nov 14 15:29:53 2013 minact-scn: useg scan erroring out with error e:12751 Thu Nov 14 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Nov 14 22:00:00 2013 Starting background process VKRM Thu Nov 14 22:00:00 2013 VKRM started with pid=37, OS id=5571104 Thu Nov 14 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Nov 14 22:00:58 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 15 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Nov 15 05:00:40 2013 Suspending MMON slave action kewrmafsa_ for 82800 seconds Fri Nov 15 20:00:23 2013 Thread 1 cannot allocate new log, sequence 32 Private strand flush not complete Current log# 13 seq# 31 mem# 0: +DATA/xjdss/redo13.log Thread 1 advanced to log sequence 32 (LGWR switch) Current log# 14 seq# 32 mem# 0: +DATA/xjdss/redo14.log Fri Nov 15 20:00:33 2013 Archived Log entry 31 added for thread 1 sequence 31 ID 0xffffffffad131ec2 dest 1: Fri Nov 15 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Nov 15 22:00:00 2013 Starting background process VKRM Fri Nov 15 22:00:00 2013 VKRM started with pid=37, OS id=4391328 Fri Nov 15 22:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 15 22:00:23 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 16 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Nov 16 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Nov 16 06:00:00 2013 Starting background process VKRM Sat Nov 16 06:00:00 2013 VKRM started with pid=37, OS id=4457328 Sat Nov 16 06:00:01 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 16 06:00:19 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 16 15:30:24 2013 minact-scn: useg scan erroring out with error e:12751 Sun Nov 17 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sun Nov 17 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sun Nov 17 06:00:00 2013 Starting background process VKRM Sun Nov 17 06:00:00 2013 VKRM started with pid=37, OS id=4588004 Sun Nov 17 06:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Nov 17 06:00:25 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sun Nov 17 10:00:39 2013 Thread 1 cannot allocate new log, sequence 33 Private strand flush not complete Current log# 14 seq# 32 mem# 0: +DATA/xjdss/redo14.log Thread 1 advanced to log sequence 33 (LGWR switch) Current log# 15 seq# 33 mem# 0: +DATA/xjdss/redo15.log Sun Nov 17 10:00:48 2013 Archived Log entry 32 added for thread 1 sequence 32 ID 0xffffffffad131ec2 dest 1: Mon Nov 18 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Mon Nov 18 06:59:19 2013 minact-scn: useg scan erroring out with error e:12751 Mon Nov 18 14:51:52 2013 minact-scn: useg scan erroring out with error e:12751 Mon Nov 18 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x3189]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Nov 18 22:00:00 2013 Starting background process VKRM Mon Nov 18 22:00:00 2013 VKRM started with pid=24, OS id=4391282 Mon Nov 18 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Nov 18 22:01:07 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Mon Nov 18 23:00:31 2013 Thread 1 cannot allocate new log, sequence 34 Private strand flush not complete Current log# 15 seq# 33 mem# 0: +DATA/xjdss/redo15.log Thread 1 advanced to log sequence 34 (LGWR switch) Current log# 16 seq# 34 mem# 0: +DATA/xjdss/redo16.log Mon Nov 18 23:00:40 2013 Archived Log entry 33 added for thread 1 sequence 33 ID 0xffffffffad131ec2 dest 1: Tue Nov 19 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Tue Nov 19 02:54:14 2013 minact-scn: useg scan erroring out with error e:12751 Tue Nov 19 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318A]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Tue Nov 19 22:00:00 2013 Starting background process VKRM Tue Nov 19 22:00:00 2013 VKRM started with pid=27, OS id=4456984 Tue Nov 19 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue Nov 19 22:00:31 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 20 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Wed Nov 20 11:03:21 2013 Thread 1 cannot allocate new log, sequence 35 Private strand flush not complete Current log# 16 seq# 34 mem# 0: +DATA/xjdss/redo16.log Thread 1 advanced to log sequence 35 (LGWR switch) Current log# 3 seq# 35 mem# 0: +DATA/xjdss/redo03.log Wed Nov 20 11:03:31 2013 Archived Log entry 34 added for thread 1 sequence 34 ID 0xffffffffad131ec2 dest 1: Wed Nov 20 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Wed Nov 20 22:00:00 2013 Starting background process VKRM Wed Nov 20 22:00:00 2013 VKRM started with pid=37, OS id=3473444 Wed Nov 20 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 20 22:00:24 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Wed Nov 20 23:51:06 2013 minact-scn: useg scan erroring out with error e:12751 Thu Nov 21 00:51:18 2013 minact-scn: useg scan erroring out with error e:12751 Thu Nov 21 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Thu Nov 21 12:30:59 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Thu Nov 21 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318C]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Thu Nov 21 22:00:00 2013 Starting background process VKRM Thu Nov 21 22:00:00 2013 VKRM started with pid=37, OS id=4719488 Thu Nov 21 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Nov 21 22:00:38 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 22 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Fri Nov 22 02:00:07 2013 Thread 1 cannot allocate new log, sequence 36 Private strand flush not complete Current log# 3 seq# 35 mem# 0: +DATA/xjdss/redo03.log Thread 1 advanced to log sequence 36 (LGWR switch) Current log# 1 seq# 36 mem# 0: +DATA/xjdss/redo01.log Fri Nov 22 02:00:16 2013 Archived Log entry 35 added for thread 1 sequence 35 ID 0xffffffffad131ec2 dest 1: Fri Nov 22 11:39:16 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 22 12:46:27 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 22 13:53:37 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 22 15:00:48 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 22 16:07:58 2013 Time drift detected. Please check VKTM trace file for more details. Fri Nov 22 20:54:34 2013 minact-scn: useg scan erroring out with error e:12751 Fri Nov 22 22:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318D]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Fri Nov 22 22:00:00 2013 Starting background process VKRM Fri Nov 22 22:00:00 2013 VKRM started with pid=37, OS id=4653788 Fri Nov 22 22:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 22 22:00:21 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Fri Nov 22 22:32:30 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Sat Nov 23 00:22:16 2013 minact-scn: useg scan erroring out with error e:12751 Sat Nov 23 02:00:00 2013 Closing scheduler window Closing Resource Manager plan via scheduler window Clearing Resource Manager plan via parameter Sat Nov 23 06:00:00 2013 Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Sat Nov 23 06:00:00 2013 Starting background process VKRM Sat Nov 23 06:00:00 2013 VKRM started with pid=37, OS id=4456854 Sat Nov 23 06:00:02 2013 Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 23 06:00:22 2013 End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK" Sat Nov 23 07:02:01 2013 Time drift detected. Please check VKTM trace file for more details. Sat Nov 23 08:09:19 2013 Time drift detected. Please check VKTM trace file for more details. Sat Nov 23 16:46:40 2013 minact-scn: useg scan erroring out with error e:12751 Sat Nov 23 16:48:30 2013 Thread 1 cannot allocate new log, sequence 37 Private strand flush not complete Current log# 1 seq# 36 mem# 0: +DATA/xjdss/redo01.log Thread 1 advanced to log sequence 37 (LGWR switch) Current log# 2 seq# 37 mem# 0: +DATA/xjdss/redo02.log Sat Nov 23 16:48:39 2013 Archived Log entry 36 added for thread 1 sequence 36 ID 0xffffffffad131ec2 dest 1: Sat Nov 23 22:33:31 2013 Suspending MMON slave action kewfmadsa_ for 82800 seconds Sat Nov 23 23:42:03 2013 minact-scn: useg scan erroring out with error e:12751 [oracle@xjdssa:/home/oracle]$ ss SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 23 23:59:14 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options