WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
UPRR1058789863uprr119-Jul-12 18:0711.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
cnuctdb130Linux x86 64-bit 16 8 2 31.28

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1991124-Apr-13 15:00:48102 3.5
End Snap:1991224-Apr-13 16:00:51122 3.6
Elapsed:  60.05 (mins)  
DB Time:  67.93 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,600M 5,600MStd Block Size: 8K
Shared Pool Size: 864M 864MLog Buffer: 21,200K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 1.1 2.8 0.03 0.05
DB CPU(s): 1.1 2.7 0.03 0.05
Redo size: 4,175.4 10,137.7  
Logical reads: 10,136.7 24,611.4  
Block changes: 10.8 26.1  
Physical reads: 41.8 101.5  
Physical writes: 1.2 2.9  
User calls: 21.1 51.3  
Parses: 2.6 6.4  
Hard parses: 0.7 1.6  
W/A MB processed: 1.2 2.9  
Logons: 0.0 0.0  
Executes: 33.8 82.0  
Rollbacks: 0.2 0.4  
Transactions: 0.4   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.59In-memory Sort %: 100.00
Library Hit %: 94.00Soft Parse %: 74.53
Execute to Parse %: 92.19Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 93.12% Non-Parse CPU: 99.60

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.48 71.93
% SQL with executions>1: 63.74 87.23
% Memory for SQL w/exec>1: 56.61 79.51

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 3,982 97.69 
log file sequential read2,616,4571,257030.85System I/O
Disk file operations I/O58,09912823.14User I/O
enq: TX - contention561121321.49Other
db file scattered read2,0521680.40User I/O

