关闭

oracle AWR报告原文件

1498人阅读 评论(0) 收藏 举报

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC
MYPL 569030708 mypl 1 03-Dec-13 20:12 11.2.0.1.0 NO

Host Name Platform CPUs Cores Sockets Memory (GB)
orale Linux IA (32-bit) 1     1.39

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 64 03-Dec-13 20:24:57 23 1.4
End Snap: 66 03-Dec-13 22:00:49 27 1.7
Elapsed:   95.87 (mins)    
DB Time:   2.92 (mins)    

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 196M 196M Std Block Size: 8K
Shared Pool Size: 68M 68M Log Buffer: 5,504K

Load Profile

  Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.0 0.3 0.00 0.18
DB CPU(s): 0.0 0.1 0.00 0.07
Redo size: 1,746.6 15,697.9    
Logical reads: 112.2 1,008.5    
Block changes: 10.1 90.7    
Physical reads: 0.7 6.2    
Physical writes: 0.3 2.7    
User calls: 0.2 1.5    
Parses: 5.6 50.5    
Hard parses: 0.8 7.4    
W/A MB processed: 0.0 0.2    
Logons: 0.1 0.5    
Executes: 21.5 192.9    
Rollbacks: 0.0 0.0    
Transactions: 0.1      

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.38 In-memory Sort %: 100.00
Library Hit %: 90.15 Soft Parse %: 85.35
Execute to Parse %: 73.83 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 62.69 % Non-Parse CPU: 83.68

Shared Pool Statistics

  Begin End
Memory Usage %: 92.36 93.29
% SQL with executions>1: 78.84 82.63
% Memory for SQL w/exec>1: 78.04 87.68

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU   67   38.47  
db file sequential read 1,997 37 19 21.36 User I/O
resmgr:cpu quantum 80 7 88 4.04 Scheduler
db file scattered read 194 5 24 2.66 User I/O
library cache: mutex X 2 2 934 1.07 Concurrency

Host CPU (CPUs: 1 Cores: Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle
0.17 1.27 0.7 1.1 1.3 96.7
Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
1.5 45.7 4.0
Memory Statistics

  Begin End
Host Mem (MB): 1,419.6 1,419.6
SGA use (MB): 598.7 598.7
PGA use (MB): 45.7 61.1
% Host Mem used for SGA+PGA: 45.39 46.47

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 175s
  • Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
  • Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
sql execute elapsed time 176.32 100.74
parse time elapsed 78.54 44.87
hard parse elapsed time 74.94 42.82
DB CPU 67.32 38.47
PL/SQL execution elapsed time 17.87 10.21
hard parse (sharing criteria) elapsed time 5.32 3.04
PL/SQL compilation elapsed time 2.22 1.27
hard parse (bind mismatch) elapsed time 2.14 1.22
repeated bind elapsed time 0.49 0.28
sequence load elapsed time 0.18 0.10
connection management call elapsed time 0.15 0.08
failed parse elapsed time 0.08 0.05
DB time 175.02  
background elapsed time 75.94  
background cpu time 16.58  

Back to Wait Events Statistics 
Back to Top

Operating System Statistics

  • *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
  • ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name
Statistic Value End Value
BUSY_TIME 18,374  
IDLE_TIME 532,106  
IOWAIT_TIME 7,208  
NICE_TIME 120  
SYS_TIME 5,992  
USER_TIME 3,640  
LOAD 0 1
RSRC_MGR_CPU_WAIT_TIME 702  
PHYSICAL_MEMORY_BYTES 1,488,609,280  
NUM_CPUS 1  
GLOBAL_RECEIVE_SIZE_MAX 131,071  
GLOBAL_SEND_SIZE_MAX 131,071  
TCP_RECEIVE_SIZE_DEFAULT 87,380  
TCP_RECEIVE_SIZE_MAX 4,194,304  
TCP_RECEIVE_SIZE_MIN 4,096  
TCP_SEND_SIZE_DEFAULT 16,384  
TCP_SEND_SIZE_MAX 4,194,304  
TCP_SEND_SIZE_MIN 4,096  

Back to Wait Events Statistics 
Back to Top

Operating System Statistics - Detail

Snap Time Load %busy %user %sys %idle %iowait
03-Dec 20:24:57 0.17          
03-Dec 21:00:16 0.00 2.82 0.29 0.96 97.18 0.28
03-Dec 22:00:49 1.27 3.64 0.88 1.17 96.36 1.91

Back to Wait Events Statistics 
Back to Top

Foreground Wait Class

  • s - second, ms - millisecond - 1000th of a second
  • ordered by wait time desc, waits desc
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
  • Captured Time accounts for 69.5% of Total DB time 175.02 (s)
  • Total FG Wait Time: 54.29 (s) DB CPU time: 67.32 (s)
Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time
DB CPU     67   38.47
User I/O 2,369 0 43 18 24.46
Scheduler 80 0 7 88 4.04
Concurrency 12 0 2 184 1.26
Commit 77 0 1 19 0.82
System I/O 1,812 0 0 0 0.20
Other 184 97 0 1 0.12
Administrative 1 100 0 180 0.10
Application 2 0 0 0 0.00
Network 31 0 0 0 0.00

Back to Wait Events Statistics 
Back to Top

Foreground Wait Events

  • s - second, ms - millisecond - 1000th of a second
  • Only events with Total Wait Time (s) >= .001 are shown
  • ordered by wait time desc, waits desc (idle events last)
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % DB time
db file sequential read 1,997 0 37 19 3.12 21.36
resmgr:cpu quantum 80 0 7 88 0.13 4.04
db file scattered read 194 0 5 24 0.30 2.66
library cache: mutex X 2 0 2 934 0.00 1.07
log file sync 77 0 1 19 0.12 0.82
read by other session 2 0 0 206 0.00 0.24
control file sequential read 1,812 0 0 0 2.83 0.20
ADR block file read 4 0 0 54 0.01 0.12
library cache load lock 1 0 0 186 0.00 0.11
JS kgl get object wait 1 100 0 180 0.00 0.10
direct path write temp 15 0 0 10 0.02 0.09
direct path sync 2 0 0 72 0.00 0.08
latch: cache buffers chains 1 0 0 64 0.00 0.04
cursor: pin S wait on X 2 0 0 27 0.00 0.03
latch: shared pool 5 0 0 6 0.01 0.02
utl_file I/O 5 0 0 5 0.01 0.01
Disk file operations I/O 154 0 0 0 0.24 0.01
asynch descriptor resize 178 100 0 0 0.28 0.00
jobq slave wait 11,272 100 5,893 523 17.61  
SQL*Net message from client 30 0 5,520 183990 0.05  
PL/SQL lock timer 1 100 2 1684 0.00  

Back to Wait Events Statistics 
Back to Top

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last)
  • Only events with Total Wait Time (s) >= .001 are shown
  • %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % bg time
