WORKLOAD REPOSITORY report for

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

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:577809-Jul-13 11:00:1096 .9
End Snap:578109-Jul-13 13:59:4684 .9
Elapsed:  179.61 (mins)  
DB Time:  37.20 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.2 1.0 0.01 0.01
DB CPU(s): 0.1 0.4 0.01 0.00
Redo size: 36,487.9 174,528.4  
Logical reads: 15,876.9 75,942.0  
Block changes: 167.9 803.0  
Physical reads: 0.1 0.4  
Physical writes: 4.9 23.6  
User calls: 20.6 98.4  
Parses: 7.1 34.1  
Hard parses: 0.3 1.3  
W/A MB processed: 47,217.3 225,849.0  
Logons: 0.2 1.2  
Executes: 17.6 84.0  
Rollbacks: 0.2 0.8  
Transactions: 0.2   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 97.03Soft Parse %: 96.13
Execute to Parse %: 59.36Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 0.01% Non-Parse CPU: 99.58

Shared Pool Statistics

BeginEnd
Memory Usage %: 87.51 87.56
% SQL with executions>1: 97.95 89.75
% Memory for SQL w/exec>1: 93.09 91.99

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 973 43.60 
SQL*Net message from dblink43,4306761630.29Network
SQL*Net more data from dblink13,7985584025.02Network
gc cr multi block request1,892840.35Cluster
db file sequential read688690.28User I/O

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

Load Average BeginLoad Average End%User%System%WIO%Idle
0.80 0.38 1.4 0.5 0.4 97.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
0.4 18.9 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): 525.8 477.0
% Host Mem used for SGA+PGA: 13.26 13.26

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1.43 6.85
Global Cache blocks served: 3.53 16.88
GCS/GES messages received: 9.96 47.63
GCS/GES messages sent: 7.54 36.08
DBWR Fusion writes: 0.08 0.37
Estd Interconnect traffic (KB) 43.10 

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

