WORKLOAD REPOSITORY COMPARE PERIOD REPORT

 

Snapshot Set DB Name DB Id Instance Inst num Release Cluster Host
First (1st) O102EE1 2384218455 o102ee1 1 10.2.0.3.0 NO hpap0601
Second (2nd) O102EE1 2384218455 o102ee1 1 10.2.0.3.0 NO hpap0601

 

 

Snapshot Set Begin Snap Id Begin Snap Time End Snap Id End Snap Time Elapsed Time (min) DB Time (min) Avg Active Users
1st 7478 02-Apr-07 20:01:05 7479 02-Apr-07 20:09:17 8.21 31.18 3.80
2nd 7480 02-Apr-07 20:28:31 7481 02-Apr-07 20:31:18 2.79 2.60 0.32

 

Configuration Comparison

 

1st 2nd %Diff
Buffer Cache: 92M 92M 0.00
Std Block Size: 8K 8K 0.00
Shared Pool Size: 148M 148M 0.00
Log Buffer: 6,960K 6,960K 0.00
SGA Target: 268M 268M 0.00
PGA Aggregate Target: 17M 17M 0.00
Undo Management: AUTO AUTO  

Load Profile

 

1st Per Sec 2nd Per Sec %Diff 1st Per Txn 2nd Per Txn %Diff
Redo size: 9,225.19 23,001.54 149.33 2,188.74 1,881.48 -14.04
Logical reads: 109,152.58 11,379.23 -89.57 25,897.25 930.80 -96.41
Block changes: 41.65 101.53 143.77 9.88 9.88 0.00
Physical reads: 6,637.45 11.93 -99.82 1,574.78 0.98 -99.94
Physical writes: 4.19 1.17 -72.08 0.99 0.10 -89.90
User calls: 291.04 853.64 193.31 69.05 69.83 1.13
Parses: 117.25 341.70 191.43 27.82 27.95 0.47
Hard parses: 53.76 159.62 196.91 12.76 13.06 2.35
Sorts: 8.37 27.53 228.91 1.99 2.25 13.07
Logons: 0.04 0.08 100.00 0.01 0.01 0.00
Executes: 131.21 386.86 194.84 31.13 31.64 1.64
Transactions: 4.21 12.23 190.50      
1st 2nd Diff
% Blocks changed per Read: 0.04 0.89 0.85
Recursive Call %: 58.40 62.19 3.79
Rollback per transaction %: 0.10 0.10 0.00
Rows per Sort: 11.47 12.16 0.69
Avg Length of Calls (sec): 0.01 0.01 0.00

Top 5 Timed Events

 

1st 2nd
Event Waits Time(s) Percent Total DB Time Wait Class Event Waits Time(s) Percent Total DB Time Wait Class
CPU time   1,521.7 81.34   CPU time   149.8 95.86  
*read by other session 532,940 194.3 10.39 User I/O *log file parallel write 2,064 10.0 6.43 System I/O
*db file scattered read 463,215 56.1 3.00 User I/O *log file sync 2,024 9.8 6.25 Commit
*db file sequential read 557,900 20.4 1.09 User I/O *control file parallel write 89 3.4 2.19 System I/O
*latch: cache buffers chains 3,042 12.8 .69 Concurrency *latch: shared pool 518 1.5 .94 Concurrency
-control file parallel write 169 8.3 .44 System I/O -db file sequential read 1,499 0.3 .17 User I/O
-log file parallel write 2,246 7.7 .41 System I/O -db file scattered read 44 0.0 .01 User I/O
-log file sync 2,039 6.5 .34 Commit          
-latch: shared pool 307 0.7 .04 Concurrency          

Events with a "*" did not make the top 5 in the other snapshot set.

 

Events with a "-" did make the top 5 in the other snapshot set.

Report Details


Back to Top

Wait Events

  • Ordered by 'Diff' column of 'DB time %' descending (idle events last)
  % DB Time # Waits/sec (Elapsed Time) Avg Wait Time (ms)
Event 1st 2nd Diff 1st 2nd %Diff 1st 2nd %Diff
read by other session 10.39 0.00 -10.39 1,082.53 0.00 -100.00 0.36 0.00 -100.00
log file parallel write 0.41 6.43 6.02 4.56 12.35 170.83 3.43 4.87 41.98
log file sync 0.34 6.25 5.90 4.14 12.11 192.51 3.16 4.83 52.85
db file scattered read 3.00 0.01 -2.99 940.90 0.26 -99.97 0.12 0.23 91.67
control file parallel write 0.44 2.19 1.75 0.34 0.53 55.88 48.87 38.41 -21.40
db file sequential read 1.09 0.17 -0.92 1,133.23 8.97 -99.21 0.04 0.18 350.00
latch: shared pool 0.04 0.94 0.90 0.62 3.10 400.00 2.32 2.82 21.55
latch: cache buffers chains 0.69 0.00 -0.69 6.18 0.00 -100.00 4.21 0.00 -100.00
latch free 0.52 0.02 -0.51 4.27 0.04 -99.06 4.67 4.90 4.93
latch: library cache 0.01 0.40 0.38 0.15 0.51 240.00 3.07 7.19 134.20
SQL*Net message to client 0.03 0.29 0.26 185.18 541.93 192.65 0.01 0.00 -100.00
SQL*Net break/reset to client 0.00 0.19 0.18 0.07 0.10 42.86 1.85 18.10 878.38
log file switch completion 0.00 0.13 0.13 0.00 0.01 100.00 0.00 100.86 100.00
os thread startup 0.00 0.04 0.04 0.00 0.01 100.00 0.00 60.93 100.00
log file single write 0.00 0.01 0.01 0.00 0.01 100.00 0.00 6.45 100.00
control file sequential read 0.00 0.01 0.01 1.96 5.98 205.10 0.01 0.01 0.00
library cache load lock 0.01 0.00 -0.01 0.00 0.00 0.00 132.60 0.00 -100.00
latch: enqueue hash chains 0.00 0.01 0.01 0.00 0.01 100.00 0.00 9.06 100.00
latch: cache buffers lru chain 0.01 0.00 -0.01 0.09 0.00 -100.00 2.53 0.00 -100.00
buffer exterminate 0.01 0.00 -0.01 0.00 0.00 0.00 99.14 0.00 -100.00
LGWR wait for redo copy 0.00 0.00 -0.00 0.14 0.00 -100.00 0.81 0.00 -100.00
latch: row cache objects 0.00 0.00 0.00 0.02 0.02 0.00 4.75 2.49 -47.58
SQL*Net more data to client 0.00 0.00 -0.00 0.06 0.01 -83.33 0.98 0.05 -94.90
wait list latch free 0.00 0.00 -0.00 0.00 0.00 0.00 13.25 0.00 -100.00
latch: library cache pin 0.00 0.00 -0.00 0.00 0.00 0.00 9.93 0.00 -100.00
latch: library cache lock 0.00 0.00 -0.00 0.01 0.00 -100.00 1.27 0.00 -100.00
latch: object queue header operation 0.00 0.00 -0.00 0.00 0.00 0.00 1.68 0.00 -100.00
cursor: pin S wait on X 0.01 0.01 -0.00 0.02 0.01 -50.00 14.22 10.46 -26.44
direct path write 0.00 0.00 0.00 0.00 0.02 100.00 0.00 0.01 100.00
log file sequential read 0.00 0.00 0.00 0.00 0.01 100.00 0.00 0.01 100.00
SQL*Net more data from client 0.00 0.00 -0.00 0.00 0.00 0.00 0.03 0.00 -100.00
SQL*Net message from client 145.25 827.59 682.34 185.18 541.93 192.65 29.81 14.28 -52.10
Streams AQ: waiting for messages in the queue 25.85 106.24 80.39 0.20 0.20 0.00 4,885.02 4,883.59 -0.03
jobq slave wait 25.62 104.56 78.94 0.33 0.34 3.03 2,922.70 2,918.21 -0.15
wait for unread message on broadcast channel 25.73 104.52 78.79 1.00 1.00 0.00 980.41 978.19 -0.23
Streams AQ: qmn slave idle wait 26.63 104.98 78.35 0.04 0.04 0.00 27,679.56 27,345.56 -1.21
Streams AQ: qmn coordinator idle wait 26.63 104.98 78.35 0.08 0.07 -12.50 12,775.12 13,672.74 7.03
SGA: MMAN sleep for component shrink 0.01 0.00 -0.01 0.03 0.00 -100.00 10.93 0.00 -100.00


Back to Top

 

Time Model Statistics

  • Ordered by 'Diff' column of '% DB Time' descending (DB Time statistic first, background statistics last)
  % DB Time Time (seconds) Time per Trans (seconds)
Statistic Name 1st 2nd Diff 1st 2nd 1st 2nd %Diff
DB time 100.00 100.00 0.00 1,870.76 156.29 0.90 0.08 -91.11
parse time elapsed 4.94 56.40 51.46 92.41 88.15 0.04 0.04 0.00
sql execute elapsed time 95.63 44.28 -51.35 1,789.04 69.20 0.86 0.03 -96.51
hard parse elapsed time 4.04 46.60 42.56 75.54 72.83 0.04 0.04 0.00
DB CPU 81.34 95.86 14.52 1,521.67 149.82 0.73 0.07 -90.41
PL/SQL compilation elapsed time 1.49 10.77 9.28 27.88 16.84 0.01 0.01 0.00
PL/SQL execution elapsed time 0.06 0.49 0.43 1.16 0.77 0.00 0.00 0.00
connection management call elapsed time 0.01 0.31 0.30 0.14 0.48 0.00 0.00 0.00
hard parse (sharing criteria) elapsed time 0.01 0.29 0.28 0.15 0.45 0.00 0.00 0.00
repeated bind elapsed time 0.00 0.06 0.06 0.06 0.09 0.00 0.00 0.00
sequence load elapsed time 0.00 0.02 0.02 0.00 0.02 0.00 0.00 0.00
hard parse (bind mismatch) elapsed time 0.00 0.01 0.01 0.07 0.02 0.00 0.00 0.00
Java execution elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
RMAN cpu time (backup/restore) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
failed parse (out of shared memory) elapsed t 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
failed parse elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
inbound PL/SQL rpc elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
background elapsed time 1.37 9.42 8.05 25.61 14.73 0.01 0.01 0.00
background cpu time 0.14 0.72 0.58 2.68 1.12 0.00 0.00 0.00