os thread startup 209 0 19 89 0.33 24.43
log file parallel write 2,954 0 14 5 4.62 18.00
db file sequential read 906 0 9 10 1.42 12.12
control file parallel write 1,899 0 5 3 2.97 6.85
db file async I/O submit 1,083 0 3 3 1.69 3.79
control file sequential read 5,412 0 0 0 8.46 0.34
db file scattered read 7 0 0 28 0.01 0.25
ADR block file read 12 0 0 15 0.02 0.23
library cache load lock 2 0 0 70 0.00 0.18
rdbms ipc reply 1 0 0 117 0.00 0.15
latch: shared pool 4 0 0 11 0.01 0.06
ADR block file write 5 0 0 6 0.01 0.04
direct path sync 1 0 0 25 0.00 0.03
asynch descriptor resize 230 100 0 0 0.36 0.02
latch free 188 0 0 0 0.29 0.01
Disk file operations I/O 53 0 0 0 0.08 0.01
enq: JS - queue lock 1 0 0 3 0.00 0.00
LGWR wait for redo copy 8 0 0 0 0.01 0.00
rdbms ipc message 24,737 94 68,829 2782 38.65  
DIAG idle wait 11,024 100 11,499 1043 17.23  
pmon timer 1,980 93 5,747 2903 3.09  
Space Manager: slave idle wait 1,107 99 5,746 5191 1.73  
Streams AQ: qmn slave idle wait 209 0 5,745 27488 0.33  
Streams AQ: qmn coordinator idle wait 236 86 5,745 24343 0.37  
smon timer 19 100 5,704 300186 0.03  
Streams AQ: waiting for time management or cleanup tasks 5 60 2,735 547083 0.01  
class slave wait 20 0 0 2 0.03  
SQL*Net message from client 5 0 0 3 0.01  

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram

  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
  • % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
  • % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
  • Ordered by Event (idle events last)
    % of Waits
Event Total Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
ADR block file read 16 31.3       18.8 18.8 31.3  
ADR block file write 5 60.0       20.0 20.0    
ADR file lock 6 100.0              
Disk file operations I/O 207 99.5 .5            
JS kgl get object wait 1             100.0  
LGWR wait for redo copy 8 100.0              
SQL*Net break/reset to client 2 100.0              
SQL*Net message to client 34 100.0              
SQL*Net more data to client 1 100.0              
asynch descriptor resize 408 99.3 .7            
control file parallel write 1899 83.0 6.6 1.9 2.2 2.1 2.4 1.8  
control file sequential read 7224 99.7 .1   .0 .1 .0 .0  
cursor: pin S wait on X 2         50.0   50.0  
db file async I/O submit 1083 77.3 10.1 2.6 2.7 3.4 2.4 1.6  
db file scattered read 204 22.1 3.9 2.0 2.5 15.2 26.0 28.4  
db file sequential read 2741 41.9 7.8 2.0 5.0 16.6 14.6 12.0 .0
direct path sync 3       33.3   33.3 33.3  
direct path write temp 16 37.5 25.0 12.5     12.5 12.5  
enq: JS - queue lock 1     100.0          
latch free 188 100.0              
latch: cache buffers chains 1             100.0  
latch: cache buffers lru chain 2 100.0              
latch: redo allocation 10 100.0              
latch: shared pool 10 30.0 20.0 10.0 10.0 20.0   10.0  
library cache load lock 3             100.0  
library cache: mutex X 2             100.0  
log file parallel write 2996 80.9 5.0 1.5 1.6 2.5 4.0 4.5  
log file sync 79 31.6 5.1 3.8 8.9 13.9 12.7 24.1  
os thread startup 209 2.4       .5 2.4 94.3 .5
rdbms ipc reply 1             100.0  
read by other session 2             100.0  
reliable message 1 100.0              
resmgr:cpu quantum 93 11.8 3.2 2.2 3.2 11.8 11.8 55.9  
row cache lock 1 100.0              
utl_file I/O 5 80.0         20.0    
DIAG idle wait 11K             82.2 17.8
PL/SQL lock timer 1               100.0
SQL*Net message from client 35 31.4 11.4     2.9     54.3
Space Manager: slave idle wait 1108 .1             99.9
Streams AQ: qmn coordinator idle wait 236 13.1           .4 86.4
Streams AQ: qmn slave idle wait 209 2.4             97.6
Streams AQ: waiting for time management or cleanup tasks 5 40.0           20.0 40.0
class slave wait 20 90.0   5.0     5.0    
jobq slave wait 11.3K             99.9 .1
pmon timer 1982 6.9 .2         .1 92.9
rdbms ipc message 24.8K 2.3 .2 .3 .3 .3 .4 20.6 75.7
smon timer 19               100.0

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
  • Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
  • % of Total Waits: total waits for all wait classes, including Idle
  • % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
  • Ordered by Event (only non-idle events are displayed)
    % of Total Waits
Event Waits 64ms to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s
ADR block file read 5 68.8 25.0 6.3          
JS kgl get object wait 1       100.0        
control file parallel write 34 98.2 1.3 .4   .1      
control file sequential read 3 100.0 .0 .0          
cursor: pin S wait on X 1 50.0 50.0            
db file async I/O submit 17 98.4 1.3 .2 .1        
db file scattered read 58 71.6 22.1 5.4 1.0        
db file sequential read 330 88.0 6.9 3.2 1.4 .5 .0 .0  
direct path sync 1 66.7     33.3        
direct path write temp 2 87.5 12.5            
latch: cache buffers chains 1   100.0            
latch: shared pool 1 90.0 10.0            
library cache load lock 3   33.3 33.3 33.3        
library cache: mutex X 2           100.0    
log file parallel write 136 95.5 2.9 1.1 .5 .1      
log file sync 19 75.9 21.5 2.5          
os thread startup 197 5.3 46.4 43.1 3.8 .5 .5   .5
rdbms ipc reply 1     100.0          
read by other session 2       100.0        
resmgr:cpu quantum 52 44.1 19.4 16.1 15.1 5.4      

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  • Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
  • Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
  • % of Total Waits: total waits for all wait classes, including Idle
  • % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
  • Ordered by Event (only non-idle events are displayed)
    % of Total Waits
Event Waits 4s to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m
os thread startup 1 99.5 .5            

Back to Wait Events Statistics 
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics 
Back to Top

Service Statistics

  • ordered by DB Time
Service Name DB Time (s) DB CPU (s) Physical Reads (K) Logical Reads (K)
SYS$USERS 172 66 3 517
SYS$BACKGROUND 0 0 1 102
mypl 0 0 0 0

Back to Wait Events Statistics 
Back to Top

Service Wait Class Stats

  • Wait Class info for services in the Service Statistics section.
  • Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
  • Time Waited (Wt Time) in seconds
Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 2368 43 12 2 0 0 31 0
SYS$BACKGROUND 992 9 213 19 0 0 0 0

