AWRRPT_HTML_TYPE_TABLE(AWRRPT_HTML_TYPE('AWR Compare Period Report for (1) DB: PWHD, Inst: pwhd, Snaps: 53-54 (2) DB: PWHD, Inst: pwhd, Snaps: 55-56'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('WORKLOAD REPOSITORY COMPARE PERIOD REPORT'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHostStd Block Size
First (1st)PWHD4252952393pwhd111.1.0.6.0NOPDBH8192
Second (2nd)PWHD4252952393pwhd111.1.0.6.0NOPDBH8192
'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st5313-Nov-11 14:04:13 (Sun)5413-Nov-11 14:05:07 (Sun) 1.06 0.90 0.96
2nd5513-Nov-11 14:21:42 (Sun)5613-Nov-11 14:22:03 (Sun) 1.19 0.34 0.41
%Diff     12.26 -62.22 -57.23
'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

Host Configuration Comparison

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
1st2ndDiff%Diff
Number of CPUs:2200.00
Number of CPU Cores:2200.00
Number of CPU Sockets:1100.00
Physical Memory:4056M4056M0M0.00
%User Time:54.7656.872.123.85
%System Time:5.475.97.519.14
%Idle Time:39.7837.15-2.62-6.61

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('System Configuration Comparison'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(' 16M'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
1st2ndDiff%Diff
SGA Target:   0M 0.00
  Buffer Cache: 696M 664M -32M -4.60
  Shared Pool Size: 240M 256M 16M 6.67
  Large Pool Size: 8M 8M 0M 0.00
  Java Pool Size: 16M 16M 0M 0.00
  Streams Pool Size: 0M 16M 100.00
Log Buffer: 4,536K 4,536K 0K 0.00
PGA Aggregate Target:   0M 0.00
Undo Management:AUTOAUTO  
'), AWRRPT_HTML_TYPE('

Load Profile

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 1.06 1.19 12.26 1.59 1.17 -26.42
CPU time: 1.02 1.07< span style="font-style:italic"> 4.90 1.53 1.05 -31.37
Redo size: 61,340.61 313,507.38 411.09 91,842.22 307,416.38 234.72
Logical reads: 22,044.27 21,979.41 -0.29 33,005.78 21,552.38 -34.70
Block changes: 368.84 1,568.72 325.31 552.25 1,538.24 178.54
Physical reads: 0.13 2.14 1,546.15 0.19 2.10 1,005.26
Physical writes: 10.35 18.21 75.94 15.50 17.86 15.23
User calls: 3.91 5.20 32.99 5.86 5.10 -12.97
Parses: 16.25 46.67 187.20 24.33 45.76 88.08
Hard parses: 0.02 13.79 68,850.00 0.03 13.52 44,966.67
Sorts: 11.98 25.35 111.60 17.94 24.86 38.57
Logons: 0.07 0.19 171.43 0.11 0.19 72.73
Executes: 301.11 348.14 15.62 450.83 341.38 -24.28
Transactions: 0.67 1.02 52.24   
'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
1st2ndDiff
% Blocks changed per Read: 1.67 7.14 5.46
Recursive Call %: 99.01 99.65 0.64
Rollback per transaction %: 8.33 4.76 -3.57
Rows per Sort: 8.80 17.40 8.61
Avg DB time per Call (sec): 0.27 0.23 -0.04
'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

Top Timed Events< /h3>'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
1st2nd
EventWait ClassWaitsTime(s)Avg Time(ms)%DB timeEventWait ClassWaitsTime(s)Avg Time(ms)%DB time
CPU time  55.05 96.06CPU time  21.95 89.54
control file sequential readSystem I/O7320.610.831.06control file sequential readSystem I/O7270.500.682.02
db file sequential readUser I/O70.1521.940.27db file sequential readUser I/O480.449.231.81
db file parallel writeSystem I/O1060.090.880.16resmgr:cpu quantumScheduler110.2724.501.10
resmgr:cpu quantumScheduler10.0993.120.16log file parallel writeSystem I/O460.183.810.71
-log file parallel writeSystem I/O470.030.630.05-db file parallel writeSystem I/O280.020.610.07

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Report Details'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Supplemental Information'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Time Model Statistics

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % of DB timeTime (seconds)Time per Trans (seconds)
Statistic Name1st2ndDiff1st2nd%Diff1st2nd%Diff
DB time100.00100.000.0057.3124.51-57.231.591.17-26.42
DB CPU96.0689.54-6.5255.0521.95-60.131.5 31.05-31.37
parse time elapsed0.064.524.460.031.113,600.000.000.05100.00
hard parse elapsed time0.004.384.380.001.07100.000.000.05100.00
PL/SQL execution elapsed time2.042.580.531.170.63-46.150.030.030.00
hard parse (sharing criteria) elapsed time0.000.510.510.000.12100.000.000.01100 .00
PL/SQL compilation elapsed time0.000.080.080.000.02100.000.000.000.00
connection management call elapsed time0.020.070.060.010.02100.000.000.000.00
sql execute elapsed time99.3199.350.0456.9124.35-57.211.581.16-26.58
repeated bind elapsed time0.230.22-0.010.130.05-61.540.000.000.00
sequence load elapsed t ime0.000.010.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 t0.000.000.000.000.000.000.000.000.00
failed parse elapsed time0.000.00 0.000.000.000.000.000.000.00
hard parse (bind mismatch) 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 time0.811.160.350.460.29-36.960.010.010.00
background cpu time0.050.060.010.030.02-33.330.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Operating System Statistics

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Value (centi-seconds)per Second (DB time)per Second (Elapsed Time)per Trans
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
AVG_BUSY_TIME3,2491,28856.6952.54-7.3260.2862.553.7790.2561.33 -32.04
AVG_IDLE_TIME2,14576137.4331.04-17.0739.8036.96-7.1459.5836.24-39.17
AVG_SYS_TIME2931225.114.98-2.545.445.928.828.145.81-28.62
AVG_USER_TIME2,9541,16651.5447.56-7.7254.8056.623.3282.0655.52-32.34
BUSY_TIME6,5002,578113.41105.16-7.27120.59125.193.81180.56122.76-32.01
IDLE_TIME4,2931,52474.9162.17-17.0179.6574.01-7.08119.2572.57-39.14
RSRC_MGR_CPU_WAIT_TIME9270.161.10587.500.171.31670.590.251.29416.00
SYS_TIME59024510.299.99-2.9210.9511.908.6816.3911.67-28.80
USER_TIME5,9102,333103.1295.17-7.71109.65113.303.33164.17111.10-32.33
VM_IN_BYTES143,36069,259,2642,501.372,825,285.87112,849.542,659.693,363,406.37126,358.593,982.223,298,060.1982,719.64
VM_OUT_BYTES000.000.000.000.000.000.000.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Wait Events'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Wait Classes

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRR PT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % of DB time# Waits/sec (Elapsed Time)Avg Wait Time (ms)
Wait Class1st2ndDiff1st2nd%Diff1st2nd%Diff
User I/O0.512.401.890.226.943,054.5524.124.11-82.96
System I/O1.322.831.5116.9039.58134.200.830.852.41
Scheduler0.161.100.940.020.532,550.0093.1224.50-73.69
Application0.000.160.160.070.05-28.570.2238.9117,586.36
Concurrency0.040.070.040.040.10150.0010.479.09-13.18
Network0.000.020.023.254.3734.460.010.07600.00
Commit0.01 0.030.020.200.58190.000.540.6724.07
Other0.000.010.010.000.34100.000.000.33100.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Wait Events'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Wait Events

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_ TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
  % of DB time# Waits/sec (Elapsed Time)Avg Wait Time (ms)
EventWait Class1st2ndDiff1st2nd%Diff1st2nd%Diff
db file sequential readUser I/O0.271.811.540.132.331,692.3121.949.23-57.93
control file sequential readSystem I/O1.062.020.9613.5835.30159.940.830.68-18.07
resmgr:cpu quantumScheduler0.161.100.940.020.532,550.0093.1224.50-73.69
log file parallel writeSystem I/O0.050.710.660.872.23156.320.633.81504.76
Data file init writeUser I/O0.000.530.530.000.44100.000.0014.53100.00
enq: TX - row lock contentionApplication0.000.160.160.000.05100.000.0038.91100.00
db file scattered readUser I/O0.130.00-0.120.040.0525.0036.060.54-98.50
db file parallel writeSystem I/O0.160.07-0.091.971.36-30.960.880.61-30.68
latch: shared poolConcurrency0.000.070.070.000.10100.000.009.09100.00
direct path writeUser I/O0.110.06-0.060.064.086,700.0021.250.16-99.25
os thread startupConcurrency0.040.00-0.040.020.00-100.0020.930.00-100.00
SQL*Net message to clientNetwork0.000.020.023.234.3735.290.010.07600.00
log file syncCommit0.010.030.020.200.58190.000.540.6724.07
control file parallel writeSystem I/O0.040.03-0.010.480.6841.670.940.48-48.94
rdbms ipc replyOther0.000.010.010.000.19100.000.000.56100.00
db file single writeUser I/O0.000.000.000.000.05100.000.000.39100.00
SQL*Net break/reset to clientApplication0.000.00-0.000.070.00-100.000.220.00-100.00
LGWR wait for redo copyOther0.000.000.000.000.15100.000.000.01100.00
SQL*Net more data from clientNetwork0.000.00-0.000.020.00-100.000.020.00-100.00
buffer busy waitsConcurrency0.000.00-0.000.020.00-100.000.010.00-100.00
SQL*Net message from clientIdle2,248.80207.80-2,040.993.254.3232.927,364.81572.37-92.23
fbar timerIdle0.001,223.841,223.840.000.05100.000.00300,013.89100.00
WCR : replay client notifyIdle0.0077.4177.410.000.24100.000.003,795.20100.00
Streams AQ: qmn slave idle waitIdle48.86114.2365.370.020.10400.0028,001.8314,000.74-50.00
Streams AQ: qmn coordinator idle waitIdle48.86114.2365.370.040.19375.0014,000.897,000.35-50.00
PL/SQL lock timerIdle52.360.00-52.360.560.00-100.001,000.270.00-100.00
jobq slave waitIdle41.940.00-41.940.150.00-100.003,004.280.00-100.00
DIAG idle waitIdle188.71163.31-25.402.001.94-3.001,001.431,000.84-0.06
Streams AQ: waiting for messages in the queueIdle122.19102.03-20.160.320.29-9.384,119.314,168.451.19
virtual circuit statusIdle104.70122.3917.690.040.0525.0030,001.6930,001.700.00
Space Manager: slave idle waitIdle95.9781.59-14.380.200.19-5.005,000.255,000.260.00
wait for unread message on broadcast channelIdle94.2285.66-8.561.001.022.00999.98999.96-0.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Wait Events'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Service Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Service Statistics

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % of DB time% CPU Time% Physical Reads% Logical Reads
Service Name1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
PWHD95.2381.84-13.3996.8389.05-7.770.000.000.0099.3992.67-6.72
SYS$USERS4.7617.9413.183.1510.527.37100.00115.9115.910.598.698.10
PWHDXDB0.000.000.000.000.000.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.000.000.000.000.010.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Service Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Service Statistics (RAC)

') , AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % CR Blks Received% Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
PWHD0.000.000.000.000.000.000.00
PWHDXDB0.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.00
SYS$USERS0.000.000.000.000.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Service Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('SQL Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Elapsed Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE( ''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRP T_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('< td align="right" class=''awrnclb''>1.12'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('< td class=''awrc''>6rm2uy96x1skz'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Elapsed Time % of DB timeElapsed Time (ms) per Exec#Exec/sec (DB time)CPU Time (ms) per ExecPhysical Reads per Exec#Rows Processed per Exec#Executions#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
bjsc9c4gg59jj94.2694.2681.6381.63-12.6354,02220,0110.020.0453,21219,4530.000.000.000.0011 BEGIN EMDW_LOG.set_context(MGM...
fyk8b9986ntk760.46154.7251.48133.12-8.9768818.906.3667790.000.000.000.005101561/ 1/ 1SELECT EXECUTION_ID, STATUS, ...
7r2fggjj3vdnt  7.78140.907.78 1,908 0.04 1,061 20.00 1.00 1 begin dbms_workload_replay.st...
7snbfvf2qc0v4  6.14147.046.14 1,505 0.04 359 13.00 0.00 1 begin :1 := dbms_workload_repl...
6ajkhukk78nsr0.11154.822.84149.882.74626970.020.04315150.008.001.001.0011 begin prvt_hdm.auto_execute( :...
9k86ctcaydu0v  2.60152.482.60 636 0.04 406 0.00 0.00 1/ 1/ 1select severity_code, message...
b25x9c4k1swgf11.35166.179.59162.07-1.7613158.906.3613150.000.001.001.005101561/ 1/ 1UPDATE MGMT_JOB_EXEC_SUMMARY S...
< a class="awr" href="#6htq3p9j91y0s">6htq3p9j91y0s13.73179.9112.19174.26-1.5515198.906.4016170.000.001.001.00510157 INSERT INTO MGMT_JOB_EXEC_SUMM...
bunssq950snhf1.19181.102.60176.861.416826380.020.046864370.000.008.007.00111/ 1/ 1insert into wrh$_sga_target_ad...
fz6320qyay15h182.21  -1.12639 0.02 78 5.00 1.00 1  BEGIN DBMS_WORKLOAD_CAPTURE.ST...
4acgtvgprp2c00.79183.010.62177.48-0.18118.906.40110.000.000.000.005101571/ 1/ 1SELECT DISTINCT JOB_TGT.TARGET...
4ay7q10wk6nc82.18185.192.02179.50-0.16238.906.40230.000.000.000.005101571/ 1/ 1INSERT INTO MGMT_JOB_PARAMETER...
2.25187.442.12181.62-0.13338.906.40320.000.000.000.005101571/ 1/ 1INSERT INTO MGMT_JOB_TARGET(JO...
08vznc16ycuag0.62188.060.49182.11-0.130026.7119.17000.000.001.001.001,5314701/ 1/ 1SELECT SYS_GUID() FROM SYS.DUA...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by CPU Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 CPU Time % of DB CPUCPU Time (ms) per Exec#Exec/sec (DB time)Exec Time (ms) per ExecPhysical Reads per Exec#Ro ws Processed per Exec#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
bjsc9c4gg59jj96.6696.6688.6388.63-8.0353,21219,4530.020.0454,02220,0110.000.000.000.00 BEGIN EMDW_LOG.set_context(MGM...
fyk8b9986ntk762.34159.0056.15144.78-6.196779 8.906.3668810.000.000.000.001/ 1/ 1SELECT EXECUTION_ID, STATUS, ...
7r2fggjj3vdnt  4.83149.614.83 1,061 0.04 1,908 20.00 1.00 begin dbms_workload_replay.st...
6ajkhukk78nsr0.06159.052.35151.952.29315150.020.04626970.008.001.001.00 begin prvt_hdm.auto_execute( :...
6htq3p9j91y0s14.45173.5112.51164.46-1.9416178.906.4015190.000.001.001.00 INSERT INTO MGMT_JOB_EXEC_SUMM...
9k86ctcaydu0v  1.85166.311.85 406 0.04 636 0.00 0.00/ 1/ 1select severity_code, message...
b25x9c4k1swgf11.84185.3510.45176.76-1.4013158.906.3613150.000.001.001.001/ 1/ 1UPDATE MGMT_JOB_EXEC_SUMMARY S...
bunssq950snhf1.25186.601.99178.750.746864370.020.046826380.000.008.007.001/ 1/ 1insert into wrh$_sga_target_ad...
6rm2uy96x1skz2.44189.031.78180.53-0.66328.906.40330.000.000.000.001/ 1/ 1INSERT INTO MGMT_JOB_TARGET(JO...
7fmujzn3gr8uz0.62189.660.07180.60-0.55108.906.40110.000.000.000.001/ 1/ 1SELECT /*+ ORDERED PUSH_SUBQ *...
08vznc16ycuag0.88190.540.43181.02-0.450026.7119.17000.000.001.001.001/ 1/ 1SELECT SYS_GUID() FROM SYS.DUA...
4ay7q10wk6nc82.21192.752.49183.510.28238.906.40230.000.000.000.001/ 1/ 1INSERT INTO M GMT_JOB_PARAMETER...
4acgtvgprp2c00.65193.400.64184.15-0.01118.906.40110.000.000.000.001/ 1/ 1SELECT DISTINCT JOB_TGT.TARGET...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Buffer Gets

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(' '), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYP E(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % Total GetsGets per Exec#ExecutionsExec Time (ms) per ExecCPU Time (ms) per ExecPhysical Reads per Exec#Rows Processed per Exec#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
fyk8b9986ntk792.7192.7182.2882.28-10.432,159.992,387.10510156688167790.000.000.000.001/ 1/ 1SELECT EXECUTION_ID, STATUS, ...
bjsc9c4gg59jj99.41192.1290.11172.39-9.301,181,213.00407,841.001154,02220,01153,21219,4530.000.000.000.00 BEGIN EMDW_LOG.set_context(MGM...
7r2fggjj3vdnt  6.92179.316.92 31,336.00  1 1,908 1,061 20.00 1.00 begin dbms_workload_replay.st...
6ajkhukk78nsr0.07192.191.34180.651.27837.006,080.001162697315150.008.001.001.00 begin prvt_hdm.auto_execute( :...
6htq3p9j91y0s2.92195.112.37183.03-0.5567.9768.38510157151916170.000.001.001.00 INSERT INTO MGMT_JOB_EXEC_SUMM...
5u0bnvvbvgf68  0.50183.520.50 2,254.00 1 101 62 0.00 1.00/ 1/ 1SELECT NVL(SUM(TABLESPACE_SIZE...
f0dm7wcn7p59h0.21195.32  -0.215.00 510 0 0 0.00 1.00 1// 1SELECT JOB_NAME, JOB_OWNER, ...
fz6320qyay15h0.21195.53  -0.212,442.00 1 639 78 5.00 1.00  BEGIN DBMS_WORKLOAD_CAPTURE.ST...
b25x9c4k1swgf0.84196.370.67184.20-0.1619.4819.47510156131513150.000.001.001.001/ 1/ 1UPDATE MGMT_JOB_EXEC_SUMMARY S...
5dwsqwabg2pxy0.60196.970.49184.68-0.117.007.001,02031600000.000.001.001.001/ 1/ 1SELECT COUNT(1) FROM MGMT_VERS...
bfhwd5nkrwjta0.52197.480.42185.10-0.103.003.002,04062800000.000.001.001.001/ 1/ 1SELECT JOB_ID, JOB_TYPE_ID FR...
fqjyb76axcsaj0.40197.880.33185.43-0.079.319.4351015700000.000.001.001.00 INSERT INTO MGMT_JOB_STATE_CHA...
4r1 94rhp4wpyu0.17198.050.14185.57-0.034.004.0051015700000.000.001.001.001/ 1/ 1SELECT JOB_TYPE_ID FROM MGMT_J...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Physical Reads

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % Total Physical ReadsPhysical Reads per Exec#ExecutionsExec Time (ms) per ExecCPU Time (ms) per Exec#Rows Processed per Exec#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
fz6320qyay15h71.4371.43  -71.435.00 1 639 78 1.00  BEGIN DBMS_WORKLOAD_CAPTURE.ST...
7r2fggjj3vdnt  45.4545.4545.45 20.00 1 1,908 1,061 1.00 begin dbms_workload_replay.st...
46zsasxjf8hb942.86114.29  -42.863.00 1 34 0 16.00 1// 1insert into WRH$_MEM_DYNAMIC_C...
7snbfvf2qc0v4  29.5575.0029.55 13.00 1 1,505 359 0.00 begin :1 := dbms_workload_repl...
0z1031991bd7w28.57142.86  -28.572.00 1 42 0 148.00 1// 1insert into wrh$_sysmetric_sum...
6ajkhukk78nsr0.00142.8618.1893.1818.180.008.001162697315151.001.00 begin prvt_hdm.auto_execute( :...
6c06mfv01xt2h  15.91109.0915.91 7.00 1 52 0 14.00/ 1/ 1update wrh$_seg_stat_obj sso ...
1gfaj4z5hn1kf14.29157.14  -14.290.50 2 9 0 0.00 1// 1delete from dependency$ where ...
cvvt9hc9c2br6  11.36120.4511.36 5.00 1 24 16 0.00/ 1/ 1 SELECT /*+ ordered use_nl(sta...
692wcvj50ytxz  6.82127.276.82 3.00 1 56 0 4.00/ 1/ 1insert into wrh$_resource_limi...
94vftcc9jztf1  6.82134.096.82 3.00 1 46 16 1.00 DECLARE row_count NUMBER ...
7ng34ruy5awxq  4.55138.644.55 0.03 67 1 1 1.57/ 2/ 2select i.obj#, i.ts#, i.file#,...
83taa7kaw59c1  4.55143.184.55 0.03 77 1 0 9.51/ 1/ 1select name, intcol#, segcol#,...
6wm3n4d7bnddg  2.27145.452.27 1.00 1 18 16 3.00/ 1/ 1 SELECT source, (case ...
062savj8zgzut0.00157.14  0.000.00 3 0 0 1.00 1// 1UPDATE sys.wri$_adv_parameters...
089dbukv1aanh0.00157.14  0.000.00 46 0 0 1.00 1// 1SELECT SYS_EXTRACT_UTC(SYSTIME...
08bqjmf8490s20.00157.14  0.000.00 4 0 0 0.75 1// 1SELECT PARAMETER_VALUE FROM MG...
08vznc16ycuag0.00157.140.00145.450.000.000.001,53147000001.001.001/ 1/ 1SELECT SYS_GUID() FROM SYS.DUA...
0h6b2sajwb74n0.00157.140.00145.450.000.000.0035000027.3332.801/ 1/ 1select privilege#, level from ...
0k8522rmdzg4k0.00157.140.00145.450.000.000.002500001.501.001/ 1/ 1select privilege# from sysauth...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Executions

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 #Executions/sec (DB time)#ExecutionsExec Time (ms) per ExecCPU Time (ms) per ExecPhysical Reads per Exec#Rows Processed per Exec#Plan 
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
bfhwd5nkrwjta35.5925.62-9.982,04062800000.000.001.001.001/ 1/ 1SELECT JOB_ID, JOB_TYPE_ID FR...
53saa2zkr6wc3 9.469.46 232 0 0 0.00 1.34/ 2/ 2select intcol#, nvl(pos#, 0), ...
23cha88t29kbg8.90 -8.90510 0 0 0.00 1.00 1// 1SELECT JOB_NAME, JOB_OWNER, ...
3824na5bnfhnu8.90 -8.90510 0 0 0.00 1.00 1// 1SELECT NESTED, NESTED_JOB_TYP...
08vznc16ycuag26.7119.17-7.541,53147000000.000.001.001.001/ 1/ 1SELECT SYS_GUID() FROM SYS.DUA...
5dwsqwabg2pxy17.8012.89-4.911,02031600000.000.001.001.001/ 1/ 1SELECT COUNT(1) FROM MGMT_VERS...
4acgtvgprp2c08.906.40-2.4951015711110.000.000.000.001/ 1/ 1SELECT DISTINCT JOB_TGT.TARGET...
4ay7q10wk6nc88.906.40-2.4951015723230.000.000.000.001/ 1/ 1INSERT INTO MGMT_JOB_PARAMETER...
4r194rhp4wpyu8.906.40-2.4951015700000.000.001.001.001/ 1/ 1SELECT JOB_TYPE_ID FROM MGMT_J...
6h6dq383cant68.906.40-2.4951015700000.000.000.000.001/ 1/ 1SELECT MGMT_JOB_PARAMSRC_RECOR...
6htq3p9j91y0s8.906.40-2.49510157151916170.000.001.001.00 INSERT INTO MGMT_JOB_EXEC_SUMM...
6rm2uy96x1skz8.906.40-2.4951015733320.000.000.000.001/ 1/ 1INSERT INTO MGMT_JOB_TARGET(JO...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Parse Calls

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % Total ParsesParses#Executions#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st/2nd/BothSQL Text
6h6dq383cant658.2258.2216.3416.34-41.885101575101571/ 1/ 1SELECT MGMT_JOB_PARAMSRC_RECOR...
3m8smr0v7v1m60.2358.456.6623.006.43264264 INSERT INTO sys.wri$_adv_messa...
f80h0xb1qvbsk0.2358.685.7228.725.492552551/ 1/ 1SELECT sys.wri$_adv_seq_msggro...
grwydz59pu6mc  4.7933.514.79 46 46/ 1/ 1select text from view$ where r...
3sqgkcng6vx8r  1.4634.961.46 14 14 INSERT INTO sys.wri$_adv_ratio...
3972rvxu3knn31.3760.05  -1.3712 12 1// 1delete from sdo_geor_ddl__tabl...
a6u3yjca29nqc1.3761.42  -1.3712 12  declare m_stmt varchar2(512...
2gxbvynrd71dr  1.3536.321.35 13 13 INSERT INTO sys.wri$_adv_rec_a...
6qz82dptj0qr7  1.3537.671.35 13 13/ 2/ 2select l.col#, l.intcol#, l....
7gs8x44r7mpnb  1.3539.021.35 13 13 INSERT INTO sys.wri$_adv_actio...
g5vpd5g3y90qv  1.3540.371.35 13 13 INSERT INTO sys.wri$_adv_recom...
4bvhj5ctc66fw  1.0441.421.04 10 10 INSERT INTO sys.wri$_adv_objec...
211pwdjq760670.6862.10  -0.686 6 1// 1SELECT id FROM dba_workload_re...
08bqjmf8490s20.4662.56  -0.464 4 1// 1SELECT PARAMETER_VALUE FROM MG...
6097g1430c6p20.4663.01  -0.464 3  BEGIN MGMT_PAF_AQ.DEQUEUE_REQU...
062savj8zgzut0.3463.36  -0.343 3 1// 1UPDATE sys.wri$_adv_parameters...
6129566gyvx210.3463.700.1041.52-0.2431311/ 1/ 1SELECT INSTANTIABLE, supertyp...
089dbukv1aanh0.2363.93  -0.232 46 1// 1SELECT SYS_EXTRACT_UTC(SYSTIME...
0h6b2sajwb74n0.3464.270.5242.040.1835351/ 1/ 1select privilege#, level from ...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Sharable Memory

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % Total Sharable MemorySharable Memory UsedSharable Memory Max#Executions 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2ndSQL Text
9gtqhd3dnpqvg  0.020.020.02 61,585 61,585 2select severity_code, message...
18naypzfmabd60.020.02  -0.0248,129 48,129 1 INSERT INTO MGMT_SYSTEM_PERFOR...
08bqjmf8490s20.020.03  -0.0239,896 39,896 4 SELECT PARAMETER_VALUE FROM MG...
6c06mfv01xt2h  0.010.040.01 38,111 38,111 1update wrh$_seg_stat_obj sso ...
71y370j6428cb0.010.05  -0.0134,330 34,330 1 insert into wrh$_thread (s...
cb21bacyh3c7d0.010.06  -0.0124,128 24,128 2 select metadata from kopm$ wh...
f318xdxdn0pdc  0.010.050.01  25,103 25,103 1insert into wrh$_log (s...
692wcvj50ytxz  0.010.050.01 21,077 21,077 1insert into wrh$_resource_limi...
c9s3vj1tj3aba0.010.07  -0.0118,836 18,836 1 UPDATE WRR$_CAPTURES SET END_T...
9wvf01xydy23m0.010.07  -0.0114,707 14,707 510 SELECT JOB_NAME, JOB_OWNER FR...
5zafwfnja12x3  0.010.060.01 14,718 14,718 1UPDATE WRR$_REPLAYS SET NUM_CL...
5xp6xdg6cp1zv0.010.08  -0.0112,603 12,603 2 SELECT MAX(VALUE) FROM V$SYSST...
3972rvxu3knn30.000.08  -0.008,502 8,502 12 delete from sdo_geor_ddl__tabl...
7fmujzn3gr8uz0.020.100.020.08-0.0056,73856,73856,73856,738510157SELECT /*+ ORDERED PUSH_SUBQ *...
6rm2uy96x1skz0.010.110.010.09-0.0023,04823,04823,04823,048510157INSERT INTO MGMT_JOB_TARGET(JO...
4acgtvgprp2c00.010.120.010.1 0-0.0018,95318,95318,95318,953510157SELECT DISTINCT JOB_TGT.TARGET...
fqjyb76axcsaj0.010.130.010.10-0.0016,83616,83616,83616,836510157INSERT INTO MGMT_JOB_STATE_CHA...
08vznc16ycuag0.000.130.000.11-0.008,5008,5008,5008,5001,531470SELECT SYS_GUID() FROM SYS.DUA...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), A WRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Version Count

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Version CountVersion Count Max#Executions 
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
08bqjmf8490s23 -33 4 SELECT PARAMETER_VALUE FROM MG...
18naypzfmabd63 -33& #160;1 INSERT INTO MGMT_SYSTEM_PERFOR...
cb21bacyh3c7d2 -22 2 select metadata from kopm$ wh...
3972rvxu3knn31 -11 12 delete from sdo_geor_ddl__tabl...
5xp6xdg6cp1zv1 -11 2 SELECT MAX(VALUE) FROM V$SYSST...
5zafwfnja12x3 11 1 1UPDATE WRR$_REPLAYS SET NUM_CL...
692wcvj50ytxz 11 1 1insert into wrh$_resource_limi...
6c06mfv01xt2h 11 1 1update wrh$_seg_stat_obj sso ...
71y370j6428cb1 -11 1 insert into wrh$_thread (s...
9gtqhd3dnpqvg 11 1 2select severity_code, message...
9wvf01xydy23m1 -11 510 SELECT JOB_NAME, JOB_OWNER FR...
c9s3vj1tj3aba1 -11 1 UPDATE WRR$_CAPTURES SET END_T...
f318xdxdn0pdc 11 1 1insert into wrh$_log (s...
08vznc16ycuag110111,531470SELECT SYS_GUID() FROM SYS.DUA...
4acgtvgprp2c011011510157SELECT DISTINCT JOB_TGT.TARGET...
6rm2uy96x1skz11011510157INSERT INTO MGMT_JOB_TARGET(JO...
7fmujzn3gr8uz11011510157SELECT /*+ ORDERED PUSH_SUBQ *...
fqjyb76axcsaj11011510157INSERT INTO MGMT_JOB_STATE_CHA...

'), AWRRP T_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 SQL Comparison by Cluster Wait Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % Total Cluster WaitCluster Wait Time (sec)Cluster Wait Time per Exec (sec)#Executions#Plans 
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
04xtrk7uyhknh  0.000.000.00 0.00 0.00 7/ 1/ 1select obj#, type#, ctime, mti...
062savj8zgzut0.000.00  0.000.00 0.00 3 1// 1UPDATE sys.wri$_adv_parameters...
089dbukv1aanh0.000.00  0.000.00 0.00 46 1// 1SELECT SYS_EXTRACT_UTC(SYSTIME...
08bqjmf8490s20.000.00  0.000.00 0.00 4 1// 1SELECT PARAMETER_VALUE FROM MG...
08vznc16ycuag0.000.000.000.000.000.000.000.000.001,5314701/ 1/ 1SELECT SYS_GUID() FROM SYS.DUA...
0fr8zhn4ymu3v  60;0.000.000.00 0.00 0.00 13/ 2/ 2select intcol#, type, flags, l...
0h6b2sajwb74n0.000.000.000.000.000.000.000.000.00351/ 1/ 1select privilege#, level from ...
0k8522rmdzg4k0.000.000.000.000.000.000.000.000.00251/ 1/ 1select privilege# from sysauth...
0kkhhb2w93cx00.000.00  0.000.00 0.00 2 1// 1update seg$ set type#=:4, bloc...
0m1qhvf6n3n66  0.000.000.00 0.00 0.00 1 begin :1 := dbms_workload_repl...
0z1031991bd7w0.000.00  0.000.00 0.00 1 1// 1insert into wrh$_sysmetric_sum...
18naypzfmabd60.000.00  0.000.00 0.00 1  INSERT INTO MGMT_SYSTEM_PERFOR...
1cq3qr774cu45  0.000.000.00 0.00 0.00 1/ 1/ 1insert into WRH$_IOSTAT_FILETY...
1gfaj4z5hn1kf0.000.00  0.000.00 0.00 2 1// 1delete from dependency$ where ...
1gu8t96d0bdmu  0.000.000.00 0.00 0.00 1/ 2/ 2select t.ts#, t.file#, t.block...
2gxbvynrd71dr  0.000.000.00 0.00 0.00 13 INSERT INTO sys.wri$_adv_rec_a...
2q93zsrvbdw48  0.000.000.00 0.00 0.00 30/ 1/ 1select grantee#, privilege#, n...

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to SQL Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Instance Activity Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Key Instance Activity Stats

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Valueper Second (DB time)per Second (Elapsed Time)per Trans
Statistic1st2nd1st2n d%Diff1st2nd%Diff1st2nd%Diff
db block changes19,88132,303346.891,317.73279.87368.841,568.72325.31552.251,538.24178.54
execute count16,2307,169283.18292.443.27301.11348.1415.62450.83341.38-24.28
logons cumulative440.070.16128.570.070.19171.430.110.1972.73
opened cursors cumulative16,1957,125282.57290.652.86300.46346.0115.16449.86339.29-24.58
parse count (total)87696115.2839.20156.5416.2546.67187.2024.3345.7688.08
parse time elapsed5300.091.221,255.560.091.461,522.220.141.43921.43
physical reads7440.121.791,391.670.132.141,546.150.192.101,005.26
physical writes5583759.7415.3057.0810.3518.2175.9415.5017.8615.23
redo size3,306,3206,455,74457,689.35263,348.49356.4961,3 40.61313,507.38411.0991,842.22307,416.38234.72
session cursor cache hits15,3886,533268.49266.50-0.74285.49317.2611.13427.44311.10-27.22
session logical reads1,188,208452,60020,732.1018,462.86-10.9522,044.2721,979.41-0.2933,005.7821,552.38-34.70
user calls2111073.684.3618.483.915.2032.995.865.10-12.97
user commits33200.580.8241.380.610.9759.020.920.953.26
user rollbacks310.050.04-20.000.060.05-16.670.080.05-37.50
workarea executions - optimal882081.548.48450.651.6310.10519.632.449.90305.74

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Instance Activity Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Other Instance Activity Stats

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TY PE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('2.57'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Valueper Second (DB time)per Second (Elapsed Time)per Trans
Statistic1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
CCursor + sql area evicted0480.001.96100.000.002.33100.000.002.29100.00
CPU used by this session5,4962,16795.9088.40-7.82101.96105.243.22152.67103.19-32.41
CPU used when call started169152.950.61-79.323.140.73-76.754.690.71-84.86
CR blocks created102411.781.67-6.181.891.995.292.831.95-31.10
DBWR checkpoint buffers written5542269.679.22-4.6510.2810.986.8115.3910.76-30.08
DBWR transaction table writes400.070.00-100.000.070.00-100.000.110.00-100.00
DBWR undo block writes203563.542.28-35.593.772.72-27.855.642.67-52.66
HSC Heap Segment Block Changes2,2566,30839.36257.32553.7641.85306.33631.9762.67300.38379.30
Heap Segment Array Inserts66801.153.26183.481.223.89218.851.833.81108.20
Heap Segment Array Updates12150.210.61190.480.220.73231.820.330.71115.15
IMU CR rollbacks1020.170.08-52.940.190.10-47.370.280.10-64.29
IMU Flushes2290.380.37-2.630.410.447.320.610.43-29.51
IMU Redo allocation size41,34036,596721.311,492.86106.97766.961,777.20131.721,148.331,742.6751.76
IMU commits31160.540.6520.370.580.7834.480.860.76-11.63
IMU contention110.020.04100.000.020.05150.000.030.0566.67
IMU undo allocation size83,22051,9961,452.042,121.0746.081,543.942,525.0663.552,311.672,476.007.11
LOB table id lookup cache misses0400.001.63100.000.001.94100.000.001.90100.00
RowCR - row contention31130.540.53-1.850.580.638.620.860.62-27.91
RowCR attempts9,4973,004165.71122.54-26.05176.19145.88-17.20263.81143.05-45.78
RowCR hits9,4662,991165.16122.01-26.13175.62145.25-17.29262.94142.43-45.83
SMON posted for undo segment shrink200.030.00-100.000.040.00-100.000.060.00-100.00
SQL*Net roundtrips to/from clien t167782.913.189.283.103.7922.264.643.71-20.04
Workload Capture: user logins200.030.00-100.000.040.00-100.000.060.00-100.00
active txn count during cleanout2002583.4910.52201.433.7112.53237.745.5612.29121.04
auto extends on undo tablespace010.000.04100.000.000.05100.000.000.05100.00
background timeouts209783.653.18-12.883.883.79-2.325.813.71-36.14
buffer is not pinned count922,077332,91916,088.5913,580.73-15.5917,106.8616,167.40-5.4925,613.2515,853.29-38.11
buffer is pinned count93,928,81033,191,7521,638,889.301,353,987.65-17.381,742,617.211,611,876.07-7.502,609,133.611,580,559.62-39.42
bytes received via SQL*Net from client27,54715,859480.65646.9334.59511.07770.1550.69765.19755.19-1.31
bytes sent via SQL*Net to client19,14915,005334.12612.1083.20355.26728.68105 .11531.92714.5234.33
calls to get snapshot scn: kcmgss24,02112,044419.12491.3117.22445.65584.8931.24667.25573.52-14.05
calls to kcmgas4125587.1922.76216.557.6427.10254.7111.4426.57132.26
calls to kcmgcs431460.755.96694.670.807.09786.251.196.95484.03
calls to kcmgrs29,75520,138519.17821.4958.23552.03977.9577.16826.53958.9516.02
change write time1390.230.3760.870.240.4483.330.360.4319.44
cleanout - number of ktugct calls2032723.5411.10213.563.7713.21250.405.6412.95129.61
cleanouts and rollbacks - consistent read gets99361.731.47-15.031.841.75-4.892.751.71-37.82
cleanouts only - consistent read gets3100.050.41720.000.060.49716.670.080.48500.00
cluster key scan block gets201520.356.201,671.430.377.381,894.590.567.241,192.86
cluster key scans201310.355.341,425.710.376.361,618.920.566.241,014.29
commit batch/immediate performed040.000.16100.000.000.19100.000.000.19100.00
commit batch/immediate requested040.000.16100.000.000.19100.000.000.19100.00
commit cleanout failures: callback failure250.030.20566.670.040.24500.000.060.24300.00
commit cleanouts3626366.3225.94310.446.7230.89359.6710.0630.29201.09
commit cleanouts successfully completed3606306.2825.70309.246.6830.59357.9310.0030.00200.00
commit immediate performed040.000.16100.000.000.19100.000.000.19100.00
commit immediate requested040.000.16100.000.000.19100.000.000.19100.00
commit txn count during cleanout36860.633.51457.140.674.18523.881.004.10310.00
consistent changes71772112.5129.41135.0913.3035.01163.2319.9234.3372.34
consistent gets1,164,154422,02120,312.4017,215.46-15.2521,598.0020,494.42-5.1132,337.6120,096.24-37.85
consistent gets - examination26,801 12,696467.63517.9110.75497.23616.5524.00744.47604.57-18.79
consistent gets from cache1,164,154422,02120,312.4017,215.46-15.2521,598.0020,494.42-5.1132,337.6120,096.24-37.85
consistent gets from cache (fastpath)1,124,040404,91919,612.4816,517.82-15.7820,853.7919,663.90-5.7131,223.3319,281.86-38.25
cursor authentications9700.162.861,687.500.173.401,900.000.253.331,232.00
data blocks consistent reads - undo records applied70227312.2511.14-9.0613.0213.261.8419.5013.00-33.33
db block gets24,05530,581419.721,247.49197.22446.281,485.09232.77668.191,4 56.24117.94
db block gets direct41490.076.088,585.710.077.2410,242.860.117.106,354.55
db block gets from cache24,05130,432419.651,241.41195.82446.211,477.86231.20668.081,449.14116.91
db block gets from cache (fastpath)7,6409,048133.30369.09176.89141.74439.39210.00212.22430.86103.03
deferred (CURRENT) block cleanout applications2042663.5610.85204.783.7812.92241.805.6712.67123.46
enqueue conversions15240.260.98276.920.281.17317.860.421.14171.43
enqueue releases8991,20215.6949.03212.4916.6858.37249.9424.9757.24129.24
enqueue requests9121,20815.9149.28209.7416.9258.66246.6925.3357.52127.08
enqueue timeouts1040.170.16-5.880.190.190.000.280.19-32.14
enqueue waits010.000.04100.000.000.05100.000.000.05100.00
free buffer requested3457586.0230.92413.626.4036.81475.169.5836.10276.83
heap block compress66271.151.10-4.351.221.317.381.831.29-29.51
immediate (CR) block cleanout applications102461.781.885.621.892.2317.992.832.19-22.61
immediate (CURRENT) block cleanout applications1062111.858.61365.411.9710.25420.302.9410.05241.84
index crx upgrade (positioned)89161.550.65-58.061.650.78-52.732.470.76-69.23
index fetch by key14,0525,852245.18238.72-2.63260.70284.199.01390.33278.67-28.61
index scans kdiixs14,1512,88272.43117.5762.3277.01139.9681.74115.31137.2419.02
leaf node 90-10 splits1280.210.3357.140.220.3977.270.330.3815.15
leaf node splits36720.632.94366.670.673.50422.391.003.43243.00
lob reads04380.0017.87100.000.0021.27100.000.0020.86100.00
lob writes63530.1014.4014,300.000.1117.1415,481.820.1716.819,788.24
lob writes unaligned63530.1014.4014,300.000.1117.1415,481.820.1716.819,788.24
messages received156802.723.2619.852.893.8934.604.333.81-12.01
messages sent156802.723.2619.852.893.8934.604.333.81-12.01
no work - consistent read gets1,122,530403,35919,586.1416,454.18-15.9920,825.7719,588.14-5.9431,181.3919,207.57-38.40
parse count (hard)12840.0211.5957,850.000.0213.7968,850.000.0313.5244,966.67
parse time cpu4340.071.391,885.710.071.652,257.140.111.621,372.73
physical read IO requests4410.071.672,285.710.071.992,742.860.111.951,672.73
physical read bytes57,344360,4481,000.5514,703.721,369.561,063.8817,504.271,545.321,592.8917,164.19977.55
physical read total IO requests74178112.9331.86146.4013.7537.93175.8520.5837.1980.71
physical read total bytes12,091,3 9212,334,080210,973.11503,142.83138.49224,325.93598,974.36167.01335,872.00587,337.1474.87
physical reads cache7440.121.791,391.670.132.141,546.150.192.101,005.26
physical reads cache prefetch330.050.12140.000.060.15150.000.080.1475.00
physical reads prefetch warmup330.050.12140.000.060.15150.000.080.1475.00
physical write IO requests1091771.907.22280.002.028.60325.743.038.43178.22
physical write bytes4,571,1363,072,00079,758.13125,315.7757.1284,806.14149,184.1575.91126,976.00146,285.7115.21
physical write total IO requests2092713.6511.05202.743.8813.16239.185.8112.90122.03
physical write total bytes8,771,58415,395,328153,048.41628,019.99310.34162,735.09747,636.36359.42243,655.11733,110.86200.88
physical write total multi block requests32290.561.18110.710.591.41138.980.891.3855.06
physical writes direct41490.076.088,585.710.077.2410,242.860.117.106,354.55
physical writes direct (lob)41490.076.088,585.710.077.2410,242.860.117.106,354.55
physical writes from cache5542269.679.22-4.6510.2810.986.8115.3910.76-30.08
physical writes non checkpoint2291974.008.04101.004.259.57125.186.369.3847.48
process last non-idle time0140.000.57100.000.000.68100.000.000.67100.00
recursive calls21,17830,445369.521,241.94236.10392.911,478.49276.29588.281,449.76146.44
recursive cpu usage5,4532,14995.1587.66-7.87101.17104.363.15151.47102.33-32.44
redo blocks checksummed by FG (exclusive)1,5852,91127.66118.75329.3229.41141.37380.6944.03138.62214.83
redo blocks written6,54012,901114.11526.27361.20121.33626.51416.37181.67614.33238.16
redo blocks written for direct writes1567,7922.72317.8611,586.032.89378.4012,993.434.33371.058,469.28
redo entries9,98216,459174.17671.41285.49185.19799.29331.61277.28783.76182.66
redo ordering marks1933493.3714.24322.553.5816.95373.465.3616.62210.07
redo subscn max counts2987005.2028.56449.235.5333.99514.658.2833.33302.54
redo synch time020.000.08100.000.000.10100.000.000.10100.00
redo synch writes18170.310.69122.580.330.83151.520.500.8162.00
redo wastage11,48811,440200.44466.67132.82213.13555.56160.67319.11544.7670.71
redo write time3210.050.861,620.000.061.021,600.000.081.001,150.00
redo writes47460.821.88 129.270.872.23156.321.312.1967.18
rollback changes - undo records applied060.000.24100.000.000.29100.000.000.29100.00
rollbacks only - consistent read gets350.050.20300.000.060.24300.000.080.24200.00
rows fetched via callback13,3805,069233.46206.78-11.43248.23246.16-0.83371.67241.38-35.06
session pga memory1,943,1241,835,00833,904.0374,855.29120.7936,049.8789,112.67147.1953,975.6787,381.3361.89
session pga memory max-1,202,60422,282,240-20,983.28908,957.07-4,431.82-22,311.351,082,082.36-4,949.92-33,405.671,061,059.05-3,276.28
ses sion uga memory4,296,520,184961,77674,966,572.4539,233.63-99.9579,711,326.0246,706.29-99.94119,347,782.8945,798.86-99.96
session uga memory max6,893,1087,236,272120,272.37295,188.48145.43127,884.60351,411.81174.79191,475.22344,584.3879.96
shared hash latch upgrades - no wait13,2204,352230.67177.53-23.04245.26211.34-13.83367.22207.24-43.57
sorts (memory)64652211.2721.2988.9111.9825.35111.6017.9424.8638.57
sorts (rows)5,6839,08599.16370.60273.74105.43441.19318.47157.86432.62174.05
sql area evicted0540.002.20100.000.002.62100.000.00100.00
switch current to new buffer23270.401.10175.000.431.31204.650.641.29101.56
table fetch by rowid47,418,46716,758,716827,367.22683,636.54-17.37879,732.60813,845.96-7.491,317,179.64798,034.10-39.41
table fetch continued row080.000.33100.000.000.39100.000.000.38100.00
table scan blocks gotten8,3225,035145.20205.3941.45154.39244.5158.37231.17239.763.72
table scan rows gotten222,220223,9963,877.349,137.45135.664,122.7410,877.82163.856,172.7810,666.4872.80
table scans (short tables)1,08941019.0016.73-11.9520.2019.91-1.4430.2519.52-35.47
total number of times SMON posted200.030.00-100.000.040.00-100.000.060.00-100.00
transaction rollbacks040.000.16100.000.000.19100.000.000.19100.00
undo change vector size1,174,4921,927,63620,492.7878,633.85283.7121,789.8093,610.92329.6132,624.7891,792.19181.36

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Instance Activity Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('IO Stats'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Tablespace IO Stats

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Avg Reads / SecAvg Writes / SecReadsAvg Read Time (ms)Avg Blocks / ReadWritesBuffer WaitsAvg Buf Wait Time (ms)IOs per second
Tablespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
SYSAUX0.061.262,000.001.478.30464.6332646.678.082.001.2779171000.000.001.529.578.05

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to IO Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 File Comparison by IO

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
  Avg Reads / SecAvg Writes / SecReadsAvg Read Time (ms)Avg Blocks / ReadWritesBuffer WaitsAvg Buf Wait Time (ms)IOs per second
TablespaceFilename1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
SYSAUXC:\ORACLE\ORADATA\PWHD\DATAFILE\O1_MF_SYSAUX_5WJTWL17_.DBF0.061.262,000.001.478.30464.6332646.678.082.001.2779171000.000.001.529.578.05

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to IO Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 File Comparison by Read Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
  Read Time % of DB timeAvg Read Time (ms)ReadsAvg Reads per SecAvg Blocks per ReadWritesAvg Writes per SecBuffer WaitsAvg Buf Wait Time (ms)
TablespaceFilename1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
SYSAUXC:\ORACLE\ORADATA\PWHD\DATAFILE\O1_MF_SYSAUX_5WJTWL17_.DBF0.240.860.6146.678.083260.061.262.001.27791711.478.30000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to IO Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 10 File Comparison by Buffer Waits

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to IO Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Advisory Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Instance Recovery Sta ts

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
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
B10223,01330,971184,320184,320184,320203,899
E10223,17631,501184,320184,320184,320204,369
         
B20223,00028,062184,320184,320184,320192,509
E20233,85839,284184,320184,320184,320203,776

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Advisory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

PGA Aggregate Summary

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
PGA Cache Hit %W/A Bytes/Sec (DB time)W/A MB ProcessedRead/Written W/A Bytes/Sec (DB time)Read/Written W/A MB
1st2ndDiff1st2nd%Diff1st2nd1st2nd%Diff1st2nd
100.00100.000.00234,432769,606228.281318000.0000

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Advisory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

PGA Aggr Target Stats

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
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)
         

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Advisory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Wait Stats'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Buffer Wait Statistics

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Wait Time % of DB timeTotal Wait Time (s)# Waits Avg Wait Time (ms)
Class1st2ndDiff1st2nd1st2nd1st2nd%Diff
undo header0.000.000.000.000.00100.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Wait Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Enqueue Activity

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Wait Stats'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Undo Segment Summary

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1st1.641,158330419.5/19.50/00/0/0/6/40/0
2nd1.922,329329519.5/19.50/00/0/0/4/24/0

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Latch Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE ('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Latch Sleep Breakdown

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 % of Total SleepsGet RequestsMissesSpin GetsSleepsWait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool0.00100.00100.003,58827,238040202018,18818,188

'), AWRRPT_HTML_TYPE( '


'), AWRRPT_HTML_TYPE('Back to Latch Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Latch Wait Time Breakdown

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Wait Time (cs)Get RequestsMissesSpin GetsSleeps% of Total Sleeps
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool018,18818,1883,58827,2380402020.00100.00100.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Latch Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Segment Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments Comparison by Logical Reads

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
     % of Total Logical ReadsLogical Reads% of Captured Logical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd1st2ndDiff
SYSMANSYSAUXMGMT_JOB_EXEC_SUMMARY TABLE74.4674.4670.2970.29-4.17884,784318,12874.7770.77-4.00
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX  2.5872.872.58 11,680 2.602.60
SYSSYSAUXWRH$_SQL_PLAN TABLE0.0374.501.4074.271.374006,3360.031.411.38
SYSMANSYSAUXMGMT_JOB_EXEC_SUMM_IDX02 INDEX19.7394.2318.4892.75-1.25234,48083,64819.8218.61-1.21
MYAPPUSERSACCOUNTS TABLE0.2594.480.6593.400.412,9122,9440.250.650.41
SYSMANSYSAUXPK_MGMT_EXEC_SUMM INDEX0.7095.170.5693.96-0.148,2722,5280.700.56-0.14
SYSMANSYSAUXMGMT_VERSIONS TABLE0.6195.790.5094.46-0.117,2802,2720.620.51-0.11
SYSMANSYSAUXMGMT_JOB_EXEC_SUMM_IDX05 INDEX0.4496.220.3994.85-0.055,2161,7440.440.39-0.05

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments Comparison by Physical Reads

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYP E(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
     % of Total Physical ReadsPhysical Reads% of Captured Physical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd1st2ndDiff
SYSSYSAUXWRH$_SQL_PLAN TABLE57.1457.140.000.00-57.1440100.000.00-100.00
SYSSYSTEMCDEF$ TABLE  4.554.554.55 2 33.3333.33
SYSSYSAUXWRH$_DB_CACHE_ADVICE_PKWRH$_DB_CAC_4252952393_43INDEX PARTITION  4.559.094.55 2 33.3333.33
SYSSYSAUXWRH$_WAITSTAT_P KWRH$_WAITST_4252952393_43INDEX PARTITION  4.5513.644.55 2 33.3333.33
SYSSYSTEMCCOL$ TABLE  0.0013.640.00 0 0.000.00
SYSSYSTEMI_CDEF2 INDEX  0.0013.640.00 0 0.000.00
SYSSYSTEMKOTAD$ TABLE0.00 57.140.0013.640.00000.000.000.00
SYSSYSTEMKOTTB$ TABLE0.0057.140.0013.640.00000.000.000.00
SYSSYSTEMSYS_C00642 INDEX0.0057.140.0013.640.00000.000.000.00
SYSSYSTEMSYS_C00643 INDEX0.0057.140.0013.640.0 0000.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments by Row Lock Waits

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
     % of TotalRow Lock Waits% of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd1st1st Total2nd2nd TotalDiff
SYSSYSTEMWRR$_REPLAYS TABLE 100.00100.00 1   100.00100.00100.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments by ITL Waits

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments by Buffer Busy Waits

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Top 5 Segments by GC Buffer Busy Waits

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Segment Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Dictionary Cache Statistics

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('< td align="right" class=''awrclb''>2'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Get Requests per Sec (DB time)Get Requests per Sec (Elapsed Time)Get RequestsPct MissScan RequestsPct MissMod ReqsFinal Usage
Cache1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
dc_awr_control0.070.16128.570.070.19171.43440.000.00000.000.00211
dc_database_links0.050.33560.000.060.39550.00380.000.00000.000.000011
dc_global_oids1.812.4535.361.932.9150.78104600.0010.00000.000.0000242412
dc_histogram_data0.0016.81100.000.0020.01100.0004120.003.16000.000.0000680788
dc_histogram_defs0.05133.15266,200.000.06158.51264,083.3333,2640.0018.60000.000.00005,3165,167
dc_object_grants0.144.082,814.290.154.863,140.0081000.000.00000.000.0000226243
dc_objects4.73125.762,558.775.03149.722,876.542713,0831.480.32000.000.00305,6094,408
dc_profiles0.030.20566.670.040.24500.00250.000.00000.000.000022
dc_rollback_segments0.404.32980.000.435.151,097.67231060.000.00000.000.00002222
dc_segments0.2356.9124,643.480.2467.7428,125.00131,3950.000.43000.000.006121,5521,483
dc_sequences0.000.24100.000.000.29100.00060.0016.67000.000.0006136
dc_tablespaces20.19131.39550.7721.47156.42628.551,1573,2210.000.00000.000.000067
dc_users23.35117.52403.3024.82139.91463.701,3382,8810.070.00000.000.0000175264
global database name0.920.90-2.170.981.079.1853220.000.00000.000.000012
sch_lj_objs0.030.00-100.000.040.00-100.002050.000.00000.000.000022

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Library Cache Activity

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Get Requests per Sec (DB Per)Get Requests per Sec (Elapsed Time)Get RequestsPct MissPin RequestsPct Mi ssReloadsInvalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
BODY0.610.610.000.650.7312.3135150.000.002,7779080.000.110100
CLUSTER0.001.63100.000.001.94100.00040 0.0009 0.000000
INDEX0.003.63100.000.004.32100.00089 0.00071 0.000000
SQL AREA3.1418.03474.203.3421.46542.511804421.1117.8716,3568,6680.0210.06022600
TABLE/PROCEDURE2.2757.602,437.442.4168.572,745.231301,4120.770.713,4523,3700.039.91028400
TRIGGER0.230.16-30.430.240.19-20.831340.000.003,1091,0000.000.000000

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Memory Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Process Memory Summary

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('< td align="right" class=''awrncrb''>8.43'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
  1st2nd% Diff of
CategorySummaryBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
OtherAlloc (KB)69,845.2968,054.87-2.5668,110.7271,305.734.69-2.484.78
 Used (KB)        
 Avg Alloc (KB)1,887.711,839.32-2.561,891.961,980.714.690.237.69
 Std Dev Alloc (KB)1,702.141,703.010.051,748.531,846.575.612.73
 Max Alloc (KB)9,401.569,401.560.009,401.569,401.560.000.000.00
 Hist Max Alloc (KB)22,937.7122,937.710.0022,937.7138,725.6968.830.0068.83
 Num Procs37.0037.000.0036.0036.000.00-2.70-2.70
 Num Alloc37.0037.000.0036.0036.000.00-2.70-2.70
PL/SQLAlloc (KB)698.09692.51-0.80605.36594.22-1.84-13.28-14.19
 Used (KB)334.45309.07-7.59313.36296.10-5.51-6.31-4.20
 Avg Alloc (KB)19.9519.79-0.8017.8017.48-1.84-10.73-11.67
 Std Dev Alloc (KB)26.0925.86-0.8722.7822.45-1.42-12.69-13.18
 Max Alloc (KB)95.2674.790.0074.7974.790.00-21.49-21.49
 Hist Max Alloc (KB)95.2695.260.00323.39323.390.00239.47239.47
 Num Procs35.0035.000.0034.0034.000.00-2.86-2.86
 Num Alloc35.0035.000.0034.0034.000.00-2.86-2.86
SQLAlloc (KB)240,529.93242,005.940.61264,977.98265,314.120.1310.169.63
 Used (KB)204,487.65205,761.190.62225,239.86225,579.340.1510.159.63
 Avg Alloc (KB)9,621.209,680.240.6111,040.7511,054.750.1314.7514.20
 Std Dev Alloc (KB)47,692.1147,960.230.5653,617.5253,704.430.1612.4211.98
 Max Alloc (KB)238,543.10263,189.100.56262,767.07263,189.100.1610.159.71
 Hist Max Alloc (KB)238,609.91239,993.190.58262,853.22263,293.190.1710.169.71
 Num Procs25.0025.000.0024.0024.000.00-4.00-4.00
 Num Alloc22.0022.000.0022.0022.000.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Memory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

SGA Memory Summary

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 1st2nd% Diff of
SGA regionsBegin Value (KB)End Value (KB)%DiffBegin Value (KB)End Value (KB)%DiffBegin ValuesEnd Values
Database Buffers712,704.00712,704.000.00688,128.00679,936.00-1.19-3.45-4.60
Fixed Size1,303.111,303.110.001,303.111,303.110.000.000.00
Redo Buffers4,536.004,536.000.004,536.004,536.000.000.000.00
Variable Size327,680.89327,680.890.00352,256.89360,448.892.337.5010.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Memory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

SGA Breakdown Difference

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
  1st2nd%Diff of
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
java poolfree memory7,676,9927,676,9920.007,676,9927,676,9920.000.000.00
java pooljoxlod exec hp8,822,0168,822,0160.008,822,0168,822,0160.000.000.00
java pooljoxs heap278,208278,2080.00278,208278,2080.000.000.00
large poolfree memory8,324,1608,324,1600.008,283,2008,324,1600.49-0.490.00
shared poolASH buffers4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
shared poolCCursor10,446,80810,452,0920.0510,607,91211,217,0485.741.547.32
shared poolHeap0: KGL6,612,3686,615,5320.056,324,0646,348,1240.38-4.36-4.04
shared poolKCB Table Scan Buffer4,194,8164,194,8160.004,194,8164,194,8160.000.000.00
shared poolKGL buckets3,145,7283,145,7280.003,145,7283,145,7280.0 00.000.00
shared poolKGL handle7,422,0247,422,8400.018,493,8608,544,3520.5914.4415.11
shared poolKGLS heap8,628,3448,628,3440.005,517,9046,860,96024.34-36.05-20.48
shared poolKQR M PO5,761,5805,764,1400.044,634,1644,945,4726.72-19.57-14.20
shared poolKSFD SGA I/O b4,190,2284,190,2280.004,190,2284,190,2280.000.000.00
shared poolPCursor4,362,7604,364,8640.056,408,4606,502,0961.4646.8948.96
shared poolPL/SQL DIANA13,344,10813,344,1080.0012,306,78812,466,0001.29-7.77-6.58
shared poolPL/SQL MPCODE16,354,82416,354,8240.0017,304,96017,309,0280.025.815.83
shared poolXDB Schema Cac7,203,0247,203,0240.007,203,0247,203,0240.000.000.00
shared pooldb_block_hash_buckets3,147,7763,147,7760.003,147,7763,147,7760.000.000.00
shared pooldbwriter coalesce buffer4,194,8164,194,8160.004,194,8164,194,8160.000.000.00
shared poolfree memory45,234,57645,211,156-0.0534,700,04440, 285,05616.10-23.29-10.90
shared poolrow cache3,780,2163,780,2160.003,780,2163,780,2160.000.000.00
shared poolsql area57,222,79657,230,9480.0173,208,64473,114,576-0.1327.9427.75
shared pooltype object de3,302,2923,302,2920.004,277,4604,464,0364.3629.5335.18
streams poolfree memory   16,734,75616,734,7560.00  
 buffer_cache729,808,896729,808,8960.00704,643,072696,254,464-1.19-3.45-4.60
 fixed_sga1,334,3801,334,3800.001,334,3801,334,3800.000.000.00
 log_buffer4,644,8644,644,8640.004,644,8644,644,8640.000.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Memory Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Streams Statistics'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Streams by CPU Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TY PE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 CPU Time (sec)User I/O Time (sec)System I/O Time (sec)
Session Type1st2ndDiff1st2ndDiff1st2ndDiff
QMON Slaves 0.000.00 0.000.00 0.000.00
QMON Coordinator 0.000.00 0.000.00 0.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Streams by IO Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_T YPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 IO Time (sec)CPU Time (sec)
Session Type1st User1st System1st Total2nd User2nd System2nd TotalTotal Diff1st2ndDiff
QMON Slaves  0.000.000.000.000.00 0.000.00
QMON Coordinator  0.000.000.000.000.00 0.000.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Streams Capture

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HT ML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Streams Apply

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Buffered Queues

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Buffered Subscribers

'), AWRRPT_HTML_TYPE(NULL), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(' No data exists for this section of the report.'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Rule Set by Evaluations

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML _TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 EvaluationsFast EvalsSQL ExecsCPU Time (sec)Elapsed Time (sec)
Ruleset Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd
SYS.ALERT_QUE_R 00 0 0 0.00 0.00

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

Rule Set by Elapsed Time

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 Elapsed Time (Sec)'), AWRRPT_HTML_TYPE('Fast EvalsSQL ExecsCPU Time (sec)Evaluations
Ruleset Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd
SYS.ALERT_QUE_R 0.000.00 0 0 0.00 0

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('Back to Streams Statistics'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

init.ora Parameters

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
 1st Period2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
__db_cache_size 729808896704643072696254464
__java_pool_size 16777216  
__large_pool_size 8388608  
__oracle_base C:\oracle  
__pga_aggregate_target 687865856  
__sga_target 1015021568  
__shared_io_pool_size 0  
__shared_pool_size 251658240260046848268435456
__streams_pool_size 0 16777216
audit_file_dest C:\ORACLE\ADMIN\PWHD\ADUMP  
audit_trail DB  
compatible 11.1.0.0.0  
control_files C:\ORACLE\ORADATA\PWHD\CONTROLFI  
db_block_size 8192  
db_create_file_dest C:\oracle\oradata  
db_domain    
db_name PWHD  
diagnostic_dest C:\ORACLE  
dispatchers (PROTOCOL=TCP) (SERVICE=PWHDXDB)  
memory_target 1702887424  
open_cursors 300  
processes 150  
remote_login_passwordfile EXCLUSIVE  
undo_tablespace UNDOTBS1  

'), AWRRPT_HTML_TYPE('


'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('

Complete List of SQL Text

'), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE('
SQL IdSQL Text
04xtrk7uyhknhselect 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
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
0fr8zhn4ymu3vselect intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
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
0m1qhvf6n3n66begin :1 := dbms_workload_replay.client_connect( dbms_workload_replay.KECP_CLIENT_CONNECT_ADMIN, :2 ); end;
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))
1cq3qr774cu45'), AWRRPT_HTML_TYPE('insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_re qs, 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) '), AWRRPT_HTML_TYPE('
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.ob j#= :1 and t.obj# = ts.obj# (+)
211pwdjq76067SELECT id FROM dba_workload_replays WHERE status = :1
23cha88t29kbgSELECT JOB_NAME, JOB_OWNER, JOB_TYPE FROM MGMT_JOB WHERE JOB_ID = :B2 AND JOB_STATUS != :B1
2gxbvynrd71drINSERT INTO sys.wri$_adv_rec_actions (task_id, rec_id, act_id) VALUES (:1, :2, :3)
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
3824na5bnfhnuSELECT NESTED, NESTED_JOB_TYPE_ID FROM MGMT_JOB WHERE JOB_ID=:B1
3972rvxu3knn3delete from sdo_geor_ddl__table$$
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)
3sqgkcng6vx8rINSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, '' '', :13) RETURNING rowid INTO :14
46zsasxjf8hb9insert into WRH$_MEM_DYNAMIC_COMP (snap_id, dbid, instance_number, component, current_size, min_size, max_size, user_specified_size, oper_count, last_oper_type, last_oper_mode, last_oper_time, granule_size) select :snap_id, :dbid, :instance_number, component, current_size, min_size, max_size, user_specified_size, oper_count, last_oper_type, last_oper_mode, last_oper_time, granule_size from v$memory_dynamic_components
4acgtvgprp2c0SELECT DISTINCT JOB_TGT.TARGET_GUID, TGT.TARGET_TYPE, TGT.TIMEZONE_REGION, TGT.TARGET_NAME||TGT.TARGET_TYPE FROM MGMT_JOB_EXT_TARGETS JOB_TGT, MGMT_TARGETS TGT WHERE JOB_TGT.JOB_ID = :B1 AND TGT.TARGET_GUID = JOB_TGT.TARGET_GUID
4ay7q10wk6nc8INSERT INTO MGMT_JOB_PARAMETER ( JOB_ID, EXECUTION_ID, PARAMETER_NAME, PARAMETER_TYPE, ENCRYPTED, SCALAR_VALUE, VECTOR_VALUE, LARGE_VALUE, CREATED_AT_SUBMIT) SELECT :B4 , :B3 , PARAMETER_NAME, PARAMETER_TYPE, ENCRYPTED, SCALAR_VALUE, VECTOR_VALUE, LARGE_VALUE, CREATED_AT_SUBMIT FROM MGMT_JOB_PARAMETER WHERE JOB_ID=:B2 AND EXECUTION_ID=:B1
4bvhj5ctc66fwINSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5, exec_name) VALUES(:1, :2, :3, :4, :5, :6, '' '', :7, :8) RETURNING rowid into :9
4r194rhp4wpyuSELECT JOB_TYPE_ID FROM MGMT_JOB_TYPE_MAX_VERSIONS MV, MGMT_JOB J WHERE J. JOB_ID=:B1 AND J.JOB_TYPE=MV.JOB_TYPE AND J.JOB_TYPE_MAJOR_VERSION=MV.MAJOR_VERSION
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5dwsqwabg2pxySELECT COUNT(1) FROM MGMT_VERSIONS WHERE COMPONENT_NAME = UPPER(:B2 ) AND COMPONENT_MODE = :B1
5u0bnvvbvgf68SELECT NVL(SUM(TABLESPACE_SIZE)/1024/1024, 0) FROM MGMT$DB_TABLESPACES WHERE TARGET_GUID = HEXTORAW(:B1 )
5xp6xdg6cp1zvSELECT MAX(VALUE) FROM V$SYSSTAT WHERE NAME = ''user calls''
5zafwfnja12x3UPDATE WRR$_REPLAYS SET NUM_CLIENTS = NUM_CLIENTS + 1 WHERE ID = :B1
6097g1430c6p2BEGIN MGMT_PAF_AQ.DEQUEUE_REQUEST(p_node_id => :1 , p_wait => :2 , x_xml_data => :3, x_request_id => :4, x_timestamp => :5, x_return_status => :6 ) ; END;
6129566gyvx21SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
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;
6c06mfv01xt2hupdate wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, ''NORMAL''|| decode(bitand(ind.property, 4), 0, '''', 4, ''/REV''), 2, ''BITMAP'', 3, ''CLUSTER'', 4, ''IOT - TOP'', 5, ''IOT - NESTED'', 6, ''SECONDARY'', 7, ''ANSI'', 8, ''LOB'', 9, ''DOMAIN'') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (obj#, dataobj#) in (select objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = ''INDEX''
6h6dq383cant6SELECT MGMT_JOB_PARAMSRC_RECORD(SOURCE_ID, SOURCE_TYPE, SOURCE_DATA, OVERRIDE_USER, REQUIRED, ENCRYPTED, PA RAMETER_NAMES) FROM MGMT_JOB_PARAM_SOURCE WHERE JOB_TYPE_ID=:B1 AND APPLY_AT_SUBMISSION=1 ORDER BY SOURCE_INDEX
6htq3p9j91y0sINSERT INTO MGMT_JOB_EXEC_SUMMARY(JOB_ID, JOB_TYPE_ID, EXECUTION_ID, EXPECTED_START_TIME, START_TIME, END_TIME, SOURCE_EXECUTION_ID, TARGET_LIST_INDEX, STATUS, STATUS_DETAIL, TRIGGERING_SEVERITY) VALUES (:B11 , :B10 , :B6 , :B9 , :B8 , :B7 , DECODE(:B5 , NULL, :B6 , :B5 ), :B4 , :B3 , :B2 , :B1 )
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
6rm2uy96x1skzINSERT INTO MGMT_JOB_TARGET(JOB_ID, EXECUTION_ID, TARGET_LIST_INDEX, TARGET_GUID, TARGET_INDEX) SELECT JOB_ID, :B4 , TARGET_LIST_INDEX, TARGET_GUID, TARGET_INDEX FROM MGMT_JOB_TARGET WHERE JOB_ID=:B3 AND EXECUTION_ID=:B2 AND TARGET_LIST_INDEX=:B1
6wm3n4d7bnddg'), AWRRPT_HTML_TYPE(' 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 , '), AWRRPT_HTML_TYPE(' 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.inst ance_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 B'), AWRRPT_HTML_TYPE('Y source ASC, time_secs DESC, log_id ASC
71y370j6428cbinsert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread#
7fmujzn3gr8uz'), AWRRPT_HTML_TYPE('SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_JOB_RULE_CONFIGS C WHERE (C.TARGET_NAME||C.TARGET_TYPE IN (SELECT * FROM TABLE(CAST(:B11 AS MGMT_LONG_STRING_ARRAY))) OR (C.TARGET_NAME = ''%'' AND C.TARGET_TYPE IN (SELECT * FROM TABLE(CAST(:B12 AS MGMT_SHORT_STRING_ARRAY)))) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME||C.TARGET_TYPE IN (SELECT * FROM TABLE(CAST(:B11 AS MGMT_LONG_STRING_ARRAY))) ))) AND :B10 LIKE C.JOB_NAME ESCAPE :B7 AND :B9 LIKE C .JOB_OWNER ESCAPE :B7 AND :B8 LIKE C.JOB_TYPE ESCAPE :B7 AND ((:B2 = :B6 AND WANT_JOB_SCHEDULED = 1) OR (:B2 = :B5 AND WANT_JOB_RUNNING = 1) OR (:B2 = :B4 AND WANT_JOB_SUSPENDED = 1) OR (:B2 = :B3 AND WANT_JOB_SUCCEEDED = 1) OR (:B2 = :B1 AND WANT_JOB_PROBLEMS = 1))) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N.PROFILE_NAME) OR (N.DEVICE_NAME = '' '' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B14 , :B13 ) ) )'), AWRRPT_HTML_TYPE('
7gs8x44r7mpnbINSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, '' '', '' '', :11, :12, :13, :14, :15, :16) RETURNING rowid INTO :17
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#< /td>
7r2fggjj3vdntbegin dbms_workload_replay.start_replay; end;
7snbfvf2qc0v4begin :1 := dbms_workload_replay.client_connect( dbms_workload_replay.KECP_CLIENT_CONNECT_GOODBYE ); end;
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#
94vftcc9jztf1DECLARE row_count NUMBER := 0; par VARCHAR2(10); host_n VARCHAR2(64); BEGIN select count(*) into row_count from wrr$_replay_stats where id = :repid and instance_number = :instid and startup_time = :starttime; IF (row_count > 0) THEN update wrr$_replay_stats set user_calls = :usercalls, dbtime = :dbtime, network_time = :ntwktime, think_time = :thinktime, time_gain = :timegain, time_loss = :timeloss where id = :repid and instance_number = :instid and startup_time = :starttime; ELSE select parallel, host_name into par, host_n from v$instance; insert into wrr$_replay_stats( id, instance_number, startup_time, parallel, host_name, user_calls, dbtime, network_time, think_time, time_gain, time_loss) values (:repid, :instid, :starttime, par, host_n, :usercalls, :dbtime, :ntwktime, :thinktime, :timegain, :timeloss); END IF; END;
9gtqhd3dnpqvg'), AWRRPT_HTML_TYPE('select severity_code, message, b.collection_timestamp, d.value, d.collection_timestamp, c.metric_name, metric_column, b.key_value, c.metric_label, c.column_label, a.target_name, b.message_nlsid, b.message_params, case when c.metric_name != ''adrAlertLogIncidentError'' then NULL else (select p.string_value from mgmt_current_metrics p, mgmt_metrics q where p.metric_guid = q.metric_guid and q.metric_name = ''adrAlertLogIncidentError'' and q.metric_column = ''impact'' and p.key_value = b.key_value and p.target_guid = b.target_guid) end as impact, e.metric_label_nlsid, c.column_label_nlsid from mgmt_targets a, mgmt_current_severity b, mgmt_metrics c, mgmt_current_metrics d, (select category_prop_1, category_prop_2, category_prop_3, category_prop_4, category_prop_5, metric_name, target_type, type_meta_ver, metric_label_nlsid from mgmt_metrics where metric_column = '' '') e where a.target_guid = b.target_guid and b.metric_guid = c.metric_guid and b.metric_guid = d.metric_guid(+) and b.target_guid = d.target_guid(+) and e.target_type = a.target_type and e.metric_name = c.metric_name and b.key_value = d.key_value(+) and a.target_name = :1 and a.target_type = :2 and c.type_meta_ver = e.type_meta_ver AND c.type_meta_ver = a.type_meta_ver AND (c.category_prop_1 = a.category_prop_1 OR c.category_prop_1 = '' '') AND (c.category_prop_2 = a.category_prop_2 OR c.category_prop_2 = '' '') AND (c.category_prop_3 = a.category_prop_3 OR c.'), AWRRPT_HTML_TYPE('category_prop_3 = '' '') AND (c.category_prop_4 = a.category_prop_4 OR c.category_prop_4 = '' '') AND (c.category_prop_5 = a.category_prop_5 OR c.category_prop_5 = '' '') AND (e.category_prop_1 = a.category_prop_1 OR e.category_prop_1 = '' '') AND (e.category_prop_2 = a.category_prop_2 OR e.category_prop_2 = '' '') AND (e.category_prop_3 = a.category_prop_3 OR e.category_prop_3 = '' '') AND (e.category_prop_4 = a.category_prop_4 OR e.category_prop_4 = '' '') AND (e.category_prop_5 = a.category_prop_5 OR e.category_prop_5 = '' '') ORDER BY 1 desc
9k86ctcaydu0v'), AWRRPT_HTML_TYPE('select severity_code, message, b.collection_timestamp, d.value, d.collection_timestamp, c.metric_name, metric_column, b.key_value, c.metric_label, c.column_label, a.target_name, b.message_nlsid, b.message_params, case when c.metric_name != ''adrAlertLogIncidentError'' then NULL else (select p.string_value from mgmt_current_metrics p, mgmt_metrics q where p.metric_guid = q.metric_guid and q.metric_name = ''adrAlertLogIncidentError'' and q.metric_column = ''impact'' and p.key_value = b.key_value and p.target_guid = b.target_guid) end as impact, e.metric_label_nlsid, c.column_label_nlsid from mgmt_targets a, mgmt_current_severity b, mgmt_metrics c, mgmt_current_metrics d, (select category_prop_1, category_prop_2, category_prop_3, category_prop_4, category_prop_5, metric_name, target_type, type_meta_ver, metric_label_nlsid from mgmt_metrics where metric_column = '' '' and target_type = ''oracle_listener'') e where a.target_guid = b.target_guid and b.metric_guid = c.metric_guid and b.metric_guid = d.metric_guid(+) and b.target_guid = d.target_guid(+) and e.metric_name = c.metric_name and b.key_value = d.key_value(+) and a.host_name = :1 and a.target_type = ''oracle_listener'' and c.type_meta_ver = e.type_meta_ver AND c.type_meta_ver = a.type_meta_ver AND (c.category_prop_1 = a.category_prop_1 OR c.category_prop_1 = '' '') AND (c.category_prop_2 = a.category_prop_2 OR c.category_prop_2 = '' '') AND (c.category_prop_3 = a.category_prop_3 '), AWRRPT_HTML_TYPE('OR c.category_prop_3 = '' '') AND (c.category_prop_4 = a.category_prop_4 OR c.category_prop_4 = '' '') AND (c.category_prop_5 = a.category_prop_5 OR c.category_prop_5 = '' '') AND (e.category_prop_1 = a.category_prop_1 OR e.category_prop_1 = '' '') AND (e.category_prop_2 = a.category_prop_2 OR e.category_prop_2 = '' '') AND (e.category_prop_3 = a.category_prop_3 OR e.category_prop_3 = '' '') AND (e.category_prop_4 = a.category_prop_4 OR e.category_prop_4 = '' '') AND (e.category_prop_5 = a.category_prop_5 OR e.category_prop_5 = '' '') ORDER BY 1 desc
9wvf01xydy23mSELECT JOB_NAME, JOB_OWNER FROM MGMT_JOB WHERE JOB_ID=:B1
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:=''delete from sdo_geor_ddl__table$$''; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
b25x9c4k1swgfUPDATE MGMT_JOB_EXEC_SUMMARY SET SCHEDULED_TIME=MGMT_GLOBAL.FROM_UTC(:B3 , :B2 ), START_TIME=:B3 , END_TIME=:B3 , TIMEZONE_REGION=:B2 WHERE EXECUTION_ID=:B1
bfhwd5nkrwjtaSELECT JOB_ID, JOB_TYPE_ID FROM MGMT_JOB_EXEC_SUMMARY WHERE EXECUTION_ID=:B1
bjsc9c4gg59jjBEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.update_step_status(:2, :3, :4, :5); END; EMDW_LOG.set_context; END;
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
c9s3vj1tj3abaUPDATE WRR$_CAPTURES SET END_TIME = SYSDATE, END_SCN = (SELECT CURRENT_SCN FROM V$DATABASE) WHERE STATUS = :B1
cb21bacyh3c7dselect metadata from kopm$ where name=''DB_FDO''
cvvt9hc9c2br6'), AWRRPT_HTML_TYPE(' SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_t ime_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM WRH$_SQLSTAT s WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id > :bid AND s.snap_id <= :eid and s.sql_id in (select sql_id from (SELECT cnt , SQL_ID FROM ( SELECT count(*) as cnt , a.SQL_ID FROM WRH$_ACTIVE_SESSION_HISTORY a WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND a.session_type = 1 AND a.sql_id is NOT NULL AND a.wait_time = 0 AND a.event_id IN (SELECT ecl.event_id FROM WRH$_EVENT_NAME ecl WHERE ecl.dbid = :dbid AND ecl.wait_class_id = :ecl) GROUP BY SQL_ID HAVING count(*) >= :r'), AWRRPT_HTML_TYPE('owcnt ORDER BY 1 DESC ) WHERE rownum <= :ret)) GROUP BY s.sql_id HAVING sum( s.iowait_delta ) >= :ss_sigtime ORDER BY sum( s.iowait_delta ) DESC ) WHERE ROWNUM <= :ss_top ) stat , WRH$_SQLTEXT text WHERE text.dbid = :dbid AND text.sql_id = stat.sql_id ORDER BY stat.io_wait DESC
f0dm7wcn7p59hSELECT JOB_NAME, JOB_OWNER, DECODE(SOURCE_EXECUTION_ID, :B1 , 0, 1) FROM MGMT_JOB J, MGMT_JOB_EXEC_SUMMARY E WHERE E.EXECUTION_ID=:B1 AND J.JOB_ID=E.JOB_ID
f318xdxdn0pdcinsert into wrh$_log (snap_id, dbid, instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time) select :snap_id, :dbid, :instance_number, group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time from v$log
f80h0xb1qvbskSELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fqjyb76axcsajINSERT INTO MGMT_JOB_STATE_CHANGES(STATE_CHANGE_GUID, JOB_ID, EXECUTION_ID, STEP_ID, LOGGED, OCCURRED, NEWSTATE, STATUS_BUCKET, TYPE, VIOLATION_GUID) VALUES (:B8 , :B1 , :B2 , -1, :B7 , :B7 , :B3 , :B4 , :B6 , :B5 )
fyk8b9986ntk7SELECT EXECUTION_ID, STATUS, STATUS_DETAIL FROM MGMT_JOB_EXEC_SUMMARY WHERE JOB_ID = :B3 AND TARGET_LIST_INDEX = :B2 AND EXPECTED_START_TIME = :B1
fz6320qyay15hBEGIN DBMS_WORKLOAD_CAPTURE.START_CAPTURE ( name => ''capture1'', dir => ''DBREPLAY'', duration => 3600, default_action => ''EXCLUDE'', auto_unrestrict => TRUE); END;
g5vpd5g3y90qvINSERT INTO sys.wri$_adv_recommendations (id, task_id, finding_id, rank, benefit_msg_id, benefit_val, type, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
grwydz59pu6mcselect text from view$ where rowid=:1
'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE('
Back to Top

'), AWRRPT_HTML_TYPE('

'), AWRRPT_HTML_TYPE(''))