WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC
RAC 2430353140 rac2 2 16-3月 -14 16:03 11.2.0.3.0 YES

Host Name Platform CPUs Cores Sockets Memory (GB)
vodrac2 Linux x86 64-bit 24 12 2 31.39

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1421 14-5月 -14 21:00:17 375 1.8
End Snap: 1424 15-5月 -14 00:00:25 389 1.8
Elapsed:   180.13 (mins)    
DB Time:   112.39 (mins)    

Report Summary

Cache Sizes

Begin End
Buffer Cache: 8,416M 8,416M Std Block Size: 8K
Shared Pool Size: 3,680M 3,680M Log Buffer: 7,164K

Load Profile

Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.6 0.0 0.00 0.00
DB CPU(s): 0.2 0.0 0.00 0.00
Redo size: 71,120.1 3,045.0    
Logical reads: 22,058.4 944.4    
Block changes: 490.3 21.0    
Physical reads: 0.5 0.0    
Physical writes: 24.7 1.1    
User calls: 420.6 18.0    
Parses: 9.7 0.4    
Hard parses: 0.0 0.0    
W/A MB processed: 1.5 0.1    
Logons: 0.7 0.0    
Executes: 145.2 6.2    
Rollbacks: 21.5 0.9    
Transactions: 23.4      

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.94 Soft Parse %: 99.76
Execute to Parse %: 93.34 Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 86.15 % Non-Parse CPU: 97.96

Shared Pool Statistics

Begin End
Memory Usage %: 83.32 83.32
% SQL with executions>1: 95.08 95.46
% Memory for SQL w/exec>1: 95.62 96.22

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
log file sync 264,505 3,075 12 45.61 Commit
DB CPU   2,219   32.91  
gc cr block busy 125,502 956 8 14.18 Cluster
gc cr block 2-way 769,312 276 0 4.10 Cluster
gc current block busy 14,231 187 13 2.77 Cluster

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average Begin Load Average End %User %System %WIO %Idle
1.50 1.42 1.1 0.3 1.5 98.5
Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
1.1 74.8 0.0
Memory Statistics

Begin End
Host Mem (MB): 32,143.7 32,143.7
SGA use (MB): 12,288.0 12,288.0
PGA use (MB): 904.6 922.9
% Host Mem used for SGA+PGA: 41.04 41.10

RAC Statistics

Begin End
Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction
Global Cache blocks received: 123.85 5.30
Global Cache blocks served: 127.30 5.45
GCS/GES messages received: 291.55 12.48
GCS/GES messages sent: 294.73 12.62
DBWR Fusion writes: 0.84 0.04
Estd Interconnect traffic (KB) 2,123.64  

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.44
Buffer access - remote cache %: 0.56
Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 1.4
Avg global cache current block receive time (ms): 0.8
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 14.2
Avg global cache cr block flush time (ms): 6.9
Avg global cache current block pin time (ms): 63,726.7
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 1.0
Avg global cache current block flush time (ms): 1,324,817.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 1.3
Avg message received queue time (ms): 2.8
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 79.59
% of indirect sent messages: 20.21
% of flow controlled messages: 0.19

Cluster Interconnect

  Begin End
Interface IP Address Pub Source IP Pub Src
bond1:1 169.254.133.80 N        

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 3,187.56 47.27
DB CPU 2,219.18 32.91
connection management call elapsed time 156.46 2.32
parse time elapsed 57.00 0.85
hard parse elapsed time 1.95 0.03
hard parse (sharing criteria) elapsed time 1.74 0.03
PL/SQL execution elapsed time 0.18 0.00
PL/SQL compilation elapsed time 0.10 0.00
sequence load elapsed time 0.05 0.00
repeated bind elapsed time 0.03 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 6,743.15  
background elapsed time 5,078.69  
background cpu time 608.49  

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Value End Value
BUSY_TIME 377,792  
IDLE_TIME 25,560,134  
IOWAIT_TIME 386,557  
NICE_TIME 351  
SYS_TIME 70,681  
USER_TIME 281,914  
LOAD 2 1
RSRC_MGR_CPU_WAIT_TIME 6  
PHYSICAL_MEMORY_BYTES 33,705,119,744  
NUM_CPUS 24  
NUM_CPU_CORES 12  
NUM_CPU_SOCKETS 2  
GLOBAL_RECEIVE_SIZE_MAX 4,194,304  
GLOBAL_SEND_SIZE_MAX 1,048,576  
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
14-5月 21:00:17 1.50          
14-5月 22:00:21 1.38 1.39 1.03 0.28 98.61 1.42
14-5月 23:00:17 1.59 1.62 1.22 0.29 98.38 1.69
15-5月 00:00:25 1.42 1.36 1.02 0.25 98.64 1.36

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time
Commit 264,505 0 3,075 12 45.61
DB CPU     2,219   32.91
Cluster 1,566,593 0 1,748 1 25.92
User I/O 19,257 0 52 3 0.77
Network 3,397,417 0 10 0 0.15
Other 11,562 48 10 1 0.15
Application 311 0 1 4 0.02
Concurrency 1,328 2 1 1 0.02
Configuration 208 73 1 3 0.01
Administrative 1 100 0 101 0.00
System I/O 28 0 0 0 0.00
Scheduler 1 0 0 0 0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % DB time
log file sync 264,505 0 3,075 12 1.05 45.61
gc cr block busy 125,502 0 956 8 0.50 14.18
gc cr block 2-way 769,312 0 276 0 3.05 4.10
gc current block busy 14,231 0 187 13 0.06 2.77
gc current block 2-way 340,074 0 119 0 1.35 1.76
gc current grant busy 260,633 0 74 0 1.03 1.10
gc cr multi block request 27,407 0 67 2 0.11 0.99
gc buffer busy release 9,295 0 60 6 0.04 0.89
direct path write 2,596 0 32 12 0.01 0.48
db file sequential read 3,151 0 16 5 0.01 0.24
SQL*Net message to client 3,276,410 0 8 0 12.98 0.12
latch free 2,923 0 3 1 0.01 0.04
Disk file operations I/O 11,642 0 3 0 0.05 0.04
name-service call wait 36 0 3 72 0.00 0.04
gc buffer busy acquire 1,133 0 2 2 0.00 0.03
gc cr block congested 5,532 0 2 0 0.02 0.03
gc current grant 2-way 8,494 0 2 0 0.03 0.03
SQL*Net more data to client 117,951 0 2 0 0.47 0.03
CSS initialization 454 0 2 4 0.00 0.03
enq: TX - row lock contention 300 0 1 5 0.00 0.02
CSS operation: action 454 0 1 3 0.00 0.02
direct path read 1,862 0 1 1 0.01 0.02
gcs drm freeze in enter server mode 32 0 1 34 0.00 0.02
gc current retry 2,304 0 1 0 0.01 0.01
gc current block congested 2,347 0 1 0 0.01 0.01
gc remaster 20 0 1 34 0.00 0.01
cursor: pin S wait on X 6 0 0 59 0.00 0.01
CSS operation: query 1,362 0 0 0 0.01 0.00
resmgr:internal state change 3 100 0 101 0.00 0.00
row cache lock 673 0 0 0 0.00 0.00
enq: HW - contention 200 76 0 1 0.00 0.00
log file switch completion 2 0 0 100 0.00 0.00
log buffer space 6 0 0 18 0.00 0.00
JS kgl get object wait 1 100 0 101 0.00 0.00
gc current multi block request 220 0 0 0 0.00 0.00
DFS lock handle 130 15 0 1 0.00 0.00
library cache: mutex X 43 0 0 2 0.00 0.00
IPC send completion sync 148 0 0 0 0.00 0.00
SQL*Net more data from client 3,056 0 0 0 0.01 0.00
library cache lock 96 18 0 0 0.00 0.00
library cache pin 101 0 0 0 0.00 0.00
enq: PS - contention 55 33 0 0 0.00 0.00
lock escalate retry 729 100 0 0 0.00 0.00
gc current grant congested 62 0 0 0 0.00 0.00
control file sequential read 28 0 0 0 0.00 0.00
buffer busy waits 147 0 0 0 0.00 0.00
asynch descriptor resize 4,398 100 0 0 0.02 0.00
latch: cache buffers chains 248 0 0 0 0.00 0.00
PX Deq: Slave Session Stats 55 0 0 0 0.00 0.00
KJC: Wait for msg sends to complete 385 0 0 0 0.00 0.00
gc cr grant 2-way 26 0 0 0 0.00 0.00
enq: TM - contention 11 0 0 1 0.00 0.00
library cache load lock 3 0 0 2 0.00 0.00
PX Deq: reap credit 370 100 0 0 0.00 0.00
enq: JS - job run lock - synchronize 10 100 0 0 0.00 0.00
enq: JQ - contention 4 100 0 0 0.00 0.00
SQL*Net message from client 3,276,400 0 1,811,191 553 12.98  
jobq slave wait 3,749 100 1,878 501 0.01  
PX Deq: Execution Msg 220 0 3 12 0.00  

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % bg time
log file parallel write 293,268 0 3,051 10 1.16 60.07
gcs log flush sync 208,368 16 1,027 5 0.83 20.21
db file parallel write 28,349 0 392 14 0.11 7.72
control file parallel write 4,868 0 78 16 0.02 1.53
control file sequential read 28,569 0 37 1 0.11 0.72
reliable message 694 1 11 17 0.00 0.23
os thread startup 133 0 5 36 0.00 0.10
DFS lock handle 5,433 11 3 1 0.02 0.06
PX Nsq: PQ load info query 12 100 2 201 0.00 0.05
ges lms sync during dynamic remastering and reconfig 240 33 2 7 0.00 0.03
enq: CO - master slave det 3,600 100 1 0 0.01 0.03
enq: WF - contention 50 0 1 29 0.00 0.03
libcache interrupt action by LCK 31,625 0 1 0 0.13 0.02
CGS wait for IPC msg 102,877 100 1 0 0.41 0.02
CSS operation: data query 516 0 1 2 0.00 0.02
name-service call wait 18 0 1 41 0.00 0.01
gc current block busy 26 0 1 26 0.00 0.01
gc current block 2-way 1,074 0 0 0 0.00 0.01
ASM file metadata operation 3,215 0 0 0 0.01 0.01
ksxr poll remote instances 28,351 100 0 0 0.11 0.01
gc cr block 2-way 915 0 0 0 0.00 0.01
gc cr block busy 14 0 0 18 0.00 0.01
row cache lock 539 0 0 0 0.00 0.00
db file sequential read 105 0 0 2 0.00 0.00
row cache process 38,176 0 0 0 0.15 0.00
CSS operation: action 462 0 0 0 0.00 0.00
enq: TM - contention 20 85 0 8 0.00 0.00
gc buffer busy release 10 0 0 15 0.00 0.00
log file sync 6 0 0 22 0.00 0.00
enq: CF - contention 321 100 0 0 0.00 0.00
gc current grant busy 437 0 0 0 0.00 0.00
SQL*Net more data to client 6,887 0 0 0 0.03 0.00
CSS group membership query 172 0 0 1 0.00 0.00
ges LMON to get to FTDONE 9 0 0 13 0.00 0.00
asynch descriptor resize 7,057 100 0 0 0.03 0.00
row cache cleanup 33,217 0 0 0 0.13 0.00
ADR block file write 15 0 0 6 0.00 0.00
latch free 34 0 0 2 0.00 0.00
SQL*Net more data from client 6,887 0 0 0 0.03 0.00
ADR block file read 45 0 0 1 0.00 0.00
direct path read 5 0 0 11 0.00 0.00
direct path write 4 0 0 12 0.00 0.00
gcs drm freeze in enter server mode 3 0 0 16 0.00 0.00
rdbms ipc reply 1 0 0 47 0.00 0.00
enq: PS - contention 53 32 0 1 0.00 0.00
db file async I/O submit 26,464 0 0 0 0.10 0.00
log file single write 4 0 0 7 0.00 0.00
PX Deq: reap credit 3,548 100 0 0 0.01 0.00
gc current grant 2-way 112 0 0 0 0.00 0.00
SQL*Net message to client 27,539 0 0 0 0.11 0.00
enq: US - contention 109 0 0 0 0.00 0.00
CSS initialization 6 0 0 4 0.00 0.00
Disk file operations I/O 487 0 0 0 0.00 0.00
log file sequential read 4 0 0 4 0.00 0.00
library cache pin 46 0 0 0 0.00 0.00
library cache lock 40 10 0 0 0.00 0.00
buffer busy waits 308 0 0 0 0.00 0.00
enq: TA - contention 36 0 0 0 0.00 0.00
PX Deq: Slave Session Stats 54 0 0 0 0.00 0.00
LGWR wait for redo copy 344 0 0 0 0.00 0.00
gc current multi block request 22 0 0 0 0.00 0.00
PX Deq: Signal ACK RSG 54 0 0 0 0.00 0.00
enq: FB - contention 21 0 0 0 0.00 0.00
enq: TD - KTF dump entries 22 0 0 0 0.00 0.00
enq: PI - contention 17 100 0 0 0.00 0.00
IPC send completion sync 36 0 0 0 0.00 0.00
enq: RO - fast object reuse 16 0 0 0 0.00 0.00
enq: MW - contention 6 0 0 1 0.00 0.00
enq: TK - Auto Task Serialization 10 100 0 0 0.00 0.00
enq: HW - contention 10 0 0 0 0.00 0.00
PX Deq: Signal ACK EXT 54 0 0 0 0.00 0.00
gc current block congested 10 0 0 0 0.00 0.00
CSS operation: query 190 0 0 0 0.00 0.00
gc object scan 222 100 0 0 0.00 0.00
KJC: Wait for msg sends to complete 21 0 0 0 0.00 0.00
ges inquiry response 8 0 0 0 0.00 0.00
enq: TT - contention 9 100 0 0 0.00 0.00
enq: DR - contention 6 0 0 0 0.00 0.00
gc cr multi block request 4 0 0 0 0.00 0.00
enq: CR - block range reuse ckpt 3 0 0 0 0.00 0.00
gc cr block congested 3 0 0 0 0.00 0.00
rdbms ipc message 733,021 25 223,214 305 2.90  
wait for unread message on broadcast channel 21,610 90 21,618 1000 0.09  
DIAG idle wait 270,295 71 21,536 80 1.07  
class slave wait 1,148 0 21,371 18616 0.00  
gcs remote message 4,112,182 29 20,373 5 16.29  
Space Manager: slave idle wait 3,119 99 15,454 4955 0.01  
dispatcher timer 181 100 10,860 60002 0.00  
smon timer 103 19 10,834 105188 0.00  
shared server idle wait 361 100 10,830 30001 0.00  
Streams AQ: qmn coordinator idle wait 752 50 10,810 14376 0.00  
Streams AQ: qmn slave idle wait 376 0 10,810 28751 0.00  
ASM background timer 2,161 0 10,809 5002 0.01  
GCR sleep 2,162 100 10,807 4999 0.01  
ges remote message 144,916 70 10,804 75 0.57  
PING 4,279 20 10,804 2525 0.02  
pmon timer 3,601 100 10,803 3000 0.01  
PX Idle Wait 73 0 7,113 97434 0.00  
SQL*Net message from client 34,426 0 10 0 0.14  
heartbeat monitor sleep 122 0 0 2 0.00  
PX Deq: Parse Reply 54 0 0 3 0.00  
PX Deq: Join ACK 54 0 0 3 0.00  
KSV master wait 6,936 95 0 0 0.03  
PX Deq: Execute Reply 54 0 0 0 0.00  
Streams AQ: RAC qmn coordinator idle wait 772 100 0 0 0.00  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

    % of Waits
