WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHostStd Block Size
First (1st)PROD3935593814PROD111.2.0.2.0NOprdsrv0116384
Second (2nd)PROD3935593814PROD111.2.0.2.0NOprdsrv0116384

Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeAvg Active UsersElapsed Time (min)DB time (min)
1st1374705-Feb-13 07:00:24 (Tue)1374905-Feb-13 09:00:34 (Tue) 0.1 120.2 8.2
2nd1391512-Feb-13 07:00:28 (Tue)1391712-Feb-13 09:00:38 (Tue) 1.5 120.2 185.1
%Diff     2,100.0 0.0 2,169.2

Host Configuration Comparison

1st2ndDiff%Diff
Number of CPUs:242400.0
Number of CPU Cores:121200.0
Number of CPU Sockets:2200.0
Physical Memory:144912.7M144912.7M0M0.0
Load at Start Snapshot:.041.861.824,550.0
Load at End Snapshot:1.171.73.5647.9
%User Time:.242.642.41,000.0
%System Time:.14.52.37271.4
%Idle Time:99.4896.6-2.88-2.9
%IO Wait Time:.98.52-.46-46.9

Cache Sizes

1st (M)2nd (M)Diff (M)%Diff
Memory Target    
.....SGA Target8,192.08,192.00.00.0
..........Buffer Cache2,320.02,240.0-80.0-3.4
..........Shared Pool4,800.04,880.080.01.7
..........Large Pool400.0400.00.00.0
..........Java Pool96.096.00.00.0
..........Streams Pool16.016.00.00.0
.....PGA Target3,072.03,072.00.00.0
Log Buffer8.98.90.00.0

Load Profile

1st per sec2nd per sec%Diff1st per txn2nd per txn%Diff
DB time: 0.1 1.5 2,100.0 0.4 1.0 185.7
CPU time: 0.0 0.6 1,966.7 0.1 0.4 166.7
Redo size: 5,087.7 2,601,468.8 51,032.8 26,352.4 1,683,752.8 6,289.4
Logical reads: 2,825.6 37,042.1 1,211.0 14,635.6 23,974.8 63.8
Block changes: 32.0 11,206.0 34,918.8 165.7 7,252.9 4,276.1
Physical reads: 431.2 5,009.8 1,061.8 2,233.6 3,242.5 45.2
Physical writes: 1.1 1,235.6 113,259.6 5.6 799.7 14,079.6
User calls: 3.7 62.1 1,573.0 19.2 40.2 109.2
Parses: 9.1 105.2 1,060.9 46.9 68.1 45.0
Hard parses: 0.7 8.8 1,120.8 3.7 5.7 53.4
W/A MB processed: 349,457.7 25,791,822.3 7,280.5 1,810,073.8 16,693,282.4 7,280.5
Logons: 0.3 3.5 1,093.1 1.5 2.2 46.4
Executes: 13.4 181.1 1,253.2 69.3 117.2 69.0
Transactions: 0.2 1.5 715.8   
1st2ndDiff
% Blocks changed per Read: 1.1 30.3 29.1
Recursive Call %: 98.7 97.8 -1.0
Rollback per transaction %: 5.2 5.4 0.1
Rows per Sort: 2,091.7 8,442.2 6,350.5
Avg DB time per Call (sec): 0.0 0.0 0.0

Top Timed Events

1st 2nd
EventWait ClassWaitsTime(s)Avg Time(ms)%DB timeEventWait ClassWaitsTime(s)Avg Time(ms)%DB time
CPU time  205.90 42.08Backup: MML create a backup pieceAdministrative9620,869.65217,392.17187.94
direct path readUser I/O48,843121.322.4824.79CPU time  4,470.42 40.26
db file sequential readUser I/O9,78520.882.134.27Backup: MML commit backup pieceAdministrative963,312.0334,500.3329.83
db file scattered readUser I/O8025.576.951.14direct path readUser I/O577,7383,026.935.2427.26
control file parallel writeSystem I/O3,4304.941.441.01db file async I/O submitSystem I/O49,0311,876.6238.2716.90
-db file async I/O submitSystem I/O1,7903.381.890.69-db file scattered readUser I/O101,485168.451.661.52
-     -control file parallel writeSystem I/O39,77941.881.050.38
-     -db file sequential readUser I/O942,32433.000.040.30

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.00489.3711,104.612,169.160.351.00185.71
Java execution elapsed time26.2516.23-10.03128.481,801.981,302.540.090.1677.78
parse time elapsed3.710.92-2.7918.16102.02461.780.010.010.00
hard parse elapsed time2.820.50-2.3213.7855.20300.580.010.00-100.00
DB CPU42.0840.26-1.82205.904,470.422,071.160.150.40166.67
PL/SQL execution elapsed time1.670.60-1.078.1966.64713.680.010.010.00
sql execute elapsed time97.5198.450.94477.1810,932.822,191.130.340.98188.24
hard parse (sharing criteria) elapsed time0.850.02-0.834.172.55-38.850.000.000.00
PL/SQL compilation elapsed time0.280.01-0.271.361.16-14.710.000.000.00
connection management call elapsed time0.380.13-0.251.8614.66688.170.000.000.00
RMAN cpu time (backup/restore)0.000.200.200.0022.13100.000.000.000.00
hard parse (bind mismatch) elapsed time0.160.00-0.160.770.00-100.000.000.000.00
failed parse elapsed time0.020.00-0.020.110.1318.180.000.000.00
repeated bind elapsed time0.010.01-0.000.040.701,650.000.000.000.00
sequence load elapsed time0.000.00-0.000.010.04300.000.000.000.00
failed parse (out of shared memory) elapsed time0.000.000.000.000.000.000.000.000.00
inbound PL/SQL rpc elapsed time0.000.000.000.000.000.000.000.000.00
background elapsed time43.44271.13227.69212.5830,108.4414,063.350.152.701,700.00
background cpu time32.636.82-25.81159.67757.55374.450.110.07-36.36



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_TIME89,343588,034182.5752.95-71.0012.3981.56558.2764.1852.79-17.75
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_TIME17,213,59416,714,89935,175.241,505.22-95.722,387.432,318.24-2.9012,366.091,500.44-87.87
IOWAIT_TIME169,26589,132345.898.03-97.6823.4812.36-47.36121.608.00-93.42
NICE_TIME75570.150.01-93.330.010.010.000.050.01-80.00
RSRC_MGR_CPU_WAIT_TIME000.000.000.000.000.000.000.000.000.00
SYS_TIME24,78389,36350.648.05-84.103.4412.39260.1717.808.02-54.94
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_TIME41,015456,52283.8141.11-50.955.6963.321,012.8329.4640.9839.10
VM_IN_BYTES147,526,695,936700,014,446,592301,464,474.6763,038,196.23-79.0920,461,136.3597,087,227.83374.50105,981,821.7962,837,921.60-40.71
VM_OUT_BYTES844,151,808189,443,632,1281,724,988.0117,059,912.00888.99117,079.1826,274,539.2822,341.68606,430.9017,005,712.042,704.23



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
Administrative0.00245.24245.240.009.28100.000.0027,233.33100.000.00407.01100.00
System I/O2.7620.6817.923.3176.492,210.8813.522,296.6916,887.350.574.16629.82
Configuration0.009.339.330.000.32100.000.001,035.68100.000.03450.291,500,866.67
User I/O30.7134.954.2414.70454.982,995.10150.273,880.642,482.441.421.18-16.90
Application0.130.990.860.060.811,250.000.64110.0017,087.501.5318.731,124.18
Other0.500.990.491.4430.702,031.942.44110.244,418.030.230.50117.39
Concurrency0.570.17-0.400.327.182,143.752.7818.90579.861.200.37-69.17
Network0.010.280.272.09120.395,660.290.0531.0862,060.000.000.04100.00
Commit0.470.30-0.160.293.501,106.902.3033.831,370.871.101.3421.82


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
Backup: MML create a backup pieceAdministrative0.00187.94187.940.000.01100.000.0020,869.65100.000.00217,392.17100.00
Backup: MML commit backup pieceAdministrative0.0029.8329.830.000.01100.000.003,312.03100.000.0034,500.33100.00
db file async I/O submitSystem I/O0.6916.9016.210.256.802,620.003.381,876.6255,421.301.8938.271,924.87
Backup: MML query backup pieceAdministrative0.0015.5115.510.000.01100.000.001,722.59100.000.0017,943.65100.00
Backup: MML write backup pieceAdministrative0.0011.9711.970.009.24100.000.001,329.06100.000.0019.95100.00
log file switch (checkpoint incomplete)Configuration0.008.868.860.000.12100.000.00984.24100.000.001,132.61100.00
db file sequential readUser I/O4.270.30-3.971.36130.699,509.5620.8833.0058.052.130.04-98.12
direct path writeUser I/O0.003.043.040.0475.71189,175.000.02338.091,690,350.000.050.621,140.00
direct path readUser I/O24.7927.262.476.7780.131,083.60121.323,026.932,395.002.485.24111.29
direct path write tempUser I/O0.002.102.100.0029.82100.000.00233.23100.000.001.08100.00
RMAN backup & recovery I/OSystem I/O0.001.271.270.002.33100.000.00141.40100.000.008.40100.00
enq: KO - fast object checkpointApplication0.000.790.790.000.03100.000.0087.88100.000.00394.06100.00
control file parallel writeSystem I/O1.010.38-0.630.485.521,050.004.9441.88747.771.441.05-27.08
log file parallel writeSystem I/O0.951.430.471.0621.961,971.704.67158.393,291.650.611.0063.93
db file scattered readUser I/O1.141.520.380.1114.0812,700.005.57168.452,924.246.951.66-76.12
os thread startupConcurrency0.380.02-0.350.020.0350.001.852.6241.6216.0814.47-10.01
log file switch completionConfiguration0.000.320.320.000.05100.000.0036.04100.000.0097.14100.00
log file sequential readSystem I/O0.040.360.320.012.9429,300.000.1939.9720,936.844.351.88-56.78
enq: CR - block range reuse ckptOther0.120.400.280.061.462,333.330.5944.547,449.151.314.24223.66
enq: CF - contentionOther0.120.360.240.021.386,800.000.5739.886,896.493.994.010.50
Log archive I/OSystem I/O0.020.260.240.012.6526,400.000.0928.7031,788.892.301.50-34.78
SQL*Net more data from clientNetwork0.000.240.240.011.7617,500.000.0126.77267,600.000.232.11817.39
log file syncCommit0.470.30-0.160.293.501,106.902.3033.831,370.871.101.3421.82
direct path read tempUser I/O0.000.150.150.0069.52100.000.0016.15100.000.000.03100.00
log buffer spaceConfiguration0.000.130.130.000.06100.000.0014.90100.000.0037.44100.00
utl_file I/OUser I/O0.180.06-0.126.0750.58733.280.897.13701.120.020.020.00
read by other sessionUser I/O0.010.110.100.020.401,900.000.0712.2717,428.570.614.30604.92
ADR block file readOther0.110.01-0.100.010.02100.000.521.05101.9213.587.86-42.12
kksfbc child completionOther0.000.090.090.000.03100.000.009.79100.000.0046.60100.00
db file parallel readUser I/O0.170.250.080.000.28100.000.8127.673,316.0538.7213.55-65.01
enq: RO - fast object reuseApplication0.130.200.070.060.721,100.000.6422.063,346.881.544.26176.62
library cache: mutex XConcurrency0.070.01-0.060.275.021,759.260.340.6179.410.180.02-88.89
local write waitUser I/O0.080.05-0.040.060.711,083.330.415.061,134.150.890.9911.24
Disk file operations I/OUser I/O0.030.070.040.261.90630.770.157.604,966.670.080.55587.50
control file sequential readSystem I/O0.050.090.031.5134.172,162.910.269.533,565.380.020.04100.00
SQL*Net more data to clientNetwork0.010.040.030.3576.7621,831.430.034.1613,766.670.010.010.00
db file single writeUser I/O0.010.040.030.001.12100.000.074.566,414.293.800.56-85.26
library cache lockConcurrency0.030.040.020.000.07100.000.144.863,371.438.589.6212.12
PX Deq: Table Q Get KeysOther0.020.01-0.020.040.41925.000.110.80627.270.380.27-28.95
direct path syncUser I/O0.020.00-0.010.010.05400.000.090.50455.561.231.294.88
PX Deq: Slave Session StatsOther0.070.06-0.010.466.471,306.520.367.211,902.780.110.1536.36
PX Deq: Signal ACK RSGOther0.000.010.010.081.251,462.500.000.94100.000.010.10900.00
cursor: pin S wait on XConcurrency0.080.090.010.000.07100.000.409.922,380.0014.4018.4728.26
latch: shared poolConcurrency0.010.00-0.010.000.03100.000.050.27440.001.561.21-22.44
latch freeOther0.000.010.010.021.004,900.000.000.65100.000.030.09200.00
enq: BF - allocation contentionOther0.010.00-0.000.000.03100.000.030.09200.006.920.42-93.93
buffer busy waitsConcurrency0.000.010.000.001.57100.000.000.58100.000.090.05-44.44
PX Deq: Signal ACK EXTOther0.020.02-0.000.233.231,304.350.111.971,690.910.060.0833.33
undo segment extensionConfiguration0.000.000.000.000.01100.000.000.43100.000.0011.00100.00
PX qref latchOther0.000.000.000.022.5712,750.000.000.38100.000.000.02100.00
latch: call allocationOther0.000.00-0.000.040.30650.000.010.08700.000.050.04-20.00
enq: PS - contentionOther0.010.00-0.000.070.791,028.570.030.451,400.000.060.0833.33
log file single writeSystem I/O0.000.000.000.000.12100.000.000.21100.002.100.24-88.57
ADR block file writeOther0.000.00-0.000.000.01100.000.010.08700.000.810.77-4.94
rdbms ipc replyOther0.000.000.000.000.28100.000.000.10100.000.020.05150.00
asynch descriptor resizeOther0.000.00-0.000.197.183,678.950.010.06500.000.000.000.00
reliable messageOther0.020.02-0.000.122.582,050.000.091.972,088.890.100.1110.00
latch: cache buffers chainsConcurrency0.000.00-0.000.010.181,700.000.000.02100.000.040.02-50.00
enq: TX - row lock contentionApplication0.000.000.000.000.06100.000.000.06100.000.180.12-33.33
SQL*Net message to clientNetwork0.000.00-0.001.7341.882,320.810.010.151,400.000.000.000.00
enq: TX - allocate ITL entryConfiguration0.000.000.000.000.08100.000.000.05100.000.090.08-11.11
log file switch (private strand flush incomplete)Configuration0.000.000.000.000.000.000.000.02100.000.004.62100.00
LGWR wait for redo copyOther0.000.000.000.031.033,333.330.010.161,500.000.030.02-33.33
latch: object queue header operationOther0.000.000.000.000.02100.000.000.01100.000.000.07100.00
enq: CI - contentionOther0.000.000.000.000.01100.000.000.01100.000.000.09100.00
row cache lockConcurrency0.000.000.000.000.10100.000.000.01100.000.010.010.00
cursor: pin SConcurrency0.000.00-0.000.010.08700.000.000.000.000.010.010.00
ARCH wait for archivelog lockOther0.000.000.000.000.06100.000.000.000.000.000.000.00
PX Deq Credit: free bufferOther0.000.00-0.000.010.121,100.000.000.000.000.000.000.00
latch: redo allocationOther0.000.000.000.000.000.000.000.000.000.000.07100.00
PX Deq: Table Q qrefOther0.000.00-0.000.040.42950.000.000.01100.000.000.000.00
ADR file lockOther0.000.00-0.000.000.03100.000.000.000.000.010.02100.00
latch: cache buffers lru chainOther0.000.000.000.000.000.000.000.000.000.000.06100.00
latch: redo writingConfiguration0.000.00-0.000.000.000.000.000.000.000.010.02100.00
buffer deadlockOther0.000.000.000.000.02100.000.000.000.000.010.00-100.00
latch: parallel query alloc bufferOther0.000.000.000.000.000.000.000.000.000.000.11100.00
cursor: mutex SConcurrency0.000.000.000.000.03100.000.000.000.000.000.01100.00
latch: enqueue hash chainsOther0.000.000.000.000.000.000.000.000.000.000.03100.00
latch: row cache objectsConcurrency0.000.00-0.000.000.01100.000.000.000.000.020.05150.00
latch: In memory undo latchConcurrency0.000.000.000.000.000.000.000.000.000.000.04100.00
latch: checkpoint queue latchOther0.000.000.000.000.000.000.000.000.000.000.02100.00
latch: messagesOther0.000.000.000.000.000.000.000.000.000.010.02100.00
SQL*Net message from clientIdle15,490.13799.97-14,690.151.7842.092,264.6175,803.5388,833.5717.195,904.62292.72-95.04
Streams AQ: qmn slave idle waitIdle2,941.9265.08-2,876.850.090.04-55.5614,396.807,226.40-49.8122,888.3928,009.3222.37
DIAG idle waitIdle2,943.91129.74-2,814.162.002.000.0014,406.5014,407.520.011,001.011,001.010.00
PX Idle WaitIdle3,308.56601.73-2,706.820.233.251,313.0416,190.9766,819.91312.709,569.132,850.80-70.21
Space Manager: slave idle waitIdle2,681.23647.01-2,034.220.383.35781.5813,121.0471,848.00447.584,848.872,978.90-38.57
shared server idle waitIdle1,477.5464.84-1,412.700.030.030.007,230.597,200.61-0.4130,002.4530,002.530.00
Streams AQ: qmn coordinator idle waitIdle1,470.9665.08-1,405.880.110.110.007,198.387,226.400.399,372.899,336.43-0.39
JOX Jit Process SleepIdle458.8851.34-407.540.020.06200.002,245.615,701.54153.9013,446.7913,047.00-2.97
jobq slave waitIdle196.578.63-187.940.270.270.00961.94958.51-0.36501.01500.79-0.04
PX Deq: Execution MsgIdle5.9456.8050.871.8745.602,338.5029.056,307.5021,612.562.1519.18792.09
PX Deq: Table Q NormalIdle2.4351.1648.722.83648.9922,832.5111.905,680.6547,636.550.581.21108.62
PX Deq Credit: send blkdIdle1.2128.5327.320.10148.01147,910.005.903,167.6253,588.478.592.97-65.42
PX Deq: Execute ReplyIdle0.8112.2111.401.5988.185,445.913.941,355.5434,304.570.342.13526.47
PX Deq Credit: need bufferIdle0.000.680.670.0220.27101,250.000.0175.13751,200.000.090.51466.67
PX Deq: Join ACKIdle0.060.03-0.030.233.231,304.350.313.39993.550.190.15-21.05
PX Deq: Parse ReplyIdle0.120.10-0.010.233.231,304.350.5711.331,887.720.340.4944.12
PX Deq: Table Q SampleIdle0.000.010.010.000.07100.000.000.72100.000.001.40100.00
class slave waitIdle0.000.00-0.000.010.00-100.000.000.000.000.070.070.00
PX Deq: Msg FragmentIdle0.000.000.000.000.05100.000.000.000.000.000.000.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$USERS85.630.92-84.7178.041.00-77.0399.860.79-99.0633.811.03-32.78
PROD14.2993.0378.7421.9097.6375.740.1482.9482.8065.6896.4630.77
PRODXDB0.000.000.000.000.000.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.000.080.080.450.06-0.39