Back to Wait Events Statistics 
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
  • %Total - Elapsed Time as a percentage of Total DB time
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 29.1% of Total DB Time (s): 175
  • Captured PL/SQL account for 32.0% of Total DB Time (s): 175
Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text
47.58 0   27.18 43.60 40.56 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
8.40 35 0.24 4.80 81.92 1.54 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
7.34 850 0.01 4.19 8.21 93.78 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
5.49 330 0.02 3.14 82.09 0.00 62yyzw3309d6a DBMS_SCHEDULER SELECT VALUE FROM V$SESSION_FI...
4.94 1,958 0.00 2.82 38.29 0.23 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
4.32 8,580 0.00 2.47 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
4.13 1,212 0.00 2.36 8.91 82.13 3ktacv9r56b51   select owner#, name, namespace...
3.63 49 0.07 2.07 78.76 3.77 c0j6cx9kzjf7g DBMS_SCHEDULER SELECT EXTRACTVALUE(VALUE(T), ...
3.47 847 0.00 1.98 4.55 91.94 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
2.69 850 0.00 1.54 7.59 85.46 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
2.68 146 0.02 1.53 6.18 93.50 63kf3an2j0pkc   insert into sys.wri$_optstat_h...
1.76 847 0.00 1.01 6.76 91.90 c6awqs517jpj0   select /*+ index(idl_char$ i_i...

Back to SQL Statistics 
Back to Top

SQL ordered by CPU Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - CPU Time as a percentage of Total DB CPU
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 26.4% of Total CPU Time (s): 67
  • Captured PL/SQL account for 41.0% of Total CPU Time (s): 67
CPU Time (s) Executions CPU per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
20.74 0   30.81 47.58 43.60 40.56 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
6.88 35 0.20 10.22 8.40 81.92 1.54 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
4.51 330 0.01 6.69 5.49 82.09 0.00 62yyzw3309d6a DBMS_SCHEDULER SELECT VALUE FROM V$SESSION_FI...
2.86 49 0.06 4.25 3.63 78.76 3.77 c0j6cx9kzjf7g DBMS_SCHEDULER SELECT EXTRACTVALUE(VALUE(T), ...
1.89 1,958 0.00 2.81 4.94 38.29 0.23 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
1.03 8,580 0.00 1.53 4.32 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
0.80 1,101 0.00 1.19 1.13 70.97 0.00 5ms6rbzdnq16t   select job, nvl2(last_date, 1,...
0.60 850 0.00 0.90 7.34 8.21 93.78 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.57 16,293 0.00 0.85 1.23 46.62 33.34 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.42 2,099 0.00 0.63 0.69 61.00 0.08 83taa7kaw59c1   select name, intcol#, segcol#,...

Back to SQL Statistics 
Back to Top

SQL ordered by User I/O Wait Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - User I/O Time as a percentage of Total User I/O Wait time
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Captured SQL account for 47.0% of Total User I/O Wait Time (s): 52
  • Captured PL/SQL account for 37.2% of Total User I/O Wait Time (s): 52
User I/O Time (s) Executions UIO per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
19.30 0   36.99 47.58 43.60 40.56 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
6.88 850 0.01 13.20 7.34 8.21 93.78 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
3.39 1,212 0.00 6.50 4.13 8.91 82.13 3ktacv9r56b51   select owner#, name, namespace...
3.19 847 0.00 6.11 3.47 4.55 91.94 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
2.95 8,580 0.00 5.65 4.32 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
2.51 146 0.02 4.81 2.68 6.18 93.50 63kf3an2j0pkc   insert into sys.wri$_optstat_h...
2.30 850 0.00 4.40 2.69 7.59 85.46 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
1.62 847 0.00 3.10 1.76 6.76 91.90 c6awqs517jpj0   select /*+ index(idl_char$ i_i...
0.59 1,212 0.00 1.14 0.97 23.89 61.26 8swypbbr0m372   select order#, columns, types ...
0.41 16,293 0.00 0.79 1.23 46.62 33.34 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...

Back to SQL Statistics 
Back to Top

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • %Total - Buffer Gets as a percentage of Total Buffer Gets
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Buffer Gets: 645,458
  • Captured SQL account for 54.9% of Total
Buffer Gets Executions Gets per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
236,843 0   36.69 47.58 43.60 40.56 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
102,781 35 2,936.60 15.92 8.40 81.92 1.54 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
46,925 16,293 2.88 7.27 1.23 46.62 33.34 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
26,857 8,580 3.13 4.16 4.32 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
26,429 1,212 21.81 4.09 0.97 23.89 61.26 8swypbbr0m372   select order#, columns, types ...
25,512 1,212 21.05 3.95 4.13 8.91 82.13 3ktacv9r56b51   select owner#, name, namespace...
25,164 5,726 4.39 3.90 0.27 77.92 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
19,298 3,309 5.83 2.99 0.69 21.63 0.00 5n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
19,029 1,439 13.22 2.95 0.32 36.12 61.72 6qg99cfg26kwb DBMS_SCHEDULER SELECT COUNT(UNQ) UNQ, COUNT(P...
15,575 5,159 3.02 2.41 0.52 57.91 0.00 3nkd3g3ju5ph1   select obj#, type#, ctime, mti...
14,238 1,958 7.27 2.21 4.94 38.29 0.23 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
14,027 1,267 11.07 2.17 0.25 52.04 37.06 gx4mv66pvj3xz   select con#, type#, condlength...
14,024 1,101 12.74 2.17 1.13 70.97 0.00 5ms6rbzdnq16t   select job, nvl2(last_date, 1,...
10,753 2,099 5.12 1.67 0.69 61.00 0.08 83taa7kaw59c1   select name, intcol#, segcol#,...
10,051 850 11.82 1.56 7.34 8.21 93.78 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
7,202 1,660 4.34 1.12 0.23 88.97 0.00 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
6,568 2,164 3.04 1.02 0.53 31.31 0.00 9tgj4g8y4rwy8   select type#, blocks, extents,...
6,545 2,186 2.99 1.01 0.10 85.82 0.00 87gaftwrm2h68   select o.owner#, o.name, o.nam...

Back to SQL Statistics 
Back to Top

SQL ordered by Reads

  • %Total - Physical Reads as a percentage of Total Disk Reads
  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Disk Reads: 3,990
  • Captured SQL account for 33.2% of Total
Physical Reads Executions Reads per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
1,737 0   43.53 47.58 43.60 40.56 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
692 850 0.81 17.34 7.34 8.21 93.78 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
267 35 7.63 6.69 8.40 81.92 1.54 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
174 8,580 0.02 4.36 4.32 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
100 847 0.12 2.51 3.47 4.55 91.94 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
100 146 0.68 2.51 2.68 6.18 93.50 63kf3an2j0pkc   insert into sys.wri$_optstat_h...
58 850 0.07 1.45 2.69 7.59 85.46 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
57 1,212 0.05 1.43 4.13 8.91 82.13 3ktacv9r56b51   select owner#, name, namespace...
46 1,212 0.04 1.15 0.97 23.89 61.26 8swypbbr0m372   select order#, columns, types ...
32 847 0.04 0.80 1.76 6.76 91.90 c6awqs517jpj0   select /*+ index(idl_char$ i_i...

Back to SQL Statistics 
Back to Top

SQL ordered by Physical Reads (UnOptimized)

  • UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
  • %Opt - Optimized Reads as percentage of SQL Read Requests
  • %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
  • Total Physical Read Requests: 3,005
  • Captured SQL account for 44.7% of Total
  • Total UnOptimized Read Requests: 3,005
  • Captured SQL account for 44.7% of Total
  • Total Optimized Read Requests: 1
  • Captured SQL account for 0.0% of Total
UnOptimized Read Reqs Physical Read Reqs Executions UnOptimized Reqs per Exec %Opt %Total SQL Id SQL Module SQL Text
1,127 1,127 0   0.00 37.50 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
692 692 850 0.81 0.00 23.03 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
197 197 35 5.63 0.00 6.56 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
174 174 8,580 0.02 0.00 5.79 db78fxqxwxt7r   select /*+ rule */ bucket, end...
100 100 847 0.12 0.00 3.33 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
100 100 146 0.68 0.00 3.33 63kf3an2j0pkc   insert into sys.wri$_optstat_h...
58 58 850 0.07 0.00 1.93 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
57 57 1,212 0.05 0.00 1.90 3ktacv9r56b51   select owner#, name, namespace...
46 46 1,212 0.04 0.00 1.53 8swypbbr0m372   select order#, columns, types ...
31 31 847 0.04 0.00 1.03 c6awqs517jpj0   select /*+ index(idl_char$ i_i...

Back to SQL Statistics 
Back to Top

SQL ordered by Executions

  • %CPU - CPU Time as a percentage of Elapsed Time
  • %IO - User I/O Time as a percentage of Elapsed Time
  • Total Executions: 123,458
  • Captured SQL account for 54.5% of Total
Executions Rows Processed Rows per Exec Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
16,293 13,747 0.84 1.23 46.62 33.34 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
8,580 131,920 15.38 4.32 23.75 68.17 db78fxqxwxt7r   select /*+ rule */ bucket, end...
5,726 6,845 1.20 0.27 77.92 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
5,159 5,056 0.98 0.52 57.91 0.00 3nkd3g3ju5ph1   select obj#, type#, ctime, mti...
3,309 6,322 1.91 0.69 21.63 0.00 5n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
2,186 2,173 0.99 0.10 85.82 0.00 87gaftwrm2h68   select o.owner#, o.name, o.nam...
2,164 2,162 1.00 0.53 31.31 0.00 9tgj4g8y4rwy8   select type#, blocks, extents,...
2,099 29,592 14.10 0.69 61.00 0.08 83taa7kaw59c1   select name, intcol#, segcol#,...
1,958 3,309 1.69 4.94 38.29 0.23 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
1,660 1,660 1.00 0.23 88.97 0.00 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
1,439 1,439 1.00 0.32 36.12 61.72 6qg99cfg26kwb DBMS_SCHEDULER SELECT COUNT(UNQ) UNQ, COUNT(P...
1,267 115 0.09 0.07 70.37 0.00 3w4qs0tbpmxr6   select con#, obj#, rcon#, enab...
1,267 5,730 4.52 0.25 52.04 37.06 gx4mv66pvj3xz   select con#, type#, condlength...

Back to SQL Statistics 
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 32,304
  • Captured SQL account for 42.3% of Total
Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
2,164 2,164 6.70 9tgj4g8y4rwy8   select type#, blocks, extents,...
1,212 1,212 3.75 3ktacv9r56b51   select owner#, name, namespace...
1,212 1,212 3.75 8swypbbr0m372   select order#, columns, types ...
850 850 2.63 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
850 850 2.63 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
847 847 2.62 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
847 847 2.62 c6awqs517jpj0   select /*+ index(idl_char$ i_i...
539 539 1.67 asvzxj61dc5vs   select timestamp, flags from f...
270 270 0.84 6qz82dptj0qr7   select l.col#, l.intcol#, l.lo...
198 198 0.61 fsbqktj5vw6n9   select next_run_date, obj#, ru...

Back to SQL Statistics 
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics 
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics 
Back to Top

Complete List of SQL Text

SQL Id SQL Text
1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
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#
3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1 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
3w4qs0tbpmxr6 select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ms6rbzdnq16t 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) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
62yyzw3309d6a SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID')
63kf3an2j0pkc insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
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;
6qg99cfg26kwb SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1) leading(cc) */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2, 3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+ first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY, 1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS, 1025) = 0 AND ROWNUM < 2 )
6qz82dptj0qr7 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
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#
83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1
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
9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1
b6usrg82hwsa3 call dbms_stats.gather_database_stats_job_proc ( )
c0j6cx9kzjf7g SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T
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#
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#
db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
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#
gx4mv66pvj3xz select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

