WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC
UEMO02 2766340557 UEMO02 1 25-Aug-15 16:08 11.2.0.4.0 NO

Host Name Platform CPUs Cores Sockets Memory (GB)
gbl05779 Linux x86 64-bit 16 8 2 125.90

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 16786 05-Oct-15 12:00:20 53 2.7
End Snap: 16791 05-Oct-15 17:00:40 32 2.4
Elapsed:   300.34 (mins)    
DB Time:   40.73 (mins)    

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.1 0.0 0.00 0.00
DB CPU(s): 0.1 0.0 0.00 0.00
Redo size (bytes): 129,468.8 20,759.1    
Logical read (blocks): 5,821.7 933.5    
Block changes: 599.9 96.2    
Physical read (blocks): 256.6 41.2    
Physical write (blocks): 27.1 4.3    
Read IO requests: 162.6 26.1    
Write IO requests: 6.6 1.1    
Read IO (MB): 2.0 0.3    
Write IO (MB): 0.2 0.0    
User calls: 114.5 18.4    
Parses (SQL): 41.6 6.7    
Hard parses (SQL): 0.3 0.1    
SQL Work Area (MB): 0.3 0.1    
Logons: 0.0 0.0    
Executes (SQL): 94.8 15.2    
Rollbacks: 0.0 0.0    
Transactions: 6.2      

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 97.28 In-memory Sort %: 100.00
Library Hit %: 99.31 Soft Parse %: 99.19
Execute to Parse %: 56.09 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 50.69 % Non-Parse CPU: 98.62

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
DB CPU   1230.5   50.3  
db file sequential read 411,719 503.1 1 20.6 User I/O
db file parallel read 76,891 352.8 5 14.4 User I/O
log file sync 194,258 192.7 1 7.9 Commit
direct path read 9,051 108.7 12 4.4 User I/O
db file scattered read 10,536 70.8 7 2.9 User I/O
direct path read temp 51,718 42.5 1 1.7 User I/O
SQL*Net more data to client 379,703 5.9 0 .2 Network
read by other session 457 3.9 9 .2 User I/O
SQL*Net more data from client 39,043 3.9 0 .2 Network

Wait Classes by Total Wait Time

Wait Class Waits Total Wait Time (sec) Avg Wait (ms) % DB time Avg Active Sessions
User I/O 895,435 1,267 1 51.8 0.1
DB CPU   1,230   50.3 0.1
System I/O 343,020 298 1 12.2 0.0
Commit 194,268 193 1 7.9 0.0
Network 1,883,740 12 0 .5 0.0
Concurrency 5,136 4 1 .2 0.0
Application 363 1 2 .0 0.0
Other 2,908 1 0 .0 0.0
Configuration 115 0 3 .0 0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle
16 8 2 3.54 2.83 6.1 3.6 0.0 89.9

Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
0.5 5.0 0.0

IO Profile

Read+Write Per Second Read per Second Write Per Second
Total Requests: 184.3 150.8 33.5
Database Requests: 169.1 162.6 6.6
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 24.7 0.0 24.7
Total (MB): 2.6 2.1 0.5
Database (MB): 2.2 2.0 0.2
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 0.3 0.0 0.3
Database (blocks): 283.7 256.6 27.1
Via Buffer Cache (blocks): 178.1 155.1 23.0
Direct (blocks): 105.6 101.5 4.1

Memory Statistics

Begin End
Host Mem (MB): 128,919.1 128,919.1
SGA use (MB): 4,096.0 4,096.0
PGA use (MB): 243.1 126.0
% Host Mem used for SGA+PGA: 3.37 3.27

Cache Sizes

Begin End
Buffer Cache: 1,808M 1,808M Std Block Size: 8K
Shared Pool Size: 1,538M 1,561M Log Buffer: 9,480K

Shared Pool Statistics

Begin End
Memory Usage %: 69.48 64.33
% SQL with executions>1: 97.78 96.59
% Memory for SQL w/exec>1: 90.77 90.26

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 2,090.62 85.54
DB CPU 1,230.47 50.35
PL/SQL execution elapsed time 163.51 6.69
sequence load elapsed time 82.32 3.37
parse time elapsed 46.82 1.92
hard parse elapsed time 30.92 1.26
connection management call elapsed time 3.09 0.13
repeated bind elapsed time 2.44 0.10
hard parse (sharing criteria) elapsed time 2.24 0.09
failed parse elapsed time 0.65 0.03
PL/SQL compilation elapsed time 0.54 0.02
hard parse (bind mismatch) elapsed time 0.05 0.00
DB time 2,443.99  
background elapsed time 719.82  
background cpu time 204.26  

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Value End Value
BUSY_TIME 2,867,265  
IDLE_TIME 25,559,342  
IOWAIT_TIME 4,020  
NICE_TIME 2,283  
SYS_TIME 1,025,259  
USER_TIME 1,733,346  
LOAD 4 3
RSRC_MGR_CPU_WAIT_TIME 0  
PHYSICAL_MEMORY_BYTES 135,181,484,032  
NUM_CPUS 16  
NUM_CPU_CORES 8  
NUM_CPU_SOCKETS 2  
GLOBAL_RECEIVE_SIZE_MAX 4,194,304  
GLOBAL_SEND_SIZE_MAX 1,048,576  
TCP_RECEIVE_SIZE_DEFAULT 87,380  
TCP_RECEIVE_SIZE_MAX 4,194,304  
TCP_RECEIVE_SIZE_MIN 4,096  
TCP_SEND_SIZE_DEFAULT 16,384  
TCP_SEND_SIZE_MAX 4,194,304  
TCP_SEND_SIZE_MIN 4,096  

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time Load %busy %user %sys %idle %iowait
05-Oct 12:00:20 3.54          
05-Oct 13:00:24 3.24 10.26 6.42 3.46 89.74 0.01
05-Oct 14:00:28 3.53 9.79 5.62 3.77 90.21 0.01
05-Oct 15:00:32 3.57 9.86 5.80 3.69 90.14 0.01
05-Oct 16:00:36 2.94 10.77 6.85 3.54 89.23 0.01
05-Oct 17:00:40 2.83 9.75 5.80 3.58 90.25 0.03

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time
DB CPU     1,230   50.35
User I/O 562,749 0 1,086 2 44.43
Commit 194,258 0 193 1 7.88
Network 1,882,740 0 12 0 0.50
Concurrency 4,826 0 2 0 0.07
Application 363 0 1 2 0.03
Configuration 115 0 0 3 0.01
Other 381 55 0 0 0.00
System I/O 0   0   0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % DB time
db file sequential read 411,719 0 503 1 3.66 20.59
db file parallel read 76,891 0 353 5 0.68 14.44
log file sync 194,258 0 193 1 1.73 7.88
direct path read 9,051 0 109 12 0.08 4.45
db file scattered read 10,536 0 71 7 0.09 2.90
direct path read temp 51,718 0 43 1 0.46 1.74
SQL*Net more data to client 379,703 0 6 0 3.38 0.24
read by other session 457 0 4 9 0.00 0.16
SQL*Net more data from client 39,043 0 4 0 0.35 0.16
direct path write temp 1,360 0 4 3 0.01 0.15
SQL*Net message to client 1,455,325 0 2 0 12.95 0.07
SQL*Net vector data to client 8,669 0 1 0 0.08 0.03
buffer busy waits 3,912 0 1 0 0.03 0.03
SQL*Net break/reset to client 87 0 0 6 0.00 0.02
log file switch (private strand flush incomplete) 9 0 0 36 0.00 0.01
row cache lock 33 0 0 9 0.00 0.01
library cache: mutex X 391 0 0 1 0.00 0.01
direct path write 157 0 0 1 0.00 0.01
os thread startup 8 0 0 24 0.00 0.01
enq: TX - row lock contention 254 0 0 1 0.00 0.01
enq: TX - index contention 40 0 0 3 0.00 0.01
latch: shared pool 176 0 0 1 0.00 0.00
enq: KO - fast object checkpoint 16 0 0 6 0.00 0.00
enq: TX - allocate ITL entry 106 0 0 0 0.00 0.00
Disk file operations I/O 858 0 0 0 0.01 0.00
cursor: pin S wait on X 2 0 0 11 0.00 0.00
enq: PS - contention 2 0 0 5 0.00 0.00
reliable message 26 0 0 0 0.00 0.00
latch: cache buffers chains 169 0 0 0 0.00 0.00
latch: row cache objects 45 0 0 0 0.00 0.00
latch: object queue header operation 93 0 0 0 0.00 0.00
enq: TM - contention 6 0 0 1 0.00 0.00
latch free 8 0 0 1 0.00 0.00
PX Deq: Slave Session Stats 16 0 0 0 0.00 0.00
Parameter File I/O 2 0 0 2 0.00 0.00
library cache lock 9 0 0 0 0.00 0.00
enq: FB - contention 1 0 0 2 0.00 0.00
buffer deadlock 210 100 0 0 0.00 0.00
latch: In memory undo latch 14 0 0 0 0.00 0.00
SQL*Net message from client 1,455,345 0 311,983 214 12.95  
PL/SQL lock timer 156 100 78 501 0.00  
PX Deq: Execution Msg 160 0 70 437 0.00  
PX Deq: Table Q Normal 578 0 13 22 0.01  
PX Deq: Execute Reply 184 0 2 13 0.00  
PX Deq Credit: send blkd 81 0 0 4 0.00  
PX Deq Credit: need buffer 20 0 0 13 0.00  
PX Deq: Parse Reply 8 0 0 2 0.00  
PX Deq: Join ACK 8 0 0 1 0.00  

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % bg time
log file parallel write 219,795 0 206 1 1.96 28.68
db file sequential read 330,485 0 178 1 2.94 24.78
control file sequential read 49,801 0 38 1 0.44 5.23
db file parallel write 37,550 0 26 1 0.33 3.59
control file parallel write 20,205 0 22 1 0.18 3.12
db file async I/O submit 15,485 0 5 0 0.14 0.72
os thread startup 112 0 3 24 0.00 0.37
db file scattered read 460 0 2 3 0.00 0.22
direct path read 70 0 1 16 0.00 0.15
log file sequential read 92 0 0 4 0.00 0.05
enq: CF - contention 4 0 0 49 0.00 0.03
ADR block file read 75 0 0 2 0.00 0.02
log file sync 10 0 0 10 0.00 0.01
log file single write 92 0 0 1 0.00 0.01
LGWR wait for redo copy 1,675 0 0 0 0.01 0.01
direct path write 74 0 0 1 0.00 0.01
latch free 219 0 0 0 0.00 0.01
ADR block file write 25 0 0 1 0.00 0.00
local write wait 4 0 0 4 0.00 0.00
buffer busy waits 158 0 0 0 0.00 0.00
latch: object queue header operation 104 0 0 0 0.00 0.00
Disk file operations I/O 1,593 0 0 0 0.01 0.00
asynch descriptor resize 368 100 0 0 0.00 0.00
read by other session 3 0 0 1 0.00 0.00
latch: shared pool 17 0 0 0 0.00 0.00
latch: call allocation 6 0 0 0 0.00 0.00
SQL*Net message to client 1,000 0 0 0 0.01 0.00
latch: cache buffers lru chain 17 0 0 0 0.00 0.00
ADR file lock 30 0 0 0 0.00 0.00
rdbms ipc message 295,635 30 215,757 730 2.63  
Space Manager: slave idle wait 18,761 63 64,145 3419 0.17  
DIAG idle wait 35,983 100 36,018 1001 0.32  
pmon timer 6,003 100 18,020 3002 0.05  
smon timer 1,439 2 18,018 12521 0.01  
PX Idle Wait 16 0 2,460 153723 0.00  
SQL*Net message from client 1,248 0 2 1 0.01  
class slave wait 112 0 0 0 0.00  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

    % of Waits