Back to Top

 

Operating System Statistics

  • Ordered by 'Statistic Name'
  Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic Name 1st 2nd 1st 2nd %Diff 1st 2nd %Diff 1st 2nd %Diff
BUSY_TIME 185,753 39,074 99 250 151.80 377 234 -38.03 90 19 -78.63
IDLE_TIME 11,123 27,832 6 178 2,892.94 23 167 637.27 5 14 154.10
IOWAIT_TIME 478 1,227 0 8 2,919.23 1 7 656.70 0 1 160.87
LOAD 4 2 0 0 100.00 0 0 0.00 0 0 0.00
NICE_TIME 689 204 0 1 254.05 1 1 -12.86 0 0 -69.70
NUM_CPU_SOCKETS 0 0 0 0 0.00 0 0 0.00 0 0 0.00
PHYSICAL_MEMORY_BYTES 8,328 15,696 4 100 2,156.85 17 94 455.08 4 8 91.52
RSRC_MGR_CPU_WAIT_TIME 0 0 0 0 0.00 0 0 0.00 0 0 0.00
SYS_TIME 23,995 13,101 13 84 553.39 49 78 60.85 12 6 -44.55
USER_TIME 160,956 25,724 86 165 91.29 327 154 -52.92 78 13 -83.77


Back to Top

 

Service Statistics

Back to Top

Service Statistics

  • Ordered by 'Diff' column of 'DB time %' descending
  • Total DB Time First: 1870.76 seconds, Second: 156.29 seconds
  • Total CPU Time First: 1521.67 seconds, Second: 149.82 seconds
  • Total Physical Reads First: 3267675, Second: 1994
  • Total Logical Reads First: 53736798, Second: 1901617
  % DB Time % CPU Time % Physical Reads % Logical Reads
Service Name 1st 2nd Diff 1st 2nd Diff 1st 2nd Diff 1st 2nd Diff
SYS$USERS 99.89 98.35 -1.54 99.88 98.40 -1.48 99.76 93.18 -6.58 99.93 99.19 -0.75
o102ee1 0.08 1.60 1.52 0.08 1.59 1.51 0.00 10.33 10.33 0.01 0.72 0.71
SYS$BACKGROUND 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.35 0.35 0.01 0.08 0.07

Back to Service Statistics
Back to Top

Service Statistics (RAC)

  • Ordered by total Diff of '% of CR Blocks Received' and '% of Current Blocks Received'
  • Total GC CR Blks Received First: 1, Second: 1
  • Total GC CURRENT Blks Received First: 1, Second: 1
  % CR Blks Received % Current Blks Received
Service Name 1st 2nd Diff 1st 2nd Diff
SYS$BACKGROUND 0.00 0.00 0.00 0.00 0.00 0.00
SYS$USERS 0.00 0.00 0.00 0.00 0.00 0.00
o102ee1 0.00 0.00 0.00 0.00 0.00 0.00

Back to Service Statistics
Back to Top

 

SQL Statistics

Back to Top

Top 10 SQL Comparison by Execution Time

  • Ordered by 'Diff' column of 'Exec Time % of DB Time' descending.
  • 'N/A' indicates no data was captured for the statement in the period
  • 'Multiple Plans' column indicates whether more than one plan exists for the statement in the two periods
  • Total SQL Execution as a % DB Time First: 95.63%, Second: 44.28%
  Exec Time % of DB Time Exec Time (ms) / Exec #Exec/sec (DB Time) CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd Multiple Plans SQL Text
8zt0p6avg76yz 4.17 16.22 12.05 78 25 0.53 6.40 57 25 0.02 0.60 1.00 1.00 No SELECT COUNT(ename) FROM emp3 ...
90p005ah4wm47 0.22 2.21 2.00 0 0 5.35 63.98 0 0 0.00 0.00 1.00 1.00 No select distinct emp1.deptno fr...
5u3yjw57ppbsx 0.12 0.92 0.80 0 0 5.35 63.98 0 0 0.00 0.00 1.00 1.00 No SELECT ENAME FROM EMP2 WHERE E...
6gvch1xu9ca3g 0.06 0.70 0.64 130 365 0.00 0.02 118 360 3.63 25.67 1.00 1.00 No DECLARE job BINARY_INTEGER := ...
b058ymxj1rvkg 0.21 0.84 0.63 188 147 0.01 0.06 165 132 0.00 0.00 1.19 0.00 No SELECT sql_id, sql_text from v...
257rmrxgvaj4z 0.12 0.56 0.43 36 39 0.03 0.14 33 39 0.00 0.36 13.00 13.00 No select begin_time, wait_class...
db78fxqxwxt7r 0.01 0.24 0.23 0 0 0.69 14.09 0 0 0.12 0.11 15.65 15.64 No select /*+ rule */ bucket, en...
7ng34ruy5awxq 0.02 0.22 0.21 1 1 0.11 1.70 1 1 0.00 0.01 1.33 1.26 No select i.obj#, i.ts#, i.file#,...
bunssq950snhf 0.02 0.22 0.20 338 344 0.00 0.01 338 344 0.00 1.00 7.00 7.00 No insert into wrh$_sga_target_ad...
b8b5jdj7khuaw 0.06 0.21 0.16 32 30 0.02 0.07 31 30 0.00 0.09 59.31 14.45 No SELECT event#, sql_id, sql_p...
6cm3sr71q92uz 0.12   -0.12 2,328   0.00   2,328   152.00   1.00   No BEGIN statspack.snap(7); END; ...
0cg8busnwuyh9 0.13 0.01 -0.12 2,367 8 0.00 0.01 2,367 8 415.00 0.00 1.00 0.00 No BEGIN DBMS_WORKLOAD_REPOSITO...
cakg0hdjjw2wf 0.05 0.13 0.08 27 18 0.02 0.07 25 18 0.00 0.00 1.00 1.00 No select value from v$sysmetric ...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by CPU Time

  • Ordered by Diff column of CPU Time % of DB Time descending.
  • 'N/A' in this section indicates no data was captured for the statement in the period
  • 'Multiple Plans' column in this section indicates whether more than one plan exist for the statement in the two periods
  • CPU Time as a % DB Time First: 81.34%, Second: 95.86%
  CPU Time % of DB Time CPU Time (ms) / Exec #Exec/sec (DB Time) Exec Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd Multiple Plans SQL Text
8zt0p6avg76yz 3.03 16.21 13.18 57 25 0.53 6.40 78 25 0.02 0.60 1.00 1.00 No SELECT COUNT(ename) FROM emp3 ...
90p005ah4wm47 0.21 2.19 1.98 0 0 5.35 63.98 0 0 0.00 0.00 1.00 1.00 No select distinct emp1.deptno fr...
5u3yjw57ppbsx 0.12 0.92 0.80 0 0 5.35 63.98 0 0 0.00 0.00 1.00 1.00 No SELECT ENAME FROM EMP2 WHERE E...
6gvch1xu9ca3g 0.05 0.69 0.64 118 360 0.00 0.02 130 365 3.63 25.67 1.00 1.00 No DECLARE job BINARY_INTEGER := ...
b058ymxj1rvkg 0.18 0.76 0.57 165 132 0.01 0.06 188 147 0.00 0.00 1.19 0.00 No SELECT sql_id, sql_text from v...
257rmrxgvaj4z 0.11 0.55 0.44 33 39 0.03 0.14 36 39 0.00 0.36 13.00 13.00 No select begin_time, wait_class...
db78fxqxwxt7r 0.01 0.24 0.23 0 0 0.69 14.09 0 0 0.12 0.11 15.65 15.64 No select /*+ rule */ bucket, en...
7ng34ruy5awxq 0.02 0.22 0.21 1 1 0.11 1.70 1 1 0.00 0.01 1.33 1.26 No select i.obj#, i.ts#, i.file#,...
bunssq950snhf 0.02 0.22 0.20 338 344 0.00 0.01 338 344 0.00 1.00 7.00 7.00 No insert into wrh$_sga_target_ad...
b8b5jdj7khuaw 0.05 0.21 0.16 31 30 0.02 0.07 32 30 0.00 0.09 59.31 14.45 No SELECT event#, sql_id, sql_p...
6cm3sr71q92uz 0.12   -0.12 2,328   0.00   2,328   152.00   1.00   No BEGIN statspack.snap(7); END; ...
0cg8busnwuyh9 0.13 0.01 -0.12 2,367 8 0.00 0.01 2,367 8 415.00 0.00 1.00 0.00 No BEGIN DBMS_WORKLOAD_REPOSITO...
cakg0hdjjw2wf 0.04 0.13 0.09 25 18 0.02 0.07 27 18 0.00 0.00 1.00 1.00 No select value from v$sysmetric ...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Buffer Gets

  • Ordered by Diff column of % Total Gets descending.
  • 'N/A' in this section indicates no data was captured for the statement in the period
  • 'Multiple Plans' column in this section indicates whether more than one plan exist for the statement in the two periods
  • Total Buffer Gets First:53736798, Second: 1901617
  % Total Gets Gets / Exec #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd Multiple Plans SQL Text
