WORKLOAD REPOSITORY COMPARE PERIOD REPORT

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

Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st182223-Apr-14 18:30:05 (Wed)182323-Apr-14 18:45:06 (Wed) 7.1 15.0 106.7
2nd182623-Apr-14 19:30:10 (Wed)182723-Apr-14 19:45:13 (Wed) 14.0 15.0 210.2
%Diff     96.8 0.1 96.9

Host Configuration Comparison

1st2ndDiff%Diff
Number of CPUs:8800.0
Number of CPU Cores:8800.0
Number of CPU Sockets:2200.0
Physical Memory:7974.6M7974.6M0M0.0
Load at Start Snapshot:6.938.371.4420.8
Load at End Snapshot:7.2314.076.8494.6
%User Time:23.7939.6215.8366.5
%System Time:.891.43.5460.7
%Idle Time:74.7958.14-16.65-22.3
%IO Wait Time:21.8130.488.6739.8

Cache Sizes

1st (M)2nd (M)Diff (M)%Diff
Memory Target    
SGA Target
1,024.01,024.00.00.0
Buffer Cache
728.0728.00.00.0
Shared Pool
260.0260.00.00.0
Large Pool
8.08.00.00.0
Java Pool
4.04.00.00.0
Streams Pool
8.08.00.00.0
PGA Target
128.0128.00.00.0
Log Buffer7.87.80.00.0

Load Profile

1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 7.1 14.0 96.8 0.0 0.0 66.7
CPU time: 1.9 3.2 68.8 0.0 0.0 0.0
Redo size: 393,267.0 552,173.5 40.4 1,931.8 1,933.1 0.1
Logical reads: 406,407.8 649,091.1 59.7 1,996.3 2,272.4 13.8
Block changes: 2,827.7 3,948.6 39.6 13.9 13.8 -0.5
Physical reads: 580.0 857.4 47.8 2.8 3.0 5.3
Physical writes: 377.6 578.1 53.1 1.9 2.0 9.2
User calls: 2,896.4 4,051.3 39.9 14.2 14.2 -0.4
Parses: 0.5 1.6 189.1 0.0 0.0 100.0
Hard parses: 0.0 0.4 3,600.0 0.0 0.0 0.0
W/A MB processed: 82,999.0 85,027.5 2.4 407.7 297.7 2.4
Logons: 0.0 0.0 200.0 0.0 0.0 0.0
Executes: 1,364.7 1,914.2 40.3 6.7 6.7 0.0
Transactions: 203.6 285.6 40.3   
1st2ndDiff
% Blocks changed per Read: 0.7 0.6 -0.1
Recursive Call %: 6.9 7.3 0.4
Rollback per transaction %: 0.0 0.0 0.0
Rows per Sort: 36.7 13.0 -23.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/O521,3614,574.968.7871.43db file sequential readUser I/O772,5539,350.5012.1074.14
CPU time  1,701.44 26.57CPU time  2,876.51 22.81
log file syncCommit182,73994.430.521.47log file syncCommit256,684266.831.042.12
log file parallel writeSystem I/O178,85738.820.220.61log file parallel writeSystem I/O242,510104.960.430.83
read by other sessionUser I/O2,75427.009.810.42read by other sessionUser I/O4,21951.4912.210.41

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.006,404.5512,612.5196.930.030.0566.67
DB CPU26.5722.81-3.761,701.442,876.5169.060.010.010.00
sql execute elapsed time95.4795.34-0.136,114.4212,024.6496.660.030.0566.67
connection management call elapsed time0.000.060.060.007.39100.000.000.000.00
parse time elapsed0.420.450.0326.8757.06112.360.000.000.00
hard parse elapsed time0.000.030.030.003.63100.000.000.000.00
hard parse (sharing criteria) elapsed time0.000.000.000.000.47100.000.000.000.00
hard parse (bind mismatch) elapsed time0.000.000.000.000.46100.000.000.000.00
PL/SQL compilation elapsed time0.000.000.000.000.26100.000.000.000.00
sequence load elapsed time0.000.00-0.000.090.00-100.000.000.000.00
PL/SQL execution elapsed time0.000.000.000.000.01100.000.000.000.00
repeated bind elapsed time0.000.000.000.000.000.000.000.000.00
Java execution elapsed time0.000.000.000.000.000.000.000.000.00
RMAN cpu time (backup/restore)0.000.000.000.000.000.000.000.000.00
failed parse (out of shared memory) elapsed time0.000.000.000.000.000.000.000.000.00
failed parse elapsed time0.000.000.000.000.000.000.000.000.00
inbound PL/SQL rpc elapsed time0.000.000.000.000.000.000.000.000.00
background cpu time0.600.49-0.1138.7362.1260.390.000.000.00
background elapsed time1.681.760.08107.51221.86106.360.000.000.00



Back to Top

Operating System Statistics

 Value (centi-seconds) per Second (DB time) per Second (Elapsed Time) per Trans
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
BUSY_TIME176,851297,13327.6123.56-14.67196.16329.1067.770.961.1519.79
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_TIME524,631412,75981.9232.73-60.05581.92457.17-21.442.861.60-44.06
IOWAIT_TIME152,976216,36223.8917.15-28.21169.68239.6441.230.830.841.20
NICE_TIME35990.010.010.000.040.11175.000.000.000.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME6,26810,1700.980.81-17.356.9511.2662.010.030.0433.33
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_TIME166,878281,27026.0622.30-14.43185.10311.5468.310.911.0919.78
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/O71.8974.562.67581.65860.7647.994,604.229,403.75104.248.7812.1037.81
Commit1.472.120.64202.69284.3040.2694.43266.83182.570.521.04100.00
System I/O0.921.140.22231.77318.9337.6158.80143.21143.550.280.5078.57
Concurrency0.010.090.081.183.03156.780.8611.541,241.860.814.21419.75
Configuration0.080.150.080.190.47147.374.9219.20290.2428.4245.7160.84
Network0.040.03-0.011,573.362,200.0739.832.483.8354.440.000.000.00
Application0.010.020.000.761.3678.950.802.20175.001.171.7952.99
Other0.010.010.001.824.10125.270.471.24163.830.280.3317.86


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/O71.4374.142.70578.29855.6847.974,574.969,350.50104.388.7812.1037.81
log file syncCommit1.472.120.64202.69284.3040.2694.43266.83182.570.521.04100.00
log file parallel writeSystem I/O0.610.830.23198.39268.6035.3938.82104.96170.380.220.4395.45
cursor: pin S wait on XConcurrency0.000.060.060.000.08100.000.007.66100.000.00103.51100.00
log file switch (private strand flush incomplete)Configuration0.040.100.060.110.29163.642.4412.05393.8524.4445.3285.43
db file parallel writeSystem I/O0.220.18-0.0427.9043.4955.8814.3722.9159.430.570.581.75
control file sequential readSystem I/O0.080.110.032.973.145.725.2614.40173.761.965.08159.18
log file switch (checkpoint incomplete)Configuration0.040.060.020.080.16100.002.477.03184.6233.8747.5040.24
db file scattered readUser I/O0.020.01-0.020.130.10-23.081.500.97-35.3312.3911.05-10.82
read by other sessionUser I/O0.420.41-0.013.054.6753.1127.0051.4990.709.8112.2124.46
SQL*Net message to clientNetwork0.040.03-0.011,573.362,200.0739.832.483.8354.440.000.000.00
library cache lockConcurrency0.000.010.010.000.06100.000.001.04100.000.0020.73100.00
enq: TX - row lock contentionApplication0.010.020.000.761.3678.950.802.20175.001.171.7952.99
library cache load lockConcurrency0.000.000.000.000.03100.000.000.52100.000.0019.15100.00
db file parallel readUser I/O0.010.00-0.000.050.03-40.000.390.30-23.089.6110.6510.82
library cache: mutex XConcurrency0.000.000.000.040.24500.000.010.474,600.000.372.15481.08
os thread startupConcurrency0.010.00-0.000.010.010.000.420.420.0035.3738.117.75
kksfbc child completionOther0.000.000.000.000.01100.000.000.31100.000.0051.10100.00
enq: TX - index contentionConcurrency0.000.000.000.010.04300.000.110.51363.6415.5116.063.55
latch: cache buffers chainsConcurrency0.000.000.000.501.49198.000.060.34466.670.120.25108.33
direct path readUser I/O0.010.00-0.000.020.04100.000.350.4734.2919.1914.53-24.28
cursor: pin SConcurrency0.000.000.000.030.07133.330.050.27440.001.954.20115.38
control file parallel writeSystem I/O0.000.000.000.680.737.350.100.35250.000.170.53211.76
buffer busy waitsConcurrency0.000.00-0.000.420.7169.050.190.2321.050.490.36-26.53
LGWR wait for redo copyOther0.000.000.000.922.92217.390.050.23360.000.070.0928.57
ASM file metadata operationOther0.000.00-0.000.600.600.000.220.3140.910.400.5742.50
enq: HW - contentionConfiguration0.000.000.000.000.000.000.000.11100.000.0028.21100.00
log file sequential readSystem I/O0.000.000.000.050.0620.000.240.57137.505.3810.2390.15
enq: JS - queue lockOther0.000.00-0.000.000.000.000.050.00-100.0050.560.00-100.00
latch freeOther0.000.000.000.080.23187.500.020.15650.000.340.71108.82
enq: TX - contentionOther0.000.000.000.000.000.000.000.07100.000.0069.44100.00
ADR block file readOther0.000.00-0.000.020.020.000.090.1122.225.436.6121.73
row cache lockConcurrency0.000.000.000.000.01100.000.000.03100.000.002.69100.00
latch: shared poolConcurrency0.000.000.000.000.01100.000.000.02100.000.001.99100.00
reliable messageOther0.000.00-0.000.100.06-40.000.010.010.000.140.1828.57
latch: object queue header operationOther0.000.000.000.020.06200.000.000.02100.000.250.3124.00
latch: redo allocationOther0.000.000.000.010.05400.000.000.01100.000.150.2886.67
latch: In memory undo latchConcurrency0.000.000.000.170.2864.710.020.05150.000.120.1850.00
Disk file operations I/OUser I/O0.000.000.000.090.22144.440.010.02100.000.070.0814.29
ADR block file writeOther0.000.00-0.000.010.010.000.000.000.000.660.49-25.76
latch: cache buffers lru chainOther0.000.000.000.010.02100.000.000.01100.000.090.25177.78
enq: CU - contentionOther0.000.000.000.000.000.000.000.000.000.003.65100.00
direct path writeUser I/O0.000.000.000.010.03200.000.000.01100.000.140.2471.43
CSS initializationOther0.000.00-0.000.000.000.000.000.01100.004.736.6340.17
latch: enqueue hash chainsOther0.000.000.000.020.0350.000.000.01100.000.230.3134.78
latch: row cache objectsConcurrency0.000.000.000.000.01100.000.000.000.000.000.28100.00
log file single writeSystem I/O0.000.00-0.000.050.0620.000.000.01100.000.080.1025.00
db file async I/O submitSystem I/O0.000.00-0.001.722.8465.120.000.01100.000.000.000.00
latch: redo writingConfiguration0.000.000.000.000.000.000.000.000.000.000.35100.00
CSS operation: actionOther0.000.00-0.000.000.000.000.000.000.001.011.6462.38
latch: session allocationOther0.000.000.000.000.000.000.000.000.000.000.17100.00
CSS operation: queryOther0.000.00-0.000.010.010.000.000.000.000.090.1233.33
latch: undo global dataOther0.000.00-0.000.000.01100.000.000.000.000.230.18-21.74
latch: checkpoint queue latchOther0.000.00-0.000.000.000.000.000.000.000.130.04-69.23
latch: messagesOther0.000.00-0.000.000.000.000.000.000.000.170.1911.76
ADR file lockOther0.000.00-0.000.010.010.000.000.000.000.010.010.00
asynch descriptor resizeOther0.000.000.000.030.07133.330.000.000.000.010.010.00
SQL*Net message from clientIdle252.02180.99-71.031,573.362,200.0939.8316,140.8422,827.0741.4211.3811.490.97
Space Manager: slave idle waitIdle45.8317.09-28.750.670.50-25.372,935.292,154.86-26.594,835.744,777.96-1.19
class slave waitIdle56.3028.71-27.600.260.3015.383,605.793,620.460.4115,343.7913,559.77-11.63
DIAG idle waitIdle28.1414.36-13.782.002.000.001,801.981,810.580.481,001.101,001.430.03
Streams AQ: qmn slave idle waitIdle14.107.15-6.950.140.140.00903.19902.13-0.127,001.476,993.22-0.12
Streams AQ: qmn coordinator idle waitIdle14.107.15-6.950.330.32-3.03903.25902.28-0.113,000.843,111.313.68
wait for unread message on broadcast channelIdle14.077.18-6.891.001.000.00900.98905.370.491,001.091,001.520.04
ASM background timerIdle14.057.18-6.870.200.200.00900.07905.510.605,000.415,002.800.05
jobq slave waitIdle0.940.48-0.460.130.130.0060.1260.120.00501.02500.98-0.01
KSV master waitIdle0.000.00-0.000.080.1025.000.010.010.000.090.1344.44


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
DBM11203.antognini.ch99.8999.73-0.16100.0299.79-0.2399.4299.460.04100.0899.94-0.14
SYS$USERS0.100.08-0.020.040.050.010.100.110.010.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.460.31-0.150.000.010.00