Event Total Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
ADR block file read 45 73.3 2.2 8.9 15.6        
ADR block file write 15       93.3 6.7      
ADR file lock 18 100.0              
ASM file metadata operation 3216 99.8 .0 .0 .1     .1  
CGS wait for IPC msg 102.9K 100.0              
CSS group membership query 172 98.3 1.7            
CSS initialization 460 50.0     48.0 2.0      
CSS operation: action 916 48.9 .8 50.3          
CSS operation: data query 516   98.8 1.2          
CSS operation: query 1552 85.4 14.5 .1          
DFS lock handle 5563 99.5 .2 .1       .3  
Disk file operations I/O 12.1K 100.0 .0            
IPC send completion sync 184 99.5 .5            
JS kgl get object wait 1             100.0  
KJC: Wait for msg sends to complete 406 100.0              
LGWR wait for redo copy 344 100.0              
PX Deq: Signal ACK EXT 54 100.0              
PX Deq: Signal ACK RSG 54 100.0              
PX Deq: Slave Session Stats 109 100.0              
PX Deq: reap credit 3918 100.0              
PX Nsq: PQ load info query 12             100.0  
SQL*Net message to client 3303.8K 100.0              
SQL*Net more data from client 9942 100.0              
SQL*Net more data to client 124.8K 100.0              
asynch descriptor resize 11.5K 100.0              
buffer busy waits 455 99.8     .2        
control file parallel write 4867     .8 6.8 65.7 23.4 3.3 .0
control file sequential read 28.6K 94.4 .5 .5 1.4 1.0 .9 1.2  
cursor: mutex S 2 100.0              
cursor: mutex X 2 100.0              
cursor: pin S 2 100.0              
cursor: pin S wait on X 6         33.3 16.7 50.0  
db file async I/O submit 26.5K 100.0              
db file parallel write 28.3K 1.1 1.0 3.8 21.9 48.3 19.8 4.0  
db file sequential read 3243 49.3 1.6 7.6 26.2 9.3 4.2 1.8  
direct path read 1867 96.7   .3 1.0 1.1 .5 .4  
direct path write 2600   .0 18.3 28.3 34.8 12.7 5.9  
enq: AF - task serialization 2 100.0              
enq: CF - contention 321 100.0              
enq: CO - master slave det 3599 99.8 .2            
enq: CR - block range reuse ckpt 3 100.0              
enq: DR - contention 6 100.0              
enq: FB - contention 23 100.0              
enq: HW - contention 210 97.1 .5 .5 .5   .5 1.0  
enq: JQ - contention 4 100.0              
enq: JS - job run lock - synchronize 10 100.0              
enq: KD - determine DBRM master 2 100.0              
enq: KM - contention 1 100.0              
enq: MW - contention 6 83.3   16.7          
enq: PI - contention 17 100.0              
enq: PS - contention 108 99.1 .9            
enq: RO - fast object reuse 16 100.0              
enq: TA - contention 35 100.0              
enq: TD - KTF dump entries 22 100.0              
enq: TK - Auto Task Serialization 10 90.0 10.0            
enq: TM - contention 31 93.5           6.5  
enq: TT - contention 9 100.0              
enq: TX - index contention 2 100.0              
enq: TX - row lock contention 300 56.0 3.3 1.7 1.3 37.7      
enq: US - contention 1 100.0              
enq: WF - contention 50 92.0           8.0  
gc buffer busy acquire 1133 91.5 3.3 1.1 1.8 1.6 .4 .2 .1
gc buffer busy release 9306 31.8 .8 5.2 24.5 33.5 4.1 .2  
gc cr block 2-way 770.3K 100.0 .0 .0 .0 .0      
gc cr block busy 125.5K 5.5 6.8 15.6 31.6 36.1 3.9 .5 .0
gc cr block congested 5536 100.0 .0            
gc cr grant 2-way 28 100.0              
gc cr grant congested 2 100.0              
gc cr multi block request 27.4K 75.3 1.8 4.5 7.4 9.6 1.4 .1  
gc current block 2-way 341.2K 100.0 .0 .0 .0 .0      
gc current block busy 14.3K 8.6 .4 2.8 10.3 55.3 19.8 2.9  
gc current block congested 2357 100.0              
gc current grant 2-way 8609 100.0 .0            
gc current grant busy 261.1K 99.9 .0 .0 .0 .0 .0    
gc current grant congested 63 100.0              
gc current multi block request 243 100.0              
gc current retry 2305 98.2     .0 1.8      
gc object scan 222 100.0              
gc remaster 20       15.0 10.0 50.0 25.0  
gcs drm freeze in enter server mode 35 2.9       5.7 34.3 57.1  
gcs log flush sync 208.4K 19.6 10.1 18.1 27.1 25.2      
ges LMON to get to FTDONE 9         100.0      
ges inquiry response 8 100.0              
ges lms sync during dynamic remastering and reconfig 240   28.8 4.6 33.8 32.9      
ges2 LMON to wake up LMD - mrcvr 2 100.0              
global enqueue expand wait 9 100.0              
ksxr poll remote instances 28.6K 100.0              
latch free 2957 49.5 50.0 .2 .1 .1      
latch: cache buffers chains 264 100.0              
latch: call allocation 4 100.0              
latch: gc element 25 100.0              
latch: gcs resource hash 6 100.0              
latch: ges resource hash list 8 100.0              
latch: object queue header operation 1 100.0              
libcache interrupt action by LCK 31.8K 100.0 .0            
library cache load lock 3 33.3 33.3 33.3          
library cache lock 160 100.0              
library cache pin 172 100.0              
library cache: mutex X 43 86.0       14.0      
lock escalate retry 729 100.0              
log buffer space 6 16.7 16.7     16.7 33.3 16.7  
log file parallel write 293.3K .0 .2 9.2 23.7 57.6 9.0 .3 .0
log file sequential read 4 50.0     50.0        
log file single write 4       50.0 50.0      
log file switch completion 2             100.0  
log file sync 264.5K .1 .2 6.2 21.0 56.7 14.9 .8 .0
name-service call wait 54       1.9 5.6 9.3 83.3  
os thread startup 133           81.2 18.8  
rdbms ipc reply 1             100.0  
read by other session 1 100.0              
reliable message 681 82.5 11.9 3.2   .3   2.1  
resmgr:cpu quantum 1 100.0              
resmgr:internal state change 3             100.0  
row cache cleanup 33.5K 100.0              
row cache lock 1320 99.2 .7 .1          
row cache process 38.7K 100.0              
utl_file I/O 5 100.0              
ASM background timer 2162               100.0
DIAG idle wait 270.3K 9.7 .7 .5 .2 13.3 28.2 47.4  
GCR sleep 2162 .0             100.0
KSV master wait 6936 100.0              
PING 4279 80.0             20.0
PX Deq: Execute Reply 54 100.0              
PX Deq: Execution Msg 220 97.7 1.4 .5         .5
PX Deq: Join ACK 54 31.5 9.3 27.8 31.5        
PX Deq: Parse Reply 54 31.5 5.6 33.3 29.6        
PX Idle Wait 55 30.9 1.8       10.9 21.8 34.5
SQL*Net message from client 3310.6K 84.7 9.4 4.0 .7 .1 .1 .5 .6
Space Manager: slave idle wait 3119       .0 .1 .0 .5 99.3
Streams AQ: RAC qmn coordinator idle wait 772 100.0              
Streams AQ: qmn coordinator idle wait 752 49.9     .1       50.0
Streams AQ: qmn slave idle wait 376               100.0
class slave wait 1148 32.9       .1 .4 27.5 39.0
dispatcher timer 181               100.0
gcs remote message 4112.4K 29.5 12.0 12.4 12.6 33.5 .0    
ges remote message 145K 21.1 1.9 1.1 .9 1.3 1.4 72.4  
heartbeat monitor sleep 122   3.3 96.7          
jobq slave wait 3768             100.0  
pmon timer 3601               100.0
rdbms ipc message 733.2K 37.8 .9 1.0 13.0 12.8 6.5 19.9 8.0
shared server idle wait 361               100.0
smon timer 105       1.0 1.9 1.0 15.2 81.0
wait for unread message on broadcast channel 21.6K     .0 .0 .0   100.0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

    % of Total Waits
Event Waits 64ms to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s
ASM file metadata operation 2 99.9 .1            
DFS lock handle 17 99.7 .2 .1 .0        
JS kgl get object wait 1     100.0          
PX Nsq: PQ load info query 12       100.0        
control file parallel write 163 96.7 2.4 .8 .0 .1 .0 .0  
control file sequential read 343 98.8 .9 .3          
cursor: pin S wait on X 3 50.0 33.3   16.7        
db file parallel write 1127 96.0 2.9 1.0 .0 .0 .0    
db file sequential read 59 98.2 1.3 .5 .0        
direct path read 8 99.6 .3 .2          
direct path write 153 94.1 4.6 1.3          
enq: HW - contention 2 99.0 .5 .5          
enq: TM - contention 2 93.5   6.5          
enq: WF - contention 4 92.0 2.0 2.0     4.0    
gc buffer busy acquire 3 99.7 .2         .1  
gc buffer busy release 14 99.8 .2            
gc cr block busy 600 99.5 .4 .1 .0 .0 .0 .0  
gc cr multi block request 41 99.9 .1 .0          
gc current block busy 410 97.1 2.4 .4 .0 .0      
gc remaster 5 75.0 5.0 20.0          
gcs drm freeze in enter server mode 20 42.9 57.1            
log buffer space 1 83.3 16.7            
log file parallel write 995 99.7 .3 .0 .0 .0 .0 .0  
log file switch completion 2     50.0 50.0        
log file sync 2176 99.2 .8 .0 .0 .0 .0 .0  
name-service call wait 45 16.7 42.6 40.7          
os thread startup 25 81.2 8.3 10.5          
rdbms ipc reply 1   100.0            
reliable message 14 97.9 .3     .1 1.6    
resmgr:internal state change 3     100.0          

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

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