8zt0p6avg76yz 2.90 81.88 78.98 1,557.00 1,557.05 1,000 1,000 78 25 57 25 0.02 0.60 1.00 1.00 No SELECT COUNT(ename) FROM emp3 ...
90p005ah4wm47 0.26 7.36 7.10 14.00 14.00 10,000 10,000 0 0 0 0 0.00 0.00 1.00 1.00 No select distinct emp1.deptno fr...
5u3yjw57ppbsx 0.07 2.11 2.03 4.00 4.00 10,000 10,000 0 0 0 0 0.00 0.00 1.00 1.00 No SELECT ENAME FROM EMP2 WHERE E...
96g93hntrzjtr 0.01 0.47 0.46 2.66 2.76 2,358 3,257 0 0 0 0 0.01 0.00 0.61 0.71 No select /*+ rule */ bucket_cnt,...
db78fxqxwxt7r 0.01 0.36 0.35 3.10 3.12 1,300 2,202 0 0 0 0 0.12 0.11 15.65 15.64 No select /*+ rule */ bucket, en...
6gvch1xu9ca3g 0.01 0.35 0.34 650.00 2,197.67 8 3 130 365 118 360 3.63 25.67 1.00 1.00 No DECLARE job BINARY_INTEGER := ...
d9qr16p9z7xy2 0.01 0.27 0.26 6.00 5.18 1,000 1,000 0 0 0 0 0.01 0.00 1.00 1.00 No update emp4 set ename = 'aaa' ...
6kpzvzuv00t58 0.01 0.27 0.26 6.00 5.07 1,000 1,000 0 0 0 0 0.00 0.00 1.00 1.00 No update EMP5 set ename = 'aaa' ...
53saa2zkr6wc3 0.01 0.17 0.16 5.00 4.79 1,017 656 0 0 0 0 0.00 0.00 1.50 1.37 No select intcol#, nvl(pos#, 0), ...
5uq8u6hqrr21g 0.01 0.16 0.15 3.05 3.00 1,000 1,000 0 0 0 0 0.00 0.00 1.00 1.00 No SELECT COUNT(ENAME) FROM EMP3 ...
0cg8busnwuyh9 0.07 0.00 -0.06 35,407.00 57.00 1 1 2,367 8 2,367 8 415.00 0.00 1.00 0.00 No BEGIN DBMS_WORKLOAD_REPOSITO...
6cm3sr71q92uz 0.05   -0.05 27,336.00   1   2,328   2,328   152.00   1.00   No BEGIN statspack.snap(7); END; ...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Physical Reads

  • Ordered by Diff column of % Total Physical Reads descending.
  • 'N/A' in this section indicates no data was captured for the statement in the period
  • 'Multiple Plans' column in this section indicates whether more than one plan exist for the statement in the two periods
  • User I/O Class Wait Time as a % DB Time First: 14.48%, Second: .18%
  • Total Physical Reads First: 3267675, Second: 1994
  % Total Physical Reads Physical Reads / Exec #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec #Rows Processed / Exec    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd Multiple Plans SQL Text
8zt0p6avg76yz 0.00 29.99 29.99 0.02 0.60 1,000 1,000 78 25 57 25 1.00 1.00 No SELECT COUNT(ename) FROM emp3 ...
db78fxqxwxt7r 0.00 12.09 12.08 0.12 0.11 1,300 2,202 0 0 0 0 15.65 15.64 No select /*+ rule */ bucket, en...
6gvch1xu9ca3g 0.00 3.86 3.86 3.63 25.67 8 3 130 365 118 360 1.00 1.00 No DECLARE job BINARY_INTEGER := ...
cvn54b7yz0s8u 0.00 2.81 2.81 0.31 0.52 51 107 0 1 0 1 2.78 1.73 No select /*+ index(idl_ub1$ i_id...
39m4sx9k63ba2 0.00 1.05 1.05 0.27 0.18 51 117 0 1 0 1 1.12 1.79 No select /*+ index(idl_ub2$ i_id...
cqgv56fmuj63x 0.00 1.00 1.00 0.06 0.08 188 249 0 0 0 0 1.32 3.49 No select owner#, name, namespace...
8swypbbr0m372 0.00 0.95 0.95 0.06 0.08 188 249 0 0 0 0 0.80 3.09 No select order#, columns, types ...
4qju99hqmn81x 0.00 0.80 0.80 10.00 16.00 1 1 60 97 60 97 188.00 11.00 No INSERT INTO WRH$_ACTIVE_SESSIO...
5u3yjw57ppbsx 0.00 0.75 0.75 0.00 0.00 10,000 10,000 0 0 0 0 1.00 1.00 No SELECT ENAME FROM EMP2 WHERE E...
ga9j9xk5cy9s0 0.00 0.70 0.70 0.04 0.12 51 117 0 0 0 0 1.08 1.23 No select /*+ index(idl_sb4$ i_id...
b7twbdp012nbw 0.04   -0.04 1,245.00   1   74   74   1.00   No select emp1no, ename from emp1...
4xqb04qv3vtg7 0.04   -0.04 1,244.00   1   74   74   1.00   No select emp1no, ename from emp1...
ahnqq4n2849u8 0.04   -0.04 1,235.00   1   79   79   1.00   No select emp1no, ename from emp1...
7dtyn9bahqv8n 0.04   -0.04 1,231.00   1   74   74   1.00   No select emp1no, ename from emp1...
7d8q61r65cnhs 0.04   -0.04 1,217.00   1   73   73   1.00   No select emp1no, ename from emp1...
36mswpf5cfhuc 0.04   -0.04 1,216.00   1   72   72   1.00   No select emp1no, ename from emp1...
19wddcpnyw0bm 0.04   -0.04 1,196.00   1   84   84   1.00   No select emp1no, ename from emp1...
42m7brc22hpwk 0.04   -0.04 1,175.00   1   74   74   1.00   No select emp1no, ename from emp1...
ag1rxfdgkw116 0.04   -0.04 1,173.00   1   74   74   1.00   No select emp1no, ename from emp1...
cdp18jk8u8mny 0.04   -0.04 1,165.00   1   77   77   1.00   No select emp1no, ename from emp1...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Executions

  • Ordered by Diff column of #Executions/sec (DB Time) descending.
  • 'N/A' in this section indicates no data was captured for the statement in the period
  • 'Multiple Plans' column in this section indicates whether more than one plan exist for the statement in the two periods
  • Total SQL Execution as a % DB Time First: 95.63%, Second: 44.28%
  #Executions/sec (DB Time) #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd Multiple Plans SQL Text
5u3yjw57ppbsx 5.35 63.98 58.64 10,000 10,000 0 0 0 0 0.00 0.00 1.00 1.00 No SELECT ENAME FROM EMP2 WHERE E...
90p005ah4wm47 5.35 63.98 58.64 10,000 10,000 0 0 0 0 0.00 0.00 1.00 1.00 No select distinct emp1.deptno fr...
96g93hntrzjtr 1.26 20.84 19.58 2,358 3,257 0 0 0 0 0.01 0.00 0.61 0.71 No select /*+ rule */ bucket_cnt,...
db78fxqxwxt7r 0.69 14.09 13.39 1,300 2,202 0 0 0 0 0.12 0.11 15.65 15.64 No select /*+ rule */ bucket, en...
5uq8u6hqrr21g 0.53 6.40 5.86 1,000 1,000 0 0 0 0 0.00 0.00 1.00 1.00 No SELECT COUNT(ENAME) FROM EMP3 ...
6kpzvzuv00t58 0.53 6.40 5.86 1,000 1,000 0 0 0 0 0.00 0.00 1.00 1.00 No update EMP5 set ename = 'aaa' ...
8zt0p6avg76yz 0.53 6.40 5.86 1,000 1,000 78 25 57 25 0.02 0.60 1.00 1.00 No SELECT COUNT(ename) FROM emp3 ...
d9qr16p9z7xy2 0.53 6.40 5.86 1,000 1,000 0 0 0 0 0.01 0.00 1.00 1.00 No update emp4 set ename = 'aaa' ...
2ym6hhaq30r73 0.35 4.70 4.35 651 734 0 0 0 0 0.00 0.00 1.00 1.00 No select type#, blocks, extents,...
53saa2zkr6wc3 0.54 4.20 3.65 1,017 656 0 0 0 0 0.00 0.00 1.50 1.37 No select intcol#, nvl(pos#, 0), ...
3c1kubcdjnppq 0.47   -0.47 883   1   1   0.01   1.00   No update sys.col_usage$ set eq...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Parse Calls

  • Ordered by Diff column of % Total Parses descending.
  • 'N/A' in this section indicates no data was captured for the statement in the period
  • 'Multiple Plans' column in this section indicates whether more than one plan exist for the statement in the two periods
  • Parse Time as a % DB Time First: 0%, Second: 0%
  • Total Parse Calls First: 57722, Second: 57102
  % Total Parses Parses #Executions    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd Multiple Plans SQL Text
