WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
MIDDB1267950709middb110.2.0.5.0NOmiddb

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:21218-Jul-13 10:00:29356 8.0
End Snap:21318-Jul-13 11:00:31355 9.0
Elapsed:  60.03 (mins)  
DB Time:  216.36 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,648M 1,648MStd Block Size: 8K
Shared Pool Size: 352M 352MLog Buffer: 14,312K

Load Profile

Per SecondPer Transaction
Redo size: 144,313.29 2,633.01
Logical reads: 684,035.83 12,480.30
Block changes: 534.55 9.75
Physical reads: 0.06 0.00
Physical writes: 13.30 0.24
User calls: 549.53 10.03
Parses: 175.28 3.20
Hard parses: 0.10 0.00
Sorts: 1.39 0.03
Logons: 0.03 0.00
Executes: 264.86 4.83
Transactions: 54.81 

% Blocks changed per Read: 0.08Recursive Call %: 21.61
Rollback per transaction %: 0.02Rows per Sort: 13.57

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 99.84Soft Parse %: 99.94
Execute to Parse %: 33.82Latch Hit %: 97.07
Parse CPU to Parse Elapsd %: 91.48% Non-Parse CPU: 99.85

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.29 85.62
% SQL with executions>1: 93.82 89.16
% Memory for SQL w/exec>1: 89.28 82.38

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  12,926  99.6 
log file sync 207,381 323 2 2.5Commit
log file parallel write 193,160 222 1 1.7System I/O
SQL*Net more data from client 345,720 46 0 .4Network
SQL*Net more data to client 211,972 5 0 .0Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 12,926.30 99.58
sql execute elapsed time 12,305.42 94.79
parse time elapsed 23.64 0.18
hard parse elapsed time 2.21 0.02
PL/SQL execution elapsed time 1.55 0.01
repeated bind elapsed time 0.60 0.00
sequence load elapsed time 0.57 0.00
hard parse (sharing criteria) elapsed time 0.36 0.00
failed parse elapsed time 0.34 0.00
PL/SQL compilation elapsed time 0.22 0.00
connection management call elapsed time 0.16 0.00
hard parse (bind mismatch) elapsed time 0.15 0.00
DB time 12,981.38  
background elapsed time 251.45  
background cpu time 42.24  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     12,926   99.58
Commit 207,381 0 323 2 2.49
System I/O 202,475   225 1 1.74
Network 1,920,802   53 0 0.41
User I/O 2,302   3 1 0.02
Concurrency 36,878 0 1 0 0.01
Configuration 45   0 5 0.00
Other 1,044 7 0 0 0.00
Application 306   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file sync 207,381 0 323 2 1.05
log file parallel write 193,160   222 1 0.98
SQL*Net more data from client 345,720   46 0 1.75
SQL*Net more data to client 211,972   5 0 1.07
Log file init write 2,010   3 1 0.01
SQL*Net message to client 1,363,110   2 0 6.90
control file parallel write 1,750   2 1 0.01
Log archive I/O 553   1 2 0.00
latch: cache buffers chains 33,097   1 0 0.17
os thread startup 20   0 23 0.00
log file sequential read 575   0 0 0.00
log file switch completion 14   0 15 0.00
buffer busy waits 2,290   0 0 0.01
latch: In memory undo latch 1,366   0 0 0.01
control file sequential read 6,420   0 0 0.03
cursor: pin S wait on X 6 67 0 7 0.00
SQL*Net break/reset to client 306   0 0 0.00
rdbms ipc reply 92   0 0 0.00
LGWR wait for redo copy 852   0 0 0.00
latch free 4   0 5 0.00
enq: TX - index contention 97   0 0 0.00
db file sequential read 228   0 0 0.00
db file scattered read 10   0 1 0.00
direct path sync 6   0 2 0.00
db file single write 27   0 0 0.00
enq: SQ - contention 23   0 0 0.00
latch: session allocation 13   0 0 0.00
library cache load lock 2   0 2 0.00
enq: TX - contention 5   0 1 0.00
enq: HW - contention 7   0 0 0.00
log file single write 17   0 0 0.00
buffer deadlock 73 100 0 0 0.00
latch: redo writing 1   0 0 0.00
latch: enqueue hash chains 2   0 0 0.00
direct path read 14   0 0 0.00
cursor: pin S 3   0 0 0.00
direct path write 7   0 0 0.00
SQL*Net message from client 1,363,151   1,173,534 861 6.91
Streams AQ: qmn slave idle wait 129   3,531 27372 0.00
Streams AQ: qmn coordinator idle wait 259 50 3,531 13633 0.00
wait for unread message on broadcast channel 3,598 100 3,517 978 0.02
Streams AQ: waiting for time management or cleanup tasks 54 67 3,517 65133 0.00
Streams AQ: waiting for messages in the queue 720 100 3,516 4884 0.00
virtual circuit status 120 100 3,516 29297 0.00
jobq slave wait 1,190 96 3,481 2925 0.01
class slave wait 8   0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 193,160   222 1 0.98
control file parallel write 1,660   2 1 0.01
Log archive I/O 553   1 2 0.00
os thread startup 20   0 23 0.00
log file sequential read 565   0 0 0.00
events in waitclass Other 944   0 0 0.00
control file sequential read 3,798   0 0 0.02
db file single write 27   0 0 0.00
log file single write 7   0 0 0.00
latch: redo writing 1   0 0 0.00
db file sequential read 27   0 0 0.00
buffer busy waits 4   0 0 0.00
rdbms ipc message 206,877 7 45,081 218 1.05
Streams AQ: qmn slave idle wait 129   3,531 27372 0.00
Streams AQ: qmn coordinator idle wait 259 50 3,531 13633 0.00
pmon timer 1,223 100 3,519 2877 0.01
Streams AQ: waiting for time management or cleanup tasks 54 67 3,517 65133 0.00
smon timer 38 13 3,500 92103 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 1,310,785
IDLE_TIME 7,332,520
IOWAIT_TIME 20,034
NICE_TIME 41
SYS_TIME 12,817
USER_TIME 1,290,451
LOAD 6
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 1,617,920
VM_OUT_BYTES 4,846,764,032
PHYSICAL_MEMORY_BYTES 33,712,242,688
NUM_CPUS 24
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
middb 12,966.30 12,910.30 58 2,463,361,892
SYS$USERS 14.10 15.10 144 67,684
SYS$BACKGROUND 0.00 0.00 23 24,401
middbXDB 0.00 0.00 0 0

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
middb 2035 3 36854 1 0 0 1916991 53
SYS$USERS 180 0 0 0 0 0 3632 0
SYS$BACKGROUND 87 0 24 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
3,874 3,957 18,345 0.21 29.84 2ax73suj5nyka JDBC Thin Client SELECT SUM(PL.GROSSPREMIUM) FR...
2,480 2,533 24,573 0.10 19.11 3r1uzmbwxhw3p JDBC Thin Client select insureinfo0_.POLICYSERI...
1,816 1,849 73,018 0.02 13.99 6hhyacc5t6kmk JDBC Thin Client select this_.SERIALNO as SERIA...
1,218 1,244 24,368 0.05 9.38 3rm6gtwn27uq4 JDBC Thin Client select beneficiar0_.PARENTSERI...
754 765 122,799 0.01 5.81 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
520 530 24,547 0.02 4.01 6x0wjqbj0rfrp JDBC Thin Client select insurancep0_.POLICYSERI...
186 190 6,798 0.03 1.44 0a98unb7db9f0 JDBC Thin Client select this_.SERIALNO as SERIA...
20 20 98,359 0.00 0.16 fbgc81kg73hks JDBC Thin Client update INSURANCEPOLICYPROCESS ...
18 18 49,269 0.00 0.14 9mq1qhcf3w76j JDBC Thin Client update INSURANCEPOLICY set AGE...
9 10 24,635 0.00 0.07 60pyjj5z447w1 JDBC Thin Client insert into PAYMENTACCOUNT (AC...

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
3,957 3,874 18,345 0.22 30.61 29.84 2ax73suj5nyka JDBC Thin Client SELECT SUM(PL.GROSSPREMIUM) FR...
2,533 2,480 24,573 0.10 19.60 19.11 3r1uzmbwxhw3p JDBC Thin Client select insureinfo0_.POLICYSERI...
1,849 1,816 73,018 0.03 14.31 13.99 6hhyacc5t6kmk JDBC Thin Client select this_.SERIALNO as SERIA...
1,244 1,218 24,368 0.05 9.62 9.38 3rm6gtwn27uq4 JDBC Thin Client select beneficiar0_.PARENTSERI...
765 754 122,799 0.01 5.92 5.81 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
530 520 24,547 0.02 4.10 4.01 6x0wjqbj0rfrp JDBC Thin Client select insurancep0_.POLICYSERI...
190 186 6,798 0.03 1.47 1.44 0a98unb7db9f0 JDBC Thin Client select this_.SERIALNO as SERIA...
20 20 98,359 0.00 0.16 0.16 fbgc81kg73hks JDBC Thin Client update INSURANCEPOLICYPROCESS ...
18 18 49,269 0.00 0.14 0.14 9mq1qhcf3w76j JDBC Thin Client update INSURANCEPOLICY set AGE...
10 9 24,635 0.00 0.07 0.07 60pyjj5z447w1 JDBC Thin Client insert into PAYMENTACCOUNT (AC...

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
1,156,601,314 18,345 63,047.22 46.95 3956.90 3873.94 2ax73suj5nyka JDBC Thin Client SELECT SUM(PL.GROSSPREMIUM) FR...
395,316,269 24,573 16,087.42 16.05 2533.44 2480.47 3r1uzmbwxhw3p JDBC Thin Client select insureinfo0_.POLICYSERI...
325,621,329 73,018 4,459.47 13.22 1849.32 1816.29 6hhyacc5t6kmk JDBC Thin Client select this_.SERIALNO as SERIA...
127,647,775 24,368 5,238.34 5.18 1243.65 1218.15 3rm6gtwn27uq4 JDBC Thin Client select beneficiar0_.PARENTSERI...
97,980,844 122,799 797.90 3.98 765.46 754.37 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
46,186,848 24,547 1,881.57 1.87 530.02 520.19 6x0wjqbj0rfrp JDBC Thin Client select insurancep0_.POLICYSERI...
34,169,150 6,798 5,026.35 1.39 189.98 186.44 0a98unb7db9f0 JDBC Thin Client select this_.SERIALNO as SERIA...
589,819 98,359 6.00 0.02 20.40 20.36 fbgc81kg73hks JDBC Thin Client update INSURANCEPOLICYPROCESS ...
436,439 24,571 17.76 0.02 9.43 9.44 d7p23cnk01by1 JDBC Thin Client insert into INSUREINFORMBOOK (...
360,000 24,635 14.61 0.01 9.69 9.46 60pyjj5z447w1 JDBC Thin Client insert into PAYMENTACCOUNT (AC...

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
135 1 135.00 60.00 0.10 0.09 89qyn4bbt03jq   SELECT /*+ USE_HASH(f a) */ SU...
15 1 15.00 6.67 0.04 0.05 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0 208 0.00 0.00 0.01 0.01 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0 6,798 0.00 0.00 189.98 186.44 0a98unb7db9f0 JDBC Thin Client select this_.SERIALNO as SERIA...
0 2 0.00 0.00 0.00 0.00 0cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
0 1 0.00 0.00 0.00 0.00 0hbv80w9ypy0n emagent@middb (TNS V1-V3) /* OracleOEM */ SELECT end_tim...
0 2 0.00 0.00 0.00 0.00 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
0 2 0.00 0.00 0.00 0.00 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
0 122,799 0.00 0.00 765.46 754.37 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
0 7 0.00 0.00 0.00 0.00 1jqqpfkr0m3yk Admin Connection SELECT COUNT(*) FROM SYS.WRI$_...

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
122,799 73,551 0.60 0.01 0.01 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
98,359 98,355 1.00 0.00 0.00 fbgc81kg73hks JDBC Thin Client update INSURANCEPOLICYPROCESS ...
73,018 24,248 0.33 0.03 0.02 6hhyacc5t6kmk JDBC Thin Client select this_.SERIALNO as SERIA...
49,269 49,268 1.00 0.00 0.00 9mq1qhcf3w76j JDBC Thin Client update INSURANCEPOLICY set AGE...
24,637 24,637 1.00 0.00 0.00 cj620gtn0n4cs JDBC Thin Client update INSURANCEPOLICYLIABILIT...
24,635 24,635 1.00 0.00 0.00 60pyjj5z447w1 JDBC Thin Client insert into PAYMENTACCOUNT (AC...
24,577 0 0.00 0.00 0.00 8as3cambv69h4 JDBC Thin Client select paymentacc0_.SERIALNO a...
24,577 24,577 1.00 0.00 0.00 f3n0ngjdmjwr4 JDBC Thin Client select insurancea0_.SERIALNO a...
24,575 0 0.00 0.00 0.00 5zrtav8pmwg53 JDBC Thin Client select invoice0_.SERIALNO as S...
24,575 0 0.00 0.00 0.00 6tqz17dynf5u0 JDBC Thin Client select insuredlia0_.INSUREDSER...
24,575 0 0.00 0.00 0.00 6vwc7wa57jdzj JDBC Thin Client select orderform0_.SERIALNO as...
24,573 97,832 3.98 0.10 0.10 3r1uzmbwxhw3p JDBC Thin Client select insureinfo0_.POLICYSERI...
24,571 24,571 1.00 0.00 0.00 2x0hctzhv19aw JDBC Thin Client insert into ADDRESSEE (CITY, C...
24,571 98,284 4.00 0.00 0.00 d7p23cnk01by1 JDBC Thin Client insert into INSUREINFORMBOOK (...
24,570 24,571 1.00 0.00 0.00 b1xh58mk37aq0 JDBC Thin Client insert into INSURANCEPOLICYLIA...
24,570 24,568 1.00 0.00 0.00 bgach9vwgy8h4 JDBC Thin Client select POLICYSERIALNUMBERSEQUE...
24,556 0 0.00 0.00 0.00 4zgn2kcfduv8b JDBC Thin Client select fundstrans0_.POLICYSERI...
24,550 24,575 1.00 0.00 0.00 bm7q8ztw8674b JDBC Thin Client select addressee0_.SERIALNO as...
24,547 24,466 1.00 0.02 0.02 6x0wjqbj0rfrp JDBC Thin Client select insurancep0_.POLICYSERI...
24,543 24,543 1.00 0.00 0.00 g0vfsxvwfmsdv JDBC Thin Client insert into INSURANCEPOLICYPRO...
24,368 0 0.00 0.05 0.05 3rm6gtwn27uq4 JDBC Thin Client select beneficiar0_.PARENTSERI...
18,396 18,396 1.00 0.00 0.00 cnjhvnr16479w JDBC Thin Client insert into PARTYROLEINPOLICY ...
18,345 18,260 1.00 0.22 0.21 2ax73suj5nyka JDBC Thin Client SELECT SUM(PL.GROSSPREMIUM) FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
27,975 73,018 4.43 6hhyacc5t6kmk JDBC Thin Client select this_.SERIALNO as SERIA...
24,575 24,577 3.89 8as3cambv69h4 JDBC Thin Client select paymentacc0_.SERIALNO a...
24,575 24,577 3.89 f3n0ngjdmjwr4 JDBC Thin Client select insurancea0_.SERIALNO a...
24,573 24,575 3.89 5zrtav8pmwg53 JDBC Thin Client select invoice0_.SERIALNO as S...
24,573 24,575 3.89 6tqz17dynf5u0 JDBC Thin Client select insuredlia0_.INSUREDSER...
24,572 24,556 3.89 4zgn2kcfduv8b JDBC Thin Client select fundstrans0_.POLICYSERI...
24,572 24,575 3.89 6vwc7wa57jdzj JDBC Thin Client select orderform0_.SERIALNO as...
24,572 24,547 3.89 6x0wjqbj0rfrp JDBC Thin Client select insurancep0_.POLICYSERI...
24,570 24,573 3.89 3r1uzmbwxhw3p JDBC Thin Client select insureinfo0_.POLICYSERI...
24,569 24,550 3.89 bm7q8ztw8674b JDBC Thin Client select addressee0_.SERIALNO as...
24,408 24,570 3.87 b1xh58mk37aq0 JDBC Thin Client insert into INSURANCEPOLICYLIA...
24,395 24,571 3.86 d7p23cnk01by1 JDBC Thin Client insert into INSUREINFORMBOOK (...
24,384 24,571 3.86 2x0hctzhv19aw JDBC Thin Client insert into ADDRESSEE (CITY, C...
24,367 24,368 3.86 3rm6gtwn27uq4 JDBC Thin Client select beneficiar0_.PARENTSERI...
24,262 24,570 3.84 bgach9vwgy8h4 JDBC Thin Client select POLICYSERIALNUMBERSEQUE...
23,885 24,543 3.78 g0vfsxvwfmsdv JDBC Thin Client insert into INSURANCEPOLICYPRO...
20,429 98,359 3.24 fbgc81kg73hks JDBC Thin Client update INSURANCEPOLICYPROCESS ...
18,207 18,396 2.88 cnjhvnr16479w JDBC Thin Client insert into PARTYROLEINPOLICY ...
18,058 18,345 2.86 2ax73suj5nyka JDBC Thin Client SELECT SUM(PL.GROSSPREMIUM) FR...
16,290 24,635 2.58 60pyjj5z447w1 JDBC Thin Client insert into PAYMENTACCOUNT (AC...
16,240 24,637 2.57 cj620gtn0n4cs JDBC Thin Client update INSURANCEPOLICYLIABILIT...
14,125 122,799 2.24 151jmjtarcvs8 JDBC Thin Client select this_.SERIALNO as SERIA...
13,696 49,269 2.17 9mq1qhcf3w76j JDBC Thin Client update INSURANCEPOLICY set AGE...
6,776 6,776 1.07 381g3brxk9gvm JDBC Thin Client select beneficiar0_.POLICYSERI...
6,745 6,784 1.07 9586ta28zmrtt JDBC Thin Client insert into INSURANCEPOLICY (A...
6,518 6,579 1.03 53qg3r45857fv JDBC Thin Client insert into PARTYROLEINPOLICY ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,688,156 49,269 0.46 9mq1qhcf3w76j JDBC Thin Client update INSURANCEPOLICY set AGE...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0a98unb7db9f0 select this_.SERIALNO as SERIALNO22_1_, this_.AGENTCODE as AGENTCODE22_1_, this_.AGENTNAME as AGENTNAME22_1_, this_.AGREEMENTNO as AGREEMEN4_22_1_, this_.ALLOWPARTYWITHDROWFLAG as ALLOWPAR5_22_1_, this_.ANNUITYPAYOUTDURATION as ANNUITYP6_22_1_, this_.ANNUITYPAYOUTDURATIONMODE as ANNUITYP7_22_1_, this_.APPLICATIONNUMBER as APPLICAT8_22_1_, this_.APPLICATIONSERIALNUMBER as APPLICAT9_22_1_, this_.AUTORENEWABLE as AUTOREN10_22_1_, this_.BANKCODE as BANKCODE22_1_, this_.BENEFICIARYMODE as BENEFIC12_22_1_, this_.BENEFITMODE as BENEFIT13_22_1_, this_.BENEFITPERIOD as BENEFIT14_22_1_, this_.BENEFITPERIODTYPE as BENEFIT15_22_1_, this_.BRANCHCODE as BRANCHCODE22_1_, this_.BRANCHNAME as BRANCHNAME22_1_, this_.CAMPAIGNCODE as CAMPAIG18_22_1_, this_.CAMPAIGNNAME as CAMPAIG19_22_1_, this_.CASHVALUE as CASHVALUE22_1_, this_.CERTIFICATIONREQUIRED as CERTIFI21_22_1_, this_.COMBOCODE as COMBOCODE22_1_, this_.COMBONAME as COMBONAME22_1_, this_.CONTRACTNAMES as CONTRAC24_22_1_, this_.CREATETIME as CREATETIME22_1_, this_.CUSTOMERID as CUSTOMERID22_1_, this_.DELIVERYEPOLICY as DELIVER27_22_1_, this_.DELIVERYHARDCOPY as DELIVER28_22_1_, this_.DELIVERYINVOICE as DELIVER29_22_1_, this_.DEPARTMENTNAME as DEPARTM30_22_1_, this_.DEPARTMENTNO as DEPARTM31_22_1_, this_.DISCOUNTPREMIUM as DISCOUN32_22_1_, this_.DISCOUNTRATE as DISCOUN33_22_1_, this_.DISCOUNTTYPECODE as DISCOUN34_22_1_, this_.DIVTYPE as DIVTYPE22_1_, this_.ELECTRONICAPPLICANTNUMBER as ELECTRO36_22_1_, thi s_.ELECTRONICPOLICYNUMBER as ELECTRO37_22_1_, this_.EXCESSPREMAMT as EXCESSP38_22_1_, this_.FACEAMOUNT as FACEAMOUNT22_1_, this_.FIRSTPREMIUM as FIRSTPR40_22_1_, this_.FORMID as FORMID22_1_, this_.FUNDTRANSFERDATEBASEDON as FUNDTRA42_22_1_, this_.GENERATEELECTRONICPOLICYSTATUS as GENERAT43_22_1_, this_.GROSSPREMIUM as GROSSPR44_22_1_, this_.INCEPTIONDATE as INCEPTI45_22_1_, this_.INITIALPREMAMT as INITIAL46_22_1_, this_.INSTITUTIONCODE as INSTITU47_22_1_, this_.INSTITUTIONNAME as INSTITU48_22_1_, this_.INSURANCEENDPERIOD as INSURAN49_22_1_, this_.INSURANCESTARTPERIOD as INSURAN50_22_1_, this_.INSUREDAMOUNT as INSURED51_22_1_, this_.INTERMEDIARYCODE as INTERME52_22_1_, this_.INTERMEDIARYNAME as INTERME53_22_1_, this_.MERCHANTORDERNUMBER as MERCHAN54_22_1_, this_.MERCHANTPRODUCTCODE as MERCHAN55_22_1_, this_.MERCHANTPRODUCTNAME as MERCHAN56_22_1_, this_.MERCHANTTRANSSERIALNUMBER as MERCHAN57_22_1_, this_.MUSTCANCELFLAG as MUSTCAN58_22_1_, this_.OPERATORID as OPERATORID22_1_, this_.ORDERSERIALNUMBER as ORDERSE60_22_1_, this_.ORGANIZATIONCODE as ORGANIZ61_22_1_, this_.ORGANIZATIONNAME as ORGANIZ62_22_1_, this_.PAYMENTDURATION as PAYMENT63_22_1_, this_.PAYMENTDURATIONMODE as PAYMENT64_22_1_, this_.PAYMENTMETHOD as PAYMENT65_22_1_, this_.PAYMENTMODE as PAYMENT66_22_1_, this_.PAYOUTEND as PAYOUTEND22_1_, this_.PAYOUTSTART as PAYOUTS68_22_1_, this_.PERSONALUSERSERIALNO as PERSONA69_22_1_, this_.POLICYDELIVERYFEE as POLICYD70_22_1_, this_.POLICYSERIAL NUMBER as POLICYS71_22_1_, this_.POLICYSTATUS as POLICYS72_22_1_, this_.POLICYSTATUSDESC as POLICYS73_22_1_, this_.POLICYSTATUSMESSAGE as POLICYS74_22_1_, this_.POLICYSTATUSNAME as POLICYS75_22_1_, this_.POLICYTYPE as POLICYTYPE22_1_, this_.PREMIUM as PREMIUM22_1_, this_.PRESERVEACCEPTTIME as PRESERV78_22_1_, this_.PRESERVEEFFECTIVETIME as PRESERV79_22_1_, this_.PRODUCTCODE as PRODUCT80_22_1_, this_.PRODUCTNAME as PRODUCT81_22_1_, this_.REFUNDPOLICYSUCCESSTIME as REFUNDP82_22_1_, this_.REFUNDPOLICYTIME as REFUNDP83_22_1_, this_.REQUIREVISA as REQUIRE84_22_1_, this_.REVERSALFLAG as REVERSA85_22_1_, this_.SIGNEDDATE as SIGNEDDATE22_1_, this_.SPECIALSTATEMENT as SPECIAL87_22_1_, this_.SUBMISSIONDATE as SUBMISS88_22_1_, this_.SYNCENDTIME as SYNCEND89_22_1_, this_.SYNCSTARTTIME as SYNCSTA90_22_1_, this_.SYNCSTATUS as SYNCSTATUS22_1_, this_.SYNCSTATUSDESC as SYNCSTA92_22_1_, this_.TRANSIDENTIFY as TRANSID93_22_1_, this_.TRANSSERIALNUMBER as TRANSSE94_22_1_, this_.TRAVELDESTINATION as TRAVELD95_22_1_, this_.UNITCOUNT as UNITCOUNT22_1_, this_.UPDATETIME as UPDATETIME22_1_, insureds2_.POLICYSERIALNO as POLICYS53_3_, insureds2_.SERIALNO as SERIALNO3_, insureds2_.SERIALNO as SERIALNO20_0_, insureds2_.ACCEPTSMS as ACCEPTSMS20_0_, insureds2_.ADDRESSLINES as ADDRESSL4_20_0_, insureds2_.AGE as AGE20_0_, insureds2_.AGEINDAY as AGEINDAY20_0_, insureds2_.ANNUALINCOME as ANNUALIN7_20_0_, insureds2_.BIRTHDATE as BIRTHDATE20_0_, insureds2_.BIRTHWEIGHT as BIRTHW EI9_20_0_, insureds2_.CITIZENSHIP as CITIZEN10_20_0_, insureds2_.CITY as CITY20_0_, insureds2_.CREATETIME as CREATETIME20_0_, insureds2_.CUSTOMFLAG as CUSTOMFLAG20_0_, insureds2_.CUSTOMERID as CUSTOMERID20_0_, insureds2_.DRINKERAMOUNTBYYEAR as DRINKER15_20_0_, insureds2_.DRINKERSTATUS as DRINKER16_20_0_, insureds2_.DRINKERYEARS as DRINKER17_20_0_, insureds2_.EMAIL as EMAIL20_0_, insureds2_.EMPLOYERFULLNAME as EMPLOYE19_20_0_, insureds2_.FULLENNAME as FULLENNAME20_0_, insureds2_.FULLNAME as FULLNAME20_0_, insureds2_.GENDER as GENDER20_0_, insureds2_.HEIGHT as HEIGHT20_0_, insureds2_.HOMEADDRESS as HOMEADD24_20_0_, insureds2_.IDEXPDATE as IDEXPDATE20_0_, insureds2_.IDNUMBER as IDNUMBER20_0_, insureds2_.IDTYPE as IDTYPE20_0_, insureds2_.MARITALSTATUS as MARITAL28_20_0_, insureds2_.MOBILEPHONENUMBER as MOBILEP29_20_0_, insureds2_.OCCUPATIONCLASS as OCCUPAT30_20_0_, insureds2_.OCCUPATIONCODE as OCCUPAT31_20_0_, insureds2_.OCCUPATIONDESCRIPTION as OCCUPAT32_20_0_, insureds2_.OFFICEADDRESS as OFFICEA33_20_0_, insureds2_.OFFICEPHONENUMBER as OFFICEP34_20_0_, insureds2_.PHONENUMBER as PHONENU35_20_0_, insureds2_.POSTALCODE as POSTALCODE20_0_, insureds2_.PROVINCE as PROVINCE20_0_, insureds2_.ROLESERIALNO as ROLESER38_20_0_, insureds2_.SMOKERAMOUNTBYYEAR as SMOKERA39_20_0_, insureds2_.SMOKERSTATUS as SMOKERS40_20_0_, insureds2_.SMOKERYEARS as SMOKERY41_20_0_, insureds2_.UPDATETIME as UPDATETIME20_0_, insureds2_.WEIGHT as WEIGHT20_0_, insureds2_.INDICAT ORMESSAGE as INDICAT48_20_0_, insureds2_.POLICYSERIALNO as POLICYS53_20_0_, insureds2_.INSUREDAMOUNTPERCENT as INSURED49_20_0_, insureds2_.ROLEORDER as ROLEORDER20_0_, insureds2_.MAININSUREDFLAG as MAININS50_20_0_, insureds2_.RELATEDTOAPPLICANT as RELATED51_20_0_, insureds2_.RELATEDTOINSURED as RELATED47_20_0_, insureds2_.SAMEINDUSTRYINSUREDAMOUNT as SAMEIND52_20_0_ from INSURANCEPOLICY this_ left outer join PARTYROLEINPOLICY insureds2_ on this_.SERIALNO=insureds2_.POLICYSERIALNO and ( insureds2_.ROLEKIND = 'Insured') where this_.MERCHANTORDERNUMBER=:1 and this_.APPLICATIONNUMBER=:2
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'
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0hbv80w9ypy0n/* OracleOEM */ SELECT end_time, status, session_key, session_recid, session_stamp, command_id, start_time, time_taken_display, input_type, output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display FROM v$rman_backup_job_details WHERE end_time = (select max(end_time) from v$rman_backup_job_details)
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
151jmjtarcvs8select this_.SERIALNO as SERIALNO25_0_, this_.CREATETIME as CREATETIME25_0_, this_.INSTITUTIONCODE as INSTITUT3_25_0_, this_.INSTITUTIONNAME as INSTITUT4_25_0_, this_.LOCKSTATUS as LOCKSTATUS25_0_, this_.LOCKEDREASON as LOCKEDRE6_25_0_, this_.MERCHANTORDERNUMBER as MERCHANT7_25_0_, this_.POLICYSERIALNUMBER as POLICYSE8_25_0_, this_.PROCESSENDTIME as PROCESSE9_25_0_, this_.PROCESSSTARTTIME as PROCESS10_25_0_, this_.PROCESSSTATUS as PROCESS11_25_0_, this_.PROCESSSTATUSDESC as PROCESS12_25_0_, this_.SERVICENAME as SERVICE13_25_0_, this_.UPDATETIME as UPDATETIME25_0_ from INSURANCEPOLICYPROCESS this_ where this_.MERCHANTORDERNUMBER=:1
1jqqpfkr0m3ykSELECT COUNT(*) FROM SYS.WRI$_ADV_PARAMETERS A WHERE A.TASK_ID = :B2 AND A.NAME = :B1
2ax73suj5nykaSELECT SUM(PL.GROSSPREMIUM) FROM INSURANCEPOLICY PL INNER JOIN PARTYROLEINPOLICY APPLICANT ON PL.SERIALNO = APPLICANT.POLICYSERIALNO AND APPLICANT.ROLEKIND = 'InsuranceApplicant' WHERE APPLICANT.FULLNAME = :1 AND APPLICANT.GENDER = :2 AND APPLICANT.IDTYPE = :3 AND APPLICANT.IDNUMBER = :4 AND APPLICANT.BIRTHDATE = :5 AND PL.POLICYSTATUS = :6 AND PL.SUBMISSIONDATE = :7
2x0hctzhv19awinsert into ADDRESSEE (CITY, CONSIGNEEADDRESS, CONSIGNEENAME, COUNTY, CREATETIME, EMAIL, FIXEDPHONE, POLICYSERIALNO, PROVINCE, REMARK, TELEPHONE, UPDATETIME, ZIPCODE, SERIALNO) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )
381g3brxk9gvm select beneficiar0_.POLICYSERIALNO as POLICYS53_1_, beneficiar0_.SERIALNO as SERIALNO1_, beneficiar0_.SERIALNO as SERIALNO20_0_, beneficiar0_.ACCEPTSMS as ACCEPTSMS20_0_, beneficiar0_.ADDRESSLINES as ADDRESSL4_20_0_, beneficiar0_.AGE as AGE20_0_, beneficiar0_.AGEINDAY as AGEINDAY20_0_, beneficiar0_.ANNUALINCOME as ANNUALIN7_20_0_, beneficiar0_.BIRTHDATE as BIRTHDATE20_0_, beneficiar0_.BIRTHWEIGHT as BIRTHWEI9_20_0_, beneficiar0_.CITIZENSHIP as CITIZEN10_20_0_, beneficiar0_.CITY as CITY20_0_, beneficiar0_.CREATETIME as CREATETIME20_0_, beneficiar0_.CUSTOMFLAG as CUSTOMFLAG20_0_, beneficiar0_.CUSTOMERID as CUSTOMERID20_0_, beneficiar0_.DRINKERAMOUNTBYYEAR as DRINKER15_20_0_, beneficiar0_.DRINKERSTATUS as DRINKER16_20_0_, beneficiar0_.DRINKERYEARS as DRINKER17_20_0_, beneficiar0_.EMAIL as EMAIL20_0_, beneficiar0_.EMPLOYERFULLNAME as EMPLOYE19_20_0_, beneficiar0_.FULLENNAME as FULLENNAME20_0_, beneficiar0_.FULLNAME as FULLNAME20_0_, beneficiar0_.GENDER as GENDER20_0_, beneficiar0_.HEIGHT as HEIGHT20_0_, beneficiar0_.HOMEADDRESS as HOMEADD24_20_0_, beneficiar0_.IDEXPDATE as IDEXPDATE20_0_, beneficiar0_.IDNUMBER as IDNUMBER20_0_, beneficiar0_.IDTYPE as IDTYPE20_0_, beneficiar0_.MARITALSTATUS as MARITAL28_20_0_, beneficiar0_.MOBILEPHONENUMBER as MOBILEP29_20_0_, beneficiar0_.OCCUPATIONCLASS as OCCUPAT30_20_0_, beneficiar0_.OCCUPATIONCODE as OCCUPAT31_20_0_, beneficiar0_.OCCUPATIONDESCRIPTION as OCCUPAT32_20_0_, beneficiar0_.OFFICEADDRESS as OFFICEA33 _20_0_, beneficiar0_.OFFICEPHONENUMBER as OFFICEP34_20_0_, beneficiar0_.PHONENUMBER as PHONENU35_20_0_, beneficiar0_.POSTALCODE as POSTALCODE20_0_, beneficiar0_.PROVINCE as PROVINCE20_0_, beneficiar0_.ROLESERIALNO as ROLESER38_20_0_, beneficiar0_.SMOKERAMOUNTBYYEAR as SMOKERA39_20_0_, beneficiar0_.SMOKERSTATUS as SMOKERS40_20_0_, beneficiar0_.SMOKERYEARS as SMOKERY41_20_0_, beneficiar0_.UPDATETIME as UPDATETIME20_0_, beneficiar0_.WEIGHT as WEIGHT20_0_, beneficiar0_.ROLEORDER as ROLEORDER20_0_, beneficiar0_.BENEFICIARYTYPE as BENEFIC45_20_0_, beneficiar0_.POLICYSERIALNO as POLICYS53_20_0_, beneficiar0_.PARENTSERIALNO as PARENTS54_20_0_, beneficiar0_.INTERESTPERCENT as INTERES46_20_0_, beneficiar0_.RELATEDTOINSURED as RELATED47_20_0_ from PARTYROLEINPOLICY beneficiar0_ where ( beneficiar0_.ROLEKIND = 'Beneficiary') and beneficiar0_.POLICYSERIALNO=:1
3r1uzmbwxhw3pselect insureinfo0_.POLICYSERIALNO as POLICYSE9_1_, insureinfo0_.SERIALNO as SERIALNO1_, insureinfo0_.SERIALNO as SERIALNO14_0_, insureinfo0_.CREATETIME as CREATETIME14_0_, insureinfo0_.INFORMCODE as INFORMCODE14_0_, insureinfo0_.INFORMCONTENT as INFORMCO4_14_0_, insureinfo0_.INFORMORDER as INFORMOR5_14_0_, insureinfo0_.INFORMTYPE as INFORMTYPE14_0_, insureinfo0_.INFORMTYPENAME as INFORMTY7_14_0_, insureinfo0_.POLICYSERIALNO as POLICYSE9_14_0_, insureinfo0_.UPDATETIME as UPDATETIME14_0_ from INSUREINFORMBOOK insureinfo0_ where insureinfo0_.POLICYSERIALNO=:1
3rm6gtwn27uq4 select beneficiar0_.PARENTSERIALNO as PARENTS54_1_, beneficiar0_.SERIALNO as SERIALNO1_, beneficiar0_.SERIALNO as SERIALNO20_0_, beneficiar0_.ACCEPTSMS as ACCEPTSMS20_0_, beneficiar0_.ADDRESSLINES as ADDRESSL4_20_0_, beneficiar0_.AGE as AGE20_0_, beneficiar0_.AGEINDAY as AGEINDAY20_0_, beneficiar0_.ANNUALINCOME as ANNUALIN7_20_0_, beneficiar0_.BIRTHDATE as BIRTHDATE20_0_, beneficiar0_.BIRTHWEIGHT as BIRTHWEI9_20_0_, beneficiar0_.CITIZENSHIP as CITIZEN10_20_0_, beneficiar0_.CITY as CITY20_0_, beneficiar0_.CREATETIME as CREATETIME20_0_, beneficiar0_.CUSTOMFLAG as CUSTOMFLAG20_0_, beneficiar0_.CUSTOMERID as CUSTOMERID20_0_, beneficiar0_.DRINKERAMOUNTBYYEAR as DRINKER15_20_0_, beneficiar0_.DRINKERSTATUS as DRINKER16_20_0_, beneficiar0_.DRINKERYEARS as DRINKER17_20_0_, beneficiar0_.EMAIL as EMAIL20_0_, beneficiar0_.EMPLOYERFULLNAME as EMPLOYE19_20_0_, beneficiar0_.FULLENNAME as FULLENNAME20_0_, beneficiar0_.FULLNAME as FULLNAME20_0_, beneficiar0_.GENDER as GENDER20_0_, beneficiar0_.HEIGHT as HEIGHT20_0_, beneficiar0_.HOMEADDRESS as HOMEADD24_20_0_, beneficiar0_.IDEXPDATE as IDEXPDATE20_0_, beneficiar0_.IDNUMBER as IDNUMBER20_0_, beneficiar0_.IDTYPE as IDTYPE20_0_, beneficiar0_.MARITALSTATUS as MARITAL28_20_0_, beneficiar0_.MOBILEPHONENUMBER as MOBILEP29_20_0_, beneficiar0_.OCCUPATIONCLASS as OCCUPAT30_20_0_, beneficiar0_.OCCUPATIONCODE as OCCUPAT31_20_0_, beneficiar0_.OCCUPATIONDESCRIPTION as OCCUPAT32_20_0_, beneficiar0_.OFFICEADDRESS as OFFICEA33 _20_0_, beneficiar0_.OFFICEPHONENUMBER as OFFICEP34_20_0_, beneficiar0_.PHONENUMBER as PHONENU35_20_0_, beneficiar0_.POSTALCODE as POSTALCODE20_0_, beneficiar0_.PROVINCE as PROVINCE20_0_, beneficiar0_.ROLESERIALNO as ROLESER38_20_0_, beneficiar0_.SMOKERAMOUNTBYYEAR as SMOKERA39_20_0_, beneficiar0_.SMOKERSTATUS as SMOKERS40_20_0_, beneficiar0_.SMOKERYEARS as SMOKERY41_20_0_, beneficiar0_.UPDATETIME as UPDATETIME20_0_, beneficiar0_.WEIGHT as WEIGHT20_0_, beneficiar0_.ROLEORDER as ROLEORDER20_0_, beneficiar0_.BENEFICIARYTYPE as BENEFIC45_20_0_, beneficiar0_.POLICYSERIALNO as POLICYS53_20_0_, beneficiar0_.PARENTSERIALNO as PARENTS54_20_0_, beneficiar0_.INTERESTPERCENT as INTERES46_20_0_, beneficiar0_.RELATEDTOINSURED as RELATED47_20_0_ from PARTYROLEINPOLICY beneficiar0_ where ( beneficiar0_.ROLEKIND = 'Beneficiary') and beneficiar0_.PARENTSERIALNO=:1
4zgn2kcfduv8b select fundstrans0_.POLICYSERIALNO as POLICYS24_1_, fundstrans0_.SERIALNO as SERIALNO1_, fundstrans0_.SERIALNO as SERIALNO11_0_, fundstrans0_.ACCOUNTNUMBER as ACCOUNTN2_11_0_, fundstrans0_.ACCTHOLDERID as ACCTHOLD3_11_0_, fundstrans0_.ACCTHOLDERNAME as ACCTHOLD4_11_0_, fundstrans0_.ACTUALAVAILABLEAMOUNT as ACTUALAV5_11_0_, fundstrans0_.CASHVALUE as CASHVALUE11_0_, fundstrans0_.CREATETIME as CREATETIME11_0_, fundstrans0_.FUNDSTRANSFERORDERNUMBER as FUNDSTRA8_11_0_, fundstrans0_.FUNDSTRANSFERSERIALNUMBER as FUNDSTRA9_11_0_, fundstrans0_.FUNDSTRANSFERSTATUS as FUNDSTR10_11_0_, fundstrans0_.FUNDSTRANSFERSTATUSDESC as FUNDSTR11_11_0_, fundstrans0_.POLICYSERIALNO as POLICYS24_11_0_, fundstrans0_.MERCHANTORDERNUMBER as MERCHAN12_11_0_, fundstrans0_.OPERATORID as OPERATORID11_0_, fundstrans0_.POLICYSERIALNUMBER as POLICYS14_11_0_, fundstrans0_.PRESERVEACCEPTTIME as PRESERV15_11_0_, fundstrans0_.PRESERVEEFFECTIVETIME as PRESERV16_11_0_, fundstrans0_.REFUNDPOLICYSUCCESSTIME as REFUNDP17_11_0_, fundstrans0_.REFUNDPOLICYTIME as REFUNDP18_11_0_, fundstrans0_.TRANSFERAMOUNT as TRANSFE19_11_0_, fundstrans0_.TRANSFERSUCCESSTIME as TRANSFE20_11_0_, fundstrans0_.TRANSFERTIME as TRANSFE21_11_0_, fundstrans0_.TRANSFERTYPE as TRANSFE22_11_0_, fundstrans0_.UPDATETIME as UPDATETIME11_0_ from FUNDSTRANSFER fundstrans0_ where fundstrans0_.POLICYSERIALNO=:1
53qg3r45857fvinsert into PARTYROLEINPOLICY (ACCEPTSMS, ADDRESSLINES, AGE, AGEINDAY, ANNUALINCOME, BIRTHDATE, BIRTHWEIGHT, CITIZENSHIP, CITY, CREATETIME, CUSTOMFLAG, CUSTOMERID, DRINKERAMOUNTBYYEAR, DRINKERSTATUS, DRINKERYEARS, EMAIL, EMPLOYERFULLNAME, FULLENNAME, FULLNAME, GENDER, HEIGHT, HOMEADDRESS, IDEXPDATE, IDNUMBER, IDTYPE, MARITALSTATUS, MOBILEPHONENUMBER, OCCUPATIONCLASS, OCCUPATIONCODE, OCCUPATIONDESCRIPTION, OFFICEADDRESS, OFFICEPHONENUMBER, PHONENUMBER, POSTALCODE, PROVINCE, ROLESERIALNO, SMOKERAMOUNTBYYEAR, SMOKERSTATUS, SMOKERYEARS, UPDATETIME, WEIGHT, POLICYSERIALNO, RELATEDTOINSURED, ROLEKIND, SERIALNO) 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 , :43 , 'InsuranceApplicant', :44 )
5zrtav8pmwg53select invoice0_.SERIALNO as SERIALNO16_0_, invoice0_.BANKACCOUNT as BANKACCO2_16_0_, invoice0_.CASHIER as CASHIER16_0_, invoice0_.COMPANYNAME as COMPANYN4_16_0_, invoice0_.CREATETIME as CREATETIME16_0_, invoice0_.CURRENCYSYMBOL as CURRENCY6_16_0_, invoice0_.POLICYSERIALNO as POLICYS25_16_0_, invoice0_.INVOICECODE as INVOICEC7_16_0_, invoice0_.INVOICENO as INVOICENO16_0_, invoice0_.INVOICETITLE as INVOICET9_16_0_, invoice0_.INVOICETYPE as INVOICE10_16_0_, invoice0_.INVOINCECONTENT as INVOINC11_16_0_, invoice0_.OPENINGBANK as OPENING12_16_0_, invoice0_.PAYEE as PAYEE16_0_, invoice0_.PAYEESEAL as PAYEESEAL16_0_, invoice0_.PAYER as PAYER16_0_, invoice0_.PRINTNO as PRINTNO16_0_, invoice0_.PRINTERMACHINENO as PRINTER17_16_0_, invoice0_.REGISTEREDADDRESS as REGISTE18_16_0_, invoice0_.REGISTEREDPHONE as REGISTE19_16_0_, invoice0_.TAXCONTROLCODE as TAXCONT20_16_0_, invoice0_.TAXREGISTRYNO as TAXREGI21_16_0_, invoice0_.TOTALINFIGURES as TOTALIN22_16_0_, invoice0_.TOTALINLETTERS as TOTALIN23_16_0_, invoice0_.UPDATETIME as UPDATETIME16_0_ from INVOICE invoice0_ where invoice0_.POLICYSERIALNO=:1
60pyjj5z447w1insert into PAYMENTACCOUNT (ACCOUNTNUMBER, ACCOUNTNUMBERCONFIRM, ACCOUNTTIME, ACCTHOLDERID, ACCTHOLDERNAME, ACCTIDNUMBER, ACCTMOBILEPHONE, BANKACCTTYPE, BANKBRANCHCODE, BANKBRANCHNAME, BANKCARDCVTWO, BANKCODE, BANKNAME, CARDEFFECTIVEDATE, CARDORBOOK, CHECKPAYNUMBER, CREATETIME, CURRENCYTYPECODE, POLICYSERIALNO, OPERATORID, PAYAMOUNT, PAYORDERSERIALNUMBER, PAYTIME, UPDATETIME, SERIALNO) 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 )
6hhyacc5t6kmk select this_.SERIALNO as SERIALNO22_1_, this_.AGENTCODE as AGENTCODE22_1_, this_.AGENTNAME as AGENTNAME22_1_, this_.AGREEMENTNO as AGREEMEN4_22_1_, this_.ALLOWPARTYWITHDROWFLAG as ALLOWPAR5_22_1_, this_.ANNUITYPAYOUTDURATION as ANNUITYP6_22_1_, this_.ANNUITYPAYOUTDURATIONMODE as ANNUITYP7_22_1_, this_.APPLICATIONNUMBER as APPLICAT8_22_1_, this_.APPLICATIONSERIALNUMBER as APPLICAT9_22_1_, this_.AUTORENEWABLE as AUTOREN10_22_1_, this_.BANKCODE as BANKCODE22_1_, this_.BENEFICIARYMODE as BENEFIC12_22_1_, this_.BENEFITMODE as BENEFIT13_22_1_, this_.BENEFITPERIOD as BENEFIT14_22_1_, this_.BENEFITPERIODTYPE as BENEFIT15_22_1_, this_.BRANCHCODE as BRANCHCODE22_1_, this_.BRANCHNAME as BRANCHNAME22_1_, this_.CAMPAIGNCODE as CAMPAIG18_22_1_, this_.CAMPAIGNNAME as CAMPAIG19_22_1_, this_.CASHVALUE as CASHVALUE22_1_, this_.CERTIFICATIONREQUIRED as CERTIFI21_22_1_, this_.COMBOCODE as COMBOCODE22_1_, this_.COMBONAME as COMBONAME22_1_, this_.CONTRACTNAMES as CONTRAC24_22_1_, this_.CREATETIME as CREATETIME22_1_, this_.CUSTOMERID as CUSTOMERID22_1_, this_.DELIVERYEPOLICY as DELIVER27_22_1_, this_.DELIVERYHARDCOPY as DELIVER28_22_1_, this_.DELIVERYINVOICE as DELIVER29_22_1_, this_.DEPARTMENTNAME as DEPARTM30_22_1_, this_.DEPARTMENTNO as DEPARTM31_22_1_, this_.DISCOUNTPREMIUM as DISCOUN32_22_1_, this_.DISCOUNTRATE as DISCOUN33_22_1_, this_.DISCOUNTTYPECODE as DISCOUN34_22_1_, this_.DIVTYPE as DIVTYPE22_1_, this_.ELECTRONICAPPLICANTNUMBER as ELECTRO36_22_1_, thi s_.ELECTRONICPOLICYNUMBER as ELECTRO37_22_1_, this_.EXCESSPREMAMT as EXCESSP38_22_1_, this_.FACEAMOUNT as FACEAMOUNT22_1_, this_.FIRSTPREMIUM as FIRSTPR40_22_1_, this_.FORMID as FORMID22_1_, this_.FUNDTRANSFERDATEBASEDON as FUNDTRA42_22_1_, this_.GENERATEELECTRONICPOLICYSTATUS as GENERAT43_22_1_, this_.GROSSPREMIUM as GROSSPR44_22_1_, this_.INCEPTIONDATE as INCEPTI45_22_1_, this_.INITIALPREMAMT as INITIAL46_22_1_, this_.INSTITUTIONCODE as INSTITU47_22_1_, this_.INSTITUTIONNAME as INSTITU48_22_1_, this_.INSURANCEENDPERIOD as INSURAN49_22_1_, this_.INSURANCESTARTPERIOD as INSURAN50_22_1_, this_.INSUREDAMOUNT as INSURED51_22_1_, this_.INTERMEDIARYCODE as INTERME52_22_1_, this_.INTERMEDIARYNAME as INTERME53_22_1_, this_.MERCHANTORDERNUMBER as MERCHAN54_22_1_, this_.MERCHANTPRODUCTCODE as MERCHAN55_22_1_, this_.MERCHANTPRODUCTNAME as MERCHAN56_22_1_, this_.MERCHANTTRANSSERIALNUMBER as MERCHAN57_22_1_, this_.MUSTCANCELFLAG as MUSTCAN58_22_1_, this_.OPERATORID as OPERATORID22_1_, this_.ORDERSERIALNUMBER as ORDERSE60_22_1_, this_.ORGANIZATIONCODE as ORGANIZ61_22_1_, this_.ORGANIZATIONNAME as ORGANIZ62_22_1_, this_.PAYMENTDURATION as PAYMENT63_22_1_, this_.PAYMENTDURATIONMODE as PAYMENT64_22_1_, this_.PAYMENTMETHOD as PAYMENT65_22_1_, this_.PAYMENTMODE as PAYMENT66_22_1_, this_.PAYOUTEND as PAYOUTEND22_1_, this_.PAYOUTSTART as PAYOUTS68_22_1_, this_.PERSONALUSERSERIALNO as PERSONA69_22_1_, this_.POLICYDELIVERYFEE as POLICYD70_22_1_, this_.POLICYSERIAL NUMBER as POLICYS71_22_1_, this_.POLICYSTATUS as POLICYS72_22_1_, this_.POLICYSTATUSDESC as POLICYS73_22_1_, this_.POLICYSTATUSMESSAGE as POLICYS74_22_1_, this_.POLICYSTATUSNAME as POLICYS75_22_1_, this_.POLICYTYPE as POLICYTYPE22_1_, this_.PREMIUM as PREMIUM22_1_, this_.PRESERVEACCEPTTIME as PRESERV78_22_1_, this_.PRESERVEEFFECTIVETIME as PRESERV79_22_1_, this_.PRODUCTCODE as PRODUCT80_22_1_, this_.PRODUCTNAME as PRODUCT81_22_1_, this_.REFUNDPOLICYSUCCESSTIME as REFUNDP82_22_1_, this_.REFUNDPOLICYTIME as REFUNDP83_22_1_, this_.REQUIREVISA as REQUIRE84_22_1_, this_.REVERSALFLAG as REVERSA85_22_1_, this_.SIGNEDDATE as SIGNEDDATE22_1_, this_.SPECIALSTATEMENT as SPECIAL87_22_1_, this_.SUBMISSIONDATE as SUBMISS88_22_1_, this_.SYNCENDTIME as SYNCEND89_22_1_, this_.SYNCSTARTTIME as SYNCSTA90_22_1_, this_.SYNCSTATUS as SYNCSTATUS22_1_, this_.SYNCSTATUSDESC as SYNCSTA92_22_1_, this_.TRANSIDENTIFY as TRANSID93_22_1_, this_.TRANSSERIALNUMBER as TRANSSE94_22_1_, this_.TRAVELDESTINATION as TRAVELD95_22_1_, this_.UNITCOUNT as UNITCOUNT22_1_, this_.UPDATETIME as UPDATETIME22_1_, insureds2_.POLICYSERIALNO as POLICYS53_3_, insureds2_.SERIALNO as SERIALNO3_, insureds2_.SERIALNO as SERIALNO20_0_, insureds2_.ACCEPTSMS as ACCEPTSMS20_0_, insureds2_.ADDRESSLINES as ADDRESSL4_20_0_, insureds2_.AGE as AGE20_0_, insureds2_.AGEINDAY as AGEINDAY20_0_, insureds2_.ANNUALINCOME as ANNUALIN7_20_0_, insureds2_.BIRTHDATE as BIRTHDATE20_0_, insureds2_.BIRTHWEIGHT as BIRTHW EI9_20_0_, insureds2_.CITIZENSHIP as CITIZEN10_20_0_, insureds2_.CITY as CITY20_0_, insureds2_.CREATETIME as CREATETIME20_0_, insureds2_.CUSTOMFLAG as CUSTOMFLAG20_0_, insureds2_.CUSTOMERID as CUSTOMERID20_0_, insureds2_.DRINKERAMOUNTBYYEAR as DRINKER15_20_0_, insureds2_.DRINKERSTATUS as DRINKER16_20_0_, insureds2_.DRINKERYEARS as DRINKER17_20_0_, insureds2_.EMAIL as EMAIL20_0_, insureds2_.EMPLOYERFULLNAME as EMPLOYE19_20_0_, insureds2_.FULLENNAME as FULLENNAME20_0_, insureds2_.FULLNAME as FULLNAME20_0_, insureds2_.GENDER as GENDER20_0_, insureds2_.HEIGHT as HEIGHT20_0_, insureds2_.HOMEADDRESS as HOMEADD24_20_0_, insureds2_.IDEXPDATE as IDEXPDATE20_0_, insureds2_.IDNUMBER as IDNUMBER20_0_, insureds2_.IDTYPE as IDTYPE20_0_, insureds2_.MARITALSTATUS as MARITAL28_20_0_, insureds2_.MOBILEPHONENUMBER as MOBILEP29_20_0_, insureds2_.OCCUPATIONCLASS as OCCUPAT30_20_0_, insureds2_.OCCUPATIONCODE as OCCUPAT31_20_0_, insureds2_.OCCUPATIONDESCRIPTION as OCCUPAT32_20_0_, insureds2_.OFFICEADDRESS as OFFICEA33_20_0_, insureds2_.OFFICEPHONENUMBER as OFFICEP34_20_0_, insureds2_.PHONENUMBER as PHONENU35_20_0_, insureds2_.POSTALCODE as POSTALCODE20_0_, insureds2_.PROVINCE as PROVINCE20_0_, insureds2_.ROLESERIALNO as ROLESER38_20_0_, insureds2_.SMOKERAMOUNTBYYEAR as SMOKERA39_20_0_, insureds2_.SMOKERSTATUS as SMOKERS40_20_0_, insureds2_.SMOKERYEARS as SMOKERY41_20_0_, insureds2_.UPDATETIME as UPDATETIME20_0_, insureds2_.WEIGHT as WEIGHT20_0_, insureds2_.INDICAT ORMESSAGE as INDICAT48_20_0_, insureds2_.POLICYSERIALNO as POLICYS53_20_0_, insureds2_.INSUREDAMOUNTPERCENT as INSURED49_20_0_, insureds2_.ROLEORDER as ROLEORDER20_0_, insureds2_.MAININSUREDFLAG as MAININS50_20_0_, insureds2_.RELATEDTOAPPLICANT as RELATED51_20_0_, insureds2_.RELATEDTOINSURED as RELATED47_20_0_, insureds2_.SAMEINDUSTRYINSUREDAMOUNT as SAMEIND52_20_0_ from INSURANCEPOLICY this_ left outer join PARTYROLEINPOLICY insureds2_ on this_.SERIALNO=insureds2_.POLICYSERIALNO and ( insureds2_.ROLEKIND = 'Insured') where this_.MERCHANTORDERNUMBER=:1
6tqz17dynf5u0 select insuredlia0_.INSUREDSERIALNO as INSURED26_1_, insuredlia0_.SERIALNO as SERIALNO1_, insuredlia0_.SERIALNO as SERIALNO21_0_, insuredlia0_.BENEFITPERIOD as BENEFITP2_21_0_, insuredlia0_.BENEFITPERIODTYPE as BENEFITP3_21_0_, insuredlia0_.CORECODE as CORECODE21_0_, insuredlia0_.CREATETIME as CREATETIME21_0_, insuredlia0_.DEDUCTIBLES as DEDUCTIB6_21_0_, insuredlia0_.DISCOUNTPREMIUM as DISCOUNT7_21_0_, insuredlia0_.DISCOUNTRATE as DISCOUNT8_21_0_, insuredlia0_.DISCOUNTTYPECODE as DISCOUNT9_21_0_, insuredlia0_.GROUPTYPE as GROUPTYPE21_0_, insuredlia0_.INSURANCEENDPERIOD as INSURAN11_21_0_, insuredlia0_.INSURANCESTARTPERIOD as INSURAN12_21_0_, insuredlia0_.INSUREDSERIALNO as INSURED26_21_0_, insuredlia0_.INSUREDAMOUNT as INSURED13_21_0_, insuredlia0_.PARENTSERIALNO as PARENTS27_21_0_, insuredlia0_.LIABILITYCODE as LIABILI14_21_0_, insuredlia0_.LIABILITYID as LIABILI15_21_0_, insuredlia0_.LIABILITYNAME as LIABILI16_21_0_, insuredlia0_.LOSSRATIO as LOSSRATIO21_0_, insuredlia0_.PAYMENTDURATION as PAYMENT18_21_0_, insuredlia0_.PAYMENTDURATIONMODE as PAYMENT19_21_0_, insuredlia0_.PAYMENTMODE as PAYMENT20_21_0_, insuredlia0_.PREMIUM as PREMIUM21_0_, insuredlia0_.PRODUCTCODE as PRODUCT22_21_0_, insuredlia0_.PRODUCTNAME as PRODUCT23_21_0_, insuredlia0_.SUBRISKFLAG as SUBRISK24_21_0_, insuredlia0_.UPDATETIME as UPDATETIME21_0_ from INSUREDLIABILITY insuredlia0_ where insuredlia0_.INSUREDSERIALNO=:1
6vwc7wa57jdzj select orderform0_.SERIALNO as SERIALNO19_0_, orderform0_.BANKORDERNO as BANKORDE2_19_0_, orderform0_.CREATETIME as CREATETIME19_0_, orderform0_.CUSTOMERID as CUSTOMERID19_0_, orderform0_.GATEWAYORDERNO as GATEWAYO5_19_0_, orderform0_.POLICYSERIALNO as POLICYS32_19_0_, orderform0_.merchantOrderNumber as merchant6_19_0_, orderform0_.OPERATORID as OPERATORID19_0_, orderform0_.ORDERAMOUNT as ORDERAMO8_19_0_, orderform0_.ORDERSERIALNUMBER as ORDERSER9_19_0_, orderform0_.ORDERSTATUS as ORDERST10_19_0_, orderform0_.ORDERSTATUSDESC as ORDERST11_19_0_, orderform0_.ORDERSTATUSNAME as ORDERST12_19_0_, orderform0_.ORDERTYPE as ORDERTYPE19_0_, orderform0_.PAYMETHOD as PAYMETHOD19_0_, orderform0_.PAYSTATUS as PAYSTATUS19_0_, orderform0_.PAYSTATUSDESC as PAYSTAT16_19_0_, orderform0_.PAYSTATUSNAME as PAYSTAT17_19_0_, orderform0_.PAYTIME as PAYTIME19_0_, orderform0_.PAYERCONTACT as PAYERCO19_19_0_, orderform0_.PAYERCONTACTTYPE as PAYERCO20_19_0_, orderform0_.PAYERIP as PAYERIP19_0_, orderform0_.PAYMENTMETHOD as PAYMENT22_19_0_, orderform0_.PERSONALUSERSERIALNO as PERSONA23_19_0_, orderform0_.PRODUCTCODE as PRODUCT24_19_0_, orderform0_.PRODUCTDESC as PRODUCT25_19_0_, orderform0_.PRODUCTNAME as PRODUCT26_19_0_, orderform0_.PRODUCTNUMBER as PRODUCT27_19_0_, orderform0_.REFUNDMENTFLAG as REFUNDM28_19_0_, orderform0_.SUBMITTIME as SUBMITTIME19_0_, orderform0_.TRANSSERIALNUMBER as TRANSSE30_19_0_, orderform0_.UPDATETIME as UPDATETIME19_0_ from ORDERFORM orderform0_ w here orderform0_.POLICYSERIALNO=:1
6x0wjqbj0rfrp select insurancep0_.POLICYSERIALNO as POLICYS26_1_, insurancep0_.SERIALNO as SERIALNO1_, insurancep0_.SERIALNO as SERIALNO24_0_, insurancep0_.BENEFITPERIOD as BENEFITP2_24_0_, insurancep0_.BENEFITPERIODTYPE as BENEFITP3_24_0_, insurancep0_.CORECODE as CORECODE24_0_, insurancep0_.CREATETIME as CREATETIME24_0_, insurancep0_.DEDUCTIBLES as DEDUCTIB6_24_0_, insurancep0_.DISCOUNTPREMIUM as DISCOUNT7_24_0_, insurancep0_.DISCOUNTRATE as DISCOUNT8_24_0_, insurancep0_.DISCOUNTTYPECODE as DISCOUNT9_24_0_, insurancep0_.GROUPTYPE as GROUPTYPE24_0_, insurancep0_.INSURANCEENDPERIOD as INSURAN11_24_0_, insurancep0_.POLICYSERIALNO as POLICYS26_24_0_, insurancep0_.PARENTSERIALNO as PARENTS27_24_0_, insurancep0_.INSURANCESTARTPERIOD as INSURAN12_24_0_, insurancep0_.INSUREDAMOUNT as INSURED13_24_0_, insurancep0_.LIABILITYCODE as LIABILI14_24_0_, insurancep0_.LIABILITYID as LIABILI15_24_0_, insurancep0_.LIABILITYNAME as LIABILI16_24_0_, insurancep0_.LOSSRATIO as LOSSRATIO24_0_, insurancep0_.PAYMENTDURATION as PAYMENT18_24_0_, insurancep0_.PAYMENTDURATIONMODE as PAYMENT19_24_0_, insurancep0_.PAYMENTMODE as PAYMENT20_24_0_, insurancep0_.PREMIUM as PREMIUM24_0_, insurancep0_.PRODUCTCODE as PRODUCT22_24_0_, insurancep0_.PRODUCTNAME as PRODUCT23_24_0_, insurancep0_.SUBRISKFLAG as SUBRISK24_24_0_, insurancep0_.UPDATETIME as UPDATETIME24_0_ from INSURANCEPOLICYLIABILITY insurancep0_ where insurancep0_.POLICYSERIALNO=:1
89qyn4bbt03jqSELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME
8as3cambv69h4select paymentacc0_.SERIALNO as SERIALNO12_0_, paymentacc0_.ACCOUNTNUMBER as ACCOUNTN2_12_0_, paymentacc0_.ACCOUNTNUMBERCONFIRM as ACCOUNTN3_12_0_, paymentacc0_.ACCOUNTTIME as ACCOUNTT4_12_0_, paymentacc0_.ACCTHOLDERID as ACCTHOLD5_12_0_, paymentacc0_.ACCTHOLDERNAME as ACCTHOLD6_12_0_, paymentacc0_.ACCTIDNUMBER as ACCTIDNU7_12_0_, paymentacc0_.ACCTMOBILEPHONE as ACCTMOBI8_12_0_, paymentacc0_.BANKACCTTYPE as BANKACCT9_12_0_, paymentacc0_.BANKBRANCHCODE as BANKBRA10_12_0_, paymentacc0_.BANKBRANCHNAME as BANKBRA11_12_0_, paymentacc0_.BANKCARDCVTWO as BANKCAR12_12_0_, paymentacc0_.BANKCODE as BANKCODE12_0_, paymentacc0_.BANKNAME as BANKNAME12_0_, paymentacc0_.CARDEFFECTIVEDATE as CARDEFF15_12_0_, paymentacc0_.CARDORBOOK as CARDORBOOK12_0_, paymentacc0_.CHECKPAYNUMBER as CHECKPA17_12_0_, paymentacc0_.CREATETIME as CREATETIME12_0_, paymentacc0_.CURRENCYTYPECODE as CURRENC19_12_0_, paymentacc0_.POLICYSERIALNO as POLICYS25_12_0_, paymentacc0_.OPERATORID as OPERATORID12_0_, paymentacc0_.PAYAMOUNT as PAYAMOUNT12_0_, paymentacc0_.PAYORDERSERIALNUMBER as PAYORDE22_12_0_, paymentacc0_.PAYTIME as PAYTIME12_0_, paymentacc0_.UPDATETIME as UPDATETIME12_0_ from PAYMENTACCOUNT paymentacc0_ where paymentacc0_.POLICYSERIALNO=:1
9586ta28zmrtt insert into INSURANCEPOLICY (AGENTCODE, AGENTNAME, AGREEMENTNO, ALLOWPARTYWITHDROWFLAG, ANNUITYPAYOUTDURATION, ANNUITYPAYOUTDURATIONMODE, APPLICATIONNUMBER, APPLICATIONSERIALNUMBER, AUTORENEWABLE, BANKCODE, BENEFICIARYMODE, BENEFITMODE, BENEFITPERIOD, BENEFITPERIODTYPE, BRANCHCODE, BRANCHNAME, CAMPAIGNCODE, CAMPAIGNNAME, CASHVALUE, CERTIFICATIONREQUIRED, COMBOCODE, COMBONAME, CONTRACTNAMES, CREATETIME, CUSTOMERID, DELIVERYEPOLICY, DELIVERYHARDCOPY, DELIVERYINVOICE, DEPARTMENTNAME, DEPARTMENTNO, DISCOUNTPREMIUM, DISCOUNTRATE, DISCOUNTTYPECODE, DIVTYPE, ELECTRONICAPPLICANTNUMBER, ELECTRONICPOLICYNUMBER, EXCESSPREMAMT, FACEAMOUNT, FIRSTPREMIUM, FORMID, FUNDTRANSFERDATEBASEDON, GENERATEELECTRONICPOLICYSTATUS, GROSSPREMIUM, INCEPTIONDATE, INITIALPREMAMT, INSTITUTIONCODE, INSTITUTIONNAME, INSURANCEENDPERIOD, INSURANCESTARTPERIOD, INSUREDAMOUNT, INTERMEDIARYCODE, INTERMEDIARYNAME, MERCHANTORDERNUMBER, MERCHANTPRODUCTCODE, MERCHANTPRODUCTNAME, MERCHANTTRANSSERIALNUMBER, MUSTCANCELFLAG, OPERATORID, ORDERSERIALNUMBER, ORGANIZATIONCODE, ORGANIZATIONNAME, PAYMENTDURATION, PAYMENTDURATIONMODE, PAYMENTMETHOD, PAYMENTMODE, PAYOUTEND, PAYOUTSTART, PERSONALUSERSERIALNO, POLICYDELIVERYFEE, POLICYSERIALNUMBER, POLICYSTATUS, POLICYSTATUSDESC, POLICYSTATUSMESSAGE, POLICYSTATUSNAME, POLICYTYPE, PREMIUM, PRESERVEACCEPTTIME, PRESERVEEFFECTIVETIME, PRODUCTCODE, PRODUCTNAME, REFUNDPOLICYSUCCESSTIME, REFUNDPOLICYTIME, REQ UIREVISA, REVERSALFLAG, SIGNEDDATE, SPECIALSTATEMENT, SUBMISSIONDATE, SYNCENDTIME, SYNCSTARTTIME, SYNCSTATUS, SYNCSTATUSDESC, TRANSIDENTIFY, TRANSSERIALNUMBER, TRAVELDESTINATION, UNITCOUNT, UPDATETIME, SERIALNO) 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 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 )
9mq1qhcf3w76j update INSURANCEPOLICY set AGENTCODE=:1 , AGENTNAME=:2 , AGREEMENTNO=:3 , ALLOWPARTYWITHDROWFLAG=:4 , ANNUITYPAYOUTDURATION=:5 , ANNUITYPAYOUTDURATIONMODE=:6 , APPLICATIONNUMBER=:7 , APPLICATIONSERIALNUMBER=:8 , AUTORENEWABLE=:9 , BANKCODE=:10 , BENEFICIARYMODE=:11 , BENEFITMODE=:12 , BENEFITPERIOD=:13 , BENEFITPERIODTYPE=:14 , BRANCHCODE=:15 , BRANCHNAME=:16 , CAMPAIGNCODE=:17 , CAMPAIGNNAME=:18 , CASHVALUE=:19 , CERTIFICATIONREQUIRED=:20 , COMBOCODE=:21 , COMBONAME=:22 , CONTRACTNAMES=:23 , CREATETIME=:24 , CUSTOMERID=:25 , DELIVERYEPOLICY=:26 , DELIVERYHARDCOPY=:27 , DELIVERYINVOICE=:28 , DEPARTMENTNAME=:29 , DEPARTMENTNO=:30 , DISCOUNTPREMIUM=:31 , DISCOUNTRATE=:32 , DISCOUNTTYPECODE=:33 , DIVTYPE=:34 , ELECTRONICAPPLICANTNUMBER=:35 , ELECTRONICPOLICYNUMBER=:36 , EXCESSPREMAMT=:37 , FACEAMOUNT=:38 , FIRSTPREMIUM=:39 , FORMID=:40 , FUNDTRANSFERDATEBASEDON=:41 , GENERATEELECTRONICPOLICYSTATUS=:42 , GROSSPREMIUM=:43 , INCEPTIONDATE=:44 , INITIALPREMAMT=:45 , INSTITUTIONCODE=:46 , INSTITUTIONNAME=:47 , INSURANCEENDPERIOD=:48 , INSURANCESTARTPERIOD=:49 , INSUREDAMOUNT=:50 , INTERMEDIARYCODE=:51 , INTERMEDIARYNAME=:52 , MERCHANTORDERNUMBER=:53 , MERCHANTPRODUCTCODE=:54 , MERCHANTPRODUCTNAME=:55 , MERCHANTTRANSSERIALNUMBER=:56 , MUSTCANCELFLAG=:57 , OPERATORID=:58 , ORDERSERIALNUMBER=:59 , ORGANIZATIONCODE=:60 , ORGANIZATIONNAME=:61 , PAYMENTDURATION=:62 , PAYMENTDURATIONMODE=:63 , PAYMENTMETHOD=:64 , PAYMENTMODE=:6 5 , PAYOUTEND=:66 , PAYOUTSTART=:67 , PERSONALUSERSERIALNO=:68 , POLICYDELIVERYFEE=:69 , POLICYSERIALNUMBER=:70 , POLICYSTATUS=:71 , POLICYSTATUSDESC=:72 , POLICYSTATUSMESSAGE=:73 , POLICYSTATUSNAME=:74 , POLICYTYPE=:75 , PREMIUM=:76 , PRESERVEACCEPTTIME=:77 , PRESERVEEFFECTIVETIME=:78 , PRODUCTCODE=:79 , PRODUCTNAME=:80 , REFUNDPOLICYSUCCESSTIME=:81 , REFUNDPOLICYTIME=:82 , REQUIREVISA=:83 , REVERSALFLAG=:84 , SIGNEDDATE=:85 , SPECIALSTATEMENT=:86 , SUBMISSIONDATE=:87 , SYNCENDTIME=:88 , SYNCSTARTTIME=:89 , SYNCSTATUS=:90 , SYNCSTATUSDESC=:91 , TRANSIDENTIFY=:92 , TRANSSERIALNUMBER=:93 , TRAVELDESTINATION=:94 , UNITCOUNT=:95 , UPDATETIME=:96 where SERIALNO=:97
b1xh58mk37aq0insert into INSURANCEPOLICYLIABILITY (BENEFITPERIOD, BENEFITPERIODTYPE, CORECODE, CREATETIME, DEDUCTIBLES, DISCOUNTPREMIUM, DISCOUNTRATE, DISCOUNTTYPECODE, GROUPTYPE, INSURANCEENDPERIOD, POLICYSERIALNO, PARENTSERIALNO, INSURANCESTARTPERIOD, INSUREDAMOUNT, LIABILITYCODE, LIABILITYID, LIABILITYNAME, LOSSRATIO, PAYMENTDURATION, PAYMENTDURATIONMODE, PAYMENTMODE, PREMIUM, PRODUCTCODE, PRODUCTNAME, SUBRISKFLAG, UPDATETIME, SERIALNO) 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 )
bgach9vwgy8h4select POLICYSERIALNUMBERSEQUENCE.nextval from dual
bm7q8ztw8674bselect addressee0_.SERIALNO as SERIALNO15_0_, addressee0_.CITY as CITY15_0_, addressee0_.CONSIGNEEADDRESS as CONSIGNE3_15_0_, addressee0_.CONSIGNEENAME as CONSIGNE4_15_0_, addressee0_.COUNTY as COUNTY15_0_, addressee0_.CREATETIME as CREATETIME15_0_, addressee0_.EMAIL as EMAIL15_0_, addressee0_.FIXEDPHONE as FIXEDPHONE15_0_, addressee0_.POLICYSERIALNO as POLICYS14_15_0_, addressee0_.PROVINCE as PROVINCE15_0_, addressee0_.REMARK as REMARK15_0_, addressee0_.TELEPHONE as TELEPHONE15_0_, addressee0_.UPDATETIME as UPDATETIME15_0_, addressee0_.ZIPCODE as ZIPCODE15_0_ from ADDRESSEE addressee0_ where addressee0_.POLICYSERIALNO=:1
cj620gtn0n4csupdate INSURANCEPOLICYLIABILITY set BENEFITPERIOD=:1 , BENEFITPERIODTYPE=:2 , CORECODE=:3 , CREATETIME=:4 , DEDUCTIBLES=:5 , DISCOUNTPREMIUM=:6 , DISCOUNTRATE=:7 , DISCOUNTTYPECODE=:8 , GROUPTYPE=:9 , INSURANCEENDPERIOD=:10 , POLICYSERIALNO=:11 , PARENTSERIALNO=:12 , INSURANCESTARTPERIOD=:13 , INSUREDAMOUNT=:14 , LIABILITYCODE=:15 , LIABILITYID=:16 , LIABILITYNAME=:17 , LOSSRATIO=:18 , PAYMENTDURATION=:19 , PAYMENTDURATIONMODE=:20 , PAYMENTMODE=:21 , PREMIUM=:22 , PRODUCTCODE=:23 , PRODUCTNAME=:24 , SUBRISKFLAG=:25 , UPDATETIME=:26 where SERIALNO=:27
cnjhvnr16479winsert into PARTYROLEINPOLICY (ACCEPTSMS, ADDRESSLINES, AGE, AGEINDAY, ANNUALINCOME, BIRTHDATE, BIRTHWEIGHT, CITIZENSHIP, CITY, CREATETIME, CUSTOMFLAG, CUSTOMERID, DRINKERAMOUNTBYYEAR, DRINKERSTATUS, DRINKERYEARS, EMAIL, EMPLOYERFULLNAME, FULLENNAME, FULLNAME, GENDER, HEIGHT, HOMEADDRESS, IDEXPDATE, IDNUMBER, IDTYPE, MARITALSTATUS, MOBILEPHONENUMBER, OCCUPATIONCLASS, OCCUPATIONCODE, OCCUPATIONDESCRIPTION, OFFICEADDRESS, OFFICEPHONENUMBER, PHONENUMBER, POSTALCODE, PROVINCE, ROLESERIALNO, SMOKERAMOUNTBYYEAR, SMOKERSTATUS, SMOKERYEARS, UPDATETIME, WEIGHT, INDICATORMESSAGE, POLICYSERIALNO, INSUREDAMOUNTPERCENT, ROLEORDER, MAININSUREDFLAG, RELATEDTOAPPLICANT, RELATEDTOINSURED, SAMEINDUSTRYINSUREDAMOUNT, ROLEKIND, SERIALNO) 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 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , 'Insured', :50 )
d7p23cnk01by1insert into INSUREINFORMBOOK (CREATETIME, INFORMCODE, INFORMCONTENT, INFORMORDER, INFORMTYPE, INFORMTYPENAME, POLICYSERIALNO, UPDATETIME, SERIALNO) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 )
f3n0ngjdmjwr4 select insurancea0_.SERIALNO as SERIALNO20_0_, insurancea0_.ACCEPTSMS as ACCEPTSMS20_0_, insurancea0_.ADDRESSLINES as ADDRESSL4_20_0_, insurancea0_.AGE as AGE20_0_, insurancea0_.AGEINDAY as AGEINDAY20_0_, insurancea0_.ANNUALINCOME as ANNUALIN7_20_0_, insurancea0_.BIRTHDATE as BIRTHDATE20_0_, insurancea0_.BIRTHWEIGHT as BIRTHWEI9_20_0_, insurancea0_.CITIZENSHIP as CITIZEN10_20_0_, insurancea0_.CITY as CITY20_0_, insurancea0_.CREATETIME as CREATETIME20_0_, insurancea0_.CUSTOMFLAG as CUSTOMFLAG20_0_, insurancea0_.CUSTOMERID as CUSTOMERID20_0_, insurancea0_.DRINKERAMOUNTBYYEAR as DRINKER15_20_0_, insurancea0_.DRINKERSTATUS as DRINKER16_20_0_, insurancea0_.DRINKERYEARS as DRINKER17_20_0_, insurancea0_.EMAIL as EMAIL20_0_, insurancea0_.EMPLOYERFULLNAME as EMPLOYE19_20_0_, insurancea0_.FULLENNAME as FULLENNAME20_0_, insurancea0_.FULLNAME as FULLNAME20_0_, insurancea0_.GENDER as GENDER20_0_, insurancea0_.HEIGHT as HEIGHT20_0_, insurancea0_.HOMEADDRESS as HOMEADD24_20_0_, insurancea0_.IDEXPDATE as IDEXPDATE20_0_, insurancea0_.IDNUMBER as IDNUMBER20_0_, insurancea0_.IDTYPE as IDTYPE20_0_, insurancea0_.MARITALSTATUS as MARITAL28_20_0_, insurancea0_.MOBILEPHONENUMBER as MOBILEP29_20_0_, insurancea0_.OCCUPATIONCLASS as OCCUPAT30_20_0_, insurancea0_.OCCUPATIONCODE as OCCUPAT31_20_0_, insurancea0_.OCCUPATIONDESCRIPTION as OCCUPAT32_20_0_, insurancea0_.OFFICEADDRESS as OFFICEA33_20_0_, insurancea0_.OFFICEPHONENUMBER as OFFICEP34_20_0_, insurancea0_.PHONENUMBE R as PHONENU35_20_0_, insurancea0_.POSTALCODE as POSTALCODE20_0_, insurancea0_.PROVINCE as PROVINCE20_0_, insurancea0_.ROLESERIALNO as ROLESER38_20_0_, insurancea0_.SMOKERAMOUNTBYYEAR as SMOKERA39_20_0_, insurancea0_.SMOKERSTATUS as SMOKERS40_20_0_, insurancea0_.SMOKERYEARS as SMOKERY41_20_0_, insurancea0_.UPDATETIME as UPDATETIME20_0_, insurancea0_.WEIGHT as WEIGHT20_0_, insurancea0_.POLICYSERIALNO as POLICYS53_20_0_, insurancea0_.RELATEDTOINSURED as RELATED47_20_0_ from PARTYROLEINPOLICY insurancea0_ where insurancea0_.POLICYSERIALNO=:1 and insurancea0_.ROLEKIND='InsuranceApplicant'
fbgc81kg73hksupdate INSURANCEPOLICYPROCESS set CREATETIME=:1 , INSTITUTIONCODE=:2 , INSTITUTIONNAME=:3 , LOCKSTATUS=:4 , LOCKEDREASON=:5 , MERCHANTORDERNUMBER=:6 , POLICYSERIALNUMBER=:7 , PROCESSENDTIME=:8 , PROCESSSTARTTIME=:9 , PROCESSSTATUS=:10 , PROCESSSTATUSDESC=:11 , SERVICENAME=:12 , UPDATETIME=:13 where SERIALNO=:14
g0vfsxvwfmsdvinsert into INSURANCEPOLICYPROCESS (CREATETIME, INSTITUTIONCODE, INSTITUTIONNAME, LOCKSTATUS, LOCKEDREASON, MERCHANTORDERNUMBER, POLICYSERIALNUMBER, PROCESSENDTIME, PROCESSSTARTTIME, PROCESSSTATUS, PROCESSSTATUSDESC, SERVICENAME, UPDATETIME, SERIALNO) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,274,215 353.78 6.45
CPU used when call started 1,273,891 353.69 6.45
CR blocks created 206,045 57.21 1.04
Cached Commit SCN referenced 374 0.10 0.00
Commit SCN cached 1 0.00 0.00
DB time 2,384,596 662.06 12.08
DBWR checkpoint buffers written 47,853 13.29 0.24
DBWR checkpoints 3 0.00 0.00
DBWR transaction table writes 113 0.03 0.00
DBWR undo block writes 23,733 6.59 0.12
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 12,290 3.41 0.06
IMU Flushes 32,854 9.12 0.17
IMU Redo allocation size 200,952,208 55,792.72 1,017.94
IMU commits 158,108 43.90 0.80
IMU contention 4,927 1.37 0.02
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 7,323 2.03 0.04
IMU recursive-transaction flush 119 0.03 0.00
IMU undo allocation size 981,548,624 272,518.86 4,972.13
IMU- failed to get a private strand 7,323 2.03 0.04
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
RowCR - row contention 226 0.06 0.00
RowCR attempts 6,075 1.69 0.03
RowCR hits 6,416 1.78 0.03
SMON posted for undo segment shrink 33 0.01 0.00
SQL*Net roundtrips to/from client 1,362,991 378.42 6.90
active txn count during cleanout 24,360 6.76 0.12
application wait time 4 0.00 0.00
background checkpoints completed 3 0.00 0.00
background checkpoints started 3 0.00 0.00
background timeouts 13,990 3.88 0.07
branch node splits 26 0.01 0.00
buffer is not pinned count 285,363,475 79,228.81 1,445.54
buffer is pinned count 1,585,736,994 440,266.77 8,032.71
bytes received via SQL*Net from client 1,268,742,418 352,255.84 6,426.94
bytes sent via SQL*Net to client 807,098,962 224,084.35 4,088.44
calls to get snapshot scn: kcmgss 3,546,095 984.54 17.96
calls to kcmgas 423,063 117.46 2.14
calls to kcmgcs 9,763 2.71 0.05
change write time 1,500 0.42 0.01
cleanout - number of ktugct calls 29,695 8.24 0.15
cleanouts and rollbacks - consistent read gets 15,432 4.28 0.08
cleanouts only - consistent read gets 2,117 0.59 0.01
cluster key scan block gets 5,241 1.46 0.03
cluster key scans 1,718 0.48 0.01
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 82 0.02 0.00
commit batch/immediate requested 82 0.02 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 1,525 0.42 0.01
commit cleanout failures: cannot pin 2,400 0.67 0.01
commit cleanouts 611,898 169.89 3.10
commit cleanouts successfully completed 607,972 168.80 3.08
commit immediate performed 82 0.02 0.00
commit immediate requested 82 0.02 0.00
commit txn count during cleanout 14,821 4.11 0.08
concurrency wait time 135 0.04 0.00
consistent changes 286,032 79.41 1.45
consistent gets 2,460,734,908 683,202.71 12,465.10
consistent gets - examination 476,147,993 132,198.55 2,411.98
consistent gets direct 14 0.00 0.00
consistent gets from cache 2,460,734,961 683,202.72 12,465.10
cursor authentications 185 0.05 0.00
data blocks consistent reads - undo records applied 279,198 77.52 1.41
db block changes 1,925,319 534.55 9.75
db block gets 3,002,883 833.73 15.21
db block gets direct 40 0.01 0.00
db block gets from cache 3,002,843 833.71 15.21
deferred (CURRENT) block cleanout applications 324,757 90.17 1.65
enqueue conversions 99,086 27.51 0.50
enqueue releases 713,394 198.07 3.61
enqueue requests 713,395 198.07 3.61
enqueue timeouts 1 0.00 0.00
enqueue waits 113 0.03 0.00
exchange deadlocks 73 0.02 0.00
execute count 953,979 264.86 4.83
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 46,290 12.85 0.23
free buffer requested 234,827 65.20 1.19
heap block compress 23,995 6.66 0.12
hot buffers moved to head of LRU 47,060 13.07 0.24
immediate (CR) block cleanout applications 17,550 4.87 0.09
immediate (CURRENT) block cleanout applications 10,082 2.80 0.05
index crx upgrade (positioned) 12,648 3.51 0.06
index fast full scans (full) 29 0.01 0.00
index fetch by key 307,489 85.37 1.56
index scans kdiixs1 474,913,768 131,855.88 2,405.72
leaf node 90-10 splits 605 0.17 0.00
leaf node splits 3,566 0.99 0.02
lob reads 18 0.00 0.00
lob writes 92 0.03 0.00
lob writes unaligned 92 0.03 0.00
logons cumulative 122 0.03 0.00
messages received 203,809 56.59 1.03
messages sent 203,809 56.59 1.03
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,981,777,818 550,224.23 10,038.89
opened cursors cumulative 631,800 175.41 3.20
parse count (failures) 10 0.00 0.00
parse count (hard) 358 0.10 0.00
parse count (total) 631,323 175.28 3.20
parse time cpu 1,943 0.54 0.01
parse time elapsed 2,124 0.59 0.01
physical read IO requests 180 0.05 0.00
physical read bytes 1,843,200 511.75 9.34
physical read total IO requests 7,267 2.02 0.04
physical read total bytes 686,472,192 190,593.33 3,477.39
physical read total multi block requests 564 0.16 0.00
physical reads 225 0.06 0.00
physical reads cache 211 0.06 0.00
physical reads cache prefetch 45 0.01 0.00
physical reads direct 14 0.00 0.00
physical reads direct (lob) 14 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 45 0.01 0.00
physical write IO requests 8,620 2.39 0.04
physical write bytes 392,339,456 108,929.81 1,987.43
physical write total IO requests 255,077 70.82 1.29
physical write total bytes 3,867,935,744 1,073,900.38 19,593.41
physical write total multi block requests 241,406 67.02 1.22
physical writes 47,893 13.30 0.24
physical writes direct 40 0.01 0.00
physical writes direct (lob) 6 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 47,853 13.29 0.24
physical writes non checkpoint 27,419 7.61 0.14
pinned cursors current 25 0.01 0.00
prefetch warmup blocks aged out before use 16 0.00 0.00
process last non-idle time 5,033 1.40 0.03
queries parallelized 0 0.00 0.00
recursive calls 545,719 151.51 2.76
recursive cpu usage 3,355 0.93 0.02
redo blocks written 1,132,393 314.40 5.74
redo buffer allocation retries 13 0.00 0.00
redo entries 648,171 179.96 3.28
redo log space requests 14 0.00 0.00
redo log space wait time 22 0.01 0.00
redo ordering marks 14,042 3.90 0.07
redo size 519,782,416 144,313.29 2,633.01
redo subscn max counts 25,008 6.94 0.13
redo synch time 33,320 9.25 0.17
redo synch writes 198,358 55.07 1.00
redo wastage 41,546,124 11,534.94 210.46
redo write time 23,048 6.40 0.12
redo writer latching time 4 0.00 0.00
redo writes 193,165 53.63 0.98
rollback changes - undo records applied 284 0.08 0.00
rollbacks only - consistent read gets 194,909 54.11 0.99
root node splits 0 0.00 0.00
rows fetched via callback 65,763 18.26 0.33
session connect time 0 0.00 0.00
session cursor cache hits 623,838 173.20 3.16
session logical reads 2,463,735,633 684,035.83 12,480.30
shared hash latch upgrades - no wait 21,297 5.91 0.11
shared hash latch upgrades - wait 153 0.04 0.00
sorts (memory) 5,013 1.39 0.03
sorts (rows) 68,034 18.89 0.34
sql area evicted 339 0.09 0.00
sql area purged 22 0.01 0.00
switch current to new buffer 957 0.27 0.00
table fetch by rowid 474,950,269 131,866.02 2,405.91
table fetch continued row 91 0.03 0.00
table scan blocks gotten 1,221,992,136 339,276.01 6,190.12
table scan rows gotten 27,020,854,351 7,502,116.84 136,876.83
table scans (long tables) 1 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 396,413 110.06 2.01
total number of times SMON posted 33 0.01 0.00
transaction rollbacks 82 0.02 0.00
undo change vector size 169,802,036 47,144.13 860.15
user I/O wait time 297 0.08 0.00
user calls 1,979,293 549.53 10.03
user commits 197,374 54.80 1.00
user rollbacks 36 0.01 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 3,688 1.02 0.02
write clones created in foreground 2 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 7,810,246,240 8,009,278,232
session cursor cache count 108,229 110,783
session uga memory 1.1E+13 1.1E+13
opened cursors current 2,858 3,186
logons current 356 355
session uga memory max 6,274,396,680 6,449,759,536
session pga memory 6,250,079,168 6,369,943,672

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 3 3.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SOOCHOWLIFE 135 0 0.00 1.00 5,904 2 1,726 0.06
UNDOTBS1 0 0 0.00 0.00 1,715 0 564 0.04
SYSAUX 37 0 0.81 2.22 850 0 0 0.00
SYSTEM 8 0 1.25 1.00 150 0 0 0.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)
SOOCHOWLIFE /oracle/oradata/middb/soochowlife01.dbf 120 0 0.00 1.00 1,540 0 356 0.06
SOOCHOWLIFE /oracle/oradata/middb/soochowlife02.dbf 15 0 0.00 1.00 1,558 0 559 0.04
SOOCHOWLIFE /oracle/oradata/middb/soochowlife03.dbf 0 0     1,525 0 530 0.09
SOOCHOWLIFE /oracle/oradata/middb/soochowlife04.dbf 0 0     1,281 0 281 0.04
SYSAUX /oracle/oradata/middb/sysaux01.dbf 37 0 0.81 2.22 850 0 0 0.00
SYSTEM /oracle/oradata/middb/system01.dbf 8 0 1.25 1.00 150 0 0 0.00
UNDOTBS1 /oracle/oradata/middb/undotbs01.dbf 0 0     1,715 0 564 0.04

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 203,837 100 2,455,174,474 211 47,853 0 0 2,290


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
B 0 13 5070 123404 356972 3317760 356972  
E 0 14 6366 123617 583994 3317760 583994  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 160 0.10 19,790 4650.14 217,784,479
D 320 0.19 39,580 2.04 95,619
D 480 0.29 59,370 1.15 54,052
D 640 0.39 79,160 1.00 47,018
D 800 0.49 98,950 1.00 46,840
D 960 0.58 118,740 1.00 46,834
D 1,120 0.68 138,530 1.00 46,834
D 1,280 0.78 158,320 1.00 46,834
D 1,440 0.87 178,110 1.00 46,834
D 1,600 0.97 197,900 1.00 46,834
D 1,648 1.00 203,837 1.00 46,834
D 1,760 1.07 217,690 1.00 46,834
D 1,920 1.17 237,480 1.00 46,834
D 2,080 1.26 257,270 1.00 46,834
D 2,240 1.36 277,060 1.00 46,834
D 2,400 1.46 296,850 1.00 46,834
D 2,560 1.55 316,640 1.00 46,834
D 2,720 1.65 336,430 1.00 46,834
D 2,880 1.75 356,220 1.00 46,834
D 3,040 1.84 376,010 1.00 46,834
D 3,200 1.94 395,800 0.86 40,442

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 247 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 4,812 4,141 275.19 0.00 0.00 0.00 0.00 492,740
E 4,812 4,126 305.24 0.00 0.00 0.00 0.00 492,740

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,417 3,417 0 0
64K 128K 11 11 0 0
512K 1024K 239 239 0 0
1M 2M 20 20 0 0
32M 64M 1 1 0 0

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 Count
602 0.13 29,225.04 0.00 100.00 0
1,203 0.25 29,225.04 0.00 100.00 0
2,406 0.50 29,225.04 0.00 100.00 0
3,609 0.75 29,225.04 0.00 100.00 0
4,812 1.00 29,225.04 0.00 100.00 0
5,774 1.20 29,225.04 0.00 100.00 0
6,737 1.40 29,225.04 0.00 100.00 0
7,699 1.60 29,225.04 0.00 100.00 0
8,662 1.80 29,225.04 0.00 100.00 0
9,624 2.00 29,225.04 0.00 100.00 0
14,436 3.00 29,225.04 0.00 100.00 0
19,248 4.00 29,225.04 0.00 100.00 0
28,872 6.00 29,225.04 0.00 100.00 0
38,496 8.00 29,225.04 0.00 100.00 0

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)
64 0.18 53 4,191 85,864 1.00 190 1.20 8,673
112 0.32 97 7,036 85,885 1.00 169 1.06 8,679
160 0.45 144 9,119 85,892 1.00 162 1.02 8,681
208 0.59 191 11,883 85,895 1.00 159 1.00 8,683
256 0.73 238 13,974 85,895 1.00 159 1.00 8,683
304 0.86 256 14,895 85,895 1.00 159 1.00 8,683
352 1.00 256 14,895 85,895 1.00 159 1.00 8,683
400 1.14 256 14,895 85,895 1.00 159 1.00 8,683
448 1.27 256 14,895 85,895 1.00 159 1.00 8,683
496 1.41 256 14,895 85,895 1.00 159 1.00 8,683
544 1.55 256 14,895 85,895 1.00 159 1.00 8,683
592 1.68 256 14,895 85,895 1.00 159 1.00 8,683
640 1.82 256 14,895 85,895 1.00 159 1.00 8,683
688 1.95 256 14,895 85,895 1.00 159 1.00 8,683
736 2.09 256 14,895 85,895 1.00 159 1.00 8,683

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
512 0.25 40,288 72,480
1,024 0.50 40,276 46,839
1,536 0.75 40,276 46,834
2,048 1.00 40,275 46,834
2,560 1.25 40,277 46,834
3,072 1.50 40,282 46,834
3,584 1.75 40,283 40,404
4,096 2.00 40,284 40,404

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,663 0 0
undo block 273 0 0
1st level bmb 41 0 0
undo header 291 0 0
segment header 18 0 0
2nd level bmb 4 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 86 86 0 86 0 0.12
TX-Transaction 202,828 202,843 0 4 0 2.50
SQ-Sequence Cache 1,253 1,253 0 17 0 0.00
HW-Segment High Water Mark 489 489 0 6 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 23.25 199,049 145 6 15/17.4 0/0 0/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
18-Jul 10:56 4,987 42,988 131 5 17 0/0 0/0/0/0/0/0
18-Jul 10:46 4,953 42,810 145 5 17 0/0 0/0/0/0/0/0
18-Jul 10:36 106 855 0 4 15 0/0 0/0/0/0/0/0
18-Jul 10:26 3,098 26,448 0 5 15 0/0 0/0/0/0/0/0
18-Jul 10:16 4,996 42,925 95 5 15 0/0 0/0/0/0/0/0
18-Jul 10:06 5,106 43,023 96 6 15 0/0 0/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 db client latch 2,493 0.00   0 0  
AWR Alerted Metric Element list 39,584 0.00   0 0  
Consistent RBA 193,172 0.00 0.00 0 0  
FAL request queue 78 0.00   0 0  
FAL subheap alocation 78 0.00   0 0  
FIB s.o chain latch 97 0.00   0 0  
FOB s.o list latch 568 0.00   0 0  
In memory undo latch 1,038,428 0.17 0.79 0 199,161 0.00
JS mem alloc latch 7 0.00   0 0  
JS queue access latch 7 0.00   0 0  
JS queue state obj latch 26,026 0.00   0 0  
JS slv state obj latch 48 0.00   0 0  
KMG MMAN ready and startup request latch 1,200 0.00   0 0  
KTF sga latch 8 0.00   0 1,192 0.00
KWQMN job cache list latch 90 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,200 0.00
OS process 303 0.00   0 0  
OS process allocation 1,401 0.07 0.00 0 0  
OS process: request allocation 121 0.00   0 0  
PL/SQL warning settings 1,463 0.00   0 0  
Reserved Space Latch 10 0.00   0 0  
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 84,092 0.00   0 0  
Shared B-Tree 135 0.00   0 0  
active checkpoint queue latch 12,228 0.32 0.00 0 0  
active service list 7,763 0.04 0.00 0 41,347 0.00
alert log latch 6 0.00   0 0  
archive control 233 0.00   0 0  
archive process latch 1,361 0.07 1.00 0 0  
begin backup scn array 10 0.00   0 0  
cache buffer handles 21,772 0.07 0.00 0 0  
cache buffers chains 4,458,389,381 3.02 0.00 1 227,962 0.05
cache buffers lru chain 97,902 0.06 0.00 0 412,123 0.02
channel handle pool latch 121 0.00   0 0  
channel operations parent latch 21,866 0.00   0 0  
checkpoint queue latch 442,318 0.00 0.00 0 48,934 0.00
client/application info 3,446 0.00   0 0  
compile environment latch 122 0.00   0 0  
dml lock allocation 952,339 0.28 0.00 0 0  
dummy allocation 245 0.41 0.00 0 0  
enqueue hash chains 1,525,999 0.07 0.00 0 0  
enqueues 489,352 0.19 0.00 0 0  
event group latch 60 0.00   0 0  
file cache latch 511 0.00   0 0  
global KZLD latch for mem in SGA 31 0.00   0 0  
hash table column usage latch 269 0.00   0 46,152 0.00
hash table modification latch 84 0.00   0 0  
internal temp table object number allocation latc 1 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes parameter latch 122 0.00   0 0  
kks stats 1,644 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 518 0.00   0 0  
ksuosstats global area 244 0.00   0 0  
ktm global data 104 0.00   0 0  
kwqbsn:qsga 135 0.00   0 0  
lgwr LWN SCN 195,558 0.06 0.00 0 0  
library cache 1,127,561 0.19 0.00 0 555 0.00
library cache load lock 1,030 0.00   0 0  
library cache lock 2,640,868 0.13 0.00 0 0  
library cache lock allocation 2,703 0.00   0 0  
library cache pin 171,082 0.09 0.00 0 0  
library cache pin allocation 836 0.00   0 0  
list of block allocation 460 0.00   0 0  
loader state object freelist 42 0.00   0 0  
longop free list parent 1 0.00   0 1 0.00
messages 642,243 0.08 0.00 0 0  
mostly latch-free SCN 195,637 0.08 0.00 0 0  
multiblock read objects 26 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 49,066 0.00   0 125 0.00
object queue header operation 235,037 0.01 0.00 0 0  
object stats modification 6 0.00   0 0  
parallel query alloc buffer 476 0.00   0 0  
parameter list 204 0.00   0 0  
parameter table management 250 0.00   0 0  
post/wait queue 302,485 0.00 0.00 0 207,191 0.10
process allocation 121 0.00   0 60 0.00
process group creation 121 0.00   0 0  
qmn task queue latch 516 0.00   0 0  
redo allocation 978,832 0.03 0.00 0 646,980 0.42
redo copy 0     0 648,169 0.19
redo writing 596,083 0.00 0.04 0 0  
resmgr group change latch 990 0.00   0 0  
resmgr:active threads 529 0.00   0 0  
resmgr:actses change group 698 0.00   0 0  
resmgr:actses change state 596 0.00   0 0  
resmgr:free threads list 229 0.44 0.00 0 0  
resmgr:resource group CPU method 401 0.25 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 151,628 0.18 0.00 0 267 0.00
sequence cache 76,673 0.16 0.00 0 0  
session allocation 847,627 0.38 0.00 0 0  
session idle bit 4,381,787 0.01 0.00 0 0  
session state list latch 296 0.00   0 0  
session switching 363 0.00   0 0  
session timer 1,223 0.00   0 0  
shared pool 39,045 0.11 0.00 0 0  
shared pool sim alloc 15 0.00   0 0  
shared pool simulator 3,127 0.00   0 0  
simulator hash latch 126,606,212 0.01 0.00 0 0  
simulator lru latch 47,853 0.39 0.00 0 126,555,976 3.38
slave class 8 0.00   0 0  
slave class create 32 3.13 1.00 0 0  
sort extent pool 118 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 1 0.00   0 0  
threshold alerts latch 239 0.00   0 0  
transaction allocation 276 0.00   0 0  
transaction branch allocation 1,223 0.00   0 0  
undo global data 1,251,321 0.32 0.00 0 0  
user lock 278 2.52 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 4,458,389,381 134,842,149 33,098 134,801,872 0 0 0
simulator hash latch 126,606,212 9,919 1 9,918 0 0 0
session allocation 847,627 3,255 13 3,245 0 0 0
dml lock allocation 952,339 2,644 1 2,643 0 0 0
In memory undo latch 1,038,428 1,730 1,365 481 0 0 0
enqueue hash chains 1,525,999 1,123 2 1,122 0 0 0
redo writing 596,083 24 1 23 0 0 0
archive process latch 1,361 1 1 0 0 0 0
slave class create 32 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch kticmt: child 0 926 63
In memory undo latch ktiFlush: child 0 474 162
In memory undo latch ktichg: child 0 135 272
In memory undo latch kturbk 0 25 1,048
In memory undo latch ktbgfc 0 1 5
archive process latch kcrrsarc 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 167,019 156,561
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 17,581 10,445
cache buffers chains kcbrls: kslbegin 0 4,746 15,873
cache buffers chains kcbgtcr: fast path 0 858 786
cache buffers chains kcbgcur: kslbegin 0 260 185
cache buffers chains kcbget: pin buffer 0 66 42
cache buffers chains kcbzwb 0 27 33
cache buffers chains kcbnew: new latch again 0 19 0
cache buffers chains kcbnlc 0 15 97
cache buffers chains kcbchg: kslbegin: call CR func 0 13 5,606
cache buffers chains kcbbxsv 0 8 1
cache buffers chains kcbzgb: scan from tail. nowait 0 6 0
cache buffers chains kcbget: exchange 0 2 18
cache buffers chains kcb_post_apply: kcbhq62 0 1 7
cache buffers chains kcbget: exchange rls 0 1 5
dml lock allocation ktaiam 0 1 0
enqueue hash chains ksqgtl3 0 2 2
object queue header operation kcbo_switch_q_bg 0 1 0
redo writing kcrfwcr 0 1 0
session allocation ksudlp 0 5 3
session allocation ksuxds: KSUSFCLC not set 0 4 6
session allocation ksucri 0 2 4
session allocation ksufap: active sessions 0 2 0
simulator hash latch kcbsacc: lookup dba 0 1 1
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
MIS SOOCHOWLIFE IDX$$_00B20001   INDEX 949,068,176 38.52
MIS SOOCHOWLIFE INSURANCEPOLICY   TABLE 551,652,048 22.39
MIS SOOCHOWLIFE PARTYROLEINPOLICY   TABLE 416,036,416 16.89
MIS SOOCHOWLIFE INSUREINFORMBOOK   TABLE 396,932,288 16.11
MIS SOOCHOWLIFE INSURANCEPOLICYPROCESS   TABLE 98,237,824 3.99

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYSMAN SYSAUX MGMT_METRICS_PK   INDEX 15 6.67
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 950709_203 TABLE PARTITION 15 6.67
SYS SYSAUX SYS_LOB0000003717C00007$$   LOB 8 3.56
SYS SYSAUX WRI$_ADV_MESSAGE_GROUPS_PK   INDEX 2 0.89

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
MIS SOOCHOWLIFE AK_INSURANCEPOLICYBAS_INSURANC   INDEX 220 74.32
MIS SOOCHOWLIFE INSUREINFORMBOOK_PK   INDEX 25 8.45
MIS SOOCHOWLIFE AK_PARTYROLEINPOLICY_INSURANC   INDEX 19 6.42
MIS SOOCHOWLIFE IDX$$_00B20001   INDEX 17 5.74
MIS SOOCHOWLIFE ADDRESS_POLICYSERIALNO_UK   INDEX 5 1.69

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
MIS SOOCHOWLIFE INSURANCEPOLICYPROCESS   TABLE 450 26.07
MIS SOOCHOWLIFE INSURANCEPOLICY   TABLE 277 16.05
MIS SOOCHOWLIFE AK_INSURANCEPOLICYBAS_INSURANC   INDEX 185 10.72
MIS SOOCHOWLIFE IDX$$_00B20001   INDEX 170 9.85
MIS SOOCHOWLIFE AK_PARTYROLEINPOLICY_INSURANC   INDEX 136 7.88

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 65 0.00 0   2 1
dc_database_links 82 0.00 0   0 1
dc_files 9 0.00 0   0 9
dc_global_oids 6,083 0.03 0   0 64
dc_histogram_data 3,379 1.30 0   0 3,930
dc_histogram_defs 4,690 6.50 0   0 3,822
dc_object_grants 45 46.67 0   0 172
dc_object_ids 10,504 0.61 0   0 1,195
dc_objects 1,595 13.04 0   9 1,280
dc_profiles 115 0.00 0   0 2
dc_rollback_segments 483 0.00 0   0 22
dc_segments 1,479 3.11 0   88 1,066
dc_sequences 1,236 0.00 0   1,236 6
dc_tablespace_quotas 79 0.00 0   79 2
dc_tablespaces 6,521 0.00 0   0 8
dc_usernames 676 0.15 0   0 45
dc_users 14,182 0.00 0   0 83
outstanding_alerts 86 0.00 0   0 15


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 911 0.66 9,365 0.18 8 0
CLUSTER 33 0.00 51 0.00 0 0
INDEX 14 7.14 62 1.61 0 0
SQL AREA 6,384 4.59 1,116,635 0.12 174 68
TABLE/PROCEDURE 1,720 3.31 66,829 0.75 228 0
TRIGGER 60 0.00 435 0.00 0 0


Back to Top

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
B Other 245.89   0.69 0.99 11 11 358 358
  Freeable 14.63 0.00 0.86 0.43 2   17 17
  SQL 13.93 8.80 0.04 0.03 0 5 346 344
  PL/SQL 0.98 0.31 0.00 0.01 0 0 356 356
E Other 265.10   0.74 0.99 11 11 357 357
  Freeable 23.56 0.00 0.87 0.37 2   27 27
  SQL 15.47 9.35 0.04 0.04 0 42 345 343
  PL/SQL 1.32 0.51 0.00 0.01 0 0 355 355

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1,728,053,248  
Fixed Size 2,118,256  
Redo Buffers 14,655,488  
Variable Size 11,140,074,896  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor 12.45 12.98 4.24
shared FileOpenBlock 6.99 6.99 0.00
shared Heap0: KGL 6.47 7.12 10.09
shared KCB Table Scan Buffer 4.00 4.00 0.00
shared KGLS heap 4.85 5.66 16.61
shared KSFD SGA I/O b 4.00 4.00 0.00
shared KTI-UNDO 6.51 6.51 0.00
shared PCursor 7.45 7.74 3.92
shared PL/SQL MPCODE 4.88 5.35 9.75
shared XDB Schema Cac 7.58 7.58 0.00
shared db_block_hash_buckets 11.25 11.25 0.00
shared event statistics per sess 7.99 7.99 0.00
shared free memory 55.30 50.63 -8.45
shared kglsim hash table bkts 4.00 4.00 0.00
shared library cache 20.92 21.14 1.06
shared parameter table block 4.40 4.39 -0.28
shared private strands 12.22 12.22 0.00
shared row cache 7.16 7.16 0.00
shared sessions 4.65 4.65 0.00
shared sql area 44.49 44.65 0.36
shared trace buffer 10.27 10.27 0.00
  buffer_cache 1,648.00 1,648.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
processes 358 658 800 800


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/middb/adump   
background_dump_dest /oracle/admin/middb/bdump   
compatible 10.2.0.5.0   
control_files /oracle/oradata/middb/control01.ctl, /oracle/oradata/middb/control02.ctl, /oracle/oradata/middb/control03.ctl   
core_dump_dest /oracle/admin/middb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name middb   
db_recovery_file_dest /oracle/flash_recovery_area   
db_recovery_file_dest_size 21474836480   
dispatchers (PROTOCOL=TCP) (SERVICE=middbXDB)   
job_queue_processes 10   
log_archive_dest_1 LOCATION=/archivelog/middb/   
log_archive_format %t_%s_%r.dbf   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 300   
pga_aggregate_target 5045747712   
processes 800   
remote_login_passwordfile EXCLUSIVE   
sga_max_size 12884901888   
sga_target 2147483648   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/middb/udump   


Back to Top

End of Report