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 7882 18-Apr-07 14:09:36 7883 18-Apr-07 14:17:43 8.12 7.80 0.96
2nd 7884 18-Apr-07 14:26:52 7888 18-Apr-07 14:35:24 8.54 8.26 1.02

 

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: 2,873.51 17,292.09 501.78 15,907.41 84,360.38 430.32
Logical reads: 66,622.36 63,487.14 -4.71 368,813.08 309,725.33 -16.02
Block changes: 11.04 64.14 480.98 61.11 61.11 0.00
Physical reads: 14,389.36 15,282.45 6.21 79,657.72 74,556.25 -6.40
Physical writes: 1.76 3.23 83.52 9.74 15.77 61.91
User calls: 63.72 60.66 -4.80 352.74 295.94 -16.10
Parses: 23.26 23.02 -1.03 128.76 112.30 -12.78
Hard parses: 20.63 19.57 -5.14 114.18 95.50 -16.36
Sorts: 1.86 1.97 5.91 10.28 9.62 -6.42
Logons: 0.03 0.04 33.33 0.16 0.20 25.00
Executes: 27.09 26.98 -0.41 149.95 131.61 -12.23
Transactions: 0.18 0.20 11.11      
1st 2nd Diff
% Blocks changed per Read: 0.02 0.10 0.08
Recursive Call %: 46.05 50.39 4.34
Rollback per transaction %: 4.55 1.90 -2.64
Rows per Sort: 12.10 30.55 18.45
Avg Length of Calls (sec): 0.02 0.02 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   459.9 98.30   CPU time   485.8 97.98  
db file scattered read 420,223 91.7 19.61 User I/O db file scattered read 502,214 101.7 20.51 User I/O
control file parallel write 160 6.8 1.45 System I/O control file parallel write 216 7.6 1.53 System I/O
db file sequential read 170,518 3.7 .80 User I/O db file sequential read 220,044 5.1 1.03 User I/O
log file parallel write 120 1.0 .20 System I/O log file parallel write 171 1.7 .34 System I/O

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
db file scattered read 19.61 20.51 0.91 862.60 980.41 13.66 0.22 0.20 -9.09
db file sequential read 0.80 1.03 0.23 350.03 429.57 22.72 0.02 0.02 0.00
log file parallel write 0.20 0.34 0.13 0.25 0.33 32.00 7.96 9.79 22.99
control file parallel write 1.45 1.53 0.07 0.33 0.42 27.27 42.52 35.05 -17.57
log file sync 0.09 0.07 -0.01 0.09 0.09 0.00 8.91 8.22 -7.74
control file sequential read 0.00 0.01 0.00 1.59 5.46 243.40 0.01 0.01 0.00
SQL*Net message to client 0.02 0.02 -0.00 43.04 40.99 -4.76 0.00 0.00 0.00
latch: shared pool 0.00 0.00 0.00 0.01 0.00 -100.00 1.26 2.79 121.43
SQL*Net break/reset to client 0.00 0.00 -0.00 0.09 0.07 -22.22 0.28 0.30 7.14
rdbms ipc reply 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.35 100.00
LGWR wait for redo copy 0.00 0.00 0.00 0.01 0.02 100.00 0.07 0.08 14.29
SQL*Net more data from client 0.00 0.00 -0.00 0.00 0.00 0.00 0.01 0.01 0.00
SQL*Net message from client 269.68 314.89 45.21 43.04 40.99 -4.76 60.18 74.36 23.56
Streams AQ: qmn coordinator idle wait 103.70 104.79 1.08 0.08 0.07 -12.50 13,114.05 13,672.50 4.26
Streams AQ: qmn slave idle wait 103.70 104.79 1.08 0.04 0.04 0.00 26,956.78 27,345.12 1.44
wait for unread message on broadcast channel 101.70 100.74 -0.96 1.00 1.00 0.00 977.10 977.46 0.04
jobq slave wait 100.78 100.99 0.21 0.33 0.33 0.00 2,910.75 2,928.27 0.60
Streams AQ: waiting for messages in the queue 100.25 100.46 0.21 0.20 0.20 0.00 4,835.77 4,883.18 0.98
SGA: MMAN sleep for component shrink 0.00 0.00 -0.00 0.00 0.00 0.00 9.99 0.09 -99.10


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 467.90 495.82 5.32 4.72 -11.28
DB CPU 98.30 97.98 -0.31 459.93 485.83 5.23 4.63 -11.47
parse time elapsed 3.07 2.81 -0.27 14.37 13.91 0.16 0.13 -18.75
hard parse elapsed time 2.37 2.14 -0.24 11.10 10.60 0.13 0.10 -23.08
sql execute elapsed time 96.63 96.83 0.20 452.13 480.10 5.14 4.57 -11.09
PL/SQL execution elapsed time 0.10 0.22 0.12 0.48 1.11 0.01 0.01 0.00
connection management call elapsed time 0.01 0.03 0.02 0.04 0.16 0.00 0.00 0.00
PL/SQL compilation elapsed time 0.02 0.01 -0.01 0.10 0.05 0.00 0.00 0.00
hard parse (sharing criteria) elapsed time 0.01 0.00 -0.01 0.04 0.00 0.00 0.00 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00 -0.00 0.00 0.00 0.00 0.00 0.00
sequence load elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
repeated bind elapsed time 0.00 0.00 -0.00 0.00 0.00 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 2.65 3.36 0.71 12.42 16.66 0.14 0.16 14.29
background cpu time 0.26 0.38 0.12 1.22 1.88 0.01 0.02 100.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 53,882 57,038 115 115 -0.10 111 111 0.67 612 543 -11.28
IDLE_TIME 140,881 147,751 301 298 -1.03 289 288 -0.26 1,601 1,407 -12.10
IOWAIT_TIME 1,331 1,700 3 3 20.77 3 3 21.61 15 16 7.01
LOAD 1 1 0 0 0.00 0 0 0.00 0 0 0.00
NICE_TIME 308 358 1 1 9.09 1 1 11.11 4 3 -2.57
NUM_CPU_SOCKETS 0 0 0 0 0.00 0 0 0.00 0 0 0.00
PHYSICAL_MEMORY_BYTES 7,872 -2,360 17 -5 -128.30 16 -5 -128.53 89 -22 -125.13
RSRC_MGR_CPU_WAIT_TIME 0 0 0 0 0.00 0 0 0.00 0 0 0.00
SYS_TIME 12,748 13,909 27 28 2.94 26 27 3.74 145 132 -8.55
USER_TIME 40,779 42,720 87 86 -1.14 84 83 -0.37 463 407 -12.20


Back to Top

 

