WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC
SDSLDB 3951945579 SDSLDB1 1 11-Dec-12 21:12 11.2.0.3.0 YES

Host Name Platform CPUs Cores Sockets Memory (GB)
SDSLDB1 Linux x86 64-bit 160 80 8 504.72

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 827 21-Dec-12 10:00:02 175 1.5
End Snap: 828 21-Dec-12 11:00:34 168 1.5
Elapsed:   60.53 (mins)    
DB Time:   77.62 (mins)    

Report Summary

Cache Sizes

Begin End
Buffer Cache: 218,112M 218,112M Std Block Size: 8K
Shared Pool Size: 25,600M 25,600M Log Buffer: 426,124K

Load Profile

Per Second Per Transaction Per Exec Per Call
DB Time(s): 1.3 1.6 0.01 0.00
DB CPU(s): 0.7 0.9 0.00 0.00
Redo size: 12,106.3 15,411.8    
Logical reads: 3,431.7 4,368.7    
Block changes: 580.3 738.8    
Physical reads: 0.0 0.0    
Physical writes: 4.9 6.3    
User calls: 649.7 827.0    
Parses: 4.1 5.2    
Hard parses: 0.2 0.3    
W/A MB processed: 2.5 3.2    
Logons: 1.5 1.8    
Executes: 150.1 191.1    
Rollbacks: 0.0 0.0    
Transactions: 0.8      

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.62 Soft Parse %: 95.30
Execute to Parse %: 97.27 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 98.91 % Non-Parse CPU: 99.60

Shared Pool Statistics

Begin End
Memory Usage %: 58.61 58.60
% SQL with executions>1: 98.05 98.27
% Memory for SQL w/exec>1: 93.35 95.38

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU   2,686   57.68  
ges inquiry response 8,582,606 2,291 0 49.20 Other
transaction 103 103 1001 2.21 Other
enq: TX - row lock contention 1 59 59188 1.27 Application
reliable message 12,516 26 2 0.55 Other

Host CPU (CPUs: 160 Cores: 80 Sockets: 8)

Load Average Begin Load Average End %User %System %WIO %Idle
0.16 0.25 0.8 0.2 0.0 99.0
Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
0.9 83.3 0.0
Memory Statistics

Begin End
Host Mem (MB): 516,829.8 516,829.8
SGA use (MB): 250,368.0 250,368.0
PGA use (MB): 900.3 900.7
% Host Mem used for SGA+PGA: 48.62 48.62

RAC Statistics

Begin End
Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction
Global Cache blocks received: 29.70 37.80
Global Cache blocks served: 7.41 9.44
GCS/GES messages received: 2,519.39 3,207.30
GCS/GES messages sent: 2,547.91 3,243.60
DBWR Fusion writes: 1.33 1.70
Estd Interconnect traffic (KB) 1,286.56  

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

Buffer access - local cache %: 99.13
Buffer access - remote cache %: 0.87
Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.4
Avg global cache current block receive time (ms): 0.5
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 %: 26.1
Avg global cache cr block flush time (ms): 0.9
Avg global cache current block pin time (ms): 1,438.5
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 606,345.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.6
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.2
% of direct sent messages: 99.23
% of indirect sent messages: 0.77
% of flow controlled messages: 0.00

Cluster Interconnect

  Begin End
Interface IP Address Pub Source IP Pub Src
eth2:1 169.254.2.43 N        

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 2,686.22 57.68
sql execute elapsed time 707.76 15.20
PL/SQL execution elapsed time 50.34 1.08
parse time elapsed 18.39 0.39
connection management call elapsed time 10.78 0.23
hard parse elapsed time 6.37 0.14
inbound PL/SQL rpc elapsed time 1.22 0.03
hard parse (sharing criteria) elapsed time 1.07 0.02
sequence load elapsed time 0.26 0.01
PL/SQL compilation elapsed time 0.21 0.00
hard parse (bind mismatch) elapsed time 0.20 0.00
repeated bind elapsed time 0.08 0.00
failed parse elapsed time 0.03 0.00
DB time 4,657.28  
background elapsed time 5,774.07  
background cpu time 2,406.33  

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Value End Value
BUSY_TIME 611,364  
IDLE_TIME 57,642,023  
IOWAIT_TIME 2,434  
NICE_TIME 0  
SYS_TIME 129,530  
USER_TIME 453,961  
LOAD 0 0
RSRC_MGR_CPU_WAIT_TIME 0  
PHYSICAL_MEMORY_BYTES 541,935,366,144  
NUM_CPUS 160  
NUM_CPU_CORES 80  
NUM_CPU_SOCKETS 8  
GLOBAL_RECEIVE_SIZE_MAX 4,194,304  
GLOBAL_SEND_SIZE_MAX 1,048,586  
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-Dec 10:00:02 0.16          
21-Dec 11:00:34 0.25 1.05 0.78 0.22 98.95 0.00

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     2,686   57.68
Other 8,778,566 1 2,458 0 52.79
Application 27 4 59 2193 1.27
Network 1,417,053 0 21 0 0.45
Cluster 17,177 0 10 1 0.21
System I/O 8,811 0 6 1 0.13
Commit 5,941 0 4 1 0.08
Concurrency 2,459 0 0 0 0.01
User I/O 894 0 0 0 0.01
Configuration 5 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
ges inquiry response 8,582,606 0 2,291 0 3,008.27 49.20
transaction 103 100 103 1001 0.04 2.21
enq: TX - row lock contention 1 0 59 59188 0.00 1.27
reliable message 12,516 0 26 2 4.39 0.55
SQL*Net message from dblink 9,684 0 18 2 3.39 0.39
PX Deq: Slave Session Stats 6,286 0 15 2 2.20 0.32
rdbms ipc reply 27,707 0 8 0 9.71 0.18
control file sequential read 8,811 0 6 1 3.09 0.13
DFS lock handle 12,708 0 5 0 4.45 0.12
enq: US - contention 13,315 0 5 0 4.67 0.10
gc cr block 2-way 7,599 0 4 1 2.66 0.09
log file sync 5,941 0 4 1 2.08 0.08
gc current block 2-way 4,891 0 3 1 1.71 0.06
gc current grant busy 3,945 0 3 1 1.38 0.05
SQL*Net message to client 1,395,369 0 2 0 489.09 0.05
enq: PS - contention 2,119 1 2 1 0.74 0.03
KJC: Wait for msg sends to complete 45,740 0 1 0 16.03 0.02
PX Deq: reap credit 50,833 100 1 0 17.82 0.02
latch free 13,641 0 1 0 4.78 0.01
name-service call wait 6 0 0 81 0.00 0.01
PX Deq: Signal ACK RSG 4,182 0 0 0 1.47 0.01
SQL*Net more data to client 2,283 0 0 0 0.80 0.01
IPC send completion sync 2,139 0 0 0 0.75 0.01
gc cr multi block request 330 0 0 1 0.12 0.01
Disk file operations I/O 763 0 0 0 0.27 0.01
row cache lock 535 0 0 0 0.19 0.00
os thread startup 3 0 0 55 0.00 0.00
SQL*Net more data from client 43 0 0 4 0.02 0.00
PX Deq: Signal ACK EXT 4,180 0 0 0 1.47 0.00
db file sequential read 73 0 0 2 0.03 0.00
gc cr block congested 172 0 0 1 0.06 0.00
library cache pin 169 0 0 0 0.06 0.00
direct path read 49 0 0 1 0.02 0.00
library cache lock 145 4 0 0 0.05 0.00
gc current block congested 93 0 0 1 0.03 0.00
enq: TX - contention 104 100 0 0 0.04 0.00
gc current block busy 27 0 0 1 0.01 0.00
SQL*Net break/reset to client 24 0 0 1 0.01 0.00
latch: row cache objects 1,605 0 0 0 0.56 0.00
gc current grant 2-way 69 0 0 0 0.02 0.00
CSS initialization 6 0 0 4 0.00 0.00
gc cr block busy 13 0 0 2 0.00 0.00
CSS operation: action 6 0 0 3 0.00 0.00
SQL*Net message to dblink 9,674 0 0 0 3.39 0.00
latch: ges resource hash list 237 0 0 0 0.08 0.00
gc cr grant 2-way 29 0 0 0 0.01 0.00
enq: JQ - contention 11 100 0 1 0.00 0.00
enq: HW - contention 5 0 0 1 0.00 0.00
gc current multi block request 5 0 0 1 0.00 0.00
CSS operation: query 18 0 0 0 0.01 0.00
enq: TO - contention 6 0 0 0 0.00 0.00
enq: CF - contention 5 0 0 0 0.00 0.00
gc current grant congested 4 0 0 1 0.00 0.00
enq: JS - job run lock - synchronize 4 100 0 0 0.00 0.00
direct path write temp 7 0 0 0 0.00 0.00
SQL*Net message from client 1,395,377 0 389,782 279 489.09  
jobq slave wait 3,032 100 1,517 500 1.06  
PX Deq: Execution Msg 8,432 0 20 2 2.96  
PX Deq: Execute Reply 4,601 0 9 2 1.61  
PX Deq: Join ACK 4,182 0 5 1 1.47  
PX Deq: Parse Reply 4,182 0 2 0 1.47  
single-task message 12 0 0 27 0.00  
KSV master wait 6 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
DFS lock handle 382,439 100 126 0 134.05 2.19
gc cr block 2-way 89,326 0 38 0 31.31 0.66
control file sequential read 10,620 0 8 1 3.72 0.14
log file parallel write 17,580 0 5 0 6.16 0.08
reliable message 2,583 0 5 2 0.91 0.08
db file parallel write 13,918 0 4 0 4.88 0.08
log file sync 4,169 0 2 1 1.46 0.04
gcs log flush sync 3,295 0 2 1 1.15 0.04
os thread startup 71 0 2 26 0.02 0.03
gc current block 2-way 2,808 0 1 1 0.98 0.02
enq: TX - contention 3,472 100 1 0 1.22 0.02
enq: US - contention 3,856 0 1 0 1.35 0.02
row cache lock 1,042 0 1 1 0.37 0.01
gc cr block congested 1,514 0 1 0 0.53 0.01
rdbms ipc reply 1,716 0 1 0 0.60 0.01
control file parallel write 1,500 0 0 0 0.53 0.01
gc current grant busy 880 0 0 1 0.31 0.01
CGS wait for IPC msg 34,084 100 0 0 11.95 0.01
CSS operation: data query 180 0 0 2 0.06 0.01
SQL*Net break/reset to client 4,914 0 0 0 1.72 0.01
ASM file metadata operation 1,446 0 0 0 0.51 0.01
latch: ges resource hash list 5,710 0 0 0 2.00 0.00
process diagnostic dump 1 0 0 252 0.00 0.00
ksxr poll remote instances 16,705 100 0 0 5.86 0.00
row cache process 33,607 0 0 0 11.78 0.00
row cache cleanup 29,228 0 0 0 10.24 0.00
name-service call wait 3 0 0 30 0.00 0.00
enq: TM - contention 7 86 0 11 0.00 0.00
gc current block busy 46 0 0 2 0.02 0.00
CSS group membership query 60 0 0 1 0.02 0.00
PX Deq: reap credit 5,143 100 0 0 1.80 0.00
libcache interrupt action by LCK 26,407 0 0 0 9.26 0.00
Disk file operations I/O 79 0 0 1 0.03 0.00
enq: JS - queue lock 5 0 0 8 0.00 0.00
enq: CF - contention 64 77 0 0 0.02 0.00
asynch descriptor resize 3,153 100 0 0 1.11 0.00
gc current block congested 46 0 0 1 0.02 0.00
ksdxexeotherwait 1 0 0 23 0.00 0.00
db file async I/O submit 13,885 0 0 0 4.87 0.00
SQL*Net message to client 14,110 0 0 0 4.95 0.00
gc cr block busy 10 0 0 1 0.00 0.00
latch: row cache objects 380 0 0 0 0.13 0.00
latch free 88 0 0 0 0.03 0.00
CSS operation: action 10 0 0 1 0.00 0.00
db file sequential read 35 0 0 0 0.01 0.00
enq: PS - contention 12 0 0 1 0.00 0.00
CSS initialization 2 0 0 5 0.00 0.00
enq: WF - contention 21 0 0 0 0.01 0.00
library cache pin 17 0 0 0 0.01 0.00
gc current grant 2-way 12 0 0 0 0.00 0.00
enq: TA - contention 12 0 0 0 0.00 0.00
gc current multi block request 8 0 0 1 0.00 0.00
LGWR wait for redo copy 77 0 0 0 0.03 0.00
library cache lock 7 14 0 1 0.00 0.00
PX Deq: Slave Session Stats 18 0 0 0 0.01 0.00
gc buffer busy release 8 0 0 0 0.00 0.00
ADR block file read 16 0 0 0 0.01 0.00
IPC send completion sync 12 0 0 0 0.00 0.00
enq: TD - KTF dump entries 7 0 0 0 0.00 0.00
PX Deq: Signal ACK RSG 18 0 0 0 0.01 0.00
enq: TT - contention 4 75 0 0 0.00 0.00
gc cr multi block request 3 0 0 1 0.00 0.00
rdbms ipc message 172,854 50 159,081 920 60.59  
gcs remote message 2,479,307 97 25,376 10 869.02  
wait for unread message on broadcast channel 7,256 100 7,263 1001 2.54  
DIAG idle wait 87,884 82 7,178 82 30.80  
PX Idle Wait 2,111 0 5,402 2559 0.74  
Space Manager: slave idle wait 852 99 4,235 4971 0.30  
smon timer 20 60 3,688 184389 0.01  
SQL*Net message from client 17,174 0 3,645 212 6.02  
ASM background timer 1,079 0 3,634 3368 0.38  
class slave wait 257 0 3,632 14132 0.09  
shared server idle wait 121 100 3,631 30011 0.04  
pmon timer 1,209 100 3,631 3003 0.42  
GCR sleep 726 100 3,630 5001 0.25  
PING 1,368 21 3,629 2653 0.48  
Streams AQ: qmn coordinator idle wait 252 50 3,627 14392 0.09  
Streams AQ: qmn slave idle wait 126 0 3,627 28785 0.04  
dispatcher timer 60 100 3,601 60014 0.02  
ges remote message 9,008,814 0 1,856 0 3,157.66  
PX Deq: Parse Reply 18 0 0 4 0.01  
KSV master wait 2,277 97 0 0 0.80  
PX Deq: Join ACK 18 0 0 1 0.01  
Streams AQ: RAC qmn coordinator idle wait 255 100 0 0 0.09  
PX Deq: Execute Reply 18 0 0 0 0.01  

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 16 100.0              
ADR block file write 5 100.0              
ADR file lock 6 100.0              
ASM file metadata operation 1446 99.7           .3  
CGS wait for IPC msg 34.1K 100.0              
CSS group membership query 60 41.7 58.3            
CSS initialization 8 50.0     12.5 37.5      
CSS operation: action 16 25.0 25.0 43.8 6.3        
CSS operation: data query 180   45.6 54.4          
CSS operation: query 84 98.8 1.2            
DFS lock handle 394.1K 99.7 .3 .0 .0 .0 .0 .0  
Disk file operations I/O 838 98.8     1.0 .2      
IPC send completion sync 2151 100.0 .0            
KJC: Wait for msg sends to complete 45.7K 100.0 .0            
LGWR wait for redo copy 77 100.0              
PX Deq: Signal ACK EXT 4198 100.0 .0            
PX Deq: Signal ACK RSG 4200 100.0 .0            
PX Deq: Slave Session Stats 6305 99.4 .3 .0 .0   .0 .2 .1
PX Deq: reap credit 56K 100.0 .0            
PX qref latch 2 100.0              
SQL*Net break/reset to client 4938 99.7 .0 .2   .0      
SQL*Net message from dblink 9684 22.7 47.4 28.1 1.7 .1 .0    
SQL*Net message to client 1409.5K 100.0              
SQL*Net message to dblink 9674 100.0              
SQL*Net more data from client 43 30.2 23.3 11.6 25.6 7.0 2.3    
SQL*Net more data to client 2283 98.0 .1 .4 .7 .6 .1 .0  
asynch descriptor resize 3231 100.0              
buffer busy waits 2 100.0              
control file parallel write 1496 99.8 .1 .1          
control file sequential read 19.4K 94.6 .6 1.1 2.4 .9 .4 .0  
db file async I/O submit 13.9K 100.0              
db file parallel write 13.9K 99.9 .0 .0 .0 .0      
db file scattered read 2 100.0              
db file sequential read 101 78.2 2.0 9.9 8.9 1.0      
direct path read 49 89.8   2.0 6.1 2.0      
direct path write 1 100.0              
direct path write temp 7 100.0              
enq: AE - lock 1 100.0              
enq: AF - task serialization 1 100.0              
enq: CF - contention 68 100.0              
enq: CR - block range reuse ckpt 1 100.0              
enq: FB - contention 2 100.0              
enq: HW - contention 12 91.7 8.3            
enq: JQ - contention 11 72.7 27.3            
enq: JS - job run lock - synchronize 4 100.0              
enq: JS - queue lock 5       60.0 40.0      
enq: MW - contention 2 100.0              
enq: PI - contention 2 100.0              
enq: PS - contention 2131 95.6 4.3 .1     .0    
enq: TA - contention 12 91.7 8.3            
enq: TD - KTF dump entries 7 100.0              
enq: TM - contention 7 85.7           14.3  
enq: TO - contention 6 100.0              
enq: TT - contention 5 100.0              
enq: TX - contention 3576 99.5 .4 .0 .0        
enq: TX - row lock contention 1               100.0
enq: UL - contention 2 100.0              
enq: US - contention 17.5K 99.8 .1 .0 .0 .0      
enq: WF - contention 21 100.0              
gc buffer busy release 9 100.0              
gc cr block 2-way 96.9K 99.8 .2 .0          
gc cr block busy 25   92.0 8.0          
gc cr block congested 1686 99.8 .2            
gc cr grant 2-way 29 100.0              
gc cr multi block request 333 90.4 9.0 .6          
gc current block 2-way 7706 98.2 1.8            
gc current block busy 70 10.0 88.6 1.4          
gc current block congested 139 98.6 1.4            
gc current grant 2-way 84 98.8 1.2            
gc current grant busy 4842 94.5 5.5 .0          
gc current grant congested 4 75.0 25.0            
gc current multi block request 26 100.0              
gcs log flush sync 3290 93.5 6.2 .1 .2        
ges inquiry response 8582.9K 99.9 .1 .0 .0 .0 .0    
ksdxexeotherwait 1           100.0    
ksxr poll remote instances 16.7K 100.0              
latch free 15K 99.9 .1     .0      
latch: active service list 1 100.0              
latch: cache buffers chains 1 100.0              
latch: enqueue hash chains 1 100.0              
latch: ges resource hash list 7467 99.7 .3 .0          
latch: messages 3 100.0              
latch: row cache objects 1975 99.9 .1            
libcache interrupt action by LCK 26.4K 100.0              
library cache lock 152 100.0              
library cache pin 186 100.0              
log file parallel write 17.6K 99.7 .1 .1 .0        
log file sync 10.1K 98.0 1.9 .1 .0        
name-service call wait 9       11.1   11.1 77.8  
os thread startup 74           95.9 4.1  
process diagnostic dump 1             100.0  
rdbms ipc reply 29.4K 93.7 6.3 .0 .0 .0 .0    
reliable message 15.1K 97.7 .7 1.3 .1 .0 .0 .3  
row cache cleanup 29.3K 100.0              
row cache lock 1584 97.7 2.0 .1   .1      
row cache process 33.6K 100.0              
transaction 103             100.0  
ASM background timer 1079       18.2 .3 1.4 10.3 69.9
DIAG idle wait 87.9K 15.1 1.4 .2 .1 10.5 24.9 47.7  
GCR sleep 727               100.0
KSV master wait 2282 100.0              
PING 1368 78.9             21.1
PX Deq: Execute Reply 4619 87.2 1.2 1.2 .9 7.2 2.0 .2 .0
PX Deq: Execution Msg 8432 60.6 28.3 9.5 .3 .7 .5 .1 .0
PX Deq: Join ACK 4200 39.6 56.0 4.5 .0        
PX Deq: Parse Reply 4200 97.8 1.8 .2 .1 .1      
PX Idle Wait 2108 .1   .0 1.9 1.6 .2 9.5 86.6
SQL*Net message from client 1412.6K 45.5 51.6 1.4 .6 .2 .1 .4 .3
Space Manager: slave idle wait 855         .1   .6 99.3
Streams AQ: RAC qmn coordinator idle wait 255 100.0              
Streams AQ: qmn coordinator idle wait 252 50.0             50.0
Streams AQ: qmn slave idle wait 126               100.0
class slave wait 254 38.6 .4 5.5 17.3 7.1   1.2 29.9
dispatcher timer 60               100.0
gcs remote message 2457K .5 .4 .6 1.1 97.4 .0    
ges remote message 9006.6K 99.7 .1 .0 .0 .0 .0 .0  
jobq slave wait 3033 .0       .0   99.9  
pmon timer 1208               100.0
rdbms ipc message 172.9K 29.3 3.4 2.5 .6 3.4 1.5 32.9 26.5
shared server idle wait 121               100.0
single-task message 12     16.7     33.3 50.0  
smon timer 19 5.3           21.1 73.7
wait for unread message on broadcast channel 7258             100.0  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

    % of Total Waits
