WORKLOAD REPOSITORY COMPARE PERIOD REPORT

  
Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHostStd Block Size
First (1st)ORCL1200893776orcl111.2.0.1.0NO11gR2Base8192
Second (2nd)ORCL1200893776orcl111.2.0.1.0NO11gR2Base8192

  

  
Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st219924-Nov-10 11:50:02 (Wed)220024-Nov-10 12:12:32 (Wed) 41.43 22.49 931.72
2nd220724-Nov-10 21:18:33 (Wed)220824-Nov-10 21:56:44 (Wed) 14.08 38.19 537.81
%Diff     -66.01 69.81 -42.28

  

  Host Configuration Comparison

  

1st2ndDiff%Diff
Number of CPUs:2200.0
Physical Memory:2011.4M2011.4M0M0.0
Load at Start Snapshot:.24.11-.13-54.2
Load at End Snapshot:23.793.55-20.24-85.1
%User Time:13.312.02-1.28-9.6
%System Time:32.7219.26-13.46-41.1
%Idle Time:51.4867.481631.1
%IO Wait Time:40.7859.5418.7646.0

  

  Cache Sizes

  

1st (M)2nd (M)Diff (M)%Diff
Memory Target    
.....SGA Target752.0752.00.00.0
..........Buffer Cache424.0396.0-28.0-6.6
..........Shared Pool300.0328.028.09.3
..........Large Pool8.08.00.00.0
..........Java Pool4.04.00.00.0
..........Streams Pool4.04.00.00.0
.....PGA Target152.0152.00.00.0
Log Buffer6.16.10.00.0

  

  Load Profile

  
1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 41.43 14.08 -66.01 40.28 145.35 260.85
CPU time: 0.83 0.60 -27.71 0.81 6.16 660.49
Redo size: 6,904.49 1,642.76 -76.21 6,712.85 16,953.95 152.56
Logical reads: 24,587.05 7,758.12 -68.45 23,904.62 80,066.95 234.94
Block changes: 25.33 3.17 -87.49 24.63 32.74 32.93
Physical reads: 23,362.89 12,137.94 -48.05 22,714.44 125,268.41 451.49
Physical writes: 3.56 263.85 7,311.52 3.46 2,723.06 78,601.16
User calls: 155.07 159.99 3.17 150.77 1,651.13 995.13
Parses: 15.47 2.29 -85.20 15.04 23.68 57.45
Hard parses: 4.60 0.01 -99.78 4.47 0.14 -96.87
W/A MB processed: 441,961.12 1,253,416.72 183.60 429,694.16 12,935,763.03 183.60
Logons: 0.18 0.06 -66.67 0.17 0.67 294.12
Executes: 101.02 3.43 -96.60 98.22 35.42 -63.94
Transactions: 1.03 0.10 -90.29   
1st2ndDiff
% Blocks changed per Read: 0.10 0.04 -0.06
Recursive Call %: 42.32 12.66 -29.65
Rollback per transaction %: 4.18 0.00 -4.18
Rows per Sort: 10.76 13,676.49 13,665.73
Avg DB time per Call (sec): 0.27 0.09 -0.18

  

Top Timed Events

1st 2nd
EventWait ClassWaitsTime(s)Avg Time(ms)%DB timeEventWait ClassWaitsTime(s)Avg Time(ms)%DB time
direct path readUser I/O248,07546,558.63187.6883.28direct path write tempUser I/O86,26717,789.98206.2255.13
db file sequential readUser I/O17,0614,255.26249.417.61direct path readUser I/O139,7146,874.7049.2121.30
db file parallel readUser I/O4811,435.912,985.262.57direct path read tempUser I/O1,530,2666,208.494.0619.24
CPU time  1,122.77 2.01CPU time  1,366.87 4.24
enq: KO - fast object checkpointApplication666899.741,350.961.61db file parallel writeSystem I/O75017.3923.180.05
-db file parallel writeSystem I/O54612.9523.710.02-db file sequential readUser I/O3464.5313.100.01
-     -db file parallel readUser I/O222.1396.690.01

  

  

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.0055,903.4532,268.75-42.2840.28145.35260.85
DB CPU2.014.242.231,122.771,366.8721.740.816.16660.49
parse time elapsed1.320.04-1.28738.0011.37-98.460.530.05-90.57
sql execute elapsed time99.0799.830.7655,383.8932,214.50-41.8339.90145.11263.68
hard parse elapsed time0.420.01-0.41236.262.75-98.840.170.01-94.12
hard parse (sharing criteria) elapsed time0.070.00-0.0737.330.00-100.000.030.00-100.00
PL/SQL compilation elapsed time0.040.00-0.0425.050.00-100.000.020.00-100.00
hard parse (bind mismatch) elapsed time0.010.00-0.015.710.00-100.000.000.000.00
PL/SQL execution elapsed time0.070.07-0.0139.8521.08-47.100.030.09200.00
connection management call elapsed time0.000.010.001.661.9416.870.000.01100.00
repeated bind elapsed time0.000.00-0.000.040.00-100.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
sequence load elapsed time0.000.000.000.000.000.000.000.000.00
background elapsed time1.080.24-0.85606.4677.36-87.240.440.35-20.45
background cpu time0.020.02-0.0013.266.80-48.720.010.03200.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_TIME128,160147,7382.294.58100.0094.9764.48-32.1092.33665.49620.77
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_TIME135,970306,5902.439.50290.95100.76133.8232.8197.961,381.041,309.80
IOWAIT_TIME107,711270,5201.938.38334.2079.82118.0747.9277.601,218.561,470.31
NICE_TIME0690.000.000.000.000.03100.000.000.31100.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME86,41587,5011.552.7174.8464.0438.19-40.3762.26394.15533.07
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_TIME35,14154,6210.631.69168.2526.0423.84-8.4525.32246.04871.72

  


  
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
Application1.730.00-1.730.850.00-100.00964.610.00-100.00839.520.00-100.00
Concurrency1.540.05-1.491.920.07-96.35860.2315.15-98.24332.1394.10-71.67
User I/O94.5195.721.21200.39766.95282.7352,834.3130,888.56-41.54195.3817.58-91.00
System I/O0.540.12-0.436.192.96-52.18302.1437.14-87.7136.155.48-84.84
Other0.280.02-0.263.650.67-81.64158.707.31-95.3932.204.74-85.28
Commit0.040.01-0.030.900.03-96.6724.074.48-81.3919.7871.06259.25
Configuration0.000.00-0.000.030.00-100.002.250.00-100.0059.220.00-100.00
Network0.010.01-0.00154.99159.763.082.881.65-42.710.010.00-100.00

  


   Back to Wait Events
Back to Top

  

Wait Events

  % of DB time # Waits/sec (Elapsed Time) Total Wait Time (sec) Avg Wait Time (ms)
EventWait Class1st2ndDiff1st2nd%Diff1st2nd%Diff1st2nd%Diff
direct path readUser I/O83.2821.30-61.98183.8360.98-66.8346,558.636,874.70-85.23187.6849.21-73.78
direct path write tempUser I/O0.0055.1355.130.0037.65100.000.0017,789.98100.000.00206.22100.00
direct path read tempUser I/O0.0019.2419.240.00667.91100.000.006,208.49100.000.004.06100.00
db file sequential readUser I/O7.610.01-7.6012.640.15-98.814,255.264.53-99.89249.4113.10-94.75
db file parallel readUser I/O2.570.01-2.560.360.01-97.221,435.912.13-99.852,985.2696.69-96.76
enq: KO - fast object checkpointApplication1.610.00-1.610.490.00-100.00899.740.00-100.001,350.960.00-100.00
read by other sessionUser I/O0.540.01-0.531.160.02-98.28302.552.35-99.22194.0752.16-73.12
db file scattered readUser I/O0.490.00-0.491.060.00-100.00273.440.00-100.00191.220.00-100.00
latch: shared poolConcurrency0.490.00-0.481.210.01-99.17271.470.85-99.69166.8532.70-80.40
cursor: pin S wait on XConcurrency0.470.00-0.470.140.00-100.00260.760.00-100.001,379.670.00-100.00
db file async I/O submitSystem I/O0.400.00-0.400.620.00-100.00224.430.00-100.00268.770.00-100.00
library cache: mutex XConcurrency0.220.00-0.220.110.01-90.91124.490.59-99.53841.1629.31-96.52
os thread startupConcurrency0.190.04-0.150.080.04-50.00106.9213.01-87.831,038.09146.21-85.92
enq: TX - row lock contentionApplication0.110.00-0.110.020.00-100.0063.220.00-100.002,341.660.00-100.00
latch freeOther0.090.00-0.090.190.01-94.7451.790.08-99.85203.103.61-98.22
cursor: pin SConcurrency0.070.00-0.070.010.00-100.0038.750.00-100.002,767.510.04-100.00
enq: PR - contentionOther0.050.00-0.050.000.000.0030.310.00-100.007,578.240.00-100.00
process diagnostic dumpOther0.050.00-0.050.000.000.0030.240.00-100.0030,236.990.00-100.00
library cache lockConcurrency0.050.00-0.050.020.00-100.0027.670.00-100.00954.030.00-100.00
db file parallel writeSystem I/O0.020.050.030.400.33-17.5012.9517.3934.2923.7123.18-2.24
log file syncCommit0.040.01-0.030.900.03-96.6724.074.48-81.3919.7871.06259.25
log file parallel writeSystem I/O0.050.03-0.031.580.20-87.3430.299.09-69.9914.1820.2843.02
latch: cache buffers chainsConcurrency0.020.00-0.020.190.01-94.7413.070.70-94.6450.8528.02-44.90
buffer deadlockOther0.020.00-0.020.000.000.0011.760.00-100.005,880.560.00-100.00
flashback log file writeSystem I/O0.030.00-0.020.370.03-91.8914.151.53-89.1928.1923.84-15.43
flashback log file syncUser I/O0.000.020.020.010.010.001.305.88352.31100.30452.46351.11
reliable messageOther0.020.00-0.020.510.00-100.008.760.00-100.0012.760.00-100.00
enq: TX - index contentionConcurrency0.010.00-0.010.020.00-100.006.290.00-100.00273.470.00-100.00
Disk file operations I/OUser I/O0.010.00-0.011.280.22-82.816.300.40-93.653.640.79-78.30
latch: cache buffers lru chainOther0.010.00-0.010.090.00-100.004.880.00-100.0041.360.00-100.00
control file sequential readSystem I/O0.020.01-0.012.191.73-21.0011.774.10-65.173.971.04-73.80
buffer busy waitsConcurrency0.010.00-0.010.050.00-100.003.440.00-100.0053.720.00-100.00
PX Deq: Signal ACK RSGOther0.010.00-0.010.030.00-100.003.430.00-100.0081.760.00-100.00
library cache load lockConcurrency0.010.00-0.010.040.00-100.003.250.00-100.0065.050.00-100.00
latch: row cache objectsConcurrency0.000.00-0.000.040.00-100.002.700.00-100.0045.840.00-100.00
enq: HW - contentionConfiguration0.000.00-0.000.030.00-100.002.250.00-100.0059.220.00-100.00
SQL*Net break/reset to clientApplication0.000.00-0.000.340.00-100.001.640.00-100.003.610.00-100.00
row cache lockConcurrency0.000.00-0.000.020.00-100.001.420.00-100.0052.480.00-100.00
enq: CF - contentionOther0.000.00-0.000.000.000.001.020.00-100.001,023.540.00-100.00
enq: TX - contentionOther0.000.00-0.000.010.00-100.000.720.00-100.0055.190.00-100.00
ASM file metadata operationOther0.020.02-0.000.440.28-36.3612.456.79-45.4620.8610.64-48.99
Parameter File I/OUser I/O0.000.00-0.000.050.00-100.000.630.00-100.009.920.00-100.00
PX Deq: Slave Session StatsOther0.000.00-0.000.110.00-100.000.510.00-100.003.540.00-100.00
latch: enqueue hash chainsOther0.000.00-0.000.010.00-100.000.470.00-100.0024.950.00-100.00
asynch descriptor resizeOther0.000.00-0.002.060.37-82.040.430.03-93.020.150.03-80.00
control file parallel writeSystem I/O0.010.020.000.500.37-26.008.104.89-39.6311.925.82-51.17
SQL*Net message to clientNetwork0.000.010.00154.51159.743.382.611.64-37.160.010.00-100.00
latch: parallel query alloc bufferOther0.000.00-0.000.010.00-100.000.200.00-100.0015.210.00-100.00
SQL*Net more data to clientNetwork0.000.00-0.000.350.01-97.140.160.00-100.000.340.12-64.71
PX Deq: Signal ACK EXTOther0.000.00-0.000.060.00-100.000.160.00-100.001.890.00-100.00
kfk: async disk IOSystem I/O0.000.00-0.000.500.30-40.000.160.01-93.750.240.01-95.83
enq: FB - contentionOther0.000.00-0.000.000.000.000.150.00-100.0030.640.00-100.00
LGWR wait for redo copyOther0.000.00-0.000.010.00-100.000.150.00-100.009.840.11-98.88
enq: PS - contentionOther0.000.00-0.000.020.00-100.000.110.00-100.004.870.00-100.00
latch: redo allocationOther0.000.00-0.000.000.000.000.110.00-100.0027.650.00-100.00
CSS initializationOther0.000.00-0.000.010.00-100.000.790.40-49.37112.3899.17-11.75
SQL*Net more data from clientNetwork0.000.00-0.000.130.01-92.310.110.01-90.910.590.54-8.47
direct path writeUser I/O0.000.00-0.000.010.00-100.000.280.11-60.7130.6718.48-39.75
latch: object queue header operationOther0.000.00-0.000.010.00-100.000.090.01-88.899.374.17-55.50
enq: BF - allocation contentionOther0.000.00-0.000.000.000.000.070.00-100.0033.320.00-100.00
flashback log file readSystem I/O0.000.00-0.000.010.010.000.300.15-50.0016.527.69-53.45
ADR block file readOther0.000.00-0.000.010.00-100.000.030.00-100.002.150.00-100.00
PX qref latchOther0.000.00-0.000.010.00-100.000.010.00-100.002.130.00-100.00
latch: call allocationOther0.000.00-0.000.010.00-100.000.010.00-100.001.610.00-100.00
CSS operation: actionOther0.000.000.000.010.00-100.000.020.020.002.664.2158.27
rdbms ipc replyOther0.000.00-0.000.010.00-100.000.010.00-100.000.540.00-100.00
PX Deq: Table Q qrefOther0.000.00-0.000.000.000.000.000.000.001.100.00-100.00
ADR block file writeOther0.000.00-0.000.000.000.000.000.000.000.390.00-100.00
CSS operation: queryOther0.000.000.000.030.01-66.670.010.010.000.180.2327.78
ADR file lockOther0.000.00-0.000.000.000.000.000.000.000.120.00-100.00
latch: cache buffer handlesOther0.000.00-0.000.000.000.000.000.000.000.030.00-100.00
PX Idle WaitIdle10.920.00-10.922.320.00-100.006,105.100.00-100.001,950.510.00-100.00
DIAG idle waitIdle4.8414.209.362.002.000.002,704.514,581.8269.411,000.931,000.83-0.01
jobq slave waitIdle2.417.485.062.002.105.001,349.832,412.4178.72500.86500.71-0.03
Streams AQ: qmn slave idle waitIdle2.407.124.710.040.040.001,343.472,296.3870.9327,417.8227,337.85-0.29
Streams AQ: qmn coordinator idle waitIdle2.407.124.710.070.070.001,344.192,296.3870.8414,001.9914,002.340.00
ASM background timerIdle2.417.104.690.270.22-18.521,349.482,292.1469.853,667.064,503.2222.80
Space Manager: slave idle waitIdle2.427.104.690.200.200.001,352.262,292.4869.535,026.994,994.51-0.65
wait for unread message on broadcast channelIdle2.427.104.681.001.000.001,353.252,291.9669.371,000.921,000.86-0.01
shared server idle waitIdle2.427.074.650.030.030.001,350.132,280.2768.8930,003.0030,003.570.00
SQL*Net message from clientIdle8.345.92-2.43154.51159.753.394,664.121,909.51-59.0622.375.22-76.67
PX Deq: Table Q NormalIdle2.080.00-2.080.670.00-100.001,162.980.00-100.001,279.410.00-100.00
PX Deq: Execute ReplyIdle1.030.00-1.030.610.00-100.00577.690.00-100.00698.530.00-100.00
class slave waitIdle2.963.710.750.040.01-75.001,653.031,195.87-27.6633,735.2745,995.1936.34
PX Deq: Execution MsgIdle0.230.00-0.230.660.00-100.00128.400.00-100.00144.760.00-100.00
PX Deq Credit: send blkdIdle0.020.00-0.020.100.00-100.0010.100.00-100.0074.240.00-100.00
PX Deq: Parse ReplyIdle0.010.00-0.010.050.00-100.006.270.00-100.0090.910.00-100.00
PX Deq: Join ACKIdle0.000.00-0.000.060.00-100.002.350.00-100.0030.490.00-100.00
KSV master waitIdle0.020.020.000.030.01-66.6710.256.30-38.54232.85314.8935.23
SGA: MMAN sleep for component shrinkIdle0.000.00-0.000.010.00-100.000.050.00-100.006.790.00-100.00
PX Deq: Table Q SampleIdle0.000.00-0.000.000.000.000.010.00-100.003.830.00-100.00

  


   Back to Wait Events