Back to SQL Statistics 
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

  • Ordered by statistic name
Statistic Total per Second per Trans
Batched IO (bound) vector count 0 0.00 0.00
Batched IO (full) vector count 0 0.00 0.00
Batched IO block miss count 0 0.00 0.00
Batched IO buffer defrag count 0 0.00 0.00
Batched IO double miss count 0 0.00 0.00
Batched IO same unit count 0 0.00 0.00
Batched IO single block count 0 0.00 0.00
Batched IO vector block count 0 0.00 0.00
Batched IO vector read count 0 0.00 0.00
Block Cleanout Optim referenced 10 0.00 0.02
CCursor + sql area evicted 165 0.03 0.26
CPU used by this session 5,589 0.97 8.73
CPU used when call started 929 0.16 1.45
CR blocks created 121 0.02 0.19
Cached Commit SCN referenced 108 0.02 0.17
Commit SCN cached 9 0.00 0.01
DB time 566,912 98.56 885.80
DBWR checkpoint buffers written 1,587 0.28 2.48
DBWR transaction table writes 145 0.03 0.23
DBWR undo block writes 351 0.06 0.55
HSC Heap Segment Block Changes 12,558 2.18 19.62
Heap Segment Array Inserts 323 0.06 0.50
Heap Segment Array Updates 128 0.02 0.20
IMU CR rollbacks 181 0.03 0.28
IMU Flushes 153 0.03 0.24
IMU Redo allocation size 192,636 33.49 300.99
IMU commits 583 0.10 0.91
IMU ktichg flush 2 0.00 0.00
IMU recursive-transaction flush 2 0.00 0.00
IMU undo allocation size 1,909,488 331.97 2,983.58
RowCR - row contention 0 0.00 0.00
RowCR attempts 68 0.01 0.11
RowCR hits 70 0.01 0.11
SQL*Net roundtrips to/from client 30 0.01 0.05
active txn count during cleanout 124 0.02 0.19
background timeouts 23,191 4.03 36.24
buffer is not pinned count 468,751 81.49 732.42
buffer is pinned count 93,529 16.26 146.14
bytes received via SQL*Net from client 7,210 1.25 11.27
bytes sent via SQL*Net to client 23,815 4.14 37.21
calls to get snapshot scn: kcmgss 149,572 26.00 233.71
calls to kcmgas 3,432 0.60 5.36
calls to kcmgcs 44,169 7.68 69.01
cell physical IO interconnect bytes 207,586,304 36,089.36 324,353.60
change write time 225 0.04 0.35
cleanout - number of ktugct calls 152 0.03 0.24
cleanouts and rollbacks - consistent read gets 8 0.00 0.01
cleanouts only - consistent read gets 21 0.00 0.03
cluster key scan block gets 49,031 8.52 76.61
cluster key scans 43,702 7.60 68.28
commit cleanout failures: block lost 8 0.00 0.01
commit cleanout failures: callback failure 14 0.00 0.02
commit cleanouts 6,215 1.08 9.71
commit cleanouts successfully completed 6,193 1.08 9.68
commit txn count during cleanout 103 0.02 0.16
concurrency wait time 2,090 0.36 3.27
consistent changes 1,860 0.32 2.91
consistent gets 595,004 103.44 929.69
consistent gets - examination 227,980 39.63 356.22
consistent gets from cache 595,004 103.44 929.69
consistent gets from cache (fastpath) 347,297 60.38 542.65
cursor authentications 971 0.17 1.52
data blocks consistent reads - undo records applied 238 0.04 0.37
db block changes 58,075 10.10 90.74
db block gets 50,454 8.77 78.83
db block gets direct 139 0.02 0.22
db block gets from cache 50,315 8.75 78.62
db block gets from cache (fastpath) 13,007 2.26 20.32
deferred (CURRENT) block cleanout applications 3,499 0.61 5.47
enqueue conversions 1,122 0.20 1.75
enqueue releases 50,252 8.74 78.52
enqueue requests 50,258 8.74 78.53
enqueue timeouts 0 0.00 0.00
enqueue waits 1 0.00 0.00
execute count 123,458 21.46 192.90
file io service time 39,260 6.83 61.34
file io wait time 55,145,645 9,587.20 86,165.07
frame signature mismatch 0 0.00 0.00
free buffer requested 5,778 1.00 9.03
heap block compress 89 0.02 0.14
immediate (CR) block cleanout applications 29 0.01 0.05
immediate (CURRENT) block cleanout applications 1,015 0.18 1.59
index crx upgrade (positioned) 10 0.00 0.02
index fast full scans (full) 123 0.02 0.19
index fetch by key 107,179 18.63 167.47
index scans kdiixs1 81,559 14.18 127.44
leaf node 90-10 splits 33 0.01 0.05
leaf node splits 64 0.01 0.10
lob reads 1,286 0.22 2.01
lob writes 470 0.08 0.73
lob writes unaligned 470 0.08 0.73
logons cumulative 308 0.05 0.48
max cf enq hold time 120 0.02 0.19
messages received 2,697 0.47 4.21
messages sent 2,697 0.47 4.21
min active SCN optimization applied on CR 12 0.00 0.02
no work - consistent read gets 314,967 54.76 492.14
non-idle wait count 17,719 3.08 27.69
non-idle wait time 10,627 1.85 16.60
opened cursors cumulative 115,155 20.02 179.93
parse count (describe) 20 0.00 0.03
parse count (failures) 41 0.01 0.06
parse count (hard) 4,731 0.82 7.39
parse count (total) 32,304 5.62 50.48
parse time cpu 1,099 0.19 1.72
parse time elapsed 1,753 0.30 2.74
physical read IO requests 3,005 0.52 4.70
physical read bytes 32,686,080 5,682.55 51,072.00
physical read total IO requests 10,237 1.78 16.00
physical read total bytes 151,355,392 26,313.49 236,492.80
physical read total multi block requests 3 0.00 0.00
physical reads 3,990 0.69 6.23
physical reads cache 3,990 0.69 6.23
physical reads cache prefetch 985 0.17 1.54
physical write IO requests 1,099 0.19 1.72
physical write bytes 14,139,392 2,458.17 22,092.80
physical write total IO requests 4,497 0.78 7.03
physical write total bytes 56,230,912 9,775.88 87,860.80
physical write total multi block requests 26 0.00 0.04
physical writes 1,726 0.30 2.70
physical writes direct 139 0.02 0.22
physical writes direct temporary tablespace 139 0.02 0.22
physical writes from cache 1,587 0.28 2.48
physical writes non checkpoint 781 0.14 1.22
pinned cursors current 2 0.00 0.00
process last non-idle time 1,386,079,208 240,973.10 2,165,748.76
recursive calls 1,245,483 216.53 1,946.07
recursive cpu usage 2,905 0.51 4.54
redo blocks checksummed by FG (exclusive) 6,441 1.12 10.06
redo blocks written 21,442 3.73 33.50
redo entries 26,067 4.53 40.73
redo size 10,046,628 1,746.63 15,697.86
redo synch time 124 0.02 0.19
redo synch writes 103 0.02 0.16
redo wastage 408,508 71.02 638.29
redo write time 1,421 0.25 2.22
redo writes 1,497 0.26 2.34
rollbacks only - consistent read gets 113 0.02 0.18
rows fetched via callback 34,068 5.92 53.23
scheduler wait time 720 0.13 1.13
session connect time 1,386,079,208 240,973.10 2,165,748.76
session cursor cache hits 132,834 23.09 207.55
session logical reads 645,458 112.21 1,008.53
shared hash latch upgrades - no wait 7,853 1.37 12.27
sorts (memory) 29,032 5.05 45.36
sorts (rows) 505,142 87.82 789.28
sql area evicted 3,430 0.60 5.36
sql area purged 54 0.01 0.08
switch current to new buffer 536 0.09 0.84
table fetch by rowid 160,090 27.83 250.14
table fetch continued row 2,576 0.45 4.03
table scan blocks gotten 39,570 6.88 61.83
table scan rows gotten 1,072,628 186.48 1,675.98
table scans (long tables) 0 0.00 0.00
table scans (short tables) 19,821 3.45 30.97
temp space allocated (bytes) 5,242,880 911.49 8,192.00
total cf enq hold time 230 0.04 0.36
total number of cf enq holders 15 0.00 0.02
total number of times SMON posted 0 0.00 0.00
undo change vector size 3,644,728 633.64 5,694.89
user I/O wait time 5,311 0.92 8.30
user calls 965 0.17 1.51
user commits 640 0.11 1.00
workarea executions - optimal 16,205 2.82 25.32