Event Waits 64ms to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s
ASM file metadata operation 4 99.7 .3            
DFS lock handle 2 100.0   .0          
PX Deq: Slave Session Stats 16 99.7   .0 .0 .0 .1 .1  
SQL*Net more data to client 1 100.0 .0            
control file sequential read 7 100.0 .0            
enq: TM - contention 1 85.7   14.3          
name-service call wait 7 22.2 33.3 44.4          
os thread startup 3 95.9 1.4 2.7          
process diagnostic dump 1       100.0        
reliable message 44 99.7 .0 .0 .0 .1 .1    
transaction 103           100.0    

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
enq: TX - row lock contention 1           100.0    

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)
SDSLDB 4,291 2,591 0 11,472
SYS$USERS 363 92 0 676
SYS$BACKGROUND 0 0 0 317
SDSLDBXDB 0 0 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SDSLDB 788 0 2297 0 0 0 1397864 3
SYS$USERS 106 0 162 0 0 0 19190 18
SYS$BACKGROUND 115 0 27925 3 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
209.12 4 52.28 4.49 8.98 0.00 7yaqm2habcbap   DECLARE job BINARY_INTEGER := ...
189.32 79 2.40 4.07 99.73 0.00 df03gsnzb7nvy Spotlight on Oracle RAC SELECT l.latch#, l.gets, l.mis...
163.99 2,084 0.08 3.52 0.82 0.00 ggu8pr7gjt8h2   UPDATE T_XHD_XHQPMX SET CHANGE...
38.21 379,389 0.00 0.82 85.72 0.00 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
30.75 47 0.65 0.66 99.66 0.00 4hps2ntgwt7mz Spotlight on Oracle RAC SELECT /*+ ORDERED USE_INDEX(s...
26.98 1,841 0.01 0.58 23.72 0.00 7tx50ncu1kxgm   select INST_ID, REFCOUNT from ...
23.92 26,589 0.00 0.51 96.89 0.00 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
17.23 1 17.23 0.37 98.68 0.06 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
15.99 1 15.99 0.34 96.95 0.13 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
12.48 49 0.25 0.27 99.63 0.00 5ydynnzwm51pg Spotlight on Oracle RAC SELECT /*+ ORDERED USE_INDEX(s...

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
188.82 79 2.39 7.03 189.32 99.73 0.00 df03gsnzb7nvy Spotlight on Oracle RAC SELECT l.latch#, l.gets, l.mis...
32.76 379,389 0.00 1.22 38.21 85.72 0.00 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
30.64 47 0.65 1.14 30.75 99.66 0.00 4hps2ntgwt7mz Spotlight on Oracle RAC SELECT /*+ ORDERED USE_INDEX(s...
23.18 26,589 0.00 0.86 23.92 96.89 0.00 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
18.78 4 4.70 0.70 209.12 8.98 0.00 7yaqm2habcbap   DECLARE job BINARY_INTEGER := ...
17.00 1 17.00 0.63 17.23 98.68 0.06 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
15.50 1 15.50 0.58 15.99 96.95 0.13 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
12.43 49 0.25 0.46 12.48 99.63 0.00 5ydynnzwm51pg Spotlight on Oracle RAC SELECT /*+ ORDERED USE_INDEX(s...
12.04 1 12.04 0.45 12.09 99.52 0.11 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
10.93 1 10.93 0.41 10.97 99.66 0.18 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...

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
0.02 1 0.02 4.21 10.97 99.66 0.18 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...
0.02 1 0.02 4.17 15.99 96.95 0.13 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
0.01 1 0.01 2.87 12.09 99.52 0.11 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
0.01 1 0.01 2.03 17.23 98.68 0.06 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
0.00 188 0.00 0.82 0.07 70.69 5.39 9j7p7w49wmys6 oracle@xhwldb1 (TNS V1-V3) SELECT "YWBMBH", "ID", "CBNY",...
0.00 4 0.00 0.29 209.12 8.98 0.00 7yaqm2habcbap   DECLARE job BINARY_INTEGER := ...
0.00 39 0.00 0.23 0.38 86.94 0.29 1nw54wu88u2dg oracle@xhwldb1 (TNS V1-V3) DELETE FROM "T_SL_YFSJ" "A1" W...
0.00 458 0.00 0.22 0.06 95.57 1.68 5vm44sf21vfxr oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."YWYBH" FROM "T_GH...
0.00 12 0.00 0.11 6.47 94.62 0.01 ckyt3atda7nsu oracle@xhwldb1 (TNS V1-V3) SELECT "DJLY", "ZDQH", "ID", "...
0.00 379,389 0.00 0.10 38.21 85.72 0.00 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...

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
1,841,351 1 1,841,351.00 14.77 17.23 98.7 .1 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
1,573,616 1 1,573,616.00 12.63 15.99 97 .1 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
1,517,556 379,389 4.00 12.18 38.21 85.7 0 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
1,429,083 1 1,429,083.00 11.47 12.09 99.5 .1 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
1,386,745 1 1,386,745.00 11.13 10.97 99.7 .2 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...
835,781 26,589 31.43 6.71 23.92 96.9 0 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
672,063 4 168,015.75 5.39 209.12 9 0 7yaqm2habcbap   DECLARE job BINARY_INTEGER := ...
506,288 1,841 275.01 4.06 8.76 80.3 0 6yva4jbyzfky5   select local_tran_id, state, s...
469,908 19 24,732.00 3.77 3.48 100.1 0 9kag3vp7hqhdq   SELECT XZPCH FROM TRANS_BILL_D...
302,404 1 302,404.00 2.43 5.39 97.4 0 brj0ggnhsncvs   UPDATE T_FHMX SET GZBJ_FG='1' ...
253,452 12 21,121.00 2.03 6.47 94.6 0 ckyt3atda7nsu oracle@xhwldb1 (TNS V1-V3) SELECT "DJLY", "ZDQH", "ID", "...
166,830 2 83,415.00 1.34 2.72 98.6 0 fq2smudhvvsu9 oracle@SDMDDB1 (TNS V1-V3) SELECT "A1"."ID", "A1"."BB", "...

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
16 1 16.00 13.45 10.97 99.66 0.18 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...
15 1 15.00 12.61 15.99 96.95 0.13 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
15 1 15.00 12.61 12.09 99.52 0.11 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
8 1 8.00 6.72 17.23 98.68 0.06 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
0 614 0.00 0.00 0.35 100.06 0.00 0k8522rmdzg4k   select privilege# from sysauth...
0 607 0.00 0.00 0.27 103.70 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
0 60 0.00 0.00 0.01 101.15 0.00 16a3s8upbvx93 oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
0 172 0.00 0.00 0.04 79.71 0.00 16d1yf88kd74t oracle@xhwldb1 (TNS V1-V3) SELECT "BH", "MC" FROM "T_SPTZ...
0 10 0.00 0.00 0.30 55.48 0.00 16xd3hnhj26rw oracle@SDMDDB3 (TNS V1-V3) INSERT INTO "TM_JCFYHG" "A1" (...
0 39 0.00 0.00 0.38 86.94 0.29 1nw54wu88u2dg oracle@xhwldb1 (TNS V1-V3) DELETE FROM "T_SL_YFSJ" "A1" W...

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
3,431 3,431 47 73.00 0.00 2932.48 aj22x1qd1b243 Spotlight on Oracle RAC SELECT file_type, ROUND (mb_us...
245 245 35 7.00 0.00 209.40 5k3dxpy9z9ppm Spotlight on Oracle RAC SELECT p.name, --CloseCursor (...
16 16 1 16.00 0.00 13.68 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...
15 15 1 15.00 0.00 12.82 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
15 15 1 15.00 0.00 12.82 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
8 8 1 8.00 0.00 6.84 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
0 0 614 0.00   0.00 0k8522rmdzg4k   select privilege# from sysauth...
0 0 607 0.00   0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
0 0 60 0.00   0.00 16a3s8upbvx93 oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
0 0 172 0.00   0.00 16d1yf88kd74t oracle@xhwldb1 (TNS V1-V3) SELECT "BH", "MC" FROM "T_SPTZ...

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
379,389 379,389 1.00 38.21 85.7 0 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
26,649 26,649 1.00 3.50 90.3 0 1v95tq50r7363 oracle@xhwldb1 (TNS V1-V3) SELECT TO_DATE(TO_CHAR(SYSDATE...
26,649 26,649 1.00 2.76 99.4 0 47cb8ym4k5y6m oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
26,589 379,329 14.27 23.92 96.9 0 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
4,220 4,220 1.00 0.51 95.1 0 5zxpkzmw3ugbr oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DFBJ_S...
2,084 2,083 1.00 163.99 .8 0 ggu8pr7gjt8h2   UPDATE T_XHD_XHQPMX SET CHANGE...
1,841 0 0.00 8.76 80.3 0 6yva4jbyzfky5   select local_tran_id, state, s...
1,841 0 0.00 26.98 23.7 0 7tx50ncu1kxgm   select INST_ID, REFCOUNT from ...
1,380 550 0.40 0.23 97 0 cm5vu20fhtnq1   select /*+ connect_by_filterin...
656 656 1.00 2.71 47.7 0 8fhbd2sf4b5gy   INSERT INTO T_DHLS_JX (FLOWID_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
3,682 1,841 24.73 7tx50ncu1kxgm   select INST_ID, REFCOUNT from ...
614 614 4.12 0k8522rmdzg4k   select privilege# from sysauth...
614 1,380 4.12 cm5vu20fhtnq1   select /*+ connect_by_filterin...
611 611 4.10 459f3z9u4fb3u   select value$ from props$ wher...
607 607 4.08 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
605 605 4.06 5ur69atw3vfhj   select decode(failover_method,...
257 0 1.73 54rvdwvrhd0wt oracle@xhwldb1 (TNS V1-V3) SELECT /*+ FULL(P) +*/ * FROM ...
252 0 1.69 3z9hhd2tgfqxq oracle@xhwldb1 (TNS V1-V3) SELECT /*+ FULL(P) +*/ * FROM ...
188 188 1.26 9j7p7w49wmys6 oracle@xhwldb1 (TNS V1-V3) SELECT "YWBMBH", "ID", "CBNY",...
172 172 1.16 16d1yf88kd74t oracle@xhwldb1 (TNS V1-V3) SELECT "BH", "MC" FROM "T_SPTZ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
5,389,318 10 0.02 16xd3hnhj26rw oracle@SDMDDB3 (TNS V1-V3) INSERT INTO "TM_JCFYHG" "A1" (...
3,705,871 26,589 0.01 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
3,432,194 2 0.01 9dhn1b8d88dpf   select OBJOID, CLSOID, RUNTIME...
3,419,241 78 0.01 fmu7z5kfhn55g Spotlight on Oracle RAC WITH pm_retention AS (SELECT '...
2,921,719 26,589 0.01 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
2,683,495 12 0.01 f3223cb4ng6hq   select next_run_date, obj#, ru...
2,586,546 1 0.01 6wm3n4d7bnddg   SELECT source, (case when tim...
2,337,685 1 0.01 61tn3mam0vq0b   SELECT source, (case when tim...
2,224,471 12 0.01 7f8f9v6hmpqb5 oracle@xhwldb1 (TNS V1-V3) INSERT INTO "T_WL_BSJH" "A1" (...
1,710,342 656 0.01 8fhbd2sf4b5gy   INSERT INTO T_DHLS_JX (FLOWID_...
1,553,711 2 0.01 69k5bhm12sz98   SELECT dbin.instance_number, d...
1,255,566 2 0.00 2j0fw19fph49j   SELECT dbin.instance_number, d...
1,248,050 1 0.00 6wm3n4d7bnddg   SELECT source, (case when tim...
1,198,341 1 0.00 61tn3mam0vq0b   SELECT source, (case when tim...
1,060,452 4 0.00 4g87wy8gxkbrt oracle@xhwldb2 (TNS V1-V3) INSERT INTO "T_WL_SJDHSJ_HZ" "...
1,053,867 2 0.00 6kqtacs2nk07f oracle@SDMDDB1 (TNS V1-V3) INSERT INTO "T_TRANS_DATA_MX" ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
98 26,589 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
98 26,589 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
66 12 7f8f9v6hmpqb5 oracle@xhwldb1 (TNS V1-V3) INSERT INTO "T_WL_BSJH" "A1" (...
49 10 16xd3hnhj26rw oracle@SDMDDB3 (TNS V1-V3) INSERT INTO "TM_JCFYHG" "A1" (...
36 12 f3223cb4ng6hq   select next_run_date, obj#, ru...
34 60 dzsurp56f8aac oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
34 60 dzsurp56f8aac oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
32 4 4g87wy8gxkbrt oracle@xhwldb2 (TNS V1-V3) INSERT INTO "T_WL_SJDHSJ_HZ" "...
31 60 16a3s8upbvx93 oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
31 60 16a3s8upbvx93 oracle@xhwldb1 (TNS V1-V3) SELECT COUNT(*) FROM "T_DPLS" ...
31 2 69k5bhm12sz98   SELECT dbin.instance_number, d...
29 2 63t3ufgq37m0c   SELECT instance_number, instan...
29 2 63t3ufgq37m0c   SELECT instance_number, instan...
29 4 ctt6sqgc8004p   SELECT * FROM T_WL_SJDHSJ_HZ W...
27 2 2j0fw19fph49j   SELECT dbin.instance_number, d...
27 2 2j0fw19fph49j   SELECT dbin.instance_number, d...
26 2 3kwt6c4bhmrcp oracle@SDMDDB1 (TNS V1-V3) INSERT INTO "T_TRANS_DATA_HZ" ...
25 2 5s34t44u10q4g   SELECT a.name task_name, nvl(e...
25 2 6kqtacs2nk07f oracle@SDMDDB1 (TNS V1-V3) INSERT INTO "T_TRANS_DATA_MX" ...
25 1 6wm3n4d7bnddg   SELECT source, (case when tim...
25 1 6wm3n4d7bnddg   SELECT source, (case when tim...
25 12 c6n5fgdrum0hh oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DH", "A1"."CYBH",...
25 2 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
24 1 61tn3mam0vq0b   SELECT source, (case when tim...
24 1 61tn3mam0vq0b   SELECT source, (case when tim...
24 1 8p9z2ztb272bm   SELECT sx.instance_number, sx...
24 2 c8gnrhxma4tas   SELECT owner#, property FROM s...
23 12 31g5yw57tgt20 oracle@xhwldb1 (TNS V1-V3) INSERT INTO "T_WL_CKSJ_HZ" "A1...
23 11 g7zbdn5dambm9 oracle@SDMDDB3 (TNS V1-V3) SELECT DISTINCT PFPCH FROM TM_...
22 1 92yv7gw4g8b94   SELECT decode(es.name, 'cache'...
22 1 b41wak2bb7atw   SELECT sum(delta_cpu_time) as...

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
3.89 4 7.69 209.12 1.86 8.98 0.00 7yaqm2habcbap   DECLARE job BINARY_INTEGER := ...
2.09 1,841 4.14 8.76 23.88 80.27 0.00 6yva4jbyzfky5   select local_tran_id, state, s...
1.54 2,084 3.04 163.99 0.94 0.82 0.00 ggu8pr7gjt8h2   UPDATE T_XHD_XHQPMX SET CHANGE...
0.33 26,589 0.66 23.92 1.40 96.89 0.00 azfanj0gxsc3k oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."DBDH", "A1"."DJLY...
0.27 12 0.53 6.47 4.12 94.62 0.01 ckyt3atda7nsu oracle@xhwldb1 (TNS V1-V3) SELECT "DJLY", "ZDQH", "ID", "...
0.22 1 0.44 15.99 1.39 96.95 0.13 8190skq31gmpp TOAD 11.6.0.43 Select * from table(dbms_workl...
0.16 1 0.31 5.39 2.90 97.42 0.00 brj0ggnhsncvs   UPDATE T_FHMX SET GZBJ_FG='1' ...
0.15 656 0.29 2.71 5.38 47.75 0.00 8fhbd2sf4b5gy   INSERT INTO T_DHLS_JX (FLOWID_...
0.08 379,389 0.15 38.21 0.20 85.72 0.00 bh4zwws4vsz3s oracle@xhwldb1 (TNS V1-V3) SELECT NVL("A1"."NOFHBJ", '0')...
0.06 1 0.13 17.23 0.37 98.68 0.06 2wrsyr40shc22 TOAD 11.6.0.43 Select * from table(dbms_workl...
0.06 39 0.11 0.38 14.56 86.94 0.29 1nw54wu88u2dg oracle@xhwldb1 (TNS V1-V3) DELETE FROM "T_SL_YFSJ" "A1" W...
0.04 2 0.08 2.72 1.53 98.57 0.00 fq2smudhvvsu9 oracle@SDMDDB1 (TNS V1-V3) SELECT "A1"."ID", "A1"."BB", "...
0.03 1 0.06 12.09 0.27 99.52 0.11 dprtygq0grpys TOAD 11.6.0.43 Select * from table(dbms_workl...
0.02 1 0.03 10.97 0.14 99.66 0.18 8unsu6uwkqwpn TOAD 11.6.0.43 Select * from table(dbms_workl...
0.02 188 0.03 0.07 20.65 70.69 5.39 9j7p7w49wmys6 oracle@xhwldb1 (TNS V1-V3) SELECT "YWBMBH", "ID", "CBNY",...
0.01 39 0.03 0.32 4.04 98.54 0.02 dt32x2rbk5fct oracle@xhwldb1 (TNS V1-V3) INSERT INTO "T_SL_YFSJ_BAK" "A...
0.01 12 0.02 0.02 35.53 57.27 0.04 7f8f9v6hmpqb5 oracle@xhwldb1 (TNS V1-V3) INSERT INTO "T_WL_BSJH" "A1" (...
0.01 368 0.01 0.06 8.16 81.76 0.01 8dh3fhm51px57 oracle@xhwldb1 (TNS V1-V3) SELECT "A1"."FLOWID", "A1"."FL...
0.01 1 0.01 0.02 21.57 77.30 0.00 6wm3n4d7bnddg   SELECT source, (case when tim...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
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')
16a3s8upbvx93 SELECT COUNT(*) FROM "T_DPLS" "A1" WHERE "A1"."DH"=:B2 AND "A1"."TDPCH"=:B1 AND "A1"."ID" IS NULL
16d1yf88kd74t SELECT "BH", "MC" FROM "T_SPTZ" "T_SPTZ" WHERE "BH"=:1
16xd3hnhj26rw INSERT INTO "TM_JCFYHG" "A1" ("FLOWID", "HGPCH", "ZDQH", "ZDXH", "ID", "GHDWH", "CZRQ0", "FYSHL", "CLZT", "CLRQ", "YWBMBH", "BIANZH", "BZ", "LYBZ", "FBPC", "YYDFLAG") SELECT "A2"."FLOWID", "A2"."HGPCH", "A2"."ZDQH", "A2"."ZDXH", "A2"."ID", (SELECT "A6"."YWBM" FROM "T_GHDW"@! "A6" WHERE "A6"."BH"="A2"."GHDWH"), "A2"."CZRQ0", "A2"."FYSHL", "A2"."CLZT", "A2"."CZRQ0"+"A2"."THQX", (SELECT "A5"."YWBM" FROM "T_GHDW"@! "A5" WHERE "A5"."BH"="A2"."GHDWH"), (SELECT TRIM("A4"."NAME") FROM "T_USER"@! "A4" WHERE "A4"."USR_ID"="A2"."USR_ID0" AND "A4"."BMBH"="A2"."YWBMBH"), "A2"."DD_GPFLAG", "A2"."LYBZ", "A2"."FBPCH", "A2"."YYD_FLAG" FROM "T_JCFYHG"@! "A2" WHERE "A2"."YWBMBH"=:B1 AND EXISTS (SELECT 0 FROM "T_BDHZ"@! "A3" WHERE "A3"."HGPCH"="A2"."HGPCH" AND "A3"."SBPCH"=TRIM(:B2))
1nw54wu88u2dg DELETE FROM "T_SL_YFSJ" "A1" WHERE "A1"."FLOWID_DJ"=:B1
1v95tq50r7363 SELECT TO_DATE(TO_CHAR(SYSDATE@!, 'yyyy-mm-dd'), 'yyyy-mm-dd')+NVL("A1"."ZTSJ", 5)+:B2 FROM "T_DM" "A1" WHERE "A1"."DH"=:B1
2j0fw19fph49j SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time
2wrsyr40shc22 Select * from table(dbms_workload_repository.awr_global_report_html( 3951945579, '1, 2', 810, 811, 0))
31g5yw57tgt20 INSERT INTO "T_WL_CKSJ_HZ" "A1" ("PCH", "JLS", "LX", "SENDBMBH", "SENDDATE", "RECEBMBH") SELECT TRIM("A2"."YWPCH"), COUNT(*), 'BF', TRIM("A2"."CYBH"), SYSDATE@!, TRIM("A2"."YWBMBH") FROM "T_CRKLS"@! "A2" WHERE "A2"."YSBBJ"='9' AND "A2"."YWLX"='BF' GROUP BY "A2"."YWPCH", "A2"."CYBH", "A2"."YWBMBH"
3kwt6c4bhmrcp INSERT INTO "T_TRANS_DATA_HZ" "A1" ("SBPCH", "YWLX", "ZMY", "ZCS", "ZSY", "DATE_SEND", "GET_DATE", "DH", "PCH_GET", "GHDWH") SELECT "A2"."SBPCH", "A2"."YWLX", "A2"."ZMY", "A2"."ZCS", "A2"."ZSY", SYSDATE@!, SYSDATE@!, "A2"."DH", "A2"."PCH_GET", "A2"."GHDWH" FROM "T_TRANS_DATA_HZ"@! "A2" WHERE "A2"."SBPCH"=:B1
3z9hhd2tgfqxq SELECT /*+ FULL(P) +*/ * FROM "T_SPTZ" P
459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'
47cb8ym4k5y6m SELECT NVL("A1"."NOFHBJ", '0') FROM "T_DM_YWBM" "A1" WHERE "A1"."DH"=:B2 AND "A1"."YWBMBH"=:B1
4g87wy8gxkbrt INSERT INTO "T_WL_SJDHSJ_HZ" "A1" ("FLOWID_DJ", "JLS", "SENDBMBH", "RECEBMBH", "RECEFLAG", "SENDDATE", "DJRQ") SELECT "A2"."FLOWID_DJ", 1, "A2"."CYBH", "A2"."YWBMBH", '0', SYSDATE@!, "A2"."OKLRRQ" FROM "TMP_DHDJ"@! "A2" WHERE "A2"."FLOWID_DJ"=:B1
4hps2ntgwt7mz SELECT /*+ ORDERED USE_INDEX(s) USE_NL(s)*/ s.sid, s.serial#, s.username, s.process, l.request, l.block, l.id1, l.id2 FROM v$lock l, v$session s WHERE l.request=0 AND block <> 0 AND l.sid=s.sid AND NOT (l.ID2=0 and l.TYPE='MR')
54rvdwvrhd0wt SELECT /*+ FULL(P) +*/ * FROM "T_JCZDML" P
5k3dxpy9z9ppm SELECT p.name, --CloseCursor (1856332) SUBSTR(quest_soo_pkg.translate_parameter(value), 1, 200) value, NVL(quest_soo_pkg.translate_parameter(value), 0) num_value, p.isdefault FROM v$system_parameter p UNION ALL SELECT 'log_mode', TO_CHAR(DECODE(log_mode, 'ARCHIVELOG', 1, 0)) log_mode, '' num_value, 'TRUE' FROM v$database
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
5vm44sf21vfxr SELECT "A1"."YWYBH" FROM "T_GHDW_YWBM" "A1" WHERE "A1"."GHDWH"=:B2 AND "A1"."YWBMBH"=:B1
5ydynnzwm51pg SELECT /*+ ORDERED USE_INDEX(s) USE_NL(s)*/ s.sid, s.serial#, s.username, s.process, u.name||'.'||o.name name, NVL (lt.name, 'Unknown') lock_type, quest_soo_pkg.lock_mode_decode (l.lmode) mode_held, quest_soo_pkg.lock_mode_decode (l.request) mode_requested, request, block, id1, id2 FROM v$lock l, v$session s, sys.obj$ o, sys.user$ u, v$lock_type lt WHERE (l.request <> 0 ) AND l.sid = s.sid AND u.user#(+) = o.owner# AND o.obj#(+) = s.row_wait_obj# AND lt.type(+)=l.type
5zxpkzmw3ugbr SELECT COUNT(*) FROM "T_DFBJ_SLDQR" "A1" WHERE "A1"."RQH"=:B1 AND (NVL("A1"."YBZBJ", '0')='0' OR TRIM("A1"."GKH")='LT0')
61tn3mam0vq0b 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.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_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(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid 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.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.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 WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
63t3ufgq37m0c SELECT instance_number, instance_name, host_name FROM ( SELECT dbin.instance_number as instance_number, max(dbin.instance_name) as instance_name, max(dbin.host_name) as host_name, sum(case when s.snap_id in (:bid, :eid) then 1 else 0 end) as cnt_edge FROM WRM$_SNAPSHOT s , WRM$_DATABASE_INSTANCE dbin WHERE s.dbid = :dbid AND dbin.instance_number = s.instance_number AND s.snap_id >= :bid AND s.snap_id <= :eid AND dbin.dbid = s.dbid AND dbin.startup_time = s.startup_time GROUP BY dbin.instance_number ) WHERE cnt_edge < 2
69k5bhm12sz98 SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6kqtacs2nk07f INSERT INTO "T_TRANS_DATA_MX" "A1" ("DH", "SBPCH", "YWLX", "DJ_DATE", "YW_FLWOID", "ID", "YWZK", "SYS", "DJSL", "GHDWH", "ZK_CB", "SYLX", "ZJXS", "LSLX", "TRANS_FLOWID", "MXJLS", "MDLX") SELECT "A2"."DH", "A2"."SBPCH", "A2"."YWLX", "A2"."DJ_DATE", "A2"."YW_FLWOID", "A2"."ID", "A2"."YWZK", "A2"."SYS", "A2"."DJSL", "A2"."GHDWH", "A2"."ZK_CB", "A2"."SYLX", "A2"."ZJXS", "A2"."LSLX", "A2"."TRANS_FLOWID", "A2"."MXJLS", :B2 FROM "T_TRANS_DATA_MX"@! "A2" WHERE "A2"."SBPCH"=:B1
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_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(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 WHERE 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
6yva4jbyzfky5 select local_tran_id, state, status, heuristic_dflt, session_vector, reco_vector, global_commit#, type# from pending_trans$ pt where global_tran_fmt = :1 and (global_oracle_id = :2 or global_foreign_id = :3) and session_vector != '00000000' and exists (select * from pending_sessions$ where local_tran_id = pt.local_tran_id and branch_id = :4 and parent_dbid = :5)
7f8f9v6hmpqb5 INSERT INTO "T_WL_BSJH" "A1" ("FLOWID", "ID", "YWBMBH", "KFBH", "CYBH", "CS", "RQ", "YSDJH", "RECEFLAG", "RECEBMBH", "SENDBMBH", "SENDDATE") SELECT "A2"."FLOWID", "A2"."ID", TRIM("A2"."YWBMBH"), TRIM("A2"."KFBH"), TRIM("A2"."CYBH"), "A2"."CS", "A2"."RQ", NVL(TRIM("A2"."YSDJH"), '00'), '0', TRIM("A2"."YWBMBH"), TRIM("A2"."CYBH"), SYSDATE@! FROM "T_BSJH_LSB"@! "A2" WHERE "A2"."YSBBJ"='9'
7tx50ncu1kxgm select INST_ID, REFCOUNT from gv$global_transaction where FORMATID = :1 and (GLOBALID = :2 or GLOBALID = :3) and (BRANCHID = :4 or BRANCHID = :5)
7yaqm2habcbap DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_SX_MAIN_XTW_RUN; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
8190skq31gmpp Select * from table(dbms_workload_repository.awr_report_html( 3951945579, 1, 803, 811, 0))
8dh3fhm51px57 SELECT "A1"."FLOWID", "A1"."FLOWID_DJ", "A1"."DH", "A1"."ID", "A1"."YFSL", "A1"."SYLX", "A1"."QSCLFS", "A1"."RECEFLAG", "A1"."FLAG", "A1"."YFBJ", "A1"."OKSL", "A1"."TPH", "A1"."FLOWID_YFSJ", "A1"."XSZQ", "A1"."SDHRQ", "A1"."ZJXS", "A1"."FHZK", "A1"."YSDJH", "A1"."DJLY", "A1"."WCXDCS", "A1"."PHCS", "A1"."YFSL_BAK", "A1"."CYBH", "A1"."CGYJ_KH", "A1"."THL", "A1"."YXJ", "A1"."TIHFS", "A1"."YQBZQCS", "A1"."FLOWID_YFSJ1", "A1"."ZDDH", "A1"."FHBZ", "A1"."JGBJ" FROM "T_SL_YFSJ" "A1" WHERE "A1"."FLOWID"=:B1 AND "A1"."YFSL">0 AND "A1"."DJLY"='TS'
8fhbd2sf4b5gy INSERT INTO T_DHLS_JX (FLOWID_DJ, FLOWID_DHMX, ID, CYBH, YWBMBH, GHDWH, KFBH, YSDJ, YSRQ, CHYCH, FLOWID_TLDJHZ, THDH, YH, SL, JHFS, LSDZJHBJ, LSDDH, FLOWID_ALLZDSM, ZDQH, ZDXH, FLOWID_JCFYHG, SYLX, JHZK, FHZK, DBBZ, XBBZ, MKZL, YSSL, DJSHSL, PSSL, YJRQ, JZJTRQ, CQJTBL, XSZQ, REMARK, LRCZYBH, OKLRRQ, SHCZYBH, SHQRRQ, SHRQ, DHPCH, ZJXS, SYS, QSSL, USR_IDJB, ZDYJ, FLOWID, YJZSL, GZBJ, QSSY, FGBJ, YWSHBJ, HYLXBH, FGYWYBH, GZFLOWID, YSFLOWID, YSFLOWID_DJ, YSSHRQ, XRRQ, ADDNEW, SSDH) SELECT FLOWID_DJ, FLOWID_DHMX, ID, CYBH, YWBMBH, GHDWH, KFBH, YSDJ, YSRQ, CHYCH, FLOWID_TLDJHZ, THDH, YH, SL, JHFS, :B8 , LSDDH, FLOWID_ALLZDSM, ZDQH, ZDXH, FLOWID_JCFYHG, SYLX, JHZK, FHZK, DBBZ, XBBZ, MKZL, YSSL, DJSHSL, PSSL, YJRQ, JZJTRQ, CQJTBL, XSZQ, REMARK, LRCZYBH, OKLRRQ, SHCZYBH, SHQRRQ, :B4 , DHPCH, ZJXS, SYS, QSSL, :B5 , :B7 , FLOWID, YJZSL, GZBJ, QSSY, '0', YWSHBJ, :B6 , :B5 , NULL, FLOWID_DHMX, FLOWID_DJ, :B4 , SHRQ, :B3 , :B2 FROM T_DHLS_JX@C_LINK_SL_WL WHERE FLOWID_DHMX = :B1
8p9z2ztb272bm SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
8unsu6uwkqwpn Select * from table(dbms_workload_repository.awr_report_html( 3951945579, 1, 809, 811, 0))
92yv7gw4g8b94 SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name
9dhn1b8d88dpf select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9j7p7w49wmys6 SELECT "YWBMBH", "ID", "CBNY", "ZDQH", "ZDXH", "ISBN", "SM", "DJ" FROM "T_JCZDML" "T_JCZDML" WHERE "ISBN"=:1 AND "YWBMBH"=:2
9kag3vp7hqhdq SELECT XZPCH FROM TRANS_BILL_DOWN WHERE XZZT = 'F' AND WHSE_ID = '37090001' GROUP BY XZPCH union SELECT XZPCH FROM ITEM_INTERFACE WHERE XZZT = 'F' AND WHSE_ID = '37090001' GROUP BY XZPCH
aj22x1qd1b243 SELECT file_type, ROUND (mb_used, 2) mb_used, ROUND (mb_reclaimable, 2) mb_reclaimable, DECODE(total_mb, 0, 0, ROUND (mb_used * 100 / total_mb, 2)) percent_space_used, DECODE(total_mb, 0, 0, ROUND (mb_reclaimable * 100 / total_mb, 2)) percent_space_reclaimable, number_of_files, total_mb db_recovery_file_dest_mb, flashback_retention_target, oldest_record, ROUND((sysdate-oldest_record)*24*60, 2) oldest_record_age_sec FROM (SELECT SUM (DECODE (NAME, 'db_recovery_file_dest_size', VALUE / 1048576, 0 ) ) total_mb, SUM (DECODE (NAME, 'db_flashback_retention_target', VALUE, 0) ) flashback_retention_target FROM v$parameter WHERE NAME IN ('db_recovery_file_dest_size', 'db_flashback_retention_target' )), (SELECT 'FLASHBACKLOG' file_type, NVL (SUM (BYTES) / 1048576, 0) mb_used, sum(CASE WHEN last_time <= (sysdate - (tgt.value/1440)) THEN bytes / 1048576 ELSE 0 END ) mb_reclaimable, COUNT (*) number_of_files, MIN (first_time) oldest_record FROM (select bytes, lead(first_time) over(order by first_time asc) last_time, first_time from v$flashback_database_logfile) fla_log, (SELECT quest_soo_pkg.stringToDigit(value) value FROM v$parameter WHERE name = 'db_flashback_retention_target') tgt UNION SELECT 'BACKUPPIECE' file_type, NVL (SUM (BYTES / 1048576), 0) mb, SUM (CASE WHEN dl.rectype = 13 THEN (BYTES / 1048576) ELSE 0 END ) reclaimable_mb, COUNT (*) no_of_files, MIN (start_time) oldest_record FROM v$backup_piece bp, x$kccagf dl WHERE is_recovery_dest_file = 'YES' AND deleted = 'NO' AND bp.recid = dl.recid(+) AND dl.rectype(+) = 13 UNION SELECT 'ARCHIVELOG' file_type, NVL (SUM (blocks * block_size) / 1048576, 0) mb, SUM (CASE WHEN dl.rectype = 11 THEN (LOG.blocks * LOG.block_size / 1048576) ELSE 0 END ) reclaimable_mb, COUNT (*) no_of_files, MIN (first_time) oldest_record FROM v$archived_log log, x$kccagf dl WHERE deleted = 'NO' AND is_recovery_dest_file = 'YES' AND dl.recid(+) = log.recid AND dl.rectype(+) = 11 UNION SELECT 'ONLINELOG' file_type, SUM (BYTES / 1048576) mb, 0 reclaimable, COUNT (*) no_of_files, MIN (first_time) oldest_record FROM v$logfile lf, (SELECT group#, BYTES, first_time FROM v$standby_log UNION SELECT group#, BYTES, first_time FROM v$log) l WHERE l.group# = lf.group# AND lf.is_recovery_dest_file = 'YES' UNION SELECT 'IMAGECOPY', NVL (SUM (blocks * (block_size /1048576 )), 0) mb, 0 reclaimable_mb, COUNT (*) no_of_files, MIN (creation_time) oldest_record FROM v$datafile_copy WHERE deleted = 'NO' AND is_recovery_dest_file = 'YES' UNION SELECT 'CONTROLFILE', NVL (SUM (block_size * file_size_blks) / 1048576, 0) mb, 0 reclaimable, COUNT (*) no_of_files, NULL oldest_record FROM v$controlfile WHERE is_recovery_dest_file = 'YES')
azfanj0gxsc3k SELECT "A1"."DBDH", "A1"."DJLY", "A1"."ZDQH", "A1"."ZDXH", "A1"."ID", "A1"."TDPCH", "A1"."DH", "A1"."TIHFS", "A1"."FHFS", "A1"."JZQX", "A1"."CYBH", "A1"."KFBH", "A1"."YWBMBH", "A1"."SYLX", "A1"."ZJXS", "A1"."SL", "A1"."FHZK", "A1"."DSLX", "A1"."XSDS", "A1"."JSDS", "A1"."CBDS", "A1"."USR_ID", "A1"."BZ", "A1"."CZRQ", "A1"."CSPC", "A1"."FLOWID_DHMX", "A1"."FLOWID_ALL", "A1"."YSBBJ", "A1"."FPXH", "A1"."FSHPCH", "A1"."YFLCS", "A1"."USR_IDPF", "A1"."YXRQ", "A1"."XDCS", "A1"."WCXDCS", "A1"."PHCS", "A1"."YDBDH", "A1"."SPBJ", "A1"."QSCLFS", "A1"."FLOWID_JCFYHG", "A1"."THL", "A1"."WCBJ", "A1"."FHDH", "A1"."SFCSH", "A1"."HW", "A1"."JYXH", "A1"."DBBZ", "A1"."XBBZ", "A1"."FLOWID_FYHG", "A1"."FSLX", "A1"."ZDQH1", "A1"."ZDXH1", "A1"."CSBJ", "A1"."XGBJ", "A1"."OKBJ", "A1"."YSDDLSH", "A1"."CGYJ_KH", "A1"."FHYXJ", "A1"."XSZQ", "A1"."CLOSE_FLAG", "A1"."CQ_FLAG", "A1"."HJDAYS", "A1"."YWSHBJ", "A1"."ZK", "A1"."REASON", "A1"."SPCZYBH", "A1"."SPDATE", "A1"."DJLX", "A1"."LT_FLAG", "A1"."NOTE_GP", "A1"."DDRQ", "A1"."YYDFLAG" FROM "T_DPLS" "A1" WHERE "A1"."TDPCH"=:B2 AND "A1"."DH"=:B1 AND "A1"."ID" IS NOT NULL
b41wak2bb7atw SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :inst_num AND b.snap_id = :begin_snap_id AND e.dbid = :dbid AND e.instance_number = :inst_num AND e.snap_id = :end_snap_id AND e.session_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
bh4zwws4vsz3s SELECT NVL("A1"."NOFHBJ", '0') FROM "T_KCSM_YWBM" "A1" WHERE "A1"."ID"=:B2 AND "A1"."YWBMBH"=:B1
brj0ggnhsncvs UPDATE T_FHMX SET GZBJ_FG='1' WHERE YSDBDH_FG=:B1 AND GZBJ_FG='0'
c6n5fgdrum0hh SELECT "A1"."DH", "A1"."CYBH", "A1"."YWBMBH", "A1"."TDPCH" FROM "T_DPLS" "A1" WHERE "A1"."DJLY"='TH' AND "A1"."ID" IS NOT NULL AND "A1"."TDPCH" IS NOT NULL AND NVL("A1"."OKBJ", '0')='1' AND "A1"."XSDS"-NVL("A1"."XDCS", 0)>0 GROUP BY "A1"."DH", "A1"."CYBH", "A1"."YWBMBH", "A1"."TDPCH"
c8gnrhxma4tas SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
ckyt3atda7nsu SELECT "DJLY", "ZDQH", "ID", "TDPCH", "DH", "CYBH", "YWBMBH", "XSDS", "YXRQ", "XDCS", "QSCLFS", "OKBJ", "CQ_FLAG", "HJDAYS", "YWSHBJ", "LT_FLAG" FROM "T_DPLS" "T_DPLS" WHERE "XSDS"-NVL("XDCS", 0)>0 AND NVL("LT_FLAG", '0')='0' AND NVL("OKBJ", '0')='1' AND (("DJLY"='QS' OR "DJLY"='TD' OR "DJLY"='XP' OR "DJLY"='XQ' OR "DJLY"='YB') OR "YWBMBH"='102' AND "DJLY"<>'TH' AND "DJLY"<>'SY' AND "DJLY"<>'ZY' AND "DJLY"<>'BF' OR "ZDQH" IS NULL AND "DJLY"='QQ') AND "ID" IS NOT NULL AND "YXRQ" IS NOT NULL AND NVL("CQ_FLAG", '0')='0' AND "TDPCH" IS NOT NULL AND NVL("YWSHBJ", '0')='1'
cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ctt6sqgc8004p SELECT * FROM T_WL_SJDHSJ_HZ WHERE RECEFLAG = '0' AND TRIM(RECEBMBH) = TRIM(:B1 ) AND NOT EXISTS (SELECT 1 FROM TMP_DHDJ WHERE FLOWID_DJ=T_WL_SJDHSJ_HZ.FLOWID_DJ )
df03gsnzb7nvy SELECT l.latch#, l.gets, l.misses, l.sleeps, l.immediate_gets, l.spin_gets, COUNT ( * ) n_latches FROM v$latch l, v$latch_children lc WHERE l.latch# = lc.latch#(+) AND l.gets > 0 GROUP BY l.latch#, l.gets, l.misses, l.sleeps, l.immediate_gets, l.spin_gets
dprtygq0grpys Select * from table(dbms_workload_repository.awr_report_html( 3951945579, 1, 808, 811, 0))
dt32x2rbk5fct INSERT INTO "T_SL_YFSJ_BAK" "A1" ("FLOWID", "FLOWID_DJ", "DH", "ID", "YFSL", "SYLX", "QSCLFS", "RECEFLAG", "FLAG", "YFBJ", "OKSL", "TPH", "FLOWID_YFSJ", "XSZQ", "SDHRQ", "ZJXS", "FHZK", "YSDJH", "DJLY", "WCXDCS", "PHCS", "YFSL_BAK", "CYBH", "CGYJ_KH", "THL", "YXJ", "TIHFS", "YQBZQCS", "FLOWID_YFSJ1", "ZDDH", "FHBZ", "JGBJ") SELECT "A2"."FLOWID", "A2"."FLOWID_DJ", "A2"."DH", "A2"."ID", "A2"."YFSL", "A2"."SYLX", "A2"."QSCLFS", "A2"."RECEFLAG", "A2"."FLAG", "A2"."YFBJ", "A2"."OKSL", "A2"."TPH", "A2"."FLOWID_YFSJ", "A2"."XSZQ", "A2"."SDHRQ", "A2"."ZJXS", "A2"."FHZK", "A2"."YSDJH", "A2"."DJLY", "A2"."WCXDCS", "A2"."PHCS", "A2"."YFSL_BAK", "A2"."CYBH", "A2"."CGYJ_KH", "A2"."THL", "A2"."YXJ", "A2"."TIHFS", "A2"."YQBZQCS", "A2"."FLOWID_YFSJ1", "A2"."ZDDH", "A2"."FHBZ", "A2"."JGBJ" FROM "T_SL_YFSJ" "A2" WHERE "A2"."FLOWID_DJ"=:B1
dzsurp56f8aac SELECT COUNT(*) FROM "T_DPLS" "A1" WHERE "A1"."DH"=:B2 AND "A1"."TDPCH"=:B1 AND "A1"."XSDS"-NVL("A1"."XDCS", 0)>0 AND ("A1"."ID" IS NULL OR NVL("A1"."OKBJ", '0')='0' OR "A1"."DH" IS NULL OR "A1"."TDPCH" IS NULL)
f3223cb4ng6hq select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and ((p.instance_id is not null and (to_char(p.instance_id) = :1)) or (p.instance_id is null and p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where bitand(b.flags, :2) <> 0 and lower(b.affinity) = lower(:3)))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and ((q.instance_id is not null and (to_char(q.instance_id) = :4)) or (q.instance_id is null and q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where bitand(c.flags, :5) <> 0 and lower(c.affinity) = lower(:6)))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), j.field1, 0 from sys.job$ j where j.field1 is not null and j.field1 > 0 and j.field1 = :7 and j.this_date is null) a order by 1) where rownum = 1
fmu7z5kfhn55g WITH pm_retention AS (SELECT 'x' x, quest_ppcm_collector.get_ppcm_parameter ( 'PM_SNAPSHOT_RETENTION_DAYS' ) pm_snapshot_retention_days FROM DUAL), pm_job AS (SELECT 'x' x, owner, job_name, CAST (start_date AS date) start_date, CAST (last_start_date AS date) last_start_date, CAST (next_run_date AS date) next_run_date, enabled FROM dba_scheduler_jobs WHERE owner IN (SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL UNION SELECT table_owner FROM user_synonyms WHERE synonym_name = 'QUEST_PPCM_SNAPSHOT') AND job_name = 'QUEST_PPCM_JOB_PM_' || SYS_CONTEXT ('USERENV', 'INSTANCE') UNION ALL SELECT 'x' x, priv_user owner, TO_CHAR (job) job_name, last_date start_date, last_date last_start_date, next_date next_run_date, case when broken='Y' then 'FALSE' else 'TRUE' end enabled FROM dba_jobs WHERE priv_user IN (SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL UNION SELECT table_owner FROM user_synonyms WHERE synonym_name = 'QUEST_PPCM_SNAPSHOT') AND instance = SYS_CONTEXT ('USERENV', 'INSTANCE') AND what = 'BEGIN quest_ppcm_collector.take_snapshot(''PM''); END;') SELECT owner, job_name, start_date, last_start_date, next_run_date, enabled, pm_snapshot_retention_days FROM pm_retention JOIN pm_job ON (pm_retention.X = pm_job.X(+))
fq2smudhvvsu9 SELECT "A1"."ID", "A1"."BB", "A1"."FL", "A1"."CIP", "A1"."LB", "A1"."ISBN", "A1"."SM", "A1"."DJ", "A1"."TM", "A1"."BC", "A1"."YC", "A1"."CBNY", "A1"."BIANZH", "A1"."YIZH", "A1"."DBBZ", "A1"."XBBZ", "A1"."MKZL", "A1"."BBLX", "A1"."NJ", "A1"."NZ", "A1"."XZ", "A1"."ZFK", "A1"."SPLX", "A1"."SPTZ", "A1"."ZT", "A1"."YWRYH", "A1"."FJW", "A1"."FIRSTDHRQ", "A1"."LASTDHRQ", "A1"."JTJZRQ", "A1"."SL", "A1"."PJZK", "A1"."PJJJ", "A1"."SYLX", "A1"."PXDZ", "A1"."PXDJ", "A1"."FHZK", "A1"."FHJG", "A1"."JMBZ", "A1"."THBJ", "A1"."GDDZDJBZ", "A1"."GDZKBJ", "A1"."WZ", "A1"."KB", "A1"."ZZ", "A1"."DJFW_BH", "A1"."PRN_TM", "A1"."TM_YB", "A1"."YSBBJ", "A1"."KZXSBJ", "A1"."YXBZ", "A1"."GHDWH", "A1"."NIAN", "A1"."FL1", "A1"."FL2", "A1"."FL3", "A1"."CBZB", "A1"."FXZB", "A1"."KMFL", "A1"."BCFL", "A1"."MFJCBJ", "A1"."FHFS", "A1"."JCNF", "A1"."JCJSLX", "A1"."SM_CS", "A1"."SM_FCS", "A1"."SM_BL", "A1"."YX", "A1"."YFBBJ", "A1"."LSJ", "A1"."TSBJ", "A1"."JSBJ", "A1"."JSLX", "A1"."ZL", "A1"."TJ", "A1"."CHANGDU", "A1"."KUANDU", "A1"."GAODU", "A1"."PRN_TM_YB", "A1"."CZCYCS", "A1"."TGYZ", "A1"."GYSSPID", "A1"."SPDM", "A1"."YSXLH", "A1"."YWFL", "A1"."MODIFY_DATE", "A1"."REF_ID" FROM "T_KCSM" "A1" WHERE "A1"."MODIFY_DATE">:B1
g7zbdn5dambm9 SELECT DISTINCT PFPCH FROM TM_DHGZ_LSD WHERE NOT EXISTS (SELECT 1 FROM T_SL_GZJH_HZ WHERE TRIM(GZJHDH) = TRIM(TM_DHGZ_LSD.PFPCH) AND DH = TM_DHGZ_LSD.DH)
gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
ggu8pr7gjt8h2 UPDATE T_XHD_XHQPMX SET CHANGE1 = '0' WHERE FLOWID_MX = :B1

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 16 0.00 0.01
Batched IO (full) vector count 0 0.00 0.00
Batched IO block miss count 168 0.05 0.06
Batched IO buffer defrag count 0 0.00 0.00
Batched IO double miss count 8 0.00 0.00
Batched IO same unit count 86 0.02 0.03
Batched IO single block count 7 0.00 0.00
Batched IO slow jump count 0 0.00 0.00
Batched IO vector block count 75 0.02 0.03
Batched IO vector read count 17 0.00 0.01
Block Cleanout Optim referenced 498 0.14 0.17
CCursor + sql area evicted 0 0.00 0.00
CPU used by this session 488,528 134.51 171.23
CPU used when call started 251,885 69.35 88.29
CR blocks created 3,938 1.08 1.38
Cached Commit SCN referenced 194,330 53.51 68.11
Clusterwide global transactions 8,609 2.37 3.02
Clusterwide global transactions spanning RAC nodes 2,089 0.58 0.73
Commit SCN cached 357 0.10 0.13
DB time 591,625 162.89 207.37
DBWR checkpoint buffers written 15,246 4.20 5.34
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 4,840 1.33 1.70
DBWR object drop buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 3,828 1.05 1.34
DBWR undo block writes 6,520 1.80 2.29
DFO trees parallelized 2,104 0.58 0.74
DX/BB enqueue lock background get time 346 0.10 0.12
DX/BB enqueue lock background gets 13,998 3.85 4.91
DX/BB enqueue lock foreground requests 3,719,299 1,024.04 1,303.64
DX/BB enqueue lock foreground wait time 6,484 1.79 2.27
Effective IO time 55,839 15.37 19.57
GTX processes spawned by autotune 4 0.00 0.00
GTX processes stopped by autotune 3 0.00 0.00
HSC Heap Segment Block Changes 36,213 9.97 12.69
HSC IDL Compressed Blocks 0 0.00 0.00
Heap Segment Array Inserts 549 0.15 0.19
Heap Segment Array Updates 818 0.23 0.29
LOB table id lookup cache misses 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
Number of read IOs issued 49 0.01 0.02
PX local messages recv'd 8,802 2.42 3.09
PX local messages sent 8,802 2.42 3.09
PX remote messages recv'd 4,233 1.17 1.48
PX remote messages sent 4,232 1.17 1.48
Parallel operations not downgraded 2,104 0.58 0.74
Requests to/from client 1,395,357 384.18 489.08
RowCR - row contention 4 0.00 0.00
RowCR attempts 4,682 1.29 1.64
RowCR hits 4,797 1.32 1.68
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 4 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 1,395,363 384.19 489.09
SQL*Net roundtrips to/from dblink 9,674 2.66 3.39
TBS Extension: bytes extended 0 0.00 0.00
TBS Extension: files extended 0 0.00 0.00
TBS Extension: tasks created 0 0.00 0.00
TBS Extension: tasks executed 0 0.00 0.00
active txn count during cleanout 4,333 1.19 1.52
application wait time 5,929 1.63 2.08
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 52,401 14.43 18.37
branch node splits 0 0.00 0.00
buffer is not pinned count 2,777,208 764.65 973.43
buffer is pinned count 3,830,376 1,054.62 1,342.58
bytes received via SQL*Net from client 394,657,668 108,661.40 138,330.76
bytes received via SQL*Net from dblink 2,110,499 581.09 739.75
bytes sent via SQL*Net to client 594,025,030 163,553.37 208,210.67
bytes sent via SQL*Net to dblink 3,788,883 1,043.20 1,328.03
calls to get snapshot scn: kcmgss 2,743,801 755.45 961.72
calls to kcmgas 50,609 13.93 17.74
calls to kcmgcs 30,931 8.52 10.84
cell physical IO interconnect bytes 727,836,672 200,395.84 255,112.75
change write time 286 0.08 0.10
cleanout - number of ktugct calls 5,464 1.50 1.92
cleanouts and rollbacks - consistent read gets 3,349 0.92 1.17
cleanouts only - consistent read gets 1,412 0.39 0.49
cluster key scan block gets 21,648 5.96 7.59
cluster key scans 21,593 5.95 7.57
cluster wait time 5,058 1.39 1.77
commit batch performed 16 0.00 0.01
commit batch requested 16 0.00 0.01
commit batch/immediate performed 33 0.01 0.01
commit batch/immediate requested 33 0.01 0.01
commit cleanout failures: block lost 52 0.01 0.02
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 26 0.01 0.01
commit cleanout failures: cannot pin 1 0.00 0.00
commit cleanouts 20,322 5.60 7.12
commit cleanouts successfully completed 20,243 5.57 7.10
commit immediate performed 17 0.00 0.01
commit immediate requested 17 0.00 0.01
commit txn count during cleanout 4,722 1.30 1.66
concurrency wait time 309 0.09 0.11
consistent changes 1,821,813 501.60 638.56
consistent gets 6,699,295 1,844.52 2,348.16
consistent gets - examination 1,901,850 523.64 666.61
consistent gets direct 49 0.01 0.02
consistent gets from cache 6,699,246 1,844.51 2,348.14
consistent gets from cache (fastpath) 4,641,878 1,278.05 1,627.02
cursor authentications 298 0.08 0.10
data blocks consistent reads - undo records applied 11,789 3.25 4.13
db block changes 2,107,744 580.33 738.78
db block gets 5,764,519 1,587.15 2,020.51
db block gets direct 44 0.01 0.02
db block gets from cache 5,764,475 1,587.14 2,020.50
db block gets from cache (fastpath) 90,779 24.99 31.82
deferred (CURRENT) block cleanout applications 11,742 3.23 4.12
enqueue conversions 20,780 5.72 7.28
enqueue deadlocks 0 0.00 0.00
enqueue releases 21,397,686 5,891.44 7,500.07
enqueue requests 21,397,702 5,891.45 7,500.07
enqueue timeouts 24 0.01 0.01
enqueue waits 23,046 6.35 8.08
exchange deadlocks 0 0.00 0.00
execute count 545,310 150.14 191.14
failed probes on index block reclamation 0 0.00 0.00
file io wait time 6,064,110 1,669.64 2,125.52
free buffer inspected 201 0.06 0.07
free buffer requested 541,604 149.12 189.84
gc blocks compressed 6,644 1.83 2.33
gc blocks lost 0 0.00 0.00
gc cr block flush time 321 0.09 0.11
gc cr block receive time 4,333 1.19 1.52
gc cr blocks received 99,447 27.38 34.86
gc cr blocks served 13,185 3.63 4.62
gc current block flush time 1,030,787 283.81 361.30
gc current block pin time 1,975,694 543.97 692.50
gc current block receive time 421 0.12 0.15
gc current blocks received 8,407 2.31 2.95
gc current blocks served 13,734 3.78 4.81
gc kbytes saved 23,872 6.57 8.37
gc kbytes sent 191,478 52.72 67.11
gc local grants 2,031 0.56 0.71
gc read wait time 0 0.00 0.00
gc read waits 0 0.00 0.00
gc remote grants 5,026 1.38 1.76
gcs messages sent 149,229 41.09 52.31
ges messages sent 9,104,752 2,506.82 3,191.29
global enqueue get time 56,543 15.57 19.82
global enqueue gets async 1,606 0.44 0.56
global enqueue gets sync 25,486,051 7,017.09 8,933.07
global enqueue releases 23,717,074 6,530.04 8,313.03
heap block compress 1,938 0.53 0.68
hot buffers moved to head of LRU 0 0.00 0.00
immediate (CR) block cleanout applications 4,761 1.31 1.67
immediate (CURRENT) block cleanout applications 1,775 0.49 0.62
in call idle wait time 23,542,521 6,481.98 8,251.85
index crx upgrade (positioned) 60 0.02 0.02
index fast full scans (full) 98 0.03 0.03
index fetch by key 584,652 160.97 204.93
index scans kdiixs1 52,609 14.48 18.44
leaf node 90-10 splits 12 0.00 0.00
leaf node splits 119 0.03 0.04
lob reads 693,564 190.96 243.10
lob writes 538,125 148.16 188.62
lob writes unaligned 538,125 148.16 188.62
logical read bytes from cache 102,102,802,432 28,112,043.78 35,787,873.27
logons cumulative 5,260 1.45 1.84
max cf enq hold time 20 0.01 0.01
messages received 66,703 18.37 23.38
messages sent 66,703 18.37 23.38
min active SCN optimization applied on CR 299 0.08 0.10
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 3,814,413 1,050.23 1,336.98
non-idle wait count 29,206,493 8,041.45 10,237.12
non-idle wait time 639,489 176.07 224.15
opened cursors cumulative 551,230 151.77 193.21
parse count (describe) 6 0.00 0.00
parse count (failures) 25 0.01 0.01
parse count (hard) 700 0.19 0.25
parse count (total) 14,886 4.10 5.22
parse time cpu 1,084 0.30 0.38
parse time elapsed 1,096 0.30 0.38
physical read IO requests 117 0.03 0.04
physical read bytes 974,848 268.41 341.69
physical read total IO requests 19,595 5.40 6.87
physical read total bytes 430,860,288 118,629.10 151,020.08
physical read total multi block requests 177 0.05 0.06
physical reads 119 0.03 0.04
physical reads cache 70 0.02 0.02
physical reads cache prefetch 2 0.00 0.00
physical reads direct 49 0.01 0.02
physical reads direct (lob) 49 0.01 0.02
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 14,399 3.96 5.05
physical write bytes 146,923,520 40,452.57 51,497.90
physical write total IO requests 52,861 14.55 18.53
physical write total bytes 296,976,384 81,766.74 104,092.67
physical write total multi block requests 106 0.03 0.04
physical writes 17,935 4.94 6.29
physical writes direct 44 0.01 0.02
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 10 0.00 0.00
physical writes from cache 17,891 4.93 6.27
physical writes non checkpoint 5,842 1.61 2.05
pinned buffers inspected 0 0.00 0.00
pinned cursors current 0 0.00 0.00
prefetch clients - default 2 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 3,565 0.98 1.25
queries parallelized 2,104 0.58 0.74
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 337,648 92.96 118.35
recursive cpu usage 5,983 1.65 2.10
redo KB read 0 0.00 0.00
redo blocks checksummed by FG (exclusive) 9,784 2.69 3.43
redo blocks written 98,504 27.12 34.53
redo buffer allocation retries 0 0.00 0.00
redo entries 182,659 50.29 64.02
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 3,245 0.89 1.14
redo size 43,969,960 12,106.28 15,411.83
redo size for direct writes 279,752 77.02 98.06
redo subscn max counts 5,168 1.42 1.81
redo synch long waits 2 0.00 0.00
redo synch time 599 0.16 0.21
redo synch time (usec) 6,500,845 1,789.88 2,278.60
redo synch writes 12,817 3.53 4.49
redo wastage 4,516,720 1,243.59 1,583.15
redo write broadcast ack count 1,733 0.48 0.61
redo write broadcast ack time 8,680,118 2,389.90 3,042.45
redo write broadcast lgwr post count 1 0.00 0.00
redo write time 806 0.22 0.28
redo writes 17,587 4.84 6.16
remote Oradebug requests 1 0.00 0.00
rollback changes - undo records applied 30,423 8.38 10.66
rollbacks only - consistent read gets 644 0.18 0.23
root node splits 0 0.00 0.00
rows fetched via callback 458,058 126.12 160.55
session connect time 0 0.00 0.00
session cursor cache hits 536,502 147.72 188.05
session logical reads 12,463,814 3,431.67 4,368.67
shared hash latch upgrades - no wait 24,422 6.72 8.56
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 12,808 3.53 4.49
sorts (rows) 349,537,757 96,238.50 122,515.86
sql area evicted 0 0.00 0.00
sql area purged 29 0.01 0.01
switch current to new buffer 2,078 0.57 0.73
table fetch by rowid 2,852,253 785.31 999.74
table fetch continued row 18,556 5.11 6.50
table scan blocks gotten 2,791,926 768.70 978.59
table scan rows gotten 111,242,661 30,628.53 38,991.47
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (short tables) 8,083 2.23 2.83
temp space allocated (bytes) 0 0.00 0.00
total cf enq hold time 370 0.10 0.13
total number of cf enq holders 99 0.03 0.03
total number of times SMON posted 7 0.00 0.00
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 33 0.01 0.01
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 12,398,528 3,413.70 4,345.79
user I/O wait time 48 0.01 0.02
user calls 2,359,528 649.65 827.03
user commits 2,842 0.78 1.00
user rollbacks 11 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 10,891 3.00 3.82
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
opened cursors current 264 252
workarea memory allocated 37,389 37,389
logons current 175 168
session uga memory max 174,882,601,024 176,237,201,496
session pga memory 12,803,821,152 12,851,072,896
session pga memory max 17,289,797,152 17,352,663,520
session cursor cache count 956,222 965,019
session uga memory 18,518,225,159,480 18,587,214,316,104

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Waits: Count Avg Tm(ms)
Others 410M 5.36 .112885 47M 0.83 .012940 21K 0.34
DBWR 0M 0.00 0M 139M 3.96 .038270 0  
LGWR 0M 0.00 0M 95M 9.76 .026156 17.6K 0.01
Buffer Cache Reads 1M 0.02 .000275 0M 0.00 0M 68 1.21
Direct Reads 1M 0.01 .000275 0M 0.00 0M 0  
Direct Writes 0M 0.00 0M 0M 0.00 0M 0  
TOTAL: 412M 5.39 .113436 281M 14.54 .077367 38.6K 0.19

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
Control File 410M 5.35 .112885 47M 0.82 .012940 0.28 9.58
Data File 2M 0.04 .000550 140M 3.96 .038546 0.93  
Log File 0M 0.00 0M 95M 9.76 .026156    
Temp File 0M 0.00 0M 0M 0.00 0M 0.00  
TOTAL: 412M 5.39 .113436 282M 14.54 .077643 0.29 9.58

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)
Others 409M 5.36 .112610 47M 0.83 .012940 19.5K 0.37
Others (Control File) 409M 5.35 .112610 47M 0.82 .012940 19.4K 0.37
Others (Data File) 0M 0.01 0M 0M 0.00 0M 35 0.57
DBWR 0M 0.00 0M 139M 3.96 .038270 0  
DBWR (Data File) 0M 0.00 0M 139M 3.96 .038270 0  
LGWR 0M 0.00 0M 95M 9.76 .026156 0  
LGWR (Log File) 0M 0.00 0M 95M 9.76 .026156 0  
Buffer Cache Reads 1M 0.02 .000275 0M 0.00 0M 68 1.21
Buffer Cache Reads (Data File) 1M 0.02 .000275 0M 0.00 0M 68 1.21
Direct Reads 1M 0.01 .000275 0M 0.00 0M 0  
Direct Reads (Data File) 1M 0.01 .000275 0M 0.00 0M 0  
Direct Writes 0M 0.00 0M 0M 0.00 0M 0  
Direct Writes (Data File) 0M 0.00 0M 0M 0.00 0M 0  
TOTAL: 411M 5.39 .113160 281M 14.54 .077367 19.5K 0.37

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)
UNDOTBS1 0 0 0.00 0.00 7,390 2 0 0.00
DATA_TABLESPACE 0 0 0.00 0.00 3,745 1 0 0.00
INDEX_TABLESPACE 0 0 0.00 0.00 2,381 1 0 0.00
SYSAUX 77 0 0.00 1.00 437 0 0 0.00
SYSTEM 32 0 2.50 1.00 329 0 2 0.00
USERS 0 0 0.00 0.00 105 0 0 0.00
TEMP 8 0 0.00 1.25 8 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)
DATA_TABLESPACE +DATA/sdsldb/datafile/data_tablespace.270.799515515 0 0     3,745 1 0 0.00
INDEX_TABLESPACE +DATA/sdsldb/datafile/index_tablespace.271.799515937 0 0     2,381 1 0 0.00
SYSAUX +DATA/sdsldb/datafile/sysaux.257.799499661 77 0 0.00 1.00 437 0 0 0.00
SYSTEM +DATA/sdsldb/datafile/system.256.799499661 32 0 2.50 1.00 329 0 2 0.00
TEMP +DATA/sdsldb/tempfile/temp.264.799499773 8 0 0.00 1.25 8 0 0  
UNDOTBS1 +DATA/sdsldb/datafile/undotbs1.258.799499663 0 0     7,390 2 0 0.00
USERS +DATA/sdsldb/datafile/users.259.799499663 0 0     105 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 25,771,722 100 12,465,129 70 17,891 0 0 2

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 15,245 0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual RedoBlks Target RedoBlks Log Sz RedoBlks Log Ckpt Timeout RedoBlks Log Ckpt Interval RedoBlks Opt Log Sz(M) Estd RAC Avail Time
B 0 1 1728 11480 49471 1698651 49471     0
E 0 0 913 4594 41830 1698651 41830     0

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers (thousands) Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time Est %DBtime for Rds
D 21,504 0.10 2,541 1.02 1,674 1 1218.00
D 43,008 0.20 5,082 1.00 1,637 1 1147.00
D 64,512 0.30 7,623 1.00 1,637 1 1147.00
D 86,016 0.39 10,163 1.00 1,637 1 1147.00
D 107,520 0.49 12,704 1.00 1,637 1 1147.00
D 129,024 0.59 15,245 1.00 1,637 1 1147.00
D 150,528 0.69 17,786 1.00 1,637 1 1147.00
D 172,032 0.79 20,327 1.00 1,637 1 1147.00
D 193,536 0.89 22,868 1.00 1,637 1 1147.00
D 215,040 0.99 25,409 1.00 1,637 1 1147.00
D 218,112 1.00 25,772 1.00 1,637 1 1147.00
D 236,544 1.08 27,950 1.00 1,637 1 1147.00
D 258,048 1.18 30,490 1.00 1,637 1 1147.00
D 279,552 1.28 33,031 1.00 1,637 1 1147.00
D 301,056 1.38 35,572 1.00 1,637 1 1147.00
D 322,560 1.48 38,113 1.00 1,637 1 1147.00
D 344,064 1.58 40,654 1.00 1,637 1 1147.00
D 365,568 1.68 43,195 1.00 1,637 1 1147.00
D 387,072 1.77 45,736 1.00 1,637 1 1147.00
D 408,576 1.87 48,277 1.00 1,637 1 1147.00
D 430,080 1.97 50,817 1.00 1,637 1 1147.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 9,093 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 150,000 134,329 900.34 36.51 4.06 100.00 0.00 1,048,576
E 150,000 134,331 900.66 36.51 4.05 100.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 8,096 8,096 0 0
64K 128K 548 548 0 0
128K 256K 72 72 0 0
256K 512K 18 18 0 0
512K 1024K 1,547 1,547 0 0
1M 2M 450 450 0 0
4M 8M 2 2 0 0
32M 64M 158 158 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
18,750 0.13 713,716.88 7,232.55 99.00 0 19,083,161
37,500 0.25 713,716.88 7,232.55 99.00 0 19,083,161
75,000 0.50 713,716.88 7,232.55 99.00 0 19,083,161
112,500 0.75 713,716.88 7,232.55 99.00 0 19,083,161
150,000 1.00 713,716.88 7,232.55 99.00 0 19,083,161
180,000 1.20 713,716.88 2,146.39 100.00 0 18,948,533
210,000 1.40 713,716.88 2,146.39 100.00 0 18,948,533
240,000 1.60 713,716.88 2,146.39 100.00 0 18,948,533

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)
15,360 0.60 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
17,920 0.70 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
20,480 0.80 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
20,992 0.82 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
21,504 0.84 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
22,016 0.86 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
22,528 0.88 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
23,040 0.90 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
23,552 0.92 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
24,064 0.94 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
24,576 0.96 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
25,088 0.98 1,680 60,996 2,448,643 1.00 6,960 1.00 124,641
25,600 1.00 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
26,112 1.02 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
26,624 1.04 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
27,136 1.06 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
27,648 1.08 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
28,160 1.10 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
28,672 1.12 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
29,184 1.14 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
29,696 1.16 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
30,208 1.18 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
30,720 1.20 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
33,280 1.30 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
35,840 1.40 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
38,400 1.50 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
40,960 1.60 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
43,520 1.70 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
46,080 1.80 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
48,640 1.90 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660
51,200 2.00 1,680 60,996 2,448,643 1.00 6,960 1.00 124,660

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
46,944 0.19 202,905 1,673,737
62,592 0.25 202,824 1,636,907
78,240 0.31 202,824 1,636,907
93,888 0.38 202,824 1,636,907
109,536 0.44 202,824 1,636,907
125,184 0.50 202,824 1,636,907
140,832 0.56 202,824 1,636,907
156,480 0.63 202,824 1,636,907
172,128 0.69 202,825 1,636,907
187,776 0.75 202,825 1,636,907
203,424 0.81 202,825 1,636,907
219,072 0.88 202,825 1,636,907
234,720 0.94 202,825 1,636,907
250,368 1.00 202,822 1,636,907
266,016 1.06 202,825 1,636,907
281,664 1.13 202,825 1,636,907
297,312 1.19 202,825 1,636,907
312,960 1.25 202,825 1,636,907
328,608 1.31 202,825 1,636,907
344,256 1.38 202,825 1,636,907
359,904 1.44 202,825 1,636,907
375,552 1.50 202,825 1,636,907
391,200 1.56 202,825 1,636,907
406,848 1.63 202,825 1,636,907
422,496 1.69 202,825 1,636,907
438,144 1.75 202,825 1,636,907
453,792 1.81 202,825 1,636,907
469,440 1.88 202,825 1,636,907
485,088 1.94 202,825 1,636,907
500,736 2.00 202,825 1,636,907

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)
512 0.50 0 0 0 0
1,024 1.00 0 0 0 0
1,536 1.50 0 0 0 0
2,048 2.00 0 0 0 0
2,560 2.50 0 0 0 0
3,072 3.00 0 0 0 0
3,584 3.50 0 0 0 0
4,096 4.00 0 0 0 0
4,608 4.50 0 0 0 0
5,120 5.00 0 0 0 0
5,632 5.50 0 0 0 0
6,144 6.00 0 0 0 0
6,656 6.50 0 0 0 0
7,168 7.00 0 0 0 0
7,680 7.50 0 0 0 0
8,192 8.00 0 0 0 0
8,704 8.50 0 0 0 0
9,216 9.00 0 0 0 0
9,728 9.50 0 0 0 0
10,240 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 1 0 0
system undo block 1 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)
TX-Transaction (row lock contention) 1 0 1 1 59 59,180.00
US-Undo Segment 21,247,015 21,247,014 0 17,171 7 0.39
TX-Transaction 13,781 13,781 0 3,576 2 0.51
PS-PX Process Reservation 14,724 14,711 13 2,131 2 0.80
TM-DML 12,850 12,850 0 7 0 11.43
CF-Controlfile Transaction 7,987 7,987 0 69 0 1.01
JS-Job Scheduler (queue lock) 32,509 32,509 0 5 0 8.00
WF-AWR Flush 22 22 0 21 0 0.48
JQ-Job Queue 18 9 9 11 0 0.91
TA-Instance Undo 14 14 0 12 0 0.00
HW-Segment High Water Mark 30,944 30,944 0 7 0 0.00
TD-KTF map table enqueue (KTF dump entries) 10 10 0 7 0 0.00
TO-Temp Object 58 58 0 6 0 0.00
TT-Tablespace 1,740 1,740 0 5 0 0.00
JS-Job Scheduler (job run lock - synchronize) 9 9 0 4 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
PI-Remote PX Process Spawn Status 4 4 0 2 0 0.00
UL-User-defined 4 4 0 2 0 0.00
AE-Edition Lock (lock) 658 658 0 1 0 0.00
AF-Advisor Framework (task serialization) 13 13 0 1 0 0.00
CR-Reuse Block Range (block range reuse ckpt) 13,698 13,698 0 1 0 0.00
FB-Format Block 7 7 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 3.26 4,931 1,687 124 180/180 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-Dec 10:59 123 252 957 5 180 0/0 0/0/0/0/0/0
21-Dec 10:49 479 658 854 5 180 0/0 0/0/0/0/0/0
21-Dec 10:39 643 940 1,404 105 180 0/0 0/0/0/0/0/0
21-Dec 10:29 104 376 1,680 3 180 0/0 0/0/0/0/0/0
21-Dec 10:19 966 1,153 1,687 113 180 0/0 0/0/0/0/0/0
21-Dec 10:09 948 1,552 1,123 124 180 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 89 0.00   0 0  
AQ dequeue txn counter latch 120 0.00   0 0  
ASM Keyed state latch 6,281 0.00   0 0  
ASM allocation 146 0.00   0 0  
ASM db client latch 5,970 0.00   0 0  
ASM map operation freelist 88 0.00   0 0  
ASM map operation hash table 146,917 0.00   0 0  
ASM network background latch 2,259 0.00   0 0  
ASM network state latch 256 0.00   0 0  
AWR Alerted Metric Element list 35,914 0.00   0 0  
Change Notification Hash table latch 1,201 0.00   0 0  
Consistent RBA 17,585 0.00   0 0  
DML lock allocation 220,469,888 0.00 0.00 0 0  
Event Group Locks 8,489 0.00   0 0  
FAL Queue 97 0.00   0 0  
FIB s.o chain latch 8 0.00   0 0  
FOB s.o list latch 1,613 0.00   0 0  
File State Object Pool Parent Latch 89 0.00   0 0  
I/O Staticstics latch 89 0.00   0 0  
IPC other latch 30 0.00   0 0  
IPC stats buffer allocation latch 12,069 0.00   0 12,039 0.00
In memory undo latch 89 0.00   0 0  
JS Sh mem access 99 0.00   0 0  
JS broadcast add buf latch 1,906 0.00   0 0  
JS broadcast autostart latch 5 0.00   0 0  
JS broadcast drop buf latch 1,907 0.00   0 0  
JS broadcast load blnc latch 1,796 0.00   0 0  
JS mem alloc latch 19 0.00   0 0  
JS queue access latch 108 0.00   0 0  
JS queue state obj latch 65,018 0.00   0 0  
JS slv state obj latch 184 0.00   0 0  
KFC FX Hash Latch 89 0.00   0 0  
KFC Hash Latch 89 0.00   0 0  
KFCL LE Freelist 89 0.00   0 0  
KFK SGA Libload latch 1,022 0.00   0 0  
KFMD SGA 4 0.00   0 0  
KGNFS-NFS:SHM structure 89 0.00   0 0  
KGNFS-NFS:SVR LIST 89 0.00   0 0  
KJC message pool free list 10,039 0.01 0.00 0 13,592 0.00
KJCT flow control latch 18,275,685 0.00 0.01 0 0  
KMG MMAN ready and startup request latch 1,210 0.00   0 0  
KSXR large replies 244 0.00   0 0  
KTF sga latch 32 0.00   0 957 0.00
KWQMN job cache list latch 256 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
KWQS pqueue ctx latch 2 0.00   0 0  
Locator state objects pool parent latch 89 0.00   0 0  
Lsod array latch 40,984 0.00   0 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 89 0.00   0 1,210 0.00
Memory Queue 89 0.00   0 0  
Memory Queue Message Subscriber #1 89 0.00   0 0  
Memory Queue Message Subscriber #2 89 0.00   0 0  
Memory Queue Message Subscriber #3 89 0.00   0 0  
Memory Queue Message Subscriber #4 89 0.00   0 0  
Memory Queue Subscriber 89 0.00   0 0  
MinActiveScn Latch 2,480 0.00   0 0  
Mutex 89 0.00   0 0  
Mutex Stats 89 0.00   0 0  
OS process 13,032 0.00   0 0  
OS process allocation 13,805 0.00   0 0  
OS process: request allocation 6,283 0.00   0 0  
PL/SQL warning settings 5,497 0.00   0 0  
PX hash array latch 89 0.00   0 0  
QMT 89 0.00   0 0  
Real-time plan statistics latch 17,352 0.00   0 0  
Result Cache: RC Latch 78 0.00   0 0  
SGA blob parent 89 0.00   0 0  
SGA bucket locks 89 0.00   0 0  
SGA heap locks 89 0.00   0 0  
SGA pool locks 89 0.00   0 0  
SQL memory manager latch 7 0.00   0 1,208 0.00
SQL memory manager workarea list latch 214,399 0.00   0 0  
Shared B-Tree 220 0.00   0 0  
Streams Generic 89 0.00   0 0  
Testing 89 0.00   0 0  
Token Manager 89 0.00   0 0  
WCR: sync 89 0.00   0 0  
Write State Object Pool Parent Latch 89 0.00   0 0  
X$KSFQP 56 0.00   0 0  
XDB NFS Security Latch 89 0.00   0 0  
XDB unused session pool 89 0.00   0 0  
XDB used session pool 89 0.00   0 0  
active checkpoint queue latch 40,290 0.06 0.00 0 0  
active service list 187,131 0.00 0.25 0 13,043 0.02
archive control 340 0.00   0 0  
archive process latch 291 0.00   0 0  
begin backup scn array 2 0.00   0 0  
buffer pool 89 0.00   0 0  
business card 4,297 0.00   0 0  
cache buffer handles 304 0.00   0 0  
cache buffers chains 27,954,878 0.00 0.00 0 549,876 0.04
cache buffers lru chain 159,107 0.00   0 1,700,631 0.00
cache table scan latch 0     0 2 0.00
call allocation 16,192 0.01 0.00 0 0  
cas latch 89 0.00   0 0  
change notification client cache latch 89 0.00   0 0  
channel handle pool latch 6,408 0.00   0 0  
channel operations parent latch 1,645,858 0.01 0.00 0 0  
checkpoint queue latch 5,608,729 0.00   0 18,988 0.00
client/application info 20,052 0.00   0 0  
compile environment latch 5,263 0.00   0 0  
corrupted undo seg latch 93,379 0.00   0 0  
cp cmon/server latch 89 0.00   0 0  
cp pool latch 89 0.00   0 0  
cp server hash latch 89 0.00   0 0  
cp sga latch 58 0.00   0 0  
cvmap freelist lock 89 0.00   0 0  
deferred cleanup latch 58 0.00   0 0  
dml lock allocation 58 0.00   0 0  
done queue latch 89 0.00   0 0  
dummy allocation 10,622 0.00   0 0  
enqueue freelist latch 89 0.00   0 42,745,707 0.00
enqueue hash chains 85,475,947 0.00 0.01 0 6,765 0.00
enqueues 139 0.00   0 0  
error message lists 10,500 0.00   0 0  
fifth spare latch 89 0.00   0 0  
file cache latch 2,686 0.00   0 0  
flashback copy 89 0.00   0 0  
fourth Audit Vault latch 89 0.00   0 0  
gc element 415,895 0.00 0.00 0 12,479 0.00
gcs commit scn state 89 0.00   0 0  
gcs opaque info freelist 37,502 0.11 0.00 0 0  
gcs partitioned table hash 5,624,055 0.01 0.00 0 5,775 0.00
gcs pcm hashed value bucket hash 89 0.00   0 0  
gcs remaster request queue 42 0.00   0 0  
gcs resource freelist 189 0.00   0 649 0.00
gcs resource hash 343,361 0.01 0.00 0 0  
gcs resource scan list 89 0.00   0 0  
gcs shadows freelist 5,834 0.00   0 11,476 0.00
ges caches resource lists 12,694,539 0.19 0.01 0 9,117,480 0.02
ges deadlock list 666 0.00   0 28 0.00
ges domain table 42,751,225 0.00 0.00 0 0  
ges enqueue table freelist 48,266,209 0.00 0.00 0 0  
ges group table 50,225,406 0.00 0.00 0 0  
ges process hash list 10,745,489,264 0.00 0.23 1 0  
ges process parent latch 98,320,152 0.00 0.33 0 0  
ges process table freelist 6,283 0.00   0 0  
ges resource hash list 121,979,433 0.03 0.14 0 262,837 0.07
ges resource scan list 7,947 0.00   0 0  
ges resource table freelist 215,488 0.00   0 0  
ges timeout list 19,052 0.00   0 148,695 0.00
ges value block free list 4,722,581 0.02 0.00 0 0  
global KZLD latch for mem in SGA 3,061 0.00   0 0  
global tx hash mapping 2,370,319 0.00 0.00 0 1,840 0.00
granule operation 89 0.00   0 0  
hash table column usage latch 226 0.00   0 196,090 0.00
hash table modification latch 118 0.00   0 0  
heartbeat check 89 0.00   0 1,940 0.00
heartbeat structure management 0     0 726 0.00
internal temp table object number allocation latch 62 0.00   0 0  
interrupt manipulation 18,980 0.00   0 0  
intra txn parallel recovery 89 0.00   0 0  
io pool granule metadata list 89 0.00   0 0  
job workq parent latch 115 0.00   0 26 0.00
job_queue_processes free list latch 66 0.00   0 0  
job_queue_processes parameter latch 1,871 0.00   0 0  
k2q global data latch 39,318 0.00   0 0  
k2q lock allocation 4,684,575 0.00 0.00 0 0  
kdlx hb parent latch 89 0.00   0 0  
kgb parent 89 0.00   0 0  
kgnfs mount latch 89 0.00   0 0  
kokc descriptor allocation latch 22 0.00   0 0  
ksfv messages 89 0.00   0 0  
ksim group membership cache 4,529 0.00   0 0  
ksim membership request latch 0     0 2,730 0.00
kss move lock 129 0.00   0 0  
ksuosstats global area 384 0.00   0 0  
ksv allocation latch 138 0.00   0 0  
ksv class latch 7,506 0.00   0 0  
ksv instance latch 20 0.00   0 0  
ksv msg queue latch 89 0.00   0 0  
ksxp shared latch 6,283 0.00   0 0  
ksxp so latch 6,283 0.00   0 0  
ksz_so allocation latch 6,283 0.00   0 0  
ktm global data 2,222 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 17,703 0.01 0.00 0 0  
list of block allocation 1,674 0.00   0 0  
loader state object freelist 120 0.00   0 0  
lob segment dispenser latch 89 0.00   0 0  
lob segment hash table latch 101 0.00   0 0  
lob segment query latch 89 0.00   0 0  
lock DBA buffer during media recovery 89 0.00   0 0  
logical standby cache 89 0.00   0 0  
logminer context allocation 90 0.00   0 0  
logminer work area 89 0.00   0 0  
longop free list parent 89 0.00   0 0  
managed standby latch 97 0.00   0 0  
mapped buffers lru chain 89 0.00   0 0  
message pool operations parent latch 28,195 0.00   0 0  
messages 521,429 0.07 0.01 0 0  
mostly latch-free SCN 17,967 0.80 0.01 0 0  
msg queue latch 89 0.00   0 0  
multiblock read objects 12,942 0.00   0 0  
name-service memory objects 11,083 0.00   0 0  
name-service namespace bucket 37,148 0.00   0 0  
name-service pending queue 6,410 0.00   0 0  
name-service request 18 0.00   0 0  
name-service request queue 42,850 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 446,103 0.00   0 123,768 0.00
object queue header operation 1,981,972 0.00 0.00 0 0  
object stats modification 36 0.00   0 0  
parallel query alloc buffer 46,997 0.00   0 0  
parallel query stats 8,508 0.00   0 0  
parallel txn reco latch 940,545 0.00   0 0  
parameter list 7,063 0.00   0 0  
parameter table management 21,459 0.00 0.00 0 0  
peshm 89 0.00   0 0  
pesom_free_list 89 0.00   0 0  
pesom_hash_node 89 0.00   0 0  
post/wait queue 9,051,272 0.00 0.00 0 9,023,541 0.00
process allocation 23,899 0.01 0.33 0 3,138 0.00
process group creation 6,283 0.00   0 0  
process queue 23,227 0.00   0 0  
process queue reference 382,180 0.00 0.00 0 36,157 0.01
qmn task queue latch 513 0.00   0 0  
query server freelists 19,023 0.00   0 0  
query server process 2,099 0.00   0 3 0.00
queued dump request 12 0.00   0 0  
queuing load statistics 89 0.00   0 0  
recovery domain hash list 89 0.00   0 0  
redo allocation 194,860 0.02 0.00 0 182,472 0.12
redo copy 89 0.00   0 182,552 0.05
redo writing 95,728 0.02 0.00 0 0  
resmgr group change latch 2,985 0.00   0 0  
resmgr:active threads 10,772 0.00   0 0  
resmgr:actses change group 2,844 0.00   0 0  
resmgr:actses change state 89 0.00   0 0  
resmgr:free threads list 10,535 0.00   0 0  
resmgr:plan CPU method 89 0.00   0 0  
resmgr:resource group CPU method 2,525 0.00   0 0  
resmgr:schema config 261 0.00   0 0  
resmgr:session queuing 89 0.00   0 0  
rm cas latch 89 0.00   0 0  
row cache objects 133,276,891 0.12 0.01 0 2 0.00
rules engine rule set statistics 100 0.00   0 0  
second Audit Vault latch 89 0.00   0 0  
second spare latch 89 0.00   0 0  
sequence cache 5,064 0.00   0 0  
session allocation 25,168 0.00   0 14,584 0.00
session idle bit 4,728,496 0.00 0.00 0 0  
session queue latch 89 0.00   0 0  
session state list latch 4,464 0.00   0 0  
session switching 3,292 0.00   0 0  
session timer 1,209 0.00   0 0  
shared pool 447,596 0.00 0.00 0 0  
shared pool sim alloc 116 0.00   0 0  
shared pool simulator 836 0.00   0 0  
sim partition latch 89 0.00   0 0  
simulator hash latch 520,269 0.00   0 0  
simulator lru latch 89 0.00   0 520,062 0.00
sort extent pool 368 0.00   0 0  
space background state object latch 10 0.00   0 0  
space background task latch 4,149 0.00   0 2,423 0.00
state object free list 2 0.00   0 0  
statistics aggregation 796 0.00   0 0  
tablespace key chain 89 0.00   0 0  
temp lob duration state obj allocation 6 0.00   0 0  
temporary table state object allocation 33 0.00   0 0  
test excl. parent l0 89 0.00   0 0  
test excl. parent2 l0 89 0.00   0 0  
third spare latch 89 0.00   0 0  
threshold alerts latch 143 0.00   0 0  
transaction allocation 55,136,059 0.00 0.00 0 0  
transaction branch allocation 2,331,509 0.00 0.00 0 0  
undo global data 380,947 0.02 0.00 0 0  
virtual circuit buffers 89 0.00   0 0  
virtual circuit holder 89 0.00   0 0  
virtual circuit queues 89 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets
row cache objects 133,276,891 155,762 2,011 154,176
ges process hash list 10,745,489,264 60,532 13,695 46,837
ges resource hash list 121,979,433 42,482 5,994 36,500
ges caches resource lists 12,694,539 24,366 173 24,195
ges value block free list 4,722,581 986 1 985
ges group table 50,225,406 783 3 780
KJCT flow control latch 18,275,685 571 7 564
messages 521,429 356 3 353
cache buffers chains 27,954,878 225 1 224
enqueue hash chains 85,475,947 178 1 177
mostly latch-free SCN 17,967 144 1 143
active service list 187,131 4 1 3
ges process parent latch 98,320,152 3 1 2
process allocation 23,899 3 1 2

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
KJCT flow control latch kjctcsnd: send normal message 0 5 5
KJCT flow control latch kjctr_updatetkt: update ticket info 0 1 2
KJCT flow control latch kjcts_sedeqv2: dequeue a vector of msgs 0 1 0
active service list kswsite: service iterator 0 1 0
cache buffers chains kcbgtcr: fast path 0 1 0
enqueue hash chains ksqgtl3 0 1 0
ges group table kjgdgll: move a lock from group lock list to process lock list 0 2 2
ges group table kjgagll: move a lock from process lock list to group lock list 0 1 1
ges process hash list kjakiqa: set inquiry response 0 13,734 0
ges process parent latch kjlalc: lock allocation from lmon 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 3,359 7
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 2,400 152
ges resource hash list kjuinq: inquire resource held mode 0 296 1
ges resource hash list kjrmas1: lookup master node 0 24 0
ges resource hash list kjcvscn: remove from scan queue 0 2 0
ges resource hash list kjlrlr: remove lock from resource queue 0 1 4,979
ges resource table freelist kjchc: clean resource cache 0 152 0
ges resource table freelist kjruch: cached obj cleanup 0 16 0
ges resource table freelist kjrm2c: move resource to cache 0 5 173
ges value block free list kjvblkgrow: allocation 0 1 0
lgwr LWN SCN kcs023 0 1 0
messages ksarcr 0 2 0
messages ksarcv 0 1 0
process allocation ksufap: active procs 0 1 0
row cache objects kqrpre: find obj 0 1,677 1,217
row cache objects kqreqd: reget 0 220 144
row cache objects kqreqd 0 114 646

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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
DBSL TEMP TM_QTFHJG   TABLE 6,139,360 49.26
DBEX INDEX_TABLESPACE PRI_KCSM_YWBM_ID   INDEX 1,142,528 9.17
DBSL DATA_TABLESPACE TRANS_BILL_DOWN   TABLE 742,624 5.96
DBSL DATA_TABLESPACE T_DPLS   TABLE 666,560 5.35
DBSL DATA_TABLESPACE ITEM_INTERFACE   TABLE 627,536 5.03

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_3951945579_813 TABLE PARTITION 28 23.53

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
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_3951945579_813 TABLE PARTITION 28 23.93

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_3951945579_813 TABLE PARTITION 28 23.93

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 1,691 9.43
DBSL INDEX_TABLESPACE IDX_T_XHD_XHQPMX_CHANGE1   INDEX 1,065 5.94
DBSL DATA_TABLESPACE T_DPLS   TABLE 702 3.91
DBEX DATA_TABLESPACE T_SL_YFSJ   TABLE 226 1.26
DBSL DATA_TABLESPACE ITEM_INTERFACE   TABLE 156 0.87

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
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 1,580 10.97
DBSL INDEX_TABLESPACE IDX_T_XHD_XHQPMX_CHANGE1   INDEX 1,020 7.08
DBSL DATA_TABLESPACE T_DPLS   TABLE 690 4.79
DBEX DATA_TABLESPACE T_SL_YFSJ   TABLE 201 1.40
DBSL DATA_TABLESPACE ITEM_INTERFACE   TABLE 144 1.00

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Writes %Total
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_3951945579_813 TABLE PARTITION 34 77.27

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

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
DBSL TEMP TM_QTFHJG   TABLE 1,809,808 95.53
DBSL DATA_TABLESPACE T_DPLS   TABLE 19,840 1.05
SYS SYSTEM AUD$   TABLE 9,792 0.52
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 9,200 0.49
DBSL INDEX_TABLESPACE IDX_T_XHD_XHQPMX_CHANGE1   INDEX 6,048 0.32

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
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 1 100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 6 100.00

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 1 100.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

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
SYS SYSTEM PENDING_TRANS$   TABLE 1,940 1.95
SYS SYSTEM PENDING_SESSION_INDEXYANGWF   INDEX 1,760 1.77
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 1,185 1.19
DBSL DATA_TABLESPACE T_DPLS   TABLE 837 0.84
DBSL DATA_TABLESPACE T_FHMX   TABLE 359 0.36

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
DBSL DATA_TABLESPACE T_XHD_XHQPMX   TABLE 1,335 15.88
DBSL INDEX_TABLESPACE IDX_T_XHD_XHQPMX_CHANGE1   INDEX 1,050 12.49
SYS SYSTEM AUD$   TABLE 340 4.04
DBSL DATA_TABLESPACE T_DPLS   TABLE 325 3.87
SYS SYSAUX WRH$_SQLSTAT WRH$_SQLSTA_3951945579_789 TABLE PARTITION 193 2.30

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 63 1.59 0   1 1
dc_files 252 0.00 0   0 7
dc_global_oids 273 2.20 0   0 78
dc_histogram_data 43,200 1.07 0   0 46,336
dc_histogram_defs 513,952 0.03 0   12 12,362
dc_object_grants 260 0.77 0   0 236
dc_objects 18,680 0.70 0   22 7,428
dc_profiles 628 0.00 0   0 1
dc_rollback_segments 43,766,831 0.00 0   896 11,542
dc_segments 11,211 0.04 0   6 6,930
dc_sequences 368 2.17 0   368 14
dc_tablespaces 61,698 0.00 0   0 9
dc_users 49,077 0.01 0   0 435
global database name 4,221 0.00 0   0 1
outstanding_alerts 30 100.00 0   0 1
sch_lj_oids 18 0.00 0   0 37

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 6 0 0
dc_histogram_defs 165 0 0
dc_objects 44 2 0
dc_rollback_segments 1,792 0 0
dc_segments 16 3 0
dc_sequences 736 9 0
dc_users 5 0 0
outstanding_alerts 60 30 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 1,214 0.08 0   0 0
BODY 213 0.47 2,662 0.04 0 0
CLUSTER 8 0.00 8 0.00 0 0
DBLINK 10,376 0.00 0   0 0
EDITION 638 0.00 1,259 0.00 0 0
INDEX 391 0.00 391 0.00 0 0
OBJECT ID 4 100.00 0   0 0
QUEUE 0   60 0.00 0 0
SCHEMA 658 0.15 0   0 0
SQL AREA 13,608 1.96 582,502 0.33 150 29
SQL AREA BUILD 478 46.44 0   0 0
SQL AREA STATS 492 69.51 492 69.51 0 0
TABLE/PROCEDURE 3,455 0.58 14,341 0.36 12 0
TRIGGER 145 0.00 7,647 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 1,214 0 0 0 0
BODY 0 2,657 2,657 0 0
CLUSTER 8 8 8 0 0
DBLINK 10,376 0 0 0 0
EDITION 638 645 645 0 0
INDEX 391 391 391 0 0
QUEUE 0 60 60 0 0
SCHEMA 627 0 0 0 0
TABLE/PROCEDURE 4,502 9,373 9,373 0 0
TRIGGER 0 7,647 7,647 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 218,112.00 218,112.00 218,112.00 218,112.00 0 INI/IMM
KEEP buffer cache 0.00 0.00 0.00 0.00 0 STA/
PGA Target 150,016.00 150,016.00 150,016.00 150,016.00 0 STA/
RECYCLE buffer cache 0.00 0.00 0.00 0.00 0 STA/
SGA Target 250,368.00 250,368.00 250,368.00 250,368.00 0 STA/
Shared IO Pool 0.00 0.00 0.00 0.00 0 STA/
java pool 3,584.00 3,584.00 3,584.00 3,584.00 0 STA/
large pool 512.00 512.00 512.00 512.00 0 STA/
shared pool 25,600.00 25,600.00 25,088.00 25,600.00 0 GRO/IMM
streams pool 1,024.00 1,024.00 1,024.00 1,024.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 816.65   4.56 7.79 58 58 179 179
SQL 46.20 44.63 0.38 4.01 44 76 121 113
Freeable 36.13 0.00 0.98 1.41 8   37 37
PL/SQL 1.48 0.91 0.01 0.02 0 0 177 176
E Other 816.75   4.75 7.90 58 58 172 172
SQL 46.06 44.27 0.41 4.15 44 76 113 105
Freeable 36.13 0.00 0.77 1.31 8   47 47
PL/SQL 1.78 1.20 0.01 0.02 0 0 170 170

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 228,707,008,512  
Fixed Size 2,244,552  
Redo Buffers 436,350,976  
Variable Size 32,212,254,776  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 3,584.00 3,584.00 0.00
large PX msg pool 7.81 7.81 0.00
large free memory 503.81 503.81 0.00
shared KGLH0 507.00 511.46 0.88
shared SQLA 1,438.29 1,431.92 -0.44
shared db_block_hash_buckets 1,424.00 1,424.00 0.00
shared free memory 10,595.76 10,598.32 0.02
shared gc name table 336.00 336.00 0.00
shared gcs resources 5,723.37 5,723.37 0.00
shared gcs shadows 3,338.63 3,338.63 0.00
streams free memory 1,024.00 1,024.00 0.00
  buffer_cache 218,112.00 218,112.00 0.00
  fixed_sga 2.14 2.14 0.00
  log_buffer 416.14 416.14 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type First Logon CPU time(s) User IO Wait time(s) SYS IO Wait time(s)
QMON Coordinator 1211 21:19:50 0.13 0.00 0.00
QMON Slaves 1211 21:19:51 0.06 0.00 0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s) %Busy %Idle Incoming Net % Outgoing Net %
3,632 0.00 100.00 0.00 0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different)
audit_file_dest /u01/app/oracle/admin/SDSLDB/adump   
audit_trail DB   
cluster_database TRUE   
compatible 11.2.0.0.0   
control_files +DATA/sdsldb/controlfile/current.260.799499755, +ARCH/sdsldb/controlfile/current.256.799499755   
db_block_size 8192   
db_cache_size 53687091200   
db_create_file_dest +DATA   
db_domain      
db_file_multiblock_read_count 64   
db_name SDSLDB   
db_recovery_file_dest +ARCH   
db_recovery_file_dest_size 1258291200000   
diagnostic_dest /u01/app/oracle   
dispatchers (PROTOCOL=TCP) (SERVICE=SDSLDBXDB)   
instance_number 1   
local_listener (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.3.205)(PORT=1521))))   
lock_sga TRUE   
log_archive_format %t_%s_%r.dbf   
max_dump_file_size 1073741824   
open_cursors 5000   
pga_aggregate_target 157286400000   
pre_page_sga FALSE   
processes 5000   
remote_listener SDSLDBscan:1521   
remote_login_passwordfile EXCLUSIVE   
sessions 7680   
sga_target 262529875968   
shared_pool_size 21474836480   
spfile +DATA/sdsldb/spfilesdsldb.ora   
thread 1   
undo_retention 10800   
undo_tablespace UNDOTBS1   

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter Name Begin value End value (if different)
control_files +ARCH/sdsldb/controlfile/current.256.799499755   
+DATA/sdsldb/controlfile/current.260.799499755   

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

Statistic Total per Second per Trans
acks for commit broadcast(actual) 9,369 2.58 3.28
acks for commit broadcast(logical) 14,825 4.08 5.20
broadcast msgs on commit(actual) 9,343 2.57 3.27
broadcast msgs on commit(logical) 17,547 4.83 6.15
broadcast msgs on commit(wasted) 3,122 0.86 1.09
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
flow control messages received 5 0.00 0.00
flow control messages sent 14,670 4.04 5.14
gcs apply delta 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 11,145 3.07 3.91
gcs ast xid 0 0.00 0.00
gcs blocked converts 14,071 3.87 4.93
gcs blocked cr converts 18,478 5.09 6.48
gcs compatible basts 37 0.01 0.01
gcs compatible cr basts (global) 2,314 0.64 0.81
gcs compatible cr basts (local) 6,526 1.80 2.29
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 2,576 0.71 0.90
gcs dbwr write request msgs 1,366 0.38 0.48
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 10 0.00 0.00
gcs force cr grant 2 0.00 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 360 0.10 0.13
gcs immediate (null) converts 427 0.12 0.15
gcs immediate cr (compatible) converts 189 0.05 0.07
gcs immediate cr (null) converts 288 0.08 0.10
gcs indirect ast 3,552 0.98 1.25
gcs indirect bidless ast 9 0.00 0.00
gcs indirect fg ast 3,543 0.98 1.24
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 470 0.13 0.16
gcs msgs process time(ms) 3,615 1.00 1.27
gcs msgs received 75,376 20.75 26.42
gcs new served by master 340 0.09 0.12
gcs out-of-order msgs 18 0.00 0.01
gcs pings refused 10 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs push delta 0 0.00 0.00
gcs queued converts 0 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 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 20 0.01 0.01
gcs share recovery bast 0 0.00 0.00
gcs side channel msgs actual 7,918 2.18 2.78
gcs side channel msgs logical 108,579 29.90 38.06
gcs stale cr 0 0.00 0.00
gcs undo cr 3 0.00 0.00
gcs write notification msgs 72 0.02 0.03
gcs writes refused 5 0.00 0.00
ges msgs process time(ms) 1,398,621 385.08 490.23
ges msgs received 9,075,054 2,498.64 3,180.88
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 5,604 1.54 1.96
implicit batch messages sent 536 0.15 0.19
lmd msg send time(ms) 402 0.11 0.14
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 193 0.05 0.07
messages queue sent actual 53,825 14.82 18.87
messages queue sent logical 11,769 3.24 4.13
messages received actual 9,105,934 2,507.14 3,191.70
messages received logical 9,150,424 2,519.39 3,207.30
messages sent directly 9,137,745 2,515.90 3,202.85
messages sent indirectly 70,960 19.54 24.87
messages sent not implicit batched 523 0.14 0.18
messages sent pbatched 88,339 24.32 30.96
msgs causing lmd to send msgs 54,147 14.91 18.98
msgs causing lms(s) to send msgs 5,421 1.49 1.90
msgs received queue time (ms) 90,358 24.88 31.67
msgs received queued 9,150,425 2,519.39 3,207.30
msgs sent queue time (ms) 37,932 10.44 13.30
msgs sent queue time on ksxp (ms) 1,655,382 455.78 580.23
msgs sent queued 63,835 17.58 22.37
msgs sent queued on ksxp 9,215,200 2,537.23 3,230.00
number of broadcasted resources 0 0.00 0.00
number of ges deadlock detected 0 0.00 0.00
process batch messages received 8,977,941 2,471.90 3,146.84
process batch messages sent 46,237 12.73 16.21


Back to Top

Global CR Served Stats

Statistic Total
CR Block Requests 12,946
CURRENT Block Requests 205
Data Block Requests 12,952
Undo Block Requests 3
TX Block Requests 31
Current Results 9,813
Private results 243
Zero Results 3,100
Disk Read Results 0
Fail Results 0
Fairness Down Converts 8,397
Fairness Clears 18
Free GC Elements 0
Flushes 3,447
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 37
Errors 0


Back to Top

Global CURRENT Served Stats

Statistic Total % <1ms % <10ms % <100ms % <1s % <10s
Pins 0 0.00 0.00 0.00 0.00 0.00
Flushes 17 58.82 41.18 0.00 0.00 0.00
Writes 2,989 79.16 10.37 1.04 5.29 4.15


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 undo header 90,577 98.33 0.01 1.66 2,174 96.00 2.48 1.52
2 data block 8,505 96.53 0.19 3.28 5,747 97.29 0.28 2.44
2 Others 373 94.10 0.00 5.90 289 97.92 0.00 2.08
2 undo block 0       195 98.97 0.00 1.03

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 undo header 0.43 0.43 1.53 0.43 0.54 0.51 1.46 0.53
2 data block 0.57 0.57 1.66 0.77 0.57 0.56 1.13 0.83
2 others 0.59 0.58   0.64 0.56 0.56   0.64
2 undo block         0.51 0.51   0.55

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 undo header 0 89,060 100.00 0.00 2,087 100.00 0.00
2 data block 0 8,210 100.00 0.00 5,591 100.00 0.00
2 others 0 351 100.00 0.00 283 100.00 0.00
2 undo block 0 0     193 100.00 0.00

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 undo header   0.43 0.43   0.51 0.51  
2 data block   0.57 0.57   0.56 0.56  
2 others   0.58 0.58   0.56 0.56  
2 undo block         0.51 0.51  

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 288 0.37 0.09 288 0.34 0.08
2 288 0.34 0.07 288 0.52 0.15

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used By Send Mbytes/sec Receive Mbytes/sec
Global Cache 0.05 0.09
Parallel Query 0.00 0.01
DB Locks 0.36 0.44
DB Streams 0.00 0.00
Other 0.00 0.01

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
eth2:1 169.254.2.43 NO   0.00 0 0 0 0 0.00 0 0 0 0

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report