Service Name DB Time (s) DB CPU (s) Physical Reads (K) Logical Reads (K)
rac 6,736 2,212 5 235,989
SYS$USERS 7 7 0 1,324
SYS$BACKGROUND 1 1 0 1,095
racXDB 0 0 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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
rac 19172 52 1065 1 0 0 3397417 10
SYS$USERS 85 0 263 0 1 0 0 0
SYS$BACKGROUND 600 0 32623 6 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text
2,347.10 231,895 0.01 34.81 38.09 0.00 awkgmxcpx9wrn JDBC Thin Client update t_aaa_failure_record se...
114.87 3,350 0.03 1.70 99.83 0.00 ad1as6vh0211f JDBC Thin Client select count(1) from T_ASSET t...
59.52 1,509 0.04 0.88 67.67 0.00 gg0ng5y6g56g3 JDBC Thin Client select * from t_aaa_failure_re...
48.49 1,997 0.02 0.72 99.78 0.00 8unvs6q1jxc6x JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
44.85 818,056 0.00 0.67 96.64 0.00 520mkxqpf15q8 JDBC Thin Client select 1 from dual
29.11 3,851 0.01 0.43 15.71 79.82 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
25.34 1,643 0.02 0.38 98.58 0.14 0ytzfcqrmg7mg JDBC Thin Client SELECT g.goods_code, g.charge_...
23.29 2,004 0.01 0.35 98.83 0.00 72xbby28c09u0 JDBC Thin Client select count(1) from T_CONTENT...
21.43 47 0.46 0.32 99.05 0.00 1wdgz5q0jp61z JDBC Thin Client select tr.resource_id, (select...
17.91 21 0.85 0.27 95.26 0.00 748w2qgxqq4yy JDBC Thin Client DELETE FROM t_prod_resource_r ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Executions CPU per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
894.07 231,895 0.00 40.29 2,347.10 38.09 0.00 awkgmxcpx9wrn JDBC Thin Client update t_aaa_failure_record se...
114.67 3,350 0.03 5.17 114.87 99.83 0.00 ad1as6vh0211f JDBC Thin Client select count(1) from T_ASSET t...
48.39 1,997 0.02 2.18 48.49 99.78 0.00 8unvs6q1jxc6x JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
43.35 818,056 0.00 1.95 44.85 96.64 0.00 520mkxqpf15q8 JDBC Thin Client select 1 from dual
40.28 1,509 0.03 1.82 59.52 67.67 0.00 gg0ng5y6g56g3 JDBC Thin Client select * from t_aaa_failure_re...
24.98 1,643 0.02 1.13 25.34 98.58 0.14 0ytzfcqrmg7mg JDBC Thin Client SELECT g.goods_code, g.charge_...
23.02 2,004 0.01 1.04 23.29 98.83 0.00 72xbby28c09u0 JDBC Thin Client select count(1) from T_CONTENT...
21.23 47 0.45 0.96 21.43 99.05 0.00 1wdgz5q0jp61z JDBC Thin Client select tr.resource_id, (select...
17.06 21 0.81 0.77 17.91 95.26 0.00 748w2qgxqq4yy JDBC Thin Client DELETE FROM t_prod_resource_r ...
13.38 235 0.06 0.60 13.45 99.46 0.06 fq46q8wa2u002 JDBC Thin Client SELECT program_guide_id, resou...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s) Executions UIO per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
23.23 3,851 0.01 44.38 29.11 15.71 79.82 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
0.50 6,884 0.00 0.95 8.02 79.53 6.21 f711myt0q6cma plsqldev.exe insert into sys.aud$( sessioni...
0.04 2,956 0.00 0.08 2.64 78.61 1.54 9xhgf9b1zm2uc JDBC Thin Client UPDATE t_record SET record_Id=...
0.04 3,145 0.00 0.07 1.58 76.74 2.29 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
0.04 1,643 0.00 0.07 25.34 98.58 0.14 0ytzfcqrmg7mg JDBC Thin Client SELECT g.goods_code, g.charge_...
0.02 6,633 0.00 0.05 4.74 92.55 0.51 5p8bhby6d49j4 JDBC Thin Client SELECT resource_id, count, act...
0.02 3,513 0.00 0.04 5.85 76.29 0.40 gdbf52r7fdakc JDBC Thin Client select Message_ID, Target_Syst...
0.01 154 0.00 0.02 6.89 99.12 0.13 grhbd41m9mt5c JDBC Thin Client SELECT g.goods_code, p.service...
0.01 3 0.00 0.02 0.03 36.13 28.53 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
0.01 235 0.00 0.02 13.45 99.46 0.06 fq46q8wa2u002 JDBC Thin Client SELECT program_guide_id, resou...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
177,334,942 231,895 764.72 74.38 2,347.10 38.1 0 awkgmxcpx9wrn JDBC Thin Client update t_aaa_failure_record se...
15,634,452 3,350 4,667.00 6.56 114.87 99.8 0 ad1as6vh0211f JDBC Thin Client select count(1) from T_ASSET t...
3,288,580 2,004 1,641.01 1.38 23.29 98.8 0 72xbby28c09u0 JDBC Thin Client select count(1) from T_CONTENT...
3,277,106 1,997 1,641.01 1.37 48.49 99.8 0 8unvs6q1jxc6x JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
2,103,693 1,509 1,394.10 0.88 59.52 67.7 0 gg0ng5y6g56g3 JDBC Thin Client select * from t_aaa_failure_re...
2,092,147 47 44,513.77 0.88 21.43 99.1 0 1wdgz5q0jp61z JDBC Thin Client select tr.resource_id, (select...
1,987,255 21 94,631.19 0.83 8.71 95.3 0 5yj05j020hb00 JDBC Thin Client INSERT INTO t_prod_resource_r ...
1,500,416 21 71,448.38 0.63 17.91 95.3 0 748w2qgxqq4yy JDBC Thin Client DELETE FROM t_prod_resource_r ...
1,019,706 1,643 620.64 0.43 25.34 98.6 .1 0ytzfcqrmg7mg JDBC Thin Client SELECT g.goods_code, g.charge_...
762,441 140 5,446.01 0.32 4.55 99.8 0 7cg5z518h6gn9 JDBC Thin Client select * from (select r.*, row...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
1,923 3,851 0.50 36.98 29.11 15.71 79.82 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
2 2,956 0.00 0.04 2.64 78.61 1.54 9xhgf9b1zm2uc JDBC Thin Client UPDATE t_record SET record_Id=...
1 47 0.02 0.02 13.06 99.73 0.02 0rs544sbmcvs8 JDBC Thin Client select * from (select r.*, row...
1 3 0.33 0.02 0.02 58.74 21.56 46zsasxjf8hb9   insert into WRH$_MEM_DYNAMIC_C...
1 3 0.33 0.02 0.03 36.13 28.53 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
0 19 0.00 0.00 2.72 99.39 0.00 0bfq5t8km62q6 JDBC Thin Client select count(1) from T_ASSET_R...
0 6,911 0.00 0.00 4.20 100.35 0.00 0k8522rmdzg4k   select privilege# from sysauth...
0 3,145 0.00 0.00 1.58 76.74 2.29 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
0 3 0.00 0.00 0.00 0.00 0.00 0pd1st1hz9cys   insert into WRH$_IC_CLIENT_STA...
0 3 0.00 0.00 0.01 86.22 17.85 0shksdzxpp4bh   select snap_interval, retentio...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs Physical Read Reqs Executions UnOptimized Reqs per Exec %Opt %Total SQL Id SQL Module SQL Text
0 0 19 0.00   0.00 0bfq5t8km62q6 JDBC Thin Client select count(1) from T_ASSET_R...
0 0 6,911 0.00   0.00 0k8522rmdzg4k   select privilege# from sysauth...
0 0 3,145 0.00   0.00 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
0 0 3 0.00   0.00 0pd1st1hz9cys   insert into WRH$_IC_CLIENT_STA...
0 0 47 0.00   0.00 0rs544sbmcvs8 JDBC Thin Client select * from (select r.*, row...
0 0 3 0.00   0.00 0shksdzxpp4bh   select snap_interval, retentio...
0 0 1 0.00   0.00 0tvn3sm19hawk   DECLARE job BINARY_INTEGER := ...
0 0 61 0.00   0.00 0tz5u0cm39vy1 JDBC Thin Client SELECT * FROM (SELECT rownum r...
0 0 6,887 0.00   0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
0 0 2 0.00   0.00 0xaytczkwj6gk   SELECT A.TASK_ID AS LOCAL_TID,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
818,056 818,063 1.00 44.85 96.6 0 520mkxqpf15q8 JDBC Thin Client select 1 from dual
231,895 380,273 1.64 2,347.10 38.1 0 awkgmxcpx9wrn JDBC Thin Client update t_aaa_failure_record se...
167,303 115,328 0.69 13.49 98.7 0 dzdw67zg9up2r JDBC Thin Client select Poster_ID, Poster_TYPE,...
85,188 0 0.00 12.89 98.4 0 gjttr6jnb8agk JDBC Thin Client select a.resource_id from t_as...
21,413 283,878 13.26 6.92 98.7 0 cm5vu20fhtnq1   select /*+ connect_by_filterin...
11,733 14,675 1.25 4.30 96.9 .1 27j6sqc76n6sc JDBC Thin Client SELECT g.goods_id, g.goods_cod...
6,911 21,413 3.10 4.20 100.3 0 0k8522rmdzg4k   select privilege# from sysauth...
6,887 6,887 1.00 2.78 100.1 0 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
6,887 6,887 1.00 2.32 99.3 0 459f3z9u4fb3u   select value$ from props$ wher...
6,887 6,887 1.00 1.67 96.4 0 5ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
6,911 6,911 6.62 0k8522rmdzg4k   select privilege# from sysauth...
6,911 21,413 6.62 cm5vu20fhtnq1   select /*+ connect_by_filterin...
6,887 6,887 6.59 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
6,887 6,887 6.59 459f3z9u4fb3u   select value$ from props$ wher...
6,887 6,887 6.59 5ur69atw3vfhj   select decode(failover_method,...
6,884 6,884 6.59 f711myt0q6cma plsqldev.exe insert into sys.aud$( sessioni...
6,836 818,056 6.54 520mkxqpf15q8 JDBC Thin Client select 1 from dual
963 6,698 0.92 ad7bwvn6pz8ug JDBC Thin Client SELECT tc.column_id, tc.goods_...
949 3,887 0.91 16a1pt4ryqxgn JDBC Thin Client SELECT t.key_code, t.key_value...
936 6,633 0.90 5p8bhby6d49j4 JDBC Thin Client SELECT resource_id, count, act...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
5,479,406 9 0.14 a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
4,409,180 13 0.11 89sdz401dc5uf   select program_oid, schedule_e...
3,530,305 3 0.09 2a99kfa1dykuy   update wrh$_seg_stat_obj sso s...
3,467,110 9 0.09 a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
2,900,123 3 0.08 6xpsr8v27pmy2   insert into WRH$_IOSTAT_FUNCTI...
2,458,020 3 0.06 abwkx4yjrgpg5   insert into WRH$_RSRC_PLAN (sn...
2,317,654 23 0.06 fstp7x8vrq235   UPDATE SYS.WRI$_ADV_TASKS SET ...
2,269,314 3 0.06 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
2,128,692 71 0.06 1821r9mfpmd7x JDBC Thin Client update T_MessageSync set statu...
2,034,972 17 0.05 6a4sh619v9b89 JDBC Thin Client update T_MessageSync set statu...
2,025,866 3 0.05 46zsasxjf8hb9   insert into WRH$_MEM_DYNAMIC_C...
2,002,881 3,851 0.05 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
1,949,857 3 0.05 0shksdzxpp4bh   select snap_interval, retentio...
1,915,300 13 0.05 b9g3c4yfaptmv JDBC Thin Client update T_MessageSync set statu...
1,757,547 3,513 0.05 gdbf52r7fdakc JDBC Thin Client select Message_ID, Target_Syst...
1,749,516 5 0.05 1q3bajqwg95cz   SELECT COUNT(*) FROM SYS.WRI$_...
1,727,676 80 0.04 3jms8sqxrjjv2 JDBC Thin Client update T_MessageSync set statu...
1,661,468 15 0.04 5ch7ahkr240am JDBC Thin Client update T_MessageSync set statu...
1,655,238 23 0.04 7gzxf61vj6wq4   SELECT ID FROM SYS.WRI$_ADV_TA...
1,618,287 478 0.04 1c32ab6qdapjv JDBC Thin Client SELECT record_Id, channel_Id, ...
1,566,512 205 0.04 dmtkbswwb5mc2 JDBC Thin Client select t.Resource_ID, t.PROVID...
1,494,964 3 0.04 f4cxyayn99cg6 JDBC Thin Client update T_MessageSync set statu...
1,491,268 6,633 0.04 5p8bhby6d49j4 JDBC Thin Client SELECT resource_id, count, act...
1,412,044 123 0.04 1rptaxp0t2rjg JDBC Thin Client update T_MessageSync set statu...
1,271,552 36 0.03 76cckj4yysvua   select time_mp, scn, num_mappi...
1,231,696 3,145 0.03 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
1,231,084 3 0.03 0pd1st1hz9cys   insert into WRH$_IC_CLIENT_STA...
1,193,488 61 0.03 0tz5u0cm39vy1 JDBC Thin Client SELECT * FROM (SELECT rownum r...
1,065,498 88 0.03 2mmfyjb2mzdsz JDBC Thin Client INSERT INTO t_res_column_resul...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
96 13 89sdz401dc5uf   select program_oid, schedule_e...
86 9 a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
86 9 a5mmhrrnpwjsc   SELECT OBJOID, CLSOID, (2*PRI ...
81 5 1q3bajqwg95cz   SELECT COUNT(*) FROM SYS.WRI$_...
79 71 1821r9mfpmd7x JDBC Thin Client update T_MessageSync set statu...
79 23 7gzxf61vj6wq4   SELECT ID FROM SYS.WRI$_ADV_TA...
78 3,851 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
78 23 fstp7x8vrq235   UPDATE SYS.WRI$_ADV_TASKS SET ...
76 3 0shksdzxpp4bh   select snap_interval, retentio...
76 3,513 gdbf52r7fdakc JDBC Thin Client select Message_ID, Target_Syst...
75 80 3jms8sqxrjjv2 JDBC Thin Client update T_MessageSync set statu...
70 123 1rptaxp0t2rjg JDBC Thin Client update T_MessageSync set statu...
69 6,633 5p8bhby6d49j4 JDBC Thin Client SELECT resource_id, count, act...
68 17 6a4sh619v9b89 JDBC Thin Client update T_MessageSync set statu...
66 5 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
65 3 abwkx4yjrgpg5   insert into WRH$_RSRC_PLAN (sn...
64 3 2a99kfa1dykuy   update wrh$_seg_stat_obj sso s...
64 13 b9g3c4yfaptmv JDBC Thin Client update T_MessageSync set statu...
61 3 32mk33ry1g665   INSERT INTO wrh$_datafile (sna...
60 3 46zsasxjf8hb9   insert into WRH$_MEM_DYNAMIC_C...
60 3 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
59 36 76cckj4yysvua   select time_mp, scn, num_mappi...
58 15 5ch7ahkr240am JDBC Thin Client update T_MessageSync set statu...
58 3 6xpsr8v27pmy2   insert into WRH$_IOSTAT_FUNCTI...
57 3 0pd1st1hz9cys   insert into WRH$_IC_CLIENT_STA...
52 478 1c32ab6qdapjv JDBC Thin Client SELECT record_Id, channel_Id, ...
50 3 f4cxyayn99cg6 JDBC Thin Client update T_MessageSync set statu...
49 88 2mmfyjb2mzdsz JDBC Thin Client INSERT INTO t_res_column_resul...
41 2,956 9xhgf9b1zm2uc JDBC Thin Client UPDATE t_record SET record_Id=...
37 1,509 gg0ng5y6g56g3 JDBC Thin Client select * from t_aaa_failure_re...
34 205 dmtkbswwb5mc2 JDBC Thin Client select t.Resource_ID, t.PROVID...
29 3,145 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
29 21 5yj05j020hb00 JDBC Thin Client INSERT INTO t_prod_resource_r ...
25 6,884 f711myt0q6cma plsqldev.exe insert into sys.aud$( sessioni...
24 21 748w2qgxqq4yy JDBC Thin Client DELETE FROM t_prod_resource_r ...
24 1,997 8unvs6q1jxc6x JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
24 5,304 dwfyuy8aw9kr4 JDBC Thin Client select t.column_id from t_res_...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s) Executions %Total Elapsed Time(s) %Clu %CPU %IO SQL Id SQL Module SQL Text
1,543.32 231,895 88.21 2,347.10 65.75 38.09 0.00 awkgmxcpx9wrn JDBC Thin Client update t_aaa_failure_record se...
21.71 1,509 1.24 59.52 36.47 67.67 0.00 gg0ng5y6g56g3 JDBC Thin Client select * from t_aaa_failure_re...
2.00 6,884 0.11 8.02 24.89 79.53 6.21 f711myt0q6cma plsqldev.exe insert into sys.aud$( sessioni...
1.44 3,513 0.08 5.85 24.56 76.29 0.40 gdbf52r7fdakc JDBC Thin Client select Message_ID, Target_Syst...
1.14 21 0.07 17.91 6.37 95.26 0.00 748w2qgxqq4yy JDBC Thin Client DELETE FROM t_prod_resource_r ...
1.13 3,851 0.06 29.11 3.90 15.71 79.82 bdzkhyda9xcbr JDBC Thin Client insert into T_MessageSync(Mess...
0.64 2,956 0.04 2.64 24.37 78.61 1.54 9xhgf9b1zm2uc JDBC Thin Client UPDATE t_record SET record_Id=...
0.46 1,643 0.03 25.34 1.80 98.58 0.14 0ytzfcqrmg7mg JDBC Thin Client SELECT g.goods_code, g.charge_...
0.44 3,145 0.03 1.58 27.79 76.74 2.29 0nxfwmpacw6mf JDBC Thin Client SELECT record_Id, channel_Id, ...
0.37 6,633 0.02 4.74 7.84 92.55 0.51 5p8bhby6d49j4 JDBC Thin Client SELECT resource_id, count, act...
0.36 21 0.02 8.71 4.11 95.28 0.00 5yj05j020hb00 JDBC Thin Client INSERT INTO t_prod_resource_r ...
0.31 2,004 0.02 23.29 1.35 98.83 0.00 72xbby28c09u0 JDBC Thin Client select count(1) from T_CONTENT...
0.26 205 0.01 7.36 3.53 96.99 0.09 dmtkbswwb5mc2 JDBC Thin Client select t.Resource_ID, t.PROVID...
0.15 3,350 0.01 114.87 0.13 99.83 0.00 ad1as6vh0211f JDBC Thin Client select count(1) from T_ASSET t...
0.09 478 0.01 1.43 6.46 94.09 0.00 1c32ab6qdapjv JDBC Thin Client SELECT record_Id, channel_Id, ...
0.09 235 0.01 13.45 0.69 99.46 0.06 fq46q8wa2u002 JDBC Thin Client SELECT program_guide_id, resou...
0.08 1,997 0.00 48.49 0.16 99.78 0.00 8unvs6q1jxc6x JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
0.07 154 0.00 6.89 1.05 99.12 0.13 grhbd41m9mt5c JDBC Thin Client SELECT g.goods_code, p.service...
0.06 3,482 0.00 0.58 10.89 86.82 0.27 35vrbm1z4nwz6 JDBC Thin Client select t.Resource_ID, t.PROVID...
0.05 47 0.00 21.43 0.22 99.05 0.00 1wdgz5q0jp61z JDBC Thin Client select tr.resource_id, (select...
0.04 47 0.00 13.06 0.34 99.73 0.02 0rs544sbmcvs8 JDBC Thin Client select * from (select r.*, row...
0.04 80 0.00 0.13 33.39 74.87 0.06 3jms8sqxrjjv2 JDBC Thin Client update T_MessageSync set statu...
0.04 123 0.00 0.11 33.98 71.79 0.05 1rptaxp0t2rjg JDBC Thin Client update T_MessageSync set statu...
0.04 17 0.00 0.06 61.66 43.32 0.02 6a4sh619v9b89 JDBC Thin Client update T_MessageSync set statu...
0.04 11,733 0.00 4.30 0.84 96.88 0.09 27j6sqc76n6sc JDBC Thin Client SELECT g.goods_id, g.goods_cod...
0.04 71 0.00 0.13 27.50 82.92 0.07 1821r9mfpmd7x JDBC Thin Client update T_MessageSync set statu...
0.03 167,303 0.00 13.49 0.24 98.72 0.00 dzdw67zg9up2r JDBC Thin Client select Poster_ID, Poster_TYPE,...
0.03 82 0.00 9.01 0.36 99.81 0.03 4kr4szjcxjd57 JDBC Thin Client SELECT a.record_id, a.key, a.d...
0.03 1 0.00 1.45 2.08 98.44 0.03 0tvn3sm19hawk   DECLARE job BINARY_INTEGER := ...
0.03 25 0.00 9.59 0.27 93.39 0.00 anu86szyzuahv JDBC Thin Client select * from (select r.*, row...
0.02 42 0.00 1.69 1.39 98.83 0.00 1bqb6snp9f82b JDBC Thin Client UPDATE t_failure_record SET ke...
0.02 5,304 0.00 1.37 1.41 100.02 0.12 dwfyuy8aw9kr4 JDBC Thin Client select t.column_id from t_res_...
0.02 4,870 0.00 0.87 1.75 95.67 0.17 9y4pjm1yqckzy JDBC Thin Client select t.LOCAL_PATH, t.SOURCE_...
0.02 19 0.00 2.72 0.55 99.39 0.00 0bfq5t8km62q6 JDBC Thin Client select count(1) from T_ASSET_R...
0.01 23 0.00 0.02 77.44 21.58 0.00 fstp7x8vrq235   UPDATE SYS.WRI$_ADV_TASKS SET ...
0.01 1,338 0.00 0.41 3.01 92.96 0.56 g0sasgzgjyuks JDBC Thin Client select t.resource_id, t.asset_...
0.01 3 0.00 7.53 0.16 99.81 0.00 7g732rx16j8jc   insert into WRH$_SERVICE_STAT ...
0.01 88 0.00 2.37 0.34 99.24 0.00 a5z1kp03n2hkj JDBC Thin Client SELECT count(1) FROM t_iepg_as...
0.01 65 0.00 1.35 0.52 99.79 0.00 6gyj4v6w9mdmf JDBC Thin Client SELECT RESOURCE_ID FROM (SELEC...
0.01 3 0.00 0.03 20.70 36.13 28.53 6403c5znjqh5b   insert into WRH$_RULE_SET (sna...
0.01 15 0.00 0.03 17.17 82.56 0.04 5ch7ahkr240am JDBC Thin Client update T_MessageSync set statu...
0.01 13 0.00 0.02 25.32 79.42 0.00 b9g3c4yfaptmv JDBC Thin Client update T_MessageSync set statu...
0.01 3,851 0.00 1.12 0.48 98.46 0.00 3nu1rc2y26dun JDBC Thin Client SELECT SEQ_MESSAGESYNC.NEXTVAL...
0.01 3 0.00 0.02 21.59 58.74 21.56 46zsasxjf8hb9   insert into WRH$_MEM_DYNAMIC_C...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
0bfq5t8km62q6 select count(1) from T_ASSET_R t1 where 1=1 and LOWER(t1.asset_name) like LOWER('%' || :1 || '%') ESCAPE '\' and not exists (select 1 from t_bms_resource_pkg_map b where b.resource_id = t1.resource_id and b.resource_id_pkg = :2) and t1.city_id = :3 and t1.type=:4 and t1.status=:5 and t1.asset_origin != 'mcap'
0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0nxfwmpacw6mf SELECT record_Id, channel_Id, channel_Name, program_Guide_Id, display_Name, video_Type, record_Status, begin_Time, end_Time, provider_Id, asset_Id, source_URL, failure_Code, failure_Message, platform, type, transfer_bit_rate , parent_id, last_modify, distribute_success, distribute_times, inject_addr_id, inject_addr_vn, city_id, is_encrypted, report_mark , ispaceUsed, PROGRAM_SYNC_RTM, duration, volumn_name FROM t_record WHERE PROGRAM_SYNC_RTM != 99 and platform = :1 and type = :2 and inject_addr_id = :3 and asset_Id = :4 and parent_id is null ORDER BY begin_Time desc
0pd1st1hz9cys insert into WRH$_IC_CLIENT_STATS (snap_id, dbid, instance_number, name, bytes_sent, bytes_received ) select :snap_id, :dbid, :instance_number, name, bytes_sent, bytes_rcv from x$ksxpclient
0rs544sbmcvs8 select * from (select r.*, rownum rn from ( select distinct asset.resource_id, asset.asset_name, asset.asset_types, asset.origin_name, asset.director, asset.leading_actor, asset.key_word, asset.year, asset.show_type, asset.record_type, asset.video_type, asset.letter_full, asset.letter_abbreviate from t_iepg_asset asset, t_res_column_map r where asset.resource_id = r.resource_id and asset.status = 1 ) r where rownum <= 100000) where rn >= 1
0shksdzxpp4bh select snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid
0tvn3sm19hawk DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PRO_UPDATE_CDR; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0tz5u0cm39vy1 SELECT * FROM (SELECT rownum ron, uuut.* FROM (select t1.OTT_LICENSING_WINDOW_END, t1.SUMMARY_SHORT, t1.ORIGIN_CODE, t1.CITY_ID, t1.CREATE_TIME, t1.OTT_LICENSING_WINDOW_START, t1.SUMMARY_LONG, t1.ISSUER_ID, t1.REMARK, t1.RECOMMENDATION_LEVEL, t1.SUMMARY_MEDIUM, t1.PUBLISH_DATE, t1.ASSET_NAME, t1.INGEST_FINISH_TIME, t1.SHOW_TYPE_FLAG, t1.ASSET_HEAD_PINYIN_NAME, t1.CHAPTERS, t1.SERIAL_ID, t1.LEVEL_TYPE, t1.OTT_SUGGESTED_PRICE, t1.TYPE, t1.ASSET_TYPE_ID, t1.EXPIRE_TIME, t1.DIRECTOR, t1.DESCRIPTION, t1.ASSET_ORIGIN_NAME, t1.RESOURCE_ID, t1.STB_LICENSING_WINDOW_END, t1.ASSET_TYPE, t1.PRIZE, t1.ASSET_PINYIN_NAME, t1.PLATFORM, t1.CONTENT_NIBBLE_LEVEL_2, t1.LEADING_ACTOR, t1.CONTENT_NIBBLE_LEVEL_1, t1.KEY_WORD, t1.POSITIVE_TOTAL, t1.CAPTION_CODE, t1.SUGGESTPRICE, t1.PUBLISH_YEAR, t1.ASSET_EN_NAME, t1.AMS_URL, t1.VIDEO_TYPE, t1.SERIES, t1.STATUS, t1.PROPAGATION_PRIORITY, t1.VIEW_LEVEL, t1.STB_SUGGESTED_PRICE, t1.ASSET_CODE, t1.STB_LICENSING_WINDOW_START, t1.COPYRIGHT_FILES, t1.EFFECTIVE_TIME, t1.SCORE, t1.IS_TASK_USED, t1.VCR, t1.PROVIDER_CODE, t1.LANGUAGE_CODE, t1.SHOW_TYPE, t1.AUDIO_TYPE, t1.PKG_ID, t1.ASSET_ORIGIN, t1.SCREENWRITER, t1.ASSET_ID from T_ASSET t1 where 1=1 and t1.type= :1 and t1.status = :2 and t1.city_id = :3 order by t1.city_id DESC, t1.create_time DESC) uuut WHERE rownum<=1800) WHERE ron>=1751
0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0xaytczkwj6gk SELECT A.TASK_ID AS LOCAL_TID, A.DATABASE_TIME AS DB_TIME, A.ACTIVE_SESSIONS AS ACS, AD.PERC_FLUSH_TIME AS FT, A.METER_LEVEL AS ML FROM DBA_ADDM_TASKS A, WRI$_ADV_ADDM_TASKS AD WHERE A.TASK_ID = AD.TASK_ID AND A.DBID = :B3 AND A.BEGIN_SNAP_ID = :B2 AND A.END_SNAP_ID = :B1 AND A.REQUESTED_ANALYSIS = 'INSTANCE' AND A.STATUS = 'COMPLETED' AND A.HOW_CREATED = 'AUTO'
0ytzfcqrmg7mg SELECT g.goods_code, g.charge_mode, g.end_time, t.resource_id FROM t_po_resource r, t_iepg_goods g, t_prodoffering p , ( SELECT resource_id FROM t_iepg_asset WHERE assetid = :1 UNION ALL SELECT asset.resource_id FROM t_iepg_asset asset , t_resource_pkg_map pkg WHERE pkg.RESOURCE_ID = asset.resource_id AND asset.assetid = :2 ) t WHERE t.resource_id = r.resource_id AND r.prodoffering_code =p.prodoffering_code AND g.prodoffering_code =p.prodoffering_code AND (g.status =0 OR g.status= 2)
16a1pt4ryqxgn SELECT t.key_code, t.key_value, t.key_desc, t.key_date_type, t.video_type, c.city_code FROM t_city c, t_sevice_param t WHERE t.key_code =:1 AND c.city_id = t.city_id AND c.city_code=:2
1821r9mfpmd7x update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 OR Message_ID=:4 )
1bqb6snp9f82b UPDATE t_failure_record SET key = :1, datatype = :2, operation = :3, comebacktimes = :4, failedaddress=:5 WHERE key = :6
1c32ab6qdapjv SELECT record_Id, channel_Id, channel_Name, program_Guide_Id, display_Name, video_Type, record_Status, begin_Time, end_Time, provider_Id, asset_Id, source_URL, failure_Code, failure_Message, platform, type, transfer_bit_rate , parent_id, last_modify, distribute_success, distribute_times, inject_addr_id, inject_addr_vn, city_id, is_encrypted, report_mark , ispaceUsed, PROGRAM_SYNC_RTM, duration, volumn_name FROM t_record WHERE PROGRAM_SYNC_RTM != 99 and channel_Id = :1 and platform = :2 and type = :3 and parent_id is null and ( end_Time >= :4 ) and report_mark=:5 order by begin_Time asc
1q3bajqwg95cz SELECT COUNT(*) FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND A.OWNER# = :B2 AND BITAND(A.PROPERTY, :B1 ) = :B1
1rptaxp0t2rjg update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 )
1wdgz5q0jp61z select tr.resource_id, (select f.column_id from t_column f where exists (select 1 from t_column t1 where t1.column_id = f.parent_id and t1.parent_id = 0) and exists (select 1 from t_column t where t.column_id = f.column_id START WITH column_id = tr.column_id CONNECT BY column_id = PRIOR PARENT_ID)) as column_id from t_res_column_map tr, t_iepg_asset r where tr.resource_id = r.resource_id and r.status = 1
27j6sqc76n6sc SELECT g.goods_id, g.goods_code, g.goods_name, g.goods_price, g.charge_mode, g.charge_term, g.charge_term_unit, g.price_desc, g.region, g.status, g.remark, g.begin_time, g.end_time, g.prodoffering_code, g.goods_type, g.ppv_id, packageid FROM t_po_resource r, t_iepg_goods g, t_prodoffering p WHERE r.prodoffering_code = p.prodoffering_code AND g.prodoffering_code = p.prodoffering_code AND r.resource_id = :1
2a99kfa1dykuy update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (select decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (ts#, obj#, dataobj#) in (select tsn_kewrseg, objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
2mmfyjb2mzdsz INSERT INTO t_res_column_result ( id, column_id, resource_id, proffering_id, goods_id, result ) values (:1, :2, :3, :4, :5, :6 )
32mk33ry1g665 INSERT INTO wrh$_datafile (snap_id, dbid, file#, creation_change#, filename, ts#, tsname, block_size) SELECT /*+ ordered index(f) index(ts) */ :lah_snap_id lah, :dbid dbid, f.file# file#, f.crscnbas + (f.crscnwrp * power(2, 32)) creation_change#, v.name filename, ts.ts# ts#, ts.name tsname, ts.blocksize block_size FROM v$dbfile v, file$ f, ts$ ts WHERE f.file# = v.file# and f.status$ = 2 and f.ts# = ts.ts# and not exists (SELECT 1 from wrh$_datafile dfh WHERE dfh.file# = f.file# AND dfh.creation_change# = (f.crscnbas + (f.crscnwrp * power(2, 32))) AND dfh.dbid = :dbid2)
35vrbm1z4nwz6 select t.Resource_ID, t.PROVIDER_CODE, t.ASSET_ID, t.Content_Name, t.File_Path, t.File_Name, t.Username, t.Password, t.STATUS, t.Transfer_Percent, t.DESTINATION, t.Transfer_Time, t.start_Next, t.Result_Message, t.Content_Type, t.Volume_Name, t.MARKER, t.PLATFORM, t.BITRATE, t.ENCRYPTED, t.RESOURCE_IDS, t.PARENT_ID, t.PROPAGATION_PRIORITY , t.ASSET_CLASS , t.DISTRIBUTE_FLAG , t.TIMES, t.FILE_SIZE, t.A3_ADDR_ID, ta.NAME as A3_ADDR_NAME, t.TRANSFER_ENDTIME, t.TASK_TYPE, t.TASK_START_TIME, t.TASK_END_TIME, t.LAST_MODIFY_DATE from T_Content_Distribute t left join T_A3_ADDR ta on t.A3_ADDR_ID = ta.ADDR_ID where t.PROVIDER_CODE = :1 and t.ASSET_ID =:2 and t.PARENT_ID is null
3jms8sqxrjjv2 update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 )
3nu1rc2y26dun SELECT SEQ_MESSAGESYNC.NEXTVAL AS messageID FROM DUAL
459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'
46zsasxjf8hb9 insert into WRH$_MEM_DYNAMIC_COMP (snap_id, dbid, instance_number, component, current_size, min_size, max_size, user_specified_size, oper_count, last_oper_type, last_oper_mode, last_oper_time, granule_size) select :snap_id, :dbid, :instance_number, component, current_size, min_size, max_size, user_specified_size, oper_count, last_oper_type, last_oper_mode, last_oper_time, granule_size from v$memory_dynamic_components
4kr4szjcxjd57 SELECT a.record_id, a.key, a.datatype, a.operation, a.comebacktimes, a.failedaddress FROM t_failure_record a WHERE a.key = :1 AND a.datatype = :2 AND a.operation != 3
520mkxqpf15q8 select 1 from dual
5ch7ahkr240am update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 OR Message_ID=:4 OR Message_ID=:5 )
5p8bhby6d49j4 SELECT resource_id, count, actual_count FROM t_iepg_asset_mod_total t WHERE t.resource_id=:1 and rownum <= 1
5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5yj05j020hb00 INSERT INTO t_prod_resource_r (prod_resource_id, prod_spec_id, resource_id ) (SELECT prod_resource_id, prod_spec_id, resource_id FROM t_prod_resource tmp WHERE tmp.prod_spec_id = :1 )
6403c5znjqh5b insert into WRH$_RULE_SET (snap_id, dbid, instance_number, owner, name, startup_time, cpu_time, elapsed_time, evaluations, sql_free_evaluations, sql_executions, reloads) select * from (select :snap_id, :dbid, :instance_number, rs.owner, rs.name, rs.first_load_time, rs.cpu_time, rs.elapsed_time, rs.evaluations, rs.sql_free_evaluations, rs.sql_executions, rs.reloads from v$rule_set rs order by rs.evaluations desc) where rownum <= 25
6a4sh619v9b89 update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 OR Message_ID=:4 OR Message_ID=:5 OR Message_ID=:6 )
6gyj4v6w9mdmf SELECT RESOURCE_ID FROM (SELECT (CASE WHEN TASK_TYPE = 1 AND T.TASK_START_TIME <= SYSDATE THEN 1 WHEN TASK_TYPE = 2 AND T.TASK_START_TIME <= SYSDATE THEN 2 WHEN TASK_TYPE = 3 AND T.TASK_START_TIME > SYSDATE OR SYSDATE > T.TASK_END_TIME THEN 3 END) FLAG, T.RESOURCE_ID FROM T_CONTENT_DISTRIBUTE T WHERE T.PARENT_ID IS NULL AND T.A3_ADDR_ID IS NULL AND T.STATUS IN (0, 2) AND T.TIMES < :1 AND T.DISTRIBUTE_FLAG = 1 AND T.ASSET_CLASS!=9 ORDER BY T.PROPAGATION_PRIORITY ASC, T.RESOURCE_ID DESC) WHERE FLAG IS NOT NULL AND ROWNUM <= :2
6xpsr8v27pmy2 insert into WRH$_IOSTAT_FUNCTION (snap_id, dbid, instance_number, function_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, large_read_reqs, large_write_reqs, number_of_waits, wait_time) (select :snap_id, :dbid, :instance_number, function_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(number_of_waits) number_of_waits, sum(wait_time) wait_time from v$iostat_function group by function_id)
72xbby28c09u0 select count(1) from T_CONTENT_DISTRIBUTE t where t.PARENT_ID is null and t.A3_ADDR_ID = :1 and t.STATUS = 1
748w2qgxqq4yy DELETE FROM t_prod_resource_r WHERE 1 = 1 AND prod_spec_id = :1
76cckj4yysvua select time_mp, scn, num_mappings, tim_scn_map from smon_scn_time where scn = (select max(scn) from smon_scn_time where scn <= :1)
7cg5z518h6gn9 select * from (select r.*, rownum rn from ( SELECT t.resource_id, t.asset_name, t.asset_en_name, t.ml_name, t.caption_name, t.asset_types, t.origin_name, t.issuer_name, t.track_type, t.chapters, t.view_level, t.describ, t.director, t.leading_actor, t.screenwriter, t.prize, t.key_word, t.remark, t.publish_date, t.create_time, t.effective_time, t.expire_time, t.city_id, t.record_type, t.media_type, t.status, t.providerid, t.video_type, t.RECOMMENDATION_LEVEL, t.USER_RECOMMEND_LEVEL, t.ASSETID, t.CP_FULLNAME, t.MOD_COUNT, t.VOD_COUNT, t.R_RECOM_COUNT, t.V_RECOM_COUNT, t.IS_UPSHELF FROM t_iepg_asset t WHERE t.status IN (1, 2) AND t.media_type != 3 AND t.PROVIDERID = 'SiTV' AND t.city_id = :1 and NOT EXISTS ( SELECT m.resource_id FROM t_res_cloumn_map m WHERE t.resource_id = m.resource_id and ( m.auto_up_shelf = 0 or m.auto_up_shelf = 2 ) ) AND t.sys_date >= sysdate - :2 ) r where rownum <= 50) where rn >= 1
7g732rx16j8jc insert into WRH$_SERVICE_STAT (snap_id, dbid, instance_number, service_name_hash, stat_id, value) select :snap_id, :dbid, :instance_number, stat.service_name_hash, stat.stat_id, stat.value from v$active_services asvc, v$service_stats stat where asvc.name_hash = stat.service_name_hash
7gzxf61vj6wq4 SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
89sdz401dc5uf select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1
8unvs6q1jxc6x SELECT RESOURCE_ID FROM (SELECT (CASE WHEN TASK_TYPE = 1 AND T.TASK_START_TIME <= SYSDATE THEN 1 WHEN TASK_TYPE = 2 AND T.TASK_START_TIME <= SYSDATE THEN 2 WHEN TASK_TYPE = 3 AND T.TASK_START_TIME > SYSDATE OR SYSDATE > T.TASK_END_TIME THEN 3 END) FLAG, T.RESOURCE_ID FROM T_CONTENT_DISTRIBUTE T WHERE T.PARENT_ID IS NULL AND T.A3_ADDR_ID = :1 AND T.STATUS IN (0, 2) AND T.TIMES < :2 AND T.DISTRIBUTE_FLAG = 1 AND T.ASSET_CLASS != 9 ORDER BY T.PROPAGATION_PRIORITY ASC, T.RESOURCE_ID DESC) WHERE FLAG IS NOT NULL AND ROWNUM <= :3
9xhgf9b1zm2uc UPDATE t_record SET record_Id=:1, channel_Id= :2, channel_Name= :3, program_Guide_Id= :4, display_Name=:5, video_Type= :6, record_Status= :7, begin_Time= :8, end_Time= :9, provider_Id= :10, asset_Id= :11, source_URL= :12, failure_Code= :13, failure_Message= :14, platform= :15, type= :16, transfer_bit_rate = :17, parent_id = :18, last_modify = sysdate, distribute_success= :19, distribute_times= :20, ISPACEUSED= :21, duration=:22, volumn_name = :23 where record_Id =:24
9y4pjm1yqckzy select t.LOCAL_PATH, t.SOURCE_ID, t.WIDTH, t.HEIGHT from t_resource_poster t where t.SOURCE_ID = :1 order by t.WIDTH desc
a5mmhrrnpwjsc SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
a5z1kp03n2hkj SELECT count(1) FROM t_iepg_asset t WHERE t.status IN (1, 2) AND t.media_type != 3 AND t.PROVIDERID = 'SiTV' AND t.city_id = :1 and NOT EXISTS ( SELECT m.resource_id FROM t_res_cloumn_map m WHERE t.resource_id = m.resource_id and ( m.auto_up_shelf = 0 or m.auto_up_shelf = 2 ) ) AND t.sys_date >= sysdate - :2
abwkx4yjrgpg5 insert into WRH$_RSRC_PLAN (snap_id, dbid, instance_number, sequence#, start_time, end_time, plan_id, plan_name, cpu_managed, parallel_execution_managed) (select :snap_id, :dbid, :instance_number, sequence#, start_time, end_time, id, name, cpu_managed, parallel_execution_managed from v$rsrc_plan_history where id is not null)
ad1as6vh0211f select count(1) from T_ASSET t1 where 1=1 and t1.type= :1 and t1.status = :2 and t1.city_id = :3
ad7bwvn6pz8ug SELECT tc.column_id, tc.goods_type, tc.parent_id, tc.alias, tc.relevant_chargemode, tc.resource_type, tc.abspath FROM t_column tc WHERE tc.display = 1 AND tc.column_id = :1
anu86szyzuahv select * from (select r.*, rownum rn from ( select t.* from t_iepg_program_guide t ) r where rownum <= 100000) where rn >= 1
awkgmxcpx9wrn update t_aaa_failure_record set key = :1, datatype = :2, operation = :3, comebacktimes = :4, failedaddress = :5 where DATATYPE = :6 and KEY = :7
b9g3c4yfaptmv update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 OR Message_ID=:4 OR Message_ID=:5 OR Message_ID=:6 OR Message_ID=:7 )
bdzkhyda9xcbr insert into T_MessageSync(Message_ID, Message_Content, Target_SystemName, Status, Retry_Times, Create_Date, Update_Date, Error_Code, Op_Code, ERROR_MESSAGE, URL_PARAM, PARAMETER_1, NODE_CODE, IS_SEND, FAIL_RETRY_TIMES) values (:1, :2, :3, :4, :5, sysdate, sysdate, :6, :7, :8, :9, :10, :11, :12, :13)
cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
dmtkbswwb5mc2 select t.Resource_ID, t.PROVIDER_CODE, t.ASSET_ID, t.Content_Name, t.File_Path, t.File_Name, t.Username, t.Password, t.STATUS, t.Transfer_Percent, t.DESTINATION, t.Transfer_Time, t.start_Next, t.Result_Message, t.Content_Type, t.Volume_Name, t.MARKER, t.PLATFORM, t.BITRATE, t.ENCRYPTED, t.RESOURCE_IDS, t.PARENT_ID, t.PROPAGATION_PRIORITY, t.ASSET_CLASS, t.DISTRIBUTE_FLAG, t.TIMES, t.FILE_SIZE, t.A3_ADDR_ID, ta.NAME as A3_ADDR_NAME, t.TRANSFER_ENDTIME, t.TASK_TYPE, t.TASK_START_TIME, t.TASK_END_TIME, t.LAST_MODIFY_DATE from T_Content_Distribute t left join T_A3_ADDR ta on t.A3_ADDR_ID = ta.ADDR_ID where t.PARENT_ID is null AND t.ASSET_CLASS=:1 AND t.STATUS not in (:2, 99) ORDER by t.Resource_ID DESC
dwfyuy8aw9kr4 select t.column_id from t_res_column_map t where (t.resource_id = :1) and exists (SELECT 1 FROM t_column tc WHERE tc.display = 1 and t.column_id = tc.column_id) union all select t.column_id from t_res_column_map t where exists (select 1 from t_resource_pkg_map m where m.resource_id = :2 and m.resource_id_pkg= t.resource_id) and exists (SELECT 1 FROM t_column tc WHERE tc.display = 1 and t.column_id = tc.column_id)
dzdw67zg9up2r select Poster_ID, Poster_TYPE, SOURCE_ID, File_Name, Upload_Time, File_Size, STATUS, ASSET_ID, LOCAL_PATH, HEIGHT, WIDTH, SOURCE_URL, PLATFORM from t_resource_poster t where t.SOURCE_ID = :1
f4cxyayn99cg6 update T_MessageSync set status=:1 where 1=1 and( Message_ID=:2 OR Message_ID=:3 OR Message_ID=:4 OR Message_ID=:5 OR Message_ID=:6 OR Message_ID=:7 OR Message_ID=:8 OR Message_ID=:9 )
f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fq46q8wa2u002 SELECT program_guide_id, resource_id, channel_id, channel_name, begin_time, end_time, event_name, event_desc, status, event_date, duration, assetid, view_level FROM (SELECT tp.program_guide_id, tp.resource_id, t.channel_id, t.channel_name, tp.begin_time, tp.end_time, tp.event_name, tp.event_desc, tp.status, tp.event_date, tp.duration, tp.assetid, tp.view_level FROM t_iepg_program_guide tp, t_iepg_channel t WHERE tp.resource_id = t.resource_id and (t.platform='1' or t.platform='3' or t.platform is null) and tp.resource_id in ( :1 ) AND tp.event_date = :2 order by tp.duration desc ) where rownum <= :3 ORDER BY end_time desc
fstp7x8vrq235 UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1
g0sasgzgjyuks select t.resource_id, t.asset_name, t.asset_en_name, t.ml_name, t.caption_name, t.asset_types, t.origin_name, t.issuer_name, t.track_type, t.chapters, t.status, t.view_level, nvl(t.describ, t.SUMMARY_Long) describ, t.director, t.leading_actor, t.screenwriter, t.prize, t.key_word, t.remark, t.recommendation_level, t.publish_date, t.user_recommend_level, t.letter_full, t.letter_abbreviate, t.providerid, t.summary_medium, t.summary_short, t.propagation_priority, nvl(t.effective_time, t.STB_LICENSING_WINDOW_START) effective_time, nvl(t.expire_time, t.STB_LICENSING_WINDOW_END) expire_time, t.record_type, t.assetid, t.show_type, t.year, t.stb_suggested_price suggestprice, t.video_type, t.play_time from t_iepg_asset t where 1 =1 and t.assetid = :1 order by t.resource_id desc
gdbf52r7fdakc select Message_ID, Target_SystemName, status, Retry_Times, Error_Code, Op_Code, Message_Content, ERROR_MESSAGE, URL_PARAM, PARAMETER_1, NODE_CODE, IS_SEND, TO_CHAR(Create_Date, 'yyyy-mm-dd hh24:mi:ss') as Create_Date, FAIL_RETRY_TIMES from T_MessageSync where rownum < :1 and status = :2 and (IS_SEND = :3 or IS_SEND is null) and Retry_Times <= :4 and TARGET_SYSTEMNAME = :5 and (Retry_Times = 0 or (Retry_Times > 0 and (sysdate - :6 / (24 * 60 * 60)) > Update_Date)) order by Message_ID asc
gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gg0ng5y6g56g3 select * from t_aaa_failure_record t where t.STAUTS = 1
gjttr6jnb8agk select a.resource_id from t_asset a where a.resource_id in ( select p.SOURCE_ID from t_resource_poster p LEFT JOIN t_bms_resource_pkg_map_r b ON b.resource_id= p.SOURCE_ID where b.resource_id_pkg = :1 ) order by a.chapters asc
grhbd41m9mt5c SELECT g.goods_code, p.servicetype, r.resource_id FROM t_po_resource r, t_iepg_goods g, t_prodoffering p, t_iepg_channel c WHERE r.prodoffering_code = p.prodoffering_code AND g.prodoffering_code = p.prodoffering_code AND r.resource_id = c.resource_id AND c.resource_id in ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

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 1 0.00 0.00
Batched IO buffer defrag count 0 0.00 0.00
Batched IO double miss count 1 0.00 0.00
Batched IO same unit count 0 0.00 0.00
Batched IO single block count 1 0.00 0.00
Batched IO slow jump 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 331 0.03 0.00
CCursor + sql area evicted 0 0.00 0.00
CPU used by this session 232,761 21.54 0.92
CPU used when call started 187,976 17.39 0.74
CR blocks created 53,525 4.95 0.21
Cached Commit SCN referenced 11,106 1.03 0.04
Commit SCN cached 516 0.05 0.00
DB time 830,165 76.81 3.29
DBWR checkpoint buffers written 256,862 23.77 1.02
DBWR checkpoints 9 0.00 0.00
DBWR fusion writes 9,053 0.84 0.04
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 619 0.06 0.00
DBWR undo block writes 246,183 22.78 0.98
DFO trees parallelized 36 0.00 0.00
Effective IO time 1,178,150 109.01 4.67
HSC Heap Segment Block Changes 916,818 84.83 3.63
HSC IDL Compressed Blocks 0 0.00 0.00
Heap Segment Array Inserts 4,851 0.45 0.02
Heap Segment Array Updates 377,659 34.94 1.50
IPC CPU used by this session 0 0.00 0.00
LOB table id lookup cache misses 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
Number of read IOs issued 1,963 0.18 0.01
OS Involuntary context switches 0 0.00 0.00
OS Maximum resident set size 0 0.00 0.00
OS Page reclaims 0 0.00 0.00
OS System time used 0 0.00 0.00
OS User time used 0 0.00 0.00
OS Voluntary context switches 0 0.00 0.00
PX local messages recv'd 72 0.01 0.00
PX local messages sent 72 0.01 0.00
PX remote messages recv'd 146 0.01 0.00
PX remote messages sent 146 0.01 0.00
Parallel operations not downgraded 36 0.00 0.00
Requests to/from client 3,276,396 303.15 12.98
RowCR - row contention 0 0.00 0.00
RowCR attempts 142 0.01 0.00
RowCR hits 145 0.01 0.00
SMON posted for undo segment shrink 67 0.01 0.00
SQL*Net roundtrips to/from client 3,276,404 303.15 12.98
TBS Extension: bytes extended 0 0.00 0.00
TBS Extension: files extended 0 0.00 0.00
TBS Extension: tasks created 0 0.00 0.00
TBS Extension: tasks executed 0 0.00 0.00
active txn count during cleanout 24,321 2.25 0.10
application wait time 155 0.01 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 80,928 7.49 0.32
branch node splits 2 0.00 0.00
buffer is not pinned count 6,878,510 636.44 27.25
buffer is pinned count 10,786,263 998.00 42.73
bytes received via SQL*Net from client 303,841,848 28,113.01 1,203.64
bytes sent via SQL*Net to client 1,537,384,163 142,246.70 6,090.22
calls to get snapshot scn: kcmgss 1,858,405 171.95 7.36
calls to kcmgas 2,291,639 212.03 9.08
calls to kcmgcs 2,863,641 264.96 11.34
cell physical IO interconnect bytes 8,788,103,168 813,120.58 34,813.33
change write time 2,762 0.26 0.01
cleanout - number of ktugct calls 24,706 2.29 0.10
cleanouts and rollbacks - consistent read gets 20,694 1.91 0.08
cleanouts only - consistent read gets 228 0.02 0.00
cluster key scan block gets 1,997 0.18 0.01
cluster key scans 1,197 0.11 0.00
cluster wait time 174,959 16.19 0.69
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 231,898 21.46 0.92
commit batch/immediate requested 231,898 21.46 0.92
commit cleanout failures: block lost 6 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 25 0.00 0.00
commit cleanout failures: cannot pin 15 0.00 0.00
commit cleanouts 108,346 10.02 0.43
commit cleanouts successfully completed 108,300 10.02 0.43
commit immediate performed 231,898 21.46 0.92
commit immediate requested 231,898 21.46 0.92
commit txn count during cleanout 6,334 0.59 0.03
concurrency wait time 714 0.07 0.00
consistent changes 28,348 2.62 0.11
consistent gets 232,498,966 21,512.00 921.03
consistent gets - examination 2,259,125 209.03 8.95
consistent gets direct 5,857 0.54 0.02
consistent gets from cache 232,493,109 21,511.46 921.00
consistent gets from cache (fastpath) 228,887,391 21,177.84 906.72
cursor authentications 150 0.01 0.00
data blocks consistent reads - undo records applied 27,601 2.55 0.11
db block changes 5,299,208 490.31 20.99
db block gets 5,905,125 546.37 23.39
db block gets direct 2,637 0.24 0.01
db block gets from cache 5,902,488 546.13 23.38
db block gets from cache (fastpath) 1,939,846 179.48 7.68
deferred (CURRENT) block cleanout applications 40,824 3.78 0.16
dirty buffers inspected 210 0.02 0.00
enqueue conversions 4,447 0.41 0.02
enqueue deadlocks 0 0.00 0.00
enqueue releases 692,466 64.07 2.74
enqueue requests 696,089 64.41 2.76
enqueue timeouts 3,615 0.33 0.01
enqueue waits 4,787 0.44 0.02
exchange deadlocks 3 0.00 0.00
execute count 1,568,709 145.15 6.21
failed probes on index block reclamation 0 0.00 0.00
file io service time 0 0.00 0.00
file io wait time 449,191,181 41,561.48 1,779.43
free buffer inspected 60,779 5.62 0.24
free buffer requested 1,900,550 175.85 7.53
gc blocks compressed 79,840 7.39 0.32
gc cr block flush time 92,451 8.55 0.37
gc cr block receive time 132,920 12.30 0.53
gc cr blocks received 968,657 89.63 3.84
gc cr blocks served 949,161 87.82 3.76
gc current block flush time 591,795,987 54,756.01 2,344.35
gc current block pin time 2,718,777,670 251,555.32 10,770.21
gc current block receive time 30,776 2.85 0.12
gc current blocks received 369,857 34.22 1.47
gc current blocks served 426,631 39.47 1.69
gc kbytes saved 249,902 23.12 0.99
gc kbytes sent 10,756,434 995.24 42.61
gc local grants 151,532 14.02 0.60
gc read wait time 2 0.00 0.00
gc read wait timeouts 0 0.00 0.00
gc read waits 129 0.01 0.00
gc remote grants 270,209 25.00 1.07
gcs messages sent 3,141,770 290.69 12.45
ges messages sent 43,584 4.03 0.17
global enqueue CPU used by this session 0 0.00 0.00
global enqueue get time 1,763 0.16 0.01
global enqueue gets async 6,130 0.57 0.02
global enqueue gets sync 421,833 39.03 1.67
global enqueue releases 412,187 38.14 1.63
global undo segment hints helped 0 0.00 0.00
heap block compress 4,484 0.41 0.02
hot buffers moved to head of LRU 286 0.03 0.00
immediate (CR) block cleanout applications 20,922 1.94 0.08
immediate (CURRENT) block cleanout applications 7,693 0.71 0.03
in call idle wait time 41,190,340 3,811.14 163.17
index crx upgrade (positioned) 2,788 0.26 0.01
index crx upgrade (prefetch) 0 0.00 0.00
index fast full scans (full) 669 0.06 0.00
index fetch by key 1,354,167 125.29 5.36
index scans kdiixs1 1,002,325 92.74 3.97
leaf node 90-10 splits 147 0.01 0.00
leaf node splits 267 0.02 0.00
lob reads 665 0.06 0.00
lob writes 8,134 0.75 0.03
lob writes unaligned 6,625 0.61 0.03
logical read bytes from cache 1,952,936,706,048 180,695,765.65 7,736,394.34
logons cumulative 7,091 0.66 0.03
max cf enq hold time 0 0.00 0.00
messages received 333,552 30.86 1.32
messages sent 333,552 30.86 1.32
min active SCN optimization applied on CR 1 0.00 0.00
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 227,399,706 21,040.19 900.82
non-idle wait count 8,473,321 784.00 33.57
non-idle wait time 951,533 88.04 3.77
opened cursors cumulative 1,337,468 123.75 5.30
parse count (describe) 0 0.00 0.00
parse count (failures) 0 0.00 0.00
parse count (hard) 248 0.02 0.00
parse count (total) 104,468 9.67 0.41
parse time cpu 4,534 0.42 0.02
parse time elapsed 5,263 0.49 0.02
physical read IO requests 5,200 0.48 0.02
physical read bytes 42,598,400 3,941.42 168.75
physical read total IO requests 33,843 3.13 0.13
physical read total bytes 511,477,760 47,324.56 2,026.18
physical read total multi block requests 0 0.00 0.00
physical reads 5,200 0.48 0.02
physical reads cache 613 0.06 0.00
physical reads cache prefetch 0 0.00 0.00
physical reads direct 4,580 0.42 0.02
physical reads direct (lob) 1,963 0.18 0.01
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 37,700 3.49 0.15
physical write bytes 2,189,778,944 202,609.63 8,674.62
physical write total IO requests 635,672 58.82 2.52
physical write total bytes 4,058,555,392 375,518.45 16,077.63
physical write total multi block requests 15,235 1.41 0.06
physical writes 267,307 24.73 1.06
physical writes direct 2,658 0.25 0.01
physical writes direct (lob) 2,596 0.24 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 264,649 24.49 1.05
physical writes non checkpoint 154,256 14.27 0.61
pinned buffers inspected 69 0.01 0.00
pinned cursors current 2 0.00 0.00
prefetch clients - default 104 0.01 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 947 0.09 0.00
process last non-idle time 10,805 1.00 0.04
queries parallelized 36 0.00 0.00
recovery blocks read 7 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 1,514,558 140.13 6.00
recursive cpu usage 8,645 0.80 0.03
redo blocks checksummed by FG (exclusive) 77,509 7.17 0.31
redo blocks written 1,669,199 154.44 6.61
redo buffer allocation retries 8 0.00 0.00
redo entries 2,706,352 250.41 10.72
redo log space requests 3 0.00 0.00
redo log space wait time 21 0.00 0.00
redo ordering marks 245,649 22.73 0.97
redo size 768,657,016 71,120.11 3,044.97
redo size for direct writes 153,152 14.17 0.61
redo subscn max counts 111,193 10.29 0.44
redo synch long waits 307 0.03 0.00
redo synch poll writes 0 0.00 0.00
redo synch polls 0 0.00 0.00
redo synch time 307,802 28.48 1.22
redo synch time (usec) 3,078,041,649 284,796.27 12,193.40
redo synch writes 265,527 24.57 1.05
redo wastage 52,313,496 4,840.31 207.24
redo write broadcast ack count 341 0.03 0.00
redo write broadcast ack time 171,246,813,039 15,844,637.41 678,379.83
redo write broadcast lgwr post count 0 0.00 0.00
redo write time 309,064 28.60 1.22
redo writes 293,264 27.13 1.16
remote Oradebug requests 0 0.00 0.00
rollback changes - undo records applied 377,889 34.96 1.50
rollbacks only - consistent read gets 585 0.05 0.00
root node splits 0 0.00 0.00
rows fetched via callback 1,068,766 98.89 4.23
scheduler wait time 0 0.00 0.00
session connect time 0 0.00 0.00
session cursor cache hits 1,167,520 108.02 4.63
session logical reads 238,404,091 22,058.37 944.42
shared hash latch upgrades - no wait 47,085 4.36 0.19
shared hash latch upgrades - wait 244 0.02 0.00
sorts (memory) 1,538,546 142.35 6.09
sorts (rows) 10,413,549 963.52 41.25
sql area evicted 62 0.01 0.00
sql area purged 0 0.00 0.00
summed dirty queue length 420 0.04 0.00
switch current to new buffer 290,221 26.85 1.15
table fetch by rowid 6,990,079 646.76 27.69
table fetch continued row 5,721 0.53 0.02
table scan blocks gotten 220,058,760 20,360.97 871.74
table scan rows gotten 14,238,382,142 1,317,408.47 56,404.15
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 294,989 27.29 1.17
temp space allocated (bytes) 0 0.00 0.00
total cf enq hold time 17,080 1.58 0.07
total number of cf enq holders 322 0.03 0.00
total number of times SMON posted 83 0.01 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 231,898 21.46 0.92
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 255,705,556 23,659.20 1,012.96
user I/O wait time 5,236 0.48 0.02
user calls 4,545,399 420.56 18.01
user commits 20,341 1.88 0.08
user rollbacks 232,094 21.47 0.92
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 1,407,417 130.22 5.58
write clones created in background 3 0.00 0.00
write clones created in foreground 32 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session pga memory max 9,846,539,376 9,916,006,672
session cursor cache count 15,961,402 16,051,082
session uga memory 15,968,418,954,656 16,084,749,823,952
opened cursors current 676 709
logons current 375 389
session uga memory max 697,963,080,080 701,207,338,112
session pga memory 7,677,013,200 7,746,839,600

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 0.33

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms)
DBWR 0M 0.00 0M 2G 3.25 .191342 7 0.00
LGWR 0M 0.00 0M 1.6G 54.43 .151001 293.3K 10.02
Others 467M 2.89 .043209 173M 1.14 .016006 36.1K 3.28
Direct Reads 16M 0.18 .001480 0M 0.00 0M 0  
Buffer Cache Reads 5M 0.06 .000462 0M 0.00 0M 619 7.78
Direct Writes 0M 0.00 0M 0M 0.00 0M 0  
TOTAL: 488M 3.13 .045152 3.8G 58.82 .358349 330K 9.28

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Small Read Large Read
Data File 40M 0.48 .003701 2G 3.49 .193099 3.22  
Log File 0M 0.00 0M 1.6G 54.43 .150908 3.50  
Control File 446M 2.65 .041266 152M 0.90 .014063 1.12  
TOTAL: 486M 3.13 .044967 3.8G 58.82 .358072 1.44  

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms)
DBWR 0M 0.00 0M 2G 3.25 .191342 7 0.00
DBWR (Data File) 0M 0.00 0M 2G 3.25 .191342 7 0.00
LGWR 0M 0.00 0M 1.6G 54.43 .150908 21 2.86
LGWR (Log File) 0M 0.00 0M 1.6G 54.43 .150908 8 5.25
LGWR (Control File) 0M 0.00 0M 0M 0.00 0M 13 1.38
Others 466M 2.89 .043116 173M 1.14 .016006 31.2K 1.37
Others (Control File) 446M 2.64 .041266 152M 0.90 .014063 28.6K 1.12
Others (Data File) 20M 0.24 .001850 21M 0.24 .001943 2617 4.08
Direct Reads 16M 0.18 .001480 0M 0.00 0M 0  
Direct Reads (Data File) 16M 0.18 .001480 0M 0.00 0M 0  
Buffer Cache Reads 5M 0.06 .000462 0M 0.00 0M 620 7.77
Buffer Cache Reads (Data File) 5M 0.06 .000462 0M 0.00 0M 620 7.77
Direct Writes 0M 0.00 0M 0M 0.00 0M 0  
Direct Writes (Data File) 0M 0.00 0M 0M 0.00 0M 0  
TOTAL: 487M 3.13 .045059 3.8G 58.82 .358257 31.8K 1.49

Back to IO Stats
Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
UNDOTBS2 1 0 0.00 1.00 18,474 2 181 0.00
SDPCMS_DATA 5,079 0 3.11 1.00 7,020 1 590 0.37
SDPCMS_IDX 6 0 8.33 1.00 2,527 0 32 0.31
AAA_DATA 9 0 0.00 1.00 1,703 0 680 2.84
SYSAUX 54 0 1.85 1.00 1,348 0 0 0.00
SDPSMEMD_DATA 1 0 0.00 1.00 1,295 0 79 0.13
SDPMISS_IDX 1 0 0.00 1.00 965 0 0 0.00
SDP_PORTAL_DATA 2 0 5.00 1.00 919 0 3 0.00
SYSTEM 26 0 4.23 1.00 598 0 22 0.45
SDP_PORTAL_IDX 2 0 0.00 1.00 572 0 0 0.00
SDPSMEMD_IDX 1 0 0.00 1.00 567 0 55 0.18
TIANWEIM_DATA 4 0 12.50 1.00 478 0 10 3.00
SDPUSM_DATA 2 0 5.00 1.00 353 0 0 0.00
TIANWEIM_IDX 2 0 10.00 1.00 315 0 24 0.83
SDPMISS_DATA 1 0 0.00 1.00 241 0 0 0.00
AAA_IDX 2 0 0.00 1.00 157 0 0 0.00
SDPUSM_IDX 1 0 0.00 1.00 153 0 0 0.00
UNDOTBS1 1 0 0.00 1.00 1 0 0 0.00
USERS 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
AAA_DATA +DATA/rac/datafile/aaa_data.273.842457671 9 0 0.00 1.00 1,703 0 680 2.84
AAA_IDX +DATA/rac/datafile/aaa_idx.275.842457685 2 0 0.00 1.00 157 0 0 0.00
SDPCMS_DATA +DATA/rac/datafile/sdpcms_data.272.842457483 2,739 0 2.34 1.00 3,636 0 404 0.50
SDPCMS_DATA +DATA/rac/datafile/sdpcms_data.276.844429637 1,231 0 4.96 1.00 2,005 0 136 0.15
SDPCMS_DATA +DATA/rac/datafile/sdpcms_data.277.844429931 1,109 0 2.98 1.00 1,379 0 50 0.00
SDPCMS_IDX +DATA/rac/datafile/sdpcms_idx.279.845464603 6 0 8.33 1.00 2,527 0 32 0.31
SDPMISS_DATA +DATA/rac/datafile/sdpmiss_data.274.842457679 1 0 0.00 1.00 241 0 0 0.00
SDPMISS_IDX +DATA/rac/datafile/sdpmiss_idx.280.845465187 1 0 0.00 1.00 965 0 0 0.00
SDPSMEMD_DATA +DATA/rac/datafile/sdpsmemd_data.268.842457455 1 0 0.00 1.00 1,295 0 79 0.13
SDPSMEMD_IDX +DATA/rac/datafile/sdpsmemd_idx.281.845465815 1 0 0.00 1.00 567 0 55 0.18
SDPUSM_DATA +DATA/rac/datafile/sdpusm_data.270.842457469 2 0 5.00 1.00 353 0 0 0.00
SDPUSM_IDX +DATA/rac/datafile/sdpusm_idx.282.845466065 1 0 0.00 1.00 153 0 0 0.00
SDP_PORTAL_DATA +DATA/rac/datafile/sdp_portal_data.271.842457473 2 0 5.00 1.00 919 0 3 0.00
SDP_PORTAL_IDX +DATA/rac/datafile/sdp_portal_idx.278.845464277 2 0 0.00 1.00 572 0 0 0.00
SYSAUX +DATA/rac/datafile/sysaux.260.842371169 54 0 1.85 1.00 1,348 0 0 0.00
SYSTEM +DATA/rac/datafile/system.259.842371157 26 0 4.23 1.00 598 0 22 0.45
TIANWEIM_DATA +DATA/rac/datafile/tianweim_data.269.842457463 4 0 12.50 1.00 478 0 10 3.00
TIANWEIM_IDX +DATA/rac/datafile/tianweim_idx.283.845466255 2 0 10.00 1.00 315 0 24 0.83
UNDOTBS1 +DATA/rac/datafile/undotbs1.261.842371179 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +DATA/rac/datafile/undotbs2.263.842371195 1 0 0.00 1.00 18,474 2 181 0.00
USERS +DATA/rac/datafile/users.264.842371199 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 993,877 100 238,391,837 611 264,649 0 0 1,677

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR Writes Log Size Writes Log Ckpt Writes Other Settings Writes Autotune Ckpt Writes Thread Ckpt Writes
0 0 0 0 256,846 0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

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 3 3843 15746 346155 829440 346155     1
E 0 10 10755 102454 342815 829440 342815     4

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

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 832 0.10 98 8.04 31,619 1 80645.00
D 1,664 0.20 197 3.19 12,536 1 29130.00
D 2,496 0.30 295 1.96 7,704 1 16085.00
D 3,328 0.40 393 1.50 5,895 1 11200.00
D 4,160 0.49 491 1.32 5,202 1 9330.00
D 4,992 0.59 590 1.22 4,814 1 8281.00
D 5,824 0.69 688 1.16 4,548 1 7565.00
D 6,656 0.79 786 1.10 4,316 1 6939.00
D 7,488 0.89 884 1.04 4,105 1 6368.00
D 8,320 0.99 983 1.00 3,950 1 5950.00
D 8,416 1.00 994 1.00 3,933 1 5905.00
D 9,152 1.09 1,081 0.97 3,806 1 5563.00
D 9,984 1.19 1,179 0.91 3,563 1 4905.00
D 10,816 1.29 1,277 0.84 3,316 1 4239.00
D 11,648 1.38 1,376 0.80 3,130 1 3736.00
D 12,480 1.48 1,474 0.76 2,992 1 3363.00
D 13,312 1.58 1,572 0.74 2,911 1 3146.00
D 14,144 1.68 1,670 0.73 2,873 1 3042.00
D 14,976 1.78 1,769 0.73 2,859 1 3004.00
D 15,808 1.88 1,867 0.72 2,815 1 2888.00
D 16,640 1.98 1,965 0.66 2,614 1 2343.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 16,278 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 4,096 3,132 904.63 0.00 0.00 0.00 0.00 419,430
E 4,096 3,116 922.91 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 1,399,477 1,399,477 0 0
64K 128K 36 36 0 0
128K 256K 6 6 0 0
256K 512K 4 4 0 0
512K 1024K 723 723 0 0
1M 2M 6,495 6,495 0 0
2M 4M 573 573 0 0
4M 8M 6 6 0 0
8M 16M 94 94 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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
512 0.13 7,331,362.98 440,829.63 94.00 25,619 26,754,233,431
1,024 0.25 7,331,362.98 3.97 100.00 0 25,236,778,444
2,048 0.50 7,331,362.98 3.97 100.00 0 25,236,778,444
3,072 0.75 7,331,362.98 3.97 100.00 0 25,236,778,444
4,096 1.00 7,331,362.98 3.97 100.00 0 25,236,778,444
4,915 1.20 7,331,362.98 0.00 100.00 0 25,236,764,772
5,734 1.40 7,331,362.98 0.00 100.00 0 25,236,764,772
6,554 1.60 7,331,362.98 0.00 100.00 0 25,236,764,772
7,373 1.80 7,331,362.98 0.00 100.00 0 25,236,764,772
8,192 2.00 7,331,362.98 0.00 100.00 0 25,236,764,772
12,288 3.00 7,331,362.98 0.00 100.00 0 25,236,764,772
16,384 4.00 7,331,362.98 0.00 100.00 0 25,236,764,772
24,576 6.00 7,331,362.98 0.00 100.00 0 25,236,764,772
32,768 8.00 7,331,362.98 0.00 100.00 0 25,236,764,772

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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)
2,144 0.58 250 7,614 4,844,832 0.80 1,252,811 57.20 594,257
2,528 0.69 634 9,443 5,226,643 0.86 871,000 39.77 617,243
2,912 0.79 1,018 11,272 5,581,428 0.92 516,215 23.57 638,519
3,296 0.90 1,401 13,959 5,926,918 0.98 170,725 7.80 659,315
3,360 0.91 1,464 15,776 5,957,828 0.98 139,815 6.38 661,276
3,392 0.92 1,495 16,779 5,973,248 0.98 124,395 5.68 662,258
3,424 0.93 1,526 17,579 5,987,477 0.99 110,166 5.03 663,185
3,456 0.94 1,558 18,245 6,001,692 0.99 95,951 4.38 664,108
3,488 0.95 1,590 18,355 6,015,888 0.99 81,755 3.73 665,034
3,520 0.96 1,622 18,465 6,029,549 0.99 68,094 3.11 665,918
3,552 0.97 1,654 18,575 6,043,133 0.99 54,510 2.49 666,800
3,584 0.97 1,686 18,685 6,056,978 1.00 40,665 1.86 667,694
3,616 0.98 1,718 18,795 6,063,340 1.00 34,303 1.57 667,953
3,648 0.99 1,750 18,905 6,069,494 1.00 28,149 1.29 668,209
3,680 1.00 1,782 19,015 6,075,742 1.00 21,901 1.00 668,469
3,712 1.01 1,814 19,125 6,075,803 1.00 21,840 1.00 668,470
3,744 1.02 1,846 19,235 6,075,818 1.00 21,825 1.00 668,471
3,776 1.03 1,878 19,345 6,075,832 1.00 21,811 1.00 668,472
3,808 1.03 1,910 19,455 6,075,854 1.00 21,789 0.99 668,472
3,840 1.04 1,941 19,680 6,075,885 1.00 21,758 0.99 668,473
3,872 1.05 1,973 20,585 6,075,896 1.00 21,747 0.99 668,474
3,904 1.06 2,005 21,024 6,075,922 1.00 21,721 0.99 668,475
3,936 1.07 2,037 21,304 6,075,953 1.00 21,690 0.99 668,476
3,968 1.08 2,069 21,584 6,075,977 1.00 21,666 0.99 668,476
4,064 1.10 2,165 22,426 6,076,031 1.00 21,612 0.99 668,478
4,448 1.21 2,548 25,296 6,076,254 1.00 21,389 0.98 668,484
4,832 1.31 2,931 31,878 6,076,327 1.00 21,316 0.97 668,489
5,216 1.42 3,315 40,866 6,076,378 1.00 21,265 0.97 668,492
5,600 1.52 3,699 49,854 6,076,437 1.00 21,206 0.97 668,495
5,984 1.63 4,083 58,842 6,076,476 1.00 21,167 0.97 668,497
6,368 1.73 4,467 67,830 6,076,522 1.00 21,121 0.96 668,499
6,752 1.83 4,851 76,818 6,076,559 1.00 21,084 0.96 668,500
7,136 1.94 5,235 85,806 6,076,576 1.00 21,067 0.96 668,502
7,520 2.04 5,619 94,794 6,076,595 1.00 21,048 0.96 668,503

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
3,072 0.25 8,167,245 31,619,518
4,608 0.38 6,936,291 31,619,518
6,144 0.50 6,877,969 7,704,182
7,680 0.63 6,866,990 5,894,464
9,216 0.75 6,863,559 4,813,590
10,752 0.88 6,862,873 4,316,025
12,288 1.00 6,861,501 3,933,314
13,824 1.13 6,860,815 3,562,796
15,360 1.25 6,859,443 3,129,738
16,896 1.38 6,858,756 2,991,679
18,432 1.50 6,858,070 2,911,439
19,968 1.63 6,858,070 2,613,687
21,504 1.75 6,857,384 2,613,687
23,040 1.88 6,857,384 2,613,687
24,576 2.00 6,857,384 2,613,687

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
32 0.50 0 0 0 0
64 1.00 0 0 0 0
96 1.50 0 0 0 0
128 2.00 0 0 0 0
160 2.50 0 0 0 0
192 3.00 0 0 0 0
224 3.50 0 0 0 0
256 4.00 0 0 0 0
288 4.50 0 0 0 0
320 5.00 0 0 0 0
352 5.50 0 0 0 0
384 6.00 0 0 0 0
416 6.50 0 0 0 0
448 7.00 0 0 0 0
480 7.50 0 0 0 0
512 8.00 0 0 0 0
544 8.50 0 0 0 0
576 9.00 0 0 0 0
608 9.50 0 0 0 0
640 10.00 0 0 0 0

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

Class Waits Total Wait Time (s) Avg Time (ms)
data block 1,128 2 2
segment header 367 0 0
undo block 148 0 0
undo header 33 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
CO-KTUCLO Master Slave enq (master slave det) 3,600 0 3,600 3,600 2 0.46
WF-AWR Flush 66 66 0 50 1 28.40
TX-Transaction (row lock contention) 310 310 0 300 1 4.70
TM-DML 278,429 278,426 0 31 0 6.45
HW-Segment High Water Mark 3,037 3,031 6 210 0 0.90
CF-Controlfile Transaction 23,654 23,651 3 321 0 0.53
PS-PX Process Reservation 235 235 0 108 0 0.56
US-Undo Segment 193 193 0 109 0 0.28
TA-Instance Undo 40 40 0 36 0 0.83
JS-Job Scheduler (job run lock - synchronize) 11 11 0 10 0 2.00
TK-Auto Task Serialization (Auto Task Serialization) 12 12 0 10 0 2.00
FB-Format Block 28 28 0 22 0 0.45
TD-KTF map table enqueue (KTF dump entries) 26 26 0 22 0 0.45
RO-Multiple Object Reuse (fast object reuse) 32 32 0 16 0 0.63
JQ-Job Queue 26 24 2 4 0 2.50
CR-Reuse Block Range (block range reuse ckpt) 2,814 2,814 0 3 0 3.33
PI-Remote PX Process Spawn Status 35 35 0 17 0 0.00
TT-Tablespace 991 991 0 9 0 0.00
DR-Distributed Recovery 6 6 0 6 0 0.00
MW-MWIN Schedule 6 6 0 6 0 0.00
AF-Advisor Framework (task serialization) 33 33 0 2 0 0.00
KD-Scheduler Master DBRM (determine DBRM master) 2 1 1 2 0 0.00
TX-Transaction (index contention) 3 3 0 2 0 0.00
KM-Scheduler 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

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
4 253.21 270,151 886 4 22.7/33.4 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

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
14-5月 23:57 21,080 19,493 245 3 23 0/0 0/0/0/0/0/0
14-5月 23:47 212 2,073 849 3 33 0/0 0/0/0/0/0/0
14-5月 23:37 12,193 12,374 248 3 23 0/0 0/0/0/0/0/0
14-5月 23:27 9,101 10,635 855 2 33 0/0 0/0/0/0/0/0
14-5月 23:17 10,175 12,821 254 3 23 0/0 0/0/0/0/0/0
14-5月 23:07 19,556 20,962 858 4 33 0/0 0/0/0/0/0/0
14-5月 22:57 7,957 9,501 257 2 23 0/0 0/0/0/0/0/0
14-5月 22:47 13,024 15,192 864 3 33 0/0 0/0/0/0/0/0
14-5月 22:37 17,948 19,468 263 3 23 0/0 0/0/0/0/0/0
14-5月 22:27 27,602 26,995 868 3 33 0/0 0/0/0/0/0/0
14-5月 22:17 24,161 26,009 267 3 23 0/0 0/0/0/0/0/0
14-5月 22:07 7,942 9,517 874 3 33 0/0 0/0/0/0/0/0
14-5月 21:57 24,671 25,703 272 3 23 0/0 0/0/0/0/0/0
14-5月 21:47 16,087 13,962 877 3 33 0/0 0/0/0/0/0/0
14-5月 21:37 4,557 2,977 275 3 23 0/0 0/0/0/0/0/0
14-5月 21:27 18,910 19,899 881 4 33 0/0 0/0/0/0/0/0
14-5月 21:17 8,534 11,132 279 3 23 0/0 0/0/0/0/0/0
14-5月 21:07 9,496 11,438 886 3 33 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
AQ deq hash table latch 3 0.00   0 0  
ASM Keyed state latch 14,025 0.00   0 0  
ASM allocation 650 0.00   0 0  
ASM db client latch 8,410 0.00   0 0  
ASM map operation freelist 1,772 0.00   0 0  
ASM map operation hash table 2,638,365 0.00 0.00 0 0  
ASM network background latch 4,649 0.00   0 0  
ASM network state latch 822 0.00   0 0  
AWR Alerted Metric Element list 134,286 0.00   0 0  
Change Notification Hash table latch 3,603 0.00   0 0  
Consistent RBA 293,274 0.00   0 0  
DML lock allocation 556,556 0.00   0 0  
Event Group Locks 14,133 0.00   0 0  
FOB s.o list latch 24,215 0.00   0 0  
File State Object Pool Parent Latch 3 0.00   0 0  
I/O Staticstics latch 3 0.00   0 0  
IPC other latch 92 0.00   0 0  
IPC stats buffer allocation latch 21,245 0.00   0 21,281 0.00
In memory undo latch 3 0.00   0 0  
JS Sh mem access 21 0.00   0 0  
JS broadcast add buf latch 2,494 0.00   0 0  
JS broadcast drop buf latch 2,494 0.00   0 0  
JS broadcast load blnc latch 2,167 0.00   0 0  
JS mem alloc latch 75 0.00   0 0  
JS queue access latch 78 0.00   0 0  
JS queue state obj latch 78,800 0.00   0 0  
JS slv state obj latch 128 0.00   0 0  
KFC FX Hash Latch 3 0.00   0 0  
KFC Hash Latch 3 0.00   0 0  
KFCL LE Freelist 3 0.00   0 0  
KFK SGA Libload latch 2,880 0.00   0 0  
KFMD SGA 230 0.00   0 0  
KGNFS-NFS:SHM structure 3 0.00   0 0  
KGNFS-NFS:SVR LIST 3 0.00   0 0  
KJC message pool free list 66,141 0.00 0.00 0 27,648 0.00
KJCT flow control latch 4,193,501 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 3,602 0.00   0 0  
KSXR large replies 4 0.00   0 0  
KTF sga latch 88 0.00   0 3,313 0.00
KWQMN job cache list latch 775 0.00   0 0  
KWQP Prop Status 6 0.00   0 0  
KWQS pqueue ctx latch 6 0.00   0 0  
Locator state objects pool parent latch 3 0.00   0 0  
Lsod array latch 92,037 0.01 0.00 0 0  
MQL Tracking Latch 0     0 216 0.00
Memory Management Latch 3 0.00   0 3,602 0.00
Memory Queue 3 0.00   0 0  
Memory Queue Message Subscriber #1 3 0.00   0 0  
Memory Queue Message Subscriber #2 3 0.00   0 0  
Memory Queue Message Subscriber #3 3 0.00   0 0  
Memory Queue Message Subscriber #4 3 0.00   0 0  
Memory Queue Subscriber 3 0.00   0 0  
MinActiveScn Latch 3,840 0.00   0 0  
Mutex 3 0.00   0 0  
Mutex Stats 3 0.00   0 0  
OS process 28,703 0.00   0 0  
OS process allocation 36,065 0.00 0.00 0 0  
OS process: request allocation 14,025 0.01 0.00 0 0  
PL/SQL warning settings 7,151 0.00   0 0  
PX hash array latch 3 0.00   0 0  
QMT 3 0.00   0 0  
Real-time plan statistics latch 68,580 0.00   0 0  
SGA IO buffer pool latch 42 0.00   0 42 0.00
SGA blob parent 3 0.00   0 0  
SGA bucket locks 3 0.00   0 0  
SGA heap locks 3 0.00   0 0  
SGA pool locks 3 0.00   0 0  
SQL memory manager latch 3 0.00   0 3,572 0.00
SQL memory manager workarea list latch 425,678 0.00   0 0  
Shared B-Tree 394 0.00   0 0  
Streams Generic 3 0.00   0 0  
Testing 3 0.00   0 0  
Token Manager 3 0.00   0 0  
WCR: sync 3 0.00   0 0  
Write State Object Pool Parent Latch 3 0.00   0 0  
X$KSFQP 3 0.00   0 0  
XDB NFS Security Latch 3 0.00   0 0  
XDB unused session pool 3 0.00   0 0  
XDB used session pool 3 0.00   0 0  
active checkpoint queue latch 44,260 0.03 0.00 0 0  
active service list 86,985 0.00 0.00 0 150,576 0.00
begin backup scn array 2,600 0.00   0 0  
buffer pool 3 0.00   0 0  
business card 75 0.00   0 0  
cache buffer handles 256 0.00   0 0  
cache buffers chains 490,824,945 0.01 0.01 0 77,433,995 0.00
cache buffers lru chain 1,571,446 0.00 0.00 0 79,836,982 0.00
call allocation 28,624 0.02 0.57 0 0  
cas latch 3 0.00   0 0  
change notification client cache latch 3 0.00   0 0  
channel handle pool latch 14,073 0.00   0 0  
channel operations parent latch 2,059,036 0.00 0.00 0 0  
checkpoint queue latch 3,918,115 0.00 0.00 0 433,429 0.00
client/application info 48,715 0.00   0 0  
compile environment latch 7,110 0.00   0 0  
corrupted undo seg latch 1,365,565 0.00   0 0  
cp cmon/server latch 3 0.00   0 0  
cp pool latch 3 0.00   0 0  
cp server hash latch 3 0.00   0 0  
cp sga latch 172 0.00   0 0  
cvmap freelist lock 3 0.00   0 0  
deferred cleanup latch 172 0.00   0 0  
dml lock allocation 172 0.00   0 0  
done queue latch 3 0.00   0 0  
dummy allocation 14,208 0.00   0 0  
enqueue freelist latch 3 0.00   0 283,107 0.00
enqueue hash chains 1,982,581 0.00 0.00 0 6 0.00
error message lists 144 0.00   0 0  
fifth spare latch 3 0.00   0 0  
file cache latch 2,562 0.00   0 0  
flashback copy 3 0.00   0 0  
fourth Audit Vault latch 3 0.00   0 0  
gc element 6,637,436 0.04 0.01 0 846,346 0.00
gc persistent rm 5 0.00   0 0  
gcr global ctx 123 0.00   0 0  
gcs commit scn state 3 0.00   0 0  
gcs opaque info freelist 931,898 0.01 0.00 0 0  
gcs partitioned table hash 32,047,551 0.03 0.00 0 735,020 0.01
gcs pcm hashed value bucket hash 3 0.00   0 0  
gcs remaster request queue 487 0.00   0 0  
gcs remastering latch 1,748,126 6.34 0.00 0 2 0.00
gcs resource freelist 15,763 0.00   0 13,993 0.00
gcs resource hash 22,498,447 0.03 0.00 0 8,015 0.06
gcs resource scan list 18,814 0.00   0 0  
gcs shadows freelist 141,285 0.00   0 144,402 0.00
ges caches resource lists 106,244 0.02 0.11 0 151,308 0.00
ges deadlock list 1,168 0.00   0 3 0.00
ges domain table 824,655 0.00   0 0  
ges enqueue table freelist 846,447 0.00 0.00 0 0  
ges group table 822,179 0.00 0.00 0 0  
ges process hash list 73,620 0.00   0 0  
ges process parent latch 1,749,994 0.00 0.00 0 0  
ges process table freelist 14,025 0.00   0 0  
ges resource hash list 1,477,618 0.06 0.01 0 6,793 0.04
ges resource scan list 443 0.00   0 0  
ges resource table freelist 12,147 0.00   0 0  
ges timeout list 2,264 0.00   0 278 0.00
ges value block free list 58 0.00   0 0  
global KZLD latch for mem in SGA 6,887 0.00   0 0  
global tx hash mapping 3 0.00   0 0  
granule operation 3 0.00   0 0  
hash table column usage latch 267 0.00   0 12,226 0.00
hash table modification latch 318 0.00   0 0  
heartbeat check 3 0.00   0 3,060 0.00
heartbeat structure management 0     0 2,161 0.00
interrupt manipulation 512 0.00   0 0  
intra txn parallel recovery 3 0.00   0 0  
io pool granule metadata list 3 0.00   0 0  
job workq parent latch 40 0.00   0 37 0.00
job_queue_processes free list latch 82 0.00   0 0  
job_queue_processes parameter latch 2,389 0.00   0 0  
k2q global data latch 7,204 0.00   0 0  
k2q lock allocation 3 0.00   0 0  
kcbtsemkid latch 1 0.00   0 0  
kdlx hb parent latch 3 0.00   0 0  
kgb parent 3 0.00   0 0  
kgnfs mount latch 3 0.00   0 0  
kmcptab latch 3 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 12 0.00   0 0  
ksfv messages 3 0.00   0 0  
ksim group membership cache 885,288 0.00 0.00 0 0  
ksim membership request latch 0     0 4,833 0.00
kss move lock 107 0.00   0 0  
ksuosstats global area 1,089 0.00   0 0  
ksv allocation latch 380 0.00   0 0  
ksv class latch 23,459 0.00   0 0  
ksv msg queue latch 126 0.00   0 123 0.00
ksxp shared latch 14,025 0.00   0 0  
ksxp so latch 14,025 0.01 0.00 0 0  
ksz_so allocation latch 14,025 0.00   0 0  
ktm global data 434 0.00   0 0  
kwqbsn:qsga 382 0.00   0 0  
lgwr LWN SCN 296,727 0.00   0 0  
list of block allocation 14,733 0.01 0.00 0 0  
loader state object freelist 14,328 0.01 0.00 0 0  
lob segment dispenser latch 3 0.00   0 0  
lob segment hash table latch 39 0.00   0 0  
lob segment query latch 3 0.00   0 0  
lock DBA buffer during media recovery 3 0.00   0 0  
logical standby cache 3 0.00   0 0  
logminer context allocation 6 0.00   0 0  
logminer work area 3 0.00   0 0  
longop free list parent 3 0.00   0 0  
mapped buffers lru chain 3 0.00   0 0  
message pool operations parent latch 17,827 0.00   0 0  
messages 1,876,603 0.01 0.00 0 0  
mostly latch-free SCN 300,371 0.29 0.00 0 0  
msg queue latch 3 0.00   0 0  
multiblock read objects 1,200,392 0.00 0.00 0 0  
name-service memory objects 29,036 0.00   0 0  
name-service namespace bucket 954,759 0.00 0.00 0 0  
name-service namespace objects 36 0.00   0 0  
name-service pending queue 11,892 0.00   0 0  
name-service request 108 0.00   0 0  
name-service request queue 121,359 0.00   0 0  
ncodef allocation latch 172 0.00   0 0  
object queue header heap 2,999 0.00   0 2,319 0.00
object queue header operation 4,705,882 0.00 0.01 0 0  
object stats modification 23 0.00   0 0  
parallel query alloc buffer 2,945 0.00   0 0  
parallel query stats 166 0.00   0 0  
parallel txn reco latch 4,134 0.00   0 0  
parameter list 68,605 0.00   0 0  
parameter table management 28,240 0.00 0.00 0 0  
peshm 3 0.00   0 0  
pesom_free_list 3 0.00   0 0  
pesom_hash_node 3 0.00   0 0  
post/wait queue 711,050 0.01 0.00 0 634,083 0.00
process allocation 31,253 0.03 0.89 0 7,020 0.00
process group creation 14,025 0.00   0 0  
process queue 438 0.00   0 0  
process queue reference 6,579 0.00   0 599 0.00
qmn task queue latch 2,283 0.00   0 0  
query server freelists 365 0.00   0 0  
query server process 37 0.00   0 18 0.00
queued dump request 36 0.00   0 0  
queuing load statistics 3 0.00   0 0  
recovery domain hash list 3 0.00   0 0  
redo allocation 887,536 0.01 0.00 0 2,706,192 0.02
redo copy 3 0.00   0 2,706,408 0.01
redo writing 932,178 0.00 0.00 0 0  
resmgr group change latch 891,398 0.00 0.00 0 0  
resmgr:active threads 50,300 0.03 0.81 0 3,611 0.00
resmgr:actses change group 7,094 0.00   0 0  
resmgr:actses change state 26 0.00   0 0  
resmgr:free threads list 14,251 0.01 0.00 0 0  
resmgr:method mem alloc latch 16 0.00   0 0  
resmgr:plan CPU method 3 0.00   0 0  
resmgr:resource group CPU method 23,065 0.03 0.00 0 0  
resmgr:schema config 1,265,633 0.37 0.62 3 120 0.00
resmgr:session queuing 3 0.00   0 0  
rm cas latch 3 0.00   0 0  
row cache objects 2,844,556 0.00 0.00 0 1 0.00
rules engine rule set statistics 300 0.00   0 0  
second Audit Vault latch 3 0.00   0 0  
second spare latch 3 0.00   0 0  
sequence cache 41,911 0.00   0 0  
session allocation 297,503 0.00 0.00 0 283,390 0.00
session idle bit 9,367,118 0.00 0.00 0 0  
session queue latch 3 0.00   0 0  
session state list latch 14,336 0.01 0.00 0 0  
session switching 7,180 0.00   0 0  
session timer 3,601 0.00   0 0  
shared pool 786,297 0.01 0.00 0 0  
shared pool sim alloc 7 0.00   0 0  
shared pool simulator 918 0.00   0 0  
sim partition latch 3 0.00   0 0  
simulator hash latch 14,305,136 0.00 0.00 0 0  
simulator lru latch 3 0.00   0 14,304,873 0.01
sort extent pool 401 0.00   0 0  
space background state object latch 34 0.00   0 0  
space background task latch 13,546 0.50 0.00 0 7,220 0.00
state object free list 6 0.00   0 0  
statistics aggregation 42,000 0.00   0 0  
tablespace key chain 3 0.00   0 0  
temp lob duration state obj allocation 6 0.00   0 0  
test excl. parent l0 3 0.00   0 0  
test excl. parent2 l0 3 0.00   0 0  
third spare latch 3 0.00   0 0  
threshold alerts latch 862 0.00   0 0  
transaction allocation 20,417 0.00 0.00 0 0  
undo global data 1,583,881 0.00 0.00 0 0  
virtual circuit buffers 3 0.00   0 0  
virtual circuit holder 3 0.00   0 0  
virtual circuit queues 3 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets
cache buffers chains 490,824,945 33,843 269 33,578
gcs resource hash 22,498,447 6,901 8 6,895
resmgr:schema config 1,265,633 4,746 2,935 1,812
gc element 6,637,436 2,472 32 2,447
ges resource hash list 1,477,618 887 9 879
object queue header operation 4,705,882 94 1 93
ges caches resource lists 106,244 18 2 16
resmgr:active threads 50,300 16 13 3
process allocation 31,253 9 8 1
call allocation 28,624 7 4 3

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
cache buffers chains kcbgtcr: fast path (cr pin) 0 291 167
cache buffers chains kclbla 0 23 0
cache buffers chains kcbgtcr: fast path 0 11 11
cache buffers chains kcbchg1: clear MS bit 0 10 1
cache buffers chains kcbgtcr: kslbegin excl 0 7 130
cache buffers chains kcl_fairness 0 7 0
cache buffers chains kcbgcur_2 0 5 0
cache buffers chains kcbzibmlt: multi-block read: nowait 0 4 0
cache buffers chains kcbzwb 0 4 4
cache buffers chains kcbgtcr_2 0 2 3
cache buffers chains kclcsr 0 2 1
cache buffers chains kcbget: fast exchange 0 1 1
cache buffers chains kcllkopesc 0 1 0
call allocation ksuxds 0 4 3
gc element kclchkping 0 27 0
gc element kclnfndnewm 0 18 0
gcs resource hash kjbassume 0 4 0
gcs resource hash kjbconvert 0 1 0
gcs resource hash kjbcrcomplete 0 1 0
gcs resource hash kjbcrconvert 0 1 0
gcs resource hash kjbcropen 0 1 0
ges resource hash list kjucvl: lock convert request 0 4 1
ges resource hash list kjakcai: search for resp by resname 0 2 1
ges resource hash list kjrmas1: lookup master node 0 2 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
ges resource table freelist kjchc: clean resource cache 0 2 0
object queue header operation kcbo_link_q 0 1 0
process allocation ksucrp:1 0 8 0
resmgr:active threads kgsksimsetup1 0 14 0
resmgr:schema config kgskgmaxdop1 0 2,723 2,927
resmgr:schema config kgskgasi1 0 200 8
resmgr:schema config kgskmetricupd 0 11 0
resmgr:schema config kgskgcs1 0 1 0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex Type Location Sleeps Wait Time (ms)
Cursor Pin kkslce [KKSCHLPIN2] 44 0
Library Cache kgllkdl1 85 26 0
Library Cache kglhdgn2 106 14 0
Library Cache kgllkc1 57 11 0
Library Cache kgllkal1 80 3 0
Library Cache kglpnal2 91 3 0
Cursor Parent kkscsAddChildNode [KKSPRTLOC34] 2 0
Cursor Parent kkscsPruneChild [KKSPRTLOC35] 2 0
Library Cache kglhdgn1 62 1 0
Cursor Pin kksfbc [KKSCHLFSP2] 1 0
Cursor Pin kksfbc [KKSCHLPIN1] 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 180,391,488 75.67
SDPCMS SDPCMS_DATA T_ASSET   TABLE 30,780,288 12.91
SDPCMS SDPCMS_DATA T_CONTENT_DISTRIBUTE   TABLE 8,187,760 3.43
TIANWEIM TIANWEIM_DATA T_IEPG_ASSET   TABLE 3,664,576 1.54
SDPSMEMD SDPSMEMD_IDX PK_T_PROD_RESOURCE_R   INDEX 1,944,992 0.82

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,310 25.19
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 663 12.75
SDPCMS SDPCMS_DATA T_MESSAGESYNC_HIS   TABLE 501 9.63
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_2430353140_1403 TABLE PARTITION 43 0.83
SDPCMS SDPCMS_DATA SYS_IL0000074248C00002$$   INDEX 3 0.06

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Read Requests %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,310 25.19
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 663 12.75
SDPCMS SDPCMS_DATA T_MESSAGESYNC_HIS   TABLE 501 9.63
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_2430353140_1403 TABLE PARTITION 43 0.83
SDPCMS SDPCMS_DATA SYS_IL0000074248C00002$$   INDEX 3 0.06

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,310 25.19
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 663 12.75
SDPCMS SDPCMS_DATA T_MESSAGESYNC_HIS   TABLE 501 9.63
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_2430353140_1403 TABLE PARTITION 43 0.83
SDPCMS SDPCMS_DATA SYS_IL0000074248C00002$$   INDEX 3 0.06

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Reads %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,302 28.43
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 661 14.43

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,741 0.65
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 1,405 0.53
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 1,395 0.52
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 1,178 0.44
SDPCMS SDPCMS_DATA T_MESSAGESYNC_HIS   TABLE 1,096 0.41

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Owner Tablespace Name Object Name Subobject Name Obj. Type Phys Write Requests %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,678 4.45
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 1,405 3.73
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 1,384 3.67
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 1,100 2.92
SDPSMEMD SDPSMEMD_DATA T_PROD_RESOURCE_R   TABLE 1,035 2.75

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Writes %Total
SDPCMS SDPCMS_DATA SYS_LOB0000074245C00002$$   LOB 1,322 49.74
SDPCMS SDPCMS_DATA SYS_LOB0000074248C00002$$   LOB 1,274 47.93
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_2430353140_1403 TABLE PARTITION 41 1.54

Back to Segment Statistics
Back to Top

Segments by Table Scans

Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total
SDP_PORTAL SDP_PORTAL_IDX PK_T_IEPG_ASSET   INDEX 47 7.03
SYS SYSTEM I_OBJ2   INDEX 17 2.54

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

Owner Tablespace Name Object Name Subobject Name Obj. Type DB Block Changes % of Capture
SDPSMEMD SDPSMEMD_IDX PK_T_PROD_RESOURCE_R   INDEX 972,368 38.84
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 797,296 31.85
SDPSMEMD SDPSMEMD_DATA T_PROD_RESOURCE_R   TABLE 503,552 20.11
SYS SYSTEM AUD$   TABLE 111,600 4.46
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 16,480 0.66

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 300 99.01
SDPCMS SDPCMS_DATA SYS_IL0000074248C00002$$   INDEX 2 0.66
SDPMISS SDPMISS_IDX IDX_HISTORY_HISTORY_DATE   INDEX 1 0.33

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 248 89.86
SDPCMS SDPCMS_DATA T_RECORD   TABLE 7 2.54
SYS SYSTEM AUD$   TABLE 6 2.17
SDPSMEMD SDPSMEMD_DATA T_MESSAGESYNC   TABLE 6 2.17
SDPCMS SDPCMS_IDX IDX_MESSAGESHIS_CDATE   INDEX 2 0.72

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

Owner Tablespace Name Object Name Subobject Name Obj. Type GC Buffer Busy % of Capture
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 431 38.07
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 331 29.24
SDPCMS SDPCMS_DATA T_RECORD   TABLE 252 22.26
SDPSMEMD SDPSMEMD_DATA T_MESSAGESYNC   TABLE 66 5.83
SDPCMS SDPCMS_IDX PK_T_MESSAGESYNC   INDEX 25 2.21

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Owner Tablespace Name Object Name Subobject Name Obj. Type CR Blocks Received %Total
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 948,665 97.94
SDPSMEMD SDPSMEMD_DATA T_PROD_RESOURCE_R   TABLE 4,711 0.49
SDPCMS SDPCMS_DATA T_RECORD   TABLE 1,756 0.18
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 1,534 0.16
SDPCMS SDPCMS_DATA T_CONTENT_DISTRIBUTE   TABLE 1,407 0.15

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Owner Tablespace Name Object Name Subobject Name Obj. Type Current Blocks Received %Total
AAA AAA_DATA T_AAA_FAILURE_RECORD   TABLE 343,805 92.96
SYS SYSTEM AUD$   TABLE 6,171 1.67
SDPSMEMD SDPSMEMD_DATA T_PROD_RESOURCE_R   TABLE 2,302 0.62
SDPCMS SDPCMS_DATA T_MESSAGESYNC   TABLE 2,020 0.55
SDPCMS SDPCMS_IDX IDX_MESSAGESYNC_STATUS   INDEX 1,118 0.30

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 192 1.56 0   3 1
dc_global_oids 44 0.00 0   0 296
dc_histogram_data 4,481 12.88 0   0 4,031
dc_histogram_defs 4,610 16.81 0   0 3,297
dc_objects 28,664 0.39 0   3 2,852
dc_profiles 6,918 0.00 0   0 1
dc_rollback_segments 10,418 0.00 0   0 109
dc_segments 3,014 1.03 0   30 1,980
dc_sequences 41 36.59 0   41 14
dc_tablespaces 471,887 0.00 0   0 20
dc_users 523,380 0.00 0   0 213
global database name 16,726 0.00 0   0 2
outstanding_alerts 306 100.00 0   0 0
sch_lj_oids 30 6.67 0   0 12

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache GES Requests GES Conflicts GES Releases
dc_awr_control 9 3 0
dc_histogram_defs 775 1,792 0
dc_objects 39 28 1
dc_segments 91 8 0
dc_sequences 82 16 0
outstanding_alerts 612 306 0
sch_lj_oids 2 0 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
ACCOUNT_STATUS 13,774 0.00 0   0 0
BODY 195 1.03 225 0.89 0 0
CLUSTER 30 3.33 32 3.13 0 0
DBLINK 13,779 0.00 0   0 0
DIRECTORY 2 100.00 3 100.00 0 0
EDITION 6,947 0.00 13,860 0.00 0 0
INDEX 31 6.45 31 6.45 0 0
QUEUE 0   180 0.00 0 0
SCHEMA 6,929 0.00 0   0 0
SQL AREA 104,438 0.05 1,633,420 0.03 153 0
SQL AREA BUILD 220 58.64 0   0 0
SQL AREA STATS 203 71.43 203 71.43 0 0
TABLE/PROCEDURE 20,149 0.05 31,806 0.98 131 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace GES Lock Requests GES Pin Requests GES Pin Releases GES Inval Requests GES Invali- dations
ACCOUNT_STATUS 13,774 0 0 0 0
BODY 0 219 219 0 0
CLUSTER 32 32 32 0 0
DBLINK 13,779 0 0 0 0
DIRECTORY 0 2 2 0 0
EDITION 6,947 6,949 6,949 0 0
INDEX 31 31 31 0 0
QUEUE 0 180 180 0 0
SCHEMA 6,913 0 0 0 0
TABLE/PROCEDURE 12,862 30,406 30,406 0 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

Component Begin Snap Size (Mb) Current Size (Mb) Min Size (Mb) Max Size (Mb) Oper Count Last Op Typ/Mod
ASM Buffer Cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT 16K buffer cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT 2K buffer cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT 32K buffer cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT 4K buffer cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT 8K buffer cache 0.00 0.00 0.00 0.00 0 STA/
DEFAULT buffer cache 8,416.00 8,416.00 8,416.00 10,432.00 0 SHR/DEF
KEEP buffer cache 0.00 0.00 0.00 0.00 0 STA/
PGA Target 4,096.00 4,096.00 4,096.00 4,096.00 0 STA/
RECYCLE buffer cache 0.00 0.00 0.00 0.00 0 STA/
SGA Target 12,288.00 12,288.00 12,288.00 12,288.00 0 STA/
Shared IO Pool 0.00 0.00 0.00 0.00 0 STA/
java pool 32.00 32.00 32.00 32.00 0 STA/
large pool 32.00 32.00 0.00 32.00 0 GRO/IMM
shared pool 3,680.00 3,680.00 1,728.00 3,680.00 0 GRO/DEF
streams pool 64.00 64.00 0.00 64.00 0 GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 745.17   1.98 2.65 27 27 377 377
Freeable 152.69 0.00 1.16 1.59 12   132 132
SQL 5.43 2.15 0.02 0.01 0 11 347 339
PL/SQL 1.42 0.70 0.00 0.02 0 0 375 375
E Other 767.45   1.96 2.61 27 27 391 391
Freeable 148.31 0.00 1.21 1.64 12   123 123
SQL 5.74 2.36 0.02 0.01 0 11 357 347
PL/SQL 1.49 0.74 0.00 0.02 0 0 389 389

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 8,824,815,616  
Fixed Size 2,240,344  
Redo Buffers 7,335,936  
Variable Size 3,992,977,576  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 32.00 32.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 7.81 7.81 0.00
large free memory 23.81 23.81 0.00
shared ASH buffers 48.00 48.00 0.00
shared KGLH0 208.73 210.02 0.62
shared SQLA 1,721.28 1,720.94 -0.02
shared db_block_hash_buckets 89.00 89.00 0.00
shared free memory 613.99 613.68 -0.05
shared gcs resources 273.79 273.79 0.00
shared gcs shadows 159.71 159.71 0.00
streams free memory 63.95 63.95 0.00
  buffer_cache 8,416.00 8,416.00 0.00
  fixed_sga 2.14 2.14 0.00
  log_buffer 7.00 7.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type First Logon CPU time(s) User IO Wait time(s) SYS IO Wait time(s)
QMON Coordinator 0316 16:38:00 0.04 0.00 0.00
QMON Slaves 0316 16:38:10 0.02 0.00 0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total Connections Avg Active Connections Avg Total Shared Srvrs Avg Active Shared Srvrs Avg Total Dispatchers Avg Active Dispatchers
0 0 1 0 1 0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec Disp Queue Per Sec Server Msgs/Sec Server KB/Sec Common Queue Total Disp Queue Total Server Total Msgs Server Total(KB)
0 0 0 0.00 0 0 0 0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s) %Busy %Idle Incoming Net % Outgoing Net %
10,808 0.00 100.00 0.00 0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Name Avg Conns Total Disp Time (s) %Busy %Idle Total Queued Total Queue Wait (s) Avg Queue Wait (ms)
D000 0.00 10,808 0.00 100.00 0 0  
D000 0.00 10,808 0.00 100.00 0 0  
D000 0.00 10,808 0.00 100.00 0 0  
D000 0.00 10,808 0.00 100.00 0 0  
Sum 0.00       0 0  
Avg 0.00   0.00 100.00 0 0  
Std 0.00   0.00 0.00 0 0  

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different)
audit_file_dest /u01/app/oracle/admin/rac/adump   
audit_trail DB   
cluster_database TRUE   
compatible 11.2.0.0.0   
control_files +DATA/rac/controlfile/current.256.842371129, +ARCH/rac/controlfile/current.256.842371129   
db_block_size 8192   
db_create_file_dest +DATA   
db_domain      
db_name rac   
db_recovery_file_dest +ARCH   
db_recovery_file_dest_size 6005194752   
diagnostic_dest /u01/app/oracle   
dispatchers (PROTOCOL=TCP) (SERVICE=racXDB)   
instance_number 2   
local_listener (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.14)(PORT=1521))))   
open_cursors 300   
pga_aggregate_target 4294967296   
processes 1500   
remote_listener scan-cluster.com:1521   
remote_login_passwordfile EXCLUSIVE   
resource_manager_plan    SCHEDULER[0x318B]:DEFAULT_MAINTENANCE_PLAN
service_names rac   
sessions 2280   
sga_target 12884901888   
spfile +DATA/rac/spfilerac.ora   
thread 2   
undo_tablespace UNDOTBS2   

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter Name Begin value End value (if different)
control_files +ARCH/rac/controlfile/current.256.842371129   
+DATA/rac/controlfile/current.256.842371129   

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