Back to Instance Activity Statistics 
Back to Top

Instance Activity Stats - Absolute Values

  • Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
session uga memory 42,958,138,736 463,881,404,020
opened cursors current 33 46
logons current 23 27
session uga memory max 39,520,460 4,533,407,028
session pga memory 54,237,012 264,740,492
session pga memory max 79,861,588 362,585,740
session cursor cache count 992 7,522

Back to Instance Activity Statistics 
Back to Top

Instance Activity Stats - Thread Activity

  • Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics 
Back to Top

IO Stats

Back to Top

IOStat by Function summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • ordered by (Data Read + Write) desc
Function Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms)
Others 113M 1.26 .019645 30M 0.33 .005215 11K 0.74
Buffer Cache Reads 30M 0.51 .005215 0M 0.00 0M 2914 18.06
DBWR 0M 0.00 0M 13M 0.19 .002260 1083 2.05
LGWR 0M 0.00 0M 11M 0.26 .001912 1498 8.92
Direct Writes 0M 0.00 0M 1M 0.00 .000173 16 9.25
Streams AQ 0M 0.00 0M 0M 0.00 0M 1 27.00
TOTAL: 143M 1.76 .024860 55M 0.78 .009561 16.5K 4.63

Back to IO Stats 
Back to Top

IOStat by Filetype summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • Small Read and Large Read are average service times, in milliseconds
  • Ordered by (Data Read + Write) desc
