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
2nd1326607-May-13 10:30:39 (Tue)1326707-May-13 10:40:40 (Tue) 1.0 10.0 9.7
%Diff     340.9 0.1 348.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.482.67.197.7
Load at End Snapshot:2.271.81-.46-20.3
%User Time:1.63.331.73108.1
%System Time:.79.52-.27-34.2
%Idle Time:97.4396.11-1.33-1.4
%IO Wait Time:1.03.95-.09-7.8

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 1.0 340.9 0.2 0.6 255.6
CPU time: 0.0 0.9 2,866.7 0.0 0.6 1,866.7
Redo size: 3,060.5 2,755.6 -10.0 2,518.0 1,823.6 -27.6
Logical reads: 1,089.3 1,166.6 7.1 896.2 772.0 -13.9
Block changes: 11.8 9.2 -22.3 9.7 6.1 -37.5
Physical reads: 657.5 684.5 4.1 540.9 453.0 -16.3
Physical writes: 1.1 1.2 5.4 0.9 0.8 -14.3
User calls: 19.0 48.1 153.3 15.6 31.8 103.8
Parses: 19.8 1,668.0 8,302.9 16.3 1,103.9 6,659.7
Hard parses: 11.0 1,646.3 14,825.9 9.1 1,089.5 11,912.5
W/A MB processed: 151,872.6 192,807.3 27.0 124,951.9 127,598.5 27.0
Logons: 0.1 0.1 0.0 0.1 0.1 -14.3
Executes: 119.9 1,706.8 1,323.8 98.6 1,129.6 1,045.2
Transactions: 1.2 1.5 23.8   
1st2ndDiff
% Blocks changed per Read: 1.1 0.8 -0.3
Recursive Call %: 91.5 99.3 7.8
Rollback per transaction %: 81.1 84.5 3.4
Rows per Sort: 35.4 33.8 -1.7
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.20CPU time  533.24 91.29
direct path readUser I/O6,24639.826.3730.59direct path readUser I/O6,65241.296.217.07
CPU time  20.03 15.39db file sequential readUser I/O1,71613.177.682.26
control file sequential readSystem I/O1,6241.440.891.10control file sequential readSystem I/O1,4491.140.790.20
control file parallel writeSystem I/O2160.642.960.49log file parallel writeSystem I/O2300.632.740.11
-log file parallel writeSystem I/O4890.541.090.41-control file parallel writeSystem I/O2110.432.060.07

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.15584.12348.810.180.64255.56
parse time elapsed4.1180.8276.715.35472.108,724.300.010.525,100.00
DB CPU15.3991.2975.9020.03533.242,562.210.030.591,866.67
hard parse elapsed time3.4460.2856.844.48352.097,759.150.010.393,800.00
PL/SQL execution elapsed time0.265.815.550.3433.959,885.290.000.04100.00
sql execute elapsed time97.5799.461.88126.98580.94357.510.170.64276.47
connection management call elapsed time0.210.07-0.140.280.4250.000.000.000.00
PL/SQL compilation elapsed time0.110.01-0.110.150.03-80.000.000.000.00
hard parse (bind mismatch) elapsed time0.000.110.110.000.64100.000.000.000.00
hard parse (sharing criteria) elapsed time0.020.110.100.020.663,200.000.000.000.00
repeated bind elapsed time0.050.00-0.050.070.02-71.430.000.000.00
Java execution elapsed time0.060.02-0.030.070.1385.710.000.000.00
sequence load elapsed time0.000.000.000.000.02100.000.000.000.00
failed parse elapsed time0.000.000.000.000.01100.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.612.79-7.8213.8016.3118.190.020.020.00
background cpu time3.711.38-2.344.838.0366.250.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,21174,802378.12128.06-66.1381.94124.4851.9267.4182.3822.21
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,846,95714,363.053,161.94-77.993,112.373,073.61-1.252,560.682,034.09-20.56
IOWAIT_TIME19,83318,203152.3931.16-79.5533.0230.29-8.2727.1720.05-26.21
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,16810,047116.5517.20-85.2425.2516.72-33.7820.7811.06-46.78
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,66363,989235.60109.55-53.5051.05106.49108.6042.0070.4767.79
VM_IN_BYTES000.000.000.000.000.000.000.000.000.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.819.39-78.4224.3014.42-40.66114.2854.84-52.017.836.33-19.16
System I/O2.410.46-1.954.633.86-16.633.132.68-14.381.131.162.65
Application0.000.070.070.000.01100.000.000.43100.000.0385.91286,266.67
Concurrency0.090.03-0.070.010.252,400.000.120.1633.3315.381.07-93.04
Commit0.120.07-0.050.210.224.760.160.39143.751.222.94140.98
Other0.020.00-0.010.090.02-77.780.020.020.000.411.46256.10
Network0.020.00-0.0116.3844.49171.610.020.020.000.000.000.00


Back to Wait Events
Back to Top

Wait Events

  % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