Event Total Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
ADR block file read 75 44.0 37.3 12.0   5.3 1.3    
ADR block file write 25 48.0 32.0 20.0          
ADR file lock 30 100.0              
Disk file operations I/O 2450 100.0         .0    
LGWR wait for redo copy 1675 99.9 .1            
PX Deq: Signal ACK EXT 8 100.0              
PX Deq: Signal ACK RSG 8 100.0              
PX Deq: Slave Session Stats 16 100.0              
PX qref latch 1 100.0              
Parameter File I/O 2   50.0 50.0          
SQL*Net break/reset to client 87 67.8     21.8 8.0 1.1 1.1  
SQL*Net message to client 1456.2K 100.0 .0            
SQL*Net more data from client 39K 100.0 .0            
SQL*Net more data to client 379.7K 99.9 .1 .0 .0 .0 .0    
SQL*Net vector data to client 8669 98.3 1.0 .2 .2 .4      
asynch descriptor resize 368 100.0              
buffer busy waits 4070 99.2 .3 .1   .2 .3    
buffer deadlock 210 100.0              
control file parallel write 20.2K 73.9 19.5 3.9 1.3 1.1 .2 .1  
control file sequential read 49.8K 86.8 10.3 1.6 .6 .5 .1 .0  
cursor: mutex X 1 100.0              
cursor: pin S 26 100.0              
cursor: pin S wait on X 2         100.0      
db file async I/O submit 15.5K 95.4 3.0 1.0 .3 .1 .0 .1  
db file parallel read 76.9K 60.2 10.6 6.7 5.5 7.7 7.4 1.9  
db file parallel write 37.5K 81.6 11.1 5.4 1.4 .4 .1 .0  
db file scattered read 11K 52.6 9.8 7.9 7.4 9.5 7.4 5.3  
db file sequential read 742.3K 87.3 6.7 2.8 1.3 1.4 .5 .1  
direct path read 9121 5.7 5.7 12.1 23.7 30.3 17.9 4.6  
direct path read temp 51.7K 79.3 17.6 2.2 .3 .5 .1 .0  
direct path write 231 69.7 19.9 5.6 3.5 1.3      
direct path write temp 1360 32.6 23.4 31.7 7.1 3.8 1.0 .4  
enq: CF - contention 4     25.0 50.0     25.0  
enq: FB - contention 1   100.0            
enq: KO - fast object checkpoint 16 18.8 12.5 31.3 12.5 18.8 6.3    
enq: PS - contention 2 50.0       50.0      
enq: TM - contention 6 66.7 33.3            
enq: TX - allocate ITL entry 106 91.5 5.7 2.8          
enq: TX - index contention 40 52.5   17.5 20.0 10.0      
enq: TX - row lock contention 254 96.9   1.2 .8   1.2    
latch free 227 96.0 2.6   1.3        
latch: In memory undo latch 14 100.0              
latch: cache buffers chains 182 99.5 .5            
latch: cache buffers lru chain 19 100.0              
latch: call allocation 6 100.0              
latch: checkpoint queue latch 1 100.0              
latch: enqueue hash chains 1 100.0              
latch: object queue header operation 197 100.0              
latch: redo allocation 8 100.0              
latch: row cache objects 48 97.9 2.1            
latch: shared pool 193 91.2 3.1 3.6 2.1        
library cache lock 9 88.9 11.1            
library cache: mutex X 398 93.7       6.0 .3    
local write wait 4   50.0 25.0   25.0      
log file parallel write 219.8K 84.9 9.6 2.2 1.3 1.7 .3 .1  
log file sequential read 92 52.2 7.6 3.3 15.2 19.6 2.2    
log file single write 92 84.8 12.0 2.2 1.1        
log file switch (private strand flush incomplete) 9           33.3 66.7  
log file sync 194.3K 84.3 10.5 2.3 1.2 1.4 .2 .1  
os thread startup 120         5.8 92.5 1.7  
read by other session 459 15.9 16.1 17.6 20.9 15.3 9.8 4.4  
reliable message 26 96.2   3.8          
row cache lock 33 48.5 9.1 6.1 3.0 12.1 12.1 9.1  
DIAG idle wait 36K             100.0  
PL/SQL lock timer 156             100.0  
PX Deq Credit: need buffer 20 5.0   30.0 15.0 5.0 40.0 5.0  
PX Deq Credit: send blkd 81 29.6 21.0 33.3 4.9 1.2 8.6 1.2  
PX Deq: Execute Reply 184 45.1 8.7 9.2 10.9 8.7 8.7 8.7  
PX Deq: Execution Msg 160 72.5 2.5 2.5 1.9 1.3 3.8 10.6 5.0
PX Deq: Join ACK 8 75.0   25.0          
PX Deq: Parse Reply 8 50.0 12.5 12.5 12.5 12.5      
PX Deq: Table Q Normal 577 69.7 6.9 6.9 6.1 3.3 1.4 5.5 .2
PX Idle Wait 8 25.0         25.0 50.0  
SQL*Net message from client 1456.5K 59.1 17.0 5.6 9.6 5.6 1.1 1.3 .6
Space Manager: slave idle wait 18.5K 14.6 .3 .1 .1 .3 .5 12.5 71.8
class slave wait 112 100.0              
pmon timer 6002               100.0
rdbms ipc message 295.6K 2.7 18.8 43.3 .4 .3 .5 15.8 18.2
smon timer 1437 44.3 .4   .2 .6 .9 32.1 21.4

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
SQL*Net break/reset to client 1 98.9     1.1        
control file parallel write 22 99.9 .1 .0          
control file sequential read 17 100.0 .0            
db file async I/O submit 12 99.9 .0 .0          
db file parallel read 1443 98.1 1.5 .4 .0        
db file parallel write 6 100.0 .0            
db file scattered read 580 94.7 4.6 .7 .0 .0      
db file sequential read 707 99.9 .1 .0 .0 .0      
direct path read 420 95.4 3.5 1.0 .1        
direct path read temp 19 100.0 .0            
direct path write temp 6 99.6 .4            
enq: CF - contention 1 75.0     25.0        
log file parallel write 177 99.9 .1 .0          
log file switch (private strand flush incomplete) 6 33.3 66.7            
log file sync 148 99.9 .1            
os thread startup 2 98.3 1.7            
read by other session 20 95.6 3.9 .4          
row cache lock 3 90.9 9.1            

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads (K) Logical Reads (K)
UEMO02.uk.hibm.hsbc 2,444 1,231 4,285 104,217
SYS$USERS 0 0 0 0
SYS$BACKGROUND 0 0 339 692

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
UEMO02.uk.hibm.hsbc 562732 1086 4826 2 0 0 1882729 12
SYS$USERS 17 0 0 0 0 0 11 0
SYS$BACKGROUND 332672 181 293 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
263.76 1 263.76 10.79 16.55 84.16 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
189.15 725 0.26 7.74 75.92 24.06 5c0wjsy0htg35 AppServer.exe BEGIN Identity_Mgr.verify(:Par...
172.10 184,165 0.00 7.04 35.78 36.58 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
118.61 3,150 0.04 4.85 98.12 0.16 6kzu3sqd5td74 AppServer.exe select t0.ASSET_IDENTIFIER, t0...
84.47 2 42.23 3.46 12.11 83.75 4b3uyh2az3drf AppServer.exe select transactionid, tsid, ts...
83.73 1 83.73 3.43 35.41 72.13 6uray8wscdpfd MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
81.61 2 40.81 3.34 18.25 84.12 a9ss1cmky0hmj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
72.38 1 72.38 2.96 11.64 89.95 0p83b4kma7mku MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
63.70 2 31.85 2.61 10.97 94.31 26gp329zqvq05 MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
60.37 1 60.37 2.47 16.27 87.83 b4x6m9tp9f8y4 MIGTester.exe SELECT /*+ OPT_PARAM('_b_tree_...
56.83 37 1.54 2.33 96.98 0.00 6tx6rtvjfjp18 AppServer.exe select t0.TARGET_FUND_MAX_INVE...
56.52 178,328 0.00 2.31 28.65 0.13 8sa2bmsr7t2ac MIGTester.exe Select SEQREPORTINFO.nextval f...
48.85 368,676 0.00 2.00 24.65 0.21 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
47.42 1 47.42 1.94 14.09 95.81 gwvhphg2xfdk9 AppServer.exe select count(1) from TASSET t0...
46.98 184,173 0.00 1.92 20.24 0.00 dwf8hakmt8d2t MIGTester.exe Select SEQViolation.nextval fr...
40.77 885 0.05 1.67 98.11 0.48 7mpjdtwz6v52x AppServer.exe select t0.CLSID, t0.ISIN, t0.g...
34.44 13 2.65 1.41 16.44 81.95 1nawuxww54b35 AppServer.exe select t0.REC_IMPORTED, t0.CLA...
28.10 2 14.05 1.15 14.35 86.25 a9fj0zn7tw53y SQL Developer select count(*) from violation

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
143.61 725 0.20 11.67 189.15 75.92 24.06 5c0wjsy0htg35 AppServer.exe BEGIN Identity_Mgr.verify(:Par...
116.38 3,150 0.04 9.46 118.61 98.12 0.16 6kzu3sqd5td74 AppServer.exe select t0.ASSET_IDENTIFIER, t0...
61.58 184,165 0.00 5.00 172.10 35.78 36.58 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
55.12 37 1.49 4.48 56.83 96.98 0.00 6tx6rtvjfjp18 AppServer.exe select t0.TARGET_FUND_MAX_INVE...
43.64 1 43.64 3.55 263.76 16.55 84.16 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
40.00 885 0.05 3.25 40.77 98.11 0.48 7mpjdtwz6v52x AppServer.exe select t0.CLSID, t0.ISIN, t0.g...
29.64 1 29.64 2.41 83.73 35.41 72.13 6uray8wscdpfd MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
21.32 434 0.05 1.73 22.01 96.86 1.86 b37cmsnb8sssq AppServer.exe select t0.CLSID, t0.SEDOL, t0....
20.86 95 0.22 1.70 22.85 91.26 8.11 fuhd2wb26t6j4 AppServer.exe DECLARE chain_and_null BOOLEAN...
20.63 95 0.22 1.68 22.35 92.27 7.21 7w0k1yncv6x12 AppServer.exe UPDATE TASSET SET CLSID = TREA...
16.29 20 0.81 1.32 16.70 97.56 0.00 a2d330h5ztu00 AppServer.exe select t0.TARGET_FUND_MAX_INVE...
16.19 178,328 0.00 1.32 56.52 28.65 0.13 8sa2bmsr7t2ac MIGTester.exe Select SEQREPORTINFO.nextval f...
15.28 262 0.06 1.24 15.45 98.88 0.00 cyng1tf6fmx5p AppServer.exe select t0.CLSID, t0.TECH_ID_GE...
14.90 111 0.13 1.21 15.07 98.86 0.00 f7hsjuf8th60z AppServer.exe select t0.valid_at, t0.RULE, t...
14.89 2 7.45 1.21 81.61 18.25 84.12 a9ss1cmky0hmj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...

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
221.98 1 221.98 17.52 263.76 16.55 84.16 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
70.74 2 35.37 5.58 84.47 12.11 83.75 4b3uyh2az3drf AppServer.exe select transactionid, tsid, ts...
68.65 2 34.33 5.42 81.61 18.25 84.12 a9ss1cmky0hmj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
65.11 1 65.11 5.14 72.38 11.64 89.95 0p83b4kma7mku MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
62.96 184,165 0.00 4.97 172.10 35.78 36.58 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
60.39 1 60.39 4.77 83.73 35.41 72.13 6uray8wscdpfd MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
60.08 2 30.04 4.74 63.70 10.97 94.31 26gp329zqvq05 MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
53.02 1 53.02 4.19 60.37 16.27 87.83 b4x6m9tp9f8y4 MIGTester.exe SELECT /*+ OPT_PARAM('_b_tree_...
45.52 725 0.06 3.59 189.15 75.92 24.06 5c0wjsy0htg35 AppServer.exe BEGIN Identity_Mgr.verify(:Par...
45.43 1 45.43 3.59 47.42 14.09 95.81 gwvhphg2xfdk9 AppServer.exe select count(1) from TASSET t0...
28.22 13 2.17 2.23 34.44 16.44 81.95 1nawuxww54b35 AppServer.exe select t0.REC_IMPORTED, t0.CLA...
24.24 2 12.12 1.91 28.10 14.35 86.25 a9fj0zn7tw53y SQL Developer select count(*) from violation
19.70 1 19.70 1.56 20.00 3.30 98.52 dtqp2h7sz87zj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
16.03 1 16.03 1.26 22.13 31.55 72.41 4yvaw975pp5nc MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
14.20 1 14.20 1.12 20.47 35.01 69.38 9wgm572gtzrrj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
12.68 1 12.68 1.00 16.78 27.97 75.61 1ymufkfzh7068 MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...

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
28,522,614 3,150 9,054.80 27.19 118.61 98.1 .2 6kzu3sqd5td74 AppServer.exe select t0.ASSET_IDENTIFIER, t0...
17,121,375 725 23,615.69 16.32 189.15 75.9 24.1 5c0wjsy0htg35 AppServer.exe BEGIN Identity_Mgr.verify(:Par...
11,243,951 184,165 61.05 10.72 172.10 35.8 36.6 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
8,008,365 885 9,049.00 7.63 40.77 98.1 .5 7mpjdtwz6v52x AppServer.exe select t0.CLSID, t0.ISIN, t0.g...
7,197,542 44,541 161.59 6.86 5.97 99.5 0 7c7y069131k88 AppServer.exe SELECT GUID FROM TIDMTMPPENDIN...
4,639,224 37 125,384.43 4.42 56.83 97 0 6tx6rtvjfjp18 AppServer.exe select t0.TARGET_FUND_MAX_INVE...
4,471,414 95 47,067.52 4.26 22.85 91.3 8.1 fuhd2wb26t6j4 AppServer.exe DECLARE chain_and_null BOOLEAN...
4,466,948 95 47,020.51 4.26 22.35 92.3 7.2 7w0k1yncv6x12 AppServer.exe UPDATE TASSET SET CLSID = TREA...
3,382,877 434 7,794.65 3.22 22.01 96.9 1.9 b37cmsnb8sssq AppServer.exe select t0.CLSID, t0.SEDOL, t0....
3,199,905 71,109 45.00 3.05 10.34 99.7 .2 f9j5xqsbx468g AppServer.exe SELECT COUNT(1) FROM TCLASSATT...
2,503,500 20 125,175.00 2.39 16.70 97.6 0 a2d330h5ztu00 AppServer.exe select t0.TARGET_FUND_MAX_INVE...
2,370,838 262 9,049.00 2.26 15.45 98.9 0 cyng1tf6fmx5p AppServer.exe select t0.CLSID, t0.TECH_ID_GE...
1,333,623 111 12,014.62 1.27 15.07 98.9 0 f7hsjuf8th60z AppServer.exe select t0.valid_at, t0.RULE, t...
1,319,327 606 2,177.11 1.26 10.91 96.2 0 anh0trnf9jmub AppServer.exe select t0.valid_at, t0.RULE, t...
1,226,452 1 1,226,452.00 1.17 263.76 16.5 84.2 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
1,191,285 2 595,642.50 1.14 84.47 12.1 83.7 4b3uyh2az3drf AppServer.exe select transactionid, tsid, ts...
1,189,079 375 3,170.88 1.13 6.89 99.5 0 6hw8ny3kjan6q AppServer.exe UPDATE TDATAOVERRIDE SET DATAC...
1,169,943 109,552 10.68 1.12 12.25 97.8 2.9 6ppwsfsvfuaxu AppServer.exe SELECT guid, clsid FROM tasset...
1,118,675 368,676 3.03 1.07 48.85 24.6 .2 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
1,210,341 1 1,210,341.00 26.17 263.76 16.55 84.16 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
1,191,078 2 595,539.00 25.76 84.47 12.11 83.75 4b3uyh2az3drf AppServer.exe select transactionid, tsid, ts...
374,976 13 28,844.31 8.11 34.44 16.44 81.95 1nawuxww54b35 AppServer.exe select t0.REC_IMPORTED, t0.CLA...
259,068 2 129,534.00 5.60 81.61 18.25 84.12 a9ss1cmky0hmj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
129,533 1 129,533.00 2.80 22.13 31.55 72.41 4yvaw975pp5nc MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
129,532 1 129,532.00 2.80 16.78 27.97 75.61 1ymufkfzh7068 MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
129,532 1 129,532.00 2.80 20.47 35.01 69.38 9wgm572gtzrrj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
127,376 1 127,376.00 2.75 72.38 11.64 89.95 0p83b4kma7mku MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
86,159 1 86,159.00 1.86 83.73 35.41 72.13 6uray8wscdpfd MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
79,353 1 79,353.00 1.72 47.42 14.09 95.81 gwvhphg2xfdk9 AppServer.exe select count(1) from TASSET t0...
79,125 2 39,562.50 1.71 28.10 14.35 86.25 a9fj0zn7tw53y SQL Developer select count(*) from violation
73,778 725 101.76 1.60 189.15 75.92 24.06 5c0wjsy0htg35 AppServer.exe BEGIN Identity_Mgr.verify(:Par...

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
1,086,694 1,086,694 1 1,086,694.00 0.00 37.10 3p0madf36bzhj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
127,962 127,962 2 63,981.00 0.00 4.37 a9ss1cmky0hmj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
127,960 127,960 1 127,960.00 0.00 4.37 4yvaw975pp5nc MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
127,959 127,959 1 127,959.00 0.00 4.37 1ymufkfzh7068 MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
127,959 127,959 1 127,959.00 0.00 4.37 9wgm572gtzrrj MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
125,794 125,794 1 125,794.00 0.00 4.29 0p83b4kma7mku MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
86,159 86,159 1 86,159.00 0.00 2.94 6uray8wscdpfd MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...
67,750 67,750 1 67,750.00 0.00 2.31 gwvhphg2xfdk9 AppServer.exe select count(1) from TASSET t0...
32,413 32,413 1 32,413.00 0.00 1.11 b4x6m9tp9f8y4 MIGTester.exe SELECT /*+ OPT_PARAM('_b_tree_...
20,144 20,144 2 10,072.00 0.00 0.69 5y824f1krct7w MIGAdmin.exe SELECT /*+ OPT_PARAM('_b_tree_...

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
368,676 368,676 1.00 48.85 24.6 .2 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
184,173 184,173 1.00 46.98 20.2 0 dwf8hakmt8d2t MIGTester.exe Select SEQViolation.nextval fr...
184,165 184,165 1.00 172.10 35.8 36.6 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
178,328 178,329 1.00 56.52 28.7 .1 8sa2bmsr7t2ac MIGTester.exe Select SEQREPORTINFO.nextval f...
109,552 109,113 1.00 12.25 97.8 2.9 6ppwsfsvfuaxu AppServer.exe SELECT guid, clsid FROM tasset...
71,109 71,109 1.00 10.34 99.7 .2 f9j5xqsbx468g AppServer.exe SELECT COUNT(1) FROM TCLASSATT...
53,870 10,223 0.19 4.47 92.5 7.2 ga020vgufg0g3 AppServer.exe SELECT guid, clsid FROM tholdi...
44,541 5 0.00 5.97 99.5 0 7c7y069131k88 AppServer.exe SELECT GUID FROM TIDMTMPPENDIN...
34,473 34,473 1.00 0.65 97 0 033sqqug6sj2p AppServer.exe SELECT AUDITED FROM TCLASS WHE...
24,376 23,305 0.96 3.51 80.6 20.5 8j7h07rtz8gj2 AppServer.exe SELECT guid, clsid FROM tasset...
24,058 24,087 1.00 2.51 100.1 0 7ff63phrrsdkd AppServer.exe SELECT guid, clsid FROM tasset...
20,383 20,383 1.00 5.33 63.6 39.3 3zggvhmf61vgz AppServer.exe INSERT INTO AASSET (CLSID, GUI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
184,173 184,173 24.57 dwf8hakmt8d2t MIGTester.exe Select SEQViolation.nextval fr...
184,166 184,165 24.57 9jzr3wuyxa45f MIGTester.exe INSERT INTO VIOLATION (RuleIde...
178,328 178,328 23.79 8sa2bmsr7t2ac MIGTester.exe Select SEQREPORTINFO.nextval f...
7,193 7,194 0.96 aqd1a2u2nz7wc CoreServer.exe select guid, type, xref, tsid,...
6,136 6,136 0.82 05n7drgfff0w3 MIGTester.exe Select SEQEventProtocol.nextva...
6,136 6,136 0.82 8huy3nxk8p8w6 MIGTester.exe Insert into EVENTPROTOCOL (Eve...
4,258 4,259 0.57 cj1yzkttx77qs AppServer.exe BEGIN Globals.setvalidity(:val...
3,150 3,150 0.42 6kzu3sqd5td74 AppServer.exe select t0.ASSET_IDENTIFIER, t0...
2,662 2,663 0.36 8m83cnc08chy0 AppServer.exe select count(1) from TGLOBAL t...
2,591 2,591 0.35 6bvn4a0zb2fub MIGTester.exe Update violation set is_closed...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
4,015,661 11 0.25 dxpgzrxg3sgyz AppServer.exe SELECT SUM(BYTES) FROM USER_SE...
3,386,738 10 0.21 1ggpbzhtjqdym AppServer.exe select SUM(bytes)/1024/1024 SC...
3,236,737 7 0.20 6ywva00xmu8wy AppServer.exe SELECT bytes/1024/1024 TABLESI...
2,744,877 10 0.17 77mvtzddmd8wy AppServer.exe select round(sum(bytes)/(1024...
2,629,250 5 0.16 6wm3n4d7bnddg   SELECT source, (case when tim...
2,399,142 10 0.15 dzj65gxcvf3d1 AppServer.exe SELECT bytes/1024/1024 TABLESI...
1,462,510 412 0.09 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
1,138,021 5 0.07 691p2a1hswk0m   insert into wrh$_seg_stat_obj ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
38 412 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
36 10 69k5bhm12sz98   SELECT dbin.instance_number, d...
25 137 5rygsj4dbw6jt   insert into sys.mon_mods$ (obj...
25 881 cc9zsuq5cchjx AppServer.exe SELECT LOCK_FLAG, SID FROM TIM...
22 188 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
22 725 5j2kd8pkmx7v1 AppServer.exe UPDATE TIMPORT_LOCK SET LOCK_F...
21 5 5s34t44u10q4g   SELECT a.name task_name, nvl(e...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
033sqqug6sj2p SELECT AUDITED FROM TCLASS WHERE GUID = :B1
05n7drgfff0w3 Select SEQEventProtocol.nextval from DUAL
0p83b4kma7mku SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27935, 27936, 27937, 27940, 27943, 27944, 27946, 27947, 27948, 27949, 27950, 27952, 27953, 27954, 27956, 27958, 27959, 27960, 27964, 27966, 27970, 27974, 27988, 27989, 27990, 28021, 28022, 28051, 28052, 28065, 28066, 28068)) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobjectiden t = v.testobjectident AND (V.RuleIdent=38623)AND (V.TestObjectIdent=6789)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
1ggpbzhtjqdym select SUM(bytes)/1024/1024 SCHEMASIZE FROM user_segments
1nawuxww54b35 select t0.REC_IMPORTED, t0.CLASS, t0.OV_UNAPPLIED, t0.valid_at, t0.LEVEL_, t0.REC_UNCHANGED, t0.OV_CONFLICTS, t0.MESSAGE, t0.OV_APPLIED, t0.IMPORT, t0.REC_TOTAL, t0.STARTTIME, t0.REC_NEW, t0.RUN_, t0.DURATION, t0.CLSID, t0.xref, t0.REC_OTHERCLASSES, t0.ID_FAILS, t0.ID_DUPLICATES, t0.guid, t0.tsid from TIMPORTCLASSRUN t0 where ((t0.CLSID in (select * from table(:p0))) and ((t0.STARTTIME >= :p1) and (t0.STARTTIME < :p2)))
1ymufkfzh7068 SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27996, 27997, 27998, 27999, 28000, 28001, 28002, 28003, 28027, 28028, 28059, 28063, 28073, 28074)) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.RuleIdent=38623)AND (V.TestObjectIdent=6789)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
26gp329zqvq05 SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27983, 27984, 27985, 27987, 28004, 28005, 28006, 28007, 28009, 28012, 28013, 28014, 28015, 28017, 28019, 28029, 28030, 28031, 28032, 28033, 28034, 28035, 28036, 28037, 28038, 28039, 28040, 28041, 28042, 28043, 28044, 28045, 28053, 28055, 28060, 28061, 28062, 28064, 28075)) AND (v.flag_deletion = 0 OR v.fla g_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.TestObjectIdent=4680)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
3p0madf36bzhj SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27983, 27984, 27985, 27987, 28004, 28005, 28006, 28007, 28009, 28012, 28013, 28014, 28015, 28017, 28019, 28029, 28030, 28031, 28032, 28033, 28034, 28035, 28036, 28037, 28038, 28039, 28040, 28041, 28042, 28043, 28044, 28045, 28053, 28055, 28060, 28061, 28062, 28064, 28075)) AND (v.flag_deletion = 0 OR v.fla g_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.RuleIdent=37776)AND (V.TestObjectIdent=4680)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
3zggvhmf61vgz INSERT INTO AASSET (CLSID, GUID, TSID, TSTIME, TSUSER, XREF, TRANSACTIONID, OLDVALUE, NEWVALUE, IPADDRESS) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , DBMS_TRANSACTION.LOCAL_TRANSACTION_ID, :B9 , :B8 , :B7 )
4b3uyh2az3drf select transactionid, tsid, tstime, tsuser, ipaddress, newvalue, oldvalue from AASSET where guid = :p0 order by tsid desc
4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4yvaw975pp5nc SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident=27915) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.RuleIdent=38623)AND (V.TestObjectIdent=6789)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C. RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
5c0wjsy0htg35 BEGIN Identity_Mgr.verify(:Parameter1, :Parameter2); END;
5j2kd8pkmx7v1 UPDATE TIMPORT_LOCK SET LOCK_FLAG = 1, SID = :B2 WHERE TABLE_NAME = :B1
5rygsj4dbw6jt insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
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
5y824f1krct7w SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27983, 27984, 27985, 27987, 28004, 28005, 28006, 28007, 28009, 28012, 28013, 28014, 28015, 28017, 28019, 28029, 28030, 28031, 28032, 28033, 28034, 28035, 28036, 28037, 28038, 28039, 28040, 28041, 28042, 28043, 28044, 28045, 28053, 28055, 28060, 28061, 28062, 28064, 28075)) AND (v.flag_deletion = 0 OR v.fla g_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.RuleIdent=36090)AND (V.TestObjectIdent=5717)AND V.SeverityIdent IN (2) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
691p2a1hswk0m insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.tsn_kewrseg and at.num2_kewrattr = ss1.objn_kewrseg and at.num3_kewrattr = ss1.objd_kewrseg and at.num2_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
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
6bvn4a0zb2fub Update violation set is_closed = :1, enddate = :2 where ViolationIdent = :3
6hw8ny3kjan6q UPDATE TDATAOVERRIDE SET DATACLASSREF =:B1 WHERE DATAOBJECTREF = :B2
6kzu3sqd5td74 select t0.ASSET_IDENTIFIER, t0.CLSID, t0.guid, t0.tsid from TASSET t0 where (t0.ASSET_IDENTIFIER = :p0) and t0.clsid in (select c.guid from tclass c start with c.guid = :p1 connect by prior c.guid = c.base)
6ppwsfsvfuaxu SELECT guid, clsid FROM tasset WHERE 1 = 1 AND asset_id_mig = :b3 AND clsid IN (SELECT * FROM tidmtemp) UNION SELECT /*+ NO_INDEX_FFS(tidmpending PK_IDMPENDING ) INDEX_RS_ASC(tidmpending PK_IDMPENDING ) */ guid, clsid FROM tidmpending WHERE identity_guid = :b1 AND key_values = :b2 AND clsid IN (SELECT * FROM tidmtemp)
6tx6rtvjfjp18 select t0.TARGET_FUND_MAX_INVESTMENT, t0.TOTAL_NET_ASSETS.MC, t0.TOTAL_NET_ASSETS.MV, t0.FREEFIELD_S02, t0.DESCRIPTION, t0.GUARANTOR, t0.EMBEDDED_LEVERAGE, t0.LIQUID, t0.RATING_LT_FITCH, t0.valid_at, t0.SECURED_BY_PHYSICAL_COMMODI613, t0.FREE_OF_CHARGE, t0.INDEX_TRACKING_FLAG, t0.EQUIVALENT_PROTECTION, t0.COMPLIANT_TO_CODE, t0.PURCHASE_DATE, t0.ASSET_MANAGEMENT_REGULATED, t0.UL_SEC_CLASS, t0.MANAGEMENT_FEES, t0.DIVIDEND_DATE, t0.SHARES_OUTSTANDING, t0.INDEX_LINKED, t0.CLASSNAME_MANUAL, t0.CALL_PUT, t0.IAS, t0.VOTING_RIGHTS, t0.CASCADE_WARRANT_PERCENTAGE, t0.RATING_LT_SP, t0.VOTING_RIGHTS_VER, t0.LT_CHECKINGUNITID, t0.NEGOTIABILITY, t0.SEC_MAPPED, t0.MARKET_SEGMENT, t0.OTHER_ASSET_INDICATOR, t0.RATING_ST_MOODYS, t0.LOAD_EXIT_FEE, t0.ISSUER_LIST_COUNTRY_DOMICILE, t0.UL_RISK_CLASS1, t0.SELL_CURRENCY, t0.UNITS_UL_EXPOSURE_CLASS, t0.ASSET_ID, t0.IS_OCCUPIED, t0.CIS_THEME, t0.ASSET_IDENTIFIER_UNIFIED, t0.CERTIFICATE_SHORT, t0.CASCADE_UNITS_PERCENT AGE, t0.SHARE_ORDINARY, t0.UL_IS_COVERED_BOND, t0.TECH_ID_GENEVA, t0.OPTION_TYPE, t0.UL_INDUSTRY_CLASS, t0.TARGET_FUND_UMBRELLA_INV, t0.FLOATER_FLAG, t0.COUPON_RATE_EFFECTIVE_DATE, t0.UL_PRICE.MC, t0.UL_PRICE.MV, t0.CONTRACT_SIZE_FX_BUY.MC, t0.CONTRACT_SIZE_FX_BUY.MV, t0.HEDGE_REGION, t0.RISK_CLASS, t0.CLASSCHANGETIME, t0.SHARECLASS, t0.REIT, t0.SWAPS_EXCLUDED_FROM_MARKET_501, t0.CONTRACT_SIZE_FX_SELL.MC, t0.CONTRACT_SIZE_FX_SELL.MV, t0.MORTGAGE_VALUE.MC, t0.MORTGAGE_VALUE.MV, t0.YIELD, t0.FUND_OF_FUNDS, t0.PENDING_PLACEMENT, t0.CONTRACT_SIZE_SWAPS_SHORT.MC, t0.CONTRACT_SIZE_SWAPS_SHORT.MV, t0.SEC_AVOID_CIRCLE, t0.HSBC_COMMENT, t0.BUY_CURRENCY, t0.INITIAL_MARGIN, t0.SATISFIES_RATING_REQ_OF_APP035, t0.FIRST_TO_DEFAULT, t0.STRIKE_PRICE.MC, t0.STRIKE_PRICE.MV, t0.CORRELATION_CRITERIA_INDEX, t0.PARTLY_PAID_FLAG, t0.TOTAL_AMOUNT_OUTSTANDING.MC, t0.TOTAL_AMOUNT_OUTSTANDING.MV, t0.RATING_ST_INTERNAL_SUFFICIENT, t0.UL_EXCHANGE_DOMICILE, t0.LASTCLASS, t0.BOND_EXCHANGE_LIST, t0.APPROPRIATE_INFORMATION, t0.LOCK_UP_PERIOD, t0.MANUALINPUT, t0.QUICK_CODE, t0.PORTFOLIOCODE, t0.UL_ISSUER_DOMICILE, t0.PROPERTY_LOCATION, t0.SHARES_OUTSTANDING_REMARK, t0.COUNTERPARTY_MARKET, t0.FREEFIELD_D01, t0.INDUSTRY_CLASS, t0.ISIN, t0.COUNTERPARTY, t0.SEC_CLASS, t0.OVERRIDESTATUS, t0.IS_IMMOVABLE_ACCEPTABLE_TYPE, t0.FREEFIELD_S01, t0.UL_INDEX_ACCEPTABLE, t0.CUSIP, t0.RIC, t0.PROPERTY_VALUATION.MC, t0.PROPERTY_VALUATION.MV, t0.REDEMPTIONS_PA, t0.INFLATION_LINKED, t0.TARGET_FUND_CATEGORY, t0.TARGET_FUND_INVESTMENTS_CHA0CF, t0.ISSUE_DATE, t0.INVESTS_IN_SPECIAL_SITUATIONS, t0.SECURITYPUBLIC_ISSUER_UP_TOBD9, t0.RELIABLE_VALUATION, t0.UL_SATISFIES_RATING_REQ_1_2_4, t0.XCHANGES, t0.ISSUE_SIZE.MC, t0.ISSUE_SIZE.MV, t0.NON_UCITS_SCHEME, t0.ETF, t0.NOMINAL_VALUE.MC, t0.NOMINAL_VALUE.MV, t0.INVESTS_IN_FEEDER, t0.DIVIDEND_RATE, t0.VOTING_SHARES, t0.RATING_ST_FITCH, t0.INVESTS_IN_FOHF, t0.SUSPENDED_FROM_IMPORT_FILE, t0.INV _FD_SHARES_OS, t0.FREEFIELD_F03, t0.REPAY_OR_WITHDRAW_ON_DEMAND, t0.TECH_ID_REUTERS, t0.PRICE_CTD_REFERENCE_BOND.MC, t0.PRICE_CTD_REFERENCE_BOND.MV, t0.FREEFIELD_F01, t0.TARGET_FUND_UMBRELLA, t0.FI_TOTAL_DEBT_ISSUED.MC, t0.FI_TOTAL_DEBT_ISSUED.MV, t0.DEBT_TYPE, t0.ISSUER, t0.FREELY_TRANSFERABLE, t0.VALUATION_REPORT_DATE, t0.CORPORATE_GOVERNANCE, t0.ASSET_TYPE_REUTERS, t0.FUND_TOTAL_ASSETS_BB.MC, t0.FUND_TOTAL_ASSETS_BB.MV, t0.OPTIONS_SERIES, t0.UCITS_COMPLIANT, t0.CONTRACT_SIZE_SWAPS_LONG.MC, t0.CONTRACT_SIZE_SWAPS_LONG.MV, t0.HIGHLY_LIQUID, t0.PROTECTION_BUYER, t0.NOT_CASCADE_SAME_UMBRELLA, t0.BASIC_NON_BASIC, t0.ACTIVE, t0.ASSET_CURRENCY, t0.INTEREST_RATE_CURRENCY, t0.RECOGNISED_SCHEME, t0.DATE_OF_MATURITY, t0.CLSID, t0.ASSET_SUBTYPE_REUTERS, t0.IMPORTSTATUS, t0.UL_SATISFIES_RATING_REQ_2_4_6, t0.COMPATIBLE_WITH_FUND, t0.AVG_DAILY_TRADED_VOLUME.MC, t0.AVG_DAILY_TRADED_VOLUME.MV, t0.DERIVATIVE_COMPONENT_EMBEDDED, t0.xref, t0.TARGET_FUND_NAV_UNIFI ED.MC, t0.TARGET_FUND_NAV_UNIFIED.MV, t0.SECURITY_144A_QUALIFYING, t0.AVG_BID_ASK_SPREAD, t0.DERIVATIVE_APPROVED, t0.RATING_LT_MOODYS, t0.RISK_PROFILE_MMI, t0.COMMODITY_TYPE, t0.INVESTMENT_MANAGER, t0.MATURITY_CORP_MOD_DURATION, t0.TECH_ID_ICON, t0.AUTHORISED_APP6, t0.EXERCISE_PRICE.MC, t0.EXERCISE_PRICE.MV, t0.NO_POTENTIAL_LOSS, t0.UL_COUNTRY_OF_EXPOSURE, t0.DURATION, t0.UL_SATISFIES_RATING_REQ_2_4_4, t0.COUNTRY_OF_EXPOSURE, t0.CONTRACT_SIZE.MC, t0.CONTRACT_SIZE.MV, t0.IS_IMMOVABLE, t0.JOINTLY_LIABLE, t0.NEXT_CALL_DATE, t0.PAYER_RECEIVER_SWAP, t0.LOCK_UP_START_DATE, t0.COUPON_RATE, t0.PRIVATE_PLACEMENT, t0.FEEDER_FUND, t0.AUTHORISED, t0.SECURITY_ID, t0.UL_ASSET, t0.MONTH_OF_MATURITY, t0.UL_STRUCTURE, t0.ISIN_LIST, t0.ISSUER_LIST, t0.COVERED_BOND, t0.INCOME_PRODUCING, t0.ASSET_IDENTIFIER, t0.VOTING_RIGHTS_VERIFIED, t0.SEDOL, t0.CASH_SETTLEMENT, t0.PREMIUM.MC, t0.PREMIUM.MV, t0.NON_VOTING_SHARES, t0.ELIGIBLE_ASSET, t0.NEXT_RATE_RESET_DATE, t0.IMMOVABLE_INCOME_RECEIVABLE.MC, t0.IMMOVABLE_INCOME_RECEIVABLE.MV, t0.STAGNATION_REMARK, t0.MATURITY, t0.PURCHASE_PRICE.MC, t0.PURCHASE_PRICE.MV, t0.TOTAL_NUMBER_UNITS, t0.COUPON_TYPE, t0.MANUALASSETCLASS, t0.ISSUER_MARKET, t0.guid, t0.GIGS_CODE, t0.PROTECTED_BY_CLIENT_MONEY_RCDA, t0.IMPORTSOURCE, t0.RATING_ST_SP, t0.DIVIDEND_PAYED.MC, t0.DIVIDEND_PAYED.MV, t0.DESCRIPTION_ICON, t0.EXCHANGES_LISTED, t0.REGULATED, t0.tsid, t0.NUM_OVERDRAWN_DAYS_LAST180 from TASSET t0
6uray8wscdpfd SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27996, 27997, 27998, 27999, 28000, 28001, 28002, 28003, 28027, 28028, 28059, 28063, 28073, 28074)) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.TestObjectIdent BETWEEN 4566 AND 4568 OR V.TestObjectIdent BETWEEN 6426 AND 6429 OR V.TestObjectI dent BETWEEN 7266 AND 7271 OR V.TestObjectIdent IN (4570, 4571, 4573, 4574, 4576, 4577, 4580, 4582, 6094, 6203, 6204, 6417, 6518, 6676, 6828))AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6ywva00xmu8wy SELECT bytes/1024/1024 TABLESIZE from user_segments s where s.segment_name = 'THOLDINGS'
77mvtzddmd8wy select round(sum(bytes)/(1024*1024*1024), 0)||'GB' DBSize from user_segments
7c7y069131k88 SELECT GUID FROM TIDMTMPPENDING WHERE KEY_VALUES = :B2 AND IDENTITY_GUID = :B1
7ff63phrrsdkd SELECT guid, clsid FROM tasset WHERE 1 = 1 AND asset_currency = :b3 AND isin = :b4 AND clsid IN (SELECT * FROM tidmtemp) UNION SELECT /*+ NO_INDEX_FFS(tidmpending PK_IDMPENDING ) INDEX_RS_ASC(tidmpending PK_IDMPENDING ) */ guid, clsid FROM tidmpending WHERE identity_guid = :b1 AND key_values = :b2 AND clsid IN (SELECT * FROM tidmtemp)
7mpjdtwz6v52x select t0.CLSID, t0.ISIN, t0.guid, t0.tsid from TASSET t0 where (t0.ISIN = :p0)
7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7w0k1yncv6x12 UPDATE TASSET SET CLSID = TREAT(:B1 AS RECLS_OT).NEWCLSID, TSID = TSID + 1 WHERE GUID = TREAT(:B2 AS RECLS_OT).GUID
8huy3nxk8p8w6 Insert into EVENTPROTOCOL (EventId, SystemMandantIdent, Module, EventText, AccessDate, Status, UserName, IP_Address) Values (:1, :2, :3, :4, :5, :6, :7, :8)
8j7h07rtz8gj2 SELECT guid, clsid FROM tasset WHERE 1 = 1 AND tech_id_reuters = :b3 AND clsid IN (SELECT * FROM tidmtemp) UNION SELECT /*+ NO_INDEX_FFS(tidmpending PK_IDMPENDING ) INDEX_RS_ASC(tidmpending PK_IDMPENDING ) */ guid, clsid FROM tidmpending WHERE identity_guid = :b1 AND key_values = :b2 AND clsid IN (SELECT * FROM tidmtemp)
8m83cnc08chy0 select count(1) from TGLOBAL t0 where t0.clsid = :p0
8sa2bmsr7t2ac Select SEQREPORTINFO.nextval from DUAL
9jzr3wuyxa45f INSERT INTO VIOLATION (RuleIdent, TestObjectIdent, CheckIdent, PosCheckDetailIdent, CheckDate, ReportViolationId, Explanation_Blob, Number_Of_Days, Number_Of_NAVDates, Maximum_Exposure, ViolationFactor, SeverityIdent, PositionChange, Exposure, StartDate, MaxExpDate, WknList, To_Be_Reported, FromLastQuartal, NavInEuro, MaxVf, RuleVersion, KeyInfo, KeyInfoValue, ForeachAttribute, RuleFromType, Path, Params, ViolationIdent, ForEachExposures, AllForEachExposures, DATAIDENT, REMARK, WAS_SEEN_BY, WAS_SEEN_AT, WAS_SEEN_BY2, WAS_SEEN_AT2, CORRECTED, REPLACEDVIOLATION, Flag_Deletion, TechRem) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29 , :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41)
9wgm572gtzrrj SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27965, 27967, 27971, 27975, 27976, 27977, 27979, 27980, 27981, 27992, 27993, 27994, 27995, 28008, 28010, 28011, 28023, 28024, 28025, 28026, 28048, 28054, 28056, 28057, 28058, 28067, 28069, 28071, 28072)) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.RuleIdent=38623)AND (V.TestObjectIdent=6789)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
a2d330h5ztu00 select t0.TARGET_FUND_MAX_INVESTMENT, t0.TOTAL_NET_ASSETS.MC, t0.TOTAL_NET_ASSETS.MV, t0.DESCRIPTION, t0.GUARANTOR, t0.LIQUID, t0.RATING_LT_FITCH, t0.valid_at, t0.SECURED_BY_PHYSICAL_COMMODI613, t0.INDEX_TRACKING_FLAG, t0.EQUIVALENT_PROTECTION, t0.COMPLIANT_TO_CODE, t0.ASSET_MANAGEMENT_REGULATED, t0.UL_SEC_CLASS, t0.MANAGEMENT_FEES, t0.DIVIDEND_DATE, t0.SHARES_OUTSTANDING, t0.INDEX_LINKED, t0.IAS, t0.VOTING_RIGHTS, t0.CASCADE_WARRANT_PERCENTAGE, t0.RATING_LT_SP, t0.VOTING_RIGHTS_VER, t0.LT_CHECKINGUNITID, t0.NEGOTIABILITY, t0.SEC_MAPPED, t0.MARKET_SEGMENT, t0.OTHER_ASSET_INDICATOR, t0.RATING_ST_MOODYS, t0.LOAD_EXIT_FEE, t0.UL_RISK_CLASS1, t0.UNITS_UL_EXPOSURE_CLASS, t0.ASSET_ID, t0.CIS_THEME, t0.ASSET_IDENTIFIER_UNIFIED, t0.CERTIFICATE_SHORT, t0.CASCADE_UNITS_PERCENTAGE, t0.SHARE_ORDINARY, t0.UL_IS_COVERED_BOND, t0.TECH_ID_GENEVA, t0.UL_INDUSTRY_CLASS, t0.TARGET_FUND_UMBRELLA_INV, t0.FLOATER_FLAG, t0.COUPON_RATE_EFFECTIVE_DATE, t0.UL_PRICE.MC , t0.UL_PRICE.MV, t0.HEDGE_REGION, t0.RISK_CLASS, t0.CLASSCHANGETIME, t0.REIT, t0.YIELD, t0.FUND_OF_FUNDS, t0.SEC_AVOID_CIRCLE, t0.HSBC_COMMENT, t0.SATISFIES_RATING_REQ_OF_APP035, t0.CORRELATION_CRITERIA_INDEX, t0.PARTLY_PAID_FLAG, t0.TOTAL_AMOUNT_OUTSTANDING.MC, t0.TOTAL_AMOUNT_OUTSTANDING.MV, t0.RATING_ST_INTERNAL_SUFFICIENT, t0.LASTCLASS, t0.BOND_EXCHANGE_LIST, t0.APPROPRIATE_INFORMATION, t0.LOCK_UP_PERIOD, t0.MANUALINPUT, t0.QUICK_CODE, t0.PORTFOLIOCODE, t0.UL_ISSUER_DOMICILE, t0.SHARES_OUTSTANDING_REMARK, t0.INDUSTRY_CLASS, t0.ISIN, t0.SEC_CLASS, t0.OVERRIDESTATUS, t0.FREEFIELD_S01, t0.UL_INDEX_ACCEPTABLE, t0.CUSIP, t0.RIC, t0.REDEMPTIONS_PA, t0.INFLATION_LINKED, t0.TARGET_FUND_CATEGORY, t0.TARGET_FUND_INVESTMENTS_CHA0CF, t0.ISSUE_DATE, t0.INVESTS_IN_SPECIAL_SITUATIONS, t0.SECURITYPUBLIC_ISSUER_UP_TOBD9, t0.RELIABLE_VALUATION, t0.XCHANGES, t0.ISSUE_SIZE.MC, t0.ISSUE_SIZE.MV, t0.NON_UCITS_SCHEME, t0.ETF, t0.NOMINAL_VALUE.MC, t0.NOMINAL _VALUE.MV, t0.INVESTS_IN_FEEDER, t0.DIVIDEND_RATE, t0.VOTING_SHARES, t0.RATING_ST_FITCH, t0.INVESTS_IN_FOHF, t0.SUSPENDED_FROM_IMPORT_FILE, t0.INV_FD_SHARES_OS, t0.FREEFIELD_F03, t0.TECH_ID_REUTERS, t0.TARGET_FUND_UMBRELLA, t0.FI_TOTAL_DEBT_ISSUED.MC, t0.FI_TOTAL_DEBT_ISSUED.MV, t0.DEBT_TYPE, t0.ISSUER, t0.FREELY_TRANSFERABLE, t0.CORPORATE_GOVERNANCE, t0.ASSET_TYPE_REUTERS, t0.FUND_TOTAL_ASSETS_BB.MC, t0.FUND_TOTAL_ASSETS_BB.MV, t0.UCITS_COMPLIANT, t0.HIGHLY_LIQUID, t0.PROTECTION_BUYER, t0.NOT_CASCADE_SAME_UMBRELLA, t0.ACTIVE, t0.ASSET_CURRENCY, t0.RECOGNISED_SCHEME, t0.DATE_OF_MATURITY, t0.CLSID, t0.ASSET_SUBTYPE_REUTERS, t0.IMPORTSTATUS, t0.COMPATIBLE_WITH_FUND, t0.AVG_DAILY_TRADED_VOLUME.MC, t0.AVG_DAILY_TRADED_VOLUME.MV, t0.DERIVATIVE_COMPONENT_EMBEDDED, t0.xref, t0.TARGET_FUND_NAV_UNIFIED.MC, t0.TARGET_FUND_NAV_UNIFIED.MV, t0.SECURITY_144A_QUALIFYING, t0.AVG_BID_ASK_SPREAD, t0.RATING_LT_MOODYS, t0.RISK_PROFILE_MMI, t0.INVESTMENT_MANAGER, t0.MATURITY_CORP_MOD_DURATION, t0.TECH_ID_ICON, t0.AUTHORISED_APP6, t0.NO_POTENTIAL_LOSS, t0.UL_COUNTRY_OF_EXPOSURE, t0.DURATION, t0.COUNTRY_OF_EXPOSURE, t0.CONTRACT_SIZE.MC, t0.CONTRACT_SIZE.MV, t0.JOINTLY_LIABLE, t0.NEXT_CALL_DATE, t0.LOCK_UP_START_DATE, t0.COUPON_RATE, t0.PRIVATE_PLACEMENT, t0.FEEDER_FUND, t0.AUTHORISED, t0.SECURITY_ID, t0.UL_ASSET, t0.UL_STRUCTURE, t0.ISIN_LIST, t0.ISSUER_LIST, t0.COVERED_BOND, t0.INCOME_PRODUCING, t0.ASSET_IDENTIFIER, t0.VOTING_RIGHTS_VERIFIED, t0.SEDOL, t0.CASH_SETTLEMENT, t0.PREMIUM.MC, t0.PREMIUM.MV, t0.NON_VOTING_SHARES, t0.ELIGIBLE_ASSET, t0.NEXT_RATE_RESET_DATE, t0.STAGNATION_REMARK, t0.MATURITY, t0.TOTAL_NUMBER_UNITS, t0.COUPON_TYPE, t0.ISSUER_MARKET, t0.guid, t0.GIGS_CODE, t0.IMPORTSOURCE, t0.RATING_ST_SP, t0.DIVIDEND_PAYED.MC, t0.DIVIDEND_PAYED.MV, t0.DESCRIPTION_ICON, t0.EXCHANGES_LISTED, t0.REGULATED, t0.tsid from TASSET t0 where t0.clsid in (select c.guid from tclass c start with c.guid = : p0 connect by prior c.guid = c.base)
a9fj0zn7tw53y select count(*) from violation
a9ss1cmky0hmj SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27895, 27896, 27900, 27904, 27905, 27906, 27907, 27908, 27909, 27910, 27911, 27912, 27913, 27914, 27917, 27918, 27919, 27921, 27923, 27924, 27927, 27929, 27930, 27931, 27932, 27933, 27939, 27941, 27942, 27945, 27962, 27969, 27978)) AND (v.flag_deletion = 0 OR v.flag_deletion IS NULL) AND testobject.testobj ectident = v.testobjectident AND (V.RuleIdent=38623)AND (V.TestObjectIdent=6789)AND V.SeverityIdent IN (0, 1, 2, 3, 5) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
anh0trnf9jmub select t0.valid_at, t0.RULE, t0.CLOSEDSYSDATE, t0.APPLIEDCOUNTER, t0.VALIDFROM, t0.VALIDTO, t0.LASTAPPLIED, t0.CLOSEDAT, t0.APPLIEDCOUNTERHISTORIC, t0.STATUS, t0.WRONGVALUE, t0.REPLACEMENTVALUE, t0.REMARKS, t0.CLSID, t0.xref, t0.CREATED, t0.DATAATTRIBUTEREF, t0.DATACLASSREF, t0.ATTRIBUTENAME, t0.CONFLICTVALUE, t0.DATAOBJECTREF, t0.guid, t0.tsid from TDATAOVERRIDE t0 where ((((t0.DATAOBJECTREF in (select * from table(:p0))) and (t0.DATAATTRIBUTEREF = hextoraw(:p1))) and (t0.STATUS <= :p2)) and (t0.VALIDFROM is null or (t0.VALIDFROM <= :p3)))
aqd1a2u2nz7wc select guid, type, xref, tsid, version, changes, name, description, attributes, folder, changesetgroup, priority, creator, createtime, modifier, modifytime, owner, owntime, status, submitter, submittime, reviewer, reviewtime, reviewcomments, deployer, deploytime, deploynr, releaser, releasetime from files where DEL_FLAG ='0' and guid = :guid and project = :project
b37cmsnb8sssq select t0.CLSID, t0.SEDOL, t0.guid, t0.tsid from TASSET t0 where (t0.SEDOL = :p0)
b4x6m9tp9f8y4 SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ VIOLATIONIDENT, TESTOBJECTIDENT, RULEIDENT, REPORTVIOLATIONID, PARAMS, PATH, KEYINFO, SEVERITYIDENT, VIOLATIONFACTOR, NUMBER_OF_DAYS, NUMBER_OF_NAVDATES, MAXVF, STARTDATE, REMARK, FROMLASTQUARTAL, EXPOSURE, MAXIMUM_EXPOSURE, MAXEXPDATE, IS_CLOSED, TO_BE_REPORTED, FOREACHATTRIBUTE, RULEFROMTYPE, OLDSEVERITYIDENT, WAS_SEEN_BY, WAS_SEEN_AT, WAS_SEEN_BY2, WAS_SEEN_AT2, TECHREM FROM VIOLATION WHERE (SEVERITYIDENT <> 5) AND (FLAG_DELETION IS NULL OR FLAG_DELETION = 0) AND (POSCHECKDETAILIDENT, TESTOBJECTIDENT) IN ( SELECT PI.POSCHECKDETAILIDENT, PI.TESTOBJECTIDENT FROM POSCHECKDETAILINFO PI, POSCHECKDETAIL P, DATATRANSFER D WHERE P.POSCHECKDETAILIDENT = PI.POSCHECKDETAILIDENT AND P.DATAIDENT = D.DATAIDENT AND (D.POSITIONDATE, PI.TESTOBJECTIDENT) IN (SELECT MAX(D2.POSITIONDATE), PI2.TESTOBJECTIDENT FROM POSCHECKDETAILINFO PI2, POSCHECKDETAIL P2, DATATRANSFER D2 WHERE PI2.POSCHECKDETAILIDENT = P2.POSCHECKDETAILIDENT AND P2.D ATAIDENT = D2.DATAIDENT AND D2.POSITIONDATE < TO_DATE('29.06.2015 00:00:00' , 'DD.MM.YYYY HH24:MI:SS') AND (TESTOBJECTIDENT BETWEEN 4586 AND 4589 OR TESTOBJECTIDENT BETWEEN 4604 AND 4613 OR TESTOBJECTIDENT BETWEEN 4618 AND 4623 OR TESTOBJECTIDENT BETWEEN 4625 AND 4629 OR TESTOBJECTIDENT BETWEEN 4666 AND 4684 OR TESTOBJECTIDENT BETWEEN 4686 AND 4690 OR TESTOBJECTIDENT BETWEEN 4709 AND 4715 OR TESTOBJECTIDENT BETWEEN 4717 AND 4721 OR TESTOBJECTIDENT BETWEEN 4752 AND 4758 OR TESTOBJECTIDENT BETWEEN 4764 AND 4794 OR TESTOBJECTIDENT BETWEEN 4801 AND 4808 OR TESTOBJECTIDENT BETWEEN 5615 AND 5618 OR TESTOBJECTIDENT BETWEEN 5621 AND 5624 OR TESTOBJECTIDENT BETWEEN 5630 AND 5638 OR TESTOBJECTIDENT BETWEEN 5650 AND 5653 OR TESTOBJECTIDENT BETWEEN 5682 AND 5684 OR TESTOBJECTIDENT BETWEEN 5689 AND 5691 OR TESTOBJECTIDENT BETWEEN 5713 AND 5717 OR TESTOBJECTIDENT BETWEEN 5743 AND 5745 OR TESTOBJECTIDENT BETWEEN 6341 AND 6344 OR TESTOBJECTIDENT BETWEEN 6500 AND 6509 OR TESTOBJECTIDENT BETWEEN 6572 AND 6574 OR TESTOBJECTIDENT BETWEEN 6969 AND 6980 OR TESTOBJECTIDENT BETWEEN 6984 AND 6987 OR TESTOBJECTIDENT BETWEEN 7020 AND 7022 OR TESTOBJECTIDENT BETWEEN 7024 AND 7026 OR TESTOBJECTIDENT BETWEEN 7071 AND 7073 OR TESTOBJECTIDENT BETWEEN 7127 AND 7137 OR TESTOBJECTIDENT BETWEEN 7209 AND 7212 OR TESTOBJECTIDENT BETWEEN 7229 AND 7231 OR TESTOBJECTIDENT IN (4615, 4616, 4659, 4723, 4728, 4731, 4732, 4734, 4743, 4744, 4750, 4760, 4761, 4814, 4819, 4842, 4872, 4876, 4913, 4914, 4916, 5029, 5030, 5034, 5054, 5098, 5120, 5139, 5338, 5399, 5406, 5407, 5410, 5419, 5430, 5497, 5498, 5523, 5550, 5597, 5695, 5700, 5701, 5705, 5707, 5709, 5711, 5719, 5721, 5740, 5741, 5752, 5796, 5797, 5820, 5822, 5839, 5843, 5846, 6052, 6053, 6058, 6063, 6065, 6068, 6175, 6179, 6180, 6182, 6184, 6193, 6200, 6202, 6248, 6251, 6258, 6274, 6275, 6277, 6278, 6318, 6347, 6348, 6401, 6402, 6408, 6564, 6569, 6782, 6783, 6831, 6834, 6982, 6990, 7042, 7069, 7077, 7080, 7087, 7093, 7143, 7147, 7150, 7193, 7200, 7203, 722 6, 7227, 7259, 7265, 7278, 7281, 7287, 7297, 7303, 7304)) GROUP BY TESTOBJECTIDENT ) )
cc9zsuq5cchjx SELECT LOCK_FLAG, SID FROM TIMPORT_LOCK WHERE TABLE_NAME = :B1 FOR UPDATE
cj1yzkttx77qs BEGIN Globals.setvalidity(:valid_at, :valid_until); END;
cyng1tf6fmx5p select t0.CLSID, t0.TECH_ID_GENEVA, t0.guid, t0.tsid from TASSET t0 where (t0.TECH_ID_GENEVA = :p0)
dtqp2h7sz87zj SELECT /*+ OPT_PARAM('_b_tree_bitmap_plans' 'false') */ v.dataident AS vdataident, v.violationident, v.testobjectident, v.ruleident, v.checkident, v.keyinfo, v.rulefromtype, v.ruleversion, v.exposure, V.Explanation_Blob, v.explanation, v.number_of_days, v.remark, v.startdate, v.enddate, v.foreachexposures, v.wknlist, v.foreachattribute, v.was_seen_by, v.was_seen_by2, v.was_seen_at, v.was_seen_at2, v.is_closed, v.to_be_reported, v.violationfactor, v.severityident, v.oldseverityident, testobject.NAME, testobject.userdefinedident, v.PATH, v.params, v.dataident, v.reportviolationid, v.number_of_navdates FROM violation v, testobject WHERE (v.dataident IN (27983, 27984, 27985, 27987, 28004, 28005, 28006, 28007, 28009, 28012, 28013, 28014, 28015, 28017, 28019, 28029, 28030, 28031, 28032, 28033, 28034, 28035, 28036, 28037, 28038, 28039, 28040, 28041, 28042, 28043, 28044, 28045, 28053, 28055, 28060, 28061, 28062, 28064, 28075)) AND (v.flag_deletion = 0 OR v.fla g_deletion IS NULL) AND testobject.testobjectident = v.testobjectident AND (V.TestObjectIdent=5717)AND V.SeverityIdent IN (0, 1, 2, 3) AND RuleIdent IN (Select RuleIdent From RuleToCategory R2C Where (R2C.RuleCatIdent BETWEEN 892 AND 894 OR R2C.RuleCatIdent BETWEEN 901 AND 903 OR R2C.RuleCatIdent BETWEEN 912 AND 921 OR R2C.RuleCatIdent BETWEEN 932 AND 941 OR R2C.RuleCatIdent BETWEEN 944 AND 966 OR R2C.RuleCatIdent BETWEEN 971 AND 976 OR R2C.RuleCatIdent IN (880, 881, 886, 887, 897, 898, 906, 910))) ORDER BY TestObjectIdent
dwf8hakmt8d2t Select SEQViolation.nextval from DUAL
dxpgzrxg3sgyz SELECT SUM(BYTES) FROM USER_SEGMENTS
dzj65gxcvf3d1 SELECT bytes/1024/1024 TABLESIZE from user_segments s where s.segment_name = 'TASSET'
f7hsjuf8th60z select t0.valid_at, t0.RULE, t0.CLOSEDSYSDATE, t0.APPLIEDCOUNTER, t0.VALIDFROM, t0.VALIDTO, t0.LASTAPPLIED, t0.CLOSEDAT, t0.APPLIEDCOUNTERHISTORIC, t0.STATUS, t0.WRONGVALUE, t0.REPLACEMENTVALUE, t0.REMARKS, t0.CLSID, t0.xref, t0.CREATED, t0.DATAATTRIBUTEREF, t0.DATACLASSREF, t0.ATTRIBUTENAME, t0.CONFLICTVALUE, t0.DATAOBJECTREF, t0.guid, t0.tsid from TDATAOVERRIDE t0 where (((t0.STATUS <= :p0) and (t0.VALIDFROM is null or (t0.VALIDFROM <= :p1))) and (t0.DATAOBJECTREF in (select * from table(:p2)))) order by t0.DATAOBJECTREF
f9j5xqsbx468g SELECT COUNT(1) FROM TCLASSATTRIBUTES WHERE CLSID = :B2 AND ATTRIBUTENAME = UPPER(:B1 )
fuhd2wb26t6j4 DECLARE chain_and_null BOOLEAN; Parameter1 BOOLEAN; BEGIN chain_and_null := sys.diutil.int_to_bool(:chain_and_null); Bulk_Reclassification.RASSET(chain_and_null, :recls_in, Parameter1); :Parameter1 := sys.diutil.bool_to_int(Parameter1); END;
ga020vgufg0g3 SELECT guid, clsid FROM tholdings WHERE 1 = 1 AND position_identity = :b3 AND clsid IN (SELECT * FROM tidmtemp) UNION SELECT /*+ NO_INDEX_FFS(tidmpending PK_IDMPENDING ) INDEX_RS_ASC(tidmpending PK_IDMPENDING ) */ guid, clsid FROM tidmpending WHERE identity_guid = :b1 AND key_values = :b2 AND clsid IN (SELECT * FROM tidmtemp)
gwvhphg2xfdk9 select count(1) from TASSET t0 where (Upper(t0.ASSET_IDENTIFIER) like Upper(:p0) and Upper(t0.ISIN) like Upper(:p1)) and t0.clsid in (select c.guid from tclass c start with c.guid = :p2 connect by prior c.guid = c.base)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