Filetype Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Small Read Large Read
Control File 113M 1.26 .019645 30M 0.33 .005215 0.05  
Data File 30M 0.50 .005215 12M 0.19 .002086 18.11  
Log File 0M 0.00 0M 11M 0.26 .001912    
Temp File 1M 0.00 .000173 1M 0.00 .000173 0.00 0.33
TOTAL: 144M 1.76 .025034 54M 0.78 .009388 5.23 0.33

Back to IO Stats 
Back to Top

IOStat by Function/Filetype summary

  • 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
  • Ordered by (Data Read + Write) desc for each function
Function/File Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms)
Others 113M 1.26 .019645 30M 0.33 .005215 7232 0.05
Others (Control File) 113M 1.26 .019645 30M 0.33 .005215 7224 0.05
Others (Data File) 0M 0.00 0M 0M 0.00 0M 8 0.13
Buffer Cache Reads 30M 0.50 .005215 0M 0.00 0M 2880 18.28
Buffer Cache Reads (Data File) 30M 0.50 .005215 0M 0.00 0M 2880 18.28
DBWR 0M 0.00 0M 13M 0.19 .002260 0  
DBWR (Data File) 0M 0.00 0M 13M 0.19 .002260 0  
LGWR 0M 0.00 0M 11M 0.26 .001912 0  
LGWR (Log File) 0M 0.00 0M 11M 0.26 .001912 0  
Direct Writes 0M 0.00 0M 1M 0.00 .000173 0  
Direct Writes (Data File) 0M 0.00 0M 1M 0.00 .000173 0  
Streams AQ 0M 0.00 0M 0M 0.00 0M 1 27.00
Streams AQ (Data File) 0M 0.00 0M 0M 0.00 0M 1 27.00
TOTAL: 143M 1.76 .024860 55M 0.78 .009561 10.1K 5.25

Back to IO Stats 
Back to Top

Tablespace IO Stats

  • ordered by IOs (Reads + Writes) desc
Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
SYSAUX 1,402 0 15.16 1.54 700 0 0 0.00
SYSTEM 1,735 0 17.48 1.05 82 0 2 95.00
UNDOTBS1 0 0 0.00 0.00 302 0 0 0.00
TEMP 10 0 0.00 13.90 16 0 0 0.00

Back to IO Stats 
Back to Top

File IO Stats

  • ordered by Tablespace, File
Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
SYSAUX /u01/app/oracle/oradata/mypl/sysaux01.dbf 1,402 0 15.16 1.54 700 0 0 0.00
SYSTEM /u01/app/oracle/oradata/mypl/system01.dbf 1,735 0 17.48 1.05 82 0 2 95.00
TEMP /u01/app/oracle/oradata/mypl/temp01.dbf 10 0 0.00 13.90 16 0 0  
UNDOTBS1 /u01/app/oracle/oradata/mypl/undotbs01.dbf 0 0     302 0 0 0.00

Back to IO Stats 
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

  • Standard block size Pools D: default, K: keep, R: recycle
  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 24,304 99 628,584 4,048 1,587 0 0 2

Back to Buffer Pool Statistics 
Back to Top

Checkpoint Activity

  • Total Physical Writes: 1,726
MTTR Writes Log Size Writes Log Ckpt Writes Other Settings Writes Autotune Ckpt Writes Thread Ckpt Writes
0 0 0 0 1,587 0

Back to Buffer Pool Statistics 
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

  • B: Begin Snapshot, E: End Snapshot
  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual RedoBlks Target RedoBlks Log Sz RedoBlks Log Ckpt Timeout RedoBlks Log Ckpt Interval RedoBlks Opt Log Sz(M) Estd RAC Avail Time
B 0 22 184 390 165888 165888        
E 0 22 1277 13033 14361 165888 14361      

Back to Advisory Statistics 
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Buffer Pool Advisory

  • Only rows with estimated physical reads >0 are displayed
  • ordered by Block Size, Buffers For Estimate
P Size for Est (M) Size Factor Buffers (thousands) Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time Est %DBtime for Rds
D 20 0.10 2 1.81 20 1 270.00
D 40 0.20 5 1.22 13 1 172.00
D 60 0.30 7 1.09 12 1 150.00
D 80 0.40 10 1.00 11 1 136.00
D 100 0.50 12 1.00 11 1 135.00
D 120 0.60 15 1.00 11 1 135.00
D 140 0.70 17 1.00 11 1 135.00
D 160 0.80 20 1.00 11 1 135.00
D 180 0.90 22 1.00 11 1 135.00
D 200 1.00 25 1.00 11 1 135.00
D 220 1.10 27 1.00 11 1 135.00
D 240 1.20 30 1.00 11 1 135.00
D 260 1.30 32 1.00 11 1 135.00
D 280 1.40 35 1.00 11 1 135.00
D 300 1.50 37 1.00 11 1 135.00
D 320 1.60 40 1.00 11 1 135.00
D 340 1.70 42 1.00 11 1 135.00
D 360 1.80 45 1.00 11 1 135.00
D 380 1.90 47 1.00 11 1 135.00
D 400 2.00 50 1.00 11 1 135.00

Back to Advisory Statistics 
Back to Top

PGA Aggr Summary

  • PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 152 0

Back to Advisory Statistics 
Back to Top

PGA Aggr Target Stats

  • B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute 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)
B 58 23 45.68 0.00 0.00 0.00 0.00 11,878
E 58 14 61.08 0.00 0.00 0.00 0.00 11,878

Back to Advisory Statistics 
Back to Top