Back to Top

  

  

Service Statistics

Back to Top

  

Service Statistics

 % of DB time % CPU Time % Physical Reads % Logical Reads
Service Name1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
SYS$USERS0.180.14-0.041.360.97-0.390.000.00-0.000.090.180.10
orcl99.8299.860.0498.6299.020.40100.00100.000.0099.8799.74-0.13
ADHOC0.000.000.000.000.000.000.000.000.000.000.000.00
BATCH_LOW0.000.000.000.000.000.000.000.000.000.000.000.00
BATCH_STD0.000.000.000.000.000.000.000.000.000.000.000.00
DSS0.000.000.000.000.000.000.000.000.000.000.000.00
OLTP0.000.000.000.000.000.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.000.00-0.000.040.080.04
orclXDB0.000.000.000.000.000.000.000.000.000.000.000.00

  


   Back to Service Statistics
Back to Top

  

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
ADHOC0.000.000.000.000.000.000.00
BATCH_LOW0.000.000.000.000.000.000.00
BATCH_STD0.000.000.000.000.000.000.00
DSS0.000.000.000.000.000.000.00
OLTP0.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
orcl0.000.000.000.000.000.000.00
orclXDB0.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
72vydb3ncbn3s71.0971.09  -71.09537,088 0.00 9,203 526,827 331,989.09 1.00 74   DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w70.89141.99  -70.89535,567 0.00 9,190 526,798 331,989.09 0.00 74 1// 1 SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5  21.6921.6921.69 466,584 0.00 25,788 443,120 461,439.00 175.00 15/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb213.42155.41  -13.4213,818 0.01 391 12,456 11,494.98 49.36 543 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7  12.4934.1812.49 268,618 0.00 9,483 262,445 237,854.13 4.00 15/ 1/ 1 SELECT supp_nation, cust_natio...
bfk319z4wc782  5.0839.265.08 409,879 0.00 9,885 403,842 270,200.00 5.00 4/ 1/ 1 SELECT n_name, SUM(l_extendedp...
1gkn6r4rbdkmy  5.0244.285.02 405,253 0.00 9,957 399,255 270,478.25 5.00 4/ 1/ 1 SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r  4.4448.724.44 95,447 0.00 4,692 93,133 134,596.00 2.00 15/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
2uzp6kw11g1su  3.8852.593.88 416,871 0.00 10,030 410,881 269,115.00 5.00 3/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td  2.6355.222.63 424,651 0.00 9,539 418,723 265,961.50 5.00 2/ 1/ 1 SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x  2.5857.802.58 415,764 0.00 9,889 409,760 269,678.50 5.00 2/ 1/ 1 SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4  2.4260.222.42 390,476 0.00 8,333 386,016 161,508.00 36,811.00 2/ 1/ 1 SELECT c_custkey, c_name, SUM(...
afy3mzh484trw  2.2962.512.29 369,920 0.00 9,654 361,348 235,011.00 11,382.00 2/ 1/ 1 SELECT l_orderkey, SUM(l_exten...
2vcn91b1wtmc61.52156.93  -1.525,893 0.00 11 5,887 19.04 23.51 144 1// 1 SELECT TH_DTS, TH_ST_ID FROM E...
318ng5h3q5x791.43158.35  -1.4322,144 0.00 320 19,171 11,654.47 19.44 36 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
8h5jmzqcfpgzb1.38159.74  -1.3811,041 0.00 26 11,006 38.17 18.34 70 1// 1 SELECT CT_AMT, CT_NAME, CT_DTS...
309b84z4mv9jb1.34161.08  -1.345,201 0.00 12 5,193 19.71 9.72 144 1// 1 SELECT SE_CASH_TYPE, SE_CASH_D...
84nxzpqwn91j51.33162.40  -1.33325 0.04 1 322 1.29 2.38 2,280 1// 1 Select to_char(TH_DTS, 'mm/dd/...
15p4z9yvdc8ua1.22163.62  -1.229,735 0.00 32 9,656 50.21 20.00 70 1// 1 SELECT T_EXEC_NAME, T_BID_PRIC...
g4gkdzc5fb01z1.03164.65  -1.03268 0.04 1 264 1.25 0.97 2,141 1// 1 Select CT_AMT, to_char(CT_DTS,...

  


   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
72vydb3ncbn3s60.6660.66  -60.669,203 526,827 0.00 537,088 331,989.09 1.00   DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w60.57121.23  -60.579,190 526,798 0.00 535,567 331,989.09 0.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5  28.3028.3028.30 25,788 443,120 0.00 466,584 461,439.00 175.00/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb218.91140.14  -18.91391 12,456 0.01 13,818 11,494.98 49.36 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7  10.4138.7110.41 9,483 262,445 0.00 268,618 237,854.13 4.00/ 1/ 1 SELECT supp_nation, cust_natio...
fps40s3v7nd3r  5.1543.865.15 4,692 93,133 0.00 95,447 134,596.00 2.00/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
48ay2b94rz41x4.00144.14  -4.00109 727 0.01 1,020 195.33 12.58 1// 1 SELECT DM_DATE, DM_CLOSE, DM_H...
1gkn6r4rbdkmy  2.9146.772.91 9,957 399,255 0.00 405,253 270,478.25 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
bfk319z4wc782  2.8949.662.89 9,885 403,842 0.00 409,879 270,200.00 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su  2.2051.862.20 10,030 410,881 0.00 416,871 269,115.00 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
9xcdxpqrhsvmx  1.4653.321.46 9,977 51,505 0.00 77,139 108,845.00 4.00/ 1/ 1 SELECT l_returnflag, l_linesta...
39pvzrsczv31x  1.4554.771.45 9,889 409,760 0.00 415,764 269,678.50 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
afy3mzh484trw  1.4156.181.41 9,654 361,348 0.00 369,920 235,011.00 11,382.00/ 1/ 1 SELECT l_orderkey, SUM(l_exten...
c0chxpnujy8td  1.4057.581.40 9,539 418,723 0.00 424,651 265,961.50 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
318ng5h3q5x791.02145.17  -1.02320 19,171 0.00 22,144 11,654.47 19.44 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
8v93w0n1dm76k0.72145.88  -0.720 6 0.56 6 0.21 1.00 1// 1 SELECT DM_CLOSE FROM E_DAILY_M...
7rq305gd2gpzw0.37146.26  -0.370 0 0.56 0 0.00 1.00 1// 1 SELECT S_NUM_OUT FROM E_SECURI...
4j9awnaff2xjr0.37146.63  -0.370 0 0.56 0 0.00 1.00 1// 1 SELECT LT_PRICE FROM E_LAST_TR...
5pnb5ryzbx5xx0.37147.00  -0.3752 1,422 0.00 3,142 1,324.93 23.96 1// 1 SELECT TH_DTS, T_QTY, T_S_SYMB...
6gvch1xu9ca3g0.54147.540.3157.89-0.2329011349680.000.002,51263234.860.341.001.00  DECLARE job BINARY_INTEGER := ...

  


   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
72vydb3ncbn3s69.7469.74  -69.74526,827 537,088 0.00 9,203 331,989.09 1.00 74   DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w69.73139.47  -69.73526,798 535,567 0.00 9,190 331,989.09 0.00 74 1// 1 SELECT T_ID FROM E_TRADE WHERE...
95rzx549dbvs5  20.6020.6020.60 443,120 466,584 0.00 25,788 461,439.00 175.00 15/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
1x255a7m968k7  12.2032.8012.20 262,445 268,618 0.00 9,483 237,854.13 4.00 15/ 1/ 1 SELECT supp_nation, cust_natio...
bqjghjzaphzb212.10151.57  -12.1012,456 13,818 0.01 391 11,494.98 49.36 543 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
bfk319z4wc782  5.0137.805.01 403,842 409,879 0.00 9,885 270,200.00 5.00 4/ 1/ 1 SELECT n_name, SUM(l_extendedp...
1gkn6r4rbdkmy  4.9542.754.95 399,255 405,253 0.00 9,957 270,478.25 5.00 4/ 1/ 1 SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r  4.3347.084.33 93,133 95,447 0.00 4,692 134,596.00 2.00 15/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
2uzp6kw11g1su  3.8250.903.82 410,881 416,871 0.00 10,030 269,115.00 5.00 3/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td  2.6053.502.60 418,723 424,651 0.00 9,539 265,961.50 5.00 2/ 1/ 1 SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x  2.5456.042.54 409,760 415,764 0.00 9,889 269,678.50 5.00 2/ 1/ 1 SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4  2.3958.432.39 386,016 390,476 0.00 8,333 161,508.00 36,811.00 2/ 1/ 1 SELECT c_custkey, c_name, SUM(...
afy3mzh484trw  2.2460.672.24 361,348 369,920 0.00 9,654 235,011.00 11,382.00 2/ 1/ 1 SELECT l_orderkey, SUM(l_exten...
2vcn91b1wtmc61.52153.08  -1.525,887 5,893 0.00 11 19.04 23.51 144 1// 1 SELECT TH_DTS, TH_ST_ID FROM E...
8h5jmzqcfpgzb1.38154.46  -1.3811,006 11,041 0.00 26 38.17 18.34 70 1// 1 SELECT CT_AMT, CT_NAME, CT_DTS...
309b84z4mv9jb1.34155.80  -1.345,193 5,201 0.00 12 19.71 9.72 144 1// 1 SELECT SE_CASH_TYPE, SE_CASH_D...
84nxzpqwn91j51.31157.11  -1.31322 325 0.04 1 1.29 2.38 2,280 1// 1 Select to_char(TH_DTS, 'mm/dd/...
318ng5h3q5x791.23158.35  -1.2319,171 22,144 0.00 320 11,654.47 19.44 36 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
15p4z9yvdc8ua1.21159.56  -1.219,656 9,735 0.00 32 50.21 20.00 70 1// 1 SELECT T_EXEC_NAME, T_BID_PRIC...
g4gkdzc5fb01z1.01160.57  -1.01264 268 0.04 1 1.25 0.97 2,141 1// 1 Select CT_AMT, to_char(CT_DTS,...

  


   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
72vydb3ncbn3s74.1174.11  -74.11332,292.01 74 537,088 9,203 526,827 331,989.09 1.00   DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w74.11148.22  -74.11332,282.86 74 535,567 9,190 526,798 331,989.09 0.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
bqjghjzaphzb218.73166.95  -18.7311,446.52 543 13,818 391 12,456 11,494.98 49.36 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
95rzx549dbvs5  12.2012.2012.20 144,575.00 15 466,584 25,788 443,120 461,439.00 175.00/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
fps40s3v7nd3r  11.7523.9511.75 139,259.00 15 95,447 4,692 93,133 134,596.00 2.00/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
1x255a7m968k7  11.4335.3911.43 135,480.00 15 268,618 9,483 262,445 237,854.13 4.00/ 1/ 1 SELECT supp_nation, cust_natio...
48ay2b94rz41x3.40170.36  -3.402,734.15 413 1,020 109 727 195.33 12.58 1// 1 SELECT DM_DATE, DM_CLOSE, DM_H...
1gkn6r4rbdkmy  3.0538.433.05 135,473.00 4 405,253 9,957 399,255 270,478.25 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
bfk319z4wc782  3.0541.483.05 135,473.00 4 409,879 9,885 403,842 270,200.00 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su  2.2943.772.29 135,473.00 3 416,871 10,030 410,881 269,115.00 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
agz7fu32m6qn4  1.5345.291.53 135,573.00 2 390,476 8,333 386,016 161,508.00 36,811.00/ 1/ 1 SELECT c_custkey, c_name, SUM(...
39pvzrsczv31x  1.5246.821.52 135,473.00 2 415,764 9,889 409,760 269,678.50 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td  1.5248.341.52 135,473.00 2 424,651 9,539 418,723 265,961.50 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c71khx643vgxb  1.5249.871.52 135,313.00 2 289,804 7,029 285,668 158,850.00 36,762.00/ 1/ 1 SELECT c_custkey, c_name, SUM(...
318ng5h3q5x791.25171.60  -1.2511,518.36 36 22,144 320 19,171 11,654.47 19.44 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
8v93w0n1dm76k0.38171.98  -0.384.00 31,342 6 0 6 0.21 1.00 1// 1 SELECT DM_CLOSE FROM E_DAILY_M...
5pnb5ryzbx5xx0.29172.28  -0.291,221.20 80 3,142 52 1,422 1,324.93 23.96 1// 1 SELECT TH_DTS, T_QTY, T_S_SYMB...
4j9awnaff2xjr0.28172.56  -0.283.00 31,342 0 0 0 0.00 1.00 1// 1 SELECT LT_PRICE FROM E_LAST_TR...
7rq305gd2gpzw0.28172.84  -0.283.00 31,342 0 0 0 0.00 1.00 1// 1 SELECT S_NUM_OUT FROM E_SECURI...
fjpgrrp53dtxj0.15173.00  -0.15359.02 141 71 6 2 0.01 1.83 1// 1 SELECT B_NAME, NVL(SUM(TR_QTY...

  


   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
58h9dvw8qzy7w77.9277.92  -77.92331,989.09 74 535,567 9,190 526,798 0.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
72vydb3ncbn3s77.92155.85  -77.92331,989.09 74 537,088 9,203 526,827 1.00   DECLARE trades E_TradeList; BE...
95rzx549dbvs5  24.8924.8924.89 461,439.00 15 466,584 25,788 443,120 175.00/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
bqjghjzaphzb219.80175.64  -19.8011,494.98 543 13,818 391 12,456 49.36 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7  12.8337.7212.83 237,854.13 15 268,618 9,483 262,445 4.00/ 1/ 1 SELECT supp_nation, cust_natio...
fps40s3v7nd3r  7.2644.987.26 134,596.00 15 95,447 4,692 93,133 2.00/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
1gkn6r4rbdkmy  3.8948.873.89 270,478.25 4 405,253 9,957 399,255 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
bfk319z4wc782  3.8952.763.89 270,200.00 4 409,879 9,885 403,842 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su  2.9055.662.90 269,115.00 3 416,871 10,030 410,881 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x  1.9457.601.94 269,678.50 2 415,764 9,889 409,760 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td  1.9159.511.91 265,961.50 2 424,651 9,539 418,723 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
afy3mzh484trw  1.6961.201.69 235,011.00 2 369,920 9,654 361,348 11,382.00/ 1/ 1 SELECT l_orderkey, SUM(l_exten...
318ng5h3q5x791.33176.97  -1.3311,654.47 36 22,144 320 19,171 19.44 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
agz7fu32m6qn4  1.1662.361.16 161,508.00 2 390,476 8,333 386,016 36,811.00/ 1/ 1 SELECT c_custkey, c_name, SUM(...
5pnb5ryzbx5xx0.34177.31  -0.341,324.93 80 3,142 52 1,422 23.96 1// 1 SELECT TH_DTS, T_QTY, T_S_SYMB...
48ay2b94rz41x0.26177.57  -0.26195.33 413 1,020 109 727 12.58 1// 1 SELECT DM_DATE, DM_CLOSE, DM_H...
5jctjh9wmayy60.11177.67  -0.11346.56 98 2,568 19 442 1.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
83vnfyd1m59nq0.11177.78  -0.11347.42 97 2,390 20 242 1.00   DECLARE tradeid INT; BEGIN SEL...
6h7xku2zvpgsh0.06177.84  -0.06463.53 40 2,406 29 540 20.00 1// 1 Select T_CA_ID, T_EXEC_NAME, D...
7vnf1z0t36s990.04177.88  -0.0459.39 194 94 5 81 0.00 1// 1 SELECT C_ID FROM E_CUSTOMER WH...

  


   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
72vydb3ncbn3s70.9170.91  -70.912,600.09 192,407 0.00 74 537,088 9,203 526,827 1.00   DECLARE trades E_TradeList; BE...
58h9dvw8qzy7w70.91141.83  -70.912,600.01 192,401 0.00 74 535,567 9,190 526,798 0.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
bqjghjzaphzb215.44157.27  -15.4477.16 41,899 0.00 543 13,818 391 12,456 49.36 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
1x255a7m968k7  14.5114.5114.51 16,157.07 242,356 0.00 15 268,618 9,483 262,445 4.00/ 1/ 1 SELECT supp_nation, cust_natio...
1gkn6r4rbdkmy  4.9919.504.99 20,823.75 83,295 0.00 4 405,253 9,957 399,255 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
bfk319z4wc782  4.9824.474.98 20,784.00 83,136 0.00 4 409,879 9,885 403,842 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
2uzp6kw11g1su  3.7128.183.71 20,629.00 61,887 0.00 3 416,871 10,030 410,881 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
39pvzrsczv31x  2.4830.662.48 20,709.50 41,419 0.00 2 415,764 9,889 409,760 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
c0chxpnujy8td  2.4233.072.42 20,178.50 40,357 0.00 2 424,651 9,539 418,723 5.00/ 1/ 1 SELECT n_name, SUM(l_extendedp...
fps40s3v7nd3r  1.2734.341.27 1,412.00 21,180 0.00 15 95,447 4,692 93,133 2.00/ 1/ 1 SELECT O_YEAR, SUM(DECODE(NATI...
318ng5h3q5x791.13158.40  -1.1385.33 3,072 0.00 36 22,144 320 19,171 19.44 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
agz7fu32m6qn4  0.9435.280.94 7,831.00 15,662 0.00 2 390,476 8,333 386,016 36,811.00/ 1/ 1 SELECT c_custkey, c_name, SUM(...
48ay2b94rz41x0.66159.06  -0.664.31 1,781 0.00 413 1,020 109 727 12.58 1// 1 SELECT DM_DATE, DM_CLOSE, DM_H...
5pnb5ryzbx5xx0.52159.58  -0.5217.75 1,420 0.00 80 3,142 52 1,422 23.96 1// 1 SELECT TH_DTS, T_QTY, T_S_SYMB...
5jctjh9wmayy60.10159.69  -0.102.90 284 0.00 98 2,568 19 442 1.00 1// 1 SELECT T_ID FROM E_TRADE WHERE...
83vnfyd1m59nq0.10159.79  -0.102.77 269 0.00 97 2,390 20 242 1.00   DECLARE tradeid INT; BEGIN SEL...
7vnf1z0t36s990.07159.86  -0.070.99 193 0.00 194 94 5 81 0.00 1// 1 SELECT C_ID FROM E_CUSTOMER WH...
6h7xku2zvpgsh0.07159.92  -0.074.58 183 0.00 40 2,406 29 540 20.00 1// 1 Select T_CA_ID, T_EXEC_NAME, D...
95rzx549dbvs5  0.0035.280.00 0.00 0   15 466,584 25,788 443,120 175.00/ 1/ 1 SELECT NATION, O_YEAR, SUM(AMO...
afy3mzh484trw  0.0035.280.00 0.00 0   2 369,920 9,654 361,348 11,382.00/ 1/ 1 SELECT l_orderkey, SUM(l_exten...

  


   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
4j9awnaff2xjr0.56 -0.5631,342 0 0 0 0.00 1.00 1// 1 SELECT LT_PRICE FROM E_LAST_TR...
7rq305gd2gpzw0.56 -0.5631,342 0 0 0 0.00 1.00 1// 1 SELECT S_NUM_OUT FROM E_SECURI...
8v93w0n1dm76k0.56 -0.5631,342 6 0 6 0.21 1.00 1// 1 SELECT DM_CLOSE FROM E_DAILY_M...
cm5vu20fhtnq10.020.070.041,2742,1571000000.000.002.812.901/ 1/ 1 select /*+ connect_by_filterin...
7yphsb8fr4vus0.04 -0.042,280 235 1 233 0.97 1.00 1// 1 Select SE_AMT, to_char(SE_CASH...
84nxzpqwn91j50.04 -0.042,280 325 1 322 1.29 2.38 1// 1 Select to_char(TH_DTS, 'mm/dd/...
g4gkdzc5fb01z0.04 -0.042,141 268 1 264 1.25 0.97 1// 1 Select CT_AMT, to_char(CT_DTS,...
3904n1ntv7txj0.01 -0.01780 371 1 330 1.24 1.00 1// 1 Select T_BID_PRICE, T_EXEC_NAM...
6dafh4gs0k2jc0.01 -0.01780 317 1 268 1.15 1.00   Declare ex_name Varchar2(65); ...
3c1kubcdjnppq0.01 -0.01559 1 0 1 0.01 0.64 1// 1 update sys.col_usage$ set equa...
089dbukv1aanh 0.010.01 232 0 0 0 0.00 1.00/ 1/ 1 SELECT SYS_EXTRACT_UTC(SYSTIME...
8vwv6hx92ymmm 0.010.01 162 3 0 0 0.02 1.00/ 1/ 1 UPDATE MGMT_CURRENT_METRICS SE...
6xvp6nxs4a9n40.000.010.001642492100000.000.001.001.001/ 1/ 1 select nvl(sum(space), 0) from...
csnp95dz2r8ss0.000.010.001642490000000.000.000.000.001/ 1/ 1 select file#, block# from recy...
fsbqktj5vw6n9 0.000.00 124 1 1 0 0.00 1.00/ 1/ 1 select next_run_date, obj#, ru...
18naypzfmabd6 0.000.00 81 11 2 1 0.05 1.00  INSERT INTO MGMT_SYSTEM_PERFOR...
08bqjmf8490s20.000.000.00731151100000.000.000.630.661/ 1/ 1 SELECT PARAMETER_VALUE FROM MG...
350f5yrnnmshs0.000.000.001391080000000.000.000.000.00  lock table sys.mon_mods$ in ex...
g00cj285jmgsw0.000.000.001391083101200.010.000.911.001/ 1/ 1 update sys.mon_mods$ set inser...

  


   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
cm5vu20fhtnq16.106.1041.0341.0334.931,2742,1571,2742,1571/ 1/ 1 select /*+ connect_by_filterin...
6xvp6nxs4a9n40.796.894.7445.773.951642491642491/ 1/ 1 select nvl(sum(space), 0) from...
csnp95dz2r8ss0.797.674.7450.503.951642491642491/ 1/ 1 select file#, block# from recy...
bqjghjzaphzb22.6610.33  -2.66555 543 1// 1 SELECT T_CHRG, T_EXEC_NAME, EX...
9ba2vwvw6z4z82.6012.94  -2.60543 543 1// 1 SELECT C_L_NAME, C_F_NAME, B_N...
fsbqktj5vw6n9  2.3652.862.36 124 124/ 1/ 1 select next_run_date, obj#, ru...
48ay2b94rz41x1.9914.92  -1.99415 413 1// 1 SELECT DM_DATE, DM_CLOSE, DM_H...
2mw82wp65dyv51.9816.90  -1.98413 413 1// 1 SELECT S_NAME, CO_ID, CO_NAME,...
37h9f39wxj92r1.9818.88  -1.98413 413 1// 1 SELECT NI_HEADLINE, NI_SUMMARY...
9wfnvt8hnx49f1.9820.86  -1.98413 413 1// 1 SELECT CO_NAME, IN_NAME FROM E...
dbf6bmt9at48f1.9822.84  -1.98413 413 1// 1 SELECT FI_YEAR, FI_QTR, FI_QTR...
gzjm68u0xahd41.9824.82  -1.98413 413 1// 1 SELECT LT_PRICE, LT_OPEN_PRICE...
08bqjmf8490s20.3425.152.1955.051.8570115731151/ 1/ 1 SELECT PARAMETER_VALUE FROM MG...
6w6tz0ppcxb7u1.5426.69  -1.54321 321 1// 1 SELECT WI_S_SYMB FROM E_WATCH_...
089dbukv1aanh  1.4556.501.45 76 232/ 1/ 1 SELECT SYS_EXTRACT_UTC(SYSTIME...
c8h3jdwaa532q  1.4557.941.45 76 76/ 1/ 1 SELECT TO_NUMBER(PARAMETER_VAL...
350f5yrnnmshs0.6727.362.0560.001.39139108139108  lock table sys.mon_mods$ in ex...
g00cj285jmgsw0.6728.022.0562.051.391391081391081/ 1/ 1 update sys.mon_mods$ set inser...
0k8522rmdzg4k  1.0863.131.08 57 57/ 1/ 1 select privilege# from sysauth...

  


   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
gjm43un5cy843  0.220.220.22 769,086 769,086 1 SELECT SUM(USED), SUM(TOTAL) F...
d8mayxqw0wnpv  0.100.330.10 351,762 351,762 4 SELECT OWNER FROM DBA_PROCEDUR...
gcph0kd36arc60.100.10  -0.10308,011 308,011 1  SELECT /*+ ORDERED PUSH_SUBQ *...
6wm3n4d7bnddg  0.090.420.09 318,578 318,578 1 SELECT source, (case when tim...
ab3swhv5g138y0.090.19  -0.09283,194 283,194 1  select OBJOID, CLSOID, RUNTIME...
25fu98m3hw2ts  0.080.500.08 272,688 272,688 2 SELECT VALUE FROM MGMT_CURRENT...
fdjtrdaz8hpvg0.070.25  -0.07209,408 209,408 6  INSERT /*+ APPEND LEADING(@"SE...
7ng34ruy5awxq0.050.30  -0.05152,138 152,138 182  select i.obj#, i.ts#, i.file#,...
bn4b3vjw2mj3u  0.050.550.05 163,792 163,792 20 SELECT OBJOID, CLSOID, DECODE(...
4jrfrtx4u6zcx  0.040.590.04 143,744 143,744 39 SELECT TASK_TGT.TARGET_GUID TA...
bqjghjzaphzb20.040.34  -0.04116,729 116,729 543  SELECT T_CHRG, T_EXEC_NAME, EX...
8vwv6hx92ymmm  0.040.620.04 121,448 121,448 162 UPDATE MGMT_CURRENT_METRICS SE...
9tgj4g8y4rwy80.030.37  -0.03105,259 105,259 147  select type#, blocks, extents,...
1gu8t96d0bdmu0.030.41  -0.03104,076 104,076 107  select t.ts#, t.file#, t.block...
1fwcc9b0mbzum  0.030.660.03 113,568 113,568 1 SELECT l_orderkey, SUM(l_exten...
4ttpsft97zujk  0.030.690.03 113,568 113,568 1 SELECT l_orderkey, SUM(l_exten...
6uusdb8z8usyu  0.030.720.03 113,568 113,568 1 SELECT l_orderkey, SUM(l_exten...
fjpgrrp53dtxj0.030.44  -0.0396,910 96,910 141  SELECT B_NAME, NVL(SUM(TR_QTY...
3ktacv9r56b510.030.47  -0.0393,074 93,074 54  select owner#, name, namespace...
6qz82dptj0qr70.020.49  -0.0276,440 76,440 22  select l.col#, l.intcol#, l.lo...

  


   Back to SQL Statistics
Back to Top

  

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
7ng34ruy5awxq12 -1212 182  select i.obj#, i.ts#, i.file#,...
1gu8t96d0bdmu8 -88 107  select t.ts#, t.file#, t.block...
39m4sx9k63ba28 -88 107  select /*+ index(idl_ub2$ i_id...
c6awqs517jpj08 -88 107  select /*+ index(idl_char$ i_i...
cvn54b7yz0s8u8 -88 107  select /*+ index(idl_ub1$ i_id...
ga9j9xk5cy9s08 -88 107  select /*+ index(idl_sb4$ i_id...
25fu98m3hw2ts 66 6 2 SELECT VALUE FROM MGMT_CURRENT...
gjm43un5cy843 66 6 1 SELECT SUM(USED), SUM(TOTAL) F...
gx4mv66pvj3xz6 -66 192  select con#, type#, condlength...
18naypzfmabd6 44 4 81 INSERT INTO MGMT_SYSTEM_PERFOR...
1fwcc9b0mbzum 44 4 1 SELECT l_orderkey, SUM(l_exten...
3ktacv9r56b514 -44 54  select owner#, name, namespace...
45cngnmv709m44 -44 1  select subscriber_id, name, ad...
4ttpsft97zujk 44 4 1 SELECT l_orderkey, SUM(l_exten...
5n1fs4m2n2y0r4 -44 254  select pos#, intcol#, col#, sp...
6ajkhukk78nsr 44 4 1 begin prvt_hdm.auto_execute( :...
6uusdb8z8usyu 44 4 1 SELECT l_orderkey, SUM(l_exten...
8vwv6hx92ymmm 44 4 162 UPDATE MGMT_CURRENT_METRICS SE...
59ahdunmw6xbz 33 3 1 SELECT l_orderkey, SUM(l_exten...
08bqjmf8490s23303373115 SELECT PARAMETER_VALUE FROM MG...

  


   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
07yqdn45g0uwp  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT l_returnflag, l_linesta...
089dbukv1aanh  0.000.000.00 0.00 0.00 232/ 1/ 1 SELECT SYS_EXTRACT_UTC(SYSTIME...
08bqjmf8490s20.000.000.000.000.000.000.000.000.00731151/ 1/ 1 SELECT PARAMETER_VALUE FROM MG...
08vznc16ycuag  0.000.000.00 0.00 0.00 38/ 1/ 1 SELECT SYS_GUID() FROM SYS.DUA...
09zd7hgsfrdg6  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT l_returnflag, l_linesta...
0k8522rmdzg4k  0.000.000.00 0.00 0.00 57/ 1/ 1 select privilege# from sysauth...
0m78skf1mudnb0.000.00  0.000.00 0.00 9 1// 1 select audit$, properties from...
0n3h2c1ufzma40.000.00  0.000.00 0.00 1 1// 1 SELECT COLLECTION_TIMESTAMP, R...
0v3dvmc22qnam0.000.00  0.000.00 0.00 202   insert into sys.col_usage$ (ob...
111xpqwr0sfjg0.000.00  0.000.00 0.00 317   Begin Update E_Trade Set T_COM...
12qmb2vstfhgy  0.000.000.00 0.00 0.00 2/ 1/ 1 SELECT c_custkey, c_name, SUM(...
15p4z9yvdc8ua0.000.00  0.000.00 0.00 70 1// 1 SELECT T_EXEC_NAME, T_BID_PRIC...
1809cng2r987s  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT c_custkey, c_name, SUM(...
18naypzfmabd6  0.000.000.00 0.00 0.00 81  INSERT INTO MGMT_SYSTEM_PERFOR...
1ba09vhjx4rxj  0.000.000.00 0.00 0.00 1/ 1/ 1 SELECT l_orderkey, SUM(l_exten...
1gu8t96d0bdmu0.000.00  0.000.00 0.00 107 2// 2 select t.ts#, t.file#, t.block...
21mdxpk0d7jt70.000.00  0.000.00 0.00 317 1// 1 UPDATE E_BROKER SET B_COMM_TOT...
2mw82wp65dyv50.000.00  0.000.00 0.00 413 1// 1 SELECT S_NAME, CO_ID, CO_NAME,...
2vcn91b1wtmc60.000.00  0.000.00 0.00 144 1// 1 SELECT TH_DTS, TH_ST_ID FROM E...

  


   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 changes34,1887,268-78.740.610.23-62.3025.333.17-87.4924.6332.7432.93
execute count136,3257,864-94.232.440.24-90.16101.023.43-96.6098.2235.42-63.94
logons cumulative240148-38.330.000.000.000.180.06-66.670.170.67294.12
opened cursors cumulative21,1417,236-65.770.380.22-42.1115.673.16-79.8315.2332.59113.99
parse count (total)20,8735,257-74.810.370.16-56.7615.472.29-85.2015.0423.6857.45
parse time elapsed59,1951,035-98.251.060.03-97.1743.870.45-98.9742.654.66-89.07
physical reads31,527,63827,809,588-11.79563.97861.8152.8123,362.8912,137.94-48.0522,714.44125,268.41451.49
physical writes4,805604,52012,481.060.0918.7320,711.113.56263.857,311.523.462,723.0678,601.16
redo size9,317,4403,763,776-59.61166.67116.64-30.026,904.491,642.76-76.216,712.8516,953.95152.56
session cursor cache hits16,4635,006-69.590.290.16-44.8312.202.18-82.1311.8622.5590.13
session logical reads33,179,61017,774,862-46.43593.52550.84-7.1924,587.057,758.12-68.4523,904.6280,066.95234.94
user calls209,267366,55175.163.7411.36203.74155.07159.993.17150.771,651.13995.13
user commits1,330222-83.310.020.01-50.000.990.10-89.900.961.004.17
workarea executions - optimal9,7973,070-68.660.180.10-44.447.261.34-81.547.0613.8395.89

  


   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 count199130-34.670.000.000.000.150.06-60.000.140.59321.43
Batched IO block miss count6,438533-91.720.120.02-83.334.770.23-95.184.642.40-48.28
Batched IO buffer defrag count903-96.670.000.000.000.070.00-100.000.060.01-83.33
Batched IO double miss count53614-97.390.010.00-100.000.400.01-97.500.390.06-84.62
Batched IO same unit count1,538327-78.740.030.01-66.671.140.14-87.721.111.4732.43
Batched IO single block count3696166.670.000.000.000.030.0433.330.030.431,333.33
Batched IO slow jump count61-83.330.000.000.000.000.000.000.000.000.00
Batched IO vector block count4,81298-97.960.090.00-100.003.570.04-98.883.470.44-87.32
Batched IO vector read count48235-92.740.010.00-100.000.360.02-94.440.350.16-54.29
Block Cleanout Optim referenced72-71.430.000.000.000.010.00-100.000.010.010.00
CPU used by this session107,873132,18022.531.934.10112.4479.9457.69-27.8377.72595.41666.10
CPU used when call started101,091131,36829.951.814.07124.8674.9157.34-23.4572.83591.75712.51
CR blocks created65415-97.710.010.00-100.000.480.01-97.920.470.07-85.11
DBWR checkpoint buffers written4,4661,210-72.910.080.04-50.003.310.53-83.993.225.4569.25
DBWR transaction table writes1711805.260.000.01100.000.130.08-38.460.120.81575.00
DBWR undo block writes549340-38.070.010.010.000.410.15-63.410.401.53282.50
HSC Heap Segment Block Changes9,1961,001-89.110.160.03-81.256.810.44-93.546.634.51-31.98
Heap Segment Array Inserts981079.180.000.000.000.070.05-28.570.070.48585.71
Number of read IOs issued247,268139,710-43.504.424.33-2.04183.2360.98-66.72178.15629.32253.25
RowCR attempts866157-81.870.020.00-100.000.640.07-89.060.620.7114.52
RowCR hits1,139157-86.220.020.00-100.000.840.07-91.670.820.71-13.41
SQL*Net roundtrips to/from client208,400365,94275.603.7311.34204.02154.43159.723.43150.141,648.39997.90
active txn count during cleanout3,12370-97.760.060.00-100.002.310.03-98.702.250.32-85.78
background timeouts6,52211,21271.910.120.35191.674.834.891.244.7050.50974.47
buffer is not pinned count541,66832,244-94.059.691.00-89.68401.3914.07-96.49390.25145.24-62.78
buffer is pinned count56,313104,86186.211.013.25221.7841.7345.779.6840.57472.351,064.28
bytes received via SQL*Net from client8,330,4514,144,439-50.25149.01128.44-13.806,173.111,808.91-70.706,001.7718,668.64211.05
bytes sent via SQL*Net to client32,778,388124,252,062279.07586.343,850.54556.7124,289.7354,231.81123.2723,615.55559,693.972,270.02
calls to get snapshot scn: kcmgss133,7898,806-93.422.390.27-88.7099.143.84-96.1396.3939.67-58.84
calls to kcmgas3,209871-72.860.060.03-50.002.380.38-84.032.313.9269.70
calls to kcmgcs72,1267,666-89.371.290.24-81.4053.453.35-93.7351.9634.53-33.55
cell physical IO interconnect bytes258,531,383,296232,923,072,000-9.914,624,605.567,218,224.9856.08191,579,231.40101,663,010.68-46.93186,261,803.531,049,203,027.03463.29
change write time22489-60.270.000.000.000.170.04-76.470.160.40150.00
cleanout - number of ktugct calls1,83972-96.080.030.00-100.001.360.03-97.791.320.32-75.76
cluster key scan block gets2,3892,279-4.600.040.0775.001.770.99-44.071.7210.27497.09
cluster key scans1,2432,02362.750.020.06200.000.920.88-4.350.909.11912.22
commit cleanout failures: callback failure64-33.330.000.000.000.000.000.000.000.02100.00
commit cleanout failures: cannot pin151-93.330.000.000.000.010.00-100.000.010.00-100.00
commit cleanouts8,7111,513-82.630.160.05-68.756.460.66-89.786.286.828.60
commit cleanouts successfully completed8,6841,508-82.630.160.05-68.756.440.66-89.756.266.798.47
commit txn count during cleanout31841-87.110.010.00-100.000.240.02-91.670.230.18-21.74
consistent changes1,53845-97.070.030.00-100.001.140.02-98.251.110.20-81.98
consistent gets33,147,54817,764,953-46.41592.94550.53-7.1524,563.297,753.80-68.4323,881.5280,022.31235.08
consistent gets - examination490,67926,338-94.638.780.82-90.66363.6111.50-96.84353.52118.64-66.44
consistent gets direct31,331,29917,271,495-44.87560.45535.24-4.5023,217.407,538.42-67.5322,572.9877,799.53244.66
consistent gets from cache1,816,249493,458-72.8332.4915.29-52.941,345.89215.38-84.001,308.542,222.7869.87
consistent gets from cache (fastpath)1,310,977465,890-64.4623.4514.44-38.42971.47203.35-79.07944.512,098.60122.19
cursor authentications57216-97.200.010.00-100.000.420.01-97.620.410.07-82.93
data blocks consistent reads - undo records applied19,44734-99.830.350.00-100.0014.410.01-99.9314.010.15-98.93
db block gets32,0629,909-69.090.570.31-45.6123.764.32-81.8223.1044.6493.25
db block gets direct222130-41.440.000.000.000.160.06-62.500.160.59268.75
db block gets from cache31,8409,779-69.290.570.30-47.3723.594.27-81.9022.9444.0592.02
db block gets from cache (fastpath)7,5751,958-74.150.140.06-57.145.610.85-84.855.468.8261.54
deferred (CURRENT) block cleanout applications4,172865-79.270.070.03-57.143.090.38-87.703.013.9029.57
enqueue conversions3,912470-87.990.070.01-85.712.900.21-92.762.822.12-24.82
enqueue releases37,48335,587-5.060.671.1064.1827.7815.53-44.1027.01160.30493.48
enqueue requests37,74535,587-5.720.681.1061.7627.9715.53-44.4827.19160.30489.55
flashback log write bytes23,904,2567,168,000-70.01427.60222.13-48.0517,713.743,128.59-82.3417,222.0932,288.2987.48
flashback log writes46057-87.610.010.00-100.000.340.02-94.120.330.26-21.21
free buffer inspected20,298365-98.200.360.01-97.2215.040.16-98.9414.621.64-88.78
free buffer requested41,556393-99.050.740.01-98.6530.790.17-99.4529.941.77-94.09
heap block compress2523-8.000.000.000.000.020.01-50.000.020.10400.00
hot buffers moved to head of LRU15,694701-95.530.280.02-92.8611.630.31-97.3311.313.16-72.06
immediate (CURRENT) block cleanout applications24731125.910.000.01100.000.180.14-22.220.181.40677.78
index fast full scans (full)4177-98.320.010.00-100.000.310.00-100.000.300.03-90.00
index fetch by key168,9698,133-95.193.020.25-91.72125.213.55-97.16121.7436.64-69.90
index scans kdiixs117,86719,91311.450.320.6293.7513.248.69-34.3712.8789.70596.97
leaf node 90-10 splits3832-15.790.000.000.000.030.01-66.670.030.14366.67
leaf node splits4840-16.670.000.000.000.040.02-50.000.030.18500.00
lob writes25150.000.000.000.000.000.000.000.000.02100.00
lob writes unaligned25150.000.000.000.000.000.000.000.000.02100.00
max cf enq hold time9070-22.220.000.000.000.070.03-57.140.060.32433.33
messages received4,8191,247-74.120.090.04-55.563.570.54-84.873.475.6261.96
messages sent4,8191,247-74.120.090.04-55.563.570.54-84.873.475.6261.96
no work - consistent read gets32,570,24617,730,030-45.56582.62549.45-5.6924,135.497,738.56-67.9423,465.6079,865.00240.35
non-idle wait count563,3782,131,884278.4110.0866.07555.46417.48930.49122.88405.899,603.082,265.93
parse count (hard)6,20431-99.500.110.00-100.004.600.01-99.784.470.14-96.87
parse time cpu1,88697-94.860.030.00-100.001.400.04-97.141.360.44-67.65
physical read IO requests271,3221,670,321515.624.8551.76967.22201.06729.04262.60195.487,523.973,748.97
physical read bytes258,274,410,496227,816,144,896-11.794,620,008.847,059,962.6552.81191,388,807.1399,434,010.44-48.05186,076,664.621,026,198,850.88451.49
physical read total IO requests274,4711,674,382510.044.9151.89956.82203.39730.81259.31197.757,542.263,714.04
physical read total bytes258,332,882,944227,882,796,032-11.794,621,054.797,062,028.1552.82191,432,136.9099,463,101.39-48.04186,118,791.751,026,499,081.23451.53
physical read total multi block requests247,905135,636-45.294.434.20-5.19183.7059.20-67.77178.61610.97242.07
physical reads cache37,650336-99.110.670.01-98.5127.900.15-99.4627.131.51-94.43
physical reads cache prefetch18,72234-99.820.330.00-100.0013.870.01-99.9313.490.15-98.89
physical reads direct31,489,98827,809,252-11.69563.29861.8052.9923,334.9912,137.79-47.9822,687.31125,266.90452.15
physical reads for flashback new384171-55.470.010.010.000.280.07-75.000.280.77175.00
physical write IO requests2,53887,1603,334.200.052.705,300.001.8838.041,923.401.83392.6121,354.10
physical write bytes39,362,5604,952,227,84012,481.06704.12153,468.2421,695.7529,168.802,161,479.277,310.2428,359.1922,307,332.6178,559.98
physical write total IO requests8,86289,813913.460.162.781,637.506.5739.20496.656.38404.566,241.07
physical write total bytes152,539,1364,997,762,0483,176.382,728.62154,879.345,576.11113,035.912,181,353.411,829.79109,898.5122,512,441.6620,384.76
physical write total multi block requests18748-74.330.000.000.000.140.02-85.710.130.2269.23
physical writes direct222603,310271,661.260.0018.70100.000.16263.32164,475.000.162,717.611,698,406.25
physical writes from cache4,5831,210-73.600.080.04-50.003.400.53-84.413.305.4565.15
physical writes non checkpoint3,494603,52417,173.150.0618.7031,066.672.59263.4210,070.662.522,718.58107,780.16
recursive calls153,51553,142-65.382.751.65-40.00113.7623.19-79.61110.60239.38116.44
recursive cpu usage77,167817-98.941.380.03-97.8357.180.36-99.3755.603.68-93.38
redo blocks checksummed by FG (exclusive)6,7904,917-27.580.120.1525.005.032.15-57.264.8922.15352.97
redo blocks written19,7847,835-60.400.350.24-31.4314.663.42-76.6714.2535.29147.65
redo entries20,0644,904-75.560.360.15-58.3314.872.14-85.6114.4622.0952.77
redo ordering marks444180-59.460.010.010.000.330.08-75.760.320.81153.13
redo size for direct writes1,836,2961,075,360-41.4432.8533.331.461,360.75469.36-65.511,322.984,843.96266.14
redo subscn max counts1,987457-77.000.040.01-75.001.470.20-86.391.432.0644.06
redo synch time2,416451-81.330.040.01-75.001.790.20-88.831.742.0316.67
redo synch writes1,29578-93.980.020.00-100.000.960.03-96.880.930.35-62.37
redo wastage555,308110,300-80.149.933.42-65.56411.5048.14-88.30400.08496.8524.19
redo write time3,187931-70.790.060.03-50.002.360.41-82.632.304.1982.17
redo writes2,136446-79.120.040.01-75.001.580.19-87.971.542.0130.52
rollbacks only - consistent read gets10,49215-99.860.190.00-100.007.770.01-99.877.560.07-99.07
rows fetched via callback153,8163,036-98.032.750.09-96.73113.981.33-98.83110.8213.68-87.66
session pga memory235,434,640120,232,392-48.934,211.453,725.97-11.53174,463.8852,477.36-69.92169,621.50541,587.35219.29
session pga memory max461,100,208122,001,864-73.548,248.153,780.81-54.16341,688.5953,249.67-84.42332,204.76549,557.9565.43
session uga memory103,148,550,960184,691,075,79279.051,845,119.755,723,528.05210.2076,436,059.1880,611,382.335.4674,314,517.98831,941,782.851,019.49
session uga memory max412,375,632166,179,896-59.707,376.575,149.87-30.19305,582.2772,531.88-76.26297,100.60748,558.09151.95
shared hash latch upgrades - no wait21,3201,016-95.230.380.03-92.1115.800.44-97.2215.364.58-70.18
sorts (memory)11,5776,908-40.330.210.210.008.583.02-64.808.3431.12273.14
sorts (rows)124,53794,764,37475,993.352.232,936.72131,591.4892.2941,361.4344,716.8189.72426,866.55475,676.36
sql area evicted5,5284-99.930.100.00-100.004.100.00-100.003.980.02-99.50
switch current to new buffer5917-71.190.000.000.000.040.01-75.000.040.08100.00
table fetch by rowid197,87953,595-72.923.541.66-53.11146.6323.39-84.05142.56241.4269.35
table scan blocks gotten32,483,43617,688,555-45.55581.06548.16-5.6624,071.177,720.45-67.9323,403.0579,678.18240.46
table scan rows gotten1,811,522,5291,000,452,129-44.7732,404.4931,003.75-4.321,342,390.58436,663.38-67.471,305,131.514,506,541.12245.29
table scans (direct read)2,240255-88.620.040.01-75.001.660.11-93.371.611.15-28.57
table scans (long tables)5,681255-95.510.100.01-90.004.210.11-97.394.091.15-71.88
table scans (short tables)1,0632,01989.930.020.06200.000.790.8811.390.779.091,080.52
total cf enq hold time7,5803,250-57.120.140.10-28.575.621.42-74.735.4614.64168.13
total number of cf enq holders138136-1.450.000.000.000.100.06-40.000.100.61510.00
undo change vector size2,656,212962,204-63.7847.5129.82-37.231,968.33419.97-78.661,913.704,334.25126.49

  


   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
182.5694.86-48.040.220.00-100.00182.3091.03-50.070.112.081,790.910.030.00-100.000.000.73100.000.010.00-100.00

  


   Back to IO Stats
Back to Top

  

IOStat by Function - Requests per Second

Total Reads Buffer Cache Reads Direct Reads Total Writes DBWR Direct Writes LGWR
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
203.45730.80259.2017.270.14-99.19183.84724.83294.276.5839.20495.741.870.39-79.140.0113.45134,400.003.230.39-87.93

  


   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
182.5794.86-48.04182.5358.90-67.730.0035.93100.000.112.081,790.910.030.00-100.000.002.06100.000.010.00-100.00

  


   Back to IO Stats
Back to Top

  

IOStat by File Type - Requests per Second

Total Reads Data File Reads Temp File Reads Total Writes Data File Writes Temp File Writes Log File Writes
1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
203.44730.79259.22201.1761.15-69.600.00667.91100.006.5939.20494.841.890.39-79.370.0037.65100.003.240.39-87.96

  


   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
TPCH_BIGTEMP  667.91100.00 37.64100.00 1,530,257 0.00 6.89 86,242 0 0.00 705.55 
TPCE_TRADE_DATA 184.430.00-100.000.740.00-100.00248,88403.240.00126.110.0099402440330.120.00185.170.00-185.17
TPCH_REF_DATA 0.0061.04100.000.000.000.000139,8420.000.030.00123.51000470.0050.430.0061.0461.04
TPCE_TRADE_HISTORY_IDX 1.910.00-100.000.010.00-100.002,5810159.050.001.250.00110950320.210.001.920.00-1.92
TPCE_SETTLEMENT_DATA 1.710.00-100.000.200.00-100.002,3130164.380.001.290.002650250244.400.001.910.00-1.91
TPCE_DAILY_MARKET_DATA 1.790.00-100.000.010.00-100.002,417057.190.0035.450.00801,0370126.750.001.800.00-1.80
TPCE_TRADE_HISTORY_DATA 1.750.00-100.000.020.00-100.002,3680185.030.001.250.00290140165.710.001.780.00-1.78
TPCE_CASH_TRANSACTION_DATA 1.650.00-100.000.110.00-100.002,2270373.420.001.330.001430470231.060.001.760.00-1.76
TPCE_TRADE_IDX 1.680.00-100.000.000.000.002,2630236.540.001.590.0060160157.500.001.680.00-1.68
TPCE_SETTLEMENT_IDX 1.570.00-100.000.000.000.002,1120126.270.001.270.0060200363.000.001.570.00-1.57
TPCE_CASH_TRANSACTION_IDX 1.510.00-100.000.000.000.002,0410253.430.001.270.0030270280.740.001.510.00-1.51
SYSTEM 0.770.00-100.000.030.02-33.331,04400.000.001.010.00423776020.790.000.800.02-0.79
TPCE_DAILY_MARKET_IDX 0.690.00-100.000.000.000.009370130.530.001.820.00006098.330.000.690.00-0.69
TPCE_REF_DATA 0.450.00-100.000.000.000.0061003.490.004.860.000060072.830.000.450.00-0.45
UNDOTBS1 0.220.03-86.360.250.16-36.00292710.000.001.001.00341364907.780.000.470.19-0.28
TPCE_WATCH_LIST_DATA 0.240.00-100.000.000.000.0032401.700.0015.860.0000120167.500.000.240.00-0.24
SYSAUX 0.110.06-45.450.330.21-36.361551400.000.003.301.86450492000.000.000.450.28-0.17
TPCE_CUSTOMER_DATA 0.150.00-100.000.000.000.0020503.120.0056.460.000040167.500.000.150.00-0.15
TPCE_COMPANY_DATA 0.120.00-100.000.000.000.0016501.210.0057.430.0000407.500.000.120.00-0.12
TPCE_HOLDING_HISTORY_DATA 0.010.00-100.000.070.00-100.0016080.630.001.000.008806802.650.000.080.00-0.08
TPCE_WATCH_ITEM_IDX 0.080.00-100.000.000.000.001040256.350.003.640.000070181.430.000.080.00-0.08

  


   Back to IO Stats
Back to Top

  

Top File Comparison by IO

   No data exists for this section of the report.

   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
SYSAUX+DATA/orcl/datafile/sysaux.258.716405081 0.000.000.000.000.001551400.110.063.301.864504920.330.21000.000.00
SYSTEM+DATA/orcl/datafile/system.259.716405187 0.000.000.000.000.001,04400.770.001.010.0042370.030.027602.080.00

  


   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
SYSTEM+DATA/orcl/datafile/system.259.716405187 0.000.00-0.007602.080.001,04400.770.000.000.001.010.00423700
TPCE_ADDRESS_DATA/u01/app/oradata/TPCE/tpce_address_data01.dbf 0.000.00-0.002007.750.001200.010.00140.000.005.250.000000

  


   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)
B10213691,3132,360424,6022,360   
E10213792,71921,163424,60221,163   
           
B20213361,1331,843424,6021,843   
E20213362,2905,516424,6025,516   

  


   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.0026.03-73.9710,71488,994730.635712,7390145,986100.0007,783

  


   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)
B11509202.60.00.00.00.030,720
E11509435.90.00.00.00.030,720
         
B21509186.60.00.00.00.030,720
E21509188.70.00.00.00.030,720

  


   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.00248.342.371,653471.500.50-66.67
extent map0.000.00-0.0029.200.006004.870.00-100.00
segment header0.000.00-0.0016.570.0013801.200.00-100.00
1st level bmb0.000.00-0.0010.170.006701.520.00-100.00
2nd level bmb0.000.00-0.001.480.003100.480.00-100.00
undo header0.000.00-0.000.040.00600.070.00-100.00
undo block0.000.00-0.000.030.00300.100.00-100.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
KO-Multiple Object Checkpoint (fast object checkpo1.610.00-1.6190006,08406,08400066601,351.680.00
TX-Transaction (row lock contention)0.110.00-0.11630270270002702,341.480.00
PR-Process Startup0.050.00-0.05300103891038900407,580.000.00
TX-Transaction (index contention)0.010.00-0.016023023000230272.170.00
HW-Segment High Water Mark0.000.00-0.00202001282001280038059.210.00
CF-Controlfile Transaction0.000.00-0.00107171,0347171,03400101,030.000.00

  


   Back to Wait Stats
Back to Top

  

  

Undo Segment Summary

Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1st0.542,1007522124.1/25.60/00/0/0/0/0/0
2nd0.174481,274323.1/33.30/00/0/0/0/0/0

  


  
Back to Top

  

  

Latch Statistics

Back to Top

  

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Wait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool81.1541.89-39.26317,47411,6713,152541,548281,92431271,472,708850,219-270,622,489
cache buffers chains11.6433.7822.143,358,455999,904756108499832762513,068,358700,613-12,367,745
sort extent pool0.0014.8614.8690329,8080102091011015,73915,739
process allocation12.400.00-12.403,3582993102029404,134,6750-4,134,675
cache buffers lru chain5.150.00-5.1523,9551,290137022012204,880,2310-4,880,231
active service list0.044.054.015,0677,62323101373,92843,832-30,096
session idle bit0.384.053.67420,127733,321474840459330,458592-29,866
simulator hash latch0.042.702.66146,769636,9391180161284015,23914,399
kks stats2.660.00-2.6631,50855650206309,934,0650-9,934,065
row cache objects2.490.00-2.49299,91443,142159010005902,704,6110-2,704,611
object queue header operation0.422.702.28101,44412,49736226010293,7408,330-85,410
FOB s.o list latch2.280.00-2.282,1029785200054011,699,5060-11,699,506
Real-time plan statistics latch1.770.00-1.7713,5011,439183114314201,094,8390-1,094,839
query server process1.560.00-1.564601800037023,212,3820-23,212,382
JS Sh mem access0.001.351.35350100010179179
ksv class latch0.001.351.353141780201010205205
enqueue hash chains0.800.00-0.8080,85571,629372182190474,0000-474,000
SQL memory manager latch0.760.00-0.761,46717520020180196,6260-196,626
parallel query alloc buffer0.760.00-0.761,78730520070180197,7750-197,775
call allocation0.340.00-0.342,310681110308012,9030-12,903
SGA IO buffer pool latch0.300.00-0.303440700070931,5710-931,571
enqueues0.300.00-0.3061,11268,24219512570337,5750-337,575
redo allocation0.170.00-0.176,7522,561400040110,5880-110,588
loader state object freelist0.130.00-0.134,5062,03430003062,7310-62,731
shared pool simulator0.080.00-0.0851,02420630102032,9770-32,977
cache buffer handles0.040.00-0.043,576226403010340-34
dummy allocation0.040.00-0.044432971000108,8020-8,802
hash table column usage latch0.040.00-0.043621310001012,0560-12,056
process queue reference0.040.00-0.0450,2661605010230-23
simulator lru latch0.040.00-0.042,480728100010200-20
space background task latch0.040.00-0.041,0031,69810001027,9240-27,924

  


   Back to Latch Statistics
Back to Top

  

Latch Wait Time Breakdown

 Wait Time (cs) Get Requests Misses Spin Gets Sleeps % of Total Sleeps
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
shared pool271,472,708850,219-270,622,489317,47411,6713,152541,548281,9243181.1541.89-39.26
query server process23,212,3820-23,212,382460180003701.560.00-1.56
cache buffers chains13,068,358700,613-12,367,7453,358,455999,904756108499832762511.6433.7822.14
FOB s.o list latch11,699,5060-11,699,5062,102978520005402.280.00-2.28
kks stats9,934,0650-9,934,06531,50855650206302.660.00-2.66
cache buffers lru chain4,880,2310-4,880,23123,9551,290137022012205.150.00-5.15
process allocation4,134,6750-4,134,6753,35829931020294012.400.00-12.40
row cache objects2,704,6110-2,704,611299,91443,142159010005902.490.00-2.49
Real-time plan statistics latch1,094,8390-1,094,83913,5011,439183114314201.770.00-1.77
SGA IO buffer pool latch931,5710-931,57134407000700.300.00-0.30
enqueue hash chains474,0000-474,00080,85571,6293721821900.800.00-0.80
enqueues337,5750-337,57561,11268,242195125700.300.00-0.30
parallel query alloc buffer197,7750-197,7751,787305200701800.760.00-0.76
SQL memory manager latch196,6260-196,6261,467175200201800.760.00-0.76
redo allocation110,5880-110,5886,7522,5614000400.170.00-0.17
object queue header operation93,7408,330-85,410101,44412,4973622601020.422.702.28
loader state object freelist62,7310-62,7314,5062,0343000300.130.00-0.13
shared pool simulator32,9770-32,97751,0242063010200.080.00-0.08
active service list73,92843,832-30,0965,0677,6232310130.044.054.01
session idle bit30,458592-29,866420,127733,32147484045930.384.053.67
space background task latch27,9240-27,9241,0031,6981000100.040.00-0.04
sort extent pool015,73915,73990329,80801020910110.0014.8614.86
simulator hash latch84015,23914,399146,769636,939118016120.042.702.66
call allocation12,9030-12,9032,31068111030800.340.00-0.34
hash table column usage latch12,0560-12,056362131000100.040.00-0.04
dummy allocation8,8020-8,8024432971000100.040.00-0.04
ksv class latch02052053141780201010.001.351.35
JS Sh mem access0179179350100010.001.351.35
cache buffer handles340-343,5762264030100.040.00-0.04
process queue reference230-2350,26616050100.040.00-0.04
simulator lru latch200-202,4807281000100.040.00-0.04

  


   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
TPCETPCE_TRADE_DATAE_TRADE TABLE94.2494.24  -94.2431,268,448  94.57 -94.57
TPCHTPCH_REF_DATAH_LINEITEM TABLE  82.6782.6782.67 14,693,856  82.7482.74
TPCHTPCH_REF_DATAH_ORDER TABLE  13.8096.4713.80 2,452,768  13.8113.81
TPCETPCE_DAILY_MARKET_DATAE_DAILY_MARKET TABLE3.4997.73  -3.491,157,936  3.50 -3.50
TPCHTPCH_REF_DATAH_CUSTOMER TABLE  1.2797.741.27 225,664  1.271.27
TPCHTPCH_REF_DATAH_PART TABLE  0.9698.690.96 170,064  0.960.96
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  0.7799.460.77 136,448  0.770.77
TPCETPCE_DAILY_MARKET_IDXE_DAILY_MARKET_PK_IDX INDEX0.2998.02  -0.2996,352  0.29 -0.29
TPCETPCE_SECURITY_DATAE_SECURITY TABLE0.2598.27  -0.2584,288  0.25 -0.25
TPCETPCE_SECURITY_IDXE_SECURITY_PK_IDX INDEX0.2298.49  -0.2273,232  0.22 -0.22

  


   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
TPCETPCE_TRADE_DATAE_TRADE TABLE99.5599.55  -99.5531,385,936  99.56 -99.56
TPCHTPCH_REF_DATAH_LINEITEM TABLE  52.8452.8452.84 14,694,075  85.0885.08
TPCHTPCH_REF_DATAH_ORDER TABLE  8.8261.668.82 2,452,485  14.2014.20
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  0.4562.110.45 125,049  0.720.72
TPCETPCE_DAILY_MARKET_DATAE_DAILY_MARKET TABLE0.2799.82  -0.2785,675  0.27 -0.27
TPCETPCE_CUSTOMER_DATAE_CUSTOMER TABLE0.0499.86  -0.0411,574  0.04 -0.04
TPCETPCE_COMPANY_DATAE_COMPANY TABLE0.0399.89  -0.039,476  0.03 -0.03
TPCETPCE_WATCH_LIST_DATAE_WATCH_LIST TABLE0.0299.91  -0.025,139  0.02 -0.02
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION0.0099.910.0062.11-0.00229132-42.360.000.000.00
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.0099.910.0062.110.00304860.000.000.000.00

  


   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
TPCETPCE_TRADE_DATAE_TRADE TABLE91.7391.73  -91.73248,882  92.25 -92.25
TPCHTPCH_REF_DATAH_LINEITEM TABLE  7.047.047.04 117,584  84.0184.01
TPCHTPCH_REF_DATAH_ORDER TABLE  1.258.291.25 20,894  14.9314.93
TPCETPCE_TRADE_HISTORY_IDXE_TRADE_HISTORY_PK_IDX INDEX0.9592.68  -0.952,581  0.96 -0.96
TPCETPCE_DAILY_MARKET_DATAE_DAILY_MARKET TABLE0.8993.57  -0.892,417  0.90 -0.90
TPCETPCE_TRADE_HISTORY_DATAE_TRADE_HISTORY TABLE0.8794.44  -0.872,368  0.88 -0.88
TPCETPCE_SETTLEMENT_DATAE_SETTLEMENT TABLE0.8595.30  -0.852,313  0.86 -0.86
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  0.088.370.08 1,344  0.960.96
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.0195.310.008.37-0.01304860.000.010.030.02
TPCHTPCH_REF_DATAH_PARTSUPP_IDX1 INDEX  0.008.370.00 18  0.010.01

  


   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
TPCETPCE_TRADE_DATAE_TRADE TABLE91.7391.73  -91.73248,882  92.25 -92.25
TPCHTPCH_REF_DATAH_LINEITEM TABLE  7.047.047.04 117,584  84.0184.01
TPCHTPCH_REF_DATAH_ORDER TABLE  1.258.291.25 20,894  14.9314.93
TPCETPCE_TRADE_HISTORY_IDXE_TRADE_HISTORY_PK_IDX INDEX0.9592.68  -0.952,581  0.96 -0.96
TPCETPCE_DAILY_MARKET_DATAE_DAILY_MARKET TABLE0.8993.57  -0.892,417  0.90 -0.90
TPCETPCE_TRADE_HISTORY_DATAE_TRADE_HISTORY TABLE0.8794.44  -0.872,368  0.88 -0.88
TPCETPCE_SETTLEMENT_DATAE_SETTLEMENT TABLE0.8595.30  -0.852,313  0.86 -0.86
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  0.088.370.08 1,344  0.960.96
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.0195.310.008.37-0.01304860.000.010.030.02
TPCHTPCH_REF_DATAH_PARTSUPP_IDX1 INDEX  0.008.370.00 18  0.010.01

  


   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
SYSSYSTEMFET$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMI_OBJ# INDEX  0.000.000.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMSYS_C00641 INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSAUXSYS_LOB0000005938C00038$$ LOB0.000.00  0.000 100.000.00 0.00
SYSSYSTEMTAB$ TABLE  0.000.000.00 0  0.000.00
SYSSYSTEMUSER$ TABLE  0.000.000.00 0  0.000.00
SYSSYSAUXWRH$_BG_EVENT_SUMMARY TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSAUXWRH$_SQL_BIND_METADATA TABLE0.000.000.000.000.00000.000.000.000.00

  


   Back to Segment Statistics
Back to Top

  

Top Segments Comparison by Direct Physical Reads

     % of Total Direct Reads Direct Reads % of Captured Direct Reads
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
TPCETPCE_TRADE_DATAE_TRADE TABLE99.6699.66  -99.6631,382,208  99.66 -99.66
TPCHTPCH_REF_DATAH_LINEITEM TABLE  52.8452.8452.84 14,694,075  85.0885.08
TPCHTPCH_REF_DATAH_ORDER TABLE  8.8261.668.82 2,452,485  14.2014.20
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  0.4562.110.45 124,935  0.720.72
TPCETPCE_DAILY_MARKET_DATAE_DAILY_MARKET TABLE0.2599.90  -0.2577,568  0.25 -0.25
TPCETPCE_CUSTOMER_DATAE_CUSTOMER TABLE0.0499.94  -0.0411,520  0.04 -0.04
TPCETPCE_COMPANY_DATAE_COMPANY TABLE0.0399.97  -0.039,420  0.03 -0.03
TPCETPCE_WATCH_LIST_DATAE_WATCH_LIST TABLE0.0299.99  -0.025,136  0.02 -0.02
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION0.0099.990.0062.11-0.00220130-40.910.000.000.00
SYSSYSTEMTAB$ TABLE  0.0062.110.00 0  0.000.00

  


   Back to Segment Statistics
Back to Top

  

Top Segments Comparison by Physical Writes

     % of Total Physical Writes Physical Writes % of Captured Physical Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
TPCETPCE_TRADE_DATAE_TRADE TABLE20.7120.71  -20.71995  29.30 -29.30
TPCETPCE_HOLDING_HISTORY_DATAE_HOLDING_HISTORY TABLE16.0736.77  -16.07772  22.73 -22.73
TPCETPCE_SETTLEMENT_DATAE_SETTLEMENT TABLE7.0843.85  -7.08340  10.01 -10.01
TPCETPCE_CASH_TRANSACTION_DATAE_CASH_TRANSACTION TABLE6.4350.28  -6.43309  9.10 -9.10
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION4.9355.210.020.02-4.91237141-40.516.9834.3127.33
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.8556.070.010.03-0.84415943.901.2114.3613.15
SYSSYSAUXWRH$_EVENT_HISTOGRAMWRH$_EVENT__1200893776_2190TABLE PARTITION0.0856.150.000.04-0.08416300.000.123.893.78
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX  0.000.040.00 22  5.355.35
SYSSYSAUXSMON_SCN_TIME TABLE  0.000.040.00 18  4.384.38

  


   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
TPCETPCE_TRADE_DATAE_TRADE TABLE39.1639.16  -39.16994  56.51 -56.51
TPCETPCE_SETTLEMENT_DATAE_SETTLEMENT TABLE10.4449.61  -10.44265  15.07 -15.07
TPCETPCE_CASH_TRANSACTION_DATAE_CASH_TRANSACTION TABLE5.6355.24  -5.63143  8.13 -8.13
TPCETPCE_HOLDING_HISTORY_DATAE_HOLDING_HISTORY TABLE3.4358.67  -3.4387  4.95 -4.95
TPCETPCE_CUSTOMER_ACCOUNT_DATAE_CUSTOMER_ACCOUNT TABLE1.3059.97  -1.3033  1.88 -1.88
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION1.1861.150.020.02-1.163017-43.331.7110.909.19
SYSSYSAUXWRH$_SYSMETRIC_HISTORY TABLE0.2861.430.010.03-0.2671042.860.406.416.01
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.2461.660.020.05-0.22614133.330.348.978.63
SYSSYSAUXSMON_SCN_TIME TABLE  0.020.070.02 18  11.5411.54
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX  0.020.090.02 16  10.2610.26

  


   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
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1200893776_2190TABLE PARTITION99.1099.100.020.02-99.08220130-40.9199.10100.000.90
SYSSYSAUXSYS_LOB0000005938C00038$$ LOB0.90100.00  -0.902  0.90 -0.90
SYSSYSTEMFET$ TABLE  0.000.020.00 0  0.000.00
SYSSYSTEMI_OBJ# INDEX  0.000.020.00 0  0.000.00
SYSSYSTEMI_SYSAUTH1 INDEX0.00100.000.000.020.00000.000.000.000.00
SYSSYSTEMSYS_C00641 INDEX0.00100.00  0.000 100.000.00 0.00
SYSSYSTEMTAB$ TABLE  0.000.020.00 0  0.000.00
SYSSYSTEMUSER$ TABLE  0.000.020.00 0  0.000.00
SYSSYSAUXWRH$_SQL_BIND_METADATA TABLE0.00100.000.000.020.00000.000.000.000.00

  


   Back to Segment Statistics
Back to Top

  

Top Segments Comparison by Table Scans

     % of Total Table Scans Table Scans % of Captured Table Scans
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
TPCHTPCH_REF_DATAH_LINEITEM TABLE  51.5351.5351.53 135  51.7251.72
TPCHTPCH_REF_DATAH_ORDER TABLE  40.0891.6040.08 105  40.2340.23
TPCETPCE_TRADE_DATAE_TRADE TABLE15.6015.60  -15.60951  16.74 -16.74
TPCETPCE_SECURITY_DATAE_SECURITY TABLE12.9128.50  -12.91787  13.85 -13.85
TPCETPCE_REF_DATAE_TRADE_TYPE TABLE11.2339.73  -11.23685  12.06 -12.06
TPCETPCE_TRADE_REQUEST_DATAE_TRADE_REQUEST TABLE10.6650.39  -10.66650  11.44 -11.44
TPCETPCE_REF_DATAE_STATUS_TYPE TABLE10.4160.81  -10.41635  11.18 -11.18
TPCHTPCH_REF_DATAH_PARTSUPP TABLE  5.7397.335.73 15  5.755.75
SYSSYSTEMI_OBJ2 INDEX  2.2999.622.29 6  2.302.30
SYSSYSTEMTAB$ TABLE  0.0099.620.00 0  0.000.00

  


   Back to Segment Statistics
Back to Top

  

Top Segments Comparison by DB Block Changes

     % of Total Block Changes DB Block Changes % of Captured Block Changes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
SYSMANSYSAUXMGMT_CURRENT_METRICS_PK INDEX  5.945.945.94 432  26.7326.73
TPCETPCE_HOLDING_HISTORY_DATAE_HOLDING_HISTORY TABLE4.264.26  -4.261,456  11.48 -11.48
TPCETPCE_TRADE_HISTORY_IDXE_TRADE_HISTORY_PK_IDX INDEX4.028.28  -4.021,376  10.84 -10.84
SYSMANSYSAUXMGMT_SYSTEM_PERF_LOG_IDX_01 INDEX  3.309.253.30 240  14.8514.85
TPCETPCE_HOLDING_SUMMARY_DATAE_HOLDING_SUMMARY TABLE2.9011.19  -2.90992  7.82 -7.82
TPCETPCE_HOLDING_SUMMARY_IDXE_HOLDING_SUMMARY_PK_IDX INDEX2.7613.95  -2.76944  7.44 -7.44
TPCETPCE_HOLDING_HISTORY_IDXE_HOLDING_HISTORY_PK_IDX INDEX2.4316.38  -2.43832  6.56 -6.56
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY_PKWRH$_ACTIVE_1200893776_2190INDEX PARTITION0.9817.363.0812.332.10336224-33.332.6513.8611.21
SYSSYSAUXWRI$_ADV_PARAMETERS TABLE  1.1013.431.10 80  4.954.95
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PKWRH$_EVENT__1200893776_2190INDEX PARTITION0.0917.461.1014.531.013280150.000.254.954.70

  


   Back to Segment Statistics
Back to Top

  

Top Segments by Row Lock Waits

     % of Total Row Lock Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd%Diff1st1st Total2nd2nd TotalDiff
TPCETPCE_BROKER_DATAE_BROKER TABLE96.30 -96.3026  52.0052.00  -52.00
TPCETPCE_TRADE_HISTORY_IDXE_TRADE_HISTORY_PK_IDX INDEX77.78 -77.7821  42.0094.00  -42.00
TPCETPCE_HOLDING_SUMMARY_IDXE_HOLDING_SUMMARY_PK_IDX INDEX7.41 -7.412  4.0098.00  -4.00
TPCETPCE_TRADE_DATAE_TRADE TABLE3.70 -3.701  2.00100.00  -2.00

  


   Back to Segment Statistics
Back to Top

  

Top Segments by ITL Waits

   No data exists for this section of the report.

   Back to Segment Statistics
Back to Top

  

Top Segments by Buffer Busy Waits

     % of Total Buffer Busy Waits Buffer Busy Waits % of Captured Buffer Busy Waits
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
TPCETPCE_HOLDING_HISTORY_DATAE_HOLDING_HISTORY TABLE106.25106.25  -106.2568  61.26 -61.26
TPCETPCE_TRADE_HISTORY_IDXE_TRADE_HISTORY_PK_IDX INDEX57.81164.06  -57.8137  33.33 -33.33
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **UNDEFINED3.13167.19  -3.132  1.80 -1.80
TPCETPCE_BROKER_DATAE_BROKER TABLE3.13170.31  -3.132  1.80 -1.80
TPCETPCE_TRADE_HISTORY_DATAE_TRADE_HISTORY TABLE1.56171.88  -1.561  0.90 -0.90

  


   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.030.02-33.3338490.000.00000.000.002211
dc_files0.000.000.000.000.03100.000800.000.00000.000.00008080
dc_global_oids0.030.01-66.671.350.13-90.371,8283060.710.00000.000.000089111
dc_histogram_data0.030.00-100.001.190.00-100.001,60077.440.00000.000.00001,5631,857
dc_histogram_defs0.350.01-97.1414.540.13-99.1119,6242906.640.00000.000.00003,3804,762
dc_object_grants0.000.000.000.100.00-100.0013805.070.00000.000.0000107110
dc_objects0.500.02-96.0020.690.31-98.5027,9257010.910.00000.000.00442,7203,153
dc_profiles0.000.000.000.060.03-50.0075590.000.00000.000.000022
dc_rollback_segments0.010.03200.000.430.42-2.335849660.000.00000.000.00003939
dc_segments0.420.01-97.6217.380.14-99.1923,4493320.550.00000.000.004971,0111,178
dc_sequences0.000.000.000.000.000.0010100.000.00000.000.001057
dc_tablespaces0.140.09-35.715.881.26-78.577,9402,8940.000.00000.000.00008384
dc_users0.300.22-26.6712.253.03-75.2716,5306,9480.010.00000.000.0000111118
global database name0.020.05150.000.760.71-6.581,0211,6380.000.00000.000.000011
outstanding_alerts0.000.01100.000.120.10-16.671612380.620.00000.000.00218079
sch_lj_oids0.000.000.000.000.000.00330.000.00000.000.000066

  


  
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
APP CONTEXT0.000.000.000.010.00-100.007014.29 7014.29 0000
BODY0.010.02100.000.360.32-11.114887441.230.001,0851,4134.330.0041000
CLUSTER0.000.000.000.030.00-100.003902.56 2603.85 0000
DBLINK0.000.000.000.080.01-87.50105331.900.0000  0000
EDITION0.000.000.000.070.03-57.1488670.000.001621250.000.000000
INDEX0.000.000.000.020.00-100.0025056.00 25056.00 0000
QUEUE0.000.000.000.020.020.0024420.000.00761400.000.000000
RULESET0.000.000.000.000.000.00210.000.00210.000.000000
SCHEMA0.010.00-100.000.260.03-88.46352730.000.0000  0000
SQL AREA0.450.04-91.1118.690.51-97.2725,2161,16865.884.37152,70810,78611.950.733020280
SUBSCRIPTION0.000.000.000.000.000.00580.000.00580.000.000000
TABLE/PROCEDURE0.360.03-91.6714.910.39-97.3820,1269000.390.0029,7362,1882.790.00545000
TRIGGER0.000.000.000.010.00-100.001288.330.00253916.000.003000

  


  
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)23,424.0052,992.00126.238,384.008,640.003.05-64.21-83.70
 Used (KB)0.000.000.000.000.000.000.000.00
 Avg Alloc (KB)2,928.00736.00-74.86931.56960.003.05-68.1830.43
 Std Dev Alloc (KB)6,422.98402.48-93.731,155.161,155.550.03-82.02187.10
 Max Alloc (KB)18,752.003,776.00-93.523,776.003,776.000.00-79.86210.53
 Hist Max Alloc (KB)        
 Num Procs8.0072.00800.009.009.000.0012.50-87.50
 Num Alloc8.0072.00800.009.009.000.0012.50-87.50
OtherAlloc (KB)182,578.98381,281.95108.83181,434.63183,366.631.06-0.63-51.91
 Used (KB)        
 Avg Alloc (KB)5,216.543,050.26-41.535,183.855,239.051.06-0.6371.76
 Std Dev Alloc (KB)8,454.444,755.29-43.758,468.908,452.08-0.200.1777.74
 Max Alloc (KB)30,454.1030,454.100.0030,454.1030,454.100.000.000.00
 Hist Max Alloc (KB)31,542.1031,542.100.0031,542.1031,542.100.000.000.00
 Num Procs35.00125.00257.1435.0035.000.000.00-72.00
 Num Alloc35.00125.00257.1435.0035.000.000.00-72.00
PL/SQLAlloc (KB)513.285,146.34902.63498.82498.820.00-2.82-90.31
 Used (KB)408.524,438.30986.43424.55424.570.013.92-90.43
 Avg Alloc (KB)15.5541.84169.0015.1215.120.00-2.82-63.87
 Std Dev Alloc (KB)43.5148.2710.9542.9542.950.00-1.27-11.02
 Max Alloc (KB)233.34233.340.00233.34233.340.000.000.00
 Hist Max Alloc (KB)857.01235.38-72.541,824.601,122.10-38.50112.90376.73
 Num Procs33.00123.00272.7333.0033.000.000.00-73.17
 Num Alloc33.0095.00187.8833.0033.000.000.00-65.26
SQLAlloc (KB)947.627,012.80640.05762.43750.42-1.57-19.54-89.30
 Used (KB)755.753,192.62322.44673.54657.77-2.34-10.88-79.40
 Avg Alloc (KB)72.8975.413.4558.6557.72-1.57-19.54-23.45
 Std Dev Alloc (KB)201.1589.86-55.32172.03168.72-1.92-14.4887.75
 Max Alloc (KB)736.20614.95-0.52626.96614.95-1.92-14.84-16.03
 Hist Max Alloc (KB)2,172.596,209.00185.792,172.592,172.590.000.00-65.01
 Num Procs13.0093.00615.3813.0013.000.000.00-86.02
 Num Alloc8.0060.00650.007.007.000.00-12.50-88.33

  


   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 Buffers430,080.00434,176.000.95405,504.00405,504.000.00-5.71-6.60
Fixed Size2,165.732,165.730.002,165.732,165.730.000.000.00
Redo Buffers6,564.006,564.000.006,564.006,564.000.000.000.00
Variable Size352,258.27348,162.27-1.16376,834.27376,834.270.006.988.24

  


   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 pool6,881,2806,881,2800.006,881,2806,881,2800.000.000.00
large poolfree memory1,114,1121,114,1120.001,114,1121,114,1120.000.000.00
shared poolASH buffers4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
shared poolCCUR23,652,71226,161,27210.6123,889,48824,076,1520.781.00-7.97
shared poolFileOpenBlock3,978,6483,978,6480.003,978,6483,978,6480.000.000.00
shared poolKCB Table Scan Buffer3,981,1203,981,1200.003,981,1203,981,1200.000.000.00
shared poolKGLH010,429,3605,835,880-44.049,056,4169,024,032-0.36-13.1654.63
shared poolKGLHD9,500,84010,895,07214.6711,862,77611,891,0480.2424.869.14
shared poolKGLS15,751,4723,903,048-75.2212,473,03212,241,624-1.86-20.81213.64
shared poolKGLSG5,264,9045,264,9040.005,264,9045,264,9040.000.000.00
shared poolKKSSP 3,149,648      
shared poolKQR L PO3,773,496       
shared poolKQR M PO3,296,824       
shared poolKSFD SGA I/O b3,977,0643,977,0640.003,977,0643,977,0640.000.000.00
shared poolPCUR11,975,83227,852,280132.5721,596,01621,681,1200.3980.33-22.16
shared poolPLDIA5,420,784  4,073,8884,004,688-1.70-24.85 
shared poolPLMCD12,391,3926,414,032-48.2412,932,80012,928,752-0.034.37101.57
shared poolSQLA84,548,28856,747,872-32.8887,844,64888,202,3680.413.9055.43
shared poolSQLP3,486,216       
shared pooldbwriter coalesce buffer3,979,2643,979,2640.003,979,2643,979,2640.000.000.00
shared poolevent statistics per sess 3,182,336      
shared poolflashback generation buff3,981,1203,981,1200.003,981,1203,981,1200.000.000.00
shared poolfree memory32,848,04860,323,57683.6445,807,33645,494,632-0.6839.45-24.58
shared poolkglsim hash table bkts4,194,3044,194,3040.004,194,3044,194,3040.000.000.00
shared poolprivate strands3,677,1843,677,1840.003,677,1843,677,1840.000.000.00
shared poolrow cache7,584,8087,584,8080.007,584,8087,584,8080.000.000.00
streams poolKTG hash buckets1,320,4321,320,4320.001,320,4321,320,4320.000.000.00
streams poolfree memory2,862,1762,862,1760.002,862,6322,862,6320.000.020.02
 buffer_cache440,401,920444,596,2240.95415,236,096415,236,0960.00-5.71-6.60
 fixed_sga2,217,7122,217,7120.002,217,7122,217,7120.000.000.00
 log_buffer6,721,5366,721,5360.006,721,5366,721,5360.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.020.01-75.000.000.000.000.000.000.00
QMON Slaves0.050.02-50.940.670.00-100.000.000.000.00

  


   Back to Streams Statistics
Back to Top

  

Streams by IO Time

 IO Time (sec) CPU Time (sec)
Session Type1st User1st System1st Total2nd User2nd System2nd TotalTotal %Diff1st2nd%Diff
QMON Slaves0.670.000.670.000.000.00-100.000.050.02-50.94
QMON Coordinator0.000.000.000.000.000.000.000.020.01-75.00

  


   Back to Streams Statistics
Back to Top

  

Streams Capture

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Streams Capture Rate

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Streams Apply

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Streams Apply Rate

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Buffered Queues

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Buffered Subscribers

   No data exists for this section of the report.

   Back to Streams Statistics
Back to Top

  

Rule Set by Evaluations

 Evals No-SQL Eval% SQL Execs CPU(s) Ela(s) Eval/Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads
Ruleset Name1st2nd%Diff1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE_R21-50.000.000.00000.0000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.00000.00

  


   Back to Streams Statistics
Back to Top

  

Rule Set by Elapsed Time

 Ela(s) No-SQL Eval% SQL Execs CPU(s) Evals Eval/Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads
Ruleset Name1st2nd%Diff1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE_R00.000.000.000.00000.0000.000.0021-50.000.000.000.000.000.000.000.000.000.000.000.000.00000.00

  


   Back to Streams Statistics
Back to Top

  

Persistent Queues

 Enq Msgs Deq Msgs %Delay Msgs %Exp Msgs Enq Time(s) Deq Time(s) %Transf Time %Eval Time
Queue Name1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd%Diff1st2nd%Diff1st2nd1st2nd
SYSMAN.MGMT_TASK_Q(82156) 213985.71213985.710.000.000.000.000.600.08-86.672.651.09-58.870.000.000.000.00
SYS.ALERT_QUE(11324) 21-50.00000.00100.00100.000.000.000.020.00-100.000.000.000.000.000.004.6522.08
SYS.AQ$_ALERT_QT_E(11323) 000.00000.00    0.000.000.000.000.000.00    
SYSMAN.MGMT_NOTIFY_Q(82486) 000.00000.00    0.000.000.000.000.000.00    

  


   Back to Streams Statistics
Back to Top

  

Persistent Queues Rate

 Enqueue Msgs/sec Dequeue Msgs/sec Avg Enqueue sec / msg Avg Dequeue sec / msg
Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
SYS.ALERT_QUE(11324) 0.000.000.000.000.000.000.010.00-100.00  0.00
SYS.AQ$_ALERT_QT_E(11323) 0.000.000.000.000.000.00  0.00  0.00
SYSMAN.MGMT_NOTIFY_Q(82486) 0.000.000.000.000.000.00  0.00  0.00
SYSMAN.MGMT_TASK_Q(82156) 0.020.020.000.020.020.000.030.00-100.000.130.03-76.92

  


   Back to Streams Statistics
Back to Top

  

Persistent Queue Subscribers

 Enqueue Msgs Dequeue Msgs Expire Msgs Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec
Subscriber/Queue Name1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff1st2nd%Diff
B1GR2BASE_3938_ORCL(62)/SYS.ALERT_QUE 21-50.00000.00000.000.000.000.000.000.000.000.000.000.00
TRAINING_1830_ORCL(41)/SYS.ALERT_QUE 21-50.00000.00000.000.000.000.000.000.000.000.000.000.00
TRAINING_3872_ORCL(61)/SYS.ALERT_QUE 21-50.00000.00000.000.000.000.000.000.000.000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000.00000.00000.00  0.00  0.00  0.00

  


   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.001100.000000.001100.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

Total Server Time (s) %Busy %Idle Incoming Net % Outgoing Net %
1st2nd%Diff1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
1,3582,29569.000.000.000.00100.00100.000.000.000.000.000.000.000.00

  


   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.000.000.000.000.00-0.00100.00100.000.00000.00000.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

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
__db_cache_size440401920444596224 415236096
__java_pool_size 4194304  
__large_pool_size 8388608  
__oracle_base /u01/app/oracle  
__pga_aggregate_target 159383552  
__sga_target 788529152  
__shared_io_pool_size 0  
__shared_pool_size318767104314572800 343932928
__streams_pool_size 4194304  
_enable_automatic_maintenance 0  
audit_file_dest /u01/app/oracle/admin/orcl/adump  
audit_trail DB  
compatible 11.2.0.0.0  
control_files +DATA/orcl/controlfile/current.2  
db_block_size 8192  
db_cache_size 394264576  
db_create_file_dest +DATA  
db_create_online_log_dest_1 +DATA  
db_domain    
db_name orcl  
db_recovery_file_dest +FRA  
db_recovery_file_dest_size 17179869184  
diagnostic_dest /u01/app/oracle  
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)  
java_pool_size 4194304  
job_queue_processes 1000  
large_pool_size 4194304  
open_cursors 300  
pga_aggregate_target 157286400  
processes 150  
remote_login_passwordfile EXCLUSIVE  
resource_manager_plan    
service_names orcl, OLTP, DSS, ADHOC, BATCH_ST  
sga_max_size 813694976  
sga_target 788529152  
shared_pool_size 134217728  
streams_pool_size 4194304  
timed_statistics TRUE  
undo_tablespace UNDOTBS1  

  


  
Back to Top

  

  

  

Complete List of SQL Text

  
SQL IdSQL Text
07yqdn45g0uwpSELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 114 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus
089dbukv1aanhSELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
08vznc16ycuagSELECT SYS_GUID() FROM SYS.DUAL
09zd7hgsfrdg6SELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 109 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0m78skf1mudnbselect audit$, properties from type_misc$ where obj#=:1
0n3h2c1ufzma4SELECT COLLECTION_TIMESTAMP, ROWID FROM MGMT_LAST_VIOLATION WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
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)
111xpqwr0sfjgBegin Update E_Trade Set T_COMM = :comm_amount, T_DTS = To_Date(:trade_dts, 'mm/dd/YYYY'), T_ST_ID = :comp_id, T_TRADE_PRICE = :trade_price Where T_ID = :trade_id; Insert Into E_TRADE_HISTORY(TH_T_ID, TH_DTS, TH_ST_ID) Values( :trade_id, to_date(:trade_dts, 'mm/dd/YYYY'), :comp_id); Update E_BROKER Set B_COMM_TOTAL = B_COMM_TOTAL + :comm_amount, B_NUM_TRADES = B_NUM_TRADES + 1 Where B_ID = :broker_id;End;
12qmb2vstfhgySELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-07-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-07-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
15p4z9yvdc8uaSELECT T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_TT_ID = TT_ID AND ROWNUM <= :B1
1809cng2r987sSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1995-01-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1ba09vhjx4rxjSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-10', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-10', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
1fwcc9b0mbzumSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-20', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-20', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
1gkn6r4rbdkmySELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1997-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1997-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1x255a7m968k7SELECT supp_nation, cust_nation, L_YEAR, SUM(VOLUME) AS REVENUE FROM (SELECT N1.n_name supp_nation, N2.n_name cust_nation, to_number(to_char(l_shipdate, 'YYYY')) AS L_YEAR, l_extendedprice * (1 - l_discount) VOLUME FROM H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2 WHERE s_suppkey = l_suppkey AND o_orderkey = l_orderkey AND c_custkey = o_custkey AND s_nationkey = N1.n_nationkey AND c_nationkey = N2.n_nationkey AND ((N1.n_name = 'ALGERIA' AND N2.n_name = 'CANADA') OR (N1.n_name = 'CANADA' AND N2.n_name = 'ALGERIA')) AND l_shipdate BETWEEN to_date( '1995-01-01', 'YYYY-MM-DD') AND to_date( '1996-12-31', 'YYYY-MM-DD') ) SHIPPING GROUP BY supp_nation, cust_nation, L_YEAR ORDER BY supp_nation, cust_nation, L_YEAR
21mdxpk0d7jt7UPDATE E_BROKER SET B_COMM_TOTAL = B_COMM_TOTAL + :B1 , B_NUM_TRADES = B_NUM_TRADES + 1 WHERE B_ID = :B2
25fu98m3hw2tsSELECT VALUE FROM MGMT_CURRENT_METRICS A, MGMT_METRICS B, MGMT_TARGETS C WHERE B.TARGET_TYPE = :B3 AND A.METRIC_GUID = B.METRIC_GUID AND B.METRIC_COLUMN = :B2 AND B.METRIC_NAME = :B1 AND C.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = C.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = C.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = C.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = C.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = C.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ')
2mw82wp65dyv5SELECT S_NAME, CO_ID, CO_NAME, CO_SP_RATE, CO_CEO, CO_DESC, CO_OPEN_DATE, CO_ST_ID, NVL(CA.AD_LINE1, CHR(0)), NVL(CA.AD_LINE2, CHR(0)), ZCA.ZC_TOWN, ZCA.ZC_DIV, CA.AD_ZC_CODE, NVL(CA.AD_CTRY, CHR(0)), S_NUM_OUT, S_START_DATE, S_EXCH_DATE, S_PE, S_52WK_HIGH, S_52WK_HIGH_DATE, S_52WK_LOW, S_52WK_LOW_DATE, S_DIVIDEND, S_YIELD, NVL(EA.AD_LINE1, CHR(0)), NVL(EA.AD_LINE2, CHR(0)), ZEA.ZC_TOWN, ZEA.ZC_DIV, NVL(EA.AD_CTRY, CHR(0)), EA.AD_ZC_CODE, NVL(EX_DESC, CHR(0)), EX_NAME, EX_NUM_SYMB, EX_OPEN, EX_CLOSE FROM E_SECURITY, E_COMPANY, E_ADDRESS CA, E_ADDRESS EA, E_ZIP_CODE ZCA, E_ZIP_CODE ZEA, E_EXCHANGE WHERE S_SYMB = :B1 AND CO_ID = S_CO_ID AND CA.AD_ID = CO_AD_ID AND EA.AD_ID = EX_AD_ID AND EX_ID = S_EX_ID AND CA.AD_ZC_CODE = ZCA.ZC_CODE AND EA.AD_ZC_CODE = ZEA.ZC_CODE
2uzp6kw11g1suSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1996-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1996-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
2vcn91b1wtmc6SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= (3 * :B1 ) ORDER BY TH_DTS
309b84z4mv9jbSELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= :B1
318ng5h3q5x79Select T_BID_PRICE, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), T_ID, NVL(T_TRADE_PRICE, 0) From E_TRADE Where T_CA_ID = :acct_id And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And Rownum <= :max_trades order by T_DTS asc
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
37h9f39wxj92rSELECT NI_HEADLINE, NI_SUMMARY, NI_DTS, NI_SOURCE, NVL(NI_AUTHOR, CHR(0)) FROM E_NEWS_XREF, E_NEWS_ITEM WHERE NI_ID = NX_NI_ID AND NX_CO_ID = :B1 AND ROWNUM <= 2
3904n1ntv7txjSelect T_BID_PRICE, T_EXEC_NAME, Case When T_IS_CASH = 'Y' Then 1 Else 0 End, TT_IS_MRKT, NVL(T_TRADE_PRICE, 0) From E_TRADE, E_TRADE_TYPE Where T_ID = :trade_id And T_TT_ID = TT_ID
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
39pvzrsczv31xSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1993-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1993-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
45cngnmv709m4select subscriber_id, name, address, protocol, subscriber_type, rule_name, trans_name, ruleset_name, negative_ruleset_name, creation_time, deletion_time, modification_time, scn_at_remove , scn_at_add from AQ$_SUBSCRIBER_TABLE where queue_name=:1 and schema=:2 and bitand(subscriber_type, 2) = 2
48ay2b94rz41xSELECT DM_DATE, DM_CLOSE, DM_HIGH, DM_LOW, DM_VOL FROM E_DAILY_MARKET WHERE DM_S_SYMB = :B3 AND DM_DATE >= TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY DM_DATE ASC
4j9awnaff2xjrSELECT LT_PRICE FROM E_LAST_TRADE WHERE LT_S_SYMB = :symbol
4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4ttpsft97zujkSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-24', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-24', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
58h9dvw8qzy7wSELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B4 AND T_DTS BETWEEN TO_DATE(:B3 , 'mm/dd/YYYY') AND TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY T_DTS
59ahdunmw6xbzSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-22', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-22', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
5jctjh9wmayy6SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B2 AND T_DTS >= TO_DATE(:B1 , 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5pnb5ryzbx5xxSELECT TH_DTS, T_QTY, T_S_SYMB, T_ID, ST_NAME From (Select T_ID As ID From E_TRADE Where T_CA_ID = :acct_id And Rownum <= 10 Order By T_DTS DESC), E_TRADE, E_TRADE_HISTORY, E_STATUS_TYPE Where T_ID = ID And TH_T_ID = T_ID And ST_ID = TH_ST_ID Order by TH_DTS Desc
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6dafh4gs0k2jcDeclare ex_name Varchar2(65); Begin If :num_update < :max_updates Then Select Trim(T_EXEC_NAME) Into ex_name From E_TRADE Where T_ID = :trade_id; :num_found := :num_found + SQL%ROWCOUNT; If ex_name Like '% X %' Then ex_name := Replace(ex_name, ' X ', ' '); Else ex_name := Replace(ex_name, ' ', ' X '); End If; Update E_TRADE Set T_EXEC_NAME = ex_name Where T_ID = :trade_id; :num_update := :num_update + SQL%ROWCOUNT; End If;End;
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6h7xku2zvpgshSelect T_CA_ID, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), NVL(T_TRADE_PRICE, 0) TRADE_PRICE, T_QTY, Trim(S_NAME), T_DTS, T_ID, T_TT_ID, TT_NAME From E_TRADE, E_TRADE_TYPE, E_SECURITY Where T_S_SYMB = :symbol And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And TT_ID = T_TT_ID And S_SYMB = T_S_SYMB And Rownum <= :max_trades Order By T_DTS Asc
6qz82dptj0qr7select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6uusdb8z8usyuSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-15', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-15', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
6w6tz0ppcxb7uSELECT WI_S_SYMB FROM E_WATCH_ITEM, E_WATCH_LIST WHERE WI_WL_ID = WL_ID AND WL_C_ID = :B1
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 B Y source ASC, time_secs DESC, log_id ASC
6xvp6nxs4a9n4select nvl(sum(space), 0) from recyclebin$ where ts# = :1
72vydb3ncbn3s DECLARE trades E_TradeList; BEGIN SELECT T_ID BULK COLLECT INTO trades FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS BETWEEN TO_DATE(:start_trade_dts, 'mm/dd/YYYY') AND TO_DATE(:end_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= :maxtrades ORDER BY T_DTS; OPEN :t_cursor for SELECT T_ID, T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) and T_TT_ID = TT_ID AND ROWNUM <= :maxtrades; OPEN :se_cursor for SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= :maxtrades; OPEN :ct_cursor for SELECT T_ID, T_IS_CASH, CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :maxtrades; OPEN :th_cursor for SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= (3 * :maxtrades) ORDER BY TH_DTS; END;
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7rq305gd2gpzwSELECT S_NUM_OUT FROM E_SECURITY WHERE S_SYMB = :symbol
7vnf1z0t36s99SELECT C_ID FROM E_CUSTOMER WHERE C_TAX_ID = :B1
7yphsb8fr4vusSelect SE_AMT, to_char(SE_CASH_DUE_DATE, 'mm/dd/YYYY'), SE_CASH_TYPE From E_SETTLEMENT Where SE_T_ID = :trade_id
83vnfyd1m59nqDECLARE tradeid INT; BEGIN SELECT T_ID INTO tradeid FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS >= to_date(:start_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC; OPEN :hh_cursor for SELECT HH_H_T_ID, HH_T_ID, HH_BEFORE_QTY, HH_AFTER_QTY FROM E_HOLDING_HISTORY WHERE HH_H_T_ID = tradeid AND ROWNUM <= :maxtrades; END;
84nxzpqwn91j5Select to_char(TH_DTS, 'mm/dd/YYYY'), TH_ST_ID From E_TRADE_HISTORY Where TH_T_ID = :trade_id order by TH_DTS
8h5jmzqcfpgzbSELECT CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :B1
8v93w0n1dm76kSELECT DM_CLOSE FROM E_DAILY_MARKET WHERE DM_S_SYMB = :symbol AND DM_DATE = to_date(:dm_date, 'mm/dd/YYYY')
8vwv6hx92ymmmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
95rzx549dbvs5SELECT NATION, O_YEAR, SUM(AMOUNT) SUM_PROFIT FROM (SELECT n_name NATION, to_number(TO_CHAR (o_orderdate, 'YYYY')) AS O_YEAR , l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity AS AMOUNT FROM H_Part, H_Supplier, H_Lineitem, H_Partsupp, H_Order, H_Nation WHERE s_suppkey = l_suppkey AND ps_suppkey = l_suppkey AND ps_partkey = l_partkey AND p_partkey = l_partkey AND o_orderkey = l_orderkey AND s_nationkey = n_nationkey AND p_name LIKE '%almond%' ) PROFIT GROUP BY NATION, O_YEAR ORDER BY NATION, O_YEAR DESC
9ba2vwvw6z4z8SELECT C_L_NAME, C_F_NAME, B_NAME FROM E_CUSTOMER_ACCOUNT, E_CUSTOMER, E_BROKER WHERE CA_ID = :B1 AND C_ID = CA_C_ID AND B_ID = CA_B_ID
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9wfnvt8hnx49fSELECT CO_NAME, IN_NAME FROM E_COMPANY_COMPETITOR, E_COMPANY, E_INDUSTRY WHERE CP_CO_ID = :B1 AND CO_ID = CP_COMP_CO_ID AND IN_ID = CP_IN_ID
9xcdxpqrhsvmxSELECT l_returnflag, l_linestatus, sum(l_quantity) AS SUM_QTY, SUM(l_extendedprice) AS SUM_BASE_PRICE, SUM(l_extendedprice * (1 - l_discount)) AS SUM_DISC_PRICE, SUM(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS SUM_CHARGE, AVG(l_quantity) AS AVG_QTY, AVG(l_extendedprice) AS AVG_PRICE, AVG(l_discount) AS AVG_DISC, COUNT(*) AS COUNT_ORDER FROM H_Lineitem WHERE l_shipdate <= to_date ('1998-12-01', 'YYYY-MM-DD') - 119 GROUP BY l_returnflag, l_linestatus ORDER BY l_returnflag, l_linestatus
ab3swhv5g138y 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.ob j# 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.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.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
afy3mzh484trwSELECT l_orderkey, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, o_orderdate, o_shippriority FROM H_Customer, H_Order, H_Lineitem WHERE c_mktsegment = 'AUTOMOBILE' AND c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate < to_date('1995-03-06', 'YYYY-MM-DD') AND l_shipdate > to_date('1995-03-06', 'YYYY-MM-DD') GROUP BY l_orderkey, o_orderdate, o_shippriority ORDER BY REVENUE DESC, o_orderdate
agz7fu32m6qn4SELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1994-10-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1994-10-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
bfk319z4wc782SELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1995-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1995-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
bn4b3vjw2mj3u SELECT 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.s chedule_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
bqjghjzaphzb2SELECT T_CHRG, T_EXEC_NAME, EX_NAME, S_NAME, ST_NAME, T_S_SYMB, T_DTS, T_ID, T_QTY, TT_NAME FROM E_TRADE, E_STATUS_TYPE, E_TRADE_TYPE, E_SECURITY, E_EXCHANGE WHERE T_CA_ID = :B1 AND ST_ID = T_ST_ID AND TT_ID = T_TT_ID AND S_SYMB = T_S_SYMB AND EX_ID = S_EX_ID AND ROWNUM <= 50 ORDER BY T_DTS DESC
c0chxpnujy8tdSELECT n_name, SUM(l_extendedprice * ( 1 - l_discount)) AS REVENUE FROM H_Customer, H_Order, H_Lineitem, H_Supplier, H_Nation, H_Region WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND l_suppkey = s_suppkey AND c_nationkey = s_nationkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'AFRICA' AND o_orderdate >= to_date( '1994-01-01', 'YYYY-MM-DD') AND o_orderdate < add_months(to_date( '1994-01-01', 'YYYY-MM-DD'), 12) GROUP BY n_name ORDER BY REVENUE DESC
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
c71khx643vgxbSELECT c_custkey, c_name, SUM(l_extendedprice * (1 - l_discount)) AS REVENUE, c_acctbal, n_name, c_address, c_phone, c_comment FROM H_Customer, H_Order, H_Lineitem, H_Nation WHERE c_custkey = o_custkey AND l_orderkey = o_orderkey AND o_orderdate >= to_date ('1993-09-01', 'YYYY-MM-DD') AND o_orderdate < add_months( to_date( '1993-09-01', 'YYYY-MM-DD'), 3) AND l_returnflag = 'R' AND c_nationkey = n_nationkey GROUP BY c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment ORDER BY REVENUE DESC
c8h3jdwaa532qSELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
csnp95dz2r8ssselect file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d8mayxqw0wnpvSELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
dbf6bmt9at48fSELECT FI_YEAR, FI_QTR, FI_QTR_START_DATE, FI_REVENUE, FI_NET_EARN, FI_BASIC_EPS, FI_DILUT_EPS, FI_MARGIN, FI_INVENTORY, FI_ASSETS, FI_LIABILITY, FI_OUT_BASIC, FI_OUT_DILUT FROM E_FINANCIAL WHERE FI_CO_ID = :B1 AND ROWNUM <= 20 ORDER BY FI_YEAR ASC, FI_QTR
fdjtrdaz8hpvg INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
fjpgrrp53dtxj SELECT B_NAME, NVL(SUM(TR_QTY * TR_BID_PRICE), 0) FROM E_BROKER, E_TRADE_REQUEST, E_SECURITY, E_COMPANY, E_INDUSTRY, E_SECTOR WHERE B_NAME IN (:broker1, :broker2, :broker3, :broker4, :broker5, :broker6, :broker7, :broker8, :broker9, :broker10, :broker11, :broker12, :broker13, :broker14, :broker15, :broker16, :broker17, :broker18, :broker19, :broker20, :broker21, :broker22, :broker23, :broker24, :broker25, :broker26, :broker27, :broker28, :broker29, :broker30, :broker31, :broker32, :broker33, :broker34, :broker35, :broker36, :broker37, :broker38, :broker39, :broker40) AND B_ID = TR_B_ID AND TR_S_SYMB = S_SYMB AND S_CO_ID = CO_ID AND CO_IN_ID = IN_ID AND IN_SC_ID = SC_ID AND SC_NAME = :sector_name GROUP BY B_NAME ORDER BY 2 DESC
fps40s3v7nd3rSELECT O_YEAR, SUM(DECODE(NATION, 'ALGERIA', VOLUME, 0)) / SUM(VOLUME) AS MKT_SHARE FROM (SELECT to_number(TO_CHAR(o_orderdate, 'YYYY')) AS O_YEAR, l_extendedprice * (1 - l_discount) VOLUME, N2.n_name NATION FROM H_Part, H_Supplier, H_Lineitem, H_Order, H_Customer, H_Nation N1, H_Nation N2, H_Region WHERE p_partkey = l_partkey AND s_suppkey = l_suppkey AND l_orderkey = o_orderkey AND o_custkey = c_custkey AND c_nationkey = N1.n_nationkey AND N1.n_regionkey = r_regionkey AND r_name = 'AFRICA' AND s_nationkey = N2.n_nationkey AND o_orderdate BETWEEN to_date ('1995-01-01', 'YYYY-MM-DD') AND to_date ('1996-12-31', 'YYYY-MM-DD') AND p_type = 'STANDARD ANODIZED TIN') ALL_NATIONS GROUP BY O_YEAR ORDER BY O_YEAR
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4gkdzc5fb01zSelect CT_AMT, to_char(CT_DTS, 'mm/dd/YYYY') , Nvl(CT_NAME, chr(0)) From E_CASH_TRANSACTION Where CT_T_ID = :trade_id
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gcph0kd36arc6 SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME, DECODE(D.TYPE, :B29 , D.PROFILE_NAME, :B28 , D.PROFILE_NAME, CFG.OWNER) CHECKUSER FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_RULE_CONFIGS C WHERE ((:B26 LIKE C.TARGET_TYPE ESCAPE :B21 AND :B25 LIKE C.TARGET_NAME ESCAPE :B21 ) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME = :B25 ))) AND :B24 LIKE C.METRIC_NAME ESCAPE :B21 AND :B23 LIKE C.METRIC_COLUMN ESCAPE :B21 AND ((:B22 LIKE C.KEY_VALUE ESCAPE :B21 ) OR (C.KEY_VALUE <> ' ' AND EXISTS (SELECT 1 FROM MGMT_METRICS_COMPOSITE_KEYS K WHERE K.COMPOSITE_KEY = :B22 AND NVL(K.KEY_PART1_VALUE, ' ') LIKE C.KEY_PART_1 ESCAPE :B21 AND NVL(K.KEY_PART2_VALUE, ' ') LIKE C.KEY_PART_2 ESCAPE :B21 AND NVL(K.KEY_PART3_VALUE, ' ') LIKE C.KEY_PART_3 ESCAPE :B21 AND NVL(K.KEY_PART4_VALUE, ' ') LIKE C.KEY_PART_4 ESCAPE :B21 AND NVL(K.KEY_PART5_VALUE, ' ') LIKE C.KEY_PART_5 ESCAPE :B21 AND K.TARGET_GUID = :B27 ))) AND ((:B4 = -1 AND ( (:B2 = :B20 AND WANT_TARGET_UNREACHABLE_START = 1) OR (:B2 = :B19 AND WANT_TARGET_UNREACHABLE_END = 1) OR (:B2 = :B18 AND WANT_TARGET_BLACKOUT_START = 1) OR (:B2 = :B17 AND WANT_TARGET_BLACKOUT_END = 1) OR (:B2 = :B16 AND ((WANT_TARGET_METRIC_ERR_START = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_START = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_START = 3))) OR (:B2 = :B15 AND ((WANT_TARGET_METRIC_ERR_END = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_END = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_END = 3))) OR (:B2 = :B1 AND WANT_CLEARS = 1 AND :B14 <> 1) OR (:B2 = :B1 AND WANT_TARGET_UP = 1 AND :B14 = 1) OR (:B2 = :B6 AND WANT_WARNINGS = 1) OR (:B2 = :B5 AND WANT_CRITICAL_ALERTS = 1 AND :B14 <> 1) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 0) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 1 AND :B11 NOT IN (:B10 , :B9 )) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 0 AND :B11 IN (:B10 , :B9 )) OR ((:B2 = :B8 OR :B2 = :B6 OR :B2 = :B5 ) AND WANT_POLICY_VIOLATIONS = 1 ) OR (:B2 = :B1 AND WANT_POLICY_CLEARS = 1 ) ) ) OR (:B4 <> -1 AND ( (:B4 = :B7 AND :B2 = :B6 AND WANT_WARNING_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 = :B5 AND WANT_CRITICAL_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 <> :B1 AND WANT_POLICY_JOB_SUCCEEDED = 1) OR (:B4 = :B3 AND :B2 = :B6 AND WANT_WARNING_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 = :B5 AND WANT_CRITICAL_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 <> :B1 AND WANT_POLICY_JOB_PROBLEMS = 1) ) ) )) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N. PROFILE_NAME) OR (N.DEVICE_NAME = ' ' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B29 , :B28 ) ) ) ORDER BY CHECKUSER
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gx4mv66pvj3xzselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1
gzjm68u0xahd4SELECT LT_PRICE, LT_OPEN_PRICE, LT_VOL FROM E_LAST_TRADE WHERE LT_S_SYMB = :B1

  
Back to Top