Statistic Total per Second per Trans
db block changes 10,810,386 599.90 96.19
execute count 1,707,471 94.75 15.19
logons cumulative 368 0.02 0.00
opened cursors cumulative 1,482,504 82.27 13.19
parse count (total) 749,674 41.60 6.67
parse time elapsed 3,344 0.19 0.03
physical reads 4,624,243 256.61 41.15
physical writes 488,256 27.09 4.34
redo size 2,333,073,452 129,468.81 20,759.10
session cursor cache hits 404,487 22.45 3.60
session logical reads 104,908,512 5,821.67 933.45
user calls 2,064,126 114.54 18.37
user commits 112,369 6.24 1.00
user rollbacks 19 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 510,719 28.34 4.54

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Statistic Total per Second per Trans
Batched IO (bound) vector count 154,629 8.58 1.38
Batched IO (full) vector count 10,054 0.56 0.09
Batched IO (space) vector count 0 0.00 0.00
Batched IO block miss count 3,402,893 188.84 30.28
Batched IO buffer defrag count 15 0.00 0.00
Batched IO double miss count 179 0.01 0.00
Batched IO same unit count 1,346,109 74.70 11.98
Batched IO single block count 81,233 4.51 0.72
Batched IO slow jump count 0 0.00 0.00
Batched IO vector block count 1,985,552 110.18 17.67
Batched IO vector read count 83,581 4.64 0.74
Block Cleanout Optim referenced 1,269 0.07 0.01
CCursor + sql area evicted 655 0.04 0.01
CPU used by this session 106,041 5.88 0.94
CPU used when call started 102,609 5.69 0.91
CR blocks created 38,566 2.14 0.34
Cached Commit SCN referenced 4,927,735 273.45 43.85
Commit SCN cached 2,365 0.13 0.02
DBWR checkpoint buffers written 382,276 21.21 3.40
DBWR checkpoints 39 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 660 0.04 0.01
DBWR tablespace checkpoint buffers written 241 0.01 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 1,273 0.07 0.01
DBWR undo block writes 94,202 5.23 0.84
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 1 0.00 0.00
Effective IO time 155,388,071 8,622.92 1,382.60
HSC Heap Segment Block Changes 1,380,276 76.60 12.28
HSC IDL Compressed Blocks 0 0.00 0.00
Heap Segment Array Inserts 1,756 0.10 0.02
Heap Segment Array Updates 571 0.03 0.01
IMU CR rollbacks 20 0.00 0.00
IMU Flushes 56,776 3.15 0.51
IMU Redo allocation size 43,671,160 2,423.44 388.57
IMU commits 55,503 3.08 0.49
IMU contention 53 0.00 0.00
IMU ktichg flush 1,413 0.08 0.01
IMU pool not allocated 24 0.00 0.00
IMU recursive-transaction flush 14 0.00 0.00
IMU undo allocation size 114,640,048 6,361.70 1,020.04
IMU- failed to get a private strand 24 0.00 0.00
LOB table id lookup cache misses 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
Number of read IOs issued 65,248 3.62 0.58
PX local messages recv'd 914 0.05 0.01
PX local messages sent 914 0.05 0.01
Parallel operations not downgraded 1 0.00 0.00
Requests to/from client 1,449,608 80.44 12.90
RowCR - row contention 7 0.00 0.00
RowCR attempts 16,793 0.93 0.15
RowCR hits 14,995 0.83 0.13
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 1,449,588 80.44 12.90
active txn count during cleanout 105,681 5.86 0.94
background checkpoints completed 24 0.00 0.00
background checkpoints started 23 0.00 0.00
background timeouts 89,947 4.99 0.80
branch node splits 53 0.00 0.00
buffer is not pinned count 24,119,753 1,338.47 214.61
buffer is pinned count 18,623,395 1,033.46 165.71
bytes received via SQL*Net from client 1,539,499,458 85,431.15 13,698.08
bytes sent via SQL*Net to client 3,670,656,598 203,695.06 32,660.57
bytes via SQL*Net vector to client 139,139,398 7,721.24 1,238.03
calls to get snapshot scn: kcmgss 4,866,167 270.04 43.30
calls to kcmgas 926,860 51.43 8.25
calls to kcmgcs 1,876,723 104.14 16.70
cell physical IO interconnect bytes 48,305,489,920 2,680,607.46 429,810.03
change write time 5,143 0.29 0.05
cleanout - number of ktugct calls 191,597 10.63 1.70
cleanouts and rollbacks - consistent read gets 10,013 0.56 0.09
cleanouts only - consistent read gets 55,767 3.09 0.50
cluster key scan block gets 63,385 3.52 0.56
cluster key scans 38,850 2.16 0.35
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 647 0.04 0.01
commit batch/immediate requested 647 0.04 0.01
commit cleanout failures: block lost 103,645 5.75 0.92
commit cleanout failures: buffer being written 198 0.01 0.00
commit cleanout failures: callback failure 1,345 0.07 0.01
commit cleanout failures: cannot pin 2,173 0.12 0.02
commit cleanouts 958,645 53.20 8.53
commit cleanouts successfully completed 851,284 47.24 7.57
commit immediate performed 647 0.04 0.01
commit immediate requested 647 0.04 0.01
commit txn count during cleanout 127,338 7.07 1.13
consistent changes 532,052 29.53 4.73
consistent gets 88,265,544 4,898.10 785.36
consistent gets - examination 9,181,718 509.52 81.70
consistent gets direct 1,922,474 106.68 17.11
consistent gets from cache 86,343,070 4,791.42 768.26
consistent gets from cache (fastpath) 76,200,843 4,228.60 678.02
cursor authentications 895 0.05 0.01
data blocks consistent reads - undo records applied 192,046 10.66 1.71
db block gets 16,642,968 923.57 148.08
db block gets direct 44,207 2.45 0.39
db block gets from cache 16,598,761 921.11 147.69
db block gets from cache (fastpath) 5,154,294 286.03 45.86
deferred (CURRENT) block cleanout applications 608,668 33.78 5.42
dirty buffers inspected 8,146 0.45 0.07
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 220 0.01 0.00
enqueue releases 1,161,317 64.44 10.33
enqueue requests 1,161,524 64.46 10.33
enqueue timeouts 237 0.01 0.00
enqueue waits 429 0.02 0.00
exchange deadlocks 210 0.01 0.00
failed probes on index block reclamation 772 0.04 0.01
file io service time 0 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 2,827,498 156.91 25.16
free buffer requested 3,156,320 175.15 28.08
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 224,812 12.48 2.00
hot buffers moved to head of LRU 504,434 27.99 4.49
immediate (CR) block cleanout applications 65,780 3.65 0.59
immediate (CURRENT) block cleanout applications 54,907 3.05 0.49
index crx upgrade (positioned) 92 0.01 0.00
index crx upgrade (prefetch) 0 0.00 0.00
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 3,593 0.20 0.03
index fast full scans (rowid ranges) 104 0.01 0.00
index fetch by key 4,467,569 247.92 39.75
index scans kdiixs1 848,528 47.09 7.55
leaf node 90-10 splits 1,408 0.08 0.01
leaf node splits 13,229 0.73 0.12
lob reads 51,732 2.87 0.46
lob writes 1,088 0.06 0.01
lob writes unaligned 1,088 0.06 0.01
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logical read bytes from cache 843,297,775,616 46,796,964.66 7,503,450.33
max cf enq hold time 40 0.00 0.00
messages received 260,920 14.48 2.32
messages sent 260,920 14.48 2.32
min active SCN optimization applied on CR 63 0.00 0.00
no buffer to keep pinned count 200 0.01 0.00
no work - consistent read gets 77,042,030 4,275.28 685.50
non-idle wait count 3,524,368 195.58 31.36
parse count (describe) 33 0.00 0.00
parse count (failures) 29 0.00 0.00
parse count (hard) 6,055 0.34 0.05
parse time cpu 1,695 0.09 0.02
physical read IO requests 2,929,465 162.56 26.07
physical read bytes 37,881,798,656 2,102,167.52 337,062.66
physical read total IO requests 2,716,834 150.76 24.17
physical read total bytes 38,699,533,312 2,147,545.91 344,338.66
physical read total multi block requests 15,313 0.85 0.14
physical reads cache 2,795,424 155.13 24.87
physical reads cache prefetch 2,033,147 112.83 18.09
physical reads direct 1,828,819 101.49 16.27
physical reads direct (lob) 78,172 4.34 0.70
physical reads direct temporary tablespace 75,265 4.18 0.67
physical write IO requests 118,297 6.56 1.05
physical write bytes 3,999,793,152 221,959.77 35,589.15
physical write total IO requests 604,479 33.54 5.38
physical write total bytes 9,605,956,608 533,061.54 85,471.37
physical write total multi block requests 20,172 1.12 0.18
physical writes direct 74,467 4.13 0.66
physical writes direct (lob) 15,005 0.83 0.13
physical writes direct temporary tablespace 44,208 2.45 0.39
physical writes from cache 413,789 22.96 3.68
physical writes non checkpoint 362,812 20.13 3.23
pinned buffers inspected 103 0.01 0.00
prefetch clients - default 0 0.00 0.00
prefetched blocks aged out before use 444 0.02 0.00
process last non-idle time 17,938 1.00 0.16
queries parallelized 1 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 2,189,698 121.51 19.48
recursive cpu usage 19,883 1.10 0.18
redo blocks checksummed by FG (exclusive) 1,754,404 97.36 15.61
redo blocks written 4,828,099 267.92 42.96
redo buffer allocation retries 9 0.00 0.00
redo entries 5,484,131 304.33 48.80
redo log space requests 14 0.00 0.00
redo ordering marks 37,496 2.08 0.33
redo size for direct writes 106,108 5.89 0.94
redo subscn max counts 58,341 3.24 0.52
redo synch long waits 440 0.02 0.00
redo synch poll writes 1,918 0.11 0.02
redo synch polls 2,226 0.12 0.02
redo synch time 19,479 1.08 0.17
redo synch time (usec) 194,838,253 10,812.12 1,733.62
redo synch time overhead (usec) 17,792,410,277 987,350.87 158,312.37
redo synch time overhead count (<128 msec) 402 0.02 0.00
redo synch time overhead count (<2 msec) 194,048 10.77 1.73
redo synch time overhead count (<32 msec) 122 0.01 0.00
redo synch time overhead count (<8 msec) 567 0.03 0.01
redo synch time overhead count (>=128 msec) 25 0.00 0.00
redo synch writes 195,221 10.83 1.74
redo wastage 58,861,864 3,266.41 523.74
redo write info find 195,170 10.83 1.74
redo write info find fail 6 0.00 0.00
redo write time 23,816 1.32 0.21
redo writes 219,802 12.20 1.96
rollback changes - undo records applied 17,661 0.98 0.16
rollbacks only - consistent read gets 25,013 1.39 0.22
root node splits 2 0.00 0.00
rows fetched via callback 2,677,627 148.59 23.82
securefile allocation bytes 310,222,848 17,215.14 2,760.28
securefile allocation chunks 22,932 1.27 0.20
securefile bytes non-transformed 230,797,300 12,807.59 2,053.58
securefile direct read bytes 23,814,144 1,321.51 211.89
securefile direct read ops 108 0.01 0.00
securefile direct write bytes 0 0.00 0.00
securefile direct write ops 0 0.00 0.00
securefile number of non-transformed flushes 73,570 4.08 0.65
segment cfs allocations 0 0.00 0.00
segment chunks allocation from disepnser 1,917 0.11 0.02
segment dispenser allocations 1,859 0.10 0.02
segment dispenser load empty 0 0.00 0.00
segment dispenser load tasks 2 0.00 0.00
segment prealloc bytes 335,544,320 18,620.30 2,985.59
segment prealloc ops 658 0.04 0.01
segment prealloc tasks 632 0.04 0.01
segment prealloc time (ms) 195,299 10.84 1.74
segment prealloc ufs2cfs bytes 65,536 3.64 0.58
segment total chunk allocation 0 0.00 0.00
session connect time 0 0.00 0.00
shared hash latch upgrades - no wait 221,031 12.27 1.97
shared hash latch upgrades - wait 34 0.00 0.00
shared io pool buffer get success 58 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 347,437 19.28 3.09
sorts (rows) 4,082,677 226.56 36.33
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 7,711 0.43 0.07
sql area purged 1,471 0.08 0.01
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 62,121 3.45 0.55
switch current to new buffer 95,992 5.33 0.85
table fetch by rowid 16,581,124 920.13 147.53
table fetch continued row 1,660,567 92.15 14.78
table scan blocks gotten 56,255,358 3,121.77 500.55
table scan rows gotten 1,239,265,786 68,770.34 11,026.67
table scans (direct read) 27 0.00 0.00
table scans (long tables) 9 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 434,123 24.09 3.86
total cf enq hold time 21,750 1.21 0.19
total number of cf enq holders 4,323 0.24 0.04
total number of times SMON posted 1,406 0.08 0.01
transaction rollbacks 48 0.00 0.00
transaction tables consistent read rollbacks 8 0.00 0.00
transaction tables consistent reads - undo records applied 831 0.05 0.01
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 640,929,404 35,566.97 5,702.83
user logons cumulative 248 0.01 0.00
user logouts cumulative 268 0.01 0.00
write clones created in background 6 0.00 0.00
write clones created in foreground 1,154 0.06 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
logons current 53 32
opened cursors current 144 78
session cursor cache count 1,368,200 1,378,019
session pga memory 3,299,191,024 3,198,238,464
session pga memory max 12,664,957,840 12,659,556,768
session uga memory 4,508,869,360 4,485,891,160
session uga memory max 174,350,026,576 176,241,198,624
workarea memory allocated 546 10

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 23 4.59

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)
Buffer Cache Reads 21.3G 140.54 1.212M 0M 0.00 0M 685.4K 0.63
Direct Reads 13.4G 3.68 .763M 12M 0.03 .001M 0  
LGWR 469M 1.67 .026M 4.9G 25.73 .277M 30.2K 0.28
DBWR 0M 0.00 0M 3.2G 6.32 .179M 0  
Others 839M 4.87 .047M 458M 1.31 .025M 87.7K 0.22
Direct Writes 14M 0.00 .001M 463M 0.16 .026M 0  
TOTAL: 36G 150.76 2.048M 8.9G 33.54 .508M 803.2K 0.57

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype Name Reads: Data Reqs per sec Data per sec Writes: Data Reqs per sec Data per sec Small Read Large Read
Data File 34.7G 145.12 1.972M 3.4G 6.45 .192M 4.89 26.57
Log File 0M 0.01 0M 4.6G 24.74 .261M 3.60  
Control File 778M 2.76 .043M 632M 2.24 .035M 0.27  
Temp File 589M 2.87 .033M 346M 0.11 .019M 0.38  
Other 0M 0.00 0M 0M 0.00 0M 2.00  
TOTAL: 36G 150.76 2.048M 8.9G 33.54 .508M 4.72 26.57

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)
Buffer Cache Reads 21.3G 140.55 1.212M 0M 0.00 0M 685.4K 0.63
Buffer Cache Reads (Data File) 21.3G 140.55 1.212M 0M 0.00 0M 685.4K 0.63
Direct Reads 13.4G 3.68 .763M 12M 0.03 .001M 0  
Direct Reads (Data File) 13.4G 3.68 .763M 12M 0.03 .001M 0  
LGWR 469M 1.67 .026M 4.9G 25.73 .277M 30.2K 0.28
LGWR (Log File) 0M 0.01 0M 4.6G 24.74 .261M 184 1.91
LGWR (Control File) 469M 1.67 .026M 280M 0.99 .016M 30K 0.27
DBWR 0M 0.00 0M 3.2G 6.32 .179M 0  
DBWR (Data File) 0M 0.00 0M 3.2G 6.32 .179M 0  
Others 839M 4.87 .047M 458M 1.31 .025M 87.7K 0.22
Others (Control File) 309M 1.10 .017M 351M 1.25 .019M 19.8K 0.28
Others (Data File) 530M 3.77 .029M 107M 0.06 .006M 67.9K 0.20
Direct Writes 14M 0.00 .001M 463M 0.16 .026M 0  
Direct Writes (Data File) 14M 0.00 .001M 463M 0.16 .026M 0  
TOTAL: 36G 150.77 2.048M 8.9G 33.54 .508M 803.3K 0.57