PGA Aggr Target Histogram

  • Optimal Executions are purely in-memory operations
Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 15,516 15,516 0 0
64K 128K 10 10 0 0
128K 256K 14 14 0 0
256K 512K 26 26 0 0
512K 1024K 122 122 0 0
1M 2M 4 4 0 0
2M 4M 4 4 0 0

Back to Advisory Statistics 
Back to Top

PGA Memory Advisory

  • When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0
PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count Estd Time
15 0.25 186.17 24.31 88.00 5 919,568
29 0.50 186.17 24.31 88.00 5 919,568
44 0.75 186.17 6.16 97.00 2 840,279
58 1.00 186.17 0.00 100.00 0 813,348
70 1.20 186.17 0.00 100.00 0 813,348
81 1.40 186.17 0.00 100.00 0 813,348
93 1.60 186.17 0.00 100.00 0 813,348
104 1.80 186.17 0.00 100.00 0 813,348
116 2.00 186.17 0.00 100.00 0 813,348
174 3.00 186.17 0.00 100.00 0 813,348
232 4.00 186.17 0.00 100.00 0 813,348
348 6.00 186.17 0.00 100.00 0 813,348
464 8.00 186.17 0.00 100.00 0 813,348

Back to Advisory Statistics 
Back to Top

Shared Pool Advisory

  • SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
  • Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits (K)
68 1.00 2 200 1,614 1.00 132 1.00 45
76 1.12 10 898 1,623 1.01 123 0.93 162
84 1.24 18 1,521 1,650 1.02 96 0.73 164
92 1.35 26 2,028 1,664 1.03 82 0.62 165
100 1.47 33 2,521 1,677 1.04 69 0.52 166
108 1.59 41 2,965 1,683 1.04 63 0.48 166
116 1.71 49 3,415 1,689 1.05 57 0.43 166
124 1.82 57 3,911 1,691 1.05 55 0.42 167
132 1.94 65 4,417 1,694 1.05 52 0.39 167
140 2.06 73 4,829 1,695 1.05 51 0.39 167

Back to Advisory Statistics 
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics 
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

  • ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
data block 2 0 95

Back to Wait Statistics 
Back to Top

Enqueue Activity

  • only enqueues with waits are shown
  • Enqueue stats gathered prior to 10g should not be compared with 10g data
  • ordered by Wait Time desc, Waits desc
Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
JS-Job Scheduler (queue lock) 16,675 16,675 0 1 0 0.00

Back to Wait Statistics 
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

  • Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
  • STO - Snapshot Too Old count, OOS - Out of Space count
  • Undo segment block stats:
  • uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
  • eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
2 0.20 1,666 1,086 3 4755.7/8253.6 0/0 0/0/0/0/0/0

Back to Undo Statistics 
Back to Top

Undo Segment Stats

  • Most recent 35 Undostat rows, ordered by Time desc
End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
03-Dec 21:53 11 143 1,086 1 8,254 0/0 0/0/0/0/0/0
03-Dec 21:43 9 152 461 2 7,794 0/0 0/0/0/0/0/0
03-Dec 21:33 10 49 1,052 1 7,212 0/0 0/0/0/0/0/0
03-Dec 21:23 11 180 427 1 6,707 0/0 0/0/0/0/0/0
03-Dec 21:13 6 50 1,006 1 6,057 0/0 0/0/0/0/0/0
03-Dec 21:03 78 446 385 3 5,296 0/0 0/0/0/0/0/0
03-Dec 20:53 11 142 974 2 7,718 0/0 0/0/0/0/0/0
03-Dec 20:43 5 48 348 1 6,502 0/0 0/0/0/0/0/0
03-Dec 20:33 60 456 933 3 4,756 0/0 0/0/0/0/0/0

Back to Undo Statistics 
Back to Top

Latch Statistics

Back to Top