3c1kubcdjnppq 0.55   -0.55 317   883   No update sys.col_usage$ set eq...
b2gnxm5z6r51n 0.55   -0.55 317   317   No lock table sys.col_usage$ in e...
asvzxj61dc5vs 0.22 0.45 0.23 127 255 127 255 No select timestamp, flags from ...
5u3yjw57ppbsx 17.32 17.51 0.19 10,000 10,000 10,000 10,000 No SELECT ENAME FROM EMP2 WHERE E...
90p005ah4wm47 17.32 17.51 0.19 10,000 10,000 10,000 10,000 No select distinct emp1.deptno fr...
2ym6hhaq30r73 1.13 1.29 0.16 651 734 651 734 No select type#, blocks, extents,...
8swypbbr0m372 0.33 0.44 0.11 188 249 188 249 No select order#, columns, types ...
cqgv56fmuj63x 0.33 0.44 0.11 188 249 188 249 No select owner#, name, namespace...
5uq8u6hqrr21g 1.73 1.75 0.02 1,000 1,000 1,000 1,000 No SELECT COUNT(ENAME) FROM EMP3 ...
6kpzvzuv00t58 1.73 1.75 0.02 1,000 1,000 1,000 1,000 No update EMP5 set ename = 'aaa' ...
8zt0p6avg76yz 1.73 1.75 0.02 1,000 1,000 1,000 1,000 No SELECT COUNT(ename) FROM emp3 ...
d9qr16p9z7xy2 1.73 1.75 0.02 1,000 1,000 1,000 1,000 No update emp4 set ename = 'aaa' ...

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

 

SQL Id SQL Text
0cg8busnwuyh9 BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); END;
19wddcpnyw0bm select emp1no, ename from emp1 where emp1no = 19914
257rmrxgvaj4z select begin_time, wait_class#, (time_waited)/(intsize_csec/100) from v$waitclassmetric union all select begin_time, -1, value from v$sysmetric where metric_name = 'CPU Usage Per Sec' and group_id = 2 order by begin_time, wait_class#
2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
36mswpf5cfhuc select emp1no, ename from emp1 where emp1no = 15984
39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
42m7brc22hpwk select emp1no, ename from emp1 where emp1no = 15989
4qju99hqmn81x INSERT INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
4xqb04qv3vtg7 select emp1no, ename from emp1 where emp1no = 15993
53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5u3yjw57ppbsx SELECT ENAME FROM EMP2 WHERE EMP2NO = :num
5uq8u6hqrr21g SELECT COUNT(ENAME) FROM EMP3 WHERE EMP3NO = 5
6cm3sr71q92uz BEGIN statspack.snap(7); END;
6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6kpzvzuv00t58 update EMP5 set ename = 'aaa' where EMP5no = 100
7d8q61r65cnhs select emp1no, ename from emp1 where emp1no = 15987
7dtyn9bahqv8n select emp1no, ename from emp1 where emp1no = 15999
7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1
8zt0p6avg76yz SELECT COUNT(ename) FROM emp3 WHERE emp3no = 1
90p005ah4wm47 select distinct emp1.deptno from emp1, dept where emp1.deptno = dept.deptno and dept.deptno = 10
96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
ag1rxfdgkw116 select emp1no, ename from emp1 where emp1no = 15983
ahnqq4n2849u8 select emp1no, ename from emp1 where emp1no = 15990
asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1
b058ymxj1rvkg SELECT sql_id, sql_text from v$sql WHERE sql_id in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait
b7twbdp012nbw select emp1no, ename from emp1 where emp1no = 15996
b8b5jdj7khuaw SELECT event#, sql_id, sql_plan_hash_value, sql_opcode, session_id, session_serial#, module, action, client_id, DECODE(wait_time, 0, 'W', 'C'), 1, time_waited, service_hash, user_id, program, sample_time, p1, p2, p3, current_file#, current_obj#, current_block#, qc_session_id, qc_instance_id FROM v$active_session_history WHERE sample_time > :1 AND sample_time <= :2
bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cakg0hdjjw2wf select value from v$sysmetric where group_id = 2 and metric_id = :1
cdp18jk8u8mny select emp1no, ename from emp1 where emp1no = 15992
cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d9qr16p9z7xy2 update emp4 set ename = 'aaa' where emp4no = 1000000
db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
ga9j9xk5cy9s0 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

  • Ordered by statistic name.
  Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic 1st 2nd 1st 2nd %Diff 1st 2nd %Diff 1st 2nd %Diff
application wait time 6 29 0.00 0.19 100.00 0.01 0.17 1,600.00 0.00 0.01 100.00
concurrency wait time 1,407 215 0.75 1.38 84.00 2.86 1.29 -54.90 0.68 0.11 -83.82
db block changes 20,507 16,967 10.96 108.56 890.51 41.65 101.53 143.77 9.88 8.30 -15.99
execute count 64,597 64,650 34.53 413.66 1,097.97 131.21 386.86 194.84 31.13 31.64 1.64
logons cumulative 20 14 0.01 0.09 800.00 0.04 0.08 100.00 0.01 0.01 0.00
opened cursors cumulative 64,322 65,334 34.38 418.03 1,115.91 130.65 390.96 199.24 31.00 31.98 3.16
parse count (total) 57,722 57,102 30.85 365.36 1,084.31 117.25 341.70 191.43 27.82 27.95 0.47
parse time elapsed 6,590 7,078 3.52 45.29 1,186.65 13.39 42.35 216.28 3.18 3.46 8.81
physical reads 3,267,675 1,994 1,746.71 12.76 -99.27 6,637.45 11.93 -99.82 1,574.78 0.98 -99.94
physical writes 2,062 196 1.10 1.25 13.64 4.19 1.17 -72.08 0.99 0.10 -89.90
redo size 4,541,644 3,843,856 2,427.71 24,594.44 913.07 9,225.19 23,001.54 149.33 2,188.74 1,881.48 -14.04
session cursor cache hits 34,884 36,685 18.65 234.72 1,158.55 70.86 219.52 209.79 16.81 17.96 6.84
session logical reads 53,736,798 1,901,617 28,724.65 12,167.26 -57.64 109,152.58 11,379.23 -89.57 25,897.25 930.80 -96.41
user I/O wait time 27,089 30 14.48 0.19 -98.69 55.02 0.18 -99.67 13.05 0.01 -99.92
user calls 143,283 142,654 76.59 912.75 1,091.74 291.04 853.64 193.31 69.05 69.83 1.13
user commits 2,073 2,041 1.11 13.06 1,076.58 4.21 12.21 190.02 1.00 1.00 0.00
user rollbacks 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
workarea executions - onepass 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
workarea executions - optimal 2,340 2,574 1.25 16.47 1,217.60 4.75 15.40 224.21 1.13 1.26 11.50

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

  • Ordered by statistic name.
  Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic 1st 2nd 1st 2nd %Diff 1st 2nd %Diff 1st 2nd %Diff