Host CPU (CPUs: 16 Cores: 8 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
1.08 1.50 3.9 3.2 0.3 92.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
6.9 97.2 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 32,030.4 32,030.4
SGA use (MB): 6,656.0 6,656.0
PGA use (MB): 684.8 734.5
% Host Mem used for SGA+PGA: 22.92 23.07

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time4,050.8499.39
DB CPU3,981.5297.69
parse time elapsed29.580.73
hard parse elapsed time27.870.68
PL/SQL execution elapsed time6.850.17
PL/SQL compilation elapsed time1.740.04
connection management call elapsed time0.440.01
hard parse (sharing criteria) elapsed time0.300.01
hard parse (bind mismatch) elapsed time0.220.01
failed parse elapsed time0.050.00
sequence load elapsed time0.030.00
repeated bind elapsed time0.010.00
DB time4,075.74 
background elapsed time3,645.17 
background cpu time11.24 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME410,820 
IDLE_TIME5,352,505 
IOWAIT_TIME14,938 
NICE_TIME2,307 
SYS_TIME183,998 
USER_TIME223,176 
LOAD12
VM_IN_BYTES6,144 
VM_OUT_BYTES32,768 
PHYSICAL_MEMORY_BYTES33,586,335,744 
NUM_CPUS16 
NUM_CPU_CORES8 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,586 
TCP_RECEIVE_SIZE_DEFAULT262,144 
TCP_RECEIVE_SIZE_MAX2,097,152 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT131,072 
TCP_SEND_SIZE_MAX1,048,576 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
24-Apr 15:00:481.08     
24-Apr 16:00:511.507.133.873.1992.870.26

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  3,982 97.69
System I/O3,305,04201,262030.96
User I/O64,458015623.84
Other46228611311.49
Commit8630230.06
Configuration3320130.02
Application6710000.00
Network54,5220000.00
Concurrency190000.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sequential read2,616,45701,25701,763.1130.85
Disk file operations I/O58,0990128239.153.14
enq: TX - contention5061121320.001.49
db file scattered read2,05201681.380.40
db file sequential read4,24201232.860.29
control file sequential read688,585040464.010.11
log file sync8630230.580.06
log buffer space3310130.220.02
direct path read400760.000.01
SQL*Net break/reset to client6700000.450.00
SQL*Net message to client53,58400036.110.00
local write wait580020.040.00
db file parallel read300260.000.00
reliable message3230000.220.00
enq: RO - fast object reuse100260.000.00
SQL*Net more data from client9300000.630.00
latch free30030.000.00
buffer busy waits50010.000.00
SQL*Net message from client53,5650140,684262636.10 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
row cache lock33103,589108430.2298.46
control file parallel write1,316015110.890.40
log file parallel write2,1810521.470.14
db file async I/O submit1,0970320.740.07
db file sequential read3670260.250.06
Disk file operations I/O3470130.230.03
os thread startup2201360.010.02
control file sequential read4,0760002.750.00
ADR block file read210030.010.00
reliable message1390000.090.00
ADR block file write50040.000.00
latch free50040.000.00
direct path write210010.010.00
log file sync20090.000.00
LGWR wait for redo copy910000.060.00
direct path sync10030.000.00
latch: call allocation60000.000.00
asynch descriptor resize89100000.060.00
rdbms ipc message37,38293108,016289025.19 
Space Manager: slave idle wait1,489977,30149031.00 
DIAG idle wait7,1911007,19810014.85 
Streams AQ: qmn coordinator idle wait258503,613140050.17 
Streams AQ: qmn slave idle wait12903,613280100.09 
pmon timer1,2041003,60229910.81 
dispatcher timer601003,600600030.04 
shared server idle wait1201003,600300010.08 
smon timer332012350.22 
SQL*Net message from client1500030.10 
class slave wait220000.01 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read2133.3 42.923.8    
ADR block file write5  60.040.0    
ADR file lock6100.0       
Disk file operations I/O58.4K49.6.235.811.92.5 .0 
LGWR wait for redo copy9198.91.1      
SQL*Net break/reset to client66899.1.9      
SQL*Net message to client53.7K100.0       
SQL*Net more data from client930100.0       
SQL*Net more data to client8100.0       
asynch descriptor resize220100.0       
buffer busy waits1392.37.7      
control file parallel write1315  3.860.526.24.45.1 
control file sequential read690.9K100.0    .0  
db file async I/O submit109756.427.09.23.13.5.3.5 
db file parallel read3    33.333.333.3 
db file scattered read205225.64.317.229.110.37.75.8 
db file sequential read460463.55.24.014.510.52.2.2 
direct path read425.0 50.0   25.0 
direct path sync1  100.0     
direct path write2190.5   9.5   
enq: HW - contention1100.0       
enq: RO - fast object reuse1     100.0  
enq: TX - contention5  60.0    40.0
latch free812.5 50.037.5    
latch: cache buffers chains1100.0       
latch: call allocation6100.0       
latch: messages32100.0       
latch: row cache objects1100.0       
library cache: mutex X13100.0       
local write wait58 91.46.9 1.7   
log buffer space33023.663.64.52.73.9.9.6 
log file parallel write217944.742.44.93.63.3.6.6 
log file sequential read2617.2K100.0.0.0.0.0.0.0 
log file sync86436.249.05.33.84.3.6.8 
os thread startup22     27.372.7 
reliable message46198.9.4.2.4    
row cache lock330       100.0
DIAG idle wait7190      100.0 
SQL*Net message from client53.7K61.08.14.62.11.01.218.73.4
Space Manager: slave idle wait1493.1 .1  .11.198.5
Streams AQ: qmn coordinator idle wait25850.0      50.0
Streams AQ: qmn slave idle wait129       100.0
class slave wait22100.0       
dispatcher timer60       100.0
pmon timer1204.2      99.8
rdbms ipc message37.4K1.4.1.2.3.51.321.574.7
shared server idle wait120       100.0
smon timer331  .3 4.292.42.4.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
Disk file operations I/O2100.0 .0     
control file parallel write6794.93.8.9.4    
db file async I/O submit699.5 .2.4    
db file parallel read166.733.3      
db file scattered read11894.25.2.5 .0   
db file sequential read1099.8.1.0.0.0   
direct path read175.0   25.0   
log buffer space299.4.3 .3    
log file parallel write1399.4.2.2.2    
log file sequential read4100.0.0      
log file sync799.2.2.3.2    
os thread startup1627.372.7      
row cache lock1      .399.7

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
enq: TX - contention260.0   20.020.0  
row cache lock329.3 .398.8.3.3  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS3,9363,84215035,853
uprr1401400542
SYS$BACKGROUND000128
uprrXDB0000

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 6442015615000502380
uprr 380400042840
SYS$BACKGROUND 735436235900000

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 IdSQL ModuleSQL Text
1,635.4115110.8340.1399.813.613g3k82x8rr54f JDBC Thin Client insert into DF2_GL_BALANCE_QUE...
68.31168.311.6899.980.00gb3kwkhf2yrhp PL/SQL Developer select * from v$access t where...
52.511190.441.29100.000.007ua2j58f81vrx JDBC Thin Client SELECT MIN( TRIM( (CASE WHEN C...
39.30139.300.9691.709.107n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
37.00137.000.9199.500.47c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...
36.89136.890.9199.710.24fd53yjyv8rk2k JDBC Thin Client INSERT INTO DA_MID_RISK_RECON_...
34.96321.090.8692.828.031s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
33.51470.710.8299.870.00gnmzswnx7jhpb JDBC Thin Client select distinct a.id as ID, a...
31.19131.190.7799.950.002gq55bxkz1h3w PL/SQL Developer select * from v$access t where...
28.98128.980.7199.980.0070d40ycg6a7wm PL/SQL Developer select * from v$access t where...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
1,632.3215110.8141.001,635.4199.813.613g3k82x8rr54f JDBC Thin Client insert into DF2_GL_BALANCE_QUE...
68.30168.301.7268.3199.980.00gb3kwkhf2yrhp PL/SQL Developer select * from v$access t where...
52.511190.441.3252.51100.000.007ua2j58f81vrx JDBC Thin Client SELECT MIN( TRIM( (CASE WHEN C...
36.81136.810.9237.0099.500.47c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...
36.78136.780.9236.8999.710.24fd53yjyv8rk2k JDBC Thin Client INSERT INTO DA_MID_RISK_RECON_...
36.04136.040.9139.3091.709.107n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
33.46470.710.8433.5199.870.00gnmzswnx7jhpb JDBC Thin Client select distinct a.id as ID, a...
32.45321.010.8134.9692.828.031s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
31.17131.170.7831.1999.950.002gq55bxkz1h3w PL/SQL Developer select * from v$access t where...
28.98128.980.7328.9899.980.0070d40ycg6a7wm PL/SQL Developer select * from v$access t where...

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)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
59.041510.3936.881,635.4199.813.613g3k82x8rr54f JDBC Thin Client insert into DF2_GL_BALANCE_QUE...
7.91140.564.9423.5169.1833.6461jpjbwnk0540 JDBC Thin Client SELECT TRIM(CUSTOMER_TYPE) FRO...
3.5813.582.2339.3091.709.107n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
2.811320.021.7628.3091.109.94bdu0m3mj7ctp0 JDBC Thin Client SELECT 'Y', BUY_CURR_CD, BUY_A...
2.81320.091.7534.9692.828.031s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
1.919220.001.192.016.7094.65db78fxqxwxt7r   select /*+ rule */ bucket, end...
0.3310.330.210.6542.1051.296ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.181,4770.000.110.2330.9276.9796g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.18790.000.110.209.1489.803ktacv9r56b51   select owner#, name, namespace...
0.1710.170.1137.0099.500.47c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
9,682,91111981,369.0026.5152.5110007ua2j58f81vrx JDBC Thin Client SELECT MIN( TRIM( (CASE WHEN C...
6,918,36516,918,365.0018.9437.0099.5.5c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...
6,917,80116,917,801.0018.9436.8999.7.2fd53yjyv8rk2k JDBC Thin Client INSERT INTO DA_MID_RISK_RECON_...
4,401,9374793,658.2312.0533.5199.90gnmzswnx7jhpb JDBC Thin Client select distinct a.id as ID, a...
4,037,42212632,043.0311.0522.7810003wzwf08xd4w4s JDBC Thin Client SELECT TRIM(REPLACE(UNIQUEID1,...
3,560,72513,560,725.009.7539.3091.79.17n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
2,938,8233291,838.228.0534.9692.881s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
2,325,13713217,614.676.3728.3091.19.9bdu0m3mj7ctp0 JDBC Thin Client SELECT 'Y', BUY_CURR_CD, BUY_A...
1,182,3071484,450.503.2423.5169.233.661jpjbwnk0540 JDBC Thin Client SELECT TRIM(CUSTOMER_TYPE) FRO...
1,112,3733333,708.273.0512.76100059bd50dx0gnuc JDBC Thin Client SELECT MASTERNO FROM ( SELECT ...
866,3342732,086.442.378.4499.808s310q37bt7wx JDBC Thin Client select distinct a.id as ID, a...
692,111798,873.001.893.72100.100p21nprzuzgv0 JDBC Thin Client select distinct a.id as ID, a...
672,5111672,511.001.847.2710003k21pj69wssa8 JDBC Thin Client INSERT INTO DA_MEND_RISK_RECON...
480,9152320,909.351.325.4199.7087yc7kybat4nz JDBC Thin Client select distinct a.id as ID, a...
478,9611629,935.061.314.0410000gj0h89xjnkzb PL/SQL Developer SELECT /*+ rule */ s.username,...
464,9182062,256.881.272.2698.8.7g4qnkaybj4qd5 JDBC Thin Client SELECT FALG, BUY_CURR_CD, BUY_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
99,939147,138.5066.3323.5169.1833.6461jpjbwnk0540 JDBC Thin Client SELECT TRIM(CUSTOMER_TYPE) FRO...
36,030136,030.0023.9139.3091.709.107n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
34,509132261.4322.9028.3091.109.94bdu0m3mj7ctp0 JDBC Thin Client SELECT 'Y', BUY_CURR_CD, BUY_A...
34,508321,078.3822.9034.9692.828.031s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
3801380.000.2537.0099.500.47c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...
3021512.000.201,635.4199.813.613g3k82x8rr54f JDBC Thin Client insert into DF2_GL_BALANCE_QUE...
2319220.250.152.016.7094.65db78fxqxwxt7r   select /*+ rule */ bucket, end...
64164.000.040.6542.1051.296ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
241,4770.020.020.2330.9276.9796g93hntrzjtr   select /*+ rule */ bucket_cnt,...
21790.270.010.209.1489.803ktacv9r56b51   select owner#, name, namespace...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
30,17130,171151199.810.00478.153g3k82x8rr54f JDBC Thin Client insert into DF2_GL_BALANCE_QUE...
8148141458.140.0012.9061jpjbwnk0540 JDBC Thin Client SELECT TRIM(CUSTOMER_TYPE) FRO...
3333331333.000.005.287n74kn6jfkrn6 JDBC Thin Client call etl_da_mend_risk_recon_fx...
2872871322.170.004.55bdu0m3mj7ctp0 JDBC Thin Client SELECT 'Y', BUY_CURR_CD, BUY_A...
286286328.940.004.531s21c96ayu4qh JDBC Thin Client SELECT TRIM(CUSTOMER_NAME) FRO...
2312319220.250.003.66db78fxqxwxt7r   select /*+ rule */ bucket, end...
24241,4770.020.000.3896g93hntrzjtr   select /*+ rule */ bucket_cnt,...
2121790.270.000.333ktacv9r56b51   select owner#, name, namespace...
1717117.000.000.27c21usvaynd7rs JDBC Thin Client call etl_da_mid_risk_recon_288...
1111790.140.000.178swypbbr0m372   select order#, columns, types ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
1,5381,5381.006.3099.804jsqz2txmvamg JDBC Thin Client SELECT (:B3 +COUNT(1)) FROM UP...
1,4771,4390.970.2330.97796g93hntrzjtr   select /*+ rule */ bucket_cnt,...
92215,63616.962.016.794.6db78fxqxwxt7r   select /*+ rule */ bucket, end...
7197181.002.0499.10c3m2v78k06wvy JDBC Thin Client SELECT NULL AS table_cat, c.ow...
7098261.170.03113053saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
6846841.000.04109.60grwydz59pu6mc   select text from view$ where r...
5855851.000.0866.631.79tgj4g8y4rwy8   select type#, blocks, extents,...
43900.000.02209.60b2gnxm5z6r51n   lock table sys.col_usage$ in e...
3303301.001.4399.60gzq9b3gr9a6fk   select file#, block# from seg$...
2382360.990.01124.10cazkts1kztw6h JDBC Thin Client SELECT PARENT_INST_ID, INST_LA...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
4394394.62b2gnxm5z6r51n   lock table sys.col_usage$ in e...
2322322.44350f5yrnnmshs   lock table sys.mon_mods$ in ex...
482240.502q93zsrvbdw48   select grantee#, privilege#, n...
482150.506aq34nj2zb2n7   select col#, grantee#, privile...
462310.4883taa7kaw59c1   select name, intcol#, segcol#,...
44440.460ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
442130.463w4qs0tbpmxr6   select con#, obj#, rcon#, enab...
44440.46459f3z9u4fb3u   select value$ from props$ wher...
442130.46gx4mv66pvj3xz   select con#, type#, condlength...
43430.450k8522rmdzg4k   select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,667,28770.29451nas8qa19mp JDBC Thin Client select bank_id as ID, bank_nam...
2,614,39970.29451nas8qa19mp JDBC Thin Client select bank_id as ID, bank_nam...
1,251,77270.14ghzg8va62bxad JDBC Thin Client select * from oper_meta where...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
261,47796g93hntrzjtr   select /*+ rule */ bucket_cnt,...
24861gu8t96d0bdmu   select t.ts#, t.file#, t.block...
24793ktacv9r56b51   select owner#, name, namespace...
2479a9u0s3g93f47z   select decode(u.type#, 2, u.ex...
221,5384jsqz2txmvamg JDBC Thin Client SELECT (:B3 +COUNT(1)) FROM UP...
2270953saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
222025n1fs4m2n2y0r   select pos#, intcol#, col#, sp...
2186cm5vu20fhtnq1   select /*+ connect_by_filterin...
21922db78fxqxwxt7r   select /*+ rule */ bucket, end...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0gj0h89xjnkzbSELECT /*+ rule */ s.username, decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL, o.owner, o.object_name, o.object_type, s.sid, s.serial#, s.terminal, s.machine, s.program, s.osuser FROM v$session s, v$lock l, dba_objects o WHERE l.sid = s.sid AND l.id1 = o.object_id(+) AND s.username is NOT Null
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0p21nprzuzgv0 select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id inner join task_report_dim trd on a.task_id = trd.task_id inner join safe_report_info_set sris on trd.report_id = sris.report_code and sris.report_sign='1' and (sris.STATUS is null or sris.STATUS ='1' or sris.STATUS ='3') left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:12 and RR.RES_ID=:13 AND RR.OBJECT_ID IN ( :14 , :15 ) ) ) AND ( tbs.bank_status = :16 ) AND ( a.task_status = :17 ) order by a.report_date desc, b.task_name desc
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1s21c96ayu4qhSELECT TRIM(CUSTOMER_NAME) FROM DF_CUSTOMER_PROFILE WHERE TRIM(CUSTOMER_ID) IN ( SELECT TRIM(CUSTOMER_ID) FROM DF_DTP_DAILY_DEALS WHERE TRIM(DEAL_NO)=TRIM(:B2 ) AND ROWNUM=1 ) AND ROWNUM=1 AND SUBSTR(DATA_DATE, 1, 10)=SUBSTR(:B1 , 1, 10)
2gq55bxkz1h3wselect * from v$access t where t.OBJECT = 'TABLE'
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3g3k82x8rr54finsert into DF2_GL_BALANCE_QUERY( Account, Account_Desc, Dept_ID, Dept_ID_Desc, Oper_Unit, Oper_Unit_Desc, Product, Product_Desc, C_Class, C_Class_Desc, Affiliate, Affiliate_Desc, Project_ID, Project_ID_Desc, Tran_Ccy, Tran_Amt, Base_Ccy, Base_Amt, branch, DATA_DATE) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 )
3k21pj69wssa8INSERT INTO DA_MEND_RISK_RECON_FX (DATA_DATE, PURCCY, PURAMT, SALECCY, SALEAMT, VALUEDATE, CUST_NAME, ACCOUNT_NUMBER, DEALNO, FXCODE, NARRATIONTRAN, CHECK_FLAG, MATCH_TYPE, ORG_ID ) SELECT DATA_DATE, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'B'), JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'A'), CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE NULL END, FUND_ITEM, NARRATIONTRAN, '0', 'TRADE', BRANCH_ID FROM ( SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRADE WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRDTPI WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TRDTPT WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM FROM DA_MEND_ACMOV_TROTP WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL ) WHERE DATA_DATE = :B1 AND BRANCH_ID IS NOT NULL AND NARRATIONTRAN NOT IN (SELECT DISTINCT NARRATIONTRAN FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B1 AND MATCH_TYPE ='TRADE' AND TRIM(NARRATIONTRAN) IS NOT NULL)
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3w4qs0tbpmxr6select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
3wzwf08xd4w4sSELECT TRIM(REPLACE(UNIQUEID1, '-', '')) FROM DA_MID_CUST_STATUS WHERE ACCOUNT_NO = :B1 AND UNIQUEID1 IS NOT NULL AND ROWNUM = 1
451nas8qa19mpselect bank_id as ID, bank_name as NAME from bank_basis where bank_id in(select member_code from auth_bank_group_member where group_code in (select bank_group_code from auth_user_bank_rights where user_code=:1 and is_user_group in('N', 'n')) union select member_code from auth_bank_group_member where group_code in (select bank_group_code from auth_user_bank_rights where is_user_group in('Y', 'y') and user_code in(select group_code from auth_user_group_member where member_code=:2 ))) order by bank_order
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4jsqz2txmvamgSELECT (:B3 +COUNT(1)) FROM UPRR.U_BASE_HOLIDAY HD WHERE HD.HOLIDAY_TYPE = :B2 AND GETDATE(HD.HOLIDAY_VALUE) = :B1
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
59bd50dx0gnucSELECT MASTERNO FROM ( SELECT TRIM(MASTERNO) MASTERNO FROM DA_MID_CUST_STATUS WHERE TRIM(ACCOUNT_NO) = TRIM(:B1 ) AND TRIM(MASTERNO) IS NOT NULL ) T WHERE ROWNUM=1
5n1fs4m2n2y0rselect pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
61jpjbwnk0540SELECT TRIM(CUSTOMER_TYPE) FROM DF_CUSTOMER_PROFILE WHERE TRIM(CUSTOMER_ID) IN ( SELECT TRIM(CUSTOMER_ID) FROM DF_DTP_DAILY_DEALS WHERE TRIM(DEAL_NO)=TRIM(:B2 ) AND ROWNUM=1 ) AND ROWNUM=1 AND SUBSTR(DATA_DATE, 1, 7)=SUBSTR(:B1 , 1, 7)
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
70d40ycg6a7wmselect * from v$access t where t.TYPE = 'TABLE'
7n74kn6jfkrn6call etl_da_mend_risk_recon_fx(:1 )
7ua2j58f81vrxSELECT MIN( TRIM( (CASE WHEN CUSTOMER_FULL_NAME_IN_CHINESE IS NULL THEN CUSTOMER_FULL_NAME ELSE CUSTOMER_FULL_NAME_IN_CHINESE END ) ) ) FROM DA_MID_CUST_STATUS WHERE ACCOUNT_NO=:B1
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
87yc7kybat4nz select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 , :12 , :13 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:14 and RR.RES_ID=:15 AND RR.OBJECT_ID IN ( :16 , :17 , :18 , :19 ) ) ) AND ( tbs.bank_status = :20 OR tbs.bank_status = :21 OR tbs.bank_status = :22 ) AND ( a.task_status = :23 ) order by a.report_date desc, b.task_name desc
8s310q37bt7wx select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 , :12 , :13 , :14 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:15 and RR.RES_ID=:16 AND RR.OBJECT_ID IN ( :17 , :18 , :19 , :20 , :21 ) ) ) AND ( tbs.bank_status = :22 OR tbs.bank_status = :23 OR tbs.bank_status = :24 ) AND ( a.task_status = :25 ) order by a.report_date desc, b.task_name desc
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a9u0s3g93f47zselect decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bdu0m3mj7ctp0SELECT 'Y', BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'B') , JSH_GET_TRADE_RISKRECON(TRIM(SUBSTR(NARRATIONTRAN, 5, LENGTH(NARRATIONTRAN) - 10)), DATA_DATE, 'A'), CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END, FUND_ITEM, NARRATIONTRAN, BRANCH_ID FROM ( SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRADE A WHERE DATA_DATE = :B1 AND A.BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRDTPI B WHERE DATA_DATE = :B1 AND B. BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TRDTPT C WHERE DATA_DATE = :B1 AND C.BRANCH_ID IS NOT NULL UNION ALL SELECT DATA_DATE, BRANCH_ID, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, NARRATIONTRAN, FUND_ITEM, BRANCH_ID AS ORG_ID FROM DA_MEND_ACMOV_TROTP D WHERE DATA_DATE = :B1 AND D.BRANCH_ID IS NOT NULL ) WHERE DATA_DATE = :B1 AND ORG_ID IS NOT NULL AND ((BUY_CURR_CD = :B5 AND BUY_AMT = :B4 ) OR (SELL_CURR_CD = :B3 AND SELL_AMT = :B2 )) AND NARRATIONTRAN NOT IN (SELECT DISTINCT NARRATIONTRAN FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B1 AND MATCH_TYPE='TRADE' AND TRIM(NARRATIONTRAN) IS NOT NULL) AND ROWNUM = 1
c21usvaynd7rscall etl_da_mid_risk_recon_288810(:1 )
c3m2v78k06wvySELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name
cazkts1kztw6hSELECT PARENT_INST_ID, INST_LAYER FROM UPRR.U_BASE_INST WHERE INST_ID= :B1
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fd53yjyv8rk2kINSERT INTO DA_MID_RISK_RECON_288810 (DATA_DATE, ROW_NO, CCY, AMT, PURCCY, PURAMT, SALECCY, SALEAMT, VALUEDATE, CUST_NAME, ACCOUNT_NUMBER, NARRATION, DEALNO, BR_CODE) SELECT DATA_DATE, TO_CHAR(ROWNUM), TRIM(CCY), NVL(AMOUNT, 0), CASE WHEN TRIM(CR_DR)='D' THEN TRIM(CCY) ELSE NULL END, CASE WHEN TRIM(CR_DR)='D' THEN ABS(NVL(AMOUNT, 0)) ELSE NULL END, CASE WHEN TRIM(CR_DR)='C' THEN TRIM(CCY) ELSE NULL END, CASE WHEN TRIM(CR_DR)='C' THEN ABS(NVL(AMOUNT, 0)) ELSE NULL END, TO_CHAR(TO_DATE(VALUE_DATE), 'yyyy-mm-dd'), JSH_GET_CUSTOMERNAME(TRIM(ACCOUNT_NO), ''), TRIM(ACCOUNT_NO), TRIM(NARRATION), CASE WHEN NARRATION LIKE '%DEAL NO.%' THEN TRIM(SUBSTR(NARRATION, INSTR(NARRATION, 'DEAL NO. ') + 9, 7)) ELSE NULL END, GETCOST_ORGID(REPLACE(LPAD(BR_CODE, 3), ' ', '0'), '01') FROM DF_RISK_RECON_288810 WHERE DATA_DATE =:B1 AND UPPER(TRIM(CCY)) <> 'CNY' AND TRIM(EXTREFNO) IS NOT NULL
g4qnkaybj4qd5SELECT FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, ACCOUNT_NUMBER, DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM (SELECT 'Y' FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, CASE WHEN SUBSTR(BUY_ACNUM, 1, 1) ='0' THEN BUY_ACNUM ELSE SELL_ACNUM END ACCOUNT_NUMBER, CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM DA_MEND_ACMOV_CMS WHERE DATA_DATE = :B5 AND BUY_CURR_CD = :B4 AND BUY_AMT = :B3 AND SELL_CURR_CD = :B2 AND SELL_AMT = :B1 AND (MAKERID, REFERENCENUMBER) NOT IN (SELECT DISTINCT MAKERID, REFERENCENUMBER FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B5 AND MATCH_TYPE='CMS' AND TRIM(REFERENCENUMBER) IS NOT NULL AND TRIM(MAKERID) IS NOT NULL ) UNION ALL SELECT 'Y' FALG, BUY_CURR_CD, BUY_AMT, SELL_CURR_CD, SELL_AMT, VALUEDT_YYYYMMDD, CUSTOMERNAME, CASE WHEN SUBSTR(BUY_ACNUM, 1, 1) ='0' THEN BUY_ACNUM ELSE SELL_ACNUM END ACCOUNT_NUMBER, CASE WHEN NARRATIONTRAN LIKE '%DEAL NO.%' THEN SUBSTR(NARRATIONTRAN, INSTR(NARRATIONTRAN, 'DEAL NO.') + 8, 7) ELSE '' END DEALNO, FUND_ITEM, REFERENCENUMBER, MAKERID, BRANCH_ID FROM DA_MEND_ACMOV_CMS_SH WHERE DATA_DATE = :B5 AND BUY_CURR_CD = :B4 AND BUY_AMT = :B3 AND SELL_CURR_CD = :B2 AND SELL_AMT = :B1 AND (MAKERID, REFERENCENUMBER) NOT IN (SELECT DISTINCT MAKERID, REFERENCENUMBER FROM DA_MEND_RISK_RECON_FX WHERE DATA_DATE = :B5 AND MATCH_TYPE='CMS' AND TRIM(REFERENCENUMBER) IS NOT NULL AND TRIM(MAKERID) IS NOT NULL ) ) A WHERE ROWNUM = 1
gb3kwkhf2yrhpselect * from v$access t where t.TYPE = 'TABLE' AND T.OBJECT='DF2_GL_BALANCE_QUERY'
ghzg8va62bxad select * from oper_meta where oper_id in (select MEMBER_CODE from AUTH_OPER_GROUP_MEMBER where group_code in (select OPER_GROUP_CODE from AUTH_USER_OPER_RIGHTS where user_code=:1 and is_user_group in('N', 'n')) union select member_code from AUTH_OPER_GROUP_MEMBER where group_code in (select OPER_GROUP_CODE from AUTH_USER_OPER_RIGHTS where is_user_group in('Y', 'y') and user_code in(select group_code from auth_user_group_member where member_code=:2 ))) order by oper_order
gnmzswnx7jhpb select distinct a.id as ID, a.task_id as TASK_ID, b.task_name as TASK_NAME, a.report_date as REPORT_DATE, a.task_status as TASK_STATUS, rs.status_name as TASK_STATUS_CH, a.start_user as START_USER, aui.user_name as START_USER_CH, a.start_time as START_TIME, a.end_time as END_TIME, ci.code_label as FREQUENCY, b.remark as TOTAL_TYPE, a.need_recheck, a.need_sameaudit from task_instance a join task_define b on a.task_id = b.task_id inner join task_bank_status tbs on a.task_id=tbs.task_id and a.report_date=tbs.report_date inner join bank_basis bank on tbs.bank_id=bank.bank_id left join report_status rs on a.task_status=rs.status_id left join code_info ci on ci.code_value=b.frequency left join auth_user_info aui on a.start_user=aui.user_id inner join task_subject_relation tsr on a.task_id=tsr.task_id where tsr.subject_id = :1 and ci.code_type='report_freq' and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_bank_dim task inner join bank_basis bank on task.bank_id=bank.bank_id where task.bank_id in ( SELECT DISTINCT U.INST_ID FROM NEW_U_BASE_INST_RELA U where (U.INST_ID = :2 OR U.INST_ID_LEVEL_1 = :3 OR U.INST_ID_LEVEL_2 = :4 OR U.INST_ID_LEVEL_3 = :5 OR U.INST_ID_LEVEL_4 = :6 OR U.INST_ID_LEVEL_5 = :7 OR U.INST_ID_LEVEL_6 = :8 ) UNION SELECT DISTINCT RR.RES_DETAIL_VALUE AS INST_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.RES_ID='35' AND RR.SYSTEM_ID=:9 AND RR.OBJECT_ID IN( :10 , :11 ) ) ) and (a.task_id, a.report_date) in ( select distinct task_id, report_date from task_instance_report_dim task inner join report_meta report on task.report_id=report.report_id where task.report_id in ( SELECT DISTINCT RR.RES_DETAIL_VALUE AS REPORT_ID FROM NEW_AUTH_ROLE_RES RR WHERE RR.SYSTEM_ID=:12 and RR.RES_ID=:13 AND RR.OBJECT_ID IN ( :14 , :15 ) ) ) AND ( tbs.bank_status = :16 OR tbs.bank_status = :17 OR tbs.bank_status = :18 ) AND ( a.task_status = :19 ) order by a.report_date desc, b.task_name desc
grwydz59pu6mcselect text from view$ where rowid=:1
gx4mv66pvj3xzselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1
gzq9b3gr9a6fkselect file#, block# from seg$ where ts# = :1 and hwmincr = :2

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count40.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count10.000.00
Batched IO same unit count10.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count20.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced40.000.00
CCursor + sql area evicted630.020.04
CPU used by this session398,362110.56268.44
CPU used when call started397,918110.44268.14
CR blocks created150.000.01
Cached Commit SCN referenced8060.220.54
Commit SCN cached90.000.01
DB time407,050112.97274.29
DBWR checkpoint buffers written4,0431.122.72
DBWR checkpoints20.000.00
DBWR object drop buffers written590.020.04
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written10.000.00
DBWR transaction table writes1050.030.07
DBWR undo block writes6470.180.44
HSC Heap Segment Block Changes8,2172.285.54
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts2,0880.581.41
Heap Segment Array Updates1,4310.400.96
IMU CR rollbacks50.000.00
IMU Flushes4580.130.31
IMU Redo allocation size762,724211.69513.96
IMU commits6970.190.47
IMU contention10.000.00
IMU ktichg flush10.000.00
IMU pool not allocated00.000.00
IMU recursive-transaction flush00.000.00
IMU undo allocation size1,783,832495.091,202.04
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued40.000.00
Requests to/from client53,56714.8736.10
RowCR - row contention00.000.00
RowCR attempts70.000.00
RowCR hits100.000.01
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment shrink60.000.00
SQL*Net roundtrips to/from client53,58914.8736.11
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout1,0530.290.71
application wait time150.000.01
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts34,8819.6823.50
branch node splits00.000.00
buffer is not pinned count2,513,050697.481,693.43
buffer is pinned count7,575,8962,102.635,105.05
bytes received via SQL*Net from client17,232,6554,782.7811,612.30
bytes sent via SQL*Net to client21,949,2056,091.8214,790.57
calls to get snapshot scn: kcmgss132,13636.6789.04
calls to kcmgas4,4861.253.02
calls to kcmgcs671,711186.43452.64
cell physical IO interconnect bytes2,721,351,236,096755,288,484.101,833,794,633.49
change write time420.010.03
cleanout - number of ktugct calls1,0700.300.72
cleanouts and rollbacks - consistent read gets10.000.00
cleanouts only - consistent read gets150.000.01
cluster key scan block gets371,031102.98250.02
cluster key scans359,50499.78242.25
commit batch performed00.000.00
commit batch requested00.000.00
commit batch/immediate performed3330.090.22
commit batch/immediate requested3330.090.22
commit cleanout failures: block lost00.000.00
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure80.000.01
commit cleanout failures: cannot pin60.000.00
commit cleanouts5,5511.543.74
commit cleanouts successfully completed5,5371.543.73
commit immediate performed3330.090.22
commit immediate requested3330.090.22
commit txn count during cleanout790.020.05
concurrency wait time358,96299.63241.89
consistent changes800.020.05
consistent gets36,476,83110,123.8424,580.07
consistent gets - examination2,309,307640.931,556.14
consistent gets direct150.000.01
consistent gets from cache36,476,81610,123.8424,580.06
consistent gets from cache (fastpath)34,135,2709,473.9623,002.20
cursor authentications1,1180.310.75
data blocks consistent reads - undo records applied140.000.01
db block changes38,75110.7626.11
db block gets46,47412.9031.32
db block gets direct490.010.03
db block gets from cache46,42512.8831.28
db block gets from cache (fastpath)9,5352.656.43
deferred (CURRENT) block cleanout applications2,5140.701.69
dirty buffers inspected110.000.01
doubling up with imu segment00.000.00
drop segment calls in space pressure00.000.00
enqueue conversions1,8900.521.27
enqueue deadlocks00.000.00
enqueue releases13,3203.708.98
enqueue requests13,3393.708.99
enqueue timeouts00.000.00
enqueue waits70.000.00
exchange deadlocks00.000.00
execute count121,65133.7681.98
failed probes on index block reclamation00.000.00
file io service time00.000.00
file io wait time33,089,3479,183.6722,297.40
frame signature mismatch00.000.00
free buffer inspected150,68341.82101.54
free buffer requested153,74142.67103.60
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress930.030.06
hot buffers moved to head of LRU8,5692.385.77
immediate (CR) block cleanout applications160.000.01
immediate (CURRENT) block cleanout applications3260.090.22
in call idle wait time13,335,3393,701.118,986.08
index crx upgrade (positioned)270.010.02
index crx upgrade (prefetch)00.000.00
index fast full scans (full)8840.250.60
index fetch by key4,830,0431,340.543,254.75
index scans kdiixs1571,202158.53384.91
leaf node 90-10 splits370.010.02
leaf node splits550.020.04
lob reads2950.080.20
lob writes1710.050.12
lob writes unaligned1710.050.12
local undo segment hints helped00.000.00
logical read bytes from cache299,198,390,27283,040,033.80201,616,165.95
logons cumulative660.020.04
max cf enq hold time900.020.06
messages received12,8143.568.63
messages sent12,8143.568.63
min active SCN optimization applied on CR00.000.00
no buffer to keep pinned count4040.110.27
no work - consistent read gets33,470,8519,289.5622,554.48
non-idle wait count3,439,718954.672,317.87
non-idle wait time509,837141.50343.56
opened cursors cumulative116,02432.2078.18
parse count (describe)70.000.00
parse count (failures)40.000.00
parse count (hard)2,4210.671.63
parse count (total)9,5062.646.41
parse time cpu1,5980.441.08
parse time elapsed1,7160.481.16
physical read IO requests6,3101.754.25
physical read bytes1,234,354,176342,584.77831,775.05
physical read total IO requests3,315,564920.212,234.21
physical read total bytes2,721,219,817,984755,252,010.091,833,706,076.81
physical read total multi block requests2,584,768717.381,741.76
physical reads150,67841.82101.54
physical reads cache150,66341.82101.52
physical reads cache prefetch144,38440.0797.29
physical reads direct150.000.01
physical reads direct (lob)40.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,6970.471.14
physical write bytes34,586,6249,599.2323,306.35
physical write total IO requests10,0192.786.75
physical write total bytes131,418,11236,474.0188,556.68
physical write total multi block requests1500.040.10
physical writes4,2221.172.85
physical writes direct490.010.03
physical writes direct (lob)200.010.01
physical writes direct temporary tablespace00.000.00
physical writes from cache4,1731.162.81
physical writes non checkpoint2,5700.711.73
pinned buffers inspected00.000.00
pinned cursors current30.000.00
prefetch clients - default620.020.04
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time3,5530.992.39
recursive aborts on index block reclamation00.000.00
recursive calls212,15458.88142.96
recursive cpu usage369,981102.69249.31
redo KB read2,645,512,747734,240.141,782,690.53
redo KB read (memory)1,098,273304.82740.08
redo blocks checksummed by FG (exclusive)18,8695.2412.71
redo blocks checksummed by LGWR1,0090.280.68
redo blocks written31,3948.7121.15
redo buffer allocation retries00.000.00
redo entries23,8066.6116.04
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks6350.180.43
redo size15,044,3684,175.4410,137.71
redo size for direct writes403,172111.90271.68
redo subscn max counts2,6200.731.77
redo synch long waits110.000.01
redo synch time2340.060.16
redo synch time (usec)2,375,377659.271,600.66
redo synch writes1,5660.431.06
redo wastage518,988144.04349.72
redo write time5200.140.35
redo writes2,1810.611.47
rollback changes - undo records applied3380.090.23
rollbacks only - consistent read gets130.000.01
root node splits00.000.00
rows fetched via callback572,630158.93385.87
session connect time00.000.00
session cursor cache hits41,95611.6428.27
session logical reads36,523,30510,136.7424,611.39
shared hash latch upgrades - no wait25,3287.0317.07
shared hash latch upgrades - wait730.020.05
sorts (disk)00.000.00
sorts (memory)547,266151.89368.78
sorts (rows)4,417,8761,226.142,977.01
space was found by tune down00.000.00
sql area evicted2,2690.631.53
sql area purged50.000.00
steps of tune down ret. in space pressure00.000.00
summed dirty queue length130.000.01
switch current to new buffer1,6140.451.09
table fetch by rowid3,960,8041,099.292,669.01
table fetch continued row3120.090.21
table scan blocks gotten31,530,7218,751.0921,247.12
table scan rows gotten1,085,161,459301,177.57731,240.88
table scans (direct read)00.000.00
table scans (long tables)3130.090.21
table scans (short tables)588,655163.38396.67
temp space allocated (bytes)1,048,576291.02706.59
total cf enq hold time6,5601.824.42
total number of cf enq holders7080.200.48
total number of times SMON posted3390.090.23
transaction rollbacks3320.090.22
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
tune down retentions in space pressure00.000.00
undo change vector size2,214,196614.531,492.05
user I/O wait time15,9934.4410.78
user calls76,06421.1151.26
user commits8240.230.56
user rollbacks6600.180.44
workarea executions - onepass00.000.00
workarea executions - optimal540,543150.02364.25
write clones created in background580.020.04
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory14,999,681,229,59214,999,692,879,872
opened cursors current361438
logons current102122
session uga memory max875,593,671,808875,790,843,624
session pga memory27,690,027,58427,711,342,272
session pga memory max81,387,932,91281,427,958,960
session cursor cache count2,834,6392,835,655

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others2.5T918.33720.11362M1.10.0172073310.9K0.01
Buffer Cache Reads1.1G1.56.3252780M0.000M56134.86
DBWR0M0.000M33M0.47.00915810971.89
LGWR0M0.000M30M1.21.00832643581.85
Direct Reads0M0.000M0M0.000M475.75
Direct Writes0M0.000M0M0.010M210.81
TOTAL:2.5T919.89720.439125M2.78.0346923322K0.02

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File2.5T726.28717.11030M1.21.0083260.000.00
Control File10.5G191.762.9960662M1.10.0172070.00 
Data File1.1G1.85.32666633M0.47.0091583.0210.47
TOTAL:2.5T919.89720.433125M2.78.0346920.020.00

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
Others 2.5T918.31720.09962M1.10.0172073308K0.00
Others (Log File) 2.5T726.27717.1010M0.000M2616.1K0.00
Others (Control File) 10.5G191.762.9960662M1.10.017207690.9K0.00
Others (Data File) 8M0.29.0022200M0.000M10411.31
Buffer Cache Reads 1.1G1.56.3252780M0.000M56124.83
Buffer Cache Reads (Data File) 1.1G1.56.3252780M0.000M56124.83
DBWR 0M0.000M33M0.46.0091580 
DBWR (Data File) 0M0.000M33M0.46.0091580 
LGWR 0M0.000M30M1.21.0083260 
LGWR (Log File) 0M0.000M30M1.21.0083260 
Direct Writes 0M0.000M0M0.010M0 
Direct Writes (Data File) 0M0.000M0M0.010M0 
Direct Reads 0M0.000M0M0.000M0 
Direct Reads (Data File) 0M0.000M0M0.000M0 
TOTAL: 2.5T919.88720.425125M2.78.0346923313.6K0.01

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATACORE 5,29114.0628.26412000.00
SYSAUX 31907.341.00486000.00
UNDOTBS1 33104.081.00239080.00
SYSTEM 40508.301.00106061.67
METABASE 8206.831.05204000.00
REPORT 10906.701.0015000.00
WORK 5107.061.0071000.00
UPRR_DATA 22010.453.9185000.00
MDR 7010.001.5761000.00
ACC 2001.504.753000.00
CFA 506.001.8015000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
ACC/safedata/oracle/data/uprr/ACC_0001.DBF 2001.504.753000.00
CFA/safedata/oracle/data/uprr/CFA_0001.DBF 506.001.8015000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0001.DBF 2,09711.8323.90200000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0002.DBF 52303.9023.7348000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0003.DBF 1,08203.1116.8958000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0004.DBF 67105.8730.6361000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0005.DBF 171010.9977.9515000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0006.DBF 20208.9672.188000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0007.DBF 24409.1036.247000.00
DATACORE/safedata/oracle/data/uprr/DATACORE_0008.DBF 30107.9437.8215000.00
MDR/safedata/oracle/data/uprr/MDR_0001.DBF 7010.001.5761000.00
METABASE/safedata/oracle/data/uprr/METABASE_0001.DBF 8206.831.05204000.00
REPORT/safedata/oracle/data/uprr/REPORT_0001.DBF 10906.701.0015000.00
SYSAUX/safedata/oracle/data/uprr/sysaux01.dbf 31907.341.00486000.00
SYSTEM/safedata/oracle/data/uprr/system01.dbf 40508.301.00106061.67
UNDOTBS1/safedata/oracle/data/uprr/undotbs01.dbf 26202.601.00180080.00
UNDOTBS1/safedata/oracle/data/uprr/undotbs02.dbf 6909.711.0059000.00
UPRR_DATA/safedata/oracle/data/uprr/UPRR_DATA_0001.DBF 22010.453.9185000.00
WORK/safedata/oracle/data/uprr/WORK_0001.DBF 5107.061.0071000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D689,95510036,522,406150,0064,1730014

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00104,0420

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0133672253742533177607425   
E0135456822636633177606366   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D5440.10671.1531,578,969113513994.00
D1,0880.191341.0228,116,71214748686.00
D1,6320.292011.0227,958,89014349135.00
D2,1760.392681.0127,857,10314091442.00
D2,7200.483351.0127,782,25313901940.00
D3,2640.584021.0127,722,54313750781.00
D3,8080.684691.0027,668,06313612853.00
D4,3520.775361.0027,620,73913493046.00
D4,8960.876031.0027,583,88913399755.00
D5,4400.976701.0027,554,05613324227.00
D5,6321.006941.0027,543,82213298318.00
D5,9841.067381.0027,525,05913250809.00
D6,5281.168051.0027,499,53513186195.00
D7,0721.268721.0027,473,90113121296.00
D7,6161.359391.0027,450,11813061089.00
D8,1601.451,0061.0027,431,45313013835.00
D8,7041.551,0731.0027,414,60112971174.00
D9,2481.641,1400.9927,396,87412926293.00
D9,7921.741,2070.9927,366,18712848598.00
D10,3361.841,2740.9927,207,30012446356.00
D10,8801.931,3410.9325,656,35011475348.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.004,3260

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K537,014537,01400
64K128K36436400
128K256K13813800
256K512K19319300
512K1024K1,6091,60900
1M2M1,1841,18400
2M4M101000
4M8M9900
8M16M5500
16M32M141400

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc CountEstd Time
4480.139,008,217.21511,757.4695.00903,150,273,830
8960.259,008,217.21265,005.5097.0003,068,620,647
1,7920.509,008,217.21249,813.6197.0003,063,593,467
2,6880.759,008,217.21249,813.6197.0003,063,593,467
3,5841.009,008,217.21239,654.1797.0003,060,231,588
4,3011.209,008,217.21210,798.0298.0003,050,682,740
5,0181.409,008,217.21210,798.0298.0003,050,682,740
5,7341.609,008,217.21210,798.0298.0003,050,682,740
6,4511.809,008,217.21210,798.0298.0003,050,682,740
7,1682.009,008,217.21210,798.0298.0003,050,682,740
10,7523.009,008,217.21210,798.0298.0003,050,682,740
14,3364.009,008,217.21210,798.0298.0003,050,682,740
21,5046.009,008,217.21210,798.0298.0003,050,682,740
28,6728.009,008,217.21210,798.0298.0003,050,682,740

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
7680.89633,2849,909,0071.00227,1771.22640,673
8000.93954,5859,933,2041.00202,9801.09642,977
8320.961265,9559,943,1741.00193,0101.03643,986
8641.001567,1829,949,3701.00186,8141.00644,567
8961.041888,4799,951,3021.00184,8820.99644,750
9281.072209,8499,951,9701.00184,2140.99644,821
9601.1125111,5159,952,6131.00183,5710.98644,893
9921.1528212,8809,953,2441.00182,9400.98644,971
1,0241.1931414,0069,953,8471.00182,3370.98645,048
1,0561.2234614,8989,954,5071.00181,6770.97645,135
1,0881.2637816,2389,955,1841.00181,0000.97645,227
1,1201.3041017,5159,955,8391.00180,3450.97645,315
1,1521.3344218,4439,956,4911.00179,6930.96645,397
1,2481.4453821,8769,958,3681.00177,8160.95645,630
1,3441.5663325,3039,960,3621.00175,8220.94645,890
1,4401.6772928,7469,962,3121.00173,8720.93646,128
1,5361.7882533,1289,964,0761.00172,1080.92646,326
1,6321.8992136,8219,965,5681.00170,6160.91646,511
1,7282.001,01639,6969,967,0381.00169,1460.91646,675

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,6640.2518,305,20031,601,026,565
2,4960.389,136,60327,979,014,020
3,3280.508,831,06327,877,101,880
4,1600.638,492,73027,742,137,154
4,9920.758,348,75827,687,049,511
5,8240.888,137,60027,601,663,663
6,6561.007,998,42727,543,821,638
7,4881.137,920,04227,519,032,199
8,3201.257,798,46827,469,453,320
9,1521.387,744,87927,450,172,644
9,9841.507,660,09527,414,365,676
10,8161.637,181,78927,227,067,689
11,6481.756,200,38225,673,596,149
12,4801.886,189,98425,673,596,149
13,3122.006,189,98425,673,596,149

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
321.000000
642.000000
963.000000
1284.000000
1605.000000
1926.000000
2247.000000
2568.000000
2889.000000
32010.000000
35211.000000
38412.000000
41613.000000
44814.000000
48015.000000
51216.000000
54417.000000
57618.000000
60819.000000
64020.000000

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

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block602
undo header800

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction 2,1172,117056112,130.00
RO-Multiple Object Reuse (fast object reuse) 202001030.00
HW-Segment High Water Mark 1,0021,0020100.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
20.591,9011,2964180/1800/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
24-Apr 15:51643711,29641800/00/0/0/0/0/0
24-Apr 15:4110620243831800/00/0/0/0/0/0
24-Apr 15:311145121,04241800/00/0/0/0/0/0
24-Apr 15:216133444131800/00/0/0/0/0/0
24-Apr 15:11571361,04441800/00/0/0/0/0/0
24-Apr 15:0119134649241800/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch10.00 00 
ASM db client latch2,8610.00 00 
ASM map operation hash table10.00 00 
ASM network state latch620.00 00 
AWR Alerted Metric Element list31,6750.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA2,1820.00 00 
DML lock allocation3,583,1460.00 00 
Event Group Locks1330.00 00 
FAL Queue960.00 00 
FIB s.o chain latch58,0170.00 00 
FOB s.o list latch58,8580.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch7,2290.00 01,5930.00
JS Sh mem access10.00 00 
JS queue access latch10.00 00 
JS slv state obj latch10.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch1,2000.00 00 
KTF sga latch240.00 09240.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status20.00 00 
KWQS pqueue ctx latch20.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch10.00 01,2000.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch400.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process3150.00 00 
OS process allocation7,3700.00 00 
OS process: request allocation1120.00 00 
PL/SQL warning settings6590.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch17,4360.00 00 
SGA IO buffer pool latch10.00 010.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,1960.00
SQL memory manager workarea list latch104,4760.00 00 
Shared B-Tree1350.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP2,7620.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch29,9554.220.0000 
active service list1,9550.100.0009,7400.00
archive control600.00 00 
archive process latch2880.00 00 
begin backup scn array210.00 00 
buffer pool10.00 00 
business card10.00 00 
cache buffer handles10,0540.600.0000 
cache buffers chains71,070,4980.010.000669,4080.00
cache buffers lru chain8,7500.00 05,512,9310.00
cache table scan latch2,0520.00 02,0520.00
call allocation8380.840.8600 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch7870.381.0000 
channel operations parent latch23,5660.00 00 
checkpoint queue latch431,8740.000.0004,3350.00
client/application info3460.00 00 
compile environment latch660.00 00 
corrupted undo seg latch1,3490.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch620.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch620.00 00 
dml lock allocation620.00 00 
done queue latch10.00 00 
dummy allocation1132.651.0000 
enqueue freelist latch10.00 016,7590.00
enqueue hash chains28,5980.00 0210.00
fifth spare latch10.00 00 
file cache latch5060.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA430.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch6840.00 0502,8000.00
hash table modification latch1630.00 00 
heartbeat check10.00 00 
internal temp table object number allocation latch30.00 00 
interrupt manipulation50.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch160.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock450.00 00 
ksuosstats global area3630.00 00 
ksv allocation latch1490.00 00 
ksv class latch870.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch1120.00 00 
ktm global data7430.00 00 
kwqbsn:qsga1310.00 00 
lgwr LWN SCN2,7060.00 00 
list of block allocation3310.00 00 
loader state object freelist560.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer work area10.00 00 
longop free list parent30.00 010.00
managed standby latch960.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch2,0640.00 00 
messages98,5848.700.0000 
mostly latch-free SCN2,7110.00 00 
msg queue latch10.00 00 
multiblock read objects8,6440.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch620.00 00 
object queue header heap9560.00 0840.00
object queue header operation341,3390.000.0000 
object stats modification640.00 00 
parallel query alloc buffer4810.00 00 
parallel query stats10.00 00 
parameter list2590.00 00 
parameter table management4690.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue4,0680.270.0003,3160.21
process allocation1340.751.000660.00
process group creation1120.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch7830.00 00 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
readredo stats and histogram8600.00 00 
recovery domain hash list10.00 00 
redo allocation10,7800.090.00023,8460.02
redo copy10.00 023,8480.72
redo writing39,0632.530.0000 
resmgr group change latch450.00 00 
resmgr:active threads1130.00 00 
resmgr:actses change group670.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list1121.790.0000 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects1,459,3770.010.0105,2180.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
second spare latch10.00 00 
sequence cache1,3590.220.0000 
session allocation4,2880.00 04,2390.00
session idle bit156,2990.000.0000 
session queue latch10.00 00 
session state list latch1760.00 00 
session switching1070.00 080.00
session timer1,2040.00 00 
shared pool206,6440.030.0000 
shared pool sim alloc10.00 00 
shared pool simulator9,6090.00 00 
sim partition latch10.00 00 
simulator hash latch3,340,6870.000.0000 
simulator lru latch1,6800.00 02,724,9010.01
sort extent pool4410.00 00 
space background state object latch130.00 00 
space background task latch5,4370.850.0202,4150.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation30.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch2620.00 00 
transaction allocation897,3130.00 00 
undo global data12,2860.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
messages98,5848,578328,547
cache buffers chains71,070,4983,55413,554
row cache objects1,459,3771711170
space background task latch5,43746145
call allocation838761
channel handle pool latch787330
dummy allocation113330
process allocation134110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chainskcbgtcr_2040
cache buffers chainskcbgtcr: fast path026
cache buffers chainskcbgcur_2010
cache buffers chainskcbgtcr: fast path (cr pin)010
cache buffers chainskcbrls: fast release012
call allocationksuxds053
call allocationksudlp: top call013
channel handle pool latchksrchconnect()033
dummy allocationktcscnfy033
messagesksaamb: after wakeup01715
messagesksarcv01517
process allocationksucrp:1010
row cache objectskqreqd: reget010
space background task latchktsj_grab_task011

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn2 10650
Library Cachekglpin1 430
Library Cachekglpndl1 9530
Library Cachekgllkdl1 8520
Library Cachekglhdgn1 6210
Library Cachekgllkc1 5710

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
DATACOREDATACOREDA_MID_CUST_STATUS TABLE14,914,08040.83
DATACOREDATACOREDF_CUSTOMER_PROFILE TABLE4,113,13611.26
DATACOREDATACORED_JOB_LOG_CHECK TABLE3,541,3929.70
UPRRUPRR_DATAU_AUTH_SYSTEM_ADMIN TABLE3,126,7048.56
DATACOREDATACOREDM_ACMOV_DATA_MERGER TABLE2,533,9526.94

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
DATACOREDATACOREDF_CUSTOMER_PROFILE TABLE134,42889.22
DATACOREDATACOREDF_BOPI_TBL_RAINFO TABLE5,5613.69
DATACOREDATACOREDA_MID_CUST_STATUS TABLE4,5012.99
DATACOREDATACOREDA_MEND_RISK_RECON_FX TABLE1,5091.00
DATACOREDATACOREDA_MID_RISK_RECON_CYRSTAL TABLE6250.41

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
DATACOREDATACOREDA_MID_CUST_STATUS TABLE2,94946.74
DATACOREDATACOREDF_CUSTOMER_PROFILE TABLE1,09717.39
DATACOREDATACOREDF_BOPI_TBL_RAINFO TABLE701.11
SYSSYSAUXWRH$_SQL_PLAN TABLE580.92
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX450.71

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
DATACOREDATACOREDA_MID_CUST_STATUS TABLE2,94946.74
DATACOREDATACOREDF_CUSTOMER_PROFILE TABLE1,09717.39
DATACOREDATACOREDF_BOPI_TBL_RAINFO TABLE701.11
SYSSYSAUXWRH$_SQL_PLAN TABLE580.92
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX450.71

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
DATACOREDATACOREDF_BOPI_TBL_CODECUSTOMER TABLE99623.59
DATACOREDATACOREDF_BOPI_TBL_RAINFO TABLE1804.26
DATACOREDATACOREDF_BOPI_TBL_ORINFO TABLE1002.37
DATACOREDATACOREDF_BOPI_TBL_DRINFO TABLE691.63
DATACOREDATACOREINDEX_TBL_ORINFO INDEX551.30

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
DATACOREDATACOREDF_BOPI_TBL_CODECUSTOMER TABLE673.95
SYSSYSAUXWRH$_SQL_PLAN TABLE382.24
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB311.83
UPRRUPRR_DATAU_BASE_USER TABLE301.77
UPRRUPRR_DATAU_BASE_SYS_LOG TABLE191.12

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1058789863_19899TABLE PARTITION2959.18
SYSSYSAUXSYS_LOB0000006198C00038$$ LOB2040.82

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX73461.32
DATACOREDATACOREDA_MID_CUST_STATUS TABLE27923.31
DATACOREDATACOREDF_CUSTOMER_PROFILE TABLE342.84
METABASEMETABASEPK_REPORT_ID INDEX10.08

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
DATACOREDATACOREDF_BOPI_TBL_CODECUSTOMER TABLE4,65648.02
SYSSYSAUXWRH$_SQL_PLAN TABLE9609.90
DATACOREDATACOREDF_BOPI_TBL_RAINFO TABLE7367.59
SYSSYSAUXWRH$_SQL_PLAN_PK INDEX6086.27
REPORTREPORTSF015D TABLE4164.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYSSYSAUXWRM$_SNAPSHOT_DETAILS_INDEX INDEX1100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMAUD$ TABLE466.67
SYSSYSTEMSEG$ TABLE233.33

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_global_oids550.000 032
dc_histogram_data167,4250.550 05,098
dc_histogram_defs77,5391.900 04,320
dc_object_grants1910.530 09
dc_objects31,7630.740 11,443
dc_profiles860.000 02
dc_rollback_segments2,2660.000 042
dc_segments23,0742.550 29747
dc_sequences5022.000 5012
dc_tablespaces138,9600.000 017
dc_users154,2520.000 062
global database name2,4610.000 01
outstanding_alerts840.000 014


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS862.330 00
BODY836.026441.2410
CLUSTER730.00730.0000
DBLINK890.000 00
EDITION590.001020.0000
INDEX2347.832347.8300
JAVA DATA4100.004100.0000
JAVA RESOURCE580.00580.0000
JAVA SOURCE580.00580.0000
SCHEMA2720.370 00
SQL AREA9,26620.54134,2275.073017
SQL AREA BUILD2,42188.190 00
SQL AREA STATS2,37496.042,37496.0400
TABLE/PROCEDURE8,8491.5532,4183.335480
TRIGGER4119.512574.6740


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache5,600.005,600.004,768.005,728.000SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target3,584.003,584.003,584.004,288.000SHR/MAN
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target6,656.006,656.005,952.006,656.000GRO/DEF
Shared IO Pool0.000.000.000.000STA/
java pool32.0032.0032.0032.000STA/
large pool32.0032.000.0032.000GRO/IMM
shared pool864.00864.00768.001,024.000GRO/IMM
streams pool32.0032.000.0064.000SHR/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

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther431.83 4.157.516161104104
Freeable247.500.003.024.3415 8282
SQL3.030.230.040.0302327367
PL/SQL2.481.470.020.0500102102
EOther456.53 3.686.966161124124
Freeable271.880.002.994.4217 9191
SQL3.190.410.030.0302329286
PL/SQL2.991.850.020.0500122122

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers5,872,025,600 
Fixed Size2,245,480 
Redo Buffers21,708,800 
Variable Size11,207,183,512 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory32.0032.000.00
largePX msg pool7.817.810.00
largefree memory24.1924.190.00
sharedASH buffers32.0032.000.00
sharedKGH: NO ACCESS159.56159.560.00
sharedKGLH083.1185.022.30
sharedKGLHD19.3219.370.25
sharedSQLA119.67118.47-1.01
shareddb_block_hash_buckets44.5044.500.00
shareddbktb: trace buffer12.5012.500.00
shareddbwriter coalesce buffer64.0664.060.00
sharedevent statistics per sess15.3815.380.00
sharedfree memory246.44242.55-1.58
sharedksunfy : SSO free list14.3314.330.00
sharedprivate strands17.5317.530.00
sharedwrite state object14.6414.640.00
streamsfree memory32.0032.000.00
 buffer_cache5,600.005,600.000.00
 fixed_sga2.142.140.00
 log_buffer20.7020.700.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0719 18:31:450.000.000.00
QMON Coordinator0719 18:31:350.000.000.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,6020.00100.000.000.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,6020.00100.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/admin/uprr/adump  
audit_trailDB  
control_file_record_keep_time30  
control_files/safedata/oracle/data/uprr/control01.ctl, /oracle/admin/uprr/cfile/uprr/control02.ctl, /safedata/oracle/flash_recovery_area/uprr/control03.ctl  
core_dump_dest/oracle/admin/uprr/cdump  
db_block_size8192  
db_domain    
db_nameuprr  
db_recovery_file_dest/safedata/oracle/flash_recovery_area  
db_recovery_file_dest_size536870912000  
db_unique_nameuprr  
db_writer_processes16  
deferred_segment_creationFALSE  
diagnostic_dest/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=uprrXDB)  
event    
global_namesTRUE  
job_queue_processes10  
log_archive_dest_1LOCATION=/safedata/oracle/arch  
log_archive_format%t_%s_%r.dbf  
memory_max_target17179869184  
memory_target10737418240  
open_cursors1500  
os_authent_prefix    
processes800  
remote_login_passwordfileNONE  
sessions1232  
undo_managementAUTO  
undo_retention10800  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/oracle/admin/uprr/cfile/uprr/control02.ctl  
/safedata/oracle/data/uprr/control01.ctl  
/safedata/oracle/flash_recovery_area/uprr/control03.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