Latch Activity

  • "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
  • "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
  • "Pct Misses" for both should be very close to 0.0
Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
AQ deq hash table latch 22 0.00   0 0  
AQ dequeue txn counter latch 4 0.00   0 0  
AQ disk delete txn counter latch 4 0.00   0 0  
ASM db client latch 3,678 0.00   0 0  
ASM map operation hash table 2 0.00   0 0  
ASM network state latch 94 0.00   0 0  
AWR Alerted Metric Element list 38,155 0.00   0 0  
Change Notification Hash table latch 1,854 0.00   0 0  
Consistent RBA 1,482 0.00   0 0  
DML lock allocation 8,060 0.00   0 0  
Event Group Locks 212 0.00   0 0  
FOB s.o list latch 403 0.00   0 0  
File State Object Pool Parent Latch 2 0.00   0 0  
IPC stats buffer allocation latch 2 0.00   0 0  
In memory undo latch 8,846 0.00   0 1,882 0.00
JS Sh mem access 16 31.25 1.00 0 0  
JS broadcast autostart latch 4 0.00   0 0  
JS mem alloc latch 18 0.00   0 0  
JS queue access latch 20 0.00   0 0  
JS queue state obj latch 33,350 0.00   0 0  
JS slv state obj latch 1,609 0.00   0 0  
KFC FX Hash Latch 2 0.00   0 0  
KFC Hash Latch 2 0.00   0 0  
KFCL LE Freelist 2 0.00   0 0  
KGNFS-NFS:SHM structure 2 0.00   0 0  
KGNFS-NFS:SVR LIST 2 0.00   0 0  
KJC message pool free list 2 0.00   0 0  
KJCT flow control latch 2 0.00   0 0  
KMG MMAN ready and startup request latch 1,840 0.00   0 0  
KTF sga latch 30 0.00   0 1,745 0.00
KWQMN job cache list latch 14 0.00   0 0  
KWQS pqsubs latch 2 0.00   0 0  
KWQS pqueue ctx latch 95 0.00   0 0  
Locator state objects pool parent latch 2 0.00   0 0  
Lsod array latch 2 0.00   0 0  
MQL Tracking Latch 0     0 109 0.00
Memory Management Latch 2 0.00   0 1,840 0.00
Memory Queue 2 0.00   0 0  
Memory Queue Message Subscriber #1 2 0.00   0 0  
Memory Queue Message Subscriber #2 2 0.00   0 0  
Memory Queue Message Subscriber #3 2 0.00   0 0  
Memory Queue Message Subscriber #4 2 0.00   0 0  
Memory Queue Subscriber 2 0.00   0 0  
MinActiveScn Latch 31 0.00   0 0  
Mutex 2 0.00   0 0  
Mutex Stats 2 0.00   0 0  
NLS data objects 4 0.00   0 0  
OS process 1,884 0.00   0 0  
OS process allocation 3,089 0.00   0 0  
OS process: request allocation 416 0.00   0 0  
PL/SQL warning settings 418 0.00   0 0  
PX hash array latch 2 0.00   0 0  
QMT 2 0.00   0 0  
Real-time plan statistics latch 94 0.00   0 0  
SGA blob parent 2 0.00   0 0  
SGA bucket locks 2 0.00   0 0  
SGA heap locks 2 0.00   0 0  
SGA pool locks 2 0.00   0 0  
SQL memory manager latch 617 0.00   0 1,839 0.00
SQL memory manager workarea list latch 169,490 0.00   0 0  
Shared B-Tree 491 0.00   0 0  
Streams Generic 2 0.00   0 0  
Testing 2 0.00   0 0  
Token Manager 2 0.00   0 0  
WCR: sync 2 0.00   0 0  
Write State Object Pool Parent Latch 2 0.00   0 0  
X$KSFQP 2 0.00   0 0  
XDB NFS Security Latch 2 0.00   0 0  
XDB unused session pool 2 0.00   0 0  
XDB used session pool 2 0.00   0 0  
active checkpoint queue latch 2,923 0.00   0 0  
active service list 11,185 0.00   0 2,792 0.00
buffer pool 2 0.00   0 0  
business card 2 0.00   0 0  
cache buffer handles 4,328 0.00   0 0  
cache buffers chains 1,154,087 0.00 1.00 0 16,149 0.00
cache buffers lru chain 8,448 0.02 1.00 0 11,768 0.00
cache table scan latch 202 0.00   0 202 0.00
call allocation 8,505 0.00   0 0  
cas latch 2 0.00   0 0  
change notification client cache latch 2 0.00   0 0  
channel handle pool latch 449 0.00   0 0  
channel operations parent latch 30,607 0.00   0 0  
checkpoint queue latch 40,810 0.00   0 2,276 0.00
client/application info 2,441 0.00   0 0  
compile environment latch 307 0.00   0 0  
cp cmon/server latch 2 0.00   0 0  
cp pool latch 2 0.00   0 0  
cp server hash latch 2 0.00   0 0  
cp sga latch 94 0.00   0 0  
cvmap freelist lock 2 0.00   0 0  
database property service latch 8 0.00   0 0  
deferred cleanup latch 94 0.00   0 0  
dml lock allocation 94 0.00   0 0  
done queue latch 2 0.00   0 0  
dummy allocation 612 0.00   0 0  
enqueue hash chains 100,906 0.00   0 0  
enqueues 86,474 0.00   0 0  
fifth spare latch 2 0.00   0 0  
file cache latch 171 0.00   0 0  
flashback copy 2 0.00   0 0  
gc element 2 0.00   0 0  
gcs commit scn state 2 0.00   0 0  
gcs partitioned table hash 2 0.00   0 0  
gcs pcm hashed value bucket hash 2 0.00   0 0  
gcs resource freelist 2 0.00   0 0  
gcs resource hash 2 0.00   0 0  
gcs resource scan list 2 0.00   0 0  
gcs shadows freelist 2 0.00   0 0  
ges domain table 2 0.00   0 0  
ges enqueue table freelist 2 0.00   0 0  
ges group table 2 0.00   0 0  
ges process hash list 2 0.00   0 0  
ges process parent latch 2 0.00   0 0  
ges resource hash list 2 0.00   0 0  
ges resource scan list 2 0.00   0 0  
ges resource table freelist 2 0.00   0 0  
ges value block free list 2 0.00   0 0  
global ctx hash table latch 2 0.00   0 0  
global tx hash mapping 2 0.00   0 0  
granule operation 2 0.00   0 0  
hash table column usage latch 1,492 0.00   0 369,989 0.00
hash table modification latch 163 0.00   0 0  
heartbeat check 2 0.00   0 0  
internal temp table object number allocation latch 16 0.00   0 0  
intra txn parallel recovery 2 0.00   0 0  
io pool granule metadata list 2 0.00   0 0  
job workq parent latch 100 0.00   0 98 0.00
job_queue_processes free list latch 209 0.00   0 0  
job_queue_processes parameter latch 1,295 0.00   0 0  
k2q lock allocation 2 0.00   0 0  
kdlx hb parent latch 2 0.00   0 0  
kgb parent 2 0.00   0 0  
kks stats 17,741 0.00   0 0  
kokc descriptor allocation latch 1,695 0.00   0 0  
ksfv messages 2 0.00   0 0  
kss move lock 42 0.00   0 0  
ksuosstats global area 374 0.00   0 0  
ksv allocation latch 174 0.00   0 0  
ksv class latch 82 0.00   0 0  
ksv msg queue latch 2 0.00   0 0  
ksz_so allocation latch 416 0.00   0 0  
ktm global data 31 0.00   0 0  
kwqbsn:qsga 204 0.00   0 0  
lgwr LWN SCN 3,064 0.00   0 0  
list of block allocation 278 0.00   0 0  
loader state object freelist 28 0.00   0 0  
lob segment dispenser latch 2 0.00   0 0  
lob segment hash table latch 22 0.00   0 0  
lob segment query latch 2 0.00   0 0  
lock DBA buffer during media recovery 2 0.00   0 0  
logical standby cache 2 0.00   0 0  
logminer context allocation 2 0.00   0 0  
logminer work area 2 0.00   0 0  
longop free list parent 45 0.00   0 44 0.00
mapped buffers lru chain 2 0.00   0 0  
message pool operations parent latch 23 0.00   0 0  
messages 53,622 0.00   0 0  
mostly latch-free SCN 3,064 0.00   0 0  
msg queue latch 2 0.00   0 0  
multiblock read objects 482 0.00   0 0  
name-service namespace bucket 2 0.00   0 0  
ncodef allocation latch 94 0.00   0 0  
object queue header heap 3,249 0.00   0 15 0.00
object queue header operation 15,382 0.00   0 0  
object stats modification 1,344 0.00   0 0  
parallel query alloc buffer 730 0.00   0 0  
parallel query stats 2 0.00   0 0  
parameter list 141 0.00   0 0  
parameter table management 614 0.00   0 0  
peshm 2 0.00   0 0  
pesom_free_list 2 0.00   0 0  
pesom_hash_node 2 0.00   0 0  
post/wait queue 173 0.00   0 87 0.00
process allocation 625 0.00   0 210 0.00
process group creation 416 0.00   0 0  
process queue 2 0.00   0 0  
process queue reference 2 0.00   0 0  
qmn task queue latch 836 21.17 1.00 0 0  
query server freelists 2 0.00   0 0  
queued dump request 18 0.00   0 0  
queuing load statistics 2 0.00   0 0  
recovery domain hash list 2 0.00   0 0  
redo allocation 8,265 0.12 1.00 0 25,860 0.00
redo copy 3 0.00   0 25,859 0.07
redo writing 11,233 0.00   0 0  
resmgr group change latch 597 0.00   0 0  
resmgr:active threads 632 0.00   0 1 0.00
resmgr:actses change group 131 0.00   0 0  
resmgr:actses change state 6 0.00   0 0  
resmgr:free threads list