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)
1st1326407-May-13 10:10:37 (Tue)1326507-May-13 10:20:38 (Tue) 0.2 10.0 2.2
2nd1326807-May-13 10:50:41 (Tue)1326907-May-13 11:00:41 (Tue) 0.3 10.0 2.9
%Diff     31.8 0.0 34.8

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.481.58-.9-36.3
Load at End Snapshot:2.273.461.1952.4
%User Time:1.6.64-.96-60.0
%System Time:.79.59-.2-25.3
%Idle Time:97.4398.751.321.4
%IO Wait Time:1.031.15.1111.7

Cache Sizes

1st (M)2nd (M)Diff (M)%Diff
Memory Target    
SGA Target
2,048.02,048.00.00.0
Buffer Cache
720.0688.0-32.0-4.4
Shared Pool
912.0944.032.03.5
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: 0.2 0.3 31.8 0.2 0.2 -5.6
CPU time: 0.0 0.1 133.3 0.0 0.0 33.3
Redo size: 3,060.5 2,356.8 -23.0 2,518.0 1,359.9 -46.0
Logical reads: 1,089.3 1,211.8 11.2 896.2 699.3 -22.0
Block changes: 11.8 7.0 -40.3 9.7 4.1 -58.1
Physical reads: 657.5 809.1 23.1 540.9 466.8 -13.7
Physical writes: 1.1 1.1 -1.8 0.9 0.6 -30.8
User calls: 19.0 31.5 65.8 15.6 18.2 16.3
Parses: 19.8 3.1 -84.4 16.3 1.8 -89.1
Hard parses: 11.0 0.7 -93.7 9.1 0.4 -95.6
W/A MB processed: 151,872.6 179,648.9 18.3 124,951.9 103,661.1 18.3
Logons: 0.1 0.1 37.5 0.1 0.1 -14.3
Executes: 119.9 1,692.4 1,311.7 98.6 976.5 890.1
Transactions: 1.2 1.7 41.8   
1st2ndDiff
% Blocks changed per Read: 1.1 0.6 -0.5
Recursive Call %: 91.5 98.2 6.7
Rollback per transaction %: 81.1 85.0 3.9
Rows per Sort: 35.4 38.4 2.9
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
db file sequential readUser I/O8,20374.449.0757.20db file sequential readUser I/O7,44581.0810.8946.22
direct path readUser I/O6,24639.826.3730.59direct path readUser I/O7,74055.187.1331.45
CPU time  20.03 15.39CPU time  42.86 24.43
control file sequential readSystem I/O1,6241.440.891.10control file sequential readSystem I/O1,4410.830.580.47
control file parallel writeSystem I/O2160.642.960.49db file parallel writeSystem I/O4550.721.580.41
-db file parallel writeSystem I/O4510.521.160.40-control file parallel writeSystem I/O2120.602.810.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.00130.15175.4434.800.180.17-5.56
DB CPU15.3924.439.0420.0342.86113.980.030.0433.33
PL/SQL execution elapsed time0.265.174.910.349.072,567.650.000.01100.00
parse time elapsed4.112.00-2.115.353.52-34.210.010.00-100.00
hard parse elapsed time3.441.91-1.534.483.35-25.220.010.00-100.00
sql execute elapsed time97.5798.180.61126.98172.2535.650.170.170.00
PL/SQL compilation elapsed time0.110.06-0.060.150.10-33.330.000.000.00
hard parse (bind mismatch) elapsed time0.000.040.040.000.08100.000.000.000.00
repeated bind elapsed time0.050.01-0.040.070.02-71.430.000.000.00
hard parse (sharing criteria) elapsed time0.020.050.030.020.08300.000.000.000.00
Java execution elapsed time0.060.080.030.070.15114.290.000.000.00
connection management call elapsed time0.210.19-0.030.280.3317.860.000.000.00
failed parse elapsed time0.000.000.000.000.000.000.000.000.00
sequence load elapsed time0.000.000.000.000.000.000.000.000.00
RMAN cpu time (backup/restore)0.000.000.000.000.000.000.000.000.00
failed parse (out of shared memory) elapsed time0.000.000.000.000.000.000.000.000.00
inbound PL/SQL rpc elapsed time0.000.000.000.000.000.000.000.000.00
background elapsed time10.618.55-2.0613.8014.998.620.020.01-50.00
background cpu time3.713.38-0.334.835.9322.770.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_TIME49,21124,046378.12137.06-63.7581.9440.03-51.1567.4123.10-65.73
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,869,2931,900,65614,363.0510,833.69-24.573,112.373,164.181.662,560.681,825.80-28.70
IOWAIT_TIME19,83322,055152.39125.71-17.5133.0236.7211.2127.1721.19-22.01
NICE_TIME46703.590.00-100.000.780.00-100.000.640.00-100.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME15,16811,365116.5564.78-44.4225.2518.92-25.0720.7810.92-47.45
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_TIME30,66312,254235.6069.85-70.3551.0520.40-60.0442.0011.77-71.98
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/O87.8177.76-10.0424.3025.555.14114.28136.4319.387.838.8913.54
System I/O2.411.56-0.854.633.89-15.983.132.74-12.461.131.173.54
Other0.020.050.040.090.06-33.330.020.09350.000.412.68553.66
Concurrency0.090.130.030.010.02100.000.120.2283.3315.3816.919.95
Commit0.120.130.010.210.2519.050.160.2343.751.221.5224.59
Network0.020.020.0016.3827.8870.210.020.0350.000.000.000.00
Application0.000.000.000.000.000.000.000.000.000.031.193,866.67


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/O57.2046.22-10.9813.6612.39-9.3074.4481.088.929.0710.8920.07
direct path readUser I/O30.5931.450.8610.4012.8923.9439.8255.1838.576.377.1311.93
control file sequential readSystem I/O1.100.47-0.632.702.40-11.111.440.83-42.360.890.58-34.83
control file parallel writeSystem I/O0.490.34-0.150.360.35-2.780.640.60-6.252.962.81-5.07
db file scattered readUser I/O0.010.090.080.000.02100.000.010.161,500.0011.2010.87-2.95
log file parallel writeSystem I/O0.410.34-0.070.810.38-53.090.540.6011.111.092.60138.53
os thread startupConcurrency0.090.120.030.010.010.000.120.2283.3324.4224.37-0.20
ADR block file readOther0.010.040.030.010.03200.000.020.08300.004.754.07-14.32
log file syncCommit0.120.130.010.210.2519.050.160.2343.751.221.5224.59
db file parallel writeSystem I/O0.400.410.010.750.761.330.520.7238.461.161.5836.21
ADR block file writeOther0.000.010.010.000.01100.000.000.01100.000.002.66100.00
direct path writeUser I/O0.010.00-0.010.010.00-100.000.010.00-100.000.960.00-100.00
LGWR wait for redo copyOther0.000.00-0.000.080.00-100.000.000.000.000.060.0833.33
enq: RO - fast object reuseApplication0.000.000.000.000.000.000.000.000.000.001.19100.00
Disk file operations I/OUser I/O0.000.00-0.000.230.244.350.010.010.000.040.040.00
local write waitUser I/O0.000.000.000.000.000.000.000.000.000.001.64100.00
SQL*Net message to clientNetwork0.010.010.0015.8727.2271.520.010.010.000.000.000.00
SQL*Net more data from clientNetwork0.000.000.000.000.01100.000.000.000.000.020.21950.00
buffer busy waitsConcurrency0.000.00-0.000.000.01100.000.000.000.000.320.14-56.25
reliable messageOther0.000.000.000.000.000.000.000.000.000.000.14100.00
ADR file lockOther0.000.000.000.000.01100.000.000.000.000.000.02100.00
SQL*Net more data to clientNetwork0.010.01-0.000.510.6527.450.010.010.000.040.040.00
SQL*Net break/reset to clientApplication0.000.00-0.000.000.000.000.000.000.000.030.00-100.00
SQL*Net message from clientIdle39,259.3312,341.22-26,918.1115.9527.3171.2251,094.4521,651.38-57.625,334.561,319.88-75.26
Streams AQ: waiting for time management or cleanup tasksIdle8,797.050.00-8,797.050.010.00-100.0011,449.010.00-100.002,289,801.590.00-100.00
Space Manager: slave idle waitIdle2,227.891,630.56-597.331.001.033.002,899.512,860.64-1.344,808.474,621.39-3.89
EMON slave idle waitIdle2,305.621,710.38-595.251.001.000.003,000.683,000.680.005,001.135,001.130.00
DIAG idle waitIdle921.53684.13-237.401.992.000.501,199.341,200.240.081,001.121,001.04-0.01
Streams AQ: emn coordinator idle waitIdle461.17342.11-119.060.100.100.00600.20600.200.0010,003.2910,003.28-0.00
Streams AQ: qmn coordinator idle waitIdle451.96351.24-100.720.070.070.00588.20616.214.7614,004.8114,004.850.00
Streams AQ: qmn slave idle waitIdle451.95351.24-100.720.030.0433.33588.20616.214.7628,009.4628,009.510.00
JOX Jit Process SleepIdle110.6885.53-25.150.030.0433.33144.04150.054.178,473.106,523.82-23.01
class slave waitIdle0.000.000.000.010.010.000.000.000.000.090.08-11.11


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$USERS98.5998.850.2699.1399.960.8399.0499.940.9191.3494.763.42
SYS$BACKGROUND0.000.000.000.000.000.000.060.04-0.028.915.19-3.71
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
a3kxyqjurdtp857.3657.36  -57.3674,646 0.01 4,082 70,986 7,853.00 13.00 1 1// 1 insert into mgmt_db_size_gtt S...
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...
28ja91pnth38j  13.96104.3713.96 24,492 0.01 24,487 0 0.00 1.00 1  DECLARE /* Yannick */ i NUMBER...
5536pyqxt9dd1  4.46108.834.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.83112.663.83 0 5,699.97 0 0 0.00 0.00 1,000,000/ 1/ 1 SELECT /* Yannick */ descr FRO...
dc1876qva6b7029.0386.3925.27137.93-3.7637,78444,3410.010.013,7483,73334,76441,222333,493.00333,493.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
81uvdbt46vt5p2.7289.11  -2.723,543 0.01 3,542 0 0.00 1.00 1   DECLARE /* Yannick */ i NUMBER...
9k0mhy6948xdh  2.63140.572.63 4,619 0.01 1,524 3,103 253.00 50.00 1/ 1/ 1 SELECT 'FUNCTION' type, owner,...
8jk9z1dwpkpb35.6994.803.91144.48-1.783,7053,4300.020.013843503,4113,13937,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
9tgj4g8y4rwy80.9095.710.19144.66-0.7200390.4741.5800000.000.000.161.0050,8187,2941/ 1/ 1 select type#, blocks, extents,...
6ajkhukk78nsr0.4596.160.81145.470.365851,4150.010.0145185913656213.0068.001.001.0011  begin prvt_hdm.auto_execute( :...
bzgpy0vxtvf630.7896.930.60146.07-0.1825260.310.232526000.000.003.754.9840411/ 1/ 1 SELECT event#, sql_id, sql_pla...
f1yky4nd9n9s60.4797.410.33146.40-0.1415140.320.231514000.000.0014.0014.0042411/ 1/ 1 select end_time, wait_class#, ...
87vs8t2c6ra1c0.4097.810.28146.68-0.1212120.320.231212000.000.004.004.0042411/ 1/ 1 select metric_id, value from v...
29npwaz6dqsva0.4398.240.37147.05-0.0535410.120.096529369.759.75887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...


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
28ja91pnth38j  57.1357.1357.13 24,487 0 0.01 24,492 0.00 1.00  DECLARE /* Yannick */ i NUMBER...
a3kxyqjurdtp820.3820.38  -20.384,082 70,986 0.01 74,646 7,853.00 13.00 1// 1 insert into mgmt_db_size_gtt S...
81uvdbt46vt5p17.6938.07  -17.693,542 0 0.01 3,543 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...
dc1876qva6b7018.7256.798.7182.07-10.013,7483,73334,76441,2220.010.0137,78444,341333,493.00333,493.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
9tgj4g8y4rwy85.9662.750.7482.80-5.220000390.4741.58000.000.000.161.001/ 1/ 1 select type#, blocks, extents,...
45ur4ja6vzbx2  4.3087.104.30 1,844 78,005 0.01 79,409 6,928.00 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  4.0191.114.01 1,719 77,923 0.01 79,201 6,919.00 0.00/ 1/ 1 create table dba_free_space_df...
9k0mhy6948xdh  3.5694.673.56 1,524 3,103 0.01 4,619 253.00 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
5536pyqxt9dd1  2.7097.372.70 1,158 6,795 0.01 7,823 69,213.00 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
bzgpy0vxtvf635.0567.802.4499.82-2.602526000.310.2325260.000.003.754.981/ 1/ 1 SELECT event#, sql_id, sql_pla...
8jk9z1dwpkpb33.8371.631.64101.45-2.203843503,4113,1390.020.013,7053,43037,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
f1yky4nd9n9s63.0974.711.35102.80-1.741514000.320.2315140.000.0014.0014.001/ 1/ 1 select end_time, wait_class#, ...
87vs8t2c6ra1c2.6077.311.15103.94-1.451212000.320.2312120.000.004.004.001/ 1/ 1 select metric_id, value from v...
d2687zmqyq4av2.5879.891.20105.14-1.371313000.300.2313130.000.0014.0014.001/ 1/ 1 select metric_id, value from v...
6ajkhukk78nsr2.2582.142.00107.15-0.254518591365620.010.015851,41513.0068.001.001.00  begin prvt_hdm.auto_execute( :...


Back to SQL Statistics
Back to Top

Top SQL Comparison by I/O Time

 I/O Time % of DB time I/O Time (ms) per Exec Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
a3kxyqjurdtp854.5454.54  -54.5470,986 74,646 0.01 4,082 7,853.00 13.00 1 1// 1 insert into mgmt_db_size_gtt S...
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...
5536pyqxt9dd1  3.8792.753.87 6,795 7,823 0.01 1,158 69,213.00 39,675.00 1/ 1/ 1 SELECT customer.oid FROM custo...
dc1876qva6b7026.7181.2523.50116.25-3.2234,76441,22237,78444,3410.010.013,7483,733333,493.00333,493.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
9k0mhy6948xdh  1.77118.021.77 3,103 4,619 0.01 1,524 253.00 50.00 1/ 1/ 1 SELECT 'FUNCTION' type, owner,...
8jk9z1dwpkpb35.2486.503.58121.60-1.663,4113,1393,7053,4300.020.0138435037,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
6ajkhukk78nsr0.1086.600.32121.920.221365625851,4150.010.0145185913.0068.001.001.0011  begin prvt_hdm.auto_execute( :...
29npwaz6dqsva0.3586.950.33122.24-0.02293635410.120.09659.759.75887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
9tgj4g8y4rwy80.0086.950.00122.250.000000390.4741.58000.000.000.161.0050,8187,2941/ 1/ 1 select type#, blocks, extents,...
28ja91pnth38j  0.00122.250.00 0 24,492 0.01 24,487 0.00 1.00 1  DECLARE /* Yannick */ i NUMBER...
81uvdbt46vt5p0.0086.95  0.000 3,543 0.01 3,542 0.00 1.00 1   DECLARE /* Yannick */ i NUMBER...
87vs8t2c6ra1c0.0086.950.00122.250.000012120.320.2312120.000.004.004.0042411/ 1/ 1 select metric_id, value from v...
bzgpy0vxtvf630.0086.950.00122.250.000025260.310.2325260.000.003.754.9840411/ 1/ 1 SELECT event#, sql_id, sql_pla...
f1yky4nd9n9s60.0086.950.00122.250.000015140.320.2315140.000.0014.0014.0042411/ 1/ 1 select end_time, wait_class#, ...
fg6g5akd8jmyx  0.00122.250.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
a3kxyqjurdtp820.1520.15  -20.15131,862.00 1 74,646 4,082 70,986 7,853.00 13.00 1// 1 insert into mgmt_db_size_gtt S...
9tgj4g8y4rwy816.7536.913.013.01-13.752.163.0050,8187,2940000000.000.000.161.001/ 1/ 1 select type#, blocks, extents,...
5536pyqxt9dd1  9.6312.649.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.7619.406.76 49,191.00 1 79,409 1,844 78,005 6,928.00 0.00  declare sql_stmt varchar2(300)...
7b8wsmb9nfrww  6.5425.946.54 47,593.00 1 79,201 1,719 77,923 6,919.00 0.00/ 1/ 1 create table dba_free_space_df...
5hk2758bxufj07.9944.9014.3640.296.37111.66111.664689361111000.000.0023.5323.531/ 1/ 1 SELECT column_name, nullable, ...
dc1876qva6b7051.0995.9945.9286.21-5.17334,270.00334,270.001137,78444,3413,7483,73334,76441,222333,493.00333,493.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
9k0mhy6948xdh  2.4788.692.47 18,002.00 1 4,619 1,524 3,103 253.00 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
8jk9z1dwpkpb311.53107.5210.3799.05-1.1737,727.0037,727.00223,7053,4303843503,4113,13937,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
3c1kubcdjnppq0.42107.95  -0.423.39 819 0 0 0 0.00 0.99 1// 1 update sys.col_usage$ set equa...
7qjhf5dzmazsr3.01110.962.74101.79-0.2719,701.0019,926.0011304346304345000.000.008.006.001/ 1/ 1 SELECT snap_id , OBJ#, DATAOBJ...
1qntcw2s31n150.27111.23  -0.271,786.00 1 169 66 102 12.00 2.00 1// 1 select * from dba_hist_baselin...
6ajkhukk78nsr1.50112.731.30103.09-0.209,785.009,451.00115851,41545185913656213.0068.001.001.00  begin prvt_hdm.auto_execute( :...
29npwaz6dqsva0.56113.290.48103.57-0.08228.75218.75161635416529369.759.75887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...


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
dc1876qva6b7084.4584.4568.6268.62-15.83333,493.00333,493.001137,78444,3413,7483,73334,76441,2220.000.001/ 1/ 1 select qi.oid from dataload.qu...
5536pyqxt9dd1  14.2482.8614.24 69,213.00 1 7,823 1,158 6,795 39,675.00/ 1/ 1 SELECT customer.oid FROM custo...
8jk9z1dwpkpb319.07103.5215.5098.36-3.5737,654.0037,654.00223,7053,4303843503,4113,1391.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
a3kxyqjurdtp81.99105.51  -1.997,853.00 1 74,646 4,082 70,986 13.00 1// 1 insert into mgmt_db_size_gtt S...
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.00105.510.01101.270.010.050.0822279301000115.9216.851/ 1/ 1 select /*+ rule */ bucket, end...
6ajkhukk78nsr0.00105.520.01101.290.0113.0068.00115851,4154518591365621.001.00  begin prvt_hdm.auto_execute( :...
29npwaz6dqsva0.04105.560.03101.32-0.019.759.7516163541652936887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
5fkzpyqyptax3  0.01101.330.01 31.00 1 355 132 224 1.00  DECLARE instance_number NUMBE...
1qntcw2s31n150.00105.56  -0.0012.00 1 169 66 102 2.00 1// 1 select * from dba_hist_baselin...
9vqmgu6c7011u0.00105.56  -0.0012.00 1 402 263 140 0.00 1// 1 select a.capture_name capture...
83taa7kaw59c10.00105.560.00101.33-0.000.110.028014911001019.4516.211/ 1/ 1 select name, intcol#, segcol#,...
3ktacv9r56b510.00105.570.00101.33-0.000.090.20108351200123.531.631/ 1/ 1 select owner#, name, namespace...


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
a3kxyqjurdtp854.3354.33  -54.337,853.00 7,853 0.00 1 74,646 4,082 70,986 13.00 1// 1 insert into mgmt_db_size_gtt S...
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...
5536pyqxt9dd1  7.3198.327.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...
dc1876qva6b7036.2090.5334.39132.70-1.815,232.005,232.005,2325,2320.000.001137,78444,3413,7483,73334,76441,2220.000.001/ 1/ 1 select qi.oid from dataload.qu...
9k0mhy6948xdh  1.61134.311.61 245.00 245 0.00 1 4,619 1,524 3,103 50.00/ 1/ 1 SELECT 'FUNCTION' type, owner,...
8jk9z1dwpkpb38.1998.737.78142.10-0.41592.00592.001,1841,1840.000.00223,7053,4303843503,4113,1391.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
db78fxqxwxt7r0.0798.800.43142.520.360.050.0810650.000.0022279301000115.9216.851/ 1/ 1 select /*+ rule */ bucket, end...
6ajkhukk78nsr0.0998.890.44142.960.3513.0067.0013670.000.00115851,4154518591365621.001.00  begin prvt_hdm.auto_execute( :...
5fkzpyqyptax3  0.24143.200.24 36.00 36 0.00 1 355 132 224 1.00  DECLARE instance_number NUMBE...
1qntcw2s31n150.1299.01  -0.1218.00 18 0.00 1 169 66 102 2.00 1// 1 select * from dba_hist_baselin...
9vqmgu6c7011u0.0899.09  -0.0812.00 12 0.00 1 402 263 140 0.00 1// 1 select a.capture_name capture...
83taa7kaw59c10.0699.160.02143.22-0.040.110.02930.000.008014911001019.4516.211/ 1/ 1 select name, intcol#, segcol#,...
29npwaz6dqsva0.0099.160.00143.220.000.000.0000  16163541652936887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
3ktacv9r56b510.0099.160.00143.220.000.000.0000  108351200123.531.631/ 1/ 1 select owner#, name, namespace...


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...
9tgj4g8y4rwy8390.4741.58-348.8950,8187,2940000000.000.000.161.001/ 1/ 1 select type#, blocks, extents,...
3c1kubcdjnppq6.29 -6.29819 0 0 0 0.00 0.99 1// 1 update sys.col_usage$ set equa...
53saa2zkr6wc31.185.033.851548830000000.010.011.211.121/ 1/ 1 select intcol#, nvl(pos#, 0), ...
db78fxqxwxt7r1.714.522.812227930100010.050.0815.9216.851/ 1/ 1 select /*+ rule */ bucket, end...
96g93hntrzjtr2.774.812.043608430000000.010.010.630.981/ 1/ 1 select /*+ rule */ bucket_cnt,...
5hk2758bxufj03.605.341.744689361111000.000.0023.5323.531/ 1/ 1 SELECT column_name, nullable, ...
3nkd3g3ju5ph12.100.46-1.64273810000000.010.050.870.861/ 1/ 1 select obj#, type#, ctime, mti...
djunbuupchm4s 1.031.03 181 0 0 0 0.00 0.00  LOCK TABLE event_info IN EXCLU...
5n1fs4m2n2y0r0.561.520.96732670000000.000.001.581.671/ 1/ 1 select pos#, intcol#, col#, sp...
8swypbbr0m3720.83 -0.83108 0 0 0 0.04 3.02 1// 1 select order#, columns, types ...
grwydz59pu6mc1.100.39-0.71143690000000.000.031.001.001/ 1/ 1 select text from view$ where r...
3ktacv9r56b510.830.20-0.63108351200120.090.203.531.631/ 1/ 1 select owner#, name, namespace...
7ng34ruy5awxq0.310.730.42401281111110.030.061.832.091/ 1/ 1 select i.obj#, i.ts#, i.file#,...
83taa7kaw59c10.610.850.23801491100100.110.0219.4516.211/ 1/ 1 select name, intcol#, segcol#,...


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
djunbuupchm4s  9.769.769.76 181 181  LOCK TABLE event_info IN EXCLU...
0ws7ahf1d78qa0.390.393.0212.782.63465646561/ 1/ 1 select SYS_CONTEXT('USERENV', ...
36ya4s1zjwx1h0.390.773.0215.802.63465646561/ 1/ 1 SELECT COUNT(*) FROM STATS$USE...
459f3z9u4fb3u0.391.163.0218.822.63465646561/ 1/ 1 select value$ from props$ wher...
bgba4tpdcpgun0.391.543.0221.842.6346564656  declare t_user_count NUMBER; l...
d6yky1ddz2m2q0.391.933.0224.872.63465646561/ 1/ 1 UPDATE STATS$USER_LOG SET LAST...
0k8522rmdzg4k0.392.322.9727.832.58465546551/ 1/ 1 select privilege# from sysauth...
5ur69atw3vfhj0.392.702.9730.802.58465546551/ 1/ 1 select decode(failover_method,...
cm5vu20fhtnq10.393.092.9733.762.58465550611/ 1/ 1 select /*+ connect_by_filterin...
5hk2758bxufj00.053.140.6534.410.606124689361/ 1/ 1 SELECT column_name, nullable, ...
0v3dvmc22qnam0.313.45  -0.3137 8   insert into sys.col_usage$ (ob...
29npwaz6dqsva0.093.540.3234.740.2311616162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...


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,...
fuyrx4r46bgxw0.050.05  -0.05500,666 500,666 1  select capture_name streams_n...
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...
4x866jn4mj1uy0.030.08  -0.03291,804 291,804 1  SELECT PROPAGATION_NAME, MESS...
0ctk7jpux5chm  0.030.440.03 291,986 291,986 1 WITH RECINFO AS ( SELECT /*+ N...
7wt7phk4xns750.020.11  -0.02231,246 231,246 1  select a.capture_name streams_...
9vqmgu6c7011u0.020.13  -0.02214,764 214,764 1  select a.capture_name capture...
gdvfxf7k4scsn0.020.15  -0.02170,190 170,190 1  select r.apply_name apply_nam...
501kary3x38sj0.020.16  -0.02166,082 166,082 1  select r.apply_name apply_nam...
8gt45jpvt1ywh0.020.180.040.470.02180,427353,307180,427353,307912 INSERT INTO mn_hist_task (ver_...
bzgpy0vxtvf630.020.200.010.48-0.01164,750111,590164,750111,5904041 SELECT event#, sql_id, sql_pla...
29npwaz6dqsva0.030.230.030.510.00261,642288,138261,642288,1381616 SELECT CONFIG_VALUE_ID, CONFIG...
6wm3n4d7bnddg0.030.260.030.54-0.00287,722287,826287,722287,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
0ctk7jpux5chm 44 4 1 WITH RECINFO AS ( SELECT /*+ N...
0v3dvmc22qnam4 -44 8  insert into sys.col_usage$ (ob...
1gu8t96d0bdmu 44 4 47 select t.ts#, t.file#, t.block...
5rygsj4dbw6jt 44 4 1 insert into sys.mon_mods$ (obj...
9gkq7rruycsjp4 -44 1  select parttype, partcnt, part...
29npwaz6dqsva2022220221616 SELECT CONFIG_VALUE_ID, CONFIG...
8gt45jpvt1ywh56156912 INSERT INTO mn_hist_task (ver_...
0k8522rmdzg4k330334655 select privilege# from sysauth...
36ya4s1zjwx1h440444656 SELECT COUNT(*) FROM STATS$USE...
3ktacv9r56b514404410835 select owner#, name, namespace...
5ur69atw3vfhj440444655 select decode(failover_method,...
7ng34ruy5awxq5505540128 select i.obj#, i.ts#, i.file#,...
83taa7kaw59c15505580149 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...
0guz6b5fs6xya0.000.00  0.000.00 0.00 1   begin open :1 for select md.me...
0k8522rmdzg4k0.000.000.000.000.000.000.000.000.0046551/ 1/ 1 select privilege# from sysauth...
0m78skf1mudnb0.000.00  0.000.00 0.00 18 1// 1 select audit$, properties from...
0v3dvmc22qnam0.000.00  0.000.00 0.00 8   insert into sys.col_usage$ (ob...
0ws7ahf1d78qa0.000.000.000.000.000.000.000.000.0046561/ 1/ 1 select SYS_CONTEXT('USERENV', ...
0z1031991bd7w  0.000.000.00 0.00 0.00 1/ 1/ 1 insert into wrh$_sysmetric_sum...
1att0guk2skhm0.000.00  0.000.00 0.00 1 1// 1 select lobtsn, lobrdba, lobobj...
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...
1qntcw2s31n150.000.00  0.000.00 0.00 1 1// 1 select * from dba_hist_baselin...
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...
2xrc1gttayzmy0.000.00  0.000.00 0.00 1 1// 1 SELECT /*+ ORDERED USE_MERGE(...


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 changes7,0824,226-40.3354.4224.09-55.7311.797.04-40.299.704.06-58.14
execute count72,0001,016,5671,311.90553.225,794.40947.40119.881,692.371,311.7298.63976.53890.09
logons cumulative516527.450.390.37-5.130.080.1137.500.070.06-14.29
opened cursors cumulative70,8531,015,9241,333.85544.415,790.74963.67117.971,691.301,333.6797.06975.91905.47
parse count (total)11,9211,854-84.4591.6010.57-88.4619.853.09-84.4316.331.78-89.10
parse time elapsed561187-66.674.311.07-75.170.930.31-66.670.770.18-76.62
physical reads394,891485,98323.073,034.222,770.09-8.71657.49809.0623.05540.95466.84-13.70
physical writes666654-1.805.123.73-27.151.111.09-1.800.910.63-30.77
redo size1,838,1401,415,652-22.9814,123.688,069.18-42.873,060.502,356.76-22.992,518.001,359.90-45.99
session cursor cache hits59,32531,186-47.43455.83177.76-61.0098.7851.92-47.4481.2729.96-63.14
session logical reads654,240727,93011.265,026.974,149.18-17.461,089.311,211.8511.25896.22699.26-21.98
user calls11,40518,91065.8087.63107.7923.0118.9931.4865.7715.6218.1716.33
user commits13815613.041.060.89-16.040.230.2613.040.190.15-21.05
user rollbacks59288549.494.555.0410.770.991.4748.480.810.854.94
workarea executions - optimal2,2813,02832.7517.5317.26-1.543.805.0432.633.122.91-6.73


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 referenced111318.180.080.07-12.500.020.020.000.020.01-50.00
CPU used by this session2,1444,398105.1316.4725.0752.223.577.32105.042.944.2243.54
CPU used when call started1,8341,9023.7114.0910.84-23.073.053.173.932.511.83-27.09
CR blocks created720185.710.050.11120.000.010.03200.000.010.02100.00
Cached Commit SCN referenced18,70518,701-0.02143.72106.60-25.8331.1431.13-0.0325.6217.96-29.90
Commit SCN cached84-50.000.060.02-66.670.010.010.000.010.00-100.00
DBWR checkpoint buffers written6436521.404.943.72-24.701.071.091.870.880.63-28.41
DBWR transaction table writes21224.760.160.13-18.750.030.0433.330.030.02-33.33
DBWR undo block writes114105-7.890.880.60-31.820.190.17-10.530.160.10-37.50
HSC Heap Segment Block Changes1,758700-60.1813.513.99-70.472.931.17-60.072.410.67-72.20
Heap Segment Array Inserts1101110.910.850.63-25.880.180.180.000.150.11-26.67
Heap Segment Array Updates617827.870.470.44-6.380.100.1330.000.080.07-12.50
IMU Flushes5980.000.040.0525.000.010.010.000.010.010.00
IMU Redo allocation size65,824102,28055.38505.77582.9915.27109.60170.2755.3690.1798.258.96
IMU commits1331469.771.020.83-18.630.220.249.090.180.14-22.22
IMU undo allocation size245,424267,1928.871,885.761,522.99-19.24408.63444.828.86336.20256.67-23.66
Number of read IOs issued6,2947,74022.9748.3644.12-8.7710.4812.8923.008.627.44-13.69
Requests to/from client9,39016,17972.3072.1592.2227.8215.6326.9372.3012.8615.5420.84
RowCR attempts110.000.010.010.000.000.000.000.000.000.00
RowCR hits110.000.010.010.000.000.000.000.000.000.00
SMON posted for dropping temp segment110.000.010.010.000.000.000.000.000.000.00
SQL*Net roundtrips to/from client9,38816,18072.3572.1392.2327.8715.6326.9472.3612.8615.5420.84
TBS Extension: tasks created12100.000.010.010.000.000.000.000.000.000.00
TBS Extension: tasks executed12100.000.010.010.000.000.000.000.000.000.00
active txn count during cleanout677511.940.510.43-15.690.110.129.090.090.07-22.22
background timeouts3,3943,4020.2426.0819.39-25.655.655.660.184.653.27-29.68
buffer is not pinned count143,484127,682-11.011,102.49727.78-33.99238.90212.56-11.03196.55122.65-37.60
buffer is pinned count286,367246,471-13.932,200.351,404.88-36.15476.80410.32-13.94392.28236.76-39.65
bytes received via SQL*Net from client1,223,2011,530,90825.169,398.688,726.13-7.162,036.632,548.6325.141,675.621,470.61-12.23
bytes sent via SQL*Net to client7,038,9989,209,86730.8454,085.4052,495.98-2.9411,719.9215,332.4530.829,642.468,847.13-8.25
calls to get snapshot scn: kcmgss74,2361,018,0031,271.31570.415,802.59917.27123.601,694.761,271.17101.69977.91861.66
calls to kcmgas8,6787,212-16.8966.6841.11-38.3514.4512.01-16.8911.896.93-41.72
calls to kcmgcs9,20417,50190.1570.7299.7641.0615.3229.1490.2112.6116.8133.31
cell physical IO interconnect bytes3,275,323,3924,018,923,00822.7025,166,534.8522,907,748.26-8.985,453,409.826,690,644.5822.694,486,744.373,860,636.90-13.95
change write time123-75.000.090.02-77.780.020.00-100.000.020.00-100.00
cleanout - number of ktugct calls10615142.450.810.866.170.180.2538.890.150.150.00
cleanouts and rollbacks - consistent read gets416300.000.030.09200.000.010.03200.000.010.02100.00
cleanouts only - consistent read gets417582.930.320.4334.380.070.1271.430.060.0716.67
cluster key scan block gets62,04298,12858.16476.71559.3317.33103.30163.3658.1484.9994.2610.91
cluster key scans29,37632,66211.19225.72186.17-17.5248.9154.3811.1840.2431.38-22.02
commit cleanout failures: callback failure1412-14.290.110.07-36.360.020.020.000.020.01-50.00
commit cleanout failures: cannot pin3433.330.020.020.000.000.01100.000.000.000.00
commit cleanouts1,210672-44.469.303.83-58.822.011.12-44.281.660.65-60.84
commit cleanouts successfully completed1,189656-44.839.143.74-59.081.981.09-44.951.630.63-61.35
commit txn count during cleanout11319269.910.871.0925.290.190.3268.420.150.1820.00
consistent changes7632-57.890.580.18-68.970.130.05-61.540.100.03-70.00
consistent gets646,963722,49811.684,971.064,118.22-17.161,077.191,202.8011.66886.25694.04-21.69
consistent gets - examination129,90935,792-72.45998.18204.01-79.56216.3059.59-72.45177.9634.38-80.68
consistent gets direct386,509478,39523.772,969.812,726.84-8.18643.54796.4323.76529.46459.55-13.20
consistent gets from cache260,454244,103-6.282,001.251,391.38-30.47433.66406.38-6.29356.79234.49-34.28
consistent gets from cache (fastpath)120,748197,56763.62927.791,126.1321.38201.05328.9163.60165.41189.7914.74
cursor authentications2,84176-97.3221.830.43-98.034.730.13-97.253.890.07-98.20
data blocks consistent reads - undo records applied161812.500.120.10-16.670.030.030.000.020.020.00
db block gets7,2775,432-25.3555.9130.96-44.6312.129.04-25.419.975.22-47.64
db block gets from cache7,2705,432-25.2855.8630.96-44.5812.109.04-25.299.965.22-47.59
db block gets from cache (fastpath)1,5841,79913.5712.1710.25-15.782.642.9913.262.171.73-20.28
deferred (CURRENT) block cleanout applications695374-46.195.342.13-60.111.160.62-46.550.950.36-62.11
enqueue conversions218800.000.020.10400.000.000.03100.000.000.02100.00
enqueue releases59,7678,954-85.02459.2351.04-88.8999.5114.91-85.0281.878.60-89.50
enqueue requests59,7698,962-85.01459.2551.08-88.8899.5214.92-85.0181.888.61-89.48
enqueue timeouts330.000.020.020.000.000.000.000.000.000.00
file io service time39,1711,999-94.90300.9811.39-96.2265.223.33-94.8953.661.92-96.42
free buffer inspected8,2026,268-23.5863.0235.73-43.3013.6610.43-23.6511.246.02-46.44
free buffer requested8,4027,782-7.3864.5644.36-31.2913.9912.96-7.3611.517.48-35.01
heap block compress1713-23.530.130.07-46.150.030.02-33.330.020.01-50.00
hot buffers moved to head of LRU1,1077,692594.858.5143.84415.161.8412.81596.201.527.39386.18
immediate (CR) block cleanout applications4591102.220.350.5248.570.070.15114.290.060.0950.00
immediate (CURRENT) block cleanout applications7210444.440.550.597.270.120.1741.670.100.100.00
index crx upgrade (positioned)5444-18.520.410.25-39.020.090.07-22.220.070.04-42.86
index fetch by key132,35022,713-82.841,016.93129.46-87.27220.3637.81-82.84181.3021.82-87.96
index scans kdiixs130,06362,243107.04230.99354.7853.5950.05103.62107.0341.1859.7945.19
java call heap collected bytes391,784783,568100.003,010.344,466.3248.37652.321,304.4799.97536.69752.7140.25
java call heap collected count4,8629,724100.0037.3655.4348.378.1016.1999.886.669.3440.24
java call heap gc count24100.000.020.020.000.000.01100.000.000.000.00
java call heap live object count3,7197,438100.0028.5842.4048.366.1912.38100.005.097.1540.47
java call heap live object count max3,7197,438100.0028.5842.4048.366.1912.38100.005.097.1540.47
java call heap live size264,632529,264100.002,033.353,016.7948.37440.61881.1199.98362.51508.4240.25
java call heap live size max264,632529,264100.002,033.353,016.7948.37440.61881.1199.98362.51508.4240.25
java call heap object count7,87515,750100.0060.5189.7748.3613.1126.22100.0010.7915.1340.22
java call heap object count max7,87515,750100.0060.5189.7748.3613.1126.22100.0010.7915.1340.22
java call heap total size1,310,7202,621,440100.0010,071.1514,942.1348.372,182.354,364.1499.971,795.512,518.1940.25
java call heap total size max1,310,7202,621,440100.0010,071.1514,942.1348.372,182.354,364.1499.971,795.512,518.1940.25
java call heap used size564,5121,129,024100.004,337.536,435.4148.37939.911,879.5899.97773.301,084.5640.25
java call heap used size max564,5121,129,024100.004,337.536,435.4148.37939.911,879.5899.97773.301,084.5640.25
java session heap live size421,888843,776100.003,241.654,809.5048.37702.441,404.7199.98577.93810.5440.25
java session heap live size max421,888843,776100.003,241.654,809.5048.37702.441,404.7199.98577.93810.5440.25
java session heap used size421,888843,776100.003,241.654,809.5048.37702.441,404.7199.98577.93810.5440.25
java session heap used size max421,888843,776100.003,241.654,809.5048.37702.441,404.7199.98577.93810.5440.25
leaf node 90-10 splits141721.430.110.10-9.090.020.0350.000.020.020.00
leaf node splits21224.760.160.13-18.750.030.0433.330.030.02-33.33
lob reads1721741.161.320.99-25.000.290.290.000.240.17-29.17
lob writes1135218.180.080.20150.000.020.06200.000.020.0350.00
lob writes unaligned1135218.180.080.20150.000.020.06200.000.020.0350.00
logical read bytes from cache2,193,195,0082,044,190,720-6.7916,851,807.2911,651,829.69-30.863,651,667.263,403,138.99-6.813,004,376.721,963,679.85-34.64
messages received906690-23.846.963.93-43.531.511.15-23.841.240.66-46.77
messages sent906690-23.846.963.93-43.531.511.15-23.841.240.66-46.77
min active SCN optimization applied on CR344429.410.260.25-3.850.060.0716.670.050.04-20.00
no work - consistent read gets505,324665,25831.653,882.753,791.95-2.34841.361,107.5131.63692.22639.06-7.68
non-idle wait count27,52434,67525.98211.49197.65-6.5445.8357.7325.9737.7033.31-11.64
parse count (describe)1233175.000.090.19111.110.020.05150.000.020.0350.00
parse count (failures)25150.000.020.0350.000.000.01100.000.000.000.00
parse count (hard)6,624415-93.7350.902.37-95.3411.030.69-93.749.070.40-95.59
parse time cpu519152-70.713.990.87-78.200.860.25-70.930.710.15-78.87
physical read IO requests14,45315,2155.27111.0586.73-21.9024.0625.335.2819.8014.62-26.16
physical read bytes3,234,947,0723,981,172,73623.0724,856,296.1622,692,572.77-8.705,386,183.296,627,798.4823.054,431,434.353,824,373.43-13.70
physical read total IO requests16,10816,6933.63123.7795.15-23.1226.8227.793.6222.0716.04-27.32
physical read total bytes3,260,743,6804,005,085,18422.8325,054,509.0222,828,873.05-8.885,429,134.626,667,607.5822.814,466,772.163,847,344.08-13.87
physical read total multi block requests6,0607,50423.8346.5642.77-8.1410.0912.4923.798.307.21-13.13
physical reads cache8,1587,490-8.1962.6842.69-31.8913.5812.47-8.1711.187.20-35.60
physical reads cache prefetch1151,400.000.010.09800.000.000.02100.000.000.01100.00
physical reads direct386,733478,49323.732,971.532,727.40-8.22643.91796.5923.71529.77459.65-13.24
physical reads direct (lob)5005040.803.842.87-25.260.830.841.200.680.48-29.41
physical write IO requests459455-0.873.532.59-26.630.760.760.000.630.44-30.16
physical write bytes5,455,8725,357,568-1.8041,921.1730,537.99-27.159,084.028,919.20-1.817,473.805,146.56-31.14
physical write total IO requests1,3821,113-19.4610.626.34-40.302.301.85-19.571.891.07-43.39
physical write total bytes14,579,71213,837,824-5.09112,025.8378,875.21-29.5924,275.2023,037.01-5.1019,972.2113,292.82-33.44
physical write total multi block requests990.000.070.05-28.570.010.010.000.010.010.00
physical writes from cache659654-0.765.063.73-26.281.101.09-0.910.900.63-30.00
physical writes non checkpoint327266-18.652.511.52-39.440.540.44-18.520.450.26-42.22
process last non-idle time1,199900-24.949.215.13-44.302.001.50-25.001.640.86-47.56
recursive calls122,1981,035,503747.40938.935,902.34528.62203.461,723.89747.29167.39994.72494.25
recursive cpu usage1,0181,85982.617.8210.6035.551.693.0982.841.391.7928.78
redo blocks checksummed by FG (exclusive)1,6351,6611.5912.569.47-24.602.722.771.842.241.60-28.57
redo blocks written4,0602,995-26.2331.2017.07-45.296.764.99-26.185.562.88-48.20
redo entries3,7442,378-36.4928.7713.55-52.906.233.96-36.445.132.28-55.56
redo ordering marks9887-11.220.750.50-33.330.160.14-12.500.130.08-38.46
redo subscn max counts21626723.611.661.52-8.430.360.4422.220.300.26-13.33
redo synch time91677.780.070.0928.570.010.03200.000.010.02100.00
redo synch time (usec)156,344226,32744.761,201.301,290.067.39260.31376.7944.75214.17217.411.51
redo synch writes13115115.271.010.86-14.850.220.2513.640.180.15-16.67
redo wastage133,55675,528-43.451,026.20430.51-58.05222.37125.74-43.45182.9572.55-60.34
redo write time546214.810.410.35-14.630.090.1011.110.070.06-14.29
redo writes489230-52.973.761.31-65.160.810.38-53.090.670.22-67.16
rollbacks only - consistent read gets52-60.000.040.01-75.000.010.00-100.000.010.00-100.00
rows fetched via callback3,3922,135-37.0626.0612.17-53.305.653.55-37.174.652.05-55.91
session uga memory2,296,53610,296,928348.3717,645.8558,692.20232.613,823.7317,142.18348.313,145.949,891.38214.42
session uga memory max72,519,62497,307,92834.18557,217.54554,652.46-0.46120,745.09161,996.8234.1699,341.9593,475.44-5.91
shared hash latch upgrades - no wait1,8863,49285.1514.4919.9037.343.145.8185.032.583.3529.84
sorts (memory)3,2914,06723.5825.2923.18-8.345.486.7723.544.513.91-13.30
sorts (rows)116,610155,97033.75895.99889.02-0.78194.16259.6633.74159.74149.83-6.20
sql area purged27250.000.020.04100.000.000.01100.000.000.01100.00
switch current to new buffer10012323.000.770.70-9.090.170.2017.650.140.12-14.29
table fetch by rowid126,359131,2653.88970.90748.21-22.94210.39218.533.87173.09126.10-27.15
table fetch continued row18666-64.521.430.38-73.430.310.11-64.520.250.06-76.00
table scan blocks gotten399,778508,03727.083,071.772,895.80-5.73665.63845.7727.06547.64488.03-10.88
table scan rows gotten4,910,3448,728,78077.7637,729.5149,753.8031.878,175.7214,531.5577.746,726.508,385.0024.66
table scans (cache partitions)2350.000.020.020.000.000.000.000.000.000.00
table scans (direct read)5740.000.040.040.000.010.010.000.010.010.00
table scans (long tables)3433.330.020.020.000.000.01100.000.000.000.00
table scans (short tables)6409,9891,460.784.9256.941,057.321.0716.631,454.210.889.60990.91
total cf enq hold time8070-12.500.610.40-34.430.130.12-7.690.110.07-36.36
total number of cf enq holders54-20.000.040.02-50.000.010.010.000.010.00-100.00
total number of times SMON posted511120.000.040.0650.000.010.02100.000.010.010.00
undo change vector size581,688455,076-21.774,469.502,593.92-41.96968.51757.60-21.78796.83437.15-45.14


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.326.3619.550.100.100.005.176.2220.310.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
27.1027.923.0313.5612.58-7.2310.7612.8919.802.301.86-19.130.750.761.330.010.00-100.000.820.39-52.44


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.336.3619.325.296.3219.470.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
27.1227.932.9924.4225.534.550.000.000.002.301.86-19.130.760.760.000.000.000.000.820.39-52.44


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_DATA_LARGE1 10.0012.5525.500.020.0350.006,0077,5360.020.0363.5863.431419000.000.0010.0212.582.55
MN_DATA1 13.1411.50-12.480.000.000.007,8896,9098.7810.451.031.0400000.000.0013.1411.50-1.63
SYSTEM 0.110.70536.360.050.02-60.00664238.6411.351.001.023311330.000.000.160.720.56
MN_IDX1 0.300.00-100.000.000.000.0018208.570.001.000.0000000.000.000.300.00-0.30
SYSAUX 0.400.32-20.000.550.53-3.642381939.879.431.001.02328321000.000.000.940.86-0.09


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_IDX1/ora_prismaqa/index/prismaqa/mnidx01.dbf 0.230.00-100.000.000.000.0013608.380.001.000.0000000.000.000.230.00-0.23


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_IDX1/ora_prismaqa/index/prismaqa/mnidx01.dbf 0.880.00-0.888.380.0013600.230.001.000.00000.000.00000.000.00
MN_DATA_LARGE1/ora_prismaqa/data/prismaqa/mn_data_large1_04.dbf 0.000.110.110.000.263687750.611.2963.6561.73020.000.00000.000.00
MN_DATA_LARGE1/ora_prismaqa/data/prismaqa/mn_data_large1_01.dbf 0.060.01-0.060.030.002,5192,8664.194.7763.5763.69220.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)
B1083161,87022,1351,492,99222,135   
E1073061,64219,3421,492,99219,342   
           
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.00701,448660,156-5.8987110000.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,024709342.00.80.2100.00.0104,850
E11,024714330.60.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.000.000.000.00330.000.000.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
1st0.281,2911,081323/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

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Latch Wait Time Breakdown

No data exists for this section of the report.

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
SYSSYSTEMI_FILE#_BLOCK# INDEX16.4716.471.931.93-14.54107,74414,064-86.9517.602.04-15.57
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  6.588.516.58 47,872  6.936.93
SYSSYSTEMCOL$ TABLE6.8823.3512.4120.925.5345,04090,368100.647.3613.085.72
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE6.6830.0410.3531.273.6643,72875,32872.267.1410.903.76
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE34.9564.9931.4262.69-3.54228,688228,6880.0037.3733.09-4.27
DATALOADMN_DATA_LARGE1QUOTE TABLE11.8476.8310.6473.33-1.2077,45677,4560.0012.6611.21-1.45


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_LARGE1QUOTE_ITEM TABLE57.9157.9147.0647.06-10.85228,685228,6850.0060.5947.80-12.80
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  9.8556.919.85 47,865  10.0010.00
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE11.0969.0115.5072.404.4043,81275,30871.8911.6115.744.13
DATALOADMN_DATA_LARGE1QUOTE TABLE19.6188.6115.9388.33-3.6877,43477,4340.0020.5216.18-4.33
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE6.9395.555.6393.97-1.3027,37427,3740.007.255.72-1.53
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.0195.56  -0.0145  0.01 -0.01


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_LARGE1CUSTOMER TABLE  5.015.015.01 763  9.619.61
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE4.774.777.7812.803.016901,18471.5911.4614.913.45
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE24.8029.5723.5636.35-1.243,5843,5840.0059.5245.13-14.39
DATALOADMN_DATA_LARGE1QUOTE TABLE8.4137.997.9944.34-0.421,2161,2160.0020.2015.31-4.88
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.3138.30  -0.3145  0.75 -0.75
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE2.9941.292.8447.18-0.154324320.007.175.44-1.73


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_LARGE1CUSTOMER TABLE  5.015.015.01 763  9.619.61
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE4.774.777.7812.803.016901,18471.5911.4614.913.45
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE24.8029.5723.5636.35-1.243,5843,5840.0059.5245.13-14.39
DATALOADMN_DATA_LARGE1QUOTE TABLE8.4137.997.9944.34-0.421,2161,2160.0020.2015.31-4.88
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.3138.30  -0.3145  0.75 -0.75
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE2.9941.292.8447.18-0.154324320.007.175.44-1.73


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$ TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMFILE$ TABLE  0.000.000.00 0  0.000.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_LARGE1QUOTE_ITEM TABLE59.1359.1347.7947.79-11.34228,685228,6850.0060.6147.84-12.77
DATALOADMN_DATA_LARGE1CUSTOMER TABLE  10.0057.7910.00 47,854  10.0110.01
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE11.3370.4615.7473.534.4143,81275,30871.8911.6115.764.14
DATALOADMN_DATA_LARGE1QUOTE TABLE20.0290.4816.1889.72-3.8477,43477,4340.0020.5216.20-4.32
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE7.0897.565.7295.44-1.3627,37427,3740.007.265.73-1.53
SYSSYSTEMCOL$ TABLE0.0097.560.0095.440.00000.000.000.000.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$_SYSSTAT_PKWRH$_SYSSTA_3673847771_13254INDEX PARTITION2.102.10  -2.1014  9.86 -9.86
SYSSYSAUXWRH$_LATCH_MISSES_SUMMARY_PKWRH$_LATCH__3673847771_13254INDEX PARTITION  1.994.131.99 13  6.956.95
SYSSYSAUXWRH$_SYSTEM_EVENT_PKWRH$_SYSTEM_3673847771_13254INDEX PARTITION1.954.05  -1.9513  9.15 -9.15
SYSSYSAUXWRH$_SQL_PLAN TABLE2.856.911.075.20-1.78197-63.1613.383.74-9.64
SYSSYSAUXWRH$_SEG_STATWRH$_SEG_ST_3673847771_13254TABLE PARTITION0.457.361.997.191.54313333.332.116.954.84
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION0.457.811.999.171.54313333.332.116.954.84
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX1.509.31  -1.5010  7.04 -7.04
SYSSYSAUXWRH$_SYSSTATWRH$_SYSSTA_3673847771_13254TABLE PARTITION0.609.911.9911.161.39413225.002.826.954.13
SYSSYSAUXWRH$_PARAMETERWRH$_PARAME_3673847771_13254TABLE PARTITION2.1012.011.8313.00-0.271412-14.299.866.42-3.44


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
SYSSYSAUXWRH$_SQL_PLAN TABLE4.144.141.541.54-2.60197-63.1619.396.19-13.19
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX2.186.32  -2.1810  10.20 -10.20
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB1.748.06  -1.748  8.16 -8.16
DATALOADMN_DATA11MN_HIST_HEALTH TABLE  1.543.081.54 7  6.196.19
SYSSYSAUXWRH$_SYSMETRIC_HISTORY_INDEX INDEX  1.544.621.54 7  6.196.19
SYSSYSAUXWRH$_BG_EVENT_SUMMARY_PK INDEX  1.325.931.32 6  5.315.31
DATALOADMN_DATA_LARGE1MN_HIST_TASK TABLE1.9610.022.428.350.4691122.229.189.730.55
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE1.0911.110.669.01-0.4353-40.005.102.65-2.45


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.007  100.00 -100.00
SYSSYSTEMCOL$ TABLE0.00100.000.000.000.00000.000.000.000.00
SYSSYSTEMFILE$ TABLE  0.000.000.00 0  0.000.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
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE33.3333.3325.0050.00-8.33110.0033.3325.00-8.33
DATALOADMN_DATA_LARGE1QUOTE TABLE33.3366.6725.0075.00-8.33110.0033.3325.00-8.33
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE33.33100.0025.00100.00-8.33110.0033.3325.00-8.33
SYSSYSTEMCOL$ TABLE0.00100.000.00100.000.00000.000.000.000.00
SYSSYSTEMI_OBJ# INDEX0.00100.000.00100.000.00000.000.000.000.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by DB Block Changes

     % of Total Block Changes DB Block Changes % of Captured Block Changes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX4.074.07  -4.07288  26.87 -26.87
SYSSYSAUXWRH$_SQL_PLAN TABLE4.748.811.141.14-3.6133648-85.7131.346.98-24.37
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
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE1.139.94  -1.1380  7.46 -7.46
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION0.2310.171.145.300.911648200.001.496.985.48
SYSSYSAUXWRH$_SQLSTATWRH$_SQLSTA_3673847771_13254TABLE PARTITION0.6810.841.146.440.4648480.004.486.982.50
SYSSYSTEMSEG$ TABLE0.9011.750.767.19-0.156432-50.005.974.65-1.32


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
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION200.00 -200.002  50.0050.00  -50.00
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX200.00 -200.002  50.00100.00  -50.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.100.08-20.000.020.020.0013140.000.00000.000.002211
dc_files0.280.00-100.000.060.00-100.00370100.000.00000.000.00003737
dc_free_extents0.670.35-47.760.140.10-28.57876214.949.68620.000.0031114951
dc_global_oids1.380.44-68.120.300.13-56.671807711.111.30000.000.00003739
dc_histogram_data39.4546.8918.868.5513.7060.235,1348,22713.199.64000.000.00001,9982,607
dc_histogram_defs184.0558.05-68.4639.8816.95-57.5023,95310,1847.058.28000.000.00003,9582,876
dc_object_grants9.270.11-98.812.010.03-98.511,206193.980.00000.000.00005354
dc_objects99.5242.39-57.4121.5712.38-42.6112,9527,4372.981.14000.000.00051,5361,771
dc_profiles0.350.31-11.430.080.0912.5046550.000.00000.000.000022
dc_rollback_segments4.082.58-36.760.880.75-14.775314520.000.00000.000.00006767
dc_segments162.0712.67-92.1835.123.70-89.4621,0932,2221.8814.76000.000.0019231,083875
dc_sequences0.030.0433.330.010.010.0047100.0028.57000.000.004784
dc_table_scns0.000.01100.000.000.000.00020.00100.00000.000.000001
dc_tablespaces482.93113.41-76.52104.6533.12-68.3562,85119,8960.000.00000.000.00001414
dc_used_extents0.090.03-66.670.020.01-50.0012550.0060.00000.000.0012500
dc_users206.4884.26-59.1944.7424.61-44.9926,87314,7830.000.01000.000.00006364
global database name3.612.81-22.160.780.825.134704930.000.00000.000.000011
outstanding_alerts0.080.06-25.000.020.020.001111100.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.710.63-11.270.150.1820.00921100.000.0000  0000
BODY0.220.2618.180.050.0740.00284510.710.00797413.921.357100
CLUSTER0.360.32-11.110.080.0912.5047570.001.7547570.001.750000
DBLINK0.680.60-11.760.150.1820.00881060.000.0000  0000
EDITION0.510.49-3.920.110.1427.2767860.000.001131410.000.000000
INDEX0.140.39178.570.030.11266.67186966.6715.94186966.6715.940000
JAVA DATA0.010.010.000.000.000.00120.000.0000  0000
OBJECT ID0.000.01100.000.000.000.0001 100.0000  0000
QUEUE0.120.01-91.670.030.00-100.001620.000.001401220.000.000000
SCHEMA5.351.01-81.121.160.29-75.006961770.000.0000  0000
SQL AREA91.909.29-89.8919.912.71-86.3911,9601,62955.1811.2388,2571,018,23322.400.093212629
SQL AREA BUILD50.672.14-95.7810.980.63-94.266,59537699.4569.4100  0000
SQL AREA STATS50.631.68-96.6810.970.49-95.536,58929499.6787.416,58929499.6787.410000
TABLE/PROCEDURE159.82106.32-33.4834.6331.05-10.3420,80018,6521.620.3938,50620,9842.442.324929000
TRIGGER0.350.4014.290.080.1250.0046700.0010.0046700.0010.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,656.0045,312.00-2.8865,088.0057,024.00-12.3939.5125.85
Used (KB)0.000.000.000.000.000.000.000.00
Avg Alloc (KB)1,085.021,053.77-2.881,384.851,239.65-10.4827.6317.64
Std Dev Alloc (KB)783.21887.9513.371,307.421,224.20-6.3766.9337.87
Max Alloc (KB)4,544.004,928.000.004,672.004,928.005.482.828.45
Hist Max Alloc (KB)        
Num Procs43.0043.000.0047.0046.00-2.139.306.98
Num Alloc43.0043.000.0047.0046.00-2.139.306.98
JAVAAlloc (KB)2,421.92   2,421.92   
Used (KB)2,413.39   2,413.58   
Avg Alloc (KB)2,421.92   2,421.92   
Std Dev Alloc (KB)0.00 100.00 0.00 100.00 
Max Alloc (KB)2,421.922,421.92  2,421.92   
Hist Max Alloc (KB)2,954.10   2,954.10   
Num Procs1.00   1.00   
Num Alloc1.00   1.00   
OtherAlloc (KB)289,547.41281,038.95-2.94281,660.32286,122.491.58-2.721.81
Used (KB)        
Avg Alloc (KB)1,765.531,734.81-1.741,738.641,734.08-0.26-1.52-0.04
Std Dev Alloc (KB)2,066.422,056.13-0.502,055.752,038.07-0.86-0.52-0.88
Max Alloc (KB)17,471.0817,505.700.0017,494.0317,505.700.070.130.20
Hist Max Alloc (KB)23,128.6323,128.630.0023,128.6323,128.630.000.000.00
Num Procs164.00162.00-1.22162.00165.001.85-1.221.85
Num Alloc164.00162.00-1.22162.00165.001.85-1.221.85
PL/SQLAlloc (KB)8,654.058,617.15-0.438,756.228,834.990.901.182.53
Used (KB)6,462.576,428.09-0.536,534.166,592.860.901.112.56
Avg Alloc (KB)52.7753.190.8054.0553.55-0.932.430.66
Std Dev Alloc (KB)241.17242.600.59242.69240.55-0.880.63-0.85
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 Procs164.00162.00-1.22162.00165.001.85-1.221.85
Num Alloc164.00162.00-1.22162.00165.001.85-1.221.85
SQLAlloc (KB)3,012.863,729.3923.782,515.098,746.49247.76-16.52134.53
Used (KB)739.551,811.77144.98705.786,246.17785.00-4.57244.76
Avg Alloc (KB)20.0925.2025.4616.8857.92243.15-15.96129.87
Std Dev Alloc (KB)50.98101.8799.8047.06508.53980.65-7.70399.21
Max Alloc (KB)471.966,238.96133.62471.966,238.961,221.920.00465.85
Hist Max Alloc (KB)119,575.72119,575.720.00119,575.72106,242.12-11.150.00-11.15
Num Procs150.00148.00-1.33149.00151.001.34-0.672.03
Num Alloc142.00141.00-0.70144.00145.000.691.412.84


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.00737,280.000.00704,512.00704,512.000.00-4.44-4.44
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,327,106.200.001,359,874.201,359,874.200.002.472.47


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,244,4160.0024,244,41624,244,4160.000.000.00
java poolfree memory142,914,880142,914,8800.00142,914,880142,914,8800.000.000.00
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 poolKGLH017,062,89698,626,088478.01159,743,152163,649,3042.45836.2065.93
shared poolKGLHD 15,609,104 25,399,97625,902,5281.98 65.95
shared poolKGLS 13,726,344      
shared poolKTI-UNDO10,635,23210,635,2320.0010,635,23210,635,2320.000.000.00
shared poolSQLA13,353,02473,982,376454.0590,013,840101,206,56012.43574.1136.80
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 memory534,393,432367,816,584-31.17314,822,600291,439,648-7.43-41.09-20.76
shared poolkglsim heap   11,003,26411,003,2640.00  
shared poolkglsim object batch15,873,31215,873,3120.0019,045,65619,045,6560.0019.9919.99
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,720754,974,7200.00721,420,288721,420,2880.00-4.44-4.44
 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 Coordinator0.000.00-100.000.000.000.000.000.000.00
QMON Slaves0.040.00-88.890.100.00-100.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 Slaves0.100.000.100.000.000.00-100.000.040.00-88.89
QMON Coordinator0.000.000.000.000.000.000.000.000.00-100.00


Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

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.AQ$_ALERT_QT_E(12327) 20-100.00000.000.00 0.00 0.040.00-100.000.000.000.000.00 0.00 
SYS.ALERT_QUE(12328) 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.000.02 -100.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.0020-100.000.000.000.000.000.000.000.000.000.00
SERVER1_DOMAI_3872_PRISMA(42)/SYS.ALERT_QUE 000.00000.0020-100.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.0020-100.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
0guz6b5fs6xyabegin open :1 for select md.metric_id, at.internal_metric_category, at.internal_metric_name, md.status, md.category from dbsnmp.bsln_metric_defaults md, v$threshold_types tt, v$alert_types at where md.metric_id = tt.metrics_id and tt.alert_reason_id = at.reason_id; open :2 for select hour, dbsnmp.bsln.timegroup(:3 , hour), dbsnmp.bsln.timegroup(:4 , hour), dbsnmp.bsln.timegroup(:5 , hour), dbsnmp.bsln.timegroup(:6 , hour), dbsnmp.bsln.timegroup(:7 , hour), dbsnmp.bsln.timegroup(:8 , hour), dbsnmp.bsln.timegroup(:9 , hour), dbsnmp.bsln.timegroup(:10 , hour), dbsnmp.bsln.timegroup(:11 , hour) from dbsnmp.bsln_timegroups; open :12 for select HEXTORAW(dbsnmp.bsln.baseline_guid(baseline_id)), baseline_id, baseline_name from dba_hist_baseline_metadata where baseline_id = 0 and dbid = dbsnmp.bsln_internal.this_dbid; end;
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0m78skf1mudnbselect audit$, properties from type_misc$ where obj#=:1
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0z1031991bd7winsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation, sum_squares) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std, sumsq FROM x$kewmsmdv WHERE groupid = 2
1att0guk2skhmselect lobtsn, lobrdba, lobobjid from x$lobstat where lobspcalloc > 0 and lobcurrtime >= :1 order by lobspcalloc desc
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
1qntcw2s31n15select * from dba_hist_baseline
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
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
36ya4s1zjwx1hSELECT COUNT(*) FROM STATS$USER_LOG WHERE USERNAME = USER
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
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
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;
4x866jn4mj1uy SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
501kary3x38sj select r.apply_name apply_name, total_messages_dequeued, total_messages_spilled from gv$streams_apply_reader r, dba_apply a, dba_queues q, dba_queue_tables t where r.apply_name = a.apply_name and a.queue_name = q.name and a.queue_owner = q.owner and q.queue_table = t.queue_table and q.owner=t.owner and r.inst_id = t.owner_instance
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
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;
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
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
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
7wt7phk4xns75select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
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#
87vs8t2c6ra1cselect metric_id, value from v$sysmetric where intsize_csec > 5900 and group_id = 2 and metric_id in (2135, 2155, 2153, 2075)
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)))
8swypbbr0m372select order#, columns, types from access$ where d_obj#=: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
9gkq7rruycsjpselect parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
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
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
9vqmgu6c7011u select a.capture_name capture_name, total_messages_captured, total_messages_enqueued from gv$streams_capture a, dba_capture b, dba_queues c, dba_queue_tables d where a.capture_name = b.capture_name and b.queue_name=c.name and b.queue_owner=c.owner and c.queue_table=d.queue_table and c.owner=d.owner and d.owner_instance=a.inst_id
a3kxyqjurdtp8insert into mgmt_db_size_gtt SELECT free.tablespace_name, SUM(free.sz) as sz FROM (SELECT tablespace_name, NVL(sum(bytes)/1048576, 0) sz FROM sys.dba_free_space GROUP BY tablespace_name UNION ALL SELECT tablespace_name, NVL(SUM(bytes)/1048576, 0) sz FROM dba_undo_extents WHERE status='EXPIRED' GROUP BY tablespace_name) free GROUP BY free.tablespace_name
akfwbgvmmwhsmselect object_type from all_objects where object_name ='CUSTOMER' and owner= 'DATALOAD'
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;
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
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
fuyrx4r46bgxw select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
gdvfxf7k4scsn select r.apply_name apply_name, r.total_received total_received, r.total_assigned total_assigned, r.total_applied total_applied from gv$streams_apply_coordinator r, dba_apply a, dba_queues q, dba_queue_tables t where r.apply_name = a.apply_name and a.queue_name = q.name and a.queue_owner = q.owner and q.queue_table = t.queue_table and q.owner=t.owner and r.inst_id = t.owner_instance
grwydz59pu6mcselect text from view$ where rowid=:1


Back to Top