Buffer access - local cache %: 99.99
Buffer access - remote cache %: 0.01
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.5
Avg global cache current block receive time (ms): 0.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.5
Avg global cache cr block flush time (ms): 1.5
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.1
Avg global cache current block flush time (ms): 5.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 892.6
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: 58.44
% of indirect sent messages: 38.53
% of flow controlled messages: 3.03


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
eth1192.168.1.3NOracle 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 time2,207.9798.93
DB CPU973.0843.60
parse time elapsed6.550.29
hard parse elapsed time4.390.20
PL/SQL execution elapsed time3.260.15
hard parse (sharing criteria) elapsed time1.320.06
connection management call elapsed time0.690.03
sequence load elapsed time0.650.03
PL/SQL compilation elapsed time0.170.01
Java execution elapsed time0.090.00
failed parse elapsed time0.050.00
repeated bind elapsed time0.050.00
hard parse (bind mismatch) elapsed time0.040.00
DB time2,231.80 
background elapsed time120.65 
background cpu time28.67 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME530,169 
IDLE_TIME25,331,217 
IOWAIT_TIME98,011 
NICE_TIME84 
SYS_TIME141,255 
USER_TIME368,239 
LOAD10
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
09-Jul 11:00:100.80     
09-Jul 11:59:390.782.041.430.540.4097.96
09-Jul 12:59:200.312.201.560.560.4297.80
09-Jul 13:59:460.381.911.280.540.3298.09

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Network250,70701,235555.33
DB CPU  973 43.60
Cluster15,06501110.47
Other97,56982900.41
User I/O7450790.30
System I/O7,5250410.19
Concurrency3,3790100.03
Application2,1940000.02
Commit1870020.01
Configuration8130280.01

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 dblink43,43006761619.2830.29
SQL*Net more data from dblink13,7980558406.1225.02
gc cr multi block request1,8920840.840.35
db file sequential read6880690.310.28
reliable message4,3770411.940.19
control file sequential read7,5250413.340.19
gc cr block 2-way6,4280102.850.07
PX Deq: Slave Session Stats8,06821103.580.06
IPC send completion sync9,59391104.260.04
gc current block 2-way3,8320101.700.04
name-service call wait1001890.000.04
enq: PS - contention3,68241101.630.04
PX Deq: reap credit67,4721000029.950.02
os thread startup3001220.000.02
DFS lock handle9112040.040.01
log file sync1870020.080.01
db file parallel read300730.000.01
row cache lock2,2220000.990.01
enq: RO - fast object reuse800260.000.01
gc current grant busy8700000.390.01
SQL*Net more data from client2,2320000.990.01
SQL*Net break/reset to client2,1830000.970.01
log file switch completion400310.000.01
SQL*Net message to client146,10700064.850.01
library cache pin6980000.310.01
gc current multi block request1,4110000.630.00
undo segment extension110001000.000.00
library cache lock4380000.190.00
PX Deq Credit: Session Stats1,5390000.680.00
PX Deq: Signal ACK RSG2,01151000.890.00
gc current grant 2-way4120000.180.00
enq: FB - contention3210000.140.00
local write wait140030.010.00
SQL*Net message to dblink43,43000019.280.00
direct path read390010.020.00
gc cr block busy110030.000.00
gc buffer busy acquire750000.030.00
SQL*Net more data to client1,7050000.760.00
gc cr grant 2-way1330000.060.00
db file scattered read100140.000.00
PX Deq: Signal ACK EXT2850000.130.00
rdbms ipc reply450000.020.00
enq: TO - contention100000.000.00
enq: JS - job run lock - synchronize5100000.000.00
SQL*Net message from client146,1170535,720366664.85 
jobq slave wait1,9081005,71029930.85 
PX Deq Credit: send blkd8,367574,0634863.71 
Streams AQ: waiting for messages in the queue1,265851,0768510.56 
PX Deq: Execution Msg12,027181415.34 
PX Deq: Join ACK1,3100110.58 
PX Deq: Parse Reply3,16333101.40 
PX Deq: Execute Reply2,7921001.24 
single-task message300230.00 
PX Deq: Msg Fragment1,47225000.65 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
control file sequential read30,795033113.6727.73
db file parallel write9,09001314.0311.01
log file parallel write2,3290731.035.48
os thread startup24205210.114.22
control file parallel write3,7890511.683.89
log file sequential read39004100.173.08
enq: WF - contention2901320.010.78
db file sequential read1840150.080.72
library cache pin6,0070102.670.68
enq: CO - master slave det3,590100101.590.68
name-service call wait6011010.000.50
CGS wait for IPC msg95,6021001042.430.42
ASM file metadata operation2,6090001.160.33
PX Deq: Slave Join Frag3,26834001.450.21
reliable message8290000.370.18
gc cr block 2-way8710000.390.18
gc current block 2-way7460000.330.14
ksxr poll remote instances25,4271000011.290.14
gcs log flush sync1561010.070.14
enq: CF - contention55665000.250.10
enq: TM - contention651100000.290.10
PX Deq: reap credit12,759100005.660.07
Log archive I/O3840000.170.07
DFS lock handle48074000.210.06
rdbms ipc reply3950000.180.06
gc current block busy260020.010.04
gc cr block busy180030.010.04
row cache lock1770000.080.03
gc current grant busy2280000.100.03
library cache lock14843000.070.02
enq: PR - contention30070.000.02
enq: PS - contention7954000.040.02
direct path read370010.020.02
enq: HW - contention954000.040.01
log file sync50020.000.01
log file single write40020.000.01
gc current grant 2-way810000.040.01
direct path write340000.020.01
gc buffer busy release20040.000.01
PX Deq: Slave Session Stats18433000.080.01
enq: TA - contention350000.020.00
IPC send completion sync8981000.040.00
gc current multi block request600000.030.00
enq: FB - contention350000.020.00
gc cr multi block request140000.010.00
SQL*Net more data from client100000.000.00
enq: TT - contention2080000.010.00
PX Deq: Signal ACK RSG7050000.030.00
gc cr grant 2-way170000.010.00
enq: US - contention20010.000.00
enq: TX - index contention10020.000.00
SQL*Net message to client7330000.330.00
enq: DR - contention60000.000.00
enq: MW - contention60000.000.00
rdbms ipc message213,61979258,663121194.82 
wait for unread message on broadcast channel21,53210021,55410019.56 
gcs remote message553,5569221,54439245.70 
DIAG idle wait316,5909321,52768140.52 
PX Idle Wait6,0886512,82921072.70 
dispatcher timer18010010,801600040.08 
fbar timer3610010,8003000030.02 
Streams AQ: qmn slave idle wait375010,784287580.17 
Streams AQ: qmn coordinator idle wait1,1183410,78496460.50 
Space Manager: slave idle wait2,15610010,77849990.96 
PING3,8942210,77727681.73 
ASM background timer2,497010,77643161.11 
ges remote message153,7067810,7747068.22 
pmon timer3,8149410,77328251.69 
shared server idle wait35910010,771300030.16 
smon timer379210,5962863760.02 
class slave wait2817160421500.12 
JOX Jit Process Sleep3910030979250.02 
SQL*Net message from client7330110.33 
KSV master wait6,50299002.89 
PX Deq: Join ACK400010.02 
PX Deq Credit: send blkd12855000.06 
PX Deq: Parse Reply8937000.04 
Streams AQ: RAC qmn coordinator idle wait1,132100000.50 
PX Deq: Execute Reply5932000.03 

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 operation260999.6.1.1 .0.0.2 
CGS wait for IPC msg95K100.0       
DFS lock handle57199.1  .2.2 .5 
IPC send completion sync968299.9.0.1     
KJC: Wait for msg sends to complete36100.0       
LGWR wait for redo copy35100.0       
Log archive I/O38499.5   .3.3  
PX Deq Credit: Session Stats1539100.0       
PX Deq: Signal ACK EXT297100.0       
PX Deq: Signal ACK RSG2081100.0 .0     
PX Deq: Slave Join Frag326899.8.1.1.0    
PX Deq: Slave Session Stats825299.9.0.0.0  .0 
PX Deq: reap credit80K100.0       
PX qref latch21100.0       
SQL*Net break/reset to client218399.4.4.1.1  .0 
SQL*Net message from dblink43K65.6.62.5.327.22.31.4.1
SQL*Net message to client146K100.0       
SQL*Net message to dblink43K100.0       
SQL*Net more data from client224299.9.0.0     
SQL*Net more data from dblink13K92.93.2.4.1.7.11.21.3
SQL*Net more data to client1715100.0       
SQL*Net more data to dblink5100.0       
control file parallel write378893.51.1.61.62.2.4.6 
control file sequential read38K92.1.6.44.51.8.3.3 
cr request retry8100.0       
db file parallel read3    33.3 66.7 
db file parallel write909065.823.41.55.43.5.3.2 
db file scattered read1    100.0   
db file sequential read87614.71.89.134.930.96.51.9 
direct path read7690.81.3 2.65.3   
direct path write3497.1  2.9    
enq: AF - task serialization1100.0       
enq: CF - contention55699.3.5.2     
enq: CO - master slave det359099.6.3.1     
enq: DR - contention6100.0       
enq: FB - contention350100.0       
enq: HW - contention80100.0       
enq: JS - job run lock - synchronize5100.0       
enq: MW - contention6100.0       
enq: PI - contention3100.0       
enq: PR - contention3   66.733.3   
enq: PS - contention376199.7.1.1.1    
enq: PW - flush prewarm buffers1100.0       
enq: RO - fast object reuse1060.0   20.0 20.0 
enq: TA - contention35100.0       
enq: TM - contention65499.8    .2  
enq: TO - contention10100.0       
enq: TT - contention24100.0       
enq: TX - index contention1 100.0      
enq: US - contention250.050.0      
enq: WF - contention2982.8    3.413.8 
enq: WL - contention1100.0       
gc buffer busy acquire7598.71.3      
gc buffer busy release250.0  50.0    
gc cr block 2-way726999.6.2.2     
gc cr block busy2860.710.7 21.47.1   
gc cr grant 2-way150100.0       
gc cr multi block request190699.5 .1 .1 .3.2
gc current block 2-way454599.7.2.2     
gc current block busy1963.221.1  10.55.3  
gc current grant 2-way49099.8.2      
gc current grant busy107899.6.1.3     
gc current multi block request1471100.0       
gc current split1100.0       
gcs log flush sync16085.63.81.95.02.5.6.6 
ges inquiry response2100.0       
ksxr poll remote instances25K100.0       
latch free10100.0       
latch: cache buffers chains20100.0       
latch: ges resource hash list3100.0       
latch: object queue header operation10100.0       
latch: session allocation4100.0       
library cache lock58699.5.5      
library cache pin6705100.0.0.0.0    
library cache: mutex X2100.0       
local write wait1457.121.4  14.37.1  
log file parallel write233266.84.18.08.310.41.8.6 
log file sequential read3901.51.034.420.325.614.62.6 
log file single write475.0  25.0    
log file switch completion4   25.025.0 50.0 
log file sync19278.15.23.16.86.3.5  
name-service call wait16     6.393.8 
os thread startup245    2.495.12.4 
rdbms ipc reply44098.9.2 .5.5   
reliable message520699.6.2.1.0  .1 
row cache lock239399.9.1.0     
undo segment extension1      100.0 
ASM background timer24976.0.9.1.1.63.42.186.7
DIAG idle wait316K4.5.2.3.3.341.952.5 
JOX Jit Process Sleep39      5.194.9
KSV master wait650299.8.0.0 .0.0.1 
PING389477.8.1.0    22.1
PX Deq Credit: send blkd849681.0.0.0 .0  18.9
PX Deq: Execute Reply285199.9.1      
PX Deq: Execution Msg12K83.016.1.3.2.3.0.1.0
PX Deq: Join ACK135099.1.7.1     
PX Deq: Msg Fragment147299.9 .1     
PX Deq: Parse Reply325299.8.1.1     
PX Idle Wait6088.1.0.1.4.1.414.684.3
SQL*Net message from client146K80.73.02.51.41.3.37.82.9
Space Manager: slave idle wait2156       100.0
Streams AQ: RAC qmn coordinator idle wait1132100.0       
Streams AQ: qmn coordinator idle wait111866.5      33.5
Streams AQ: qmn slave idle wait375       100.0
Streams AQ: waiting for messages in the queue1265   .1.4.699.0 
class slave wait28126.0.7  .7 .771.9
dispatcher timer180       100.0
fbar timer36       100.0
gcs remote message553K4.9.6.9.5.5.991.6 
ges remote message153K10.11.71.5.81.02.182.7 
jobq slave wait1908.1  .1  .299.7
pmon timer38145.8.0     94.2
rdbms ipc message213K12.01.2.4.5.6.656.128.5
shared server idle wait359       100.0
single-task message3     100.0  
smon timer37       100.0
wait for unread message on broadcast channel21K      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$USERS1,3298203,918
orcl119028910167,100
SYS$BACKGROUND00079
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 285229301001053771235
orcl11 46054490001453300
SYS$BACKGROUND 2561658060000

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
1,0313311030.8746.19axxpjram6w68k sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
5755745,4180.1125.76cbasm16fcz3c3   select * from mm_policy_ti whe...
273341273.4312.252aur6mba52158 sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
2382386450.3710.65gtgdp28a44js0   select * from MM_PAYABLEMONEY_...
21602107.859.674q1rjpn3t0wc3 sqlplus@wo-db-1-pr (TNS V1-V3) INSERT INTO BFP_TEMP_DCRD (SOU...
162212,8210.017.28fcsr3mt7jzznq   SELECT NVL(MAX(TRIM(AGTYP)), '...
990519.854.45ack02xpwc7z1b sqlplus@wo-db-1-pr (TNS V1-V3) SELECT A.ACPNO, B.INS_CODE SO...
9605390.184.31buwgykca9c3hn   SELECT TRIM(MAX(USOCL)) FROM (...
870517.483.9234zauv6342qp6 sqlplus@wo-db-1-pr (TNS V1-V3) SELECT /*+ driving_site(a) */A...
370218.621.675cw8v33s4kydh sqlplus@wo-db-1-pr (TNS V1-V3) INSERT INTO RLS_TEMP_LFPACT( I...

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
5745755,4180.1158.9625.76cbasm16fcz3c3   select * from mm_policy_ti whe...
2382386450.3724.4110.65gtgdp28a44js0   select * from MM_PAYABLEMONEY_...
34273134.493.5412.252aur6mba52158 sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
331,031133.423.4346.19axxpjram6w68k sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
13122,3240.011.290.553xgw35tqxsmvb   SELECT MAX(A.CONTRACTTYPE) FRO...
10108,0600.000.980.448yd6ptfvhq140   select nvl((select t.email fro...
9924.350.890.4170png2sdd4c2y   INSERT INTO RLS_TEMP_LFPPML( I...
55500.100.540.23g0thukcaqz0r2   select mmlegaldat_.id, mmlega...
55470.110.530.236cgrjhvx3qrvb   select mmlegaldat_.id, mmlega...
5514.510.460.20f5yun5dynkskv plsqldev.exe select s.synonym_name as obje...

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
137,665,9705,41825,409.0080.46573.75574.83cbasm16fcz3c3   select * from mm_policy_ti whe...
20,898,57664532,400.8912.21237.52237.66gtgdp28a44js0   select * from MM_PAYABLEMONEY_...
1,959,17811,959,178.001.1534.49273.432aur6mba52158 sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
1,895,61911,895,619.001.1133.421030.87axxpjram6w68k sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
1,474,4505029,489.000.865.225.19g0thukcaqz0r2   select mmlegaldat_.id, mmlega...
1,385,9834729,489.000.815.165.186cgrjhvx3qrvb   select mmlegaldat_.id, mmlega...
1,298,5182649,259.000.768.709.1870png2sdd4c2y   INSERT INTO RLS_TEMP_LFPPML( I...
782,3132926,976.310.463.904.000cxp0daqjf90v   select count(*) as col_0_0_ fr...
698,3351698,335.000.414.2012.89f64xbv6132vpj sqlplus@wo-db-1-pr (TNS V1-V3) INSERT INTO RLS_TEMP_LFPAPPL (...
532,2415,95989.320.314.255.250g023nsr9qtjq   select * from mm_policy_ti a w...

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
2211221.0025.1733.421030.87axxpjram6w68k sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
10412,1680.0111.852.2112.802cx2pgddzwdsd   INSERT INTO BFP_POLICY_TI (SEQ...
75870.868.540.061.54d38x404f54ybs   insert into MM_PAYMENTIN_EVENT...
692800.257.860.121.27gc8wdrc4ndxsb   insert into MM_PAYMENTIN_EVENT...
482170.225.470.111.01cbwszvzaby2r4   insert into MM_PAYMENTIN_EVENT...
32132.003.6434.49273.432aur6mba52158 sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
2538.332.850.020.285u69w0v0tz51x   select count (*) as count from...
25212.502.850.350.616ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
166440.021.820.291.1936322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
7120.580.800.130.170mswpdmwk6py5   call mm_ats_pkg.mm_ats_to(:1)

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
22,34022,3401.000.000.007h35uxf5uhmm1   select sysdate from dual
12,82112,8211.000.000.01fcsr3mt7jzznq   SELECT NVL(MAX(TRIM(AGTYP)), '...
12,23212,2321.000.000.002w1cp8mz1uvqb   SELECT (SELECT NEWCODE FROM MM...
12,23212,2321.000.000.003b0zg76rm3p3n   SELECT MAX(A.INS_CODE) SOURCEL...
12,23212,2321.000.000.004d68fvyqqhh90   SELECT NVL(MAX(T.SIG), 1) SIG ...
12,23212,2321.000.000.00963852n5aqasf   SELECT SUBCOMPANY FROM MM_DEPA...
12,16812,1681.000.000.002cx2pgddzwdsd   INSERT INTO BFP_POLICY_TI (SEQ...
8,060250.000.000.008yd6ptfvhq140   select nvl((select t.email fro...
5,95900.000.000.000g023nsr9qtjq   select * from mm_policy_ti a w...
5,41800.000.110.11cbasm16fcz3c3   select * from mm_policy_ti whe...
3,2493,2491.000.000.004s1wmpcjbbkny   select seq_default.nextval fro...
2,3242,3241.000.010.013xgw35tqxsmvb   SELECT MAX(A.CONTRACTTYPE) FRO...
2,1482,1481.000.000.004gkghaguz5avk   INSERT INTO BFP_TMP_RISKS...
2,0142,0141.000.000.009gwrrr6ra2f9q   select sysdate CRTDATE from du...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
22,34022,34029.067h35uxf5uhmm1   select sysdate from dual
8,0608,06010.498yd6ptfvhq140   select nvl((select t.email fro...
5,9595,9597.750g023nsr9qtjq   select * from mm_policy_ti a w...
5,4185,4187.05cbasm16fcz3c3   select * from mm_policy_ti whe...
3,2493,2494.234s1wmpcjbbkny   select seq_default.nextval fro...
2,1491,0752.807frqszzdu8sgg racgimon@wo-db-2-pr (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
2,0142,0142.629gwrrr6ra2f9q   select sysdate CRTDATE from du...
1,2161,2161.584m7m0t6fjcs5x   update seq$ set increment$=:2,...
1,0911,0911.423972rvxu3knn3 racgimon@wo-db-1-pr (TNS V1-V3) delete from sdo_geor_ddl__tabl...
1,0911,0911.42a6u3yjca29nqc racgimon@wo-db-1-pr (TNS V1-V3) declare m_stmt varchar2(512...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
5,968,368890.22037cq8hnwpss1   update MM_POLICY_LEGAL set amo...
4,305,3216440.1636322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
2,888,734500.117ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
2,819,46630.116wm3n4d7bnddg   SELECT source, (case ...
2,006,29730.08a73024n0k9w46   update MM_PAYMENTIN_EVENTS_TD ...
1,875,5452610.07cwt8b6a6t8a79   insert into MM_PLATFORMFILE_DE...
1,811,08280.07803u6vwz0ah1p   select OBJOID, CLSOID, RUNT...
1,522,704150.06bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DE...
1,490,534290.060cxp0daqjf90v   select count(*) as col_0_0_ fr...
1,478,521770.06fvwcc2yxafszu   update MM_POLICYLIST_LEGAL set...
1,437,422570.05gbcsnmy9kqjm8   insert into MM_PLATFORMFILE_DE...
1,216,1992800.05gc8wdrc4ndxsb   insert into MM_PAYMENTIN_EVENT...
1,166,2732610.046vx15dmj4s49k   insert into MM_INPAYMENT_TD (a...
1,142,91910.0449khugt43hffr   select * from ( select platfor...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
11489037cq8hnwpss1   update MM_POLICY_LEGAL set amo...
67507ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
67507ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
67507ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
67507ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
4764436322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
4477fvwcc2yxafszu   update MM_POLICYLIST_LEGAL set...
413a73024n0k9w46   update MM_PAYMENTIN_EVENTS_TD ...
393bhvyz9bgyrhb2   SELECT name, datatype, value, ...
3630cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
36261cwt8b6a6t8a79   insert into MM_PLATFORMFILE_DE...
333akh9zqqkx3wj7   select 1, max(id) from sys.wr...
311513m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
26315w1t8qpdgg5k   select i.obj#, i.flags, u.na...
2636wm3n4d7bnddg   SELECT source, (case ...
253843z3698rn43r   SELECT nvl(e.status, a.status...
243c8gnrhxma4tas   SELECT owner#, property FROM ...
2416fnz13xnvkybtj   INSERT INTO sys.wri$_adv_findi...
23141gu8t96d0bdmu   select t.ts#, t.file#, t.block...
23141gu8t96d0bdmu   select t.ts#, t.file#, t.block...
2357gbcsnmy9kqjm8   insert into MM_PLATFORMFILE_DE...
22280gc8wdrc4ndxsb   insert into MM_PAYMENTIN_EVENT...
21290cxp0daqjf90v   select count(*) as col_0_0_ fr...
213gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...

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
4.1197.7536.994.210.0317nnxcwjxnr4ms   select * from ( select * from ...
1.9796.8217.732.040.071g4pqhxju85rdr   select count (*) as count from...
0.930.098.341,030.8733.421axxpjram6w68k sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
0.9183.448.151.090.111dfzk5b2bw668m   select tbl_.batchid, tbl_.poli...
0.350.133.12273.4334.4912aur6mba52158 sqlplus@wo-db-1-pr (TNS V1-V3) declare batchid_out number; be...
0.346.473.055.254.255,9590g023nsr9qtjq   select * from mm_policy_ti a w...
0.282.212.5412.802.2112,1682cx2pgddzwdsd   INSERT INTO BFP_POLICY_TI (SEQ...
0.220.041.99574.83573.755,418cbasm16fcz3c3   select * from mm_policy_ti whe...
0.1613.721.471.190.2964436322yuy3rrj8   update MM_PAYABLEMONEY_TD set ...
0.100.040.89237.66237.52645gtgdp28a44js0   select * from MM_PAYABLEMONEY_...
0.0914.330.780.610.3526ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
0.082.090.754.003.90290cxp0daqjf90v   select count(*) as col_0_0_ fr...
0.075.180.591.270.12280gc8wdrc4ndxsb   insert into MM_PAYMENTIN_EVENT...
0.065.610.511.010.11217cbwszvzaby2r4   insert into MM_PAYMENTIN_EVENT...
0.050.410.4812.894.201f64xbv6132vpj sqlplus@wo-db-1-pr (TNS V1-V3) INSERT INTO RLS_TEMP_LFPAPPL (...
0.042.860.371.441.461bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
0.042.150.351.831.766fz0ya076jdvj1   select count (*) as count from...
0.033.510.310.990.7956mudrcg20gdzc   select count (*) as count from...
0.031.740.241.540.0687d38x404f54ybs   insert into MM_PAYMENTIN_EVENT...
0.031.180.242.222.0659yr92fn9nr1nq   select * from ( select opcode ...
0.0210.160.210.230.201c1vr2w9vja27p   select count (*) as count from...
0.022.830.210.810.77154cc3vgpc8vvy7   select * from ( select platfor...
0.0213.940.210.160.14149khugt43hffr   select * from ( select platfor...
0.023.010.170.620.10648bvhrznagmf3m3   update mm_payablemoney_list_td...
0.028.320.160.210.201fgbmcgrgqa1zx   update mm_policylist_legal set...
0.012.340.130.620.582cndpkawm505jx   select count (*) as count from...
0.013.320.120.410.346abntd984zc4xh   select count (*) as count from...
0.018.860.120.150.1315p9h9gnj63k82   select count(1) from ( select ...
0.010.540.122.392.3865yu6cdus56fvv   select * from ( select * from ...
0.014.930.110.260.24124b5vhb41cuc9   select count (*) as count from...
0.0111.310.110.110.042222pq0y22akqb16   insert into MM_PLATFORMFILE_DE...
0.015.140.110.240.221gnbryh5283zcp   select * from ( select * from ...
0.010.240.115.185.16476cgrjhvx3qrvb   select mmlegaldat_.id, mmlega...
0.017.220.110.170.13120mswpdmwk6py5   call mm_ats_pkg.mm_ats_to(:1)
0.015.470.100.210.1723bfdwkak8bwj3   select * from ( select MM_POLI...
0.015.650.100.190.181013afbjrk6cch   select count (*) as count from...
0.016.440.100.170.0389037cq8hnwpss1   update MM_POLICY_LEGAL set amo...
0.014.100.090.240.183638s0n774w8zh   select count (*) as count from...
0.0132.080.090.030.021513m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
0.014.370.090.220.211asfsn2qvkj822   select * from ( select * from ...
0.012.260.090.420.41176q39ztcyk053   select platformfi0_.id as id99...
0.016.300.080.150.1314r8mvvus0asy2   select count(1) from ( select ...
0.013.100.080.270.2761dma70nxa58bv   select * from ( select * from ...
0.012.710.060.260.065652w8hubg0rr78j   select payablemon0_.payableno ...
0.0110.470.060.070.0177fvwcc2yxafszu   update MM_POLICYLIST_LEGAL set...
0.010.780.060.860.8413zz7hdgcyzu08   select count (*) as count from...
0.010.120.065.195.2250g0thukcaqz0r2   select mmlegaldat_.id, mmlega...
0.010.000.06215.700.0824q1rjpn3t0wc3 sqlplus@wo-db-1-pr (TNS V1-V3) INSERT INTO BFP_TEMP_DCRD (SOU...
0.019.520.050.060.0116fnz13xnvkybtj   INSERT INTO sys.wri$_adv_findi...
0.0118.120.050.030.0157gbcsnmy9kqjm8   insert into MM_PLATFORMFILE_DE...
0.011.000.050.510.522d8m9rbpwuz01x   select * from ( select inpayme...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
013afbjrk6cchselect 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.certitype = :2 AND t.inpaymentdepartment = :3 AND t.customername like :4 AND t.inpaymentflag = :5 AND t.datasource = :6) 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 ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 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)))
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'
0cxp0daqjf90vselect count(*) as col_0_0_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0_.id and (platformfi1_.policyno in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4
0g023nsr9qtjqselect * from mm_policy_ti a where a.bpstatus = '1' and a.datasource = 'NEWGROUP' and rownum <= 20
0mswpdmwk6py5call mm_ats_pkg.mm_ats_to(:1)
15w1t8qpdgg5kselect i.obj#, i.flags, u.name, o.name, o.type# from sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i where bitand(i.flags, 512) = 512 and o.obj#=idx.obj# and o.owner# = u.user# and idx.obj#=i.obj#
1dma70nxa58bv select * from ( select * from (select '12' as businesstype, '' as baserealamount, '' as authorizedstate , '' as contractcode, p.agentcode, p.amount as amount, p.bankname, p.baseamount as baseamount, p.basecurrencycode, p.baseusedamount as baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.applicantnamecn customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount as usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, 0 as baseleftamount, p.payableno as settlementno, p.usableno as usableno, p.payableseq, p.returnno, p.serialno, p.paytype, p.seqbusiness , p.paycode, p.billno, p.customerkeyword, p.ifsupplement , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate , p.confirmsequenceno , p.ifupload , 0 as seqinvply from mm_payablemoney_td p where 1=1 and p.inpaymentmethod != '04' and p.inpaymentflag = '0' and opstatus in ('0', '1') and subcompany = (:1) and datasource = (:2) and baseamount>0) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner = :3 and biz.powergrade='5' 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)) ) where rownum <= :4
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# (+)
24b5vhb41cuc9select 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.inpaymentdepartment = :2 AND t.customername like :3 AND t.inpaymentflag = :4 AND t.datasource = :5) 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 ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:6 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)))
2aur6mba52158declare batchid_out number; begin -- Call the procedure spcdms01.bfp_preposerls_pkg.do_extract(startopdate_in => date'2013-07-05', endopdate_in => date'2013-07-08', batchid_out => batchid_out); end;
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 )
2pq0y22akqb16insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, certificateno, certificatetype, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42)
2w1cp8mz1uvqbSELECT (SELECT NEWCODE FROM MM_CODEMAPPING_TC WHERE CODETYPE = 'DEPARTMENTMAPPING' AND OLDCODE = :B1 ) ERLT FROM DUAL
2w8hubg0rr78j select payablemon0_.payableno as payableno91_0_, payablemon0_.agentcode as agentcode91_0_, payablemon0_.agentnamecn as agentnam3_91_0_, payablemon0_.agentnameen as agentnam4_91_0_, payablemon0_.agentpartyno as agentpar5_91_0_, payablemon0_.amount as amount91_0_, payablemon0_.appisjapan as appisjapan91_0_, payablemon0_.applicantcode as applican8_91_0_, payablemon0_.applicantionpartyno as applican9_91_0_, payablemon0_.applicantnamecn as applica10_91_0_, payablemon0_.applicantnameen as applica11_91_0_, payablemon0_.bankarea as bankarea91_0_, payablemon0_.bankcity as bankcity91_0_, payablemon0_.bankname as bankname91_0_, payablemon0_.bankprovince as bankpro15_91_0_, payablemon0_.banktype as banktype91_0_, payablemon0_.baseamount as baseamount91_0_, payablemon0_.basecurrencycode as basecur18_91_0_, payablemon0_.baseusedamount as baseuse19_91_0_, payablemon0_.billcode as billcode91_0_, payablemon0_.billno as billno91_0_, payablemon0_.businessattr as busines22_91_0_, payablemon0_.businesschannel as busines23_91_0_, payablemon0_.canceldate as canceldate91_0_, payablemon0_.cancelflag as cancelflag91_0_, payablemon0_.cardflag as cardflag91_0_, payablemon0_.certificateno as certifi27_91_0_, payablemon0_.certificatetype as certifi28_91_0_, payablemon0_.certitype as certitype91_0_, payablemon0_.chargedescription as charged30_91_0_, payablemon0_.claimno as claimno91_0_, payablemon0_.classescode as classes32_91_0_, payablemon0_.classeskind as classes33_91_0_, payablemon0_.confirmsequenceno as confirm34_91_0_, payablemon0_.contracttype as contrac35_91_0_, payablemon0_.createdate as createdate91_0_, payablemon0_.currencycode as currenc37_91_0_, payablemon0_.custaccountname as custacc38_91_0_, payablemon0_.custaccountnameen as custacc39_91_0_, payablemon0_.custaccountno as custacc40_91_0_, payablemon0_.custbankno as custbankno91_0_, payablemon0_.custemail as custemail91_0_, payablemon0_.custisjapan as custisj43_91_0_, payablemon0_.customercode as custome44_91_0_, payablemon0_.customerkeyword as custome45_91_0_, payablemon0_.customername as custome46_91_0_, payablemon0_.customernameen as custome47_91_0_, payablemon0_.customerpartyno as custome48_91_0_, payablemon0_.custseq as custseq91_0_, payablemon0_.datasource as datasource91_0_, payablemon0_.datatype as datatype91_0_, payablemon0_.departmentcode as departm52_91_0_, payablemon0_.description as descrip53_91_0_, payablemon0_.domestic as domestic91_0_, payablemon0_.endorseno as endorseno91_0_, payablemon0_.fatherno as fatherno91_0_, payablemon0_.hibernateversion as hiberna57_91_0_, payablemon0_.ifbillback as ifbillback91_0_, payablemon0_.ifeffect as ifeffect91_0_, payablemon0_.ifsupplement as ifsuppl60_91_0_, payablemon0_.ifupload as ifupload91_0_, payablemon0_.inpaymentbatchno as inpayme62_91_0_, payablemon0_.inpaymentflag as inpayme63_91_0_, payablemon0_.inpaymentmethod as inpayme64_91_0_, payablemon0_.insuranceterm as insuran65_91_0_, payablemon0_. insuredcode as insured66_91_0_, payablemon0_.insuredname as insured67_91_0_, payablemon0_.insurednameen as insured68_91_0_, payablemon0_.insuredpartyno as insured69_91_0_, payablemon0_.ispaypublic as ispaypu70_91_0_, payablemon0_.lastopdate as lastopdate91_0_, payablemon0_.mobilenumber as mobilen72_91_0_, payablemon0_.offsetno as offsetno91_0_, payablemon0_.opcode as opcode91_0_, payablemon0_.opdate as opdate91_0_, payablemon0_.opstatus as opstatus91_0_, payablemon0_.payableseq as payableseq91_0_, payablemon0_.paytype as paytype91_0_, payablemon0_.plandate as plandate91_0_, payablemon0_.policyno as policyno91_0_, payablemon0_.porttype as porttype91_0_, payablemon0_.returnno as returnno91_0_, payablemon0_.risktype as risktype91_0_, payablemon0_.seqbusiness as seqbusi84_91_0_, payablemon0_.subcompany as subcompany91_0_, payablemon0_.summaryno as summaryno91_0_, payablemon0_.unitbankno as unitbankno91_0_, payablemon0_.unitcode as unitcode91_0_, payablemon0_.usableno as usableno91_0_, payablemon0_.usedamount as usedamount91_0_ from MM_PAYABLEMONEY_TD payablemon0_ where payablemon0_.payableno=:1
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
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$$
3b0zg76rm3p3nSELECT MAX(A.INS_CODE) SOURCELIB, MAX(A.PAGT1) AGT1_NUM, MAX(A.PAGT2) AGT2_NUM, MAX(A.PPAGT1) PAGT1, MAX(A.PPAGT2) PAGT2 FROM RLS_TEMP_LFPPML A WHERE A.PNO = :B1
3bfdwkak8bwj3select * from ( select MM_POLICY_LEGAL.inpaymentdepartment as departmentcode, MM_POLICY_LEGAL.* , (select max(list.policyno) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) policyno , (select max(list.classescode) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) classescode , (select max(list.businesschannel) from MM_POLICYLIST_LEGAL list where list.seqbusiness= MM_POLICY_LEGAL.seqbusiness) businesschannel , log.modifybatchno from MM_POLICY_LEGAL, mm_legaldata_modify_log_td log where 1 = 1 and MM_POLICY_LEGAL.certitype <> '6' and MM_POLICY_LEGAL.seqbusiness = log.seqbusiness and log.modifydetail = 'auditpass' and log.modifytype = '3' and log.modifybatchno = :1 ) where rownum <= :2
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)
3xgw35tqxsmvbSELECT MAX(A.CONTRACTTYPE) FROM RLS_TEMP_LACONTRACT A WHERE A.AGENTCODE = :B2 || SUBSTR(:B1 , -6, 6)
3zz7hdgcyzu08select 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :2 AND t.createdate >= :3 AND t.createdate <:4+1 AND t.ifsupplement = :5 AND t.inpaymentflag = :6) 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 ='001974' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 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)))
49khugt43hffr select * from ( select platformfi0_.id as id108_, platformfi0_.accountno as accountno108_, platformfi0_.batchno as batchno108_, platformfi0_.createdate as createdate108_, platformfi0_.crsumamount as crsumamo5_108_, platformfi0_.crsumcount as crsumcount108_, platformfi0_.currencycode as currency7_108_, platformfi0_.detailcount as detailco8_108_, platformfi0_.downloadcounts as download9_108_, platformfi0_.drsumamount as drsumam10_108_, platformfi0_.drsumcount as drsumcount108_, platformfi0_.failamount as failamount108_, platformfi0_.failcount as failcount108_, platformfi0_.filename as filename108_, platformfi0_.filepath as filepath108_, platformfi0_.filestatus as filestatus108_, platformfi0_.hibernateversion as hiberna17_108_, platformfi0_.lastopcode as lastopcode108_, platformfi0_.lastopdate as lastopdate108_, platformfi0_.merchantno as merchantno108_, platformfi0_.mmaccountid as mmaccou21_108_, platformfi0_.modifydesc as modifydesc108_, platformfi0_.opcode as opcode108_, platformfi0_.opdate as opdate108_, platformfi0_.optime as optime108_, platformfi0_.outputdate as outputdate108_, platformfi0_.platformid as platformid108_, platformfi0_.successamount as success28_108_, platformfi0_.successcount as success29_108_, platformfi0_.sumamount as sumamount108_, platformfi0_.unitcode as unitcode108_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0 _.id and (platformfi1_.policyno in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4 ) where rownum <= :5
4cc3vgpc8vvy7 select * from ( select platformfi0_.id as id26_, platformfi0_.accountno as accountno26_, platformfi0_.batchno as batchno26_, platformfi0_.createdate as createdate26_, platformfi0_.crsumamount as crsumamo5_26_, platformfi0_.crsumcount as crsumcount26_, platformfi0_.currencycode as currency7_26_, platformfi0_.detailcount as detailco8_26_, platformfi0_.downloadcounts as download9_26_, platformfi0_.drsumamount as drsumam10_26_, platformfi0_.drsumcount as drsumcount26_, platformfi0_.failamount as failamount26_, platformfi0_.failcount as failcount26_, platformfi0_.filename as filename26_, platformfi0_.filepath as filepath26_, platformfi0_.filestatus as filestatus26_, platformfi0_.hibernateversion as hiberna17_26_, platformfi0_.lastopcode as lastopcode26_, platformfi0_.lastopdate as lastopdate26_, platformfi0_.merchantno as merchantno26_, platformfi0_.mmaccountid as mmaccou21_26_, platformfi0_.modifydesc as modifydesc26_, platformfi0_.opcode as opcode26_, platformfi0_.opdate as opdate26_, platformfi0_.optime as optime26_, platformfi0_.outputdate as outputdate26_, platformfi0_.platformid as platformid26_, platformfi0_.successamount as success28_26_, platformfi0_.successcount as success29_26_, platformfi0_.sumamount as sumamount26_, platformfi0_.unitcode as unitcode26_ from MM_PLATFORMFILE_TD platformfi0_ where 1=1 and (exists (select 1 from MM_PLATFORMFILE_DETAIL_TD platformfi1_ where platformfi1_.platformfileid=platformfi0_.id and (platformfi1_.policyno in (:1)))) and (exists (select 1 from MM_BIZSUB_COVER_TD bizsub2_, MM_UNIT_TC unit3_ where unit3_.subcompany=bizsub2_.SUBCOMPANY and unit3_.unitcode=platformfi0_.unitcode and bizsub2_.OPCODE=:2)) and platformfi0_.opdate>=:3 and platformfi0_.opdate<=:4 ) where rownum <= :5
4d68fvyqqhh90SELECT NVL(MAX(T.SIG), 1) SIG FROM RLS_TEMP_TABPLAN T WHERE T.PLAN = :B2 AND T.INS_CODE =SUBSTR(:B1 , 1, 1)
4gkghaguz5avk INSERT INTO BFP_TMP_RISKSPLIT_TD( POLICYNO, RISKCODE, SUBRISKCODE, SPLITTYPE, SPLITDATE, SPLITPREM, SUBPREMIUM, SUBQTY, SUBRATE, IFMEDCOVER, INSUREDAGE, INSUREDGENDER, INSUREDCASTE, HOLDERAGE, HOLDERGENDER, COVERAGE, MAINRISKCODE, MAINPREM, TOTALPREM, PERIODRATIO, SERIALNO) VALUES(:POLICYNO, :RISKCODE, :SUBRISKCODE, :SPLITTYPE, :SPLITDATE, :SPLITPREM, :SUBPREMIUM, :SUBQTY, :SUBRATE, :IFMEDCOVER, :INSUREDAGE, :INSUREDGENDER, :INSUREDCASTE, :HOLDERAGE, :HOLDERGENDER, :COVERAGE, :MAINRISKCODE, :MAINPREM, :TOTALPREM, :PERIODRATIO, :SERIALNO)
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4q1rjpn3t0wc3 INSERT INTO BFP_TEMP_DCRD (SOURCELIB, DCRSEQ, DCRDOT, DCRDOS, DCRECP, DCRTYP, DCRDOP, DCREV, DCRBCQ, DCPAID, DCCY, DCRATE, DCTRAN, DCPCO, DCPNO, DCPCCY, DCPRAT, DCPN, DCDUE, DCFYP, DCMODE, DCPREM, DCMTH, DCDIFF, DCAGT1, DCAGT2, DCCOMM, DCLN, DCLNI, DCDVD, DCDVDI, DCFPD, DCFPDI, DCSDA1, DCSDC1, DCRAT1, DCSD1, DCSDA2, DCSDC2, DCRAT2, DCSD2, DCSDA3, DCSDC3, DCRAT3, DCSD3, DCSDA4, DCSDC4, DCRAT4, DCSD4, DCSDA5, DCSDC5, DCRAT5, DCSD5, DCPLAN, DCPLNN, DCTRMP, DCTRMC, DCILSP, DCTLSP, DCILSC, DCTLSC, DCSEQ2, DCXCLC, DCXCAM, DCRAL, DCMEXTR, DCMBNS, DCRSOUR, DCCSPL, DCPFX, DCPFT, DCPIL, DCPFL, DCRTYP_OLD, FLAG, OPDATE) SELECT /*+ driving_site(a) */A.INS_CODE SOURCELIB, A.DCRSEQ, A.DCRDOT, A.DCRDOS, A.DCRECP, CASE WHEN A.DCRTYP = '3' AND A.DCREV = 'R' AND B.DCPNO IS NOT NULL THEN B.DCRTYP ELSE A.DCRTYP END DCRTYP, A.DCRDOP, A.DCREV, A.DCRBCQ, A.DCPAID, A.DCCY, A.DCRATE, A.DCTRAN, A.DCPCO, A.DCPNO, A.DCPCCY, A.DCPRAT, A.DCPN# DCPN, A.DCDUE, A.DCFYP, A.DCMODE, A.DCPREM, A.DCMTH, A.DCDIFF, A.DCAGT1, A.DCAGT2, A.DCCOMM, A.DCLN, A.DCLNI, A.DCDVD, A.DCDVDI, A.DCFPD, A.DCFPDI, A.DCSDA1, A.DCSDC1, A.DCRAT1, A.DCSD1, A.DCSDA2, A.DCSDC2, A.DCRAT2, A.DCSD2, A.DCSDA3, A.DCSDC3, A.DCRAT3, A.DCSD3, A.DCSDA4, A.DCSDC4, A.DCRAT4, A.DCSD4, A.DCSDA5, A.DCSDC5, A.DCRAT5, A.DCSD5, TRIM(A.DCPLAN), A.DCPLNN, A.DCTRMP, A.DCTRMC, A.DCILSP, A.DCTLSP, A.DCILSC, A.DCTLSC, A.DCSEQ2, A.DCXCLC, A.DCXCAM, A.DCRAL, A.DCMEXTR, A.DCMB NS, A.DCRSOUR, A.DCCSPL, A.DCPFX, A.DCPFT, A.DCPIL, A.DCPFL, A.DCRTYP DCRTYP_OLD, CASE WHEN A.DCREV = 'R' THEN -1 ELSE 1 END FLAG, TRUNC(SYSDATE) OPDATE FROM RLS_LFPDCRD@BFR A, (SELECT /*+ driving_site(c) */ DCPNO, DCRSEQ, MAX(DCRTYP) DCRTYP, MAX(DCREV) DCREV FROM RLS_LFPDCRD@BFR C WHERE (C.DCRTYP IN ('1', '2') AND C.DCREV = 'Q') OR (C.DCRTYP = '3' AND C.DCREV = 'X') GROUP BY DCPNO, DCRSEQ) B WHERE A.DCPNO = B.DCPNO(+) AND A.DCRSEQ = B.DCRSEQ(+) AND ((A.DCRDOT > :B2 AND A.DCRDOT <= :B1 ) OR (A.DCRDOP > :B2 AND A.DCRDOP <= :B1 ) OR (A.DCDUE > :B2 AND A.DCDUE <= :B1 ) )
4r8mvvus0asy2select count(1) from ( select '' USPBATCHNO, '' USPSERIALNO, '' MAKEDATE, '' MAKETIME, SEQBUSINESSLIST, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, SERIALNO, DATATYPE, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, INSUREDCODE, INSUREDNAME, INSUREDNAMEEN, APPLICODE, APPLINAME, APPLINAMEEN, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, BUSINESSSTATUS, BPSTATUS, STATUS, ERRMSG from MM_POLICYLIST_TI where SEQBUSINESS in (select SEQBUSINESS from MM_POLICY_TI where DATASOURCE = 'SRS') and BPSTATUS = '1' order by LASTOPDATE) rsc
4s1wmpcjbbknyselect seq_default.nextval from dual
5cw8v33s4kydh INSERT INTO RLS_TEMP_LFPACT( INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, ACPLAN, ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF) SELECT /*+ driving_site(a) */INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, TRIM(ACPLAN) ACPLAN, TRIM(ACTCD) ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF FROM RLS_LFPACT@BFR WHERE ACDOT > :B2 AND ACDOT <= :B1 UNION ALL SELECT INS_CODE, ACPCO, ACPNO, ACPCCY, ACCCY, TRIM(ACPLAN) ACPLAN, TRIM(ACTCD) ACTCD, ACEFF, ACDOT, ACTRNR, ACPAYR, ACDCR, ACNBDI, ACRB, ACTB, ACDVD, ACDVDI, ACMAE, ACLN, ACLNI, ACFPD, ACFPDI, ACFUND, ACFYP, ACPREM, ACTRMP, ACDIFF, ACBSUR, ACSUR, ACMAT, ACSIB, ACPCRG, ACCOI, ACPMF, ACIMF, ACRMF, ACAMF, ACAP, ACGC, ACSCRG, ACABAL, ACDCLM, ACPCHG, ACSD, ACAMT, ACAMTH, ACERAT, ACADMC, ACITM1, ACITM2, ACSCH, ACSCHI, ACCSF FROM RLS_LFPACTH@BFR WHERE ACDOT > :B2 AND ACDOT <= :B1
5p9h9gnj63k82select count(1) from ( select '' USPBATCHNO, '' USPSERIALNO, '' MAKEDATE, '' MAKETIME, SEQBUSINESSLIST, SEQBUSINESS, SUBCOMPANY, DEPARTMENTCODE, POLICYNO, ENDORSENO, CLAIMNO, BIZNO, SERIALNO, DATATYPE, CURRENCYCODE, AMOUNT, CLASSESKIND, CLASSESCODE, STARTDATE, ENDDATE, SIGNDATE, INPUTDATE, PLANDATE, INSUREDCODE, INSUREDNAME, INSUREDNAMEEN, APPLICODE, APPLINAME, APPLINAMEEN, TRANSACTORCODE, UNDERWRITERCODE, AGENTCODE, AGENTNAME, BUSINESSCHANNEL, GRFLAG, HASPLAN, RENEWALFLAG, OFFSETNO, REALAMOUNT, SEGMENT1, SEGMENT2, OPCODE, CREATEDATE, RECEIVEDATE, LASTOPCODE, LASTOPDATE, ROWVERSION, BUSINESSSTATUS, BPSTATUS, STATUS, ERRMSG from MM_POLICYLIST_TI where SEQBUSINESS in (select SEQBUSINESS from MM_POLICY_TI where DATASOURCE = 'GROUP') and BPSTATUS = '1' and SUBCOMPANY like '8601%' order by LASTOPDATE) rsc
5u69w0v0tz51x select count (*) as count from(select * from (select '12' as businesstype, 0 as baserealamount, '' as contractcode, p.agentcode, p.amount, p.bankname, p.baseamount, p.basecurrencycode, p.baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, p.bankprovince, p.bankcity, p.ifoldcustaccountno, p.banktype, p.ispaypublic, p.ifsupplement, '' as result, p.payableno as settlementno, p.payableseq, p.returnno, p.serialno, p.paytype, 0 as baseleftamount , 0 as seqinvply , null as platformid, p.billno, p.custaccountname, p.seqbusiness, p.inpaymentflag, p.ifbillback, p.unitbankno, p.mobilenumber, p.cardflag, p.certificatetype, p.certificateno, p.custemail, p.bankarea, p.certitype, p.inpaymentmethod, p.plandate , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate, p.confirmsequenceno, p.ifupload, '1' as authorizedstate from mm_payablemoney_td p where 1=1 and p.ifbillback='0' and p.basecurrencycode = (:1) and (p.opdate betwee n (:2) and (:3)) and exists(select 1 from mm_payablemoney_list_td list where 1=1 and list.payableno= p.payableno and list.policyno in (:4) ) and (p.datatype not in ('402', '417', '418') or( p.datatype in('402', '417', '418') and not exists(select 1 from mm_policy_legal where seqbusiness=p.seqbusiness and status<>'2')))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner = :5 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)))
5yu6cdus56fvvselect * 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.createdate >= :2 AND t.createdate <:3+1) 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 ='1698' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:4 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)) ) where rownum <= :5
638s0n774w8zhselect 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :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 ='G3131' ))) 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)))
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
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
6mudrcg20gdzcselect count (*) as count from(select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, receiptno, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate from mm_inpayment_td i where saveflag = '0' and opstatus in ('Z') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) )
6vx15dmj4s49kinsert into MM_INPAYMENT_TD (accountno, amount, auditstatus, baseamount, basecurrencycode, baseusedamount, cancelflag, checkdate, createdate, currencycode, custaccountno, custbankno, customerbankname, customercode, customername, gatherstatus, hibernateversion, ifprinted, incomemethod, inpaymentbatno, inpaymentmethod, lastopdate, mmaccountid, mmaccountname, mmbankname, opcode, opdate, operatedtimes, opstatus, platformid, rate, remittername, saveflag, subcompany, unitcode, usedamount, inpaymentflag, inpaymentid) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, '1', :37)
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
76q39ztcyk053 select platformfi0_.id as id99_, platformfi0_.amount as amount99_, platformfi0_.atsdealdate as atsdeald3_99_, platformfi0_.atsdealerrorinfo as atsdeale4_99_, platformfi0_.atsdealstate as atsdeals5_99_, platformfi0_.atsreturndate as atsretur6_99_, platformfi0_.atsreturninfo as atsretur7_99_, platformfi0_.atsreturnstate as atsretur8_99_, platformfi0_.bank_failtype as bank9_99_, platformfi0_.bank_payresultinfo as bank10_99_, platformfi0_.bankabstract as bankabs11_99_, platformfi0_.batchno as batchno99_, platformfi0_.batchserialno as batchse13_99_, platformfi0_.budgetitemcode as budgeti14_99_, platformfi0_.businessno as businessno99_, platformfi0_.cardflag as cardflag99_, platformfi0_.certificateno as certifi17_99_, platformfi0_.certificatetype as certifi18_99_, platformfi0_.checkbatchno as checkba19_99_, platformfi0_.checkno as checkno99_, platformfi0_.checktype as checktype99_, platformfi0_.createdate as createdate99_, platformfi0_.currencycode as currenc23_99_, platformfi0_.currencyname as currenc24_99_, platformfi0_.custaccountname as custacc25_99_, platformfi0_.custaccountno as custacc26_99_, platformfi0_.custbankarea as custban27_99_, platformfi0_.custbankcity as custban28_99_, platformfi0_.custbankcode as custban29_99_, platformfi0_.custbankname as custban30_99_, platformfi0_.custbankprovince as custban31_99_, platformfi0_.customername as custome32_99_, platformfi0_.customertype as custome33_99_, platformfi0_.custunitbankno as custuni34_99_ , platformfi0_.cvvcode as cvvcode99_, platformfi0_.cvvvaliddate as cvvvali36_99_, platformfi0_.datasource as datasource99_, platformfi0_.departmentcode as departm38_99_, platformfi0_.description as descrip39_99_, platformfi0_.displayorder as display40_99_, platformfi0_.failtype as failtype99_, platformfi0_.fastflag as fastflag99_, platformfi0_.fundcategorycode as fundcat43_99_, platformfi0_.fundsubcategorycode as fundsub44_99_, platformfi0_.inpaymentflag as inpayme45_99_, platformfi0_.inpaymentid as inpayme46_99_, platformfi0_.ispublic as ispublic99_, platformfi0_.lastopcode as lastopcode99_, platformfi0_.lastopdate as lastopdate99_, platformfi0_.memo as memo99_, platformfi0_.merchantno as merchantno99_, platformfi0_.mmaccountid as mmaccou52_99_, platformfi0_.mmaccountname as mmaccou53_99_, platformfi0_.mmaccountno as mmaccou54_99_, platformfi0_.mmbankcode as mmbankcode99_, platformfi0_.mmbankname as mmbankname99_, platformfi0_.mmentitycode as mmentit57_99_, platformfi0_.opcode as opcode99_, platformfi0_.paydate as paydate99_, platformfi0_.paymadedate as paymade60_99_, platformfi0_.payresultinfo as payresu61_99_, platformfi0_.paystate as paystate99_, platformfi0_.paytype as paytype99_, platformfi0_.platformfileid as platfor64_99_, platformfi0_.policyno as policyno99_, platformfi0_.purpose as purpose99_, platformfi0_.refundinfo as refundinfo99_, platformfi0_.refundstate as refunds68_99_, platformfi0_.refundtime as refundtime99_, platformfi0_ .rowversion as rowversion99_, platformfi0_.settlementmode as settlem71_99_, platformfi0_.sourcedealdate as sourced72_99_, platformfi0_.sourcedealerrorinfo as sourced73_99_, platformfi0_.sourcedealstate as sourced74_99_, platformfi0_.sourcerefunddealdate as sourcer75_99_, platformfi0_.sourcerefunddealerrorinfo as sourcer76_99_, platformfi0_.sourcerefunddealstate as sourcer77_99_, platformfi0_.subcompany as subcompany99_, platformfi0_.vendor_code as vendor79_99_ from MM_PLATFORMFILE_DETAIL_TD platformfi0_ where 1=1 and platformfi0_.inpaymentid=:1
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#
7nnxcwjxnr4msselect * from ( select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= :1 and bfp_voucherdetail_td.accountingDate < :2 and bfp_voucherdetail_td.currencyCode = :3 and bfp_voucherdetail_td.segment1 = :4 ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:5 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)) ) where rownum <= :6
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
843z3698rn43rSELECT nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
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
963852n5aqasfSELECT SUBCOMPANY FROM MM_DEPARTMENT_TC WHERE DEPARTMENTCODE = :B1
9gwrrr6ra2f9qselect sysdate CRTDATE from dual
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
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
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
abntd984zc4xh select count (*) as count from(select * from (select '12' as businesstype, '' as baserealamount, '' as authorizedstate , '' as contractcode, p.agentcode, p.amount as amount, p.bankname, p.baseamount as baseamount, p.basecurrencycode, p.baseusedamount as baseusedamount, p.businessattr, p.canceldate, p.cancelflag, p.claimno, p.classescode, p.currencycode, p.custaccountno, p.custbankno, p.customercode, p.customername, p.applicantnamecn customernameen, p.customerpartyno, p.custseq, p.datasource, p.datatype, p.departmentcode, p.description, p.endorseno, p.fatherno, p.inpaymentbatchno, p.lastopdate, p.opcode, p.opdate, p.opstatus, p.policyno, p.risktype, p.subcompany, p.summaryno, p.createdate, p.unitcode, p.usedamount as usedamount, p.amount - p.usedamount as handledamount, p.baseamount - p.baseusedamount as handledbaseamount, '' as departmentname, 0 as baseleftamount, p.payableno as settlementno, p.usableno as usableno, p.payableseq, p.returnno, p.serialno, p.paytype, p.seqbusiness , p.paycode, p.billno, p.customerkeyword, p.ifsupplement , '' batchId, '' batchSummaryno, 0 batchAmount, '' AS actualcurrencycode, 0 AS actualexchangerate , p.confirmsequenceno , p.ifupload , 0 as seqinvply from mm_payablemoney_td p where 1=1 and p.inpaymentmethod != '04' and p.inpaymentflag = '0' and opstatus in ('0', '1') and subcompany = (:1) and datasource = (:2) and baseamount>0) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.own er = :3 and biz.powergrade='5' 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)))
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
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
asfsn2qvkj822select * 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.certitype = :2 AND t.inpaymentdepartment = :3 AND t.customername like :4 AND t.inpaymentflag = :5 AND t.datasource = :6) 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 ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:7 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)) ) where rownum <= :8
axxpjram6w68kdeclare batchid_out number; begin -- Call the procedure spcdms01.bfp_preposerls_pkg.do_extract(startopdate_in => date'2013-07-06', endopdate_in => date'2013-07-08', batchid_out => batchid_out); end;
bd502nbh9abbsselect s.synonym_name 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')
bhvyz9bgyrhb2SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.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, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) 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 c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (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# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
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 )
bvhrznagmf3m3update mm_payablemoney_list_td set hibernateversion=hibernateversion+1, lastopdate=sysdate, lastopcode=:1, realamount=:2, opstatus=:3, dcrmatchstatus=:4 where id=:5
c1vr2w9vja27pselect 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.inpaymentdepartment = :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 ='1698' ))) 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)))
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')
cbwszvzaby2r4insert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, classescode, currencycode, customername, datasource, departmentcode, departmentname, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
cndpkawm505jxselect count (*) as count from(select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate , receiptno from mm_inpayment_td i where saveflag = '0' and inpaymentflag='0' and opstatus in ('0', '1', '2') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) and amount >= :6 and amount <= :7and not exists (select 1 from mm_platformfile_detail_td t1 where exists (select 1 from mm_platformfile_td t2 where exists (select 1 from mm_bankplatform_tc t3 where t3.ifdirect = '1' and t3.platformid = t2.platformid) and t2.id = t1.platformfileid) and t1.inpaymentid = i.inpaymentid))
cwt8b6a6t8a79insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankname, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41)
d38x404f54ybsinsert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, claimno, currencycode, customername, datasource, departmentcode, departmentname, endorseno, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30)
d8m9rbpwuz01xselect * from ( select inpaymentid, unitcode, opdate, mmaccountid, accountno, currencycode, amount, basecurrencycode, baseamount, customername, customernameen, customerpartyno, agentcode, usedamount, auditstatus, dailyauditno, opcode, subcompany, coinpaymentid, description, coreason, nvl((select s.authorizedstate from mm_settlementcancel_td s where s.listno = i.inpaymentid), 1) as authorizedstate , receiptno from mm_inpayment_td i where saveflag = '0' and inpaymentflag='0' and opstatus in ('0', '1', '2') and subcompany = :1 and opdate between :2 and :3 and (opcode = :4 or :5 in (select p.businesscode from mm_permissions_td p where p.opcode = i.opcode)) and amount >= :6 and amount <= :7and not exists (select 1 from mm_platformfile_detail_td t1 where exists (select 1 from mm_platformfile_td t2 where exists (select 1 from mm_bankplatform_tc t3 where t3.ifdirect = '1' and t3.platformid = t2.platformid) and t2.id = t1.platformfileid) and t1.inpaymentid = i.inpaymentid) ) where rownum <= :8
dfzk5b2bw668m select tbl_.batchid, tbl_.policyno, tbl_.seqreportno, tbl_.voucherno, tbl_.voucherType, tbl_.businessType, tbl_.entered_Dr, tbl_.entered_Cr, tbl_.segment4, tbl_.reportKind, tbl_.segment1, tbl_.segment2, tbl_.accountingDate, tbl_.segment3, tbl_.segment5, tbl_.segment6, tbl_.segment7, tbl_.segment8, tbl_.currencyCode, tbl_.businessNo, tbl_.accounted_Cr, tbl_.attribute3, tbl_.customerCode, tbl_.customerName, tbl_.description, tbl_.opdate, tbl_.status, tbl_.accounted_Dr, tbl_.jeLineNo, tbl_.segment9, tbl_.segment10, tbl_.segment11, tbl_.segment12, tbl_.segment13, tbl_.segment14, tbl_.segment15, tbl_.segment16, tbl_.segment17, tbl_.segment18, tbl_.segment19, tbl_.segment20 from (select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= timestamp'2013-07-08 00:00:00' and bfp_voucherdetail_td.accountingDate < timestamp'2013-07-09 00:00:00' and bfp_voucherdetail_td.currencyCode = 'RMB' and bfp_voucherdetail_td.segment1 = 'SY' ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner ='002869' 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))) tbl_
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
fcsr3mt7jzznqSELECT NVL(MAX(TRIM(AGTYP)), 'AD') AGTYP, MAX(AGNAME) FROM RAS_AGPCONT@BFR WHERE INS_CODE=:B2 AND AGAGC=:B1
fgbmcgrgqa1zxupdate mm_policylist_legal set bpstatus = :1 , businessstatus = :2 , status = :3 , lastopcode = :4 , Lastopdate = :5 , errmsg = :6 where seqpolicy = :7
fnz13xnvkybtjINSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id, name_msg_code, flags, exec_name) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
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
fz0ya076jdvj1select 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.seqbusiness in (select b.seqbusiness from mm_policylist_legal b where b.seqbusiness=t.seqbusiness and policyno in( :1) ) AND t.createdate >= :2 AND t.createdate <:3+1) 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 ='1698' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:4 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)))
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
g4pqhxju85rdrselect count (*) as count from(select * from ( select bfp_voucherdetail_td.*, bfp_voucherdetail_td.segment2 as departmentcode from bfp_voucherdetail_td where 1=1 and bfp_voucherdetail_td.accountingDate >= :1 and bfp_voucherdetail_td.accountingDate < :2 and bfp_voucherdetail_td.currencyCode = :3 and bfp_voucherdetail_td.segment1 = :4 ) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:5 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)))
gbcsnmy9kqjm8insert into MM_PLATFORMFILE_DETAIL_TD (amount, batchno, batchserialno, businessno, cardflag, currencycode, currencyname, custaccountname, custaccountno, custbankarea, custbankcity, custbankcode, custbankprovince, customername, customertype, cvvcode, datasource, departmentcode, displayorder, fastflag, fundcategorycode, inpaymentflag, inpaymentid, ispublic, lastopcode, lastopdate, mmaccountid, mmaccountname, mmaccountno, mmbankcode, mmbankname, opcode, paydate, paytype, platformfileid, policyno, rowversion, settlementmode, subcompany, id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40)
gc8wdrc4ndxsbinsert into MM_PAYMENTIN_EVENTS_TD (amount, auditstatus, baseamount, basecurrencycode, businessone, businesstwo, currencycode, customercode, customername, datasource, departmentcode, departmentname, fromunitcode, hibernateversion, inpaymentflag, mmaccountid, newno, oldno, opcode, opcode2, opdate, opstatus, payablelistno, policyno, subcompany, tosubcompany, tounitcode, tradebatno, listno) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gnbryh5283zcpselect * 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.inpaymentdepartment = :2 AND t.customername like :3 AND t.inpaymentflag = :4 AND t.datasource = :5) 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 ='005174' ))) t where exists(select * from mm_commonpower_td biz where biz.powertype = 'USER-UNITPOWER' and biz.owner =:6 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)) ) where rownum <= :7
gtgdp28a44js0select * from MM_PAYABLEMONEY_LIST_TD where payableno = :1 order by amount, id

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count190.000.01
Batched IO (full) vector count00.000.00
Batched IO (space) vector count00.000.00
Batched IO block miss count1180.010.05
Batched IO buffer defrag count00.000.00
Batched IO double miss count70.000.00
Batched IO same unit count650.010.03
Batched IO single block count200.000.01
Batched IO slow jump count00.000.00
Batched IO vector block count300.000.01
Batched IO vector read count40.000.00
Block Cleanout Optim referenced2390.020.11
CCursor + sql area evicted2070.020.09
CPU used by this session96,8638.9942.99
CPU used when call started96,6718.9742.91
CR blocks created810.010.04
Cached Commit SCN referenced900.010.04
Clusterwide global transactions30.000.00
Commit SCN cached10.000.00
DB time902,09183.71400.40
DBWR checkpoint buffers written49,4684.5921.96
DBWR checkpoints60.000.00
DBWR fusion writes8260.080.37
DBWR object drop buffers written2,9690.281.32
DBWR tablespace checkpoint buffers written00.000.00
DBWR thread checkpoint buffers written1,0460.100.46
DBWR transaction table writes1690.020.08
DBWR undo block writes31,6042.9314.03
DFO trees parallelized1,1110.100.49
DX/BB enqueue lock background get time00.000.00
DX/BB enqueue lock background gets60.000.00
DX/BB enqueue lock foreground requests241,02722.37106.98
DX/BB enqueue lock foreground wait time2050.020.09
Effective IO time55,4355.1424.60
HSC Heap Segment Block Changes70,5216.5431.30
Heap Segment Array Inserts30,4182.8213.50
Heap Segment Array Updates5570.050.25
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued430.000.02
PX local messages recv'd6,5400.612.90
PX local messages sent6,5400.612.90
PX remote messages recv'd6,6300.622.94
PX remote messages sent6,6330.622.94
Parallel operations downgraded to serial00.000.00
Parallel operations not downgraded1,1110.100.49
RowCR - row contention00.000.00
RowCR attempts8940.080.40
RowCR hits8940.080.40
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink30.000.00
SQL*Net roundtrips to/from client146,10713.5664.85
SQL*Net roundtrips to/from dblink43,4304.0319.28
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout39,2203.6417.41
application wait time470.000.02
background checkpoints completed20.000.00
background checkpoints started20.000.00
background timeouts70,2946.5231.20
branch node splits220.000.01
buffer is not pinned count1,750,951162.48777.16
buffer is pinned count16,735,4361,552.957,428.07
bytes received via SQL*Net from client29,123,2492,702.4712,926.43
bytes received via SQL*Net from dblink122,704,72911,386.3154,462.82
bytes sent via SQL*Net to client49,423,3264,586.2121,936.67
bytes sent via SQL*Net to dblink8,690,550806.433,857.32
calls to get snapshot scn: kcmgss204,20918.9590.64
calls to kcmgas54,3715.0524.13
calls to kcmgcs257,71823.91114.39
cell physical IO interconnect bytes2,740,202,496254,275.361,216,246.11
change write time3290.030.15
cleanout - number of ktugct calls43,5934.0519.35
cleanouts and rollbacks - consistent read gets530.000.02
cleanouts only - consistent read gets6010.060.27
cluster key scan block gets1,8310.170.81
cluster key scans1,4010.130.62
cluster wait time1,1110.100.49
commit batch performed10.000.00
commit batch requested10.000.00
commit batch/immediate performed270.000.01
commit batch/immediate requested270.000.01
commit cleanout failures: block lost16,8991.577.50
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure440.000.02
commit cleanout failures: cannot pin00.000.00
commit cleanouts45,5314.2320.21
commit cleanouts successfully completed28,5882.6512.69
commit immediate performed260.000.01
commit immediate requested260.000.01
commit txn count during cleanout22,0462.059.79
concurrency wait time6770.060.30
consistent changes430,43939.94191.05
consistent gets168,183,99515,606.5374,648.91
consistent gets - examination470,55943.67208.86
consistent gets direct480.000.02
consistent gets from cache168,183,94715,606.5274,648.89
consistent gets from cache (fastpath)167,588,81715,551.3074,384.74
current blocks converted for CR00.000.00
cursor authentications3010.030.13
data blocks consistent reads - undo records applied2,1700.200.96
db block changes1,809,075167.87802.96
db block gets2,913,371270.341,293.11
db block gets direct210.000.01
db block gets from cache2,913,350270.341,293.10
db block gets from cache (fastpath)421,56739.12187.11
deferred (CURRENT) block cleanout applications4,9620.462.20
dirty buffers inspected30.000.00
enqueue conversions6,6360.622.95
enqueue releases157,10114.5869.73
enqueue requests161,11114.9571.51
enqueue timeouts4,0190.371.78
enqueue waits9,1440.854.06
exchange deadlocks10.000.00
execute count189,14917.5583.95
failed probes on index block reclamation40.000.00
free buffer inspected71,2756.6131.64
free buffer requested74,0086.8732.85
gc CPU used by this session5820.050.26
gc blocks lost80.000.00
gc cr block build time00.000.00
gc cr block flush time110.000.00
gc cr block receive time5070.050.23
gc cr block send time340.000.02
gc cr blocks received10,0820.944.47
gc cr blocks served14,1231.316.27
gc current block flush time80.000.00
gc current block pin time00.000.00
gc current block receive time2040.020.09
gc current block send time680.010.03
gc current blocks received5,3530.502.38
gc current blocks served23,9002.2210.61
gc local grants38,0753.5316.90
gc remote grants5,1260.482.28
gcs messages sent42,3413.9318.79
ges messages sent38,9583.6217.29
global enqueue get time3,3730.311.50
global enqueue gets async2,5420.241.13
global enqueue gets sync395,52736.70175.56
global enqueue releases260,79624.20115.75
heap block compress1,0330.100.46
hot buffers moved to head of LRU201,12318.6689.27
immediate (CR) block cleanout applications6540.060.29
immediate (CURRENT) block cleanout applications34,0143.1615.10
index crx upgrade (positioned)2,3590.221.05
index crx upgrade (prefetch)60.000.00
index fast full scans (full)2470.020.11
index fetch by key102,4829.5145.49
index scans kdiixs1810,34875.20359.68
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap live object count00.000.00
java call heap live object count max00.000.00
java call heap live size00.000.00
java call heap live size max00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
leaf node 90-10 splits860.010.04
leaf node splits8,7590.813.89
lob reads690.010.03
lob writes1430.010.06
lob writes unaligned1420.010.06
logons cumulative2,6360.241.17
messages received17,0301.587.56
messages sent17,0301.587.56
min active SCN optimization applied to CR270.000.01
no buffer to keep pinned count5,9380.552.64
no work - consistent read gets167,437,21715,537.2374,317.45
opened cursors cumulative179,83316.6979.82
parse count (describe)30.000.00
parse count (failures)160.000.01
parse count (hard)2,9780.281.32
parse count (total)76,8667.1334.12
parse time cpu4090.040.18
parse time elapsed4800.040.21
physical IO disk bytes2,740,202,496254,275.361,216,246.11
physical read IO requests8750.080.39
physical read bytes7,192,576667.433,192.44
physical read total IO requests43,1264.0019.14
physical read total bytes1,436,160,000133,267.56637,443.41
physical read total multi block requests3,0520.281.35
physical reads8780.080.39
physical reads cache7970.070.35
physical reads cache prefetch250.000.01
physical reads direct810.010.04
physical reads direct (lob)430.000.02
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests9,8130.914.36
physical write bytes435,511,29640,413.00193,302.84
physical write total IO requests16,5151.537.33
physical write total bytes1,304,042,496121,007.80578,802.71
physical write total multi block requests3,2510.301.44
physical writes53,1634.9323.60
physical writes direct540.010.02
physical writes direct (lob)150.000.01
physical writes direct temporary tablespace00.000.00
physical writes from cache53,1094.9323.57
physical writes non checkpoint48,9314.5421.72
pinned buffers inspected20.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use190.000.01
process last non-idle time10,8021.004.79
queries parallelized1,1110.100.49
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls291,84827.08129.54
recursive cpu usage7,2800.683.23
redo blocks checksummed by FG (exclusive)321,20129.81142.57
redo blocks written795,17373.79352.94
redo buffer allocation retries40.000.00
redo entries880,53381.71390.83
redo log space requests40.000.00
redo log space wait time120.000.01
redo ordering marks32,1532.9814.27
redo size393,212,42036,487.90174,528.37
redo size for direct writes172,78816.0376.69
redo subscn max counts2,2020.200.98
redo synch time290.000.01
redo synch writes1980.020.09
redo wastage621,57257.68275.89
redo write broadcast ack time20.000.00
redo write time6790.060.30
redo writer latching time00.000.00
redo writes2,3290.221.03
rollback changes - undo records applied510.000.02
rollbacks only - consistent read gets320.000.01
rows fetched via callback48,6254.5121.58
session connect time00.000.00
session cursor cache hits167,88415.5874.52
session logical reads171,097,36615,876.8775,942.02
shared hash latch upgrades - no wait44,9344.1719.94
shared hash latch upgrades - wait00.000.00
sorts (memory)52,6474.8923.37
sorts (rows)569,31152.83252.69
sql area evicted2,1980.200.98
sql area purged200.000.01
summed dirty queue length20.000.00
switch current to new buffer1,6910.160.75
table fetch by rowid8,664,803804.043,845.90
table fetch continued row245,53422.78108.98
table scan blocks gotten164,759,28615,288.7373,128.84
table scan rows gotten5,300,423,722491,849.472,352,607.07
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)50,6974.7022.50
total number of times SMON posted30.000.00
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks270.000.01
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size185,278,52817,192.8082,236.36
user I/O wait time7540.070.33
user calls221,71820.5798.41
user commits4310.040.19
user rollbacks1,8220.170.81
workarea executions - onepass00.000.00
workarea executions - optimal49,1114.5621.80
write clones created in background140.000.01
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 max13,259,715,732,59213,273,488,082,240
session cursor cache count2,970,9962,975,976
session uga memory11,248,425,398,46411,257,122,690,928
opened cursors current8277
logons current9684
session uga memory max471,198,029,592471,958,677,936
session pga memory2,306,653,094,9282,309,838,759,136

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)20.67

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 65708.051.005,4411750.13
UNDOTBS1 100.001.002,824000.00
SYSAUX 8707.701.001,395000.00
SYSTEM 12508.641.00151000.00
UNDOTBS2 100.001.001000.00
USERS 100.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 1906.321.0094000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.343.817492349 2609.231.002610380.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.344.817492455 3507.141.00194000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.345.817492553 17011.181.00275000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.346.817492653 2307.391.00135000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.347.817492751 4105.371.00154000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.348.817492851 1309.231.00123000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.364.798903927 8010.001.00125000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.365.798904013 7011.431.00114000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.366.798904069 10010.001.30123000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.367.798904121 1205.001.00125030.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.368.798904177 10015.001.00169080.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.369.798904231 15012.001.00173000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.370.798904285 605.001.00186000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.371.798904339 20014.001.00388000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.372.798904393 37011.081.00361010.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.373.798904447 16012.501.00164000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.374.798904501 6502.771.00251000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.375.798904557 2007.501.00189010.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.376.798904611 18011.111.00157000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.377.798904665 4705.321.00275020.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.378.798904719 26010.001.00179040.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.379.798904773 3108.711.00277000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.380.798904833 37012.161.00188090.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.381.798904897 1808.331.00182000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.382.798904949 3705.411.00216000.00
CDMS+ODS02_DATA/orcl11/datafile/cdms.383.798905003 4207.141.00294091.11
CDMS+ODS02_DATA/orcl11/datafile/cdms.387.817493043 100.001.0069000.00
SYSAUX+ODS02_DATA/orcl11/datafile/sysaux.353.798901157 8707.701.001,395000.00
SYSTEM+ODS02_DATA/orcl11/datafile/system.352.798901157 12508.641.00151000.00
UNDOTBS1+ODS02_DATA/orcl11/datafile/undotbs1.354.798901157 100.001.002,824000.00
UNDOTBS2+ODS02_DATA/orcl11/datafile/undotbs2.360.798901295 100.001.001000.00
USERS+ODS02_DATA/orcl11/datafile/users.355.798901157 100.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
D625,429100171,092,28579753,1090075


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

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D5120.1060,832115.53206,388,048
D1,0240.19121,66446.3482,778,952
D1,5360.29182,49625.9046,268,305
D2,0480.39243,32813.9624,936,950
D2,5600.49304,1607.1312,733,948
D3,0720.58364,9924.037,199,676
D3,5840.68425,8242.454,383,521
D4,0960.78486,6561.642,922,100
D4,6080.88547,4881.202,150,636
D5,1200.97608,3201.031,839,734
D5,2641.00625,4291.001,786,381
D5,6321.07669,1520.961,719,529
D6,1441.17729,9840.921,645,749
D6,6561.26790,8160.891,595,703
D7,1681.36851,6480.871,561,576
D7,6801.46912,4800.871,551,498
D8,1921.56973,3120.861,543,934
D8,7041.651,034,1440.861,540,715
D9,2161.751,094,9760.861,540,156
D9,7281.851,155,8080.861,538,716
D10,2401.951,216,6400.44789,445

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.004850

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,571525.790.000.000.000.00204,800
E2,0001,588476.970.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
2K4K48,63848,63800
64K128K272700
256K512K171700
512K1024K36436400
1M2M494900
2M4M141400
4M8M2200

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.13214,284.973,191.5699.0030264,039,329
5000.25214,284.97748.98100.00263,320,073
1,0000.50214,284.97742.38100.00063,318,131
1,5000.75214,284.97742.38100.00063,318,131
2,0001.00214,284.97742.38100.00063,318,131
2,4001.20214,284.97667.88100.00063,296,194
2,8001.40214,284.97667.88100.00063,296,194
3,2001.60214,284.97667.88100.00063,296,194
3,6001.80214,284.97667.88100.00063,296,194
4,0002.00214,284.97667.88100.00063,296,194
6,0003.00214,284.97667.88100.00063,296,194
8,0004.00214,284.97667.88100.00063,296,194
12,0006.00214,284.97667.88100.00063,296,194
16,0008.00214,284.97667.88100.00063,296,194

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,5360.6013012,160259,7090.995,2472.0918,069
1,7920.7038831,577260,6740.994,2821.7136,012
2,0480.8064346,847261,8781.003,0781.2336,158
2,3040.9091061,655262,2541.002,7021.0836,203
2,5601.001,17877,187262,4491.002,5071.0036,226
2,8161.101,43492,788262,5611.002,3950.9636,240
3,0721.201,689106,691262,6311.002,3250.9336,248
3,3281.301,945120,429262,6811.002,2750.9136,255
3,5841.402,201134,548262,7231.002,2330.8936,260
3,8401.502,457149,748262,7671.002,1890.8736,265
4,0961.602,713166,680262,8101.002,1460.8636,269
4,3521.702,969185,813262,8601.002,0960.8436,274
4,6081.803,225205,249262,8961.002,0600.8236,278
4,8641.903,481222,774262,9091.002,0470.8236,280
5,1202.003,737240,222262,9201.002,0360.8136,281

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.38587,75189,852,061
4,0000.50273,55427,067,660
5,0000.63177,2027,814,846
6,0000.75153,9703,171,705
7,0000.88147,8021,939,108
8,0001.00145,8331,786,373
9,0001.13144,9871,732,067
10,0001.25144,6231,695,089
11,0001.38144,4771,684,014
12,0001.50141,181856,923
13,0001.63140,423856,923
14,0001.75140,248856,923
15,0001.88140,131856,923
16,0002.00140,131856,923

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
160.500000
321.000000
481.500000
642.000000
802.500000
963.000000
1123.500000
1284.000000
1444.500000
1605.000000
1765.500000
1926.000000
2086.500000
2247.000000
2407.500000
2568.000000
2728.500000
2889.000000
3049.500000
32010.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
320.3336710,2501.002,5071.0011,683
480.501223110,2501.002,5071.0040,490
640.671323310,2501.002,5071.0040,490
800.831323310,2501.002,5071.0040,490
961.001323310,2501.002,5071.0040,490
1121.171323310,2501.002,5071.0040,490
1281.331323310,2501.002,5071.0040,490
1441.501323310,2501.002,5071.0040,490
1601.671323310,2501.002,5071.0040,490
1761.831323310,2501.002,5071.0040,490
1922.001323310,2501.002,5071.0040,490
2082.171323310,2501.002,5071.0040,490

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block7400
1st level bmb100

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 9,2498,8214283,76110.27
WF-AWR Flush 6060029132.76
CO-KTUCLO Master Slave enq (master slave det) 3,59003,5903,59010.26
RO-Multiple Object Reuse (fast object reuse) 3636010021.00
TM-DML 14,16814,168065400.28
CF-Controlfile Transaction 24,13824,137155600.25
FB-Format Block 750750035600.20
HW-Segment High Water Mark 4,7344,73409800.41
MW-MWIN Schedule 660603.33
PR-Process Startup 2452450306.67
TA-Instance Undo 353503500.29
TT-Tablespace 58558502400.42
TX-Transaction (index contention) 1101010.00
TO-Temp Object 141401000.00
DR-Distributed Recovery 660600.00
JS-Job Scheduler (job run lock - synchronize) 550500.00
PI-Remote PX Process Spawn Status 990300.00
US-Undo Segment 330200.00
AF-Advisor Framework (task serialization) 21210100.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 110100.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
231.4514,0471,047420.2/330/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
09-Jul 13:50149041320/00/0/0/0/0/0
09-Jul 13:40121789973300/00/0/0/0/0/0
09-Jul 13:3095403972330/00/0/0/0/0/0
09-Jul 13:2031021,0051300/00/0/0/0/0/0
09-Jul 13:10044040330/00/0/0/0/0/0
09-Jul 13:001551541,0093300/00/0/0/0/0/0
09-Jul 12:5015,3306,4094084330/00/0/0/0/0/0
09-Jul 12:402501,0161300/00/0/0/0/0/0
09-Jul 12:30084150330/00/0/0/0/0/0
09-Jul 12:206458921,0203300/00/0/0/0/0/0
09-Jul 12:1014,3105,5124194330/00/0/0/0/0/0
09-Jul 12:003062251,0264300/00/0/0/0/0/0
09-Jul 11:5052694253330/00/0/0/0/0/0
09-Jul 11:4025151,0352300/00/0/0/0/0/0
09-Jul 11:307434342200/00/0/0/0/0/0
09-Jul 11:2015481,0412300/00/0/0/0/0/0
09-Jul 11:101392264403200/00/0/0/0/0/0
09-Jul 11:002391681,0473300/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 latch7,2970.00 00 
ASM map headers560.00 00 
ASM map load waiting list120.00 00 
ASM map operation freelist1620.00 00 
ASM map operation hash table147,3410.000.0000 
ASM network SGA latch60.00 00 
ASM network background latch5,0020.00 00 
ASM scan context latch80.00 00 
AWR Alerted Metric Element list83,8030.00 00 
Change Notification Hash table latch3,5910.00 00 
Consistent RBA2,3310.00 00 
DML lock allocation28,4320.00 00 
Event Group Locks4340.00 00 
FAL request queue2920.00 00 
FIB s.o chain latch280.00 00 
FOB s.o list latch1,3590.00 00 
File State Object Pool Parent Latch30.00 00 
IPC stats buffer allocation latch5,5170.00 05,4680.00
In memory undo latch30.00 00 
JOX JIT latch250.001.00020.00
JOX SGA heap latch600.00 00 
JS Sh mem access250.00 00 
JS broadcast add buf latch2,4840.00 00 
JS broadcast autostart latch20.00 00 
JS broadcast drop buf latch2,4840.00 00 
JS broadcast load blnc latch2,1600.00 00 
JS mem alloc latch140.00 00 
JS queue access latch170.00 00 
JS queue state obj latch78,4160.00 00 
JS slv state obj latch5700.00 00 
KFC FX Hash Latch30.00 00 
KFC Hash Latch30.00 00 
KFCL LE Freelist30.00 00 
KFK SGA Libload latch5010.00 00 
KFMD SGA1200.00 00 
KFR redo allocation latch30.00 00 
KGNFS-NFS:SHM structure30.00 00 
KGNFS-NFS:SVR LIST30.00 00 
KJC message pool free list4,3940.070.0002,9690.00
KJCT flow control latch103,9420.010.0000 
KMG MMAN ready and startup request latch3,5910.00 00 
KSXR large replies7180.00 00 
KTF sga latch1680.00 03,3820.00
KWQMN job cache list latch1,1320.00 00 
KWQP Prop Status60.00 00 
KWQS pqueue ctx latch60.00 00 
Locator state objects pool parent latch30.00 00 
MQL Tracking Latch0  02150.00
Memory Management Latch30.00 03,5910.00
Memory Queue30.00 00 
Memory Queue Message Subscriber #130.00 00 
Memory Queue Message Subscriber #230.00 00 
Memory Queue Message Subscriber #330.00 00 
Memory Queue Message Subscriber #430.00 00 
Memory Queue Subscriber30.00 00 
MinActiveScn Latch247,0870.000.0000 
Mutex30.00 00 
Mutex Stats30.00 00 
OS process2,8020.00 00 
OS process allocation5,4450.00 00 
OS process: request allocation8740.00 00 
PL/SQL warning settings4,4860.00 00 
QMT30.00 00 
Real-time plan statistics latch51,3300.00 00 
SGA IO buffer pool latch440.00 0500.00
SGA blob parent30.00 00 
SGA bucket locks30.00 00 
SGA heap locks30.00 00 
SGA pool locks30.00 00 
SQL memory manager latch30.00 03,5890.00
SQL memory manager workarea list latch406,3930.00 00 
Shared B-Tree3930.00 00 
Streams Generic30.00 00 
Testing30.00 00 
Token Manager30.00 00 
Write State Object Pool Parent Latch30.00 00 
XDB NFS Security Latch30.00 00 
XDB unused session pool30.00 00 
XDB used session pool30.00 00 
active checkpoint queue latch21,0700.050.0000 
active service list137,4340.00 013,0920.00
alert log latch40.00 00 
archive control1,3360.00 00 
archive process latch4,1770.021.0000 
begin backup scn array160.00 00 
buffer pool30.00 00 
business card2,2250.00 00 
cache buffer handles20,5040.00 00 
cache buffers chains346,068,9160.030.000468,5660.00
cache buffers lru chain140,2780.000.000470,4300.00
cache table scan latch10.00 010.00
cas latch30.00 00 
change notification client cache latch30.00 00 
channel handle pool latch9220.00 00 
channel operations parent latch1,769,9960.020.0000 
checkpoint queue latch1,351,8160.000.00053,2290.00
client/application info12,3190.00 00 
commit callback allocation70.00 00 
compile environment latch2,6410.00 00 
corrupted undo seg lock1800.00 00 
cp cmon/server latch30.00 00 
cp pool latch30.00 00 
cp server hash latch30.00 00 
cp sga latch1820.00 00 
cvmap freelist lock30.00 00 
deferred cleanup latch1820.00 00 
dictionary lookup40.00 00 
dml lock allocation1820.00 00 
done queue latch30.00 00 
dummy allocation5,2970.00 00 
enqueue hash chains385,4850.00 070.00
enqueues260,4570.000.0000 
error message lists5,5190.00 00 
fifth spare latch30.00 00 
file cache latch2,1900.00 00 
flashback archiver latch360.00 00 
flashback copy30.00 00 
gc element226,4490.050.0002250.00
gcs commit scn state30.00 00 
gcs opaque info freelist44,8760.140.0000 
gcs partitioned table hash29,497,2850.000.00031,2910.00
gcs pcm hashed value bucket hash30.00 00 
gcs remaster request queue550.00 00 
gcs remastering latch1,3120.00 00 
gcs resource freelist21,8170.000.0003,2870.00
gcs resource hash242,8090.060.0000 
gcs resource scan list30.00 00 
gcs shadows freelist20,3870.00 021,7540.00
ges caches resource lists88,2060.020.000133,9640.02
ges deadlock list14,4620.00 00 
ges domain table297,0440.00 00 
ges enqueue table freelist534,7280.000.0000 
ges group table437,5000.00 00 
ges process hash list7,0170.00 00 
ges process parent latch1,096,7630.00 00 
ges process table freelist8740.00 00 
ges resource hash list957,7600.060.01021,6110.01
ges resource scan list1,3270.00 00 
ges resource table freelist40,7000.020.0000 
ges timeout list3,4420.00 05200.00
ges value block free list233,8610.00 00 
global KZLD latch for mem in SGA1800.00 00 
global tx hash mapping116,9500.00 00 
granule operation30.00 00 
hash table column usage latch3570.00 032,8990.00
hash table modification latch3040.00 00 
heartbeat check30.00 02,1530.00
intra txn parallel recovery30.00 00 
io pool granule metadata list30.00 00 
job workq parent latch30.00 0140.00
job_queue_processes parameter latch2,5430.00 00 
k2q global data latch7,1950.00 00 
k2q lock allocation233,8110.00 00 
kdlx hb parent latch30.00 00 
kgb parent30.00 00 
kks stats15,5310.00 00 
kokc descriptor allocation latch8,6060.00 00 
ksfv messages30.00 00 
ksim membership request latch8120.00 06,9600.00
kss move lock1090.00 00 
ksuosstats global area7270.00 00 
ksv allocation latch3950.00 00 
ksv class latch13,3650.010.0000 
ksv msg queue latch310.00 0280.00
ksxp shared latch8740.00 00 
ksz_so allocation latch8740.00 00 
ktm global data620.00 00 
kwqbsn:qsga3810.00 00 
lgwr LWN SCN5,0950.00 00 
list of block allocation2,1050.00 00 
loader state object freelist1300.00 00 
lob segment dispenser latch30.00 00 
lob segment hash table latch390.00 00 
lob segment query latch30.00 00 
lock DBA buffer during media recovery30.00 00 
logical standby cache30.00 00 
logminer context allocation60.00 00 
logminer work area30.00 00 
longop free list parent30.00 00 
mapped buffers lru chain30.00 00 
message pool operations parent latch27,3540.00 00 
messages456,2970.010.0000 
mostly latch-free SCN5,1040.00 00 
msg queue latch30.00 00 
multiblock read objects6,3060.00 00 
name-service memory objects35,9270.00 00 
name-service namespace bucket73,0640.00 00 
name-service pending queue19,6820.00 00 
name-service request320.00 00 
name-service request queue123,4150.00 00 
ncodef allocation latch1820.00 00 
object queue header heap85,2650.00 01,5210.07
object queue header operation1,145,8000.010.1300 
object stats modification880.00 00 
parallel query alloc buffer32,2960.00 00 
parallel query stats5,5390.00 00 
parallel txn reco latch2,0650.00 00 
parameter list1,9000.00 00 
parameter table management5,3250.00 00 
peshm30.00 00 
pesom_free_list1,1870.00 00 
pesom_hash_node1,1870.00 00 
pesom_heap_alloc130.00 00 
post/wait queue5120.200.0003550.00
process allocation50,7940.000.0004310.00
process group creation8740.00 00 
process queue15,4590.00 00 
process queue reference453,3740.010.00043,9870.05
qmn task queue latch2,2774.700.0700 
query server freelists12,1620.00 00 
query server process60.00 050.00
queued dump request360.00 00 
recovery domain hash list30.00 00 
redo allocation12,5670.170.000880,5830.00
redo copy30.00 0880,5950.00
redo writing35,6120.030.0000 
resmgr group change latch4,5610.00 00 
resmgr:active threads5,2970.00 00 
resmgr:actses change group2,4480.00 00 
resmgr:actses change state30.00 00 
resmgr:free threads list5,2940.00 00 
resmgr:plan CPU method30.00 00 
resmgr:resource group CPU method30.00 00 
resmgr:schema config1630.00 00 
resmgr:session queuing30.00 00 
rm cas latch30.00 00 
row cache objects998,4180.000.0002490.00
rules engine rule set statistics3000.00 00 
second spare latch30.00 00 
segmented array pool120.00 00 
sequence cache50,9130.00 00 
session allocation59,8640.290.0200 
session idle bit456,7630.00 00 
session queue latch30.00 00 
session state list latch5,3280.00 00 
session switching1850.00 00 
session timer3,8140.00 00 
shared pool322,9850.000.0000 
shared pool sim alloc30.00 00 
shared pool simulator21,9740.00 00 
sim partition latch30.00 00 
simulator hash latch10,795,6630.000.0000 
simulator lru latch30.00 010,790,7940.05
sort extent pool5470.00 00 
space background state object latch320.00 00 
space background task latch7,9560.010.0007,1800.00
state object free list60.00 00 
statistics aggregation6,0480.00 00 
tablespace key chain30.00 00 
temp lob duration state obj allocation60.00 00 
temporary table state object allocation40.00 00 
test excl. parent l030.00 00 
test excl. parent2 l030.00 00 
third spare latch30.00 00 
threshold alerts latch4590.00 00 
transaction allocation2400.00 00 
transaction branch allocation3,8270.00 00 
undo global data809,7260.00 00 
user lock7490.00 00 
virtual circuit buffers30.00 00 
virtual circuit holder30.00 00 
virtual circuit queues30.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains346,068,916102,48220102,498
ges resource hash list957,7605583555
session allocation59,8641744170
qmn task queue latch2,277107899
object queue header operation1,145,800911281
JOX JIT latch2110
archive process latch4,177110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
PC and Classifier lists for WLMNo latch011
archive process latchkcrrgpll010
cache buffers chainskcbgtcr: fast path (cr pin)01912
cache buffers chainskcbbxsv033
cache buffers chainskcbchg1: kslbegin: bufs not pinned021
cache buffers chainskcbgtcr: kslbegin excl016
cache buffers chainskcbrls_2012
ges resource hash listkjakcai: search for resp by resname010
ges resource hash listkjlmfnd: search for lockp by rename and inst id010
ges resource hash listkjucvl: lock convert request010
object queue header operationkcbo_write_q0100
object queue header operationkcbo_service_ockpt030
qmn task queue latchkwqmnmvtsks: delay to ready list080
session allocationksuxds: KSUSFCLC not set040

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekgllkdl1 8510
Library Cachekglpnck1 8810

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 TABLE138,366,52880.87
SPCDMS01CDMSMM_PAYABLEMONEY_LIST_TD TABLE20,897,18412.21
SPCDMS01CDMSMM_LEGALDATA_MODIFY_LOG_TD TABLE2,860,8801.67
SPCDMS01CDMSMM_POLICY_LEGAL TABLE1,082,0960.63
SPCDMS01CDMSMM_PLATFORMFILE_DETAIL_TD TABLE931,3440.54

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SPCDMS01CDMSIDX_PAYMENTINE_02 INDEX9110.36
SPCDMS01CDMSIND_POLICY_TI INDEX525.92
SPCDMS01CDMSIDX_PAYMENTINE_05 INDEX465.24
SPCDMS01CDMSIDX_MIRRORDETAIL_01 INDEX353.99
SPCDMS01CDMSIDX_PAYABLEMONEY_02 INDEX313.53

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 TABLE4,0767.67
SPCDMS01CDMSRLS_TEMP_LFPAPPL TABLE3,0235.69
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX2,2244.18
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX2,1754.09
SPCDMS01CDMSIND_POLICY_TI INDEX1,1822.22

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXSYS_LOB0000005981C00038$$ LOB1527.78

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX114.45
SPCDMS01CDMSIDX_PLATFORMFILE_DETAIL_01 INDEX104.05

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX187,84020.24
SPCDMS01CDMSIDX_LFPAPPL_01 INDEX187,71220.23
SPCDMS01TEMPIDX_RLS_TEMP_LFPPML01 INDEX180,83219.48
SPCDMS01TEMPIDX_RLS_TEMP_LFPPML01 INDEX180,46419.44
SPCDMS01TEMPRLS_TEMP_LFPPML TABLE30,0323.24

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SPCDMS01CDMSMM_POLICYLIST_TI TABLE3952.00
SPCDMS01CDMSIDX_POLICYLIST_TI_03 INDEX1520.00
SPCDMS01CDMSIDX_POLICY_TI_02 INDEX1114.67
SPCDMS01CDMSMM_POLICY_TI TABLE912.00
SPCDMS01CDMSMM_EVENTS_TI TABLE11.33

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
SPCDMS01CDMSMM_POLICY_TI TABLE1,97219.56
SPCDMS01CDMSBFP_VOUCHERDETAIL_TD TABLE9949.86
SPCDMS01CDMSBFP_MIRRORDETAIL_TD TABLE7407.34
SPCDMS01CDMSBFP_TEMP_DCRD TABLE6426.37
SPCDMS01CDMSMM_POLICY_LEGAL TABLE5645.59

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SPCDMS01CDMSIND_POLICY_TI INDEX65412.22
SPCDMS01CDMSIDX_PAYABLEMONEY_01 INDEX4788.93
SPCDMS01CDMSIDX_PAYMENTINE_05 INDEX4277.98
SPCDMS01CDMSMM_POLICY_TI TABLE2584.82
SPCDMS01CDMSBFP_RISKSPLIT_TD TABLE2013.75

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_control1863.230 01
dc_database_links14,7150.010 05
dc_global_oids5,3930.000 0324
dc_histogram_data59,6000.190 06,152
dc_histogram_defs19,4001.710 09,379
dc_object_grants365.560 0830
dc_objects48,3320.190 64,248
dc_profiles1840.000 01
dc_rollback_segments4,3980.000 061
dc_segments11,7970.070 3102,194
dc_sequences1,2350.810 1,2356
dc_tablespace_quotas2770.000 2771
dc_tablespaces86,2280.000 08
dc_users103,2970.000 2196
global database name9,6720.000 02
outstanding_alerts12671.430 01

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control660
dc_database_links100
dc_histogram_defs331027
dc_objects455256
dc_segments622311
dc_sequences2,47070
dc_tablespace_quotas55410
dc_users800
outstanding_alerts252900

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1452.071,4270.2800
CLUSTER1270.00760.0000
INDEX382.63352.8600
JAVA DATA40.000 00
SQL AREA16,64645.97221,1123.842243,680
TABLE/PROCEDURE37,7570.2269,1410.301280
TRIGGER1,1160.541,1160.5400

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER7676000
INDEX3535000
TABLE/PROCEDURE12,32357,903000

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,264.005,264.005,264.005,264.000INI/
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 pool96.0096.0096.0096.000STA/
large pool16.0016.0016.0016.000STA/
shared pool2,544.002,544.002,544.002,544.000STA/
streams pool32.0032.0032.0032.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
BOther480.90 4.866.9425269999
 Freeable40.810.001.071.026 3838
 JAVA2.362.361.181.672422
 SQL1.010.490.020.03086649
 PL/SQL0.720.290.010.03009797
