WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHostStd Block Size
First (1st)PRISMAQA3673847771prismaqa111.2.0.3.0NOserver18192
Second (2nd)PRISMAQA3673847771prismaqa111.2.0.3.0NOserver18192

Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st1326607-May-13 10:30:39 (Tue)1326707-May-13 10:40:40 (Tue) 1.0 10.0 9.7
2nd1326807-May-13 10:50:41 (Tue)1326907-May-13 11:00:41 (Tue) 0.3 10.0 2.9
%Diff     -70.1 -0.1 -70.0

Host Configuration Comparison

1st2ndDiff%Diff
Number of CPUs:323200.0
Number of CPU Cores:161600.0
Number of CPU Sockets:2200.0
Physical Memory:64318.1M64318.1M0M0.0
Load at Start Snapshot:2.671.58-1.09-40.8
Load at End Snapshot:1.813.461.6591.2
%User Time:3.33.64-2.69-80.8
%System Time:.52.59.0713.5
%Idle Time:96.1198.752.642.7
%IO Wait Time:.951.15.221.1

Cache Sizes

1st (M)2nd (M)Diff (M)%Diff
Memory Target    
SGA Target
2,048.02,048.00.00.0
Buffer Cache
688.0688.00.00.0
Shared Pool
944.0944.00.00.0
Large Pool
208.0208.00.00.0
Java Pool
160.0160.00.00.0
Streams Pool
16.016.00.00.0
PGA Target
1,024.01,024.00.00.0
Log Buffer10.010.00.00.0

Load Profile

1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 1.0 0.3 -70.1 0.6 0.2 -73.4
CPU time: 0.9 0.1 -92.1 0.6 0.0 -93.2
Redo size: 2,755.6 2,356.8 -14.5 1,823.6 1,359.9 -25.4
Logical reads: 1,166.6 1,211.8 3.9 772.0 699.3 -9.4
Block changes: 9.2 7.0 -23.1 6.1 4.1 -33.0
Physical reads: 684.5 809.1 18.2 453.0 466.8 3.1
Physical writes: 1.2 1.1 -6.8 0.8 0.6 -19.2
User calls: 48.1 31.5 -34.6 31.8 18.2 -42.9
Parses: 1,668.0 3.1 -99.8 1,103.9 1.8 -99.8
Hard parses: 1,646.3 0.7 -100.0 1,089.5 0.4 -100.0
W/A MB processed: 192,807.3 179,648.9 -6.8 127,598.5 103,661.1 -6.8
Logons: 0.1 0.1 37.5 0.1 0.1 0.0
Executes: 1,706.8 1,692.4 -0.8 1,129.6 976.5 -13.5
Transactions: 1.5 1.7 14.6   
1st2ndDiff
% Blocks changed per Read: 0.8 0.6 -0.2
Recursive Call %: 99.3 98.2 -1.1
Rollback per transaction %: 84.5 85.0 0.5
Rows per Sort: 33.8 38.4 4.6
Avg DB time per Call (sec): 0.0 0.0 -0.0

Top Timed Events

1st 2nd
EventWait ClassWaitsTime(s)Avg Time(ms)%DB timeEventWait ClassWaitsTime(s)Avg Time(ms)%DB time
CPU time  533.24 91.29db file sequential readUser I/O7,44581.0810.8946.22
direct path readUser I/O6,65241.296.217.07direct path readUser I/O7,74055.187.1331.45
db file sequential readUser I/O1,71613.177.682.26CPU time  42.86 24.43
control file sequential readSystem I/O1,4491.140.790.20control file sequential readSystem I/O1,4410.830.580.47
log file parallel writeSystem I/O2300.632.740.11db file parallel writeSystem I/O4550.721.580.41
-db file parallel writeSystem I/O4300.481.110.08-log file parallel writeSystem I/O2290.602.600.34

Report Details

Supplemental Information


Back to Top

Time Model Statistics

 % of DB time Time (seconds) Time per Trans (seconds)
Statistic Name1st2ndDiff1st2nd%Diff1st2nd%Diff
DB time100.00100.000.00584.12175.44-69.970.640.17-73.44
parse time elapsed80.822.00-78.82472.103.52-99.250.520.00-100.00
DB CPU91.2924.43-66.86533.2442.86-91.960.590.04-93.22
hard parse elapsed time60.281.91-58.37352.093.35-99.050.390.00-100.00
sql execute elapsed time99.4698.18-1.27580.94172.25-70.350.640.17-73.44
PL/SQL execution elapsed time5.815.17-0.6433.959.07-73.280.040.01-75.00
connection management call elapsed time0.070.190.120.420.33-21.430.000.000.00
hard parse (sharing criteria) elapsed time0.110.05-0.060.660.08-87.880.000.000.00
hard parse (bind mismatch) elapsed time0.110.04-0.060.640.08-87.500.000.000.00
Java execution elapsed time0.020.080.060.130.1515.380.000.000.00
PL/SQL compilation elapsed time0.010.060.050.030.10233.330.000.000.00
repeated bind elapsed time0.000.010.010.020.020.000.000.000.00
sequence load elapsed time0.000.00-0.000.020.00-100.000.000.000.00
failed parse elapsed time0.000.00-0.000.010.00-100.000.000.000.00
RMAN cpu time (backup/restore)0.000.000.000.000.000.000.000.000.00
failed parse (out of shared memory) elapsed time0.000.000.000.000.000.000.000.000.00
inbound PL/SQL rpc elapsed time0.000.000.000.000.000.000.000.000.00
background elapsed time2.798.555.7516.3114.99-8.090.020.01-50.00
background cpu time1.383.382.008.035.93-26.150.010.010.00



Back to Top

Operating System Statistics

 Value (centi-seconds) per Second (DB time) per Second (Elapsed Time) per Trans
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
BUSY_TIME74,80224,046128.06137.067.03124.4840.03-67.8482.3823.10-71.96
GLOBAL_RECEIVE_SIZE_MAX000.000.000.000.000.000.000.000.000.00
GLOBAL_SEND_SIZE_MAX000.000.000.000.000.000.000.000.000.00
IDLE_TIME1,846,9571,900,6563,161.9410,833.69242.633,073.613,164.182.952,034.091,825.80-10.24
IOWAIT_TIME18,20322,05531.16125.71303.4330.2936.7221.2320.0521.195.69
NICE_TIME000.000.000.000.000.000.000.000.000.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME10,04711,36517.2064.78276.6316.7218.9213.1611.0610.92-1.27
TCP_RECEIVE_SIZE_DEFAULT000.000.000.000.000.000.000.000.000.00
TCP_RECEIVE_SIZE_MAX000.000.000.000.000.000.000.000.000.00
TCP_RECEIVE_SIZE_MIN000.000.000.000.000.000.000.000.000.00
TCP_SEND_SIZE_DEFAULT000.000.000.000.000.000.000.000.000.00
TCP_SEND_SIZE_MAX000.000.000.000.000.000.000.000.000.00
TCP_SEND_SIZE_MIN000.000.000.000.000.000.000.000.000.00
USER_TIME63,98912,254109.5569.85-36.24106.4920.40-80.8470.4711.77-83.30
VM_IN_BYTES01,0240.005.84100.000.001.70100.000.000.98100.00
VM_OUT_BYTES000.000.000.000.000.000.000.000.000.00



Back to Top

Wait Events

Back to Top

Wait Classes

 % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
Wait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
User I/O9.3977.7668.3814.4225.5577.1854.84136.43148.786.338.8940.44
System I/O0.461.561.103.863.890.782.682.742.241.161.170.86
Concurrency0.030.130.100.250.02-92.000.160.2237.501.0716.911,480.37
Application0.070.00-0.070.010.00-100.000.430.00-100.0085.911.19-98.61
Commit0.070.130.060.220.2513.640.390.23-41.032.941.52-48.30
Other0.000.050.050.020.06200.000.020.09350.001.462.6883.56
Network0.000.020.0144.4927.88-37.330.020.0350.000.000.000.00


Back to Wait Events
Back to Top

Wait Events

  % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
EventWait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db file sequential readUser I/O2.2646.2243.962.8612.39333.2213.1781.08515.647.6810.8941.80
direct path readUser I/O7.0731.4524.3811.0712.8916.4441.2955.1833.646.217.1314.81
db file parallel writeSystem I/O0.080.410.330.720.765.560.480.7250.001.111.5842.34
control file sequential readSystem I/O0.200.470.282.412.40-0.411.140.83-27.190.790.58-26.58
control file parallel writeSystem I/O0.070.340.270.350.350.000.430.6039.532.062.8136.41
log file parallel writeSystem I/O0.110.340.230.380.380.000.630.60-4.762.742.60-5.11
os thread startupConcurrency0.030.120.100.010.010.000.160.2237.5022.7224.377.26
SQL*Net break/reset to clientApplication0.070.00-0.070.010.00-100.000.430.00-100.00107.100.00-100.00
log file syncCommit0.070.130.060.220.2513.640.390.23-41.032.941.52-48.30
ADR block file readOther0.000.040.040.010.03200.000.020.08300.004.964.07-17.94
db file scattered readUser I/O0.060.090.030.240.02-91.670.340.16-52.942.3410.87364.53
ADR block file writeOther0.000.010.010.000.01100.000.000.01100.000.002.66100.00
SQL*Net more data to clientNetwork0.000.010.010.520.6525.000.010.010.000.030.0433.33
SQL*Net message to clientNetwork0.000.010.0143.9727.22-38.090.010.010.000.000.000.00
read by other sessionUser I/O0.000.00-0.000.000.000.000.010.00-100.0014.750.00-100.00
Disk file operations I/OUser I/O0.000.000.000.230.244.350.010.010.000.040.040.00
direct path writeUser I/O0.000.00-0.000.020.00-100.000.010.00-100.001.010.00-100.00
enq: RO - fast object reuseApplication0.000.000.000.000.000.000.000.000.000.001.19100.00
local write waitUser I/O0.000.000.000.000.000.000.000.000.000.001.64100.00
SQL*Net more data from clientNetwork0.000.000.000.000.01100.000.000.000.000.020.21950.00
latch: shared poolConcurrency0.000.00-0.000.230.00-100.000.000.000.000.020.00-100.00
enq: KO - fast object checkpointApplication0.000.00-0.000.000.000.000.000.000.001.160.00-100.00
reliable messageOther0.000.000.000.000.000.000.000.000.000.320.14-56.25
buffer busy waitsConcurrency0.000.000.000.000.01100.000.000.000.000.250.14-44.00
ADR file lockOther0.000.000.000.000.01100.000.000.000.000.000.02100.00
latch freeOther0.000.00-0.000.010.00-100.000.000.000.000.030.00-100.00
LGWR wait for redo copyOther0.000.000.000.010.00-100.000.000.000.000.050.0860.00
library cache: mutex XConcurrency0.000.00-0.000.000.000.000.000.000.000.010.00-100.00
SQL*Net message from clientIdle1,881.3812,341.2210,459.8544.0427.31-37.9910,989.5521,651.3897.02415.261,319.88217.84
EMON slave idle waitIdle517.131,710.381,193.241.011.00-0.993,020.693,000.68-0.664,976.425,001.130.50
Space Manager: slave idle waitIdle565.521,630.561,065.041.191.03-13.453,303.342,860.64-13.404,607.164,621.390.31
DIAG idle waitIdle205.49684.13478.652.002.000.001,200.291,200.24-0.001,001.071,001.04-0.00
Streams AQ: qmn coordinator idle waitIdle105.49351.24245.750.070.070.00616.22616.21-0.0014,004.9814,004.85-0.00
Streams AQ: qmn slave idle waitIdle105.49351.24245.740.040.040.00616.22616.21-0.0028,009.8428,009.51-0.00
Streams AQ: emn coordinator idle waitIdle102.75342.11239.360.100.100.00600.19600.200.0010,003.2510,003.280.00
JOX Jit Process SleepIdle35.9785.5349.560.050.04-20.00210.08150.05-28.577,503.026,523.82-13.05
SGA: MMAN sleep for component shrinkIdle0.150.00-0.150.140.00-100.000.870.00-100.0010.670.00-100.00
class slave waitIdle0.000.000.000.010.010.000.000.000.000.080.080.00


Back to Wait Events
Back to Top

Service Statistics

Back to Top

Service Statistics

 % of DB time % CPU Time % Physical Reads % Logical Reads
Service Name1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
SYS$USERS100.0098.85-1.15100.0099.96-0.0499.9499.940.0092.8494.761.91
SYS$BACKGROUND0.000.000.000.000.000.000.060.04-0.027.225.19-2.02
prismaqa.world0.000.000.000.000.000.000.000.000.000.000.000.00


Back to Service Statistics
Back to Top

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
SYS$BACKGROUND0.000.000.000.000.000.000.00
SYS$USERS0.000.000.000.000.000.000.00
prismaqa.world0.000.000.000.000.000.000.00


Back to Service Statistics
Back to Top

SQL Statistics

Back to Top

Top SQL Comparison by Elapsed Time

 Elapsed Time % of DB time Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