Back to IO Stats
Back to Top

Tablespace IO Stats

Tablespace Reads Av Rds/s Av Rd(ms) Av Blks/Rd 1-bk Rds/s Av 1-bk Rd(ms) Writes Writes avg/s Buffer Waits Av Buf Wt(ms)
MIG_DATA 2,111,391 117 0.13 1.84 38,455 116.00 0 2 300 6.07
MIG_LOB 329,754 18 0.54 1.04 2,017 18.26 1 0 4 0.00
MIG_INDEX 148,003 8 1.78 1.57 44,283 8.14 2 2 158 5.82
MIG_TEMP 49,401 3 0.00 1.48 857 1.44 0 0 0 0.00
MIG_CACHE 20,057 1 1.22 3.70 10,273 1.06 1 1 23 3.48
UNDOTBS 93 0 11.72 1.00 17,544 0.01 12 1 928 0.05
SYSAUX 3,357 0 2.55 3.08 2,346 0.16 2 0 0 0.00
TEMP 2,343 0 0.00 1.00 1,150 0.13 0 0 0 0.00
SYSTEM 2,035 0 3.24 1.36 1,198 0.10 3 0 3,484 0.46
DB_ADMIN 24 0 0.00 1.00 25 0.00 0 0 0 0.00
AUDIT_DATA 24 0 0.00 1.00 24 0.00 0 0 0 0.00
HSSEM01_SV_DATA 24 0 0.00 1.00 24 0.00 0 0 0 0.00
HSSEM01_SV_INDEX 24 0 0.00 1.00 24 0.00 0 0 0 0.00
MIG_DATA_L3 24 0 0.00 1.00 24 0.00 0 0 0 0.00
TOOLS 24 0 0.00 1.00 24 0.00 0 0 0 0.00
USERS 24 0 0.00 1.00 24 0.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Rds/s Av Rd(ms) Av Blks/Rd 1-bk Rds/s Av 1-bk Rd(ms) Writes Writes avg/s Buffer Waits Av Buf Wt(ms)
AUDIT_DATA /oradata/UEMO02/datafile1/audit_data01.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
DB_ADMIN /oradata/UEMO02/datafile1/db_admin01.dbf 24 0 0.00 1.00 0 0.00 25 0 0 0.00
HSSEM01_SV_DATA /oradata/UEMO02/datafile1/hssem01_sv_data_01.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
HSSEM01_SV_INDEX /oradata/UEMO02/datafile1/hssem01_sv_idx_01.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_CACHE /oradata/UEMO02/datafile1/mig_cache_01.dbf 20,057 1 1.22 3.70 1 0.99 10,273 1 23 3.48
MIG_DATA /oradata/UEMO02/datafile1/mig_data_01.dbf 447,995 25 0.12 1.78 25 0.11 10,620 1 21 17.14
MIG_DATA /oradata/UEMO02/datafile1/mig_data_02.dbf 410,203 23 0.13 1.85 23 0.12 9,095 1 24 13.75
MIG_DATA /oradata/UEMO02/datafile1/mig_data_03.dbf 401,644 22 0.15 1.88 22 0.14 4,794 0 71 5.92
MIG_DATA /oradata/UEMO02/datafile1/mig_data_04.dbf 440,238 24 0.11 1.84 24 0.10 6,739 0 25 14.80
MIG_DATA /oradata/UEMO02/datafile2/mig_data_05.dbf 411,311 23 0.12 1.86 23 0.11 7,207 0 159 2.14
MIG_DATA_L3 /oradata/UEMO02/datafile1/mig_data_l3_01.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_INDEX /oradata/UEMO02/datafile1/mig_index_01.dbf 73,626 4 1.89 1.58 4 1.70 22,686 1 71 4.79
MIG_INDEX /oradata/UEMO02/datafile1/mig_index_02.dbf 74,377 4 1.67 1.57 4 1.52 21,597 1 87 6.67
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_01.dbf 3,341 0 0.57 1.04 0 0.57 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_02.dbf 68,964 4 0.59 1.02 4 0.55 108 0 4 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_03.dbf 39,404 2 0.51 1.00 2 0.51 170 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_04.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_05.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_06.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_07.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_08.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_09.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_10.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_11.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_12.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_13.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile1/mig_lob_14.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_15.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_16.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_17.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_18.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_19.dbf 28 0 0.00 2.93 0 0.00 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_20.dbf 65,359 4 0.56 1.15 4 0.51 1,237 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_21.dbf 59,726 3 0.52 1.00 3 0.52 46 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_22.dbf 62,810 3 0.50 1.00 3 0.50 24 0 0 0.00
MIG_LOB /oradata/UEMO02/datafile2/mig_lob_23.dbf 29,762 2 0.51 1.00 2 0.51 24 0 0 0.00
MIG_TEMP /oradata/UEMO02/datafile1/mig_temp_01.dbf 49,401 3 0.00 1.48 1 0.01 857 0 0  
SYSAUX /oradata/UEMO02/datafile1/sysaux_01.dbf 3,357 0 2.55 3.08 0 2.41 2,346 0 0 0.00
SYSTEM /oradata/UEMO02/datafile1/system_01.dbf 2,035 0 3.24 1.36 0 3.18 1,198 0 3,484 0.46
TEMP /oradata/UEMO02/datafile1/temp_01.dbf 9 0 0.00 1.00 0 0.00 16 0 0  
TEMP /oradata/UEMO02/datafile2/temp_02.dbf 2,334 0 0.00 1.00 0 0.00 1,134 0 0  
TOOLS /oradata/UEMO02/datafile1/tools01.dbf 24 0 0.00 1.00 0 0.00 24 0 0 0.00
UNDOTBS /oradata/UEMO02/datafile1/undotbs_01.dbf 93 0 11.72 1.00 0 11.72 17,544 1 928 0.05
USERS /oradata/UEMO02/datafile1/users_01.dbf 24 0 0.00 1.00 0 0.00 24 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 221,152 97 102,931,494 2,795,379 413,789 0 0 4,910

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 316,490 0 0 65,545 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 114 15 8145 39982 829440 829440     6865  
E 48 9 257 1108 829440 829440     18739  