EOther440.76 5.077.3825268787
 Freeable34.810.001.201.156 2929
 SQL0.850.420.020.03085547
 PL/SQL0.570.170.010.03008584

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers5,519,704,064 
Fixed Size2,176,320 
Redo Buffers10,694,656 
Variable Size2,818,575,040 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory84.3584.350.00
javajoxlod exec hp11.1911.190.00
largeASM map operations hashta0.380.380.00
largePX msg pool1.031.030.00
largefree memory14.6014.600.00
sharedASH buffers40.5040.500.00
sharedCCursor181.43184.451.66
sharedKGL handle63.1063.400.47
sharedPCursor136.97137.760.57
shareddb_block_hash_buckets44.5044.500.00
sharedfree memory317.72316.38-0.42
sharedgcs resources103.93103.930.00
sharedgcs shadows69.2869.280.00
sharedkglsim object batch39.1339.130.00
sharedsql area1,153.531,150.14-0.29
streamsfree memory31.9431.940.00
 buffer_cache5,264.005,264.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

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves8,99800
QMON Coordinator1,00000

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

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R00000

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_number1  
local_listenerLISTENER_ORCL111  
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  
service_namesorcl11  
sessions885  
sga_target8388608000  
spfile+ODS02_DATA/orcl11/spfileorcl11.ora  
thread1  
undo_tablespaceUNDOTBS1  


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)3,6600.341.62
acks for commit broadcast(logical)3,6790.341.63
broadcast msgs on commit(actual)2,2430.211.00
broadcast msgs on commit(logical)2,2440.211.00
broadcast msgs on commit(wasted)4140.040.18
broadcast on commit wait time(ms)110.000.00
broadcast on commit waits110.000.00
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
false posts waiting for scn acks00.000.00
flow control messages received20.000.00
flow control messages sent60.000.00
gcs assume cvt00.000.00
gcs assume no cvt18,5361.728.23
gcs ast xid10.000.00
gcs blocked converts4,7650.442.11
gcs blocked cr converts9,4640.884.20
gcs compatible basts610.010.03
gcs compatible cr basts (global)4530.040.20
gcs compatible cr basts (local)17,7881.657.90
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs7430.070.33
gcs dbwr write request msgs4130.040.18
gcs error msgs00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts3170.030.14
gcs immediate (null) converts7,9650.743.54
gcs immediate cr (compatible) converts00.000.00
gcs immediate cr (null) converts3,0280.281.34
gcs indirect ast2,0530.190.91
gcs indirect bidless ast00.000.00
gcs indirect fg ast2,0530.190.91
gcs lms flush pi msgs00.000.00
gcs lms write request msgs2190.020.10
gcs msgs process time(ms)1,1590.110.51
gcs msgs received76,8367.1334.10
gcs new served by master7,0410.653.13
gcs out-of-order msgs60.000.00
gcs pings refused10.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 xid10.000.00
gcs regular cr00.000.00
gcs retry convert request10.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual2,0570.190.91
gcs side channel msgs logical16,6161.547.38
gcs stale cr00.000.00
gcs undo cr8,5270.793.78
gcs write notification msgs220.000.01
gcs writes refused140.000.01
ges msgs process time(ms)2990.030.13
ges msgs received30,4842.8313.53
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 received6740.060.30
implicit batch messages sent5400.050.24
lmd msg send time(ms)10.000.00
lms(s) msg send time(ms)00.000.00
messages flow controlled1,7480.160.78
messages queue sent actual22,8232.1210.13
messages queue sent logical23,5152.1810.44
messages received actual74,9676.9633.27
messages received logical107,3219.9647.63
messages sent directly33,7123.1314.96
messages sent indirectly22,2282.069.87
messages sent not implicit batched22,2832.079.89
messages sent pbatched41,0343.8118.21
msgs causing lmd to send msgs9,2980.864.13
msgs causing lms(s) to send msgs1,4660.140.65
msgs received queue time (ms)150.000.01
msgs received queued107,3219.9647.63
msgs sent queue time (ms)20,917,9461,941.079,284.49
msgs sent queue time on ksxp (ms)41,7173.8718.52
msgs sent queued23,4362.1710.40
msgs sent queued on ksxp57,8525.3725.68
process batch messages received27,9822.6012.42
process batch messages sent18,2511.698.10


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests4,715
CURRENT Block Requests9,462
Data Block Requests4,715
Undo Block Requests8,527
TX Block Requests608
Current Results14,100
Private results0
Zero Results77
Disk Read Results0
Fail Results0
Fairness Down Converts776
Fairness Clears241
Free GC Elements0
Flushes74
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works24
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins24,034100.000.000.000.000.00
Flushes1560.0020.0020.000.000.00
Writes82667.9225.425.210.610.85


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
2data block9,70099.840.160.005,12799.690.310.00
2Others30299.670.330.0018799.470.530.00
2undo header6088.3311.670.002688.4611.540.00
2undo block633.3366.670.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
2data block0.530.522.55 0.410.412.23 
2others0.300.287.81 0.270.270.26 
2undo header0.560.233.03 0.690.273.88 
2undo block0.650.270.84     

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
2data block09,684100.000.005,111100.000.00
2others0301100.000.00186100.000.00
2undo header053100.000.0023100.000.00
2undo 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
2data block 0.520.52 0.410.41 
2others 0.280.28 0.270.27 
2undo header 0.230.23 0.270.27 
2undo block 0.270.27    

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

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.030.01
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.3NOOracle Cluster Repository 1.160000 1.020000

Back to Interconnect Stats
Back to Top

End of Report