Statistic Total per Second per Trans
acks for commit broadcast(actual) 778,810 72.06 3.09
acks for commit broadcast(logical) 798,223 73.86 3.16
broadcast msgs on commit(actual) 284,892 26.36 1.13
broadcast msgs on commit(logical) 293,156 27.12 1.16
broadcast msgs on commit(wasted) 5,524 0.51 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs apply delta 0 0.00 0.00
gcs assume cvt 16 0.00 0.00
gcs assume no cvt 175,716 16.26 0.70
gcs ast xid 0 0.00 0.00
gcs blocked converts 335,593 31.05 1.33
gcs blocked cr converts 850,795 78.72 3.37
gcs compatible basts 60 0.01 0.00
gcs compatible cr basts (global) 104,169 9.64 0.41
gcs compatible cr basts (local) 138,749 12.84 0.55
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 7,961 0.74 0.03
gcs dbwr write request msgs 6,380 0.59 0.03
gcs delta msgs sent 0 0.00 0.00
gcs delta push aborted by cancel 0 0.00 0.00
gcs delta push aborted by remastering 0 0.00 0.00
gcs delta push cancelled 0 0.00 0.00
gcs delta push cancelled at master 0 0.00 0.00
gcs delta push cancelled by close 0 0.00 0.00
gcs delta push cancelled by consign 0 0.00 0.00
gcs delta push cancelled by cvt ping 0 0.00 0.00
gcs delta push cancelled by dwncvt 0 0.00 0.00
gcs delta push create pi 0 0.00 0.00
gcs delta update master msgs sent 0 0.00 0.00
gcs delta wait aborted by remastering 0 0.00 0.00
gcs delta wait cancelled 0 0.00 0.00
gcs error msgs 22 0.00 0.00
gcs force cr block only 48,041 4.45 0.19
gcs force cr grant 31,260 2.89 0.12
gcs force cr no current 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 17,305 1.60 0.07
gcs immediate (null) converts 905 0.08 0.00
gcs immediate cr (compatible) converts 171 0.02 0.00
gcs immediate cr (null) converts 9,641 0.89 0.04
gcs indirect ast 134,636 12.46 0.53
gcs indirect bidless ast 740 0.07 0.00
gcs indirect fg ast 133,896 12.39 0.53
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 2,159 0.20 0.01
gcs msgs process time(ms) 99,522 9.21 0.39
gcs msgs received 3,107,326 287.51 12.31
gcs new served by master 777 0.07 0.00
gcs out-of-order msgs 26 0.00 0.00
gcs pings refused 2,730 0.25 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs push delta 0 0.00 0.00
gcs queued converts 4,870 0.45 0.02
gcs reader bypass N->Xw ping local 0 0.00 0.00
gcs reader bypass N->Xw ping remote 0 0.00 0.00
gcs reader bypass grant X on assume 0 0.00 0.00
gcs reader bypass grant ast 0 0.00 0.00
gcs reader bypass grant fg ast 0 0.00 0.00
gcs reader bypass grant immediate 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 440 0.04 0.00
gcs share recovery bast 0 0.00 0.00
gcs side channel msgs actual 45,302 4.19 0.18
gcs side channel msgs logical 1,491,662 138.02 5.91
gcs stale cr 1,972 0.18 0.01
gcs undo cr 258 0.02 0.00
gcs write notification msgs 500 0.05 0.00
gcs writes refused 5 0.00 0.00
ges msgs process time(ms) 1,022 0.09 0.00
ges msgs received 43,718 4.05 0.17
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 10,469 0.97 0.04
implicit batch messages sent 19,440 1.80 0.08
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 4,434 0.41 0.02
messages queue sent actual 447,761 41.43 1.77
messages queue sent logical 59,287 5.49 0.23
messages received actual 3,034,503 280.77 12.02
messages received logical 3,151,086 291.55 12.48
messages sent directly 1,835,478 169.83 7.27
messages sent indirectly 466,131 43.13 1.85
messages sent not implicit batched 21 0.00 0.00
messages sent pbatched 1,170,800 108.33 4.64
msgs causing lmd to send msgs 10,213 0.94 0.04
msgs causing lms(s) to send msgs 348,387 32.23 1.38
msgs received queue time (ms) 8,883,073 821.91 35.19
msgs received queued 3,151,028 291.55 12.48
msgs sent queue time (ms) 13,759 1.27 0.05
msgs sent queue time on ksxp (ms) 4,044,372 374.21 16.02
msgs sent queued 487,475 45.10 1.93
msgs sent queued on ksxp 3,077,286 284.73 12.19
number of broadcasted resources 0 0.00 0.00
number of ges deadlock detected 0 0.00 0.00
process batch messages received 527,375 48.80 2.09
process batch messages sent 1,102,603 102.02 4.37