Service Statistics

Back to Top

Service Statistics

  • Ordered by 'Diff' column of 'DB time %' descending
  • Total DB Time First: 467.9 seconds, Second: 495.82 seconds
  • Total CPU Time First: 459.93 seconds, Second: 485.83 seconds
  • Total Physical Reads First: 7009879, Second: 7828406
  • Total Logical Reads First: 32455551, Second: 32521160
  % 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.73 99.78 0.05 99.77 99.82 0.04 100.00 99.99 -0.01 99.98 99.97 -0.00
o102ee1 0.27 0.22 -0.05 0.23 0.18 -0.04 0.00 0.00 0.00 0.02 0.01 -0.00
SYS$BACKGROUND 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.00 0.01 0.01

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: 96.63%, Second: 96.83%
  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
0cg8busnwuyh9 0.15 0.92 0.77 709 1,137 0.00 0.01 709 1,122 90.00 266.75 1.00 1.00 Yes BEGIN DBMS_WORKLOAD_REPOSITO...
bunssq950snhf 0.06 0.25 0.19 297 310 0.00 0.01 297 310 1.00 0.50 7.00 7.00 Yes insert into wrh$_sga_target_ad...
d92h3rjp0y217 0.01 0.06 0.05 40 73 0.00 0.01 40 66 4.00 2.50 1.00 1.00 Yes begin prvt_hdm.auto_execute( :...
0hbv80w9ypy0n 0.04   -0.04 192   0.00   192   8.00   0.00   No /* OracleOEM */ SELECT end_...
cb75rw3w1tt0s 0.08 0.11 0.03 1 2 0.63 0.62 1 2 0.00 0.23 1.00 1.00 Yes begin MGMT_JOB_ENGINE.get_sche...
9bymqgyftpgwu   0.03 0.03   133   0.00   133   1,565.00   0.00 No select emp1no, ename from emp1...
8hk7xvhua40va 0.04 0.01 -0.03 13 9 0.03 0.01 13 9 0.00 0.14 13.57 13.71 No INSERT INTO MGMT_METRICS_RAW(C...
amwpy3yxtzh4f   0.02 0.02   119   0.00   119   1,625.00   1.00 No select emp1no, ename from emp1...
6gvch1xu9ca3g 0.08 0.06 -0.02 47 31 0.02 0.02 42 26 2.25 0.11 1.00 1.00 Yes DECLARE job BINARY_INTEGER := ...
asg4rqz2wyz54   0.02 0.02   118   0.00   118   1,677.00   1.00 No select emp1no, ename from emp1...
a17nj4wsb5gcm 0.02   -0.02 110   0.00   106   1,662.00   1.00   No select emp1no, ename from emp1...
cwx13g8ysb2ub 0.02 0.00 -0.02 109 22 0.00 0.00 108 22 1,667.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
g0180fvp36gmw 0.02 0.00 -0.02 105 22 0.00 0.00 105 22 1,691.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
abtp0uqvdb1d3 0.02 0.01 -0.01 16 16 0.01 0.01 16 15 2.43 0.25 0.00 0.00 Yes CALL MGMT_ADMIN_DATA.EVALUATE_...
9whvap5tun47x 0.01 0.03 0.01 70 126 0.00 0.00 70 126 1,512.00 2,231.00 1.00 1.00 No select emp1no, ename from emp1...
ds09ud7x09avh 0.02 0.02 0.01 73 123 0.00 0.00 73 123 1,576.00 1,888.00 1.00 1.00 No select emp1no, ename from emp1...

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: 98.3%, Second: 97.98%
  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
0cg8busnwuyh9 0.15 0.91 0.75 709 1,122 0.00 0.01 709 1,137 90.00 266.75 1.00 1.00 Yes BEGIN DBMS_WORKLOAD_REPOSITO...
bunssq950snhf 0.06 0.25 0.19 297 310 0.00 0.01 297 310 1.00 0.50 7.00 7.00 Yes insert into wrh$_sga_target_ad...
d92h3rjp0y217 0.01 0.05 0.04 40 66 0.00 0.01 40 73 4.00 2.50 1.00 1.00 Yes begin prvt_hdm.auto_execute( :...
0hbv80w9ypy0n 0.04   -0.04 192   0.00   192   8.00   0.00   No /* OracleOEM */ SELECT end_...
9bymqgyftpgwu   0.03 0.03   133   0.00   133   1,565.00   0.00 No select emp1no, ename from emp1...
8hk7xvhua40va 0.04 0.01 -0.03 13 9 0.03 0.01 13 9 0.00 0.14 13.57 13.71 No INSERT INTO MGMT_METRICS_RAW(C...
amwpy3yxtzh4f   0.02 0.02   119   0.00   119   1,625.00   1.00 No select emp1no, ename from emp1...
asg4rqz2wyz54   0.02 0.02   118   0.00   118   1,677.00   1.00 No select emp1no, ename from emp1...
6gvch1xu9ca3g 0.07 0.05 -0.02 42 26 0.02 0.02 47 31 2.25 0.11 1.00 1.00 Yes DECLARE job BINARY_INTEGER := ...
a17nj4wsb5gcm 0.02   -0.02 106   0.00   110   1,662.00   1.00   No select emp1no, ename from emp1...
cwx13g8ysb2ub 0.02 0.00 -0.02 108 22 0.00 0.00 109 22 1,667.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
cb75rw3w1tt0s 0.08 0.10 0.02 1 2 0.63 0.62 1 2 0.00 0.23 1.00 1.00 Yes begin MGMT_JOB_ENGINE.get_sche...
g0180fvp36gmw 0.02 0.00 -0.02 105 22 0.00 0.00 105 22 1,691.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
abtp0uqvdb1d3 0.02 0.01 -0.01 16 15 0.01 0.01 16 16 2.43 0.25 0.00 0.00 Yes CALL MGMT_ADMIN_DATA.EVALUATE_...
9whvap5tun47x 0.01 0.03 0.01 70 126 0.00 0.00 70 126 1,512.00 2,231.00 1.00 1.00 No select emp1no, ename from emp1...
ds09ud7x09avh 0.02 0.02 0.01 73 123 0.00 0.00 73 123 1,576.00 1,888.00 1.00 1.00 No select emp1no, ename from emp1...

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:32455551, Second: 32521160
  % 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
0cg8busnwuyh9 0.03 0.23 0.20 8,123.00 18,305.25 1 4 709 1,137 709 1,122 90.00 266.75 1.00 1.00 Yes BEGIN DBMS_WORKLOAD_REPOSITO...
d92h3rjp0y217 0.00 0.01 0.01 1,063.00 1,132.25 1 4 40 73 40 66 4.00 2.50 1.00 1.00 Yes begin prvt_hdm.auto_execute( :...
cm6k4tzqr38f7   0.01 0.01   3,264.00   1   53   40   0.00   1.00 No select emp1no, ename from emp1...
02wgnvau4y6fz 0.01   -0.01 3,243.00   1   22   22   0.00   1.00   No select emp1no, ename from emp1...
0013pqzx8kbfg   0.01 0.01   3,243.00   1   22   22   0.00   1.00 No select emp1no, ename from emp1...
004ykw9jpsh8g   0.01 0.01   3,243.00   1   75   75   1,506.00   1.00 No select emp1no, ename from emp1...
00dww3mzgs927   0.01 0.01   3,243.00   1   21   21   0.00   1.00 No select emp1no, ename from emp1...
00uyrt10qq3ks   0.01 0.01   3,243.00   1   21   21   0.00   1.00 No select emp1no, ename from emp1...
011tnwdfnd6rg   0.01 0.01   3,243.00   1   68   68   1,468.00   1.00 No select emp1no, ename from emp1...
0128jdhc4ngnq   0.01 0.01   3,243.00   1   22   22   0.00   1.00 No select emp1no, ename from emp1...
004kcfrmktkj2 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 78 22 78 22 1,686.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
01vkf625s61b9 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 22 22 22 22 0.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
02st69bsctjyh 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 71 22 71 22 1,602.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
02tkznbyqf5su 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 69 22 69 22 1,513.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
03336c2b57677 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 22 29 22 29 0.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
03464ty2n13zm 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 69 22 69 22 1,521.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
03u4yqx1rc5h6 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 76 21 76 21 1,682.00 0.00 1.00 1.00 No select emp1no, ename from emp1...
043k6frc9jhaa 0.01 0.01 -0.00 3,243.00 3,243.00 1 1 70 22 70 22 1,471.00 0.00 1.00 1.00 No select emp1no, ename from emp1...

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: 20.4%, Second: 21.54%
  • Total Physical Reads First: 7009879, Second: 7828406
  % 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
d97drcnr50s17 0.03   -0.03 1,782.00   1   82   82   1.00   No select emp1no, ename from emp1...
ccbc7uwnta3xd 0.03 0.00 -0.03 1,772.00 0.00 1 1 80 22 80 22 1.00 1.00 No select emp1no, ename from emp1...
gk4ph2gu4d55u 0.03 0.00 -0.03 1,769.00 0.00 1 1 80 23 80 23 1.00 1.00 No select emp1no, ename from emp1...
922v4j6cjat33 0.03 0.00 -0.03 1,766.00 0.00 1 1 79 22 79 22 1.00 1.00 No select emp1no, ename from emp1...
9uxf7690gxwgf 0.03 0.00 -0.03 1,763.00 0.00 1 1 92 22 92 22 1.00 1.00 No select emp1no, ename from emp1...
c4cm2gbpjfbhg 0.03 0.00 -0.03 1,762.00 0.00 1 1 80 22 80 22 1.00 1.00 No select emp1no, ename from emp1...
c629u0x2bmm0g 0.03 0.00 -0.03 1,761.00 0.00 1 1 80 23 80 23 1.00 1.00 No select emp1no, ename from emp1...
04yxjbx9k8679 0.03 0.00 -0.03 1,756.00 0.00 1 1 87 22 87 22 1.00 1.00 No select emp1no, ename from emp1...
4pu4m428cvj2q 0.03 0.00 -0.03 1,756.00 0.00 1 1 81 22 81 22 1.00 1.00 No select emp1no, ename from emp1...
5dvpduy7zztyb 0.03 0.00 -0.03 1,754.00 0.00 1 1 79 22 79 22 1.00 1.00 No select emp1no, ename from emp1...
92z27ctrgc1rt 0.02 0.03 0.01 1,540.00 2,322.00 1 1 71 105 71 105 1.00 1.00 No select emp1no, ename from emp1...
8bm3jtsppgfzw 0.02 0.03 0.01 1,557.00 2,313.00 1 1 72 102 72 102 1.00 1.00 No select emp1no, ename from emp1...
7xwd34tdu52f1 0.02 0.03 0.01 1,560.00 2,291.00 1 1 72 102 72 102 1.00 1.00 No select emp1no, ename from emp1...
gfr8zr790m35j 0.02 0.03 0.01 1,572.00 2,290.00 1 1 71 102 71 102 1.00 1.00 No select emp1no, ename from emp1...
csuc5prcz0trv 0.02 0.03 0.01 1,565.00 2,279.00 1 1 72 108 72 108 1.00 1.00 No select emp1no, ename from emp1...
akfj0252pyg54 0.02 0.03 0.01 1,559.00 2,268.00 1 1 71 100 71 100 1.00 1.00 No select emp1no, ename from emp1...
9mbf11kr6nsrf 0.02 0.03 0.01 1,578.00 2,277.00 1 1 72 100 72 100 1.00 1.00 No select emp1no, ename from emp1...
asnsx6h0pqgg5 0.02 0.03 0.01 1,565.00 2,261.00 1 1 71 100 71 100 1.00 1.00 No select emp1no, ename from emp1...
0u4a7zybtrq08 0.02 0.03 0.01 1,561.00 2,246.00 1 1 71 99 71 99 1.00 1.00 No select emp1no, ename from emp1...
8upvyyhz5fj4u 0.02 0.03 0.01 1,571.00 2,254.00 1 1 71 100 71 100 1.00 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: 96.63%, Second: 96.83%
  #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
5h7w8ykwtb2xt 0.11 0.43 0.31 53 212 0 0 0 0 0.08 0.05 1.00 1.00 Yes INSERT INTO SYS.WRI$_ADV_PARAM...
91h2x42zqagcm 0.45 0.23 -0.22 211 116 0 0 0 0 0.00 0.00 1.00 1.00 Yes UPDATE MGMT_CURRENT_METRICS SE...
350f5yrnnmshs 0.15 0.05 -0.10 71 24 0 0 0 0 0.00 0.00 0.00 0.00 No lock table sys.mon_mods$ in ex...
g00cj285jmgsw 0.15 0.05 -0.10 71 24 0 1 0 1 0.00 0.00 1.00 1.00 No update sys.mon_mods$ set inser...
04xtrk7uyhknh 0.08 0.10 0.02 36 50 0 0 0 0 0.03 0.00 0.86 0.98 Yes select obj#, type#, ctime, mti...
0h6b2sajwb74n 0.34 0.36 0.02 158 177 0 0 0 0 0.00 0.00 1.52 1.53 Yes select privilege#, level from ...
3c1kubcdjnppq 0.16 0.15 -0.01 77 75 0 0 0 0 0.01 0.00 1.00 1.00 No update sys.col_usage$ set eq...
089dbukv1aanh 0.65 0.64 -0.01 302 315 0 0 0 0 0.00 0.00 1.00 1.00 Yes SELECT SYS_EXTRACT_UTC(SYSTIME...
6gh8gj9n09vr7 0.63 0.62 -0.01 294 309 0 0 0 0 0.00 0.00 0.00 0.00 Yes SELECT JOB_ID, EXECUTION_ID, ...
cb75rw3w1tt0s 0.63 0.62 -0.01 294 309 1 2 1 2 0.00 0.23 1.00 1.00 Yes begin MGMT_JOB_ENGINE.get_sche...
g2wr3u7s1gtf3 0.19 0.19 -0.00 90 94 0 0 0 0 0.00 0.00 1.00 1.00 Yes select count(*) from sys.job$ ...
6ssrk2dqj7jbx 0.21 0.21 -0.00 98 103 0 0 0 0 0.00 0.00 0.08 0.09 Yes select job, nvl2(last_date, ...

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: 11331, Second: 11792
  % Total Parses Parses #Executions    
SQL Id 1st 2nd Diff 1st 2nd 1st 2nd Multiple Plans SQL Text
350f5yrnnmshs 0.63 0.20 -0.42 71 24 71 24 No lock table sys.mon_mods$ in ex...
g00cj285jmgsw 0.63 0.20 -0.42 71 24 71 24 No update sys.mon_mods$ set inser...
0h6b2sajwb74n 1.39 1.50 0.11 158 177 158 177 Yes select privilege#, level from ...
3c1kubcdjnppq 0.31 0.25 -0.06 35 29 77 75 No update sys.col_usage$ set eq...
53btfq0dt9bs9 0.31 0.25 -0.06 35 29 1 1 No insert into sys.col_usage$ val...
b2gnxm5z6r51n 0.31 0.25 -0.06 35 29 35 29 No lock table sys.col_usage$ in e...
39m4sx9k63ba2 0.16 0.14 -0.02 18 16 18 16 Yes select /*+ index(idl_ub2$ i_id...
c6awqs517jpj0 0.16 0.14 -0.02 18 16 18 16 Yes select /*+ index(idl_char$ i_i...
cvn54b7yz0s8u 0.16 0.14 -0.02 18 16 18 16 Yes select /*+ index(idl_ub1$ i_id...
ga9j9xk5cy9s0 0.16 0.14 -0.02 18 16 18 16 Yes select /*+ index(idl_sb4$ i_id...
24dkx03u3rj6k 0.14 0.15 0.01 16 18 24 27 Yes SELECT COUNT(*) FROM MGMT_PARA...
6129566gyvx21 0.15 0.14 -0.01 17 17 17 17 Yes SELECT INSTANTIABLE, supertyp...
2b064ybzkwf1y 0.14 0.14 0.00 16 17 16 17 Yes BEGIN EMD_NOTIFICATION.QUEUE_R...

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

 

SQL Id SQL Text
0013pqzx8kbfg select emp1no, ename from emp1 where emp1no = 3929
004kcfrmktkj2 select emp1no, ename from emp1 where emp1no = 9789
004ykw9jpsh8g select emp1no, ename from emp1 where emp1no = 5851
00dww3mzgs927 select emp1no, ename from emp1 where emp1no = 4346
00uyrt10qq3ks select emp1no, ename from emp1 where emp1no = 4354
011tnwdfnd6rg select emp1no, ename from emp1 where emp1no = 1147
0128jdhc4ngnq select emp1no, ename from emp1 where emp1no = 7736
01vkf625s61b9 select emp1no, ename from emp1 where emp1no = 8213
02st69bsctjyh select emp1no, ename from emp1 where emp1no = 9292
02tkznbyqf5su select emp1no, ename from emp1 where emp1no = 9427
02wgnvau4y6fz select emp1no, ename from emp1 where emp1no = 7029
03336c2b57677 select emp1no, ename from emp1 where emp1no = 8689
03464ty2n13zm select emp1no, ename from emp1 where emp1no = 8951
03u4yqx1rc5h6 select emp1no, ename from emp1 where emp1no = 9028
043k6frc9jhaa select emp1no, ename from emp1 where emp1no = 9517
04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
04yxjbx9k8679 select emp1no, ename from emp1 where emp1no = 8824
089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
0cg8busnwuyh9 BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); END;
0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hbv80w9ypy0n /* OracleOEM */ SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM v$rman_backup_job_details WHERE end_time = (select max(end_time) from v$rman_backup_job_details)
0u4a7zybtrq08 select emp1no, ename from emp1 where emp1no = 9965
24dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait
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
4pu4m428cvj2q select emp1no, ename from emp1 where emp1no = 8794
53btfq0dt9bs9 insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
5dvpduy7zztyb select emp1no, ename from emp1 where emp1no = 8818
5h7w8ykwtb2xt INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
6129566gyvx21 SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
6gh8gj9n09vr7 SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1
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;
6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
7xwd34tdu52f1 select emp1no, ename from emp1 where emp1no = 9865
8bm3jtsppgfzw select emp1no, ename from emp1 where emp1no = 9867
8hk7xvhua40va INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRING_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
8upvyyhz5fj4u select emp1no, ename from emp1 where emp1no = 9875
91h2x42zqagcm UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
922v4j6cjat33 select emp1no, ename from emp1 where emp1no = 8822
92z27ctrgc1rt select emp1no, ename from emp1 where emp1no = 9863
9bymqgyftpgwu select emp1no, ename from emp1 where emp1no = 0
9mbf11kr6nsrf select emp1no, ename from emp1 where emp1no = 9871
9uxf7690gxwgf select emp1no, ename from emp1 where emp1no = 8798
9whvap5tun47x select emp1no, ename from emp1 where emp1no = 9951
a17nj4wsb5gcm select emp1no, ename from emp1 where emp1no = 9765
abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
akfj0252pyg54 select emp1no, ename from emp1 where emp1no = 9879
amwpy3yxtzh4f select emp1no, ename from emp1 where emp1no = 4666
asg4rqz2wyz54 select emp1no, ename from emp1 where emp1no = 5207
asnsx6h0pqgg5 select emp1no, ename from emp1 where emp1no = 9877
b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait
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
c4cm2gbpjfbhg select emp1no, ename from emp1 where emp1no = 8800
c629u0x2bmm0g select emp1no, ename from emp1 where emp1no = 8808
c6awqs517jpj0 select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cb75rw3w1tt0s begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
ccbc7uwnta3xd select emp1no, ename from emp1 where emp1no = 8802
cm6k4tzqr38f7 select emp1no, ename from emp1 where emp1no = 4230
csuc5prcz0trv select emp1no, ename from emp1 where emp1no = 9873
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#
cwx13g8ysb2ub select emp1no, ename from emp1 where emp1no = 9070
d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
d97drcnr50s17 select emp1no, ename from emp1 where emp1no = 8796
ds09ud7x09avh select emp1no, ename from emp1 where emp1no = 9845
g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g0180fvp36gmw select emp1no, ename from emp1 where emp1no = 8838
g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
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#
gfr8zr790m35j select emp1no, ename from emp1 where emp1no = 9869
gk4ph2gu4d55u select emp1no, ename from emp1 where emp1no = 8810

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 1 1 0.00 0.00 0.00 0.00 0.00 0.00 0.01 0.01 0.00
concurrency wait time 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
db block changes 5,378 32,855 11.49 66.26 476.68 11.04 64.14 480.98 61.11 312.90 412.03
execute count 13,196 13,819 28.20 27.87 -1.17 27.09 26.98 -0.41 149.95 131.61 -12.23
logons cumulative 14 21 0.03 0.04 33.33 0.03 0.04 33.33 0.16 0.20 25.00
opened cursors cumulative 11,472 11,885 24.52 23.97 -2.24 23.55 23.20 -1.49 130.36 113.19 -13.17
parse count (total) 11,331 11,792 24.22 23.78 -1.82 23.26 23.02 -1.03 128.76 112.30 -12.78
parse time elapsed 1,417 1,454 3.03 2.93 -3.30 2.91 2.84 -2.41 16.10 13.85 -13.98
physical reads 7,009,879 7,828,406 14,981.73 15,788.76 5.39 14,389.36 15,282.45 6.21 79,657.72 74,556.25 -6.40
physical writes 857 1,656 1.83 3.34 82.51 1.76 3.23 83.52 9.74 15.77 61.91
redo size 1,399,852 8,857,840 2,991.81 17,864.98 497.13 2,873.51 17,292.09 501.78 15,907.41 84,360.38 430.32
session cursor cache hits 647 744 1.38 1.50 8.70 1.33 1.45 9.02 7.35 7.09 -3.54
session logical reads 32,455,551 32,521,160 69,365.02 65,590.47 -5.44 66,622.36 63,487.14 -4.71 368,813.08 309,725.33 -16.02
user I/O wait time 9,545 10,682 20.40 21.54 5.59 19.59 20.85 6.43 108.47 101.73 -6.21
user calls 31,041 31,074 66.34 62.67 -5.53 63.72 60.66 -4.80 352.74 295.94 -16.10
user commits 84 103 0.18 0.21 16.67 0.17 0.20 17.65 0.95 0.98 3.16
user rollbacks 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
workarea executions - multipass 0 0 0.00 0.00 0.00 0.00 0.00 0.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 495 537 1.06 1.08 1.89 1.02 1.05 2.94 5.63 5.11 -9.24

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 47,850 50,739 102.27 102.33 0.06 98.22 99.05 0.85 543.75 483.23 -11.13
CPU used when call started 47,772 50,616 102.10 102.09 -0.01 98.06 98.81 0.76 542.86 482.06 -11.20
CR blocks created 99 71 0.21 0.14 -33.33 0.20 0.14 -30.00 1.13 0.68 -39.82
DBWR checkpoint buffers written 851 1,474 1.82 2.97 63.19 1.75 2.88 64.57 9.67 14.04 45.19
DBWR transaction table writes 14 15 0.03 0.03 0.00 0.03 0.03 0.00 0.16 0.14 -12.50
DBWR undo block writes 110 252 0.24 0.51 112.50 0.23 0.49 113.04 1.25 2.40 92.00
IMU CR rollbacks 27 29 0.06 0.06 0.00 0.06 0.06 0.00 0.31 0.28 -9.68
IMU Flushes 121 131 0.26 0.26 0.00 0.25 0.26 4.00 1.38 1.25 -9.42
IMU Redo allocation size 102,332 49,608 218.71 100.05 -54.25 210.06 96.84 -53.90 1,162.86 472.46 -59.37
IMU commits 80 93 0.17 0.19 11.76 0.16 0.18 12.50 0.91 0.89 -2.20
IMU undo allocation size 275,288 274,812 588.35 554.26 -5.79 565.09 536.48 -5.06 3,128.27 2,617.26 -16.34
SMON posted for undo segment shrink 0 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 100.00
SQL*Net roundtrips to/from client 20,957 20,978 44.79 42.31 -5.54 43.02 40.95 -4.81 238.15 199.79 -16.11
active txn count during cleanout 49 420 0.10 0.85 750.00 0.10 0.82 720.00 0.56 4.00 614.29
background timeouts 1,555 1,636 3.32 3.30 -0.60 3.19 3.19 0.00 17.67 15.58 -11.83
branch node splits 0 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 100.00
buffer is not pinned count 8,533 34,330 18.24 69.24 279.61 17.52 67.02 282.53 96.97 326.95 237.17
buffer is pinned count 2,331 12,115 4.98 24.43 390.56 4.78 23.65 394.77 26.49 115.38 335.56
bytes received via SQL*Net from client 2,353,810 2,342,891 5,030.64 4,725.27 -6.07 4,831.73 4,573.74 -5.34 26,747.84 22,313.25 -16.58
bytes sent via SQL*Net to client 4,810,373 4,816,026 10,280.88 9,713.23 -5.52 9,874.38 9,401.75 -4.79 54,663.33 45,866.91 -16.09
calls to get snapshot scn: kcmgss 84,662 87,497 180.94 176.47 -2.47 173.79 170.81 -1.71 962.07 833.30 -13.38
calls to kcmgas 431 1,019 0.92 2.06 123.91 0.88 1.99 126.14 4.90 9.70 97.96
calls to kcmgcs 41 293 0.09 0.59 555.56 0.08 0.57 612.50 0.47 2.79 493.62
change write time 5 28 0.01 0.06 500.00 0.01 0.05 400.00 0.06 0.27 350.00
cleanout - number of ktugct calls 67 467 0.14 0.94 571.43 0.14 0.91 550.00 0.76 4.45 485.53
cleanouts only - consistent read gets 3 13 0.01 0.03 200.00 0.01 0.03 200.00 0.03 0.12 300.00
cluster key scan block gets 556 782 1.19 1.58 32.77 1.14 1.53 34.21 6.32 7.45 17.88
cluster key scans 155 122 0.33 0.25 -24.24 0.32 0.24 -25.00 1.76 1.16 -34.09
commit batch/immediate performed 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
commit batch/immediate requested 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
commit cleanout failures: callback failure 6 15 0.01 0.03 200.00 0.01 0.03 200.00 0.07 0.14 100.00
commit cleanouts 928 3,244 1.98 6.54 230.30 1.90 6.33 233.16 10.55 30.90 192.89
commit cleanouts successfully completed 922 3,229 1.97 6.51 230.46 1.89 6.30 233.33 10.48 30.75 193.42
commit immediate performed 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
commit immediate requested 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
commit txn count during cleanout 37 161 0.08 0.32 300.00 0.08 0.31 287.50 0.42 1.53 264.29
consistent changes 99 71 0.21 0.14 -33.33 0.20 0.14 -30.00 1.13 0.68 -39.82
consistent gets 32,450,820 32,488,654 69,354.91 65,524.91 -5.52 66,612.65 63,423.68 -4.79 368,759.32 309,415.75 -16.09
consistent gets - examination 7,574 37,870 16.19 76.38 371.77 15.55 73.93 375.43 86.07 360.67 319.04
consistent gets from cache 32,450,820 32,488,654 69,354.91 65,524.91 -5.52 66,612.65 63,423.68 -4.79 368,759.32 309,415.75 -16.09
cursor authentications 44 7 0.09 0.01 -88.89 0.09 0.01 -88.89 0.50 0.07 -86.00
data blocks consistent reads - undo records applied 99 71 0.21 0.14 -33.33 0.20 0.14 -30.00 1.13 0.68 -39.82
db block gets 4,731 32,506 10.11 65.56 548.47 9.71 63.46 553.55 53.76 309.58 475.86
db block gets from cache 4,731 32,506 10.11 65.56 548.47 9.71 63.46 553.55 53.76 309.58 475.86
deferred (CURRENT) block cleanout applications 656 2,294 1.40 4.63 230.71 1.35 4.48 231.85 7.45 21.85 193.29
dirty buffers inspected 1 55 0.00 0.11 100.00 0.00 0.11 100.00 0.01 0.52 5,100.00
enqueue conversions 100 112 0.21 0.23 9.52 0.21 0.22 4.76 1.14 1.07 -6.14
enqueue releases 14,875 15,744 31.79 31.75 -0.13 30.53 30.74 0.69 169.03 149.94 -11.29
enqueue requests 14,875 15,744 31.79 31.75 -0.13 30.53 30.74 0.69 169.03 149.94 -11.29
free buffer inspected 7,442,586 8,421,158 15,906.53 16,984.26 6.78 15,277.59 16,439.61 7.61 84,574.84 80,201.50 -5.17
free buffer requested 7,010,134 7,829,230 14,982.28 15,790.42 5.39 14,389.89 15,284.06 6.21 79,660.61 74,564.10 -6.40
heap block compress 4 15 0.01 0.03 200.00 0.01 0.03 200.00 0.05 0.14 180.00
hot buffers moved to head of LRU 263 1,883 0.56 3.80 578.57 0.54 3.68 581.48 2.99 17.93 499.67
immediate (CR) block cleanout applications 3 13 0.01 0.03 200.00 0.01 0.03 200.00 0.03 0.12 300.00
immediate (CURRENT) block cleanout applications 102 375 0.22 0.76 245.45 0.21 0.73 247.62 1.16 3.57 207.76
index crx upgrade (positioned) 1,294 1,337 2.77 2.70 -2.53 2.66 2.61 -1.88 14.70 12.73 -13.40
index fast full scans (full) 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
index fetch by key 3,656 18,480 7.81 37.27 377.21 7.50 36.08 381.07 41.55 176.00 323.59
index scans kdiixs1 2,460 2,525 5.26 5.09 -3.23 5.05 4.93 -2.38 27.95 24.05 -13.95
leaf node 90-10 splits 7 27 0.01 0.05 400.00 0.01 0.05 400.00 0.08 0.26 225.00
leaf node splits 18 117 0.04 0.24 500.00 0.04 0.23 475.00 0.20 1.11 455.00
lob writes 0 749 0.00 1.51 100.00 0.00 1.46 100.00 0.00 7.13 100.00
lob writes unaligned 0 749 0.00 1.51 100.00 0.00 1.46 100.00 0.00 7.13 100.00
messages received 501 777 1.07 1.57 46.73 1.03 1.52 47.57 5.69 7.40 30.05
messages sent 501 777 1.07 1.57 46.73 1.03 1.52 47.57 5.69 7.40 30.05
no work - consistent read gets 32,371,173 32,378,160 69,184.68 65,302.06 -5.61 66,449.16 63,207.98 -4.88 367,854.24 308,363.43 -16.17
parse count (hard) 10,048 10,027 21.47 20.22 -5.82 20.63 19.57 -5.14 114.18 95.50 -16.36
parse time cpu 1,400 1,415 2.99 2.85 -4.68 2.87 2.76 -3.83 15.91 13.48 -15.27
physical read IO requests 590,724 722,224 1,262.51 1,456.62 15.37 1,212.59 1,409.91 16.27 6,712.77 6,878.32 2.47
physical read bytes 57,424,928,768 64,130,301,952 122,730,354.97 129,341,540.65 5.39 117,877,663.19 125,193,855.23 6.21 652,556,008.73 610,764,780.50 -6.40
physical read total IO requests 591,506 725,043 1,264.19 1,462.31 15.67 1,214.20 1,415.41 16.57 6,721.66 6,905.17 2.73
physical read total bytes 57,437,675,520 64,176,324,608 122,757,597.73 129,434,361.69 5.44 117,903,828.79 125,283,699.71 6.26 652,700,858.18 611,203,091.50 -6.36
physical read total multi block requests 420,223 502,214 898.11 1,012.89 12.78 862.60 980.41 13.66 4,775.26 4,782.99 0.16
physical reads cache 7,009,879 7,828,406 14,981.73 15,788.76 5.39 14,389.36 15,282.45 6.21 79,657.72 74,556.25 -6.40
physical reads cache prefetch 6,419,155 7,106,182 13,719.22 14,332.14 4.47 13,176.77 13,872.54 5.28 72,944.94 67,677.92 -7.22
physical write IO requests 400 656 0.85 1.32 55.29 0.82 1.28 56.10 4.55 6.25 37.36
physical write bytes 7,020,544 13,565,952 15,004.53 27,360.56 82.35 14,411.26 26,483.17 83.77 79,778.91 129,199.54 61.95
physical write total IO requests 1,000 1,498 2.14 3.02 41.12 2.05 2.92 42.44 11.36 14.27 25.62
physical write total bytes 16,418,816 33,446,400 35,090.81 67,456.55 92.23 33,703.34 65,293.37 93.73 186,577.45 318,537.14 70.73
physical write total multi block requests 239 454 0.51 0.92 80.39 0.49 0.89 81.63 2.72 4.32 58.82
physical writes from cache 857 1,656 1.83 3.34 82.51 1.76 3.23 83.52 9.74 15.77 61.91
physical writes non checkpoint 210 616 0.45 1.24 175.56 0.43 1.20 179.07 2.39 5.87 145.61
pinned buffers inspected 8 162 0.02 0.33 1,550.00 0.02 0.32 1,500.00 0.09 1.54 1,611.11
recursive calls 26,496 31,560 56.63 63.65 12.40 54.39 61.61 13.27 301.09 300.57 -0.17
recursive cpu usage 1,296 1,678 2.77 3.38 22.02 2.66 3.28 23.31 14.73 15.98 8.49
redo blocks written 2,996 18,093 6.40 36.49 470.16 6.15 35.32 474.31 34.05 172.31 406.05
redo entries 2,690 17,181 5.75 34.65 502.61 5.52 33.54 507.61 30.57 163.63 435.26
redo ordering marks 81 477 0.17 0.96 464.71 0.17 0.93 447.06 0.92 4.54 393.48
redo subscn max counts 217 880 0.46 1.77 284.78 0.45 1.72 282.22 2.47 8.38 239.27
redo synch time 41 41 0.09 0.08 -11.11 0.08 0.08 0.00 0.47 0.39 -17.02
redo synch writes 478 497 1.02 1.00 -1.96 0.98 0.97 -1.02 5.43 4.73 -12.89
redo wastage 34,148 51,788 72.98 104.45 43.12 70.10 101.10 44.22 388.05 493.22 27.10
redo write time 96 180 0.21 0.36 71.43 0.20 0.35 75.00 1.09 1.71 56.88
redo writes 119 172 0.25 0.35 40.00 0.24 0.34 41.67 1.35 1.64 21.48
rollback changes - undo records applied 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
rollbacks only - consistent read gets 99 71 0.21 0.14 -33.33 0.20 0.14 -30.00 1.13 0.68 -39.82
rows fetched via callback 2,272 12,070 4.86 24.34 400.82 4.66 23.56 405.58 25.82 114.95 345.20
session pga memory 11,825,824 10,838,260 25,274.52 21,859.20 -13.51 24,275.18 21,158.23 -12.84 134,384.36 103,221.52 -23.19
session pga memory max 32,076,448 14,704,884 68,554.79 29,657.62 -56.74 65,844.17 28,706.57 -56.40 364,505.09 140,046.51 -61.58
session uga memory 34,360,225,176 38,655,043,092 73,435,748.61 77,961,629.30 6.16 70,532,138.87 75,461,579.34 6.99 390,457,104.27 368,143,267.54 -5.71
session uga memory max 11,349,388 18,173,036 24,256.27 36,652.38 51.10 23,297.19 35,477.03 52.28 128,970.32 173,076.53 34.20
shared hash latch upgrades - no wait 1,341 2,165 2.87 4.37 52.26 2.75 4.23 53.82 15.24 20.62 35.30
sorts (memory) 905 1,010 1.93 2.04 5.70 1.86 1.97 5.91 10.28 9.62 -6.42
sorts (rows) 10,947 30,852 23.40 62.22 165.90 22.47 60.23 168.05 124.40 293.83 136.20
sql area evicted 1,085 1,856 2.32 3.74 61.21 2.23 3.62 62.33 12.33 17.68 43.39
summed dirty queue length 1 55 0.00 0.11 100.00 0.00 0.11 100.00 0.01 0.52 5,100.00
switch current to new buffer 18 22 0.04 0.04 0.00 0.04 0.04 0.00 0.20 0.21 5.00
table fetch by rowid 3,622 13,748 7.74 27.73 258.27 7.43 26.84 261.24 41.16 130.93 218.10
table fetch continued row 79 127 0.17 0.26 52.94 0.16 0.25 56.25 0.90 1.21 34.44
table scan blocks gotten 32,360,510 32,361,396 69,161.89 65,268.25 -5.63 66,427.27 63,175.25 -4.90 367,733.07 308,203.77 -16.19
table scan rows gotten 5,244,535,534 5,244,540,626 11,208,785.48 10,577,479.66 -5.63 10,765,596.17 10,238,284.24 -4.90 59,596,994.70 49,948,005.96 -16.19
table scans (long tables) 10,000 10,001 21.37 20.17 -5.62 20.53 19.52 -4.92 113.64 95.25 -16.18
table scans (short tables) 249 295 0.53 0.59 11.32 0.51 0.58 13.73 2.83 2.81 -0.71
total number of times SMON posted 0 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.01 100.00
transaction rollbacks 4 2 0.01 0.00 -100.00 0.01 0.00 -100.00 0.05 0.02 -60.00
undo change vector size 463,716 2,723,508 991.07 5,492.92 454.24 951.88 5,316.78 458.56 5,269.50 25,938.17 392.23

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
SYSAUX 0.20 2.09 945.00 0.71 1.17 64.79 99 1,069 0.20 0.12 1.08 1.00 346 598 0 0 0.00 0.00
SYSTEM 0.07 0.33 371.43 0.05 0.02 -60.00 35 168 0.29 0.65 1.00 3.77 22 10 0 0 0.00 0.00
USERS 1,212.34 1,407.52 16.10 0.00 0.00 0.00 590,600 720,999 0.16 0.15 11.87 10.86 0 0 0 0 0.00 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 1,212.34 1,407.52 16.10 0.00 0.00 0.00 590,600 720,999 0.16 0.15 11.87 10.86 0 0 0 0 0.00 0.00
SYSAUX /opt/app/oracle/oradata/o102ee1/sysaux01.dbf 0.20 2.09 945.00 0.71 1.17 64.79 99 1,069 0.20 0.12 1.08 1.00 346 598 0 0 0.00 0.00
SYSTEM /opt/app/oracle/oradata/o102ee1/system01.dbf 0.07 0.33 371.43 0.05 0.02 -60.00 35 168 0.29 0.65 1.00 3.77 22 10 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 20.52 21.47 0.95 0.16 0.15 590,600 720,999 1,212.34 1,407.52 11.87 10.86 0 0 0.00 0.00 0 0 0.00 0.00
SYSAUX /opt/app/oracle/oradata/o102ee1/sysaux01.dbf 0.00 0.03 0.02 0.20 0.12 99 1,069 0.20 2.09 1.08 1.00 346 598 0.71 1.17 0 0 0.00 0.00
SYSTEM /opt/app/oracle/oradata/o102ee1/system01.dbf 0.00 0.02 0.02 0.29 0.65 35 168 0.07 0.33 1.00 3.77 22 10 0.05 0.02 0 0 0.00 0.00

Back to IO Stats
Back to Top

 

Top 10 File Comparison by Buffer Waits

No data exists for this section of the report.

Back to IO Stats
Back to Top

 

Advisory Statistics

Back to Top

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 30,237 98,695 226.41 13 47 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 88.7 0.0 0.0 0.0 0.0 3,276
E1 16 4 88.9 0.0 0.0 0.0 0.0 3,276
                 
B2 16 4 88.9 0.0 0.0 0.0 0.0 3,276
E2 16 4 88.9 0.0 0.0 0.0 0.0 3,276

Back to Advisory Statistics
Back to Top

 

Wait Stats

Back to Top

 

Buffer Wait Statistics

No data exists for this section of the report.

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 100.00 100.00 0.00 342,373 343,447 43 12 40 10 3 2 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 99.92 99.72 -0.20 32,429,568 32,429,488
SYS SYSAUX WRH$_SQL_PLAN_PK   INDEX 0.00 0.04 0.04 1,184 13,872
SYS SYSAUX WRH$_SQLSTAT_INDEX WRH$_SQLSTA_2384218455_7846 INDEX PARTITION 0.00 0.03 0.03 1,088 10,336
SYS SYSAUX WRH$_SQL_BIND_METADATA_PK   INDEX 0.00 0.03 0.03 656 9,680
SYS SYSAUX WRH$_SQLSTAT_PK WRH$_SQLSTA_2384218455_7846 INDEX PARTITION 0.00 0.03 0.03 576 8,992
SYS SYSAUX SYS_IOT_TOP_8813   INDEX 0.02 0.02 -0.00 7,200 7,088
SYS SYSTEM SYS_C00648   INDEX 0.00 0.00 0.00 880 912

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 100.00 99.98 -0.02 7,009,747 7,826,716
SYS SYSAUX WRH$_SQL_PLAN   TABLE 0.00 0.01 0.01 27 667
SYS SYSTEM TAB$   TABLE   0.01 0.01   533
SYS SYSAUX WRH$_SQLTEXT   TABLE 0.00 0.00 0.00 14 154
SYS SYSTEM IDL_UB1$   TABLE   0.00 0.00   49
SYS SYSAUX WRI$_ADV_PARAMETERS_PK   INDEX 0.00 0.00 0.00 4 8
SYS SYSTEM IDL_UB2$   TABLE 0.00 0.00 -0.00 9 10

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.03 0.05 66.67 0.02 0.05 150.00 12 26 0.00 0.00 0 0 0.00 0.00 2 8 1 1
dc_global_oids 1.51 1.57 3.97 1.45 1.52 4.83 705 777 0.00 0.26 0 0 0.00 0.00 0 0 25 25
dc_histogram_data 0.41 0.33 -19.51 0.39 0.32 -17.95 190 162 5.26 21.60 0 0 0.00 0.00 0 0 719 729
dc_histogram_defs 43.57 40.53 -6.98 41.85 39.23 -6.26 20,386 20,098 0.19 0.15 0 0 0.00 0.00 0 0 845 815
dc_object_grants 0.03 0.01 -66.67 0.03 0.01 -66.67 14 5 35.71 100.00 0 0 0.00 0.00 0 0 56 56
dc_object_ids 45.24 42.82 -5.35 43.45 41.45 -4.60 21,167 21,233 0.08 0.16 0 0 0.00 0.00 0 0 508 507
dc_objects 21.86 20.89 -4.44 20.99 20.22 -3.67 10,226 10,359 0.42 0.63 0 0 0.00 0.00 0 0 428 401
dc_profiles 0.03 0.03 0.00 0.02 0.03 50.00 12 13 0.00 0.00 0 0 0.00 0.00 0 0 1 1
dc_rollback_segments 0.12 0.13 8.33 0.11 0.13 18.18 54 66 0.00 0.00 0 0 0.00 0.00 0 0 12 12
dc_segments 42.90 40.37 -5.90 41.21 39.08 -5.17 20,074 20,017 0.04 0.03 0 0 0.00 0.00 3 9 181 179
dc_sequences 0.00 0.00 0.00 0.00 0.00 0.00 0 1 0.00 0.00 0 0 0.00 0.00 0 1 1 2
dc_tablespaces 0.91 0.93 2.20 0.87 0.90 3.45 424 461 0.00 0.00 0 0 0.00 0.00 0 0 5 5
dc_usernames 0.16 0.19 18.75 0.15 0.19 26.67 75 95 0.00 0.00 0 0 0.00 0.00 0 0 6 6
dc_users 2.73 2.33 -14.65 2.62 2.25 -14.12 1,276 1,154 0.00 0.00 0 0 0.00 0.00 0 0 25 25
outstanding_alerts 0.03 0.02 -33.33 0.02 0.02 0.00 12 12 0.00 0.00 0 0 0.00 0.00 0 0 10 10


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.20 0.23 15.00 0.19 0.22 15.79 93 114 0.00 0.00 845 900 0.47 0.33 4 3 0 0
CLUSTER 0.01 0.00 -100.00 0.01 0.00 -100.00 6 2 0.00 0.00 10 7 0.00 0.00 0 0 0 0
SQL AREA 22.32 21.12 -5.38 21.44 20.44 -4.66 10,443 10,470 95.88 95.62 34,015 34,828 88.63 86.34 38 11 9 0
TABLE/PROCEDURE 0.23 0.13 -43.48 0.22 0.12 -45.45 106 64 10.38 1.56 31,796 31,646 0.35 0.13 88 38 0 0
TRIGGER 0.02 0.02 0.00 0.02 0.02 0.00 10 8 0.00 0.00 52 35 3.85 0.00 2 0 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 10,412,228 15,259,744 46.56 12,506,668 12,272,156 -1.88 20.12 -19.58
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,904,128 24,904,128 0.00 24,904,128 24,904,128 0.00 0.00 0.00
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 10,654,500 13,146,648 23.39 10,589,464 11,956,872 12.91 -0.61 -9.05
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 33,031,868 27,333,536 -17.25 33,037,916 35,858,576 8.54 0.02 31.19
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 9,106,472 10,099,408 10.90 9,401,824 9,175,188 -2.41 3.24 -9.15
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 15,335,356 19,325,004 26.02 18,019,900 16,756,004 -7.01 17.51 -13.29
  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