CPU used by this session 154,183 14,816 82.42 94.80 15.02 313.18 88.66 -71.69 74.31 7.25 -90.24
CPU used when call started 153,883 14,641 82.26 93.68 13.88 312.57 87.61 -71.97 74.16 7.17 -90.33
CR blocks created 159 55 0.08 0.35 337.50 0.32 0.33 3.13 0.08 0.03 -62.50
Cached Commit SCN referenced 1,488,000 1,487,000 795.40 9,514.39 1,096.18 3,022.49 8,898.17 194.40 717.11 727.85 1.50
Commit SCN cached 1 1 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
DBWR checkpoint buffers written 1,502 121 0.80 0.77 -3.75 3.05 0.72 -76.39 0.72 0.06 -91.67
DBWR checkpoints 0 1 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
DBWR transaction table writes 13 4 0.01 0.03 200.00 0.03 0.02 -33.33 0.01 0.00 -100.00
DBWR undo block writes 359 26 0.19 0.17 -10.53 0.73 0.16 -78.08 0.17 0.01 -94.12
IMU CR rollbacks 56 0 0.03 0.00 -100.00 0.11 0.00 -100.00 0.03 0.00 -100.00
IMU Flushes 123 3 0.07 0.02 -71.43 0.25 0.02 -92.00 0.06 0.00 -100.00
IMU Redo allocation size 49,976 0 26.71 0.00 -100.00 101.51 0.00 -100.00 24.08 0.00 -100.00
IMU commits 2,067 110 1.10 0.70 -36.36 4.20 0.66 -84.29 1.00 0.05 -95.00
IMU contention 0 1 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
IMU pool not allocated 0 2,007 0.00 12.84 100.00 0.00 12.01 100.00 0.00 0.98 100.00
IMU undo allocation size 1,980,276 98,716 1,058.54 631.62 -40.33 4,022.42 590.71 -85.31 954.35 48.32 -94.94
IMU- failed to get a private strand 0 2,007 0.00 12.84 100.00 0.00 12.01 100.00 0.00 0.98 100.00
SQL*Net roundtrips to/from client 91,164 90,550 48.73 579.37 1,088.94 185.18 541.85 192.61 43.93 44.32 0.89
active txn count during cleanout 130 104 0.07 0.67 857.14 0.26 0.62 138.46 0.06 0.05 -16.67
background checkpoints started 0 1 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
background timeouts 1,568 532 0.84 3.40 304.76 3.18 3.18 0.00 0.76 0.26 -65.79
buffer is not pinned count 69,146 122,779 36.96 785.59 2,025.51 140.45 734.71 423.11 33.32 60.10 80.37
buffer is pinned count 10,559 10,488 5.64 67.11 1,089.89 21.45 62.76 192.59 5.09 5.13 0.79
bytes received via SQL*Net from client 12,511,630 12,455,183 6,688.01 79,692.95 1,091.58 25,414.18 74,531.50 193.27 6,029.70 6,096.52 1.11
bytes sent via SQL*Net to client 19,116,850 18,959,665 10,218.79 121,311.07 1,087.14 38,831.00 113,454.16 192.17 9,212.94 9,280.31 0.73
calls to get snapshot scn: kcmgss 177,631 65,111 94.95 416.60 338.76 360.81 389.62 7.98 85.61 31.87 -62.77
calls to kcmgas 2,990 2,382 1.60 15.24 852.50 6.07 14.25 134.76 1.44 1.17 -18.75
calls to kcmgcs 77 70 0.04 0.45 1,025.00 0.16 0.42 162.50 0.04 0.03 -25.00
change write time 62 23 0.03 0.15 400.00 0.13 0.14 7.69 0.03 0.01 -66.67
cleanout - number of ktugct calls 155 126 0.08 0.81 912.50 0.31 0.75 141.94 0.07 0.06 -14.29
cleanouts only - consistent read gets 2 4 0.00 0.03 100.00 0.00 0.02 100.00 0.00 0.00 0.00
cluster key scan block gets 11,478 12,723 6.14 81.41 1,225.90 23.31 76.13 226.60 5.53 6.23 12.66
cluster key scans 6,324 7,306 3.38 46.75 1,283.14 12.85 43.72 240.23 3.05 3.58 17.38
commit batch/immediate performed 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
commit batch/immediate requested 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
commit cleanout failures: callback failure 14 13 0.01 0.08 700.00 0.03 0.08 166.67 0.01 0.01 0.00
commit cleanouts 3,675 3,068 1.96 19.63 901.53 7.46 18.36 146.11 1.77 1.50 -15.25
commit cleanouts successfully completed 3,661 3,055 1.96 19.55 897.45 7.44 18.28 145.70 1.76 1.50 -14.77
commit immediate performed 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
commit immediate requested 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
commit txn count during cleanout 74 64 0.04 0.41 925.00 0.15 0.38 153.33 0.04 0.03 -25.00
consistent changes 159 55 0.08 0.35 337.50 0.32 0.33 3.13 0.08 0.03 -62.50
consistent gets 53,716,484 1,887,280 28,713.80 12,075.53 -57.95 109,111.32 11,293.44 -89.65 25,887.46 923.78 -96.43
consistent gets - examination 112,512 127,889 60.14 818.28 1,260.63 228.54 765.28 234.86 54.22 62.60 15.46
consistent gets from cache 53,716,484 1,887,280 28,713.80 12,075.53 -57.95 109,111.32 11,293.44 -89.65 25,887.46 923.78 -96.43
cursor authentications 51 151 0.03 0.97 3,133.33 0.10 0.90 800.00 0.02 0.07 250.00
data blocks consistent reads - undo records applied 159 55 0.08 0.35 337.50 0.32 0.33 3.13 0.08 0.03 -62.50
db block gets 20,314 14,337 10.86 91.73 744.66 41.26 85.79 107.93 9.79 7.02 -28.29
db block gets direct 0 4 0.00 0.03 100.00 0.00 0.02 100.00 0.00 0.00 0.00
db block gets from cache 20,314 14,333 10.86 91.71 744.48 41.26 85.77 107.88 9.79 7.02 -28.29
deferred (CURRENT) block cleanout applications 3,047 2,767 1.63 17.70 985.89 6.19 16.56 167.53 1.47 1.35 -8.16
dirty buffers inspected 280 36 0.15 0.23 53.33 0.57 0.22 -61.40 0.13 0.02 -84.62
enqueue conversions 147 84 0.08 0.54 575.00 0.30 0.50 66.67 0.07 0.04 -42.86
enqueue releases 36,147 32,573 19.32 208.41 978.73 73.42 194.92 165.49 17.42 15.94 -8.50
enqueue requests 36,147 32,573 19.32 208.41 978.73 73.42 194.92 165.49 17.42 15.94 -8.50
free buffer inspected 4,201,761 1,955 2,246.02 12.51 -99.44 8,534.80 11.70 -99.86 2,024.95 0.96 -99.95
free buffer requested 3,268,269 2,345 1,747.03 15.00 -99.14 6,638.65 14.03 -99.79 1,575.07 1.15 -99.93
heap block compress 4 5 0.00 0.03 100.00 0.01 0.03 200.00 0.00 0.00 0.00
hot buffers moved to head of LRU 2,562 719 1.37 4.60 235.77 5.20 4.30 -17.31 1.23 0.35 -71.54
immediate (CR) block cleanout applications 2 4 0.00 0.03 100.00 0.00 0.02 100.00 0.00 0.00 0.00
immediate (CURRENT) block cleanout applications 245 131 0.13 0.84 546.15 0.50 0.78 56.00 0.12 0.06 -50.00
index crx upgrade (positioned) 2,023 1,288 1.08 8.24 662.96 4.11 7.71 87.59 0.97 0.63 -35.05
index fast full scans (full) 4 4 0.00 0.03 100.00 0.01 0.02 100.00 0.00 0.00 0.00
index fetch by key 41,245 38,614 22.05 247.07 1,020.50 83.78 231.07 175.81 19.88 18.90 -4.93
index scans kdiixs1 19,646 36,094 10.50 230.94 2,099.43 39.91 215.99 441.19 9.47 17.67 86.59
leaf node 90-10 splits 12 11 0.01 0.07 600.00 0.02 0.07 250.00 0.01 0.01 0.00
leaf node splits 50 45 0.03 0.29 866.67 0.10 0.27 170.00 0.02 0.02 0.00
lob writes 0 18 0.00 0.12 100.00 0.00 0.11 100.00 0.00 0.01 100.00
lob writes unaligned 0 18 0.00 0.12 100.00 0.00 0.11 100.00 0.00 0.01 100.00
messages received 2,941 2,154 1.57 13.78 777.71 5.97 12.89 115.91 1.42 1.05 -26.06
messages sent 2,941 2,154 1.57 13.78 777.71 5.97 12.89 115.91 1.42 1.05 -26.06
no work - consistent read gets 53,483,923 1,752,471 28,589.48 11,212.97 -60.78 108,638.93 10,486.74 -90.35 25,775.38 857.79 -96.67
parse count (hard) 26,468 26,674 14.15 170.67 1,106.15 53.76 159.62 196.91 12.76 13.06 2.35
parse time cpu 5,919 6,695 3.16 42.84 1,255.70 12.02 40.06 233.28 2.85 3.28 15.09
physical read IO requests 1,022,372 1,461 546.50 9.35 -98.29 2,076.69 8.74 -99.58 492.71 0.72 -99.85
physical read bytes 26,768,793,600 16,334,848 14,309,083.69 104,516.51 -99.27 54,373,967.57 97,747.32 -99.82 12,900,623.42 7,995.52 -99.94
physical read total IO requests 1,023,340 2,471 547.02 15.81 -97.11 2,078.65 14.79 -99.29 493.18 1.21 -99.75
physical read total bytes 26,784,620,544 32,785,408 14,317,543.88 209,773.38 -98.53 54,406,115.96 196,187.06 -99.64 12,908,250.86 16,047.68 -99.88
physical read total multi block requests 464,021 44 248.04 0.28 -99.89 942.54 0.26 -99.97 223.62 0.02 -99.99
physical reads cache 3,267,675 1,994 1,746.71 12.76 -99.27 6,637.45 11.93 -99.82 1,574.78 0.98 -99.94
physical reads cache prefetch 2,245,303 533 1,200.21 3.41 -99.72 4,560.76 3.19 -99.93 1,082.07 0.26 -99.98
physical write IO requests 912 104 0.49 0.67 36.73 1.85 0.62 -66.49 0.44 0.05 -88.64
physical write bytes 16,891,904 1,605,632 9,029.46 10,273.44 13.78 34,311.59 9,608.06 -72.00 8,140.68 785.92 -90.35
physical write total IO requests 3,662 2,440 1.96 15.61 696.43 7.44 14.60 96.24 1.76 1.19 -32.39
physical write total bytes 30,827,520 10,788,352 16,478.65 69,027.94 318.89 62,618.23 64,557.23 3.10 14,856.64 5,280.64 -64.46
physical write total multi block requests 2,485 2,087 1.33 13.35 903.76 5.05 12.49 147.33 1.20 1.02 -15.00
physical writes direct 0 4 0.00 0.03 100.00 0.00 0.02 100.00 0.00 0.00 0.00
physical writes direct (lob) 0 4 0.00 0.03 100.00 0.00 0.02 100.00 0.00 0.00 0.00
physical writes from cache 2,062 192 1.10 1.23 11.82 4.19 1.15 -72.55 0.99 0.09 -90.91
physical writes non checkpoint 1,296 97 0.69 0.62 -10.14 2.63 0.58 -77.95 0.62 0.05 -91.94
pinned buffers inspected 15,285 0 8.17 0.00 -100.00 31.05 0.00 -100.00 7.37 0.00 -100.00
process last non-idle time 0 453 0.00 2.90 100.00 0.00 2.71 100.00 0.00 0.22 100.00
recursive calls 201,158 234,632 107.53 1,501.26 1,296.13 408.60 1,404.03 243.62 96.94 114.85 18.48
recursive cpu usage 8,239 7,942 4.40 50.82 1,055.00 16.74 47.52 183.87 3.97 3.89 -2.02
redo blocks written 10,994 9,389 5.88 60.07 921.60 22.33 56.18 151.59 5.30 4.60 -13.21
redo buffer allocation retries 0 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
redo entries 8,895 8,575 4.75 54.87 1,055.16 18.07 51.31 183.95 4.29 4.20 -2.10
redo log space requests 0 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
redo log space wait time 0 20 0.00 0.13 100.00 0.00 0.12 100.00 0.00 0.01 100.00
redo ordering marks 209 204 0.11 1.31 1,090.91 0.42 1.22 190.48 0.10 0.10 0.00
redo subscn max counts 523 370 0.28 2.37 746.43 1.06 2.21 108.49 0.25 0.18 -28.00
redo synch time 649 1,006 0.35 6.44 1,740.00 1.32 6.02 356.06 0.31 0.49 58.06
redo synch writes 2,473 2,180 1.32 13.95 956.82 5.02 13.05 159.96 1.19 1.07 -10.08
redo wastage 980,504 882,104 524.12 5,644.03 976.86 1,991.64 5,278.49 165.03 472.53 431.77 -8.63
redo write time 784 1,022 0.42 6.54 1,457.14 1.59 6.12 284.91 0.38 0.50 31.58
redo writer latching time 5 0 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
redo writes 2,246 2,064 1.20 13.21 1,000.83 4.56 12.35 170.83 1.08 1.01 -6.48
rollback changes - undo records applied 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
rollbacks only - consistent read gets 159 55 0.08 0.35 337.50 0.32 0.33 3.13 0.08 0.03 -62.50
rows fetched via callback 16,960 16,500 9.07 105.57 1,063.95 34.45 98.74 186.62 8.17 8.08 -1.10
session pga memory 11,498,144 7,518,544 6,146.26 48,106.47 682.70 23,355.54 44,990.78 92.63 5,541.27 3,680.15 -33.59
session pga memory max 38,826,656 12,237,136 20,754.54 78,297.80 277.26 78,866.44 73,226.71 -7.15 18,711.64 5,989.79 -67.99
session uga memory 34,360,181,400 12,886,771,104 18,367,010.43 82,454,411.43 348.93 69,793,933.08 77,114,115.02 10.49 16,559,123.57 6,307,768.53 -61.91
session uga memory max 18,476,416 14,514,732 9,876.45 92,870.72 840.32 37,530.12 86,855.79 131.43 8,904.30 7,104.62 -20.21
shared hash latch upgrades - no wait 2,275 1,830 1.22 11.71 859.84 4.62 10.95 137.01 1.10 0.90 -18.18
sorts (memory) 4,119 4,601 2.20 29.44 1,238.18 8.37 27.53 228.91 1.99 2.25 13.07
sorts (rows) 47,244 55,967 25.25 358.10 1,318.22 95.96 334.91 249.01 22.77 27.39 20.29
sql area evicted 1,089 391 0.58 2.50 331.03 2.21 2.34 5.88 0.52 0.19 -63.46
summed dirty queue length 382 37 0.20 0.24 20.00 0.78 0.22 -71.79 0.18 0.02 -88.89
switch current to new buffer 20 10 0.01 0.06 500.00 0.04 0.06 50.00 0.01 0.00 -100.00
table fetch by rowid 26,892 45,352 14.37 290.18 1,919.35 54.62 271.39 396.87 12.96 22.20 71.30
table fetch continued row 228 373 0.12 2.39 1,891.67 0.46 2.23 384.78 0.11 0.18 63.64
table scan blocks gotten 53,331,826 1,552,500 28,508.18 9,933.48 -65.16 108,329.98 9,290.12 -91.42 25,702.08 759.91 -97.04
table scan rows gotten 8,653,895,624 262,154,185 4,625,883.36 1,677,361.14 -63.74 17,578,178.79 1,568,724.07 -91.08 4,170,552.11 128,318.25 -96.92
table scans (long tables) 16,002 1 8.55 0.01 -99.88 32.50 0.01 -99.97 7.71 0.00 -100.00
table scans (short tables) 1,275 1,148 0.68 7.35 980.88 2.59 6.87 165.25 0.61 0.56 -8.20
transaction rollbacks 2 2 0.00 0.01 100.00 0.00 0.01 100.00 0.00 0.00 0.00
undo change vector size 1,462,984 1,223,524 782.03 7,828.57 901.06 2,971.68 7,321.54 146.38 705.05 598.89 -15.06

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

  • Ordered by Differences of normalized IOs (Avg Reads/Sec + Avg Writes/Sec) desc
  • Only contains tablespaces with at least 100 IOs
  • 'N/A' indicates the tablespace did not exist in the database for the period
  Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms)
