WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHostStd Block Size
First (1st)PWHD496003788pwhd111.1.0.6.0NOPDBH8192
Second (2nd)PWL2466883936pwl2111.2.0.3.0NOPDBH8192

Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st10914-Nov-11 19:11:24 (Mon)11014-Nov-11 19:13:03 (Mon) 0.1 1.7 0.1
2nd1514-Nov-11 20:06:19 (Mon)1614-Nov-11 20:06:23 (Mon) 1.0 0.1 0.1
%Diff     1,516.7 -95.8 -25.4

Host Configuration Comparison

1st2ndDiff%Diff
Number of CPUs:2200.0
Number of CPU Cores:2200.0
Number of CPU Sockets:1100.0
Physical Memory:4055.7M4055.7M0M0.0
Load at Start Snapshot:    
%User Time:5.1622.2117.05330.4
%System Time:4.476.011.5534.5
%Idle Time:90.3771.78-18.59-20.6

Cache Sizes

1st (M)2nd (M)Diff (M)%Diff
Memory Target1,624.01,632.08.00.5
SGA Target
1,024.0976.0-48.0-4.7
Buffer Cache
512.0528.016.03.1
Shared Pool
464.0368.0-96.0-20.7
Large Pool
8.016.08.0100.0
Java Pool
16.016.00.00.0
Streams Pool
16.032.016.0100.0
PGA Target
600.0656.056.09.3
Log Buffer4.36.32.046.6

Load Profile

1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 0.1 1.0 1,516.7 0.2 0.2 15.8
CPU time: 0.0 0.3 1,550.0 0.1 0.1 -12.5
Redo size: 9,027.3 297,206.9 3,192.3 30,898.9 66,621.3 115.6
Logical reads: 144.0 2,170.9 1,407.6 492.9 486.6 -1.3
Block changes: 23.4 865.0 3,599.7 80.0 193.9 142.3
Physical reads: 0.3 36.2 12,814.3 1.0 8.1 736.1
Physical writes: 0.2 4.7 2,036.4 0.8 1.1 38.2
User calls: 0.7 12.4 1,604.1 2.5 2.8 12.5
Parses: 6.9 88.8 1,191.8 23.5 19.9 -15.4
Hard parses: 0.1 14.6 12,033.3 0.4 3.3 695.1
W/A MB processed: 291,626.8 7,576,013.2 2,497.8 998,188.1 1,698,223.2 2,497.8
Logons: 0.1 0.7 775.0 0.3 0.2 -42.9
Executes: 8.4 200.0 2,281.5 28.8 44.8 55.9
Transactions: 0.3 4.5 1,437.9   
1st2ndDiff
% Blocks changed per Read: 16.2 39.8 23.6
Recursive Call %: 98.1 98.8 0.6
Rollback per transaction %: 0.0 0.0 0.0
Rows per Sort: 19.6 43.5 23.8
Avg DB time per Call (sec): 0.1 0.1 0.0

Top Timed Events

1st 2nd
EventWait ClassWaitsTime(s)Avg Time(ms)%DB timeEventWait ClassWaitsTime(s)Avg Time(ms)%DB time
CPU time  2.34 42.37CPU time  1.39 33.72
db file sequential readUser I/O320.7322.9013.27db file sequential readUser I/O1731.106.3726.77
control file sequential readSystem I/O7980.660.8311.92enq: RR - contentionOther10.57565.3713.73
os thread startupConcurrency40.0613.761.00control file sequential readSystem I/O1230.231.885.62
latch: cache buffers chainsConcurrency10.0438.050.69log file parallel writeSystem I/O290.113.662.57
-log file parallel writeSystem I/O1340.030.250.61-     

Report Details

Supplemental Information


Back to Top

Time Model Statistics

 % of DB time Time (seconds) Time per Trans (seconds)
Statistic Name1st2ndDiff1st2nd%Diff1st2nd%Diff
DB time100.00100.000.005.524.12-25.360.190.2215.79
PL/SQL execution elapsed time5.7730.3224.550.321.25290.630.010.07600.00
DB CPU42.3733.72-8.652.341.39-40.600.080.07-12.50
sql execute elapsed time100.3195.79-4.535.543.94-28.880.190.2110.53
hard parse (sharing criteria) elapsed time3.140.69-2.450.170.03-82.350.010.00-100.00
parse time elapsed7.004.66-2.340.390.19-51.280.010.010.00
hard parse elapsed time2.923.740.820.160.15-6.250.010.010.00
hard parse (bind mismatch) elapsed time0.000.400.400.000.02100.000.000.000.00
connection management call elapsed time0.090.360.270.000.01100.000.000.000.00
PL/SQL compilation elapsed time0.260.490.230.010.02100.000.000.000.00
sequence load elapsed time0.000.020.020.000.000.000.000.000.00
repeated bind elapsed time0.010.030.010.000.000.000.000.000.00
Java execution elapsed time0.000.000.000.000.000.000.000.000.00
RMAN cpu time (backup/restore)0.000.000.000.000.000.000.000.000.00
failed parse (out of shared memory) elapsed time0.000.000.000.000.000.000.000.000.00
failed parse elapsed time0.000.000.000.000.000.000.000.000.00
inbound PL/SQL rpc elapsed time0.000.000.000.000.000.000.000.000.00
background elapsed time12.1614.532.360.670.60-10.450.020.0350.00
background cpu time1.411.890.480.080.080.000.000.000.00



Back to Top

Operating System Statistics

 Value (centi-seconds) per Second (DB time) per Second (Elapsed Time) per Trans
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
AVG_BUSY_TIME951115172.2127.93-83.789.5827.00181.8432.796.05-81.55
AVG_IDLE_TIME8,9342921,617.7770.91-95.6290.0068.56-23.82308.0715.37-95.01
AVG_SYS_TIME4392479.495.83-92.674.425.6427.6015.141.26-91.68
AVG_USER_TIME5099092.1721.86-76.285.1321.13311.8917.554.74-72.99
BUSY_TIME1,904230344.7855.86-83.8019.1854.00181.5465.6612.11-81.56
IDLE_TIME17,8705853,235.90142.07-95.61180.03137.36-23.70616.2130.79-95.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME88349159.8911.90-92.568.9011.5129.3330.452.58-91.53
USER_TIME1,021181184.8843.96-76.2210.2942.50313.0235.219.53-72.93



Back to Top

Wait Events

Back to Top

Wait Classes

 % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
Wait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
User I/O13.9229.0015.070.3646.2512,747.220.771.1954.5521.366.06-71.63
Other0.0514.4414.400.021.416,950.000.000.59100.001.3499.137,297.76
System I/O13.188.21-4.979.9235.92262.100.730.34-53.420.742.21198.65
Concurrency2.050.00-2.050.060.00-100.000.110.00-100.0018.900.00-100.00
Application0.001.951.950.000.23100.000.000.08100.000.0080.24100.00
Commit0.010.250.240.011.6416,300.000.000.01100.000.601.45141.67
Network0.000.000.000.429.862,247.620.000.000.000.010.00-100.00


Back to Wait Events
Back to Top

Wait Events

  % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
EventWait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
enq: RR - contentionOther0.0013.7313.730.000.23100.000.000.57100.000.00565.37100.00
db file sequential readUser I/O13.2726.7713.500.3240.6212,593.750.731.1050.6822.906.37-72.18
control file sequential readSystem I/O11.925.62-6.318.0428.88259.200.660.23-65.150.831.88126.51
direct path writeUser I/O0.002.162.160.003.52100.000.000.09100.000.005.92100.00
log file parallel writeSystem I/O0.612.571.961.356.81404.440.030.11266.670.253.661,364.00
enq: TX - row lock contentionApplication0.001.951.950.000.23100.000.000.08100.000.0080.24100.00
os thread startupConcurrency1.000.00-1.000.040.00-100.000.060.00-100.0013.760.00-100.00
enq: JS - queue lockOther0.000.710.710.000.23100.000.000.03100.000.0029.41100.00
latch: cache buffers chainsConcurrency0.690.00-0.690.010.00-100.000.040.00-100.0038.050.00-100.00
Data file init writeUser I/O0.640.00-0.640.030.00-100.000.040.00-100.0011.870.00-100.00
library cache lockConcurrency0.370.00-0.370.010.00-100.000.020.00-100.0020.280.00-100.00
control file parallel writeSystem I/O0.340.02-0.320.360.23-36.110.020.00-100.000.520.6321.15
db file parallel writeSystem I/O0.300.00-0.300.170.00-100.000.020.00-100.000.980.00-100.00
log file syncCommit0.010.250.240.011.6416,300.000.000.01100.000.601.45141.67
Disk file operations I/OUser I/O0.000.080.080.002.11100.000.000.000.000.000.35100.00
rdbms ipc replyOther0.050.00-0.050.020.00-100.000.000.000.001.340.00-100.00
db file single writeUser I/O0.010.00-0.010.010.00-100.000.000.000.000.550.00-100.00
latch freeOther0.000.000.000.000.23100.000.000.000.000.000.01100.00
asynch descriptor resizeOther0.000.000.000.000.70100.000.000.000.000.000.000.00
SQL*Net message to clientNetwork0.000.000.000.429.862,247.620.000.000.000.010.00-100.00
Streams AQ: waiting for time management or cleanup tasksIdle0.0016,494.8916,494.890.000.23100.000.00679.21100.000.00679,209.95100.00
DIAG idle waitIdle3,603.46196.82-3,406.642.001.88-6.00199.008.10-95.93999.991,013.051.31
virtual circuit statusIdle2,173.080.00-2,173.080.040.00-100.00120.010.00-100.0030,001.690.00-100.00
Streams AQ: qmn slave idle waitIdle2,028.20121.60-1,906.600.080.23187.50112.015.01-95.5314,000.755,007.23-64.24
Streams AQ: qmn coordinator idle waitIdle2,028.20121.60-1,906.600.090.47422.22112.015.01-95.5312,445.102,503.62-79.88
Streams AQ: waiting for messages in the queueIdle1,811.81182.52-1,629.280.260.70169.23100.067.52-92.483,848.292,505.27-34.90
jobq slave waitIdle1,249.52163.50-1,086.020.233.291,330.4369.006.73-90.253,000.17480.90-83.97
SQL*Net message from clientIdle1,245.57245.74-999.830.4110.572,478.0568.7910.12-85.291,677.69224.86-86.60
Space Manager: slave idle waitIdle1,842.62948.42-894.200.2110.574,933.33101.7639.05-61.634,845.59867.85-82.09
PL/SQL lock timerIdle543.230.00-543.230.300.00-100.0030.000.00-100.00999.990.00-100.00
wait for unread message on broadcast channelIdle0.00118.37118.370.001.17100.000.004.87100.000.00974.82100.00
WCR: replay client notifyIdle0.0085.6985.690.000.94100.000.003.53100.000.00882.16100.00
class slave waitIdle0.000.00-0.000.010.00-100.000.000.000.000.080.00-100.00
WCR: replay clockIdle0.000.000.000.000.94100.000.000.000.000.000.000.00


Back to Wait Events
Back to Top

Service Statistics

Back to Top

Service Statistics

 % of DB time % CPU Time % Physical Reads % Logical Reads
Service Name1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
SYS$USERS99.8299.900.0896.67100.003.3371.43109.7438.3193.82100.216.39
SYS$BACKGROUND0.000.000.000.000.000.0017.860.00-17.865.920.02-5.90
PWHD0.00  0.00  0.00  0.00  
PWHDXDB0.00  0.00  0.00  0.00  
PWL2 0.10  0.00  0.00  0.01 
PWL2XDB 0.00  0.00  0.00  0.00 