Back to Advisory Statistics
Back to Top

MTTR Advisory

Size for Est (s) Dirty Limit Est Cache Writes Est Cache Write Fctr Est Total Writes Est Total Write Fctr Est Total IOs Est Total IO Fctr
12 1,100 39,427 1.19 61,874 1.11 1,567,946 1.00
22 5,168 34,938 1.06 57,385 1.03 1,563,457 1.00
32 9,236 33,973 1.03 56,420 1.02 1,562,492 1.00
42 13,303 33,467 1.01 55,914 1.01 1,561,986 1.00
52 17,476 33,092 1.00 55,539 1.00 1,561,611 1.00

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 176 0.10 22 1.30 588,074 1 196931.00
D 352 0.19 43 1.19 541,051 1 171126.00
D 528 0.29 65 1.15 520,046 1 159599.00
D 704 0.39 87 1.12 505,890 1 151831.00
D 880 0.49 108 1.09 492,425 1 144442.00
D 1,056 0.58 130 1.06 481,909 1 138671.00
D 1,232 0.68 152 1.04 472,587 1 133556.00
D 1,408 0.78 173 1.03 465,116 1 129456.00
D 1,584 0.88 195 1.01 458,975 1 126086.00
D 1,760 0.97 217 1.00 454,044 1 123380.00
D 1,808 1.00 222 1.00 452,886 1 122744.00
D 1,936 1.07 238 0.99 449,799 1 121050.00
D 2,112 1.17 260 0.99 446,462 1 119219.00
D 2,288 1.27 282 0.98 444,243 1 118001.00
D 2,464 1.36 303 0.98 442,470 1 117028.00
D 2,640 1.46 325 0.97 440,949 1 116194.00
D 2,816 1.56 347 0.97 439,549 1 115425.00
D 2,992 1.65 368 0.97 438,297 1 114739.00
D 3,168 1.75 390 0.97 437,035 1 114046.00
D 3,344 1.85 412 0.96 435,690 1 113308.00
D 3,520 1.95 433 0.96 434,282 1 112535.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 6,073 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 1,024 800 243.14 0.52 0.22 100.00 0.00 104,850
E 1,024 855 126.03 0.00 0.00 0.00 0.00 104,850

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 508,045 508,045 0 0
64K 128K 240 240 0 0
128K 256K 224 224 0 0
256K 512K 179 179 0 0
512K 1024K 502 502 0 0
1M 2M 1,362 1,362 0 0
2M 4M 98 98 0 0
4M 8M 42 42 0 0
8M 16M 14 14 0 0
16M 32M 2 2 0 0
64M 128M 2 2 0 0
128M 256M 6 6 0 0
256M 512M 2 2 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
128 0.13 587,762.91 223,878.74 72.00 2,192 566,415,751
256 0.25 587,762.91 125,571.74 82.00 303 497,810,798
512 0.50 587,762.91 53,386.93 92.00 20 447,435,598
768 0.75 587,762.91 48,759.06 92.00 0 444,205,972
1,024 1.00 587,762.91 35,044.71 94.00 0 434,635,218
1,229 1.20 587,762.91 34,804.10 94.00 0 434,467,302
1,434 1.40 587,762.91 34,804.10 94.00 0 434,467,302
1,638 1.60 587,762.91 34,804.10 94.00 0 434,467,302
1,843 1.80 587,762.91 34,804.10 94.00 0 434,467,302
2,048 2.00 587,762.91 34,804.10 94.00 0 434,467,302
3,072 3.00 587,762.91 34,804.10 94.00 0 434,467,302
4,096 4.00 587,762.91 34,804.10 94.00 0 434,467,302
6,144 6.00 587,762.91 34,804.10 94.00 0 434,467,302
8,192 8.00 587,762.91 34,804.10 94.00 0 434,467,302

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)
1,152 0.69 9 4,763 428,069 0.74 163,820 10.03 60,681
1,328 0.79 182 10,123 495,521 0.86 96,368 5.90 66,258
1,504 0.90 358 17,138 545,057 0.95 46,832 2.87 70,865
1,520 0.90 374 18,155 549,252 0.95 42,637 2.61 71,264
1,536 0.91 389 19,549 553,314 0.96 38,575 2.36 71,657
1,552 0.92 405 21,425 557,135 0.97 34,754 2.13 72,036
1,568 0.93 421 22,088 560,564 0.97 31,325 1.92 72,394
1,584 0.94 437 22,795 563,962 0.98 27,927 1.71 72,748
1,600 0.95 453 23,684 567,111 0.99 24,778 1.52 73,077
1,616 0.96 469 24,699 570,041 0.99 21,848 1.34 73,376
1,632 0.97 485 25,504 572,324 0.99 19,565 1.20 73,646
1,648 0.98 501 26,289 574,287 1.00 17,602 1.08 73,874
1,664 0.99 517 27,095 574,956 1.00 16,933 1.04 73,946
1,680 1.00 533 27,728 575,557 1.00 16,332 1.00 74,022
1,696 1.01 549 28,088 575,583 1.00 16,306 1.00 74,028
1,712 1.02 565 28,465 575,595 1.00 16,294 1.00 74,029
1,728 1.03 581 28,842 575,602 1.00 16,287 1.00 74,032
1,744 1.04 597 29,219 575,614 1.00 16,275 1.00 74,034
1,760 1.05 613 29,596 575,619 1.00 16,270 1.00 74,035
1,776 1.06 629 29,973 575,624 1.00 16,265 1.00 74,036
1,792 1.07 645 30,544 575,628 1.00 16,261 1.00 74,037
1,808 1.08 661 31,351 575,641 1.00 16,248 0.99 74,039
1,824 1.09 677 32,120 575,647 1.00 16,242 0.99 74,040
1,856 1.10 709 33,865 575,661 1.00 16,228 0.99 74,043
2,032 1.21 885 44,272 575,744 1.00 16,145 0.99 74,061
2,208 1.31 1,061 56,267 575,789 1.00 16,100 0.99 74,075
2,384 1.42 1,237 66,008 575,867 1.00 16,022 0.98 74,088
2,560 1.52 1,413 75,564 575,903 1.00 15,986 0.98 74,100
2,736 1.63 1,589 86,100 575,935 1.00 15,954 0.98 74,109
2,912 1.73 1,765 95,991 575,974 1.00 15,915 0.97 74,118
3,088 1.84 1,941 104,632 576,009 1.00 15,880 0.97 74,127
3,264 1.94 2,117 113,273 576,033 1.00 15,856 0.97 74,136
3,440 2.05 2,293 121,914 576,069 1.00 15,820 0.97 74,144

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
2,048 0.50 628,058 592,103,152
2,560 0.63 457,305 544,776,566
3,072 0.75 428,517 495,819,590
3,584 0.88 412,810 468,329,409
4,096 1.00 403,766 452,885,997
4,608 1.13 399,688 445,503,955
5,120 1.25 397,386 441,292,115
5,632 1.38 395,166 437,261,430
6,144 1.50 394,964 437,261,430
6,656 1.63 394,843 437,261,430
7,168 1.75 394,762 437,261,430
7,680 1.88 394,681 437,261,430
8,192 2.00 394,681 437,261,430

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)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.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 3,915 4 1
file header block 23 0 3
segment header 20 0 3
undo header 514 0 0
undo block 414 0 0
1st level bmb 6 0 3
free list 4 0 0
2nd level bmb 2 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)
CF-Controlfile Transaction 14,687 14,687 0 4 0 50.00
TX-Transaction (row lock contention) 254 254 0 254 0 0.59
TX-Transaction (index contention) 1,558 1,558 0 40 0 3.00
KO-Multiple Object Checkpoint (fast object checkpoint) 160 160 0 16 0 5.63
TX-Transaction (allocate ITL entry) 127 127 0 106 0 0.38
PS-PX Process Reservation 40 40 0 2 0 5.00
TM-DML 501,359 501,359 0 6 0 0.00
FB-Format Block 5,806 5,806 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 92.69 503,500 2,775 23 10000.2/24473.6 0/0 0/0/0/1/14976/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
05-Oct 16:57 0 21 0 0 10,441 0/0 0/0/0/0/0/0
05-Oct 16:47 2 48 1,732 1 10,441 0/0 0/0/0/0/0/0
05-Oct 16:37 54 450 1,131 23 10,436 0/0 0/0/0/0/0/0
05-Oct 16:27 5 26 992 1 10,428 0/0 0/0/0/0/0/0
05-Oct 16:17 5,903 38,309 1,592 3 10,024 0/0 0/0/0/1/14976/0
05-Oct 16:07 11,609 73,750 991 5 10,000 0/0 0/0/0/0/0/0
05-Oct 15:57 13,151 87,823 1,591 3 10,658 0/0 0/0/0/0/0/0
05-Oct 15:47 6,425 41,309 1,589 3 12,296 0/0 0/0/0/0/0/0
05-Oct 15:37 3,811 25,087 1,588 6 13,221 0/0 0/0/0/0/0/0
05-Oct 15:27 4,492 29,454 988 3 13,530 0/0 0/0/0/0/0/0
05-Oct 15:17 6,635 43,085 986 3 13,774 0/0 0/0/0/0/0/0
05-Oct 15:07 7,948 48,763 385 5 14,438 0/0 0/0/0/0/0/0
05-Oct 14:57 69 56 0 2 16,799 0/0 0/0/0/0/0/0
05-Oct 14:47 50 124 2,435 2 16,858 0/0 0/0/0/0/0/0
05-Oct 14:37 63 309 1,834 9 16,864 0/0 0/0/0/0/0/0
05-Oct 14:27 10 46 1,233 1 16,877 0/0 0/0/0/0/0/0
05-Oct 14:17 9 13 632 1 16,879 0/0 0/0/0/0/0/0
05-Oct 14:07 193 634 0 3 16,842 0/0 0/0/0/0/0/0
05-Oct 13:57 10 70 0 1 16,888 0/0 0/0/0/0/0/0
05-Oct 13:47 10 14 0 1 16,888 0/0 0/0/0/0/0/0
05-Oct 13:37 54 308 0 5 16,882 0/0 0/0/0/0/0/0
05-Oct 13:27 9 12 2,775 1 16,894 0/0 0/0/0/0/0/0
05-Oct 13:17 14 147 2,174 1 16,895 0/0 0/0/0/0/0/0
05-Oct 13:07 6,934 9,235 1,573 3 15,737 0/0 0/0/0/0/0/0
05-Oct 12:57 3,217 20,246 972 5 17,573 0/0 0/0/0/0/0/0
05-Oct 12:47 11,003 61,641 371 5 16,728 0/0 0/0/0/0/0/0
05-Oct 12:37 3,124 5,139 137 12 20,880 0/0 0/0/0/0/0/0
05-Oct 12:27 5,646 11,919 757 5 21,046 0/0 0/0/0/0/0/0
05-Oct 12:17 689 2,963 1,573 10 24,474 0/0 0/0/0/0/0/0
05-Oct 12:07 1,548 2,499 971 9 24,406 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 5 0.00   0 0  
ASM db client latch 12,056 0.00   0 0  
ASM map operation hash table 5 0.00   0 0  
ASM network state latch 286 0.00   0 0  
AWR Alerted Metric Element list 136,948 0.00   0 0  
Change Notification Hash table latch 6,115 0.00   0 0  
Consistent RBA 219,839 0.00 0.00 0 0  
DML lock allocation 1,002,840 0.00 0.00 0 0  
Event Group Locks 749 0.00   0 0  
FIB s.o chain latch 2 0.00   0 0  
FOB s.o list latch 4,948 0.00   0 0  
File State Object Pool Parent Latch 27 0.00   0 0  
I/O Staticstics latch 5 0.00   0 0  
IPC stats buffer allocation latch 5 0.00   0 0  
In memory undo latch 553,478 0.00 0.67 0 113,827 0.00
JS Sh mem access 5 0.00   0 0  
JS queue access latch 5 0.00   0 0  
JS slv state obj latch 5 0.00   0 0  
KFC FX Hash Latch 5 0.00   0 0  
KFC Hash Latch 5 0.00   0 0  
KFCL LE Freelist 5 0.00   0 0  
KGNFS-NFS:SHM structure 5 0.00   0 0  
KGNFS-NFS:SVR LIST 5 0.00   0 0  
KJC message pool free list 5 0.00   0 0  
KJCT flow control latch 5 0.00   0 0  
KMG MMAN ready and startup request latch 6,005 0.00   0 0  
KTF sga latch 102 0.00   0 5,525 0.00
KWQMN job cache list latch 5 0.00   0 0  
KWQP Prop Status 10 0.00   0 0  
KWQS pqueue ctx latch 10 0.00   0 0  
Locator state objects pool parent latch 5 0.00   0 0  
Lsod array latch 5 0.00   0 0  
MQL Tracking Latch 0     0 360 0.00
Memory Management Latch 5 0.00   0 6,005 0.00
Memory Queue 5 0.00   0 0  
Memory Queue Message Subscriber #1 5 0.00   0 0  
Memory Queue Message Subscriber #2 5 0.00   0 0  
Memory Queue Message Subscriber #3 5 0.00   0 0  
Memory Queue Message Subscriber #4 5 0.00   0 0  
Memory Queue Subscriber 5 0.00   0 0  
MinActiveScn Latch 200 0.00   0 0  
Mutex 5 0.00   0 0  
Mutex Stats 5 0.00   0 0  
OS process 2,140 0.00   0 0  
OS process allocation 37,097 0.00 0.00 0 0  
OS process: request allocation 757 0.00   0 0  
PL/SQL warning settings 13,944 0.03 0.00 0 0  
PX hash array latch 5 0.00   0 0  
QMT 5 0.00   0 0  
Real-time plan statistics latch 83,144 0.00   0 0  
Result Cache: RC Latch 115,354 0.00   0 0  
SGA IO buffer pool latch 12,643 0.02 0.00 0 12,900 0.01
SGA blob parent 5 0.00   0 0  
SGA bucket locks 5 0.00   0 0  
SGA heap locks 5 0.00   0 0  
SGA pool locks 5 0.00   0 0  
SQL memory manager latch 10 30.00 1.00 0 5,995 0.00
SQL memory manager workarea list latch 1,463,977 0.00 0.00 0 0  
Shared B-Tree 30 0.00   0 0  
Streams Generic 5 0.00   0 0  
Testing 5 0.00   0 0  
Token Manager 5 0.00   0 0  
Undo Hint Latch 0     0 1 0.00
WCR: sync 5 0.00   0 0  
Write State Object Pool Parent Latch 5 0.00   0 0  
X$KSFQP 5 0.00   0 0  
XDB NFS Security Latch 5 0.00   0 0  
XDB unused session pool 5 0.00   0 0  
XDB used session pool 5 0.00   0 0  
active checkpoint queue latch 50,454 0.07 0.00 0 0  
active service list 9,999 0.06 0.00 0 10,632 0.00
begin backup scn array 1,543 0.00   0 0  
buffer pool 5 0.00   0 0  
business card 5 0.00   0 0  
cache buffer handles 107,962 0.00 0.00 0 0  
cache buffers chains 222,527,407 0.01 0.01 0 5,503,289 0.00
cache buffers lru chain 643,914 0.01 0.27 0 4,154,745 0.01
cache table scan latch 0     0 10,996 0.00
call allocation 9,930 0.24 0.38 0 0  
cas latch 5 0.00   0 0  
change notification client cache latch 5 0.00   0 0  
channel handle pool latch 781 0.00   0 0  
channel operations parent latch 88,750 0.00   0 0  
checkpoint queue latch 3,650,682 0.00 0.01 0 408,648 0.00
client/application info 1,907 0.00   0 0  
compile environment latch 376 0.00   0 0  
corrupted undo seg latch 53,031 0.00   0 0  
cp cmon/server latch 5 0.00   0 0  
cp pool latch 5 0.00   0 0  
cp server hash latch 5 0.00   0 0  
cp sga latch 286 0.00   0 0  
cvmap freelist lock 5 0.00   0 0  
deferred cleanup latch 286 0.00   0 0  
dml lock allocation 746 0.00   0 0  
done queue latch 5 0.00   0 0  
dummy allocation 778 1.29 0.10 0 0  
eighth spare latch - X parent 5 0.00   0 0  
eleventh spare latch - children 5 0.00   0 0  
enqueue freelist latch 5 0.00   0 314,068 0.00
enqueue hash chains 2,323,603 0.01 0.00 0 0  
enqueues 1 0.00   0 0  
error message lists 17 17.65 0.00 0 0  
fast space usage latch 2,118 0.00   0 0  
fifteenth spare latch - children 5 0.00   0 0  
file cache latch 2,706 0.00   0 0  
first Audit Vault latch 246 0.00   0 0  
flashback copy 5 0.00   0 0  
fourteenth spare latch - children 5 0.00   0 0  
fourth Audit Vault latch 5 0.00   0 0  
gc element 5 0.00   0 0  
gcs commit scn state 5 0.00   0 0  
gcs partitioned table hash 5 0.00   0 0  
gcs pcm hashed value bucket hash 5 0.00   0 0  
gcs resource freelist 5 0.00   0 0  
gcs resource hash 5 0.00   0 0  
gcs resource scan list 5 0.00   0 0  
gcs resource validate list 5 0.00   0 0  
gcs shadows freelist 5 0.00   0 0  
ges domain table 5 0.00   0 0  
ges enqueue table freelist 5 0.00   0 0  
ges group table 5 0.00   0 0  
ges process hash list 5 0.00   0 0  
ges process parent latch 5 0.00   0 0  
ges resource hash list 5 0.00   0 0  
ges resource scan list 5 0.00   0 0  
ges resource table freelist 5 0.00   0 0  
ges value block free list 5 0.00   0 0  
global KZLD latch for mem in SGA 246 0.00   0 0  
global ctx hash table latch 496 0.00   0 0  
global tx hash mapping 5 0.00   0 0  
granule operation 5 0.00   0 0  
hash table column usage latch 1,188 0.00   0 1,051,609 0.00
hash table modification latch 598 0.17 0.00 0 0  
heartbeat check 5 0.00   0 0  
internal temp table object number allocation latch 25 0.00   0 0  
interrupt manipulation 82 1.22 0.00 0 0  
intra txn parallel recovery 5 0.00   0 0  
io pool granule list 119 0.00   0 0  
io pool granule metadata list 290 0.00   0 0  
job workq parent latch 5 0.00   0 0  
k2q lock allocation 5 0.00   0 0  
kcbtsemkid latch 23 0.00   0 0  
kdlx hb parent latch 5 0.00   0 0  
kgb parent 5 0.00   0 0  
kgnfs mount latch 5 0.00   0 0  
kokc descriptor allocation latch 48 0.00   0 0  
ksfv messages 5 0.00   0 0  
ksim group membership cache 5 0.00   0 0  
kss move lock 229 0.00   0 0  
ksuosstats global area 1,817 0.11 1.00 0 0  
ksv allocation latch 735 0.00   0 0  
ksv class latch 455 0.00   0 0  
ksv msg queue latch 5 0.00   0 0  
ksz_so allocation latch 757 0.13 0.00 0 0  
ktm global data 5,752 0.00   0 0  
kwqbsn:qsga 10 0.00   0 0  
lgwr LWN SCN 226,605 0.02 0.00 0 0  
list of block allocation 30,746 0.00   0 0  
loader state object freelist 107,972 0.02 0.00 0 0  
lob segment dispenser latch 14,742 0.00   0 0  
lob segment hash table latch 7,544 0.00   0 0  
lob segment query latch 5 0.00   0 0  
lock DBA buffer during media recovery 5 0.00   0 0  
logical standby cache 5 0.00   0 0  
logminer context allocation 10 0.00   0 0  
logminer local 5 0.00   0 0  
logminer work area 5 0.00   0 0  
longop free list parent 50 0.00   0 45 0.00
mapped buffers lru chain 5 0.00   0 0  
message pool operations parent latch 83 0.00   0 0  
messages 913,890 0.01 0.00 0 0  
mostly latch-free SCN 229,251 0.61 0.00 0 0  
msg queue latch 5 0.00   0 0  
multiblock read objects 184,384 0.00   0 0  
name-service namespace bucket 5 0.00   0 0  
ncodef allocation latch 286 0.00   0 0  
nineth spare latch - X parent 5 0.00   0 0  
object queue header heap 447,891 0.00 0.33 0 55,885 0.00
object queue header operation 8,120,819 0.01 0.30 0 0  
object stats modification 2,204 0.00   0 0  
parallel query alloc buffer 2,577 1.55 0.00 0 0  
parallel query stats 16 37.50 0.17 0 0  
parameter list 2,559 0.31 0.00 0 0  
parameter table management 5,337 0.06 0.00 0 0  
peshm 5 0.00   0 0  
pesom_free_list 5 0.00   0 0  
pesom_hash_node 5 0.00   0 0  
post/wait queue 304,778 0.05 0.01 0 211,428 0.10
process allocation 878 0.34 1.00 0 368 0.00
process group creation 757 0.13 0.00 0 0  
process queue 135 2.96 0.00 0 0  
process queue reference 21,324 0.01 0.00 0 1,250 0.08
query server freelists 120 0.00   0 0  
query server process 16 0.00   0 8 0.00
queued dump request 60 0.00   0 0  
queuing load statistics 5 0.00   0 0  
recovery domain hash list 5 0.00   0 0  
redo allocation 913,284 0.09 0.01 0 5,483,449 0.04
redo copy 5 0.00   0 5,484,313 0.04
redo writing 726,520 0.00 0.00 0 0  
resmgr group change latch 258 0.00   0 0  
resmgr:active threads 778 0.00   0 0  
resmgr:actses change group 373 0.00   0 0  
resmgr:actses change state 5 0.00   0 0  
resmgr:free threads list 773 1.42 0.00 0 0  
resmgr:plan CPU method 5 0.00   0 0  
resmgr:resource group CPU method 5 0.00   0 0  
resmgr:schema config 405 0.00   0 0  
resmgr:session queuing 5 0.00   0 0  
rm cas latch 5 0.00   0 0  
row cache objects 10,881,476 0.12 0.00 0 4,191 0.31
rules engine aggregate statistics 1 0.00   0 0  
rules engine rule set statistics 502 0.00   0 0  
second Audit Vault latch 5 0.00   0 0  
sequence cache 753,444 0.01 0.00 0 0  
session allocation 487,756 0.00   0 487,181 0.00
session idle bit 4,615,080 0.00 0.00 0 0  
session queue latch 5 0.00   0 0  
session state list latch 1,007 0.99 0.20 0 0  
session switching 680 0.00   0 0  
session timer 6,003 0.00   0 0  
seventh spare latch - X parent 5 0.00   0 0  
shared pool 518,038 0.28 0.14 0 1,600 0.00
shared pool sim alloc 6 0.00   0 0  
shared pool simulator 31,412 0.01 0.00 0 0  
sim partition latch 10 0.00   0 2,807 0.00
simulator hash latch 6,628,866 0.00 0.00 0 0  
simulator lru latch 232,405 0.01 0.00 0 6,136,541 0.09
sixth spare latch - X parent 5 0.00   0 0  
sort extent pool 10,879 0.00   0 0  
space background state object latch 75 0.00   0 0  
space background task latch 54,538 4.47 0.09 0 12,760 0.00
state object free list 60 0.00   0 0  
statistics aggregation 1,680 0.00   0 0  
tablespace key chain 5 0.00   0 0  
temp lob duration state obj allocation 119 0.00   0 0  
temporary table state object allocation 101 0.00   0 0  
tenth spare latch - X parent 5 0.00   0 0  
test excl. parent l0 5 0.00   0 0  
test excl. parent2 l0 5 0.00   0 0  
thirteenth spare latch - children 5 0.00   0 0  
threshold alerts latch 1,263 0.00   0 0  
transaction allocation 11,111 0.00   0 0  
transaction branch allocation 6,003 0.00   0 0  
twelfth spare latch - children 5 0.00   0 0  
twenty-fifth spare latch - S par 5 0.00   0 0  
twenty-first spare latch - S par 5 0.00   0 0  
twenty-fourth spare latch - S par 5 0.00   0 0  
twenty-second spare latch - S par 5 0.00   0 0  
twenty-third spare latch - S par 5 0.00   0 0  
undo global data 2,163,330 0.00 0.00 0 0  
virtual circuit buffers 5 0.00   0 0  
virtual circuit holder 5 0.00   0 0  
virtual circuit queues 5 0.00   0 0  
write info latch 0     0 219,825 0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets
cache buffers chains 222,527,407 17,531 189 17,348
row cache objects 10,881,476 13,509 50 13,462
space background task latch 54,538 2,440 211 2,229
shared pool 518,038 1,447 204 1,257
mostly latch-free SCN 229,251 1,404 1 1,403
redo allocation 913,284 799 8 791
object queue header operation 8,120,819 669 198 472
enqueue hash chains 2,323,603 338 1 337
post/wait queue 304,778 142 2 140
checkpoint queue latch 3,650,682 118 1 117
cache buffers lru chain 643,914 71 19 52
call allocation 9,930 24 9 18
In memory undo latch 553,478 21 14 7
dummy allocation 778 10 1 9
session state list latch 1,007 10 2 8
parallel query stats 16 6 1 5
SQL memory manager latch 10 3 3 0
object queue header heap 447,891 3 1 2
process allocation 878 3 3 0
ksuosstats global area 1,817 2 2 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 10 5
In memory undo latch kticmt: child 0 4 0
In memory undo latch ktichg: child 0 1 4
PC and Classifier lists for WLM No latch 0 7 0
SQL memory manager latch qesmmIQueryRefreshBound 0 3 3
cache buffers chains kcbchg1: mod cr pin 0 79 36
cache buffers chains kcbgtcr: fast path (cr pin) 0 35 29
cache buffers chains kcbgcur_2 0 27 21
cache buffers chains kcbgtcr: fast path 0 20 22
cache buffers chains kcbget: pin buffer 0 16 16
cache buffers chains kcbgtcr_2 0 13 11
cache buffers chains kcbget: fast exchange 0 11 5
cache buffers chains kcbzwb 0 7 6
cache buffers chains kcbgcur_4 0 6 3
cache buffers chains kcbchg1: mod cur pin 0 3 8
cache buffers chains kcbso1: set no access 0 2 0
cache buffers chains kcbchg1: clear MS bit 0 1 16
cache buffers chains kcbgcur: fast path (shr) 0 1 5
cache buffers chains kcbgtcr: kslbegin shared 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers lru chain kcbzgws 0 19 0
call allocation ksuxds 0 9 8
checkpoint queue latch kcbkubc_4 0 1 0
dummy allocation ktcscnfy 0 1 1
enqueue hash chains ksqgtl3 0 1 0
ksuosstats global area ksugetosstat 0 2 2
lgwr LWN SCN kcs023 0 1 0
object queue header heap kcbo_unlink_q 0 1 0
object queue header operation kcbo_link_q 0 200 17
object queue header operation kcbo_switch_mq_bg 0 3 55
object queue header operation kcbo_switch_cq 0 2 82
object queue header operation kcbo_switch_q_bg 0 1 33
parallel query stats kxfprst: KSLBEGIN:1 0 1 1
post/wait queue ksliwat:add:nowait 0 1 0
post/wait queue ksliwat:remove 0 1 2
process allocation ksucrp:1 0 3 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 8 0
row cache objects kqrpre: find obj 0 21 30
row cache objects kqreqd: reget 0 15 1
row cache objects kqreqd 0 6 9
session state list latch kpseqd 0 2 0
shared pool kghalo 0 181 93
shared pool kghupr1 0 12 85
shared pool kghfrunp: clatch: nowait 0 8 0
shared pool kghalp 0 7 21
shared pool kghfrunp: alloc: wait 0 3 0
shared pool kghfrh 0 1 0
space background task latch ktsj_grab_task 0 202 210
space background task latch ktsjCreateTask 0 1 0
space background task latch ktsj_detach_task 0 1 1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex Type Location Sleeps Wait Time (ms)
Library Cache kgllkdl1 85 97 0
Library Cache kgllkc1 57 96 0
Library Cache kglhdgn2 106 72 0
Library Cache kglhdgn1 62 46 0
Library Cache kglpnal1 90 46 0
Library Cache kglhdgh1 64 33 0
Library Cache kglpin1 4 29 0
Library Cache kglpndl1 95 25 0
Library Cache kglget2 2 17 0
Cursor Pin kksLockDelete [KKSCHLPIN6] 14 0
Library Cache kglget1 1 10 0
Cursor Pin kkslce [KKSCHLPIN2] 10 0
Cursor Pin kksfbc [KKSCHLFSP2] 8 0
Library Cache kglobpn1 71 4 0
Library Cache kgldtin1 42 2 0
Library Cache kglrfcl1 79 2 0
Cursor Pin kksfbc [KKSCHLPIN1] 2 0
Library Cache kglini1 32 1 0
Cursor Parent kkscsAddChildNode [KKSPRTLOC34] 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
HSSEM01_UCITS4 MIG_DATA TASSET   TABLE 43,847,056 41.80
HSSEM01DM MIG_DATA TASSET   TABLE 8,353,872 7.96
HSSEM01_UCITS4 MIG_TEMP PK_IDMTMPPENDING   INDEX 7,072,304 6.74
HSSEM01DM MIG_DATA TDATAOVERRIDE   TABLE 4,866,016 4.64
HSSEM01 MIG_DATA VIOLATION   TABLE 3,489,888 3.33

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
HSSEM01 MIG_DATA VIOLATION   TABLE 2,157,518 46.66
HSSEM01DM MIG_DATA AASSET   TABLE 1,191,481 25.77
HSSEM01DM MIG_DATA TIMPORTCLASSRUN   TABLE 346,128 7.49
HSSEM01 MIG_LOB SYS_LOB0000292548C00036$$   LOB 325,465 7.04
HSSEM01 MIG_INDEX IXVIOLATION_TEJNT   INDEX 81,220 1.76

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
HSSEM01 MIG_DATA VIOLATION   TABLE 2,126,256 72.58
HSSEM01 MIG_LOB SYS_LOB0000292548C00036$$   LOB 325,465 11.11
HSSEM01 MIG_INDEX IXVIOLATION_TEJNT   INDEX 81,220 2.77
HSSEM01 MIG_INDEX IXVIOLATION_CHKNT   INDEX 79,203 2.70
HSSEM01 MIG_INDEX IX_VIOLATION_WEB   INDEX 29,428 1.00

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type UnOptimized Reads %Total
HSSEM01 MIG_DATA VIOLATION   TABLE 2,126,256 72.58
HSSEM01 MIG_LOB SYS_LOB0000292548C00036$$   LOB 325,465 11.11
HSSEM01 MIG_INDEX IXVIOLATION_TEJNT   INDEX 81,220 2.77
HSSEM01 MIG_INDEX IXVIOLATION_CHKNT   INDEX 79,203 2.70
HSSEM01 MIG_INDEX IX_VIOLATION_WEB   INDEX 29,428 1.00

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Reads %Total
HSSEM01DM MIG_DATA AASSET   TABLE 1,191,076 65.13
HSSEM01DM MIG_DATA TIMPORTCLASSRUN   TABLE 346,124 18.93
HSSEM01L3 MIG_CACHE ASSETS_DATA_MANAGER_1625   TABLE 49,276 2.69
HSSEM01DM MIG_DATA TASSET   TABLE 35,115 1.92
HSSEM01 MIG_DATA VIOLATION   TABLE 31,531 1.72

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Writes %Total
HSSEM01 MIG_DATA VIOLATION   TABLE 133,825 27.41
HSSEM01 MIG_LOB SYS_LOB0000292548C00036$$   LOB 35,457 7.26
HSSEM01L3 MIG_CACHE ASSETS_DATA_MANAGER_1625   TABLE 24,553 5.03
HSSEM01DM MIG_INDEX PK_TIMPORTMAPPING   INDEX 21,038 4.31
HSSEM01_UCITS4 MIG_INDEX II0_THOLDINGS   INDEX 9,686 1.98

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
HSSEM01 MIG_DATA VIOLATION   TABLE 24,715 20.89
HSSEM01DM MIG_INDEX PK_TIMPORTMAPPING   INDEX 6,246 5.28
HSSEM01 MIG_INDEX IXVIOLATION_RUENTRUVON   INDEX 5,783 4.89
HSSEM01 MIG_INDEX IXVIOLATION_RUENT   INDEX 5,452 4.61
HSSEM01L3 MIG_CACHE ASSETS_DATA_MANAGER_1625   TABLE 5,160 4.36

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Owner Tablespace Name Object Name Subobject Name Obj. Type Direct Writes %Total
HSSEM01L3 MIG_CACHE ASSETS_DATA_MANAGER_1625   TABLE 12,314 16.54
HSSEM01L3 MIG_CACHE HOLDINGS_ICON_1625   TABLE 3,525 4.73
HSSEM01L3 MIG_CACHE ASSETMASTER_REUTERS_1621   TABLE 2,673 3.59
HSSEM01L3 MIG_CACHE ASSETMASTER_REUTERS_1622   TABLE 2,673 3.59
HSSEM01L3 MIG_CACHE ASSETMASTER_REUTERS_1623   TABLE 2,673 3.59

