WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

BUSDB 1036472754 busdb1 1 10.2.0.4.0 YES busdbr1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BUSDB	1036472754	busdb1	1	10.2.0.4.0	YES	busdbr1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 22217 26-Dec-12 08:00:09 1184 8.2

End Snap: 22218 26-Dec-12 09:00:15 1203 9.2

Elapsed: 60.11 (mins)

DB Time: 607.80 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	22217	26-Dec-12 08:00:09	1184	8.2
End Snap:	22218	26-Dec-12 09:00:15	1203	9.2
Elapsed:		60.11 (mins)
DB Time:		607.80 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 24,000M 24,000M Std Block Size: 8K

Shared Pool Size: 4,608M 4,608M Log Buffer: 47,052K

	Begin	End
Buffer Cache:	24,000M	24,000M	Std Block Size:	8K
Shared Pool Size:	4,608M	4,608M	Log Buffer:	47,052K

Load Profile

Per Second Per Transaction

Redo size: 56,659.15 5,108.76

Logical reads: 199,930.54 18,027.03

Block changes: 269.30 24.28

Physical reads: 15,478.91 1,395.68

Physical writes: 44.26 3.99

User calls: 3,317.67 299.14

Parses: 726.77 65.53

Hard parses: 241.02 21.73

Sorts: 10,561.42 952.29

Logons: 0.06 0.01

Executes: 2,063.78 186.08

Transactions: 11.09

	Per Second	Per Transaction
Redo size:	56,659.15	5,108.76
Logical reads:	199,930.54	18,027.03
Block changes:	269.30	24.28
Physical reads:	15,478.91	1,395.68
Physical writes:	44.26	3.99
User calls:	3,317.67	299.14
Parses:	726.77	65.53
Hard parses:	241.02	21.73
Sorts:	10,561.42	952.29
Logons:	0.06	0.01
Executes:	2,063.78	186.08
Transactions:	11.09

% Blocks changed per Read: 0.13 Recursive Call %: 27.80

Rollback per transaction %: 23.67 Rows per Sort: 8.79

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.63 Redo NoWait %: 99.99

Buffer Hit %: 92.27 In-memory Sort %: 100.00

Library Hit %: 67.26 Soft Parse %: 66.84

Execute to Parse %: 64.78 Latch Hit %: 98.45

Parse CPU to Parse Elapsd %: 19.19 % Non-Parse CPU: 96.66

Shared Pool Statistics

Begin End

Memory Usage %: 93.28 91.36

% SQL with executions>1: 84.54 86.12

% Memory for SQL w/exec>1: 60.51 66.95

	Begin	End
Memory Usage %:	93.28	91.36
% SQL with executions>1:	84.54	86.12
% Memory for SQL w/exec>1:	60.51	66.95

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 14,175 38.9

db file sequential read 3,970,591 12,309 3 33.8 User I/O

cursor: pin S wait on X 804,153 7,857 10 21.5 Concurrency

db file scattered read 3,986,390 3,168 1 8.7 User I/O

gc buffer busy 1,982,872 3,137 2 8.6 Cluster

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		14,175		38.9
db file sequential read	3,970,591	12,309	3	33.8	User I/O
cursor: pin S wait on X	804,153	7,857	10	21.5	Concurrency
db file scattered read	3,986,390	3,168	1	8.7	User I/O
gc buffer busy	1,982,872	3,137	2	8.6	Cluster

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 2,080.66 187.61

Global Cache blocks served: 957.19 86.31

GCS/GES messages received: 5,893.73 531.42

GCS/GES messages sent: 8,424.00 759.56

DBWR Fusion writes: 2.30 0.21

Estd Interconnect traffic (KB) 27,099.17

	Per Second	Per Transaction
Global Cache blocks received:	2,080.66	187.61
Global Cache blocks served:	957.19	86.31
GCS/GES messages received:	5,893.73	531.42
GCS/GES messages sent:	8,424.00	759.56
DBWR Fusion writes:	2.30	0.21
Estd Interconnect traffic (KB)	27,099.17

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

Buffer access - local cache %: 91.23

Buffer access - remote cache %: 1.04

Buffer access - disk %: 7.73

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

Avg global cache cr block receive time (ms): 0.8

Avg global cache current block receive time (ms): 1.0

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

Avg global cache cr block flush time (ms): 0.7

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

Avg global cache current block flush time (ms): 0.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.3

Avg message sent queue time on ksxp (ms): 0.4

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

% of indirect sent messages: 82.15