Back to Top

Global CR Served Stats

Statistic Total
CR Block Requests 542,126
CURRENT Block Requests 407,643
Data Block Requests 542,491
Undo Block Requests 258
TX Block Requests 1,480
Current Results 928,196
Private results 1
Zero Results 20,191
Disk Read Results 1,972
Fail Results 0
Fairness Down Converts 375,169
Fairness Clears 120,947
Free GC Elements 0
Flushes 134,568
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 399
Errors 0


Back to Top

Global CURRENT Served Stats

Statistic Total % <1ms % <10ms % <100ms % <1s % <10s
Pins 945 99.15 0.74 0.11 0.00 0.00
Flushes 4,467 3.27 63.55 33.18 0.00 0.00
Writes 5,315 0.00 18.44 69.60 3.91 8.05


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

    CR Current
Inst No Block Class Blocks Received % Immed % Busy % Congst Blocks Received % Immed % Busy % Congst
1 data block 564,089 75.39 23.61 1.00 167,410 91.32 7.81 0.87
1 Others 403,141 99.27 0.02 0.71 202,396 98.76 0.58 0.67
1 undo header 940 59.68 40.11 0.21 79 73.42 26.58 0.00
1 undo block 508 97.44 2.36 0.20 0      

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

    CR Avg Time (ms) Current Avg Time (ms)
