WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORCL114045645851orcl112214-Apr-13 00:0411.1.0.7.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
wo-db-2-prLinux x86 64-bit 24 12 2 62.80

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:579810-Jul-13 07:00:3890 2.0
End Snap:580010-Jul-13 09:00:4982 2.2
Elapsed:  120.18 (mins)  
DB Time:  84.96 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,056M 5,056MStd Block Size: 8K
Shared Pool Size: 2,864M 2,864MLog Buffer: 10,444K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.7 0.6 0.01 0.05
DB CPU(s): 0.1 0.1 0.00 0.01
Redo size: 47,242.4 39,220.3  
Logical reads: 18,766.2 15,579.6  
Block changes: 258.6 214.7  
Physical reads: 0.9 0.7  
Physical writes: 4.7 3.9  
User calls: 15.5 12.9  
Parses: 11.9 9.9  
Hard parses: 0.1 0.1  
W/A MB processed: 209,944.7 174,294.6  
Logons: 0.3 0.2  
Executes: 47.9 39.7  
Rollbacks: 0.3 0.3  
Transactions: 1.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 99.56Soft Parse %: 99.15
Execute to Parse %: 75.22Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 0.00% Non-Parse CPU: 99.72

Shared Pool Statistics

BeginEnd
Memory Usage %: 77.51 77.57
% SQL with executions>1: 93.96 98.70
% Memory for SQL w/exec>1: 94.83 95.27

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
SQL*Net message from dblink20,2301,5917931.21Network
DB CPU 718 14.08 
SQL*Net more data from dblink6,8685237610.27Network
gc cr multi block request8,7625971.15Cluster
db file sequential read1,770950.18User I/O

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