Tablespace 1st 2nd %Diff 1st 2nd %Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
SYSTEM 0.66 3.02 357.58 0.04 0.16 300.00 326 505 0.03 0.02 1.00 1.00 21 26 0 0 0.00 0.00
SYSAUX 0.72 5.62 680.56 1.69 0.33 -80.47 353 939 0.17 0.27 1.00 1.00 833 55 0 0 0.00 0.00
USERS 2,071.69 0.60 -99.97 0.01 0.08 700.00 1,019,913 101 0.07 0.10 3.19 6.28 3 13 532,785 0 0.38 0.00

Back to IO Stats
Back to Top

Top 10 File Comparison by IO

  • Ordered by files with greatest normalized IOs (Avg Reads/Sec + Avg Writes/Sec) from either period descending
  • Only contains files with at least 100 IOs
    Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms)
Tablespace Filename 1st 2nd %Diff 1st 2nd %Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
USERS /opt/app/oracle/oradata/o102ee1/users01.dbf 2,071.69 0.60 -99.97 0.01 0.08 700.00 1,019,913 101 0.07 0.10 3.19 6.28 3 13 532,785 0 0.38 0.00
SYSAUX /opt/app/oracle/oradata/o102ee1/sysaux01.dbf 0.72 5.62 680.56 1.69 0.33 -80.47 353 939 0.17 0.27 1.00 1.00 833 55 0 0 0.00 0.00
SYSTEM /opt/app/oracle/oradata/o102ee1/system01.dbf 0.66 3.02 357.58 0.04 0.16 300.00 326 505 0.03 0.02 1.00 1.00 21 26 0 0 0.00 0.00

Back to IO Stats
Back to Top

Top 10 File Comparison by Read Time

  • Ordered by files with greatest 'Read Time % of DB Time' from either period descending
  • Only contains files with at least 100 IOs
    Read Time % of DB Time Avg Read Time (ms) Reads Avg Reads / Sec Avg Blocks / Read Writes Avg Writes / Sec Buffer Waits Avg Buf Wait Time (ms)
Tablespace Filename 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
USERS /opt/app/oracle/oradata/o102ee1/users01.dbf 4.00 0.01 -3.99 0.07 0.10 1,019,913 101 2,071.69 0.60 3.19 6.28 3 13 0.01 0.08 532,785 0 0.04 0.00
SYSAUX /opt/app/oracle/oradata/o102ee1/sysaux01.dbf 0.00 0.16 0.16 0.17 0.27 353 939 0.72 5.62 1.00 1.00 833 55 1.69 0.33 0 0 0.00 0.00
SYSTEM /opt/app/oracle/oradata/o102ee1/system01.dbf 0.00 0.01 0.01 0.03 0.02 326 505 0.66 3.02 1.00 1.00 21 26 0.04 0.16 0 0 0.00 0.00

Back to IO Stats
Back to Top

Top 10 File Comparison by Buffer Waits

  • Ordered by files with greatest 'Wait Time % of DB Time' from either period descending
  • Contains only entries with at least 1 second of wait time
    Read Time % of DB Time Avg Read Time (ms) Reads Avg Reads / Sec Avg Blocks / Read Writes Avg Writes / Sec Buffer Waits Avg Buf Wait Time (ms)
Tablespace Filename 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
USERS /opt/app/oracle/oradata/o102ee1/users01.dbf 4.00 0.01 -3.99 0.07 0.10 1,019,913 101 2,071.69 0.60 3.19 6.28 3 13 0.01 0.08 532,785 0 0.04 0.00
SYSAUX /opt/app/oracle/oradata/o102ee1/sysaux01.dbf 0.00 0.16 0.16 0.17 0.27 353 939 0.72 5.62 1.00 1.00 833 55 1.69 0.33 0 0 0.00 0.00
SYSTEM /opt/app/oracle/oradata/o102ee1/system01.dbf 0.00 0.01 0.01 0.03 0.02 326 505 0.66 3.02 1.00 1.00 21 26 0.04 0.16 0 0 0.00 0.00

Back to IO Stats
Back to Top

 

Advisory Statistics

Back to Top

PGA Aggregate Summary

  • PGA Cache Hit % - percentage of W/A (Work Area) data processed in-memory only
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
1st 2nd Diff 1st 2nd %Diff 1st 2nd 1st 2nd %Diff 1st 2nd
100.00 100.00 0.00 16,888 233,314 1,281.58 30 35 0 0 0.00 0 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  • B1: 1st begin snap E1: 1st end snap B2: 2nd begin snap E2: 2nd end snap
  • Data shown in the table represent absolute value, i.e. not diffed over the interval)
  • Auto PGA Target - actual workarea memory target
  • W/A PGA Used - amount of memory used for all Workareas (manual + auto)
  • %PGA W/A Mem - percentage of PGA memory allocated to workareas
  • %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
  • %Man W/A Mem - percentage of workarea memory under manual control
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 Mem Global Mem Bound(K)
B1 16 4 85.4 0.0 0.0 0.0 0.0 3,276
E1 16 4 86.0 0.0 0.0 0.0 0.0 3,276
                 
B2 16 4 89.4 0.7 0.7 100.0 0.0 3,276
E2 16 4 92.8 0.7 0.7 100.0 0.0 3,276

Back to Advisory Statistics
Back to Top

 

Wait Stats

Back to Top