Back to Service Statistics
Back to Top

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
DBM11203.antognini.ch0.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.00
SYS$USERS0.000.000.000.000.000.000.00


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
9bz9sa0abpc486.246.24  -6.2427 2.29 1 27 3.21 1.00 14,671   insert into customers (custome...
g8rhybcumtwd621.0927.3318.3518.35-2.741912221.110.8317520513111.100.639.999.997,08610,4421/ 1/ 1 SELECT /*+ first_rows index(cu...
8vvvyuun2urt69.1736.4910.5228.881.366916.4311.6600590.650.761.001.00105,252147,058  insert into order_items(ORDER_...
5g00dq4fxwnsw6.7743.278.0236.891.244716.4311.6600470.460.560.900.90105,254147,0541/ 1/ 1 update inventories set quantit...
2yp5w5a36s5xv1.6344.902.5639.460.93365.754.1200360.300.501.001.0036,85351,9451/ 1/ 1 update orders set order_mode =...
82ud5h0qcg0bf29.0973.9928.7568.20-0.34152119.5013.970015201.561.541.001.00124,882176,1821/ 1/ 1 select customer_id, cust_first...
gyk686gnaygs20.8274.800.6768.87-0.150034.4224.6700000.000.005.035.03220,441311,1301/ 1/ 1 select product_id, product_nam...
9zd49du11u7cf10.1884.9810.2379.100.0518255.754.121117241.921.931.001.0036,85251,948  insert into orders(ORDER_ID, O...
gshgncvvtv0c60.3685.350.3479.44-0.030019.5013.9700000.000.001.001.00124,883176,186  insert into logon values(:1 , ...
gfqas5ahy1x560.6986.040.6780.11-0.02125.754.1200110.120.132.862.8336,85451,9471/ 1/ 1 SELECT o.order_id, line_item_i...
d5j6fbqmu3gjp8.2494.288.2388.35-0.0114205.744.110014201.781.810.930.9636,75251,8871/ 1/ 1 SELECT /*+ use_nl */ o.order_i...


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
g8rhybcumtwd672.8672.8674.5574.551.6917520513111.110.831912221.100.639.999.991/ 1/ 1 SELECT /*+ first_rows index(cu...
gyk686gnaygs22.7575.612.5677.11-0.19000034.4224.67000.000.005.035.031/ 1/ 1 select product_id, product_nam...
82ud5h0qcg0bf1.8977.491.8178.92-0.0700152019.5013.9715211.561.541.001.001/ 1/ 1 select customer_id, cust_first...
7v0pya6f6qc6s0.7078.200.6579.57-0.05000017.1512.31000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
dt8dtzvsq5kj50.6478.830.5980.16-0.05000016.4311.66000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
5g00dq4fxwnsw0.8879.710.9281.080.04004716.4311.66470.460.560.900.901/ 1/ 1 update inventories set quantit...
2yp5w5a36s5xv0.6480.350.6781.750.0300365.754.12360.300.501.001.001/ 1/ 1 update orders set order_mode =...
gshgncvvtv0c61.0081.350.9882.72-0.02000019.5013.97000.000.001.001.00  insert into logon values(:1 , ...
8vvvyuun2urt61.7883.131.8084.520.01005916.4311.66690.650.761.001.00  insert into order_items(ORDER_...
9zd49du11u7cf1.2184.351.2085.72-0.011117245.754.1218251.921.931.001.00  insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp0.7585.100.7486.46-0.010014205.744.1114201.781.810.930.961/ 1/ 1 SELECT /*+ use_nl */ o.order_i...


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
9bz9sa0abpc486.086.08  -6.0827 27 2.29 1 3.21 1.00 14,671   insert into customers (custome...
8vvvyuun2urt68.6714.7610.0710.071.40596916.4311.66000.650.761.001.00105,252147,058  insert into order_items(ORDER_...
5g00dq4fxwnsw6.5521.317.8017.871.25474716.4311.66000.460.560.900.90105,254147,0541/ 1/ 1 update inventories set quantit...
2yp5w5a36s5xv1.4622.772.4020.270.9436365.754.12000.300.501.001.0036,85351,9451/ 1/ 1 update orders set order_mode =...
g8rhybcumtwd61.4024.170.9421.21-0.4713111912221.110.831752051.100.639.999.997,08610,4421/ 1/ 1 SELECT /*+ first_rows index(cu...
82ud5h0qcg0bf28.6752.8528.3949.60-0.281520152119.5013.97001.561.541.001.00124,882176,1821/ 1/ 1 select customer_id, cust_first...
9zd49du11u7cf9.8762.719.9459.540.07172418255.754.12111.921.931.001.0036,85251,948  insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp8.0670.778.0867.610.01142014205.744.11001.781.810.930.9636,75251,8871/ 1/ 1 SELECT /*+ use_nl */ o.order_i...
gfqas5ahy1x560.5671.340.5768.190.0111125.754.12000.120.132.862.8336,85451,9471/ 1/ 1 SELECT o.order_id, line_item_i...
gshgncvvtv0c60.0471.380.0568.240.01000019.5013.97000.000.001.001.00124,883176,186  insert into logon values(:1 , ...
gyk686gnaygs20.0071.380.0068.240.00000034.4224.67000.000.005.035.03220,441311,1301/ 1/ 1 select product_id, product_nam...


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
g8rhybcumtwd695.9895.980.000.00-95.9849,626.710.007,08610,44219122217520513111.100.639.999.991/ 1/ 1 SELECT /*+ first_rows index(cu...
gyk686gnaygs21.8197.781.591.59-0.2130.0330.02220,441311,1300000000.000.005.035.031/ 1/ 1 select product_id, product_nam...
8vvvyuun2urt60.3898.160.331.93-0.0513.2813.28105,252147,0586900590.650.761.001.00  insert into order_items(ORDER_...
gshgncvvtv0c60.2098.370.172.10-0.035.985.80124,883176,1860000000.000.001.001.00  insert into logon values(:1 , ...
dt8dtzvsq5kj50.2098.570.182.28-0.037.067.06105,252147,0590000000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
9zd49du11u7cf0.1998.760.172.45-0.0218.9918.7736,85251,94818251117241.921.931.001.00  insert into orders(ORDER_ID, O...
7v0pya6f6qc6s0.2198.970.192.63-0.027.067.06109,862155,2520000000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
gfqas5ahy1x560.1399.110.112.74-0.0213.2312.5136,85451,9471200110.120.132.862.831/ 1/ 1 SELECT o.order_id, line_item_i...
82ud5h0qcg0bf0.1499.240.122.86-0.024.014.00124,882176,18215210015201.561.541.001.001/ 1/ 1 select customer_id, cust_first...
5g00dq4fxwnsw0.1199.360.102.96-0.013.923.93105,254147,0544700470.460.560.900.901/ 1/ 1 update inventories set quantit...
2yp5w5a36s5xv0.1099.460.093.05-0.0110.1410.2936,85351,9453600360.300.501.001.001/ 1/ 1 update orders set order_mode =...


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
9bz9sa0abpc489.019.01  -9.013.21 14,671 27 1 27 1.00   insert into customers (custome...
82ud5h0qcg0bf37.2746.2735.1435.14-2.131.561.54124,882176,18215210015201.001.001/ 1/ 1 select customer_id, cust_first...
5g00dq4fxwnsw9.1955.4710.7045.841.510.460.56105,254147,0544700470.900.901/ 1/ 1 update inventories set quantit...
8vvvyuun2urt613.0168.4714.4960.331.490.650.76105,252147,0586900591.001.00  insert into order_items(ORDER_...
2yp5w5a36s5xv2.1470.613.3463.671.200.300.5036,85351,9453600361.001.001/ 1/ 1 update orders set order_mode =...
g8rhybcumtwd61.4972.100.8464.51-0.641.100.637,08610,44219122217520513119.999.991/ 1/ 1 SELECT /*+ first_rows index(cu...
9zd49du11u7cf13.5285.6212.9477.46-0.571.921.9336,85251,94818251117241.001.00  insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp12.5598.1612.1689.62-0.381.781.8136,75251,88714200014200.930.961/ 1/ 1 SELECT /*+ use_nl */ o.order_i...
6k3uuf3g8pwh60.3798.530.2889.90-0.100.270.207,08210,4423400331.001.001/ 1/ 1 update /*+ index(orders, order...
gfqas5ahy1x560.8399.370.8590.750.020.120.1336,85451,9471200112.862.831/ 1/ 1 SELECT o.order_id, line_item_i...
9zus1m3s2675b0.0999.460.1090.850.01490.00793.00113,8866,4736301,2793,1404,9501.001.00  DECLARE job BINARY_INTEGER := ...


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
82ud5h0qcg0bf37.3537.3535.1735.17-2.181.561.54194,866271,9940.000.00124,882176,18215210015201.001.001/ 1/ 1 select customer_id, cust_first...
5g00dq4fxwnsw9.2146.5610.7145.881.500.460.5648,06682,8310.000.00105,254147,0544700470.900.901/ 1/ 1 update inventories set quantit...
8vvvyuun2urt613.0359.6014.5160.381.470.650.7668,010112,2100.000.00105,252147,0586900591.001.00  insert into order_items(ORDER_...
2yp5w5a36s5xv2.1561.743.3463.721.190.300.5011,19725,8320.000.0036,85351,9453600361.001.001/ 1/ 1 update orders set order_mode =...
9bz9sa0abpc481.0962.83  -1.090.39 5,680 0.00 14,671 27 1 27 1.00   insert into customers (custome...
g8rhybcumtwd61.4964.320.8564.57-0.641.100.637,7776,5460.000.007,08610,44219122217520513119.999.991/ 1/ 1 SELECT /*+ first_rows index(cu...
9zd49du11u7cf13.5577.8712.9577.53-0.591.921.9370,673100,1930.000.0036,85251,94818251117241.001.00  insert into orders(ORDER_ID, O...
d5j6fbqmu3gjp12.5790.4412.1889.70-0.401.781.8165,59894,1660.000.0036,75251,88714200014200.930.961/ 1/ 1 SELECT /*+ use_nl */ o.order_i...
6k3uuf3g8pwh60.3790.810.2889.98-0.100.270.201,9422,1300.000.007,08210,4423400331.001.001/ 1/ 1 update /*+ index(orders, order...
gfqas5ahy1x560.8391.650.8590.830.020.120.134,3546,6020.000.0036,85451,9471200112.862.831/ 1/ 1 SELECT o.order_id, line_item_i...
9zus1m3s2675b0.1691.800.1590.98-0.01815.001,126.008151,1260.000.00113,8866,4736301,2793,1404,9501.001.00  DECLARE job BINARY_INTEGER := ...


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
gyk686gnaygs234.4224.67-9.75220,441311,1300000000.000.005.035.031/ 1/ 1 select product_id, product_nam...
82ud5h0qcg0bf19.5013.97-5.53124,882176,18215210015201.561.541.001.001/ 1/ 1 select customer_id, cust_first...
gshgncvvtv0c619.5013.97-5.53124,883176,1860000000.000.001.001.00  insert into logon values(:1 , ...
7v0pya6f6qc6s17.1512.31-4.84109,862155,2520000000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
5g00dq4fxwnsw16.4311.66-4.77105,254147,0544700470.460.560.900.901/ 1/ 1 update inventories set quantit...
8vvvyuun2urt616.4311.66-4.77105,252147,0586900590.650.761.001.00  insert into order_items(ORDER_...
982zxphp8ht6c16.4311.66-4.77105,251147,0570000000.000.001.001.001/ 1/ 1 select product_id, product_nam...
dt8dtzvsq5kj516.4311.66-4.77105,252147,0590000000.000.0010.0010.001/ 1/ 1 select p.product_id, product_n...
2yp5w5a36s5xv5.754.12-1.6436,85351,9453600360.300.501.001.001/ 1/ 1 update orders set order_mode =...
gfqas5ahy1x565.754.12-1.6436,85451,9471200110.120.132.862.831/ 1/ 1 SELECT o.order_id, line_item_i...
9zd49du11u7cf5.754.12-1.6436,85251,94818251117241.921.931.001.00  insert into orders(ORDER_ID, O...
8uk8bquk453q85.754.12-1.6336,84851,9470000000.000.001.001.001/ 1/ 1 select orders_seq.nextval from...


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
350f5yrnnmshs27.2427.249.539.53-17.70134137134137  lock table sys.mon_mods$ in ex...
b2gnxm5z6r51n0.8128.0510.5120.049.6941514151  lock table sys.col_usage$ in e...
9tgj4g8y4rwy8  1.6021.641.60 23 96/ 1/ 1 select type#, blocks, extents,...
cm5vu20fhtnq1  1.1822.831.18 17 30/ 1/ 1 select /*+ connect_by_filterin...
0k8522rmdzg4k  1.0423.871.04 15 15/ 2/ 2 select privilege# from sysauth...
0ws7ahf1d78qa  1.0424.911.04 15 15/ 1/ 1 select SYS_CONTEXT('USERENV', ...
2yp5w5a36s5xv0.0028.051.0425.961.0401536,85351,9451/ 1/ 1 update orders set order_mode =...
459f3z9u4fb3u  1.0427.001.04 15 15/ 1/ 1 select value$ from props$ wher...
5d8b4p888x97a0.0028.051.0428.041.0401514,67120,5021/ 1/ 1 select customer_seq.nextval fr...
0kkhhb2w93cx01.0229.07  -1.025 10 1// 1 update seg$ set type#=:4, bloc...
1gfaj4z5hn1kf0.4129.47  -0.412 2 1// 1 delete from dependency$ where ...
20vv6ttajyjzq0.4129.88  -0.412 2 1// 1 delete from access$ where d_ob...
2pff93c8c626v0.4130.28  -0.412 2 1// 1 select name, address, protocol...
4m7m0t6fjcs5x0.4130.69  -0.412 10 1// 1 update seq$ set increment$=:2,...
6abthk1u14yb70.4131.10  -0.412 2 1// 1 SELECT VERSION FROM V$INSTANCE
6xvp6nxs4a9n40.4131.50  -0.412 12 1// 1 select nvl(sum(space), 0) from...
bsa0wjtftg3uw1.4232.931.3229.37-0.10719881111/ 1/ 1 select file# from file$ where ...


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
9dhn1b8d88dpf  0.110.110.11 288,434 288,434 1 select OBJOID, CLSOID, RUNTIME...
bn4b3vjw2mj3u  0.070.170.07 178,288 178,288 4 SELECT OBJOID, CLSOID, DECODE(...
c2p21x29vnybg  0.060.230.06 154,684 154,684 1 SELECT x.inst_id, x.sid_knst, ...
8jhgd9rm6f17u  0.060.280.06 154,423 154,423 1 select SID, SERIAL#, CAPTURE#,...
6ajkhukk78nsr0.050.050.030.32-0.01132,37395,253132,37395,25311 begin prvt_hdm.auto_execute( :...
6wm3n4d7bnddg0.120.170.110.43-0.00321,554312,970321,554312,97011 SELECT source, (case when tim...
7r7twx8dzdd8r0.070.230.070.50-0.00182,732178,660182,732178,66011 INSERT INTO STATS$SEG_STAT_OBJ...
317v5hnvvd49h0.050.280.050.550.00139,928139,944139,928139,94411 UPDATE wrh$_seg_stat_obj ob S...
7k6zct1sya5300.060.340.060.610.00150,925150,941150,925150,94111 insert into WRH$_STREAMS_APPLY...
1bumcaqpc58vj0.050.390.050.660.00133,903133,903133,903133,90311 INSERT INTO STATS$STREAMS_CAPT...
5dyhfnkzta2zm0.060.450.060.710.00153,605153,605153,605153,60511 WITH awr_evts as (SELECT e.eve...
5h91zx386wbht0.070.520.070.790.00199,210199,210199,210199,21011 WITH awr_params as ( SELECT /*...
6cp74g22fzahf0.080.600.080.860.00216,035216,035216,035216,03511 WITH ash as (SELECT ash.event...
dnhdv2yuma39z0.050.650.050.920.00146,496146,496146,496146,49611 INSERT INTO STATS$STREAMS_APPL...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
0k8522rmdzg4k 44 4 15 select privilege# from sysauth...
5ur69atw3vfhj 44 4 15 select decode(failover_method,...
b3zgx1xckrwxu 44 4 1 select host, userid, password,...
23buxzfxyp1vy3 -33 1  SELECT greatest(0, 1000*servi...
23nad9x295gkf3 -33 1  SELECT (m.current_size / 10485...
4g46czps3t55u3 -33 1  SELECT sum(case when snap_id ...
4kt3cun8s5fp5 33 3 2 select name, password, datats#...
4vs91dcv7u1p6 33 3 15 insert into sys.aud$( sessioni...
5uw1u291s3m0k3 -33 1  SELECT case when cnt = 0 then ...
6sqdp7673k5x33 -33 1  UPDATE wri$_adv_addm_tasks SET...
47mm81hm9sggy3303311 SELECT sum(case when a.sessio...
5dyhfnkzta2zm3303311 WITH awr_evts as (SELECT e.eve...
5h91zx386wbht3303311 WITH awr_params as ( SELECT /*...
6ajkhukk78nsr3303311 begin prvt_hdm.auto_execute( :...
6cp74g22fzahf3303311 WITH ash as (SELECT ash.event...


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
01gmsncqrjrfr  0.000.000.00 0.00 0.00 1/ 1/ 1 insert into WRH$_BUFFERED_QUEU...
0bma28usvnqt1  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT text.sql_id FROM WRH$_S...
0k8522rmdzg4k  0.000.000.00 0.00 0.00 15/ 2/ 2 select privilege# from sysauth...
0kkhhb2w93cx00.000.00  0.000.00 0.00 10 1// 1 update seg$ set type#=:4, bloc...
0v3dvmc22qnam  0.000.000.00 0.00 0.00 195  insert into sys.col_usage$ (ob...
0ws7ahf1d78qa  0.000.000.00 0.00 0.00 15/ 1/ 1 select SYS_CONTEXT('USERENV', ...
14wnf35dahb7v0.000.00  0.000.00 0.00 1 1// 1 SELECT A.ID, A.TYPE FROM SYS.W...
18c2yb5aj919t0.000.00  0.000.00 0.00 1 1// 1 SELECT nvl(e1, 0) as e1, nvl(...
1bumcaqpc58vj0.000.000.000.000.000.000.000.000.00111/ 1/ 1 INSERT INTO STATS$STREAMS_CAPT...
1cq3qr774cu450.000.000.000.000.000.000.000.000.00111/ 1/ 1 insert into WRH$_IOSTAT_FILETY...
1crajpb7j5tyz0.000.000.000.000.000.000.000.000.00111/ 1/ 1 INSERT INTO STATS$SGA_TARGET_A...
1gfaj4z5hn1kf0.000.00  0.000.00 0.00 2 1// 1 delete from dependency$ where ...
1p36ta7p3d7fu0.000.00  0.000.00 0.00 1 1// 1 select file#, block#, ts#, blo...
20vv6ttajyjzq0.000.00  0.000.00 0.00 2 1// 1 delete from access$ where d_ob...
23buxzfxyp1vy0.000.00  0.000.00 0.00 1 1// 1 SELECT greatest(0, 1000*servi...
2yp5w5a36s5xv0.000.000.000.000.000.000.000.000.0036,85351,9451/ 1/ 1 update orders set order_mode =...
317v5hnvvd49h0.000.000.000.000.000.000.000.000.00111/ 1/ 1 UPDATE wrh$_seg_stat_obj ob S...


Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

 Value per Second (DB time) per Second (Elapsed Time) per Trans
Statistic1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
db block changes2,549,3133,564,96339.84398.05282.65-28.992,827.703,948.5639.6413.8913.82-0.50
execute count1,230,3801,728,26840.47192.11137.03-28.671,364.741,914.2340.266.706.700.00
logons cumulative1327107.690.000.000.000.010.03200.000.000.000.00
opened cursors cumulative1,230,0721,727,50640.44192.06136.97-28.681,364.401,913.3940.246.706.700.00
parse count (total)4921,437192.070.080.1137.500.551.59189.090.000.01100.00
parse time elapsed1,8064,361141.470.280.3525.002.004.83141.500.010.02100.00
physical reads522,880774,07548.0481.6461.37-24.83579.98857.3747.832.853.005.26
physical writes340,400521,94453.3353.1541.38-22.14377.57578.1153.111.852.029.19
redo size354,549,884498,530,95240.6155,359.0739,526.72-28.60393,267.02552,173.5040.411,931.771,933.130.07
session logical reads366,396,963586,033,17559.9457,208.8646,464.45-18.78406,407.81649,091.0759.711,996.322,272.4313.83
user calls2,611,2143,657,71640.08407.71290.01-28.872,896.364,051.2939.8814.2314.18-0.35
user commits183,536257,88840.5128.6620.45-28.65203.58285.6440.311.001.000.00
workarea executions - optimal2741,032276.640.040.08100.000.301.14280.000.000.000.00


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
Batched IO (bound) vector count451433-3.990.070.03-57.140.500.48-4.000.000.000.00
Batched IO block miss count64376819.440.100.06-40.000.710.8519.720.000.000.00
Batched IO buffer defrag count73-57.140.000.000.000.010.00-100.000.000.000.00
Batched IO double miss count9012336.670.010.010.000.100.1440.000.000.000.00
Batched IO same unit count22326317.940.030.02-33.330.250.2916.000.000.000.00
Batched IO single block count4814942.700.080.04-50.000.530.553.770.000.000.00
Batched IO vector block count1231262.440.020.01-50.000.140.140.000.000.000.00
Batched IO vector read count60623.330.010.00-100.000.070.070.000.000.000.00
Block Cleanout Optim referenced3,5586,67587.610.560.53-5.363.957.3987.090.020.0350.00
CPU used by this session162,156274,38069.2125.3221.75-14.10179.86303.9068.960.881.0620.45
CPU used when call started162,045274,17169.1925.3021.74-14.07179.74303.6768.950.881.0620.45
CR blocks created43,72776,36874.656.836.05-11.4248.5084.5974.410.240.3025.00
Cached Commit SCN referenced34,73041,73120.165.423.31-38.9338.5246.2219.990.190.16-15.79
Commit SCN cached6,5048,60932.361.020.68-33.337.219.5432.320.040.03-25.00
DBWR checkpoint buffers written49,33731,900-35.347.702.53-67.1454.7235.33-35.430.270.12-55.56
DBWR checkpoints111427.270.000.000.000.010.02100.000.000.000.00
DBWR thread checkpoint buffers written49,33731,900-35.347.702.53-67.1454.7235.33-35.430.270.12-55.56
DBWR transaction table writes21828530.730.030.02-33.330.240.3233.330.000.000.00
DBWR undo block writes16,33624,06847.332.551.91-25.1018.1226.6647.130.090.090.00
HSC Heap Segment Block Changes421,099589,97240.1065.7546.78-28.85467.08653.4539.902.292.290.00
Heap Segment Array Inserts1691732.370.030.01-66.670.190.190.000.000.000.00
Heap Segment Array Updates152140.000.000.000.000.020.020.000.000.000.00
IMU CR rollbacks13,39618,37337.152.091.46-30.1414.8620.3536.940.070.070.00
IMU Flushes23,25929,87128.433.632.37-34.7125.8033.0928.260.130.12-7.69
IMU Redo allocation size116,746,320143,624,72423.0218,228.6511,387.48-37.53129,495.11159,078.9222.85636.09556.93-12.44
IMU commits154,026168,1539.1724.0513.33-44.57170.85186.259.010.840.65-22.62
IMU contention19,87226,33632.533.102.09-32.5822.0429.1732.350.110.10-9.09
IMU pool not allocated6,25859,912857.370.984.75384.696.9466.36856.200.030.23666.67
IMU undo allocation size373,604,528376,000,2640.6458,334.2429,811.70-48.90414,402.45416,458.360.502,035.591,458.00-28.37
IMU- failed to get a private strand6,25859,912857.370.984.75384.696.9466.36856.200.030.23666.67
Requests to/from client1,418,8641,988,09340.12221.54157.63-28.851,573.812,202.0139.927.737.71-0.26
RowCR - row contention23127619.480.040.02-50.000.260.3119.230.000.000.00
RowCR attempts112,607159,69841.8217.5812.66-27.99124.90176.8841.620.610.621.64
RowCR hits111,471156,90040.7517.4012.44-28.51123.64173.7840.550.610.610.00
SMON posted for undo segment shrink24268.330.000.000.000.030.030.000.000.000.00
SQL*Net roundtrips to/from client1,418,8721,988,11240.12221.54157.63-28.851,573.812,202.0439.927.737.71-0.26
active txn count during cleanout55,65560,6909.058.694.81-44.6561.7367.228.890.300.24-20.00
background checkpoints completed111427.270.000.000.000.010.02100.000.000.000.00
background checkpoints started111427.270.000.000.000.010.02100.000.000.000.00
background timeouts4,6824,6990.360.730.37-49.325.195.200.190.030.02-33.33
branch node splits3433.330.000.000.000.000.000.000.000.000.00
buffer is not pinned count177,662,097285,236,50860.5527,739.9822,615.37-18.47197,062.94315,928.3160.32968.001,106.0514.26
buffer is pinned count179,300,974287,542,23660.3727,995.8822,798.18-18.57198,880.79318,482.1460.14976.931,114.9914.13
bytes received via SQL*Net from client346,648,249485,538,09440.0754,125.3138,496.56-28.88384,502.52537,782.6039.861,888.721,882.75-0.32
bytes sent via SQL*Net to client767,717,8951,076,635,52640.24119,870.7185,362.54-28.79851,553.321,192,482.8540.044,182.934,174.82-0.19
calls to get snapshot scn: kcmgss1,133,7821,594,65240.65177.03126.43-28.581,257.591,766.2440.456.186.180.00
calls to kcmgas235,694349,20148.1636.8027.69-24.76261.43386.7847.951.281.355.47
calls to kcmgcs726,6761,018,86640.21113.4680.78-28.80806.031,128.5040.013.963.95-0.25
cell physical IO interconnect bytes7,982,754,81611,859,735,55248.571,246,419.37940,315.54-24.568,854,478.1913,135,857.8748.3543,494.2245,987.935.73
change write time1,3002,20069.230.200.17-15.001.442.4469.440.010.010.00
cleanout - number of ktugct calls32,87446,80042.365.133.71-27.6836.4651.8442.180.180.180.00
cleanouts and rollbacks - consistent read gets23,36333,59643.803.652.66-27.1225.9137.2143.610.130.130.00
cleanouts only - consistent read gets1,731987-42.980.270.08-70.371.921.09-43.230.010.00-100.00
cluster key scan block gets603,8676,345.000.010.313,000.000.074.286,014.290.000.01100.00
cluster key scans603,1645,173.330.010.252,400.000.073.504,900.000.000.01100.00
commit batch/immediate performed183383.330.000.000.000.020.04100.000.000.000.00
commit batch/immediate requested183383.330.000.000.000.020.04100.000.000.000.00
commit cleanout failures: buffer being written939333.330.000.000.000.010.04300.000.000.000.00
commit cleanout failures: callback failure94227141.490.010.02100.000.100.25150.000.000.000.00
commit cleanout failures: cannot pin4,9277,53852.990.770.60-22.085.478.3552.650.030.030.00
commit cleanouts757,2561,058,90239.83118.2483.96-28.99839.951,172.8439.634.134.11-0.48
commit cleanouts successfully completed752,2261,051,08839.73117.4583.34-29.04834.371,164.1939.534.104.08-0.49
commit immediate performed183383.330.000.000.000.020.04100.000.000.000.00
commit immediate requested183383.330.000.000.000.020.04100.000.000.000.00
commit txn count during cleanout47,75372,20651.217.465.72-23.3252.9779.9850.990.260.287.69
consistent changes100,357173,51872.9015.6713.76-12.19111.32192.1972.650.550.6721.82
consistent gets362,913,878581,211,84660.1556,665.0146,082.19-18.68402,544.37643,750.9659.921,977.342,253.7413.98
consistent gets - examination236,188,959379,363,28660.6236,878.3130,078.34-18.44261,980.99420,183.2560.391,286.881,471.0414.31
consistent gets from cache362,913,875581,211,84760.1556,665.0146,082.19-18.68402,544.37643,750.9759.921,977.342,253.7413.98
consistent gets from cache (fastpath)126,504,818201,512,17959.2919,752.3415,977.17-19.11140,319.25223,195.1459.06689.26781.3913.37
cursor authentications547840.000.000.000.000.010.05400.000.000.000.00
data blocks consistent reads - undo records applied90,673160,46376.9714.1612.72-10.17100.57177.7376.720.490.6226.53
db block gets3,483,0034,822,13238.45543.83382.33-29.703,863.355,341.0038.2518.9818.70-1.48
db block gets direct2760122.220.000.000.000.030.07133.330.000.000.00
db block gets from cache3,482,9764,822,07238.45543.83382.32-29.703,863.325,340.9338.2518.9818.70-1.48
db block gets from cache (fastpath)1,190,1041,653,62738.95185.82131.11-29.441,320.061,831.5638.756.486.41-1.08
deferred (CURRENT) block cleanout applications265,326371,81540.1441.4329.48-28.84294.30411.8239.931.451.44-0.69
dirty buffers inspected209,279363,77073.8232.6828.84-11.75232.13402.9173.571.141.4123.68
enqueue conversions579563-2.760.090.04-55.560.640.62-3.130.000.000.00
enqueue releases443,391619,92639.8169.2349.15-29.00491.81686.6339.612.422.40-0.83
enqueue requests443,403619,93439.8169.2349.15-29.00491.82686.6439.612.422.40-0.83
enqueue waits6911,26683.210.110.10-9.090.771.4081.820.000.000.00
free buffer inspected568,832865,51752.1688.8268.62-22.74630.95958.6551.943.103.368.39
free buffer requested584,574878,71350.3291.2769.67-23.67648.41973.2650.103.193.416.90
heap block compress57686550.170.090.07-22.220.640.9650.000.000.000.00
hot buffers moved to head of LRU267,499478,07478.7241.7737.90-9.27296.71529.5278.461.461.8526.71
immediate (CR) block cleanout applications25,09434,58337.813.922.74-30.1027.8338.3037.620.140.13-7.14
immediate (CURRENT) block cleanout applications29,43540,59737.924.603.22-30.0032.6544.9737.730.160.160.00
index fast full scans (full)220.000.000.000.000.000.000.000.000.000.00
index fetch by key58,944,68094,692,07860.659,203.567,507.79-18.4365,381.49104,881.0660.41321.16367.1814.33
index scans kdiixs158,760,49694,436,43860.719,174.817,487.52-18.3965,177.19104,597.9260.48320.16366.1914.38
leaf node 90-10 splits2018-10.000.000.000.000.020.020.000.000.000.00
leaf node splits1,6111,95821.540.250.16-36.001.792.1721.230.010.010.00
lob writes8011037.500.010.010.000.090.1233.330.000.000.00
lob writes unaligned8011037.500.010.010.000.090.1233.330.000.000.00
logical read bytes from cache3,001,522,946,0484,800,790,085,63259.95468,654,797.58380,637,283.69-18.783,329,291,715.435,317,361,079.8159.7116,353,864.8918,615,794.7913.83
max cf enq hold time1030200.000.000.000.000.010.03200.000.000.000.00
messages received207,981288,18438.5632.4722.85-29.63230.69319.1938.361.131.12-0.88
messages sent207,981288,18438.5632.4722.85-29.63230.69319.1938.361.131.12-0.88
min active SCN optimization applied on CR159,883225,82041.2424.9617.90-28.29177.34250.1241.040.870.881.15
no work - consistent read gets125,842,864200,598,43259.4019,648.9815,904.72-19.06139,585.01222,183.0759.17685.66777.8513.45
non-idle wait count2,527,0153,587,07441.95394.57284.41-27.922,802.973,973.0541.7413.7713.911.02
parse count (hard)53326,540.000.000.03100.000.010.373,600.000.000.000.00
parse time cpu1,8833,13966.700.290.25-13.792.093.4866.510.010.010.00
physical read IO requests521,753773,42948.2481.4761.32-24.73578.73856.6548.022.843.005.63
physical read bytes4,283,432,9606,341,222,40048.04668,810.95502,772.59-24.834,751,187.367,023,545.8347.8323,338.3824,589.065.36
physical read total IO requests524,482776,32048.0281.8961.55-24.84581.76859.8547.802.863.015.24
physical read total bytes4,327,405,5686,387,666,94447.61675,676.79506,455.01-25.044,799,961.817,074,987.8747.4023,577.9724,769.155.05
physical read total multi block requests52-60.000.000.000.000.010.00-100.000.000.000.00
physical reads cache522,825773,99348.0481.6361.37-24.82579.92857.2847.832.853.005.26
physical reads cache prefetch1,170676-42.220.180.05-72.221.300.75-42.310.010.00-100.00
physical reads direct558249.090.010.010.000.060.0950.000.000.000.00
physical write IO requests236,463383,68062.2636.9230.42-17.61262.28424.9662.031.291.4915.50
physical write bytes2,788,556,8004,275,765,24853.33435,402.48339,009.96-22.143,093,069.494,735,842.9253.1115,193.5116,579.939.13
physical write total IO requests597,121876,09846.7293.2369.46-25.50662.33970.3746.513.253.404.62
physical write total bytes3,655,349,2485,472,060,41649.70570,742.58433,859.88-23.984,054,516.396,060,860.9349.4819,916.2521,218.756.54
physical write total multi block requests1,099362-67.060.170.03-82.351.220.40-67.210.010.00-100.00
physical writes direct8213058.540.010.010.000.090.1455.560.000.000.00
physical writes from cache340,318521,81453.3353.1441.37-22.15377.48577.9653.111.852.029.19
physical writes non checkpoint268,955426,91758.7341.9933.85-19.39298.33472.8558.501.471.6612.93
pinned buffers inspected3995143.590.010.010.000.040.11175.000.000.000.00
prefetched blocks aged out before use12100.000.000.000.000.000.000.000.000.000.00
recursive calls193,830289,59849.4130.2622.96-24.12215.00320.7649.191.061.125.66
recursive cpu usage1,5362,36053.650.240.19-20.831.702.6153.530.010.010.00
redo blocks checksummed by FG (exclusive)292,518296,1161.2345.6723.48-48.59324.46327.981.081.591.15-27.67
redo blocks written826,7431,147,04538.74129.0990.95-29.55917.021,270.4738.544.504.45-1.11
redo buffer allocation retries174443154.600.030.0433.330.190.49157.890.000.000.00
redo entries649,8271,192,53683.52101.4694.55-6.81720.791,320.8583.253.544.6230.51
redo log space requests176471167.610.030.0433.330.200.52160.000.000.000.00
redo ordering marks6,11511,15982.490.950.88-7.376.7812.3682.300.030.0433.33
redo size for direct writes208780275.000.030.06100.000.230.86273.910.000.000.00
redo subscn max counts16,12528,53776.972.522.26-10.3217.8931.6176.690.090.1122.22
redo synch long waits187847352.940.030.07133.330.210.94347.620.000.000.00
redo synch time9,60126,962180.821.502.1442.6710.6529.86180.380.050.10100.00
redo synch time (usec)96,015,263269,626,508180.8214,991.7321,377.7142.60106,500.21298,638.66180.41523.141,045.5299.85
redo synch writes183,545257,92640.5228.6620.45-28.65203.59285.6840.321.001.000.00
redo wastage55,374,42470,121,08426.638,646.115,559.65-35.7061,421.3677,666.2026.45301.71271.91-9.88
redo write time5,26012,621139.940.821.0021.955.8313.98139.790.030.0566.67
redo writes178,894242,72835.6827.9319.25-31.08198.43268.8535.490.970.94-3.09
rollback changes - undo records applied48125160.420.010.010.000.050.14180.000.000.000.00
rollbacks only - consistent read gets19,77041,584110.343.093.306.8021.9346.06110.030.110.1645.45
rows fetched via callback58,794,76494,478,49660.699,180.167,490.86-18.4065,215.20104,644.5060.46320.34366.3514.36
session pga memory5,621,28036,228,832544.49877.702,872.45227.276,235.1340,127.10543.5630.63140.48358.64
session pga memory max12,223,36059,462,688386.471,908.544,714.58147.0313,558.1665,860.95385.7766.60230.58246.22
session uga memory4,295,894,7444,302,374,5680.15670,756.72341,119.72-49.144,765,009.984,765,315.430.0123,406.2816,683.11-28.72
session uga memory max25,936,85649,050,98489.124,049.753,889.08-3.9728,769.1854,328.9388.84141.32190.2034.59
shared hash latch upgrades - no wait309,676428,12438.2548.3533.94-29.80343.49474.1938.051.691.66-1.78
shared hash latch upgrades - wait305480.000.000.000.000.030.06100.000.000.000.00
sorts (memory)4452,106373.260.070.17142.860.492.33375.510.000.01100.00
sorts (rows)16,32227,41767.982.552.17-14.9018.1030.3767.790.090.1122.22
summed dirty queue length1,935,7983,184,84864.52302.25252.52-16.452,147.193,527.5464.2910.5512.3517.06
switch current to new buffer342712108.190.050.0620.000.380.79107.890.000.000.00
table fetch by rowid119,629,777191,823,39960.3518,678.8715,208.98-18.58132,693.45212,463.8460.12651.81743.8214.12
table scan blocks gotten6,180,6298,684,64940.51965.04688.57-28.656,855.569,619.1340.3133.6833.680.00
table scan rows gotten220,747,132310,139,84540.5034,467.2424,589.87-28.66244,852.90343,511.2840.291,202.751,202.61-0.01
table scans (short tables)220,455309,78940.5234.4224.56-28.65244.53343.1240.321.201.200.00
total cf enq hold time3,2504,93051.690.510.39-23.533.605.4651.670.020.020.00
total number of cf enq holders799013.920.010.010.000.090.1011.110.000.000.00
total number of times SMON posted284146.430.000.000.000.030.0566.670.000.000.00
transaction rollbacks1532113.330.000.000.000.020.04100.000.000.000.00
undo change vector size119,248,856164,305,73237.7818,619.4013,027.21-30.03132,270.93181,985.2337.59649.73637.12-1.94
write clones created in foreground123670444.720.020.05150.000.140.74428.570.000.000.00


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
4.586.7647.604.536.7148.120.000.000.003.875.7949.612.954.5353.560.000.000.000.901.2538.89


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
581.89861.4848.05578.79858.1748.270.060.0833.33662.44972.5446.81262.24425.9262.420.040.0525.00399.03545.4036.68


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
4.586.7647.604.536.7148.120.000.000.003.875.7949.612.954.5253.220.000.000.000.901.2437.78


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
581.88861.4748.05578.86858.2748.270.000.000.00662.45972.3046.77262.30425.7662.320.000.000.00398.78545.0636.68


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
SOE 576.60852.3947.83260.19420.8661.75519,831769,5808.7812.111.001.00234,576379,9763,2705,0128.3910.30836.791,273.25436.46
UNDOTBS1 0.090.1011.111.513.12106.6283896.0210.671.001.001,3632,817521130.190.271.603.221.61
SYSTEM 0.261.34415.380.030.0433.332301,21410.489.323.351.2726321630.002.380.281.381.10
SYSAUX 1.641.48-9.760.560.6719.641,4751,3336.396.881.401.24502609000.000.002.192.15-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
SOE+DATA/dbm11203/datafile/soe.486.836957131 576.60852.3947.83260.19420.8661.75519,831769,5808.7812.111.001.00234,576379,9763,2705,0128.3910.30836.791,273.25436.46
UNDOTBS1+DATA/dbm11203/datafile/undotbs1.461.772715929 0.090.1011.111.513.12106.6283896.0210.671.001.001,3632,817521130.190.271.603.221.61
SYSTEM+DATA/dbm11203/datafile/system.459.772715923 0.261.34415.380.030.0433.332301,21410.489.323.351.2726321630.002.380.281.381.10
SYSAUX+DATA/dbm11203/datafile/sysaux.460.772715927 1.641.48-9.760.560.6719.641,4751,3336.396.881.401.24502609000.000.002.192.15-0.04


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
SOE+DATA/dbm11203/datafile/soe.486.836957131 71.2973.922.638.7812.11519,831769,580576.60852.391.001.00234,576379,976260.19420.863,2705,0120.841.03
SYSAUX+DATA/dbm11203/datafile/sysaux.460.772715927 0.150.07-0.076.396.881,4751,3331.641.481.401.245026090.560.67000.000.00
SYSTEM+DATA/dbm11203/datafile/system.459.772715923 0.040.090.0510.489.322301,2140.261.343.351.2726320.030.041630.000.24
UNDOTBS1+DATA/dbm11203/datafile/undotbs1.461.772715929 0.010.01-0.006.0210.6783890.090.101.001.001,3632,8171.513.12521130.020.03


Back to IO Stats
Back to Top

Top File Comparison by Buffer Waits

  Wait Time % of DB time Buffer Waits Avg Buf Wait Time (ms) Reads Avg Reads per Sec Avg Read Time (ms) Avg Blocks per Read Writes Avg Writes per Sec
TablespaceFilename1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
SOE+DATA/dbm11203/datafile/soe.486.836957131 0.430.41-0.023,2705,0120.841.03519,831769,580576.60852.398.7812.111.001.00234,576379,976260421


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)
B101920,987167,937165,888165,888445,422   
E101921,454167,685165,888165,888384,637   
           
B201816,165167,866165,888165,888417,367   
E201816,018169,373165,888165,888413,717   


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.0011,6846,084-47.937173000.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)
B11288178.20.00.00.00.026,214
E11288181.20.00.00.00.026,214
         
B21288184.90.00.00.00.026,214
E21288217.00.00.00.00.026,214


Back to Advisory Statistics
Back to Top

Wait Stats

Back to Top

Buffer Wait Statistics

 Wait Time % of DB time Total Wait Time (s) # Waits Avg Wait Time (ms)
Class1st2ndDiff1st2nd1st2nd1st2nd%Diff
data block0.000.00-0.0027.4451.563,2755,0280.080.1025.00
segment header0.000.000.000.000.090220.000.04100.00
3rd level bmb0.000.000.000.000.040110.000.04100.00
2nd level bmb0.000.000.000.000.03090.000.03100.00
undo header0.000.000.000.000.0228440.000.000.00
undo block0.000.00-0.000.010.0124690.000.000.00
1st level bmb0.000.000.000.000.00020.000.000.00


Back to Wait Stats
Back to Top

Enqueue Activity

 Wait Time % of DB time Wait Time Requests Successful Gets Failed Gets Waits Avg Wait Time (ms)
Enqueue Type (Request Reason)1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
TX-Transaction (row lock contention)0.010.020.01126861,2366861,236006841,2301.171.80


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
1st31.79369,8479392019.6/29.70/00/0/0/0/0/0
2nd41.51489,0559383119.6/29.60/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
In memory undo latch21.4712.98-8.491,305,4401,391,68127739512014015825719,00745,25826,251
cache buffers chains61.1468.437.29505,924,400804,374,724239,9951,488,116239,5451,486,7614501,35555,570338,795283,225
simulator hash latch2.995.052.0621,646,93034,366,8491,5074,3161,4854,217221009,841100,03090,189
session idle bit4.352.73-1.625,405,4877,568,1214381,2814061,22732545,56526,21220,647
object queue header operation1.902.730.832,330,8543,523,0234501,1464361,09314543,49616,29412,798
redo allocation1.492.220.73900,5471,141,7123161,02230597811441,76212,28910,527
shared pool0.000.710.712,35032,027356350014017,88317,883
enqueue hash chains1.901.41-0.49888,0711,240,95722745921343114283,1548,7625,608
row cache objects0.000.400.408,35055,2382602520802,2422,242
mostly latch-free SCN1.771.46-0.30182,081247,78863595862292913294,9304,677-253
cache buffers lru chain1.361.16-0.20451,916703,39018143217141010238945,5374,643
DML lock allocation0.540.35-0.19498,223698,72643843977476402,2911,651
messages0.270.15-0.12616,540852,99411525311325023338569231
undo global data0.410.30-0.101,065,4911,411,9787326670260366751,061386
Consistent RBA0.000.100.10178,907242,58103010201,6631,663
redo writing0.000.100.10566,775775,99219491947020698698
sequence cache0.000.100.10154,907216,62523952393020111111
session allocation0.000.100.10183,644257,90019571955020335335
checkpoint queue latch0.140.05-0.091,348,9252,062,78041124401231113435-99
ASM map operation hash table0.000.050.052,245,3333,306,049114113010243243
post/wait queue0.000.050.05271,590373,24031493148010410410
simulator lru latch0.410.450.0520,84332,455148413145404393,9679,4345,467


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
cache buffers chains55,570338,795283,225505,924,400804,374,724239,9951,488,116239,5451,486,7614501,35561.1468.437.29
simulator hash latch9,841100,03090,18921,646,93034,366,8491,5074,3161,4854,217221002.995.052.06
In memory undo latch19,00745,25826,2511,305,4401,391,68127739512014015825721.4712.98-8.49
session idle bit5,56526,21220,6475,405,4877,568,1214381,2814061,22732544.352.73-1.62
shared pool017,88317,8832,35032,0273563500140.000.710.71
object queue header operation3,49616,29412,7982,330,8543,523,0234501,1464361,09314541.902.730.83
redo allocation1,76212,28910,527900,5471,141,7123161,02230597811441.492.220.73
enqueue hash chains3,1548,7625,608888,0711,240,95722745921343114281.901.41-0.49
simulator lru latch3,9679,4345,46720,84332,455148413145404390.410.450.05
cache buffers lru chain8945,5374,643451,916703,39018143217141010231.361.16-0.20
row cache objects02,2422,2428,35055,238260252080.000.400.40
Consistent RBA01,6631,663178,907242,5810301020.000.100.10
DML lock allocation6402,2911,651498,223698,72643843977470.540.35-0.19
redo writing0698698566,775775,99219491947020.000.100.10
post/wait queue0410410271,590373,24031493148010.000.050.05
undo global data6751,0613861,065,4911,411,9787326670260360.410.30-0.10
session allocation0335335183,644257,90019571955020.000.100.10
mostly latch-free SCN4,9304,677-253182,081247,78863595862292913291.771.46-0.30
ASM map operation hash table02432432,245,3333,306,049114113010.000.050.05
messages338569231616,540852,994115253113250230.270.15-0.12
sequence cache0111111154,907216,62523952393020.000.100.10
checkpoint queue latch13435-991,348,9252,062,7804112440123110.140.05-0.09


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
SOESOEPRODUCT_INFORMATION TABLE1.891.891.661.66-0.236,935,3129,718,81640.141.901.67-0.23
SOESOECUSTOMERS TABLE15.9517.8416.0617.720.1258,425,95294,131,21661.1115.9816.150.17
SOESOECUSTOMERS_PK INDEX32.0349.8732.0649.780.03117,354,960187,892,78460.1132.0932.240.15
SOESOEITEM_ORDER_IX INDEX32.1382.0032.1081.88-0.03117,716,448188,119,18459.8132.1932.280.09
SOESOEORDERS TABLE16.0198.0116.0097.88-0.0158,667,76093,754,88059.8116.0416.090.04


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
SOESOECUSTOMERS_PK INDEX19.7919.7918.1218.12-1.67103,490140,24835.5219.8718.23-1.64
SOESOEINVENTORIES TABLE9.1228.9110.5528.671.4347,66781,65571.309.1510.611.46
SOESOECUSTOMERS TABLE20.5249.4319.1947.86-1.33107,285148,56638.4820.6019.31-1.29
SOESOEORD_CUSTOMER_IX INDEX12.5962.0112.0059.86-0.5965,81692,87441.1112.6412.07-0.57
SOESOEITEM_ORDER_IX INDEX8.8570.878.3668.21-0.5046,28564,68439.758.898.41-0.48


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
SOESOECUSTOMERS_PK INDEX19.8419.8418.1318.13-1.70103,490140,24935.5219.9018.24-1.66
SOESOEINVENTORIES TABLE9.1428.9710.5628.691.4247,66781,65571.309.1710.621.45
SOESOECUSTOMERS TABLE20.5649.5319.2147.90-1.35107,283148,56338.4820.6319.32-1.31
SOESOEORD_CUSTOMER_IX INDEX12.6162.1512.0159.91-0.6165,81692,87441.1112.6612.08-0.58
SOESOEITEM_ORDER_IX INDEX8.8771.028.3668.27-0.5146,28564,68239.758.908.41-0.49


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
SOESOECUSTOMERS_PK INDEX19.8419.8418.1318.13-1.70103,490140,24935.5219.9018.24-1.66
SOESOEINVENTORIES TABLE9.1428.9710.5628.691.4247,66781,65571.309.1710.621.45
SOESOECUSTOMERS TABLE20.5649.5319.2147.90-1.35107,283148,56338.4820.6319.32-1.31
SOESOEORD_CUSTOMER_IX INDEX12.6162.1512.0159.91-0.6165,81692,87441.1112.6612.08-0.58
SOESOEITEM_ORDER_IX INDEX8.8771.028.3668.27-0.5146,28564,68239.758.908.41-0.49


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
SYSSYSTEMAUD$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMCCOL$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_CCOL2 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_HH_OBJ#_INTCOL# INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_JOB_NEXT INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMSCHEDULER$_JOB TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSAUXSMON_SCN_TIME TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS TABLE0.000.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Reads

     % of Total Direct Reads Direct Reads % of Captured Direct Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMAUD$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMCCOL$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_CCOL2 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_HH_OBJ#_INTCOL# INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_JOB_NEXT INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMSCHEDULER$_JOB TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSAUXSMON_SCN_TIME TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS TABLE0.000.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Writes

     % of Total Physical Writes Physical Writes % of Captured Physical Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SOESOEITEM_PRODUCT_IX INDEX8.778.7712.0812.083.3129,85463,064111.249.2412.723.48
SOESOEORDER_PK INDEX10.8119.589.8821.97-0.9336,81051,58740.1411.4010.40-0.99
SOESOEITEM_ORDER_IX INDEX9.5829.178.7230.69-0.8632,62245,51739.5310.109.18-0.92
SOESOEORDER_ITEMS_PK INDEX9.5638.738.7239.40-0.8432,53645,49039.8110.079.17-0.90
SOESOEORD_CUSTOMER_IX INDEX10.3849.109.6049.00-0.7835,32150,08741.8110.9410.10-0.83
SOESOEORD_WAREHOUSE_IX INDEX8.1757.278.9157.900.7327,81846,48367.108.619.380.76
SOESOEINVENTORIES TABLE20.0877.3520.0677.96-0.0268,342104,69353.1921.1621.12-0.04


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
SOESOEINVENTORIES TABLE15.6015.6017.7817.782.1836,88968,21584.9215.7417.972.24
SOESOEORDER_PK INDEX14.6130.2113.0730.85-1.5534,55550,13645.0914.7413.21-1.53
SOESOEORD_CUSTOMER_IX INDEX13.7143.9312.3443.19-1.3732,42447,34846.0313.8312.48-1.36
SOESOEITEM_ORDER_IX INDEX12.4756.3911.2054.38-1.2729,47742,96445.7512.5811.32-1.26
SOESOEORDER_ITEMS_PK INDEX12.7069.0911.5265.90-1.1830,01944,18447.1912.8111.64-1.17


Back to Segment Statistics
Back to Top

Top Segments Comparison by Direct Physical Writes

     % of Total Direct Writes Direct Writes % of Captured Direct Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSAUXSYS_LOB0000006339C00038$$ LOB0.000.009.239.239.23012100.000.0020.3420.34
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_2532911053_1819TABLE PARTITION32.9332.9336.1545.383.23274774.07100.0079.66-20.34
SYSSYSTEMCCOL$ TABLE  0.0045.380.00 0  0.000.00
SYSSYSTEMI_CCOL2 INDEX  0.0045.380.00 0  0.000.00
SYSSYSTEMI_JOB_NEXT INDEX0.0032.93  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX  0.0045.380.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE0.0032.93  0.000 100.000.00 0.00
SYSSYSAUXSMON_SCN_TIME TABLE0.0032.93  0.000 100.000.00 0.00
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS TABLE0.0032.93  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Table Scans

     % of Total Table Scans Table Scans % of Captured Table Scans
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSSYSTEMAUD$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMCCOL$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_CCOL2 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_HH_OBJ#_INTCOL# INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_JOB_NEXT INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMOBJ$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMSCHEDULER$_JOB TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSAUXSMON_SCN_TIME TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSAUXWRI$_ADV_MESSAGE_GROUPS TABLE0.000.00  0.000 100.000.00 0.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by DB Block Changes

     % of Total Block Changes DB Block Changes % of Captured Block Changes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SOESOEORDERS TABLE2.772.774.454.451.6970,528158,800125.1613.6715.441.77
SOESOEORD_WAREHOUSE_IX INDEX3.135.904.448.901.3179,824158,33698.3615.4715.39-0.08
SOESOEITEM_ORDER_IX INDEX2.488.383.6312.521.1563,184129,296104.6312.2412.570.33
SOESOEINVENTORIES TABLE2.5410.922.9915.510.4564,816106,59264.4512.5610.36-2.20
SOESOEORDER_ITEMS TABLE3.5814.503.6219.130.0491,216128,96041.3817.6812.54-5.14


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
SOESOEORDERS TABLE100.1599.76-0.396851,22779.1256.9456.9474.6874.6817.74
SOESOEORD_ORDER_DATE_IX INDEX42.6911.71-30.98292144-50.6824.2781.218.7683.44-15.51
SOESOEORD_WAREHOUSE_IX INDEX5.128.463.3435104197.142.9184.126.3389.773.42
SOESOEITEM_PRODUCT_IX INDEX14.046.42-7.619679-17.717.9892.104.8194.58-3.17
SOESOECUST_LNAME_IX INDEX3.51 -3.5124  2.0094.10  -2.00
SOESOECUST_ACCOUNT_MANAGER_IX INDEX 1.791.79 22   1.3495.921.34


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
SOESOEORDERS TABLE88.8388.8381.8281.82-7.0133452256.2996.5392.72-3.81
SOESOEORD_ORDER_DATE_IX INDEX0.8089.632.0483.861.24313333.330.872.311.44
SOESOECUSTOMERS_PK INDEX1.0690.690.0083.86-1.0640-100.001.160.00-1.16
SYSSYSTEMAUD$ TABLE  0.9484.800.94 6  1.071.07
SOESOEORDER_ITEMS TABLE0.2790.960.7885.580.5215400.000.290.890.60
SOESOEORDER_PK INDEX0.5391.490.7886.360.2525150.000.580.890.31
SOESOEITEM_ORDER_IX INDEX0.5392.020.4786.83-0.062350.000.580.53-0.05


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.000.000.000.020.020.0019190.000.00000.000.002211
dc_global_oids0.000.000.000.010.06500.007530.005.66000.000.00002424
dc_histogram_data0.010.222,100.000.093.073,311.11782,76944.8715.31000.000.00002,0002,149
dc_histogram_defs0.010.434,200.000.055.9711,840.00415,38712.2029.03000.000.00002,0242,942
dc_object_grants0.000.000.000.000.000.00020.0050.00000.000.0000510
dc_objects0.040.22450.000.253.061,124.002292,7590.447.29000.000.00111,5011,264
dc_profiles0.000.000.000.000.02100.002170.000.00000.000.000011
dc_rollback_segments0.150.08-46.671.071.1810.289631,0680.000.00000.000.00007878
dc_segments0.020.10400.000.131.39969.231211,2530.008.70000.000.001015614463
dc_sequences0.000.000.000.010.02100.0010140.0042.86000.000.00101457
dc_tablespaces0.080.22175.000.563.07448.215062,7690.000.00000.000.000077
dc_users0.040.23475.000.263.281,161.542342,9600.000.71000.000.00004622
global database name0.100.05-50.000.680.702.946126290.000.00000.000.000011
outstanding_alerts0.000.000.000.010.010.00880.000.00000.000.000044
sch_lj_oids0.000.000.000.000.000.00220.000.00000.000.000011



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.000.000.000.000.03100.00030 3.3300  0000
BODY0.000.000.000.020.0350.0015300.006.6744590.005.080100
CLUSTER0.000.000.000.000.04100.002360.002.782360.002.780000
DBLINK0.000.000.000.000.03100.001310.003.2300  0000
EDITION0.000.000.000.010.03200.008230.000.008380.007.890000
INDEX0.000.000.000.000.02100.00015 6.67015 6.670000
QUEUE0.040.02-50.000.290.290.002622660.000.002622660.000.000000
SCHEMA0.000.01100.000.000.18100.0011600.000.0000  0000
SQL AREA0.060.12100.000.411.63297.563721,4701.088.911,230,4631,728,755-0.020.02121100
SQL AREA BUILD0.000.03100.000.010.393,800.005350100.0083.7100  0000
SQL AREA STATS0.000.02100.000.010.333,200.00530080.0054.00530080.0054.000000
TABLE/PROCEDURE0.000.11100.000.031.565,100.00271,4050.008.83103,351147,4550.000.67146800



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)24,128.0024,704.002.3925,984.0026,816.003.207.698.55
Used (KB)0.000.000.000.000.000.000.000.00
Avg Alloc (KB)832.00796.90-4.22812.00812.610.07-2.401.97
Std Dev Alloc (KB)466.24434.02-6.91429.31438.322.10-7.920.99
Max Alloc (KB)1,792.001,152.00-35.711,152.001,152.000.00-35.710.00
Hist Max Alloc (KB)        
Num Procs29.0031.006.9032.0033.003.1310.346.45
Num Alloc29.0031.006.9032.0033.003.1310.346.45
OtherAlloc (KB)155,103.87157,590.881.60158,156.20189,296.5519.691.9720.12
Used (KB)        
Avg Alloc (KB)2,674.202,671.03-0.122,680.612,558.06-4.570.24-4.23
Std Dev Alloc (KB)2,474.612,455.54-0.772,469.082,220.21-10.08-0.22-9.58
Max Alloc (KB)14,327.9814,647.980.0014,647.9814,647.980.002.232.23
Hist Max Alloc (KB)25,911.9825,911.980.0025,911.9825,911.980.000.000.00
Num Procs58.0059.001.7259.0074.0025.421.7225.42
Num Alloc58.0059.001.7259.0074.0025.421.7225.42
PL/SQLAlloc (KB)2,467.142,469.100.084,171.004,537.888.8069.0683.79
Used (KB)2,139.152,139.370.012,469.052,745.8411.2115.4228.35
Avg Alloc (KB)42.5441.85-1.6270.6961.32-13.2666.2046.53
Std Dev Alloc (KB)181.40179.90-0.82377.19336.73-10.73107.9487.18
Max Alloc (KB)1,377.022,903.630.002,903.632,903.630.00110.86110.86
Hist Max Alloc (KB)1,751.771,751.770.003,820.803,820.800.00118.11118.11
Num Procs58.0059.001.7259.0074.0025.421.7225.42
Num Alloc58.0059.001.7259.0074.0025.421.7225.42
SQLAlloc (KB)839.35833.34-0.721,070.301,605.1049.9727.5192.61
Used (KB)94.5692.43-2.26133.24117.38-11.9040.9027.00
Avg Alloc (KB)20.9820.33-3.1426.1029.1811.7924.4043.58
Std Dev Alloc (KB)29.9330.040.3835.6932.51-8.9019.248.21
Max Alloc (KB)165.77153.840.00153.84153.840.00-7.20-7.20
Hist Max Alloc (KB)9,671.649,671.640.005,335.065,335.060.00-44.84-44.84
Num Procs40.0041.002.5041.0055.0034.152.5034.15
Num Alloc36.0036.000.0037.0051.0037.842.7841.67


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 Buffers745,472.00745,472.000.00745,472.00745,472.000.000.000.00
Fixed Size2,182.822,182.820.002,182.822,182.820.000.000.00
Redo Buffers9,508.009,508.000.009,508.009,508.000.000.000.00
Variable Size286,721.18286,721.180.00286,721.18286,721.180.000.000.00


Back to Memory Statistics
Back to Top

SGA Breakdown Difference

  1st 2nd %Diff of
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
java poolfree memory4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
large poolASM map operations hashta393,216393,2160.00393,216393,2160.000.000.00
large poolPX msg pool3,894,3043,894,3040.003,894,3043,894,3040.000.000.00
large poolfree memory4,101,0884,101,0880.004,101,0884,101,0880.000.000.00
shared poolASH buffers16,777,21616,777,2160.0016,777,21616,777,2160.000.000.00
shared poolKCB Table Scan Buffer3,981,1203,981,1200.003,981,1203,981,1200.000.000.00
shared poolKGLH019,337,41619,329,344-0.0419,305,40817,465,064-9.53-0.17-9.64
shared poolKGLHD3,996,7844,004,7040.204,035,6563,361,472-16.710.97-16.06
shared poolKGLS4,575,6084,579,6560.095,113,4085,132,4240.3711.7512.07
shared poolKGLSG5,266,0085,266,0080.005,266,0085,266,0080.000.000.00
shared poolKKSSP2,854,6882,894,9841.412,916,0883,738,21628.192.1529.13
shared poolKSFD SGA I/O b3,977,1443,977,1440.003,977,1443,977,1440.000.000.00
shared poolPLMCD3,354,0323,354,0320.004,258,776  26.97 
shared poolSQLA23,338,81623,407,9200.3045,819,29622,795,944-50.2596.32-2.61
shared pooldb_block_hash_buckets5,836,8005,836,8000.005,836,8005,836,8000.000.000.00
shared pooldbwriter coalesce buffer3,979,2643,979,2640.003,979,2643,979,2640.000.000.00
shared pooldirty object counts array4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
shared poolevent statistics per sess3,245,8243,245,8240.003,245,8243,245,8240.000.000.00
shared poolfree memory91,372,76891,214,776-0.1769,082,34494,734,71237.13-24.403.86
shared poolkglsim hash table bkts4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
shared poolksunfy : SSO free list3,025,6003,025,6000.003,025,6003,025,6000.000.000.00
shared poolprivate strands3,677,1843,677,1840.003,677,1843,677,1840.000.000.00
shared poolrow cache7,593,7047,593,7040.007,593,7047,593,7040.000.000.00
shared poolwrite state object3,853,6803,853,6800.003,853,6803,853,6800.000.000.00
streams poolfree memory8,376,4408,376,4400.008,376,4408,376,4400.000.000.00
 buffer_cache763,363,328763,363,3280.00763,363,328763,363,3280.000.000.00
 fixed_sga2,235,2082,235,2080.002,235,2082,235,2080.000.000.00
 log_buffer9,736,1929,736,1920.009,736,1929,736,1920.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.00199.800.000.000.000.000.000.00
QMON Slaves0.020.0226.310.050.13181.880.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.050.000.050.130.000.13181.880.020.0226.31
QMON Coordinator0.000.000.000.000.000.000.000.000.00199.80


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

 Enq Msgs Enq Msgs/sec Deq Msgs Deq Msgs/sec Spill Msgs Spill Msgs/sec %Spill Msgs
Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd
SYS.SCHEDULER$_EVENT_QUEUE(12613) 000.000.000.000.00000.000.000.000.00000.000.000.000.00  


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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

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
audit_file_dest /u00/app/oracle/admin/DBM11203/a  
audit_trail DB  
control_files +DATA/dbm11203/controlfile/curre  
core_dump_dest /u00/app/oracle/diag/rdbms/dbm11  
cursor_sharing EXACT  
db_block_size 8192  
db_create_file_dest +DATA  
db_domain antognini.ch  
db_name DBM11203  
db_recovery_file_dest +FRA  
db_recovery_file_dest_size 2147483648  
diagnostic_dest /u00/app/oracle  
local_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=  
log_buffer 8183808  
open_cursors 30  
optimizer_dynamic_sampling 2  
optimizer_mode ALL_ROWS  
pga_aggregate_target 134217728  
plsql_warnings DISABLE:ALL  
processes 150  
query_rewrite_enabled TRUE  
remote_login_passwordfile EXCLUSIVE  
result_cache_max_size 2031616  
sga_target 1073741824  
skip_unusable_indexes TRUE  
undo_tablespace UNDOTBS1  
user_dump_dest /u00/app/oracle/diag/rdbms/dbm11  


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  +DATA/dbm11203/controlfile/current.455.772715921    
  +FRA/dbm11203/controlfile/current.332.772715921    


Back to init.ora Parameters
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01gmsncqrjrfrinsert into WRH$_BUFFERED_QUEUES (snap_id, dbid, instance_number, queue_schema, queue_name, startup_time, queue_id, num_msgs, spill_msgs, cnum_msgs, cspill_msgs, expired_msgs, oldest_msgid, oldest_msg_enqtm, queue_state, elapsed_enqueue_time, elapsed_dequeue_time, elapsed_transformation_time, elapsed_rule_evaluation_time, enqueue_cpu_time, dequeue_cpu_time, last_enqueue_time, last_dequeue_time) select * from (select :snap_id, :dbid, :instance_number, qs.queue_schema, qs.queue_name, qs.startup_time, qs.queue_id, qs.num_msgs, qs.spill_msgs, qs.cnum_msgs, qs.cspill_msgs, qs.expired_msgs, qs.oldest_msgid, qs.oldest_msg_enqtm, qs.queue_state, qs.elapsed_enqueue_time, qs.elapsed_dequeue_time, qs.elapsed_transformation_time, qs.elapsed_rule_evaluation_time, qs.enqueue_cpu_time, qs.dequeue_cpu_time, qs.last_enqueue_time, qs.last_dequeue_time from v$buffered_queues qs order by qs.num_msgs desc) where rownum <= 25
0bma28usvnqt1SELECT text.sql_id FROM WRH$_SQLTEXT text WHERE text.dbid = :dbid AND text.sql_id in (:sqlid0, :sqlid1, :sqlid2, :sqlid3, :sqlid4, :sqlid5, :sqlid6, :sqlid7)
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kkhhb2w93cx0update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
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')
14wnf35dahb7vSELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1
18c2yb5aj919t SELECT nvl(e1, 0) as e1, nvl(e2, 0) as e2, nvl(e3, 0) as e3, nvl(e4, 0) as e4, nvl(e5, 0) as e5, nvl(e6, 0) as e6 FROM (SELECT e.event_id as event_id, e.event_name as event_name FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid AND e.event_name in ('log file sync', 'gc buffer busy', 'gc buffer busy acquire', 'gc buffer busy release', 'Streams: resolve low memory condition', 'Streams capture: resolve low memory condition') ) PIVOT (max(event_id) FOR event_name IN ('log file sync' as e1, 'gc buffer busy' as e2, 'gc buffer busy acquire' as e3, 'gc buffer busy release' as e4, 'Streams: resolve low memory condition' as e5, 'Streams capture: resolve low memory condition' as e6) )
1bumcaqpc58vjINSERT INTO STATS$STREAMS_CAPTURE ( SNAP_ID , DBID , INSTANCE_NUMBER , CAPTURE_NAME , STARTUP_TIME , TOTAL_MESSAGES_CAPTURED , TOTAL_MESSAGES_ENQUEUED , ELAPSED_CAPTURE_TIME , ELAPSED_RULE_TIME , ELAPSED_ENQUEUE_TIME , ELAPSED_LCR_TIME , ELAPSED_REDO_WAIT_TIME , ELAPSED_PAUSE_TIME ) SELECT :B3 , :B2 , :B1 , CAPTURE_NAME , STARTUP_TIME , TOTAL_MESSAGES_CAPTURED , TOTAL_MESSAGES_ENQUEUED , ELAPSED_CAPTURE_TIME , ELAPSED_RULE_TIME , ELAPSED_ENQUEUE_TIME , ELAPSED_LCR_TIME , ELAPSED_REDO_WAIT_TIME , ELAPSED_PAUSE_TIME FROM V$STREAMS_CAPTURE
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)
1crajpb7j5tyzINSERT INTO STATS$SGA_TARGET_ADVICE ( SNAP_ID , DBID , INSTANCE_NUMBER , SGA_SIZE , SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS ) SELECT :B3 , :B2 , :B1 , SGA_SIZE , SGA_SIZE_FACTOR , ESTD_DB_TIME , ESTD_DB_TIME_FACTOR , ESTD_PHYSICAL_READS FROM V$SGA_TARGET_ADVICE
1gfaj4z5hn1kfdelete from dependency$ where d_obj#=:1
1p36ta7p3d7fuselect file#, block#, ts#, blocks from seg$ where type# = 3
20vv6ttajyjzqdelete from access$ where d_obj#=:1
23buxzfxyp1vy SELECT greatest(0, 1000*servicetime - req*:expio ) as impact FROM ( SELECT sum( case when iostat.snap_id = :eid then iostat.small_read_reqs else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_reqs else 0 end) as req, sum( case when iostat.snap_id = :eid then iostat.small_read_servicetime else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_servicetime else 0 end) as servicetime FROM WRH$_IOSTAT_FILETYPE iostat, WRH$_IOSTAT_FILETYPE_NAME fn WHERE iostat.dbid = fn.dbid AND iostat.filetype_id = fn.filetype_id AND (fn.filetype_name = 'Data File' OR fn.filetype_name = 'Temp File') AND iostat.dbid = :dbid AND iostat.instance_number = :inst AND iostat.snap_id IN (:bid, :eid) )
23nad9x295gkfSELECT (m.current_size / 1048576) as sizemb, case when cast(m.last_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as changed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT buffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DEFAULT 8K buffer cache', 6, 'DEFAULT 16K buffer cache', 7, 'DEFAULT 32K buffer cache', 8, 'SGA Target', 9, 'PGA Target', 10, 'memory target', 11 , 255) as comp_id FROM WRH$_MEM_DYNAMIC_COMP m , WRM$_SNAPSHOT s WHERE m.dbid = :dbid AND m.instance_number = :inst_num AND m.snap_id = :end_snap_id AND s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id = :begin_snap_id
2pff93c8c626vselect name, address, protocol, subscriber_type, subscriber_id from "SYS"."AQ$_SCHEDULER$_EVENT_QTAB_S" where queue_name = :1 and (bitand(subscriber_type, 4096) = 4096)
2yp5w5a36s5xvupdate orders set order_mode = :1 , order_status = :2 , order_total = :3 where order_id = :4
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)
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
4g46czps3t55u SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_id )
4kt3cun8s5fp5select name, password, datats#, tempts#, type#, defrole, resource$, ptime, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1, spare4, ext_username, spare2 from user$ where user#=:1
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4vs91dcv7u1p6insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5d8b4p888x97aselect customer_seq.nextval from dual
5dyhfnkzta2zmWITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_instance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
5g00dq4fxwnswupdate inventories set quantity_on_hand = quantity_on_hand - :1 where product_id = :2 and warehouse_id = :3
5h91zx386wbhtWITH awr_params as ( SELECT /*+ NO_MERGE(map) USE_HASH(map) */ p.parameter_hash as parameter_hash, max(map.parameter_name) as parameter_name, max (map.keh_id) as keh_id, max (case when p.snap_id = :bid then upper(p.value) else null end) as first_value, max (case when p.snap_id = :eid then upper(p.value) else null end) as last_value, max (case when p.isdefault = 'TRUE' then upper(p.value) else null end) as default_value, max (upper(p.value)) as max_value, min (upper(p.value)) as min_value, max (case when p.snap_id = :bid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as first_is_mod, max (case when p.snap_id = :eid then decode(p.ismodified, 'FALSE', 0, 'MODIFIED', 1, 4) else null end) as last_is_mod FROM ( SELECT /*+ USE_HASH(xmap) */ xmap.keh_id as keh_id, xmap.parameter_hash as parameter_hash, pn.parameter_name as parameter_name FROM X$KEHPRMMAP xmap , WRH$_PARAMETER_NAME pn WHERE pn.dbid = :dbid AND pn.parameter_hash = xmap.parameter_hash ) map, WRH$_PARAMETER p WHERE p.parameter_hash = map.parameter_hash AND p.dbid = :dbid AND p.instance_number = :inst AND p.snap_id >= :bid AND p.snap_id <= :eid GROUP BY p.parameter_hash ), def_params as (SELECT p.hash as parameter_hash, p.name as parameter_name, x.keh_id as keh_id, decode(p.name, 'db_block_size', '8192', 'gcs_server_processes', '1', 'disk_asynch_io', 'TRUE', '0') as value FROM X$KEHPRMMAP x , V$PARAMETER p WHERE x.parameter_hash = p.hash AND (p.name like '%size' OR p.name like '%target' OR p.name in ('gcs_server_processes', 'disk_asynch_io')) ) SELECT parameter_hash, nvl(a.parameter_name, p.parameter_name) as pname, nvl(a.keh_id, p.keh_id) as keh_id, case when a.keh_id is null then p.value else a.first_value end as first_value, case when a.keh_id is null then p.value else a.last_value end as last_value, case when a.keh_id is null then p.value else a.default_value end as default_value, case when a.keh_id is null then p.value else a.max_value end as min_value, case when a.keh_id is null then p.value else a.min_value end as min_value, case when a.keh_id is null then 0 else a.first_is_mod end as first_is_mod, case when a.keh_id is null then 0 else a.last_is_mod end as last_is_mod FROM awr_params a full outer join def_params p using(parameter_hash)
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
5uw1u291s3m0kSELECT case when cnt = 0 then 0 else (1000000 * total) / cnt end FROM ( SELECT SUM(m.num_interval) AS cnt, SUM(m.num_interval * m.average) AS total FROM WRH$_SYSMETRIC_SUMMARY m , WRH$_METRIC_NAME n WHERE m.dbid = :dbid and m.instance_number = :inst_num and m.snap_id > :begin_snap_id and m.snap_id <= :end_snap_id and m.metric_id = n.metric_id and n.dbid = :dbid and n.metric_name = 'Current OS Load' )
6abthk1u14yb7SELECT VERSION FROM V$INSTANCE
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6cp74g22fzahf WITH ash as (SELECT ash.event_id, sum(decode(ash.session_type, 1, 1, 0)) as cnt_fg, count(*) as cnt_total FROM WRH$_ACTIVE_SESSION_HISTORY ash WHERE ash.dbid = :dbid AND ash.instance_number = :inst AND ash.snap_id > :bid AND ash.snap_id <= :eid AND ash.wait_time = 0 GROUP BY ash.event_id ), evts as (SELECT event_id, sum(w_cnt) as w_cnt, sum(to_cnt) as to_cnt, sum(w_time) as w_time , sum(w_cnt_fg) as w_cnt_fg, sum(to_cnt_fg) as to_cnt_fg, sum(w_time_fg) as w_time_fg FROM (SELECT es.event_id as event_id, es.total_waits - nvl(bs.total_waits, 0) as w_cnt, es.TOTAL_TIMEOUTS - nvl(bs.TOTAL_TIMEOUTS, 0) as to_cnt, es.TIME_WAITED_MICRO - nvl(bs.TIME_WAITED_MICRO, 0) as w_time , es.total_waits_fg - nvl(bs.total_waits_fg, 0) as w_cnt_fg, es.TOTAL_TIMEOUTS_FG - nvl(bs.TOTAL_TIMEOUTS_FG, 0) as to_cnt_fg, es.TIME_WAITED_MICRO_FG - nvl(bs.TIME_WAITED_MICRO_FG, 0) as w_time_fg FROM WRH$_SYSTEM_EVENT es , WRH$_SYSTEM_EVENT bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid(+) = :dbid AND bs.instance_number(+) = es.instance_number AND bs.snap_id(+) = :bid AND es.instance_number = bs.instance_number(+) AND es.event_id = bs.event_id(+) UNION ALL SELECT x.event_hash as event_id, 0 as w_cnt, 0 as to_cnt, 0 as w_time , 0 as w_cnt_fg, 0 as to_cnt_fg, 0 as w_time_fg FROM X$KEHEVTMAP x ) GROUP BY event_id ), awr_names as (SELECT e.event_id, e.event_name, e.wait_class_id, e.parameter1, e.parameter2, e.parameter3 FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid ), named_events as (SELECT names.event_id as event_id, names.event_name as event_name, evts.w_cnt as w_cnt, evts.to_cnt as to_cnt, evts.w_time as w_time, evts.w_cnt_fg as w_cnt_fg, evts.to_cnt_fg as to_cnt_fg, evts.w_time_fg as w_time_fg, names.wait_class_id as wait_class_id, names.parameter1 as p1, names.parameter2 as p2, names.parameter3 as p3 FROM evts, awr_names names WHERE evts.event_id = names.event_id AND names.wait_class_id <> 2723168908 ), data as (SELECT e.event_id as event_id, e.event_name as event_name, e.wait_class_id as wait_class_id, e.p1 as p1, e.p2 as p2, e.p3 as p3, e.w_cnt as total_w_cnt, e.to_cnt as total_to_cnt, e.w_time as total_w_time, e.w_cnt_fg as fg_w_cnt, e.to_cnt_fg as fg_to_cnt, e.w_time_fg as fg_w_time, nvl(a.cnt_total, 0) as total_ash_cnt, nvl(a.cnt_fg, 0) as fg_ash_cnt FROM named_events e, ash a WHERE e.event_id = a.event_id(+) ), final_query as (SELECT d.event_name, d.event_id, d.p1 as p1, case when (p1 is null OR p1 = '0') then 0 else 1 end as p1valid, d.p2 as p2, case when (p2 is null OR p2 = '0') then 0 else 1 end as p2valid, d.p3 as p3, case when (p3 is null OR p3 = '0') then 0 else 1 end as p3valid, nvl(e.keh_id, 0) as keh_evt_id, c.class# as class_num, d.wait_class_id as wait_class_id, c.keh_id as keh_ecl_id, round(d.total_ash_cnt, 0) as total_ash_cnt, round(d.fg_ash_cnt, 0) as fg_ash_cnt, round(d.fg_w_cnt, 0) as fg_w_cnt, round(d.fg_to_cnt, 0) as fg_to_cnt, round(d.fg_w_time, 0) as fg_w_time, round(d.total_w_cnt, 0) as total_w_cnt, round(d.total_to_cnt, 0) as total_to_cnt, round(d.total_w_time, 0) as total_w_time from data d, X$KEHEVTMAP e , X$KEHECLMAP c where d.event_id = e.event_hash(+) and d.wait_class_id = c.class_hash ) SELECT * FROM final_query WHERE keh_evt_id > 0 OR total_w_time > 0 ORDER BY wait_class_id, fg_w_time DESC, event_id
6k3uuf3g8pwh6update /*+ index(orders, order_pk) */ orders set order_status = :1 where order_id = :2
6sqdp7673k5x3UPDATE wri$_adv_addm_tasks SET actual_analysis = :aa, database_time = :dbt, active_sessions = round(:dbt / (1000000 * :sint), 2), perc_flush_time = round(:ft / :sint, 2), perc_mw_time = round(:mw / :sint, 2) WHERE task_id = :tid
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
7r7twx8dzdd8rINSERT INTO STATS$SEG_STAT_OBJ ( TS# , OBJ# , DATAOBJ# , DBID , OWNER , OBJECT_NAME , SUBOBJECT_NAME , OBJECT_TYPE , TABLESPACE_NAME ) SELECT /*+ ordered index(ss1) */ VS.TS# , VS.OBJ# , VS.DATAOBJ# , :B2 , VS.OWNER , VS.OBJECT_NAME , VS.SUBOBJECT_NAME , VS.OBJECT_TYPE , VS.TABLESPACE_NAME FROM STATS$SEG_STAT SS1, V$SEGMENT_STATISTICS VS WHERE VS.DATAOBJ# = SS1.DATAOBJ# AND VS.OBJ# = SS1.OBJ# AND VS.TS# = SS1.TS# AND SS1.SNAP_ID = :B3 AND SS1.DBID = :B2 AND SS1.INSTANCE_NUMBER = :B1 AND VS.STATISTIC# = 0 AND NOT EXISTS (SELECT 1 FROM STATS$SEG_STAT_OBJ SS2 WHERE SS2.DATAOBJ# = SS1.DATAOBJ# AND SS2.OBJ# = SS1.OBJ# AND SS2.TS# = SS1.TS#) ORDER BY DATAOBJ#, OBJ#, TS#, DBID
7v0pya6f6qc6sselect p.product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url, quantity_on_hand, warehouse_id from product_information p, inventories i where category_id = :1 and i.product_id = p.product_id
82ud5h0qcg0bfselect customer_id, cust_first_name , cust_last_name , nls_language , nls_territory , credit_limit , cust_email , account_mgr_id from customers where customer_id = :1
8jhgd9rm6f17uselect SID, SERIAL#, CAPTURE#, CAPTURE_NAME, LOGMINER_ID, STARTUP_TIME, STATE, TOTAL_PREFILTER_DISCARDED, TOTAL_PREFILTER_KEPT, TOTAL_PREFILTER_EVALUATIONS, TOTAL_MESSAGES_CAPTURED, CAPTURE_TIME, CAPTURE_MESSAGE_NUMBER, CAPTURE_MESSAGE_CREATE_TIME, TOTAL_MESSAGES_CREATED, TOTAL_FULL_EVALUATIONS, TOTAL_MESSAGES_ENQUEUED, ENQUEUE_TIME, ENQUEUE_MESSAGE_NUMBER, ENQUEUE_MESSAGE_CREATE_TIME, AVAILABLE_MESSAGE_NUMBER, AVAILABLE_MESSAGE_CREATE_TIME, ELAPSED_CAPTURE_TIME, ELAPSED_RULE_TIME, ELAPSED_ENQUEUE_TIME, ELAPSED_LCR_TIME, ELAPSED_REDO_WAIT_TIME, ELAPSED_PAUSE_TIME, STATE_CHANGED_TIME, APPLY_NAME, APPLY_DBLINK, APPLY_MESSAGES_SENT, APPLY_BYTES_SENT, OPTIMIZATION, PURPOSE, SGA_USED, SGA_ALLOCATED, BYTES_OF_REDO_MINED, SESSION_RESTART_SCN from GV$STREAMS_CAPTURE where INST_ID = USERENV('Instance')
8uk8bquk453q8select orders_seq.nextval from dual
8vvvyuun2urt6insert into order_items(ORDER_ID, LINE_ITEM_ID, PRODUCT_ID, UNIT_PRICE, QUANTITY) values (:1 , :2 , :3 , :4 , :5 )
982zxphp8ht6cselect product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url from product_information where product_id = :1
9bz9sa0abpc48insert into customers (customer_id , cust_first_name , cust_last_name , nls_language , nls_territory , credit_limit , cust_email , account_mgr_id ) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 )
9dhn1b8d88dpf select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
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
9zd49du11u7cfinsert into orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) values (:1 , :2 , :3 , :4 )
9zus1m3s2675bDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN perfstat.statspack.snap(i_snap_level => 7); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b3zgx1xckrwxuselect host, userid, password, flag, authusr, authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
bn4b3vjw2mj3uSELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c2p21x29vnybg SELECT x.inst_id, x.sid_knst, x.serial_knst, x.capnum_knstcap, x.capname_knstcap, x.logminer_id_knstcap, x.startup_time_knstcap, case when (x.state_knstcap = 10 and d.loaded = 'ACTIVE') then d.current_state || ' ' || d.progress when (x.state_knstcap = 18) then 'WAIT FOR ' || x.subscriber_num || ' SUBSCRIBER(S) INITIALIZING' else DECODE(x.state_knstcap, 0, 'INITIALIZING', 1, 'CAPTURING CHANGES', 2, 'EVALUATING RULE', 3, 'ENQUEUING MESSAGE', 4, 'SHUTTING DOWN', 5, 'ABORTING', 6, 'CREATING LCR', 7, DECODE(x.missing_logfile_info_knstcap, NULL, 'WAITING FOR DICTIONARY REDO', 'WAITING FOR DICTIONARY REDO: ' || x.missing_logfile_info_knstcap), 8, DECODE(x.missing_logfile_info_knstcap, NULL, 'WAITING FOR REDO', 'WAITING FOR REDO: ' || x.missing_logfile_info_knstcap), 9, 'PAUSED FOR FLOW CONTROL', 10, 'DICTIONARY INITIALIZATION', 11, 'WAITING FOR APPLY TO BE ENABLED', 12, 'CONNECTING TO APPLY DATABASE', 13, 'WAITING FOR PROPAGATION TO BE ENABLED', 15, 'WAITING FOR A SUBSCRIBER TO BE ADDED', 16, 'WAITING FOR BUFFERED QUEUE TO SHRINK', 17, 'SUSPENDED FOR AUTO SPLIT/MERGE', 19, 'WAITING FOR INACTIVE DEQUEUERS', 20, 'WAITING FOR TRANSACTION') end, m.msgs_filtered, m.msgs_kept, m.msgs_total, x.total_captured_knstcap, x.recent_time_knstcap, x.recent_msg_num_knstcap, x.recent_msg_time_knstcap, x.total_messages_created_knstcap, x.total_full_evaluations_knstcap, x.total_msg_enq_knstcap, x.enqueue_time_knstcap, x.enqueue_msg_num_knstcap, x.enqueue_msg_time_knstcap, DECODE(bitand(x.flags_knstcap, 1), 0, upstream.next_scn, 1, DECODE(bitand(x.flags_knstcap, 8), 0, downstream.next_scn, downstream_real.next_scn)), DECODE(bitand(x.flags_knstcap, 1), 0, upstream.next_time, 1, DECODE(bitand(x.flags_knstcap, 8), 0, downstream.next_time, downstream_real.next_time)), x.elapsed_capture_time_knstcap, x.elapsed_rule_time_knstcap, x.elapsed_enqueue_time_knstcap, x.elapsed_lcr_time_knstcap, x.elapsed_wait_time_knstcap, x.elapsed_pause_time_knstcap, x.state_changed_time_knstcap, x.appname_knstcap, x.apply_dblink_knstcap, x.apply_messages_sent_knstcap, (SELECT sesstat.ksusestv FROM x$ksusd stat, x$ksusesta sesstat, x$ksuse sess WHERE x.sid_knst=sesstat.ksusenum AND x.sid_knst=sess.indx AND x.serial_knst=sess.ksuseser AND bitand(sess.ksspaflg, 1)!=0 AND bitand(sess.ksuseflg, 1)!=0 AND sesstat.ksusestn = stat.indx AND bitand(sesstat.ksspaflg, 1)!=0 AND bitand(sesstat.ksuseflg, 1)!=0 AND sesstat.ksusestn<(select ksusgstl from x$ksusgif) AND stat.ksusdnam = 'bytes sent via SQL*Net to dblink'), DECODE(BITAND(x.flags_knstcap, 6), 2, 1, 4, 2, 0), DECODE(BITAND(x.flags_knstcap, 32), 32, 'GoldenGate', DECODE(BITAND(x.flags_knstcap, 16), 16, 'XStream', 'Streams')), x.sga_used_knstcap, x.sga_allocated_knstcap, brm.value, srs.value FROM x$knstcap x, (SELECT session_id, sum(skipped_filter_calls) msgs_filtered, sum(kept_filter_calls) msgs_kept, sum(total_filter_calls) msgs_total FROM x$logmnr_process GROUP BY session_id) m, (SELECT last_write_scn next_scn, last_write_scn_time next_time FROM x$kcrfws) upstream, (SELECT session#, max(next_change#) next_scn, max(next_time) next_time FROM system.logmnr_log$ GROUP BY session#) downstream, (SELECT max(to_number(slnxs)) next_scn, max(to_date(slnxt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')) next_time FROM x$kccsl WHERE sign(slseq)=1) downstream_real, x$logmnr_dictionary_load d, (SELECT session_id, name, value FROM x$krvxsv WHERE name = 'bytes of redo mined') brm, (SELECT session_id, name, value FROM x$krvxsv WHERE name = 'session restart SCN') srs WHERE type_knst=8 AND x.logminer_id_knstcap = m.session_id(+) AND x.logminer_id_knstcap = d.session_id(+) AND x.logminer_id_knstcap = downstream.session#(+) AND x.logminer_id_knstcap = brm.session_id(+) AND x.logminer_id_knstcap = srs.session_id(+) AND EXISTS (SELECT 1 FROM v$session s WHERE s.sid=x.sid_knst AND s.serial#=x.serial_knst)
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d5j6fbqmu3gjpSELECT /*+ use_nl */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and c.customer_id = :1
dnhdv2yuma39zINSERT INTO STATS$STREAMS_APPLY_SUM ( SNAP_ID , DBID , INSTANCE_NUMBER , APPLY_NAME , STARTUP_TIME , READER_TOTAL_MESSAGES_DEQUEUED , READER_ELAPSED_DEQUEUE_TIME , READER_ELAPSED_SCHEDULE_TIME , COORD_TOTAL_RECEIVED , COORD_TOTAL_APPLIED , COORD_TOTAL_WAIT_DEPS , COORD_TOTAL_WAIT_COMMITS , COORD_ELAPSED_SCHEDULE_TIME , SERVER_TOTAL_MESSAGES_APPLIED , SERVER_ELAPSED_DEQUEUE_TIME , SERVER_ELAPSED_APPLY_TIME ) SELECT :B3 , :B2 , :B1 , MAX(C.APPLY_NAME) , MAX(C.STARTUP_TIME) , MAX(R.TOTAL_MESSAGES_DEQUEUED) , MAX(R.ELAPSED_DEQUEUE_TIME) , MAX(R.ELAPSED_SCHEDULE_TIME) , MAX(C.TOTAL_RECEIVED) , MAX(C.TOTAL_APPLIED) , MAX(C.TOTAL_WAIT_DEPS) , MAX(C.TOTAL_WAIT_COMMITS) , MAX(C.ELAPSED_SCHEDULE_TIME) , SUM(S.TOTAL_MESSAGES_APPLIED) , SUM(S.ELAPSED_DEQUEUE_TIME) , SUM(S.ELAPSED_APPLY_TIME) FROM V$STREAMS_APPLY_COORDINATOR C , V$STREAMS_APPLY_READER R , V$STREAMS_APPLY_SERVER S WHERE C.APPLY_NAME = R.APPLY_NAME AND C.APPLY_NAME = S.APPLY_NAME GROUP BY C.APPLY_NAME
dt8dtzvsq5kj5select p.product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status, list_price, min_price, catalog_url, quantity_on_hand, warehouse_id from product_information p, inventories i where i.product_id = :1 and i.product_id = p.product_id
g8rhybcumtwd6SELECT /*+ first_rows index(customers, customers_pk) index(orders, order_status_ix) */ o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email, order_date FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and o.order_status <= 4
gfqas5ahy1x56SELECT o.order_id, line_item_id, product_id, unit_price, quantity, order_mode, order_status, order_total, sales_rep_id, promotion_id, c.customer_id, cust_first_name, cust_last_name, credit_limit, cust_email FROM orders o , order_items oi, customers c WHERE o.order_id = oi.order_id and o.customer_id = c.customer_id and o.order_id = :1
gshgncvvtv0c6insert into logon values(:1 , :2 )
gyk686gnaygs2select product_id, product_name, product_description, category_id, weight_class, supplier_id, product_status list_price, min_price, catalog_url from product_information where category_id = :1


Back to Top