Back to Segment Statistics
Back to Top

Segments by Table Scans

Owner Tablespace Name Object Name Subobject Name Obj. Type Table Scans %Total
HSSEM01DM MIG_INDEX II11_TGLOBAL   INDEX 2,669 74.10
HSSEM01_UCITS4 MIG_INDEX II0_TASSET   INDEX 68 1.89
HSSEM01DM MIG_INDEX PK_TASSET   INDEX 26 0.72
HSSEM01_UCITS4 MIG_INDEX PK_TASSET   INDEX 11 0.31
HSSEM01_UCITS4 MIG_INDEX II0_THOLDINGS   INDEX 9 0.25

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
HSSEM01 MIG_DATA VIOLATION   TABLE 488,336 9.91
SYS SYSTEM SEQ$   TABLE 368,448 7.47
HSSEM01L3 MIG_CACHE ASSETS_DATA_MANAGER_1625   TABLE 208,672 4.23
HSSEM01 MIG_INDEX IX_VIOLATION_WEB   INDEX 206,768 4.19
HSSEM01 MIG_INDEX IX_VIOLATION_RB   INDEX 203,616 4.13

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
HSSEM01 MIG_INDEX IX_VIOLATION_RB   INDEX 238 13.13
HSSEM01 MIG_INDEX IXVIOLATION_MLTKEY   INDEX 218 12.03
HSSEM01 MIG_INDEX IX_VIOLATION_WEB   INDEX 180 9.93
SYS SYSTEM I_FILE#_BLOCK#   INDEX 153 8.44
HSSEM01 MIG_INDEX IXVIOLATION_RUENTRUVON   INDEX 121 6.68

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
SYS SYSTEM CCOL$   TABLE 51 40.16
SYS SYSTEM SEG$   TABLE 47 37.01
SYS SYSTEM ICOL$   TABLE 5 3.94
HSSEM01 MIG_INDEX IX_VIOLATION_RB   INDEX 4 3.15
HSSEM01 MIG_INDEX IXVIOLATION_MLTKEY   INDEX 3 2.36

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 SEQ$   TABLE 1,478 44.73
SYS SYSTEM I_FILE#_BLOCK#   INDEX 461 13.95
SYS SYSTEM I_COBJ#   INDEX 323 9.78
SYS SYSTEM I_COL3   INDEX 181 5.48
SYS SYSTEM SEG$   TABLE 158 4.78

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 331 0.00 0   10 1
dc_constraints 460 50.00 0   460 171
dc_global_oids 8,632 0.13 0   0 103
dc_histogram_data 98,393 0.77 0   0 3,886
dc_histogram_defs 398,248 0.99 0   0 15,377
dc_object_grants 1,890 0.11 0   0 47
dc_objects 649,051 0.20 0   621 5,190
dc_profiles 982 0.00 0   0 2
dc_rollback_segments 11,318 0.00 0   0 35
dc_segments 53,717 1.41 0   821 3,631
dc_sequences 369,030 0.00 0   369,030 16
dc_tablespace_quotas 256 1.95 0   0 11
dc_tablespaces 653,111 0.00 0   0 16
dc_users 944,037 0.02 0   0 304
global database name 12,333 0.00 0   0 1
outstanding_alerts 399 0.00 0   1 13


Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
ACCOUNT_STATUS 738 1.08 0   0 0
APP CONTEXT 248 0.00 248 0.00 0 0
BODY 2,060 0.34 52,293 0.02 5 0
CLUSTER 159 1.89 159 1.89 0 0
DBLINK 752 0.00 0   0 0
EDITION 323 0.00 569 0.00 0 0
INDEX 431 26.68 431 55.92 11 0
OBJECT ID 230 100.00 0   0 0
QUEUE 2 0.00 2 0.00 0 0
RULESET 1 0.00 1 0.00 0 0
SCHEMA 765 0.26 0   0 0
SQL AREA 25,622 16.10 1,866,406 0.78 1,841 2,161
SQL AREA BUILD 4,164 92.15 0   0 0
SQL AREA STATS 5,447 69.71 5,447 69.71 0 0
TABLE/PROCEDURE 26,623 1.05 863,664 0.24 867 0
TRIGGER 6,716 0.49 206,498 0.03 30 0


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 1,808.00 1,808.00 1,760.00 3,200.00 0 SHR/DEF
KEEP buffer cache 0.00 0.00 0.00 0.00 0 STA/
PGA Target 1,024.00 1,024.00 1,024.00 1,024.00 0 STA/
RECYCLE buffer cache 0.00 0.00 0.00 0.00 0 STA/
SGA Target 4,096.00 4,096.00 4,096.00 4,096.00 0 STA/
Shared IO Pool 512.00 512.00 0.00 512.00 0 GRO/IMM
java pool 16.00 16.00 16.00 64.00 0 SHR/DEF
large pool 32.00 32.00 32.00 32.00 0 STA/
shared pool 1,680.00 1,680.00 736.00 1,728.00 0 GRO/DEF
streams pool 16.00 16.00 16.00 32.00 0 SHR/DEF

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 172.87   3.26 3.04 17 17 53 53
Freeable 46.75 0.00 1.20 1.70 8   39 39
PL/SQL 20.45 16.50 0.39 0.76 2 3 53 53
SQL 3.07 1.36 0.07 0.11 1 13 41 38
E Other 91.44   2.86 3.05 15 15 32 32
Freeable 32.81 0.00 1.93 2.41 8   17 17
PL/SQL 1.23 0.94 0.04 0.04 0 0 32 32
SQL 0.55 0.14 0.03 0.03 0 105 20 17

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 2,432,696,320  
Fixed Size 2,261,368  
Redo Buffers 9,707,520  
Variable Size 2,365,591,176  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 16.00 16.00 0.00
large PX msg pool 7.81 7.81 0.00
large free memory 24.19 24.19 0.00
shared ASH buffers 32.00 32.00 0.00
shared Checkpoint queue 31.26 31.26 0.00
shared KGH: NO ACCESS 133.83 133.83 0.00
shared KGLH0 306.04 247.03 -19.28
shared KGLHD 45.93 35.10 -23.59
shared KTSL subheap 21.07 21.07 0.00
shared SQLA 420.79 426.49 1.35
shared db_block_hash_buckets 22.25 22.25 0.00
shared free memory 469.33 556.78 18.63
shared kglsim object batch 25.08 25.08 0.01
shared object queue 29.96 29.96 0.00
streams KGH: NO ACCESS 15.99 15.99 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 1,808.00 1,808.00 0.00
  fixed_sga 2.16 2.16 0.00
  log_buffer 9.26 9.26 0.00
  shared_io_pool 512.00 512.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

