WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC
MCSDB 2372875213 MCSDB1 1 08-2月 -14 20:02 11.2.0.3.0 YES

Host Name Platform CPUs Cores Sockets Memory (GB)
dm01db01.mcsdb.com Linux x86 64-bit 24 12 2 94.47

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 12107 21-4月 -14 02:00:14 1099 8.1
End Snap: 12108 21-4月 -14 03:00:02 1093 8.1
Elapsed:   59.80 (mins)    
DB Time:   25.17 (mins)    

Report Summary

Cache Sizes

Begin End
Buffer Cache: 35,712M 35,712M Std Block Size: 8K
Shared Pool Size: 13,056M 13,056M Log Buffer: 156,956K

Load Profile

Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.4 0.0 0.00 0.00
DB CPU(s): 0.3 0.0 0.00 0.00
Redo size: 1,740,410.9 46,311.2    
Logical reads: 17,887.3 476.0    
Block changes: 6,154.7 163.8    
Physical reads: 2,166.5 57.7    
Physical writes: 238.1 6.3    
User calls: 2,365.3 62.9    
Parses: 69.6 1.9    
Hard parses: 1.0 0.0    
W/A MB processed: 1.8 0.1    
Logons: 2.0 0.1    
Executes: 1,450.8 38.6    
Rollbacks: 24.5 0.7    
Transactions: 37.6      

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.96 In-memory Sort %: 100.00
Library Hit %: 99.80 Soft Parse %: 98.64
Execute to Parse %: 95.20 Latch Hit %: 99.63
Parse CPU to Parse Elapsd %: 54.51 % Non-Parse CPU: 99.10

Shared Pool Statistics

Begin End
Memory Usage %: 84.86 85.21
% SQL with executions>1: 97.86 97.12
% Memory for SQL w/exec>1: 91.14 90.54

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU   1,194   79.09  
cell single block physical read 165,285 203 1 13.47 User I/O
cell multiblock physical read 4,709 55 12 3.66 User I/O
SQL*Net more data from client 61,656 43 1 2.88 Network
log file sync 53,283 29 1 1.94 Commit

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

Load Average Begin Load Average End %User %System %WIO %Idle
0.67 0.42 2.1 0.9 0.0 97.0
Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
1.6 51.6 0.0
Memory Statistics

Begin End
Host Mem (MB): 96,738.8 96,738.8
SGA use (MB): 51,200.0 51,200.0
PGA use (MB): 2,856.3 2,853.5
% Host Mem used for SGA+PGA: 55.88 55.88

RAC Statistics

Begin End
Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction
Global Cache blocks received: 108.92 2.90
Global Cache blocks served: 80.32 2.14
GCS/GES messages received: 364.47 9.70
GCS/GES messages sent: 365.64 9.73
DBWR Fusion writes: 8.28 0.22
Estd Interconnect traffic (KB) 1,656.51  

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

Buffer access - local cache %: 98.27
Buffer access - remote cache %: 0.69
Buffer access - disk %: 1.04

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.3
Avg global cache current block receive time (ms): 0.4
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 %: 1.6
Avg global cache cr block flush time (ms): 0.4
Avg global cache current block pin time (ms): 0.0
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): 0.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 0.5
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 68.10
% of indirect sent messages: 31.33
% of flow controlled messages: 0.58

Cluster Interconnect

  Begin End
Interface IP Address Pub Source IP Pub Src
bondib0 192.168.10.1 N cluster_interconnects parameter      

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 1,194.27 79.09
sql execute elapsed time 1,135.99 75.23
parse time elapsed 33.16 2.20
connection management call elapsed time 28.35 1.88
hard parse elapsed time 12.36 0.82
hard parse (sharing criteria) elapsed time 6.85 0.45
PL/SQL execution elapsed time 4.56 0.30
sequence load elapsed time 0.49 0.03
repeated bind elapsed time 0.09 0.01
failed parse elapsed time 0.03 0.00
PL/SQL compilation elapsed time 0.01 0.00
DB time 1,510.10  
background elapsed time 505.29  
background cpu time 169.16  

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Value End Value
BUSY_TIME 264,027  
IDLE_TIME 8,408,909  
IOWAIT_TIME 659  
NICE_TIME 0  
SYS_TIME 76,217  
USER_TIME 183,886  
LOAD 1 0
RSRC_MGR_CPU_WAIT_TIME 0  
VM_IN_BYTES 0  
VM_OUT_BYTES 0  
PHYSICAL_MEMORY_BYTES 101,438,005,248  
NUM_CPUS 24  
NUM_CPU_CORES 12  
NUM_CPU_SOCKETS 2  
GLOBAL_RECEIVE_SIZE_MAX 4,194,304  
GLOBAL_SEND_SIZE_MAX 2,097,152  
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
21-4月 02:00:14 0.67          
21-4月 03:00:02 0.42 3.04 2.12 0.88 96.96 0.01

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
DB CPU     1,194   79.09
User I/O 254,523 1 296 1 19.63
Network 7,721,809 0 50 0 3.29
Cluster 337,295 0 44 0 2.91
Commit 53,283 0 29 1 1.94
Application 1,596 5 6 4 0.37
Other 26,076 38 5 0 0.33
System I/O 1,373 0 2 1 0.13
Concurrency 9,131 0 1 0 0.07
Administrative 1 100 0 101 0.01
Configuration 96 0 0 1 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
cell single block physical read 165,285 0 203 1 1.23 13.47
cell multiblock physical read 4,709 0 55 12 0.03 3.66
SQL*Net more data from client 61,656 0 43 1 0.46 2.88
log file sync 53,283 0 29 1 0.40 1.94
cell list of blocks physical read 3,390 0 22 6 0.03 1.43
gc current block 2-way 140,954 0 16 0 1.05 1.07
cell smart table scan 6,136 54 12 2 0.05 0.76
gc current grant 2-way 92,084 0 8 0 0.68 0.52
gc cr block 2-way 52,468 0 5 0 0.39 0.34
gc cr multi block request 13,862 0 5 0 0.10 0.34
SQL*Net message to client 7,478,919 0 4 0 55.46 0.24
enq: RO - fast object reuse 633 0 3 5 0.00 0.20
gc current grant busy 16,560 0 3 0 0.12 0.19
SQL*Net more data to client 181,234 0 3 0 1.34 0.17
enq: KO - fast object checkpoint 32 0 2 76 0.00 0.16
reliable message 2,215 0 2 1 0.02 0.15
gc current block busy 2,529 0 2 1 0.02 0.14
control file sequential read 1,365 0 2 1 0.01 0.13
gc buffer busy acquire 542 0 2 3 0.00 0.11
direct path write temp 1,679 0 1 1 0.01 0.09
Disk file operations I/O 71,094 0 1 0 0.53 0.09
local write wait 531 0 1 2 0.00 0.07
gc cr grant 2-way 11,513 0 1 0 0.09 0.07
gc cr block busy 1,878 0 1 1 0.01 0.06
direct path read temp 1,679 0 1 1 0.01 0.06
DFS lock handle 2,649 4 1 0 0.02 0.05
gc current multi block request 2,769 0 1 0 0.02 0.05
enq: FB - contention 2,651 0 0 0 0.02 0.03
row cache lock 4,235 0 0 0 0.03 0.03
PX Deq: Slave Session Stats 1,168 0 0 0 0.01 0.03
rdbms ipc reply 5,066 0 0 0 0.04 0.02
library cache lock 1,552 2 0 0 0.01 0.02
ADR block file read 36 0 0 7 0.00 0.02
library cache pin 2,152 0 0 0 0.02 0.02
enq: CF - contention 9 0 0 19 0.00 0.01
gc current block congested 1,076 0 0 0 0.01 0.01
kksfbc child completion 2 100 0 51 0.00 0.01
JS kgl get object wait 1 100 0 101 0.00 0.01
library cache: mutex X 863 0 0 0 0.01 0.01
gc cr block congested 341 0 0 0 0.00 0.01
enq: PS - contention 425 6 0 0 0.00 0.00
gc current grant congested 573 0 0 0 0.00 0.00
PX Deq: reap credit 8,895 100 0 0 0.07 0.00
log file switch completion 1 0 0 56 0.00 0.00
read by other session 18 0 0 3 0.00 0.00
SQL*Net break/reset to client 812 0 0 0 0.01 0.00
cursor: pin S wait on X 4 0 0 11 0.00 0.00
latch: object queue header operation 103 0 0 0 0.00 0.00
buffer busy waits 215 0 0 0 0.00 0.00
PX Deq: Signal ACK RSG 764 0 0 0 0.01 0.00
enq: HW - contention 94 0 0 0 0.00 0.00
CSS initialization 6 0 0 3 0.00 0.00
enq: TM - contention 118 72 0 0 0.00 0.00
CSS operation: action 6 0 0 2 0.00 0.00
gc buffer busy release 46 0 0 0 0.00 0.00
PX Deq: Signal ACK EXT 764 0 0 0 0.01 0.00
enq: TX - index contention 6 0 0 2 0.00 0.00
gc cr grant congested 86 0 0 0 0.00 0.00
enq: JQ - contention 21 100 0 0 0.00 0.00
enq: TX - row lock contention 1 0 0 5 0.00 0.00
enq: TT - contention 28 0 0 0 0.00 0.00
IPC send completion sync 446 0 0 0 0.00 0.00
control file parallel write 8 0 0 0 0.00 0.00
latch: cache buffers chains 74 0 0 0 0.00 0.00
CSS operation: query 18 0 0 0 0.00 0.00
library cache load lock 4 0 0 0 0.00 0.00
SQL*Net message from client 7,478,919 0 3,036,350 406 55.46  
Streams AQ: waiting for messages in the queue 717 100 3,585 5000 0.01  
jobq slave wait 6,858 100 3,434 501 0.05  
PX Deq: Execution Msg 1,616 0 2 1 0.01  
PX Deq: Execute Reply 800 0 1 1 0.01  
PX Deq: Parse Reply 764 0 0 0 0.01  
PX Deq: Join ACK 764 0 0 0 0.01  
PX Deq Credit: send blkd 48 0 0 0 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
db file parallel write 89,728 0 240 3 0.67 47.48
log file parallel write 70,616 0 41 1 0.52 8.19
log file sequential read 3,058 0 37 12 0.02 7.34
Streams AQ: qmn coordinator waiting for slave to start 3 100 18 5844 0.00 3.47
control file parallel write 2,897 0 14 5 0.02 2.70
control file sequential read 13,893 0 9 1 0.10 1.84
ges lms sync during dynamic remastering and reconfig 135 84 7 51 0.00 1.36
os thread startup 152 0 2 12 0.00 0.35
gcs log flush sync 5,241 0 2 0 0.04 0.33
LGWR wait for redo copy 17,632 0 1 0 0.13 0.16
PX Deq: reap credit 134,424 100 1 0 1.00 0.11
latch free 687 0 1 1 0.01 0.11
ASM file metadata operation 2,594 0 1 0 0.02 0.10
cell single block physical read 256 0 0 1 0.00 0.05
DFS lock handle 1,747 52 0 0 0.01 0.05
CGS wait for IPC msg 34,497 100 0 0 0.26 0.04
CSS operation: data query 165 0 0 1 0.00 0.04
row cache process 48,458 0 0 0 0.36 0.03
row cache lock 727 0 0 0 0.01 0.03
ksxr poll remote instances 22,269 100 0 0 0.17 0.02
libcache interrupt action by LCK 25,727 0 0 0 0.19 0.02
direct path read 11 0 0 8 0.00 0.02
ges LMON to get to FTDONE 4 100 0 21 0.00 0.02
enq: CF - contention 391 95 0 0 0.00 0.02
reliable message 405 0 0 0 0.00 0.01
gc current block 2-way 657 0 0 0 0.00 0.01
gc cr block 2-way 519 0 0 0 0.00 0.01
db file async I/O submit 83,057 0 0 0 0.62 0.01
row cache cleanup 33,971 0 0 0 0.25 0.01
CSS group membership query 55 0 0 1 0.00 0.01
enq: RO - fast object reuse 343 0 0 0 0.00 0.01
asynch descriptor resize 6,604 100 0 0 0.05 0.01
gc object scan 15,347 100 0 0 0.11 0.01
enq: TT - contention 297 97 0 0 0.00 0.01
ges inquiry response 268 0 0 0 0.00 0.01
gc cr block busy 30 0 0 1 0.00 0.01
library cache: mutex X 20 0 0 1 0.00 0.00
SQL*Net message to client 19,386 0 0 0 0.14 0.00
library cache pin 87 0 0 0 0.00 0.00
latch: object queue header operation 37 0 0 0 0.00 0.00
gc current grant 2-way 151 0 0 0 0.00 0.00
gc current grant busy 108 0 0 0 0.00 0.00
ges generic event 1 100 0 11 0.00 0.00
ADR block file read 16 0 0 1 0.00 0.00
library cache lock 48 0 0 0 0.00 0.00
CSS operation: action 10 0 0 1 0.00 0.00
Disk file operations I/O 1,219 0 0 0 0.01 0.00
CSS initialization 2 0 0 3 0.00 0.00
direct path write 13 0 0 0 0.00 0.00
gc cr multi block request 27 0 0 0 0.00 0.00
enq: KO - fast object checkpoint 44 0 0 0 0.00 0.00
gc current block busy 5 0 0 1 0.00 0.00
gc buffer busy acquire 12 0 0 0 0.00 0.00
gc cr grant 2-way 37 0 0 0 0.00 0.00
enq: TD - KTF dump entries 12 0 0 0 0.00 0.00
buffer busy waits 17 0 0 0 0.00 0.00
enq: PS - contention 13 8 0 0 0.00 0.00
enq: TM - contention 11 55 0 0 0.00 0.00
gc current multi block request 9 0 0 0 0.00 0.00
enq: TA - contention 12 0 0 0 0.00 0.00
gc buffer busy release 1 0 0 1 0.00 0.00
enq: WF - contention 9 0 0 0 0.00 0.00
PX Deq: Slave Session Stats 18 0 0 0 0.00 0.00
PX Idle Wait 403 0 348,026 863588 0.00  
rdbms ipc message 249,260 26 92,854 373 1.85  
Space Manager: slave idle wait 6,383 79 27,590 4322 0.05  
class slave wait 1,402 0 18,814 13419 0.01  
wait for unread message on broadcast channel 7,221 89 7,175 994 0.05  
DIAG idle wait 115,866 69 7,138 62 0.86  
gcs remote message 1,266,820 46 7,130 6 9.39  
Streams AQ: qmn slave idle wait 137 2 3,772 27530 0.00  
Streams AQ: waiting for time management or cleanup tasks 135 62 3,766 27895 0.00  
ASM background timer 774 0 3,587 4634 0.01  
smon timer 892 0 3,587 4021 0.01  
ges remote message 71,782 43 3,586 50 0.53  
pmon timer 1,193 100 3,586 3006 0.01  
GCR sleep 717 100 3,586 5001 0.01  
PING 1,118 25 3,581 3203 0.01  
Streams AQ: qmn coordinator idle wait 253 49 3,574 14127 0.00  
SQL*Net message from client 25,831 0 44 2 0.19  
KSV master wait 2,631 83 0 0 0.02  
PX Deq: Join ACK 18 0 0 1 0.00  
PX Deq: Parse Reply 18 0 0 0 0.00  
PX Deq: Execute Reply 18 0 0 0 0.00  
Streams AQ: RAC qmn coordinator idle wait 256 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 52 44.2   9.6 26.9 11.5 7.7    
ADR block file write 10 100.0              
ADR file lock 12 100.0              
ARCH wait for archivelog lock 2 100.0              
ASM file metadata operation 2598 99.6 .1 .0   .2   .0  
CGS wait for IPC msg 34.5K 100.0              
CSS group membership query 55 96.4 3.6            
CSS initialization 8 50.0     50.0        
CSS operation: action 16 50.0 37.5 12.5          
CSS operation: data query 165   100.0            
CSS operation: query 79 100.0              
DFS lock handle 4396 99.9   .1       .0  
Disk file operations I/O 72.6K 100.0 .0            
IPC send completion sync 458 100.0              
JS kgl get object wait 1             100.0  
LGWR wait for redo copy 17.6K 99.5 .5            
Log archive I/O 1 100.0              
PX Deq: Signal ACK EXT 782 100.0              
PX Deq: Signal ACK RSG 782 100.0              
PX Deq: Slave Session Stats 1186 99.8       .1   .1  
PX Deq: reap credit 143.4K 100.0              
PX qref latch 1 100.0              
SQL*Net break/reset to client 812 99.9       .1      
SQL*Net message to client 7494.5K 100.0              
SQL*Net more data from client 61.8K 66.4 24.7 8.8 .0 .0      
SQL*Net more data to client 181.2K 100.0 .0 .0 .0     .0  
Streams AQ: qmn coordinator waiting for slave to start 3               100.0
asynch descriptor resize 7358 100.0              
buffer busy waits 231 100.0              
cell list of blocks physical read 3390 90.6 .6 .6 .5 2.2 2.3 3.2  
cell multiblock physical read 4695 24.6 2.5 10.2 13.8 23.8 22.2 2.8 .0
cell single block physical read 165.8K 92.1 .7 1.1 2.4 2.7 .8 .2  
cell smart table scan 6138 82.4 8.2 2.5 2.5 1.7 1.6 1.1  
control file parallel write 2906 89.0 1.3 .8 .7 1.0 2.4 4.8 .0
control file sequential read 15.3K 98.2 .9 .2 .2 .3 .2 .1  
cursor: mutex X 1 100.0              
cursor: pin S 12 100.0              
cursor: pin S wait on X 4   25.0     50.0 25.0    
db file async I/O submit 83K 100.0              
db file parallel write 89.7K 91.5 1.0 .7 1.0 1.5 1.9 2.4 .0
direct path read 11 63.6   9.1 9.1 9.1   9.1  
direct path read temp 1679 98.7 1.0 .1 .2 .1      
direct path write 15 100.0              
direct path write temp 1679 97.3 .8 .1 .1 .5 .8 .5  
enq: AE - lock 1 100.0              
enq: AF - task serialization 1 100.0              
enq: CF - contention 400 99.0         .3 .8  
enq: CR - block range reuse ckpt 4 100.0              
enq: DL - contention 1 100.0              
enq: DR - contention 2 100.0              
enq: FB - contention 2651 99.9 .1         .0  
enq: HW - contention 106 100.0              
enq: JQ - contention 21 100.0              
enq: KO - fast object checkpoint 76 97.4       1.3     1.3
enq: PD - contention 3 100.0              
enq: PS - contention 438 100.0              
enq: RO - fast object reuse 976 93.0 2.5 .3 .3 .4 1.3 2.0 .1
enq: ST - contention 1 100.0              
enq: TA - contention 12 100.0              
enq: TD - KTF dump entries 12 100.0              
enq: TM - contention 142 100.0              
enq: TO - contention 1 100.0              
enq: TQ - DDL contention 1 100.0              
enq: TQ - TM contention 2 100.0              
enq: TT - contention 325 99.7 .3            
enq: TX - index contention 6 50.0 33.3   16.7        
enq: TX - row lock contention 1       100.0        
enq: WF - contention 9 100.0              
gc buffer busy acquire 554 47.7 25.5 16.4 5.2 2.7 1.1 1.4  
gc buffer busy release 46 97.8 2.2            
gc cr block 2-way 53K 99.9 .1 .0 .0 .0 .0 .0  
gc cr block busy 1904 97.4 1.8 .3 .1 .2 .2    
gc cr block congested 348 99.7           .3  
gc cr disk read 4 100.0              
gc cr grant 2-way 11.6K 99.9 .0 .0 .0   .0 .0  
gc cr grant congested 86 100.0              
gc cr multi block request 13.9K 97.2 2.4 .1 .1 .2 .1 .1  
gc current block 2-way 141.6K 99.9 .1 .0 .0 .0 .0 .0  
gc current block busy 2538 91.0 6.6 1.5 .5 .3 .0 .1  
gc current block congested 1080 99.7   .1 .1   .1    
gc current grant 2-way 92.3K 99.9 .0 .0 .0 .0 .0 .0  
gc current grant busy 16.7K 99.7 .2 .0 .0 .0 .0 .0  
gc current grant congested 574 99.7   .2   .2      
gc current multi block request 2785 98.5 1.3 .1   .0   .1  
gc current retry 7 100.0              
gc current split 3 100.0              
gc object scan 15.3K 100.0              
gcs log flush sync 5247 98.1 1.4 .3 .1 .2      
ges LMON to get to FTDONE 4           100.0    
ges generic event 1         100.0      
ges inquiry response 268 100.0              
ges lms sync during dynamic remastering and reconfig 135 5.9 3.7   .7 10.4 35.6 43.7  
kfk: async disk IO 3 100.0              
kjbdrmcvtq lmon drm quiesce: ping completion 1 100.0              
kksfbc child completion 2             100.0  
ksxr poll remote instances 22.3K 100.0              
latch free 690 91.3     8.6 .1      
latch: cache buffers chains 89 100.0              
latch: cache buffers lru chain 3 100.0              
latch: enqueue hash chains 2 100.0              
latch: gc element 9 100.0              
latch: gcs resource hash 7 100.0              
latch: ges resource hash list 51 100.0              
latch: object queue header operation 140 98.6 1.4            
latch: row cache objects 3 100.0              
latch: shared pool 9 100.0              
libcache interrupt action by LCK 25.8K 100.0              
library cache load lock 4 100.0              
library cache lock 1593 99.9 .1     .1      
library cache pin 2233 100.0 .0            
library cache: mutex X 880 99.0       1.0      
local write wait 531 87.8 7.2 1.5 .2 1.3 .9 1.1  
log file parallel write 70.7K 93.6 3.4 .3 2.4 .1 .1 .1  
log file sequential read 3058 .2 .4 1.3 55.6 26.1 13.4 3.0  
log file single write 2 100.0              
log file switch completion 1             100.0  
log file sync 53.3K 94.9 3.8 .8 .2 .1 .1 .1  
os thread startup 152         98.7 1.3    
rdbms ipc reply 5066 99.9   .1          
read by other session 18 66.7 11.1 11.1   5.6 5.6    
reliable message 2622 99.2 .5   .0 .0 .0 .2  
row cache cleanup 34K 100.0              
row cache lock 4974 100.0 .0            
row cache process 48.6K 100.0              
ASM background timer 775 2.8 1.0     .3 .6 1.7 93.5
DIAG idle wait 115.9K 23.7 2.3 .3 .1 12.8 27.7 33.0  
GCR sleep 718               100.0
KSV master wait 2655 99.8 .1 .0   .0   .0  
PING 1118 74.7             25.3
PX Deq Credit: send blkd 48 100.0              
PX Deq: Execute Reply 818 85.5 1.0 8.1 2.8 1.2   1.5  
PX Deq: Execution Msg 1616 96.8 1.3 .9 .6 .1   .2 .1
PX Deq: Join ACK 782 99.7 .3            
PX Deq: Msg Fragment 48 100.0              
PX Deq: Parse Reply 782 99.4 .4         .3  
PX Idle Wait 404 59.9 8.9 4.7 2.2 1.2 .2 7.9 14.9
SQL*Net message from client 7501.3K 85.8 7.4 1.5 2.6 .5 .4 1.3 .4
Space Manager: slave idle wait 6367   .1 .2 .2 .5 .5 7.8 90.6
Streams AQ: RAC qmn coordinator idle wait 256 100.0              
Streams AQ: qmn coordinator idle wait 253 49.4             50.6
Streams AQ: qmn slave idle wait 137               100.0
Streams AQ: waiting for messages in the queue 718               100.0
Streams AQ: waiting for time management or cleanup tasks 135 35.6           20.7 43.7
class slave wait 1401 35.0 .1 1.5 18.8 1.4 2.2 8.3 32.8
gcs remote message 1267.7K 32.4 5.5 6.2 9.9 45.9 .0 .0  
ges remote message 71.9K 33.9 4.3 2.8 2.9 3.0 3.5 49.5  
jobq slave wait 6864   .0 .0       100.0  
pmon timer 1195               100.0
rdbms ipc message 249.4K 43.0 2.3 2.4 5.8 3.3 4.6 30.7 7.9
smon timer 901   .2 .4 .6 6.3 .9 7.7 83.9
wait for unread message on broadcast channel 7224         .7   99.3  

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 1 100.0     .0        
DFS lock handle 2 100.0   .0          
JS kgl get object wait 1     100.0          
PX Deq: Slave Session Stats 1 99.9       .1      
SQL*Net more data to client 5 100.0 .0 .0          
cell list of blocks physical read 109 96.8 .8 .8 1.0 .6      
cell multiblock physical read 131 97.2 2.1 .4 .1 .0 .1 .0  
cell single block physical read 271 99.8 .1 .0 .0 .0      
cell smart table scan 67 98.9 .8 .2 .1   .0    
control file parallel write 141 95.1 3.1 1.5 .1 .1   .0  
control file sequential read 17 99.9 .1 .0          
db file parallel write 2146 97.6 1.7 .6 .1 .0 .0 .0  
direct path read 1 90.9 9.1            
direct path write temp 8 99.5 .4   .1        
enq: CF - contention 3 99.3 .8            
enq: FB - contention 1 100.0 .0            
enq: RO - fast object reuse 21 97.8 1.2 .6 .2     .1  
gc buffer busy acquire 8 98.6 .5 .9          
gc cr block 2-way 5 100.0 .0            
gc cr block congested 1 99.7 .3            
gc cr grant 2-way 2 100.0 .0            
gc cr multi block request 9 99.9 .1            
gc current block 2-way 15 100.0 .0 .0 .0        
gc current block busy 2 99.9     .1        
gc current grant 2-way 9 100.0 .0 .0 .0        
gc current grant busy 5 100.0 .0 .0          
gc current multi block request 2 99.9 .1            
ges lms sync during dynamic remastering and reconfig 59 56.3 35.6 .7 3.7 3.7      
kksfbc child completion 2   100.0            
local write wait 6 98.9 .8 .2 .2        
log file parallel write 89 99.9 .1 .0          
log file sequential read 92 97.0 1.9 1.0 .0        
log file switch completion 1   100.0            
log file sync 56 99.9 .1 .0          
reliable message 4 99.8 .0     .0 .1    

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

    % of Total Waits