Buffer Wait Statistics

  • Ordered by 'Diff' column of 'Wait Time % of DB time' descending
  Wait Time % DB Time Total Wait Time (s) # Waits Avg Wait Time (ms)
Class 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd %Diff
data block 0.11 0.00 -0.11 202.37 0.00 532,796 0 0.00 0.00 0.00

Back to Wait Stats
Back to Top

 

Enqueue Activity

No data exists for this section of the report.

Back to Wait Stats
Back to Top

 

Latch Sleep Breakdown

  • Ordered by 'Diff' Column of '% of Total Sleeps' descending
  % of Total Sleeps Get Requests Misses Spin Gets Sleeps Sleep1 Sleep2 Sleep3
Latch Name 1st 2nd Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
shared pool 5.50 84.36 78.86 977,411 988,664 36,195 39,391 35,937 38,896 307 518 0 0 0 0 0 0
cache buffers chains 54.54 0.00 -54.54 111,191,175 3,709,197 1,967,362 964 1,965,138 964 3,042 0 0 0 0 0 0 0
simulator lru latch 36.86 0.00 -36.86 6,592,701 114,371 384,605 0 382,938 0 2,056 0 0 0 0 0 0 0
library cache 1.29 14.01 12.72 849,627 749,083 11,093 11,817 11,038 11,734 72 86 0 0 0 0 0 0
cache buffers lru chain 0.75 0.00 -0.75 7,403 476 864 0 830 0 42 0 0 0 0 0 0 0
kks stats 0.09 0.81 0.72 170,836 174,078 716 606 713 602 5 5 0 0 0 0 0 0
multiblock read objects 0.57 0.00 -0.57 2,015,384 138 5,524 0 5,502 0 32 0 0 0 0 0 0 0
row cache objects 0.14 0.49 0.35 407,529 699,017 20,635 35,945 20,631 35,942 8 3 0 0 0 0 0 0
enqueue hash chains 0.00 0.16 0.16 72,409 65,230 343 384 343 383 0 1 0 0 0 0 0 0
enqueues 0.00 0.16 0.16 62,482 58,181 998 1,044 998 1,043 0 1 0 0 0 0 0 0
simulator hash latch 0.13 0.00 -0.13 12,310,453 114,734 963 0 958 0 7 0 0 0 0 0 0 0
library cache lock 0.07 0.00 -0.07 222,573 218,571 884 1,021 882 1,021 4 0 0 0 0 0 0 0
object queue header operation 0.04 0.00 -0.04 6,534,010 6,633 44 0 42 0 2 0 0 0 0 0 0 0
library cache pin 0.02 0.00 -0.02 210,084 206,204 654 713 653 713 1 0 0 0 0 0 0 0


Back to Top

 

Segment Statistics

Back to Top

Top 5 Segments Comparison by Logical Reads

  • Ordered by 'Diff' column of '% of Total Logical Reads'
  • 'N/A' indicates no data was captured for the segment in the period
          % of Total Logical Reads Logical Reads
Owner Tablespace Object Name Subobject Name Type 1st 2nd Diff 1st 2nd
SCOTT USERS EMP1   TABLE 96.42 0.76 -95.66 51,813,408 14,416
SCOTT USERS EMP3   TABLE 2.90 81.92 79.02 1,558,448 1,557,840
SCOTT USERS IND_EMP1_DEPTNO   INDEX 0.25 7.16 6.91 132,416 136,128
SCOTT USERS IND_EMP1_EMP1NO   INDEX   2.60 2.60   49,504
SCOTT USERS PK_EMP2   INDEX 0.05 1.35 1.30 29,264 25,712
SCOTT USERS PK_DEPT   INDEX 0.02 0.21 0.19 9,696 4,000

Back to Segment Statistics
Back to Top

Top 5 Segments Comparison by Physical Reads

  • Ordered by 'Diff' column of '% of Total Physical Reads'
  • 'N/A' indicates no data was captured for the segment in the period
          % of Total Physical Reads Physical Reads
Owner Tablespace Object Name Subobject Name Type 1st 2nd Diff 1st 2nd
SCOTT USERS EMP1   TABLE 99.61 1.20 -98.40 3,254,786 24
SCOTT USERS EMP3   TABLE 0.00 29.84 29.84 17 595
SYS SYSTEM HISTGRM$   TABLE 0.01 15.05 15.04 189 300
SYS SYSAUX WRH$_SQL_PLAN   TABLE   12.59 12.59   251
SYS SYSAUX WRH$_SQL_PLAN_PK   INDEX 0.00 6.42 6.42 57 128
SYS SYSAUX WRH$_SQLTEXT   TABLE 0.00 4.71 4.71 46 94
SCOTT USERS EMP2   TABLE 0.00 0.70 0.70 23 14

Back to Segment Statistics
Back to Top

 

Top 5 Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

 

Top 5 Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

 

Top 5 Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

 

Dictionary Cache Statistics

  • Ordered by cache
  Get Requests / Sec (DB Time) Get Requests / Sec (Elapsed Time) Get Requests Pct Miss Scan Requests Pct Miss Mod Reqs Final Usage
Cache 1st 2nd %Diff 1st 2nd %Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
dc_awr_control 0.01 0.04 300.00 0.02 0.04 100.00 12 7 0.00 57.14 0 0 0.00 0.00 2 2 1 1
dc_global_oids 0.41 2.27 453.66 1.56 2.12 35.90 769 355 3.64 11.83 0 0 0.00 0.00 0 0 19 15
dc_histogram_data 1.56 28.07 1,699.36 5.91 26.25 344.16 2,911 4,387 47.72 46.96 0 0 0.00 0.00 0 0 1,031 649
dc_histogram_defs 19.79 241.88 1,122.23 75.20 226.22 200.82 37,023 37,804 6.44 8.35 0 0 0.00 0.00 0 0 1,254 949
dc_object_grants 0.03 0.57 1,800.00 0.12 0.53 341.67 58 89 29.31 59.55 0 0 0.00 0.00 0 0 17 14
dc_object_ids 18.93 637.84 3,269.47 71.92 596.53 729.44 35,408 99,688 0.86 0.44 0 0 0.00 0.00 0 0 431 355
dc_objects 9.51 117.99 1,140.69 36.12 110.34 205.48 17,783 18,440 2.82 3.56 0 0 0.00 0.00 0 0 400 322
dc_profiles 0.01 0.08 700.00 0.04 0.07 75.00 18 12 0.00 0.00 0 0 0.00 0.00 0 0 1 1
dc_rollback_segments 0.03 0.13 333.33 0.11 0.13 18.18 54 21 0.00 0.00 0 0 0.00 0.00 0 0 12 12
dc_segments 17.79 316.39 1,678.47 67.59 295.90 337.79 33,277 49,448 2.00 1.41 0 0 0.00 0.00 2 0 401 327
dc_sequences 0.00 0.03 100.00 0.01 0.03 200.00 3 5 100.00 100.00 0 0 0.00 0.00 3 5 0 0
dc_tablespaces 2.05 20.01 876.10 7.81 18.72 139.69 3,844 3,128 0.10 0.13 0 0 0.00 0.00 0 0 5 4
dc_usernames 0.24 4.72 1,866.67 0.91 4.41 384.62 447 737 0.22 0.95 0 0 0.00 0.00 0 0 6 6
dc_users 2.60 127.58 4,806.92 9.86 119.32 1,110.14 4,855 19,940 0.25 0.12 0 0 0.00 0.00 0 0 21 14
outstanding_alerts 0.01 0.00 -100.00 0.02 0.00 -100.00 12 0 83.33 0.00 0 0 0.00 0.00 0 0 0 0


Back to Top

 

Library Cache Activity

  • Ordered by namespace
  Get Requests / Sec (DB Time) Get Requests / Sec (Elapsed Time) Get Requests Pct Miss Pin Requests Pct Miss Reloads Invalidations
Namespace 1st 2nd %Diff 1st 2nd %Diff 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd 1st 2nd
BODY 0.05 0.44 780.00 0.19 0.41 115.79 93 68 3.23 11.76 828 368 2.17 6.52 15 16 0 0
CLUSTER 0.01 0.29 2,800.00 0.04 0.27 575.00 20 45 0.00 2.22 39 95 5.13 3.16 2 2 0 0
INDEX 0.01 0.13 1,200.00 0.04 0.12 200.00 20 20 95.00 65.00 20 22 95.00 77.27 0 4 0 0
SQL AREA 14.57 173.70 1,092.18 55.35 162.45 193.50 27,249 27,147 96.22 98.57 121,913 122,187 65.11 65.42 205 352 87 62
TABLE/PROCEDURE 0.79 13.90 1,659.49 3.00 13.00 333.33 1,479 2,172 7.91 14.69 84,139 83,432 1.93 2.29 823 678 0 0
TRIGGER 0.00 0.04 100.00 0.01 0.04 300.00 6 6 0.00 33.33 36 37 5.56 16.22 2 4 0 0


Back to Top

 

SGA Statistics

Back to Top

SGA Memory Summary

  Size (KB)
SGA regions 1st 2nd
Database Buffers 94,208.00 94,208.00
Fixed Size 1,231.69 1,231.69
Redo Buffers 6,960.00 6,960.00
Variable Size 159,744.31 159,744.31

Back to SGA Statistics
Back to Top

SGA breakdown difference

    1st 2nd    