Inst No Block Class All Immed Busy Congst All Immed Busy Congst
1 data block 2.10 0.39 7.63 0.65 1.46 0.37 14.25 0.59
1 others 0.36 0.36 1.10 0.37 0.34 0.34 0.68 0.35
1 undo header 3.89 0.30 9.25 0.31 3.85 0.36 13.49  
1 undo block 0.57 0.25 13.92 0.27        

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

      CR Current
Src Inst# Block Class Blocks Lost Immed Blks Received % 2hop % 3hop Immed Blks Received % 2hop % 3hop
1 others 0 400,199 100.00 0.00 199,884 100.00 0.00
1 data block 0 425,246 100.00 0.00 152,877 100.00 0.00
1 undo header 0 561 100.00 0.00 58 100.00 0.00
1 undo block 0 495 100.00 0.00 0    

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

      CR Avg Time (ms) Current Avg Time (ms)
Src Inst# Block Class Lost Time Immed 2hop 3hop Immed 2hop 3hop
1 others   0.36 0.36   0.34 0.34  
1 data block   0.39 0.39   0.37 0.37  
1 undo header   0.30 0.30   0.36 0.36  
1 undo block   0.25 0.25        

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance 500B Ping Count Avg Latency 500B msg Stddev 500B msg 8K Ping Count Avg Latency 8K msg Stddev 8K msg
1 856 0.29 0.04 856 0.42 0.11
2 856 0.20 0.03 856 0.19 0.03

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used By Send Mbytes/sec Receive Mbytes/sec
Global Cache 0.97 0.96
Parallel Query 0.00 0.00
DB Locks 0.08 0.08
DB Streams 0.00 0.00
Other 0.01 0.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Device Name IP Address Public Source Send Mbytes/sec Send Errors Send Dropped Send Buffer Overrun Send Carrier Lost Receive Mbytes/sec Receive Errors Receive Dropped Receive Buffer Overrun Receive Frame Errors
bond1:1 169.254.133.80 NO   0.00 0 0 0 0 0.00 0 0 0 0

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

Name Total per Remaster Op Begin Snap End Snap
remaster ops 10 1.00    
remastered objects 10 1.00    
replayed locks received 3,823 382.30    
replayed locks sent 3,704 370.40    
resources cleaned 0 0.00    
remaster time (s) 5.3 0.53    
quiesce time (s) 1.1 0.11    
freeze time (s) 0.4 0.04    
cleanup time (s) 0.6 0.06    
replay time (s) 0.2 0.02    
fixwrite time (s) 1.0 0.10    
sync time (s) 2.0 0.20    
affinity objects     2 2


Back to Top

End of Report