Back to Service Statistics
Back to Top

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
SYS$BACKGROUND0.000.000.000.000.000.000.00
SYS$USERS0.000.000.000.000.000.000.00
PWHD0.00  0.00   
PWHDXDB0.00  0.00   
PWL2 0.00  0.00  
PWL2XDB 0.00  0.00  


Back to Service Statistics
Back to Top

SQL Statistics

Back to Top

Top SQL Comparison by Elapsed Time

 Elapsed Time % of DB time Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
4677dt963h4pv58.9558.95  -58.953,256 0.18 967 377 13.00 0.00 1   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
3z5b10rcvwbc0  43.1043.1043.10 1,775 0.24 686 688 115.00 1.00 1  BEGIN dbms_workload_replay.sta...
0tu45m00jq66a24.5083.45  -24.501,353 0.18 484 275 14.00 1.00 1   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
dwjfhksff9ypg  15.1658.2615.16 624 0.24 16 39 6.00 1.00 1/ 1/ 1 select dbms_workload_replay.ge...
5ax5xu96u2ztd8.3991.850.2758.53-8.12463110.180.244716000.000.00613.00453.00111/ 1/ 1 insert into WRH$_EVENT_HISTOGR...
gg6zabzs8ra006.2398.07  -6.23344 0.18 94 0 0.00 54.00 1 1// 1 update accounts set generated ...
dayq182sk41ks  5.4163.945.41 223 0.24 218 0 0.00 7.00 1/ 1/ 1 insert into wrh$_memory_target...
bm2pwrpcr8ru6  5.3869.325.38 222 0.24 218 0 0.00 7.00 1/ 1/ 1 select sga_size s, sga_size_fa...
586b2udq6dbng5.49103.570.2269.54-5.2730390.180.244716000.000.00469.00622.00111/ 1/ 1 insert into wrh$_sysstat (snap...
7vgmvmy8vvb9s5.15108.72  -5.15284 0.18 94 0 0.00 1.00 1 1// 1 insert into wrh$_tempstatxs (s...
4tg8mr2bvy6gr4.16112.88  -4.16230 0.18 0 215 5.00 1.00 1 1// 1 select smontabv.cnt, smontab.t...
71n72y1csrcfa2.72115.60  -2.7275 0.36 16 31 1.50 1.00 2   DECLARE row_count NUMBER := 0;...
8j1c23fa3f015  2.5872.122.58 106 0.24 0 0 0.00 1.00 1  begin :1 := dbms_workload_repl...
5zafwfnja12x3  2.4874.612.48 102 0.24 0 0 0.00 1.00 1/ 1/ 1 UPDATE WRR$_REPLAYS SET NUM_CL...
bunssq950snhf9.51125.117.1881.79-2.335252960.180.24468265000.000.007.007.00111/ 1/ 2 insert into wrh$_sga_target_ad...
6ajkhukk78nsr4.28129.392.1683.94-2.13236890.180.24784755384.003.001.001.0011  begin prvt_hdm.auto_execute( :...
cvn54b7yz0s8u  1.9385.871.93 8 2.43 2 7 6.70 4.70 10/ 1/ 1 select /*+ index(idl_ub1$ i_id...
350myuyx0t1d61.66131.051.8387.700.1891750.180.240065610.000.005.005.00111/ 1/ 1 insert into wrh$_tablespace_st...


Back to SQL Statistics
Back to Top

Top SQL Comparison by CPU Time

 CPU Time % of DB CPU CPU Time (ms) per Exec I/O Time (ms) per Exec #Exec/sec (DB time) Exec Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3z5b10rcvwbc0  49.4449.4449.44 686 688 0.24 1,775 115.00 1.00  BEGIN dbms_workload_replay.sta...
4677dt963h4pv41.3341.33  -41.33967 377 0.18 3,256 13.00 0.00   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
0tu45m00jq66a20.6762.00  -20.67484 275 0.18 1,353 14.00 1.00   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
bm2pwrpcr8ru6  15.7365.1715.73 218 0 0.24 222 0.00 7.00/ 1/ 1 select sga_size s, sga_size_fa...
dayq182sk41ks  15.7380.9015.73 218 0 0.24 223 0.00 7.00/ 1/ 1 insert into wrh$_memory_target...
1rswbxwhbpmr76.0068.00  -6.0023 0 1.09 22 0.00 1.00 1// 1 select decode(bitand(a.flags, ...
bqnn4c3gjtmgu4.6772.67  -4.67109 0 0.18 79 0.00 38.00 1// 1 insert into wrh$_bg_event_summ...
7vgmvmy8vvb9s4.0076.67  -4.0094 0 0.18 284 0.00 1.00 1// 1 insert into wrh$_tempstatxs (s...
gg6zabzs8ra004.0080.67  -4.0094 0 0.18 344 0.00 54.00 1// 1 update accounts set generated ...
5dfmd823r8dsp  3.3784.273.37 47 0 0.24 53 0.00 0.00/ 1/ 1 insert into wrh$_memory_resize...
3s58mgk0uy2ws  3.3787.643.37 1 0 19.67 0 0.00 1.00  insert into wrm$_snapshot_deta...
6gvch1xu9ca3g3.3384.00  -3.3339 0 0.36 69 0.00 1.00   DECLARE job BINARY_INTEGER := ...
35y2u24f4rxqm  2.2589.892.25 31 1 0.24 66 0.00 10.00/ 1/ 1 insert into wrh$_seg_stat_obj ...
g5caq3p7yt68s2.0086.00  -2.0047 0 0.18 44 0.00 1.00 1// 1 select max(created) from accou...
5a6ytgs4sp3u3  1.1291.011.12 16 0 0.24 12 0.00 0.00/ 1/ 1 SELECT a.default_action, b.nam...
bunssq950snhf20.00106.0019.10110.11-0.90468265000.180.245252960.000.007.007.001/ 1/ 2 insert into wrh$_sga_target_ad...
cp3gpd7z878w80.67106.671.12111.240.461616000.180.24670.000.0019.0026.001/ 1/ 2 insert into wrh$_sgastat (snap...
6ajkhukk78nsr3.33110.003.37114.610.04784755380.180.24236894.003.001.001.00  begin prvt_hdm.auto_execute( :...


Back to SQL Statistics
Back to Top

Top SQL Comparison by I/O Time

 I/O Time % of DB time I/O Time (ms) per Exec Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3z5b10rcvwbc0  16.7216.7216.72 688 1,775 0.24 686 115.00 1.00 1  BEGIN dbms_workload_replay.sta...
4677dt963h4pv6.836.83  -6.83377 3,256 0.18 967 13.00 0.00 1   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
0tu45m00jq66a4.9911.82  -4.99275 1,353 0.18 484 14.00 1.00 1   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
4tg8mr2bvy6gr3.9015.72  -3.90215 230 0.18 0 5.00 1.00 1 1// 1 select smontabv.cnt, smontab.t...
cvn54b7yz0s8u  1.7618.481.76 7 8 2.43 2 6.70 4.70 10/ 1/ 1 select /*+ index(idl_ub1$ i_id...
71n72y1csrcfa1.1216.84  -1.1231 75 0.36 16 1.50 1.00 2   DECLARE row_count NUMBER := 0;...
dwjfhksff9ypg  0.9419.420.94 39 624 0.24 16 6.00 1.00 1/ 1/ 1 select dbms_workload_replay.ge...
350myuyx0t1d61.1718.011.4820.900.31656191750.180.24000.000.005.005.00111/ 1/ 1 insert into wrh$_tablespace_st...
6ajkhukk78nsr0.9919.000.9221.82-0.075538236890.180.2478474.003.001.001.0011  begin prvt_hdm.auto_execute( :...
586b2udq6dbng0.0019.000.0021.820.000030390.180.2447160.000.00469.00622.00111/ 1/ 1 insert into wrh$_sysstat (snap...
5ax5xu96u2ztd0.0019.000.0021.820.0000463110.180.2447160.000.00613.00453.00111/ 1/ 1 insert into WRH$_EVENT_HISTOGR...
5zafwfnja12x3  0.0021.820.00 0 102 0.24 0 0.00 1.00 1/ 1/ 1 UPDATE WRR$_REPLAYS SET NUM_CL...
7vgmvmy8vvb9s0.0019.00  0.000 284 0.18 94 0.00 1.00 1 1// 1 insert into wrh$_tempstatxs (s...
8j1c23fa3f015  0.0021.820.00 0 106 0.24 0 0.00 1.00 1  begin :1 := dbms_workload_repl...
bm2pwrpcr8ru6  0.0021.820.00 0 222 0.24 218 0.00 7.00 1/ 1/ 1 select sga_size s, sga_size_fa...
bunssq950snhf0.0019.000.0021.820.00005252960.180.244682650.000.007.007.00111/ 1/ 2 insert into wrh$_sga_target_ad...
dayq182sk41ks  0.0021.820.00 0 223 0.24 218 0.00 7.00 1/ 1/ 1 insert into wrh$_memory_target...
gg6zabzs8ra000.0019.00  0.000 344 0.18 94 0.00 54.00 1 1// 1 update accounts set generated ...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Buffer Gets

 % Total Gets Gets per Exec #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3z5b10rcvwbc0  62.7962.7962.79 5,806.00 1 1,775 686 688 115.00 1.00  BEGIN dbms_workload_replay.sta...
gg6zabzs8ra0021.1621.16  -21.163,025.00 1 344 94 0 0.00 54.00 1// 1 update accounts set generated ...
1qjpw4wb8sbdp21.0942.25  -21.093,014.00 1 38 31 0 0.00 1.00 1// 1 select max(created) from accou...
g5caq3p7yt68s21.0963.33  -21.093,014.00 1 44 47 0 0.00 1.00 1// 1 select max(created) from accou...
0tu45m00jq66a12.5275.86  -12.521,790.00 1 1,353 484 275 14.00 1.00   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
4677dt963h4pv12.3588.21  -12.351,766.00 1 3,256 967 377 13.00 0.00   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
dwjfhksff9ypg  7.8570.657.85 726.00 1 624 16 39 6.00 1.00/ 1/ 1 select dbms_workload_replay.ge...
3s58mgk0uy2ws  5.3576.005.35 6.11 81 0 1 0 0.00 1.00  insert into wrm$_snapshot_deta...
3ktacv9r56b51  4.1180.114.11 29.23 13 0 1 0 0.00 14.00/ 1/ 1 select owner#, name, namespace...
8swypbbr0m372  4.0784.184.07 28.92 13 1 0 1 0.08 13.46/ 1/ 1 select order#, columns, types ...
6gvch1xu9ca3g3.9692.17  -3.96283.00 2 69 39 0 0.00 1.00   DECLARE job BINARY_INTEGER := ...
3nkd3g3ju5ph1  2.9787.152.97 3.99 69 0 0 0 0.00 0.99/ 1/ 1 select obj#, type#, ctime, mti...
6ajkhukk78nsr5.9798.158.7795.922.80854.00811.001123689784755384.003.001.001.00  begin prvt_hdm.auto_execute( :...
cvn54b7yz0s8u  1.9997.911.99 18.40 10 8 2 7 6.70 4.70/ 1/ 1 select /*+ index(idl_ub1$ i_id...
g00cj285jmgsw1.90100.04  -1.903.01 90 1 0 0 0.00 1.00 1// 1 update sys.mon_mods$ set inser...
0h6b2sajwb74n1.87101.91  -1.874.94 54 0 0 0 0.00 3.57 1// 1 select privilege#, level from ...
96g93hntrzjtr  1.8699.771.86 2.77 62 0 0 0 0.00 0.77/ 1/ 1 select /*+ rule */ bucket_cnt,...
5h7w8ykwtb2xt1.57103.48  -1.573.41 66 1 0 0 0.00 1.00   INSERT INTO SYS.WRI$_ADV_PARAM...
f0s0bk5k713yb0.29103.771.56101.331.2741.00144.00114617016000.000.00298.00356.001/ 1/ 1 insert into wrh$_parameter (sn...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Physical Reads

 % Total Physical Reads Physical Reads per Exec #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3z5b10rcvwbc0  74.6874.6874.68 115.00 1 1,775 686 688 1.00  BEGIN dbms_workload_replay.sta...
0tu45m00jq66a50.0050.00  -50.0014.00 1 1,353 484 275 1.00   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
4677dt963h4pv46.4396.43  -46.4313.00 1 3,256 967 377 0.00   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
cvn54b7yz0s8u  43.51118.1843.51 6.70 10 8 2 7 4.70/ 1/ 1 select /*+ index(idl_ub1$ i_id...
4tg8mr2bvy6gr17.86114.29  -17.865.00 1 230 0 215 1.00 1// 1 select smontabv.cnt, smontab.t...
692wcvj50ytxz14.29128.57  -14.294.00 1 142 0 93 4.00 1// 1 insert into wrh$_resource_limi...
3m8smr0v7v1m614.29142.860.65118.83-13.644.001.0011821916055181.001.00  INSERT INTO sys.wri$_adv_messa...
6ajkhukk78nsr14.29157.141.95120.78-12.344.003.001123689784755381.001.00  begin prvt_hdm.auto_execute( :...
561frs7bf8c7910.71167.86  -10.713.00 1 76 0 62 1.00   INSERT INTO WRR$_CAPTURE_STATS...
71n72y1csrcfa10.71178.57  -10.711.50 2 75 16 31 1.00   DECLARE row_count NUMBER := 0;...
84qubbrsr0kfn10.71189.29  -10.713.00 1 94 16 59 496.00 1// 1 insert into wrh$_latch (snap_i...
dwjfhksff9ypg  3.90124.683.90 6.00 1 624 16 39 1.00/ 1/ 1 select dbms_workload_replay.ge...
fnk7155mk2jq63.57192.860.00124.68-3.571.000.00149910021020.0017.251/ 1/ 1 insert into wrh$_sysmetric_his...
6hwjmjgrpsuaa  1.30125.971.30 2.00 1 32 16 29 82.00/ 1/ 1 insert into wrh$_enqueue_stat ...
bwsz40d3hc8q7  1.30127.271.30 2.00 1 21 0 20 24.00/ 1/ 1 insert into wrh$_librarycache ...
27wht2mxm7sjh  0.65127.920.65 0.25 4 12 4 4 1.00  /* OracleOEM */ BEGIN :message...
2cb3nbu3mauzp  0.65128.570.65 1.00 1 18 16 15 1.00  insert into sys.scheduler$_job...
2r80d5wbd6u9d  0.65129.220.65 1.00 1 26 0 22 0.00/ 1/ 1 SELECT post_commit_scn, nvl(l...


Back to SQL Statistics
Back to Top

Top SQL Comparison by UnOptimized Read Requests

 % Total UnOptimized Read Requests Read Requests per Exec Total Read Requests %Optimized Reads #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3z5b10rcvwbc0  95.4595.4595.45 147.00 147 0.00 1 1,775 686 688 1.00  BEGIN dbms_workload_replay.sta...
cvn54b7yz0s8u  43.51138.9643.51 6.70 67 0.00 10 8 2 7 4.70/ 1/ 1 select /*+ index(idl_ub1$ i_id...
dwjfhksff9ypg  3.90142.863.90 6.00 6 0.00 1 624 16 39 1.00/ 1/ 1 select dbms_workload_replay.ge...
6ajkhukk78nsr  1.95144.811.95 3.00 3 0.001123689784755381.001.00  begin prvt_hdm.auto_execute( :...
6hwjmjgrpsuaa  1.30146.101.30 2.00 2 0.00 1 32 16 29 82.00/ 1/ 1 insert into wrh$_enqueue_stat ...
bwsz40d3hc8q7  1.30147.401.30 2.00 2 0.00 1 21 0 20 24.00/ 1/ 1 insert into wrh$_librarycache ...
27wht2mxm7sjh  0.65148.050.65 0.25 1 0.00 4 12 4 4 1.00  /* OracleOEM */ BEGIN :message...
2cb3nbu3mauzp  0.65148.700.65 1.00 1 0.00 1 18 16 15 1.00  insert into sys.scheduler$_job...
2r80d5wbd6u9d  0.65149.350.65 1.00 1 0.00 1 26 0 22 0.00/ 1/ 1 SELECT post_commit_scn, nvl(l...
3m8smr0v7v1m6  0.65150.000.65 1.00 1 0.0011821916055181.001.00  INSERT INTO sys.wri$_adv_messa...
0tu45m00jq66a    0.00      1 1,353 484 275 1.00   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
4677dt963h4pv    0.00      1 3,256 967 377 0.00   BEGIN DBMS_WORKLOAD_CAPTURE.FI...
4tg8mr2bvy6gr    0.00      1 230 0 215 1.00 1// 1 select smontabv.cnt, smontab.t...
561frs7bf8c79    0.00      1 76 0 62 1.00   INSERT INTO WRR$_CAPTURE_STATS...
692wcvj50ytxz    0.00      1 142 0 93 4.00 1// 1 insert into wrh$_resource_limi...
71n72y1csrcfa    0.00      2 75 16 31 1.00   DECLARE row_count NUMBER := 0;...
84qubbrsr0kfn    0.00      1 94 16 59 496.00 1// 1 insert into wrh$_latch (snap_i...
fnk7155mk2jq6  0.00150.000.00 0.00 0  149910021020.0017.251/ 1/ 1 insert into wrh$_sysmetric_his...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Executions

 #Executions/sec (DB time) #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plan  
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
3s58mgk0uy2ws 19.6719.67 81 0 1 0 0.00 1.00  insert into wrm$_snapshot_deta...
3nkd3g3ju5ph1 16.7616.76 69 0 0 0 0.00 0.99/ 1/ 1 select obj#, type#, ctime, mti...
350f5yrnnmshs16.30 -16.3090 0 0 0 0.00 0.00 1// 1 lock table sys.mon_mods$ in ex...
g00cj285jmgsw16.30 -16.3090 1 0 0 0.00 1.00 1// 1 update sys.mon_mods$ set inser...
96g93hntrzjtr 15.0615.06 62 0 0 0 0.00 0.77/ 1/ 1 select /*+ rule */ bucket_cnt,...
5h7w8ykwtb2xt11.95 -11.9566 1 0 0 0.00 1.00   INSERT INTO SYS.WRI$_ADV_PARAM...
0h6b2sajwb74n9.78 -9.7854 0 0 0 0.00 3.57 1// 1 select privilege#, level from ...
87gaftwrm2h68 3.893.89 16 0 0 0 0.00 0.94/ 1/ 1 select o.owner#, o.name, o.nam...
3972rvxu3knn33.44 -3.4419 0 0 0 0.00 0.00 1// 1 delete from sdo_geor_ddl__tabl...
a6u3yjca29nqc3.44 -3.4419 0 1 0 0.00 1.00   declare m_stmt varchar2(512); ...
3ktacv9r56b51 3.163.16 13 0 1 0 0.00 14.00/ 1/ 1 select owner#, name, namespace...
8swypbbr0m372 3.163.16 13 1 0 1 0.08 13.46/ 1/ 1 select order#, columns, types ...
53saa2zkr6wc3 2.672.67 11 0 0 0 0.00 1.55/ 2/ 2 select intcol#, nvl(pos#, 0), ...
c6awqs517jpj0 2.432.43 10 0 0 0 0.00 0.20/ 1/ 1 select /*+ index(idl_char$ i_i...
cvn54b7yz0s8u 2.432.43 10 8 2 7 6.70 4.70/ 1/ 1 select /*+ index(idl_ub1$ i_id...
ga9j9xk5cy9s0 2.432.43 10 1 0 1 0.10 1.00/ 1/ 1 select /*+ index(idl_sb4$ i_id...
3c1kubcdjnppq2.17 -2.1712 0 0 0 0.00 1.00 1// 1 update sys.col_usage$ set equa...
08bqjmf8490s21.81 -1.8110 0 0 0 0.00 0.60 1// 1 SELECT PARAMETER_VALUE FROM MG...
5j0q2df7hm1k21.81 -1.8110 5 0 0 0.00 1.00   INSERT INTO MGMT_METRICS_RAW (...
8vwv6hx92ymmm1.81 -1.8110 0 2 0 0.00 1.00 1// 1 UPDATE MGMT_CURRENT_METRICS SE...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Parse Calls

 % Total Parses Parses #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st/2nd/BothSQL Text
350f5yrnnmshs13.2013.20  -13.2090 90 1// 1 lock table sys.mon_mods$ in ex...
g00cj285jmgsw13.2026.39  -13.2090 90 1// 1 update sys.mon_mods$ set inser...
0h6b2sajwb74n7.9234.31  -7.9254 54 1// 1 select privilege#, level from ...
3972rvxu3knn32.7937.10  -2.7919 19 1// 1 delete from sdo_geor_ddl__tabl...
a6u3yjca29nqc2.7939.88  -2.7919 19   declare m_stmt varchar2(512); ...
08bqjmf8490s21.4741.35  -1.4710 10 1// 1 SELECT PARAMETER_VALUE FROM MG...
3nkd3g3ju5ph1  1.061.061.06 4 69/ 1/ 1 select obj#, type#, ctime, mti...
96g93hntrzjtr  1.062.121.06 4 62/ 1/ 1 select /*+ rule */ bucket_cnt,...
cm5vu20fhtnq1  1.063.171.06 4 4/ 1/ 1 select /*+ connect_by_filterin...
0v3dvmc22qnam1.0342.38  -1.037 1   insert into sys.col_usage$ (ob...
3c1kubcdjnppq1.0343.40  -1.037 12 1// 1 update sys.col_usage$ set equa...
b2gnxm5z6r51n1.0344.43  -1.037 7 1// 1 lock table sys.col_usage$ in e...
0ws7ahf1d78qa  0.793.970.79 3 3/ 1/ 1 select SYS_CONTEXT('USERENV', ...
1gu8t96d0bdmu  0.794.760.79 3 3/ 2/ 2 select t.ts#, t.file#, t.block...
27wht2mxm7sjh  0.795.560.79 3 4  /* OracleOEM */ BEGIN :message...
2ggpbty3yfyxr  0.796.350.79 3 3/ 1/ 1 SELECT TO_DATE( TO_CHAR(SYSTIM...
459f3z9u4fb3u  0.797.140.79 3 3/ 1/ 1 select value$ from props$ wher...
4vs91dcv7u1p6  0.797.940.79 3 3  insert into sys.aud$( sessioni...
bsa0wjtftg3uw1.1745.600.538.47-0.6482832/ 1/ 2 select file# from file$ where ...
0k8522rmdzg4k0.5946.191.069.520.4744441/ 1/ 1 select privilege# from sysauth...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Sharable Memory

 % Total Sharable Memory Sharable Memory Used Sharable Memory Max #Executions  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2ndSQL Text
1rswbxwhbpmr70.160.16  -0.16791,741 791,741 6  select decode(bitand(a.flags, ...
7ng34ruy5awxq  0.070.070.07 281,140 281,140 5 select i.obj#, i.ts#, i.file#,...
803u6vwz0ah1p0.070.23  -0.07328,754 328,754 1  select OBJOID, CLSOID, RUNTIME...
3ktacv9r56b51  0.060.140.06 241,778 241,778 13 select owner#, name, namespace...
1gu8t96d0bdmu  0.060.190.06 215,428 215,428 3 select t.ts#, t.file#, t.block...
9tgj4g8y4rwy8  0.040.230.04 163,627 163,627 7 select type#, blocks, extents,...
9nn460aaugtas0.040.27  -0.04186,324 186,324 5  SELECT OBJOID, CLSOID, DECODE(...
6qz82dptj0qr7  0.040.270.04 147,088 147,088 1 select l.col#, l.intcol#, l.lo...
8swypbbr0m372  0.040.310.04 144,305 144,305 13 select order#, columns, types ...
2tkw12w5k68vd  0.040.350.04 138,566 138,566 2 select user#, password, datats...
83taa7kaw59c1  0.030.380.03 133,725 133,725 9 select name, intcol#, segcol#,...
1gfaj4z5hn1kf  0.030.410.03 132,640 132,640 3 delete from dependency$ where ...
0kkhhb2w93cx00.030.29  -0.03125,403 125,403 2  update seg$ set type#=:4, bloc...
dpyzg5dsn3g600.020.32  -0.02116,741 116,741 1  insert into wrh$_seg_stat_obj ...
18naypzfmabd60.020.34  -0.0294,965 94,965 3  INSERT INTO MGMT_SYSTEM_PERFOR...
ca3rwma7ccf9b0.020.35  -0.0282,432 82,432 1  SELECT startsn.stat_id, x.keh...
6wm3n4d7bnddg0.070.420.080.500.01340,734312,162340,734312,16211 SELECT source, (case when tim...
cp3gpd7z878w80.020.440.020.510.0075,46772,85975,46772,85911 insert into wrh$_sgastat (snap...
1cq3qr774cu450.030.470.030.550.00155,853130,597155,853130,59711 insert into WRH$_IOSTAT_FILETY...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
1gfaj4z5hn1kf 1414 14 3 delete from dependency$ where ...
1gu8t96d0bdmu 1414 14 3 select t.ts#, t.file#, t.block...
7ng34ruy5awxq 1414 14 5 select i.obj#, i.ts#, i.file#,...
6qz82dptj0qr7 1212 12 1 select l.col#, l.intcol#, l.lo...
53saa2zkr6wc3 1010 10 11 select intcol#, nvl(pos#, 0), ...
gx4mv66pvj3xz 1010 10 5 select con#, type#, condlength...
3ktacv9r56b51 88 8 13 select owner#, name, namespace...
8swypbbr0m372 88 8 13 select order#, columns, types ...
9k43zr1uannr6 88 8 1 select obj#, owner, node from ...
bsa0wjtftg3uw102-810283 select file# from file$ where ...
dcstr36r0vz0d 88 8 2 select procedure#, procedurena...
18naypzfmabd67 -77 3  INSERT INTO MGMT_SYSTEM_PERFOR...
08bqjmf8490s26 -66 10  SELECT PARAMETER_VALUE FROM MG...
0kkhhb2w93cx05 -55 2  update seg$ set type#=:4, bloc...
1rswbxwhbpmr74 -44 6  select decode(bitand(a.flags, ...
3972rvxu3knn34 -44 19  delete from sdo_geor_ddl__tabl...
843z3698rn43r4 -44 1  SELECT nvl(e.status, a.status)...
8vwv6hx92ymmm4 -44 10  UPDATE MGMT_CURRENT_METRICS SE...
a6u3yjca29nqc4 -44 19  declare m_stmt varchar2(512); ...
6wm3n4d7bnddg42-24211 SELECT source, (case when tim...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Cluster Wait Time

 % Total Cluster Wait Cluster Wait Time (sec) Cluster Wait Time per Exec (sec) #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
062savj8zgzut0.000.00  0.000.00 0.00 3 1// 1 UPDATE sys.wri$_adv_parameters...
089dbukv1aanh0.000.00  0.000.00 0.00 8 1// 1 SELECT SYS_EXTRACT_UTC(SYSTIME...
08bqjmf8490s20.000.00  0.000.00 0.00 10 1// 1 SELECT PARAMETER_VALUE FROM MG...
08vznc16ycuag0.000.00  0.000.00 0.00 2 1// 1 SELECT SYS_GUID() FROM SYS.DUA...
0h6b2sajwb74n0.000.00  0.000.00 0.00 54 1// 1 select privilege#, level from ...
0k8522rmdzg4k0.000.000.000.000.000.000.000.000.00441/ 1/ 1 select privilege# from sysauth...
0kkhhb2w93cx00.000.00  0.000.00 0.00 2 1// 1 update seg$ set type#=:4, bloc...
0tu45m00jq66a0.000.00  0.000.00 0.00 1   BEGIN DBMS_WORKLOAD_CAPTURE.ST...
0v3dvmc22qnam0.000.00  0.000.00 0.00 1   insert into sys.col_usage$ (ob...
0ws7ahf1d78qa  0.000.000.00 0.00 0.00 3/ 1/ 1 select SYS_CONTEXT('USERENV', ...
0z1031991bd7w0.000.00  0.000.00 0.00 1 1// 1 insert into wrh$_sysmetric_sum...
1cd2krbdzrhvq  0.000.000.00 0.00 0.00 1/ 1/ 1 insert into wrh$_tempstatxs (s...
1cq3qr774cu450.000.000.000.000.000.000.000.000.00111/ 1/ 2 insert into WRH$_IOSTAT_FILETY...
1gfaj4z5hn1kf  0.000.000.00 0.00 0.00 3/ 2/ 2 delete from dependency$ where ...
1gu8t96d0bdmu  0.000.000.00 0.00 0.00 3/ 2/ 2 select t.ts#, t.file#, t.block...
1tn90bbpyjshq  0.000.000.00 0.00 0.00 1/ 1/ 1 UPDATE wrh$_tempfile tfh SET (...
20vv6ttajyjzq  0.000.000.00 0.00 0.00 3/ 1/ 1 delete from access$ where d_ob...
270jvdqbxdub5  0.000.000.00 0.00 0.00 1/ 1/ 1 select NUM_CLIENTS, SYNCHRONI...
27wht2mxm7sjh  0.000.000.00 0.00 0.00 4  /* OracleOEM */ BEGIN :message...


Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db block changes2,3213,68458.72420.29894.67112.8723.38864.993,599.7080.03193.89142.27
execute count8348522.16151.02206.9137.018.40200.052,281.5528.7644.8455.91
logons cumulative83-62.501.450.73-49.660.080.70775.000.280.16-42.86
opened cursors cumulative840768-8.57152.11186.5122.628.46180.322,031.4428.9740.4239.52
parse count (total)682378-44.57123.5091.80-25.676.8788.751,191.8523.5219.89-15.43
parse time elapsed356-82.866.341.46-76.970.351.41302.861.210.32-73.55
physical reads28154450.005.0737.40637.670.2836.1612,814.290.978.11736.08
physical writes2220-9.093.984.8622.110.224.702,036.360.761.0538.16
redo size896,0681,265,80441.26162,259.96307,405.7489.459,027.30297,206.863,192.3130,898.9066,621.26115.61
session cursor cache hits4114499.2574.42109.0446.524.14105.422,446.3814.1723.6366.76
session logical reads14,2949,246-35.322,588.362,245.43-13.25144.002,170.931,407.59492.90486.63-1.27
user calls7253-26.3913.0412.87-1.300.7312.441,604.112.482.7912.50
user commits2919-34.485.254.61-12.190.294.461,437.931.001.000.00
workarea executions - optimal182126-30.7732.9630.60-7.161.8329.581,516.396.286.635.57


Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
CPU used by this session220140-36.3639.8434.00-14.662.2232.871,380.637.597.37-2.90
CPU used when call started201137-31.8436.4033.27-8.602.0232.171,492.576.937.214.04
CR blocks created31-66.670.540.24-55.560.030.23666.670.100.05-50.00
HSC Heap Segment Block Changes45366246.1482.03160.7795.994.56155.443,308.7715.6234.84123.05
Heap Segment Array Inserts82864.8814.8520.8940.670.8320.192,332.532.834.5360.07
Heap Segment Array Updates134-69.232.350.97-58.720.130.94623.080.450.21-53.33
IMU Flushes318-74.195.611.94-65.420.311.88506.451.070.42-60.75
IMU Redo allocation size11,50055,828385.462,082.4213,558.06551.07115.8613,108.2411,213.86396.552,938.32640.97
IMU commits2314-39.134.163.40-18.270.233.291,330.430.790.74-6.33
IMU contention110.000.180.2433.330.010.232,200.000.030.0566.67
IMU undo allocation size62,59284,80035.4811,334.1620,594.0381.70630.5719,910.783,057.582,158.344,463.16106.79
SQL*Net roundtrips to/from client4032-20.007.247.777.320.407.511,777.501.381.6821.74
active txn count during cleanout304653.335.4311.17105.710.3010.803,500.001.032.42134.95
background timeouts38322-94.2669.355.34-92.303.865.1733.9413.211.16-91.22
buffer is not pinned count2,1564,753120.45390.411,154.29195.6621.721,115.995,038.0874.34250.16236.51
buffer is pinned count1,1271,37522.01204.08333.9263.6211.35322.852,744.4938.8672.3786.23
bytes received via SQL*Net from client6,97415,254118.731,262.853,704.50193.3470.263,581.594,997.62240.48802.84233.85
bytes sent via SQL*Net to client8,13810,28326.361,473.632,497.2769.4681.992,414.422,844.77280.62541.2192.86
calls to get snapshot scn: kcmgss1,4001,173-16.21253.51284.8712.3714.10275.421,853.3348.2861.7427.88
calls to kcmgas251169-32.6745.4541.04-9.702.5339.681,468.388.668.892.66
calls to kcmgcs263591,280.774.7187.181,750.960.2684.2932,319.230.9018.891,998.89
cleanout - number of ktugct calls375343.246.7012.8792.090.3712.443,262.161.282.79117.97
cleanouts only - consistent read gets31-66.670.540.24-55.560.030.23666.670.100.05-50.00
cluster key scan block gets2256154.553.9813.60241.710.2213.155,877.270.762.95288.16
cluster key scans2251131.823.9812.39211.310.2211.975,340.910.762.68252.63
commit cleanout failures: callback failure36100.000.541.46170.370.031.414,600.000.100.32220.00
commit cleanouts432362-16.2078.2387.9112.374.3585.001,854.0214.9019.0527.85
commit cleanouts successfully completed429356-17.0277.6886.4611.304.3283.591,834.9514.7918.7426.71
commit txn count during cleanout192952.633.447.04104.650.196.813,484.210.661.53131.82
consistent changes75-28.571.271.21-4.720.071.171,571.430.240.268.33
consistent gets12,1175,725-52.752,194.151,390.34-36.63122.071,344.211,001.18417.83301.32-27.88
consistent gets - examination1,3542,50284.79245.18607.62147.8313.64587.464,206.8946.69131.68182.03
consistent gets from cache12,1175,725-52.752,194.151,390.34-36.63122.071,344.211,001.18417.83301.32-27.88
consistent gets from cache (fastpath)10,4773,020-71.171,897.17733.42-61.34105.55709.09571.80361.28158.95-56.00
cursor authentications1475435.712.5418.21616.930.1417.6112,478.570.483.95722.92
data blocks consistent reads - undo records applied31-66.670.540.24-55.560.030.23666.670.100.05-50.00
db block gets2,1773,52161.74394.21855.09116.9121.93826.723,669.8175.07185.32146.86
db block gets from cache2,1773,50160.82394.21850.23115.6821.93822.023,648.3875.07184.26145.45
db block gets from cache (fastpath)5971,281114.57108.10311.10187.796.01300.774,904.4920.5967.42227.44
deferred (CURRENT) block cleanout applications285241-15.4451.6158.5313.412.8756.591,871.789.8312.6828.99
enqueue conversions224-81.823.980.97-75.630.220.94327.270.760.21-72.37
enqueue releases1,537555-63.89278.32134.78-51.5715.48130.31741.8053.0029.21-44.89
enqueue requests1,541556-63.92279.04135.03-51.6115.52130.55741.1753.1429.26-44.94
free buffer requested112298166.0720.2872.37256.851.1369.976,092.043.8615.68306.22
heap block compress72-71.431.270.49-61.420.070.47571.430.240.11-54.17
immediate (CR) block cleanout applications31-66.670.540.24-55.560.030.23666.670.100.05-50.00
immediate (CURRENT) block cleanout applications465928.268.3314.3372.030.4613.852,910.871.593.1195.60
index crx upgrade (positioned)609-85.0010.862.19-79.830.602.11251.672.070.47-77.29
index fetch by key77097126.10139.43235.8169.127.76227.992,838.0226.5551.1192.50
index scans kdiixs159280836.49107.20196.2383.055.96189.723,083.2220.4142.53108.38
leaf node 90-10 splits101220.001.812.9160.770.102.822,720.000.340.6385.29
leaf node splits142364.292.545.59120.080.145.403,757.140.481.21152.08
lob writes732357.141.277.77511.810.077.5110,628.570.241.68600.00
lob writes unaligned732357.141.277.77511.810.077.5110,628.570.241.68600.00
messages received15631-80.1328.257.53-73.351.577.28363.695.381.63-69.70
messages sent15631-80.1328.257.53-73.351.577.28363.695.381.63-69.70
no work - consistent read gets10,1752,746-73.011,842.49666.88-63.81102.51644.75528.96350.86144.53-58.81
parse count (hard)1262416.672.1715.06594.010.1214.5612,033.330.413.26695.12
parse time cpu71157.141.272.67110.240.072.583,585.710.240.58141.67
physical read IO requests28154450.005.0737.40637.670.2836.1612,814.290.978.11736.08
physical read bytes229,3761,261,568450.0041,535.40306,377.01637.632,310.81296,212.2612,718.557,909.5266,398.32739.47
physical read total IO requests833282-66.15150.8468.48-54.608.3966.21689.1528.7214.84-48.33
physical read total bytes13,361,1523,317,760-75.172,419,436.98805,731.75-66.70134,604.90778,999.77478.73460,729.38174,618.95-62.10
physical reads cache28154450.005.0737.40637.670.2836.1612,814.290.978.11736.08
physical write IO requests172017.653.084.8657.790.174.702,664.710.591.0577.97
physical write bytes180,224163,840-9.0932,634.9639,789.2221.921,815.6438,469.122,018.766,214.628,623.1638.76
physical write total IO requests22952-77.2941.4712.63-69.542.3112.21428.577.902.74-65.32
physical write total bytes3,797,5041,418,240-62.65687,651.90344,425.45-49.9138,257.38332,998.36770.42130,948.4174,644.21-43.00
physical write total multi block requests42-50.000.720.49-31.940.040.471,075.000.140.11-21.43
process last non-idle time3,78113-99.66684.663.16-99.5438.093.05-91.99130.380.68-99.48
recursive calls3,8024,23411.36688.471,028.2449.3538.30994.132,495.64131.10222.8469.98
recursive cpu usage195131-32.8235.3131.81-9.911.9630.761,469.396.726.892.53
redo blocks checksummed by FG (exclusive)1,5291,340-12.36276.87325.4217.5415.40314.631,943.0552.7270.5333.78
redo blocks written2,3132,3863.16418.84579.4538.3523.30560.232,304.4279.76125.5857.45
redo entries1,1331,82460.99205.16442.97115.9111.41428.273,653.4639.0796.00145.71
redo ordering marks597832.2010.6818.9477.340.5918.313,003.392.034.11102.46
redo subscn max counts14217623.9425.7142.7466.241.4341.322,789.514.909.2688.98
redo synch writes61066.671.092.43122.940.062.353,816.670.210.53152.38
redo wastage50,4768,864-82.449,140.192,152.66-76.45508.512,081.24309.281,740.55466.53-73.20
redo write time210400.000.362.43575.000.022.3511,650.000.070.53657.14
redo writes13629-78.6824.637.04-71.421.376.81397.084.691.53-67.38
rollbacks only - consistent read gets31-66.670.540.24-55.560.030.23666.670.100.05-50.00
rows fetched via callback48774953.8088.19181.90106.264.91175.863,481.6716.7939.42134.78
session uga memory max10,404,73210,065,280-3.261,884,088.542,444,394.9029.74104,820.902,363,296.552,154.60358,783.86529,751.5847.65
shared hash latch upgrades - no wait261124-52.4947.2630.11-36.292.6329.111,006.849.006.53-27.44
sorts (memory)325131-59.6958.8531.81-45.953.2730.76840.6711.216.89-38.54
sorts (rows)6,3855,692-10.851,156.201,382.3319.5664.321,336.461,977.83220.17299.5836.07
switch current to new buffer2110-52.383.802.43-36.050.212.351,019.050.720.53-26.39
table fetch by rowid9532,133123.82172.57518.01200.179.60500.825,116.8832.86112.26241.63
table scan blocks gotten9,435160-98.301,708.4938.86-97.7395.0537.57-60.47325.348.42-97.41
table scan rows gotten629,41016,293-97.41113,973.543,956.82-96.536,340.903,825.55-39.6721,703.79857.53-96.05
table scans (short tables)8231-62.2014.857.53-49.290.837.28777.112.831.63-42.40
total number of times SMON posted14300.000.180.97438.890.010.949,300.000.030.21600.00
undo change vector size301,020405,51234.7154,508.6998,480.2780.673,032.5895,212.963,039.6710,380.0021,342.74105.61


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function - Data Rate per Second

Total Reads Buffer Cache Reads Direct Reads Total Writes DBWR Direct Writes LGWR
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
0.130.70438.460.000.23100.000.000.000.000.040.23475.000.010.00-100.000.000.000.000.000.23100.00


Back to IO Stats
Back to Top

IOStat by Function - Requests per Second

Total Reads Buffer Cache Reads Direct Reads Total Writes DBWR Direct Writes LGWR
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
8.3960.81624.790.2829.8210,550.000.000.000.002.3412.68441.880.170.00-100.000.000.94100.001.417.04399.29


Back to IO Stats
Back to Top

IOStat by File Type - Data Rate per Second

Total Reads Data File Reads Temp File Reads Total Writes Data File Writes Temp File Writes Log File Writes
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
0.120.70483.330.000.23100.000.000.000.000.030.23666.670.000.000.000.000.000.000.010.232,200.00


Back to IO Stats
Back to Top

IOStat by File Type - Requests per Second

Total Reads Data File Reads Temp File Reads Total Writes Data File Writes Temp File Writes Log File Writes
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
8.3960.58622.050.3530.768,688.570.000.000.002.3212.68446.550.184.702,511.110.000.000.001.417.04399.29


Back to IO Stats
Back to Top

Tablespace IO Stats

 Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
Tablespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
SYSAUX 0.2422.079,095.830.084.705,775.00249425.009.791.001.00820000.000.000.3226.7726.44


Back to IO Stats
Back to Top

Top File Comparison by IO

  Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
TablespaceFilename1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
SYSAUXC:\ORACLE\ORADATA\PWL2\SYSAUX01.DBF  22.07100.00 4.70100.00 94 9.79 1.00 20 0 0.00 26.77 


Back to IO Stats
Back to Top

Top File Comparison by Read Time

  Read Time % of DB time Avg Read Time (ms) Reads Avg Reads per Sec Avg Blocks per Read Writes Avg Writes per Sec Buffer Waits Avg Buf Wait Time (ms)
TablespaceFilename1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
SYSAUXC:\ORACLE\ORADATA\PWL2\SYSAUX01.DBF  22.3422.34 9.79 94 22.07 1.00 20 4.70 0 0.00


Back to IO Stats
Back to Top

Top File Comparison by Buffer Waits

No data exists for this section of the report.

Back to IO Stats
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Target MTTR(s)Estimated MTTR(s)Recovery Estimated IOsActual Redo Blocks Target Redo Blocks Log File Size Redo Blocks Log Ckpt Timeout Redo Blocks Log Ckpt Interval Redo Blocks Optimal Log File Size (Mb)Estimated Cluster Available Time (s)
B10171863903,864184,3203,864   
E10175272,6805,768184,3205,768   
           
B20165114,498165,888165,888    
E20168726,884165,888165,888    


Back to Advisory Statistics
Back to Top

PGA Aggregate Summary

PGA Cache Hit % W/A Bytes/Sec (DB time) W/A MB Processed Read/Written W/A Bytes/Sec (DB time) Read/Written W/A MB
1st2ndDiff1st2nd%Diff1st2nd1st2nd%Diff1st2nd
100.00100.000.005,241,8047,835,99049.492831000.0000


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)
         


Back to Advisory Statistics
Back to Top

Wait Stats

Back to Top

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Stats
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Stats
Back to Top

Undo Segment Summary

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



Back to Top

Latch Statistics

Back to Top

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Wait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
JS Sh mem access0.00100.00100.001301000101414


Back to Latch Statistics
Back to Top

Latch Wait Time Breakdown

 Wait Time (cs) Get Requests Misses Spin Gets Sleeps % of Total Sleeps
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
JS Sh mem access01414130100010.00100.00100.00


Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Top Segments Comparison by Logical Reads

     % of Total Logical Reads Logical Reads % of Captured Logical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
MYAPPUSERSACCOUNTS TABLE63.3663.36  -63.369,056  73.60 -73.60
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.7864.149.179.178.39112848657.140.9112.5311.62
SYSSYSTEMSYS_C00643 INDEX  4.6713.844.67 432  6.386.38
SYSSYSAUXWRH$_SQL_PLAN TABLE1.1265.264.8518.693.73160448180.001.306.625.32
SYSSYSTEMI_ARGUMENT2 INDEX  3.4622.153.46 320  4.734.73
SYSSYSTEMI_OBJ1 INDEX0.4565.713.8125.963.3664352450.000.525.204.68
SYSSYSAUXSMON_SCN_TIME TABLE1.4667.16  -1.46208  1.69 -1.69
SYSSYSTEMI_SYSAUTH1 INDEX2.2469.401.3827.34-0.85320128-60.002.601.89-0.71
SYSSYSAUXWRI$_ADV_PARAMETERS_PK INDEX2.1371.532.9430.280.82304272-10.532.474.021.55
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE1.1272.651.7332.010.611601600.001.302.361.06


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Reads

     % of Total Physical Reads Physical Reads % of Captured Physical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMIDL_UB1$ TABLE  43.5143.5143.51 67  60.9160.91
SYSSYSAUXSMON_SCN_TIME TABLE17.8617.86  -17.865  25.00 -25.00
SYSSYSAUXWRI$_ADV_MSG_GRPS_IDX_01 INDEX14.2932.14  -14.294  20.00 -20.00
SYSSYSAUXWRH$_LATCHWRH$_LATCH_4252952393_43TABLE PARTITION10.7142.86  -10.713  15.00 -15.00
SYSSYSAUXWRH$_SQLSTATWRH$_SQLSTA_4252952393_43TABLE PARTITION7.1450.00  -7.142  10.00 -10.00
SYSSYSAUXWRH$_SQL_BIND_METADATA_PK INDEX0.0050.003.2546.753.2505100.000.004.554.55
SYSSYSAUXWRH$_SQL_PLAN TABLE10.7160.717.7954.55-2.92312300.0015.0010.91-4.09
SYSSYSTEMARGUMENT$ TABLE  1.9556.491.95 3  2.732.73
SYSSYSAUXWRH$_SYS_TIME_MODEL_PKWRH$_SYS_TI_466883936_0INDEX PARTITION  1.9558.441.95 3  2.732.73


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Read Requests

     % of Total Read Requests Read Requests % of Captured Read Requests
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMIDL_UB1$ TABLE  43.5143.5143.51 67  60.9160.91
SYSSYSAUXWRH$_SQL_PLAN TABLE  7.7951.307.79 12  10.9110.91
SYSSYSAUXWRH$_SQL_BIND_METADATA_PK INDEX  3.2554.553.25 5  4.554.55
SYSSYSTEMARGUMENT$ TABLE  1.9556.491.95 3  2.732.73
SYSSYSAUXWRH$_SYS_TIME_MODEL_PKWRH$_SYS_TI_466883936_0INDEX PARTITION  1.9558.441.95 3  2.732.73
SYSSYSTEMI_DEPENDENCY2 INDEX    0.00     0.00
SYSSYSTEMI_OBJ1 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMI_OBJ2 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMUSER$ TABLE    0.00     0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by UnOptimized Read Requests

     % of Total UnOptimized Requests UnOptimized Requests % of Captured UnOptimized Reqs
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMIDL_UB1$ TABLE  43.5143.5143.51 67  60.9160.91
SYSSYSAUXWRH$_SQL_PLAN TABLE  7.7951.307.79 12  10.9110.91
SYSSYSAUXWRH$_SQL_BIND_METADATA_PK INDEX  3.2554.553.25 5  4.554.55
SYSSYSTEMARGUMENT$ TABLE  1.9556.491.95 3  2.732.73
SYSSYSAUXWRH$_SYS_TIME_MODEL_PKWRH$_SYS_TI_466883936_0INDEX PARTITION  1.9558.441.95 3  2.732.73
SYSSYSTEMI_DEPENDENCY2 INDEX    0.00     0.00
SYSSYSTEMI_OBJ1 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMI_OBJ2 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX  0.0058.440.00 0  0.000.00
SYSSYSTEMUSER$ TABLE    0.00     0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Optimized Read Requests

     % of Total Optimized Read Requests Optimized Requests % of Captured Optimized Reqs
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMACCESS$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_ACCESS1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_DEPENDENCY2 INDEX    0.00     0.00
SYSSYSTEMI_OBJ1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_OBJ2 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE    0.00     0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Reads

     % of Total Direct Reads Direct Reads % of Captured Direct Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMACCESS$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_ACCESS1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_DEPENDENCY2 INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMI_OBJ2 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMI_SYSAUTH1 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMOBJ$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE0.000.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Writes

     % of Total Physical Writes Physical Writes % of Captured Physical Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB  65.0065.0065.00 13  65.0065.00
SYSSYSAUXSYS_LOB0000006331C00004$$ LOB  35.00100.0035.00 7  35.0035.00
SYSSYSAUXSMON_SCN_TIME TABLE9.099.09  -9.092  50.00 -50.00
SYSSYSTEMI_JOB_NEXT INDEX4.5513.64  -4.551  25.00 -25.00
SYSMANSYSAUXMGMT_COLLECTION_WORKERS_PK INDEX4.5518.18  -4.551  25.00 -25.00
SYSSYSTEMI_OBJ1 INDEX0.0018.180.00100.000.00000.000.000.000.00
SYSSYSTEMI_OBJ2 INDEX0.0018.180.00100.000.00000.000.000.000.00
SYSSYSTEMOBJ$ TABLE  0.00100.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE0.0018.18  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Write Requests

     % of Total Write Requests Write Requests % of Captured Write Requests
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB  65.0065.0065.00 13  65.0065.00
SYSSYSAUXSYS_LOB0000006331C00004$$ LOB  35.00100.0035.00 7  35.0035.00
SYSSYSTEMI_DEPENDENCY2 INDEX    0.00     0.00
SYSSYSTEMI_OBJ1 INDEX  0.00100.000.00 0  0.000.00
SYSSYSTEMI_OBJ2 INDEX  0.00100.000.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX  0.00100.000.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE  0.00100.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE    0.00     0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Writes

     % of Total Direct Writes Direct Writes % of Captured Direct Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB  65.0065.0065.00 13  65.0065.00
SYSSYSAUXSYS_LOB0000006331C00004$$ LOB  35.00100.0035.00 7  35.0035.00
SYSSYSTEMI_DEPENDENCY2 INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX0.000.000.00100.000.00000.000.000.000.00
SYSSYSTEMI_OBJ2 INDEX0.000.000.00100.000.00000.000.000.000.00
SYSSYSTEMI_SYSAUTH1 INDEX0.000.000.00100.000.00000.000.000.000.00
SYSSYSTEMOBJ$ TABLE  0.00100.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE0.000.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Table Scans

     % of Total Table Scans Table Scans % of Captured Table Scans
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMI_OBJ2 INDEX100.00100.000.000.00-100.0010-100.00100.000.00-100.00
SYSSYSTEMACCESS$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_ACCESS1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_DEPENDENCY2 INDEX0.00100.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX0.00100.000.000.000.00000.000.000.000.00
SYSSYSTEMI_SYSAUTH1 INDEX0.00100.000.000.000.00000.000.000.000.00
SYSSYSTEMOBJ$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE0.00100.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by DB Block Changes

     % of Total Block Changes DB Block Changes % of Captured Block Changes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.000.0010.8610.8610.860400100.000.0031.6531.65
SYSSYSAUXWRH$_SQL_PLAN TABLE4.144.148.6919.544.5596320233.3312.0025.3213.32
SYSSYSTEMMON_MODS$ TABLE4.148.27  -4.1496  12.00 -12.00
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE3.4511.720.4319.98-3.018016-80.0010.001.27-8.73
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_4252952393_43INDEX PARTITION2.7614.48  -2.7664  8.00 -8.00
SYSSYSAUXWRI$_ADV_PARAMETERS_PK INDEX3.4517.920.8720.85-2.588032-60.0010.002.53-7.47
SYSSYSAUXWRH$_SQLSTAT_INDEXWRH$_SQLSTA_466883936_0INDEX PARTITION  2.1723.022.17 80  6.336.33
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX  1.7424.761.74 64  5.065.06
SYSSYSAUXWRH$_SYSSTAT_PKWRH$_SYSSTA_466883936_0INDEX PARTITION  1.3026.061.30 48  3.803.80


Back to Segment Statistics
Back to Top

Top Segments by Row Lock Waits

     % of Total Row Lock Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd%Diff1st1st Total2nd2nd TotalDiff
SYSSYSAUXWRH$_SGASTAT_UWRH$_SGASTA_4252952393_43INDEX PARTITION200.00 -200.002  100.00100.00  -100.00
SYSSYSTEMWRR$_REPLAYS TABLE 100.00100.00 1   100.00100.00100.00


Back to Segment Statistics
Back to Top

Top Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Top Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Top Segments by GC Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

 Get Requests per Sec (DB time) Get Requests per Sec (Elapsed Time) Get Requests Pct Miss Scan Requests Pct Miss Mod Reqs Final Usage
Cache1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
dc_awr_control1.091.7055.960.061.642,633.33670.000.00000.000.002211
dc_database_links0.36  0.02  2 0.00 0 0.00 0 1 
dc_global_oids4.352.19-49.660.242.11779.172490.000.00000.000.0000277322
dc_histogram_data0.008.26100.000.007.98100.000340.000.00000.000.0000836791
dc_histogram_defs12.31112.20811.450.69108.4815,621.74684620.0013.42000.000.00005,9435,418
dc_object_grants5.6132.54480.040.3131.4610,048.39311340.000.00000.000.0000387395
dc_objects61.02160.28162.673.40154.974,457.943376600.0011.36000.000.00036,6954,070
dc_profiles0.720.9734.720.040.942,250.00440.000.00000.000.000022
dc_rollback_segments7.790.00-100.000.430.00-100.004300.000.00000.000.00002222
dc_segments6.7030.11349.400.3729.117,767.57371240.004.84000.000.00541,2561,624
dc_sequences0.000.49100.000.000.47100.00020.0050.00000.000.00021510
dc_tablespaces32.0546.6345.491.7845.082,432.581771920.000.00000.000.000077
dc_users67.36103.7053.953.75100.262,573.603724270.000.47000.000.0000739168
global database name18.111.94-89.291.011.8886.1410080.000.00000.000.000022
outstanding_alerts1.2744.203,380.310.0742.7360,942.8671820.000.00000.000.00026184
sch_lj_objs0.000.24100.000.000.23100.00010.00100.00000.000.000021
sch_lj_oids0.000.49100.000.000.47100.00020.0050.00000.000.000003



Back to Top

Library Cache Activity

 Get Requests per Sec (DB Time) Get Requests per Sec (Elapsed Time) Get Requests Pct Miss Pin Requests Pct Miss Reloads Invalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
ACCOUNT_STATUS 1.46  1.41  6 0.00 0   0 0
APP CONTEXT 0.00  0.00  0   7 0.00 0 0
BODY13.048.74-32.980.738.451,057.5372360.0011.1178560.008.930000
CLUSTER0.000.73100.000.000.70100.0003 0.0003 0.000000
DBLINK 1.46  1.41  6 0.00 0   0 0
EDITION 0.97  0.94  4 0.00 7 0.00 0 0
OBJECT ID 0.24  0.23  1 100.00 0   0 0
QUEUE 1.70  1.64  7 0.00 69 0.00 0 0
RULESET 0.49  0.47  2 0.00 2 50.00 1 0
SCHEMA 7.77  7.51  32 3.13 0   0 0
SQL AREA55.05107.8395.883.06104.253,306.863044440.6638.511,1421,2022.1913.3901900
SQL AREA BUILD 13.84  13.38  57 89.47 0   0 0
SQL AREA STATS 12.63  12.21  52 98.08 52 98.08 0 0
SUBSCRIPTION 0.49  0.47  2 0.00 2 0.00 0 0
TABLE/PROCEDURE32.9674.80126.941.8372.323,851.911823080.0017.864075340.005.240700
TRIGGER3.800.00-100.000.210.00-100.002100.00 2100.00 0000



Back to Top

Memory Statistics

Back to Top

Process Memory Summary

  1st 2nd % Diff of
CategorySummaryBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
FreeableAlloc (KB)   32,192.0031,808.00-1.19  
Used (KB)   0.000.000.00  
Avg Alloc (KB)   1,463.271,514.673.51  
Std Dev Alloc (KB)   2,489.102,536.401.90  
Max Alloc (KB) 11,776.00 11,776.0011,776.000.00  
Hist Max Alloc (KB)        
Num Procs   22.0021.00-4.55  
Num Alloc   22.0021.00-4.55  
OtherAlloc (KB)46,531.6156,844.2022.1694,582.3493,178.58-1.48103.2663.92
Used (KB)        
Avg Alloc (KB)1,661.841,960.1417.951,970.471,982.520.6118.571.14
Std Dev Alloc (KB)1,882.442,388.1926.871,776.291,760.03-0.92-5.64-26.30
Max Alloc (KB)9,401.569,000.245.169,000.249,000.240.00-4.27-8.97
Hist Max Alloc (KB)22,925.5822,925.580.0020,220.1420,220.140.00-11.80-11.80
Num Procs28.0029.003.5748.0047.00-2.0871.4362.07
Num Alloc28.0029.003.5748.0047.00-2.0871.4362.07
PL/SQLAlloc (KB)249.21263.725.8216,061.7816,224.401.016,344.956,052.07
Used (KB)131.61121.99-7.3114,184.6614,444.401.8310,678.1711,740.81
Avg Alloc (KB)9.599.771.90349.17360.543.263,542.803,591.24
Std Dev Alloc (KB)15.7815.00-4.93579.53584.700.893,573.073,798.07
Max Alloc (KB)55.682,022.900.002,022.902,022.900.003,533.353,533.35
Hist Max Alloc (KB)184.51184.510.002,159.722,159.720.001,070.501,070.50
Num Procs26.0027.003.8546.0045.00-2.1776.9266.67
Num Alloc26.0027.003.8546.0045.00-2.1776.9266.67
SQLAlloc (KB)955.71936.30-2.032,540.722,562.540.86165.85173.69
Used (KB)436.04417.85-4.17817.00846.183.5787.37102.51
Avg Alloc (KB)59.7355.08-7.7976.9980.084.0128.9045.40
Std Dev Alloc (KB)51.1248.39-5.34114.68119.043.80124.33146.00
Max Alloc (KB)134.87650.110.00627.72650.113.57365.43382.04
Hist Max Alloc (KB)8,150.248,150.240.0019,759.4719,759.470.00142.44142.44
Num Procs16.0017.006.2533.0032.00-3.03106.2588.24
Num Alloc13.0014.007.6928.0028.000.00115.38100.00


Back to Memory Statistics
Back to Top

SGA Memory Summary

 1st 2nd % Diff of
SGA regionsBegin Value (KB)End Value (KB)%DiffBegin Value (KB)End Value (KB)%DiffBegin ValuesEnd Values
Database Buffers524,288.00524,288.000.00540,672.00540,672.000.003.133.13
Fixed Size1,303.111,303.110.002,202.992,202.990.0069.0669.06
Redo Buffers4,536.004,536.000.006,708.006,708.000.0047.8847.88
Variable Size516,096.89516,096.890.001,114,113.011,114,113.010.00115.87115.87


Back to Memory Statistics
Back to Top

SGA Breakdown Difference

  1st 2nd %Diff of
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
java poolfree memory6,935,1046,935,1040.0016,777,21616,777,2160.00141.92141.92
java pooljoxlod exec hp9,459,0729,459,0720.00     
java pooljoxs heap383,040383,0400.00     
large poolPX msg pool   491,520491,5200.00  
large poolfree memory8,324,1608,324,1600.0016,076,80016,285,6961.3093.1395.64
large poolkecp: Rep. SSOs   208,896    
shared poolASH buffers   4,194,3044,194,3040.00  
shared poolCCursor27,029,30027,115,3240.32     
shared poolHeap0: KGL8,335,0968,335,0960.00     
shared poolKCB Table Scan Buffer   4,194,8164,194,8160.00  
shared poolKGL handle11,618,82011,621,4760.02     
shared poolKGLH0   62,869,76063,389,0560.83  
shared poolKGLHD   12,149,12812,313,8961.36  
shared poolKGLS   12,646,00012,568,896-0.61  
shared poolKGLS heap11,120,28411,120,2840.00     
shared poolKGLSG   5,266,0085,266,0080.00  
shared poolKQR L PO   4,335,6564,382,7601.09  
shared poolKQR M PO6,513,8246,513,8240.003,931,6563,936,2640.12-39.64-39.57
shared poolKSFD SGA I/O b   4,190,3284,190,3280.00  
shared poolPCursor9,263,7609,266,9240.03     
shared poolPL/SQL DIANA13,580,70813,580,7080.00     
shared poolPL/SQL MPCODE18,424,14018,424,1400.00     
shared poolPLDIA   4,900,3924,831,192-1.41  
shared poolPLMCD   14,104,68813,667,672-3.10  
shared poolSQLA   89,898,60890,472,2400.64  
shared poolXDB Schema Cac7,203,0247,203,0240.00     
shared poolXDBSC   14,813,76814,813,7680.00  
shared pooldb_block_hash_buckets   5,836,8005,836,8000.00  
shared pooldbwriter coalesce buffer   4,194,8164,194,8160.00  
shared poolfree memory59,931,08059,680,660-0.4256,982,55256,302,280-1.19-4.92-5.66
shared poolkglsim hash table bkts   4,194,3044,194,3040.00  
shared poolrow cache   7,593,7047,593,7040.00  
shared poolsql area233,164,132233,290,5600.05     
streams poolKTG hash buckets   1,320,4321,320,4320.00  
streams poolfree memory16,726,71616,726,7160.0032,224,28832,223,984-0.0092.6592.65
 buffer_cache536,870,912536,870,9120.00553,648,128553,648,1280.003.133.13
 fixed_sga1,334,3801,334,3800.002,255,8642,255,8640.0069.0669.06
 log_buffer4,644,8644,644,8640.006,868,9926,868,9920.0047.8847.88


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams by CPU Time

 CPU Time (sec) User I/O Time (sec) System I/O Time (sec)
Session Type1st2nd%Diff1st2nd%Diff1st2nd%Diff
QMON Slaves0.000.06100.000.000.000.000.000.000.00
QMON Coordinator0.000.000.000.000.000.000.000.000.00


Back to Streams Statistics
Back to Top

Streams by IO Time

 IO Time (sec) CPU Time (sec)
Session Type1st User1st System1st Total2nd User2nd System2nd TotalTotal %Diff1st2nd%Diff
QMON Coordinator0.000.000.000.000.000.000.000.000.000.00
QMON Slaves0.000.000.000.000.000.000.000.000.06100.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 Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

 Evals No-SQL Eval% SQL Execs CPU(s) Ela(s) Eval/Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads
Ruleset Name1st2nd%Diff1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE_R 2100.00 0.00 00.00 0.02100.00 0.03100.00 0.47100.00 0.000.00 0.02100.00 0.01100.00 1100.00


Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

 Ela(s) No-SQL Eval% SQL Execs CPU(s) Evals Eval/Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads
Ruleset Name1st2nd%Diff1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE_R 0.03100.00 0.00 00.00 0.02100.00 2100.00 0.47100.00 0.000.00 0.02100.00 0.01100.00 1100.00


Back to Streams Statistics
Back to Top

Persistent Queues

 Enq Msgs Deq Msgs %Delay Msgs %Exp Msgs Enq Time(s) Deq Time(s) %Transf Time %Eval Time
Queue Name1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd%Diff1st2nd%Diff1st2nd1st2nd
SYS.ALERT_QUE(12733)  2100.00 00.00 100.00 0.00 0.05100.00 2.52100.00 0.00 57.74
SYSMAN.MGMT_TASK_Q(64111) 1 -100.001 -100.000.00 0.00 0.00 0.000.00 0.00    
SYS.ALERT_QUE(11324) 0 0.000 0.00    0.00 0.000.00 0.00    
SYSMAN.MGMT_NOTIFY_Q(64433) 0 0.000 0.00    0.00 0.000.00 0.00    
SYSMAN.MGMT_NOTIFY_Q(69041)  00.00 00.00     0.000.00 0.000.00    
SYSMAN.MGMT_TASK_Q(68711)  00.00 00.00     0.000.00 0.000.00    


Back to Streams Statistics
Back to Top

Persistent Queues Rate

 Enqueue Msgs/sec Dequeue Msgs/sec Avg Enqueue sec / msg Avg Dequeue sec / msg
Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE(12733)  0.47100.00 0.000.00 0.03100.00  0.00
SYSMAN.MGMT_TASK_Q(64111) 0.01 -100.000.01 -100.000.00 0.000.00 0.00
SYS.ALERT_QUE(11324) 0.00 0.000.00 0.00  0.00  0.00
SYSMAN.MGMT_NOTIFY_Q(64433) 0.00 0.000.00 0.00  0.00  0.00
SYSMAN.MGMT_NOTIFY_Q(69041)  0.000.00 0.000.00  0.00  0.00
SYSMAN.MGMT_TASK_Q(68711)  0.000.00 0.000.00  0.00  0.00


Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

 Enqueue Msgs Dequeue Msgs Expire Msgs Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec
Subscriber/Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
PDBH_1831_PWL2(41)/SYS.ALERT_QUE  2100.00 2100.00 00.00 0.47100.00 0.47100.00 0.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000.00000.00000.00  0.00  0.00  0.00
PDBH_3938_PWHD(41)/SYS.ALERT_QUE 0 0.000 0.000 0.000.00 0.000.00 0.000.00 0.00


Back to Streams Statistics
Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec Dispatcher Queue Per Sec Server Messages Per Sec Server KB Per Sec Common Queue Total Dispatcher Queue Total Server Total Messages Server Total KB
1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
 0.000.00  0.000.00  0.000.00  0.000.00  0  0  0  0 


Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s) %Busy %Idle Incoming Net % Outgoing Net %
1st2nd%Diff1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
 4  0.000.00 100.00100.00 0.000.00 0.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

Avg Connections (per Dispatcher) Avg %Busy Avg %Idle Total Queued (all Dispatchers) Average Queued per Dispatcher Average Queued Wait (ms)
1st2nd%Diff1st2ndDiff1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
    0.000.00 100.00100.00 0  0    


Back to Shared Server Statistics
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
__db_cache_size 536870912 553648128
__java_pool_size 16777216  
__large_pool_size 8388608 16777216
__oracle_base C:\oracle  
__pga_aggregate_target 629145600 687865856
__sga_target 1073741824 1023410176
__shared_io_pool_size 0  
__shared_pool_size 486539264 385875968
__streams_pool_size 16777216 33554432
audit_file_dest C:\ORACLE\ADMIN\PWHD\ADUMP C:\ORACLE\ADMIN\PWL2\ADUMP
audit_trail DB  
compatible 11.1.0.0.0 11.2.0.0.0
control_files C:\ORACLE\ORADATA\PWHD\CONTROLFI C:\ORACLE\ORADATA\PWL2\CONTROL01
db_block_size 8192  
db_create_file_dest C:\oracle\oradata (DEFAULT)
db_domain    
db_name PWHD PWL2
db_recovery_file_dest (DEFAULT) C:\oracle\fast_recovery_area
db_recovery_file_dest_size (DEFAULT) 4322230272
diagnostic_dest C:\ORACLE  
dispatchers (PROTOCOL=TCP) (SERVICE=PWHDXDB) (PROTOCOL=TCP) (SERVICE=PWL2XDB)
local_listener (DEFAULT) LISTENER_PWL2
memory_target 1702887424 1711276032
open_cursors 300  
processes 150  
remote_login_passwordfile EXCLUSIVE  
undo_tablespace UNDOTBS1  


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
control_files  (NULL)  C:\ORACLE\FAST_RECOVERY_AREA\PWL2\CONTROL02.CTL
  (NULL)  C:\ORACLE\ORADATA\PWL2\CONTROL01.CTL


Back to init.ora Parameters
Back to Top

Complete List of SQL Text

SQL IdSQL Text
062savj8zgzutUPDATE sys.wri$_adv_parameters SET datatype = :1, value = :2, flags = :3, description = :4 WHERE task_id = :5 AND name = :6
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
0tu45m00jq66aBEGIN DBMS_WORKLOAD_CAPTURE.START_CAPTURE ( name => 'capture2', dir => 'DBREPLAY2', default_action => 'INCLUDE' ); END;
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
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')
0z1031991bd7winsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
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))
1cd2krbdzrhvqinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ftio.kcftiopyr, ftio.kcftiopyw, ftio.kcftiosbr, floor(ftio.kcftioprt / 10000), floor(ftio.kcftiopwt / 10000), floor(ftio.kcftiosbt / 10000), ftio.kcftiopbr, ftio.kcftiopbw, fw.count, fw.time from x$kcftio ftio, x$kcctf tf, x$kcbfwait fw, x$kccfn fn, x$kccts ts where ts.tstsn = tf.tftsn and ftio.kcftiofno = fn.fnfno and tf.tfnum = fn.fnfno and tf.tffnh = fn.fnnum and tf.tfdup <> 0 and fn.fntyp = 7 and fn.fnnam is not null and bitand(tf.tfsta, 32) <> 32 and fw.indx+1 = (fn.fnfno + :db_files)
1cq3qr774cu45insert 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)
1gfaj4z5hn1kfdelete from dependency$ where d_obj#=:1
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1qjpw4wb8sbdpselect max(created) from accounts where status = 'INVALID'
1rswbxwhbpmr7select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time), a.obj#, decode(bitand(a.flags, 16384), 0, 0, 1), a.sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q UNION ALL select j.job, 0, cast(j.next_date as timestamp with time zone), 1, NULL, cast(j.next_date as timestamp with time zone), NULL, 0 from sys.job$ j where (:1 = 1) and (j.field1 is null or j.field1 = 0) and j.job not in (select v.id2 from v$lock v where v.type = 'JQ')) a where bitand(a.job_status, 3) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 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 decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) = (select min(decode(bitand(c.flags, 16384), 0, c.next_run_date, c.last_enabled_time)) from (select r.flags flags, r.next_run_date next_run_date, r.job_status job_status, r.class_oid class_oid, r.last_enabled_time last_enabled_time, r.instance_id instance_id from sys.scheduler$_job r UNION ALL select s.flags, s.next_run_date, s.job_status, s.class_oid, s.last_enabled_time, s.instance_id from sys.scheduler$_lightweight_job s UNION ALL select 0, cast(k.next_date as timestamp with time zone), 1, NULL, cast(k.next_date as timestamp with time zone), NULL from sys.job$ k where (:2 = 1) and (k.field1 is null or k.field1 = 0) and k.job not in (select w.id2 from v$lock w where w.type = 'JQ')) c where bitand(c.job_status, 3) = 1 and ((bitand(c.flags, 134217728 + 268435456) = 0) or (bitand(c.job_status, 1024) <> 0)) and bitand(c.flags, 4096) = 0 and c.instance_id is NULL and (c.class_oid is null or (c.class_oid is not null and c.class_oid in (select d.obj# from sys.scheduler$_class d where d.affinity is null))))
1tn90bbpyjshqUPDATE wrh$_tempfile tfh SET (snap_id, filename, tsname) = (SELECT :lah_snap_id, tf.name name, ts.name tsname FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change#) WHERE (file#, creation_change#) IN (SELECT tf.tfnum, to_number(tf.tfcrc_scn) creation_change# FROM x$kcctf tf WHERE tf.tfdup != 0) AND dbid = :dbid AND snap_id < :snap_id
20vv6ttajyjzqdelete from access$ where d_obj#=:1
270jvdqbxdub5 select NUM_CLIENTS, SYNCHRONIZATION, THINK_TIME_AUTO_CORRECT, THINK_TIME_SCALE, CONNECT_TIME_SCALE , SCALE_UP_MULTIPLIER from sys.dba_workload_replays where STATUS = 'IN PROGRESS'
27wht2mxm7sjh/* OracleOEM */ BEGIN :message := dbms_server_alert.expand_message(:language, :message_id, :argument_1, :argument_2, :argument_3, :argument_4, :argument_5); END;
2cb3nbu3mauzpinsert into sys.scheduler$_job (program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags, obj#) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54)
2ggpbty3yfyxrSELECT TO_DATE( TO_CHAR(SYSTIMESTAMP AT TIME ZONE DBTIMEZONE, :B1 ), :B1 ) FROM DUAL
2r80d5wbd6u9d SELECT post_commit_scn, nvl(lead(post_commit_scn) over (order by post_commit_scn, stream_id) , 0) as lead_post_commit_scn, nvl(stream_id, 0) as stream_id, nvl(lead(stream_id) over (order by post_commit_scn, stream_id) , 0) as lead_stream_id FROM (SELECT * FROM (SELECT post_commit_scn, stream_id, dense_rank() over (order by post_commit_scn) as rnk FROM WRR$_REPLAY_SCN_ORDER WHERE valid = 'Y' AND post_commit_scn >= :pcscn ORDER BY post_commit_scn asc, stream_id asc) WHERE rnk <= :maxrows) ORDER BY post_commit_scn, stream_id
2tkw12w5k68vdselect user#, password, datats#, tempts#, type#, defrole, resource$, ptime, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1, spare4, ext_username, spare2 from user$ where name=:1
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6insert 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#
35y2u24f4rxqminsert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3nkd3g3ju5ph1select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3s58mgk0uy2wsinsert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
3z5b10rcvwbc0BEGIN dbms_workload_replay.start_replay(); END;
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4677dt963h4pvBEGIN DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE ( ); END;
4tg8mr2bvy6grselect smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
561frs7bf8c79INSERT INTO WRR$_CAPTURE_STATS( ID, INSTANCE_NUMBER, STARTUP_TIME, PARALLEL, HOST_NAME, CAPTURE_SIZE, DBTIME, USER_CALLS, USER_CALLS_EMPTY, TXNS, CONNECTS, ERRORS) VALUES (:B1 , :B2 , :B3 , :B12 , :B11 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 )
586b2udq6dbnginsert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5a6ytgs4sp3u3SELECT a.default_action, b.name, b.attribute, b.value FROM dba_workload_replays a, dba_workload_filters b WHERE a.id = :1 AND b.type = :2 AND a.id = b.id
5ax5xu96u2ztdinsert into WRH$_EVENT_HISTOGRAM (snap_id, dbid, instance_number, event_id, wait_time_milli, wait_count) select :snap_id, :dbid, :instance_number, d.ksledhash, s.kslsesmaxdur, s.kslsesval from x$kslseshist s, x$ksled d where s.kslsesenum = d.indx and s.kslsesval > 0 order by d.ksledhash, s.kslsesmaxdur
5dfmd823r8dspinsert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5j0q2df7hm1k2INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
5zafwfnja12x3UPDATE WRR$_REPLAYS SET NUM_CLIENTS = NUM_CLIENTS + 1 WHERE ID = :B1
692wcvj50ytxzinsert into wrh$_resource_limit (snap_id, dbid, instance_number, resource_name, current_utilization, max_utilization, initial_allocation, limit_value) select :snap_id, :dbid, :instance_number, resource_name, current_utilization, max_utilization, initial_allocation, limit_value from v$resource_limit where limit_value != ' UNLIMITED' and max_utilization > 0
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6hwjmjgrpsuaainsert into wrh$_enqueue_stat (snap_id, dbid, instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#, cum_wait_time, event# from v$enqueue_statistics where total_req# != 0 order by eq_type, req_reason
6qz82dptj0qr7select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
71n72y1csrcfaDECLARE row_count NUMBER := 0; par VARCHAR2(10); host_n VARCHAR2(64); BEGIN select count(*) into row_count from wrr$_capture_stats where id = :recid and instance_number = :instid and startup_time = :starttime; IF (row_count > 0) THEN update wrr$_capture_stats set capture_size = :capsize, dbtime = :dbtime, user_calls = :usercalls, user_calls_empty = :ucallsempty, txns = :txns, connects = :connects, errors = :errnum where id = :recid and instance_number = :instid and startup_time = :starttime; ELSE select parallel, host_name into par, host_n from v$instance; insert into wrr$_capture_stats( id, instance_number, startup_time, parallel, host_name, capture_size, dbtime, user_calls, user_calls_empty, txns, connects, errors) values (:recid, :instid, :starttime, par, host_n, :capsize, :dbtime, :usercalls, :ucallsempty, :txns, :connects, :errnum); END IF; dbms_wrr_internal.update_capture_total_stats( :recid, :instid, :starttime ); END;
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7vgmvmy8vvb9sinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
803u6vwz0ah1p 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.next_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.class_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.name = 'CURRENT_OPEN_W INDOW' and e.value = f.name 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.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name 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
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
843z3698rn43rSELECT nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
87gaftwrm2h68select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8j1c23fa3f015begin :1 := dbms_workload_replay.client_connect( dbms_workload_replay.KECP_CLIENT_CONNECT_LOGIN ); end;
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
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
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9k43zr1uannr6select obj#, owner, node from syn$ where name=:1
9nn460aaugtasSELECT 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 e.affinity = :6)) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bm2pwrpcr8ru6select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
bqnn4c3gjtmguinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
bsa0wjtftg3uwselect file# from file$ where ts#=:1
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
bwsz40d3hc8q7insert into wrh$_librarycache (snap_id, dbid, instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations) select :snap_id, :dbid, :instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations from v$librarycache
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
ca3rwma7ccf9b SELECT startsn.stat_id, x.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYS_TIME_MODEL startsn , WRH$_SYS_TIME_MODEL endsn , X$KEHTIMMAP x WHERE endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid and startsn.stat_id = endsn.stat_id and startsn.stat_id = x.statistic# and x.statistic# != 0 GROUP BY startsn.stat_id, x.keh_id ORDER BY x.keh_id ASC
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cp3gpd7z878w8insert into wrh$_sgastat (snap_id, dbid, instance_number, pool, name, bytes) select :snap_id, :dbid, :instance_number, pool, name, bytes from (select pool, name, bytes, 100*(bytes) / (sum(bytes) over (partition by pool)) part_pct from v$sgastat) where part_pct >= 1 or pool is null or name = 'free memory' order by name, pool
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
dayq182sk41ksinsert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
dcstr36r0vz0dselect procedure#, procedurename, properties, itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc
dpyzg5dsn3g60insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
dwjfhksff9ypgselect dbms_workload_replay.get_advanced_parameter('DBMS_LOCK_SYNC'), dbms_workload_replay.get_advanced_parameter('MONITOR_CLIENTS') from dual
f0s0bk5k713ybinsert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instance_number, i.ksppihash hash, substr(sv.ksppstvl, 1, 512), sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#_%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '#_#_%' escape '#')) order by hash
fnk7155mk2jq6insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g5caq3p7yt68sselect max(created) from accounts where generated = 'Y'
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gg6zabzs8ra00update accounts set generated = 'N' where secondary = 'Y'
gx4mv66pvj3xzselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1


Back to Top