Pool Name Begin Value End Value %Diff Begin Value End Value %Diff %Diff of Begin Values %Diff of End Values
java free memory 4,194,304 4,194,304 0.00 4,194,304 4,194,304 0.00 0.00 0.00
large PX msg pool 1,074,012 1,074,012 0.00 1,074,012 1,074,012 0.00 0.00 0.00
large free memory 3,120,292 3,120,292 0.00 3,120,292 3,120,292 0.00 0.00 0.00
shared ASH buffers 5,368,712 5,368,712 0.00 5,368,712 5,368,712 0.00 0.00 0.00
shared CCursor 6,887,808 9,966,012 44.69 3,311,824 6,938,000 109.49 -51.92 -30.38
shared Cursor Stats 1,923,500 1,923,500 0.00 1,923,500 1,923,500 0.00 0.00 0.00
shared KCB Table Scan Buffer 3,981,204 3,981,204 0.00 3,981,204 3,981,204 0.00 0.00 0.00
shared KGH: NO ACCESS 24,977,744 24,977,744 0.00 24,985,920 16,662,720 -33.31 0.03 -33.29
shared KSFD SGA I/O b 3,977,140 3,977,140 0.00 3,977,140 3,977,140 0.00 0.00 0.00
shared KTI-UNDO 3,774,540 3,774,540 0.00 3,774,540 3,774,540 0.00 0.00 0.00
shared PCursor 5,107,268 6,821,088 33.56 2,220,176 4,855,332 118.69 -56.53 -28.82
shared event statistics per sess 4,032,000 4,032,000 0.00 4,032,000 4,032,000 0.00 0.00 0.00
shared free memory 46,318,896 41,056,596 -11.36 52,822,984 46,885,004 -11.24 14.04 14.20
shared kglsim hash table bkts 2,097,152 2,097,152 0.00 2,097,152 2,097,152 0.00 0.00 0.00
shared kglsim heap 3,323,408 3,323,408 0.00 3,323,408 3,323,408 0.00 0.00 0.00
shared kglsim object batch 4,707,920 4,707,920 0.00 4,707,920 4,707,920 0.00 0.00 0.00
shared library cache 7,000,100 7,154,376 2.20 5,646,348 6,529,652 15.64 -19.34 -8.73
shared private strands 3,660,800 3,660,800 0.00 3,660,800 3,660,800 0.00 0.00 0.00
shared row cache 3,755,444 3,755,444 0.00 3,755,444 3,755,444 0.00 0.00 0.00
shared sessions 2,410,004 2,410,004 0.00 2,410,004 2,410,004 0.00 0.00 0.00
shared sql area 5,793,540 8,924,632 54.04 13,485,644 3,606,320 -73.26 132.77 -59.59
  buffer_cache 96,468,992 96,468,992 0.00 96,468,992 96,468,992 0.00 0.00 0.00
  fixed_sga 1,261,248 1,261,248 0.00 1,261,248 1,261,248 0.00 0.00 0.00
  log_buffer 7,127,040 7,127,040 0.00 7,127,040 7,127,040 0.00 0.00 0.00

Back to SGA Statistics
Back to Top

 

init.ora Parameters

  • Only parameters that are set differently are shown for the second period.
Parameter Name 1st End Snap Value 2nd End Snap Value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE  
__db_cache_size 96468992  
__dg_broker_service_names o102ee1_XPT  
__java_pool_size 4194304  
__large_pool_size 4194304  
__shared_pool_size 155189248  
__streams_pool_size 0  
aq_tm_processes 0  
archive_lag_target 0  
asm_power_limit 1  
audit_file_dest /opt/app/oracle/admin/o102ee1/ad  
audit_sys_operations FALSE  
audit_trail NONE  
background_core_dump partial  
background_dump_dest /opt/app/oracle/admin/o102ee1/bd  
backup_tape_io_slaves FALSE  
bitmap_merge_area_size 1048576  
blank_trimming FALSE  
cluster_database FALSE  
cluster_database_instances 1  
commit_point_strength 1  
compatible 10.2.0.3.0  
control_file_record_keep_time 7  
control_files /opt/app/oracle/oradata/o102ee1/  
core_dump_dest /opt/app/oracle/admin/o102ee1/cd  
cpu_count 4  
create_bitmap_area_size 8388608  
cursor_sharing EXACT  
cursor_space_for_time FALSE  
db_16k_cache_size 0  
db_2k_cache_size 0  
db_32k_cache_size 0  
db_4k_cache_size 0  
db_8k_cache_size 0  
db_block_buffers 0  
db_block_checking FALSE  
db_block_checksum TRUE  
db_block_size 8192  
db_cache_advice ON  
db_cache_size 0  
db_file_multiblock_read_count 41  
db_files 200  
db_flashback_retention_target 1440  
db_keep_cache_size 0  
db_name o102ee1  
db_recovery_file_dest /opt/app/oracle/flash_recovery_a  
db_recovery_file_dest_size 2147483648  
db_recycle_cache_size 0  
db_unique_name o102ee1  
db_writer_processes 1  
dbwr_io_slaves 0  
ddl_wait_for_locks FALSE  
dg_broker_config_file1 /opt/app/oracle/product/10.2.0/d  
dg_broker_config_file2 /opt/app/oracle/product/10.2.0/d  
dg_broker_start FALSE  
disk_asynch_io TRUE  
distributed_lock_timeout 60  
dml_locks 2200  
drs_start FALSE  
fast_start_io_target 0  
fast_start_mttr_target 0  
fast_start_parallel_rollback LOW  
file_mapping FALSE  
filesystemio_options none  
gcs_server_processes 0  
global_names FALSE  
hash_area_size 131072  
hi_shared_memory_address 0  
hs_autoregister TRUE  
instance_name o102ee1  
instance_number 0  
instance_type RDBMS  
java_max_sessionspace_size 0  
java_pool_size 0  
java_soft_sessionspace_limit 0  
job_queue_processes 10  
large_pool_size 0  
ldap_directory_access NONE  
license_max_sessions 0  
license_max_users 0  
license_sessions_warning 0  
lock_sga FALSE  
log_archive_dest_state_1 enable  
log_archive_dest_state_10 enable  
log_archive_dest_state_2 enable  
log_archive_dest_state_3 enable  
log_archive_dest_state_4 enable  
log_archive_dest_state_5 enable  
log_archive_dest_state_6 enable  
log_archive_dest_state_7 enable  
log_archive_dest_state_8 enable  
log_archive_dest_state_9 enable  
log_archive_format %t_%s_%r.dbf  
log_archive_local_first TRUE  
log_archive_max_processes 2  
log_archive_min_succeed_dest 1  
log_archive_start FALSE  
log_archive_trace 0  
log_buffer 7016448  
log_checkpoint_interval 0  
log_checkpoint_timeout 1800  
log_checkpoints_to_alert FALSE  
logmnr_max_persistent_sessions 1  
max_commit_propagation_delay 0  
max_dump_file_size UNLIMITED  
max_enabled_roles 150  
nls_language JAPANESE  
nls_length_semantics BYTE  
nls_nchar_conv_excp FALSE  
nls_territory JAPAN  
object_cache_max_size_percent 10  
object_cache_optimal_size 102400  
olap_page_pool_size 0  
open_cursors 1024  
open_links 4  
open_links_per_instance 4  
optimizer_dynamic_sampling 2  
optimizer_features_enable 10.2.0.3  
optimizer_index_caching 0  
optimizer_index_cost_adj 100  
optimizer_mode ALL_ROWS  
optimizer_secure_view_merging TRUE  
os_authent_prefix ops$  
os_roles FALSE  
parallel_adaptive_multi_user TRUE  
parallel_automatic_tuning FALSE  
parallel_execution_message_size 2148  
parallel_max_servers 80  
parallel_min_percent 0  
parallel_min_servers 0  
parallel_server FALSE  
parallel_server_instances 1  
parallel_threads_per_cpu 2  
pga_aggregate_target 16777216  
plsql_code_type INTERPRETED  
plsql_compiler_flags INTERPRETED, NON_DEBUG  
plsql_debug FALSE  
plsql_native_library_subdir_count 0  
plsql_optimize_level 2  
plsql_v2_compatibility FALSE  
plsql_warnings DISABLE:ALL  
pre_page_sga FALSE  
processes 150  
query_rewrite_enabled TRUE  
query_rewrite_integrity enforced  
read_only_open_delayed FALSE  
recovery_parallelism 0  
recyclebin on  
remote_archive_enable true  
remote_dependencies_mode TIMESTAMP  
remote_login_passwordfile EXCLUSIVE  
remote_os_authent FALSE  
remote_os_roles FALSE  
replication_dependency_tracking TRUE  
resource_limit FALSE  
resumable_timeout 0  
serial_reuse disable  
service_names o102ee1  
session_cached_cursors 20  
session_max_open_files 10  
sessions 500  
sga_max_size 268435456  
sga_target 268435456  
shadow_core_dump partial  
shared_memory_address 0  
shared_pool_reserved_size 3984588  
shared_pool_size 0  
shared_servers 0  
skip_unusable_indexes TRUE  
sort_area_retained_size 0  
sort_area_size 65536  
sql92_security FALSE  
sql_trace FALSE  
sql_version NATIVE  
sqltune_category DEFAULT  
standby_archive_dest ?/dbs/arch  
standby_file_management MANUAL  
star_transformation_enabled FALSE  
statistics_level TYPICAL  
streams_pool_size 0  
tape_asynch_io TRUE  
thread 0  
timed_os_statistics 0  
timed_statistics TRUE  
trace_enabled TRUE  
transactions 550  
transactions_per_rollback_segment 5  
undo_management AUTO  
undo_retention 900  
undo_tablespace UNDOTBS1  
use_indirect_data_buffers FALSE  
user_dump_dest /opt/app/oracle/admin/o102ee1/ud  
workarea_size_policy AUTO  


Back to Top