Load Average BeginLoad Average End%User%System%WIO%Idle
0.25 0.52 0.9 0.1 0.2 99.0
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.4 41.7 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 64,305.1 64,305.1
SGA use (MB): 8,000.0 8,000.0
PGA use (MB): 491.3 504.6
% Host Mem used for SGA+PGA: 13.20 13.20

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 4.24 3.52
Global Cache blocks served: 1.21 1.00
GCS/GES messages received: 7.13 5.92
GCS/GES messages sent: 10.38 8.62
DBWR Fusion writes: 0.03 0.02
Estd Interconnect traffic (KB) 46.98 

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.4
Avg global cache current block receive time (ms): 0.8
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.2
Avg global cache cr block flush time (ms): 0.9
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.3
Avg global cache current block flush time (ms): 6.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 891.1
Avg message sent queue time on ksxp (ms): 0.7
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 69.05
% of indirect sent messages: 27.54
% of flow controlled messages: 3.41


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
eth1192.168.1.4NOracle Cluster Repository   

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time5,089.8799.85
DB CPU717.7714.08
sequence load elapsed time20.510.40
parse time elapsed7.910.16
PL/SQL execution elapsed time5.320.10
hard parse elapsed time3.320.07
hard parse (sharing criteria) elapsed time1.480.03
hard parse (bind mismatch) elapsed time0.600.01
connection management call elapsed time0.420.01
failed parse elapsed time0.250.00
repeated bind elapsed time0.070.00
PL/SQL compilation elapsed time0.010.00
DB time5,097.35 
background elapsed time108.08 
background cpu time22.86 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME177,416 
IDLE_TIME17,127,527 
IOWAIT_TIME35,895 
NICE_TIME55 
SYS_TIME25,896 
USER_TIME147,860 
LOAD01
PHYSICAL_MEMORY_BYTES67,428,761,600 
NUM_CPUS24 
NUM_CPU_CORES12 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX262,144 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
10-Jul 07:00:380.25     
10-Jul 08:00:140.571.221.040.150.2798.78
10-Jul 09:00:490.520.840.670.150.1499.16

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Network122,78502,1141741.47
DB CPU  718 14.08
Cluster21,92806131.21
Other64,942821100.21
User I/O1,84101160.21
Concurrency48,4650200.05
System I/O5,0330200.04
Configuration2281020.01
Application1,5440000.01
Commit590020.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
SQL*Net message from dblink20,23001,591792.3331.21
SQL*Net more data from dblink6,8680523760.7910.27
gc cr multi block request8,76205971.011.15
db file sequential read1,7700950.200.18
reliable message2,9780620.340.12
PX Deq: Slave Session Stats4,56830200.530.04
control file sequential read5,0330200.580.04
gc current block 2-way9,4320201.090.04
row cache lock48,0360205.530.03
db file parallel read1801500.000.02
name-service call wait801990.000.02
IPC send completion sync7,16482100.820.01
os thread startup5011180.000.01
db file scattered read2101270.000.01
enq: PS - contention2,21734000.260.01
DFS lock handle1235030.010.01
SQL*Net break/reset to client1,5320000.180.01
gc current grant busy1,5270000.180.01
PX Deq: reap credit44,759100005.150.01
undo segment extension210001010.000.00
log file switch completion400310.000.00
gc cr block 2-way4560000.050.00
log file sync590020.010.00
gc current multi block request1,0670000.120.00
PX Deq Credit: Session Stats1,3560000.160.00
direct path read250030.000.00
gc current grant 2-way5910000.070.00
SQL*Net message to client75,0540008.640.00
library cache pin2650000.030.00
gc cr block busy270010.000.00
enq: HW - contention2220000.030.00
enq: FB - contention2010000.020.00
PX Deq: Signal ACK RSG1,25755000.140.00
library cache lock1560000.020.00
local write wait70030.000.00
SQL*Net message to dblink20,2300002.330.00
enq: RO - fast object reuse40030.000.00
PX Deq: Signal ACK EXT1470000.020.00
gc cr grant 2-way640000.010.00
SQL*Net more data from client2080000.020.00
rdbms ipc reply580000.010.00
enq: JQ - contention8100000.000.00
SQL*Net more data to client1940000.020.00
enq: UL - contention667000.000.00
SQL*Net message from client75,0620309,32741218.64 
jobq slave wait1,677974,97529660.19 
Streams AQ: waiting for messages in the queue822877208760.09 
PX Deq: Execution Msg7,374201520.85 
PX Deq Credit: send blkd4,60246100.53 
PX Deq: Join ACK1,3250000.15 
PX Deq: Parse Reply2,08934000.24 
PX Deq: Msg Fragment2,3469000.27 
PX Deq: Execute Reply1,91218000.22 
single-task message300220.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
gc cr multi block request1,526131200.1828.65
control file sequential read20,93601712.4115.42
db file parallel write5,0300710.586.51
log file parallel write6,8610710.796.21
os thread startup19104200.023.50
log file sequential read3900490.043.39
control file parallel write2,7010210.311.66
ksxr poll remote instances154,8211001017.820.56
db file sequential read1170150.010.54
ges inquiry response2,5540100.290.51
name-service call wait500980.000.45
ASM file metadata operation1,7370000.200.41
reliable message810050.010.36
CGS wait for IPC msg63,807100007.350.29
db file parallel read1200250.000.28
gc cr block 2-way9710000.110.20
PX Deq: Slave Join Frag2,18334000.250.16
gc current block 2-way6640000.080.14
Log archive I/O3840000.040.10
rdbms ipc reply2700000.030.07
DFS lock handle41257000.050.06
enq: CF - contention24898000.030.05
PX Deq: reap credit8,900100001.020.05
gcs log flush sync360010.000.04
gc current block busy300120.000.03
db file scattered read40090.000.03
row cache lock1210000.010.02
gc current grant busy1660000.020.02
log file sync50030.000.02
enq: PS - contention5050000.010.01
gc cr block busy30040.000.01
log file single write40030.000.01
library cache pin620000.010.01
enq: US - contention630000.010.01
direct path read330000.000.01
PX Deq: Slave Session Stats11643000.010.00
direct path write340000.000.00
library cache lock2520000.000.00
enq: WF - contention230000.000.00
IPC send completion sync7269000.010.00
enq: TA - contention220000.000.00
SQL*Net more data from client30010.000.00
enq: TD - KTF dump entries140000.000.00
gc current multi block request200000.000.00
enq: TT - contention12100000.000.00
wait for scn ack130000.000.00
LGWR wait for redo copy570000.010.00
gc cr grant 2-way100000.000.00
gc current grant 2-way120000.000.00
PX Deq: Signal ACK RSG4852000.010.00
enq: JQ - contention1100010.000.00
rdbms ipc message288,98539172,95259833.27 
wait for unread message on broadcast channel14,40810014,42310011.66 
gcs remote message356,5389614,4184041.05 
DIAG idle wait224,6389414,4076425.86 
PX Idle Wait4,374669,20321040.50 
PING2,725217,21426470.31 
ASM background timer1,62507,21044370.19 
Space Manager: slave idle wait1,4421007,21050000.17 
ges remote message103,662787,2097011.93 
pmon timer2,503967,20628790.29 
shared server idle wait2401007,201300030.03 
dispatcher timer1201007,200600010.01 
fbar timer241007,2003000040.00 
Streams AQ: qmn slave idle wait25007,189287550.03 
Streams AQ: qmn coordinator idle wait500507,189143780.06 
smon timer26857,0062694650.00 
class slave wait2657660722910.03 
SQL*Net message from client4450110.05 
KSV master wait4,36499000.50 
PX Deq: Join ACK310000.00 
PX Deq Credit: send blkd9653000.01 
PX Deq: Parse Reply6141000.01 
PX Deq: Execute Reply4129000.00 
Streams AQ: RAC qmn coordinator idle wait506100000.06 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ARCH wait for archivelog lock2100.0       
ASM file metadata operation173799.4.2.1   .2 
CGS wait for IPC msg63K100.0       
DFS lock handle53598.7.4    .9 
IPC send completion sync723699.9.1.1.0    
KJC: Wait for msg sends to complete25100.0       
LGWR wait for redo copy57100.0       
Log archive I/O38499.5   .3 .3 
PX Deq Credit: Session Stats1356100.0       
PX Deq: Signal ACK EXT15899.4 .6     
PX Deq: Signal ACK RSG1305100.0       
PX Deq: Slave Join Frag2183100.0       
PX Deq: Slave Session Stats468499.9.1.0    .0
PX Deq: reap credit53K100.0       
PX qref latch16100.0       
SQL*Net break/reset to client153296.91.2.2.51.1   
SQL*Net message from dblink20K66.4.52.7.225.23.01.7.4
SQL*Net message to client75K100.0       
SQL*Net message to dblink20K100.0       
SQL*Net more data from client21199.5.5      
SQL*Net more data from dblink686885.2.4.7.95.7.92.63.5
SQL*Net more data to client197100.0       
SQL*Net more data to dblink1100.0       
buffer busy waits2100.0       
control file parallel write270297.5.5.5.5.9.1  
control file sequential read25K93.2.6.44.31.4.0.0 
cr request retry48100.0       
db file parallel read30    6.740.053.3 
db file parallel write503066.423.91.24.73.4.4.1 
db file scattered read258.0  8.020.032.032.0 
db file sequential read189441.91.55.722.725.03.1.1 
direct path read5887.9  6.93.41.7  
direct path write3497.1 2.9     
enq: AF - task serialization2100.0       
enq: CF - contention24898.8.8.4     
enq: DR - contention4100.0       
enq: FB - contention204100.0       
enq: HW - contention222100.0       
enq: JQ - contention988.911.1      
enq: JS - job run lock - synchronize2100.0       
enq: PS - contention226799.7.2.0     
enq: RO - fast object reuse666.7  33.3    
enq: TA - contention22100.0       
enq: TD - KTF dump entries14100.0       
enq: TM - contention3100.0       
enq: TO - contention2100.0       
enq: TT - contention15100.0       
enq: UL - contention6100.0       
enq: US - contention63100.0       
enq: WF - contention23100.0       
enq: WL - contention1100.0       
gc buffer busy acquire2100.0       
gc cr block 2-way141799.9 .1     
gc cr block busy3080.06.73.33.36.7   
gc cr grant 2-way74100.0       
gc cr multi block request10K99.0.0.0 .0.1.3.5
gc current block 2-way10K100.0.0.0     
gc current block busy333.3   33.333.3  
gc current grant 2-way609100.0       
gc current grant busy167799.9     .1 
gc current multi block request1087100.0       
gcs log flush sync3378.815.2 6.1    
ges inquiry response255799.6.2.2     
ksxr poll remote instances154K100.0       
latch: cache buffers chains2100.0       
latch: gc element6100.0       
latch: ges resource hash list1100.0       
latch: session allocation1100.0       
latch: shared pool1100.0       
library cache lock18199.4.6      
library cache pin327100.0       
library cache: mutex X5100.0       
local write wait742.928.6  28.6   
log file parallel write685989.41.92.92.82.7.3.1 
log file sequential read3901.5.533.319.532.111.51.5 
log file single write450.0  50.0    
log file switch completion4  25.025.0  50.0 
log file sync6478.11.63.17.89.4   
name-service call wait13     7.792.3 
os thread startup196    6.191.32.6 
rdbms ipc reply32898.2.6 .6.6   
reliable message305999.5.1.1   .3 
row cache lock48K100.0.0.0     
undo segment extension2      100.0 
wait for scn ack13100.0       
ASM background timer16254.1.6.1 .63.22.089.4
DIAG idle wait224K3.4.2.3.3.546.848.5 
KSV master wait436499.8.1.0   .1 
PING272578.8 .1    21.2
PX Deq Credit: send blkd4698100.0       
PX Deq: Execute Reply1953100.0       
PX Deq: Execution Msg737481.617.6.2.1.3 .1.1
PX Deq: Join ACK135699.6.4      
PX Deq: Msg Fragment2346100.0 .0     
PX Deq: Parse Reply215099.8.0.2     
PX Idle Wait4374.1.0.3.7.4.713.883.9
SQL*Net message from client75K84.22.2.6.2.2.28.63.8
Space Manager: slave idle wait1443       100.0
Streams AQ: RAC qmn coordinator idle wait506100.0       
Streams AQ: qmn coordinator idle wait50050.0      50.0
Streams AQ: qmn slave idle wait250       100.0
Streams AQ: waiting for messages in the queue822 .1  .5.698.8 
class slave wait26521.1.4.4 .8 .876.6
dispatcher timer120       100.0
fbar timer24       100.0
gcs remote message356K2.3.3.3.4.5.895.5 
ges remote message103K11.11.61.6.71.12.081.8 
jobq slave wait1677      .699.4
pmon timer25044.0      96.0
rdbms ipc message288K55.5.6.2.2.4.427.714.9
shared server idle wait240       100.0
single-task message3     100.0  
smon timer26      3.896.2
wait for unread message on broadcast channel14K      100.0 

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS4,741363549,686
orcl11356354085,441
SYS$BACKGROUND001197
orcl11XDB0000

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 17801048209200510442114
orcl11 610256000717410
SYS$BACKGROUND 200140640000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
2,35517312354.8046.203d844nhux431y   DECLARE job BINARY_INTEGER := ...
32601325.636.398c21hbhf1t608 PL/SQL Developer SELECT A.M2PNO, A.INS_CODE SO...
3213213,2680.106.29cbasm16fcz3c3   select * from mm_policy_ti whe...
30201301.585.922wrf9q66bhg88   SELECT /*+ driving_site(a) */ ...
27200 5.34g8rhn3v9syy8s   SELECT /*+ driving_site(a) */I...
20001200.063.927bn2adzszradf PL/SQL Developer SELECT A.ACPNO, A.INS_CODE SO...
17201171.823.37gcu0c1chf0k24   SELECT A.DCPNO, A.INS_CODE SO...
15002950.512.94buwgykca9c3hn PL/SQL Developer SELECT TRIM(MAX(USOCL)) FROM (...
12901129.232.5434zauv6342qp6   SELECT /*+ driving_site(a) */A...
12351122.792.4170png2sdd4c2y PL/SQL Developer INSERT INTO RLS_TEMP_LFPPML( I...
705169.671.37f64xbv6132vpj   INSERT INTO RLS_TEMP_LFPAPPL (...
67114,0820.001.31a34r71rnhycqh   SELECT SEQ_VOUCHER.NEXTVAL FRO...
620162.251.226mq1v48177hdu   SELECT /*+ driving_site(a) */ ...
560156.081.10ack02xpwc7z1b PL/SQL Developer SELECT A.ACPNO, B.INS_CODE SO...
5415,3680.011.072cx2pgddzwdsd PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
3213213,2680.1044.706.29cbasm16fcz3c3   select * from mm_policy_ti whe...
1732,3551173.4824.1746.203d844nhux431y   DECLARE job BINARY_INTEGER := ...
45153,3300.016.200.29bszs56at7vx1b PL/SQL Developer UPDATE BFP_VOUCHERDETAIL_TD SE...
18310,7520.002.550.0531n26us0tmayx PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
18171100.162.440.34fasad8pywykdm   INSERT INTO BFP_TMP_MIRRORDETA...
16410,7520.002.250.0977fbpzq5a3jyj PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
10132200.051.400.25c0xy1zgazyym8   INSERT INTO BFP_MIRRORDETAIL_T...
710200.361.010.19gvw5y39ru38su   DECLARE job BINARY_INTEGER := ...
76880.080.990.129qhrn5fx6h095 PL/SQL Developer INSERT INTO BFP_TMP_MIRRORDETA...
761,2780.010.980.123xgw35tqxsmvb PL/SQL Developer SELECT MAX(A.CONTRACTTYPE) FRO...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
83,011,2033,26825,401.2261.34320.83320.51cbasm16fcz3c3   select * from mm_policy_ti whe...
49,099,962149,099,962.0036.28173.482354.803d844nhux431y   DECLARE job BINARY_INTEGER := ...
18,378,6133,3305,519.1013.5844.5114.73bszs56at7vx1b PL/SQL Developer UPDATE BFP_VOUCHERDETAIL_TD SE...
17,282,873110157,117.0312.7717.5317.43fasad8pywykdm   INSERT INTO BFP_TMP_MIRRORDETA...
4,021,24810,752374.002.9718.312.5631n26us0tmayx PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
4,021,24810,752374.002.9716.144.4577fbpzq5a3jyj PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
855,1812929,489.000.632.552.33g0thukcaqz0r2   select mmlegaldat_.id, mmlega...
701,1451701,145.000.524.5469.67f64xbv6132vpj   INSERT INTO RLS_TEMP_LFPAPPL (...
651,6231651,623.000.485.44122.7970png2sdd4c2y PL/SQL Developer INSERT INTO RLS_TEMP_LFPPML( I...
616,180996,224.040.464.564.38buxhp761775fs PL/SQL Developer INSERT INTO BFP_MIRRORDETAIL_T...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
4,55014,550.0072.53173.482354.803d844nhux431y   DECLARE job BINARY_INTEGER := ...
2,03512,035.0032.440.2736.89f4r1rrdkxdnaz PL/SQL Developer INSERT INTO BFP_TEMP_BUSINESS ...
1,30811,308.0020.850.1831.57ajymgnp1qnruw   select o.name, o.owner# from ...
4751143.187.570.159.58fux2zdk7hjjhf PL/SQL Developer UPDATE BFP_VOUCHER_TO V SET V....
3395,3760.065.400.813.25fc1ct948abkwr PL/SQL Developer INSERT INTO BFP_POLICY_TD (SEQ...
2932014.654.677.289.80gvw5y39ru38su   DECLARE job BINARY_INTEGER := ...
2712201.234.3210.0812.56c0xy1zgazyym8   INSERT INTO BFP_MIRRORDETAIL_T...
2481248.003.950.056.01b7w2w7mhjk05u PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...
23110,7520.023.6816.144.4577fbpzq5a3jyj PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
935,3680.021.480.8754.302cx2pgddzwdsd PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
47,75547,7551.000.000.004m7m0t6fjcs5x   update seq$ set increment$=:2,...
14,08214,0821.000.000.00a34r71rnhycqh   SELECT SEQ_VOUCHER.NEXTVAL FRO...
13,19013,1901.000.000.007h35uxf5uhmm1   select sysdate from dual
10,75210,7521.000.000.0031n26us0tmayx PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
10,75210,7521.000.000.0077fbpzq5a3jyj PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
6,8006,8001.000.000.00cfw87jaa04qd8   select path from MM_QUERYFILE_...
5,6735,6731.000.000.01fcsr3mt7jzznq PL/SQL Developer SELECT NVL(MAX(TRIM(AGTYP)), '...
5,3765,3761.000.000.00fc1ct948abkwr PL/SQL Developer INSERT INTO BFP_POLICY_TD (SEQ...
5,3765,3761.000.000.00fkv9aynrt0sw6 PL/SQL Developer SELECT CASE WHEN EXISTS(SELECT...
5,3685,3681.000.000.012cx2pgddzwdsd PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...
5,35500.000.000.008yd6ptfvhq140   select nvl((select t.email fro...
4,2594,2591.000.000.004d68fvyqqhh90 PL/SQL Developer SELECT NVL(MAX(T.SIG), 1) SIG ...
3,53200.000.000.000g023nsr9qtjq   select * from mm_policy_ti a w...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
47,75547,75555.834m7m0t6fjcs5x   update seq$ set increment$=:2,...
13,19013,19015.427h35uxf5uhmm1   select sysdate from dual
5,3555,3556.268yd6ptfvhq140   select nvl((select t.email fro...
3,5323,5324.130g023nsr9qtjq   select * from mm_policy_ti a w...
3,2683,2683.82cbasm16fcz3c3   select * from mm_policy_ti whe...
1,4387191.687frqszzdu8sgg racgimon@wo-db-2-pr (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
7827820.910h6b2sajwb74n   select privilege#, level from ...
7667660.903972rvxu3knn3 racgimon@wo-db-2-pr (TNS V1-V3) delete from sdo_geor_ddl__tabl...
3203200.370zz0a65tg0d1a   select * from (select c.applyn...
2532530.30350f5yrnnmshs   lock table sys.mon_mods$ in ex...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,310,41530.148f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...
3,621,25020.126wm3n4d7bnddg   SELECT source, (case ...
3,577,27310.1236322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
2,859,280360.10037cq8hnwpss1   update MM_POLICY_LEGAL set amo...
2,395,345350.08fvwcc2yxafszu   update MM_POLICYLIST_LEGAL set...
2,303,030150.087ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
2,251,02440.073wr2mysfyh36n PL/SQL Developer select null from sys.all_mview...
2,206,58520.07a73024n0k9w46   update MM_PAYMENTIN_EVENTS_TD ...
2,050,00260.07803u6vwz0ah1p   select OBJOID, CLSOID, RUNT...
2,043,75720.0761tn3mam0vq0b   SELECT source, (case ...
1,848,68730.068f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...
1,514,97310.051ng6v39qb5hxg plsqldev.exe /* The name + type results o...
1,450,07310.05f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...
1,356,45410.05ack02xpwc7z1b PL/SQL Developer SELECT A.ACPNO, B.INS_CODE SO...
1,233,25530.048f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...
1,207,902700.04fsbqktj5vw6n9   select next_run_date, obj#, ...
1,088,77640.04c61yvrr104ppk   SELECT dbin.instance_number, ...
1,068,92130.047aw21806wpgzp plsqldev.exe select null from all_synonyms ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
5435fvwcc2yxafszu   update MM_POLICYLIST_LEGAL set...
49157ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
49157ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
49157ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
49157ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
4636037cq8hnwpss1   update MM_POLICY_LEGAL set amo...
44136322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
442a73024n0k9w46   update MM_PAYMENTIN_EVENTS_TD ...
404bhvyz9bgyrhb2   SELECT name, datatype, value, ...
392383m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
3440cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
334bfst4kkjb9bzn DBMS_SCHEDULER insert into sys.scheduler$_eve...
334c8gnrhxma4tas   SELECT owner#, property FROM ...
3126wm3n4d7bnddg   SELECT source, (case ...
304akh9zqqkx3wj7   select 1, max(id) from sys.wr...
294gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
2841gu8t96d0bdmu   select t.ts#, t.file#, t.block...
2841gu8t96d0bdmu   select t.ts#, t.file#, t.block...
2659tgj4g8y4rwy8   select type#, blocks, extents,...
254c61yvrr104ppk   SELECT dbin.instance_number, ...
247a73wbv1yu8x5c   select con#, type#, condlength...
247a73wbv1yu8x5c   select con#, type#, condlength...
2414bu5x9yrrd2vvu   UPDATE SYS.WRI$_ADV_PARAMETERS...
2348p409rzcjjbat   SELECT DECODE(VALUE, 'UNUSED'...
2241k5c5twx2xr01 DBMS_SCHEDULER insert into sys.scheduler$_job...
22226djmqa9kmk6z   SELECT sx.instance_number, ...
22203mvb01r7xwy14   SELECT COUNT(*) / 2000 FROM MM...
22292yv7gw4g8b94   SELECT decode(es.name, ...
2214grzx1ww6wf4q2   SELECT A.FLAGS FROM SYS.WRI$_A...
21261tn3mam0vq0b   SELECT source, (case ...
2170fsbqktj5vw6n9   select next_run_date, obj#, ...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)%Ela%TotalElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
58.402.4862.872,354.80173.4813d844nhux431y   DECLARE job BINARY_INTEGER := ...
35.8697.2138.6136.890.271f4r1rrdkxdnaz PL/SQL Developer INSERT INTO BFP_TEMP_BUSINESS ...
30.9698.0733.3431.570.181ajymgnp1qnruw   select o.name, o.owner# from ...
9.3097.0110.019.580.1511fux2zdk7hjjhf PL/SQL Developer UPDATE BFP_VOUCHER_TO V SET V....
5.8397.056.286.010.051b7w2w7mhjk05u PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...
3.4376.913.694.4516.1410,75277fbpzq5a3jyj PL/SQL Developer SELECT T.SEGMENT8_LOW, T.SEGM...
1.8752.832.013.542.1076cgrjhvx3qrvb   select mmlegaldat_.id, mmlega...
1.6295.881.741.690.021ahkzgdb62gjk8 PL/SQL Developer DELETE FROM BFP_RISKSPLIT_TD A...
0.4425.920.471.691.2229yr92fn9nr1nq   select * from ( select opcode ...
0.3013.770.322.142.012252pf5dda6qnjg PL/SQL Developer INSERT INTO BFP_TMP_MIRRORDETA...
0.2228.790.240.780.57131w9fsmunh1rx   select count (*) as count from...
0.137.780.141.660.3811063u3rctccppxb   DELETE FROM BFP_MIRRORDETAIL_T...
0.120.220.1354.300.875,3682cx2pgddzwdsd PL/SQL Developer INSERT INTO BFP_POLICY_TI (SEQ...
0.121.180.129.807.2820gvw5y39ru38su   DECLARE job BINARY_INTEGER := ...
0.100.150.1169.674.541f64xbv6132vpj   INSERT INTO RLS_TEMP_LFPAPPL (...
0.070.570.0812.5610.08220c0xy1zgazyym8   INSERT INTO BFP_MIRRORDETAIL_T...
0.051.630.063.250.815,376fc1ct948abkwr PL/SQL Developer INSERT INTO BFP_POLICY_TD (SEQ...
0.020.720.022.542.64206g8xxwfvnrh76   SELECT T.* FROM ATS_PAY_TRANSA...
0.010.290.014.384.5699buxhp761775fs PL/SQL Developer INSERT INTO BFP_MIRRORDETAIL_T...
0.0183.250.010.010.004akh9zqqkx3wj7   select 1, max(id) from sys.wr...
0.017.780.010.070.01146grwydz59pu6mc   select text from view$ where r...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
037cq8hnwpss1update MM_POLICY_LEGAL set amount=:1, bankcity=:2, bankname=:3, bankprovince=:4, batchid=:5, batchserialno=:6, bpstatus=:7, businessno=:8, businessstatus=:9, cardflag=:10, certificateno=:11, certificatetype=:12, certitype=:13, createdate=:14, currencycode=:15, custaccountname=:16, custaccountno=:17, custbankno=:18, custemail=:19, customercode=:20, customerkeyword=:21, customername=:22, datasource=:23, description=:24, errcode=:25, errmsg=:26, ifneedaudit=:27, ifpublic=:28, ifsupplement=:29, inpaymentdepartment=:30, inpaymentflag=:31, inpaymentmethod=:32, inpaymentsubcompany=:33, lastopcode=:34, lastopdate=:35, mergedseqbusiness=:36, mobilenumber=:37, opcode=:38, realamount=:39, receivedate=:40, rowversion=:41, segment1=:42, segment2=:43, seqbusiness=:44, splitedseqbusiness=:45, status=:46, summaryamount=:47, summaryno=:48, unitbankno=:49, usableno=:50 where id=:51 and rowversion=:52
0cn2wm9d7zq8dSELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0g023nsr9qtjqselect * from mm_policy_ti a where a.bpstatus = '1' and a.datasource = 'NEWGROUP' and rownum <= 20
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0zz0a65tg0d1aselect * from (select c.applyno, c.taskcode, t.tasktype, c.Param, c.sqlstr, b.opcode, (case when t.taskcode='common_download' then c.fieldname else t.fieldname end) as fieldname from mm_querycontrol_td c, mm_querytaskcode_tc t, mm_queryapply_td b where c.status = '1' and c.taskcode = t.taskcode and c.applyno = b.q_c_applyno) where rownum <= 30
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# (+)
1k5c5twx2xr01insert into sys.scheduler$_job_run_details (log_id, log_date, req_start_date, start_date, run_duration, instance_id, session_id, slave_pid, cpu_used, error#, additional_info) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, numtodsinterval(:8/100, 'second'), :9, :10)
1ng6v39qb5hxg/* The name + type results of these queries will be used by the Code Assistant if the "Describe Context" option is enabled. After typing 3 or more characters the Code Assistant will show a list of matching names. Separate multiple queries with semi-colons and use the :schema bind variable to restrict names to the currently connected user. In case of an error the query results will be omitted. No error message will be displayed. Place this file in the PL/SQL Developer installation directory for all users, or in the "%APPDATA%\PLSQL Developer" directory for a specific user. */ select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
26djmqa9kmk6z SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number
2cx2pgddzwdsdINSERT INTO BFP_POLICY_TI (SEQREPORTNO, SEQBUSINESS, BATCHID, DATASOURCE, POLICYNO, CLAIMNO, BUSINESSONE, BUSINESSTWO, CURRENCYCODE, AMOUNT, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, BUSINESSCHANNEL, AGENTCODE, AGENTNAME, OPDATE, HASPLAN, CERTITYPE, EMPLOYESTATUS, GRFLAG, PREMTYPE, RENEWALFLAG) VALUES (SEQ_DEFAULT.NEXTVAL, '', :B18 , 'RLS', :B17 , :B16 , :B15 , :B14 , 'RMB', :B13 , 'RLS', SYSDATE, SYSDATE, 'RLS', SYSDATE, '1', :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , NVL(:B5 , '1'), :B4 , :B3 , '101', :B2 , :B1 )
2wrf9q66bhg88SELECT /*+ driving_site(a) */ A.PNO, A.INS_CODE SOURCELIB, A.PCO, TRIM(B.C1PLAN) C1PLAN, A.PMODE, B.C1PREM, A.PEFF, A.PPTD FROM RLS_LFPPML@BFR A, RLS_CAPPOLPRM@BFR B WHERE A.PNO = B.C1PNO AND A.PSTU = '1' AND B.C1PREM <> 0 AND A.PEFF <> A.PPTD AND (((A.PPTD - :B1 ) * (ADD_MONTHS(TO_DATE(A.PPTD, 'yyyy-mm-dd'), 1) - :B2 ) * (ADD_MONTHS(TO_DATE(A.PPTD, 'yyyy-mm-dd'), 2) - :B2 ) = 0 AND A.PMODE = 'M') OR (A.PMODE <> 'M' AND A.PPTD = :B1 )) AND ( A.LPLAN =B.C1PLAN OR EXISTS (SELECT 1 FROM RLS_LFPRIDR@BFR WHERE PNO = B.C1PNO AND RPLAN = B.C1PLAN AND RSTU IS NULL )) AND EXISTS (SELECT 1 FROM BFP_CLASSESCODE_TC WHERE IFUL = 'N' AND CLASSESCODE = TRIM(B.C1PLAN))
31n26us0tmayxSELECT T.SEGMENT8_LOW, T.SEGMENT9_LOW, T.SEGMENT10_LOW, T.SEGMENT11_LOW, T.SEGMENT12_LOW, T.SEGMENT13_LOW, T.SEGMENT14_LOW, T.SEGMENT15_LOW, T.SEGMENT16_LOW, T.SEGMENT17_LOW FROM BFP_RULES_TD T WHERE T.BATCH_ID = '630' AND T.FLEX_VALIDATION_RULE_NAME = 'ALL_VOUCHER_TCODE' AND T.ENABLED_FLAG = 'Y' AND T.SEGMENT1_LOW = :B2 AND T.SEGMENT4_LOW = :B1
31w9fsmunh1rxselect count (*) as count from(select * from (select * from (select t.inpaymentdepartment as departmentcode, t.*, (select max(policyno) from mm_policylist_legal p where p.seqbusiness=t.seqbusiness)policyno from MM_POLICY_LEGAL t where 1=1 AND t.certitype = :1 AND t.datasource = :2) dstmp where 1=1 and exists( select *from mm_commonpower_td c where c.powertype = 'dataSourcePower' and dstmp.datasource = c.powerobj and c.owner in (select roleid from mm_operatorandroles_td where opcode ='002734' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:3 and biz.powergrade>='4' and exists(select d_unit.*, level from d_unit where d_unit.unitcode = t.departmentcode start with d_unit.unitcode = biz.powerobj connect by prior d_unit.unitcode = d_unit.higherunit)))
34zauv6342qp6SELECT /*+ driving_site(a) */A.DCPNO, A.INS_CODE SOURCELIB, A.DCFYP, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, CASE WHEN DCRDOP > DCDUE THEN B.A54PRM ELSE 0 END AMT_1, CASE WHEN DCRDOP > DCDUE THEN 0 ELSE B.A54PRM END AMT_2 FROM RLS_LFPPREMS@BFR A, RLS_LFPPRMSD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCRDOP > 0 AND B.A54PRM <> 0 AND GREATEST(A.DCRDOP, A.DCDUE) = :B1
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
36322yuy3rrj8 update MM_PAYABLEMONEY_TD set agentcode=:1, agentnamecn=:2, agentnameen=:3, agentpartyno=:4, amount=:5, appisjapan=:6, applicantcode=:7, applicantionpartyno=:8, applicantnamecn=:9, applicantnameen=:10, bankarea=:11, bankcity=:12, bankname=:13, bankprovince=:14, banktype=:15, baseamount=:16, basecurrencycode=:17, baseusedamount=:18, billcode=:19, billno=:20, businessattr=:21, businesschannel=:22, canceldate=:23, cancelflag=:24, cardflag=:25, certificateno=:26, certificatetype=:27, certitype=:28, chargedescription=:29, claimno=:30, classescode=:31, classeskind=:32, confirmsequenceno=:33, contracttype=:34, createdate=:35, currencycode=:36, custaccountname=:37, custaccountnameen=:38, custaccountno=:39, custbankno=:40, custemail=:41, custisjapan=:42, customercode=:43, customerkeyword=:44, customername=:45, customernameen=:46, customerpartyno=:47, custseq=:48, datasource=:49, datatype=:50, departmentcode=:51, description=:52, domestic=:53, endorseno=:54, fatherno=:55, hibernateversion=:56, ifbillback=:57, ifeffect=:58, ifsupplement=:59, ifupload=:60, inpaymentbatchno=:61, inpaymentflag=:62, inpaymentmethod=:63, insuranceterm=:64, insuredcode=:65, insuredname=:66, insurednameen=:67, insuredpartyno=:68, ispaypublic=:69, lastopdate=:70, mobilenumber=:71, offsetno=:72, opcode=:73, opdate=:74, opstatus=:75, payableseq=:76, paytype=:77, plandate=:78, policyno=:79, porttype=:80, returnno=:81, risktype=:82, s eqbusiness=:83, subcompany=:84, summaryno=:85, unitbankno=:86, unitcode=:87, usableno=:88, usedamount=:89 where payableno=:90 and hibernateversion=:91
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3d844nhux431yDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN BFP_JOBVOUCHER_PKG.jobREportAndMirror(i_jobName =>'700' ); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3mvb01r7xwy14SELECT COUNT(*) / 2000 FROM MM_POLICY_TI WHERE STATUS = '1'
3wr2mysfyh36nselect null from sys.all_mviews where owner = :object_owner and mview_name = :object_name
3xgw35tqxsmvbSELECT MAX(A.CONTRACTTYPE) FROM RLS_TEMP_LACONTRACT A WHERE A.AGENTCODE = :B2 || SUBSTR(:B1 , -6, 6)
4d68fvyqqhh90SELECT NVL(MAX(T.SIG), 1) SIG FROM RLS_TEMP_TABPLAN T WHERE T.PLAN = :B2 AND T.INS_CODE =SUBSTR(:B1 , 1, 1)
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
52pf5dda6qnjgINSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, BUSINESSCHANNEL, STARTDATE, ENDDATE, SIGNDATE, DATATYPE) SELECT NULL, NULL, NULL , C.SUBCOMPANY, V.SEGMENT2, V.CURRENCYCODE, V.ENTERED_DR, V.ENTERED_CR, 0, V.ACCOUNTINGDATE, V.CUSTOMERNAME, '0' , V.POLICYNO, NULL, C.UNITCODE, NULL, NULL, V.SEGMENT5, (SELECT EC.CLASSESCODENAME FROM BFP_CLASSESCODE_TC EC WHERE EC.CLASSESCODE =V.SEGMENT5 ) CLASSESCODENAME, (SELECT UC.UNITNAME FROM MM_UNIT_TC UC WHERE UC.UNITCODE = C.UNITCODE AND UC.IFVALID = '1') UNITNAME, (SELECT DC.DEPARTMENTNAME FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = V.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, NULL, NULL, NULL, NULL, 'TERM' FROM MM_UNIT_TC C, BFP_VOUCHERDETAIL_TD V WHERE V.SEGMENT1 = C.UNITCODE AND C.SUBCOMPANY = :B3 AND C.IFVALID = '1' AND V.SEGMENT4 IN (SELECT P.NEWCODE FROM MM_CODEMAPPING_TC P WHERE P.OLDCODE = :B4 AND P.IFVALID = '1' AND P.CODETYPE = 'MIRRORMAPPING') AND TRUNC(V.ACCOUNTINGDATE) BETWEEN :B2 + 1 AND :B1
61tn3mam0vq0b SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMB ERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
63u3rctccppxbDELETE FROM BFP_MIRRORDETAIL_TD WHERE MIRRORID = :B1
6cgrjhvx3qrvb select mmlegaldat_.id, mmlegaldat_.amount as amount55_, mmlegaldat_.bankcity as bankcity55_, mmlegaldat_.bankname as bankname55_, mmlegaldat_.bankprovince as bankprov5_55_, mmlegaldat_.batchid as batchid55_, mmlegaldat_.batchserialno as batchser7_55_, mmlegaldat_.bpstatus as bpstatus55_, mmlegaldat_.businessno as businessno55_, mmlegaldat_.businessstatus as busines10_55_, mmlegaldat_.cardflag as cardflag55_, mmlegaldat_.certificateno as certifi12_55_, mmlegaldat_.certificatetype as certifi13_55_, mmlegaldat_.certitype as certitype55_, mmlegaldat_.createdate as createdate55_, mmlegaldat_.currencycode as currenc16_55_, mmlegaldat_.custaccountname as custacc17_55_, mmlegaldat_.custaccountno as custacc18_55_, mmlegaldat_.custbankno as custbankno55_, mmlegaldat_.custemail as custemail55_, mmlegaldat_.customercode as custome21_55_, mmlegaldat_.customername as custome22_55_, mmlegaldat_.datasource as datasource55_, mmlegaldat_.description as descrip24_55_, mmlegaldat_.errcode as errcode55_, mmlegaldat_.errmsg as errmsg55_, mmlegaldat_.ifneedaudit as ifneeda27_55_, mmlegaldat_.ifpublic as ifpublic55_, mmlegaldat_.inpaymentflag as inpayme29_55_, mmlegaldat_.inpaymentmethod as inpayme30_55_, mmlegaldat_.lastopcode as lastopcode55_, mmlegaldat_.lastopdate as lastopdate55_, mmlegaldat_.mobilenumber as mobilen33_55_, mmlegaldat_.modifybatchno as modifyb34_55_, mmlegaldat_.modifycomment as modifyc35_55_, mmlegaldat_.modifydetail as modifyd36_55_, mmlegal dat_.modifyopcode as modifyo37_55_, mmlegaldat_.modifyopdate as modifyo38_55_, mmlegaldat_.modifytype as modifytype55_, mmlegaldat_.opcode as opcode55_, mmlegaldat_.realamount as realamount55_, mmlegaldat_.receivedate as receive42_55_, mmlegaldat_.rowversion as rowversion55_, mmlegaldat_.segment1 as segment44_55_, mmlegaldat_.segment2 as segment45_55_, mmlegaldat_.seqbusiness as seqbusi46_55_, mmlegaldat_.status as status55_, mmlegaldat_.summaryamount as summary48_55_, mmlegaldat_.summaryno as summaryno55_, mmlegaldat_.unitbankno as unitbankno55_, mmlegaldat_.usableno as usableno55_ from MM_LEGALDATA_MODIFY_LOG_TD mmlegaldat_ where mmlegaldat_.id=:1
6g8xxwfvnrh76SELECT T.* FROM ATS_PAY_TRANSACTIONS T WHERE T.ATS_RETURNSTATE = '2' AND (SOURCE_DEALSTATE = '1' OR (REFUND_STATE = '2' AND SOURCE_REFUNDDEALSTATE = '1'))
6mq1v48177hduSELECT /*+ driving_site(a) */ A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(A.DCPLAN) DCPLAN, DCPREM - DCDVD - DCDVDI - DCFPD AMT_D, A.DCDVD DCDVD, A.DCDVDI DCDVDI, A.DCFPD DCFPD, TRIM(A.DCFYP) DCFYP FROM RLS_LFPPREMS@BFR A WHERE A.DCRDOP = :B1
6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
70png2sdd4c2yINSERT INTO RLS_TEMP_LFPPML( INS_CODE, PNO, PAGT1, PAGT2, PPAGT1, PPAGT2, LPLAN, PEFF, PPTD, PCO, PSTU, PDOT) SELECT A.INS_CODE, A.PNO, TO_NUMBER(SUBSTR(A.PPAGT1, -6, 6)), TO_NUMBER(SUBSTR(A.PPAGT2, -6, 6)), A.PPAGT1, A.PPAGT2, TRIM(A.LPLAN), A.PEFF, A.PPTD, A.PCO, A.PSTU, A.PDOT FROM RLS_LFPPML@BFR A
77fbpzq5a3jyjSELECT T.SEGMENT8_LOW, T.SEGMENT9_LOW, T.SEGMENT10_LOW, T.SEGMENT11_LOW, T.SEGMENT12_LOW, T.SEGMENT13_LOW, T.SEGMENT14_LOW, T.SEGMENT15_LOW, T.SEGMENT16_LOW, T.SEGMENT17_LOW FROM BFP_RULES_TD T WHERE T.BATCH_ID ='630' AND T.FLEX_VALIDATION_RULE_NAME ='ALL_VOUCHER_TCODE' AND T.SEGMENT1_LOW = :B2 AND T.SEGMENT4_LOW = :B1
7aw21806wpgzpselect null from all_synonyms where 1=0
7bn2adzszradfSELECT A.ACPNO, A.INS_CODE SOURCELIB, A.ACPCO, A.ACPLAN, CASE WHEN A.ACTCD IN ('LA', 'PC', 'FP', 'D2') THEN 0- A.ACFPD ELSE 0 END ACFPD, CASE WHEN A.ACTCD IN ('LA', 'D2') THEN 0- A.ACDVD ELSE 0 END ACDVD, CASE WHEN A.ACTCD IN ('LA', 'D2') THEN 0- A.ACDVDI ELSE 0 END ACDVDI, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACLN ELSE 0 END ACLN, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACLNI ELSE 0 END ACLNI, CASE WHEN A.ACTCD = 'LA' THEN 0- A.ACMAE ELSE 0 END ACMAE FROM (SELECT ACPNO, INS_CODE, ACPCO, ACPLAN, ACTCD, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, ACDOT FROM RLS_TEMP_LFPACT WHERE ACTCD IN ('LA', 'PC', 'FP', 'D2') ) A WHERE EXISTS (SELECT 1 FROM ( SELECT DCPNO, DCACT, DCDOT FROM RLS_LFPPREM@BFR UNION ALL SELECT DCPNO, DCACT, DCDOT FROM RLS_LFPPREMH@BFR ) B WHERE TRIM(B.DCPNO) = TRIM(A.ACPNO) AND TRIM(B.DCACT) = A.ACTCD AND B.DCDOT = A.ACDOT) AND A.ACDOT=:B1
7frqszzdu8sggselect DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7h35uxf5uhmm1select sysdate from dual
7ng34ruy5awxqselect 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#
803u6vwz0ah1p select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
8c21hbhf1t608SELECT A.M2PNO, A.INS_CODE SOURCELIB, A.M2PCO, B.ACPLAN, SUM(DECODE(TRIM(M2TCOD), 'TUC', A.M2AMTF, 'TUP', A.M2AMTF, 'LSC', A.M2AMTF, 'LSP', A.M2AMTF, 'CNL', -1*A.M2AMTF)) AMT652 FROM RLS_LFPUFTDH@BFR A, (SELECT ACPNO, MAX(ACPLAN) ACPLAN FROM RLS_TEMP_LFPACT WHERE ACTCD IN ('Z1', 'Z2', 'Z3', 'Z4') AND ACDOT = :B1 GROUP BY ACPNO) B WHERE A.M2TCOD IN ('CNL', 'TUC', 'TUP', 'LSC', 'LSP') AND A.M2PNO = B.ACPNO GROUP BY A.M2PNO, A.INS_CODE, A.M2PCO, B.ACPLAN
8f1sjvfxuup9wselect t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8p409rzcjjbatSELECT DECODE(VALUE, 'UNUSED', NULL, TO_NUMBER(VALUE)) FROM WRI$_ADV_PARAMETERS WHERE TASK_ID = :B1 AND NAME = 'START_SNAPSHOT'
8yd6ptfvhq140select nvl((select t.email from mm_user_tc t where t.opcode = t1.usercode), t1.usercode) emailaddress from mm_emailadvieslist_td t1 where t1.emailid = :1
92yv7gw4g8b94SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name
9qhrn5fx6h095INSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, BUSINESSCHANNEL, STARTDATE, ENDDATE, SIGNDATE, DATATYPE) SELECT NULL, NULL, NULL , C.SUBCOMPANY, V.SEGMENT2, V.CURRENCYCODE, V.ENTERED_CR, V.ENTERED_DR, 0, V.ACCOUNTINGDATE, V.CUSTOMERNAME, '0' , V.POLICYNO, NULL, C.UNITCODE, NULL, NULL, NULL, NULL, (SELECT UC.UNITNAME FROM MM_UNIT_TC UC WHERE UC.UNITCODE = C.UNITCODE AND UC.IFVALID = '1') UNITNAME, (SELECT DC.DEPARTMENTNAME FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = V.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, NULL, NULL, NULL, NULL, 'TERM' FROM MM_UNIT_TC C, BFP_VOUCHERDETAIL_TD V WHERE V.SEGMENT1 = C.UNITCODE AND C.SUBCOMPANY = :B3 AND C.IFVALID = '1' AND V.SEGMENT4 IN (SELECT P.NEWCODE FROM MM_CODEMAPPING_TC P WHERE P.OLDCODE = :B4 AND P.IFVALID = '1' AND P.CODETYPE = 'MIRRORMAPPING') AND TRUNC(V.ACCOUNTINGDATE) BETWEEN :B2 + 1 AND :B1
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
9yr92fn9nr1nq select * from ( select opcode as opcode, decode(ifsupplement, '1', createdate, '0', receivedate) as opdate, '数据接入' as type, id from mm_policy_legal where seqbusiness = :1 union all select modifyopcode as opcode, modifyopdate as opdate, to_char((select newcode from mm_codemapping_tc where codetype = 'MODIFYTYPE' and oldcode = l.modifytype and reference1 = l.modifydetail)) type, id from mm_legaldata_modify_log_td l where seqbusiness = :2 union all select opcode , createdate as opdate, '财务报盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :3 and t.payableno = t1.newno and t1.oldno = t2.inpaymentid and t2.platformfileid = t3.id) union all select lastopcode as opcode , lastopdate as opdate, '银行回盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :4 and t.payableno = t1.newno and t1.oldno = t2.inpaymentid and t2.lastopdate > t2.createdate and t2.platformfileid = t3.id) union all select opcode , createdate as opdate, '财务报盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :5 and t.payableno = t1.oldno and t1.newno = t2.inpaymentid and t2.platformfileid = t3.id) union all select lastopcode as opcode , last opdate as opdate , '银行回盘' as type, t3.id from mm_platformfile_td t3 where exists (select 1 from mm_payablemoney_td t, mm_paymentin_events_td t1, mm_platformfile_detail_td t2 where t.seqbusiness = :6 and t.payableno = t1.oldno and t1.newno = t2.inpaymentid and t2.lastopdate > t2.createdate and t2.platformfileid = t3.id)) order by opdate
a34r71rnhycqhSELECT SEQ_VOUCHER.NEXTVAL FROM DUAL
a73024n0k9w46update MM_PAYMENTIN_EVENTS_TD set amount=:1, auditdate=:2, auditercode=:3, auditstatus=:4, baseamount=:5, basecurrencycode=:6, businesschannel=:7, businessone=:8, businesstwo=:9, checkdate=:10, checkercode=:11, claimno=:12, classescode=:13, confirmsequenceno=:14, createdate=:15, currencycode=:16, customercode=:17, customername=:18, dailyauditno=:19, datasource=:20, departmentcode=:21, departmentname=:22, description=:23, ebankingsequenceno=:24, endorseno=:25, fatherno=:26, fromunitcode=:27, hibernateversion=:28, ifprintinvoice=:29, ifupload=:30, inpaymentflag=:31, invoiceamount=:32, invoicecode=:33, invoicedunit=:34, issplitted=:35, lastopdate=:36, mmaccountid=:37, newno=:38, oldno=:39, opcode=:40, opcode2=:41, opdate=:42, opstatus=:43, payablelistno=:44, policyno=:45, receiveunit=:46, reference4=:47, returnno=:48, risktype=:49, sonno=:50, splitbatchid=:51, subcompany=:52, tosubcompany=:53, tounitcode=:54, tradebatno=:55 where listno=:56 and hibernateversion=:57
a73wbv1yu8x5cselect con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
ack02xpwc7z1bSELECT A.ACPNO, B.INS_CODE SOURCELIB, B.PCO, B.PEFF, B.PPTD, A.ACPLAN, CASE WHEN A.ACTCD LIKE 'AW%' THEN 0 - A.ACLN ELSE 0 END AMT_636, CASE WHEN A.ACTCD LIKE 'AW%' THEN 0 - A.ACLN * 0.00005 ELSE 0 END AMT_637 FROM RLS_TEMP_LFPACT A, RLS_TEMP_LFPPML B WHERE A.ACPNO = B.PNO AND A.ACTCD LIKE 'AW%' AND EXISTS (SELECT 1 FROM RLS_LFPCHGH@BFR C WHERE C.CREF = A.ACTRNR AND TRIM(C.CTC) = 'L' UNION ALL SELECT 1 FROM RLS_LFPCHG@BFR C WHERE C.CREF = A.ACTRNR AND TRIM(C.CTC) = 'L') AND A.ACDOT = :B1 AND A.ACLN <> 0
ahkzgdb62gjk8DELETE FROM BFP_RISKSPLIT_TD A WHERE TRUNC(A.SPLITDATE) = :B1
ajymgnp1qnruwselect o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
b7w2w7mhjk05uINSERT INTO BFP_POLICY_TI (SEQREPORTNO, SEQBUSINESS, BATCHID, DATASOURCE, POLICYNO, CLAIMNO, BUSINESSONE, BUSINESSTWO, CURRENCYCODE, AMOUNT, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, OPDATE, HASPLAN, CERTITYPE, EMPLOYESTATUS, GRFLAG, RENEWALFLAG, PREMTYPE, BUSINESSCHANNEL, AGENTCODE , AGENTNAME) SELECT SEQ_DEFAULT.NEXTVAL, SEQBUSINESS, :B3 , DATASOURCE, POLICYNO, CLAIMNO, '01302', '667', CURRENCYCODE, 0 - AMOUNT, OPCODE, SYSDATE CREATEDATE, SYSDATE RECEIVEDATE, LASTOPCODE, SYSDATE LASTOPDATE, '1' STATUS, CLASSESCODE, SUBCOMPANY, DEPARTMENTCODE, :B2 , HASPLAN, CERTITYPE, EMPLOYESTATUS, '101', '0', PREMTYPE, BUSINESSCHANNEL, AGENTCODE , AGENTNAME FROM BFP_POLICY_TI WHERE BUSINESSONE = '01204' AND BUSINESSTWO ='642' AND POLICYNO = :B1
bfst4kkjb9bzninsert into sys.scheduler$_event_log (log_id, log_date, type#, name, owner, operation, status, user_name, client_id, guid, dbid, additional_info, destination, class_id) values (:1, SYSTIMESTAMP, :2, :3, :4, :5, :6, :7, :8, :9, NULL, :10, :11, :12)
bhvyz9bgyrhb2SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bszs56at7vx1bUPDATE BFP_VOUCHERDETAIL_TD SET VOUCHERNO = :B23 || :B28 , JELINENO = :B27 WHERE ACCOUNTINGDATE = :B26 AND CURRENCYCODE = :B25 AND VOUCHERTYPE = :B24 AND SEGMENT1 = :B23 AND SEGMENT2 = :B22 AND NVL(SEGMENT3, 'NLL') = NVL(:B21 , 'NLL') AND SEGMENT4 = :B20 AND NVL(SEGMENT5, 'NLL') = NVL(:B19 , 'NLL') AND NVL(SEGMENT6, 'NLL') = NVL(:B18 , 'NLL') AND NVL(SEGMENT7, 'NLL') = NVL(:B17 , 'NLL') AND NVL(SEGMENT8, 'NLL') = NVL(:B16 , 'NLL') AND NVL(SEGMENT9, 'NLL') = NVL(:B15 , 'NLL') AND NVL(SEGMENT10, 'NLL') = NVL(:B14 , 'NLL') AND NVL(SEGMENT11, 'NLL') = NVL(:B13 , 'NLL') AND NVL(SEGMENT12, 'NLL') = NVL(:B12 , 'NLL') AND NVL(SEGMENT13, 'NLL') = NVL(:B11 , 'NLL') AND NVL(SEGMENT14, 'NLL') = NVL(:B10 , 'NLL') AND NVL(SEGMENT15, 'NLL') = NVL(:B9 , 'NLL') AND NVL(SEGMENT16, 'NLL') = NVL(:B8 , 'NLL') AND NVL(SEGMENT17, 'NLL') = NVL(:B7 , 'NLL') AND (SEGMENT19 = :B6 OR SEGMENT19 IS NULL) AND (SEGMENT20 = :B5 OR SEGMENT20 IS NULL) AND IFSUPPLEMENT = :B4 AND DECODE(0.00, :B3 , ENTERED_DR, :B2 , ENTERED_CR) = 0.00 AND STATUS IN ('0', '7') AND BATCHID = :B1
bu5x9yrrd2vvuUPDATE SYS.WRI$_ADV_PARAMETERS A SET A.VALUE = :B1 , A.FLAGS = :B4 WHERE A.TASK_ID = :B3 AND A.NAME = :B2 AND A.VALUE <> :B1
buwgykca9c3hnSELECT TRIM(MAX(USOCL)) FROM (SELECT USOCL FROM RLS_LFPAPPUS@BFR WHERE USPNO = :B1 UNION ALL SELECT USOCL FROM RLS_LFPAPUSH@BFR WHERE USPNO = :B1 )
buxhp761775fs INSERT INTO BFP_MIRRORDETAIL_TD ( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, ACCOUNTDATE, BUSINESSCHANNEL, POLICYNO, UNITCODE, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, TIMESTAMP, HIBERNATEVERSION) SELECT SEQ_LISTNO.NEXTVAL, (SELECT MIRRORID FROM BFP_MIRROR_TD WHERE MIRRORDATE=T.ACCOUNTDATE AND SUBCOMPANY=T.SUBCOMPANY AND MIRRORTYPE=:B4 AND TYPE=:B5 ) MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, ACCOUNTDATE, BUSINESSCHANNEL, POLICYNO, UNITCODE, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, TIMESTAMP, HIBERNATEVERSION FROM( SELECT SEGMENT4 ERPACCOUNTCODE, B.SUBCOMPANY, A.SEGMENT2 DEPARTMENTCODE, A.CURRENCYCODE, A.SEGMENT6 BUSINESSCHANNEL, SUM(CASE WHEN :B4 ='201' THEN ENTERED_CR - ENTERED_DR ELSE ENTERED_DR - ENTERED_CR END) AMOUNT, TRUNC(A.ACCOUNTINGDATE) ACCOUNTDATE, MAX(B.UNITCODE) UNITCODE, A.SEGMENT5 CLASSESCODE, A.POLICYNO, (SELECT MAX(EC.ERPCLASSESNAME) FROM BFP_ERPCLASSES_TC EC WHERE EC.ERPCLASSESCODE =A.SEGMENT5 AND EC.ENABLEDFLAG = '1') CLASSESCODENAME, MAX(B.UNITNAME) UNITNAME, (SELECT MAX(DC.DEPARTMENTNAME) FROM MM_DEPARTMENT_TC DC WHERE DC.DEPARTMENTCODE = A.SEGMENT2 AND DC.IFVALID = '1') DEPARTMENTNAME, SYSDATE TIMESTAMP, '1' HIBERNATEVERSION FROM BFP_VOUCHERDETAIL_TD A, MM_UNIT_TC B WHERE A.SEGMENT1=B.UNITCODE AND A.ACCOUNTINGDATE>=:B3 AND A.ACCOUNTINGDATE<:B2 +1 AND B.SUBCOMPANY=:B1 AND A.SEGMENT4 IN (SELECT NEWCODE FROM MM_CO DEMAPPING_TC WHERE CODETYPE ='MIRRORMAPPING' AND OLDCODE =:B4 ) GROUP BY TRUNC(A.ACCOUNTINGDATE), A.SEGMENT4, B.SUBCOMPANY, A.SEGMENT2, A.CURRENCYCODE, A.SEGMENT5, A.POLICYNO, A.SEGMENT6) T WHERE T.AMOUNT <> 0
c0xy1zgazyym8INSERT INTO BFP_MIRRORDETAIL_TD ( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, TIMESTAMP, HIBERNATEVERSION, BUSINESSCHANNEL) SELECT SEQ_LISTNO.NEXTVAL, :B2 , ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, NULL, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, :B1 , '1', BUSINESSCHANNEL FROM BFP_TMP_MIRRORDETAIL T WHERE T.DATATYPE = 'SUM'
c61yvrr104ppk 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
c8gnrhxma4tasSELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
cbasm16fcz3c3select * from mm_policy_ti where datasource = 'NEWGROUP' and bpstatus in ('12', 'Z1', 'Z2')
cfw87jaa04qd8select path from MM_QUERYFILE_TD where applyno=:1
f4r1rrdkxdnazINSERT INTO BFP_TEMP_BUSINESS (POLICYNO, AMOUNT, ACCOUNTDATE, DATATYPE) SELECT D.POLICYNO, SUM(D.REMAINS), :B1 , 'MDS' DATATYPE FROM BFP_MIRRORDETAIL_TD D, BFP_MIRROR_TD M WHERE D.MIRRORID = M.MIRRORID AND M.MIRRORDATE = :B1 AND M.MIRRORTYPE = '101' GROUP BY D.POLICYNO
f5yun5dynkskv select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
f64xbv6132vpjINSERT INTO RLS_TEMP_LFPAPPL ( PNO, INS_CODE , PCO , LPLAN , PAGT1 , PAGT2 ) SELECT C.PNO, C.INS_CODE, C.PCO, TRIM(C.LPLAN) LPLAN, C.PAGT1, C.PAGT2 FROM RLS_LFPAPPL@BFR C UNION ALL SELECT D.PNO, D.INS_CODE , D.PCO, TRIM(D.LPLAN) LPLAN, D.PAGT1, D.PAGT2 FROM RLS_LFPAPPLH@BFR D
fasad8pywykdmINSERT INTO BFP_TMP_MIRRORDETAIL( LISTNO, MIRRORID, ERPACCOUNTCODE, SUBCOMPANY, DEPARTMENTCODE, CURRENCYCODE, AMOUNT, USEDAMOUNT, REMAINS, ACCOUNTDATE, CUSTOMERNAME, OPSTATUS, POLICYNO, ENDORSENO, UNITCODE, CLAIMNO, MODIFYDESC, CLASSESCODE, CLASSESCODENAME, UNITNAME, DEPARTMENTNAME, STARTDATE, ENDDATE, SIGNDATE, TIMESTAMP, HIBERNATEVERSION, DATATYPE, BUSINESSCHANNEL) SELECT T.LISTNO, T.MIRRORID, T.ERPACCOUNTCODE, T.SUBCOMPANY, T.DEPARTMENTCODE, T.CURRENCYCODE, T.AMOUNT, T.USEDAMOUNT, T.REMAINS, T.ACCOUNTDATE, T.CUSTOMERNAME, T.OPSTATUS, T.POLICYNO, T.ENDORSENO, T.UNITCODE, T.CLAIMNO, T.MODIFYDESC, T.CLASSESCODE, T.CLASSESCODENAME, T.UNITNAME, T.DEPARTMENTNAME, T.STARTDATE, T.ENDDATE, T.SIGNDATE, T.TIMESTAMP, T.HIBERNATEVERSION, 'INIT', T.BUSINESSCHANNEL FROM BFP_MIRRORDETAIL_TD T, BFP_MIRROR_TD M WHERE T.MIRRORID = M.MIRRORID AND M.MIRRORDATE = :B3 AND M.SUBCOMPANY = :B2 AND M.MIRRORTYPE = :B1
fc1ct948abkwrINSERT INTO BFP_POLICY_TD (SEQREPORTNO, BATCHID, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, BUSINESSONE, BUSINESSTWO, SERIALNO, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, STATUS, ERRMSG, TOUNITCODE, FROMUNITCODE, DESCRIPTION, DATASOURCE, OPDATE, CUSTOMERCODE, CUSTOMERNAME, BUSINESSTHREE, BUSINESSFOUR, CERTITYPE, IFSUPPLEMENT, PREMTYPE, EMPLOYESTATUS) VALUES (:B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , '2', :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
fcsr3mt7jzznqSELECT NVL(MAX(TRIM(AGTYP)), 'AD') AGTYP, MAX(AGNAME) FROM RAS_AGPCONT@BFR WHERE INS_CODE=:B2 AND AGAGC=:B1
fkv9aynrt0sw6SELECT CASE WHEN EXISTS(SELECT 1 FROM MM_SUBCOMPANY_TC T WHERE T.SUBCOMPANY= :B1 ) THEN '1' ELSE '0' END AS FGS FROM DUAL
fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
fux2zdk7hjjhfUPDATE BFP_VOUCHER_TO V SET V.ATTRIBUTE11 = :B2 WHERE V.REFERENCE1 = :B1
fvwcc2yxafszuupdate MM_POLICYLIST_LEGAL set agentcode=:1, agentname=:2, amount=:3, applicode=:4, appliname=:5, applinameen=:6, bizno=:7, bpstatus=:8, businesschannel=:9, businessstatus=:10, claimno=:11, classescode=:12, classeskind=:13, createdate=:14, currencycode=:15, datatype=:16, departmentcode=:17, enddate=:18, endorseno=:19, errmsg=:20, grflag=:21, hasplan=:22, inputdate=:23, insuredcode=:24, insuredname=:25, insurednameen=:26, lastopcode=:27, lastopdate=:28, offsetno=:29, opcode=:30, plandate=:31, policyno=:32, realamount=:33, receivedate=:34, renewalflag=:35, rowversion=:36, segment1=:37, segment2=:38, seqbusiness=:39, seqbusinesslist=:40, seqpolicy=:41, serialno=:42, signdate=:43, startdate=:44, status=:45, subcompany=:46, transactorcode=:47, underwritercode=:48 where id=:49 and rowversion=:50
g0thukcaqz0r2 select mmlegaldat_.id, mmlegaldat_.amount as amount1_, mmlegaldat_.bankcity as bankcity1_, mmlegaldat_.bankname as bankname1_, mmlegaldat_.bankprovince as bankprov5_1_, mmlegaldat_.batchid as batchid1_, mmlegaldat_.batchserialno as batchser7_1_, mmlegaldat_.bpstatus as bpstatus1_, mmlegaldat_.businessno as businessno1_, mmlegaldat_.businessstatus as busines10_1_, mmlegaldat_.cardflag as cardflag1_, mmlegaldat_.certificateno as certifi12_1_, mmlegaldat_.certificatetype as certifi13_1_, mmlegaldat_.certitype as certitype1_, mmlegaldat_.createdate as createdate1_, mmlegaldat_.currencycode as currenc16_1_, mmlegaldat_.custaccountname as custacc17_1_, mmlegaldat_.custaccountno as custacc18_1_, mmlegaldat_.custbankno as custbankno1_, mmlegaldat_.custemail as custemail1_, mmlegaldat_.customercode as custome21_1_, mmlegaldat_.customername as custome22_1_, mmlegaldat_.datasource as datasource1_, mmlegaldat_.description as descrip24_1_, mmlegaldat_.errcode as errcode1_, mmlegaldat_.errmsg as errmsg1_, mmlegaldat_.ifneedaudit as ifneeda27_1_, mmlegaldat_.ifpublic as ifpublic1_, mmlegaldat_.inpaymentflag as inpayme29_1_, mmlegaldat_.inpaymentmethod as inpayme30_1_, mmlegaldat_.lastopcode as lastopcode1_, mmlegaldat_.lastopdate as lastopdate1_, mmlegaldat_.mobilenumber as mobilen33_1_, mmlegaldat_.modifybatchno as modifyb34_1_, mmlegaldat_.modifycomment as modifyc35_1_, mmlegaldat_.modifydetail as modifyd36_1_, mmlegaldat_.modifyopcode as modifyo37_1_, mmlegaldat_.modifyopdate as modifyo38_1_, mmlegaldat_.modifytype as modifytype1_, mmlegaldat_.opcode as opcode1_, mmlegaldat_.realamount as realamount1_, mmlegaldat_.receivedate as receive42_1_, mmlegaldat_.rowversion as rowversion1_, mmlegaldat_.segment1 as segment44_1_, mmlegaldat_.segment2 as segment45_1_, mmlegaldat_.seqbusiness as seqbusi46_1_, mmlegaldat_.status as status1_, mmlegaldat_.summaryamount as summary48_1_, mmlegaldat_.summaryno as summaryno1_, mmlegaldat_.unitbankno as unitbankno1_, mmlegaldat_.usableno as usableno1_ from MM_LEGALDATA_MODIFY_LOG_TD mmlegaldat_ where mmlegaldat_.id=:1
g8rhn3v9syy8sSELECT /*+ driving_site(a) */INS_CODE, M2PCO , M2PNO , M2AMTP , M2FTRD, TRIM(M2TCOD) M2TCOD , M2EFFD, M2PTYP, M2CODE, M2AMTU FROM RLS_LFPUFTDH@BFR A WHERE A.M2PMOD = 'R' AND TRIM(A.M2TCOD) IN ('BRC', 'SUR') AND A.M2FTRD = :B1 AND A.M2AMTP <> 0
gcu0c1chf0k24 SELECT A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, TRIM(A.DCFYP) DCFYP, CASE WHEN DCDOT > DCDUE THEN B.A54PRM ELSE 0 END AMT615, CASE WHEN DCDOT > DCDUE THEN 0 ELSE B.A54PRM END AMT616 FROM (SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREM@BFR UNION ALL SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREMH@BFR) A, RLS_LFPPREMD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCDOT > 0 AND B.A54PRM <> 0 AND TRIM(A.DCACT) IN ('LA', 'PC', 'FP', 'D2') AND EXISTS (SELECT ACPNO, TRIM(ACTCD) ACTCD, ACDOT, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, TRIM(ACPLAN) ACPLAN FROM RLS_LFPACT@BFR WHERE TRIM(A.DCPNO) = TRIM(ACPNO) AND TRIM(A.DCACT) = TRIM(ACTCD) AND TRIM(A.DCDOT) = TRIM(ACDOT) UNION ALL SELECT ACPNO, TRIM(ACTCD) ACTCD, ACDOT, ACFPD, ACDVD, ACDVDI, ACLN, ACLNI, ACMAE, TRIM(ACPLAN) ACPLAN FROM RLS_LFPACTH@BFR WHERE TRIM(A.DCPNO) = TRIM(ACPNO) AND TRIM(A.DCACT) = TRIM(ACTCD) AND TRIM(A.DCDOT) = TRIM(ACDOT)) AND GREATEST(A.DCDOT, A.DCDUE) = :B1 UNION ALL SELECT A.DCPNO, A.INS_CODE SOURCELIB, A.DCPCO, TRIM(B.A54PLAN) A54PLAN, A.DCMODE, TRIM(A.DCFYP) DCFYP, CASE WHEN DCDOT > DCDUE THEN B.A54PRM ELSE 0 END AMT615, CASE WHEN DCDOT > DCDUE THEN 0 ELSE B.A54PRM END AMT616 FROM (SELECT DCPNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREM@BFR UNION ALL SELECT DC PNO, INS_CODE, DCPCO, DCMODE, DCDOT, DCDUE, DCACT, DCSEQ, DCFYP FROM RLS_LFPPREMH@BFR) A, RLS_LFPPREMD@BFR B WHERE A.DCPNO = B.A54PNO AND A.DCSEQ = B.A54SEQ AND A.DCDOT > 0 AND B.A54PRM <> 0 AND TRIM(A.DCACT) = 'UFD' AND GREATEST(A.DCDOT, A.DCDUE) = :B1
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
grwydz59pu6mcselect text from view$ where rowid=:1
grzx1ww6wf4q2SELECT A.FLAGS FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1
gvw5y39ru38suDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN mm_job_pkg.mm_job2; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count3730.050.04
Batched IO (full) vector count430.010.00
Batched IO (space) vector count00.000.00
Batched IO block miss count7,0740.980.81
Batched IO buffer defrag count250.000.00
Batched IO double miss count3,2320.450.37
Batched IO same unit count8690.120.10
Batched IO single block count3530.050.04
Batched IO slow jump count00.000.00
Batched IO vector block count5,8940.820.68
Batched IO vector read count690.010.01
Block Cleanout Optim referenced1280.020.01
CCursor + sql area evicted750.010.01
CPU used by this session54,4567.556.27
CPU used when call started35,8044.974.12
CR blocks created6150.090.07
Cached Commit SCN referenced5500.080.06
Clusterwide global transactions40.000.00
Commit SCN cached10.000.00
DB time842,610116.8597.01
DBWR checkpoint buffers written33,9034.703.90
DBWR checkpoints40.000.00
DBWR fusion writes1980.030.02
DBWR object drop buffers written80.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written3,8490.530.44
DBWR transaction table writes1220.020.01
DBWR undo block writes22,4063.112.58
DFO trees parallelized7440.100.09
DX/BB enqueue lock background get time00.000.00
DX/BB enqueue lock background gets80.000.00
DX/BB enqueue lock foreground requests113,30715.7113.04
DX/BB enqueue lock foreground wait time850.010.01
Effective IO time43,4666.035.00
HSC Heap Segment Block Changes303,50742.0934.94
Heap Segment Array Inserts15,2702.121.76
Heap Segment Array Updates8040.110.09
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued240.000.00
PX local messages recv'd4,3800.610.50
PX local messages sent4,3800.610.50
PX remote messages recv'd4,4360.620.51
PX remote messages sent4,4380.620.51
Parallel operations downgraded to serial00.000.00
Parallel operations not downgraded7440.100.09
RowCR - row contention10.000.00
RowCR attempts3380.050.04
RowCR hits3370.050.04
SMON posted for instance recovery00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink40.000.00
SQL*Net roundtrips to/from client75,05410.418.64
SQL*Net roundtrips to/from dblink20,2302.812.33
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout23,7373.292.73
application wait time320.000.00
auto extends on undo tablespace00.000.00
background checkpoints completed20.000.00
background checkpoints started20.000.00
background timeouts65,7309.127.57
branch node splits120.000.00
buffer is not pinned count34,139,2384,734.293,930.38
buffer is pinned count3,234,679448.57372.40
bytes received via SQL*Net from client10,479,1181,453.201,206.44
bytes received via SQL*Net from dblink60,763,8858,426.496,995.61
bytes sent via SQL*Net to client22,203,4573,079.092,556.23
bytes sent via SQL*Net to dblink3,900,040540.84449.00
calls to get snapshot scn: kcmgss382,97453.1144.09
calls to kcmgas96,87513.4311.15
calls to kcmgcs320,45844.4436.89
cell physical IO interconnect bytes2,355,465,728326,646.52271,179.57
change write time4320.060.05
cleanout - number of ktugct calls26,2663.643.02
cleanouts and rollbacks - consistent read gets210.000.00
cleanouts only - consistent read gets4560.060.05
cluster key scan block gets7540.100.09
cluster key scans6670.090.08
cluster wait time9,2881.291.07
commit batch performed10.000.00
commit batch requested10.000.00
commit batch/immediate performed190.000.00
commit batch/immediate requested190.000.00
commit cleanout failures: block lost9,2301.281.06
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure470.010.01
commit cleanout failures: cannot pin00.000.00
commit cleanouts113,57215.7513.08
commit cleanouts successfully completed104,29514.4612.01
commit immediate performed180.000.00
commit immediate requested180.000.00
commit txn count during cleanout11,9471.661.38
concurrency wait time6140.090.07
consistent changes400,61355.5646.12
consistent gets133,100,82418,457.8915,323.60
consistent gets - examination17,461,4792,421.492,010.30
consistent gets direct240.000.00
consistent gets from cache133,100,80018,457.8815,323.60
consistent gets from cache (fastpath)115,562,31416,025.7213,304.43
current blocks converted for CR00.000.00
cursor authentications600.010.01
data blocks consistent reads - undo records applied1,6630.230.19
db block changes1,865,083258.64214.72
db block gets2,223,211308.31255.95
db block gets direct70.000.00
db block gets from cache2,223,204308.30255.95
db block gets from cache (fastpath)352,58848.9040.59
deferred (CURRENT) block cleanout applications80,43211.159.26
dirty buffers inspected30.000.00
enqueue conversions23,1643.212.67
enqueue releases907,513125.85104.48
enqueue requests907,579125.86104.49
enqueue timeouts740.010.01
enqueue waits3,1130.430.36
exchange deadlocks00.000.00
execute count345,09647.8639.73
failed probes on index block reclamation40.000.00
free buffer inspected120,76716.7513.90
free buffer requested88,19112.2310.15
gc CPU used by this session3860.050.04
gc blocks lost740.010.01
gc cr block build time00.000.00
gc cr block flush time10.000.00
gc cr block receive time760.010.01
gc cr block send time190.000.00
gc cr blocks received1,8520.260.21
gc cr blocks served6,5400.910.75
gc current block flush time40.000.00
gc current block pin time00.000.00
gc current block receive time2,3510.330.27
gc current block send time60.000.00
gc current blocks received28,6953.983.30
gc current blocks served2,1800.300.25
gc local grants24,8253.442.86
gc remote grants5,0610.700.58
gcs messages sent53,9257.486.21
ges messages sent20,9162.902.41
global enqueue get time2,7060.380.31
global enqueue gets async48,4546.725.58
global enqueue gets sync399,20355.3645.96
global enqueue releases290,40540.2733.43
heap block compress9,1991.281.06
hot buffers moved to head of LRU216,34630.0024.91
immediate (CR) block cleanout applications4770.070.05
immediate (CURRENT) block cleanout applications20,6512.862.38
index crx upgrade (positioned)1,5410.210.18
index crx upgrade (prefetch)00.000.00
index fast full scans (full)3340.050.04
index fetch by key16,854,3012,337.291,940.40
index scans kdiixs1288,15439.9633.17
leaf node 90-10 splits3130.040.04
leaf node splits4,8460.670.56
lob reads640.010.01
lob writes2240.030.03
lob writes unaligned2240.030.03
logons cumulative1,8150.250.21
messages received108,62415.0612.51
messages sent108,62415.0612.51
min active SCN optimization applied to CR00.000.00
no buffer to keep pinned count890.010.01
no work - consistent read gets115,292,71515,988.3313,273.40
opened cursors cumulative342,59747.5139.44
parse count (describe)80.000.00
parse count (failures)440.010.01
parse count (hard)7310.100.08
parse count (total)85,53011.869.85
parse time cpu2040.030.02
parse time elapsed3710.050.04
physical IO disk bytes2,355,465,728326,646.52271,179.57
physical read IO requests4,3220.600.50
physical read bytes51,388,4167,126.345,916.23
physical read total IO requests34,1844.743.94
physical read total bytes1,277,747,200177,192.85147,104.21
physical read total multi block requests3,0720.430.35
physical reads6,2730.870.72
physical reads cache6,2160.860.72
physical reads cache prefetch4,3380.600.50
physical reads direct570.010.01
physical reads direct (lob)240.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests6,1780.860.71
physical write bytes279,592,96038,772.8332,188.92
physical write total IO requests16,2932.261.88
physical write total bytes1,077,718,528149,453.68124,075.35
physical write total multi block requests2,3200.320.27
physical writes34,1304.733.93
physical writes direct400.010.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache34,0904.733.92
physical writes non checkpoint30,6894.263.53
pinned buffers inspected00.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use140.000.00
process last non-idle time7,2681.010.84
queries parallelized7440.100.09
recursive aborts on index block reclamation00.000.00
recursive calls1,093,422151.63125.88
recursive cpu usage18,5452.572.14
redo blocks checksummed by FG (exclusive)182,83225.3521.05
redo blocks written692,47196.0379.72
redo buffer allocation retries40.000.00
redo entries919,687127.54105.88
redo log space requests40.000.00
redo log space wait time120.000.00
redo ordering marks22,7713.162.62
redo size340,667,32847,242.3839,220.28
redo size for direct writes57,5967.996.63
redo subscn max counts1,7810.250.21
redo synch time110.000.00
redo synch writes670.010.01
redo wastage2,172,732301.31250.14
redo write broadcast ack time220.000.00
redo write time7180.100.08
redo writer latching time00.000.00
redo writes6,8610.950.79
rollback changes - undo records applied8790.120.10
rollbacks only - consistent read gets5790.080.07
rows fetched via callback16,777,7892,326.681,931.59
session connect time00.000.00
session cursor cache hits335,90546.5838.67
session logical reads135,324,03518,766.1915,579.56
shared hash latch upgrades - no wait52,8557.336.09
shared hash latch upgrades - wait00.000.00
sorts (memory)38,3025.314.41
sorts (rows)387,45053.7344.61
sql area evicted4750.070.05
sql area purged450.010.01
summed dirty queue length20.000.00
switch current to new buffer9,7861.361.13
table fetch by rowid18,152,4792,517.312,089.85
table fetch continued row6,8320.950.79
table scan blocks gotten114,478,28015,875.3913,179.63
table scan rows gotten3,954,058,827548,332.99455,222.06
table scans (long tables)10.000.00
table scans (short tables)74,18710.298.54
total number of times SMON posted40.000.00
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction rollbacks190.000.00
transaction tables consistent read rollbacks20.000.00
transaction tables consistent reads - undo records applied68,4969.507.89
undo change vector size143,257,06819,866.3116,492.87
user I/O wait time1,1830.160.14
user calls111,76715.5012.87
user commits6,3200.880.73
user rollbacks2,3660.330.27
workarea executions - onepass00.000.00
workarea executions - optimal29,5204.093.40
write clones created in background70.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max10,139,917,807,13610,162,911,504,864
session cursor cache count4,824,2894,828,532
session uga memory165,982,046,204,048166,149,628,195,296
opened cursors current178180
logons current9082
session uga memory max551,252,172,336551,760,164,792
session pga memory2,418,263,583,8082,421,176,165,056

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)21.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
CDMS 3,09703.281.592,935030.00
UNDOTBS2 1010.001.002,445010.00
SYSTEM 1,196019.351.10122000.00
SYSAUX 2308.261.17673000.00
UNDOTBS1 1010.001.001000.00
USERS 1010.001.001000.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)
CDMS+ODS02_DATA/orcl11/datafile/cdms.342.817492949 5704.211.00110000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.343.817492349 15406.171.39263000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.344.817492455 23906.531.49343000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.345.817492553 25905.141.02248000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.346.817492653 12206.151.00131000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.347.817492751 2109.526.5263000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.348.817492851 1204.171.00110000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.364.798903927 8102.471.78186000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.365.798904013 13401.341.90129000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.366.798904069 15012.6716.4796000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.367.798904121 6801.321.0053000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.368.798904177 7602.112.5789000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.369.798904231 12012.5020.6774000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.370.798904285 6018.3320.8337000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.371.798904339 1508.001.0059000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.372.798904393 14101.281.0067000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.373.798904447 2507.205.6455000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.374.798904501 18101.601.0077000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.375.798904557 15902.141.0056000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.376.798904611 13601.101.0041000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.377.798904665 31601.491.00171000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.378.798904719 18013.3314.0033000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.379.798904773 4106.833.7864010.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.380.798904833 13301.731.0027000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.381.798904897 27801.551.0031000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.382.798904949 19701.321.0095020.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.383.798905003 9306.242.2688000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.387.817493043 10802.311.56139000.00
SYSAUX+ODS02_DATA/orcl11/datafile/sysaux.353.798901157 2308.261.17673000.00
SYSTEM+ODS02_DATA/orcl11/datafile/system.352.798901157 1,196019.351.10122000.00
UNDOTBS1+ODS02_DATA/orcl11/datafile/undotbs1.354.798901157 1010.001.001000.00
UNDOTBS2+ODS02_DATA/orcl11/datafile/undotbs2.360.798901295 1010.001.002,445010.00
USERS+ODS02_DATA/orcl11/datafile/users.355.798901157 1010.001.001000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D598,552100135,317,5876,21434,090004


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B002177869278436000092784 
E011288813788843600008884 

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D4960.1058,93143.38319,976,710
D9920.20117,86219.50143,841,582
D1,4880.29176,79310.9881,026,625
D1,9840.39235,7246.5148,050,575
D2,4800.49294,6554.1530,622,483
D2,9760.59353,5862.8921,316,967
D3,4720.69412,5172.1615,946,694
D3,9680.78471,4481.6912,431,530
D4,4640.88530,3791.339,807,287
D4,9600.98589,3101.057,733,767
D5,0561.00600,7161.007,376,927
D5,4561.08648,2410.856,299,925
D5,9521.18707,1720.735,359,925
D6,4481.28766,1030.644,738,433
D6,9441.37825,0340.604,402,266
D7,4401.47883,9650.574,233,105
D7,9361.57942,8960.564,139,436
D8,4321.671,001,8270.554,093,169
D8,9281.771,060,7580.554,041,677
D9,4241.861,119,6890.533,912,222
D9,9201.961,178,6200.463,357,276

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.001,4440

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 MemGlobal Mem Bound(K)
B2,0001,590491.280.000.000.000.00204,800
E2,0001,588504.650.000.000.000.00204,800

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K28,44828,44800
64K128K494900
128K256K232300
256K512K323200
512K1024K42742700
1M2M46046000
2M4M696900
4M8M121200

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
2500.13307,072.6019,679.7694.001,39569,264,831
5000.25307,072.60515.84100.001665,202,470
1,0000.50307,072.60507.88100.00565,200,783
1,5000.75307,072.60507.88100.00065,200,783
2,0001.00307,072.60507.88100.00065,200,783
2,4001.20307,072.60446.64100.00065,187,802
2,8001.40307,072.60446.64100.00065,187,802
3,2001.60307,072.60446.64100.00065,187,802
3,6001.80307,072.60446.64100.00065,187,802
4,0002.00307,072.60446.64100.00065,187,802
6,0003.00307,072.60446.64100.00065,187,802
8,0004.00307,072.60446.64100.00065,187,802
12,0006.00307,072.60446.64100.00065,187,802
16,0008.00307,072.60446.64100.00065,187,802

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)
1,7280.6012010,736496,9550.9923,0781.1526,050
2,0160.7040931,430497,6721.0022,3611.1163,067
2,3040.8069545,757499,0501.0020,9831.0563,254
2,5920.9098361,882499,7001.0020,3331.0163,345
2,8801.001,27177,884499,9531.0020,0801.0063,382
3,1681.101,55892,896500,0841.0019,9490.9963,403
3,4561.201,846107,284500,1721.0019,8610.9963,417
3,7441.302,134121,713500,2361.0019,7970.9963,428
4,0321.402,422137,601500,2811.0019,7520.9863,435
4,3201.502,710155,637500,3181.0019,7150.9863,442
4,6081.602,998175,800500,3521.0019,6810.9863,447
4,8961.703,286197,325500,3831.0019,6500.9863,452
5,1841.803,574217,841500,4131.0019,6200.9863,456
5,4721.903,862235,693500,4391.0019,5940.9863,459
5,7602.004,150251,933500,4591.0019,5740.9763,462

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,0000.381,101,936223,936,916
4,0000.50540,57774,806,456
5,0000.63384,13233,186,577
6,0000.75332,11819,354,103
7,0000.88296,9729,807,623
8,0001.00287,8477,376,926
9,0001.13283,7026,853,902
10,0001.25282,0326,590,546
11,0001.38280,9396,372,189
12,0001.50277,5715,226,552
13,0001.63276,4195,226,552
14,0001.75276,2475,226,552
15,0001.88276,1325,226,552
16,0002.00276,1035,226,552

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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 block300
undo header100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PS-PX Process Reservation 5,9395,907322,26710.22
FB-Format Block 375375020400.34
CF-Controlfile Transaction 16,25016,250024800.24
HW-Segment High Water Mark 2,9932,993022200.23
US-Undo Segment 686806300.16
TA-Instance Undo 242402200.45
JQ-Job Queue 783642901.11
RO-Multiple Object Reuse (fast object reuse) 18180601.67
DR-Distributed Recovery 440402.50
WF-AWR Flush 434302300.00
TT-Tablespace 60260201500.00
TD-KTF map table enqueue (KTF dump entries) 141401400.00
UL-User-defined 16160600.00
TM-DML 69,23769,2370300.00
AF-Advisor Framework (task serialization) 26260200.00
JS-Job Scheduler (job run lock - synchronize) 440200.00
TO-Temp Object 2282280200.00
WL-Being Written Redo Log 220100.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
522.1760,7281,230421.4/35.50/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
10-Jul 08:5027815992310/00/0/0/0/0/0
10-Jul 08:405331,2071350/00/0/0/0/0/0
10-Jul 08:301546071310/00/0/0/0/0/0
10-Jul 08:201111,2121350/00/0/0/0/0/0
10-Jul 08:104,24033,5106104310/00/0/0/0/0/0
10-Jul 08:001711863674210/00/0/0/0/0/0
10-Jul 07:502125506173310/00/0/0/0/0/0
10-Jul 07:4015,10910,7151,2233350/00/0/0/0/0/0
10-Jul 07:302,40115,4866223320/00/0/0/0/0/0
10-Jul 07:20081,2300360/00/0/0/0/0/0
10-Jul 07:101946291320/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
ASM allocation1100.00 00 
ASM db client latch4,9540.00 00 
ASM map headers560.00 00 
ASM map load waiting list120.00 00 
ASM map operation freelist3810.00 00 
ASM map operation hash table127,9820.000.0000 
ASM network SGA latch60.00 00 
ASM network background latch3,2580.00 00 
ASM scan context latch80.00 00 
AWR Alerted Metric Element list56,0490.00 00 
Change Notification Hash table latch2,4030.00 00 
Consistent RBA6,8660.00 00 
DML lock allocation138,5380.00 00 
Event Group Locks3080.00 00 
FAL request queue1960.00 00 
FIB s.o chain latch160.00 00 
FOB s.o list latch6440.00 00 
File State Object Pool Parent Latch20.00 00 
IPC stats buffer allocation latch3,7060.00 03,7100.00
In memory undo latch20.00 00 
JS Sh mem access140.00 00 
JS broadcast add buf latch20,3570.00 00 
JS broadcast drop buf latch20,3590.00 00 
JS broadcast load blnc latch20,1500.00 00 
JS mem alloc latch110.00 00 
JS queue access latch130.00 00 
JS queue state obj latch725,4680.00 00 
JS slv state obj latch4910.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KFK SGA Libload latch3370.00 00 
KFMD SGA930.00 00 
KFR redo allocation latch20.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list5,8290.00 03,7020.00
KJCT flow control latch83,1760.010.0000 
KMG MMAN ready and startup request latch2,4030.00 00 
KSXR large replies40.00 00 
KTF sga latch1090.00 02,2390.00
KWQMN job cache list latch5060.00 00 
Locator state objects pool parent latch20.00 00 
MQL Tracking Latch0  01440.00
Memory Management Latch20.00 02,4030.00
Memory Queue20.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch517,5690.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
OS process2,1170.00 00 
OS process allocation3,8060.00 00 
OS process: request allocation6190.00 00 
PL/SQL warning settings2,6630.00 00 
QMT20.00 00 
Real-time plan statistics latch46,9760.00 00 
SGA IO buffer pool latch640.00 0670.00
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 02,4010.00
SQL memory manager workarea list latch266,8890.00 00 
Shared B-Tree2520.00 00 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
Write State Object Pool Parent Latch20.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch12,5020.100.0000 
active service list209,3350.00 05,4760.00
alert log latch40.00 00 
archive control9070.00 00 
archive process latch2,7970.00 00 
begin backup scn array10.00 00 
buffer pool20.00 00 
business card1,4900.00 00 
cache buffer handles14,1560.00 00 
cache buffers chains257,348,5550.000.0701,601,4500.00
cache buffers lru chain146,7120.00 01,627,6470.00
cache table scan latch250.00 0250.00
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch6530.00 00 
channel operations parent latch8,185,2040.000.0000 
checkpoint queue latch895,0980.000.00038,5670.00
client/application info8,3640.00 00 
commit callback allocation4460.00 00 
compile environment latch1,8190.00 00 
corrupted undo seg lock2,6560.00 00 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch1200.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch1200.00 00 
dictionary lookup20.00 00 
dml lock allocation1200.00 00 
done queue latch20.00 00 
dummy allocation3,6480.00 00 
enqueue hash chains1,996,2330.000.0000 
enqueues1,550,4600.000.0000 
error message lists3,6960.00 00 
fifth spare latch20.00 00 
file cache latch1,5450.00 00 
flashback archiver latch240.00 00 
flashback copy20.00 00 
gc element243,2830.030.080460.00
gcs commit scn state20.00 00 
gcs opaque info freelist44,3660.010.0000 
gcs partitioned table hash19,720,0630.000.00033,3260.00
gcs pcm hashed value bucket hash20.00 00 
gcs remaster request queue5990.00 00 
gcs remastering latch14,1720.010.0000 
gcs resource freelist8,8520.00 07170.00
gcs resource hash211,0230.020.0000 
gcs resource scan list20.00 00 
gcs shadows freelist3,8100.00 02,0190.00
ges caches resource lists162,4270.000.00083,7260.00
ges deadlock list1,0140.00 00 
ges domain table468,9440.00 00 
ges enqueue table freelist594,2340.000.0000 
ges group table703,9880.000.0000 
ges process hash list525,6200.00 00 
ges process parent latch1,282,4030.00 00 
ges process table freelist6190.00 00 
ges resource hash list1,019,2400.000.0308,8790.00
ges resource scan list1,5340.00 00 
ges resource table freelist15,4940.00 00 
ges timeout list1,7720.00 01320.00
ges value block free list111,9830.00 00 
global KZLD latch for mem in SGA1100.00 00 
global tx hash mapping55,9900.00 00 
granule operation20.00 00 
hash table column usage latch810.00 018,2100.00
hash table modification latch1990.00 00 
heartbeat check20.00 01,4370.00
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch20.00 0790.00
job_queue_processes free list latch80.00 00 
job_queue_processes parameter latch20,4640.00 00 
k2q global data latch4,8260.00 00 
k2q lock allocation111,9200.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kks stats3,4420.00 00 
kokc descriptor allocation latch5,7560.00 00 
ksfv messages20.00 00 
ksim membership request latch5300.00 04,7160.00
kss move lock740.00 00 
ksuosstats global area4860.00 00 
ksv allocation latch2630.00 00 
ksv class latch9,0180.00 00 
ksv msg queue latch300.00 0280.00
ksxp shared latch6190.00 00 
ksz_so allocation latch6190.00 00 
ktm global data450.00 00 
kwqbsn:qsga2500.00 00 
lgwr LWN SCN8,6460.00 00 
list of block allocation1,6890.00 00 
loader state object freelist640.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch260.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation20.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch18,3310.00 00 
messages694,2440.010.0000 
mostly latch-free SCN8,6550.00 00 
msg queue latch20.00 00 
multiblock read objects24,1840.00 00 
name-service memory objects23,8740.00 00 
name-service namespace bucket48,8700.00 00 
name-service pending queue11,7380.00 00 
name-service request260.00 00 
name-service request queue81,6240.00 00 
ncodef allocation latch1200.00 00 
object queue header heap52,1620.00 02,9300.03
object queue header operation692,7510.000.0000 
object stats modification990.00 00 
parallel query alloc buffer21,6110.00 00 
parallel query stats3,7090.00 00 
parallel txn reco latch1,3570.00 00 
parameter list1,2120.00 00 
parameter table management3,6590.00 00 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue1610.00 01050.00
process allocation34,1200.00 03060.00
process group creation6190.00 00 
process queue10,3520.00 00 
process queue reference304,1320.000.00029,4460.05
qmn task queue latch1,0180.590.0000 
query server freelists8,1450.00 00 
query server process50.00 040.00
queued dump request240.00 00 
recovery domain hash list20.00 00 
redo allocation24,2060.220.000919,6770.00
redo copy20.00 0919,6900.01
redo writing38,1560.020.0000 
resmgr group change latch3,0800.00 00 
resmgr:active threads3,6480.00 00 
resmgr:actses change group1,6620.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list3,6460.00 00 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:schema config20.00 00 
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects1,300,7400.010.0000 
second spare latch20.00 00 
segmented array pool120.00 00 
sequence cache159,5610.00 00 
session allocation39,5390.490.0100 
session idle bit231,6950.00 00 
session queue latch20.00 00 
session state list latch3,7260.00 00 
session switching1210.00 00 
session timer2,5040.00 00 
shared pool208,3070.000.2500 
shared pool sim alloc20.00 00 
shared pool simulator5,4290.00 00 
sim partition latch20.00 00 
simulator hash latch7,464,5080.000.0000 
simulator lru latch20.00 07,462,7160.00
sort extent pool1,6640.00 00 
space background state object latch220.00 00 
space background task latch5,3220.040.0004,8040.00
state object free list40.00 00 
statistics aggregation1,1200.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation40.00 00 
temporary table state object allocation20.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch3070.00 00 
transaction allocation4060.00 00 
transaction branch allocation2,5120.00 00 
undo global data575,4260.00 00 
user lock5500.00 00 
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
session allocation39,5391931192
gc element243,28371665
ges resource hash list1,019,24035134
cache buffers chains257,348,55529227
shared pool208,307413

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chainskcbgcur_2010
cache buffers chainskcbnew: new latch again010
gc elementkclnfndnewm040
gc elementkclrwrite010
gc elementkclulb011
ges resource hash listkjrmas1: lookup master node010
session allocationksuxds: KSUSFCLC not set010
shared poolkgh_next_free010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpnal2 9120
Library Cachekglpnck1 8820
Library Cachekglpndl1 9510

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
SPCDMS01CDMSMM_POLICY_TI TABLE83,012,99261.34
SPCDMS01CDMSBFP_VOUCHERDETAIL_TD TABLE20,282,92814.99
SPCDMS01CDMSBFP_MIRROR_TD TABLE16,452,84812.16
SPCDMS01CDMSBFP_RULES_TD TABLE8,041,8085.94
SPCDMS01CDMSMM_LEGALDATA_MODIFY_LOG_TD TABLE1,061,7440.78

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SPCDMS01CDMSBFP_MIRRORDETAIL_TD TABLE2,55440.71
SYSSYSTEMTYPE$ TABLE1,29820.69
SPCDMS01CDMSBFP_VOUCHER_TO TABLE4807.65
SPCDMS01CDMSIND_POLICY_TD1 INDEX3014.80
SPCDMS01CDMSBFP_POLICY_TI TABLE2524.02

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
SPCDMS01CDMSRLS_TEMP_LFPAPPL TABLE3,0248.86
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX2,1756.37
SPCDMS01CDMSBFP_MIRRORDETAIL_TD TABLE1,4974.39
SPCDMS01CDMSIND_POLICY_TI INDEX7912.32
SPCDMS01CDMSIND_POLICY_TD1 INDEX4011.17

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORY45851_5792TABLE PARTITION717.50

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SPCDMS01CDMSIDX_BFP_MIRROR_01 INDEX11032.84
SPCDMS01CDMSU_VOUCHER_TO_03 INDEX113.28
SPCDMS01CDMSIDX_PLATFORMFILE_DETAIL_01 INDEX20.60

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX188,00022.28
SPCDMS01TEMPIDX_RLS_TEMP_LFPPML01 INDEX181,34421.49
SPCDMS01CDMSBFP_MIRRORDETAIL_TD TABLE78,5129.30
SPCDMS01CDMSIDX_MIRRORDETAIL_01 INDEX51,4566.10
SPCDMS01CDMSPK_BFP_MIRRORDETAIL_TD INDEX49,0245.81

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SPCDMS01TEMPIDX_RLS_TEMP_LFPPML01 INDEX2100.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
SPCDMS01CDMSMM_QUERYCONTROL_TD TABLE1100.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SPCDMS01CDMSMM_QUERYCONTROL_TD TABLE1100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SPCDMS01CDMSBFP_POLICY_TI TABLE19310.42
SPCDMS01CDMSMM_INPAYMENT_TD TABLE1105.94
SPCDMS01CDMSMM_SUNACCOUNT_TO TABLE924.97
SYSSYSAUXSMON_SCN_TIME TABLE804.32
SPCDMS01CDMSATS_PAY_TRANSACTIONS TABLE683.67

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SPCDMS01CDMSMM_LEGALDATA_MODIFY_LOG_TD TABLE11,82741.22
SPCDMS01CDMSBFP_MIRRORDETAIL_TD TABLE3,71512.95
SYSSYSTEMTYPE$ TABLE2,94710.27
SPCDMS01CDMSBFP_VOUCHERDETAIL_TD TABLE1,8936.60
SPCDMS01CDMSIDX_PLATFORMFILE_DETAIL_01 INDEX1,6285.67

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1290.000 41
dc_database_links7,7120.000 07
dc_global_oids3,8510.000 0177
dc_histogram_data12,1090.050 011,689
dc_histogram_defs6,0860.210 07,507
dc_objects19,4360.200 125,499
dc_profiles1530.000 01
dc_rollback_segments4,7900.000 061
dc_segments3,6670.160 1501,959
dc_sequences47,7550.010 47,75517
dc_tablespace_quotas1420.000 1421
dc_tablespaces56,4940.000 08
dc_users64,2390.000 0265
global database name7,6260.000 01
outstanding_alerts8471.430 06

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control800
dc_histogram_defs1300
dc_objects2600
dc_segments30280
dc_sequences95,46630
dc_tablespace_quotas28400
outstanding_alerts168600

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY2880.005580.1810
CLUSTER2450.41731.3700
INDEX280.00280.0000
SQL AREA7,14124.56418,2570.5112649
TABLE/PROCEDURE10,4850.0682,5400.08380
TRIGGER7710.007710.0000

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER7373000
INDEX2828000
TABLE/PROCEDURE5,80579,355000

Back to Library Cache Statistics
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,056.005,056.004,880.005,248.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target2,000.002,000.002,000.002,000.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target8,000.008,000.008,000.008,000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool16.0016.0016.0016.000STA/
large pool16.0016.0016.0016.000STA/
shared pool2,864.002,864.002,672.003,040.000GRO/DEF
streams pool0.000.000.000.000STA/

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
BOther453.17 4.877.3927279393
 Freeable36.500.001.401.436 2626
 SQL1.130.510.020.04056251
 PL/SQL0.510.110.010.03009191
EOther460.83 5.367.5327278686
 Freeable41.880.001.311.316 3232
 SQL1.360.610.020.05055549
 PL/SQL0.600.210.010.03008483

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers5,301,600,256 
Fixed Size2,176,320 
Redo Buffers10,694,656 
Variable Size3,036,678,848 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largeASM map operations hashta0.380.380.00
largePX msg pool1.031.030.00
largefree memory14.6014.600.00
sharedASH buffers40.5040.500.00
sharedCCursor178.69179.530.47
sharedCursor Stats31.1731.170.00
sharedKGH: NO ACCESS31.1431.140.00
sharedKGL handle60.8560.920.12
sharedPCursor130.12130.740.48
shareddb_block_hash_buckets44.5044.500.00
sharedfree memory644.03642.34-0.26
sharedgcs resources100.45100.450.00
sharedgcs shadows66.9766.970.00
sharedkglsim object batch46.7246.720.00
sharedsql area1,179.921,179.77-0.01
 buffer_cache5,056.005,056.000.00
 fixed_sga2.082.080.00
 log_buffer10.2010.200.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 Apply

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

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/app/admin/orcl11/adump  
audit_trailNONE  
cluster_databaseTRUE  
cluster_database_instances2  
compatible11.1.0.0.0  
control_files+ODS02_DATA/orcl11/controlfile/current.356.798901211  
db_block_size8192  
db_create_file_dest+ODS02_DATA  
db_domain    
db_nameorcl11  
diagnostic_dest/oracle/app  
dispatchers(PROTOCOL=TCP) (SERVICE=orcl11XDB)  
instance_number2  
local_listenerLISTENER_ORCL112  
log_archive_dest_1LOCATION=+ARCHIVE_LOG  
log_archive_format%t_%s_%r.dbf  
open_cursors300  
pga_aggregate_target2097152000  
processes800  
remote_listenerLISTENERS_ORCL11  
remote_login_passwordfileEXCLUSIVE  
sessions885  
sga_target8388608000  
spfile+ODS02_DATA/orcl11/spfileorcl11.ora  
thread2  
undo_tablespaceUNDOTBS2  


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)4160.060.05
acks for commit broadcast(logical)4300.060.05
broadcast msgs on commit(actual)6,8170.950.78
broadcast msgs on commit(logical)6,8190.950.79
broadcast msgs on commit(wasted)410.010.00
broadcast on commit wait time(ms)640.010.01
broadcast on commit waits510.010.01
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
false posts waiting for scn acks80.000.00
flow control messages received20.000.00
flow control messages sent80.000.00
gcs assume cvt00.000.00
gcs assume no cvt1,3070.180.15
gcs ast xid00.000.00
gcs blocked converts2,6110.360.30
gcs blocked cr converts5,1700.720.60
gcs compatible basts150.000.00
gcs compatible cr basts (global)720.010.01
gcs compatible cr basts (local)20,4672.842.36
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs1630.020.02
gcs dbwr write request msgs860.010.01
gcs error msgs00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts3570.050.04
gcs immediate (null) converts3,1250.430.36
gcs immediate cr (compatible) converts00.000.00
gcs immediate cr (null) converts9340.130.11
gcs indirect ast7960.110.09
gcs indirect bidless ast00.000.00
gcs indirect fg ast7960.110.09
gcs lms flush pi msgs00.000.00
gcs lms write request msgs860.010.01
gcs msgs process time(ms)3210.040.04
gcs msgs received25,7083.572.96
gcs new served by master2,1280.300.24
gcs out-of-order msgs600.010.01
gcs pings refused00.000.00
gcs pkey conflicts retry00.000.00
gcs queued converts00.000.00
gcs reader bypass N->Xw ping local00.000.00
gcs reader bypass N->Xw ping remote00.000.00
gcs reader bypass grant X on assume00.000.00
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast00.000.00
gcs reader bypass grant immediate00.000.00
gcs recovery claim msgs00.000.00
gcs refuse xid00.000.00
gcs regular cr00.000.00
gcs retry convert request00.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual1,2090.170.14
gcs side channel msgs logical32,3164.483.72
gcs stale cr00.000.00
gcs undo cr00.000.00
gcs write notification msgs00.000.00
gcs writes refused20.000.00
ges msgs process time(ms)1480.020.02
ges msgs received25,7063.562.96
global posts dropped00.000.00
global posts queue time00.000.00
global posts queued00.000.00
global posts requested00.000.00
global posts sent00.000.00
implicit batch messages received4190.060.05
implicit batch messages sent2270.030.03
lmd msg send time(ms)00.000.00
lms(s) msg send time(ms)00.000.00
messages flow controlled1,3490.190.16
messages queue sent actual17,4192.422.01
messages queue sent logical17,8992.482.06
messages received actual36,6585.084.22
messages received logical51,4147.135.92
messages sent directly27,3323.793.15
messages sent indirectly10,9021.511.26
messages sent not implicit batched17,1922.381.98
messages sent pbatched44,6266.195.14
msgs causing lmd to send msgs10,9401.521.26
msgs causing lms(s) to send msgs7010.100.08
msgs received queue time (ms)120.000.00
msgs received queued51,4137.135.92
msgs sent queue time (ms)15,778,6712,188.121,816.56
msgs sent queue time on ksxp (ms)36,4135.054.19
msgs sent queued17,7072.462.04
msgs sent queued on ksxp50,2556.975.79
process batch messages received16,2282.251.87
process batch messages sent20,2982.812.34


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests6,354
CURRENT Block Requests153
Data Block Requests6,354
Undo Block Requests0
TX Block Requests31
Current Results6,500
Private results1
Zero Results3
Disk Read Results0
Fail Results0
Fairness Down Converts754
Fairness Clears183
Free GC Elements0
Flushes11
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works0
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins2,152100.000.000.000.000.00
Flushes60.00100.000.000.000.00
Writes19875.7617.176.060.001.01


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1data block1,29597.682.320.0028,43499.930.020.06
1Others169100.000.000.0025799.610.390.00
1undo header383100.000.000.00977.7822.220.00
1undo block2100.000.000.000   

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

  CR Avg Time (ms) Current Avg Time (ms)
Inst NoBlock Class AllImmedBusyCongstAllImmedBusyCongst
1data block0.560.531.71 0.830.820.534.30
1others0.260.26  0.300.2513.32 
1undo header0.250.25  2.880.2712.03 
1undo block0.220.22      

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

   CR Current
Src Inst#Block Class Blocks LostImmed Blks Received% 2hop% 3hopImmed Blks Received% 2hop% 3hop
1data block741,265100.000.0028,413100.000.00
1others0169100.000.00256100.000.00
1undo header0383100.000.007100.000.00
1undo block02100.000.000  

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

   CR Avg Time (ms) Current Avg Time (ms)
Src Inst#Block Class Lost TimeImmed2hop3hopImmed2hop3hop
1data block1190.470.530.53 0.820.82 
1others 0.260.26 0.250.25 
1undo header 0.250.25 0.270.27 
1undo block 0.220.22    

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
15770.170.185770.300.18
25770.180.015770.160.01

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.010.03
Parallel Query0.000.00
DB Locks0.000.00
DB Streams0.000.00
Other0.000.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Device NameIP AddressPublicSourceSend Mbytes/secSend ErrorsSend DroppedSend Buffer OverrunSend Carrier LostReceive Mbytes/secReceive ErrorsReceive DroppedReceive Buffer OverrunReceive Frame Errors
eth1192.168.1.4NOOracle Cluster Repository 0.750000 0.250000

Back to Interconnect Stats
Back to Top

End of Report