EventWait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db file sequential readUser I/O57.202.26-54.9413.662.86-79.0674.4413.17-82.319.077.68-15.33
direct path readUser I/O30.597.07-23.5210.4011.076.4439.8241.293.696.376.21-2.51
control file sequential readSystem I/O1.100.20-0.912.702.41-10.741.441.14-20.830.890.79-11.24
control file parallel writeSystem I/O0.490.07-0.420.360.35-2.780.640.43-32.812.962.06-30.41
db file parallel writeSystem I/O0.400.08-0.320.750.72-4.000.520.48-7.691.161.11-4.31
log file parallel writeSystem I/O0.410.11-0.300.810.38-53.090.540.6316.671.092.74151.38
SQL*Net break/reset to clientApplication0.000.070.070.000.01100.000.000.43100.000.03107.10356,900.00
os thread startupConcurrency0.090.03-0.070.010.010.000.120.1633.3324.4222.72-6.96
log file syncCommit0.120.07-0.050.210.224.760.160.39143.751.222.94140.98
db file scattered readUser I/O0.010.060.050.000.24100.000.010.343,300.0011.202.34-79.11
ADR block file readOther0.010.00-0.010.010.010.000.020.020.004.754.964.42
SQL*Net more data to clientNetwork0.010.00-0.010.510.521.960.010.010.000.040.03-25.00
SQL*Net message to clientNetwork0.010.00-0.0115.8743.97177.060.010.010.000.000.000.00
Disk file operations I/OUser I/O0.000.00-0.000.230.230.000.010.010.000.040.040.00
direct path writeUser I/O0.010.00-0.000.010.02100.000.010.010.000.961.015.21
read by other sessionUser I/O0.000.000.000.000.000.000.000.01100.000.0014.75100.00
LGWR wait for redo copyOther0.000.00-0.000.080.01-87.500.000.000.000.060.05-16.67
buffer busy waitsConcurrency0.000.00-0.000.000.000.000.000.000.000.320.25-21.88
latch: shared poolConcurrency0.000.000.000.000.23100.000.000.000.000.000.02100.00
enq: KO - fast object checkpointApplication0.000.000.000.000.000.000.000.000.000.001.16100.00
reliable messageOther0.000.000.000.000.000.000.000.000.000.000.32100.00
SQL*Net more data from clientNetwork0.000.00-0.000.000.000.000.000.000.000.020.020.00
latch freeOther0.000.000.000.000.01100.000.000.000.000.000.03100.00
library cache: mutex XConcurrency0.000.000.000.000.000.000.000.000.000.000.01100.00
SQL*Net message from clientIdle39,259.331,881.38-37,377.9615.9544.04176.1151,094.4510,989.55-78.495,334.56415.26-92.22
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
EMON slave idle waitIdle2,305.62517.13-1,788.491.001.011.003,000.683,020.690.675,001.134,976.42-0.49
Space Manager: slave idle waitIdle2,227.89565.52-1,662.371.001.1919.002,899.513,303.3413.934,808.474,607.16-4.19
DIAG idle waitIdle921.53205.49-716.051.992.000.501,199.341,200.290.081,001.121,001.07-0.00
Streams AQ: emn coordinator idle waitIdle461.17102.75-358.420.100.100.00600.20600.19-0.0010,003.2910,003.25-0.00
Streams AQ: qmn coordinator idle waitIdle451.96105.49-346.460.070.070.00588.20616.224.7614,004.8114,004.980.00
Streams AQ: qmn slave idle waitIdle451.95105.49-346.460.030.0433.33588.20616.224.7628,009.4628,009.840.00
JOX Jit Process SleepIdle110.6835.97-74.710.030.0566.67144.04210.0845.858,473.107,503.02-11.45
SGA: MMAN sleep for component shrinkIdle0.000.150.150.000.14100.000.000.87100.000.0010.67100.00
class slave waitIdle0.000.00-0.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.59100.001.4199.13100.000.8799.0499.940.9091.3492.841.51
SYS$BACKGROUND0.000.000.000.000.000.000.060.060.008.917.22-1.69
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
81uvdbt46vt5p2.722.7289.1489.1486.423,543520,7020.010.003,542520,667000.000.001.001.0011  DECLARE /* Yannick */ i NUMBER...
a3kxyqjurdtp857.3660.08  -57.3674,646 0.01 4,082 70,986 7,853.00 13.00 1 1// 1 insert into mgmt_db_size_gtt S...
dc1876qva6b7029.0389.115.8194.95-23.2237,78433,9400.010.003,7482,00034,76432,329333,493.00333,528.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
8jk9z1dwpkpb35.6994.801.4796.42-4.223,7054,2940.020.003842873,4114,07137,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
9tgj4g8y4rwy80.9095.71  -0.900 390.47 0 0 0.00 0.16 50,818 1// 1 select type#, blocks, extents,...
bzgpy0vxtvf630.7896.490.1296.54-0.6625170.310.072517000.000.003.7514.9340401/ 1/ 1 SELECT event#, sql_id, sql_pla...
6ajkhukk78nsr0.4596.930.0396.58-0.425851970.010.004517113612613.009.001.001.0011  begin prvt_hdm.auto_execute( :...
f1yky4nd9n9s60.4797.410.1196.68-0.3715160.320.071515000.000.0014.0014.0042401/ 1/ 1 select end_time, wait_class#, ...
87vs8t2c6ra1c0.4097.810.0696.74-0.341290.320.07129000.000.004.004.0042401/ 1/ 1 select metric_id, value from v...
29npwaz6dqsva0.4398.240.1596.90-0.2835550.120.036429509.7510.38887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
db78fxqxwxt7r0.0798.310.3397.230.26011.714.2500010.050.0615.9217.532222,4811/ 1/ 1 select /*+ rule */ bucket, end...
7z7x3166pt4km  0.1497.370.14 838 0.00 406 434 40.00 3.00 1/ 1/ 1 SELECT 'SCHEMA' type, username...
61a161nm1ttjj  0.1497.510.14 7 0.21 6 0 0.03 0.00 123/ 1/ 1 select /*+ INDEX(TAB AQ$_AQ_EV...
9nh7uqswpdc6h  0.1197.620.11 642 0.00 19 626 74.00 0.00 1/ 1/ 1 select OID, Customer_Oid, Cust...
b4mrsfc9ttham  0.1197.730.11 16 0.07 16 0 0.05 6.15 40/ 1/ 1 WITH snaps as (SELECT :1 dbid,...


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
81uvdbt46vt5p17.6917.6997.6497.6479.953,542520,667000.010.003,543520,7020.000.001.001.00  DECLARE /* Yannick */ i NUMBER...
a3kxyqjurdtp820.3838.07  -20.384,082 70,986 0.01 74,646 7,853.00 13.00 1// 1 insert into mgmt_db_size_gtt S...
dc1876qva6b7018.7256.790.3898.02-18.343,7482,00034,76432,3290.010.0037,78433,940333,493.00333,528.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
9tgj4g8y4rwy85.9662.75  -5.960 0 390.47 0 0.00 0.16 1// 1 select type#, blocks, extents,...
bzgpy0vxtvf635.0567.800.1398.15-4.922517000.310.0725170.000.003.7514.931/ 1/ 1 SELECT event#, sql_id, sql_pla...
8jk9z1dwpkpb33.8371.630.1198.25-3.733842873,4114,0710.020.003,7054,29437,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
f1yky4nd9n9s63.0974.710.1298.37-2.971515000.320.0715160.000.0014.0014.001/ 1/ 1 select end_time, wait_class#, ...
87vs8t2c6ra1c2.6077.310.0798.44-2.53129000.320.071290.000.004.004.001/ 1/ 1 select metric_id, value from v...
d2687zmqyq4av2.5879.890.0798.51-2.501310000.300.0713100.000.0014.0014.001/ 1/ 1 select metric_id, value from v...
6ajkhukk78nsr2.2582.140.0198.53-2.24451711361260.010.0058519713.009.001.001.00  begin prvt_hdm.auto_execute( :...
cyg8zddx2x8h61.0083.140.1098.63-0.89514000.280.075140.000.0014.0014.001/ 1/ 1 select FUNCTION_NAME, SMALL_RE...
61a161nm1ttjj  0.1498.770.14 6 0 0.21 7 0.03 0.00/ 1/ 1 select /*+ INDEX(TAB AQ$_AQ_EV...
b4mrsfc9ttham  0.1298.880.12 16 0 0.07 16 0.05 6.15/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
7z7x3166pt4km  0.0898.960.08 406 434 0.00 838 40.00 3.00/ 1/ 1 SELECT 'SCHEMA' type, username...


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...
dc1876qva6b7026.7181.255.535.53-21.1834,76432,32937,78433,9400.010.003,7482,000333,493.00333,528.000.000.00111/ 1/ 1 select qi.oid from dataload.qu...
8jk9z1dwpkpb35.2486.501.396.93-3.853,4114,0713,7054,2940.020.0038428737,654.0037,654.001.001.00221/ 1/ 1 SELECT mn_member.ver_num, mn_m...
db78fxqxwxt7r0.0686.550.307.220.2401011.714.25000.050.0615.9217.532222,4811/ 1/ 1 select /*+ rule */ bucket, end...
29npwaz6dqsva0.3586.910.147.36-0.21295035550.120.03649.7510.38887.50887.5016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
9nh7uqswpdc6h  0.117.470.11 626 642 0.00 19 74.00 0.00 1/ 1/ 1 select OID, Customer_Oid, Cust...
6ajkhukk78nsr0.1087.010.027.49-0.081361265851970.010.004517113.009.001.001.0011  begin prvt_hdm.auto_execute( :...
7z7x3166pt4km  0.077.560.07 434 838 0.00 406 40.00 3.00 1/ 1/ 1 SELECT 'SCHEMA' type, username...
61a161nm1ttjj  0.017.570.01 0 7 0.21 6 0.03 0.00 123/ 1/ 1 select /*+ INDEX(TAB AQ$_AQ_EV...
b4mrsfc9ttham  0.007.580.00 0 16 0.07 16 0.05 6.15 40/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
81uvdbt46vt5p0.0087.010.007.580.00003,543520,7020.010.003,542520,6670.000.001.001.0011  DECLARE /* Yannick */ i NUMBER...
87vs8t2c6ra1c0.0087.010.007.580.00001290.320.071290.000.004.004.0042401/ 1/ 1 select metric_id, value from v...
9tgj4g8y4rwy80.0087.01  0.000 0 390.47 0 0.00 0.16 50,818 1// 1 select type#, blocks, extents,...
bzgpy0vxtvf630.0087.010.007.580.000025170.310.0725170.000.003.7514.9340401/ 1/ 1 SELECT event#, sql_id, sql_pla...
f1yky4nd9n9s60.0087.010.007.580.000015160.320.0715150.000.0014.0014.0042401/ 1/ 1 select end_time, wait_class#, ...


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.91  -16.752.16 50,818 0 0 0 0.00 0.16 1// 1 select type#, blocks, extents,...
5hk2758bxufj07.9944.9014.9114.916.92111.66111.664689361110000.000.0223.5323.531/ 1/ 1 SELECT column_name, nullable, ...
dc1876qva6b7051.0995.9947.6862.59-3.41334,270.00334,270.001137,78433,9403,7482,00034,76432,329333,493.00333,528.000.000.001/ 1/ 1 select qi.oid from dataload.qu...
61a161nm1ttjj  2.3364.932.33 132.98 123 7 6 0 0.03 0.00/ 1/ 1 select /*+ INDEX(TAB AQ$_AQ_EV...
96g93hntrzjtr0.1596.142.1167.041.972.672.353606,3010000000.010.000.630.351/ 1/ 1 select /*+ rule */ bucket_cnt,...
b4mrsfc9ttham  1.9168.961.91 335.33 40 16 16 0 0.05 6.15/ 1/ 1 WITH snaps as (SELECT :1 dbid,...
3w4qs0tbpmxr60.0296.161.3270.281.302.0527.64793350000000.000.000.0312.821/ 1/ 1 select con#, obj#, rcon#, enab...
81uvdbt46vt5p0.0396.191.2871.561.25188.008,963.00113,543520,7023,542520,667000.000.001.001.00  DECLARE /* Yannick */ i NUMBER...
53saa2zkr6wc30.1096.291.3372.881.224.424.061542,2900000000.010.001.211.031/ 1/ 1 select intcol#, nvl(pos#, 0), ...
6ajkhukk78nsr1.5097.790.3473.23-1.159,785.002,415.00115851974517113612613.009.001.001.00  begin prvt_hdm.auto_execute( :...
8jk9z1dwpkpb311.53109.3210.7683.99-0.7737,727.0037,727.00223,7054,2943842873,4114,07137,654.0037,654.001.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
3c1kubcdjnppq0.42109.75  -0.423.39 819 0 0 0 0.00 0.99 1// 1 update sys.col_usage$ set equa...
1qntcw2s31n150.27110.02  -0.271,786.00 1 169 66 102 12.00 2.00 1// 1 select * from dba_hist_baselin...
7qjhf5dzmazsr3.01113.032.8486.83-0.1719,701.0019,921.001130444330433201130.0013.008.008.001/ 1/ 1 SELECT snap_id , OBJ#, DATAOBJ...
29npwaz6dqsva0.56113.590.5087.33-0.06228.75218.75161635556429509.7510.38887.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.4581.0981.09-3.36333,493.00333,528.001137,78433,9403,7482,00034,76432,3290.000.001/ 1/ 1 select qi.oid from dataload.qu...
a3kxyqjurdtp81.9986.44  -1.997,853.00 1 74,646 4,082 70,986 13.00 1// 1 insert into mgmt_db_size_gtt S...
8jk9z1dwpkpb319.07105.5118.3199.40-0.7637,654.0037,654.00223,7054,2943842873,4114,0711.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
db78fxqxwxt7r0.00105.510.0499.430.030.050.062222,48101000115.9217.531/ 1/ 1 select /*+ rule */ bucket, end...
9nh7uqswpdc6h  0.0299.450.02 74.00 1 642 19 626 0.00/ 1/ 1 select OID, Customer_Oid, Cust...
7z7x3166pt4km  0.0199.460.01 40.00 1 838 406 434 3.00/ 1/ 1 SELECT 'SCHEMA' type, username...
6xvp6nxs4a9n4  0.0199.470.01 1.33 27 17 2 15 1.00/ 1/ 1 select nvl(sum(space), 0) from...
5fkzpyqyptax3  0.0199.480.01 29.00 1 455 106 349 1.00  DECLARE instance_number NUMBE...
bqfx5q2jas08u  0.0199.490.01 29.00 1 371 25 349 1.00/ 1/ 1 SELECT TASK_LIST.TASK_ID FROM ...
96g93hntrzjtr0.00105.510.0199.490.010.010.003606,3010000000.630.351/ 1/ 1 select /*+ rule */ bucket_cnt,...
1qntcw2s31n150.00105.52  -0.0012.00 1 169 66 102 2.00 1// 1 select * from dba_hist_baselin...
9vqmgu6c7011u0.00105.52  -0.0012.00 1 402 263 140 0.00 1// 1 select a.capture_name capture...
83taa7kaw59c10.00105.520.0099.49-0.000.110.018071410001019.4522.751/ 1/ 1 select name, intcol#, segcol#,...
6ajkhukk78nsr0.00105.530.0099.49-0.0013.009.0011585197451711361261.001.00  begin prvt_hdm.auto_execute( :...
29npwaz6dqsva0.04105.570.0499.530.009.7510.3816163555642950887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
3ktacv9r56b510.00105.570.0099.540.000.090.081081431100113.531.641/ 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...
dc1876qva6b7036.2090.5362.1662.1625.965,232.005,265.005,2325,2650.000.001137,78433,9403,7482,00034,76432,3290.000.001/ 1/ 1 select qi.oid from dataload.qu...
8jk9z1dwpkpb38.1998.7313.9876.145.79592.00592.001,1841,1840.000.00223,7054,2943842873,4114,0711.001.001/ 1/ 1 SELECT mn_member.ver_num, mn_m...
db78fxqxwxt7r0.0798.801.7177.851.640.050.06101450.000.002222,48101000115.9217.531/ 1/ 1 select /*+ rule */ bucket, end...
9nh7uqswpdc6h  0.8478.690.84 71.00 71 0.00 1 642 19 626 0.00/ 1/ 1 select OID, Customer_Oid, Cust...
7z7x3166pt4km  0.4779.160.47 40.00 40 0.00 1 838 406 434 3.00/ 1/ 1 SELECT 'SCHEMA' type, username...
5fkzpyqyptax3  0.4379.590.43 36.00 36 0.00 1 455 106 349 1.00  DECLARE instance_number NUMBE...
6xvp6nxs4a9n4  0.4380.010.43 1.33 36 0.00 27 17 2 15 1.00/ 1/ 1 select nvl(sum(space), 0) from...
96g93hntrzjtr0.0298.820.3180.320.290.010.003260.000.003606,3010000000.630.351/ 1/ 1 select /*+ rule */ bucket_cnt,...
1qntcw2s31n150.1298.94  -0.1218.00 18 0.00 1 169 66 102 2.00 1// 1 select * from dba_hist_baselin...
9vqmgu6c7011u0.0899.02  -0.0812.00 12 0.00 1 402 263 140 0.00 1// 1 select a.capture_name capture...
6ajkhukk78nsr0.0999.110.1180.430.0213.009.001390.000.0011585197451711361261.001.00  begin prvt_hdm.auto_execute( :...
83taa7kaw59c10.0699.180.0580.47-0.020.110.01940.000.008071410001019.4522.751/ 1/ 1 select name, intcol#, segcol#,...
29npwaz6dqsva0.0099.180.0080.470.000.000.0000  16163555642950887.50887.502/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
3ktacv9r56b510.0099.180.0080.470.000.000.0000  1081431100113.531.641/ 1/ 1 select owner#, name, namespace...
bqfx5q2jas08u  0.0080.470.00 0.00 0   1 371 25 349 1.00/ 1/ 1 SELECT TASK_LIST.TASK_ID FROM ...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Executions

 #Executions/sec (DB time) #Executions Exec Time (ms) per Exec CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Plan  
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
9tgj4g8y4rwy8390.47 -390.4750,818 0 0 0 0.00 0.16 1// 1 select type#, blocks, extents,...
96g93hntrzjtr2.7710.798.023606,3010000000.010.000.630.351/ 1/ 1 select /*+ rule */ bucket_cnt,...
3c1kubcdjnppq6.29 -6.29819 0 0 0 0.00 0.99 1// 1 update sys.col_usage$ set equa...
53saa2zkr6wc31.183.922.741542,2900000000.010.001.211.031/ 1/ 1 select intcol#, nvl(pos#, 0), ...
db78fxqxwxt7r1.714.252.542222,4810100010.050.0615.9217.531/ 1/ 1 select /*+ rule */ bucket, end...
5hk2758bxufj03.601.60-1.994689361110000.000.0223.5323.531/ 1/ 1 SELECT column_name, nullable, ...
5n1fs4m2n2y0r0.562.391.83731,3940000000.000.001.581.591/ 1/ 1 select pos#, intcol#, col#, sp...
3nkd3g3ju5ph12.100.81-1.282734760000000.010.010.870.911/ 1/ 1 select obj#, type#, ctime, mti...
2q93zsrvbdw48 1.071.07 624 0 0 0 0.01 3.31/ 1/ 1 select grantee#, privilege#, n...
6aq34nj2zb2n7 0.970.97 569 0 0 0 0.02 0.00/ 1/ 1 select col#, grantee#, privile...
83taa7kaw59c10.611.220.61807141000100.110.0119.4522.751/ 1/ 1 select name, intcol#, segcol#,...
3ktacv9r56b510.830.24-0.591081431100110.090.083.531.641/ 1/ 1 select owner#, name, namespace...
8swypbbr0m3720.830.24-0.591081430000000.040.023.020.871/ 1/ 1 select order#, columns, types ...
7ng34ruy5awxq0.310.760.45404441111100.030.021.833.141/ 1/ 1 select i.obj#, i.ts#, i.file#,...
grwydz59pu6mc1.100.70-0.401434110000000.000.001.001.001/ 1/ 1 select text from view$ where r...


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
0k8522rmdzg4k0.390.390.000.00-0.38464446441/ 1/ 1 select privilege# from sysauth...
0ws7ahf1d78qa0.390.770.000.01-0.38464446441/ 1/ 1 select SYS_CONTEXT('USERENV', ...
36ya4s1zjwx1h0.391.160.000.01-0.38464446441/ 1/ 1 SELECT COUNT(*) FROM STATS$USE...
459f3z9u4fb3u0.391.540.000.02-0.38464446441/ 1/ 1 select value$ from props$ wher...
5ur69atw3vfhj0.391.930.000.02-0.38464446441/ 1/ 1 select decode(failover_method,...
bgba4tpdcpgun0.392.320.000.03-0.3846444644  declare t_user_count NUMBER; l...
cm5vu20fhtnq10.392.700.000.03-0.38464450461/ 1/ 1 select /*+ connect_by_filterin...
d6yky1ddz2m2q0.393.090.000.04-0.38464446441/ 1/ 1 UPDATE STATS$USER_LOG SET LAST...
0v3dvmc22qnam0.313.40  -0.3137 8   insert into sys.col_usage$ (ob...
29npwaz6dqsva0.093.490.000.04-0.0911616162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
djunbuupchm4s  0.020.050.02 180 180  LOCK TABLE event_info IN EXCLU...
9zzuyxx4pjhsx  0.000.060.00 28 28/ 1/ 1 select p_obj#, flags, code, au...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Sharable Memory

 % Total Sharable Memory Sharable Memory Used Sharable Memory Max #Executions  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2ndSQL Text
a32bhg8ny1y4u  0.110.110.11 1,051,615 1,051,615 1 select * from dba_tab_statisti...
7z7x3166pt4km  0.090.200.09 933,261 933,261 1 SELECT 'SCHEMA' type, username...
avv5dcc9zx2qb  0.090.290.09 897,641 897,641 1 SELECT 'SCHEMA' type, username...
fuyrx4r46bgxw0.050.05  -0.05500,666 500,666 1  select capture_name streams_n...
4x866jn4mj1uy0.030.08  -0.03291,804 291,804 1  SELECT PROPAGATION_NAME, MESS...
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...
b4mrsfc9ttham  0.020.310.02 221,420 221,420 40 WITH snaps as (SELECT :1 dbid,...
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...
9zzuyxx4pjhsx  0.020.330.02 166,287 166,287 28 select p_obj#, flags, code, au...
bzgpy0vxtvf630.020.180.010.34-0.01164,750111,590164,750111,5904040 SELECT event#, sql_id, sql_pla...
8gt45jpvt1ywh0.020.200.020.370.01180,427237,811180,427237,811910 INSERT INTO mn_hist_task (ver_...
29npwaz6dqsva0.030.230.030.390.00261,642288,138261,642288,1381616 SELECT CONFIG_VALUE_ID, CONFIG...
6wm3n4d7bnddg0.030.260.030.42-0.00287,722287,826287,722287,82611 SELECT source, (case when tim...
5hk2758bxufj00.010.270.010.44-0.00137,490137,490137,490137,490468936 SELECT column_name, nullable, ...
7k6zct1sya5300.010.290.010.45-0.00134,701134,701134,701134,70111 insert into WRH$_STREAMS_APPLY...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
9zzuyxx4pjhsx 2929 29 28 select p_obj#, flags, code, au...
b3zgx1xckrwxu 1010 10 9 select host, userid, password,...
0v3dvmc22qnam4 -44 8  insert into sys.col_usage$ (ob...
5rygsj4dbw6jt 44 4 105 insert into sys.mon_mods$ (obj...
29npwaz6dqsva2022220221616 SELECT CONFIG_VALUE_ID, CONFIG...
0k8522rmdzg4k330334644 select privilege# from sysauth...
36ya4s1zjwx1h440444644 SELECT COUNT(*) FROM STATS$USE...
3ktacv9r56b5144044108143 select owner#, name, namespace...
5ur69atw3vfhj440444644 select decode(failover_method,...
7ng34ruy5awxq5505540444 select i.obj#, i.ts#, i.file#,...
83taa7kaw59c15505580714 select name, intcol#, segcol#,...
8gt45jpvt1ywh55055910 INSERT INTO mn_hist_task (ver_...
9gkq7rruycsjp4404415 select parttype, partcnt, part...


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
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.0046441/ 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.0046441/ 1/ 1 select SYS_CONTEXT('USERENV', ...
1att0guk2skhm0.000.00  0.000.00 0.00 1 1// 1 select lobtsn, lobrdba, lobobj...
1cq3qr774cu450.000.000.000.000.000.000.000.000.00111/ 1/ 1 insert into WRH$_IOSTAT_FILETY...
1qntcw2s31n150.000.00  0.000.00 0.00 1 1// 1 select * from dba_hist_baselin...
29npwaz6dqsva0.000.000.000.000.000.000.000.000.0016162/ 2/ 2 SELECT CONFIG_VALUE_ID, CONFIG...
2q93zsrvbdw48  0.000.000.00 0.00 0.00 624/ 1/ 1 select grantee#, privilege#, n...
2xrc1gttayzmy0.000.000.000.000.000.000.000.000.00111/ 1/ 1 SELECT /*+ ORDERED USE_MERGE(...
317v5hnvvd49h0.000.000.000.000.000.000.000.000.00111/ 1/ 1 UPDATE wrh$_seg_stat_obj ob S...
350myuyx0t1d60.000.000.000.000.000.000.000.000.00111/ 1/ 1 insert into wrh$_tablespace_st...
35hatv0pj8hw7  0.000.000.00 0.00 0.00 10/ 1/ 1 select decode(u.type#, 2, u.ex...
36ya4s1zjwx1h0.000.000.000.000.000.000.000.000.0046441/ 1/ 1 SELECT COUNT(*) FROM STATS$USE...


Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db block changes7,0825,504-22.2854.429.42-82.6911.799.16-22.319.706.06-37.53
execute count72,0001,025,6411,324.50553.221,755.87217.39119.881,706.821,323.7798.631,129.561,045.25
logons cumulative51510.000.390.09-76.920.080.080.000.070.06-14.29
opened cursors cumulative70,8531,025,3061,347.09544.411,755.29222.42117.971,706.261,346.3597.061,129.191,063.39
parse count (total)11,9211,002,3028,307.8791.601,715.911,773.2619.851,667.988,302.9216.331,103.866,659.71
parse time elapsed56146,8158,244.924.3180.151,759.630.9377.918,277.420.7751.566,596.10
physical reads394,891411,3074.163,034.22704.15-76.79657.49684.484.11540.95452.98-16.26
physical writes6667045.715.121.21-76.371.111.175.410.910.78-14.29
redo size1,838,1401,655,872-9.9214,123.682,834.80-79.933,060.502,755.62-9.962,518.001,823.65-27.58
session cursor cache hits59,32523,306-60.71455.8339.90-91.2598.7838.78-60.7481.2725.67-68.41
session logical reads654,240701,0067.155,026.971,200.10-76.131,089.311,166.587.09896.22772.03-13.86
user calls11,40528,905153.4487.6349.48-43.5418.9948.10153.2915.6231.83103.78
user commits1381412.171.060.24-77.360.230.230.000.190.16-15.79
user rollbacks59276729.564.551.31-71.210.991.2829.290.810.843.70
workarea executions - optimal2,2815,851156.5117.5310.02-42.843.809.74156.323.126.44106.41


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 referenced111536.360.080.03-62.500.020.020.000.020.020.00
CPU used by this session2,14453,5072,395.6616.4791.60456.163.5789.042,394.122.9458.931,904.42
CPU used when call started1,8341,294-29.4414.092.22-84.243.052.15-29.512.511.43-43.03
CR blocks created73-57.140.050.01-80.000.010.00-100.000.010.00-100.00
Cached Commit SCN referenced18,70518,703-0.01143.7232.02-77.7231.1431.12-0.0625.6220.60-19.59
Commit SCN cached85-37.500.060.01-83.330.010.010.000.010.010.00
DBWR checkpoint buffers written643531-17.424.940.91-81.581.070.88-17.760.880.58-34.09
DBWR transaction table writes2116-23.810.160.03-81.250.030.030.000.030.02-33.33
DBWR undo block writes1141194.390.880.20-77.270.190.205.260.160.13-18.75
HSC Heap Segment Block Changes1,7581,101-37.3713.511.88-86.082.931.83-37.542.411.21-49.79
Heap Segment Array Inserts110106-3.640.850.18-78.820.180.180.000.150.12-20.00
Heap Segment Array Updates6157-6.560.470.10-78.720.100.09-10.000.080.06-25.00
IMU Flushes510100.000.040.02-50.000.010.02100.000.010.010.00
IMU Redo allocation size65,82461,204-7.02505.77104.78-79.28109.60101.85-7.0790.1767.41-25.24
IMU commits133131-1.501.020.22-78.430.220.220.000.180.14-22.22
IMU undo allocation size245,424198,744-19.021,885.76340.24-81.96408.63330.74-19.06336.20218.88-34.90
Number of read IOs issued6,2946,6525.6948.3611.39-76.4510.4811.075.638.627.33-14.97
Requests to/from client9,39026,285179.9372.1545.00-37.6315.6343.74179.8512.8628.95125.12
RowCR attempts110.000.010.00-100.000.000.000.000.000.000.00
RowCR hits110.000.010.00-100.000.000.000.000.000.000.00
SMON posted for dropping temp segment110.000.010.00-100.000.000.000.000.000.000.00
SQL*Net roundtrips to/from client9,38826,285179.9972.1345.00-37.6115.6343.74179.8512.8628.95125.12
TBS Extension: tasks created12100.000.010.00-100.000.000.000.000.000.000.00
TBS Extension: tasks executed12100.000.010.00-100.000.000.000.000.000.000.00
active txn count during cleanout6754-19.400.510.09-82.350.110.09-18.180.090.06-33.33
background timeouts3,3943,3990.1526.085.82-77.685.655.660.184.653.74-19.57
buffer is not pinned count143,484161,63212.651,102.49276.71-74.90238.90268.9812.59196.55178.01-9.43
buffer is pinned count286,367433,95251.542,200.35742.91-66.24476.80722.1651.46392.28477.9221.83
bytes received via SQL*Net from client1,223,2011,545,46226.359,398.682,645.79-71.852,036.632,571.8826.281,675.621,702.051.58
bytes sent via SQL*Net to client7,038,9989,625,14736.7454,085.4016,477.97-69.5311,719.9216,017.6736.679,642.4610,600.389.93
calls to get snapshot scn: kcmgss74,2361,025,8731,281.91570.411,756.26207.89123.601,707.201,281.23101.691,129.821,011.04
calls to kcmgas8,678638-92.6566.681.09-98.3714.451.06-92.6611.890.70-94.11
calls to kcmgcs9,2041,815-80.2870.723.11-95.6015.323.02-80.2912.612.00-84.14
cell physical IO interconnect bytes3,275,323,3923,408,162,3044.0625,166,534.855,834,673.54-76.825,453,409.825,671,687.354.004,486,744.373,753,482.71-16.34
change write time127-41.670.090.01-88.890.020.01-50.000.020.01-50.00
cleanout - number of ktugct calls10612114.150.810.21-74.070.180.2011.110.150.13-13.33
cleanouts only - consistent read gets416660.980.320.11-65.630.070.1157.140.060.0716.67
cluster key scan block gets62,04298,43158.65476.71168.51-64.65103.30163.8058.5784.99108.4027.54
cluster key scans29,37630,6084.19225.7252.40-76.7948.9150.944.1540.2433.71-16.23
commit cleanout failures: callback failure1413-7.140.110.02-81.820.020.020.000.020.01-50.00
commit cleanout failures: cannot pin330.000.020.01-50.000.000.000.000.000.000.00
commit cleanouts1,210950-21.499.301.63-82.472.011.58-21.391.661.05-36.75
commit cleanouts successfully completed1,189934-21.459.141.60-82.491.981.55-21.721.631.03-36.81
commit txn count during cleanout11317958.410.870.31-64.370.190.3057.890.150.2033.33
consistent changes7616-78.950.580.03-94.830.130.03-76.920.100.02-80.00
consistent gets646,963694,8267.404,971.061,189.52-76.071,077.191,156.297.34886.25765.23-13.66
consistent gets - examination129,90943,052-66.86998.1873.70-92.62216.3071.64-66.88177.9647.41-73.36
consistent gets direct386,509409,2075.872,969.81700.55-76.41643.54680.985.82529.46450.67-14.88
consistent gets from cache260,454285,6199.662,001.25488.97-75.57433.66475.319.60356.79314.56-11.84
consistent gets from cache (fastpath)120,748237,28596.51927.79406.22-56.22201.05394.8896.41165.41261.3357.99
cursor authentications2,8418,092184.8321.8313.85-36.564.7313.47184.783.898.91129.05
data blocks consistent reads - undo records applied163-81.250.120.01-91.670.030.00-100.000.020.00-100.00
db block gets7,2776,180-15.0755.9110.58-81.0812.1210.28-15.189.976.81-31.70
db block gets direct71157.140.050.02-60.000.010.02100.000.010.010.00
db block gets from cache7,2706,169-15.1455.8610.56-81.1012.1010.27-15.129.966.79-31.83
db block gets from cache (fastpath)1,5841,477-6.7612.172.53-79.212.642.46-6.822.171.63-24.88
deferred (CURRENT) block cleanout applications695556-20.005.340.95-82.211.160.93-19.830.950.61-35.79
enqueue conversions28300.000.020.01-50.000.000.01100.000.000.01100.00
enqueue releases59,767991,7821,559.41459.231,697.90269.7399.511,650.471,558.6081.871,092.271,234.15
enqueue requests59,769991,7851,559.36459.251,697.91269.7199.521,650.481,558.4481.881,092.271,233.99
enqueue timeouts330.000.020.01-50.000.000.000.000.000.000.00
file io service time39,1712,441-93.77300.984.18-98.6165.224.06-93.7753.662.69-94.99
free buffer inspected8,2021,167-85.7763.022.00-96.8313.661.94-85.8011.241.29-88.52
free buffer requested8,4022,229-73.4764.563.82-94.0813.993.71-73.4811.512.45-78.71
heap block compress1714-17.650.130.02-84.620.030.02-33.330.020.020.00
hot buffers moved to head of LRU1,107170-84.648.510.29-96.591.840.28-84.781.520.19-87.50
immediate (CR) block cleanout applications456646.670.350.11-68.570.070.1157.140.060.0716.67
immediate (CURRENT) block cleanout applications728011.110.550.14-74.550.120.138.330.100.09-10.00
index crx upgrade (positioned)5444-18.520.410.08-80.490.090.07-22.220.070.05-28.57
index fetch by key132,35015,277-88.461,016.9326.15-97.43220.3625.42-88.46181.3016.82-90.72
index scans kdiixs130,06364,774115.46230.99110.89-51.9950.05107.79115.3641.1871.3473.24
java call heap collected bytes391,784783,568100.003,010.341,341.45-55.44652.321,303.9799.90536.69862.9660.79
java call heap collected count4,8629,724100.0037.3616.65-55.438.1016.1899.756.6610.7160.81
java call heap gc count24100.000.020.01-50.000.000.01100.000.000.000.00
java call heap live object count3,7197,438100.0028.5812.73-55.466.1912.38100.005.098.1960.90
java call heap live object count max3,7197,438100.0028.5812.73-55.466.1912.38100.005.098.1960.90
java call heap live size264,632529,264100.002,033.35906.08-55.44440.61880.7799.90362.51582.8960.79
java call heap live size max264,632529,264100.002,033.35906.08-55.44440.61880.7799.90362.51582.8960.79
java call heap object count7,87515,750100.0060.5126.96-55.4513.1126.2199.9210.7917.3560.80
java call heap object count max7,87515,750100.0060.5126.96-55.4513.1126.2199.9210.7917.3560.80
java call heap total size1,310,7202,621,440100.0010,071.154,487.83-55.442,182.354,362.4699.901,795.512,887.0560.79
java call heap total size max1,310,7202,621,440100.0010,071.154,487.83-55.442,182.354,362.4699.901,795.512,887.0560.79
java call heap used size564,5121,129,024100.004,337.531,932.86-55.44939.911,878.8699.90773.301,243.4260.79
java call heap used size max564,5121,129,024100.004,337.531,932.86-55.44939.911,878.8699.90773.301,243.4260.79
java session heap live size421,888843,776100.003,241.651,444.52-55.44702.441,404.1799.90577.93929.2760.79
java session heap live size max421,888843,776100.003,241.651,444.52-55.44702.441,404.1799.90577.93929.2760.79
java session heap used size421,888843,776100.003,241.651,444.52-55.44702.441,404.1799.90577.93929.2760.79
java session heap used size max421,888843,776100.003,241.651,444.52-55.44702.441,404.1799.90577.93929.2760.79
leaf node 90-10 splits14140.000.110.02-81.820.020.020.000.020.020.00
leaf node splits212414.290.160.04-75.000.030.0433.330.030.030.00
lob reads1721741.161.320.30-77.270.290.290.000.240.19-20.83
lob writes118-27.270.080.01-87.500.020.01-50.000.020.01-50.00
lob writes unaligned118-27.270.080.01-87.500.020.01-50.000.020.01-50.00
logical read bytes from cache2,193,195,0082,390,327,2968.9916,851,807.294,092,169.97-75.723,651,667.263,977,859.008.933,004,376.722,632,519.05-12.38
messages received906737-18.656.961.26-81.901.511.23-18.541.240.81-34.68
messages sent906737-18.656.961.26-81.901.511.23-18.541.240.81-34.68
min active SCN optimization applied on CR3428-17.650.260.05-80.770.060.05-16.670.050.03-40.00
no work - consistent read gets505,324645,78527.803,882.751,105.56-71.53841.361,074.6827.73692.22711.222.74
non-idle wait count27,52438,04838.24211.4965.14-69.2045.8363.3238.1637.7041.9011.14
parse count (failures)210400.000.020.020.000.000.02100.000.000.01100.00
parse count (hard)6,624989,29314,834.9850.901,693.643,227.3911.031,646.3314,825.939.071,089.5311,912.46
parse time cpu51946,3688,834.103.9979.381,889.470.8677.168,872.090.7151.077,092.96
physical read IO requests14,4538,470-41.40111.0514.50-86.9424.0614.10-41.4019.809.33-52.88
physical read bytes3,234,947,0723,369,426,9444.1624,856,296.165,768,359.74-76.795,386,183.295,607,225.974.104,431,434.353,710,822.63-16.26
physical read total IO requests16,1089,964-38.14123.7717.06-86.2226.8216.58-38.1822.0710.97-50.29
physical read total bytes3,260,743,6803,393,601,5364.0725,054,509.025,809,745.93-76.815,429,134.625,647,456.084.024,466,772.163,737,446.63-16.33
physical read total multi block requests6,0606,4165.8746.5610.98-76.4210.0910.685.858.307.07-14.82
physical reads cache8,1582,002-75.4662.683.43-94.5313.583.33-75.4811.182.20-80.32
physical reads cache prefetch118418,300.000.010.323,100.000.000.31100.000.000.20100.00
physical reads direct386,733409,3055.842,971.53700.72-76.42643.91681.145.78529.77450.78-14.91
physical reads direct (lob)5005040.803.840.86-77.600.830.841.200.680.56-17.65
physical write IO requests4594681.963.530.80-77.340.760.782.630.630.52-17.46
physical write bytes5,455,8725,767,1685.7141,921.179,873.22-76.459,084.029,597.425.657,473.806,351.51-15.02
physical write total IO requests1,3821,125-18.6010.621.93-81.832.301.87-18.701.891.24-34.39
physical write total bytes14,579,71214,560,768-0.13112,025.8324,927.61-77.7524,275.2024,231.28-0.1819,972.2116,036.09-19.71
physical write total multi block requests98-11.110.070.01-85.710.010.010.000.010.010.00
physical writes direct71157.140.050.02-60.000.010.02100.000.010.010.00
physical writes direct (lob)71157.140.050.02-60.000.010.02100.000.010.010.00
physical writes from cache6596935.165.061.19-76.481.101.154.550.900.76-15.56
physical writes non checkpoint327317-3.062.510.54-78.490.540.53-1.850.450.35-22.22
recursive calls122,1984,088,2603,245.60938.936,998.98645.42203.466,803.473,243.89167.394,502.492,589.82
recursive cpu usage1,01850,0684,818.277.8285.71996.041.6983.324,830.181.3955.143,866.91
redo blocks checksummed by FG (exclusive)1,6351,7346.0612.562.97-76.352.722.896.252.241.91-14.73
redo blocks written4,0603,607-11.1631.206.18-80.196.766.00-11.245.563.97-28.60
redo entries3,7443,055-18.4028.775.23-81.826.235.08-18.465.133.36-34.50
redo ordering marks9891-7.140.750.16-78.670.160.15-6.250.130.10-23.08
redo size for direct writes36457257.142.800.98-65.000.610.9555.740.500.6326.00
redo subscn max counts2162275.091.660.39-76.510.360.385.560.300.25-16.67
redo synch time935288.890.070.06-14.290.010.06500.000.010.04300.00
redo synch time (usec)156,344394,581152.381,201.30675.51-43.77260.31656.64152.25214.17434.56102.90
redo synch writes1311449.921.010.25-75.250.220.249.090.180.16-11.11
redo wastage133,55669,616-47.881,026.20119.18-88.39222.37115.85-47.90182.9576.67-58.09
redo write time546316.670.410.11-73.170.090.1011.110.070.070.00
redo writes489230-52.973.760.39-89.630.810.38-53.090.670.25-62.69
rollbacks only - consistent read gets53-40.000.040.01-75.000.010.00-100.000.010.00-100.00
rows fetched via callback3,3922,046-39.6826.063.50-86.575.653.40-39.824.652.25-51.61
session uga memory2,296,5362,571,23211.9617,645.854,401.87-75.053,823.734,278.9111.903,145.942,831.75-9.99
session uga memory max72,519,62479,158,8089.16557,217.54135,517.55-75.68120,745.09131,731.999.1099,341.9587,179.30-12.24
shared hash latch upgrades - no wait1,8863,875105.4614.496.63-54.243.146.45105.412.584.2765.50
sorts (memory)3,2919,430186.5425.2916.14-36.185.4815.69186.314.5110.39130.38
sorts (rows)116,610318,461173.10895.99545.20-39.15194.16529.97172.96159.74350.73119.56
sql area purged210400.000.020.020.000.000.02100.000.000.01100.00
switch current to new buffer10096-4.000.770.16-79.220.170.16-5.880.140.11-21.43
table fetch by rowid126,359234,67285.72970.90401.75-58.62210.39390.5385.62173.09258.4549.32
table fetch continued row186120-35.481.430.21-85.310.310.20-35.480.250.13-48.00
table scan blocks gotten399,778471,89418.043,071.77807.87-73.70665.63785.3017.98547.64519.71-5.10
table scan rows gotten4,910,3448,002,37962.9737,729.5113,699.84-63.698,175.7213,317.1562.896,726.508,813.1931.02
table scans (cache partitions)220.000.020.00-100.000.000.000.000.000.000.00
table scans (direct read)550.000.040.01-75.000.010.010.000.010.010.00
table scans (long tables)3433.330.020.01-50.000.000.01100.000.000.000.00
table scans (short tables)64072813.754.921.25-74.591.071.2113.080.880.80-9.09
total cf enq hold time8040-50.000.610.07-88.520.130.07-46.150.110.04-63.64
total number of cf enq holders550.000.040.01-75.000.010.010.000.010.010.00
total number of times SMON posted5740.000.040.01-75.000.010.010.000.010.010.00
undo change vector size581,688527,184-9.374,469.50902.52-79.81968.51877.31-9.42796.83580.60-27.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.325.391.320.100.03-70.005.175.322.900.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.1016.59-38.7813.563.03-77.6510.7611.072.882.301.88-18.260.750.761.330.010.02100.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.335.391.135.295.351.130.000.000.000.020.020.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.1216.59-38.8324.4214.17-41.970.000.000.002.301.88-18.260.760.782.630.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_DATA1 13.140.39-97.030.000.000.007,8892368.780.001.032.1400000.000.0013.140.39-12.74
MN_DATA11 0.011.7016,900.000.020.020.0041,0197.503.711.001.181012000.000.000.021.721.69
MN_DATA_LARGE1 10.0010.787.800.020.0350.006,0076,4770.020.1363.5863.131419000.000.0010.0210.810.79
SYSTEM 0.110.59436.360.050.10100.00663558.6411.861.001.003362340.002.500.160.690.53
MN_IDX1 0.300.00-100.000.000.000.0018208.570.001.000.0000000.000.000.300.00-0.30
SYSAUX 0.400.39-2.500.550.51-7.272382329.8710.821.001.00328308000.000.000.940.90-0.04


Back to IO Stats
Back to Top

Top File Comparison by IO

  Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
TablespaceFilename1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
MN_DATA1/ora_prismaqa/data/prismaqa/mndata09.dbf 1.160.00-100.000.000.000.0069808.800.001.000.0000000.000.001.160.00-1.16
MN_DATA1/ora_prismaqa/data/prismaqa/mndata13.dbf 0.860.00-100.000.000.000.00515012.120.001.000.0000000.000.000.860.00-0.86
MN_DATA1/ora_prismaqa/data/prismaqa/mndata12.dbf 0.700.00-100.000.000.000.00418010.620.001.000.0000000.000.000.700.00-0.70
MN_DATA1/ora_prismaqa/data/prismaqa/mndata11.dbf 0.590.00-100.000.000.000.00352011.420.001.000.0000000.000.000.590.00-0.59
MN_DATA1/ora_prismaqa/data/prismaqa/mndata10.dbf 0.530.00-100.000.000.000.0031809.910.001.000.0000000.000.000.530.00-0.53
MN_DATA1/ora_prismaqa/data/prismaqa/mndata08.dbf 0.390.00-100.000.000.000.0023209.140.001.000.0000000.000.000.390.00-0.39
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_DATA1/ora_prismaqa/data/prismaqa/mndata02.dbf 10.290.00-10.297.510.001,7821562.970.261.092.08000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata09.dbf 4.720.00-4.728.800.0069801.160.001.000.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata04.dbf 4.380.00-4.388.010.00712101.190.021.032.80000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata01.dbf 4.340.00-4.347.870.00718141.200.021.022.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata05.dbf 4.190.00-4.199.020.0060461.010.011.023.33000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata03.dbf 3.480.00-3.488.530.00531120.880.021.022.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata07.dbf 2.990.00-2.998.840.0044040.730.011.023.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata06.dbf 2.980.00-2.987.590.00511340.850.061.072.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata10.dbf 2.420.00-2.429.910.0031800.530.001.000.00000.000.00000.000.00
MN_DATA1/ora_prismaqa/data/prismaqa/mndata08.dbf 1.630.00-1.639.140.0023200.390.001.000.00000.000.00000.000.00
MN_DATA11/ora_prismaqa/data/prismaqa/mn_data11_01.dbf 0.000.280.280.004.1403910.000.650.001.16650.010.01000.000.00
MN_DATA_LARGE1/ora_prismaqa/data/prismaqa/mn_data_large1_04.dbf 0.000.070.070.000.943684140.610.6963.6559.11000.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   
           
B2073451,211636,5501,492,992636,550   
E207261705629,2211,492,992629,221   


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,448198,348-71.7287110000.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,024713331.60.80.3100.00.0104,850
E21,024715334.70.80.3100.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.01340.000.03100.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
2nd8.848921,080323/330/00/0/0/0/0/0



Back to Top

Latch Statistics

Back to Top

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Wait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool0.0097.9097.90348,33445,357,48814,35814,220014002,3842,384
space background task latch0.003.503.501,6151,86722372232050140140


Back to Latch Statistics
Back to Top

Latch Wait Time Breakdown

 Wait Time (cs) Get Requests Misses Spin Gets Sleeps % of Total Sleeps
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool02,3842,384348,33445,357,48814,35814,22001400.0097.9097.90
space background task latch01401401,6151,86722372232050.003.503.50


Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Top Segments Comparison by Logical Reads

     % of Total Logical Reads Logical Reads % of Captured Logical Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMI_FILE#_BLOCK# INDEX16.4716.470.180.18-16.29107,7441,248-98.8417.600.19-17.42
SYSSYSTEMIND$ TABLE  13.6113.7913.61 95,424  14.2514.25
SYSSYSTEMCOL$ TABLE6.8823.35  -6.8845,040  7.36 -7.36
DATALOADMN_DATA11PRO_USER TABLE  5.5219.315.52 38,704  5.785.78
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE6.6830.0410.7530.064.0643,72875,32872.267.1411.254.10
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE34.9564.9932.6262.68-2.33228,688228,6880.0037.3734.14-3.22
DATALOADMN_DATA_LARGE1QUOTE TABLE11.8476.8311.0573.73-0.7977,45677,4560.0012.6611.56-1.09


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_LARGE1MN_MEMBER TABLE11.0911.0918.3118.317.2143,81275,30871.8911.6118.366.75
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE57.9169.0155.6073.91-2.31228,685228,6850.0060.5955.74-4.85
DATALOADMN_DATA_LARGE1QUOTE TABLE19.6188.6118.8392.74-0.7877,43477,4340.0020.5218.88-1.64
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE6.9395.556.6699.39-0.2827,37427,3740.007.256.67-0.58
DATALOADMN_DATA11PRO_USER TABLE  0.2599.640.25 1,009  0.250.25
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_LARGE1QUOTE_ITEM TABLE24.8024.8042.3142.3117.523,5843,5840.0059.5246.69-12.83
DATALOADMN_DATA11PRO_USER TABLE  9.9352.249.93 841  10.9610.96
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE4.7729.5713.9866.229.206901,18471.5911.4615.423.96
DATALOADMN_DATA_LARGE1QUOTE TABLE8.4137.9914.3680.585.941,2161,2160.0020.2015.84-4.35
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE2.9940.975.1085.682.114324320.007.175.63-1.55
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.3141.29  -0.3145  0.75 -0.75


Back to Segment Statistics
Back to Top

Top Segments Comparison by UnOptimized Read Requests

     % of Total UnOptimized Requests UnOptimized Requests % of Captured UnOptimized Reqs
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE24.8024.8042.3142.3117.523,5843,5840.0059.5246.69-12.83
DATALOADMN_DATA11PRO_USER TABLE  9.9352.249.93 841  10.9610.96
DATALOADMN_DATA_LARGE1MN_MEMBER TABLE4.7729.5713.9866.229.206901,18471.5911.4615.423.96
DATALOADMN_DATA_LARGE1QUOTE TABLE8.4137.9914.3680.585.941,2161,2160.0020.2015.84-4.35
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE2.9940.975.1085.682.114324320.007.175.63-1.55
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX0.3141.29  -0.3145  0.75 -0.75


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.00  0.000 100.000.00 0.00
SYSSYSTEMIND$ 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_LARGE1MN_MEMBER TABLE11.3311.3318.4018.407.0743,81275,30871.8911.6118.426.81
DATALOADMN_DATA_LARGE1QUOTE_ITEM TABLE59.1370.4655.8774.27-3.26228,685228,6850.0060.6155.94-4.67
DATALOADMN_DATA_LARGE1QUOTE TABLE20.0290.4818.9293.19-1.1077,43477,4340.0020.5218.94-1.58
DATALOADMN_DATA_LARGE1MN_HT_CONTRACT TABLE7.0897.566.6999.88-0.3927,37427,3740.007.266.70-0.56
SYSSYSTEMCOL$ TABLE0.0097.56  0.000 100.000.00 0.00
SYSSYSTEMIND$ TABLE  0.0099.880.00 0  0.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$_SYSSTAT_PKWRH$_SYSSTA_3673847771_13254INDEX PARTITION2.102.10  -2.1014  9.86 -9.86
SYSSYSAUXWRH$_PARAMETER_PKWRH$_PARAME_3673847771_13254INDEX PARTITION  1.991.991.99 14  7.537.53
SYSSYSAUXWRH$_SYSTEM_EVENT_PKWRH$_SYSTEM_3673847771_13254INDEX PARTITION1.954.05  -1.9513  9.15 -9.15
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_3673847771_13254INDEX PARTITION  1.853.841.85 13  6.996.99
SYSSYSAUXWRH$_ROWCACHE_SUMMARY_PKWRH$_ROWCAC_3673847771_13254INDEX PARTITION  1.855.681.85 13  6.996.99
SYSSYSAUXWRH$_SQL_PLAN TABLE2.856.911.286.96-1.57199-52.6313.384.84-8.54
SYSSYSAUXWRH$_PARAMETERWRH$_PARAME_3673847771_13254TABLE PARTITION2.109.010.577.53-1.53144-71.439.862.15-7.71
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX1.5010.51  -1.5010  7.04 -7.04
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__3673847771_13254TABLE PARTITION0.6011.111.859.381.25413225.002.826.994.17
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB1.2012.311.7011.080.5081250.005.636.450.82


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.921.92-2.22199-52.6319.398.18-11.21
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX2.186.32  -2.1810  10.20 -10.20
DATALOADMN_DATA_LARGE1MN_HIST_QUERY_USAGE TABLE  1.283.211.28 6  5.455.45
SYSSYSAUXWRH$_PARAMETER_PKWRH$_PARAME_3673847771_13254INDEX PARTITION  1.074.271.07 5  4.554.55
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB1.748.062.566.840.8281250.008.1610.912.75
DATALOADMN_DATA_LARGE1MN_HIST_TASK TABLE1.9610.022.569.400.6091233.339.1810.911.73
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE1.0911.110.6410.04-0.4553-40.005.102.73-2.37


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
SYSSYSTEMCOL$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMIND$ 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
SYSSYSTEMSEG$ TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB100.00100.00100.00100.000.0071157.14100.00100.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
YJAQUIERUSERSTEST1 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.00  0.000 100.000.00 0.00
SYSSYSTEMIND$ TABLE  0.00100.000.00 0  0.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
SYSSYSAUXWRM$_SNAPSHOT_DETAILS TABLE1.135.20  -1.1380  7.46 -7.46
SYSSYSAUXWRH$_LATCH_PKWRH$_LATCH_3673847771_13254INDEX PARTITION  0.870.870.87 48  6.386.38
SYSSYSAUXWRH$_SERVICE_WAIT_CLASS_PKWRH$_SERVIC_3673847771_13254INDEX PARTITION  0.871.740.87 48  6.386.38
SYSSYSAUXWRH$_SQLSTATWRH$_SQLSTA_3673847771_13254TABLE PARTITION0.685.870.001.74-0.68480-100.004.480.00-4.48
SYSSYSAUXWRH$_SQLSTAT_PKWRH$_SQLSTA_3673847771_13254INDEX PARTITION0.236.100.872.620.651648200.001.496.384.89
SYSSYSTEMSEG$ TABLE0.907.001.163.780.2664640.005.978.512.54
SYSSYSAUXWRH$_SQL_PLAN TABLE4.7411.754.658.43-0.09336256-23.8131.3434.042.70


Back to Segment Statistics
Back to Top

Top Segments by Row Lock Waits

     % of Total Row Lock Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd%Diff1st1st Total2nd2nd TotalDiff
SYSSYSAUXWRH$_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.00100.00100.000.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.02-80.000.020.020.0013130.000.00000.000.002211
dc_files0.280.00-100.000.060.00-100.00370100.000.00000.000.00003737
dc_free_extents0.670.10-85.070.140.10-28.57876014.946.67620.000.0031104948
dc_global_oids1.380.10-92.750.300.10-66.671806011.113.33000.000.00003738
dc_histogram_data39.4511.48-70.908.5511.1630.535,1346,70813.1936.99000.000.00001,9981,390
dc_histogram_defs184.053,406.431,750.8239.883,311.278,203.0823,9531,989,7697.050.32000.000.00003,9581,803
dc_object_grants9.270.01-99.892.010.01-99.501,20673.980.00000.000.00005354
dc_objects99.521,706.741,614.9721.571,659.067,591.5212,952996,9432.980.05000.000.00001,5361,657
dc_profiles0.350.08-77.140.080.07-12.5046440.000.00000.000.000022
dc_rollback_segments4.080.77-81.130.880.75-14.775314520.000.00000.000.00006767
dc_segments162.075,080.473,034.7435.124,938.5513,961.9321,0932,967,6171.880.02000.000.0019141,083523
dc_sequences0.030.02-33.330.010.02100.00412100.00100.00000.000.0041280
dc_table_scns0.000.000.000.000.000.00020.00100.00000.000.000000
dc_tablespaces482.9310.05-97.92104.659.77-90.6662,8515,8690.000.00000.000.00001414
dc_used_extents0.090.01-88.890.020.01-50.0012450.0050.00000.000.0012400
dc_users206.483,395.661,544.5544.743,300.817,277.7626,8731,983,4820.000.00000.000.00006363
global database name3.610.83-77.010.780.813.854704840.000.00000.000.000011
outstanding_alerts0.080.02-75.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.15-78.870.150.150.0092880.0011.3600  0000
BODY0.220.04-81.820.050.04-20.00282510.710.00795913.920.007000
CLUSTER0.360.06-83.330.080.05-37.5047330.006.0647330.006.060000
DBLINK0.680.15-77.940.150.14-6.6788860.0010.4700  0000
EDITION0.510.13-74.510.110.1318.1867770.0036.361131210.0030.580100
INDEX0.140.00-100.000.030.00-100.0018066.67 18066.67 0000
JAVA DATA0.010.00-100.000.000.000.00120.000.0000  0000
QUEUE0.120.01-91.670.030.00-100.001630.000.001401270.000.000000
SCHEMA5.350.51-90.471.160.50-56.906962990.000.0000  0000
SQL AREA91.901,715.631,766.8419.911,667.708,276.1911,9601,002,13755.1896.9888,2572,998,96422.4098.693217,762210
SQL AREA BUILD50.671,694.273,243.7310.981,646.9414,899.456,595989,66199.4599.9400  0000
SQL AREA STATS50.631,692.733,243.3310.971,645.4414,899.456,589988,75999.6799.056,589988,75999.6799.050100
TABLE/PROCEDURE159.821,734.91985.5434.631,686.444,769.8820,8001,013,3981.620.0238,5063,003,9832.440.08492,06000
TRIGGER0.350.08-77.140.080.07-12.5046440.0020.4546440.0020.450000



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.8846,144.0050,368.009.15-1.1011.16
Used (KB)0.000.000.000.000.000.000.000.00
Avg Alloc (KB)1,085.021,053.77-2.881,073.121,144.736.67-1.108.63
Std Dev Alloc (KB)783.21887.9513.37895.55965.227.7814.348.70
Max Alloc (KB)4,544.004,736.000.004,544.004,736.004.230.004.23
Hist Max Alloc (KB)        
Num Procs43.0043.000.0043.0044.002.330.002.33
Num Alloc43.0043.000.0043.0044.002.330.002.33
JAVAAlloc (KB)2,421.92       
Used (KB)2,413.39       
Avg Alloc (KB)2,421.92       
Std Dev Alloc (KB)0.00 100.00   100.00 
Max Alloc (KB)2,421.92       
Hist Max Alloc (KB)2,954.10       
Num Procs1.00       
Num Alloc1.00       
OtherAlloc (KB)289,547.41281,038.95-2.94282,257.71281,009.93-0.44-2.52-0.01
Used (KB)        
Avg Alloc (KB)1,765.531,734.81-1.741,742.331,734.63-0.44-1.31-0.01
Std Dev Alloc (KB)2,066.422,056.13-0.502,062.492,052.53-0.48-0.19-0.17
Max Alloc (KB)17,471.0817,494.030.0017,565.0817,494.03-0.400.540.13
Hist Max Alloc (KB)23,128.6323,128.630.0023,128.6323,128.630.000.000.00
Num Procs164.00162.00-1.22162.00162.000.00-1.220.00
Num Alloc164.00162.00-1.22162.00162.000.00-1.220.00
PL/SQLAlloc (KB)8,654.058,617.15-0.438,763.118,757.41-0.071.261.63
Used (KB)6,462.576,428.09-0.536,558.626,555.87-0.041.491.99
Avg Alloc (KB)52.7753.190.8054.0954.06-0.072.511.63
Std Dev Alloc (KB)241.17242.600.59242.79242.75-0.010.670.06
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.00162.000.00-1.220.00
Num Alloc164.00162.00-1.22162.00162.000.00-1.220.00
SQLAlloc (KB)3,012.863,729.3923.782,486.802,730.329.79-17.46-26.79
Used (KB)739.551,811.77144.98691.70717.053.66-6.47-60.42
Avg Alloc (KB)20.0925.2025.4616.8018.329.06-16.34-27.28
Std Dev Alloc (KB)50.98101.8799.8047.8348.210.79-6.19-52.68
Max Alloc (KB)471.96471.96133.62471.96471.960.000.00-57.19
Hist Max Alloc (KB)119,575.72119,575.720.00119,575.72119,575.720.000.000.00
Num Procs150.00148.00-1.33148.00149.000.68-1.330.68
Num Alloc142.00141.00-0.70141.00142.000.71-0.700.71


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.00737,280.00704,512.00-4.440.00-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,327,106.201,359,874.202.470.002.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,208,128-0.150.00-0.15
java poolfree memory142,914,880142,914,8800.00142,914,880142,951,1680.030.000.03
large poolPX msg pool8,192,0008,192,0000.008,192,0008,192,0000.000.000.00
large poolfree memory209,911,808209,911,8080.00209,911,808209,911,8080.000.000.00
shared poolASH buffers42,949,67242,949,6720.0042,949,67242,949,6720.000.000.00
shared poolCheckpoint queue33,570,81633,570,8160.0033,570,81633,570,8160.000.000.00
shared poolFileOpenBlock15,937,34415,937,3440.0015,937,34415,937,3440.000.000.00
shared poolKGLDA    13,054,616   
shared poolKGLH017,062,89698,626,088478.01101,881,432248,708,888144.12497.09152.17
shared poolKGLHD 15,609,104 15,974,81638,726,264142.42 148.10
shared poolKGLS 13,726,344 14,830,568    
shared poolKTI-UNDO10,635,23210,635,2320.0010,635,23210,635,2320.000.000.00
shared poolSQLA13,353,02473,982,376454.0579,656,312136,386,28071.22496.5484.35
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.17356,215,464170,055,136-52.26-33.34-53.77
shared poolkglsim heap    11,003,264   
shared poolkglsim object batch15,873,31215,873,3120.0015,873,31219,045,65619.990.0019.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.00754,974,720721,420,288-4.440.00-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
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')
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)
1qntcw2s31n15select * from dba_hist_baseline
29npwaz6dqsvaSELECT CONFIG_VALUE_ID, CONFIG_ID, VALUE, DESCRIPTION, CLOB_VALUE, NODE_ID, OWNER, RELATED_ORG_ID FROM MN_CONFIGURATION_VALUE WHERE FEATURE = :1 AND INIT_CONFIGSET_VALUE = 1
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2xrc1gttayzmy SELECT /*+ ORDERED USE_MERGE(m) */ TO_CHAR( FROM_TZ( CAST(m.end_time AS TIMESTAMP), TO_CHAR(systimestamp, 'tzr') ) AT TIME ZONE sessiontimezone, 'YYYY-MM-DD HH24:MI:SS'), SUM(CASE WHEN a.internal_metric_name = 'transactions_ps' THEN m.value ELSE 0 END) transactions_ps, SUM(CASE WHEN a.internal_metric_name = 'physreads_ps' THEN m.value ELSE 0 END) physreads_ps, SUM(CASE WHEN a.internal_metric_name = 'physreads_pt' THEN m.value ELSE 0 END) physreads_pt, SUM(CASE WHEN a.internal_metric_name = 'physwrites_ps' THEN m.value ELSE 0 END) physwrites_ps, SUM(CASE WHEN a.internal_metric_name = 'physwrites_pt' THEN m.value ELSE 0 END) physwrites_pt, SUM(CASE WHEN a.internal_metric_name = 'physreadsdir_ps' THEN m.value ELSE 0 END) physreadsdir_ps, SUM(CASE WHEN a.internal_metric_name = 'physreadsdir_pt' THEN m.value ELSE 0 END) physreadsdir_pt, SUM(CASE WHEN a.internal_metric_name = 'physwritesdir_ps' THEN m.value ELSE 0 END) physwritesdir_ps, SUM(CASE WHEN a.internal_metric_name = 'physwritesdir_pt' THEN m.value ELSE 0 END) physwritesdir_pt, SUM(CASE WHEN a.internal_metric_name = 'physreadslob_ps' THEN m.value ELSE 0 END) physreadslob_ps, SUM(CASE WHEN a.internal_metric_name = 'physreadslob_pt' THEN m.value ELSE 0 END) physreadslob_pt, SUM(CASE WHEN a.internal_metric_name = 'physwriteslob_ps' THEN m.value ELSE 0 END) physwriteslob_ps, SUM(CASE WHEN a.internal_metric_name = 'physwriteslob_pt' THEN m.value ELSE 0 END) physwriteslob_pt, SUM(CASE WHEN a.internal_metric_name = 'redosize_ps' THEN m.value ELSE 0 END) redosize_ps, SUM(CASE WHEN a.internal_metric_name = 'logons_ps' THEN m.value ELSE 0 END) logons_ps, SUM(CASE WHEN a.internal_metric_name = 'logons_pt' THEN m.value ELSE 0 END) logons_pt, SUM(CASE WHEN a.internal_metric_name = 'opncurs_ps' THEN m.value ELSE 0 END) opncurs_ps, SUM(CASE WHEN a.internal_metric_name = 'opncurs_pt' THEN m.value ELSE 0 END) opncurs_pt, SUM(CASE WHEN a.internal_metric_name = 'commits_ps' THEN m.value ELSE 0 END) commits_ps, SUM(CASE WHEN a.internal_metric_name = 'commits_pt' THEN m.value ELSE 0 END) commits_pt, SUM(CASE WHEN a.internal_metric_name = 'rollbacks_ps' THEN m.value ELSE 0 END) rollbacks_ps, SUM(CASE WHEN a.internal_metric_name = 'rollbacks_pt' THEN m.value ELSE 0 END) rollbacks_pt, SUM(CASE WHEN a.internal_metric_name = 'usercalls_ps' THEN m.value ELSE 0 END) usercalls_ps, SUM(CASE WHEN a.internal_metric_name = 'usercalls_pt' THEN m.value ELSE 0 END) usercalls_pt, SUM(CASE WHEN a.internal_metric_name = 'recurscalls_ps' THEN m.value ELSE 0 END) recurscalls_ps, SUM(CASE WHEN a.internal_metric_name = 'recurscalls_pt' THEN m.value ELSE 0 END) recurscalls_pt, SUM(CASE WHEN a.internal_metric_name = 'logreads_ps' THEN m.value ELSE 0 END) logreads_ps, SUM(CASE WHEN a.internal_metric_name = 'logreads_pt' THEN m.value ELSE 0 END) logreads_pt, SUM(CASE WHEN a.internal_metric_name = 'dbwrcheckpoints_ps' THEN m.value ELSE 0 END) dbwrcheckpoints_ps, SUM(CASE WHEN a.internal_metric_name = 'bgcheckpoints_ps' THEN m.value ELSE 0 END) bgcheckpoints_ps, SUM(CASE WHEN a.internal_metric_name = 'redowrites_ps' THEN m.value ELSE 0 END) redowrites_ps, SUM(CASE WHEN a.internal_metric_name = 'redowrites_pt' THEN m.value ELSE 0 END) redowrites_pt, SUM(CASE WHEN a.internal_metric_name = 'tabscanslong_ps' THEN m.value ELSE 0 END) tabscanslong_ps, SUM(CASE WHEN a.internal_metric_name = 'tabscanslong_pt' THEN m.value ELSE 0 END) tabscanslong_pt, SUM(CASE WHEN a.internal_metric_name = 'tabscanstotal_ps' THEN m.value ELSE 0 END) tabscanstotal_ps, SUM(CASE WHEN a.internal_metric_name = 'tabscanstotal_pt' THEN m.value ELSE 0 END) tabscanstotal_pt, SUM(CASE WHEN a.internal_metric_name = 'indxscansfull_pt' THEN m.value ELSE 0 END) indxscansfull_pt, SUM(CASE WHEN a.internal_metric_name = 'indxscansfull_ps' THEN m.value ELSE 0 END) indxscansfull_ps, SUM(CASE WHEN a.internal_metric_name = 'indxscanstotal_ps' THEN m.value ELSE 0 END) indxscanstotal_ps, SUM(CASE WHEN a.internal_metric_name = ' indxscanstotal_pt' THEN m.value ELSE 0 END) indxscanstotal_pt, SUM(CASE WHEN a.internal_metric_name = 'parses_ps' THEN m.value ELSE 0 END) parses_ps, SUM(CASE WHEN a.internal_metric_name = 'parses_pt' THEN m.value ELSE 0 END) parses_pt, SUM(CASE WHEN a.internal_metric_name = 'hardparses_ps' THEN m.value ELSE 0 END) hardparses_ps, SUM(CASE WHEN a.internal_metric_name = 'hardparses_pt' THEN m.value ELSE 0 END) hardparses_pt, SUM(CASE WHEN a.internal_metric_name = 'failedparses_ps' THEN m.value ELSE 0 END) failedparses_ps, SUM(CASE WHEN a.internal_metric_name = 'failedparses_pt' THEN m.value ELSE 0 END) failedparses_pt, SUM(CASE WHEN a.internal_metric_name = 'executions_ps' THEN m.value ELSE 0 END) executions_ps, SUM(CASE WHEN a.internal_metric_name = 'sortsdisk_ps' THEN m.value ELSE 0 END) sortsdisk_ps, SUM(CASE WHEN a.internal_metric_name = 'sortsdisk_pt' THEN m.value ELSE 0 END) sortsdisk_pt, SUM(CASE WHEN a.internal_metric_name = 'rows_psort' THEN m.value ELSE 0 END) rows_psort, SUM(CASE WHEN a.internal_metric_name = 'executeswoparse_pct' THEN m.value ELSE 0 END) executeswoparse_pct, SUM(CASE WHEN a.internal_metric_name = 'softparse_pct' THEN m.value ELSE 0 END) softparse_pct, SUM(CASE WHEN a.internal_metric_name = 'usercall_pct' THEN m.value ELSE 0 END) usercall_pct, SUM(CASE WHEN a.internal_metric_name = 'networkbytes_ps' THEN m.value ELSE 0 END) networkbytes_ps, SUM(CASE WHEN a.internal_metric_name = 'enqtimeouts_ps' THEN m.value ELSE 0 END) enqtimeouts_ps, SUM(CASE WHEN a.internal_metric_name = 'enqtimeouts_pt' THEN m.value ELSE 0 END) enqtimeouts_pt, SUM(CASE WHEN a.internal_metric_name = 'enqwaits_ps' THEN m.value ELSE 0 END) enqwaits_ps, SUM(CASE WHEN a.internal_metric_name = 'enqwaits_pt' THEN m.value ELSE 0 END) enqwaits_pt, SUM(CASE WHEN a.internal_metric_name = 'enqdeadlocks_ps' THEN m.value ELSE 0 END) enqdeadlocks_ps, SUM(CASE WHEN a.internal_metric_name = 'enqdeadlocks_pt' THEN m.value ELSE 0 END) enqdeadlocks_pt, SUM(CASE WHEN a.internal_metric_name = 'enqreqs_ps' THEN m.value ELSE 0 END) enqreqs_ps, SUM(CASE WHEN a.internal_metric_name = 'enqreqs_pt' THEN m.value ELSE 0 END) enqreqs_pt, SUM(CASE WHEN a.internal_metric_name = 'dbblkgets_ps' THEN m.value ELSE 0 END) dbblkgets_ps, SUM(CASE WHEN a.internal_metric_name = 'dbblkgets_pt' THEN m.value ELSE 0 END) dbblkgets_pt, SUM(CASE WHEN a.internal_metric_name = 'consistentreadgets_ps' THEN m.value ELSE 0 END) consistentreadgets_ps, SUM(CASE WHEN a.internal_metric_name = 'consistentreadgets_pt' THEN m.value ELSE 0 END) consistentreadgets_pt, SUM(CASE WHEN a.internal_metric_name = 'dbblkchanges_ps' THEN m.value ELSE 0 END) dbblkchanges_ps, SUM(CASE WHEN a.internal_metric_name = 'dbblkchanges_pt' THEN m.value ELSE 0 END) dbblkchanges_pt, SUM(CASE WHEN a.internal_metric_name = 'consistentreadchanges_ps' THEN m.value ELSE 0 END) consistentreadchanges_ps, SUM(CASE WHEN a.internal_metric_name = 'consistentreadchanges_pt' THEN m.value ELSE 0 END) consistentreadchanges_pt, SUM(CASE WHEN a.internal_metric_name = 'crblks_ps' THEN m.value ELSE 0 END) crblks_ps, SUM(CASE WHEN a.internal_metric_name = 'crblks_pt' THEN m.value ELSE 0 END) crblks_pt, SUM(CASE WHEN a.internal_metric_name = 'crundorecs_pt' THEN m.value ELSE 0 END) crundorecs_pt, SUM(CASE WHEN a.internal_metric_name = 'userrollbackundorec_ps' THEN m.value ELSE 0 END) userrollbackundorec_ps, SUM(CASE WHEN a.internal_metric_name = 'userrollbackundorec_pt' THEN m.value ELSE 0 END) userrollbackundorec_pt, SUM(CASE WHEN a.internal_metric_name = 'leafnodesplits_ps' THEN m.value ELSE 0 END) leafnodesplits_ps, SUM(CASE WHEN a.internal_metric_name = 'leafnodesplits_pt' THEN m.value ELSE 0 END) leafnodesplits_pt, SUM(CASE WHEN a.internal_metric_name = 'branchnodesplits_ps' THEN m.value ELSE 0 END) branchnodesplits_ps, SUM(CASE WHEN a.internal_metric_name = 'branchnodesplits_pt' THEN m.value ELSE 0 END) branchnodesplits_pt, SUM(CASE WHEN a.internal_metric_name = 'redosize_pt' THEN m.valu e ELSE 0 END) redosize_pt, SUM(CASE WHEN a.internal_metric_name = 'crundorecs_ps' THEN m.value ELSE 0 END) crundorecs_ps, SUM(CASE WHEN a.internal_metric_name = 'dbtime_ps' THEN m.value ELSE 0 END) dbtime_ps, SUM(CASE WHEN a.internal_metric_name = 'avg_active_sessions' THEN m.value ELSE 0 END) avg_active_sessions, SUM(CASE WHEN a.internal_metric_name = 'avg_sync_singleblk_read_latency' THEN m.value ELSE 0 END) avg_block_read_latency, SUM(CASE WHEN a.internal_metric_name = 'iombs_ps' THEN m.value ELSE 0 END) iombs_ps, SUM(CASE WHEN a.internal_metric_name = 'iorequests_ps' THEN m.value ELSE 0 END) iorequests_ps FROM v$alert_types a, v$threshold_types t, v$sysmetric m WHERE a.internal_metric_category = 'instance_throughput' AND a.reason_id = t.alert_reason_id AND t.metrics_id = m.metric_id AND m.group_id = 2 AND :1 != 'BASIC' AND m.end_time <= SYSDATE GROUP BY m.end_time ORDER BY m.end_time ASC
317v5hnvvd49h UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
350myuyx0t1d6insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
35hatv0pj8hw7select decode(u.type#, 2, u.ext_username, u.name), o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where o.type# = 12 and bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
36ya4s1zjwx1hSELECT COUNT(*) FROM STATS$USER_LOG WHERE USERNAME = USER
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
3w4qs0tbpmxr6select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
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
5fkzpyqyptax3 DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SELECT parameter_value, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; OPEN data_cursor FOR WITH recInfo AS ( SELECT /*+ NO_MERGE */ finding_id, count(r.rec_id) recCount, r.type FROM DBA_ADVISOR_RECOMMENDATIONS r WHERE task_id=latest_task_id GROUP BY r.finding_id, r.type ), f_curr AS ( SELECT /*+ NO_MERGE */ DISTINCT finding_name FROM DBA_ADVISOR_FINDINGS WHERE task_id=latest_task_id ), tasks AS ( SELECT /*+ NO_MERGE */ t.task_id, i.local_task_id, t.end_time, t.begin_time FROM DBA_ADDM_TASKS t, DBA_ADDM_INSTANCES i WHERE t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=SYS_CONTEXT('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ), f_all AS ( SELECT /*+ NO_MERGE */ COUNT(fa.task_id) finding_count, fa.finding_name FROM tasks, DBA_ADVISOR_FINDINGS fa WHERE fa.task_id=tasks.task_id AND fa.type<>'INFORMATION' AND fa.type<>'WARNING' AND fa.parent=0 GROUP BY fa.finding_name ), history AS ( SELECT /*+ NO_MERGE */ finding_name, finding_count FROM f_all JOIN f_curr USING (finding_name) ) SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, null, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_CHAR(TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') start_time, TO_CHAR(TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM DBA_ADDM_FINDINGS f, recInfo, history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f.parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :1 := data_cursor; END;
5hk2758bxufj0SELECT column_name, nullable, data_type, char_length, data_precision, data_scale FROM user_tab_columns WHERE table_name=:1 ORDER BY column_id
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5rygsj4dbw6jtinsert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
61a161nm1ttjjselect /*+ INDEX(TAB AQ$_AQ_EVENT_TABLE_I) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no, tab.user_data from "SYS"."AQ_EVENT_TABLE" tab where q_name = :1 and (state = :2 ) order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
7k6zct1sya530insert into WRH$_STREAMS_APPLY_SUM (snap_id, dbid, instance_number, apply_name, startup_time, reader_total_messages_dequeued, reader_lag, coord_total_received, coord_total_applied, coord_total_rollbacks, coord_total_wait_deps, coord_total_wait_cmts, coord_lwm_lag, server_total_messages_applied, server_elapsed_dequeue_time, server_elapsed_apply_time) select * from (select :snap_id, :dbid, :instance_number, ac.apply_name, ac.startup_time, ar.total_messages_dequeued, ar.dequeue_time - ar.dequeued_message_create_time, ac.total_received, ac.total_applied, ac.total_rollbacks, ac.total_wait_deps, ac.total_wait_commits, ac.lwm_time - ac.lwm_message_create_time, al.total_messages_applied, al.elapsed_dequeue_time, al.elapsed_apply_time from v$streams_apply_coordinator ac, v$streams_apply_reader ar, (select apply_name, sum(total_messages_applied) total_messages_applied, sum(elapsed_dequeue_time) elapsed_dequeue_time, sum(elapsed_apply_time) elapsed_apply_time from v$streams_apply_server group by apply_name) al where al.apply_name=ac.apply_name and ar.apply_name=ac.apply_name order by ac.total_applied desc) where rownum <= 25
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
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
7z7x3166pt4kmSELECT 'SCHEMA' type, username owner, username object_name, null column_name, null column_id, null data_type FROM all_users WHERE rownum <=50 and username like :1 union all SELECT 'ARGUMENT' type, null owner, a.owner||'.'||a.package_name||'.'||a.object_name||'.'||a.overload object_name, a.argument_name||' '||a.data_type column_name, a.position column_id, null data_type FROM all_arguments a, all_objects o WHERE a.object_id=o.object_id and rownum <=50 and argument_name is not null and o.object_name = :2 union all SELECT object_type type, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') and object_name like :3
81uvdbt46vt5pDECLARE /* Yannick */ i NUMBER; sql_stmt VARCHAR2(200); max_id number; BEGIN SELECT MAX(id) INTO max_id FROM yjaquier.test1; i:=1; DBMS_RANDOM.SEED(SYSDATE); FOR i IN 1..max_id LOOP sql_stmt:='SELECT /* Yannick */ descr FROM yjaquier.test1 WHERE id=' || ROUND(DBMS_RANDOM.VALUE(1, max_id)); EXECUTE IMMEDIATE sql_stmt; END LOOP; END;
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
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
9nh7uqswpdc6hselect OID, Customer_Oid, Customer_Name, Customer_Location, ACCOUNT_NUM, Interface_Name, MN_Created_DEC, DEC_Code, STATUS , customer_alias_oid from dataload.ST_ACC_ALIAS_DATA where STATUS = :1 order by interface_id
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
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
9zzuyxx4pjhsxselect p_obj#, flags, code, audit$ from edition$ where obj#=:1
a32bhg8ny1y4uselect * from dba_tab_statistics where owner='YJAQUIER' and table_name='TEST1'
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
avv5dcc9zx2qbSELECT 'SCHEMA' type, username owner, username object_name, null column_name, null column_id, null data_type FROM all_users WHERE rownum <=50 and username like :1 union all SELECT object_type type, SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') owner, object_name, null column_name, null column_id, null data_type FROM all_objects WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') and object_name like :2
b3zgx1xckrwxuselect host, userid, password, flag, authusr, authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
b4mrsfc9tthamWITH snaps as (SELECT :1 dbid, MIN(snap_id) as bid, MAX(snap_id) as eid FROM DBA_HIST_SNAPSHOT WHERE dbid = :2 AND end_interval_time >= :3 AND end_interval_time <= :4 ) SELECT t.task_id, t.end_time as end_time FROM DBA_ADDM_TASKS t, snaps s, DBA_ADDM_INSTANCES i WHERE t.dbid = :5 AND t.dbid = s.dbid AND t.begin_snap_id >= s.bid - 1 AND t.begin_snap_id < s.eid AND t.how_created = 'AUTO' AND t.requested_analysis = 'INSTANCE' AND t.task_id = i.task_id AND i.instance_number = :6
bgba4tpdcpgundeclare t_user_count NUMBER; l_program v$session.program%TYPE; l_osuser v$session.program%TYPE; begin select count(*) into t_user_count from stats$user_log where username = USER; IF t_user_count = 0 THEN insert into stats$user_log ( username, LAST_LOGON_DAY ) values( USER, sysdate ); ELSE UPDATE stats$user_log SET LAST_LOGON_DAY = SYSDATE WHERE username = USER; END IF; exception when others then raise_application_error(-20008, 'Problem in connection due to Logon_Trig. Contact DB-SL Team.'); end;
bqfx5q2jas08uSELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1
bzgpy0vxtvf63SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id, sql_child_number, plsql_object_id, plsql_subprogram_id, qc_session_serial# FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cyg8zddx2x8h6select FUNCTION_NAME, SMALL_READ_MBPS, SMALL_WRITE_MBPS, LARGE_READ_MBPS, LARGE_WRITE_MBPS, SMALL_READ_IOPS, SMALL_WRITE_IOPS, LARGE_READ_IOPS, LARGE_WRITE_IOPS, AVG_WAIT_TIME from V$IOFUNCMETRIC where intsize_csec > 5900 order by function_name
d2687zmqyq4avselect metric_id, value from v$sysmetric where intsize_csec > 5900 and group_id = 2 and metric_id in (2148, 2149, 2137, 2138, 2141, 2140, 2139, 2091, 2090, 2089, 2088, 2087, 2142, 2144)
d6yky1ddz2m2qUPDATE STATS$USER_LOG SET LAST_LOGON_DAY = SYSDATE WHERE USERNAME = USER
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dc1876qva6b70select qi.oid from dataload.quote q, dataload.quote_item qi, dataload.quote_contract_mapping qcm, dataload.mn_ht_contract mhc, dataload.part p, dataload.mn_ht_contract_li mhcl, dataload.quote_contract_item_mapping qcim, dataload.exporter_info ei where q.oid = qi.quote_oid and qcm.contract_oid = mhc.contract_id and p.oid = qi.part_oid and qcm.quote_oid = q.oid and mhc.contract_id = mhcl.contract_id and qi.custom_field1 in ('On Hold', 'Deleted', 'Rejected') and mhcl.line_status = 30 and q.quote_type_oid = 4 and qcim.contract_item_oid = mhcl.contract_line_item_id and qcim.quote_item_oid = qi.oid and mhc.contract_status not in ('TERM') and ei.TYPE ='CANCEL_CONTRACT_ITEM' and qi.MODIFIED_DATE >= ei.LAST_EXPORT
djunbuupchm4sLOCK TABLE event_info IN EXCLUSIVE MODE
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#
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