Back to Service Statistics
Back to Top

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiffTotal Diff
PROD0.000.000.000.000.000.000.00
PRODXDB0.000.000.000.000.000.000.00
SYS$BACKGROUND0.000.000.000.000.000.000.00
SYS$USERS0.000.000.000.000.000.000.00


Back to Service Statistics
Back to Top

SQL Statistics

Back to Top

Top SQL Comparison by Elapsed Time

 Elapsed Time % of DB time Elapsed Time (ms) per Exec #Exec/sec (DB time) CPU Time (ms) per Exec I/O Time (ms) per Exec Physical Reads per Exec #Rows Processed per Exec #Executions #Plans  
SQL Id1st1st Total2nd2nd TotalDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st/2nd/BothSQL Text
5p780wzurvqzd  35.8135.8135.81 795,214 0.00 256,889 44,557 754,395.20 1.00 5  begin :error_msg := null; :err...
fky21a2j944wr22.2622.26  -22.2615,562 0.01 1,248 73 62.57 1.00 7   begin sp_exec_rel_load; end;
f53dq339tg6ta14.8837.14  -14.888,091 0.02 3,881 4,551 114,122.56 9.56 9 2// 2 select c.rowid_object, c.full...
crm09z5z1m4vz6.2743.41  -6.2730,678 0.00 1,919 2,543 1,204.00 1.00 1   begin sp_link_dat_to_groups('...
c2t7mvu1f3sbf  4.2440.044.24 117,691 0.00 23,959 844 16,713.25 1.00 4  begin :error_msg := null; :err...
8csym9s53yg2y3.3746.78  -3.378,255 0.00 3,961 4,630 114,122.00 0.50 2 2// 2 select c.rowid_object, c.full...
gpank43gkh2rx2.9649.75  -2.96439 0.07 427 12 45.70 0.00 33 1// 1 insert into x_bo_dat_grp ( ro...
d6wmw6wbcc2nz2.5452.28  -2.5412,410 0.00 4,463 2,720 1,186.00 1.00 1   BEGIN prdmm.multi_merge( :1, :...
4m1a4b7gwk1br1.7153.993.7843.822.071,0466,9930.020.018435,2651182,178122.5028,701.951.001.00860  BEGIN prdld.maint_rr( :1, :2, ...
ggku786rstp2j1.8355.82  -1.838,947 0.00 4,061 5,196 114,124.00 0.00 1 1// 1 select c.rowid_object, c.full...
cmvws22p9ckyt1.7757.59  -1.778,650 0.00 2,405 6,435 4,984.00 1.00 1   begin sp_link_dat_to_groups('...
2vg2pg9vsm9gx2.4760.060.9944.81-1.491681750.150.06168175000.002.210.000.00726271/ 1/ 1 delete FROM anon_table_cac...
armw47wdxcsaq3.1063.161.9846.79-1.121,8933,7250.020.019152,890195793180.757,674.711.001.00859  BEGIN prdld.maint_delta( :1, :...
9rt2s2wsfqdcy1.5864.730.6347.42-0.941071120.150.06107110020.007.271.000.99726231/ 1/ 1 SELECT COUNT( * ) FROM USER_SO...
dbvkky621gqtr  0.7148.130.71 83 0.09 83 0 0.00 101.99 949/ 1/ 1 SELECT /*+ parallel */ EXTRACT...
cckfxmhqnpkvv  0.5848.710.58 32,210 0.00 17,337 14,519 96,467.50 1,000,000.00 2/ 2/ 2 create table ANONTAB
35cxwq3ftdjc9  0.4549.160.45 25,032 0.00 2,188 23,210 155,875.50 724.00 2/ 1/ 1 create table ANONTAB
0uduy46y8mdtf  0.4549.610.45 49,988 0.00 18,538 1 120.00 1,000,000.00 1/ 1/ 1 update ANONTAB


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
5p780wzurvqzd  28.7328.7328.73 256,889 44,557 0.00 795,214 754,395.20 1.00  begin :error_msg := null; :err...
f53dq339tg6ta16.9616.96  -16.963,881 4,551 0.02 8,091 114,122.56 9.56 2// 2 select c.rowid_object, c.full...
gpank43gkh2rx6.8423.80  -6.84427 12 0.07 439 45.70 0.00 1// 1 insert into x_bo_dat_grp ( ro...
fky21a2j944wr4.2428.05  -4.241,248 73 0.01 15,562 62.57 1.00   begin sp_exec_rel_load; end;
8csym9s53yg2y3.8531.89  -3.853,961 4,630 0.00 8,255 114,122.00 0.50 2// 2 select c.rowid_object, c.full...
4m1a4b7gwk1br3.2835.177.0735.803.798435,2651182,1780.020.011,0466,993122.5028,701.951.001.00  BEGIN prdld.maint_rr( :1, :2, ...
2vg2pg9vsm9gx5.8741.042.4538.25-3.43168175000.150.061681750.002.210.000.001/ 1/ 1 delete FROM anon_table_cac...
9rt2s2wsfqdcy3.7444.791.5439.78-2.21107110020.150.061071120.007.271.000.991/ 1/ 1 SELECT COUNT( * ) FROM USER_SO...
d6wmw6wbcc2nz2.1746.95  -2.174,463 2,720 0.00 12,410 1,186.00 1.00   BEGIN prdmm.multi_merge( :1, :...
c2t7mvu1f3sbf  2.1441.932.14 23,959 844 0.00 117,691 16,713.25 1.00  begin :error_msg := null; :err...
7z20v3mu30z1q2.5849.540.7442.67-1.84104281000.100.011052810.040.101.001.00  BEGIN prdlb.generate_key( :1 )...
dbvkky621gqtr  1.7644.421.76 83 0 0.09 83 0.00 101.99/ 1/ 1 SELECT /*+ parallel */ EXTRACT...
cckfxmhqnpkvv  0.7845.200.78 17,337 14,519 0.00 32,210 96,467.50 1,000,000.00/ 2/ 2 create table ANONTAB
61gh6sk81rxxc  0.7145.910.71 15,802 9,840 0.00 24,586 105,892.50 1,639,552.00/ 2/ 2 CREATE TABLE ANONTAB
armw47wdxcsaq3.5653.093.8149.720.269152,8901957930.020.011,8933,725180.757,674.711.001.00  BEGIN prdld.maint_delta( :1, :...


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
f53dq339tg6ta8.378.37  -8.374,551 8,091 0.02 3,881 114,122.56 9.56 9 2// 2 select c.rowid_object, c.full...
5p780wzurvqzd  2.012.012.01 44,557 795,214 0.00 256,889 754,395.20 1.00 5  begin :error_msg := null; :err...
8csym9s53yg2y1.8910.26  -1.894,630 8,255 0.00 3,961 114,122.00 0.50 2 2// 2 select c.rowid_object, c.full...
cmvws22p9ckyt1.3111.58  -1.316,435 8,650 0.00 2,405 4,984.00 1.00 1   begin sp_link_dat_to_groups('...
ggku786rstp2j1.0612.64  -1.065,196 8,947 0.00 4,061 114,124.00 0.00 1 1// 1 select c.rowid_object, c.full...
4m1a4b7gwk1br0.1912.831.183.180.981182,1781,0466,9930.020.018435,265122.5028,701.951.001.00860  BEGIN prdld.maint_rr( :1, :2, ...
d6wmw6wbcc2nz0.5613.39  -0.562,720 12,410 0.00 4,463 1,186.00 1.00 1   BEGIN prdmm.multi_merge( :1, :...
crm09z5z1m4vz0.5213.91  -0.522,543 30,678 0.00 1,919 1,204.00 1.00 1   begin sp_link_dat_to_groups('...
35cxwq3ftdjc9  0.423.600.42 23,210 25,032 0.00 2,188 155,875.50 724.00 2/ 1/ 1 create table ANONTAB
cckfxmhqnpkvv  0.263.860.26 14,519 32,210 0.00 17,337 96,467.50 1,000,000.00 2/ 2/ 2 create table ANONTAB
fky21a2j944wr0.1014.01  -0.1073 15,562 0.01 1,248 62.57 1.00 7   begin sp_exec_rel_load; end;
armw47wdxcsaq0.3214.330.424.280.101957931,8933,7250.020.019152,890180.757,674.711.001.00859  BEGIN prdld.maint_delta( :1, :...
gpank43gkh2rx0.0814.41  -0.0812 439 0.07 427 45.70 0.00 33 1// 1 insert into x_bo_dat_grp ( ro...
c2t7mvu1f3sbf  0.034.310.03 844 117,691 0.00 23,959 16,713.25 1.00 4  begin :error_msg := null; :err...
9rt2s2wsfqdcy0.0014.410.014.330.01021071120.150.061071100.007.271.000.99726231/ 1/ 1 SELECT COUNT( * ) FROM USER_SO...
2vg2pg9vsm9gx0.0014.410.004.330.00001681750.150.061681750.002.210.000.00726271/ 1/ 1 delete FROM anon_table_cac...
0uduy46y8mdtf  0.004.330.00 1 49,988 0.00 18,538 120.00 1,000,000.00 1/ 1/ 1 update ANONTAB
dbvkky621gqtr  0.004.330.00 0 83 0.09 83 0.00 101.99 949/ 1/ 1 SELECT /*+ parallel */ EXTRACT...


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
5p780wzurvqzd  33.3833.3833.38 17,830,268.60 5 795,214 256,889 44,557 754,395.20 1.00  begin :error_msg := null; :err...
2vg2pg9vsm9gx63.8063.8042.8976.27-20.91180,523.00182,706.0072627168175168175000.002.210.000.001/ 1/ 1 delete FROM anon_table_cac...
7z20v3mu30z1q19.1482.949.1685.44-9.9876,451.06207,391.2051118105281104281000.040.101.001.00  BEGIN prdlb.generate_key( :1 )...
fky21a2j944wr7.7990.73  -7.79226,771.86 7 15,562 1,248 73 62.57 1.00   begin sp_exec_rel_load; end;
armw47wdxcsaq8.6399.362.5988.02-6.05219,836.63117,094.638591,8933,7259152,890195793180.757,674.711.001.00  BEGIN prdld.maint_delta( :1, :...
f53dq339tg6ta5.06104.42  -5.06114,589.22 9 8,091 3,881 4,551 114,122.56 9.56 2// 2 select c.rowid_object, c.full...
fyfxzazwfpbz7  4.7592.774.75 211,231.72 60 527 509 19 117.15 1.00  BEGIN prdut.generate_constrain...
09y8y6k71rhqn  4.5897.354.58 207,548.46 59 298 292 2 3.56 1.00  BEGIN prdut.disable_constraint...
5ypw77s2m96yc4.03108.45  -4.0327,371.20 30 39 39 1 0.00 1.00   BEGIN prdlog.file_rolling (); ...
9rt2s2wsfqdcy8.72117.175.71103.06-3.0124,666.1424,468.2672623107112107110020.007.271.000.991/ 1/ 1 SELECT COUNT( * ) FROM USER_SO...
93b0px38476d38.69125.875.70108.76-2.9924,600.3824,338.477262651535150020.007.1723,816.5723,304.811/ 1/ 1 select o.obj#, o.type#, u.name...
229gsdj5ps3pn2.89128.75  -2.89587,901.00 1 5,715 4,152 1,534 8,798.00 1.00   begin sp_denormalize_groups('2...
4m1a4b7gwk1br8.62137.375.85114.62-2.76219,421.50260,563.428601,0466,9938435,2651182,178122.5028,701.951.001.00  BEGIN prdld.maint_rr( :1, :2, ...
c2t7mvu1f3sbf  1.24115.861.24 830,511.25 4 117,691 23,959 844 16,713.25 1.00  begin :error_msg := null; :err...


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
f53dq339tg6ta33.0333.03  -33.03114,122.56 9 8,091 3,881 4,551 9.56 2// 2 select c.rowid_object, c.full...
5p780wzurvqzd  10.4410.4410.44 754,395.20 5 795,214 256,889 44,557 1.00  begin :error_msg := null; :err...
8csym9s53yg2y7.3440.38  -7.34114,122.00 2 8,255 3,961 4,630 0.50 2// 2 select c.rowid_object, c.full...
4m1a4b7gwk1br0.0340.414.7715.214.74122.5028,701.958601,0466,9938435,2651182,1781.001.00  BEGIN prdld.maint_rr( :1, :2, ...
ggku786rstp2j3.6744.08  -3.67114,124.00 1 8,947 4,061 5,196 0.00 1// 1 select c.rowid_object, c.full...
05jgbg38fja193.6747.75  -3.67114,122.00 1 8,337 3,984 4,667 0.00 1// 1 select c.rowid_object, c.full...
0gz3r29t7uxdw3.6751.42  -3.67114,122.00 1 7,892 4,156 4,082 0.00 1// 1 select c.rowid_object, c.full...
0ht163d05xnqf3.6755.09  -3.67114,122.00 1 8,231 4,224 4,387 0.00 1// 1 select c.rowid_object, c.full...
10w62cb6udswr3.6758.76  -3.67114,122.00 1 8,038 3,993 4,367 0.00 1// 1 select c.rowid_object, c.full...
2vw792k09qhht3.6762.43  -3.67114,122.00 1 8,034 4,089 4,324 0.00 1// 1 select c.rowid_object, c.full...
383w76mqhft8a3.6766.10  -3.67114,122.00 1 7,919 4,046 4,205 0.00 1// 1 select c.rowid_object, c.full...
3z4614fqt7uct3.6769.77  -3.67114,122.00 1 7,902 4,002 4,213 1.00 1// 1 select c.rowid_object, c.full...
armw47wdxcsaq0.0569.821.2516.461.21180.757,674.718591,8933,7259152,8901957931.001.00  BEGIN prdld.maint_delta( :1, :...
35cxwq3ftdjc9  0.8617.330.86 155,875.50 2 25,032 2,188 23,210 724.00/ 1/ 1 create table ANONTAB
61gh6sk81rxxc  0.5917.910.59 105,892.50 2 24,586 15,802 9,840 1,639,552.00/ 2/ 2 CREATE TABLE ANONTAB
cckfxmhqnpkvv  0.5318.450.53 96,467.50 2 32,210 17,337 14,519 1,000,000.00/ 2/ 2 create table ANONTAB
0z35tvax59u3a  0.4318.880.43 155,901.00 1 23,166 3,019 20,522 2,770.00/ 1/ 1 create table ANONTAB
d2dccmyz4q092  0.4319.310.43 155,141.00 1 27,451 5,874 21,956 4,008.00/ 1/ 1 CREATE TABLE ANONTAB
6mbnz0rxzbd5d  0.4319.740.43 154,947.00 1 26,411 5,864 20,923 3,750.00/ 1/ 1 CREATE TABLE ANONTAB
cckvkdz7xwdt1  0.4320.170.43 154,783.00 1 26,762 5,822 21,328 4,092.00/ 1/ 1 CREATE TABLE ANONTAB


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
5p780wzurvqzd  46.2146.2146.21 199,372.40 996,862 0.00 5 795,214 256,889 44,557 1.00  begin :error_msg := null; :err...
f53dq339tg6ta27.3627.36  -27.361,809.56 16,286 0.00 9 8,091 3,881 4,551 9.56 2// 2 select c.rowid_object, c.full...
8csym9s53yg2y6.0833.44  -6.081,809.00 3,618 0.00 2 8,255 3,961 4,630 0.50 2// 2 select c.rowid_object, c.full...
ggku786rstp2j3.0436.48  -3.041,811.00 1,811 0.00 1 8,947 4,061 5,196 0.00 1// 1 select c.rowid_object, c.full...
05jgbg38fja193.0439.52  -3.041,809.00 1,809 0.00 1 8,337 3,984 4,667 0.00 1// 1 select c.rowid_object, c.full...
0gz3r29t7uxdw3.0442.56  -3.041,809.00 1,809 0.00 1 7,892 4,156 4,082 0.00 1// 1 select c.rowid_object, c.full...
0ht163d05xnqf3.0445.60  -3.041,809.00 1,809 0.00 1 8,231 4,224 4,387 0.00 1// 1 select c.rowid_object, c.full...
10w62cb6udswr3.0448.64  -3.041,809.00 1,809 0.00 1 8,038 3,993 4,367 0.00 1// 1 select c.rowid_object, c.full...
2vw792k09qhht3.0451.68  -3.041,809.00 1,809 0.00 1 8,034 4,089 4,324 0.00 1// 1 select c.rowid_object, c.full...
383w76mqhft8a3.0454.72  -3.041,809.00 1,809 0.00 1 7,919 4,046 4,205 0.00 1// 1 select c.rowid_object, c.full...
3z4614fqt7uct3.0457.75  -3.041,809.00 1,809 0.00 1 7,902 4,002 4,213 1.00 1// 1 select c.rowid_object, c.full...
4m1a4b7gwk1br2.5360.295.4251.622.88188.501,947.831,508116,8700.000.008601,0466,9938435,2651182,1781.001.00  BEGIN prdld.maint_rr( :1, :2, ...
61gh6sk81rxxc  0.6852.300.68 7,302.00 14,604 0.00 2 24,586 15,802 9,840 1,639,552.00/ 2/ 2 CREATE TABLE ANONTAB
armw47wdxcsaq1.6061.881.1453.44-0.46118.75415.3295024,5040.000.008591,8933,7259152,8901957931.001.00  BEGIN prdld.maint_delta( :1, :...
cckfxmhqnpkvv  0.3853.820.38 4,085.00 8,170 0.00 2 32,210 17,337 14,519 1,000,000.00/ 2/ 2 create table ANONTAB
35cxwq3ftdjc9  0.2554.070.25 2,715.50 5,431 0.00 2 25,032 2,188 23,210 724.00/ 1/ 1 create table ANONTAB
d2dccmyz4q092  0.1854.250.18 3,932.00 3,932 0.00 1 27,451 5,874 21,956 4,008.00/ 1/ 1 CREATE TABLE ANONTAB
6mbnz0rxzbd5d  0.1754.420.17 3,738.00 3,738 0.00 1 26,411 5,864 20,923 3,750.00/ 1/ 1 CREATE TABLE ANONTAB
cckvkdz7xwdt1  0.1754.590.17 3,572.00 3,572 0.00 1 26,762 5,822 21,328 4,092.00/ 1/ 1 CREATE TABLE ANONTAB
0z35tvax59u3a  0.1354.710.13 2,702.00 2,702 0.00 1 23,166 3,019 20,522 2,770.00/ 1/ 1 create table ANONTAB


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
60uw2vh6q9vn2 9.919.91 110,060 0 0 0 0.01 1.00  insert into col$(obj#, name, i...
bsa0wjtftg3uw1.567.275.7176380,7560000000.000.001.932.012/ 1/ 2 select file# from file$ where ...
86kwhy1f0bttn 2.122.12 23,520 0 0 0 0.00 1.00/ 1/ 1 SELECT /*+ ALL_ROWS */ COUNT(*...
cm5vu20fhtnq11.92 -1.92941 0 0 0 0.00 0.89 1// 1 select /*+ connect_by_filterin...
7jpt4cpfvcy1k3.361.49-1.871,64416,5520000000.000.001.001.001/ 1/ 1 select ts#, online$ from ts$ w...
9y7s2afnkqs9d3.011.56-1.451,47317,3130000000.000.000.000.001/ 1/ 1 delete from idl_ub2$ where obj...
d5jd9b2xct7xz3.011.56-1.451,47317,3130000000.000.000.000.001/ 1/ 1 delete from idl_char$ where ob...
dvpfc386d6dmm3.011.56-1.451,47317,3130000000.000.000.000.001/ 1/ 1 delete from idl_sb4$ where obj...
gdhz78y24tvnz3.011.56-1.451,47317,3130000000.000.000.000.001/ 1/ 1 delete from ncomp_dll$ where o...
gsqxm6zz3w2by3.011.56-1.451,47317,3130000000.000.000.000.001/ 1/ 1 delete from idl_ub1$ where obj...
3nkd3g3ju5ph12.931.58-1.351,43417,4980000000.000.000.050.021/ 1/ 1 select obj#, type#, ctime, mti...
0kkhhb2w93cx03.042.52-0.531,48927,9390000000.000.011.001.001/ 1/ 1 update seg$ set type#=:4, bloc...
96g93hntrzjtr9.489.990.504,640110,8850000000.000.000.040.001/ 1/ 1 select /*+ rule */ bucket_cnt,...


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
bsa0wjtftg3uw1.161.1610.7610.769.5976181,57676380,7562/ 1/ 2 select file# from file$ where ...
cm5vu20fhtnq11.442.60  -1.44941 941 1// 1 select /*+ connect_by_filterin...
7jpt4cpfvcy1k2.525.122.1812.94-0.331,64416,5521,64416,5521/ 1/ 1 select ts#, online$ from ts$ w...
8w4c8u9udsuyy1.286.401.4914.430.2183611,33283611,3322/ 1/ 2 select count(*) from ( select ...
ct6c4h224pxgz1.347.741.5515.980.2187611,76087611,760  BEGIN BEGIN IF (sys.is_vpd_ena...
bkjxktgc8afm11.339.071.5317.520.2086811,61986811,619  DECLARE cnt NUMBER; stmt VARCH...
9y7s2afnkqs9d2.2511.322.2819.800.031,47317,3131,47317,3131/ 1/ 1 delete from idl_ub2$ where obj...
d5jd9b2xct7xz2.2513.582.2822.080.031,47317,3131,47317,3131/ 1/ 1 delete from idl_char$ where ob...
dvpfc386d6dmm2.2515.832.2824.360.031,47317,3131,47317,3131/ 1/ 1 delete from idl_sb4$ where obj...
gdhz78y24tvnz2.2518.092.2826.650.031,47317,3131,47317,3131/ 1/ 1 delete from ncomp_dll$ where o...
gsqxm6zz3w2by2.2520.342.2828.930.031,47317,3131,47317,3131/ 1/ 1 delete from idl_ub1$ where obj...


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
8gycngut7mkwq0.570.570.230.23-0.3528,747,62411,533,76828,747,62411,533,768 2 /* SQL Analyze(0) */ select /*...
b398mjk7k7wxj  0.290.520.29 14,826,145 14,826,145 5 /* SQL Analyze(0) */ select /*...
cdpujnv16qc8x  0.290.800.29 14,678,848 14,678,848 9 /* SQL Analyze(0) */ select /*...
7jarczsb0yzc5  0.281.080.28 14,292,025 14,292,025 4 /* SQL Analyze(0) */ select /*...
gb2kz2wr720qc0.250.82  -0.2512,475,472 12,475,472    create table ANONTAB
80q5hfvumz1db  0.241.320.24 12,296,359 12,296,359 4 /* SQL Analyze(0) */ select /*...
6v98v8ux0t9xc  0.171.500.17 8,927,437 8,927,437 9 create table ANONTAB
7dhd4uf7t3dbw0.301.120.131.63-0.1715,108,4166,669,93715,108,4166,669,937 3 create table ANONTAB
asbucjjc707tn  0.171.790.17 8,450,768 8,450,768 25 create table ANONTAB
8tdynzm3uxv3r  0.161.950.16 8,350,373 8,350,373 9 create table ANONTAB
dht82v68h5sj6  0.162.110.16 8,021,984 8,021,984 4 /* SQL Analyze(0) */ select /*...
9g5t9p9rvdchn  0.142.250.14 7,170,985 7,170,985 4 /* SQL Analyze(0) */ select /*...
d89c1mh5pvbkz0.131.25  -0.136,435,072 6,435,072 129  SELECT /*+ rule */ U.NAME, OT....
31tvs8p54y31d0.161.400.062.31-0.107,881,0482,914,0877,881,0482,914,087 3 select substrb(dump(val, 16, 0...
0dzypz17rawyn0.091.50  -0.094,669,758 4,669,758 1  create table ANONTAB
aa7fqth6y5rhx0.081.58  -0.084,199,868 4,199,868 1  create table ANONTAB
4zc5qdcch4b9a0.081.66  -0.084,110,250 4,110,250 1  create table ANONTAB
1r8gswtqtxxx70.081.750.042.35-0.054,241,9041,892,7954,241,9041,892,795 2 select substrb(dump(val, 16, 0...
buhbzpq7d7r7z0.091.840.052.39-0.044,517,1362,442,4224,517,1362,442,422 3 select substrb(dump(val, 16, 0...


Back to SQL Statistics
Back to Top

Top SQL Comparison by Version Count

 Version Count Version Count Max #Executions  
SQL Id1st2ndDiff1st2nd1st2ndSQL Text
gb2kz2wr720qc450 -450450    create table ANONTAB
gjxpqm7s2tf4q281 -281281 10  select substrb(dump(val, 16, 0...
6v98v8ux0t9xc 265265 265 9 create table ANONTAB
8tdynzm3uxv3r 263263 263 9 create table ANONTAB
8zw484p3sz36d 255255 255 9 select substrb(dump(val, 16, 0...
azu1ksrdbujgk 252252 252 8 select substrb(dump(val, 16, 0...
cdpujnv16qc8x 247247 247 9 /* SQL Analyze(0) */ select /*...
1r8gswtqtxxx7282523241282523 2 select substrb(dump(val, 16, 0...
1gu8t96d0bdmu156 -156156 197  select t.ts#, t.file#, t.block...
7dhd4uf7t3dbw422576154422576 3 create table ANONTAB
31tvs8p54y31d611757146611757 3 select substrb(dump(val, 16, 0...
buhbzpq7d7r7z40750295407502 3 select substrb(dump(val, 16, 0...
8gycngut7mkwq40649791406497 2 /* SQL Analyze(0) */ select /*...
3ktacv9r56b5184 -8484 97  select owner#, name, namespace...
69k5bhm12sz9876 -7676 4  SELECT dbin.instance_number, d...


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
03qzkjk3u3q1g  0.000.000.00 0.00 0.00 1/ 1/ 1 CREATE TABLE ANONTAB
03tuga43v3xkg0.000.000.000.000.000.000.000.000.003774,617  BEGIN aw_drop_proc(ora_dict_ob...
03xmj98vw7aqv0.000.00  0.000.00 0.00 62 1// 1 SELECT /*+ leading(u op tcp ts...
05bcrtybfu5rj0.000.00  0.000.00 0.00 12 1// 1 SELECT ANONTAB
05jgbg38fja190.000.00  0.000.00 0.00 1 1// 1 select c.rowid_object, c.full...
09y8y6k71rhqn  0.000.000.00 0.00 0.00 59  BEGIN prdut.disable_constraint...
0a1n8y6rzny100.000.00  0.000.00 0.00 29 1// 1 select dat_grp_id, dat_grp_n...
0cmahs6p5fjc9  0.000.000.00 0.00 0.00 1/ 1/ 1 update ANONTAB
0dzypz17rawyn0.000.00  0.000.00 0.00 1 1// 1 create table ANONTAB
0f44zztxs6y8y0.000.00  0.000.00 0.00 1 1// 1 insert into ANONTAB
0gtmk6w7c653a0.000.00  0.000.00 0.00 1   BEGIN prdbv.preview_bvt( :1, :...
0gz3r29t7uxdw0.000.00  0.000.00 0.00 1 1// 1 select c.rowid_object, c.full...
0ht163d05xnqf0.000.00  0.000.00 0.00 1 1// 1 select c.rowid_object, c.full...
0kkhhb2w93cx00.000.000.000.000.000.000.000.000.001,48927,9391/ 1/ 1 update seg$ set type#=:4, bloc...
0ucq6bhap8869  0.000.000.00 0.00 0.00 4/ 1/ 1 /* SQL Analyze(0) */ select /*...
0uduy46y8mdtf  0.000.000.00 0.00 0.00 1/ 1/ 1 update ANONTAB
0xmc93n0tdguk  0.000.000.00 0.00 0.00 4/ 1/ 1 select substrb(dump(val, 16, 0...
0z35tvax59u3a  0.000.000.00 0.00 0.00 1/ 1/ 1 create table ANONTAB
10d1f1nmcdu3z  0.000.000.00 0.00 0.00 1/ 1/ 1 CREATE TABLE ANONTAB


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 changes230,70480,797,24334,922.04471.437,276.011,443.3932.0011,206.0334,918.84165.747,252.894,276.06
execute count96,5021,305,4551,252.78197.20117.56-40.3913.38181.061,253.2169.33117.1969.03
logons cumulative2,12524,9121,072.334.342.24-48.390.293.461,093.101.532.2446.41
opened cursors cumulative94,2661,269,9291,247.18192.63114.36-40.6313.07176.131,247.5967.72114.0068.34
parse count (total)65,338758,3961,060.73133.5268.30-48.859.06105.181,060.9346.9468.0845.04
parse time elapsed1,47710,328599.263.020.93-69.210.201.43615.001.060.93-12.26
physical reads3,109,20636,121,7841,061.776,353.533,252.86-48.80431.235,009.841,061.762,233.633,242.5345.17
physical writes7,8448,909,040113,477.7716.03802.284,904.871.091,235.62113,259.635.64799.7314,079.61
redo size36,682,54818,757,006,42451,033.3274,959.211,689,119.212,153.385,087.672,601,468.8251,032.8126,352.411,683,752.826,289.37
session cursor cache hits52,509784,7841,394.57107.3070.67-34.147.28108.841,395.0537.7270.4586.77
session logical reads20,372,713267,079,4541,210.9741,630.7724,051.23-42.232,825.5837,042.101,210.9614,635.5723,974.8263.81
user calls26,746447,5701,573.4154.6540.30-26.263.7162.071,573.0519.2140.18109.16
user commits1,31910,541699.172.700.95-64.810.181.46711.110.950.950.00
user rollbacks73599720.550.150.05-66.670.010.08700.000.050.050.00
workarea executions - optimal8,05474,417823.9816.466.70-59.301.1210.32821.435.796.6815.37


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 count51,58631,620.000.010.141,300.000.000.22100.000.000.14100.00
Batched IO block miss count15667,67843,283.330.326.091,803.130.029.3946,850.000.116.085,427.27
Batched IO buffer defrag count41,74543,525.000.010.161,500.000.000.24100.000.000.16100.00
Batched IO double miss count135,80644,561.540.030.521,633.330.000.81100.000.010.525,100.00
Batched IO same unit count3416,09047,223.530.071.451,971.430.002.23100.000.021.447,100.00
Batched IO single block count41,19829,850.000.010.111,000.000.000.17100.000.000.11100.00
Batched IO vector block count11851,22843,313.560.244.611,820.830.027.1035,400.000.084.605,650.00
Batched IO vector read count122,32719,291.670.020.21950.000.000.32100.000.010.212,000.00
Block Cleanout Optim referenced52,71454,180.000.010.242,300.000.000.38100.000.000.24100.00
CCursor + sql area evicted2422,496931.400.490.22-55.100.030.351,066.670.170.2229.41
CPU used by this session22,179445,7701,909.8745.3240.14-11.433.0861.831,907.4715.9340.02151.22
CPU used when call started20,768444,1582,038.6742.4440.00-5.752.8861.602,038.8914.9239.87167.23
CR blocks created2107,9003,661.900.430.7165.120.031.103,566.670.150.71373.33
Commit SCN cached114244,179214,092.110.2321.999,460.870.0233.87169,250.000.0821.9227,300.00
DBWR checkpoint buffers written3,1552,629,51683,244.416.45236.803,571.320.44364.7082,786.362.27236.0410,298.24
DBWR checkpoints4275,9621,296.250.870.54-37.930.060.831,283.330.310.5474.19
DBWR object drop buffers written2,42147,2591,852.044.954.26-13.940.346.551,826.471.744.24143.68
DBWR transaction table writes182936414.290.370.08-78.380.030.13333.330.130.08-38.46
DBWR undo block writes987500,44650,603.752.0245.072,131.190.1469.4149,478.570.7144.926,226.76
DDL statements parallelized1582,2751,339.870.320.20-37.500.020.321,500.000.110.2081.82
DFO trees parallelized2774,0061,346.210.570.36-36.840.040.561,300.000.200.3680.00
HSC Heap Segment Block Changes29,34336,988,289125,954.9059.963,330.905,455.204.075,130.02125,944.7221.083,320.3115,651.00
Heap Segment Array Inserts2471,064330.770.500.10-80.000.030.15400.000.180.10-44.44
Heap Segment Array Updates1,51351,4283,299.073.094.6349.840.217.133,295.241.094.62323.85
IMU CR rollbacks69431,3224,413.261.422.8298.590.104.344,240.000.502.81462.00
IMU Flushes2633,8231,353.610.540.34-37.040.040.531,225.000.190.3478.95
IMU Redo allocation size242,0847,584,7003,033.09494.69683.0238.0733.581,051.953,032.67173.91680.85291.50
IMU commits3211,773452.340.660.16-75.760.040.25525.000.230.16-30.43
IMU undo allocation size1,275,83210,736,144741.502,607.11966.82-62.92176.951,489.03741.50916.55963.755.15
Number of read IOs issued48,843577,5121,082.3899.8152.01-47.896.7780.101,083.1635.0951.8447.73
PX local messages recv'd45,4015,641,86212,326.7492.77508.06447.666.30782.4912,320.4832.62506.451,452.58
PX local messages sent45,4015,642,03212,327.1192.77508.08447.686.30782.5112,320.7932.62506.471,452.64
Parallel operations downgraded to serial44119170.450.090.01-88.890.010.02100.000.030.01-66.67
Parallel operations not downgraded2774,0381,357.760.570.36-36.840.040.561,300.000.200.3680.00
RowCR attempts642,926715,333.330.013.8738,600.000.005.95100.000.003.85100.00
RowCR hits1242,096350,700.000.023.7918,850.000.005.84100.000.013.7837,700.00
SMON posted for undo segment shrink1151,400.000.000.000.000.000.000.000.000.000.00
SQL*Net roundtrips to/from client11,072296,0602,573.9522.6326.6617.811.5441.062,566.237.9526.58234.34
active txn count during cleanout82631,8003,749.881.692.8669.230.114.413,909.090.592.85383.05
background checkpoints completed142742,600.000.000.04100.000.000.06100.000.000.04100.00
background checkpoints started142742,600.000.000.04100.000.000.06100.000.000.04100.00
background timeouts40,04339,578-1.1681.833.56-95.655.555.49-1.0828.773.55-87.66
buffer is not pinned count15,384,222173,374,1981,026.9631,437.0015,612.82-50.342,133.7124,045.821,026.9511,051.8815,563.2140.82
buffer is pinned count8,727,92979,402,322809.7517,835.157,150.39-59.911,210.5211,012.56809.746,270.067,127.6813.68
bytes received via SQL*Net from client2,489,3002,386,576,27995,773.395,086.78214,917.664,125.02345.25331,001.8595,773.091,788.29214,234.8511,879.87
bytes sent via SQL*Net to client9,494,4831,456,822,25315,243.8819,401.57131,190.79576.191,316.83202,051.3115,243.776,820.75130,773.991,817.30
calls to get snapshot scn: kcmgss99,7351,430,6431,334.44203.80128.83-36.7913.83198.421,334.7171.65128.4279.23
calls to kcmgas17,9731,810,9449,975.9136.73163.08344.002.49251.179,987.1512.91162.561,159.18
calls to kcmgcs58,1781,633,3972,707.59118.88147.0923.738.07226.542,707.1941.79146.62250.85
cell physical IO interconnect bytes51,480,388,608820,783,090,1761,494.36105,197,965.7673,913,739.57-29.747,140,045.02113,837,014.741,494.3536,983,037.7973,678,912.9499.22
change write time40621,1305,104.430.831.90128.920.062.934,783.330.291.90555.17
cleanout - number of ktugct calls8652,820,822326,006.591.77254.0214,251.410.12391.23325,925.000.62253.2240,741.94
cleanouts and rollbacks - consistent read gets132841537.120.270.08-70.370.020.12500.000.090.08-11.11
cleanouts only - consistent read gets202,787,97413,939,770.000.04251.06627,550.000.00386.67100.000.01250.272,502,600.00
cluster key scan block gets32,189546,4591,597.6665.7849.21-25.194.4675.791,599.3323.1249.05112.15
cluster key scans21,169403,3331,805.3043.2636.32-16.042.9455.941,802.7215.2136.21138.07
commit batch/immediate performed87975,9018,534.931.806.84280.000.1210.538,675.000.636.81980.95
commit batch/immediate requested87975,9018,534.931.806.84280.000.1210.538,675.000.636.81980.95
commit cleanout failures: callback failure184252,261.110.040.040.000.000.06100.000.010.04300.00
commit cleanout failures: cannot pin596619,220.000.010.09800.000.000.13100.000.000.09100.00
commit cleanouts23,593882,6983,641.3648.2179.4964.883.27122.423,643.7316.9579.24367.49
commit cleanouts successfully completed23,570880,6373,636.2648.1679.3064.663.27122.143,635.1716.9379.05366.92
commit immediate performed87975,9018,534.931.806.84280.000.1210.538,675.000.636.81980.95
commit immediate requested87975,9018,534.931.806.84280.000.1210.538,675.000.636.81980.95
commit txn count during cleanout3132,794,986892,866.770.64251.7039,228.130.04387.65969,025.000.22250.90113,945.45
consistent changes4,52576,9801,601.229.256.93-25.080.6310.681,595.243.256.91112.62
consistent gets20,109,392218,847,681988.2941,092.6819,707.83-52.042,789.0630,352.68988.2814,446.4019,645.2135.99
consistent gets - examination12,268,925111,764,114810.9525,071.0210,064.66-59.861,701.6315,500.92810.958,813.8810,032.6913.83
consistent gets direct3,081,29429,427,732855.046,296.492,650.05-57.91427.364,081.43855.032,213.572,641.6319.34
consistent gets from cache17,028,098189,419,9491,012.4034,796.1917,057.78-50.982,361.7026,271.251,012.3912,232.8317,003.5939.00
consistent gets from cache (fastpath)4,651,49676,332,7171,541.049,505.136,873.97-27.68645.1410,586.831,541.013,341.596,852.13105.06
cursor authentications5125,125900.981.050.46-56.190.070.71914.290.370.4624.32
data blocks consistent reads - undo records applied94241,8534,342.991.923.7796.350.135.804,361.540.683.76452.94
db block gets263,32148,231,77318,216.72538.094,343.40707.1936.526,689.4218,217.14189.174,329.602,188.74
db block gets direct5503,104,718564,394.181.12279.5924,863.390.08430.60538,150.000.40278.7069,575.00
db block gets from cache262,77145,127,05517,073.53536.964,063.81656.8236.446,258.8117,075.66188.774,050.902,045.94
db block gets from cache (fastpath)73,2732,477,5103,281.20149.73223.1149.0110.16343.613,281.9952.64222.40322.49
deferred (CURRENT) block cleanout applications8,674369,9094,164.5717.7233.3187.981.2051.304,175.006.2333.21433.07
dirty buffers inspected92503,783547,490.220.1945.3723,778.950.0169.87698,600.000.0745.2264,500.00
enqueue conversions11,294144,8651,182.6723.0813.05-43.461.5720.091,179.628.1113.0060.30
enqueue releases116,0321,119,505864.82237.11100.81-57.4816.09155.27865.0183.36100.4920.55
enqueue requests116,0351,120,073865.29237.11100.87-57.4616.09155.35865.5183.36100.5520.62
enqueue timeouts356918,866.670.010.05400.000.000.08100.000.000.05100.00
enqueue waits1,49532,9362,103.083.052.97-2.620.214.572,076.191.072.96176.64
exchange deadlocks114914,800.000.000.01100.000.000.02100.000.000.01100.00
free buffer inspected41,2825,126,78812,318.9484.36461.68447.275.73711.0512,309.2529.66460.211,451.62
free buffer requested37,3625,834,21215,515.3676.35525.39588.135.18809.1715,521.0426.84523.721,851.27
heap block compress12431,19325,055.650.252.811,024.000.024.3321,550.000.092.803,011.11
hot buffers moved to head of LRU24,8151,750,1196,952.6750.71157.60210.793.44242.736,956.1017.83157.10781.10
immediate (CR) block cleanout applications1522,788,8151,834,646.710.31251.1480,912.900.02386.791,933,850.000.11250.34227,481.82
immediate (CURRENT) block cleanout applications4,698110,4342,250.669.609.943.540.6515.322,256.923.389.91193.20
index fast full scans (full)4142,853589.130.850.26-69.410.060.40566.670.300.26-13.33
index fetch by key7,452,73268,982,313825.6015,229.346,212.04-59.211,033.659,567.38825.595,353.976,192.3115.66
index scans kdiixs1328,83821,712,7586,502.87671.971,955.29190.9845.613,011.416,502.52236.231,949.08725.08
java call heap collected bytes633,31211,644,6641,738.691,294.151,048.63-18.9787.841,615.041,738.62454.971,045.30129.75
java call heap collected count3,303185,0125,501.336.7516.66146.810.4625.665,478.262.3716.61600.84
java call heap gc count938322.220.020.00-100.000.000.01100.000.010.00-100.00
java call heap object count3,30375,9622,199.796.756.841.330.4610.542,191.302.376.82187.76
java call heap object count max3,30379,7242,313.686.757.186.370.4611.062,304.352.377.16202.11
java call heap total size11,796,48015,204,35228.8924,105.601,369.19-94.321,636.112,108.7428.898,474.481,364.84-83.89
java call heap total size max11,796,48015,204,35228.8924,105.601,369.19-94.321,636.112,108.7428.898,474.481,364.84-83.89
java call heap used size633,3125,259,600730.491,294.15473.64-63.4087.84729.47730.45454.97472.143.77
java call heap used size max633,3125,487,280766.441,294.15494.14-61.8287.84761.05766.40454.97492.578.26
java session heap live size3,096,5763,735,55220.636,327.72336.40-94.68429.48518.1020.632,224.55335.33-84.93
java session heap live size max3,096,5763,735,55220.636,327.72336.40-94.68429.48518.1020.632,224.55335.33-84.93
java session heap used size3,096,5763,735,55220.636,327.72336.40-94.68429.48518.1020.632,224.55335.33-84.93
java session heap used size max3,096,5763,735,55220.636,327.72336.40-94.68429.48518.1020.632,224.55335.33-84.93
leaf node 90-10 splits374931,232.430.080.04-50.000.010.07600.000.030.0433.33
leaf node splits518641,594.120.100.08-20.000.010.121,100.000.040.08100.00
lob reads1,88316,590781.043.851.49-61.300.262.30784.621.351.4910.37
lob writes1,11410,498842.372.280.95-58.330.151.46873.330.800.9417.50
lob writes unaligned1,11410,498842.372.280.95-58.330.151.46873.330.800.9417.50
max cf enq hold time72019,2602,575.001.471.7317.690.102.672,570.000.521.73232.69
messages received56,9371,532,7042,591.93116.35138.0218.627.90212.582,590.8940.90137.59236.41
messages sent56,9371,532,7042,591.93116.35138.0218.627.90212.582,590.8940.90137.59236.41
no buffer to keep pinned count8647,611780.901.770.69-61.020.121.06783.330.620.689.68
no work - consistent read gets7,764,138102,414,5551,219.0715,865.689,222.71-41.871,076.8414,204.201,219.065,577.699,193.4164.82
non-idle wait count203,9705,350,0122,522.94416.80481.7815.5928.29742.012,522.87146.53480.25227.75
parse count (failures)64324406.250.130.03-76.920.010.04300.000.050.03-40.00
parse count (hard)5,16863,3661,126.1210.565.71-45.930.728.791,120.833.715.6953.37
parse time cpu8817,839789.781.800.71-60.560.121.09808.330.630.7011.11
physical read IO requests59,5242,157,3513,524.34121.63194.2859.738.26299.213,522.4042.76193.66352.90
physical read bytes50,941,231,104591,819,309,0561,061.77104,096,220.5353,294,931.15-48.807,065,266.8682,081,300.421,061.7636,595,712.0053,125,611.2345.17
physical read total IO requests70,5312,450,6753,374.61144.13220.6953.129.78339.893,375.3650.67219.99334.16
physical read total bytes51,161,033,728634,655,865,3441,140.51104,545,377.7657,152,479.03-45.337,095,752.2688,022,438.521,140.4936,753,616.1856,970,903.5355.01
physical read total multi block requests49,247672,9901,266.56100.6360.60-39.786.8393.341,266.6235.3860.4170.75
physical reads cache27,9124,232,96915,065.4157.04381.19568.293.87587.0815,070.0320.05379.981,795.16
physical reads cache prefetch17,3583,198,47018,326.4935.47288.03712.042.41443.6118,307.0512.47287.122,202.49
physical reads direct3,081,29431,888,815934.926,296.492,871.67-54.39427.364,422.76934.902,213.572,862.5529.32
physical write IO requests4,4103,225,57773,042.349.01290.473,123.860.61447.3773,239.343.17289.559,034.07
physical write bytes128,516,096145,965,711,360113,477.77262,617.1313,144,607.524,905.2417,824.4720,244,448.30113,476.7292,324.7813,102,846.6214,092.12
physical write total IO requests19,4253,521,19818,027.1539.69317.09698.922.69488.3718,055.0213.95316.092,165.88
physical write total bytes319,354,880186,127,224,83258,182.25652,588.0016,761,260.542,468.4344,292.7525,814,576.2158,181.72229,421.6116,708,009.417,182.67
physical write total multi block requests251413,759164,744.220.5137.267,205.880.0357.39191,200.000.1837.1420,533.33
physical writes direct5505,603,9811,018,805.641.12504.6544,958.040.08777.23971,437.500.40503.05125,662.50
physical writes from cache7,2943,305,05945,212.0214.90297.631,897.521.01458.3945,285.155.24296.685,561.83
physical writes non checkpoint6,1337,818,534127,383.0312.53704.085,519.150.851,084.38127,474.124.41701.8415,814.74
pinned buffers inspected126926,800.000.000.02100.000.000.04100.000.000.02100.00
prefetched blocks aged out before use27119,522442,574.070.0610.7617,833.330.0016.58100.000.0210.7353,550.00
process last non-idle time7,2006,994-2.8614.710.63-95.721.000.97-3.005.170.63-87.81
queries parallelized1071,4441,249.530.220.13-40.910.010.201,900.000.080.1362.50
recursive calls2,095,01019,628,179836.904,281.061,767.57-58.71290.572,722.29836.881,505.041,761.9617.07
recursive cpu usage6,424429,4536,585.1313.1338.67194.520.8959.566,592.134.6138.55736.23
redo KB read37,20418,897,24350,693.5876.021,701.752,138.565.162,620.9250,693.0226.731,696.346,246.20
redo blocks checksummed by FG (exclusive)11,662920,9807,797.2723.8382.94248.051.62127.737,784.578.3882.67886.52
redo blocks written78,19337,839,44048,292.36159.783,407.542,032.6410.845,248.0748,313.9356.173,396.725,947.21
redo entries125,08641,851,25733,357.99255.613,768.821,374.4417.355,804.4833,355.2289.863,756.854,080.78
redo ordering marks2,806569,45120,194.055.7351.28794.940.3978.9820,151.282.0251.122,430.69
redo size for direct writes16,02431,944,136199,251.8232.742,876.668,686.382.224,430.43199,468.9211.512,867.5224,813.29
redo subscn max counts5,8121,582,59827,129.8311.88142.521,099.660.81219.5026,998.774.18142.063,298.56
redo synch long waits1772,3651,236.160.360.21-41.670.020.331,550.000.130.2161.54
redo synch time1491,9181,187.250.300.17-43.330.020.271,250.000.110.1754.55
redo synch time (usec)2,314,27033,974,2021,368.034,729.113,059.47-35.31320.984,711.991,368.001,662.553,049.7583.44
redo synch writes2,49627,8591,016.155.102.51-50.780.353.861,002.861.792.5039.66
redo wastage2,014,53646,037,9722,185.294,116.624,145.840.71279.406,385.152,185.311,447.224,132.67185.56
redo write time47015,9103,285.110.961.4348.960.072.213,057.140.341.43320.59
redo writes7,657158,3461,967.9915.6514.26-8.881.0621.961,971.705.5014.21158.36
rollback changes - undo records applied2903,6581,161.380.590.33-44.070.040.511,175.000.210.3357.14
rollbacks only - consistent read gets526,11711,663.460.110.55400.000.010.858,400.000.040.551,275.00
rows fetched via callback7,373,37764,520,237775.0415,067.185,810.22-61.441,022.658,948.52775.035,296.975,791.769.34
session pga memory25,993,90411,983,984-53.9053,117.431,079.19-97.973,605.211,662.10-53.9018,673.781,075.76-94.24
session pga memory max41,870,67220,569,200-50.8785,560.921,852.31-97.845,807.232,852.81-50.8730,079.511,846.43-93.86
session uga memory68,830,873,24869,998,199,1921.70140,652,936.836,303,527.36-95.529,546,461.229,708,272.661.6949,447,466.416,283,500.83-87.29
session uga memory max3,049,409,576102,914,165,7923,274.896,231,337.669,267,699.2748.73422,936.2314,273,492.653,274.862,190,667.809,238,255.46321.71
shared hash latch upgrades - no wait18,798493,9242,527.5338.4144.4815.802.6168.502,524.5213.5044.34228.44
shared hash latch upgrades - wait122,30019,066.670.020.21950.000.000.32100.000.010.212,000.00
sorts (memory)14,929100,445572.8230.519.05-70.342.0713.93572.9510.729.02-15.86
sorts (rows)31,226,398849,406,9402,620.1663,809.8076,491.3919.874,330.93117,806.952,620.1322,432.7676,248.38239.90
sql area evicted24214,9026,057.850.491.34173.470.032.076,800.000.171.34688.24
sql area purged3954,014916.200.810.36-55.560.050.561,020.000.280.3628.57
summed dirty queue length841,226,0701,459,507.140.17110.4164,847.060.01170.051,700,400.000.06110.06183,333.33
switch current to new buffer4,211964,33622,800.408.6086.84909.770.58133.7522,960.343.0386.572,757.10
table fetch by rowid9,774,73195,985,236881.9719,974.248,643.73-56.731,355.7013,312.50881.977,022.088,616.2722.70
table fetch continued row2,07310,163390.264.240.92-78.300.291.41386.211.490.91-38.93
table scan blocks gotten4,922,23941,394,571740.9710,058.383,727.69-62.94682.695,741.14740.963,536.093,715.855.08
table scan rows gotten305,619,4193,319,880,309986.28624,520.17298,964.21-52.1342,387.72460,444.75986.27219,554.18298,014.3935.74
table scans (direct read)2769,150256,011.110.066.2310,283.330.009.59100.000.026.2130,950.00
table scans (long tables)4,801153,7433,102.319.8113.8441.080.6721.323,082.093.4513.80300.00
table scans (rowid ranges)4,578151,1823,202.369.3513.6145.560.6320.973,228.573.2913.57312.46
table scans (short tables)14,328188,9161,218.5129.2817.01-41.911.9926.201,216.5810.2916.9664.82
total cf enq hold time1,29046,9303,537.982.644.2360.230.186.513,516.670.934.21352.69
total number of cf enq holders79835,6484,367.171.633.2196.930.114.944,390.910.573.20461.40
total number of times SMON posted459812,080.000.090.090.000.010.141,300.000.030.09200.00
transaction rollbacks179095,247.060.030.08166.670.000.13100.000.010.08700.00
undo change vector size13,737,4967,906,237,17257,452.2428,071.98711,978.062,436.261,905.311,096,541.1557,451.859,868.89709,716.087,091.45
write clones created in background4645,1131,001.940.950.46-51.580.060.711,083.330.330.4639.39


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
6.7783.941,139.880.069.1715,183.336.6868.95932.190.0424.6461,500.000.027.1635,700.000.0010.40100.000.012.5825,700.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
9.78339.883,375.261.48149.109,974.326.77149.122,102.662.69488.8918,074.350.57341.5859,826.320.0493.78234,350.001.1327.442,328.32


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
6.7783.941,139.886.7473.67993.030.004.63100.000.0424.6261,450.000.0213.9069,400.000.005.42100.000.012.5625,500.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
9.78339.893,375.368.26230.782,693.950.0069.55100.002.69488.2318,049.810.61418.5468,513.110.0029.82100.001.1226.262,244.64


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
PRD_DATA 7.9096.941,127.090.09276.15306,733.3356,940698,9570.290.1654.5131.236811,991,10631,1156.677.527.99373.09365.10
PRD_TEMP 0.0854.0567,462.500.1864.9735,994.44600389,7260.020.141.4229.111,278468,46317710,1090.060.050.26119.02118.76
TEMP 0.0069.55100.000.0029.82100.000501,4650.000.000.004.261215,006000.000.000.0099.3799.37
PRD_INDX 0.1774.7143,847.060.1019.6519,550.001,220538,6904.270.042.041.41720141,71091,7572.222.260.2794.3794.10
UNDOTBS1 0.000.02100.000.0654.7291,100.0051610.000.061.001.00462394,51915810.000.000.0654.7454.67
SYSTEM 0.092.632,822.220.070.951,257.1464518,9946.590.422.722.205176,823123,2480.830.060.163.583.42
SYSAUX 0.021.296,350.000.100.98880.001119,3304.860.121.001.137477,049000.000.000.122.272.15


Back to IO Stats
Back to Top

Top File Comparison by IO

  Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms) IOs per second
TablespaceFilename1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndDiff
TEMP/u01/app/oracle/oradata/PROD/temp01.dbf 0.0033.17100.000.0013.73100.000239,1420.000.000.004.52098,976000.000.000.0046.8946.89
TEMP/u01/app/oracle/oradata/PROD/temp03.dbf 0.000.08100.000.000.07100.0005480.000.000.0014.690536000.000.000.000.150.15
TEMP/u01/app/oracle/oradata/PROD/temp04.dbf 0.000.05100.000.000.05100.0003580.000.000.0014.530346000.000.000.000.100.10


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
PRD_TEMP/u01/app/oracle/oradata/PROD/DB_TEMP02.dbf 0.000.260.260.000.14187199,8250.0327.711.5728.37410239,5060.0633.22275,5590.000.01
TEMP/u01/app/oracle/oradata/PROD/temp01.dbf 0.000.000.000.000.000239,1420.0033.170.004.52098,9760.0013.73000.000.00
TEMP/u01/app/oracle/oradata/PROD/temp03.dbf 0.000.000.000.000.0005480.000.080.0014.6905360.000.07000.000.00
TEMP/u01/app/oracle/oradata/PROD/temp04.dbf 0.000.000.000.000.0003580.000.050.0014.5303460.000.05000.000.00
TEMP/u01/app/oracle/oradata/PROD/temp05.dbf 0.000.000.000.000.00064,3480.008.920.002.97122,0590.003.06000.000.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
PRD_DATA/u01/app/oracle/oradata/PROD/DB_DATA04.dbf 0.000.030.0303700.000.776,33926,7240.883.710.380.1952.7642.34303,85101
PRD_DATA/u01/app/oracle/oradata/PROD/DB_DATA03.dbf 0.000.020.0203640.000.7133,009378,6564.5852.520.300.1654.7738.03618879,8790122
PRD_INDX/u01/app/oracle/oradata/PROD/DB_INDX01.dbf 0.000.020.0205460.000.32655264,1770.0936.643.830.041.841.4044169,951010
PRD_DATA/u01/app/oracle/oradata/PROD/DB_DATA02.dbf 0.000.010.0101660.000.786,520233,6150.9032.400.290.1545.7017.86141,026,1480142


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)
B109178884197165,888197   
E101082324,77341,784165,88841,784   
           
B20174,039156,453165,888165,888418,036   
E2016884165,319165,888165,888501,147   


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.0084.62-15.385,114,38816,513,332222.882,387174,879068,109,764100.00031,787


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)
B13,0722,608379.20.00.00.00.0314,570
E13,0722,589405.40.00.00.00.0314,570
         
B23,0722,503470.00.00.00.00.0314,570
E23,0722,511447.70.00.00.00.0314,570


Back to Advisory Statistics
Back to Top

Wait Stats

Back to Top

Buffer Wait Statistics

 Wait Time % of DB time Total Wait Time (s) # Waits Avg Wait Time (ms)
Class1st2ndDiff1st2nd1st2nd1st2nd%Diff
data block0.000.000.000.0412.581736,9050.000.02100.00
file header block0.000.000.000.010.49279,3110.000.000.00
segment header0.000.00-0.000.010.00100.100.00-100.00
undo block0.000.000.000.000.0004280.000.000.00
undo header0.000.000.000.000.0011530.000.000.00


Back to Wait Stats
Back to Top

Enqueue Activity

 Wait Time % of DB time Wait Time Requests Successful Gets Failed Gets Waits Avg Wait Time (ms)
Enqueue Type (Request Reason)1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
KO-Multiple Object Checkpoint (fast object checkpo0.000.790.7908802,00702,0070002230.00393.95
CR-Reuse Block Range (block range reuse ckpt)0.140.400.271454,153104,7684,153104,7650045210,5101.504.27
CF-Controlfile Transaction0.120.360.241404,00074,9804,00074,977041439,9464.134.00
RO-Multiple Object Reuse (fast object reuse)0.110.200.091223,83447,8083,83447,808004165,1831.274.26


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
1st1.4912,0509121018/28.20/00/0/0/0/0/0
2nd497.28233,7929351418.5/30.60/00/0/0/0/0/0



Back to Top

Latch Statistics

Back to Top

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Wait Time (cs)
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndDiff
call allocation52.1219.86-32.2611,200257,5521,51427,1311,27125,2732832,22713,55482,93069,376
active service list9.3937.3928.0026,050145,4531,09024,8411,04221,099514,1931,372252,989251,617
space background task latch2.9514.0611.127,93153,475494,375372,968161,577862256,855255,993
cache buffers chains22.1011.79-10.3122,899,550503,699,32917,3184,996,41717,2214,993,1801201,3223,79522,93619,141
Real-time plan statistics latch9.3914.204.8137,80661,9326398,4635897,102511,592850109,276108,426
shared pool5.342.11-3.23501,1004,903,16913,369188,23313,340188,0092923745,244273,901228,657
row cache objects2.030.87-1.151,021,88910,626,3572,211243,8402,200243,74411982144,6834,469
interrupt manipulation1.100.03-1.0811,142157,9176709,9156649,91263183137-46
object queue header operation0.371.421.05532,35832,950,1591156,2071136,0532159810,83810,830
archive process latch0.000.740.745863,56508704083013,79813,798
enqueues0.550.13-0.42165,2861,138,03873326,38573026,37031596928832
redo writing0.550.20-0.3684,3031,876,59151610,56151310,53932238464426
messages0.550.21-0.34217,5333,604,7772,59049,8562,58749,83232426597571
parallel query stats0.000.320.322,46934,8544385,4114385,37503606,7556,755
process queue reference0.000.190.191,048,289103,454,88765022,96565022,94602103,7563,756
session state list latch0.180.340.154,44652,31753811,11653711,0821384461457
sort extent pool0.000.150.1543141,820014001230170435435
active checkpoint queue latch0.550.40-0.1559,8611,442,9081,28519,8311,28219,786345106720614
redo allocation0.000.140.1433,858711,221785,433785,41701601,0951,095
cache buffers lru chain0.000.070.0739,0766,448,84173,58573,577080459459
enqueue hash chains0.000.060.06246,8832,460,3351468,0311468,024070186186
process queue0.000.040.0417,280234,2583423,6853423,6800503,3153,315
SQL memory manager workarea list latch0.000.040.04172,517332,2642642,8242642,8200402222
post/wait queue0.000.040.042,78745,285345341040217217
In memory undo latch0.000.030.0313,027262,594043040030130130
dml lock allocation0.000.030.031,39638,277211,607211,604030159159
error message lists0.000.030.033,58550,3613585,4203585,417030449449
parallel query alloc buffer0.000.030.0328,450375,4762943,4492943,446030322322
qmn task queue latch0.000.020.021,9321,5664691764691740202020
resmgr:free threads list0.000.020.024,31250,05853210,95053210,9480203333
checkpoint queue latch0.000.010.012,704,53450,281,020831,878831,8770101616
dummy allocation0.000.010.014,31450,0603057,6423057,6410101313
object queue header heap0.000.010.016,583103,09104030105656
simulator lru latch0.000.010.015,2962,747,243021002090101010


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
space background task latch862256,855255,9937,93153,475494,375372,968161,5772.9514.0611.12
active service list1,372252,989251,61726,050145,4531,09024,8411,04221,099514,1939.3937.3928.00
shared pool45,244273,901228,657501,1004,903,16913,369188,23313,340188,009292375.342.11-3.23
Real-time plan statistics latch850109,276108,42637,80661,9326398,4635897,102511,5929.3914.204.81
call allocation13,55482,93069,37611,200257,5521,51427,1311,27125,2732832,22752.1219.86-32.26
cache buffers chains3,79522,93619,14122,899,550503,699,32917,3184,996,41717,2214,993,1801201,32222.1011.79-10.31
archive process latch013,79813,7985863,565087040830.000.740.74
object queue header operation810,83810,830532,35832,950,1591156,2071136,05321590.371.421.05
parallel query stats06,7556,7552,46934,8544385,4114385,3750360.000.320.32
row cache objects2144,6834,4691,021,88910,626,3572,211243,8402,200243,74411982.030.87-1.15
process queue reference03,7563,7561,048,289103,454,88765022,96565022,9460210.000.190.19
process queue03,3153,31517,280234,2583423,6853423,680050.000.040.04
redo allocation01,0951,09533,858711,221785,433785,4170160.000.140.14
enqueues96928832165,2861,138,03873326,38573026,3703150.550.13-0.42
active checkpoint queue latch10672061459,8611,442,9081,28519,8311,28219,7863450.550.40-0.15
messages26597571217,5333,604,7772,59049,8562,58749,8323240.550.21-0.34
cache buffers lru chain045945939,0766,448,84173,58573,577080.000.070.07
session state list latch44614574,44652,31753811,11653711,0821380.180.340.15
error message lists04494493,58550,3613585,4203585,417030.000.030.03
sort extent pool043543543141,820014001230170.000.150.15
redo writing3846442684,3031,876,59151610,56151310,5393220.550.20-0.36
parallel query alloc buffer032232228,450375,4762943,4492943,446030.000.030.03
post/wait queue02172172,78745,285345341040.000.040.04
enqueue hash chains0186186246,8832,460,3351468,0311468,024070.000.060.06
dml lock allocation01591591,39638,277211,607211,604030.000.030.03
In memory undo latch013013013,027262,594043040030.000.030.03
object queue header heap056566,583103,0910403010.000.010.01
interrupt manipulation183137-4611,142157,9176709,9156649,912631.100.03-1.08
resmgr:free threads list033334,31250,05853210,95053210,948020.000.020.02
SQL memory manager workarea list latch02222172,517332,2642642,8242642,820040.000.040.04
qmn task queue latch020201,9321,566469176469174020.000.020.02
checkpoint queue latch016162,704,53450,281,020831,878831,877010.000.010.01
dummy allocation013134,31450,0603057,6423057,641010.000.010.01
simulator lru latch010105,2962,747,24302100209010.000.010.01


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
PRD_SCMPRD_DATAANONTAB TABLE15.4115.410.070.07-15.343,138,848185,552-94.0915.680.08-15.60
PRD_SCMPRD_DATAANONTAB TABLE36.8152.2224.6224.69-12.197,499,10465,764,144776.9637.4728.15-9.32
PRD_SCMPRD_DATAANONTAB TABLE  9.1733.869.17 24,484,800  10.4810.48
PRD_SCMPRD_INDXPK_COLUMN INDEX25.1877.4016.8050.66-8.385,130,27244,869,600774.6025.6319.21-6.43
PRD_SCMPRD_DATAANONTAB TABLE  7.1657.827.16 19,124,176  8.198.19
PRD_SCMPRD_DATAANONTAB TABLE6.8584.25  -6.851,395,456  6.97 -6.97
SYSSYSTEMI_OBJ1 INDEX8.7593.005.8163.63-2.941,783,50415,524,976770.488.916.65-2.27


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
PRD_SCMPRD_DATAANONTAB TABLE99.2799.270.370.37-98.903,086,547134,258-95.6599.700.52-99.18
PRD_SCMPRD_DATAANONTAB TABLE  13.5213.9013.52 4,885,234  19.0819.08
PRD_SCMPRD_DATAANONTAB TABLE  7.6721.577.67 2,771,975  10.8310.83
PRD_SCMPRD_DATAANONTAB TABLE  6.8428.416.84 2,470,497  9.659.65
PRD_SCMPRD_DATAANONTAB TABLE  6.1234.536.12 2,211,514  8.648.64
PRD_SCMPRD_DATAANONTAB TABLE  5.5540.085.55 2,003,830  7.837.83
PRD_SCMPRD_DATAANONTAB TABLE0.1699.43  -0.165,061  0.16 -0.16
SYSSYSTEMOBJ$ TABLE0.0499.47  -0.041,178  0.04 -0.04
PRD_SCMPRD_DATASVR1_187A INDEX0.0399.50  -0.03815  0.03 -0.03
PRD_SCMPRD_DATAANONTAB TABLE0.0299.52  -0.02755  0.02 -0.02


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
PRD_SCMPRD_DATAANONTAB TABLE90.8890.881.021.02-89.8654,09621,941-59.4497.292.03-95.26
PRD_SCMPRD_DATAANONTAB TABLE  12.8113.8312.81 276,374  25.5625.56
PRD_SCMPRD_DATAANONTAB TABLE  3.9217.753.92 84,629  7.837.83
PRD_SCMPRD_INDXSVR1_35WG INDEX  3.4021.153.40 73,250  6.786.78
** MISSING **PRD_INDX** MISSING: 3983472/3983472** MISSING **UNDEFINED  3.4024.543.40 73,244  6.776.77
** MISSING **PRD_INDX** MISSING: 3986204/3986204** MISSING **UNDEFINED  3.2127.753.21 69,208  6.406.40
PRD_SCMPRD_DATAANONTAB TABLE0.6291.50  -0.62367  0.66 -0.66
PRD_SCMPRD_DATAANONTAB TABLE0.6092.10  -0.60356  0.64 -0.64
PRD_SCMPRD_DATAANONTAB TABLE0.4292.52  -0.42252  0.45 -0.45
PRD_SCMPRD_DATASVR1_187A INDEX0.1592.67  -0.1587  0.16 -0.16


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
PRD_SCMPRD_DATAANONTAB TABLE90.8890.881.021.02-89.8654,09621,941-59.4497.292.03-95.26
PRD_SCMPRD_DATAANONTAB TABLE  12.8113.8312.81 276,374  25.5625.56
PRD_SCMPRD_DATAANONTAB TABLE  3.9217.753.92 84,629  7.837.83
PRD_SCMPRD_INDXSVR1_35WG INDEX  3.4021.153.40 73,250  6.786.78
** MISSING **PRD_INDX** MISSING: 3983472/3983472** MISSING **UNDEFINED  3.4024.543.40 73,244  6.776.77
** MISSING **PRD_INDX** MISSING: 3986204/3986204** MISSING **UNDEFINED  3.2127.753.21 69,208  6.406.40
PRD_SCMPRD_DATAANONTAB TABLE0.6291.50  -0.62367  0.66 -0.66
PRD_SCMPRD_DATAANONTAB TABLE0.6092.10  -0.60356  0.64 -0.64
PRD_SCMPRD_DATAANONTAB TABLE0.4292.52  -0.42252  0.45 -0.45
PRD_SCMPRD_DATASVR1_187A INDEX0.1592.67  -0.1587  0.16 -0.16


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$ TABLE0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_COL1 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMI_FILE#_BLOCK# INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMI_OBJ# INDEX0.000.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ1 INDEX0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMSEG$ TABLE0.000.000.000.000.00000.000.000.000.00
SYSSYSTEMTAB$ 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
PRD_SCMPRD_DATAANONTAB TABLE100.00100.000.360.36-99.643,081,294114,122-96.30100.000.50-99.50
PRD_SCMPRD_DATAANONTAB TABLE  14.5714.9314.57 4,647,373  20.3620.36
PRD_SCMPRD_DATAANONTAB TABLE  8.6823.618.68 2,766,482  12.1212.12
PRD_SCMPRD_DATAANONTAB TABLE  7.7431.357.74 2,467,988  10.8110.81
PRD_SCMPRD_DATAANONTAB TABLE  6.9338.286.93 2,210,004  9.689.68
PRD_SCMPRD_DATAANONTAB TABLE  6.2844.566.28 2,003,712  8.788.78
SYSSYSTEMFET$ TABLE0.00100.00  0.000 100.000.00 0.00
SYSSYSTEMI_OBJ# INDEX0.00100.00  0.000 100.000.00 0.00
SYSSYSTEMSEG$ TABLE0.00100.000.0044.560.00000.000.000.000.00
SYSSYSTEMTAB$ TABLE0.00100.000.0044.560.00000.000.000.000.00


Back to Segment Statistics
Back to Top

Top Segments Comparison by Physical Writes

     % of Total Physical Writes Physical Writes % of Captured Physical Writes
OwnerTablespaceObject NameSubobject NameType1st1st Total2nd2nd TotalDiff1st2nd%Diff1st2ndDiff
PRD_SCMPRD_DATAANONTAB TABLE  16.8516.8516.85 1,500,880  38.1538.15
PRD_SCMPRD_DATAANONTAB TABLE  12.5129.3612.51 1,114,466  28.3328.33
SYSSYSTEMSEG$ TABLE1.381.380.0229.37-1.361081,3861,183.3311.230.04-11.19
** MISSING **PRD_TEMP** MISSING: 3771736/3771736** MISSING **UNDEFINED0.682.05  -0.6853  5.51 -5.51
** MISSING **PRD_TEMP** MISSING: 3771964/3771964** MISSING **UNDEFINED0.652.70  -0.6551  5.30 -5.30
PRD_SCMPRD_DATAANONTAB TABLE0.653.35  -0.6551  5.30 -5.30
** MISSING **PRD_TEMP** MISSING: 3771907/3771907** MISSING **UNDEFINED0.643.99  -0.6450  5.20 -5.20
PRD_SCMPRD_DATAANONTAB TABLE  0.3729.740.37 33,050  0.840.84
PRD_SCMPRD_DATAANONTAB TABLE  0.3730.110.37 33,045  0.840.84
PRD_SCMPRD_DATAANONTAB TABLE  0.3730.480.37 33,039  0.840.84


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
PRD_SCMPRD_DATAANONTAB TABLE  33.5333.5333.53 1,081,604  50.9150.91
PRD_SCMPRD_DATAANONTAB TABLE  26.6960.2226.69 860,892  40.5240.52
SYSSYSTEMSEG$ TABLE2.432.430.0460.26-2.391071,139964.4915.620.05-15.57
PRD_SCMPRD_DATAANONTAB TABLE1.163.58  -1.1651  7.45 -7.45
PRD_SCMPRD_DATAANONTAB TABLE0.884.47  -0.8839  5.69 -5.69
SYSSYSTEMTAB$ TABLE0.845.310.0160.27-0.8337298705.415.400.01-5.39
PRD_SCMPRD_DATAANONTAB TABLE0.635.94  -0.6328  4.09 -4.09
PRD_SCMPRD_INDXSVR1_35WG INDEX  0.2960.560.29 9,344  0.440.44
PRD_SCMPRD_INDXSVR1_35WG INDEX  0.2960.850.29 9,342  0.440.44
** MISSING **PRD_INDX** MISSING: 3982102/3982102** MISSING **UNDEFINED  0.2961.140.29 9,341  0.440.44


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
** MISSING **PRD_TEMP** MISSING: 3771679/3771679** MISSING **UNDEFINED6.556.55  -6.5536  11.25 -11.25
** MISSING **PRD_TEMP** MISSING: 3771793/3771793** MISSING **UNDEFINED6.5513.09  -6.5536  11.25 -11.25
** MISSING **PRD_TEMP** MISSING: 3771850/3771850** MISSING **UNDEFINED6.5519.64  -6.5536  11.25 -11.25
** MISSING **PRD_TEMP** MISSING: 3771907/3771907** MISSING **UNDEFINED6.5526.18  -6.5536  11.25 -11.25
** MISSING **PRD_TEMP** MISSING: 3771964/3771964** MISSING **UNDEFINED6.5532.73  -6.5536  11.25 -11.25
** MISSING **PRD_TEMP** MISSING: 3983176/3983176** MISSING **UNDEFINED  0.590.590.59 32,789  2.572.57
** MISSING **PRD_TEMP** MISSING: 3984542/3984542** MISSING **UNDEFINED  0.591.170.59 32,789  2.572.57
** MISSING **PRD_TEMP** MISSING: 3985908/3985908** MISSING **UNDEFINED  0.591.760.59 32,789  2.572.57
** MISSING **PRD_TEMP** MISSING: 3987274/3987274** MISSING **UNDEFINED  0.592.340.59 32,789  2.572.57
** MISSING **PRD_TEMP** MISSING: 3981810/3981810** MISSING **UNDEFINED  0.582.930.58 32,777  2.572.57


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
PRD_SCMPRD_DATAANONTAB TABLE17.9317.93  -17.93935  37.69 -37.69
PRD_SCMPRD_DATAANONTAB TABLE17.9135.84  -17.91934  37.65 -37.65
PRD_SCMPRD_DATAANONTAB TABLE  2.792.792.79 4,370  10.9210.92
PRD_SCMPRD_DATAANONTAB TABLE  1.344.141.34 2,106  5.265.26
PRD_SCMPRD_DATAANONTAB TABLE  1.195.331.19 1,871  4.674.67
PRD_SCMPRD_DATAANONTAB TABLE  1.106.431.10 1,728  4.324.32
SYSSYSTEMI_OBJ1 INDEX1.3837.220.406.83-0.9872626769.442.901.56-1.34
** MISSING **PRD_TEMP** MISSING: 3771679/3771679** MISSING **UNDEFINED0.9038.12  -0.9047  1.89 -1.89
** MISSING **PRD_TEMP** MISSING: 3771793/3771793** MISSING **UNDEFINED0.9039.02  -0.9047  1.89 -1.89
PRD_SCMPRD_DATAg TABLE  0.887.710.88 1,379  3.443.44


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
PRD_SCMPRD_DATAANONTAB TABLE  23.2023.2023.20 18,746,240  49.0849.08
PRD_SCMPRD_DATAANONTAB TABLE  23.0146.2123.01 18,592,672  48.6848.68
SYSSYSTEMTAB$ TABLE6.756.750.1546.36-6.6015,568120,576674.5121.850.32-21.53
SYSSYSTEMI_COL1 INDEX5.4012.150.1346.49-5.2712,464104,320736.9717.490.27-17.22
SYSSYSTEMI_COL2 INDEX5.3317.480.1346.62-5.2012,288101,600726.8217.250.27-16.98
SYSSYSTEMI_COL3 INDEX5.2222.690.1346.74-5.0912,032102,304750.2716.890.27-16.62
SYSSYSTEMCDEF$ TABLE1.4824.18  -1.483,424  4.81 -4.81


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
SYSSYSTEMI_FILE#_BLOCK# INDEX100.0099.57-0.43146446,300.00100.00100.00100.00100.000.00


Back to Segment Statistics
Back to Top

Top Segments by ITL Waits

     % of Total ITL Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd%Diff1st1st Total2nd2nd TotalDiff
SYSSYSTEMSEG$ TABLE100.0098.99-1.01159159,000.00100.00100.00100.00100.000.00


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
SYSSYSTEMI_FILE#_BLOCK# INDEX20.8320.8311.1911.19-9.6451,26525,200.0050.0038.33-11.67
SYSSYSTEMSEG$ TABLE20.8341.6717.1728.36-3.6751,94038,700.0050.0058.798.79
PRD_SCMPRD_DATAANONTAB TABLE  0.1028.460.10 11  0.330.33
PRD_SCMPRD_DATAANONTAB TABLE  0.1028.560.10 11  0.330.33
PRD_SCMPRD_DATAANONTAB TABLE  0.0928.650.09 10  0.300.30
SYSSYSTEMTAB$ TABLE0.0041.670.0228.660.0202100.000.000.060.06


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.270.01-96.300.020.020.001301300.000.00000.000.004411
dc_constraints3.431.19-65.310.231.83695.651,67813,18733.0233.00000.000.001,66213,0574035
dc_global_oids1.220.12-90.160.080.19137.505981,3681.170.00000.000.0000320300
dc_histogram_data49.3713.03-73.613.3520.06498.8124,158144,6430.480.07000.000.00181,46810,0773,995
dc_histogram_defs126.4842.84-66.138.5865.98669.0061,896475,7497.5023.31000.000.0099733,56011,9069,367
dc_object_grants0.070.00-100.000.000.000.0032240.000.00000.000.000028831
dc_objects156.4242.73-72.6810.6265.81519.6876,548474,5292.594.93000.000.002,14723,51737,80959,646
dc_profiles0.810.14-82.720.060.21250.003981,5350.000.00000.000.000011
dc_rollback_segments2.690.14-94.800.180.2222.221,3171,5790.000.00000.000.00001717
dc_segments54.8637.93-30.863.7258.421,470.4326,847421,2061.672.57000.000.002,40948,9643,7623,877
dc_sequences0.050.02-60.000.000.03100.00261870.001.07000.000.00261873115
dc_table_scns0.640.39-39.060.040.601,400.003134,330100.00100.00000.000.000000
dc_tablespace_quotas7.5826.48249.340.5140.787,896.083,708294,0600.000.00000.000.000076
dc_tablespaces111.7655.43-50.407.5985.371,024.7754,691615,5060.000.00000.000.00001313
dc_users197.21105.13-46.6913.39161.911,109.1996,5101,167,3860.210.23000.000.00002,5164,868
global database name11.120.62-94.420.750.9526.675,4406,8300.000.00000.000.000011
outstanding_alerts0.250.01-96.000.020.020.001201200.000.00000.000.00001010
sch_lj_oids0.020.00-100.000.000.000.00880.000.00000.000.0000144



Back to Top

Library Cache Activity

 Get Requests per Sec (DB Time) Get Requests per Sec (Elapsed Time) Get Requests Pct Miss Pin Requests Pct Miss Reloads Invalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
ACCOUNT_STATUS1.540.27-82.470.100.42320.007563,0300.000.0000  0000
BODY6.792.87-57.730.464.43863.043,32131,9050.000.005,23239,7470.080.004000
CLUSTER0.320.00-100.000.020.00-100.0015740.0025.0015740.0025.000000
DBLINK1.550.27-82.580.110.42281.827603,0340.000.0000  0000
DIRECTORY14.935.48-63.301.018.44735.647,30860,8280.000.007,30860,8280.000.000000
EDITION1.200.18-85.000.080.28250.005861,9980.000.009803,5290.000.000000
INDEX3.991.62-59.400.272.49822.221,95417,9581.130.591,96117,81019.2220.892202,09200
JAVA DATA0.040.00-100.000.000.000.0021240.000.0000  0000
OBJECT ID1.010.52-48.510.070.801,042.864925,768100.00100.0000  0000
SCHEMA3.581.83-48.880.242.821,075.001,75420,3050.000.0000  0000
SQL AREA75.0338.05-49.295.0958.611,051.4736,718422,5653.994.18137,9741,848,4866.635.472,62022,0292,27330,813
SQL AREA BUILD7.603.20-57.890.524.93848.083,72035,54740.5942.8200  0000
SQL AREA STATS6.183.29-46.760.425.061,104.763,02336,48149.1243.343,02336,48149.1243.340000
TABLE/PROCEDURE297.8741.85-85.9520.2264.45218.74145,768464,7260.602.45184,498896,2641.593.655373,71200
TRIGGER18.2010.11-44.451.2415.571,155.658,907112,2380.000.008,907112,2380.000.000000



Back to Top

Memory Statistics

Back to Top

Process Memory Summary

  1st 2nd % Diff of
CategorySummaryBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
FreeableAlloc (KB)183,552.00192,192.004.71122,240.00101,632.00-16.86-33.40-47.12
 Used (KB)0.000.000.000.000.000.000.000.00
 Avg Alloc (KB)8,343.275,652.71-32.253,134.362,258.49-27.94-62.43-60.05
 Std Dev Alloc (KB)17,194.3614,209.13-17.367,272.975,343.74-26.53-57.70-62.39
 Max Alloc (KB)52,160.0031,424.000.0032,896.0031,424.00-4.47-36.93-39.75
 Hist Max Alloc (KB)        
 Num Procs22.0034.0054.5539.0045.0015.3877.2732.35
 Num Alloc22.0034.0054.5539.0045.0015.3877.2732.35
JAVAAlloc (KB) 2,418.01 7,362.07    
 Used (KB) 2,410.02 7,340.33    
 Avg Alloc (KB) 2,418.01 3,681.04    
 Std Dev Alloc (KB) 0.00 1,786.19   100.00
 Max Alloc (KB)   4,944.06    
 Hist Max Alloc (KB) 2,859.59 4,944.06    
 Num Procs 1.00 2.00    
 Num Alloc 1.00 2.00    
OtherAlloc (KB)200,607.67215,877.027.61345,392.82351,530.221.7872.1762.84
 Used (KB)        
 Avg Alloc (KB)4,559.273,722.02-18.364,485.624,449.75-0.80-1.6219.55
 Std Dev Alloc (KB)7,468.566,658.00-10.857,441.307,446.460.07-0.3611.84
 Max Alloc (KB)27,814.5328,902.530.0028,902.5328,902.530.003.913.91
 Hist Max Alloc (KB)41,866.9741,866.970.0044,798.1744,798.170.007.007.00
 Num Procs44.0058.0031.8277.0079.002.6075.0036.21
 Num Alloc44.0058.0031.8277.0079.002.6075.0036.21
PL/SQLAlloc (KB)3,529.063,958.0312.165,523.054,658.27-15.6656.5017.69
 Used (KB)853.931,185.2438.801,709.851,077.08-37.01100.23-9.13
 Avg Alloc (KB)84.0370.68-15.8873.6460.50-17.85-12.36-14.41
 Std Dev Alloc (KB)389.96344.28-11.71311.07291.97-6.14-20.23-15.19
 Max Alloc (KB)2,520.482,520.480.002,520.482,520.480.000.000.00
 Hist Max Alloc (KB)2,836.422,836.420.002,836.422,836.420.000.000.00
 Num Procs42.0056.0033.3375.0077.002.6778.5737.50
 Num Alloc42.0045.007.1463.0063.000.0050.0040.00
SQLAlloc (KB)617.45696.0212.72793.29707.06-10.8728.481.59
 Used (KB)100.5777.90-22.54140.7894.38-32.9639.9821.16
 Avg Alloc (KB)24.7018.32-25.8413.6811.78-13.84-44.62-35.66
 Std Dev Alloc (KB)49.7743.53-12.5435.0432.66-6.79-29.60-24.97
 Max Alloc (KB)241.36247.360.00249.43247.36-0.833.342.49
 Hist Max Alloc (KB)121,546.59121,546.590.00121,546.59256,978.51111.420.00111.42
 Num Procs25.0038.0052.0058.0060.003.45132.0057.89
 Num Alloc20.0020.000.0036.0035.00-2.7880.0075.00


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 Buffers2,899,968.002,899,968.000.002,818,048.002,818,048.000.00-2.82-2.82
Fixed Size2,191.022,191.020.002,191.022,191.020.000.000.00
Redo Buffers9,500.009,500.000.009,500.009,500.000.000.000.00
Variable Size5,439,488.985,439,488.980.005,521,408.985,521,408.980.001.511.51


Back to Memory Statistics
Back to Top

SGA Breakdown Difference

  1st 2nd %Diff of
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%DiffBegin ValuesEnd Values
java poolJOXLE24,389,56824,389,5680.0024,389,56824,389,5680.000.000.00
java poolfree memory75,310,08075,310,0800.0075,310,08075,310,0800.000.000.00
large poolPX msg pool8,192,0008,192,0000.008,192,0008,192,0000.000.000.00
large poolfree memory411,238,400411,238,4000.00411,238,400411,238,4000.000.000.00
shared poolKGLH0916,743,000941,098,6882.66855,058,336838,835,832-1.90-6.73-10.87
shared poolKGLHD551,854,440555,264,3840.62589,842,664591,155,3280.226.886.46
shared poolKQR L PO   64,799,44866,273,6562.28  
shared poolSQLA1,463,850,3041,604,568,3449.611,997,780,3281,993,203,752-0.2336.4724.22
shared poolfree memory1,503,006,3121,328,160,208-11.631,075,999,3681,093,926,7281.67-28.41-17.64
shared poolkglsim object batch66,248,28066,248,2800.0066,248,28066,248,2800.000.000.00
streams poolKGH: NO ACCESS16,760,86416,760,8640.0016,760,86416,760,8640.000.000.00
streams poolfree memory16,616,44016,616,4400.0016,605,01616,605,0160.00-0.07-0.07
 buffer_cache2,432,696,3202,432,696,3200.002,348,810,2402,348,810,2400.00-3.45-3.45
 fixed_sga2,243,6082,243,6080.002,243,6082,243,6080.000.000.00
 log_buffer9,728,0009,728,0000.009,728,0009,728,0000.000.000.00
 shared_io_pool536,870,912536,870,9120.00536,870,912536,870,9120.000.000.00


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams by CPU Time

 CPU Time (sec) User I/O Time (sec) System I/O Time (sec)
Session Type1st2nd%Diff1st2nd%Diff1st2nd%Diff
QMON Coordinator0.000.00100.000.000.000.000.000.000.00
QMON Slaves0.000.00100.000.000.00100.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.000.000.000.000.000.00100.000.000.00100.00
QMON Coordinator0.000.000.000.000.000.000.000.000.00100.00


Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Evaluations

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set by Elapsed Time

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total Connections Avg Active Connections Avg Total Shared Servers Avg Active Shared Servers Avg Total Dispatchers Avg Active Dispatchers
1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff1st2ndDiff%Diff
0000.000000.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
7,2097,209-0.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.000.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

Back to Top

init.ora Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
__db_cache_size 2432696320 2348810240
__java_pool_size 100663296  
__large_pool_size 419430400  
__oracle_base /d01/oracle  
__pga_aggregate_target 3221225472  
__sga_target 8589934592  
__shared_io_pool_size 536870912  
__shared_pool_size 5033164800 5117050880
__streams_pool_size 16777216  
audit_file_dest /u01/app/oracle/admin/PROD/adump  
audit_trail DB  
compatible 11.2.0.0.0  
control_files /u01/app/oracle/oradata/PROD  
db_block_size 16384  
db_cache_size 2147483648  
db_domain    
db_name PROD  
diagnostic_dest /d01/oracle  
dispatchers (PROTOCOL=TCP) (SERVICE=PRODXD  
large_pool_size 419430400  
local_listener LISTENER_PROD  
log_archive_dest_1 LOCATION=/u01/app/oracle/arc  
nls_length_semantics BYTE  
open_cursors 1000  
pga_aggregate_target 3221225472  
processes 1000  
recyclebin OFF  
remote_login_passwordfile EXCLUSIVE  
sga_max_size 8589934592  
sga_target 8589934592  
shared_pool_size 1073741824  
undo_tablespace UNDOTBS1  
utl_file_dir /prod/logs  


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

 1st Period 2nd Period
Parameter NameBegin Snap ValueEnd Snap ValueBegin Snap ValueEnd Snap Value
control_files  /u01/app/oracle/oradata/PROD/control01.ctl    
   /u01/app/oracle/oradata/PROD/control02.ctl    


Back to init.ora Parameters
Back to Top


Back to Top