% of flow controlled messages: 0.93

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 36468.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	34,280.99	94.00
DB CPU	14,175.33	38.87
parse time elapsed	1,895.91	5.20
hard parse elapsed time	1,488.85	4.08
failed parse elapsed time	75.57	0.21
hard parse (sharing criteria) elapsed time	13.08	0.04
hard parse (bind mismatch) elapsed time	8.49	0.02
sequence load elapsed time	7.06	0.02
repeated bind elapsed time	4.07	0.01
PL/SQL execution elapsed time	1.99	0.01
PL/SQL compilation elapsed time	1.85	0.01
connection management call elapsed time	0.36	0.00
DB time	36,468.05
background elapsed time	1,288.31
background cpu time	1,001.65

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	8,711,187	0.00	17,621	2	217.79
Concurrency	1,757,355	45.74	8,002	5	43.93
Cluster	9,883,916	0.24	5,704	1	247.10
Other	779,436	78.21	438	1	19.49
System I/O	141,360	0.00	116	1	3.53
Application	383,568	0.00	45	0	9.59
Commit	41,405	0.00	24	1	1.04
Network	11,197,482	0.00	22	0	279.94
Configuration	973	98.46	0	0	0.02

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	3,970,591	0.00	12,309	3	99.27
cursor: pin S wait on X	804,153	99.96	7,857	10	20.10
db file scattered read	3,986,390	0.00	3,168	1	99.66
gc buffer busy	1,982,872	0.01	3,137	2	49.57
read by other session	653,143	0.00	1,986	3	16.33
gc cr multi block request	5,937,912	0.00	1,397	0	148.45
gc current block 2-way	955,445	0.00	510	1	23.89
gc cr grant 2-way	886,486	0.00	420	0	22.16
gcs drm freeze in enter server mode	513	66.47	196	382	0.01
gc remaster	289	0.35	160	553	0.01
db file parallel read	92,021	0.00	154	2	2.30
kksfbc child completion	2,208	83.47	90	41	0.06
latch: object queue header operation	82,404	0.00	89	1	2.06
library cache lock	209,273	0.00	87	0	5.23
kst: async disk IO	3,020	0.00	63	21	0.08
SQL*Net break/reset to client	381,802	0.00	44	0	9.55
cr request retry	29	100.00	27	944	0.00
log file sequential read	60,896	0.00	26	0	1.52
log file sync	41,405	0.00	24	1	1.04
latch: cache buffers chains	685,555	0.00	21	0	17.14
gc cr block 2-way	35,225	0.00	21	1	0.88
latch: shared pool	3,105	0.00	21	7	0.08
gc current grant 2-way	38,395	0.00	20	1	0.96
log file parallel write	46,028	0.00	15	0	1.15
gc current grant busy	11,745	0.00	14	1	0.29
row cache lock	49,682	0.00	14	0	1.24
latch free	4,124	0.00	13	3	0.10
LNS wait on SENDREQ	961	0.00	10	10	0.02
gc current block busy	311	0.00	9	29	0.01
kjbdrmcvtq lmon drm quiesce: ping completion	71	76.06	9	121	0.00
reliable message	296	1.35	9	29	0.01
SQL*Net message to client	10,914,336	0.00	7	0	272.87
db file parallel write	14,620	0.00	6	0	0.37
gc object scan	24,658	95.35	5	0	0.62
gc cr disk read	9,166	0.00	4	0	0.23
gc cr grant congested	626	0.00	4	6	0.02
SQL*Net more data to client	243,899	0.00	4	0	6.10
control file sequential read	14,682	0.00	4	0	0.37
CGS wait for IPC msg	570,563	99.88	3	0	14.26
gc current block congested	287	0.00	2	6	0.01
direct path read	1,493	0.00	2	1	0.04
SQL*Net more data from client	38,188	0.00	2	0	0.95
latch: library cache	182	0.00	1	7	0.00
Log archive I/O	286	0.00	1	4	0.01
direct path read temp	3,273	0.00	1	0	0.08
control file parallel write	1,812	0.00	1	1	0.05
ges global resource directory to be frozen	71	98.59	1	10	0.00
enq: TM - contention	1,756	0.00	1	0	0.04
ksxr poll remote instances	84,781	40.49	1	0	2.12
os thread startup	19	0.00	0	25	0.00
direct path write temp	2,959	0.00	0	0	0.07
enq: XR - database force logging	1,201	0.00	0	0	0.03
DFS lock handle	1,072	0.00	0	0	0.03
log file switch completion	11	0.00	0	34	0.00
latch: row cache objects	40	0.00	0	8	0.00
latch: KCL gc element parent latch	1,806	0.00	0	0	0.05
direct path write	1,317	0.00	0	0	0.03
enq: TX - index contention	74	0.00	0	3	0.00
enq: TX - row lock contention	4	0.00	0	46	0.00
gc current grant congested	15	0.00	0	11	0.00
gc cr block busy	134	0.00	0	1	0.00
enq: CF - contention	318	0.00	0	1	0.01
rdbms ipc reply	604	0.00	0	0	0.02
library cache pin	420	0.00	0	0	0.01
IPC send completion sync	216	100.00	0	0	0.01
gc cr block congested	8	0.00	0	11	0.00
gcs log flush sync	238	6.72	0	0	0.01
gc current multi block request	303	0.00	0	0	0.01
KJC: Wait for msg sends to complete	1,331	0.00	0	0	0.03
enq: PS - contention	102	0.00	0	0	0.00
latch: gcs resource hash	18	0.00	0	2	0.00
enq: TT - contention	75	0.00	0	0	0.00
PX Deq: reap credit	2,890	96.54	0	0	0.07
enq: FB - contention	52	0.00	0	0	0.00
gc current block unknown	33	0.00	0	1	0.00
cursor: pin S	24,053	0.00	0	0	0.60
buffer busy waits	135	0.00	0	0	0.00
PX Deq Credit: send blkd	33	18.18	0	0	0.00
enq: WF - contention	11	0.00	0	0	0.00
PX Deq: Signal ACK	39	28.21	0	0	0.00
enq: TD - KTF dump entries	8	0.00	0	1	0.00
cursor: mutex S	4,558	0.00	0	0	0.11
log file single write	16	0.00	0	0	0.00
LGWR wait for redo copy	210	0.00	0	0	0.01
gc cr failure	6	0.00	0	0	0.00
ges2 LMON to wake up LMD - mrcvr	64	0.00	0	0	0.00
enq: WR - contention	4	0.00	0	0	0.00
undo segment extension	958	100.00	0	0	0.02
enq: US - contention	2	0.00	0	1	0.00
enq: TX - contention	4	0.00	0	0	0.00
ges inquiry response	2	0.00	0	1	0.00
enq: MW - contention	2	0.00	0	1	0.00
enq: TX - allocate ITL entry	2	0.00	0	0	0.00
enq: DR - contention	3	0.00	0	0	0.00
wait for scn ack	4	0.00	0	0	0.00
enq: WL - contention	2	0.00	0	0	0.00
enq: SQ - contention	1	0.00	0	1	0.00
enq: HW - contention	1	0.00	0	0	0.00
SQL*Net more data from dblink	4	0.00	0	0	0.00
cursor: mutex X	159	0.00	0	0	0.00
SQL*Net message to dblink	90	0.00	0	0	0.00
SQL*Net more data to dblink	4	0.00	0	0	0.00
SQL*Net break/reset to dblink	6	0.00	0	0	0.00
buffer deadlock	12	100.00	0	0	0.00
SQL*Net message from client	10,914,350	0.00	3,063,852	281	272.87
gcs remote message	7,487,287	80.98	55,439	7	187.19
LNS ASYNC end of log	716,317	100.00	7,001	10	17.91
PX Idle Wait	1,488	93.48	3,520	2365	0.04
Streams AQ: qmn slave idle wait	140	9.29	3,513	25093	0.00
Streams AQ: qmn coordinator idle wait	380	33.95	3,512	9243	0.01
ges remote message	387,069	86.42	3,512	9	9.68
Streams AQ: waiting for messages in the queue	372	100.00	3,508	9431	0.01
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,456	288012	0.00
jobq slave wait	1,163	96.13	3,347	2878	0.03
DIAG idle wait	17,133	0.00	3,345	195	0.43
SQL*Net message from dblink	88	0.00	1,617	18372	0.00
PX Deq: Execution Msg	485	29.48	2	4	0.01
PX Deq: Parse Reply	45	37.78	0	2	0.00
single-task message	4	0.00	0	13	0.00
PX Deq: Join ACK	44	38.64	0	1	0.00
PX Deq: Execute Reply	41	36.59	0	1	0.00
PX Deq: Msg Fragment	129	55.81	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	410	100.00	0	0	0.01
class slave wait	4	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
events in waitclass Other	715,602	84.49	109	0	17.89
kst: async disk IO	3,020	0.00	63	21	0.08
log file sequential read	60,908	0.00	27	0	1.52
log file parallel write	46,036	0.00	15	0	1.15
LNS wait on SENDREQ	961	0.00	10	10	0.02
db file parallel write	14,621	0.00	6	0	0.37
gc object scan	24,658	95.35	5	0	0.62
control file sequential read	13,452	0.00	3	0	0.34
db file sequential read	691	0.00	3	4	0.02
Log archive I/O	286	0.00	1	4	0.01
gc cr multi block request	3,142	0.00	1	0	0.08
control file parallel write	1,812	0.00	1	1	0.05
row cache lock	2,179	0.00	1	0	0.05
enq: TM - contention	1,654	0.00	1	0	0.04
os thread startup	19	0.00	0	25	0.00
gc current block 2-way	772	0.00	0	1	0.02
library cache lock	917	0.00	0	0	0.02
latch: cache buffers chains	228	0.00	0	1	0.01
gc cr block 2-way	82	0.00	0	1	0.00
gc current grant 2-way	138	0.00	0	0	0.00
gc cr grant 2-way	122	0.00	0	0	0.00
log file switch completion	1	0.00	0	37	0.00
direct path read	242	0.00	0	0	0.01
library cache pin	105	0.00	0	0	0.00
latch: shared pool	4	0.00	0	3	0.00
db file scattered read	1	0.00	0	6	0.00
gc current grant busy	8	0.00	0	1	0.00
log file single write	16	0.00	0	0	0.00
gc cr block busy	1	0.00	0	1	0.00
direct path write	110	0.00	0	0	0.00
log file sync	2	0.00	0	0	0.00
buffer busy waits	4	0.00	0	0	0.00
SQL*Net more data from dblink	2	0.00	0	0	0.00
SQL*Net more data to dblink	2	0.00	0	0	0.00
SQL*Net message to dblink	16	0.00	0	0	0.00
rdbms ipc message	241,311	28.10	83,835	347	6.03
gcs remote message	7,487,622	80.98	55,441	7	187.20
LNS ASYNC end of log	716,338	100.00	7,001	10	17.91
pmon timer	1,311	97.03	3,518	2683	0.03
Streams AQ: qmn slave idle wait	140	9.29	3,513	25093	0.00
Streams AQ: qmn coordinator idle wait	380	33.95	3,512	9243	0.01
ges remote message	387,196	86.42	3,512	9	9.68
smon timer	28	42.86	3,471	123979	0.00
Streams AQ: waiting for time management or cleanup tasks	12	100.00	3,456	288012	0.00
DIAG idle wait	17,134	0.00	3,346	195	0.43
PX Deq: Parse Reply	30	40.00	0	1	0.00
single-task message	2	0.00	0	14	0.00
SQL*Net message from dblink	16	0.00	0	1	0.00
PX Deq: Join ACK	29	41.38	0	1	0.00
PX Deq: Execute Reply	28	35.71	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	410	100.00	0	0	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	32,478
AVG_IDLE_TIME	328,553
AVG_IOWAIT_TIME	21,667
AVG_SYS_TIME	3,805
AVG_USER_TIME	28,561
BUSY_TIME	2,085,967
IDLE_TIME	21,034,532
IOWAIT_TIME	1,394,561
SYS_TIME	250,780
USER_TIME	1,835,187
LOAD	0
OS_CPU_WAIT_TIME	1,898,400
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	66,035,122,176
NUM_CPUS	64
NUM_CPU_CORES	32

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
busdb	22,059.50	8,512.10	19,125,014	497,192,188
SYS$USERS	14,321.80	5,634.70	36,660,243	222,494,826
SYS$BACKGROUND	0.00	0.00	1,352	127,000

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
busdb	4913418	1098275	1208249	794136	7140216	668
SYS$USERS	3795530	663185	544685	5591	4055407	517
SYS$BACKGROUND	1608	425	3995	192	981	994

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Text
4,151	161	199	20.86	11.38	2nh8vygjwqty9	call sff_payrefrec.Querydatafo...
1,906	63	5	381.20	5.23	7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType...
1,017	224	39	26.09	2.79	a17rkh5dsxwb7	select check_card(:1...
927	29	1	926.80	2.54	dv2jvxn1p6vpb	SELECT COUNT(*) FROM PrpTcarsh...
804	461	586,018	0.00	2.20	cwftufrd5xsxh	select prpjpayrefrec.certino f...
739	24	2	369.32	2.03	6bd9t0vtfy58m	select * from prpjpayrefrec wh...
667	21	1	666.89	1.83	a3nw9r52pkvxz	SELECT COUNT(*) FROM PrpTcarsh...
621	23	5	124.18	1.70	bt6b5hrjzm7sy	SELECT PrpJpayRefRec.certiType...
618	55	16	38.62	1.69	0xj1u01p9jh71	select C_INSRNT_AGE from t_ca...
567	20	2	283.49	1.55	97uq9r9t4rcqp	select * from prpjpayrefrec wh...
541	26	4	135.27	1.48	63yq0tt748m85	SELECT PrpJpayRefRec.certiType...
532	15	1	532.14	1.46	d8ab9abx8ba05	select * from prpjpayrefrec wh...
427	19	9	47.42	1.17	5wmg5w5xp3a66	select * from prpjpayrefrec wh...
366	12	2	183.16	1.00	bwwdby9gj0y48	select * from prpjpayrefrec wh...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Text
461	804	586,018	0.00	2.20	cwftufrd5xsxh	select prpjpayrefrec.certino f...
224	1,017	39	5.76	2.79	a17rkh5dsxwb7	select check_card(:1...
173	234	1	173.01	0.64	7fc94h80x0qfv	SELECT COUNT(*) FROM PrpTmain ...
161	4,151	199	0.81	11.38	2nh8vygjwqty9	call sff_payrefrec.Querydatafo...
151	161	2,055	0.07	0.44	f1g45cc2jzh1h	select evalinsure0_.ID as ID, ...
124	167	2	62.19	0.46	79jsxvmbq6ghn	select rowid, ClaimNo, LFlag...
63	1,906	5	12.57	5.23	7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType...
58	95	1	58.38	0.26	2drgycsfvvhwx	SELECT ReqRespNo, SerialNo, RT...
58	95	12	4.82	0.26	aawvjh7qqaxav	select agentcode, riskcode, cu...
55	618	16	3.41	1.69	0xj1u01p9jh71	select C_INSRNT_AGE from t_ca...
29	927	1	29.41	2.54	dv2jvxn1p6vpb	SELECT COUNT(*) FROM PrpTcarsh...
26	541	4	6.41	1.48	63yq0tt748m85	SELECT PrpJpayRefRec.certiType...
24	739	2	11.92	2.03	6bd9t0vtfy58m	select * from prpjpayrefrec wh...
23	621	5	4.69	1.70	bt6b5hrjzm7sy	SELECT PrpJpayRefRec.certiType...
21	667	1	21.49	1.83	a3nw9r52pkvxz	SELECT COUNT(*) FROM PrpTcarsh...
20	567	2	9.80	1.55	97uq9r9t4rcqp	select * from prpjpayrefrec wh...
19	427	9	2.08	1.17	5wmg5w5xp3a66	select * from prpjpayrefrec wh...
15	532	1	14.56	1.46	d8ab9abx8ba05	select * from prpjpayrefrec wh...
12	366	2	5.97	1.00	bwwdby9gj0y48	select * from prpjpayrefrec wh...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 721,063,085
Captured SQL account for 25.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
68,855,385	586,018	117.50	9.55	461.03	803.94	cwftufrd5xsxh	select prpjpayrefrec.certino f...
36,517,918	2	18,258,959.00	5.06	124.38	167.04	79jsxvmbq6ghn	select rowid, ClaimNo, LFlag...
19,286,780	1	19,286,780.00	2.67	173.01	233.78	7fc94h80x0qfv	SELECT COUNT(*) FROM PrpTmain ...
11,540,445	2,055	5,615.79	1.60	150.61	160.72	f1g45cc2jzh1h	select evalinsure0_.ID as ID, ...
5,214,059	39	133,693.82	0.72	224.47	1017.40	a17rkh5dsxwb7	select check_card(:1...
4,065,121	721	5,638.17	0.56	53.60	57.35	30qqj8f05b8c9	select evalinsure0_.ID as ID, ...
3,776,185	358	10,548.00	0.52	23.43	25.77	3t2h6pb90mgsr	SELECT char_cont FROM Eval_Con...
3,085,464	199	15,504.84	0.43	160.57	4151.47	2nh8vygjwqty9	call sff_payrefrec.Querydatafo...
2,999,491	5	599,898.20	0.42	62.83	1906.00	7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType...
2,438,582	5	487,716.40	0.34	23.43	620.88	bt6b5hrjzm7sy	SELECT PrpJpayRefRec.certiType...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 55,825,738
Captured SQL account for 11.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
828,167	199	4,161.64	1.48	160.57	4151.47	2nh8vygjwqty9	call sff_payrefrec.Querydatafo...
801,021	1	801,021.00	1.43	58.38	94.66	2drgycsfvvhwx	SELECT ReqRespNo, SerialNo, RT...
717,391	39	18,394.64	1.29	224.47	1017.40	a17rkh5dsxwb7	select check_card(:1...
650,327	12	54,193.92	1.16	57.88	94.87	aawvjh7qqaxav	select agentcode, riskcode, cu...
570,612	1	570,612.00	1.02	173.01	233.78	7fc94h80x0qfv	SELECT COUNT(*) FROM PrpTmain ...
464,749	1	464,749.00	0.83	30.25	76.17	1p6c8x0pamrsm	select comCode as comCode, vis...
277,731	12	23,144.25	0.50	41.78	59.00	dzdgfnjb0sfg0	select agentcode, riskcode, cu...
211,619	16	13,226.19	0.38	54.60	617.85	0xj1u01p9jh71	select C_INSRNT_AGE from t_ca...
182,239	5	36,447.80	0.33	62.83	1906.00	7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType...
181,099	2	90,549.50	0.32	124.38	167.04	79jsxvmbq6ghn	select rowid, ClaimNo, LFlag...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 7,443,145
Captured SQL account for 62.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Text
2,917,946	2,917,403	1.00	bunvx480ynf57	SELECT 1 FROM DUAL
586,018	10,392	0.02	cwftufrd5xsxh	select prpjpayrefrec.certino f...
284,353	284,280	1.00	1gxycd9mf6qsu	Select * From PrpDrisk Where R...
277,914	67,522	0.24	7nkswk2x5nnrc	Select * From PrpUserGrade Whe...
118,634	118,634	1.00	ftj9uawt4wwzb	select condition from cdef$ wh...
84,674	84,632	1.00	8qtnwfznp4xn7	Select * From PrpDuser Where U...
70,093	69,001	0.98	3ysvgb0mpgqss	select rowid, configCode, ou...
40,630	40,630	1.00	5dv357yng47gw	Select * From PrpDcompany Wher...
30,709	13,507	0.44	8f696gckfqbqp	select rowid, BusinessNo, Pol...
22,835	22,835	1.00	2ym6hhaq30r73	select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,621,131
Captured SQL account for 12.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
118,633	118,634	4.53	ftj9uawt4wwzb	select condition from cdef$ wh...
22,835	22,835	0.87	2ym6hhaq30r73	select type#, blocks, extents,...
22,413	22,412	0.86	8qk5crj296shj	select rowid, configCode, out...
17,356	17,356	0.66	3s38a2wuku1rr	Select * from PrpDcode Where c...
10,062	10,062	0.38	4m7m0t6fjcs5x	update seq$ set increment$=:2,...
8,673	8,675	0.33	gmc40aqq66k5k	SELECT logid.NEXTVAL FROM DUAL
8,451	8,451	0.32	896y3kr66cfdm	SET TRANSACTION READ ONLY
8,451	8,449	0.32	d4ggk0agny9tf	SET TRANSACTION READ WRITE
6,722	15,813	0.26	7960383qkahvm	select rowid, PolicyNo, Risk...
6,553	15,813	0.25	a0suvbq9zruyy	select rowid, PolicyNo, RiskC...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,440,711	1	0.03	8f1sjvfxuup9w	PL/SQL Developer	select t., o., m.comments ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
568	26	0vxqqttq7yzz5		INSERT INTO PrpLcheck (RegistN...
111	6	4dv2q7v3adc1d		INSERT INTO PrpLcertifyCollect...
80	1	fnj6cnubp1sau	PL/SQL Developer	begin if :enable = 0 then ...
78	3,851	045mhpa5150sp		Update PrpCmain Set PolicyNo =...
77	6	atvxrt64vtnmy		Update PrpJpayRefRec Set Certi...
49	34	0xwby571mq3n2		select name, password, datats#...
48	4	g73tzgnm4722f		select u.name, o.name, trigg...
44	14	2696phr1u823r		INSERT INTO PrpLloss (Compensa...
36	268	asvzxj61dc5vs		select timestamp, flags from ...
33	82	8hd36umbhpgsz		select parttype, partcnt, pa...
30	120	0k8522rmdzg4k		select privilege# from sysauth...
26	3	5ur69atw3vfhj		select decode(failover_method,...
25	3	0kugqg48477gf		select distinct(-privilege#), ...
23	7	dccm4dw93qy3b	plsqldev.exe	begin sys.dbms_application_inf...
21	227	b1wc53ddd6h3p		select audit$, options from pr...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Text
734.04	72.15	1,017.40	224.47	39	a17rkh5dsxwb7	select check_card(:1...
595.74	31.26	1,906.00	62.83	5	7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType...
490.38	79.37	617.85	54.60	16	0xj1u01p9jh71	select C_INSRNT_AGE from t_ca...
315.25	7.59	4,151.47	160.57	199	2nh8vygjwqty9	call sff_payrefrec.Querydatafo...
236.78	38.14	620.88	23.43	5	bt6b5hrjzm7sy	SELECT PrpJpayRefRec.certiType...
222.27	23.98	926.80	29.41	1	dv2jvxn1p6vpb	SELECT COUNT(*) FROM PrpTcarsh...
178.98	26.84	666.89	21.49	1	a3nw9r52pkvxz	SELECT COUNT(*) FROM PrpTcarsh...
172.88	31.95	541.08	25.63	4	63yq0tt748m85	SELECT PrpJpayRefRec.certiType...
149.14	18.55	803.94	461.03	586,018	cwftufrd5xsxh	select prpjpayrefrec.certino f...
142.59	33.41	426.74	18.68	9	5wmg5w5xp3a66	select * from prpjpayrefrec wh...
86.05	75.69	113.69	19.18	9	9azd05uun8amq	Select count(flowid) from SwfL...
78.33	67.78	115.56	39.38	13	g294gwr2d5ppj	Select count(flowid) from SwfL...
60.34	70.30	85.83	41.67	4	fu6r9gf3j4ghg	select C_INSRNT_AGE from t_ca...
55.75	28.55	195.30	10.00	3	gjbmwtccqpdxa	select * from prpjpayrefrec wh...
49.49	28.36	174.50	7.04	2	cg6nmxtcbgbnz	select * from prpjpayrefrec wh...
36.15	56.27	64.25	23.91	6	aku1v1xchwy96	Select count(flowid) from SwfL...
34.25	59.11	57.94	20.12	13	9cjjs2nh3cysp	Select * from (SELECT T.*, Ro...
31.56	13.43	234.94	11.51	3	2h699fygt52rg	SELECT COUNT(*) FROM PrpJpayRe...
29.09	30.07	96.73	3.01	3	4j70gn3a9azyb	SELECT VisaCode, VisaName, vis...
28.43	17.02	167.04	124.38	2	79jsxvmbq6ghn	select rowid, ClaimNo, LFlag...
21.61	5.90	366.31	11.93	2	bwwdby9gj0y48	select * from prpjpayrefrec wh...
20.86	2.82	738.64	23.84	2	6bd9t0vtfy58m	select * from prpjpayrefrec wh...
20.58	48.89	42.09	18.70	6	80zjzwpqa43qc	Select count(flowid) from SwfL...
17.26	22.67	76.17	30.25	1	1p6c8x0pamrsm	select comCode as comCode, vis...
7.99	1.41	566.97	19.61	2	97uq9r9t4rcqp	select * from prpjpayrefrec wh...
5.65	4.92	114.93	11.07	60	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
5.08	4.73	107.50	8.42	1	abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_...
5.07	4.74	107.15	8.32	1	89qyn4bbt03jq	SELECT /+ USE_HASH(f a) / SU...
4.45	0.84	532.14	14.56	1	d8ab9abx8ba05	select * from prpjpayrefrec wh...
3.30	1.10	299.33	10.38	2	8vqqrqngfu263	select * from prpjpayrefrec wh...
3.21	1.89	170.35	11.05	1	dzmaaxssv3adq	select * from prpjpayrefrec wh...
2.05	7.90	26.00	11.81	30,709	8f696gckfqbqp	select rowid, BusinessNo, Pol...
0.74	8.27	8.98	4.93	18,370	7c9b2tyakczhy	select rowid, RegistNo, lFla...
0.69	3.76	18.25	5.73	15,813	7960383qkahvm	select rowid, PolicyNo, Risk...
0.67	3.74	17.78	12.46	277,914	7nkswk2x5nnrc	Select * From PrpUserGrade Whe...
0.57	12.65	4.52	4.46	84,674	8qtnwfznp4xn7	Select * From PrpDuser Where U...
0.54	16.85	3.23	3.00	10,062	4m7m0t6fjcs5x	update seq$ set increment$=:2,...
0.54	0.45	120.09	6.26	1	cd6339bwu4p23	select * from prpjpayrefrec wh...
0.49	7.56	6.44	3.13	10,851	0967wz9v2dxu4	select rowid, CertiNo, CertiT...
0.47	6.89	6.77	2.49	9,656	d8c7ajzwp0zzd	select rowid, ScheduleID, Re...
0.41	11.56	3.55	2.57	3,851	045mhpa5150sp	Update PrpCmain Set PolicyNo =...
0.34	3.08	11.01	2.88	4,338	23pnnkv6fav1g	SELECT * FROM CIInsureDemand W...
0.33	5.16	6.45	5.80	8,675	gmc40aqq66k5k	SELECT logid.NEXTVAL FROM DUAL
0.24	0.15	160.72	150.61	2,055	f1g45cc2jzh1h	select evalinsure0_.ID as ID, ...
0.23	11.76	1.92	1.16	5,898	3s34rwupy93ts	Select * From PrpTmain Where P...
0.21	70.69	0.30	0.30	492	axmdf8vq7k1rh	select increment$, minvalue, m...
0.21	13.67	1.52	1.49	22,835	2ym6hhaq30r73	select type#, blocks, extents,...
0.19	0.18	105.93	8.41	1	cyvv4wv5drpnk	SELECT COUNT(*) FROM PrpTcarsh...
0.17	11.28	1.52	1.48	11,885	gvyuhpu95pd1p	SELECT * FROM PrpCmain WHERE P...
0.11	0.44	25.77	23.43	358	3t2h6pb90mgsr	SELECT char_cont FROM Eval_Con...
0.11	0.19	57.35	53.60	721	30qqj8f05b8c9	select evalinsure0_.ID as ID, ...
0.08	0.28	29.73	28.82	175	96vpq7w65y759	select evaluserin0_.ID as ID, ...
0.08	0.03	233.78	173.01	1	7fc94h80x0qfv	SELECT COUNT(*) FROM PrpTmain ...
0.06	5.52	1.02	0.09	77	3qbktmazwqxwc	Insert Into PrpLdangerItem ( C...
0.05	2.86	1.90	1.76	3,227	7ng34ruy5awxq	select i.obj#, i.ts#, i.file#,...
0.04	48.22	0.09	0.05	41	1c98q25nhftbz	Insert Into PrpLRegistRPolicy ...
0.04	0.04	94.87	57.88	12	aawvjh7qqaxav	select agentcode, riskcode, cu...
0.03	36.70	0.09	0.07	67	9j7sh88h1yct9	INSERT INTO PrpLext (CertiNo, ...
0.03	9.17	0.33	0.31	1,716	1gu8t96d0bdmu	select t.ts#, t.file#, t.block...
0.03	8.42	0.35	0.09	26	0vxqqttq7yzz5	INSERT INTO PrpLcheck (RegistN...
0.03	0.12	22.31	19.96	12	6g29pc6n8k36n	SELECT * FROM PrpCmain WHERE 1...
0.02	0.04	59.00	41.78	12	dzdgfnjb0sfg0	select agentcode, riskcode, cu...
0.02	4.69	0.51	0.44	8,101	62xnx3wv7hq2d	select rowid, CertiNo, CertiT...
0.02	8.32	0.22	0.12	35	23u3gum7h1gjd	Insert Into PrpLqualityCheck (...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

045mhpa5150sp Update PrpCmain Set PolicyNo = :1, ClassCode = :2, RiskCode =:3, ProposalNo = :4, ContractNo =:5, PolicySort = :6, PrintNo =:7, BusinessNature = :8, Language = :9, PolicyType = :10, AppliCode = :11, AppliName = :12, AppliAddress =:13, InsuredCode = :14, InsuredName = :15, InsuredAddress = :16, OperateDate = :17, StartDate = :18, StartHour = :19, EndDate = :20, EndHour = :21, PureRate = :22, DisRate = :23, Discount = :24, Currency = :25, SumValue = :26, SumAmount =:27, SumDiscount = :28, SumPremium = :29, SumSubPrem = :30, SumQuantity = :31, JudicalScope = :32, AutoTransRenewFlag = :33, ArgueSolution = :34, ArbitBoardName = :35, PayTimes = :36, EndorseTimes =:37, ClaimTimes = :38, MakeCom = :39, OperateSite = :40, ComCode = :41, HandlerCode = :42, Handler1Code = :43, ApproverCode = :44, UnderWriteCode =:45, UnderWriteName = :46, OperatorCode = :47, InputDate = :48, InputHour = :49, UnderWriteEndDate = :50, StatisticsYM = :51, AgentCode = :52, CoinsFlag = :53, ReinsFlag = :54, AllinsFlag = :55, UnderWriteFlag = :56, OthFlag = :57, Flag = :58, DisRate1 = :59, BusinessFlag = :60, PayMode = :61, UpdaterCode =:62, UpdateDate = :63, UpdateHour = :64, SignDate = :65, ShareHolderFlag = :66, SpecialChannel = :67, AgreementNo = :68, Remark = :69, InquiryNo = :70, PayDate = :71, PNPDate = :72, PrintDate = :73, AgricultureFlag = :74, BizTypeFlag = :75, AgricultureAmount = :76, EffectFlag = :77, EffectTime = :78, stopTimes = :79, CardKey = :80, salescode = :81, useNature = :82, ComputerIP = :83, BusinessChannel = :84, inputSysCode = :85 Where PolicyNo =:86

0967wz9v2dxu4 select rowid, CertiNo, CertiType, PersonDeathB, PersonDeathD1, PersonInjureB, PersonInjureD1, Carrier, SailStartDate, UnloadDate, AppliCheckDate, AppliPhone, InsuredPhone, CargoLossCheckCom, CargoLossType, ShareClaimer, Salvor, GuaranteeFlag, Currency, CargoValue, SalvaGuarantAmount, RestQuantity, Guarantor, Value1, Value2, Value3, Remark, Flag FROM PrpLext WHERE CertiNo = :1 And CertiType = :2

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0kugqg48477gf select distinct(-privilege#), nvl(option$, 0) from sysauth$ where grantee#=:1 and privilege#<0

0vxqqttq7yzz5 INSERT INTO PrpLcheck (RegistNo, ClaimNo, RiskCode, PolicyNo, CheckType, CheckNature, CheckDate, CheckSite, FirstSiteFlag, ClaimType, DamageCode, DamageName, DamageTypeCode, DamageTypeName, ReferKind, DamageAreaCode, DamageAddressType, IndemnityDuty, ClaimFlag, Checker1, Checker2, CheckUnitName, HandleUnit, Remark, Flag, ReferSerialNo, InsureCarFlag, RepeatInsureFlag, HandleUnitCode, UnitType, EstimateFee, EstimateLoss, DamageStartDate, DamageStartHour, DamageAddress, CheckLinker, EntrustFlag, InjuryFlag, BrigandageFlag, RoadFlag, AcciLetterFlag, AcciLetterNo, ThirdVehicleFlag, AccidentCode, AccidentName, CheckCode1, CheckCode2, ManageTypeCode, ManageTypeName, SubCertiType, SubCertiTypeName, paySelfFlag, subClaimFlag, DamageAddressCode) 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)

0xj1u01p9jh71 select C_INSRNT_AGE from t_card_base where c_card_no=10060005000215784353

0xwby571mq3n2 select name, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1 from user$ where user#=:1

1c98q25nhftbz Insert Into PrpLRegistRPolicy ( RegistNo, PolicyNo, ClaimNo, PolicyType, FlowId, Remark, ValidStatus, Flag, RiskCode, RegistFlag, RegistCancelDate, ComCode) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)

1gu8t96d0bdmu select 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# (+)

1gxycd9mf6qsu Select * From PrpDrisk Where RiskCode = :1

1p6c8x0pamrsm select comCode as comCode, visaCode as VisaCode, visaName as visaName, sum(earlyNoReturn) as earlyNoReturn, sum(inBetweenQuantity) as inBetweenQuantity, sum(outBetweenQuantity) as outBetweenQuantity, sum(returnBetweenQuantity) as returnBetweenQuantity, (sum(earlyNoReturn)+sum(inBetweenQuantity)-sum(outBetweenQuantity)-sum(returnBetweenQuantity)) as laterNoReturn from( (select comcode as comCode, visacode as visaCode, visaname as visaName, (sum(inQuantity)-sum(outQuantity)-sum(returnedQuantity)) as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from ( select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(StorageQuantity) as inQuantity, 0 as outQuantity, 0 as returnedQuantity from vsstorage where comcode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') and CheckerCode is not null group by comcode, visacode, visaname) union all select * from (select Acceptercomcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(Quantity) as inQuantity, 0 as outQuantity, 0 as returnedQuantity from vsprovide where acceptercomcode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by acceptercomcode, visacode, visaname) union all select * from (select confirmcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(Quantity) as inQuantity, 0 as outQ uantity, 0 as returnedQuantity from vsrecycle where confirmcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by confirmcode, visacode, visaname) union all select * from (select providercode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, sum(Quantity) as outQuantity, 0 as returnedQuantity from vsprovide where providercode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by providercode, visacode, visaname) union all select * from (select submitcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, sum(Quantity) as outQuantity, 0 as returnedQuantity from vsrecycle where submitcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by submitcode, visacode, visaname) union all select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, 0 as outQuantity, count(*) as returnedQuantity from vsmark where comcode in ('2370521000') and 1=1 and UseDate <= to_date('2012-1-1', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) union all select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, 0 as outQuantity, count(*) as returnedQuantity from vsmarkhis where comcode in ('2370521000') and 1=1 and UseDate <= to_date('2012-1-1', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname)) group by comcode, visacode, visaname) union all select * from (select ComCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(StorageQuantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from VsStorage where comcode in ('2370521000') and 1=1 and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and CheckerCode is not null group by comcode, visacode, visaname) union all select * from (select confirmCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(Quantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from Vsrecycle where confirmcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by confirmcode, visacode, visaname) union all select * from (select acceptercomcode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(Quantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from Vsprovide where acceptercomcode in ('2370521000') and 1=1 and InputDate Between to_dat e('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by acceptercomcode, visacode, visaname) union all select * from (select ProviderCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, sum(Quantity) as outBetweenQuantity, 0 as returnBetweenQuantity from vsProvide where providercode in ('2370521000') and 1=1 and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by providercode, visacode, visaname) union all select * from (select submitCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, sum(Quantity) as outBetweenQuantity, 0 as returnBetweenQuantity from vsrecycle where submitcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by submitcode, visacode, visaname) union all select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, count(*) as returnBetweenQuantity from vsmark where comcode in ('2370521000') and 1=1 and UseDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) union all select * from (select comcode as comCode, v isacode as visaCode, visaname as visaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, count(*) as returnBetweenQuantity from vsMarkHis where comcode in ('2370521000') and 1=1 and UseDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) )group by comCode, visaCode, visaName order by comCode, visaCode, visaName

23pnnkv6fav1g SELECT * FROM CIInsureDemand WHERE proposalNo = :1

23u3gum7h1gjd Insert Into PrpLqualityCheck ( RegistNo, QualityCheckType, SerialNo, TypeCode, TypeName, CheckResult, CheckRemark, Flag) values(:1, :2, :3, :4, :5, :6, :7, :8)

2696phr1u823r INSERT INTO PrpLloss (CompensateNo, RiskCode, PolicyNo, SerialNo, ItemKindNo, FamilyNo, FamilyName, KindCode, LicenseNo, ItemCode, LossName, ItemAddress, FeeTypeCode, FeeTypeName, LossQuantity, Unit, UnitPrice, BuyDate, DepreRate, Currency, Amount, Currency1, ItemValue, Currency2, SumLoss, SumRest, IndemnityDutyRate, ClaimRate, Currency3, DeductibleRate, Deductible, Currency4, SumRealPay, Flag, RejectReason, DutyDeductibleRate, DriverDeductibleRate, Remark, ArrangeRate, SumDefPay, NoDutyDeductAmount, damageDate, endcasedate, lossquantity1, typecode, damageReasonCode) 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)

2drgycsfvvhwx SELECT ReqRespNo, SerialNo, RType, RTime, RXml FROM (Select RowNum As LineNum, T.* From (Select * From prpebaoxml Where 1=1) T) Where linenum > 1440000 and LineNum <= 1445000

2h699fygt52rg SELECT COUNT(*) FROM PrpJpayRefExp WHERE planfee<0 and exists (select 1 from prpjpayrefrec b where b.certitype = 'E' and prpjpayrefexp.certino = b.certino and prpjpayrefexp.serialno = b.serialno and prpjpayrefexp.payreftimes = b.payreftimes and b.payrefno > '0' And (Case When b.validdate>b.underwritedate Then b.validdate Else b.underwritedate End) >=Date'2012-1-1' ) and payrefno='0' and ( 1=0 or comCode = '2508900000' or comCode = '2500381502' or comCode = '2500381580' or comCode = '2500381601' or comCode = '2500381602' or comCode = '2500382580' or comCode = '2500382601' or comCode = '2500000601' or comCode = '2500000602' or comCode = '2500000603' or comCode = '2500000604' or comCode = '2500000605' or comCode = '2500000606' or comCode = '2500000607' or comCode = '2500000608' or comCode = '2500000609' or comCode = '2500381000' or comCode = '2500382000' or comCode = '2508900128' or comCode = '2508900502' or comCode = '2508900601' or comCode = '2508900602' or comCode = '2508900603' or comCode = '2508900604' or comCode = '2508900605' or comCode = '2508900606' or comCode = '2508900607' or comCode = '2508900608' or comCode = '2508900609' or comCode = '2508900610' or comCode = '2508900611' or comCode = '2508900612' or comCode = '2508900613' or comCode = '2508900701' or comCode = '2508900702' or comCode = '2508983000' or comCode = '2508983502' or comCode = '2508983701')and feeType='3 ' and ((CoinsFlag='1' and CoinsType='1') or (CoinsFlag='2' and CoinsType='1') or (CoinsFlag='0')) and not exists (select 1 from (select certino, serialno, sum(planfee) from prpjpayrefexp where ( 1=0 or comCode = '2508900000' or comCode = '2500381502' or comCode = '2500381580' or comCode = '2500381601' or comCode = '2500381602' or comCode = '2500382580' or comCode = '2500382601' or comCode = '2500000601' or comCode = '2500000602' or comCode = '2500000603' or comCode = '2500000604' or comCode = '2500000605' or comCode = '2500000606' or comCode = '2500000607' or comCode = '2500000608' or comCode = '2500000609' or comCode = '2500381000' or comCode = '2500382000' or comCode = '2508900128' or comCode = '2508900502' or comCode = '2508900601' or comCode = '2508900602' or comCode = '2508900603' or comCode = '2508900604' or comCode = '2508900605' or comCode = '2508900606' or comCode = '2508900607' or comCode = '2508900608' or comCode = '2508900609' or comCode = '2508900610' or comCode = '2508900611' or comCode = '2508900612' or comCode = '2508900613' or comCode = '2508900701' or comCode = '2508900702' or comCode = '2508983000' or comCode = '2508983502' or comCode = '2508983701') and feeType='3' group by certino, serialno having sum(planfee)=0 )p Where prpjpayrefexp.certino = p.certino and prpjpayrefexp.serialno = p.serialno )

2nh8vygjwqty9 call sff_payrefrec.Querydataforconfirm(:1, :2, :3, :4, :5)

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

30qqj8f05b8c9 select evalinsure0_.ID as ID, evalinsure0_.EVAL_INFO_ID as EVAL_INF2_, evalinsure0_.INSURE_TERM as INSURE_T3_, evalinsure0_.INSURE_TERM_CODE as INSURE_T4_, evalinsure0_.DESCRIPTION as DESCRIPT5_, evalinsure0_.DEL_FLAG as DEL_FLAG, evalinsure0_.CREATED_BY as CREATED_BY, evalinsure0_.CREATED_DATE as CREATED_8_, evalinsure0_.UPDATED_BY as UPDATED_BY, evalinsure0_.UPDATED_DATE as UPDATED10_, evalinsure0_.REMARK as REMARK from EVAL_INSURE_TERM evalinsure0_ where (evalinsure0_.EVAL_INFO_ID=:1 )

3qbktmazwqxwc Insert Into PrpLdangerItem ( CertiNo, RiskCode, DangerNo, SerialNo, KindFlag, KindCode, KindName, PostCode, AddressName, Currency, SumPaid, SumFee, RegistNo, Flag) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)

3s34rwupy93ts Select * From PrpTmain Where ProposalNo = :1

3s38a2wuku1rr Select * from PrpDcode Where codetype='ClaimStatus' AND codecode='4'

3t2h6pb90mgsr SELECT char_cont FROM Eval_Content where char_cont_id=:1 order by char_order

3ysvgb0mpgqss select rowid, configCode, outerCode, innerCode, codeType, validStatus, riskType FROM UtiCodeTransfer WHERE outercode=:1

4dv2q7v3adc1d INSERT INTO PrpLcertifyCollect (BusinessNo, LossItemCode, LossItemName, PicCount, StartDate, StartHour, EndDate, EndHour, OperatorCode, CollectFlag, CltInsureCarFlag, CltThirdCarFlag, CltPersonFlag, CltPropFlag, CltCarLossFlag, CltAllLossFlag, CaseFlag, Content, Flag, PolicyNo, RiskCode, UploadYear, PAYSELFFLAG, SubCertiType, SubCertiTypeName, subClaimFlag, CompelFlag ) 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)

4j70gn3a9azyb SELECT VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName, PayRefFee FROM ( SELECT a.VisaCode, a.VisaName, a.visaserialno, a.Currency2, a.PrintDate, a.PrinterCode, a.VisaHandler, a.PayRefName, a.PayRefFee FROM ( SELECT VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName, sum(PayRefFee) as PayRefFee FROM PrpJpayRefRec WHERE CertiType IN ('P', 'E', 'T') AND VisaSerialNo IS NOT NULL and PrpJPayRefRec.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPayRefRec.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjpayrefrec.ComCode like '23310%' OR ( prpjpayrefrec.handlercode='233100005' OR prpjpayrefrec.operatorcode='233100005' OR prpjpayrefrec.handler1code='233100005') OR 1=0 ) and PrpJPayRefRec.PrintDate is not null Group By VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName )a where not exists ( select 1 from (SELECT PrpJPrintInvoice.VisaCode as VisaCode, PrpJPrintInvoice.VisaName as VisaName, PrpJPrintInvoice.visaserialno as visaSerialNo, PrpJPrintInvoice.Currency1 as currency2, PrpJPrintInvoice.PrintDate as PrintDate, PrpJPrintInvoice.PrinterCode as PrinterCode, Prpjpayrefrec.VisaHandler as VisaHandler, Prpjpayrefrec.PayRefName as PayRefName, PrpJPrintInvoice.PrintRefFee as payRefFee FROM PrpJPrintInvoice, Prpjpayrefrec WHERE PrpJPrintInvoice.certino=Prpjpayrefrec.certino and PrpJPrintInvoice.certitype=Prpjpayrefrec.cert itype and PrpJPrintInvoice.CertiType IN ('P', 'E', 'T') AND PrpJPrintInvoice.VisaSerialNo IS NOT NULL and PrpJPrintInvoice.printercode='233100005' and PrpJPrintInvoice.comCode ='2331000502' and PrpJPrintInvoice.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPrintInvoice.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjprintinvoice.ComCode like '23310%' OR 1=0 OR 1=0 ))b where a.visaserialno=b.visaserialno ) union all SELECT PrpJPrintInvoice.VisaCode as VisaCode, PrpJPrintInvoice.VisaName as VisaName, PrpJPrintInvoice.visaserialno as visaSerialNo, PrpJPrintInvoice.Currency1 as currency2, PrpJPrintInvoice.PrintDate as PrintDate, PrpJPrintInvoice.PrinterCode as PrinterCode, Prpjpayrefrec.VisaHandler as VisaHandler, Prpjpayrefrec.PayRefName as PayRefName, PrpJPrintInvoice.PrintRefFee as payRefFee FROM PrpJPrintInvoice, Prpjpayrefrec WHERE PrpJPrintInvoice.certino=Prpjpayrefrec.certino and PrpJPrintInvoice.certitype=Prpjpayrefrec.certitype and PrpJPrintInvoice.CertiType IN ('P', 'E', 'T') AND PrpJPrintInvoice.VisaSerialNo IS NOT NULL and PrpJPrintInvoice.printercode='233100005' and PrpJPrintInvoice.comCode ='2331000502' and PrpJPrintInvoice.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPrintInvoice.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjprintinvoice.ComCode like '23310%' OR 1=0 OR 1=0 ) ) order by visaserialno

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

5dv357yng47gw Select * From PrpDcompany Where ComCode = :1

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

5wmg5w5xp3a66 select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2141000128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '21410%' OR ( PrpJpayRefRec.handlercode='214100004' OR PrpJpayRefRec.operatorcode='214100004' OR PrpJpayRefRec.handler1code='214100004') OR 1=0 ) and rownum <= 1000

62xnx3wv7hq2d select rowid, CertiNo, CertiType, PolicyNo, SerialNo, FamilyNo, AcciCode, AcciName, Sex, Age, IdentifyType, IdentifyNumber, Remark, Flag, Phone, Address, RelationCode, RelationName, TherapyHospital, ApplyMoney, PersonSituation, ApplyDate, CertiFullDate, AcciDiagnose FROM PrpLacciPerson WHERE CertiNo = :1

63yq0tt748m85 SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpCcarshipTaxOrigin.licenseNo, PrpCcarshipTaxOrigin.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpCcarshipTaxOrigin, PrpJpayRefRec WHERE PrpCcarshipTaxOrigin.PolicyNo=PrpJpayRefRec.certino AND PrpCcarshipTaxOrigin.SerialNo=PrpJpayRefRec.SerialNo AND PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in('2371000000' , '2371000102' , '2371000128' , '2371000502' , '2371000580' , '2371000601' , '2371000602' , '2371000603' , '2371000604' , '2371081000' , '2371081502' , '2371081601' , '2371082000' , '2371082502' , '2371082601' , '2371083000' , '2371083502' , '2371083601' , '2371087000' , '2371087502' , '2371087601' , '2371088000' , '2371088502' , '2371088601' , '2371089000' , '2371089502' , '2371089601')) AND (PrpJpayRefRec.ComCode lik e '23710%' OR ( PrpJpayRefRec.handlercode='237100011' OR PrpJpayRefRec.operatorcode='237100011' OR PrpJpayRefRec.handler1code='237100011') OR 1=0 )Union All SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpPcarshipTax.licenseNo, PrpPcarshipTax.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpPcarshipTax, PrpJpayRefRec WHERE PrpPcarshipTax.endorseno=PrpJpayRefRec.certino AND PrpPcarshipTax.SerialNo=PrpJpayRefRec.SerialNo AND PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in('2371000000' , '2371000102' , '2371000128' , '2371000502' , '2371000580' , '2371000601' , '2371000602' , '2371000603' , '2371000604' , '2371081000' , '2371081502' , '2371081601' , '2371082000' , '2371082502' , '2371082601' , '2371083000' , '2371083502' , '2371083601' , '2371087000' , '2371087502' , '2371 087601' , '2371088000' , '2371088502' , '2371088601' , '2371089000' , '2371089502' , '2371089601')) AND (PrpJpayRefRec.ComCode like '23710%' OR ( PrpJpayRefRec.handlercode='237100011' OR PrpJpayRefRec.operatorcode='237100011' OR PrpJpayRefRec.handler1code='237100011') OR 1=0 ) order by policyno, certino, serialno

6bd9t0vtfy58m select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '232%' OR ( PrpJpayRefRec.handlercode='232000113' OR PrpJpayRefRec.operatorcode='232000113' OR PrpJpayRefRec.handler1code='232000113') OR 1=0 ) and rownum <= 1000

6g29pc6n8k36n SELECT * FROM PrpCmain WHERE 1=1 AND RiskCode='0590' AND (PrintNo IS NULL OR PrintNo = '') AND (ProposalNo IS NOT NULL) AND ( ( prpcmain.handlercode='QXSXYS_01' OR prpcmain.operatorcode='QXSXYS_01' OR prpcmain.handler1code='QXSXYS_01') OR 1=0 ) and not (SUBSTR(OthFlag, 4, 1) = '1') and (UnderWriteFlag='1' or UnderWriteFlag='3') order by MakeCom, PolicyNo

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

7960383qkahvm select rowid, PolicyNo, RiskCode, Currency, Amount, Premium, Flag From PrpCfee Where PolicyNo = :1 And Currency = :2

79jsxvmbq6ghn select rowid, ClaimNo, LFlag, CaseNo, ClassCode, RiskCode, RegistNo, PolicyNo, BusinessNature, Language, PolicyType, InsuredCode, InsuredName, StartDate, StartHour, EndDate, EndHour, Currency, SumAmount, SumPremium, SumQuantity, DamageStartDate, DamageStartHour, DamageEndDate, DamageEndHour, DamageCode, DamageName, DamageTypeCode, DamageTypeName, DamageAreaCode, DamageAreaName, DamageAddressType, AddressCode, DamageAddress, LossName, LossQuantity, DamageKind, ClaimDate, IndemnityDuty, IndemnityDutyRate, DeductibleRate, SumClaim, SumDefLoss, SumPaid, SumReplevy, Remark, CaseType, MakeCom, ComCode, AgentCode, HandlerCode, Handler1Code, StatisticsYM, OperatorCode, InputDate, EndCaseDate, EndCaserCode, CancelDate, CancelReason, DealerCode, EscapeFlag, Flag, ThirdComFlag, ReplevyFlag, cIndemnityDutyRate, EndCaseFlag, CatastropheCode1, CatastropheName1, CatastropheCode2, CatastropheName2, DamageAreaPostCode, ClaimType, EntrustComCode, EntrustedComCode, EntrustFlag, InjuryFlag, BrigandageFlag, RoadFlag, AcciLetterFlag, AcciLetterNo, ThirdVehicleFlag, AccidentCode, AccidentName, PaySelfFlag, SUBROGATION_FLAG, Endcaseplatdate, DamageAddressCode From PrpLclaim Where (ClaimNo IN (SELECT ClaimNo FROM PrpLcompensate WHERE CompensateNo = '405062150000120076492') OR ClaimNo IN (SELECT ClaimNo FROM PrpLprepay WHERE PreCompensateNo = '405062150000120076492') )

7c9b2tyakczhy select rowid, RegistNo, lFlag, ClassCode, RiskCode, PolicyNo, Language, InsuredCode, InsuredName, InsuredAddress, ClauseType, LicenseNo, LicenseColorCode, CarKindCode, ModelCode, BrandName, EngineNo, FrameNo, RunDistance, UseYears, ReportDate, ReportHour, ReportAddress, ReportorName, ReportType, PhoneNumber, LinkerName, DamageStartDate, DamageStartHour, DamageEndDate, DamageEndHour, DamageCode, DamageName, DamageTypeCode, DamageTypeName, FirstSiteFlag, DamageAreaCode, DamageAreaName, DamageAddressType, AddressCode, DamageAddress, DamageAreaPostCode, HandleUnit, LossName, LossQuantity, Unit, EstiCurrency, EstimateLoss, ReceiverName, HandlerCode, Handler1Code, ComCode, InputDate, AcceptFlag, RepeatInsureFlag, ClaimType, CancelDate, DealerCode, Remark, OperatorCode, MakeCom, Flag, ReportorPhoneNumber, LinkerPostCode, LinkerAddress, EstimateFee, CatastropheCode1, CatastropheName1, CatastropheCode2, CatastropheName2, ReportFlag, IndemnityDuty, WeatherCode, WeatherName, ManageTypeCode, ManageTypeName, SectionCode, SectionName, EntrustComCode, EntrustedComCode, EcdemicFlag, EntrustFlag, AccidentLossType, PaySelfFlag, DamageAddressCode, SUBROGATION_FLAG, DeductibleType, damageLongitude, DamageLatitude From PrpLregist Where RegistNo = :1

7fc94h80x0qfv SELECT COUNT(*) FROM PrpTmain WHERE RiskCode='0506' AND ProposalNo In( SELECT DISTINCT ProposalNo FROM PrpTitemCar WHERE PrpTitemCar.ProposalNo=PrpTmain.ProposalNo And RiskCode='0506' ) AND (prptmain.ComCode in (Select ComCode From PrpDcompany CONNECT BY PRIOR ComCode = UpperComCode START WITH ComCode = (Select UpperComCode From PrpDcompany Where ComCode = '2330100300')) OR 1=0 OR 1=0 )

7n2v52g7y5x1r SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpCcarshipTaxOrigin.licenseNo, PrpCcarshipTaxOrigin.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpCcarshipTaxOrigin, PrpJpayRefRec WHERE PrpCcarshipTaxOrigin.PolicyNo=PrpJpayRefRec.certino AND PrpCcarshipTaxOrigin.SerialNo=PrpJpayRefRec.SerialNo AND Prpjpayrefrec.riskcode='0590' and PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) and ComCode in( select comcode from business.prpdcompany start with comcode = '2520100000' connect by nocycle prior comcode = uppercomcode ) AND (PrpJpayRefRec.ComCode like '25201%' OR ( PrpJpayRefRec.handlercode='252010009' OR PrpJpayRefRec.operatorcode='252010009' OR PrpJpayRefRec.handler1code='252010009') OR 1=0 ) order by policyno, certino, serialno

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7nkswk2x5nnrc Select * From PrpUserGrade Where UserCode = :1 And GroupCode = :2 And TaskCode = :3 And CheckCode = :4

80zjzwpqa43qc Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2130200000', '2130200128', '2130200301', '2130200502', '2130200610', '2130200601', '2130200602', '2130200603', '2130200604', '2130200605', '2130200606', '2130200607', '2130200608', '2130200609', '2130200201', '2130200102', '2130200130', '2130200500', '2130281000', '2130281601', '2130281602', '2130281502', '2130281701', '2130229000', '2130229601', '2130207000', '2130207601', '2130207701', '2130208000', '2130208601', '2130283000', '2130283601', '2130283701', '2130224000', '2130224601', '2130200611', '2130200580', '2130200612', '2130225000', '2130225601', '2130225602', '2130200613', '2130299000', '2130299601')) or (swfLog.entrustedcomcode IN ( '2130200000', '2130200128', '2130200301', '2130200502', '2130200610', '2130200601', '2130200602', '2130200603', '2130200604', '2130200605', '2130200606', '2130200607', '2130200608', '2130200609', '2130200201', '2130200102', '2130200130', '2130200500', '2130281000', '2130281601', '2130281602', '2130281502', '2130281701', '2130229000', '2130229601', '2130207000', '2130207601', '2130207701', '2130208000', '2130208601', '2130283000', '2130283601', '2130283701', '2130224000', '2130224601', '2130200611', '2130200580', '2130200612', '2130225000', '2130225601', '2130225602', '2130200613', '2130299000', '2130299601') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc

896y3kr66cfdm SET TRANSACTION READ ONLY

89qyn4bbt03jq SELECT /*+ 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

8f1sjvfxuup9w select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null

8f696gckfqbqp select rowid, BusinessNo, PolicyNo, NodeType, SerialNo, RiskCode, Status, FlowID, HandlerCode, InputDate, OperateDate, TypeFlag, Flag, RegistNo, LicenseNo, InsuredName, AppliName, IdentifyNo, AcciName, ReceiverName, CancelDate, MainPolicyNo, ComCode, EntrustedComCode, EntrustComCode, Checker, ClaimNo, OperatorCode, LossItemName, UnderWriteFlag, CompensateNo, SumPaid, EndCaseNo, LossItemCode, CollectFlag, StartDate, CheckDate, EntrustFlag, Reportdate, CaseType, CheckNo FROM PrpLclaimStatus WHERE BusinessNo = :1 And NodeType = :2 And SerialNo = :3

8hd36umbhpgsz select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1

8qk5crj296shj select rowid, configCode, outerCode, innerCode, codeType, validStatus, riskType FROM UtiCodeTransfer WHERE 1=1

8qtnwfznp4xn7 Select * From PrpDuser Where UserCode = :1

8vqqrqngfu263 select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2140100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '214%' OR ( PrpJpayRefRec.handlercode='214000006' OR PrpJpayRefRec.operatorcode='214000006' OR PrpJpayRefRec.handler1code='214000006') OR 1=0 ) and rownum <= 1000

96vpq7w65y759 select evaluserin0_.ID as ID, evaluserin0_.EVAL_INFO_ID as EVAL_INF2_, evaluserin0_.USER_CODE as USER_CODE, evaluserin0_.PASSWORD as PASSWORD, evaluserin0_.REQUEST_TYPE as REQUEST_5_, evaluserin0_.POWER as POWER, evaluserin0_.AUDIT_FLAG as AUDIT_FLAG, evaluserin0_.ESTIMATE_NO as ESTIMATE8_, evaluserin0_.LOSS_NO as LOSS_NO, evaluserin0_.CASE_NO as CASE_NO, evaluserin0_.PLATE_NO as PLATE_NO, evaluserin0_.MARK_COLOR as MARK_COLOR, evaluserin0_.PLATE_COLOR as PLATE_C13_, evaluserin0_.ENGINE_NO as ENGINE_NO, evaluserin0_.FRAME_NO as FRAME_NO, evaluserin0_.INSURE_VEHICLE_NAME as INSURE_16_, evaluserin0_.INSURE_VEHICLE_CODE as INSURE_17_, evaluserin0_.COM_CODE as COM_CODE, evaluserin0_.COMPANY as COMPANY, evaluserin0_.HANDLER_CODE as HANDLER20_, evaluserin0_.HANDLER_NAME as HANDLER21_, evaluserin0_.FIX_RATE as FIX_RATE, evaluserin0_.MAN_HOUR as MAN_HOUR, evaluserin0_.DEL_FLAG as DEL_FLAG, evaluserin0_.CREATED_BY as CREATED_BY, evaluserin0_.CREATED_DATE as CREATED26_, evaluserin0_.UPDATED_BY as UPDATED_BY, evaluserin0_.UPDATED_DATE as UPDATED28_, evaluserin0_.REMARK as REMARK, evaluserin0_.RETURN_URL as RETURN_URL, evaluserin0_.BRANCH_COM_CODE as BRANCH_31_, evaluserin0_.BRANCH_COM_NAME as BRANCH_32_, evaluserin0_.PHONE as PHONE, evaluserin0_.CHG_COMP_SET_NAME as CHG_COM34_, evaluserin0_.CHG_COMP_SET_CODE as CHG_COM35_ from EVAL_USER_INFO evaluserin0_ where (evaluserin0_.DEL_FLAG='0' )and(evaluserin0_.CASE_NO=:1 )and(evaluserin0_.LOSS_NO=:2 )

97uq9r9t4rcqp select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320400128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23204%' OR ( PrpJpayRefRec.handlercode='232040045' OR PrpJpayRefRec.operatorcode='232040045' OR PrpJpayRefRec.handler1code='232040045') OR 1=0 ) and rownum <= 1000

9azd05uun8amq Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2320300000', '2320300601', '2320300602', '2320300603', '2320300604', '2320300128', '2320300500', '2320300502', '2320300606', '2320300605', '2320324000', '2320324601', '2320300607', '2320300102', '2320381000', '2320381601', '2320381602', '2320381603', '2320381604', '2320381605', '2320300608', '2320300610', '2320300201', '2320300609', '2320300611', '2320300617', '2320300616', '2320300615', '2320300612', '2320300614', '2320300613')) or (swfLog.entrustedcomcode IN ( '2320300000', '2320300601', '2320300602', '2320300603', '2320300604', '2320300128', '2320300500', '2320300502', '2320300606', '2320300605', '2320324000', '2320324601', '2320300607', '2320300102', '2320381000', '2320381601', '2320381602', '2320381603', '2320381604', '2320381605', '2320300608', '2320300610', '2320300201', '2320300609', '2320300611', '2320300617', '2320300616', '2320300615', '2320300612', '2320300614', '2320300613') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc

9cjjs2nh3cysp Select * from (SELECT T.*, Rownum As Linenum FROM ( Select Distinct FlowID, LogNo, ModelNo, NodeNo, NodeName, BusinessNo, HandleDept, HandlerCode, HandlerName, FlowInTime, TimeLimit, HandleTime, SubmitTime, NodeStatus, FlowStatus, PackageID, SwfLog.Flag, TaskNo, TaskType, NodeType, TitleStr, BusinessType, RiskCode, KeyIn, KeyOut, DeptName, MainFlowID, SubFlowID, PosX, PosY, EndFlag, BeforeHandlerCode, BeforeHandlerName, SwfLog.PolicyNo, TypeFlag, ComCode, ScheduleID, LossItemCode, LossItemName, InsureCarFlag, HandlerRange, ExigenceGree, RegistNo, InsuredName, EntrustComCode, EntrustedComCode, EntrustFlag, EntrustUserCode, EntrustUserName, EntrustNodeStatus, DamageStartDate, DamageEndDate From SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602')) or (swfLog.entrustedcomcode IN ( '2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc) T ) Where LineNum>0 And LineNum<=100

9j7sh88h1yct9 INSERT INTO PrpLext (CertiNo, CertiType, PersonDeathB, PersonDeathD1, PersonInjureB, PersonInjureD1, Carrier, SailStartDate, UnloadDate, AppliCheckDate, AppliPhone, InsuredPhone, CargoLossCheckCom, CargoLossType, ShareClaimer, Salvor, GuaranteeFlag, Currency, CargoValue, SalvaGuarantAmount, RestQuantity, Guarantor, Value1, Value2, Value3, Remark, Flag ) 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)

a0suvbq9zruyy select rowid, PolicyNo, RiskCode, RiskKind, GuaranteeType, GuaranteeName, MortgageNo, WarrantorCode, WarrantorName, LoanNo1, LoanNo2, InstallmentFlag, DeliverDate, LoanContractNo, LoanWay, LoanNature, LoanBankCode, LoanBankName, LoanUsage, LoanStartDate, LoanEndDate, LoanYear, PlanAmount, FirstRate, FirstPaid, Currency, LoanAmount, LoanRate, RepaidType, PaidTimes, PerRepaidAmount, Remark, flag FROM PrpCmainLoan WHERE PolicyNo = :1

a17rkh5dsxwb7 select check_card(:1, :2) from dual

a3nw9r52pkvxz SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0602007' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')

aawvjh7qqaxav select agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid from midgrmain where conditiontype='1' and saletype='1' and (conditiondesc is null or (conditiondesc is not null and not conditiondesc = '��ڴ��')) and posid is not null and comcode like '211%' group by agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid

abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

aku1v1xchwy96 Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2320500000', '2320000612', '2320000613', '2320000614', '2320000615', '2320000616', '2320000610', '2320500601', '2320500128', '2328100000', '2328100601', '2328100128', '2328100502', '2328100201', '2328400000', '2328400601', '2328400602', '2328400502', '2328400603', '2328500000', '2328500601', '2328500602', '2328500502', '2328500128', '2328800000', '2328800602', '2328800601', '2328800128', '2328800603', '2328800502', '2328900000', '2328900602', '2328900601', '2328900502', '2328900128', '2328300000', '2328300601', '2328300128', '2328600000', '2328600601', '2328600603', '2328600604', '2328600502', '2328600602', '2328600605', '2328600128', '2320500602', '2320500604', '2320500605', '2320500502', '2320500200', '2320501000', '2320501610', '2320501601', '2320501128', '2320500606', '2320500608', '2320500607', '2320500609', '2320500610', '2320588000', '2320588128', '2320588601', '2320588602', '2320588502', '2320588603', '2320589000', '2320589602', '2320589601', '2320589128', '2320589502', '2320589603', '2320500611', '2320581000', '2320581502', '2320581602', '2320581601', '2320581128', '2320581605', '2320581603', '2320581604', '2320581606', '2320583000', '2320583601', '2320583128', '2320583502', '2320583602', '2320583603', '2320583604', '2320583605', '2320583608', '2320583606', '2320583607', '2320584000', '2320584502', '2320584602', '2320584601', '2320584128', '2320584603', '2320 584604', '2320584701', '2320584606', '2320584605', '2320584607', '2320582000', '2320582603', '2320582601', '2320582602', '2320582128', '2320582502', '2320582604', '2320582605', '2320582606', '2320582607', '2320500612', '2320585000', '2320585502', '2320585601', '2320585602', '2320585128', '2320585603', '2320585604', '3208', '2320500614', '2320500613', '2320500603', '2320500616', '2320500615', '2320506000')) or (swfLog.entrustedcomcode IN ( '2320500000', '2320000612', '2320000613', '2320000614', '2320000615', '2320000616', '2320000610', '2320500601', '2320500128', '2328100000', '2328100601', '2328100128', '2328100502', '2328100201', '2328400000', '2328400601', '2328400602', '2328400502', '2328400603', '2328500000', '2328500601', '2328500602', '2328500502', '2328500128', '2328800000', '2328800602', '2328800601', '2328800128', '2328800603', '2328800502', '2328900000', '2328900602', '2328900601', '2328900502', '2328900128', '2328300000', '2328300601', '2328300128', '2328600000', '2328600601', '2328600603', '2328600604', '2328600502', '2328600602', '2328600605', '2328600128', '2320500602', '2320500604', '2320500605', '2320500502', '2320500200', '2320501000', '2320501610', '2320501601', '2320501128', '2320500606', '2320500608', '2320500607', '2320500609', '2320500610', '2320588000', '2320588128', '2320588601', '2320588602', '2320588502', '2320588603', '2320589000', '2320589602', '2320589601', '2320589128', '2320589502', '2320589603', '2320500611', '2320581000', '2320581502', '232058 1602', '2320581601', '2320581128', '2320581605', '2320581603', '2320581604', '2320581606', '2320583000', '2320583601', '2320583128', '2320583502', '2320583602', '2320583603', '2320583604', '2320583605', '2320583608', '2320583606', '2320583607', '2320584000', '2320584502', '2320584602', '2320584601', '2320584128', '2320584603', '2320584604', '2320584701', '2320584606', '2320584605', '2320584607', '2320582000', '2320582603', '2320582601', '2320582602', '2320582128', '2320582502', '2320582604', '2320582605', '2320582606', '2320582607', '2320500612', '2320585000', '2320585502', '2320585601', '2320585602', '2320585128', '2320585603', '2320585604', '3208', '2320500614', '2320500613', '2320500603', '2320500616', '2320500615', '2320506000') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

atvxrt64vtnmy Update PrpJpayRefRec Set CertiType = :1, CertiNo = :2, PolicyNo = :3, SerialNo = :4, PayRefReason = :5, PayRefTimes = :6, ClaimNo = :7, ClassCode = :8, RiskCode = :9, ContractNo = :10, AppliCode = :11, AppliName = :12, InsuredCode = :13, InsuredName = :14, StartDate = :15, EndDate = :16, ValidDate = :17, PayNo = :18, Currency1 = :19, PlanFee = :20, PlanDate = :21, ComCode = :22, MakeCom = :23, AgentCode = :24, Handler1Code = :25, HandlerCode = :26, UnderWriteDate = :27, CoinsFlag = :28, CoinsCode = :29, CoinsName = :30, CoinsType = :31, OperateDate = :32, OperatorCode = :33, OperateUnit = :34, Currency2 = :35, ExchangeRate = :36, PayRefFee = :37, VisaCode = :38, VisaName = :39, VisaSerialNo = :40, PrintDate = :41, PrinterCode = :42, VisaHandler = :43, PayRefName = :44, IdentifyType = :45, IdentifyNumber = :46, Remark = :47, PayRefNo = :48, PayRefDate = :49, Flag = :50, CarNatureCode = :51, CustomerType = :52, LossType = :53, SumPlanFee = :54, EntrustComCode = :55, EntrustedComCode = :56, EntrustFlag = :57, PayWay = :58, ShouldPayNum = :59, PayNum = :60, businessChanel = :61, businessNature = :62, IsRealPayFee = :63 Where CertiType = :64 And CertiNo = :65 And SerialNo = :66 And PayRefReason = :67 And PayRefTimes = :68

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

b1wc53ddd6h3p select audit$, options from procedure$ where obj#=:1

bt6b5hrjzm7sy SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpPcarshipTax.licenseNo, PrpPcarshipTax.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpPcarshipTax, PrpJpayRefRec WHERE PrpPcarshipTax.endorseno=PrpJpayRefRec.certino AND PrpPcarshipTax.SerialNo=PrpJpayRefRec.SerialNo AND Prpjpayrefrec.riskcode='0590' and PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) and ComCode in( select comcode from business.prpdcompany start with comcode = '2520100000' connect by nocycle prior comcode = uppercomcode ) AND (PrpJpayRefRec.ComCode like '25201%' OR ( PrpJpayRefRec.handlercode='252010009' OR PrpJpayRefRec.operatorcode='252010009' OR PrpJpayRefRec.handler1code='252010009') OR 1=0 ) order by policyno, certino, serialno

bunvx480ynf57 SELECT 1 FROM DUAL

bwwdby9gj0y48 select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23211%' OR ( PrpJpayRefRec.handlercode='232110007' OR PrpJpayRefRec.operatorcode='232110007' OR PrpJpayRefRec.handler1code='232110007') OR 1=0 ) and rownum <= 1000

cd6339bwu4p23 select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320200128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23202%' OR ( PrpJpayRefRec.handlercode='232020030' OR PrpJpayRefRec.operatorcode='232020030' OR PrpJpayRefRec.handler1code='232020030') OR 1=0 ) and rownum <= 1000

cg6nmxtcbgbnz select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320800128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23208%' OR ( PrpJpayRefRec.handlercode='232080016' OR PrpJpayRefRec.operatorcode='232080016' OR PrpJpayRefRec.handler1code='232080016') OR 1=0 ) and rownum <= 1000

cwftufrd5xsxh select prpjpayrefrec.certino from prpjpayrefrec, Prpjpayrefmain, Accmainvoucher where prpjpayrefrec.payrefno = Prpjpayrefmain.payrefno and Prpjpayrefmain.serialno='1' and Prpjpayrefmain.Centercode = Accmainvoucher.Centercode and accmainvoucher.voucherDate between to_date('2012-11-01') and to_date('2012-11-30') and 1=1 and Prpjpayrefmain.Yearmonth = Accmainvoucher.Yearmonth And Prpjpayrefmain.Voucherno = Accmainvoucher.Voucherno And prpjpayrefrec.payrefreason =:1 and prpjpayrefrec.payrefno!='0' and prpjpayrefrec.certitype='T' and prpjpayrefrec.certino=:2

cyvv4wv5drpnk SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0365256' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')

d4ggk0agny9tf SET TRANSACTION READ WRITE

d8ab9abx8ba05 select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321200128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23212%' OR ( PrpJpayRefRec.handlercode='232120022' OR PrpJpayRefRec.operatorcode='232120022' OR PrpJpayRefRec.handler1code='232120022') OR 1=0 ) and rownum <= 1000

d8c7ajzwp0zzd select rowid, ScheduleID, RegistNo, SurveyNo, ClaimComCode, RiskCode, PolicyNo, OperatorCode, InputDate, InputHour, ScheduleArea, ScheduleMoreFlag, ScheduleFlag, ScheduleObjectID, ScheduleObjectName, ScheduleType, CheckInputDate, CheckOperatorCode, CheckFlag, CheckInfo, Flag, CheckSite, NextHandlerCode, NextHandlerName, NextNodeNo, damageLongitude, damageLatitude, EntrustFlag From PrpLscheduleMainWF Where ScheduleID = :1 And RegistNo = :2

dccm4dw93qy3b begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;

dv2jvxn1p6vpb SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0280255' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')

dzdgfnjb0sfg0 select agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, ieipnetmac from midgrmain where conditiontype='1' and saletype='1' and (conditiondesc is null or (conditiondesc is not null and not conditiondesc = '��ڴ��')) and ieipnetmac is not null and comcode like '211%' group by agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid, ieipnetmac

dzmaaxssv3adq select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321000128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23210%' OR ( PrpJpayRefRec.handlercode='232100006' OR PrpJpayRefRec.operatorcode='232100006' OR PrpJpayRefRec.handler1code='232100006') OR 1=0 ) and rownum <= 1000

f1g45cc2jzh1h select evalinsure0_.ID as ID, evalinsure0_.EVAL_INFO_ID as EVAL_INF2_, evalinsure0_.INSURE_TERM as INSURE_T3_, evalinsure0_.INSURE_TERM_CODE as INSURE_T4_, evalinsure0_.DESCRIPTION as DESCRIPT5_, evalinsure0_.DEL_FLAG as DEL_FLAG, evalinsure0_.CREATED_BY as CREATED_BY, evalinsure0_.CREATED_DATE as CREATED_8_, evalinsure0_.UPDATED_BY as UPDATED_BY, evalinsure0_.UPDATED_DATE as UPDATED10_, evalinsure0_.REMARK as REMARK from EVAL_INSURE_TERM evalinsure0_ where (evalinsure0_.EVAL_INFO_ID=:1 )and(evalinsure0_.INSURE_TERM_CODE=:2 )

fnj6cnubp1sau begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

fu6r9gf3j4ghg select C_INSRNT_AGE from t_card_base where c_card_no=21510001000239891481

g294gwr2d5ppj Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602')) or (swfLog.entrustedcomcode IN ( '2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', ' 2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc

g73tzgnm4722f select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#

gjbmwtccqpdxa select * from prpjpayrefrec where RiskCode NOT IN ('0388') AND (CertiType IN ('P', 'E') or (certitype='T' and PayRefReason in('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))or (certitype='J' and PayRefReason in('P43'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and (payway ='00' Or (payway in ('02', '05', '03') And IsRealPayFee='1')) AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2370500502') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23705%' OR ( PrpJpayRefRec.handlercode='237050014' OR PrpJpayRefRec.operatorcode='237050014' OR PrpJpayRefRec.handler1code='237050014') OR 1=0 ) and rownum <= 1000

gmc40aqq66k5k SELECT logid.NEXTVAL FROM DUAL

gvyuhpu95pd1p SELECT * FROM PrpCmain WHERE PolicyNo = :1

SQL Id	SQL Text
045mhpa5150sp	Update PrpCmain Set PolicyNo = :1, ClassCode = :2, RiskCode =:3, ProposalNo = :4, ContractNo =:5, PolicySort = :6, PrintNo =:7, BusinessNature = :8, Language = :9, PolicyType = :10, AppliCode = :11, AppliName = :12, AppliAddress =:13, InsuredCode = :14, InsuredName = :15, InsuredAddress = :16, OperateDate = :17, StartDate = :18, StartHour = :19, EndDate = :20, EndHour = :21, PureRate = :22, DisRate = :23, Discount = :24, Currency = :25, SumValue = :26, SumAmount =:27, SumDiscount = :28, SumPremium = :29, SumSubPrem = :30, SumQuantity = :31, JudicalScope = :32, AutoTransRenewFlag = :33, ArgueSolution = :34, ArbitBoardName = :35, PayTimes = :36, EndorseTimes =:37, ClaimTimes = :38, MakeCom = :39, OperateSite = :40, ComCode = :41, HandlerCode = :42, Handler1Code = :43, ApproverCode = :44, UnderWriteCode =:45, UnderWriteName = :46, OperatorCode = :47, InputDate = :48, InputHour = :49, UnderWriteEndDate = :50, StatisticsYM = :51, AgentCode = :52, CoinsFlag = :53, ReinsFlag = :54, AllinsFlag = :55, UnderWriteFlag = :56, OthFlag = :57, Flag = :58, DisRate1 = :59, BusinessFlag = :60, PayMode = :61, UpdaterCode =:62, UpdateDate = :63, UpdateHour = :64, SignDate = :65, ShareHolderFlag = :66, SpecialChannel = :67, AgreementNo = :68, Remark = :69, InquiryNo = :70, PayDate = :71, PNPDate = :72, PrintDate = :73, AgricultureFlag = :74, BizTypeFlag = :75, AgricultureAmount = :76, EffectFlag = :77, EffectTime = :78, stopTimes = :79, CardKey = :80, salescode = :81, useNature = :82, ComputerIP = :83, BusinessChannel = :84, inputSysCode = :85 Where PolicyNo =:86
0967wz9v2dxu4	select rowid, CertiNo, CertiType, PersonDeathB, PersonDeathD1, PersonInjureB, PersonInjureD1, Carrier, SailStartDate, UnloadDate, AppliCheckDate, AppliPhone, InsuredPhone, CargoLossCheckCom, CargoLossType, ShareClaimer, Salvor, GuaranteeFlag, Currency, CargoValue, SalvaGuarantAmount, RestQuantity, Guarantor, Value1, Value2, Value3, Remark, Flag FROM PrpLext WHERE CertiNo = :1 And CertiType = :2
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kugqg48477gf	select distinct(-privilege#), nvl(option$, 0) from sysauth$ where grantee#=:1 and privilege#<0
0vxqqttq7yzz5	INSERT INTO PrpLcheck (RegistNo, ClaimNo, RiskCode, PolicyNo, CheckType, CheckNature, CheckDate, CheckSite, FirstSiteFlag, ClaimType, DamageCode, DamageName, DamageTypeCode, DamageTypeName, ReferKind, DamageAreaCode, DamageAddressType, IndemnityDuty, ClaimFlag, Checker1, Checker2, CheckUnitName, HandleUnit, Remark, Flag, ReferSerialNo, InsureCarFlag, RepeatInsureFlag, HandleUnitCode, UnitType, EstimateFee, EstimateLoss, DamageStartDate, DamageStartHour, DamageAddress, CheckLinker, EntrustFlag, InjuryFlag, BrigandageFlag, RoadFlag, AcciLetterFlag, AcciLetterNo, ThirdVehicleFlag, AccidentCode, AccidentName, CheckCode1, CheckCode2, ManageTypeCode, ManageTypeName, SubCertiType, SubCertiTypeName, paySelfFlag, subClaimFlag, DamageAddressCode) 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)
0xj1u01p9jh71	select C_INSRNT_AGE from t_card_base where c_card_no=10060005000215784353
0xwby571mq3n2	select name, password, datats#, tempts#, type#, defrole, resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass, NULL, 'DEFAULT_CONSUMER_GROUP', defschclass), spare1 from user$ where user#=:1
1c98q25nhftbz	Insert Into PrpLRegistRPolicy ( RegistNo, PolicyNo, ClaimNo, PolicyType, FlowId, Remark, ValidStatus, Flag, RiskCode, RegistFlag, RegistCancelDate, ComCode) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
1gu8t96d0bdmu	select 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# (+)
1gxycd9mf6qsu	Select * From PrpDrisk Where RiskCode = :1
1p6c8x0pamrsm	select comCode as comCode, visaCode as VisaCode, visaName as visaName, sum(earlyNoReturn) as earlyNoReturn, sum(inBetweenQuantity) as inBetweenQuantity, sum(outBetweenQuantity) as outBetweenQuantity, sum(returnBetweenQuantity) as returnBetweenQuantity, (sum(earlyNoReturn)+sum(inBetweenQuantity)-sum(outBetweenQuantity)-sum(returnBetweenQuantity)) as laterNoReturn from( (select comcode as comCode, visacode as visaCode, visaname as visaName, (sum(inQuantity)-sum(outQuantity)-sum(returnedQuantity)) as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from ( select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(StorageQuantity) as inQuantity, 0 as outQuantity, 0 as returnedQuantity from vsstorage where comcode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') and CheckerCode is not null group by comcode, visacode, visaname) union all select * from (select Acceptercomcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(Quantity) as inQuantity, 0 as outQuantity, 0 as returnedQuantity from vsprovide where acceptercomcode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by acceptercomcode, visacode, visaname) union all select * from (select confirmcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, sum(Quantity) as inQuantity, 0 as outQ uantity, 0 as returnedQuantity from vsrecycle where confirmcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by confirmcode, visacode, visaname) union all select * from (select providercode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, sum(Quantity) as outQuantity, 0 as returnedQuantity from vsprovide where providercode in ('2370521000') and 1=1 and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by providercode, visacode, visaname) union all select * from (select submitcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, sum(Quantity) as outQuantity, 0 as returnedQuantity from vsrecycle where submitcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate <= to_date('2012-1-1', 'YYYY-MM-DD') group by submitcode, visacode, visaname) union all select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, 0 as outQuantity, count() as returnedQuantity from vsmark where comcode in ('2370521000') and 1=1 and UseDate <= to_date('2012-1-1', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) union all select from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyBalance, 0 as inQuantity, 0 as outQuantity, count() as returnedQuantity from vsmarkhis where comcode in ('2370521000') and 1=1 and UseDate <= to_date('2012-1-1', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname)) group by comcode, visacode, visaname) union all select from (select ComCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(StorageQuantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from VsStorage where comcode in ('2370521000') and 1=1 and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and CheckerCode is not null group by comcode, visacode, visaname) union all select * from (select confirmCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(Quantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from Vsrecycle where confirmcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by confirmcode, visacode, visaname) union all select * from (select acceptercomcode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, sum(Quantity) as inBetweenQuantity, 0 as outBetweenQuantity, 0 as returnBetweenQuantity from Vsprovide where acceptercomcode in ('2370521000') and 1=1 and InputDate Between to_dat e('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by acceptercomcode, visacode, visaname) union all select * from (select ProviderCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, sum(Quantity) as outBetweenQuantity, 0 as returnBetweenQuantity from vsProvide where providercode in ('2370521000') and 1=1 and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by providercode, visacode, visaname) union all select * from (select submitCode as comCode, VisaCode as VisaCode, VisaName as VisaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, sum(Quantity) as outBetweenQuantity, 0 as returnBetweenQuantity from vsrecycle where submitcode in ('2370521000') and 1=1 and confirmdate is not null and InputDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') group by submitcode, visacode, visaname) union all select * from (select comcode as comCode, visacode as visaCode, visaname as visaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, count() as returnBetweenQuantity from vsmark where comcode in ('2370521000') and 1=1 and UseDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) union all select from (select comcode as comCode, v isacode as visaCode, visaname as visaName, 0 as earlyNoReturn, 0 as inBetweenQuantity, 0 as outBetweenQuantity, count(*) as returnBetweenQuantity from vsMarkHis where comcode in ('2370521000') and 1=1 and UseDate Between to_date('2012-1-1', 'YYYY-MM-DD') AND to_date('2012-12-26', 'YYYY-MM-DD') and (visaStatus = '04' or visaStatus = '05' or visaStatus = '06' or visaStatus = '11') group by comcode, visacode, visaname) )group by comCode, visaCode, visaName order by comCode, visaCode, visaName
23pnnkv6fav1g	SELECT * FROM CIInsureDemand WHERE proposalNo = :1
23u3gum7h1gjd	Insert Into PrpLqualityCheck ( RegistNo, QualityCheckType, SerialNo, TypeCode, TypeName, CheckResult, CheckRemark, Flag) values(:1, :2, :3, :4, :5, :6, :7, :8)
2696phr1u823r	INSERT INTO PrpLloss (CompensateNo, RiskCode, PolicyNo, SerialNo, ItemKindNo, FamilyNo, FamilyName, KindCode, LicenseNo, ItemCode, LossName, ItemAddress, FeeTypeCode, FeeTypeName, LossQuantity, Unit, UnitPrice, BuyDate, DepreRate, Currency, Amount, Currency1, ItemValue, Currency2, SumLoss, SumRest, IndemnityDutyRate, ClaimRate, Currency3, DeductibleRate, Deductible, Currency4, SumRealPay, Flag, RejectReason, DutyDeductibleRate, DriverDeductibleRate, Remark, ArrangeRate, SumDefPay, NoDutyDeductAmount, damageDate, endcasedate, lossquantity1, typecode, damageReasonCode) 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)
2drgycsfvvhwx	SELECT ReqRespNo, SerialNo, RType, RTime, RXml FROM (Select RowNum As LineNum, T.* From (Select * From prpebaoxml Where 1=1) T) Where linenum > 1440000 and LineNum <= 1445000
2h699fygt52rg	SELECT COUNT(*) FROM PrpJpayRefExp WHERE planfee<0 and exists (select 1 from prpjpayrefrec b where b.certitype = 'E' and prpjpayrefexp.certino = b.certino and prpjpayrefexp.serialno = b.serialno and prpjpayrefexp.payreftimes = b.payreftimes and b.payrefno > '0' And (Case When b.validdate>b.underwritedate Then b.validdate Else b.underwritedate End) >=Date'2012-1-1' ) and payrefno='0' and ( 1=0 or comCode = '2508900000' or comCode = '2500381502' or comCode = '2500381580' or comCode = '2500381601' or comCode = '2500381602' or comCode = '2500382580' or comCode = '2500382601' or comCode = '2500000601' or comCode = '2500000602' or comCode = '2500000603' or comCode = '2500000604' or comCode = '2500000605' or comCode = '2500000606' or comCode = '2500000607' or comCode = '2500000608' or comCode = '2500000609' or comCode = '2500381000' or comCode = '2500382000' or comCode = '2508900128' or comCode = '2508900502' or comCode = '2508900601' or comCode = '2508900602' or comCode = '2508900603' or comCode = '2508900604' or comCode = '2508900605' or comCode = '2508900606' or comCode = '2508900607' or comCode = '2508900608' or comCode = '2508900609' or comCode = '2508900610' or comCode = '2508900611' or comCode = '2508900612' or comCode = '2508900613' or comCode = '2508900701' or comCode = '2508900702' or comCode = '2508983000' or comCode = '2508983502' or comCode = '2508983701')and feeType='3 ' and ((CoinsFlag='1' and CoinsType='1') or (CoinsFlag='2' and CoinsType='1') or (CoinsFlag='0')) and not exists (select 1 from (select certino, serialno, sum(planfee) from prpjpayrefexp where ( 1=0 or comCode = '2508900000' or comCode = '2500381502' or comCode = '2500381580' or comCode = '2500381601' or comCode = '2500381602' or comCode = '2500382580' or comCode = '2500382601' or comCode = '2500000601' or comCode = '2500000602' or comCode = '2500000603' or comCode = '2500000604' or comCode = '2500000605' or comCode = '2500000606' or comCode = '2500000607' or comCode = '2500000608' or comCode = '2500000609' or comCode = '2500381000' or comCode = '2500382000' or comCode = '2508900128' or comCode = '2508900502' or comCode = '2508900601' or comCode = '2508900602' or comCode = '2508900603' or comCode = '2508900604' or comCode = '2508900605' or comCode = '2508900606' or comCode = '2508900607' or comCode = '2508900608' or comCode = '2508900609' or comCode = '2508900610' or comCode = '2508900611' or comCode = '2508900612' or comCode = '2508900613' or comCode = '2508900701' or comCode = '2508900702' or comCode = '2508983000' or comCode = '2508983502' or comCode = '2508983701') and feeType='3' group by certino, serialno having sum(planfee)=0 )p Where prpjpayrefexp.certino = p.certino and prpjpayrefexp.serialno = p.serialno )
2nh8vygjwqty9	call sff_payrefrec.Querydataforconfirm(:1, :2, :3, :4, :5)
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
30qqj8f05b8c9	select evalinsure0_.ID as ID, evalinsure0_.EVAL_INFO_ID as EVAL_INF2_, evalinsure0_.INSURE_TERM as INSURE_T3_, evalinsure0_.INSURE_TERM_CODE as INSURE_T4_, evalinsure0_.DESCRIPTION as DESCRIPT5_, evalinsure0_.DEL_FLAG as DEL_FLAG, evalinsure0_.CREATED_BY as CREATED_BY, evalinsure0_.CREATED_DATE as CREATED_8_, evalinsure0_.UPDATED_BY as UPDATED_BY, evalinsure0_.UPDATED_DATE as UPDATED10_, evalinsure0_.REMARK as REMARK from EVAL_INSURE_TERM evalinsure0_ where (evalinsure0_.EVAL_INFO_ID=:1 )
3qbktmazwqxwc	Insert Into PrpLdangerItem ( CertiNo, RiskCode, DangerNo, SerialNo, KindFlag, KindCode, KindName, PostCode, AddressName, Currency, SumPaid, SumFee, RegistNo, Flag) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)
3s34rwupy93ts	Select * From PrpTmain Where ProposalNo = :1
3s38a2wuku1rr	Select * from PrpDcode Where codetype='ClaimStatus' AND codecode='4'
3t2h6pb90mgsr	SELECT char_cont FROM Eval_Content where char_cont_id=:1 order by char_order
3ysvgb0mpgqss	select rowid, configCode, outerCode, innerCode, codeType, validStatus, riskType FROM UtiCodeTransfer WHERE outercode=:1
4dv2q7v3adc1d	INSERT INTO PrpLcertifyCollect (BusinessNo, LossItemCode, LossItemName, PicCount, StartDate, StartHour, EndDate, EndHour, OperatorCode, CollectFlag, CltInsureCarFlag, CltThirdCarFlag, CltPersonFlag, CltPropFlag, CltCarLossFlag, CltAllLossFlag, CaseFlag, Content, Flag, PolicyNo, RiskCode, UploadYear, PAYSELFFLAG, SubCertiType, SubCertiTypeName, subClaimFlag, CompelFlag ) 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)
4j70gn3a9azyb	SELECT VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName, PayRefFee FROM ( SELECT a.VisaCode, a.VisaName, a.visaserialno, a.Currency2, a.PrintDate, a.PrinterCode, a.VisaHandler, a.PayRefName, a.PayRefFee FROM ( SELECT VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName, sum(PayRefFee) as PayRefFee FROM PrpJpayRefRec WHERE CertiType IN ('P', 'E', 'T') AND VisaSerialNo IS NOT NULL and PrpJPayRefRec.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPayRefRec.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjpayrefrec.ComCode like '23310%' OR ( prpjpayrefrec.handlercode='233100005' OR prpjpayrefrec.operatorcode='233100005' OR prpjpayrefrec.handler1code='233100005') OR 1=0 ) and PrpJPayRefRec.PrintDate is not null Group By VisaCode, VisaName, visaserialno, Currency2, PrintDate, PrinterCode, VisaHandler, PayRefName )a where not exists ( select 1 from (SELECT PrpJPrintInvoice.VisaCode as VisaCode, PrpJPrintInvoice.VisaName as VisaName, PrpJPrintInvoice.visaserialno as visaSerialNo, PrpJPrintInvoice.Currency1 as currency2, PrpJPrintInvoice.PrintDate as PrintDate, PrpJPrintInvoice.PrinterCode as PrinterCode, Prpjpayrefrec.VisaHandler as VisaHandler, Prpjpayrefrec.PayRefName as PayRefName, PrpJPrintInvoice.PrintRefFee as payRefFee FROM PrpJPrintInvoice, Prpjpayrefrec WHERE PrpJPrintInvoice.certino=Prpjpayrefrec.certino and PrpJPrintInvoice.certitype=Prpjpayrefrec.cert itype and PrpJPrintInvoice.CertiType IN ('P', 'E', 'T') AND PrpJPrintInvoice.VisaSerialNo IS NOT NULL and PrpJPrintInvoice.printercode='233100005' and PrpJPrintInvoice.comCode ='2331000502' and PrpJPrintInvoice.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPrintInvoice.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjprintinvoice.ComCode like '23310%' OR 1=0 OR 1=0 ))b where a.visaserialno=b.visaserialno ) union all SELECT PrpJPrintInvoice.VisaCode as VisaCode, PrpJPrintInvoice.VisaName as VisaName, PrpJPrintInvoice.visaserialno as visaSerialNo, PrpJPrintInvoice.Currency1 as currency2, PrpJPrintInvoice.PrintDate as PrintDate, PrpJPrintInvoice.PrinterCode as PrinterCode, Prpjpayrefrec.VisaHandler as VisaHandler, Prpjpayrefrec.PayRefName as PayRefName, PrpJPrintInvoice.PrintRefFee as payRefFee FROM PrpJPrintInvoice, Prpjpayrefrec WHERE PrpJPrintInvoice.certino=Prpjpayrefrec.certino and PrpJPrintInvoice.certitype=Prpjpayrefrec.certitype and PrpJPrintInvoice.CertiType IN ('P', 'E', 'T') AND PrpJPrintInvoice.VisaSerialNo IS NOT NULL and PrpJPrintInvoice.printercode='233100005' and PrpJPrintInvoice.comCode ='2331000502' and PrpJPrintInvoice.PrintDate>=to_date('2012-05-02', 'YYYY-MM-DD') and PrpJPrintInvoice.PrintDate<=to_date('2012-05-02', 'YYYY-MM-DD') AND (prpjprintinvoice.ComCode like '23310%' OR 1=0 OR 1=0 ) ) order by visaserialno
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
5dv357yng47gw	Select * From PrpDcompany Where ComCode = :1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5wmg5w5xp3a66	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2141000128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '21410%' OR ( PrpJpayRefRec.handlercode='214100004' OR PrpJpayRefRec.operatorcode='214100004' OR PrpJpayRefRec.handler1code='214100004') OR 1=0 ) and rownum <= 1000
62xnx3wv7hq2d	select rowid, CertiNo, CertiType, PolicyNo, SerialNo, FamilyNo, AcciCode, AcciName, Sex, Age, IdentifyType, IdentifyNumber, Remark, Flag, Phone, Address, RelationCode, RelationName, TherapyHospital, ApplyMoney, PersonSituation, ApplyDate, CertiFullDate, AcciDiagnose FROM PrpLacciPerson WHERE CertiNo = :1
63yq0tt748m85	SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpCcarshipTaxOrigin.licenseNo, PrpCcarshipTaxOrigin.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpCcarshipTaxOrigin, PrpJpayRefRec WHERE PrpCcarshipTaxOrigin.PolicyNo=PrpJpayRefRec.certino AND PrpCcarshipTaxOrigin.SerialNo=PrpJpayRefRec.SerialNo AND PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in('2371000000' , '2371000102' , '2371000128' , '2371000502' , '2371000580' , '2371000601' , '2371000602' , '2371000603' , '2371000604' , '2371081000' , '2371081502' , '2371081601' , '2371082000' , '2371082502' , '2371082601' , '2371083000' , '2371083502' , '2371083601' , '2371087000' , '2371087502' , '2371087601' , '2371088000' , '2371088502' , '2371088601' , '2371089000' , '2371089502' , '2371089601')) AND (PrpJpayRefRec.ComCode lik e '23710%' OR ( PrpJpayRefRec.handlercode='237100011' OR PrpJpayRefRec.operatorcode='237100011' OR PrpJpayRefRec.handler1code='237100011') OR 1=0 )Union All SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpPcarshipTax.licenseNo, PrpPcarshipTax.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpPcarshipTax, PrpJpayRefRec WHERE PrpPcarshipTax.endorseno=PrpJpayRefRec.certino AND PrpPcarshipTax.SerialNo=PrpJpayRefRec.SerialNo AND PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in('2371000000' , '2371000102' , '2371000128' , '2371000502' , '2371000580' , '2371000601' , '2371000602' , '2371000603' , '2371000604' , '2371081000' , '2371081502' , '2371081601' , '2371082000' , '2371082502' , '2371082601' , '2371083000' , '2371083502' , '2371083601' , '2371087000' , '2371087502' , '2371 087601' , '2371088000' , '2371088502' , '2371088601' , '2371089000' , '2371089502' , '2371089601')) AND (PrpJpayRefRec.ComCode like '23710%' OR ( PrpJpayRefRec.handlercode='237100011' OR PrpJpayRefRec.operatorcode='237100011' OR PrpJpayRefRec.handler1code='237100011') OR 1=0 ) order by policyno, certino, serialno
6bd9t0vtfy58m	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '232%' OR ( PrpJpayRefRec.handlercode='232000113' OR PrpJpayRefRec.operatorcode='232000113' OR PrpJpayRefRec.handler1code='232000113') OR 1=0 ) and rownum <= 1000
6g29pc6n8k36n	SELECT * FROM PrpCmain WHERE 1=1 AND RiskCode='0590' AND (PrintNo IS NULL OR PrintNo = '') AND (ProposalNo IS NOT NULL) AND ( ( prpcmain.handlercode='QXSXYS_01' OR prpcmain.operatorcode='QXSXYS_01' OR prpcmain.handler1code='QXSXYS_01') OR 1=0 ) and not (SUBSTR(OthFlag, 4, 1) = '1') and (UnderWriteFlag='1' or UnderWriteFlag='3') order by MakeCom, PolicyNo
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7960383qkahvm	select rowid, PolicyNo, RiskCode, Currency, Amount, Premium, Flag From PrpCfee Where PolicyNo = :1 And Currency = :2
79jsxvmbq6ghn	select rowid, ClaimNo, LFlag, CaseNo, ClassCode, RiskCode, RegistNo, PolicyNo, BusinessNature, Language, PolicyType, InsuredCode, InsuredName, StartDate, StartHour, EndDate, EndHour, Currency, SumAmount, SumPremium, SumQuantity, DamageStartDate, DamageStartHour, DamageEndDate, DamageEndHour, DamageCode, DamageName, DamageTypeCode, DamageTypeName, DamageAreaCode, DamageAreaName, DamageAddressType, AddressCode, DamageAddress, LossName, LossQuantity, DamageKind, ClaimDate, IndemnityDuty, IndemnityDutyRate, DeductibleRate, SumClaim, SumDefLoss, SumPaid, SumReplevy, Remark, CaseType, MakeCom, ComCode, AgentCode, HandlerCode, Handler1Code, StatisticsYM, OperatorCode, InputDate, EndCaseDate, EndCaserCode, CancelDate, CancelReason, DealerCode, EscapeFlag, Flag, ThirdComFlag, ReplevyFlag, cIndemnityDutyRate, EndCaseFlag, CatastropheCode1, CatastropheName1, CatastropheCode2, CatastropheName2, DamageAreaPostCode, ClaimType, EntrustComCode, EntrustedComCode, EntrustFlag, InjuryFlag, BrigandageFlag, RoadFlag, AcciLetterFlag, AcciLetterNo, ThirdVehicleFlag, AccidentCode, AccidentName, PaySelfFlag, SUBROGATION_FLAG, Endcaseplatdate, DamageAddressCode From PrpLclaim Where (ClaimNo IN (SELECT ClaimNo FROM PrpLcompensate WHERE CompensateNo = '405062150000120076492') OR ClaimNo IN (SELECT ClaimNo FROM PrpLprepay WHERE PreCompensateNo = '405062150000120076492') )
7c9b2tyakczhy	select rowid, RegistNo, lFlag, ClassCode, RiskCode, PolicyNo, Language, InsuredCode, InsuredName, InsuredAddress, ClauseType, LicenseNo, LicenseColorCode, CarKindCode, ModelCode, BrandName, EngineNo, FrameNo, RunDistance, UseYears, ReportDate, ReportHour, ReportAddress, ReportorName, ReportType, PhoneNumber, LinkerName, DamageStartDate, DamageStartHour, DamageEndDate, DamageEndHour, DamageCode, DamageName, DamageTypeCode, DamageTypeName, FirstSiteFlag, DamageAreaCode, DamageAreaName, DamageAddressType, AddressCode, DamageAddress, DamageAreaPostCode, HandleUnit, LossName, LossQuantity, Unit, EstiCurrency, EstimateLoss, ReceiverName, HandlerCode, Handler1Code, ComCode, InputDate, AcceptFlag, RepeatInsureFlag, ClaimType, CancelDate, DealerCode, Remark, OperatorCode, MakeCom, Flag, ReportorPhoneNumber, LinkerPostCode, LinkerAddress, EstimateFee, CatastropheCode1, CatastropheName1, CatastropheCode2, CatastropheName2, ReportFlag, IndemnityDuty, WeatherCode, WeatherName, ManageTypeCode, ManageTypeName, SectionCode, SectionName, EntrustComCode, EntrustedComCode, EcdemicFlag, EntrustFlag, AccidentLossType, PaySelfFlag, DamageAddressCode, SUBROGATION_FLAG, DeductibleType, damageLongitude, DamageLatitude From PrpLregist Where RegistNo = :1
7fc94h80x0qfv	SELECT COUNT(*) FROM PrpTmain WHERE RiskCode='0506' AND ProposalNo In( SELECT DISTINCT ProposalNo FROM PrpTitemCar WHERE PrpTitemCar.ProposalNo=PrpTmain.ProposalNo And RiskCode='0506' ) AND (prptmain.ComCode in (Select ComCode From PrpDcompany CONNECT BY PRIOR ComCode = UpperComCode START WITH ComCode = (Select UpperComCode From PrpDcompany Where ComCode = '2330100300')) OR 1=0 OR 1=0 )
7n2v52g7y5x1r	SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpCcarshipTaxOrigin.licenseNo, PrpCcarshipTaxOrigin.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpCcarshipTaxOrigin, PrpJpayRefRec WHERE PrpCcarshipTaxOrigin.PolicyNo=PrpJpayRefRec.certino AND PrpCcarshipTaxOrigin.SerialNo=PrpJpayRefRec.SerialNo AND Prpjpayrefrec.riskcode='0590' and PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) and ComCode in( select comcode from business.prpdcompany start with comcode = '2520100000' connect by nocycle prior comcode = uppercomcode ) AND (PrpJpayRefRec.ComCode like '25201%' OR ( PrpJpayRefRec.handlercode='252010009' OR PrpJpayRefRec.operatorcode='252010009' OR PrpJpayRefRec.handler1code='252010009') OR 1=0 ) order by policyno, certino, serialno
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7nkswk2x5nnrc	Select * From PrpUserGrade Where UserCode = :1 And GroupCode = :2 And TaskCode = :3 And CheckCode = :4
80zjzwpqa43qc	Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2130200000', '2130200128', '2130200301', '2130200502', '2130200610', '2130200601', '2130200602', '2130200603', '2130200604', '2130200605', '2130200606', '2130200607', '2130200608', '2130200609', '2130200201', '2130200102', '2130200130', '2130200500', '2130281000', '2130281601', '2130281602', '2130281502', '2130281701', '2130229000', '2130229601', '2130207000', '2130207601', '2130207701', '2130208000', '2130208601', '2130283000', '2130283601', '2130283701', '2130224000', '2130224601', '2130200611', '2130200580', '2130200612', '2130225000', '2130225601', '2130225602', '2130200613', '2130299000', '2130299601')) or (swfLog.entrustedcomcode IN ( '2130200000', '2130200128', '2130200301', '2130200502', '2130200610', '2130200601', '2130200602', '2130200603', '2130200604', '2130200605', '2130200606', '2130200607', '2130200608', '2130200609', '2130200201', '2130200102', '2130200130', '2130200500', '2130281000', '2130281601', '2130281602', '2130281502', '2130281701', '2130229000', '2130229601', '2130207000', '2130207601', '2130207701', '2130208000', '2130208601', '2130283000', '2130283601', '2130283701', '2130224000', '2130224601', '2130200611', '2130200580', '2130200612', '2130225000', '2130225601', '2130225602', '2130200613', '2130299000', '2130299601') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc
896y3kr66cfdm	SET TRANSACTION READ ONLY
89qyn4bbt03jq	SELECT /+ 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
8f1sjvfxuup9w	select t., o., m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8f696gckfqbqp	select rowid, BusinessNo, PolicyNo, NodeType, SerialNo, RiskCode, Status, FlowID, HandlerCode, InputDate, OperateDate, TypeFlag, Flag, RegistNo, LicenseNo, InsuredName, AppliName, IdentifyNo, AcciName, ReceiverName, CancelDate, MainPolicyNo, ComCode, EntrustedComCode, EntrustComCode, Checker, ClaimNo, OperatorCode, LossItemName, UnderWriteFlag, CompensateNo, SumPaid, EndCaseNo, LossItemCode, CollectFlag, StartDate, CheckDate, EntrustFlag, Reportdate, CaseType, CheckNo FROM PrpLclaimStatus WHERE BusinessNo = :1 And NodeType = :2 And SerialNo = :3
8hd36umbhpgsz	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1
8qk5crj296shj	select rowid, configCode, outerCode, innerCode, codeType, validStatus, riskType FROM UtiCodeTransfer WHERE 1=1
8qtnwfznp4xn7	Select * From PrpDuser Where UserCode = :1
8vqqrqngfu263	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2140100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '214%' OR ( PrpJpayRefRec.handlercode='214000006' OR PrpJpayRefRec.operatorcode='214000006' OR PrpJpayRefRec.handler1code='214000006') OR 1=0 ) and rownum <= 1000
96vpq7w65y759	select evaluserin0_.ID as ID, evaluserin0_.EVAL_INFO_ID as EVAL_INF2_, evaluserin0_.USER_CODE as USER_CODE, evaluserin0_.PASSWORD as PASSWORD, evaluserin0_.REQUEST_TYPE as REQUEST_5_, evaluserin0_.POWER as POWER, evaluserin0_.AUDIT_FLAG as AUDIT_FLAG, evaluserin0_.ESTIMATE_NO as ESTIMATE8_, evaluserin0_.LOSS_NO as LOSS_NO, evaluserin0_.CASE_NO as CASE_NO, evaluserin0_.PLATE_NO as PLATE_NO, evaluserin0_.MARK_COLOR as MARK_COLOR, evaluserin0_.PLATE_COLOR as PLATE_C13_, evaluserin0_.ENGINE_NO as ENGINE_NO, evaluserin0_.FRAME_NO as FRAME_NO, evaluserin0_.INSURE_VEHICLE_NAME as INSURE_16_, evaluserin0_.INSURE_VEHICLE_CODE as INSURE_17_, evaluserin0_.COM_CODE as COM_CODE, evaluserin0_.COMPANY as COMPANY, evaluserin0_.HANDLER_CODE as HANDLER20_, evaluserin0_.HANDLER_NAME as HANDLER21_, evaluserin0_.FIX_RATE as FIX_RATE, evaluserin0_.MAN_HOUR as MAN_HOUR, evaluserin0_.DEL_FLAG as DEL_FLAG, evaluserin0_.CREATED_BY as CREATED_BY, evaluserin0_.CREATED_DATE as CREATED26_, evaluserin0_.UPDATED_BY as UPDATED_BY, evaluserin0_.UPDATED_DATE as UPDATED28_, evaluserin0_.REMARK as REMARK, evaluserin0_.RETURN_URL as RETURN_URL, evaluserin0_.BRANCH_COM_CODE as BRANCH_31_, evaluserin0_.BRANCH_COM_NAME as BRANCH_32_, evaluserin0_.PHONE as PHONE, evaluserin0_.CHG_COMP_SET_NAME as CHG_COM34_, evaluserin0_.CHG_COMP_SET_CODE as CHG_COM35_ from EVAL_USER_INFO evaluserin0_ where (evaluserin0_.DEL_FLAG='0' )and(evaluserin0_.CASE_NO=:1 )and(evaluserin0_.LOSS_NO=:2 )
97uq9r9t4rcqp	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320400128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23204%' OR ( PrpJpayRefRec.handlercode='232040045' OR PrpJpayRefRec.operatorcode='232040045' OR PrpJpayRefRec.handler1code='232040045') OR 1=0 ) and rownum <= 1000
9azd05uun8amq	Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2320300000', '2320300601', '2320300602', '2320300603', '2320300604', '2320300128', '2320300500', '2320300502', '2320300606', '2320300605', '2320324000', '2320324601', '2320300607', '2320300102', '2320381000', '2320381601', '2320381602', '2320381603', '2320381604', '2320381605', '2320300608', '2320300610', '2320300201', '2320300609', '2320300611', '2320300617', '2320300616', '2320300615', '2320300612', '2320300614', '2320300613')) or (swfLog.entrustedcomcode IN ( '2320300000', '2320300601', '2320300602', '2320300603', '2320300604', '2320300128', '2320300500', '2320300502', '2320300606', '2320300605', '2320324000', '2320324601', '2320300607', '2320300102', '2320381000', '2320381601', '2320381602', '2320381603', '2320381604', '2320381605', '2320300608', '2320300610', '2320300201', '2320300609', '2320300611', '2320300617', '2320300616', '2320300615', '2320300612', '2320300614', '2320300613') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc
9cjjs2nh3cysp	Select * from (SELECT T.*, Rownum As Linenum FROM ( Select Distinct FlowID, LogNo, ModelNo, NodeNo, NodeName, BusinessNo, HandleDept, HandlerCode, HandlerName, FlowInTime, TimeLimit, HandleTime, SubmitTime, NodeStatus, FlowStatus, PackageID, SwfLog.Flag, TaskNo, TaskType, NodeType, TitleStr, BusinessType, RiskCode, KeyIn, KeyOut, DeptName, MainFlowID, SubFlowID, PosX, PosY, EndFlag, BeforeHandlerCode, BeforeHandlerName, SwfLog.PolicyNo, TypeFlag, ComCode, ScheduleID, LossItemCode, LossItemName, InsureCarFlag, HandlerRange, ExigenceGree, RegistNo, InsuredName, EntrustComCode, EntrustedComCode, EntrustFlag, EntrustUserCode, EntrustUserName, EntrustNodeStatus, DamageStartDate, DamageEndDate From SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602')) or (swfLog.entrustedcomcode IN ( '2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc) T ) Where LineNum>0 And LineNum<=100
9j7sh88h1yct9	INSERT INTO PrpLext (CertiNo, CertiType, PersonDeathB, PersonDeathD1, PersonInjureB, PersonInjureD1, Carrier, SailStartDate, UnloadDate, AppliCheckDate, AppliPhone, InsuredPhone, CargoLossCheckCom, CargoLossType, ShareClaimer, Salvor, GuaranteeFlag, Currency, CargoValue, SalvaGuarantAmount, RestQuantity, Guarantor, Value1, Value2, Value3, Remark, Flag ) 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)
a0suvbq9zruyy	select rowid, PolicyNo, RiskCode, RiskKind, GuaranteeType, GuaranteeName, MortgageNo, WarrantorCode, WarrantorName, LoanNo1, LoanNo2, InstallmentFlag, DeliverDate, LoanContractNo, LoanWay, LoanNature, LoanBankCode, LoanBankName, LoanUsage, LoanStartDate, LoanEndDate, LoanYear, PlanAmount, FirstRate, FirstPaid, Currency, LoanAmount, LoanRate, RepaidType, PaidTimes, PerRepaidAmount, Remark, flag FROM PrpCmainLoan WHERE PolicyNo = :1
a17rkh5dsxwb7	select check_card(:1, :2) from dual
a3nw9r52pkvxz	SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0602007' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')
aawvjh7qqaxav	select agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid from midgrmain where conditiontype='1' and saletype='1' and (conditiondesc is null or (conditiondesc is not null and not conditiondesc = '��ڴ��')) and posid is not null and comcode like '211%' group by agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
aku1v1xchwy96	Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2320500000', '2320000612', '2320000613', '2320000614', '2320000615', '2320000616', '2320000610', '2320500601', '2320500128', '2328100000', '2328100601', '2328100128', '2328100502', '2328100201', '2328400000', '2328400601', '2328400602', '2328400502', '2328400603', '2328500000', '2328500601', '2328500602', '2328500502', '2328500128', '2328800000', '2328800602', '2328800601', '2328800128', '2328800603', '2328800502', '2328900000', '2328900602', '2328900601', '2328900502', '2328900128', '2328300000', '2328300601', '2328300128', '2328600000', '2328600601', '2328600603', '2328600604', '2328600502', '2328600602', '2328600605', '2328600128', '2320500602', '2320500604', '2320500605', '2320500502', '2320500200', '2320501000', '2320501610', '2320501601', '2320501128', '2320500606', '2320500608', '2320500607', '2320500609', '2320500610', '2320588000', '2320588128', '2320588601', '2320588602', '2320588502', '2320588603', '2320589000', '2320589602', '2320589601', '2320589128', '2320589502', '2320589603', '2320500611', '2320581000', '2320581502', '2320581602', '2320581601', '2320581128', '2320581605', '2320581603', '2320581604', '2320581606', '2320583000', '2320583601', '2320583128', '2320583502', '2320583602', '2320583603', '2320583604', '2320583605', '2320583608', '2320583606', '2320583607', '2320584000', '2320584502', '2320584602', '2320584601', '2320584128', '2320584603', '2320 584604', '2320584701', '2320584606', '2320584605', '2320584607', '2320582000', '2320582603', '2320582601', '2320582602', '2320582128', '2320582502', '2320582604', '2320582605', '2320582606', '2320582607', '2320500612', '2320585000', '2320585502', '2320585601', '2320585602', '2320585128', '2320585603', '2320585604', '3208', '2320500614', '2320500613', '2320500603', '2320500616', '2320500615', '2320506000')) or (swfLog.entrustedcomcode IN ( '2320500000', '2320000612', '2320000613', '2320000614', '2320000615', '2320000616', '2320000610', '2320500601', '2320500128', '2328100000', '2328100601', '2328100128', '2328100502', '2328100201', '2328400000', '2328400601', '2328400602', '2328400502', '2328400603', '2328500000', '2328500601', '2328500602', '2328500502', '2328500128', '2328800000', '2328800602', '2328800601', '2328800128', '2328800603', '2328800502', '2328900000', '2328900602', '2328900601', '2328900502', '2328900128', '2328300000', '2328300601', '2328300128', '2328600000', '2328600601', '2328600603', '2328600604', '2328600502', '2328600602', '2328600605', '2328600128', '2320500602', '2320500604', '2320500605', '2320500502', '2320500200', '2320501000', '2320501610', '2320501601', '2320501128', '2320500606', '2320500608', '2320500607', '2320500609', '2320500610', '2320588000', '2320588128', '2320588601', '2320588602', '2320588502', '2320588603', '2320589000', '2320589602', '2320589601', '2320589128', '2320589502', '2320589603', '2320500611', '2320581000', '2320581502', '232058 1602', '2320581601', '2320581128', '2320581605', '2320581603', '2320581604', '2320581606', '2320583000', '2320583601', '2320583128', '2320583502', '2320583602', '2320583603', '2320583604', '2320583605', '2320583608', '2320583606', '2320583607', '2320584000', '2320584502', '2320584602', '2320584601', '2320584128', '2320584603', '2320584604', '2320584701', '2320584606', '2320584605', '2320584607', '2320582000', '2320582603', '2320582601', '2320582602', '2320582128', '2320582502', '2320582604', '2320582605', '2320582606', '2320582607', '2320500612', '2320585000', '2320585502', '2320585601', '2320585602', '2320585128', '2320585603', '2320585604', '3208', '2320500614', '2320500613', '2320500603', '2320500616', '2320500615', '2320506000') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
atvxrt64vtnmy	Update PrpJpayRefRec Set CertiType = :1, CertiNo = :2, PolicyNo = :3, SerialNo = :4, PayRefReason = :5, PayRefTimes = :6, ClaimNo = :7, ClassCode = :8, RiskCode = :9, ContractNo = :10, AppliCode = :11, AppliName = :12, InsuredCode = :13, InsuredName = :14, StartDate = :15, EndDate = :16, ValidDate = :17, PayNo = :18, Currency1 = :19, PlanFee = :20, PlanDate = :21, ComCode = :22, MakeCom = :23, AgentCode = :24, Handler1Code = :25, HandlerCode = :26, UnderWriteDate = :27, CoinsFlag = :28, CoinsCode = :29, CoinsName = :30, CoinsType = :31, OperateDate = :32, OperatorCode = :33, OperateUnit = :34, Currency2 = :35, ExchangeRate = :36, PayRefFee = :37, VisaCode = :38, VisaName = :39, VisaSerialNo = :40, PrintDate = :41, PrinterCode = :42, VisaHandler = :43, PayRefName = :44, IdentifyType = :45, IdentifyNumber = :46, Remark = :47, PayRefNo = :48, PayRefDate = :49, Flag = :50, CarNatureCode = :51, CustomerType = :52, LossType = :53, SumPlanFee = :54, EntrustComCode = :55, EntrustedComCode = :56, EntrustFlag = :57, PayWay = :58, ShouldPayNum = :59, PayNum = :60, businessChanel = :61, businessNature = :62, IsRealPayFee = :63 Where CertiType = :64 And CertiNo = :65 And SerialNo = :66 And PayRefReason = :67 And PayRefTimes = :68
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b1wc53ddd6h3p	select audit$, options from procedure$ where obj#=:1
bt6b5hrjzm7sy	SELECT PrpJpayRefRec.certiType, PrpJpayRefRec.certiNo, PrpJpayRefRec.policyNo, PrpJpayRefRec.serialNo, PrpJpayRefRec.insuredName, PrpJpayRefRec.startDate, PrpJpayRefRec.validDate, PrpJpayRefRec.payNo, PrpJpayRefRec.planFee, PrpJpayRefRec.planDate, PrpJpayRefRec.handler1Code, PrpJpayRefRec.underWriteDate, PrpJpayRefRec.exchangeRate, PrpJpayRefRec.payRefFee, PrpJpayRefRec.payRefNo, PrpJpayRefRec.payRefDate, PrpPcarshipTax.licenseNo, PrpPcarshipTax.taxPayerName, PrpJpayRefRec.payRefReason, PrpJpayRefRec.payRefTimes, PrpJpayRefRec.currency1 FROM PrpPcarshipTax, PrpJpayRefRec WHERE PrpPcarshipTax.endorseno=PrpJpayRefRec.certino AND PrpPcarshipTax.SerialNo=PrpJpayRefRec.SerialNo AND Prpjpayrefrec.riskcode='0590' and PrpJpayRefRec.CertiType ='T' AND PrpJpayRefRec.PayRefDate IS NULL AND PrpJpayRefRec.PayRefno = '0' AND Currency1 = 'CNY' AND (PrpJpayRefRec.payrefreason in ('T30', 'T31', 'T32', 'T40', 'T41', 'T42')) AND PrpJpayRefRec.payway<>'04' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) and ComCode in( select comcode from business.prpdcompany start with comcode = '2520100000' connect by nocycle prior comcode = uppercomcode ) AND (PrpJpayRefRec.ComCode like '25201%' OR ( PrpJpayRefRec.handlercode='252010009' OR PrpJpayRefRec.operatorcode='252010009' OR PrpJpayRefRec.handler1code='252010009') OR 1=0 ) order by policyno, certino, serialno
bunvx480ynf57	SELECT 1 FROM DUAL
bwwdby9gj0y48	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321100128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23211%' OR ( PrpJpayRefRec.handlercode='232110007' OR PrpJpayRefRec.operatorcode='232110007' OR PrpJpayRefRec.handler1code='232110007') OR 1=0 ) and rownum <= 1000
cd6339bwu4p23	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320200128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23202%' OR ( PrpJpayRefRec.handlercode='232020030' OR PrpJpayRefRec.operatorcode='232020030' OR PrpJpayRefRec.handler1code='232020030') OR 1=0 ) and rownum <= 1000
cg6nmxtcbgbnz	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2320800128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23208%' OR ( PrpJpayRefRec.handlercode='232080016' OR PrpJpayRefRec.operatorcode='232080016' OR PrpJpayRefRec.handler1code='232080016') OR 1=0 ) and rownum <= 1000
cwftufrd5xsxh	select prpjpayrefrec.certino from prpjpayrefrec, Prpjpayrefmain, Accmainvoucher where prpjpayrefrec.payrefno = Prpjpayrefmain.payrefno and Prpjpayrefmain.serialno='1' and Prpjpayrefmain.Centercode = Accmainvoucher.Centercode and accmainvoucher.voucherDate between to_date('2012-11-01') and to_date('2012-11-30') and 1=1 and Prpjpayrefmain.Yearmonth = Accmainvoucher.Yearmonth And Prpjpayrefmain.Voucherno = Accmainvoucher.Voucherno And prpjpayrefrec.payrefreason =:1 and prpjpayrefrec.payrefno!='0' and prpjpayrefrec.certitype='T' and prpjpayrefrec.certino=:2
cyvv4wv5drpnk	SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0365256' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')
d4ggk0agny9tf	SET TRANSACTION READ WRITE
d8ab9abx8ba05	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321200128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23212%' OR ( PrpJpayRefRec.handlercode='232120022' OR PrpJpayRefRec.operatorcode='232120022' OR PrpJpayRefRec.handler1code='232120022') OR 1=0 ) and rownum <= 1000
d8c7ajzwp0zzd	select rowid, ScheduleID, RegistNo, SurveyNo, ClaimComCode, RiskCode, PolicyNo, OperatorCode, InputDate, InputHour, ScheduleArea, ScheduleMoreFlag, ScheduleFlag, ScheduleObjectID, ScheduleObjectName, ScheduleType, CheckInputDate, CheckOperatorCode, CheckFlag, CheckInfo, Flag, CheckSite, NextHandlerCode, NextHandlerName, NextNodeNo, damageLongitude, damageLatitude, EntrustFlag From PrpLscheduleMainWF Where ScheduleID = :1 And RegistNo = :2
dccm4dw93qy3b	begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
dv2jvxn1p6vpb	SELECT COUNT(*) FROM PrpTcarshipTax WHERE PaidFreeCertificate='0280255' AND proposalno IN (SELECT proposalno FROM prptmain WHERE substr(othflag, 4, 1)!='2' AND proposalno LIKE '10590241%')
dzdgfnjb0sfg0	select agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, ieipnetmac from midgrmain where conditiontype='1' and saletype='1' and (conditiondesc is null or (conditiondesc is not null and not conditiondesc = '��ڴ��')) and ieipnetmac is not null and comcode like '211%' group by agentcode, riskcode, currency, comcode, handler1code, agreementno, policyid, posid, ieipnetmac
dzmaaxssv3adq	select * from prpjpayrefrec where (CertiType IN ('P', 'E') or (certitype='T' and payrefreason in ('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and payway='01' and IsRealPayFee='1' AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2321000128') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23210%' OR ( PrpJpayRefRec.handlercode='232100006' OR PrpJpayRefRec.operatorcode='232100006' OR PrpJpayRefRec.handler1code='232100006') OR 1=0 ) and rownum <= 1000
f1g45cc2jzh1h	select evalinsure0_.ID as ID, evalinsure0_.EVAL_INFO_ID as EVAL_INF2_, evalinsure0_.INSURE_TERM as INSURE_T3_, evalinsure0_.INSURE_TERM_CODE as INSURE_T4_, evalinsure0_.DESCRIPTION as DESCRIPT5_, evalinsure0_.DEL_FLAG as DEL_FLAG, evalinsure0_.CREATED_BY as CREATED_BY, evalinsure0_.CREATED_DATE as CREATED_8_, evalinsure0_.UPDATED_BY as UPDATED_BY, evalinsure0_.UPDATED_DATE as UPDATED10_, evalinsure0_.REMARK as REMARK from EVAL_INSURE_TERM evalinsure0_ where (evalinsure0_.EVAL_INFO_ID=:1 )and(evalinsure0_.INSURE_TERM_CODE=:2 )
fnj6cnubp1sau	begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
fu6r9gf3j4ghg	select C_INSRNT_AGE from t_card_base where c_card_no=21510001000239891481
g294gwr2d5ppj	Select count(flowid) from SwfLog Where nodeType='regis' and flowstatus > '0' AND ((swfLog.comcode in ('2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', '2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602')) or (swfLog.entrustedcomcode IN ( '2210200000', '2210200500', '2210200302', '2210288000', '2210288601', '2210288602', '2210288603', '2210200201', '2210200601', '2210200602', '2210200502', '2210200102', '210201', '2210200128', '2210200606', '2210200607', '2210200608', '2210200604', '2210200605', '2210281000', '2210281601', '2210281128', '2210281502', '2210213000', '2210213601', '2210213502', '2210213128', '210202', '2210200603', '2210200609', '2210283000', '2210283128', '2210283601', '2210283502', ' 2210244000', '2210244601', '2210287000', '2210287601', '2210287602', '2210287603', '2210287604', '2210289000', '2210289601', '2210289602', '2210200610', '2210200612', '2210299000', '2210299502', '2210299128', '2210299601', '2210299602', '2210299603', '2210299604', '2210299605', '2210299606', '2210299607', '2210200613', '2210200611', '2210200614', '2210298000', '2210298128', '2210298502', '2210298601', '2210298602') ) ) and (swfLog.riskCode in ('0501', '0502', '0503', '0505', '0506', '0590') ) order by handleTime desc
g73tzgnm4722f	select u.name, o.name, trigger$.sys_evts, trigger$.type# from obj$ o, user$ u, trigger$ where bitand(trigger$.property, 16) = 16 and trigger$.baseobject = :1 and trigger$.obj# = o.obj# and o.owner# = u.user# order by o.obj#
gjbmwtccqpdxa	select * from prpjpayrefrec where RiskCode NOT IN ('0388') AND (CertiType IN ('P', 'E') or (certitype='T' and PayRefReason in('T10', 'T11', 'T12', 'T20', 'T21', 'T22'))or (certitype='J' and PayRefReason in('P43'))) AND PayRefDate IS NULL AND PayRefno = '0' AND Currency1 = 'CNY' and (payway ='00' Or (payway in ('02', '05', '03') And IsRealPayFee='1')) AND ((CoinsFlag='1' and CoinsType='1')or(CoinsFlag='2' and CoinsType='1')or(CoinsFlag='0')) AND (ComCode in(Select ComCode From Prpdcompany Start With Comcode = Sff_Common.getCentercodeByComcode('2370500502') Connect By nocycle Prior Comcode = Uppercomcode And ( (CenterFlag <> '2' AND CenterFlag <> '1') Or Centerflag Is Null ) ) ) AND (PrpJpayRefRec.ComCode like '23705%' OR ( PrpJpayRefRec.handlercode='237050014' OR PrpJpayRefRec.operatorcode='237050014' OR PrpJpayRefRec.handler1code='237050014') OR 1=0 ) and rownum <= 1000
gmc40aqq66k5k	SELECT logid.NEXTVAL FROM DUAL
gvyuhpu95pd1p	SELECT * FROM PrpCmain WHERE PolicyNo = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	1,117,133	309.75	27.93
CPU used when call started	1,114,092	308.91	27.85
CR blocks created	7,715	2.14	0.19
Cached Commit SCN referenced	1,448,028	401.50	36.20
Commit SCN cached	484	0.13	0.01
DB time	4,263,044	1,182.02	106.58
DBWR checkpoint buffers written	70,056	19.42	1.75
DBWR checkpoints	4	0.00	0.00
DBWR fusion writes	8,281	2.30	0.21
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	1,038	0.29	0.03
DBWR undo block writes	12,347	3.42	0.31
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	17	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	55	0.02	0.00
PX local messages sent	55	0.02	0.00
PX remote messages recv'd	330	0.09	0.01
PX remote messages sent	211	0.06	0.01
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	17	0.00	0.00
RowCR - row contention	2,484	0.69	0.06
RowCR attempts	205,407	56.95	5.14
RowCR hits	202,432	56.13	5.06
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	2	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	10,928,761	3,030.24	273.23
SQL*Net roundtrips to/from dblink	90	0.02	0.00
active txn count during cleanout	12,238	3.39	0.31
application wait time	4,503	1.25	0.11
background checkpoints completed	3	0.00	0.00
background checkpoints started	4	0.00	0.00
background timeouts	21,254	5.89	0.53
branch node splits	8	0.00	0.00
buffer is not pinned count	310,023,089	85,960.69	7,750.77
buffer is pinned count	647,614,522	179,565.32	16,190.77
bytes received via SQL*Net from client	1,159,133,767	321,395.23	28,979.07
bytes received via SQL*Net from dblink	24,660	6.84	0.62
bytes sent via SQL*Net to client	3,417,755,785	947,647.68	85,446.03
bytes sent via SQL*Net to dblink	24,918	6.91	0.62
calls to get snapshot scn: kcmgss	8,328,577	2,309.28	208.22
calls to kcmgas	242,561	67.26	6.06
calls to kcmgcs	4,640	1.29	0.12
change write time	733	0.20	0.02
cleanout - number of ktugct calls	11,509	3.19	0.29
cleanouts and rollbacks - consistent read gets	5,130	1.42	0.13
cleanouts only - consistent read gets	1,273	0.35	0.03
cluster key scan block gets	191,029	52.97	4.78
cluster key scans	89,288	24.76	2.23
cluster wait time	570,851	158.28	14.27
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	3,622	1.00	0.09
commit batch/immediate requested	3,622	1.00	0.09
commit cleanout failures: block lost	89	0.02	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	554	0.15	0.01
commit cleanout failures: cannot pin	31	0.01	0.00
commit cleanouts	222,792	61.77	5.57
commit cleanouts successfully completed	222,118	61.59	5.55
commit immediate performed	3,621	1.00	0.09
commit immediate requested	3,621	1.00	0.09
commit txn count during cleanout	25,057	6.95	0.63
concurrency wait time	804,635	223.10	20.12
consistent changes	16,313	4.52	0.41
consistent gets	719,580,964	199,519.59	17,989.97
consistent gets - examination	125,280,505	34,736.76	3,132.09
consistent gets direct	1,650	0.46	0.04
consistent gets from cache	719,579,527	199,519.19	17,989.94
current blocks converted for CR	30	0.01	0.00
cursor authentications	190,607	52.85	4.77
data blocks consistent reads - undo records applied	15,527	4.31	0.39
db block changes	971,262	269.30	24.28
db block gets	1,482,328	411.01	37.06
db block gets direct	1,728	0.48	0.04
db block gets from cache	1,480,603	410.53	37.02
deferred (CURRENT) block cleanout applications	87,464	24.25	2.19
dirty buffers inspected	28,727	7.97	0.72
enqueue conversions	13,541	3.75	0.34
enqueue deadlocks	0	0.00	0.00
enqueue releases	2,043,623	566.64	51.09
enqueue requests	2,043,680	566.66	51.09
enqueue timeouts	5	0.00	0.00
enqueue waits	3,624	1.00	0.09
exchange deadlocks	13	0.00	0.00
execute count	7,443,145	2,063.78	186.08
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	63,385,990	17,575.15	1,584.69
free buffer requested	63,306,537	17,553.12	1,582.70
gc CPU used by this session	284,885	78.99	7.12
gc blocks lost	0	0.00	0.00
gc cr block build time	61	0.02	0.00
gc cr block flush time	9	0.00	0.00
gc cr block receive time	3,370	0.93	0.08
gc cr block send time	140	0.04	0.00
gc cr blocks received	41,698	11.56	1.04
gc cr blocks served	49,776	13.80	1.24
gc current block flush time	1	0.00	0.00
gc current block pin time	1,688	0.47	0.04
gc current block receive time	746,190	206.90	18.66
gc current block send time	9,816	2.72	0.25
gc current blocks received	7,462,331	2,069.09	186.56
gc current blocks served	3,402,379	943.38	85.06
gc local grants	47,680,431	13,220.44	1,192.04
gc remote grants	8,090,370	2,243.23	202.26
gcs messages sent	29,834,294	8,272.21	745.88
ges messages sent	547,445	151.79	13.69
global enqueue get time	12,737	3.53	0.32
global enqueue gets async	50,829	14.09	1.27
global enqueue gets sync	1,588,286	440.39	39.71
global enqueue releases	1,604,300	444.83	40.11
heap block compress	7,047	1.95	0.18
hot buffers moved to head of LRU	4,145,713	1,149.49	103.65
immediate (CR) block cleanout applications	6,403	1.78	0.16
immediate (CURRENT) block cleanout applications	32,788	9.09	0.82
index crx upgrade (found)	11	0.00	0.00
index crx upgrade (positioned)	128,837	35.72	3.22
index fast full scans (full)	2,567	0.71	0.06
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	67,211,014	18,635.73	1,680.32
index scans kdiixs1	152,715,043	42,343.59	3,817.97
leaf node 90-10 splits	64	0.02	0.00
leaf node splits	1,095	0.30	0.03
lob reads	547	0.15	0.01
lob writes	27,258	7.56	0.68
lob writes unaligned	27,121	7.52	0.68
logons cumulative	225	0.06	0.01
messages received	166,940	46.29	4.17
messages sent	166,556	46.18	4.16
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	593,142,565	164,461.77	14,828.93
opened cursors cumulative	1,377,420	381.92	34.44
parse count (failures)	187,824	52.08	4.70
parse count (hard)	869,273	241.02	21.73
parse count (total)	2,621,131	726.77	65.53
parse time cpu	47,296	13.11	1.18
parse time elapsed	246,438	68.33	6.16
physical read IO requests	8,813,293	2,443.68	220.34
physical read bytes	###############	126,803,240.98	11,433,398.62
physical read total IO requests	8,889,226	2,464.73	222.24
physical read total bytes	###############	127,071,885.22	11,457,621.31
physical read total multi block requests	4,060,081	1,125.75	101.50
physical reads	55,825,738	15,478.91	1,395.68
physical reads cache	55,745,937	15,456.78	1,393.68
physical reads cache prefetch	47,690,167	13,223.14	1,192.28
physical reads direct	79,808	22.13	2.00
physical reads direct (lob)	1,284	0.36	0.03
physical reads direct temporary tablespace	77,960	21.62	1.95
physical reads prefetch warmup	56	0.02	0.00
physical write IO requests	97,038	26.91	2.43
physical write bytes	1,307,762,688	362,605.86	32,694.88
physical write total IO requests	321,403	89.12	8.04
physical write total bytes	2,381,061,632	660,201.51	59,528.03
physical write total multi block requests	99,611	27.62	2.49
physical writes	159,639	44.26	3.99
physical writes direct	51,595	14.31	1.29
physical writes direct (lob)	1,622	0.45	0.04
physical writes direct temporary tablespace	49,756	13.80	1.24
physical writes from cache	108,044	29.96	2.70
physical writes non checkpoint	133,751	37.09	3.34
pinned buffers inspected	807	0.22	0.02
prefetch clients - default	3	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	72	0.02	0.00
process last non-idle time	3,613	1.00	0.09
queries parallelized	17	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	4,607,772	1,277.61	115.20
recursive cpu usage	84,216	23.35	2.11
redo blocks written	436,557	121.04	10.91
redo buffer allocation retries	41	0.01	0.00
redo entries	542,879	150.53	13.57
redo log space requests	41	0.01	0.00
redo log space wait time	39	0.01	0.00
redo ordering marks	11,520	3.19	0.29
redo size	204,345,092	56,659.15	5,108.76
redo subscn max counts	8,678	2.41	0.22
redo synch time	2,609	0.72	0.07
redo synch writes	42,217	11.71	1.06
redo wastage	11,957,124	3,315.37	298.94
redo write time	1,869	0.52	0.05
redo writer latching time	1	0.00	0.00
redo writes	46,249	12.82	1.16
rollback changes - undo records applied	8,181	2.27	0.20
rollbacks only - consistent read gets	2,558	0.71	0.06
rows fetched via callback	20,411,507	5,659.54	510.30
session connect time	0	0.00	0.00
session cursor cache hits	1,169,298	324.21	29.23
session logical reads	721,063,085	199,930.54	18,027.03
session pga memory	906,841,344	251,441.63	22,671.60
session pga memory max	2,451,370,336	679,696.14	61,285.79
session uga memory	###############	71,617,941.55	6,457,535.84
session uga memory max	2,174,072,936	602,809.36	54,353.18
shared hash latch upgrades - no wait	643,544	178.44	16.09
shared hash latch upgrades - wait	104,451	28.96	2.61
sorts (disk)	2	0.00	0.00
sorts (memory)	38,090,468	10,561.42	952.29
sorts (rows)	334,972,000	92,878.33	8,374.51
sql area evicted	680,187	188.60	17.01
sql area purged	176,433	48.92	4.41
summed dirty queue length	33,216	9.21	0.83
switch current to new buffer	4,740	1.31	0.12
table fetch by rowid	283,695,348	78,660.75	7,092.56
table fetch continued row	120,456	33.40	3.01
table scan blocks gotten	186,976,421	51,843.31	4,674.53
table scan rows gotten	5,960,415,236	1,652,655.72	149,014.11
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	404	0.11	0.01
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	233,649	64.78	5.84
total number of times SMON posted	16	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	3,622	1.00	0.09
transaction tables consistent read rollbacks	2	0.00	0.00
transaction tables consistent reads - undo records applied	145	0.04	0.00
undo change vector size	62,659,820	17,373.81	1,566.53
user I/O wait time	1,765,293	489.47	44.13
user calls	11,965,401	3,317.67	299.14
user commits	30,532	8.47	0.76
user rollbacks	9,467	2.62	0.24
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	3	0.00	0.00
workarea executions - optimal	37,778,813	10,475.00	944.49
write clones created in background	0	0.00	0.00
write clones created in foreground	4	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	6,199,169	6,243,995
opened cursors current	9,713	11,122
workarea memory allocated	1,508	304,142
logons current	1,184	1,203

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	4	3.99

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BUSINESS	8,054,202	2,233	1.85	6.42	37,740	10	2,387,338	1.84
BUSIDX	405,177	112	4.39	1.11	49,576	14	112,183	2.95
ACCBIZ	280,934	78	1.31	12.54	1,320	0	122,136	3.79
JYDATA	24,252	7	3.81	1.03	703	0	2,598	2.82
SYSAUX	21,197	6	1.07	1.00	711	0	0	0.00
TEMP	11,588	3	4.14	6.73	3,916	1	0	0.00
SYSTEM	4,680	1	3.61	1.01	220	0	5	80.00
UNDOTBS1	395	0	4.68	1.00	2,593	1	35	0.57
BUSRND	1,364	0	4.63	5.09	25	0	0	0.00
TAB_YDCK	37	0	3.78	1.08	57	0	0	0.00
TAB_YXXT	26	0	5.38	1.00	23	0	0	0.00
EIES	4	0	5.00	1.00	3	0	0	0.00
UNDOTBS2	2	0	20.00	1.00	2	0	105	1.43
EIESIDX	2	0	5.00	1.00	1	0	0	0.00
JYIDX	2	0	5.00	1.00	1	0	0	0.00
TAB_DXPT	2	0	5.00	1.00	1	0	0	0.00
USERS	1	0	20.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
ACCBIZ	/dev/rlvaccbiz01	110,829	31	1.25	12.92	62	0	44,229	2.19
ACCBIZ	/dev/rlvaccbiz02	111,912	31	1.29	13.02	156	0	43,509	2.21
ACCBIZ	/dev/rlvaccbiz03	27,973	8	1.19	13.94	132	0	13,456	2.14
ACCBIZ	/dev/rlvaccbiz04	21,276	6	1.81	6.99	230	0	17,607	13.31
ACCBIZ	/dev/rlvaccbiz05	8,944	2	1.44	10.57	740	0	3,335	1.88
BUSIDX	/dev/rlvbusidx01	15,383	4	3.80	1.06	1,764	0	4,892	2.55
BUSIDX	/dev/rlvbusidx02	16,049	4	4.16	1.06	1,712	0	3,968	2.48
BUSIDX	/dev/rlvbusidx03	16,917	5	4.07	1.06	2,168	1	4,697	2.24
BUSIDX	/dev/rlvbusidx04	16,838	5	4.54	1.07	1,701	0	6,132	3.09
BUSIDX	/dev/rlvbusidx05	15,194	4	4.19	1.07	1,670	0	6,120	2.44
BUSIDX	/dev/rlvbusidx06	14,397	4	4.76	1.09	1,567	0	6,608	2.75
BUSIDX	/dev/rlvbusidx07	15,164	4	4.12	1.10	1,574	0	2,705	2.82
BUSIDX	/dev/rlvbusidx08	13,952	4	4.43	1.12	1,643	0	5,121	2.84
BUSIDX	/dev/rlvbusidx09	16,081	4	3.99	1.11	1,691	0	2,071	2.49
BUSIDX	/dev/rlvbusidx10	12,405	3	4.50	1.15	1,783	0	2,553	3.11
BUSIDX	/dev/rlvbusidx11	11,203	3	4.54	1.18	1,579	0	1,723	2.07
BUSIDX	/dev/rlvbusidx12	12,442	3	4.58	1.18	1,845	1	5,598	2.27
BUSIDX	/dev/rlvbusidx13	12,936	4	4.31	1.16	2,252	1	5,719	2.58
BUSIDX	/dev/rlvbusidx14	12,761	4	4.93	1.17	2,139	1	5,856	2.62
BUSIDX	/dev/rlvbusidx15	13,082	4	4.79	1.17	1,741	0	8,949	3.51
BUSIDX	/dev/rlvbusidx16	13,192	4	4.23	1.17	1,757	0	8,973	2.42
BUSIDX	/dev/rlvbusidx17	11,472	3	5.09	1.19	1,771	0	3,987	4.28
BUSIDX	/dev/rlvbusidx18	12,480	3	4.21	1.17	1,943	1	3,760	3.62
BUSIDX	/dev/rlvbusidx19	12,413	3	4.77	1.10	1,738	0	2,685	4.00
BUSIDX	/dev/rlvbusidx20	13,599	4	4.25	1.07	1,396	0	2,300	3.39
BUSIDX	/dev/rlvbusidx21	12,167	3	4.58	1.07	1,264	0	2,040	3.77
BUSIDX	/dev/rlvbusidx22	12,431	3	4.27	1.08	1,515	0	1,936	3.44
BUSIDX	/dev/rlvbusidx23	13,039	4	3.94	1.06	1,542	0	1,814	3.76
BUSIDX	/dev/rlvbusidx24	11,286	3	4.62	1.05	1,308	0	1,507	4.13
BUSIDX	/dev/rlvbusidx25	13,423	4	4.00	1.10	1,166	0	1,618	4.03
BUSIDX	/dev/rlvbusidx26	12,788	4	4.61	1.10	1,184	0	1,818	3.99
BUSIDX	/dev/rlvbusidx27	12,463	3	4.69	1.10	1,510	0	1,319	4.14
BUSIDX	/dev/rlvbusidx28	12,930	4	4.38	1.09	1,459	0	1,294	3.21
BUSIDX	/dev/rlvbusidx29	13,209	4	4.59	1.08	1,745	0	1,967	2.66
BUSIDX	/dev/rlvbusidx30	13,481	4	4.21	1.09	1,449	0	2,453	2.66
BUSINESS	/dev/rlvbusdata01	217,568	60	2.11	6.47	264	0	71,523	2.31
BUSINESS	/dev/rlvbusdata02	225,655	63	1.97	6.17	386	0	79,636	2.03
BUSINESS	/dev/rlvbusdata03	225,529	63	2.05	6.32	726	0	70,899	2.14
BUSINESS	/dev/rlvbusdata04	225,682	63	2.00	6.47	805	0	69,162	2.01
BUSINESS	/dev/rlvbusdata05	225,687	63	2.06	6.52	666	0	69,568	2.03
BUSINESS	/dev/rlvbusdata06	229,323	64	1.68	6.35	1,707	0	64,013	1.77
BUSINESS	/dev/rlvbusdata07	240,320	67	2.22	6.14	644	0	70,292	2.32
BUSINESS	/dev/rlvbusdata08	234,929	65	1.70	6.13	446	0	71,060	1.70
BUSINESS	/dev/rlvbusdata09	222,940	62	1.67	6.27	621	0	67,249	1.63
BUSINESS	/dev/rlvbusdata10	222,169	62	1.80	6.43	678	0	63,961	1.87
BUSINESS	/dev/rlvbusdata11	245,654	68	1.62	6.06	887	0	68,822	1.67
BUSINESS	/dev/rlvbusdata12	256,782	71	1.75	5.82	536	0	70,435	1.81
BUSINESS	/dev/rlvbusdata13	257,249	71	1.62	5.89	932	0	68,332	1.70
BUSINESS	/dev/rlvbusdata14	276,416	77	1.92	5.55	650	0	82,193	1.92
BUSINESS	/dev/rlvbusdata15	276,572	77	1.56	5.74	786	0	79,930	1.56
BUSINESS	/dev/rlvbusdata16	272,066	75	1.95	5.74	533	0	74,423	2.00
BUSINESS	/dev/rlvbusdata17	265,098	74	1.63	6.03	857	0	70,663	1.71
BUSINESS	/dev/rlvbusdata18	283,328	79	1.67	6.43	654	0	70,821	1.73
BUSINESS	/dev/rlvbusdata19	291,198	81	1.57	6.29	1,038	0	75,448	1.49
BUSINESS	/dev/rlvbusdata20	231,053	64	1.85	6.09	1,234	0	70,620	1.70
BUSINESS	/dev/rlvbusdata21	256,220	71	2.06	5.97	828	0	71,764	1.97
BUSINESS	/dev/rlvbusdata22	247,388	69	2.02	5.75	1,125	0	81,863	1.71
BUSINESS	/dev/rlvbusdata23	257,235	71	2.20	5.68	1,550	0	86,551	1.75
BUSINESS	/dev/rlvbusdata24	220,634	61	2.02	5.32	1,093	0	83,766	1.77
BUSINESS	/dev/rlvbusdata25	230,297	64	1.89	5.56	928	0	80,140	1.68
BUSINESS	/dev/rlvbusdata26	239,007	66	1.97	5.91	1,214	0	84,014	1.74
BUSINESS	/dev/rlvbusdata27	225,934	63	1.80	6.16	938	0	81,775	1.64
BUSINESS	/dev/rlvbusdata28	233,552	65	1.99	6.10	1,476	0	81,078	1.94
BUSINESS	/dev/rlvbusdata29	231,521	64	1.84	5.75	835	0	81,555	1.73
BUSINESS	/dev/rlvbusdata30	224,903	62	1.80	6.25	687	0	80,459	1.82
BUSINESS	/dev/rlvbusdata31	60,568	17	1.48	6.83	587	0	25,108	1.34
BUSINESS	/dev/rlvbusdata32	63,628	18	1.46	6.25	830	0	26,704	1.29
BUSINESS	/dev/rlvbusdata33	59,205	16	1.84	6.86	1,233	0	26,644	1.58
BUSINESS	/dev/rlvbusdata34	51,780	14	1.85	7.75	505	0	10,633	1.95
BUSINESS	/dev/rlvbusdata35	55,879	15	1.50	7.08	231	0	10,693	1.61
BUSINESS	/dev/rlvbusdata36	30,317	8	1.96	11.42	582	0	5,398	2.92
BUSINESS	/dev/rlvbusdata37	31,661	9	2.01	10.95	479	0	4,286	3.14
BUSINESS	/dev/rlvbusdata38	31,891	9	2.57	10.88	514	0	4,497	4.73
BUSINESS	/dev/rlvbusdata39	30,001	8	1.88	11.50	334	0	3,429	3.45
BUSINESS	/dev/rlvbusdata40	31,124	9	2.11	11.12	663	0	3,188	3.93
BUSINESS	/dev/rlvbusdata41	31,914	9	2.00	10.88	410	0	3,748	3.76
BUSINESS	/dev/rlvbusdata42	16,474	5	3.32	7.81	97	0	2,685	4.55
BUSINESS	/dev/rlvbusdata43	9,796	3	3.79	1.86	445	0	2,742	3.30
BUSINESS	/dev/rlvbusdata44	31,279	9	1.63	11.04	248	0	3,311	2.87
BUSINESS	/dev/rlvbusdata45	31,346	9	1.88	11.02	1,050	0	3,228	3.54
BUSINESS	/dev/rlvbusdata46	29,924	8	1.69	11.50	667	0	4,880	2.59
BUSINESS	/dev/rlvbusdata47	23,633	7	1.24	14.29	595	0	477	3.14
BUSINESS	/dev/rlvbusdata48	24,243	7	1.27	13.96	1,495	0	490	2.20
BUSINESS	/dev/rlvbusdata49	23,027	6	1.09	14.64	186	0	541	1.72
BUSINESS	/dev/rlvbusdata50	22,614	6	1.08	14.88	356	0	454	3.35
BUSINESS	/dev/rlvbusdata51	22,570	6	0.96	14.91	173	0	556	1.80
BUSINESS	/dev/rlvbusdata52	22,472	6	1.01	14.97	101	0	533	2.59
BUSINESS	/dev/rlvbusdata53	2,704	1	4.49	2.89	101	0	573	2.64
BUSINESS	/dev/rlvbusdata54	24,243	7	1.16	13.95	134	0	525	2.13
BUSRND	/dev/rlvbusrnd01	671	0	4.19	4.72	4	0	0	0.00
BUSRND	/dev/rlvbusrnd02	604	0	4.80	5.91	2	0	0	0.00
BUSRND	/dev/rlvbusrnd03	36	0	5.00	4.39	16	0	0	0.00
BUSRND	/dev/rlvbusrnd04	20	0	6.00	1.00	1	0	0	0.00
BUSRND	/dev/rlvbusrnd05	5	0	10.00	1.00	1	0	0	0.00
BUSRND	/dev/rlvbusrnd06	28	0	9.29	1.00	1	0	0	0.00
EIES	/dev/rlveiesdata01	2	0	5.00	1.00	2	0	0	0.00
EIES	/dev/rlveiesdata02	2	0	5.00	1.00	1	0	0	0.00
EIESIDX	/dev/rlveiesindx01	2	0	5.00	1.00	1	0	0	0.00
JYDATA	/dev/rlvjydata01	24,252	7	3.81	1.03	703	0	2,598	2.82
JYIDX	/dev/rlvjyindx01	2	0	5.00	1.00	1	0	0	0.00
SYSAUX	/dev/rlvbussysaux01	21,197	6	1.07	1.00	711	0	0	0.00
SYSTEM	/dev/rlvbussystem01	4,680	1	3.61	1.01	220	0	5	80.00
TAB_DXPT	/dev/rlvdxpt01	2	0	5.00	1.00	1	0	0	0.00
TAB_YDCK	/dev/rlvydck01	37	0	3.78	1.08	57	0	0	0.00
TAB_YXXT	/dev/rlvyxxt01	26	0	5.38	1.00	23	0	0	0.00
TEMP	/dev/rlvbustmp01	11,407	3	4.19	6.60	3,735	1	0
TEMP	/dev/rlvbustmp04	181	0	0.99	15.00	181	0	0
UNDOTBS1	/dev/rlvbusundo101	167	0	5.81	1.00	1,544	0	22	0.00
UNDOTBS1	/dev/rlvbusundo102	202	0	4.01	1.00	495	0	5	2.00
UNDOTBS1	/dev/rlvbusundo103	26	0	2.69	1.00	554	0	8	1.25
UNDOTBS2	/dev/rlvbusundo201	1	0	20.00	1.00	1	0	53	0.19
UNDOTBS2	/dev/rlvbusundo202	1	0	20.00	1.00	1	0	52	2.69
USERS	/dev/rlvbususer01	1	0	20.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	2,878,500	91	638,061,716	55,736,407	108,011	0	0	2,635,032
K	61,408	100	82,351,051	221	16	0	0	945

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	1	2560	10894	46200	368640	46200
E	0	5	16734	89167	315062	368640	315062

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	2,400	0.10	287,850	1.55	14,612,725,847
D	4,800	0.20	575,700	1.26	11,939,538,629
D	7,200	0.30	863,550	1.15	10,909,329,795
D	9,600	0.40	1,151,400	1.10	10,407,933,835
D	12,000	0.50	1,439,250	1.07	10,091,644,718
D	14,400	0.60	1,727,100	1.04	9,871,110,217
D	16,800	0.70	2,014,950	1.03	9,697,211,575
D	19,200	0.80	2,302,800	1.01	9,589,755,942
D	21,600	0.90	2,590,650	1.01	9,514,491,824
D	24,000	1.00	2,878,500	1.00	9,454,801,696
D	26,400	1.10	3,166,350	0.99	9,406,106,929
D	28,800	1.20	3,454,200	0.99	9,366,098,219
D	31,200	1.30	3,742,050	0.99	9,332,724,228
D	33,600	1.40	4,029,900	0.98	9,302,015,572
D	36,000	1.50	4,317,750	0.98	9,272,803,195
D	38,400	1.60	4,605,600	0.98	9,238,440,183
D	40,800	1.70	4,893,450	0.97	9,208,289,784
D	43,200	1.80	5,181,300	0.97	9,173,961,678
D	45,600	1.90	5,469,150	0.96	9,103,898,434
D	48,000	2.00	5,757,000	0.93	8,819,013,146
K	48	0.09	5,757	145.08	1,064,631
K	96	0.19	11,514	1.00	7,338
K	144	0.28	17,271	1.00	7,338
K	192	0.38	23,028	1.00	7,338
K	240	0.47	28,785	1.00	7,338
K	288	0.56	34,542	1.00	7,338
K	336	0.66	40,299	1.00	7,338
K	384	0.75	46,056	1.00	7,338
K	432	0.84	51,813	1.00	7,338
K	480	0.94	57,570	1.00	7,338
K	512	1.00	61,408	1.00	7,338
K	528	1.03	63,327	1.00	7,338
K	576	1.13	69,084	1.00	7,338
K	624	1.22	74,841	1.00	7,338
K	672	1.31	80,598	1.00	7,338
K	720	1.41	86,355	1.00	7,338
K	768	1.50	92,112	1.00	7,338
K	816	1.59	97,869	1.00	7,338
K	864	1.69	103,626	1.00	7,338
K	912	1.78	109,383	1.00	7,338
K	960	1.88	115,140	1.00	7,338

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
99.28	102,054	741

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	6,287	1,735	5,864.67	1.47	0.03	100.00	0.00	643,780
E	6,287	1,483	6,545.33	296.86	4.54	100.00	0.00	643,780

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	37,743,324	37,743,324	0
64K	128K	7,392	7,392	0
128K	256K	766	766	0
256K	512K	1,181	1,181	0
512K	1024K	8,712	8,712	0
1M	2M	9,911	9,911	0
2M	4M	1,626	1,626	0
4M	8M	133	133	0
8M	16M	20	20	0
16M	32M	16	14	2
32M	64M	3	3	0
64M	128M	6	6	0
256M	512M	1	1	0
512M	1024M	1	0	1

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
786	0.13	12,322,504.25	1,735,245.76	88.00	33,754
1,572	0.25	12,322,504.25	1,712,451.58	88.00	32,530
3,144	0.50	12,322,504.25	1,377,710.46	90.00	24,355
4,715	0.75	12,322,504.25	1,018,126.48	92.00	18,104
6,287	1.00	12,322,504.25	211,253.94	98.00	6,819
7,544	1.20	12,322,504.25	148,607.50	99.00	0
8,802	1.40	12,322,504.25	139,732.13	99.00	0
10,059	1.60	12,322,504.25	139,732.13	99.00	0
11,317	1.80	12,322,504.25	139,732.13	99.00	0
12,574	2.00	12,322,504.25	139,732.13	99.00	0
18,861	3.00	12,322,504.25	139,732.13	99.00	0
25,148	4.00	12,322,504.25	139,732.13	99.00	0
37,722	6.00	12,322,504.25	139,732.13	99.00	0
50,296	8.00	12,322,504.25	139,732.13	99.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
3,232	0.70	509	112,549	2,025,589	0.83	1,425,841	1.40	866,109,830
3,696	0.80	966	133,621	2,254,440	0.93	1,196,990	1.18	881,337,373
4,160	0.90	1,428	154,290	2,357,930	0.97	1,093,500	1.08	886,121,911
4,624	1.00	1,890	176,846	2,434,322	1.00	1,017,108	1.00	889,296,016
5,088	1.10	2,353	200,335	2,482,218	1.02	969,212	0.95	891,760,829
5,552	1.20	2,816	222,924	2,532,553	1.04	918,877	0.90	893,718,540
6,016	1.30	3,279	245,854	2,591,176	1.06	860,254	0.85	895,738,725
6,480	1.40	3,742	270,914	2,647,289	1.09	804,141	0.79	897,295,038
6,944	1.50	4,205	293,995	2,695,353	1.11	756,077	0.74	898,637,558
7,408	1.60	4,668	317,932	2,752,469	1.13	698,961	0.69	899,883,823
7,872	1.70	5,131	341,272	2,818,291	1.16	633,139	0.62	901,152,401
8,336	1.80	5,594	364,690	2,857,708	1.17	593,722	0.58	902,455,822
8,800	1.90	6,057	389,192	2,893,102	1.19	558,328	0.55	903,646,272
9,264	2.00	6,520	415,771	2,920,526	1.20	530,904	0.52	904,740,721

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	2,633,294	5,235	2
undo block	123	0	1
1st level bmb	2	0	5
segment header	2	0	5
undo header	18	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TM-DML	290,311	290,309	0	1,756	1	0.43
XR-Quiesce / Force Logging (database force logging)	1,201	1,201	0	1,201	1	0.44
CF-Controlfile Transaction	9,466	9,465	1	318	0	1.35
TX-Transaction (index contention)	217	217	0	74	0	3.61
TX-Transaction (row lock contention)	5	5	0	4	0	46.50
PS-PX Process Reservation	169	169	0	102	0	0.46
TT-Tablespace	18,932	18,932	0	75	0	0.47
FB-Format Block	135	135	0	52	0	0.44
WF-AWR Flush	22	22	0	11	0	0.55
TD-KTF map table enqueue (KTF dump entries)	7	7	0	7	0	0.57
WR-LNS archiving log	8	8	0	4	0	0.50
TX-Transaction (allocate ITL entry)	2	2	0	2	0	1.00
US-Undo Segment	5	5	0	2	0	1.00
TX-Transaction	47,730	47,729	0	4	0	0.25
MW-MWIN Schedule	2	2	0	2	0	0.50
SQ-Sequence Cache	261	261	0	1	0	1.00
DR-Distributed Recovery	5	5	0	3	0	0.00
WL-Being Written Redo Log	4	4	0	2	0	0.00
HW-Segment High Water Mark	3,053	3,053	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	17.23	63,392	1,385	30	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
26-Dec 09:07	6,033	17,110	598	30	5,760	0/0	0/0/0/0/0/0
26-Dec 08:57	2,630	10,531	1,385	24	5,760	0/0	0/0/0/0/0/0
26-Dec 08:47	2,185	10,041	783	27	5,760	0/0	0/0/0/0/0/0
26-Dec 08:37	1,158	6,558	1,358	20	5,760	0/0	0/0/0/0/0/0
26-Dec 08:27	772	4,920	756	20	5,760	0/0	0/0/0/0/0/0
26-Dec 08:17	865	6,289	59	19	5,760	0/0	0/0/0/0/0/0
26-Dec 08:07	3,586	7,943	108	18	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,536	0.00		0	0
AWR Alerted Metric Element list	94,859	0.00		0	0
Consistent RBA	46,066	0.00		0	0
FAL request queue	126	0.00		0	0
FAL subheap alocation	126	0.00		0	0
FIB s.o chain latch	136	0.00		0	0
FOB s.o list latch	6,424	0.00		0	0
JS broadcast add buf latch	824	0.00		0	0
JS broadcast drop buf latch	824	0.00		0	0
JS broadcast load blnc latch	721	0.00		0	0
JS queue state obj latch	21,630	0.00		0	0
JS slv state obj latch	43	0.00		0	0
KCL gc element parent latch	105,269,973	0.05	0.03	0	5,008	0.08
KJC message pool free list	6,087,620	0.52	0.00	0	781,222	0.16
KJCT flow control latch	19,214,769	0.32	0.00	0	0
KMG MMAN ready and startup request latch	1,202	0.00		0	0
KSXR large replies	242	0.00		0	0
KTF sga latch	14	0.00		0	1,120	0.00
KWQMN job cache list latch	426	0.00		0	0
KWQP Prop Status	2	0.00		0	0
LGWR NS Write	2,116	0.95	0.00	0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,202	0.00
OS process	297	0.00		0	0
OS process allocation	1,419	0.00		0	0
OS process: request allocation	141	0.00		0	0
PL/SQL warning settings	1,368	0.00		0	0
SGA IO buffer pool latch	2,986,669	0.35	0.02	2	2,986,671	0.36
SQL memory manager latch	1	0.00		0	1,201	0.00
SQL memory manager workarea list latch	209,368	0.00		0	0
Shared B-Tree	130	0.00		0	0
active checkpoint queue latch	26,488	0.12	0.00	0	0
active service list	7,535	0.00		0	3,809	0.00
alert log latch	4	0.00		0	0
archive control	210	0.00		0	0
archive process latch	1,462	0.00		0	0
begin backup scn array	1,628	0.00		0	0
business card	34	0.00		0	0
cache buffer handles	11,121	0.02	0.00	0	0
cache buffers chains	1,452,071,021	2.46	0.02	21	224,527,594	0.01
cache buffers lru chain	375,401	0.36	0.00	0	173,793,950	0.48
cache table scan latch	0			0	3,935,728	1.32
channel handle pool latch	161	0.00		0	0
channel operations parent latch	2,255,169	0.00	0.00	0	0
checkpoint queue latch	1,646,501	0.00	0.00	0	133,311	0.00
client/application info	2,397	0.00		0	0
commit callback allocation	4	0.00		0	0
compile environment latch	225	0.00		0	0
dml lock allocation	560,243	0.01	0.00	0	0
dummy allocation	431	0.00		0	0
enqueue hash chains	4,714,920	0.08	0.00	0	775	0.00
enqueues	3,916,653	0.32	0.00	0	0
error message lists	73	0.00		0	0
event group latch	80	0.00		0	0
file cache latch	1,669	0.00		0	0
gcs opaque info freelist	13,435,373	0.15	0.00	0	0
gcs partitioned table hash	266,342,785	0.00	0.00	0	44,895,412	0.00
gcs remaster request queue	26	0.00		0	0
gcs remastering latch	53,679,575	0.00	18.30	2	0
gcs resource freelist	13,755,896	0.02	0.00	0	4,538,370	0.02
gcs resource hash	133,651,761	0.94	0.00	0	18	0.00
gcs resource scan list	36	0.00		0	0
gcs shadows freelist	6,469,598	0.00	0.00	0	6,515,691	0.00
ges caches resource lists	1,896,946	0.23	0.00	0	1,048,733	0.22
ges deadlock list	420,346	0.01	0.00	0	52	0.00
ges domain table	3,181,891	0.00	0.00	0	0
ges enqueue table freelist	3,333,481	0.00	0.00	0	0
ges group table	4,735,400	0.00	0.00	0	0
ges process hash list	130,935	0.00		0	0
ges process parent latch	6,850,051	0.00	0.00	0	1	0.00
ges process table freelist	141	0.00		0	0
ges resource hash list	5,379,908	0.06	0.00	0	603,936	0.04
ges resource scan list	102	0.00		0	0
ges resource table freelist	1,086,030	0.01	0.00	0	0
ges synchronous data	384	1.56	0.00	0	48,381	0.06
ges timeout list	41,803	0.00		0	44,242	0.00
global KZLD latch for mem in SGA	60	0.00		0	0
global tx hash mapping	776	0.00		0	4	0.00
hash table column usage latch	1,755	0.11	0.00	0	12,481,874	0.00
hash table modification latch	250	0.00		0	0
job workq parent latch	0			0	120	0.00
job_queue_processes parameter latch	120	0.00		0	0
kks stats	4,045,036	0.21	0.01	1	0
kokc descriptor allocation latch	1,126	0.53	0.50	0	0
ksuosstats global area	242	0.00		0	0
ktm global data	38	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	46,176	0.02	0.00	0	0
library cache	24,211,858	0.12	0.01	1	3,567,378	0.22
library cache load lock	26,584	0.00		0	0
library cache lock	10,151,126	0.01	0.00	0	0
library cache lock allocation	52,105	0.00		0	0
library cache pin	5,518,889	0.01	0.00	0	0
library cache pin allocation	27,345	0.00		0	0
list of block allocation	6,810	0.00		0	0
loader state object freelist	4,264	0.00		0	0
logminer context allocation	1	0.00		0	0
longop free list parent	284	0.00		0	286	0.00
message pool operations parent latch	1,112	0.00		0	0
messages	669,053	0.04	0.00	0	0
mostly latch-free SCN	48,345	3.44	0.00	0	0
multiblock read objects	11,577,503	0.24	0.00	0	0
name-service memory objects	28,032	0.00		0	0
name-service namespace bucket	45,406	0.00		0	0
name-service pending queue	12,580	0.00		0	0
name-service request queue	52,033	0.00		0	0
ncodef allocation latch	96	0.00		0	0
object queue header heap	263,458	0.00		0	23,484	0.00
object queue header operation	128,431,931	0.06	1.16	89	0
object stats modification	2	0.00		0	1	0.00
parallel query alloc buffer	1,316	0.00		0	0
parallel query stats	136	0.00		0	0
parallel txn reco latch	11,455	0.00		0	0
parameter list	263	0.00		0	0
parameter table allocation management	432	0.00		0	0
post/wait queue	118,305	0.00	0.00	0	41,825	0.01
process allocation	31,163	0.00		0	80	0.00
process group creation	141	0.00		0	0
process queue	361	0.00		0	0
process queue reference	6,896	0.01	0.00	0	656	0.00
qmn task queue latch	775	16.26	0.00	0	0
query server freelists	277	0.00		0	0
queued dump request	17,133	0.00		0	0
redo allocation	232,036	0.02	0.00	0	542,418	0.06
redo copy	0			0	542,557	0.05
redo writing	168,105	0.02	0.00	0	0
resmgr group change latch	553	0.00		0	0
resmgr:active threads	424	0.00		0	0
resmgr:actses change group	206	0.00		0	0
resmgr:free threads list	423	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	161,553,533	1.85	0.00	0	47,980	2.74
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	104	0.00		0	0
sequence cache	29,497	0.00	0.00	0	0
session allocation	983,710	0.03	0.00	0	0
session idle bit	24,390,856	0.00	0.00	0	0
session state list latch	595	0.00		0	0
session switching	96	0.00		0	0
session timer	1,301	0.00		0	0
shared pool	37,883,448	0.41	0.02	21	0
shared pool simulator	40,739,949	0.04	0.05	9	0
simulator hash latch	46,895,213	0.00	0.00	0	0
simulator lru latch	0			0	38,085,302	3.51
slave class	4	0.00		0	0
slave class create	16	6.25	1.00	0	0
sort extent pool	603	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	672	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	479	0.00		0	0
transaction allocation	373	0.00		0	0
transaction branch allocation	2,064	0.00		0	0
undo global data	263,882	0.03	0.00	0	0
user lock	577	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,452,071,021	35,710,541	685,821	35,103,739
row cache objects	161,553,533	2,983,186	40	2,983,146
gcs resource hash	133,651,761	1,250,343	18	1,250,327
shared pool	37,883,448	155,708	3,110	152,678
object queue header operation	128,431,931	71,118	82,410	10,075
KCL gc element parent latch	105,269,973	55,155	1,806	53,603
library cache	24,211,858	29,394	182	29,213
shared pool simulator	40,739,949	17,293	899	16,403
SGA IO buffer pool latch	2,986,669	10,546	201	10,364
kks stats	4,045,036	8,469	126	8,343
session idle bit	24,390,856	499	2	497
gcs remastering latch	53,679,575	158	2,892	37
kokc descriptor allocation latch	1,126	6	3	3
slave class create	16	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
KCL gc element parent latch	kclplz	1,143	73
KCL gc element parent latch	kclzcl	720	75
KCL gc element parent latch	kclliter	713	9
KCL gc element parent latch	kclnfndnewm	480	881
KCL gc element parent latch	kclnfnd	232	21
KCL gc element parent latch	kclulb	50	1,049
KCL gc element parent latch	KCLUNLNK	13	1,051
KCL gc element parent latch	kclfwrite1	8	3
KCL gc element parent latch	kclprm	8	122
KCL gc element parent latch	kclbla	7	0
KCL gc element parent latch	kclgcr	5	1
KCL gc element parent latch	kclrwrite	3	2
KCL gc element parent latch	kclwrt	2	0
KCL gc element parent latch	kclclose	1	1
KCL gc element parent latch	kclgrantlk	1	39
KCL gc element parent latch	kclhngcbk1	1	0
SGA IO buffer pool latch	ksfd_free_sgabuffer	134	201
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	67	0
cache buffers chains	kclcls_3	580,895	2,219
cache buffers chains	kcbgtcr: kslbegin excl	536,196	809,232
cache buffers chains	kcbgtcr: kslbegin shared	36,021	27,718
cache buffers chains	kcbrls: kslbegin	26,818	30,696
cache buffers chains	kcbgtcr: fast path	17,678	43,779
cache buffers chains	kcbzwb	6,836	289,507
cache buffers chains	kcbchg: kslbegin: bufs not pinned	675	369
cache buffers chains	kclobj_1	291	0
cache buffers chains	kcbzib: multi-block read: nowait	160	0
cache buffers chains	kclexpand	119	37
cache buffers chains	kcbzib: finish free bufs	59	386
cache buffers chains	kcbgtcr	50	49
cache buffers chains	kcbzgb: scan from tail. nowait	39	0
cache buffers chains	kclobj	25	0
cache buffers chains	kclgrantlk	22	0
cache buffers chains	kcbget: pin buffer	19	6
cache buffers chains	kclwrt	10	0
cache buffers chains	kcbchg: kslbegin: call CR func	6	208
cache buffers chains	kcbgcur: kslbegin	3	1
cache buffers chains	kclgrantlk_1	2	9
cache buffers chains	kcbzpnd: dump buffers	1	0
cache buffers chains	kclgrantlk_2	1	7
cache buffers chains	kclwcrs	1	0
gcs remastering latch	59	2,827	0
gcs remastering latch	43	61	0
gcs remastering latch	69	7	0
gcs resource hash	kjblocalfile_nolock	10	7
gcs resource hash	kjbrdrmcvtq_98	3	2
gcs resource hash	kjbmpopen	2	1
gcs resource hash	kjbopen:affinity	2	2
gcs resource hash	kclzcl	1	2
kks stats	kks stats alloc/free	126	126
kokc descriptor allocation latch	kokcdlt: allocation	3	3
library cache	kglpndl: child: after processing	44	0
library cache	kgldti: 2child	19	3
library cache	kglhdgn: child:	15	69
library cache	kglobpn: child:	13	54
library cache	kglukp: child	10	14
library cache	kglati	4	0
library cache	kgldte: child 0	4	15
library cache	kglpin	2	2
library cache	kglpndl: child: before processing	1	8
library cache lock	kgllkdl: child: no lock handle	28	13
object queue header operation	kclobj_1	81,295	53,129
object queue header operation	kclobj_3	3,082	1,495
object queue header operation	kclobj_2	134	125
object queue header operation	kcbw_unlink_q	102	26,427
object queue header operation	kcbw_link_q	36	3,433
object queue header operation	kcbo_switch_mq_bg	1	10
row cache objects	kqreqd: reget	16	1
row cache objects	kqrpre: find obj	5	35
row cache objects	kqreqd	3	1
row cache objects	kqrso	3	2
session idle bit	ksupuc: clear busy	4	4
shared pool	kghupr1	1,408	1,064
shared pool	kghalo	1,276	1,389
shared pool	kghfre	216	458
shared pool	kghfrunp: alloc: wait	114	1
shared pool	kghalp	84	157
shared pool	kghfrunp: clatch: nowait	47	0
shared pool	kghasp	12	40
shared pool	kghfrunp: clatch: wait	8	3
shared pool simulator	kglsim_unpin_simhp	739	101
shared pool simulator	kglsim_scan_lru: scan	90	454
shared pool simulator	kglsim_unpin_simhp: fast path	47	238
shared pool simulator	kglsim_upd_newhp	19	95
shared pool simulator	kglsim_chg_simhp_free	3	5
shared pool simulator	kglsim_chg_simhp_noob	1	6
slave class create	ksvcreate	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

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 721,063,085
Captured Segments account for 94.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
BUSINESS	BUSIDX	IDX_PRPDCOMPANY_UPPERCOMCODE	INDEX	113,054,560	15.68
BUSINESS	BUSINESS	PRPDCOMPANY	TABLE	79,153,344	10.98
BUSINESS	BUSINESS	ACCMAINVOUCHER	TABLE	65,534,352	9.09
BUSINESS	BUSIDX	PK_LCOMPENSATE	INDEX	65,073,616	9.02
BUSINESS	BUSIDX	IND_ALIAS_BY_VEHICLE_ID	INDEX	50,674,432	7.03

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 55,825,738
Captured Segments account for 92.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
BUSINESS	BUSINESS	PRPEBAOXML	TABLE	33,265,834	59.59
BUSINESS	BUSINESS	PRPCMAIN	TABLE	4,132,703	7.40
BUSINESS	BUSINESS	VSMARK	TABLE	3,404,871	6.10
ACCBIZ	ACCBIZ	MIDGRMAIN	TABLE	2,788,891	5.00
BUSINESS	BUSINESS	SWFLOG	TABLE	2,296,342	4.11

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
BUSINESS	BUSIDX	PK_TMAIN	INDEX	290	35.41
BUSINESS	BUSINESS	PK_PRPDCUSTOMERRISKLEVEL	INDEX	146	17.83
BUSINESS	BUSIDX	PK_PRPTDANGERUNIT	INDEX	83	10.13
BUSINESS	BUSINESS	PK_CIPLATLOG	INDEX	62	7.57
BUSINESS	BUSIDX	PK_CMAIN	INDEX	59	7.20

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

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
BUSINESS	BUSINESS	PK_CIPLATLOG		INDEX	111	99.11
BUSINESS	BUSINESS	INDEX_CIPLATLOG		INDEX	1	0.89

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

% of Capture shows % of GC Buffer Busy for each top segment compared
with GC Buffer Busy for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	GC Buffer Busy	% of Capture
BUSINESS	BUSINESS	SWFLOG	TABLE	669,072	34.05
BUSINESS	BUSINESS	PRPJPAYREFREC	TABLE	470,983	23.97
DBWEBINS	ACCBIZ	T_CARD_BASE	TABLE	122,939	6.26
BUSINESS	BUSINESS	ACCMAINVOUCHER	TABLE	118,301	6.02
BUSINESS	BUSINESS	PRPCCARSHIPTAXORIGIN	TABLE	112,953	5.75

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Total CR Blocks Received: 41,698
Captured Segments account for 42.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	CR Blocks Received	%Total
BUSINESS	BUSINESS	PRPDUSER	TABLE	7,179	17.22
BUSINESS	BUSINESS	SWFLOG	TABLE	3,804	9.12
BUSINESS	BUSINESS	WFLOG	TABLE	998	2.39
BUSINESS	BUSINESS	PRPCMAIN	TABLE	489	1.17
BUSINESS	BUSINESS	PRPJPAYREFREC	TABLE	447	1.07

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Total Current Blocks Received: 7,462,331
Captured Segments account for 98.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Current Blocks Received	%Total
BUSINESS	BUSINESS	SWFLOG	TABLE	2,609,998	34.98
DBWEBINS	ACCBIZ	T_CARD_BASE	TABLE	1,895,607	25.40
BUSINESS	BUSINESS	PRPCMAIN	TABLE	1,589,414	21.30
BUSINESS	BUSIDX	IDX_PRPCINSURED_POLICYNO	INDEX	232,762	3.12
BUSINESS	BUSINESS	PRPLCLAIM	TABLE	224,298	3.01

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Dictionary Cache Stats
Dictionary Cache Stats (RAC)

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	68	0.00	2	1
dc_database_links	336	2.68	0	1
dc_files	111	100.00	0	0
dc_global_oids	2,126	3.72	0	24
dc_histogram_data	37,482,192	0.06	0	13,908
dc_histogram_defs	13,096,963	0.21	0	8,831
dc_object_grants	188	27.13	0	10
dc_object_ids	19,442,740	0.02	0	1,727
dc_objects	956,792	0.30	0	921
dc_profiles	120	0.83	0	1
dc_rollback_segments	24,752	0.00	0	883
dc_segments	5,148,487	0.08	4	1,841
dc_sequences	9,857	4.09	9,857	9
dc_tablespaces	801,832	0.01	0	17
dc_usernames	16,027	0.43	0	19
dc_users	1,713,048	0.00	0	35
outstanding_alerts	212	92.45	2	0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache	GES Requests	GES Conflicts	GES Releases
dc_awr_control	4	0	0
dc_database_links	9	0	9
dc_files	111	0	111
dc_global_oids	79	0	85
dc_histogram_defs	27,792	0	25,895
dc_object_ids	4,621	0	3,564
dc_objects	3,056	0	2,769
dc_profiles	1	0	1
dc_segments	4,207	7	3,738
dc_sequences	19,179	346	56
dc_tablespaces	76	0	76
dc_usernames	69	0	65
dc_users	62	0	59
outstanding_alerts	418	120	80

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Library Cache Activity
Library Cache Activity (RAC)

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,354	0.81	3,058	2.88	73	0
CLUSTER	186	0.54	364	2.75	9	0
INDEX	16	81.25	57	22.81	0	0
SQL AREA	1,989,081	64.81	4,302,798	56.31	228,445	5,890
TABLE/PROCEDURE	356,611	0.14	3,134,748	0.42	8,317	0
TRIGGER	657	1.22	1,042	1.63	9	0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases	GES Inval Requests
CLUSTER	364	1	0	1
INDEX	57	13	5	13
TABLE/PROCEDURE	1,258,194	394	569	313

Back to Library Cache Statistics
Back to Top

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	4,870.20		4.11	13.19	407	407	1,185	1,185
	Freeable	546.94	0.00	1.27	1.00	9		432	432
	SQL	435.19	222.01	0.38	1.09	8	741	1,145	1,038
	PL/SQL	12.75	8.86	0.01	0.02	1	1	1,185	1,185
E	Other	5,219.91		4.34	13.15	407	407	1,204	1,204
	SQL	742.21	524.49	0.64	7.00	233	741	1,164	1,059
	Freeable	569.31	0.00	1.18	0.96	9		484	484
	PL/SQL	14.49	10.26	0.01	0.02	1	1	1,204	1,204

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	25,702,694,912
Fixed Size	2,147,144
Redo Buffers	48,181,248
Variable Size	8,606,715,064

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	112.00	112.00	0.00
large	free memory	512.00	512.00	0.00
shared	ASH buffers	68.00	68.00	0.00
shared	CCursor	715.46	669.99	-6.36
shared	Cursor Stats	75.52	75.52	0.00
shared	PCursor	374.75	348.16	-7.10
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	free memory	309.48	398.23	28.68
shared	gcs resources	550.79	550.79	0.00
shared	gcs shadows	308.22	308.22	0.00
shared	kglsim heap	55.73	55.73	0.00
shared	kglsim object batch	104.61	104.61	0.00
shared	library cache	507.94	479.12	-5.68
shared	sql area	982.27	985.19	0.30
streams	free memory	15.99	15.99	0.00
	buffer_cache	24,512.00	24,512.00	0.00
	fixed_sga	2.05	2.05	0.00
	log_buffer	45.95	45.95	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	62,142	0	0
QMON Slaves	52,407	0	0

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

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	2	0	0	13	54

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
gcs_resources	1,234,960	3,199,663	3330915	3330915
gcs_shadows	1,414,420	3,246,761	3330915	3330915
sessions	1,232	1,802	2205	2205

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/busdb/adump
background_dump_dest	/oracle/admin/busdb/bdump
cluster_database	TRUE
cluster_database_instances	2
compatible	10.2.0.3.0
control_files	/dev/rlvbusctl01, /dev/rlvbusctl02, /dev/rlvbusctl03
core_dump_dest	/oracle/admin/busdb/cdump
cursor_sharing	EXACT
cursor_space_for_time	TRUE
db_block_size	8192
db_cache_size	25165824000
db_domain
db_file_multiblock_read_count	16
db_keep_cache_size	536870912
db_name	busdb
db_writer_processes	8
dml_locks	9700
fal_client	BUSDB1
fal_server	p_stdby
instance_number	1
java_pool_size	117440512
job_queue_processes	10
large_pool_size	536870912
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.129.12)(PORT=1521))
log_archive_config	DG_CONFIG=(busdb, p_stdby, p2_stdby)
log_archive_dest_1	location=/arch/busdb/archlog1
log_archive_dest_2	SERVICE=p_stdby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=p_stdby
log_archive_dest_3	SERVICE=p2_stdby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=p2_stdby
log_archive_dest_state_2	enable
log_archive_dest_state_3	enable
log_archive_max_processes	6
nls_date_format	yyyy-mm-dd
open_cursors	1200
optimizer_index_caching	0
pga_aggregate_target	6592397312
processes	2000
remote_listener	LISTENERS_BUSDB
remote_login_passwordfile	EXCLUSIVE
service_names	busdb
session_cached_cursors	1000
sessions	2205
sga_max_size	34359738368
sga_target	0
shared_pool_size	4831838208
spfile	/dev/rlvbusspfile
standby_file_management	AUTO
streams_pool_size	16777216
thread	1
transactions	2425
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/busdb/udump

Global Enqueue Statistics

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	10,035	2.78	0.25
acks for commit broadcast(logical)	14,706	4.08	0.37
broadcast msgs on commit(actual)	46,251	12.82	1.16
broadcast msgs on commit(logical)	46,267	12.83	1.16
broadcast msgs on commit(wasted)	9,148	2.54	0.23
broadcast on commit wait time(ms)	8,100	2.25	0.20
broadcast on commit waits	41,150	11.41	1.03
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	2	0.00	0.00
flow control messages received	3	0.00	0.00
flow control messages sent	1,569	0.44	0.04
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	1,863,806	516.78	46.60
gcs ast xid	0	0.00	0.00
gcs blocked converts	23,585	6.54	0.59
gcs blocked cr converts	52,051	14.43	1.30
gcs compatible basts	3,384	0.94	0.08
gcs compatible cr basts (global)	5,936	1.65	0.15
gcs compatible cr basts (local)	6,691,717	1,855.43	167.30
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	6,156	1.71	0.15
gcs dbwr write request msgs	5,225	1.45	0.13
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	7,871	2.18	0.20
gcs immediate (null) converts	1,468,844	407.27	36.72
gcs immediate cr (compatible) converts	94,798	26.28	2.37
gcs immediate cr (null) converts	6,830,026	1,893.77	170.75
gcs indirect ast	302,007	83.74	7.55
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	1,355	0.38	0.03
gcs msgs process time(ms)	510,308	141.49	12.76
gcs msgs received	20,864,498	5,785.14	521.63
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	94,995	26.34	2.37
gcs pkey conflicts retry	0	0.00	0.00
gcs queued converts	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	7	0.00	0.00
gcs side channel msgs actual	141,287	39.17	3.53
gcs side channel msgs logical	8,427,900	2,336.82	210.70
gcs stale cr	27,662	7.67	0.69
gcs undo cr	417	0.12	0.01
gcs write notification msgs	670	0.19	0.02
gcs writes refused	14	0.00	0.00
ges msgs process time(ms)	3,527	0.98	0.09
ges msgs received	391,657	108.60	9.79
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	2	0.00	0.00
global posts requested	2	0.00	0.00
global posts sent	2	0.00	0.00
implicit batch messages received	1,126,451	312.33	28.16
implicit batch messages sent	1,484,435	411.59	37.11
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	118,488	32.85	2.96
messages queue sent actual	2,598,708	720.55	64.97
messages queue sent logical	11,313,291	3,136.86	282.84
messages received actual	5,506,336	1,526.75	137.66
messages received logical	21,256,419	5,893.81	531.42
messages sent directly	2,147,658	595.49	53.69
messages sent indirectly	10,431,851	2,892.46	260.80
messages sent not implicit batched	1,114,458	309.01	27.86
messages sent pbatched	17,983,917	4,986.44	449.61
msgs causing lmd to send msgs	77,810	21.57	1.95
msgs causing lms(s) to send msgs	469,388	130.15	11.73
msgs received queue time (ms)	300,400	83.29	7.51
msgs received queued	21,254,831	5,893.37	531.38
msgs sent queue time (ms)	3,059,793	848.39	76.50
msgs sent queue time on ksxp (ms)	2,745,096	761.14	68.63
msgs sent queued	10,603,377	2,940.02	265.09
msgs sent queued on ksxp	6,917,212	1,917.95	172.93
process batch messages received	2,009,321	557.13	50.23
process batch messages sent	2,526,597	700.55	63.17

Global CR Served Stats

Statistic	Total
CR Block Requests	49,000
CURRENT Block Requests	1,511
Data Block Requests	49,000
Undo Block Requests	417
TX Block Requests	347
Current Results	48,814
Private results	1
Zero Results	986
Disk Read Results	33
Fail Results	3
Fairness Down Converts	9,463
Fairness Clears	0
Free GC Elements	0
Flushes	132
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	799
Errors	0

Global CURRENT Served Stats

Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	3,402,323	100.00	0.00	0.00	0.00	0.00
Flushes	40	92.50	7.50	0.00	0.00	0.00
Writes	8,302	49.07	49.21	0.29	0.60	0.83

Global Cache Transfer Stats

Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
ordered by CR + Current Blocks Received desc

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	40,608	99.59	0.36	0.05	7,461,955	99.26	0.00	0.74
2	Others	676	99.26	0.74	0.00	2,155	99.91	0.05	0.05
2	undo header	431	99.54	0.23	0.23	34	100.00	0.00	0.00
2	undo block	84	97.62	2.38	0.00	0

End of Report

% Blocks changed per Read:	0.13	Recursive Call %:	27.80
Rollback per transaction %:	23.67	Rows per Sort:	8.79

Buffer Nowait %:	99.63	Redo NoWait %:	99.99
Buffer Hit %:	92.27	In-memory Sort %:	100.00
Library Hit %:	67.26	Soft Parse %:	66.84
Execute to Parse %:	64.78	Latch Hit %:	98.45
Parse CPU to Parse Elapsd %:	19.19	% Non-Parse CPU:	96.66

Buffer access - local cache %:	91.23
Buffer access - remote cache %:	1.04
Buffer access - disk %:	7.73

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.8
Avg global cache current block receive time (ms):	1.0
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.3
Avg global cache cr block flush time (ms):	0.7
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.0
Avg global cache current block flush time (ms):	0.3

Avg message sent queue time (ms):	0.3
Avg message sent queue time on ksxp (ms):	0.4
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:	16.91
% of indirect sent messages:	82.15
% of flow controlled messages:	0.93