Rule Evals No-SQL Eval% SQL Execs CPU(s) Ela(s) Eval /Sec SQL per Eval Ela(s) per Eval CPU(s) per Eval Reloads
SYS.ALERT_QUE_R 1 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different)
aq_tm_processes 0   
archive_lag_target 1800   
audit_file_dest /u01/in/UEMO02/oracle/admin/UEMO02/adump   
audit_sys_operations TRUE   
audit_trail DB_EXTENDED   
cluster_database FALSE   
compatible 11.2.0.4   
control_file_record_keep_time 14   
control_files /oradata/UEMO02/redo1/ct/control01.ctl, /oradata/UEMO02/redo2/ct/control02.ctl   
cursor_sharing EXACT   
db_block_size 8192   
db_domain uk.hibm.hsbc   
db_file_multiblock_read_count 128   
db_files 2000   
db_name UEMO02   
db_recovery_file_dest /oradata/UEMO02/fra   
db_recovery_file_dest_size 214748364800   
db_securefile ALWAYS   
fast_start_mttr_target 900   
global_names TRUE   
java_jit_enabled TRUE   
job_queue_processes 1000   
local_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER_UEMO02)))   
log_archive_dest_1 location=/oradata/UEMO02/archive1   
log_archive_dest_state_1 enable   
log_archive_dest_state_10 defer   
log_archive_dest_state_2 defer   
log_archive_dest_state_3 defer   
log_archive_dest_state_4 defer   
log_archive_dest_state_5 defer   
log_archive_dest_state_6 defer   
log_archive_dest_state_7 defer   
log_archive_dest_state_8 defer   
log_archive_dest_state_9 defer   
log_archive_format UEMO02_%t_%s_%r.arc   
log_buffer 9240576   
log_checkpoint_timeout 0   
max_dump_file_size 5M   
memory_max_target 5368709120   
open_cursors 2000   
optimizer_mode FIRST_ROWS_100   
parallel_max_servers 320   
pga_aggregate_target 1073741824   
plsql_warnings DISABLE:ALL   
processes 500   
recyclebin OFF   
remote_listener      
remote_login_passwordfile EXCLUSIVE   
resource_limit TRUE   
result_cache_max_size 21495808   
sga_max_size 4831838208   
sga_target 4294967296   
undo_management AUTO   
undo_tablespace UNDOTBS   

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter Name Begin value End value (if different)
control_files /oradata/UEMO02/redo1/ct/control01.ctl   
/oradata/UEMO02/redo2/ct/control02.ctl   

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report