Event Waits 4s to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m
Streams AQ: qmn coordinator waiting for slave to start 3     100.0          
enq: KO - fast object checkpoint 1 98.7 1.3            

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)
MCSDB 1,490 1,178 7,771 63,486
SYS$USERS 20 16 0 573
SYS$BACKGROUND 0 0 2 162

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
MCSDB 253755 296 7369 1 0 0 7718241 50
SYS$USERS 774 0 1762 0 1 0 3868 0
SYS$BACKGROUND 1494 0 26786 2 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
223.12 3,496,720 0.00 14.78 21.90 18.13 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
161.70 18,821 0.01 10.71 70.15 0.00 4wdq8nhtd4ggd pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSKUGTPLU(ORG...
132.56 962 0.14 8.78 12.08 86.32 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
19.02 1 19.02 1.26 99.23 0.00 8yyxd2kvr1m9x pmdtm@MCSAPP3 (TNS V1-V3) UPDATE retail_station_info_dim...
16.60 1 16.60 1.10 94.24 5.61 c15z5v8875zad pmdtm@MCSAPP3 (TNS V1-V3) select FCT_SALE_COMM_MAS.CONTR...
14.87 1 14.87 0.98 76.82 23.12 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...
14.85 14,504 0.00 0.98 50.93 12.01 dd757xnmm2q80 Oil_server@linux-suse-1 (TNS V1-V3) insert into SERVER_INVENTORY_...
12.85 16 0.80 0.85 66.98 0.00 85fbq1b55c07d pmdtm@MCSAPP3 (TNS V1-V3) SELECT TRAFFIC_MONITOR_ID, PLA...
12.22 2 6.11 0.81 64.99 22.36 fn5xaswj0adsb pmdtm@MCSAPP3 (TNS V1-V3) DELETE FROM MCSODS.COMM_ABNORM...
11.65 272,004 0.00 0.77 28.04 1.81 9ffufkbjyyx7r pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_STATION_FACILITY SE...

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
113.43 18,821 0.01 9.50 161.70 70.15 0.00 4wdq8nhtd4ggd pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSKUGTPLU(ORG...
48.87 3,496,720 0.00 4.09 223.12 21.90 18.13 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
18.88 1 18.88 1.58 19.02 99.23 0.00 8yyxd2kvr1m9x pmdtm@MCSAPP3 (TNS V1-V3) UPDATE retail_station_info_dim...
16.01 962 0.02 1.34 132.56 12.08 86.32 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
15.65 1 15.65 1.31 16.60 94.24 5.61 c15z5v8875zad pmdtm@MCSAPP3 (TNS V1-V3) select FCT_SALE_COMM_MAS.CONTR...
11.42 1 11.42 0.96 14.87 76.82 23.12 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...
8.60 16 0.54 0.72 12.85 66.98 0.00 85fbq1b55c07d pmdtm@MCSAPP3 (TNS V1-V3) SELECT TRAFFIC_MONITOR_ID, PLA...
7.94 2 3.97 0.67 12.22 64.99 22.36 fn5xaswj0adsb pmdtm@MCSAPP3 (TNS V1-V3) DELETE FROM MCSODS.COMM_ABNORM...
7.76 119 0.07 0.65 7.81 99.33 0.00 772s25v1y0x8k   select shared_pool_size_for_es...
7.69 119 0.06 0.64 7.76 99.16 0.00 5yv7yvjgjxugg   select TIME_WAITED_MICRO from ...

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
114.43 962 0.12 38.56 132.56 12.08 86.32 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
40.45 3,496,720 0.00 13.63 223.12 21.90 18.13 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
6.63 490 0.01 2.23 7.44 11.62 89.03 3fqtyatabshf1 pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSALSALEPAYYY...
6.04 702 0.01 2.03 8.69 16.37 69.48 c281nr5shzx0n pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSALSALEPLUYY...
5.60 1 5.60 1.89 6.65 14.90 84.17 1jwcd06s7859k pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDCGHEAD.BILLNO,...
4.37 1 4.37 1.47 5.26 13.46 83.05 4jwaywbts2k0c pmdtm@MCSAPP3 (TNS V1-V3) SELECT SAP_KNA1.KUNNR, SAP_KNA...
4.34 70,866 0.00 1.46 9.34 18.98 46.48 0ayu3sfq1r6y1 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_POSITION_OF_FUNCTIO...
3.84 1 3.84 1.30 4.90 21.56 78.49 ct227jp07uztb pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TPRCTSJBODY.BILLNO...
3.82 1 3.82 1.29 4.89 21.15 77.98 1c61db74m6jg8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDYHHEAD.BILLNO,...
3.49 1 3.49 1.18 5.16 29.72 67.71 9nn7skr6fk85q pmdtm@MCSAPP3 (TNS V1-V3) SELECT FYP_FCT_SALE.STORE_ID, ...
3.44 1 3.44 1.16 14.87 76.82 23.12 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...

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
17,609,607 3,496,720 5.04 27.44 223.12 21.9 18.1 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
13,918,701 18,821 739.53 21.69 161.70 70.1 0 4wdq8nhtd4ggd pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSKUGTPLU(ORG...
1,527,300 1 1,527,300.00 2.38 19.02 99.2 0 8yyxd2kvr1m9x pmdtm@MCSAPP3 (TNS V1-V3) UPDATE retail_station_info_dim...
1,135,625 1 1,135,625.00 1.77 16.60 94.2 5.6 c15z5v8875zad pmdtm@MCSAPP3 (TNS V1-V3) select FCT_SALE_COMM_MAS.CONTR...
1,013,767 1 1,013,767.00 1.58 14.87 76.8 23.1 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...
829,673 272,004 3.05 1.29 11.65 28 1.8 9ffufkbjyyx7r pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_STATION_FACILITY SE...
680,606 14,504 46.93 1.06 14.85 50.9 12 dd757xnmm2q80 Oil_server@linux-suse-1 (TNS V1-V3) insert into SERVER_INVENTORY_...
627,421 2 313,710.50 0.98 12.22 65 22.4 fn5xaswj0adsb pmdtm@MCSAPP3 (TNS V1-V3) DELETE FROM MCSODS.COMM_ABNORM...
514,790 8 64,348.75 0.80 5.28 87.8 0 6h5t2wyax3cx0 pmdtm@MCSAPP3 (TNS V1-V3) SELECT ltrim(rtrim(accept_gsmh...
434,895 1 434,895.00 0.68 4.65 40.9 2.5 gb0r7q3w52br8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_SELL_DAY_END.STATIO...

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,135,584 1 1,135,584.00 14.61 16.60 94.24 5.61 c15z5v8875zad pmdtm@MCSAPP3 (TNS V1-V3) select FCT_SALE_COMM_MAS.CONTR...
1,013,298 1 1,013,298.00 13.04 14.87 76.82 23.12 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...
434,874 1 434,874.00 5.59 4.65 40.94 2.51 gb0r7q3w52br8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_SELL_DAY_END.STATIO...
402,897 1 402,897.00 5.18 7.10 27.58 2.73 02yrtn6mqaskx pmdtm@MCSAPP3 (TNS V1-V3) SELECT SAP_VBPA_HIS.MANDT, SAP...
176,633 1 176,633.00 2.27 4.00 30.90 69.19 5mna7rfz1kx6z pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSODS.FCT_STATION_LOSS...
80,452 962 83.63 1.03 132.56 12.08 86.32 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
59,810 1 59,810.00 0.77 6.65 14.90 84.17 1jwcd06s7859k pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDCGHEAD.BILLNO,...
40,509 1 40,509.00 0.52 4.89 21.15 77.98 1c61db74m6jg8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDYHHEAD.BILLNO,...
35,600 1 35,600.00 0.46 4.90 21.56 78.49 ct227jp07uztb pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TPRCTSJBODY.BILLNO...
34,753 3,496,720 0.01 0.45 223.12 21.90 18.13 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...

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
10,018 10,018 1 10,018.00 0.00 15.23 c15z5v8875zad pmdtm@MCSAPP3 (TNS V1-V3) select FCT_SALE_COMM_MAS.CONTR...
9,850 9,867 1 9,867.00 0.17 14.97 1160by9963x0x pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSSTG.NOLB_TSALSALEPAY...
8,893 80,452 962 83.63 88.95 13.52 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
3,706 3,706 1 3,706.00 0.00 5.63 gb0r7q3w52br8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_SELL_DAY_END.STATIO...
3,665 34,753 3,496,720 0.01 89.45 5.57 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
1,598 1,612 1 1,612.00 0.87 2.43 5mna7rfz1kx6z pmdtm@MCSAPP3 (TNS V1-V3) SELECT MCSODS.FCT_STATION_LOSS...
1,265 1,945 1 1,945.00 34.96 1.92 4jwaywbts2k0c pmdtm@MCSAPP3 (TNS V1-V3) SELECT SAP_KNA1.KUNNR, SAP_KNA...
554 739 1 739.00 25.03 0.84 1jwcd06s7859k pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDCGHEAD.BILLNO,...
419 3,917 70,866 0.06 89.30 0.64 0ayu3sfq1r6y1 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_POSITION_OF_FUNCTIO...
401 580 1 580.00 30.86 0.61 1c61db74m6jg8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDYHHEAD.BILLNO,...

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
3,496,720 3,496,720 1.00 223.12 21.9 18.1 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
272,004 272,004 1.00 11.65 28 1.8 9ffufkbjyyx7r pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_STATION_FACILITY SE...
137,167 438,883 3.20 7.77 27.7 0 6ss9jsrba6g2z pmrepagent@MCSAPP3 (TNS V1-V3) SELECT METAEXT_NAME, DATA_TYPE...
137,166 0 0.00 4.24 27.7 0 65n74bvx3vs46 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT OBJECT_TYPE, OBJECT_SUB...
70,866 70,866 1.00 9.34 19 46.5 0ayu3sfq1r6y1 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_POSITION_OF_FUNCTIO...
45,244 45,242 1.00 1.62 35.4 0 a0r18jnk4frap pmrepagent@MCSAPP3 (TNS V1-V3) SELECT WIDGET_NAME, WIDGET_TYP...
29,922 0 0.00 0.90 26.3 0 1mcuj158m6wt7 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SHORTCUT_NAME, REPOSITO...
24,425 24,425 1.00 0.96 30.8 0 8wy6a0y7k22zn pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SUBJECT_ID FROM OPB_WID...
22,622 0 0.00 0.58 27.2 0 2h9drc884789n pmrepagent@MCSAPP3 (TNS V1-V3) SELECT MACRO_ID, MACRO_NAME, M...
22,622 82,651 3.65 1.20 27 .8 5fwkqja3jckh0 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT EXPRESSION, EXPR_ID, LI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
6,478 15,193 2.59 cm5vu20fhtnq1   select /*+ connect_by_filterin...
6,469 6,484 2.59 0k8522rmdzg4k   select privilege# from sysauth...
6,432 6,432 2.58 459f3z9u4fb3u   select value$ from props$ wher...
6,432 6,432 2.58 5ur69atw3vfhj   select decode(failover_method,...
6,425 6,432 2.57 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
6,234 6,238 2.50 6dv0dpznx0dg9 pmrepagent@MCSAPP3 (TNS V1-V3) select VALUE from NLS_SESSION_...
2,682 45,244 1.07 a0r18jnk4frap pmrepagent@MCSAPP3 (TNS V1-V3) SELECT WIDGET_NAME, WIDGET_TYP...
1,807 4,841 0.72 80cqc24ntgmf8 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT DESCRIPTION, PM_VALUE,...
1,677 29,922 0.67 1mcuj158m6wt7 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SHORTCUT_NAME, REPOSITO...
1,639 5,829 0.66 85ja7fnp61tu5 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SESS_WIDG_INST_ID, RESO...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
20,856,113 12 0.15 9juw6s4yy5pzp emagent_SQL_rac_database /* OracleOEM */ SELECT SUM(bro...
20,153,821 12 0.15 6k5agh28pr3wp perl@dm01db01.mcsdb.com (TNS V1-V3) select propagation_name stream...
19,205,858 12 0.14 05xcf43d9psvm emagent_SQL_rac_database SELECT NVL(SUM(FAILURES), 0) F...
18,703,225 12 0.14 a5pyncg7v0bw3 emagent_SQL_rac_database /* OracleOEM */ SELECT PROPAGA...
15,939,529 2 0.12 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
15,591,417 12 0.11 cxjqbfn0d3yqq emagent_SQL_rac_database SELECT COUNT(*) FROM SYS.DBA_P...
14,786,073 12 0.11 b2u9kspucpqwy emagent_SQL_rac_database SELECT COUNT(*) FROM SYS.DBA_P...
14,008,388 4 0.10 88juhgrgf4zqa emagent_SQL_rac_database SELECT DISTINCT :B1 TASK_ID, F...
13,032,458 1 0.10 6wm3n4d7bnddg   SELECT source, (case when tim...
12,985,782 12 0.09 7wt7phk4xns75 emagent_SQL_rac_database select a.capture_name streams_...
8,384,704 61 0.06 4jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
7,748,251 1 0.06 gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
7,504,829 1 0.05 1cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
7,347,859 12 0.05 f0jxh8d6b5af2 emagent_SQL_rac_database /* OracleOEM */ select a.captu...
6,825,864 2 0.05 bjstq78pprd24 pmdtm@MCSAPP3 (TNS V1-V3) SELECT DECODE(ELEMENT_SUBSTITU...
5,028,711 1 0.04 1tnc284g172h5 emagent_SQL_rac_database SELECT /*+ leading(oe f r l) *...
4,904,301 1 0.04 g3ds9bj2t4gtz pmrepagent@MCSAPP3 (TNS V1-V3) SELECT DISTINCT M.MAPPING_ID, ...
4,355,174 17 0.03 4auwu9gtbucrv pmrepagent@MCSAPP3 (TNS V1-V3) SELECT DISTINCT M.MAPPING_ID, ...
3,775,438 122 0.03 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
3,554,277 1 0.03 23buxzfxyp1vy   SELECT greatest(0, 1000*servi...
3,515,043 46 0.03 9vt6njn4h1wf1   SELECT TRIM(B.METRIC_NAME) FRO...
3,508,559 45,244 0.03 a0r18jnk4frap pmrepagent@MCSAPP3 (TNS V1-V3) SELECT WIDGET_NAME, WIDGET_TYP...
3,446,624 2 0.03 bjstq78pprd24 pmdtm@MCSAPP3 (TNS V1-V3) SELECT DECODE(ELEMENT_SUBSTITU...
3,376,958 1 0.02 86w49kdq48gk9   SELECT STATUS#, HOW_CREATED, L...
2,474,027 1 0.02 gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
2,353,430 12 0.02 4tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
2,267,506 1 0.02 5s34t44u10q4g   SELECT a.name task_name, nvl(e...
2,098,698 4 0.02 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
2,016,175 13 0.01 7zmfr1s2uamz5 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_RESERVED_ORDER.MATN...
2,002,514 4 0.01 gtymd9z3asvh1 emagent_SQL_rac_database SELECT :B2 TASK_AVAILABLE, LAT...
1,952,479 1 0.01 1tnc284g172h5 emagent_SQL_rac_database SELECT /*+ leading(oe f r l) *...
1,932,059 11 0.01 gan8rn3g2vcy1 JDBC Thin Client SELECT TRIGGER_STATE FROM QRTZ...
1,916,798 12 0.01 9wncfacx0nj9h   insert into smon_scn_time (thr...
1,813,906 4 0.01 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
1,726,923 14,504 0.01 181xzty42kz4v Oil_server@linux-suse-1 (TNS V1-V3) SELECT UPLOAD_TIME FROM SERVER...
1,685,244 1 0.01 1p36ta7p3d7fu   select file#, block#, ts#, blo...
1,676,353 2 0.01 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
1,659,056 22,114 0.01 cxjzbma42ckb5 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT ATTR_ID, ATTR_VALUE, LI...
1,623,270 182 0.01 5j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
1,522,386 4 0.01 gtymd9z3asvh1 emagent_SQL_rac_database SELECT :B2 TASK_AVAILABLE, LAT...
1,500,602 4 0.01 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
1,294,300 1 0.01 0drvc2yxhdvv7   SELECT COUNT(TARGET_NAME) FROM...
1,203,120 12 0.01 5zp39my20n6zn pmdtm@MCSAPP3 (TNS V1-V3) SELECT RSNUM, RSPOS FROM FCT_R...
1,107,663 24,425 0.01 8wy6a0y7k22zn pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SUBJECT_ID FROM OPB_WID...
1,072,698 3,312 0.01 7jfvtx5a4svff pmrepagent@MCSAPP3 (TNS V1-V3) UPDATE OPB_TASK_INST_RUN SET E...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
100 182 5j0q2df7hm1k2   INSERT INTO MGMT_METRICS_RAW (...
100 1 5s34t44u10q4g   SELECT a.name task_name, nvl(e...
100 1 86w49kdq48gk9   SELECT STATUS#, HOW_CREATED, L...
99 14,504 181xzty42kz4v Oil_server@linux-suse-1 (TNS V1-V3) SELECT UPLOAD_TIME FROM SERVER...
98 1 6wm3n4d7bnddg   SELECT source, (case when tim...
98 13 7zmfr1s2uamz5 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_RESERVED_ORDER.MATN...
98 1 g3ds9bj2t4gtz pmrepagent@MCSAPP3 (TNS V1-V3) SELECT DISTINCT M.MAPPING_ID, ...
97 1 1p36ta7p3d7fu   select file#, block#, ts#, blo...
96 12 05xcf43d9psvm emagent_SQL_rac_database SELECT NVL(SUM(FAILURES), 0) F...
96 1 0drvc2yxhdvv7   SELECT COUNT(TARGET_NAME) FROM...
95 12 cxjqbfn0d3yqq emagent_SQL_rac_database SELECT COUNT(*) FROM SYS.DBA_P...
94 1 23buxzfxyp1vy   SELECT greatest(0, 1000*servi...
94 46 9vt6njn4h1wf1   SELECT TRIM(B.METRIC_NAME) FRO...
94 12 b2u9kspucpqwy emagent_SQL_rac_database SELECT COUNT(*) FROM SYS.DBA_P...
94 4 gtymd9z3asvh1 emagent_SQL_rac_database SELECT :B2 TASK_AVAILABLE, LAT...
94 4 gtymd9z3asvh1 emagent_SQL_rac_database SELECT :B2 TASK_AVAILABLE, LAT...
94 4 gtymd9z3asvh1 emagent_SQL_rac_database SELECT :B2 TASK_AVAILABLE, LAT...
93 436 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
92 12 4tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
89 12 5zp39my20n6zn pmdtm@MCSAPP3 (TNS V1-V3) SELECT RSNUM, RSPOS FROM FCT_R...
89 12 9wncfacx0nj9h   insert into smon_scn_time (thr...
89 11 gan8rn3g2vcy1 JDBC Thin Client SELECT TRIGGER_STATE FROM QRTZ...
87 17 4auwu9gtbucrv pmrepagent@MCSAPP3 (TNS V1-V3) SELECT DISTINCT M.MAPPING_ID, ...
84 22,114 cxjzbma42ckb5 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT ATTR_ID, ATTR_VALUE, LI...
82 12 6k5agh28pr3wp perl@dm01db01.mcsdb.com (TNS V1-V3) select propagation_name stream...
77 24,425 8wy6a0y7k22zn pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SUBJECT_ID FROM OPB_WID...
76 1 gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
76 1 gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
71 4 88juhgrgf4zqa emagent_SQL_rac_database SELECT DISTINCT :B1 TASK_ID, F...
71 4 88juhgrgf4zqa emagent_SQL_rac_database SELECT DISTINCT :B1 TASK_ID, F...
71 12 a5pyncg7v0bw3 emagent_SQL_rac_database /* OracleOEM */ SELECT PROPAGA...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
70 4 a8j39qb13tqkr emagent_SQL_oracle_database SELECT :B1 TASK_ID, F.FINDING_...
64 61 4jrfrtx4u6zcx   SELECT TASK_TGT.TARGET_GUID TA...
64 12 9juw6s4yy5pzp emagent_SQL_rac_database /* OracleOEM */ SELECT SUM(bro...
63 12 7wt7phk4xns75 emagent_SQL_rac_database select a.capture_name streams_...
61 1 1cq3qr774cu45   insert into WRH$_IOSTAT_FILETY...
60 2 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
60 2 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
60 2 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
60 2 cnumpcz520unc   SELECT COUNT(*) FROM ALL_OBJEC...
53 8 6h5t2wyax3cx0 pmdtm@MCSAPP3 (TNS V1-V3) SELECT ltrim(rtrim(accept_gsmh...
53 8 6h5t2wyax3cx0 pmdtm@MCSAPP3 (TNS V1-V3) SELECT ltrim(rtrim(accept_gsmh...
47 1 1tnc284g172h5 emagent_SQL_rac_database SELECT /*+ leading(oe f r l) *...
47 1 1tnc284g172h5 emagent_SQL_rac_database SELECT /*+ leading(oe f r l) *...
41 3,312 7jfvtx5a4svff pmrepagent@MCSAPP3 (TNS V1-V3) UPDATE OPB_TASK_INST_RUN SET E...
41 3,312 7jfvtx5a4svff pmrepagent@MCSAPP3 (TNS V1-V3) UPDATE OPB_TASK_INST_RUN SET E...
35 2 bjstq78pprd24 pmdtm@MCSAPP3 (TNS V1-V3) SELECT DECODE(ELEMENT_SUBSTITU...
35 2 bjstq78pprd24 pmdtm@MCSAPP3 (TNS V1-V3) SELECT DECODE(ELEMENT_SUBSTITU...
35 2 bjstq78pprd24 pmdtm@MCSAPP3 (TNS V1-V3) SELECT DECODE(ELEMENT_SUBSTITU...
33 12 f0jxh8d6b5af2 emagent_SQL_rac_database /* OracleOEM */ select a.captu...
31 20,794 gdxm55c5pr008 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE GPS_YYYYMMDD_TEMP SET A...

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
6.97 962 15.80 132.56 5.26 12.08 86.32 frdxb5s9mwkxn pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO FCT_OILDEPOT_STOCK...
3.41 3,496,720 7.73 223.12 1.53 21.90 18.13 38cbk1ua63x60 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE SAP_VBPA_HIS SET KUNNR ...
2.26 2 5.12 12.22 18.50 64.99 22.36 fn5xaswj0adsb pmdtm@MCSAPP3 (TNS V1-V3) DELETE FROM MCSODS.COMM_ABNORM...
1.93 1 4.36 7.21 26.70 50.82 30.14 asmju60ht2qn0 pmdtm@MCSAPP3 (TNS V1-V3) delete from mcsods.fct_sell_da...
1.37 18,821 3.11 161.70 0.85 70.15 0.00 4wdq8nhtd4ggd pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSKUGTPLU(ORG...
1.30 14,504 2.94 14.85 8.74 50.93 12.01 dd757xnmm2q80 Oil_server@linux-suse-1 (TNS V1-V3) insert into SERVER_INVENTORY_...
1.07 1 2.43 2.17 49.42 59.21 0.00 d1wky1vpysxc9 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_SELL_DAY_END.SELL_D...
0.85 3,312 1.92 1.84 45.95 58.33 0.30 7jfvtx5a4svff pmrepagent@MCSAPP3 (TNS V1-V3) UPDATE OPB_TASK_INST_RUN SET E...
0.68 70,866 1.54 9.34 7.28 18.98 46.48 0ayu3sfq1r6y1 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_POSITION_OF_FUNCTIO...
0.53 1 1.20 5.16 10.27 29.72 67.71 9nn7skr6fk85q pmdtm@MCSAPP3 (TNS V1-V3) SELECT FYP_FCT_SALE.STORE_ID, ...
0.25 1 0.56 6.65 3.73 14.90 84.17 1jwcd06s7859k pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDCGHEAD.BILLNO,...
0.22 272,004 0.51 11.65 1.92 28.04 1.81 9ffufkbjyyx7r pmdtm@MCSAPP3 (TNS V1-V3) UPDATE STA_STATION_FACILITY SE...
0.16 1 0.37 4.89 3.37 21.15 77.98 1c61db74m6jg8 pmdtm@MCSAPP3 (TNS V1-V3) SELECT NOLB_TORDYHHEAD.BILLNO,...
0.13 43 0.29 1.74 7.44 87.91 1.81 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.10 22,114 0.22 1.97 5.01 29.32 5.50 cxjzbma42ckb5 pmrepagent@MCSAPP3 (TNS V1-V3) SELECT ATTR_ID, ATTR_VALUE, LI...
0.08 20,794 0.18 5.17 1.53 34.47 0.02 gdxm55c5pr008 pmdtm@MCSAPP3 (TNS V1-V3) UPDATE GPS_YYYYMMDD_TEMP SET A...
0.08 1 0.18 2.99 2.64 41.34 43.87 c95qnptjy342z pmdtm@MCSAPP3 (TNS V1-V3) select a.matnr, a.werks, a.lgo...
0.07 24,425 0.16 0.96 7.49 30.78 0.00 8wy6a0y7k22zn pmrepagent@MCSAPP3 (TNS V1-V3) SELECT SUBJECT_ID FROM OPB_WID...
0.07 1 0.15 19.02 0.36 99.23 0.00 8yyxd2kvr1m9x pmdtm@MCSAPP3 (TNS V1-V3) UPDATE retail_station_info_dim...
0.05 45,244 0.11 1.62 3.06 35.41 0.00 a0r18jnk4frap pmrepagent@MCSAPP3 (TNS V1-V3) SELECT WIDGET_NAME, WIDGET_TYP...
0.05 1 0.11 5.26 0.93 13.46 83.05 4jwaywbts2k0c pmdtm@MCSAPP3 (TNS V1-V3) SELECT SAP_KNA1.KUNNR, SAP_KNA...
0.05 13 0.11 0.11 46.03 59.44 0.08 7zmfr1s2uamz5 pmdtm@MCSAPP3 (TNS V1-V3) SELECT FCT_RESERVED_ORDER.MATN...
0.04 2 0.08 1.64 2.24 98.17 0.00 d15cdr0zt3vtp Oracle Enterprise Manager.Metric Engine SELECT TO_CHAR(current_timesta...
0.03 22,622 0.07 1.52 2.07 28.95 11.26 f3u6vd210afnt pmrepagent@MCSAPP3 (TNS V1-V3) SELECT FIELD_NAME, FIELD_ID, W...
0.02 8 0.05 5.28 0.38 87.82 0.00 6h5t2wyax3cx0 pmdtm@MCSAPP3 (TNS V1-V3) SELECT ltrim(rtrim(accept_gsmh...
0.02 59 0.04 6.83 0.23 99.02 0.02 2utv9nxmm9n3k pmdtm@MCSAPP3 (TNS V1-V3) delete from fct_traffic_un_ala...
0.01 490 0.02 7.44 0.14 11.62 89.03 3fqtyatabshf1 pmdtm@MCSAPP3 (TNS V1-V3) INSERT INTO NOLB_TSALSALEPAYYY...
0.01 12 0.02 0.04 26.34 76.66 0.00 4tg8mr2bvy6gr   select smontabv.cnt, smontab.t...
0.01 122 0.02 0.06 14.79 84.04 2.47 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
0.01 2,203 0.02 0.29 3.01 31.21 7.62 0h9q31bxn3xjq pmrepagent@MCSAPP3 (TNS V1-V3) SELECT VARIABLE_ID, VAR_NAME, ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
02yrtn6mqaskx SELECT SAP_VBPA_HIS.MANDT, SAP_VBPA_HIS.VBELN, SAP_VBPA_HIS.POSNR, SAP_VBPA_HIS.PARVW, SAP_VBPA_HIS.KUNNR, SAP_VBPA_HIS.LIFNR, SAP_VBPA_HIS.PERNR, SAP_VBPA_HIS.PARNR, SAP_VBPA_HIS.ADRNR, SAP_VBPA_HIS.ABLAD, SAP_VBPA_HIS.LAND1, SAP_VBPA_HIS.ADRDA, SAP_VBPA_HIS.XCPDK, SAP_VBPA_HIS.HITYP, SAP_VBPA_HIS.PRFRE, SAP_VBPA_HIS.BOKRE, SAP_VBPA_HIS.HISTUNR, SAP_VBPA_HIS.KNREF, SAP_VBPA_HIS.LZONE, SAP_VBPA_HIS.HZUOR, SAP_VBPA_HIS.STCEG, SAP_VBPA_HIS.PARVW_FF, SAP_VBPA_HIS.ADRNP, SAP_VBPA_HIS.KALE, SAP_VBPA_HIS.OIPBL, SAP_VBPA_HIS.ETL_TIME FROM SAP_VBPA_HIS WHERE SAP_VBPA_HIS.PARVW = 'RG'
05xcf43d9psvm SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
0ayu3sfq1r6y1 UPDATE STA_POSITION_OF_FUNCTION SET TPLKZ = :1, LGWID = :2, FLTYP = :3, IWERK = :4, TPLMA = :5, EQFNR = :6, SWERK = :7, STORT = :8, BEBER = :9, GSBER = :10, KOSTL = :11, BUKRS = :12, ADRNR = :13, ARBPL = :14, KTEXT = :15, INNAM = :16, IFLOT_IWERK_NAME = :17, ILOA_SWERK_NAME = :18, PLTXT = :19, FING = :20, LTEXT = :21, STSMA = :22, USER_STAT = :23, USER_TXT30 = :24, CLINT = :25, KSCHL = :26, UPDATE_TIME = :27, STREET = :28, CITY1 = :29, TEL_NUMBER = :30, FAX_NUMBER = :31, POST_CODE1 = :32 WHERE MANDT = :33 AND TPLNR = :34 AND ILOAN = :35
0drvc2yxhdvv7 SELECT COUNT(TARGET_NAME) FROM MGMT_TARGETS
0h9q31bxn3xjq SELECT VARIABLE_ID, VAR_NAME, VAR_TYPE, VAR_DESC, VAR_DATATYPE, VAR_DEFAULT, LAST_SAVED, TASK_INST_ID, TASK_INST_NAME, OPB_OBJECT_ID, BIT_OPTIONS FROM OPB_WFLOW_VAR WHERE WORKFLOW_ID = :1 AND SUBJECT_ID = :2 AND VERSION_NUMBER = :3
0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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')
1160by9963x0x SELECT MCSSTG.NOLB_TSALSALEPAYYYYYMM.SERIALNO, MCSSTG.NOLB_TSALSALEPAYYYYYMM.ZFCODE, MCSSTG.NOLB_TSALSALEPAYYYYYMM.PAYSSTOTAL, MCSSTG.NOLB_TSALSALEPAYYYYYMM.ZFTOTAL, MCSSTG.NOLB_TSALSALEPAYYYYYMM.SSTOTAL, MCSODS.FCT_SALE.SALE_ID FROM MCSSTG.NOLB_TSALSALEPAYYYYYMM, MCSODS.FCT_SALE, MCSODS.MAP_STATION WHERE NOLB_TSALSALEPAYYYYYMM.ORGCODE=MAP_STATION.NOLB_CODE AND FCT_SALE.STORE_ID=MAP_STATION.STORE_ID AND FCT_SALE.SALE_BILLNO = NOLB_TSALSALEPAYYYYYMM.SALENO AND FCT_SALE.RPT_DATE IS NOT NULL AND (0=1 or trunc(FCT_SALE.RPT_DATE)=to_DATE('2014-04-20', 'YYYY-MM-DD'))
181xzty42kz4v SELECT UPLOAD_TIME FROM SERVER_INVENTORY_RT WHERE STATION_ID =:B2 AND TANK_ID =:B1
1c61db74m6jg8 SELECT NOLB_TORDYHHEAD.BILLNO, NOLB_TORDYHHEAD.LRDATE, NOLB_TORDYHHEAD.JZDATE, NOLB_TORDYHHEAD.ETPCODE, NOLB_TORDYHHEAD.SDDATE, NOLB_TORDYHHEAD.YHCOUNT, NOLB_TORDYHHEAD.YWSTATUS, NOLB_TORDYHHEAD.DATASTATUS FROM NOLB_TORDYHHEAD WHERE 0=1 or trunc(NOLB_TORDYHHEAD.JZDATE)=to_date('2014-04-20', 'yyyy-mm-dd')
1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_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(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1jwcd06s7859k SELECT NOLB_TORDCGHEAD.BILLNO, NOLB_TORDCGHEAD.RPTDATE, NOLB_TORDCGHEAD.YSORGCODE, NOLB_TORDCGHEAD.YSORGNAME, NOLB_TORDCGHEAD.SUPCODE, NOLB_TORDCGHEAD.CNTID, NOLB_TORDCGHEAD.JYMODE, NOLB_TORDCGHEAD.PSTYPE, NOLB_TORDCGHEAD.CGHCOST, NOLB_TORDCGHEAD.CGWCOST, NOLB_TORDCGHEAD.CGJTAXTOTAL, NOLB_TORDCGHEAD.PSCOST, NOLB_TORDCGHEAD.STOTAL, NOLB_TORDCGHEAD.CJTOTAL, NOLB_TORDCGHEAD.SDCOUNT, NOLB_TORDCGHEAD.XDDATE, NOLB_TORDCGHEAD.ZXDATE, NOLB_TORDCGHEAD.ZDDATE, NOLB_TORDCGHEAD.YXDATE, NOLB_TORDCGHEAD.DHDATE, NOLB_TORDCGHEAD.YWSTATUS, NOLB_TORDCGHEAD.DATASTATUS FROM NOLB_TORDCGHEAD WHERE 0=1 or NOLB_TORDCGHEAD.RPTDATE='2014-04-21'
1mcuj158m6wt7 SELECT SHORTCUT_NAME, REPOSITORY_NAME, REPOSITORY_ID, REFERENCE_TYPE, CREATION_TIME, OPB_SHORTCUT.COMMENTS, PARENT_ID, OBJECT_SUBTYPE, UTC_LAST_SAVED, IS_VISIBLE, VERSION_STATUS, UTC_REF_TIME, CHECKOUT_USER_ID, TEMPLATE_ID FROM OPB_SHORTCUT WHERE OBJECT_ID = :1 AND OBJECT_TYPE = :2 AND SUBJECT_ID = :3 AND VERSION_NUMBER = :4
1p36ta7p3d7fu select file#, block#, ts#, blocks from seg$ where type# = 3
1tnc284g172h5 SELECT /*+ leading(oe f r l) */ /* STN_REPT_TOP_PROF */ xmlelement( "top_profiles", xmlagg(xmlelement("obj_id", object_id))) FROM (SELECT task_id, exec_name, exec_id, exec_start, object_id, sql_id, parsing_schema, phv, obj_attr8 FROM (SELECT /*+ cardinality(o ) leading(e o) */ e.task_id task_id, e.execution_name exec_name, e.execution_id exec_id, e.execution_start exec_start, o.id object_id, o.attr1 sql_id, o.attr3 parsing_schema, to_number(nvl(o.attr5, '0')) phv, nvl(o.attr8, 0) obj_attr8, row_number() over (partition by o.attr1 order by bitand(o.attr7, 32) asc, e.execution_start desc) rn FROM (SELECT e.task_id, e.name execution_name, e.id execution_id, e.exec_start execution_start, e.status status# FROM (SELECT task_id, min(execution_name) keep (dense_rank first order by execution_start) bename, max(execution_name) keep (dense_rank last order by execution_start) eename, min(execution_start) bestart, max(execution_start) eestart FROM ( SELECT task_id, name execution_name, exec_start execution_start FROM wri$_adv_executions WHERE task_id = :tid and name in (:bename, :eename)) GROUP BY task_id) r, wri$_adv_executions e WHERE e.task_id = r.task_id and e.exec_start >= bestart and e.exec_start <= eestart and e.status IN (3, 4) and (bename <> eename OR e.name = bename)) e /* e */, wri$_adv_objects o WHERE o.task_id = e.task_id AND o.exec_name = e.execution_name AND o.type = :sqltyp) WHERE rn = 1) oe /* oe */, wri$_adv_findings f, wri$_adv_recommendations r, wri$_adv_rationale l WHERE oe.task_id = f.task_id AND oe.exec_name = f.exec_name AND oe.object_id = f.obj_id AND f.task_id = r.task_id AND f.exec_name = r.exec_name AND f.id = r.finding_id AND l.task_id = r.task_id AND l.exec_name = r.exec_name AND l.rec_id = r.id AND r.type = :profiletyp AND l.type = :impltyp AND l.attr1 = :acceptdis AND NOT EXISTS (SELECT 1 FROM dba_sql_profiles p WHERE p.task_id = r.task_id AND p.task_exec_name = r.exec_name AND p.task_obj_id = oe.object_id AND p.task_fnd_id = r.finding_id AND p.task_rec_id = r.id)
23buxzfxyp1vy SELECT greatest(0, 1000*servicetime - req*:expio ) as impact FROM ( SELECT sum( case when iostat.snap_id = :eid then iostat.small_read_reqs else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_reqs else 0 end) as req, sum( case when iostat.snap_id = :eid then iostat.small_read_servicetime else 0 end) - sum( case when iostat.snap_id = :bid then iostat.small_read_servicetime else 0 end) as servicetime FROM WRH$_IOSTAT_FILETYPE iostat, WRH$_IOSTAT_FILETYPE_NAME fn WHERE iostat.dbid = fn.dbid AND iostat.filetype_id = fn.filetype_id AND (fn.filetype_name = 'Data File' OR fn.filetype_name = 'Temp File') AND iostat.dbid = :dbid AND iostat.instance_number = :inst AND iostat.snap_id IN (:bid, :eid) )
2h9drc884789n SELECT MACRO_ID, MACRO_NAME, MACRO_TYPE FROM OPB_WIDG_MCR_DEP WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 AND INSTANCE_ID = 0 AND MAPPING_ID = 0
2utv9nxmm9n3k delete from fct_traffic_un_alarm where un_alarm_id in (select un_alarm_id from (select traffic_monitor_id, outdepot_time, arrival_time from fct_traffic_monitor where stime = to_date('20140421', 'yyyymmdd')) a inner join (select un_alarm_id, traffic_monitor_id, un_alarm_time from fct_traffic_un_alarm where trunc(un_alarm_time) = to_date('20140421', 'yyyymmdd') and un_alarm_type = '02') b on a.traffic_monitor_id = b.traffic_monitor_id where a.outdepot_time >= b.un_alarm_time or a.arrival_time <= b.un_alarm_time)
38cbk1ua63x60 UPDATE SAP_VBPA_HIS SET KUNNR = :1, LIFNR = :2, PERNR = :3, PARNR = :4, ADRNR = :5, ABLAD = :6, LAND1 = :7, ADRDA = :8, XCPDK = :9, HITYP = :10, PRFRE = :11, BOKRE = :12, HISTUNR = :13, KNREF = :14, LZONE = :15, HZUOR = :16, STCEG = :17, PARVW_FF = :18, ADRNP = :19, KALE = :20, OIPBL = :21, ETL_TIME = :22 WHERE MANDT = :23 AND VBELN = :24 AND POSNR = :25 AND PARVW = :26
3fqtyatabshf1 INSERT INTO NOLB_TSALSALEPAYYYYYMM(ORGCODE, SALENO, TRANTYPE, SERIALNO, ZFCODE, ZFNAME, ZFNO, PAYSSTOTAL, ZFTOTAL, SSTOTAL, REMARK, JZDATE) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'
4auwu9gtbucrv SELECT DISTINCT M.MAPPING_ID, M.SUBJECT_ID FROM OPB_MAPPING M, OPB_WIDGET_INST I, OPB_VALIDATE V, OPB_WIDGET W WHERE M.IS_VISIBLE = :1 AND M.MAPPING_ID = I.MAPPING_ID AND M.VERSION_NUMBER = I.VERSION_NUMBER AND M.REF_WIDGET_ID = 0 AND M.MAPPING_ID IN (1016) AND I.WIDGET_TYPE = W.WIDGET_TYPE AND I.WIDGET_ID = W.WIDGET_ID AND V.SUBJECT_ID = W.SUBJECT_ID AND V.OBJECT_TYPE = I.WIDGET_TYPE AND V.OBJECT_ID = I.WIDGET_ID AND V.VERSION_NUMBER = W.VERSION_NUMBER AND V.INV_UTC > M.UTC_LAST_SAVED AND M.IS_VALID = 1 AND W.IS_REUSABLE = 1 AND (W.IS_VISIBLE <> 2 OR (W.IS_VISIBLE = 2 AND W.CHECKOUT_USER_ID = :2))
4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), M GMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4jwaywbts2k0c SELECT SAP_KNA1.KUNNR, SAP_KNA1.NAME1, SAP_KNA1.NAME2, SAP_KNA1.NAME3, SAP_KNA1.STRAS, SAP_KNA1.PSTLZ, SAP_KNA1.ORT01, SAP_KNA1.LAND1, SAP_KNA1.REGIO, SAP_KNA1.TELF1, SAP_KNA1.TELFX, SAP_KNA1.STCEG, SAP_KNA1.PERIV, SAP_KNA1.BRSCH, SAP_KNA1.STCD1, SAP_KNA1.NIELS, SAP_KNA1.ERNAM, SAP_KNA1.ERDAT, SAP_KNB1.BUKRS, SAP_KNB1.ZSABE, SAP_KNB1.ZWELS, SAP_KNB1.ZTERM, SAP_KNBK.BANKN, SAP_KNBK.KOINH, SAP_KNBK.BANKS, SAP_KNVV.VKORG, SAP_KNVV.VKBUR, SAP_KNVV.BZIRK, SAP_KNVV.VTWEG, SAP_KNVV.SPART, SAP_KNVV.KVGR1, SAP_KNVV.KVGR2, SAP_KNVV.KVGR3, SAP_KNVV.KVGR4, SAP_KNVV.KVGR5, SAP_KNVV.VKGRP, SAP_KNVV.LOEVM, SAP_KNA1.MANDT, SAP_ADRC.NAME2, SAP_ADRC.NAME3, SAP_KNBK.BANKL FROM SAP_KNA1, SAP_KNB1, SAP_KNBK, SAP_KNVV, SAP_ADRC WHERE SAP_KNA1.KUNNR = SAP_KNB1.KUNNR(+) AND SAP_KNA1.KUNNR = SAP_KNBK.KUNNR(+) AND SAP_KNA1.KUNNR = SAP_KNVV.KUNNR(+) AND SAP_KNA1.KUNNR = SAP_ADRC.ADDRNUMBER(+) AND SAP_ADRC.DATE_TO(+) = TO_DATE('99991231', 'YYYYMMDD')
4tg8mr2bvy6gr select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax
4wdq8nhtd4ggd INSERT INTO NOLB_TSKUGTPLU(ORGCODE, DEPID, DEPCODE, DEPNAME, PLUID, PLUCODE, PLUNAME, PLUENAME, PLUABBRNAME, PLUMN, BARCODE, UNIT, SPEC, ISPACKDSC, ISPTDSC, ISXLDSC, ISPLDSC, ISHYDSC, ISCERTIDSC, ISKC, ISKCNOW, ISZEROSALE, HYPRICE, PRICE, DOTDECIMAL, XTAXRATE, ISWEIGHT, ISCOUTQTY, MINPRICE, MAXPRICE, ISCANSALE, ISCANSALETH, ISCANPRESENT, ISPRESENT, ISMINPRICE, PROMDECIMAL, PROMFORMULA, PLUTYPE, UPTFLAG, CLSID, CLSCODE, BRANDCODE, POSCOMCURNO, POSCOMUPTYPE, UPTDATE) VALUES ( :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)
5fwkqja3jckh0 SELECT EXPRESSION, EXPR_ID, LINE_NO FROM OPB_EXPRESSION WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 ORDER BY EXPR_ID, LINE_NO ASC
5j0q2df7hm1k2 INSERT INTO MGMT_METRICS_RAW (TARGET_GUID, COLLECTION_TIMESTAMP, METRIC_GUID, KEY_VALUE, VALUE) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
5mna7rfz1kx6z SELECT MCSODS.FCT_STATION_LOSS_SUB.COMM_ID, MCSODS.FCT_STATION_LOSS_SUB.YK_COUNT, MCSODS.FCT_STATION_LOSS_SUB.YK_HCOST, MCSODS.FCT_STATION_LOSS_SUB.YK_WCOST, MCSODS.FCT_STATION_LOSS_SUB.YK_SCOST, MCSODS.FCT_STATION_LOSS.STORE_ID, MCSDW.YEAR_MONTH_DIM.YEAR_MONTH_ID FROM MCSDW.YEAR_MONTH_DIM, MCSODS.FCT_STATION_LOSS, MCSODS.FCT_STATION_LOSS_SUB WHERE FCT_STATION_LOSS.STATION_LOSS_ID=FCT_STATION_LOSS_SUB.STATION_LOSS_ID AND FCT_STATION_LOSS.RPT_DATE BETWEEN YEAR_MONTH_DIM.CAL_MONTH_BEGIN AND YEAR_MONTH_DIM.CAL_MONTH_END AND FCT_STATION_LOSS.BILL_TYPE='4' AND (0=1 OR TO_DATE('2014-04-20', 'YYYY-MM-DD') BETWEEN YEAR_MONTH_DIM.CAL_MONTH_BEGIN AND YEAR_MONTH_DIM.CAL_MONTH_END)
5s34t44u10q4g SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :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
5yv7yvjgjxugg select TIME_WAITED_MICRO from V$SYSTEM_EVENT where event = 'Shared IO Pool Memory'
5zp39my20n6zn SELECT RSNUM, RSPOS FROM FCT_RESERVED_ORDER ORDER BY RSNUM, RSPOS
65n74bvx3vs46 SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, LIB_TYPE FROM OPB_MMD_LIBS WHERE COMPONENT_ID = :1 AND COMPONENT_TYPE = 1
6dv0dpznx0dg9 select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS'
6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6h5t2wyax3cx0 SELECT ltrim(rtrim(accept_gsmhm)) accept_gsmhm, accept_e, accept_n, accept_time FROM tank_gps_yyyymmdd where accept_time>trunc(sysdate)
6k5agh28pr3wp select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6ss9jsrba6g2z SELECT METAEXT_NAME, DATA_TYPE, MAX_LENGTH, OBJECT_TYPE, DBTYPE, SUBTYPE, PERMISSIONS, DEFAULT_VALUE, METAEXT_DESC, METAEXT_PROP, OPB_OBJECT_ID, OBJVERSION, LINE_NO FROM OPB_MMD_METAEXT WHERE VENDOR_ID = :1 AND DOMAIN_ID = :2 ORDER BY OBJECT_TYPE, DBTYPE, METAEXT_NAME, LINE_NO ASC
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
772s25v1y0x8k select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7jfvtx5a4svff UPDATE OPB_TASK_INST_RUN SET END_TIME=:1, RUN_STATUS_CODE=:2, RUN_ERR_CODE =:3, RUN_ERR_MSG = :4, SERVER_NODE_NAME = :5 WHERE WORKFLOW_ID = :6 AND WORKFLOW_RUN_ID = :7 AND WORKLET_RUN_ID = :8 AND INSTANCE_ID = :9 AND FRAGMENT_ID = -1
7wt7phk4xns75 select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
7zmfr1s2uamz5 SELECT FCT_RESERVED_ORDER.MATNR, FCT_RESERVED_ORDER.WERKS, FCT_RESERVED_ORDER.UMWRK, FCT_RESERVED_ORDER.UMLGO, FCT_RESERVED_ORDER.LGORT, FCT_RESERVED_ORDER.RSNUM, FCT_RESERVED_ORDER.BDTER, FCT_RESERVED_ORDER.OIB_BLTIME, FCT_RESERVED_ORDER.BDMNG, FCT_RESERVED_ORDER.ENMNG, FCT_RESERVED_ORDER.WEMPF, FCT_RESERVED_ORDER.SGTXT FROM FCT_RESERVED_ORDER WHERE FCT_RESERVED_ORDER.ETL_TIME >= TRUNC(SYSDATE)
80cqc24ntgmf8 SELECT DESCRIPTION, PM_VALUE, EXEC_ORDER, VAL_NAME, TASK_ID, SESSION_ID, WORKFLOW_ID, INSTANCE_ID, LINE_NO, BIT_OPTION FROM OPB_TASK_VAL_LIST WHERE TASK_ID = :1 AND TASK_TYPE = :2 AND COMPONENT_TYPE = :3 AND SESSION_ID = 0 AND INSTANCE_ID = 0 AND VERSION_NUMBER = :4 ORDER BY TASK_ID, EXEC_ORDER, LINE_NO ASC
85fbq1b55c07d SELECT TRAFFIC_MONITOR_ID, PLAN_QTY, REAL_QTY, INSERT_TIME, RSNUM, OIL_ID FROM FCT_TRAFFIC_MONITOR ORDER BY RSNUM, OIL_ID
85ja7fnp61tu5 SELECT SESS_WIDG_INST_ID, RESOURCE_TYPE, RESOURCE_NAME FROM OPB_TASK_RES_REFS WHERE TASK_ID = :1 AND TASK_INST_ID = :2 AND WORKFLOW_ID = :3 AND VERSION_NUMBER = :4
86w49kdq48gk9 SELECT STATUS#, HOW_CREATED, LAST_EXECUTION FROM SYS.DBA_ADVISOR_TASKS WHERE TASK_ID = :B1 FOR UPDATE
88juhgrgf4zqa SELECT DISTINCT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDINGCOUNT FINDINGCOUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS, INSTANCES.INSTANCE_COUNT INSTCOUNT FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(DISTINCT F_ALL.TASK_ID) FINDINGCOUNT, F_CURR.FINDING_NAME FROM (SELECT DISTINCT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 AND TYPE<>'INFORMATION' AND TYPE<>'WARNING' AND PARENT=0) F_CURR, (SELECT TASK_ID, END_TIME FROM DBA_ADDM_TASKS WHERE END_TIME>SYSDATE -1 AND REQUESTED_ANALYSIS='DATABASE') TASKS, (SELECT DISTINCT FINDING_NAME , TASK_ID FROM DBA_ADVISOR_FINDINGS) F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME GROUP BY F_CURR.FINDING_NAME) HISTORY, (SELECT F.TASK_ID, F.FINDING_ID, COUNT(B.INSTANCE_NUMBER) INSTANCE_COUNT FROM DBA_ADDM_FDG_BREAKDOWN B, DBA_ADDM_FINDINGS F WHERE B.TASK_ID= :B1 AND B.TASK_ID=F.TASK_ID AND B.FINDING_ID =F.FINDING_ID AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.PARENT=0 GROUP BY F.FINDING_ID, F.TASK_ID ORDER BY F.FINDING_ID ) INSTANCES WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME(+) AND F.TASK_ID=INSTANCES.TASK_ID(+) AND F.FINDING_ID=INSTANCES.FINDING_ID (+) ORDER BY F.FINDING_ID
8wy6a0y7k22zn SELECT SUBJECT_ID FROM OPB_WIDGET WHERE WIDGET_ID = :1
8yyxd2kvr1m9x UPDATE retail_station_info_dim a SET a.station_capacity= (SELECT v.station_t_capacity FROM VIEW_STATION_OILTANK_CAPACITY v WHERE a.station_code=v.station_code) where IS_NEW = '1'
9ffufkbjyyx7r UPDATE STA_STATION_FACILITY SET STATION_ID = :1, TYPE_CODE = :2, TYPE_NAME = :3, PROJECT_CODE = :4, PROJECT_NAME = :5, FACILITY_CODE = :6, FACILITY_NAME = :7, UPDATE_DATE = :8 WHERE FAC_ID = :9
9juw6s4yy5pzp /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9nn7skr6fk85q SELECT FYP_FCT_SALE.STORE_ID, FYP_FCT_SALE.COMM_PRICE, FYP_FCT_SALE.COMM_PROFIT, FYP_FCT_SALE.TAG FROM TIME_DAY_DIM, FYP_FCT_SALE WHERE FYP_FCT_SALE.DAY_ID=TIME_DAY_DIM.DAY_ID AND TIME_DAY_DIM.CAL_DATE<=ADD_MONTHS(TO_DATE('2014-04-20', 'YYYY-MM-DD'), -1) AND TIME_DAY_DIM.CAL_DATE>=ADD_MONTHS(TRUNC(TO_DATE('2014-04-20', 'YYYY-MM-DD'), 'MM'), -1)
9vt6njn4h1wf1 SELECT TRIM(B.METRIC_NAME) FROM MGMT_TARGETS A, MGMT_METRICS B WHERE B.METRIC_GUID = :B2 AND A.TARGET_TYPE = B.TARGET_TYPE AND A.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = A.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = A.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = A.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = A.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = A.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ') AND A.TARGET_GUID=:B1
9wncfacx0nj9h insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
a0r18jnk4frap SELECT WIDGET_NAME, WIDGET_TYPE, IS_REUSABLE, SUBJECT_ID, VERSION_STATUS, COMMENTS, WIDGET_PROP, LAST_SAVED, CREATE_INFO, OBJVERSION, UTC_LAST_SAVED, IS_VISIBLE, UTC_REF_TIME, CHECKOUT_USER_ID, TEMPLATE_ID, RU_PARENT_ID, RU_VERSION_NUMBER, FILE_ID, COMP_VERSION FROM OPB_WIDGET WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 AND SUBJECT_ID = :3
a5pyncg7v0bw3 /* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_F INDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
asmju60ht2qn0 delete from mcsods.fct_sell_day_end fs where fs.etl_time >= to_date('20140420', 'YYYYMMDD') and (fs.sell_date, fs.station_code, fs.pay_oil_type, fs.oil_code) in (select t.sell_date, t.station_code, t.pay_oil_type, t.oil_code from mcsods.fct_sell_day_end t where t.etl_time >= to_date('20140420', 'YYYYMMDD') minus select t.sfdat as sell_date, t.stnid as station_code, m.payoil_code as pay_oil_type, t.matnr as oil_code from mcszemn.fct_im_import_sales_data t, mcsods.map_payoil_type m where t.bnsid_cust = m.zemn_code(+) and t.bukrs = '3300' and t.matnr in (select zemn_code from mcsods.map_oil where zemn_code is not null) and t.dflag is null and t.rulind != '4' and t.etl_time >= to_date('20140420', 'YYYYMMDD')-7)
b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait
b2u9kspucpqwy SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
bjstq78pprd24 SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
c15z5v8875zad select FCT_SALE_COMM_MAS.CONTRACT_ID, FCT_SALE_COMM_MAS.SUPPLIER_ID, FCT_SALE_COMM_MAS.COMM_ID, sum(FCT_SALE_COMM_MAS.COMM_COUNT) as SUM_COMM_COUNT, sum(FCT_SALE_COMM_MAS.COMM_COUNT*FCT_SALE_COMM_MAS.HJ_PRICE) as SUM_HJ_PRICE from FCT_SALE_COMM_MAS group by FCT_SALE_COMM_MAS.CONTRACT_ID, FCT_SALE_COMM_MAS.SUPPLIER_ID, FCT_SALE_COMM_MAS.COMM_ID
c281nr5shzx0n INSERT INTO NOLB_TSALSALEPLUYYYYMM(ORGCODE, SALENO, XSDATE, TRANTYPE, PAGENO, LNNO, CLKID, CLKCODE, PACKTYPE, PACKCODE, PLUID, PLUCODE, PLUNAME, EXPLUCODE, BARCODE, UNIT, SPEC, DEPID, DEPCODE, DEPNAME, PRICE, FSPRICE, XSCOUNT, YSTOTAL, SSTOTAL, YHTOTAL, SRTOTAL, XFTYPE, AUTHNO, REASON, REASONNAME, CXBILLNO, HYBILLNO, CLKBILLNO, INVNO, INVSTATUS, REMARK, JZDATE, TAG) VALUES ( :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)
c95qnptjy342z select a.matnr, a.werks, a.lgort, a.charg, a.datum as datum_b, case when b.datum is null then to_date('9999-12-31', 'yyyy-mm-dd') else b.datum - 1 end as datum_e, a.tdich, a.tstmp, a.tsteh, a.mttmp, a.mtteh, a.hydro, a.abind from (select row_number() over(partition by matnr, werks, lgort, charg order by matnr, werks, lgort, charg, datum) as rid, matnr, werks, lgort, charg, datum, tdich, tstmp, tsteh, mttmp, mtteh, hydro, abind from mcsstg.sap_oib03) a left join (select row_number() over(partition by matnr, werks, lgort, charg order by matnr, werks, lgort, charg, datum) - 1 as rid, matnr, werks, lgort, charg, datum, tdich, tstmp, tsteh, mttmp, mtteh, hydro, abind from mcsstg.sap_oib03) b on a.rid || a.matnr || a.werks || a.lgort || a.charg = b.rid || b.matnr || b.werks || b.lgort || b.charg
cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnumpcz520unc SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
ct227jp07uztb SELECT NOLB_TPRCTSJBODY.BILLNO, NOLB_TPRCTSJBODY.SERIALNO, NOLB_TPRCTSJBODY.PLUID, NOLB_TPRCTSJBODY.PLUCODE, NOLB_TPRCTSJBODY.PLUNAME, NOLB_TPRCTSJBODY.HJPRICE, NOLB_TPRCTSJBODY.PRICE, NOLB_TPRCTSJBODY.PFPRICE, NOLB_TPRCTSJBODY.NEWPRICE, NOLB_TPRCTSJBODY.NEWPFPRICE, MCSODS.FCT_SELL_PRICE.SELL_PRICE_ID FROM MCSODS.FCT_SELL_PRICE, NOLB_TPRCTSJBODY WHERE FCT_SELL_PRICE.PRICE_BILLNO=NOLB_TPRCTSJBODY.BILLNO AND (0=1 OR TRUNC(FCT_SELL_PRICE.RPT_DATE)=TO_DATE('2014-04-20', 'YYYY-MM-DD'))
cxjqbfn0d3yqq SELECT COUNT(*) FROM SYS.DBA_PROPAGATION
cxjzbma42ckb5 SELECT ATTR_ID, ATTR_VALUE, LINE_NO FROM OPB_WIDGET_ATTR WHERE WIDGET_ID = :1 AND WIDGET_TYPE = :2 AND VERSION_NUMBER = :3 AND MAPPING_ID = 0 AND INSTANCE_ID = 0 AND SESSION_ID = 0 AND SESSION_TASK_ID = 0 AND PARTITION_ID = 0 ORDER BY ATTR_ID, LINE_NO ASC
d15cdr0zt3vtp SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')
d1wky1vpysxc9 SELECT FCT_SELL_DAY_END.SELL_DATE, FCT_SELL_DAY_END.OIL_ID, FCT_SELL_DAY_END.SALES_TYPE, FCT_SELL_DAY_END.QUANTITY, FCT_SELL_DAY_END.AMOUNT FROM FCT_SELL_DAY_END WHERE sell_date between (select t.startdate from fct_closing_info t where to_date('2014-04-21', 'yyyy-mm-dd') - 31 between t.startdate and t.enddate) and (select t.enddate from fct_closing_info t where to_date('2014-04-21', 'yyyy-mm-dd') between t.startdate and t.enddate)
dd757xnmm2q80 insert into SERVER_INVENTORY_HI(STATION_ID, TANK_ID, DEVICE_BRAND, UPLOAD_TIME1, TANK_STATE, OIL_ID, OIL_VOLUME, STANDARD_VOLUME, EMPTY_VOLUME, OIL_HEIGHT, WATER_HEIGHT, TEMPERATURE, WATER_VOLUME, APPARENT_DENSITY, STANDARD_DENSITY, INSERT_TIME) values (:STATIONID, :TANKID, :DEVICEBRAND, :UPLOADTIME1, :TANKSTATE, :OILID, :OILVOLUME, :STANDARDVOLUME, :EMPTYVOLUME, :OILHEIGHT, :WATERHEIGHT, :TEMPER, :WATERVOLUME, :APPARENTDENSITY, :STANDARDDENSITY, sysdate)
f0jxh8d6b5af2 /* OracleOEM */ select a.capture_name capture_name, total_messages_captured, total_messages_enqueued from gv$streams_capture a, dba_capture b, dba_queues c, dba_queue_tables d where a.capture_name = b.capture_name and b.queue_name=c.name and b.queue_owner=c.owner and c.queue_table=d.queue_table and c.owner=d.owner and d.owner_instance=a.inst_id
f3u6vd210afnt SELECT FIELD_NAME, FIELD_ID, WGT_PREC, WGT_SCALE, WGT_DATATYPE, PORTTYPE, FIELD_ORDER, COMMENTS, WIDGET_FLD_PROP, DEFAULT_VALUE, SRC_FIELD_ID, GROUP_ID, WIDGET_FLD_PROP2, OUTGROUP_ID, PICTXT FROM OPB_WIDGET_FIELD WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2
fn5xaswj0adsb DELETE FROM MCSODS.COMM_ABNORMAL_DATA WHERE ANM_TYPE='27'
frdxb5s9mwkxn INSERT INTO FCT_OILDEPOT_STOCK_ERP(MANDT, MATNR, MAKTX, MATKL, WGBEZ, WERKS, NAME1, LGORT, LGOBE, CHARG, SOBKZ, KUNNR, NAME1_KNA1, LVORM, LFGJA, LFMON, CLABS, CVMLA, STOCK_DATE, ETL_TIME) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)
g3ds9bj2t4gtz SELECT DISTINCT M.MAPPING_ID, M.SUBJECT_ID FROM OPB_MAPPING M, OPB_WIDGET_INST I, OPB_VALIDATE V, OPB_WIDGET W WHERE M.IS_VISIBLE = :1 AND M.MAPPING_ID = I.MAPPING_ID AND M.VERSION_NUMBER = I.VERSION_NUMBER AND M.REF_WIDGET_ID = 0 AND M.MAPPING_ID IN (182) AND I.WIDGET_TYPE = W.WIDGET_TYPE AND I.WIDGET_ID = W.WIDGET_ID AND V.SUBJECT_ID = W.SUBJECT_ID AND V.OBJECT_TYPE = I.WIDGET_TYPE AND V.OBJECT_ID = I.WIDGET_ID AND V.VERSION_NUMBER = W.VERSION_NUMBER AND V.INV_UTC > M.UTC_LAST_SAVED AND M.IS_VALID = 1 AND W.IS_REUSABLE = 1 AND (W.IS_VISIBLE <> 2 OR (W.IS_VISIBLE = 2 AND W.CHECKOUT_USER_ID = :2))
gan8rn3g2vcy1 SELECT TRIGGER_STATE FROM QRTZ92_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2
gb0r7q3w52br8 SELECT FCT_SELL_DAY_END.STATION_ID, FCT_SELL_DAY_END.STATION_CODE, FCT_SELL_DAY_END.QUANTITY FROM FCT_SELL_DAY_END WHERE to_char(sell_date, 'yyyy') = to_char(sysdate, 'yyyy') - 1
gdxm55c5pr008 UPDATE GPS_YYYYMMDD_TEMP SET ACCEPT_E = :1, ACCEPT_N = :2 WHERE ACCEPT_GSMHM = :3
gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gtymd9z3asvh1 SELECT :B2 TASK_AVAILABLE, LATEST_TASKS.TASK_COUNT, :B1 FROM DUAL, (SELECT COUNT(TASK_ID) TASK_COUNT FROM DBA_ADDM_TASKS WHERE END_TIME>SYSDATE -1 AND REQUESTED_ANALYSIS='DATABASE') LATEST_TASKS

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 11,315 3.15 0.08
Batched IO (full) vector count 0 0.00 0.00
Batched IO (space) vector count 0 0.00 0.00
Batched IO block miss count 48,205 13.43 0.36
Batched IO buffer defrag count 5 0.00 0.00
Batched IO double miss count 6,871 1.91 0.05
Batched IO same unit count 28,913 8.06 0.21
Batched IO single block count 6,881 1.92 0.05
Batched IO slow jump count 6,817 1.90 0.05
Batched IO vector block count 12,709 3.54 0.09
Batched IO vector read count 4,741 1.32 0.04
Block Cleanout Optim referenced 2,913 0.81 0.02
CCursor + sql area evicted 32 0.01 0.00
CPU used by this session 59,809 16.67 0.44
CPU used when call started 50,153 13.98 0.37
CR blocks created 558 0.16 0.00
Cached Commit SCN referenced 166,374 46.37 1.23
Clusterwide global transactions 1,267 0.35 0.01
Commit SCN cached 8,753 2.44 0.06
DB time 817,541 227.85 6.06
DBWR checkpoint buffers written 819,150 228.30 6.07
DBWR checkpoints 476 0.13 0.00
DBWR fusion writes 29,726 8.28 0.22
DBWR object drop buffers written 2,319 0.65 0.02
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 8 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 201 0.06 0.00
DBWR undo block writes 512,935 142.96 3.80
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 394 0.11 0.00
DX/BB enqueue lock background get time 21 0.01 0.00
DX/BB enqueue lock background gets 2,534 0.71 0.02
DX/BB enqueue lock foreground requests 11,404 3.18 0.08
DX/BB enqueue lock foreground wait time 63 0.02 0.00
EHCC Analyzer Calls 0 0.00 0.00
EHCC CU Row Pieces Compressed 0 0.00 0.00
EHCC CUs Compressed 0 0.00 0.00
EHCC CUs Decompressed 0 0.00 0.00
EHCC Check CUs Decompressed 0 0.00 0.00
EHCC Columns Decompressed 0 0.00 0.00
EHCC Compressed Length Compressed 0 0.00 0.00
EHCC Compressed Length Decompressed 0 0.00 0.00
EHCC Decompressed Length Compressed 0 0.00 0.00
EHCC Decompressed Length Decompressed 0 0.00 0.00
EHCC Normal Scan CUs Decompressed 0 0.00 0.00
EHCC Pieces Buffered for Decompression 0 0.00 0.00
EHCC Query High CUs Compressed 0 0.00 0.00
EHCC Query High CUs Decompressed 0 0.00 0.00
EHCC Rowid CUs Decompressed 0 0.00 0.00
EHCC Rows Compressed 0 0.00 0.00
EHCC Rows Not Compressed 0 0.00 0.00
EHCC Total Columns for Decompression 0 0.00 0.00
EHCC Total Pieces for Decompression 0 0.00 0.00
EHCC Total Rows for Decompression 0 0.00 0.00
EHCC Turbo Scan CUs Decompressed 0 0.00 0.00
Effective IO time 885,258 246.72 6.57
GTX processes spawned by autotune 0 0.00 0.00
GTX processes stopped by autotune 0 0.00 0.00
HCC Conventional DMLs 0 0.00 0.00
HCC non-CU Compressed Blocks 0 0.00 0.00
HCC: Number of times tried to non-CU Compress a Block 0 0.00 0.00
HSC Compressed Segment Block Changes 310,693 86.59 2.30
HSC Heap Segment Block Changes 5,288,060 1,473.80 39.22
HSC IDL Compressed Blocks 0 0.00 0.00
HSC OLTP Compressed Blocks 22,179 6.18 0.16
HSC OLTP Non Compressible Blocks 22,111 6.16 0.16
HSC OLTP Space Saving 233,075,874 64,958.84 1,728.51
HSC OLTP inline compression 113,261 31.57 0.84
HSC OLTP negative compression 0 0.00 0.00
HSC OLTP positive compression 114,491 31.91 0.85
HSC OLTP recursive compression 1,230 0.34 0.01
Heap Segment Array Inserts 213,242 59.43 1.58
Heap Segment Array Updates 34,841 9.71 0.26
LOB table id lookup cache misses 0 0.00 0.00
Number of read IOs issued 1,679 0.47 0.01
PX local messages recv'd 1,612 0.45 0.01
PX local messages sent 1,612 0.45 0.01
PX remote messages recv'd 844 0.24 0.01
PX remote messages sent 868 0.24 0.01
Parallel operations not downgraded 394 0.11 0.00
Requests to/from client 7,476,880 2,083.83 55.45
RowCR - row contention 2 0.00 0.00
RowCR attempts 438 0.12 0.00
RowCR hits 436 0.12 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 7,476,824 2,083.81 55.45
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 220,474 61.45 1.64
application wait time 563 0.16 0.00
background checkpoints completed 2 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 30,560 8.52 0.23
branch node splits 171 0.05 0.00
buffer is not pinned count 13,395,627 3,733.40 99.34
buffer is pinned count 96,446,093 26,879.77 715.25
bytes received via SQL*Net from client 1,519,040,996 423,360.57 11,265.34
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 3,743,969,868 1,043,453.87 27,765.61
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 5,235,036 1,459.02 38.82
calls to kcmgas 1,136,187 316.66 8.43
calls to kcmgcs 451,034 125.70 3.34
cell CUs processed for uncompressed 0 0.00 0.00
cell CUs sent uncompressed 0 0.00 0.00
cell IO uncompressed bytes 49,522,696,192 13,802,100.63 367,264.62
cell blocks helped by commit cache 0 0.00 0.00
cell blocks helped by minscn optimization 6,282,487 1,750.95 46.59
cell blocks processed by cache layer 6,288,896 1,752.73 46.64
cell blocks processed by data layer 6,045,251 1,684.83 44.83
cell blocks processed by txn layer 6,288,896 1,752.73 46.64
cell commit cache queries 0 0.00 0.00
cell flash cache read hits 183,251 51.07 1.36
cell num fast response sessions 0 0.00 0.00
cell num fast response sessions continuing to smart scan 0 0.00 0.00
cell num smart IO sessions using passthru mode due to cellsrv 0 0.00 0.00
cell physical IO bytes eligible for predicate offload 58,784,882,688 16,383,495.43 435,953.80
cell physical IO bytes saved by storage index 9,285,910,528 2,588,006.74 68,865.12
cell physical IO bytes saved during optimized file creation 0 0.00 0.00
cell physical IO interconnect bytes 62,388,011,344 17,387,696.49 462,674.92
cell physical IO interconnect bytes returned by smart scan 4,942,737,232 1,377,553.36 36,655.77
cell scans 11 0.00 0.00
cell smart IO session cache hard misses 0 0.00 0.00
cell smart IO session cache hits 1 0.00 0.00
cell smart IO session cache hwm 0 0.00 0.00
cell smart IO session cache lookups 1 0.00 0.00
cell smart IO session cache soft misses 1 0.00 0.00
cell transactions found in commit cache 0 0.00 0.00
chained rows processed by cell 0 0.00 0.00
chained rows rejected by cell 0 0.00 0.00
chained rows skipped by cell 0 0.00 0.00
change write time 9,262 2.58 0.07
cleanout - number of ktugct calls 258,608 72.07 1.92
cleanouts and rollbacks - consistent read gets 127 0.04 0.00
cleanouts only - consistent read gets 3,768 1.05 0.03
cluster key scan block gets 7,471 2.08 0.06
cluster key scans 5,528 1.54 0.04
cluster wait time 4,412 1.23 0.03
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 73 0.02 0.00
commit batch/immediate requested 73 0.02 0.00
commit cleanout failures: block lost 750 0.21 0.01
commit cleanout failures: buffer being written 5 0.00 0.00
commit cleanout failures: cannot pin 288 0.08 0.00
commit cleanouts 2,612,857 728.21 19.38
commit immediate performed 73 0.02 0.00
commit immediate requested 73 0.02 0.00
commit txn count during cleanout 104,227 29.05 0.77
concurrency wait time 322 0.09 0.00
consistent changes 15,523 4.33 0.12
consistent gets 42,257,171 11,777.18 313.38
consistent gets - examination 16,839,009 4,693.07 124.88
consistent gets direct 7,177,568 2,000.41 53.23
consistent gets from cache 35,079,603 9,776.77 260.15
consistent gets from cache (fastpath) 18,022,049 5,022.79 133.65
cursor authentications 340 0.09 0.00
data blocks consistent reads - undo records applied 917 0.26 0.01
db block changes 22,083,531 6,154.74 163.77
db block gets 21,923,430 6,110.12 162.59
db block gets direct 1,689 0.47 0.01
db block gets from cache 21,921,741 6,109.64 162.57
db block gets from cache (fastpath) 5,169,606 1,440.78 38.34
deferred (CURRENT) block cleanout applications 1,830,110 510.06 13.57
dirty buffers inspected 942 0.26 0.01
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 4,295 1.20 0.03
enqueue releases 353,067 98.40 2.62
enqueue requests 353,089 98.41 2.62
enqueue timeouts 25 0.01 0.00
enqueue waits 5,183 1.44 0.04
exchange deadlocks 4 0.00 0.00
execute count 5,205,370 1,450.75 38.60
failed probes on index block reclamation 0 0.00 0.00
file io service time 0 0.00 0.00
file io wait time 585,097,456 163,068.14 4,339.13
frame signature mismatch 0 0.00 0.00
free buffer inspected 1,584,710 441.66 11.75
free buffer requested 1,644,938 458.45 12.20
gc blocks compressed 82,124 22.89 0.61
gc cr block flush time 66 0.02 0.00
gc cr block receive time 3,503 0.98 0.03
gc cr blocks received 119,875 33.41 0.89
gc cr blocks served 103,833 28.94 0.77
gc current block flush time 111 0.03 0.00
gc current block pin time 6 0.00 0.00
gc current block receive time 11,666 3.25 0.09
gc current blocks received 270,932 75.51 2.01
gc current blocks served 184,359 51.38 1.37
gc kbytes saved 281,991 78.59 2.09
gc kbytes sent 2,023,553 563.97 15.01
gc local grants 825,078 229.95 6.12
gc read wait time 16 0.00 0.00
gc read wait timeouts 0 0.00 0.00
gc read waits 141 0.04 0.00
gc remote grants 382,978 106.74 2.84
gcs messages sent 1,230,432 342.92 9.12
ges messages sent 81,510 22.72 0.60
global enqueue get time 1,045 0.29 0.01
global enqueue gets async 6,676 1.86 0.05
global enqueue gets sync 410,866 114.51 3.05
global enqueue releases 398,710 111.12 2.96
heap block compress 125,647 35.02 0.93
hot buffers moved to head of LRU 369,304 102.93 2.74
immediate (CR) block cleanout applications 3,895 1.09 0.03
immediate (CURRENT) block cleanout applications 179,206 49.95 1.33
in call idle wait time 20,033,858 5,583.49 148.57
index crx upgrade (positioned) 2,615 0.73 0.02
index crx upgrade (prefetch) 0 0.00 0.00
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 50 0.01 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 4,352,050 1,212.93 32.28
index scans kdiixs1 850,960 237.16 6.31
leaf node 90-10 splits 600 0.17 0.00
leaf node splits 47,606 13.27 0.35
lob reads 4,381 1.22 0.03
lob writes 5,783 1.61 0.04
lob writes unaligned 4,104 1.14 0.03
local undo segment hints helped 0 0.00 0.00
logical read bytes from cache 466,954,977,280 130,141,532.75 3,462,978.73
logons cumulative 7,051 1.97 0.05
max cf enq hold time 50 0.01 0.00
messages received 230,331 64.19 1.71
messages sent 230,331 64.19 1.71
min active SCN optimization applied on CR 0 0.00 0.00
no buffer to keep pinned count 4 0.00 0.00
no work - consistent read gets 17,796,838 4,960.02 131.98
non-idle wait count 9,567,443 2,666.47 70.95
non-idle wait time 80,589 22.46 0.60
opened cursors cumulative 1,146,737 319.60 8.50
parse count (describe) 8 0.00 0.00
parse count (failures) 176 0.05 0.00
parse count (hard) 3,408 0.95 0.03
parse count (total) 249,720 69.60 1.85
parse time cpu 1,076 0.30 0.01
parse time elapsed 1,974 0.55 0.01
physical read IO requests 257,913 71.88 1.91
physical read bytes 63,680,307,200 17,747,862.62 472,258.70
physical read requests optimized 192,123 53.55 1.42
physical read total IO requests 276,774 77.14 2.05
physical read total bytes 67,841,936,384 18,907,719.19 503,121.70
physical read total bytes optimized 10,972,020,736 3,057,929.92 81,369.46
physical read total multi block requests 66,871 18.64 0.50
physical reads 7,773,475 2,166.49 57.65
physical reads cache 594,275 165.63 4.41
physical reads cache prefetch 420,628 117.23 3.12
physical reads direct 7,179,200 2,000.86 53.24
physical reads direct (lob) 1,679 0.47 0.01
physical reads direct temporary tablespace 1,679 0.47 0.01
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 132,467 36.92 0.98
physical write bytes 6,999,293,952 1,950,720.92 51,907.37
physical write total IO requests 225,377 62.81 1.67
physical write total bytes 17,386,459,648 4,845,650.26 128,939.50
physical write total multi block requests 50,342 14.03 0.37
physical writes 854,406 238.13 6.34
physical writes direct 2,085 0.58 0.02
physical writes direct (lob) 1,679 0.47 0.01
physical writes direct temporary tablespace 1,680 0.47 0.01
physical writes from cache 852,321 237.54 6.32
physical writes non checkpoint 791,060 220.47 5.87
pinned buffers inspected 235 0.07 0.00
pinned cursors current 4 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 765 0.21 0.01
process last non-idle time 3,588 1.00 0.03
queries parallelized 394 0.11 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 1,110,198 309.41 8.23
recursive cpu usage 3,177 0.89 0.02
redo KB read 3,682,771 1,026.40 27.31
redo blocks checksummed by FG (exclusive) 4,863,720 1,355.53 36.07
redo blocks written 12,643,007 3,523.64 93.76
redo buffer allocation retries 1 0.00 0.00
redo entries 11,588,229 3,229.67 85.94
redo entries for lost write detection 167,953 46.81 1.25
redo log space requests 3 0.00 0.00
redo log space wait time 6 0.00 0.00
redo ordering marks 507,118 141.34 3.76
redo size 6,244,689,880 1,740,410.86 46,311.16
redo size for direct writes 57,744 16.09 0.43
redo size for lost write detection 19,232,016 5,360.01 142.63
redo subscn max counts 8,540 2.38 0.06
redo synch long waits 123 0.03 0.00
redo synch time 2,597 0.72 0.02
redo synch time (usec) 29,606,836 8,251.50 219.57
redo synch writes 60,885 16.97 0.45
redo wastage 19,331,192 5,387.65 143.36
redo write broadcast ack count 358 0.10 0.00
redo write broadcast ack time 1,628,798 453.95 12.08
redo write broadcast lgwr post count 0 0.00 0.00
redo write time 4,700 1.31 0.03
redo writes 70,601 19.68 0.52
rollback changes - undo records applied 186 0.05 0.00
rollbacks only - consistent read gets 417 0.12 0.00
root node splits 6 0.00 0.00
rows fetched via callback 308,595 86.01 2.29
scheduler wait time 0 0.00 0.00
session connect time 0 0.00 0.00
session cursor cache hits 191,766 53.45 1.42
session logical reads 64,180,642 17,887.31 475.97
shared hash latch upgrades - no wait 62,953 17.55 0.47
shared hash latch upgrades - wait 50 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 384,309 107.11 2.85
sorts (rows) 65,186,649 18,167.68 483.43
space was found by tune down 0 0.00 0.00
sql area evicted 2,281 0.64 0.02
sql area purged 279 0.08 0.00
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 18,079 5.04 0.13
switch current to new buffer 65,253 18.19 0.48
table fetch by rowid 51,132,065 14,250.64 379.20
table fetch continued row 1,745,734 486.54 12.95
table scan blocks gotten 11,756,163 3,276.47 87.18
table scan rows gotten 758,819,335 211,484.87 5,627.47
table scans (direct read) 11 0.00 0.00
table scans (long tables) 12 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 108,486 30.24 0.80
temp space allocated (bytes) 0 0.00 0.00
total cf enq hold time 9,590 2.67 0.07
total number of cf enq holders 466 0.13 0.00
total number of times SMON posted 897 0.25 0.01
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction rollbacks 72 0.02 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 2,953,753,020 823,218.43 21,905.29
user I/O wait time 29,661 8.27 0.22
user calls 8,486,721 2,365.27 62.94
user commits 46,948 13.08 0.35
user rollbacks 87,894 24.50 0.65
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 177,609 49.50 1.32
write clones created in background 531 0.15 0.00
write clones created in foreground 25 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session uga memory 296,410,279,048,488 296,642,571,393,088
opened cursors current 8,877 8,869
workarea memory allocated 8,437 8,437
logons current 1,099 1,093
session uga memory max 9,840,312,511,488 9,844,982,819,960
session pga memory 265,477,412,616 265,688,185,000
session pga memory max 506,522,489,704 506,822,818,376
session cursor cache count 142,672,813 142,741,701

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 1.00

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)
Smart Scan 54.8G 16.88 15.6274 0M 0.00 0M 0  
Others 3.9G 5.31 1.10644 3.7G 3.89 1.04401 18.4K 0.93
DBWR 0M 0.00 0M 6.5G 36.33 1.85560 0  
LGWR 1M 0.00 .000278 6G 22.49 1.72098 70.7K 0.28
Buffer Cache Reads 4.5G 54.08 1.29150 0M 0.00 0M 173.7K 1.15
Direct Reads 26M 0.92 .007246 2M 0.06 .000557 0  
Direct Writes 0M 0.00 0M 2M 0.05 .000557 0  
Streams AQ 0M 0.00 0M 0M 0.00 0M 2 1.50
TOTAL: 63.2G 77.20 18.0328 16.2G 62.83 4.62172 262.7K 0.90

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 59.3G 71.47 16.9247 6.5G 36.44 1.85699 1.36 3565.39
Log File 3.5G 1.00 1.00249 6G 22.48 1.72070 8.29 27.77
Archive Log 0M 0.00 0M 3.5G 1.00 1.00249    
Control File 372M 4.25 .103677 136M 2.43 .037903 0.10 8.24
Temp File 14M 0.47 .003901 13M 0.47 .003623 0.56  
TOTAL: 63.2G 77.20 18.0348 16.2G 62.83 4.62172 1.27 3367.73

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)
Smart Scan 54.8G 16.89 15.6307 0M 0.00 0M 0  
Smart Scan (Data File) 54.8G 16.89 15.6307 0M 0.00 0M 0  
Others 3.9G 5.31 1.10644 3.7G 3.89 1.04401 15.5K 0.27
Others (Archive Log) 0M 0.00 0M 3.5G 1.00 1.00249 0  
Others (Log File) 3.5G 1.00 1.00221 0M 0.00 0M 5 3.20
Others (Control File) 372M 4.25 .103677 135M 2.42 .037624 15.3K 0.18
Others (Data File) 2M 0.06 .000557 14M 0.47 .003901 198 7.63
DBWR 0M 0.00 0M 6.5G 36.33 1.85504 0  
DBWR (Data File) 0M 0.00 0M 6.5G 36.33 1.85504 0  
LGWR 1M 0.00 .000278 6G 22.49 1.72070 18 2.33
LGWR (Log File) 0M 0.00 0M 6G 22.48 1.72070 4 10.50
LGWR (Control File) 1M 0.00 .000278 0M 0.01 0M 14 0.00
Buffer Cache Reads 4.5G 54.08 1.28899 0M 0.00 0M 170.3K 1.05
Buffer Cache Reads (Data File) 4.5G 54.08 1.28899 0M 0.00 0M 170.3K 1.05
Direct Reads 26M 0.92 .007246 2M 0.06 .000557 0  
Direct Reads (Data File) 26M 0.92 .007246 2M 0.06 .000557 0  
Direct Writes 0M 0.00 0M 2M 0.05 .000557 0  
Direct Writes (Data File) 0M 0.00 0M 2M 0.05 .000557 0  
Streams AQ 0M 0.00 0M 0M 0.00 0M 2 1.50
Streams AQ (Data File) 0M 0.00 0M 0M 0.00 0M 2 1.50
TOTAL: 63.2G 77.20 18.0337 16.2G 62.82 4.62088 185.7K 0.99

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)
ALL_IDX 87,350 24 1.36 1.00 27,070 8 26 0.00
MCSSTG 64,759 18 3.01 5.79 19,601 5 36 3.33
UNDOTBS1 2 0 0.00 1.00 41,672 12 63 0.16
MCSODS 6,487 2 3.85 20.98 14,322 4 20 0.50
MCSDW 13,631 4 0.82 2.09 2,447 1 0 0.00
IDX_MCSDW 7,744 2 0.29 1.01 374 0 0 0.00
DEP 651 0 2.89 1.00 6,737 2 0 0.00
IDX_MCSODS 5,641 2 0.80 1.00 1,509 0 1 10.00
MCSERP 4,469 1 1.18 1.05 1,325 0 0 0.00
IDX_MCSSTG 237 0 2.24 1.00 4,333 1 24 0.42
MCSZEMN 3,679 1 0.59 1.00 93 0 522 2.80
GIS_DATA_IDX 435 0 1.03 1.00 3,230 1 0 0.00
INFO_DATA 1,123 0 2.05 1.00 2,270 1 11 0.00
TEMP 1,680 0 0.00 1.00 1,680 0 0 0.00
INFO_BASE 83 0 0.48 1.00 2,814 1 0 0.00
SYSAUX 304 0 0.95 1.03 1,010 0 0 0.00
SYSTEM 324 0 0.59 1.00 780 0 316 0.47
GIS_DATA 140 0 1.43 1.00 609 0 0 0.00
GIS_GPS_HIS_DATA 102 0 2.35 1.00 160 0 0 0.00
MCSAPP 73 0 0.55 1.00 75 0 0 0.00
DEV5_OIM 21 0 0.00 1.00 95 0 0 0.00
SDYWY 32 0 0.00 1.00 44 0 0 0.00
DEV117_OAM 24 0 0.42 1.00 29 0 0 0.00
TYYW 30 0 0.00 1.00 6 0 0 0.00
DEV6_BIPLATFORM 12 0 0.00 1.00 14 0 0 0.00
PORTAL 13 0 0.77 1.00 8 0 0 0.00
DEV1_IAS_ORASDPM 14 0 0.00 1.00 2 0 0 0.00
DEV1_MDS 14 0 0.00 1.00 2 0 0 0.00
DEV55_OIM 14 0 0.00 1.00 2 0 0 0.00
DEV55_OIM_LOB 14 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_IAU 14 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_OIF 14 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_ORASDPM 14 0 0.00 1.00 2 0 0 0.00
DEV5_MDS 14 0 0.00 1.00 2 0 0 0.00
DEV5_OAM 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_SEP 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_INDX 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_PL_LG_IDX 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_PS_LG_IDX 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_QA_DATA 14 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_WEBCENTER 14 0 0.00 1.00 2 0 0 0.00
DEV6_MDS 14 0 0.00 1.00 2 0 0 0.00
ETL_MONITOR 14 0 0.00 1.00 2 0 0 0.00
DEV117_IAS_IAU 12 0 0.00 1.00 2 0 0 0.00
DEV1_OIM 12 0 0.00 1.00 2 0 0 0.00
DEV1_OIM_LOB 12 0 0.00 1.00 2 0 0 0.00
DEV1_SOAINFRA 12 0 0.00 1.00 2 0 0 0.00
DEV53_IAS_IAU 12 0 0.00 1.00 2 0 0 0.00
DEV53_OAM 12 0 0.00 1.00 2 0 0 0.00
DEV5_APM 12 0 0.00 1.00 2 0 0 0.00
DEV5_BRSADATA 12 0 0.00 1.00 2 0 0 0.00
DEV5_OIM_LOB 12 0 0.00 1.00 2 0 0 0.00
DEV5_SOAINFRA 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_APR 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_AUG 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_DEC 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_FEB 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JAN 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JUL 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JUN 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_MAR 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_MAY 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_NOV 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_OCT 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ENTONE_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ENTX_MP_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_EONEPRF_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ET_US_MP_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_MON_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_MO_LG_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ND_HS_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ND_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_QA_HT_DATA 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_RL_LG_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_SESS_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_TX_DT_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_TX_LG_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_US_ND_IDX 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_ACTIVITY 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_DISCUSS 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_PORTLET 12 0 0.00 1.00 2 0 0 0.00
DEVBITEST_BIPLATFORM 12 0 0.00 1.00 2 0 0 0.00
DEVBITEST_MDS 12 0 0.00 1.00 2 0 0 0.00
MAPINFO 12 0 0.00 1.00 2 0 0 0.00
OLTS_ATTRSTORE 12 0 0.00 1.00 2 0 0 0.00
OLTS_CT_STORE 12 0 0.00 1.00 2 0 0 0.00
OLTS_SVRMGSTORE 12 0 0.00 1.00 2 0 0 0.00
OSBDB 12 0 0.00 1.00 2 0 0 0.00
DEV52_IAS_IAU 10 0 0.00 1.00 2 0 0 0.00
DEV52_OAM 10 0 0.00 1.00 2 0 0 0.00
DEV5_BRSAINDX 10 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_UDV_MP_IDX 10 0 0.00 1.00 2 0 0 0.00
OLTS_BATTRSTORE 10 0 0.00 1.00 2 0 0 0.00
OLTS_DEFAULT 10 0 0.00 1.00 2 0 0 0.00
MCSHTY_DATA 4 0 0.00 1.00 4 0 0 0.00
DEV1172_IAS_IAU 2 0 0.00 1.00 2 0 0 0.00
DEV1172_OAM 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 2 0 0.00 1.00 2 0 0 0.00
USERS 2 0 0.00 1.00 2 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)
ALL_IDX +DATA_DM01/mcsdb/midware_datafiles/all_idx01.dbf 35,545 10 1.34 1.00 7,610 2 9 0.00
ALL_IDX +DATA_DM01/mcsdb/midware_datafiles/all_idx02.dbf 17,777 5 1.32 1.00 6,267 2 6 0.00
ALL_IDX +DATA_DM01/mcsdb/midware_datafiles/all_idx03.dbf 6,793 2 1.39 1.00 5,811 2 8 0.00
ALL_IDX +DATA_DM01/mcsdb/midware_datafiles/all_idx04.dbf 27,235 8 1.42 1.00 7,382 2 3 0.00
DEP +DATA_DM01/mcsdb/ywy_datafiles/dep01.dbf 153 0 4.31 1.00 1,725 0 0 0.00
DEP +DATA_DM01/mcsdb/ywy_datafiles/dep02.dbf 131 0 1.76 1.00 1,108 0 0 0.00
DEP +DATA_DM01/mcsdb/ywy_datafiles/dep03.dbf 118 0 1.53 1.00 792 0 0 0.00
DEP +DATA_DM01/mcsdb/ywy_datafiles/dep04.dbf 101 0 2.28 1.00 1,872 1 0 0.00
DEP +DATA_DM01/mcsdb/ywy_datafiles/dep05.dbf 148 0 3.92 1.00 1,240 0 0 0.00
DEV1172_IAS_IAU +DATA_DM01/mcsdb/datafile/dev1172_ias_iau.473.822651789 2 0 0.00 1.00 2 0 0 0.00
DEV1172_OAM +DATA_DM01/mcsdb/datafile/dev1172_oam.474.822651789 2 0 0.00 1.00 2 0 0 0.00
DEV117_IAS_IAU +DATA_DM01/mcsdb/datafile/dev117_ias_iau.440.816802503 12 0 0.00 1.00 2 0 0 0.00
DEV117_OAM +DATA_DM01/mcsdb/datafile/dev117_oam.465.816802505 24 0 0.42 1.00 29 0 0 0.00
DEV1_IAS_ORASDPM +DATA_DM01/mcsdb/datafile/dev1_ias_orasdpm.441.802540727 14 0 0.00 1.00 2 0 0 0.00
DEV1_MDS +DATA_DM01/mcsdb/datafile/dev1_mds.445.802540727 14 0 0.00 1.00 2 0 0 0.00
DEV1_OIM +DATA_DM01/mcsdb/datafile/dev1_oim.447.802540729 12 0 0.00 1.00 2 0 0 0.00
DEV1_OIM_LOB +DATA_DM01/mcsdb/datafile/dev1_oim_lob.446.802540729 12 0 0.00 1.00 2 0 0 0.00
DEV1_SOAINFRA +DATA_DM01/mcsdb/datafile/dev1_soainfra.449.802540729 12 0 0.00 1.00 2 0 0 0.00
DEV52_IAS_IAU +DATA_DM01/mcsdb/datafile/dev52_ias_iau.461.815561541 10 0 0.00 1.00 2 0 0 0.00
DEV52_OAM +DATA_DM01/mcsdb/datafile/dev52_oam.463.815561541 10 0 0.00 1.00 2 0 0 0.00
DEV53_IAS_IAU +DATA_DM01/mcsdb/datafile/dev53_ias_iau.443.815481611 12 0 0.00 1.00 2 0 0 0.00
DEV53_OAM +DATA_DM01/mcsdb/datafile/dev53_oam.451.815481611 12 0 0.00 1.00 2 0 0 0.00
DEV55_OIM +DATA_DM01/mcsdb/datafile/dev55_oim.437.802540493 14 0 0.00 1.00 2 0 0 0.00
DEV55_OIM_LOB +DATA_DM01/mcsdb/datafile/dev55_oim_lob.442.802540491 14 0 0.00 1.00 2 0 0 0.00
DEV5_APM +DATA_DM01/mcsdb/datafile/dev5_apm.391.801068887 12 0 0.00 1.00 2 0 0 0.00
DEV5_BRSADATA +DATA_DM01/mcsdb/datafile/dev5_brsadata.381.801068881 12 0 0.00 1.00 2 0 0 0.00
DEV5_BRSAINDX +DATA_DM01/mcsdb/datafile/dev5_brsaindx.369.801068877 10 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_IAU +DATA_DM01/mcsdb/datafile/dev5_ias_iau.393.801068887 14 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_OIF +DATA_DM01/mcsdb/datafile/dev5_ias_oif.417.801068897 14 0 0.00 1.00 2 0 0 0.00
DEV5_IAS_ORASDPM +DATA_DM01/mcsdb/datafile/dev5_ias_orasdpm.416.801068897 14 0 0.00 1.00 2 0 0 0.00
DEV5_MDS +DATA_DM01/mcsdb/datafile/dev5_mds.419.801068897 14 0 0.00 1.00 2 0 0 0.00
DEV5_OAM +DATA_DM01/mcsdb/datafile/dev5_oam.418.801068897 14 0 0.00 1.00 2 0 0 0.00
DEV5_OIM +DATA_DM01/mcsdb/datafile/dev5_oim.413.801068895 21 0 0.00 1.00 95 0 0 0.00
DEV5_OIM_LOB +DATA_DM01/mcsdb/datafile/dev5_oim_lob.387.801068885 12 0 0.00 1.00 2 0 0 0.00
DEV5_SOAINFRA +DATA_DM01/mcsdb/datafile/dev5_soainfra.374.801068879 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data.384.801068883 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_APR +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_apr.371.801068877 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_AUG +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_aug.386.801068883 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_DEC +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_dec.377.801068881 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_FEB +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_feb.388.801068885 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JAN +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_jan.402.801068891 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JUL +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_jul.410.801068893 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_JUN +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_jun.408.801068893 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_MAR +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_mar.409.801068893 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_MAY +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_may.405.801068891 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_NOV +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_nov.385.801068883 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_OCT +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_oct.376.801068879 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_DATA_SEP +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_data_sep.394.801068887 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ENTONE_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_entone_idx.390.801068885 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ENTX_MP_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_entx_mp_idx.375.801068879 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_EONEPRF_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_eoneprf_idx.379.801068881 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ET_US_MP_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_et_us_mp_idx.372.801068877 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_INDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_indx.395.801068887 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_MON_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_mon_idx.389.801068885 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_MO_LG_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_mo_lg_idx.400.801068889 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ND_HS_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_nd_hs_idx.373.801068879 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_ND_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_nd_idx.406.801068891 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_PL_LG_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_pl_lg_idx.398.801068889 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_PS_LG_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_ps_lg_idx.397.801068889 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_QA_DATA +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_qa_data.399.801068889 14 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_QA_HT_DATA +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_qa_ht_data.382.801068883 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_RL_LG_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_rl_lg_idx.378.801068881 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_SESS_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_sess_idx.414.801068895 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_TX_DT_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_tx_dt_idx.407.801068893 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_TX_LG_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_tx_lg_idx.401.801068891 12 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_UDV_MP_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_udv_mp_idx.370.801068877 10 0 0.00 1.00 2 0 0 0.00
DEV5_TBS_OAAM_US_ND_IDX +DATA_DM01/mcsdb/datafile/dev5_tbs_oaam_us_nd_idx.411.801068895 12 0 0.00 1.00 2 0 0 0.00
DEV6_BIPLATFORM +DATA_DM01/mcsdb/datafile/dev6_biplatform.426.801069449 12 0 0.00 1.00 14 0 0 0.00
DEV6_IAS_ACTIVITY +DATA_DM01/mcsdb/datafile/dev6_ias_activity.424.801069449 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_DISCUSS +DATA_DM01/mcsdb/datafile/dev6_ias_discuss.427.801069451 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_PORTLET +DATA_DM01/mcsdb/datafile/dev6_ias_portlet.425.801069449 12 0 0.00 1.00 2 0 0 0.00
DEV6_IAS_WEBCENTER +DATA_DM01/mcsdb/datafile/dev6_ias_webcenter.421.801069447 14 0 0.00 1.00 2 0 0 0.00
DEV6_MDS +DATA_DM01/mcsdb/datafile/dev6_mds.423.801069449 14 0 0.00 1.00 2 0 0 0.00
DEVBITEST_BIPLATFORM +DATA_DM01/mcsdb/datafile/devbitest_biplatform.454.814114577 12 0 0.00 1.00 2 0 0 0.00
DEVBITEST_MDS +DATA_DM01/mcsdb/datafile/devbitest_mds.455.814114577 12 0 0.00 1.00 2 0 0 0.00
ETL_MONITOR +DATA_DM01/mcsdb/midware_datafiles/etl_monitor01.dbf 14 0 0.00 1.00 2 0 0 0.00
GIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_data01.dbf 140 0 1.43 1.00 609 0 0 0.00
GIS_DATA_IDX +DATA_DM01/mcsdb/gis_datafiles/gis_data_idx01.dbf 223 0 1.03 1.00 1,080 0 0 0.00
GIS_DATA_IDX +DATA_DM01/mcsdb/gis_datafiles/gis_data_idx02.dbf 131 0 1.30 1.00 1,549 0 0 0.00
GIS_DATA_IDX +DATA_DM01/mcsdb/gis_datafiles/gis_data_idx03.dbf 33 0 0.30 1.00 31 0 0 0.00
GIS_DATA_IDX +DATA_DM01/mcsdb/gis_datafiles/gis_data_idx04.dbf 30 0 0.33 1.00 25 0 0 0.00
GIS_DATA_IDX +DATA_DM01/mcsdb/gis_datafiles/gis_data_idx05.dbf 18 0 1.67 1.00 545 0 0 0.00
GIS_GPS_HIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_gps_his_data01.dbf 8 0 0.00 1.00 2 0 0 0.00
GIS_GPS_HIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_gps_his_data02.dbf 8 0 0.00 1.00 2 0 0 0.00
GIS_GPS_HIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_gps_his_data03.dbf 10 0 0.00 1.00 2 0 0 0.00
GIS_GPS_HIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_gps_his_data04.dbf 47 0 3.40 1.00 104 0 0 0.00
GIS_GPS_HIS_DATA +DATA_DM01/mcsdb/gis_datafiles/gis_gps_his_data05.dbf 29 0 2.76 1.00 50 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw01.dbf 574 0 0.44 1.01 3 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw02.dbf 525 0 0.53 1.01 2 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw03.dbf 3,678 1 0.19 1.00 311 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw04.dbf 559 0 0.36 1.01 5 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw05.dbf 399 0 0.25 1.00 7 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw06.dbf 382 0 0.39 1.03 10 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw07.dbf 388 0 0.39 1.03 4 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw08.dbf 457 0 0.37 1.01 28 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw09.dbf 386 0 0.36 1.15 2 0 0 0.00
IDX_MCSDW +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsdw10.dbf 396 0 0.33 1.00 2 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods01.dbf 482 0 0.62 1.00 160 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods02.dbf 622 0 0.79 1.00 159 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods03.dbf 469 0 0.66 1.00 164 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods04.dbf 524 0 0.82 1.00 60 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods05.dbf 569 0 0.93 1.00 73 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods06.dbf 678 0 0.72 1.00 29 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods07.dbf 738 0 0.72 1.00 143 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods08.dbf 643 0 1.18 1.00 208 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods09.dbf 515 0 0.78 1.00 291 0 0 0.00
IDX_MCSODS +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsods10.dbf 401 0 0.65 1.00 222 0 1 10.00
IDX_MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsstg01dbf 224 0 2.14 1.00 1,941 1 23 0.43
IDX_MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/idx_mcsstg02.dbf 13 0 3.85 1.00 2,392 1 1 0.00
INFO_BASE +DATA_DM01/mcsdb/midware_datafiles/info_base01.dbf 83 0 0.48 1.00 2,814 1 0 0.00
INFO_DATA +DATA_DM01/mcsdb/midware_datafiles/info_data01.dbf 603 0 2.21 1.00 1,336 0 11 0.00
INFO_DATA +DATA_DM01/mcsdb/midware_datafiles/info_data02.dbf 520 0 1.87 1.00 934 0 0 0.00
MAPINFO +DATA_DM01/mcsdb/gis_datafiles/mapinfo01.dbf 12 0 0.00 1.00 2 0 0 0.00
MCSAPP +DATA_DM01/mcsdb/mcs_datafiles/mcsapp01.dbf 25 0 0.40 1.00 19 0 0 0.00
MCSAPP +DATA_DM01/mcsdb/mcs_datafiles/mcsapp02.dbf 25 0 0.40 1.00 44 0 0 0.00
MCSAPP +DATA_DM01/mcsdb/mcs_datafiles/mcsapp03.dbf 23 0 0.87 1.00 12 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw01.dbf 387 0 0.54 2.35 77 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw02.dbf 594 0 0.93 2.08 86 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw03.dbf 294 0 2.45 3.22 49 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw04.dbf 178 0 1.35 4.68 32 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw05.dbf 3,270 1 0.36 1.52 24 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw06.dbf 2,767 1 0.64 1.64 156 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw07.dbf 175 0 4.80 5.37 97 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw08.dbf 113 0 6.28 7.88 44 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw09.dbf 187 0 1.02 4.32 181 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw10.dbf 81 0 1.98 8.38 30 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw11.dbf 655 0 0.73 1.82 89 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw12.dbf 443 0 0.68 2.22 95 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw13.dbf 223 0 1.48 3.91 54 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw14.dbf 190 0 1.26 4.58 25 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw15.dbf 228 0 1.01 3.88 44 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw16.dbf 816 0 0.92 1.81 84 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw17.dbf 920 0 0.66 1.71 487 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw18.dbf 868 0 0.75 1.75 361 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw19.dbf 647 0 0.82 2.01 174 0 0 0.00
MCSDW +DATA_DM01/mcsdb/mcs_datafiles/mcsdw20.dbf 595 0 0.72 1.87 258 0 0 0.00
MCSERP +DATA_DM01/mcsdb/mcs_datafiles/mcserp01.dbf 4,464 1 1.18 1.05 1,093 0 0 0.00
MCSERP +DATA_DM01/mcsdb/mcs_datafiles/mcserp02.dbf 5 0 0.00 1.00 232 0 0 0.00
MCSHTY_DATA +DATA_DM01/mcsdb/mcs_datafiles/mcshty_data01.dbf 2 0 0.00 1.00 2 0 0 0.00
MCSHTY_DATA +DATA_DM01/mcsdb/mcs_datafiles/mcshty_data02.dbf 2 0 0.00 1.00 2 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods01.dbf 200 0 6.75 44.63 840 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods02.dbf 261 0 4.90 30.89 146 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods03.dbf 173 0 8.32 45.73 115 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods04.dbf 305 0 3.84 23.80 982 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods05.dbf 325 0 3.72 21.30 739 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods06.dbf 319 0 4.51 19.75 1,170 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods07.dbf 317 0 3.60 18.37 1,244 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods08.dbf 351 0 2.93 14.63 1,237 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods09.dbf 328 0 3.11 14.82 1,192 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods10.dbf 321 0 3.24 18.00 1,191 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods11.dbf 281 0 3.59 20.33 1,111 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods12.dbf 272 0 4.60 20.97 1,056 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods13.dbf 160 0 6.88 37.55 814 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods14.dbf 177 0 5.88 32.19 93 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods15.dbf 314 0 3.54 21.00 80 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods16.dbf 186 0 6.51 36.13 43 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods17.dbf 269 0 3.94 25.21 801 0 0 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods18.dbf 192 0 7.29 37.04 549 0 18 0.56
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods19.dbf 1,366 0 1.82 7.21 829 0 1 0.00
MCSODS +DATA_DM01/mcsdb/mcs_datafiles/mcsods20.dbf 370 0 3.27 24.13 90 0 1 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg01.dbf 2,075 1 6.50 16.64 612 0 0 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg02.dbf 1,514 0 10.39 22.30 1,113 0 2 5.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg03.dbf 2,245 1 5.89 15.42 1,392 0 0 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg04.dbf 1,926 1 6.80 17.92 534 0 0 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg05.dbf 1,274 0 9.64 25.10 522 0 1 10.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg06.dbf 1,233 0 8.43 18.19 438 0 4 5.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg07.dbf 1,568 0 7.08 15.37 522 0 5 8.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg08.dbf 1,580 0 7.68 14.60 466 0 1 10.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg09.dbf 3,301 1 4.48 8.30 511 0 1 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg10.dbf 3,528 1 3.77 7.54 663 0 0 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg11.dbf 10,675 3 1.51 1.80 1,763 0 1 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg12dbf 4,139 1 2.05 2.89 1,571 0 1 10.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg13dbf 12,678 4 1.35 1.59 4,059 1 2 0.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg14.dbf 6,391 2 1.46 1.97 2,031 1 10 1.00
MCSSTG +DATA_DM01/mcsdb/mcs_datafiles/mcsstg15.dbf 10,632 3 1.35 1.68 3,404 1 8 1.25
MCSZEMN +DATA_DM01/mcsdb/mcs_datafiles/mcszemn01.dbf 231 0 0.52 1.00 2 0 178 4.38
MCSZEMN +DATA_DM01/mcsdb/mcs_datafiles/mcszemn02.dbf 3,308 1 0.57 1.00 86 0 164 1.71
MCSZEMN +DATA_DM01/mcsdb/mcs_datafiles/mcszemn03.dbf 140 0 1.07 1.00 5 0 180 2.22
OLTS_ATTRSTORE +DATA_DM01/mcsdb/datafile/olts_attrstore.380.801068881 12 0 0.00 1.00 2 0 0 0.00
OLTS_BATTRSTORE +DATA_DM01/mcsdb/datafile/olts_battrstore.368.801068877 10 0 0.00 1.00 2 0 0 0.00
OLTS_CT_STORE +DATA_DM01/mcsdb/datafile/olts_ct_store.415.801068895 12 0 0.00 1.00 2 0 0 0.00
OLTS_DEFAULT +DATA_DM01/mcsdb/datafile/olts_default.366.801068875 10 0 0.00 1.00 2 0 0 0.00
OLTS_SVRMGSTORE +DATA_DM01/mcsdb/datafile/olts_svrmgstore.412.801068895 12 0 0.00 1.00 2 0 0 0.00
OSBDB +DATA_DM01/mcsdb/midware_datafiles/osbdb.dbf 12 0 0.00 1.00 2 0 0 0.00
PORTAL +DATA_DM01/mcsdb/mcs_datafiles/portal01.dbf 13 0 0.77 1.00 8 0 0 0.00
SDYWY +DATA_DM01/mcsdb/ywy_datafiles/sdywy01.dbf 10 0 0.00 1.00 20 0 0 0.00
SDYWY +DATA_DM01/mcsdb/ywy_datafiles/sdywy02.dbf 10 0 0.00 1.00 22 0 0 0.00
SDYWY +DATA_DM01/mcsdb/ywy_datafiles/sdywy03.dbf 12 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATA_DM01/mcsdb/datafile/sysaux.265.800704881 304 0 0.95 1.03 1,010 0 0 0.00
SYSTEM +DATA_DM01/mcsdb/datafile/system.266.800704875 296 0 0.61 1.00 365 0 37 0.27
SYSTEM +DATA_DM01/mcsdb/datafile/system01.dbf 21 0 0.48 1.00 407 0 279 0.50
SYSTEM +DATA_DM01/mcsdb/datafile/system02.dbf 7 0 0.00 1.00 8 0 0 0.00
TEMP +DATA_DM01/mcsdb/tempfile/temp.257.800704891 1,680 0 0.00 1.00 1,680 0 0  
TYYW +DATA_DM01/mcsdb/tyyw_datafiles/tyyw01.dbf 10 0 0.00 1.00 2 0 0 0.00
TYYW +DATA_DM01/mcsdb/tyyw_datafiles/tyyw02.dbf 10 0 0.00 1.00 2 0 0 0.00
TYYW +DATA_DM01/mcsdb/tyyw_datafiles/tyyw03.dbf 10 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATA_DM01/mcsdb/datafile/undotbs1.258.800704885 2 0 0.00 1.00 41,672 12 63 0.16
UNDOTBS2 +DATA_DM01/mcsdb/datafile/undotbs2.264.800704897 2 0 0.00 1.00 2 0 0 0.00
USERS +DATA_DM01/mcsdb/datafile/users.263.800704903 2 0 0.00 1.00 2 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 4,215,411 99 57,027,400 594,642 852,320 0 0 1,018

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 819,126 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 300 16 28081 594714 3363297 27179064 3363297   10520 6
E 300 7 16257 194679 9068340 27179064 9068340   8250 2

Back to Advisory Statistics
Back to Top

MTTR Advisory

Size for Est (s) Dirty Limit Est Cache Writes Est Cache Write Fctr Est Total Writes Est Total Write Fctr Est Total IOs Est Total IO Fctr
30 37,690 774,576 1.73 1,042,539 1.46    
150 188,451 477,731 1.07 745,694 1.04    
300 376,902 447,394 1.00 715,357 1.00    
450 565,354 437,027 0.98 704,990 0.99    
687 863,107 428,493 0.96 696,456 0.97    

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 3,584 0.10 423 1.51 1,642,523 1 666808.00
D 7,168 0.20 846 1.23 1,342,187 1 460689.00
D 10,752 0.30 1,269 1.15 1,249,890 1 397346.00
D 14,336 0.40 1,692 1.10 1,193,399 1 358576.00
D 17,920 0.50 2,115 1.07 1,162,334 1 337257.00
D 21,504 0.60 2,538 1.05 1,139,524 1 321603.00
D 25,088 0.70 2,961 1.03 1,124,234 1 311109.00
D 28,672 0.80 3,384 1.02 1,110,545 1 301714.00
D 32,256 0.90 3,807 1.01 1,098,701 1 293586.00
D 35,840 1.00 4,231 1.00 1,087,689 1 286028.00
D 39,424 1.10 4,654 0.99 1,078,679 1 279845.00
D 43,008 1.20 5,077 0.98 1,070,672 1 274350.00
D 46,592 1.30 5,500 0.98 1,063,838 1 269659.00
D 50,176 1.40 5,923 0.97 1,056,854 1 264866.00
D 53,760 1.50 6,346 0.97 1,050,953 1 260816.00
D 57,344 1.60 6,769 0.96 1,045,009 1 256737.00
D 60,928 1.70 7,192 0.95 1,038,082 1 251983.00
D 64,512 1.80 7,615 0.95 1,029,259 1 245928.00
D 68,096 1.90 8,038 0.94 1,022,366 1 241198.00
D 71,680 2.00 8,461 0.93 1,009,799 1 232573.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 6,275 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 30,720 25,758 2,856.32 0.00 0.00 0.00 0.00 1,048,576
E 30,720 25,760 2,853.48 0.00 0.00 0.00 0.00 1,048,576

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 168,481 168,481 0 0
64K 128K 3,065 3,065 0 0
128K 256K 3,486 3,486 0 0
256K 512K 684 684 0 0
512K 1024K 1,494 1,494 0 0
1M 2M 273 273 0 0
2M 4M 9 9 0 0
4M 8M 70 70 0 0
8M 16M 4 4 0 0
16M 32M 11 11 0 0
32M 64M 41 41 0 0
64M 128M 4 4 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
3,840 0.13 22,357,560.06 2,193,943.10 91.00 0 5,547,801,382
7,680 0.25 22,357,560.06 2,002,444.12 92.00 0 5,504,529,151
15,360 0.50 22,357,560.06 2,001,651.36 92.00 0 5,504,350,015
23,040 0.75 22,357,560.06 2,001,651.36 92.00 0 5,504,350,015
30,720 1.00 22,357,560.06 1,972,054.67 92.00 0 5,497,662,173
36,864 1.20 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
43,008 1.40 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
49,152 1.60 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
55,296 1.80 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
61,440 2.00 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
92,160 3.00 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
122,880 4.00 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
184,320 6.00 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709
245,760 8.00 22,357,560.06 1,869,187.51 92.00 0 5,474,417,709

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)
7,424 0.57 252 55,399 22,533,949 0.49 23,971,697 358.80 371,121
8,832 0.68 1,658 96,350 29,098,417 0.63 17,407,229 260.55 969,932
10,240 0.78 3,059 158,183 36,026,391 0.78 10,479,255 156.85 1,599,308
11,648 0.89 4,467 219,392 42,716,394 0.92 3,789,252 56.72 2,214,797
11,776 0.90 4,595 226,231 43,173,885 0.93 3,331,761 49.87 2,259,993
11,904 0.91 4,723 234,036 43,628,742 0.94 2,876,904 43.06 2,304,735
12,032 0.92 4,851 242,128 44,062,702 0.95 2,442,944 36.57 2,346,038
12,160 0.93 4,979 250,220 44,486,885 0.96 2,018,761 30.22 2,386,583
12,288 0.94 5,107 257,374 44,864,456 0.97 1,641,190 24.57 2,421,526
12,416 0.95 5,235 263,937 45,188,356 0.97 1,317,290 19.72 2,450,248
12,544 0.96 5,363 269,817 45,512,057 0.98 993,589 14.87 2,478,955
12,672 0.97 5,491 274,810 45,810,248 0.99 695,398 10.41 2,506,134
12,800 0.98 5,619 279,803 46,097,611 0.99 408,035 6.11 2,531,782
12,928 0.99 5,747 284,796 46,384,709 1.00 120,937 1.81 2,557,293
13,056 1.00 5,875 290,330 46,438,836 1.00 66,810 1.00 2,562,223
13,184 1.01 6,003 297,344 46,438,929 1.00 66,717 1.00 2,562,241
13,312 1.02 6,131 304,358 46,438,957 1.00 66,689 1.00 2,562,245
13,440 1.03 6,259 311,372 46,438,979 1.00 66,667 1.00 2,562,248
13,568 1.04 6,387 317,750 46,438,994 1.00 66,652 1.00 2,562,252
13,696 1.05 6,514 323,147 46,439,010 1.00 66,636 1.00 2,562,255
13,824 1.06 6,641 328,544 46,439,031 1.00 66,615 1.00 2,562,258
13,952 1.07 6,768 333,941 46,439,049 1.00 66,597 1.00 2,562,261
14,080 1.08 6,895 339,338 46,439,074 1.00 66,572 1.00 2,562,265
14,208 1.09 7,022 344,735 46,439,101 1.00 66,545 1.00 2,562,268
14,464 1.11 7,277 355,529 46,439,139 1.00 66,507 1.00 2,562,274
15,872 1.22 8,685 421,658 46,439,317 1.00 66,329 0.99 2,562,303
17,280 1.32 10,093 501,010 46,439,437 1.00 66,209 0.99 2,562,327
18,688 1.43 11,501 575,461 46,439,536 1.00 66,110 0.99 2,562,346
20,096 1.54 12,909 655,075 46,439,621 1.00 66,025 0.99 2,562,364
21,504 1.65 14,317 734,689 46,439,695 1.00 65,951 0.99 2,562,381
22,912 1.75 15,725 814,303 46,439,795 1.00 65,851 0.99 2,562,398
24,320 1.86 17,133 893,917 46,439,876 1.00 65,770 0.98 2,562,413
25,728 1.97 18,541 973,531 46,439,951 1.00 65,695 0.98 2,562,427
27,136 2.08 19,949 1,053,145 46,440,022 1.00 65,624 0.98 2,562,441

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
12,800 0.25 26,815,864 1,656,223,614
19,200 0.38 2,850,435 1,656,223,614
25,600 0.50 2,580,267 1,260,304,920
32,000 0.63 2,520,175 1,172,093,365
38,400 0.75 2,494,069 1,133,589,184
44,800 0.88 2,476,584 1,107,919,730
51,200 1.00 2,462,792 1,087,688,720
57,600 1.13 2,456,881 1,079,639,823
64,000 1.25 2,447,276 1,065,717,408
70,400 1.38 2,439,395 1,053,752,832
76,800 1.50 2,428,559 1,037,872,577
83,200 1.63 2,415,260 1,018,185,411
89,600 1.75 2,414,768 1,018,185,411
96,000 1.88 2,414,275 1,018,185,411
102,400 2.00 2,414,275 1,018,185,411

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)
128 0.50 0 0 0 0
256 1.00 0 0 0 0
384 1.50 0 0 0 0
512 2.00 0 0 0 0
640 2.50 0 0 0 0
768 3.00 0 0 0 0
896 3.50 0 0 0 0
1,024 4.00 0 0 0 0
1,152 4.50 0 0 0 0
1,280 5.00 0 0 0 0
1,408 5.50 0 0 0 0
1,536 6.00 0 0 0 0
1,664 6.50 0 0 0 0
1,792 7.00 0 0 0 0
1,920 7.50 0 0 0 0
2,048 8.00 0 0 0 0
2,176 8.50 0 0 0 0
2,304 9.00 0 0 0 0
2,432 9.50 0 0 0 0
2,560 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 926 2 2
undo header 59 0 0
segment header 17 0 1
1st level bmb 4 0 3
file header block 8 0 0
undo block 4 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)
RO-Multiple Object Reuse (fast object reuse) 3,272 3,272 0 976 3 3.24
KO-Multiple Object Checkpoint (fast object checkpoint) 210 210 0 76 2 32.11
FB-Format Block 5,569 5,569 0 2,655 1 0.29
CF-Controlfile Transaction 8,651 8,647 4 400 0 0.63
PS-PX Process Reservation 2,750 2,750 0 438 0 0.21
TT-Tablespace 1,733 1,733 0 325 0 0.12
HW-Segment High Water Mark 3,577 3,577 0 98 0 0.41
TM-DML 106,837 106,833 3 130 0 0.08
TX-Transaction (index contention) 6 6 0 6 0 1.67
CR-Reuse Block Range (block range reuse ckpt) 32 32 0 4 0 2.50
TQ-Queue table enqueue (TM contention) 52 52 0 2 0 5.00
JQ-Job Queue 70 53 17 21 0 0.00
TA-Instance Undo 23 23 0 12 0 0.00
TD-KTF map table enqueue (KTF dump entries) 12 12 0 12 0 0.00
WF-AWR Flush 22 22 0 9 0 0.00
PD-Property Lock 8 8 0 3 0 0.00
DR-Distributed Recovery 2 2 0 2 0 0.00
AE-Edition Lock (lock) 6,514 6,514 0 1 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
DL-Direct Loader Index Creation 2 2 0 1 0 0.00
ST-Space Transaction 4 4 0 1 0 0.00
TO-Temp Object 1 1 0 1 0 0.00
TQ-Queue table enqueue (DDL contention) 2 2 0 1 0 0.00
TX-Transaction (row lock contention) 1 1 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
2 514.04 114,913 1,818 8 13058.5/13808.1 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
21-4月 02:54 32,703 5,299 1,335 5 13,409 0/0 0/0/0/0/0/0
21-4月 02:44 67,992 19,198 965 7 13,345 0/0 0/0/0/0/0/0
21-4月 02:34 324,320 50,784 1,779 8 13,058 0/0 0/0/0/0/0/0
21-4月 02:24 27,297 12,739 1,818 7 13,795 0/0 0/0/0/0/0/0
21-4月 02:14 27,815 13,727 1,697 6 13,808 0/0 0/0/0/0/0/0
21-4月 02:04 33,912 13,166 1,775 6 13,797 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 1 0.00   0 0  
AQ dequeue txn counter latch 3,704 0.00   0 0  
ASM Keyed state latch 13,197 0.30 0.00 0 0  
ASM allocation 1,312 0.00   0 0  
ASM db client latch 3,530 0.00   0 0  
ASM map headers 32 0.00   0 0  
ASM map load waiting list 8 0.00   0 0  
ASM map operation freelist 33,230 0.01 0.00 0 0  
ASM map operation hash table 1,935,910 0.03 0.00 0 0  
ASM network background latch 2,022 0.00   0 0  
ASM network state latch 1,005 0.00   0 0  
AWR Alerted Metric Element list 96,952 0.00   0 0  
Change Notification Hash table latch 1,194 0.00   0 0  
Consistent RBA 70,631 0.00 0.00 0 0  
DML lock allocation 7,927,877 0.00 0.00 0 0  
Event Group Locks 13,646 0.01 0.00 0 0  
FAL Queue 98 0.00   0 0  
FIB s.o chain latch 8 0.00   0 0  
FOB s.o list latch 144,608 0.24 0.00 0 0  
File State Object Pool Parent Latch 1 0.00   0 0  
I/O Staticstics latch 1 0.00   0 0  
IPC other latch 31 0.00   0 0  
IPC stats buffer allocation latch 21,355 0.00   0 21,326 0.15
In memory undo latch 1 0.00   0 0  
JS Sh mem access 9 0.00   0 0  
JS broadcast add buf latch 825 0.00   0 0  
JS broadcast drop buf latch 825 0.00   0 0  
JS broadcast load blnc latch 723 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 9 0.00   0 0  
JS queue state obj latch 21,704 0.00   0 0  
JS slv state obj latch 243 0.00   0 0  
KFC FX Hash Latch 1 0.00   0 0  
KFC Hash Latch 1 0.00   0 0  
KFCL LE Freelist 1 0.00   0 0  
KFK SGA Libload latch 15,246 0.00   0 0  
KFMD SGA 6,380 0.00   0 0  
KGNFS-NFS:SHM structure 1 0.00   0 0  
KGNFS-NFS:SVR LIST 1 0.00   0 0  
KJC message pool free list 90,728 0.30 0.02 0 18,042 0.01
KJCT flow control latch 968,876 0.04 0.00 0 0  
KMG MMAN ready and startup request latch 1,196 0.00   0 0  
KSXR large replies 542 0.00   0 0  
KTF sga latch 36 0.00   0 1,207 0.00
KWQMN job cache list latch 505 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
KWQS pqsubs latch 5 0.00   0 0  
KWQS pqueue ctx latch 605 0.00   0 0  
Locator state objects pool parent latch 1 0.00   0 0  
Lsod array latch 89,028 0.61 0.30 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1 0.00   0 1,196 0.00
Memory Queue 1 0.00   0 0  
Memory Queue Message Subscriber #1 1 0.00   0 0  
Memory Queue Message Subscriber #2 1 0.00   0 0  
Memory Queue Message Subscriber #3 1 0.00   0 0  
Memory Queue Message Subscriber #4 1 0.00   0 0  
Memory Queue Subscriber 1 0.00   0 0  
MinActiveScn Latch 2,463 0.04 0.00 0 0  
Mutex 1 0.00   0 0  
Mutex Stats 1 0.00   0 0  
OS process 27,163 0.00   0 0  
OS process allocation 20,944 0.28 0.00 0 0  
OS process: request allocation 13,196 0.42 0.00 0 0  
PL/SQL warning settings 26,833 0.00   0 0  
PX hash array latch 1 0.00   0 0  
QMT 1 0.00   0 0  
Real-time plan statistics latch 22,776 0.00   0 0  
Reserved Space Latch 4 0.00   0 0  
SGA IO buffer pool latch 330 0.00   0 330 0.00
SGA blob parent 1 0.00   0 0  
SGA bucket locks 1 0.00   0 0  
SGA heap locks 1 0.00   0 0  
SGA pool locks 1 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,190 0.00
SQL memory manager workarea list latch 176,374 0.00   0 0  
Shared B-Tree 1,145 0.00   0 0  
Streams Generic 1 0.00   0 0  
Testing 1 0.00   0 0  
Token Manager 1 0.00   0 0  
WCR: sync 1 0.00   0 0  
Write State Object Pool Parent Latch 1 0.00   0 0  
X$KSFQP 51 0.00   0 0  
XDB NFS Security Latch 1 0.00   0 0  
XDB unused session pool 1 0.00   0 0  
XDB used session pool 1 0.00   0 0  
active checkpoint queue latch 151,544 0.88 0.00 0 0  
active service list 58,747 0.07 0.00 0 5,151 0.02
alert log latch 2 0.00   0 0  
archive control 187 0.00   0 0  
archive process latch 295 0.00   0 0  
begin backup scn array 4 0.00   0 0  
buffer pool 1 0.00   0 0  
business card 789 0.00   0 0  
cache buffer handles 2,762,874 0.00 0.00 0 0  
cache buffers chains 143,037,638 0.02 0.00 0 9,511,977 0.16
cache buffers lru chain 1,461,361 0.02 0.01 0 3,647,660 0.01
cache table scan latch 4,708 0.00   0 4,708 0.00
call allocation 28,379 0.23 0.00 0 0  
cas latch 1 0.00   0 0  
change notification client cache latch 1 0.00   0 0  
channel handle pool latch 13,657 0.12 0.00 0 0  
channel operations parent latch 1,513,464 0.00 0.02 0 0  
checkpoint queue latch 5,725,439 0.01 0.00 0 879,688 0.00
client/application info 49,195 0.00 0.00 0 0  
compile environment latch 7,051 0.01 0.00 0 0  
corrupted undo seg latch 630 0.16 0.00 0 0  
cp cmon/server latch 1 0.00   0 0  
cp pool latch 1 0.00   0 0  
cp server hash latch 1 0.00   0 0  
cp sga latch 57 0.00   0 0  
cvmap freelist lock 1 0.00   0 0  
database property service latch 16 0.00   0 0  
deferred cleanup latch 57 0.00   0 0  
dml lock allocation 61 0.00   0 0  
done queue latch 1 0.00   0 0  
dummy allocation 14,113 0.19 0.00 0 0  
enqueue freelist latch 1 0.00   0 260,152 0.00
enqueue hash chains 970,530 0.03 0.01 0 7 0.00
enqueues 2 0.00   0 0  
error message lists 1,958 0.00   0 0  
fifth spare latch 1 0.00   0 0  
file cache latch 5,302 0.00   0 0  
flashback copy 1 0.00   0 0  
fourth Audit Vault latch 1 0.00   0 0  
gc element 4,308,882 0.04 0.01 0 117,512 0.01
gc persistent rm 24 0.00   0 0  
gcs commit scn state 1 0.00   0 0  
gcs opaque info freelist 418,035 0.31 0.00 0 0  
gcs partitioned table hash 50,776,260 0.49 0.00 0 809,135 0.00
gcs pcm hashed value bucket hash 1 0.00   0 0  
gcs remaster request queue 1,783 0.00   0 0  
gcs remastering latch 16,711,441 6.10 0.00 0 840 6.79
gcs resource freelist 591,475 0.00 0.00 0 632,278 0.00
gcs resource hash 67,709,390 0.00 0.00 0 5 0.00
gcs resource scan list 13 0.00   0 0  
gcs shadows freelist 282,742 0.00   0 483,537 0.00
ges caches resource lists 232,773 0.01 0.05 0 98,896 0.01
ges deadlock list 7,712 0.00   0 0  
ges domain table 748,682 0.00 0.00 0 0  
ges enqueue table freelist 849,823 0.00 0.00 0 0  
ges group table 765,085 0.00 0.00 0 0  
ges process hash list 281,768 0.00 0.00 0 0  
ges process parent latch 1,690,796 0.00 0.00 0 0  
ges process table freelist 13,196 0.30 0.00 0 0  
ges resource hash list 1,659,119 0.07 0.05 0 28,056 0.00
ges resource scan list 1,905 0.00   0 0  
ges resource table freelist 51,082 0.01 0.00 0 0  
ges timeout list 5,544 0.00   0 614 0.00
ges value block free list 23,341 0.00   0 0  
global KZLD latch for mem in SGA 6,441 0.02 0.00 0 0  
global tx hash mapping 13,938 0.00   0 0  
granule operation 1 0.00   0 0  
hash table column usage latch 673 0.00   0 639,723 0.02
hash table modification latch 226 0.00   0 0  
heartbeat check 1 0.00   0 1,018 0.00
heartbeat structure management 0     0 717 0.00
internal temp table object number allocation latch 15 0.00   0 0  
interrupt manipulation 3,626 0.00   0 0  
intra txn parallel recovery 1 0.00   0 0  
io pool granule metadata list 1 0.00   0 0  
job workq parent latch 72 0.00   0 71 1.41
job_queue_processes free list latch 144 0.00   0 0  
job_queue_processes parameter latch 836 0.00   0 0  
k2q global data latch 7,511 0.00   0 0  
k2q lock allocation 15,205 0.00   0 0  
kcbtsemkid latch 1 0.00   0 0  
kcfis latch 437 0.00   0 0  
kdlx hb parent latch 1 0.00   0 0  
kgb parent 1 0.00   0 0  
kgnfs mount latch 1 0.00   0 0  
kokc descriptor allocation latch 344 0.00   0 0  
krbmrosl 2 0.00   0 0  
ksbxic instance latch 985 0.00   0 0  
ksfv messages 1 0.00   0 0  
ksim group membership cache 1,069 0.00   0 0  
ksim membership request latch 0     0 2,362 0.00
kss move lock 69 0.00   0 0  
ksuosstats global area 505 0.00   0 0  
ksv allocation latch 197 0.00   0 0  
ksv class latch 10,859 0.00   0 0  
ksv instance latch 24 0.00   0 0  
ksv msg queue latch 11 0.00   0 10 0.00
ksxp shared latch 13,196 0.23 0.00 0 0  
ksxp so latch 13,196 0.20 0.00 0 0  
ksz_so allocation latch 14,268 0.32 0.00 0 0  
ktm global data 2,056 0.00   0 0  
kwqbsn:qsga 347 0.00   0 0  
lgwr LWN SCN 71,463 0.44 0.00 0 0  
list of block allocation 230,400 0.00 0.00 0 0  
loader state object freelist 10,322 0.00   0 0  
lob segment dispenser latch 1 0.00   0 0  
lob segment hash table latch 13 0.00   0 0  
lob segment query latch 1 0.00   0 0  
lock DBA buffer during media recovery 1 0.00   0 0  
logical standby cache 1 0.00   0 0  
logminer context allocation 2 0.00   0 0  
logminer work area 1 0.00   0 0  
longop free list parent 102 0.00   0 17 0.00
managed standby latch 97 0.00   0 0  
mapped buffers lru chain 1 0.00   0 0  
message pool operations parent latch 9,564 0.00   0 0  
messages 891,690 0.32 0.00 0 0  
mostly latch-free SCN 73,404 1.50 0.00 0 0  
msg queue latch 1 0.00   0 0  
multiblock read objects 37,724 0.01 0.00 0 0  
name-service memory objects 23,094 0.00   0 0  
name-service namespace bucket 32,864 0.00   0 0  
name-service pending queue 11,680 0.00   0 0  
name-service request queue 49,813 0.00   0 0  
ncodef allocation latch 57 0.00   0 0  
object queue header heap 15,828 0.00   0 12,212 0.00
object queue header operation 7,053,753 0.03 0.08 0 0  
object stats modification 2,940 0.17 0.00 0 0  
parallel query alloc buffer 8,401 0.00   0 0  
parallel query stats 1,587 0.00   0 0  
parallel txn reco latch 1,702 0.00   0 0  
parameter list 59,080 0.15 0.00 0 0  
parameter table management 112,401 0.02 0.00 0 0  
peshm 1 0.00   0 0  
pesom_free_list 1 0.00   0 0  
pesom_hash_node 1 0.00   0 0  
post/wait queue 167,233 0.22 0.00 0 138,746 0.12
process allocation 30,663 0.49 0.40 0 6,523 1.07
process group creation 13,196 0.01 0.00 0 0  
process queue 4,347 0.00   0 0  
process queue reference 70,040 0.00 0.00 0 6,844 0.01
qmn state object latch 5 0.00   0 0  
qmn task context latch 3 0.00   0 0  
qmn task queue latch 533 0.00   0 0  
query server freelists 3,555 0.00   0 0  
query server process 388 0.00   0 0  
queued dump request 12 0.00   0 0  
queuing load statistics 1 0.00   0 0  
recovery domain hash list 1 0.00   0 0  
redo allocation 221,647 0.68 0.00 0 11,587,309 0.05
redo copy 1 0.00   0 11,589,574 0.16
redo writing 371,793 0.28 0.00 0 0  
reid allocation latch 1,072 0.00   0 0  
reservation so alloc latch 2 0.00   0 0  
resmgr group change latch 6,958 0.00   0 0  
resmgr:active threads 14,160 0.00   0 0  
resmgr:actses change group 6,934 0.00   0 0  
resmgr:actses change state 1 0.00   0 0  
resmgr:free threads list 14,113 0.22 0.00 0 0  
resmgr:plan CPU method 1 0.00   0 0  
resmgr:resource group CPU method 1 0.00   0 0  
resmgr:schema config 129 0.00   0 0  
resmgr:session queuing 1 0.00   0 0  
rm cas latch 1 0.00   0 0  
row cache objects 1,965,587 0.33 0.00 0 130 0.00
rules engine rule set statistics 100 0.00   0 0  
second Audit Vault latch 1 0.00   0 0  
second spare latch 1 0.00   0 0  
segmented array pool 8 0.00   0 0  
sequence cache 123,429 0.05 0.00 0 0  
session allocation 204,231 0.00 0.00 0 190,176 0.00
session idle bit 17,160,287 0.00 0.00 0 0  
session queue latch 1 0.00   0 0  
session state list latch 1,504 0.00   0 0  
session switching 6,661 0.03 0.00 0 0  
session timer 1,194 0.00   0 0  
shared pool 4,743,871 0.02 0.01 0 153 0.00
shared pool sim alloc 118 0.00   0 0  
shared pool simulator 9,243 0.09 0.00 0 0  
sim partition latch 2 0.00   0 5,689 0.02
simulator hash latch 4,220,012 0.00 0.00 0 0  
simulator lru latch 1 0.00   0 4,038,013 0.02
sort extent pool 1,010 0.00   0 0  
space background state object latch 37 0.00   0 0  
space background task latch 15,528 7.50 0.40 0 2,510 0.12
state object free list 12 0.00   0 0  
statistics aggregation 336 0.00   0 0  
storage server table manipulation latch 976 0.00   0 0  
tablespace key chain 12 0.00   0 0  
temp lob duration state obj allocation 6 0.00   0 0  
test excl. parent l0 1 0.00   0 0  
test excl. parent2 l0 1 0.00   0 0  
third spare latch 1 0.00   0 0  
threshold alerts latch 1,235 0.00   0 0  
transaction allocation 1,931,442 0.00   0 0  
transaction branch allocation 11,330 0.00   0 0  
undo global data 1,122,716 0.00 0.00 0 0  
virtual circuit buffers 1 0.00   0 0  
virtual circuit holder 1 0.00   0 0  
virtual circuit queues 1 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 143,037,638 27,010 90 26,921
row cache objects 1,965,587 6,470 3 6,467
gcs resource hash 67,709,390 2,483 8 2,476
object queue header operation 7,053,753 1,778 140 1,638
gc element 4,308,882 1,771 9 1,762
space background task latch 15,528 1,164 466 698
ges resource hash list 1,659,119 1,092 51 1,041
shared pool 4,743,871 714 9 705
Lsod array latch 89,028 542 160 386
enqueue hash chains 970,530 304 2 302
KJC message pool free list 90,728 271 5 266
cache buffers lru chain 1,461,361 247 3 244
process allocation 30,663 151 60 91
channel operations parent latch 1,513,464 56 1 55
ges caches resource lists 232,773 22 1 21

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 4 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 5
Lsod array latch kfklsodtablCleanup 0 160 159
PC and Classifier lists for WLM No latch 0 11 0
active service list kswslogon: session logout 0 2 0
cache buffers chains kcbgcur_2 0 30 22
cache buffers chains kcbgtcr: fast path 0 25 3
cache buffers chains kcbgtcr: fast path (cr pin) 0 24 17
cache buffers chains kcbgtcr: kslbegin excl 0 8 12
cache buffers chains kcbbxsv 0 2 1
cache buffers chains kcbgtcr_2 0 2 3
cache buffers chains kcllkopesc 0 2 0
cache buffers chains kcbchg1: mod cr pin 0 1 1
cache buffers chains kcbget: fast exchange 0 1 1
cache buffers chains kcbgtcr: kslbegin shared 0 1 1
cache buffers chains kcbrls_2 0 1 2
cache buffers chains kcbzwb 0 1 2
cache buffers lru chain kcbzgb_2 0 2 1
cache buffers lru chain kcbzgws 0 1 0
channel operations parent latch ksrpubwait():1 0 1 0
enqueue hash chains ksqgtl3 0 2 1
gc element kclnfndnewm 0 11 3
gc element kclbla 0 4 0
gc element kclchkping 0 1 0
gcs resource hash kjbassume 0 4 0
gcs resource hash kclrwrite 0 2 0
gcs resource hash kclfwrite1 0 1 1
gcs resource hash kjbconvert 0 1 0
ges resource hash list kjrmas1: lookup master node 0 43 11
ges resource hash list kjakcai: search for resp by resname 0 4 2
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 3 0
ges resource hash list kjakoca: search for resp by resname 0 1 8
ges resource table freelist kjrchc2: cached obj cleanup 0 1 0
object queue header operation kclobj_5 0 130 0
object queue header operation kcbo_switch_mq_bg 0 3 21
object queue header operation kclobj_1 0 3 0
object queue header operation kcbo_switch_q_bg 0 2 15
object queue header operation kcbo_unlink_q 0 2 89
object queue header operation kcbo_link_q 0 1 9
process allocation ksucrp:1 0 54 0
process allocation ksufap: active procs 0 4 0
process allocation ksudlp 0 2 0
row cache objects kqreqd 0 1 2
row cache objects kqreqd: reget 0 1 0
row cache objects kqrpre: find obj 0 1 1
shared pool kghalo 0 8 4
shared pool kghalp 0 1 2
space background task latch ktsj_grab_task 0 455 466

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex Type Location Sleeps Wait Time (ms)
Library Cache kglhdgn1 62 377 0
Library Cache kgllkc1 57 156 0
Library Cache kglpnal2 91 135 0
Library Cache kglhdgn2 106 82 0
Library Cache kgllkdl1 85 62 0
Library Cache kglpin1 4 53 0
Library Cache kglpndl1 95 31 0
Cursor Pin kkslce [KKSCHLPIN2] 19 0
Library Cache kglget1 1 14 0
Library Cache kglpnal1 90 14 0
Library Cache kglhdgh1 64 13 0
Library Cache kgllkal1 80 10 0
Library Cache kgldtin1 42 9 0
Library Cache kglobpn1 71 7 0
Library Cache kglget2 2 4 0
Cursor Pin kksfbc [KKSCHLPIN1] 2 0
Library Cache kglobld1 75 1 0
Library Cache kglrfcl1 79 1 0
Cursor Pin kksLockDelete [KKSCHLPIN6] 1 0
Cursor Parent kkscsAddChildNode [KKSPRTLOC34] 1 0
Cursor Pin kksfbc [KKSCHLFSP2] 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
MCSSTG MCSSTG PK_MANDT_VBELN_POSNR_PARVW   INDEX 14,214,656 22.15
MCSODS MCSODS FCT_SELL_DAY_END   TABLE 4,935,712 7.69
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 4,493,024 7.00
MCSSTG ALL_IDX IDX_TSKUGTPLU_WEBPOS   INDEX 3,917,808 6.10
MCSSTG ALL_IDX PK_TSKUGTPLU   INDEX 3,812,912 5.94

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
MCSODS MCSODS FCT_SALE_COMM_MAS   TABLE 2,271,758 29.22
MCSSTG MCSSTG SAP_VBFA_HIS   TABLE 1,163,902 14.97
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 1,010,230 13.00
MCSODS MCSODS FCT_SALE   TABLE 999,926 12.86
MCSSTG MCSSTG SAP_MSKU_HIS   TABLE 639,473 8.23

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
MCSERP ALL_IDX PK_MATNR_LGORT_WERKS_CHARG   INDEX 80,155 31.08
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 43,397 16.83
MCSODS MCSODS FCT_SALE_COMM_MAS   TABLE 19,521 7.57
MCSODS MCSODS FCT_PROCURE   TABLE 13,014 5.05
MCSSTG MCSSTG SAP_VBFA_HIS   TABLE 9,166 3.55

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total
MCSODS MCSODS FCT_SALE_COMM_MAS   TABLE 18,986 28.86
MCSODS MCSODS FCT_PROCURE   TABLE 12,996 19.75
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 11,995 18.23
MCSSTG MCSSTG SAP_VBFA_HIS   TABLE 9,154 13.91
MCSERP ALL_IDX PK_MATNR_LGORT_WERKS_CHARG   INDEX 8,850 13.45

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Optimized Reads %Total
MCSERP ALL_IDX PK_MATNR_LGORT_WERKS_CHARG   INDEX 71,305 37.11
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 31,402 16.34
MCSDW MCSDW FYP_FCT_SALE   TABLE 7,866 4.09
MCSSTG MCSSTG SAP_MSKU_HIS   TABLE 5,011 2.61
MCSSTG MCSSTG PK_TSALSALEPAYYYYYMM   INDEX 4,423 2.30

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Reads %Total
MCSODS MCSODS FCT_SALE_COMM_MAS   TABLE 2,271,168 31.64
MCSSTG MCSSTG SAP_VBFA_HIS   TABLE 1,163,891 16.21
MCSODS MCSODS FCT_SALE   TABLE 999,916 13.93
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 975,162 13.58
MCSSTG MCSSTG SAP_MSKU_HIS   TABLE 639,428 8.91

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total
MCSERP ALL_IDX PK_MATNR_LGORT_WERKS_CHARG   INDEX 80,791 9.46
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 70,682 8.27
MCSODS MCSODS COMM_ABNORMAL_DATA   TABLE 23,658 2.77
MCSSTG MCSSTG NOLB_TSKUGTPLU   TABLE 22,385 2.62
MCSSTG ALL_IDX IDX_TSKUGTPLU_WEBPOS   INDEX 14,233 1.67

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
MCSODS MCSODS COMM_ABNORMAL_DATA   TABLE 13,079 9.87
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 8,525 6.44
MCSERP ALL_IDX PK_MATNR_LGORT_WERKS_CHARG   INDEX 7,568 5.71
MCSSTG ALL_IDX IDX_ACCEPT_GSMHM   INDEX 6,925 5.23
MCSSTG IDX_MCSSTG IDX_GPS_ACCE_GSMHM SYS_P1343 INDEX PARTITION 3,700 2.79

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total
MCSODS MCSODS FCT_SALE   TABLE 2 3.23
MCSZEMN ALL_IDX PK_STNID_SFDAT_MATNR2   INDEX 2 3.23
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 2 3.23
MCSODS MCSODS FCT_SALE_COMM_MAS   TABLE 1 1.61
MCSODS MCSODS FCT_SELL_DAY_END   TABLE 1 1.61

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
MCSSTG MCSSTG SAP_VBPA_HIS   TABLE 3,506,560 34.28
MCSSTG ALL_IDX IDX_TSKUGTPLU_WEBPOS   INDEX 1,410,256 13.79
MCSSTG ALL_IDX PK_TSKUGTPLU   INDEX 1,361,552 13.31
MCSSTG ALL_IDX IDX_TSKUGTPLU_PLUID   INDEX 1,329,648 13.00
MCSODS MCSODS COMM_ABNORMAL_DATA   TABLE 521,808 5.10

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
MCSPCRS ALL_IDX IDX_OPB_PERF_COUNT_WORKID   INDEX 2 50.00
MCSPCRS ALL_IDX IDX_OPB_DTL_SWIDG_RUNID   INDEX 1 25.00
DEV5_OIM DEV5_OIM QRTZ92_LOCKS   TABLE 1 25.00

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
SYS SYSTEM AUD$   TABLE 153 85.47
SYS SYSTEM SEG$   TABLE 12 6.70
MCSPCRS ALL_IDX OPB_PF_COUNT_IDX2   INDEX 2 1.12
MCSPCRS ALL_IDX OPB_TINSTLG_IDX2   INDEX 2 1.12
MCSPCRS INFO_DATA OPB_WFLOW_PERVAL   TABLE 2 1.12

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
MCSZEMN MCSZEMN STA_IM_EMPLOYEE_SALARY   TABLE 519 74.36
SYS SYSTEM AUD$   TABLE 140 20.06
MCSSTG MCSSTG TANK_GPS_YYYYMMDD SYS_P1343 TABLE PARTITION 16 2.29
MCSPCRS ALL_IDX OPB_TINSTLG_IDX2   INDEX 8 1.15
SYS SYSTEM SEG$   TABLE 8 1.15

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
MCSZEMN MCSZEMN STA_IM_EMPLOYEE_SALARY   TABLE 34,808 29.04
MCSODS MCSODS FCT_SELL_DAY_END   TABLE 23,641 19.72
MCSSTG MCSSTG NOLB_TETPSUPPLIER   TABLE 9,467 7.90
MCSZEMN MCSZEMN FCT_IM_OIL_DENSITY   TABLE 7,443 6.21
MCSPCRS INFO_DATA OPB_TASK_INST_RUN   TABLE 3,850 3.21

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
MCSZEMN MCSZEMN STA_IM_EMPLOYEE_SALARY   TABLE 34,808 12.85
MCSSTG MCSSTG SAP_ILOA   TABLE 30,484 11.25
MCSODS MCSODS COMM_ABNORMAL_DATA   TABLE 23,224 8.57
MCSSTG MCSSTG PK_MANDT_VBELN_POSNR_PARVW   INDEX 19,652 7.25
MCSODS MCSODS FCT_CHECK   TABLE 19,197 7.09

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 64 1.56 0   1 1
dc_files 198 0.00 0   0 198
dc_global_oids 820 0.12 0   0 128
dc_histogram_data 122,676 0.26 0   0 24,176
dc_histogram_defs 73,119 0.78 0   2 26,644
dc_object_grants 571 0.00 0   0 141
dc_objects 91,019 0.43 0   186 9,532
dc_profiles 6,496 0.00 0   0 1
dc_rollback_segments 8,307 0.00 0   0 76
dc_segments 38,992 0.64 0   1,433 4,741
dc_sequences 1,329 0.38 0   1,329 16
dc_tablespaces 104,304 0.00 0   0 148
dc_users 315,216 0.00 0   0 243
global database name 10,849 0.00 0   0 2
outstanding_alerts 580 99.31 0   0 98
sch_lj_oids 5 0.00 0   0 16

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache GES Requests GES Conflicts GES Releases
dc_awr_control 3 1 0
dc_global_oids 1 0 0
dc_histogram_defs 568 0 232
dc_objects 888 165 4
dc_segments 3,179 210 0
dc_sequences 2,658 8 0
outstanding_alerts 1,152 576 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 12,878 -0.02 0   0 0
BODY 3,795 0.05 6,074 0.10 4 0
CLUSTER 44 0.00 44 0.00 0 0
DBLINK 12,884 0.00 0   0 0
DIRECTORY 1 0.00 1 0.00 0 0
EDITION 6,510 0.00 13,004 0.00 0 0
INDEX 1,226 1.96 1,226 4.89 36 0
OBJECT ID 1 100.00 0   0 0
QUEUE 881 0.00 2,523 0.00 0 0
SCHEMA 6,525 0.00 0   0 0
SQL AREA 247,919 0.48 5,362,084 0.15 1,930 493
SQL AREA BUILD 3,271 80.80 0   0 0
SQL AREA STATS 3,330 54.56 3,329 54.55 0 0
SUBSCRIPTION 18 0.00 18 0.00 0 0
TABLE/PROCEDURE 39,430 0.03 102,398 0.78 425 0
TRANSFORMATION 359 0.00 359 0.00 0 0
TRIGGER 576 0.00 30,014 0.00 0 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 12,881 0 0 0 0
BODY 0 5,975 5,975 0 0
CLUSTER 44 44 44 0 0
DBLINK 12,884 0 0 0 0
DIRECTORY 0 1 1 0 0
EDITION 6,510 6,510 6,510 0 0
INDEX 1,226 1,225 1,225 0 0
QUEUE 424 2,523 2,523 0 0
SCHEMA 6,496 0 0 0 0
SUBSCRIPTION 0 18 18 0 0
TABLE/PROCEDURE 43,776 84,405 84,405 0 0
TRANSFORMATION 359 359 359 0 0
TRIGGER 0 30,014 30,014 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 35,712.00 35,712.00 35,712.00 37,504.00 0 SHR/IMM
KEEP buffer cache 0.00 0.00 0.00 0.00 0 STA/
PGA Target 30,720.00 30,720.00 30,720.00 30,720.00 0 STA/
RECYCLE buffer cache 0.00 0.00 0.00 0.00 0 STA/
SGA Target 51,200.00 51,200.00 51,200.00 51,200.00 0 STA/
Shared IO Pool 256.00 256.00 256.00 256.00 0 STA/
java pool 1,280.00 1,280.00 1,280.00 1,280.00 0 STA/
large pool 256.00 256.00 256.00 256.00 0 STA/
shared pool 13,056.00 13,056.00 11,264.00 13,056.00 0 GRO/IMM
streams pool 256.00 256.00 256.00 256.00 0 STA/

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 2,481.71   2.08 4.35 78 78 1,195 1,195
Freeable 296.56 0.00 1.09 1.79 17   271 271
PL/SQL 43.92 7.56 0.04 0.16 2 2 1,147 1,107
SQL 32.97 1.56 0.03 0.09 1 1,926 1,079 1,052
E Other 2,477.06   2.08 4.36 78 78 1,190 1,190
Freeable 297.69 0.00 1.08 1.77 17   275 275
PL/SQL 43.95 7.58 0.04 0.16 2 2 1,142 1,102
SQL 36.67 5.42 0.03 0.15 4 1,926 1,077 1,049

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 37,715,181,568  
Fixed Size 2,240,984  
Redo Buffers 160,722,944  
Variable Size 15,569,260,072  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 1,280.00 1,280.00 0.00
large PX msg pool 58.50 58.50 0.00
large free memory 197.13 197.13 0.00
shared KGLH0 1,971.80 1,985.88 0.71
shared KGLHD 285.47 287.67 0.77
shared SQLA 4,749.66 4,771.96 0.47
shared db_block_hash_buckets 356.00 356.00 0.00
shared free memory 1,976.40 1,930.67 -2.31
shared gcs resources 980.83 980.83 0.00
shared gcs shadows 572.15 572.15 0.00
shared kglsim heap 326.98 327.13 0.05
shared kglsim object batch 623.77 624.05 0.05
streams free memory 256.00 256.00 0.00
  buffer_cache 35,712.00 35,712.00 0.00
  fixed_sga 2.14 2.14 0.00
  log_buffer 153.28 153.28 0.00
  shared_io_pool 256.00 256.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 Slaves 0208 20:14:53 0.12 0.00 0.00
QMON Coordinator 0208 20:14:53 0.08 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

Queue Name Enq Msgs Deq Msgs %Exp Msgs %Delay Msgs Enq Time(s) Deq Time(s) %Transf Time %Eval Time
SYS.ALERT_QUE(12741) 0 0     0.00 0.00    
SYS.AQ$_ALERT_QT_E(12740) 2 0 0.00 0.00 0.00 0.00 0.00 0.00
SYSMAN.MGMT_TASK_Q(15985) 61 61 0.00 0.00 0.01 0.07 0.00 0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue Name Enqueue Msgs/sec Dequeue Msgs/sec Avg Enqueue sec / msg Avg Dequeue sec / msg
SYS.ALERT_QUE(12741) 0.00 0.00    
SYS.AQ$_ALERT_QT_E(12740) 0.00 0.00 0.00  
SYSMAN.MGMT_TASK_Q(15985) 0.02 0.02 0.00 0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/Queue Enqueue Msgs Dequeue Msgs Expire Msgs Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec
DM01DB01_MCSD_3938_MCSDB1(22)/SYS.ALERT_QUE 0 0 0 0.00 0.00 0.00
DM01DB02_MCSD_3938_MCSDB2(42)/SYS.ALERT_QUE 0 0 2 0.00 0.00 0.00
HAE_SUB(1)/SYS.ALERT_QUE 0 0 0      

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 0 0 0 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

No data exists for this section of the report.

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

No data exists for this section of the report.

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)
_aggregation_optimization_settings 0   
_always_anti_join CHOOSE   
_always_semi_join CHOOSE   
_and_pruning_enabled TRUE   
_b_tree_bitmap_plans TRUE   
_bloom_filter_enabled TRUE   
_bloom_folding_enabled TRUE   
_bloom_pruning_enabled TRUE   
_complex_view_merging TRUE   
_compression_compatibility 11.2.0.3.0   
_connect_by_use_union_all TRUE   
_convert_set_to_join FALSE   
_cost_equality_semi_join TRUE   
_cpu_to_io 0   
_dimension_skip_null TRUE   
_eliminate_common_subexpr TRUE   
_enable_NUMA_support FALSE   
_enable_type_dep_selectivity TRUE   
_fast_full_scan_enabled TRUE   
_file_size_increase_increment 2143289344   
_first_k_rows_dynamic_proration TRUE   
_gby_hash_aggregation_enabled TRUE   
_generalized_pruning_enabled TRUE   
_globalindex_pnum_filter_enabled TRUE   
_gs_anti_semi_join_allowed TRUE   
_improved_outerjoin_card TRUE   
_improved_row_length_enabled TRUE   
_index_join_enabled TRUE   
_ksb_restart_policy_times 0, 60, 120, 240   
_left_nested_loops_random TRUE   
_local_communication_costing_enabled TRUE   
_minimal_stats_aggregation TRUE   
_mmv_query_rewrite_enabled TRUE   
_new_initial_join_orders TRUE   
_new_sort_cost_estimate TRUE   
_nlj_batching_enabled 1   
_optim_adjust_for_part_skews TRUE   
_optim_enhance_nnull_detection TRUE   
_optim_new_default_join_sel TRUE   
_optim_peek_user_binds TRUE   
_optimizer_adaptive_cursor_sharing TRUE   
_optimizer_better_inlist_costing ALL   
_optimizer_cbqt_no_size_restriction TRUE   
_optimizer_coalesce_subqueries TRUE   
_optimizer_complex_pred_selectivity TRUE   
_optimizer_compute_index_stats TRUE   
_optimizer_connect_by_combine_sw TRUE   
_optimizer_connect_by_cost_based TRUE   
_optimizer_connect_by_elim_dups TRUE   
_optimizer_correct_sq_selectivity TRUE   
_optimizer_cost_based_transformation LINEAR   
_optimizer_cost_hjsmj_multimatch TRUE   
_optimizer_cost_model CHOOSE   
_optimizer_dim_subq_join_sel TRUE   
_optimizer_distinct_agg_transform TRUE   
_optimizer_distinct_elimination TRUE   
_optimizer_distinct_placement TRUE   
_optimizer_eliminate_filtering_join TRUE   
_optimizer_enable_density_improvements TRUE   
_optimizer_enable_extended_stats TRUE   
_optimizer_enable_table_lookup_by_nl TRUE   
_optimizer_enhanced_filter_push TRUE   
_optimizer_extend_jppd_view_types TRUE   
_optimizer_extended_cursor_sharing UDO   
_optimizer_extended_cursor_sharing_rel SIMPLE   
_optimizer_extended_stats_usage_control 192   
_optimizer_false_filter_pred_pullup TRUE   
_optimizer_fast_access_pred_analysis TRUE   
_optimizer_fast_pred_transitivity TRUE   
_optimizer_filter_pred_pullup TRUE   
_optimizer_fkr_index_cost_bias 10   
_optimizer_full_outer_join_to_outer TRUE   
_optimizer_group_by_placement TRUE   
_optimizer_improve_selectivity TRUE   
_optimizer_interleave_jppd TRUE   
_optimizer_join_elimination_enabled TRUE   
_optimizer_join_factorization TRUE   
_optimizer_join_order_control 3   
_optimizer_join_sel_sanity_check TRUE   
_optimizer_max_permutations 2000   
_optimizer_mode_force TRUE   
_optimizer_multi_level_push_pred TRUE   
_optimizer_native_full_outer_join FORCE   
_optimizer_new_join_card_computation TRUE   
_optimizer_null_aware_antijoin TRUE   
_optimizer_or_expansion DEPTH   
_optimizer_order_by_elimination_enabled TRUE   
_optimizer_outer_join_to_inner TRUE   
_optimizer_outer_to_anti_enabled TRUE   
_optimizer_push_down_distinct 0   
_optimizer_push_pred_cost_based TRUE   
_optimizer_rownum_bind_default 10   
_optimizer_rownum_pred_based_fkr TRUE   
_optimizer_skip_scan_enabled TRUE   
_optimizer_sortmerge_join_inequality TRUE   
_optimizer_squ_bottomup TRUE   
_optimizer_star_tran_in_with_clause TRUE   
_optimizer_system_stats_usage TRUE   
_optimizer_table_expansion TRUE   
_optimizer_transitivity_retain TRUE   
_optimizer_try_st_before_jppd TRUE   
_optimizer_undo_cost_change 11.2.0.3   
_optimizer_unnest_corr_set_subq TRUE   
_optimizer_unnest_disjunctive_subq TRUE   
_optimizer_use_cbqt_star_transformation TRUE   
_optimizer_use_feedback TRUE   
_or_expand_nvl_predicate TRUE   
_ordered_nested_loop TRUE   
_parallel_broadcast_enabled TRUE   
_partition_view_enabled TRUE   
_pga_max_size 2147483648   
_pivot_implementation_method CHOOSE   
_pre_rewrite_push_pred TRUE   
_pred_move_around TRUE   
_push_join_predicate TRUE   
_push_join_union_view TRUE   
_push_join_union_view2 TRUE   
_px_minus_intersect TRUE   
_px_partition_scan_enabled TRUE   
_px_pwg_enabled TRUE   
_px_ual_serial_input TRUE   
_query_rewrite_setopgrw_enable TRUE   
_remove_aggr_subquery TRUE   
_replace_virtual_columns TRUE   
_right_outer_hash_enable TRUE   
_selfjoin_mv_duplicates TRUE   
_smm_max_size 1048576   
_smm_min_size 1024   
_smm_px_max_size 14680064   
_sql_model_unfold_forloops RUN_TIME   
_sqltune_category_parsed DEFAULT   
_subquery_pruning_enabled TRUE   
_subquery_pruning_mv_enabled FALSE   
_table_scan_cost_plus_one TRUE   
_union_rewrite_for_gs YES_GSET_MVS   
_unnest_subquery TRUE   
_use_column_stats_for_function TRUE   
audit_sys_operations TRUE   
audit_trail DB   
background_dump_dest /u01/app/oracle/diag/rdbms/mcsdb/MCSDB1/trace   
cluster_database TRUE   
cluster_interconnects 192.168.10.1   
compatible 11.2.0.3.0   
control_files +DATA_DM01/mcsdb/control01.ctl, +DATA_DM01/mcsdb/control02.ctl, +DATA_DM01/mcsdb/control03.ctl   
core_dump_dest /u01/app/oracle/diag/rdbms/mcsdb/MCSDB1/cdump   
db_block_checking false   
db_block_checksum typical   
db_block_size 8192   
db_create_online_log_dest_1 +DATA_DM01   
db_domain      
db_lost_write_protect typical   
db_name MCSDB   
db_recovery_file_dest +RECO_DM01   
db_recovery_file_dest_size 2199023255552   
diagnostic_dest /u01/app/oracle   
fal_client      
fast_start_mttr_target 300   
filesystemio_options setall   
global_names FALSE   
instance_number 1   
local_listener (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.187.4.92)(PORT=1521))))   
log_archive_dest_1 location=USE_DB_RECOVERY_FILE_DEST   
log_archive_format %t_%s_%r.dbf   
log_buffer 134217728   
log_checkpoints_to_alert TRUE   
open_cursors 3000   
optimizer_dynamic_sampling 2   
optimizer_mode ALL_ROWS   
os_authent_prefix      
parallel_adaptive_multi_user FALSE   
parallel_degree_limit 16   
parallel_degree_policy MANUAL   
parallel_execution_message_size 16384   
parallel_max_servers 240   
parallel_min_servers 96   
parallel_servers_target 128   
parallel_threads_per_cpu 1   
pga_aggregate_target 32212254720   
plsql_warnings DISABLE:ALL   
processes 3000   
query_rewrite_enabled TRUE   
query_rewrite_integrity TRUSTED   
recyclebin on   
remote_listener dm01-scan:1521   
remote_login_passwordfile EXCLUSIVE   
result_cache_max_size 187924480   
sessions 4536   
sga_max_size 53687091200   
sga_target 53687091200   
skip_unusable_indexes TRUE   
sql92_security TRUE   
thread 1   
undo_tablespace UNDOTBS1   
use_large_pages TRUE   
user_dump_dest /u01/app/oracle/diag/rdbms/mcsdb/MCSDB1/trace   

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter Name Begin value End value (if different)
_ksb_restart_policy_times 0   
120   
240   
60   
control_files +DATA_DM01/mcsdb/control01.ctl   
+DATA_DM01/mcsdb/control02.ctl   
+DATA_DM01/mcsdb/control03.ctl   

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

Statistic Total per Second per Trans
acks for commit broadcast(actual) 40,272 11.22 0.30
acks for commit broadcast(logical) 41,200 11.48 0.31
broadcast msgs on commit(actual) 68,599 19.12 0.51
broadcast msgs on commit(logical) 70,582 19.67 0.52
broadcast msgs on commit(wasted) 1,441 0.40 0.01
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
flow control messages received 14 0.00 0.00
flow control messages sent 6 0.00 0.00
gcs apply delta 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 107,154 29.86 0.79
gcs ast xid 3 0.00 0.00
gcs blocked converts 114,671 31.96 0.85
gcs blocked cr converts 114,011 31.78 0.85
gcs compatible basts 897 0.25 0.01
gcs compatible cr basts (global) 2,282 0.64 0.02
gcs compatible cr basts (local) 98,906 27.57 0.73
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 28,001 7.80 0.21
gcs dbwr write request msgs 9,404 2.62 0.07
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 0 0.00 0.00
gcs force cr block only 9 0.00 0.00
gcs force cr grant 53 0.01 0.00
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 7,554 2.11 0.06
gcs immediate (null) converts 248,086 69.14 1.84
gcs immediate cr (compatible) converts 19 0.01 0.00
gcs immediate cr (null) converts 312,598 87.12 2.32
gcs indirect ast 204,272 56.93 1.51
gcs indirect bidless ast 0 0.00 0.00
gcs indirect fg ast 203,120 56.61 1.51
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 10,221 2.85 0.08
gcs msgs process time(ms) 16,269 4.53 0.12
gcs msgs received 1,256,911 350.30 9.32
gcs new served by master 115,499 32.19 0.86
gcs out-of-order msgs 4 0.00 0.00
gcs pings refused 267 0.07 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs push delta 0 0.00 0.00
gcs queued converts 1 0.00 0.00
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 2 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 21 0.01 0.00
gcs share recovery bast 0 0.00 0.00
gcs side channel msgs actual 0 0.00 0.00
gcs side channel msgs logical 0 0.00 0.00
gcs stale cr 33 0.01 0.00
gcs undo cr 2,570 0.72 0.02
gcs write notification msgs 1,373 0.38 0.01
gcs writes refused 150 0.04 0.00
ges msgs process time(ms) 767 0.21 0.01
ges msgs received 50,822 14.16 0.38
global posts dropped 0 0.00 0.00
global posts queue time 104 0.03 0.00
global posts queued 63 0.02 0.00
global posts requested 63 0.02 0.00
global posts sent 63 0.02 0.00
implicit batch messages received 26,255 7.32 0.19
implicit batch messages sent 20,129 5.61 0.15
lmd msg send time(ms) 34 0.01 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 3,440 0.96 0.03
messages queue sent actual 118,285 32.97 0.88
messages queue sent logical 77,291 21.54 0.57
messages received actual 653,782 182.21 4.85
messages received logical 1,307,718 364.46 9.70
messages sent directly 406,141 113.19 3.01
messages sent indirectly 186,848 52.08 1.39
messages sent not implicit batched 130 0.04 0.00
messages sent pbatched 795,194 221.62 5.90
msgs causing lmd to send msgs 19,868 5.54 0.15
msgs causing lms(s) to send msgs 31,421 8.76 0.23
msgs received queue time (ms) 635,279 177.05 4.71
msgs received queued 1,307,758 364.48 9.70
msgs sent queue time (ms) 8,055 2.24 0.06
msgs sent queue time on ksxp (ms) 61,480 17.13 0.46
msgs sent queued 169,301 47.18 1.26
msgs sent queued on ksxp 620,660 172.98 4.60
number of broadcasted resources 0 0.00 0.00
number of ges deadlock detected 0 0.00 0.00
process batch messages received 160,308 44.68 1.19
process batch messages sent 155,222 43.26 1.15


Back to Top

Global CR Served Stats

Statistic Total
CR Block Requests 96,911
CURRENT Block Requests 7,011
Data Block Requests 96,910
Undo Block Requests 2,570
TX Block Requests 1,113
Current Results 103,855
Private results 8
Zero Results 52
Disk Read Results 0
Fail Results 2
Fairness Down Converts 76,027
Fairness Clears 3,634
Free GC Elements 0
Flushes 1,649
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 84
Errors 0


Back to Top

Global CURRENT Served Stats

Statistic Total % <1ms % <10ms % <100ms % <1s % <10s
Pins 30 73.33 13.33 13.33 0.00 0.00
Flushes 1,882 94.21 5.58 0.21 0.00 0.00
Writes 29,725 38.91 36.59 16.46 4.87 3.17


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
2 data block 115,884 86.78 1.62 11.60 267,116 88.96 0.92 10.12
2 Others 2,686 95.42 0.19 4.39 3,728 94.66 1.21 4.13
2 undo header 1,324 94.94 4.08 0.98 218 86.24 13.30 0.46
2 undo block 10 70.00 30.00 0.00 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
2 data block 0.31 0.28 0.51 0.53 0.44 0.37 0.76 1.08
2 others 0.23 0.22 0.43 0.43 0.38 0.31 6.12 0.33
2 undo header 0.14 0.08 1.43 0.08 0.24 0.11 1.10 0.11
2 undo block 0.22 0.09 0.53          

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
2 data block 0 100,562 100.00 0.00 237,617 100.00 0.00
2 others 0 2,563 100.00 0.00 3,529 100.00 0.00
2 undo header 0 1,257 100.00 0.00 188 100.00 0.00
2 undo block 0 7 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
2 data block   0.28 0.28   0.37 0.37  
2 others   0.22 0.22   0.31 0.31  
2 undo header   0.08 0.08   0.11 0.11  
2 undo block   0.09 0.09        

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 284 0.09 0.02 284 0.08 0.02
2 284 0.10 0.02 284 0.12 0.05

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used By Send Mbytes/sec Receive Mbytes/sec
Global Cache 0.55 0.75
Parallel Query 0.00 0.00
DB Locks 0.10 0.09
DB Streams 0.00 0.00
Other 0.00 0.02

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
bondib0 192.168.10.1 NO cluster_interconnects parameter 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 16 1.60    
replayed locks received 4,216 421.60    
replayed locks sent 32,829 3,282.90    
resources cleaned 0 0.00    
remaster time (s) 14.0 1.40    
quiesce time (s) 3.2 0.32    
freeze time (s) 0.4 0.04    
cleanup time (s) 2.1 0.21    
replay time (s) 0.6 0.06    
fixwrite time (s) 4.3 0.43    
sync time (s) 3.3 0.33    
affinity objects     728 728


Back to Top

End of Report