81uvdbt46vt5p89.1489.14  -89.14520,702 0.00 520,667 0 0.00 1.00 1   DECLARE /* Yannick */ i NUMBER...
45ur4ja6vzbx2  45.2645.2645.26 79,409 0.01 1,844 78,005 6,928.00 0.00 1  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  45.1490.4145.14 79,201 0.01 1,719 77,923 6,919.00 0.00 1/ 1/ 1 create table dba_free_space_df...
dc1876qva6b705.8194.9525.27115.6819.4633,94044,3410.000.012,0003,73332,32941,222333,528.00333,493.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
28ja91pnth38j  13.96129.6413.96 24,492 0.01 24,487 0 0.00 1.00 1  DECLARE /* Yannick */ i NUMBER...
5536pyqxt9dd1  4.46134.104.46 7,823 0.01 1,158 6,795 69,213.00 39,675.00 1/ 1/ 1 SELECT customer.oid FROM custo...
fg6g5akd8jmyx  3.83137.933.83 0 5,699.97 0 0 0.00 0.00 1,000,000/ 1/ 1 SELECT /* Yannick */ descr FRO...
9k0mhy6948xdh  2.63140.572.63 4,619 0.01 1,524 3,103 253.00 50.00 1/ 1/ 1 SELECT 'FUNCTION' type, owner,...
8jk9z1dwpkpb31.4796.423.91144.482.444,2943,4300.000.012873504,0713,13937,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
6ajkhukk78nsr0.0396.460.81145.280.771971,4150.000.01718591265629.0068.001.001.0011  begin prvt_hdm.auto_execute( :...
bzgpy0vxtvf630.1296.580.60145.880.4817260.070.231726000.000.0014.934.9840411/ 1/ 1 SELECT event#, sql_id, sql_pla...
29npwaz6dqsva0.1596.730.37146.250.2255410.030.0945503610.389.75887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
7z7x3166pt4km0.1496.87  -0.14838 0.00 406 434 40.00 3.00 1 1// 1 SELECT 'SCHEMA' type, username...
61a161nm1ttjj0.1497.01  -0.147 0.21 6 0 0.03 0.00 123 1// 1 select /*+ INDEX(TAB AQ$_AQ_EV...
9nh7uqswpdc6h0.1197.12  -0.11642 0.00 19 626 74.00 0.00 1 1// 1 select OID, Customer_Oid, Cust...
b4mrsfc9ttham0.1197.230.01146.27-0.101610.070.23160000.050.006.155.9840411/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
db78fxqxwxt7r0.3397.560.39146.660.05114.254.5200110.060.0817.5316.852,4817931/ 1/ 1 select /*+ rule */ bucket, end...


Back to SQL Statistics
Back to Top

Top SQL Comparison by CPU Time

 CPU Time % of DB CPU CPU Time (ms) per Exec I/O Time (ms) per Exec #Exec/sec (DB time) Exec Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
81uvdbt46vt5p97.6497.64  -97.64520,667 0 0.00 520,702 0.00 1.00   DECLARE /* Yannick */ i NUMBER...
28ja91pnth38j  57.1357.1357.13 24,487 0 0.01 24,492 0.00 1.00  DECLARE /* Yannick */ i NUMBER...
fg6g5akd8jmyx  16.2273.3516.22 0 0 5,699.97 0 0.00 0.00/ 1/ 1 SELECT /* Yannick */ descr FRO...
dc1876qva6b700.3898.028.7182.078.342,0003,73332,32941,2220.000.0133,94044,341333,528.00333,493.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
45ur4ja6vzbx2  4.3086.374.30 1,844 78,005 0.01 79,409 6,928.00 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  4.0190.384.01 1,719 77,923 0.01 79,201 6,919.00 0.00/ 1/ 1 create table dba_free_space_df...
9k0mhy6948xdh  3.5693.933.56 1,524 3,103 0.01 4,619 253.00 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
5536pyqxt9dd1  2.7096.632.70 1,158 6,795 0.01 7,823 69,213.00 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
bzgpy0vxtvf630.1398.152.4499.082.321726000.070.2317260.000.0014.934.981/ 1/ 1 SELECT event#, sql_id, sql_pla...
6ajkhukk78nsr0.0198.162.00101.081.99718591265620.000.011971,4159.0068.001.001.00  begin prvt_hdm.auto_execute( :...
8jk9z1dwpkpb30.1198.271.64102.721.532873504,0713,1390.000.014,2943,43037,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
f1yky4nd9n9s60.1298.381.35104.061.231514000.070.2316140.000.0014.0014.001/ 1/ 1 select end_time, wait_class#, ...
d2687zmqyq4av0.0798.461.20105.271.131013000.070.2310130.000.0014.0014.001/ 1/ 1 select metric_id, value from v...
cyg8zddx2x8h60.1098.560.45105.720.35145000.070.231450.000.0014.0014.001/ 1/ 1 select FUNCTION_NAME, SMALL_RE...
61a161nm1ttjj0.1498.70  -0.146 0 0.21 7 0.03 0.00 1// 1 select /*+ INDEX(TAB AQ$_AQ_EV...
7z7x3166pt4km0.0898.77  -0.08406 434 0.00 838 40.00 3.00 1// 1 SELECT 'SCHEMA' type, username...
b4mrsfc9ttham0.1298.890.04105.76-0.07160000.070.231610.050.006.155.981/ 1/ 1 WITH snaps as (SELECT :1 dbid,...


Back to SQL Statistics
Back to Top

Top SQL Comparison by I/O Time

 I/O Time % of DB time I/O Time (ms) per Exec Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
45ur4ja6vzbx2  44.4644.4644.46 78,005 79,409 0.01 1,844 6,928.00 0.00 1  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  44.4288.8844.42 77,923 79,201 0.01 1,719 6,919.00 0.00 1/ 1/ 1 create table dba_free_space_df...
dc1876qva6b705.535.5323.50112.3717.9632,32941,22233,94044,3410.000.012,0003,733333,528.00333,493.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
5536pyqxt9dd1  3.87116.253.87 6,795 7,823 0.01 1,158 69,213.00 39,675.00 1/ 1/ 1 SELECT customer.oid FROM custo...
8jk9z1dwpkpb31.396.933.58119.832.184,0713,1394,2943,4300.000.0128735037,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
9k0mhy6948xdh  1.77121.601.77 3,103 4,619 0.01 1,524 253.00 50.00 1/ 1/ 1 SELECT 'FUNCTION' type, owner,...
6ajkhukk78nsr0.026.950.32121.920.301265621971,4150.000.01718599.0068.001.001.0011  begin prvt_hdm.auto_execute( :...
29npwaz6dqsva0.147.090.33122.240.19503655410.030.094510.389.75887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
9nh7uqswpdc6h0.117.20  -0.11626 642 0.00 19 74.00 0.00 1 1// 1 select OID, Customer_Oid, Cust...
7z7x3166pt4km0.077.27  -0.07434 838 0.00 406 40.00 3.00 1 1// 1 SELECT 'SCHEMA' type, username...
db78fxqxwxt7r0.307.560.33122.580.0411114.254.52000.060.0817.5316.852,4817931/ 1/ 1 select /*+ rule */ bucket, end...
61a161nm1ttjj0.017.57  -0.010 7 0.21 6 0.03 0.00 123 1// 1 select /*+ INDEX(TAB AQ$_AQ_EV...
b4mrsfc9ttham0.007.580.00122.58-0.00001610.070.231600.050.006.155.9840411/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
28ja91pnth38j  0.00122.580.00 0 24,492 0.01 24,487 0.00 1.00 1  DECLARE /* Yannick */ i NUMBER...
81uvdbt46vt5p0.007.58  0.000 520,702 0.00 520,667 0.00 1.00 1   DECLARE /* Yannick */ i NUMBER...
bzgpy0vxtvf630.007.580.00122.580.000017260.070.2317260.000.0014.934.9840411/ 1/ 1 SELECT event#, sql_id, sql_pla...
fg6g5akd8jmyx  0.00122.580.00 0 0 5,699.97 0 0.00 0.00 1,000,000/ 1/ 1 SELECT /* Yannick */ descr FRO...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Buffer Gets

 % Total Gets Gets per Exec #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
5536pyqxt9dd1  9.639.639.63 70,125.00 1 7,823 1,158 6,795 69,213.00 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
45ur4ja6vzbx2  6.7616.396.76 49,191.00 1 79,409 1,844 78,005 6,928.00 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  6.5422.936.54 47,593.00 1 79,201 1,719 77,923 6,919.00 0.00/ 1/ 1 create table dba_free_space_df...
9tgj4g8y4rwy8  3.0125.943.01 3.00 7,294 0 0 0 0.00 1.00/ 1/ 1 select type#, blocks, extents,...
9k0mhy6948xdh  2.4728.412.47 18,002.00 1 4,619 1,524 3,103 253.00 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
61a161nm1ttjj2.332.33  -2.33132.98 123 7 6 0 0.03 0.00 1// 1 select /*+ INDEX(TAB AQ$_AQ_EV...
96g93hntrzjtr2.114.450.3528.76-1.772.353.026,3018430000000.000.010.350.981/ 1/ 1 select /*+ rule */ bucket_cnt,...
dc1876qva6b7047.6852.1345.9274.68-1.76334,270.00334,270.001133,94044,3412,0003,73332,32941,222333,528.00333,493.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
b4mrsfc9ttham1.9154.050.3275.00-1.59335.3356.854041161160000.050.006.155.981/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
81uvdbt46vt5p1.2855.32  -1.288,963.00 1 520,702 520,667 0 0.00 1.00   DECLARE /* Yannick */ i NUMBER...
3w4qs0tbpmxr61.3256.650.3475.34-0.9827.6420.303351210000000.000.0112.829.151/ 1/ 1 select con#, obj#, rcon#, enab...
6ajkhukk78nsr0.3456.991.3076.630.952,415.009,451.00111971,415718591265629.0068.001.001.00  begin prvt_hdm.auto_execute( :...
53saa2zkr6wc31.3358.320.5177.15-0.814.064.242,2908830000000.000.011.031.121/ 1/ 1 select intcol#, nvl(pos#, 0), ...
5hk2758bxufj014.9173.2314.3691.51-0.55111.66111.669369361101000.020.0023.5323.531/ 1/ 1 SELECT column_name, nullable, ...
8jk9z1dwpkpb310.7683.9910.37101.87-0.4037,727.0037,727.00224,2943,4302873504,0713,13937,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
7qjhf5dzmazsr2.8486.832.74104.61-0.1019,921.0019,926.0011443346332345113013.000.008.006.001/ 1/ 1 SELECT snap_id , OBJ#, DATAOBJ...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Physical Reads

 % Total Physical Reads Physical Reads per Exec #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
5536pyqxt9dd1  14.2414.2414.24 69,213.00 1 7,823 1,158 6,795 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
dc1876qva6b7081.0981.0968.6282.86-12.47333,528.00333,493.001133,94044,3412,0003,73332,32941,2220.000.001/ 1/ 1 select qi.oid from dataload.qu...
8jk9z1dwpkpb318.3199.4015.5098.36-2.8137,654.0037,654.00224,2943,4302873504,0713,1391.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
45ur4ja6vzbx2  1.4399.791.43 6,928.00 1 79,409 1,844 78,005 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  1.42101.211.42 6,919.00 1 79,201 1,719 77,923 0.00/ 1/ 1 create table dba_free_space_df...
9k0mhy6948xdh  0.05101.260.05 253.00 1 4,619 1,524 3,103 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
db78fxqxwxt7r0.0499.430.01101.27-0.020.060.082,48179311001117.5316.851/ 1/ 1 select /*+ rule */ bucket, end...
9nh7uqswpdc6h0.0299.45  -0.0274.00 1 642 19 626 0.00 1// 1 select OID, Customer_Oid, Cust...
6ajkhukk78nsr0.0099.450.01101.290.019.0068.00111971,415718591265621.001.00  begin prvt_hdm.auto_execute( :...
7z7x3166pt4km0.0199.46  -0.0140.00 1 838 406 434 3.00 1// 1 SELECT 'SCHEMA' type, username...
6xvp6nxs4a9n40.0199.47  -0.011.33 27 17 2 15 1.00 1// 1 select nvl(sum(space), 0) from...
29npwaz6dqsva0.0499.510.03101.32-0.0110.389.7516165541455036887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
96g93hntrzjtr0.0199.520.00101.32-0.000.000.016,3018430000000.350.981/ 1/ 1 select /*+ rule */ bucket_cnt,...
5fkzpyqyptax30.0199.530.01101.33-0.0029.0031.00114553551061323492241.001.00  DECLARE instance_number NUMBE...
bqfx5q2jas08u0.0199.530.01101.34-0.0029.0031.001137124825273492241.001.001/ 1/ 1 SELECT TASK_LIST.TASK_ID FROM ...


Back to SQL Statistics
Back to Top

Top SQL Comparison by UnOptimized Read Requests

 % Total UnOptimized Read Requests Read Requests per Exec Total Read Requests %Optimized Reads #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec #Rows Processed per Exec #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
45ur4ja6vzbx2  45.5345.5345.53 6,928.00 6,928 0.00 1 79,409 1,844 78,005 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  45.4791.0145.47 6,919.00 6,919 0.00 1 79,201 1,719 77,923 0.00/ 1/ 1 create table dba_free_space_df...
dc1876qva6b7062.1662.1634.39125.40-27.775,265.005,232.005,2655,2320.000.001133,94044,3412,0003,73332,32941,2220.000.001/ 1/ 1 select qi.oid from dataload.qu...
5536pyqxt9dd1  7.31132.707.31 1,112.00 1,112 0.00 1 7,823 1,158 6,795 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
8jk9z1dwpkpb313.9876.147.78140.49-6.20592.00592.001,1841,1840.000.00224,2943,4302873504,0713,1391.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
9k0mhy6948xdh  1.61142.101.61 245.00 245 0.00 1 4,619 1,524 3,103 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
db78fxqxwxt7r1.7177.850.43142.52-1.280.060.08145650.000.002,48179311001117.5316.851/ 1/ 1 select /*+ rule */ bucket, end...
9nh7uqswpdc6h0.8478.69  -0.8471.00 71 0.00 1 642 19 626 0.00 1// 1 select OID, Customer_Oid, Cust...
7z7x3166pt4km0.4779.16  -0.4740.00 40 0.00 1 838 406 434 3.00 1// 1 SELECT 'SCHEMA' type, username...
6xvp6nxs4a9n40.4379.59  -0.431.33 36 0.00 27 17 2 15 1.00 1// 1 select nvl(sum(space), 0) from...
6ajkhukk78nsr0.1179.690.44142.960.339.0067.009670.000.00111971,415718591265621.001.00  begin prvt_hdm.auto_execute( :...
96g93hntrzjtr0.3180.000.07143.04-0.230.000.0126110.000.006,3018430000000.350.981/ 1/ 1 select /*+ rule */ bucket_cnt,...
5fkzpyqyptax30.4380.430.24143.27-0.1936.0036.0036360.000.00114553551061323492241.001.00  DECLARE instance_number NUMBE...
29npwaz6dqsva0.0080.430.00143.270.000.000.0000  16165541455036887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
bqfx5q2jas08u0.0080.430.00143.270.000.000.0000  1137124825273492241.001.001/ 1/ 1 SELECT TASK_LIST.TASK_ID FROM ...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Executions

 #Executions/sec (DB time) #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plan  
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
fg6g5akd8jmyx 5,699.975,699.97 1,000,000 0 0 0 0.00 0.00/ 1/ 1 SELECT /* Yannick */ descr FRO...
9tgj4g8y4rwy8 41.5841.58 7,294 0 0 0 0.00 1.00/ 1/ 1 select type#, blocks, extents,...
96g93hntrzjtr10.794.81-5.986,3018430000000.000.010.350.981/ 1/ 1 select /*+ rule */ bucket_cnt,...
5hk2758bxufj01.605.343.739369361101000.020.0023.5323.531/ 1/ 1 SELECT column_name, nullable, ...
53saa2zkr6wc33.925.031.112,2908830000000.000.011.031.121/ 1/ 1 select intcol#, nvl(pos#, 0), ...
5n1fs4m2n2y0r2.391.52-0.861,3942670000000.000.001.591.671/ 1/ 1 select pos#, intcol#, col#, sp...
djunbuupchm4s0.311.030.721801810000000.000.000.000.00  LOCK TABLE event_info IN EXCLU...
83taa7kaw59c11.220.85-0.377141490100000.010.0222.7516.211/ 1/ 1 select name, intcol#, segcol#,...
2q93zsrvbdw481.070.70-0.376241220000000.010.023.317.321/ 1/ 1 select grantee#, privilege#, n...
3nkd3g3ju5ph10.810.46-0.35476810000000.010.050.910.861/ 1/ 1 select obj#, type#, ctime, mti...
6aq34nj2zb2n70.970.70-0.285691220000000.020.040.000.001/ 1/ 1 select col#, grantee#, privile...
db78fxqxwxt7r4.254.520.272,4817931100110.060.0817.5316.851/ 1/ 1 select /*+ rule */ bucket, end...
7ng34ruy5awxq0.760.73-0.034441281111010.020.063.142.091/ 1/ 1 select i.obj#, i.ts#, i.file#,...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Parse Calls

 % Total Parses Parses #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st/2nd/BothSQL Text
djunbuupchm4s0.020.029.769.769.74180181180181  LOCK TABLE event_info IN EXCLU...
0ws7ahf1d78qa0.000.023.0212.783.02445644561/ 1/ 1 select SYS_CONTEXT('USERENV', ...
36ya4s1zjwx1h0.000.033.0215.803.02445644561/ 1/ 1 SELECT COUNT(*) FROM STATS$USE...
459f3z9u4fb3u0.000.033.0218.823.02445644561/ 1/ 1 select value$ from props$ wher...
bgba4tpdcpgun0.000.043.0221.843.0244564456  declare t_user_count NUMBER; l...
d6yky1ddz2m2q0.000.043.0224.873.02445644561/ 1/ 1 UPDATE STATS$USER_LOG SET LAST...
0k8522rmdzg4k0.000.042.9727.832.96445544551/ 1/ 1 select privilege# from sysauth...
5ur69atw3vfhj0.000.052.9730.802.96445544551/ 1/ 1 select decode(failover_method,...
cm5vu20fhtnq10.000.052.9733.762.96445546611/ 1/ 1 select /*+ connect_by_filterin...
5hk2758bxufj00.000.050.6534.410.6512129369361/ 1/ 1 SELECT column_name, nullable, ...
9zzuyxx4pjhsx0.000.06  -0.0028 28 1// 1 select p_obj#, flags, code, au...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Sharable Memory

 % Total Sharable Memory Sharable Memory Used Sharable Memory Max #Executions  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2ndSQL Text
9k0mhy6948xdh  0.200.200.20 1,984,309 1,984,309 1 SELECT 'FUNCTION' type, owner,...
a32bhg8ny1y4u0.110.11  -0.111,051,615 1,051,615 1  select * from dba_tab_statisti...
7z7x3166pt4km0.090.20  -0.09933,261 933,261 1  SELECT 'SCHEMA' type, username...
avv5dcc9zx2qb0.090.29  -0.09897,641 897,641 1  SELECT 'SCHEMA' type, username...
bd13sdj0ty0q4  0.040.240.04 429,547 429,547 1 SELECT 'X' FROM SYS.ALL_OBJECT...
3zzjfr9zwjc6s  0.040.290.04 425,390 425,390 1 select object_type from all_ob...
akfwbgvmmwhsm  0.040.330.04 425,386 425,386 1 select object_type from all_ob...
dqk6gb5778xxa  0.040.370.04 421,374 421,374 1 select object_type from all_ob...
654w48vhhm355  0.030.410.03 342,185 342,185 1 select t.column_name "Name", d...
0ctk7jpux5chm  0.030.440.03 291,986 291,986 1 WITH RECINFO AS ( SELECT /*+ N...
9zzuyxx4pjhsx0.020.31  -0.02166,287 166,287 28  select p_obj#, flags, code, au...
7k6zct1sya5300.010.32  -0.01134,701 134,701 1  insert into WRH$_STREAMS_APPLY...
8gt45jpvt1ywh0.020.350.040.470.01237,811353,307237,811353,3071012 INSERT INTO mn_hist_task (ver_...
b4mrsfc9ttham0.020.370.020.490.00221,420225,500221,420225,5004041 WITH snaps as (SELECT :1 dbid,...
29npwaz6dqsva0.030.400.030.520.00288,138288,138288,138288,1381616 SELECT CONFIG_VALUE_ID, CONFIG...
5hk2758bxufj00.010.410.010.540.00137,490137,490137,490137,490936936 SELECT column_name, nullable, ...
6wm3n4d7bnddg0.030.440.030.570.00287,826287,826287,826287,82611 SELECT source, (case when tim...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
9zzuyxx4pjhsx29 -2929 28  select p_obj#, flags, code, au...
b3zgx1xckrwxu10 -1010 9  select host, userid, password,...
0ctk7jpux5chm 44 4 1 WITH RECINFO AS ( SELECT /*+ N...
1gu8t96d0bdmu 44 4 47 select t.ts#, t.file#, t.block...
8gt45jpvt1ywh561561012 INSERT INTO mn_hist_task (ver_...
29npwaz6dqsva2222022221616 SELECT CONFIG_VALUE_ID, CONFIG...
36ya4s1zjwx1h440444456 SELECT COUNT(*) FROM STATS$USE...
3ktacv9r56b514404414335 select owner#, name, namespace...
5rygsj4dbw6jt440441051 insert into sys.mon_mods$ (obj...
5ur69atw3vfhj440444455 select decode(failover_method,...
7ng34ruy5awxq55055444128 select i.obj#, i.ts#, i.file#,...
83taa7kaw59c155055714149 select name, intcol#, segcol#,...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Cluster Wait Time

 % Total Cluster Wait Cluster Wait Time (sec) Cluster Wait Time per Exec (sec) #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
002cwnmg6c9xt  0.000.000.00 0.00 0.00 1/ 1/ 1 UPDATE mn_member SET ver_start...
0ctk7jpux5chm  0.000.000.00 0.00 0.00 1/ 2/ 2 WITH RECINFO AS ( SELECT /*+ N...
0k8522rmdzg4k0.000.000.000.000.000.000.000.000.0044551/ 1/ 1 select privilege# from sysauth...
0ws7ahf1d78qa0.000.000.000.000.000.000.000.000.0044561/ 1/ 1 select SYS_CONTEXT('USERENV', ...
0z1031991bd7w  0.000.000.00 0.00 0.00 1/ 1/ 1 insert into wrh$_sysmetric_sum...
1cq3qr774cu450.000.00  0.000.00 0.00 1 1// 1 insert into WRH$_IOSTAT_FILETY...
1fg26zq234bg2  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT 1 FROM sys.tab$ WHERE o...
1gu8t96d0bdmu  0.000.000.00 0.00 0.00 47/ 1/ 1 select t.ts#, t.file#, t.block...
1p36ta7p3d7fu  0.000.000.00 0.00 0.00 1/ 1/ 1 select file#, block#, ts#, blo...
23buxzfxyp1vy  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT greatest(0, 1000*servi...
23nad9x295gkf  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT (m.current_size / 10485...
29npwaz6dqsva0.000.000.000.000.000.000.000.000.0016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
2q93zsrvbdw480.000.000.000.000.000.000.000.000.006241221/ 1/ 1 select grantee#, privilege#, n...
2xrc1gttayzmy0.000.00  0.000.00 0.00 1 1// 1 SELECT /*+ ORDERED USE_MERGE(...
317v5hnvvd49h0.000.00  0.000.00 0.00 1 1// 1 UPDATE wrh$_seg_stat_obj ob S...
350myuyx0t1d60.000.000.000.000.000.000.000.000.00111/ 1/ 1 insert into wrh$_tablespace_st...
35hatv0pj8hw70.000.00  0.000.00 0.00 10 1// 1 select decode(u.type#, 2, u.ex...
36ya4s1zjwx1h0.000.000.000.000.000.000.000.000.0044561/ 1/ 1 SELECT COUNT(*) FROM STATS$USE...


Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db block changes5,5044,226-23.229.4224.09155.739.167.04-23.146.064.06-33.00
execute count1,025,6411,016,567-0.881,755.875,794.40230.001,706.821,692.37-0.851,129.56976.53-13.55
logons cumulative516527.450.090.37311.110.080.1137.500.060.060.00
opened cursors cumulative1,025,3061,015,924-0.921,755.295,790.74229.901,706.261,691.30-0.881,129.19975.91-13.57
parse count (total)1,002,3021,854-99.821,715.9110.57-99.381,667.983.09-99.811,103.861.78-99.84
parse time elapsed46,815187-99.6080.151.07-98.6777.910.31-99.6051.560.18-99.65
physical reads411,307485,98318.16704.152,770.09293.39684.48809.0618.20452.98466.843.06
physical writes704654-7.101.213.73208.261.171.09-6.840.780.63-19.23
redo size1,655,8721,415,652-14.512,834.808,069.18184.652,755.622,356.76-14.471,823.651,359.90-25.43
session cursor cache hits23,30631,18633.8139.90177.76345.5138.7851.9233.8825.6729.9616.71
session logical reads701,006727,9303.841,200.104,149.18245.741,166.581,211.853.88772.03699.26-9.43
user calls28,90518,910-34.5849.48107.79117.8548.1031.48-34.5531.8318.17-42.92
user commits14115610.640.240.89270.830.230.2613.040.160.15-6.25
user rollbacks76788515.381.315.04284.731.281.4714.840.840.851.19
workarea executions - optimal5,8513,028-48.2510.0217.2672.269.745.04-48.256.442.91-54.81


Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
Block Cleanout Optim referenced1513-13.330.030.07133.330.020.020.000.020.01-50.00
CPU used by this session53,5074,398-91.7891.6025.07-72.6389.047.32-91.7858.934.22-92.84
CPU used when call started1,2941,90246.992.2210.84388.292.153.1747.441.431.8327.97
CR blocks created320566.670.010.111,000.000.000.03100.000.000.02100.00
Cached Commit SCN referenced18,70318,701-0.0132.02106.60232.9231.1231.130.0320.6017.96-12.82
Commit SCN cached54-20.000.010.02100.000.010.010.000.010.00-100.00
DBWR checkpoint buffers written53165222.790.913.72308.790.881.0923.860.580.638.62
DBWR checkpoints12100.000.000.01100.000.000.000.000.000.000.00
DBWR transaction table writes162237.500.030.13333.330.030.0433.330.020.020.00
DBWR undo block writes119105-11.760.200.60200.000.200.17-15.000.130.10-23.08
HSC Heap Segment Block Changes1,101700-36.421.883.99112.231.831.17-36.071.210.67-44.63
Heap Segment Array Inserts1061114.720.180.63250.000.180.180.000.120.11-8.33
Heap Segment Array Updates577836.840.100.44340.000.090.1344.440.060.0716.67
IMU Flushes109-10.000.020.05150.000.020.01-50.000.010.010.00
IMU Redo allocation size61,204102,28067.11104.78582.99456.39101.85170.2767.1867.4198.2545.75
IMU commits13114611.450.220.83277.270.220.249.090.140.140.00
IMU undo allocation size198,744267,19234.44340.241,522.99347.62330.74444.8234.49218.88256.6717.27
Number of read IOs issued6,6527,74016.3611.3944.12287.3611.0712.8916.447.337.441.50
Requests to/from client26,28516,179-38.4545.0092.22104.9343.7426.93-38.4328.9515.54-46.32
RowCR attempts110.000.000.01100.000.000.000.000.000.000.00
RowCR hits110.000.000.01100.000.000.000.000.000.000.00
SMON posted for dropping temp segment110.000.000.01100.000.000.000.000.000.000.00
SQL*Net roundtrips to/from client26,28516,180-38.4445.0092.23104.9643.7426.94-38.4128.9515.54-46.32
TBS Extension: tasks created220.000.000.01100.000.000.000.000.000.000.00
TBS Extension: tasks executed220.000.000.01100.000.000.000.000.000.000.00
active txn count during cleanout547538.890.090.43377.780.090.1233.330.060.0716.67
background timeouts3,3993,4020.095.8219.39233.165.665.660.003.743.27-12.57
buffer is not pinned count161,632127,682-21.00276.71727.78163.01268.98212.56-20.98178.01122.65-31.10
buffer is pinned count433,952246,471-43.20742.911,404.8889.11722.16410.32-43.18477.92236.76-50.46
bytes received via SQL*Net from client1,545,4621,530,908-0.942,645.798,726.13229.812,571.882,548.63-0.901,702.051,470.61-13.60
bytes sent via SQL*Net to client9,625,1479,209,867-4.3116,477.9752,495.98218.5816,017.6715,332.45-4.2810,600.388,847.13-16.54
calls to get snapshot scn: kcmgss1,025,8731,018,003-0.771,756.265,802.59230.391,707.201,694.76-0.731,129.82977.91-13.45
calls to kcmgas6387,2121,030.411.0941.113,671.561.0612.011,033.020.706.93890.00
calls to kcmgcs1,81517,501864.243.1199.763,107.723.0229.14864.902.0016.81740.50
cell physical IO interconnect bytes3,408,162,3044,018,923,00817.925,834,673.5422,907,748.26292.615,671,687.356,690,644.5817.973,753,482.713,860,636.902.85
change write time73-57.140.010.02100.000.010.00-100.000.010.00-100.00
cleanout - number of ktugct calls12115124.790.210.86309.520.200.2525.000.130.1515.38
cleanouts only - consistent read gets667513.640.110.43290.910.110.129.090.070.070.00
cluster key scan block gets98,43198,128-0.31168.51559.33231.93163.80163.36-0.27108.4094.26-13.04
cluster key scans30,60832,6626.7152.40186.17255.2950.9454.386.7533.7131.38-6.91
commit cleanout failures: callback failure1312-7.690.020.07250.000.020.020.000.010.010.00
commit cleanout failures: cannot pin3433.330.010.02100.000.000.01100.000.000.000.00
commit cleanouts950672-29.261.633.83134.971.581.12-29.111.050.65-38.10
commit cleanouts successfully completed934656-29.761.603.74133.751.551.09-29.681.030.63-38.83
commit txn count during cleanout1791927.260.311.09251.610.300.326.670.200.18-10.00
consistent changes1632100.000.030.18500.000.030.0566.670.020.0350.00
consistent gets694,826722,4983.981,189.524,118.22246.211,156.291,202.804.02765.23694.04-9.30
consistent gets - examination43,05235,792-16.8673.70204.01176.8171.6459.59-16.8247.4134.38-27.48
consistent gets direct409,207478,39516.91700.552,726.84289.24680.98796.4316.95450.67459.551.97
consistent gets from cache285,619244,103-14.54488.971,391.38184.55475.31406.38-14.50314.56234.49-25.45
consistent gets from cache (fastpath)237,285197,567-16.74406.221,126.13177.22394.88328.91-16.71261.33189.79-27.38
cursor authentications8,09276-99.0613.850.43-96.9013.470.13-99.038.910.07-99.21
data blocks consistent reads - undo records applied318500.000.010.10900.000.000.03100.000.000.02100.00
db block gets6,1805,432-12.1010.5830.96192.6310.289.04-12.066.815.22-23.35
db block gets from cache6,1695,432-11.9510.5630.96193.1810.279.04-11.986.795.22-23.12
db block gets from cache (fastpath)1,4771,79921.802.5310.25305.142.462.9921.541.631.736.13
deferred (CURRENT) block cleanout applications556374-32.730.952.13124.210.930.62-33.330.610.36-40.98
enqueue conversions818125.000.010.10900.000.010.03200.000.010.02100.00
enqueue releases991,7828,954-99.101,697.9051.04-96.991,650.4714.91-99.101,092.278.60-99.21
enqueue requests991,7858,962-99.101,697.9151.08-96.991,650.4814.92-99.101,092.278.61-99.21
enqueue timeouts330.000.010.02100.000.000.000.000.000.000.00
enqueue waits12100.000.000.01100.000.000.000.000.000.000.00
file io service time2,4411,999-18.114.1811.39172.494.063.33-17.982.691.92-28.62
free buffer inspected1,1676,268437.102.0035.731,686.501.9410.43437.631.296.02366.67
free buffer requested2,2297,782249.133.8244.361,061.263.7112.96249.332.457.48205.31
heap block compress1413-7.140.020.07250.000.020.020.000.020.01-50.00
hot buffers moved to head of LRU1707,6924,424.710.2943.8415,017.240.2812.814,475.000.197.393,789.47
immediate (CR) block cleanout applications669137.880.110.52372.730.110.1536.360.070.0928.57
immediate (CURRENT) block cleanout applications8010430.000.140.59321.430.130.1730.770.090.1011.11
index crx upgrade (positioned)44440.000.080.25212.500.070.070.000.050.04-20.00
index fetch by key15,27722,71348.6726.15129.46395.0725.4237.8148.7416.8221.8229.73
index scans kdiixs164,77462,243-3.91110.89354.78219.94107.79103.62-3.8771.3459.79-16.19
java call heap collected bytes783,568783,5680.001,341.454,466.32232.951,303.971,304.470.04862.96752.71-12.78
java call heap collected count9,7249,7240.0016.6555.43232.9116.1816.190.0610.719.34-12.79
java call heap gc count440.000.010.02100.000.010.010.000.000.000.00
java call heap live object count7,4387,4380.0012.7342.40233.0712.3812.380.008.197.15-12.70
java call heap live object count max7,4387,4380.0012.7342.40233.0712.3812.380.008.197.15-12.70
java call heap live size529,264529,2640.00906.083,016.79232.95880.77881.110.04582.89508.42-12.78
java call heap live size max529,264529,2640.00906.083,016.79232.95880.77881.110.04582.89508.42-12.78
java call heap object count15,75015,7500.0026.9689.77232.9726.2126.220.0417.3515.13-12.80
java call heap object count max15,75015,7500.0026.9689.77232.9726.2126.220.0417.3515.13-12.80
java call heap total size2,621,4402,621,4400.004,487.8314,942.13232.954,362.464,364.140.042,887.052,518.19-12.78
java call heap total size max2,621,4402,621,4400.004,487.8314,942.13232.954,362.464,364.140.042,887.052,518.19-12.78
java call heap used size1,129,0241,129,0240.001,932.866,435.41232.951,878.861,879.580.041,243.421,084.56-12.78
java call heap used size max1,129,0241,129,0240.001,932.866,435.41232.951,878.861,879.580.041,243.421,084.56-12.78
java session heap live size843,776843,7760.001,444.524,809.50232.951,404.171,404.710.04929.27810.54-12.78
java session heap live size max843,776843,7760.001,444.524,809.50232.951,404.171,404.710.04929.27810.54-12.78
java session heap used size843,776843,7760.001,444.524,809.50232.951,404.171,404.710.04929.27810.54-12.78
java session heap used size max843,776843,7760.001,444.524,809.50232.951,404.171,404.710.04929.27810.54-12.78
leaf node 90-10 splits141721.430.020.10400.000.020.0350.000.020.020.00
leaf node splits2422-8.330.040.13225.000.040.040.000.030.02-33.33
lob reads1741740.000.300.99230.000.290.290.000.190.17-10.53
lob writes835337.500.010.201,900.000.010.06500.000.010.03200.00
lob writes unaligned835337.500.010.201,900.000.010.06500.000.010.03200.00
logical read bytes from cache2,390,327,2962,044,190,720-14.484,092,169.9711,651,829.69184.733,977,859.003,403,138.99-14.452,632,519.051,963,679.85-25.41
messages received737690-6.381.263.93211.901.231.15-6.500.810.66-18.52
messages sent737690-6.381.263.93211.901.231.15-6.500.810.66-18.52
min active SCN optimization applied on CR284457.140.050.25400.000.050.0740.000.030.0433.33
no work - consistent read gets645,785665,2583.021,105.563,791.95242.991,074.681,107.513.05711.22639.06-10.15
non-idle wait count38,04834,675-8.8765.14197.65203.4263.3257.73-8.8341.9033.31-20.50
parse count (failures)105-50.000.020.0350.000.020.01-50.000.010.00-100.00
parse count (hard)989,293415-99.961,693.642.37-99.861,646.330.69-99.961,089.530.40-99.96
parse time cpu46,368152-99.6779.380.87-98.9077.160.25-99.6851.070.15-99.71
physical read IO requests8,47015,21579.6314.5086.73498.1414.1025.3379.659.3314.6256.70
physical read bytes3,369,426,9443,981,172,73618.165,768,359.7422,692,572.77293.405,607,225.976,627,798.4818.203,710,822.633,824,373.433.06
physical read total IO requests9,96416,69367.5317.0695.15457.7416.5827.7967.6110.9716.0446.22
physical read total bytes3,393,601,5364,005,085,18418.025,809,745.9322,828,873.05292.945,647,456.086,667,607.5818.063,737,446.633,847,344.082.94
physical read total multi block requests6,4167,50416.9610.9842.77289.5310.6812.4916.957.077.211.98
physical reads cache2,0027,490274.133.4342.691,144.613.3312.47274.472.207.20227.27
physical reads cache prefetch18415-91.850.320.09-71.880.310.02-93.550.200.01-95.00
physical reads direct409,305478,49316.90700.722,727.40289.23681.14796.5916.95450.78459.651.97
physical reads direct (lob)5045040.000.862.87233.720.840.840.000.560.48-14.29
physical write IO requests468455-2.780.802.59223.750.780.76-2.560.520.44-15.38
physical write bytes5,767,1685,357,568-7.109,873.2230,537.99209.309,597.428,919.20-7.076,351.515,146.56-18.97
physical write total IO requests1,1251,113-1.071.936.34228.501.871.85-1.071.241.07-13.71
physical write total bytes14,560,76813,837,824-4.9724,927.6178,875.21216.4224,231.2823,037.01-4.9316,036.0913,292.82-17.11
physical write total multi block requests8912.500.010.05400.000.010.010.000.010.010.00
physical writes from cache693654-5.631.193.73213.451.151.09-5.220.760.63-17.11
physical writes non checkpoint317266-16.090.541.52181.480.530.44-16.980.350.26-25.71
pinned cursors current4650.000.010.03200.000.010.010.000.000.01100.00
recursive calls4,088,2601,035,503-74.676,998.985,902.34-15.676,803.471,723.89-74.664,502.49994.72-77.91
recursive cpu usage50,0681,859-96.2985.7110.60-87.6383.323.09-96.2955.141.79-96.75
redo blocks checksummed by FG (exclusive)1,7341,661-4.212.979.47218.862.892.77-4.151.911.60-16.23
redo blocks written3,6072,995-16.976.1817.07176.216.004.99-16.833.972.88-27.46
redo entries3,0552,378-22.165.2313.55159.085.083.96-22.053.362.28-32.14
redo ordering marks9187-4.400.160.50212.500.150.14-6.670.100.08-20.00
redo subscn max counts22726717.620.391.52289.740.380.4415.790.250.264.00
redo synch time3516-54.290.060.0950.000.060.03-50.000.040.02-50.00
redo synch time (usec)394,581226,327-42.64675.511,290.0690.98656.64376.79-42.62434.56217.41-49.97
redo synch writes1441514.860.250.86244.000.240.254.170.160.15-6.25
redo wastage69,61675,5288.49119.18430.51261.23115.85125.748.5476.6772.55-5.37
redo write time6362-1.590.110.35218.180.100.100.000.070.06-14.29
redo writes2302300.000.391.31235.900.380.380.000.250.22-12.00
rollbacks only - consistent read gets32-33.330.010.010.000.000.000.000.000.000.00
rows fetched via callback2,0462,1354.353.5012.17247.713.403.554.412.252.05-8.89
session uga memory2,571,23210,296,928300.474,401.8758,692.201,233.354,278.9117,142.18300.622,831.759,891.38249.30
session uga memory max79,158,80897,307,92822.93135,517.55554,652.46309.28131,731.99161,996.8222.9787,179.3093,475.447.22
shared hash latch upgrades - no wait3,8753,492-9.886.6319.90200.156.455.81-9.924.273.35-21.55
sorts (memory)9,4304,067-56.8716.1423.1843.6215.696.77-56.8510.393.91-62.37
sorts (rows)318,461155,970-51.02545.20889.0263.06529.97259.66-51.00350.73149.83-57.28
sql area purged107-30.000.020.04100.000.020.01-50.000.010.010.00
switch current to new buffer9612328.130.160.70337.500.160.2025.000.110.129.09
table fetch by rowid234,672131,265-44.06401.75748.2186.24390.53218.53-44.04258.45126.10-51.21
table fetch continued row12066-45.000.210.3880.950.200.11-45.000.130.06-53.85
table scan blocks gotten471,894508,0377.66807.872,895.80258.45785.30845.777.70519.71488.03-6.10
table scan rows gotten8,002,3798,728,7809.0813,699.8449,753.80263.1713,317.1514,531.559.128,813.198,385.00-4.86
table scans (cache partitions)2350.000.000.02100.000.000.000.000.000.000.00
table scans (direct read)5740.000.010.04300.000.010.010.000.010.010.00
table scans (long tables)440.000.010.02100.000.010.010.000.000.000.00
table scans (short tables)7289,9891,272.121.2556.944,455.201.2116.631,274.380.809.601,100.00
total cf enq hold time407075.000.070.40471.430.070.1271.430.040.0775.00
total number of cf enq holders54-20.000.010.02100.000.010.010.000.010.00-100.00
total number of times SMON posted71157.140.010.06500.000.010.02100.000.010.010.00
undo change vector size527,184455,076-13.68902.522,593.92187.41877.31757.60-13.65580.60437.15-24.71


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function - Data Rate per Second

Total Reads Buffer Cache Reads Direct Reads Total Writes DBWR Direct Writes LGWR
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
5.396.3618.000.030.10233.335.326.2216.920.020.020.000.010.010.000.000.000.000.000.000.00


Back to IO Stats
Back to Top

IOStat by Function - Requests per Second

Total Reads Buffer Cache Reads Direct Reads Total Writes DBWR Direct Writes LGWR
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
16.5927.9268.293.0312.58315.1811.0712.8916.441.881.86-1.060.760.760.000.020.00-100.000.390.390.00


Back to IO Stats
Back to Top

IOStat by File Type - Data Rate per Second

Total Reads Data File Reads Temp File Reads Total Writes Data File Writes Temp File Writes Log File Writes
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
5.396.3618.005.356.3218.130.000.000.000.020.0350.000.010.010.000.000.000.000.000.000.00


Back to IO Stats
Back to Top

IOStat by File Type - Requests per Second

Total Reads Data File Reads Temp File Reads Total Writes Data File Writes Temp File Writes Log File Writes
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
16.5927.9368.3514.1725.5380.170.000.000.001.881.86-1.060.780.76-2.560.000.000.000.390.390.00


Back to IO Stats
Back to Top

Tablespace IO Stats

 Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
Tablespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
MN_DATA1 0.3911.502,848.720.000.000.002366,9090.0010.452.141.0400000.000.000.3911.5011.11
MN_DATA_LARGE1 10.7812.5516.420.030.030.006,4777,5360.130.0363.1363.431919000.000.0010.8112.581.77
MN_DATA11 1.700.03-98.240.020.0350.001,019173.7110.591.181.181221000.000.001.720.06-1.65
SYSAUX 0.390.32-17.950.510.533.9223219310.829.431.001.02308321000.000.000.900.86-0.04
SYSTEM 0.590.7018.640.100.02-80.0035542311.8611.351.001.026211432.500.000.690.720.03


Back to IO Stats
Back to Top

Top File Comparison by IO

  Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
TablespaceFilename1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
MN_DATA1/ora_prismaqa/data/prismaqa/mndata09.dbf 0.000.86100.000.000.000.0005190.0011.100.001.0000000.000.000.000.860.86
MN_DATA1/ora_prismaqa/data/prismaqa/mndata13.dbf 0.000.84100.000.000.000.0005030.009.400.001.0000000.000.000.000.840.84
MN_DATA1/ora_prismaqa/data/prismaqa/mndata12.dbf 0.000.64100.000.000.000.0003860.009.900.001.0000000.000.000.000.640.64
MN_DATA1/ora_prismaqa/data/prismaqa/mndata11.dbf 0.000.51100.000.000.000.0003090.0010.420.001.0000000.000.000.000.510.51
MN_DATA1/ora_prismaqa/data/prismaqa/mndata10.dbf 0.000.44100.000.000.000.0002670.0010.410.001.0000000.000.000.000.440.44
MN_DATA1/ora_prismaqa/data/prismaqa/mndata08.dbf 0.000.32100.000.000.000.0001930.008.450.001.0000000.000.000.000.320.32


Back to IO Stats
Back to Top

Top File Comparison by Read Time

  Read Time % of DB time Avg Read Time (ms) Reads Avg Reads per Sec Avg Blocks per Read Writes Avg Writes per Sec Buffer Waits Avg Buf Wait Time (ms)
TablespaceFilename1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
MN_DATA1/ora_prismaqa/data/prismaqa/mndata02.dbf 0.007.527.520.008.401561,5720.262.622.081.11000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata04.dbf 0.005.285.280.0014.90106220.021.042.801.03000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata01.dbf 0.004.444.440.0011.49146780.021.132.001.02000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata05.dbf 0.003.363.360.0011.2665240.010.873.331.03000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata09.dbf 0.003.283.280.0011.1005190.000.860.001.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata03.dbf 0.003.033.030.0010.88124890.020.812.001.02000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata06.dbf 0.002.502.500.0010.05344360.060.732.001.08000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata07.dbf 0.002.222.220.0010.6043680.010.613.001.02000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata10.dbf 0.001.581.580.0010.4102670.000.440.001.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata08.dbf 0.000.930.930.008.4501930.000.320.001.00000.000.00000.000.00
MN_DATA_LARGE1/ora_prismaqa/data/prismaqa/mn_data_large1_01.dbf 0.040.01-0.030.080.002,5282,8664.214.7763.3563.69120.000.00000.000.00


Back to IO Stats
Back to Top

Top File Comparison by Buffer Waits

No data exists for this section of the report.

Back to IO Stats
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Target MTTR(s)Estimated MTTR(s)Recovery Estimated IOsActual Redo Blocks Target Redo Blocks Log File Size Redo Blocks Log Ckpt Timeout Redo Blocks Log Ckpt Interval Redo Blocks Optimal Log File Size (Mb)Estimated Cluster Available Time (s)
B1073451,211636,5501,492,992636,550   
E107261705629,2211,492,992629,221   
           
B2072871,024630,2461,492,992630,246   
E20730280511,3311,492,99211,331   


Back to Advisory Statistics
Back to Top

PGA Aggregate Summary

PGA Cache Hit % W/A Bytes/Sec (DB time) W/A MB Processed Read/Written W/A Bytes/Sec (DB time) Read/Written W/A MB
1st2ndDiff1st2nd%Diff1st2nd1st2nd%Diff1st2nd
100.00100.000.00198,348660,156232.83110110000.0000


Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M)W/A PGA Used(M)%PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B11,024713331.60.80.3100.00.0104,850
E11,024715334.70.80.3100.00.0104,850
         
B21,024715349.50.80.2100.00.0104,850
E21,024710354.56.61.9100.00.0104,850


Back to Advisory Statistics
Back to Top

Wait Stats

Back to Top

Buffer Wait Statistics

 Wait Time % of DB time Total Wait Time (s) # Waits Avg Wait Time (ms)
Class1st2ndDiff1st2nd1st2nd1st2nd%Diff
data block0.000.00-0.000.010.00430.030.00-100.00
undo header0.000.000.000.000.00010.000.000.00


Back to Wait Stats
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Stats
Back to Top

Undo Segment Summary

Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1st8.848921,080323/330/00/0/0/0/0/0
2nd0.281,0631,078423/330/00/0/0/0/0/0



Back to Top

Latch Statistics

Back to Top

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Wait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool97.900.00-97.9045,357,48839,0834,35804,220014002,3840-2,384
space background task latch3.500.00-3.501,8671,68237283228501400-140


Back to Latch Statistics
Back to Top

Latch Wait Time Breakdown

 Wait Time (cs) Get Requests Misses Spin Gets Sleeps % of Total Sleeps
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool2,3840-2,38445,357,48839,0834,35804,2200140097.900.00-97.90
space background task latch1400-1401,8671,68237283228503.500.00-3.50


Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Top Segments Comparison by Logical Reads

     % of Total Logical Reads Logical Reads % of Captured Logical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMIND$ TABLE13.6113.61  -13.6195,424  14.25 -14.25
SYSSYSTEMCOL$ TABLE  12.4112.4112.41 90,368  13.0813.08
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  6.5818.996.58 47,872  6.936.93
DATALOADMN_DATA11PRO_USER TABLE5.5219.13  -5.5238,704  5.78 -5.78
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE32.6251.7631.4250.41-1.21228,688228,6880.0034.1433.09-1.05
DATALOADMN_DATA_LARGE1QUOTE TABLE11.0562.8110.6461.05-0.4177,45677,4560.0011.5611.21-0.35
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE10.7573.5510.3571.40-0.4075,32875,3280.0011.2510.90-0.34


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Reads

     % of Total Physical Reads Physical Reads % of Captured Physical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  9.859.859.85 47,865  10.0010.00
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE55.6055.6047.0656.91-8.54228,685228,6850.0055.7447.80-7.95
DATALOADMN_DATA_LARGE1QUOTE TABLE18.8374.4315.9372.84-2.8977,43477,4340.0018.8816.18-2.69
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE18.3192.7415.5088.33-2.8175,30875,3080.0018.3615.74-2.62
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE6.6699.395.6393.97-1.0227,37427,3740.006.675.72-0.95
DATALOADMN_DATA11PRO_USER TABLE0.2599.64  -0.251,009  0.25 -0.25


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Read Requests

     % of Total Read Requests Read Requests % of Captured Read Requests
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE42.3142.3123.5623.56-18.763,5843,5840.0046.6945.13-1.56
DATALOADMN_DATA11PRO_USER TABLE9.9352.24  -9.93841  10.96 -10.96
DATALOADMN_DATA_LARGE1QUOTE TABLE14.3666.607.9931.55-6.361,2161,2160.0015.8415.31-0.53
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE13.9880.587.7839.33-6.201,1841,1840.0015.4214.91-0.51
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  5.0144.345.01 763  9.619.61
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE5.1085.682.8447.18-2.264324320.005.635.44-0.19


Back to Segment Statistics
Back to Top

Top Segments Comparison by UnOptimized Read Requests

     % of Total UnOptimized Requests UnOptimized Requests % of Captured UnOptimized Reqs
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE42.3142.3123.5623.56-18.763,5843,5840.0046.6945.13-1.56
DATALOADMN_DATA11PRO_USER TABLE9.9352.24  -9.93841  10.96 -10.96
DATALOADMN_DATA_LARGE1QUOTE TABLE14.3666.607.9931.55-6.361,2161,2160.0015.8415.31-0.53
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE13.9880.587.7839.33-6.201,1841,1840.0015.4214.91-0.51
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  5.0144.345.01 763  9.619.61
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE5.1085.682.8447.18-2.264324320.005.635.44-0.19


Back to Segment Statistics
Back to Top

Top Segments Comparison by Optimized Read Requests

     % of Total Optimized Read Requests Optimized Requests % of Captured Optimized Reqs
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMCOL$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMFILE$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMIND$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_FILE#_BLOCK# INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMI_OBJ# INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMOBJ$ TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMSEG$ TABLE0.000.000.000.000.00000.000.000.000.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Reads

     % of Total Direct Reads Direct Reads % of Captured Direct Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  10.0010.0010.00 47,854  10.0110.01
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE55.8755.8747.7957.79-8.08228,685228,6850.0055.9447.84-8.10
DATALOADMN_DATA_LARGE1QUOTE TABLE18.9274.7916.1873.98-2.7477,43477,4340.0018.9416.20-2.74
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE18.4093.1915.7489.72-2.6675,30875,3080.0018.4215.76-2.67
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE6.6999.885.7295.44-0.9727,37427,3740.006.705.73-0.97
SYSSYSTEMIND$ TABLE0.0099.88  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Writes

     % of Total Physical Writes Physical Writes % of Captured Physical Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__3673847771_13254INDEX PARTITION  2.142.142.14 14  7.497.49
SYSSYSAUXWRH$_PARAMETER_PKWRH$_PARAME_3673847771_13254INDEX PARTITION1.991.99  -1.9914  7.53 -7.53
SYSSYSAUXWRH$_LATCH_MISSES_SUMMARY_PKWRH$_LATCH__3673847771_13254INDEX PARTITION  1.994.131.99 13  6.956.95
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_3673847771_13254INDEX PARTITION1.853.84  -1.8513  6.99 -6.99
SYSSYSAUXWRH$_ROWCACHE_SUMMARY_PKWRH$_ROWCAC_3673847771_13254INDEX PARTITION1.855.68  -1.8513  6.99 -6.99
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB1.707.39  -1.7012  6.45 -6.45
SYSSYSAUXWRH$_SYSSTATWRH$_SYSSTA_3673847771_13254TABLE PARTITION0.577.951.996.121.42413225.002.156.954.80
SYSSYSAUXWRH$_SEG_STATWRH$_SEG_ST_3673847771_13254TABLE PARTITION0.718.661.998.101.28513160.002.696.954.26
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION0.719.371.9910.091.28513160.002.696.954.26
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__3673847771_13254TABLE PARTITION1.8511.220.6110.70-1.23134-69.236.992.14-4.85


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Write Requests

     % of Total Write Requests Write Requests % of Captured Write Requests
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB2.562.56  -2.5612  10.91 -10.91
DATALOADMN_DATA11MN_HIST_HEALTH TABLE  1.541.541.54 7  6.196.19
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX  1.543.081.54 7  6.196.19
SYSSYSAUXWRH$_BG_EVENT_SUMMARY_PK INDEX  1.324.401.32 6  5.315.31
DATALOADMN_DATA_LARGE1MN_HIST_QUERY_USAGE TABLE1.283.85  -1.286  5.45 -5.45
SYSSYSAUXWRH$_PARAMETER_PKWRH$_PARAME_3673847771_13254INDEX PARTITION1.074.91  -1.075  4.55 -4.55
SYSSYSAUXWRH$_SQL_PLAN TABLE1.926.841.545.93-0.3897-22.228.186.19-1.99
DATALOADMN_DATA_LARGE1MN_HIST_TASK TABLE2.569.402.428.35-0.151211-8.3310.919.73-1.17


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Writes

     % of Total Direct Writes Direct Writes % of Captured Direct Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB100.00100.00  -100.0011  100.00 -100.00
SYSSYSTEMCOL$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMFILE$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMIND$ TABLE0.00100.00  0.000 100.000.00 0.00
SYSSYSTEMI_FILE#_BLOCK# INDEX0.00100.000.000.000.00000.000.000.000.00
SYSSYSTEMI_OBJ# INDEX0.00100.000.000.000.00000.000.000.000.00
SYSSYSTEMSEG$ TABLE0.00100.000.000.000.00000.000.000.000.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Table Scans

     % of Total Table Scans Table Scans % of Captured Table Scans
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1CUSTOMER_ALIAS TABLE  25.0025.0025.00 1  25.0025.00
YJAQUIERUSERSTEST1 TABLE25.0025.00  -25.001  25.00 -25.00
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE25.0050.0025.0050.000.00110.0025.0025.000.00
DATALOADMN_DATA_LARGE1QUOTE TABLE25.0075.0025.0075.000.00110.0025.0025.000.00
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE25.00100.0025.00100.000.00110.0025.0025.000.00
SYSSYSTEMCOL$ TABLE  0.00100.000.00 0  0.000.00
SYSSYSTEMIND$ TABLE0.00100.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by DB Block Changes

     % of Total Block Changes DB Block Changes % of Captured Block Changes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXWRH$_SQL_PLAN TABLE4.654.651.141.14-3.5225648-81.2534.046.98-27.07
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX  1.893.031.89 80  11.6311.63
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__3673847771_13254INDEX PARTITION  1.144.161.14 48  6.986.98
SYSSYSAUXWRH$_SQLSTATWRH$_SQLSTA_3673847771_13254TABLE PARTITION0.004.651.145.301.14048100.000.006.986.98
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_3673847771_13254INDEX PARTITION0.875.52  -0.8748  6.38 -6.38
SYSSYSAUXWRH$_SERVICE_WAIT_CLASS_PKWRH$_SERVIC_3673847771_13254INDEX PARTITION0.876.40  -0.8748  6.38 -6.38
SYSSYSTEMSEG$ TABLE1.167.560.766.06-0.416432-50.008.514.65-3.86
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION0.878.431.147.190.2648480.006.386.980.59


Back to Segment Statistics
Back to Top

Top Segments by Row Lock Waits

     % of Total Row Lock Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd%Diff1st1st Total2nd2nd TotalDiff
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX 200.00200.00 2   100.00100.00100.00


Back to Segment Statistics
Back to Top

Top Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Top Segments by Buffer Busy Waits

     % of Total Buffer Busy Waits Buffer Busy Waits % of Captured Buffer Busy Waits
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMSEG$ TABLE100.00100.0075.0075.00-25.00330.00100.00100.000.00


Back to Segment Statistics
Back to Top

Top Segments by GC Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

 Get Requests per Sec (DB time) Get Requests per Sec (Elapsed Time) Get Requests Pct Miss Scan Requests Pct Miss Mod Reqs Final Usage
Cache1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
dc_awr_control0.020.08300.000.020.020.0013140.000.00000.000.002211
dc_free_extents0.100.35250.000.100.100.0060626.679.68220.000.0010114851
dc_global_oids0.100.44340.000.100.1330.0060773.331.30000.000.00003839
dc_histogram_data11.4846.89308.4511.1613.7022.766,7088,22736.999.64000.000.00001,3902,607
dc_histogram_defs3,406.4358.05-98.303,311.2716.95-99.491,989,76910,1840.328.28000.000.00001,8032,876
dc_object_grants0.010.111,000.000.010.03200.007190.000.00000.000.00005454
dc_objects1,706.7442.39-97.521,659.0612.38-99.25996,9437,4370.051.14000.000.00051,6571,771
dc_profiles0.080.31287.500.070.0928.5744550.000.00000.000.000022
dc_rollback_segments0.772.58235.060.750.750.004524520.000.00000.000.00006767
dc_segments5,080.4712.67-99.754,938.553.70-99.932,967,6172,2220.0214.76000.000.001423523875
dc_sequences0.020.04100.000.020.01-50.00127100.0028.57000.000.0012704
dc_table_scns0.000.01100.000.000.000.0022100.00100.00000.000.000001
dc_tablespaces10.05113.411,028.469.7733.12239.005,86919,8960.000.00000.000.00001414
dc_used_extents0.010.03200.000.010.010.004550.0060.00000.000.004500
dc_users3,395.6684.26-97.523,300.8124.61-99.251,983,48214,7830.000.01000.000.00006364
global database name0.832.81238.550.810.821.234844930.000.00000.000.000011
outstanding_alerts0.020.06200.000.020.020.0011110.000.00000.000.00001111



Back to Top

Library Cache Activity

 Get Requests per Sec (DB Time) Get Requests per Sec (Elapsed Time) Get Requests Pct Miss Pin Requests Pct Miss Reloads Invalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
ACCOUNT_STATUS0.150.63320.000.150.1820.008811011.360.0000  0000
BODY0.040.26550.000.040.0775.0025450.000.0059740.001.350100
CLUSTER0.060.32433.330.050.0980.0033576.061.7533576.061.750000
DBLINK0.150.60300.000.140.1828.578610610.470.0000  0000
EDITION0.130.49276.920.130.147.69778636.360.0012114130.580.001000
INDEX0.000.39100.000.000.11100.00069 15.94069 15.940000
JAVA DATA0.000.01100.000.000.000.00220.000.0000  0000
OBJECT ID0.000.01100.000.000.000.0001 100.0000  0000
QUEUE0.010.010.000.000.000.00320.000.001271220.000.000000
SCHEMA0.511.0198.040.500.29-42.002991770.000.0000  0000
SQL AREA1,715.639.29-99.461,667.702.71-99.841,002,1371,62996.9811.232,998,9641,018,23398.690.0917,762126109
SQL AREA BUILD1,694.272.14-99.871,646.940.63-99.96989,66137699.9469.4100  0000
SQL AREA STATS1,692.731.68-99.901,645.440.49-99.97988,75929499.0587.41988,75929499.0587.411000
TABLE/PROCEDURE1,734.91106.32-93.871,686.4431.05-98.161,013,39818,6520.020.393,003,98320,9840.082.322,06029000
TRIGGER0.080.40400.000.070.1271.43447020.4510.00447020.4510.000000



Back to Top

Memory Statistics

Back to Top

Process Memory Summary

  1st 2nd % Diff of
CategorySummaryBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
FreeableAlloc (KB)46,144.0050,368.009.1565,088.0057,024.00-12.3941.0513.21
Used (KB)0.000.000.000.000.000.000.000.00
Avg Alloc (KB)1,073.121,144.736.671,384.851,239.65-10.4829.058.29
Std Dev Alloc (KB)895.55965.227.781,307.421,224.20-6.3745.9926.83
Max Alloc (KB)4,544.004,928.004.234,672.004,928.005.482.824.05
Hist Max Alloc (KB)        
Num Procs43.0044.002.3347.0046.00-2.139.304.55
Num Alloc43.0044.002.3347.0046.00-2.139.304.55
JAVAAlloc (KB)    2,421.92   
Used (KB)    2,413.58   
Avg Alloc (KB)    2,421.92   
Std Dev Alloc (KB)    0.00   
Max Alloc (KB) 2,421.92  2,421.92   
Hist Max Alloc (KB)    2,954.10   
Num Procs    1.00   
Num Alloc    1.00   
OtherAlloc (KB)282,257.71281,009.93-0.44281,660.32286,122.491.58-0.211.82
Used (KB)        
Avg Alloc (KB)1,742.331,734.63-0.441,738.641,734.08-0.26-0.21-0.03
Std Dev Alloc (KB)2,062.492,052.53-0.482,055.752,038.07-0.86-0.33-0.70
Max Alloc (KB)17,565.0817,505.70-0.4017,494.0317,505.700.07-0.400.07
Hist Max Alloc (KB)23,128.6323,128.630.0023,128.6323,128.630.000.000.00
Num Procs162.00162.000.00162.00165.001.850.001.85
Num Alloc162.00162.000.00162.00165.001.850.001.85
PL/SQLAlloc (KB)8,763.118,757.41-0.078,756.228,834.990.90-0.080.89
Used (KB)6,558.626,555.87-0.046,534.166,592.860.90-0.370.56
Avg Alloc (KB)54.0954.06-0.0754.0553.55-0.93-0.08-0.95
Std Dev Alloc (KB)242.79242.75-0.01242.69240.55-0.88-0.04-0.91
Max Alloc (KB)2,826.912,826.910.002,826.912,826.910.000.000.00
Hist Max Alloc (KB)3,056.803,056.800.003,056.803,056.800.000.000.00
Num Procs162.00162.000.00162.00165.001.850.001.85
Num Alloc162.00162.000.00162.00165.001.850.001.85
SQLAlloc (KB)2,486.802,730.329.792,515.098,746.49247.761.14220.35
Used (KB)691.70717.053.66705.786,246.17785.002.04771.10
Avg Alloc (KB)16.8018.329.0616.8857.92243.150.46216.10
Std Dev Alloc (KB)47.8348.210.7947.06508.53980.65-1.61954.90
Max Alloc (KB)471.966,238.960.00471.966,238.961,221.920.001,221.92
Hist Max Alloc (KB)119,575.72119,575.720.00119,575.72106,242.12-11.150.00-11.15
Num Procs148.00149.000.68149.00151.001.340.681.34
Num Alloc141.00142.000.71144.00145.000.692.132.11


Back to Memory Statistics
Back to Top

SGA Memory Summary

 1st 2nd % Diff of
SGA regionsBegin Value (KB)End Value (KB)%DiffBegin Value (KB)End Value (KB)%DiffBegin ValuesEnd Values
Database Buffers737,280.00704,512.00-4.44704,512.00704,512.000.00-4.440.00
Fixed Size2,177.802,177.800.002,177.802,177.800.000.000.00
Redo Buffers21,216.0021,216.000.0021,216.0021,216.000.000.000.00
Variable Size1,327,106.201,359,874.202.471,359,874.201,359,874.200.002.470.00


Back to Memory Statistics
Back to Top

SGA Breakdown Difference

  1st 2nd %Diff of
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
java poolJOXLE24,244,41624,208,128-0.1524,244,41624,244,4160.000.000.15
java poolfree memory142,914,880142,951,1680.03142,914,880142,914,8800.000.00-0.03
large poolPX msg pool8,192,0008,192,0000.008,192,0008,192,0000.000.000.00
large poolfree memory209,911,808209,911,8080.00209,911,808209,911,8080.000.000.00
shared poolASH buffers42,949,67242,949,6720.0042,949,67242,949,6720.000.000.00
shared poolCheckpoint queue33,570,81633,570,8160.0033,570,81633,570,8160.000.000.00
shared poolFileOpenBlock15,937,34415,937,3440.0015,937,34415,937,3440.000.000.00
shared poolKGLDA 13,054,616      
shared poolKGLH0101,881,432248,708,888144.12159,743,152163,649,3042.4556.79-34.20
shared poolKGLHD15,974,81638,726,264142.4225,399,97625,902,5281.9859.00-33.11
shared poolKGLS14,830,568       
shared poolKTI-UNDO10,635,23210,635,2320.0010,635,23210,635,2320.000.000.00
shared poolSQLA79,656,312136,386,28071.2290,013,840101,206,56012.4313.00-25.79
shared pooldb_block_hash_buckets11,669,50411,669,5040.0011,669,50411,669,5040.000.000.00
shared pooldbktb: trace buffer14,745,60014,745,6000.0014,745,60014,745,6000.000.000.00
shared pooldbwriter coalesce buffer16,793,60016,793,6000.0016,793,60016,793,6000.000.000.00
shared pooldirty object counts array16,777,21616,777,2160.0016,777,21616,777,2160.000.000.00
shared poolevent statistics per sess18,009,08818,009,0880.0018,009,08818,009,0880.000.000.00
shared poolfree memory356,215,464170,055,136-52.26314,822,600291,439,648-7.43-11.6271.38
shared poolkglsim heap 11,003,264 11,003,26411,003,2640.00 0.00
shared poolkglsim object batch15,873,31219,045,65619.9919,045,65619,045,6560.0019.990.00
shared poolksunfy : SSO free list16,787,20016,787,2000.0016,787,20016,787,2000.000.000.00
shared poolprivate strands20,564,99220,564,9920.0020,564,99220,564,9920.000.000.00
streams poolKTG hash buckets660,216660,2160.00660,216660,2160.000.000.00
streams poolfree memory16,115,56016,115,5600.0016,115,56016,115,5600.000.000.00
 buffer_cache754,974,720721,420,288-4.44721,420,288721,420,2880.00-4.440.00
 fixed_sga2,230,0722,230,0720.002,230,0722,230,0720.000.000.00
 log_buffer21,725,18421,725,1840.0021,725,18421,725,1840.000.000.00


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams by CPU Time

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


Back to Streams Statistics
Back to Top

Streams by IO Time

 IO Time (sec) CPU Time (sec)
Session Type1st User1st System1st Total2nd User2nd System2nd TotalTotal %Diff1st2nd%Diff
QMON Coordinator0.000.000.000.000.000.000.000.000.000.00
QMON Slaves0.000.000.000.000.000.000.000.000.00-0.02


Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

 Enq Msgs Deq Msgs %Delay Msgs %Exp Msgs Enq Time(s) Deq Time(s) %Transf Time %Eval Time
Queue Name1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd%Diff1st2nd%Diff1st2nd1st2nd
SYS.ALERT_QUE(12328) 000.00000.00    0.000.000.000.000.000.00    
SYS.AQ$_ALERT_QT_E(12327) 000.00000.00    0.000.000.000.000.000.00    


Back to Streams Statistics
Back to Top

Persistent Queues Rate

 Enqueue Msgs/sec Dequeue Msgs/sec Avg Enqueue sec / msg Avg Dequeue sec / msg
Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE(12328) 0.000.000.000.000.000.00  0.00  0.00
SYS.AQ$_ALERT_QT_E(12327) 0.000.000.000.000.000.00  0.00  0.00


Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

 Enqueue Msgs Dequeue Msgs Expire Msgs Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec
Subscriber/Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SERVER1_3872_PRISMA(22)/SYS.ALERT_QUE 000.00000.00000.000.000.000.000.000.000.000.000.000.00
SERVER1_DOMAI_3872_PRISMA(42)/SYS.ALERT_QUE 000.00000.00000.000.000.000.000.000.000.000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000.00000.00000.00  0.00  0.00  0.00
NGSERVER1_DO_3872_PRISMA(62)/SYS.ALERT_QUE 000.00000.00000.000.000.000.000.000.000.000.000.000.00
NGserver1_DO_3872_PRISMAQA(82)/SYS.ALERT_QUE 000.00000.00000.000.000.000.000.000.000.000.000.000.00


Back to Streams Statistics
Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total Connections Avg Active Connections Avg Total Shared Servers Avg Active Shared Servers Avg Total Dispatchers Avg Active Dispatchers
1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff
0000.000000.000000.000000.000000.000000.00


Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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


Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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


Back to Shared Server Statistics
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
_allow_level_without_connect_by TRUE  
_b_tree_bitmap_plans FALSE  
_fast_full_scan_enabled FALSE  
_gby_hash_aggregation_enabled FALSE  
_like_with_bind_as_equality TRUE  
_optimizer_connect_by_cost_based FALSE  
_remove_aggr_subquery FALSE  
_sort_elimination_cost_ratio 5  
audit_trail NONE  
compatible 11.2.0.3.0  
control_files /ora_prismaqa/ctrl/prismaqa/cont  
db_block_size 8192  
db_cache_advice ready  
db_domain world  
db_files 1024  
db_name prismaqa  
db_writer_processes 4  
diagnostic_dest /ora_prismaqa/dump/prismaqa  
disk_asynch_io FALSE  
filesystemio_options setall  
instance_name prismaqa  
java_pool_size 167772160  
job_queue_processes 10  
large_pool_size 218103808  
log_archive_dest_1 LOCATION=/ora_prismaqa/arch/pris  
log_buffer 10485760  
log_checkpoint_interval 0  
log_checkpoints_to_alert TRUE  
open_cursors 2000  
os_authent_prefix    
pga_aggregate_target 1073741824  
processes 900  
session_cached_cursors 50  
sessions 1376  
sga_max_size 2147483648  
sga_target 2147483648  
sort_area_size 524288  
statistics_level typical  
undo_management AUTO  
undo_tablespace UNDOTBS1  
utl_file_dir /log_recv/prisma/logs  


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
control_files  /ora_prismaqa/ctrl/prismaqa/control01.ctl    
  /ora_prismaqa/ctrl/prismaqa/control02.ctl    


Back to init.ora Parameters
Back to Top

Complete List of SQL Text

SQL IdSQL Text
002cwnmg6c9xtUPDATE mn_member SET ver_start_date = :1 , cont_obj_mgr_id = :2 , ver_end_date = :3 , oid = :4 , pricing_region_id = :5 , ver_state = :6 , description = :7 , comments = :8 , end_ver_num = :9 , cntct_id = :10 , ver_num = :11 , member_id_updated = :12 , mgr_id = :13 , display_name = :14 , cont_obj_id = :15 , realm_num = :16 , status_flg_vector = :17 , date_updated = :18 , bulk_op_id = :19 , member_name = :20 WHERE ((mn_member.member_id = :21 ) AND (mn_member.date_updated = :22 )) AND (mn_member.realm_num IN (1024, 1, 0))
0ctk7jpux5chmWITH RECINFO AS ( SELECT /*+ NO_MERGE */ FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE ), F_CURR AS ( SELECT /*+ NO_MERGE */ DISTINCT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ), TASKS AS ( SELECT /*+ NO_MERGE */ T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ), F_ALL AS ( SELECT /*+ NO_MERGE */ COUNT(FA.TASK_ID) FINDING_COUNT, FA.FINDING_NAME FROM TASKS, DBA_ADVISOR_FINDINGS FA WHERE FA.TASK_ID=TASKS.TASK_ID AND FA.TYPE<>'INFORMATION' AND FA.TYPE<>'WARNING' AND FA.PARENT=0 GROUP BY FA.FINDING_NAME ), HISTORY AS ( SELECT /*+ NO_MERGE */ FINDING_NAME, FINDING_COUNT FROM F_ALL JOIN F_CURR USING (FINDING_NAME) ) SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_CHAR(TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') START_TIME, TO_CHAR(TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, RECINFO, HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0z1031991bd7winsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
1cq3qr774cu45insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1fg26zq234bg2SELECT 1 FROM sys.tab$ WHERE obj# = :1 AND bitand(property, 262144) != 0
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1p36ta7p3d7fuselect file#, block#, ts#, blocks from seg$ where type# = 3
23buxzfxyp1vy SELECT greatest(0, 1000*servicetime - req*:expio ) as impact FROM ( SELECT sum( case when iostat.snap_id = :eid then iostat.small_read_reqs else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_reqs else 0 end) as req, sum( case when iostat.snap_id = :eid then iostat.small_read_servicetime else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_servicetime else 0 end) as servicetime FROM WRH$_IOSTAT_FILETYPE iostat, WRH$_IOSTAT_FILETYPE_NAME fn WHERE iostat.dbid = fn.dbid AND iostat.filetype_id = fn.filetype_id AND (fn.filetype_name = 'Data File' OR fn.filetype_name = 'Temp File') AND iostat.dbid = :dbid AND iostat.instance_number = :inst AND iostat.snap_id IN (:bid, :eid) )
23nad9x295gkfSELECT (m.current_size / 1048576) as sizemb, case when cast(m.last_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as changed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT buffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DEFAULT 8K buffer cache', 6, 'DEFAULT 16K buffer cache', 7, 'DEFAULT 32K buffer cache', 8, 'SGA Target', 9, 'PGA Target', 10, 'memory target', 11 , 255) as comp_id FROM WRH$_MEM_DYNAMIC_COMP m , WRM$_SNAPSHOT s WHERE m.dbid = :dbid AND m.instance_number = :inst_num AND m.snap_id = :end_snap_id AND s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id = :begin_snap_id
28ja91pnth38jDECLARE /* Yannick */ i NUMBER; sql_stmt VARCHAR2(200); max_id number; BEGIN SELECT MAX(id) INTO max_id FROM yjaquier.test1; DBMS_RANDOM.SEED(SYSDATE); sql_stmt:='SELECT /* Yannick */ descr FROM yjaquier.test1 WHERE id=:id'; FOR i IN 1..max_id LOOP EXECUTE IMMEDIATE sql_stmt USING ROUND(DBMS_RANDOM.VALUE(1, max_id)); END LOOP; END;
29npwaz6dqsvaSELECT CONFIG_VALUE_ID, CONFIG_ID, VALUE, DESCRIPTION, CLOB_VALUE, NODE_ID, OWNER, RELATED_ORG_ID FROM MN_CONFIGURATION_VALUE WHERE FEATURE = :1 AND INIT_CONFIGSET_VALUE = 1
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#
2xrc1gttayzmy SELECT /*+ ORDERED USE_MERGE(m) */ TO_CHAR( FROM_TZ( CAST(m.end_time AS TIMESTAMP), TO_CHAR(systimestamp, 'tzr') ) AT TIME ZONE sessiontimezone, 'YYYY-MM-DD HH24:MI:SS'), SUM(CASE WHEN a.internal_metric_name = 'transactions_ps' THEN m.value ELSE 0 END) transactions_ps, SUM(CASE WHEN a.internal_metric_name = 'physreads_ps' THEN m.value ELSE 0 END) physreads_ps, SUM(CASE WHEN a.internal_metric_name = 'physreads_pt' THEN m.value ELSE 0 END) physreads_pt, SUM(CASE WHEN a.internal_metric_name = 'physwrites_ps' THEN m.value ELSE 0 END) physwrites_ps, SUM(CASE WHEN a.internal_metric_name = 'physwrites_pt' THEN m.value ELSE 0 END) physwrites_pt, SUM(CASE WHEN a.internal_metric_name = 'physreadsdir_ps' THEN m.value ELSE 0 END) physreadsdir_ps, SUM(CASE WHEN a.internal_metric_name = 'physreadsdir_pt' THEN m.value ELSE 0 END) physreadsdir_pt, SUM(CASE WHEN a.internal_metric_name = 'physwritesdir_ps' THEN m.value ELSE 0 END) physwritesdir_ps, SUM(CASE WHEN a.internal_metric_name = 'physwritesdir_pt' THEN m.value ELSE 0 END) physwritesdir_pt, SUM(CASE WHEN a.internal_metric_name = 'physreadslob_ps' THEN m.value ELSE 0 END) physreadslob_ps, SUM(CASE WHEN a.internal_metric_name = 'physreadslob_pt' THEN m.value ELSE 0 END) physreadslob_pt, SUM(CASE WHEN a.internal_metric_name = 'physwriteslob_ps' THEN m.value ELSE 0 END) physwriteslob_ps, SUM(CASE WHEN a.internal_metric_name = 'physwriteslob_pt' THEN m.value ELSE 0 END) physwriteslob_pt, SUM(CASE WHEN a.internal_metric_name = 'redosize_ps' THEN m.value ELSE 0 END) redosize_ps, SUM(CASE WHEN a.internal_metric_name = 'logons_ps' THEN m.value ELSE 0 END) logons_ps, SUM(CASE WHEN a.internal_metric_name = 'logons_pt' THEN m.value ELSE 0 END) logons_pt, SUM(CASE WHEN a.internal_metric_name = 'opncurs_ps' THEN m.value ELSE 0 END) opncurs_ps, SUM(CASE WHEN a.internal_metric_name = 'opncurs_pt' THEN m.value ELSE 0 END) opncurs_pt, SUM(CASE WHEN a.internal_metric_name = 'commits_ps' THEN m.value ELSE 0 END) commits_ps, SUM(CASE WHEN a.internal_metric_name = 'commits_pt' THEN m.value ELSE 0 END) commits_pt, SUM(CASE WHEN a.internal_metric_name = 'rollbacks_ps' THEN m.value ELSE 0 END) rollbacks_ps, SUM(CASE WHEN a.internal_metric_name = 'rollbacks_pt' THEN m.value ELSE 0 END) rollbacks_pt, SUM(CASE WHEN a.internal_metric_name = 'usercalls_ps' THEN m.value ELSE 0 END) usercalls_ps, SUM(CASE WHEN a.internal_metric_name = 'usercalls_pt' THEN m.value ELSE 0 END) usercalls_pt, SUM(CASE WHEN a.internal_metric_name = 'recurscalls_ps' THEN m.value ELSE 0 END) recurscalls_ps, SUM(CASE WHEN a.internal_metric_name = 'recurscalls_pt' THEN m.value ELSE 0 END) recurscalls_pt, SUM(CASE WHEN a.internal_metric_name = 'logreads_ps' THEN m.value ELSE 0 END) logreads_ps, SUM(CASE WHEN a.internal_metric_name = 'logreads_pt' THEN m.value ELSE 0 END) logreads_pt, SUM(CASE WHEN a.internal_metric_name = 'dbwrcheckpoints_ps' THEN m.value ELSE 0 END) dbwrcheckpoints_ps, SUM(CASE WHEN a.internal_metric_name = 'bgcheckpoints_ps' THEN m.value ELSE 0 END) bgcheckpoints_ps, SUM(CASE WHEN a.internal_metric_name = 'redowrites_ps' THEN m.value ELSE 0 END) redowrites_ps, SUM(CASE WHEN a.internal_metric_name = 'redowrites_pt' THEN m.value ELSE 0 END) redowrites_pt, SUM(CASE WHEN a.internal_metric_name = 'tabscanslong_ps' THEN m.value ELSE 0 END) tabscanslong_ps, SUM(CASE WHEN a.internal_metric_name = 'tabscanslong_pt' THEN m.value ELSE 0 END) tabscanslong_pt, SUM(CASE WHEN a.internal_metric_name = 'tabscanstotal_ps' THEN m.value ELSE 0 END) tabscanstotal_ps, SUM(CASE WHEN a.internal_metric_name = 'tabscanstotal_pt' THEN m.value ELSE 0 END) tabscanstotal_pt, SUM(CASE WHEN a.internal_metric_name = 'indxscansfull_pt' THEN m.value ELSE 0 END) indxscansfull_pt, SUM(CASE WHEN a.internal_metric_name = 'indxscansfull_ps' THEN m.value ELSE 0 END) indxscansfull_ps, SUM(CASE WHEN a.internal_metric_name = 'indxscanstotal_ps' THEN m.value ELSE 0 END) indxscanstotal_ps, SUM(CASE WHEN a.internal_metric_name = ' indxscanstotal_pt' THEN m.value ELSE 0 END) indxscanstotal_pt, SUM(CASE WHEN a.internal_metric_name = 'parses_ps' THEN m.value ELSE 0 END) parses_ps, SUM(CASE WHEN a.internal_metric_name = 'parses_pt' THEN m.value ELSE 0 END) parses_pt, SUM(CASE WHEN a.internal_metric_name = 'hardparses_ps' THEN m.value ELSE 0 END) hardparses_ps, SUM(CASE WHEN a.internal_metric_name = 'hardparses_pt' THEN m.value ELSE 0 END) hardparses_pt, SUM(CASE WHEN a.internal_metric_name = 'failedparses_ps' THEN m.value ELSE 0 END) failedparses_ps, SUM(CASE WHEN a.internal_metric_name = 'failedparses_pt' THEN m.value ELSE 0 END) failedparses_pt, SUM(CASE WHEN a.internal_metric_name = 'executions_ps' THEN m.value ELSE 0 END) executions_ps, SUM(CASE WHEN a.internal_metric_name = 'sortsdisk_ps' THEN m.value ELSE 0 END) sortsdisk_ps, SUM(CASE WHEN a.internal_metric_name = 'sortsdisk_pt' THEN m.value ELSE 0 END) sortsdisk_pt, SUM(CASE WHEN a.internal_metric_name = 'rows_psort' THEN m.value ELSE 0 END) rows_psort, SUM(CASE WHEN a.internal_metric_name = 'executeswoparse_pct' THEN m.value ELSE 0 END) executeswoparse_pct, SUM(CASE WHEN a.internal_metric_name = 'softparse_pct' THEN m.value ELSE 0 END) softparse_pct, SUM(CASE WHEN a.internal_metric_name = 'usercall_pct' THEN m.value ELSE 0 END) usercall_pct, SUM(CASE WHEN a.internal_metric_name = 'networkbytes_ps' THEN m.value ELSE 0 END) networkbytes_ps, SUM(CASE WHEN a.internal_metric_name = 'enqtimeouts_ps' THEN m.value ELSE 0 END) enqtimeouts_ps, SUM(CASE WHEN a.internal_metric_name = 'enqtimeouts_pt' THEN m.value ELSE 0 END) enqtimeouts_pt, SUM(CASE WHEN a.internal_metric_name = 'enqwaits_ps' THEN m.value ELSE 0 END) enqwaits_ps, SUM(CASE WHEN a.internal_metric_name = 'enqwaits_pt' THEN m.value ELSE 0 END) enqwaits_pt, SUM(CASE WHEN a.internal_metric_name = 'enqdeadlocks_ps' THEN m.value ELSE 0 END) enqdeadlocks_ps, SUM(CASE WHEN a.internal_metric_name = 'enqdeadlocks_pt' THEN m.value ELSE 0 END) enqdeadlocks_pt, SUM(CASE WHEN a.internal_metric_name = 'enqreqs_ps' THEN m.value ELSE 0 END) enqreqs_ps, SUM(CASE WHEN a.internal_metric_name = 'enqreqs_pt' THEN m.value ELSE 0 END) enqreqs_pt, SUM(CASE WHEN a.internal_metric_name = 'dbblkgets_ps' THEN m.value ELSE 0 END) dbblkgets_ps, SUM(CASE WHEN a.internal_metric_name = 'dbblkgets_pt' THEN m.value ELSE 0 END) dbblkgets_pt, SUM(CASE WHEN a.internal_metric_name = 'consistentreadgets_ps' THEN m.value ELSE 0 END) consistentreadgets_ps, SUM(CASE WHEN a.internal_metric_name = 'consistentreadgets_pt' THEN m.value ELSE 0 END) consistentreadgets_pt, SUM(CASE WHEN a.internal_metric_name = 'dbblkchanges_ps' THEN m.value ELSE 0 END) dbblkchanges_ps, SUM(CASE WHEN a.internal_metric_name = 'dbblkchanges_pt' THEN m.value ELSE 0 END) dbblkchanges_pt, SUM(CASE WHEN a.internal_metric_name = 'consistentreadchanges_ps' THEN m.value ELSE 0 END) consistentreadchanges_ps, SUM(CASE WHEN a.internal_metric_name = 'consistentreadchanges_pt' THEN m.value ELSE 0 END) consistentreadchanges_pt, SUM(CASE WHEN a.internal_metric_name = 'crblks_ps' THEN m.value ELSE 0 END) crblks_ps, SUM(CASE WHEN a.internal_metric_name = 'crblks_pt' THEN m.value ELSE 0 END) crblks_pt, SUM(CASE WHEN a.internal_metric_name = 'crundorecs_pt' THEN m.value ELSE 0 END) crundorecs_pt, SUM(CASE WHEN a.internal_metric_name = 'userrollbackundorec_ps' THEN m.value ELSE 0 END) userrollbackundorec_ps, SUM(CASE WHEN a.internal_metric_name = 'userrollbackundorec_pt' THEN m.value ELSE 0 END) userrollbackundorec_pt, SUM(CASE WHEN a.internal_metric_name = 'leafnodesplits_ps' THEN m.value ELSE 0 END) leafnodesplits_ps, SUM(CASE WHEN a.internal_metric_name = 'leafnodesplits_pt' THEN m.value ELSE 0 END) leafnodesplits_pt, SUM(CASE WHEN a.internal_metric_name = 'branchnodesplits_ps' THEN m.value ELSE 0 END) branchnodesplits_ps, SUM(CASE WHEN a.internal_metric_name = 'branchnodesplits_pt' THEN m.value ELSE 0 END) branchnodesplits_pt, SUM(CASE WHEN a.internal_metric_name = 'redosize_pt' THEN m.valu e ELSE 0 END) redosize_pt, SUM(CASE WHEN a.internal_metric_name = 'crundorecs_ps' THEN m.value ELSE 0 END) crundorecs_ps, SUM(CASE WHEN a.internal_metric_name = 'dbtime_ps' THEN m.value ELSE 0 END) dbtime_ps, SUM(CASE WHEN a.internal_metric_name = 'avg_active_sessions' THEN m.value ELSE 0 END) avg_active_sessions, SUM(CASE WHEN a.internal_metric_name = 'avg_sync_singleblk_read_latency' THEN m.value ELSE 0 END) avg_block_read_latency, SUM(CASE WHEN a.internal_metric_name = 'iombs_ps' THEN m.value ELSE 0 END) iombs_ps, SUM(CASE WHEN a.internal_metric_name = 'iorequests_ps' THEN m.value ELSE 0 END) iorequests_ps FROM v$alert_types a, v$threshold_types t, v$sysmetric m WHERE a.internal_metric_category = 'instance_throughput' AND a.reason_id = t.alert_reason_id AND t.metrics_id = m.metric_id AND m.group_id = 2 AND :1 != 'BASIC' AND m.end_time <= SYSDATE GROUP BY m.end_time ORDER BY m.end_time ASC
317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (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, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
350myuyx0t1d6insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
35hatv0pj8hw7select decode(u.type#, 2, u.ext_username, u.name), o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where o.type# = 12 and bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
36ya4s1zjwx1hSELECT COUNT(*) FROM STATS$USER_LOG WHERE USERNAME = USER
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3w4qs0tbpmxr6select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
3zzjfr9zwjc6sselect object_type from all_objects where object_name ='CUSTOMER'and OBJECT_TYPE ='SYNONYM'
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
45ur4ja6vzbx2declare sql_stmt varchar2(300) :='create table dba_free_space_dfspace as SELECT a.file_id, SUM(bytes) as bytes FROM dba_free_space a GROUP BY a.file_id'; table_or_view_does_not_exist exception; PRAGMA EXCEPTION_INIT(table_or_view_does_not_exist, -942); begin execute immediate 'drop table dba_free_space_dfspace'; execute immediate sql_stmt; exception when table_or_view_does_not_exist then execute immediate sql_stmt; end;
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5536pyqxt9dd1SELECT customer.oid FROM customer, customer_alias ca WHERE (( ( UPPER(concat(customer.display_name, (concat(' - ', customer.location)))) LIKE '%%')) OR ( ( UPPER(concat(ca.name, (concat(' - ', ca.location)))) LIKE '%%')) ) AND customer.oid=ca.customer_oid(+) AND customer.status != 'Forecast' AND (customer.oid IN (SELECT customer_oid FROM org_cust_mapping WHERE org_oid IN (SELECT oid FROM org CONNECT BY parent_org_oid=PRIOR oid START WITH oid IN (505, 526, 8362)))) AND customer.obsolete_flag=0 ORDER BY UPPER(customer.display_name), UPPER(customer.location)
5fkzpyqyptax3 DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SELECT parameter_value, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; OPEN data_cursor FOR WITH recInfo AS ( SELECT /*+ NO_MERGE */ finding_id, count(r.rec_id) recCount, r.type FROM DBA_ADVISOR_RECOMMENDATIONS r WHERE task_id=latest_task_id GROUP BY r.finding_id, r.type ), f_curr AS ( SELECT /*+ NO_MERGE */ DISTINCT finding_name FROM DBA_ADVISOR_FINDINGS WHERE task_id=latest_task_id ), tasks AS ( SELECT /*+ NO_MERGE */ t.task_id, i.local_task_id, t.end_time, t.begin_time FROM DBA_ADDM_TASKS t, DBA_ADDM_INSTANCES i WHERE t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=SYS_CONTEXT('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ), f_all AS ( SELECT /*+ NO_MERGE */ COUNT(fa.task_id) finding_count, fa.finding_name FROM tasks, DBA_ADVISOR_FINDINGS fa WHERE fa.task_id=tasks.task_id AND fa.type<>'INFORMATION' AND fa.type<>'WARNING' AND fa.parent=0 GROUP BY fa.finding_name ), history AS ( SELECT /*+ NO_MERGE */ finding_name, finding_count FROM f_all JOIN f_curr USING (finding_name) ) SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, null, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_CHAR(TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') start_time, TO_CHAR(TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM DBA_ADDM_FINDINGS f, recInfo, history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f.parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :1 := data_cursor; END;
5hk2758bxufj0SELECT column_name, nullable, data_type, char_length, data_precision, data_scale FROM user_tab_columns WHERE table_name=:1 ORDER BY column_id
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5rygsj4dbw6jtinsert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
61a161nm1ttjjselect /*+ INDEX(TAB AQ$_AQ_EVENT_TABLE_I) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.user_data from "SYS"."AQ_EVENT_TABLE" tab where q_name = :1 and (state = :2 ) order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked
654w48vhhm355select t.column_name "Name", decode(t.nullable, 'Y', null, 'NOT NULL') "Null", UPPER(t.data_type)|| case when ( t.data_type='VARCHAR' OR t.data_type = 'VARCHAR2' OR t.data_type ='RAW' OR t.data_type='CHAR') AND ( t.data_length <> 0 AND nvl(t.data_length, -1) <> -1) then case when(t.char_used ='C' and 'BYTE' =(select value from nls_session_parameters where PARAMETER='NLS_LENGTH_SEMANTICS')) then '(' || t.char_length || ' CHAR)' when(t.char_used ='B' and 'CHAR' =(select value from nls_session_parameters where PARAMETER='NLS_LENGTH_SEMANTICS')) then '(' || t.data_length || ' BYTE)' when(t.char_used ='C' and 'CHAR' =(select value from nls_session_parameters where PARAMETER='NLS_LENGTH_SEMANTICS')) then '(' || t.char_length || ')' when(t.char_used ='B' and 'BYTE' =(select value from nls_session_parameters where PARAMETER='NLS_LENGTH_SEMANTICS')) then '(' || t.data_length || ')' else '(' || t.data_length || ' BYTE)' end when (t.data_type='NVARCHAR2' OR t.data_type='NCHAR') then '(' || t.data_length/2 || ')' when (t.data_type like 'TIMESTAMP%' OR t.data_type like 'INTERVAL DAY%' OR t.data_type like 'INTERVAL YEAR%' OR t.data_type = 'DATE' OR(t.data_type = 'NUMBER' AND (t.data_precision = 0 OR nvl(t.data_precision, -1) = -1))) then '' when (t.data_scale = 0 OR nvl(t.data_scale, -1) = -1) then '('|| t.data_precision ||')' else '('|| t.data_precision ||', ' ||t.data_scale ||')' end "Type" from sys.all_tab_columns t, sys.all_col_comments c where t.column_name = c.column_name and c.owner = t.owner and c.table_name = t.table_name and UPPER(t.owner) = UPPER(:1) and t.table_name = :2 order by t.column_id
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7b8wsmb9nfrwwcreate table dba_free_space_dfspace as SELECT a.file_id, SUM(bytes) as bytes FROM dba_free_space a GROUP BY a.file_id
7k6zct1sya530insert into WRH$_STREAMS_APPLY_SUM (snap_id, dbid, instance_number, apply_name, startup_time, reader_total_messages_dequeued, reader_lag, coord_total_received, coord_total_applied, coord_total_rollbacks, coord_total_wait_deps, coord_total_wait_cmts, coord_lwm_lag, server_total_messages_applied, server_elapsed_dequeue_time, server_elapsed_apply_time) select * from (select :snap_id, :dbid, :instance_number, ac.apply_name, ac.startup_time, ar.total_messages_dequeued, ar.dequeue_time - ar.dequeued_message_create_time, ac.total_received, ac.total_applied, ac.total_rollbacks, ac.total_wait_deps, ac.total_wait_commits, ac.lwm_time - ac.lwm_message_create_time, al.total_messages_applied, al.elapsed_dequeue_time, al.elapsed_apply_time from v$streams_apply_coordinator ac, v$streams_apply_reader ar, (select apply_name, sum(total_messages_applied) total_messages_applied, sum(elapsed_dequeue_time) elapsed_dequeue_time, sum(elapsed_apply_time) elapsed_apply_time from v$streams_apply_server group by apply_name) al where al.apply_name=ac.apply_name and ar.apply_name=ac.apply_name order by ac.total_applied desc) where rownum <= 25
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#
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
7z7x3166pt4kmSELECT 'SCHEMA' type, username owner, username object_name, null column_name, null column_id, null data_type FROM all_users WHERE rownum <=50 and username like :1 union all SELECT 'ARGUMENT' type, null owner, a.owner||'.'||a.package_name||'.'||a.object_name||'.'||a.overload object_name, a.argument_name||' '||a.data_type column_name, a.position column_id, null data_type FROM all_arguments a, all_objects o WHERE a.object_id=o.object_id and rownum <=50 and argument_name is not null and o.object_name = :2 union all SELECT object_type type, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') and object_name like :3
81uvdbt46vt5pDECLARE /* Yannick */ i NUMBER; sql_stmt VARCHAR2(200); max_id number; BEGIN SELECT MAX(id) INTO max_id FROM yjaquier.test1; i:=1; DBMS_RANDOM.SEED(SYSDATE); FOR i IN 1..max_id LOOP sql_stmt:='SELECT /* Yannick */ descr FROM yjaquier.test1 WHERE id=' || ROUND(DBMS_RANDOM.VALUE(1, max_id)); EXECUTE IMMEDIATE sql_stmt; END LOOP; 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#
8gt45jpvt1ywhINSERT INTO mn_hist_task (ver_start_date, ver_end_date, task_end_date, session_id, query_time, query_count, date_created, member_id_updated, task_id, bytes_returned, name, components, task_start_date, thread_type, jvm_time, id, class, member_name, server_time, action, pobjs, node_name, ver_state, resource_key, ver_num, component_time, mgr_id, realm_num, date_updated, pobjs_time, member_id_created) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 )
8jk9z1dwpkpb3SELECT mn_member.ver_num, mn_member.mgr_id, mn_member.member_id FROM mn_member WHERE (NOT (mn_member.realm_number IN (0, 1)))
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9k0mhy6948xdhSELECT 'FUNCTION' type, owner, object_name||'.'||procedure_name object_name, null column_name, null column_id, null data_type FROM all_procedures WHERE rownum <=50 and object_type = 'PACKAGE' and procedure_name is not null and owner in('SYS', :1) and object_name = :2 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :3 and table_name = :4 union all SELECT object_type type, owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE object_type ='TABLE' and object_name not like 'BIN$%' and rownum <=50 and owner = :5 union all SELECT object_type type, owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE object_type ='VIEW' and object_name not like 'BIN$%' and rownum <=50 and owner = :6 union all SELECT object_type type, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') and owner = :7
9nh7uqswpdc6hselect OID, Customer_Oid, Customer_Name, Customer_Location, ACCOUNT_NUM, Interface_Name, MN_Created_DEC, DEC_Code, STATUS , customer_alias_oid from dataload.ST_ACC_ALIAS_DATA where STATUS = :1 order by interface_id
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9zzuyxx4pjhsxselect p_obj#, flags, code, audit$ from edition$ where obj#=:1
a32bhg8ny1y4uselect * from dba_tab_statistics where owner='YJAQUIER' and table_name='TEST1'
akfwbgvmmwhsmselect object_type from all_objects where object_name ='CUSTOMER' and owner= 'DATALOAD'
avv5dcc9zx2qbSELECT 'SCHEMA' type, username owner, username object_name, null column_name, null column_id, null data_type FROM all_users WHERE rownum <=50 and username like :1 union all SELECT object_type type, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') and object_name like :2
b3zgx1xckrwxuselect host, userid, password, flag, authusr, authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
b4mrsfc9tthamWITH snaps as (SELECT :1 dbid, MIN(snap_id) as bid, MAX(snap_id) as eid FROM DBA_HIST_SNAPSHOT WHERE dbid = :2 AND end_interval_time >= :3 AND end_interval_time <= :4 ) SELECT t.task_id, t.end_time as end_time FROM DBA_ADDM_TASKS t, snaps s, DBA_ADDM_INSTANCES i WHERE t.dbid = :5 AND t.dbid = s.dbid AND t.begin_snap_id >= s.bid - 1 AND t.begin_snap_id < s.eid AND t.how_created = 'AUTO' AND t.requested_analysis = 'INSTANCE' AND t.task_id = i.task_id AND i.instance_number = :6
bd13sdj0ty0q4SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
bgba4tpdcpgundeclare t_user_count NUMBER; l_program v$session.program%TYPE; l_osuser v$session.program%TYPE; begin select count(*) into t_user_count from stats$user_log where username = USER; IF t_user_count = 0 THEN insert into stats$user_log ( username, LAST_LOGON_DAY ) values( USER, sysdate ); ELSE UPDATE stats$user_log SET LAST_LOGON_DAY = SYSDATE WHERE username = USER; END IF; exception when others then raise_application_error(-20008, 'Problem in connection due to Logon_Trig. Contact DB-SL Team.'); end;
bqfx5q2jas08uSELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1
bzgpy0vxtvf63SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, sql_child_number, plsql_object_id, plsql_subprogram_id, qc_session_serial# FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cyg8zddx2x8h6select FUNCTION_NAME, SMALL_READ_MBPS, SMALL_WRITE_MBPS, LARGE_READ_MBPS, LARGE_WRITE_MBPS, SMALL_READ_IOPS, SMALL_WRITE_IOPS, LARGE_READ_IOPS, LARGE_WRITE_IOPS, AVG_WAIT_TIME from V$IOFUNCMETRIC where intsize_csec > 5900 order by function_name
d2687zmqyq4avselect metric_id, value from v$sysmetric where intsize_csec > 5900 and group_id = 2 and metric_id in (2148, 2149, 2137, 2138, 2141, 2140, 2139, 2091, 2090, 2089, 2088, 2087, 2142, 2144)
d6yky1ddz2m2qUPDATE STATS$USER_LOG SET LAST_LOGON_DAY = SYSDATE WHERE USERNAME = USER
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dc1876qva6b70select qi.oid from dataload.quote q, dataload.quote_item qi, dataload.quote_contract_mapping qcm, dataload.mn_ht_contract mhc, dataload.part p, dataload.mn_ht_contract_li mhcl, dataload.quote_contract_item_mapping qcim, dataload.exporter_info ei where q.oid = qi.quote_oid and qcm.contract_oid = mhc.contract_id and p.oid = qi.part_oid and qcm.quote_oid = q.oid and mhc.contract_id = mhcl.contract_id and qi.custom_field1 in ('On Hold', 'Deleted', 'Rejected') and mhcl.line_status = 30 and q.quote_type_oid = 4 and qcim.contract_item_oid = mhcl.contract_line_item_id and qcim.quote_item_oid = qi.oid and mhc.contract_status not in ('TERM') and ei.TYPE ='CANCEL_CONTRACT_ITEM' and qi.MODIFIED_DATE >= ei.LAST_EXPORT
djunbuupchm4sLOCK TABLE event_info IN EXCLUSIVE MODE
dqk6gb5778xxaselect object_type from all_objects where object_name ='CUSTOMER' and UPPER(owner)= UPPER(sys_context('USERENV', 'CURRENT_SCHEMA'))
f1yky4nd9n9s6select end_time, wait_class#, (time_waited_fg)/(intsize_csec/100), (time_waited)/(intsize_csec/100), 0 from v$waitclassmetric union all select end_time, -1, sum(case when metric_name = 'CPU Usage Per Sec' then value else 0 end) fg, sum(case when metric_name = 'Background CPU Usage Per Sec' then value else 0 end) bg, sum(case when metric_name = 'Average Active Sessions' then value else 0 end) dbt from v$sysmetric where group_id = 2 and metric_name in ('Background CPU Usage Per Sec', 'CPU Usage Per Sec', 'Average Active Sessions') group by end_time order by end_time, wait_class#
fg6g5akd8jmyxSELECT /* Yannick */ descr FROM yjaquier.test1 WHERE id=:id


Back to Top